For question 21, how do I set it up into excel?

$4 $6 500 propuncay Houston (proposed) Forecast demand $3 (anticipated) 800 1,200 21 The distribution system for the Smith Company con- sists of three plants (A, B, and C), two warehouses (D and E), and four customers (W, X, Y. and Z). The relevant supply, demand, and unit shipping cost information are given in the table for Problem 21 near the top of the next page. Set up and solve the trans- shipment model to minimize total shipping costs. Which of the new possible plants should be opened? Table for Problem 18 MARKETS BOSTON CHARLESTOWN DOVER PACKING PLANTS Eaglestown Farrier Guyton Hayesville Demand ATLANTA $6.00 $5.50 $6.00 $7.00 8,000 $7.00 $5.50 $5.00 $7.50 9,000 $7.50 $4.00 $6.50 $8.50 10,000 $7.50 $7.00 $7.00 $6.50 SUPPLY 8,000 10,000 5,000 9,000 5,000 187 TRANSPORTATION, ASSIGNMENT, AND NETWORK MODELS TO LAURENS Table for Problem 19 FROM WISE HUMBOLT CLEVELAND BREVARD Charlotte $20 $17 Greenville $25 $27 $20 $30 Atlanta $22 $25 $22 $30 Capacity 300 200 150 150 $21 $29 $27 $28 $31 DEMAND 250 200 350 150 Table for Problem 21 TO TO PLANT SUPPLY CUSTOMER DEMAND FROM D E FROM W X Y z A 450 W 450 A $4 $6 $4 D E $8 $7 $4 $7 B 500 B $7 $5 $6 $3 X Y $6 300 300 $8 $5 380 Z 400