Peterborough municipality are working to build a new state of the art medical center at the end of Lansdowne west. The following was the plan that they had approved. Work was to start on September 6, 2021. Assuming that each month is 20 working days (for manual / excel calculations) and all durations below are in Months. Also assume that tasks that require more than one month have the cost split evenly between the months.

Task identifier	Task Description	Predecessor	Duration (d)	Cost
A	Ground breaking		1	$1,500,000
B	Foundation	A	2	$3,000,000
C	Steel Frame	B	2	$5,000,000
D	Shell	B	3	$6,000,000
E	Interior Frame	D	3	$3,000,000
F	Plumbing	E	2	$1,000,000
H	HVAC	C	2	$2,000,000
I	Gas	H	1	$1,500,000
J	Alarm	I, F	2	$1,000,000
K	Telephone	J	2	$1,000,000
L	Cable	J	1	$1,000,000
M	Finish Work	L,K	2	$1,000,000

PART 1: Basics

1. Open an Excel file in the first sheet,

a. draw a network diagram to show this project. Answer the questions in the same excel sheet

b. What are the paths and their durations? Which path(s) is the critical path?

c. Name 3 different scheduling risks apparent from your network diagram and explain what they are.

d. What task is not on the critical path?

e. How long will it take to complete the project (total project duration)?

f. use a forward pass and a backward pass and calculate early start and finish and late start and finish. Calculate float.

g. What is the float of task H and task L