{"indicators":{"grants":{"totals":{"2013":{"SCHD":{"national_conditional_grants":352076000.0},"TRFR":{"national_conditional_grants":306528000.0}},"2014":{"SCHD":{"national_conditional_grants":436157000.0},"TRFR":{"national_conditional_grants":395461000.0}},"2015":{"ACT":{"national_conditional_grants":502569539.0},"SCHD":{"national_conditional_grants":628947000.0},"TRFR":{"national_conditional_grants":531716000.0}},"2016":{"ACT":{"national_conditional_grants":389422021.0},"SCHD":{"national_conditional_grants":683490000.0},"TRFR":{"national_conditional_grants":572062000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{},"provincial_transfers":{},"national_conditional_grants":{"2013":[{"amount.sum":31500000.0,"grant.code":"ACNG","grant.label":"2013 Africa Cup of Nations Host City Operating Grant","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":5000000.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":5000000.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":13018000.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":188062000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":188062000.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":730000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":98703000.0,"grant.code":"PTIG","grant.label":"Public Transport Infrastructure and Systems Grant","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":98703000.0,"grant.code":"PTIG","grant.label":"Public Transport Infrastructure and Systems Grant","amount_type.code":"TRFR","financial_year_end.year":2013},{"amount.sum":2954000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":2954000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2013},{"amount.sum":300000.0,"grant.code":"WS7G","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":9509000.0,"grant.code":"WSOG","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2013},{"amount.sum":9509000.0,"grant.code":"WSOG","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2013}],"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":39446000.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":8000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":8000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":241164000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":241164000.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":7660000.0,"grant.code":"MWIG","grant.label":"Municipal Water Infrastructure Grant (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":7660000.0,"grant.code":"MWIG","grant.label":"Municipal Water Infrastructure Grant (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":1000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":1560000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":1560000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":123762000.0,"grant.code":"PTIG","grant.label":"Public Transport Infrastructure and Systems Grant","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":123762000.0,"grant.code":"PTIG","grant.label":"Public Transport Infrastructure and Systems Grant","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":1695000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":1695000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2014},{"amount.sum":250000.0,"grant.code":"WS7G","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":9180000.0,"grant.code":"WSOG","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2014},{"amount.sum":9180000.0,"grant.code":"WSOG","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2014}],"2015":[{"amount.sum":4958000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":4958000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":4476187.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":1950000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":1950000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":1494203.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":76117000.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":7473173.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":288462235.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":286043000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":286043000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":1058684.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":18151000.0,"grant.code":"MW7G","grant.label":"Municipal Water Infrastructure Grant (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":2663000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":7368649.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":10000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":10000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":173484514.0,"grant.code":"PTIG","grant.label":"Public Transport Infrastructure and Systems Grant","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":195191000.0,"grant.code":"PTIG","grant.label":"Public Transport Infrastructure and Systems Grant","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":195191000.0,"grant.code":"PTIG","grant.label":"Public Transport Infrastructure and Systems Grant","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":3458050.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":6040000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":6040000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2015},{"amount.sum":300000.0,"grant.code":"WS7G","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":15293844.0,"grant.code":"WSOG","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2015},{"amount.sum":15000000.0,"grant.code":"WSOG","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2015},{"amount.sum":15000000.0,"grant.code":"WSOG","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2015}],"2016":[{"amount.sum":-1250855.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":7000000.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":7000000.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":1054511.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":50438000.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":235192460.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":298264000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":298264000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":542046.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":37146990.0,"grant.code":"MWIG","grant.label":"Municipal Water Infrastructure Grant (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":55000000.0,"grant.code":"MWIG","grant.label":"Municipal Water Infrastructure Grant (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":55000000.0,"grant.code":"MWIG","grant.label":"Municipal Water Infrastructure Grant (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":1800000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":36014532.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":65829000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":65829000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":52676449.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":116540000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":116540000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":9480950.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":6899000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":6899000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2016},{"amount.sum":59190000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":18564938.0,"grant.code":"WSOG","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2016},{"amount.sum":20000000.0,"grant.code":"WSOG","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2016},{"amount.sum":20000000.0,"grant.code":"WSOG","grant.label":"Water Services Operating and Transfer Subsidy Grant (Schedule 5B)","amount_type.code":"TRFR","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":94843988.0,"cube_version":"v1"},{"date":2014,"rating":"good","result":96112103.0,"cube_version":"v1"},{"date":2013,"rating":"good","result":19558126.0,"cube_version":"v1"},{"date":2012,"rating":"good","result":35792006.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":"bad","result":0.5,"cube_version":"v1"},{"date":2014,"rating":"bad","result":0.6,"cube_version":"v1"},{"date":2013,"rating":"bad","result":0.1,"cube_version":"v1"},{"date":2012,"rating":"bad","result":0.3,"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":361833655.0,"rating":"bad","result":0.32,"amount_type":"AUDA","liabilities":1114662321.0,"cube_version":"v1"},{"date":2014,"year":2014,"assets":279660609.0,"rating":"bad","result":0.33,"amount_type":"AUDA","liabilities":842239475.0,"cube_version":"v1"},{"date":2013,"year":2013,"assets":189656585.0,"rating":"bad","result":0.28,"amount_type":"AUDA","liabilities":668455782.0,"cube_version":"v1"},{"date":2012,"year":2012,"assets":209942045.0,"rating":"bad","result":0.38,"amount_type":"AUDA","liabilities":556235248.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":94843989.0,"date":"2015","year":2015,"rating":"bad","result":0.09,"amount_type":"ACT","liabilities":1114662321.0,"cube_version":"v1","call_investment_deposits":0.0},{"cash":96112103.0,"date":"2014","year":2014,"rating":"bad","result":0.11,"amount_type":"ACT","liabilities":842239475.0,"cube_version":"v1","call_investment_deposits":0.0},{"cash":19558128.0,"date":"2013","year":2013,"rating":"bad","result":0.03,"amount_type":"ACT","liabilities":668455782.0,"cube_version":"v1","call_investment_deposits":0.0},{"cash":35792008.0,"date":"2012","year":2012,"rating":"bad","result":0.06,"amount_type":"ACT","liabilities":556235248.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":1482689878.0,"percent":63.78},"total":2324726525.0,"rating":"ave","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":842036647.0,"percent":36.22}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2015,"rating":"bad","result":10.48,"cube_version":"v1"},{"date":2014,"rating":"bad","result":10.52,"cube_version":"v1"},{"date":2013,"rating":"bad","result":5.47,"cube_version":"v1"},{"date":2012,"rating":"bad","result":0.71,"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":-1580000.0,"comparison":"Original to adjusted budget","percent_changed":-42.23},{"item":"Fines","amount":-759834.0,"comparison":"Original budget to audited outcome","percent_changed":-20.31},{"item":"Government Transfers","amount":324637301.0,"comparison":"Original to adjusted budget","percent_changed":108.71},{"item":"Government Transfers","amount":166032210.0,"comparison":"Original budget to audited outcome","percent_changed":55.6},{"item":"Interest and investments","amount":-3101000.0,"comparison":"Original to adjusted budget","percent_changed":-13.7},{"item":"Interest and investments","amount":-581005.0,"comparison":"Original budget to audited outcome","percent_changed":-2.57},{"item":"Licenses and Permits","amount":1000000.0,"comparison":"Original to adjusted budget","percent_changed":18.87},{"item":"Licenses and Permits","amount":-5291794.0,"comparison":"Original budget to audited outcome","percent_changed":-99.87},{"item":"Other","amount":-4717499.0,"comparison":"Original to adjusted budget","percent_changed":-4.17},{"item":"Other","amount":-28476518.0,"comparison":"Original budget to audited outcome","percent_changed":-25.19},{"item":"Property rates","amount":-82896882.0,"comparison":"Original to adjusted budget","percent_changed":-25.15},{"item":"Property rates","amount":43866483.0,"comparison":"Original budget to audited outcome","percent_changed":13.31},{"item":"Rental income","amount":-9016544.0,"comparison":"Original to adjusted budget","percent_changed":-39.09},{"item":"Rental income","amount":-6633437.0,"comparison":"Original budget to audited outcome","percent_changed":-28.76},{"item":"Service Charges","amount":-35192141.0,"comparison":"Original to adjusted budget","percent_changed":-5.73},{"item":"Service Charges","amount":-28349517.0,"comparison":"Original budget to audited outcome","percent_changed":-4.61}],"2013":[{"item":"Fines","amount":-544117.0,"comparison":"Original to adjusted budget","percent_changed":-14.54},{"item":"Fines","amount":12942745.0,"comparison":"Original budget to audited outcome","percent_changed":345.87},{"item":"Government Transfers","amount":91539458.0,"comparison":"Original to adjusted budget","percent_changed":14.65},{"item":"Government Transfers","amount":-74453444.0,"comparison":"Original budget to audited outcome","percent_changed":-11.91},{"item":"Interest and investments","amount":1852864.0,"comparison":"Original to adjusted budget","percent_changed":8.07},{"item":"Interest and investments","amount":-4695136.0,"comparison":"Original budget to audited outcome","percent_changed":-20.44},{"item":"Licenses and Permits","amount":132433.0,"comparison":"Original to adjusted budget","percent_changed":2191.15},{"item":"Licenses and Permits","amount":14809.0,"comparison":"Original budget to audited outcome","percent_changed":245.02},{"item":"Other","amount":-24027209.0,"comparison":"Original to adjusted budget","percent_changed":-17.7},{"item":"Other","amount":26996019.0,"comparison":"Original budget to audited outcome","percent_changed":19.89},{"item":"Property rates","amount":16347320.0,"comparison":"Original to adjusted budget","percent_changed":4.19},{"item":"Property rates","amount":12078745.0,"comparison":"Original budget to audited outcome","percent_changed":3.1},{"item":"Rental income","amount":-5337338.0,"comparison":"Original to adjusted budget","percent_changed":-24.4},{"item":"Rental income","amount":-3610256.0,"comparison":"Original budget to audited outcome","percent_changed":-16.5},{"item":"Service Charges","amount":-5708448.0,"comparison":"Original to adjusted budget","percent_changed":-0.85},{"item":"Service Charges","amount":-33649498.0,"comparison":"Original budget to audited outcome","percent_changed":-5.03}],"2014":[{"item":"Fines","amount":-383142.0,"comparison":"Original to adjusted budget","percent_changed":-10.7},{"item":"Fines","amount":11745461.0,"comparison":"Original budget to audited outcome","percent_changed":327.93},{"item":"Government Transfers","amount":121216633.0,"comparison":"Original to adjusted budget","percent_changed":16.36},{"item":"Government Transfers","amount":-211195316.0,"comparison":"Original budget to audited outcome","percent_changed":-28.5},{"item":"Interest and investments","amount":-5892313.0,"comparison":"Original to adjusted budget","percent_changed":-19.44},{"item":"Interest and investments","amount":-3810259.0,"comparison":"Original budget to audited outcome","percent_changed":-12.57},{"item":"Licenses and Permits","amount":-40438.0,"comparison":"Original to adjusted budget","percent_changed":-91.25},{"item":"Licenses and Permits","amount":-39944.0,"comparison":"Original budget to audited outcome","percent_changed":-90.13},{"item":"Other","amount":8960224.0,"comparison":"Original to adjusted budget","percent_changed":6.71},{"item":"Other","amount":-17214226.0,"comparison":"Original budget to audited outcome","percent_changed":-12.89},{"item":"Property rates","amount":-8895393.0,"comparison":"Original to adjusted budget","percent_changed":-1.99},{"item":"Property rates","amount":-21853316.0,"comparison":"Original budget to audited outcome","percent_changed":-4.89},{"item":"Rental income","amount":-3991006.0,"comparison":"Original to adjusted budget","percent_changed":-17.72},{"item":"Rental income","amount":-3930987.0,"comparison":"Original budget to audited outcome","percent_changed":-17.45},{"item":"Service Charges","amount":-22592935.0,"comparison":"Original to adjusted budget","percent_changed":-2.97},{"item":"Service Charges","amount":-52119175.0,"comparison":"Original budget to audited outcome","percent_changed":-6.85}],"2015":[{"item":"Fines","amount":10105123.0,"comparison":"Original to adjusted budget","percent_changed":251.9},{"item":"Fines","amount":19585233.0,"comparison":"Original budget to audited outcome","percent_changed":488.22},{"item":"Government Transfers","amount":102155274.0,"comparison":"Original to adjusted budget","percent_changed":11.24},{"item":"Government Transfers","amount":-66434353.0,"comparison":"Original budget to audited outcome","percent_changed":-7.31},{"item":"Interest and investments","amount":-11394454.0,"comparison":"Original to adjusted budget","percent_changed":-33.57},{"item":"Interest and investments","amount":-17175306.0,"comparison":"Original budget to audited outcome","percent_changed":-50.6},{"item":"Licenses and Permits","amount":-47836.0,"comparison":"Original to adjusted budget","percent_changed":-96.37},{"item":"Licenses and Permits","amount":-48276.0,"comparison":"Original budget to audited outcome","percent_changed":-97.26},{"item":"Other","amount":6159889.0,"comparison":"Original to adjusted budget","percent_changed":4.12},{"item":"Other","amount":-10277913.0,"comparison":"Original budget to audited outcome","percent_changed":-6.87},{"item":"Property rates","amount":42700812.0,"comparison":"Original to adjusted budget","percent_changed":9.47},{"item":"Property rates","amount":42702839.0,"comparison":"Original budget to audited outcome","percent_changed":9.47},{"item":"Rental income","amount":2374994.0,"comparison":"Original to adjusted budget","percent_changed":12.6},{"item":"Rental income","amount":3666282.0,"comparison":"Original budget to audited outcome","percent_changed":19.45},{"item":"Service Charges","amount":3252018.0,"comparison":"Original to adjusted budget","percent_changed":0.41},{"item":"Service Charges","amount":-13414302.0,"comparison":"Original budget to audited outcome","percent_changed":-1.68}]},"income_time_series":[{"amount":1599731487.0,"budget_phase":"Adjusted Budget","financial_year":2012,"amount_type.code":"ADJB"},{"amount":1942234806.0,"budget_phase":"Adjusted Budget","financial_year":2013,"amount_type.code":"ADJB"},{"amount":2228082357.0,"budget_phase":"Adjusted Budget","financial_year":2014,"amount_type.code":"ADJB"},{"amount":2521428141.0,"budget_phase":"Adjusted Budget","financial_year":2015,"amount_type.code":"ADJB"},{"amount":2915942685.0,"budget_phase":"Adjusted Budget","financial_year":2016,"amount_type.code":"ADJB"},{"amount":1550404840.0,"budget_phase":"Audited Actual","financial_year":2012,"amount_type.code":"AUDA"},{"amount":1803603827.0,"budget_phase":"Audited Actual","financial_year":2013,"amount_type.code":"AUDA"},{"amount":1841282965.0,"budget_phase":"Audited Actual","financial_year":2014,"amount_type.code":"AUDA"},{"amount":2324726525.0,"budget_phase":"Audited Actual","financial_year":2015,"amount_type.code":"AUDA"},{"amount":2985118848.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2017,"amount_type.code":"IBY1"},{"amount":3307016065.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2018,"amount_type.code":"IBY2"},{"amount":1410598252.0,"budget_phase":"Original Budget","financial_year":2012,"amount_type.code":"ORGB"},{"amount":1867979843.0,"budget_phase":"Original Budget","financial_year":2013,"amount_type.code":"ORGB"},{"amount":2139700727.0,"budget_phase":"Original Budget","financial_year":2014,"amount_type.code":"ORGB"},{"amount":2366122321.0,"budget_phase":"Original Budget","financial_year":2015,"amount_type.code":"ORGB"},{"amount":2732492229.0,"budget_phase":"Original Budget","financial_year":2016,"amount_type.code":"ORGB"}],"spending_adjustments":{"2012":[{"item":"Bulk purchases","amount":11844027.0,"comparison":"Original to adjusted budget","percent_changed":3.66},{"item":"Bulk purchases","amount":46310948.0,"comparison":"Original budget to audited outcome","percent_changed":14.31},{"item":"Contracted services","amount":32290971.0,"comparison":"Original to adjusted budget","percent_changed":18.74},{"item":"Contracted services","amount":-3619855.0,"comparison":"Original budget to audited outcome","percent_changed":-2.1},{"item":"Employee related costs","amount":444606.0,"comparison":"Original to adjusted budget","percent_changed":0.12},{"item":"Employee related costs","amount":3257594.0,"comparison":"Original budget to audited outcome","percent_changed":0.84},{"item":"Finance charges","amount":-16021498.0,"comparison":"Original to adjusted budget","percent_changed":-29.97},{"item":"Finance charges","amount":-5486585.0,"comparison":"Original budget to audited outcome","percent_changed":-10.26},{"item":"Other","amount":-64020378.0,"comparison":"Original to adjusted budget","percent_changed":-10.1},{"item":"Other","amount":43923238.0,"comparison":"Original budget to audited outcome","percent_changed":6.93},{"item":"Remuneration of councillors","amount":300000.0,"comparison":"Original to adjusted budget","percent_changed":1.61},{"item":"Remuneration of councillors","amount":629306.0,"comparison":"Original budget to audited outcome","percent_changed":3.37},{"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":1870281.0,"comparison":"Original to adjusted budget","percent_changed":0.49},{"item":"Bulk purchases","amount":38836912.0,"comparison":"Original budget to audited outcome","percent_changed":10.2},{"item":"Contracted services","amount":248088.0,"comparison":"Original to adjusted budget","percent_changed":0.13},{"item":"Contracted services","amount":14228835.0,"comparison":"Original budget to audited outcome","percent_changed":7.4},{"item":"Employee related costs","amount":-8500000.0,"comparison":"Original to adjusted budget","percent_changed":-2.02},{"item":"Employee related costs","amount":-1944068.0,"comparison":"Original budget to audited outcome","percent_changed":-0.46},{"item":"Finance charges","amount":-1704536.0,"comparison":"Original to adjusted budget","percent_changed":-5.05},{"item":"Finance charges","amount":18160168.0,"comparison":"Original budget to audited outcome","percent_changed":53.83},{"item":"Other","amount":38464126.0,"comparison":"Original to adjusted budget","percent_changed":6.05},{"item":"Other","amount":16753193.0,"comparison":"Original budget to audited outcome","percent_changed":2.64},{"item":"Remuneration of councillors","amount":800000.0,"comparison":"Original to adjusted budget","percent_changed":3.98},{"item":"Remuneration of councillors","amount":814514.0,"comparison":"Original budget to audited outcome","percent_changed":4.05},{"item":"Transfers and subsidies","amount":-276500.0,"comparison":"Original to adjusted budget","percent_changed":-1.35},{"item":"Transfers and subsidies","amount":5447042.0,"comparison":"Original budget to audited outcome","percent_changed":26.67}],"2014":[{"item":"Bulk purchases","amount":6480000.0,"comparison":"Original to adjusted budget","percent_changed":1.61},{"item":"Bulk purchases","amount":35088121.0,"comparison":"Original budget to audited outcome","percent_changed":8.71},{"item":"Contracted services","amount":-8930803.0,"comparison":"Original to adjusted budget","percent_changed":-3.07},{"item":"Contracted services","amount":-29878133.0,"comparison":"Original budget to audited outcome","percent_changed":-10.27},{"item":"Employee related costs","amount":-1520784.0,"comparison":"Original to adjusted budget","percent_changed":-0.34},{"item":"Employee related costs","amount":12454423.0,"comparison":"Original budget to audited outcome","percent_changed":2.76},{"item":"Finance charges","amount":121464.0,"comparison":"Original to adjusted budget","percent_changed":0.26},{"item":"Finance charges","amount":11464533.0,"comparison":"Original budget to audited outcome","percent_changed":24.43},{"item":"Other","amount":-68058570.0,"comparison":"Original to adjusted budget","percent_changed":-11.14},{"item":"Other","amount":-2280134.0,"comparison":"Original budget to audited outcome","percent_changed":-0.37},{"item":"Remuneration of councillors","amount":4199993.0,"comparison":"Original to adjusted budget","percent_changed":19.02},{"item":"Remuneration of councillors","amount":3809883.0,"comparison":"Original budget to audited outcome","percent_changed":17.25},{"item":"Transfers and subsidies","amount":-4438961.0,"comparison":"Original to adjusted budget","percent_changed":-17.34},{"item":"Transfers and subsidies","amount":-1894309.0,"comparison":"Original budget to audited outcome","percent_changed":-7.4}],"2015":[{"item":"Bulk purchases","amount":486464.0,"comparison":"Original to adjusted budget","percent_changed":0.11},{"item":"Bulk purchases","amount":34099502.0,"comparison":"Original budget to audited outcome","percent_changed":7.64},{"item":"Contracted services","amount":72351733.0,"comparison":"Original to adjusted budget","percent_changed":33.16},{"item":"Contracted services","amount":113391111.0,"comparison":"Original budget to audited outcome","percent_changed":51.97},{"item":"Employee related costs","amount":9130838.0,"comparison":"Original to adjusted budget","percent_changed":1.89},{"item":"Employee related costs","amount":37459654.0,"comparison":"Original budget to audited outcome","percent_changed":7.75},{"item":"Finance charges","amount":1389208.0,"comparison":"Original to adjusted budget","percent_changed":2.43},{"item":"Finance charges","amount":8579481.0,"comparison":"Original budget to audited outcome","percent_changed":14.98},{"item":"Other","amount":-38654219.0,"comparison":"Original to adjusted budget","percent_changed":-7.06},{"item":"Other","amount":114257600.0,"comparison":"Original budget to audited outcome","percent_changed":20.88},{"item":"Remuneration of councillors","amount":2.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":162643.0,"comparison":"Original budget to audited outcome","percent_changed":0.59},{"item":"Transfers and subsidies","amount":10333973.0,"comparison":"Original to adjusted budget","percent_changed":7.47},{"item":"Transfers and subsidies","amount":-111529581.0,"comparison":"Original budget to audited outcome","percent_changed":-80.61}]},"spending_time_series":[{"amount":1552606843.0,"budget_phase":"Adjusted Budget","financial_year":2012,"amount_type.code":"ADJB"},{"amount":1734156022.0,"budget_phase":"Adjusted Budget","financial_year":2013,"amount_type.code":"ADJB"},{"amount":1777471910.0,"budget_phase":"Adjusted Budget","financial_year":2014,"amount_type.code":"ADJB"},{"amount":1973491513.0,"budget_phase":"Adjusted Budget","financial_year":2015,"amount_type.code":"ADJB"},{"amount":2284858965.0,"budget_phase":"Adjusted Budget","financial_year":2016,"amount_type.code":"ADJB"},{"amount":1672783761.0,"budget_phase":"Audited Actual","financial_year":2012,"amount_type.code":"AUDA"},{"amount":1795551159.0,"budget_phase":"Audited Actual","financial_year":2013,"amount_type.code":"AUDA"},{"amount":1878383955.0,"budget_phase":"Audited Actual","financial_year":2014,"amount_type.code":"AUDA"},{"amount":2114873924.0,"budget_phase":"Audited Actual","financial_year":2015,"amount_type.code":"AUDA"},{"amount":2369217604.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2017,"amount_type.code":"IBY1"},{"amount":2584301443.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2018,"amount_type.code":"IBY2"},{"amount":1587769115.0,"budget_phase":"Original Budget","financial_year":2012,"amount_type.code":"ORGB"},{"amount":1703254563.0,"budget_phase":"Original Budget","financial_year":2013,"amount_type.code":"ORGB"},{"amount":1849619571.0,"budget_phase":"Original Budget","financial_year":2014,"amount_type.code":"ORGB"},{"amount":1918453514.0,"budget_phase":"Original Budget","financial_year":2015,"amount_type.code":"ORGB"},{"amount":2181544665.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":-26.84,"overunder":"under","cube_version":"v1"},{"date":2014,"rating":"bad","result":-61.89,"overunder":"under","cube_version":"v1"},{"date":2013,"rating":"bad","result":-54.61,"overunder":"under","cube_version":"v1"},{"date":2012,"rating":"bad","result":-63.6,"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":493747750.0,"amount_type":"AUDA"},{"date":"2015","item":"Service Charges","amount":786818761.0,"amount_type":"AUDA"},{"date":"2015","item":"Rental income","amount":22515676.0,"amount_type":"AUDA"},{"date":"2015","item":"Interest and investments","amount":16766731.0,"amount_type":"AUDA"},{"date":"2015","item":"Fines","amount":23596792.0,"amount_type":"AUDA"},{"date":"2015","item":"Licenses and Permits","amount":1360.0,"amount_type":"AUDA"},{"date":"2015","item":"Agency services","amount":30592600.0,"amount_type":"AUDA"},{"date":"2015","item":"Other","amount":108650208.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":24.63},{"date":2014,"rating":"","result":24.65},{"date":2013,"rating":"","result":23.29},{"date":2012,"rating":"","result":23.27}],"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.2,"overunder":"over","cube_version":"v1"},{"date":2014,"rating":"ave","result":5.7,"overunder":"over","cube_version":"v1"},{"date":2013,"rating":"good","result":3.5,"overunder":"over","cube_version":"v1"},{"date":2012,"rating":"ave","result":7.7,"overunder":"over","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":2.28,"cube_version":"v1"},{"date":2014,"rating":"bad","result":2.7,"cube_version":"v1"},{"date":2013,"rating":"bad","result":2.45,"cube_version":"v1"},{"date":2012,"rating":"bad","result":2.41,"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":15.68},{"date":2014,"rating":"","result":13.89},{"date":2013,"rating":"","result":11.5},{"date":2012,"rating":"","result":10.08}],"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":"good","result":95.44,"amount_type":"AUDA","cube_version":"v1"},{"date":"2014","year":2014,"rating":"good","result":99.7,"amount_type":"AUDA","cube_version":"v1"},{"date":"2013","year":2013,"rating":"good","result":97.53,"amount_type":"AUDA","cube_version":"v1"},{"date":"2012","year":2012,"rating":"good","result":97.38,"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":59413423.0},{"year":2013,"value":98912288.0},{"year":2014,"value":142411743.0},{"year":2015,"value":183470572.0}],"category":"Community & Social Services"},{"values":[{"year":2012,"value":449422545.0},{"year":2013,"value":501249181.0},{"year":2014,"value":522353384.0},{"year":2015,"value":577962742.0}],"category":"Electricity "},{"values":[{"year":2013,"value":5803718.0},{"year":2014,"value":7241116.0},{"year":2015,"value":3760551.0}],"category":"Environmental Protection"},{"values":[{"year":2012,"value":364538295.0},{"year":2013,"value":455692862.0},{"year":2014,"value":537496211.0},{"year":2015,"value":536653270.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2012,"value":12639539.0},{"year":2013,"value":4064080.0},{"year":2014,"value":280301.0},{"year":2015,"value":362331.0}],"category":"Health"},{"values":[{"year":2012,"value":16009220.0},{"year":2013,"value":4536115.0},{"year":2014,"value":5496490.0},{"year":2015,"value":8259440.0}],"category":"Housing"},{"values":[{"year":2013,"value":3277400.0},{"year":2014,"value":3150912.0},{"year":2015,"value":1760694.0}],"category":"Other"},{"values":[{"year":2012,"value":289031065.0},{"year":2013,"value":195680105.0},{"year":2014,"value":160549152.0},{"year":2015,"value":239391855.0}],"category":"Road Transport"},{"values":[{"year":2012,"value":136459549.0},{"year":2013,"value":206211849.0},{"year":2014,"value":177950800.0},{"year":2015,"value":189521625.0}],"category":"Sport And Recreation"},{"values":[{"year":2012,"value":116907253.0},{"year":2013,"value":108445779.0},{"year":2014,"value":123056024.0},{"year":2015,"value":142067836.0}],"category":"Waste Management"},{"values":[{"year":2012,"value":70452406.0},{"year":2013,"value":107605589.0},{"year":2014,"value":60368014.0},{"year":2015,"value":79191257.0}],"category":"Waste Water Management"},{"values":[{"year":2012,"value":157910466.0},{"year":2013,"value":104072193.0},{"year":2014,"value":138029808.0},{"year":2015,"value":152471751.0}],"category":"Water"}],"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":[],"land_gained":[],"disestablished":true,"disestablished_to":["MP326"],"disestablished_date":"2016-08-03","code":"MP322"},"muni_contact":{"url":"http://www.mbombela.gov.za","phone_number":"013 759 9111","street_address_1":"Civic Centre","street_address_2":"1 Nel Street","street_address_3":"Nelspruit","street_address_4":"1200"},"mayoral_staff":{"officials":[{"name":"Sibusiso Mathosi","role":"Mayor/Executive Mayor","email":"sibusiao.mathonsi@mbombela.gov.za","title":"Cllr","secretary":{"name":"Liyanda Maphanga","role":"Secretary of Mayor/Executive Mayor","email":"liyanda.maphanga@mbombela.gov.za","title":"Ms","fax_number":"013 759 2253","office_phone":"013 759 2003"},"fax_number":"013 759 2253","office_phone":"013 759 2003"},{"name":"N M Seanego","role":"Municipal Manager","email":"noko.seanego@mbombela.gov.za","title":"Mr","secretary":{"name":"Nompumelelo Khumalo","role":"Secretary of Municipal Manager","email":"Nompumelelo.khumalo@mbombela.gov.za","title":"Ms","fax_number":"013 759 9055","office_phone":"013 759 2041"},"fax_number":"013 759 2252","office_phone":"013 759 2041"},{"name":null,"role":"Deputy Mayor/Executive Mayor","email":null,"title":null,"fax_number":null,"office_phone":null},{"name":"O P Mokoena","role":"Chief Financial Officer","email":"oupa.mokoena@mbombela.gov.za","title":"Mr","secretary":{"name":"K Ngomane","role":"Secretary of Financial Manager","email":"karlinan@mbombela.gov.za","title":"Ms","fax_number":"013 759 9055","office_phone":"013 759 2005"},"fax_number":"013 759 9055","office_phone":"013 759 2005"}],"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/MP322%20Mbombela/MP322%20Mbombela%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/MP322%20Mbombela/MP322%20Mbombela%20Audit%20report%202013-14.pdf"},{"date":2013,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"http://mfma.treasury.gov.za/Documents/07.%20Audit%20Reports/2012-13/02.%20Local%20Municipalities/MP322%20Mbombela/MP322%20Mbombela%20Audit%20report%202012-13.pdf"},{"date":2012,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"http://mfma.treasury.gov.za/Documents/07.%20Audit%20Reports/2011-12/02.%20Local%20municipalities/MP322%20Mbombela/MP322%20Mbombela%20Audit%20Report%202011-12.pdf"}]}}