1. Consider the following linear program

Min 8X + 12Y

s.t.

1X + 3Y > 9

2X + 2Y > 10

6X + 2Y > 18

X, Y > 0

1. Use the Excel Solver to find the Optimal Solution. Please identify the solutions as well as the slack and surplus variables.
2. Assume that the objective function coefficient for X changes from 8 to 6. Does the optimal solution change? Use the sensitivity analysis report to answer this question.
3. Assume that the objective function coefficients for X remains 8, but the objective function coefficient for Y changes from 12 to 6. Does the optimal solution change? Use the sensitivity analysis report to answer this question.
4. What are the shadow prices and what do they mean?

Identify the range of optimality and the range of feasibility for this problem.