Implementation of an ERP for the Optimization of Finished Product Warehouse Management at Lácteos Huacariz

Abstract

Abstract–This study describes the design and implementation of an ERP system developed in Excel to optimize the management of the finished goods warehouse at Lácteos Huacariz. The organization exhibited recurring problems related to manual records, lack of traceability, discrepancies between physical and recorded inventory, and the absence of a reliable history of movements. In response, an assessment of the current process was conducted, the root cause was identified using quality tools, and a modular ERP system based on buttons and linked sheets was developed, capable of recording entries, exits, daily inventories, and an operations history. The results demonstrate that the system improved inventory accuracy, ensured traceability, reduced information retrieval times, and facilitated operational decision-making. Similarly, limitations related to staff training and initial resistance to change were identified. In conclusion, the proposed ERP constitutes a viable and low-cost solution for small and medium-sized enterprises, enabling more efficient warehouse management and providing the foundation for future technological and operational improvements.