0 Sensitivity Report Worksheet Report Created 9152016

0 sensitivity report worksheet report created 9152016

This preview shows page 3 - 8 out of 16 pages.

Worksheet: [Assn7_MartinD.xlsx]Sheet1Report Created: 9/15/2016 3:25:07 PMVariable CellsFinalReducedObjectiveAllowableCellNameValueCostCoefficientIncrease$B$17Optimal Production Levels Small16157.142857020.5 1.00000E+030$C$17Optimal Production Levels Medium6200 -4.071428571434 4.0714285714$D$17Optimal Production Levels Large2600 -3.392857142842 3.3928571428ConstraintsFinalShadowConstraintAllowableCellNameValuePriceR.H. SideIncrease$E$12Bending/forming Available Time2340000 10517.142857$E$13Welding Available Time2340000 4385.7142857$E$14Painting Available Time46800 -14.64285714303020
Background image
AllowableDecrease1.53225806451.00000E+0301.00000E+030AllowableDecrease1.00000E+0301.00000E+0306780
Background image
Microsoft Excel 16.0 Limits ReportWorksheet: [Assn7_MartinD.xlsx]Sheet1Report Created: 9/15/2016 3:25:07 PMObjectiveCellNameValue$B$21Final Profit Small$ 651,221.43 VariableLowerObjectiveUpperCellNameValueLimitResultLimit$B$17Optimal Production Levels Small16157.1428571400060700016157.142857$C$17Optimal Production Levels Medium62006200651221.436200$D$17Optimal Production Levels Large26002600651221.432600
Background image
ObjectiveResult651221.43651221.43651221.43
Background image
Klein Industries portable air compressorsSmallMediumLargeUnit Profit$ 20.50 $ 34.00 $ 42.00 Monthly SalesMinimum14,0006,2002,600Maximum21,00012,5004,200Available TimeBending/forming0.40.70.823,400Welding0.611.223,400Painting1.42.63.146,800Total Time in Minutes2.44.35.1Optimal Production Levels16157.1428571462002600Profit per production time unit$ 8.54 $ 7.91 $ 8.24 Note: Because the profit is highestFinal Profit$ 651,221.43
Background image
Image of page 8

You've reached the end of your free preview.

Want to read all 16 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture