Question 1

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

Accepted Answer

The answer of A(n) ____________________ saves the result of a...

Question 2

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

Accepted Answer

The answer of A(n) ____________________ function results when a decision...

Question 3

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-The combination of the objective cell, variable cells, and constraints that are used to solve a problem
A)linear function
B)nonlinear function
C)unbounded solution
D)infeasible solution
E)objective function
F)Solver model

Accepted Answer

The Solver model is the combination of the objective cell, variable cells, and constraints used to solve a problem using the Solver tool in Excel. The other answer choices do not accurately describe this definition.

Question 4

Maximize Z = Q1 + Q2 is an example of a(n) ____________________ function, a mathematical formula that relates the decision variables or variable cells to the desired outcome.

Accepted Answer

The answer of Maximize Z = Q1 + Q2 is...

Question 5

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
A)linear function
B)nonlinear function
C)unbounded solution
D)infeasible solution
E)objective function
F)Solver model

Accepted Answer

An infeasible solution occurs when Solver cannot find a solution that satisfies all of the constraints. This means that it is not possible to reach a feasible solution, no matter how much the decision variables are changed.

Question 6

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)linear function
B)nonlinear function
C)unbounded solution
D)infeasible solution
E)objective function
F)Solver model

Accepted Answer

An unbounded solution means that there is no limit or constraint on a certain dimension, which can lead to an infinitely large or small solution. This is different from an infeasible solution, which means no feasible solution exists, and a linear or nonlinear function is simply a mathematical relationship between variables. The objective function is the function being optimized in a mathematical model, and Solver is a software tool for solving optimization problems.

Question 7

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

Accepted Answer

The answer of When using the Solver model, a value...

Question 8

When you cannot describe a function in linear terms, it is called a(n) ____________________ function.

Accepted Answer

The answer of When you cannot describe a function in...

Question 9

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.

Accepted Answer

The answer of One of the options when assigning constraints...

Question 10

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

Accepted Answer

The answer of A(n) ____________________ status indicates that the constraint...

Question 11

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

Accepted Answer

The answer of A(n) ____________________ solution occurs in situations in...

Question 12

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
A)linear function
B)nonlinear function
C)unbounded solution
D)infeasible solution
E)objective function
F)Solver model

Accepted Answer

A nonlinear function cannot be described using linear terms, while a linear function can be. The other choices do not relate to the definition given.

Question 13

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

Accepted Answer

The answer of The ____________________ function sums a series of...

Question 14

____________________ are the boundaries that define the feasible solution area.

Accepted Answer

The answer of ____________________ are the boundaries that define the...

Question 15

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

Accepted Answer

The answer of Saving a(n) ____________________ saves the Solver parameters...

Question 16

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

Accepted Answer

The answer of It is a good idea to use...

Question 17

A(n) ____________________ solution results when Solver cannot determine the combination of decision variables that satisfies all of the constraints.

Accepted Answer

The answer of A(n) ____________________ solution results when Solver cannot...

Question 18

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
A)linear function
B)nonlinear function
C)unbounded solution
D)infeasible solution
E)objective function
F)Solver model

Accepted Answer

A linear function results when a decision variable is multiplied by a constant, such as price, representing a direct relationship between two variables.

Question 19

The ____________________ constraint assigns the value 0 or 1 to variable cells.

Accepted Answer

The answer of The ____________________ constraint assigns the value 0...

Question 20

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

Accepted Answer

The answer of When Solver produces an acceptable solution to...

Quiz 9: Enhancing Decision Making with Solver