6428571 442214286 695442857 Allowable Allowable Increase Decrease Allowable

6428571 442214286 695442857 allowable allowable

This preview shows page 17 - 19 out of 19 pages.

3020 -14.6428571 -44221.4286695442.857AllowableAllowableIncreaseDecreaseAllowableAllowableIncreaseDecrease10517.142857 1.00000E+0304385.7142857 1.00000E+03030206780ve in the Sensitivity Report sincie it is pulling the profit down).ame, profit could increase up to 3,020 paint time units.profit will increase to $695,442.86 (please refer to E5 of Sheet2 (2)).
Background image
Portable Air CompressorSmallMediumLargeTotal ProfitUnit Profit$20.50 $34.00 $42.00 $695,442.86 Monthyl SalesSmallMediumLargeMinimum14,0006,2002,600Maximum21,00012,5004,200Production process (minutes)SmallMediumLargeAvailable TimeBending/forming0.40.70.823,400Welding0.611.223,400Painting1.42.63.149,820Total Production Time2.44.35.1Production18314.2962002600Checking pointsMinimumMaximumTotal Profit Total Profit = $20.50 small + $34.00 medium + $42.00 LargeProduction Constraints:14,000 <= small <= 21,0006,200 <= medium <= 12,5002,600 <= large <= 4,200Time Constraints:0.40 small + 0.70 medium + 0.80 large <= 23,4000.60 small + 1.00 medium + 1.20 large <= 23,4001.40 small + 2.60 medium + 3.10 large <= 46,800SmallMediumLargeUnit Profit$20.50 $34.00 $42.00 Production Time Per Unit2.44.35.1Profit Per Production Time$8.54 $7.91 $8.24
Background image
AllowableShadowIncreasePrice3020 -14.6428571 -44221.4286695442.857Time UsedRemaining Time (Available Time-Time Used)5.7142869,6548.5714293,091498200e
Background image

You've reached the end of your free preview.

Want to read all 19 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture