{"indicators":{"grants":{"totals":{"2013":{"SCHD":{"national_conditional_grants":218151000.0},"TRFR":{"national_conditional_grants":174033000.0}},"2014":{"SCHD":{"national_conditional_grants":279745000.0},"TRFR":{"national_conditional_grants":255158000.0}},"2015":{"ACT":{"national_conditional_grants":182391974.0},"SCHD":{"national_conditional_grants":345667000.0},"TRFR":{"national_conditional_grants":194731000.0}},"2016":{"ACT":{"national_conditional_grants":173216325.0},"SCHD":{"national_conditional_grants":296009000.0},"TRFR":{"national_conditional_grants":205652000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{},"provincial_transfers":{},"national_conditional_grants":{"2013":[{"amount.sum":6000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":6000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2013},{"amount.sum":1500000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":1500000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2013},{"amount.sum":36118000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":50000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":50000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2013},{"amount.sum":74355000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":74355000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2013},{"amount.sum":800000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":800000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2013},{"amount.sum":2000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":40000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":40000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2013},{"amount.sum":1378000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":1378000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2013},{"amount.sum":6000000.0,"grant.code":"RH7G","grant.label":"Rural Households Infrastructure Grant (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2013}],"2014":[{"amount.sum":20000000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":20000000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":1550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":1550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":20734000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":50000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":50000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":155983000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":155983000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":890000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":890000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":2000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":25000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":25000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":1735000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":1735000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":1853000.0,"grant.code":"RH7G","grant.label":"Rural Households Infrastructure Grant (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2014}],"2015":[{"amount.sum":3365740.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":1600000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":1600000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":1600000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":145436000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":45000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":45000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":45000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":107358117.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":126460000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":126460000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":898286.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":934000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":934000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":1000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":22432831.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":15000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":15000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":1737000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":1737000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":1737000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":4500000.0,"grant.code":"RH7G","grant.label":"Rural Households Infrastructure Grant (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2015}],"2016":[{"amount.sum":3870272.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":8000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":8000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":1600000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":1600000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":1600000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":85857000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":60000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":60000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":60000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":105205053.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":132820000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":132820000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":930000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":930000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":930000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":1611000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":2302000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":2302000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":4500000.0,"grant.code":"RH7G","grant.label":"Rural Households Infrastructure Grant (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2016}]}},"cash_balance":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2015,"rating":"good","result":313266673.0,"cube_version":"v1"},{"date":2014,"rating":"good","result":253664278.0,"cube_version":"v1"},{"date":2013,"rating":"good","result":292292953.0,"cube_version":"v1"},{"date":2012,"rating":"good","result":190736627.0,"cube_version":"v1"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2015,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2015,"rating":"good","result":6.0,"cube_version":"v1"},{"date":2014,"rating":"good","result":7.0,"cube_version":"v1"},{"date":2013,"rating":"good","result":6.9,"cube_version":"v1"},{"date":2012,"rating":"good","result":6.7,"cube_version":"v1"}],"formula":{"text":"= Cash available at year end / Operating Expenditure per month","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"},"/","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"/","12",")"]},"last_year":2015,"formula_v2":{"text":"= Cash available at year end / Operating Expenditure per month","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"},"/","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"/","12",")"]},"result_type":"months"},"current_ratio":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2015,"year":2015,"assets":462703358.0,"rating":"good","result":4.26,"amount_type":"AUDA","liabilities":108549371.0,"cube_version":"v1"},{"date":2014,"year":2014,"assets":502224632.0,"rating":"good","result":3.26,"amount_type":"AUDA","liabilities":154230856.0,"cube_version":"v1"},{"date":2013,"year":2013,"assets":332796842.0,"rating":"good","result":1.88,"amount_type":"AUDA","liabilities":177255006.0,"cube_version":"v1"},{"date":2012,"year":2012,"assets":341805494.0,"rating":"good","result":2.88,"amount_type":"AUDA","liabilities":118791908.0,"cube_version":"v1"}],"formula":{"text":"= Current Assets / Current Liabilities","actual":["=",{"cube":"bsheet","item_codes":["2150"],"amount_type":"AUDA"},"/",{"cube":"bsheet","item_codes":["1600"],"amount_type":"AUDA"}]},"last_year":2015,"formula_v2":{"text":"= Current Assets / Current Liabilities","actual":["=",{"cube":"financial_position_v2","item_codes":["0120","0125","0130","0140","0150","0160","0170","0180"],"amount_type":"AUDA"},"/",{"cube":"financial_position_v2","item_codes":["0330","0340","0350","0360","0370","0380","0390","0400","0410","0420"],"amount_type":"AUDA"}]},"result_type":"ratio"},"liquidity_ratio":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"cash":313266843.0,"date":"2015","year":2015,"rating":"good","result":2.89,"amount_type":"ACT","liabilities":108549371.0,"cube_version":"v1","call_investment_deposits":0.0},{"cash":253664103.0,"date":"2014","year":2014,"rating":"good","result":2.31,"amount_type":"ACT","liabilities":154230856.0,"cube_version":"v1","call_investment_deposits":102554832.0},{"cash":292292699.0,"date":"2013","year":2013,"rating":"good","result":1.65,"amount_type":"ACT","liabilities":177255006.0,"cube_version":"v1","call_investment_deposits":0.0},{"cash":190736629.0,"date":"2012","year":2012,"rating":"good","result":1.61,"amount_type":"ACT","liabilities":118791908.0,"cube_version":"v1","call_investment_deposits":0.0}],"formula":{"text":"= (Cash + Call Investment Deposits) / Current Liabilities","actual":["=",{"cube":"bsheet","item_codes":["1800","2200"],"amount_type":"AUDA"},"/",{"cube":"bsheet","item_codes":["1600"],"amount_type":"AUDA"}]},"last_year":2015,"formula_v2":{"text":"= (Cash + Call Investment Deposits) / Current Liabilities","actual":["=",{"cube":"financial_position_v2","item_codes":["0120","0125"],"amount_type":"AUDA"},"/",{"cube":"financial_position_v2","item_codes":["0330","0340","0350","0360","0370","0380","0390","0400","0410","0420"],"amount_type":"AUDA"}]},"result_type":"ratio"},"revenue_sources":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"year":2015,"local":{"amount":265867263.0,"percent":33.82},"total":786235692.0,"rating":"bad","formula":{"text":"= Total revenue","actual":["=",{"cube":"incexp","item_codes":["0200","0300","0400","0700","0800","1000","1100","1300","1400","1500","1700","1800","1600","1610"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total revenue","actual":["=",{"cube":"incexp_v2","item_codes":["0200","0300","0400","0500","0600","0700","0800","0900","1000","1100","1200","1300","1400","1500","1550","1570","1590","1600","1700","1800","1900","2000","2100","2300","2400","2500","2600","2700","2800","2200"],"amount_type":"AUDA"}]},"government":{"amount":520368429.0,"percent":66.18}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2015,"rating":"bad","result":5.14,"cube_version":"v1"},{"date":2014,"rating":"bad","result":3.28,"cube_version":"v1"},{"date":2013,"rating":"good","result":0.0,"cube_version":"v1"},{"date":2012,"rating":"bad","result":8.41,"cube_version":"v1"}],"formula":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},")","*","100"]},"last_year":2015,"formula_v2":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"income_adjustments":{"2012":[{"item":"Fines","amount":1350000.0,"comparison":"Original to adjusted budget","percent_changed":55.1},{"item":"Fines","amount":1555673.0,"comparison":"Original budget to audited outcome","percent_changed":63.5},{"item":"Government Transfers","amount":79002841.0,"comparison":"Original to adjusted budget","percent_changed":19.34},{"item":"Government Transfers","amount":22364446.0,"comparison":"Original budget to audited outcome","percent_changed":5.48},{"item":"Interest and investments","amount":1655500.0,"comparison":"Original to adjusted budget","percent_changed":6.06},{"item":"Interest and investments","amount":-19982261.0,"comparison":"Original budget to audited outcome","percent_changed":-73.2},{"item":"Licenses and Permits","amount":-1860238.0,"comparison":"Original to adjusted budget","percent_changed":-16.88},{"item":"Licenses and Permits","amount":538097.0,"comparison":"Original budget to audited outcome","percent_changed":4.88},{"item":"Other","amount":-13990000.0,"comparison":"Original to adjusted budget","percent_changed":-9.31},{"item":"Other","amount":-121751280.0,"comparison":"Original budget to audited outcome","percent_changed":-80.99},{"item":"Property rates","amount":8500000.0,"comparison":"Original to adjusted budget","percent_changed":54.84},{"item":"Property rates","amount":9925680.0,"comparison":"Original budget to audited outcome","percent_changed":64.04},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":217006.0,"comparison":"Original budget to audited outcome","percent_changed":76.95},{"item":"Service Charges","amount":8850000.0,"comparison":"Original to adjusted budget","percent_changed":31.02},{"item":"Service Charges","amount":7229268.0,"comparison":"Original budget to audited outcome","percent_changed":25.34}],"2013":[{"item":"Fines","amount":-3000000.0,"comparison":"Original to adjusted budget","percent_changed":-50.0},{"item":"Fines","amount":-2137196.0,"comparison":"Original budget to audited outcome","percent_changed":-35.62},{"item":"Government Transfers","amount":17335954.0,"comparison":"Original to adjusted budget","percent_changed":4.03},{"item":"Government Transfers","amount":-15807609.0,"comparison":"Original budget to audited outcome","percent_changed":-3.68},{"item":"Interest and investments","amount":-12700000.0,"comparison":"Original to adjusted budget","percent_changed":-37.35},{"item":"Interest and investments","amount":-12628136.0,"comparison":"Original budget to audited outcome","percent_changed":-37.14},{"item":"Licenses and Permits","amount":2000000.0,"comparison":"Original to adjusted budget","percent_changed":18.18},{"item":"Licenses and Permits","amount":774015.0,"comparison":"Original budget to audited outcome","percent_changed":7.04},{"item":"Other","amount":-4983000.0,"comparison":"Original to adjusted budget","percent_changed":-3.18},{"item":"Other","amount":-136655552.0,"comparison":"Original budget to audited outcome","percent_changed":-87.09},{"item":"Property rates","amount":-1712000.0,"comparison":"Original to adjusted budget","percent_changed":-5.27},{"item":"Property rates","amount":2524960.0,"comparison":"Original budget to audited outcome","percent_changed":7.77},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-96334.0,"comparison":"Original budget to audited outcome","percent_changed":-16.06},{"item":"Service Charges","amount":-25040000.0,"comparison":"Original to adjusted budget","percent_changed":-41.02},{"item":"Service Charges","amount":-25555399.0,"comparison":"Original budget to audited outcome","percent_changed":-41.86}],"2014":[{"item":"Fines","amount":-2153000.0,"comparison":"Original to adjusted budget","percent_changed":-68.28},{"item":"Fines","amount":9991284.0,"comparison":"Original budget to audited outcome","percent_changed":316.88},{"item":"Government Transfers","amount":34442756.0,"comparison":"Original to adjusted budget","percent_changed":7.42},{"item":"Government Transfers","amount":-17862641.0,"comparison":"Original budget to audited outcome","percent_changed":-3.85},{"item":"Interest and investments","amount":7796745.0,"comparison":"Original to adjusted budget","percent_changed":38.98},{"item":"Interest and investments","amount":9873373.0,"comparison":"Original budget to audited outcome","percent_changed":49.36},{"item":"Licenses and Permits","amount":232000.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Licenses and Permits","amount":12474633.0,"comparison":"Original budget to audited outcome","percent_changed":0},{"item":"Other","amount":49826000.0,"comparison":"Original to adjusted budget","percent_changed":59.94},{"item":"Other","amount":-64810408.0,"comparison":"Original budget to audited outcome","percent_changed":-77.96},{"item":"Property rates","amount":3325000.0,"comparison":"Original to adjusted budget","percent_changed":10.39},{"item":"Property rates","amount":3148268.0,"comparison":"Original budget to audited outcome","percent_changed":9.84},{"item":"Rental income","amount":316000.0,"comparison":"Original to adjusted budget","percent_changed":94.61},{"item":"Rental income","amount":214263.0,"comparison":"Original budget to audited outcome","percent_changed":64.15},{"item":"Service Charges","amount":5600000.0,"comparison":"Original to adjusted budget","percent_changed":14.7},{"item":"Service Charges","amount":5402195.0,"comparison":"Original budget to audited outcome","percent_changed":14.18}],"2015":[{"item":"Fines","amount":12706000.0,"comparison":"Original to adjusted budget","percent_changed":423.53},{"item":"Fines","amount":13511560.0,"comparison":"Original budget to audited outcome","percent_changed":450.39},{"item":"Government Transfers","amount":52684330.0,"comparison":"Original to adjusted budget","percent_changed":9.88},{"item":"Government Transfers","amount":-12829571.0,"comparison":"Original budget to audited outcome","percent_changed":-2.41},{"item":"Interest and investments","amount":2000000.0,"comparison":"Original to adjusted budget","percent_changed":6.67},{"item":"Interest and investments","amount":5564435.0,"comparison":"Original budget to audited outcome","percent_changed":18.55},{"item":"Licenses and Permits","amount":17000.0,"comparison":"Original to adjusted budget","percent_changed":5.15},{"item":"Licenses and Permits","amount":12265000.0,"comparison":"Original budget to audited outcome","percent_changed":3716.67},{"item":"Other","amount":-105900404.0,"comparison":"Original to adjusted budget","percent_changed":-55.64},{"item":"Other","amount":-78532549.0,"comparison":"Original budget to audited outcome","percent_changed":-41.26},{"item":"Property rates","amount":-50537858.0,"comparison":"Original to adjusted budget","percent_changed":-48.68},{"item":"Property rates","amount":-62112306.0,"comparison":"Original budget to audited outcome","percent_changed":-59.82},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-315420.0,"comparison":"Original budget to audited outcome","percent_changed":-31.54},{"item":"Service Charges","amount":25220452.0,"comparison":"Original to adjusted budget","percent_changed":114.89},{"item":"Service Charges","amount":25044121.0,"comparison":"Original budget to audited outcome","percent_changed":114.09}]},"income_time_series":[{"amount":727352249.0,"budget_phase":"Adjusted Budget","financial_year":2012,"amount_type.code":"ADJB"},{"amount":704021000.0,"budget_phase":"Adjusted Budget","financial_year":2013,"amount_type.code":"ADJB"},{"amount":740111756.0,"budget_phase":"Adjusted Budget","financial_year":2014,"amount_type.code":"ADJB"},{"amount":819829942.0,"budget_phase":"Adjusted Budget","financial_year":2015,"amount_type.code":"ADJB"},{"amount":844480829.0,"budget_phase":"Adjusted Budget","financial_year":2016,"amount_type.code":"ADJB"},{"amount":543940775.0,"budget_phase":"Audited Actual","financial_year":2012,"amount_type.code":"AUDA"},{"amount":542538795.0,"budget_phase":"Audited Actual","financial_year":2013,"amount_type.code":"AUDA"},{"amount":599157222.0,"budget_phase":"Audited Actual","financial_year":2014,"amount_type.code":"AUDA"},{"amount":786235692.0,"budget_phase":"Audited Actual","financial_year":2015,"amount_type.code":"AUDA"},{"amount":804180742.0,"budget_phase":"Audited Actual","financial_year":2016,"amount_type.code":"AUDA"},{"amount":892354707.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2017,"amount_type.code":"IBY1"},{"amount":921558231.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2018,"amount_type.code":"IBY2"},{"amount":643844146.0,"budget_phase":"Original Budget","financial_year":2012,"amount_type.code":"ORGB"},{"amount":732120046.0,"budget_phase":"Original Budget","financial_year":2013,"amount_type.code":"ORGB"},{"amount":640726255.0,"budget_phase":"Original Budget","financial_year":2014,"amount_type.code":"ORGB"},{"amount":883640422.0,"budget_phase":"Original Budget","financial_year":2015,"amount_type.code":"ORGB"},{"amount":870610822.0,"budget_phase":"Original Budget","financial_year":2016,"amount_type.code":"ORGB"}],"spending_adjustments":{"2012":[{"item":"Bulk purchases","amount":-5000000.0,"comparison":"Original to adjusted budget","percent_changed":-100.0},{"item":"Bulk purchases","amount":-5000000.0,"comparison":"Original budget to audited outcome","percent_changed":-100.0},{"item":"Contracted services","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Contracted services","amount":306695.0,"comparison":"Original budget to audited outcome","percent_changed":0},{"item":"Employee related costs","amount":-2442384.0,"comparison":"Original to adjusted budget","percent_changed":-1.44},{"item":"Employee related costs","amount":-56181546.0,"comparison":"Original budget to audited outcome","percent_changed":-33.03},{"item":"Finance charges","amount":9000000.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Finance charges","amount":4910061.0,"comparison":"Original budget to audited outcome","percent_changed":0},{"item":"Other","amount":40051513.0,"comparison":"Original to adjusted budget","percent_changed":11.45},{"item":"Other","amount":-146289736.0,"comparison":"Original budget to audited outcome","percent_changed":-41.81},{"item":"Remuneration of councillors","amount":-113026.0,"comparison":"Original to adjusted budget","percent_changed":-0.49},{"item":"Remuneration of councillors","amount":-4316275.0,"comparison":"Original budget to audited outcome","percent_changed":-18.72},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original budget to audited outcome","percent_changed":0}],"2013":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Bulk purchases","amount":0.0,"comparison":"Original budget to audited outcome","percent_changed":0},{"item":"Contracted services","amount":700000.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Contracted services","amount":3495500.0,"comparison":"Original budget to audited outcome","percent_changed":0},{"item":"Employee related costs","amount":-13965481.0,"comparison":"Original to adjusted budget","percent_changed":-8.34},{"item":"Employee related costs","amount":-24205794.0,"comparison":"Original budget to audited outcome","percent_changed":-14.46},{"item":"Finance charges","amount":-1310000.0,"comparison":"Original to adjusted budget","percent_changed":-32.35},{"item":"Finance charges","amount":-2307149.0,"comparison":"Original budget to audited outcome","percent_changed":-56.97},{"item":"Other","amount":7511704.0,"comparison":"Original to adjusted budget","percent_changed":2.28},{"item":"Other","amount":6548718.0,"comparison":"Original budget to audited outcome","percent_changed":1.99},{"item":"Remuneration of councillors","amount":-4182272.0,"comparison":"Original to adjusted budget","percent_changed":-17.36},{"item":"Remuneration of councillors","amount":-3685529.0,"comparison":"Original budget to audited outcome","percent_changed":-15.29},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original budget to audited outcome","percent_changed":0}],"2014":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Bulk purchases","amount":0.0,"comparison":"Original budget to audited outcome","percent_changed":0},{"item":"Contracted services","amount":2460000.0,"comparison":"Original to adjusted budget","percent_changed":410.0},{"item":"Contracted services","amount":3386531.0,"comparison":"Original budget to audited outcome","percent_changed":564.42},{"item":"Employee related costs","amount":7141796.0,"comparison":"Original to adjusted budget","percent_changed":4.37},{"item":"Employee related costs","amount":9393635.0,"comparison":"Original budget to audited outcome","percent_changed":5.75},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":-642743.0,"comparison":"Original budget to audited outcome","percent_changed":-32.14},{"item":"Other","amount":59461790.0,"comparison":"Original to adjusted budget","percent_changed":22.73},{"item":"Other","amount":-23929425.0,"comparison":"Original budget to audited outcome","percent_changed":-9.15},{"item":"Remuneration of councillors","amount":-558000.0,"comparison":"Original to adjusted budget","percent_changed":-2.46},{"item":"Remuneration of councillors","amount":-535633.0,"comparison":"Original budget to audited outcome","percent_changed":-2.36},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original budget to audited outcome","percent_changed":0}],"2015":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Bulk purchases","amount":0.0,"comparison":"Original budget to audited outcome","percent_changed":0},{"item":"Contracted services","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Contracted services","amount":2185000.0,"comparison":"Original budget to audited outcome","percent_changed":71.41},{"item":"Employee related costs","amount":4517054.0,"comparison":"Original to adjusted budget","percent_changed":2.46},{"item":"Employee related costs","amount":9161836.0,"comparison":"Original budget to audited outcome","percent_changed":4.98},{"item":"Finance charges","amount":350000.0,"comparison":"Original to adjusted budget","percent_changed":16.67},{"item":"Finance charges","amount":598296.0,"comparison":"Original budget to audited outcome","percent_changed":28.49},{"item":"Other","amount":27269045.0,"comparison":"Original to adjusted budget","percent_changed":8.06},{"item":"Other","amount":62964303.0,"comparison":"Original budget to audited outcome","percent_changed":18.61},{"item":"Remuneration of councillors","amount":441.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":1170484.0,"comparison":"Original budget to audited outcome","percent_changed":5.25},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original budget to audited outcome","percent_changed":0}]},"spending_time_series":[{"amount":589481749.0,"budget_phase":"Adjusted Budget","financial_year":2012,"amount_type.code":"ADJB"},{"amount":514090999.0,"budget_phase":"Adjusted Budget","financial_year":2013,"amount_type.code":"ADJB"},{"amount":518705381.0,"budget_phase":"Adjusted Budget","financial_year":2014,"amount_type.code":"ADJB"},{"amount":581913962.0,"budget_phase":"Adjusted Budget","financial_year":2015,"amount_type.code":"ADJB"},{"amount":642149979.0,"budget_phase":"Adjusted Budget","financial_year":2016,"amount_type.code":"ADJB"},{"amount":341414845.0,"budget_phase":"Audited Actual","financial_year":2012,"amount_type.code":"AUDA"},{"amount":505182794.0,"budget_phase":"Audited Actual","financial_year":2013,"amount_type.code":"AUDA"},{"amount":437872160.0,"budget_phase":"Audited Actual","financial_year":2014,"amount_type.code":"AUDA"},{"amount":625857341.0,"budget_phase":"Audited Actual","financial_year":2015,"amount_type.code":"AUDA"},{"amount":917047239.0,"budget_phase":"Audited Actual","financial_year":2016,"amount_type.code":"AUDA"},{"amount":555701210.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2017,"amount_type.code":"IBY1"},{"amount":602001142.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2018,"amount_type.code":"IBY2"},{"amount":547985646.0,"budget_phase":"Original Budget","financial_year":2012,"amount_type.code":"ORGB"},{"amount":525337048.0,"budget_phase":"Original Budget","financial_year":2013,"amount_type.code":"ORGB"},{"amount":450199795.0,"budget_phase":"Original Budget","financial_year":2014,"amount_type.code":"ORGB"},{"amount":549777422.0,"budget_phase":"Original Budget","financial_year":2015,"amount_type.code":"ORGB"},{"amount":638190824.0,"budget_phase":"Original Budget","financial_year":2016,"amount_type.code":"ORGB"}],"capital_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2015,"rating":"bad","result":-22.37,"overunder":"under","cube_version":"v1"},{"date":2014,"rating":"bad","result":-25.26,"overunder":"under","cube_version":"v1"},{"date":2013,"rating":"bad","result":-42.15,"overunder":"under","cube_version":"v1"},{"date":2012,"rating":"ave","result":-10.22,"overunder":"under","cube_version":"v1"}],"formula":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital","item_codes":["4100"],"amount_type":"AUDA"},"-",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","/",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","*","100"]},"last_year":2015,"formula_v2":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital_v2","amount_type":"AUDA","item_description":"capital type code NEW, RENEWAL, UPGRADING"},"-",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","/",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","*","100"]},"result_type":"%"},"local_revenue_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":"2015","item":"Property rates","amount":41711945.0,"amount_type":"AUDA"},{"date":"2015","item":"Service Charges","amount":46995000.0,"amount_type":"AUDA"},{"date":"2015","item":"Rental income","amount":684580.0,"amount_type":"AUDA"},{"date":"2015","item":"Interest and investments","amount":35564435.0,"amount_type":"AUDA"},{"date":"2015","item":"Fines","amount":16511560.0,"amount_type":"AUDA"},{"date":"2015","item":"Licenses and Permits","amount":12595000.0,"amount_type":"AUDA"},{"date":"2015","item":"Agency services","amount":0.0,"amount_type":"AUDA"},{"date":"2015","item":"Other","amount":111804743.0,"amount_type":"AUDA"}],"formula":{"text":"= Breakdown of local income","actual":["=",{"cube":"incexp","item_codes":["0200","0300","0400","0700","0800","1000","1100","1300","1400","1500","1700","1800","1600","1610"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Breakdown of local income","actual":["=",{"cube":"incexp_v2","item_codes":["0200","0300","0400","0500","0600","0700","0800","0900","1000","1100","1200","1300","1400","1500","1550","1570","1590","1600","1700","1800","1900","2000","2100","2300","2400","2500","2600","2700","2800","2200"],"amount_type":"AUDA"}]}},"expenditure_trends_staff":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":2015,"rating":"","result":30.85},{"date":2014,"rating":"","result":39.45},{"date":2013,"rating":"","result":28.35},{"date":2012,"rating":"","result":33.36}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2015,"rating":"ave","result":7.6,"overunder":"over","cube_version":"v1"},{"date":2014,"rating":"bad","result":-15.6,"overunder":"under","cube_version":"v1"},{"date":2013,"rating":"good","result":-1.7,"overunder":"under","cube_version":"v1"},{"date":2012,"rating":"bad","result":-42.1,"overunder":"under","cube_version":"v1"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2015,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2015,"rating":"bad","result":1.33,"cube_version":"v1"},{"date":2014,"rating":"bad","result":0.0,"cube_version":"v1"},{"date":2013,"rating":"bad","result":4.24,"cube_version":"v1"},{"date":2012,"rating":"bad","result":5.05,"cube_version":"v1"}],"formula":{"text":"= (Repairs and maintenance expenditure / (Property, Plant and Equipment + Investment Property)) * 100","actual":["=","(",{"cube":"capital","item_codes":["4100"],"amount_type":"AUDA"},"/","(",{"cube":"bsheet","item_codes":["1300"],"amount_type":"AUDA"},"+",{"cube":"bsheet","item_codes":["1401"],"amount_type":"AUDA"},")",")","*","100"]},"last_year":2015,"formula_v2":{"text":"= (Repairs and maintenance expenditure / (Property, Plant and Equipment + Investment Property)) * 100","actual":["=","(",{"cube":"capital_v2","amount_type":"AUDA","item_description":"capital type code REPAIR_MNT Total"},"/","(",{"cube":"financial_position_v2","item_codes":["0230","0220"],"amount_type":"AUDA"},")",")","*","100"]},"result_type":"%"},"expenditure_trends_contracting":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":2015,"rating":"","result":0.84},{"date":2014,"rating":"","result":0.91},{"date":2013,"rating":"","result":0.69},{"date":2012,"rating":"","result":0.09}],"formula":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp","item_codes":["4200"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp_v2","item_codes":["3800"],"amount_type":"AUDA"}]},"result_type":"%"},"current_debtors_collection_rate":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"date":"2015","year":2015,"rating":"bad","result":50.73,"amount_type":"AUDA","cube_version":"v1"},{"date":"2014","year":2014,"rating":"bad","result":20.36,"amount_type":"AUDA","cube_version":"v1"},{"date":"2013","year":2013,"rating":"good","result":100.88,"amount_type":"AUDA","cube_version":"v1"},{"date":"2012","year":2012,"rating":"bad","result":33.74,"amount_type":"AUDA","cube_version":"v1"}],"formula":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow","item_codes":["3010","3030","3040","3050","3060","3070","3100"],"amount_type":"AUDA"},"/",{"cube":"incexp","item_codes":["0200","0400","1000","less item code","2000"],"amount_type":"AUDA"},")","*","100"]},"last_year":2015,"formula_v2":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow_v2","item_codes":["0120","0130","0280"],"amount_type":"AUDA"},"/",{"cube":"incexp_v2","item_codes":["1800","0300","0400","0500","0600","1400","1100","1000"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"expenditure_functional_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"values":[{"year":2012,"value":177517389.0},{"year":2013,"value":286380190.0},{"year":2014,"value":215978714.0},{"year":2015,"value":377765086.0},{"year":2016,"value":261742026.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2012,"value":10261856.0},{"year":2013,"value":12663559.0},{"year":2014,"value":37200913.0},{"year":2015,"value":33844013.0},{"year":2016,"value":58994789.0}],"category":"Housing"},{"values":[{"year":2012,"value":26838825.0},{"year":2013,"value":24924320.0},{"year":2014,"value":28065765.0},{"year":2015,"value":46587757.0},{"year":2016,"value":47193425.0}],"category":"Public Safety"},{"values":[{"year":2012,"value":98703444.0},{"year":2013,"value":136879089.0},{"year":2014,"value":87286363.0},{"year":2015,"value":100572775.0},{"year":2016,"value":484432259.0}],"category":"Road Transport"},{"values":[{"year":2012,"value":9174549.0},{"year":2013,"value":21117589.0},{"year":2014,"value":30425052.0},{"year":2015,"value":24392563.0},{"year":2016,"value":18227328.0}],"category":"Sport And Recreation"},{"values":[{"year":2012,"value":18918782.0},{"year":2013,"value":23218047.0},{"year":2014,"value":38915353.0},{"year":2015,"value":42695147.0},{"year":2016,"value":46457412.0}],"category":"Waste Management"},{"values":[{"year":2012,"value":0.0}],"category":"Waste Water Management"}],"formula":{"text":"= All expenditure by function","actual":["=",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= All expenditure by function","actual":["=",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"}]}}},"demarcation":{"land_lost":[{"date":"2016-08-03","changes":[{"change":"established","demarcation_code":"LIM345"}]}],"land_gained":[{"date":"2016-08-03","changes":[{"change":"disestablished","demarcation_code":"LIM342"}]}],"code":"LIM343"},"muni_contact":{"url":"http://www.thulamela.gov.za","phone_number":"015 962 7500","street_address_1":"Old Agriven Building Ardc","street_address_2":"Thohoyandou","street_address_3":"Thohoyandou","street_address_4":"0950"},"mayoral_staff":{"officials":[{"name":"Rammbuda As","role":"Mayor/Executive Mayor","email":"rammbudaas@thulamela.gov.za","title":"Cllr","secretary":{"name":"Lumadi Rofhiwa","role":"Secretary of Mayor/Executive Mayor","email":"Singord@thulamela.gov.za","title":"Ms","fax_number":"015 962 4020","office_phone":"015 962 7620"},"fax_number":"015 962 4020","office_phone":"015 962 7664"},{"name":"K T M SIGIDI","role":"Municipal Manager","email":"muthotho@thulamela.gov.za","title":"Mr","secretary":{"name":"R R Mojela","role":"Secretary of Municipal Manager","email":"mojelarr@thulamela.gov.za","title":"Mr","fax_number":"015 962 4169","office_phone":"015 962 7624"},"fax_number":" ","office_phone":"015 962 7593"},{"name":"","role":"Deputy Mayor/Executive Mayor","email":"","title":"","secretary":{"name":"","role":"Secretary of Deputy Mayor/Executive Mayor","email":"","title":"","fax_number":"","office_phone":""},"fax_number":"","office_phone":""},{"name":"A C Mufamadi","role":"Chief Financial Officer","email":"mufamadiac@thulamela.gov.za","title":"Mr","secretary":{"name":"T F Mafhaga","role":"Secretary of Financial Manager","email":"mafhagatf@thulamela.gov.za","title":"Mrs","fax_number":"015 962 7614","office_phone":"015 962 7614"},"fax_number":"015 962 4020","office_phone":"015 962 7515"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2015,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"http://mfma.treasury.gov.za/Documents/07.%20Audit%20Reports/2014-15/02.%20Local%20municipalities/LIM343%20Thulamela/LIM343%20Thulamela%20%20Audit%20report%202014-15.pdf"},{"date":2014,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"http://mfma.treasury.gov.za/Documents/07.%20Audit%20Reports/2013-14/02.%20Local%20municipalities/LIM343%20Thulamela/LIM343%20Thulamela%20Audit%20report%202013-14.pdf"},{"date":2013,"rating":"qualified","result":"Qualified","report_url":"http://mfma.treasury.gov.za/Documents/07.%20Audit%20Reports/2012-13/02.%20Local%20Municipalities/LIM343%20Thulamela/LIM343%20Thulamela%20Audit%20report%202012-13.pdf"},{"date":2012,"rating":"qualified","result":"Qualified","report_url":"http://mfma.treasury.gov.za/Documents/07.%20Audit%20Reports/2011-12/02.%20Local%20municipalities/LIM343%20Thulamela/LIM343%20Thulamela%20Audit%20Report%202011-12.pdf"}]}}