Algoritmo de ponderación, priorización y secuencia en base a la metodología de mínimos y máximos para la creación de planimetría de inventarios en una empresa retail comercializadora de motocicletas

Abstract

In the retail sector, inventory allocation implies a dynamic challenge since it is necessary to adopt policies that consider the market fluctuating demand and the consumer behavior variability, depending on their geographical location. An inappropriate inventory distribution directly transcends sales levels, the cost of maintaining high inventory levels, and the transfer logistics cost of between stores due to the incomplete availability of products. In this research work an algorithmic model that calculates the best assortment for each store of a retail company in the motorcycle sector is developed. The proposed solution is based on prioritization methods and weighting of external and internal historical variables and marketing variables in order to obtain the ideal set of products. The model has been developed in Visual Basic programming language for its flexibility in variable parameterization combined with easy implementation and interactivity with databases. The results show that inventory turnover indicator increase significantly from the application of the model, which shows that a correct inventory allocation can increase the profits of the retailer. The strength of the proposed system is that it allows the parameterization of input variables according to the commercial needs of the retail owner; because one of the main limitations of the existing literature is that it neglects marketing rules and does not address the strategic importance of the product