< All Posts

How to Build a Workforce Planning Model from Scratch

How to Build a Workforce Planning Model from Scratch
Three connected circles forming a molecular structure icon on a dark blue background, with two blue circles and one grey circle linked by grey and white lines.
Written by:
Trace Insights
Publish Date:
Mar 2026
Topic Tag:
Workforce Planning & Scheduling

Ready to turn insight into action?

We help organisations transform ideas into measurable results with strategies that work in the real world. Let’s talk about how we can solve your most complex supply chain challenges.

Trace Logo

Most organisations know they need a workforce plan. Far fewer have one that actually works.

What passes for workforce planning in many Australian businesses is a combination of last year's headcount, a few assumptions about growth, and a spreadsheet that someone in HR updates annually and nobody uses to make decisions. It describes the workforce you have. It doesn't tell you what you need, when you'll need it, or what it will cost to bridge the gap.

A real workforce planning model is different. It connects demand — the work that needs to be done — to supply — the people available to do it — and surfaces the gaps between them clearly enough that management can act. Built well, it becomes one of the most commercially useful tools in an organisation. Built poorly, it becomes another document that sits in a shared drive.

This guide explains how to build a workforce planning model that actually earns a place in your planning cycle.

What a Workforce Planning Model Is — and Isn't

Before building anything, it's worth being precise about what you're trying to produce.

A workforce planning model is an analytical tool that projects workforce demand and workforce supply over a defined horizon — typically one to three years — and identifies the capacity, capability, and cost gaps between them. It should answer three core questions:

  • How many people, in what roles, with what skills, do we need to deliver our operational plan?
  • How many people, in what roles, with what skills, do we have — and how will that change through natural attrition, retirement, and current hiring?
  • What is the gap, and what are our options for closing it?

What it is not: a headcount budget, an organisation chart, a HR strategy document, or a rostering system. These are related tools — and a good workforce plan connects to all of them — but they're not the model itself.

The model lives between strategy and operations. Its inputs come from both. Its outputs should drive both.

Step 1: Agree the Planning Horizon and Granularity

The first decision in building a workforce planning model is scope: what time horizon are you planning for, and at what level of granularity?

Horizon. Strategic workforce planning typically operates over a one to five year horizon. Operational workforce planning — connecting demand to rosters and shifts — operates over weeks to months. Most organisations need both, but they're different tools. For a strategic model, a three-year horizon with annual milestones is a practical starting point for most Australian organisations. In fast-changing environments (health, technology, defence), a five-year horizon with quarterly reviews is more appropriate.

Granularity. You can model workforce at the level of the organisation, business unit, function, role family, or individual role. The right level depends on your purpose. If you're planning for an enterprise-wide transformation, role family level is usually sufficient. If you're planning for a specific operational area — a hospital ward, a distribution centre, a contact centre — role-level granularity is necessary.

Starting too granular creates a model so complex that it can't be maintained. Starting too coarse creates a model so aggregated that it can't be acted on. Most organisations benefit from a tiered approach: enterprise-level for strategic decisions, function-level for workforce investment decisions, role-level for operational planning.

Step 2: Build the Demand Side

Demand modelling is the part most workforce plans get wrong. They start with last year's headcount and adjust for growth. That's supply modelling — it tells you how your existing workforce might change. Demand modelling starts somewhere different: with the work.

The question is: what does your operational plan require in terms of human effort, by role, over the planning horizon?

There are three primary approaches to demand modelling, and the right choice depends on your industry and data availability.

Driver-based modelling. Connect workforce demand to the operational drivers that cause it. In a hospital, demand drivers include bed occupancy, patient acuity, procedure volumes, and outpatient attendances. In a distribution centre, they're order volume, SKU complexity, and despatch frequency. In a contact centre, they're call volume, average handle time, and service level targets. Build a model that translates operational drivers into FTE requirements by role — and you have a demand forecast that updates automatically when the operating plan changes.

Ratio-based modelling. Use established ratios of workforce to output as a starting point — staff-to-patient ratios in health, covers-per-staff in hospitality, cases-per-picker in logistics. These are faster to build than driver-based models but less sensitive to operational change. They're a useful starting point or a cross-check, not a substitute for driver-based modelling in complex environments.

Activity-based modelling. Map the activities that each role performs, estimate the time each activity takes, and multiply by projected activity volumes to get FTE demand. This is the most granular approach and the most powerful for identifying where work is being done inefficiently — but it requires significant data collection and is harder to maintain.

For most Australian organisations building a workforce plan for the first time, a driver-based model at role family level, cross-checked against ratios, is the right starting point. It's buildable in a reasonable timeframe, updatable without heroic effort, and directly connected to the operational plan.

Step 3: Build the Supply Side

Supply modelling answers the question: what workforce do you have now, and how will it change over time if you make no deliberate interventions?

The supply model starts with a current state snapshot — headcount by role, employment type (full-time, part-time, casual), age, tenure, location, and any skills or qualification data you hold. Then it projects that workforce forward using three variables:

Attrition. How many people will leave in each period, by role? Attrition has voluntary and involuntary components. Voluntary attrition (resignation, retirement) can be estimated from historical data, segmented by age band, role, and tenure. In health and aged care, where workforce shortages are acute and turnover is structurally high, voluntary attrition rates of 20–30% in some care worker cohorts are not unusual. In professional services, rates in the 10–15% range are more common. Involuntary attrition (performance exits, redundancy) is usually smaller and more manageable.

Internal mobility. How will people move within the organisation — through promotion, lateral transfer, reskilling, or deployment? An organisation with active talent development programmes will have higher internal mobility than one that fills roles primarily externally. Internal mobility reduces recruitment cost and supports retention, but it needs to be modelled explicitly to understand its effect on supply in different role pools.

Current pipeline. What recruiting, training, and development activity is already in progress, and what headcount will it deliver, when? Graduates and trainees already enrolled, internal development programmes underway, and approved recruitment in progress should all be factored into the base supply projection.

The output of the supply model is a projected workforce profile — by role, over the planning horizon — assuming no new interventions.

Step 4: Identify and Quantify the Gaps

With demand and supply modelled, the gap analysis is straightforward in principle: subtract supply from demand, by role, by period.

In practice, the gap analysis has four dimensions that need to be considered separately:

Capacity gaps. Do you have enough people? A simple numerical difference between demand and supply. A positive gap means you're short; a negative gap means you're over-resourced.

Capability gaps. Do you have people with the right skills? A capacity analysis that shows sufficient headcount can still mask a serious capability problem if the skills required have changed — through technology adoption, regulatory change, or service model evolution — and your existing workforce hasn't kept pace.

Location gaps. Are your people in the right places? In organisations with geographically distributed operations — health networks, retail chains, government agencies — the aggregate workforce picture can look balanced while specific locations or regions face critical shortfalls.

Cost gaps. Can you afford the workforce you need? A workforce plan that identifies the right headcount and skills profile but is unaffordable is not a plan — it's a wish list. The cost model needs to run in parallel with the demand and supply model, translating FTE requirements into salary and on-cost projections that can be tested against the budget.

The gap analysis should be presented as a forward-looking picture across all four dimensions, with the gaps ranked by severity and time horizon.

Step 5: Develop and Evaluate Strategies

Gap identification is analysis. Workforce planning becomes useful when it generates strategies for closing gaps — and when those strategies are evaluated against each other.

For each material gap, there are typically four types of response:

Recruit. Hire people from the external labour market. Fast but expensive, and in tight labour markets (health, engineering, digital, logistics) constrained by supply. Recruitment strategy needs to account for lead times — in specialised roles, six to twelve months from decision to productive contribution is not unusual.

Develop. Build capability internally through training, reskilling, or upskilling. Slower than recruitment and requires investment, but builds organisational capability, supports retention, and is often less expensive than external hiring for roles where internal candidates are close to ready.

Redeploy. Move people from areas of surplus to areas of shortage. Effective where the roles are adjacent and the capability gap is manageable — less effective where the skills differential is large or the geographic movement is significant.

Restructure. Change the way work is done to reduce the workforce requirement or change its composition. Automation, process redesign, outsourcing, or changes to the operating model can all reduce or reshape demand. This is often the highest-leverage response but the slowest to implement.

Most workforce plans require a combination of all four, sequenced over the planning horizon. The model should allow you to test the sensitivity of different strategy mixes — what happens to cost and risk if you lean more heavily on recruitment vs. development? — and to track progress against the chosen strategy over time.

Step 6: Connect the Model to the Business Planning Cycle

A workforce plan that isn't connected to the budget process, the strategic plan, and operational decision-making will be ignored.

The model needs to be designed for ongoing use, not just for the project that created it. That means: data inputs that can be updated from source systems (HR, payroll, operational planning) without manual re-entry; a governance process that defines who updates the model, how often, and who reviews the outputs; and decision triggers that define when the model should be used — for new investment decisions, organisational changes, budget submissions.

In health and aged care, the model also needs to connect to compliance monitoring — tracking care minute delivery against mandated minimums, for example, requires the same underlying data as workforce planning and should be sourced from the same system.

The most common failure mode in workforce planning programmes is building a model that's accurate at the point of creation and obsolete within six months because nobody owns the update cycle. Design for maintenance from the start.

Common Mistakes

Starting with supply instead of demand. A workforce plan built from current headcount with adjustments for growth is a staffing budget. It misses the capability dimension entirely and doesn't challenge whether the current operating model is fit for purpose.

Over-engineering the model. A highly complex model with hundreds of variables is difficult to maintain and difficult to explain to the executives who need to act on it. Build for the decisions you need to make, not for theoretical completeness.

Ignoring external labour market context. A workforce gap analysis that doesn't account for the availability of the skills you need in the external market is incomplete. In tight labour markets — and Australia currently faces tight markets across health, engineering, and technology — a gap that looks closeable through recruitment may not be.

One-size-fits-all modelling. Different parts of the organisation have different workforce dynamics. Applying a uniform planning methodology across all functions misses the variation that drives meaningful insight.

How Trace Consultants Can Help

Building a workforce planning model that earns a place in your planning cycle requires both analytical rigour and deep knowledge of your sector's workforce dynamics.

Trace Consultants works with Australian organisations across health, aged care, government, retail, logistics, and infrastructure to design and implement workforce planning models that are operationally grounded, financially connected, and built to last.

Model design. We design workforce planning frameworks appropriate to your organisation's scale, sector, and data environment — driver-based, ratio-based, or activity-based as the situation warrants.

Data and analytics. We extract and structure workforce data from HR and payroll systems, develop demand projections from operational plans, and build the gap analysis and scenario modelling tools your leadership team needs.

Strategy development. We work with your leadership and HR teams to develop and sequence the strategies that close your workforce gaps — balancing recruitment, development, redeployment, and restructuring options against cost and risk.

Implementation support. We embed workforce planning as an ongoing management practice — not a one-off project — with governance structures, update cycles, and reporting that sustain the model over time.

Explore our Workforce Planning services →Speak to an expert at Trace →

Ready to turn insight into action?

We help organisations transform ideas into measurable results with strategies that work in the real world. Let’s talk about how we can solve your most complex supply chain challenges.

Trace Logo