Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

OptiJet Airlines provide daily service for commuters traveling from South to MidWest. One of the fare classes for this flight has been set at $250.

image text in transcribed
image text in transcribed
image text in transcribed
OptiJet Airlines provide daily service for commuters traveling from South to MidWest. One of the fare classes for this flight has been set at $250. The airline has set aside a capacity of 25 passengers in this fare class. Historical passenger demand for these seats in this fare class has been fit to a normal distribution with mean 27.18 and standard deviation 3.14. If demanded, the airline will typically accept more reservations than the seat capacity since only 90% of all customers who have a reservation show up for the flight. This policy is called overbooking. If the flight is overbooked, anyone who shows up but does not receive a seat on the plane receives $350 in compensation in addition to a full refund of the ticket price. The variable cost of transporting a passenger and his/her luggage on this flight is $100. The fixed cost of operating the flight is $2,500. To maximize expected profit from operating this flight, how many reservations for the flight should this airline accept? Develop a simulation model in the spreadsheet file. What would be the best strategy for the airline? Consider Optijet problem statement and the screenshot above. The screenshot above represents a completed simulaton model. What is in the cell that represents "Number of tickets sold" (C15)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial And Managerial Accounting

Authors: Susan F. Haka ,Joseph V. Carcello ,Jan R. Williams

18th Edition

1259922189, 978-1259922183

More Books

Students also viewed these Accounting questions

Question

6. How do histories influence the process of identity formation?

Answered: 1 week ago