Exam 9: Enhancing Decision Making with Solver

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 is ready to fill in the By Changing Variable Cells box. She would choose the cells containing the ____.

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

Solver changes the values in the variable cells (also called ____ variables) to maximize, minimize, or set the objective cell to a specific value.

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 is using Solver to determine her production schedule for pendants. Ava clicks the Set Objective box, and then she clicks cell G6 because it contains the ____.

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.

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.

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. -To keep Solver from returning a negative number as a solution, Ava can ____.

When determining the feasibility of a solution, it is helpful to examine the model's constraints visually-for example, in a two-dimensional chart-to understand them.

Case 9-2 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. -Rick now needs to determine the required finished time. The correct mathematical model is ____.

When you graph a nonlinear function on two dimensions, it results in a ____.

Saving a Solver model saves the ____ that were used in the Solver model so you can load them later if necessary.

To view a previously saved scenario, select it in the Scenarios box, and then click the ____ button to update the worksheet with the data saved in the scenario.

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

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

The ____ report includes detailed information about the objective cell, variable cells, and Constraints used in the Solver model.

Click the Save Scenario button in the ____ dialog box to open the Save Scenario dialog box.

A ____ saves the result of a Solver model so that you can load it later.

One of the options when assigning constraints to a Solver model is to include the ____________________ operator, which you might be tempted to include automatically when a value in your Solver model is expressed as a whole number.

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

When you use Goal Seek, you are limited to entering values in a single cell to reach a goal in another related cell. This related cell is known as the ____ in Solver.