Problem 10-11

Hi can you please help me to solve this using Excel Solver? Thank you!

Customer demand and shipping costs per unit (in \$) from each warehouse to each customer are as follows: a. Choose the correct network representation of this problem. (i) (ii) (i) c. Solve the linear program to determine the optimal shipping plan. Objective Function Value = There is an excess capacity of units at