1. XYZ Computer Company wants to manufacture two models of computers, Standard and Turbo. The owner wants to know how many to produce in the follow month to maximize his profit. Manufacturing these computers requires wiring, assembly and inspection time. Each computer produces a certain level of profit and has a limited demand. Also, there is a limited number of hours available for wiring, assembly and inspection; the data for this problem is summarized below.

	A	B	C	D	E
1	Computer Model	Standard	Turbo
2		X1	X2
3	Profit ($)	30	40
4	Max Demand	80	90
5
6	Required Hours				Maximum Available Hours
7
8	Wiring	0.4	0.5		50
9	Assembly	0.5	0.4		50
10	Inspection	0.2	0.3		22

	A	B	C	D	E
1		X1	X2
2			XYZ Corp
3
4		Standard	Turbo		Total Profit
5
6	Unit to Produce	0	0
7	Unit Profit	30	40		(A)
8
9				Used	Available
10	Production Hours
11	Wiring	0.4	0.5	(B)	50
12	Assembly	0.5	0.4	(C)	50
13	Inspection	0.2	0.3	(D)	22
14
15	Available Demand	80	90

1. For the above, formulate the (LP) Model
2. Which cell(s) are the Set or Answer Cell(s)
3. Which cell(s) are the Changing or Variable Cell(s)
4. Which cell(s) are the constraint Cell(s)
5. For each of the letters in the spreadsheet above, indicate the formula that should appear in that cell.