Part (a). What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit?

A. =SUMPRODUCT(B4:B5,C4:C5)

B. =SUM(B4:C4)*SUM(B5:C5)

C. =SUM(B5:C5)

D.=SUMPRODUCT(B4:C4,B5:C5)

E. None of the above.

Part (b). What formula should be entered in cell D8 and copied down through D12?

A. =SUMPRODUCT(B8:C8,B$4:C$4)

B. =B$4*B5+B$4*C5

C. =SUMPRODUCT(B8:C8)

D. =B8*B4+C8*C4

E. None of the above.

Part (c). When specifying the problem to Solver, what should be entered as the Objective Cell?

A. D8:D12

B. B4:C4

C. B4*B5+C4*C5

D.E5

E. None of the above.

Part (d). When specifying the problem to Solver, which cells should be variable (changing) cells?

A.E8:E12

B. E5

C. D8:D12

D. B4:C4

E. All of the above.

Part (e) When specifying the problem to Solver, which of the following statements will represent the constraint for just inspection hours?

A.D10 E10

B.B10:C10 E10

C.D8:D12 E8:E12

D.B10+C10 E10

E.None of the above.

1. The Byte computer company produces two models of computers, A and B. 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 cach month. The data for this problem is summarized in the following table. Computer Assembly Hours Required Profit per Model (5) 30 40 Model Maximum demand for Wiring Hours product Required 80 5 Hours Available 50 Inspection Hours Required 2 .3 22 B D E B Byte Computer Company A B Total Profit: 2 3 4 Number to make 5 Unit profit: 6 7 Constraints: 8 Wiring 9 Assembly 10 Inspection 11 Plain Demand 12 Fancy Demand Used Available