Implement the following profit maximization LP model in a spreadsheet. Use Solver

to solve the problem and create a Sensitivity Report. Use this information to answer the following

questions.

MAX: $$5$X$1+$ $$5$X$2$

Subject to:

$2$X$1+3$X$260$

$4$X$1+2$X$280$

X$1<=18$

$1,2>=0$

a$.$ What is the optimal solution to this problem? $(5$ Points$)$

b$.$ For what ranges of values, holding all else constant, could each of the objective function

coefficients be changed without changing the optimal solution? $(10$ Points$)$

c$.$ If we could obtain one additional unit of resource $1,$ how would it impact profit? Over what range

of RHS values could we rely upon this value? $(10$ Points$)$

d$.$ If we were to give up one unit of resource $2.$ How would it impact profit? $(5$ Points$)$