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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!