The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses during the coming autumn term. Four core courses need to be covered. The four c...

Question

Question

The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses durin

The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses during the coming autumn term. Four core courses need to be covered. The four c...

The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses during the coming autumn term. Four core courses need to be covered. The four courses are at the undergraduate (UG), master of business admin- istration (MBA), master of science (MS), and doctor of philosophy (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 terms. Based on a rating scale of 4 (excellent), 3 (very good), 2 (average), 1 (fair), and 0 (poor), the average stu- dent evaluations for each professor are shown. Professor D does not have a Ph.D. and cannot be assigned to teach the Ph.D. level course. If the department head makes teaching assign- ments based on maximizing the student evaluation ratings over all four courses, what staff- ing assignments should be made? Course MBA Professor UG MS Ph.D 2.8 3.2 2.2 3.0 3.2 2.8 3.3 3.6 3.5 2.5 3.0 3.6 3.3 3.2 3.5

math Advanced-Math

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Let $U G_{A}, U G_{B}, U G_{C}$ , and $UGp$ represent the undergraduate course with professor A, B, C, and D , respectively.

Let $MBAA, MBAB, MBAo$ and $MBAD$ represent the master of business administration course with professor A, B, C, and D. respectively.

Let $MSA, MSB, MSc$ and $MSD$ represent the master of business administration course with professor A, B, C, and D. respectively.

Let $PHD_{A}, PHD_{B}, PHD_C$ and $PHDp$ represent the master of business administration course with professor A, B, C, and D. respectively.

Then we formulate the problem as follows:

max^ 3.2MBAc +2.8MB.Ap 3.3MSA +3.6MSB 3.5MSc 2.5MSD+ 3.0PhDA 3.6PhDB +3.5PhDc Subject to:

$MSA+MSB MSc+MSD 1 All Variables> 0$

Use EXCEL to solve for the optimal solution report using the following steps.

1. Select Solver from the Analysis Group in the Data Ribbon

2. Enter the proper values for the constraints and the objective function

3. Select Simplex LP

4. Click the checkbox for Make Unconstrained Variables Non-negative

5. Solve

The optimal solution is UG =D, MBA=C, MS=A, PhD=B, which generates a max value of 13.3.

That means, The optimal solution is to assign professor A to the MS course, professor B to the
Ph.D. course, professor c to the MBA course, and professor D to the undergraduate
course.

Add a comment

Answer 2

The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses during the coming autumn term. Four core courses need to be covered. The four c...

Homework Answers

Add Answer to:
The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses during the coming autumn term. Four core courses need to be covered. The four c...

Post as a guest

Earn Coins

The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses during the coming autumn term. Four core courses need to be covered. The four c...

Homework Answers

Add Answer to: The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses during the coming autumn term. Four core courses need to be covered. The four c...

Post as a guest

Earn Coins

Add Answer to:
The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses during the coming autumn term. Four core courses need to be covered. The four c...