10-10 - Heartbreak Hotel Calculations set to Manual. Press...

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

View Full Document Right Arrow Icon
Heartbreak Hotel Data Table Calculations set to Manual. Press F9 to recalculate. No-Shows Distribution Day Total cost No-shows Probability Run Cost 1 1 2 $250.00 0 $0.00 $250.00 0 0.10 0.00 0.10 1 $147.50 2 3 0 $0.00 0 $0.00 $0.00 1 0.13 0.10 0.23 2 $147.50 3 0 3 $375.00 0 $0.00 $375.00 2 0.31 0.23 0.54 3 $147.50 4 4 0 $0.00 1 $50.00 $50.00 3 0.16 0.54 0.70 4 $147.50 5 2 1 $125.00 0 $0.00 $125.00 4 0.21 0.70 0.91 5 $147.50 6 1 2 $250.00 0 $0.00 $250.00 5 0.09 0.91 1.00 6 $147.50 7 5 0 $0.00 2 $100.00 $100.00 7 $147.50 8 0 3 $375.00 0 $0.00 $375.00 Rooms overbooked 3 8 $147.50 9 0 3 $375.00 0 $0.00 $375.00 9 $147.50 10 2 1 $125.00 0 $0.00 $125.00 Cost per room short $125 10 $147.50 11 4 0 $0.00 1 $50.00 $50.00 Cost per room vacant $50 11 $147.50 12 3 0 $0.00 0 $0.00 $0.00 12 $147.50 13 4 0 $0.00 1 $50.00 $50.00 Based on 1 replication: 13 $147.50 14 4 0 $0.00 1 $50.00 $50.00 Average daily cost = $147.50 14 $147.50 15 3 0 $0.00 0 $0.00 $0.00 15 $147.50 16 2 1 $125.00 0 $0.00 $125.00 Based on 200 replications: 16 $147.50 17 2 1 $125.00
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/10/2011 for the course INSY 4508 taught by Professor Graham during the Spring '10 term at Bentley.

Page1 / 8

10-10 - Heartbreak Hotel Calculations set to Manual. Press...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online