ter 1 y Plan B dy Plan apter 3 4 Cudy Plan Chapter 4 h5 Use the a amou form B Repla From Mari Mar Mari Mari Minn Minn Minn Minn General Appliance Corporation B C D 1 Data 2 Distribution Center 3 PlantCleveland Baltimore Chicago Marietta $13.23 $14.31 $11.0 $8.16 Minneapolis $16.25 $9.73 100 Demand 350 500 Model Distribution Center 350 0 Plant Cleveland Baltimore Chicago Marietta 0 Minneapolis Demand 500 100 100 350 500 Cost $27.636 Done Tech help 4 5 G 7 D 10 11 12 13 14 15 16 Total Print 0 E Phoenix Capacity $17.53 $17.90 1000 Phoenix 1250 700 Total Shipped 1250 700 DOD 100 1000 Suomiit qarz - Next past du the score mentos bicades point possible From Maneta Marieta To Cleveland Batimore Maneta Chicago Maneta Phoenix Minneapolis Cleveland Minneapols Batimore Minneapols Chicago Minneapolis Phoenix Plan ter 1 Use INDEX and MATCH functions to fe in a table that extracts the amounts shipped between each pair of cities in the accompanying data, which shows the solution to an optimization model that finds the minimum cost and amounts shipped from two plants to four distribution centers. Your table should be set up as follows, and the formulas for the Amount Shipped column should reference the names in the From and To columns dy Plan Click the icon to view the data and model apter 2 3 Replace the functions with the amounts shipped between each pair of cities tudy Plan From To Amount Shipped Marietta Cleveland 0 Marietta Baltimore Chapter 3 Marietta Chicago 0 Marietta Phoenix Minneapolis Cleveland ch 4 O Minneapolis Baltimore Minneapolis Chicago Minneapols Phoenix Study Plan Chapter 4 Tech help Amount Shipped Next past due see store ubicados