Blog · Territory, capacity and quota planning · Sales teams
Sales expectations work when the outcome, selling behaviors and available capacity fit together. Use a CRM export to check the proposed target, then write an agreement with clear ownership and a regular review.
Sales expectations should define results, observable selling behaviors and the support needed to deliver them. Check the proposed target against historical conversion and available time before asking a seller to commit. Then write a short agreement that makes the assumptions and review process visible.
Use opportunity ID, owner, qualification date, outcome, close date, booked amount and recorded selling hours. Keep the revenue definition consistent: this example uses booked sales, not recognized revenue. Use one row per opportunity, with activity hours summarized separately before matching them to that row.
Select a qualification cohort old enough to have completed its normal buying window. Include both wins and losses, and disclose any unresolved opportunities. Mixing this month's new opportunities with this month's closed deals produces a conversion rate between different populations.
For the broader distinction between bookings, revenue and pipeline, see questions a CFO asks about sales data. Here the narrower job is to agree what the seller and manager will do.
An illustrative US industrial supplier summarizes one rep's completed opportunity cohort below. The figures are planning inputs, not an industry benchmark. Selling hours include the recorded work associated with those opportunities across their full sales process.
| Outcome | Opportunities | Booked sales (USD) | Selling hours |
|---|---|---|---|
| Won | 5 | 100,000 | 15 |
| Lost | 15 | 0 | 45 |
| Total | 20 | 100,000 | 60 |
In a raw export, suppose owner is column B, cohort is C, outcome is D and booked amount is E. Count Alex's completed-cohort wins in Excel with:
=COUNTIFS(B2:B1000,"Alex",C2:C1000,"Completed",D2:D1000,"Won")
Remove the outcome condition to count the full cohort. Microsoft's COUNTIFS documentation explains counting rows that meet all specified criteria. Sum the booked amounts on the same basis:
=SUMIFS(E2:E1000,B2:B1000,"Alex",C2:C1000,"Completed",D2:D1000,"Won")
Microsoft documents SUMIFS as adding values that meet multiple criteria. Keep all ranges aligned and exclude duplicated opportunity rows. Covirage is not affiliated with Microsoft.
The summary gives conversion of 5 / 20 = 25.0%, average won deal size of 100,000 / 5 = $20,000 and selling effort of 60 / 20 = 3 hours per qualified opportunity. Check that the outcome counts sum to the cohort total and that booked sales tie to the sales register.
The next planning period covers four weeks. The seller and manager supply these assumptions:
| Planning input | Value |
|---|---|
| Booked-sales target (USD) | 120,000 |
| Planning weeks | 4 |
| Selling hours available per week | 20 |
| Other committed deal work, hours | 16 |
Apply the historical baseline to the proposed target:
| Step | Calculation | Result |
|---|---|---|
| Wins required | 120,000 / 20,000 | 6 |
| Qualified opportunities required | 6 / 25.0% | 24 |
| Opportunity work, hours | 24 × 3 | 72 |
| Total required hours | 72 + 16 | 88 |
| Available hours | 4 × 20 | 80 |
| Capacity gap, hours | 88 − 80 | 8 |
If the target is B2, average deal size B3, conversion B4, hours per opportunity B5, other work B6, weeks B7 and weekly selling hours B8, the exact formulas are:
Wins required: =ROUNDUP(B2/B3,0)
Opportunities required: =ROUNDUP(ROUNDUP(B2/B3,0)/B4,0)
Required hours: =ROUNDUP(ROUNDUP(B2/B3,0)/B4,0)*B5+B6
Available hours: =B7*B8
Round required wins and opportunities up to whole counts. Other displayed percentages use one decimal place.
These are steady-state workload equivalents, not a promise that newly qualified opportunities will close within four weeks. Check sales cycle length and the starting pipeline separately. The effort estimate also assumes the next cohort requires similar work and that its 16 hours of other work are excluded from the cohort estimate.
The current assumptions do not fit. The manager must identify eight additional selling hours, remove equivalent work or revise the target. Historical sales of $100,000 imply five wins and twenty opportunities; their estimated workload is 20 × 3 + 16 = 76 hours.
Separate the outcome from the behaviors the seller controls. An expectation can require a documented customer next step for active opportunities without treating a particular call count as guaranteed revenue.
| Agreement element | What to write |
|---|---|
| Outcome | Booked-sales target, period and included accounts |
| Selling behavior | Qualification evidence and a dated next step for each active deal |
| Data responsibility | Update outcome, amount and expected close date after material changes |
| Manager support | Resolve the eight-hour capacity gap before confirming this proposal |
| Review | Weekly blockers and monthly results against recorded assumptions |
At review, ask whether the shortfall came from opportunity supply, conversion, deal value, timing or unavailable capacity. Keep the discussion specific. The new-business and expansion capacity comparison covers the separate decision about where selling effort belongs.
Bring your CRM opportunity export and a file of planned selling capacity. Covirage maps the columns, its tools compute and check the historical measures and workload comparison, and the external AI model explains the findings with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See capacity planning for the supporting business context.
Include an outcome measure, observable selling behaviors, workload limits, data responsibilities and the manager's commitments. State the period and how each measure will be checked. A revenue target without agreed account coverage, lead quality and available time leaves important assumptions unstated.
Use consistent definitions, but account for differences in territory, account mix, tenure and responsibilities. A seller managing renewals has a different workload from a seller building a new territory. Document the reason for different expectations rather than allowing unexplained exceptions.
A weekly check can address deal blockers and work quality, while a monthly review can compare outcomes and workload with the assumptions. Choose a cadence that fits the buying cycle. Record changes with effective dates so the original agreement remains understandable.
Identify the missing capacity and assign an owner to resolve it. Possible responses include removing other work, changing coverage or revising the target. Higher conversion or larger deals can be scenarios, but they should not be treated as committed improvements without supporting evidence.