How many seats should the airline overbook

Assignment Help Operation Management

Reference no: EM132136118

Revenue Management Assignment II

II. San Francisco Express Airlines, SaFE for short, flies from PHL to SFO. On a Thursday evening flight, the number of last-minute no-shows and cancellations is Poisson distributed with mean 7.5. SaFE has an unlimited number of low fare travelers who pay $300. The cost of bumping such a passenger is estimated to be $350 (due lost goodwill as well as the cost of routing their itinerary through other airlines). SaFE offers this low fare because it also comes with a cancellation/rebooking fee of $150 – if a customer doesn’t show up for the flight or cancels her reservation, she must pay $150 to use the ticket on another flight.

To maximize revenue from this flight, how many seats should the airline overbook?

Customers are more reliable on the Friday evening flight. On that flight, the average number of no-shows and cancellations is Poisson with mean 4.5. Suppose SaFE overbooks that flight by 6 seats. What is the probability that at least 1 passenger will be bumped from this flight?

PLEASE ANSWER IT IN EXCEL SHEET WITH EXPLANATION

Reference no: EM132136118

Questions Cloud

Recorded the actual weekly sales of bags of dog food : Penny's Pup Food has recorded the actual weekly sales of bags of dog food and what the forecast was for each week.

Best suited to the hierarchical database model : What system that was mentioned in lecture is best suited to the hierarchical database model?

Decides to assess short-term effects of marketing activities : Three months into the launch of the new model, the department decides to assess the short-term effects of its marketing activities.

Difference between business markets and consumer markets : Which of the following is a difference between business markets and consumer markets ?

How many seats should the airline overbook : To maximize revenue from this flight, how many seats should the airline overbook?

Various types organizational structural options : Explain The various types organizational structural options

Expectations seem to change from one day to the next : No one ever seems to do what they say they will do. In addition, her manager’s expectations seem to change from one day to the next.

Additional target markets upon which sprig should focus : Identify two additional target markets upon which Sprig should focus

See presented with organizational approaches : What opportunities do you see presented with organizational approaches. Hindrances?

User Account

All Pages