Exploring the bullwhip effect by means of spreadsheet simulation
An 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.
|Date of creation:||09 Feb 2007|
|Date of revision:|
|Contact details of provider:|| Postal: Reep 1, 9000 Gent|
Phone: +32 9 210 98 99
Fax: +32 9 210 97 00
Web page: http://www.vlerick.com
More information through EDIRC
When requesting a correction, please mention this item's handle: RePEc:vlg:vlgwps:2007-4. See general information about how to correct material in RePEc.
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.