Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

http://www.chegg.com/homework-help/questions-and-answers/classic-furniture-compa

ID: 460787 • Letter: H

Question

http://www.chegg.com/homework-help/questions-and-answers/classic-furniture-company-trying-determine-optimal-quantites-make-six-possible-products-ta-q4380462 Classic Furniture company sensitivity report Adjustable cells name Final value Reduced cost Objective coefficient Allowable increase Allowable de # of units oak tables 3 0 75 0 1E+30 # of units oak chairs 51.67 0 35 1E+30 0 # of units cherry tables 3 0 90 0 1E+30 # of units cherry chairs 85.56 0 60 1E+30 0 # of units Pine tables 42.26 0 45 88.33 0 # of units pine chairs 33.08 0 20 0 13.25 Constraints name Final value Shadow price Constraint R.H. side Allowable increase Allowable de Labor hours 1000 10 1000 373.30 37.21 Oak (pounds) 2150 0 2150 318.93 1250 Cherry (pounds) 3800 0 3800 223.25 2239.78 Pine (pounds) 8500 0 8500 1488.33 5039.5 Min oak tables 3 0 3 6.25 2.35 Min cherry tables 3 0 3 11.33 1.2 Min oak chairs 51.67 0 10 41.67 1E+30 Min cherry chairs 85.56 0 10 75.56 1E+30 Min pine chairs 33.08 0 5 28.08 1E+30

Explanation / Answer

A) Profit is $10000

Production Plan

Oak tables=3

Oak Chairs=51.67=52

Cherry Table=3

Cherry Chairs=85.56=86

Pine Table=42.26=42

Pine Chair=33.08=33

b) All the constraints Labor hour,Oak(pounds),cherry(pounds),Pine(pounds) are binding

c)

d) 318.93

e)

F) None