In Excel, you can use Solver to find an optimal value (maximum or minimum, or a certain value) for a formula in one cell called the objective cell, subject to certain constraints or limits, on the values of other formula cells on the worksheet. Then, one or more other variables are changed repeatedly, subject to the specified constraints, until you discover the best values for the target variables. Instead of setting a specific target value for a variable, the goal is to find the optimum value for one or more target variables, under certain constraints. Solver is a Microsoft Excel add-in program you can use for optimization in what-if analysis.Īccording to O'Brien and Marakas, optimization analysis is a more complex extension of goal-seeking analysis.
0 Comments
Leave a Reply. |