Map Extract
Free tool

Set sales quotas from your revenue target

Dividing the target by the number of salespeople gives a quota nobody hits, because new starters are still learning, and not everyone reaches 100%. This calculator spreads the target across full and ramping reps, adds an over-assignment buffer, shows the bookings you can expect at realistic attainment, and checks the quota against what one rep can actually close.

Runs in your browser. Nothing you enter is uploaded.

Setting the quota

  1. Start from an example

    A team of ten with two ramping, a founder plus two reps, or a quarterly quota. Overwrite the numbers with yours.

  2. Enter the target and the team

    Revenue target for the period, the number of fully ramped reps and the number still ramping, with the share of a full quota a ramping rep carries.

  3. Add the buffers

    Over-assignment sets total quota above the target to cover misses. Expected average attainment is the share of quota your reps typically reach.

  4. Check capacity from the bottom up

    Enter opportunities per rep a month, win rate, average deal and months in the period. The calculator works out what one rep can close and compares it with their quota.

  5. Read and export

    Quota per full rep, total quota assigned, full rep equivalents and expected bookings, with how far above or short of the target they land. Export the plan as CSV, Excel or JSON.

Example: a founder, one rep and a new starter

A small software business wants £450,000 of new bookings this year. It has two fully ramped sellers (the founder and one rep) and one new starter who will carry half a quota. With 10% over-assignment there are 2.5 full rep equivalents, a total quota of £495,000 and £198,000 per full rep.

At the 80% attainment the team usually reaches, expected bookings are £396,000, £54,000 short. The capacity check confirmed the problem: with 8 opportunities a month, a 30% win rate and £6,000 deals, one rep closes about £172,800 a year, so the quota is 114.6% of what a rep can do. The fix was more pipeline per rep rather than a higher quota.

Input
Target: £450,000   Full reps: 2   Ramping: 1 at 50%   Over-assignment: 10%   Attainment: 80%
Capacity: 8 opportunities a month, 30% win rate, £6,000 average deal, 12 months
Result
Quota per full rep: £198,000.00   Total quota: £495,000.00   Full rep equivalents: 2.5
Expected bookings: £396,000.00 (£54,000.00 short of target)
Quota is 114.6% of what one rep can close. A rep with 8 opportunities a month at a 30% win rate closes about £172,800.00 in the period.

What each input does

InputEffect on the quota
Ramping reps carryA rep at 50% counts as half a person when the target is shared out
Over-assignmentTotal quota = target × (1 + over-assignment), so a few misses do not sink the plan
Expected attainmentExpected bookings = total quota × attainment; shows whether the plan reaches the target
Capacity per repOpportunities × win rate × deal × months; a quota far above it is unlikely to be met

Questions people ask

How do you set a sales quota?

Start from the revenue target, count full rep equivalents (ramping reps count partly), add an over-assignment buffer, and divide. Then check the result against capacity: how many opportunities a rep handles, their win rate and deal size. A quota above that capacity will be missed however hard the rep works.

What is over-assignment in sales quotas?

It means the total of all reps' quotas is set above the company target, so the target can still be reached if some reps fall short. The calculator applies the percentage you choose and shows expected bookings at your typical attainment, so you can see whether the buffer is enough to cover the misses you usually see.

How should quotas work for new salespeople?

New starters usually carry a reduced quota while they build pipeline and learn the product, rising to a full quota over several months. Enter the share a ramping rep carries, such as 50%, and the calculator counts them as part of a full rep when splitting the target.

What if the quota is above a rep's capacity?

The calculator flags it in amber or red. Either raise capacity, with more opportunities per rep, a better win rate or bigger deals, or lower the quota and hire. Setting quotas most reps cannot reach tends to hurt morale and makes forecasts unreliable.

Where your data goes

Targets, team sizes and capacity figures are calculated in your browser. No plan details are uploaded or saved.

Checked against the tool on

Top