Consider the following LP problem:
Maximize profit = 5X =6Y
Subject to 2X+Y= 120
2X+ 3Y = 240
X,Y= 0
A) What is the optimal solution to this problem? Solve it using solver.
B) If a technical breakthrough occurred that raised the profit per unit of X to $8, would this affect the optimal solution?
C) 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?
Reminder this problem must be solved using Solver in Excel.