Branch Teller Peak Hour Ratio Scheduler

Screen observed peak-hour workload against explicit mean service time/utilization and actual scheduled tellers, retaining staffing deficit; deterministic capacity model, not queue-delay guarantee, labor policy or staffing recommendation.

Description

A deterministic teller-capacity model converts arrivals and service minutes into workload.

A deterministic teller-capacity model converts arrivals and service minutes into workload. Target utilization expands the required headcount.1

The returned values include Required modeled teller counts, Signed scheduled minus required tellers. The How section below explains the calculation, input rules and interpretation.

When to use Branch Teller Peak Hour Ratio Scheduler

Use Branch Teller Peak Hour Ratio Scheduler when you need to evaluate the supplied records under the calculation and evidence rules below. No queue-delay guarantee, labor policy or staffing recommendation is supplied.

Prepare observed financial records and verified caller terms. Use one currency for integer minor-unit money and preserve leading zeros in identifier text. One basis point is 0.01 percentage points. Resolve dates, local clocks, counting rules and evidence flags as specified.

How to use Branch Teller Peak Hour Ratio Scheduler and understand its results

  1. Prepare observed financial records and verified caller terms. Use one currency for integer minor-unit money and preserve leading zeros in identifier text. One basis point is 0.01 percentage points. Resolve dates, local clocks, counting rules and evidence flags as specified.
  2. Enter observedPeakArrivalCountsByHour, callerMeanServiceMinutes, callerMaximumUtilizationFraction, observedScheduledTellerCounts using the field table and calculation rules, then run the tool.
  3. Read requiredModeledTellerCounts, signedScheduledMinusRequiredTellers. The explanation below defines the units, signs, ordering and any flags or placeholder values.
  4. If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
Input fieldMeaningValue type; see rules belowRequirement
observedPeakArrivalCountsByHourObserved peak arrival counts by hourlist of numberRequired
callerMeanServiceMinutesCaller mean service minutesnumberRequired
callerMaximumUtilizationFractionCaller maximum utilization fractionnumberRequired
observedScheduledTellerCountsObserved scheduled teller countslist of numberRequired

Enter aligned nonempty integer arrivals/scheduled tellers 0–1000000, positive finite mean service minutes and utilization in (0,1]. Derived required counts must be integers at most 1000000. Return required counts and signed staffing margins.

required_i=ceil(arrivals_i×meanServiceMinutes/(60×utilization)); margin_i=scheduled_i−required_i

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output fieldMeaningValue type
requiredModeledTellerCountsRequired modeled teller countslist of number
signedScheduledMinusRequiredTellersSigned scheduled minus required tellerslist of number
json
{
  "input": {
    "observedPeakArrivalCountsByHour": [
      20,
      30
    ],
    "callerMeanServiceMinutes": 5,
    "callerMaximumUtilizationFraction": 0.75,
    "observedScheduledTellerCounts": [
      2,
      4
    ]
  },
  "output": {
    "requiredModeledTellerCounts": [
      3,
      4
    ],
    "signedScheduledMinusRequiredTellers": [
      -1,
      0
    ]
  }
}

Limitations and assumptions

No queue-delay guarantee, labor policy or staffing recommendation is supplied.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Numeric lists are limited to 10,000 entries; string lists to 128 strings of at most 128 characters each. The rules above may impose smaller limits. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Teller Drawer Variance Limit Checker: Drawer over/short compares counted denomination inventory with expected cash from the opening balance and ledger. A signed deficit differs from a tolerance flag. For a complementary task, use Alert Backlog Aging Checker: Backlog aging reviews unresolved alerts against a caller threshold. An absent unresolved subset needs an explicit unavailable oldest age.

References

  1. Branch Teller Peak Hour Ratio Scheduler — tool.io

Similar or alternative tools

  • Teller Drawer Variance Limit Checker

    Drawer over/short compares counted denomination inventory with expected cash from the opening balance and ledger. A signed deficit differs from a tolerance flag.

  • Alert Backlog Aging Checker

    Backlog aging reviews unresolved alerts against a caller threshold. An absent unresolved subset needs an explicit unavailable oldest age.

Don't forget to set a bookmark for tool.io!
Privacy | Imprint | Cookies