Solution to the multiple products transportation problem: linear programming optimization with Excel Solver

Sánchez, Luis Carlos Sánchez; Herrera, Jorge

doi:10.1109/tla.2016.7437253

Cited by 7 publications

(4 citation statements)

References 5 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…The formulation of the problem of optimizing cargo flows is formally expressed in the form of a linear programming transport model and formulated as follows [6][7][8].…”

Section: Methods and Modelmentioning

confidence: 99%

“…At the same time, the sum of 𝑋 𝑖𝑗 transport works formed during the movement of the above-mentioned 𝑋 𝑖𝑗 , 𝐿 𝑖𝑗 flows should be the smallest, i.e. 𝐿 21 + 𝑋 22 𝐿 22 + ⋯ + 𝑋 𝑚2 𝐿 𝑚2 + 𝑋 𝑚1 𝐿 𝑚1 + 𝑋 𝑚2 𝐿 𝑚2 + ⋯ + 𝑋 𝑚𝑛 𝐿 𝑚𝑛 → 𝑚𝑖𝑛 (7) Another condition of the extended model of the transport problem is that its volatility cannot be negative. Because the load current with a negative value does not physically exist and does not make sense.…”

Section: Methods and Modelmentioning

confidence: 99%

See 1 more Smart Citation

Modeling of cargo flow processes in the logistics of the transport system

Usmonov,

Djuraev,

Malikova

et al. 2023

E3S Web of Conf.

View full text Add to dashboard Cite

The management of cargo flows and transport activities is one of the most significant challenges currently. This article aims to discuss optimizing material flows in both transport and cargo management. It also develops mathematical software and material flow structures to facilitate management and production functions in supply enterprises. The article solves regulatory and forecasting issues using material flows and information models to optimize vehicle operational forms.

show abstract

“…The formulation of the problem of optimizing cargo flows is formally expressed in the form of a linear programming transport model and formulated as follows [6][7][8].…”

Section: Methods and Modelmentioning

confidence: 99%

Section: Methods and Modelmentioning

confidence: 99%

Modeling of cargo flow processes in the logistics of the transport system

Usmonov,

Djuraev,

Malikova

et al. 2023

E3S Web of Conf.

View full text Add to dashboard Cite

show abstract

“…e use of closed-loop adaptive methods to solve the optimal path selection problem based on urban traffic system problems has been proposed in the study by Sanchez and Herrera [26], so that road traffic conditions can be accurately evaluated according to real-time road conditions, and the optimization calculation function can be used to calculate the optimal path. Calculate the best route.…”

Section: Related Workmentioning

confidence: 99%

Research on the Intelligent Assignment Model of Urban Traffic Planning Based on Optimal Path Optimization Algorithm

Lü

Yao

2022

Scientific Programming

View full text Add to dashboard Cite

Congestion and complexity in the field of highway transportation have risen steadily in recent years, particularly because the growth rate of vehicles has far outpaced the growth rate of roads and other transportation facilities. To ensure smooth traffic, reduce traffic congestion, improve road safety, and reduce the negative impact of air pollution on the environment, an increasing number of traffic management departments are turning to new scientifically developed technology. The urban road traffic is simulated by nodes and sidelines in this study, which is combined with graph theory, and the information of real-time changes of road traffic is added to display and calculate the relevant data and parameters in the road. On this foundation, the dynamic path optimization algorithm model is discussed in the context of high informationization. Although the improved algorithm’s optimal path may not be the conventional shortest path, its actual travel time is the shortest, which is more in line with users’ actual travel needs to a large extent.

show abstract

“…Es una herramienta que se encuentra presente en las hojas de cálculo, como son Excel y OpenOffice.org. Permite que los modelos sometidos a restricciones obtener soluciones óptimas, por lo que en el presente estudio se lo utiliza para tener un contraste y/o comprobación de la optimización generada por el algoritmo realizado en Excel [15].…”

Section: Herramienta Solverunclassified

Modelo de Optimización para medir el costo por perdida de producto no vendido mediante Simulación Montecarlo y Algoritmo Metaheurístico Tabú

Moncayo¹,

Troncozo²,

Sanchez³

et al. 2019

ejsri

View full text Add to dashboard Cite

En este estudio se propone la mejora de un sistema de inventarios, con el objetivo de reducir el costo y maximizar las ventas en la farmacia "La Voluntad de Dios", debido a que existe manejo empírico del inventario por parte de los bodegueros, a consecuencia de esto, no se logra satisfacer correctamente a los clientes y en ocasiones se generan pérdidas por falta de espacio en la bodega o expiración de productos. Por este motivo se decidió optimizar la gestión inventario aplicando el algoritmo de búsqueda tabú obteniendo una función objetivo basada en distribuciones de probabilidad normal de 3 productos, para esto se toma muestra del histórico de inventario del año 2017 al 2019, se realizó una proyección de ventas para el año 2020; el dando como resultado un 14% más de ganancia con respecto al año 2019 y un sistema de inventario que proyecta el uso aproximado del 95% de los productos en stock, obteniendo valores óptimos para satisfacer la alta demanda y mantener control del inventario.

show abstract

Solution to the multiple products transportation problem: linear programming optimization with Excel Solver

Cited by 7 publications

References 5 publications

Modeling of cargo flow processes in the logistics of the transport system

Modeling of cargo flow processes in the logistics of the transport system

Research on the Intelligent Assignment Model of Urban Traffic Planning Based on Optimal Path Optimization Algorithm

Modelo de Optimización para medir el costo por perdida de producto no vendido mediante Simulación Montecarlo y Algoritmo Metaheurístico Tabú

Contact Info

Product

Resources

About