(18)

THE INFORMATION PROVIDED BELOW IS ALL THAT I HAVE

I DO NO HAVE A EXCEL SHEET THAT THIS QUESTION PROVIDES

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. Let X1 = Number of Beds to produce X2 = Number of Desks to produce The LP model for the problem is MAX: Subject to: 30 X1 +40 X2 6 X1 +4 X2 36 (carpentry) 4 X1 +8 X2 s 40 (varnishing) X2 5 8 (demand for desks) X1, X220 A B D F Jones Furniture 2 3 Beds Desks 4 Total Profit: Number to make: Unit profit: 5 30 40 6 Used 6 4 Constraints: 8 Carpentry 9 Varnishing 10 Desk demand Available 36 40 4 8 8 Refer to Exhibit 3.1. Which of the following statements represent the carpentry, varnishing and limited demand for desks constraints? a. B4:C4 s B5:C5 ob. E8:E10 s D8:D10 O c. D8:D10 s E8:E10 O d. E5 s 0