(Solved): Develop an Excel model for the following LP transportation problem. Solve the problem using Solver ...

Develop an Excel model for the following LP transportation problem. Solve the problem using Solver and match the correct answer to the questions. Match the correct answer to the following questions: 1. What is the value of the objective function? 2. How many units Warehouse B is shipping to each city? 3. What warehouses are shipping to City $\mathrm{H}$ ? 4. How many units city E getting from Warehouse D? Question \#1 Question \#2 Question \#3 1. What is the value of the objective function? 2. How many units Warehouse B is shipping to each city? 3. What warehouses are shipping to City $\mathrm{H}$ ? 4. How many units city E getting from Warehouse D? How many units city $E$ getting from Warehouse $D$ ? \begin{tabular}{l|l} \hline & $?[$ Choose ] \\ restion \#1 & \\ & $E=500;F=0;G=5000;H=0$ \\ & 4400 \\ & 25,100 \\ & 4200 \\ & 28,000 \\ & $E=1100;F=2100;G=4000,H=500$ \\ & $B=4000;C=11$ \\ & $A=4000;C=500;D=1100$ \\ & 4000 \\ & 3800 \\ & $E=0;F=0;G=5000;H=0$ \\ & $A=2000;C=2500;D=1100$ \\ & 41,000 \\ \hline \end{tabular}