BNV6047 Project Management: Project Scheduling and Cost Analysis Resit

This assignment focuses on project management principles, specifically project scheduling and cost management, using MS Project. It includes creating a network diagram, identifying the critical path, calculating total and free float, and analyzing the impact of altering activity durations on the proje...Read More

Running head: PROJECT MANAGEMENT
Project Management using MS-Project
Name of the Student
Name of the University
Author Note

1
PROJECT MANAGEMENT
Table of Contents
Question 1........................................................................................................................................2
a) Network Diagram....................................................................................................................2
b) i. Critical Path..........................................................................................................................2
b) ii. Total and Free Float........................................................................................................3
b) Overall Expected Duration......................................................................................................3
i. Critical Path..........................................................................................................................3
ii. Early Event Times...............................................................................................................4
b) iii. Late Event Times...............................................................................................................4
c) Calculate total and free float of non-critical activities............................................................5
d) Altering Electric Service Activity...........................................................................................5
Amended Network Diagram....................................................................................................6
Question 2........................................................................................................................................7
a) Gantt chart with early start times.............................................................................................7
Question 3 Cost overview................................................................................................................8
Bibliography....................................................................................................................................9

2
PROJECT MANAGEMENT
Question 1
a) Network Diagram
Figure 1: Network Diagram
(Source: Created by Author Using MS Project)

3
PROJECT MANAGEMENT
b) i. Critical Path
Critical Path: A, B, C, D, E, F, G, H = 114 days
Figure 1: Network Diagram
(Source: Created by Author Using MS-Project)
b) ii. Total and Free Float
Activity Total float Free float
A 0 0
B 0 0
C 0 0
D 0 0
E 0 0
F 0 0
G 0 0
H 0 0
I 12 27
J 25 25
K 8 23

4
PROJECT MANAGEMENT
L - -
Figure 2: Network Diagram
(Source: Created by Author using MS-Visio)
b) Overall Expected Duration
i. Critical Path
Critical Path: A, B, C, D, E, F, G, H = 114 days
ii. Early Event Times
Task Name Duration Early Start Early Finish
Lay access road 15 days Wed 10/3/18 Tue 10/23/18
Erect fence 10 days Wed 10/24/18 Tue 11/6/18
Demolition of existing structure 15 days Wed 11/7/18 Tue 11/27/18
Disposal of demolished material,
off site 5 days Wed 11/28/18 Tue 12/4/18
Top soil removal and reduce
level excavation 18 days Wed 11/28/18 Fri 12/21/18
Hardcore filling and compacting 15 days Mon 12/24/18 Fri 1/11/19
Erect site accommodation 15 days Mon 1/14/19 Fri 2/1/19
Fit out 21 days Wed 2/13/19 Wed 3/13/19
Electrical services 6 days Wed 11/28/18 Wed 12/5/18
Temporary drain connection 15 days Wed 11/28/18 Tue 12/18/18
Excavate and lay water service 7 days Mon 2/4/19 Tue 2/12/19
Fit gates 7 days Mon 2/4/19 Tue 2/12/19

5
PROJECT MANAGEMENT
b) iii. Late Event Times
Task Name Duration Late Start Late Finish
Lay access road 15 days Wed 10/3/18 Tue 10/23/18
Erect fence 10 days Wed 10/24/18 Tue 11/6/18
Demolition of existing structure 15 days Wed 11/7/18 Tue 11/27/18
Disposal of demolished material,
off site 5 days Thu 3/7/19 Wed 3/13/19
Top soil removal and reduce
level excavation 18 days Wed 11/28/18 Fri 12/21/18
Hardcore filling and compacting 15 days Mon 12/24/18 Fri 1/11/19
Erect site accommodation 15 days Mon 1/14/19 Fri 2/1/19
Fit out 21 days Wed 2/13/19 Wed 3/13/19
Electrical services 6 days Fri 1/25/19 Fri 2/1/19
Temporary drain connection 15 days Mon 1/14/19 Fri 2/1/19
Excavate and lay water service 7 days Mon 2/4/19 Tue 2/12/19
Fit gates 7 days Mon 2/4/19 Tue 2/12/19
c) Calculate total and free float of non-critical activities
Activity Total float Free float
A 0 0
B 0 0
C 0 0
D 0 0
E 0 0
F 0 0
G 0 0

6
PROJECT MANAGEMENT
H 0 0
I 12 27
J 25 25
K 8 23
L - -
d) Altering Electric Service Activity
Since the number of days increase even more than the total float, the activity will be
influencing the entire project timeline and even the activity will not be a critical activity anymore
as shown in the below picture.
Figure 2: Gantt chart after amendments to Electric Services
(Source: Created by Author)

7
PROJECT MANAGEMENT
Amended Network Diagram
Figure 3: Network Diagram after amendments (Critical Path in Red)
(Source: Created by Author)
Question 2
a) Gantt chart with early start times

8
PROJECT MANAGEMENT
Slack
Critical Task
Non – critical task
Figure 4: Gantt chart after altering timeline of Electric Services
(Source: Created by Author)
In manner to accomplish the project one day earlier it is crucial to manipulate the timeline of the
critical activity for a day and make sure that the project is accomplished one day earlier. Moreover, in manner
to alter the non-critical activity, it is obvious to manipulate the non-critical activity one dat earlier than the
calculated slack.
Question 3 Cost overview
Overall estimated budget without contingency (graphical presentation)
Figure 5: Graphical representation of cost and activity per month

9
PROJECT MANAGEMENT
(Source: Created by Author)
Activity Start Finish Cost
A Wed 10/3/18 Tue 10/23/18 $110,600.00
B Wed 10/24/18 Tue 11/6/18 $53,250.00
C Wed 11/7/18 Tue 11/27/18 $65,125.00
D Wed 11/28/18 Tue 12/4/18 $38,800.00
E Wed 11/28/18 Fri 12/21/18 $110,600.00
F Mon 12/24/18 Fri 1/11/19 $75,825.00
G Mon 1/14/19 Fri 2/1/19 $8,170.00
H Mon 2/4/19 Mon 3/4/19 $17,230.00
I Wed 11/28/18 Wed 12/5/18 $14,650.00
J Wed 11/28/18 Tue 12/18/18 $21,450.00
K Wed 11/28/18 Tue 12/11/18 $41,775.00
L Mon 2/4/19 Tue 2/12/19 $5,250.00
Total $562,725.00
Budget with Contingency plan
Activity Start Finish Cost
A Wed 10/3/18 Tue 10/23/18 $110,600.00
B Wed 10/24/18 Tue 11/6/18 $53,250.00
C Wed 11/7/18 Tue 11/27/18 $65,125.00
D Wed 11/28/18 Tue 12/4/18 $38,800.00
E Wed 11/28/18 Fri 12/21/18 $110,600.00
F Mon 12/24/18 Fri 1/11/19 $75,825.00
G Mon 1/14/19 Fri 2/1/19 $8,170.00
H Mon 2/4/19 Mon 3/4/19 $17,230.00
I Wed 11/28/18 Wed 12/5/18 $14,650.00

10
PROJECT MANAGEMENT
J Wed 11/28/18 Tue 12/18/18 $21,450.00
K Wed 11/28/18 Tue 12/11/18 $41,775.00
L Mon 2/4/19 Tue 2/12/19 $5,250.00
Expected Budget $562,725.00
Contingency plan $56,272.50
Total Budget $618,997.50
Tue 10/23/18
Tue 11/6/18
Tue 11/27/18
Tue 12/4/18
Fri 12/21/18
Fri 1/11/19
Fri 2/1/19
Mon 3/4/19
Wed 12/5/18
Tue 12/18/18
Tue 12/11/18
Tue 2/12/19
A B C D E F G H I J K L
$0.00
$20,000.00
$40,000.00
$60,000.00
$80,000.00
$100,000.00
$120,000.00
Cost
Figure 6: Cost Overview
(Source: Created by Author using Excel)
Month wise budget distribution
Year Month Budget
2018 October $163,850.00

11
PROJECT MANAGEMENT
November $292,400.00
December $75,825.00
2019 January $8,170.00
February $22,480.00
Cash Flow
3 4 1
$0.00
$100,000.00
$200,000.00
$300,000.00
$400,000.00
$500,000.00
$600,000.00
$0.00
$100,000.00
$200,000.00
$300,000.00
$400,000.00
$500,000.00
$600,000.00
Cost Cumulative Cost
Figure 7: Cumulative cost
(Source: Created by Author)

12
PROJECT MANAGEMENT
Bibliography
Kerzner, H. and Kerzner, H.R., 2017. Project management: a systems approach to planning,
scheduling, and controlling. John Wiley & Sons.
Turner, J.R., 2014. Handbook of project-based management(Vol. 92). New York, NY: McGraw-
hill.