Solve using excel. Use solver and solver table. Please add what your inputs are for both.

1 Assignment Homework 2 3 4 5 Suppose a firm has 4 tasks which need to be completed and 5 employees who could potentially complete the task. The amount of time each employee would take to complete each task are provided. Blank spaces indicate the employee lacks the qualifications to complete the task. Use Solver to find the optimal assignment of these employees ensuring each employee only completes 1 task, each task is completed, and employees are not assigned to tasks for which they are unqualified. (HINT: There are a few ways to ensure unqualified employees aren't assigned to tasks. Think about how to "force" Solver not to consider them as a solution for these tasks.) The total time should be 75 in the optimal solution. 7 8 9 10 11 12 13 14 Task times 15 16 Employee 1 17 Employee 2 18 Employee 3 19 Employee 4 20 Employee 5 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Task 1 22 18 26 16 21 Task 2 18 20 22 Task 3 30 27 28 25 Task 4 18 22 28 14 28 K