Consider the following spreadsheet and Excel Solver sensitivity report. $($The profit is in dollars, and the variables $x_1$ and $x_2$ represent the number of units of products $1$ and $2,$ respectively.$)$

Sensitivity Report

Variable Cells

ConstraintsUse the spreadsheet and Excel Solver sensitivity report to answer these questions.

$($a$)$ What is the cell formula for B$12($the profit contribution of variable $x_1)?$

$=B8-B11$

$=B{8}^{**}B11$

$\frac{?}{s}=UM(B4$:$B6{)}^{**}B8$

$\frac{?}{S}=UM(B4$:$B6)-B11$

$\frac{?}{s}=uM(B4$:$B6{)}^{**}B11$

$($b$)$ What is the cell formula for $C12($the profit contribution of variable $x_2)?$

$={\displaystyle \underset{?}{\overset{?}{}}}(C4$:$C6)-C11$

$\frac{?}{S}=UM(C4$:$C6{)}^{**}CB$

$=C{8}^{**}C11$

$=C8-C11$

: $\frac{?}{\text{S}\text{U}\text{M}}(C4$:$C6{)}^{**}C11$

$($c$)$ What is the cell formula for D$12?$

$=B12-C12$

$=B12+C12$

$=C\frac{12}{B}12$

$=B{12}^{**}C12$

$=B\frac{12}{C}12$

$($d$)$ What is the cell formula for $B15($the final value of the first constraint$)?$

$=B{8}^{**}B11+C{B}^{**}C11$

$=B{4}^{**}B8-C{4}^{**}C8$

$=B^{**}B11+C^{**}C11$

$=B^{**}B11-C{44}^{**}C11$

$=B{4}^{**}B8+C{4}^{**}C8$

$($e$)$ What is the cell formula for B$16($the final value of the first constraint$)?$

$=B{5}^{**}B11+C^{**}C11$

$=B{5}^{**}B8+C{5}^{**}C8$

$=B{5}^{**}B8-{?}^{**}{?}^{**}C8$

$=B^{**}B11-C{5}^{**}C11$

$=B{8}^{**}B11+C{B}^{**}C11$

$($f$)$ What is the cell formula for $B17($the final value of the first constraint$)?$

$=B{6}^{**}B11-C{6}^{**}C11$

$=B{6}^{**}B8+C^{**}C8$

$=B{6}^{**}B8-C^{**}C8$

$=B6**B11+C^{**}C11$

$=B{8}^{**}B11+C{B}^{**}C11$

$($g$)$ What is the optimal value for $x_1?($Round your answer to two decimal places.$)$

$($h$)$ What is the optimal value for $x_2?($Round your answer to two decimal places.$)$

$|$

$($i$)$ Would you pay $$0\mathrm{.}20$ each for up to $76$ more units of resource $1?$

Yes

No

$($j$)$ Is it possible to figure the new objective function value if the profit on product $1$ increases by a dollar, or do you have to rerun Solver?

Yes, it is possible to know the new value without rerunning Solver

No$,$ it is necessary to rerun Solver: