2014 2015.pdf

Aldridge
School

Financial Management
Reports as at

31st August 2015

Period 12
August 2015

Twelve Months to
31st August 2015

Contents

Page

3
Financial Summary Income and Expenditure Actual, Budgeted and

Forecast

4
Statement of Variance Criteria

5
Detailed Budget Monitoring

10
Variance Notes and Explanations

12
2014-15 Year End Forecast Detail

15
2014-15 Year End Forecast Summary

2

Financial Summary Income and Expenditure
Actual, Budgeted and Forecast

Year to
Income
Period 12 - August


Full Year
  Forecast

date

Forecast
%
Description
Actual
Budget
Variance
Actual
Budget
Variance
Income
Variance

Budget
Received

Total Restricted Income
632,187
618,771
13,416
8,285,935
8,096,215
189,720
8,096,215
102
8,358,091
261,876
-
-
-

  Total Unrestricted Income
4,808
963
3,845
49,671
35,449
14,222
35,449
140
49,671
14,222
-
-
-

  Total Income
636,995
619,734
17,261
8,335,605
8,131,664
203,941
8,131,664
103
8,407,762
276,098
-
-
-

Year to
Expenditure
Period 12 - August



Full Year
  Forecast

date

Forecast
%
Description
Actual
Budget
Variance
Actual
Budget
Variance
  Spend
Variance

Budget
Spent

Staffing Total
486,668
492,132
5,464
6,293,907
6,111,143
-182,764
6,111,143
103
6,304,857
-193,714
-
-
-

  Premises and Occupation Costs
235,838
27,324
-208,514
800,128
820,261
20,133
820,261
98
945,523
-125,262
-
-
-

Administration
2,413
5,190
2,777
633,761
671,176
37,415
671,176
94
658,977
12,199
-
-
-

  Administration Total
1,035
1,618
583
146,492
171,505
25,013
171,505
85
148,323
23,182
-
-
-

SLT Capitation
4,588
2,702
-1,886
216,352
327,579
111,227
327,579
66
323,181
4,398
-
-
-

Grand Total Expenditure
730,541
528,966
-201,575
8,090,640
8,101,664
11,024
8,101,664
100
8,380,862
-279,198
-
-
-




Carry Forward (£)

Balance brought forward from
618,805
2013/14

Budgeted surplus from 2014/15
26,900

Total
645,705

Statement of Variance Criteria

Budgets with an overspend of 10% and over £250 or £1000 (which ever
lower), are deemed to require specific explanation to Governors and SLT.

This explanation will include a reason for the variance and action required
to either avoided it happening again or to rectify the situation and
reduce/remove the overspend where possible.

Detailed Budget Monitoring Period

Income
Period 12 - August

Year to date
Full Year

Code
Description
Actual
Budget
Variance
Actual
Budget
Variance
Budget
%Received

901
GAG Income
616,065
618,771
-2,706
7,833,987
7,866,569
-32,582
7,866,569
100

941
2014 -15 CAPITAL MAINTENANCE FUN
0
0
0
128,633
200,789
-72,156
200,789
64

942
Capital Maintence Fund 2015-16
0
0
0
225,000
0
225,000
0

945
Developed Formula Capital
0
0
0
46,719
28,857
17,862
28,857
162

950
Other Government Grants
16,122
0
16,122
42,933
0
42,933
0

951
Big Lottery Grant
0
0
0
8,758
0
8,758
0

966
Other Miscellaneous Income
0
0
0
-350
0
-350
0

980
Catering Income
0
0
0
255
0
255
0


Total Restricted Income
632,187
618,771
13,416
8,285,935
8,096,215
189,720
8,096,215
102
960
Lettings & Rental Income
4,776
550
4,226
31,877
25,449
6,428
25,449
125

964
Bank interest
32
413
-381
6,541
5,000
1,541
5,000
131

965
Other Employee Income
0
0
0
11,253
5,000
6,253
5,000
225


  Total Unrestricted Income
4,808
963
3,845
49,671
35,449
14,222
35,449
140

  Total Income
636,995
619,734
17,261
8,335,605
8,131,664
203,941
8,131,664
103

5

Expenditure - Staffing
Period 12 - August


Year to date
Full Year

Code
Description
Actual
Budget
Variance
Actual
Budget
Variance
Budget
%Spent

001
Teaching Staff
396,413
405,327
8,914
4,722,881
4,842,551
119,670
4,842,551
98

002
Associate Staff
86,751
86,805
54
1,190,572
1,115,712
-74,860
1,115,712
107

003
Supply Staff - Illness
920
0
-920
208,740
63,200
-145,540
63,200
330

004
Supply Staff - Maternity/Pat'nty
0
0
0
58,935
30,000
-28,935
30,000
196

006
Supply Staff - Other Authorised
0
0
0
62,975
15,000
-47,975
15,000
420

007
Lunchcover
1,954
0
-1,954
23,443
27,680
4,237
27,680
85

010
Employee Related Costs
630
0
-630
7,795
7,000
-795
7,000
111

011
Recruitment
0
0
0
18,567
10,000
-8,567
10,000
186


Staffing Total
486,668
492,132
5,464
6,293,907
6,111,143
-182,764
6,111,143
103

Premises and Occupation Costs
Period 12 - August


Year to date
Full Year

Code
Description
Actual
Budget
Variance
Actual
Budget
Variance
Budget
%Spent

012
Welfare and Hospitality
2,908
17
-2,891
10,738
16,000
5,262
16,000
67

013
Simply Health
890
915
25
10,775
10,980
205
10,980
98

015
Capital Improvment Fund
168,031
0
-168,031
203,359
0
-203,359
0

017
Capital Maintenance Round 1
0
0
0
3,000
0
-3,000
0

018
Capital Maintenance Fund 2014-15
4,798
0
-4,798
119,217
200,789
81,572
200,789
59

019
Devolved Formula Capital (Exp)
0
2,304
2,304
0
28,857
28,857
28,857
-

020
Operational Maintenance
33,588
14,535
-19,053
101,884
107,678
5,794
107,678
95

021
Grounds Maintenance
2,731
1,568
-1,163
9,726
15,000
5,274
15,000
65

022
Property Projects
0
0
0
-2,374
0
2,374
0

023
Water and Sewerage
689
0
-689
10,042
12,898
2,856
12,898
78

024
Energy
149
2,687
2,538
77,048
147,729
70,681
147,729
52

025
Other Occupation Costs
2,040
2,287
247
31,743
40,000
8,257
40,000
79

026
Cleaning and Caretaking
11,612
0
-11,612
139,344
140,000
656
140,000
100

028
Insurance
0
0
0
56,162
64,330
8,168
64,330
87

029
Rates
8,402
3,011
-5,391
29,464
36,000
6,536
36,000
82


  Premises and Occupation Costs
235,838
27,324
-208,514
800,128
820,261
20,133
820,261
98

6

Administration
Period 12 - August


Year to date
Full Year

Code
Description
Actual
Budget
Variance
Actual
Budget
Variance
Budget
%Spent

030
Admin Supplies
98
0
-98
15,219
30,000
14,781
30,000
51

031
Communications
2,405
1,155
-1,250
23,501
30,000
6,499
30,000
78

033
ICT Consumables
0
0
0
4,998
5,500
502
5,500
91

034
ICT Curriculum Development
65
-1
-66
52,195
46,000
-6,195
46,000
113

035
ICT Network Support
52
1,728
1,676
75,253
94,435
19,182
94,435
80

036
ICT Network Upgrade
0
0
0
122,107
125,931
3,824
125,931
97

037
BYOD
-7,131
0
7,131
-14,797
0
14,797
0
-

040
Professional services
1,000
1,500
500
53,261
40,000
-13,261
40,000
133

048
Admissions and Marketing
785
808
23
24,489
25,000
511
25,000
98

049
Admission appeals
0
0
0
0
1,000
1,000
1,000
-

050
Library
0
0
0
12,253
14,000
1,747
14,000
88

055
Resources
355
0
-355
8,317
16,329
8,012
16,329
51

060
Furniture & Equipment
4,225
0
-4,225
14,932
16,000
1,068
16,000
93

061
Minibus Operating costs
163
0
-163
13,669
7,799
-5,870
7,799
175

065
Transport PE activities-external
0
0
0
5,465
5,000
-465
5,000
109

070
Examinations Fees
767
0
-767
135,007
140,000
4,993
140,000
96

080
Catering Supplies (inc Subsidy)
0
0
0
2,299
2,300
1
2,300
100

085
Free School Meals
-371
0
371
81,503
55,248
-26,255
55,248
148

091
Bursary 16-19 Distribution
0
0
0
4,090
16,634
12,544
16,634
25


Administration
2,413
5,190
2,777
633,761
671,176
37,415
671,176
94

7

Curriculum Capitation
Period 12 - August


Year to date
Full Year

Code
Description
Actual
Budget
Variance
Actual
Budget
Variance
Budget
%Spent

100
Faculty of English
0
0
0
5,848
12,000
6,152
12,000
49

101
English Department DNU
0
0
0
-280
0
280
0

102
Media Studies
0
0
0
519
500
-19
500
104

130
Faculty of Mathematics
-765
0
765
11,911
11,970
59
11,970
100

131
Mathematics Department DNU
0
0
0
108
30
-78
30
361

140
Maths Futures
0
0
0
466
500
34
500
93

160
Faculty of Science
1,757
1,252
-505
20,964
23,889
2,925
23,889
88

161
Science Department DNU
0
0
0
-119
111
230
111
-107

201
Business Studies
0
0
0
2,674
3,000
326
3,000
89

202
ICT Department
43
0
-43
1,317
1,500
183
1,500
88

203
MFL Department
0
0
0
3,561
4,000
439
4,000
89

204
Asdan
0
0
0
80
0
-80
0

205
Psychology/Sociology
0
0
0
1,104
1,400
296
1,400
79

206
Health & Social
0
0
0
850
1,200
350
1,200
71

250
Faculty of Humanities
0
0
0
-21
0
21
0

251
Geography Department
0
0
0
3,810
4,000
190
4,000
95

252
History Department
0
0
0
3,804
4,000
196
4,000
95

253
RST Department
0
0
0
2,717
3,000
283
3,000
91

255
Citizenship
0
0
0
484
500
16
500
97

256
LAW
0
0
0
437
500
63
500
87

300
Faculty of Performance
0
0
0
-525
0
525
0

301
PE Department
0
0
0
5,128
5,416
288
5,416
95

302
Music Department
0
0
0
5,772
5,619
-153
5,619
103

303
Walsall/Other Music Support
0
0
0
45,909
57,870
11,961
57,870
79

304
Drama Department
0
0
0
1,545
1,500
-45
1,500
103

351
D&T Department
0
0
0
18,866
19,000
134
19,000
99

352
Art Department
0
339
339
6,406
6,300
-106
6,300
102

391
Student Development Department
0
27
27
2,458
3,000
542
3,000
82

392
Student Development Social Club
0
0
0
200
200
0
200
100

393
Student Dev. Foundation Learning
0
0
0
500
500
0
500
100


  Administration Total
1,035
1,618
583
146,492
171,505
25,013
171,505
85

8

SLT Capitation
Period 12 - August


Year to date
Full Year

Code
Description
Actual
Budget
Variance
Actual
Budget
Variance
Budget
%Spent

400
Revision and Boosters
0
0
0
3,986
4,500
514
4,500
89

401
Improving T&L
250
0
-250
6,014
10,000
3,986
10,000
60

402
Planners
0
0
0
5,995
6,000
5
6,000
100

411
Curriculum Development GM
0
0
0
901
3,000
2,099
3,000
30

420
Surveys
0
0
0
0
2,000
2,000
2,000
-

421
CPD
0
0
0
12,773
15,000
2,227
15,000
85

422
NQT
0
0
0
2,514
5,000
2,486
5,000
50

430
Science College
0
0
0
0
50
50
50
-

431
Science and Engineering
0
240
240
3,359
3,500
141
3,500
96

440
Alternative Provision
0
0
0
22,522
50,000
27,478
50,000
45

450
Sixth Form Funding
0
253
253
5,257
6,000
743
6,000
88

451
Careers
0
0
0
23,380
25,000
1,620
25,000
94

452
UCAS
-23
0
23
-314
0
314
0

461
Rewards and Consequences
808
0
-808
9,577
9,000
-577
9,000
106

470
Aldridge Partnership
0
0
0
30
30
0
30
100

480
Barr House
0
0
0
158
200
42
200
79

481
Daniels House
78
0
-78
166
200
34
200
83

482
Linley House
6
0
-6
-150
200
350
200
-75

483
Scott House
0
0
0
8
200
192
200
4

484
Alder Centre
0
15
15
293
300
7
300
98

485
Gifted and Talented
0
0
0
165
0
-165
0

486
PSHCE
0
0
0
781
350
-431
350
223

487
School Council
0
0
0
87
250
163
250
35

488
Pastoral/Attendance
0
0
0
1,199
1,415
216
1,415
85

489
Director of School
0
0
0
24
100
76
100
24

490
Peer Mentoring/Ambassadors
0
0
0
0
100
100
100
-

491
Lotto Fund
0
0
0
7,000
0
-7,000
0

495
SLT Residual
356
84
-272
-2,413
9,072
11,485
9,072
-27

496
Pupil Premium Exp
3,112
2,110
-1,002
130,041
176,112
46,071
176,112
74

497
Year 7 Catch Up Grant
0
0
0
-17,000
0
17,000
0


SLT Capitation
4,588
2,702
-1,886
216,352
327,579
111,227
327,579
66

Grand Total Expenditure
730,541
528,966
-201,575
8,090,640
8,101,664
11,024
8,101,664
100

Budgeted Surplus
30,000

9

Variance Notes and Explanation

Code
Description
Variance Reason
Action Required
002
Associate Staff
Overspent by £74k – due to pension deficit
Transfer half of pension deficit payment,
payment waiting to be split over finical
use underspends elsewhere will allow the
years, staff pay progression and cost of
budget to return to zero. Use the budgeted
lining increase.
surplus and underspends elsewhere to

cover costs.
003 -
Supply Staff
Overspent of £222k due to increased of
Transfer funds from cost centres e.g. CPD.
006
supply from maternity, increased illness and  Monitor situation closely. HR are currently
compassionate leave. Some costs can be
involved with longer term issues.  The
transferred from CPD and other costs will be  forecast surplus and underspends
offset by generated income i.e. external
elsewhere will allow the budget to return
moderation.
to zero.  Budget for supply increased next
year.  Supply Other Authorised costs to be
removed 2015 - 16
010
Employee Related Costs
Overspent by £795 due to DBS checks for
Take funds form underspend elsewhere.
new staff
007
Recruitment
Overspent by £8.5k due to additional
Use underspends elsewhere to cover
advertising required to fill posts that failed
increased costs.
to be filled on first run.

022
Property Projects
-£2,374 showing – this is a correction
NA
following a miss code

034
ICT Curriculum Development
Overspent by £6K relating to expenses for
Correct at year end
September 1st
037
BYOD
Zero Budget showing overspend, this
NA
budget is used to hold funds for BYOD
project – money that goes out will be offset
by funds collected from parents.

040
Professional Services
Overspent by £13K due to costs relating to
Transfer costs relating to roofing project.
roofing work starting to come through and
Use underspends elsewhere to cover
increased costs for other services.
increased costs. Modify next years model.

10

Code
Description
Variance Reason
Action Required
061
Minibus Operational costs
Overspend by £6k due to purchase on new
Funds to be transferred at end of year.
van.

065
Transport PE activities-external
Overspend of £465 due to additional
Transfer to be made from elsewhere.
activities
085
Free School Meals
Increased uptake in FSM has caused
Use underspends elsewhere to cover
overspend from allocation of £26k
increased costs.  Model for 2015/16 is
using 85% uptake to allow for increase.
100 -
Curriculum Capitation Cost
Overspent against budgets due to phasing.
Fund transfers from parent cost centre
393
Centres
Where cost centres started with zero
where required.
budgets, funds from parent cost centre to
be transferred e.g. 140 and 130.


452
UCAS
Zero Budget showing overspend, this
NA
budget is used to hold funds for UCAS
project – money that goes out will be offset
by funds collected from parents.

461
Rewards and Consequences
Overspent by £577 due to purchased of gift
Transfer to be made from elsewhere.
vouchers for Prize Award Evening
485
Gifted and Talented
£165 showing – this relates to a late invoice  Transfer to be made from elsewhere.

486
PSHCE
Overspend of £781 due to increased
Use underspends elsewhere to cover
photocopying
increased costs.
491
Lotto Fund
£10,000 relating to last financial year
Zero budget but find accounted for in year
end.

11

2014-15 Year End Forecast Detail

Expenditure - Staffing
Full Year
  Forecast

  Code
  Description
Budget
%Spent
  Spend
Variance

001
Teaching Staff
4,842,551
98    -
4,722,881
119,670

002
Associate Staff
1,115,712
107    -
1,201,523
-85,811

003
Supply Staff - Illness
63,200
330    -
208,740
-145,540

004
Supply Staff - Maternity/Pat'nty
30,000
196    -
58,935
-28,935

006
Supply Staff - Other Authorised
15,000
420    -
62,975
-47,975

007
Lunchcover
27,680
85    -
23,443
4,237

010
Employee Related Costs
7,000
111    -
7,795
-795

011
Recruitment
10,000
186    -
18,567
-8,567


Staffing Total

6,111,143
103    -
6,304,857
-193,714

Premises and Occupation Costs
Full Year
-
  Forecast

Code
Description
Budget
%Spent
-
  Spend
Variance

012
Welfare and Hospitality
16,000
67    -
10,738
5,262

013
Simply Health
10,980
98    -
10,775
205

015
Capital Improvment Fund
-
#DIV/0!
-
234,409
-234,409

017
Capital Maintenance Round 1
-
#DIV/0!
-
3,000
-3,000

018
Capital Maintenance Fund 2014-15
200,789
59    -
200,789
-

019
Devolved Formula Capital (Exp)
28,857
-     -
28,857
-

020
Operational Maintenance
107,678
95    -
105,066
2,612

021
Grounds Maintenance
15,000
65    -
9,726
5,274

022
Property Projects
-
#DIV/0!
-
-2,374
2,374

023
Water and Sewerage
12,898
78    -
10,042
2,856

024
Energy
147,729
52    -
77,048
70,681

025
Other Occupation Costs
40,000
79    -
32,477
7,523

026
Cleaning and Caretaking
140,000
100    -
139,344
656

028
Insurance
64,330
87    -
56,162
8,168

029
Rates
36,000
82    -
29,464
6,536

0
Premises and Occupation Costs

820,261
98    -
945,523
-125,262

12

Administration
Full Year
-
  Forecast

Code
Description
Budget
%Spent
-
  Spend
Variance

030
Admin Supplies
30,000
51    -
15,219
14,781

031
Communications
30,000
78    -
23,590
6,410

033
ICT Consumables
5,500
91    -
4,998
502

034
ICT Curriculum Development
46,000
113    -
52,546
-6,546

035
ICT Network Support
94,435
80    -
91,008
3,427

036
ICT Network Upgrade
125,931
97    -
125,931
0

037
BYOD
-
-     -
-14,797
14,797

040
Professional services
40,000
133    -
53,261
-13,261

048
Admissions and Marketing
25,000
98    -
24,489
511

049
Admission appeals
1,000
-     -
-
1,000

050
Library
14,000
88    -
12,253
1,747

055
Resources
16,329
51    -
11,790
4,539

060
Furniture & Equipment
16,000
93    -
16,036
-36

061
Minibus Operating costs
7,799
175    -
13,669
-5,870

065
Transport PE activities-external
5,000
109    -
5,465
-465

070
Examinations Fees
140,000
96    -
135,627
4,373

080
Catering Supplies (inc Subsidy)
2,300
100    -
2,299
1

085
Free School Meals
55,248
148    -
81,503
-26,255

091
Bursary 16-19 Distribution
16,634
25    -
4,090
12,544

0
Administration

671,176
94    -
658,977
12,199

Curriculum Capitation
Full Year
-
  Forecast

Code
Description
Budget
%Spent
-
  Spend
Variance

100
Faculty of English
12,000
49    -
5,848
6,152

101
English Department DNU
-
#DIV/0!
-
-280
280

102
Media Studies
500
104    -
519
-19

130
Faculty of Mathematics
11,970
100    -
11,911
59

131
Mathematics Department DNU
30
361    -
108
-78

140
Maths Futures
500
93    -
466
34

160
Faculty of Science
23,889
88    -
22,494
1,395

161
Science Department DNU
111
-107    -
-119
230

201
Business Studies
3,000
89    -
2,770
230

202
ICT Department
1,500
88    -
1,317
183

203
MFL Department
4,000
89    -
3,736
264

204
Asdan
-
#DIV/0!
-
80
-80

205
Psychology/Sociology
1,400
79    -
1,104
296

206
Health & Social
1,200
71    -
850
350

250
Faculty of Humanities
-
#DIV/0!
-
-21
21

251
Geography Department
4,000
95    -
3,810
190

252
History Department
4,000
95    -
3,834
166

253
RST Department
3,000
91    -
2,717
283

255
Citizenship
500
97    -
484
16

256
LAW
500
87    -
437
63

300
Faculty of Performance
-
#DIV/0!
-
-525
525

301
PE Department
5,416
95    -
5,128
288

302
Music Department
5,619
103    -
5,772
-153

303
Walsall/Other Music Support
57,870
79    -
45,909
11,961

304
Drama Department
1,500
103    -
1,545
-45

351
D&T Department
19,000
99    -
18,866
134

352
Art Department
6,300
102    -
6,406
-106

391
Student Development Department
3,000
82    -
2,458
542

392
Student Development Social Club
200
100    -
200
0

393
Student Dev. Foundation Learning
500
100    -
500
0

0
Administration Total

171,505
85    -
148,323
23,182

13

SLT Capitation
Full Year
-
  Forecast

Code
Description
Budget
%Spent
-
  Spend
Variance

400
Revision and Boosters
4,500
89    -
3,986
514

401
Improving T&L
10,000
60    -
6,014
3,986

402
Planners
6,000
100    -
5,995
5

411
Curriculum Development GM
3,000
30    -
946
2,054

420
Surveys
2,000
-     -
-
2,000

421
CPD
15,000
85    -
12,773
2,227

422
NQT
5,000
50    -
3,610
1,390

430
Science College
50
-     -
-
50

431
Science and Engineering
3,500
96    -
3,359
141

440
Alternative Provision
50,000
45    -
49,802
198

450
Sixth Form Funding
6,000
88    -
5,257
743

451
Careers
25,000
94    -
23,380
1,620

452
UCAS
-
#DIV/0!
-
-314
314

461
Rewards and Consequences
9,000
106    -
9,577
-577

470
Aldridge Partnership
30
100    -
30
-

480
Barr House
200
79    -
158
42

481
Daniels House
200
83    -
166
34

482
Linley House
200
-75    -
-150
350

483
Scott House
200
4    -
8
192

484
Alder Centre
300
98    -
293
7

485
Gifted and Talented
-
#DIV/0!
-
165
-165

486
PSHCE
350
223    -
781
-431

487
School Council
250
35    -
87
163

488
Pastoral/Attendance
1,415
85    -
1,199
216

489
Director of School
100
24    -
24
76

490
Peer Mentoring/Ambassadors
100
-     -
-
100

491
Lotto Fund
-
#DIV/0!
-
7,000
-7,000

495
SLT Residual
9,072
-27    -
-2,337
11,409

496
Pupil Premium Exp
176,112
74    -
174,373
1,739

497
Year 7 Catch Up Grant
-
#DIV/0!
-
17,000
-17,000

0
SLT Capitation

327,579
66    -
323,181
4,398

Grand Total Expenditure

8101664
100    -
8,380,862
-279,198

Budgeted Surplus

30,000

Forecast Surplus    -
26,900

14

2014-15 Forecast Summary

Income
Full Year
  Forecast

Description
Forecast Budget
%Received
Income
Variance

Total Restricted Income
8,096,215
102
8,358,091
261,876

  Total Unrestricted Income
35,449
140
49,671
14,222

  Total Income
8,131,664
103

8,407,762
276,098

Expenditure
Full Year
  Forecast

Description
Forecast Budget
%Spent
  Spend
Variance

Staffing Total
6,111,143
103
6,304,857
-193,714

  Premises and Occupation Costs
820,261
98
945,523
-125,262

Administration
671,176
94
658,977
12,199

  Administration Total
171,505
85
148,323
23,182

SLT Capitation
327,579
66
323,181
4,398

Grand Total Expenditure
8,101,664
100
8,380,862
-279,198

Budgeted Surplus
30,000

Forecast Surplus

26,900

15