Exam 9: Enhancing Decision Making with Solver

As Solver inserts values into the variable cells, it also examines the attributes to ensure that the solution satisfies them. _________________________

The _______________ function sums a series of products in ranges of identical sizes, called arrays, that are parallel to each other in a worksheet.

The ____________________ function sums a series of products in ranges of identical sizes, called arrays, which are parallel to each other in a worksheet.

Case 9-1 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?

If you keep the Solver solution, the original values are lost and you cannot recover them unless you previously ____.

Any Solver solution requires a well-organized spreadsheet that links the variable cells with the ____, and links the known facts about the problem with the objective cell.

Case 9-1 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 then needs to specify whether Solver should maximize, minimize, or set the objective cell to a certain value. She would choose the ____ option button.

The model you create when using Solver is ____.

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

An example of a(n) nonlinear function is the relationship between the price of an item and the demand for that item. _________________________

Sometimes, you might need to save several Solver models in a worksheet to track your progress in solving a specific problem. Without ____, it might be difficult to determine which saved Solver model appears in the different ranges.

With Solver, you can change the values of up to 500 cells at one time to reach a goal in the objective cell.

When a constraint is binding in a Solver answer report, the first column is set to 0 because the constraint equals the final value. _________________________

A(n) ____________________ saves the result of a Solver model so that you can load it later.

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

Any Solver solution requires a well-organized spreadsheet that links the variable cells with the objective cell and the known facts about the problem with the objective cell.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -When you cannot describe a function in linear terms

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 binding status indicates that the constraint does not have 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.