Inputs
Choose a method, enter assumptions, then generate a forecast and staffing estimate.
Example Data Table
Use this as a reference for building your ticket history and order-rate assumptions.
| Week | Orders | Tickets | Tickets / 1,000 Orders | Notes |
|---|---|---|---|---|
| W1 | 4,800 | 240 | 50.0 | Stable operations |
| W2 | 5,100 | 255 | 50.0 | Minor shipping delays |
| W3 | 5,250 | 268 | 51.0 | New product drop |
| W4 | 5,600 | 280 | 50.0 | Promo traffic |
| W5 | 5,900 | 295 | 50.0 | Returns increase |
| W6 | 6,200 | 310 | 50.0 | Higher support demand |
If your ticket rate is stable, use the Per Order Rate method. If demand trends upward, use Trend + Seasonality. For noisy data, try smoothing.
Formula Used
Common multipliers
- Multiplier = Seasonality × (1 + Uplift%)
- Peak Workday = Avg Workday × Peak Factor
- Agents Required = ceil((Peak / Capacity) × (1 + Buffer%))
Operational capacity and backlog
- Workdays = CalendarDays × (WorkdaysPerWeek / 7)
- CapacityTotal = Agents × CapacityPerAgent × Workdays
- BacklogEnd = max(0, BacklogStart + Demand − CapacityTotal)
Forecasting methods
Trend + Seasonality
Compounding growth per unit.
Tickets(i) = Base × (1 + Growth)ᶦ × Multiplier
Total = Σ Tickets(i), i = 1..H
Per Order Rate
Uses ticket-to-order conversion.
Total = Orders × (TicketsPer1000 / 1000)
Total = Total × Complexity × Multiplier
Weighted Moving Average
Recent periods can matter more.
Forecast = Σ(Historyᵢ × Weightᵢ)
Forecast = Forecast × Multiplier
Exponential Smoothing
Alpha controls responsiveness.
S₀ = x₀
Sₜ = αxₜ + (1−α)Sₜ₋₁
Forecast = S_last × Multiplier
How to Use This Calculator
- Select a forecasting method that matches your data.
- Set the horizon and unit to match your planning window.
- Enter seasonality and uplift to reflect special periods.
- Provide staffing capacity to estimate agent requirements.
- Press Submit to view results above the form.
- Download CSV or PDF for sharing and scheduling.