Inventory Management Using Cross Prediction

  • Răzvan Daniel ZOTA The Bucharest University of Economic Studies, Bucharest, Romania
  • Yasser AL HADAD The Bucharest University of Economic Studies, Bucharest, Romania
Keywords: Inventory management, BI (Business intelligence), SAS (SQL analysis services), cross prediction, Data analysis


Inventory management involves determining optimum inventory stock that should be held. It is necessary to introduce a set of policies and controls that establish and track levels of inventory and determine when stock should be refilled. At a firm level, identifying all opportunities for optimizing the value chain and lowering the warehouse cost is a main requirement for an efficient stock management. In this paper a supply chain application is modelled to support and optimize the stock management activity. This topic is addressed by using autoregressive method to model a supply chain application. Also, the potential of cross prediction is tested for increasing the performance of the auto regression method. SQL server Analysis services and visual basic for application is used for implementing the supply chain application.  


[1] ***. SQL Server 2012. Tutorials: Analysis Services - Data Mining [Internet]. SQL Server 2012 Books Online. 2012 [cited 2017 Jun 05]. p. 55
[2] Anthony D. W. Basics of Inventory Management. APICS Educational & Research Foundation. Inc. [Internet], 2003. p. 5. Available from:
[3] Dinu D. M. Inventory management within a food factory. Bucharest: CAFEE Conference. 2013. pp. 269-274
[4] Dobrican O. Forecasting Demand for Automotive Aftermarket Inventories. Informatica Economică. 2013. 17(2). pp. 119-129
[5] Ferson S. What Monte Carlo methods cannot do. HERA journal. 1996. 2(4) pp. 990-1007
[6] Lukic R. The Effects of Application of Lean Concept in Retail. MER journal. 2012. 15(1). pp. 88-98.
[7] The balance [Internet]. Just-in-Time. Inventory Management. 2016 [updated 2016 Jun 21; cited 2017 Jun 5]. Available from:
How to Cite
ZOTA, R. D., & AL HADAD, Y. (2018). Inventory Management Using Cross Prediction. LUMEN Proceedings, 3, 575-585.