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

Warehouse City E City F City G City H Warehouse Supply

A 0.51 0.21 0.52 0.41 4000

B 0.31 0.35 0.41 0.28 6000

C 0.56 0.32 0.54 0.33 4000

D 0.43 0.54 0.34 0.52 5500

City Demand 4,400 3,000 6,500 5,600

Please answer the following questions:

1. What is the value of the objective function?

2. How many units Warehouse A is shipping to each city?

3. What warehouses are shipping to City G?

4. How many units city E getting from Warehouse C?