The department chair is deciding which of his faculty to assign to teach four courses offered...

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.

Expert Solution

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.

keosha answered 1 year ago

An outbreak of salmonellosis occurred after an epidemiology department luncheon, which was attended by 485 faculty...

An outbreak of salmonellosis occurred after an epidemiology department luncheon, which was attended by 485 faculty and staff. Assume everyone ate the same food items. Sixty-five people had fever and diarrhea; five of these people were severely affected. Subsequent laboratory tests on everyone who attended the luncheon revealed an additional 72 cases. Foods served at the luncheon included home-canned olives, chicken salad, homemade flavored drink mix, freshly baked rolls, and raw vegetables. Based on your understanding of foods that potentially...

A university department is deciding which of the research proposals to support. Eight members of staff...

A university department is deciding which of the research proposals to support. Eight members of staff were asked to read the proposals and to award each of them a mark out of 100. Following are the marks awarded to the proposals. Staff Proposal 1 Proposal 2 1 53 75 2 46 67 3 60 69 4 53 51 5 66 76 6 59 59 7 52 65 8 67 68 Determine a 95% confidence interval for the difference in the...

List four procedures for screening projects and deciding which to accept or reject? What does a...

List four procedures for screening projects and deciding which to accept or reject? What does a net present value profile tell you, and how is it constructed? How does the IRR enter into the net present value profile? What is the difference between the IRR and the MIRR? What are mutually exclusive projects? How might they complicate the capital-budgeting process?

A town is deciding between alternatives on additional hospitals funding. There are four options which come...

A town is deciding between alternatives on additional hospitals funding. There are four options which come with corresponding tax increases: H (highest level funding), M (medium level), L (low level) and N (no additional funding). There are three groups of voters in the town. The rst group is Elderly people who need hospital services most, the second group is Young people who need hospital services the least but also don't want the low quality hospitals for the future. The third...

3) Frank is considering the following two investment options that his broker has offered. Which one...

3) Frank is considering the following two investment options that his broker has offered. Which one should he choose and why? (show work) Option 1) Deposit $50,000 today, and for the next 10 years make a payment of $1,000 at the end of each month. After 10 years, you will be able to withdraw a total of $300,000 from your account. Option 2) Deposit $80,000 today, and for the next 10 years make a payment of $10,000 at the end...

Question