Exam 9: Enhancing Decision Making with Solver

After you load the Solver Add-in, the Solver command is available in the ____ group on the DATA tab.

Identify the letter of the choice that best matches the items in the Solver answer report above. -Includes the cell reference, name, original value, and final value of the variable cells in the worksheet A)#1 B)#2 C)#3 D)#4 E)#5 F)#6

It is a good idea to use ____________________ in the worksheet to identify which Solver model is stored in the different ranges of the worksheet.

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

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

An infeasible solution results when Solver cannot determine the combination of decision variables that satisfies all of the constraints. What are three ways you can troubleshoot this situation?

The Constraint input box can contain values, references to cells that contain those values, And ____.

Ava is setting up a production model for her jewelry-making business. She decides to use Solver to find the optimal number of topaz and onyx pendants to produce with the given constraints. One of the most important constraints is that the minimum number to produce is 100 of each. Please answer the questions below, referencing the above figure as needed. -Ava's production plan contains no nonlinear formulas or arrangement. What should she do to the solving method used by the Solver?

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

Solver lets you create a ____ model of a business scenario.

Solver inserts values in the ____ until the value of the objective cell has reached the specified goal.

Solver also lets you establish ____________________ that restrict the values that are entered into the variable cells.

Describe how to create a Solver model. Please include these key terms in your descriptions: Solver model, objective cell, variable cells, and constraints.

If all of the constraints, which represent the availability of resources, have ____ values, the solution isn't the optimal solution that maximizes the available resources.

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

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Results when Solver cannot determine the combination of decision variables that satisfies all of the constraints

The constraints that you add to the Solver Parameters dialog box are ____.

To change the number of times Solver attempts to solve a problem, click Options in the Solver Parameters dialog box, change the value in the ____ box, and then click the OK button.

After you load the Solver Add-in, the Solver command is available in the Data group on the DATA tab.

When you copy a worksheet that contains a Solver model, the Solver model is not saved with the new worksheet unless you save it as a model in a blank area of the worksheet and load the Solver model into the new worksheet.