IDNLearn.com is your go-to resource for finding answers to any question you have. Our platform offers reliable and comprehensive answers to help you make informed decisions quickly and easily.
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