Question: Metro Supply decided to relocate its warehouse. Determine a good location for its new warehouse based on minimizing the number of miles traveled. The addresses
Metro Supply decided to relocate its warehouse. Determine a good location for its new warehouse based on minimizing the number of miles traveled. The addresses and number of trips made to each of its customers last year can be found in the "Metro Supply.xls" file and displayed in a "Metro Supply.ptm" file (a MapPoint map) in myomlab. For your convenience, the center of gravity is displayed on the map. Enter the street address of your proposed warehouse location on the "Distribution Centers" worksheet in the "Metro Supply.xls" file and run the macro by selecting the button on the "Customers" worksheet to determine the total one-way mileage (which is essentially the load-distance score). You may wish to watch the Witherspoon Automotive video on myomlab before starting this problem.
Step by Step Solution
3.38 Rating (157 Votes )
There are 3 Steps involved in it
After analyzing the MapPoint map and considering the number of trips made to each customer a good lo... View full answer
Get step-by-step solutions from verified subject matter experts
