Distribution Center Location



Distribution Center Location

Question 5

 

NYC

BIRMINGHAM

TERRE HAUTE

DALLAS

SPOKANE

SAN DIIEGO

Philadelphia

$ 45 $ 52 $ 56 $ 62 $ 78 $ 85

Atlanta

$ 55 $ 42 $ 58 $ 59 $ 80 $ 82

St. Louis

$ 57 $ 60 $ 50 $ 54 $ 65 $ 70

Salt Lake City

$ 72 $ 71 $ 67 $ 57 $ 52 $ 60

Total Demand

525

415

925

600

325

400

Total Minimized Cost =

1489

 

By using Excel

 

 

 

 

 

 

The above plan has been given to minimize the route cost for the SP and cost and benefit analysis for the optimum root has been done above. The above analysis ...