In the Great Threads model, we didn’t constrain the production quantities in row 16 to be integers, arguing that any fractional values could be safely rounded to integers. See whether this is true. Constrain these quantities to be integers and then run Solver. Are the optimal integer values the same as the rounded fractional values in Figure 6.12?

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