South Central Airlines (SCA) operates a commuter flight between Atlanta and Charlotte. The regional jet holds 50 passengers and currently SCA books only up to 50 reservations. Past data shows that SCA always sells all 50 reservations but that, on average, two passengers do not show up. As a result, with 50 reservations, the flight is often being flown with empty seats. To capture additional profit, SCA is considering an overbooking strategy in which they would accept 52 reservations even though the airplane holds only 50 passengers. SCA believes that it will be able to always book all 52 reservations. The probability distribution for the number of passengers showing up when 52 reservations are accepted is estimated as follows:
SCA receives a marginal profit of $100 for each passenger who books a reservation ( regardless whether they show up). The airline will also incur a cost for any passenger denied seating on the flight. This cost covers added expenses of rescheduling the passenger as well as loss of goodwill, estimated to be $150 per passenger. Develop a spreadsheet simulation model for this overbooking system. Simulate the number of passengers showing up for a flight.
a. What is the average net profit for each flight with the overbooking strategy?
b. What is the probability that the net profit with the overbooking strategy will be less than the net profit without overbooking (50*$100 5 $5,000)?
c. Explain how your simulation model could be used to evaluate other overbooking levels such as 51, 53, and 54 and for recommending a best overbooking strategy.
From the following list, select the letter that accurately describes each of the following groups of words, and write the correct answer in the space provided.a. correctl...Jun 11 2021
use the data listed below. The values are departure delay times (minutes) for American Airlines flights from New York to Los Angeles. Negative values correspond to flight...May 31 2021
Journal Entries to Record a Business CombinationOn January 1, 20X2, Frost Company acquired all of TKK Corporation’s assets and liabilities by issuing 24,000 shares of its...Jul 08 2020
Which of the following is an illustration of the law of increasing opportunity costs?A) As more cars are produced, the opportunity cost of each additional car is greater ...May 10 2021
Why are retro brands so popular? What is the key ingredient that makes them successful?Aug 23 2020
For Marx, what are the problems of division of labor? How does Marx argue that labor is not valued in this mode of production?(use more information from Economic and Phil...Mar 17 2020
Started business on Jan.1st. List below are some events thatoccurred its first year operation.1. Equipment worth $150,000 was purchased on Sep.1st, in exchangefor $50,000...May 19 2018
Prepare a project report 2000-3000 words,choose a new product or service that you wish to market.create/choose- Brand Name- color of logo/trademark- punchline for adverti...Apr 03 2021
Financial markets improve economic welfare because: A. they channel funds from savers to investorsB. they allow consumers to time their purchases betterC. they eliminate ...Apr 26 2021
Earthquake Magnitudes Listed below are Richter scale magnitudes of randomly selected earthquakes. a. Identify the best point estimate of the population mean m. b. Const...May 27 2021