Please only answer my question if you have access to a personal computer. I need the formulas and explanations in Excel. Thank you. Please answer the question properly and please follow the instructions on the question. Please I will give a thumbs up for ur efforts so plz don't copy and paste from any online sources.

General note: To get the maximum point, show all formula in an appropriate step-by-step procedure, substitution, intermediate results, final answers, conclusions and interpretations. Most marks are allocated to procedure, formula and substitution. So, the final answers do not complete the work This assignment covers Chapter 5. 1. (5 points) 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. Transportation Quantity Cost S/ton mile in Tons Xn Yn 1.2 1.3 655 455 405 Sources/Markets Supply North Haverbrook Ogden Springfield Market Seattle Lubbock Nashville Philadelphia 705 255 235 1205 605 835 1.5 2.5 2.6 2.7 2.8 310 220 510 620 155 455 805 955 1205 305 255 1105 Find the optimal location for the Super Assembly Center. Setup an Excel spreadsheet. Submit the printed copy of the Excel spreadsheet, show the result of two consecutive iterations and the final solution