Solver is definitely next What’sBest! The most popular tool for solving optimization models using Microsoft Excel as a platform. In fact the free version of Solver we use is developed by Frontline Systems Inc., which provides a number of tools and resolution engines that are very useful when addressing problems of real life situations that […]

# Archivo de Etiquetas (Tags) | excel

## Example of a Product Mix Problem in Linear Programming

One of the classic applications of Linear Programming models is the product mix problem. If the quality of a product that is processed through the mixture of certain inputs can be approximated reasonably through a proportion, then a linear model may be useful. The example below shows this situation: An oil refinery produces two types […]

## Formulation and Resolution of a model of Linear Programming to reduce the duration of a Project (Crashing)

In Project Management one of the key aspects is determining the costs to complete the project in a given time. Likewise it is of particular interest to efficiently face the problem of how to reduce the duration of it in the most economical way, on the premise that certain activities could eventually be developed in […]

## Model of Transportation with Transshipment solved with Excel Solver

One of the classic uses of Operations Research and, in particular of Linear Programming is to propose optimum alternatives for the logistics or transport of inputs and products from a group of suppliers to a group receivers or petitioners. When we consider that, in this process of transportation, intermediaries can participate, this is an extension […]

## How to Solve a Linear Programming (LP) problem with What’sBest!

The following tutorial will show how to solve a Linear Programming (LP) model with What’sBest! 11.1. Of course, you previously need to download and install What’sBest! as a add-in for Excel the way we explained it step by step in a previous tutorial. In order to show how to use this Excel add-in we will use the Transportation […]