Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a sensitivity report. Use th

Z

information in the sensitivity report to answer the following question. $($round all answers to two decimal places$)$

MAx:$4x_1+2x_2$

Subject to:

$2x_1+4x_{2}20$

$3x_1+5x_{2}15$

$x_1,x_{2}0$

$($a$)$ What is the lower bound for the objective function coefficient for variable $x_1$ assume without changing the optimal solution?

$[$ ans $1]x_1$

$($b$)$ How much does the objective function coefficient for variable $x_2$ have to increase before it enters the optimal solution with a positive value?

$[$ans$3]$

$($c$)$ What is the optimal objective function value if $x_2$ equals $1?$

$[$ans$4]$

$($d$)$ What is the optimal objective function value if the RHS value for the second constraint changes from $15$ to $25?[$ans$5]$

Specified Answer for: ans $1,2\mathrm{.}8$

Specified Answer for: ans$34\mathrm{.}67$

Specified Answer for: ans$410\mathrm{.}33$

Specified Answer for: ans $17$