$\backslash$table$[[$Plant$,$Store A$,$Store B$,$Store C$,$Capacity$],[1,$$$6\mathrm{.}70,$$$5\mathrm{.}20,$$$3\mathrm{.}30,160],[2,$$$7\mathrm{.}90,$$$5\mathrm{.}20,$$$7\mathrm{.}20,750],[3,$$$4\mathrm{.}10,$$$7\mathrm{.}40,$$$4\mathrm{.}60,560],[$Demand$,740,290,400,]]$

Let:

$x_{11}=$ number of components produced in Plant $1$ and supplied to Store $A$

$x_{12}=$ number of comporients produced in Plant $1$ and supplied to Store $B$

$x_{13}=$ number of components produced in Plant $1$ and supplied to Store $C$

$x_{21}=$ number of compenents produced in Plant $2$ and supplied to Store $A$

$x_{22}=$ number of components produced in Plant $2$ and supplied to Store B

$x_{23}=$ number of components produced in Plant $2$ and supplied to Store $C$

$x_{31}=$ number of components produced in Plant $3$ and supplied to Store A

$x_{32}=$ number of camponents produced in Plant $3$ and supplied to Store $B$

$x_{33}=$ number of components produced in Plant $3$ and supplied to Store $C$

Min

$3_{x_{12}+},8_{x_{13}}+$

$321+$

$6{?}_{22}+$

$623+$

$Q_{x_{31}+}$

$]$

Subiect to the cpnstraints

What is the value of tolal distribution costs at the optimal solution? Use the Excel solver to find the optimal solutian. Rourid your answer to the nedret dollar: