Exam 9: Enhancing Decision Making with Solver

In the Solver answer report, when the status is ____, the slack column indicates the difference between the final value and the constraint.

In Solver, if you select the Value Of option button, you also must enter a(n) ____.

A(n) ____________________ status indicates that the constraint has a final value that is equal to the value of the constraint.

A(n) ____ results when Solver cannot determine the combination of decision variables that satisfies all of the constraints.

When Solver produces an acceptable solution to the problem you identified, you can use the Keep Solver Solution option button in the ____________________ dialog box to permanently change the values in the worksheet to reflect the solution.

Constraints that are entered into the Add Constraint dialog box are stored in Solver and are only visible when you open the Solver Parameters dialog box; you can see only ____ constraint(s) at a time in this way.

The objective function or formula that you use in the objective cell can be ____.

Creating a(n) ____ table in a worksheet organizes the constraints and makes them visible in the worksheet at any time, and without the limitation of having to open the Solver Parameters dialog box and scroll the constraints to view them.

Large Solver models run noticeably slower when they include integer constraints because Solver uses a different solution method, called ____, when a model includes integer constraints.

When you plot a linear function in a chart, the result is a ____.

Goal Seek lets you change multiple cells.

You can use Solver to determine how to allocate ____, such as people, budgets, or inventories, in such a way as to achieve the greatest benefits.

When working with Solver, you maximize, minimize, or set the objective cell to a certain value by selecting the Max (maximum), Min (minimum), or ____ option button, respectively.

Saving a(n) ____________________ saves the Solver parameters that were used in the Solver model so you can load them later, if necessary.

____________________ are the boundaries that define the feasible solution area.

The default solving method in the Solver Parameters dialog box is GRG Nonlinear.

When using the Solver model, a value of FALSE indicates a satisfied constraint. _________________________

The combination of the objective cell, variable cells, and constraints that are used to solve a problem is called a ____.

The Cell Reference input box accepts ____.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Occurs in situations in which the feasible solution is unrestrained or unlimited on some dimension