Article

Discrete-event simulation of queues with spreadsheets: a teaching case

Authors:

Marco Aurélio de Mesquita,

Alvaro Euzebio HernandezAuthors Info & Claims

WSC '06: Proceedings of the 38th conference on Winter simulation

Pages 2277 - 2283

Published: 03 December 2006 Publication History

Get Access

Abstract

This paper describes the use of spreadsheets combined with simple VBA code as a tool for teaching queuing theory and discrete-event simulation. Four different cases are considered: single server, parallel servers, tandem queuing, and closed queuing system. The data obtained in the simulation run are conveniently stored in spreadsheets for subsequent statistical analysis. This approach was successfully deployed in a second one-semester course on management science for industrial engineers undergraduate students.

References

[1]

Albright, S. C. 2001. VBA for Modelers. Pacific Grove: Duxbury.

Google Scholar

[2]

Banks, J. 1998. Principles of Simulation. In Handbook of Simulation: principles, methodology, advances, applications, and practice. Ed. J. Banks. New York: John Wiley.

Google Scholar

[3]

Centeno, M. A. 1996. An Introduction to Simulation Modeling. In Proceedings of the 1996 Winter Simulation Conference, ed. J. M. Charnes, D. J. Morrice, D. T. Brunner, and J. J. Swain, 15--22. Piscataway, New Jersey: Institute of Electrical and Electronics Engineers.

Digital Library

Google Scholar

[4]

Chase, R. B., N. J. Aquilano, F. R. Jacobs. 1998. Production and Operations Management: manufacturing and services. 8th ed. Boston: Irwin/McGraw-Hill.

Google Scholar

[5]

Evans, J. R. 2000. Spreadsheets as a Tool for Teaching Simulation. Informs Transactions on Educations. 1(1), p. 27--37.

Digital Library

Google Scholar

[6]

Grossman, T. A. 1999. Teachers' Forum: spreadsheet modeling and simulation improves understanding of queues. Interfaces. 29(3), p. 88--103.

Digital Library

Google Scholar

[7]

Hora, S. C. 2003. Spreadsheet Modeling of the G/G/c Queuing System without Macros or Add-Ins. Informs Transactions on Educations. 3(3), p. 86--89.

Digital Library

Google Scholar

[8]

Ingolfsson, A.; T. A. Grossman. 2002. Graphical Spreadsheet Simulation of Queues. Informs Transactions on Educations, 2(2), p. 27--39.

Digital Library

Google Scholar

[9]

Kleinrock, L. 1975. Queuing Systems. New York: John Wiley.

Digital Library

Google Scholar

[10]

Pritsker, A. A. B. 1998. Principles of Simulation Modeling. In Handbook of Simulation: principles, methodology, advances, applications, and practice. Ed. J. Banks. New York: John Wiley.

Google Scholar

[11]

Schriber, T. J.; and D. T. Brunner. 1998. How Discrete-Event Simulation Software Works. In Handbook of Simulation: principles, methodology, advances, applications, and practice. Ed. J. Banks. New York: John Wiley.

Google Scholar

[12]

Spearman, M. L.; D. L. Woodruff; and W. J. Hopp. 1990. CONWIP: a pull alternative to kanban. International Journal of Production Research. 28(5), p. 879--894.

Crossref

Google Scholar

[13]

Winston, W. L. 2004. Operations Research, 4th ed. Belmont: Thomson Learning.

Google Scholar

Cited By

View all

Arce-Medina E(2007)Monte Carlo simulation to propose improvements of an alkyd resin processProceedings of the 7th WSEAS International Conference on Simulation, Modelling and Optimization10.5555/1353862.1353945(469-473)Online publication date: 15-Sep-2007
https://dl.acm.org/doi/10.5555/1353862.1353945

Discrete-event simulation of queues with spreadsheets: a teaching case
1. Applied computing

Recommendations

Discrete-time single-server finite-buffer queues under discrete Markovian arrival process with vacations

This paper treats a discrete-time single-server finite-buffer exhaustive (single- and multiple-) vacation queueing system with discrete-time Markovian arrival process (D-MAP). The service and vacation times are generally distributed random variables and ...
Discrete-time GeoX/G(a,b)/1/N queues with single and multiple vacations

In this paper, we consider a discrete-time single-server finite-buffer batch arrival queue in which customers are served in batches according to a general bulk-service rule, that is, at least 'a' customers are needed to start a service with a maximum ...
A Rare-Event Simulation Algorithm for Periodic Single-Server Queues

An efficient algorithm is developed to calculate the periodic steady-state distribution and moments of the remaining workload W _y at time yc within a cycle of length c , 0 â y < 1, in a single-server queue with a periodic arrival-rate function. ...

Comments

Information & Contributors

Information

Published In

WSC '06: Proceedings of the 38th conference on Winter simulation

December 2006

2429 pages

ISBN:1424405017

Editors:
L. Felipe Perrone
Bucknell University
,
Barry G. Lawson
University of Richmond
,
Jason Liu
Colorado School of Mines
,
Frederick P. Wieland
Sensis Corporation
,
General Chair:
David Nicol
University of Illinois, Urbana-Champaign
,
Program Chair:
Richard Fujimoto
College of Computing, Georgia Tech

Publisher

Winter Simulation Conference

Publication History

Published: 03 December 2006

Check for updates

Qualifiers

Article

Conference

WSC06

Sponsor:

IIE
ASA
IEICE ESS
IEEE-CS\DATC
SIGSIM
NIST
(SCS)
INFORMS-CS

WSC06: Winter Simulation Conference 2006

December 3 - 6, 2006

California, Monterey

Acceptance Rates

WSC '06 Paper Acceptance Rate 177 of 252 submissions, 70%;

Overall Acceptance Rate 3,413 of 5,075 submissions, 67%

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

1
Total Citations
View Citations
453
Total Downloads

Downloads (Last 12 months)1
Downloads (Last 6 weeks)0

Reflects downloads up to 07 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Arce-Medina E(2007)Monte Carlo simulation to propose improvements of an alkyd resin processProceedings of the 7th WSEAS International Conference on Simulation, Modelling and Optimization10.5555/1353862.1353945(469-473)Online publication date: 15-Sep-2007
https://dl.acm.org/doi/10.5555/1353862.1353945

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Abstract

References

Cited By

Recommendations

Discrete-time single-server finite-buffer queues under discrete Markovian arrival process with vacations

Discrete-time GeoX/G(a,b)/1/N queues with single and multiple vacations

A Rare-Event Simulation Algorithm for Periodic Single-Server Queues

Comments

Information

Published In

Sponsors

Publisher

Publication History

Check for updates

Qualifiers

Conference

Acceptance Rates

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Login options

Full Access

View options

PDF

eReader

Share

Share this Publication link

Share on social media

Affiliations