Graphical Spreadsheet Simulation of Queues

Graphical representations of spreadsheet queueing simulations can be used to teach students about queues and queueing processes. A customer graph shows the experience of every individual customer in a queue, based on arrival time, start of service, end of service, and showing clearly the length of time in queue and service time for each individual customer. The cumulative effect is powerful, illustrating how one long service time (or short interarrival time) can cause delays for many succeeding customers. The server graph (a Gantt chart) shows the experience of each server, illustrating how customers stack up, and the nature of periods of idle time. The graphs are linked to a spreadsheet simulation and update instantly when the simulation is replicated. The graphs illustrate the complete evolution of a queue (which simulation animations cannot do) and help provide a holistic view of queues. They can be used to teach students about the nature of queues and support active learning where the students articulate for themselves the cause of queue behaviors.