Shipments: From Plant A Plant B Plant C To 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Flow in 0.0 0.0 0.0 0.0 0.0 Unit Costs From Flow out 0.0 0.0 0.0 To Plant A Plant B Plant C Total cost. = 0 M4_IND3. A supply chain consists of three plants (A, B, and C), three distributors (J, K, and L), and three stores (X, Y, and Z). The relevant supply, demand, and unit shipping costs are given in the tables below. Plant A B C Supply (units) 400 600 350 Stores X Y Z Demand (units) 450 450 350 The unit transportation costs ($) for the shipments from the plants to the distributors and from the distributors to the stores are shown below: To Distibutor From Plant A B C J $8 $5 $6 K $5 $7 $8 L $6 $4 $7 To Store From Distributor J K L J $2 $5 $6 K $6 $5 $8 L $8 $7 $9 Formulate this problem in Excel and solve to determine the minimum shipping costs required to meet demands. a) What is the total cost to minimize shipping costs from the plants? b) Which routes had zero units shipped? c) Which supplier did not ship out all of its supply? d) How many units should be shipped from C to J? e) How many units should be from K to Y? Location Flow in 0.0 0.0 0.0 0 0 Flow balance equations Flow out Net flow Sign RHS 0 0 0 0 0 0 0 0 0 0 0