Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.



ABC
1
Capital Tours
2
Tour Reservation System
3


4
Seats Available15
5
Ticket Price per Seat$10
6
Prob. of No-Show0.2
7
Cost of Bumping$25
8
Reservations Accepted18
9


10
Passengers to Board12
11


12
Ticket Revenue$180
13
Opp. Cost of Empty Seats$30
14
Cost of Bumping Passengers0
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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics For Management And Economics

Authors: Gerald Keller

11th Edition

978-1337296946, 1337296945, 1337093459, 978-1337516723, 1337516724, 978-1337093453

More Books

Students also viewed these Mathematics questions