{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 7 - Simulation demonstrations

# Chapter 7 - Simulation demonstrations - Cumulative Card...

This preview shows pages 1–3. Sign up to view the full content.

Cumulative Card Probability Probability Deal 0.159719 0.656208 0.058437 0.750082 0.848806 2 0.077 0.077 4 10 2 Jack King 3 0.077 0.154 4 0.077 0.231 5 0.077 0.308 6 0.077 0.385 7 0.077 0.462 8 0.077 0.538 9 0.077 0.615 10 0.077 0.692 Jack 0.077 0.769 Queen 0.077 0.846 King 0.077 0.923 Ace 0.077 1.000 LOOKUP TABLE Cumulative Vlookup Note: When FALSE is used in VLOOKUP, it returns the next lowest match 0.000 2 0.077 2 3 0.154 3 4 0.231 4 5 0.308 5 6 0.385 6 7 0.462 7 8 0.538 8 9 0.615 9 10 0.692 10 Jack 0.769 Jack Queen 0.846 Queen King 0.923 King Ace 1.000 Ace

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Marvin's Marine Service Centre Weekly Probability Demand 2000 0.12 3000 0.23 4000 0.48 5000 0.17 Begin. Inv. 300 Profit/gal sold 0.1 Shipment 3500 Loss/gal unsatisfied 0.12 Capacity 5500 Cost/gal to ship back 0.05 Inventory Inventory Average Week at beginning Simulated at end Unsatisfied Shipped Weekly Weekly Number of week Demand Sold of week Demand Back Profit Profit 1 3800 4000 3800 0 200 0 404 404 2 3500 4000 3500 0 500 0 410 407 3 3500 3000 3000 500 0 0 300 371
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 5

Chapter 7 - Simulation demonstrations - Cumulative Card...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online