Demystifying HR Forecasting
The key inputs you will need to start filling in your individual-level forecast include existing employees, new planned roles with timing, and related salary information.
for HR professionals
To help you navigate the headcount planning process, we created a tangible, easy to follow headcount forecasting template, with a recorded class session available to walk you through the forecasting process. Taught by our founder, Katie Fifer, the class recording covers a comprehensive review of key considerations, inputs and outputs when forecasting headcount, along with an overview of how to structure a headcount forecast. With an increased comfort around the numbers, you should come away feeling more prepared and excited for your next planning discussion.
Recalc Demystifying HR Forecasting (YouTube)
Setting the stage: What does a successful headcount forecasting model look like?
Before we compare these approaches, we first need to consider what a successful headcount forecasting model looks like to ensure the model is actionable and useful to the organization.
| Characteristics of a successful model | Implications for model construction |
|---|---|
| Actively used throughout the year to manage headcount. Not just completed as part of the annual planning process and never opened again. | Drills down to the team and individual level |
| Makes sense in the context of historical information | Includes historical headcount information and a clear waterfall bridge to go from beginning to end of the year |
| Translates headcount into cost | Includes salary information + fringe cost estimates |
| Makes sense in the context of the revenue and business plan | Includes relevant metrics and KPIs |
| Clear and easy to follow | Easy to update, flexible model with clear inputs and summaries |
Forecasting Approaches
The class covers two forecasting approaches -- the first forecasts headcount at the individual role level, while the second forecasts at the team level.
The class provides step-by-step guidance to help you understand and operationalize each approach:
Approach 1: Forecasting at the Individual Level
Introducing the model -- The first approach forecasts at the individual role level, and is most relevant for smaller organizations, or a division within a larger organization.
Understanding and building the model
-
Filling out the key inputs -- The key inputs you will need to start filling in your individual-level forecast include existing employees, new planned roles with timing, and related salary information.
-
Breaking down the monthly forecast -- The salary information for each individual flows into monthly salary calculations using IF statements. It's basically saying if they're an existing team member, or if they're new and the date in question where they're starting is less than or equal to the date above (meaning they have started), then they'll flow in. This is a simplified model where people start essentially on the first of the month.
-
Summarizing salary & headcount by team by month -- The next step in the model is to roll up the salaries and headcount information by month by team using common summary formulas SUMIFS and COUNTIFS.
Summarizing the data and putting it in context
-
Getting ready for cross-functional discussions -- We recommend creating the summary forecast on a separate tab from the inputs to be able to clearly see and understand the outputs. We mainly leverage the XLOOKUP formula to carry data across the two tabs. Key tips: you can reorder teams in any order you want since the model looks up based on the team. Show numbers in thousands (never show numbers with two commas). Add run rate metrics to annualize current state. Include quarterly summaries alongside monthly data.
-
Ratios & metrics -- The final step is to put the forecast into context -- what does it mean related to revenue, cost, and industry benchmarks.
Approach 2: Forecasting at the Team Level
Introducing the model -- The second approach focuses on a headcount forecast at the team level.
Understanding and building the model
-
Inputting headcount changes -- Key inputs for this team-level forecast include historical headcount information and planned attrition and new hires by team.
-
Adding in the cost (salary) forecast -- The next step is to translate the headcount changes into cost using historical and planned salaries at the team level.
Summarizing the data and putting it in context
- Summarizing the data -- The final step is to summarize the team level forecast on a separate tab to see planned changes by quarter and total changes over the year.