Air Montreal flight AM-1660 travels from Montreal to Toronto. The airplane assigned to the flight is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Air Montreal flight AM-1660 travels from Montreal to Toronto. The airplane assigned to the flight is an Airbus A319 having 125 seats. All of the seats are coach class. There is no first-class section. On the other hand, the airline sells two types of tickets discount, and full-fare. Discount tickets cost $400 each and must be purchased at least twenty-one days ahead of time. Full-fare tickets cost $1000 each, are refundable, and are available up to the time of departure on a space-available basis. Virtually all full-fare tickets are sold within twenty-one days before departure. The airline is trying to decide how many seats to set aside for full-fare passengers on its busy Monday morning flight. The seat inventory control policy follows a nested structure. That is, when discount tickets are offered, full-fare tickets must also be offered. A protection level can be established to "protect" seats for full-fare customers. The protected seats for full-fare customers are only available to full-fare customers. If too many seats are set aside for the full-fare customers, the airplane may depart with many empty seats should the demand be low. If too few seats are set aside, revenues again may be low due to the number of high-paying passengers being turned away because too many discount tickets were sold. The airline has estimated the demand for all two types of tickets. The demand distributions are all normal. The means and standard deviations are reported in the following table. In addition, the demands for the two types of tickets are assumed to be independent. Type Discount Full Mean Standard deviation 120 30 20 10 To simplify the problem, assume the demand for the two types arrive sequentially with discount first and full-fare last. Air Montreal wishes to determine how many seats to set aside for full-fare in order to maximize the expected revenue from flight AM-1660. (a) Construct a simulation model in Excel to simulate the following policy: protect 30 seats exclusively for full-fare customers. Simulate for 1000 times. What are the mean and standard deviation of the revenue? Calculate the 95% confidence interval for the mean. What do you think about the policy? (b) Optimize the mean of the revenue by varying the protection level for full-fare customers between 20 and 40. Report and plot all the results (the mean of the revenue with the confidence interval). Report the mean and standard deviation of the revenue corresponding to the optimal policy. Calculate the 95% confidence interval for the mean of the revenue corresponding the optimal policy. (c) Find the 95% confidence interval for the probability of optimal revenue greater than or equal to the mean revenue that corresponds to protection level of 30 seats (i.e., the mean revenue that you found in part a). Air Montreal flight AM-1660 travels from Montreal to Toronto. The airplane assigned to the flight is an Airbus A319 having 125 seats. All of the seats are coach class. There is no first-class section. On the other hand, the airline sells two types of tickets discount, and full-fare. Discount tickets cost $400 each and must be purchased at least twenty-one days ahead of time. Full-fare tickets cost $1000 each, are refundable, and are available up to the time of departure on a space-available basis. Virtually all full-fare tickets are sold within twenty-one days before departure. The airline is trying to decide how many seats to set aside for full-fare passengers on its busy Monday morning flight. The seat inventory control policy follows a nested structure. That is, when discount tickets are offered, full-fare tickets must also be offered. A protection level can be established to "protect" seats for full-fare customers. The protected seats for full-fare customers are only available to full-fare customers. If too many seats are set aside for the full-fare customers, the airplane may depart with many empty seats should the demand be low. If too few seats are set aside, revenues again may be low due to the number of high-paying passengers being turned away because too many discount tickets were sold. The airline has estimated the demand for all two types of tickets. The demand distributions are all normal. The means and standard deviations are reported in the following table. In addition, the demands for the two types of tickets are assumed to be independent. Type Discount Full Mean Standard deviation 120 30 20 10 To simplify the problem, assume the demand for the two types arrive sequentially with discount first and full-fare last. Air Montreal wishes to determine how many seats to set aside for full-fare in order to maximize the expected revenue from flight AM-1660. (a) Construct a simulation model in Excel to simulate the following policy: protect 30 seats exclusively for full-fare customers. Simulate for 1000 times. What are the mean and standard deviation of the revenue? Calculate the 95% confidence interval for the mean. What do you think about the policy? (b) Optimize the mean of the revenue by varying the protection level for full-fare customers between 20 and 40. Report and plot all the results (the mean of the revenue with the confidence interval). Report the mean and standard deviation of the revenue corresponding to the optimal policy. Calculate the 95% confidence interval for the mean of the revenue corresponding the optimal policy. (c) Find the 95% confidence interval for the probability of optimal revenue greater than or equal to the mean revenue that corresponds to protection level of 30 seats (i.e., the mean revenue that you found in part a).
Expert Answer:
Answer rating: 100% (QA)
SOLUTION a Simulation Model To construct the simulation model follow these steps in Excel 1 Create a worksheet named Simulation with the following columns Trial A column to represent the trial number ... View the full answer
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
If the end of the cord is pulled downward with speed v C , determine the angular velocities of pulleys A and B and the speed of block D. Assume that the cord does not slip on the pulleys. Given: VC =...
-
The late economist Herbert Stein described the accounts that comprise a country's balance of payments: A country is more likely to have a deficit in its current account the higher its price level,...
-
Is pork-barrel spending always a bad thing? Can you think of some examples of pork-barrel projects, perhaps from your own district, that have had positive results?
-
What costs are recognized for environmental obligations?
-
Assigning Accounts Receivable On April 1, 2010, Prince Company assigns $500,000 of its accounts receivable to the Third National Bank as collateral for a $300,000 loan due July 1, 2010. The...
-
List and describe the four parts of Section I and the two partsof Section II of a homeowner??s insurance policy. 2 answers
-
The number of bears killed in 2014 for 56 counties in Pennsylvania is shown in the frequency distribution. Construct a histogram, frequency polygon, and ogive for the data. Comment on the skewness of...
-
What leaders or leader do you think the instWhat leaders or leader do you think the instructor is talking about?ructor is talking about?
-
How does the location of where a service is performed determine which code set is used. Relate issues such as reimbursement schedules, co-pay amounts, and coverage limitations. What is a...
-
Which annuity has a better return? explain why? Annuity A: $25,000 annuity that pays $5,000 every year for 10 years Annuity B: $25,000 annuity that pays $5,000 every year for 6 years.
-
Rainbow Manufacturing has the following data: Selling price: $140 Variable manufacturing cost: $87 Fixed manufacturing cost $250,000 per month Variable selling & adminstrative costs $22 Fixed selling...
-
Let f(x, y) = kx^3 - 48 kx + y^2, where k is not 0. Find the critical points of f. Write your points in ascending order of their x-coordinates
-
The related Kakai data of the Company: Period Quantity Unit cost Week 1 8,000 10.00 Week 2 8,200 11.00 Week 3 7,900 12.00 On week 4 the company made a sale of 15,000 units Mark up base on cost is 50%...
-
What is the best way to manage the situation where individuals rationalize committing misconduct in and organization?
-
The diagram shows the two forces acting on a small object. Which of the following is the resultant force on the object? A. 8 N downwards B. 8 N upwards C. 2 N downwards D. 2 N upwards 3 N 5 N
-
Name and describe the 13 mandatory features of an OODBMS.
-
What major factors should be addressed when database system performance is evaluated? Discuss each factor briefly.
-
Explain what an upsert does.
-
Search for the latest about Robert Allen Stan- fords' alleged ponzi scheme.
-
From the following selected balances of Filo plc as at 31 March 2005 draw up (i) a detailed trading and profit and loss account for internal use, and (i) a profit and loss account for publication....
-
From the following selected balances of State plc as at 31 December 2008, prepare (j) a detailed trading and profit and loss account for the year ended 31 December 2008 for internal use and (ii) a...
Study smarter with the SolutionInn App