Figure $1$:$\backslash$

$\backslash \backslash \backslash \backslash$table$[[,$A$,$B$,$C$,$D$,$E$],[1,,,,,],[2,,$

x$\_(1)$

$,$

x$\_(2)$

$,,],[3,$Number to Make:,,,,OBJ. FN$.$ VALUE:$],[4,,,,,],[5,$Unit profit:,

$$4$

$,$

$$3$

$,,],[6,,,,,],[7,$Constraints:,,,Used,Available$],[8,1,3,5,,40],[9,2,12,10,,120],[10,3,1,0,,15]]\backslash$

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

Max: $4$x$1+3$x$2\backslash$

Subject to: $\backslash$

$3$x$1+5$x$2<=40\backslash$

$12$x$1+10$x$2<=120\backslash$

x$1>=15\backslash$

x$1,$x$2>=0$

$\backslash$

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.$\backslash$

Refer to Figure $1.$ What formula should be entered in cell E$4$ to compute total profitability?$\backslash$

A$)$

$=$

SUMPRODUCT

$($B$5$:C$5,$B$2$:C$2)$

$\backslash$

B$)$

$()/($S$)=$UM $($B$3$:C$3)$

$\backslash$

C$)$

$=$B$2**$B$5+$C$2**$C$5$

$\backslash$

D$)$

$=$

SUMPRODUCT$($B$5$:C$5,$E$8$:E$10)\backslash$

E$)$

$=$B$3**$B$5+$C$3**$C$5$

$\backslash$

Answer:$\backslash$

Page Ref: $42\backslash$

Topic: Setting Up and Solving Linear Programming Problems Using Excel's Solver$\backslash$

Difficulty: Easy$\backslash$

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

A$)$

$=$

B

$9**$D$9+$C$9**$D$9$

$\backslash$

B$)$

$=$

SUMPRODUCT

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

$\backslash$

C$)$

$()/($S$)=$UM $($B$9$:C$9)$

$\backslash$

D$)$

$=$

SUMPRODUCT

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

$\backslash$

E$)$

$=$

SUMPRODUCT

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

$\backslash$

Answer:$\backslash$

Page Ref: $42\backslash$

Topic: Setting Up and Solving Linear Programming Problems Using Excel's Solver Difficulty: Easy