CH%205_P3

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

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

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

This note was uploaded on 05/09/2010 for the course MD 605 taught by Professor Silks during the Fall '10 term at box.

Ask a homework question - tutors are online