Table of distances From 1 2 3 4 45678 8 1 0 19 57 51 49 4 12 92 To 4 2 3 19 57 51 0 51 61 51 0 49 61 49 0 53 18 50 25 30 11 80 6 53 47 91 38 5 49 53 18 50 0 68 0 62 48 9 94 6 4 25 30 11 38 7 8 12 92 80 53 6 47 91 38 62 48 9 94 0 9 9 0

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Plz use excel.   

Table of distances
From
1
2
3
4
5
6
7
8
1
0
19
57
51
49
4
12
92
2
19
0
51
61
53
25
80
53
To
4
5
51
49
61
53
49
18
49
0
50
18 50
0
30
11
68
6
91 62
47
38
9
3
550
57
51
6
4
25
30
11
38
0
48
94
|712806124809
8
92
53
47
38
9
94
9
0
0
Transcribed Image Text:Table of distances From 1 2 3 4 5 6 7 8 1 0 19 57 51 49 4 12 92 2 19 0 51 61 53 25 80 53 To 4 5 51 49 61 53 49 18 49 0 50 18 50 0 30 11 68 6 91 62 47 38 9 3 550 57 51 6 4 25 30 11 38 0 48 94 |712806124809 8 92 53 47 38 9 94 9 0 0
Suppose the distances (in kilometers) that a pharmaceutical representative, Tracy Ross, travels between medical offices are shown in the accompanying table. Set up and solve a traveling salesperson problem using Evolutionary Solver.
Click the icon to view the table of distances.
The shortest distance for a tour is
(Type a whole number.)
kilometers.
******
Transcribed Image Text:Suppose the distances (in kilometers) that a pharmaceutical representative, Tracy Ross, travels between medical offices are shown in the accompanying table. Set up and solve a traveling salesperson problem using Evolutionary Solver. Click the icon to view the table of distances. The shortest distance for a tour is (Type a whole number.) kilometers. ******
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.