2. [20 points] The department chair of a business school has decided to apply a new...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. [20 points] The department chair of a business school has decided to apply a new method in assigning professors to courses next semester. As a criterion for judging who should teach each course, the department chair reviews the past two years teaching evaluations (which were filled out be students). With the help of an MBA student, the chair has developed a linear program to assign professors to the courses to maximize the overall teaching rating. The linear program (which was coded in LP Solve and Excel Solver) is given with the assignment. After developing the LP, three new professors (with teaching experience) were hired for the next semester and their teaching ratings are shown in the following table. (NR - No-rating means the professor is not qualified to teach that course, i.e. student rating would be zero.) COURSE PROFESSOR ACCOUNTING Anderson 90 Sweeney 70 Williams 85 Johnson NR Cormier Brown 50 65 MANANGMENT FINANCE ECONOMICS 65 60 40 80 60 80 95 80 80 70 70 NR NR 75 60 75 80 50 MARKETING SUPPLY CHAIN NR NR 70 60 90 65 75 85 0 NR 65 85 a. What is the current solution for assigning 3 professors to 3 courses? (Please see the Q2 Model.mod file or Q2 Model.xlsx file to see the data and the model). Which professor is assigned to what class? What is the total rating? (Hint: *.mod files can be opened with Notepad or similar text editor software in addition to LP Solve). b. Modify the Linear Programming model and find the best assignment of 6 professors to 6 courses to maximize the overall teaching rating. Which professor is assigned to what class? What is the total rating? 2. [20 points] The department chair of a business school has decided to apply a new method in assigning professors to courses next semester. As a criterion for judging who should teach each course, the department chair reviews the past two years teaching evaluations (which were filled out be students). With the help of an MBA student, the chair has developed a linear program to assign professors to the courses to maximize the overall teaching rating. The linear program (which was coded in LP Solve and Excel Solver) is given with the assignment. After developing the LP, three new professors (with teaching experience) were hired for the next semester and their teaching ratings are shown in the following table. (NR - No-rating means the professor is not qualified to teach that course, i.e. student rating would be zero.) COURSE PROFESSOR ACCOUNTING Anderson 90 Sweeney 70 Williams 85 Johnson NR Cormier Brown 50 65 MANANGMENT FINANCE ECONOMICS 65 60 40 80 60 80 95 80 80 70 70 NR NR 75 60 75 80 50 MARKETING SUPPLY CHAIN NR NR 70 60 90 65 75 85 0 NR 65 85 a. What is the current solution for assigning 3 professors to 3 courses? (Please see the Q2 Model.mod file or Q2 Model.xlsx file to see the data and the model). Which professor is assigned to what class? What is the total rating? (Hint: *.mod files can be opened with Notepad or similar text editor software in addition to LP Solve). b. Modify the Linear Programming model and find the best assignment of 6 professors to 6 courses to maximize the overall teaching rating. Which professor is assigned to what class? What is the total rating?
Expert Answer:
Answer rating: 100% (QA)
a To determine the current solution for assigning 3 professors to 3 courses we need to refer to the given LP model and the professor ratings provided ... View the full answer
Related Book For
Quantitative Analysis for Management
ISBN: 978-0132149112
11th Edition
Authors: Barry render, Ralph m. stair, Michael e. Hanna
Posted Date:
Students also viewed these economics questions
-
Daniel Glaser, chairman of the College of San antonios business department, needs to assign professors to courses next semester. As a criterion for judging who should teach each course, Professor...
-
Roscoe Davis, chairman of a college's business department, has decided to apply a new method in assigning professors to courses next semester. As a criterion for judging who should teach each course,...
-
With only a straightedge and compass, use a number line and the Pythagorean theorem to construct a segment whose length is 2. Measure the segment as accurately as possible, and write your answer in...
-
The circuit in FIGURE 21-43 includes a battery with a finite internal resistance, r = 0.50 . Figure 21-43, (a) Find the current flowing through the 7.1- and the 3.2- resistors. (b) How much current...
-
SWAT Surplus began March 2018 with 100 tents that cost $10 each. During the month, the company made the following purchases at cost: The company sold 318 tents, and at March 31, the ending inventory...
-
A single acting reciprocating pump has to deliver water against a total head of 50 m. The plunger diameter is 120 mm. What is the force exerted by the plunger during delivery stroke? Assume pump...
-
John conducted a repeated-measures study to measure self-esteem among victims of domestic violence before and after they complete an 8-week program for abuse victims with 10 individuals. He...
-
A 22 kg dolphin moving in the positive direction decelerates from 12.5 to 8.5 m/s in 2.5 s to join another dolphin in play. What average force, in newtons, was exerted to slow him if he was moving...
-
Financial information on AAA Ltd. is shown below. AAA Ltd. Income Statement For the Year Ended December 31st, 2019 2018 Sales 4,215,750 3,850,000 Cost Of Goods Sold 2,178,700 2,016,320 Other Expenses...
-
James provides lawn services to ABC Corporation. James spends about 25 hours per week on the premises of ABC. He does not have any other clients. When ABC does not heed landscaping and lawn care...
-
In Illinois, when two of four children turn 18 years old how much child support is lost? Currently receiving $1900.00 per month for four children.
-
7 week 5, Excerciese 1/1: Splines in a geometry shader O A geometry shader is an optional shader stage between the vertex and the fragment shader. The geometry shader takes a geometric primitive,...
-
A and B own farms in southern Ontario next to one another in an area where the land registry system applies. They have access to their farms by means of a road that runs along the northerly edge of...
-
Suppose we want to know if the number of hours spent studying and the number of prep exams taken affects the score that a student receives on a certain college entrance exam To explore this...
-
Find the domain and range of the function f(x, y) = VT+ I
-
The liquidliquid extractor in Figure 8.1 operates at 100F and a nominal pressure of 15 psia. For the feed and solvent flows shown, determine the number of equilibrium stages to extract 99.5% of the...
-
Managers are quick to claim that quantitative analysts talk to them in a jargon that does not sound like English. List four terms that might not be understood by a manager. Then explain in...
-
A second cashier is added to the grocery store in Problem 13-37, and this cashier works at the same rate as the original one. Assume the arrival rate does not change. (a) What is the average length...
-
Rob Roller has been in charge of inventory policy at Cyclorama, a large retail bicycle shop in Orlando, Florida. He now orders Chrome-Moly frames from Frameco, a local frame supplier. Cyclorama...
-
Action Quest Games adjusts its accounts annually. The following information is available for the year ended December 31, 2025. 1. Purchased a 1-year insurance policy on June 1 for $1,800 cash. 2....
-
With each pass of a comet about the Sun, the comets mass (a) remains virtually unchanged. (b) actually increases. (c) is appreciably reduced.
-
Why is carbon such a special atom?
Study smarter with the SolutionInn App