We are currently developing a workforce supply tool (in excel data sheet format) which will support step four of the Six Step Guide to Workforce Planning. The tool is being designed to enable users to estimate the number and types of staff available now and in the future to support the development of a workforce and/or improvement plan.
The excel data sheets will:
uses data from ESR and/or IPS
Uses data from ESR and/or IPS
Provide details of age profiles
Provide participation and retirement rates for staff for the next 5 years
Provide turnover rates (based on the data definitions calculation)
Provide the functionality to enter new staffing supply
Provide a calculation of the supply implications of workforce modernisation and organisational development
Provide a direct feed into the service reconfiguration template (Christmas tree tool) to provide a visual representation of the workforce numbers at each level of the NHS career framework now and in the future.
Provide an accurate starting point for workforce improvement plans/workforce plans
Provide costings for staff based on agenda for change pay bands
Undertake mini forecasting
Detail any long term vacancy pressures.
Feedback
At this stage of the development process we would like to seek feedback from potential users of the workforce supply tool. Please have a think about these questions and drop us a line using the form below:
Does the tool outlined above sound like it would be useful to you?
Would you use this tool?
Would you make any additions or changes to the tool, to make it more useful to you?
