Develop an Excel model for the following LP transportation problem. Solve the problem using Solver and match the correct

[answerhappygod]

Develop an Excel model for the following LP transportationproblem. Solve the problem using Solver and match the correctanswer to the questions.
Warehouse CityE City F City G CityH Warehouse Supply
A 0.53 0.21 0.52 0.41 4500
B 0.31 0.37 0.41 0.28 5000
C 0.56 0.32 0.56 0.33 4000
D 0.41 0.54 0.34 0.52 5500
City Demand 4,400 3,500 5,500 5,600
Match the correct answer to the following questions:
1. What is the value of the objective function? (USE SOLVER)
2. How many units Warehouse B is shipping to eachcity? (USE SOLVER)
3. What warehouses are shipping to City H? (USE SOLVER)
4. How many units city E getting from Warehouse D? (USESOLVER)