Problem $1$ Part a$)$ Use the Sensitivity Report that you generated and refer to your original

answer. Assume that we will decrease the value of the coefficient of B to $$3\mathrm{.}00.$

Answer the questions below in your spreadsheet to the right of your data.

Amount of the Decrease equals what value? $(2$ points$)$

The Allowable Decrease equals what value? $(2$ points$)$

Is this change within the Allowable Decrease? $(2$ points$)$

What will the new objective function value equal? $(4$ points$)$ Note: You must calculate this

value off to the right in your spreadsheet using the SUMPRODUCT formula that we used

in all sensitivity analysis spreadsheets posted on Canvas.

$($Continued on next page$)$