Question: 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

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

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 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

$ 0.00

$ 20.00

$ 40.00

$ 1,980

None of the above

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

A firm faces the following demand and total cost schedules, with all quantities listed on a per-month basis. Suppose that it is required to produce a whole number of items each month. a. How much...

Q:

An insurance company has the business objective of reducing the amount of time it takes to approve applications for life insurance. The approval process consists of underwriting, which includes a...

Q:

Snend Problem 2 0 - 9 ( Static ) Accounting changes; Identify type and reporting approach [ LO 2 0 - 1 , 2 0 - 2 , 2 0 - 3 . 2 0 - 4 ] At the begirning of 2 0 2 4 . Wegner implements undertook a...

Q:

Pineapple International has excess capacity and must decide whether to rework or scrap units that do not pass inspection. Pineapple Internatioani has 19,000 defective units that cost $5.20 per unit...