Answer using Excel***

Todd's Direct, a major TV sales chain headquartered in New Orleans, is about to open its first outlet in Mobile, Alabama and wants to select a site that will place the new outlet in the center of Mobile's population base. Todd examines the seven census tracts in Mobile, plots the coordinates of the center of each from a map, and looks up the population base in each to use as a weighting. The information gathered appears in the following table: Census Tract Population in Census Tract X, Y Map Coordinates 101 25,000 102 2,000 103 17,500 104 16,000 (20, 40) (30, 120) (90,95) (40, 65) (35, 80) (120, 70) (95, 45) (75, 70) 105 28,000 106 21,000 107 3,000 108 32,000 A. (10 points) At what center-of-gravity coordinates should the new store be located? B. (5 points) Census tracts 103 and 105 are each projected to grow by 25% in the next year. How will this influence the new store's coordinates