IDEAS home Printed from https://ideas.repec.org/a/inm/orinte/v29y1999i3p88-103.html
   My bibliography  Save this article

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

Author

Listed:
  • Thomas A. Grossman

    (Faculty of Management, University of Calgary, Calgary, Alberta, Canada T2N 1N4)

Abstract

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.

Suggested Citation

  • Thomas A. Grossman, 1999. "Teachers' Forum: Spreadsheet Modeling and Simulation Improves Understanding of Queues," Interfaces, INFORMS, vol. 29(3), pages 88-103, June.
    • Handle: RePEc:inm:orinte:v:29:y:1999:i:3:p:88-103
    DOI: 10.1287/inte.29.3.88
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/inte.29.3.88
    Download Restriction: no
    File URL: https://libkey.io/10.1287/inte.29.3.88?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Stephen G. Powell, 1997. "The Teachers' Forum: From Intelligent Consumer to Active Modeler, Two MBA Success Stories," Interfaces, INFORMS, vol. 27(3), pages 88-98, June.
    2. Arthur M. Geoffrion, 1976. "The Purpose of Mathematical Programming is Insight, Not Numbers," Interfaces, INFORMS, vol. 7(1), pages 81-92, November.
    3. William T. Morris, 1967. "On the Art of Modeling," Management Science, INFORMS, vol. 13(12), pages 707-717, August.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Thomas A. Grossman, 2002. "Student Consulting Projects Benefit Faculty and Industry," Interfaces, INFORMS, vol. 32(2), pages 42-48, April.
    2. Christophe Oggier & Emmanuel Fragnière & Jeremy Stuby, 2005. "Nestlé Improves Its Financial Reporting with Management Science," Interfaces, INFORMS, vol. 35(4), pages 271-280, August.
    3. Larry J. LeBlanc & Michael R. Galbreth, 2007. "Implementing Large-Scale Optimization Models in Excel Using VBA," Interfaces, INFORMS, vol. 37(4), pages 370-382, August.
    4. Jeffrey W. Herrmann, 2008. "Disseminating Emergency Preparedness Planning Models as Automatically Generated Custom Spreadsheets," Interfaces, INFORMS, vol. 38(4), pages 263-270, August.
    5. Kiygi Calli, M. & Weverbergh, M. & Franses, Ph.H.B.F., 2017. "Call center performance with direct response advertising," Econometric Institute Research Papers EI2017-04, Erasmus University Rotterdam, Erasmus School of Economics (ESE), Econometric Institute.
    6. Kiygi-Calli, Meltem & Weverbergh, Marcel & Franses, Philip Hans, 2021. "Forecasting time-varying arrivals: Impact of direct response advertising on call center performance," Journal of Business Research, Elsevier, vol. 131(C), pages 227-240.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Calvin Sonntag & Thomas A. Grossman, 1999. "End-User Modeling Improves R&D Management at AgrEvo Canada, Inc," Interfaces, INFORMS, vol. 29(5), pages 132-142, October.
    2. Brian C. Briggeman & Allan W. Gray & Joshua D. Detre, 2008. "Using Limited Information to Support the Decision to Launch a New Product in the Fruit Juice Market: A Teaching Case Study," Review of Agricultural Economics, Agricultural and Applied Economics Association, vol. 30(2), pages 370-378.
    3. Lahtinen, Tuomas J. & Hämäläinen, Raimo P., 2016. "Path dependence and biases in the even swaps decision analysis method," European Journal of Operational Research, Elsevier, vol. 249(3), pages 890-898.
    4. van den Burg, A.J. & van der Ham, R.T. & Kleijnen, J.P.C., 1977. "Generalizations of simulation results : Practicality of statistical methods (Part one)," Research Memorandum FEW 67, Tilburg University, School of Economics and Management.
    5. James F. Campbell, 2017. "Comments on: Continuous approximation models in freight distribution management," TOP: An Official Journal of the Spanish Society of Statistics and Operations Research, Springer;Sociedad de Estadística e Investigación Operativa, vol. 25(3), pages 434-437, October.
    6. T R Willemain & S G Powell, 2007. "How novices formulate models. Part II: a quantitative description of behaviour," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 58(10), pages 1271-1283, October.
    7. Huang, Rongbing & Menezes, Mozart B.C. & Kim, Seokjin, 2012. "The impact of cost uncertainty on the location of a distribution center," European Journal of Operational Research, Elsevier, vol. 218(2), pages 401-407.
    8. Larry J. LeBlanc & Michael R. Galbreth, 2007. "Implementing Large-Scale Optimization Models in Excel Using VBA," Interfaces, INFORMS, vol. 37(4), pages 370-382, August.
    9. Gerald G. Brown & Richard E. Rosenthal, 2008. "Optimization Tradecraft: Hard-Won Insights from Real-World Decision Support," Interfaces, INFORMS, vol. 38(5), pages 356-366, October.
    10. Brian Heath & Raymond Hill & Frank Ciarallo, 2009. "A Survey of Agent-Based Modeling Practices (January 1998 to July 2008)," Journal of Artificial Societies and Social Simulation, Journal of Artificial Societies and Social Simulation, vol. 12(4), pages 1-9.
    11. Richard Francis & Timothy Lowe, 2014. "Comparative error bound theory for three location models: continuous demand versus discrete demand," TOP: An Official Journal of the Spanish Society of Statistics and Operations Research, Springer;Sociedad de Estadística e Investigación Operativa, vol. 22(1), pages 144-169, April.
    12. Michael Pidd, 1999. "Just Modeling Through: A Rough Guide to Modeling," Interfaces, INFORMS, vol. 29(2), pages 118-132, April.
    13. Lieven Demeester & Mei Qi & Luk N. Van Wassenhove, 2013. "Plant Networks for Processing Recyclable Materials," Manufacturing & Service Operations Management, INFORMS, vol. 15(4), pages 670-688, October.
    14. Kleijnen, J.P.C., 1977. "Generalizing simulation results through metamodels," Other publications TiSEM e671b2d6-c334-4938-99aa-3, Tilburg University, School of Economics and Management.
    15. Briggeman, Brian C. & Gunderson, Michael A. & Detre, Joshua D., 2006. "Protecting Your Turf: First-mover Advantages as a Barrier to Competitor Innovation," International Food and Agribusiness Management Review, International Food and Agribusiness Management Association, vol. 9(1), pages 1-18.
    16. Kleijnen, J.P.C., 1978. "The role of statistical methodology in simulation," Other publications TiSEM 05085a08-4669-4775-adc5-4, Tilburg University, School of Economics and Management.
    17. Thomas A. Grossman & Vijay Mehrotra & Mouwafac Sidaoui, 2016. "A Student-Centered Approach to the Business School Management Science Course," INFORMS Transactions on Education, INFORMS, vol. 16(2), pages 42-53, January.
    18. Peter J. Regan, 2006. "Professional Decision Modeling: Practitioner as Professor," Interfaces, INFORMS, vol. 36(2), pages 142-149, April.
    19. Irineu de Brito & Silvia Uneddu & Emma Maspero & Paulo Gonçalves, 2020. "Optimizing Long-Lasting Insecticidal Nets Campaign in Ivory Coast," Logistics, MDPI, vol. 4(3), pages 1-21, August.
    20. Sy, Charlle L. & Aviso, Kathleen B. & Ubando, Aristotle T. & Tan, Raymond R., 2016. "Target-oriented robust optimization of polygeneration systems under uncertainty," Energy, Elsevier, vol. 116(P2), pages 1334-1347.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:inm:orinte:v:29:y:1999:i:3:p:88-103. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.