Original Value Final Value Integer B16D16 Constraints Cell Name Cell Value

Original value final value integer b16d16 constraints

This preview shows page 2 - 6 out of 6 pages.

Original ValueFinal ValueInteger$B$16:$D$16ConstraintsCellNameCell ValueFormulaStatus$E$12Bending/Forming Available Time23,400 $E$12>=$F$12Not Binding$E$13Welding Available Time23,400 $E$13>=$F$13Not Binding$E$14Painting Available Time46,800 $E$14>=$F$14Binding$B$16Production Small 16157.14 $B$16<=$B$9Not Binding$B$16Production Small 16157.14 $B$16>=$B$8Not Binding$C$16Production Medium6200.00 $C$16<=$C$9Not Binding$C$16Production Medium6200.00 $C$16>=$C$8Binding$D$16Production Large2600.00 $D$16<=$D$9Not Binding$D$16Production Large2600.00 $D$16>=$D$8Binding
Background image
Slack10,517 4,386 0 4842.85714292157.1463000.0016000.00
Background image
Microsoft Excel 14.0 Sensitivity ReportWorksheet: [519257 Klein Industries.xlsx]Sheet1Report Created: 12/21/2012 7:58:50 PMVariable CellsFinalReducedObjectiveAllowableCellNameValueCostCoefficientIncrease$B$16:$D$16ConstraintsFinalShadowConstraintAllowableCellNameValuePriceR.H. SideIncrease$E$12Bending/Forming Available Time2340000 10517.142857$E$13Welding Available Time2340000 4385.7142857$E$14Painting Available Time46800 -14.64285714303020
Background image
AllowableDecreaseAllowableDecrease1.00000E+0301.00000E+0306780
Background image
Microsoft Excel 14.0 Limits ReportWorksheet: [519257 Klein Industries.xlsx]Sheet1Report Created: 12/21/2012 7:59:00 PMObjectiveCellNameValue$E$5Unit profit Total Profit$651,221.43VariableLowerObjectiveUpperObjectiveCellNameValueLimitResultLimitResult$B$16:$D$16
Background image

You've reached the end of your free preview.

Want to read all 6 pages?

  • Fall '13
  • Gerald
  • Decision Making, Sales, Limit superior and limit inferior, total profit, Available Time

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture