The table for this problem describes the various activities of a construction project in a chemical plant.

(a) Set up and solve an LP model using Excel to crash this project to 22 days. What is the total crashing cost?

(b) Assuming each activity can only be crashed in whole days, what is the earliest completion of this project? What is the total associated crash cost?

Immediate Standard Time Standard Crash Time Activity Predecessors (days) Cost (days) Crash Cost A 4 $2,000 2 $2,600 $3,500 $3,300 $4,300 $3,900 A 6 5 A 8. 6 $1,200 $1,700 $1,800 $2,200 B 5 4 C, D 3 2 F E 7 $2,200 5 $3,600 $ 900 $1,200 $1,550 $1,700 G 5 4 H F, G 4 3 DE