Title: Spreadsheet vs. multiagent-based simulations in the study of decision making in supply chains

Authors: T. Moyaux, B. Chaib-draa, S. D'Amours

Addresses: DAMAS, FOR@C & CIRRELT, Department d'Informatique et de Genie Logiciel, Universite Laval, Quebec City, QC G1K 7P4, Canada. ' DAMAS, FOR@C & CIRRELT, Department d'Informatique et de Genie Logiciel, Universite Laval, Quebec City, QC G1K 7P4, Canada. ' FOR@C & CIRRELT, Department de Genie Mecanique, Universite Laval, Quebec City G1K 7P4, QC, Canada

Abstract: A game called the Quebec Wood Supply Game (QWSG) is a role-playing simulation based on the Beer Game for teaching Supply Chain (SC) dynamics, and, in particular, the bullwhip effect. In this context, this paper describes and compares two simulators based on the QWSG which may be used to study decision making and its impact on SC dynamics. We first focus on the direct implementation of the QWSG in a spreadsheet program. This spreadsheet model is the base on which we next build a more complex MultiAgent Based Simulation (MABS) in which JACK™ agents represent companies. Finally, we compare the respective advantages of each simulator. We identify the features of a SC model making a spreadsheet simulation impossible, and those for which a spreadsheet simulation is better, as good as, or worse than MABS.

Keywords: SCM; supply chain management; simulation types; simulation comparison; spreadsheet simulation; MABS; multi-agent based simulation; beer game; QWSG; Quebec wood supply game; multi-agent systems; MAS; agent-based systems; role playing; teaching SCM; supply chain dynamics; bullwhip effect.

DOI: 10.1504/IJSPM.2008.022052

International Journal of Simulation and Process Modelling, 2008 Vol.4 No.2, pp.89 - 105

Published online: 17 Dec 2008 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article