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...
-
Go to the Baldrige Award website, www.quality.nist.gov, and research several companies that have won the Malcolm Baldrige Award. Describe any common characteristics that the quality-management...
-
Why is YTM important?
-
Evans \& Sons, Inc., received notification from a local attorney that the company was being sued for \(\$ 5,000,000\) for patent infringement. A review of the situation by the company's CEO led to...
-
1. What tips can you offer Cooper and Schwinoff about family members who start and run a business together? What pitfalls would you warn them to avoid? 2. Suppose that Cooper and Schwinoff had...
-
The bestdesigned strategies are valuable, whether or not they are effectively implemented. Question content area bottom Part 1 True False
-
The Toyota Camry is one of the best-selling cars in North America. The cost of a previously owned Camry depends on many factors, including the model year, mileage, and condition. To investigate the...
-
Question Content Area Roget Factory has budgeted factory overhead for the year at $5,229,900. It plans to produce 2,000,000 units of product. Budgeted direct labor hours are 351,000, and budgeted...
-
1. The distance between two cities is 239 miles. If you travel at a speed of 74 mph, how long would it take you to go from one city to another? 2. You can travel from one city to another in 2 hours...
-
Consider the following table: Scenario Severe recession Mild recession Normal growth Boom Required: Probability Stock Fund Rate of Return Bond Fund Rate of Return 0.10 -34% -9% 0.20 0.30 0.40 -20.0%...
-
Investigate the molecular basis of antibiotic resistance in bacterial populations, considering both horizontal gene transfer and selective pressures driving the evolution of resistance mechanisms .
-
Download a company's Organizational Chart Discuss how the Organizational chart relates to its external environment, organizational size, technology, or strategy. Discuss how this information impacts...
-
Discuss the significance of co-evolution between plants and their pollinators, highlighting the intricate biochemical signaling mechanisms involved in plant-pollinator interactions .
-
In C++: Completing the shotgun DNA sequencing program. Write a program that operates over an array of strings, where each string represents a chunk of DNA. Building on the pseudocode we wrote in...
-
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...
-
Refer to the data given for the Geary Company in Problem P12-4B. Required a. Compute the change in cash that occurred during 2019. b. Prepare a statement of cash flows using the direct method. Use...
-
Columbia Sportswear Company vs Under Armour, Inc. The financial statements for the Columbia Sportswear Company can be found in Appendix A at the end of this book, and the financial statements of...
-
Recently hired as assistant controller for Finite, Inc., you are sitting next to the controller as she responds to questions at the annual stockholders' meeting. The firm's financial statements...
Study smarter with the SolutionInn App