| Type Council Here |
Hertfordshire County Council |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Double-click to input date
Insert Date of Completion Here |
CURRENT RESOURCE - CHILDREN'S |
|
|
|
|
| For instructions on how to use this workbook, please refer to the black tab entitled "Instructions". |
Workforce Groupings |
|
|
|
|
| Hover your mouse over the red triangles shown on some cells to view additional guidance. |
Newly Qualified Social Worker
Newly Qualified Social Worker |
R = RATING
For each category, input a number from 1-5 to indicate how much of a concern this data is to you.
(1 = NO CONCERN, 5 = HIGH CONCERN)
Rating |
Qualified SW (inc. Senior Practitioner, Consultant Social Worker) with less than 2 years service
Experienced Qualified Social Worker (<2 years experience) |
R = RATING
For each category, input a number from 1-5 to indicate how much of a concern this data is to you.
(1 = NO CONCERN, 5 = HIGH CONCERN)
Rating |
Qualified SW (inc. Senior Practitioner, Consultant Social Worker) with MORE than 2 years service
Experienced Qualified Social Worker (>2 years experience) |
R = RATING
For each category, input a number from 1-5 to indicate how much of a concern this data is to you.
(1 = NO CONCERN, 5 = HIGH CONCERN)
Rating |
Assistant Team Manager / Team Manager
Assistant Team Manager / Team Manager |
R = RATING
For each category, input a number from 1-5 to indicate how much of a concern this data is to you.
(1 = NO CONCERN, 5 = HIGH CONCERN)
Rating |
Service Manager / Group Manager
Service Manager / Group Manager |
R = RATING
For each category, input a number from 1-5 to indicate how much of a concern this data is to you.
(1 = NO CONCERN, 5 = HIGH CONCERN)
Rating |
|
Total |
R = RATING
For each category, input a number from 1-5 to indicate how much of a concern this data is to you.
(1 = NO CONCERN, 5 = HIGH CONCERN)
Rating |
|
|
This should be equal to your Establishment
Total FTE + Vacancies |
If known, record the numbers per Workforce Grouping for each of the given categories, at the time of recording.
These numbers do not need to be 100% accurate - the most important aspect is what Rating you assign to them (in the red columns).
The blue % columns do not require your input - these will autofill based on the numbers you input to the "No" columns.
Guidance |
|
|
|
2 |
|
|
|
|
|
|
|
0 |
2 |
|
| Current Headcount |
21 |
|
97 |
5 |
223 |
|
74 |
|
21 |
|
|
436 |
5 |
|
| Current FTE |
21.0 |
|
94.3 |
3 |
206.1 |
|
72.0 |
|
21.0 |
|
|
414.4 |
3 |
|
|
Number
No |
If you only know the percentage, you can manually input this, however it is preferable to input a number to the number column and allow the workbook to autofill the percentage.
% |
|
No |
% |
|
No |
% |
|
No |
% |
|
No |
% |
|
|
|
|
|
|
Record the physical number of part-time workers you currently have employed per Workforce Grouping.
Part Time (headcount) |
0 |
0 |
|
|
0 |
2 |
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
2 |
|
| Current Vacancies (fte) |
-21 |
#DIV/0! |
|
-94.3 |
#DIV/0! |
5 |
-206.1 |
#DIV/0! |
|
-72 |
#DIV/0! |
|
-21 |
#DIV/0! |
|
|
-414.4 |
5 |
|
|
How many roles in each Workforce Grouping are currently being covered by agency staff?
Vacancies Covered by Agency SWs |
|
#DIV/0! |
|
|
#DIV/0! |
3 |
|
#DIV/0! |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
3 |
|
| Bottom of salary range |
All H8 SCP30 |
|
|
1x H7 SCP 29 |
|
|
7x H8 SCP 31 |
|
|
1x M3 SCP 47 |
|
|
1x M4 SCP 53 |
|
|
|
|
|
|
| Top of salary range |
All H8 SCP30 |
|
|
1x M2 SCP 46 |
|
|
8x M2 SCP 46 |
|
|
31x M4 SCP 52 |
|
|
13x M5 SCP 55 |
|
|
|
|
|
|
| Max. annual market forces amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Average Hourly Agency Pay Rate |
|
|
|
3 |
|
|
|
|
|
|
|
|
3 |
|
|
How long, on average, have your permanent staff been employed (in years)
Please note this does not refer to their tenure within the organisation as a whole - just tenure in their current post.
Average Tenure (Permanent) |
0.3 |
|
1.5 |
4 |
9.0 |
|
9.0 |
|
14.3 |
|
|
6.275 |
4 |
|
|
How long, on average, have your permanent staff been in post (in weeks)
Please note this does not refer to their tenure within the organisation as a whole - just tenure in their current post.
Average Tenure (Agency) |
|
|
|
4 |
|
|
|
|
|
|
|
#DIV/0! |
4 |
|
|
This includes voluntary and compulsory turnover.
If you are unable to break turnover down by Workforce Grouping, please feel free to input the same figure (%) for each category.
Total Turnover (%) |
28.6% |
|
3.1% |
4 |
26.5% |
|
14.9% |
|
9.5% |
|
|
17% |
4 |
|
|
For each Workforce Grouping please indicate what percentage are from black or minority ethnic backgrounds.
BME (%) |
61.9% |
|
37.1% |
1 |
17.9% |
|
16.2% |
|
28.6% |
|
|
32% |
1 |
|
|
No |
% |
|
No |
% |
|
No |
% |
|
No |
% |
|
No |
% |
|
|
|
|
|
| Male |
3 |
14 |
|
6 |
6 |
4 |
21 |
9 |
|
5 |
7 |
|
3 |
14 |
|
|
38 |
4 |
|
| Female |
18 |
86 |
|
91 |
94 |
4 |
202 |
91 |
|
69 |
93 |
|
18 |
86 |
|
|
398 |
4 |
|
| <25 |
Age |
4 |
19 |
|
14 |
14 |
3 |
5 |
2 |
|
0 |
0 |
|
0 |
0 |
|
|
23 |
3 |
|
| 26-35 |
16 |
76 |
|
42 |
43 |
2 |
70 |
31 |
|
7 |
9 |
|
1 |
5 |
|
|
136 |
2 |
|
| 36-45 |
1 |
5 |
|
21 |
22 |
2 |
61 |
27 |
|
20 |
27 |
|
4 |
19 |
|
|
107 |
2 |
|
| 46-55 |
0 |
0 |
|
15 |
15 |
2 |
54 |
24 |
|
35 |
47 |
|
9 |
43 |
|
|
113 |
2 |
|
| >55 |
0 |
0 |
|
5 |
5 |
2 |
33 |
15 |
|
12 |
16 |
|
7 |
33 |
|
|
57 |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
