Get 20M+ Full-Text Papers For Less Than $1.50/day. Start a 14-Day Trial for You or Your Team.

Learn More →

Parameter optimization of intermittent demand forecasting by using spreadsheet

Parameter optimization of intermittent demand forecasting by using spreadsheet 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. http://www.deepdyve.com/assets/images/DeepDyve-Logo-lg.png Kybernetes Emerald Publishing

Parameter optimization of intermittent demand forecasting by using spreadsheet

Ogcu Kaya, Gamze; Demirel, Omer Fahrettin
Kybernetes , Volume 44 (4): 12 – Apr 7, 2015
Download PDF
12 pages

Loading next page...
 
/lp/emerald-publishing/parameter-optimization-of-intermittent-demand-forecasting-by-using-iCNd5TrmUT

References (21)

Publisher
Emerald Publishing
Copyright
Copyright © Emerald Group Publishing Limited
ISSN
0368-492X
DOI
10.1108/K-03-2015-0062
Publisher site
See Article on Publisher Site

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.

Journal

Kybernetes – Emerald Publishing

Published: Apr 7, 2015

There are no references for this article.