The computer output given below is for Problem 7-31. Use this to answer the following questions.

(a) How much could the profit on X increase or decreas without changing the values of X and Y in the optimal solution?

(b) If the right-hand side of constraint 1 were increased by 1 unit, how much would the profit increase?

( c) If the right-hand side of constraint 1 were inceased by 10 units, how much would the profit increase?

	X	Y		RHS	Dual
Maximize	5	6
Constaint 1	2	1	<=	120	0.755555
Costraint 2	2	3	<=	0	1.75
Solution>	30	60		510

Variable	Value	Reduced Cost	Original Value	Lower Bound	Upper Bound
X	30	0	5	4	12
Y	60	0	6	2.5	7.5
Constraint	Dual value	slack/surplus	Original Value	Lower Bound	Upper Bound
const 1	0.75	0	120	80	240
const 2	1.75	0	240	120	360

Need to solve the Linear programming model in Excel using the Solver add in to Excel.