School Budget Summary and Variances - Mar 25 Management Accounts

Management Accounts Mar 25 SCHOOLS THAT EXCEL | PEOPLE WHO INSPIRE | PARTNERSHIPS THAT MAKE A DIFFERENCE

Mar 25 Management Accounts Figures represent the surplus/deficits By school Table opposite contains the summary of the surplus/deficits v the budget for Mar 25. Schools Central Charter Institute The Charter Schools Educational Trust Primary Charles Dickens Primary School Dulwich Hamlet Junior School Loughborough Primary School Lyndhurst Primary School Streatham Wells Primary School The Belham Primary School Secondary The Charter School Bermondsey The Charter School East Dulwich The Charter School North Dulwich Grand Total Actual - - - Budget - Variance - - - - - 123,976 88,260 35,716 108,238 10,235 5,226 31,356 26,538 38,841 16,512 25,513 10,630 49,981 13,838 257,727 46,095 16,250 29,845 40,985 8,579 7,368 3,553 6,907 9,535 5,043 52,467 11,774 3,013 43,706 139,547 77,881 72,010 5,871 67,253 18,814 2,142 27,803 19,631 29,306 11,469 26,954 22,404 52,994 57,544 118,180 The budget has been revised to include the extra income that we are receiving, that had not been budgeted. This means the overall TCSET target for 2024/25 is 1.8m. Overall performance is good & ahead of budget by 118k. The main adverse variances are at; CDP The main cause is adverse other expenditure of 21k the largest element of which is whole school subscriptions. DHJ The main adverse variance is across other expenditure. CSB Greater income & under spends on staff costs are consumed by a 77k adverse variance on other expenditure which includes 44k from an unpaid rental invoice on the old site & a wide distribution of other variances including 10k on curriculum expenditure. CND The main cause is a 68k adverse other expenditure variances distributed across many lines including inclusion support, music peris, whole school subs.

Mar 25 Year to Date (YTD) Figures represent the surplus/deficits By school Schools Central Charter Institute The Charter Schools Educational Trust Primary Charles Dickens Primary School Dulwich Hamlet Junior School Loughborough Primary School Lyndhurst Primary School Streatham Wells Primary School The Belham Primary School Secondary The Charter School Bermondsey The Charter School East Dulwich The Charter School North Dulwich Grand Total Actual - Budget Variance - - - - - - - - 381,359 158,167 223,192 277,555 14,345 24,583 72,246 104,477 21,029 69,565 401,702 140,511 37,966 223,225 1,060,615 278,481 65,896 212,585 283,762 67,130 41,789 24,871 61,029 32,471 56,472 577,048 43,397 263,692 269,959 1,139,291 102,878 92,271 10,607 6,207 81,475 17,206 47,375 43,448 11,442 13,093 175,346 97,114 225,726 46,734 78,676 Table opposite contains the summary of the surplus/deficits v the budget for Mar 25 YTD. Overall the YTD position is a surplus of 1.1m but is Adverse to the revised budget by 79k. The adverse positions are due to; CED This is mainly from the pupil number adjustment ( 172k) & the overspend on other expenditure ( 221k). CDP The main issue has been the downward revision of the 3rd party income (lettings) has cost 103k YTD. DHJ The main issue has been over spend on agency costs for support staff. SWP The main issues have been agency costs ( 28k) & catering costs ( 13k). CND The over spends in March ( 57k) on other expenditure.

Accounts by Cost Line March 25 Month End Within the month of March the main adverse area was other expenditure adverse 184k. The highest for a few months. There is 36k of rates cost that is matched by income but the main remaining areas are Whole school subs 41k adverse Curriculum support & inclusion 35k Greystar rental at CSB - 42k Actual Revised Budget Variance 4,065,797 3,170,236 756,014 139,547 Total INCOME Total Staffing Expenditure Total Other Expenditure Surplus / (Deficit) excl. Capital 4,444,817 3,246,831 940,259 257,727 - - 379,020 76,595 184,245 118,180 March 25 YTD Variance - - - Actual Revised Budget 28,525,169 22,236,798 5,149,080 1,139,291 Total INCOME Total Staffing Expenditure Total Other Expenditure Surplus / (Deficit) excl. Capital 29,288,507 22,387,951 5,839,940 1,060,615 763,338 151,153 690,860 78,676 In the year to date (YTD) view the main focus continues to be on bring the overspends on the other expenditure back in line with the budget. See slides 6 & 9 for more detail.

Income March Month Schools Central Charter Institute The Charter Schools Educational Trust Primary Charles Dickens Primary School Dulwich Hamlet Junior School Loughborough Primary School Lyndhurst Primary School Streatham Wells Primary School The Belham Primary School Secondary The Charter School Bermondsey The Charter School East Dulwich The Charter School North Dulwich Grand Total Actual Budget Variance The table shows income by school & is looking to explain the 379k Favourable monthly variance. 179,103 170,102 9,000 1,729,839 356,756 263,600 308,540 318,328 205,421 277,194 2,535,875 478,862 1,073,266 983,748 4,444,817 83,734 80,400 3,334 1,531,375 347,557 255,147 220,932 271,182 172,342 264,215 2,450,688 437,532 1,051,912 961,244 4,065,797 95,369 89,702 5,666 198,464 9,199 8,453 87,608 47,146 33,079 12,979 85,187 41,330 21,354 22,504 379,020 Note In general we have had confirmation of the latest pupil premium allocations for each school & a number of true ups have resulted in a 62k FAV variance across TCSET. We have also now added the National insurance funding to all schools ( 177k). Also 37k of rates income has been recognised (with equal rates cost). LOU has recognised 30k of rates income (& cost) plus other FAV income exist across CSBG, HNF & self generated income. The FAV 90k in CHI relates to extra income in the Teaching School Note LOU didn t join TCSET until 1 Oct.

Other Expenditure Revised Bud variances Dec 24 YTD Schools Central Charter Institute The Charter Schools Educational Trust Primary Charles Dickens Primary School Dulwich Hamlet Junior School Loughborough Primary School Lyndhurst Primary School Streatham Wells Primary School The Belham Primary School Secondary The Charter School Bermondsey The Charter School East Dulwich The Charter School North Dulwich Grand Total Actual - - Budget - - Variance - - - - - - - - - - - - School Central Charter Institute The Charter Schools Educational Trust Primary Charles Dickens Primary School Dulwich Hamlet Junior School Loughborough Primary School Lyndhurst Primary School Streatham Wells Primary School The Belham Primary School Secondary The Charter School Bermondsey The Charter School East Dulwich The Charter School North Dulwich Total Jan 25 Mth Feb 25 Mth Mar 25 Mth Mar 25 YTD 1,107,317 155,151 1,262,468 2,784,191 536,532 440,084 399,354 525,203 358,754 524,264 4,163,066 901,400 1,697,822 1,563,844 5,839,940 1,091,048 143,850 1,234,898 2,595,658 443,163 380,339 499,051 463,400 304,865 504,840 3,644,470 780,580 1,475,843 1,388,047 5,149,080 16,269 11,301 27,570 188,533 93,369 59,745 99,697 61,803 53,889 19,424 518,596 120,820 221,979 175,797 690,860 - - 8,303 139,083 4,621 116,490 - 2,488 25,957 - 5,131 24,205 - 11,301 27,570 - - - - - 35,851 21,489 106,601 32,527 16,122 - - - - - 29,095 28,387 1,588 26,127 14,498 15,676 7,134 1,608 23,492 4,308 17,230 - 4,711 - - - - - - - - 21,289 8,262 31,983 7,457 6,038 1,914 - - 93,369 59,745 99,697 61,803 - 53,889 - 19,424 - 952 - - - - 61,474 95,946 8,315 313,461 - - - 16,479 88,340 28,449 67,454 34,362 53,284 - 127,363 - 125,700 - 77,229 15,592 68,568 - 184,245 - - 120,820 - 221,979 - 175,797 - 690,860 - Note LOU didn t join TCSET until 1 Oct. The tables show a trend by school of the variances to budget for other expenditure & the YTD position by school v the budget. The rate of over spend has increased again. Only LOU is within budget (even accounting for 11 months of actuals).

Current Forecast Mar 25 Currently the full year forecast (FYF) is showing ADVERSE 642k for the year against the revised budget. Revised Bud 24/25 42,263,424 3,573,936 3,044,777 48,900,137 25,852,068 6,864,320 3,764,336 38,372,640 2,097,414 2,820,232 2,432,037 8,732,777 47,105,417 1,794,720 FORE 24/25 42,216,156 4,275,105 3,285,506 49,807,867 25,814,063 6,625,591 1,068,680 3,731,685 591,263 1,222,195 39,053,478 423,861 2,422,640 2,937,959 2,898,108 391,062 291,379 110,226 9,601,757 48,655,235 1,152,631 Variance - - - - - - - - - - - 1,549,818 - 642,089 - Feb FYF 49,460,633 25,842,604 6,630,908 1,057,538 3,771,685 584,403 1,224,510 39,111,648 462,792 2,403,543 3,061,418 2,815,439 396,038 279,550 111,469 9,643,301 48,754,949 705,684 Variance to Feb 25 - - - - - - - A0 - GAG funding A2 - Other Govt Grants A3 - Private Sector Funding A4 - Other Income Total INCOME B0 - Teaching Staff B1 - Educational Support Staff B2 - Premises Staffing B3 - Admin Staffing B4 - Other Staff B5 - Agency Staff B6 - SLT Staff Costs Total Staffing Expenditure C0 - Maintenance of Premises C1 - Other Occupational Costs D0 - Educational Supplies and Services E0 - Other Supplies and Services F0 - ICT Costs (Non Capital) G0 - Staff Development G1 - Indirect Employees Expenses H0 - Other GAG Expenses L0 - Direct Revenue Financing Total Other Expenditure Total EXPENDITURE Surplus / (Deficit) excl. Capital 47,268 701,169 13,099 240,729 907,730 38,005 238,729 90,002 32,651 36,795 937,015 41,974,322 4,294,876 28,220 3,163,215 241,834 19,771 2,880 122,291 347,234 28,541 5,317 11,142 40,000 6,860 2,315 18,000 31,099 In month the FYF has increased from 705k in Feb 25 to 1,152k. The main improvement being 347k of extra income being due to the full NI funding being recognised ( 178k), the revised PP funding numbers (extra 65k) & extra TSH income ( 85k). 978,678 628,058 285,180 - - - - - 680,838 51,333 325,226 117,727 466,071 45,642 43,754 1,645 31,266 59,868 868,980 58,170 38,931 19,097 123,459 82,669 4,976 11,829 1,243 1,530 15,000 41,544 99,714 446,948 372,528 The staff adverse forecast - 680k is explained as being a smaller issue on the following slide. The focus remains on bring down the other expenditure adverse 0.9m (broadly similar to last month). 436,704 247,625 108,581 110,580 107,076 79,314 47,208 80,844 32,208

Staffing by school Staff Cost Variance - - - - - - - HNF - 1085 Inclusivity Funds - 1070 DFE new funds NI funds -1059 Nursery Expansion Adjusted Variance BPS CDP DHJ LOU LPS SWP CED CND CSB CET CHI 67,156 35,958 53,533 7,868 256,669 39,717 26,044 119,932 103,386 207,291 109,796 - - - - 22,740 33,948 15,000 86,018 109,188 19,252 46,068 42,696 21,000 18,384 24,120 17,268 16,413 20,772 10,884 59,244 41,316 26,652 - - - - - - 26,032 94,026 37,265 110,299 25,681 48,085 39,220 10,688 223,038 207,291 20,388 14,000 101,028 132,000 72,000 89,408 Total - 680,838 149,878 218,000 89,408 235,053 101,028 112,529 Overall the Trust can explain or justify the variance. The overage in CET arises because of the centralisation of the HR team. Note we have also included the National Insurance rise (for all schools) from April 25. The DFE have explained the 5-16 funding but not for EY & 16+. Some schools definitely won t be covered & there will be an annualised extra cost for the Central teams of 39k.

Other Exp Variances explained Nominal Code 3210 - Electricity 5125 - Whole School Subscriptions 4135 - Curriculum Support 4300 - School Fund Expenditure 5000 - Catering 3250 - Rates 5120 - Photocopying / Printing 5151 - Audit/Internal Audit 4010 - Consumables 4150 - Examination Fees 4137 - Peripatetic Music Curriculum Costs 3105 - Cleaning Contract 5310 - IT Managed Services Budget 24/25 FORE 24/25 Variance - - - - - - - - - - - - - Feb FYF Variance - - - The main issue for our delivery of the budget continues to be keeping to the other expenditure budget. The adverse variance has decreased again since last month by 42k. 494,012 227,508 235,069 60,000 1,376,169 71,652 119,256 650,045 379,805 352,847 168,480 1,482,722 146,821 192,971 62,700 56,232 455,664 400,416 876,704 307,605 156,033 152,297 117,778 108,480 106,553 75,169 73,715 62,700 53,676 53,004 51,408 43,220 42,897 616,040 367,640 335,982 168,480 1,512,335 146,821 192,971 62,700 56,232 455,664 400,416 878,432 307,605 34,005 12,165 16,865 - 29,613 - - - - - - - This is the second positive move in the year however as we saw in the in month & year to date numbers there continues to be overspends which calls into question whether the full year forecasts are too optimistic. 2,556 402,660 349,008 833,484 264,708 1,728 - Other 4,296,695 4,068,745 227,950 4,141,983 73,238 As all schools (apart from LOU) continue to be adverse to their FYF. We should now be closing down spend for the year (except for contracted services & key spends) apart from LOU. Total 8,732,777 9,601,757 - 868,980 9,643,301 41,544 Note last year, as we don t have good usage of purchase orders, the lag in closing took a few months to have impact, so starting now would probably finally show benefit in June. Note we need to do this asap as the amount of cash being paid out on other expenditure in Feb & Mar had been accelerating. Either way - work needs to continue to pull these costs back & to better understand the contractual commitments.

FYF Variances by School School BPS CDP DHJ LOU LPS SWP CED CND CSB CET CHI Budget 24/25 FYF 24/25 - - Variance - - - - - - - - - FYF Feb 25 - - Var to Feb FYF - - Comments We are adverse to the FYF by 642k with only 1 school Favourable. 61,262 82,773 60,958 42,636 64,877 42,300 466,726 422,288 63,548 342,261 145,091 1,060 58,946 15,628 94,429 37,096 3,560 203,052 294,234 26,665 256,000 195,337 62,322 23,827 76,586 51,793 27,781 38,740 263,674 128,054 36,883 86,261 50,246 32,296 49,257 422 78,429 11,538 23,332 77,545 245,551 75,538 222,408 105,036 31,236 9,689 16,050 16,000 25,558 19,772 125,507 48,683 102,204 33,592 90,301 LOU continues to be ahead of FYF. CED The positive movement from Feb is due to extra PP income ( 38k) & savings in staffing ( 85k) CSB The positive movement from Feb is due to extra PP & NI funding ( 24k) & savings in teaching cost of 60k. CHI The positive movement is due to extra income in the Teaching school ( 85k). Total 1,794,720 1,152,631 - 642,089 705,684 446,948 Currently only 1 school is on target Loughborough All other schools to close non contractual other expenditure down in order to close the gap to the revised budget.

IT Position at CND [Draft data] Lost Assets categorised by last time it hit the network Replacement Profile categorised by year of purchase Count of Model No. Row Labels Desktop PC iMac Laptop PC Smart Board Grand Total Column Labels Count of Model No. Row Labels Desktop PC iMac Laptop PC Smart Board Grand Total Column Labels 2021 2022 1 2023 65 2024 2025 (blank) Grand Total 24 166 2012 2014 59 2015 219 2024 2025 (blank) Grand Total 30 1 40 5 14 30 60 7 55 40 11 14 120 318 40 111 14 483 9 318 40 111 14 483 9 91 106 1 7 65 33 257 9 59 219 106 Staff Pupil mix categorised by year of purchase Windows 11 Compliance categorised by last time it hit the network Count of Model No. Row Labels Pupil Desktop PC iMac Laptop PC Staff Desktop PC iMac Laptop PC Teacher Desktop PC (blank) Desktop PC Smart Board Grand Total Column Labels Count of Model No. Row Labels N/A iMac Smart Board No Desktop PC Laptop PC Yes Laptop PC Grand Total Column Labels 2012 2014 2015 129 129 2024 21 2025 (blank) Grand Total 30 42 30 37 5 3 2021 2022 2023 2024 2025 (blank) Grand Total 222 159 37 26 108 20 54 40 14 60 55 5 6 6 120 54 40 14 323 318 21 85 1 1 7 7 65 65 24 24 166 166 1 1 19 19 5 3 3 9 9 91 91 257 106 106 483 85 85 2 2 151 137 14 483 2 2 1 7 65 33 8 8 59 59 69 69 15 1 14 60 The picture is still partial but it guides us now to fill in the gaps e.g. All classroom boards & dates of purchase, Change pupil category to classroom, Remove desktops no longer in use, Add names to assets in use by individuals, Start to assess cost of windows 10 issue & the longer term asset replacement cycle. 9 59 219 106 30