Forecasting Spare Parts Demand Using Statistical Analysis

Abstract

Spare parts are very essential in most industrial companies. They are characterized by their large number and their high impact on the companies’ operations whenever needed. Therefore companies tend to analyze their spare parts demand and try to estimate their future consumption. Nevertheless, they face difficulties in figuring out an optimal forecasting method that deals with the lumpy and intermittent demand of spare parts. In this paper, we performed a comparison between five forecasting methods based on three statistical tools; Mean squared error (MSE), mean absolute deviation (MAD) and mean error (ME), where the results showed close performance for all the methods associated with their optimal parameters and the frequency of the spare part demand. Therefore, we proposed to compare all the methods based on the tracking signal with the objective of minimizing the average number of out of controls. This approach was tested in a comparative study at a local paper mill company. Our findings showed that the application of the tracking signal approach helps companies to better select the optimal forecasting method and reduce forecast errors.