The Answer Report Target Cell, Adjustable Cell, and Constraint sections all include:

a) base value, original value

b) original value, final value

c) base value, final value

d) original value, test value

e) bounded value, un-bounded value

Answer: b

The ____________ for a constraint is the amount the optimal objective value will change if the right-hand-side of the constraint is increased by one unit.

a) Changing Price

b) Opportunity Cost

c) Shadow Price

d) Opportunity Price

e) Shadow Cost

Answer: c

One use of the Answer report is:

a) to develop the final answer.

b) to duplicate the output results in a new form.

c) as a debugging tool.

d) as a duplication tool.

e) as a results summary printout.

Answer: c

What do you need to do before using Solver?

a) take an Excel class

b) enter solver settings into Excel

c) define all constraints

d) enter Solver options

e) have a working, flexible spreadsheet model

Answer: e

Constraints that are not at their limits at the optimal solution of a Linear Program, that is, with the left-hand-side value not equal to the right-hand-side value, are called _________.

a) inequality constraints

b) non-binding constraints

c) binding constraints

d) limiting constraints

e) shadow constraints

Answer: b

To retain model flexibility while using Solver you must:

a) use appropriate color codes

b) enter specific values

c) ensure the inputs and outputs are separated

d) use only cell references

e) use Slack

Answer: d

At the optimal solution of a Linear Program, the difference between the right-hand-side value and the left-hand-side value of a constraint is the ________________.

a) shadow

b) difference

c) shortfall

d) slack

e) cushion

Answer: d

Three reports are available when Solver has successfully found an optimal solution. These are _______.

a) Answer Report, Sensitivity Report, and Limits Report

b) Answer Report, Sensitivity Report, and Constraints Report

c) Answer Report, Limits Report, and Constraints Report

d) Solution Report, Sensitivity Report, and Limits Report

e) Solution Report, Sensitivity Report, and Constraints Report

Answer: a

In the "Solver Options" box of Excel Solver, what should be checked to ensure that all decision variables are ≥ 0?

a) Assume Linear Model

b) Use Automatic Scaling

c) Assume Positive

d) Assume Non-Negative

e) Assume Nonzero

Answer: d

In the "Solver Options" box of Excel Solver, what should be checked to ensure that the Simplex Method is used to solve the model?

a) Assume Non-Negative

b) Use Automatic Scaling

c) Newton

d) Dantzig

e) Assume Linear Model

Answer: e

In the "Solver Parameters" box of Excel Solver, what is clicked to actually solve the problem?

a) "GO"

b) "OK"

c) "SOLVE"

d) "CLOSE"

e) "START"

Answer: c

Constraints at their limits at the optimal solution of a Linear Program, that is, with the left-hand-side value equal to the right-hand-side value, are called _________________________.

a) equality constraints

b) non-binding constraints

c) binding constraints

d) limiting constraints

e) synergistic constraints

Answer: c

In the Excel Solver "Add Constraint" box, what two additional choices are available under the relationship operator list besides ≤, ≥, and =?

a) gin and bin

b) int and gin

c) big and int

d) inf and bin

e) int and bin

Answer: e

A constraint in Excel Solver consists of what three pieces of information?

a) Target Cell, relationship operator, and Constraint

b) Target Cell, Changing Cells, and Constraint

c) Cell Reference, relationship operator, and Constraint

d) Cell Reference, Changing Cells, and Constraint

e) Target Cell, Changing Cells, and Cell Reference

Answer: c

What in Excel Solver corresponds to the decision variables in the algebraic model?

a) Optimization Cells

b) Target Cells

c) Changing Cells

d) Decision Cells

e) Parameter Cells

Answer: c

What in Excel Solver corresponds to the objective function in the algebraic model?

a) Optimization Cell

b) Target Cell

c) Changing Cell

d) Constraint Cell

e) Parameter Cell

Answer: b

Which Excel tool provides solutions to Linear Programs?

a) Solver

b) Answer

c) Simplexer

d) Computer

e) Goal Seek

Answer: a

The two primary Excel tools for diagnosing problems in models are ___________________.

a) Error Auditing and Formula Checking

b) Error Auditing and Formula Auditing

c) Error Checking and Formula Auditing

d) Error Checking and Formula Checking

e) Error Diagnosing and Formula Debugging

Answer: c

When was the Simplex Method developed?

a) 1927

b) 1937

c) 1947

d) 1957

e) 1967

Answer: c

George Dantzig developed the ___________________ in 1947 to solve Linear Programs.

a) Complex Method

b) Multiplex Method

c) Simplex Method

d) Superplex Method

e) Perplex Method

Answer: c