Project Scenarios-What if Analysis


Project conception and monitoring involve estimation risks. Estimates are uncertain. Expert judgement is used to quantify these. 
However hard we plan, there would always be some random variations. Let us explore the “what if” in the forecast group at data tab.  Scenario manager here is helpful in creating various project (probable) outcomes.  
This concept is best understood using an example. Click here to download the workbook.
You need to solve it to get a grip over it.
Do the followings.
  1. Use “Goal seek” to create the various break-even quantities
  2. Use “data table” to vary two variables at a time
  3. Create a “Scenario Summary” with most likely, Optimistic and Pessimistic quantities.
  4.   Run Monte Carlo simulation.

These tricks allow great possibilities to a problem solver. Your comments to simplify and further explore it are welcome.



Comments

Popular posts from this blog

Using Excel Solver Feature to analyze and optimize the Steel Truss Design.

Using Excel conditional formatting for comparative statements

Using Excel's Forecast Sheet Feature for Construction & Life Cycle Parameters