Question: I need urgent help solving this problem, please show me how to solve this problem in excel ASAP! Best answer guaranteed a thumbs up! A

I need urgent help solving this problem, please show me how to solve this problem in excel ASAP! Best answer guaranteed a thumbs up!

A ticket from St. Louis to Austin on an airline sells for $150. The plane can hold 100 people. It costs $8000 to fly an empty plane. Each person on the plane incurs variable costs of $30 (for food and fuel). If the flight is overbooked, anyone who cannot get a seat receives $300 in compensation. On average, 95% of all the people who have a reservation actually show up for the flight. The company plans to accept 105 reservations for each flight. Simulate 1000 flights and calculate: Average profit Proportion of full flights Average number of people turned away per flight. Hint: To model a person with a reservation showing up, use =IF(rand()

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

I need urgent help solving this problem, please show me how to solve this problem in excel ASAP! Best answer guaranteed a thumbs up! A small grocery store has only one checkout counter. Time between...

I need urgent help solving this problem, please show me how to solve this problem in excel ASAP! Best answer guaranteed a thumbs up! A company is considering entering a new market channel. The...

I need urgent help solving this problem, please show me how to solve this problem in excel ASAP! Best answer guaranteed a thumbs up! A product must go through an assembly line made up of five...

Answer all parts please no work needed to be shown Part 2.5 2.5 Assignment 2: Problem Set Overview In this assignment you will be completing problems based on graphing rational functions. The purpose...

Three suppliers located in Baltim x Homework Help-08.A from On X > Term Project (1).pdf X + -ox Term Project - MGMT-520-36 - 5 x Term Project (1).pdf X G C File...

After Reading the Case. Clearly answer the following questions in a single post. 1) In your opinion , How did ChassisCo contribute to the cause of crisis at Athens in 2004? How did Toyota contribute...

Hello, I need help with with Return of the Tallahassee Beancounters Case (the 2010 version). The solution and teachers handouts for the 2003 version have already been made available, however it's...

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

Three suppliers located in Baltimore, St. Louis, and Kansas City provide four customers with a special component every year. These customers are located in Cleveland, Charlotte, Atlanta, and Houston....

A Canon black-and-white multifunction laser printer costs $49 and sells for $119.99. Find the rate of markup based on the selling price.

Assume that you have client with an underfunded pension fund. What strategies would you recommend to close the gap in the pension fund?

Angle Castillo and Reesa Cameron own The Garden and Lawn Shop. The partnership agreement provides that Castillo can withdraw \ $ 1 0 , 0 0 0 a month and Cameron, \ $ 9 0 0 0 a month In anticlpation...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...