Question
The manager of a downtown Chicago sightseeing tour company is concerned about overbooking for one of his bus tours. The bus has 15 seats but
The manager of a downtown Chicago sightseeing tour company is concerned about overbooking for one of his bus tours. The bus has 15 seats but sometimes there are empty seats. His records show that about 20% of ticket holders do not show up for their tour. Tickets cost $10 and are non-refundable. If the manager overbooks the tour and more than 15 passengers show up, some of them will be bumped to a later tour. This bumping costs the company $25 in various expenses to keep the customer happy until the next tour. The manager wants to see what happens to profits if 18 reservations are accepted.
A | B | C | |
1 | Capital Tours | ||
2 | Tour Reservation System | ||
3 | |||
4 | Seats Available | 15 | |
5 | Ticket Price per Seat | $10 | |
6 | Prob. of No-Show | 0.2 | |
7 | Cost of Bumping | $25 | |
8 | Reservations Accepted | 18 | |
9 | |||
10 | Passengers to Board | 12 | |
11 | |||
12 | Ticket Revenue | $180 | |
13 | Opp. Cost of Empty Seats | $30 | |
14 | Cost of Bumping Passengers | 0 | |
15 | Marginal Profit | $150 | |
MODEL |
What formula should go in cell C14 of the worksheet to determine the Cost of Bumping Passengers? (Click to select)
=C5*MAX(C10,0)
=MAX(C10-C4,0)
=C5*MAX(C10,C4)
=C5*MAX(C10-C4,0)
Step by Step Solution
3.53 Rating (160 Votes )
There are 3 Steps involved in it
Step: 1
The answer is C5MAXC10C40 As bumping will on...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started