$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$],[1,,,,,],[2,,x_1,x_2,,],[3,$Number to Make:,,,,OBJ. FN$.$ VALUE:$],[4,,,,,],[5,$Unit profit:,$S4,$$$3,,],[6,,,,,],[7,$Constraints:,,,Used,Available$],[8,1,3,5,,40],[9,2,12,10,,120],[10,3,1,0,,15]]$

Figure $1$ demonstrates an Excel spreadsheet that is used to model the following linear programming problem:

Max: $4x_1+3x_2$

Subject $to$:

$,3x_1+5x_{2}40$

$,12x_1+10x_{2}120$

$,x_{1}15$

$,x_1,x_{2}0$

Note: Cells B$3$ and C$3$ are the designated cells for the optimal values of $x_1$ and $x_2,$ respectively, while cell E$4$ is the designated cell for the objective function value. Cells D$8$:D$10$ designate the left$-$hand side of the constraints.

Refer to Figure $1.$ What formula should be entered in cell D$9$ to compute the amount of resource $2$ that is consumed? $$

$=$SUMPRODUCT$($B$9$:C$9,$B$5$:C$5)$

$\frac{?}{S}=UM(B9$:$C9)$

$=B99D9+C9D9$

$=$SUMPRODUCT$($B$2$:C$2,$B$9$:C$9)$

$=$SUMPRODUCT$($B$3$:C$3,$B$9$:C$9)$