Excel Solver

How to Use Solver in Excel (Solving Linear Programming Problems)!

The solver tool is used to find an optimum value (either a maximum or minimum depending on the example) for a formula in one cell, by changing ...

Sequencing problem using Johnson’s algorithm of scheduling n-jobs on 2-machines [Sol]

Almost two weeks ago, Jagadeesh asked me if I can explain how to solve the sequencing problem using Johnson’s algorithm of scheduling n-jobs on ...

Deal with Sequencing Problems Using Excel Solver!

It is well known that sequencing problems are notoriously difficult to solve. There are two kinds of sequencing problems:  traveling salesperson ...

How to Assign Work Using Evolutionary Engine?

Previously, I have made a brief introduction to the Evolutionary engine when discussing GRG engine. Today, I’d like to show you how to use ...

GRG Nonlinear Multistart & Excel Evolutionary Solver (Explained)!

Previously I have written an article on how to rate sports team using GRG Nonlinear engine, today I’d like to continue to discuss GRG Nonlinear ...

Excel Solver with a Case Study [Rate Your Sports Team]

Ratings are numerical representations of competitive strength which is directly comparable. It is often applied directly to predict the game outcome ...

Financial Planning with Excel Solver [2 Case Studies]

Most of us need to determine the monthly payment or the amount of money to be saved for retirement over life. It is not easy to do such kinds of ...

Use Excel Solver to Determine Which Projects should be Undertaken

Companies need to know which projects should be undertaken in order to produce the greatest NPV (net present value) when there are limited resources. ...

Solving Transportation or Distribution Problems using Excel Solver

It is well known that companies not only manufacture products at different locations but also ship their products to the customer at different ...

Schedule Your Workforce using Excel Solver [4 Case Studies]

I have written an article on how to determine the optimal product mix using Excel Solver. Today, I’d like to discuss how to schedule the workforce ...

Using Excel Solver to Determine the Optimal Product Mixtures

In many situations, we may want to find the best way to do something. For example, companies often need to determine the amount of each product that ...

Excel Solver Guide (Easy and Step by Step)

It is a complete Excel solver guide for you. Actually, it is a list of articles that explain the topic in easy language and step by step. Follow ...

Optimizing an investment portfolio using Excel Solver

This article is part of my series: Excel Solver Guide (Easy and Step by Step). In this example, we're going to demonstrate how to use Solver to get ...

Resource Allocation Model in Excel Using Solver

In this article, you will learn how to build a resource allocation model in Excel using the solver. Our motto is always making the best use of ...

If Excel doesn’t show the Solver command

This article is part of my series: Excel Solver Guide (Easy and Step by Step). You can access Solver by choosing Data ➪ Analysis ➪ Solver. Sometimes ...

ExcelDemy
Logo