Business Analytics department chair will be scheduling faculty to teach courses during the coming fall semester. Four core courses need to be covered. The four courses are at the UG, MBA, MS, and Ph.D. levels. Four professors will be assigned to the courses, with each professor receiving one of the courses. Student evaluations of professors are available from previous semesters. Based on a rating scale of 1 to 5, the average student evaluations for each professor are shown in the following table. Professor C does not have a Ph.D. and cannot be assigned to teach the Ph.D. level course. If the department chair makes teaching assignments based on maximizing the student evaluation ratings over all four courses, what staff assignments should be made? Course Professor UG MBA MS Ph.D. A 4.2 4.7 4.3 4.2 B 4.1 4.4 3.9 4.5 C 4.6 4.1 4.2 - D 4.8 4.0 4.6 4.4 a) Develop a network representation of this problem. b) Formulate a linear programming model for this problem. c) Solve the problem by using Excel Solver (Hand-in the value and formulas printouts for the problem). Show the optimal solution and optimal value in your printouts.
Business Analytics department chair will be
coming fall semester. Four core courses need to be covered. The four courses are at the
UG, MBA, MS, and Ph.D. levels. Four professors will be assigned to the courses, with
each professor receiving one of the courses. Student evaluations of professors are available
from previous semesters. Based on a rating scale of 1 to 5, the average student evaluations
for each professor are shown in the following table. Professor C does not have a Ph.D.
and cannot be assigned to teach the Ph.D. level course. If the department chair makes
teaching assignments based on maximizing the student evaluation ratings over all four
courses, what staff assignments should be made?
Course
Professor UG MBA MS Ph.D.
A 4.2 4.7 4.3 4.2
B 4.1 4.4 3.9 4.5
C 4.6 4.1 4.2 -
D 4.8 4.0 4.6 4.4
a) Develop a network representation of this problem.
b) Formulate a linear programming model for this problem.
c) Solve the problem by using Excel Solver (Hand-in the value and formulas printouts for
the problem). Show the optimal solution and optimal value in your printouts.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images
