mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 8. Queuing Theory > mmMMS, Basic Queuing Model

Business Formulas

mmMMS, Basic Queuing Model

Category: Queuing

The MMS Queuing Model assumes there are S servers and the total service capacity of the system must be greater than the rate at which arrivals occur.


mmMMS(Arrival_Rate, Service_Rate, Number_Servers, 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
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


See example file Business Formulas.xls, sheet mmMMS.

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
  • mmMMSP
  • mmMMSQ
  • mmPERTSD
  • mmPERTT
Related MM4XL software tools
  • Quality Analyst
  • Risk Analyst
  • Decision Tree
  • Gravity Analysis
Cliff T. Ragsdale, 2001, Spreadsheet modeling and decision analysis
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5