excel simulation model
Not what you're looking for?
I am having a hard time getting this set up. Any help would be appreciated. I know how to get Crystal Ball to run..but have problems doing the initial spreadsheet setup.
We have an airline trip from point A to point B.
Tickets sell for $150
Plane holds 100 people
Each seat incurs $30 variable cost
$8000 to cost an empty plane to fly
95% of reservations show up
Overbooking penalty is $300
Can overbook up to 110 per plane
I am trying to set up an excel model with Crystal Ball Sensitivity to track the following:
1) Average number of customers turned away
2) Average profit per flight
3) Average number of seats occupied
4) Probability that 95 or fewer seats are occupied
I would like to run the model with for 10,000 trails with 100 seats being booked
Purchase this Solution
Solution Summary
The expert examines Excel simulation models using crystal ball sensitivity. The overbooking penalty is determined for the price of seats.
Solution Preview
Hi,
Did you not want an excel solution for this? I am not sure what is crystal ball. ...
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Introduction to Finance
This quiz test introductory finance topics.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Motivation
This tests some key elements of major motivation theories.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.