Question: Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. Item cost $ 12.00 Standard deviation of weekly
Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year.
| Item cost | $ | 12.00 | Standard deviation of weekly demand | 20 | units | |
| Order cost | $ | 250.00 | /order | Lead time | 1 | week |
| Annual holding cost (%) | 20 | % of item cost | Service probability | 90 | % | |
| Annual demand | 22,700 | units | ||||
| Average demand | 454 | /week | ||||
a. Determine the order quantity and reorder point. (Use Excels NORMSINV( ) function to find your z-value and then round that z-value to 2 decimal places. Do not round any other intermediate calculations. Round your final answers to the nearest whole number.)
Optimal Order quantity:
Reorder points:
b. Determine the annual holding and order costs. (Do not round any intermediate calculations. Round your final answers to 2 decimal places.)
Holding Cost:
Ordering cost:
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
