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 6.9 million
Dallas 32.80 96.77 8.0 million
St. Louis 38.62 90.20 4.3 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. Do not copy from any other source please.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 General Management Questions!