Learn Programming and technology with ease @ developerpublish.com

In this post, youâ€™ll learn about Solver Add-in in Excel which is used find optimal solutions for decision making problems.

• Go to File tab â€“ > Options. When Excel Options dialog box opens up, Go to Add-ins â€“ > Solver Add-in<Go.
• Add-ins dialog box opens up click on Solver Add-in check box and then on OK.
• After this, you can find the Solver tool in the Data tab under the Analyze group.

## How to Formulate the Model for Solver in Excel?

• Firstly Identify the problem.
• Then identify the constraints, the objective and the restrictions.
• And finally figure out a mathematical formulation for the problem.
• For instance, letâ€™s say we have a problem to minimize the cost of transportation from two places to four destinations. letâ€™s say there are two companies.
• The formulation of the constraints, the demand shouldnâ€™t exceed the available quantity.

Formulation of optimal solution, the objective is to minimize the total cost of transportation.

Firstly we need to figure out the quantity that is to be transported from the two companies and the total of the quantity delivered to the four destinations.

## Solving the Model using Solver in Excel

To find the optimal solution and solve the model using Solver in Excel, follow the below steps.

• After figuring out the constraints and the objective function. Go to Data tab â€“ > Analyze â€“ > Solver.
• Solver Parameters dialog box opens up.
• Under the Set Objective field, set it according to the problem and the optimal solution expected from the objective function.
• In the To category select the options according to the objective of the problem.

Similarly select for By Changing Variable Cells.

• In the Subject to the Constraints field enter the constraints that youâ€™ve formed. And also make sure to select the solving method you want.

Finally make sure youâ€™ve made all the changes you want.

Then click on Solve.

• Click on OK, after selecting Answer under the Reports Category in the Solver Results dialog box. This will show you the result.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021