Assignment Problem

Assignment

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