mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 8. Queuing Theory > mmMMSP, Queuing Model with Finite Population

Business Formulas

mmMMSP, Queuing Model with Finite Population

Category: Queuing

The MMSP Queuing Model with Finite Population assumes that the number of arriving customers is finite.

Syntax

mmMMSP(Arrival_Rate, Service_Rate, Number_Servers, Population_Size, 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
Population_Size Maximum number of clients or jobs arriving per service time
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 mmMMSP.

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:B41; (2) type the formula; (3) press CTRL+SHIFT+ENTER.

Related functions
  • mmDHMS
  • mmMD1
  • mmMG1
  • mmMMS
  • 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:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: