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 SolverTable 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 decision variable cells, the labor hours and cloth used, and the profit as outputs in the table. 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 SolverTable.

Figure 6.12

A B D E F. G H K 1 Great Threads fixed cost clothing model Range names used: Effective_capacity Rent equipment =Model!$B$18:$F$18 =Modell$B$14:$F$14 =Model!$B$29 =Model!$D$22:D$23 |=Model!$B$22:$B$23 =Modell$B$16:$F$16 2 3 Input data on products Shirts Profit Resource available Resource_used Units produced 4 Shorts Pants Skirts Jackets 5 Labor hours/unit 6 Cloth (sq. yd.)/unit 2 8 3 2.5 4. 4.5 5.5 7 8 Selling price/unit 9 Variable cost/unit 10 Fixed cost for equipment $35 $20 $1,500 $40 $10 $65 $25 $70 $30 $110 $35 $1,200 $1,600 $1,500 $1,600 11 12 Production plan, constraints on capacity 13 Shirts Shorts Pants Skirts Jackets 14 Rent equipment 15 16 Units produced 965.52 379.31 17