Question

A manufacturer of cat towers wishes to locate a super assembly facility to meet their cat tower assembly needs for the next millennium. Currently, carpet, cylinders, yarn and fasteners are purchased in bulk from suppliers in North Haverbrook, Ogden, and Springfield in the quantities shown in the table. The super assembly facility would ship to distribution centers located in Seattle, Lubbock, Nashville, and Philadelphia. The locations of all of these cities on an x-y grid, transportation costs on a ton per mile basis, and total tonnage are all shown in the table on worksheet Below. Determine the optimal location by Solver for the Super Assembly Center.c

	Sources/Markets	Shipping Cost $/ton mile (Fn)	Quantity in Tons (Dn)	Xn	Yn	dn
Supply	North Haverbrook	1.1	650	700	1200
	Ogden	1.2	450	250	600
	Springfield	1.4	400	225	825
Market	Seattle	2.25	300	50	1200
	Lubbock	2.25	200	450	300
	Nashville	2.25	500	800	250
	Philadelphia	2.25	500	950	1100

X
Y
Cost

Answer 1

The model is shown below

The formulas are shown below

The solver parameters are shown below

The result is shown below