Using Simulation to Develop S-curves

There are two commercially available products that can be used to run Monte Carlo (random number) simulations: @Risk and Crystal Ball. These programs use your Excel model as a calculation engine, and you specify the input distributions for each uncertainty that you want to use and then specify the measures of value that you want to examine. Once you’ve run the simulation, you can extract the data and develop a graph similar to the one in Figure 9.3. As these products have been extensively written about elsewhere,1 I’m not going to provide step-by-step instructions on how to operate the software.

The advantage of using one of the commercial programs is that you can set up the simulation much more quickly ...

Get Decision Analysis for Managers now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.