Kelly Spaugh, course scheduler of a technical college$$s business department, needs to assign instructors to courses next semester. As a criterion for judging who should teach each course, Kelly reviews the student evaluations of teaching for the past two years. Because each of the four professors taught each of the four courses at one time or another during the two$-$year period, Kelly is able to determine a course rating for each instructor. These ratings are shown in the table at the bottom of this page.

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

In addition to uploading the solution in the solutions view, take a screenshot or PDF of the formula view and upload it as well.

You are required to provide a written answer to the specific questions asked, to show that you understand how to interpret the spreadsheet solution. Failure to do so will result in a deduction of $10$ points. An example of the written answer is: The number of units needed to breakeven is $10,000$ units and the breakeven dollar amount is $$50,000$

PLEASE ANSWER THIS IN EXCEL WITH THE FORMAT REQUIRED. ALSO, MAKE SURE YOU INCLUDE THE FORMULA VIEW I NEED TO ALSO UPLOAD.

Thank you so much, I will vote you!