Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a Sensitivity Report. Use this information to answer the following questions:

MAX:	4X1 + 3X2
Subject to:	2X1 + 4X2		20
	3X1 + 5X2		15
	X1, X2		0

(a)

What range of values can the objective function coefficient for variable X₁ assume without changing the optimal solution? (If there is no limit on how much the coefficient can increase or decrease, enter .)

The objective function coefficient for variable X₁ can decrease by

or increase by

without changing the optimal solution.

(b)

Is the optimal solution to this problem unique, or are there alternate optimal solutions?

(c)

How much does the objective function coefficient for variable X₂ have to increase before it enters the optimal solution at a strictly positive level? (Round your answer to three decimal places.)

(d)

What is the optimal objective function value if X₂ equals 1? (Round your answer to three decimal places.)

(e)

What is the optimal objective function value if the RHS value for the second constraint changes from 15 to 24? (Round your answer to three decimal places.)

(f)

Is the current solution still optimal if the coefficient for X₂ in the second constraint changes from 5 to 1? Explain. (Round your answer to three decimal places.)

If we change this coefficient from 5 to 1, then the new reduced cost for X₂ for our current solution would be . Therefore, it_____ be profitable to increase the value of X₂ and the current solution would ________ be optimal.