{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

CH%205_P3

# CH%205_P3 - 2800 3512.2 4000 B16(Sim#2 Total Profi 2920...

This preview shows page 1. Sign up to view the full content.

Chapter 5 Problem 3 Page 1 Chapter 5 Problem 3 Assuming refundable tickets Ticket Price \$150.00 Capacity 100 Fixed cost \$8,000.00 Variable Cost \$30.00 Overbooking compensation \$300.00 Iterations= 100 Prob of Showing up 0.95 Simulations= 10 Reservations accepted #ADDIN? # Input Variables= 2 # Output Variables= 1 Number showing up #ADDIN? Sampling Type= Latin Hypercube Ticket Revenue #ADDIN? Runtime= 00:00:34 Total Overbooking Comp #ADDIN? Variable Costs #ADDIN? Summary Statistics Fixed Cost \$8,000.00 Total Profit #ADDIN? Cell Name Minimum Mean Maximum B16 (Sim#1) Total Profi...
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2800 3512.2 4000 B16 (Sim#2) Total Profi. .. 2920 3613.6 4000 B16 (Sim#3) Total Profi. .. 3040 3680.2 4000 B16 (Sim#4) Total Profi. .. 2800 3703 4000 B16 (Sim#5) Total Profi. .. 2500 3652 4000 B16 (Sim#6) Total Profi. .. 2200 3539.2 4000 B16 (Sim#7) Total Profi. .. 1900 3365.8 4000 B16 (Sim#8) Total Profi. .. 1600 3151 4000 B16 (Sim#9) Total Profi. .. 1300 2896.6 4000 B16 (Sim#10) Total Prof. .. 1000 2631.4 4000 A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online