Citation :

Víctor Jesús Trejo-Aylas, José Luis De-Zela-Quispe, Juan Carlos Quiroz-Flores, "Real-Time Inventory Optimization Integrating ABC, Holt-Winters, EOQ/ROP, and RFID for Last-Mile Telecom Contractors," International Journal of Electronics and Communication Engineering, vol. 13, no. 4, pp. 20-34, 2026. Crossref, https://doi.org/10.14445/23488549/IJECE-V13I4P102

Abstract

Past research on last-mile inventory has approached the problems of forecasting, replenishment policy, and automatic identification as a series of independent solutions that limit the real-time control of dispersed telecom assets. In this studied warehouse, this fragmentation caused 26.6% stockouts, 80% accurate inventory, and 7.2-day replenishment times. This study presented an integrated optimization model comprising ABC prioritization, Holt-Winters seasonal forecasting, EOQ/ROP replenishment rules, and a low-cost RFID-Arduino dataset. Arena discrete-event simulation was used to simulate the model, @Risk performed probabilistic analyses, and functional RFID testing was used to demonstrate efficacy. The results produced 8% stockouts, 4-day replenishment time, 90% inventory accuracy, and a coverage index of 3.79 days (greater means better). The findings increased reinforcement of service continuity, financial resources could be released for reinvestment, and the responsiveness of the operational environment could be improved. For future research, this integrated approach should be presented in other asset-intensive service sectors, and further research into scalability and Sustainability should be conducted in the context of more demanding parameters and levels of volatility.

Keywords

Real-Time Inventory Management, Last-Mile Logistics, Telecommunications Supply Chain, Inventory Optimization, Holt-Winters Forecasting, RFID-Based Inventory Systems.

References

1. “Monthly Index of the National Production (Seasonally Adjusted Figures),” National Institute of Statistics and Informatics, Technical Report, pp. 1-13, 2024.
   [Publisher Link]
2. Peru: Country Regulation Overview – 2025, OSIPTEL, 2025. [Online]. Available: https://omdia.tech.informa.com/om136034/peru-country-regulation-overview--2025
3. “Living Conditions in Peru,” National Institute of Statistics and Informatics, Report, pp. 1-82, 2024.
   [Publisher Link]
4. “Financial Performance Analysis of the Telecommunications Sector from January to September 2024,” OSIPTEL, pp. 1-22, 2024.
   [Publisher Link]
5. “Peru Telecom Tower Market Size & Share Analysis - Growth Trends and Forecast (2026 - 2031),” Mordor Intelligence Industry Report, 2025.
   [Publisher Link]
6. Ministry of Transport and Communications, “MTC: National Fiber Optic Backbone Network Increased its Contracted Capacity by 195%,” 2024.
   [Publisher Link]
7. Peru: Mobile Market Grew 3.28% at the End of 2024 and Reached 42.70 Million Lines, OSIPTEL, [Online]. Available: https://www.osiptel.gob.pe/portal-del-usuario/noticias/peru-mercado-movil-crecio-3-28-al-cierre-de-2024-y-alcanzo-las-42-70-millones-de-lineas/
8. 19 Inventory Management Statistics and Industry Benchmarks for 2024, Unleashed Software, 2024. [Online]. Available: https://www.unleashedsoftware.com/blog/inventory-management-statistics/
9. Half of Retailers Say Out-of-stock Items will be the Biggest Challenge in 2023, SML, 2023. [Online]. Available: https://www.sml.com/half-of-retailers-say-out-of-stock-items-will-be-biggest-challenge-in-2023/
10. The Monthly Metric: Inventory Accuracy Rate, Institute for Supply Management, 2024. [Online]. Available: https://www.ismworld.org/supply-management-news-and-reports/news-publications/inside-supply-management-magazine/blog/2024/2024-03/the-monthly-metric-inventory-accuracy-rate/
11. Telefónica, “Consolidated Management Report,” pp. 1-394, 2025.
    [Publisher Link]
12. Stockouts in Retail: A Drawback to the Customer Experience, kaizen Institute Insights. [Online]. Available: https://kaizen.com/es/insights-es/roturas-stock-producto-retail-es/
13. The True Cost of a Back Order, F. Curtis Barry & Company. [Online]. Available: https://www.fcbco.com/blog/the-true-cost-of-a-back-order
14. Navigating the Storm: The Impact of Network Disruptions on Telecom Carriers, VC4. [Online]. Available: https://www.vc4.com/blog/navigating-the-storm-the-impact-of-network-outages-on-telecom-carriers/
15. 85% of Telcos had Projects Delayed by Supply Chain Issues, Telecoms Tech News, 2023. [Online]. Available: https://www.telecomstechnews.com/news/85-of-telcos-projects-delayved-supply-chain-issues/
16. 85% of Telecom Operators had Project Timelines Disrupted Due to Supply Chain Issues, Digitalisation World, 2023. [Online]. Available: https://www.telecomstechnews.com
17. Nima Pourmohammadreza et al., “Last-Mile Logistics with Alternative Delivery Locations: A Systematic Literature Review,” Results in Engineering, vol. 25, pp. 1-15, 2025.
    [CrossRef] [Google Scholar] [Publisher Link]
18. Vasiliki Balaska et al., “A Viewpoint on the Challenges and Solutions for Driverless Last-Mile Delivery,” Machines, vol. 10, no. 11, pp. 1-15, 2022.
    [CrossRef] [Google Scholar] [Publisher Link]
19. Andreas Karaoulanis, “The Role of Micro Fulfilment Centers in Alleviating, in a Sustainable Way, the Urban Last Mile Logistics Problem: A Systematic Literature Review,” Sustainability, vol. 16, no. 20, pp. 1-25, 2024.
    [CrossRef] [Google Scholar] [Publisher Link]
20. Fan Liu, and Ning Ma, “Multicriteria ABC Inventory Classification using Social Choice Theory,” Sustainability, vol. 12, no. 1, pp. 1-19, 2020.
    [CrossRef] [Google Scholar] [Publisher Link]
21. Alaa Asim Qaffas et al., “An Explainable Artificial Intelligence Approach for Multicriteria ABC Item Classification,” Journal of Theoretical and Applied Electronic Commerce Research, vol. 18, no. 2, pp. 848-866, 2023.
    [CrossRef] [Google Scholar] [Publisher Link]
22. Yiheng Lin, “Application of ABC Analysis and Linear Regression Model in Inventory Management,” Proceedings of the 8^th International Conference on Economic Management and Green Development, vol. 126, pp. 111-119, 2024.
    [CrossRef] [Publisher Link]
23. Yash Khanorkar, and P.V. Kane, “Selective Inventory Classification using ABC Classification, Multi-Criteria Decision Making Techniques, and Machine Learning Techniques,” Materials Today: Proceedings, vol. 72, pp. 1270-1274, 2023.
    [CrossRef] [Google Scholar] [Publisher Link]
24. Clara Della Evania, and Bakti Siregar, “Comparison of Holt-Winters and SARIMA Methods using Foreign Tourist Visit Data in Bali,” Journal of Mathematics Computations and Statistics, vol. 7, no. 2, pp. 350-359, 2024.
    [Google Scholar]
25. Irina Kochetkova et al., “Short-Term Mobile Network Traffic Forecasting using Seasonal ARIMA and Holt-Winters Models,” Future Internet, vol. 15, no. 9, pp. 1-15, 2023.
    [CrossRef] [Google Scholar] [Publisher Link]
26. Güzin Tirkeş, Cenk Güray, and Neşe Çelebi, “Demand Forecasting: A Comparison between the Holt-Winters, Trend Analysis and Decomposition Models,” Trend Analysis and Decomposition Models, vol. 24, no. 2, pp. 503-509, 2017.
    [CrossRef] [Google Scholar] [Publisher Link]
27. Ansari Saleh Ahmar et al., “The Implementation of the Holt-Winters Method to Forecast Loan Interest Rates in Indonesia,” Quantitative Economics and Management Studies, vol. 5, no. 3, pp. 494-499, 2024.
    [CrossRef] [Google Scholar] [Publisher Link]
28. Lalji Kumar, Sudhakar Khedlekar, and U.K. Khedlekar, “A Comparative Assessment of Holt Winter Exponential Smoothing and Autoregressive Integrated Moving Average for Inventory Optimization in Supply Chains,” Supply Chain Analytics, vol. 8, pp. 1-16, 2024.
    [CrossRef] [Google Scholar] [Publisher Link]
29. Albert Budiyanto, and Muhammad Muslim, “Optimizing Inventory Systems with RFID: A Narrative Review,” Sinergi International Journal of Logistics, vol. 2, no. 2, pp. 133-146, 2024.
    [CrossRef] [Google Scholar] [Publisher Link]
30. Sri Valli Aluguri et al., “RFID Based Inventory Management System,” International Journal for Research in Applied Science & Engineering Technology, vol. 11, no. 10, pp. 1363-1369, 2023.
    [CrossRef] [Google Scholar] [Publisher Link]
31. Zhongheng Sun et al., “An Intelligent Cargo/Warehouse Management System,” Proceedings of the International Conference on Artificial Life and Robotics, Oita, Japan, pp. 818-822, 2024.
    [Google Scholar]
32. Imasha Bandara, Oluyomi Simpson, and Yichuang Sun, “Optimizing Efficiency Using a Low-Cost RFID-Based Inventory Management System,” 2024 International Wireless Communications and Mobile Computing (IWCMC), Ayia Napa, Cyprus, pp. 1729-1733, 2024.
    [CrossRef] [Google Scholar] [Publisher Link]
33. Yasaman Mashayekhy et al., “Impact of Internet of Things on Inventory Management: A Literature Survey,” Logistics, vol. 6, no. 2, 1-19, 2022.
    [CrossRef] [Google Scholar] [Publisher Link]
34. Heribertus Ary Setyadi, Budi Al Amin, and Pudji Widodo “Implementation Economic Order Quantity and Reorder Point Methods in Inventory Management Information Systems,” Journal of Information Systems and Informatics, vol. 6, no. 1, pp. 103-117, 2024.
    [CrossRef] [Google Scholar] [Publisher Link]
35. Dariusz Milewskia, and Tomasz Wiśniewski, “Regression Analysis as an Alternative Method of Determining the Economic Order Quantity and Reorder Point,” Heliyon, vol. 8, no. 9, pp. 1-9, 2022.
    [CrossRef] [Google Scholar] [Publisher Link]
36. Bo Liang et al., “RF-CHORD: Towards Deployable RFID Localization System for Logistics Network,” arXiv, pp. 1-17, 2022.
    [CrossRef] [Google Scholar] [Publisher Link]‌