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 aualified to teach that course. i.e. student rating would be zero.) 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