Annual demand for a product is 9,100 units; weekly demand is 200 units with a standard...

Transcribed Image Text:

Annual demand for a product is 9,100 units; weekly demand is 200 units with a standard deviation of 50 units. The cost of placing an order is $75, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.75 per unit. a. To provide a 98 percent service probability, what must the reorder point be? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Reorder point units b. Suppose the production manager is told to reduce the safety stock of this item by 80 units. If this is done, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round your answer to the nearest whole number.) Service probability % Annual demand for a product is 9,100 units; weekly demand is 200 units with a standard deviation of 50 units. The cost of placing an order is $75, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.75 per unit. a. To provide a 98 percent service probability, what must the reorder point be? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Reorder point units b. Suppose the production manager is told to reduce the safety stock of this item by 80 units. If this is done, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round your answer to the nearest whole number.) Service probability %

Answer rating: 100% (QA)

a To calculate the reorder point for a 98 percent service probability we need to use the formula Reo... View the full answer