Preview

Delta Blue Airlines

Satisfactory Essays
Open Document
Open Document
334 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Delta Blue Airlines
Delta Blue Airlines

Delta Blue Airlines operates a commuter flight between Charlotte and Philadelphia. The plane holds 30 passengers in Economy and 6 passengers in First Class. The airline makes a $100 profit on each passenger in Economy and $200 per passenger in First Class on the flight. When Delta Blue takes 30 Economy reservations and 6 First Class for the flight, experience has shown that on average, two passengers do not show up for each class. As a result, Delta Blue is averaging 28 Economy passengers and 4 First Class passengers with a profit of 28*$100 + 4*$200 = $3600 per flight. The airline operations office has asked for an evaluation of an overbooking strategy where they would accept 32 Economy reservations and up to 8 First Class reservations even though the airplane holds only 30 Economy and 6 First class passengers. The probability distribution for the number of passengers showing up with the new overbooking reservations policy is as follows:

# of Passengers Showing up
For Economy

Probability
28
0.05
29
0.25
30
0.50
31
0.15
32
0.05

# of Passengers Showing up
For First Class

Probability
1
0.02
2
0.06
3
0.17
4
0.20
5
0.25
6
0.23
7
0.05
8
0.02

The airline will 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 Economy passenger and $300 per First Class passenger. On the other hand, if there are First Class seats available, they move up Economy passengers to First Class. When this happens, they believe there is a positive goodwill “cost” of $200. Build a simulation model in an Excel file that will model the performance of the overbooking system. Model 500 flights. And answer the following questions.

a. What is the mean profit per flight if overbooking is implemented?
b. What percentage of customers will experience an overbooking problem?
c. Does your model recommend the overbooking strategy? Any

You May Also Find These Documents Helpful

  • Good Essays

    Acct 505 Course Project

    • 1431 Words
    • 6 Pages

    | BE (Passengers) = Fixed cost/ (Selling price – Variable Cost) = 3,150,000 / 160-70 = 3,150,000 / 90 = 35, 000…

    • 1431 Words
    • 6 Pages
    Good Essays
  • Good Essays

    Mat 540-Assignment 1

    • 566 Words
    • 3 Pages

    Jet Copies demonstrates a uniform probability distribution as it pertains to the number of copies sold per day. The average sale is between 2,000 through 8,000 copies a day, at $0.10 a copy. This number is denoted on the excel spreadsheet as r3 by generating a random number between 2,000 and 8,000. To calculate the total amount of business lost on any given day, the following calculations utilized: Lost Revenue = repair time * r3 * 0.10…

    • 566 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Frankie Ferrara

    • 581 Words
    • 3 Pages

    h. Considering that condor is risk averse, its reservation price would be 80% x $ 15 = $12.…

    • 581 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    d. What is Jewel’s new reservation price, i.e., the most it will pay for Condor’s Z2 CPU? Assume that Jewels makes decisions on the basis of Expected Monetary Value (EMV)…

    • 616 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Au C 520 Case Study

    • 610 Words
    • 3 Pages

    BBGP Case 8.3: In this case study, you are asked to do work related to performing a substantive analytical procedure for ticket revenues. AU-C 520 will be helpful in completing this assignment. You were previously assigned to read this standard but it would be helpful to review it before beginning the assignment to understand some of the factors that affect substantive analytical procedures, particularly forming an expectation. Please complete the following table AFTER reading the case.…

    • 610 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Southwest Airlines

    • 474 Words
    • 2 Pages

    Southwest Airlines strict adherence to its mission to provide the highest quality of customer service delivered with a sense of warmth, friendliness, individual pride, and company spirit is a key factor to the company’s success (About Southwest Airlines Co, 2013). The airlines ability to commit to employees to provide them with a stable work environment that ensures equal opportunity for learning and personal growth. Southwest prides itself on allowing all within the company to be creativity and innovative to help improve the effectiveness of Southwest Airlines. The most important benefit, employees will be provided the same concern, respect, and caring attitude within the organization that they are expected to share externally with every Southwest Customer.…

    • 474 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Bsbwor501 Final Exam

    • 582 Words
    • 3 Pages

    There are 2000 passengers who make this trip daily, and the airlines have agreed not to engage in price competition, but to compete based on market shares. So, at a price of $225 per ticket, they divvy up the $450,000 in revenue in a manner that is based on the share of the total number of flights each provides. Both airlines operate 200 passenger aircraft, which cost $20,000 per aircraft to operate (assume this does not vary with the number of passengers). American currently has 4 flights and Delta 6 flights daily. Complete the payoff…

    • 582 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    George's T-Shirts

    • 443 Words
    • 2 Pages

    George thought in terms of three possibilities specifically 80,000, 50,000 and 20,000 grand seats which he assumed to be high, medium and low respectively. The probability of 50,000 was as likely as either of the two possibilities combined. And 80,000 and 20,000 were about equally likely, or 80,000 was more likely than 20,000. He also thought regarding his designs and quality of the shirts, his sales could be ten percent (about 6 times out of 10), five percent, or fifteen (1 time out of 10) percent of the attendance.…

    • 443 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Alltel

    • 1600 Words
    • 7 Pages

    (Hint: don't ignore the possibility that the attendance of Comp ticket holders affects the concert's profitability.). (4:1 sales mix tickets of paying : comp) Break-Even = $0 = 4x($40.08-$3.05) + 1x($13.09-$3.05) - $263,245 x = 1664.42 sales mix packages 1(1664.42) = 1665 comp tickets 4(1664.42) = 6658 paying tickets = 8323 total tickets i.) Do you think that it is likely that the Pavilion will break even? Briefly explain. Yes, ALLTEL will likely break even. To make a profit ALLTEL has to sell over 8323 total tickets with the projected number of sales tickets is 10,349 total. ii.) Given your estimated breakeven point in units, compute the Margin of Safety (MOS) in units. Briefly comment on the MOS result. MOS units = #of total tickets - # of Break Even Tickets MOS units = 10,349 8323…

    • 1600 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    George T-shirt

    • 850 Words
    • 4 Pages

    George thought in terms of three possibilities specifically 80,000, 50,000 and 20,000 grand seats which he assumed to be high, medium and low respectively. The probability of 50,000 was as likely as either of the two possibilities combined. And 80,000 and 20,000 were about equally likely, or 80,000 were more likely than 20,000. He also thought regarding his designs and quality of the shirts, his sales could be ten percent (about 6 times out of 10), five percent, or fifteen (1 time out of 10) percent of the attendance.…

    • 850 Words
    • 4 Pages
    Good Essays
  • Good Essays

    TransAtlantic does not have data retention policy in place. Hence, TransAtlantic has applied the consensus of experts for the scenario analysis. The percentage of no-shows varies between 3% and 8% in economy class and 15%-30% in business.…

    • 1075 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Marriott Rooms Forecasting

    • 2499 Words
    • 10 Pages

    In this report the case is put forward and various methods have been chosen to come to a sensible conclusion. Firstly the raw data provided is used and the exponential smoothing model (ESM) is used to predict the outcome of guests on Saturday the 22nd of August. Next basic statistics are used and standard deviation is calculated with which the probability of the number of outcomes is concluded. Finally the most likely situations are analyzed and discussed like a lay man and the revenue is calculated to conclude which option should be suitable and concluding that the most likely scenario will be the 5th option.…

    • 2499 Words
    • 10 Pages
    Good Essays
  • Satisfactory Essays

    American Airlines

    • 354 Words
    • 2 Pages

    Our group was given a case study; case study 1 to figure out the contemporary workplace in the case study was given.…

    • 354 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Cprogramming

    • 746 Words
    • 3 Pages

    If the person types 1, then your program should assign a seat in the first class section (seats 1 – 5). If the person types 2, then your program should assign a seat in the economy section (seats 6 – 10). Your program should then print a boarding pass indication the pass indicating the person’s seat number and whether it is in the first class or economy section of the plane.…

    • 746 Words
    • 3 Pages
    Better Essays
  • Good Essays

    * Difficult to match the marginal cost of economy class seats in a mixed configuration aircraft of major carriers.…

    • 516 Words
    • 3 Pages
    Good Essays