The CoBE chair reviewed last year's schedule, the degree requirements for the everpopular Business Analytics major, and the emails that had drifted into her mailbox over the last week. Naturally, every professor in the college had his/her own pet course and wanted to maintain control of it while avoiding 8 a.m. classes at all costs. In an effort to placate the senior faculty members of the department, the chair sent an email asking them to supply the prep time for each of the classes they were qualified to teach, promising to assign them the least taxing schedule possible. Each of her department members had to teach at least two courses, but no more than three. The elective courses, QBA 362, MGT 330, MGT 424, MKT 315, and MKT 318 each had to be offered once and the college needed to offer at least six sections of the QBA 300 class. The prep times each professor estimated for each course appear in the table below. a. Formulate the problem as an assignment problem. b. Find the optimal solution that minimizes the total prep time while meeting all college's requirements using Solver. c. Attach your formulation and Excel output