CGS 2518 CHAPTER #9 EXAM
QUESTIONS AND ANSWERS
Infeasible solutions happen when Solver can't produce a combination of decision
variables that satisfy all the constraints. User must correct all data-entry errors. Review
the feasibility report for constraints that have been marked as violated. Review the
constraints to see if a policy constraint is the problem. - Answer-What is an infeasible
solution? What steps can you take to attempt to change an infeasible solution into a
feasible solution?
Occurs in situations in which the feasible solution is unrestrained or unlimited on some
dimension - Answer-What is an unbound solution?
Linear Function- When a decision variable is multiplied by a constant. The result is a
straight line. Nonlinear Function- A function that cannot be described in linear terms.
Graphed on two dimensions and results in a curve - Answer-What is the difference
between a linear function and a nonlinear function?
Requires the cells have the same size, shape and orientation - Answer-What
requirements exist for cells in arrays when you use the SUMPRODUCT function?
Multiply the values according to positions in multiple ranges and then add the results to
obtain a total. - Answer-Describe how the SUMPRODCUCT functions work.
Is a problem in which there is a one-to-one relationship between a resource and an
assignment or job. - Answer-What is an assignment problem?
The binary comparison operator will restrict the values to either 1 or 0 - Answer-How
does the binary comparison operator work?
must compare the multiple production quantities. Can't find more than single answers
using goal seek - Answer-What are the limitations of using goal seek?
With Solver, you can change the values in as many as 200 cells at one time. - Answer-
How many changing variable cells can you use in a solver model?
The objective cell that you want to maximize, minimize, or set to a specific value. The
variable cells that Solver uses to produce the desired results in the objective cell. The
constraints that limit how to solve the problem. - Answer-What are the three required
parameters of a solver model and what do they represent?
Set up the structure for the data table. 2. Instruct Excel about how the data table's
structure relates to the input section of the worksheet. - Answer-What are the two major
steps involved in creating a data table in Excel?
QUESTIONS AND ANSWERS
Infeasible solutions happen when Solver can't produce a combination of decision
variables that satisfy all the constraints. User must correct all data-entry errors. Review
the feasibility report for constraints that have been marked as violated. Review the
constraints to see if a policy constraint is the problem. - Answer-What is an infeasible
solution? What steps can you take to attempt to change an infeasible solution into a
feasible solution?
Occurs in situations in which the feasible solution is unrestrained or unlimited on some
dimension - Answer-What is an unbound solution?
Linear Function- When a decision variable is multiplied by a constant. The result is a
straight line. Nonlinear Function- A function that cannot be described in linear terms.
Graphed on two dimensions and results in a curve - Answer-What is the difference
between a linear function and a nonlinear function?
Requires the cells have the same size, shape and orientation - Answer-What
requirements exist for cells in arrays when you use the SUMPRODUCT function?
Multiply the values according to positions in multiple ranges and then add the results to
obtain a total. - Answer-Describe how the SUMPRODCUCT functions work.
Is a problem in which there is a one-to-one relationship between a resource and an
assignment or job. - Answer-What is an assignment problem?
The binary comparison operator will restrict the values to either 1 or 0 - Answer-How
does the binary comparison operator work?
must compare the multiple production quantities. Can't find more than single answers
using goal seek - Answer-What are the limitations of using goal seek?
With Solver, you can change the values in as many as 200 cells at one time. - Answer-
How many changing variable cells can you use in a solver model?
The objective cell that you want to maximize, minimize, or set to a specific value. The
variable cells that Solver uses to produce the desired results in the objective cell. The
constraints that limit how to solve the problem. - Answer-What are the three required
parameters of a solver model and what do they represent?
Set up the structure for the data table. 2. Instruct Excel about how the data table's
structure relates to the input section of the worksheet. - Answer-What are the two major
steps involved in creating a data table in Excel?
