Formulate the mathematical problem

a. decision variables

b. objective functions

c. constraints

d. binding constraints

e. Solve the problem using EXCEL Solver Add-In

PROBLEM 2: (30 POINTS) Semester Prep The department chair reviewed last year's schedule, the degree requirements for the ever popular Operations and Supply Chain major, and the emails that had drifted into her mailbox over the last week. Naturally, every professor in the department had his 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, Project Management, Quality Management, Control and Planning, Logistics, and Management Science each had to be offered once and the department needed to offer at least six sections of the Introduction to Operations class. The prep times each professor estimated for each course appear in the table below. 16 Saba Geoff Tim David Intro to Ops 3 4 5 4 Project Quality Contr Logisti Mgt Mgt Mgt ol CS Science 10 12 12 7 19 2 10 8 18 11 4 14 14 3 11 4 15 17 15