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

Published Online:https://doi.org/10.1287/ited.3.3.86

Spreadsheets are 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.

INFORMS site uses cookies to store information on your computer. Some are essential to make our site work; Others help us improve the user experience. By using this site, you consent to the placement of these cookies. Please read our Privacy Statement to learn more.