Purchase Solution

excel simulation model

Not what you're looking for?

Ask Custom Question

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

Attachments
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. ...

Solution provided by:
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.