Spreadsheet Modeling of the G/G/c Queuing System without Macros or Add-Ins

Stephen C. Hora - Hora@Hawaii.edu
School of Business and Economics, University of Hawaii at Hilo,
200 W. Kawili St., Hilo, Hawaii 96720

Abstract

Spreadsheets have become a popular tool for teaching business students about waiting line systems. Modeling queuing systems with multiple servers, however, is somewhat difficult and ordinarily accomplished by using macros or by having multiple templates, each template with a different number of servers. Here, it is shown how native Excel array functions can be used to create a spreadsheet model with the number of servers being an adjustable parameter.

Download the PDF
10.1287/ited.3.3.86

Citation Information
Hora, S. C. 2003. Spreadsheet Modeling of the G/G/c Queuing System without Macros or Add-Ins. INFORMS Trans. Ed. 3(3) 86-89. Available online at http://ite.pubs.informs.org/.

DOI: 10.1287/ited.3.3.86