PLEASE SHOW CLEAR WORK AND SELECT FROM THE MULTIPLE CHOICE OPTIONS GIVEN

1) What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit?

a) =SUMPRODUCT(B4:C4,B5:C5)

b) =SUM(B5:C5)

c) =B4*C4+B5*C5

d) =SUM(E8:E10)

2) What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the amount of wiring used?

a) =B4*B5+C4*C5

b) =SUM(B5:C5)

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

d) =SUM(E8:E10)

3) Which cells should be changing cells in this problem?

a) E8:E10

b) E5

c) D8:D10

d) B4:C4

4) Which cells should be the constraint cells in this problem?

a) E8:E12

b) B4:C4

c) E5

d) D8:D12

5) Which of the following statements will represent the constraint for just assembly hours?

a) E8:E10 D8:D10

b) D8:D10 E8:E10

c) D9 E9

d) B4:C4 B5:C5

The Rammstein Tech company produces two models of computers, Basic and Elite. 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. Computer Model Basic Elite Profit per Model ($) 30 40 Maximum demand for Wiring Hours product Required 80 .4 90 .5 Hours Available 50 Assembly Hours Required 5 4 Inspection Hours Required .2 3 22 50 Let MAX: Subject to: X1 = Number of Basic computers to produce X2 = Number of Elite computers to produce 30 X1 +40 X2 .4 X1 +.5 X2 5 50 (wiring hours) .5 X1 +.4 X2 5 50 (assembly hours) .2 X1 + 2 X2 s 22 (inspection hours) X1 580 (Basic computers demand) X2 s 90 (Elite computers demand) X1, X220 A A D E B C Rammstein Tech Company 1 2 3 Basic Elite Total Profit: 30 40 Number to 4 4 make: 5 Unit profit: 6 6 7 7 Constraints: 8 Wiring Used Available 50 0.4 0.5