Hello, Could someone show me how to do this on excel with the formulas?

An office has five workers, and five tasks have to be performed. Workers differ in efficiency and tasks differ in their intrinsic difficulty. Time each worker would take to complete each task is given in the effectiveness matrix. How the tasks should be allocated to each worker so as to minimize the total employee-minutes?

Show your work in the tables in the excel HW file and also write down your action. Once you have the final table, answer who should be assigned which task.

the formulas and steps to solve this on excel?

An office has five workers, and five tasks have to be performed. Workers differ in efficiency and tasks differ in their intrinsic difficulty. Time each worker would take to complete each task is given in the effectiveness matrix. How the tasks should be allocated to each worker so as to minimize the total employee-minutes? Show your work in the tables in the excel HW file and also write down your action. Once you have the final table, answer who should be assigned which task. Taks 4 Taks 5 Taks 3 60 24 13 42 15 56 Taks 1 Taks 2 Jack 16 84 Lisa 41 57 Peter 66 78 Mike 47 71 Ashley 89 67 Task 2 is assigned to Lisa 32 13 39 38 92 40 78 27 73 The final cost of task 3 is 32 The final cost of task 5 is 40 The total cost is 170 The total cost is 150 Task 5 is assigned to Peter Ashley gets task 2 Task 4 is assigned to Lisa The final cost of task 2 is 23