Forecasting Accuracy Analysis of Catering Raw Material Stock Using Simple Exponential Smoothing Based on Mean Absolute Percentage Error (MAPE)
DOI:
https://doi.org/10.35870/ijsecs.v6i1.7039Keywords:
Simple Exponential Smoothing, Forecasting, Inventory Management, MAPE, Catering IndustryAbstract
In the catering industry, inaccurate inventory management often leads to significant food waste or stockouts due to highly volatile raw material demand, and conventional intuition-based procurement methods are no longer sufficient to maintain operational efficiency. This research applies to the Simple Exponential Smoothing (SES) algorithm to forecast raw material requirements and evaluates its accuracy using the Mean Absolute Percentage Error (MAPE) metric. Twelve months of historical transaction data from a local catering business were analyzed, categorized into basic commodities, proteins, and vegetables, with the SES model calibrated by testing smoothing constants ( ) across the range of 0.1 to 0.9. The findings indicate that stable items such as rice achieve the highest accuracy at a low of 0.2, yielding a MAPE of 4.25% — classified as Very Good. Highly volatile items such as proteins and fresh vegetables require a high of 0.8–0.9 to remain responsive, producing MAPE values between 12.40% and 18.15%, classified as Good. These results confirm that SES offers a defensible, data-grounded decision-making structure that measurably reduces forecasting errors and improves procurement cost management in the catering sector.
Downloads
References
Ainun, Q., Sutisna, F. I., Andini, L., & Kinari, I. (2025). A hybrid exponential smoothing distribution requirement planning framework for sustainable distribution optimization in a traditional food Rengginang. Jurnal Riset Ilmu Teknik, 3(2), 112–124. https://doi.org/10.59976/jurit.v3i2.204
Ali-Mohammed, A., & Hosein, P. (2024). An AI approach to SME inventory management. In Proceedings of the 2024 IEEE International Conference on Technology Management, Operations and Decisions (ICTMOD) (pp. 1–7). IEEE. https://doi.org/10.1109/ICTMOD63116.2024.10878175
Astuti, Y., Wulandari, I. R., Arridho, M. N., Seniwati, E., & Maulina, D. (2021). Alfa value scalability on single and double exponential smoothing comparatives. IJISTECH (International Journal of Information System and Technology), 5(4), 456–465. https://doi.org/10.30645/ijistech.v5i4.165
Athanasopoulos, G., & Hyndman, R. J. (2021). Forecasting: Principles and practice (3rd ed.). OTexts. https://otexts.com/fpp3/
Aziz, A. A., Mustaffa, Z., Ismail, S., Nor, N. A. M., & Fozi, N. Q. M. (2025). A hybrid simple exponential smoothing-barnacles mating optimization approach for parameter estimation: Enhancing COVID-19 forecasting in Malaysia. MethodsX, 14, Article 103347. https://doi.org/10.1016/j.mex.2025.103347
Bhat, A., Vidhathri, V., Hemachandra, C., Chaitra, V., Paladugula, L. S., & Srinivas, K. S. (2024). Predictive analysis of restaurant inventory: A study on stocking items based on popularity trends. In Proceedings of the 2024 17th International Conference on Advanced Computer Theory and Engineering (ICACTE) (pp. 345–352). IEEE. https://doi.org/10.1109/ICACTE62428.2024.10871751
Choi, J. G., Zhang, Y. W., & Nadzri, N. I. B. M. (2022). A review of forecasting studies for the restaurant industry: Focusing on results, contributions and limitations. Global Business & Finance Review, 27(2), 61–77. https://doi.org/10.17549/gbfr.2022.27.2.61
Chowdhury, A. R., Paul, R., & Rozony, F. Z. (2025). A systematic review of demand forecasting models for retail e-commerce enhancing accuracy in inventory and delivery planning. International Journal of Scientific Interdisciplinary Research, 6(1), 01–27. https://doi.org/10.63125/mbbfw637
Dmytryshyn, M. (2023). Development of a predictive model for sales forecasting of perishable food products [Bachelor's thesis, Ukrainian Catholic University]. UCU Electronic Repository. https://er.ucu.edu.ua
Filani, O. M., Olajide, J. O., & Osho, G. O. (2021). A statistical model for analyzing stock movement trends in small and medium-sized enterprises (SMEs). Complexity, 2021, Article 6. https://doi.org/10.1155/2021/5527717
Giannopoulos, P. G., Dasaklis, T. K., Tsantilis, J., & Patsakis, C. (2025). Machine learning algorithms in intermittent and lumpy demand forecasting: A review [Preprint]. SSRN. https://dx.doi.org/10.2139/ssrn.5231788
Guturu, I. S. (2024). Impact of seasonality on demand forecasting techniques for small-scale food retailers [Master's thesis, California State University San Bernardino]. ScholarWorks. https://scholarworks.lib.csusb.edu/etd/1914
Jahin, M. A., Shovon, M. S. H., Shin, J., Ridoy, I. A., & Mridha, M. F. (2024). Big data—supply chain management framework for forecasting: Data preprocessing and machine learning techniques. Archives of Computational Methods in Engineering, 31(6), 3619–3645. https://doi.org/10.1007/s11831-024-10092-9
Junthopas, W., & Wongoutong, C. (2023). Setting the initial value for single exponential smoothing and the value of the smoothing constant for forecasting using solver in Microsoft Excel. Applied Sciences, 13(7), Article 4328. https://doi.org/10.3390/app13074328
Kingrungphet, N., & Buddhakulsomsiri, J. (2025). Demand forecasting in the supply chain: Case study of a Bangladeshi retailer [Doctoral dissertation, Thammasat University]. Thammasat University Library.
Kusuma, D. T., Purwanto, Y. S., Sudirman, M. Y. D., Fitriani, Y., & Saputra, A. L. (2023). Optimization of alpha parameters in single exponential smoothing method for forecasting coffee raw material stocks. In Proceedings of the 2023 International Conference on Networking, Electrical Engineering, Computer Science, and Technology (IConNECT) (pp. 207–212). IEEE. https://doi.org/10.1109/IConNECT56593.2023.10327187
Lakatua, R. D., Hetharie, J. A., & Manuhutu, K. I. (2025). Application of single exponential smoothing for sales forecasting: A data-driven approach to demand management. Public Policy: Jurnal Aplikasi Kebijakan Publik dan Bisnis, 6(2), 373–390.
Lase, F. A., Zai, K. S., Gea, J. B. I. J., & Mendrofa, M. S. D. (2025). Analysis of raw material inventory forecasting using the time series method in achieving profit in the integrated training and skills development business in Gunungsitoli. Journal of Management, Economic, and Accounting, 4(2), 765–778. https://doi.org/10.37676/jmea.v4i2.908
Lase, N. E., & Harefa, I. (2025). Analysis of tofu sales forecasting using the single exponential smoothing method at UD. Tahu Murni, Gunungsitoli City. EKOMBIS REVIEW: Jurnal Ilmiah Ekonomi dan Bisnis, 13(2), 1023–1032. https://doi.org/10.37676/ekombis.v13i2.7273
Lima, S., Gonçalves, A. M., & Costa, M. (2024). Predictive accuracy of time series models applied to economic data: The European countries retail trade. Journal of Applied Statistics, 51(9), 1818–1841. https://doi.org/10.1080/02664763.2023.2238249
Mutiara, V. Z., & Syah, E. H. (2025). Forecasting–inventory optimization model: Integrating exponential smoothing with min–max and blanket order systems for SMEs. Jurnal Riset Ilmu Teknik, 2(3), 187–197. https://doi.org/10.59976/jurit.v2i3.140
Nafisah, S., Najaf, A. R. E., & Ananto, P. K. F. (2025). Forecasting and raw material planning in traditional Songkok production using ARIMA and simple exponential smoothing. JUSIFO (Jurnal Sistem Informasi), 11(1), 31–42. https://doi.org/10.19109/jusifo.v11i1.27833
Omer, R. I., Hassan, R., & Aziz, M. S. A. (2025). A review and comparative analysis of predictive models for supply chain demand forecasting. In Proceedings of the 2025 10th International Conference on Information and Communication Technology for the Muslim World (ICT4M) (pp. 1–7). IEEE. https://doi.org/10.1109/ICT4M68001.2025.11363509
Patel, P. (2025). Time series forecasting in inventory management using R and Python. Journal of Applied Sciences, 5(11), 79–88. https://doi.org/10.5281/zenodo.17691499
Prasetyo, E. (2014). Data mining: Mengolah data menjadi informasi menggunakan MATLAB. Andi Offset.
Ravichandran, L., Kavirathna, C., Asanka, D., & Abhilashani, K. (2024). Demand forecasting for perishable products using data mining techniques: Systematic review. In Proceedings of the 2024 International Conference on Advances in Technology and Computing (ICATC) (pp. 1–6). IEEE. https://doi.org/10.1109/ICATC64549.2024.11025369
Sarjono, H., & Maesaroh, J. (2022). The effectiveness of simple time series implementation in the culinary industry: A systematic literature review. In Proceedings of the 2nd Indian International Conference on Industrial Engineering and Operations Management (pp. 1–10). IEOM Society.
Suryaningsih, S., Usman, F., Hidayat, N., & Pinjaman, S. (2025). Comparative forecasting models for optimizing MSME production: A time series analysis. Hasanuddin Economics and Business Review, 9(2), 86–97. https://doi.org/10.26487/hebr.v9i2.6333
Tundo, T., Saifullah, S., Dharmawan, T., Junaidi, J., & Devia, E. (2025). Seasonal meat stock demand used comparison of performance smoothing-average forecasting. Indonesian Journal of Electrical Engineering and Computer Science, 37(1), 625–633. https://doi.org/10.11591/ijeecs.v37.i1.pp425-433
Tyas, D. L., & Charifi, L. (2025). Forecasting monthly sales using single exponential smoothing: An evaluation and performance analysis. Journal of Computing Innovations and Emerging Technologies, 1(1), 11–15. https://doi.org/10.64472/jciet.v1i1.3
Wahedi, H. J., Heltoft, M., Christophersen, G. J., Severinsen, T., Saha, S., & Nielsen, I. E. (2023). Forecasting and inventory planning: An empirical investigation of classical and machine learning approaches for Svanehøj's future software consolidation. Applied Sciences, 13(15), Article 8581. https://doi.org/10.3390/app13158581
Wu, D. C., Zhong, S., Wu, J., & Song, H. (2025). Tourism and hospitality forecasting with big data: A systematic review of the literature. Journal of Hospitality & Tourism Research, 49(3), 615–634. https://doi.org/10.1177/10963480231223151
Yoo, S., & Park, M. (2025). Determining optimal data length for short-term business forecasting: An empirical study in catering services. Journal of International Logistics and Trade, 23(2), 118–130. https://doi.org/10.1108/JILT-09-2024-0068.
Downloads
Published
License
Copyright (c) 2026 Dimas Eko Prasetyo, Endin Fahrudin
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
