A Dynamic Queuing System: Interactive Spreadsheets and Data Analytics
Keywords:
business, economics, spreadsheets, queuing analysis, single channel, multi-channelAbstract
Queuing theory is an important field of Operations Research with wide applications in the service industry as well as in healthcare settings. This paper is motivated by a recent visit to a local DMV (Department of Motor Vehicles) office and upon observing the queuing system they use at that office. In this paper, we create interactive spreadsheets of a smaller and a modified version of such a dynamic queuing system. We discuss how our proposed system has additional features and provide future directions to make our system superior and efficient.
References
Braun, K.W. (2017). Excel-based Active Learning. Strategic Finance, 42–49.
Economou, A., Logothetis, D., & Manou, A. (2022). The value of reneging for strategic customers in queueing systems with server vacations/failures. European Journal of Operational Research, 299, 960–976.
Formby, S.K., Medlin, D., & Ellington, V.B. (2017). Microsoft ExcelVR: Is it an important job skill for college graduates? Information Systems Education Journal, 15(3), 55–63.
Grossman, T.A. (1999). Spreadsheet modeling and simulation improves understanding of Queues. Interfaces, 29(3), 88–103.
Higgins, E., Bailey, M., & Guardiola, I. (2020). Case article – Converting NFL point spreads into probabilities: A case study for teaching business analytics. INFORMS Transactions on Education, 21(1), 45–48.
Leong, T.Y., & Cheong, M.L. (2008). Teaching business modeling using spreadsheets. INFORMS Transactions on Education, 9(1), 20–34.
Leong, T.Y., & Ma, N.L. (2024). Spreadsheet Simulation of Priority Queues. INFORMS Transactions on Education, 25(1), 1–22.
Patrick, J., Montazeri, A., Michalowski, W., & Banerjee, D. (2019) Automated pathologist scheduling at the Ottawa hospital. INFORMS Journal on Applied Analytics, 49(2), 93–103.
Stevenson, W. (2017). Operations Management (12th edition). McGraw Hill.
Winston, W.L., & Albright, S.C. (2019). Practical Management Science (6th ed.). Cengage.
