Solver engine engine simplex lp solution time 0062

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