School of Business publications portal
This portal is no longer updated. Aalto University School of Business Master's Theses are now in the Aaltodoc publication archive (Aalto University institutional repository)
School of Business | Department of Information and Service Economy | Logistics | 2013
Thesis number: 14276
Forecasting for intermittent spare parts in single-echelon multi-location and multi-item logistics network: Case KONE Global Spares Supply
Author: Oguji, Nnamdi
Title: Forecasting for intermittent spare parts in single-echelon multi-location and multi-item logistics network: Case KONE Global Spares Supply
Year: 2013  Language: eng
Department: Department of Information and Service Economy
Academic subject: Logistics
Index terms: logistiikka; logistics; ennusteet; forecasts; mallit; models; asiakashallinta; customer relationship management; inventointi; inventory
Pages: 87
Full text:
» hse_ethesis_14276.pdf pdf  size:722 KB (738650)
Key terms: Forecasting Performance, Intermittence, Croston, Continuous Review System
The objective of this thesis is to test existing forecasting models for intermittence demand SKU's and implement the best forecast model that suits the inventory control policy of the case company. The optimal forecasting model was selected based on the model that produces optimal performance in terms of customer service levels, inventory total cost and inventory value.

Intermittence demand type was categorized based on degree of lumpiness, erratic, smooth-intermittence and intermittent types. The quantitative data set comprised of historical demand information from 2010-2012 (36 months period) for sixteen thousand stock keeping units (SKU) in the three central distribution centers of the case company. Algorithms for the different forecasting models was developed using VBA programming in Excel 2007 and simulated against the demand data. Explorative approach was used to gather information regarding new material introduction process, forecasting parameters used in the software package (Servigistics) and how the results of the research can be implemented in the case organization.

The result of the analysis shows that traditional forecast accuracy measure is inadequate for selecting best forecast model. Nevertheless, our result shows that no forecast method (Simple Exponential Smoothening (SES), Croston and Modified Croston (SBA) explicitly showed superior performance in all the traditional measures utilized. When stock control measure was utilized Croston showed superior customer service levels of 1% to SES and 1.4% to SBA. The superior customer service levels come with a 1% increase in total cost. The findings of the thesis also suggest the need for amending the outlier management settings in the software system and to customized tracking signal in the forecast review board to enable the prioritization of review reasons in degree of descending order of stock value and tracking signal estimates
Electronic publications are subject to copyright. The publications can be read freely and printed for personal use. Use for commercial purposes is forbidden.