1. Using the center-of-gravity method, compute the centralized coordinates among the following locations, which are indicated via black cells with white text in LOCATION.xIs:: 7,110,14,22,56,69,62,86,10 2. Using the weighted average center-of-gravity, which accounts for quantities* to be shipped from locations, compute the centralized coordinates among the following locations: 7,110,14,22,56,69,62,86,10 "Quantities to be shipped are listed within the existing locations (i.e. Location 7,1 ships 17 units) in LOCATION.xlsx 3. Among alternatives A(4,4),B(8,3) and C(7,8), list the location most attractive when accounting for the weighted factors listed below: In order to compute the distances between prospective locations and the centraized coordinates computed in Question 1 , utilize the Euclidian distance formula, which is sometimes referred to as the Pythagorean distance. The formula is stated as: d=[(x2x1)2+(y2y1)2] 1. Using the center-of-gravity method, compute the centralized coordinates among the following locations, which are indicated via black cells with white text in LOCATION.xIs:: 7,110,14,22,56,69,62,86,10 2. Using the weighted average center-of-gravity, which accounts for quantities* to be shipped from locations, compute the centralized coordinates among the following locations: 7,110,14,22,56,69,62,86,10 "Quantities to be shipped are listed within the existing locations (i.e. Location 7,1 ships 17 units) in LOCATION.xlsx 3. Among alternatives A(4,4),B(8,3) and C(7,8), list the location most attractive when accounting for the weighted factors listed below: In order to compute the distances between prospective locations and the centraized coordinates computed in Question 1 , utilize the Euclidian distance formula, which is sometimes referred to as the Pythagorean distance. The formula is stated as: d=[(x2x1)2+(y2y1)2]