Question: ANSWER IN EXCEL AND PLEASE DO NOT COPY. I NEED CLEAR ANSWER. OR ILL GIVE DISLIKE.AND REPORT. Do not copy from any other source please.
ANSWER IN EXCEL AND PLEASE DO NOT COPY. I NEED CLEAR ANSWER. OR ILL GIVE DISLIKE.AND REPORT. Do not copy from any other source please.
Atlas Corporation is considering a distribution center which will serve three primary market areas: Dallas, Texas; Atlanta, Georgia; and, St. Louis, Missouri. Atlas has determined that the latitude, longitude, and populations of the three metropolitan areas are:
| Metropolitan Area | Approx. Latitude | Approx. Longitude | Approx. Population |
| Atlanta | 33.75 | 84.39 | 5.7 million |
| Dallas | 32.80 | 96.77 | 6.8 million |
| St. Louis | 38.62 | 90.20 | 3.1 million |
Using the center-of-gravity method, determine the latitude and longitude of the best location for the distribution center. Use the given population data to estimate demand and enter this data in millions in the necessary calculations (e.g., enter 5.4 million as "5.4"). (Negative answers should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.)
latitude?
longitude?
ANSWER IN EXCEL AND PLEASE DO NOT COPY. I NEED CLEAR ANSWER. OR ILL GIVE DISLIKE.AND REPORT
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
