ANALYZING THE SUITABILITY OF TIME SERIES AND REGRESSION FORECASTING METHOD FOR DRINKING WATER PRODUCT

Authors

  • Syifa Hanifa Salsabil , Devilia Sari , Aan Komariah , Dedy Achmad Kurniady

Abstract

The objective of this research was to find the right method to increase the accuracy of
forecasting in the demand of 330 ml bottled drinking water in the water supply company in
Bandung West Java, Indonesia. The methods used were Naïve, Moving Average, Weighted
Moving Average, Single Exponential Smoothing, Holt’s Exponential Smoothing, Winter
Holt’s Exponential Smoothing, and Polynomial Regression. To examine the performance of
forecasting methods, three measures are applied. Those are Mean Absolute Deviation
(MAD), mean squared error (MSE), and mean absolute percent error (MAPE). The research
results showed that the most suitable forecasting method for 330ml bottled water product is
weighted moving average. By comparison MSE resulted from proposed method is
1,334,992.74 and the number of MSE with the method that is currently employed by the
company is 2,382,366.84. The conclusion is the accuracy calculation of the demand for
bottled drinking water products can be done by techniques forecasting with weighted moving
average method.

Downloads

Download data is not yet available.

Downloads

Published

2020-11-28

How to Cite

Syifa Hanifa Salsabil , Devilia Sari , Aan Komariah , Dedy Achmad Kurniady. (2020). ANALYZING THE SUITABILITY OF TIME SERIES AND REGRESSION FORECASTING METHOD FOR DRINKING WATER PRODUCT. PalArch’s Journal of Archaeology of Egypt / Egyptology, 17(6), 1556 - 1567. Retrieved from http://mail.palarch.nl/index.php/jae/article/view/1012