Planning Model Based on Demand Forecasting and ABC Classification: A Comparative Study of Two Branches of a Food-Sector MSME
Inventory management is essential to the operational efficiency of micro, small and medium-sized nventory management remains a critical challenge for micro, small and medium-sized enterprises (MSMEs) in the food sector, where perishable materials, demand variability and constrained replenishment schedules frequently generate stockouts, excess inventory and operational interruptions. This study develops and retrospectively evaluates an integrated inventory planning model that combines demand forecasting, volume-based ABC classification and material requirements planning for two branches of a Mexican food MSME producing and selling pastes. A quantitative, applied, descriptive and comparative non-experimental design was applied to historical daily sales records from 2026. Pachuquilla 1 provided product-level data (174 days), while Venta de Carpio provided only aggregated daily totals (150 days). A four-week same-weekday moving average was compared with a naïve previous-day forecast; accuracy was measured using mean absolute error (MAE) and weighted absolute percentage error (WAPE). ABC classification by unit volume was performed for Pachuquilla, and ingredient requirements were derived from standardized yields under a fixed Monday–Wednesday–Friday supply calendar. Pachuquilla sold 66,519 units (daily mean 382.3) and Venta de Carpio sold 142,688 units (daily mean 951.3). The moving-average method produced WAPE values of 1.24 % and 12.38 %, respectively, outperforming the naïve benchmark (33.40 % and 13.40 %). At Pachuquilla, 14 flavors classified as Category A accounted for 84.7 % of sales volume. The results demonstrate that relatively simple, low-cost quantitative tools can support more systematic replenishment decisions when data granularity differs across sites and complete inventory records are unavailable. However, because historical stock movements and unit costs were not accessible, reductions in stockouts, waste or costs were not empirically demonstrated and require future operational validation. The study contributes an accessible, reproducible procedure tailored to the practical constraints of food-sector MSMEs.
Authors
- Domingo Noé Marrón Ramos (ORCID: https://orcid.org/0000-0003-1964-6592)
- Mayra Lorena González Mosqueda (ORCID: https://orcid.org/0000-0002-4153-8099)
- Manuel Horacio Gutiérrez Martínez (ORCID: https://orcid.org/0009-0006-0166-8872)
- Abril Cadena Martínez
- Karen Lilian Gómez Barbosa
- Mishell Ferran Zúñiga Hernández
Institutions
- Tecnológico Nacional de México, Campus Pachuca (MX)
- Instituto Tecnológico Superior del Occidente del Estado de Hidalgo (MX)
Publication Details
- Journal
- International Journal of Research and Innovation in Social Science
- Published
- 2026-11-16
- DOI
- https://doi.org/10.47772/ijriss.2026.102500019
- Primary Topic
- Supply Chain and Inventory Management
- Type
- article
- Field-Weighted Citation Impact
- 0.00