Question: In the optimal solution to the Great Threads model, the labor hour and cloth constraints are both binding-the company is using all it has.
a. Use Solver able to see what happens to the optimal solution when the amount of available cloth increases from its current value. (You can choose the range of input values to use.) Capture all of the changing cells, the labor hours and cloth used, and the profit as outputs. The real issue here is whether the company can profitably use more cloth when it is already constrained by labor hours.
b. Repeat part a, but reverse the roles of labor hours and cloth. That is, use the available labor hours as the input for Solver Table.