Don't solve with Excel...

1) Company X wants to build a new warehouse close to its core customers to increase the service level provided to them. To do so a new study must be performed. You are asked to find a suitable location for the new warehouse to serve your key customers. The volume demands and their relative (x, y) coordinates are created from real data. a) Use distance load method to find the better location between 2 alternatives. L(MURATLI = 77.09, 85.33), (LLEBURGAZ=64.36,110.07)) Use Euclidean Distances. b) Use "Center of Gravity" method to find the location of the new warehouse. NO: LOAD 1 18 DWN 16 5 X-COORDINATE 157,94 25,74 83,31 18,75 24,98 96,08 62,22 98,73 127,5 30,63 95,94 6 8 CTY SLVR UZUNKPR LLEBURGAZ KEAN GELBOLU MURATLI ARKY PINARHSAR SARAY LALAPAA SLEYMANPAA ATALCA BABAESK IPSALA HAYRABOLU 7 Y-COORDINATE 96,17 117,27 132,15 64,34 22,07 107,4 44,58 158,5 136 181,4 84,86 103,4 135,1 78,29 8 9 13 10 6 11 20 12 15 12 14 60,23 0,0 61,82 15 10 0,0 1) Company X wants to build a new warehouse close to its core customers to increase the service level provided to them. To do so a new study must be performed. You are asked to find a suitable location for the new warehouse to serve your key customers. The volume demands and their relative (x, y) coordinates are created from real data. a) Use distance load method to find the better location between 2 alternatives. L(MURATLI = 77.09, 85.33), (LLEBURGAZ=64.36,110.07)) Use Euclidean Distances. b) Use "Center of Gravity" method to find the location of the new warehouse. NO: LOAD 1 18 DWN 16 5 X-COORDINATE 157,94 25,74 83,31 18,75 24,98 96,08 62,22 98,73 127,5 30,63 95,94 6 8 CTY SLVR UZUNKPR LLEBURGAZ KEAN GELBOLU MURATLI ARKY PINARHSAR SARAY LALAPAA SLEYMANPAA ATALCA BABAESK IPSALA HAYRABOLU 7 Y-COORDINATE 96,17 117,27 132,15 64,34 22,07 107,4 44,58 158,5 136 181,4 84,86 103,4 135,1 78,29 8 9 13 10 6 11 20 12 15 12 14 60,23 0,0 61,82 15 10 0,0