please do the calculations (excel preferred )

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. Intro to Ops Quality Mgt Saba 12 Project Mgt 3 4 5 4 Control 16 10 Logistics 12 8 Mgt Science 7 18 3 Geoff Tim David 2 10 19 11 11 4 14 14 4 15 17 15 What is an appropriate objective function for this scenario? (5 POINTS) Which constraint is appropriate for this scenario? (15 POINTS) NAME: Which constraint ensures that Introduction to Operations is offered according to the scenario? (20 POINTS)