A school system has 16 bus drivers that must cover 12 bus routes. Each driver can cover

Question:

A school system has 16 bus drivers that must cover 12 bus routes. Each driver can cover at most one route. The driver’s bids for the various routes are listed in the file P05_45.xlsx. Each bid indicates the amount the driver will charge the school system to drive that route. How should the drivers be assigned to the routes to minimize the school system’s cost? After you find the optimal assignments, use conditional formatting so that the cost the school system pays for each route is highlighted in red and whenever the cheapest bid is not used for a route, that bid is high-lighted in green.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Practical Management Science

ISBN: 978-1305250901

5th edition

Authors: Wayne L. Winston, Christian Albright

Question Posted: