Question: i need help i go not understand this Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Number of

i need help i go not understand this
Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Number of units Tables 320.00 0.00 7.00 3.00 325 $C$5 Number of units Chairs 360.00 0.00 5.00 4.33 150 Constraints Cell Name SDS8 Carpentry hours $D$9 Painting hours SDS10 Maximum chairs $D$11 Minimum tables Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 2400.00 0.60 2400.00 225.00 900.00 1000.00 2.60 1000.00 600.00 150.00 360.00 0.00 450.00 1E+30 90.00 320.00 0.00 100.00 220.00 1E+30 1) please understand which constraints are binding. 2) For the carpentry time, understand valid range (low and high) of the shadow price. 3) For the painting time, understand valid range (low and high) of the shadow price. 4) In the case of tables, find the range of profit contribution (low and high) with current production plan to remain optimal. 5) In the case of chairs, find the range of profit contribution (low and high) with current production plan to remain optimal. Focus inlich (nited States c. Accessibility: Investigate Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Number of units Tables 320.00 0.00 7.00 3.00 325 $C$5 Number of units Chairs 360.00 0.00 5.00 4.33 150 Constraints Cell Name SDS8 Carpentry hours $D$9 Painting hours SDS10 Maximum chairs $D$11 Minimum tables Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 2400.00 0.60 2400.00 225.00 900.00 1000.00 2.60 1000.00 600.00 150.00 360.00 0.00 450.00 1E+30 90.00 320.00 0.00 100.00 220.00 1E+30 1) please understand which constraints are binding. 2) For the carpentry time, understand valid range (low and high) of the shadow price. 3) For the painting time, understand valid range (low and high) of the shadow price. 4) In the case of tables, find the range of profit contribution (low and high) with current production plan to remain optimal. 5) In the case of chairs, find the range of profit contribution (low and high) with current production plan to remain optimal. Focus inlich (nited States c. Accessibility: Investigate
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
