In: Operations Management
4. Devos inc has 4 teams (A, B, C, D) and 4 (1, 2, 3, 4) potential tasks. The total amount of days each employee would need to allocate to each job is as follows:
|
Potential Tasks |
|||
Team |
1 |
2 |
3 |
4 |
A |
28 |
33 |
21 |
35 |
B |
41 |
43 |
23 |
37 |
C |
48 |
28 |
33 |
42 |
D |
49 |
27 |
43 |
46 |
Use Excel solver
Match the team the most efficient task. What is the total number of days that these projects will take to get worked on?
Below is the screenshot of the LP table -
Below is the screenshot of the formula applied -
Below is the screenshot of the solver -
Below is the screenshot of the result -