Once you have obtained an estimate for the number of staff you need, you can make an estimate of the staff costs. The staffing calculator will have given you an indication of the number of staff needed, but now you will have to decide the skill mix of those staff, i.e. you should consider how many staff of each grade/band are required. Once decided, you should enter the number of WTEs for each band/grade in the relevant cells in column H (again you will only be able to enter data in the cells with a white background). You will then be given the salary costs for this staff type (this does not include on-costs). Three costs are presented, based on different scale points: bottom of scale, mid-band, top of scale.
If you want to see the costs for staff, including the on-costs, then go to the spreadsheet: Staff Costs. If you have entered data for different staff types then the cost of all of the staff can be found in this Staff Costs spreadsheet. Because on-costs vary by salary it is not possible to provide an exact figure. The calculations in the Staff Costs worksheet are based around on-costs of 22%. You will see this figure entered into cell F4. This figure can be changed if you want to reduce or increase the on-costs. None of the other cells in this spreadsheet can be modified. If you want to make amendments, you will have to change the data in staffing spreadsheets.
If you want to plan budgets for the future, you can make estimates for salary increases in the spreadsheet Costs with inflation. A default value of 2% for inflation has been entered into cell F4, and this can be altered by the user. None of the other cells in this spreadsheet can be modified. If you want to make amendments, you will have to change the data in staffing spreadsheets.
