2. [20 points] The department chair of a business school has decided to apply a new...

    

Transcribed Image Text:

2. [20 points] The department chair of a business school has decided to apply a new method in assigning professors to courses next semester. As a criterion for judging who should teach each course, the department chair reviews the past two years teaching evaluations (which were filled out be students). With the help of an MBA student, the chair has developed a linear program to assign professors to the courses to maximize the overall teaching rating. The linear program (which was coded in LP Solve and Excel Solver) is given with the assignment. After developing the LP, three new professors (with teaching experience) were hired for the next semester and their teaching ratings are shown in the following table. (NR - No-rating means the professor is not qualified to teach that course, i.e. student rating would be zero.) COURSE PROFESSOR ACCOUNTING Anderson 90 Sweeney 70 Williams 85 Johnson NR Cormier Brown 50 65 MANANGMENT FINANCE ECONOMICS 65 60 40 80 60 80 95 80 80 70 70 NR NR 75 60 75 80 50 MARKETING SUPPLY CHAIN NR NR 70 60 90 65 75 85 0 NR 65 85 a. What is the current solution for assigning 3 professors to 3 courses? (Please see the Q2 Model.mod file or Q2 Model.xlsx file to see the data and the model). Which professor is assigned to what class? What is the total rating? (Hint: *.mod files can be opened with Notepad or similar text editor software in addition to LP Solve). b. Modify the Linear Programming model and find the best assignment of 6 professors to 6 courses to maximize the overall teaching rating. Which professor is assigned to what class? What is the total rating? 2. [20 points] The department chair of a business school has decided to apply a new method in assigning professors to courses next semester. As a criterion for judging who should teach each course, the department chair reviews the past two years teaching evaluations (which were filled out be students). With the help of an MBA student, the chair has developed a linear program to assign professors to the courses to maximize the overall teaching rating. The linear program (which was coded in LP Solve and Excel Solver) is given with the assignment. After developing the LP, three new professors (with teaching experience) were hired for the next semester and their teaching ratings are shown in the following table. (NR - No-rating means the professor is not qualified to teach that course, i.e. student rating would be zero.) COURSE PROFESSOR ACCOUNTING Anderson 90 Sweeney 70 Williams 85 Johnson NR Cormier Brown 50 65 MANANGMENT FINANCE ECONOMICS 65 60 40 80 60 80 95 80 80 70 70 NR NR 75 60 75 80 50 MARKETING SUPPLY CHAIN NR NR 70 60 90 65 75 85 0 NR 65 85 a. What is the current solution for assigning 3 professors to 3 courses? (Please see the Q2 Model.mod file or Q2 Model.xlsx file to see the data and the model). Which professor is assigned to what class? What is the total rating? (Hint: *.mod files can be opened with Notepad or similar text editor software in addition to LP Solve). b. Modify the Linear Programming model and find the best assignment of 6 professors to 6 courses to maximize the overall teaching rating. Which professor is assigned to what class? What is the total rating?

Answer rating: 100% (QA)

a To determine the current solution for assigning 3 professors to 3 courses we need to refer to the given LP model and the professor ratings provided ... View the full answer