Question: I really need help with what to enter in Excel. I keep getting the following: OBJECTIVE FUNCTION MIN (COST) $ 148.50 DECISION VARIABLES Program 1

I really need help with what to enter in Excel. I keep getting the following:
| OBJECTIVE FUNCTION | |
| MIN (COST) | $ 148.50 |
| DECISION VARIABLES | ||||||
| Program 1 | Program 2 | Program 3 | Program 4 | Program 5 | Program 6 | |
| Roy | 0 | 0 | 0 | 0 | 0 | 0 |
| Amy | 0 | 3 | 0 | 0 | 0 | 3 |
| John | 0 | 0 | 0 | 3 | 0 | 0 |
| Jack | 3 | 0 | 0 | 0 | 1 | 0 |
| Mary | 0 | 0 | 3 | 0 | 1 | 0 |
| Mark | 0 | 0 | 0 | 0 | 0 | 0 |
| Linda | 0 | 0 | 0 | 0 | 1 | 0 |
Problem 4: Assignment Problem Programmer /Program11 Program 1 Program 2 Program 3 Program 4 Program 5 Program 6 Roy 15 15 19.5 15 15 15 Amy 9 8 20.5 6 28 8 John 16 20 13 5 21 20 Jack 5.5 19 16 5.5 9 19 Mary 12 12 12 12 12 12 Mark 22 12 12 12 12 12 Linda 12 12 22 12 12 12 Pro Inc. assigns programmers to develop programs. Assignment of a programmers to a program incurs cost which is given in the table above. Find out which assignment of the programmer to program will incur minimum cost. There are certain situations we need to take into account while we are doing the assignments. Firstly, each program needs at least 3 programmers working on each program. Secondly, Roy and Mark cannot work on more than three projects. Thirdly, Jack has mentioned that he wants to work on either program 4 or 5. Fourthly, Mary wants to work on at least 4 programs. Finally, programs requires the expertise of Linda
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
