Question: management science, answer please + The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost and is qualifled to
management science, answer please
+ The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost and is qualifled 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 250x4 + 180x2 + 280x3+ 260x4 + 180x5 + 210x6 + 260x7 + 200x8 s.t. x1 + x2 + xy + x7 2 1 (Building A constraint] *1 + x2 + x3 2 1 (Building constraint) *6 +*2 1 (Building C constraint) *1 + x4 + xy 2 1 (Building D constraint) *2 + xy 1 (Building e constraint) *3 * * 81 (Building F constraint) *2 + x3 + x 2 1 (Building G constraint) x1 + x4 + X6 2 1 (Building H constraint) *1 + x4 + xg 2 1 (Building I constraint) *1 + x2 + xy 2 1 (Building constraint) S 1. if crew is selected *;= 10, otherwise Set up the problem in Excel and find the optimal solution 10 a. What is the cost of the optimal crew assignment? Cost of 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

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
