a Develop a network representation of this problem b Formula

a. Develop a network representation of this problem.

b. Formulate a linear programming model of the problem.

c. Solve the linear program to determine the optimal shipping plan.

NOTE: PLEASE SOLVE IN EXCEL. PLEASE EITHER ATTACH EXCEL WORKSHEET OR SCREENSHOT STEP BY STEP TO INCLUDE SOLVER FORMULATIONS

10.11 -the distribution system for Herman company consists of 3 plants, 2 warehouses and 4 customers. Plant capacities and shipping costs per unit from each plant to each warehouse are shown below. Warehouse Plant Capacity 450 600 380 4 Customer demand and per unit shipping costs from each warehouse to each customer are as follows: Customer Warehouse1 4 2 6 Demand 300 300 300 400

Solution