Excel Solver

How to Use Solver in Excel (with Detailed Steps)

The solver tool is used to find an optimum value for a formula in one cell, by changing decision variables. While solving linear programming problems ...

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 ...

How to Use Excel Evolutionary Solver (With Easy Steps)

In this tutorial, I am going to show you how to use the Evolutionary solver in excel to solve complex optimization problems. You can use this solver ...

How to Use Excel Solver to Rate Sports Team (With Easy Steps)

This tutorial will demonstrate how to use an excel solver to rate sports team. Ratings are numerical representations of competitive strength which is ...

How to Create Financial Planning Calculator in Excel

In this article, I will show you two ways to create a financial planning calculator in Excel. Most of us need to determine the monthly payment or the ...

How to Use Excel Solver to Determine Which Projects Should Be Undertaken

This tutorial will demonstrate how to use excel solver to determine which projects should be undertaken. Companies need to know which projects should ...

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 Optimization in Excel (Detailed Analysis)

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 ...

How to Calculate Optimal Product Mix in Excel (with Easy Steps)

In many situations, you may want to know how to calculate the optimal product mix in Excel. For example, companies often need to determine the amount ...

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 ...

How to Do Portfolio Optimization Using Excel Solver

In this example, we're going to demonstrate how to use Solver to get maximum return from an investment portfolio. A portfolio consists of several ...

Resource Allocation in Excel (Create with Quick Steps)

Resource allocation means a proper distribution of our existing inventories to make the maximum amount of profit, In this article, we are going to ...

Where Is Solver in Excel?

Solver is a Microsoft Excel add-in program. The Solver is a part of the collection of What-If Analysis tools that we can use in Excel to test ...

ExcelDemy
Logo