Monte Carlo Simulation for Dummies

Monte Carlo for Dummies1 Monte Carlo Simulation for DummiesCursory discussions with young project managers reveal a simple yet concerning fact. Most project managers are aware of the need to identify and manage project risks and most will be aware of the need to establish and publish a project risk register. That’s the good news. Where most inexperienced project managers fail is in their lack of understanding of the need to rigorously manage project risks arising inherently from their project schedule.

A short example can illustrate the issue quite clearly. Assume your project has 5 tasks, each estimated with a confidence level of 90%. Based on the above, would you say that your overall chances of meeting your project target delivery date are 90%? You might intuitively say ‘Yes’ but then you’ll be wrong. The correct answer is actually less than 60% (being the product of the following calculation: 0.9 x 0.9 x 0.9 x 0.9 x 0.9 = 0.59). So, in this example, if you were confidently managing your project, expecting a very high chance of meeting your deadline, you could be up for a surprise when some of the odds start playing against you.

The initial lesson from this example is that as a project manager you need to understand and manage the risks inherently built into your schedule. These risks require the least brainstorming or group discussions as they are directly and explicitly jump out of your project schedule and as such should be the most apparent ones.

The reality of most projects is that they will have a substantially larger number of tasks about them than the example above. Not only will the average project have substantially more tasks, each task is likely to have varying degrees of confidence levels, such that establishing an overall project scheduling risk factor will be far more complicated.

A simplistic approach for taking scheduling confidence into account is the PERT (also known as Three Point Estimate) technique. This technique uses three estimates to define an approximation of the activity’s duration (and cost). This technique works as follows: Determine your Optimistic (O), Pessimistic (P) and Most Likely (M) estimates for each activity. Having determined these parameters calculate the expected activity duration using a weighted average of the three parameters, based on the following formula:

Expected activity duration = (O + 4M + P) / 6.

The reason I referred to this approach as being “simplistic” is because despite its elegant look, it is statistically incorrect, due primarily to the fact that it assumes that the duration of each activity can be determined independently from all other activities, which is hardly ever the case.

This is the point where using Monte Carlo Analysis can come handy. Rather than using the simplistic approach suggested by the PERT technique, the Monte Carlo Analysis technique utilizes the three estimates to repeatedly simulate the project’s completion date, while taking into account the statistical likelihood that each activity’s duration will be somewhere on the continuum between the three estimates. The result of this analysis will not be a definitive answer, i.e. the answer will not be in the form of “based on the individual activity duration estimates, the project is expected to finish of date X”. Rather, the answer will be in the form of “based on the individual activity duration estimates, there is X% chance that the project will be complete on or before date Y”.

The chart below was produced using a Monte Carlo Simulation software, and highlights the type of outputs that such a tool will produce. Let’s examine the chart and understand its content. The overall purpose of the chart is to present the likelihood (or a better term – probability) of the project completing on any particular date. The left axis (Hits) can be used to review the number of times, during the simulation, that a particular date was identified as a potential completion date. The right axis (Cumulative Frequency) shows the total accumulative times that the project was determined to complete on or before a particular date. The bottom axis (Distribution) shows the identified potential completion dates, while the height of the bar associated with that date is determined by the number of times that the date has been identified by the simulation as being the project’s completion date.

In this example, having analyzed the project activity durations, the following statements can now be made:

  • Based on the individual activity duration estimates, there is 80% chance that the project will be complete on or before 21/05/02.
  • Based on the individual activity duration estimates, there is 50% chance that the project will be complete on or before 15/05/02.

Mone Carlo Simulation1 Monte Carlo Simulation for Dummies

By the way, if you notice the yellow arrow, pointing at 08/05/02, this is the date shown as the project completion date on the project plan. Now that we’ve performed the risk analysis we can determine that our chances of actually finishing the project on or before that date are just 15%!

As the name of this post suggests, there is much more to Monte Carlo Simulation software than what I’ve presented here. The above, however, highlights the fundamental need to consider project scheduling risks as if you don’t they WILL come back to haunt you.

Can you see how this type of analysis can help you better manage your project risks?

I value your comments, if you have any thoughts on the above please join in and share with others!

Here is a list of relevant articles you might want to read:

pixel Monte Carlo Simulation for Dummies

No related posts.

17 Comments

  1. Glen B. Alleman says:

    Shim,

    Great overview. Just a couple of details.

    1. The five tasks you describe have to be in series for the math to work. In series, the 90% confidence level must also have a level probability distribution, so the 90% has a 10% uncertainty.

    2. The term “confidence” should be replaced with “variability.” Confidence is a scalar measure that does not describe the underlying statistical behavior of the task duration. This variability is described by the means and standard deviation of the probability distribution function – the shape of the statistical function that generates the random variables of the duration.

    3. The PERT approach not only assumes independence, more importantly the standard deviation is predefined and the distribution is symmetric. Neither of which are true in practice.

    4. The actual phrase for the probability of completion is “there is an 80% confidence of completing on or before at date.” Since the PDF shown in the example is a cumulative distribution function. What it says – in the sampling population, 80% of the random completion dates finish on or before a date.

    5. The 3 point samples can be used for the Monte Carlo Simulations as well. The MCS can also used a Most Likely (the mode) and the statistical upper and lower limit for a specific probability distribution function (pdf). The triangle distribution is a common one for projects that don’t have historical information.

  2. Shim Marom says:

    Refreshed my post on "Monte Carlo for Dummies" #pmot http://quantmleap.com/blog/?p=346.

  3. Nirav Patel says:

    RT @shim_marom: Refreshed my post on "Monte Carlo for Dummies" #pmot http://quantmleap.com/blog/?p=346.

  4. Shim Marom says:

    Cheers mate RT @niravbpatel RT @shim_marom: Refreshed my post on "Monte Carlo for Dummies" #pmot http://quantmleap.com/blog/?p=346.

  5. Bob Marshall says:

    TR @TopsyRT: Monte Carlo Simulation for Dummies http://bit.ly/b7MZcI

  6. missdblue says:

    RT @TopsyRT: Monte Carlo Simulation for Dummies http://bit.ly/b7MZcI (via @flowchainsensei)

  7. missdblue (missdblue) says:

    Twitter Comment


    RT @TopsyRT: Monte Carlo Simulation for Dummies [link to post] (via @flowchainsensei)

    Posted using Chat Catcher

  8. flowchainsensei (Bob Marshall) says:

    Twitter Comment


    TR @TopsyRT: Monte Carlo Simulation for Dummies [link to post]

    Posted using Chat Catcher

  9. missdblue (missdblue) says:

    Twitter Comment


    RT @TopsyRT: Monte Carlo Simulation for Dummies [link to post](via @flowchainsensei)

    Posted using Chat Catcher

  10. Shim Marom says:

    Thanks for @missdblue and @flowchainsensei got yout TY on Monte Carlo for Dummies http://ow.ly/282iu and http://ow.ly/282iT #pmot

  11. jenshoffmann says:

    Manage schedule risk effectively with Monte Carlo Simulation for Dummies: http://bit.ly/d4cJ5k

  12. Shim Marom says:

    RT @jenshoffmann: Manage schedule risk effectively with Monte Carlo Simulation for Dummies: http://bit.ly/d4cJ5k

  13. Shim Marom says:

    quantmleap: Monte Carlo Simulation for Dummies http://is.gd/fIFkn #pmot #ftpm #pmp

  14. Leslie Wiser says:

    RT @shim_marom: quantmleap: Monte Carlo Simulation for Dummies http://is.gd/fIFkn #pmot #ftpm #pmp

  15. RT @shim_marom: quantmleap: Monte Carlo Simulation for Dummies http://is.gd/fIFkn #pmot #ftpm #pmp

  16. Shim Marom says:

    Points taken mate, thanks.

Leave a Reply


+ 2 = eleven

CommentLuv badge