Use the Excel Start File to

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

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

AutoSave Off HI Mod 4 Application Start - Protected View O Search File Home Insert Draw Page Layout Formulas Data Review View Help O PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing M16 f . D E F G H 1 J K N 0 P Q R S T U V B C Crash Costs Table L M Crash Calculations 1 Normal Normal Cost Preceedin Activity None Crash Max Crash cost/Slope Activity 2 3 4 Duration 2 Aaj Total Costs Crash (Norm+Crash Max Crash Slope Cost 1 100 1 80 1 60 1 40 1 Activity B Normal Duration 2 3 2 B A 100 80 60 3 1 2 1 Normal Cost 150 100 200 200 200 150 200 200 D 5 1 D 5 6 7 8 9 5 150 100 200 200 200 150 200 200 E 5 2. 5 B C D 40 F F 3 F G 40 40 40 20 0 2 1 0 3 5 1 G H 2 1 0 40 20 H E, F, G 1 0 Total Network Diagram Activity Dur A Paths 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Steps Crash Total Cost Crash Calculations +