Question

The department chair is deciding which of his faculty to assign to teach four courses offered next year.  Four of his faculty, Anderson, Sweeney, Williams, and McKinney, have taught each one of these courses several times over the last 3 years.  Teaching evaluations by students were collected and summarized for these professors by course in the following table:

		Evaluation Scores by Professor by Course
			Course
	Professor	Analytics	Services	Sourcing	Opns Mgmt
	Anderson	90	65	95	40
	Sweeney	70	60	80	75
	Williams	85	40	80	60
	McKinney	55	80	65	55

Find the best assignment of professors to these four courses to maximize the overall teaching ratings.

Answer 1

Answer :

Explanation :

We have to maximize the overall teaching ratings.

Here, we have created a table where for every subject if that particular teacher is teaching it then the value in the corresponding cell is 1 otherwise 0.

We want only 1 teacher to teach 1 subject and every subject has 1 teacher assigned. Hence the row sum and column sum of each teacher and subject respectively should be 1.

Eg. If analytics, for example, is being taught by Anderson then the cell in the column for Analytics with Anderson row will have value 1 and rest three teachers' corresponding values for Analytics will be 0.

Following are the values to be added the solver.