Free Call Center Capacity Planner Template
Plan staffing levels online with our free capacity planner, or download the spreadsheet template. Calculate required agents based on call volume, AHT, and shrinkage rate.
Online Capacity Planner
Enter your call volume, AHT, and shrinkage rate to calculate required staffing levels. No sign-up required.
Settings
Industry standard: 25–35%
Current staff count for gap analysis
Hourly Forecast
| Time Slot | Calls/Hour | AHT (min) | Required | Scheduled | Gap | |
|---|---|---|---|---|---|---|
| 8 | 15 | +7 | ||||
| 12 | 15 | +3 | ||||
| 15 | 15 | +0 | ||||
| 14 | 15 | +1 | ||||
| 10 | 15 | +5 | ||||
| 11 | 15 | +4 | ||||
| 14 | 15 | +1 | ||||
| 13 | 15 | +2 | ||||
| 11 | 15 | +4 | ||||
| 6 | 15 | +9 |
Total Calls
915
Peak Required
15
Avg Required
11
Understaffed
0 / 10
What This Covers
| Sheet | Purpose |
|---|---|
| Call Volume Forecast | Enter historical call data by month, week, and day -- template calculates trends and projections |
| Staffing Calculator | Input AHT, shrinkage rate, and service level target to calculate required agents per interval |
| Schedule Builder | Map agent shifts against forecasted demand to identify coverage gaps |
| Shrinkage Tracker | Log planned and unplanned shrinkage to refine your shrinkage rate over time |
Call Center Capacity Planning Formula
The core formula for calculating the number of agents you need:
Required Agents = (Call Volume x Average Handle Time) / (Available Time per Agent x (1 - Shrinkage Rate))
Example Calculation
| Input | Value |
|---|---|
| Expected calls per hour | 120 |
| Average Handle Time (AHT) | 5 minutes |
| Available time per agent per hour | 60 minutes |
| Shrinkage rate | 30% |
Required Agents = (120 x 5) / (60 x (1 - 0.30))
= 600 / 42 = 14.3 -- round up to 15 agents
This gives you a baseline. For more precise calculations that account for service level targets and acceptable wait times, use the Erlang C Calculator.
Key Variables
Call Volume
Number of incoming calls during a specific time interval. Pull from historical data and adjust for known events (campaigns, seasonal peaks, product launches).
Average Handle Time (AHT)
Total talk time + hold time + after-call work, measured in minutes.
Shrinkage Rate
Percentage of scheduled time when agents are unavailable for calls. Industry standard is 25-35%. Includes breaks, training, meetings, absences, and system downtime.
Service Level Target
Percentage of calls answered within a target time (e.g., 80% of calls answered within 20 seconds).
Occupancy Rate
Percentage of time agents spend handling calls versus waiting. Target 75-85% to avoid burnout.
How to Use the Template
1. Gather Historical Data
Collect at least 3-6 months of call volume data, broken down by hour of day and day of week.
2. Calculate Your AHT
Pull average handle time from your phone system or ACD reports.
3. Determine Your Shrinkage Rate
Use the shrinkage report template to calculate your actual planned and unplanned shrinkage.
4. Set Service Level Targets
Define your target (e.g., 80/20) based on customer expectations and business requirements.
5. Run the Staffing Calculation
Enter your inputs into the template to see required agents per interval.
6. Build the Schedule
Assign shifts to cover peak and off-peak periods. Stagger start times to smooth coverage.
7. Review and Adjust Weekly
Compare forecasted vs. actual call volumes and refine your model.
Frequently Asked Questions
Common questions about call center capacity planning.
Create a high-level plan 3-6 months out for hiring and training decisions. Refine it at the monthly level for scheduling, and make final adjustments weekly based on updated forecasts.
The 80/20 rule is a common service level target: 80% of calls answered within 20 seconds. The right target for your operation depends on customer expectations, call complexity, and cost constraints.
Start with industry benchmarks for call volume, AHT, and shrinkage. Use conservative estimates and plan to adjust aggressively in the first 30-60 days as real data comes in. Over-staff slightly at launch rather than risk poor customer experiences during ramp-up.
Capacity planning focuses on how many agents you need (demand forecasting and staffing calculations). Workforce management is broader and includes scheduling, real-time adherence, performance tracking, and ongoing optimization. Capacity planning is one input into the workforce management process.
The Erlang C formula calculates the probability that a call will wait in queue given a specific number of agents, call volume, and AHT. It is the industry-standard method for determining staffing requirements to meet a service level target. Use our Erlang C Calculator to run the calculation.
Track Agent Time and Manage Schedules
HiveDesk helps contact centers and BPOs track agent hours, monitor attendance, and manage schedules across shifts and time zones. $5/user/month, all features included.