This lab involves solving a queueing network problem by hand and in Excel. We will also use the Excel queueing model to perform what-if analysis. The videos will guide you through:
- Understanding the basics of queueing analysis
- Solving the queueing network by hand
- Using the Excel model of the queueing network to perform what-if analysis (we will use Excel’s Data Table to accomplish this task)
- Developing a Simio model of the queueing system to verify our “solution” calculated by hand
Related Lab Files:
Video 1: Introduction to Queueing Systems, Problem Description
Topics covered in this video:
– Introduction to queueing systems (components, notations, formulas, etc.)
– Approximation queueing models
– Typical performance metrics in queueing analysis
– Jackson Network and it’s assumptions
Video 2: Solving Queueing Network, Feedback Loop
Topics covered in this video:
– Solving M/M/1 and M/M/c queueing models
– Re-entrant flow and effective arrival rate
Video 3: M/M/c Calculations, Little’s Law, What-If Analysis Using Excel
Topics covered in this video:
– Number in system
– Time in system and Little’s Law
– Solving queueing networks in Excel
– What-if analysis using Excel’s Data Table
– Simulation to verify queueing calculations
ashkannegahban.com 