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 | |
The model is shown below
The formulas are shown below
The solver parameters are shown below
The result is shown below
A manufacturer of cat towers wishes to locate a super assembly facility to meet their cat...
Formulate the model setupto minimuze shiping coststo the super assy center Thay u Solver use Excel he Problem#2(30 points). A manufacturer of cat towers wishes to their cat tower assembly needs for the next millennium. Cu in the table. The super assembly facility would ship to distrii Nashville, and Philadelphia. The locations of all of these citie Ogden, and Springfield in the quantities and Sprincving are purchased in bulk from suppliers in North Haverbrook,, carpet,s sembly show in the table...