Propuesta de un sistema de control de inventario en la empresa Qualichem Cía. Ltda. a través del sistema de Planificación de Recursos Materiales (MRP) semiautomático con Vissual Basic Applications (VBA) y Excel

Abstract

Abstract:The present work developed a proposal for an inventory control system in the company Qualichem Cía. Ltda. through an MRP system that could be automated with VBA and Excel. For this purpose, an MRP methodology was determined, consisting of a production master program (MPS), a list of materials (BOM), material explosion (MRP) and inventory status. Apart from that, the current situation of the company was diagnosed, analysis that showed the lack of an inventory control and management system exclusively for production. With this in mind, a proposal for an inventory control system was developed, detailing the MRP methodology in: forecasting methods (exponential smoothing and linear regression) in the MPS, matrix N in the BOM, material needs, gross needs, net needs, orders pending and release of planned orders in the MRP, stock, lead time, inventory management (methods ABC and CMT) in the inventory status. Finally, this system proposes the possible structure in Excel with VBA.