Question: The straight - line distance between two cities in the United States can be approximated by the following formula, where lat 1 and long 1

The "straight-line" distance between two cities in the United States can be approximated by the following formula, where lat1 and long1 are the latitude and longitude of city 1 and lat2 and long2 are the latitude and longitude of city 2, and the value 69 corresponds to the number of miles in a degree of latitude or longitude.
69
(lat1 lat2)2+(long1 long2)2
Ted's daughter is getting married, and he is inviting relatives from 15 different locations in the United States. The table below gives the longitude, latitude, and number of relatives in each of the 15 locations.
Location lat long # Relatives
NewYork 40.714352874.005973144
Maryland 39.025665177.07636697
Virginia 37.431573478.65689422
SC 32.216316080.75260801
NC 35.772096078.638614511
TN 35.960638483.92073921
FL 27.498927882.57481945
Ohio 39.136111084.50305567
Wyoming 43.6226250110.62605901
CA 34.0194543118.49119129
Iowa 41.698611193.04694446
IL 41.850033087.65005233
Mass 42.933979270.79838551
NJ 40.901210174.51432329
PA 39.952335075.16378902
Ted would like to find a wedding location that minimizes the demand-weighted distance, where demand is the number of relatives at each location. Assuming that the wedding can occur anywhere, find the latitude and longitude of the optimal location. (Hint: Notice that all longitude values given for this problem are negative. Make sure that you do not check the option for Make Unconstrained Variables Non-Negative in Solver. Round your answers to three decimal places.)
latitude of the optimal wedding location
longitude of the optimal wedding location

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!