Oak
tables
Oak
chairs
Cherry
tables
Cherry
chairs
Pine
tables
Pine
chairs
Min oak tables 1 3.00 >= 3
Classic Furniture Company
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$4 Number of units Oak tables 3.00 0.00 75.00 0.00 1E+30
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$H$7 Labor hours 1000.00 10.00 1000.00 373.30 37.21
$H$8 Oak (pounds) 2150.00 0.00 2150.00 318.93 1250.00
Problems 4-28to32. Classic Furniture Company