You Should use the solver tool to make the total cost the lowest possible value while assigning only 1 task to each person. A task can only be assigned once and a person can do only one task. All of the changing cells that say "total" should equal one as a result.

1. What are the decisions to be made? For this problem, we need Excel to find out which person to assign to which task (Yes=1, No=0). For example, if we assign Person 1 to Task 1, cell C12 equals 1. If not, cell C12 equals 0. 2. What are the constraints on these decisions? Each person can only do one task, Tasks Assigned = 1 for each person (row). Each task only needs one person, Persons Assigned=1 for each task (column). 3. What is the overall measure of performance for these decisions? The overall measure of performance is the total cost of the assignment, so the objective is to minimize this quantity (cost). Note: The formulas for Total Cost, Tasks Assigned, Persons Assigned cells are already provided. You need just to use the Solver tool to assign the tasks to the persons to achieve the lowest cost Try to solve the problem first manually and then use Solver tool, do you get the same result, which one is more efficient Task Cost Task 3 Labor Task 1 Task 2 Task 5 Task 4 $50 Person 1 $40 $47 $80 $70 Person 2 $72 $36 $58 $30 $60 Person 3 $24 $61 $71 $80 $55 Person 4 $30 $50 $77 $40 $35 Person 5 $45 $60 $70 $50 $60 Tasks to be completed Labor Task 1 Task 2 Task 3 Task 4 Task 5 Total Number of Tasks Assigned to Each Person Person 1 0 0 0 0 0 0 Person 2 0 0 0 0 0 0 0 Person 3 0 0 0 0 0 0 Person 4 0 0 0 0 0 0 0 0 0 0 0 0 Person 5 Total Number of Persons Assigned to Each Task 0 0 0 0 0 Total Cost $0 $