Explain how to do it in excel please 21. A distribution center is considering fo

Question

Explain how to do it in excel please

21. A distribution center is considering four possible locations for their new facility The following table (in DC.xls) presents the x and y coordinates of these locations The management is planning to choose the location that would minimize the total distance traveled to serve their customers. File Customers.xls, worksheet Locations contains the location of the customers Calculate the total distancetraveled from each candidate location to the customers. Consider Euclidean distance between locations. Calculate the distances in DC.xls referencing customer locations in Customers.xls 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 Distance From/To C1 y-Coord 300 155 225 350 DC Location x-Coord 200 100 135 250 C2 C3 C4 Total Customers Location C1 C2 C3 C4 x-Coord 190 210 144 180 y-Coord 178 89 344 310

Explanation / Answer

Here write all the tables in one shhet then use the ready-made functions of excel for calculations like sum(),sqrt(),etc.

Consider Euclidean distance by formula ((x1-x2)2+(y1-y2)2)1/2.From A to C1 x1=200,x2=190,y1=300 & y2=178.

DC Location x y A 200 300 B 100 155 C 135 225 D 250 350 Customer Location x y Distance From/To C1 C2 C3 C4 Total C1 190 178 A 122.4091 211.2368 71.2179 22.3606 427.2244 C2 210 89 B 92.8924 128.2809 194.0541 89.4427 504.6701 C3 144 344 C 72.3463 155.3093 119.3398 96.1769 443.1723 C4 180 310 D 182.1647 264.0473 106.1696 80.6225 633.0041

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.