=E*3.32. Consider the assignment problem having the following cost table:

Job 1 2 3 Person A $5 $7 $4 B 3 6 5 C 2 3 4 The optimal solution is A-3, B-1, C-2, with a total cost of $10.

Formulate this problem on a spreadsheet and then use the Excel Solver to obtain the optimal solution identified above.