The annual demand for a product is 16,400 units. The weekly demand is 315 units with a standard deviation of 90 units. The cost to place an order is $31.00, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.20 per unit. a. Find the reorder point necessary to provide a 95 percent service probability. (Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places.) b. Suppose the production manager is asked to reduce the safety stock of this item by 55 percent. If she does so, what will the new service probability be? (Use Excel's NORM.S.DIST() 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.)
The annual demand for a product is 16,400 units. The weekly demand is 315 units with a standard deviation of 90 units. The cost to place an order is $31.00, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.20 per unit.
a. Find the reorder point necessary to provide a 95 percent service
b. Suppose the production manager is asked to reduce the safety stock of this item by 55 percent. If she does so, what will the new service probability be? (Use Excel's NORM.S.DIST() 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.)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images