WBS |
Task Name |
Duration |
Start |
Finish |
0 |
Essendon & Buckley Street level crossing removal |
985 days |
Wed 4/25/18 |
Tue 2/1/22 |
1 |
Initiation phase of the project |
73 days |
Wed 4/25/18 |
Fri 8/3/18 |
1.1 |
Identifying objectives of the project |
15 days |
Wed 4/25/18 |
Tue 5/15/18 |
1.2 |
Undertaking feasibility study |
20 days |
Wed 5/16/18 |
Tue 6/12/18 |
1.3 |
Establishing project charter |
16 days |
Fri 7/13/18 |
Fri 8/3/18 |
1.4 |
Appointing team members of the project |
22 days |
Wed 6/13/18 |
Thu 7/12/18 |
1.5 |
Milestone 1: Completion of project initiation phase |
0 days |
Fri 8/3/18 |
Fri 8/3/18 |
2 |
Planning phase of the project |
148 days |
Mon 8/6/18 |
Wed 2/27/19 |
2.1 |
Site investigations |
22 days |
Mon 8/6/18 |
Tue 9/4/18 |
2.2 |
Solution announced |
20 days |
Wed 9/5/18 |
Tue 10/2/18 |
2.3 |
Community information sessions |
25 days |
Wed 10/3/18 |
Tue 11/6/18 |
2.4 |
Trader consultation |
26 days |
Wed 11/7/18 |
Wed 12/12/18 |
2.5 |
Assessment of design options |
26 days |
Thu 12/13/18 |
Thu 1/17/19 |
2.6 |
Lowering Buckley street under rail line |
29 days |
Fri 1/18/19 |
Wed 2/27/19 |
2.7 |
Milestone 2: Completion of planning phase |
0 days |
Wed 2/27/19 |
Wed 2/27/19 |
3 |
Procurement phase |
420 days |
Thu 2/28/19 |
Wed 10/7/20 |
3.1 |
Community input on design elements |
32 days |
Thu 2/28/19 |
Fri 4/12/19 |
3.2 |
North west alliance project partner announced |
39 days |
Mon 4/15/19 |
Thu 6/6/19 |
3.3 |
Construction partner announced |
134 days |
Fri 6/7/19 |
Wed 10/7/20 |
3.4 |
Community consultation |
47 days |
Fri 6/7/19 |
Mon 8/12/19 |
3.5 |
Refinement of design including community inputs |
50 days |
Tue 8/13/19 |
Mon 10/21/19 |
3.6 |
Finalizing design |
42 days |
Tue 10/22/19 |
Wed 12/18/19 |
3.7 |
Milestone 3 : Completion of procurement phase |
0 days |
Wed 12/18/19 |
Wed 12/18/19 |
4 |
Construction phase |
480 days |
Thu 12/19/19 |
Wed 10/20/21 |
4.1 |
On-going community consultation |
32 days |
Thu 12/19/19 |
Fri 1/31/20 |
4.2 |
Construction commences |
34 days |
Mon 2/3/20 |
Thu 3/19/20 |
4.3 |
Preparatory work commenced |
43 days |
Fri 3/20/20 |
Tue 5/19/20 |
4.4 |
Finalized design released to the community |
90 days |
Wed 5/20/20 |
Wed 12/9/20 |
4.5 |
Contract awarded for Buckley street level crossing removal project |
156 days |
Wed 5/20/20 |
Thu 5/20/21 |
4.6 |
Early works commence |
102 days |
Wed 5/20/20 |
Thu 10/8/20 |
4.7 |
Major works commence |
48 days |
Thu 12/10/20 |
Mon 2/15/21 |
4.8 |
Boom gates removed |
112 days |
Tue 2/16/21 |
Wed 7/21/21 |
4.9 |
Finalizing landscapes |
65 days |
Thu 7/22/21 |
Wed 10/20/21 |
4.10 |
Milestone 4: Completion of Construction phase |
0 days |
Wed 10/20/21 |
Wed 10/20/21 |
5 |
Closure phase |
74 days |
Thu 10/21/21 |
Tue 2/1/22 |
5.1 |
Post-project review |
20 days |
Thu 10/21/21 |
Wed 11/17/21 |
5.2 |
Stakeholder-sign off |
30 days |
Thu 11/18/21 |
Wed 12/29/21 |
5.3 |
Documentation |
24 days |
Thu 12/30/21 |
Tue 2/1/22 |
5.4 |
Milestone 4: Completion of project closure phase |
0 days |
Wed 11/17/21 |
Wed 11/17/21 |
WBS |
Task Name |
Duration |
Start |
Finish |
Predecessors |
0 |
Essendon & Buckley Street level crossing removal |
985 days |
Wed 4/25/18 |
Tue 2/1/22 |
|
1 |
Initiation phase of the project |
73 days |
Wed 4/25/18 |
Fri 8/3/18 |
|
1.1 |
Identifying objectives of the project |
15 days |
Wed 4/25/18 |
Tue 5/15/18 |
|
1.2 |
Undertaking feasibility study |
20 days |
Wed 5/16/18 |
Tue 6/12/18 |
2 |
1.3 |
Establishing project charter |
16 days |
Fri 7/13/18 |
Fri 8/3/18 |
3 |
1.4 |
Appointing team members of the project |
22 days |
Wed 6/13/18 |
Thu 7/12/18 |
3 |
1.5 |
Milestone 1: Completion of project initiation phase |
0 days |
Fri 8/3/18 |
Fri 8/3/18 |
5,4 |
2 |
Planning phase of the project |
148 days |
Mon 8/6/18 |
Wed 2/27/19 |
|
2.1 |
Site investigations |
22 days |
Mon 8/6/18 |
Tue 9/4/18 |
6 |
2.2 |
Solution announced |
20 days |
Wed 9/5/18 |
Tue 10/2/18 |
8,6 |
2.3 |
Community information sessions |
25 days |
Wed 10/3/18 |
Tue 11/6/18 |
9 |
2.4 |
Trader consultation |
26 days |
Wed 11/7/18 |
Wed 12/12/18 |
10,9 |
2.5 |
Assessment of design options |
26 days |
Thu 12/13/18 |
Thu 1/17/19 |
11 |
2.6 |
Lowering Buckley street under rail line |
29 days |
Fri 1/18/19 |
Wed 2/27/19 |
12,11 |
2.7 |
Milestone 2: Completion of planning phase |
0 days |
Wed 2/27/19 |
Wed 2/27/19 |
13 |
3 |
Procurement phase |
420 days |
Thu 2/28/19 |
Wed 10/7/20 |
|
3.1 |
Community input on design elements |
32 days |
Thu 2/28/19 |
Fri 4/12/19 |
14 |
3.2 |
North west alliance project partner announced |
39 days |
Mon 4/15/19 |
Thu 6/6/19 |
16,14 |
3.3 |
Construction partner announced |
134 days |
Fri 6/7/19 |
Wed 10/7/20 |
17 |
3.4 |
Community consultation |
47 days |
Fri 6/7/19 |
Mon 8/12/19 |
17 |
3.5 |
Refinement of design including community inputs |
50 days |
Tue 8/13/19 |
Mon 10/21/19 |
19 |
3.6 |
Finalizing design |
42 days |
Tue 10/22/19 |
Wed 12/18/19 |
20 |
3.7 |
Milestone 3 : Completion of procurement phase |
0 days |
Wed 12/18/19 |
Wed 12/18/19 |
21,20 |
4 |
Construction phase |
480 days |
Thu 12/19/19 |
Wed 10/20/21 |
|
4.1 |
On-going community consultation |
32 days |
Thu 12/19/19 |
Fri 1/31/20 |
22 |
4.2 |
Construction commences |
34 days |
Mon 2/3/20 |
Thu 3/19/20 |
24,22 |
4.3 |
Preparatory work commenced |
43 days |
Fri 3/20/20 |
Tue 5/19/20 |
25 |
4.4 |
Finalized design released to the community |
90 days |
Wed 5/20/20 |
Wed 12/9/20 |
26 |
4.5 |
Contract awarded for Buckley street level crossing removal project |
156 days |
Wed 5/20/20 |
Thu 5/20/21 |
26 |
4.6 |
Early works commence |
102 days |
Wed 5/20/20 |
Thu 10/8/20 |
26 |
4.7 |
Major works commence |
48 days |
Thu 12/10/20 |
Mon 2/15/21 |
27 |
4.8 |
Boom gates removed |
112 days |
Tue 2/16/21 |
Wed 7/21/21 |
30 |
4.9 |
Finalizing landscapes |
65 days |
Thu 7/22/21 |
Wed 10/20/21 |
31 |
4.10 |
Milestone 4: Completion of Construction phase |
0 days |
Wed 10/20/21 |
Wed 10/20/21 |
32 |
5 |
Closure phase |
74 days |
Thu 10/21/21 |
Tue 2/1/22 |
|
5.1 |
Post-project review |
20 days |
Thu 10/21/21 |
Wed 11/17/21 |
33 |
5.2 |
Stakeholder-sign off |
30 days |
Thu 11/18/21 |
Wed 12/29/21 |
35,33 |
5.3 |
Documentation |
24 days |
Thu 12/30/21 |
Tue 2/1/22 |
35 |
5.4 |
Milestone 4: Completion of project closure phase |
0 days |
Wed 11/17/21 |
Wed 11/17/21 |
35 |
WBS |
Task Name |
Duration |
Start |
Finish |
Resource Names |
0 |
Essendon & Buckley Street level crossing removal |
985 days |
Wed 4/25/18 |
Tue 2/1/22 |
|
1 |
Initiation phase of the project |
73 days |
Wed 4/25/18 |
Fri 8/3/18 |
|
1.1 |
Identifying objectives of the project |
15 days |
Wed 4/25/18 |
Tue 5/15/18 |
Project manager |
1.2 |
Undertaking feasibility study |
20 days |
Wed 5/16/18 |
Tue 6/12/18 |
Project manager |
1.3 |
Establishing project charter |
16 days |
Fri 7/13/18 |
Fri 8/3/18 |
Project manager, Project planner |
1.4 |
Appointing team members of the project |
22 days |
Wed 6/13/18 |
Thu 7/12/18 |
Project manager, Project planner |
1.5 |
Milestone 1: Completion of project initiation phase |
0 days |
Fri 8/3/18 |
Fri 8/3/18 |
|
2 |
Planning phase of the project |
148 days |
Mon 8/6/18 |
Wed 2/27/19 |
|
2.1 |
Site investigations |
22 days |
Mon 8/6/18 |
Tue 9/4/18 |
Supervisor, Construction manager |
2.2 |
Solution announced |
20 days |
Wed 9/5/18 |
Tue 10/2/18 |
Construction technician, Contractor, Equipment cost[1] |
2.3 |
Community information sessions |
25 days |
Wed 10/3/18 |
Tue 11/6/18 |
Construction manager, Contractor |
2.4 |
Trader consultation |
26 days |
Wed 11/7/18 |
Wed 12/12/18 |
Construction manager, Contractor |
2.5 |
Assessment of design options |
26 days |
Thu 12/13/18 |
Thu 1/17/19 |
Construction manager, Contractor, Sub-contractor |
2.6 |
Lowering Buckley street under rail line |
29 days |
Fri 1/18/19 |
Wed 2/27/19 |
Architect, Construction manager, Construction technician, Sub-contractor |
2.7 |
Milestone 2: Completion of planning phase |
0 days |
Wed 2/27/19 |
Wed 2/27/19 |
|
3 |
Procurement phase |
420 days |
Thu 2/28/19 |
Wed 10/7/20 |
|
3.1 |
Community input on design elements |
32 days |
Thu 2/28/19 |
Fri 4/12/19 |
Cost for removing level crossing[1], Supervisor, Architect, Construction technician, Equipment cost[1] |
3.2 |
North west alliance project partner announced |
39 days |
Mon 4/15/19 |
Thu 6/6/19 |
Supervisor, Architect, Construction manager, Contractor, Procurement manager |
3.3 |
Construction partner announced |
134 days |
Fri 6/7/19 |
Wed 10/7/20 |
Supervisor, Architect, Construction technician, Contractor, Procurement manager |
3.4 |
Community consultation |
47 days |
Fri 6/7/19 |
Mon 8/12/19 |
Cost for removing level crossing[1], Architect, Construction technician, Contractor |
3.5 |
Refinement of design including community inputs |
50 days |
Tue 8/13/19 |
Mon 10/21/19 |
Architect, Construction technician, Contractor, Financial manager, Procurement manager |
3.6 |
Finalizing design |
42 days |
Tue 10/22/19 |
Wed 12/18/19 |
Supervisor, Architect, Equipment cost[1], Procurement manager |
3.7 |
Milestone 3 : Completion of procurement phase |
0 days |
Wed 12/18/19 |
Wed 12/18/19 |
|
4 |
Construction phase |
480 days |
Thu 12/19/19 |
Wed 10/20/21 |
|
4.1 |
On-going community consultation |
32 days |
Thu 12/19/19 |
Fri 1/31/20 |
Supervisor, Architect, Contractor, Procurement manager, Sub-contractor |
4.2 |
Construction commences |
34 days |
Mon 2/3/20 |
Thu 3/19/20 |
Cost for removing level crossing[1], Project manager, Architect, Construction technician, Procurement manager |
4.3 |
Preparatory work commenced |
43 days |
Fri 3/20/20 |
Tue 5/19/20 |
Cost for removing level crossing[1], Supervisor, Architect, Construction technician, Contractor, Equipment cost[1], Sub-contractor |
4.4 |
Finalized design released to the community |
90 days |
Wed 5/20/20 |
Wed 12/9/20 |
Supervisor, Architect, Construction manager, Construction technician, Procurement manager |
4.5 |
Contract awarded for Buckley street level crossing removal project |
156 days |
Wed 5/20/20 |
Thu 5/20/21 |
Cost for removing level crossing[1], Project manager, Architect, Construction technician, Contractor, Sub-contractor |
4.6 |
Early works commence |
102 days |
Wed 5/20/20 |
Thu 10/8/20 |
Cost for removing level crossing[1], Architect, Construction manager, Construction technician, Equipment cost[1] |
4.7 |
Major works commence |
48 days |
Thu 12/10/20 |
Mon 2/15/21 |
Cost for removing level crossing[1], Project manager, Supervisor, Architect, Construction manager, Construction technician, Sub-contractor |
4.8 |
Boom gates removed |
112 days |
Tue 2/16/21 |
Wed 7/21/21 |
Cost for removing level crossing[1], Project manager, Architect, Construction manager, Construction technician, Contractor |
4.9 |
Finalizing landscapes |
65 days |
Thu 7/22/21 |
Wed 10/20/21 |
Architect, Construction manager, Construction technician, Contractor, Sub-contractor |
4.10 |
Milestone 4: Completion of Construction phase |
0 days |
Wed 10/20/21 |
Wed 10/20/21 |
|
5 |
Closure phase |
74 days |
Thu 10/21/21 |
Tue 2/1/22 |
|
5.1 |
Post-project review |
20 days |
Thu 10/21/21 |
Wed 11/17/21 |
Project manager, Project planner |
5.2 |
Stakeholder-sign off |
30 days |
Thu 11/18/21 |
Wed 12/29/21 |
Project manager, Project planner |
5.3 |
Documentation |
24 days |
Thu 12/30/21 |
Tue 2/1/22 |
Project manager, Project planner |
5.4 |
Milestone 4: Completion of project closure phase |
0 days |
Wed 11/17/21 |
Wed 11/17/21 |
|
WBS |
Task Name |
Duration |
Start |
Finish |
0 |
Essendon & Buckley Street level crossing removal |
985 days |
Wed 4/25/18 |
Tue 2/1/22 |
1 |
Initiation phase of the project |
73 days |
Wed 4/25/18 |
Fri 8/3/18 |
1.1 |
Identifying objectives of the project |
15 days |
Wed 4/25/18 |
Tue 5/15/18 |
1.2 |
Undertaking feasibility study |
20 days |
Wed 5/16/18 |
Tue 6/12/18 |
1.3 |
Establishing project charter |
16 days |
Fri 7/13/18 |
Fri 8/3/18 |
1.4 |
Appointing team members of the project |
22 days |
Wed 6/13/18 |
Thu 7/12/18 |
1.5 |
Milestone 1: Completion of project initiation phase |
0 days |
Fri 8/3/18 |
Fri 8/3/18 |
2 |
Planning phase of the project |
148 days |
Mon 8/6/18 |
Wed 2/27/19 |
2.1 |
Site investigations |
22 days |
Mon 8/6/18 |
Tue 9/4/18 |
2.2 |
Solution announced |
20 days |
Wed 9/5/18 |
Tue 10/2/18 |
2.3 |
Community information sessions |
25 days |
Wed 10/3/18 |
Tue 11/6/18 |
2.4 |
Trader consultation |
26 days |
Wed 11/7/18 |
Wed 12/12/18 |
2.5 |
Assessment of design options |
26 days |
Thu 12/13/18 |
Thu 1/17/19 |
2.6 |
Lowering Buckley street under rail line |
29 days |
Fri 1/18/19 |
Wed 2/27/19 |
2.7 |
Milestone 2: Completion of planning phase |
0 days |
Wed 2/27/19 |
Wed 2/27/19 |
3 |
Procurement phase |
420 days |
Thu 2/28/19 |
Wed 10/7/20 |
3.1 |
Community input on design elements |
32 days |
Thu 2/28/19 |
Fri 4/12/19 |
3.2 |
North west alliance project partner announced |
39 days |
Mon 4/15/19 |
Thu 6/6/19 |
3.3 |
Construction partner announced |
134 days |
Fri 6/7/19 |
Wed 10/7/20 |
3.4 |
Community consultation |
47 days |
Fri 6/7/19 |
Mon 8/12/19 |
3.5 |
Refinement of design including community inputs |
50 days |
Tue 8/13/19 |
Mon 10/21/19 |
3.6 |
Finalizing design |
42 days |
Tue 10/22/19 |
Wed 12/18/19 |
3.7 |
Milestone 3 : Completion of procurement phase |
0 days |
Wed 12/18/19 |
Wed 12/18/19 |
4 |
Construction phase |
480 days |
Thu 12/19/19 |
Wed 10/20/21 |
4.1 |
On-going community consultation |
32 days |
Thu 12/19/19 |
Fri 1/31/20 |
4.2 |
Construction commences |
34 days |
Mon 2/3/20 |
Thu 3/19/20 |
4.3 |
Preparatory work commenced |
43 days |
Fri 3/20/20 |
Tue 5/19/20 |
4.4 |
Finalized design released to the community |
90 days |
Wed 5/20/20 |
Wed 12/9/20 |
4.5 |
Contract awarded for Buckley street level crossing removal project |
156 days |
Wed 5/20/20 |
Thu 5/20/21 |
4.6 |
Early works commence |
102 days |
Wed 5/20/20 |
Thu 10/8/20 |
4.7 |
Major works commence |
48 days |
Thu 12/10/20 |
Mon 2/15/21 |
4.8 |
Boom gates removed |
112 days |
Tue 2/16/21 |
Wed 7/21/21 |
4.9 |
Finalizing landscapes |
65 days |
Thu 7/22/21 |
Wed 10/20/21 |
4.10 |
Milestone 4: Completion of Construction phase |
0 days |
Wed 10/20/21 |
Wed 10/20/21 |
5 |
Closure phase |
74 days |
Thu 10/21/21 |
Tue 2/1/22 |
5.1 |
Post-project review |
20 days |
Thu 10/21/21 |
Wed 11/17/21 |
5.2 |
Stakeholder-sign off |
30 days |
Thu 11/18/21 |
Wed 12/29/21 |
5.3 |
Documentation |
24 days |
Thu 12/30/21 |
Tue 2/1/22 |
5.4 |
Milestone 4: Completion of project closure phase |
0 days |
Wed 11/17/21 |
Wed 11/17/21 |
Figure 1: bar representation of the activities
(Source: Created by Author)
Figure 2: Critical Path representation
(Source: Created by Author)
Figure 3: WBS
(Source: Created by Author Using MS project and WBS Schedule Pro)
WBS |
Task Name |
Duration |
Start |
Finish |
Cost |
0 |
Essendon & Buckley Street level crossing removal Project |
985 days |
Wed 4/25/18 |
Tue 2/1/22 |
$153,991,424.00 |
1 |
Initializing First phase of the project |
73 days |
Wed 4/25/18 |
Fri 8/3/18 |
$104,512.00 |
2 |
Second phase Planning of the project |
148 days |
Mon 8/6/18 |
Wed 2/27/19 |
$15,763,440.00 |
3 |
Procurement phase |
420 days |
Thu 2/28/19 |
Wed 10/7/20 |
$50,064,000.00 |
4 |
Construction phase |
480 days |
Thu 12/19/19 |
Wed 10/20/21 |
$87,871,216.00 |
5 |
Closure phase |
74 days |
Thu 10/21/21 |
Tue 2/1/22 |
$188,256.00 |
WBS |
Task Name |
Duration |
Start |
Finish |
Cost |
0 |
Essendon & Buckley Street level crossing removal |
985 days |
Wed 4/25/18 |
Tue 2/1/22 |
$153,991,424.00 |
1 |
Initiation phase of the project |
73 days |
Wed 4/25/18 |
Fri 8/3/18 |
$104,512.00 |
1.1 |
Identifying objectives of the project |
15 days |
Wed 4/25/18 |
Tue 5/15/18 |
$3,360.00 |
1.2 |
Undertaking feasibility study |
20 days |
Wed 5/16/18 |
Tue 6/12/18 |
$4,480.00 |
1.3 |
Establishing project charter |
16 days |
Fri 7/13/18 |
Fri 8/3/18 |
$40,704.00 |
1.4 |
Appointing team members of the project |
22 days |
Wed 6/13/18 |
Thu 7/12/18 |
$55,968.00 |
1.5 |
Milestone 1: Completion of project initiation phase |
0 days |
Fri 8/3/18 |
Fri 8/3/18 |
$0.00 |
2 |
Planning phase of the project |
148 days |
Mon 8/6/18 |
Wed 2/27/19 |
$15,763,440.00 |
2.1 |
Site investigations |
22 days |
Mon 8/6/18 |
Tue 9/4/18 |
$82,720.00 |
2.2 |
Solution announced |
20 days |
Wed 9/5/18 |
Tue 10/2/18 |
$15,086,400.00 |
2.3 |
Community information sessions |
25 days |
Wed 10/3/18 |
Tue 11/6/18 |
$100,000.00 |
2.4 |
Trader consultation |
26 days |
Wed 11/7/18 |
Wed 12/12/18 |
$104,000.00 |
2.5 |
Assessment of design options |
26 days |
Thu 12/13/18 |
Thu 1/17/19 |
$156,000.00 |
2.6 |
Lowering Buckley street under rail line |
29 days |
Fri 1/18/19 |
Wed 2/27/19 |
$234,320.00 |
2.7 |
Milestone 2: Completion of planning phase |
0 days |
Wed 2/27/19 |
Wed 2/27/19 |
$0.00 |
3 |
Procurement phase |
420 days |
Thu 2/28/19 |
Wed 10/7/20 |
$50,064,000.00 |
3.1 |
Community input on design elements |
32 days |
Thu 2/28/19 |
Fri 4/12/19 |
$24,197,120.00 |
3.2 |
North west alliance project partner announced |
39 days |
Mon 4/15/19 |
Thu 6/6/19 |
$380,640.00 |
3.3 |
Construction partner announced |
134 days |
Fri 6/7/19 |
Wed 10/7/20 |
$443,520.00 |
3.4 |
Community consultation |
47 days |
Fri 6/7/19 |
Mon 8/12/19 |
$9,300,800.00 |
3.5 |
Refinement of design including community inputs |
50 days |
Tue 8/13/19 |
Mon 10/21/19 |
$500,000.00 |
3.6 |
Finalizing design |
42 days |
Tue 10/22/19 |
Wed 12/18/19 |
$15,241,920.00 |
3.7 |
Milestone 3 : Completion of procurement phase |
0 days |
Wed 12/18/19 |
Wed 12/18/19 |
$0.00 |
4 |
Construction phase |
480 days |
Thu 12/19/19 |
Wed 10/20/21 |
$87,871,216.00 |
4.1 |
On-going community consultation |
32 days |
Thu 12/19/19 |
Fri 1/31/20 |
$317,440.00 |
4.2 |
Construction commences |
34 days |
Mon 2/3/20 |
Thu 3/19/20 |
$9,211,616.00 |
4.3 |
Preparatory work commenced |
43 days |
Fri 3/20/20 |
Tue 5/19/20 |
$24,443,760.00 |
4.4 |
Finalized design released to the community |
90 days |
Wed 5/20/20 |
Wed 12/9/20 |
$439,200.00 |
4.5 |
Contract awarded for Buckley street level crossing removal project |
156 days |
Wed 5/20/20 |
Thu 5/20/21 |
$9,448,448.00 |
4.6 |
Early works commence |
102 days |
Wed 5/20/20 |
Thu 10/8/20 |
$24,346,560.00 |
4.7 |
Major works commence |
48 days |
Thu 12/10/20 |
Mon 2/15/21 |
$9,490,752.00 |
4.8 |
Boom gates removed |
112 days |
Tue 2/16/21 |
Wed 7/21/21 |
$9,507,840.00 |
4.9 |
Finalizing landscapes |
65 days |
Thu 7/22/21 |
Wed 10/20/21 |
$665,600.00 |
4.10 |
Milestone 4: Completion of Construction phase |
0 days |
Wed 10/20/21 |
Wed 10/20/21 |
$0.00 |
5 |
Closure phase |
74 days |
Thu 10/21/21 |
Tue 2/1/22 |
$188,256.00 |
5.1 |
Post-project review |
20 days |
Thu 10/21/21 |
Wed 11/17/21 |
$50,880.00 |
5.2 |
Stakeholder-sign off |
30 days |
Thu 11/18/21 |
Wed 12/29/21 |
$76,320.00 |
5.3 |
Documentation |
24 days |
Thu 12/30/21 |
Tue 2/1/22 |
$61,056.00 |
5.4 |
Milestone 4: Completion of project closure phase |
0 days |
Wed 11/17/21 |
Wed 11/17/21 |
$0.00 |
Input Values
SL. No |
Hardware |
$ 100,000,000.00 |
1 |
Software |
$ 10,000,000.00 |
2 |
Development team salaries |
$ 10,000,000.00 |
3 |
Training |
$ 10,000,000.00 |
|
Total Development Cost |
$ 130,000,000.00 |
4 |
|
|
5 |
Hardware |
$ 2,000,000.00 |
6 |
Software |
$ 3,000,000.00 |
7 |
Operational Labor |
$ 18,000,000.00 |
|
Total Operational Cost |
$ 23,000,000.00 |
8 |
|
|
9 |
Approximate salary savings |
$ 54,000,000.00 |
10 |
Reduced operating cost |
$ 60,000,000.00 |
|
Total Benefit |
$ 114,000,000.00 |
11 |
|
|
|
Discount Rate Used |
6.00% |
Net Present Value Calculation
Enter values for the cost-benefit analysis in the INPUT_VALUES worksheet |
|||||||
|
|
|
Year of Project |
|
|
|
|
|
0 |
1 |
2 |
3 |
4 |
5 |
TOTALS |
|
$0.00 |
$ 114,000,000.00 |
$ 114,000,000.00 |
$ 114,000,000.00 |
$ 114,000,000.00 |
$ 114,000,000.00 |
|
6.00% |
1.0000 |
0.9434 |
0.8900 |
0.8396 |
0.7921 |
0.7473 |
|
$ 114,000,000.00 |
$0.00 |
$107,547,169.81 |
$101,459,594.16 |
$95,716,598.27 |
$90,298,677.61 |
$85,187,431.71 |
|
$ 23,000,000.00 |
|
|
|
|
|
|
|
$ 130,000,000.00 |
$0.00 |
$ 107,547,169.81 |
$ 209,006,763.97 |
$ 304,723,362.24 |
$ 395,022,039.85 |
$ 480,209,471.55 |
$ 480,209,471.55 |
|
|
|
|
|
|
|
|
|
$ (130,000,000.00) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.00 |
$ (23,000,000.00) |
$ (23,000,000.00) |
$ (23,000,000.00) |
$ (23,000,000.00) |
$ (23,000,000.00) |
|
|
1.0000 |
0.9434 |
0.8900 |
0.8396 |
0.7921 |
0.7473 |
|
|
$0.00 |
$ (21,698,113.21) |
$ (20,469,918.12) |
$ (19,311,243.51) |
$ (18,218,154.25) |
$ (17,186,937.98) |
|
|
|
|
|
|
|
|
|
|
$ (130,000,000.00) |
$ (151,698,113.21) |
$ (172,168,031.33) |
$ (191,479,274.84) |
$ (209,697,429.09) |
$ (226,884,367.07) |
$ (226,884,367.07) |
|
|
|
|
|
|
|
|
|
$ (130,000,000.00) |
$ 85,849,056.60 |
$ 80,989,676.04 |
$ 76,405,354.76 |
$ 72,080,523.35 |
$ 68,000,493.73 |
$ 253,325,104.49 |
|
$ (130,000,000.00) |
$ (44,150,943.40) |
$ 36,838,732.65 |
$ 113,244,087.40 |
$ 185,324,610.76 |
$ 253,325,104.49 |
|
|
|
|
|
|
|
|
1.1165 |
Break Even Chart
Unique ID |
Resource Name |
Type |
Max. Units |
Std. Rate |
Ovt. Rate |
Cost/Use |
Accrue At |
Base Calendar |
1 |
Project manager |
Work |
100% |
$28.00/hr |
$0.00/hr |
$0.00 |
Prorated |
Standard |
2 |
Project planner |
Work |
100% |
$290.00/hr |
$0.00/hr |
$0.00 |
Prorated |
Standard |
3 |
Supervisor |
Work |
100% |
$240.00/hr |
$0.00/hr |
$0.00 |
Prorated |
Standard |
4 |
Contractor |
Work |
100% |
$270.00/hr |
$0.00/hr |
$0.00 |
Prorated |
Standard |
5 |
Architect |
Work |
100% |
$260.00/hr |
$0.00/hr |
$0.00 |
Prorated |
Standard |
6 |
Construction technician |
Work |
100% |
$270.00/hr |
$0.00/hr |
$0.00 |
Prorated |
Standard |
7 |
Procurement manager |
Work |
100% |
$220.00/hr |
$0.00/hr |
$0.00 |
Prorated |
Standard |
8 |
Construction manager |
Work |
100% |
$230.00/hr |
$0.00/hr |
$0.00 |
Prorated |
Standard |
9 |
Sub-contractor |
Work |
100% |
$250.00/hr |
$0.00/hr |
$0.00 |
Prorated |
Standard |
10 |
Equipment cost |
Material |
|
$15,000,000.00 |
|
$0.00 |
Prorated |
|
11 |
Cost for removing level crossing |
Material |
|
$9,000,000.00 |
|
$0.00 |
Prorated |
|
12 |
Financial manager |
Work |
100% |
$230.00/hr |
$0.00/hr |
$0.00 |
Prorated |
Standard |
Binder, J. (2016). Global project management: communication, collaboration and management across borders. Routledge.
Boud, D., Cohen, R., & Sampson, J. (Eds.). (2014). Peer learning in higher education: Learning from and with each other. Routledge.
de Carvalho, M. M., Patah, L. A., & de Souza Bido, D. (2015). Project management and its effects on project success: Cross-country and cross-industry comparisons. International Journal of Project Management, 33(7), 1509-1522.
Fleming, Q. W., & Koppelman, J. M. (2016, December). Earned value project management. Project Management Institute.
Fleming, Q. W., & Koppelman, J. M. (2016, December). Earned value project management. Project Management Institute.
Gido, J., Clements, J., & Clements, J. (2014). Successful project management. Nelson Education.
Harrison, F., & Lock, D. (2017). Advanced project management: a structured approach. Routledge.
Heagney, J. (2016). Fundamentals of project management. AMACOM Div American Mgmt Assn.
Hornstein, H. A. (2015). The integration of project management and organizational change management is now a necessity. International Journal of Project Management, 33(2), 291-298.
JOSEPH. PHILLIPS, P. M. P., CBAP, I., & PMP, C. (2018). PMP PROJECT MANAGEMENT PROFESSIONAL STUDY GUIDE. McGraw-Hill Education.
Joslin, R., & Müller, R. (2015). Relationships between a project management methodology and project success in different project governance contexts. International Journal of Project Management, 33(6), 1377-1392.
Kaiser, M. G., El Arbi, F., & Ahlemann, F. (2015). Successful project portfolio management beyond project selection techniques: Understanding the role of structural alignment. International Journal of Project Management, 33(1), 126-139.
Kerzner, H. (2017). Project management metrics, KPIs, and dashboards: a guide to measuring and monitoring project performance. John Wiley & Sons.
Kerzner, H., & Kerzner, H. R. (2017). Project management: a systems approach to planning, scheduling, and controlling. John Wiley & Sons.
Krajewski, L. J., Malhotra, M. K., & Ritzman, L. P. (2015). Operations management: processes and supply chains. Pearson.
Leach, L. P. (2014). Critical chain project management. Artech House.
Martinelli, R. J., & Milosevic, D. Z. (2016). Project management toolbox: tools and techniques for the practicing project manager. John Wiley & Sons.
Meredith, J. R., Shafer, S. M., Mantel Jr, S. J., & Sutton, M. M. (2016). Project management in practice. Wiley Global Education.
Mir, F. A., & Pinnington, A. H. (2014). Exploring the value of project management: linking project management performance and project success. International journal of project management, 32(2), 202-217.
Nicholas, J. M., & Steyn, H. (2017). Project management for engineering, business and technology. Taylor & Francis.
Riol, H., & Thuillier, D. (2015). Project management for academic research projects: balancing structure and flexibility. International Journal of Project Organisation and Management, 7(3), 251-269.
Schwalbe, K. (2015). Information technology project management. Cengage Learning.
Sears, S. K., Sears, G. A., Clough, R. H., Rounds, J. L., & Segner, R. O. (2015). Construction project management. John Wiley & Sons.
Serra, C. E. M., & Kunc, M. (2015). Benefits realisation management and its influence on project success and on the execution of business strategies. International Journal of Project Management, 33(1), 53-66.
Snyder, C. S. (2014). A guide to the project management body of knowledge: PMBOK (®) guide. Project Management Institute: Newtown Square, PA, USA.
Svejvig, P., & Andersen, P. (2015). Rethinking project management: A structured literature review with a critical look at the brave new world. International Journal of Project Management, 33(2), 278-290.
Todorovi?, M. L., Petrovi?, D. ?., Mihi?, M. M., Obradovi?, V. L., & Bushuyev, S. D. (2015). Project success analysis framework: A knowledge-based approach in project management. International Journal of Project Management, 33(4), 772-783.
Too, E. G., & Weaver, P. (2014). The management of project management: A conceptual framework for project governance. International Journal of Project Management, 32(8), 1382-1394
Turner, R. (2016). Gower handbook of project management. Routledge.
Verzuh, E. (2015). The fast forward MBA in project management. John Wiley & Sons.