Diseño de Aplicativo de Gestión y Control de Inventarios para una Empresa de Confección Textil por Medio de AppSheet y Power BI

Abstract

The project addresses inventory management problems in a micro textile company, specifically Studio Yez, which faces discrepancies between physical and recorded inventory, as well as stock-outs and overstocking of slow-moving products. To solve this, an inventory management prototype was developed consisting of two main interfaces: one in AppSheet, for the control of inputs and outputs, and another in Power BI, which includes dashboards for ABC analysis and inventory control. The methodology included interviews with key personnel, analysis of production processes through flow charts, and the development of indicators such as turnover and inventory days. AppSheet facilitates the recording of products, sales, and inventory movements in real time, while Power BI offers interactive analysis with techniques such as reorder point and safety stock. The prototype improves record-keeping and planning accuracy, optimizing the supply chain. The results show that the proposed system can address current deficiencies, increase operational efficiency and improve customer satisfaction, establishing a solid foundation for future research in the use of ICT in inventory management.