How are general integrality requirements indicated in the Excel Risk Solver Platform (RSP)?
A)Specifying the INT option for the appropriate changing cells.
B)Specifying the INT option for the constraint rows.
C)Adding additional RHS values to constraints.
D)Choosing the BIN setting in the Value field in the Solver Parameters dialog box.

Question

Quizplus · Accepted Answer

Specifying the INT option for the appropriate changing cells indicates that the variables are restricted to integer values, which satisfies the general integrality requirement. This is done by selecting the changing cell(s), going to the Solver Parameters dialog box, and choosing the GRG Nonlinear solver with the "Assume Non-Negative" and "Integer" options selected for the variables. Option B is incorrect because it applies the integrality requirement to the constraint rows instead of the variables. Option C is also incorrect because adding additional RHS values does not necessarily enforce integer solutions. Option D is specific to binary variables, not general integer variables.

How Are General Integrality Requirements Indicated in the Excel Risk