Do you have a burning HR question that needs answering?
Our expert HR advice
is just a click away
This spreadsheet enables an organisation to analyse its workforce to identify data to be used in workforce planning. It may identify trends and indicate areas for action & priority. For example, the age profile may indicate:
Another example is the profile analysis in terms of gender and ethnic diversity, which may indicate the organisation is not taking full advantage of the available workforce, such as increasing the pool of apprentices or by actively seeking female candidates and/or recent arrivals to Australia.
Well-being indicators are also important as they can reveal a need for flexible work (i.e. a large amount of Carer's leave) or WHS and well-being issues for a category of employees such as mature age or employees from a non-English speaking background.
It is recommended that this spreadsheet is completed prior to involving stakeholders in workforce planning and is used to provide objective data to inform discussions and analysis of the organisations needs. Organisations can omit columns that they do not have data on or add columns in relation to key workforce skills or experience key to achievements of the organisations strategic objectives.
You must be logged in to download these resources
Log in now
Ai Group members get unlimited access to our HR Resource Centre. This includes comprehensive HR articles, templates and resources, and our popular Q&A section.
Already a member? Log in to access this content.
Not a member? Take a look at what Ai Group can offer your business.