A distribution center is considering four possible locations for their new facility. The following table (Table 1 - DC Locations) presents the x and y coordinates of these locations. Table 1 - DC Locations Table 2 - Customer Locations Table 3 - Distance From To F G H 1 J C1 C2 C4 Total . B 1 DC Location x-Coordy-Coord 2 A 200 300 3 B 100 155 4 135 225 5 D 250 350 A B 1 Customers Location x-Coordy-Coord 2. C1 190 178 3 C2 210 89 4 C3 144 344 5 C4 180 310 E Distance 1 From To 2 3 B 4 c 5 D The management is planning to choose the location that would minimize the total distance traveled to serve their customers. Table 2 - Customer Locations, this table contains the location of the customers. Calculate the total distance traveled from each candidate location to the customers. Consider Euclidean distance between locations. Calculate the distances in Table 3 - Distance From To referencing customer locations in Table 2. Using the Create Name option, name the range of cells that presents the distances from a particular location to all customers. Use the formulas =sum(A)' to=sum(D)' to calculate the total distance from a candidate location to all customers. Note that: the Euclidean distance between locations A and B is calculated as follows: [(xa - XB)2 + (YA - )?] (1/2)