Chapter 9 - Solver Flashcards
What determines the optimal set of decision inputs to meet an objective?
The solver
What is an excellent tool for determining the best way to apply resources to a particular problem?
The solver
Is the solver more powerful than the goal seek?
Yes
What is an analytical method that narrows available options so you can choose the best potential outcome?
Optimization
List the 3 things that you should consider before using optimization
- 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
True or False:
The goal seek doesn’t make calculation automatically
False
What lets you specify the desired value in a cell and the cell that should be changed to reach that goal?
The goal seek
What is goal seek limited to?
One input and one output
True or False:
Goal seek finds single answers easily
True
Whatis an optimization technique for a system oflinearconstraints and alinearobjective function?
Linear programming
What defines the quantity to be optimized?
An objective function
Fill in the Blank:
The goal of linear programming is to find ____________ that maximize or minimize the objective function
The values of the variables
What is the cell that you want to maximize, minimize, or set to a specific value?
The objective cell
What produces the desired results in the target cell?
Variable cells
What limits how to solve the problem?
Constraints
