1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
A B C D E F G H I J K L M N
Template for PERT Three-Estimate Approach
Time Estimates On Mean
Activity o m p Critical Path
ms2Range Name Cells
A1.5 215 *4.083 5.0625 Mean Critical Activity B5:B18
B 2 3.5 21 6.167 10.0278 Path ActivityMean G5:G18
C 1 1.5 18 4.167 8.02778
m = 17.083 ActivityVariance H5:H18
D0.5 115 3.25 5.84028
s2 = 25.34 CompletionProbability K10
E 3 5 24 *7.833 12.2500 CriticalPathMean K7
F 1 2 16 4.167 6.25
P(T<=d) =
0.8356 CriticalPathVariance K8
G0.5 114 3.083 5.0625 where d K12
H2.5 3.5 25 6.917 14.0625 d = 22 m D5:D18
I 1 3 18 *5.167 8.02778 o C5:C18
J 2 3 18 5.333 7.11111 OnMeanCriticalPath F5:F18
p E5:E18
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
A B C D E F G H I J K L M N
Template for PERT Three-Estimate Approach
Time Estimates On Mean
Activity o m p Critical Path
ms2Range Name Cells
A1.5 215 *4.083 5.0625 Mean Critical Activity B5:B18
B 2 3.5 21 6.167 10.0278 Path ActivityMean G5:G18
C 1 1.5 18 *4.167 8.02778
m = 17.583 ActivityVariance H5:H18
D0.5 115 3.25 5.84028
s2 = 27.368 CompletionProbability K10
E 3 5 24 7.833 12.2500 CriticalPathMean K7
F 1 2 16 *4.167 6.25
P(T<=d) =
0.8007 CriticalPathVariance K8
G0.5 114 3.083 5.0625 where d K12
H2.5 3.5 25 6.917 14.0625 d = 22 m D5:D18
I 1 3 18 *5.167 8.02778 o C5:C18
J 2 3 18 5.333 7.11111 OnMeanCriticalPath F5:F18
p E5:E18
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
A B C D E F G H I J K L M N
Template for PERT Three-Estimate Approach
Time Estimates On Mean
Activity o m p Critical Path
ms2Range Name Cells
A1.5 215 4.083 5.063 Mean Critical Activity B5:B18
B 2 3.5 21 *6.167 10.028 Path ActivityMean G5:G18
C 1 1.5 18 4.167 8.028
m = 17.833 ActivityVariance H5:H18
D0.5 115 *3.25 5.840
s2 = 28.042 CompletionProbability K10
E 3 5 24 7.833 12.250 CriticalPathMean K7
F 1 2 16 4.167 6.250
P(T<=d) =
0.7843 CriticalPathVariance K8
G0.5 114 *3.083 5.063 where d K12
H2.5 3.5 25 6.917 14.063 d = 22 m D5:D18
I 1 3 18 5.167 8.028 o C5:C18
J 2 3 18 *5.333 7.111 OnMeanCriticalPath F5:F18
p E5:E18
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
A B C D E F G H I J K L M N
Template for PERT Three-Estimate Approach
Time Estimates On Mean
Activity o m p Critical Path
ms2Range Name Cells
A1.5 215 4.083 5.063 Mean Critical Activity B5:B18
B 2 3.5 21 *6.167 10.028 Path ActivityMean G5:G18
C 1 1.5 18 4.167 8.028
m = 18.417 ActivityVariance H5:H18
D0.5 115 3.25 5.840
s2 = 31.201 CompletionProbability K10
E 3 5 24 7.833 12.250 CriticalPathMean K7
F 1 2 16 4.167 6.250
P(T<=d) =
0.7394 CriticalPathVariance K8
G0.5 114 3.083 5.063 where d K12
H2.5 3.5 25 *6.917 14.063 d = 22 m D5:D18
I 1 3 18 5.167 8.028 o C5:C18
J 2 3 18 *5.333 7.111 OnMeanCriticalPath F5:F18
p E5:E18
16.18d
1
2
3
4
5
6
7
8
9
10
A B C D E F G H I J
Normal Crash Maximum Time Crash Cost
Time Time Normal Crash Reduction per Month Start Time Finish
Activity (months) (months) Cost Cost (months) Saved Time Reduction Time
A 8 5 $25,000 $40,000 3 $5,000 0 0 8
B 9 7 $20,000 $30,000 2 $5,000 0 2 7
C 6 4 $16,000 $24,000 2 $4,000 8 2 12
D 7 4 $27,000 $45,000 3 $6,000 7 2 12
Max Time
Project Completion Time (months) 12 <= 12
Total Cost $118,000
16.18e (T≤11)
1
2
3
4
5
6
7
8
9
10
A B C D E F G H I J
Normal Crash Maximum Time Crash Cost
Time Time Normal Crash Reduction per Month Start Time Finish
Activity (months) (months) Cost Cost (months) Saved Time Reduction Time
A 8 5 $25,000 $40,000 3 $5,000 0 1 7
B 9 7 $20,000 $30,000 2 $5,000 0 2 7
C 6 4 $16,000 $24,000 2 $4,000 7 2 11
D 7 4 $27,000 $45,000 3 $6,000 7 3 11
Max Time
Project Completion Time (months) 11 <= 11
Total Cost $129,000
16.18e (T≤13)
1
2
3
4
5
6
7
8
9
10
A B C D E F G H I J
Normal Crash Maximum Time Crash Cost
Time Time Normal Crash Reduction per Month Start Time Finish
Activity (months) (months) Cost Cost (months) Saved Time Reduction Time
A 8 5 $25,000 $40,000 3 $5,000 0 0 8
B 9 7 $20,000 $30,000 2 $5,000 0 2 7
C 6 4 $16,000 $24,000 2 $4,000 8 1 13
D 7 4 $27,000 $45,000 3 $6,000 7 1 13
Max Time
Project Completion Time (months) 13 <= 13
Total Cost $108,000
16.19c
A B C D E F G H I J
Normal Crash Maximum Time Crash Cost
Time Time Normal Crash Reduction per Day Start Time Finish
Activity (days) (days) Cost Cost (days) Saved Time Reduction Time
A12 9 $210,000 $270,000 3 $20,000 0 0 12
B23 18 $410,000 $460,000 5 $10,000 0 3 20
C15 12 $290,000 $320,000 3 $10,000 12 324
D27 21 $440,000 $500,000 6 $10,000 20 047
E18 14 $350,000 $410,000 4 $15,000 24 141
F 6 4 $160,000 $210,000 2 $25,000 41 047
Max Time
Project Completion Time (days) 47 <= 47
Total Cost $1,935,000
Page 8
16.20c (T≤12)
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J K
Normal Crash Maximum Time Crash Cost
Time Time Normal Crash Reduction per Week Start Time Finish
Activity (weeks) (weeks) Cost Cost (weeks) Saved Time Reduction Time
A 3 2 $54,000 $60,000 1 $6,000 0 0 3
B 4 3 $62,000 $65,000 1 $3,000 4 0 8
C 5 2 $66,000 $70,000 3 $1,333 3 0 8
D 3 1 $40,000 $43,000 2 $1,500 9 0 12
E 4 2 $75,000 $80,000 2 $2,500 8 0 12
Max Time
Project Completion Time (weeks) 12 <= 12
Total Cost $297,000
Page 9
16.20c (T≤11)
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J K
Normal Crash Maximum Time Crash Cost
Time Time Normal Crash Reduction per Week Start Time Finish
Activity (weeks) (weeks) Cost Cost (weeks) Saved Time Reduction Time
A 3 2 $54,000 $60,000 1 $6,000 0 0 3
B 4 3 $62,000 $65,000 1 $3,000 3 0 7
C 5 2 $66,000 $70,000 3 $1,333 3 1 7
D 3 1 $40,000 $43,000 2 $1,500 8 0 11
E 4 2 $75,000 $80,000 2 $2,500 7 0 11
Max Time
Project Completion Time (weeks) 11 <= 11
Total Cost $298,333
Page 10
16.20c (T≤10)
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J K
Normal Crash Maximum Time Crash Cost
Time Time Normal Crash Reduction per Week Start Time Finish
Activity (weeks) (weeks) Cost Cost (weeks) Saved Time Reduction Time
A 3 2 $54,000 $60,000 1 $6,000 0 0 3
B 4 3 $62,000 $65,000 1 $3,000 3 0 7
C 5 2 $66,000 $70,000 3 $1,333 3 1 7
D 3 1 $40,000 $43,000 2 $1,500 7 0 10
E 4 2 $75,000 $80,000 2 $2,500 7 1 10
Max Time
Project Completion Time (weeks) 10 <= 10
Total Cost $300,833
Page 11
16.20c (T≤9)
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J K
Normal Crash Maximum Time Crash Cost
Time Time Normal Crash Reduction per Week Start Time Finish
Activity (weeks) (weeks) Cost Cost (weeks) Saved Time Reduction Time
A 3 2 $54,000 $60,000 1 $6,000 0 0 3
B 4 3 $62,000 $65,000 1 $3,000 3 0 7
C 5 2 $66,000 $70,000 3 $1,333 3 1 7
D 3 1 $40,000 $43,000 2 $1,500 7 1 9
E 4 2 $75,000 $80,000 2 $2,500 7 2 9
Max Time
Project Completion Time (weeks) 9 <= 9
Total Cost $304,833
Page 12
16.20c (T≤8)
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J K
Normal Crash Maximum Time Crash Cost
Time Time Normal Crash Reduction per Week Start Time Finish
Activity (weeks) (weeks) Cost Cost (weeks) Saved Time Reduction Time
A 3 2 $54,000 $60,000 1 $6,000 0 0 3
B 4 3 $62,000 $65,000 1 $3,000 3 1 6
C 5 2 $66,000 $70,000 3 $1,333 3 2 6
D 3 1 $40,000 $43,000 2 $1,500 6 1 8
E 4 2 $75,000 $80,000 2 $2,500 6 2 8
Max Time
Project Completion Time (weeks) 8 <= 8
Total Cost $309,167
Page 13
16.21
A B C D E F G H I J
Crash Cost
Normal Crash Normal Crash Maximum Time per Week
Time Time Cost Cost Reduction Saved Start Time Finish
Activity (weeks) (weeks) ($million) ($million) (weeks) ($million) Time Reduction Time
A 5 3 20 30 2 5 0 2 3
B 3 2 10 20 110 0 1 2
C 4 2 16 24 2 4 3 0 7
D 6 3 25 43 3 6 3 0 9
E 5 4 22 30 1 8 2 0 7
F 7 4 30 48 3 6 2 0 9
G 9 5 25 45 4 5 7 1 15
H 8 6 30 44 2 7 9 2 15
Max Time
Project Completion Time (weeks) 15 <= 15
Total Cost ($million) 217
Page 14
16.22
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
A B C D E F G H I J
Crash Cost
Normal Crash Normal Crash Maximum Time per Week
Time Time Cost Cost Reduction Saved Start Time Finish
Activity (weeks) (weeks) ($million) ($million) (weeks) ($million) Time Reduction Time
A32 28 160 180 4 5 0 0 32
B28 25 125 146 3 7 0 3 25
C36 31 170 210 5 8 32 068
D16 13 60 72 3 4 25 041
E32 27 135 160 5 5 26 058
F54 47 215 257 7 6 25 376
G17 15 90 96 2 3 41 058
H20 17 120 132 3 4 58 078
I34 30 190 226 4 9 58 092
J18 16 80 84 2 2 76 292
Max Time
Project Completion Time (weeks) 92 <= 92
Total Cost ($million) 1,388
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J K L M N
Template for PERT/Cost
Estimated
Duration Estimated Start Cost Per Week Week Week Week Week Week Week Week Week
Activity (weeks) Cost Time of Its Duration 1 2 3 4 5 6 7 8
A 3 $54,000 0 $18,000 $18,000 $18,000 $18,000 $0 $0 $0 $0 $0
B 3 $65,000 3 $21,667 $0 $0 $0 $21,667 $21,667 $21,667 $0 $0
C 3 $68,667 3 $22,889 $0 $0 $0 $22,889 $22,889 $22,889 $0 $0
D 2 $41,500 6 $20,750 $0 $0 $0 $0 $0 $0 $20,750 $20,750
E 2 $80,000 6 $40,000 $0 $0 $0 $0 $0 $0 $40,000 $40,000
Weekly Project Cost $18,000 $18,000 $18,000 $44,556 $44,556 $44,556 $60,750 $60,750
Cumulative Project Cost $18,000 $36,000 $54,000 $98,556 $143,111 $187,667 $248,417 $309,167
1
2
3
4
5
6
7
8
9
10
11
12
13
14
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Template for PERT/Cost
Estimated Estimated Cost Per Week all costs in $thousands
Duration Cost Start of Its Duration Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week
Activity
(weeks) ($thousands) Time ($thousands) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
A 6 420 070 70 70 70 70 70 70 00000000000000
B 2 180 090 90 90 000000000000000000
C 4 540 6135 000000135 135 135 135 0000000000
D 5 360 672 00000072 72 72 72 72 000000000
E 7 590 10 84.286 0 0 0 0 0 0 0 0 0 0 84.29 84.29 84.29 84.29 84.29 84.29 84.29 0 0 0
F 9 630 11 70 0000000000070 70 70 70 70 70 70 70 70
Weekly Project Cost ($thousands) 160 160 70 70 70 70 207 207 207 207 156.3 154.3 154.3 154.3 154.3 154.3 154.3 70 70 70
Cumulative Project Cost ($thousands) 160 320 390 460 530 600 807 1014 1221 1428 1584 1739 1893 2047 2201 2356 2510 2580 2650 2720
1
2
3
4
5
6
7
8
9
10
11
12
13
14
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Template for PERT/Cost
Estimated Estimated Cost Per Week all costs in $thousands
Duration Cost Start of Its Duration Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week
Activity
(weeks) ($thousands) Time ($thousands) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
A 6 420 070 70 70 70 70 70 70 00000000000000
B 2 180 490 000090 90 00000000000000
C 4 540 9135 000000000135 135 135 135 0000000
D 5 360 672 00000072 72 72 72 72 000000000
E 7 590 13 84.286 000000000000084.29 84.29 84.29 84.29 84.29 84.29 84.29
F 9 630 11 70 0000000000070 70 70 70 70 70 70 70 70
Weekly Project Cost ($thousands) 70 70 70 70 160 160 72 72 72 207 207 205 205 154.3 154.3 154.3 154.3 154.3 154.3 154.3
Cumulative Project Cost ($thousands) 70 140 210 280 440 600 672 744 816 1023 1230 1435 1640 1794 1949 2103 2257 2411 2566 2720
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Template for PERT/Cost
Estimated Estimated Cost Per Week all costs in $thousands
Duration Cost Start of Its Duration Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week
Activity (weeks) ($thousands) Time ($thousands) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
A 6 180 030 30 30 30 30 30 30 00000000000000
B 3 75 025 25 25 25 00000000000000000
C 4 120 030 30 30 30 30 0000000000000000
D 4 140 635 00000035 35 35 35 0000000000
E 7 175 325 00025 25 25 25 25 25 25 0000000000
F 4 80 420 000020 20 20 20 000000000000
G 6 210 435 000035 35 35 35 35 35 0000000000
H 3 45 10 15 000000000015 15 15 0000000
I 5 125 625 00000025 25 25 25 25 000000000
J 4 100 10 25 000000000025 25 25 25 000000
K 3 60 820 0000000020 20 20 000000000
L 5 50 10 10 000000000010 10 10 10 10 00000
M 6 90 14 15 0000000000000015 15 15 15 15 15
N 5 150 15 30 00000000000000030 30 30 30 30
Weekly Project Cost ($thousands) 85 85 85 85 110 110 140 140 140 140 95 50 50 35 25 45 45 45 45 45
Cumulative Project Cost ($thousands) 85 170 255 340 450 560 700 840 980 1120 1215 1265 1315 1350 1375 1420 1465 1510 1555 1600
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Template for PERT/Cost
Estimated Estimated Cost Per Week all costs in $thousands
Duration Cost Start of Its Duration Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week Week
Activity (weeks) ($thousands) Time ($thousands) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
A 6 180 130 030 30 30 30 30 30 0000000000000
B 3 75 025 25 25 25 00000000000000000
C 4 120 030 30 30 30 30 0000000000000000
D 4 140 735 000000035 35 35 35 000000000
E 7 175 325 00025 25 25 25 25 25 25 0000000000
F 4 80 820 0000000020 20 20 20 00000000
G 6 210 435 000035 35 35 35 35 35 0000000000
H 3 45 11 15 0000000000015 15 15 000000
I 5 125 925 00000000025 25 25 25 25 000000
J 4 100 10 25 000000000025 25 25 25 000000
K 3 60 12 20 00000000000020 20 20 00000
L 5 50 10 10 000000000010 10 10 10 10 00000
M 6 90 14 15 0000000000000015 15 15 15 15 15
N 5 150 15 30 00000000000000030 30 30 30 30
Weekly Project Cost ($thousands) 55 85 85 85 90 90 90 95 115 140 115 95 95 95 45 45 45 45 45 45
Cumulative Project Cost ($thousands) 55 140 225 310 400 490 580 675 790 930 1045 1140 1235 1330 1375 1420 1465 1510 1555 1600