What is the target cell and what is the changing cell?
target: the goal, the value to be optimized
changing: value that can be changed to optimize
What is a feasible solution and what the optimal solution?
feasible solution: satisfies the model´s constraints
optimal solution: the solution out of all feasible solutions showing the best target cell value
What is the goal seek and where to find it?
determines the value of one changing cell
data -> data tools -> What-if Analysis
What are in the dialog box?
set cell: cell to be optimized
to value: the goal to be reached
by changing cell: the variable cell
How to install the solver?
File -> Options
Excel Options -> Add-Ins
Solver Add-In -> Go
Activate
What is the solver?
determines the value of various changing cells
What are the differences between goal seek and solver?
goal seek: only one value can be optimized, solver: various values can be optimized and there are also constraints
solver: max/min, Scenario manager
Last changed2 years ago