what is the answer using Excel solver Add-Inn ? please identify all binding constraints? and

please draw the network solution ?

Mantastic Devices designs and manufactures high-end support garments for men. The facilities in Manhattan and Atlanta serve as 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. 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 below. Manhattan Medelha NO Atlante I Knoxville The costs for shipping between each facility is shown below. A grey cell indicates that shipping between two facilities is not permitted. $4.5 Philadelphia Knoxville Memphis New Orleans El Paso Manhattan $25 Atlanta $22 $2.35 Philadelphia $2.25 $18.22 $14.22 $35.25 Knoxville $3.5 $15.22 $5.90 $17.2