Calculator inputs
Plotly graph
This chart shows the contact drivers shaping your support queue.
Example data table
| Scenario | Forecast Days | Daily Orders | Gross Contacts | Assisted Contacts | Workload Hours | Peak FTE |
|---|---|---|---|---|---|---|
| Baseline Month | 30 | 500 | 2,120 | 1,527 | 220.5 | 4.31 |
| Holiday Push | 30 | 900 | 4,331 | 3,118 | 451.4 | 8.57 |
| Automation Upgrade | 30 | 900 | 4,331 | 2,515 | 360.1 | 6.83 |
Formula used
Projected Daily Orders = Current Daily Orders × (1 + Growth Rate) × Seasonality Multiplier × Promotion Multiplier
Projected Orders = Projected Daily Orders × Forecast Days
Base Contacts = Pre-sale Contacts + Return Contacts + Defect Contacts + Shipping Contacts + Cancellation Contacts + Payment Contacts + Other Contacts
Repeat Contacts = Base Contacts × Repeat Contact Rate
Assisted Contacts = (Base Contacts + Repeat Contacts) × (1 − Automation Deflection) × (1 − Self-service Resolution)
Weighted AHT = Σ(Channel Share × Channel AHT)
Total Workload Hours = Assisted Contacts × Weighted AHT ÷ 60
FTE = Total Workload Minutes ÷ [Agent Hours per Day × 60 × Open Days × Occupancy × (1 − Shrinkage)]
How to use this calculator
- Enter your planning horizon, support open days, and current daily order volume.
- Add growth, seasonality, promotion, and peak-day assumptions to reflect expected ecommerce demand shifts.
- Fill in issue rates for returns, defects, shipping, cancellations, payments, and other contacts.
- Set contacts per issue and repeat contact rate to model follow-up demand realistically.
- Enter automation and self-service assumptions to estimate how much demand avoids human handling.
- Provide channel mix and average handle time for email, chat, phone, and social support.
- Add staffing conditions such as shift length, occupancy, and shrinkage.
- Press Estimate Support Demand to see projected contacts, workload hours, FTE needs, and the Plotly graph.
FAQs
1) What does this calculator estimate?
It estimates ecommerce support demand by combining projected orders, issue rates, repeat contacts, channel mix, automation, and staffing efficiency into workload and FTE outputs.
2) Why include pre-sale inquiries?
Pre-sale questions can become a large share of demand during launches, price changes, and promotions. Ignoring them usually understates staffing needs.
3) What is contacts per issue?
It reflects how many times a single issue creates customer contact. Complex refunds, exchanges, or delayed shipments often require more than one touch.
4) Why does the calculator normalize channel shares?
Teams often enter channel percentages that do not total exactly 100. Normalization preserves their intended mix while keeping calculations mathematically consistent.
5) What is the difference between base FTE and peak FTE?
Base FTE covers average demand across the full forecast period. Peak FTE estimates the staffing needed on your busiest day after applying the peak multiplier.
6) How should I choose occupancy and shrinkage?
Use actual team history when possible. Occupancy often sits below 85%, while shrinkage should include meetings, breaks, coaching, absences, and admin work.
7) Can this model automation improvements?
Yes. Increase automation deflection and self-service resolution to test how bots, portals, macros, and knowledge content reduce human-assisted workload.
8) Is this suitable for weekly and monthly planning?
Yes. Adjust forecast days and open days to match your cycle. The same model works for short campaign planning or broader monthly capacity planning.