A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .95. The order interval is 14 days, and lead time is 2 days. Average demand for one item is 65 units per day, and the standard deviation of demand is 3 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table. On Hand TT Cycle 1 40 2 12 3 95 Click here for the Excel Data File Determine the order quantities for cycles 1, 2, and 3: (Round your answers to the nearest whole number.) Cycle Units 1 2 3

A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .95. The order interval is 14 days, and lead time is 2 days. Average demand for one item is 65 units per day, and the standard deviation of demand is 3 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table. On Hand TT Cycle 1 40 2 12 3 95 Click here for the Excel Data File Determine the order quantities for cycles 1, 2, and 3: (Round your answers to the nearest whole number.) Cycle Units 1 2 3

Name: A drugstore uses fixed-order cycles for many of the items it stocks.
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .95. The order interval is 14days, and lead time is 2 days. Average demand for one item is 65 units per day, and the standard deviation of dema

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
Petromax Enterprises uses a continuous review policy to manage the inventory for one of its SKUs. The following information is available on the item. The firm operates 50 weeks in a year. Demand = 90,000 units/year Ordering Cost = $60/Order Holding Cost = $3/Unit/Order Lead Time = 10 weeks Standard Deviation of Weekly Demand = 200 units Suppose due to some recent changes to the target service level, they have determined the reorder point to be 20,000. If the inventory position of this SKU is currently 19,600, how many units should they order? (Round your answer to the nearest whole number, if it has decimals. Input 0 if they should not order now.)
Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand = 36 units per day Average lead time = 50 days Item unit cost = $70 for orders of less than 400 units Item unit cost = $68 for orders of 400 units or more Ordering cost = $45 Inventory carrying cost = 25% The business year is 250 days Assume there is no uncertainty at all about the demand or the lead time. Calculate EOQ if unit cost is $70 and $68. (Note: These EOQs do not need to be feasible in theirprice range.) (Round up your answers to the next whole number.) EOQ Unit cost at $70 units Unit cost at $68 units Calculate annual ordering costs for each alternative? (For the first value, use your rounded EOQ from Part a. For the second value, use the lowest feasible order quantity needed to qualify for that price level. Round your answers to 2 decimal places.) Annual Ordering Cost Unit cost at $70 Unit…
The annual demand for a product is 15,200 units. The weekly demand is 292 units with a standard deviation of 80 units. The cost to place an order is $33.50, and the time from ordering to receipt is two weeks. The annual inventory carrying cost is $0.10 per unit. a. Find the reorder point necessary to provide a 90 percent service probability. (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Round "z" value to 2 decimal places.)\ b. Suppose the production manager is asked to reduce the safety stock of this item by 45 percent. If she does so, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round "z" value to 2 decimal places and final answer to 1 decimal place.)
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a servicelevel of .98. The order interval is 14 days, and lead time is 2 days. Average demand for one itemis 40 units per day, and the standard deviation of demand is 3 units per day. Given the on-handinventory at the reorder time for each order cycle shown in the following table, determine theorder quantities for cycles 1, 2, and 3.Cycle On Hand1 422 83 103
ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average of 500 boxes but maysometimes sell a maximum of 600 boxes. The supplier takes an average of 5 days to deliver the order. During busier times, thesupplier may take 7 days.Based on ABC’s records, ordering cost average P400 per order. Storage cost per box average P5 per year. There is also anopportunity cost of 1% per year for every peso invested in inventories. Each box of candles costs P450. If ABC would continue its current inventory management policy, it would keep 10,000 boxes as safety stock and order ten-days-worth of inventory. (C) Reorder Point and Economic Order Quantity19. What would the average number of boxes be if the safety stock from Part A was kept and the EOQ from Part Bwas followed? Round off to two decimal places.20. How much would the carrying cost for the year be based on item 19?21. How much would the total inventory related (ordering plus carrying) costs be if the…
ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average of 500 boxes but maysometimes sell a maximum of 600 boxes. The supplier takes an average of 5 days to deliver the order. During busier times, thesupplier may take 7 days.Based on ABC’s records, ordering cost average P400 per order. Storage cost per box average P5 per year. There is also anopportunity cost of 1% per year for every peso invested in inventories. Each box of candles costs P450. If ABC would continue its current inventory management policy, it would keep 10,000 boxes as safety stock and order ten-days-worth of inventory. (B) Economic Order Quantity 1. How much would the total inventory related (ordering plus carrying) costs be if the economic order quantity wasfollowed (excluding safety stock)? (D) Cost-Benefit Analysis: If ABC maintains its current inventory policy for the year,1. How much would the entity save it followed the reorder point and economic order quantity models?…
ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average of 500 boxes but maysometimes sell a maximum of 600 boxes. The supplier takes an average of 5 days to deliver the order. During busier times, thesupplier may take 7 days.Based on ABC’s records, ordering cost average P400 per order. Storage cost per box average P5 per year. There is also anopportunity cost of 1% per year for every peso invested in inventories. Each box of candles costs P450. If ABC would continue its current inventory management policy, it would keep 10,000 boxes as safety stock and order ten-days-worth of inventory. 18. Explain what would happen to the ordering cost, carrying cost and total inventory-related costs if the entity doesnot follow the economic order quantity based on the previous numbers
Sam's Pet Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag. The following information is available about these bags: ≻Demand=75 bags/week ≻Order cost=$55.00/order ≻Annual holding cost=25 percent of cost ≻Desired cycle-service level=80 percent ≻Lead time=4 weeks (24 working days) ≻Standard deviation of weekly demand=15 bags ≻Current on-hand inventory is 320 bags, with no open orders or backorders. Part 2 a. Suppose that the weekly demand forecast of 75 bags is incorrect and actual demand averages only 50 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $enter your response here higher owing to the error in EOQ. (Enter your response rounded to two decimal places.) a. What is the EOQ? What would the average time between orders (in weeks)? b. What should R be? c. An inventory withdraw…
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .99. The order interval is 12 days, and lead time is 4 days. Average demand for one item is 63 units per day, and the standard deviation of demand is 6 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table. Cycle On Hand 1 38 2 10 3 93 Determine the order quantities for cycles 1, 2, and 3: (Round your answers to the nearest whole number) Cycle Units 1 1019 Numeric ResponseEdit Unavailable. 1019 incorrect. 2 1047 Numeric ResponseEdit Unavailable. 1047 incorrect. 3 964 Numeric ResponseEdit Unavailable. 964 incorrect.
It takes approximately 2 weeks (14 days) for an order ofsteel bolts to arrive once the order has been placed. The demandfor bolts is fa irly constant; on the average, the manager, MichelleWu, has observed that the hardware store sells 500 of these boltseach day. Because the demand is fairly constant, Michelle believesthat she can avoid stockouts completely if she orders the bolts atthe correct time. What is the reorder poin t?
A local service station is open 7 days per week, 365 days per year. Sales of 10W40 grade premium oil average 20 cans per day. Inventory holding costs are $0.50 per can per year. Ordering costs are $10 per order. The lead time is two weeks. Backorders are not practical— the motorist drives away.a. Based on these data, choose the appropriate inventory model and calculate the economic order quantity and reorder point. Describe in a sentence how the plan would work. Hint: Assume demand is deterministic.b. The boss is concerned about this model because the demand really varies. The standarddeviation of demand was determined from a data sample to be 6.15 cans per day. Themanager wants a 99.5 percent service probability. Determine a new inventory planbased on this information and the data in part (a). Use Qopt from part (a).