Your answers and justifications for this part should be based only on the sensitivity report provided below and NOT on the Excel sheet used in A$.$

M$1($pounds$)$

M$2($pounds$)$

Labor $($hours$)$

A

$2$

$3$

$3\mathrm{.}2$

B

$1$

$5$

$1\mathrm{.}5$

C

$6$

$0$

$2$

Variable Cells

Cell Name Value

$L$$10$ AQty $10$

$L$$11$ BQty $54$

Cost Coefficient

$-2726$

$050$

$020$

Increase

$27$

$1$E$+30*$

$46\mathrm{.}67$

Decrease

$1$E$+30*$

$35$

$20\mathrm{.}00$

Final Reduced Objective Allowable Allowable

$L$$12$ C Qty Constraints

Cell Name

$F$$13$ UsedM$1$

$G$$13$ Used M$2$

$18\mathrm{.}50$

Final Shadow Constraint Allo