Regular & Super Consider the following linear program, which maximizes profit for two products--regular (R)
and super (S):
MAX 50R + 75S
s. t.
1.2 R + 1.6 S ≤ 600 assembly (hours)
0.8 R + 0.5 S ≤ 300 paint (hours)
.16 R + 0.4 S ≤ 100 inspection (hours)
Name:
`Sensitivity Report:
Cell Name
Final
Value
Reduced
Cost
Objective
Coefficient
Allowable
Increase
Allowable
Decrease
$B$7 Regular = 291.67 0.00 50 70 20
$C$7 Super = 133.33 0.00 75 50 43.75
Cell Name
Final
Value
Shadow
Price
Constraint
R. H. Side
Allowable
Increase
Allowable
Decrease
$E$3 Assembly (hr/unit) 563.33 0.00 600 1E+30 36.67
$E$4 Paint (hr/unit) 300.00 33.33 300 39.29 175
$E$5 Inspect (hr/unit) 100.00 145.83 100 12.94 40
3-1) The optimal number of regular products to produce is , and the optimal number of
super products to produce is , for total profits of .
3-2) If the company wanted to increase the available hours for one of their constraints (assembly,
painting, or inspection) by two hours, they should increase .
3-3) The profit on the super product could increase by without affecting the product
mix.
3-4) If downtime reduced the available capacity for painting by 40 hours (from 300 to 260
hours), profits would be reduced by .
3-5) A change in the market has increased the profit on the super product by $5. Total profit will
increase by .