Comparison of Moving Average and Exponential Smoothing Methods in Sales Forecasting of Banana Chips Products in Pd. Dwi Putra Tulang Bawang Barat

Rahmat Adi Wijaya (Jurusan Manajemen, Universitas Lampung)
Rr. Erlina (Jurusan Manajemen, Universitas Lampung)
Nova Mardiana (Jurusan Manajemen, Universitas Lampung)

Journal of Finance and Business Digital (JFBD)
Vol. 2 No. 2 (2023): June 2023

Sales forecasts predict a company's sales. PD Dwi Putra's banana chip sales have fluctuated every month for the past few years, resulting in stock shortages and excesses. Forecasting using historical sales data uses time series methods like moving average and exponential smoothing. This study compares the two forecasting methods to find the lowest error rate and the best method for the company to use for the next four years. The exponential smoothing method outperforms the moving average method for MAPE, MSE, and MAD values, so it is used for future forecasting. According to research, companies should use exponential smoothing with parameter α = 0.6 for the next four years because it has the lowest forecasting error rate. Thus, these parameters are used to forecast the next few years.