Consider the Classic Furniture product mix problem (Problem 4-28). For each of the following situations, (a) The

Consider the Classic Furniture product mix problem (Problem 4-28). For each of the following situations,€ƒ

(a) The number of labor hours expands to 1,320.
(b) The amount of cherry wood increases to 3,900.
(c) The number of labor hours decreases to 950.
(d) The company does not have a minimum requirement for cherry chairs.

Transcribed Image Text:

HIII Classic Furniture Company Oak Oak Cherry CherryPine Pine ables chairs tables chairs tables chairs 4 Number of units 3.00 51.67 3.00 85.66 4226 33.08 5 Profit 5 Constraints 7 Labor hours 35 90 60 $46 6.0 4.6 2.0 36 75 20 $10,00000 1000.00;-1.0 2160.001 < 2,1 3800.09! < 3.8 SSOO.DOi<8,6 3.00 ! > 7.5 3.6 9.0 3 O-ak(pounds) 200 30 9 Cherrv (pounds) 10 Pine pound 11 Min oak tables 12 Min cherrytables 13 Min oak chairs 14 Min cherrychairs 16 Min pine chairs 16 240 180 27 3.00 86.56i 10 LHS Sian I RH 61.6711 Variable Cells Cell SBS4 Number of units Oak tables SC$4 Number of units Oak chairs Final Roduced bjective Allowablo Allowablo Value Cost Coefficient Increase Decrease 1E+30 Name 3.00 0.00 0.00 0.00 0.00 0.00 75.00 0.00 35.001E+30 0.00 1E+30 45.0066.33 51.67 SDS4 Number of units Cherny tables3 SES4 Number of units Cherry chairs 85.56 SFS4 Number of units Pine tables $G54 Number of units Pine chairs 1E+30 0.00 0.00 3.00 90.00 60.00 33.08 0.00 20.00 0.0013.25 Final Shadow Constraint Allowable Allowable 42.26 Constraints Cell Value Price R.H. Side Increase Decrease SH57 Labor hours SH5 Oak (pounds) SHS9 Cherry (pounda) SHS10 Pine (pounds) SH$11 Min oak tables SHS12 Min cherry tables SHS13 Min oak chairs SH514 Min cherry chairs 5H515 Min pine chairs 37.21 000.00 10.001000.00 373.30 2150.00 3800.00 8500.00 0.00 2150.00318.931250.00 0.00 3800.00 223.25 2239.78 0.00 8500.00 1488.33 5039. 50 0.00 0.00 0.00 0.00 0.00 3.00 3.00 51.67 85.56 33.08 3.00 3.00 10.00 10.00 5.00 6.25 11.33 41.67 75.56 28.08 2.35 1.20 1E+30 1E+30 1E+30