COMPARISON OF MOVING AVERAGE AND EXPONENTIAL SMOOTHING METHODS IN ANALYZING KWH METER STOCK EXPENDITURE DATA

Merri Parida; Reta Liyanti

doi:10.56327/ijiscs.v8i2.1704

COMPARISON OF MOVING AVERAGE AND EXPONENTIAL SMOOTHING METHODS IN ANALYZING KWH METER STOCK EXPENDITURE DATA

Merri Parida⁽¹⁾, Reta Liyanti⁽²⁾,

(1) Institute of Business Technology and Language Dian Cipta Cendikia Kotabumi, Lampung
(2) Institute of Business Technology and Language Dian Cipta Cendikia Kotabumi, Lampung

Corresponding Author

Abstract

A common problem that occurs in a company is how to predict future production by utilizing historical data that has been previously recorded, to minimize errors in providing a stock of goods and increasing production efficiency so as not to waste more costs. This research aims to identify and analyze the results of production forecasting using the moving average and exponential smoothing methods in the forecasting calculation process to determine the future stock of goods. Data processing using rapidminer programming, from the prediction results using both methods states that the exponential smoothing method with an alpha value of 0.9 is superior to the moving average method with a request result of 23661.5 MAD = 70.7 and MSE = 12387.9987 smaller than other methods.

Keywords

Forecasting, Moving Average, Exponential Smoothing

References

G. Adi Prasetyo, S. Adi Wibowo, and N. Vendyansyah, "Application of Data Mining Using the Double Moving Average Method to Predict Soybean Sales," JATI (Mhs. Tech. Inform. Journal, vol. 7, no. 4, pp. 2303–2310, 2023, doi: 10.36040/jati.v7i4.7490.

A. Ramayani, "WEBSITE-BASED KWH ELECTRICITY METER AT PT PLN (PERSERO) ULP MUARA ENIM OUTER TITLE PAGE By: 2023 Faculty of Computer Science and Engineering," 2023.

M. A. Maricar, "Comparative Analysis of the Accuracy Values of Moving Average and Exponential Smoothing for the Revenue Forecasting System for Company XYZ," J. Sist. And Inform., vol. 13, no. 2, pp. 36–45, 2019.

A. K. Azis and K. Kustanto, "Application of Moving Averages to Accurate Sales Predictions," J. Teknol. Inf. and Commun., vol. 11, no. 1, p. 25, 2023, doi: 10.30646/tikomsin.v11i1.722.

R. Rachman, "Application of Moving Average and Exponential Smoothing Methods in Garment Industry Production Forecasting," J. Inform., vol. 5, no. 2, pp. 211–220, 2018, doi: 10.31311/ji.v5i2.3309.

A. Vebrianti, M. Nasir, J. Jemakmun, and A. Andri, "Forecasting Drug Needs Using the Single Exponential Smoothing Method," J. Inf. Syst. Res., vol. 5, no. 1, pp. 281–292, 2023, doi: 10.47065/josh.v5i1.4381.

L. Fauziah and F. Fauziah, "Application of the Single Exponential Smoothing and Moving Average Method in Web-Based Retail Product Stock Prediction," STRING (Unit of Research and Innovation Technology., vol. 7, no. 2, p 159, 2022, doi: 10.30998/string.v7i2.13932.

B. K. Dewi and D. Mahdiana, "Application of Exponential Smoothing for Optimizing Data Mining Algorithms in Sales Forecasting Application of Exponential Smoothing for Optimization of Data Mining Algorithms in Forecasting Fuel Oil Sales," vol. 2, no. September, pp. 473–482, 2023.

J. Algor, "Inventory Control Using the Forecasting Method: Moving Average and Exponential Smoothing," vol. 1, pp. 21–29, 2020.

L. S. Marita and I. Darwati, "Prediction of Goods Inventory Using the Weighted Moving Average, Exponential Smoothing and Simple Moving Average Methods," vol. 16, no. 1, pp. 56–68.

Full Text: PDF