Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ted's daughter is getting married, and he is inviting relatives from 1 5 different locations in the United States. The DATAfile Wedding gives the longitude,
Ted's daughter is getting married, and he is inviting relatives from different locations in the United States. The DATAfile Wedding gives the longitude, latitude, and number of relatives in each of the locations. Ted would like to find a wedding location that minimizes the demandweighted 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 NonNegative in Solver.
If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even. Example: Do not round intermediate calculation.
Latitude of the optimal wedding location
Longitude of the optimal wedding location
Total demandweighted distance
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started