$($DO NOT use Excel! similar problem we discussed in class in details$).$

Consider the following linear program, which maximizes profit for two products$--$regular $($R$)$ and super $($S$)$:

MAX $50$R $+75S$

s$.$t$.$

$1\mathrm{.}2R+1\mathrm{.}6S600$ assembly $(hours)$

$0\mathrm{.}8R+0\mathrm{.}5S300$ paint $(hours)$

$0\mathrm{.}16R+0\mathrm{.}4S100$ inspection $(hours)$

Sensitivity Report:

$\backslash$table$[[,,,,,,],[$Cell$,$Name,Final,Reduced,Objective,Allowable,Allowable$],[$$BS$7,$Regular $=,291\mathrm{.}67,0\mathrm{.}00,50,70,20],[$$CS$7,$Super $=,133\mathrm{.}33,0\mathrm{.}00,75,50,43\mathrm{.}75],[,,,,,,],[,,,,,,],[,,$Final,Shadow,Constraint,Allowable,Allowable$],[$Cell$,$Name,Value,Price,R$.$H$.$ Side,Increase,Decrease$],[$$ES$3$ Assembly $($hr$/$unit$),563\mathrm{.}33,4\mathrm{.}00,600,1E+30,36\mathrm{.}67,],[$$ES$4$Paint $($hr$/$unit$),300\mathrm{.}00,33\mathrm{.}33,300,39\mathrm{.}29,175,],[$$ES$5$ Inspect $($hr$/$unit$),100\mathrm{.}00,145\mathrm{.}83,100,12\mathrm{.}94,40,]]$

Question $10$

If the company wanted to increase the available hours for one of their constraints $($assembly$,$ painting, or inspection$)$

$!$

@

$2$

$3$

$

$4$

Q

$(1)$

G

$$

F$7$