The Solver command should appear in the Analysis group as shown below. You can use Solver to find optimal solutions for diverse problems such as −ĭetermining the monthly product mix for a drug manufacturing unit that maximizes the profitability.īefore you proceed with finding solution for a problem with Solver, ensure that the Solver Add-in is activated in Excel as follows − Solver adjusts the values in the decision variable cells to satisfy the limits on constraint cells and produce the result you want for the objective cell. This means that the Solver works with a group of cells called decision variables that are used in computing the formulas in the objective and constraint cells. 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 kommentar(er)
