A manufacturer wants to locate a super assembly facility to meet their assembly needs for the foreseeable future. There are 6 raw material suppliers are located in cities A through F, and the facility would ship manufactured products to 10 distribution centers in cities G through P. The locations of these cities on an x-y grid, outbound transportation costs on a ton per mile basis, and total tonnage are all contained in the fileData.xlsx. Use the Euclidian distance formula to calculate distances.

What is the minimal shipping cost that satisfies all market demand? (report your answer to 2 decmal places) Blank 1

What is the optimal location for the super assembly center? (report your answers to 2 decimal places)

x-coordinate: ________________

y-coordinate: ________________