Multiple Choice
Riker Co. is considering which of four different projects to undertake in order to maximize its net present value (NPV) . Define Xi as a binary (0-1) variable that equals 1 if project i is undertaken and 0 otherwise, for i = 1,2,3,4. The NPV and required capital (in millions) for each project are listed below.
Project Net Present Value Capital Required
1 60 7
2 50 10
3 40 6
4 20 3
Which of the following represents the constraint(s) stating that project 1 must be undertaken and at least one of the other projects must be undertaken?
A) X1 + X2 ≤ 1, and X1 + X3 ≤ 1, and X1 + X4 ≤ 1
B) X1 ≥ 1, and X2 + X3 + X4 ≥ 1
C) X1 + X2 ≥ 1, and X1 + X3 ≥ 1, and X1 + X4 ≥ 1
D) X1 ≥ 1, and X2 + X3 + X4 ≤ 3
E) X1 + X2 + X3 + X4 ≥ 2
Correct Answer:

Verified
Correct Answer:
Verified
Q6: In the "Solver Parameters" box of Excel
Q7: Excel's Solver Add-In solves _ problems.
Q8: The two primary Excel tools for diagnosing
Q9: Three reports are available when Solver has
Q10: What is the optimal solution to the
Q12: Describe what steps one should use if
Q13: With Excel Solver, the range for the
Q14: The _ for a constraint is the
Q15: George Dantzig developed the _ in 1947
Q16: What in Excel Solver corresponds to the