The passenger transport industry faces the problem of determining how to efficiently allocate transportation capacity when offering different prices or fees to their customers for a specific route. This is why they must consider sales revenues associated with each type of rate, estimated customer demand for such fees and the capacity of the transport in […]

# Archivo de Etiquetas (Tags) | solver

## How to Download and Install the Trial version of Premium Solver Pro in Excel 2010

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 […]

## 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 […]