Exhibit 3.1
The following questions are based on this problem and accompanying Excel windows.
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. The LP model for the problem is
-Refer to Exhibit 3.1. Which cells should be the constraint cells in this problem?
A) B4:C4
B) E5
C) D8:D10
D) E8:E10

Question

Exhibit 3.1
The following questions are based on this problem and accompanying Excel windows.
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.  The LP model for the problem is  
-Refer to Exhibit 3.1. Which cells should be the constraint cells in this problem?
A) B4:C4 
B) E5 
C) D8:D10 
D) E8:E10

Quizplus · Accepted Answer

The constraint cells in this problem are the cells that limit the amount of available carpentry and varnishing time for production. These are the cells D8:D10 and E8:E10, respectively. The values in these cells cannot exceed the available hours, which are 36 for carpentry and 40 for varnishing. Therefore, the correct answer is C. B4:C4 and E5 are not the constraint cells because they represent the profit per unit and the total profit, respectively, which do not limit the production process.

Exhibit 3.1 The Following Questions Are Based on This Problem and Accompanying