Efektivitas Metode Least Squares dan Double Moving Average dalam Mendukung Pengambilan Keputusan Persediaan

Main Article Content

Yance Sonatha
Humaira
Teten Dwi Rahmi Kiflinda

Abstract

Penelitian ini bertujuan membandingkan tingkat akurasi metode Least Square (LS) dan Double Moving Average (DMA) dalam meramalkan permintaan persediaan pada Toko Online Telaten Karya, sebuah usaha ritel daring bahan bangunan yang selama ini mengambil keputusan persediaan berdasarkan intuisi. Penelitian menggunakan pendekatan kuantitatif berbasis analisis deret waktu terhadap data penjualan bulanan selama dua belas bulan, dengan tingkat akurasi dievaluasi menggunakan Mean Absolute Percentage Error (MAPE). Hasil menunjukkan metode Least Square (LS) menghasilkan MAPE sebesar 15,00% (kategori akurasi baik), sedangkan metode Double Moving Average (DMA) menghasilkan MAPE sebesar 54,13% (kategori akurasi rendah), sekitar tiga setengah kali lebih tinggi. Kinerja Least Square (LS) yang lebih unggul sejalan dengan pola tren penjualan yang meningkat secara bertahap, sementara proses double smoothing pada DMA justru menimbulkan bias ke arah nilai yang lebih tinggi. Metode Least Square (LS) direkomendasikan sebagai dasar perencanaan persediaan pada UMKM tersebut.


This study compares the forecasting accuracy of the Least Squares (LS) and Double Moving Average (DMA) methods for supporting inventory demand planning at Toko Online Telaten Karya, an online retailer of building materials that previously relied on intuition-based inventory decisions. A quantitative time-series approach was applied to twelve months of monthly sales data, with forecasting accuracy evaluated using the Mean Absolute Percentage Error (MAPE). The results show that the LS method achieved a MAPE of 15.00%, classified as good accuracy, while the DMA method produced a MAPE of 54.13%, classified as poor accuracy, roughly three and a half times higher. The superior performance of LS aligns with the gradually increasing sales trend in the data, whereas the double-smoothing process in DMA introduced an upward bias. The LS method is recommended as the basis for inventory planning in this small online retail business.

Article Details

How to Cite
Sonatha, Y., Humaira, & Teten Dwi Rahmi Kiflinda. (2025). Efektivitas Metode Least Squares dan Double Moving Average dalam Mendukung Pengambilan Keputusan Persediaan. MSI Transaction on Education, 6(3), 165-176. https://doi.org/10.46574/mted.v6i3.198

References

[1] D. P. Anggraeni, "Optimisation of inventory management through time series analysis of inventory data with double exponential smoothing method," Journal of Computer Networks, Architecture and High Performance Computing, vol. 6, no. 3, pp. 1693–1700, Jul. 2024, doi: 10.47709/cnahpc.v6i3.4410.
[2] S. Yondri, D. Meidelfi, T. Lestari, F. Sukma, and I. S. Mutia, "Comparative analysis of the least squares method and double moving average technique for forecasting product inventory," Teknomekanik, vol. 7, no. 1, pp. 74–84, Jun. 2024, doi: 10.24036/teknomekanik.v7i1.29672.
[3] T. M. Fahrudin, R. P. Ambariawan, and M. Kamisutara, "Demand forecasting of the automobile sales using least square, single exponential smoothing and double exponential smoothing," Petra International Journal of Business Studies, vol. 4, no. 2, pp. 122–130, Dec. 2021, doi: 10.9744/ijbs.4.2.122-130.
[4] D. Li and S. Xu, "CSD-LSSVR-based inventory demand forecasting for warehouse-distribution integrated SMEs," Informatica, vol. 49, no. 9, pp. 343–358, 2025, doi: 10.31449/inf.v49i9.8382.
[5] F. Firmansyah, A. Fatharani, and U. Anis, "Forecasting using the time series forecasting model at SMEs Pempek Dang Tirta, Banyumas, Central Java," Jurnal Teknologi Agro-Industri, vol. 11, no. 2, pp. 91–103, Nov. 2024, doi: 10.34128/jtai.v11i2.199.
[6] T. Regina and P. Jodiawan, "Proposed improvement of forecasting using time series forecasting of fast moving consumer goods," JIEMS (Journal of Industrial Engineering and Management Systems), vol. 14, no. 1, pp. 38–54, Oct. 2021, doi: 10.30813/jiems.v14i1.2418.
[7] V. W. Nirmala, D. Harjadi, and R. Awaluddin, "Sales forecasting by using exponential smoothing method and trend method to optimize product sales in PT. Zamrud Bumi Indonesia during the COVID-19 pandemic," International Journal of Engineering, Science and Information Technology, vol. 1, no. 4, pp. 59–64, Aug. 2021, doi: 10.52088/ijesty.v1i4.169.
[8] D. R. Cahyadewi, A. A. P. A. S. Wiranatha, and I. K. Satriawan, "Analisis peramalan permintaan dan pengendalian persediaan bahan baku body scrub powder di CV. Denara Duta Mandiri," Jurnal Rekayasa dan Manajemen Agroindustri, vol. 8, no. 3, pp. 360–370, Sep. 2020, doi: 10.24843/JRMA.2020.v08.i03.p05.
[9] Ma. del R. C. Estrada, M. E. G. Camarillo, F. P. Villaseñor, A. E. Domínguez, and M. J. C. Gómez, "Assessment of the sales forecast technique double-weighted moving average vs. other widely used forecasting techniques," International Journal of Business Administration, vol. 11, no. 2, pp. 39–48, Mar. 2020, doi: 10.5430/ijba.v11n2p39.
[10] Y. Fatman, S. A. Majapahit, and M. F. Ramadhan, "A linear regression model for deploying a cognitive web for an inventory prediction system," Journal of Intelligent Computing and Health Informatics, vol. 4, no. 1, pp. 1–8, Feb. 2023, doi: 10.26714/jichi.v4i1.11258.
[11] H. Hasbullah and Y. Santoso, "Overstock improvement by combining forecasting, EOQ, and ROP," Jurnal PASTI (Penelitian dan Aplikasi Sistem dan Teknik Industri), vol. 14, no. 3, pp. 230–239, 2021, doi: 10.22441/pasti.2020.v14i3.002.
[12] A. A. P. Arnaiz, L. S. Cristal, A. O. Fernandez, M. R. F. Gubaton, D. V. Tanael, and C. J. Centeno, "Optimizing inventory management and demand forecasting system using time series algorithm," World Journal of Advanced Research and Reviews, vol. 20, no. 3, pp. 21–32, Dec. 2023, doi: 10.30574/wjarr.2023.20.3.2456.
[13] I. I. Almaraj and M. S. A. Ghamdi, "Adopting new ARIMA double layering technique in make-to-stock production policy," Decision Science Letters, vol. 13, no. 2, pp. 315–328, 2024, doi: 10.5267/j.dsl.2024.2.005.
[14] R. Ternero, J. P. Sepúlveda-Rojas, M. Alfaro, G. Fuertes, and M. Vargas, "Inventory management with stochastic demand: Case study of a medical equipment company," South African Journal of Industrial Engineering, vol. 34, no. 1, pp. 165–178, Jan. 2023, doi: 10.7166/34-1-2668.
[15] M. Hasni, M. Z. Babai, and B. Rostami-Tabar, "A hybrid LSTM method for forecasting demands of medical items in humanitarian operations," International Journal of Production Research, vol. 62, no. 17, pp. 6046–6063, 2024, doi: 10.1080/00207543.2024.2306904.
[16] T. B. Affonso, S. V. Conceição, L. R. Muniz, J. F. de Freitas Almeida, and J. C. de Lima, "A new hybrid forecasting method for spare part inventory management using heuristics and bootstrapping," Decision Analytics Journal, vol. 10, Art. no. 100415, Mar. 2024, doi: 10.1016/j.dajour.2024.100415.