The distances between the customer locations and the distribution centers in miles for a company that handles 3rd party logistics is as given below. Distance 1 2 3 7 DC 16.3 16.5 20 19.6 17.9 9.3 12.7 7.2 14.9 16.6 16.6 12.7 11.5 8.9 10.1 11 10.8 9.8 4 7.3 13.4 19.1 17.5 12.9 16.4 16.1 6 9.4 17.4 7 3.6 These are the number of boxes the customers need

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
100%

provide the answer for 2 questions

The distances between the customer locations and the distribution centers in miles for a company that
handles 3rd party logistics is as given below.
Distance
2
3
7
DC
1
16.3
16.5
20
19.6
17.9
9.3
12.7
7.2
14.9
16.6
16.6
12.7
11.5
3
8.9
10.1
11
10.8
9.8
7.3
13.4
19.1
17.5
12.9
16.4
16.1
6.
9.4
17.4
7
3.6
These are the number of boxes the customers need.
Customer
3
5
6.
7
ID
Demand (Boxes)
24
38
19
37
23
21
10
4.
2.
Transcribed Image Text:The distances between the customer locations and the distribution centers in miles for a company that handles 3rd party logistics is as given below. Distance 2 3 7 DC 1 16.3 16.5 20 19.6 17.9 9.3 12.7 7.2 14.9 16.6 16.6 12.7 11.5 3 8.9 10.1 11 10.8 9.8 7.3 13.4 19.1 17.5 12.9 16.4 16.1 6. 9.4 17.4 7 3.6 These are the number of boxes the customers need. Customer 3 5 6. 7 ID Demand (Boxes) 24 38 19 37 23 21 10 4. 2.
Ms. Angela Barnes is routing vehicles to deliver goods to seven customers. The customers are identified with
an ID.
Consider that each of her trucks can carry, at most, 100 boxes per tour. Use the Savings algorithm to design
the routes.
Tip: Remember that the Savings algorithm is a heuristic algorithm. This means that the solution provided by
the Savings algorithm will not necessarily be the optimal solution to the problem.
Important: Write the sequence of customers with a dash between the ID numbers (do not use spaces and do
not include "DC"). For example, if the route goes from DC to 5 to 2 to 6 to DC, write 5-2-6 or 6-2-5 (both are
considered correct). In the above example, 2-5-6 or 2-6-5 would be considered wrong!
How many tours would Angela need?
What are the savings (in distance traveled) compared to delivering directly from the DC to each customer?
Round your result to one decimal digit
Transcribed Image Text:Ms. Angela Barnes is routing vehicles to deliver goods to seven customers. The customers are identified with an ID. Consider that each of her trucks can carry, at most, 100 boxes per tour. Use the Savings algorithm to design the routes. Tip: Remember that the Savings algorithm is a heuristic algorithm. This means that the solution provided by the Savings algorithm will not necessarily be the optimal solution to the problem. Important: Write the sequence of customers with a dash between the ID numbers (do not use spaces and do not include "DC"). For example, if the route goes from DC to 5 to 2 to 6 to DC, write 5-2-6 or 6-2-5 (both are considered correct). In the above example, 2-5-6 or 2-6-5 would be considered wrong! How many tours would Angela need? What are the savings (in distance traveled) compared to delivering directly from the DC to each customer? Round your result to one decimal digit
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
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.