Project Scenarios-What if Analysis

By -

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

  1. saivenkatJanuary 15, 2021 at 10:57 PM

    This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
    Billing Software

    ReplyDelete

Post a Comment

Popular posts from this blog

Decision Making Through Life Cycle Costing- A Simple Practical Example

By -
Decision Making Through  Life Cycle Costing- A Simple Practical Example Problem Statement: To compare the life cycle costing by calculating the single Present  Value for different scenarios. A choice is required to be made for air conditioning by Installing AC only Installing AC along with insulation works and solar film . The variables would be the Initial costs and the Cost of Capital. The link below would take you to the Excel worksheet wherein the comments in each cell would make you understand the process fully. It is assumed that the user is a knowledge worker and the input parameters have been evaluated through experts. Excel Workbook has been set in a manner that is fit for a novice excel user. Download The Excel File Related Article - THE ECONOMY OF ENERGY EFFICIENT BUILDINGS; AN INDIAN PERSPECTIVE
Read more

WHY USE MS PROJECT FOR SCHEDULING AND MONITORING CONSTRUCTION PROJECTS?

By -
To begin with the single most important reason to adopt the MS Project is that activity sequencing with it is very easy. It is here assumed that your team is already using other MS office applications (2007 or later). The initiation of schedule preparation with MS Project would give rich dividends and justify additional cost and effort on this account only. In Indian scenario especially at locations where construction projects have suddenly grown both in size and complexities, gaining maturity in professional scheduling/work sequencing can be a boon. The construction projects scenario here can be summed up as below. 1.        Projects are getting more complex. 2.        Numerous sub consultants and subject matter experts are involved. 3.    Construction Industry has a tradition of consultants working in silos. 4.        Works have to be got done through subcontracting. if you have been in a complex building construction team, it is obvious to you that inadequate
Read more

Data Validation

By -
As a default, you can fill in just any text or Number etc. in any cell of your worksheet. Databases and solutions however demand reliability.  The Data validation feature just does that. For example you might want to dictate the following rules to your electronic measurement book.
Read more