USE EXCEL SOLVER PLEASE - 9-24Baseball 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

TheXindicates 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?