A Deep Dive into PERT Estimation

PERT: What is it?

PERT is an acronym for Program Evaluation & Review Technique, and was developed by United States Defence as a quick estimating strategy in 1950’s. It is also known as Three-Point technique or PERT Weighted Average. PERT can be used to apply to Costs, and Schedules. 

Understanding the PERT Estimation

PERT emphasis on Three-Point estimate for each Project activity incorporating Optimistic(O), Pessimistic (P), and Most Likely (M) time estimates.

The Formula to Calculate Expected Duration (TE) for an activity is 

TE = O+4M+P

                6

This formula considers a weighted average, giving more weight to the most likely estimate. The resulting Expected Duration provides a more realistic view of the time required for an activity, considering both optimistic and pessimistic scenarios.

Key Components of PERT Estimation

Optimistic estimates (O):

The best-case scenario estimate, representing the minimum time required to complete an activity without any risks and favorable situation.

Pessimistic Estimate (P):

The worst-case scenario estimate, indicating the maximum time needed for activity completion Including Risks and an unfavorable situation.

Most Likely Time (M):

The most realistic and probable time estimate based on historical data and expert judgment, including favorable & unfavorable situations.

Let’s look at an example below. 

Table 1

Note: The above Activities can be broken down into smaller tasks. I have taken an Abstract of Activities for Illustration only.

Let’s Assume the Project Start Date as 06-Dec-2023

Table 2

Note: Some of the above dates fall on Weekends, and this is just for Illustration Only

Now, let’s build a Timeline Chart using Table 2.

To Create the Timeline Chart in Google Sheets

1. Select the above Table 2 (Data Range i.e Sheet1!C16:G22) in the example (Attached Google Sheet Below for Reference)
2. Click on Insert → Select & Click on Timeline 
   
3. Map the Column from Table 2 on Required fields (Settings) on the left pane to the following
   • Start Date -> Start Date
   • End Date or Duration -> End Date
   • Card Title -> Activities

Timeline Chart in Google Sheet

Link to the spreadsheet: PERT Estimation_Example

Benefits of PERT Estimation

1. Probability Analysis: PERT estimation embraces a probabilistic methodology, offering a spectrum of potential durations for each activity. This contributes to the assessment and management of risks within the project.
2. Improved Accuracy: PERT estimation provides a more detailed and precise depiction of project timelines when contrasted with conventional single-point estimates.
3. Effective Resources Allocation: Project managers can better allocate resources by understanding the variability in activity durations. This promotes optimal resource utilization.
4. Risk Mitigation: PERT estimation highlights critical path activities and potential bottlenecks, allowing project teams to focus on risk mitigation strategies.

By embracing the three-point/PERT estimation methodology, Project Managers/Sales/Developers/Testers can navigate uncertainties, enhance decision-making, and steer their teams toward successful project completion. PERT estimation is not merely a mathematical tool; it’s a strategic ally in the pursuit of project success, offering a holistic view that empowers teams to adapt, innovate, and thrive in the face of complexity.