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.

Syntax

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

Example

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
  • 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: