Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Furniture City (FC) company makes 3 kinds of couches: (1) Standard, (2) Deluxe, and (3) Luxury styles. Each couch goes through 3 production departments:
The Furniture City (FC) company makes 3 kinds of couches: (1) Standard, (2) Deluxe, and (3) Luxury styles. Each couch goes through 3 production departments: (1) Cutting and Coloring. (2) Assembly, and (3) Finishing. The total number of hours available each month in each of the above departments is 800, 400 and 500, respectively. The time (in hours) required by 3 departments for making each couch and the profit per couch are listed below. The company has a contract of supplying at least a total of 200 Standard and Deluxe couches per month. Cutting and Couch Coloring (hrs) Assembly(hrs) Finishing(hrs) Profit ($) Standard 1.4 0.6 1.0 160 Deluxe Luxury 1.8 0.8 1.2 190 2.5 0.7 1.5 250 The company would like to make a production plan to maximize its total profit. Define S. D. L as the variables for the numbers of Standard, Deluxe and Luxury couches produced by the company. Then the corresponding LP model is built as follows: Max 160 S +190 D + 250 L Subject to: 1.45+1.8 D 2.5L 800 0.65+0.8 D+0.7L 400 1.05 1.2D 1.5 L 500 S+D 200 (Cutting and Coloring) (Assembly) (Finishing) (contract supply) All variables are non-negative. When the above LP model is solved with Excel, we see the following Sensitivity Report. Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 S 200 0 160 6.67 3.33 $C$11 D -3.33 190 3.33 1E+30 $D$11 L 200 0 250 1E+30 10 Constraints Final: Shadow Constraint Allowable Allowable Cell Name Value Price: R.H. Side Increase Decrease $B$16 Cutting and Coloring 780 0 800 1E+30 20 $B$17 Assembly 260 0 400 1E+30 140 SRS18 Finishing 500 166.67 500 12 300 $B$19 Contract Supply 200 -6.67 200 300 75 75 At which of the following price point(s) would FC consider producing Deluxe couches? 1. $192 II. $194 III. $196 O None of these prices Ollor ill OL or Ill Olil only If the supply contract calls for a minimum of 400 total Standard and Deluxe coaches to be made, what would happen to the optimal solution and the optimal profit? O Optimal solution would change and optimal profit would increase. O Optimal solution would remain the same but optimal profit would decrease. O Both optimal solution and optimal profit would remain the same. O Optimal solution would change but optimal profit would remain the same. O Optimal solution would change and optimal profit would decrease. Suppose Sabre, a heavy machinery manufacturer, offers to lease a new finishing machine to FC for 20 additional hours per month. Which lease price(s) below require(s) FC to re-solve the problem to make this decision instead of relying on the sensitivity report alone? I. $1,500 II. $2,500 III. $3,500 CO Only II Only! OI and II O II and III O 1, II, and
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started