This question is supposed to be solved in excel and I must utilize solver. Please help! Will upvote!

Problem 3. Mean Green Trucking has entered the third party logistics market. The executive team has requested assistance from the LSCM 4560 class to determine the best location for their facility. They recently acquired a new account which has distribution centers at ten locations throughout the United States (see map below for the geographic region served). Your task is to determine the optimal location for a single Mean Green Trucking DC to serve these locations. The CEO wants to obtain the total cost for the optimal location coordinates and total cost for the optimal location. The distribution center will support customers at the following coordinates with corresponding rates and volumes: Customer Seattle, WA Boise, ID Las Vegas, NV Denver, CO Minneapolis, M Fort Worth, TX Columbus, OH Atlanta, GA New York, NY Orlando, FL X 19 38 35 83 136 119 183 183 223 202 Y 144 116 71 87 115 44 92 53 114 22 Volume 24000 19000 50000 35000 39000 44000 48000 40000 50000 13000 Rate 2.35 2.40 2.00 2.10 2.15 1.95 1.90 1.85 1.90 1.90 Homework #1 Facility Location, Spring 2022 Page 16 TRIP Your task is to compute the X and Y coordinates and the total cost for the optimal location. The analysis should appear on a worksheet titled "Problem 3". The total cost for the optimal location should be calculated using either the exact grid or median approach as you believe appropriate. You should explain your selection to the executive team. Your analysis must use Solver to calculate coordinates and the total cost for the optimal location. As a result, you will have columns with the distance from each customer and cost