Publication

Exploring the bullwhip effect by means of spreadsheet simulation

Boute, Robert
Lambrecht, Marc
Citations
Altmetric:
Publication Type
Journal article
Editor
Supervisor
Publication Year
2009
Journal
INFORMS Transactions on Education
Book
Publication Volume
10
Publication Issue
1
Publication Begin page
1
Publication End page
9
Publication Number of pages
Collections
Abstract
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.
Research Projects
Organizational Units
Journal Issue
Keywords
Operations & Supply Chain Management
Citation
Knowledge Domain/Industry
Other links
Embedded videos