The quantitative methods department head at a major midwestern university will bescheduling faculty to teach courses during the coming autumn term. Four core courses needto be covered. The four courses are at the undergraduate (UG), master of businessadministration (MBA), master of science (MS), and doctor of philosophy (Ph.D.) levels. Fourprofessors 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 scaleof 4 (excellent), 3 (very good), 2 (average), 1 (fair), and 0 (poor), the average studentevaluations for each professor are shown. Professor D does not have a Ph.D. and cannot beassigned to teach the Ph.D. level course.Professor UG MBA MS Ph.D.ABCDCourse2.7 2.1 3.23.1 2.9 3.53.23.1 3.43.1 2.7 2.42.93.53.4If the department head makes teaching assignments based on maximizing the studentevaluation ratings over all four courses, what staffing assignments should be made?

An assignment problem is a special kind of transportation problem. The objective of this type of…

Answered: The quantitative methods department…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A final assembly plant for a certain automobile model is to have a capacity of 240,000 units annually. The plant will operate 50 weeks/yr, two shifts/day, 5 days/week, and 8.0 hours/shift. It will be divided into three departments: (1) Body shop, (2) paint shop, (3) trim-chassis-final department. The body shop welds the car bodies using robots, and the paint shop coats the bodies. Both of these departments are highly automated. Trim-chassis-final has no automation. There are 15.5 hours of direct labor content on each car in this department, where cars are moved by a continuous conveyor. Determine: (a) Hourly production rate of the plant, (b) number of workers and workstations required in trim-chassis-final if no automated stations are used, the average manning level is 2.5, balancing efficiency = 93%, proportion uptime = 95%, and a repositioning time of 0.15 min is allowed for each worker.
The Monroe Logistics Company would like to schedule its drivers to minimize the number of drivers used to cover the requirements over all seven days of the week. The company has 6 cabs but needs all six of them on duty only on Fridays. The estimated requirements are as follows: Day Mon Tue Wed Thu Fri Sat Sun Requirements 6 4 4 4 6 3 3 Prepare a schedule that minimizes the total number of drivers needed and minimizes the amount of slack capacity. In case of ties for assignment, it is preferred to give weekend days off. Identify the slack capacity for each day of the week. In addition, please identify the number of people working less than full-time (i, e., working less than five days a week. This is employee scheduling program. No employee can be off on Friday and please do not change the requirement in the question. Thank you.
Quality Consulting has two consultants, Alfred and Barbara that can be scheduled to work for clients up to a maximum of 170 hours each over the next four weeks. A third consultant, Charlie, has some administrative assignments already planned and is available for clients up to a maximum of 150 hours over the next four weeks. The company has four clients with projects in process. The estimated hourly requirements for each of the clients over the four- week period are: Client Hours A: 180 B: 75 C: 100 D: 85 Hourly rates vary for the consultant-client combination and are based on several factors, including project type and the consultant’s experience. The rates (dollars per hour) for each consultant-client combination are as follows: Client Consultant A B C D Alfred 100 125 115 100 Barbara 120 135 115 120 Charlie 155 150 140 130 1) Develop a network…
A B C D F G H M N O P Raptor Consulting has three (3) projects to complete this year. They have four (4) project teams currently available. Each project team can at most do one project. Based on the mix of skills and experience on each of the teams, Raptor has developed the following estimates on time taken by each team (in days) to 2 complete each proiect. 3 4 5 6 7 8 9 10 Determine the optimal assignment of teams to projects in order minimize the total days taken to complete all the projects. 11 12 Please answer items A-E below 13 A. Formulate the problem as an assignment problem. Use worksheet tab "Q2 SS Model" to develop your formulation. 14 Use worksheet tab "Q2 SS Model" to develop your formulation 15 16 B. Solve the problem using Excel Solver. 17 Use worksheet tab "Q2 SS Model" Teams Project Team 1 Team 2 Project A 50 30 Project B 35 28 Project C 33 37 Ready Title Q1 E Accessibility: Investigate Team 3 Team 4 55 27 25 35 30 23 18 19 C. What is the optimal assignment of teams to…
Embassy Motorcycles (EM) manufactures two lightweight motorcycles designed for easy handling and safety. The EZ-Rider model has a new engine and a low profile that make it easy to balance. The Lady-Sport model is slightly larger, uses a more traditional engine, and is specifically designed to appeal to women riders. Embassy produces the engines for both models at its Des Moines, Iowa, plant. Each EZ-Rider engine requires 6 hours of
Casper Geriatric Center, a senior medical facility located in a large hospital in New Zealand, started a procedure where their guests receive their meals in their rooms while the food is still as hot as possible. The facility will continue to prepare the food in the commissary, but will now deliver it in bulk (not individual servings) to one of three new meal serving stations in the building. From there, the food will be reheated, meals will be placed on individual trays, loaded onto a cart, and distributed to the various floors and sections of the facility. The three new serving stations are as efficiently located as possible to reach the various hallways in the facility. The purpose of the new procedure is to increase the temperature of the hot meals that the guest receives. Therefore, the amount of time needed to deliver a tray from a serving station will determine the proper distribution of food from serving station to section. The table below summarizes the time associated with…
Problem 1 The Security Company in charge of rescuing visitors in the case of problems at "High Mountain Natural Park" in South Bekaa area has the intention to purchase special trained dogs to help their rescue team, so that they can conduct their search for lost people more efficiently. The rescue team is composed of 10 employees and the company is going to provide each of them with a trained dog. Two types of dogs were selected. The German Shepherd dog breed and the Belgium Malinois breed. The cost of the Belgium Malinois dog breed is $550,00 per dog, while the German Shepherd dog breed is at $850,00 each. For budget reason, the number of German Shepherd dog should be less than half the number of Belgium Malinois. For technical reason, at least three German Shepherd dog must be purchased to get advantage of the special performance of such dog breed in their particular capacity to search for lost person in all weather and under heavy conditions. The overall budget is $6500,00. All of…
Dongguk Furniture Is A Manufacturer Of Fine Hand-Crafted Furniture. During The Next Production Period, Management Is management is considering producing 3 products; dining room tables, dining room chairs, and/or bookcases. The time required for each item to go through the two stages of production (assembly and finishing), the amount of wood required (fine cherry wood), and the corresponding unit profits are given in the following table, along with the amount of each resource available in the upcoming production period. Formulate the objective functions and constraints determine the breakdown of each product and the expected profit
Diana are currently employed as full-time supervisor at a wealth management company in Kuala Lumpur, and she want to negotiate with the head manager, Mrs. Janice to work flexible hours from home on long term bases due to her condition which have previously miscarriage for two times. She is worried about her current pregnancy which just entered the second month. She and her husband has been waiting to conceive for more than 4 years. However, Diana want to implement this flexible hour (work remotely) to everyone in the company. Diana want to work remotely because she is now having to take care of herself as according to the doctor, she is so fragile at the early of her pregnancy. She must reduce her steps to make sure no bleeding could happen. Since she was on work from home mode for the last month as she is given bed rest by the doctor, she seems to prefer working in such condition. Diana found that working remotely gave her the flexibility and was able to concentrate a lot more…
Casper Geriatric Center, a senior medical facility located in a large hospital in New Zealand, started a procedure where their guests receive their meals in their rooms while the food is still as hot as possible. The facility will continue to prepare the food in the commissary, but will now deliver it in bulk (not individual servings) to one of three new meal serving stations in the building. From there, the food will be reheated, meals will be placed on individual trays, loaded onto a cart, and distributed to the various floors and sections of the facility. The three new serving stations are as efficiently located as possible to reach the various hallways in the facility. The purpose of the new procedure is to increase the temperature of the hot meals that the guest receives. Therefore, the amount of time needed to deliver a tray from a serving station will determine the proper distribution of food from serving station to section. The table below summarizes the time associated with…
Airline Scheduling. Alpha Airline wishes to schedule no more than one flight out of a given airport to each of the following cities: C, D, L, and N. The available departure slots are 8 a.m., 10 a.m., and 12 noon. Alpha leases the airplanes at the cost of $5000 before and including 10 a.m. and $3000 after 10 a.m., and is able to lease at most two per departure slot. Also, if a flight leaves for location N in a time slot, there must be a flight leaving for location L in the same time slot. The expected profit (in $1000) contribution before rental costs per flight is shown in the table below. Time Slot 8 10 12 C 10 6 6 D 9 10 9 L 14 11 10 N 18 15 10 a) Formulate an integer linear program model that can be used to find the profit-maximizing schedule. Define your decision variables as Xij = 1 if a flight to destination i occurs in time slot j and Xij = 0 otherwise; and Yj = number of airplanes rented for time slot j. Write the objective function and all the constraints. b)…

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS