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 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
Get step-by-step solutions from verified subject matter experts
