please help with this IN EXCEL!!!!! show all steps and equations and solver and explain results!!!! thanks in advance will rate fast. 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, outbound transportation costs

on a ton per mile basis, and total tonnage are all contained in the

table.

What is the minimal shipping cost that satisfies all market

demand?