ework Question 13, 2.4.29 HW Score: 74.17%, 74.17 of 100 points KO Save Part 1 of 2 O Points: 0 of 8 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 From To Amount Shipped 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 Marietta Cleveland as follows, and the formulas for the Amount Shipped column should reference the names in the From and To columns. Marietta Baltimore Marietta Chicago Marietta Phoenix Minneapolis Cleveland Minneapolis Baltimore Minneapolis Chicago Minneapolis Phoenix Click the icon to view the data and model. . . . Let cell range B11:E12 be named "Model," let cell range A11:A12 be named "Plant," and let cell range B10:E10 be named "Center." Select the appropriate INDEX and MATCH functions to complete the spreadsheet below. H I J 1 From To Amount Shipped 2 Marietta Cleveland 3 Marietta Baltimore 4 Marietta Chicago 5 Marietta Phoenix 6 Minneapolis Cleveland 7 Minneapolis |Baltimore 8 Minneapolis Chicago Minneapolis PhoenixGeneral Appliance Corporation A B C D E F 1 Data 2 Distribution Center 3 Plant Cleveland Baltimore Chicago Phoenix Capacity A Marietta $13.24 $14.66 $11.63 $17.84 1050 5 Minneapolis $9.71 $16.38 $8.08 $17.95 900 6 Demand 200 250 500 1000 7 8 Model 9 Distribution Center 10 Plant Cleveland Baltimore Chicago Phoenix Total Shipped 11 Marietta O 250 O 800 1050 12 Minneapolis 200 O 500 200 900 13 Demand 200 250 500 1000 14 15 Cost 16 Total $27,509- . . Let cell range B11:E12 be named "Model," let cell range A11:A12 be named "Plant," and let cell range B10:E10 be named "Center." Select the appropriate INDEX and MATCH functions to complete the spreadsheet below. H From To 2 Marietta Cleveland 3 Marietta Baltimore =MATCH(Plant, INDEX(H9,Center,0), INDEX(19, Model,0)) Marietta Chicago =INDEX(Model,MATCH(H9,Plant,0), MATCH(19,Center,0)) 5 Marietta Phoenix 6 Minneapolis Cleveland =MATCH(Model, INDEX(H9, Plant,0), INDEX(19, Center,0)) 7 Minneapolis Baltimore =INDEX(Center, MATCH(H9, Plant,0),MATCH(19,Model,0)) B Minneapolis Chicago 9 Minneapolis Phoenix