question archive 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 |
Purchased 7 times