The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost and is qualified to clean only certain buildings. There are eight possible crews to choose from in this case. The goal is to minimize costs while making sure that each building is cleaned. The management science department formulated the following linear programming model to help with the selection process. Min 200x1 + 250x2 + 225x3+ 190x4 + 215x5 + 245x6 + 235x7 + 220x8 s.t. x₁ + x₂ + x5 + x7 2 1 (Building A constraint} x1 + x2 + x3 2 1 (Building B constraint} X6 + x8 > 1 [Building C constraint) x1 + x4 + x7 2 1 [Building D constraint} x2 + x7 2 1 {Building E constraint} x3 + x8 2 1 [Building F constraint] x2 + x5 + x7 2 1 {Building G constraint} x1 + x4 + x6 ² 1 {Building H constraint} x1 + x6 + x8 2 1 [Building I constraint} x₁ + x₂ + x7 ² 1 (Building J constraint] [1, if crew jis selected 10, otherwise = a. What is the cost of the optimal crew assignment? Cost of optimal crew assignment b. Which crews are assigned to work? Crew 1 will Crew 2 will Crew 3 will Crew 4 will Crew 5 will Crew 6 will Crew 7 will Crew 8 will (Use EXCEL or a LINEAR PROGRAMMING SOLVER.) The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost and is qualified to clean only certain buildings. There are eight possible crews to choose from in this case. The goal is to minimize costs while making sure that each building is cleaned. The management science department formulated the following linear programming model to help with the selection process. Min 200x1 + 250x2 + 225x3+ 190x4 + 215x5 + 245x6 + 235x7 + 220x8 s.t. x₁ + x₂ + x5 + x7 2 1 (Building A constraint} x1 + x2 + x3 2 1 (Building B constraint} X6 + x8 > 1 [Building C constraint) x1 + x4 + x7 2 1 [Building D constraint} x2 + x7 2 1 {Building E constraint} x3 + x8 2 1 [Building F constraint] x2 + x5 + x7 2 1 {Building G constraint} x1 + x4 + x6 ² 1 {Building H constraint} x1 + x6 + x8 2 1 [Building I constraint} x₁ + x₂ + x7 ² 1 (Building J constraint] [1, if crew jis selected 10, otherwise = a. What is the cost of the optimal crew assignment? Cost of optimal crew assignment b. Which crews are assigned to work? Crew 1 will Crew 2 will Crew 3 will Crew 4 will Crew 5 will Crew 6 will Crew 7 will Crew 8 will (Use EXCEL or a LINEAR PROGRAMMING SOLVER.)
Expert Answer:
Answer rating: 100% (QA)
To solve the linear programming problem and determine the optimal crew assignment well use the provi... View the full answer
Related Book For
Operations Management Creating Value Along the Supply Chain
ISBN: 978-0470525906
7th Edition
Authors: Roberta S. Russell, Bernard W. Taylor
Posted Date:
Students also viewed these programming questions
-
BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
If the demand function and supply function for Z-brand phones are p + 2q = 100 and 35p + 20q = 350, respectively, compare the quantity demanded and the quantity supplied when p = 14. Are there...
-
Mikado plc is considering launching a new product involving capital investment of 180,000. The machine has a four-year life and no residual value. Sales volumes of 6,000 units are forecast for each...
-
What is Web structure mining? What are authoritative pages and hubs? How do they relate to Web structure mining?
-
Expected value of research projects Patrick Corporation is preparing its research and development budget for the coming year. Two research projects are being evaluated. Project A is expected to cost...
-
The client, Mr. David Keys, would like to know what state law provides concerning the removal of a director from the board of directors of a corporation. Prepare an information letter to Mr. Keys...
-
1 Exercise 1 2 - 1 Preparing a Segment Performance Report ( LO 1 - CC 3 ) 1 0 Indi Systems Inc., headquartered in Bengaluru, India, provides specialized information technology ( IT ) services and...
-
A vaccine to prevent severe rotavirus gastroenteritis (diarrhea) was given to African children within the first year of life as part of a drug study. The study reported that of the 3298 children...
-
National Inc. manufactures two models of CMD that can be used as cell phones, MPX, and digital camcorders. Model Annual Sales in Units High F 11,600 Great P 17,600 National uses a volume-based...
-
Cobe Company has manufactured 255 partially finished cabinets at a cost of $63,750. These can be sold as is for $76,500. Instead, the cabinets can be stained and fitted with hardware to make finished...
-
Sunland Company purchased equipment and these costs were incurred: Cash price $83000 Sales taxes 2600 Insurance during transit 690 Installation and testing 880 Total costs $87170 Sunland will record...
-
Tasty Meat Inc. uses ABC costing to allocate the manufacturing overhead costs incurred by producing tasty pork ribs. The following activities related to yearly manufacturing overhead costs, and cost...
-
Bank failures in 2023 such as Silicon and Signature banks were most likely due to ineffective risk management. According to the U.S. Government Accountability Office both of these banks took on a...
-
One-hundred milliliters of 1.75 mM NaCl is mixed with 80.0mL of3.20 mM MgCl2 at 20 degrees celcius. Calculate the osmotic pressureof each starting solution and that of the mixture, assuming thatthe...
-
1.) Maisy is an employee at a shoe store. She receives a 20% discount on all items, including sales items. For Black Friday, all boots at the store are discounted 40%. Maisy grabs a pair of boots...
-
Suppose that the laptop of Prob. 2.16 is placed in an insulating briefcase with a fully charged battery, but it does not go into sleep mode, and the battery discharges as if the laptop were in use....
-
The manager of the I-85 Carpet outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill,...
-
Discuss how a quality management program can affect productivity.
-
The Atlantic Grocery chain operates in major metropolitan areas on the eastern seaboard. The stores have a no-frills approach, with low overhead and high volume. They generally buy their stock in...
-
What is an impairment of a tangible capital asset? How is a depreciable capital asset impairment recorded in the financial statements?(Appendix)
-
Refer to Exhibit 1, which shows the segment information of Goodyear Tire & Rubber Company. In what business segments does Goodyear operate? What is the relative size of its business segments in terms...
-
In a dramatic move, Standard & Poors Ratings Group, the large financial company that evaluates the riskiness of companies debt, downgraded its rating of General Motors and Ford Motor Co. debt to junk...
Study smarter with the SolutionInn App