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