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

Transcribed Image Text:

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 <= く= <= <= <= 18 Effective capacity 0.00 1800.00 0.00 0.00 500.00 19 20 Constraints on resources 21 Resource used Available 22 Labor hours 4000.00 4000 くニ 23 Cloth 4500.00 く= 4500 24 25 Monetary outputs 26 Revenue 27 Variable cost 28 Fixed cost for equipment 29 Profit $80,345 $22,931 $2,800 $54,614 Objective to maximize