| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Req posted | Assumed Ramp | |||||||||||||||||||
2 | Hired (3 months) | Month | To Ramp | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | ||||
3 | Confirmed | Mid Market | FTE | 6 | 0 | 0.17 | 0.33 | 0.50 | 0.67 | 0.83 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | |||
4 | SMB | FTE | 3 | 0 | 0.33 | 0.67 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | ||||
5 | Full Time Equivalent | ||||||||||||||||||||
6 | Employee | Role | Territory | Start Date | 8/1/2023 | 9/1/2023 | 10/1/2023 | 11/1/2023 | 12/1/2023 | 1/1/2024 | 2/1/2024 | 3/1/2024 | 4/1/2024 | 5/1/2024 | 6/1/2024 | 7/1/2024 | 8/1/2024 | 9/1/2024 | 10/1/2024 | 11/1/2024 | 12/1/2024 |
7 | Rep 1 | Mid Market | T0001 | 2/1/2022 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
8 | Rep 2 | Mid Market | T0002 | 2/15/2022 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
9 | Rep 3 | Mid Market | T0003 | 3/24/2022 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
10 | Rep 4 | Mid Market | T0004 | 1/26/2023 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
11 | CHURN | Mid Market | 0.00 | 0.00 | 0.71 | 0.71 | 0.71 | 0.71 | 1.07 | 1.26 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | ||
12 | Rep 5 | SMB | T0005 | 5/27/2023 | 0.67 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
13 | Rep 6 | SMB | T0006 | 3/23/2023 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
14 | Rep 7 | SMB | T0007 | 1/28/2022 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
15 | Rep 8 | SMB | T0008 | 10/17/2021 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
16 | CHURN | SMB | 0.00 | 0.00 | 0.54 | 0.73 | 0.73 | 0.73 | 0.92 | 0.92 | 1.09 | 1.09 | 1.26 | 1.26 | 1.26 | 1.26 | 1.26 | 1.39 | 1.39 | ||
17 | TBH 1 | Mid Market | 11/1/2023 | 0.00 | 0.17 | 0.33 | 0.50 | 0.67 | 0.83 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | ||||
18 | TBH 2 | Mid Market | 12/1/2023 | 0.00 | 0.17 | 0.33 | 0.50 | 0.67 | 0.83 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | |||||
19 | TBH 3 | Mid Market | 1/1/2024 | 0.00 | 0.17 | 0.33 | 0.50 | 0.67 | 0.83 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | ||||||
20 | TBH 4 | Mid Market | 1/1/2024 | 0.00 | 0.17 | 0.33 | 0.50 | 0.67 | 0.83 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | ||||||
21 | TBH 5 | SMB | 11/1/2023 | 0.00 | 0.33 | 0.67 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | ||||
22 | TBH 6 | SMB | 1/1/2024 | 0.00 | 0.33 | 0.67 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | ||||||
23 | TBH 7 | SMB | 3/1/2024 | 0.00 | 0.33 | 0.67 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | ||||||||
24 | TBH 8 | SMB | 6/1/2024 | 0.00 | 0.33 | 0.67 | 1.00 | 1.00 | 1.00 | 1.00 | |||||||||||
25 | TOTAL | 7.67 | 8.00 | 9.25 | 9.44 | 9.61 | 9.94 | 11.16 | 12.01 | 13.04 | 13.71 | 14.38 | 14.71 | 14.71 | 14.71 | 14.71 | 14.84 | 14.84 | |||
26 | |||||||||||||||||||||
27 | In-Seat HC | Mid Market | 4.00 | 4.00 | 3.29 | 3.29 | 3.46 | 3.79 | 4.10 | 4.57 | 5.05 | 5.72 | 6.22 | 6.55 | 6.55 | 6.55 | 6.55 | 6.55 | 6.55 | ||
28 | In-Seat HC | SMB | 3.67 | 4.00 | 3.46 | 3.27 | 3.60 | 3.94 | 4.41 | 4.75 | 5.24 | 5.58 | 5.74 | 6.07 | 6.41 | 6.74 | 6.74 | 6.61 | 6.61 | ||
29 | PLAN HC | Mid Market | TARGET HEADCOUNT (Simple Bookings Plan tab) | 4.62 | 4.62 | 4.62 | 5.77 | 5.77 | 5.77 | 5.77 | 5.77 | 5.77 | 6.92 | 6.92 | 6.92 | ||||||
30 | PLAN HC | SMB | TARGET HEADCOUNT (Simple Bookings Plan tab) | 4.44 | 4.44 | 4.44 | 5.56 | 5.56 | 5.56 | 5.56 | 5.56 | 5.56 | 6.67 | 6.67 | 6.67 | ||||||
31 | Better / (Worse) | Mid Market | -0.83 | -0.52 | -0.04 | -0.72 | -0.05 | 0.45 | 0.78 | 0.78 | 0.78 | -0.37 | -0.37 | -0.37 | |||||||
32 | Better / (Worse) | SMB | -0.51 | -0.03 | 0.30 | -0.31 | 0.02 | 0.18 | 0.52 | 0.85 | 1.18 | 0.07 | -0.06 | -0.06 | |||||||
33 | |||||||||||||||||||||
34 | |||||||||||||||||||||
35 | Predicted Churn | Assumed Retention (via LinkedIn article) | |||||||||||||||||||
36 | Month | 0 | 12 | 24 | 36 | 48 | 60 | ||||||||||||||
37 | Mid Market | FTE | 95.00% | 78.00% | 59.00% | 46.00% | 38.00% | 32.00% | |||||||||||||
38 | SMB | FTE | 95.00% | 78.00% | 59.00% | 46.00% | 38.00% | 32.00% | |||||||||||||
39 | Tenure (in months) | ||||||||||||||||||||
40 | Employee | Role | Territory | Start Date | 8/1/2023 | 9/1/2023 | 10/1/2023 | 11/1/2023 | 12/1/2023 | 1/1/2024 | 2/1/2024 | 3/1/2024 | 4/1/2024 | 5/1/2024 | 6/1/2024 | 7/1/2024 | 8/1/2024 | 9/1/2024 | 10/1/2024 | 11/1/2024 | 12/1/2024 |
41 | Rep 1 | Mid Market | T0001 | 2/1/2022 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 |
42 | Rep 2 | Mid Market | T0002 | 2/15/2022 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 |
43 | Rep 3 | Mid Market | T0003 | 3/24/2022 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 |
44 | Rep 4 | Mid Market | T0004 | 1/26/2023 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |
45 | Rep 5 | SMB | T0005 | 5/27/2023 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |
46 | Rep 6 | SMB | T0006 | 3/23/2023 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
47 | Rep 7 | SMB | T0007 | 1/28/2022 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 |
48 | Rep 8 | SMB | T0008 | 10/17/2021 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 |
49 | TBH 1 | SMB | T0009 | 1/1/2024 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |||||
50 | TBH 2 | SMB | T0010 | 1/1/2024 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |||||
51 | TBH 3 | SMB | T0011 | 1/1/2024 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |||||
52 | TBH 4 | SMB | T0013 | 1/1/2024 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |||||
53 | |||||||||||||||||||||
54 | Churn Probability | ||||||||||||||||||||
55 | Employee | Role | Territory | Start Date | 8/1/2023 | 9/1/2023 | 10/1/2023 | 11/1/2023 | 12/1/2023 | 1/1/2024 | 2/1/2024 | 3/1/2024 | 4/1/2024 | 5/1/2024 | 6/1/2024 | 7/1/2024 | 8/1/2024 | 9/1/2024 | 10/1/2024 | 11/1/2024 | 12/1/2024 |
56 | Rep 1 | Mid Market | T0001 | 2/1/2022 | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% |
57 | Rep 2 | Mid Market | T0002 | 2/15/2022 | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% |
58 | Rep 3 | Mid Market | T0003 | 3/24/2022 | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% |
59 | Rep 4 | Mid Market | T0004 | 1/26/2023 | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% |
60 | Rep 5 | SMB | T0005 | 5/27/2023 | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% |
61 | Rep 6 | SMB | T0006 | 3/23/2023 | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% |
62 | Rep 7 | SMB | T0007 | 1/28/2022 | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 22.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% |
63 | Rep 8 | SMB | T0008 | 10/17/2021 | 22.00% | 22.00% | 22.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 41.00% | 54.00% | 54.00% |
64 | TOTAL | Mid Market | 0.71 | 0.71 | 0.71 | 0.71 | 0.71 | 0.71 | 1.07 | 1.26 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | ||
65 | TOTAL | SMB | 0.54 | 0.54 | 0.54 | 0.73 | 0.73 | 0.73 | 0.92 | 0.92 | 1.09 | 1.09 | 1.26 | 1.26 | 1.26 | 1.26 | 1.26 | 1.39 | 1.39 | ||
66 |