IMPLEMENTASI METODE SIMPLE MOVING AVERAGE (SMA) MENGGUNAKAN PYTHON UNTUK PERAMALAN STOK OLI AHM

Herri Wijaya, Milad Naufal akbar, Fifi Endah Irawati

Abstract


Inefficient inventory management at Toko Mojo Pahit Motor frequently leads to overstocking and stockouts of AHM oil products, a challenge compounded by steadily increasing sales. This study aims to implement the Simple Moving Average forecasting method using Python to predict sales and provide data-driven recommendations for inventory optimization. The research employed a quantitative approach with a case study design, analyzing monthly sales data from 2021 to 2024. The Simple Moving Average method was tested with various time periods and evaluated using Mean Absolute Error to identify the most accurate model. The results indicated that the three-month period model achieved the highest accuracy, yielding a Mean Absolute Error of 18.52. Based on the forecasts from this model, a re-order point of 42 units is recommended, providing a quantitative basis for procurement decisions. The primary limitation of this method is its inability to directly respond to external factors. It is concluded that implementing the Simple Moving Average method with Python offers an effective and practical solution for Toko Mojo Pahit Motor. It is recommended that the store regularly updates its forecasts to maintain accuracy.

Full Text:

PDF

References


Dewi, S. K., and W. Jatmiko. 2023. “Sistem Rekomendasi Manajemen Persediaan Berbasis Hasil Peramalan Untuk Optimalisasi Stok.” Jurnal Sistem Cerdas 6(3):210–21.

Gunawan, D., and R. Setiawan. 2024. “Otomatisasi Peramalan Penjualan Menggunakan Python Dengan Library Pandas Dan Matplotlib.” Jurnal Pengembangan Teknologi Informasi Dan Ilmu Komputer 8(1):450–59.

Hidayat, R., and A. Wibowo. 2022. “Analisis Pengaruh Ketersediaan Produk Terhadap Keberlanjutan Usaha Toko Ritel.” Jurnal Riset Ekonomi Dan Akuntansi 7(1):45–58.

Lestari, F., and M. A. Firmansyah. 2021. “Ketidakpastian Permintaan Dan Pengambilan Keputusan Persediaan Berbasis Intuisi: Studi Kasus UMKM.” Jurnal Ilmiah Manajemen 11(3):201–14.

Nugroho, A., and R. Abdullah. 2023. “Aplikasi Metode Peramalan Kuantitatif Untuk Pengambilan Keputusan Pengadaan Barang.” Jurnal Sistem Informasi Dan Operasi Manajemen 6(2):88–101.

Pratama, D., and I. P. Sari. 2023. “Peran Teknologi Dalam Peningkatan Efisiensi Manajemen Persediaan Pada UMKM Sektor Ritel.” Jurnal Manajemen Dan Bisnis Digital 4(2):112–25.

Putra, E. K., and B. Hartono. 2022. “Peningkatan Akurasi Perencanaan Rantai Pasok Melalui Model Peramalan Permintaan.” Jurnal Teknik Industri 24(1):75–86.

Rahman, A., and R. Fauzi. 2021. “Perbandingan Akurasi Metode Simple Moving Average Dan Weighted Moving Average Untuk Peramalan Jangka Pendek.” Jurnal Sains Data Dan Komputasi 2(1):22–31.

Santoso, B. 2024. “Dampak Overstock Dan Stockout Terhadap Arus Kas Dan Loyalitas Pelanggan.” Jurnal Logistik Dan Rantai Pasok 5(1):30–41.

Wijaya, H., and A. Susanto. 2020. “Implementasi Metode Simple Moving Average Untuk Peramalan Penjualan Produk Roti Pada Usaha Rumahan.” Jurnal Informatika Dan Teknologi 3(2):150–59.


Refbacks

  • There are currently no refbacks.