Use INDEX and MATCH functions to fill 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 From Marietta To Cleveland Marietta Baltimore Marietta Chicago Phoenix Amount Shipped 2 3 Plant Distribution Center Cleveland 4 Marietta $13.24 Phoenix Baltimore Chicago $17.84 $11.63 $14.66 Capacity 5 Minneapolis $9.71 $16.38 $8.08 $17.95 1050 900 6 Demand 200 250 500 1000 Marietta Minneapolis Cleveland Minneapolis Baltimore Minneapolis Chicago Minneapolis 7 8 Model 9 Distribution Center Phoenix 10 Plant Cleveland Click the icon to view the data and model. 11 Marietta 12 Minneapolis 13 Demand Phoenix Baltimore Chicago Total Shipped 0 250 0 200 0 500 800 200 1050 900 200 250 500 1000 14 8 Minneapolis Chicago 9 Minneapolis Phoenix FINDEX(Model,MATCH(H8, Plant,U),MAI CH(18,Center,U)) INDEX(Model,MATCH(H9, Plant,0),MATCH(19,Center,0)) Replace the functions with the amounts shipped between each pair of cities. 15 Cost 16 Total $27,509 17 18 19 From To Amount Shipped 20 Marietta Cleveland 0 21 Marietta Baltimore 22 Marietta Chicago 0 23 Marietta Phoenix 24 Minneapolis Cleveland 25 26 Minneapolis Baltimore 0 4 27 Minneapolis Chicago 28 Minneapolis Phoenix 29