21-11-2012, 01:35 PM
PERT/CPM CALCULATIONS
pert2.ppt (Size: 1.07 MB / Downloads: 287)
About This Training Module
This training module was crafted using PowerPoint by Microsoft Corporation. It has been packaged with PowerPoint Viewer, a standalone Microsoft product that allows a user to view this module without use of PowerPoint.
Training Module Preview
This module will provide:
Introduction to manually calculating key Project Management functions (both PERT and CPM)
Introduction to using MS Excel to calculate key functions (PERT and Risk analysis)
Step-by step instruction on building a PERT risk analysis calculator using MS Excel
Use of PERT and CPM traditional techniques to manually lay out a project
This module is constructed as the second block in a building block approach
PERT Calculations - Simplicity
Simple steps in a logical order
Step 1: Define tasks
Step 2: Place Tasks in a logical order, find the critical path
The longest time path through the task network. The series of tasks (or even a single task) that dictates the calculated finish date
Step 3: Generate estimates
Optimistic, pessimistic, likely and PERT- expected
Standard Deviation and variance
Step 4: Determine earliest and latest dates
Step 5etermine probability of meeting expected date
Steps 1 and 2 are logic and legwork, not calculation – these require a clear goal
Constructing the Spreadsheet
Be sure to adjust formulae as necessary when adding additional tasks
If a error message shows up check cell addresses in the formulae first – formulae must reflect intent
This set of formulae mirrors the manual calculations but takes less time for the user
Because PERT is a probabilistic approach, these formulae can deliver a 100% probability – but no plan is perfect – these are always estimates
Never feel there is a 100% probability of a project completing on the estimated date