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 cost (inventory + shortage) at the end of 20 weeks if the order size is equal to the demand in every week?

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

$ 3.00

$ 132.00

$ 135.00

$ 290.00

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 General Management 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:

Miller Mfg. has one LIFO pool. Information relating to the products in this pool is as follows: Beginning inventory, January 1 . . . . . . . . . . . . . . . . . . . . 60 units @ $10 each Purchase,...

Q:

Royal Australian Navy (RAN) is considering three types of attack aircraft to equip its carriers: a supersonic type, a subsonic type, and a boost glide type. The effectiveness of any aircraft to the...

Q:

After selling a private business to a buyer, what are the risk if the seller liquidates the company after sell for the buyer?

Q:

Note: This problem is for the 2018 tax year. Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social...