Rep Capacity Planner
Use sales representatives, hours per rep/week, weeks in period, selling time (%) to prepare the rep capacity planner record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Use sales representatives, hours per rep/week, weeks in period, selling time (%) to prepare the rep capacity planner record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Turning the revenue target into a measurable sales workload
This worksheet calculates the displayed relationship from the supplied quantities. Its label and period conventions determine how the amount should be interpreted. Pipeline planning joins deal value, conversion and time. The model should use opportunities that meet a defined qualification stage, rather than every contact in the CRM. Deal concentration matters when a few large accounts dominate an average.
Scope of this operation
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options. The example output for rep capacity planner is shown below so the supplied source can be checked against the actual format. It is not evidence that the operation has run against your own file or account.
How it works
Available selling hours = [Sales representatives] × [Hours per rep/week] × [Weeks in period] × [Selling time (%)] ÷ 100
Inputs
| Field | Example | Definition |
|---|---|---|
| Sales representatives | 5 | Use the source quantity represented by sales representatives. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Hours per rep/week | 40 | Use the duration unit stated in hours per rep/week. A time period is not interchangeable with a currency amount or a count of events. |
| Weeks in period | 4 | Use the duration unit stated in weeks in period. A time period is not interchangeable with a currency amount or a count of events. |
| Selling time (%) | 60 | Enter selling time (%) on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
Step-by-step guide
Prepare the source
Supply Sales representatives, Hours per rep/week, Weeks in period. Keep the original material so the output can be compared with it.
Build output
Check Sales representatives, Hours per rep/week, then select Generate output.
Use the result
Compare the rep capacity planner result with the unchanged source before copying or downloading it.
When to use it
Available selling hours = [Sales representatives] × [Hours per rep/week] × [Weeks in period] × [Selling time (%)] ÷ 100 The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Example and scope
Example inputs: Sales representatives: 5; Hours per rep/week: 40; Weeks in period: 4; Selling time (%): 60.
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Worked output
Available selling hours: 480 Assumptions: reps: 5 hours: 40 weeks: 4 utilization: 60
Related tool family
This focused tool is associated with Sales Quota Attainment Calculator. Use it when you need to isolate a specific part of that wider workflow.
Several parent models may support the same step. Keep the business question visible and choose the version that best matches the process you actually need to manage.
Related parent models
Sales Quota Attainment Calculator, Sales Target Calculator, Pipeline Coverage Calculator, Required Pipeline Calculator, Lead to Opportunity Conversion Calculator, Opportunity Win Rate Calculator, Average Deal Size Calculator, Sales Cycle Calculator
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026