Published: 2026-04-25

Forecasting Accuracy Analysis of Catering Raw Material Stock Using Simple Exponential Smoothing Based on Mean Absolute Percentage Error (MAPE)

DOI: 10.35870/ijsecs.v6i1.7039

Dimas Eko Prasetyo, Endin Fahrudin
  • Dimas Eko Prasetyo: Universitas Pamulang ROR
  • Endin Fahrudin: Universitas Pamulang ROR
No Cover Available
Article Metrics
Share:

Abstract

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.

Keywords

Simple Exponential Smoothing; Forecasting; Inventory Management; MAPE; Catering Industry

Peer Review Process

This article has undergone a double-blind peer review process to ensure quality and impartiality.

Indexing Information

Discover where this journal is indexed at our indexing page.

Open Science Badges

This journal supports transparency in research and encourages authors to meet criteria for Open Science Badges.

How to Cite

Prasetyo, D. E., & Fahrudin, E. (2026). Forecasting Accuracy Analysis of Catering Raw Material Stock Using Simple Exponential Smoothing Based on Mean Absolute Percentage Error (MAPE). International Journal Software Engineering and Computer Science (IJSECS), 6(1), 338-352. https://doi.org/10.35870/ijsecs.v6i1.7039
Article Information

This article has been peer-reviewed and published in the International Journal Software Engineering and Computer Science (IJSECS). The content is available under the terms of the Creative Commons Attribution 4.0 International License.

  • Issue: Vol. 6 No. 1 (2026)

  • Section: Articles

  • Published: 2026-04-25

AI Research Hub

This article is indexed and available through various AI-powered research tools and citation platforms. Our AI Research Hub ensures that scholarly work is discoverable, accessible, and easily integrated into the global research ecosystem.

Semantic Scholar Scite Dimensions Connected Papers
Scholarly Connection Platforms
Dimensions Dimensions Connected Papers Connected Papers Scite Scite Google Scholar Google Scholar Semantic Scholar Semantic Scholar Garuda Garuda Scilit Scilit Crossref Crossref BASE BASE Zenodo Zenodo Unpaywall Unpaywall OpenCitations OpenCitations
Author Biographies
Dimas Eko Prasetyo, Universitas Pamulang
Google Scholar ResearchGate ORCID

Department of Information System, Universitas Pamulang, South Tangerang City, Banten Province, Indonesia

Endin Fahrudin, Universitas Pamulang
Google Scholar ResearchGate ORCID

Department of Information System, Universitas Pamulang, South Tangerang City, Banten Province, Indonesia

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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • Athanasopoulos, G., & Hyndman, R. J. (2021). Forecasting: Principles and practice (3rd ed.). OTexts. https://otexts.com/fpp3/
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • Kingrungphet, N., & Buddhakulsomsiri, J. (2025). Demand forecasting in the supply chain: Case study of a Bangladeshi retailer [Doctoral dissertation, Thammasat University]. Thammasat University Library.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • Prasetyo, E. (2014). Data mining: Mengolah data menjadi informasi menggunakan MATLAB. Andi Offset.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
License & Copyright
Creative Commons License

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.

Downloads