| Assignment problem |
| Add or delate # of rows and columns |
| Enter Data in shaded light blue area and go to Solver and click on Solve |
| Make sure that the # of jobs and # of people are equal |
|
Job 1 |
Job 2 |
Job 3 |
Job 4 |
Job 5 |
| Person 1 |
7 |
8 |
9 |
10 |
12 |
| Person 2 |
12 |
6 |
8 |
9 |
12 |
| Person 3 |
13 |
10 |
12 |
8 |
13 |
| Person 4 |
10 |
99999 |
15 |
7 |
13 |
| Person 5 |
99999 |
7 |
11 |
9 |
99999 |
| Solution: |
Job 1 |
Job 2 |
Job 3 |
Job 4 |
Job 5 |
|
Cost |
| Person 1 |
1 |
0 |
0 |
0 |
0 |
1 |
7 |
| Person 2 |
0 |
0 |
1 |
0 |
0 |
1 |
8 |
| Person 3 |
0 |
0 |
0 |
0 |
1 |
1 |
13 |
| Person 4 |
0 |
0 |
0 |
1 |
0 |
1 |
7 |
| Person 5 |
0 |
1 |
0 |
0 |
0 |
1 |
7 |
|
1 |
1 |
1 |
1 |
1 |
|
42 |
|
|
|
|
|
|
Total Cost |
