Exam 9: Enhancing Decision Making with Solver

A ____ status indicates that a constraint has a final value that is equal to the value of the constraint.

When you use ____, you are limited to entering values in a single cell to reach a goal in another related cell.

Range names are usually the source of the problem when Solver cannot find a feasible solution.

The combination of the objective cell, variable cells, and constraints that are used to solve a problem is called a(n) ____________________ model.

A(n) output function is a mathematical formula that relates the decision variables or variable cells to the desired outcome. _________________________

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(n) Goal model. _________________________

____________________ are the boundaries that define the feasible solution area.

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

The method you use to narrow the available options for a problem so you can choose the best potential outcome is an analytical process known as ____ in the field of management science.

Identify the letter of the choice that best matches the items in the Solver answer report above. -The constraint has a final value that is equal to the value of the constraint A)#1 B)#2 C)#3 D)#4 E)#5 F)#6

To start Solver, Beth clicks the Solver button in the ____________________ group on the DATA tab on the ribbon.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Results when a decision variable is multiplied by a constant, such as price

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.

By default, Solver attempts to solve a problem ____ times before it stops working and determines that there is no feasible solution.

Solver changes the values in the variable cells to maximize, minimize, or set the objective cell to a specific value. _________________________

When troubleshooting, one of the best options is to save the worksheet and the Solver model in a blank section of the worksheet.

Identify the letter of the choice that best matches the items in the Solver answer report above. -Contains the cell reference, name, cell value, and formula for cells that have constraints A)#1 B)#2 C)#3 D)#4 E)#5 F)#6

You must answer four questions before using optimization to solve a problem. They do NOT include ____.

The cells in a worksheet usually display combinations of text or numbers; the math that generates the answers is hidden.