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 file Data.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)

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

x-coordinate:

y-coordinate:

	Supplier/DC	Fn	Dn	xn	yn
Supplier	A	$0.80	1721	172.69	347.97
	B	$0.75	449	1483.78	1370.63
	C	$0.95	2443	402	2351.23
	D	$1.10	1633	666.51	792.1
	E	$1.15	945	1832.27	2449.81
	F	$0.90	1840	1382.22	934.44
DC	G	$1.25	1208	1424.42	2184.27
	H	$1.25	2290	2437.41	1844.63
	I	$1.25	1725	1306.96	798.71
	J	$1.25	878	219.99	845.47
	K	$1.25	309	1313.94	530.93
	L	$1.25	1978	2048.82	1129.1
	M	$1.25	1102	1829.77	1192.06
	N	$1.25	2776	1576.34	1762.55
	O	$1.25	2116	1895.69	299.96
	P	$1.25	997	976.04	2239.69