South central airlines (sca) operates a commuter flight

Assignment Help Applied Statistics

Reference no: EM13889898

South Central Airlines (SCA) operates a commuter flight between Atlanta and Charlotte. The regional jet holds 48 passengers and currently SCA only books up to 48 reservations. Past data shows that SCA always sells all 48 reservations, but on average, two passengers do not show up. As a result, with 48 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 50 reservations even though the airplane holds only 48 passengers. SCA believes that it will be able to always book all 50 reservations. The probability distribution for the number of passengers showing up when 50 reservations are accepted is estimated as follows:

Passengers Showing Up	Probability
46	0.06
47	0.25
48	0.5
49	0.15
50	0.04

SCA receives a marginal profit of $100 for each passenger who books a reservation (regardless whether they show up or not). 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 $160 per passenger. Develop a spreadsheet simulation model for this overbooking system. Simulate the number of passengers showing up for a flight (Do 100 simulations). Assume the airline collects revenue from every ticket booked, even if the passenger doesn't show up.

(a)	What is the average net profit for each flight with the overbooking strategy?
If required, round your answer to the nearest dollar.
$

(b)	What is the probability that the net profit with the overbooking strategy will be less than the net profit without overbooking (48*$100 = $4,800)?
If required, round your answer to two decimal places.

(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.
The input in the box below will not be graded, but may be reviewed and considered by your instructor.

Reference no: EM13889898

Questions Cloud

2n socks in a drawer : If you have 2n socks in a drawer, n white and n black, and you reach in to choose 2 socks at random, How many ways are there to choose? How many of these ways result in getting a pair of the same color?

Show a monopolist will never produce on inelastic portion : Show that a monopolist will never produce on the inelastic portion of the demand curve and provide an explanation.

Relatively low rate of glass recycling? : What are the factors that contribute to our relatively low rate of glass recycling? Discuss three ways that we might be able to improve upon this rate

Calculate the slack for each activity : 1.A project for improving a billing process has the following precedence relationships and activity times:

South central airlines (sca) operates a commuter flight : South Central Airlines (SCA) operates a commuter flight between Atlanta and Charlotte. The regional jet holds 48 passengers and currently SCA only books up to 48 reservations. Past data shows that SCA always sells all 48 reservations, but on average,..

How much cash does the company expect to collect in may : Total billing notices in January were $58,000; in February, $62,000; in March, $66,000; in April, $65,000; in May, $60,000; and in June, $62,000. How much cash does the company expect to collect in May?

The level of calcium in the blood in healthy young adults : The level of calcium in the blood in healthy young adults varies with mean about u = 9.50 milligrams per deciliter and standard deviation about .40 milligram per deciliter. A clinic in rural Guatemala measures the blood calcium level of 64 healthy pr..

Approximately how long does it take to fall : A rock is dropped from a cliff approximately how long does it take to fall 45m if the acceleration due to gravity is 9.8m/sec2

What is the value judgment that underpins pareto efficiency : A new free-trade agreement increases total surplus. Everyone agrees on that. But your friend says, "Big deal, I am not supporting any such policy!" Can you argue why he should? Why he should not?

User Account

All Pages