Analysis Of Demand Forecasting For Top Sales Products During The Month Of Ramadan In The Frozen Dairy Category Using The Single Exponential Smoothing (SES), Single Moving Average (SMA), And Double  Moving Average (DMA) Methods

Hanun Hakim Wibowo; Anjar Priyono

doi:10.63922/ijebir.v5i01.2748

Hanun Hakim Wibowo Department of Management, Department of Management, Faculty of Business and Economics University of Islam Indonesia, Indonesia.
Anjar Priyono Department of Management, Department of Management, Faculty of Business and Economics University of Islam Indonesia, Indonesia.

DOI: https://doi.org/10.63922/ijebir.v5i01.2748

Keywords: Demand Forecasting, Single Exponential Smoothing, Single Moving Average, Double Moving Average, Mean Absolute Percentage Error

Abstract

Demand patterns tend to change when entering seasonal periods such as Ramadan, so accurate demand forecasting is needed to ensure that the supply chain runs optimally. Hypermart Pakuwon Mall Yogyakarta experienced out of stock and overstock for several of its products at the start of Ramadan, indicating that more accurate forecasting results are needed to prevent this from happening again. This study aims to find the best demand forecasting method for Hypermart Pakuwon Mall Yogyakarta. This study compares demand forecasting methods for top-selling dairy frozen products during Ramadan using the Single Exponential Smoothing (SES), Single Moving Average (SMA), and Double Moving Average (DMA) methods. The forecasting results of each method are then measured using Mean Absolute Percentage Error (MAPE). If a forecasting method produces the smallest MAPE value, it can be said to be the best forecasting method. The results show that the Double Moving Average Order 12 method has the smallest MAPE value of 17.36%. In this case, the Double Moving Average Order 12 method is the best 2 method to use for forecasting com

References

Aji, F. (2024). Role Of Supply Chain Management In The Production System Company And Operations. Dinamik. https://doi.org/10.35315/dinamik.v29i2.9269
Alex, M. A. H., & Rahmawati, N. (2023). Application of the single moving average, weighted moving average and exponential smoothing methods for forecasting demand at boy delivery. Tibuana, 6(1), 32-37.
Ali, Dawit. (2019). Assessment of the Effect of out-of-Stock on Customers Purchasing Behavior. International Journal of Transportation Engineering and Technology.
Badan Pengawas Obat dan Makanan. (2024). Intensifikasi Pengawasan Pangan, Maksimalkan Perlindungan Masyarakat Selama Ramadhan dan Idulfitri. Available at https://www.pom.go.id/siaran-pers/intensifikasi-pengawasan-pangan-maksimalkan-perlindungan-masyarakat-selama-ramadan-dan-idulfitri (Accessed: 24 Mei 2025).
De Myttenaere, A., Golden, B., Le Grand, B., & Rossi, F. (2015). Using the Mean Absolute Percentage Error for Regression Models. The European Symposium on Artificial Neural Networks. https://hal.archives-ouvertes.fr/hal-01162980/document
Dewantara, R., & Giovanni, J. (2023). Analisis peramalan item penjualan dalam optimalisasi stok menggunakan metode least square. Krisnadana Journal, 3(1), 59-66.
Heizer, Jay, Render, Barry, Munson, Chuck. (2017). Operations Management : Sustainability and Supply Chain Management 12th ed. (12th ed.). Boston: Pearson.
Khairina, D. M., Khairunnisa, R., Hatta, H. R., & Maharani, S. (2021). Comparison of the trend moment and double moving average methods for forecasting the number of dengue hemorrhagic fever patients. Bulletin of Electrical Engineering and Informatics, 10(2), 978-987.
Kusumawati, W. I. (2014). Peramalan Produksi Sarung Tenun Dengan Menggunakan Metode Pemulusan Data. Majalah Ekonomi, 18(2), 69-78.
Santoso, A. B., Rumetna, M. S., & Isnaningtyas, K. (2021). Penerapan Metode Single Exponential Smoothing Untuk Analisa Peramalan Penjualan. Jurnal Media Informatika Budidarma, 5(2), 756.
Ugih Rizqi, Zakka & Khairunisa, Adinda. (2020). Integration of deterministic and probabilistic inventory methods to optimize the balance between overstock and stockout. IOP Conference Series: Materials Science and Engineering.