Hello please help me put all the values and help me how to use Solver please help me guide step by step on how to put the details in an Excel sheet. please add a screenshot of the excel sheet properly so I can understand.

Transportation Problems Example Note: Transportation problems or the optimization of shipping plans are very popular in linear programming. Can be relevant to any company with products to transport from one place to another, E.g. Manufacturing facilities to distribution centers to retailers and so forth, and are looking to minimize their costs. Algoma Recycling collects used papers and cardboard and ships them to processing facilities for recycling purposes. They have four collection centers across the region and ship to two processing facilities. There is a cost associated with shipping each Ton of recycling material from one place to another. Additionally, there are minimum demands that must be met at the facilities and limitations on how much each center can supply. The table below shows these values: Collection center 1 2 3 4 Quantity required (Tons) Facility 1 $3 $9 $7 $2 275 Facility 2 $8 $4 $6 $4 340 Supply limit (Tons) 170 190 65 210 Formulate an LP model to determine the tons of used papers and cardboards paper to ship from each center to each facility so that total shipping costs are minimized. X11 Centers 1 2 3 4 1 2 Facilities

Let, X11 = tons shipped from Center 1 to Facility 1 X12 = tons shipped from Center 1 to Facility 2 X21 = tons shipped from Center 2 to Facility 1 X22 = tons shipped from Center 2 to Facility 2 X31 = tons shipped from Center 3 to Facility 1 X32 = tons shipped from Center 3 to Facility 2 X41 = tons shipped from Center 4 to Facility 1 X42 = tons shipped from Center 4 to Facility 2 Minimize Cost = 3X11 + 8X12 + 9X21 + 4X22 + 7X31 + 6X32 + 2X41 + 4X42 Subject to: Center 1 supply: X11 + X12 170 Center 2 supply: X21 + X22 190 Center 3 supply: X31 + X32 65 Center 4 supply: X41 + X42 210 Facility 1 demands: X11 + X21 + X31 + X41 275 Facility 2 demands: X12 + X22 + X32 + X42 340 Non-negativity: All variables 0