Computer Model Profit per Model ($) Maximum demand for product Wiring Hours Requ

Question

Computer Model Profit per Model ($) Maximum demand for product Wiring Hours Required Assembly Hours Required Inspection Hours Required Plain 30 80 .4 .5 .2 Fancy 40 90 .5 .4 .3 Hours Available 50 50 22 Let X1 = Number of Plain to produce X2 = Number of Fancy to produce MAX: 30 X1 + 40 X2 Subject to: .4 X1 + .5 X2 ? 50 (wiring hours) .5 X1 + .4 X2 ? 50 (assembly hours) .2 X1 + .2 X2 ? 22 (inspection hours) X1 ? 80 (Plain computers demand) X2 ? 90 (Fancy computers demand) X1, X2 ? 0 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 ____ 16. Refer to Scenario 3-2. Which cells should be the constraint cells in this problem? a. B4:C4 b. E5 c. D8:D12 d. E8:E12

Explanation / Answer

14. c. =SUM(B5:C5) 15. d. E8:E10 16. a. B4:C4

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.