Implement the following LP problem in a spreadsheet. Use Solver to solve the

problem and create a Sensitivity Report. Use this information 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$.$ What range of values can the objective function coefficient for variable $x_1$ assume

without changing the optimal solution?

b$.$ Is the optimal solution to this problem unique, or are there alternate optimal

solutions?

c$.$ How much does the objective function coefficient for variable $x_2$ have to increase

before it enters the optimal solution at a strictly positive level?

d$.$ What is the optimal objective function value if $x_2$ equals $1?$

e$.$ What is the optimal objective function value if the RHS value for the second

constraint changes from $15$ to $25?$

f$.$ Is the current solution still optimal if the coefficient for $x_2$ in the second constraint

changes from $5$ to $1?$ Explain. can you please put excel cells i don't know how to place correctly to get solver solution