Project 2007: Estimating Task Durations Using the PERT Formula (Part 1 of 2)

PERT Analysis uses a weighted average of three duration estimates to calculate an estimated duration for a task. This is a great tool when you don't have a specific duration but do have duration estimates from reliable sources. Who are reliable sources? A reliable source is anyone (or anything) with experience working with this type of task, including, but not limited to, skilled project managers, the people who will be performing the work, and even the data logs of a resource like a machine (to find out how fast the equipment can get the job done).

You can use the Estimated Duration formula to manually calculate a task's duration the same way Office Project 2007 would. To properly estimate task durations (either manually or using Office Project 2007), you'll need access to three numbers:

• Expected Time
• Most Pessimistic Time
• Most Optimistic Time

With these three numbers, you and Office Project 2007 can create accurate task estimate durations. Each of these numbers holds a weighted average in Office Project 2007.

• The Most Optimistic and Most Pessimistic times each hold a weight of one (or 16.66 percent each).
• The Expected Time holds a weight of four (or 66.67 percent).

Although you might think that understanding how to manually calculate a task's duration isn't important (because you can have Office Project 2007 do it for you), it really is something you need to know. You should be able to tell by looking at the results of the PERT analysis if the duration is approximately where it should be. You can know this only if you know how to calculate the task duration manually.

When plugged into the following formula, you can calculate estimated durations just like Office Project 2007: Estimated Duration = ((Optimistic+Pessimistic+(4*Expected))/6

After you get the hang of manually calculating task duration estimates, you're ready to move to using Microsoft Office Project's PERT Analysis feature. The calculation you worked with when manually calculating estimated durations is the same calculation that Office Project uses. This means that you'll still need access to three numbers: Expected Time, Pessimistic Time, and Optimistic Time.

To begin, you'll need to display the PERT Analysis toolbar. You do this by clicking View, choosing Toolbars, and choosing PERT Analysis.

After you display the PERT Analysis toolbar, you can use the Pert Entry Form button to calculate estimated task durations based on the most optimistic, most pessimistic, and expected durations you enter.To calculate an estimated task duration using the PERT Analysis toolbar, follow these steps:

1. On the PERT Analysis toolbar, click the PERT Entry Form button (it's the fifth one from the right).
2. In the PERT Entry dialog box, type a number for the Optimistic, Expected, and Pessimistic durations.
3. Click OK.

With permission from Microsoft Press, this article content was excerpted from the book, Managing Projects with Microsoft Office Project 2007 (Self-Paced Training Kit for Exam 70-632).