Management Accounts: Dec 24 Surplus/Deficits Summary & Analysis

Management Accounts Dec 24 SCHOOLS THAT EXCEL | PEOPLE WHO INSPIRE | PARTNERSHIPS THAT MAKE A DIFFERENCE

Dec 24 Management Accounts Figures represent the surplus/deficits By school 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 Grand Total Actual - - - - Budget - Variance - - - - - 313,679 66,410 60,057 187,212 300,279 Table opposite contains the summary of the surplus/deficits v the budget for Dec 24. 5,489 28,682 23,194 30,480 47,231 22,691 3,264 23,751 16,861 51,393 358,208 61,692 107,427 189,089 394,177 24,666 8,113 16,553 24,703 2,247 2,031 4,346 9,959 1,979 4,141 44,529 4,718 47,370 1,877 93,898 19,177 20,569 39,747 5,777 49,478 20,660 7,610 13,792 18,840 47,252 All schools have benefited as we have caught up with extra income for Budget Grants (extra 148k for Dec month) + the booking of the ECT mentor & mentee grant relating to 23/24 - 92k. The main adverse variances are at; CDP the 3rd party income has had to be reduced (adverse 67k in month) as the run rate is not as expected & the holiday & after school provider has given notice. A drive to ensure billing & collections are up to date has been put in place. SWP is caused by a combination of higher agency costs than budgeted & sundry over spends on other expenditure. CET is mainly caused by 29k of expenditure that was unbudgeted on NFER & MFL consultancy (most of which should be recharged to schools).

Dec 24 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 - - - - 379,768 81,495 296,309 402,062 Table opposite contains the summary of the surplus/deficits v the budget for Dec 24 YTD. 106,522 68,004 38,518 104,129 12,842 16,125 21,214 26,869 7,972 60,736 528,265 59,336 165,112 303,817 738,916 84,468 18,256 66,212 103,889 14,120 8,124 17,384 39,836 7,916 16,509 148,497 22,159 163,148 7,508 336,854 22,054 49,748 27,694 240 26,962 8,001 3,830 12,968 15,888 44,227 Overall the YTD position continues to improve & we are now 400k favourable to the original budget. The adverse positions are due to; CDP the impact of the rebasing of 3rd party income in December. SWP, again the impact of the adverse December performance. LPS whilst adverse by 13k this represents an improvement from a deficit of 27k for the November YTD position. CET the move into a deficit is mainly explained by the NFER & MFL consultancy costs in Dec that weren t cross charged to schools. 1,964

Accounts by Cost Line Dec 24 (month) Actual 4,517,100 3,259,703 863,220 Budget 3,945,659 3,161,885 689,876 Variance 571,441 97,818 - 173,344 - The favourable income variances have improved further as we have uplifted the amounts we are receiving for the Budget Grants (to cover the 5.5% teachers pay rise) now that we have seen the first cash instalments. Income Staff cost Other expenditure Surplus / (Deficit) 394,177 93,898 300,279 The adverse monthly movement on staff costs is mainly caused by the 67k adverse on the agency cost line. Dec 24 (YTD) Actual 16,717,656 12,735,036 3,243,704 Budget 15,782,636 12,671,278 2,774,504 Variance 935,020 63,758 - 469,200 - Income Staff cost Other expenditure Other expenditure whilst slowing down compared to November continues to run ahead of budget. Curriculum expenditure & curriculum support accounting for 137k of that variance in month. CSB was 47k of this adverse but of that 33k was a double count that will be removed in Jan & the adverse 28k on CET mentioned in the Dec month comments. Surplus / (Deficit) 738,916 336,854 402,062

Other Expenditure Note LOU didn t join TCSET until 1 Oct. Other expenditure variances 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 Sep-24 Oct-24 Nov-24 Dec-24 Dec YTD - 5,556 9,695 - 3,599 12,116 - - 9,927 43,928 - - 417 - - 8,387 82,403 40,896 - - - - 11,170 20,600 70,300 9,389 3,959 8,895 - - - 1,951 4,780 68,897 4,786 - - - - - 14,169 5,341 41,946 12,487 13,466 5,493 - - - - - 29,476 6,679 6,178 14,944 18,855 167 - - - - - 56,766 27,840 103,429 41,607 36,206 6,330 74 20,551 - - - 649 21,709 65,542 21,771 164,004 - - - - 93,993 68,035 32,295 330,095 - - - - 1,182 8,921 57,985 173,344 - - - - 74,116 186,762 49,939 466,927 175,349 18,570 127,491 The table shows a trend by school of the variances to budget for other expenditure. Note CND, CDP, LPS & SWP the adverse variances are accelerating. CED is decelerating.

Current Forecast Dec 24 Category 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 Budget 24_25 FORE 24_25 40,797,168 3,555,456 18,000 2,977,288 47,347,912 25,728,553 6,864,321 978,679 3,764,336 628,058 285,180 - 38,249,127 372,528 2,097,432 2,540,244 2,396,214 472,428 247,632 108,588 73,092 107,076 8,415,234 46,664,361 683,551 Variance 1,399,531 475,167 137,502 2,071,364 113,954 - 161,676 28,740 - 60,115 - 32,290 - 609,226 - 682,649 - 28,958 - 292,962 - 435,356 - 309,288 - 37,900 - 26,918 - - 13,184 - 1,140,619 - 1,823,268 - 248,096 Currently the forecast is showing favourable 0.25m for the year against the original budget. 42,196,699 4,030,623 20,011 3,114,790 49,419,276 25,842,507 6,702,645 1,007,419 3,824,451 660,348 894,406 38,931,776 401,486 2,390,394 2,975,600 2,705,502 510,328 274,550 110,398 67,335 120,260 9,555,853 48,487,629 931,647 2,011 If we adjust for the the extra income from CSBG & TPS 16-19 grant the budget target rises to 1.8m. - - Adjusting for that we are then adverse 0.9m. This is mainly caused by Over spends on other expenditure - 1.1m (increased from 843k last month) Staffing - 682k (last month 477k) 1,810 5,757

Staffing by school Schools BPS CDP CED CET CND CSB DHJ LOU LPS SWP CHI Staff cost variance 67,442 - 4,584 - 152,639 - 123,054 - 44,203 - 67,534 - 93,433 - 31,011 133,876 - 16,699 43,594 - High Needs Funds - 1085 - 1/2% funded DFE NI Costs Adjusted Variance - - - - - 22,730 33,949 6,719 10,794 34,730 4,235 31,722 13,778 6,696 5,148 7,784 4,185 2,350 - - - - - - - - - - 6,396 10,585 31,596 50,744 117,909 112,757 67,532 50,974 75,859 65,575 19,812 25,532 28,756 - - 6,062 27,008 11,727 6,882 5,158 7,196 53,004 93,003 3,996 24,259 138,708 46,416 - 70,000 Total variance - 682,649 323,233 128,141 70,000 81,014 - 80,261 Overall the Trust is close to the staffing budget or the variances are explicable/justified. The main issues to be resolved on staffing are in BPS/CED/DHJ/SWP (SWP caused by reduction in High Needs funding). The adverse movement in CET is from moving the HR staff into the central team as part of the new way of working. Note we have also included the National Insurance rise (for most schools) from April 25 which will be over 100k (we expect this to be covered by a new grant yet to be announced hence including in the adjustment above).

Other Exp Variances explained The main issue for our delivery of the budget to target is keeping to the other expenditure budget. The adverse variance has increased since last month by 297k. Category Budget FORECAST Dec 24 VAR Nov 24 VAR Change 4135 - Curriculum Support 3210 - Electricity 5101 - Teaching School Expenditure 5125 - Whole School Subscriptions 5000 - Catering 5120 - Photocopying / Printing 4300 - School Fund Expenditure 3250 - Rates 5601 - Research School Expenditure 3105 - Cleaning Contract 4500 - Counselling 4150 - Examination Fees 7030 - Provisional Write Off 3005 - Repairs & Maintenance 235,068 494,016 2,688 227,508 1,376,169 119,256 30,000 71,652 833,484 58,080 402,672 339,480 393,400 633,608 134,841 325,859 1,473,054 206,931 115,664 146,821 878,435 102,864 445,664 379,876 - - - - - - - - - - - - - - 158,332 139,592 132,153 98,351 96,885 87,675 85,664 75,169 45,650 44,951 44,784 42,992 42,000 40,396 - - - - - - - - - - - - - - 119,597 87,293 130,653 67,447 83,285 12,035 75,004 9,491 45,650 41,951 44,784 43,000 42,000 35,404 - - - - - - - - - - 38,735 52,299 1,500 30,904 13,600 75,640 10,660 65,678 Rates has no impact as there is income to match it off. Electric is across 3 sites & is probably related to optimistic budget assumptions this is less controllable. - 45,650 - 3,000 - 8 - 42,000 - 4,992 Other 4,225,161 4,231,186 - 6,025 - 5,903 - 122 Grand Total 8,415,234 9,555,853 1,140,619 - - 843,497 - 297,122 Areas with more control The increase in the photocopying variance largely due to CND but investigating an offset with their Curriculum exp budget. Whole school subs is mainly CND but we are investigating an offset in the budget with the IT equip forecast. Curriculum support is mainly across 3 sites that did not budget anything on this line.

Variances by School Schools BPS CDP CED CND CSB DHJ LOU LPS SWP CET_CHI Original Budget Adjusted BUD 625 3,531 317,830 18,429 67,615 - 13,829 52,152 9,971 10,378 324,421 FORECAST - - - - VAR to Original Bud - - - - - VAR to Adj BUD - - - - - - - - 61,586 83,359 468,427 423,783 64,173 61,299 42,635 65,247 42,484 488,011 12,092 13,934 287,518 169,418 41,043 53,895 30,524 67,847 8,045 526,123 11,467 17,465 30,312 150,989 26,572 67,724 82,676 57,876 2,333 201,702 49,494 97,293 180,909 254,365 105,216 115,194 73,159 2,600 34,439 38,112 Total 683,551 1,801,005 931,647 248,096 - 869,358 The current variance to the original budget is favourable 0.25m & is shown by school. The adjusted budget ( 1.8m) is shown (after reflecting the extra CSBG & TPS funding). The variance to the adjusted budget is ADVERSE 0.9m. All schools are working through plans to close the gap to the revised budget.

Benchmarking Benchmarks Benchmarks Primary Single value Source Secondary Single value Benchmarks & targets circulated to all schools. Lower Upper Lower Upper Oct 24 census NOR missing 5-16 Revenue missing NOR v PAN % (5-16) 23/24 DFE data ave class size prim 26.6 / sec 22.4 Staff cost/total income Plus central costs (exc CHI) sub total 75% 78% 72% 75% SRMA template - Oct 23 Reviewing via management accounts meetings. Teacher cost /grant income Plus central costs (exc CHI) sub total 45.8% 54.7% From SFB data 2122 Support cost /grant income (inc midday supervisors) Supp cost (excl music & Nursery) 18.6% 9.2% From SFB data 2122 Next Friday focus on where you vary most? how can you use this? what help do you need to take any actions? Non teaching /total income Plus central costs (exc CHI) sub total 11.1% 10.1% From SFB data 2122 Other expenditure/total income Oth exp excl Central contribution 20.6% 18.3% Average of TCSET Nov 24 payroll Teachers/ support FTE ratio 0.83 0.22 2223 Workforce census Nov 24 payroll & Oct 24 census Pupil teacher ratio 22 24 17 18 SRMA template - Oct 23 Nov 24 payroll Nov 24 payroll Ratio of Leaders/UPS to Mainscale (base on FTE) Average teacher cost (with on cost/excl TLRs) To be determined - suggest 50% Need latest benchmark view 2024 modelling 2024 modelling 2024 modelling ICFP contact ratio KS3 bonus % (curriculum bonus) KS4 bonus % (curriculum bonus) 0.76 0.78 SRMA template - Oct 23