The following Excel Solver Results show capital projects selected for investment. When constructing the Solver parameters, the "subject to the constraints" need to be set. What two constraints are required?{MISSING IMAGE} A) $G$8 AND B10:E10 = binary B) B8:E8 = binary AND F2:F5 I2:I5 D) B10:E10 = binary AND F2:F5

Question

The following Excel Solver Results show capital projects selected for investment. When constructing the Solver parameters, the "subject to the constraints" need to be set. What two constraints are required?{MISSING IMAGE}
A) $G$8 AND B10:E10 = binary
B) B8:E8 = binary AND F2:F5 <= I2:I5
C) B10:E10 = binary AND F2:F5 => I2:I5
D) B10:E10 = binary AND F2:F5 <= I2:I5

Quizplus · Accepted Answer

The constraints are:1. B10:E10 = binary: This ensures that each project is either selected or not selected.2. F2:F5 <= I2:I5: This ensures that the total investment does not exceed the available budget.

The Following Excel Solver Results Show Capital Projects Selected for Investment