a) Value for cell A?

b) Cell B?

c)Cell C?

d)Cell D?

e)Cell E?

f) for the compnay to maintain its current production level, what is the highest price the compnay can charge for a desk

g)The company receives additional 50 KG of decorative metal for free. How would this affect the total revenue?

Based on the information in the table, you formulated the LP problem and solved it using Solver. The answer report and sensitivity report are shown below. In addition to the information shown, you remember that in the optimal solution the number of chairs was 72. Objective Cell (Max) Cell $E$31 Max Total Revenue Name Original Value Final Value Name Final Value Variable Cells Cell $E$22 Number of chair $F$22 Number of carbinets $G$22 Number of desks G Original Value 0 0 0 Integer Contin Contin Contin Cell Value Slack 3 Constraints Cell Name $E$26 Leather upholstery $E$27 Wood SE$28 Labor $E$29 Decorative metal $E $E$30 Chairs at least 20 units more than carbinets D D Formula Status $E$26c+$G$26 Not Binding $E$27$G$30 Binding 0 12 0 Variable Cells Final Value Reduced Cost Name Cell $E$22 Number of chair $F$22 Number of carbinets SG$22 Number of desks Objective Allowable Allowable Coefficient Increase Decrease 40 10 58.75 60 10 27.5 55 78.33333333 5 5 0 0 0 B 126 Constraints Final Value 700 Cell Name $E$26 Leather upholstery SE$27 Wood $E$28 Labor SE$29 Decorative metal SE$30 Chairs at least 20 units more than carbinets Shadow Price 0 2 23.5 0 -11 Constraint Allowable Allowable R.H. Side Increase Decrease 460 1E+30 3 700 60 15 500 2.608695652 130 450 1E+30 12 20 2.727272727 120 20