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
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

#### You've reached the end of your free preview.

Want to read all 12 pages?

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