In the class, we have formulated a linear programming $($LP$)$ model to find the optimal plan to

speed up activities to meet a desired deadline. The model has been discussed in the class.

You can use the Excel file $<$ LP Model$>$ and the Solver in Excel to find the optimal

solution if you are given a desired deadline. Now your task is to change the desired deadline

and use the Solver to

find the optimal plan for each desired deadline. Plot the graph showing the relationship between

the least costs and the desired deadline. Examine the optimal solutions, and concisely report

any insights or findings $($this is an open question$).$

BELOW IS THE EXCEL FILE SHOWING THE LP MODEL,

$$ Decision Variable$$ Activity$$ Duration Cost objective function A $511107\mathrm{.}2$ B $14$ C $616$ D $510$ E $518$ F $636\mathrm{.}2$ G $212$ Event Time $00152636411517619$ Constraint x$(0)+$dA $5<=$x$(1)$ x$(0)+$dC $6<=$x$(2)$ x$(1)+$dB $6<=$x$(3)$ x$(2)+$dD $11<=$x$(4)$ x$(3)+$dE $11<=$x$(4)$ x$(4)+$dF $17<=$x$(5)$ x$(5)+$dG $19<=$x$(6)$