Module 11
After you have identified the criteria that prevent a solution from being feasible, you have two choices: You can do nothing and declare that there is no solution to the problem, or you can ____ to create a feasible solution. -add data -adjust the constraints -add constraints -run a summary report
Adjust the constraints
With Solver, you can change the values of up to 500 cells at one time to reach a goal in the objective cell. (True Or False)
False
Solver can produce four different reports: summary, answer, sensitivity, and limits. (True or False)
False (Answer, sensitivity, limits)
You must answer four questions before using optimization to solve a problem. They do NOT include ____. -How many resources are there and how many are needed? -How many resources does each decision variable consume? -How much does each decision variable contribute to the objective? -How much does each decision variable cost?
How much does each decision variable cost?
If all of the constraints, which represent the availability of resources, have slack values, the solution isn't the optimal solution that maximizes the available resources. (True or False)
True
The cells in a worksheet usually display combinations of text or numbers; the math that generates the answers is hidden. (True Or False)
True
When solving problems with nonlinear objective functions, you must enter a variety of starting points to ensure that the answer that Solver reports is actually the optimal solution. (True or False)
True
If Solver attempts the maximum number of iterations without the objective cell converging to an answer, the assumption is that the solution is ____. -targeted -untargeted -bounded -unbounded
Unbounded
A(n) ____ results when Solver cannot determine the combination of decision variables that satisfies all of the constraints. -infeasible solution -wrong solution -error -dead end
Infeasible Solution
To change the number of times Solver attempts to solve a problem, click Options in the Solver Parameters dialog box, change the value in the ____ box, and then click the OK button. -solve -count -iterations -options
Iterations