Question 1

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 2

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 3

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 4

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 occurs in situations where there is no constraint on the feasible solution, resulting in the solution being unrestrained or unlimited on some dimension.

Question 5

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 6

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 7

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

Nonlinear functions cannot be described using linear terms, whereas linear functions can. The other answer choices are not applicable to this definition.

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

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 11

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

A Solver model is the combination of the objective cell, variable cells, and constraints that are used to solve a problem using Microsoft Excel's Solver tool. The other answer choices are related to specific concepts within mathematical modeling but do not fully encompass the definition given.

Question 12

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 13

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

Accepted Answer

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

Question 14

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 15

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 16

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 17

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 18

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 determine a combination of decision variables that satisfies all of the constraints.

Question 19

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...

Question 20

____________________ are the boundaries that define the feasible solution area.

Accepted Answer

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

Quiz 9: Enhancing Decision Making with Solver

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