The Cost of Delayed Time-to-Hire and Ramp

	A	B	E
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	$ Lost from Unfilled Headcount
6
7	Number of Reps to be Hired	2	Change
8	Weeks Delayed in Hiring	2	Do Not Change
9	Monthly Quota When Ramped	30000
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