Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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: InvestigateStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started