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
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.
Step by Step Solution
3.47 Rating (173 Votes )
There are 3 Steps involved in it
Assigning bus drivers to routes Drivers bids Route Driver 1 2 3 4 5 6 7 8 9 10 ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (3 attachments)
1497_60b741243f023_696496.pdf
180 KBs PDF File
1497_6041c97891c28_696496.xlsx
300 KBs Excel File
1497_60b741243f023_696496.docx
120 KBs Word File
