Safeguarding Calculator

Please follow the steps below to enable this spreadsheet to accurately calculate your teachers pay protection The spreadsheet will only calculate for one teacher at a time. For every different teacher with management point safeguarding, a new spreadsheet must be used 1 Click on the 'Calculator' tab. This will take you to the input spreadsheet. 2 Enter the teacher's name and FTE in the appropriate boxes. 3 Enter the relevant data in each cell using the drop down menu, utilising the notes below as a guide. Only enter data in cells colured light green. -See tables below for help with Payscale, Mgt Points, R&R Incentives & TLR codes -Payscale Sept 2005 Payscale Sept 2006 Payscale Sept 2007 Payscale Sept 2008 Payscale M1 M2 M3 M4 Mgt Points MA1 MA1 MA1 MA1 R & R Incentives 0 0 0 0 Salary @Dec 05 TLR Grade TLR2 A TLR2 A TLR2 A TLR2 A * Due to the complexities of reducing TLR's once given, the spreadsheet cannot calculate for their reduction. Please speak to your HR consultant for further guidance if applicable. 4 You will notice that once the first years data has been input, the remaining years populate automatically. An incremental rise has been built into each year where appropriate. DO NOT LEAVE ANY BLANKS. If no data is required, enter a 0 (zero). If any amendments to the pre-populated data are necessary this can be done by overtyping the formula contained in the cell. However with ammendments to the payscale, all subsequent years must also be overtyped. 5 The calculator will automatically show the salary details for the staff member over the next 3 years. It will also highlight any safeguarded amount, as well as any rise in pay due from incremental progression and inflation. 6 Based on incremental pay rises the calculator will work out the value of any future protected pay (which can be paid to the staff member as an allowance). As a visual check, the calculator will also show if the staff members pay is to be protected, and switch between red and green as appropriate. 7 Finally for January 2009, when all Mgt point protection will cease, it will show the salary for that member of staff 8 Please note that the final Salary figure quoted, is that received by the staff member, not the cost to the school. 9 As stated above, the calculator can only be used for one teacher at a time. Once data has been input for a particular staff member, either print the page off, or save the spreadsheet under that teachers name, and reopen a new spreadsheet for each teacher. GUIDANCE NOTES Enter the Payscale and pay point. Data will auto-fill for remaining years, with rising increments for each year. The payscale can be increased at any point. However if manually increased, all subsequent payscale cells must also be manually filled. (eg M6 to UPS 1) Enter the number of TLR points given. Data will auto-fill for remaining years. If no TLR's given, enter a 0 TLR points can be added or increased at any time. *TLR's cannot be reduced. If a TLR is given in in the first year (effective Jan 2006), it must be entered in the Sept 2005 data input cell. Enter the number of Management Points and /or Recruitment & Retention Incentive Points. Data will auto-fill for remaining years. If Points are time limited, remove in the relevant year If no Points given ,enter a 0 Management Points and R&R Incentive Points can be added or removed at any time. Page 1 of 9 1/28/200810 If at any point the equations in the input cells are overwritten and need to be reinstated, ie for inputting the next teachers data, they can be reproduced by clicking on the "RESET TEACHER DATA" button. WARNING: This will automatically reset to a blank template, regardless of any 'saves' that have been made. 11 Once the data has been entered for all staff members, and printouts have been kept, the information can be input into the teaching staff salary calculator, The printouts will enable the user to identify when the management points will cease, when TLR values should be added and also what the value of the 'protected sum' should be (if applicable). Inflation: inflation for Pay and TLR values have been set at 2.5% for each year. this can be amended, by clicking on the appropriate tab and overtyping the percentages (highlighted yellow) Page 2 of 9 1/28/2008Payscale codes Table: when entering staff pay scales, please use the following codes Mainscale -Point 1 M1 Mainscale -Point 2 M2 Upper Pay Scale 1 U1 Mainscale -Point 3 M3 Upper Pay Scale 2 U2 Mainscale -Point 4 M4 Upper Pay Scale 3 U3 Mainscale -Point 5 M5 Mainscale -Point 6 M6 Management Allowance Code Table: when entering staff Management Allowances, please use the following codes 1 Management Allowance Point MA1 2 Management Allowance Points MA2 3 Management Allowance Points MA3 4 Management Allowance Points MA4 5 Management Allowance Points MA5 Recruitment & Retention Incentive Code Table: when entering staff R&R Incentives, please use the following codes 1 Recruitment & Retention Point R&R1 2 Recruitment & Retention Points R&R2 3 Recruitment & Retention Points R&R3 4 Recruitment & Retention Points R&R4 5 Recruitment & Retention Points R&R5 Assumed values for R&R Incentives have been set in this calculator, however they can be ammended by changing the values in column 'D' of the "Allowances" tab. Note: R&R Incentives are not set against a national scale, and can be agreed locally. TLR Code Table: when entering staff TLR's, please use the following codes Minimum TLR 2 value TLR2 A Minimum TLR 1 value TLR1 A Mid-Point TLR 2 value TLR2 B Lower Range TLR 1 value TLR1 B Maximum TLR 2 value TLR2 C Higher Range TLR1 value TLR1 C Maximum TLR 1 value TLR1 D Assumed values for TLR's have been set in this calculator, however they can be ammended by changing the values in column 'B' of the "TLR Values" tab. Note: TLR values are not set against a national scale, and can be agreed locally. The minimum TLR2 value is £2,250, rising incrementally by at least £1,500 to a maximum of £5,500) The minimum TLR1 value is £6,500, rising incrementally by at least £1,500 to a maximum of £11,000) Page 3 of 9 1/28/2008Teacher Name: Teacher Name FTE: 1.00 January September September September January Payscale Sept 2005 Payscale Sept 2006 Payscale Sept 2007 Payscale Sept 2008 2006 2006 2007 2008 2009 Payscale M1 M2 M3 M4 20,082 22,137 24,436 26,902 26,902 Mgt Points MA1 MA1 MA1 MA1 1,638 1,638 1,638 1,638 R & R Incentives 0 0 0 0 -----Salary @Dec 05 21,720 TLR Grade TLR2 A TLR2 A TLR2 A TLR2 A 2,250 2,306 2,364 2,423 2,423 Mgt Point less starting TLR value 612 -612 -612 -612 --Cummulative Increase in basic pay from -2,055 4,354 6,820 -incremental progression starting Sept 06 Safeguard protection value -----Protected? Unprotected Unprotected Unprotected Unprotected Unprotected Final Salary 22,332 £ 24,443 £ 26,800 £ 29,325 £ 29,325 £ SEPT 2005 (£) SEPT 2006 (£)* MAIN PAY SCALE CODE %age rise SALARY POINT 0 2.50% 1 M1 20,082 20,584 2 M2 21,597 22,137 3 M3 23,259 23,840 4 M4 24,981 25,606 5 M5 26,877 27,549 6 M6 28,923 29,646 UPPER PAY SCALE SALARY POINT 1 U1 U1 U1 31,260 32,042 2 U2 U2 U2 32,385 33,195 3 U3 U3 U3 33,549 34,388 ADVANCED SKILLS TEACHERS SALARY POINT 1 AST1 32,412 33,222 2 AST2 32,976 33,800 3 AST3 33,540 34,379 4 AST4 34,095 34,947 5 AST5 34,659 35,525 6 AST6 35,226 36,107 7 AST7 35,793 36,688 8 AST8 36,351 37,260 9 AST9 36,912 37,835 10 AST10 37,470 38,407 11 AST11 38,037 38,988 12 AST12 38,787 39,757 13 AST13 39,537 40,525 14 AST14 40,284 41,291 15 AST15 41,034 42,060 16 AST16 41,784 42,829 17 AST17 42,534 43,597 18 AST18 43,287 44,369 19 AST19 44,037 45,138 20 AST20 44,787 45,907 21 AST21 45,537 46,675 22 AST22 46,470 47,632 23 AST23 47,409 48,594 24 AST24 48,345 49,554 25 AST25 49,284 50,516 26 AST26 50,217 51,472 27 AST27 51,159 52,438 Converter for Annual Incremental Progression M1 M2 M3 M4 M2 M3 M4 M5 M3 M4 M5 M6 M4 M5 M6 M6 M5 M6 M6 M6 M6 M6 M6 M6 U1 U1 U1 U1 U2 U2 U2 U2 U3 U3 U3 U3AST1 AST1 AST1 AST1 AST2 AST2 AST2 AST2 AST3 AST3 AST3 AST3 AST4 AST4 AST4 AST4 AST5 AST5 AST5 AST5 AST6 AST6 AST6 AST6 AST7 AST7 AST7 AST7 AST8 AST8 AST8 AST8 AST9 AST9 AST9 AST9 AST10 AST10 AST10 AST10 AST11 AST11 AST11 AST11 AST12 AST12 AST12 AST12 AST13 AST13 AST13 AST13 AST14 AST14 AST14 AST14 AST15 AST15 AST15 AST15 AST16 AST16 AST16 AST16 AST17 AST17 AST17 AST17 AST18 AST18 AST18 AST18 AST19 AST19 AST19 AST19 AST20 AST20 AST20 AST20 AST21 AST21 AST21 AST21 AST22 AST22 AST22 AST22 AST23 AST23 AST23 AST23 AST24 AST24 AST24 AST24 AST25 AST25 AST25 AST25 AST26 AST26 AST26 AST26 AST27 AST27 AST27 AST27SEPT 2007 (£)* SEPT 2008 (£)* %age rise %age rise 2.50% 2.50% change to suit inflation (could be 0) 21,099 21,626 22,690 23,258 note: Coloured cells can be altered 24,436 25,047 26,246 26,902 28,238 28,944 30,387 31,147 32,843 33,664 34,024 34,875 35,247 36,129 34,053 34,904 34,645 35,512 35,238 36,119 35,821 36,717 36,414 37,324 37,009 37,935 37,605 38,545 38,191 39,146 38,781 39,750 39,367 40,351 39,963 40,962 40,751 41,769 41,539 42,577 42,323 43,381 43,111 44,189 43,899 44,997 44,687 45,804 45,478 46,615 46,266 47,423 47,054 48,231 47,842 49,038 48,823 50,043 49,809 51,054 50,792 52,062 51,779 53,073 52,759 54,078 53,749 55,093ADDITIONAL ALLOWANCES MANAGEMENT 0 0 0 MANAGEMENT 1 MA1 1,638 MANAGEMENT 2 MA2 3,312 MANAGEMENT 3 MA3 5,688 MANAGEMENT 4 MA4 7,833 MANAGEMENT 5 MA5 10,572 Recruitment & Retention 0 0 0 Recruitment & Retention 1 R&R1 1,002 Recruitment & Retention 2 R&R2 1,971 Recruitment & Retention 3 R&R3 2,985 Recruitment & Retention 4 R&R4 4,158 Recruitment & Retention 5 R&R5 5,415 note: Coloured cells can be altered05-06 06-07 07-08 08-09 TLR's %age rise %age rise %age rise 0 0 2.50% 2.50% 2.50% change to suit inflation (could be 0) TLR2 A 2250 2,306 2,364 2,423 TLR2 B 3750 3,844 3,940 4,038 TLR2 C 5500 5,638 5,778 5,923 TLR1 A 6500 6,663 6,829 7,000 TLR1 B 8000 8,200 8,405 8,615 TLR1 C 9500 9,738 9,981 10,230 TLR1 D 11000 11,275 11,557 11,846 note: Coloured cells can be altered