solve the problem using excel solver add-in ONLY EXCEL SOLUTION THANK!

serve as Mantastic Devices designs and manufactures high-end support garments for men. The facilities in Manhattan and Atlanta design and component manufacturing facilities Components are then shipped to warehouses in Philadelphia or Knoxville, where they are held until final assembly is completed at either Memphis, New Orleans, or El Paso. Manhattar Manufacturing capacity in Manhattan and Atlanta is 2000 units. Demand at Memphis, New Orleans, and El Paso is 500, 500, and 1000, respectively. The network representing the shipping routes is shown Memphis Manhattan Pelphia 5 3 New Orleans 6 Allarta El Paso 4 7 below. Knoxville ia Knoxville Memphis I= ins El Paso Manhattan $4.5 $25 Atlanta $22 $2.35 Philadelphia $2.25 $18.22 $14.22 $35.25 Knoxville $3.5 $15.22 $5.90 $17.2