Question: What is an appropriate objective function for this scenario? Which constraint is appropriate for this scenario? Which constraint ensures that Introduction to Operations is offered

What is an appropriate objective function for this scenario?
Which constraint is appropriate for this scenario?
Which constraint ensures that Introduction to Operations is offered according to the scenario?
Show all of the work from excel with formulas, and solver if used.
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 Project Mgt Quality Mgt Mgt Science Control 3 10 12 16 Saba Geoff Tim Logistics 12 8 14 4 19 2 10 7 18 3 5 11 4 14 David 4 11 4 15 17 15Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
