Vlookup model Reorder Point 15 Order Order Carrying Shortage Quantity Cost/order Cost/unit Cost/unit 26 500 10...

Transcribed Image Text:

Vlookup model Reorder Point 15 Order Order Carrying Shortage Quantity Cost/order Cost/unit Cost/unit 26 500 10 50 Demand 0.20 Cumulative (x) Prob(x) Probability. 14.00 Cumlulative Prob Demand 0.20 0.00 14.00 15.00 0.40 0.60 0.20 15.00 Mean Inventory Cost 200.00 16.00 0.20 0.80 0.60 16.00 17.00 0.10 0.90 0.80 17.00 18.00 0.10 1.00 0.90 18.00 LEADTIME = 2 weeks Week Beginning Order Inventory Random Number Inventory Receipt Level 1 34 34 Ending Place Order Carrying Shortage Total 0 Number 0.01 Demand 14.0 Inventory Order 20.0 NO Cost 0.0 Cost 200.0 Cost 0.00 Cost 200.00 234567890 0 0.20 0.90 0.80 0.95 0.47 0.67 0.90 0.41 10 0.19 FOR n=10 Weeks Standard Vlookup model Reorder Point 15 Order Order Carrying Shortage Quantity Cost/order Cost/unit Cost/unit 26 500 10 50 Demand 0.20 Cumulative (x) Prob(x) Probability. 14.00 Cumlulative Prob Demand 0.20 0.00 14.00 15.00 0.40 0.60 0.20 15.00 Mean Inventory Cost 200.00 16.00 0.20 0.80 0.60 16.00 17.00 0.10 0.90 0.80 17.00 18.00 0.10 1.00 0.90 18.00 LEADTIME = 2 weeks Week Beginning Order Inventory Random Number Inventory Receipt Level 1 34 34 Ending Place Order Carrying Shortage Total 0 Number 0.01 Demand 14.0 Inventory Order 20.0 NO Cost 0.0 Cost 200.0 Cost 0.00 Cost 200.00 234567890 0 0.20 0.90 0.80 0.95 0.47 0.67 0.90 0.41 10 0.19 FOR n=10 Weeks Standard