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

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 15

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!