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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!