Use the Excel Solver output for a Maximization LP problem to determine by how much the objective function value will increase by if the RHS of the Space Constraint increases by $5$ units.

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

Variable Cells

Name

Variable$1$

Final Reduced

Objective AllowableAllowable

Variable$2$

ValueCost

CoefficientIncrease Decrease

$2\mathrm{.}40$

$5$

$4,1$

$2\mathrm{.}40$

$6$

$1\mathrm{.}5,2\mathrm{.}67$

Constraints

$\backslash$table$[[$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,],[$Space$,12,1\mathrm{.}6,12,6,1\mathrm{.}8,],[$Limit$,3\mathrm{.}2,0,10,6\mathrm{.}8,1E+30,]]$

$$40$

$$1\mathrm{.}2$

$$8$

Exceeds Range of Feasibility