Then, one or more other variables are changed repeatedly, subject to the specified constraints, until you discover the best values for the target variables. 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. 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. ![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |