A new plant must be built to service the carpet mills at the following four locations, where X and Y specify coordinates on an X,Y grid.

	Location
Carpet Mill	X	Y
Dalton	9	43
Rome	2	28
Canton	51	36
Kennesaw	19	4

The number of annual deliveries to each of the carpet mills is shown below.

	Annual
	Deliveries
Dalton	130
Rome	75
Canton	90
Kennesaw	80

The plant cannot be more than 50 miles from any of the mills. Where should the plant be located to minimize the total annual shipping miles traveled between the new plant and all of the mills?

Use the Multistart option, and assume that the location of the plant must be between 0 and 100 for both X and Y.

Please use excel