OPERATIONS RESEARCH
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 80 12 Fancy Demand 1 90 ____ 14. Refer to Scenario 3-2. What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit? a. =B4*C4+B5*C5 b. =SUMPRODUCT(B4:C4,B5:C5) c. =SUM(B5:C5) d. =SUM(E8:E10) ____ 15. Refer to Scenario 3-2. Which cells should be changing cells in this problem? a. B4:C4 b. E5 c. D8:D10 d. E8:E10
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 80 12 Fancy Demand 1 90 ____ 14. Refer to Scenario 3-2. What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit? a. =B4*C4+B5*C5 b. =SUMPRODUCT(B4:C4,B5:C5) c. =SUM(B5:C5) d. =SUM(E8:E10) ____ 15. Refer to Scenario 3-2. Which cells should be changing cells in this problem? a. B4:C4 b. E5 c. D8:D10 d. E8:E10
0 comments:
Post a Comment