guides

from population projections to workforce demand

Long-term workforce plans need long-term demand. This guide sets out how to get from the published population projections to the staff each service will need, one step at a time.

1. start with the population you serve

The Office for National Statistics publishes subnational population projections for each local authority by single year of age. Choose the local authorities your services cover and, for each one, the share of its population you serve. Group the ages into bands that match how use of services changes with age, for example 0 to 17, 18 to 64, 65 to 74, 75 to 84, and 85 and over.

If your catchment is changing, for example because a neighbouring service is closing, add a boundary change so the population served grows or shrinks from a date.

2. turn people into activity

For each service, set its use per 1,000 people in each age band, from your own activity data. Multiplying the population served by these rates gives the activity each year that comes from the population alone, and shows how ageing alone changes demand.

3. adjust for deprivation and long-term conditions

Two adjustments make the forecast fairer and more accurate.

  • Deprivation. People in more deprived areas tend to use some services more, and earlier in life. Split the population by deprivation quintile and apply a factor to each.
  • Long-term conditions. As more people live with conditions such as diabetes or heart failure, use of related services rises. Add the expected change in the number of people with each condition, and the extra use per 1,000 people that each brings.

4. shape it through the year

Activity is not even across the year. Apply a winter factor to the months that need it, and a change in demand from policy, such as care closer to home or virtual wards, from the date it takes effect.

5. from activity to staff

Turn activity into staff needed with a ratio for each service and staff group, for example WTE per 1,000 attendances, or from beds, care hours, or rotas. Add headroom for leave, sickness, and training as extra staff needed. Then compare the staff needed with the staff in post, year by year: the gap is what the workforce plan has to close.

doing it in Workforce Planner

Workforce Planner does each of these steps in its demand forecast layer, with the ONS projections already loaded in its data libraries. Link the demand forecast to a workforce forecast, and staff needed in each service follows its activity, set against funded WTE and staff in post, month by month. Options can then be tested against the gap to need. It works in the free demo, for up to 50 posts.

see your own structure, then plan it

Any organisation can try Workforce Planner free in the demo, with up to 50 posts: enough to load a ward or a small team, see its structure, forecast it, and test options. Send us a request and we will be in touch to set up your organisation.

request demo access book a 20-minute walkthrough see pricing and discounts