Question: Simulate the following inventary replenishment problem for 20 weeks. You will have to use the Excel program to simulate. Demand is uniformly distributed between 20

Simulate the following inventary replenishment problem for 20 weeks. You will have to use the Excel program to simulate. Demand is uniformly distributed between 20 and 30 urits. Additional Data are given below. Inventary Cost/Week - $1.00 Shortage Cost/Week $2.00 Leod Time -2 weeks Beginning Stack on Hand [SOH]0 Supply in Week 1 - 21 units Supply in Week 2 - 22 units What is the total inventory cost at the end of 20 weeks if the order size in every week is 20 units? The demand for the neat 20 weeks is given belaw. $0.00 $20.00 $40.00 $1,980 None of the above
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
