Table $3\mathrm{.}1$: Regular & Super

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

MAX $50R+75S$

s$.$t$.$

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

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

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

Sensitivity Report:

$\backslash$table$[[$Cell$,$Name,$\backslash$table$[[$Final$],[$Value$]],\backslash$table$[[$Reduced$],[$Cost$]],\backslash$table$[[$Objective$],[$Coefficient$]],\backslash$table$[[$Allowable$],[$Increase$]],\backslash$table$[[$Allowable$],[$Decrease$]]],[$$B$$7,$Regular $=,291\mathrm{.}67,0\mathrm{.}00,50,70,20],[$$C$$7,$Super $=,133\mathrm{.}33,0\mathrm{.}00,75,50,43\mathrm{.}75]]$

$\backslash$table$[[,,$Final,Shadow,Constraint,Allowable,Allowable$],[$Cell$,$Name,Value,Price,R$.$H$.$ Side,Increase,Decrease$],[$SES$3,$Assembly $($hr$/$unit$),563\mathrm{.}33,0\mathrm{.}00,600,1E+30,36\mathrm{.}67],[$SES$4,$Paint $($hr$/$unit$),300\mathrm{.}00,33\mathrm{.}33,300,39\mathrm{.}29,175],[$SES$5,$Inspect $($hr$/$unit$),100\mathrm{.}00,145\mathrm{.}83,100,12\mathrm{.}94,40]]$

If the company wanted to increase the available hours for one of their constraints $($assembly$,$ painting. or inspection$)$ by two hours, they should increase:

$1.$

inspection

nothing

paint

assembly