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

Business Formulas

mmMD1, Queuing Model with Finite Population

Category: Queuing

The MD1 Queuing Model replaces the MG1 model when the service times are deterministic (not random).

Syntax

mmMD1(Arrival_Rate, Service_Time, Optional Labels, Optional Show_Time)

Arrival_Rate Average number of arrivals per time period
Service_Time Number of jobs or customers that can be served per time period
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

Example

See example file Business Formulas.xls, sheet mmMD1.

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

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