Mejoras en el manejo de inventario mediante un modelo de gestión por categoría: caso xiaomi stores Ecuador

Abstract

inventory management of a technology retailer with long import lead times is diagnosed, the objective is to propose a category-based prioritization model that optimizes replenishment and reduces lost sales, the hypothesis states that a KPI–AHP–ABC scheme raises service level and recovers revenue without materially increasing working capital, and the project is justified by the impact of stockouts on customer satisfaction and profitability. A mixed case study was conducted at SmartStores S.A. over 760 SKUs: sales and inventory data (Jan-2023 to Jun-2025) were cleaned and segmented, KPIs were defined, AHP judgments with acceptable consistency were elicited, a composite score was computed, and an ABC classification was derived; the policy was validated via Monte Carlo using Q4-2024 demand; Python and Excel were used, and brief interviews with customers and advisors were collected. Results showed that 19% of SKUs concentrated 71% of the weighted value, the proposed policy increased fill rate from 91% to 97% while keeping working capital roughly unchanged (+0.8%), it estimated ~USD 158,000 in quarterly recovered sales, and it reduced stockouts in 27 class-A SKUs. It is concluded that the model aligns replenishment with strategic priorities, improves availability and profitability, and is replicable as a baseline for category management. Keywords: Inventory management, AHP, multicriteria ABC, KPI, technology retail, category