Spreadsheet simulation for the supply chain inventory problem

This paper demonstrates how spreadsheets can be used to simulate supply chain inventory systems. For this purpose, a sample spreadsheet simulation model is developed for a single distribution channel. It is simulated for three different scenarios reflecting various levels of demand fluctuations (high, medium and low demand variance). The proposed modelling approach has potential value to the operational managers because it provides a simple methodology that can be implemented with any spreadsheet program. Several avenues for the use of spreadsheets in modelling supply chain systems are presented.

[1]  Jinxing Xie,et al.  The Impact of Forecast Errors on Early Order Commitment in a Supply Chain , 2002, Decis. Sci..

[2]  Charu Chandra,et al.  Taxonomy of inventory policies for supply‐chain effectiveness , 1998 .

[3]  Barry Alan Pasternack,et al.  Applied Management Science - A Computer-Integrated Approach for Decision Making ] , 1998 .

[4]  Enver Yücesan,et al.  Transshipments: An emerging inventory recourse to achieve supply chain leagility , 2002 .

[5]  Mohamed Mohamed Naim,et al.  The dynamics of emergency transhipment supply chains , 2000 .

[6]  James R. Evans,et al.  Principles of Operations Management , 2005 .

[7]  Hon-Shiang Lau,et al.  Effects of a demand-curve's shape on the optimal solutions of a multi-echelon inventory/pricing model , 2003, Eur. J. Oper. Res..

[8]  F. Persson,et al.  Performance simulation of supply chain designs , 2002 .

[9]  Ulrich Wilhelm Thonemann,et al.  Deriving inventory-control policies with genetic programming , 2004, OR Spectr..

[10]  Lloyd J. Taylor,et al.  A simulation study of WIP inventory drive systems and their effect on financial measurements , 1999 .

[11]  A. Banerjee,et al.  Controlled partial shipments in two-echelon supply chain networks: a simulation study , 2001 .

[12]  Wei-yu Kevin Chiang,et al.  Production, Manufacturing and Logistics Managing inventories in a two-echelon dual-channel supply chain , 2005 .

[13]  Luc LeBel,et al.  Simulation of woodyard inventory variations using a stochastic model , 1997 .

[14]  George Q. Huang,et al.  Web‐based simulation portal for investigating impacts of sharing production information on supply chain dynamics from the perspective of inventory allocation , 2002 .

[15]  M. Khouja.  Optimizing inventory decisions in a multi-stage multi-customer supply chain , 2003 .

[16]  A. Banerjee,et al.  A simulation study of lateral shipments in single supplier, multiple buyers supply chain networks , 2003 .

[17]  Sita Bhaskaran.  Simulation Analysis of a Manufacturing Supply Chain , 1998 .

[18]  Dobrila Petrovic,et al.  Simulation of supply chain behaviour and performance in an uncertain environment , 2001 .

[19]  H. Wee,et al.  Integrated inventory model for deteriorating items under a multi-echelon supply chain environment , 2003 .

[20]  Alan J. Stenger,et al.  The impact of inventory and flow planning parameters on supply chain performance: An exploratory study , 2001 .

[21]  Henry C. W. Lau,et al.  A simulation approach in supply chain management , 2002 .

[22]  Barry Render,et al.  Principles of Operations Management , 1993 .