Optimized Demand Forecasting by Cross-Validation
Sales forecasting plays an important role in business strategy. An appropriate demand forecasting model is necessary for reducing the cost of storage. At a company level, lowering the warehouse costs and optimizing the value chain is a prominent requirement for an optimum stock management. In this paper a demand forecasting model is built to support the stock management activity of medium enterprises by means of data mining algorithms. SQL server analysis service is used for implementing the demand forecasting model. The paper studies a list of available algorithms that are offered by SQL server analysis service and the performance of the aforementioned algorithms is tested using the cross-validation feature that is provided by SQL server analysis service to optimize the performance of the model. We also aim to explore in our research the ability of RMSE (Root mean Squared Error) to include time series algorithms in the cross-validation phase. The proposed model is tested based on a dataset of a timber export company and the output is used for analysing the performance of the proposed model. The paper reached a group of conclusion and one of most the importance conclusion is neural network algorithms performance was the better in adapting our tested dataset comparing with the other algorithms.
 Meek C., Chickering D. M., & Heckerman D. Autoregressive tree modes for time-series analysis. SIAM International Conference on Data Mining. 2002. (2). pp. 229-244
 Kochak A., & Sharma S. Demand forecasting using neural network for supply chain managemnt. IJMERR. 2015 Jan, 4(1). pp. 96-104
 Dobrican, O. Forecasting Demand for Automotive Aftermarket Inventories. Informatica Economică. 2013. 17(2). pp. 119-129
 Stepanov O. A, & Amosov O. S. The Comparison of the Monte-Carlo method and neural networks algorithms in nonlinear estimation problems. IFAC Proceedings. 2007. 9(1) pp. 392-397
 Pang-Ning T., Michael S., & Kumar V. Chapter 4: Classification: Basic Concepts, Decision Trees, and Model Evaluation. Introduction to Data Mining. Boston, MA, USA: Addison-Wesley Longman Publishing Co. 2005. p. 157
 ***, SQL Server 2012 Tutorials: Analysis Services - Data Mining [Internet]. SQL Server 2012 Books Online. 2012. (cited 2017 Jun 05). P. 55
 Buongiorno J. Global modelling to predict timber production and prices:the GFPM approach.. Forestry. 2014 Dec 4, 88. pp. 291–303. Available from: https://doi.org/10.1093/forestry/cpu047
Copyright (c) 2018 LUMEN Proceedings
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Selection and peer-review under responsibility of the Organizing Committee of the conference.
This is an Open Access article distributed under the terms of the Creative Commons Attribution-Noncommercial 4.0 Unported License, permitting all non-commercial use, distribution, and reproduction in any medium, provided the original work is properly cited.