Question

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 below ton per mile basis, and total tonnage are all contained in the tablgrid. ein Seattie Transportation Quantity ources/Markets Cost S/ton mile in T onsXnY (Dn) (Fn) Supply 650 450 400 700 250 225 th Haverbrook 1.2 1.4 1,200 600 825 gden ngfield arket eattle ubbock ashville Philadelphia 2.25 2.25 2.25 2.25 300 200 50 1,200 450 200 50950 500800 250 1,100 500
Formulate the model setupto minimuze shiping coststo the super assy center

Answer 1