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_66.xlsx. Each bid...

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_66.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 highlighted in green.