Chat with us, powered by LiveChat

Define and solve a problem by using Solver

Put simply, you can use Solver to determine the maximum or minimum value of one cell by changing other cells. For example, you can change the amount of your projected advertising budget and see the effect on your projected profit amount.
Activating Solver Addin

  1. In Excel 2010, 2013 and 2016 and later, go to File > Options or press the short cut keys ALT +F + T

    Note: For Excel 2007, click the Microsoft Office Button Office button image , and then click Excel Options.

  2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.
  3. Click Go.
  4. In the Add-Ins available box, select the Solver Add-in check box, and then click OK.

    Notes:

    •  If the Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
    • If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.
  5. After you load the Solver Add-in, the Solvercommand is available in the Analysis group on the Data tab

Solver Addin UseCases

  • Transportation Problem
  • Personel Shift Allocation
  • Profit Modeling
  • Queuing Problem
  • Budget Modeling
  • Resources allocation solutions
  • Tariff and Rate Modeling for Utilities such as Power, Gas, Licensing and many money

Party adopted from Microsoft Website. Drafted by David K. Kandie, OCL Learning, Chief Learning Officer 

Share with your followers...
Email this to someone
email
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin

Post Author: David K. Kandie