Not binding 43857142857 b12 painting quantity 46800

Not Binding 4385.7142857
$B$12 PAINTING QUANTITY 46800 $B$12<=$D$12 Binding 0
$B$14 AUXILIARY QUANTITY 2600 $B$14>=$B$4 Binding 0
$B$2 S QUANTITY 16157.1428571 $B$2<=$D$2 Not Binding 4842.8571429
$B$3 M QUANTITY 6200 $B$3<=$D$3 Not Binding 6300
$B$4 L QUANTITY 2600 $B$4<=$D$4 Not Binding 1600
$B$2 S QUANTITY 16157.1428571 $B$2>=$C$2 Not Binding 2157.1428571
$B$3 M QUANTITY 6200 $B$3>=$C$3 Binding 0
$B$4 L QUANTITY 2600 $B$4>=$C$4 Binding 0

Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Assignment Week 7-Robinson, C..xlsx]Sheet3
Report Created: 8/14/2019 9:54:27 PM
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$2 S QUANTITY 16157.142857 0 20.5 1E+030 1.5322580645
$B$3 M QUANTITY 6200 -4.0714285714 34 4.0714285714 1E+030
$B$4 L QUANTITY 2600 -3.3928571429 42 3.3928571429 1E+030
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$10 BENDING QUANTITY 12883 0 23400 1E+030 10517.142857
$B$11 WELDING QUANTITY 19014 0 23400 1E+030 4385.7142857
$B$12 PAINTING QUANTITY 46800 14.64 46800 6780 3020
$B$14 AUXILIARY QUANTITY 2600 0 0 0 1E+030

Microsoft Excel 16.0 Limits Report
Worksheet: [Assignment Week 7-Robinson, C..xlsx]Sheet3
Report Created: 8/14/2019 9:54:27 PM
Objective
Cell Name Value
$B$7 TOTAL PROFIT QUANTITY 651221
Variable Lower Objective Upper Objective
Cell Name Value Limit Result Limit Result
$B$2 S QUANTITY 16157 14000 607000 16157 651221
$B$3 M QUANTITY 6200 6200 651221 6200 651221
$B$4 L QUANTITY 2600 2600 651221 2600 651221