Consider the assignment problem having the following cost table.
(a) Draw the network representation of this assignment problem.
(b) Formulate this problem as a transportation problem by constructing the appropriate parameter table.
(c) Display this formulation on an Excel spreadsheet.
(d) Use the Excel Solver to obtain an optimal solution.