Schedule contingency analysis for transit projects using a simulation approach.
Gurgun, Asli Pelin ; Zhang, Ye ; Touran, Ali 等
Table 1. Case study project schedule analysis (phases are
expressed in "years")
Original project duration
by phase (years)
A B C D E
Project PE/
Number Case study projects FEIS FD Construction
1 Atlanta North Line 1 3 6
Extension
2 Boston Old Colony 1 6 2
Rehabilitation
3 Boston Silver Line 1 1 10
(Phase 1)
4 Chicago Southwest 2 3 3
Extension
5 Dallas South Oak 2 1 3
Cliff Extension
6 Denver Southwest 4 1 3
Line
7 Los Angeles Red 5 1
Line MOS 1
8 Los Angeles Red 7 4
Line MOS 2
9 Los Angeles Red 10 5
Line MOS 3
10 Minneapolis 6 1 4
Hiawatha Line
11 New-Jersey Hudson- 3 1 5
Bergen MOS1
12 New York 63rd 3 2 7
Street Connector
13 Pasadena Gold Line 3 4 3
14 Pittsburgh Airport 2 1 7
Busway (Phase 1)
15 Portland Airport 2 4
MAX Extension
16 PortlandBanfield 3 1
Corridor
17 Portland Interstate 1 2 2
MAX
18 Portland Westside/ 1 3 4
Hillsboro MAX
19 Salt Lake North- 1 3 1
South Line
20 San Fransisco SFO 4 1 6
Airport Exten.
21 San Juan Tren Urbano 3 1 8
22 Santa Clara Capitol 1 4
Line
23 Santa Clara Tasman 3 4 2
East Line
24 Santa Clara Tasman 1 3 3
West Line
25 Santa Clara Vasona 1 5
Line
26 Seattle Busway Tunnel 1 3 3
27 St Louis Saint 3 1 2
Clair Corridor
28 Washington Largo 3 1 4
Extension
Approximate project delay by
phase (years)
A F G H I
Original total
project duration PE/
Project (Col.C + Col.D + FEIS FD Construction
Number Col.E) delay delay delay
1 10 0 0 4
2 9 1 2 0
3 12 4 0 4
4 8 0 1 2
5 6 1 2 -1
6 8 4 0 0
7 6 1 2
8 11 2 2
9 15 2 1
10 11 3 1 1
11 9 1 1 2
12 12 3 1 0
13 10 2 4 0
14 10 4 3 0
15 6 0 0
16 4 2 0
17 5 0 0 0
18 8 1 3 0
19 5 2 0 -1
20 11 2 0 2
21 12 2 1 4
22 5 0 0
23 9 2 1 0
24 7 2 0 -1
25 6 0 0
26 7 1 3 0
27 6 0 0 0
28 8 2 -1 0
Mean: 34
Standard deviation 22
A J K L
Final Schedule
duration overrun changes
(Col.F + for total
Total project Col.G + project %
Project delay (Col.G + Col.H + (Col.K-
Number Col.H + Col.I) Col.I) Col.F)/(Col.F)
1 4 14 40
2 3 12 33
3 8 20 67
4 3 11 38
5 2 8 33
6 4 12 50
7 3 9 50
8 4 15 36
9 3 18 20
10 5 16 45
11 4 13 44
12 4 16 33
13 6 16 60
14 7 17 70
15 0 6 0
16 2 6 50
17 0 5 0
18 4 12 50
19 1 6 20
20 4 15 36
21 7 19 58
22 0 5 0
23 3 12 33
24 1 8 14
25 0 6 0
26 7 11 57
27 0 6 0
28 1 9 13
Table 2. Schedule contingencies at the end of each phase
Delays in phases (years)
A B C D E
Total
Project PE/ project
Number FEIS FD Construction delay
1 0 0 4 4
2 1 2 0 3
3 4 0 4 8
4 0 1 2 3
5 1 2 -1 2
6 4 0 0 4
7 1 2 3
8 2 2 4
9 2 1 3
10 3 1 1 5
11 1 1 2 4
12 3 1 0 4
13 2 4 0 6
14 4 3 0 7
15 0 0 0
16 2 0 2
17 0 0 0 0
18 1 3 0 4
19 2 0 -1 1
20 2 0 2 4
21 2 1 4 7
22 0 0 0
23 2 1 0 3
24 2 0 -1 1
25 0 0 0
26 1 3 0 4
27 0 0 0 0
28 2 -1 0 1
Cumulative phase delay/total project delay
A F G H
PE/FEIS
Project (Col.B/ FD ([Col.B + Construction ([Col.B+
Number Col.E) % Col.C]/Col.E) % Col.C + Col.D]/Col.E) %
1 0 0 100
2 33 100 100
3 50 50 100
4 0 33 100
5 50 150 100
6 100 100 100
7 0 33 100
8 0 50 100
9 0 67 100
10 60 80 100
11 25 50 100
12 75 100 100
13 33 100 100
14 57 100 100
15
16 0 100 100
17
18 25 100 100
19 200 200 100
20 50 50 100
21 29 43 100
22
23 67 100 100
24 200 200 100
25
26 25 100 100
27
28 200 100 100
Schedule contingency at the end of phases
A I J K
Project PE/FEIS Construction
Number (1-Col.F) % FD (1-Col.G) % (1-Col.H) %
1 100 100 0
2 67 0 0
3 50 50 0
4 100 67 0
5 50 - 50 0
6 0 0 0
7 100 67 0
8 100 50 0
9 100 33 0
10 40 20 0
11 75 50 0
12 25 0 0
13 67 0 0
14 43 0 0
15
16 100 0 0
17
18 75 0 0
19 - 100 - 100 0
20 50 50 0
21 71 57 0
22
23 33 0 0
24 - 100 - 100 0
25
26 75 0 0
27
28 - 100 0 0
Notes: Mean 44, 13 and 0.
Table 3. JCL-PC notations used for simulation
A B C
% completion Schedule contigency Assume no risks occur
remaining
0 Values obtained by 1
using Eq. 3, 4
and 5
A D E F
% completion Normal risk dist. % project % project
complete remaining
0 Risk Normal 0 1- CoLE
(mean:SD)+1
A G H I
% completion JCL-PC Mult. Schedule Schedule
contingency contingency x
contingency
remaining
0 Risk Discrete Col.G-1 Col.H x Col.B
(Col.C;Col.D:
Col.E;Col.F)
Notes: Col. A: a given percent complete; Col. B: cumulative schedule
contingency at the end of given percent completion from real data
calculated by fitted lines in Figures 2 (a c) using Eqns (3 5);
Col. C: onstant assuming that no unknown risk would occur
at the given percent completion; Col. D: simulated values using a
simulation software (e.g. @Risk) with schedule growth mean and
standard deviation values from real data, which are 34%
and 0.22, respectively; Col. E: a given percent complete;
Col. F: % project remaining at that stage; Col. G: simulated
values for M (JCL-PC multiplier); Col. H: total schedule contingency
at the end of a given percent completion; Col. I: the amount of
schedule contingency for the rest of the project
Table 4. JCL-PC notations used for simulation in the application
A B C D
Assume no Normal risk
unknown dist. (mean:
% Schedule contingency risks 0.34, SD:
completion remaining occur 0.22)
-11.12 xCol.A + 1 = RiskNormal
(for PE/FEIS)--3.1615 x (0.34;0.22)+ 1
Col.A + 0.602 (for FD) -
0.1503 x Col.A + 0.1503
(for construction)
0 1.00 1 1.3401
5 0.44 1 1.3401
10 0.29 1 1.3401
15 0.13 1 1.3401
20 0.12 1 1.3401
25 0.11 1 1.3401
30 0.11 1 1.3401
35 0.10 1 1.3401
40 0.09 1 1.3401
45 0.08 1 1.3401
50 0.08 1 1.3401
55 0.07 1 1.3401
60 0.06 1 1.3401
65 0.05 1 1.3401
70 0.05 1 1.3401
75 0.04 1 1.3401
80 0.03 1 1.3401
85 0.02 1 1.3401
90 0.02 1 1.3401
95 0.01 1 1.3401
100 0 1 1.3401
A E F G
% % project % project
completion completed remaining JCL-PC Mult.
1--ColE = RiskDiscrete
(Col.C:Col.D;Col.E;
Col.F)
0 0 100 1.3401
5 5 95 1.3401
10 10 90 1.3401
15 15 85 1.3401
20 20 80 1.3401
25 25 75 1.3401
30 30 70 1.3401
35 35 65 1.3401
40 40 60 1.3401
45 45 55 1.3401
50 50 50 1
55 55 45 1
60 60 40 1
65 65 35 1
70 70 30 1
75 75 25 1
80 80 20 1
85 85 15 1
90 90 10 1
95 95 5 1
100 100 0 1
A H I
Schedule
% Schedule contingency x
completion contingency contingency remaining
= Col.G-1 = Col.Hx Col.B
0 0.3401 0.3401
5 0.3401 0.1510
10 0.3401 0.0972
15 0.3401 0.0435
20 0.3401 0.0409
25 0.3401 0.0383
30 0.3401 0.0358
35 0.3401 0.0332
40 0.3401 0.0307
45 0.3401 0.0281
50 0 0
55 0 0
60 0 0
65 0 0
70 0 0
75 0 0
80 0 0
85 0 0
90 0 0
95 0 0
100 0 0
Table 5. Simulated unused contingency values as a percent of base
duration using normal distribution
Project
completion % 5% 10% 15% 20% 25% 30% 35%
0 - 1.5 6.4 11.6 15.9 19.4 22.7 25.7
5 - 0.6 0.0 3.0 5.5 7.5 9.1 10.7
10 - 0.3 0.0 0.0 2.2 3.7 4.9 6.0
15 0.0 0.0 0.0 0.1 1.2 1.8 2.3
20 0.0 0.0 0.0 0.0 0.1 1.2 1.8
25 0.0 0.0 0.0 0.0 0.0 0.1 1.0
30 0.0 0.0 0.0 0.0 0.0 0.0 0.3
35 0.0 0.0 0.0 0.0 0.0 0.0 0.0
40 0.0 0.0 0.0 0.0 0.0 0.0 0.0
45 0.0 0.0 0.0 0.0 0.0 0.0 0.0
50 0.0 0.0 0.0 0.0 0.0 0.0 0.0
55 0.0 0.0 0.0 0.0 0.0 0.0 0.0
60 0.0 0.0 0.0 0.0 0.0 0.0 0.0
65 0.0 0.0 0.0 0.0 0.0 0.0 0.0
70 0.0 0.0 0.0 0.0 0.0 0.0 0.0
75 0.0 0.0 0.0 0.0 0.0 0.0 0.0
80 0.0 0.0 0.0 0.0 0.0 0.0 0.0
85 0.0 0.0 0.0 0.0 0.0 0.0 0.0
90 0.0 0.0 0.0 0.0 0.0 0.0 0.0
95 0.0 0.0 0.0 0.0 0.0 0.0 0.0
100 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Project
completion % 40% 45% 50% 55% 60% 65% 70%
0 28.6 31.3 34.0 36.7 39.5 42.3 45.3
5 12.0 13.3 14.5 15.8 17.1 18.5 19.8
10 7.0 8.0 8.9 9.7 10.6 11.5 12.4
15 2.8 3.2 3.7 4.1 4.6 4.9 5.4
20 2.4 2.9 3.3 3.7 4.1 4.5 4.9
25 1.7 2.3 2.7 3.2 3.6 4.0 4.4
30 1.2 1.8 2.3 2.8 3.2 3.6 4.0
35 0.2 1.1 1.8 2.3 2.7 3.1 3.5
40 0.0 0.4 1.1 1.8 2.2 2.7 3.1
45 0.0 0.0 0.5 1.2 1.7 2.2 2.6
50 0.0 0.0 0.0 0.5 1.2 1.8 2.3
55 0.0 0.0 0.0 0.0 0.5 1.2 1.7
60 0.0 0.0 0.0 0.0 0.0 0.6 1.2
65 0.0 0.0 0.0 0.0 0.0 0.0 0.6
70 0.0 0.0 0.0 0.0 0.0 0.0 0.0
75 0.0 0.0 0.0 0.0 0.0 0.0 0.0
80 0.0 0.0 0.0 0.0 0.0 0.0 0.0
85 0.0 0.0 0.0 0.0 0.0 0.0 0.0
90 0.0 0.0 0.0 0.0 0.0 0.0 0.0
95 0.0 0.0 0.0 0.0 0.0 0.0 0.0
100 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Project
completion % 75% 80% 85% 90% 95%
0 48.5 52.1 56.3 61.6 69.3
5 21.3 22.9 24.8 27.1 30.5
10 13.5 14.5 15.7 17.1 19.8
15 5.9 6.3 6.9 7.7 8.6
20 5.3 5.8 6.3 7.0 8.1
25 4.9 5.3 5.8 6.5 7.5
30 4.4 4.9 5.4 6.0 7.0
35 3.9 4.3 4.9 5.5 6.3
40 3.4 3.8 4.3 4.9 5.8
45 3.0 3.4 3.8 4.3 5.2
50 2.6 3.0 3.5 4.0 4.6
55 2.1 2.5 3.0 3.4 4.2
60 1.6 2.0 2.4 2.9 3.6
65 1.1 1.5 2.1 2.5 2.9
70 0.5 1.0 1.4 1.9 2.5
75 0.0 0.6 1.0 1.5 1.9
80 0.0 0.0 0.6 1.0 1.4
85 0.0 0.0 0.0 0.7 1.0
90 0.0 0.0 0.0 0.0 0.6
95 0.0 0.0 0.0 0.0 0.0
100 0.0 0.0 0.0 0.0 0.0