Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $A$3 V -1 29 1 1E+30 $B$3 5 380 0 32 40 1.666666667 $C$3 T 0 -8 72 8 $D$3 D 1060 0 54 10 1E+30 5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value SE$12 LHS 4700 Price R.H. Side Increase Decrease 2 4700 2800 950 $E$13 LHS 3940 4500 1E+30 560 SE$14 LHS 2500 24 2500 466.6666667 1325 1) For what range of profit contributions for DVD players the current solution will remain optimal? 2) What happens to profit if this value drops to $50 per DVD player? 3) Will the value of the objective function change if the supply of nonelectrical components changes? 4) What will happen if the supply of electrical components increases by 400? 5) What will happen if the supply of electrical components increases by 4000? 6) What if we could buy an additional 400 electrical components for $3 more than usual? Would we want to buy them? 7) What if we could get an additional 250 hours of assembly time by paying $5 per hour more than usual? Would this be profitable?