This problem must be done in Excel. The attached Excel Shell file contains data for a CPM project. Setup the CPM model in Excel. Using Solver determine the least possible project completion time at the least possible cost. Assume crashing must be in whole numbers. Prepare a well formatted printout.

Note:

Make sure you uncheck Ignore Integer Constraints and set Integer Optimality (%) to 0, by clicking Options in Solver. please show formulas in cells!

\begin{tabular}{l} Start time \\ \cline { 2 } Activity \\ \hline A \\ B \\ C \\ D \\ E \\ F \\ G \\ H \\ I \\ \hline J \\ \hline Completion time \\ \hline Normal project cost = \\ Cost of crashing = \\ Total cost \\ \hline \end{tabular} \begin{tabular}{l} Start time \\ \cline { 2 } Activity \\ \hline A \\ B \\ C \\ D \\ E \\ F \\ G \\ H \\ I \\ \hline J \\ \hline Completion time \\ \hline Normal project cost = \\ Cost of crashing = \\ Total cost \\ \hline \end{tabular}