AN EXPONENTIALLY WEIGHTED MOVING AVERAGE METHOD WITH DESIGNED INPUT DATA ASSIGNMENTS FOR FORECASTING LIME PRICES IN THAILAND

Thitima Booranawong, Apidet Booranawong

Abstract


In this paper, the Exponentially Weighted Moving Average (EWMA) method with designed input data assignments (i.e. the proposed method) is presented to forecast lime prices in Thailand during January 2016 to December 2016. The lime prices from January 2011 to December 2015 as the input data are gathered from the website’s database of Simummuang market, which is one of the big markets in Thailand. The novelty of our paper is that although the performance of the EWMA method significantly decreases when applying to forecast data which show trend and seasonality behaviors and the EWMA method is used for short-range forecasting (i.e. usually one month into the future), the proposed method can properly handle such mentioned problems. For this purpose, to forecast lime prices, five different input data are intently defined before assigned to the EWMA method: a) the monthly data of the year 2015 (i.e. the recent year data), b) the average monthly data of the year 2011 to 2015, c) the median of the monthly data of the year 2011 to 2015, d) the monthly data of the year 2011 to 2015 after applying the linear weighting factor, where the higher weight value is applied to the recent data, and e) the average monthly data of the year 2011 to 2015 after applying the exponential weighting factor, where the higher weight is also applied to the recent data. These designed input data are used as agents of the raw data. Our study reveals that using the input data b) with the EWMA method to forecast lime prices during January 2016 to September 2016 gives the smallest forecasting error measured by the Mean Absolute Percentage Error (MAPE). Forecasted lime prices of October 2016 to December 2016 are also provided. Additionally, we demonstrate that the proposed method works well compared with the Double Exponentially Weighted Moving Average (DEWMA), the Multiplicative Holt-Winters (MHW), and the Additive Holt-Winters (AHW) methods, which are suitably used for forecasting data with the trend and the seasonality.


Keywords


Forecasting, exponentially weighted moving average, double exponentially weighted moving average, Holt-Winters, lime prices

Full Text:

PDF

References


Brown, R.G. 1956. Exponential Smoothing for Predicting Demand. 10th National Meeting of the Operations Research Society of America, San Francisco.

Hunter, J. H. 1986. The Exponentially Weighted Moving Average. Journal of Quality Technology. 18(4): 203-210.

Winters, P. 1960. Forecasting Sales by Exponentially Weighted Moving Averages. Management Science. 6: 324-342.

Montgomery, D. C., Jennings, C. L., and Kulahci, M. 2008. Introduction to Time Series Analysis and Forecasting. Wiley Series in Probability and Statistics. John Wiley and Sons, Hoboken, New Jersey, USA.

Kalekar, P. S. 2004. Time Series Forecasting Using Holt-Winters Exponential Smoothing. Kanwal Rekhi School of Information Technology.

Holt, C. C. 2004. Forecasting Seasonals and Trends by Exponentially Weighted Moving Averages. International Journal of Forecasting. 20(1): 5-10.

Dhakre, D. S., Sarkar, K. A., and Manna, S. 2016. Forecasting Price of Brinjal by Holt Winters Method in West Bengal Using MS Excel. International Journal of Bio-resource, Environment and Agricultural Sciences. 2(1): 232-235.

Gardner, E. S. 1985. Exponential Smoothing: The State of the Art. Journal of Forecasting. 4: 1-28.

De Gooijer, J. G., and Hyndman, R. J. 2006. 25 Years of Time Series Forecasting. International Journal of Forecast. 22(3): 443–473.

Chatfield, C. 2001. Time-Series Forecasting. Chapman & Hall, New York.

Simummuang Market, Retrieved June 2017 from http://www.taladsimummuang.com/dmma/Portals/PriceList.aspx.

Tratar, L. F., and Srmcnik, E. 2016. The Comparison of Holt-Winters Method and Multiple Regression Methods: A Case Study. Energy. 109(2016): 266-276.

Tratar, L. F., Mojskerc, B., and Toman, A. 2016. Demand Forecasting with Four-Parameter Exponential Smoothing. International Journal of Production Economics. 181(2016): 162-173.

Ramos, P., Santos, N., and Rebelo, R. 2015. Performance of State Space and ARIMA models for Consumer Retail Sales Forecasting. Robotics and Computer-Integrated Manufacturing. 34(2015): 151-163.

Tratar, L. F. 2016. Forecasting Method for Noisy Demand. International Journal of Production Economics. 161(2015): 64-73.

Gentry, T. W., Wiliamowski, B. M., and Weatherford, L. R. 1995. A Comparison of Traditional Forecasting Techniques and Neural Networks. Intelligent Engineering Systems through Artificial Neural Networks. 5: 765-770.

Alon, I., Qi, M., and Sadowski, R. J. 2001. Forecasting Aggregate Retail Sales: A Comparison of Artificial Neural Networks and Traditional Methods. Journal of Retailing and Consumer Services. 8(3): 147-156.

Ravindran, A., and Warsing, D.P. 2013. Supply Chain Engineering: Models and Applications. New York. NY: CRC Press.




DOI: http://dx.doi.org/10.11113/jt.v79.10096

Refbacks

  • There are currently no refbacks.


Copyright © 2012 Penerbit UTM Press, Universiti Teknologi Malaysia.
Disclaimer : This website has been updated to the best of our knowledge to be accurate. However, Universiti Teknologi Malaysia shall not be liable for any loss or damage caused by the usage of any information obtained from this web site.
Best viewed: Mozilla Firefox 4.0 & Google Chrome at 1024 × 768 resolution.