MANAGEMENT SCIENCE QUESTION

A school system has 16 bus drivers that must cover 12 bus routes. Each driver can cover at most one route. The drivers bids for the various routes are listed below. 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 systems 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.

Make sure to do it in excel and give all the inputs and formulas

Assigning bus drivers to routes Route Driver Assigning bus drivers to routes Route Driver