#
Question

Formulation Max z = 3x_2 + 2x_2 (objective function) Subject to (s.t.) 2 x_1 + x_2 lessthanorequalto 100 (finishing constraint) x_1 + x_2 lessthanorequalto 80 (carpentry constrain) x_1 lessthanorequalto 40 (constraint on demand for soldiers) Sensitivity Report. The optimal objective function value for this problem is $180. Using the sensitivity report generated using Excel answer the following questions: Suppose that the capacity of the finishing operation is increased to 140 hours, how will this increase affect the optimum revenue? Explain and do not find new optimal value. If the capacity of the finishing operation is increased from 100 hours to 110 hours, how will this increase impact the optimum revenue? Explain and find the new optimal value. A suggestion is made to increase the capacities of operations 1 and 2 at the additional cost of $5/hr for each operation. Is this advisable? Explain. If you can increase the capacity of both operations, which operation should receive priority? Explain.