# 10-5 - Judith's Limousine Service Data Table Calculations...

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

Judith's Limousine Service Data Table Calculations set to Manual. Press F9 to recalculate. Judith's reservation limit 14 Van's passenger capacity = 10 Reservation Exist? Show up? Run Profit Occ rate Reservations requested 7 Minimum reservation request = 7 1 1 1 1 \$220 80.0% Reservations accepted 7 Maximum reservation request = 14 2 1 1 2 \$220 80.0% Number show up 6 Probability person shows up 0.80 3 1 1 3 \$220 80.0% Number overbook 0 Reservation deposit amount = \$10 4 1 1 4 \$220 80.0% Seats remaining 4 Balance of ticket price = \$25 5 1 1 5 \$220 80.0% Number walk-up 2 Walk-up ticket price = \$50 6 1 1 6 \$220 80.0% Walk-up accepted 2 Cost per overbooked person = \$75 7 1 0 7 \$220 80.0% Total seats occupied 8 Fixed cost per trip = \$100 8 0 0 8 \$220 80.0% Revenue \$320 9 0 0 9 \$220 80.0% Cost \$100 Walk-up Distribution 10 0 0 10 \$220 80.0% Profit \$220 Number Probability RN intvl LL RN intvl UL 11 0 0 11 \$220 80.0% Occupancy rate 80.0% 0 0.30 0.00 0.30 12 0 0 12 \$220 80.0% 1 0.45 0.30 0.75 13 0 0 13 \$220 80.0% 2 0.25 0.75 1.00

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 7

10-5 - Judith's Limousine Service Data Table Calculations...

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

View Full Document
Ask a homework question - tutors are online