CGS 2518 Final Study Guide CH 9
questions and answers graded A+
What are the limitations of using Goal Seek? - correct answer ✔✔It is limited to changing values
in a single cell to reach a goal in another related cell
How many changing variable cells can you use in a Solver model? - correct answer ✔✔Up to
200
What are the three required parameters of a Solver model and what do they represent? -
correct answer ✔✔The objective cell that you want to maximize/minimize/set to a specific
value, the variable cell that Solver uses to produce the desired results in the objective cell, the
constraint that limit how to solve the problem
What are two advantages of creating a constraints table in a worksheet that includes a Solver
model? - correct answer ✔✔Provides an available record of the constraints and cell references,
they are a data-entry reference for when Solver is being set up
What is the advantage of linking the constraints in the Solver Parameters dialog box to values in
a constraints table in the worksheet? - correct answer ✔✔The values in the constraints table
can be changed as necessary without having to edit them individually in the Change Constraint
dialog box.
What is the difference between a policy constraint and a physical constraint? Give one example
of each type of constraint. - correct answer ✔✔Policy constraint is based on company history
and to some extent inertia. An example of policy constraint is a constraint that only fully loaded
trucks can make deliveries. A physical constraint is physical limitations. An example of a physical
constraint is something as simple as the size of a truck or available inventory.
questions and answers graded A+
What are the limitations of using Goal Seek? - correct answer ✔✔It is limited to changing values
in a single cell to reach a goal in another related cell
How many changing variable cells can you use in a Solver model? - correct answer ✔✔Up to
200
What are the three required parameters of a Solver model and what do they represent? -
correct answer ✔✔The objective cell that you want to maximize/minimize/set to a specific
value, the variable cell that Solver uses to produce the desired results in the objective cell, the
constraint that limit how to solve the problem
What are two advantages of creating a constraints table in a worksheet that includes a Solver
model? - correct answer ✔✔Provides an available record of the constraints and cell references,
they are a data-entry reference for when Solver is being set up
What is the advantage of linking the constraints in the Solver Parameters dialog box to values in
a constraints table in the worksheet? - correct answer ✔✔The values in the constraints table
can be changed as necessary without having to edit them individually in the Change Constraint
dialog box.
What is the difference between a policy constraint and a physical constraint? Give one example
of each type of constraint. - correct answer ✔✔Policy constraint is based on company history
and to some extent inertia. An example of policy constraint is a constraint that only fully loaded
trucks can make deliveries. A physical constraint is physical limitations. An example of a physical
constraint is something as simple as the size of a truck or available inventory.
