Generación de rutas óptimas para el canal TAT de una empresa láctea por medio de la herramienta Geovisor

Abstract

This article focuses on the explicit need of a dairy company to optimize its distribution model of the Presale-Autoventa Channel in the city of Cali and make it more profitable from the economic point of view and customer service. In order to achieve this, the client's total debugging must first be based on this, and each client is tabulated with the information inherent to sales in liters, weights, and the rejection percentages that have, this to create a statistic and a trend in the last quarter. Then, one of the components of the simulation software is used, which is the geo-referenced one, whose main function is to georeference all the clients in the geospatial map of Cali, assigning coordinates in X and Y. Here, the software is fed with all the customer base already structured and organized. This geo-referenced database is downloaded and uploaded to the Geo viewer program, this tool will allow us to have a visual and simulated visual of where each of the clients is and what information they have. With the help of this visual, it is possible to model and simulate each of the routes as planned or to program the software so that it parametrizes the optimal or ideal route according to restrictions or parameters assigned to it. It was evidenced that the distribution could be optimized and went from having 41 routes to working with 29, obtaining an optimization of 30% of the fleet, thus improving profitability, the CLT of the routes and the productivity of each of the vendors of the Chanel.