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
Background image
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
Background image
Image of page 6

You've reached the end of your free preview.

Want to read all 12 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture