Note on the Use of Solver in Excel
by Roman Kapuscinski
Product Type: Conceptual Note
Publication Date: 11/2012
Product ID#: 1-429-308
Length: 10pages
Solver also allows for inclusion of various constraints (e.g., available budget, storage space, or maximum work-hours). By varying the values of input cells, we can see how the value of our objective function (say, profit) changes. Consequently, for small problems we can manually find the best values of input cells. For bigger problems, however, the manual search becomes quite tedious. Solver is very systematic and efficient in performing the search.