Question: Question 2: Consider the (M,N) inventory policy problem. Fill the table according to the following parameters and calculate total cost. General Parameters Distribution of Daily

 Question 2: Consider the (M,N) inventory policy problem. Fill the table

Question 2: Consider the (M,N) inventory policy problem. Fill the table according to the following parameters and calculate total cost. General Parameters Distribution of Daily Demand Distribution of Lead Time Cumulative Probability 4 Maximum Inventory 15 Review Period (days) Initial Inventory 3 Least Order Quantity 8 First Lead Time 3 Holding Cost/item 0.4 TL Stockout Cost/item 0.9 TL Cumulative Demand Probability Probability 0 0.10 1 0.25 2 0.35 3 0.11 4 0.19 Lead Time (days) Probability 1 0.65 2 0.10 3 0.25 Days until Order Arrives Holding Cost Shortage Cost Day 3 3 8 2 2 0.9 0 0 1 100 Do the simulation for 100 days using Excel. its my homework Please send the excel file to mail cedisgoat@gmail.com

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 Accounting Questions!