ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Preamble
3
This sheet is desinged to help revenue leaders with Quota Planning, enabling them to run scenarios with their teams to see where they need to set quotas based on the salaries and other costs associated with their reps and managers. It takes into account the rep base and bonus, manager costs and the associate overhead that comes with full time employees (fully burdened cost).

This framework is simple and uses a 'salary and up' approach to quota planning. I'm sure that you'll also need to do your revenue planning and then see how these different tools can meet in the middle. Feel free to add to it or edit it based on your experience and give me feedback on what you have adjusted to make it work for you. Hit me up at paul@cinc.co

Oh, and there is another bonus tab on Salary Benchmarks. I found it on the internet, so I can't vouch for the source but it seems sort of in line with expectations.

4
Instructions:
5
•The GREEN boxes are the main ones you can input in to change the outputs (i.e. the multipliers or quota adjustment)
•The GREY boxes are outputs
•This is meant to be a working file so you can adjust your multipliers and see how you can make your team more efficient, either by adjusting salaries, multipliers or the quotas themselves
•If you want to use/edit/change this document, choose "make a copy" of the sheet, don't ask for editing access to the file
•If you like what you see, feel free to sign up for more random things I'll share, or follow me on LinkedIn

6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100