Implementación de un modelo de asignación de flota maximizando la rentabilidad en operaciones de transporte de bebidas

Abstract

CONDITION FOR PUBLICATION OF PROJECT. An industrial brewery requires, on average, 153 trips per month to supply the different warehouses around the country; truck allocation is a manual activity that takes up to 5 hours every week. An optimization model would allow us to reduce this time and ensure operation efficiency by minimizing costs and underutilization of space. To develop the project, QFD was applied to transform customer feedback (VOC) into design specifications, company databases were used to collect key data, mixed linear programming was applied to formulate the model, and the Python language with the PuLP library was used to execute it. As a result of pilot tests comparing actual allocation against the model´s suggestion, a 13% increase in space utilization was obtained for each order, equivalent to $ 1 660 in monthly savings; in turn, the daily time spent on the manual activity was reduced from 45 to 15 minutes. Keywords: MILP, assignment problem, primary transportation, truck utilization by weight.