The Evaluation of Forecasting Methods for Sales of Sterilized Flavoured Milk in Chhattisgarh

  IJETT-book-cover  International Journal of Engineering Trends and Technology (IJETT)          
© 2014 by IJETT Journal
Volume-8 Number-2                          
Year of Publication : 2014
Authors :  Pradeep Kumar Sahu , Rajesh Kumar


Pradeep Kumar Sahu , Rajesh Kumar."The Evaluation of Forecasting Methods for Sales of Sterilized Flavoured Milk in Chhattisgarh", International Journal of Engineering Trends and Technology(IJETT), 8(2),98-104 February 2014. ISSN:2231-5381. published by seventh sense research group


In recent years, there has been a great deal of discussion on applications of various forecasting models and their performance in forecasting business activities. This paper discussed few of forecasting models and their application for sales forecasting of sterilized flavoured milk in Chhattisgarh. Applying weekly data spreading over October 2011 to October 2012, on the sales of sterilized flavoured milk in liter. The forecasting method analysed included: naϊve model , moving average, double moving average, simple exponential smoothing; and semi average method. The accuracy of the forecasting method was measured using mean Forecast Error (MFE), mean Absolute Deviation (MAD), mean Square Error (MSE), root mean square Error (RMSE).


[1] Armstrong, J.S. and Collopy, F., (1992) “Error Measures For Generalizing About Forecasting Method: Empirical Comparisons”, International Journal of Forecasting, Vol.8, pp 69-80.
[2] Armstrong, J.S., & Lusk, E.J., (1983) “The accuracy of alternative extrapolation models: analysis of a forecasting competition through open peer review” Journal of forecasting, Vol.2, Issue 3, pp 259-311.
[3] Armstrong, J.S., et al., (2005) “The forecasting canon: nine generalization to improve forecast accuracy” The international journal of applied forecasting, Vol.1, Issue 1, pp 29-35.
[4] Armstrong, J.S., & Collopy, F., (1992)” Error measures for generalizing about forecasting methods: empirical comparisons” International journal of forecasting, Vol. 8, Issue 1, pp 69-80.
[5] Armstrong, J.S., et al., (1983) “Relative accuracy of judgmental and extrapolative methods in forecasting annual earnings” Journal of forecasting, Vol. 2, Issue 4, pp 437-447.
[6] Armstrong, J.S., & Collopy, F., (1998) “Integration of statistical methods and judgment for time series forecasting: principles from empirical research Forecasting with Judgment” John Wiley & Sons Ltd., pp 269-293. [7] Armstrong, J.S., et al., (1986) “The ombudsman: research on forecasting: a quarter-century review, 1960-1984” Interfaces, Vol. 16, Issue 1, pages 89-109.
[8] Armstrong, J.S., et al., (2001) “Selecting Forecasting Methods” Principles of Forecasting: A Handbook for Researchers and Practitioners, Kluwer academic publishers.
[9] Armstrong, J.S., et al., (2001) “Standards and practices for forecasting” principles of forecasting: a handbook for researchers and practitioners, Kluwer academic publishers.
[10] Armstrong, J.S., Morwitz, V.G. and Kumar, V. (2000). Sales Forecasts for Existing Consumer Products and Services: Do Purchase Intentions Contribute to Accuracy? International Journal of Forecasting. Vol. 16, Issue 5, pp 383-397.
[11] Armstrong, J.S., Morwitz and Grohman, M.C. (1972). A Comparative Study of Methods for Long-Range Market Forecasting. Management Science. Vol. 19, Issue 2, pp 211-221.
[12] Azeem, A., et al., (2009) “Demand Forecasting and Supplier Selection for Incoming Material in RMG Industry: A Case Study” International Journal of Business and Management, Vol. 4, Issue 5, pp 149-159.
[13] Alfares, H.K., and Nazeerudin, M., (2002) “Electric load forecasting: literature survey and classification method,” International journal of system science: volume 33, Number 1, pp 23-24.
[14] Bunn, D., & Wright, G., (1991) “Interaction of judgmental and statistical forecasting method: issue and analysis” Management science, Vol.37, Issue 5, pp 501-518.
[15] Bratu, M., et al “The Accuracy of Unemployment Rate Forecasts In Romania and The Actual Economic Crisis”, Scientific Bulletin – Economic Sciences, Vol.11, Issue 2, pp 56-67.
[16] Chen, F.L., & Chen, Y.C., (2009) “An investigation of forecasting critical spare parts requirement” world congress on computer science and information engineering, pp 225-230.
[17] Croushore, D., et al., (1993) “introducing: The survey of professional forecasters” Business Review, pp 3-5. [18] Cole, R., et al (1969) “Data errors and forecasting accuracy” Economic forecasts and expectations: analysis of forecasting behavior and performance, pp 47-82.
[19] Chary, S.N., et al.,(2009) “Production and Operation Management”, Tata McGraw-Hill, New Delhi (India). [20] Chopra, S. and Meindl, P., (2010) “Supply Chain Management Strategy, Plainning and Operation”, Pearson, 4th Ed, India.
[21] Cacatto, C., Belfiore, P., and Vieira, J.G., (2012) “Forecasting Practices in Brazilian food Industry,” Journal of logistics management: Vol. 1, No. 4, pp 24-36.
[22] Corberan-Vallet, A., Bermudez, J. D., and Vercher, E. (2011). Forecasting correlated time series with exponential smoothing models. International Journal of Forecasting, Vol. 27, pp 252-265.
[23] Feridun, M. & Adebiyi,M.A.(2006) “ Forecasting Inflation in Developing Economics: The Case of Nigeria”, International Journal of Applied Econometrics and Quantitative Studies, 1986-1998, Volume 3, Issue 1, pp 18-19.
[24] Floros, C., et al., (2005) “Forecasting the UK Unemployment Rate: Model Comparisons”, International Journal of Applied Econometrics and Quantitative Studies,Vol.2, Issue 4, pp 57-72.
[25] Fildes, R., & Markridakis, S.,(1993) “The impact of empirical accuracy studies on time series analysis and forecasting”, pp1-26.
[26] Goodwin, P., et al (2000) “Correct or combine? Mechanically integrating judgmental forecasts with statistical methods” International journal of forecasting, Vol. 16, pp 261–275.
[27] Hyndman, R. J., Koehler, A. B., Snyder, R. D., and Grose, S., (2002) “A state space framework for automatic forecasting using exponential smoothing methods”, International Journal of Forecasting, 18, 439-454.
[28] Hannan, M.A., Marselin, M.G., Rahaman, M.M., & Islam, M.S., (2011) “Analysis for finding an efficient sales forecasting method in the process of production plainning, operation and other area of decision making” International journal of mechanical and production engineering research and development, Vol. 1, Issue 2, pp 1-37.
[29] Jacobs, F. R. and Chase, R.B. (2013). Operations and Supply Chain Management: The Core, 3rd Edition, McGraw-Hill Higher Education
[30] Lim, P.Y., and Nayar, C.V., (2012) “Solar Irradiance and Load Demand Forecasting Based on Single Exponential Smoothing Method”, IACSIT International Journal of Engineering and Technology, Vol.4, Issue 4, pp 451-455.
[31] Markridakis, S., et al.,(1989) “Sliding simulation: a new approach to time series forecasting” management science, Vol.89, Issue 51, pp 1-12.
[32] Markridakis, S., et al.,(1989) “Why combining works?” International journal of forecasting, Vol.89, Issue 53, pp 1-6.
[33] Mentzer, J.T., & Kahn, K.B., (1995) “Forecasting technique familiarity, satisfaction, usage, and application” Journal of forecasting, Vol. 14, pp 465-476.
[34] Padhan, P.C., et al., (2012) “Use of Univariate Time Series Model For Forecasting Cement Production in India”, International Research Journal of Finance and Economics, Issue 83.
[35] Panneerselvam, R., et al., (2009) “Production and Operation Management, 2nd edition, PHI Learning Private Limited, New Delhi (India).
[36] Patil, D.P., Shrotri, A.P. and Dandekar, A.R., (2013) “Management of Uncertainty in Supply Chain”, International Journal of Emerging Technology and Advanced Engineering, Vol.2, Issue 5, pp 303-308.
[37] Paul, S.K., et al., (2011) “Determination of Exponential Smoothing Constant to Minimize Mean Square Error and Mean Absolute Deviation”, Global Journal of Research in Engineering, Vol.11, Issue 3, Version 1.0.
[38] Rachel J.C., Bloomfield, P., and Cubbage, F.W., (2008) “Comparing Forecasting Models in Tourism”, Journal of Hospitality & tourism Research, Vol.32, Issue 1, pp 3-21.
[39] Rachel J.C., Bloomfield, P., and John S.F., (2003) “An Evaluation of Alternative Forecasting Method to Recreation Visitation,” Journal of Leisure Research: Vol. 35, No.4, pp 441-454.
[40] Ramamurthy, P., et al., (2005) “Production and Operation Management”, New Age International (P) Limited, Publishers, New Delhi (India).
[41] Ryu, K., and Sanchez, A., (2003) “The Evaluation of Forecasting Method at an Institutional Foodservice Dining Facility,” Journal of Hospitality Financial Management: Vol. 11: Iss.1, Article 4.
[42] Strasheim et al., (1992) “Demand Forecasting for Motor Vehicle Spare Parts,” A Journal of Industrial Engineering, Vol. 6, No. 2, pp 18-19.
[43] Taylor, J. W., et al., (2003) “Exponential smoothing with a damped multiplicative trend”, International Journal of Forecasting, Vol. 19, pp 715-725.
[44] West, C.T., et al., (2003) “The Status of Evaluating Accuracy of Regional Forecasts”, The Review of Regional Studies, Vol.33, Issue 1, pp 85-103.
[45] Znaczko, T. M., et al., (2013) "Forecasting Foreign Exchange Rates" Applied Economics Theses. Paper 4.

sterilized flavoured milk, forecasting models Introduction