1 / 11

Introduction to Modeling

Introduction to Modeling. Monte Carlo Simulation. Experience. Simulation. Pros. Cons. Provides “Virtual Experience”. Great teacher Many situations Deal with the unexpected Thorough understanding of processes Broader knowledge. Expensive Not always practical Time consuming

donnellyn
Download Presentation

Introduction to Modeling

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to Modeling Monte Carlo Simulation Experience Simulation Pros Cons Provides “Virtual Experience” • Great teacher • Many situations • Deal with the unexpected • Thorough understanding of processes • Broader knowledge • Expensive • Not always practical • Time consuming • Impossible for all situations • Can be complex More Pros • Expensive • Not always practical • Time consuming • Impossible for all situations • Can be complex • Cheap • Flexible • Fast • Adaptable • Simplifying

  2. Introduction to Modeling Monte Carlo Simulation Key Points of Simulation Models • Allow for interactivity and experimentation by the modeler • Generates a range of possibilities from criteria given rather than optimizing the goal • Applicable to short run, temporary and specific behaviorAnalytic (statistical) models predict average, or steady state, long run behavior • Deals well with uncertainty • Can deal with ‘complicating factors’ that make analytical modeling difficult or impossible to estimate: uncertainty, risk, multiple locations, volatile sales • Inexpensive,relatively simple process using software like Excel and Crystal Ball

  3. Introduction to Modeling Monte Carlo Simulation Monte Carlo Simulation - named for the roulette wheels of Monte Carlo As in roulette, variable values are known with uncertainty Unlike roulette, specific probability distributions define the range of outcomes Crystal Ball - an application specializing in Monte Carlo simulation

  4. Introduction to Modeling Monte Carlo Simulation Normal Distribution Generating Random Variables CRYSTAL BALL: • Generates random variables across a distribution specified by the user • Lets users select distributions from a gallery or generate their own • Generates a report containing all of the model’s assumptions EXAMPLE: Normal Distribution of random variables having a mean value of 3.0 generated by the equation is X2

  5. Introduction to Modeling Monte Carlo Simulation Uniform Distribution Triangle Distribution Custom Distribution Lognormal Distribution Generating Other Distributions

  6. Introduction to Modeling Monte Carlo Simulation • The User • Defines distribution assumptions • Selects the number of trials • Sets the forecast variables • Crystal Ball • Repeats the simulation for the predetermined number of trials • Calculates forecast values for each trial • Reports the results Monte Carlo Simulation Via Crystal Ball 1) Specify the model’s equation(s) 2) Define the variable distributions 3) Define the forecasts 4) Select number of trials 5) Run the Monte Carlo Simulation 6) Interpret the results 7) Make decisions

  7. Introduction to Modeling Monte Carlo Simulation Outcome Frequency Chart - Normal Distribution Outcome Frequency Chart - Lognormal Distribution Distribution of Outcomes Distribution of outcomes depends on the distributions chosen for the assumption variables

  8. Introduction to Modeling Monte Carlo Simulation Sensitivity Analysis and Risk One of Crystal Ball’s best features: it can easily and quickly perform sensitivity and risk analysis. Goal: Determine the likelihood that, given the normal distribution used, the result will equal at least1. Result: Drag the arrow to where the frequency chart equals 1 and the probability will be calculated by Crystal Ball.

  9. Introduction to Modeling Monte Carlo Simulation Sensitivity Analysis and Risk Probability that the result will equal at least 1 is 53.60%

  10. Introduction to Modeling Break-Even Simulation

  11. Introduction to Modeling Decision Tree Simulation

More Related