In the Great Threads model, the production quantities in row 16 were not constrained to be integers. Presumably, 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 14.46?

Transcribed Image Text:

Figure 14.46 Fixed-Cost Clothing Model A B D. F G H. 1 Great Threads fixed cost clothing model 2 3 input data on products Range names used: Logical upper_limit -ModellSB18-$F$18 Produce any? Profit Resource_available -Modell$D$2:$D$23 Resource_used Units produced -Modell$8$14:$F$14 ModellSB$ 29 Shirts Skirts 4 Shorts Pants Jackets 5 Labor hours/unit 6 Cloth (sq. yd.)/unit 6 4 -ModelI$B$22 $B$ 23 ModellSBS 16:SF$16 2.5 4.5 5.5 7 8 Selling price/unit 9 Variable cost/unit 10 Fixed cost for equipment $35 $40 $65 $70 $110 $20 $10 $25 $30 $35 $1,500 $1,200 $1,600 $1,500 $1,600 11 12 Production plan, constraints on capacity 13 Shirts Shorts Pants Skirts Jackets 14 Produce any? 15 16 Units produced 965.52 379.31 17 18 Logical upper limit 19 20 Constraints on resources 21 22 Labor hours 23 Cloth 24 25 Monetary outputs 26 Revenue 27 Variable cost 28 Fixed cost for equipment 29 Profit 0.00 1800.00 0.00 0.00 500.00 Resource used Available 4000.00 4500.00 4000 4500 $80,345 $22,931 $2,800 $54,614 + Objective to maximize