Abstract
The main purpose of the study is to design a forecasting framework through a better understanding of the structure of the customers’ own forecasts to minimize the forecast error. Different than the conventional forecasting methods, our framework has an extra input, which is the set of reported customer forecasts; which is mostly based on customers’ own production plans and capacities. Furthermore, our framework also takes the advantage of the classical methods: Winter’s Method in its pure form and Winter’s Method merged with Decomposition Method are taken into consideration, because these methods are able to handle stability, seasonality and trend in the demand data structures. The general proposed model is designed to embed the customer forecasts to the forecasting framework with a scientific methodology. A new method is created with a logic of a calculation of reliability indices for each customer and product pairs with following some statistical procedures. As a result of the method which can calculate the reliability of each customer, a forecast output is provided. On the other hand, forecast Combination Method is adjusted with respect to the nature of the problem to combine the output of Winter’s Method’s and the output of Customer Forecasts Method. In order to implement all these methods, the study is practiced in a well-known, international energy company. The demand data are divided into such subgroups as; Regular, High Variance, New Born, Rare, On Off and Inactive based on the demand structure of the data, to observe how these subgroups would react to the method. In order to achieve all these routines of the forecasting framework, we design a Decision Support System in Excel Visual Basic Applications (VBA).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Nahmias S (2005) Production and operations analysis, 5th edn. McGraw-Hill Irwin, Boston
Brockwell PJ, Davis RA (2002) Introduction to time series and forecasting, 2nd edn. Springer, New York
Kalekar PS (2004) Time series forecasting using holt-winters exponential smoothing. Kanwal Rekhi School of Information Technology
Social Science Computing Cooperative (2018) Homepage. https://www.ssc.wisc.edu/~bhansen/390/2010/390Lecture24.pdf
Adalı E, Aktaş, Y, Baykan OM, Güldoğan İ, Koral E (2014-2015) Demand tracking and forecasting system for finished goods. Yasar University Bachelor Thesis Project Book, Izmir
Acknowledgment
We thank to Mert Paldrak who is working as research assistant in Industrial Engineering department Yasar University and also Duygu Alan and İsmail Serkan Kabataş who are the students of Industrial Engineering department of Yasar University who provided insight and expertise that greatly assisted the research.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this paper
Cite this paper
Mutlu, İ., Sancar, D., Altın, E.N., Balaban, S., Cesur, T.C., Bulut, Ö. (2019). A New Demand Forecasting Framework Based on Reported Customer Forecasts and Historical Data. In: Durakbasa, N., Gencyilmaz, M. (eds) Proceedings of the International Symposium for Production Research 2018. ISPR 2018. Springer, Cham. https://doi.org/10.1007/978-3-319-92267-6_67
Download citation
DOI: https://doi.org/10.1007/978-3-319-92267-6_67
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-92266-9
Online ISBN: 978-3-319-92267-6
eBook Packages: EngineeringEngineering (R0)