Which cells should be changing cells in this problem? a. B4:C4 b. E5 c. D8:D10 d. E8:E10 Which cells should be the constraint cells in this problem? a. B4:C4 b. E5 c. D8:D10 d. E8:E10 Which of the following statements represents the carpentry, varnishing and limited demand for desks constraints? a. B4:C4B5:C5 b. E50 C. D8:D10E8:E10 d. E8:E10D8:D10 Essential Supplies, Inc. produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hours 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=Numberofdeskstoproduce The LP model for the problem is as follows: MAX: 301+402 Subject to: 61+4236 41+8240X28X1,X20 Suppose we lay out the problem in Excel as follow: What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit? A. =B4B5+C4C5 B. = SUMPRODUCT(B8:C8,\$B \$4:\$C\$4) C. =SUM(B5:C5) D. =SUM(E8:E10) What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the amount of carpentry used? A. =B4B5+C4C5 B. =SUMPRODUCT(B8:C8,$B$4:$C$4) C. =SUM(B5:C5) D. =SUM(B8:C8)