Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Environmental Responsibility Accounting And Corporate Finance In The EU

Authors: Panagiotis Dimitropoulos, Konstantinos Koronios

1st Edition

3030727726, 9783030727727

More Books

Students also viewed these Accounting questions