Critical-Path Analysis For Network Scheduling (Page 6 of 12) in pdf

Critical-Path Analysis For Network Scheduling Page 6

Critical Path Model on a Spreadsheet

Delay

The spreadsheet file (“CPM.xls”) represents a template for CPM analysis with one row for each activity. The

data for an activity are represented in columns. The shaded cells include formulas while the white cells are user

inputs pertaining to the activity ID, Name, Duration, Cost, IDs of 3 predecessors, IDs of 3 successors, and a

Delay value. The total project duration (32 days) is also included in a separate cell at the top of the spreadsheet.

Any change in the duration of any activity or the logical relationships automatically changes the project duration

along with all the CPM data regarding the activities’ early and late times as well as the total floats, which identify

critical and non-critical activities. Experiment with different option and see their impact on the schedule.

Critical-Path Analysis For Network Scheduling Page 6