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 varishing. 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 S30 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: 30 X1 +40 X2 Subject to: 6X1 + 4 X2 S 36 (carpentry) 4 X1 + 8 X2540 (varnishin g) X258 (demand for desks) X1, X2 0 A D B C Jones Furniture 1 2 3 Bed Desks Total Profil 4 Numberto make sunt profit 6 10 40 d 6 4 4 9 Vanishing 10 Desk demand 16 20 * 1 E5 in the accompanying Excel spreadsheet to compute total profit? a. =B4 B5+C4*C5 b. =SUMPRODUCT(B8:C8,$B$4:$CS4) c. SUM(BS:C5) d. =SUM(E8:E10) 12 Refer to Exhibit 3.1. 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:$CS4) c. SUM(B5:C5) d. SUM(E8E10) 13. Refer to Exhibit 3.1. Which cells should be changing cells in this problem? B4:04 E5 D8:010 4.E8:E10 Refer to Exhibit 3.1. Which cells should be the constraint cells in this problem? B4:04 E5 DE:DIO d.E8:E10 1s. What is the significance of an absolute cell reference in Excel? . The cell reference will not change if the formula containing the reference is copied to another location 6. The cell will always contain the absolute value of any number entered into it The cell reference changes if the formula containing the reference is copied to another location a. It is the only formula used to refer to a cell on another spreadsheet 16. In the Analytic Solver Platform dialog box simple upper and lower bounds for decision variables are specified by - referring directly to the decision variable cells in the Constraints-Bound area. 6. requiring the addition of the bounds above and below the variable cells. resolving the problem with the bounds added. a incorporating the bounds in the objective function. 18. Which tab in the Analytic Solver Platform task pane is used to define an optimization problem? a. Guess b. Model c. Change d. Delete 19. Models which are setup in an intuitively appealing, logical layout tend to be the most a. Reliable b. Modifiable c. Auditable d. Organized 20. Scaling problems a. can cause Analytic Solver Platform to consider a linear problem as nonlinear. b. can cause problems in accuracy of solutions returned. c. are caused by small numbers and large numbers used in the same problem. d. all of these