Lesson 7 - IntroductiontoSimulation UsingCrystalBall...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Introduction to Simulation  Using Crystal Ball
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Introduction to Simulation In many spreadsheets, the value for one or more cells  representing independent variables is unknown or uncertain.   As a result, there is uncertainty about the value the dependent  variable will assume: Y = f (X 1 , X 2 , …, X k ) Simulation can be used to analyze these types of models.
Background image of page 2
Random Variables & Risk random variable  is any variable whose value cannot be predicted or set  with certainty. Many “input cells” in spreadsheet models are actually random variables. the future cost of raw materials future interest rates future number of  employees in a firm expected product demand Decisions made on the basis of uncertain information often involve risk. “Risk” implies the potential for loss.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Why Analyze Risk? Plugging in expected values for uncertain cells tells us nothing about the  variability of the performance measure we base decisions on. Suppose an $1,000 investment is expected to return $10,000 in two years.   Would you invest if. .. the outcomes could range from $9,000 to $11,000? the outcomes could range from -$30,000 to $50,000? Alternatives with the same expected value may involve different levels of  risk.  
Background image of page 4
Methods of Risk Analysis Best-Case/Worst-Case Analysis What-if Analysis Simulation
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Best-Case/Worst-Case Analysis Best case - plug in the most optimistic values for each of the  uncertain cells. Worst case - plug in the most pessimistic values for each of  the uncertain cells. This is easy to do but tells us nothing about the  distribution  of  possible outcomes within the best and worst-case limits.
Background image of page 6
Possible Performance Measure Distributions Within a Range worst case best case worst case best case worst case best case worst case best case
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
What-If Analysis Plug in different values for the uncertain cells and see what  happens.
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/08/2011 for the course MGMT 386 taught by Professor Markowitz during the Summer '10 term at Rutgers.

Page1 / 47

Lesson 7 - IntroductiontoSimulation UsingCrystalBall...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online