answer on excel please

H Q2: XYZ Logistics 20 (points) The shipping cost per unit from the different origins to the different destinations is given in the table below. Also indicated is the total supply from each origin as also the total demand of each destination The company would like to determine the optimal quantity that must be shipped from each origin to each destination Set up the problem as a LP problem and then enter the objective function and constraints in Solver Note: I should be able to see the formulae in the cells on the excel sheet and the Solver dialog box MUST be populated when I open them Parameters Shipping Cost/Unit B C D E $3.00 $6.00 $2.00 $4.00 6000 Destination F G $2.00 $7.00 $5.00 $2.00 $5.00 $4.00 $3.00 $5.00 4000 2000 H $6.00 $3.00 $5.00 $4.00 1500 Supply 5000 6000 2500 3000 $5.00 $4.000 $3.00 $3.00 3000 Origin 5 5 Demand