CGS 2518 FINAL STUDY GUIDE CH #9
QUESTIONS AND ANSWERS
What is an infeasible solution? What steps can you take to attempt to change an
infeasible solution into a feasible solution? - Answer-It is when Solver can't produce a
combination of decision variables that satisfies all of the constraints; the steps to
troubleshoot an infeasible solution are: fix any data-entry errors, review the feasibility
report for constraints with a violated status, review the constraints to see if a policy
constraint is the problem
What is an unbounded solution? - Answer-An unbounded solution occurs in situations in
which the feasible solution is unrestrained
What is the difference between a linear function and a nonlinear function? - Answer-
Linear function results when a decision variable is multiplied by a constant, when plotted
on a chart the result is a straight line; a nonlinear function is a function that can't be
described in linear terms, graphed on two dimensions and results in a curve
What requirements exist for cells in arrays when you use the SUMPRODUCT function?
- Answer-The arrays must be identical in size, shape, and orientation
Describe how the SUMPRODUCT function works. - Answer-The SUMPRODUCT
function sums a series of products in ranges of identical sizes, called arrays that are
arranged in the same orientation to each other in a worksheet
17. Describe the steps for saving a Solver model. What is the advantage of saving a
Solver model? - Answer-i) Click the Solver button on the data tab ii) Click load/save
button iii) Select an empty range in the worksheet with the number of cells listed in the
dialog box iv) Click the save button. Protects the information that is provided from being
lost/deleted
What is an assignment problem? - Answer-An assignment problem is an optimization
problem in which there is a one-to-one relationship between a resource and an
assignment or job
How does the binary comparison operator work? - Answer-It restricts the value to either
0 or 1
What are the limitations of using Goal Seek? - 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? - Answer-Up to 200
What are the three required parameters of a Solver model and what do they represent?
- Answer-The objective cell that you want to maximize/minimize/set to a specific value,
QUESTIONS AND ANSWERS
What is an infeasible solution? What steps can you take to attempt to change an
infeasible solution into a feasible solution? - Answer-It is when Solver can't produce a
combination of decision variables that satisfies all of the constraints; the steps to
troubleshoot an infeasible solution are: fix any data-entry errors, review the feasibility
report for constraints with a violated status, review the constraints to see if a policy
constraint is the problem
What is an unbounded solution? - Answer-An unbounded solution occurs in situations in
which the feasible solution is unrestrained
What is the difference between a linear function and a nonlinear function? - Answer-
Linear function results when a decision variable is multiplied by a constant, when plotted
on a chart the result is a straight line; a nonlinear function is a function that can't be
described in linear terms, graphed on two dimensions and results in a curve
What requirements exist for cells in arrays when you use the SUMPRODUCT function?
- Answer-The arrays must be identical in size, shape, and orientation
Describe how the SUMPRODUCT function works. - Answer-The SUMPRODUCT
function sums a series of products in ranges of identical sizes, called arrays that are
arranged in the same orientation to each other in a worksheet
17. Describe the steps for saving a Solver model. What is the advantage of saving a
Solver model? - Answer-i) Click the Solver button on the data tab ii) Click load/save
button iii) Select an empty range in the worksheet with the number of cells listed in the
dialog box iv) Click the save button. Protects the information that is provided from being
lost/deleted
What is an assignment problem? - Answer-An assignment problem is an optimization
problem in which there is a one-to-one relationship between a resource and an
assignment or job
How does the binary comparison operator work? - Answer-It restricts the value to either
0 or 1
What are the limitations of using Goal Seek? - 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? - Answer-Up to 200
What are the three required parameters of a Solver model and what do they represent?
- Answer-The objective cell that you want to maximize/minimize/set to a specific value,
