Exam 9: Enhancing Decision Making with Solver

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

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.

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.

It is more difficult to use Solver with linear functions than nonlinear functions.

Rick has created the chart above outlining the information he has on producing toy trains. He will create a two-dimensional chart to visualize the information. Please refer to the chart above as you answer the questions below. -The slack for molding time for Sample 3 shows ____.

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

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 is ready to add the constraints and clicks the Add button. Each constraint contains a cell reference to a cell in the worksheet, a comparison operator, and a cell reference or a constraint value. Ava's first constraint is that total cost (H6) cannot exceed $10,000 (C10). She would enter these parameters in the appropriate text box: ____.

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

After you have identified the criteria that prevent a solution from being feasible, you have two choices: You can do nothing and declare that there is no solution to the problem, or you can ____ to create a feasible solution.

After changing one or more values in your constraints table, you must click the Solve button in the Solver Parameters dialog box to "resolve" the problem because Solver is not included in the automatic recalculation that Excel performs when you change a cell in a worksheet. _________________________

____ reports are NOT one of the three reports Solver can produce.

The Cell Reference input box accepts ____.

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

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.

The model you create when using Solver is ____.

Rick has created the chart above outlining the information he has on producing toy trains. He will create a two-dimensional chart to visualize the information. Please refer to the chart above as you answer the questions below. -Looking at the chart above, what would the mathematical formula be for required molding time?

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

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

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

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