Chapter 7 - Simulation demonstrations

Chapter 7 - Simulation demonstrations - Cumulative Card...

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/04/2011 for the course ITIS ITIS1p97 taught by Professor Dr.susansproule during the Fall '11 term at Brock University.

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 Right Arrow Icon
Ask a homework question - tutors are online