COMPARATIVE ANALYSIS OF MOVING AVERAGE AND DOUBLE EXPONENTIAL SMOOTHING METHODS FOR FORECASTING ASTM A252 GR 2 PIPE DEMAND AT PT XYZ

Ardita Dwi Agustin, Ade Momon S, Agustian Suseno, Wildan Fatchan Maulidin

Abstract

Raw material inventory planning is a crucial aspect in the manufacturing industry to ensure smooth production and cost efficiency. However, PT XYZ has not implemented a forecasting method in its raw material planning system, so that procurement decisions are still reactive to actual demand. This study aims to analyze and compare forecasting methods using Double Exponential Smoothing (DES) and Moving Average (MA) to determine the most accurate method in projecting raw material needs for Non-API spec pipe products, type ASTM A252 GR 2 at KT 24 PT XYZ. The data used is historical demand data, which is then analyzed using POM-QM for Windows software. The results of the analysis show that the Moving Average method with a two-month period (MA-2) has the smallest Mean Squared Error (MSE), which is 182067, and a Mean Absolute Percentage Error (MAPE) value of 1.24%, which indicates a higher level of accuracy than other methods. Thus, the MA-2 method is recommended to be implemented in PT XYZ's raw material planning system to improve production efficiency and reduce the risk of excess or shortage of stock. For further research, it is recommended to develop a forecasting model by considering external factors such as market trends and seasonality, and integrating machine learning or hybrid forecasting methods to improve prediction accuracy. In addition, the implementation of an Enterprise Resource Planning (ERP)-based system with a forecasting module can also be a solution for long-term planning efficiency.

Keywords

Forecasting, Double Exponential Smoothing, Moving Average, POM-QM, Inventory Planning

Full Text:

PDF

References

Abdy, M., Thaha, I. And Lukman, F. (2023) ‘Penggunaan Metode Double Exponential Smoothing Dalam Meramalkan Indeks Harga Konsumen (Ihk) Di Kota Makassar’, Journal Of Mathematics: Theory And Applications, 5(2), Pp. 61–66. Available At: Https://Doi.Org/10.31605/Jomta.V5i2.2874.

Anastasya Bernike Br Ginting Et Al. (2024) ‘Metode Material Requirement Planning (Mrp) Dalam Perencanaan Produksi Sirup Markisa Dewi’, Jurnal Arjuna : Publikasi Ilmu Pendidikan, Bahasa Dan Matematika, 2(4), Pp. 246–269. Available At: Https://Doi.Org/10.61132/Arjuna.V2i4.1102.

Apriosa, S.I., Orisa, M. And Rudhistiar, D. (2024) Analisa Metode Double Exponential Smothing Untuk Prediksi Penjualan Obat Pertanian Di Toko Mitra Pajapro, Jurnal Mahasiswa Teknik Informatika.

Asmaradana, A.A., Widodo, E. And Artikel, R. (2023) Penerapan Metode Peramalan Double Exponential Smoothing Pada Indeks Harga Konsumen Kota Yogyakarta P-Issn E-Issn, Emerging Statistics And Data Science Journal. Available At: Https://Jogjakota.Bps.Go.Id/.

Azahra, N. Et Al. (2022) ‘Peramalan Jumlah Produksi Tebu Menggunakan Metode Time Series Model Moving Averages’, Jurikom (Jurnal Riset Komputer), 9(4), P. 840. Available At: Https://Doi.Org/10.30865/Jurikom.V9i4.4388.

Azkiya, A. Et Al. (2023) ‘Analisis Peramalan Penjualan Produk X Pada Perusahaan Xyz Menggunakan Metode Double Exponential Smoothing Forecasting Analysis Of Product X Sales At Company Xyz Using Double Exponential Smoothing Method’, 22(2).

Dinanti, D. And Suryati (2023) ‘Analisis Perbandingan Metode Double Moving Average Dengan Double Exponential Smoothing Pada Peramalan Harga Saham Perbankan’, 6(1), Pp. 105–112.

Indah Vindari, Z. Et Al. (2023) ‘Analisis Peramalan Permintaan Pada Part Arm Rear Brake Kwbf Di Pt Ciptaunggul Karya Abadi’, Viii(1).

Khadarusman, R., Kusrini And Kusnawi (2024) ‘Penerapan Metode Moving Average Untuk Memprediksi Stok Parfum’, Bit-Tech, 7(1), Pp. 104–112. Available At: Https://Doi.Org/10.32877/Bt.V7i1.1563.

Lusiana, A. And Yuliarty, P. (2020) ‘Penerapan Metode Peramalan (Forecasting) Pada Permintaan Atap Di Pt X’.

Marlim, Y.N. And Hajjah2, A. (2021) ‘Sistem Peramalan Persediaan Barang Menggunakan Metode Brown Exponential Smoothing’, Joisie Journal Of Information System And Informatics Engineering, 5(2), Pp. 146–152.

Rahman Lutfi, F. And Sasongko, C. (2022) ‘Perencanaan Produksi Dan Manajemen Persediaan Pada Perusahaan Kue Dan Roti’, Studi Akuntansi Dan Keuangan Indonesia, 5(1).

Reyhan, O.:, Purwoko, A. And Yudhistira, A.A. (2024) ‘Pt. Media Akademik Publisher Implementasi Stock Opname Persediaan Bahan Baku Di Pt Juara Langkah Jaya’, Jma), 2, Pp. 3031–5220. Available At: Https://Doi.Org/10.62281.

Rodiah, D. (2022) Jurnal Informatika Dan Rekayasa Komputer (Jakakom) Peramalan Produksi Pempek Dengan Metode Moving Average Dan Exponential Smoothing. Available At: Http://Ejournal.Unama.Ac.Id/Index.Php/Jakakom.

Sari, N. (2022) ‘Perencanaan Dan Pengendalian Persediaan Barang Dalam Upaya Meningkatkan Efektivitas Gudang’, Jurnal Bisnis, Logistik Dan Supply Chain (Blogchain), 2(2), Pp. 85–91. Available At: Https://Doi.Org/10.55122/Blogchain.V2i2.542.

Sebastian Rudi, W., Agus Pranoto, Y. And Xaverius Ariwibisono, F. (2023) Penerapan Metode Regresi Linier Dalam Peramalan Penjualan Kue Di Toko Karya Bahari Samarinda Berbasis Website, Jurnal Mahasiswa Teknik Informatika.

Syaddyah, A.Y., Ratnawati, V. And Wahyuni, N. (2020) ‘Pengaruh Asimetri Informasi, Perencanaan Pajak, Dan Kompensasi Bonus Terhadap Manajemen Laba’, 1(2), Pp. 2722–5437. Available At: Http://Ejournal.Uin-Suska.Ac.Idjournalhomepage:Http://Ejournal.Uin-Suska.Ac.Id/Index.Php/Jot/.

Sylvia (2023) ‘Aplikasi Model Peramalan Moving Average Dan Exponential Smoothing Untuk Penjualan Produk Minuman Di Cv. Gatsu Jaya Perkasa Abadi’.

Yusta, O.: Et Al. (2023) Analysis Of Sales Forecasting In Raw Material Inventory Management At Sun Cafe, Oktober.

DOI: https://doi.org/10.33536/jiem.v9i3.1897

Refbacks



Bookmark and Share