Question: I NEED STEP BY STEP ON HOW TO SOLVE THIS IN EXCEL QM SOLVER. DONT JUST DO IT IN EXCEL BUT USE SOLVER! TRIED 3
I NEED STEP BY STEP ON HOW TO SOLVE THIS IN EXCEL QM SOLVER. DON"T JUST DO IT IN EXCEL BUT USE SOLVER! TRIED 3 TIMES NOW.
The Pointy-haired boss has five projects to assign and decides to go against all convention and assign them to individuals rather than project teams. He has the Elbonians estimate the labor cost in dollars of each possible assignment and that information is summarized in the table. Use Solver to determine which of these assignments is correct.
|
| Labor Costs for each possible assignment | ||||
| Project | Dilbert | Wally | Alice | Asok | Dogbert |
| 1 | 22 | 21 | 25 | 26 | 30 |
| 2 | 25 | 19 | 22 | 27 | 28 |
| 3 | 29 | 25 | 22 | 34 | 20 |
| 4 | 20 | 23 | 27 | 26 | 24 |
| 5 | 24 | 48 | 19 | 24 | 27 |
A) Project 3 = Dogbert
B) Project 2 = Alice
C) Project 3 = Alice
D) Project 4 = Wally
I NEED STEP BY STEP ON HOW TO SOLVE THIS IN EXCEL QM SOLVER. DON"T JUST DO IT IN EXCEL BUT USE SOLVER! TRIED 3 TIMES NOW.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
