Diseño de un sistema de gestión de inventarios para una compañía de climatización

Abstract

CONDITION FOR PUBLICATION OF PROJECT. Local-first architecture ensures operational continuity despite intermittent connectivity in supply chain management environments. This approach establishes a validated data flow and role-based dashboards to strengthen institutional procurement traceability. It is hypothesized that load validation and status tracking increase information reliability and provider performance oversight, justifying the need for operational visibility when central systems are unstable. During the development phase, web modules with a Python backend and visualization dashboards were designed. The implementation included a manual extraction, transformation, and load (ETL) process from Excel files, integrating strict format validations and duplicate record detection. The results evidenced a procurement plan consisting of 8,530 units and 13 unique SKUs; out of 31 purchase orders analyzed, 19 were registered as delivered. The average real lead time reached 17.39 days compared to the projected 14.32 days, resulting in a 41.94% on-time delivery rate. In conclusion, the evidence supports the effectiveness of operating locally under quality controls, key performance indicators, and auditing processes to facilitate informed decision-making within the logistics framework. Keywords: Offline architecture, Data integrity, Supply management, Logistics indicators, Backend solution.