Exam 9: Enhancing Decision Making with Solver

Ranges are the boundaries that define the feasible solution area. _________________________

The ____ section of the answer report contains the cell reference, name, cell value, and formula for cells that have constraints.

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.

A(n) ____________________ function results when a decision variable is multiplied by a constant, such as price.

The combination of the objective cell, variable cells, and constraints that are used to solve a problem is called a ____.

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

When solving problems with nonlinear objective functions, you must enter a variety of starting points to ensure that the answer that Solver reports is actually the optimal solution.

Restricting the number of gallons of milk that a customer can buy at a sale price is a ____.

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

You can set up complex business models in a worksheet and use Solver to determine the optimal set of decision inputs to improve profitability, such as minimizing costs or ____ income.

Solver can be used with either linear or nonlinear functions. Define linear and nonlinear functions, and give an example of a situation where you would find each of them.

Although you can enter constraints directly into the ____ dialog box without creating a constraints table in your worksheet, creating a constraints table in the worksheet is a much better way of organizing your Solver models.

Because Solver is a(n) database model, there is nothing to keep it from producing negative results. _________________________

A(n) ____________________ solution occurs in situations in which the feasible solution is unrestrained or unlimited on some dimension.

Although Goal Seek only lets you change ____, it can be quite useful at times.

You can use ____ in the Constraint input box of the Add Constraint dialog box instead of entering a specific value.

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

The ____ section of the answer report includes the cell reference, name, original value, and final value of the variable cells in a worksheet.

Identify the letter of the choice that best matches the items in the Solver answer report above. -Includes the objective cell reference and name (which is generated from the worksheet's labels), the original value in the cell, and the final value in the cell A)#1 B)#2 C)#3 D)#4 E)#5 F)#6

If you try to solve a problem in which there are no constraints or too few constraints, the solution is bounded. _________________________