Question $20$

$5pts$

Based on the Excel Solver output for a LP Maximization problem below, if additional units were available to be added to one constraint, which constraint would provide the greatest improvement to the objective function value by gaining those additional units.

Objective Function Value $=26\mathrm{.}40$

Variable Cells

$\backslash$table$[[,$Final Reduced,Objective Allowable,eAllowable$],[$Name$,$ValueCost,CoefficientIncrease,Decrease$],[$Variable$1,2\mathrm{.}4,4,1],[$Variable$2,2\mathrm{.}40,1\mathrm{.}5,2\mathrm{.}67]]$

$\backslash$table$[[$Constraints$,,,,,],[,$Final Shadow,Constraint AllowableAllowable,,$],[$Name$,$ValuePrice,R$.$H$.$ Side,Increase,Decrease,$],[$Labor$,12,0\mathrm{.}6,12,3,3],[$Wood$,6\mathrm{.}4,0,14,7\mathrm{.}6,1E+30$