Objective
The project manager would like to crush the total project duration to 40 weeks with the minimum cost,
so the requirement of the selected task should be on the critical path, which does not have any floats.
Overall, the crushing cost would be the objective value of the solver function, and the variable should be
the quantity of the crushing weeks.
Methodology
Based on the chart above, the crashing cost formula is listed below:
100*Xa+50*Xb+80*Xc+40*Xd+160*Xe+40*Xf+40*Xg+60*Xh+30*Xi+30*Xj+40*Xk+50*Xl+100*Xm+60*X
n
The constraints are listed below based on the crashed activity duration:
Xa<= 1, Xb<=2, Xc<=7, Xd<=4, Xe<=3,Xf<=3,Xg<=4,Xh<=6,Xi<=5, Xj<=6, Xk<=3, Xl<=3, Xm<=1, Xn<=3
Based on the critical path study (A-V-C-E-F-J-K-N), the starting data variables are set below.
Ya=0,Yb=2-Xa,Yc=Yb+4-Xb,Ye=Yc+10-Xc, Yf=Ye+4-Xe, Yj=Yf+5-Xj, Yk=Yj+8-Xj,Yn=Yk+4-Xk
The project manager would like to crush the total project duration to 40 weeks with the minimum cost,
so the requirement of the selected task should be on the critical path, which does not have any floats.
Overall, the crushing cost would be the objective value of the solver function, and the variable should be
the quantity of the crushing weeks.
Methodology
Based on the chart above, the crashing cost formula is listed below:
100*Xa+50*Xb+80*Xc+40*Xd+160*Xe+40*Xf+40*Xg+60*Xh+30*Xi+30*Xj+40*Xk+50*Xl+100*Xm+60*X
n
The constraints are listed below based on the crashed activity duration:
Xa<= 1, Xb<=2, Xc<=7, Xd<=4, Xe<=3,Xf<=3,Xg<=4,Xh<=6,Xi<=5, Xj<=6, Xk<=3, Xl<=3, Xm<=1, Xn<=3
Based on the critical path study (A-V-C-E-F-J-K-N), the starting data variables are set below.
Ya=0,Yb=2-Xa,Yc=Yb+4-Xb,Ye=Yc+10-Xc, Yf=Ye+4-Xe, Yj=Yf+5-Xj, Yk=Yj+8-Xj,Yn=Yk+4-Xk
