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

1 Expert Approved Answer
Step: 1 Unlock

After analyzing the MapPoint map and considering the number of trips made to each customer a good lo... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Operations Management Questions!