question archive Jones Furniture Company produces beds and desks for college students

Jones Furniture Company produces beds and desks for college students

Subject:FinancePrice:2.87 Bought7

Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced.

1) Suppose the company can purchase more varnishing time for $3.00, should it be purchased and how much can be bought before the value of the additional time is uncertian? Base your response on the following Analytic Solver Platform sensitivity ouput

Let

X1 = Number of Beds to produce

 

X2 = Number of Desks to produce

The LP model for the problem is

MAX:

30 X1 + 40 X2

Subject to:

6 X1 + 4 X2 <= 36 (carpentry)

 

4 X1 + 8 X2 <= 40 (varnishing)

 

X2 <= 8 (demand for desks)

Changing cells            
               
  cell Name Final vale Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease
  $B$4 Number to make Beds 4 0 30 30 10
  $C$4 Number to make desk 3 0 40 20 20
               
Constraints            
  Cell Name Final Value Shadow proce Constraint R.H. Side Allowable increase Allowable decrease
  $D$8 Carpentry Used 36 2.5 36 24 16
  $D$9 Varnishing Used 40 3.75 40 26.67 16
  $D$10 Desk demand Used 3 0 8 1.00E+30 5

Option 1

Low Cost Option
Download this past answer in few clicks

2.87 USD

PURCHASE SOLUTION

Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 7 times

Completion Status 100%