Pickson Luthiers Corporation Is Studying Where to Locate a Phone

question 19

Essay

Pickson Luthiers Corporation is studying where to locate a phone charging point on the factory floor.The locations of five production cells are expressed as X- and Y-coordinates on a rectangular grid of the factory layout.The daily demand for the charging point (measured as the number of trips to the charging point)at each production cell is also known.Because of the nature of the equipment layout in the factory and for safety reasons, workers must travel along marked horizontal and vertical aisles to access the charger.Thus, the distance from a cell to the charger is measured as rectilinear distance.
The table below provides the relevant information.

The optimal location should minimize the total weighted distance between the charging point and all production cells, where the weights are the daily number of trips to the phone charging point.
From the above table, provide the objective function for the best location of the charging point.What kind of solution technique from Solver can be used to make the optimization model based on the data?

---

Definitions:

Syndicate

A group of individuals or organizations combined to promote some common interest, often used in reference to underwriting groups for securities offerings.