Diseño e implementación de un sistema de información semiautomatizado para la gestión de indicadores de producción, calidad y talento humano en Bromx S.A.S.

Abstract

This project addresses the design and implementation of a semi-automated information system for managing production, quality, and human talent indicators at Bromx S.A.S., a Colombian leather footwear manufacturing company. The core problem lies in a fragmented information management approach that leads to data loss, a lack of traceability, and reactive decision-making, resulting in quality control deficiencies, high staff turnover, and the risk of non-compliance with clients. The project applied a research methodology developed across five phases: diagnosis, architecture design, modular development, validation, and impact assessment. Fifteen functional requirements were identified, integrating 36 scattered records into 15 sections of relevant information. Developed in Microsoft Excel using VBA, the system consists of two modules—production-quality and human talent—and features automated last curve calculation, a Pareto diagram for returns, dynamic production targets, last inventory management, absenteeism tracking, and semi-automated payroll calculation. Technical validation confirmed 100% accuracy in automated calculations. The evaluation using the Improvement Perception and Coverage Index yielded ninety percent, with unanimous team satisfaction. Operational benefits include an 86% reduction in last curve calculation time and an 89% reduction in absenteeism reporting time, with estimated economic benefits of $178,358.98 COP monthly. A sustainability plan was established featuring knowledge transfer, data backups, and biweekly indicator reviews.