Consider the following LP problem. Use Excel Solver to set up and solve this problem and generate a sensitivity analysis report. Then, use that report to answer the following questions.

MAX: $4x_1+2x_2$

Subject $to$: $2x_1+4x_{2}20$

$,3x_1+5x_{2}15$

$,x_1,x_{2}0$

a$/$ If X$2$ were forced to equal $1,$ then what would be optimal objective function value be$?$

b$/$ What is the optimal objective function value if the RHS value for the second constraint changes from $15$ to $25?$

$(a,b)=(33\mathrm{.}33,15\mathrm{.}33)$

$(a,b)=(17\mathrm{.}84,35\mathrm{.}41)$

$(a,b)=(15\mathrm{.}33,33\mathrm{.}33)$

$(a,b)=(35\mathrm{.}41,17\mathrm{.}84)($Solve in excel with solver$)$