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

To

Amount Shipped

Marietta

Cleveland

Marietta

Baltimore

Marietta

Chicago

Marietta

Phoenix

Minneapolis

Cleveland

Minneapolis

Baltimore

Minneapolis

Chicago

Minneapolis

Phoenix

LOADING... Click the icon to view the data and model.

Question content area bottom

Part $1$

Let cell range$$ B$11$:E$12$ be named$$ "Model," let cell range$$ A$11$:A$12$ be named$$ "Plant," and let cell range$$ B$10$:E$10$ 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

$=$INDEX$($Center$,$MATCH$($H$2,$Plant,$0),$MATCH$($I$2,$Model,$0))$

$3$

Marietta

Baltimore

$=$MATCH$($Plant$,$INDEX$($H$3,$Center,$0),$INDEX$($I$3,$Model,$0))$

$4$

Marietta

Chicago

$=$INDEX$($Model$,$MATCH$($H$4,$Plant,$0),$MATCH$($I$4,$Center,$0))$

$5$

Marietta

Phoenix

$=$INDEX$($Center$,$MATCH$($H$5,$Plant,$0),$MATCH$($I$5,$Model,$0))$

$6$

Minneapolis

Cleveland

$=$MATCH$($Plant$,$INDEX$($H$6,$Center,$0),$INDEX$($I$6,$Model,$0))$

$7$

Minneapolis

Baltimore

$=$INDEX$($Center$,$MATCH$($H$7,$Plant,$0),$MATCH$($I$7,$Model,$0))$

$8$

Minneapolis

Chicago

$=$MATCH$($Plant$,$INDEX$($H$8,$Center,$0),$INDEX$($I$8,$Model,$0))$

$9$

Minneapolis

Phoenix

$=$MATCH$($Model$,$INDEX$($H$9,$Plant,$0),$INDEX$($I$9,$Center,$0))$