Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cima Official Learning System Financial Operations

Authors: Jo Watkins

6th Edition

1856177912, 978-1856177917

More Books

Students also viewed these Accounting questions

Question

Question What are the requirements for a SIMPLE 401(k) plan?

Answered: 1 week ago