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, Rr. Erlina, Nova Mardiana
Abstract
Open-access reader
Rahmat Adi Wijaya, Rr. Erlina, Nova Mardiana
Abstract
Open-access reader
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.
OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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.
Key concepts: Exponential smoothing, Moving average, Sales forecasting, Exponential function, Economic shortage, Statistics, Econometrics, Smoothing