Auxillary Variable Medium6200 -4.07142857146200 1161.5384615$D$26Auxillary Variable Large260004200 1.00000E+030$D$26Auxillary Variable Large2600 -3.39285714292600 974.19354839$E$18Bending/forming Minutes Used12882.857143023400 1.00000E+030$E$19Welding Minutes Used19014.285714023400 1.00000E+030$E$20Painting Minutes Used46800 14.642857143468006780
AllowableDecrease1.53225806451.00000E+0301.00000E+030AllowableDecrease4842.85714291.00000E+03063002607.692307716002187.096774210517.1428574385.71428573020
Microsoft Excel 14.0 Sensitivity ReportWorksheet: [AntesE-BUSN625-Week7.xlsx]Klein IndustriesReport Created: 7/20/2017 4:22:43 PMVariable CellsFinalReducedObjectiveAllowableCellNameValueCostCoefficientIncrease$B$22Number Produced Small16157.142857020.5 1.00000E+030$C$22Number Produced Medium6200 -4.071428571434 4.0714285714$D$22Number Produced Large2600 -3.392857142942 3.3928571429ConstraintsFinalShadowConstraintAllowableCellNameValuePriceR.H. SideIncrease$E$18Bending/forming Minutes Used12882.857143023400 1.00000E+030$E$19Welding Minutes Used19014.285714023400 1.00000E+030$E$20Painting Minutes Used46800 14.642857143468006780
AllowableDecrease1.53225806451.00000E+0301.00000E+030AllowableDecrease10517.1428574385.71428573020
Microsoft Excel 14.0 Limits ReportWorksheet: [AntesE-BUSN625-Week7.xlsx]Klein IndustriesReport Created: 7/20/2017 4:17:26 PMObjectiveCellNameValue$E$24Profit Contribution Total Profit$ 651,221.43 VariableLowerObjectiveUpperCellNameValueLimitResultLimit$B$22Number Produced Small16157.1428571400060700016157.142857$C$22Number Produced Medium62006200651221.436200$D$22Number Produced Large26002600651221.432600
ObjectiveResult651221.43651221.43651221.43
Microsoft Excel 14.0 Limits ReportWorksheet: [AntesE-BUSN625-Week7.xlsx]Klein IndustriesReport Created: 7/20/2017 4:22:44 PMObjectiveCellNameValue$E$24Profit Contribution Total Profit$ 651,221.43 VariableLowerObjectiveUpperCellNameValueLimitResultLimit$B$22Number Produced Small16157.1428571400060700016157.142857$C$22Number Produced Medium62006200651221.436200$D$22Number Produced Large26002600651221.432600
ObjectiveResult651221.43651221.43651221.43
You've reached the end of your free preview.
Want to read all 12 pages?
- Fall '13
- Gerald
- Decision Making, Sales
