Loading...
Exploring the bullwhip effect by means of spreadsheet simulation
Boute, Robert
Boute, Robert
Citations
Altmetric:
Publication Type
Working paper
Editor
Supervisor
Publication Year
2007
Journal
Book
Publication Volume
Publication Issue
4
Publication Begin page
Publication End page
Publication NUmber of pages
33
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. Keywords: Bullwhip effect, forecasting techniques, replenishment rules, inventory fluctuations, spreadsheet simulation
Research Projects
Organizational Units
Journal Issue
Keywords
Logistics Management