Solver Engine Engine Simplex LP Solution Time 0032 Seconds Iterations 2

# Solver engine engine simplex lp solution time 0032

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

Solver EngineEngine: Simplex LPSolution Time: 0.032 Seconds.Iterations: 2 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic ScalingMax Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegativeObjective Cell (Max)CellNameOriginal ValueFinal Value\$E\$24Profit Contribution Total Profit\$ 651,218.50 \$ 651,221.43 Variable CellsCellNameOriginal ValueFinal ValueInteger\$B\$22Number Produced Small16157 16157.1428571 Contin\$C\$22Number Produced Medium62006200 Contin\$D\$22Number Produced Large26002600 ContinConstraintsCellNameCell ValueFormulaStatusSlack\$E\$18Bending/forming Minutes Used12882.8571429 \$E\$18<=\$E\$9Not Binding10517.142857\$E\$19Welding Minutes Used19014.2857143 \$E\$19<=\$E\$10Not Binding4385.7142857\$E\$20Painting Minutes Used46800 \$E\$20<=\$E\$11 Binding0\$B\$22Number Produced Small16157.1428571 \$B\$22<=\$B\$6Not Binding4842.8571429\$B\$22Number Produced Small16157.1428571 \$B\$22>=\$B\$5Not Binding2157.1428571\$C\$22Number Produced Medium6200 \$C\$22<=\$C\$6Not Binding6300\$C\$22Number Produced Medium6200 \$C\$22>=\$C\$5Binding0\$D\$22Number Produced Large2600 \$D\$22<=\$D\$6Not Binding1600\$D\$22Number Produced Large2600 \$D\$22>=\$D\$5Binding0
Microsoft Excel 14.0 Sensitivity ReportWorksheet: [AntesE-BUSN625-Week7.xlsx]Klein IndustriesReport Created: 7/20/2017 4:17:26 PMVariable CellsFinalReducedObjectiveAllowableCellNameValueCostCoefficientIncrease\$B\$22Number Produced Small16157.142857020.5 1.00000E+030\$C\$22Number Produced Medium6200034 4.0714285714\$D\$22Number Produced Large2600042 3.3928571429ConstraintsFinalShadowConstraintAllowableCellNameValuePriceR.H. SideIncrease\$B\$26Auxillary Variable Small16157.142857021000 1.00000E+030\$B\$26Auxillary Variable Small16157.142857014000 2157.1428571\$C\$26Auxillary Variable Medium6200012500 1.00000E+030\$C\$26

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

Want to read all 12 pages?

• Fall '13
• Gerald