View the step-by-step solution to:

USE EXCEL SOLVER PLEASE - 9-24 Baseball umpiring crews are currently in four cities where three-game series are beginning.

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?

Top Answer

Send team in Seattle to Detroit Send team in... View the full answer

City excel.png

1 l Flle Home Insert Draw Page Layout Formulas Data Revlew Vlew Help ,0 Tell me what you want to do :1 Sh
E [Elme Text/CSV [89 ESE?“ SDI-”EEK H— Eu 5 Queries 8:: Connection: Al Z A \X Clear E...

1 comment
  • 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.
    • camel2house
    • Nov 03, 2018 at 10:14pm

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online