MOPS Team Size Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
© 2017 Josh Hill, Marketing Rockstar Guides. Creative Commons License 4.0 with Attribution
https://creativecommons.org/licenses/by-sa/4.0/
2
These are base assumptions only. Please modify the numbers or calculations to better fit your situation
3
4
5
Rule of Thumb Method - ratios and levels of activity indicating requirements
6
Do not total Column D. The same people could perform similar jobs, however, each major product integration needs a manager
7
FactorEstimatesNotes
Possible FTE Required
8
Size of Marketing team50Indicates level of activity6.25
One person for every 8 marketers
9
Size of Company by Employees1000Indicates level of activity
10
Annual Revenue $ 100,000,000.00 Indicates level of activity
11
% of Revenue Dedicated to Marketing
3%Available Resources
12
Marketing Budget $ 3,000,000.00
Available Resources, Activity
13
Sales OperationsYesIndicates level of activity1
One person if Sales Ops to deal with relationship
14
Revenue OperationsNo1
One person if no revenue ops
15
Size of Database (Records)100,000Indicates level of activity0.1
One person per Million (but that's a rule of thumb)
16
SaaS intgrations?YesIndicates level of activity1
One person for integration
17
Product Integrations?YesIndicates level of activity1
One person for integration
18
Demand Gen Team Size5Indicates level of activity1
One person for every 5 marketers
19
Global TeamYesIndicates level of activity2
20
Marketing Data WarehouseYesIndicates level of activity1
at least one person must manage this.
21
22
Production and Programs Method - this is used to determine how many marketing automation people may need to support non technical marketers.
23
FTE Load Factor15%
24
25
Salaries:BaseFully Loaded# FTETotal Cost
Hours Available
Cost per Hour
26
Entry Level$65,000 $ 74,750.00 1 $ 74,750.00 1920 $ 38.93
27
Mid Level$100,000 $ 115,000.00 0.25 $ 28,750.00 480 $ 59.90
28
Expert Admin$130,000 $ 149,500.00 1 $ 149,500.00 1920 $ 77.86
29
People Manager$140,000 $ 161,000.00 1 $ 161,000.00 1920 $ 83.85
30
Totals3.25 $ 414,000.00 6240 $ 65.14
31
32
Hours RequiredRate
33
# of Programs per Week10
34
Hours per Program (avg)5
35
Hours per Week Required50
36
Hours per Week per FTE40
37
FTE Required 1.25
38
39
Agency CalculatorRateCompare to In House
Savings with In House
40
Cost of Agency Hours $ 160.00 $ 65.14
41
Hours Used per Week50
42
Cost per Week $ 8,000.00
43
Hours per Q 650
44
Hours per A 2,600
45
Cost per Q $ 104,000.00
46
Cost per A $ 416,000.00 $ 414,000.00 $ 2,000.00
47
Hours Available per Year26006240-3640
48
49
The advantage of an agency is more flexibility to scale up or down, or swap in better performers faster.
50
The downside is that they will never care as much as in-house staff.
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
Loading...
Main menu