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(B5:C5)

C. =SUM(B4:C4)*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. =B8*B4+C8*C4

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

D. =SUMPRODUCT(B8:C8)

E. None of the above.

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

A. E5

B. B4:C4

C. B4*B5+C4*C5

D. D8:D12

E. None of the above.

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

A. B4:C4

B. D8:D12

C. E5

D. E8:E12

E. All of the above.

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

A. D9 E9

B. B9:C9 E9

C. B9+C9 E9

D. D8:D10 E8:E10

E. None of the above.

The 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 is summarized in the following table. The LP Formulation and a partial spreadsheet is also given. Shaded cells in the spreadsheet are to contain either numbers or formulas that calculate numbers, as appropriate. Problem Data Computer Unit Model Profit Plain Fancy $30 $40 Maximize: Subject to: Maximum Demand 80 90 Hours Available LP Formulation Let X1 = Number of Plain to produce X2 = Number of Fancy to produce Wiring Hours Required Per Unit 30 X1 + 40 X2 0.4 X1 +0.5 X2 50 (wiring hours) 0.5 X1 + 0.4 X2 50 (assembly hours) 0.2 X1 +0.2 X2 22 (inspection hours) X1 80 (Plain computers demand) X2 90 (Fancy computers demand) X1, X2 0 0.4 0.5 50 Assembly Hours Required Per Unit 0.5 0.4 50 Inspection Hours Required Per Unit 0.2 0.3 22 Partial Spreadsheet 1 A 2 3 4 5 6 7 8 Wiring 9 Assembly 10 Inspection 11 Plain Demand 12 Fancy Demand Number to Make Unit Profit Constraints B Byte Computer Company Plain $30 0.4 0.5 0.2 1 0 Fancy $40 0.5 0.4 0.3 0 1 D Used E Total Profit Available 50 sale 50 22 80 90