The answer for A is 301.7 and B is 319..6. PLEASE show how to get both in Excel. ***Show Excel answer AND show Solver Setup. And I will give ratings.

1) Prepare an Excel spreadsheet to solve the following problems. Make sure that each problem/sub-problem is on its own worksheet. 2) You may work with your classmates. 3) Good luck! 1. Captain America Sporting Goods Captain America Sporting Goods has decided to build a centrally located warehouse as part of its distribution system. The company manufactures several types of sports equipment, stocks them at the factory warehouse, and delivers to a variety of retail sites. Having outgrown its current warehouse and wanting to take advantage of new warehousing equipment, the firm has decided to build at a fresh location. To define a central location, their ten retail sites are first mapped on a two-dimensional grid, so that the coordinates (xk,yk) can be associated with each site. These values are as follows. A good location is one that is "close" to all sites. To make this concept operational, Cap's distribution manager Natasha suggests that the objective should be to minimize the sum of the distances between the warehouse and the various sites. Using this measure as a criterion, the distribution manager wishes to find the optimal location for the warehouse. A) Find the warehouse location if Natasha does not care how far any of the stores are from the warehouse. (10 points) B) Find the warehouse location if Natasha wants each store to be no more than 55 miles from the warehouse. (10 points) 1) Prepare an Excel spreadsheet to solve the following problems. Make sure that each problem/sub-problem is on its own worksheet. 2) You may work with your classmates. 3) Good luck! 1. Captain America Sporting Goods Captain America Sporting Goods has decided to build a centrally located warehouse as part of its distribution system. The company manufactures several types of sports equipment, stocks them at the factory warehouse, and delivers to a variety of retail sites. Having outgrown its current warehouse and wanting to take advantage of new warehousing equipment, the firm has decided to build at a fresh location. To define a central location, their ten retail sites are first mapped on a two-dimensional grid, so that the coordinates (xk,yk) can be associated with each site. These values are as follows. A good location is one that is "close" to all sites. To make this concept operational, Cap's distribution manager Natasha suggests that the objective should be to minimize the sum of the distances between the warehouse and the various sites. Using this measure as a criterion, the distribution manager wishes to find the optimal location for the warehouse. A) Find the warehouse location if Natasha does not care how far any of the stores are from the warehouse. (10 points) B) Find the warehouse location if Natasha wants each store to be no more than 55 miles from the warehouse. (10 points)