Use the information contained below to create a network diagram. Then compress one-time unit per move using the least cost method. Reduce the schedule until you reach the crash point of the network. For each move identify what activity(ies) was crashed and the adjusted total cost.

1. Create a network diagram
2. Calculate paths and identify the critical path
3. Create a table that calculates crash costs and adjusted total costs with headings: Activity. Norm Duration, Norm Cost, Max Crash, Slope, Crash Cost, Adj Total Costs, in that order.
4. Identify the activity at each step that was crashed, number of crash steps, and total costs

Submit your Excel workbook to the link in this assignment by the deadline.

Activity	Preceding Activity	Normal Duration	Normal Cost	Max Crash	Crash cost/Slope
A	None	2	150	1	100
B	A	3	100	1	80
C	B	2	200	1	60
D	B	5	200	1	40
E	A	5	200	2	40
F	C	3	150	2	40
G	D	5	200	1	20
H	E, F, G	1	200	0	0