{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["1 Cont","5 Grss Exp","6 Grss Inc","7 Net Exp","8-9 Summary","10 FTEs","11 Heads","12 Crp Res Obj","13 Crp Res Exp","14 Crp Res Inc","15 Econ Obj","16 Econ Exp","17 Econ Inc","18-19 Peop Obj","20-21 Peop Exp","22-23 Peop Inc","24 Place Obj","25 Place Exp","26 Place Inc","29-33 Cap Prog","34 Cap Pru"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":142,"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":"1 Cont","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Contents",null,"Page"]
[]
["A city with 2020 vision",null,"2-3"]
["Revenue Expenditure",null,4]
["Summary - Gross Expenditure",null,5]
["Summary - Gross Income",null,6]
["Summary - Net Expenditure",null,7]
["Summary by type of expenditure/income ",null,"8-9"]
["Employee Numbers",null,"10-11"]
[]
["Directorate Budget Analysis:"]
[]
[]
["Corporate Resources",null,"12-14"]
["Economy",null,"15-17"]
["People",null,"18-23"]
["Place",null,"24-26"]
[]
["Council Tax",null,"27-28"]
["Capital Expenditure",null," 29-34"]
["Glossary",null," 35-36"]

{"sheet":"5 Grss Exp","index":1,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Revenue Budget for City Council Services - Gross Expenditure"]
[]
[null,null,"Adjusted"]
[null,null,"2015/16",null,"2016/17"]
[null,null,"Budget",null,"Budget"]
[null,null,"£m",null,"£m"]
[]
[null,"Directorate"]
[]
[null,"Corporate Resources",666.221,null,660.22199999999998]
[null,"Economy ",154.28899999999999,null,147.14500000000001]
[null,"People   ",1623.8409999999999,null,1587.1379999999999]
[null,"Place (excluding Housing Revenue Account)",230.52099999999999,null,205.52699999999999]
[]
[]
[null,"Total Directorate Expenditure",2674.8719999999998,null,2600.0320000000002]
[]
[null,"Corporately Managed Budgets",137.68899999999999,null,139.52013300000002]
[null,"Contingencies",39.656999999999996,null,54.468874999999997]
[]
[]
[null,"Total Expenditure on Services",2852.2179999999998,null,2794.0210080000002]
[]
[null,"Corporate Contribution to Reserves",8.4649999999999999,null,8.6809999999999992]
[null,"Corporate Repayment of Borrowing from Reserves",11.077999999999999,null,2.5350000000000001]
[null,"Contribution to General Balances",1.5,null,1.5]
[]
[null,"Total General Fund Expenditure",2873.261,null,2806.7370080000001]
[]
[null,"Housing Revenue Account",289.95699999999999,null,287.03500000000003]
[]
[null,"Total Gross Expenditure",3163.2179999999998,null,3093.7720079999999]

{"sheet":"6 Grss Inc","index":2,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Revenue Budget for City Council Services - Gross Income"]
[]
[null,null,"Adjusted"]
[null,null,"2015/16",null,"2016/17"]
[null,null,"Budget",null,"Budget"]
[null,null,"£m",null,"£m"]
[]
[null,"Directorate"]
[]
[null,"Corporate Resources",-619.10900000000004,null,-626.95299999999997]
[null,"Economy ",-87.323999999999998,null,-87.911000000000001]
[null,"People",-1127.386,null,-1116.4829999999999]
[null,"Place (excluding Housing Revenue Account)",-85.144999999999996,null,-74.100999999999999]
[]
[]
[null,"Total Directorate Income",-1918.9639999999999,null,-1905.4479999999999]
[]
[null,"Corporately Managed Budgets",-3.85,null,-16.666]
[null,"Contingencies"]
[null,"Corporate Grants",-31.986000000000001,null,-31.574999999999999]
[]
[null,"Total Income from Services",-1954.8,null,-1953.6889999999999]
[]
[null,"Corporate Use of Reserves",-42.262999999999998,null,-13.54]
[null,"Corporate Borrowing from Reserves",-1.657,null,-4.2270000000000003]
[]
[]
[null,"Total General Fund Income",-1998.7199999999998,null,-1971.4559999999999]
[]
[null,"Housing Revenue Account",-289.95699999999999,null,-287.03500000000003]
[]
[null,"Total Gross Income",-2288.6769999999997,null,-2258.491]

{"sheet":"7 Net Exp","index":3,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Revenue Budget for City Council Services - Net Expenditure"]
[]
[null,null,"Adjusted"]
[null,null,"2015/16",null,"2016/17"]
[null,null,"Budget",null,"Budget"]
[null,null,"£m",null,"£m"]
[]
[null,"Directorate"]
[]
[null,"Corporate Resources ",47.112000000000002,null,33.269000000000005]
[null,"Economy",66.965000000000003,null,59.234000000000009]
[null,"People ",496.45499999999998,null,470.65499999999997]
[null,"Place (excluding Housing Revenue Account)",145.376,null,131.42599999999999]
[]
[]
[null,"Total Directorate Net Expenditure",755.9079999999999,null,694.58400000000006]
[]
[null,"Corporately Managed Budgets",133.839,null,122.85413300000002]
[null,"Contingencies",39.656999999999996,null,54.468874999999997]
[null,"Corporate Grants",-31.986000000000001,null,-31.574999999999999]
[]
[null,"Total Net Expenditure on Services",897.41799999999989,null,840.33200800000009]
[]
[null,"Corporate Use of Reserves",-33.798000000000002,null,-4.859]
[null,"Corporate Net Borrowing from Reserves",9.4209999999999994,null,-1.6920000000000002]
[null,"Contribution to General Balances",1.5,null,1.5]
[]
[null,"Total General Fund Budget",874.54099999999994,null,835.28100800000004]
[]
[null,"Housing Revenue Account",0,null,0]
[]
[null,"City Council Budget",874.54099999999994,null,835.28100800000004]

{"sheet":"8-9 Summary","index":4,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":false,"merged":[[24,12,27,12],[23,13,27,13],[24,3,27,3],[24,4,27,4],[24,5,27,5],[24,6,27,6],[24,7,27,7],[24,8,27,8],[24,9,27,9],[24,10,27,10],[24,11,27,11],[5,11,7,11],[5,12,7,12],[6,9,7,9],[6,10,7,10],[4,13,7,13],[4,11,4,12],[4,14,7,14],[4,15,7,15],[4,16,7,16],[4,17,7,17],[4,18,7,18],[4,2,4,5],[4,6,7,6],[4,7,7,7],[4,8,7,8],[4,9,5,10],[5,2,7,2],[5,3,7,3],[5,4,7,4],[5,5,7,5]]}
[]
[null,"Summary - type of expenditure"]
[]
[null,"Spending 2016/17"]
[null,null,"Employees",null,null,null,"Premises","Transport","Supplies & Services","Third Party\n Payments",null,"Transfer Payments",null,"Support Services","Capital Charges","Appropriations to Reserves","GROSS EXPEN","Less: Rechargeable Expen","TOTAL AFTER RECHARGES"]
[null,"Type of","NJC and Other Awards","Teachers","Sub Total Pay Awards","Other Emps Expenses",null,null,null,null,null,"Major","Other"]
[null,"Expenditure",null,null,null,null,null,null,null,"Grants to Vol Orgs","Other"]
[]
[null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[]
[]
[]
[null,"Directorates"]
[null,"Corporate Resources ",70015,813,70828,3721,13644,478,111648,153,4440,345233,202165,24697,0,1555,778562,-118340,660222]
[null,"Economy",23712,0,23712,1288,8562,298,94244,25,630,0,0,8631,23628,0,161018,-13873,147145]
[null,"People",433379,329276,762655,13889,63170,16755,205940,26534,485098,0,4698,173410,14581,5748,1772478,-185340,1587138]
[null,"Place  (exc HRA)",78391,6380,84771,2818,43304,9641,80589,4943,6684,0,0,6777,431,2800,242758,-37231,205527]
[]
[null,"Housing Revenue Account (HRA)",33633,0,33633,10073,68823,615,21153,0,1186,0,555,21606,129978,0,287622,-587,287035]
[null,"TOTAL",639130,336469,975599,31789,197503,27787,513574,31655,498038,345233,207418,235121,168618,10103,3242438,-355371,2887067]
[]
[null,"Summary - type of income"]
[]
[null,"Income 2016/17",null,null,null,null,null,null,null,null,null,null,null,"NET SPENDING OF SERVICES"]
[null,null,null,"Grants","Reimbursemts & Contribs","Sales","Fees & Charges","Rents","Recharges within & to other services","Appropriations from Reserves","GROSS INCOME","Less: income from Recharges","TOTAL AFTER RECHARGES"]
[null,"Type of"]
[null,"Income"]
[]
[null,null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[]
[]
[null,"Directorates"]
[null,"Corporate Resources ",null,-557887,-126,-328,-30529,-33473,-118340,-4610,-745293,118340,-626953,33269]
[null,"Economy",null,-51074,-4614,-1835,-25549,-332,-13873,-4507,-101784,13873,-87911,59234]
[null,"People",null,-925016,-62156,-13693,-90920,-9317,-185340,-15381,-1301823,185340,-1116483,470655]
[null,"Place  (exc HRA)",null,-19214,-380,-3018,-42515,-8186,-37231,-788,-111332,37231,-74101,131426]
[]
[null,"Housing Revenue Account (HRA)",null,0,0,0,-4962,-282073,-587,0,-287622,587,-287035,0]
[null,"TOTAL",null,-1553191,-67276,-18874,-194475,-333381,-355371,-25286,-2547854,355371,-2192483,694584]

{"sheet":"10 FTEs","index":5,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,3,3,6]]}
[null,"Employees - full time equivalents "]
[]
[]
[null,"Budget","Directorate","Budget 2016/17"]
[null,"2015/16",null,"NJC & Other","Teachers","Lecturers","TOTAL"]
[null,null,null,"Awards"]
[]
[null,1924,"Corporate Resources",1659,0,0,1659]
[null,473,"Economy",446,0,0,446]
[null,17832,"People",9459,7146,0,16605]
[]
[null,3168,"Place (excluding Housing Revenue Account)",2447,0,202,2649]
[null,1049,"Housing Revenue Account",1001,0,0,1001]
[null,4217,"Place - sub total",3448,0,202,3650]
[]
[null,24446,"TOTAL",15012,7146,202,22360]

{"sheet":"11 Heads","index":6,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,2,4,4],[4,5,4,7]]}
[]
[null,"Employees - head count"]
[]
[]
[null,"Directorate","Budget 2015/16",null,null,"Budget 2016/17"]
[null,null,"Full-","Part-","Total","Full-","Part-","Total"]
[null,null,"time","time",null,"time","time"]
[]
[null,"Corporate Resources",1572,528,2100,1370,481,1851]
[null,"Economy",455,33,488,428,33,461]
[null,"People",12883,11847,24730,13003,10487,23490]
[]
[null,"Place (excluding Housing Revenue Account)",2316,2758,5074,2114,1928,4042]
[null,"Housing Revenue Account",1013,72,1085,976,37,1013]
[null,"Place - sub total",3329,2830,6159,3090,1965,5055]
[]
[null,"TOTAL",18239,15238,33477,17891,12966,30857]

{"sheet":"12 Crp Res Obj","index":7,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,1,7,1],[6,2,7,2]]}
[null,32]
[]
[]
["Corporate Resources Directorate - Net Expenditure"]
[]
[]
["Service","Adjusted 2015/16 Budget","2016/17 Budget"]
[]
[null,"£'000","£'000"]
["City Finance",5420,6833]
["Corporate Strategy",777,-2015]
["Procurement",1403,1580]
["Birmingham Audit",2305,2377]
["Human Resources",8163,7437]
["Elections Office",1830,1732]
["Birmingham Property Services",1055,-1337]
["Legal & Democratic Services",5483,5822]
["Revenues & Benefits Division",2126,-2548]
["Shared Services Centre",2395,2198]
["Core ICT",-4336,-10132]
["Business Transformation Legacy Costs",45024,39267]
["Charities & Trusts - Support",50,50]
["Directorate Wide Recharges",-37890,-28346]
["Insurance",1484,14]
["Customer Services",8622,8629]
["Corporate Resources Other Services",3363,1708]
["Use of Reserves & Balances - Corp Resources",-162,0]
["Total Corporate Resources",47112,33269]

{"sheet":"13 Crp Res Exp","index":8,"n_rows":28,"n_cols":22,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,2,3,5],[3,6,6,6],[3,7,6,7],[3,8,6,8],[3,9,4,10],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5],[3,14,6,14],[3,15,6,15],[3,16,6,16],[3,17,6,17],[3,18,6,18],[4,11,6,11],[4,12,6,12],[5,9,6,9],[5,10,6,10],[3,13,6,13],[3,11,3,12]]}
[null,"Corporate Resources budgets - type of expenditure  "]
[]
[null,"Spending 2016/17"]
[null,null,"Employees",null,null,null,"Premises","Transport","Supplies & Services","Third Party\n Payments",null,"Transfer Payments",null,"Support Services","Capital Charges","Appropriations to Reserves","GROSS EXPEN","Less: Rechargeable Expen","TOTAL AFTER RECHARGES"]
[null,"Type of Expenditure","NJC and Other Awards","Teachers","Sub Total Pay Awards","Other Emps Expenses",null,null,null,null,null,"Major","Other"]
[null,null,null,null,null,null,null,null,null,"Grants to Vol Orgs","Other"]
[]
[null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[]
[]
[null,"City Finance",5697,0,5697,419,0,9,2385,0,0,0,0,40,0,0,8550,-1214,7336,null,null,0]
[null,"Corporate Strategy",2139,0,2139,222,158,39,-1465,112,0,0,0,100,0,682,1987,-371,1616,null,null,0]
[null,"Procurement",3211,0,3211,79,0,25,1398,0,0,0,0,3,0,0,4716,-1498,3218,null,null,0]
[null,"Birmingham Audit",2583,0,2583,19,2,21,359,0,0,0,0,0,0,0,2984,-503,2481,null,null,0]
[null,"Human Resources",8559,813,9372,989,73,44,2303,0,0,0,0,251,0,0,13032,-2758,10274,null,null,0]
[null,"Elections Office",841,0,841,5,62,54,778,0,0,0,0,5,0,0,1745,0,1745,null,null,0]
[null,"Birmingham Property Services",5835,0,5835,113,10178,72,10652,0,0,0,0,8139,0,0,34989,-4516,30473,null,null,0]
[null,"Legal & Democratic Services",8333,0,8333,115,41,93,4573,0,0,0,0,-279,0,0,12876,-6384,6492,null,null,0]
[null,"Revenues & Benefits Division",9107,0,9107,82,0,35,8850,0,4439,345233,202165,1348,0,0,571259,-4445,566814,null,null,0]
[null,"Shared Services Centre",4596,0,4596,22,152,55,1559,0,0,0,0,73,0,0,6457,-2773,3684,null,null,0]
[null,"Core ICT",10450,0,10450,0,0,20,21051,0,0,0,0,148,0,0,31669,-27233,4436,null,null,0]
[null,"Business Transformation Legacy Costs",0,0,0,79,0,5,48129,0,1,0,0,12,0,873,49099,-9832,39267,null,null,0]
[null,"Charities & Trusts - Support",0,0,0,0,50,0,0,0,0,0,0,0,0,0,50,0,50,null,null,0]
[null,"Directorate Wide Recharges",0,0,0,0,0,0,0,0,0,0,0,12459,0,0,12459,-40805,-28346,null,null,0]
[null,"Insurance",0,0,0,1186,3141,0,3822,0,0,0,0,2353,0,0,10502,-10246,256,null,null,0]
[null,"Customer Services",8664,0,8664,5,0,6,5755,0,0,0,0,45,0,0,14475,-5762,8713,null,null,0]
[null,"Corporate Resources Other Services",0,0,0,386,-213,0,1499,41,0,0,0,0,0,0,1713,0,1713,null,null,0]
[null,"Total Corporate Resources",70015,813,70828,3721,13644,478,111648,153,4440,345233,202165,24697,0,1555,778562,-118340,660222,null,null,0]

{"sheet":"14 Crp Res Inc","index":9,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,10,6,10],[2,11,6,11],[3,1,6,1],[3,2,6,2],[3,3,6,3],[3,4,6,4],[3,5,6,5],[3,6,6,6],[3,7,6,7],[3,8,6,8],[3,9,6,9]]}
["Corporate Resources budgets - type of income "]
[]
["Income 2016/17",null,null,null,null,null,null,null,null,null,null,"NET SPENDING OF SERVICES"]
[null,"Grants","Reimbursemts & Contribs","Sales","Fees & Charges","Rents","Recharges within & to other services","Appropriations from Reserves","GROSS INCOME","Less: income from Recharges","TOTAL AFTER RECHARGES"]
["Type of Income"]
[]
[]
[null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[]
[]
["City Finance",0,-29,0,-474,0,-1214,0,-1717,1214,-503,6833,null,null,0]
["Corporate Strategy",0,-44,-313,-302,-2830,-371,-142,-4002,371,-3631,-2015,null,null,0]
["Procurement",0,0,0,-1538,0,-1498,-100,-3136,1498,-1638,1580,null,null,0]
["Birmingham Audit",0,0,0,-16,0,-503,-88,-607,503,-104,2377,null,null,0]
["Human Resources",0,0,0,-2837,0,-2758,0,-5595,2758,-2837,7437,null,null,0]
["Elections Office",0,0,0,-13,0,0,0,-13,0,-13,1732,null,null,0]
["Birmingham Property Services",0,0,-1,-1166,-30643,-4516,0,-36326,4516,-31810,-1337,null,null,0]
["Legal & Democratic Services",-66,0,-14,-590,0,-6384,0,-7054,6384,-670,5822,null,null,0]
["Revenues & Benefits Division",-557821,0,0,-7261,0,-4445,-4280,-573807,4445,-569362,-2548,null,null,0]
["Shared Services Centre",0,-50,0,-1436,0,-2773,0,-4259,2773,-1486,2198,null,null,0]
["Core ICT",0,0,0,-14568,0,-27233,0,-41801,27233,-14568,-10132,null,null,0]
["Business Transformation Legacy Costs",0,0,0,0,0,-9832,0,-9832,9832,0,39267,null,null,0]
["Charities & Trusts - Support",0,0,0,0,0,0,0,0,0,0,50,null,null,0]
["Directorate Wide Recharges",0,0,0,0,0,-40805,0,-40805,40805,0,-28346,null,null,0]
["Insurance",0,0,0,-242,0,-10246,0,-10488,10246,-242,14,null,null,0]
["Customer Services",0,-3,0,-81,0,-5762,0,-5846,5762,-84,8629,null,null,0]
["Corporate Resources Other Services",0,0,0,-5,0,0,0,-5,0,-5,1708,null,null,0]
["Total Corporate Resources",-557887,-126,-328,-30529,-33473,-118340,-4610,-745293,118340,-626953,33269,null,null,0]

{"sheet":"15 Econ Obj","index":10,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,1,6,1],[5,2,6,2]]}
[]
[]
["Economy Directorate - Net Expenditure"]
[]
[]
["Service","Adjusted 2015/16 Budget","2016/17 Budget"]
[]
[null,"£'000","£'000"]
["Building Consultancy",1165,1164]
["Development Management Services",7883,4250]
["Planning & Regeneration",4141,4194]
["Highways",35924,33154]
["Transportation and Connectivity",51570,49833]
["Urban Design",-783,-533]
["Catering & Building Cleaning",12,-100]
["Facilities Management",-680,-631]
["Shelforce",-75,-100]
["Employment Services",885,1049]
["Capital Financing Adjustments - Economy",-32319,-32319]
["Business Loans & Other Investments",-758,-727]
["Total Economy Directorate",66965,59234]

{"sheet":"16 Econ Exp","index":11,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,11,6,11],[4,12,6,12],[5,9,6,9],[5,10,6,10],[3,13,6,13],[3,11,3,12],[3,14,6,14],[3,15,6,15],[3,16,6,16],[3,17,6,17],[3,18,6,18],[3,2,3,5],[3,6,6,6],[3,7,6,7],[3,8,6,8],[3,9,4,10],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5]]}
[null,"Economy budgets - type of expenditure  "]
[]
[null,"Spending 2016/17"]
[null,null,"Employees",null,null,null,"Premises","Transport","Supplies & Services","Third Party\n Payments",null,"Transfer Payments",null,"Support Services","Capital Charges","Appropriations to Reserves","GROSS EXPEN","Less: Rechargeable Expen","TOTAL AFTER RECHARGES"]
[null,"Type of Expenditure","NJC and Other Awards","Teachers","Sub Total Pay Awards","Other Emps Expenses",null,null,null,null,null,"Major","Other"]
[null,null,null,null,null,null,null,null,null,"Grants to Vol Orgs","Other"]
[]
[null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[]
[]
[null,"Building Consultancy",0,0,0,0,0,0,1165,0,0,0,0,0,0,0,1165,0,1165]
[null,"Development Management Services",-284,0,-284,662,-1000,13,1573,0,0,0,0,3981,0,0,4945,-588,4357]
[null,"Planning & Regeneration",9475,0,9475,72,9,90,3431,25,0,0,0,4157,0,0,17259,-1253,16006]
[null,"Highways",4762,0,4762,472,9416,77,91735,0,385,0,0,346,0,0,107193,-1946,105247]
[null,"Transportation and Connectivity",5020,0,5020,69,2,65,51995,0,245,0,0,126,0,0,57522,-6506,51016]
[null,"Urban Design",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Catering & Building Cleaning",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Facilities Management",2295,0,2295,8,0,36,179,0,0,0,0,0,0,0,2518,-3088,-570]
[null,"Shelforce",646,0,646,0,135,5,17,0,0,0,0,19,0,0,822,0,822]
[null,"Employment Services",1798,0,1798,5,0,12,96,0,0,0,0,2,0,0,1913,-492,1421]
[null,"Capital Financing Adjustments - Economy",0,0,0,0,0,0,-55947,0,0,0,0,0,23628,0,-32319,0,-32319]
[null,"Business Loans & Other Investments",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Economy Directorate",23712,0,23712,1288,8562,298,94244,25,630,0,0,8631,23628,0,161018,-13873,147145]

{"sheet":"17 Econ Inc","index":12,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,11,6,11],[2,12,6,12],[3,2,6,2],[3,3,6,3],[3,4,6,4],[3,5,6,5],[3,6,6,6],[3,7,6,7],[3,8,6,8],[3,9,6,9],[3,10,6,10]]}
[null,"Economy budgets - type of income "]
[]
[null,"Income 2016/17",null,null,null,null,null,null,null,null,null,null,"NET SPENDING OF SERVICES"]
[null,null,"Grants","Reimbursemts & Contribs","Sales","Fees & Charges","Rents","Recharges within & to other services","Appropriations from Reserves","GROSS INCOME","Less: income from Recharges","TOTAL AFTER RECHARGES"]
[null,"Type of Income"]
[]
[]
[null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[]
[]
[null,"Building Consultancy",0,0,0,-1,0,0,0,-1,0,-1,1164,null,null,0]
[null,"Development Management Services",0,-107,0,0,0,-588,0,-695,588,-107,4250,null,null,0]
[null,"Planning & Regeneration",0,-4135,-32,-5111,-286,-1253,-2248,-13065,1253,-11812,4194,null,null,0]
[null,"Highways",-50311,0,-881,-18664,-46,-1946,-2191,-74039,1946,-72093,33154,null,null,0]
[null,"Transportation and Connectivity",-763,0,0,-352,0,-6506,-68,-7689,6506,-1183,49833,null,null,0]
[null,"Urban Design",0,0,0,-533,0,0,0,-533,0,-533,-533,null,null,0]
[null,"Catering & Building Cleaning",0,0,0,-100,0,0,0,-100,0,-100,-100,null,null,0]
[null,"Facilities Management",0,0,0,-61,0,-3088,0,-3149,3088,-61,-631,null,null,0]
[null,"Shelforce",0,0,-922,0,0,0,0,-922,0,-922,-100,null,null,0]
[null,"Employment Services",0,-372,0,0,0,-492,0,-864,492,-372,1049,null,null,0]
[null,"Capital Financing Adjustments - Economy",0,0,0,0,0,0,0,0,0,0,-32319,null,null,0]
[null,"Business Loans & Other Investments",0,0,0,-727,0,0,0,-727,0,-727,-727,null,null,0]
[null,"Total Economy Directorate",-51074,-4614,-1835,-25549,-332,-13873,-4507,-101784,13873,-87911,59234,null,null,0]

{"sheet":"18-19 Peop Obj","index":13,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":false,"merged":[[6,1,7,1],[6,2,7,2],[39,1,40,1],[39,2,40,2]]}
[null,32]
[]
[]
["People Directorate - Net Expenditure"]
[]
[]
["Service","Adjusted 2015/16 Budget","2016/17 Budget"]
[]
[null,"£'000","£'000"]
["Adults with Mental Health Needs",15176,14734]
["Older People's Services",115211,83280]
["Persons with No Recourse to Public Funds",104,104]
["Homelessness",3247,2877]
["Adults with a Physical Disability",22976,22613]
["Service Strategy",7736,25563]
["Adults with a Learning Disability",94146,90765]
["Housing Strategy",1930,1952]
["Other Adult Services",4475,4853]
["Supporting People",27991,24666]
["Public Health",0,-6]
["School Settings / Improvements",2236,2618]
["Schools Management & Governor Support",-29,-17]
["SEND Information, Advice & Support",262,268]
["Admissions & Placements",4060,4035]
["Cityserve",-2063,-2152]
["Education Skills & Infrastructure",6140,5808]
["Early Years",53104,41904]
["Strategic Leadership & Improvement – Education & Commissioning",3098,1497]
["Schools' Delegated Budgets",577362,548005]
["School Funding Centrally Managed",-726468,-691018]
["Commissioning & Brokerage",4128,4117]
["Strategic Management",1872,1521]
["Troubled Families",2,0]
[]
[null,null,"Continued (see next page)…"]
[]
["People Directorate - Net Expenditure (Continued)"]
[]
[]
["Service","2015/16 Budget","2016/17 Budget"]
[]
[null,"£'000","£'000"]
["Customer Information & Advisory Service",1010,1026]
["Professional Support Services",10435,10640]
["Disabled Children's Social Care",6284,6309]
["Looked After Children Education Service",2016,1613]
["Higher Needs",73732,73638]
["Access to Education",7895,7972]
["Early Support Service",1673,1673]
["Transport",15711,13292]
["Strategic leadership- Early Help & Children’s Social Care",1681,1022]
["Social Work",31384,32888]
["Family Support Teams",5871,6019]
["Persons From Abroad",2707,2846]
["Care Leavers",5647,5878]
["Safeguarding",4351,4936]
["External Placements",51822,53457]
["Residential",10362,10044]
["Fostering",18795,18741]
["Adoption",6761,7334]
["Therapeutic Emotional Support Service",1508,1544]
["Contact & Escort",1560,1384]
["Child Protection Resources",323,310]
["Early Help & Brokerage Service",334,343]
["Rights & Participation",555,564]
["Youth Offending Service",3926,3656]
["Learning & Development",987,965]
["Business Support",18920,21065]
["Capital Financing Adjustments - People",-6491,-6491]
["Total People Directorate",496455,470655]

{"sheet":"20-21 Peop Exp","index":14,"n_rows":77,"n_cols":21,"rows_kept":77,"cut":false,"hidden":false,"merged":[[3,2,3,5],[3,6,6,6],[3,7,6,7],[3,8,6,8],[3,9,4,10],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5],[3,14,6,14],[3,15,6,15],[3,16,6,16],[3,17,6,17],[3,18,6,18],[4,12,6,12],[5,9,6,9],[5,10,6,10],[3,13,6,13],[3,11,3,12],[42,6,45,6],[42,7,45,7],[42,8,45,8],[42,9,43,10],[4,11,6,11],[42,17,45,17],[42,18,45,18],[43,2,45,2],[43,3,45,3],[43,4,45,4],[43,5,45,5],[43,11,45,11],[43,12,45,12],[44,9,45,9],[44,10,45,10],[42,11,42,12],[42,13,45,13],[42,14,45,14],[42,15,45,15],[42,16,45,16],[42,2,42,5]]}
[null,"People budgets - type of expenditure"]
[]
[null,"Spending 2016/17"]
[null,null,"Employees",null,null,null,"Premises","Transport","Supplies & Services","Third Party\n Payments",null,"Transfer Payments",null,"Support Services","Capital Charges","Appropriations to Reserves","GROSS EXPEN","Less: Rechargeable Expen","TOTAL AFTER RECHARGES"]
[null,"Type of Expenditure","NJC and Other Awards","Teachers","Sub Total Pay Awards","Other Emps Expenses",null,null,null,null,null,"Major","Other"]
[null,null,null,null,null,null,null,null,null,"Grants to Vol Orgs","Other"]
[]
[null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[]
[]
[null,"Adults with Mental Health Needs",3634,0,3634,81,0,114,39,1232,13506,0,0,0,0,0,18606,null,18606,null,0]
[null,"Older People's Services",44570,0,44570,58,1431,677,5295,3942,97973,0,1119,103,0,0,155168,-49,155119,null,0]
[null,"Persons with No Recourse to Public Funds",0,0,0,0,0,0,3,0,76,0,25,0,0,0,104,0,104,null,0]
[null,"Homelessness",6981,0,6981,0,947,67,128,0,5811,0,0,0,0,0,13934,-3323,10611,null,0]
[null,"Adults with a Physical Disability",1398,0,1398,0,111,308,57,266,22877,0,0,1,0,0,25018,0,25018,null,0]
[null,"Service Strategy",16593,0,16593,1423,179,65,13927,571,2251,0,40,7975,0,5748,48772,-1965,46807,null,0]
[null,"Adults with a Learning Disability",14137,0,14137,8,459,1280,332,496,84853,0,0,23,0,0,101588,-193,101395,null,0]
[null,"Housing Strategy",699,0,699,0,6,3,96,1069,0,0,0,220,0,0,2093,-141,1952,null,0]
[null,"Other Adult Services",2545,0,2545,2,101,38,1222,829,1836,0,5,1,0,0,6579,-301,6278,null,0]
[null,"Supporting People",587,0,587,12,8,14,42,0,24003,0,0,0,0,0,24666,0,24666,null,0]
[null,"Public Health",3677,0,3677,53,0,29,240,6061,60276,0,0,25229,0,0,95565,0,95565,null,0]
[null,"School Settings / Improvements",262,6,268,41,0,0,419,0,1800,0,0,90,0,0,2618,0,2618,null,0]
[null,"Schools Management & Governor Support",468,22,490,3,16,4,122,0,0,0,0,111,0,0,746,-666,80,null,0]
[null,"SEND Information, Advice & Support",265,0,265,0,0,3,6,0,0,0,0,21,0,0,295,0,295,null,0]
[null,"Admissions & Placements",1828,94,1922,2,0,15,2089,0,0,0,0,243,0,0,4271,-221,4050,null,0]
[null,"Cityserve",25393,0,25393,113,216,73,13114,0,0,0,0,499,0,0,39408,-25080,14328,null,0]
[null,"Education Skills & Infrastructure",2065,0,2065,13,368,37,37768,0,0,0,0,0,0,0,40251,-8954,31297,null,0]
[null,"Early Years",6207,44,6251,106,1116,43,1255,3077,49371,0,0,6738,0,0,67957,-19135,48822,null,0]
[null,"Strategic Leadership & Improvement – Education & Commissioning",683,0,683,0,1,0,813,0,0,0,0,0,0,0,1497,0,1497,null,0]
[null,"Schools' Delegated Budgets",198950,324460,523410,3782,56145,4454,111863,34,325,0,0,2137,0,0,702150,-101812,600338,null,0]
[null,"School Funding Centrally Managed",81,288,369,0,0,0,21916,0,1584,0,0,69550,0,0,93419,0,93419,null,0]
[null,"Commissioning & Brokerage",1385,0,1385,3,2,4,148,3712,2551,0,0,171,0,0,7976,-3686,4290,null,0]
[null,"Strategic Management",1523,0,1523,1,0,1,24,0,0,0,0,0,0,0,1549,0,1549,null,0]
[null,"Troubled Families",344,0,344,0,0,0,0,5213,0,0,0,0,0,0,5557,-45,5512,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Continued (see next page)…",null,0]
[]
[]
[]
[null,"People budgets - type of expenditure (continued)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Spending 2016/17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Employees",null,null,null,"Premises","Transport","Supplies & Services","Third Party\n Payments",null,"Transfer Payments",null,"Support Services","Capital Charges","Appropriations to Reserves","GROSS EXPEN","Less: Rechargeable Expen","TOTAL AFTER RECHARGES"]
[null,"Type of Expenditure","NJC and Other Awards","Teachers","Sub Total Pay Awards","Other Emps Expenses",null,null,null,null,null,"Major","Other",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Grants to Vol Orgs","Other",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Customer Information & Advisory Service",1179,0,1179,0,0,0,4,0,0,0,0,0,0,0,1183,-157,1026,null,0]
[null,"Professional Support Services",11308,0,11308,8,0,15,359,0,0,0,0,0,0,0,11690,-1050,10640,null,0]
[null,"Disabled Children's Social Care",2042,0,2042,11,0,157,29,0,4087,0,19,3,0,0,6348,0,6348,null,0]
[null,"Looked After Children Education Service",1415,99,1514,8,0,25,2219,0,0,0,0,586,0,0,4352,-2698,1654,null,0]
[null,"Higher Needs",2112,0,2112,0,3,4,1212,0,33649,0,0,39888,0,0,76868,-651,76217,null,0]
[null,"Access to Education",4701,3751,8452,56,136,97,920,0,150,0,0,885,0,0,10696,-1461,9235,null,0]
[null,"Early Support Service",1054,512,1566,8,23,21,33,0,0,0,0,22,0,0,1673,0,1673,null,0]
[null,"Transport",5546,0,5546,21,0,7702,27,0,0,0,0,234,0,0,13530,-113,13417,null,0]
[null,"Strategic leadership- Early Help & Children’s Social Care",334,0,334,91,0,3,560,0,34,0,0,0,0,0,1022,0,1022,null,0]
[null,"Social Work",28883,0,28883,0,566,903,1853,0,0,0,345,338,0,0,32888,0,32888,null,0]
[null,"Family Support Teams",7097,0,7097,32,67,54,48,0,84,0,16,45,0,0,7443,-1424,6019]
[null,"Persons From Abroad",670,0,670,0,0,6,32,0,42,0,2714,44,0,0,3508,0,3508,null,0]
[null,"Care Leavers",1348,0,1348,3,0,69,34,0,4311,0,409,4,0,0,6178,0,6178,null,0]
[null,"Safeguarding",4369,0,4369,20,0,30,271,2,444,0,0,435,0,0,5571,-435,5136,null,0]
[null,"External Placements",0,0,0,0,0,0,0,0,54300,0,0,0,0,0,54300,-330,53970,null,0]
[null,"Residential",8650,0,8650,6,841,72,476,0,0,0,0,0,0,0,10045,0,10045,null,0]
[null,"Fostering",3550,0,3550,24,65,76,616,0,14395,0,0,15,0,0,18741,0,18741,null,0]
[null,"Adoption",3236,0,3236,11,6,28,322,30,3689,0,0,12,0,0,7334,0,7334,null,0]
[null,"Therapeutic Emotional Support Service",1394,0,1394,45,33,0,72,0,0,0,0,0,0,0,1544,0,1544,null,0]
[null,"Contact & Escort",1197,0,1197,0,95,88,4,0,0,0,0,0,0,0,1384,0,1384,null,0]
[null,"Child Protection Resources",292,0,292,1,0,3,14,0,0,0,0,0,0,0,310,0,310,null,0]
[null,"Early Help & Brokerage Service",372,0,372,8,4,5,5,0,0,0,0,347,0,0,741,-348,393,null,0]
[null,"Rights & Participation",371,0,371,0,0,11,24,0,133,0,0,25,0,0,564,0,564,null,0]
[null,"Youth Offending Service",5968,0,5968,6,215,112,322,0,687,0,6,202,0,0,7518,-676,6842,null,0]
[null,"Learning & Development",558,0,558,407,0,0,0,0,0,0,0,0,0,0,965,0,965,null,0]
[null,"Business Support",1458,0,1458,7422,10,45,6638,0,0,0,0,17213,0,0,32786,-10426,22360,null,0]
[null,"Capital Financing Adjustments - People",0,0,0,0,0,0,-21072,0,0,0,0,0,14581,0,-6491,0,-6491,null,0]
[null,"Total People Directorate",433379,329276,762655,13889,63170,16755,205940,26534,485098,0,4698,173410,14581,5748,1772478,-185340,1587138,null,0]

{"sheet":"22-23 Peop Inc","index":15,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":false,"merged":[[3,11,6,11],[2,12,6,12],[3,2,6,2],[3,3,6,3],[3,4,6,4],[3,5,6,5],[3,6,6,6],[3,7,6,7],[3,8,6,8],[3,9,6,9],[3,10,6,10],[41,12,45,12],[42,2,45,2],[42,3,45,3],[42,4,45,4],[42,5,45,5],[42,6,45,6],[42,7,45,7],[42,8,45,8],[42,9,45,9],[42,10,45,10],[42,11,45,11]]}
[null,"People budgets - type of income"]
[]
[null,"Income 2016/17",null,null,null,null,null,null,null,null,null,null,"NET SPENDING OF SERVICES"]
[null,null,"Grants","Reimbursemts & Contribs","Sales","Fees & Charges","Rents","Recharges within & to other services","Appropriations from Reserves","GROSS INCOME","Less: income from Recharges","TOTAL AFTER RECHARGES"]
[null,"Type of Income"]
[]
[]
[null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[]
[]
[null,"Adults with Mental Health Needs",0,-3200,0,-672,0,0,0,-3872,null,-3872,14734,null,null,0]
[null,"Older People's Services",0,-37191,-190,-33925,-533,-49,0,-71888,49,-71839,83280,null,null,0]
[null,"Persons with No Recourse to Public Funds",0,0,0,0,0,0,0,0,0,0,104,null,null,0]
[null,"Homelessness",0,0,0,-271,-7463,-3323,0,-11057,3323,-7734,2877,null,null,0]
[null,"Adults with a Physical Disability",0,0,-27,-2377,-1,0,0,-2405,0,-2405,22613,null,null,0]
[null,"Service Strategy",-754,-20154,0,-261,-75,-1965,0,-23209,1965,-21244,25563,null,null,0]
[null,"Adults with a Learning Disability",-4499,-212,-171,-5748,0,-193,0,-10823,193,-10630,90765,null,null,0]
[null,"Housing Strategy",0,0,0,0,0,-141,0,-141,141,0,1952,null,null,0]
[null,"Other Adult Services",0,-69,0,-1356,0,-301,0,-1726,301,-1425,4853,null,null,0]
[null,"Supporting People",0,0,0,0,0,0,0,0,0,0,24666,null,null,0]
[null,"Public Health",-95571,0,0,0,0,0,0,-95571,0,-95571,-6,null,null,0]
[null,"School Settings / Improvements",0,0,0,0,0,0,0,0,0,0,2618,null,null,0]
[null,"Schools Management & Governor Support",0,0,0,-97,0,-666,0,-763,666,-97,-17,null,null,0]
[null,"SEND Information, Advice & Support",0,0,0,-27,0,0,0,-27,0,-27,268,null,null,0]
[null,"Admissions & Placements",0,0,0,-15,0,-221,0,-236,221,-15,4035,null,null,0]
[null,"Cityserve",0,0,-9152,-7328,0,-25080,0,-41560,25080,-16480,-2152,null,null,0]
[null,"Education Skills & Infrastructure",-19432,0,0,-5499,-558,-8954,0,-34443,8954,-25489,5808,null,null,0]
[null,"Early Years",0,0,0,-1376,0,-19135,-5542,-26053,19135,-6918,41904,null,null,0]
[null,"Strategic Leadership & Improvement – Education & Commissioning",0,0,0,0,0,0,0,0,0,0,1497,null,null,0]
[null,"Schools' Delegated Budgets",-17227,0,-4152,-30487,-467,-101812,0,-154145,101812,-52333,548005,null,null,0]
[null,"School Funding Centrally Managed",-777668,0,0,-1,-196,0,-6572,-784437,0,-784437,-691018,null,null,0]
[null,"Commissioning & Brokerage",0,-149,0,0,-24,-3686,0,-3859,3686,-173,4117,null,null,0]
[null,"Strategic Management",0,0,0,-28,0,0,0,-28,0,-28,1521,null,null,0]
[null,"Troubled Families",-4234,0,0,0,0,-45,-1278,-5557,45,-5512,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Continued (see next page)…",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"People budgets - type of income (continued)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Income 2016/17",null,null,null,null,null,null,null,null,null,null,"NET SPENDING OF SERVICES",null,null,0]
[null,null,"Grants","Reimbursemts & Contribs","Sales","Fees & Charges","Rents","Recharges within & to other services","Appropriations from Reserves","GROSS INCOME","Less: income from Recharges","TOTAL AFTER RECHARGES"]
[null,"Type of Income",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Customer Information & Advisory Service",0,0,0,0,0,-157,0,-157,157,0,1026,null,null,0]
[null,"Professional Support Services",0,0,0,0,0,-1050,0,-1050,1050,0,10640,null,null,0]
[null,"Disabled Children's Social Care",0,-39,0,0,0,0,0,-39,0,-39,6309,null,null,0]
[null,"Looked After Children Education Service",0,0,0,-41,0,-2698,0,-2739,2698,-41,1613,null,null,0]
[null,"Higher Needs",-898,-150,0,0,0,-651,-1531,-3230,651,-2579,73638,null,null,0]
[null,"Access to Education",0,0,0,-1263,0,-1461,0,-2724,1461,-1263,7972,null,null,0]
[null,"Early Support Service",0,0,0,0,0,0,0,0,0,0,1673,null,null,0]
[null,"Transport",-105,-9,0,-11,0,-113,0,-238,113,-125,13292,null,null,0]
[null,"Strategic leadership- Early Help & Children’s Social Care",0,0,0,0,0,0,0,0,0,0,1022,null,null,0]
[null,"Social Work",0,0,0,0,0,0,0,0,0,0,32888,null,null,0]
[null,"Family Support Teams",0,0,0,0,0,-1424,0,-1424,1424,0,6019]
[null,"Persons From Abroad",-662,0,0,0,0,0,0,-662,0,-662,2846,null,null,0]
[null,"Care Leavers",-300,0,0,0,0,0,0,-300,0,-300,5878,null,null,0]
[null,"Safeguarding",0,-200,0,0,0,-435,0,-635,435,-200,4936,null,null,0]
[null,"External Placements",0,-513,0,0,0,-330,0,-843,330,-513,53457,null,null,0]
[null,"Residential",0,0,-1,0,0,0,0,-1,0,-1,10044,null,null,0]
[null,"Fostering",0,0,0,0,0,0,0,0,0,0,18741,null,null,0]
[null,"Adoption",0,0,0,0,0,0,0,0,0,0,7334,null,null,0]
[null,"Therapeutic Emotional Support Service",0,0,0,0,0,0,0,0,0,0,1544,null,null,0]
[null,"Contact & Escort",0,0,0,0,0,0,0,0,0,0,1384,null,null,0]
[null,"Child Protection Resources",0,0,0,0,0,0,0,0,0,0,310,null,null,0]
[null,"Early Help & Brokerage Service",0,-50,0,0,0,-348,0,-398,348,-50,343,null,null,0]
[null,"Rights & Participation",0,0,0,0,0,0,0,0,0,0,564,null,null,0]
[null,"Youth Offending Service",-2930,-220,0,-36,0,-676,0,-3862,676,-3186,3656,null,null,0]
[null,"Learning & Development",0,0,0,0,0,0,0,0,0,0,965,null,null,0]
[null,"Business Support",-736,0,0,-101,0,-10426,-458,-11721,10426,-1295,21065,null,null,0]
[null,"Capital Financing Adjustments - People",0,0,0,0,0,0,0,0,0,0,-6491,null,null,0]
[null,"Total People Directorate",-925016,-62156,-13693,-90920,-9317,-185340,-15381,-1301823,185340,-1116483,470655,null,null,0]

{"sheet":"24 Place Obj","index":16,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,1,6,1],[5,2,6,2]]}
[]
[]
["Place Directorate - Net Expenditure"]
[]
[]
["Service","Adjusted 2015/16 Budget","2016/17 Budget"]
[]
[null,"£'000","£'000"]
["Community Sport & Events",9242,6897]
["Community Development & Play",-273,-292]
["Fleet and Waste Management",55141,52041]
["Parks and Nature Conservation",16238,14424]
["Bereavement Services",-3820,-2626]
["Markets",-3003,-2064]
["Business Support - Place",2613,2479]
["Equalities,Cohesion and Safety",1320,216]
["Resilience",1471,1183]
["Regulatory Services",4233,5393]
["Voluntary Advice Agency Funding",313,337]
["Birmingham Careers Service",1295,1210]
["Private Sector Housing",1296,417]
["Neighbourhood Advice",1476,1319]
["Community Libraries",4398,4178]
["School Crossing Patrol Service",881,377]
["Car Parks",-1184,-1150]
["Business Support (Districts)",966,367]
["Place Other Services",869,2810]
["Youth Service",2542,1992]
["Birmingham Adult Education Services",84,227]
["Central Support Costs",16729,11210]
["Culture & Visitor Economy",36773,33099]
["City Centre Management",294,7]
["Use of Reserves & Balances - Place",-1893,0]
["Capital Financing Adjustments - Place",-2625,-2625]
["Other Place Services",145376,131426]
["Housing Revenue Account",0,0]
["Total Place Directorate",145376,131426]

{"sheet":"25 Place Exp","index":17,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,11,6,11],[4,12,6,12],[5,9,6,9],[5,10,6,10],[3,13,6,13],[3,11,3,12],[3,14,6,14],[3,15,6,15],[3,16,6,16],[3,17,6,17],[3,18,6,18],[3,2,3,5],[3,6,6,6],[3,7,6,7],[3,8,6,8],[3,9,4,10],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5]]}
[null,"Place budgets - type of expenditure"]
[]
[null,"Spending 2016/17"]
[null,null,"Employees",null,null,null,"Premises","Transport","Supplies & Services","Third Party\n Payments",null,"Transfer Payments",null,"Support Services","Capital Charges","Appropriations to Reserves","GROSS EXPEN","Less: Rechargeable Expen","TOTAL AFTER RECHARGES"]
[null,"Type of Expenditure","NJC and Other Awards","Teachers","Sub Total Pay Awards","Other Emps Expenses",null,null,null,null,null,"Major","Other"]
[null,null,null,null,null,null,null,null,null,"Grants to Vol Orgs","Other"]
[]
[null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[]
[]
[null,"Community Sport & Events",6342,68,6410,134,3579,128,6818,0,8,0,0,31,0,0,17108,-4959,12149,null,null,0]
[null,"Community Development & Play",0,0,0,12,-14,-3,0,-287,0,0,0,0,0,0,-292,0,-292,null,null,0]
[null,"Fleet and Waste Management",24819,0,24819,320,723,7210,37192,0,38,0,0,82,0,0,70384,-5239,65145,null,null,0]
[null,"Parks and Nature Conservation",8133,0,8133,167,24851,1154,2644,0,40,0,0,76,0,0,37065,-18971,18094,null,null,0]
[null,"Bereavement Services",2065,0,2065,80,2543,287,1108,0,0,0,0,1,0,0,6084,0,6084,null,null,0]
[null,"Markets",1756,0,1756,35,3249,43,794,0,0,0,0,0,0,0,5877,0,5877,null,null,0]
[null,"Business Support - Place",2265,0,2265,1203,47,27,133,0,0,0,0,31,0,0,3706,-1227,2479,null,null,0]
[null,"Equalities,Cohesion and Safety",782,0,782,4,38,14,48,0,1473,0,0,371,0,0,2730,-12,2718,null,null,0]
[null,"Resilience",1228,0,1228,125,106,12,1112,0,0,0,0,1,0,0,2584,-1310,1274,null,null,0]
[null,"Regulatory Services",12612,0,12612,217,1016,505,3021,0,0,0,0,24,0,0,17395,-1079,16316,null,null,0]
[null,"Voluntary Advice Agency Funding",125,0,125,0,0,0,29,333,0,0,0,0,0,0,487,-150,337,null,null,0]
[null,"Birmingham Careers Service",1610,0,1610,11,80,15,140,0,0,0,0,31,0,0,1887,-677,1210,null,null,0]
[null,"Private Sector Housing",2452,0,2452,0,0,29,351,0,0,0,0,573,0,0,3405,-1125,2280,null,null,0]
[null,"Neighbourhood Advice",2064,0,2064,24,328,16,65,0,0,0,0,128,0,0,2625,-1249,1376,null,null,0]
[null,"Community Libraries",2766,0,2766,0,947,7,629,0,0,0,0,135,0,0,4484,-16,4468,null,null,0]
[null,"School Crossing Patrol Service",342,0,342,0,0,0,0,0,0,0,0,35,0,0,377,0,377,null,null,0]
[null,"Car Parks",0,0,0,0,191,0,2,0,0,0,0,63,0,0,256,0,256,null,null,0]
[null,"Business Support ",948,0,948,1,134,4,-76,0,0,0,0,3,0,0,1014,-449,565,null,null,0]
[null,"Place Other Services",1523,0,1523,2,77,9,2163,47,0,0,0,0,0,0,3821,-566,3255,null,null,0]
[null,"Youth Service",1306,0,1306,0,683,51,243,0,0,0,0,120,0,0,2403,0,2403,null,null,0]
[null,"Birmingham Adult Education Services",3210,6312,9522,155,1112,36,2665,0,510,0,0,312,0,0,14312,-73,14239,null,null,0]
[null,"Central Support Costs",-1346,0,-1346,-45,-114,0,7972,0,0,0,0,4743,0,0,11210,0,11210,null,null,0]
[null,"Culture & Visitor Economy",3133,0,3133,373,3728,97,16585,4850,4615,0,0,17,0,2800,36198,-129,36069]
[null,"City Centre Management",256,0,256,0,0,0,7,0,0,0,0,0,0,0,263,0,263,null,null,0]
[null,"Capital Financing Adjustments - Place",0,0,0,0,0,0,-3056,0,0,0,0,0,431,0,-2625,0,-2625,null,null,0]
[null,"Other Place Services",78391,6380,84771,2818,43304,9641,80589,4943,6684,0,0,6777,431,2800,242758,-37231,205527,null,null,0]
[null,"Housing Revenue Account",33633,0,33633,10073,68823,615,21153,0,1186,0,555,21606,129978,0,287622,-587,287035,null,null,0]
[null,"Total Place Directorate",112024,6380,118404,12891,112127,10256,101742,4943,7870,0,555,28383,130409,2800,530380,-37818,492562,null,null,0]

{"sheet":"26 Place Inc","index":18,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,11,6,11],[2,12,6,12],[3,2,6,2],[3,3,6,3],[3,4,6,4],[3,5,6,5],[3,6,6,6],[3,7,6,7],[3,8,6,8],[3,9,6,9],[3,10,6,10]]}
[null,"Place budgets - type of income"]
[]
[null,"Income 2016/17",null,null,null,null,null,null,null,null,null,null,"NET SPENDING OF SERVICES"]
[null,null,"Grants","Reimbursemts & Contribs","Sales","Fees & Charges","Rents","Recharges within & to other services","Appropriations from Reserves","GROSS INCOME","Less: income from Recharges","TOTAL AFTER RECHARGES"]
[null,"Type of Income"]
[]
[]
[null,null,"£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000","£'000"]
[]
[]
[null,"Community Sport & Events",-707,-81,-114,-3684,-666,-4959,0,-10211,4959,-5252,6897,null,null,0]
[null,"Community Development & Play",0,0,0,0,0,0,0,0,0,0,-292,null,null,0]
[null,"Fleet and Waste Management",0,0,-1545,-10655,-904,-5239,0,-18343,5239,-13104,52041,null,null,0]
[null,"Parks and Nature Conservation",-129,-12,-735,-1730,-978,-18971,-86,-22641,18971,-3670,14424,null,null,0]
[null,"Bereavement Services",0,0,-300,-8170,-240,0,0,-8710,0,-8710,-2626,null,null,0]
[null,"Markets",0,0,0,-3021,-4920,0,0,-7941,0,-7941,-2064,null,null,0]
[null,"Business Support - Place",0,0,0,0,0,-1227,0,-1227,1227,0,2479,null,null,0]
[null,"Equalities,Cohesion and Safety",-2502,0,0,0,0,-12,0,-2514,12,-2502,216,null,null,0]
[null,"Resilience",0,0,0,0,0,-1310,-91,-1401,1310,-91,1183,null,null,0]
[null,"Regulatory Services",-3866,0,0,-6742,-4,-1079,-311,-12002,1079,-10923,5393,null,null,0]
[null,"Voluntary Advice Agency Funding",0,0,0,0,0,-150,0,-150,150,0,337,null,null,0]
[null,"Birmingham Careers Service",0,0,0,0,0,-677,0,-677,677,0,1210,null,null,0]
[null,"Private Sector Housing",-1243,0,0,-620,0,-1125,0,-2988,1125,-1863,417,null,null,0]
[null,"Neighbourhood Advice",0,-33,0,-24,0,-1249,0,-1306,1249,-57,1319,null,null,0]
[null,"Community Libraries",-9,0,-26,-167,-88,-16,0,-306,16,-290,4178,null,null,0]
[null,"School Crossing Patrol Service",0,0,0,0,0,0,0,0,0,0,377,null,null,0]
[null,"Car Parks",0,0,-25,-1381,0,0,0,-1406,0,-1406,-1150,null,null,0]
[null,"Business Support ",0,0,0,-180,-18,-449,0,-647,449,-198,367,null,null,0]
[null,"Place Other Services",0,-25,-158,-91,-171,-566,0,-1011,566,-445,2810,null,null,0]
[null,"Youth Service",0,-50,0,-361,0,0,0,-411,0,-411,1992,null,null,0]
[null,"Birmingham Adult Education Services",-10758,0,0,-3254,0,-73,0,-14085,73,-14012,227,null,null,0]
[null,"Central Support Costs",0,0,0,0,0,0,0,0,0,0,11210]
[null,"Culture & Visitor Economy",0,-71,-115,-2287,-197,-129,-300,-3099,129,-2970,33099]
[null,"City Centre Management",0,-108,0,-148,0,0,0,-256,0,-256,7]
[null,"Capital Financing Adjustments - Place",0,0,0,0,0,0,0,0,0,0,-2625,null,null,0]
[null,"Other Place Services",-19214,-380,-3018,-42515,-8186,-37231,-788,-111332,37231,-74101,131426,null,null,0]
[null,"Housing Revenue Account",0,0,0,-4962,-282073,-587,0,-287622,587,-287035,0]
[null,"Total Place Directorate",-19214,-380,-3018,-47477,-290259,-37818,-788,-398954,37818,-361136,131426]

{"sheet":"29-33 Cap Prog","index":19,"n_rows":201,"n_cols":7,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
[]
["PROPOSED CAPITAL EXPENDITURE PROGRAMME 2016/17 - 2018/19"]
[]
[null,null,"2016/17","2017/18","2018/19","TOTAL"]
[null,null,null,null,"onwards*"]
[null,null,"£'000","£'000","£'000","£'000"]
["* The figures for 2018/19 onwards include planned spend in later years"]
[]
["PEOPLE DIRECTORATE"]
[]
["Adults & Communities"]
["Transformation of Adult Social Care",null,300,1309,50,1659]
["Programme of Minor Works",null,514,200,100,814]
["Adults Information Technology Schemes",null,1692,950,100,2742]
["Homeless Services",null,1117,null,null,1117]
["Learning Disability Homes & Day Centres",null,500,null,null,500]
["Reform of Adult Care Services",null,3118,null,null,3118]
["Total Adults & Communities",null,7241,2459,250,9950]
[]
["Children, Young People & Families"]
["Aiming Higher for Disabled Children",null,null,450,null,450]
["Devolved Capital Allocation for Schools",null,null,2832,null,2832]
["Schools Capital Maintenance Works",null,18521,13713,null,32234]
["Additional Primary Places - Basic Needs",null,63277,19765,null,83042]
["Early Years",null,null,2000,null,2000]
["Business Transformation - Children's Services",null,1000,3183,null,4183]
["Total Children, Young People & Families",null,82798,41943,0,124741]
[]
["Total People Directorate",null,90039,44402,250,134691]
[]
[]
[]
[null,null,"2016/17","2017/18","2018/19","TOTAL"]
[null,null,null,null,"onwards*"]
[null,null,"£'000","£'000","£'000","£'000"]
["PLACE DIRECTORATE"]
[]
["General Fund"]
["Swimming Pool Facilities",null,5975,null,null,5975]
["Sport & Physical Activity",null,24051,7879,508,32438]
["Fleet & Waste Management",null,8292,155,160,8607]
["Parks",null,3157,53,null,3210]
["New Wholesale Market",null,28691,985,null,29676]
["Community Initiatives",null,457,null,null,457]
["Regulation & Enforcement",null,372,null,null,372]
["Adult Education - Brasshouse Relocation",null,1902,null,null,1902]
["Community Sport",null,23,null,null,23]
["Community Libraries",null,497,null,null,497]
["Community Development & Play",null,18,null,null,18]
["Total Non-Housing",null,73435,9072,668,83175]
[]
["Housing"]
["Council Housing HRA"]
["Housing Improvements Programme",null,35475,38188,53175,126838]
["Other Essential Works",null,14430,12672,12672,39774]
["Redevelopment",null,74355,54765,22527,151647]
["Other Programmes",null,9203,9683,10160,29046]
["Total Council Housing HRA",null,133463,115308,98534,347305]
[]
["Private Sector Housing"]
["Affordable Housing",null,350,350,350,1050]
["Independent Living",null,4408,4403,4400,13211]
["St Vincent Street",null,8000,3950,null,11950]
["Other Programmes",null,352,197,200,749]
["Total Private Sector Housing",null,13110,8900,4950,26960]
[]
["Resilience"]
["Land Drainage & Flood Defences",null,1115,null,null,1115]
["Total Resilience",null,1115,0,0,1115]
[]
["Total Place Directorate",null,221123,133280,104152,458555]
[]
[]
[null,null,"2016/17","2017/18","2018/19","TOTAL"]
[null,null,null,null,"onwards*"]
["CORPORATE RESOURCES DIRECTORATE",null,"£'000","£'000","£'000","£'000"]
[]
["Birmingham Property Services"]
["Access to Buildings",null,438,null,null,438]
["Attwood Green Park",null,29,null,null,29]
["Attwood Green - Holloway Head",null,620,40,null,660]
["Total Birmingham Property Services",null,1087,40,0,1127]
[]
["Corporate Resources - Other"]
["Capitalised Redundancy Costs",null,17000,14000,7000,38000]
["IT Projects - Centralised Desktop",null,200,null,null,200]
["Capital Loans & Equity Funds",null,9067,null,null,9067]
["ICT Infrastructure",null,8231,33318,null,41549]
["SAP Investments",null,4195,1185,115,5495]
["Total Corporate Resources - Other",null,38693,48503,7115,94311]
[]
["Total Corporate Resources Directorate",null,39780,48543,7115,95438]
[]
[]
[null,null,"2016/17","2017/18","2018/19","TOTAL"]
[null,null,null,null,"onwards*"]
["ECONOMY DIRECTORATE",null,"£'000","£'000","£'000","£'000"]
[]
["Planning & Regeneration"]
["Regeneration - Enterprise Zone"]
["Enterprise Zone - Paradise Circus",null,20851,10079,13496,44426]
["Enterprise Zone - Site Development & Access",null,9000,null,null,9000,"*"]
["Enterprise Zone - Connect Economic Opportunities",null,null,null,13301,13301]
["Enterprise Zone - Southern Gateway Site",null,1000,1000,33470,35470]
["Enterprise Zone - LEP Investment Fund",null,null,null,20000,20000]
["Enterprise Zone - HS2 Curzon St Site",null,null,null,30000,30000]
["Enterprise Zone - HS2 Interchange Site",null,null,null,20000,20000]
["Enterprise Zone - Snow Hill Public Realm",null,275,null,null,275]
["Enterprise Zone - Metro Centenary Square",null,3297,3720,600,7617]
["Enterprise Zone - One Station",null,194,421,112,727]
["Total Enterprise Zone",null,34617,15220,130979,180816]
[]
["Regeneration - Other"]
["East Aston Regional Investment Site",null,4236,null,null,4236]
["National College for HS2",null,21453,2136,null,23589]
["Women's Enterprise Centre",null,100,null,null,100]
["Longbridge Regeneration",null,3763,null,null,3763]
["Local Centres",null,933,null,null,933]
["Conservation",null,276,null,null,276]
["Local Improvement Budget",null,44,null,null,44]
["Other City Centre Projects",null,161,null,null,161]
["Planning Other",null,50,51,51,152]
["Total Regeneration",null,31016,2187,51,33254]
[]
["Total Planning & Regeneration",null,65633,17407,131030,214070]
[]
["Transportation  "]
["New Street Station (Gateway)",null,5147,null,null,5147]
["Coventry Road A45",null,1539,null,null,1539]
["Local Growth Fund",null,12870,7197,1300,21367]
["Metro Extension",null,3940,7996,null,11936]
["Infrastructure Development",null,1178,null,null,1178]
["Walking, Cycling & Accessibility",null,1585,null,null,1585]
["Economic Growth & Congestion",null,2757,1651,null,4408]
["Minor Schemes (including balance of ITB)",null,216,3591,4004,7811]
["Total Transportation",null,29232,20435,5304,54971]
[]
["Highways"]
["Structures - Tame Valley Viaduct",null,224,null,null,224]
["Safer Routes to Schools",null,449,300,300,1049]
["Network Integrity",null,378,55,55,488]
["Minworth A38 Improvements",null,3084,163,null,3247]
["Ward Minor Transport Measures",null,500,500,500,1500]
["Road Safety",null,621,300,300,1221]
["Other Minor Schemes",null,149,250,null,399]
["Total Highways",null,5405,1568,1155,8128]
[]
["Total Economy Directorate",null,100270,39410,137489,277169]
[]
["Total Capital Programme",null,451212,265635,249006,965853]
[]
[]
[]
["New Schemes/Funding"]
["The following projects included in the above programme have been added since Quarter 2 2015/16"]
[]
[null,"#","2016/17","2017/18","2018/19","TOTAL"]
[null,null,null,null,"onwards*"]
[null,null,"£'000","£'000","£'000","£'000"]
["People Directorate:"]
["Transfomation of Adult Social Care","A",300,-669,50,-319]
["Replacement Vehicles","A",-1469,null,null,-1469]
["Programme of Minor Works","N",null,200,100,300]
["Improving Information Management","N",null,750,null,750]
["IT Technical Refresh","N",null,200,100,300]
["Total People Directorate",null,-1169,481,250,-438]
[]
["Place Directorate:"]
["Swimming Pool Facilities","N",594,null,null,594]
["Strategic Parks","N",96,3,null,99]
["Private Sector Housing","N",518,518,4950,5986]
["Adult Education - Brasshouse Relocation","N",1902,null,null,1902]
["HRA Housing","N",15316,8858,98594,122768]
["Total Place Directorate",null,18426,9379,103544,131349]
[]
["Corporate Resources Directorate:"]
["Capitalised Redundancy Costs","N",17000,14000,7000,38000]
["Corporately Held - Property Fund","A",-5736,null,null,-5736]
["ICT Infrastructure & SAP","A",-4895,135,115,-4645]
["Total Corporate Resources Directorate",null,6369,14135,7115,27619]
[]
["Economy Directorate:"]
["East Aston Regional Investment Site","N",525,null,null,525]
["Enterprise Zone - minor adjustment","A",null,-84,null,-84]
["Metro Centenary Square","N",3297,3720,600,7617]
["Metro Extension","N",230,220,null,450]
["Planning - Other","A",null,-51,51,0]
["Longbridge Regeneration (Station)","N",3160,null,null,3160]
["National College for HS2","N",21875,2136,null,24011]
["Transportation Schemes","N",-172,3591,4004,7423]
["Local Growth Fund","N",6672,1132,null,7804]
["A38 Minworth Improvements","N",3084,163,null,3247]
["Highways ","N",14,1405,1155,2574]
["Total Economy Directorate",null,38685,12232,5810,56727]
[]
["Total New Schemes / Resources",null,62311,36227,116719,215257]
[]
["Note: this includes some re-phasing between years where additional resources have been identified for"]
["existing programmes and the removal of budgets where savings have been identified."]
["#  A - Amendment"]
["    N - New "]

{"sheet":"34 Cap Pru","index":20,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Analysis of Prudential Borrowing"]
[]
[null,"2016/17","2017/18","2018/19"]
[null,null,null,"onwards*","Total"]
[null,"£m","£m","£m","£m"]
[]
["Major Self Financed Prudential Borrowing"]
[]
["Capital Loans & Equity",8.6999999999999993,null,null,8.6999999999999993]
["Enterprise Zone",31.1,11.1,130.30000000000001,172.5]
["One Station",0.2,0.4,0.1,0.70000000000000007]
["Metro Centenary Square",3.3,3.7,0.6,7.6]
["Metro Extension",3.9,8,null,11.9]
["Housing Private Sector - St Vincent Street",8,4,null,12]
["HRA",27,12.4,5.0999999999999996,44.5]
["Wholesale Markets",28.8,1,null,29.8]
["Sport & Physical Activity",17.8,7.9,0.5,26.200000000000003]
["Fleet & Waste Management Transformation",8.1,null,null,8.1]
["Cofton Park Nurseries",1.833,null,null,1.833]
["Adult Education - Brasshouse Relocation",1.9019999999999999,null,null,1.9019999999999999]
[]
["Total Self Financed",140.63499999999996,48.5,136.6,325.73500000000001]
[]
[]
["Major Prudential Borrowing with net impact on Council revenue resources"]
[]
["Swimming Pool Facilities",6,null,null,6]
["IT Infrastructure & Upgrades",12.6,34.4,0.1,47.1]
["Other",12.3,8.6,1.4,22.299999999999997]
["Total Capital projects requiring revenue resources",30.900000000000002,43,1.5,75.400000000000006]
[]
[]
[]
["Total Prudential Borrowing",171.53499999999997,91.5,138.1,401.13499999999999]
[]
["* the 2018/19 onwards column includes prudential borrowing plans in later years"]