USE EXCEL SOLVER PLEASE - 9-24 Baseball umpiring crews are currently in four cities where three-game series are beginning. When these are finished, the crews are needed to work games in four different cities. The distances (miles) from each of the cities where the crews are currently working to the cities where the new games will begin are shown in the following table:
KANSAS CITY CHICAGO DETROIT TORONTO
SEATTLE 1,500 1,730 1,940 2,070
Arlington 460 810 1,020 1,270
Oakland 1,500 1,850 2,080 X
Baltimore 960 610 400 330
The X indicates that the crew in Oakland cannot be sent to Toronto. Determine which crew should be sent to each city to minimize the total distance traveled. How many miles will be traveled if these assignments are made?
Send team in Seattle to Detroit Send team in... View the full answer
- The answer is supposed to be "Total Cost = 4580". This is correct, thank you for the guidance. I see what I was doing wrong now with my solver.
- Nov 03, 2018 at 10:14pm