Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
South Central Airlines operates a commuter flight between Atlanta and Charlotte. The plane holds 30 passengers, and the airline makes a $100 profit on each passenger on the flight. When South Central takes 30 reservations for the flight, experience has shown that on average, two passengers do not show up. As a result, with 30 reservations, South Central is averaging 28 passengers with a profit of 28(100) = $2800 per flight. The airline operations office has asked for an evaluation of an overbooking strategy where they would accept 32 reservations even though the airplane holds only 30 passengers. The probability distribution for the number of passengers showing up when 32 reservations are accepted is as follows.
Passengers Showing Up: Probability:
28 0.05
29 0.25
30 0.5
31 0.15
32 0.05
The airline will receive a profit of $100 for each passenger on the flight up to the capacity of 30 passengers. 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 passenger. Develop a worksheet model that will simulate the performance of the overbooking system. Simulate the number of passengers showing up for each of 500 flights by using the VLOOKUP function. Use the results to compute the profit for each flight.
Does your simulation recommend the overbooking strategy? What is the mean profit per flight if overbooking is implemented?
Explain how your simulation model could be used to evaluate other overbooking levels such as 31, 33, 34 and for recommending a best overbooking strategy.
The role of policy analysis in policy modification. Include brief descriptions of three federal agencies (GAO, CBO, and CRS) that support policymaking through policy analysis.
1. Develop a forecasting model and project attendance through 2014. 2. What revenues are to be expected in 2013 and 2014?
Compute the forecasts for all quarters of 2010 using the three quarter weighted moving average, with the most recent data weighted at 0.5
Does your company's compensation plans help to attract and retain people with the right skills, knowledge and motivation to help the company succeed?
What is the scope of the project? What does it deliver? Describe how the project tasks and work are organized. What are the weak points with using bar charts for planning this project? It has received an order from an aircraft manufacturer to design ..
Describe how the skills needed for designing and implementing human process based interventions differ from those need for tech-structural interventions.
A product is currently made in a process-focused shop, where fixed costs are $9000 per year and variable cost is $50 per unit. The firm is considering a fundamental shift in process, to repetitive manufacture.
People with an external locus of control are:
What are the supply chain or demand chain elements essential to the operations and marketing of Amazon? Where are amazon warehouses located and why are they located there? How can the lessons learned from amazon be applied to other forms of e-commerc..
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 29 2 32 3 33 4 38 5 42 6 36 7 45 8 47 9 48 10 45 Calculate the exponential smoothing with trend forecast for these data using an α of 0.20, a formula5.mml of 0.30,..
UPD Manufacturing produces a range of health care appliances for hospital as well as for home use. The company has experienced a steady demand for its products, which are highly regarded in the health care field. Recently the company has undertaken a..
List three opportunities and three threats that could represent key factors facing your college or university. Briefly state your view of what institution should do in light of these factors.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd