Table C5: Monthly Budget Statement - Capital Expenditure (municipal vote, standard classification and funding) NC064 Kamiesberg - Table C5 Monthly Budget Statement - Capital Expenditure (municipal vote, standard classification and funding) - M06 December Vote Description Ref 2016/17 Budget Year 2017/18 Audited Outcome Original Budget Adjusted Budget Monthly actual YearTD actual YearTD budget YTD variance YTD variance Full Year Forecast R thousands 1 % Single Year expenditure appropriation 2 Vote 1 - EXECUTIVE AND COUNCIL 64 661 – – – – – – – Vote 2 - FINANCE AND ADMINISTRATION 296 – – – – – – – Vote 5 - WASTE MANAGEMENT 437 – – – – – – – Vote 6 - WATER – 11 601 11 601 1 831 7 022 4 579 2 442 53% 11 601 Vote 7 - ELECTRICITY 605 – – – – – – – Vote 9 - TECHNICAL AND ROADS 2 073 – – – – – – – Total Capital expenditure 4 68 072 11 601 11 601 1 831 7 022 4 579 2 442 53% 11 601
Total By Revenue Source 2000 1 436 1 476 1 299 64 911 – – – – 69 121 – 64 911 2016/17 - totals only – – Debtors Age Analysis By Customer Category Government 2200 150 212 142 1 726 – – – – 2 229 – Business 2300 222 195 215 5 021 – – – – 5 653 – Households 2400 835 835 714 40 170 – – – – 42 554 – Other 2500 229 233 228 17 994 – – – – 18 685 – Total By Customer Category 2600 1 436 1 476 1 299 64 911 – – – – 69 121 – This table is a comparison between the revenue source and the customer category. Although we closely monitoring the credit control measures it still remains a challenge to get the rate payers as far as settling their debt. An overall cleaning of the debtors’ ledger is also necessary to establish what should be written off as bad debtsto determine amountfrom debtors which cannot be recovered after all means were taken to recover arrear debt. Creditors’ Analysis Description NT Code Budget Year 2017/18 Prior year totals for chart (same period) 0 - 30 Days 31 - 60 Days 61 - 90 Days 91 - 120 Days 121 - Days 151 - 180 Days 181 Days - 1 Year Over 1 Year Total R thousands Creditors Age Analysis By Customer Type Bulk Electricity 0100 1 311 205 1 303 932 3 524 1 105 – 8 380 Bulk Water 0200 – – – – – PAYE deductions 0300 304 288 309 305 416 – 1 622 VAT (output less input) 0400 – Pensions / Retirement deductions 0500 (168) 245 244 51 247 256 875 Loan repayments 0600 – Trade Creditors 0700 29 115 88 32 – 798 287 337 1 687
Auditor General 0800 2 397 336 247 170 55 4 605 – – 7 810 Other 0900 – – – – – 1 877 1 877 Total By Customer Type 2600 3 873 1 190 2 191 1 490 4 242 6 765 287 2 214 22 251 – Investment portfolio NC064 Kamiesberg - Supporting Table SC5 Monthly Budget Statement - investment portfolio - M06 December Investments by maturity Name of institution & investment ID Ref Period of Investment Type of Investment Expiry date of investment Accrued interest for the Yield for the month 1 (%) Market value at beginning of the month Change in market value Market value at end of the month R thousands Yrs/Months Municipality Investec Bank Limited 0 Smartrate plus Notice 32/80 41 0,0% 6 988 – 7 029 Municipality 41 6 988 – 7 029 Entities Entities sub-total – – – – TOTAL INVESTMENTS AND INTEREST 2 41 6 988 – 7 029 Allocation and receipts and expenditure NC064 Kamiesberg - Supporting Table SC6 Monthly Budget Statement - transfers and grant receipts - M06 December Description Ref 2016/17 Budget Year 2017/18 Audited Outcome Original Budget Adjusted Budget Monthly actual YearTD actual YearTD budget YTD variance YTD variance Full Year Forecast R thousands % RECEIPTS: 1,2 Operating Transfers and Grants National Government: 21 185 22 977 22 977 5 216 15 879 7 098 6 936 97,7% 22 977 Local Government Equitable Share 18 175 19 632 19 632 5 216 13 284 6 348 6 936 109,3% 19 632 Finance Management 2 010 2 345 2 345 2 345 – 2 345 EPWP Incentive 1 000 1 000 1 000 250 750 1 000 –
TOTAL SALARY, ALLOWANCES & BENEFITS 20 106 25 014 25 014 2 143 10 100 14 914 (4 813) -32% 25 014 % increase 4 24,4% 24,4% 24,4% TOTAL MANAGERS AND STAFF 17 951 22 625 22 625 1 907 9 322 13 303 (3 981) -30% 22 625 MID-YEAR PERFORMANCE AGAINST THE PERFORMANCE INDICATORS SET IN THE APPROVED TOP LAYER SDBIP FOR 2017/18 31 2017 (Please note that only the Strategic objectives with their 19 KPI’s due for this period on the Top Layer are indicated below. The rest will be reported on in future periods when they are due) Category Colour Explanation KPI's Not Met R 0% >= Actual/Target < 75% KPI's Almost Met O 75% >= Actual/Target < 100%