Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 8. Queuing Theory > mmMMSQ, Queuing Model with Queue Length

Business Formulas

mmMMSQ, Queuing Model with Queue Length

Category: Queuing

The MMSQ Queuing Model with Queue Length assumes that the size or capacity of the waiting area is infinite so that all arrivals to the system join the queue and wait for service.

Syntax

mmMMSQ(Arrival_Rate, Service_Rate, Number_Servers, Max_Queue, Optional Labels, Optional Show_Time, Optional Chart_Boundary, Optional Chart_Data)

Arrival_Rate Average number of arrivals per time period
Service_Rate Number of jobs or customers that can be served per time period
Number_Servers Number of employees or machines serving
Max_Queue Maximum number of clients or jobs in the waiting queue
Labels Optional - TRUE shows long report labels in output, FALSE shows short report labels
Show_Time Optional - TRUE shows time using mmDHSM, FALSE shows time as a number
Chart_Boundary Optional - Lower probability limit to return results for
Chart_Data Optional - TRUE returns the number of classes with probability larger than zero

Example

See example file Business Formulas.xls, sheet mmMMSQ.

Business analysis formulas for Excel. Marketing tool for professionals

Note: This is an Array Function (curly brackets { } ). To enter an array function: (1) select the range where you want to enter it, for instance, A21:B38; (2) type the formula; (3) press CTRL+SHIFT+ENTER.

Related functions
  • mmDHMS
  • mmMD1
  • mmMG1
  • mmMMS
  • mmMMSP
  • mmPERTSD
  • mmPERTT
  • mmPERTVAR
Related MM4XL software tools
  • Quality Analyst
  • Risk Analyst
  • Decision Tree
  • Gravity Analysis
Source
Cliff T. Ragsdale, 2001, Spreadsheet modeling and decision analysis
Lifetime license:
MM4XL All Tools
Price: euro 238.00

Vote this tool
403 votes: vote vote vote vote vote
5 stars:
145
4 stars:
187
3 stars:
61
2 stars:
8
1 star:
2
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: