Question: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $M$19 Decision Variable Tablet 16 0 80 70 20 $N$19 Decision
| Variable Cells | ||||||||
| Final | Reduced | Objective | Allowable | Allowable | ||||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | ||
| $M$19 | Decision Variable Tablet | 16 | 0 | 80 | 70 | 20 | ||
| $N$19 | Decision Variable Smart Phone | 10 | 0 | 120 | 40 | 56 | ||
| Constraints | ||||||||
| Final | Shadow | Constraint | Allowable | Allowable | ||||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | ||
| $O$16 | Inspection Contribution | 108 | 15.5555556 | 108 | 72 | 36 | ||
| $O$17 | Assembly Contribution | 120 | 6.66666667 | 120 | 60 | 48 |
1.The profit reduction $1920 means the resource reduction, what is the new available hours for this constraint? (original R.H.S. is (108,120), what is the new R.H.S?).
2. If I want the new profit after the resources reduction to be $1920, and still keep profit function 80X+120Y (X is Table, Y is Smart Phone) and I know the Tablet I will produce 0 units, what is the units of Smart Phone should be produced ?
3. Your answer $3600 to be valid and I want to keep the profit function 80X+120Y (X is Tablet and Y is Smart Phone), what is the new available hours for this constraint?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
