wallington county grammar school total income and ... · wallington county grammar school total...

88
Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £ £ £ Income GAG Funding 5,030,002 5,260,104 5,330,100 Private Sector Funding 152,800 158,000 164,000 Other Income 709,000 724,000 739,000 Top Slice (426,042) (437,420) (427,595) Total Income 5,465,761 5,704,684 5,805,505 Expenditure Teaching Staff 3,134,464 3,359,742 3,526,758 Educational Support Staff 547,175 526,646 551,894 Premises Staff 90,362 89,264 81,789 Admin Staff 134,464 139,565 144,050 Other Staff 170,540 165,028 146,581 Agency Staff 12,210 10,000 10,000 Total Staffing Expenditure 4,089,215 4,290,245 4,461,072 88.8% 89.0% 91.0% Maintenance of Premises 64,144 64,000 64,000 Other Occupational Costs 317,135 316,110 321,610 Educational Supplies and Services 642,672 652,500 655,500 Other Supplies and Services 237,754 234,600 235,550 ICT Costs (Non Capital) 60,250 60,250 60,250 Staff Development 40,766 42,000 42,000 Other GAG Expenses 0 0 0 Total Other Expenditure 1,362,722 1,369,460 1,378,910 Total Expenditure 5,451,937 5,659,705 5,839,982 Net Surplus/Deficit 13,824 44,979 (34,477) Transfer to Capital 0 0 0 Net Surplus/Deficit after Transfers 13,824 44,979 (34,477) Reserves B/F 153,829 167,653 212,632 Reserves C/F 167,653 212,632 178,155

Upload: others

Post on 17-Oct-2019

7 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Wallington County Grammar School

Total Income and Expenditure Account

Estimate Estimate Estimate

2017/18 2018/19 2019/20

£ £ £

Income

GAG Funding 5,030,002 5,260,104 5,330,100

Private Sector Funding 152,800 158,000 164,000

Other Income 709,000 724,000 739,000

Top Slice (426,042) (437,420) (427,595)

Total Income 5,465,761 5,704,684 5,805,505

Expenditure

Teaching Staff 3,134,464 3,359,742 3,526,758

Educational Support Staff 547,175 526,646 551,894

Premises Staff 90,362 89,264 81,789

Admin Staff 134,464 139,565 144,050

Other Staff 170,540 165,028 146,581

Agency Staff 12,210 10,000 10,000

Total Staffing Expenditure 4,089,215 4,290,245 4,461,072

88.8% 89.0% 91.0%

Maintenance of Premises 64,144 64,000 64,000

Other Occupational Costs 317,135 316,110 321,610

Educational Supplies and Services 642,672 652,500 655,500

Other Supplies and Services 237,754 234,600 235,550

ICT Costs (Non Capital) 60,250 60,250 60,250

Staff Development 40,766 42,000 42,000

Other GAG Expenses 0 0 0

Total Other Expenditure 1,362,722 1,369,460 1,378,910

Total Expenditure 5,451,937 5,659,705 5,839,982

Net Surplus/Deficit 13,824 44,979 (34,477)

Transfer to Capital 0 0 0

Net Surplus/Deficit after Transfers 13,824 44,979 (34,477)

Reserves B/F 153,829 167,653 212,632

Reserves C/F 167,653 212,632 178,155

Page 2: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Wallington County Grammar School

Key Performance Indicators17/18 18/19 19/20

SLT Cost as % of GAG 9.74% 9.74% 10.02%

Teaching Cost (incl SLT) as % of GAG 62.32% 63.87% 66.17%

Agency Staff as% of GAG 0.24% 0.19% 0.19%

Education Support as % of GAG 10.88% 10.01% 10.35%

Teaching Cost per Pupil 2,963£ 3,068£ 3,206£

Average Teachers Cost 52,929£ 56,641£ 60,999£

Education Support Cost per Pupil 517£ 481£ 502£

Average Education Support Cost 34,736£ 34,146£ 35,685£

Teaching Staff (FTE) 59.2 59.3 57.8

Education Support Staff (FTE) 15.8 15.4 15.5

Pupil Numbers 1058 1095 1100

Pupil/Teacher Ratio 17.9 18.5 19.0

Pupil/ES Ratio 67.2 71.0 71.1

Admin Staff Cost per Pupil 127£ 127£ 131£

Extended Services Staff as a % of Extended Services Income n/a n/a n/a

Maintenance & Occupation Costs as % of Total Income 6.98% 6.66% 6.64%

Education Supplies & Services as % of GAG 12.78% 12.40% 12.30%

Other Supplies & Services as % of Total Income 4.35% 4.11% 4.06%

Staff Development as % of GAG 0.81% 0.80% 0.79%

Page 3: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Wallington County Grammar School

Initial Analysis of Funding for 2017/18744

Main School Funding

Students Funding Students

AWPU 418 4,442.00 1,856,756.00 450

287 4,442.00 1,274,854.00 294

Deprivation

IDACI 1 80 - 0.00 89

2 86 - 0.00 85

3 33 100.00 3,300.03 34

4 17 200.00 3,399.93 18

5 11 300.00 3,300.03 13

6 3 400.00 1,199.91 5

FSM 15 800.00 12,000.23 16

FSM 6 70

LAC 2 500.00 1,041.29 3

Low Cost, High Incidence SEN 2 1,917.00 3,355.74 3

EAL 11 75.00 835.69 21

Lump Sum 100,000.00

MFG

705 3,260,042.85 744

Changes in Sixth Form Funding

Base Funding 351 4,000.00 1,403,908.00 351

2 3,300.00 6,676.00

Retention Impact 0.999 (2,017.00) 1

Disadvantage Funding 1.57% 23,574.00 1.5%

Large Programme Funding 28 400.00 22,400.00 18

1

Area Uplift 1.12 174,545.00 1.12

1,629,086.00

.

2017/18 Indicative 2018/19 Forecast

Page 4: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Student Support 18,188.00

4,907,316.85

ESG Impact (Full Impact) 1058 31,702.41

ESG Protection

SEN LACSEG Adjustment

Total Funding 4,939,019.26

Other Funding Streams

Rates 28,708.00

Pupil Premium 60,775.00

SEN Support 1,500.00

Other Grants -

Parental Subscriptions (Incl Gift Aid) 135,300.00

Other Donations & Fundraising 17,500.00

Catering Income 350,000.00

Educational Visits 250,000.00

Lettings 30,000.00

Staff Services 30,000.00

Exam Fees 20,000.00

Sponsor Income 4,000.00

Investment Income

Sale of other Goods 25,000.00

Total Revenue 5,891,802.26

Top Slice (426,041.56)

Total Net Revenue 5,465,760.70

Page 5: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Funding 18/19 19/20 18/19 19/20

4,241.31 1,908,589.50 450 450 1,908,590 1,908,590

4,815.75 1,415,830.50 295 300 1,420,646 1,444,725

318.43 28,340.35 75 89 23,758 28,340 67.1

428.23 36,399.45 92 85 39,468 36,399 84.1

565.49 19,226.69 54 34 30,402 19,227 32

614.90 11,068.41 15 18 9,446 11,068 17

658.82 8,564.60 3 13 2,168 8,565 14

889.40 4,446.72 0 5 - 4,447 3

483.13 7,729.94 16 16 7,940 7,730

861.95 60,206.30 58 69.848952 49,993 60,206 57.8

- 0.00 2 3.174648 - -

1,701.95 4,914.32 1 2.887464 1,702 4,914

1,520.77 32,370.87 11 21.28584 16,728 32,371 41.1

120,783.30 100,000 100,000

(125,377.76) (65,000.00)

3,533,093.19 745 750 3,610,841.02 3,601,582.15

4,748.78 4,802

4,000.00 1,404,000.00 350 350 1,400,000 1,400,000

3,300.00 0.00

21,450.68 1.6% 1.6% 21,980 21,980

400.00 14,400.00 25 25 20,000 20,000

800.00 1,600.00

172,975.32 1.12 1.12 173,037.60 173,037.60

1,614,426.00 1,615,017.60 1,615,017.60

2018/19 Forecast Student Numbers Estimated funding

Page 6: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

18,085.00 18,000 18,000

5,165,604.19 5,243,858.62 5,234,599.75

1095 1100

5,165,604.19 5,243,858.62 5,234,599.75

29,000 29,000 30,000

62,500 62,500 62,500

3,000 3,000 3,000

140,000 140,000 145,000

18,000 18,000 19,000

360,000 360,000 370,000

250,000 250,000 250,000

35,000 35,000 40,000

30,000 30,000 30,000

20,000 20,000 20,000

4,000 4,000 4,000

25,000 25,000 25,000

6,142,104.19 6,220,358.62 6,233,099.75

(437,420.31) (443,289.40) (427,594.98)

5,704,683.88 5,777,069.22 5,805,504.77

Page 7: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

3797.29 1,587,267.22 1,708,780.50 1,708,780.50

4311.59 1,237,426.33 1,271,919.05 1,293,477.00

290 19,459.00 19,485.15 19,615.93

390 32,799.00 32,843.08 33,063.51

515 16,480.00 16,502.15 16,612.90

515 8,755.00 8,766.77 8,825.60

600 8,400.00 8,411.29 8,467.74

810 2,430.00 2,433.27 2,449.60

1225 18,375.35 20,131.59 19,599.66

785 Ever 6 45,373.00 45,433.99 45,738.91

1550 2,713.30 1,550.00 1,550.00

1385 56,923.50 57,000.01 57,382.56

110,000 110,000.00 110,000.00 110,000.00

3,146,401.70 3,303,256.85 3,325,563.91

3,450,344.10 Area Factor 3,622,351.47 3,646,813.38

1.0966 1.0966 1.0966

3,610,841.02 3,601,582.15

Restricted

Year 1

Page 8: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £
Page 9: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Sanity Check

Page 10: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Wallington County Grammar School

Teachers Salary Projections Financial Year 2017-2018

FTE

NAME BASIC TLR FTE Base TLR Total

SLT

Jamie Bean (L24 - L30) L25 1.00 74,177.00 0.00 74,177.00

Duvessa Owen (L18 - L22) L22 1.00 69,139.00 0.00 69,139.00

Simon Waters (L18 - L22) L19 1.00 64,469.00 0.00 64,469.00

David Jones (L13 - L17) L17 1.00 61,515.00 0.00 61,515.00

Clare Tovey (L13 - L17) L17 1.00 61,515.00 0.00 61,515.00

Alasdair Robertson (L13 - L17) L13 1.00 56,059.00 0.00 56,059.00

Kelvin Meek (L8 - L12) L12 1.00 54,766.00 0.00 54,766.00

Alasdair Robertson (L8 - L12) L10 1.00 52,325.00 0.00 52,325.00

Gemma Farlow (L8 - L12) L10 1.00 52,325.00 0.00 52,325.00

Art & Design

Laura Musselbrook U3 2c 0.80 42,498.00 6,515.00 39,210.40

Jodie James M1 1.00 26,662.00 0.00 26,662.00

Duncan Holding U3 1c 0.80 42,498.00 11,353.00 43,080.80

DT

Steve Weston U3 1b 1.00 42,498.00 9,474.00 51,972.00

Sally Smart U1 ii 1.00 39,519.00 0.00 39,519.00

Economics & Gov/Pol

James Dicker U1 i 2c 1.00 39,519.00 6,515.00 46,034.00

Rebecca Brownsing M3 1.00 30,067.00 0.00 30,067.00

Emmanuel Hammond U1 i 1.00 39,519.00 0.00 39,519.00

English

Catherine Curtis U2 i 1b 1.00 40,981.00 10,224.00 51,205.00

Louise King U2 i 2c 1.00 40,981.00 6,515.00 47,496.00

Lizzie Ball U1 ii 2c 1.00 39,519.00 6,515.00 46,034.00

Michael McLauchlan M2 2a 1.00 28,315.00 2,667.00 30,982.00

Anna Weddell M6 2a 1.00 37,645.00 2,667.00 40,312.00

Nathan Rhodes-Brandon M2 0.80 28,315.00 0.00 22,652.00

Marina French M2 1.00 28,315.00 0.00 28,315.00

Food Technology

Dhrissie Nunes U1 ii 2a 0.95 39,519.00 2,667.00 40,076.70

Wellbeing

Kat Turner U1 i 3a 0.60 39,519.00 2,081.00 25,792.40

Geography

Natasha Evans U1 i 2b 1.00 39,519.00 6,514.00 46,033.00

Page 11: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Julie Dimond U1 i 2b 1.00 39,519.00 4,444.00 43,963.00

History/Classics

Tom Davies U2 i 2c 1.00 40,981.00 6,515.00 47,496.00

Ben Greenly (LP1 - LP5) LP4 1.00 45,524.00 0.00 45,524.00

Computer Science

Jack Barwick M5 2a 1.00 34,637.00 7,667.00 42,304.00

Mathematics

Gill Bird (L13 - L17) U3 1c 1.00 42,498.00 11,353.00 53,851.00

Joe Gordon U2 ii 2a 1.00 40,981.00 3,417.00 44,398.00

Luke Howells U3 2a 1.00 42,498.00 2,667.00 45,165.00

Jean Luc Lescault U3 1.00 42,498.00 0.00 42,498.00

Ravinder Bhandari U2 i 1.00 40,981.00 0.00 40,981.00

Daniel Singarajah M1 1.00 26,662.00 0.00 26,662.00

Anne Pushpanathan M4 1.00 31,929.00 0.00 31,929.00

Ioana Boulescu M6 1.00 37,645.00 0.00 37,645.00

Modern Foreign Languages

Antonella Gabriele U3 1a 1.00 42,498.00 7,697.00 50,195.00

Claudie Mortreuil U2 i 1.00 40,981.00 0.00 40,981.00

Audrey Paradis (Maternity) U2 i 2c 1.00 40,981.00 6,515.00 47,496.00

Andrea Colombo U1 ii 0.80 39,519.00 0.00 31,615.20

Eva O'Connor M5 0.60 34,637.00 0.00 20,782.20

Music

Catherine Williams U1 i 0.40 39,519.00 0.00 15,807.60

Johanna Martin M5 2b 0.80 34,637.00 4,444.00 31,264.80

PE/Games

David Johnson U3 1b 1.00 42,498.00 9,474.00 51,972.00

Tom Collins U2 i 2c 1.00 40,981.00 6,515.00 47,496.00

Ariez Mehta M4 2a 1.00 31,929.00 2,667.00 34,596.00

RS & Philosophy

Liz Jennings U3 2c 1.00 42,498.00 7,515.00 50,013.00

Mark Young U3 2c 1.00 42,498.00 6,515.00 49,013.00

Biology

Gemma Farlow U3 2c 1.00 42,498.00 6,515.00 49,013.00

Sadaf Khan M6 1.00 37,645.00 0.00 37,645.00

Shamee Tanna U2 i 0.60 40,981.00 0.00 24,588.60

Emma Burgess U3 0.60 42,498.00 0.00 25,498.80

Chemistry

Jamie Gallagher U2 i 2c 1.00 40,981.00 6,515.00 47,496.00

Farhaan Hasan M4 2c 1.00 31,929.00 6,515.00 38,444.00

Joe Moran M6 0.60 37,645.00 0.00 22,587.00

Page 12: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Rachel Kershaw U1 i 1.00 39,519.00 0.00 39,519.00

Physics

John Croft U2 i 2c 1.00 40,981.00 6,515.00 47,496.00

Peter Quantrel U1 i 1.00 39,519.00 0.00 39,519.00

Elizabeth Billy-Pedro M5 1.00 34,637.00 0.00 34,637.00

Sumeira Hayat M4 0.80 31,929.00 0.00 25,543.20

Toby M1 1.00 26,662.00 0.00 26,662.00

Teaching Assistants

Eva O'Connor 0.15 3,878.40

Marie-Pierre Verrills 0.17 5,024.22

Joe Perkins

Goran Maric 0.37 13,745.05

Nigel Legg 0.28 7,600.25

Sports Allowances 4,654.70

Duties 8,725.00

59.22

Page 13: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Sep Oct Nov Dec Jan Feb Mar Apr

6,181.42 6,181.42 6,181.42 6,181.42 6,181.42 6,181.42 6,181.42 6,181.42

5,761.58 5,761.58 5,761.58 5,761.58 5,761.58 5,761.58 5,761.58 5,761.58

5,372.42 5,372.42 5,372.42 5,372.42 5,372.42 5,372.42 5,372.42 5,372.42

5,126.25 5,126.25 5,126.25 5,126.25 5,126.25 5,126.25 5,126.25 5,126.25

5,126.25 5,126.25 5,126.25 5,126.25

4,671.58 4,671.58 4,671.58 4,671.58

4,563.83 4,563.83 4,563.83 4,563.83 4,563.83 4,563.83 4,563.83 4,563.83

4,360.42 4,360.42 4,360.42 4,360.42

4,360.42 4,360.42 4,360.42 4,360.42

482.16 56.39 45.11 45.11 56.39

2,221.83 2,221.83 2,221.83 2,221.83 2,221.83 2,221.83 2,221.83 2,221.83

3,590.07 3,590.07 3,590.07 3,590.07 3,590.07 3,590.07 3,590.07 3,590.07

4,331.00 4,331.00 4,331.00 4,331.00 4,331.00 4,331.00 4,331.00 4,331.00

3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25

3,836.17 3,836.17 3,836.17 3,836.17 3,836.17 3,836.17 3,836.17 3,836.17

2,359.58 2,359.58 2,359.58 2,359.58 2,505.58 2,505.58 2,505.58 2,505.58

3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25

4,267.08 4,267.08 4,267.08 4,267.08 4,267.08 4,267.08 4,267.08 4,267.08

3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00

3,836.17 3,836.17 3,836.17 3,836.17 3,836.17 3,836.17 3,836.17 3,836.17

2,581.83 2,581.83 2,581.83 2,581.83 2,581.83 2,581.83 2,581.83 2,581.83

3,359.33 3,359.33 4,109.33 3,359.33 3,359.33 3,359.33 3,359.33 3,359.33

1,887.67 1,887.67 1,887.67 1,887.67 1,887.67 1,887.67 1,887.67 1,887.67

2,359.58 2,359.58 2,359.58 2,359.58

3,339.73 3,339.73 3,339.73 3,339.73 3,339.73 3,339.73 3,339.73 3,339.73

2,149.37 2,149.37 2,149.37 2,149.37 2,149.37 2,149.37 2,149.37 2,149.37

3,836.08 3,836.08 3,836.08 3,836.08 3,836.08 3,836.08 3,836.08 3,836.08

Page 14: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

3,663.58 3,663.58 3,663.58 3,663.58 3,663.58 3,663.58 3,663.58 3,663.58

3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00

3,793.67 3,793.67 3,793.67 3,793.67 3,793.67 3,793.67 3,793.67 3,793.67

3,525.33 3,525.33 3,525.33 3,525.33 3,525.33 3,525.33 3,525.33 3,525.33

4,487.58 4,487.58 4,487.58 4,487.58 4,487.58 4,487.58 4,487.58 4,487.58

3,699.83 3,699.83 3,699.83 3,699.83 3,699.83 3,699.83 3,699.83 3,699.83

3,763.75 3,763.75 3,763.75 3,763.75 3,763.75 3,763.75 3,763.75 3,763.75

3,541.50 3,541.50 3,541.50 3,541.50 3,541.50 3,541.50 3,541.50 3,541.50

3,415.08 3,415.08 3,415.08 3,415.08 3,415.08 3,415.08 3,415.08 3,415.08

2,221.83 2,221.83 2,221.83 2,221.83 2,221.83 2,221.83 2,221.83 2,221.83

2,660.75 2,660.75 2,660.75 2,660.75 2,660.75 2,660.75 2,660.75 2,660.75

3,137.08 3,137.08 3,137.08 3,137.08 3,137.08 3,137.08 3,137.08 3,137.08

4,182.92 4,182.92 4,182.92 4,182.92 4,182.92 4,182.92 4,182.92 4,182.92

3,415.08 3,415.08 3,415.08 3,415.08 3,415.08 3,415.08 3,415.08 3,415.08

3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00

1,537.16 1,956.34 45.11 56.39 45.11 45.11 45.11

1,731.85 1,731.85 1,731.85 1,731.85 1,731.85 1,731.85 1,731.85 1,731.85

1,317.30 1,317.30 1,317.30 1,317.30 1,317.30 1,317.30 1,317.30 1,317.30

2,605.40 2,605.40 2,605.40 2,605.40 2,605.40 2,605.40 2,605.40 2,605.40

4,331.00 4,331.00 4,331.00 4,331.00 4,331.00 4,331.00 4,331.00 4,331.00

4,458.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 4,208.00 3,958.00

2,883.00 2,883.00 2,883.00 2,883.00 2,883.00 2,883.00 2,883.00 2,883.00

4,167.75 4,167.75 4,167.75 4,167.75 4,167.75 4,167.75 4,167.75 4,167.75

4,084.42 4,084.42 4,084.42 4,084.42 4,084.42 4,084.42 4,084.42 4,084.42

4,084.42 4,084.42 4,084.42 4,084.42

3,137.08 3,137.08 3,137.08 3,137.08 3,137.08 3,137.08 3,137.08 3,137.08

2,049.05 2,049.05 2,049.05 2,049.05 2,049.05 2,049.05 2,049.05 2,049.05

2,124.90 2,124.90 2,124.90 2,124.90 2,124.90 2,124.90 2,124.90 2,124.90

4,458.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00

2,660.75 2,660.75 2,660.75 2,660.75 3,203.67 3,203.67 3,203.67 3,203.67

1,882.25 1,882.25 1,882.25 1,882.25 1,882.25 1,882.25 1,882.25 1,882.25

Page 15: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25

3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00 3,958.00

3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25 3,293.25

2,886.42 2,886.42 2,886.42 2,886.42 2,886.42 2,886.42 2,886.42 2,886.42

2,128.60 2,128.60 2,128.60 2,128.60 2,128.60 2,128.60 1,476.29 1,064.30

554.06 554.06 554.06 554.06 554.06 554.06 554.06

717.75 717.75 717.75 717.75 717.75 717.75 717.75

568.71 490.38 927.07 695.31 927.08 463.54

1,145.42 1,145.42 1,145.42 1,145.42 1,145.42 1,145.42 1,145.42 1,145.42

633.35 633.35 633.35 633.35 633.35 633.35 633.35 633.35

2,500.00 1,250.00

860.00 760.00 1,020.00 540.00 920.00 720.00 1,080.00 440.00

208,249.35 208,414.56 208,070.76 209,273.71 206,099.82 205,611.67 207,051.13 203,990.49

Page 16: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

May Jun Jul Aug Annual

6,181.42 6,181.42 6,181.42 6,181.42 74,177.00

5,761.58 5,761.58 5,761.58 5,761.58 69,139.00

5,372.42 5,372.42 5,372.42 5,372.42 64,469.00

5,126.25 5,126.25 5,126.25 5,126.25 61,515.00

20,505.00

4,671.58 4,671.58 4,671.58 4,671.58 37,372.67

4,563.83 4,563.83 4,563.83 4,563.83 54,766.00

17,441.67

4,360.42 4,360.42 4,360.42 4,360.42 34,883.33

3,267.53 3,267.53 3,267.53 3,267.53 13,755.29

2,221.83 2,221.83 2,221.83 2,221.83 26,662.00

28,720.53

4,331.00 4,331.00 4,331.00 4,331.00 51,972.00

3,293.25 3,293.25 3,293.25 3,293.25 39,519.00

3,836.17 3,836.17 3,836.17 3,836.17 46,034.00

2,505.58 2,505.58 2,505.58 2,505.58 29,482.99

3,293.25 3,293.25 3,293.25 3,293.25 39,519.00

4,267.08 4,267.08 4,267.08 4,267.08 51,205.00

3,958.00 3,958.00 3,958.00 3,958.00 47,496.00

3,836.17 3,836.17 3,836.17 3,836.17 46,034.00

2,581.83 2,581.83 2,581.83 2,581.83 30,982.00

3,359.33 3,359.33 3,359.33 3,359.33 41,062.00

1,887.67 1,887.67 1,887.67 1,887.67 22,652.00

2,359.58 2,359.58 2,359.58 2,359.58 18,876.67

3,339.73 3,339.73 3,339.73 3,339.73 40,076.70

2,149.37 2,149.37 2,149.37 2,149.37 25,792.40

3,836.08 1,787.86 1,295.19 1,815.63 39,423.43

Page 17: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

3,663.58 3,663.58 3,663.58 3,663.58 43,963.00

3,958.00 3,958.00 3,958.00 3,958.00 47,496.00

3,793.67 3,793.67 3,793.67 3,793.67 45,524.00

3,525.33 3,525.33 3,525.33 3,525.33 42,304.00

4,487.58 4,487.58 4,487.58 4,487.58 53,851.00

3,699.83 3,699.83 3,699.83 3,699.83 44,398.00

3,763.75 3,763.75 3,763.75 3,763.75 45,165.00

3,541.50 3,541.50 3,541.50 3,541.50 42,498.00

3,415.08 3,415.08 3,415.08 3,415.08 40,981.00

2,221.83 2,221.83 2,221.83 2,221.83 26,662.00

2,660.75 2,660.75 2,660.75 2,660.75 31,929.00

3,137.08 3,137.08 3,137.08 3,137.08 37,645.00

4,182.92 4,182.92 4,182.92 4,182.92 50,195.00

3,415.08 3,415.08 3,415.08 3,415.08 40,981.00

3,958.00 3,958.00 3,958.00 3,958.00 47,496.00

526.92 2,634.60 2,634.60 9,526.45

1,731.85 3,596.92 19,183.57

1,317.30 1,317.30 1,317.30 1,317.30 15,807.60

2,605.40 2,605.40 2,605.40 2,605.40 31,264.80

4,331.00 4,331.00 4,331.00 4,331.00 51,972.00

3,958.00 3,958.00 4,208.00 3,958.00 48,496.00

2,883.00 2,883.00 2,883.00 2,883.00 34,596.00

4,167.75 4,167.75 4,167.75 4,167.75 50,013.00

4,084.42 4,084.42 4,084.42 4,084.42 49,013.00

16,337.67

3,137.08 3,137.08 3,137.08 3,137.08 37,645.00

2,049.05 2,049.05 2,049.05 2,049.05 24,588.60

2,124.90 2,124.90 2,124.90 2,124.90 25,498.80

3,958.00 3,958.00 4,958.00 3,958.00 48,996.00

3,203.67 3,203.67 3,203.67 3,203.67 36,272.33

1,882.25 1,882.25 1,882.25 1,882.25 22,587.00

Page 18: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

3,293.25 3,293.25 3,293.25 3,293.25 39,519.00

3,958.00 3,958.00 3,958.00 3,958.00 47,496.00

3,293.25 3,293.25 3,293.25 3,293.25 39,519.00

2,886.42 2,886.42 2,886.42 2,886.42 34,637.00

15,312.19

5,221.83 2,221.83 2,221.83 9,665.50

3,878.40

5,024.22

463.54 4,535.63

1,145.42 1,145.42 1,145.42 1,145.42 13,745.05

633.35 633.35 633.35 633.35 7,600.25

904.70 4,654.70

920.00 960.00 505.00 0.00 8,725.00

201,811.86 206,953.92 203,671.71 201,532.45 2,470,731.44

695,973.54

3,166,704.98

4,041,879.70

35,126.00

10,000.00

4,087,005.70

Error

Page 19: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

8,164.00

Comments NI Calc Pen Calc

9,109.79 12,224.37

8,414.55 11,394.11

7,770.09 10,624.49

7,362.44 10,137.67

1,703.06 3,379.22

4,030.80 6,159.02

6,431.08 9,025.44

1,280.32 2,874.39

3,687.27 5,748.77

771.60 2,266.87

2,552.72 4,393.90

2,836.80 4,733.14

6,045.50 8,564.99

4,326.99 6,512.73

5,226.06 7,586.40

2,942.02 4,858.80

4,326.99 6,512.73

£750 Allowance for T&L 5,939.66 8,438.58

5,427.82 7,827.34

5,226.06 7,586.40

3,148.88 5,105.83

4,539.92 6,767.02

1,999.34 3,733.05

1,478.35 3,110.87

4,403.95 6,604.64

Full TLR 2,432.72 4,250.59

Includes Recruitment Bonus to equiv 2c 4,313.80 6,496.98

Page 20: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

TLR for D of E 4,940.26 7,245.10

5,427.82 7,827.34

5,155.68 7,502.36

£5000 Retention Bonus 4,711.32 6,971.70

6,304.81 8,874.64

£750 Allowance for T&L responsibility 5,000.29 7,316.79

5,106.14 7,443.19

4,738.09 7,003.67

4,528.75 6,753.67

2,552.72 4,393.90

3,279.57 5,261.90

4,068.38 6,203.90

5,800.28 8,272.14

4,528.75 6,753.67

5,427.82 7,827.34

188.02 1,569.96

1,520.70 3,161.45

1,054.82 2,605.09

3,187.91 5,152.44

6,045.50 8,564.99

5,565.82 7,992.14

3,647.62 5,701.42

Allowance for E Safety 5,775.16 8,242.14

5,637.16 8,077.34

1,127.97 2,692.45

4,068.38 6,203.90

2,266.59 4,052.20

2,392.20 4,202.20

Honoraria for SLT Shadow 5,634.82 8,074.54

3,878.95 n/a

1,990.37 3,722.34

Page 21: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

4,326.99 6,512.73

5,427.82 7,827.34

4,326.99 6,512.73

3,653.27 5,708.18

986.45 2,523.45

207.21 1,592.87

535.22 639.16

n/a

770.18 2,265.18

- n/a

642.35 767.09

1,204.05 1,437.88

265,361.76 398,370.88

10.7% 16.1%

NTS 51,073.49 160,368.59

Total Staff 316,435.26 558,739.47

Other Staff Costs

Agency

Grand Total

Check

Page 22: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

30688.513

Page 23: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Wallington County Grammar School

Non-Teaching Staff Salary Projections Financial Year 2017-2018

Spine Spine

Grade Range Act LLW Basic Allow TTO

Administration

Jo Johnson S6/SO1 26 - 31 30 30 28,668.00 38.00

Laura Gayle 7/8 29 - 34 29 29 27,801.00 165.00 38.00

Amanda Tutt S6/SO1 26 - 31 31 31 29,517.00 165.00 38.00

Rita Bharadia 4/5 18 - 25 25 25 24,510.00 38.00

Education Support

Daniel Cardenas PO2 35 - 38 38 38 35,286.00 38.00

Yasmin Noor Ahmed 5/6 22 - 28 26 26 25,242.00 165.00 38.00

Peggy Clode S6/SO1 26 - 31 30 30 28,668.00 38.00

Carole Brooks 5/6 22 - 28 31 31 29,517.00 165.00 38.00

Mandy Curtis 5/6 22 - 28 24 24 23,802.00 165.00 38.00

Irene Gambel 5/6 22 - 28 24 24 23,802.00 165.00 38.00

Lorraine Lenaghan S6/SO1 26 - 31 30 30 28,668.00 38.00

Maria Waters 5/6 22 - 28 26 26 25,242.00 165.00 38.00

Eugenie Bryan 4/5 18 - 25 22 22 22,506.00 38.00

Terry Round 4/5 18 - 25 25 25 24,510.00 165.00 38.00

Nicola Moyle 4/5 18 - 25 21 21 21,984.00 38.00

Paul Kiteley 4/5 18 - 25 18 18 19,917.00 38.00

Leila Herbal 4/5 18 - 25 18 18 19,917.00 38.00

Nathan Rhodes-Brandon 4/5 18 - 25 18 18 19,917.00 38.00

Phil Nicholson 5/6 22 - 28 26 26 25,242.00 165.00 38.00

Michael Mulligan 5/6 22 - 28 27 27 26,019.00 165.00 38.00

Angela Stratford 5/6 22 - 28 28 28 26,805.00 38.00

Annette Slade 5/6 22 - 28 24 24 23,802.00 165.00 38.00

Tracey Donald 4/5 18 - 25 20 20 21,276.00 165.00 38.00

Richard Poynter 5/6 22 - 28 24 24 23,802.00 165.00 38.00

Asma Farshori 4/5 18 - 25 22 22 22,506.00 38.00

Oliver Williamson N/A N/A N/A N/A 10,000.00 38.00

Jack Forrest N/A N/A N/A N/A 14,000.00 38.00

Premises

Derek Dougherty 4/5 18 - 25 25 25 24,510.00 38.00

Alan Etherington 4/5 18 - 25 25 25 24,510.00 38.00

Ken Antwi 1c/3 9 - 17 10 10 18,330.00 38.00

Catering

Marion Barton 5/6 22 - 28 28 28 26,805.00 38.00

Page 24: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Diane Reeves 4/5 18 - 25 25 25 24,510.00 165.00 38.00

Jackie Dyduch 1A/2 5 - 13 13 13 18,396.00 38.00

Jan Skipp 1A/2 5 - 13 13 13 18,396.00 38.00

Debbie Branch 1A/2 5 - 13 13 13 18,396.00 38.00

Julia Morcombe 1A/2 5 - 13 7 10 18,330.00 38.00

Samantha Drew 1A/2 5 - 13 7 10 18,330.00 38.00

Tracey Donovan 1A/2 5 - 13 9 10 18,330.00 38.00

Sports Allowances

Duties

Overtime/Suppl/Admin

Invigilation

Educational Support Staff

Premises Staff

Admin Staff

Other Staff

Page 25: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

FTE Calc

+ Wks Hols Contract Hours Total Annual 5 Yrs

2.00 7.20 0.905 36.00 25,951.85 25,951.85 47.20 x

7.20 0.867 36.00 24,243.64 24,410.51 45.20 x

6.94 7.20 1.000 36.00 29,682.00 29,682.00 52.14 x

2.00 7.20 0.905 36.00 22,187.80 22,187.80 47.20 x

102,232.17

4.00 7.20 0.944 36.00 33,296.34 33,296.34 49.20 x

4.00 6.60 0.932 36.00 23,682.01 23,685.73 48.60 23/2/20

4.00 7.20 0.944 36.00 27,051.51 27,051.51 49.20 x

2.00 7.20 0.905 23.00 17,166.80 17,166.80 47.20 x

2.00 7.20 0.905 36.00 21,696.25 21,696.25 47.20 x

2.00 7.20 0.905 30.00 18,080.21 18,170.21 47.20 x

7.20 0.867 20.00 13,806.78 13,806.78 45.20 x

4.00 7.20 0.944 30.00 19,978.65 19,978.66 49.20 x

6.60 0.855 36.00 19,251.39 19,251.39 44.60 21/11/21

7.20 0.867 30.00 17,825.57 17,825.57 45.20 x

7.20 0.867 36.00 19,057.86 19,057.86 45.20 x

6.60 0.855 18.00 8,518.39 7,666.60 44.60 x

6.60 0.855 18.00 8,518.39 7,845.91 44.60 x

6.60 0.855 7.20 3,407.36 3,407.36 44.60 x

6.60 0.855 36.00 21,732.88 21,732.88 44.60 4/11/18

7.20 0.867 36.00 22,698.83 22,698.83 45.20 x

7.20 0.867 15.00 9,682.15 9,682.15 45.20 x

6.60 0.855 21.00 11,958.98 12,013.95 44.60 16/3/20

6.60 0.855 15.00 7,641.83 7,641.83 44.60 13/4/20

7.20 0.867 36.00 20,776.92 20,776.92 45.20 x

7.20 0.867 36.00 19,510.38 19,510.38 45.20 1/9/19

6.60 0.855 36.00 10,000.00 10,000.00 44.60 x

6.60 0.855 36.00 14,000.00 14,000.00 44.60 x

387,963.90

6.94 7.20 1.000 36.00 24,510.00 24,510.00 52.14 x

6.94 7.20 1.000 36.00 24,510.00 24,510.00 52.14 x

6.94 7.20 1.000 30.00 15,275.00 15,275.00 52.14 x

64,295.00

1.00 7.20 0.886 36.00 23,751.27 23,751.27 46.20 x

Page 26: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

7.20 0.867 36.00 21,390.68 21,390.68 45.20 x

7.20 0.867 35.00 15,504.45 15,504.45 45.20 x

7.20 0.867 25.00 11,074.61 11,074.61 45.20 x

7.20 0.867 20.00 8,859.69 8,859.69 45.20 x

6.60 0.855 15.00 6,533.04 6,533.04 44.60 1/9/20

6.60 0.855 15.00 6,533.04 6,533.04 44.60 2/11/20

6.60 0.855 20.00 8,710.71 8,710.71 44.60 4/11/18

102,357.47

1,500.00

2,625.00

10,000.00

25,000.00

695,973.54

421,088.90

67,295.00

104,232.17

103,357.47

695,973.54

Page 27: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

8,164.00 25.5%

OT Rate Comments NI Calc Pen Calc

15.27 2,454.72 6,617.72

14.90 2,242.02 n/a

15.81 2,969.48 7,568.91

13.06 1,935.28 5,657.89

9,601.51 19,844.52

18.80 3,468.26 8,490.57

13.54 2,142.00 6,039.86

15.27 2,606.48 6,898.13

15.81 1,242.39 4,377.54

12.77 1,867.45 5,532.54

12.77 1,380.86 4,633.40

15.27 778.70 3,520.73

13.54 1,630.42 5,094.56

11.99 1,530.06 4,909.11

13.15 1,333.30 4,545.52

11.71 1,503.35 4,859.75

10.61 - n/a

10.61 - 2,000.71

10.61 - 868.88

13.54 1,872.51 5,541.88

13.95 2,005.81 5,788.20

14.28 209.51 2,468.95

12.77 531.29 3,063.56

11.42 - 1,948.67

12.77 1,740.58 5,298.11

11.99 1,565.80 4,975.15

6.23 253.37 n/a

8.72 805.37 3,570.00

28,467.50 94,425.81

13.06 2,255.75 6,250.05

13.06 2,255.75 6,250.05

9.77 981.32 3,895.13

5,492.81 16,395.23

14.28 2,151.04 6,056.57

Page 28: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

13.15 1,825.28 5,454.62

9.80 1,012.98 3,953.63

9.80 401.66 2,824.02

9.80 96.00 2,259.22

9.77 - 1,665.92

9.77 - 1,665.92

9.77 75.45 2,221.23

5,562.42 26,101.16

207.00 382.50

362.25 669.38

1,380.00 2,550.00

51,073.49 160,368.59

7.34% 23.04%

29,588.75 96,497.69

5,906.81 17,160.23

9,877.51 20,354.52

5,700.42 26,356.16

51,073.49 160,368.59

Page 29: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

0.905255

0.866897

1

0.905255

0

0

0.943613

0.932106

0.943613

0.578357

0.905255

0.754379

0.481609

0.786344

0.855389

0.722414

0.866897

0.427695

0.171078

0.855389

0.866897

0.361207

0.498977

0.356412

0.866897

0.866897

0.855389

0.855389

15.75221

0

1

1

0.833333

0

0

0.886076

Page 30: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

0.866897

0.842816

0.602012

0.481609

0.356412

0.356412

0.475216

Page 31: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Wallington County Grammar School

YTD Nov 17 Bal 17/18

Other Staff Costs 8,484.32 26,641.68

Supply Staff 5,232.75 6,977.00

WCG3000 - Building Projects/Maintenance 2,397.70 14,000.00

WCG3005 - Equipment Repairs & Maintenance 8,144.46 17,000.00

WCG3010 - Grounds Maintenance 3,602.25 19,000.00

Maintenance of Premises 14,144.41 50,000.00

WCG3100 - Caretaker Supplies 2,120.91 1,500.00

WCG3105 - Cleaning Contract 29,478.39 81,521.61

WCG3110 - Cleaning Materials 417.59 2,500.00

WCG3120 - Hygiene Services 1,033.84 3,216.16

WCG3125 - Refuse Disposal 3,259.49 6,500.00

WCG3200 - Water/Sewerage Charges 4,543.63 1,956.37

WCG3205 - Gas 4,088.18 25,000.00

WCG3210 - Electricity 9,405.97 24,594.03

WCG3220 - Rent 6,254.52 18,745.48

WCG3250 - Rates 10,026.00 18,682.00

WCG3260 - Insurance 6,225.00 18,780.00

WCG3300 - Fire Alarm & Extinguishers 918.08- 2,918.08

WCG3305 - Security Alarm 1,169.95 2,500.00

WCG3310 - CCTV Monitoring 287.50 962.50

WCG3320 - PAT Testing - 500.00

WCG3330 - Health and Safety 1,418.06 4,500.00

WCG3331 - Other Maintenance Contracts 2,552.01 7,500.00

WCG3332 - Other Premises Costs 2,779.87 4,000.00

WCG3340 - Lettings Related Expenditure 153.62 150.00

WCG3350 - Minibus Costs 856.05 1,643.95

WCG3351 - Minibus Cost Lease 1,617.00 2,695.00

Other Occupation Costs 86,769.50 230,365.18

WCG4000 - Student Rewards 2,500.00 2,000.00

WCG4005 - Books 4,814.90 5,000.00

WCG4010 - Equipment (Not IT) 16,360.79 15,000.00

WCG4011 - Equipment (Not IT) - Curriculum Change 102.51- -

WCG4012- Equipment purchased from bids 75.40- -

WCG4015- IT Consumables - Educational - -

WCG4020 - Stationery - Educational 11,774.68 10,000.00

WCG4025 - Photocopying 7,401.09 12,000.00

WCG4040 - Student Bursary and Pupil Premium payments 1,429.61 12,500.00

WCG4135 - Professional Services - Educational 5,075.00 27,425.00

WCG4140 - Subscriptions - Educational 7,970.94 12,029.06

WCG4150 - Examination Fees 16,716.70 113,283.30

Page 32: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

WCG4155 - IT Equipment - Educational 857.28 10,000.00

WCG4156 - IT Equipment - Educational -Lease 2,729.41 7,220.59

WCG4158 - Transport 7,315.00 7,685.00

WCG4159 - Admissions 254.22 2,745.78

WCG4170 - Work Experience - 6,500.00

WCG4171 - Extra Curricular Costs 1,261.75 4,000.00

WCG4172 - Expenditure from Restricted Income 5,895.57 4,104.43

WCG4173 - Event Costs 24.41- 10,024.41

WCG4174 - Cost of Supplies for resale 11,982.40 13,017.60

WCG4175 - Bid Pot - 15,000.00

WCG6500 - Trips Travel Costs 9,876.47 235,123.53

WCG6505 - Trips Accomodation/Entrance 525.00 3,475.00

WCG6600 - Uniforms Expenditure - -

Educational Supplies & Services 114,538.49 528,133.70

WCG5000 - Catering Food/Drink 59,220.59 120,000.00

WCG5005 - Catering Maintenance & Repairs 1,943.10 1,000.00

WCG5010 - Catering Equipment 133.60 750.00

WCG5015 - Catering Consumables - -

WCG5016 - Cashless Catering System 627.05 1,872.95

WCG5100 - Telephone Costs 1,365.79 4,634.21

WCG5101 - Telephone Costs - Lease 811.72 2,438.28

WCG5105 - Mobile Phones 156.80 500.00

WCG5115 - Postage 843.63 2,156.37

WCG5116 - Postage - Lease 233.71 750.00

WCG5120 - Photocopying / Printing Admin 5,445.41- 10,000.00-

WCG5121 - Photocopying / Printing Lease 3,142.66 9,357.34

WCG5125 - Subscriptions - Admin 765.92 2,734.08

WCG5130 - Stationery - Admin 4,456.28 8,043.72

WCG5140 - Other Professional Services - Non Ed 5,501.70 13,498.30

WCG5145 - General Office Costs 211.82 1,000.00

WCG5153 - Governor Training and Expenses 6.00 -

WCG5155 - Bank Charges - -

WCG5200 - Furniture/Equipment 1,044.01 4,000.00

Other Supplies & Services 75,018.97 162,735.25

WCG5300 - IT Equipment - Non-Educational 1,581.10 3,418.90

WCG5305 - IT Consumables - Non-Educational - 250.00

WCG5310 - IT Licensing 8,902.16 46,097.84

ICT Costs (Non Capital) 10,483.26 49,766.74

WCG6000 - Staff Training 5,942.95 11,557.05

WCG6010 - Recruitment Fees 44.98 14,955.02

WCG6015 - Staff Travel and subsistence 766.09 3,000.00

WCG6020 - CRB Checks 360.00 1,140.00

WCG6025 - Hospitality 1,163.41 1,836.59

Staff Development 8,277.43 32,488.66

WCG6955 - VAT Adjustment - -

Page 33: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

309,232.06 1,053,489.53

Page 34: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

17/18 18/19 19/20

35,126.00 35,126.00 35,126.00

12,209.75 10,000.00 10,000.00

16,397.70 16,500.00 16,500.00

25,144.46 25,000.00 25,000.00

22,602.25 22,500.00 22,500.00

64,144.41 64,000.00 64,000.00

3,620.91 4,000.00 4,000.00

111,000.00 113,000.00 115,000.00

2,917.59 3,000.00 3,000.00

4,250.00 4,250.00 4,250.00

9,759.49 9,000.00 9,000.00

6,500.00 6,500.00 6,500.00

29,088.18 30,000.00 31,000.00

34,000.00 35,000.00 36,000.00

25,000.00 25,000.00 25,000.00

28,708.00 29,000.00 30,000.00

25,005.00 25,110.00 25,110.00

2,000.00 2,000.00 2,000.00

3,669.95 3,500.00 3,500.00

1,250.00 1,250.00 1,250.00

500.00 500.00 500.00

5,918.06 6,000.00 6,000.00

10,052.01 10,500.00 11,000.00

6,779.87 6,000.00 6,000.00

303.62

2,500.00 2,500.00 2,500.00

4,312.00 - -

317,134.68 316,110.00 321,610.00

4,500.00 4,500.00 4,500.00

9,814.90 10,000.00 10,000.00

31,360.79 30,000.00 30,000.00

102.51-

75.40-

-

21,774.68 22,500.00 22,500.00

19,401.09 19,500.00 19,500.00

13,929.61 14,000.00 14,000.00

32,500.00 30,000.00 30,000.00

20,000.00 20,000.00 20,000.00

130,000.00 132,500.00 135,000.00

Page 35: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

10,857.28 15,000.00 15,000.00

9,950.00

15,000.00 15,500.00 16,000.00

3,000.00 3,000.00 3,000.00

6,500.00 6,500.00 6,500.00

5,261.75 5,500.00 5,500.00

10,000.00 10,000.00 10,000.00

10,000.00 10,000.00 10,000.00

25,000.00 25,000.00 25,000.00

15,000.00 30,000.00 30,000.00

245,000.00 245,000.00 245,000.00

4,000.00 4,000.00 4,000.00

-

642,672.19 652,500.00 655,500.00

179,220.59 180,000.00 180,000.00

2,943.10 3,000.00 3,000.00

883.60 1,000.00 1,250.00

- - -

2,500.00 2,500.00 2,500.00

6,000.00 6,000.00 6,000.00

3,250.00 550.00

656.80 750.00 750.00

3,000.00 3,250.00 3,500.00

983.71 1,000.00 1,000.00

15,445.41- 15,000.00- 15,000.00-

12,500.00 12,500.00 12,500.00

3,500.00 3,500.00 3,500.00

12,500.00 12,500.00 12,500.00

19,000.00 20,000.00 21,000.00

1,211.82 550.00 550.00

6.00

-

5,044.01 2,500.00 2,500.00

237,754.22 234,600.00 235,550.00

5,000.00 5,000.00 5,000.00

250.00 250.00 250.00

55,000.00 55,000.00 55,000.00

60,250.00 60,250.00 60,250.00

17,500.00 17,500.00 17,500.00

15,000.00 15,000.00 15,000.00

3,766.09 5,000.00 5,000.00

1,500.00 1,500.00 1,500.00

3,000.00 3,000.00 3,000.00

40,766.09 42,000.00 42,000.00

-

Page 36: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

1,362,721.59 1,369,460.00 1,378,910.00

Page 37: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Comments

Early Retirement Costs

£2,500 new signs & general sprucing up

Mighty Oak in 2018/19

Page 38: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

£186,750=Curriculum Costs

£2,500 new Promotional Materials

£5,000 New Displays etc

Page 39: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £
Page 40: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

20,000.00

25,000.00

22,500.00

67,500.00

3,000.00

111,000.00

7,500.00

4,250.00

9,000.00

6,500.00

31,500.00

34,000.00

25,000.00

28,708.00

25,005.00

2,000.00

3,000.00

1,250.00

500.00

8,500.00

12,000.00

5,500.00

2,500.00

4,312.00

325,025.00

2,250.00

4,500.00

30,000.00

15,000.00

18,000.00

15,000.00

32,500.00

20,000.00

130,000.00

Page 41: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

15,000.00

9,950.00

15,000.00

3,000.00

6,500.00

5,500.00

10,000.00

10,000.00

25,000.00

30,000.00

245,000.00

4,000.00

646,200.00

170,000.00

2,000.00

1,000.00

250.00

2,500.00

6,000.00

3,250.00

750.00

3,000.00

1,250.00

7,500.00-

12,500.00

3,500.00

12,500.00

19,000.00

3,050.00

7,500.00

240,550.00

5,000.00

250.00

55,000.00

60,250.00

17,500.00

15,000.00

5,000.00

1,500.00

3,000.00

42,000.00

1,500.00

Page 42: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

1,383,025.00

Page 43: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Wallington County Grammar School

Teachers Salary Projections Financial Year 2018-2019

FTE

NAME BASIC TLR FTE Base TLR Total

SLT

Jamie Bean (L28 - L34) L28 1.00 81,182.82 0.00 81,182.82

Duvessa Owen (L18 - L22) L22 1.00 70,521.78 0.00 70,521.78

Simon Waters (L18 - L22) L20 1.00 67,307.76 0.00 67,307.76

David Jones (L13 - L17) L17 1.00 62,745.30 0.00 62,745.30

Alasdair Robertson (L13 - L17) L14 1.00 58,517.40 0.00 58,517.40

Kelvin Meek (L8 - L12) L12 1.00 55,861.32 0.00 55,861.32

Gemma Farlow (L8 - L12) L11 1.00 54,668.94 0.00 54,668.94

Jamie Gallagher (L8 - L12) L9 1.00 52,111.80 0.00 52,111.80

Art & Design

Laura Musselbrook U3 2c 0.80 43,347.96 6,645.30 39,994.61

Jodie James M2 1.00 28,881.30 0.00 28,881.30

DT

Steve Weston U3 1b 1.00 43,347.96 9,663.48 53,011.44

Sally Smart U2 i 1.00 41,800.62 0.00 41,800.62

Economics & Gov/Pol

James Dicker U1 ii 2c 1.00 40,309.38 6,645.30 46,954.68

Rebecca Brownsing M4 1.00 32,567.58 0.00 32,567.58

ANO M2 1.00 28,881.30 0.00 28,881.30

English

Catherine Curtis U2 ii 1b 1.00 41,800.62 10,413.48 52,214.10

Louise King U2 ii 2c 1.00 41,800.62 6,645.30 48,445.92

Lizzie Ball U2 i 2c 1.00 41,800.62 6,645.30 48,445.92

Michael McLauchlan M3 2a 1.00 30,668.34 2,720.34 33,388.68

Anna Weddell U1 i 2a 1.00 40,309.38 2,720.34 43,029.72

Nathan Rhodes-Brandon M3 1.00 30,668.34 0.00 30,668.34

Marina French M3 1.00 30,668.34 0.00 30,668.34

Food Technology

Dhrissie Nunes U2 i 2a 1.00 41,800.62 2,720.34 44,520.96

Wellbeing

Kat Turner U1 ii 3a 1.00 40,309.38 2,122.62 42,432.00

Geography

Natasha Evans U1 ii 2b 1.00 40,309.38 6,645.30 46,954.68

Julie Dimond U1 ii 2b 1.00 40,309.38 4,532.88 44,842.26

Sarah Mills U2 i 2b 0.70 41,800.62 4,532.88 32,433.45

Page 44: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

History/Classics

Tom Davies U2 ii 2c 1.00 41,800.62 6,645.30 48,445.92

Ben Greenly (LP1 - LP5) LP5 1.00 47,513.64 0.00 47,513.64

Computer Science

Jack Barwick M6 2a 1.00 38,397.90 7,720.34 46,118.24

Mathematics

Gill Bird (L13 - L17) U3 1c 1.00 43,347.96 11,580.06 54,928.02

ANO M6 1.00 38,397.90 38,397.90

ANO M6 2a 1.00 38,397.90 2,720.34 41,118.24

Jean Luc Lescault U3 1.00 43,347.96 0.00 43,347.96

Ravinder Bhandari U2 ii 1.00 41,800.62 0.00 41,800.62

Daniel Singarajah M2 1.00 28,881.30 0.00 28,881.30

Anne Pushpanathan M5 2a 1.00 35,329.74 2,720.34 38,050.08

Ioana Boulescu U1i 1.00 40,309.38 0.00 40,309.38

Modern Foreign Languages

Antonella Gabriele U3 1a 1.00 43,347.96 7,850.94 51,198.90

Claudie Mortreuil U2 ii 1.00 41,800.62 0.00 41,800.62

Audrey Paradis (Maternity) U2 ii 2c 1.00 41,800.62 6,645.30 48,445.92

Andrea Colombo U2 i 0.80 41,800.62 0.00 33,440.50

Music

Catherine Williams U1 ii 2b 0.40 40,309.38 4,532.88 19,750.06

Johanna Martin M6 2b 0.80 38,397.90 4,532.88 34,344.62

Anthony John M6 0.80 38,397.90 0.00 30,718.32

PE/Games

David Johnson U3 1b 1.00 43,347.96 9,663.48 53,011.44

Tom Collins U2 ii 2C 1.00 41,800.62 6,645.30 48,445.92

Ariez Mehta M5 2a 1.00 35,329.74 2,720.34 38,050.08

Nigel Legg UNQ6 2a 0.52 30,010.44 2,720.34 18,449.13

RS & Philosophy

Liz Jennings U3 2c 1.00 43,347.96 7,645.30 50,993.26

Mark Young U3 2c 1.00 43,347.96 6,645.30 49,993.26

Biology

Sadaf Khan U1 i 1.00 40,309.38 0.00 40,309.38

Shamee Tanna U3 0.60 43,347.96 0.00 26,008.78

Emma Burgess U3 0.60 43,347.96 0.00 26,008.78

Chemistry

Farhaan Hasan M5 2c 1.00 35,329.74 6,645.30 41,975.04

Joe Moran M6 0.60 38,397.90 0.00 23,038.74

Rachel Kershaw U1 ii 2c 1.00 40,309.38 6,645.30 46,954.68

Seong M1 1.00 27,195.24 1,686.06 28,881.30

Physics

Page 45: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

John Croft U2 ii 2c 1.00 41,800.62 6,645.30 48,445.92

Peter Quantrel U1 ii 1.00 40,309.38 0.00 40,309.38

Elizabeth Billy-Pedro M6 1.00 38,397.90 0.00 38,397.90

Toby M2 1.00 28,881.30 0.00 28,881.30

Teaching Assistants

ANO 0.15 3,917.18

Marie-Pierre Verrills 0.17 5,074.47

Goran Maric 0.37 13,882.50

Sports Allowances 4,617.50

Duties 8,812.25

59.32

Page 46: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Sep Oct Nov Dec Jan Feb Mar Apr

6,765.24 6,765.24 6,765.24 6,765.24 6,765.24 6,765.24 6,765.24 6,765.24

5,876.82 5,876.82 5,876.82 5,876.82 5,876.82 5,876.82 5,876.82 5,876.82

5,608.98 5,608.98 5,608.98 5,608.98 5,608.98 5,608.98 5,608.98 5,608.98

5,228.78 5,228.78 5,228.78 5,228.78 5,228.78 5,228.78 5,228.78 5,228.78

4,876.45 4,876.45 4,876.45 4,876.45 4,876.45 4,876.45 4,876.45 4,876.45

4,655.11 4,655.11 4,655.11 4,655.11 4,655.11 4,655.11 4,655.11 4,655.11

4,555.75 4,555.75 4,555.75 4,555.75 4,555.75 4,555.75 4,555.75 4,555.75

4,342.65 4,342.65 4,342.65 4,342.65 4,342.65 4,342.65 4,342.65 4,342.65

3,332.88 3,332.88 3,332.88 3,332.88 3,332.88 3,332.88 3,332.88 3,332.88

2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78

4,417.62 4,417.62 4,417.62 4,417.62 4,417.62 4,417.62 4,417.62 4,417.62

3,483.39 3,483.39 3,483.39 3,483.39 3,483.39 3,483.39 3,483.39 3,483.39

3,912.89 3,912.89 3,912.89 3,912.89 3,912.89 3,912.89 3,912.89 3,912.89

2,713.97 2,713.97 2,713.97 2,713.97 2,713.97 2,713.97 2,713.97 2,713.97

2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78

4,351.18 4,351.18 4,351.18 4,351.18 4,351.18 4,351.18 4,351.18 4,351.18

4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16

4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16

2,782.39 2,782.39 2,782.39 2,782.39 2,782.39 2,782.39 2,782.39 2,782.39

3,585.81 3,585.81 3,585.81 3,585.81 3,585.81 3,585.81 3,585.81 3,585.81

2,555.70 2,555.70 2,555.70 2,555.70 2,555.70 2,555.70 2,555.70 2,555.70

2,555.70 2,555.70 2,555.70 2,555.70 2,555.70 2,555.70 2,555.70 2,555.70

3,710.08 3,710.08 3,710.08 3,710.08 3,710.08 3,710.08 3,710.08 3,710.08

3,536.00 3,536.00 3,536.00 3,536.00 3,536.00 3,536.00 3,536.00 3,536.00

2,269.54 930.37 45.11 56.39 45.11 45.11 1,979.01 3,912.89

3,736.86 3,736.86 3,736.86 3,736.86 3,736.86 3,736.86 3,736.86 3,736.86

2,702.79 2,702.79 2,702.79 2,702.79 2,702.79 2,702.79 2,702.79

Page 47: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16

3,959.47 3,959.47 3,959.47 3,959.47 3,959.47 3,959.47 3,959.47 3,959.47

3,843.19 3,843.19 3,843.19 3,843.19 3,843.19 3,843.19 3,843.19 3,843.19

4,577.34 4,577.34 4,577.34 4,577.34 4,577.34 4,577.34 4,577.34 4,577.34

3,199.83 3,199.83 3,199.83 3,199.83 3,199.83 3,199.83 3,199.83 3,199.83

3,426.52 3,426.52 3,426.52 3,426.52 3,426.52 3,426.52 3,426.52 3,426.52

3,612.33 3,612.33 3,612.33 3,612.33 3,612.33 3,612.33 3,612.33 3,612.33

3,483.39 3,483.39 3,483.39 3,483.39 3,483.39 3,483.39 3,483.39 3,483.39

2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78

3,170.84 3,170.84 3,170.84 3,170.84 3,170.84 3,170.84 3,170.84 3,170.84

3,359.12 3,359.12 3,359.12 3,359.12 3,359.12 3,359.12 3,359.12 3,359.12

4,266.58 4,266.58 4,266.58 4,266.58 4,266.58 4,266.58 4,266.58 4,266.58

3,483.39 3,483.39 3,483.39 3,483.39 3,483.39 3,483.39 3,483.39 3,483.39

4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16

2,786.71 2,786.71 2,786.71 2,786.71 2,786.71 2,786.71 2,786.71 2,786.71

1,645.84 1,645.84 1,645.84 1,645.84 1,645.84 1,645.84 1,645.84 1,645.84

219.36 792.92 1,708.09 1,366.47 375.45 45.11 56.39 45.11

2,559.86 2,559.86 2,559.86 2,559.86 2,559.86 2,559.86 2,559.86 2,559.86

4,417.62 4,417.62 4,417.62 4,417.62 4,417.62 4,417.62 4,417.62 4,417.62

4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16

3,170.84 3,170.84 3,170.84 3,170.84 3,170.84 3,170.84 3,170.84 3,170.84

1,537.43 1,537.43 1,537.43 1,537.43 1,537.43 1,537.43 1,537.43 1,537.43

4,249.44 4,249.44 4,249.44 4,249.44 4,249.44 4,249.44 4,249.44 4,249.44

4,166.11 4,166.11 4,166.11 4,166.11 4,166.11 4,166.11 4,166.11 4,166.11

3,359.12 3,359.12 3,359.12 3,359.12 3,359.12 3,359.12 3,359.12 3,359.12

2,167.40 2,167.40 2,167.40 2,167.40 2,167.40 2,167.40 2,167.40 2,167.40

2,167.40 2,167.40 2,167.40 2,167.40 2,167.40 2,167.40 2,167.40 2,167.40

3,497.92 3,497.92 3,497.92 3,497.92 3,497.92 3,497.92 3,497.92 3,497.92

1,919.90 1,919.90 1,919.90 1,919.90 1,919.90 1,919.90 1,919.90 1,919.90

3,912.89 3,912.89 3,912.89 3,912.89 3,912.89 3,912.89 3,912.89 3,912.89

2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78

Page 48: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16 4,037.16

3,359.12 3,359.12 3,359.12 3,359.12 3,359.12 3,359.12 3,359.12 3,359.12

3,199.83 3,199.83 3,199.83 3,199.83 3,199.83 3,199.83 3,199.83 3,199.83

2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78 2,406.78

559.60 559.60 559.60 559.60 559.60 559.60 559.60

724.92 724.92 724.92 724.92 724.92 724.92 724.92

1,156.88 1,156.88 1,156.88 1,156.88 1,156.88 1,156.88 1,156.88 1,156.88

2,117.50 1,250.00

860.00 760.00 1,020.00 540.00 920.00 720.00 1,080.00 440.00

218,548.96 218,967.87 219,257.78 220,564.95 217,825.15 217,294.81 220,849.98 218,179.80

Page 49: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

May Jun Jul Aug Annual

6,765.24 6,765.24 6,765.24 6,765.24 81,182.82

5,876.82 5,876.82 5,876.82 5,876.82 70,521.78

5,608.98 5,608.98 5,608.98 5,608.98 67,307.76

5,228.78 5,228.78 5,228.78 5,228.78 62,745.30

4,876.45 4,876.45 4,876.45 4,876.45 58,517.40

4,655.11 4,655.11 4,655.11 4,655.11 55,861.32

4,555.75 4,555.75 4,555.75 4,555.75 54,668.94

4,342.65 4,342.65 4,342.65 4,342.65 52,111.80

3,332.88 3,332.88 3,332.88 3,332.88 39,994.61

2,406.78 2,406.78 2,406.78 2,406.78 28,881.30

4,417.62 4,417.62 4,417.62 4,417.62 53,011.44

3,483.39 3,483.39 3,483.39 3,483.39 41,800.62

3,912.89 3,912.89 3,912.89 3,912.89 46,954.68

2,713.97 2,713.97 2,713.97 2,713.97 32,567.58

2,406.78 2,406.78 2,406.78 2,406.78 28,881.30

4,351.18 4,351.18 4,351.18 4,351.18 52,214.10

4,037.16 4,037.16 4,037.16 4,037.16 48,445.92

4,037.16 4,037.16 4,037.16 4,037.16 48,445.92

2,782.39 2,782.39 2,782.39 2,782.39 33,388.68

3,585.81 3,585.81 3,585.81 3,585.81 43,029.72

2,555.70 2,555.70 2,555.70 2,555.70 30,668.34

2,555.70 2,555.70 2,555.70 2,555.70 30,668.34

3,710.08 3,710.08 3,710.08 3,710.08 44,520.96

3,536.00 3,536.00 3,536.00 3,536.00 42,432.00

3,912.89 3,912.89 3,912.89 3,912.89 24,935.09

3,736.86 3,736.86 3,736.86 3,736.86 44,842.26

18,919.51

Page 50: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

4,037.16 4,037.16 4,037.16 4,037.16 48,445.92

3,959.47 3,959.47 3,959.47 3,959.47 47,513.64

3,843.19 3,843.19 3,843.19 3,843.19 46,118.24

4,577.34 4,577.34 4,577.34 4,577.34 54,928.02

3,199.83 3,199.83 3,199.83 3,199.83 38,397.90

3,426.52 3,426.52 3,426.52 3,426.52 41,118.24

3,612.33 3,612.33 3,612.33 3,612.33 43,347.96

3,483.39 3,483.39 3,483.39 3,483.39 41,800.62

2,406.78 2,406.78 2,406.78 2,406.78 28,881.30

3,170.84 3,170.84 3,170.84 3,170.84 38,050.08

3,359.12 3,359.12 3,359.12 3,359.12 40,309.38

4,266.58 4,266.58 4,266.58 4,266.58 51,198.90

3,483.39 3,483.39 3,483.39 3,483.39 41,800.62

4,037.16 4,037.16 4,037.16 4,037.16 48,445.92

2,786.71 2,786.71 2,786.71 2,786.71 33,440.50

1,645.84 1,645.84 1,645.84 1,645.84 19,750.06

2,862.05 2,862.05 10,333.02

2,559.86 2,559.86 2,559.86 2,559.86 30,718.32

4,417.62 4,417.62 4,417.62 4,417.62 53,011.44

4,037.16 4,037.16 4,037.16 4,037.16 48,445.92

3,170.84 3,170.84 3,170.84 3,170.84 38,050.08

1,537.43 1,537.43 1,537.43 1,537.43 18,449.13

4,249.44 4,249.44 4,249.44 4,249.44 50,993.26

4,166.11 4,166.11 4,166.11 4,166.11 49,993.26

3,359.12 3,359.12 3,359.12 3,359.12 40,309.38

2,167.40 2,167.40 2,167.40 2,167.40 26,008.78

2,167.40 2,167.40 2,167.40 2,167.40 26,008.78

3,497.92 3,497.92 3,497.92 3,497.92 41,975.04

1,919.90 1,919.90 1,919.90 1,919.90 23,038.74

3,912.89 3,912.89 3,912.89 3,912.89 46,954.68

2,406.78 2,406.78 2,406.78 2,406.78 28,881.30

Page 51: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

4,037.16 4,037.16 4,037.16 4,037.16 48,445.92

3,359.12 3,359.12 3,359.12 3,359.12 40,309.38

3,199.83 3,199.83 3,199.83 3,199.83 38,397.90

2,406.78 2,406.78 2,406.78 2,406.78 28,881.30

3,917.18

5,074.47

1,156.88 1,156.88 1,156.88 1,156.88 13,882.50

1,250.00 4,617.50

920.00 960.00 592.25 0.00 8,812.25

217,330.16 217,370.16 221,114.47 219,272.22 2,626,576.31

674,194.80

3,300,771.11

4,245,118.68

35,126.00

10,000.00

4,290,244.68

Error

Page 52: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

8,245.64

Comments NI Calc Pen Calc

10,065.33 14,062.22

8,594.11 12,215.55

8,150.57 11,658.83

7,520.95 10,868.53

6,937.50 10,136.19

6,570.96 9,676.11

6,406.42 9,469.57

6,053.53 9,026.63

4,381.36 6,927.73

2,847.72 5,002.72

6,177.68 9,182.46

4,630.59 7,240.56

5,341.85 8,133.33

3,356.43 5,641.25

2,847.72 5,002.72

£750 Allowance for T&L 6,067.65 9,044.35

5,547.64 8,391.64

5,547.64 8,391.64

3,469.74 5,783.48

4,800.20 7,453.46

3,094.33 5,312.27

3,094.33 5,312.27

5,005.99 7,711.77

Full TLR 4,717.72 7,349.93

Includes Recruitment Bonus to equiv 2c 2,303.14 4,504.50

TLR for D of E 5,050.33 7,767.43

1,472.99 3,117.94

Page 53: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

5,547.64 8,391.64

5,418.98 8,230.15

£5000 Retention Bonus 5,226.42 7,988.45

6,442.17 9,514.45

4,161.01 6,651.16

4,536.42 7,122.36

4,844.12 7,508.59

4,630.59 7,240.56

2,847.72 5,002.72

4,113.01 6,590.91

4,424.80 6,982.26

5,927.55 8,868.50

4,630.59 7,240.56

5,547.64 8,391.64

3,476.89 5,792.45

TLR paid at 80% whilst JMA away 1,587.61 3,421.04

288.06 1,819.42

3,101.23 5,320.92

6,177.68 9,182.46

5,547.64 8,391.64

4,113.01 6,590.91

1,408.08 N/A

Allowance for E Safety 5,899.17 8,832.88

5,761.17 8,659.67

4,424.80 6,982.26

2,451.31 4,505.15

2,451.31 4,505.15

4,654.66 n/a

2,041.45 3,990.69

5,341.85 8,133.33

2,847.72 5,002.72

Page 54: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

5,547.64 8,391.64

4,424.80 6,982.26

4,161.01 6,651.16

2,847.72 5,002.72

656.86

n/a

777.89 2,404.68

637.22 786.21

1,216.09 1,511.09

289,539.09 443,626.38

11.0% 16.9%

NTS 48,513.03 162,669.07

Total Staff 338,052.12 606,295.45

Other Staff Costs

Agency

Grand Total

Check

Page 55: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Wallington County Grammar School

Teachers Salary Projections Financial Year 2018-2019

FTE

NAME BASIC TLR FTE Base TLR Total

SLT

Jamie Bean (L28 - L34) L29 1.00 84,772.83 0.00 84,772.83

Duvessa Owen (L18 - L22) L22 1.00 71,932.22 0.00 71,932.22

Simon Waters (L18 - L22) L21 1.00 70,273.82 0.00 70,273.82

David Jones (L13 - L17) L17 1.00 64,000.21 0.00 64,000.21

Alasdair Robertson (L13 - L17) L15 1.00 61,092.29 0.00 61,092.29

Kelvin Meek (L8 - L12) L12 1.00 56,978.55 0.00 56,978.55

Gemma Farlow (L8 - L12) L12 1.00 56,978.55 0.00 56,978.55

Jamie Gallagher (L8 - L12) L10 1.00 54,438.93 0.00 54,438.93

Art & Design

Laura Musselbrook U3 2c 0.80 44,214.92 6,778.21 40,794.50

Jodie James M3 1.00 31,281.71 0.00 31,281.71

DT

Steve Weston U3 1b 1.00 44,214.92 9,856.75 54,071.67

Sally Smart U2 ii 1.00 42,636.63 0.00 42,636.63

Economics & Gov/POL

James Dicker U2 i 2c 1.00 42,636.63 6,778.21 49,414.84

Rebecca Brownsing M5 1.00 36,036.33 0.00 36,036.33

ANO M3 1.00 31,281.71 0.00 31,281.71

English

Catherine Curtis U3 1b 1.00 44,214.92 10,606.75 54,821.67

Louise King U3 2c 1.00 44,214.92 6,778.21 50,993.13

Lizzie Ball U2 ii 2c 1.00 42,636.63 6,778.21 49,414.84

Michael McLauchlan M4 2a 1.00 33,218.93 2,774.75 35,993.68

Anna Weddell U1 ii 2a 1.00 41,115.57 2,774.75 43,890.31

Nathan Rhodes-Brandon M4 1.00 33,218.93 0.00 33,218.93

Marina French M4 1.00 33,218.93 0.00 33,218.93

Food Technology

Dhrissie Nunes U2 ii 2a 1.00 42,636.63 2,774.75 45,411.38

Wellbeing

Kat Turner U2 i 3a 1.00 42,636.63 2,165.07 44,801.70

Geography

Natasha Evan U2 i 2b 1.00 42,636.63 4,623.54 47,260.17

Julie Dimond U2 i 2b 1.00 42,636.63 4,623.54 47,260.17

History/Classics

Page 56: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Tom Davies U3 2c 1.00 44,214.92 6,778.21 50,993.13

Ben Greenly (LP1 - LP5) LP5 1.00 48,463.91 0.00 48,463.91

Computer Science

Jack Barwick U1 i 2a 1.00 41,115.57 7,774.75 48,890.31

Mathematics

Gill Bird (L13 - L17) U3 1c 1.00 44,214.92 11,811.66 56,026.58

ANO M6 1.00 39,165.86 39,165.86

ANO M6 2a 1.00 39,165.86 2,774.75 41,940.60

Jean Luc Lescault U3 1.00 44,214.92 0.00 44,214.92

Ravinder Bhandari U3 1.00 44,214.92 0.00 44,214.92

Daniel Singarajah M3 1.00 31,281.71 0.00 31,281.71

Anne Pushpanathan M6 2a 1.00 39,165.86 2,774.75 41,940.60

Ioana Boulescu U1 ii 1.00 41,115.57 0.00 41,115.57

Modern Foreign Languages

Antonella Gabriele U3 1a 1.00 44,214.92 8,007.96 52,222.88

Claudie Mortreuil U3 1.00 44,214.92 0.00 44,214.92

Audrey Paradis (Maternity) U3 2c 1.00 44,214.92 6,778.21 50,993.13

Andrea Colombo U2 ii 0.80 42,636.63 0.00 34,109.31

Music

Catherine Williams U2 i 0.40 42,636.63 0.00 17,054.65

Johanna Martin U1 i 2b 0.80 41,115.57 4,623.54 36,591.28

PE/Games

David Johnson U3 1b 1.00 44,214.92 9,856.75 54,071.67

Tom Collins U3 2c 1.00 44,214.92 6,778.21 50,993.13

Ariez Mehta M6 2a 1.00 39,165.86 2,774.75 41,940.60

Nigel Legg UNQ6 2a 0.52 30,610.65 2,774.75 18,818.11

RS & Philosophy

Liz Jennings U3 2c 1.00 44,214.92 7,778.21 51,993.13

Mark Young U3 2c 1.00 44,214.92 6,778.21 50,993.13

Biology

Sadaf Khan U1 ii 1.00 41,115.57 0.00 41,115.57

Shamee Tanna U3 0.60 44,214.92 0.00 26,528.95

Emma Burgess U3 0.60 44,214.92 0.00 26,528.95

Chemistry

Farhaan Hasan M6 2c 1.00 39,165.86 6,778.21 45,944.06

Joe Moran M6 0.60 39,165.86 0.00 23,499.51

Rachel Kershaw U2 i 2c 1.00 42,636.63 6,778.21 49,414.84

Seong M2 1.00 29,458.93 0.00 29,458.93

Physics

John Croft U3 2c 1.00 44,214.92 6,778.21 50,993.13

Peter Quantrel U2 i 1.00 42,636.63 0.00 42,636.63

Page 57: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Elizabeth Billy-Pedro U1 i 1.00 41,115.57 0.00 41,115.57

Toby M3 1.00 31,281.71 0.00 31,281.71

Teaching Assistants

ANO 0.15 3,956.36

Marie-Pierre Verrills 0.17 5,125.21

Goran Maric 0.37 14,021.33

Sports Allowances 4,478.67

Duties 8,900.37

57.82

Page 58: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Sep Oct Nov Dec Jan Feb Mar Apr

7,064.40 7,064.40 7,064.40 7,064.40 7,064.40 7,064.40 7,064.40 7,064.40

5,994.35 5,994.35 5,994.35 5,994.35 5,994.35 5,994.35 5,994.35 5,994.35

5,856.15 5,856.15 5,856.15 5,856.15 5,856.15 5,856.15 5,856.15 5,856.15

5,333.35 5,333.35 5,333.35 5,333.35 5,333.35 5,333.35 5,333.35 5,333.35

5,091.02 5,091.02 5,091.02 5,091.02 5,091.02 5,091.02 5,091.02 5,091.02

4,748.21 4,748.21 4,748.21 4,748.21 4,748.21 4,748.21 4,748.21 4,748.21

4,748.21 4,748.21 4,748.21 4,748.21 4,748.21 4,748.21 4,748.21 4,748.21

4,536.58 4,536.58 4,536.58 4,536.58 4,536.58 4,536.58 4,536.58 4,536.58

3,399.54 3,399.54 3,399.54 3,399.54 3,399.54 3,399.54 3,399.54 3,399.54

2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81

4,505.97 4,505.97 4,505.97 4,505.97 4,505.97 4,505.97 4,505.97 4,505.97

3,553.05 3,553.05 3,553.05 3,553.05 3,553.05 3,553.05 3,553.05 3,553.05

4,117.90 4,117.90 4,117.90 4,117.90 4,117.90 4,117.90 4,117.90 4,117.90

3,003.03 3,003.03 3,003.03 3,003.03 3,003.03 3,003.03 3,003.03 3,003.03

2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81

4,568.47 4,568.47 4,568.47 4,568.47 4,568.47 4,568.47 4,568.47 4,568.47

4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43

4,117.90 4,117.90 4,117.90 4,117.90 4,117.90 4,117.90 4,117.90 4,117.90

2,999.47 2,999.47 2,999.47 2,999.47 2,999.47 2,999.47 2,999.47 2,999.47

3,657.53 3,657.53 3,657.53 3,657.53 3,657.53 3,657.53 3,657.53 3,657.53

2,768.24 2,768.24 2,768.24 2,768.24 2,768.24 2,768.24 2,768.24 2,768.24

2,768.24 2,768.24 2,768.24 2,768.24 2,768.24 2,768.24 2,768.24 2,768.24

3,784.28 3,784.28 3,784.28 3,784.28 3,784.28 3,784.28 3,784.28 3,784.28

3,733.48 3,733.48 3,733.48 3,733.48 3,733.48 3,733.48 3,733.48 3,733.48

3,938.35 3,938.35 3,938.35 3,938.35 3,938.35 3,938.35 3,938.35 3,938.35

3,938.35 3,938.35 3,938.35 3,938.35 3,938.35 3,938.35 3,938.35 3,938.35

Page 59: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43

4,038.66 4,038.66 4,038.66 4,038.66 4,038.66 4,038.66 4,038.66 4,038.66

4,074.19 4,074.19 4,074.19 4,074.19 4,074.19 4,074.19 4,074.19 4,074.19

4,668.88 4,668.88 4,668.88 4,668.88 4,668.88 4,668.88 4,668.88 4,668.88

3,263.82 3,263.82 3,263.82 3,263.82 3,263.82 3,263.82 3,263.82 3,263.82

3,495.05 3,495.05 3,495.05 3,495.05 3,495.05 3,495.05 3,495.05 3,495.05

3,684.58 3,684.58 3,684.58 3,684.58 3,684.58 3,684.58 3,684.58 3,684.58

3,684.58 3,684.58 3,684.58 3,684.58 3,684.58 3,684.58 3,684.58 3,684.58

2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81

3,495.05 3,495.05 3,495.05 3,495.05 3,495.05 3,495.05 3,495.05 3,495.05

3,426.30 3,426.30 3,426.30 3,426.30 3,426.30 3,426.30 3,426.30 3,426.30

4,351.91 4,351.91 4,351.91 4,351.91 4,351.91 4,351.91 4,351.91 4,351.91

3,684.58 3,684.58 3,684.58 3,684.58 3,684.58 3,684.58 3,684.58 3,684.58

4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43

2,842.44 2,842.44 2,842.44 2,842.44 2,842.44 2,842.44 2,842.44 2,842.44

1,421.22 1,421.22 1,421.22 1,421.22 1,421.22 1,421.22 1,421.22 1,421.22

3,049.27 3,049.27 3,049.27 3,049.27 3,049.27 3,049.27 3,049.27 3,049.27

4,505.97 4,505.97 4,505.97 4,505.97 4,505.97 4,505.97 4,505.97 4,505.97

4,749.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,499.43 4,249.43

3,495.05 3,495.05 3,495.05 3,495.05 3,495.05 3,495.05 3,495.05 3,495.05

1,568.18 1,568.18 1,568.18 1,568.18 1,568.18 1,568.18 1,568.18 1,568.18

4,332.76 4,332.76 4,332.76 4,332.76 4,332.76 4,332.76 4,332.76 4,332.76

4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43

3,426.30 3,426.30 3,426.30 3,426.30 3,426.30 3,426.30 3,426.30 3,426.30

2,210.75 2,210.75 2,210.75 2,210.75 2,210.75 2,210.75 2,210.75 2,210.75

2,210.75 2,210.75 2,210.75 2,210.75 2,210.75 2,210.75 2,210.75 2,210.75

3,828.67 3,828.67 3,828.67 3,828.67 3,828.67 3,828.67 3,828.67 3,828.67

1,958.29 1,958.29 1,958.29 1,958.29 1,958.29 1,958.29 1,958.29 1,958.29

4,117.90 4,117.90 4,117.90 4,117.90 4,117.90 4,117.90 4,117.90 4,117.90

2,454.91 2,454.91 2,454.91 2,454.91 2,454.91 2,454.91 2,454.91 2,454.91

4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43 4,249.43

3,553.05 3,553.05 3,553.05 3,553.05 3,553.05 3,553.05 3,553.05 3,553.05

Page 60: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

3,426.30 3,426.30 3,426.30 3,426.30 3,426.30 3,426.30 3,426.30 3,426.30

2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81 2,606.81

565.19 565.19 565.19 565.19 565.19 565.19 565.19

732.17 732.17 732.17 732.17 732.17 732.17 732.17

1,168.44 1,168.44 1,168.44 1,168.44 1,168.44 1,168.44 1,168.44 1,168.44

1,978.67 1,250.00

860.00 760.00 1,020.00 540.00 920.00 720.00 1,080.00 440.00

226,947.74 227,645.11 227,905.11 229,403.78 227,805.11 227,605.11 229,465.11 227,325.11

Page 61: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

May Jun Jul Aug Annual

7,064.40 7,064.40 7,064.40 7,064.40 84,772.83

5,994.35 5,994.35 5,994.35 5,994.35 71,932.22

5,856.15 5,856.15 5,856.15 5,856.15 70,273.82

5,333.35 5,333.35 5,333.35 5,333.35 64,000.21

5,091.02 5,091.02 5,091.02 5,091.02 61,092.29

4,748.21 4,748.21 4,748.21 4,748.21 56,978.55

4,748.21 4,748.21 4,748.21 4,748.21 56,978.55

4,536.58 4,536.58 4,536.58 4,536.58 54,438.93

3,399.54 3,399.54 3,399.54 3,399.54 40,794.50

2,606.81 2,606.81 2,606.81 2,606.81 31,281.71

4,505.97 4,505.97 4,505.97 4,505.97 54,071.67

3,553.05 3,553.05 3,553.05 3,553.05 42,636.63

4,117.90 4,117.90 4,117.90 4,117.90 49,414.84

3,003.03 3,003.03 3,003.03 3,003.03 36,036.33

2,606.81 2,606.81 2,606.81 2,606.81 31,281.71

4,568.47 4,568.47 4,568.47 4,568.47 54,821.67

4,249.43 4,249.43 4,249.43 4,249.43 50,993.13

4,117.90 4,117.90 4,117.90 4,117.90 49,414.84

2,999.47 2,999.47 2,999.47 2,999.47 35,993.68

3,657.53 3,657.53 3,657.53 3,657.53 43,890.31

2,768.24 2,768.24 2,768.24 2,768.24 33,218.93

2,768.24 2,768.24 2,768.24 2,768.24 33,218.93

3,784.28 3,784.28 3,784.28 3,784.28 45,411.38

3,733.48 3,733.48 3,733.48 3,733.48 44,801.70

3,938.35 3,938.35 3,938.35 3,938.35 47,260.17

3,938.35 3,938.35 3,938.35 3,938.35 47,260.17

Page 62: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

4,249.43 4,249.43 4,249.43 4,249.43 50,993.13

4,038.66 4,038.66 4,038.66 4,038.66 48,463.91

4,074.19 4,074.19 4,074.19 4,074.19 48,890.31

4,668.88 4,668.88 4,668.88 4,668.88 56,026.58

3,263.82 3,263.82 3,263.82 3,263.82 39,165.86

3,495.05 3,495.05 3,495.05 3,495.05 41,940.60

3,684.58 3,684.58 3,684.58 3,684.58 44,214.92

3,684.58 3,684.58 3,684.58 3,684.58 44,214.92

2,606.81 2,606.81 2,606.81 2,606.81 31,281.71

3,495.05 3,495.05 3,495.05 3,495.05 41,940.60

3,426.30 3,426.30 3,426.30 3,426.30 41,115.57

4,351.91 4,351.91 4,351.91 4,351.91 52,222.88

3,684.58 3,684.58 3,684.58 3,684.58 44,214.92

4,249.43 4,249.43 4,249.43 4,249.43 50,993.13

2,842.44 2,842.44 2,842.44 2,842.44 34,109.31

1,421.22 1,421.22 1,421.22 1,421.22 17,054.65

3,049.27 3,049.27 3,049.27 3,049.27 36,591.28

4,505.97 4,505.97 4,505.97 4,505.97 54,071.67

4,249.43 4,249.43 4,499.43 4,249.43 51,993.13

3,495.05 3,495.05 3,495.05 3,495.05 41,940.60

1,568.18 1,568.18 1,568.18 1,568.18 18,818.11

4,332.76 4,332.76 4,332.76 4,332.76 51,993.13

4,249.43 4,249.43 4,249.43 4,249.43 50,993.13

3,426.30 3,426.30 3,426.30 3,426.30 41,115.57

2,210.75 2,210.75 2,210.75 2,210.75 26,528.95

2,210.75 2,210.75 2,210.75 2,210.75 26,528.95

3,828.67 3,828.67 3,828.67 3,828.67 45,944.06

1,958.29 1,958.29 1,958.29 1,958.29 23,499.51

4,117.90 4,117.90 4,117.90 4,117.90 49,414.84

2,454.91 2,454.91 2,454.91 2,454.91 29,458.93

4,249.43 4,249.43 4,249.43 4,249.43 50,993.13

3,553.05 3,553.05 3,553.05 3,553.05 42,636.63

Page 63: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

3,426.30 3,426.30 3,426.30 3,426.30 41,115.57

2,606.81 2,606.81 2,606.81 2,606.81 31,281.71

3,956.36

5,125.21

1,168.44 1,168.44 1,168.44 1,168.44 14,021.33

1,250.00 4,478.67

920.00 960.00 680.37 0.00 8,900.37

226,507.74 226,547.74 227,768.11 225,587.74 2,730,513.50

671,893.70

3,402,407.21

4,415,946.10

35,126.00

10,000.00

4,461,072.10

Error

Page 64: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

8,328.10

Comments NI Calc Pen Calc

10,549.37 15,682.97

8,777.37 13,307.46

8,548.51 13,000.66

7,682.75 11,840.04

7,281.46 11,302.07

6,713.76 10,541.03

6,713.76 10,541.03

6,363.30 10,071.20

4,480.36 7,546.98

3,167.60 5,787.12

6,312.61 10,003.26

4,734.58 7,887.78

5,669.97 9,141.75

3,823.74 6,666.72

3,167.60 5,787.12

£750 Allowance re T&L 6,416.11 10,142.01

5,887.77 9,433.73

5,669.97 9,141.75

3,817.85 6,658.83

4,907.59 8,119.71

3,434.94 6,145.50

3,434.94 6,145.50

5,117.49 8,401.11

Full TLR 5,033.36 8,288.32

Includes Recruitment Bonus to equiv 2c 5,372.63 8,743.13

TLR for D of E 5,372.63 8,743.13

Page 65: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

5,887.77 9,433.73

5,538.74 8,965.82

£5000 Retention Bonus 5,597.59 9,044.71

6,582.39 10,364.92

4,255.61 7,245.68

4,638.53 7,759.01

4,952.38 8,179.76

4,952.38 8,179.76

3,167.60 5,787.12

4,638.53 7,759.01

4,524.67 7,606.38

6,057.48 9,661.23

4,952.38 8,179.76

5,887.77 9,433.73

3,557.81 6,310.22

1,204.26 3,155.11

3,900.32 6,769.39

6,312.61 10,003.26

£1000 built in for Cricket etc 6,025.77 9,618.73

4,638.53 7,759.01

1,447.62 3,481.35

Allowance for E Safety 6,025.77 9,618.73

5,887.77 9,433.73

4,524.67 7,606.38

2,511.72 4,907.86

2,511.72 4,907.86

5,191.00 n/a

2,093.66 4,347.41

5,669.97 9,141.75

2,916.05 n/a

5,887.77 9,433.73

4,734.58 7,887.78

Page 66: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

4,524.67 7,606.38

3,167.60 5,787.12

545.98 731.93

n/a

785.67 2,593.95

618.06 828.55

1,228.25 1,646.57

305,997.67 490,247.28

11.2% 18.0%

NTS 49,469.22 167,824.73

Total Staff 355,466.88 658,072.01

Other Staff Costs

Agency

Grand Total

Check

Page 67: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Wallington County Grammar School

Non-Teaching Staff Salary Projections Financial Year 2018-2019

Spine Spine

Grade Range Act LLW Basic Allow TTO

Administration

Jo Johnson S6/SO1 26 - 31 31 31 30,107.34 38.00

Laura Gayle 7/8 29 - 34 30 30 29,241.36 38.00

Amanda Tutt S6/SO1 26 - 31 31 31 30,107.34 165.00 38.00

Rita Bharadia 4/5 18 - 25 25 25 25,000.20 38.00

Education Support

Daniel Cardenas PO2 35 - 38 38 38 35,991.72 38.00

Yasmin Noor Ahmed 5/6 22 - 28 27 27 26,539.38 165.00 38.00

Peggy Clode S6/SO1 26 - 31 31 31 30,107.34 38.00

Carole Brooks 5/6 22 - 28 31 31 30,107.34 165.00 38.00

Mandy Curtis 5/6 22 - 28 25 25 25,000.20 165.00 38.00

Irene Gambel 5/6 22 - 28 25 25 25,000.20 38.00

Lorraine Lenaghan S6/SO1 26 - 31 31 31 30,107.34 38.00

Maria Waters 5/6 22 - 28 27 27 26,539.38 165.00 38.00

Eugenie Bryan 4/5 18 - 25 23 23 23,577.30 38.00

Terry Round 4/5 18 - 25 25 25 25,000.20 165.00 38.00

Nicola Moyle 4/5 18 - 25 22 22 22,956.12 38.00

Paul Kiteley 4/5 18 - 25 19 19 21,009.96 38.00

Leila Herbal 4/5 18 - 25 19 19 21,009.96 38.00

Phil Nicholson 5/6 22 - 28 27 27 26,539.38 165.00 38.00

ANO 5/6 22 - 28 22 22 22,956.12 165.00 38.00

Angela Stratford 5/6 22 - 28 28 28 27,341.10 38.00

Annette Slade 5/6 22 - 28 25 25 25,000.20 38.00

Tracey Donald 4/5 18 - 25 21 21 22,423.68 165.00 38.00

Richard Poynter 5/6 22 - 28 25 25 25,000.20 165.00 38.00

Asma Farshori 4/5 18 - 25 23 23 23,577.30 38.00

Food Tech N/A N/A N/A N/A 10,000.00 38.00

Sports Tech N/A N/A N/A N/A 10,000.00 38.00

Premises

Derek Dougherty 4/5 18 - 25 25 25 25,000.20 38.00

Alan Etherington 4/5 18 - 25 25 25 25,000.20 38.00

ANO 1c/3 9 - 17 9 10 18,696.60 38.00

Ken Antwi 1c/3 9 - 17 11 11 18,724.14 38.00

Catering

Marion Barton 5/6 22 - 28 28 28 27,341.10 38.00

Page 68: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Diane Reeves 5/6 22 - 28 26 26 25,746.84 165.00 38.00

Jackie Dyduch 1A/2 5 - 13 13 13 18,763.92 38.00

Jan Skipp 1A/2 5 - 13 13 13 18,763.92 38.00

Debbie Branch 1A/2 5 - 13 13 13 18,763.92 38.00

Julia Morcombe 1A/2 5 - 13 8 10 18,696.60 38.00

Samantha Drew 1A/2 5 - 13 8 10 18,696.60 38.00

Tracey Donovan 1A/2 5 - 13 10 10 18,696.60 38.00

Sports Allowances

Duties

Overtime/Suppl/Admin

Invigilation

Educational Support Staff

Premises Staff

Admin Staff

Other Staff

Page 69: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

FTE

+ Wks Hols Contract Hours Total Sep Oct Nov

2.00 7.20 0.905 36.00 27,254.82 2,271.24 2,271.24 2,271.24

7.20 0.867 36.00 25,349.24 2,112.44 2,112.44 2,112.44

6.94 7.20 1.000 36.00 30,272.34 2,522.70 2,522.70 2,522.70

2.00 7.20 0.905 36.00 22,631.56 1,885.96 1,885.96 1,885.96

8,792.33 8,792.33 8,792.33

4.00 7.20 0.944 36.00 33,962.27 2,830.19 2,830.19 2,830.19

4.00 6.60 0.932 25.00 17,285.63 1,440.47 1,440.47 1,440.47

4.00 7.20 0.944 36.00 28,409.69 2,367.47 2,367.47 2,367.47

2.00 7.20 0.905 0.00 - 0.00 0.00 0.00

2.00 7.20 0.905 36.00 22,780.93 1,898.41 1,898.41 1,898.41

2.00 7.20 0.905 30.00 18,859.63 1,571.64 1,571.64 1,571.64

7.20 0.867 20.00 14,499.98 1,208.33 1,208.33 1,208.33

4.00 7.20 0.944 30.00 20,998.84 1,749.90 1,749.90 1,749.90

6.60 0.855 36.00 20,167.77 1,680.65 1,680.65 1,680.65

7.20 0.867 30.00 18,179.69 1,514.97 1,514.97 1,514.97

7.20 0.867 36.00 19,900.59 1,658.38 1,658.38 1,658.38

6.60 0.855 18.00 8,985.85 748.82 748.82 748.82

6.60 0.855 18.00 8,985.85 748.82 748.82 748.82

7.20 0.867 36.00 23,149.94 1,929.16 1,929.16 1,929.16

6.60 0.855 36.00 19,777.56 1,648.13 1,648.13 1,648.13

7.20 0.867 15.00 9,875.80 822.98 822.98 822.98

6.60 0.855 21.00 12,474.53 1,039.54 1,039.54 1,039.54

6.60 0.855 15.00 8,050.88 670.91 670.91 670.91

7.20 0.867 36.00 21,815.63 1,817.97 1,817.97 1,817.97

6.60 0.855 36.00 20,167.77 1,680.65 1,680.65 1,680.65

6.94 7.20 1.000 36.00 10,000.00 833.33 833.33 833.33

6.94 7.20 1.000 36.00 10,000.00 833.33 833.33 833.33

30,694.07 30,694.07 30,694.07

6.94 7.20 1.000 36.00 25,000.20 2,083.35 2,083.35 2,083.35

6.94 7.20 1.000 36.00 25,000.20 2,083.35 2,083.35

6.94 7.20 1.000 36.00 18,696.60 1,558.05 1,558.05 1,558.05

6.94 7.20 1.000 30.00 15,603.45 1,300.29 1,300.29 1,300.29

7,025.04 7,025.04 4,941.69

1.00 7.20 0.886 25.00 16,823.81 1,401.98 1,401.98 1,401.98

Page 70: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

7.20 0.867 36.00 22,462.89 1,871.91 1,871.91 1,871.91

7.20 0.867 35.00 15,814.54 1,317.88 1,317.88 1,317.88

7.20 0.867 25.00 11,296.10 941.34 941.34 941.34

7.20 0.867 20.00 9,036.88 753.07 753.07 753.07

6.60 0.855 15.00 6,663.70 555.31 555.31 555.31

6.60 0.855 15.00 6,663.70 555.31 555.31 555.31

7.20 0.867 20.00 9,004.46 750.37 750.37 750.37

8,147.17 8,147.17 8,147.17

210.00 240.00 315.00

1,000.00 1,000.00 1,000.00

100.00 500.00 500.00

55,968.61 56,398.61 54,390.26

Page 71: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Dec Jan Feb Mar Apr May Jun Jul

2,271.24 2,271.24 2,271.24 2,271.24 2,271.24 2,271.24 2,271.24 2,271.24

2,112.44 2,112.44 2,112.44 2,112.44 2,112.44 2,112.44 2,112.44 2,112.44

2,522.70 2,522.70 2,522.70 2,522.70 2,522.70 2,522.70 2,522.70 2,522.70

1,885.96 1,885.96 1,885.96 1,885.96 1,885.96 1,885.96 1,885.96 1,885.96

8,792.33 8,792.33 8,792.33 8,792.33 8,792.33 8,792.33 8,792.33 8,792.33

2,830.19 2,830.19 2,830.19 2,830.19 2,830.19 2,830.19 2,830.19 2,830.19

1,440.47 1,440.47 1,440.47 1,440.47 1,440.47 1,440.47 1,440.47 1,440.47

2,367.47 2,367.47 2,367.47 2,367.47 2,367.47 2,367.47 2,367.47 2,367.47

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

1,898.41 1,898.41 1,898.41 1,898.41 1,898.41 1,898.41 1,898.41 1,898.41

1,571.64 1,571.64 1,571.64 1,571.64 1,571.64 1,571.64 1,571.64 1,571.64

1,208.33 1,208.33 1,208.33 1,208.33 1,208.33 1,208.33 1,208.33 1,208.33

1,749.90 1,749.90 1,749.90 1,749.90 1,749.90 1,749.90 1,749.90 1,749.90

1,680.65 1,680.65 1,680.65 1,680.65 1,680.65 1,680.65 1,680.65 1,680.65

1,514.97 1,514.97 1,514.97 1,514.97 1,514.97 1,514.97 1,514.97 1,514.97

1,658.38 1,658.38 1,658.38 1,658.38 1,658.38 1,658.38 1,658.38 1,658.38

748.82 748.82 748.82 748.82 748.82 748.82 748.82 748.82

748.82 748.82 748.82 748.82 748.82 748.82 748.82 748.82

1,929.16 1,929.16 1,929.16 1,929.16 1,929.16 1,929.16 1,929.16 1,929.16

1,648.13 1,648.13 1,648.13 1,648.13 1,648.13 1,648.13 1,648.13 1,648.13

822.98 822.98 822.98 822.98 822.98 822.98 822.98 822.98

1,039.54 1,039.54 1,039.54 1,039.54 1,039.54 1,039.54 1,039.54 1,039.54

670.91 670.91 670.91 670.91 670.91 670.91 670.91 670.91

1,817.97 1,817.97 1,817.97 1,817.97 1,817.97 1,817.97 1,817.97 1,817.97

1,680.65 1,680.65 1,680.65 1,680.65 1,680.65 1,680.65 1,680.65 1,680.65

833.33 833.33 833.33 833.33 833.33 833.33 833.33 833.33

833.33 833.33 833.33 833.33 833.33 833.33 833.33 833.33

30,694.07 30,694.07 30,694.07 30,694.07 30,694.07 30,694.07 30,694.07 30,694.07

2,083.35 2,083.35 2,083.35 2,083.35 2,083.35 2,083.35 2,083.35 2,083.35

1,558.05 1,558.05 1,558.05 1,558.05 1,558.05 1,558.05 1,558.05 1,558.05

1,300.29 1,300.29 1,300.29 1,300.29 1,300.29 1,300.29 1,300.29 1,300.29

4,941.69 4,941.69 4,941.69 4,941.69 4,941.69 4,941.69 4,941.69 4,941.69

1,401.98 1,401.98 1,401.98 1,401.98 1,401.98 1,401.98 1,401.98 1,401.98

Page 72: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

1,871.91 1,871.91 1,871.91 1,871.91 1,871.91 1,871.91 1,871.91 1,871.91

1,317.88 1,317.88 1,317.88 1,317.88 1,317.88 1,317.88 1,317.88 1,317.88

941.34 941.34 941.34 941.34 941.34 941.34 941.34 941.34

753.07 753.07 753.07 753.07 753.07 753.07 753.07 753.07

555.31 555.31 555.31 555.31 555.31 555.31 555.31 555.31

555.31 555.31 555.31 555.31 555.31 555.31 555.31 555.31

750.37 750.37 750.37 750.37 750.37 750.37 750.37 750.37

8,147.17 8,147.17 8,147.17 8,147.17 8,147.17 8,147.17 8,147.17 8,147.17

1,000.00 500.00

165.00 285.00 225.00 330.00 135.00 285.00 300.00 135.00

1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00

2,000.00 2,000.00 2,000.00 900.00 5,000.00 6,000.00 6,000.00

56,740.26 55,860.26 55,800.26 54,405.26 54,610.26 58,860.26 59,875.26 58,710.26

Page 73: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Calc

Aug Annual 5 Yrs OT Rate

2,271.24 27,254.82 47.20 x 16.04

2,112.44 25,349.24 45.20 x 15.58

2,522.70 30,272.34 52.14 x 16.13

1,885.96 22,631.56 47.20 x 13.32

8,792.33 105,507.96

2,830.19 33,962.27 49.20 x 19.17

1,440.47 17,285.63 48.60 23/2/20 14.23

2,367.47 28,409.69 49.20 x 16.04

0.00 - 47.20 x #DIV/0!

1,898.41 22,780.93 47.20 x 13.41

1,571.64 18,859.63 47.20 x 13.32

1,208.33 14,499.98 45.20 x 16.04

1,749.90 20,998.84 49.20 x 14.23

1,680.65 20,167.77 44.60 21/11/21 12.56

1,514.97 18,179.69 45.20 x 13.41

1,658.38 19,900.59 45.20 x 12.23

748.82 8,985.85 44.60 1/11/22 11.19

748.82 8,985.85 44.60 1/11/22 11.19

1,929.16 23,149.94 45.20 x 14.23

1,648.13 19,777.56 44.60 x 12.32

822.98 9,875.80 45.20 x 14.57

1,039.54 12,474.53 44.60 16/3/20 13.32

670.91 8,050.88 44.60 13/4/20 12.03

1,817.97 21,815.63 45.20 x 13.41

1,680.65 20,167.77 44.60 1/9/19 12.56

833.33 10,000.00 52.14 x 5.33

833.33 10,000.00 52.14 x 5.33

30,694.07 368,328.82

2,083.35 25,000.20 52.14 x 13.32

4,166.70 52.14 x 13.32

1,558.05 18,696.60 52.14 x 9.96

1,300.29 15,603.45 52.14 x 9.98

4,941.69 63,466.95

1,401.98 16,823.81 46.20 x 14.57

Page 74: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

1,871.91 22,462.89 45.20 x 13.80

1,317.88 15,814.54 45.20 x 10.00

941.34 11,296.10 45.20 x 10.00

753.07 9,036.88 45.20 x 10.00

555.31 6,663.70 44.60 1/9/20 9.96

555.31 6,663.70 44.60 2/11/20 9.96

750.37 9,004.46 45.20 x 9.96

8,147.17 97,766.07

1,500.00

2,625.00

10,000.00

25,000.00

52,575.26 674,194.80

401,453.82

66,466.95

107,507.96

98,766.07

674,194.80

Page 75: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

8,245.64 26.5%

Comments NI Calc Pen Calc

2,623.27 7,222.53

2,360.30 n/a

3,039.68 8,022.17

1,985.26 5,997.36

10,008.51 21,242.06

3,548.89 9,000.00

1,247.52 4,580.69

2,782.64 7,528.57

- -

2,005.87 6,036.95

1,464.73 4,997.80

863.10 3,842.49

1,759.94 5,564.69

1,645.25 5,344.46

1,370.90 4,817.62

1,608.38 5,273.66

102.15 2,381.25

102.15 2,381.25

2,056.79 6,134.73

1,591.40 5,241.05

224.96 2,617.09

583.59 3,305.75

- 2,133.48

1,872.66 5,781.14

1,645.25 5,344.46

242.10 n/a

242.10 2,650.00

26,960.39 94,957.14

2,312.13 6,625.05

- 1,104.18

1,442.23 4,954.60

1,015.38 4,134.91

4,769.74 16,818.74

1,183.79 4,458.31

Page 76: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

1,961.98 5,952.67

1,044.51 4,190.85

420.96 2,993.47

109.19 2,394.77

- 1,765.88

- 1,765.88

104.72 2,386.18

4,825.15 25,908.01

207.00 397.50

362.25 695.63

1,380.00 2,650.00

48,513.03 162,669.07

7.20% 24.13%

28,081.64 97,110.26

5,183.74 17,613.74

10,284.51 21,772.06

4,963.15 26,173.01

48,513.03 162,669.07

Page 77: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

0.905255

0.866897

1

0.905255

0

0

0.943613

0.647296

0.943613

0

0.905255

0.754379

0.481609

0.786344

0.855389

0.722414

0.866897

0.427695

0.427695

0.866897

0.855389

0.361207

0.498977

0.356412

0.866897

0.855389

1

1

15.42337

0

1

1

1

0.833333

0

0

0.615331

Page 78: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

0.866897

0.842816

0.602012

0.481609

0.356412

0.356412

0.481609

Page 79: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Wallington County Grammar School

Non-Teaching Staff Salary Projections Financial Year 2019-2020

Spine Spine

Grade Range Act LLW Basic Allow TTO

Administration

Jo Johnson S6/SO1 26 - 31 31 31 30,709.49 38.00

Laura Gayle 7/8 29 - 34 31 31 30,709.49 38.00

Amanda Tutt S6/SO1 26 - 31 31 31 30,709.49 165.00 38.00

Rita Bharadia 4/5 18 - 25 25 25 25,500.20 38.00

Education Support

Daniel Cardenas PO2 35 - 38 38 38 36,711.55 38.00

Yasmin Noor Ahmed 5/6 22 - 28 28 28 27,887.92 165.00 38.00

Peggy Clode S6/SO1 26 - 31 31 31 30,709.49 38.00

Carole Brooks 5/6 22 - 28 28 28 27,887.92 165.00 38.00

Mandy Curtis 5/6 22 - 28 26 26 26,261.78 165.00 38.00

Irene Gambel 5/6 22 - 28 26 26 26,261.78 38.00

Lorraine Lenaghan S6/SO1 26 - 31 31 31 30,709.49 38.00

Maria Waters 5/6 22 - 28 28 28 27,887.92 165.00 38.00

Eugenie Bryan 4/5 18 - 25 24 24 24,763.60 38.00

Terry Round 4/5 18 - 25 25 25 25,500.20 165.00 38.00

Nicola Moyle 4/5 18 - 25 23 23 24,048.85 38.00

Paul Kiteley 4/5 18 - 25 20 20 22,135.55 38.00

Leila Herbal 4/5 18 - 25 20 20 22,135.55 38.00

Phil Nicholson 5/6 22 - 28 28 28 27,887.92 165.00 38.00

ANO 5/6 22 - 28 23 23 24,048.85 165.00 38.00

Angela Stratford 5/6 22 - 28 28 28 27,887.92 38.00

Annette Slade 5/6 22 - 28 26 26 26,261.78 38.00

Tracey Donald 4/5 18 - 25 22 22 23,415.24 165.00 38.00

Richard Poynter 5/6 22 - 28 26 26 26,261.78 165.00 38.00

Asma Farshori 4/5 18 - 25 24 24 24,763.60 165.00 38.00

Food Tech N/A N/A N/A N/A 10,000.00 38.00

PE Tech N/A N/A N/A N/A 14,000.00 38.00

Premises

Derek Dougherty 4/5 18 - 25 25 25 25,500.20 38.00

ANO 1c/3 9 - 17 10 10 19,070.53 38.00

Ken Antwi 1c/3 9 - 17 12 12 19,117.35 38.00

Catering

Diane Reeves 5/6 22 - 28 27 27 27,070.17 165.00 38.00

Jackie Dyduch 1A/2 5 - 13 13 13 19,139.20 38.00

Page 80: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

Jan Skipp 1A/2 5 - 13 13 13 19,139.20 38.00

Debbie Branch 1A/2 5 - 13 13 13 19,139.20 38.00

Julia Morcombe 1A/2 5 - 13 9 10 19,070.53 38.00

Samantha Drew 1A/2 5 - 13 9 10 19,070.53 38.00

Tracey Donovan 1A/2 5 - 13 11 11 19,098.62 38.00

Sports Allowances

Duties

Overtime/Suppl/Admin

Invigilation

Educational Support Staff

Premises Staff

Admin Staff

Other Staff

Page 81: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

FTE Calc

+ Wks Hols Contract Hours Total Annual 5 Yrs

2.00 7.20 0.905 36.00 27,799.92 27,799.92 47.20 x

7.20 0.867 36.00 26,621.96 26,621.96 45.20 x

6.94 7.20 1.000 36.00 30,874.49 30,874.49 52.14 x

2.00 7.20 0.905 36.00 23,084.19 23,084.19 47.20 x

108,380.55

4.00 7.20 0.944 36.00 34,641.51 34,641.51 49.20 x

4.00 7.20 0.944 25.00 18,382.72 18,382.72 49.20 x

4.00 7.20 0.944 36.00 28,977.88 28,977.88 49.20 x

2.00 7.20 0.905 0.00 - - 47.20 x

2.00 7.20 0.905 36.00 23,922.97 23,922.97 47.20 x

2.00 7.20 0.905 30.00 19,811.34 19,811.34 47.20 x

7.20 0.867 20.00 14,789.98 14,789.98 45.20 x

4.00 7.20 0.944 30.00 22,059.26 22,059.26 49.20 x

6.60 0.855 36.00 21,182.52 21,182.52 44.60 21/11/21

7.20 0.867 30.00 18,540.90 18,540.90 45.20 x

7.20 0.867 36.00 20,847.87 20,847.87 45.20 x

6.60 0.855 18.00 9,467.26 9,467.26 44.60 1/11/22

6.60 0.855 18.00 9,467.26 9,467.26 44.60 1/11/22

7.20 0.867 36.00 24,318.99 24,318.99 45.20 x

7.20 0.867 36.00 20,990.91 20,990.91 45.20 x

7.20 0.867 15.00 10,073.31 10,073.31 45.20 x

7.20 0.867 21.00 13,280.31 13,280.31 45.20 x

7.20 0.867 15.00 8,517.35 8,517.35 45.20 x

7.20 0.867 36.00 22,909.29 22,909.29 45.20 x

7.20 0.867 36.00 21,610.52 21,610.52 45.20 x

6.94 7.20 1.000 36.00 10,000.00 10,000.00 52.14 x

6.94 7.20 1.000 36.00 10,000.00 10,000.00 52.14 x

383,792.15

6.94 7.20 1.000 36.00 25,500.20 25,500.20 52.14 x

6.94 7.20 1.000 30.00 15,892.11 15,892.11 52.14 x

6.94 7.20 1.000 30.00 15,931.13 15,931.13 52.14 x

57,323.44

7.20 0.867 36.00 23,610.08 23,610.08 45.20 x

7.20 0.867 35.00 16,130.83 16,130.83 45.20 x

Page 82: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

7.20 0.867 25.00 11,522.02 11,522.02 45.20 x

7.20 0.867 20.00 9,217.62 9,217.62 45.20 x

6.60 0.855 15.00 6,796.97 6,796.97 44.60 1/9/20

6.60 0.855 15.00 6,796.97 6,796.97 44.60 2/11/20

7.20 0.867 20.00 9,198.08 9,198.08 45.20 x

83,272.56

1,500.00

2,625.00

10,000.00

25,000.00

671,893.70

416,917.15

60,323.44

110,380.55

84,272.56

671,893.70

Page 83: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

8,328.10 27.5%

OT Rate Comments NI Calc Pen Calc

16.36 2,687.11 7,644.98

16.36 2,524.55 n/a

16.45 3,111.40 8,490.48

13.59 2,036.34 6,348.15

10,359.41 22,483.61

19.56 3,631.25 9,526.42

14.95 1,387.54 5,055.25

16.36 2,849.67 7,968.92

#DIV/0! - -

14.08 2,152.09 6,578.82

13.99 1,584.69 5,448.12

16.36 891.74 4,067.24

14.95 1,894.90 6,066.30

13.19 1,773.91 5,825.19

13.67 1,409.37 5,098.75

12.81 1,727.73 5,733.16

11.79 157.20 2,603.50

11.79 157.20 2,603.50

14.95 2,206.74 6,687.72

12.90 1,747.47 5,772.50

14.86 240.84 2,770.16

13.99 683.41 3,652.09

12.56 26.12 2,342.27

14.08 2,012.20 6,300.05

13.28 1,832.98 5,942.89

5.33 230.72 n/a

5.33 230.72 2,750.00

28,828.49 102,792.84

13.59 2,369.75 7,012.56

10.16 1,043.83 4,370.33

10.18 1,049.22 4,381.06

4,462.80 15,763.95

14.51 2,108.91 6,492.77

10.20 1,076.78 4,435.98

Page 84: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

10.20 440.76 3,168.56

10.20 122.75 2,534.84

10.16 - 1,869.17

10.16 - 1,869.17

10.17 120.06 2,529.47

3,869.26 22,899.96

207.00 412.50

362.25 721.88

1,380.00 2,750.00

49,469.22 167,824.73

7.36% 24.98%

29,949.74 105,027.22

4,876.80 16,588.95

10,635.41 23,033.61

4,007.26 23,174.96

49,469.22 167,824.73

Page 85: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

0.905255

0.866897

1

0.905255

0

0

0.943613

0.655287

0.943613

0

0.905255

0.754379

0.481609

0.786344

0.855389

0.722414

0.866897

0.427695

0.427695

0.866897

0.866897

0.361207

0.50569

0.361207

0.866897

0.866897

1

1

15.46588

0

1

0.833333

0.833333

0

0

0.866897

0.842816

Page 86: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

0.602012

0.481609

0.356412

0.356412

0.481609

Page 87: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

0 -

4 -

5

6 17,961

7 17,985

8 18,051

9 18,105

10 18,330

11 18,357

12 18,375

13 18,396

14 18,657

15 18,936

16 19,281

17 19,623

18 19,917

19 20,598

20 21,276

21 21,984

22 22,506

23 23,115

24 23,802

25 24,510

26 25,242

27 26,019

28 26,805

29 27,801

30 28,668

31 29,517

32 30,324

33 31,170

34 31,998

35 32,628

36 33,444

37 34,338

38 35,286

39 36,372

40 37,293

41 38,229

42 39,147

43 40,086

44 41,025

45 41,898

46 42,876

47 43,815

48 44,751

49 45,666

50 47,544

51 48,489

Grade 9

Grade 10

Grade 1a

Grade 1b

Grade 16

Grade 4

Grade 1c

Grade 2

Grade 3

Grade 5

Grade 6

Grade 7

Grade 14

Grade 15

Grade 11

Grade 12

Grade 8

Page 88: Wallington County Grammar School Total Income and ... · Wallington County Grammar School Total Income and Expenditure Account Estimate Estimate Estimate 2017/18 2018/19 2019/20 £

52 49,452

53 50,445

54 52,476

55 53,478

56 54,480

57 55,494

Grade 16

Grade 17