Given a transportation problem with the following cost,

Formulate the problem as a general liner programing model

Solve this problem using Ms Excel Solver.

\begin{tabular}{crrrr} \hline & \multicolumn{4}{c}{ To } \\ \cline { 2 - 5 } From & \multicolumn{1}{c}{1} & 2 & 3 & \\ \hline A & $6 & 9 & M & 130 \\ B & 12 & 3 & 5 & 70 \\ C & 4 & 8 & 11 & 100 \\ \hline Demand & 80 & 110 & 60 & \\ \hline \end{tabular} \begin{tabular}{crrrr} \hline & \multicolumn{4}{c}{ To } \\ \cline { 2 - 5 } From & \multicolumn{1}{c}{1} & 2 & 3 & \\ \hline A & $6 & 9 & M & 130 \\ B & 12 & 3 & 5 & 70 \\ C & 4 & 8 & 11 & 100 \\ \hline Demand & 80 & 110 & 60 & \\ \hline \end{tabular}