Question

T 154.8 9 20 B C E F G H K L M N O R S 1 Learning Activity -- Facility Location by the Gravity Method 2 Instructions: 3 Latitude Longitude 1) To start the computations, you'll need to compute the SUM of the population shown in Column D. 4 City (LAT) (LON) Population (1,000) p*Lat P*Lon 2) Compute each city's "Population x Latitude" (column E). 5 1 16.6 1655 3) Compute each city's "Population x Longitude" (column F). 2 16.7 156.8 2300 4) Sum all the P*Lat and P*Lon that will be needed for the final equation (E27 and F27). 7 3 16.8 153.2 601 5) Now, follow the Gravity Method formula to compute the Latitude and Longitude. 4 17.0 154 1385 Note: This will minimize the total travel distance from the Distribution Center to each customer! 9 5 17.0 152 1230 10 6 17.2 144.9 665 11. 7 17.5 155.7 664 12 8 17.4 147.1 885 13 17.5 141.1 1116 14 10 17.8 155.1 636 15 11 17.9 153.8 1200 16 12 18.0 144.6 148 21 17 13 18.4 142.4 854 23 18 14 18.9 156.8 1473 19 15 19.3 148.3 615 20 16 19.4 152.9 1145 21 17 19.4 142.8 627 22 18 19.9 143.7 542 23 19 20.3 152.5 379 = 24 20 21.2 143.7 9641 og for 25 21 21.6 155.6 546 26 22 22.6 140.1 706 27 23 23.4 155.8 727 28 24 669) Your solution for a single, low-cost location: 29 25 24.9 146.4 931 Latitude Longitude "The angular distance of a place north or south of the earth's equator, or latitude of a celestial object north or south of the celestial equator, usually 30 expressed in degrees and minutes." "The angular distance of a place east or west of the meridian at lon.gi-tude Greenwich, England, or west of the standard meridian of a celestial 31 See your solution in the chart below! object, usually expressed in degrees and minutes." 25 abitude LAT EP* LAT ΣΡ LON XP* LON ΣΡ 15'w cal laude 24.0 144.4

Answer 1

A B H J K LAT 4 City 5 6 1 2 3 7 8 4 9 5 6 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 LON 16.6 16.7 16.8 17 17 17.2 17.5 17.4 17.5 17.8 17.9 18 18.4 18.9 19.3 19.4 19.4 19.9 20.3 21.2 21.6 22.6 23.4 24 24.9 с D E F Population (1,000) PLAT PELON 154.8 1655 27473 256194 156.8 2300 38410 360640 153.2 601 10096.8 92073.2 154 1385 23545 213290 152 1230 20910 186960 144.9 665 11438 96358.5 155.7 664 11620 103384.8 147.1 885 15399 130183.5 141.1 1116 19530 157467.6 155.1 636 11320.8 98643.6 153.8 1200 21480 184560 144.6 148 2664 21400.8 1424 854 15713.6 121609.6 156.8 1473 27839.7 230966.4 148.3 615 11869.5 91204.5 152.9 1145 22213 175070.5 142.8 627 12163.8 89535.6 143.7 964 19183.6 138526.8 152.5 379 7693.7 57797.5 143.7 964 20436.8 138526.8 155.6 546 11793.6 84957.6 140.1 706 15955.6 98910.6 155.8 727 17011.8 113266.6 144.4 669 16056 96603.6 146.4 931 23181.9 136298.4 23085 434999.2 3474430.5 =SUMD5:029) =SUM(E5:E29) =SUM(F5:F29) Latitude Longitude 18.84337015 150.5059779 =E30/D30 =F30/D30

All the formulae used are mentioned in the excel sheet.

25 24 23 22 21 20 ว C 19 18 17 15 15 138 140 142 144 145 148 150 152 154 155 158

C in the graph defines the central location.

********

IF YOU HAVE ANY DOUBT, KINDLY COMMENT. I WOULD LOVE TO HELP YOU!!!

IF YOU LIKE THE ANSWER, PLEASE GIVE AN UP-VOTE OR THUMB UP. THIS WILL ENCOURAGE ME TO ANSWER MORE!!