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

Warehouse City E City F City G City H 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 each city? (USE SOLVER)

3. What warehouses are shipping to City H? (USE SOLVER)

4. How many units city E getting from Warehouse D? (USE SOLVER)