The Cost of Delayed Time-to-Hire and Ramp
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTU
1
Please make a copy and add this sheet to your drive to get started.
2
How to use this formula:
It helps to see the impact of unfilled headcounts and slow ramp when you can put it in your own numbers. Use this formula to forecast the cost of unfilled sales headcount when it takes an extra month or two to hire the right sales rep or manager.
3
4
$ Lost from Unfilled Headcount
5
6
7
Number of Reps to be Hired2Change
8
Weeks Delayed in Hiring2Do Not Change
9
Monthly Quota When Ramped30000
10
Dollars Expected During Ramp (Total)25000
11
Ramp Time (Months)3
12
Year One Expected Contribution (Per Rep)295000
13
14
Year One: Impact of Missing Headcount (Total) $ 22,692.31
15
16
Year Two: Delayed Revenue of Missing Headcount (Total) $ 30,000.00
17
18
Total Impact of Delayed Hiring $ 52,692.31
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
Loading...