{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Budget 23-24","Precept 23-24"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Budget 23-24","index":0,"n_rows":98,"n_cols":13,"rows_kept":98,"cut":false,"hidden":false,"merged":[[19,0,19,1],[23,7,23,8],[24,7,24,8],[25,7,25,8]]}
[]
["Income",null,"BUDGET 23 - 24",{"$nulls":4},"RESERVES @ 30/11/22"]
[1000,"Grants received",20000,{"$nulls":4},"General Fund",null,null,null,{"$f":"311083+48260-90000","v":269343}]
[1001,"Miscellaneous Income",0,{"$nulls":4},"Earmarked reserves",null,null,null,354139]
[1002,"Christmas Lights Income",0,{"$nulls":5},"Election Fund",null,null,null,4000]
[1003,"Donations received",0,{"$nulls":5},"Staff Sickness",null,null,null,2500]
[1004,"CAP Salary",{"$f":"9931/12*5","v":4137.916666666667},{"$nulls":5},"Bells Contingency",null,null,null,40000]
[1010,"Room Hire",500,{"$nulls":5},"Environment",null,null,null,4139]
[1020,"KGV Hire",1500,{"$nulls":5},"Bells Boardwalk",null,null,null,13500]
[1050,"Burial Income",0,{"$nulls":5},"Capital purchase",null,null,null,200000]
[1080,"Mayor's Charity",0,{"$nulls":5},"Clock Tower",null,null,null,75000]
[1081,"Bells Field Income",0,{"$nulls":5},"Cemetery expansion",null,null,null,15000]
[1100,"Investment Revaluation",0,{"$nulls":8},{"$f":"SUM(L3:L12)","v":623482}]
[1176,"Precept Received",465000]
[1190,"Interest Received",0,{"$nulls":4},"Predicted excess Income / Expenditure",null,null,null,{"$f":"SUM(C18-C98)","v":-185872.08333333331}]
[1191,"TIC Income",4500]
[1200,"NDP Locality Grant",10000,{"$nulls":4},"TOTAL Predicted Reserves at 1/4/23",null,null,null,{"$f":"SUM(L13+L15)","v":437609.91666666669}]
[null,null,{"$f":"SUM(C3:C17)","v":505637.91666666669}]
[]
["Expenditure",null,"BUDGET 23 - 24"]
[4000,"Staff Salaries",109000]
[4001,"Employers N I",6650]
[4002,"Employers Pension Cont.",15850]
[4004,"Staff Sickness Reserve",500]
[4008,"Training and Conferences",3000]
[4009,"Office Maintenance",1000]
[4010,"Office Improvements",500,{"$nulls":4},"CH",1000,{"$f":"I27/37*32","v":864.8648648648649}]
[4011,"Office Rent",12500,{"$nulls":4},"LS",2000,{"$f":"I28/37*34.75","v":1878.3783783783786}]
[4012,"Youth Building",5000]
[4013,"Office Business Rates",4650,{"$nulls":4},"EB",500,{"$f":"I30/37*12","v":162.16216216216216}]
[4014,"Office Household Supplies",2200,{"$nulls":4},"LJ",500,{"$f":"I31/37*15","v":202.70270270270271}]
[4015,"Office Utilities",8000,{"$nulls":4},"JP",500,{"$f":"(I32/37*15)/12*5","v":84.459459459459453}]
[4016,"Window Cleaning",460]
[4017,"Website",500]
[4020,"Refreshments and Entertaining",200]
[4021,"Telephone & Broadband",2500]
[4022,"Post",200]
[4023,"Photocopying",2700]
[4024,"Subscriptions",3700]
[4025,"Insurance",10500]
[4026,"Stationery",1700]
[4030,"Recruitment Advertising",250]
[4031,"General Advertising",600]
[4032,"Statutory Advertising",250]
[4033,"Chairman's Allowance",200]
[4034,"Election Charges",11000]
[4035,"Travelling Expenses",150]
[4037,"Council Newsletter",1000]
[4038,"Town Events Leaflet",1600]
[4039,"NDP",10000]
[4050,"Bank Charges",100]
[4057,"Audit",1500]
[4058,"Professional Fees",28000]
[4070,"Civic Expenditure",1000]
[4075,"Mayor's Charity",0]
[4081,"No 4 Lords Hill Rent",8500]
[4082,"No 4 Lords Hill Utilities",2200]
[4083,"No 4 Business Rates",1200]
[4084,"Emergency Plan",250]
[4100,"CCTV Maintenance & Purchase",6100]
[4101,"No 4 Improvements",250]
[4102,"SLA Grant CAB",5000]
[4103,"Grants",10000]
[4104,"Twinning Project",7000]
[4107,"Promotion Video",500]
[4110,"Town Guide",1000]
[4125,"Section 137 Payments",0]
[4149,"Street Furniture Purchase",1000]
[4151,"Office Equipment",3000]
[4153,"Street Furniture Maintenance",500]
[4175,"Clock Tower Maintenance",85000]
[4176,"Clock Tower Utilities",2800]
[4200,"Bells Field Improvements",25000]
[4201,"Bells Field Maintenance",42000]
[4210,"KGV Utilities",2000]
[4211,"KGV Maintenance",5000]
[4212,"KGV Improvements",10000]
[4226,"Cemetery Utilities",2200]
[4228,"Cemetery Grave Expenditure",4000]
[4230,"Cemetery Maintenance",10000]
[4231,"Cemetery Improvements",20000]
[4249,"TIC Expenditure",2000]
[4250,"TIC Goods",2500]
[4251,"Town Centre Flower Contract",8500]
[4252,"Events",78000]
[4253,"Town Centre Maintenance",1500]
[4258,"Town Centre Improvements",25000]
[4259,"Environment",10000]
[4274,"Parish Maintenance ",15500]
[4275,"Bus Shelter Maintenance",7250]
[4276,"Bus Shelter Purchase",7000]
[4278,"Covid-19 Fund",0]
[4279,"Parish Improvements ",5000]
[4280,"Grass Cutting Community Areas",7800]
[4281,"Play Area Inspection and Maintenance",7500]
[4282,"Promotion Items",500]
[4305,"SLA Youth Association",12000]
[null,null,{"$f":"SUM(C21:C97)","v":691510}]

{"sheet":"Precept 23-24","index":1,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Precept"]
[]
["2022/23","Actual",450000,null,"Yr on Yr % Variance exc. Taxbase",null,"With Taxbase",null,null,null,{"$f":"SUM(C4-C3)","v":15000}]
["2023/24","Proposal",465000,null,{"$f":"SUM(K3/C3)","v":3.3333333333333333E-2},{"$f":"SUM((C4/2988.95)/A9)*100","v":100.73215231658834},{"$f":"SUM(F4-100)","v":0.73215231658834057},null,"Total budget - income and £185,872 from reserves*"]
[{"$nulls":8},"*or consideration of a Public Works Loan"]
[]
["2022/23","2023/24",null,null,"Examples:",null,"%",null,"Total Budgeted Expenditure - £691,510",null,null,855212]
[2913.71,2988.95,"Taxbase",null,"£425K",{"$f":"SUM((425000/2988.95)/154.44)*100","v":92.068376917571456},{"$f":"SUM(F8-100)","v":-7.9316230824285441},null,"Budgeted income - £40,638 plus precept of £465,000",null,null,10638,{"$f":"L7-(L8+L9)","v":379574}]
[154.44227462582069,{"$f":"SUM(C4/2988.95)","v":155.57302731728535},"D Band",null,"£430K",{"$f":"SUM((430000/2988.95)/154.44)*100","v":93.151534293072288},-6.8484657069277119,null,"Shortfall - £185,872",null,null,465000]
[{"$nulls":4},"£435K",{"$f":"SUM((435000/2988.95)/154.44)*100","v":94.234691668573149},-5.7653083314268514]
[null,{"$f":"SUM(B9-A9)/52","v":2.1745244066628162E-2},"per week",null,"£440K",{"$f":"SUM((440000/2988.95)/154.44)*100","v":95.317849044073981},-4.6821509559260193,null,"At 3.33% rise cost per week is £0.02- 2p/week"]
[{"$nulls":4},"£445K",{"$f":"SUM((445000/2988.95)/154.44)*100","v":96.401006419574827},-3.5989935804251729]
[{"$nulls":4},"£450K",{"$f":"SUM((450000/2988.95)/154.44)*100","v":97.484163795075659},-2.5158362049243408]
[{"$nulls":4},"£455K",{"$f":"SUM((455000/2988.95)/154.44)*100","v":98.567321170576506},{"$f":"SUM(F14-100)","v":-1.4326788294234944}]
[{"$nulls":4},"£460K",{"$f":"SUM((460000/2988.95)/154.44)*100","v":99.650478546077338},{"$f":"SUM(F15-100)","v":-0.34952145392266232}]
[]
[]
[{"$nulls":4},"0% = £450,000"]