Hub selection template

Sheet1

		Hub Selection
Note: If $/mile/ton is not given then use 1 for each location.
	$/ton/mile	Tons	X cord	Y Cord	distance	Cost	Optimal Solution
A	1.5	500	650	750	158.1129258317	118584.694373798	X	500.0011930466
B	1.3	1000	550	1050	353.5537685958	459619.899174538	Y	699.9994477268
C	1.95	1200	750	950	353.5529375002	827313.873750477	Objective	7229742.35689002	Minmum Cost
D	1.1	800	850	550	380.7873411593	335092.860220182
E	1.85	700	650	350	380.787677711	493120.042635736
F	1.25	1400	780	980	395.9793443712	692963.852649541
G	1.55	1000	400	800	141.4225903655	219205.015066481		400	7229742.35689002
H	1.05	900	950	250	636.3948689406	601393.151148884		800	9292587
P1	2	4000	500	700	0.0013146733	10.5173861716		9292586.71681756	2062844.64310998
P2	2	2000	300	400	360.5553298129	1442221.31925143
P3	2	1500	900	150	680.0723770776	2040217.13123278
		15000
	Approximate Solution using Center of gravity Method
	X	613.8	Y	631.4666666667