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. 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 5 36 (carpentry) 4X4 +8X2 = 40 (varnishing) X2 5 8 (demand for desks) X1, X2 20 B D E 1 Jones Furniture 2 3 Beds Desks Total Profit: 4 Number to make: 5 Unit profit: 6 30 40 Used Available 6 4 36 7 Constraints: 8 Carpentry 9 Varnishing 10 Desk demand 4 8 40 1 8 Refer to Exhibit 3.1. What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit? O a. ESUM(E8:E10) O b. =SUMPRODUCT(B8:C8,$B$4:$C$4) O c. =SUM(B5:C5) O d. =B4*B5+C4*C5