Project Management with the Critical Path Method
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Project Management with the Critical Path Method
2
3
Instructions: The objective is to minimize the duration of a project of multiple tasks and sequence constraints. The calculation also finds the latest start of tasks subject to the minimum duration. Tasks on the critical path have no slack. This spreadsheet uses the OpenSolver Add-on. The Green cells denote user input, yellow are decision variable determined by the solver, and the red cell is the problem objective.
4
5
Project Duration64
6
Sum of Slacks229
7
Objective6171
<< a weighted difference between project duration and sum of slacks
8
9
EarliestLatest
10
Task DescriptionTask CodeDurStartFinishStartFinishSlackCritical Path?
11
Installing the Construction SiteT01202020Critical Path
12
TerracingT02162182180Critical Path
13
Constructing FoundationsT039182718270Critical Path
14
Access RoadsT0481826293711
15
BasementT0510273727370Critical Path
16
Main FloorT066374337430Critical Path
17
Chaning RoomsT0722628616335
18
Electrifying TerracesT0824345596116
19
RoofT099435243520Critical Path
20
Stadium LightingT1052631596433
21
Installing TerracesT1134346586115
22
Sealing RoofT122525452540Critical Path
23
Finish Changing RoomsT1312829636435
24
Constructing Ticket OfficeT1471825536035
25
Secondary Access RoadsT1542630606434
26
SignallingT1634649616415
27
Lawn and AccessoriesT179546354630Critical Path
28
Handing OverT181636463640Critical Path
29
FinishFinish0646464640Critical Path
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Tasks
__OpenSolver__
Sequencing