Diseño e implementación de una aplicación web para el control de inventarios de la Distribuidora el Buen Sabor VR S.A.S en la ciudad de Villavicencio para el año 2025

Abstract

Process optimization has ceased to be merely a concept and has consolidated itself as a guiding principle inherent in every productive process or activity. There is no company that does not integrate continuous improvement as an essential part of its operation, since there is always something to enhance and strengthen within the organization. In this regard, efficiency emerges as an unavoidable premise that gains particular relevance in the food sector, where proper inventory management and waste reduction are decisive factors to ensure competitiveness and growth in a dynamic and highly demanding environment. The present work aimed to design a web application to optimize inventory control at Distribuidora El Buen Sabor VR S.A.S., located in Villavicencio, due to its reliance on manual records, an obsolete system, and the lack of clear control policies, which caused losses of nearly 54% of the monthly inventory. Expired products accounted for 95% of the defects, representing the most critical factor in the losses. To address this issue, the Lean Six Sigma methodology was applied under the DMAIC cycle (Define, Measure, Analyze, Improve, and Control), which allowed mapping of the current process and structuring a path for improvement. As a result, the implementation led to a digital tool that integrates product registration, physical counts, defect control, and real-time reports. Combined with the application of the 5S methodology, it not only optimized product management but also improved visual control and process standardization in the warehouse, providing a more reliable, efficient, and sustainable control model for the distributor.