This page provides Excel and Google Sheets templates to help you think through the critical aspects of your workforce planning.
March 16, 2022 2 min read
This page provides Excel and Google Sheets templates to help you think through the critical aspects of your workforce planning. These include:
If you’re looking for human resource management templates to develop your current workforce, how to interview well, how to measure competencies, succession planning and knowledge transfer, or do a workforce skills gap analysis, you’re not alone. But the experts in those areas can help. Here are a few resources to start with:
We created the workforce planning templates below to help you build better forecasts of your biggest cost: your people. Whether you are building a headcount planning model from scratch, or just looking for best practices ideas to add to your existing forecasting approach, we think you’ll find value in these templates.
We’ve also created a comprehensive Workforce Planning Model template that combines these templates and more to give you a single model to work from to build a plan that meets your strategic goals. You can download the entire workforce planning toolkit here.
And we’ve developed a number of examples that you can use to develop an action plan for retention, future workforce growth, location strategy, and more, alongside how-to videos and more, all available on our Knowledge Hub.
Good workforce planning requires data, of course. Make sure you’re working with the best data you can find, because as the old saying goes, “garbage in, garbage out.”
You’ll need:
Our roles & salaries template you define the roles of future hires you want to forecast in your organization. By defining job levels, salaries, and other parameters here, you can quickly adjust future hiring assumptions based on your demographic research and future demand expectations, without having to manage this data hire by hire. The sheet includes 25 placeholders and defines payment type, daily hours, and details about pay increase and bonus timing and amounts.
Many companies don’t bother forecasting taxes and benefits. But as we showed on our blog on the financial impacts of a business plan to move to a remote workforce, a more accurate forecast can make a material difference in many situations. Variations in tax rates aren’t news, but state unemployment taxes don’t follow the patterns you’d expect. On the benefits side, your business strategy for meeting workforce challenges should consider what benefits you offer, at what level, to which employees, and project that forward over time. Armed with a the right data on tax rates — provided here — and a few assumptions around benefits, you can make benefits a strategic weapon in your workforce retention arsenal.
Fringe benefits form a key part of workforce strategy and retention, given the workforce challenges of the current economic climate. Many organizations offer role-specific benefits, for example, extra stipends for engineers to purchase more powerful computers, or a car allowance for field sales and service reps. These benefits can also vary by job level. This template can help you structure such benefits into your planning model.
In our full Workforce Planning Model template, you can forecast future hires individually or in batches. This template shows how to forecast batch hiring, which is useful for organizations with predictable vacancies that regularly hire a group of people in the same role on a periodic basis, like seasonal retail workers or an annual class of junior consultants, lawyers, or accountants.
The best workforce planning process needs to provide visualizations and trends of your existing workforce and future demand to challenge your thinking, facilitate discussions and decisions about trade-offs across your executive stakeholders.
This template provides three different dashboards:
For any model you build to be quickly updated, you need a repeatable way to get the latest data on your current from your HR system into it. If you’re using FP&A software like OnPlan, you can do this with a direct integration, but if you’re working in spreadsheets, it’s good to have a standard import template that can feed the rest of your model. We’ve created a template you can use if you’re using ADP.
Having a unified model that incorporates workforce data from current staff and your stakeholders’ demand analysis of future workforce needs can ensure each department gets what it needs while staying within the budget constraints of the business. Even better is connecting a workforce model to the rest of your revenue and operating model, so your operational needs and assumptions are tied to the hiring plan. OnPlan helps our customers do just that. Doing this in spreadsheets alone is tough — you can’t share a single model with the whole company because it’s full of sensitive compensation data. Splitting up the model and re-entering data from stakeholders with every change adds a big administrative overhead to your team.
As you begin thinking about workforce planning, the best place to start is where you are now. Gather data about your current workforce. If you have an HR system, use the relevant import template above. Of course, you’ll want to capture critical information like the number of employees, salaries, and job levels/roles.
Next, work with your stakeholders across the organization to understand their business needs. What expectations do they have for hiring, and for career development of their current employees (and the compensation implications of that growth)?
Your HR stakeholder should simultaneously be doing a supply analysis to make sure your company has a plan to supply a recruiting pipeline to fill the needs. Given the tight labor market, you may have to be creative by looking to part-time workers, freelancers, or remote staff.
Finally, bring your current staff and future hiring plans together into a holistic forecast that can form the basis of discussion, strategic choices, horse-trading between departments and business plans.
Our individual templates above can help you with all these steps, but the holistic template that brings them all together and calculates totals will be the most help if you’re running an end-to-end process.
Addressing challenges like these is why we built OnPlan. Book a demo to see how OnPlan makes workforce planning — and other financial planning tasks — faster and more flexible.
If you’re trying to plan for growth, your workforce should be top of mind. Human capital is the top expense for most companies, and if you don’t treat your employees right, that expensive investment can walk right out the door.
This page provides Excel and Google Sheets templates to help you think through the critical aspects of your workforce planning. These include:
If you’re looking for human resource management templates to develop your current workforce, how to interview well, how to measure competencies, succession planning and knowledge transfer, or do a workforce skills gap analysis, you’re not alone. But the experts in those areas can help. Here are a few resources to start with:
But If you’re looking for resources for planning for all your workforce-related costs, you’re in the right place!
Strategic workforce planning is the practice of setting up organizational processes to anticipate your company’s future workforce needs. By taking inputs from across the business including finance, HR, sales, marketing, and other departments, companies that practice workforce planning can plan for the workforce size, composition, and budget that matches their strategic goals and ensures future success.
A staffing plan (typically created by the HR department) identifies future staffing requirements for the organization based on both current personnel and forward-looking strategy. An effective staffing plan should help leadership and hiring managers clearly understand the profiles of employees needed to meet company goals.
Business strategy affects workforce plans, and workforce plans affect business strategy. When company leaders decide to move forward with a strategic project, they naturally need to consider how it will affect various business functions. Since most major new initiatives require new or different skills, these initiatives inevitably end up influencing workforce plans. Those plans should then outline how to meet the new requirements, and the operational timeline required. Leaders then need to keep that timeline in mind as they lay out how and how fast to put their new initiatives into motion.
According to Gartner, the three stages of workforce planning are:
The US Government’s Office of Personnel Management (basically, the government’s HR department) lays out a five-step workforce planning process
Completing a staffing plan comprises six main steps:
The above outline is designed to complete a staffing plan for a specific function. Staffing plans can also be created for entire divisions or organizations. To complete staffing plans with a bigger scope, organizations can break down the plan into manageable pieces. For example, a division might complete individual staffing plans for the sales, finance, HR, IT, marketing, and production functions, and then combine them into one overall plan. HR professionals responsible for this type of planning must closely collaborate with the leaders of each individual group to understand goals, needs, and expertise required. Conducting such an exercise can help leaders better understand how each function interlocks to support overall organizational goals.
Strategic workforce planning prepares companies to respond to continuous and inevitable changes in the workplace. It also ensures business agility in times of crisis, such as the Covid-19 pandemic, which has already altered the way people around the world live and work.
For example, many organizations started encouraging remote work to ensure the safety and wellbeing of employees during the crisis. To what degree will they support remote work going forward? To what degree will their employees favor or disfavor them as an employer as a result?
Companies must adapt their business strategies to the remote work model to enable employees to work productively, and to meet their goals.
Operational workforce planning enables the organization to achieve short term outcomes. This level of workforce planning involves keeping track of day-to-day operations, assigning people to prepare for immediate operational or resource needs, and addressing ad-hoc changes are all part of this form of workforce planning. Operational workforce planning is largely driven by HR and individual team managers, and produces documentation including procedures, processes and rosters. Preparation for the recruitment life cycle and seasonal workforce changes are other typical examples.
Learn how OnPlan gives your model superpowers.
Book a demo