Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

B K C D F H A company has offices in the cities listed below. A manager wants to visit each of the offices and

image text in transcribed
B K C D F H A company has offices in the cities listed below. A manager wants to visit each of the offices and return to LA. Build a model to calculate the maximum distance of the manager's trip when an ordered list of city names is provided. The model must work for any seven cities and any order of visits. Distance: LA 1 LA 2 New York 3 Chicago 4 Houston 5 Philadelphia 6 Phoenix 7 San Antonio 1 2 3 4 5 6 7 New York Chicago Houston Philadelphia Phoenix San Antonio 0 2464.39 1752.3 1381.34 2404.61 365.076 1209,77 2464.39 0 719.539 1420.64 77.5993 2144.99 1584.85 1752.3 719.539 0 936.145 668.145 1447.23 1046.4 1381.34 1420,64 936.145 0 1344.31 1016.85 190.066 2404.61 77.5993 668.145 1344.31 O 2081.42 1509.61 365.076 2144.99 144723 1016.85 2081.42 0 847.995 1209.77 1584.85 1046.4 190.066 1509.61 847.995 0 + City Name Distance ILA INDEX(C7:114,017,018) Please make sure that your model works for any order of cities entered New York INDEX(array, row. num. (column num) Chicago INDEX/reference row.num. (column num). Cares ruml) on different sets of input data, Houston Philadelphia Time-Saving Hint: Formulas need to be developed only for two cells the rest is cop Phoenix San Antonio LA Maximum distance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Infrastructure Planning And Finance

Authors: Vicki Elmer, Adam Leigland

1st Edition

0415693187, 978-0415693189

More Books

Students also viewed these Finance questions