{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Income","Funding","Expenditure","Header","Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":65,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Income","index":0,"n_rows":119,"n_cols":9,"rows_kept":119,"cut":false,"hidden":false,"merged":[[5,6,6,6],[64,2,64,3],[52,1,52,3],[63,2,63,3],[62,1,62,8],[46,2,46,3],[48,1,48,3],[51,2,51,3],[56,1,56,3],[54,1,54,8],[58,1,58,8],[55,2,55,3],[59,2,59,3],[23,2,23,3],[24,2,24,3],[21,1,21,8],[22,2,22,3],[26,1,26,3],[40,2,40,3],[35,2,35,3],[29,2,29,3],[31,2,31,3],[28,1,28,8],[37,2,37,3],[5,9,5,11],[5,5,6,5],[5,4,6,4],[9,2,9,3],[60,1,60,3],[47,2,47,3],[50,1,50,8],[45,1,45,8],[10,1,10,3],[13,2,13,3],[8,2,8,3],[5,7,6,7],[43,1,43,3],[42,2,42,3],[33,2,33,3],[41,2,41,3],[0,1,0,8],[39,2,39,3],[2,2,2,3],[5,1,6,1],[5,2,6,3],[38,2,38,3],[36,2,36,3],[32,2,32,3],[30,2,30,3],[2,6,2,8],[5,8,6,8],[17,2,17,3],[18,1,18,3],[16,1,16,3],[14,1,14,3],[34,2,34,3],[77,1,77,3],[70,1,70,3],[75,1,75,3],[74,2,74,3],[65,1,65,3],[73,1,73,3],[67,1,67,3],[72,1,72,3]]}
[null,"\nBudget Plan - Income  2020/21"]
[]
[null,"School","Please select school",null,null,"Cost Centre",{"$f":"IF($C$3=\"\",\"\",VLOOKUP(C3,B:J,3,0))","v":0}]
[]
[]
[null,"Oracle Object Code","Description",null,"Fund 06\nOther Capital","Fund 01 School Budget","Fund 01\nOther Funding","Total Budget","Comments"]
[]
[null,"I01 Funds Delegated by the LEA"]
[null,null,"School Standards Grant (SSG)",null,0,0,0,{"$f":"ROUND(SUM(E9:G9),0)","v":0}]
[null,null,"Threshold Reimbursement",null,0,0,0,{"$f":"ROUND(SUM(E10:G10),0)","v":0}]
[null,"Funds Delegated by the LEA Sub Total",null,null,{"$f":"SUM(E9:E10)","v":0},{"$f":"SUM(F9:F10)","v":0},{"$f":"SUM(G9:G10)","v":0},{"$f":"SUM(H9:H10)","v":0}]
[]
[null,"I04 Ethnic Minority Achievement"]
[null,null,"Ethnic Minority Achievement",null,0,0,0,{"$f":"ROUND(SUM(E14:G14),0)","v":0}]
[null,"Ethnic Minority Achievement Sub Total",null,null,{"$f":"SUM(E14)","v":0},{"$f":"SUM(F14)","v":0},{"$f":"SUM(G14)","v":0},{"$f":"SUM(H14)","v":0}]
[]
[null,"I05 Pupil Premium"]
[null,null,"Pupil Premium",null,0,0,0,{"$f":"ROUND(SUM(E18:G18),0)","v":0}]
[null,"Pupil Premium Sub Total",null,null,{"$f":"SUM(E18:E18)","v":0},{"$f":"SUM(F18:F18)","v":0},{"$f":"SUM(G18:G18)","v":0},{"$f":"SUM(H18:H18)","v":0}]
[]
[]
[null,"I07 Other Grants and Payments Received"]
[null,"8093","Other Grants",null,null,null,null,{"$f":"ROUND(SUM(E23:G23),0)","v":0}]
[null,"8179","Fees & Charges - Outside Bodies ",null,null,null,null,{"$f":"ROUND(SUM(E24:G24),0)","v":0}]
[null,"8103","Fees & Charges - Academies",null,null,null,null,0]
[null,"8106","Fees and Charges - Maintained schools",null,null,null,null,0]
[null,"Other Grants and Payments Received Sub Total",null,null,null,{"$f":"SUM(F23:F26)","v":0},{"$f":"SUM(G23:G26)","v":0},{"$f":"SUM(H23:H26)","v":0}]
[]
[null,"I08 Income from Facilities & Services"]
[null,"8115","Sales General",null,null,null,null,{"$f":"ROUND(SUM(E30:G30),0)","v":0}]
[null,"8150","Fees & Charges - Hire of Equipment",null,null,null,null,0]
[null,"8191","Fees & Charges - Legal Court Costs",null,null,null,null,0]
[null,"8169","Fees & Charges After School/Breakfast Club",null,null,null,null,0]
[null,"8173","Fees & Charges - Schools Departmental Sales",null,null,null,null,0]
[null,"8174","Student Teacher Income",null,null,null,null,0]
[null,"8175","Fees & Charges - Schools Music Activities",null,null,null,null,0]
[null,"8170","Fees & Charges - Schools",null,null,null,null,0]
[null,"8177","Fees & Charges - Schools Adults in Schools",null,null,null,null,0]
[null,"8447","Rents",null,null,null,null,0]
[null,"8176","Fees & Charges - Schools Lettings",null,null,null,null,0]
[null,"8465","Other Miscellaneous Income (nv)",null,null,null,null,0]
[null,"8504","Interest Received",null,null,null,null,0]
[null,"8451","Rents service - Tenancy",null,null,null,null,0]
[null,"Income from Facilities & Services Sub Total",null,null,null,{"$f":"SUM(F30:F43)","v":0},{"$f":"SUM(G30:G43)","v":0},{"$f":"SUM(H30:H43)","v":0}]
[]
[null,"I09 Income from Catering"]
[null,"8140","Sales - Food/Drink/Cater - Adults",null,null,null,null,{"$f":"ROUND(SUM(E47:G47),0)","v":0}]
[null,"8144","Sales - Food/Drink/Cater - Pupils",null,null,null,null,{"$f":"ROUND(SUM(E48:G48),0)","v":0}]
[null,"Income from Catering Sub Total",null,null,null,{"$f":"SUM(F47:F48)","v":0},{"$f":"SUM(G47:G48)","v":0},0]
[]
[null,"I10 Receipts from Supply Teacher insurance Claims"]
[null,"1330","Staff Absence Insurance Receipts - Teacher",null,null,null,null,{"$f":"ROUND(SUM(E52:G52),0)","v":0}]
[null,"Receipts from Supply Teacher insurance Claims Sub Total",null,null,null,{"$f":"SUM(F52:F52)","v":0},{"$f":"SUM(G52:G52)","v":0},{"$f":"SUM(H52:H52)","v":0}]
[]
[null,"I11 Receipts from Other Insurance Claims"]
[null,"8172","Insurance Receipts - Other",null,null,null,null,{"$f":"ROUND(SUM(E56:G56),0)","v":0}]
[null,"Receipts from Other Insurance Claims Sub Total",null,null,null,{"$f":"SUM(F56:F56)","v":0},{"$f":"SUM(G56:G56)","v":0},{"$f":"SUM(H56:H56)","v":0}]
[]
[null,"I12 Income from Contributions to Visits"]
[null,"8171","Fees & Charges Schools - School Trip Income",null,null,null,null,{"$f":"ROUND(SUM(E60:G60),0)","v":0}]
[null,"Income from Contributions to Visits Sub Total",null,null,null,{"$f":"SUM(F60)","v":0},{"$f":"SUM(G60)","v":0},{"$f":"SUM(H60)","v":0}]
[]
[null,"I13 Donations and/or Private funds"]
[null,"8095","Donations spent in school",null,null,null,null,{"$f":"ROUND(SUM(E64:G64),0)","v":0}]
[null,"8003","DfE Grant Funding",null,null,null,null,{"$f":"ROUND(SUM(E65:G65),0)","v":0}]
[null,"Donations and/or Private funds Sub Total",null,null,null,{"$f":"SUM(F64:F65)","v":0},{"$f":"SUM(G64:G65)","v":0},{"$f":"SUM(H64:H65)","v":0}]
[]
[]
[]
[]
[null,"Total Revenue Income",null,null,null,{"$f":"F11+F15+F19+F27+F44+F49+F53+F57+F61+F66+F68","v":0},{"$f":"G11+G15+G19+G27+G44+G49+G53+G57+G61+G66+G68","v":0},{"$f":"H11+H15+H19+H27+H44+H49+H53+H57+H61+H66+H68","v":0}]
[]
[null,"Capital Income"]
[null,"CI01 Capital Income"]
[null,"8005","Other Capital Grant Income",null,null,null,null,{"$f":"ROUND(SUM(E75:G75),0)","v":0}]
[null,"Capital Income Sub Total",null,null,{"$f":"SUM(E75)","v":0},{"$f":"SUM(F75)","v":0},{"$f":"SUM(G75)","v":0},{"$f":"SUM(H75)","v":0}]
[]
[null,"Total Income",null,null,{"$f":"E71+E76","v":0},{"$f":"F71+F76","v":0},{"$f":"G71+G76","v":0},{"$f":"H71+H76","v":0}]
[]
[]
[]
[]
[]
[]
[null,"School Names",null,"Cost Centre"]
[null,"Please select school"]
[null,"Bentinck Primary",null,85021]
[null,"Berridge Primary",null,85050]
[null,"Cantrell Primary And Nursery",null,85022]
[null,"Carrington Primary",null,85023]
[null,"Claremont Primary",null,85024]
[null,"Crab Tree Farm Primary",null,85025]
[null,"Dovecote Primary School",null,85026]
[null,"Dunkirk Primary",null,85027]
[null,"Fernwood Primary",null,85052]
[null,"Forest Fields Primary",null,85028]
[null,"Glade Hill Primary",null,85029]
[null,"Greenfields Primary School",null,85030]
[null,"Haydn Primary And Nursery",null,85031]
[null,"Heathfield Primary",null,85032]
[null,"Hempshill Hall Primary",null,85033]
[null,"Henry Whipple Primary",null,85034]
[null,"Hospital & Home Education",null,85009]
[null,"Melbury Primary",null,85035]
[null,"Mellers Primary And Nursery",null,85036]
[null,"Middleton Primary",null,85037]
[null,"Nottingham Nursery",null,85020]
[null,"Oak Field Special",null,85000]
[null,"Rise Park Primary",null,85038]
[null,"Robin Hood Primary",null,85039]
[null,"Rosehill Special",null,85001]
[null,"Rufford Primary",null,85040]
[null,"Seely Primary",null,85051]
[null,"Snape Wood Primary",null,85041]
[null,"Southglade Primary",null,85043]
[null,"Southwold Primary And Nursery",null,85044]
[null,"Walter Halls Primary And Nursery",null,85046]
[null,"Welbeck Primary",null,85047]
[null,"Westglade Primary",null,85048]

{"sheet":"Funding","index":1,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[30,1,30,4],[9,1,9,4],[11,1,11,4],[18,1,18,4],[17,1,17,8],[13,1,13,5],[13,7,13,8],[15,1,15,4],[14,1,14,8],[12,1,12,4],[26,7,26,8],[28,1,28,5],[20,1,20,4],[21,1,21,4],[25,1,25,4],[28,7,28,8],[26,1,26,5],[24,1,24,4],[22,1,22,4],[23,1,23,4],[2,1,2,2],[6,1,6,4],[10,1,10,4],[0,1,0,8],[7,1,7,4],[8,1,8,4],[19,1,19,4],[4,1,4,4],[5,1,5,4],[3,1,3,8],[16,1,16,5],[16,7,16,8]]}
[null,"Funding  2020/21"]
[]
[null,"Funding",null,{"$f":"IF(Income!$C$3=\"\",\"\",Income!C3)","v":"Please select school"},{"$f":"Income!G3","v":0},"CFR Category","Amount £","Evidence needed","Comments"]
[null,"Revenue Funding"]
[null,"School Budget - DSG ",null,null,null,"I01"]
[null,"Early Years",null,null,null,"I01"]
[null,"Teachers Pay Grant",null,null,null,"I01"]
[null,"High Needs",null,null,null,"I03"]
[null,"Pupil Premium",null,null,null,"I05"]
[null,"Early Years Pupil Premium Funding",null,null,null,"I05"]
[null,"Teachers Pension Grant",null,null,null,"I18"]
[null,"PE and Sports Grant",null,null,null,"I18"]
[null,"Additional Grant for schools (UIFSM)",null,null,null,"I18"]
[null,"Total Revenue Funding",null,null,null,null,{"$f":"SUM(G5:G13)","v":0},null,null,null,{"$f":"IF(H5=\"Yes\",1,\"\")","v":""}]
[null,"Capital Funding",null,null,null,null,null,null,null,null,{"$f":"IF(H6=\"Yes\",1,\"\")","v":""}]
[null,"Capital Grant ",null,null,null,"CI01",null,null,null,null,{"$f":"IF(H8=\"Yes\",1,\"\")","v":""}]
[null,"Total Capital Funding",null,null,null,null,{"$f":"G16","v":0},null,null,null,{"$f":"IF(H9=\"Yes\",1,\"\")","v":""}]
[null,"Additional Funding*",null,null,null,null,null,null,null,null,{"$f":"IF(H15=\"Yes\",1,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(B19=\"\",\"\",VLOOKUP(B19,$B$37:$C$45,2,FALSE))","v":""},null,{"$f":"IF(G19>14999,\"Y\",\"\")","v":""},null,null,""]
[null,null,null,null,null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,$B$37:$C$45,2,FALSE))","v":""},null,{"$f":"IF(G20>14999,\"Y\",\"\")","v":""},null,null,""]
[null,null,null,null,null,"",null,"",null,null,""]
[null,null,null,null,null,"",null,"",null,null,""]
[null,null,null,null,null,"",null,"",null,null,""]
[null,null,null,null,null,"",null,"",null,null,""]
[null,null,null,null,null,"",null,"",null,null,""]
[null,null,null,null,null,"",null,"",null,null,""]
[null,"Total Additional Funding",null,null,null,null,{"$f":"SUM(G19:G26)","v":0},null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,"Total Funding",null,null,null,null,{"$f":"SUM(G14,G17,G27)","v":0},null,null,null,""]
[]
[null,"* Please note that evidence is only required for additional funding"]
[]
[]
[]
[]
[null,"Additional Funding","Code"]
[null,"KS1 Funding","I01"]
[null,"Exceptional Circumstances Grant","I01"]
[null,"Other","I06"]
[null,"Pathfinder Grant","I06"]
[null,"Pupil Premium","I05"]
[null,"High Needs","I03"]
[null,"Tamhs Funding","I06"]
[null,"Transitional Funding","I01"]

{"sheet":"Expenditure","index":2,"n_rows":247,"n_cols":10,"rows_kept":247,"cut":false,"hidden":false,"merged":[[70,2,70,3],[66,1,66,3],[59,2,59,3],[39,2,39,3],[53,2,53,3],[54,2,54,3],[64,2,64,3],[62,2,62,3],[94,1,94,9],[55,2,55,3],[65,2,65,3],[50,2,50,3],[63,2,63,3],[60,2,60,3],[69,2,69,3],[73,2,73,3],[87,2,87,3],[88,2,88,3],[92,1,92,3],[40,2,40,3],[56,1,56,3],[58,1,58,9],[49,2,49,3],[48,2,48,3],[244,1,244,3],[241,2,241,3],[242,1,242,3],[238,1,238,3],[240,1,240,9],[235,1,235,3],[237,2,237,3],[180,2,180,3],[179,2,179,3],[194,2,194,3],[195,2,195,3],[197,1,197,3],[182,1,182,3],[185,2,185,3],[186,1,186,3],[222,1,222,9],[223,2,223,3],[224,1,224,3],[221,1,221,9],[206,2,206,3],[205,1,205,9],[203,1,203,3],[189,2,189,3],[191,1,191,3],[0,1,0,9],[25,1,25,9],[18,1,18,9],[7,1,7,9],[5,1,6,1],[5,2,6,3],[5,5,6,5],[23,1,23,3],[2,7,2,9],[11,2,11,3],[2,2,2,4],[21,2,21,3],[20,2,20,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[43,2,43,3],[42,2,42,3],[212,1,212,3],[236,1,236,9],[230,1,230,3],[228,1,228,3],[227,2,227,3],[226,1,226,9],[61,2,61,3],[76,1,76,3],[72,2,72,3],[232,1,232,3],[214,1,214,9],[215,2,215,3],[218,2,218,3],[217,2,217,3],[216,2,216,3],[211,2,211,3],[220,1,220,3],[210,2,210,3],[209,2,209,3],[202,2,202,3],[208,2,208,3],[207,2,207,3],[200,2,200,3],[193,1,193,9],[199,1,199,9],[157,2,157,3],[158,1,158,3],[154,2,154,3],[71,2,71,3],[116,1,116,3],[118,1,118,9],[109,2,109,3],[110,2,110,3],[75,2,75,3],[74,2,74,3],[176,2,176,3],[171,2,171,3],[169,2,169,3],[156,2,156,3],[168,1,168,9],[172,2,172,3],[173,2,173,3],[170,2,170,3],[153,2,153,3],[155,2,155,3],[160,1,160,9],[201,2,201,3],[96,1,96,3],[188,1,188,9],[184,1,184,9],[175,2,175,3],[181,2,181,3],[80,1,80,7],[78,1,78,3],[85,2,85,3],[89,2,89,3],[90,2,90,3],[84,1,84,9],[178,2,178,3],[95,2,95,3],[111,1,111,3],[145,1,145,3],[120,2,120,3],[122,2,122,3],[113,1,113,9],[190,2,190,3],[152,2,152,3],[164,1,164,9],[162,1,162,3],[177,2,177,3],[165,2,165,3],[161,2,161,3],[174,2,174,3],[246,1,246,7],[26,2,26,3],[30,2,30,3],[36,1,36,9],[34,1,34,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[143,2,143,3],[132,2,132,3],[139,1,139,9],[83,1,83,9],[108,2,108,3],[104,1,104,3],[142,2,142,3],[144,2,144,3],[68,1,68,9],[150,2,150,3],[140,2,140,3],[149,2,149,3],[148,2,148,3],[102,1,102,9],[151,2,151,3],[133,1,133,3],[51,2,51,3],[47,1,47,9],[5,8,6,8],[5,6,6,6],[5,4,6,4],[5,7,6,7],[8,2,8,3],[9,2,9,3],[45,1,45,3],[41,2,41,3],[5,9,6,9],[15,2,15,3],[22,2,22,3],[33,2,33,3],[44,2,44,3],[10,2,10,3],[31,2,31,3],[32,2,32,3],[38,2,38,3],[19,2,19,3],[16,1,16,3],[219,2,219,3],[196,2,196,3],[52,2,52,3],[100,1,100,3],[121,2,121,3],[98,1,98,9],[115,2,115,3],[99,2,99,3],[103,2,103,3],[107,2,107,3],[137,1,137,3],[141,2,141,3],[119,2,119,3],[131,2,131,3],[130,2,130,3],[127,1,127,3],[129,1,129,9],[125,1,125,9],[123,1,123,3],[106,1,106,9],[136,2,136,3],[147,1,147,9],[135,1,135,9],[126,2,126,3]]}
[null,"\nBudget Plan - Expenditure 2020/21"]
[]
[null,"School",{"$f":"IF(Income!$C$3=\"\",\"\",Income!C3)","v":"Please select school"},null,null,null,"Cost Centre",{"$f":"Income!G3","v":0}]
[]
[]
[null,"Oracle Object Code","Description",null,"Pupil Premium","Sports and PE Grant","Fund 01 School Budget","Fund 01 Other Funding","Total Budget","Comments"]
[]
[null,"E01 Teaching Staff"]
[null,"E011000","Teaching Staff Basic Pay",null,null,null,null,null,{"$f":"ROUND(SUM(E9:H9),0)","v":0}]
[null,"E011001","Teaching Staff National Insurance",null,null,null,null,null,{"$f":"ROUND(SUM(E10:H10),0)","v":0}]
[null,"E011002","Teaching Staff Superannuation",null,null,null,null,null,{"$f":"ROUND(SUM(E11:H11),0)","v":0}]
[null,"E011003","Teaching Staff Overtime",null,null,null,null,null,{"$f":"SUM(E12:H12)","v":0}]
[null,"E011005","Teaching Staff Allowances",null,null,null,null,null,{"$f":"SUM(E13:H13)","v":0}]
[null,"E011007","Teaching Staff Pay Protection",null,null,null,null,null,0]
[null,"E011010","Teaching Staff Redundancy",null,null,null,null,null,0]
[null,"E011011","Teaching Staff Apprenticeship Levy",null,null,null,null,null,{"$f":"SUM(E16:H16)","v":0}]
[null,"Teaching Staff Sub Total ",null,null,{"$f":"SUM(E9:E16)","v":0},{"$f":"SUM(F9:F16)","v":0},{"$f":"SUM(G9:G16)","v":0},{"$f":"SUM(H9:H16)","v":0},{"$f":"SUM(I9:I16)","v":0}]
[]
[null,"E02 Supply Staff"]
[null,"E021000","Supply Teachers Basic Pay",null,null,null,null,null,{"$f":"ROUND(SUM(E20:H20),0)","v":0}]
[null,"E021001","Supply Teachers National Insurance",null,null,null,null,null,{"$f":"ROUND(SUM(E21:H21),0)","v":0}]
[null,"E021002","Supply Teachers Superannuation",null,null,null,null,null,{"$f":"ROUND(SUM(E22:H22),0)","v":0}]
[null,"E021011","Supply Teachers Apprenticeship Levy",null,null,null,null,null,{"$f":"ROUND(SUM(E23:H23),0)","v":0}]
[null,"Supply Staff Sub Total",null,null,{"$f":"SUM(E20:E23)","v":0},{"$f":"SUM(F20:F23)","v":0},0,0,0]
[]
[null,"E03 Education Support Staff"]
[null,"E031000","Education Support Staff Basic Pay",null,null,null,null,null,{"$f":"ROUND(SUM(E27:H27),0)","v":0}]
[null,"E031001","Education Support Staff National Insurance",null,null,null,null,null,0]
[null,"E031002","Education Support Staff Superannuation",null,null,null,null,null,0]
[null,"E031003","Education Support Staff Overtime",null,null,null,null,null,0]
[null,"E031005","Education Support Allowances",null,null,null,null,null,0]
[null,"E031007","Education Support Pay Protection",null,null,null,null,null,0]
[null,"E031010","Education Support Redundancy",null,null,null,null,null,0]
[null,"E031011","Education Support  Apprenticeship Levy",null,null,null,null,null,0]
[null,"Education Support Staff Sub Total",null,null,{"$f":"SUM(E27:E34)","v":0},{"$f":"SUM(F27:F34)","v":0},{"$f":"SUM(G27:G34)","v":0},{"$f":"SUM(H27:H34)","v":0},{"$f":"SUM(I27:I34)","v":0}]
[]
[null,"E04 Premises Staff"]
[null,"E041000","Premises Related Staff Basic Pay",null,null,null,null,null,{"$f":"ROUND(SUM(E38:H38),0)","v":0}]
[null,"E041001","Premises Related Staff National Insurance",null,null,null,null,null,0]
[null,"E041002","Premises Related Staff Superannuation",null,null,null,null,null,0]
[null,"E041003","Premises Related Staff Overtime",null,null,null,null,null,{"$f":"ROUND(SUM(E41:H41),0)","v":0}]
[null,"E041005","Premises Related Staff Allowances",null,null,null,null,null,{"$f":"ROUND(SUM(E42:H42),0)","v":0}]
[null,"E041007","Premises Related Staff Pay Protection",null,null,null,null,null,{"$f":"ROUND(SUM(E43:H43),0)","v":0}]
[null,"E041010","Premises Related Staff Redundancy",null,null,null,null,null,{"$f":"ROUND(SUM(E44:H44),0)","v":0}]
[null,"E041011","Premises Related Staff  Apprenticeship Levy",null,null,null,null,null,0]
[null,"Premises Staff Sub Total",null,null,{"$f":"SUM(E38:E45)","v":0},{"$f":"SUM(F38:F45)","v":0},0,0,0]
[]
[null,"E05 Administrative and Clerical Staff"]
[null,"E051000","Admin and Clerical Pay",null,null,null,null,null,{"$f":"ROUND(SUM(E49:H49),0)","v":0}]
[null,"E051001","Admin and Clerical National Insurance",null,null,null,null,null,0]
[null,"E051002","Admin and Clerical Superannuation",null,null,null,null,null,0]
[null,"E051003","Admin and Clerical Overtime",null,null,null,null,null,0]
[null,"E051005","Admin and Clerical Allowances",null,null,null,null,null,0]
[null,"E051007","Admin and Clerical Pay Protection",null,null,null,null,null,0]
[null,"E051010","Admin and Clerical Redundancy",null,null,null,null,null,0]
[null,"E051011","Admin  and Clerical Apprenticeship Levy",null,null,null,null,null,0]
[null,"Administrative and Clerical Staff Sub Total",null,null,{"$f":"SUM(E49:E56)","v":0},{"$f":"SUM(F49:F56)","v":0},{"$f":"SUM(G49:G56)","v":0},{"$f":"SUM(H49:H56)","v":0},{"$f":"SUM(I49:I56)","v":0}]
[]
[null,"E06 Catering Staff"]
[null,"E061000","Catering Staff Basic Pay",null,null,null,null,null,{"$f":"ROUND(SUM(E60:H60),0)","v":0}]
[null,"E061001","Catering Staff National Insurance",null,null,null,null,null,{"$f":"ROUND(SUM(E61:H61),0)","v":0}]
[null,"E061002","Catering Staff Superannuation",null,null,null,null,null,0]
[null,"E061003","Catering Staff Overtime",null,null,null,null,null,0]
[null,"E061005","Catering Staff Allowances",null,null,null,null,null,0]
[null,"E061010","Catering Staff Redundancy",null,null,null,null,null,{"$f":"ROUND(SUM(E65:H65),0)","v":0}]
[null,"E061011","Catering Staff Apprenticeship Levy",null,null,null,null,null,{"$f":"ROUND(SUM(E66:H66),0)","v":0}]
[null,"Catering Staff Sub Total",null,null,{"$f":"SUM(E60:E66)","v":0},{"$f":"SUM(F60:F66)","v":0},{"$f":"SUM(G60:G66)","v":0},{"$f":"SUM(H60:H66)","v":0},{"$f":"SUM(I60:I66)","v":0}]
[]
[null,"E07 Cost of Other Staff"]
[null,"E071000","Other Staff Groups Basic Pay",null,null,null,null,null,{"$f":"ROUND(SUM(E70:H70),0)","v":0}]
[null,"E071001","Other Staff Groups National Insurance",null,null,null,null,null,0]
[null,"E071002","Other Staff Groups Superannuation",null,null,null,null,null,0]
[null,"E071003","Other Staff Groups Overtime",null,null,null,null,null,0]
[null,"E071005","Other Staff Groups Allowances",null,null,null,null,null,0]
[null,"E071010","Other Staff Groups Redundancy",null,null,null,null,null,0]
[null,"E071011","Other Staff Groups  Apprenticeship Levy",null,null,null,null,null,0]
[null,"Cost of Other Staff Sub Total",null,null,{"$f":"SUM(E70:E76)","v":0},{"$f":"SUM(F70:F76)","v":0},{"$f":"SUM(G70:G76)","v":0},{"$f":"SUM(H70:H76)","v":0},{"$f":"SUM(I70:I76)","v":0}]
[]
[null,"Payroll Expenditure",null,null,{"$f":"E17+E24+E35+E46+E57+E67+E77","v":0},0,{"$f":"G17+G24+G35+G46+G57+G67+G77","v":0},{"$f":"H17+H24+H35+H46+H57+H67+H77","v":0},0]
[]
[null,"Payroll Expenditure (% of Budget)",null,null,null,null,null,null,{"$f":"IF(ISERROR(I79/Header!G22),0,I79/Header!G22)","v":0}]
[]
[]
[null,"Non Pay Expenditure"]
[null,"E08 Indirect Employee Expenses"]
[null,"3060","Staff Travel",null,null,null,null,null,{"$f":"ROUND(SUM(E86:H86),0)","v":0}]
[null,"1902","Staff Health Expenses",null,null,null,null,null,0]
[null,"1900","External Recruitment Expenses",null,null,null,null,null,0]
[null,"1410","Labour Recharges (through payroll)",null,null,null,null,null,0]
[null,"3050","Mileage claims (through payroll)",null,null,null,null,null,0]
[null,"3055","Parking claims (through payroll)",null,null,null,null,null,0]
[null,"1904","Staff General Expenses (through payroll)",null,null,null,null,null,0]
[null,"Indirect Employee Exp Sub Total",null,null,{"$f":"SUM(E86:E92)","v":0},{"$f":"SUM(F86:F92)","v":0},{"$f":"SUM(G86:G92)","v":0},{"$f":"SUM(H86:H92)","v":0},{"$f":"SUM(I86:I92)","v":0}]
[]
[null,"E09 Development & Training"]
[null,"1903","Training Costs",null,null,null,null,null,{"$f":"ROUND(SUM(E96:H96),0)","v":0}]
[null,"Development & Training Sub Total",null,null,{"$f":"SUM(E96)","v":0},{"$f":"SUM(F96)","v":0},{"$f":"SUM(G96)","v":0},{"$f":"SUM(H96)","v":0},{"$f":"SUM(I96)","v":0}]
[]
[null,"E10 Supply Teacher Insurance"]
[null,"4282","Insurance Charges Teacher Insurance",null,null,null,null,null,{"$f":"ROUND(SUM(E100:H100),0)","v":0}]
[null,"Supply Teacher Insurance Sub Total",null,null,{"$f":"SUM(E100)","v":0},{"$f":"SUM(F100)","v":0},{"$f":"SUM(G100)","v":0},{"$f":"SUM(H100)","v":0},{"$f":"SUM(I100)","v":0}]
[]
[null,"E11 Staff Related Insurance"]
[null,"4280","Insurance Charges Other Staff",null,null,null,null,null,{"$f":"ROUND(SUM(E104:H104),0)","v":0}]
[null,"Staff Related Insurance Sub Total",null,null,{"$f":"SUM(E104)","v":0},{"$f":"SUM(F104)","v":0},{"$f":"SUM(G104)","v":0},{"$f":"SUM(H104)","v":0},{"$f":"SUM(I104)","v":0}]
[]
[null,"E12 Building Maintenance and Improvement"]
[null,"2000","Planned Repairs and Maintenance Buildings",null,null,null,null,null,{"$f":"ROUND(SUM(E108:H108),0)","v":0}]
[null,"2005","Day to Day Maintenance",null,null,null,null,null,{"$f":"ROUND(SUM(E109:H109),0)","v":0}]
[null,"2060","Fixtures and Fittings",null,null,null,null,null,{"$f":"ROUND(SUM(E110:H110),0)","v":0}]
[null,"2061","Health and Safety Equipment",null,null,null,null,null,{"$f":"ROUND(SUM(E111:H111),0)","v":0}]
[null,"Building Maintenance and Improvement Sub Total",null,null,{"$f":"SUM(E108:E111)","v":0},{"$f":"SUM(F108:F111)","v":0},{"$f":"SUM(G108:G111)","v":0},{"$f":"SUM(H108:H111)","v":0},{"$f":"SUM(I108:I111)","v":0}]
[]
[null,"E13 Grounds Maintenance and Improvement"]
[null,6067,"Grounds Maintenance (LA)",null,null,null,null,null,{"$f":"ROUND(SUM(E115:H115),0)","v":0}]
[null,"2084","Grounds Maintenance",null,null,null,null,null,{"$f":"ROUND(SUM(E116:H116),0)","v":0}]
[null,"Grounds Maintenance and Improvement Sub Total",null,null,{"$f":"SUM(E115:E116)","v":0},{"$f":"SUM(F115:F116)","v":0},0,0,0]
[]
[null,"E14 Cleaning & Caretaking"]
[null,"4003","Cleaning Equipment",null,null,null,null,null,{"$f":"ROUND(SUM(E120:H120),0)","v":0}]
[null,"2072","Building Cleaning",null,null,null,null,null,{"$f":"ROUND(SUM(E121:H121),0)","v":0}]
[null,"6061","Building Cleaning (LA)",null,null,null,null,null,{"$f":"ROUND(SUM(E122:H122),0)","v":0}]
[null,"6062","Window Cleaning (LA)",null,null,null,null,null,{"$f":"ROUND(SUM(E123:H123),0)","v":0}]
[null,"Cleaning & Caretaking Sub Total",null,null,{"$f":"SUM(E120:E123)","v":0},{"$f":"SUM(F120:F123)","v":0},{"$f":"SUM(G120:G123)","v":0},{"$f":"SUM(H120:H123)","v":0},{"$f":"SUM(I120:I123)","v":0}]
[]
[null,"E15 Water & Sewerage"]
[null,"2050","Water charges",null,null,null,null,null,{"$f":"ROUND(SUM(E127:H127),0)","v":0}]
[null,"E15 Water & Sewerage Sub Total",null,null,{"$f":"SUM(E127)","v":0},{"$f":"SUM(F127)","v":0},{"$f":"SUM(G127)","v":0},{"$f":"SUM(H127)","v":0},{"$f":"SUM(I127)","v":0}]
[]
[null,"E16 Energy"]
[null,"2020","Electricity",null,null,null,null,null,{"$f":"ROUND(SUM(E131:H131),0)","v":0}]
[null,"2022","Gas",null,null,null,null,null,{"$f":"ROUND(SUM(E132:H132),0)","v":0}]
[null,"2024","Other Fuel Costs",null,null,null,null,null,{"$f":"ROUND(SUM(E133:H133),0)","v":0}]
[null,"Energy Sub Total",null,null,{"$f":"SUM(E131:E133)","v":0},{"$f":"SUM(F131:F133)","v":0},{"$f":"SUM(G131:G133)","v":0},{"$f":"SUM(H131:H133)","v":0},{"$f":"SUM(I131:I133)","v":0}]
[]
[null,"E17 Rates"]
[null,"2040","Business Rates",null,null,null,null,null,{"$f":"ROUND(SUM(E137:H137),0)","v":0}]
[null,"E17 Rates Sub Total",null,null,{"$f":"SUM(E137)","v":0},{"$f":"SUM(F137)","v":0},{"$f":"SUM(G137)","v":0},{"$f":"SUM(H137)","v":0},{"$f":"SUM(I137)","v":0}]
[]
[null,"E18 Other Occupation Costs"]
[null,"2004","Security/Health Safety",null,null,null,null,null,{"$f":"ROUND(SUM(E141:H141),0)","v":0}]
[null,"2031","Room Hire",null,null,null,null,null,{"$f":"ROUND(SUM(E142:H142),0)","v":0}]
[null,"2062","Fire Alarms",null,null,null,null,null,{"$f":"ROUND(SUM(E143:H143),0)","v":0}]
[null,"2073","Refuse",null,null,null,null,null,{"$f":"ROUND(SUM(E144:H144),0)","v":0}]
[null,"6065","Refuse (LA)",null,null,null,null,null,{"$f":"ROUND(SUM(E145:H145),0)","v":0}]
[null,"Other Occupation Costs Sub Total",null,null,{"$f":"SUM(E141:E145)","v":0},{"$f":"SUM(F141:F145)","v":0},0,0,0]
[]
[null,"E19 Learning Resources"]
[null,"3041","Transport Contract Hire",null,null,null,null,null,{"$f":"ROUND(SUM(E149:H149),0)","v":0}]
[null,"3015","Repairs & Maintenance Vehicles",null,null,null,null,null,0]
[null,"3000","Fuel",null,null,null,null,null,0]
[null,"3020","Road Licences (incl MOT)",null,null,null,null,null,0]
[null,"4250","School Trips",null,null,null,null,null,0]
[null,"3065","Transport Client, Service User, Volunteers",null,null,null,null,null,0]
[null,"4066","Photocopying",null,null,null,null,null,0]
[null,"4007","Learning Resources, Materials",null,null,null,null,null,0]
[null,"4024","Learning Resources, Books",null,null,null,null,null,0]
[null,"7020","Operating Lease Payments",null,null,null,null,null,0]
[null,"Learning Resources Sub Total",null,null,{"$f":"SUM(E149:E158)","v":0},{"$f":"SUM(F149:F158)","v":0},{"$f":"SUM(G149:G158)","v":0},{"$f":"SUM(H149:H158)","v":0},{"$f":"SUM(I149:I158)","v":0}]
[]
[null,"E20 ICT Learning Resources"]
[null,"4096","ICT Learning Resources (incl TV License)",null,null,null,null,null,{"$f":"ROUND(SUM(E162:H162),0)","v":0}]
[null,"ICT Learning Resources Sub Total",null,null,{"$f":"SUM(E162)","v":0},{"$f":"SUM(F162)","v":0},{"$f":"SUM(G162)","v":0},{"$f":"SUM(H162)","v":0},{"$f":"SUM(I162)","v":0}]
[]
[null,"E21 Exam Fees"]
[null,"4167","Exam Fees",null,null,null,null,null,{"$f":"ROUND(SUM(E166:H166),0)","v":0}]
[null,null,"Exam Fees Sub Total",null,{"$f":"SUM(E166)","v":0},{"$f":"SUM(F166)","v":0},{"$f":"SUM(G166)","v":0},{"$f":"SUM(H166)","v":0},{"$f":"SUM(I166)","v":0}]
[]
[null,"E22 Administrative Supplies"]
[null,"4060","Printing",null,null,null,null,null,{"$f":"ROUND(SUM(E170:H170),0)","v":0}]
[null,"4063","Stationery and Office Supplies",null,null,null,null,null,0]
[null,"4080","Postal Services",null,null,null,null,null,0]
[null,"4082","Telephones",null,null,null,null,null,0]
[null,"4083","Mobile Phones",null,null,null,null,null,0]
[null,"4090","IT Equipment Hardware",null,null,null,null,null,0]
[null,"4093","IT Equipment Maintenance",null,null,null,null,null,0]
[null,"4091","IT Equipment Software",null,null,null,null,null,0]
[null,"4000","Furniture",null,null,null,null,null,0]
[null,"4001","Admin Equipment (incl First Aid)",null,null,null,null,null,0]
[null,"4011","Books, Newspapers & Periodicals",null,null,null,null,null,0]
[null,"4025","Administrative materials",null,null,null,null,null,0]
[null,"4220","Bank Charges",null,null,null,null,null,0]
[null,"Administrative Supplies Sub Total",null,null,{"$f":"SUM(E170:E182)","v":0},{"$f":"SUM(F170:F182)","v":0},{"$f":"SUM(G170:G182)","v":0},{"$f":"SUM(H170:H182)","v":0},{"$f":"SUM(I170:I182)","v":0}]
[]
[null,"E23 Other Insurance Premiums"]
[null,"2092","Premises Insurance",null,null,null,null,null,{"$f":"ROUND(SUM(E186:H186),0)","v":0}]
[null,"Other Insurance Premiums Sub Total",null,null,{"$f":"SUM(E186)","v":0},{"$f":"SUM(F186)","v":0},{"$f":"SUM(G186)","v":0},{"$f":"SUM(H186)","v":0},{"$f":"SUM(I186)","v":0}]
[]
[null,"E24 Special Facilities"]
[null,"4050","Protective Clothing, Uniforms",null,null,null,null,null,{"$f":"ROUND(SUM(E190:H190),0)","v":0}]
[null,"4124","Hospitality",null,null,null,null,null,{"$f":"ROUND(SUM(E191:H191),0)","v":0}]
[null,"Special Facilities Sub Total",null,null,{"$f":"SUM(E190:E191)","v":0},{"$f":"SUM(F190:F191)","v":0},{"$f":"SUM(G190:G191)","v":0},{"$f":"SUM(H190:H191)","v":0},{"$f":"SUM(I190:I191)","v":0}]
[]
[null,"E25 Catering Supplies"]
[null,"4013","Catering Provisions",null,null,null,null,null,{"$f":"ROUND(SUM(E195:H195),0)","v":0}]
[null,"4041","Schools Catering - Pupils Meals",null,null,null,null,null,{"$f":"ROUND(SUM(E196:H196),0)","v":0}]
[null,"4042","Schools Catering - Adults Meals",null,null,null,null,null,{"$f":"ROUND(SUM(E197:H197),0)","v":0}]
[null,"Catering Supplies Sub Total",null,null,{"$f":"SUM(E195:E197)","v":0},{"$f":"SUM(F195:F197)","v":0},0,0,0]
[]
[null,"E26 Agency Supply Staff"]
[null,"1320","Agency Supply Teachers - General",null,null,null,null,null,{"$f":"ROUND(SUM(E201:H201),0)","v":0}]
[null,"1321","Agency Supply Teachers - Sickness",null,null,null,null,null,{"$f":"ROUND(SUM(E202:H202),0)","v":0}]
[null,"1322","Agency Supply Teachers - Training",null,null,null,null,null,{"$f":"ROUND(SUM(E203:H203),0)","v":0}]
[null,"Agency Supply Staff Sub Total",null,null,{"$f":"SUM(E201:E203)","v":0},{"$f":"SUM(F201:F203)","v":0},{"$f":"SUM(G201:G203)","v":0},{"$f":"SUM(H201:H203)","v":0},{"$f":"SUM(I201:I203)","v":0}]
[]
[null,"E27 Brought in Prof Services - Curriculum"]
[null,"1305","Agency Supply Staff",null,null,null,null,null,{"$f":"ROUND(SUM(E207:H207),0)","v":0}]
[null,"6045","Educational Support Service Curriculum",null,null,null,null,null,0]
[null,"4165","Library Service",null,null,null,null,null,0]
[null,"6046","Swimming",null,null,null,null,null,0]
[null,"6047","Music Tuition",null,null,null,null,null,0]
[null,"6050","School Development",null,null,null,null,null,0]
[null,"Brought in Prof Services - Curriculum Sub Total",null,null,{"$f":"SUM(E207:E212)","v":0},{"$f":"SUM(F207:F212)","v":0},{"$f":"SUM(G207:G212)","v":0},{"$f":"SUM(H207:H212)","v":0},{"$f":"SUM(I207:I212)","v":0}]
[]
[null,"E28A Brought in Prof Services - Other"]
[null,"6015","Human Resources",null,null,null,null,null,{"$f":"ROUND(SUM(E216:H216),0)","v":0}]
[null,"6051","Support Services (incl Clerking)",null,null,null,null,null,0]
[null,"6048","Managing Administration",null,null,null,null,null,0]
[null,"6049","Premises Management",null,null,null,null,null,0]
[null,"6052","Charges from Other Maintained Schools",null,null,null,null,null,0]
[null,"Brought in Prof Services - Other Sub Total",null,null,{"$f":"SUM(E216:E220)","v":0},{"$f":"SUM(F216:F220)","v":0},{"$f":"SUM(G216:G220)","v":0},{"$f":"SUM(H216:H220)","v":0},{"$f":"SUM(I216:I220)","v":0}]
[]
[null,"E28B Brought in Prof Services - Other (PFI)"]
[null,null,"Private Finance Initiative (PFI)",null,null,null,null,null,{"$f":"ROUND(SUM(E224:H224),0)","v":0}]
[null,"Brought in Prof Services - Other (PFI)Sub Total",null,null,{"$f":"SUM(E224)","v":0},{"$f":"SUM(F224)","v":0},{"$f":"SUM(G224)","v":0},{"$f":"SUM(H224)","v":0},{"$f":"SUM(I224)","v":0}]
[]
[null,"E29 Loan Payments & Interest "]
[null,"7006","Interest Payable",null,null,null,null,null,{"$f":"ROUND(SUM(E228:H228),0)","v":0}]
[null,"Loan Interest Sub Total",null,null,{"$f":"SUM(E228)","v":0},{"$f":"SUM(F228)","v":0},{"$f":"SUM(G228)","v":0},{"$f":"SUM(H228)","v":0},{"$f":"SUM(I228)","v":0}]
[]
[null,"Non Pay Revenue Expenditure",null,null,{"$f":"E93+E97+E101+E105+E112+E117+E124+E128+E134+E138+E146+E159+E163+E167+E183+E187+E192+E198+E204+E213+E221+E229+E225","v":0},0,{"$f":"G93+G97+G101+G105+G112+G117+G124+G128+G134+G138+G146+G159+G163+G167+G183+G187+G192+G198+G204+G213+G221+G229+G225","v":0},{"$f":"H93+H97+H101+H105+H112+H117+H124+H128+H134+H138+H146+H159+H163+H167+H183+H187+H192+H198+H204+H213+H221+H229+H225","v":0},0]
[]
[null,"Total Revenue Expenditure",null,null,{"$f":"E231+E79","v":0},{"$f":"F231+F79","v":0},{"$f":"G231+G79","v":0},{"$f":"H231+H79","v":0},{"$f":"I231+I79","v":0}]
[]
[]
[null,"Capital Expenditure",null,null,"Fund 06 other capital","Fund 76 devolved capital",null,null,"Total Budget"]
[null,"CE02 New Construction, Conversion & Renovation"]
[null,"2003","Devolved Capital Building Works",null,null,null,null,null,{"$f":"ROUND(SUM(E238:H238),0)","v":0}]
[null,"New Construction, Conversion & Renovation Sub Total",null,null,{"$f":"SUM(E238:E238)","v":0},{"$f":"SUM(F238:F238)","v":0},{"$f":"SUM(G238:G238)","v":0},{"$f":"SUM(H238:H238)","v":0},{"$f":"SUM(I238:I238)","v":0}]
[]
[null,"CE04 Information & Communication Technology"]
[null,"4094","IT Equipment Hardware",null,null,null,null,null,{"$f":"ROUND(SUM(E242:H242),0)","v":0}]
[null,"Information & Communication Technology Sub Total",null,null,{"$f":"SUM(E242)","v":0},{"$f":"SUM(F242)","v":0},{"$f":"SUM(G242)","v":0},{"$f":"SUM(H242)","v":0},{"$f":"SUM(I242)","v":0}]
[]
[null,"Total Capital Expenditure",null,null,{"$f":"E239+E243","v":0},{"$f":"F239+F243","v":0},{"$f":"G239+G243","v":0},{"$f":"H239+H243","v":0},{"$f":"I239+I243","v":0}]
[]
[null,"Grand Total Expenditure",null,null,null,null,null,null,{"$f":"I233+I245","v":0}]

{"sheet":"Header","index":3,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[[65,1,65,6],[58,1,58,6],[48,3,48,5],[50,3,50,5],[64,1,64,6],[63,1,63,6],[60,1,60,6],[56,1,56,6],[54,4,54,5],[57,1,57,6],[52,3,52,5],[0,1,0,2],[2,5,2,6],[55,3,55,5],[4,5,4,6],[16,1,16,4],[9,1,9,4],[3,5,3,6],[10,1,10,4],[43,1,43,6],[13,1,13,4],[45,1,46,6],[20,1,20,4],[12,1,12,4]]}
[null,"\nHeader  2020/21"]
[]
[null,null,null,null,"School: ",{"$f":"IF(Income!$C$3=\"\",\"\",Income!$C$3)","v":"Please select school"}]
[null,null,null,null,"Produced by: "]
[null,null,null,null,"Date: "]
[]
[null,"Budget Summary",null,null,null,null,"£"]
[]
[null,"Revenue Budget"]
[null,"School Budget - DSG (I01)",null,null,null,null,{"$f":"Funding!G5","v":0}]
[null,"Early Years (I01)",null,null,null,null,{"$f":"Funding!G6","v":0}]
[null,"Teachers Pay Grant (I01)",null,null,null,null,{"$f":"Funding!G7","v":0}]
[null,"High Needs (I03)",null,null,null,null,{"$f":"Funding!G8","v":0}]
[null,"Pupil Premium (I05)",null,null,null,null,{"$f":"Funding!G9+Funding!G10","v":0}]
[null,"Teachers Pension Grant (I18)",null,null,null,null,{"$f":"Funding!G11","v":0}]
[null,"PE and Sports Grant (I18)",null,null,null,null,{"$f":"Funding!G12","v":0}]
[null,"Additional Grant for schools (I18)",null,null,null,null,{"$f":"Funding!G13","v":0}]
[null,"Total Delegated School Funding",null,null,null,null,{"$f":"SUM(G10:G17)","v":0}]
[null,"Additional Funding",null,null,null,null,{"$f":"Funding!G27","v":0}]
[null,"Total Revenue Funding",null,null,null,null,{"$f":"SUM(G18,G19)","v":0}]
[null,"Other Revenue Income",null,null,null,null,{"$f":"Income!H71","v":0}]
[null,"Total Revenue Income",null,null,null,null,{"$f":"G20+G21","v":0}]
[null,"Pay Expenditure",null,null,null,null,{"$f":"Expenditure!I79","v":0}]
[null,"Non Pay Expenditure",null,null,null,null,{"$f":"Expenditure!I231","v":0}]
[null,"Total Revenue Expenditure",null,null,null,null,{"$f":"Expenditure!I233","v":0}]
[null,"In Year Revenue Surplus/(Deficit)",null,null,null,null,{"$f":"G22-G25","v":0}]
[null,"Revenue Carry Forward From Previous Year ",null,null,null,null,0]
[null,"Projected Revenue Surplus/(Deficit) at Year End",null,null,null,null,{"$f":"G26+G27","v":0}]
[]
[null,"Capital Budget"]
[null,"Devolved Capital Funding - Fund 76 (CI01)",null,null,null,null,{"$f":"Funding!G16","v":0}]
[null,"Other Capital Income",null,null,null,null,{"$f":"Income!H76","v":0}]
[null,"Total Capital Income",null,null,null,null,{"$f":"SUM(G31:G32)","v":0}]
[null,"New Construction, Conversion & Renovation Expenditure (CI01-CI04)",null,null,null,null,{"$f":"Expenditure!I245","v":0}]
[null,"Total Capital Expenditure ",null,null,null,null,{"$f":"G34","v":0}]
[null,"In Year Capital Surplus/(Deficit)",null,null,null,null,{"$f":"G33-G35","v":0}]
[null,"Devolved Capital Carry Forward From Previous Year",null,null,null,null,0]
[null,"Projected Capital Surplus/(Deficit) at Year End",null,null,null,null,{"$f":"SUM(G36:G37)","v":0}]
[]
[null,"Total Projected Surplus/(Deficit) at Year end",null,null,null,null,{"$f":"G28+G38","v":0}]
[]
[]
[]
[null,"Declaration:"]
[]
[null,"To the best of my knowledge this is an accurate year-end projection of the financial position of the school, including all actual, committed and planned expenditure and known income."]
[]
[]
[null,null,"Headteacher's Name: "]
[]
[null,null,"Signature: "]
[]
[null,null,"Date: "]
[]
[null,"Approved at Governing Body Meeting held on:"]
[]
[null,"Once completed please email an electronic copy of this budget plan to School Finance via:"]
[null,"schools.finance@nottinghamcity.gov.uk"]
[null,"together with a signed & scanned copy of this header sheet."]
[]
[null,"Please return this form by 1st May 2020"]

{"sheet":"Summary","index":4,"n_rows":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":false,"merged":[[53,2,53,6],[51,2,51,6],[50,2,50,6],[49,2,49,6],[48,2,48,6],[47,2,47,6],[46,2,46,6],[45,2,45,6],[44,2,44,6],[43,2,43,6],[6,1,6,7],[22,1,22,6],[24,1,24,7],[39,2,39,6],[33,2,33,6],[8,2,8,6],[32,2,32,6],[31,2,31,6],[35,2,35,6],[38,2,38,6],[37,2,37,6],[30,2,30,6],[29,2,29,6],[28,2,28,6],[12,2,12,6],[11,2,11,6],[21,2,21,6],[26,2,26,6],[25,2,25,6],[66,1,66,6],[54,2,54,6],[64,1,64,6],[58,1,58,6],[60,2,60,6],[61,2,61,6],[62,2,62,6],[55,1,55,6],[36,2,36,6],[42,2,42,6],[41,2,41,6],[52,2,52,6],[40,2,40,6],[0,1,0,2],[15,2,15,6],[27,2,27,6],[34,2,34,6],[7,2,7,6],[10,2,10,6],[9,2,9,6],[20,2,20,6],[19,2,19,6],[14,2,14,6],[13,2,13,6],[18,2,18,6],[17,2,17,6],[16,2,16,6],[2,3,2,5],[3,3,3,5]]}
[null,"\nSummary 2020/21"]
[]
[null,null,null,{"$f":"IF(Income!$C$3=\"\",\"\",Income!$C$3)","v":"Please select school"},null,null,"Produced by:  ",{"$f":"IF(Header!F4=\"\",\"\",Header!F4)","v":""}]
[null,null,null,"Consistent Financial Reporting Summary",null,null,"Date: ",{"$f":"IF(Header!F5=\"\",\"\",Header!F5)","v":""}]
[]
[null,null,null,null,null,null,null,"Amount (£)"]
[null,"Revenue Income"]
[null,"I01","Funds delegated by the local authority",null,null,null,null,{"$f":"SUMIF(Funding!$F$5:$F$26,Summary!B8,Funding!$G$5:$G$26)","v":0}]
[null,"I02","Funding for sixth form students",null,null,null,null,{"$f":"SUMIF(Funding!$F$5:$F$26,B9,Funding!$G$5:$G$26)","v":0}]
[null,"I03","Special educational needs funding",null,null,null,null,{"$f":"SUMIF(Funding!$F$5:$F$26,B10,Funding!$G$5:$G$26)","v":0}]
[null,"I04","Funding for minority ethnic pupils",null,null,null,null,{"$f":"SUMIF(Funding!$F$5:$F$26,B11,Funding!$G$5:$G$26)","v":0}]
[null,"I05","Pupil Premium",null,null,null,null,{"$f":"SUMIF(Funding!$F$5:$F$26,B12,Funding!$G$5:$G$26)","v":0}]
[null,"I06","Other government grants",null,null,null,null,{"$f":"SUMIF(Funding!$F$5:$F$26,B13,Funding!$G$5:$G$26)","v":0}]
[null,"I07","Other grants and payments received",null,null,null,null,{"$f":"Income!H27","v":0}]
[null,"I08","Income from facilities and services",null,null,null,null,{"$f":"Income!H44","v":0}]
[null,"I09","Income from catering",null,null,null,null,{"$f":"Income!H49","v":0}]
[null,"I10","Receipts from supply teacher insurance claims",null,null,null,null,{"$f":"Income!H53","v":0}]
[null,"I11","Receipts from other insurance claims",null,null,null,null,{"$f":"Income!H57","v":0}]
[null,"I12","Income from contributions to visits",null,null,null,null,{"$f":"Income!H61","v":0}]
[null,"I13","Donations and/or voluntary funds",null,null,null,null,{"$f":"Income!H66","v":0}]
[null,"I14","SSG Pupil Focused",null,null,null,null,{"$f":"Income!H68","v":0}]
[null,"I18","Additional grant for schools",null,null,null,null,{"$f":"Header!G17+Header!G16+Header!G15","v":0}]
[null,"Total Revenue Income",null,null,null,null,null,{"$f":"SUM(H8:H22)","v":0}]
[]
[null,"Revenue Expenditure"]
[null,"E01","Teaching staff",null,null,null,null,{"$f":"Expenditure!I17","v":0}]
[null,"E02","Supply teaching staff",null,null,null,null,{"$f":"Expenditure!I24","v":0}]
[null,"E03","Education support staff",null,null,null,null,{"$f":"Expenditure!I35","v":0}]
[null,"E04","Premises staff",null,null,null,null,{"$f":"Expenditure!I46","v":0}]
[null,"E05","Administrative and clerical staff",null,null,null,null,{"$f":"Expenditure!I57","v":0}]
[null,"E06","Catering staff",null,null,null,null,{"$f":"Expenditure!I67","v":0}]
[null,"E07","Cost of other staff",null,null,null,null,{"$f":"Expenditure!I77","v":0}]
[null,"E08","Indirect employee expenses",null,null,null,null,{"$f":"Expenditure!I93","v":0}]
[null,"E09","Staff development and training",null,null,null,null,{"$f":"Expenditure!I97","v":0}]
[null,"E10","Supply teacher insurance",null,null,null,null,{"$f":"Expenditure!I101","v":0}]
[null,"E11","Staff related insurance",null,null,null,null,{"$f":"Expenditure!I105","v":0}]
[null,"E12","Building maintenance and improvement",null,null,null,null,{"$f":"Expenditure!I112","v":0}]
[null,"E13","Grounds maintenance and improvement",null,null,null,null,{"$f":"Expenditure!I117","v":0}]
[null,"E14","Cleaning and caretaking",null,null,null,null,{"$f":"Expenditure!I124","v":0}]
[null,"E15","Water and sewage",null,null,null,null,{"$f":"Expenditure!I128","v":0}]
[null,"E16","Energy",null,null,null,null,{"$f":"Expenditure!I134","v":0}]
[null,"E17","Rates ",null,null,null,null,{"$f":"Expenditure!I138","v":0}]
[null,"E18","Other occupation costs",null,null,null,null,{"$f":"Expenditure!I146","v":0}]
[null,"E19","Learning resources",null,null,null,null,{"$f":"Expenditure!I159","v":0}]
[null,"E20","ICT learning resources",null,null,null,null,{"$f":"Expenditure!I163","v":0}]
[null,"E21","Examination fees",null,null,null,null,{"$f":"Expenditure!I167","v":0}]
[null,"E22","Administrative supplies",null,null,null,null,{"$f":"Expenditure!I183","v":0}]
[null,"E23","Other insurance premiums",null,null,null,null,{"$f":"Expenditure!I187","v":0}]
[null,"E24","Special facilities",null,null,null,null,{"$f":"Expenditure!I192","v":0}]
[null,"E25","Catering supplies",null,null,null,null,{"$f":"Expenditure!I198","v":0}]
[null,"E26","Agency supply teaching staff",null,null,null,null,{"$f":"Expenditure!I204","v":0}]
[null,"E27","Bought-in professional services - curriculum",null,null,null,null,{"$f":"Expenditure!I213","v":0}]
[null,"E28A","Bought-in professional services - other",null,null,null,null,{"$f":"Expenditure!I221","v":0}]
[null,"E28B","Bought-in professional services - other (PFI)",null,null,null,null,{"$f":"Expenditure!I225","v":0}]
[null,"E29","Loan interest",null,null,null,null,{"$f":"Expenditure!I229","v":0}]
[null,"Total Revenue Expenditure",null,null,null,null,null,{"$f":"SUM(H26:H55)","v":0}]
[null,null,"In Year Revenue Surplus/(Deficit)",null,null,null,null,{"$f":"H23-H56","v":0}]
[null,"B01 + B02","Revenue Carry Forward From Previous Year",null,null,null,null,{"$f":"Header!G27","v":0}]
[null,"Projected Revenue Surplus/(Deficit)",null,null,null,null,null,{"$f":"H57+H58","v":0}]
[]
[null,"CI01","Capital income",null,null,null,null,{"$f":"Income!H76+SUMIF(Funding!$F$5:$F$26,B61,Funding!$G$5:$G$26)","v":0}]
[null,"CE02","New construction, conversion and renovation",null,null,null,null,{"$f":"Expenditure!I239","v":0}]
[null,"CE04","Information and communication technology",null,null,null,null,{"$f":"Expenditure!I243","v":0}]
[null,"B03","Devolved Capital Carry Forward From Previous Year",null,null,null,null,{"$f":"Header!G37","v":0}]
[null,"Projected Capital Surplus/(Deficit)",null,null,null,null,null,{"$f":"H61-H62-H63+H64","v":0}]
[]
[null,"Total Projected Surplus/(Deficit)",null,null,null,null,null,{"$f":"H59+H65","v":0}]