Not Binding 43857142857 B12 PAINTING QUANTITY 46800 B12D12 Binding B14

Not binding 43857142857 b12 painting quantity 46800

This preview shows page 2 - 4 out of 4 pages.

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
Image of page 2
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
Image of page 3
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
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Fall '13
  • Gerald
  • Limit superior and limit inferior, Max Subproblems Unlimited

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture