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

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

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 Accounting Questions!