Site icon Kellblog

Lessons from Playing with a Simple Quota Attainment Model

Quota attainment can get confusing quickly. It’s simple concept, but:

In short, there’s enough potential for confusion here that I recommend three things:

I have embedded such a model below, and you can download it here.

Let’s quickly have some fun looking at the scenarios I created:

If you find yourself in conversations about attainment and things start to get confusing, I’d whip out a model like this and start playing with scenarios. You can download this sheet here.

# # #

Notes

[1] Nomenclature: X% at Y% means X% of reps at or above Y% of their quota.

[2] The title is about “proving a repeatable sales process” because a common use of attainment statistics is to prove sales model repeatability.

[3] When done my way (i.e., based on productivity) every number in the model (except the one row with quota) is a realistic take on what we expect to sell. The alternative is to have every number uplifted by 20-30% and then need to do constant mental discounts. That’s too much work that’s too easily forgotten. Start your model on Earth.

[4] Some companies run two layers of cushion: quota to productivity (to account for the fact that 100% of quota is rarely realized) and then productivity to plan (to add extra cushion to increase the odds of hitting plan).

[5] The sum of the quotas for each of the reps, forgetting management layers and cushions, which can complicate things endlessly.

[6] “At” here means “at or above.” I wanted to make many sentences less wordy.

[7] People aren’t great at statistics and distributions and often screw up even simple mental math. For example, if you have a 20% cushion between quota and productivity and you say we need 80% of reps at 100% of plan, then you are also saying that the plan is to beat plan. While that might sound like a great locker room speech, it’s bad analytics. If 80% are at 100%, you hit plan. Any over-performance (and there always is) by the hundred-plus percenters takes you above plan, and any contributions from the 20% of reps below quota take you beyond that.

[8] My intent at picking 50% is both that it’s an unacceptable performance and, while you should model it out for your company, they are likely unprofitable to carry, depending on cost of sales and marketing support resources. Reps at 80% aren’t achieving plan but they are usually squarely profitable.

[9] And they’re not wrong to do so, but well, you did make plan.

[10] Orange cells are drivers/input cells that you can type in. One only hopes their OTE is $150K so it’s inline with a 4x+ quota/OTE ratio and that they don’t require heavy support resources. Then, resetting the quotas might just be the solution.

Exit mobile version