Question 1 to Question 4 is based on this problem and accompanying Excel spreadsheet: Byte Computer Company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize profits. Producing these computers requires wiring, assembly, and inspection time. Each computer produces a certain level of profits but faces only a limited demand. There are also a limited number of wiring, assembly, and inspection hours available in each month. The data for this problem are summarized in the following table: The formulation is as follows: Let X1 - Number of plain computers to produce X2=Numberoffancycomputerstoproduce MAX: 301+402 Subject to: 0.41+0.5250 0.51+0.42500.21+0.2222X180X290X1,20 Suppose we lay out the problem in Excel as follows: What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the amount of wiring used? A. =B4xB5+C4xC5 B. =SUMPRODUCT(B8:C8,\$B\$4-\$C\$4) c. =SUM(B5:C5) D. =SUM(E8:E10)