our job as an industrial engineer is to come up with the location of the distribution center (to the nearest mile) that minimizes the cost for your company. The weekly cost is given by the formula cost = 0.5 * distance * quantity. Assume a dense network of roads such that the distance between your new distribution center and the customer is a straight line.   When done plot the location of the customers (using one color) and the optimal location for the distribution center (using a different color). Make sure that your program outputs the total weekly shipping cost from that location onto the command window.

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

Suppose that you are an engineer tasked with finding a new location for your distribution center (let's say you work as an industrial engineer at a cosmetics company). You have a good idea of who your customers are and how many tons of cosmetics you must ship per week. Using your company headquarters as the origin, you plot out the following table:

Customer                                     x-location (miles)    y-location (miles)    Quantity (tons/week)

JC Penney                                              10                               280                                  3

BB&B                                                     70                              180                                  7

Target                                                    80                               160                                  4

Bath&Body Works                                170                              20                                   5

Walmart                                                220                             100                                  2

Macy's                                                   270                              80                                   6

Your job as an industrial engineer is to come up with the location of the distribution center (to the nearest mile) that minimizes the cost for your company. The weekly cost is given by the formula cost = 0.5 * distance * quantity. Assume a dense network of roads such that the distance between your new distribution center and the customer is a straight line.

 

When done plot the location of the customers (using one color) and the optimal location for the distribution center (using a different color). Make sure that your program outputs the total weekly shipping cost from that location onto the command window.

 

Expert Solution
Step 1

MINIMUM WEEKLY COST = 0.5*DISTANCE*QUANTITY

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Similar 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.