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

1 Expert Approved Answer
Step: 1 Unlock

Assigning bus drivers to routes Drivers bids Route Driver 1 2 3 4 5 6 7 8 9 10 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (3 attachments)

PDF file Icon

1497_60b741243f023_696496.pdf

180 KBs PDF File

Excel file Icon

1497_6041c97891c28_696496.xlsx

300 KBs Excel File

Word file Icon

1497_60b741243f023_696496.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!