Help Please Annual demand for a product is 10,400 units; weekly demand is 200 un
ID: 455992 • Letter: H
Question
Help Please
Annual demand for a product is 10,400 units; weekly demand is 200 units with a standard deviation of 75 units. The cost of placing an order is $100, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.50 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 -level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)
b) Suppose the production manager is told to reduce the safety stock of this item by 110 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.)
Annual demand for a product is 10,400 units; weekly demand is 200 units with a standard deviation of 75 units. The cost of placing an order is $100, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.50 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 -level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)
b) Suppose the production manager is told to reduce the safety stock of this item by 110 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.)
Explanation / Answer
Given Information :
S = Annual demand for a product =10,400 units;
Weekly demand is 200 units
Standard deviation of 75 units.
Cp = The cost of placing an order is $100,
Lead time = Four Weeks
i = The annual inventory carrying cost is $0.50 per unit.
Service = 98%
Reorder Point = Safety Stock + Lead time consumption
= (Z* S.D.*Square root of of Lead time) +(Lead time * Weekly requirement)
=(2.33 * 75 * Square root 4) + (4 * 200 )
=349.5 + 800
=1150
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Safety Stock = (Z* S.D.*Square root of of Lead time)
350 - 110 = Z * 75 * Square root 4
240/(75*2) = Z
Z = 1.6
For value of Z = 1.6
The service probability is 90 %
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.