Consider an assignment issue that has the following cost table.

a. Draw a network representation of this assignment problem. b. Formulate this problem as a transport problem by drawing up the appropriate parameter table. c. Determine the optimal assignment solution using the Hungarian method! d. Use Excel Solver to get the optimal solution.

\begin{tabular}{|cc|cccc} \hline & & \multicolumn{5}{|c}{ Task } \\ \cline { 3 - 6 } & & 1 & 2 & 3 & 4 \\ \hline \multirow{4}{*}{ Assignee } & A & 8 & 6 & 5 & 7 \\ & B & 6 & 5 & 3 & 4 \\ & C & 7 & 8 & 4 & 6 \\ & D & 6 & 7 & 5 & 6 \\ \hline \end{tabular}