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+30Explanation / 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
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.