*** I need the excel sheet set up along with the excel solver answers. I am having trouble setting up the table to get the excel solver results.

(Hint: Sensitivity Analysis problem). Consider the following LP problem:

Maximize profit = 5x +6y

Subject to:

2x +y < 120

2x + 3y < 240

X, y > 0

What is the optimal solution to this problem? Solve it using excel solver and obtain the sensitivity report. (be sure to submit the Excel work sheet along with your answers).

a)If a technical breakthrough occurred that raised the profit per unit of X to $8, would this affect the optimal solution?

b)Instead of an increase in the profit coefficient X to $8, suppose that profit was overestimated and should only have been $3. Does this change the optimal solution?

c)If the second constraint is changed from 2X + 3Y <=240 to 2X + 4Y<=240, what effect will this have on the optimal solution?