Solver Engine Engine Simplex LP Solution Time 0062 Seconds Iterations 2

Solver engine engine simplex lp solution time 0062

This preview shows page 4 - 6 out of 12 pages.

Solver Engine Engine: Simplex LP Solution Time: 0.062 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $E$24 profit contribution Total Profit $ 651,218.50 $ 651,221.43 Variable Cells Cell Name Original Value Final Value Integer $B$22 number produced small 16157 16157.1428571 Contin $C$22 number produced medium 6200 6200 Contin $D$22 number produced large 2600 2600 Contin Constraints Cell Name Cell Value Formula Status Slack $E$18 bending/forming available time 12882.86 $E$18<=$E$9 Not Binding 10517.142857 $E$19 welding available time 19014.29 $E$19<=$E$10 Not Binding 4385.7142857 $E$20 painting available time 46800.00 $E$20<=$E$11 Binding 0 $B$22 number produced small 16157.1428571 $B$22<=$B$6 Not Binding 4842.8571429 $B$22 number produced small 16157.1428571 $B$22>=$B$5 Not Binding 2157.1428571 $C$22 number produced medium 6200 $C$22<=$C$6 Not Binding 6300 $C$22 number produced medium 6200 $C$22>=$C$5 Binding 0 $D$22 number produced large 2600 $D$22<=$D$6 Not Binding 1600 $D$22 number produced large 2600 $D$22>=$D$5 Binding 0
Image of page 4
Microsoft Excel 16.0 Sensitivity Report Worksheet: [Jesus Moreno.xlsx]Klein Industries Report Created: 2/23/2020 8:54:04 PM Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$22 number produced small 16157.142857 0 20.5 1E+030 $C$22 number produced medium 6200 0 34 4.0714285714 $D$22 number produced large 2600 0 42 3.3928571429 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $B$26 auxillary variable small 16157.142857 0 21000 1E+030 $B$26 auxillary variable small 16157.142857 0 14000 2157.1428571 $C$26 auxillary variable medium 6200 0 12500 1E+030 $C$26 auxillary variable medium 6200 -4.0714285714 6200 1161.5384615 $D$26
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 12 pages?

  • Fall '13
  • Gerald
  • English-language films, Klein Industries, 1E

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture