Exploring the bullwhip effect by means of spreadsheet simulation
AbstractAn important supply chain research problem is the bullwhip effect: demand fluctuations increase as one moves up the supply chain from retailer to manufacturer. It has been recognized that demand forecasting and ordering policies are two of the key causes of the bullwhip effect. In this paper we present a spreadsheet application, which explores a series of replenishment policies and forecasting techniques under different demand patterns. It illustrates how tuning the parameters of the replenishment policy induces or reduces the bullwhip effect. Moreover, we demonstrate how bullwhip reduction (order variability dampening) may have an adverse impact on inventory holdings. Indeed, order smoothing may increase inventory fluctuations resulting in poorer customer service. As such, the spreadsheets can be used as an educational tool to gain a clear insight into the use or abuse of inventory control policies and improper forecasting in relation to the bullwhip effect and customer service.
Download InfoIf you experience problems downloading a file, check if you have the proper application to view it first. In case of further problems read the IDEAS help page. Note that these files are not on the IDEAS site. Please be patient as the files may be large.
Bibliographic InfoPaper provided by Vlerick Leuven Gent Management School in its series Vlerick Leuven Gent Management School Working Paper Series with number 2007-4.
Length: 33 pages
Date of creation: 09 Feb 2007
Date of revision:
Bullwhip effect; forecasting techniques; replenishment rules; inventory fluctuations; spreadsheet simulation;
This paper has been announced in the following NEP Reports:
- NEP-ALL-2007-02-17 (All new papers)
- NEP-CMP-2007-02-17 (Computational Economics)
- NEP-FOR-2007-02-17 (Forecasting)
You can help add them by filling out this form.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Isabelle Vandenbroere).
If references are entirely missing, you can add them using this form.