A B C D E F G Chairs Tables Bookcases Unit Profit $40 $220 $280 Resources Required per Unit Total Used Available Assembly (minutes) Finishing (minutes) 20 30 45 3600 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$10 Prodution Chairs 0 -90 40 90 $C$10 Prodution Tables 60 0 220 60 33.33 $D$10 Prodution Bookcases 40 0 280 50 60 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$5 Assembly (minutes) Total Used 3600 $E$6 Finishing (minutes) Total Used 2000 $E$7 Wood (pounds) Total Used 3600 450 3600 200 600 2000 400 400 3800 1E+30