ANALYSIS OF PRODUCT STOCK INVENTORY FORECASTING USING WEIGHTED MOVING AVERAGE METHOD

Anita Rahayu; Arny  Lattu; Mupaat Mupaat

doi:10.20884/1.jutif.2022.3.6.421

Anita Rahayu Universitas Nusa Putra
Arny Lattu Fakultas Teknologi Informasi Dan Komputer, Program Studi Sistem Informasi, Universitas Nusa Putra, Indonesia
Mupaat Fakultas Teknologi Informasi Dan Komputer, Program Studi Sistem Informasi, Universitas Nusa Putra, Indonesia

DOI: https://doi.org/10.20884/1.jutif.2022.3.6.421

Keywords: Forcasting, Weighted Moving Average, Product Stock Inventory

Abstract

A company is said to be successful if it has fulfilled the demands of consumers in the future. cv. Aadiba company is engaged in sales services as a reseller by selling men's outdoor shoes. Problems with the company Cv. Aadiba, which is unable to meet consumer demand because they often experience a shortage of product stock, so far, planning for purchasing product stock is estimated manually based on previous experience and therefore this study aims to predict product stock inventory in order to minimize product stock purchases errors in the future period. and make the implementation of the forecasting system. The method used in the study is the Weighted Moving Average (WMA) method which can estimate the amount of stock that must be purchased for the future period. The data used for this research is sales data from January 2021 to April 2022, the moving average of the previous 3 months. Forecasting results using the Weighted Moving Average (WMA) method produce future sales of 612.5 and the error value of MAD is 104.448718, MSE 28380.712 and the MAPE value is 0.179160773% or 0.18% The smallest error value is considered the most appropriate used for forecasting, then the MAPE value is considered appropriate in forecasting because it has the smallest error value and the implementation of a forecasting system that can facilitate the Cv. Aadiba in terms of forecasting in the future period.

Downloads

Download data is not yet available.

References

S. Wardah and I. Iskandar, “Analisis Peramalan Pisang Kemasan Bungkus (Studi Kasus : Home Industry Arwana Food Tembilahan),” J@ti Undip J. Tek. Ind., vol. 11, no. 3, p. 135, 2017, doi: 10.14710/jati.11.3.135-142.

N. Nafi’iyah, “Analisis Peramalan Stok Barang dengan Metode Weight Moving Average dan Double Exponential Smoothing pada Jovita Ms Glow Lamongan,” J. Intell. Syst. Comput., vol. 1, no. 1, pp. 39–42, 2019, doi: 10.52985/insyst.v1i1.23.

Saputra, “Rancang Bangun Aplikasi Peramalan Persedian Stok Barang Menggunakan Metode Weighted Moving Average (WMA) Pada Toko XYZ,” J. Tek. Inform. Vol. 13, No. 3, Agustus 2021, vol. 13, no. 3, pp. 1–9, 2021.

A. Nasution, “Forecasting Produksi Karet Menggunakan,” vol. 9986, no. September, 2018.

Z. Silvya, A. Zakir, and D. Irwan, “Penerapan Metode Weighted Moving Average Untuk Peramalan Persediaan Produk Farmasi,” Jitekh, vol. 8, no. 2, pp. 69–74, 2020.

S. Ramayani and M. Iqbal, “Forcasting Of Fertilizier Inventory In UD Menara Tani With Weighted Moving Average And DOuble Exponential Smoothing,” J. Teknol. Inf. dan Komput., vol. 3, no. 3, 2022.

J. Mayani, S. Hasibuan, R. Tama, and A. Agus, “Forecasting of Yamaha Motorcycle Sales Using the Weighted Moving Average ( Wma ) Web-Based Forecasting Penjualan Sepeda Motor Yamaha Dengan Menggunakan Metode Weighted Moving Average ( Wma ) Berbasis,” J. Teknol. Inf. dan Komput., 3, no. 2, 2022.

S. Mulyani, D. Hayati, and A. N. Sari, “Analisis Metode Peramalan (Forecasting) Penjualan Sepeda Motor Honda Dalam Menyusun Anggaran Penjualan Pada Pt Trio Motor Martadinata Banjarmasin,” J. Ekon. dan Bisnis, vol. 14, no. 1, pp. 178–188, 2021.

C. Anwar, H. Irwan, D. Redantan, P. Studi Teknik Industri Universitas Riau Kepulauan Batam Jl Batu Aji baru, and K. Riau, “Pengendalian Persediaan Cell Baterai Lithium Polymer Revolectrix Untuk Menghilangkan Kekosongan Stok (Out Of stock) Dengan Metode MRP (Studi Kasus DI PT. LEO ENERGY),” PROFICIENSI J. Ind. Eng. Study Progr., vol. 6, no. 2, pp. 58–65, 2018, [Online]. Available: www.revolectrix.com.

K. Sukiyono and R. Rosdiana, “Pendugaan Model Peramalan Harga Beras Pada Tingkat Grosir,” J. AGRISEP, vol. 17, no. 1, pp. 23–30, 2018, doi: 10.31186/jagrisep.17.1.23-30.

D. A. Pratama, S. Hidayati, E. Suroso, and D. Sartika, “Analisis Peramalan Permintaan dan Pengendalian Persediaan Bahan Baku Pembantu pada Industri Gula (Studi Kasus PT. XYZ Lampung Utara),” J. Penelit. Pertan. Terap., vol. 20, no. 2, pp. 148–160, 2020, doi: 10.25181/jppt.v20i2.1636.

A. Nasution, “Metode Weighted Moving Average Dalam M-Forcasting,” JURTEKSI (Jurnal Teknol. dan Sist. Informasi), vol. V, no. 2, pp. 119–124, 2019.

S. Monalisa, M. Afriani, F. Kurnia, and M. Hartati, “Sistem Informasi Peramalan Penjualan Dengan Menggunakan Metode Weighted Moving Average,” J. Teknol. Inf. dan Komput., vol. 4, no. 1, pp. 309–316, 2018.

D. J. Sari, H. Saputra, and A. Nasution, “The Use of The WMA Method Predicts The Inventory of Tofu Raw Materials Case Study Industry Tahu Iyus,” J. Tek. Inform., vol. 3, no. 2, pp. 429–436, 2022.

S. Julianto and S. Setiawan, “Perancangan Sistem Informasi Pemesanan Tiket Bus Pada Po. Handoyo Berbasis Online,” Simatupang, Julianto Sianturi, Setiawan, vol. 3, no. 2, pp. 11–25, 2019, [Online]. Available: https://journal.amikmahaputra.ac.id/index.php/JIT/article/view/56/48.