Byte Computer Company. This question involves five (5) parts; each part counts as one point.

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 Model	Unit Profit	Maximum Demand	Wiring Hours Required Per Unit	Assembly Hours Required Per Unit	Inspection Hours Required Per Unit
Plain	$30	80	0.4	0.5	0.2
Fancy	$40	90	0.5	0.4	0.3
		Hours Available	50	50	22

LP Formulation

Let X1 = Number of Plain to produce

X2 = Number of Fancy to produce

Maximize: 30 X1 + 40 X2

Subject to: 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

Partial Spreadsheet

	A	B	C	D	E
1		Byte Computer Company
2
3		Plain	Fancy
4	Number to Make				Total Profit
5	Unit Profit	$30	$40
6
7	Constraints			Used	Available
8	Wiring	0.4	0.5		50
9	Assembly	0.5	0.4		50
10	Inspection	0.2	0.3		22
11	Plain Demand	1	0		80
12	Fancy Demand	0	1		90

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

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

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

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

D.=SUM(B5:C5)

E.None of the above.

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

A.=B8*B4+C8*C4

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

C.=SUMPRODUCT(B8:C8)

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

E. None of the above.

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

A. B4*B5+C4*C5

B. B4:C4

C. D8:D12

D.E5

E.None of the above.

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

A. B4:C4

B. E8:E12

C.E5

D.D8:D12

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. B9+C9 E9

B. D9 E9

C. D8:D10 E8:E10

D. B9:C9 E9

E. None of the above.