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 | |
Purchase A New Answer
Custom new solution created by our subject matter experts
GET A QUOTE
Answer Preview
please use this google drive link to download the answer file.
https://drive.google.com/file/d/1zy44fJkgziVSBjIUyQsj_I3P1vZP_flN/view?usp=sharing
note: if you have any trouble in viewing/downloading the answer from the given link, please use this below guide to understand the whole process.
https://helpinhomework.org/blog/how-to-obtain-answer-through-google-drive-link
