A formulation for measuring the bullwhip effect with spreadsheets

Journal ar
Direccion y Organizacion
  • Volumen: 48
  • Fecha: 01 December 2012
  • Páginas: 29-33
  • ISSN: 1132175X 21716323
  • Source Type: Journal
  • Document Type: Article
The bullwhip effect refers to the scenario in which orders to suppliers tend to present larger fluctuations than sales to buyers, and the resulting distor tion increasingly amplifies upstream in a supply chain. We propose a transformation of the known formulation by Chen et al. (2000) to calculate the bullwhip effect in a supply chain for the purpose of being easily applied with spreadsheets without using VBA macros. We present this formulation modeled by Ms Excel® using a numerical example.

Author keywords

    Indexed keywords

      Funding details