Title: Exploring the bullwhip effect by means of spreadsheet simulation
Authors: Boute, Robert ×
Lambrecht, Marc #
Issue Date: Sep-2009
Publisher: Institute for Operations Research and the Management Sciences
Series Title: INFORMS Transactions on Education vol:10 issue:1 pages:1-9
Abstract: One of the main supply chain deficiencies is the bullwhip effect: demand fluctuations increase as one moves up the supply chain from retailer to manufacturer. The Beer Distribution Game is widely known for illustrating these supply chain dynamics in class. In this paper we present a spreadsheet application, exploring the two key causes of the bullwhip effect: demand forecasting and the type of ordering policy. We restrict our attention to a single product two-echelon system and illustrate how tuning the parameters of the replenishment policy induces or reduces the bullwhip effect. We also demonstrate how bullwhip reduction (dampening the order variability) may have an adverse impact on inventory holdings and/or customer
service. As such, the spreadsheets can be used as an educational tool to gain a clear insight into the use of inventory control policies and forecasting in relation to the bullwhip effect and customer service.
ISSN: 1532-0545
VABB publication type: VABB-1
Publication status: published
KU Leuven publication type: IT
Appears in Collections:Research Center for Operations Management, Leuven
× corresponding author
# (joint) last author

Files in This Item:
File Description Status SizeFormat
BWExplorer_ITE_.pdfExploring the bullwhip effect by means of spreadsheet simulation Published 242KbAdobe PDFView/Open


All items in Lirias are protected by copyright, with all rights reserved.