2. Company ABC has five milling machines on its manufacturing floor. It wishes t

Question

2. Company ABC has five milling machines on its manufacturing floor. It wishes to implement a tool crib which will contain tooling and other supplies for technicians to perform routine maintenance. After reviewing the current equipment layout, management determined that there are three potential locations for the new tool crib. The locations of the five milling machines and number of expected trips/month between that machine and the tool crib are listed below: Milling Machine X-Coordinate Y-Coordinate Weight/# Trips 20 36 62 50 25 25 18 37 56 600 400 500 300 200 Possible sites for the new tool crib are Possible Site X-Coordinate Y-Coordinate 50 30 65 50 45 28 Use the Load-Distance Method to determine the optimal location for the new tool crib such that the total distance the technicians have to travel is minimized. It is fair to say that the construction costs for the new crib are identical in each location and distance is measured rectilinearly.

Explanation / Answer

Min Z=600*((ABS(A2-20)+ABS(B2-25))+400*ABS(A2-36)+400*ABS(B2-18)+500*ABS(A2-62)+500*ABS(B2-37)+300*ABS(A2-50)+300*ABS(B2-56)+200*ABS(A2-25)+200*ABS(B2-0))

since 28653000 is least , we choose site 1

X Y Z 50 50 28653000 30 45 31518000 65 28 28888800

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

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