To learn more about EpiX Analytics' work, please visit our modeling applications, white papers, and training schedule.

Page tree

 

 

This is a typical project risk analysis problem. Let's imagine the following example: A construction company is about to sign a contract for building a hospital in the middle of the city. The government of the city wishes to know the estimate of the duration of the project for some planning purposes. In order to calculate the duration, the project manager has divided the project into several stages, and assigned the most likely values to the duration of each stage:

 

Task

Duration (most likely), weeks

Design

30

Planning

6

Dig holes

5

Archaeological excavation

3

Foundations

12

Walls

22

Roof

7

Services and finishings

15

Commissioning

17

Job over

117

 

Each stage may start only after the previous one is finished and there are no parallel tasks. Thus, summing up the durations of all 9 stages, we get the total duration of the project equal to 117 weeks.

Now the project manager wishes to know the uncertainty around this parameter, as the input estimates are uncertain as well. He assigns the minimum, the most likely and the maximum possible values to the duration of each stage:

 

Task

Minimum (80%)

Most likely

Maximum (150%)

Design

24

30

45

Planning

4.8

6

9

Dig holes

4

5

7.5

Archaeological excavation

2.4

3

4.5

Foundations

9.6

12

18

Walls

17.6

22

33

Roof

5.6

7

10.5

Services and finishings

12

15

22.5

Commissioning

13.6

17

25.5

Job over

93.6

117

175.5

 

We have simplified things here for illustration purposes by making the minimum and maximum value 80% and 150% of the most likely value respectively. In a real problem, the minimum and maximum would be estimated individually. In the most favorable scenario the total duration of the project will not be less than 93.6 week, and in the worst scenario case the duration will not exceed 175.5 weeks.

There are two widely used distributions that are applied in project risk analysis to model expert's opinions. These are the Triangular distribution and the PERT distribution. Both of them take three parameters - minimum, most likely and maximum. Thus, the duration of each stage can be modeled by either of these distributions.

The figure below shows the two way of modeling the "Design" stage:

 

 

In this example we will use the PERT distribution for all stages of the project as it seems to provide a more realistic interpretation of these parameter values. Replacing the most likely values in the project manager's original calculations with distributions, we get the structure as illustrated in this model: Hospital

The links to the Hospital software specific models are provided here:

  hospital

 

The outcome distribution for the total duration is shown below:

 

 

  hospital

 

The outcome distribution for the total duration is shown below:

 

 

As we can see from this graph, the project manager's original estimate of 117 weeks is far from being the expected value. There is only a 100 - 84.19 = 16.81% probability that the total duration will be less than or equal to 117 weeks.

 

This is a very common problem for the project managers that try to estimate the duration of the project. By setting all their estimates to the most likely values they neglect the fact that usually the probability of exceeding the most likely value for a particular stage duration (or cost, in fact) is higher than finishing earlier, i.e. the distribution has a longer tail to the right because in a project there is an absolute minimum time, that any task will take, but life finds a way of introducing any number of obstacles to make that task take a very long time.

 

In this case we've had the minimum as 80% of the most likely and the maximum as 150% of the most likely, so we have a skewed distribution to the right for each of those tasks. As these distributions get added up, the difference between the most likely and the mean value of the sum becomes more and more large.

Generally, when you add a lot of probability distributions together, you get something that looks like a normal distribution (see Central Limit Theory) with the 50th percentile of the Normal distribution pretty much equivalent to the sum of those mean values of the individual task distributions.

 

A rough rule of thumb would be to take the minimum plus 4 times the most likely plus the maximum divided by 6 for each of those tasks. That would give the mean of each of those PERT distributions and their summation would therefore give a rough approximation to the 50th percentile of the total project duration. If you were to use a Triangular distribution then it would be the minimum plus most likely plus maximum divide by 3.

 

Another example of this problem is provided here: Silo. In this model we have tasks that are going in parallel. The discrepancy between our best guess estimate and the actual mean of the distribution becomes greater and greater because when there are parallel tasks we are looking for the maximum duration of parallel path activities. This model is an extension to the previous one and it really shows at a very basic level why risk analysis for projects is very helpful.

The links to the Silo software specific models are provided here:

  silo

  silo

 

 


  • No labels