Solve the LP by Excel Solver and then answer the following questions based on the Answer and Sensitivity Report of the original LP. You are not allowed to re-solve the LP for each of the questions.

Max where is the quantity of product 1 to make, etc.

Subject to

Machine: minutes

Labor: hours

Materials:

Product 2: units

Non-Negativity:

Note: the following questions are independent of each other.

a) Are any constraints binding? If so, which one(s)?

b) If the profit on product 3 were changed to $25 a unit, what would the values of the decision variables be? The objective function? Explain.

c) If the profit on product 1 were changed to $20 a unit, what would the values of the decision variables be? The objective function? Explain.

Z = 12.01 + 18.02 + 15.73 5.21 + 4.62 +3.03