to

Create a network diagram

Calculate paths and identify the critical path

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.

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$