Simulate the following inventory replenishment problem for 20 weeks. You will have to use the Excel program to simulate. Demand is uniformly distributed between 20 and 30 units. Additional Data are given below.

Inventory Cost/Week = $ 1.00

Shortage Cost/Week = $ 2.00

Lead Time = 2 weeks

Beginning Stock on Hand (SOH) = 0

Supply in Week 1 = 21 units

Supply in Week 2 = 22 units

If the order size is equal to the demand in every week, how many units are delivered in week 10?

The demand for the next 20 weeks is given below.

Week	1	2	3	4	5	6	7	8	9	10
Demand	21	22	30	21	27	28	23	29	21	25
Week	11	12	13	14	15	16	17	18	19	20
Demand	22	28	28	29	27	26	24	27	23	21

Group of answer choices

20

24

29

30

None of the above