Exercise #3 (20pt): You're a systems engineer at Kash Air airlines charged with helping the airline...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Exercise #3 (20pt): You're a systems engineer at Kash Air airlines charged with helping the airline to overbook flights. You realize that a certain percentage of ticketed passengers will cancel at the last minute. Therefore, to avoid empty seats, the airline wants to sell more tickets than there are seats, hoping that just about the right number of passengers show up. You assume that the no-show rate is 8% and assume that passengers choose to show up independently of each other. For a flight with 200 seats, the airline wants to see how sensitive various probabilities are to the number of tickets it issues. a. Calculate the probability that more than 205 passengers show up for the flight. b. Calculate the probability that more than 200 passengers show up. c. Calculate the probability that at least 195 passengers show up. d. Calculate the probability that at least 190 passengers show up. You're going to suggest that the airline issues a minimum of 205 tickets for the flight, and as many as 230, with all possibilities in between. Use Excel to calculate the four probabilities in a-d for each of the ticket allotment possibilities (be thoughtful in setting up the parameters so that you do as little manual entering as possible - this problem can be answered quickly with some thought on setting it up properly). Use the output of this exercise to make an informed decision about how many tickets to issue considering the risks of (1) operating a flight without maximizing revenue and (2) overselling. For this discussion, define the likelihood that flights will have exact capacity or fewer passengers (more than one options are possible) and the likelihood of overbooking the flight. Exercise #3 (20pt): You're a systems engineer at Kash Air airlines charged with helping the airline to overbook flights. You realize that a certain percentage of ticketed passengers will cancel at the last minute. Therefore, to avoid empty seats, the airline wants to sell more tickets than there are seats, hoping that just about the right number of passengers show up. You assume that the no-show rate is 8% and assume that passengers choose to show up independently of each other. For a flight with 200 seats, the airline wants to see how sensitive various probabilities are to the number of tickets it issues. a. Calculate the probability that more than 205 passengers show up for the flight. b. Calculate the probability that more than 200 passengers show up. c. Calculate the probability that at least 195 passengers show up. d. Calculate the probability that at least 190 passengers show up. You're going to suggest that the airline issues a minimum of 205 tickets for the flight, and as many as 230, with all possibilities in between. Use Excel to calculate the four probabilities in a-d for each of the ticket allotment possibilities (be thoughtful in setting up the parameters so that you do as little manual entering as possible - this problem can be answered quickly with some thought on setting it up properly). Use the output of this exercise to make an informed decision about how many tickets to issue considering the risks of (1) operating a flight without maximizing revenue and (2) overselling. For this discussion, define the likelihood that flights will have exact capacity or fewer passengers (more than one options are possible) and the likelihood of overbooking the flight.
Expert Answer:
Answer rating: 100% (QA)
Answeyx As Per guidelines Giuen in fmation P NO Show 010 P Sh... View the full answer
Related Book For
Statistics for Business and Economics
ISBN: 978-0134506593
13th edition
Authors: James T. McClave, P. George Benson, Terry Sincich
Posted Date:
Students also viewed these accounting questions
-
Airlines overbook (sell more tickets than there are seats) flights, based on past records that indicate that approximately 5% of all passengers fail to arrive on time for their flight. Sup-pose a...
-
Airlines routinely sell more tickets for flights than the number of seats on the plane. Overbooking seldom causes problems because a statistically predictable number of ticketholders fail to show up...
-
Airlines overbook flights in order to reduce the odds of flying with unused seats. An article in Transportation Research (Vol. 38, 2002) investigated the optimal overbooking policies for major...
-
A trial balance was extracted from the books of V Baker, and it was found that the debit side exceeded the credit side by 40. This amount was entered in the suspense account. The following errors...
-
Sunder manufactures hard rubber pet toys. The purple dog chewy has a variable cost of $ 3.00 per unit. It is produced on a machine that is leased. The three models of this machine have three...
-
30, 2019. Accounts Payable Accounts Receivable Accumulated Amortization Accumulated Depreciation Amortization Expense Cash Common Stock Depreciation Expense Equipment (in millions) reported in the...
-
Using bolts of the same material and cross-sectional area, two possible attachments for a cylinder head are shown. Compare the strain energy developed in each case, and then explain which design is...
-
The following is a list of liability accounts on the ledger of Chop House Incorporated on January 1: Sales Tax Payable .....$ 7,500 Accounts Payable ..... 9,500 Unearned Revenue ... 16,500 The...
-
Two identical spaceships with proper lengths of 175 m are launched from Earth. Spaceship A is launched in one direction at 0.500c and spaceship B is launched in the opposite direction at 0.750c. a....
-
A columnist made the following comment in an online article: "In any case, the Q-factor approach, unlike consumption CAPM, explains where the anomalies come from (and why they might end). Consumption...
-
Consider the Smith family of four living across the street from you in your neighborhood/state. They do not earn an outrageous amount of money; however, they consider themselves as having a...
-
Define the following: a. IDC b. Elected capitalized IDC c. Sublease d. Depletable basis e. Half-year convention f. Property
-
How is a data flow diagram different from a flowchart?
-
What are some examples of the event-driven modeling used in systems analysis?
-
What are external agents and why can the external agents of an information system change?
-
If interest areas warranting further evaluation are identified, the initial reconnaissance costs of the project area are ______________. a. Capitalized to the areas of interest b. Allocated to the...
-
When discussing the topic of ancient civilizations in history, what could be a research question about this topic that could tie into the themes of diversity and bias?
-
Juarez worked for Westarz Homes at construction sites for five years. Bever was a superintendent at construction sites, supervising subcontractors and moving trash from sites to landfills. He...
-
A team of industrial management university professors investigated the reliability of a manufacturing system that involves multiple production lines (Journal of Systems Sciences & Systems...
-
According to the most recent Global Business Travel Association (GBTA) survey, the average base salary of a U.S. travel management professional is $94,000. Assume that the standard deviation of such...
-
Refer to Exercise 7.84. Suppose we had n = 100, x = 9.4, and s2 = 4.84. a. Test the null hypothesis, H0: 2 = 1, against the alternative hypothesis, Ha: 2 > 1. b. Compare your test result with that of...
-
The stiffness matrix \([C]\) for a specially orthotropic material associated with the principal material axes \((1,2,3)\) is given in Equation 2.16. Prove that, when the material is specially...
-
Using an example of static equilibrium of an element in pure two-dimensional (2D) shear stress, prove that the shear stresses are symmetric (i.e., prove that \(\sigma_{i j}=\sigma_{j i}\) when \(i eq...
-
A balanced orthotropic, or square symmetric lamina, is made up of \(0^{\circ}\) and \(90^{\circ}\) fibers woven into a fabric and bonded together, as shown in Figure 2.10. a. Describe the...
Study smarter with the SolutionInn App