Teachers' Forum: Spreadsheet Modeling and Simulation Improves Understanding of Queues

Process-driven spreadsheet queuing simulation is a better vehicle for understanding queue behavior than queuing theory or dedicated simulation software. Spreadsheet queuing simulation has many pedagogical benefits in a business school end-user modeling course, including developing students intuition, giving them experience with active modeling skills, and providing access to tools. Spreadsheet queuing simulations are surprisingly easy to program, even for queues with balking and reneging. The ease of prototyping in spreadsheets invites thoughtless design, so careful spreadsheet programming practice is important. Spreadsheet queuing simulation is inferior to dedicated simulation software for analyzing queues but is more likely to be available to managers and students.

[1]  Cliff T. Ragsdale,et al.  Modeling Optimization Problems in the Unstructured World of Spreadsheets , 1997 .

[2]  Wayne L. Winston Practical Management Science , 1997 .

[3]  William T. Morris,et al.  On the Art of Modeling , 1967 .

[4]  Arthur M. Geoffrion,et al.  The Purpose of Mathematical Programming is Insight, Not Numbers , 1976 .

[5]  James R. Evans,et al.  Management science : modeling, analysis, and interpretation , 1995 .

[6]  Stephen G. Powell,et al.  The Teachers’ Forum: Six Key Modeling Heuristics , 1995 .

[7]  Malcolm King,et al.  Spreadsheet Modelling Abuse: An Opportunity for OR? , 1993 .

[8]  Thomas A. Grossman,et al.  End-User Modeling Improves R&D Management at AgrEvo Canada, Inc , 1999, Interfaces.

[9]  Wayne L. Winston,et al.  Practical Management Science Spreadsheet Modeling and Applications , 2002, J. Oper. Res. Soc..

[10]  Betty Duncan,et al.  Applied Management Science and Spreadsheet Modeling , 1995 .

[11]  David L. Olson,et al.  Introduction to Simulation and Risk Analysis , 1998 .

[12]  Matthew J. Liberatore,et al.  The Teachers' Forum: Breaking the Mold - A New Approach to Teaching the First MBA Course in Management Science , 1999, Interfaces.

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

[14]  Wayne L. Winston Simulation Modeling Using Risk , 1995 .

[15]  Andrew Robson,et al.  Spreadsheet Modelling: Guidelines for Model Development , 1993 .

[16]  Shmuel S. Oren,et al.  A Closure Approximation for the Nonstationary M/M/s Queue , 1979 .

[17]  Arne Thesen,et al.  Simulation for Decision Making , 1992 .

[18]  Rick Hesse Managerial spreadsheet modeling and analysis , 1997 .

[19]  Stephen G. Powell The Teachers' Forum: From Intelligent Consumer to Active Modeler, Two MBA Success Stories , 1997 .

[20]  M. D. Wilkinson,et al.  Management science , 1989, British Dental Journal.