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 Normal Normal Activity Max Crash Crash Duration Cost cost/Slope A None 2 150 1 100 B A 3 100 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 0Crash Costs Table Normal Duration Preceeding Activity Activity Paths Steps Crash Total Cost Crash Calculations Activity Slope 100 80 60 40 40 40 20 Total> Crash Cost Adj total Costs (Norm+Crash)