You will need to save the Excel file you create to solve this problem as it will need to be submitted $($uploaded$)$ as part of your overall solution.

A project is composed of five activities $($A$,$ B$,$ C$,$ D$,$ and E$).$ Suppose we have the following crashing data and network information:

Immediate Normal Crash

Activity Predecessor Time $($days$)$ Time $($days$)$ Normal Cost Crash Cost

A $----85$ $$500$ $$800$

B A $43$ $$200$ $$350$

C $----75$ $$500$ $$900$

D C $42$ $$200$ $$500$

E B$,$D $32$ $$300$ $$550$

Suppose management desires an $11$ day project completion time. Formulate a linear programming model that can be used to assist with the crashing decisions. Using this, what activities should be crashed and by how much? What is the total crashing cost?

Upload a copy of the final Excel file used to complete this problem using the Add File selection button below. You will need to calculate the crash cost per day before setting up your linear program.