2023Journal of Finance and Business DigitalOpen access

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

Open full text 1 citations

Abstract

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.

Open-access reader

About this research paper

What this paper is about

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.

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

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

Related papers

Back to paper searchBrowse research topicsOriginal source
Comparison of Moving Average and Exponential Smoothing Methods in Sales Forecasting of Banana Chips Products in Pd. Dwi Putra Tulang Bawang Barat — Research Paper | ScholarLens