Set up an excel file to complete the assignment problem and have 1 answer report, 1 sensitivity report and 1 limit report included (you can delete the ones that are incorrect, should you have any). You will attach this file upon submitting the assignment.

Also answer

1. What is the minimum total to for this assignment problem while meeting the characteristics of the problem?
2. Indicate which operator works with each machine in the optimal solution.

What would happen to total time if the different assignment to have operator 1 work with machine A, operator 2 work with machine B, and so on down the diagonal was made instead of the optimal assignment

Exhibit C C A plant has four operators to be assigned to four machines. The time (minutes) required by each worker to produce a product on each machine is shown in the following table: Machine (min.) Operator A B D 10 1 2 3 4 5 12 8 12 10 14 15 9 7 13 11 11 8 11 9 Exhibit C C A plant has four operators to be assigned to four machines. The time (minutes) required by each worker to produce a product on each machine is shown in the following table: Machine (min.) Operator A B D 10 1 2 3 4 5 12 8 12 10 14 15 9 7 13 11 11 8 11 9