F1 The business school department decided to apply a new method in assigningprofessors to courses next semester. As a criterion for judging who shouldteach each course, the department chair reviews the past two years' teachingevaluations. These ratings are shown in the following table. Find the bestassignment of professors to the course to maximize the overall teaching rating.• Formulate an LP problem to maximize the overall teaching rating.Solve the LP using excel solver and interpret the solution.(Make sure to upload the Excel worksheet)ProfessorAndersonSweeneyWilliamsMcKinneyStatistic90708555CourseManagement65604080Finance95808065Economics40756055

Professor/CoursesStatisticsManagementFinanceEconomicsAnderson90659540Sweeney70608075Williams85408060…

Answered: The business school department decided…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter12: Queueing Models

Section: Chapter Questions

Problem 59P

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
The chairperson of the department of management at Tech wants to forecast the number of students who will enroll in operations management next semester in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for the past 15 semesters: Using 2 Semester Weighted moving average compute the forecasted number of student for semester 16 the weight are 4 for the most recent semester and 2 for the older one. Semester Students Enrolled in OM 1 270 2 310 3 250 4 290 5 370 6 410 7 400 8 450 9 440 10 470 11 520 12 515 13 525 14 542 15 503
a) The demand forecast for Month 6 would be: A. 565 haircuts B. 574 haircuts C. 578 haircuts D. 584 haircuts b) With Mean Absolute Deviation (MAD) as the criterion, the best forecasting model for this time series data is: A. Naïve approach B. 2-week Simple Moving Average (SMA) C. Weighted Moving Average (WMA) with weights: 0.5, 0.3, 0.2 D. Exponential Smoothing (ES) with alpha = 0.8
Tom Glass forecasts electrical demand for the FlatlandsPublic Power District (FPPD). The FPPD wants to take itsComstock power plant out of service for maintenance whendemand is expected to be low. After shutdown, performingmaintenance and getting the plant back on line takes two weeks. The utility has enough other generating capacity tosatisfy 1,550 megawatts (MW) of demand while Comstockis out of service. Table 8.5 shows weekly peak demands(in MW) for the past several autumns. When next in year 6should the Comstock plant be scheduled for maintenance?
Suppose a four-period weighted average is being used to forecast demand. Weights for the periods are as follows: wt-4 = 0.1, wt-3 = 0.2, wt-2 = 0.3 and wt-1 = 0.4. Demand observed in the previous four periods was as follows: At-4 = 380, At-3 = 410, At-2 = 390, and At-1 = 400. What will be the demand forecast for period t?
Please use the proper methodology when solving, thank you.
St. Clair County Hospital is attemoting to assess its needs for nurses over the coming four months(January to April). The need for nurses depend on both the numbers and the types of patients in the hospital. Based on a study conducted by consultants, the hospitals have determined that the following ratios of nurses to patients arerequired: Patient Forecast Patient Type: # of nurses Jan Feb March April Major surgery 0.4 28 21 16 18 Minor surgery 0.1 12 25 45 32 Maternity 0.5 22 43 90 26 Critical care 0.6 75 45 60 30 Other 0.3 80 94 73 77 a). How many nurses should be working each…
CRUISE MINI CASE: Sunshine Cruise Lines is a cruise operator that offers three- to seven-day cruises along five Caribbean routes. It has developed a reputation as a party cruise operator and the majority of its revenue comes from vacationing college students. This type of customer demand is highly cyclical, and Sunshine finds that repeat purchase is high while its consumers are in college, but practically disappears after graduation. In an effort to encourage its customers to continue taking Sunshine Cruises after they have graduated, the cruise operator has begun offering Adventure Cruises, with port stops on islands known for eco-tourism and biodiversity, both on land and off shore, appealing to young professionals who like to hike and scuba dive or snorkel. In contrast to its party cruises, Sunshine focuses its marketing message for Adventure Cruises on activities at port stops and the convenience of being able to explore several Caribbean destinations from the comfort of a single…
Please help me with this practice problem. Please be specific on where to put the equations and what equations to use. Thank you
Tom Glass forecasts electrical demand for the FlatlandsPublic Power District (FPPD). The FPPD wants to take itsComstock power plant out of service for maintenance whendemand is expected to be low. After shutdown, performingmaintenance and getting the plant back on line takes twoweeks. The utility has enough other generating capacity tosatisfy 1,550 megawatts (MW) of demand while Comstockis out of service. Table 8.5 shows weekly peak demands(in MW) for the past several autumns. When next in year 6should the Comstock plant be scheduled for maintenance?
Sarah has been custom manufacturing sweaters now for 7 years. Her annual sales are shown below. Year Sales 1 178 2 215 3 233 4 301 5 337 6 330 7 361 What are her forecasted sales for year 8 using a 3 year moving average? What are her forecasted sales for year 8 using a 5 year weighted average where w1=.4, w2=.3, w3=.15, w4=.1, w5=.05? What are her forecasted sales for year 8 using exponential smoothing? Assume year 7 forecast was 323. Select your own alpha. Which forecast method is the best for Sarah to use based on MAD? Why?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

SEE MORE TEXTBOOKS