Search results

1 – 1 of 1
Click here to view access options
Article
Publication date: 7 April 2015

Gamze Ogcu Kaya and Omer Fahrettin Demirel

Accurate forecasting of intermittent demand is very important since parts with intermittent demand characteristics are very common. The purpose of this paper is to bring…

Abstract

Purpose

Accurate forecasting of intermittent demand is very important since parts with intermittent demand characteristics are very common. The purpose of this paper is to bring an easier way of handling the hard work of intermittent demand forecasting by using commonly used Excel spreadsheet and also performing parameter optimization.

Design/methodology/approach

Smoothing parameters of the forecasting methods are optimized dynamically by Excel Solver in order to achieve the best performance. Application is done on real data of Turkish Airlines’ spare parts comprising 262 weekly periods from January 2009 to December 2013. The data set are composed of 500 stock-keeping units, so there are 131,000 data points in total.

Findings

From the results of implementation, it is shown that using the optimum parameter values yields better performance for each of the methods.

Research limitations/implications

Although it is an intensive study, this research has some limitations. Since only real data are considered, this research is limited to the aviation industry.

Practical implications

This study guides market players by explaining the features of intermittent demand. With the help of the study, decision makers dealing with intermittent demand are capable of applying specialized intermittent demand forecasting methods.

Originality/value

The study brings simplicity to intermittent demand forecasting work by using commonly used spreadsheet software. The study is valuable for giving insights to market players dealing with items having intermittent demand characteristics, and it is one of the first study which is optimizing the smoothing parameters of the forecasting methods by using spreadsheet in the area of intermittent demand forecasting.

Details

Kybernetes, vol. 44 no. 4
Type: Research Article
ISSN: 0368-492X

Keywords

1 – 1 of 1