Question: Consider the following linear program, which maximizes profit for two products--regular (R) and super (S): MAX 40R + 75S s.t. 1.6 R + 1.7 S
Consider the following linear program, which maximizes profit for two products--regular (R) and super (S):
MAX 40R + 75S
s.t.
1.6 R + 1.7 S 600 assembly (hours)
0.9 R + 0.4 S 300 paint (hours)
.18 R + 0.5 S 100 inspection (hours)
Sensitivity Report:
| Cell |
Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease |
| $B$7 | Regular = | ??? | 0.00 | 40 | 30.58 | 13 |
| $C$7 | Super = | ??? | 0.00 | 75 | 36.11 | 32.5 |
| Cell |
Name | Final Value | Shadow Price | Constraint R.H. Side | Allowable Increase | Allowable Decrease |
| $E$3 | Assembly (hr/unit) | 600 | 13.16 | 600 | 27.51 | 260 |
| $E$4 | Paint (hr/unit) | 278.94 | 0 | 300 | 1E+30 | 21.05 |
| $E$5 | Inspect (hr/unit) | 100.00 | 105.26 | 100 | 76.47 | 11.68 |
19) The optimal number of regular products to produce is ________, and the optimal number of super products to produce is ________, for total profits of ___________.
Answer:
20) If the company wanted to increase the available hours for one of their constraints (assembly, painting, or inspection) by two hours, they should increase ________.
Answer: ___________
21) The profit on the super product could increase by ________ without affecting the product mix.
Answer: ___________________
22) If downtime reduced the available capacity for inspecting by 40 hours (from 100 to 60 hours), profits would be reduced by ________.
Answer: _______________
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
