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

Roger S.-A.; Brany I.-C.; Dalexandro O.-E. · Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology (2026) · DOI: 10.18687/laccei2026.1.1.255

Resumen

This study describes the design and implementation of an Enterprise Resource Planning (ERP) system developed in Excel to optimize the management of the finished goods warehouse at Lácteos Huacariz. The organization was experiencing recurring problems related to manual record-keeping, a lack of traceability, discrepancies between physical and recorded inventory, and the absence of a reliable history of inventory movements. In response, a diagnosis of the current process was conducted, the root cause was identified using quality tools, and a modular Enterprise Resource Planning (ERP) system based on buttons and linked sheets was developed, capable of recording receipts, shipments, daily inventories, and a history of operations. The results show that the system improved inventory accuracy by 85.714%, ensured traceability, reduced historical information search times by 86.667%, and facilitated operational decision-making; order errors were also reduced by 75% compared to the previous system. Additionally, limitations related to staff training and initial resistance to change were identified. In conclusion, the proposed Enterprise Resource Planning (ERP) system constitutes a viable, low-cost solution for small and medium-sized enterprises, enabling more efficient warehouse management and laying the groundwork for future technological and operational improvements.

Instituciones: Universidad Privada del Norte