*Please show all work, use excel and identify the value and units measured.
(Notes for my own Use: Ch10:2)
Location Problem with Two Sites. Oliveira Office Supply has a large retail system consisting of 12 stores spread around the country, often in direct competition with Kilroy. However, managers at Oliveira have decided to use two national distribution centers. When Oliveira's stores are mapped on the same grid as Kilroy's, the store locations occur at the coordinates listed in the following table. There is also data to indicate how many trips are made annually to each store.
a. find the optimal location for Oliveira's two distribution centers.
b. What is the optimal value of the objective function
Please find the solution attached.
Coordinates Coordinates Coordinates Trips 43 49
Full solution using Excel.