Planning Model Based on Demand Forecasting and ABC Classification: A Comparative Study of Two Branches of a Food-Sector MSME
Authors
Instituto Tecnológico de Pachuca, Hidalgo (Mexico)
Mayra Lorena González Mosqueda
Instituto Tecnológico de Pachuca, Hidalgo (Mexico)
Mishell Ferran Zúñiga Hernández
Instituto Tecnológico de Pachuca, Hidalgo (Mexico)
Instituto Tecnológico Superior del Occidente del Estado de Hidalgo (Mexico)
Manuel Horacio Gutiérrez Martínez
Instituto Tecnológico de Pachuca, Hidalgo (Mexico)
Instituto Tecnológico de Pachuca, Hidalgo (Mexico)
Article Information
DOI: 10.47772/IJRISS.2026.102500019
Subject Category: Management
Volume/Issue: 10/25 | Page No: 349-359
Publication Timeline
Submitted: 2026-10-26
Accepted: 2026-10-31
Published: 2026-11-16
Abstract
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.
Keywords
inventory planning; demand forecasting; ABC classification; material requirements planning; MSMEs; food sector.
Downloads
References
1. Abdalla, A. M. S., & Mohamed, M. R. M. (2026). Supply chain inventory efficiency and corporate profitability: An empirical study of ABC–XYZ classification in food and beverage firms. International Journal of Professional Business Review, 11(2), Article 5855. https://doi.org/10.26668/businessreview/2026.v11i2.5855 [Google Scholar] [Crossref]
2. Aguh, P. S. (2025). A comparative analysis of machine learning models for inventory demand forecasting in a food manufacturing SME. Indonesian Journal of Innovation Science and Knowledge, 2(3), 35–48. https://doi.org/10.31004/ijisk.v2i3.177 [Google Scholar] [Crossref]
3. Cuba Paz, B. A., Bazan Cabezas, P. E., & Flores-Perez, A. (2022). Application of a model based on demand forecasting, ABC classification and EOQ in a gastronomic SME to improve inventory turnover: Case study in Peru. In Proceedings of the International Conference on Industrial Engineering and Operations Management. IEOM Society. [Google Scholar] [Crossref]
4. Espejel Rivera, et al. (2026). Hybrid algorithmic framework for intelligent requisition management: Integrating Excel, AI agents, and Power BI for analytical traceability. International Journal of Combinatorial Optimization Problems and Informatics, 18(1), 200–219. https://doi.org/10.61467/2007.1558.2027.v18i1.1464 [Google Scholar] [Crossref]
5. Flores Gutiérrez, X. P., Cota Pardini, Y. B., & Loredo Medina, R. (2023). Redistribución de inventario con base en clasificación ABC para mejorar el flujo de materiales en una empresa productora de alimentos en Sinaloa, México. Ingeniería Industrial, (44), 65–80. https://doi.org/10.26439/ing.ind2023.n44.6244 [Google Scholar] [Crossref]
6. Goltsos, T. E., Syntetos, A. A., Glock, C. H., & Ioannou, G. (2022). Inventory – forecasting: Mind the gap. European Journal of Operational Research, 299(2), 397–419. https://doi.org/10.1016/j.ejor.2021.07.040 [Google Scholar] [Crossref]
7. Huber, J., Müller, S., Fleischmann, M., & Stuckenschmidt, H. (2019). A data-driven newsvendor problem: From data to decision. European Journal of Operational Research, 278(3), 904–915. https://doi.org/10.1016/j.ejor.2019.04.043 [Google Scholar] [Crossref]
8. Hyndman, R. J., & Koehler, A. B. (2006). Another look at measures of forecast accuracy. International Journal of Forecasting, 22(4), 679–688. https://doi.org/10.1016/j.ijforecast.2006.03.001 [Google Scholar] [Crossref]
9. Lázaro, R., et al. (2025). Effective inventory optimization strategy: An integrated approach for MSMEs using ABC classification and cycle counting. Journal of Financial Economics, 9(15), 4–17. https://doi.org/10.35429/JFE.2025.9.15.4.1.7 [Google Scholar] [Crossref]
10. López-Soto, et al. (2017). Considerations for perishable inventory. (Cited in recent food logistics literature). [Google Scholar] [Crossref]
11. Mohedano Torres, E. J., & Gutiérrez Martínez, M. H. (2026). Mejora integral de inventarios para abastecimiento con base a las técnicas EOQ, ABC y JIT. In Herramientas de clase mundial: Enfoque holístico. Tecnológico Nacional de México, Campus Pachuca. [Google Scholar] [Crossref]
12. Nasution, J., et al. (2025). Analysis of the effectiveness and accuracy of a production system based on demand forecasting in reducing excess stock. Urwatul Wutsqo: Jurnal Studi Kependidikan dan Keislaman, 14(3). [Google Scholar] [Crossref]
13. Partogi Matanari, M., & Parung, J. (2026). Systematic review on the convergence of Lean, ABC–FSN inventory classification, and Industry 4.0 in strategic food logistics. In Proceedings of the International Conference on Industrial Engineering and Operations Management. IEOM Society. [Google Scholar] [Crossref]
14. Pradita, S. P., & Widodo, K. H. (2024). Product inventory control at a local brand forum outlet using ABC analysis. Agrointek, 18(2), 246–255. https://doi.org/10.21107/agrointek.v18i2.18819 [Google Scholar] [Crossref]
15. Rodrigues Filho, L. F. V. (2025). Gestão de estoques com curva ABC e MRP em pequena empresa varejista de alimentos [Undergraduate thesis]. Instituto Federal do Espírito Santo. [Google Scholar] [Crossref]
16. Silver, E. A., Pyke, D. F., & Thomas, D. J. (2017). Inventory and production management in supply chains (4th ed.). CRC Press. [Google Scholar] [Crossref]
17. Syntetos, A. A., & Boylan, J. E. (2005). The accuracy of intermittent demand estimates. International Journal of Forecasting, 21(2), 303–314. https://doi.org/10.1016/j.ijforecast.2004.10.001 [Google Scholar] [Crossref]
18. Trapero, J. R., Holgado de Frutos, E., & Pedregal, D. J. (2024). Demand forecasting under lost sales stock policies. International Journal of Forecasting, 40(3), 1055–1068. https://doi.org/10.1016/j.ijforecast.2023.09.004 [Google Scholar] [Crossref]
19. Zhang, et al. (2020). Multi-criteria ABC classification. (Cited in 2024–2026 food inventory reviews). [Google Scholar] [Crossref]
20. Reviews and MSME food cases (2024–2026). Various studies in Indonesia, Peru, Mexico, and Nigeria. Journals and conference proceedings. [Google Scholar] [Crossref]
21. Note: Some entries from the SALSA table (particularly #18, #19 and #20) remain incomplete because full bibliographic details were not available in the source table; they should be completed or replaced with fully verifiable references before final submission. [Google Scholar] [Crossref]
Metrics
Views & Downloads
Similar Articles
- The Indirect Effect of Liquidity and Activity on Company Value with Profitability as an Intervening Variable
- Effect of Financial Skills, Knowledge, and Attitude on The Financial Behaviour of Clergy
- A Decade of Review: Trends in Budget Execution and Financial Performance of Development Projects in Tanzania (2014/15-2023/24)
- The Influence of Pre-Project Planning on the Budget Absorption Rate of Public Funded Infrastructure Projects in Kenya a Comparative Case Study of Narok, Migori, and Kisii County Government Projects
- Assessment of Factors Influencing Digital Transformation in Hotels’ Facility Management in Abuja Metropolis, Nigeria