Westonci.ca is your trusted source for finding answers to a wide range of questions, backed by a knowledgeable community. Ask your questions and receive precise answers from experienced professionals across different disciplines. Discover in-depth answers to your questions from a wide network of professionals on our user-friendly Q&A platform.

The average revenue collected on this flight is $145/seat. However, if the flight is overbooked and the airline needs to rebook a ticketed passenger, United typically gives the customer a free round-trip ticket for a future flight. The cost of this free round-trip ticket averages $330. By how many seats should United overbook for this route

Sagot :

This question is incomplete, the complete question is;

United Airline flights from Newark to Seattle are typically booked to capacity. However, due to United’s current lenient rebooking policies, on average 17 customers (with a standard deviation of 10) cancel or are no shows for these flights. The average revenue collected on this flight is is $145/seat. However, if the flight is overbooked and the airline needs to rebook a ticketed passenger, United typically gives the customer a free round-trip ticket for a future flight. The cost of this free round-trip ticket averages $330. By how many seats should United overbook for this route?

Answer:

the number of seats that should be overbooked is approximately 12

Step-by-step explanation:

Given the data in the question;

average = 17 customers

standard deviation = 10

Cost of under booking the flight ( underage ); Cu = $145

Cost of overbooking the flight ( Overage ); Co = $330

we calculate the service level

service level = Cu / ( Cu + Co )

we substitute

Service level = 145 / ( 330 + 145 )

= 145 / 475

Service level = 0.3053

In excel, we use NORMSIV function to determine the z-value

z-value = NORMSIV ( 0.3053 )

z -value = -0.509

Now, the number of seats (Q) that should be overbooked will be;

Q = Average cancellations + Z-value × S.D

we substitute

Q = 17 + ( -0.509 × 10 )

Q = 17 + ( -5.09 )

Q = 17 - 5.09

Q = 11.91 ≈ 12

Therefore, the number of seats that should be overbooked is approximately 12