Please also give a step-by-step on how to enter it and use Excel Solver to solve.

The business school department 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. These ratings are shown in the following table. Find the best assignment of professors to the course to maximize the overall teaching rating. - Formulate an LP problem to maximize the overall teaching rating. - Solve the LP using excel solver and interpret the solution. (Make sure to upload the Excel worksheet)