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

Authors:
Marco Aurélio de Mesquita;Alvaro Euzebio Hernandez
Affiliations:
Escola Politécnica - Universidade de São Paulo, São Paulo, SP, Brazil;Escola Politécnica - Universidade de São Paulo, São Paulo, SP, Brazil
Venue:
Proceedings of the 38th conference on Winter simulation
Year:
2006

Citing 3
Cited 1

An introduction to simulation modeling

WSC '96 Proceedings of the 28th conference on Winter simulation
Teachers' Forum: Spreadsheet Modeling and Simulation Improves Understanding of Queues

Interfaces
Theory, Volume 1, Queueing Systems

Theory, Volume 1, Queueing Systems

Monte Carlo simulation to propose improvements of an alkyd resin process

SMO'07 Proceedings of the 7th WSEAS International Conference on Simulation, Modelling and Optimization

Quantified Score

Hi-index	0.00

Visualization

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.