WC025 Breede Valley
Version 2.3
Click for Instructions!
Contact details:
Technical enquiries to the MFMA Helpline at:
mfma@treasury.gov.za
Data submission enquiries:
Elsabé Rossouw
National Treasury
Tel: (012) 315-5534
Electronic documents: lgdocuments@treasury.gov.za
Queries on formats: lgdataqueries@treasury.gov.za
2020
Preparation Instructions
Municipality Name: WC025 Breede Valley
CFO Name: D McThomas
Tel: 023 348 4995 Fax: 023 348 4997
E-Mail: dmcthomas@bvm.gov.za
Reporting period: M02 August
MTREF: 2011 Budget Year: 2011/12
Does this municipality have Entities? No
Parent Municipality
If YES: Identify type of report:
Name Votes & Sub-Votes
Importants documents which
Printing Instructions
provide essential assistance
Showing / Hiding Columns MFMA Budget Circular 2011/12 Click to view
Hide Reference columns on all sheets
MBRR Budget Formats Guide Click to view
Hide Pre-audit columns on all sheets MFMA Circular 48 Click to view
Showing / Clearing Highlights MFMA Circular 51 Click to view
Clear Highlights on all sheets
MFMA Return Forms Click to view
Organisational structure votes (if required) Organisational structure sub-votes (if required)
Vote 1 - Council General Council General
Vote 2 - Municipal Manager Admin
Vote 3 - Corporate Services Mayoral Office
Vote 4 - Financial Services
Vote 5 - Community Services
Vote 6 - Operational Services
Vote 7 - Example 7
Vote 8 - Example 8
Vote 9 - Example 9
Vote 10 - Example 10
Vote 11 - Example 11
Vote 12 - Example 12 Municipal Manager
Vote 13 - Example 13 Admin
Vote 14 - Example 14 Internal Audit
Vote 15 - Example 15 IDP
Community Safety
Ombudsman
Performance Management & Community
Area Managers
Corporate Services
Admin
Civic Buildings
Housing
Financial Services
Admin
Revenue
Expenditure
Financial Planning
Supply Chain Management
Community Services
Admin
Health
Traffic
Fire Protection
Libraries
Operational Services
Public Works
Cemetaries
Recreational Facilities
Resorts
Refuse Removal
Sewerage
Electricity Management
Water Management
WC025 Breede Valley - Contact Information
A. GENERAL INFORMATION
Municipality WC025 Breede Valley Set name on 'Instructions' sheet
Grade 4 1 Grade in terms of the Remuneration of Public Office Bearers Act.
Province WC WESTERN CAPE
Web Address www.bvm.gov.za
e-mail Address bvm.gov.za
B. CONTACT INFORMATION
Postal address:
P.O. Box Private Bag X3046
City / Town Worcester
Postal Code 6849
Street address
Building Civic Building
Street No. & Name Corner of Baring- and High Street
City / Town Worcester
Postal Code 6850
General Contacts
Telephone number 023 348 2600
Fax number 023 347 2599
C. POLITICAL LEADERSHIP
Speaker: Secretary/PA to the Speaker:
Name A Steyn Name E van der Westhuizen
Telephone number 023 348 2846 Telephone number 023 348 2846
Cell number 072 404 6248 Cell number 079 210 9640
Fax number 023 348 2852 Fax number 023 348 2852
E-mail address asteyn@bvm.gov.za E-mail address evdwesthuizen@bvm.gov.za
Mayor/Executive Mayor: Secretary/PA to the Mayor/Executive Mayor:
Name BD Kivedo Name E Pekeur
Telephone number 023 348 2842 Telephone number 023 348 2842
Cell number 082 442 4412 Cell number 076 272 7880
Fax number 023 348 2852 Fax number 023 348 2852/ 086 512 1041
E-mail address em@bvm.gov.za E-mail address epekeur@bvm.gov.za
Deputy Mayor/Executive Mayor: Secretary/PA to the Deputy Mayor/Executive Mayor:
Name JD Levendal Name R Robinson
Telephone number 023 348 2844 Telephone number 023 348 2844
Cell number 072 180 7812 Cell number 071 980 0242
Fax number 023 348 2852 Fax number 023 348 2852
E-mail address jlevendal@bvm.gov.za E-mail address rrobinson@bvm.gov.za
D. MANAGEMENT LEADERSHIP
Municipal Manager: Secretary/PA to the Municipal Manager:
Name AA Paulse Name M Mdabuli
Telephone number 023 348 2800 Telephone number 023 348 2602
Cell number 084 449 2800 Cell number 084 448 2850
Fax number 023 348 3852 Fax number 023 348 3852
E-mail address apaulse@bvm.gov.za E-mail address mmdabuli@bvm.gov.za
Chief Financial Officer Secretary/PA to the Chief Financial Officer
Name D McThomas Name H Kamfer
Telephone number 023 348 4995 Telephone number 023 348 4994
Cell number 083 778 9480 Cell number 082 694 8146
Fax number 023 348 4997 Fax number 023 348 4997
E-mail address dmcthomas@bvm.gov.za E-mail address hkamfer@bvm.gov.za
Official responsible for submitting financial information
Name S Roets
Telephone number 023 348 4992
Cell number 083 656 4436
Fax number 023 348 4997
E-mail address sroets@bvm.gov.za
Official responsible for submitting financial information
Name M Memani
Telephone number 023 348 4996
Cell number 082 716 8777
Fax number 023 348 4997
E-mail address mlelo@bvm.gov.za
Official responsible for submitting financial information
Name G Haas
Telephone number 023 348 4975
Cell number 079 210 9652
Fax number 023 348 4997
E-mail address ghaas@bvm.gov.za
WC025 Breede Valley - Table C1 Monthly Budget Statement Summary - M02 August
2010/11 Budget Year 2011/12
Description Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands %
Financial Performance
Property rates 64,369 69,267 69,267 6,032 11,880 11,544 335 3% 69,267
Service charges 320,051 363,097 363,097 31,913 43,110 60,516 (17,407) -29% 363,097
Investment revenue 9,404 9,546 9,546 554 941 1,591 (650) -41% 9,546
Transfers recognised - operational 91,740 104,558 109,238 3,437 27,590 18,206 9,383 52% 109,238
Other own revenue 28,287 34,726 34,726 2,643 4,529 5,788 (1,258) -22% 34,726
Total Revenue (excluding capital transfers and 513,850 581,194 585,874 44,578 88,050 97,646 (9,596) -10% 585,874
contributions)
Employee costs 158,420 181,615 181,657 12,522 24,483 30,276 (5,793) -19% 181,657
Remuneration of Councillors 10,145 11,479 11,479 917 1,834 1,913 (79) -4% 11,479
Depreciation & asset impairment 62,933 66,255 66,300 – – 11,050 (11,050) -100% 66,300
Finance charges 23,679 32,005 32,005 5,031 5,031 5,334 (303) -6% 32,005
Materials and bulk purchases 183,917 219,584 219,636 25,191 25,607 36,606 (10,999) -30% 219,636
Transfers and grants 166 150 150 2 4 25 (21) 150
Other expenditure 125,294 124,168 128,709 6,218 14,332 21,452 (7,120) -33% 128,709
Total Expenditure 564,553 635,254 639,935 49,881 71,291 106,656 (35,364) -33% 639,935
Surplus/(Deficit) (50,703) (54,060) (54,060) (5,303) 16,758 (9,010) 25,768 -286% (54,060)
Transfers recognised - capital 49,543 30,567 31,996 – – 5,333 (5,333) -100% 31,996
Contributions & Contributed assets – – – – – – – –
Surplus/(Deficit) after capital transfers & (1,160) (23,493) (22,064) (5,303) 16,758 (3,677) 20,436 -556% (22,064)
contributions
Share of surplus/ (deficit) of associate – – – – – – – –
Surplus/ (Deficit) for the year (1,160) (23,493) (22,064) (5,303) 16,758 (3,677) 20,436 -556% (22,064)
Capital expenditure & funds sources
Capital expenditure 137,534 113,513 122,191 2,475 4,042 18,586 (14,544) -78% 122,191
Capital transfers recognised 49,251 30,067 31,496 1,722 3,155 12,707 (9,551) -75% 31,496
Public contributions & donations 291 500 500 – – – – 500
Borrowing 58,872 75,114 80,875 – – 4,769 (4,769) -100% 80,875
Internally generated funds 29,119 7,832 9,320 753 886 1,110 (224) -20% 9,320
Total sources of capital funds 137,534 113,513 122,191 2,475 4,042 18,586 (14,544) -78% 122,191
Financial position
Total current assets 195,504 160,394 160,394 208,906 160,394
Total non current assets 1,802,587 1,818,543 1,827,220 1,795,689 1,827,220
Total current liabilities 124,182 113,377 113,377 159,469 113,377
Total non current liabilities 381,957 405,926 405,926 398,150 405,926
Community wealth/Equity 1,491,952 1,459,634 1,459,634 1,446,977 1,459,634
Cash flows
Net cash from (used) operating 114,193 55,484 50,804 (9,327) 22,998 35,891 (12,893) -36% 50,804
Net cash from (used) investing (167,777) (108,663) (112,341) (12,475) (29,042) (78,144) 49,102 -63% (112,341)
Net cash from (used) financing 78,369 27,654 27,654 – – 9 (9) -100% 27,654
Cash/cash equivalents at the month/year end 35,989 11,733 3,375 – 31,213 (4,987) 36,200 -726% 3,375
181 Dys-1
Debtors & creditors analysis 0-30 Days 31-60 Days 61-90 Days 91-120 Days 121-150 Dys 151-180 Dys Over 1Yr Total
Yr
Debtors Age Analysis
Total By Revenue Source 74,379 3,370 1,610 1,311 1,103 1,081 6,552 ######### 106,535
Creditors Age Analysis
Total Creditors 49,359 32,088 – – – – – ######### 90,775
WC025 Breede Valley - Table C2 Monthly Budget Statement - Financial Performance (standard classification) - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands 1 %
Revenue - Standard
Governance and administration 110,644 117,788 118,249 8,236 27,389 19,708 7,681 39% 118,249
Executive and council 721 874 1,335 6 215 222 (8) -3% 1,335
Budget and treasury office 107,837 114,170 114,170 8,140 26,848 19,028 7,820 41% 114,170
Corporate services 2,086 2,744 2,744 90 327 457 (131) -29% 2,744
Community and public safety 42,896 62,950 67,610 2,258 5,877 11,268 (5,391) -48% 67,610
Community and social services 1,952 1,978 2,084 117 525 347 177 51% 2,084
Sport and recreation 2,310 3,694 5,179 85 170 863 (694) -80% 5,179
Public safety 7,731 10,459 10,671 556 1,165 1,779 (614) -35% 10,671
Housing 30,826 46,807 49,663 1,500 4,018 8,277 (4,259) -51% 49,663
Health 77 12 12 – – 2 (2) -100% 12
Economic and environmental services 31,066 14,267 14,872 1,568 1,870 2,479 (608) -25% 14,872
Planning and development 1,361 1,397 1,502 585 696 250 445 178% 1,502
Road transport 26,302 7,603 8,103 550 741 1,351 (609) -45% 8,103
Environmental protection 3,403 5,267 5,267 433 433 878 (444) -51% 5,267
Trading services 378,781 416,756 417,139 32,516 52,913 69,523 (16,610) -24% 417,139
Electricity 221,135 266,011 266,011 24,208 30,328 44,335 (14,007) -32% 266,011
Water 53,300 57,608 57,608 2,416 5,162 9,601 (4,440) -46% 57,608
Waste water management 76,454 62,904 63,239 3,777 10,897 10,540 357 3% 63,239
Waste management 27,892 30,234 30,281 2,116 6,527 5,047 1,480 29% 30,281
Other 4 7 – – – – – – –
Total Revenue - Standard 2 563,393 611,761 617,871 44,578 88,050 102,978 (14,929) -14% 617,871
Expenditure - Standard
Governance and administration 114,093 110,117 110,578 8,171 16,325 18,430 (2,105) -11% 110,578
Executive and council 44,515 33,720 34,481 2,343 5,364 5,747 (383) -7% 34,481
Budget and treasury office 33,329 40,938 40,838 2,864 5,642 6,806 (1,165) -17% 40,838
Corporate services 36,249 35,459 35,259 2,964 5,319 5,877 (557) -9% 35,259
Community and public safety 108,747 130,401 134,409 6,121 13,351 22,402 (9,051) -40% 134,409
Community and social services 15,254 17,267 17,270 1,124 2,032 2,878 (847) -29% 17,270
Sport and recreation 17,260 18,910 20,060 979 1,749 3,343 (1,594) -48% 20,060
Public safety 33,556 38,267 38,267 2,734 5,134 6,378 (1,244) -20% 38,267
Housing 42,243 55,436 58,292 1,260 4,391 9,715 (5,324) -55% 58,292
Health 433 521 521 25 46 87 (41) -48% 521
Economic and environmental services 54,529 50,043 50,149 1,997 3,606 8,358 (4,752) -57% 50,149
Planning and development 8,411 8,685 8,790 642 1,159 1,465 (306) -21% 8,790
Road transport 39,326 31,535 31,535 945 1,737 5,256 (3,519) -67% 31,535
Environmental protection 6,792 9,824 9,824 410 711 1,637 (927) -57% 9,824
Trading services 285,959 343,429 343,534 33,519 37,872 57,256 (19,383) -34% 343,534
Electricity 188,582 223,583 223,583 26,050 27,248 37,264 (10,016) -27% 223,583
Water 35,847 39,894 39,894 1,688 2,709 6,649 (3,940) -59% 39,894
Waste water management 45,815 54,569 54,627 4,135 5,390 9,104 (3,714) -41% 54,627
Waste management 15,715 25,383 25,430 1,645 2,525 4,238 (1,713) -40% 25,430
Other 1,226 1,264 1,264 73 137 211 (73) -35% 1,264
Total Expenditure - Standard 3 564,553 635,254 639,935 49,881 71,291 106,656 (35,364) -33% 639,935
Surplus/ (Deficit) for the year (1,160) (23,493) (22,064) (5,303) 16,758 (3,677) 20,436 -556% (22,064)
WC025 Breede Valley - Table C2 Monthly Budget Statement - Financial Performance (standard classification) - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Full Year
Monthly actual YearTD actual YearTD budget YTD variance YTD variance
Outcome Budget Budget Forecast
R thousands 1 %
Revenue - Standard
Municipal governance and administration 110,644 117,788 118,249 8,236 27,389 19,708 7,681 39% 118,249
Executive and council 721 874 1,335 6 215 222 (8) (0) 1,335
Mayor and Council 376 829 1,290 3 209 215 (6) (0) 1,290
Municipal Manager 345 45 45 3 6 7 (1) (0) 45
Budget and treasury office 107,837 114,170 114,170 8,140 26,848 19,028 7,820 0 114,170
Corporate services 2,086 2,744 2,744 90 327 457 (131) (0) 2,744
Human Resources 752 1,200 1,200 – 181 200 (19) (0) 1,200
Information Technology 1 1 1 – 0 0 0 0 1
Property Services 1,079 1,543 1,543 8 15 257 (242) (0) 1,543
Other Admin 253 – – 82 130 – 130 – –
Community and public safety 42,896 62,950 67,610 2,258 5,877 11,268 (5,391) (0) 67,610
Community and social services 1,952 1,978 2,084 117 525 347 177 0 2,084
Libraries and Archives 1,190 1,153 1,259 26 358 210 148 0 1,259
Museums & Art Galleries etc – – – – – – – –
Community halls and Facilities 267 253 253 41 62 42 20 0 253
Cemeteries & Crematoriums 495 572 572 50 104 95 9 0 572
Child Care – – – – – – – –
Aged Care – – – – – – – –
Other Community – – – – – – – –
Other Social – – – – – – – –
Sport and recreation 2,310 3,694 5,179 85 170 863 (694) (0) 5,179
Public safety 7,731 10,459 10,671 556 1,165 1,779 (614) (0) 10,671
Police 6,891 10,018 10,230 536 1,120 1,705 (585) (0) 10,230
Fire 840 442 442 20 45 74 (29) (0) 442
Civil Defence – – – – – – – –
Street Lighting – – – – – – – –
Other – – – – – – – –
Housing 30,826 46,807 49,663 1,500 4,018 8,277 (4,259) (0) 49,663
Health 77 12 12 – – 2 (2) (0) 12
Clinics – 12 12 – – 2 (2) (0) 12
Ambulance – – – – – – – –
Other 77 – – – – – – –
Economic and environmental services 31,066 14,267 14,872 1,568 1,870 2,479 (608) (0) 14,872
Planning and development 1,361 1,397 1,502 585 696 250 445 0 1,502
Economic Development/Planning 375 500 567 500 500 95 405 0 567
Town Planning/Building
enforcement 986 897 935 85 196 156 40 0 935
Licensing & Regulation – – – – – – – –
Road transport 26,302 7,603 8,103 550 741 1,351 (609) (0) 8,103
Roads 20,110 1,591 2,091 2 2 348 (346) (0) 2,091
Public Buses – – – – – – – –
Parking Garages – – – – – – – –
Vehicle Licensing and Testing 6,192 6,013 6,013 548 739 1,002 (263) (0) 6,013
Other – – – – – – – –
Environmental protection 3,403 5,267 5,267 433 433 878 (444) (0) 5,267
Pollution Control – – – – – – – –
Biodiversity & Landscape 6 – – – – – – –
Other 3,397 5,267 5,267 433 433 878 (444) (0) 5,267
Trading services 378,781 416,756 417,139 32,516 52,913 69,523 (16,610) (0) 417,139
Electricity 221,135 266,011 266,011 24,208 30,328 44,335 (14,007) (0) 266,011
Electricity Distribution 221,135 266,011 266,011 24,208 30,328 44,335 (14,007) (0) 266,011
Electricity Generation – – – – – – – –
Water 53,300 57,608 57,608 2,416 5,162 9,601 (4,440) (0) 57,608
Water Distribution 53,300 45,065 45,065 2,416 5,162 7,511 (2,349) (0) 45,065
Water Storage – 12,543 12,543 – – 2,090 (2,090) (0) 12,543
Waste water management 76,454 62,904 63,239 3,777 10,897 10,540 357 0 63,239
Sewerage 70,947 62,904 62,962 3,777 10,897 10,494 403 0 62,962
Storm Water Management 5,507 – 278 – – 46 (46) (0) 278
Public Toilets – – – – – – – –
Waste management 27,892 30,234 30,281 2,116 6,527 5,047 1,480 0 30,281
Solid Waste 27,892 30,234 30,281 2,116 6,527 5,047 1,480 0 30,281
Other 7 – – – – – – –
Air Transport – – – – – – – –
Abattoirs – – – – – – – –
Tourism 7 – – – – – – –
Forestry – – – – – – – –
Markets – – – – – – – –
Total Revenue - Standard 2 563,393 611,761 617,871 44,578 88,050 102,978 (14,929) (0) 617,871
Expenditure - Standard
Municipal governance and administration 114,093 110,117 110,578 8,171 16,325 18,430 (2,105) (0) 110,578
Executive and council 44,515 33,720 34,481 2,343 5,364 5,747 (383) (0) 34,481
Mayor and Council 37,451 26,817 27,578 1,889 4,529 4,596 (67) (0) 27,578
Municipal Manager 7,064 6,902 6,902 453 835 1,150 (316) (0) 6,902
Budget and treasury office 33,329 40,938 40,838 2,864 5,642 6,806 (1,165) (0) 40,838
Corporate services 36,249 35,459 35,259 2,964 5,319 5,877 (557) (0) 35,259
Human Resources 8,038 9,361 9,361 477 897 1,560 (663) (0) 9,361
Information Technology 3,716 5,543 5,243 309 452 874 (422) (0) 5,243
Property Services 9,173 11,337 11,337 579 1,276 1,889 (614) (0) 11,337
Other Admin 15,321 9,218 9,318 1,600 2,695 1,553 1,142 0 9,318
Community and public safety 108,747 130,401 134,409 6,121 13,351 22,402 (9,051) (0) 134,409
Community and social services 15,254 17,267 17,270 1,124 2,032 2,878 (847) (0) 17,270
Libraries and Archives 6,713 8,173 8,176 559 1,032 1,363 (330) (0) 8,176
Museums & Art Galleries etc – – – – – – – –
Community halls and Facilities 5,441 5,724 5,724 350 651 954 (303) (0) 5,724
Cemeteries & Crematoriums 1,598 1,687 1,687 103 132 281 (150) (0) 1,687
Child Care – – – – – – – –
Aged Care – – – – – – – –
Other Community 1,502 1,683 1,683 111 216 280 (64) (0) 1,683
Other Social – – – – – – – –
Sport and recreation 17,260 18,910 20,060 979 1,749 3,343 (1,594) (0) 20,060
Public safety 33,556 38,267 38,267 2,734 5,134 6,378 (1,244) (0) 38,267
Police 15,105 17,760 17,760 1,111 2,249 2,960 (711) (0) 17,760
Fire 14,169 16,612 16,612 1,192 2,145 2,769 (624) (0) 16,612
Civil Defence – – – – – – – –
Street Lighting 3,977 3,648 3,648 431 740 608 132 0 3,648
Other 306 247 247 – – 41 (41) (0) 247
Housing 42,243 55,436 58,292 1,260 4,391 9,715 (5,324) (0) 58,292
Health 433 521 521 25 46 87 (41) (0) 521
Clinics 224 232 232 10 15 39 (24) (0) 232
Ambulance – – – – – – – –
Other 209 289 289 15 31 48 (17) (0) 289
Economic and environmental services 54,529 50,043 50,149 1,997 3,606 8,358 (4,752) (0) 50,149
Planning and development 8,411 8,685 8,790 642 1,159 1,465 (306) (0) 8,790
Economic Development/Planning 3,820 3,624 3,691 256 420 615 (195) (0) 3,691
Town Planning/Building
enforcement 4,590 5,061 5,100 386 739 850 (111) (0) 5,100
Licensing & Regulation – – – – – – – –
Road transport 39,326 31,535 31,535 945 1,737 5,256 (3,519) (0) 31,535
Roads 33,986 25,333 25,333 532 901 4,222 (3,322) (0) 25,333
Public Buses – – – – – – – –
Parking Garages – – – – – – – –
Vehicle Licensing and Testing 5,340 6,202 6,202 413 836 1,034 (198) (0) 6,202
Other – – – – – – – –
Environmental protection 6,792 9,824 9,824 410 711 1,637 (927) (0) 9,824
Pollution Control – – – – – – – –
Biodiversity & Landscape 3,395 4,877 4,877 209 428 813 (385) (0) 4,877
Other 3,397 4,947 4,947 200 283 824 (542) (0) 4,947
Trading services 285,959 343,429 343,534 33,519 37,872 57,256 (19,383) (0) 343,534
Electricity 188,582 223,583 223,583 26,050 27,248 37,264 (10,016) (0) 223,583
Electricity Distribution 188,582 223,583 223,583 26,050 27,248 37,264 (10,016) (0) 223,583
Electricity Generation – – – – – – – –
Water 35,847 39,894 39,894 1,688 2,709 6,649 (3,940) (0) 39,894
Water Distribution 24,891 26,689 26,689 1,150 1,854 4,448 (2,594) (0) 26,689
Water Storage 10,956 13,205 13,205 538 855 2,201 (1,345) (0) 13,205
Waste water management 45,815 54,569 54,627 4,135 5,390 9,104 (3,714) (0) 54,627
Sewerage 42,563 51,310 51,368 3,992 5,192 8,561 (3,370) (0) 51,368
Storm Water Management 1,557 1,618 1,618 24 25 270 (245) (0) 1,618
Public Toilets 1,696 1,641 1,641 119 174 273 (99) (0) 1,641
Waste management 15,715 25,383 25,430 1,645 2,525 4,238 (1,713) (0) 25,430
Solid Waste 15,715 25,383 25,430 1,645 2,525 4,238 (1,713) (0) 25,430
Other 1,226 1,264 1,264 73 137 211 (73) (0) 1,264
Air Transport 140 164 164 11 21 27 (6) (0) 164
Abattoirs – – – – – – – –
Tourism 1,086 1,100 1,100 61 116 183 (67) (0) 1,100
Forestry – – – – – – – –
Markets – – – – – – – –
Total Expenditure - Standard 3 564,553 635,254 639,935 49,881 71,291 106,656 (35,364) (0) 639,935
Surplus/ (Deficit) for the year (1,160) (23,493) (22,064) (5,303) 16,758 (3,677) 20,436 (0) (22,064)
References
1. Government Finance Statistics Functions and Sub-functions are standardised to assist national and international accounts and comparison
2. Total Revenue by Standard Classification must reconcile to total operating revenue shown in Financial Performance (revenue and expenditure)
3. Total Expenditure by Standard Classification must reconcile to total operating expenditure shown in Financial Performance (revenue and expenditure)
4. All amounts must be classified under a Standard (modified GFS) classification. The GFS function 'Other' is only for Abbatoirs, Air Transport, Markets and Tourism - and if used must be supported by footnotes. Nothing
else may be placed under 'Other'. Assign associate share to relevant classification
check oprev balance - - - - - -0 -
check opexp balance - - - - - - -
WC025 Breede Valley - Table C3 Monthly Budget Statement - Financial Performance (revenue and expenditure by municipal vote) - M02 August
Vote Description 2010/11 Budget Year 2011/12
Audited Original Adjusted Monthly YearTD YTD YTD Full Year
Ref YearTD actual
[Insert departmental structure etc 3.] Outcome Budget Budget actual budget variance variance Forecast
R thousands %
Revenue by Vote 1
Vote 1 - Council General 376 829 1,290 3 209 215 (6) -2.9% 1,290
Vote 2 - Municipal Manager 683 500 500 500 500 83 417 500.0% 500
Vote 3 - Corporate Services 31,887 48,311 51,167 1,544 4,268 8,528 (4,259) -49.9% 51,167
Vote 4 - Financial Services 108,009 114,170 114,170 8,222 26,978 19,028 7,949 41.8% 114,170
Vote 5 - Community Services 15,189 17,637 17,956 1,130 2,262 2,993 (730) -24.4% 17,956
Vote 6 - Operational Services 407,249 430,314 432,788 33,179 53,833 72,131 (18,299) -25.4% 432,788
Vote 7 - Example 7 – – – – – – – –
Vote 8 - Example 8 – – – – – – – –
Vote 9 - Example 9 – – – – – – – –
Vote 10 - Example 10 – – – – – – – –
Vote 11 - Example 11 – – – – – – – –
Vote 12 - Example 12 – – – – – – – –
Vote 13 - Example 13 – – – – – – – –
Vote 14 - Example 14 – – – – – – – –
Vote 15 - Example 15 – – – – – – – –
Total Revenue by Vote 2 563,393 611,761 617,871 44,578 88,050 102,978 (14,929) -14.5% 617,871
Expenditure by Vote 1
Vote 1 - Council General 33,559 22,750 23,211 1,582 3,962 3,868 93 2.4% 23,211
Vote 2 - Municipal Manager 8,766 7,940 7,940 494 893 1,323 (431) -32.6% 7,940
Vote 3 - Corporate Services 72,711 85,709 88,564 3,501 8,310 14,761 (6,450) -43.7% 88,564
Vote 4 - Financial Services 38,509 47,619 47,619 3,354 6,560 7,937 (1,377) -17.3% 47,619
Vote 5 - Community Services 43,367 50,922 50,924 3,396 6,494 8,487 (1,994) -23.5% 50,924
Vote 6 - Operational Services 367,641 420,315 421,675 37,553 45,073 70,279 (25,206) -35.9% 421,675
Vote 7 - Example 7 – – – – – – – –
Vote 8 - Example 8 – – – – – – – –
Vote 9 - Example 9 – – – – – – – –
Vote 10 - Example 10 – – – – – – – –
Vote 11 - Example 11 – – – – – – – –
Vote 12 - Example 12 – – – – – – – –
Vote 13 - Example 13 – – – – – – – –
Vote 14 - Example 14 – – – – – – – –
Vote 15 - Example 15 – – – – – – – –
Total Expenditure by Vote 2 564,553 635,254 639,935 49,881 71,291 106,656 (35,364) -33.2% 639,935
Surplus/ (Deficit) for the year 2 (1,160) (23,493) (22,064) (5,303) 16,758 (3,677) 20,436 -555.7% (22,064)
WC025 Breede Valley - Table C3 Monthly Budget Statement - Financial Performance (revenue and expenditure by municipal vote) - A - M02 August
Vote Description Ref 2010/11 Budget Year 2011/12
Audited Original Adjusted Full Year
R thousand Monthly actual YearTD actual YearTD budget YTD variance YTD variance
Outcome Budget Budget Forecast
%
Revenue by Vote 1
Vote 1 - Council General 376 829 1,290 3 209 215 (6) -3% 1,290
Admin 376 829 1,290 3 209 215 (6) -3% 1,290
Mayoral Office – – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 2 - Municipal Manager 683 500 500 500 500 83 417 500% 500
Subvote example 2 308 – – – – – – –
Internal Audit – – – – – – – –
IDP 375 400 400 400 400 67 333 500% 400
Community Safety – – – – – – – –
Ombudsman – – – – – – – –
Performance Management & Community – 100 100 100 100 17 83 500% 100
Area Managers – – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 3 - Corporate Services 31,887 48,311 51,167 1,544 4,268 8,528 (4,259) -50% 51,167
Admin 969 1,246 1,253 3 188 209 (21) -10% 1,253
Civic Buildings 270 258 258 42 63 43 20 46% 258
Housing 30,648 46,807 49,655 1,500 4,018 8,276 (4,258) -51% 49,655
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 4 - Financial Services 108,009 114,170 114,170 8,222 26,978 19,028 7,949 42% 114,170
Admin 16,569 18,004 18,004 1,803 4,572 3,001 1,571 52% 18,004
Revenue 90,396 95,861 95,861 6,038 21,977 15,977 6,000 38% 95,861
Expenditure – – – – – – – –
Financial Planning 841 290 290 299 299 48 250 518% 290
Supply Chain Management 203 15 15 83 130 3 127 5099% 15
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 5 - Community Services 15,189 17,637 17,956 1,130 2,262 2,993 (730) -24% 17,956
Admin – – – – – – – –
Health 77 12 12 – – 2 (2) -100% 12
Traffic 13,083 16,030 16,242 1,084 1,859 2,707 (848) -31% 16,242
Fire Protection 840 442 442 20 45 74 (29) -39% 442
Libraries 1,190 1,153 1,259 26 358 210 148 71% 1,259
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 6 - Operational Services 407,249 430,314 432,788 33,179 53,833 72,131 (18,299) -25% 432,788
Public Works 31,170 9,292 10,175 528 646 1,696 (1,050) -62% 10,175
Cemetaries 495 572 572 50 104 95 9 9% 572
Recreational Facilities 447 1,366 2,851 2 2 475 (473) -100% 2,851
Resorts 1,863 2,328 2,328 83 167 388 (221) -57% 2,328
Refuse Removal 27,892 30,234 30,281 2,116 6,527 5,047 1,480 29% 30,281
Sewerage 70,947 62,904 62,962 3,777 10,897 10,494 403 4% 62,962
Electricity Management 221,135 266,011 266,011 24,208 30,328 44,335 (14,007) -32% 266,011
Water Management 53,300 57,608 57,608 2,416 5,162 9,601 (4,440) -46% 57,608
– – – – – – – –
– – – – – – – –
Vote 7 - Example 7 – – – – – – – –
Subvote example 7 –
–
–
–
–
–
–
–
–
–
Example 8 - Vote8 – – – – – – – –
Subvote example 8 –
–
–
–
–
–
–
–
–
–
Example 9 - Vote9 – – – – – – – –
Subvote example 9 –
–
–
–
–
–
–
–
–
–
Example 10 - Vote10 – – – – – – – –
Subvote example 10 –
–
–
–
–
–
–
–
–
–
Example 11 - Vote11 – – – – – – – –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Example 12 - Vote12 – – – – – – – –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Example 13 - Vote13 – – – – – – – –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Example 14 - Vote14 – – – – – – – –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Example 15 - Vote15 – – – – – – – –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Total Revenue by Vote 2 563,393 611,761 617,871 44,578 88,050 102,978 (14,929)
– -14% 617,871
Expenditure by Vote 1 –
Vote 1 - Council General 33,559 22,750 23,211 1,582 3,962 3,868 93 2% 23,211
Admin 26,578 15,163 15,624 997 2,815 2,604 210 8% 15,624
Mayoral Office 6,981 7,586 7,586 585 1,147 1,264 (117) -9% 7,586
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 2 - Municipal Manager 8,766 7,940 7,940 494 893 1,323 (431) -33% 7,940
Subvote example 2 2,978 1,967 1,967 109 209 328 (119) -36% 1,967
Internal Audit 1,589 1,939 1,939 99 188 323 (135) -42% 1,939
IDP 1,903 1,457 1,457 70 127 243 (116) -48% 1,457
Community Safety 266 288 288 1 19 48 (29) -60% 288
Ombudsman 119 118 118 7 15 20 (5) -26% 118
Performance Management & Community 1,349 1,508 1,508 160 241 251 (10) -4% 1,508
Area Managers 563 664 664 48 95 111 (16) -15% 664
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 3 - Corporate Services 72,711 85,709 88,564 3,501 8,310 14,761 (6,450) -44% 88,564
Admin 26,380 26,092 26,099 2,004 3,490 4,350 (860) -20% 26,099
Civic Buildings 6,622 6,954 6,954 396 774 1,159 (385) -33% 6,954
Housing 39,708 52,663 55,512 1,102 4,047 9,252 (5,205) -56% 55,512
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 4 - Financial Services 38,509 47,619 47,619 3,354 6,560 7,937 (1,377) -17% 47,619
Admin 7,323 8,603 8,603 496 697 1,434 (737) -51% 8,603
Revenue 16,286 21,137 21,137 1,586 3,512 3,523 (11) 0% 21,137
Expenditure 781 1,131 1,131 71 127 188 (61) -33% 1,131
Financial Planning 6,301 7,373 7,373 518 959 1,229 (270) -22% 7,373
Supply Chain Management 7,818 9,375 9,375 683 1,266 1,563 (297) -19% 9,375
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 5 - Community Services 43,367 50,922 50,924 3,396 6,494 8,487 (1,994) -23% 50,924
Admin 1,502 1,683 1,683 111 216 280 (64) -23% 1,683
Health 232 245 245 10 15 41 (25) -62% 245
Traffic 20,673 24,068 24,068 1,524 3,085 4,011 (927) -23% 24,068
Fire Protection 14,246 16,753 16,753 1,192 2,145 2,792 (648) -23% 16,753
Libraries 6,713 8,173 8,176 559 1,032 1,363 (330) -24% 8,176
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 6 - Operational Services 367,641 420,315 421,675 37,553 45,073 70,279 (25,206) -36% 421,675
Public Works 64,381 57,907 58,013 2,976 5,345 9,669 (4,324) -45% 58,013
Cemetaries 1,598 1,687 1,687 103 132 281 (150) -53% 1,687
Recreational Facilities 13,356 15,307 16,457 756 1,384 2,743 (1,359) -50% 16,457
Resorts 3,904 3,602 3,602 223 365 600 (235) -39% 3,602
Refuse Removal 17,411 27,023 27,070 1,765 2,699 4,512 (1,813) -40% 27,070
Sewerage 42,563 51,310 51,368 3,992 5,192 8,561 (3,370) -39% 51,368
Electricity Management 188,582 223,583 223,583 26,050 27,248 37,264 (10,016) -27% 223,583
Water Management 35,847 39,894 39,894 1,688 2,709 6,649 (3,940) -59% 39,894
– – – – – – – –
– – – – – – – –
Vote 7 - Example 7 – – – – – – – –
Subvote example 7 –
–
–
–
–
–
–
–
–
–
Example 8 - Vote8 – – – – – – – –
Subvote example 8 –
–
–
–
–
–
–
–
–
–
Example 9 - Vote9 – – – – – – – –
Subvote example 9 –
–
–
–
–
–
–
–
–
–
Example 10 - Vote10 – – – – – – – –
Subvote example 10 –
–
–
–
–
–
–
–
–
–
Example 11 - Vote11 – – – – – – – –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Example 12 - Vote12 – – – – – – – –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Example 13 - Vote13 – – – – – – – –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Example 14 - Vote14 – – – – – – – –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Example 15 - Vote15 – – – – – – – –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Total Expenditure by Vote 2 564,553 635,254 639,935 49,881 71,291 106,656 (35,364)
– (0) 639,935
Surplus/ (Deficit) for the year 2 (1,160) (23,493) (22,064) (5,303) 16,758 (3,677) 20,436 (0) (22,064)
References
1. Insert 'Vote'; e.g. Department, if different to standard structure
2. Must reconcile to Financial Performance ('Revenue and Expenditure by Standard Classification' and 'Revenue and Expenditure')
3. Assign share in 'associate' to relevant Vote
check revenue - - - - - -0 -
check expenditure - - - - - - -
WC025 Breede Valley - Table C4 Monthly Budget Statement - Financial Performance (revenue and expenditure) - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands %
Revenue By Source
Property rates 63,898 68,756 68,756 5,999 11,814 11,459 355 3% 68,756
Property rates - penalties & collection charges 470 511 511 33 65 85 (20) -23% 511
Service charges - electricity revenue 216,474 258,832 258,832 23,675 28,699 43,139 (14,440) -33% 258,832
Service charges - water revenue 40,209 37,985 37,985 2,397 2,444 6,331 (3,887) -61% 37,985
Service charges - sanitation revenue 39,707 41,998 41,998 3,750 7,672 7,000 672 10% 41,998
Service charges - refuse revenue 23,661 24,282 24,282 2,090 4,295 4,047 248 6% 24,282
Service charges - other – – – – – – – –
Rental of facilities and equipment 10,015 11,412 11,412 842 1,676 1,902 (226) -12% 11,412
Interest earned - external investments 7,350 7,500 7,500 364 574 1,250 (676) -54% 7,500
Interest earned - outstanding debtors 2,053 2,046 2,046 190 367 341 26 8% 2,046
Dividends received – – – – – – – –
Fines 7,147 9,290 9,290 538 1,132 1,548 (416) -27% 9,290
Licences and permits 2,786 2,527 2,527 233 472 421 50 12% 2,527
Agency services 3,769 3,763 3,763 339 339 627 (288) -46% 3,763
Transfers recognised - operational 91,740 104,558 109,238 3,437 27,590 18,206 9,383 52% 109,238
Other revenue 4,317 7,720 7,720 691 910 1,287 (376) -29% 7,720
Gains on disposal of PPE 254 15 15 – – 3 (3) -100% 15
513,850 581,194 585,874 44,578 88,050 97,646 (9,596) -10% 585,874
Total Revenue (excluding capital transfers and contributions)
Expenditure By Type
Employee related costs 158,420 181,615 181,657 12,522 24,483 30,276 (5,793) -19% 181,657
Remuneration of councillors 10,145 11,479 11,479 917 1,834 1,913 (79) -4% 11,479
Debt impairment 2,669 6,000 6,000 – – 1,000 (1,000) -100% 6,000
Depreciation & asset impairment 62,933 66,255 66,300 – – 11,050 (11,050) -100% 66,300
Finance charges 23,679 32,005 32,005 5,031 5,031 5,334 (303) -6% 32,005
Bulk purchases 141,178 172,962 172,962 22,775 22,784 28,827 (6,043) -21% 172,962
Other materials 42,739 46,622 46,674 2,416 2,823 7,779 (4,956) -64% 46,674
Contracted services 3,719 2,652 2,640 285 298 440 (142) -32% 2,640
Transfers and grants 166 150 150 2 4 25 (21) -86% 150
Other expenditure 118,884 115,426 119,979 5,934 14,034 19,997 (5,962) -30% 119,979
Loss on disposal of PPE 22 90 90 – – 15 (15) -100% 90
Total Expenditure 564,553 635,254 639,935 49,881 71,291 106,656 (35,364) -33% 639,935
Surplus/(Deficit) (50,703) (54,060) (54,060) (5,303) 16,758 (9,010) 25,768 (0) (54,060)
Transfers recognised - capital 49,543 30,567 31,996 – – 5,333 (5,333) (0) 31,996
Contributions recognised - capital – – – – – – – –
Contributed assets – – – – – – – –
Surplus/(Deficit) after capital transfers & contributions (1,160) (23,493) (22,064) (5,303) 16,758 (3,677) (22,064)
Taxation – – – – – – – –
Surplus/(Deficit) after taxation (1,160) (23,493) (22,064) (5,303) 16,758 (3,677) (22,064)
Attributable to minorities – – – – – – –
Surplus/(Deficit) attributable to municipality (1,160) (23,493) (22,064) (5,303) 16,758 (3,677) (22,064)
Share of surplus/ (deficit) of associate – – – – – – –
Surplus/ (Deficit) for the year (1,160) (23,493) (22,064) (5,303) 16,758 (3,677) (22,064)
References
1. Material variances to be explained on Table SC1
563,393 611,761
Total Revenue (excluding capital transfers and contributions) including capital transfers/contributions etc 617,871 44,578 88,050 102,978 617,871
WC025 Breede Valley - Table C5 Monthly Budget Statement - Capital Expenditure (municipal vote, standard classification and funding) - M02 August
2010/11 Budget Year 2011/12
Vote Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands 1 %
Multi-Year expenditure appropriation 2
Vote 1 - Council General – – – – – – – –
Vote 2 - Municipal Manager – – – – – – – –
Vote 3 - Corporate Services – – – – – – – –
Vote 4 - Financial Services – – – – – – – –
Vote 5 - Community Services – – – – – – – –
Vote 6 - Operational Services – – – – – – – –
Vote 7 - Example 7 – – – – – – – –
Vote 8 - Example 8 – – – – – – – –
Vote 9 - Example 9 – – – – – – – –
Vote 10 - Example 10 – – – – – – – –
Vote 11 - Example 11 – – – – – – – –
Vote 12 - Example 12 – – – – – – – –
Vote 13 - Example 13 – – – – – – – –
Vote 14 - Example 14 – – – – – – – –
Vote 15 - Example 15 – – – – – – – –
Total Capital Multi-year expenditure 4,7 – – – – – – – –
Single Year expenditure appropriation 2
Vote 1 - Council General 159 – – – – – – –
Vote 2 - Municipal Manager – – – – – – – –
Vote 3 - Corporate Services 558 129 289 – – – – 289
Vote 4 - Financial Services 482 218 218 – – – – 218
Vote 5 - Community Services 2,155 1,379 1,695 – 0 – 0 #DIV/0! 1,695
Vote 6 - Operational Services 134,179 111,787 119,989 2,475 4,041 18,586 (14,545) -78% 119,989
Vote 7 - Example 7 – – – – – – – –
Vote 8 - Example 8 – – – – – – – –
Vote 9 - Example 9 – – – – – – – –
Vote 10 - Example 10 – – – – – – – –
Vote 11 - Example 11 – – – – – – – –
Vote 12 - Example 12 – – – – – – – –
Vote 13 - Example 13 – – – – – – – –
Vote 14 - Example 14 – – – – – – – –
Vote 15 - Example 15 – – – – – – – –
Total Capital single-year expenditure 4 137,534 113,513 122,191 2,475 4,042 18,586 (14,544) -78% 122,191
Total Capital Expenditure 137,534 113,513 122,191 2,475 4,042 18,586 (14,544) -78% 122,191
Capital Expenditure - Standard Classification
Governance and administration 3,750 1,310 1,310 280 280 – 280 #DIV/0! 1,310
Executive and council 222 274 274 – – – – 274
Budget and treasury office 364 – – – – – – –
Corporate services 3,163 1,036 1,036 280 280 – 280 #DIV/0! 1,036
Community and public safety 2,624 2,478 3,289 – 0 520 (520) -100% 3,289
Community and social services 429 58 321 – 0 – 0 #DIV/0! 321
Sport and recreation 227 1,086 1,422 – – 520 (520) -100% 1,422
Public safety 1,968 1,334 1,546 – – – – 1,546
Housing – – – – – – – –
Health – – – – – – – –
Economic and environmental services 11,450 1,602 2,102 – – – – 2,102
Planning and development 0 39 39 – – – – 39
Road transport 11,450 1,563 2,063 – – – – 2,063
Environmental protection – – – – – – – –
Trading services 119,710 108,123 115,490 2,195 3,762 18,066 (14,305) -79% 115,490
Electricity 15,215 47,420 54,017 81 205 6,069 (5,864) -97% 54,017
Water 6,508 13,124 13,124 3 11 94 (82) -88% 13,124
Waste water management 97,288 47,078 47,848 2,111 3,545 11,903 (8,358) -70% 47,848
Waste management 699 500 500 – – – – 500
Other 1 – – – – – – –
Total Capital Expenditure - Standard Classification 3 137,534 113,513 122,191 2,475 4,042 18,586 (14,544) -78% 122,191
Funded by:
National Government 18,390 26,982 26,982 1,722 3,155 12,187 (9,031) -74% 26,982
Provincial Government 29,436 2,035 3,129 – – – – 3,129
District Municipality – – – – – – – –
Other transfers and grants 1,425 1,050 1,386 – – 520 (520) -100% 1,386
Transfers recognised - capital 49,251 30,067 31,496 1,722 3,155 12,707 (9,551) -75% 31,496
Public contributions & donations 5 291 500 500 – – – – 500
Borrowing 6 58,872 75,114 80,875 – – 4,769 (4,769) -100% 80,875
Internally generated funds 29,119 7,832 9,320 753 886 1,110 (224) -20% 9,320
Total Capital Funding 137,534 113,513 122,191 2,475 4,042 18,586 (14,544) -78% 122,191
References
1. Municipalities may choose to appropriate for capital expenditure for three years or for one year (if one year appropriation projected expenditure required for yr2 and yr3).
2. Include capital component of PPP unitary payment
3. Capital expenditure by standard classification must reconcile to the total of multi-year and single year appropriations
4. Include expenditure on investment property, intangible and biological assets
5. Must reconcile to Monthly Budget Statement Financial Performance (revenue and expenditure)
6. Include finance leases and PPP capital funding component of unitary payment - total borrowing/repayments to reconcile to changes in Table SA17
WC025 Breede Valley - Table C5 Monthly Budget Statement - Capital Expenditure (municipal vote, standard classification and funding) - A - M02 August
Vote Description Ref 2010/11 Budget Year 2011/12
Audited Original Adjusted Full Year
R thousand Monthly actual YearTD actual YearTD budget YTD variance YTD variance
Outcome Budget Budget Forecast
%
Capital expenditure - Municipal Vote
Expenditure of multi-year capital appropriation 1
Vote 1 - Council General – – – – – – – –
Admin –
Mayoral Office –
–
–
–
–
–
–
–
–
Vote 2 - Municipal Manager – – – – – – – –
Admin –
Internal Audit –
IDP –
Community Safety –
Ombudsman –
Performance Management & Community –
Area Managers –
–
–
–
Vote 3 - Corporate Services – – – – – – – –
Admin –
Civic Buildings –
Housing –
–
–
–
–
–
–
–
Vote 4 - Financial Services – – – – – – – –
Admin –
Revenue –
Expenditure –
Financial Planning –
Supply Chain Management –
–
–
–
–
–
Vote 5 - Community Services – – – – – – – –
Admin –
Health –
Traffic –
Fire Protection –
Libraries –
–
–
–
–
–
Vote 6 - Operational Services – – – – – – – –
Public Works –
Cemetaries –
Recreational Facilities –
Resorts –
Refuse Removal –
Sewerage –
Electricity Management –
Water Management –
–
–
Example 7 - Vote7 – – – – – – – –
Subvote example 7 –
–
–
–
–
–
–
–
–
–
Example 8 - Vote8 – – – – – – – –
Subvote example 8 –
–
–
–
–
–
–
–
–
–
Example 9 - Vote9 – – – – – – – –
Subvote example 9 –
–
–
–
–
–
–
–
–
–
Example 10 - Vote10 – – – – – – – –
Subvote example 10 –
–
–
–
–
–
–
–
–
–
Example 11 - Vote11 – – – – – – – –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Example 12 - Vote12 – – – – – – – –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Example 13 - Vote13 – – – – – – – –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Example 14 - Vote14 – – – – – – – –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Example 15 - Vote15 – – – – – – – –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Total multi-year capital expenditure – – – – – – –
– –
Capital expenditure - Municipal Vote
Expenditue of single-year capital appropriation 1 –
Vote 1 - Council General 159 – – – – – – –
Admin 159 – – – – – – –
Mayoral Office 1 – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 2 - Municipal Manager – – – – – – – –
Admin – – – – – – – –
Internal Audit – – – – – – – –
IDP – – – – – – – –
Community Safety – – – – – – – –
Ombudsman – – – – – – – –
Performance Management & Community – – – – – – – –
Area Managers – – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 3 - Corporate Services 558 129 289 – – – – 289
Admin 307 116 116 – – – – 116
Civic Buildings 252 13 172 – – – – 172
Housing – – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 4 - Financial Services 482 218 218 – – – – 218
Admin – – – – – – – –
Revenue 26 – – – – – – –
Expenditure – – – – – – – –
Financial Planning 313 200 200 – – – – 200
Supply Chain Management 144 18 18 – – – – 18
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 5 - Community Services 2,155 1,379 1,695 – 0 – 0 #DIV/0! 1,695
Admin 2 40 40 – – – – 40
Health – – – – – – – –
Traffic 256 800 1,012 – – – – 1,012
Fire Protection 1,712 534 534 – – – – 534
Libraries 185 5 109 – 0 – 0 #DIV/0! 109
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
Vote 6 - Operational Services 134,179 111,787 119,989 2,475 4,041 18,586 (14,545) -78% 119,989
Public Works 19,749 2,578 3,356 280 280 – 280 #DIV/0! 3,356
Cemetaries – – – – – – – –
Recreational Facilities 227 1,065 1,401 – – 520 (520) -100% 1,401
Resorts – 21 21 – – – – 21
Refuse Removal 699 500 500 – – – – 500
Sewerage 91,781 47,078 47,570 2,111 3,545 11,903 (8,358) -70% 47,570
Electricity Management 15,215 47,420 54,017 81 205 6,069 (5,864) -97% 54,017
Water Management 6,508 13,124 13,124 3 11 94 (82) -88% 13,124
– – – – – – – –
– – – – – – – –
Example 7 - Vote7 – – – – – – – –
Subvote example 7 –
–
–
–
–
–
–
–
–
–
Example 8 - Vote8 – – – – – – – –
Subvote example 8 –
–
–
–
–
–
–
–
–
–
Example 9 - Vote9 – – – – – – – –
Subvote example 9 –
–
–
–
–
–
–
–
–
–
Example 10 - Vote10 – – – – – – – –
Subvote example 10 –
–
–
–
–
–
–
–
–
–
Example 11 - Vote11 – – – – – – – –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Subvote example 11 –
Example 12 - Vote12 – – – – – – – –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Subvote example 12 –
Example 13 - Vote13 – – – – – – – –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Subvote example 13 –
Example 14 - Vote14 – – – – – – – –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Subvote example 14 –
Example 15 - Vote15 – – – – – – – –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Subvote example 15 –
Total single-year capital expenditure 137,534 113,513 122,191 2,475 4,042 18,586 (14,544)
– (0) 122,191
Total Capital Expenditure 137,534 113,513 122,191 2,475 4,042 18,586 (14,544) (0) 122,191
References
1. Insert 'Vote'; e.g. Department, if different to standard structure
WC025 Breede Valley - Table C6 Monthly Budget Statement - Financial Position - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Full Year
YearTD actual
Outcome Budget Budget Forecast
R thousands 1
ASSETS
Current assets
Cash 37,281 10,465 10,465 31,237 10,465
Call investment deposits 90,000 80,000 80,000 115,000 80,000
Consumer debtors 51,432 48,443 48,443 48,251 48,443
Other debtors 9,389 12,750 12,750 6,616 12,750
Current portion of long-term receivables 1,324 2,037 2,037 1,324 2,037
Inventory 6,078 6,700 6,700 6,479 6,700
Total current assets 195,504 160,394 160,394 208,906 160,394
Non current assets
Long-term receivables 3,927 5,500 5,500 3,856 5,500
Investments – – – – –
Investment property 8,356 7,600 7,600 8,356 7,600
Investments in Associate – – – – –
Property, plant and equipment 1,789,821 1,805,020 1,813,697 1,783,010 1,813,697
Agricultural – – – – –
Biological assets – – – – –
Intangible assets 483 423 423 467 423
Other non-current assets – – – – –
Total non current assets 1,802,587 1,818,543 1,827,220 1,795,689 1,827,220
TOTAL ASSETS 1,998,091 1,978,937 1,987,615 2,004,595 1,987,615
LIABILITIES
Current liabilities
Bank overdraft – – – – –
Borrowing 23,682 24,178 24,178 23,682 24,178
Consumer deposits 2,716 2,700 2,700 2,732 2,700
Trade and other payables 97,785 86,499 86,499 133,055 86,499
Provisions – – – – –
Total current liabilities 124,182 113,377 113,377 159,469 113,377
Non current liabilities
Borrowing 257,875 284,980 284,980 273,314 284,980
Provisions 124,082 120,946 120,946 124,836 120,946
Total non current liabilities 381,957 405,926 405,926 398,150 405,926
TOTAL LIABILITIES 506,139 519,303 519,303 557,618 519,303
NET ASSETS 2 1,491,952 1,459,634 1,468,312 1,446,977 1,468,312
COMMUNITY WEALTH/EQUITY
Accumulated Surplus/(Deficit) 1,489,418 1,456,818 1,456,818 1,444,850 1,456,818
Reserves 2,534 2,816 2,816 2,127 2,816
TOTAL COMMUNITY WEALTH/EQUITY 2 1,491,952 1,459,634 1,459,634 1,446,977 1,459,634
WC025 Breede Valley - Table C7 Monthly Budget Statement - Cash Flow - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands 1 %
CASH FLOW FROM OPERATING ACTIVITIES
Receipts
Ratepayers and other 457,141 473,190 473,190 48,233 83,472 75,834 7,638 10% 473,190
Government - operating 115,250 104,558 104,558 3,437 27,590 30,725 (3,136) -10% 104,558
Government - capital 35,190 30,567 30,567 500 15,439 10,080 5,359 53% 30,567
Interest 12,709 9,546 9,546 554 941 1,147 (206) -18% 9,546
Dividends – – – – – – – –
Payments
Suppliers and employees (478,969) (530,846) (535,526) (62,048) (104,441) (81,875) 22,566 -28% (535,526)
Finance charges (26,979) (31,382) (31,382) – – – – (31,382)
Transfers and Grants (150) (150) (150) (2) (4) (21) (17) 82% (150)
NET CASH FROM/(USED) OPERATING ACTIVITIES 114,193 55,484 50,804 (9,327) 22,998 35,891 (12,893) -36% 50,804
CASH FLOWS FROM INVESTING ACTIVITIES
Receipts
Proceeds on disposal of PPE 100 150 150 – – – – 150
Decrease (Increase) in non-current debtors – – – – – – – –
Decrease (increase) other non-current receivables (1,700) (300) (300) – – (50) 50 -100% (300)
Decrease (increase) in non-current investments 20,000 5,000 10,000 (10,000) (25,000) (60,000) 35,000 -58% 10,000
Payments
Capital assets (186,177) (113,513) (122,191) (2,475) (4,042) (18,094) (14,052) 78% (122,191)
NET CASH FROM/(USED) INVESTING ACTIVITIES (167,777) (108,663) (112,341) (12,475) (29,042) (78,144) (49,102) 63% (112,341)
CASH FLOWS FROM FINANCING ACTIVITIES
Receipts
Short term loans – – – – – – – –
Borrowing long term/refinancing 100,000 51,000 51,000 – – – – 51,000
Increase (decrease) in consumer deposits 219 53 53 – – 9 (9) -100% 53
Payments
Repayment of borrowing (21,850) (23,399) (23,399) – – – – (23,399)
NET CASH FROM/(USED) FINANCING ACTIVITIES 78,369 27,654 27,654 – – 9 9 100% 27,654
NET INCREASE/ (DECREASE) IN CASH HELD 24,785 (25,524) (33,882) (21,802) (6,044) (42,244) (33,882)
Cash/cash equivalents at beginning: 11,204 37,257 37,257 37,257 37,257 37,257
Cash/cash equivalents at month/year end: 35,989 11,733 3,375 31,213 (4,987) 3,375
WC025 Breede Valley - Supporting Table SC1 Material variance explanations - M02 August
Ref Description
Variance Reasons for material deviations Remedial or corrective steps/remarks
R thousands
1 Revenue By Source
Services Charges - Water Revenue -61% Low consumption during winter period Consumption will increase during summer period
Interest Reveivable for 2010/2011 has been deducted in July 2011,
Interest Earned - External Investments -54% and lower interest rates which resulted in less interest earned None
Agency Services -46% Less Vehicle Registration Fees recognised than budgeted Increase revenue collection of Agency Services
Transfers Recognised - Operational 52% ¼ of Equitable Share has been received in advance None
Transfers Recognised - Capital -100% Recognised at year-end after capitilisation of assets None
2 Expenditure By Type
Debt Impairment -100% Debt Impairment only once a year by May None
Depreciation & Asset Impairment -100% Trial Depreciation Run was done for August 2011 - R 10 955 317 Accruals to be made in future
Other Materials -64% Actual Expenditure less than budgeted due to savings Maintenance spending to accelerate
Transfers and Grants -86% Recognised after approved by Council None, to be awarded still after due process followed
3 Capital Expenditure
Total Capiatl expenditure Departments to ensure that for those where tenders
-78% Bulk at Operations (WWWTW) Payments for August 2011 only made after
month-end not yet awarded, tiemous actions be impemented to
ensure spending!
4 Financial Position
5 Cash Flow
6 Measureable performance
7 Municipal Entities
Not applicable
WC025 Breede Valley - Supporting Table SC2 Monthly Budget Statement - performance indicators - M02 August
2010/11 Budget Year 2011/12
Description of financial indicator Basis of calculation Ref Audited Original Adjusted Full Year
YearTD actual
Outcome Budget Budget Forecast
Percentage
Borrowing Management
Borrowing to Asset Ratio Total Long-term Borrowing/ Total Assets 12.9% 14.4% 14.3% 13.6% 14.3%
Capital Charges to Operating Expenditure Interest & principal paid/Operating Expenditure 15.3% 15.5% 15.4% 7.1% 6.8%
Borrowed funding of capital expenditure Borrowings/Capital expenditure excl. transfers and grants 42.8% 66.2% 66.2% 0.0% 66.2%
Safety of Capital
Debt to Equity Loans, Accounts Payable, Overdraft & Tax Provision/ 25.4% 27.1% 27.1% 29.7% 27.1%
Funds & Reserves
Gearing Long Term Borrowing/ Funds & Reserves 10177.2% 10121.4% 10121.4% 12851.9% 10121.4%
Liquidity
Current Ratio 1 Current assets/current liabilities 1 157.4% 141.5% 141.5% 131.0% 141.5%
Liquidity Ratio Monetary Assets/Current Liabilities 102.5% 79.8% 79.8% 91.7% 79.8%
Revenue Management
Annual Debtors Collection Rate Last 12 Mths Receipts/ Last 12 Mths Billing
(Payment Level %)
Outstanding Debtors to Revenue Total Outstanding Debtors to Annual Revenue 12.9% 11.8% 11.7% 68.2% 11.7%
Longstanding Debtors Reduction Due To Recovery Debtors > 12 Mths Recovered/Total Debtors > 0.0% 0.0% 0.0% 0.0% 0.0%
12 Months Old
Creditors Management
Creditors System Efficiency % of Creditors Paid Within Terms (within MFMA s 65(e)) 100.0% 97.0% 97.0% 90.0% 97.0%
Funding of Provisions
Percentage Of Provisions Not Funded Unfunded Provisions/Total Provisions
Other Indicators
Electricity Distribution Losses % Volume (units purchased and generated less units 2 6.6% 8.0% 8.0% 7.0% 8.0%
sold)/units purchased and generated
Water Distribution Losses % Volume (units purchased and own source less units 2 32.7% 18.0% 18.0% 11.0% 18.0%
sold)/Total units purchased and own source
Employee costs Employee costs/Total Revenue - capital revenue 30.8% 31.2% 31.0% 27.8% 31.0%
Repairs & Maintenance R&M/Total Revenue - capital revenue 8.3% 8.0% 8.0% 3.2% 8.0%
Interest & Depreciation I&D/Total Revenue - capital revenue 16.9% 16.9% 16.8% 5.7% 7.4%
IDP regulation financial viability indicators
i. Debt coverage (Total Operating Revenue - Operating Grants)/Debt 8.70 8.70 8.70 10.21 8.70
service payments due within financial year)
ii. O/S Service Debtors to Revenue Total outstanding service debtors/annual revenue 16.4% 10.9% 10.9% 6.3% 10.9%
received for services
iii. Cost coverage (Available cash + Investments)/monthly fixed operational 2.84 1.71 1.71 1.39 1.17
expenditure
References
1. Consumer debtors > 12 months old are excluded from current assets.
2. Material variances to be explained.
Calculations
Borrowing 257,875 284,980 284,980 273,314 284,980
Total Assets 1,998,091 1,978,937 1,987,615 2,004,595 1,987,615
Employee related costs 158,420 181,615 181,657 24,483 181,657
Repairs & Maintenance 42,739 46,622 46,674 2,823 46,674
Interest (finance charges) 23,679 32,005 32,005 5,031 32,005
Principal paid 21,850 23,399 23,399 23,399
Depreciation 62,933 66,255 66,300 11,479
Operating expenditure 564,553 635,254 639,935 71,291 639,935
Total Capital Expenditure 137,534 113,513 122,191 4,042 122,191
Borrowed funding for capital 58,872 75,114 80,875 80,875
Debt 379,342 395,657 395,657 430,051 395,657
Equity 1,491,952 1,459,634 1,459,634 1,446,977 1,459,634
Reserves 2,534 2,816 2,816 2,127 2,816
Borrowing 257,875 284,980 284,980 273,314 284,980
Current assets 195,504 160,394 160,394 208,906 160,394
Current liabilities 124,182 113,377 113,377 159,469 113,377
Monetary assets 127,281 90,465 90,465 146,237 90,465
Total Revenue (excluding capital transfers and contributions) 513,850 581,194 585,874 88,050 585,874
Transfers recognised - operational 91,740 104,558 109,238 27,590 109,238
Transfers recognised - capital 49,543 30,567 31,996 31,996
Debt service payments (9,141) (13,852) (13,852) (54,780)
Outstanding debtors (receivables) 66,072 68,730 68,730 60,047 68,730
Annual services revenue 320,051 363,097 363,097 43,110
Cash + investments Including LT investments 127,281 90,465 90,465 146,237 90,465
Fixed operational expend. (monthly) 47,046 52,938 53,328 71,291 53,328
Longstanding debtors outstanding 3,927 5,500 5,500 3,856 5,500
Longstanding debtors recovered
Attorney collections
WC025 Breede Valley - Supporting Table SC3 Monthly Budget Statement - aged debtors - M02 August
Description Budget Year 2011/12
NT
0-30 Days 31-60 Days 61-90 Days 91-120 Days 121-150 Dys 151-180 Dys 181 Dys-1 Yr Over 1Yr Total Bad
Code >90 days
R thousands Debts
Debtors Age Analysis By Revenue Source
Rates 1200 8,874 354 340 249 236 200 1,059 1,773 13,085 – 3,516
Electricity 1300 19,831 205 227 135 73 99 1,409 964 22,942 – 2,679
Water 1400 15,414 300 208 171 147 120 921 2,136 19,417 – 3,495
Sewerage / Sanitation 1500 10,949 378 283 222 179 153 850 1,655 14,669 – 3,059
Refuse Removal 1600 8,668 267 194 156 132 112 597 1,457 11,582 – 2,453
Housing (Rental Revenue) 1700 3,094 201 174 144 154 222 495 1,444 5,927 – 2,459
Other 1900 7,549 1,665 183 234 182 175 1,222 7,702 18,912 – 9,515
Total By Revenue Source 2000 74,379 3,370 1,610 1,311 1,103 1,081 6,552 17,129 106,535 – 27,176
2010/11 - totals only 70,660 3,202 1,529 1,245 1,048 1,027 6,224 16,273 101,208 25,817
Debtors Age Analysis By Customer Category
Government 2200 2,002 11 5 5 14 3 13 40 2,093 –
Business 2300 10,768 211 127 110 65 77 381 722 12,461 –
Households 2400 53,474 1,882 1,349 1,071 934 876 5,099 11,468 76,153 –
Other 2500 8,136 1,267 128 124 91 124 1,059 4,899 15,827 –
Total By Customer Category 2600 74,379 3,370 1,610 1,311 1,103 1,081 6,552 17,129 106,535 –
Notes
Material increases in value of debtors' categories compared to previous month to be explained
Bad debts = amounts actually written off in the month
Total by Revenue Source must reconcile with Total by Customer Group
– – – – – – – – –
WC025 Breede Valley - Supporting Table SC4 Monthly Budget Statement - aged creditors - M02 August
Budget Year 2011/12 Prior year totals
Description NT
0- 31 - 61 - 91 - 121 - 151 - 181 Days - Over 1 Total for chart (same
Code
R thousands 30 Days 60 Days 90 Days 120 Days 150 Days 180 Days 1 Year Year period)
Creditors Age Analysis By Customer Type
Bulk Electricity 0100 22,962 – – – – – – – 22,962 –
Bulk Water 0200 60 – – – – – – – 60 –
PAYE deductions 0300 – – – – – – – – – –
VAT (output less input) 0400 – – – – – – – – –
Pensions / Retirement deductions 0500 – – – – – – – 7,928 7,928 –
Loan repayments 0600 – – – – – – – – – –
Trade Creditors 0700 26,338 – – – – – – – 26,338
Auditor General 0800 – – – – – – – – – –
Other 0900 – 32,088 – – – – – 1,401 33,488 –
Total By Customer Type 2600 49,359 32,088 – – – – – 9,328 90,775 –
WC025 Breede Valley - Supporting Table SC5 Monthly Budget Statement - investment portfolio - M02 August
Type of Expiry date of Accrued Yield for the Market value Change in Market value
Investment investment interest for month 1 at beginning market value at end of the
Investments by maturity Period of
the month (%) of the month month
Name of institution & investment ID Ref Investment
R thousands Yrs/Months
Municipality
Nedbank 12 Months Notice deposit 12 Jan 2012 25 5,000 – 5,000
Investec 7 Months Notice deposit 28 Sept 2011 25 5,000 – 5,000
Investec 8 Months Notice deposit 30 Nov 2011 26 5,000 – 5,000
Nedbank 12 Months Notice deposit 29 Mar 2012 55 10,000 – 10,000
FNB 2 Months Notice deposit 29 Aug 2011 21 – – –
FNB 3 Months Notice deposit 28 Jun 2012 23 5,000 – 5,000
Standard Bank 2 Months Notice deposit 30 Aug 2011 45 – – –
Standard Bank 5 Months Notice deposit 30 Nov 2011 25 5,000 – 5,000
Standard Bank 6 Months Notice deposit 30 Dec 2011 50 10,000 – 10,000
Nedbank 3 Months Notice deposit 29 Sep 2011 24 5,000 – 5,000
Nedbank 5 Months Notice deposit 29 Nov 2011 25 5,000 – 5,000
Investec 3 Months Notice deposit 29 Sept 2011 24 5,000 – 5,000
Investec 4 Months Notice deposit 28 Oct 2011 24 5,000 – 5,000
ABSA 4 Months Notice deposit 31 Oct 2011 24 5,000 – 5,000
Standard Bank 2 Months Notice deposit 28 Sept 2011 24 5,000 – 5,000
Nedbank 7 Months Notice deposit 28 Febr 2012 25 5,000 – 5,000
Investec 8 Months Notice deposit 29 Mar 2012 26 5,000 – 5,000
FNB 12 Months Notice deposit 28 Jul 2012 26 5,000 – 5,000
Standard Bank 1 Month Notice deposit 30 Sept 2011 2 5,000 – 5,000
Nedbank 2 Months Notice deposit 31 Oct 2011 2 5,000 – 5,000
Standard Bank 2 Months Notice deposit 31 Oct 2011 3 10,000 – 10,000
Nedbank 3 Months Notice deposit 29 Nov 2011 2 5,000 – 5,000
Municipality sub-total 525 115,000 – 115,000
Entities
Entities sub-total – – – –
TOTAL INVESTMENTS AND INTEREST 2 525 115,000 – 115,000
WC025 Breede Valley - Supporting Table SC6 Monthly Budget Statement - transfers and grant receipts - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands %
RECEIPTS: 1,2
Operating Transfers and Grants
National Government: 55,120 58,844 58,844 2,040 25,708 25,330 378 1.5% 58,844
Local Government Equitable Share 53,333 56,804 56,804 – 23,668 23,290 378 1.6% 56,804
Finance Management 1,000 1,250 1,250 1,250 1,250 1,250 – 1,250
Municipal Systems Improvement 787 790 790 790 790 790 – 790
Provincial Government: 36,391 45,714 50,306 1,397 1,882 5,396 (3,514) -65.1% 50,306
Health subsidy 77 12 12 – – – – 12
Housing – 37,540 37,540 – – 4,100 (4,100) -100.0% 37,540
LGWSETA 444 600 600 – 173 84 89 106.0% 600
Learnership SETA 4 – 500 500 – – 100 (100) -100.0% 500
Proclaimed Roads 9,010 115 115 – – – – 115
Proj Prepararion Fund Ground water – – 58 – – – – 58
Upgrading land ownership – – 81 – – – – 81
Medicinal Plants Projects De Doorns – – 67 – – – – 67
Work for water 3,397 5,267 5,267 433 433 878 (444) -50.6% 5,267
Add Staff at Publiv Liabraries 727 936 939 – 312 234 78 33.3% 939
CDW grant Operational Support 191 208 553 – – – – 553
Geographic Information System 6 – 39 – – – – 39
Housing Consumer Education grant 24 – 0 – – – – 0
Prov Mangement Support Grant - HR 208 – – – – – – –
Top Structures: Touwsriver – – 6 – – – – 6
Top Structures: Sunnyside Hostel 1 – – – – – – –
Top Structures: 708 Avian Park – – 222 – – – – 222
Top Structures - Additional 10/11 11,775 – – – – – – –
Top Structures - Avian Park 438 Houses 7,634 – – 963 963 – 963 #DIV/0! –
Top Structures - 331 People Housing Proj Zwel 2,564 – 2,621 – – – – 2,621
Land Rehabilitation Additional 10/11 – – – – – – – –
Dept Culture Affairs and Sport DE Doorns – – 500 – – – – 500
Dept Culture Affairs and Sport 08/09 – – 650 – – – – 650
Emergency relief - reintegration 270 – – – – – – –
Zwelethemba 242 Erven 62 – – – – – – –
EPWP Grant from Provincial 536 536 – – – – 536
District Municipality: 213 – 88 – – – – 88
Housing Consumer Education – – 6 – – – – 6
Capacity Buiilding for 20 Ward Commitees – – 34 – – – – 34
Facility Reg of Immovable Property BVM 149 – 1 – – – – 1
Clean up Campaign of Sanhills Village – – 9 – – – – 9
Waste Removal in Sandhills Village 20 – 38 – – – – 38
Emergency relief - reintegration 38 – – – – – – –
Tourism Development grant - Training 7 – – – – – – –
Other grant providers: 17 – 1 – – – – 1
Unicity Cape Town - Comm Kits – – 1 – – – – 1
Teerlapwerk 11 – – – – – – –
Lunch for eldary 1 – – – – – – –
Housing HCE Workshops 5 – 0 – – – – 0
Total Operating Transfers and Grants 5 91,741 104,558 109,238 3,437 27,590 30,725 (3,136) -10.2% 109,238
Capital Transfers and Grants
National Government: 18,390 26,982 26,982 500 15,439 9,030 6,409 71.0% 26,982
Municipal Infrastructure Grant (MIG) 18,390 25,482 25,482 – 14,939 7,530 7,409 98.4% 25,482
Integrated National Electification Program – 1,500 1,500 500 500 1,500 (1,000) -66.7% 1,500
Provincial Government: 29,436 2,035 3,129 – – – – 3,129
Add Staff at Publiv Liabraries 169 – 104 – – – – 104
De Doorns Taxi Shelter (Non Motorist) – – 37 – – – – 37
Speedcalming Springveld (Non Motorist) – – 110 – – – – 110
Upgrading Zwel Taxi Rank (Non Motorist) – – 65 – – – – 65
Proclaimed Roads 1,545 1,235 1,235 – – – – 1,235
Add De Doorns South of N1 27,717 – 778 – – – – 778
Prov Mangement Support Grant - HR 5 – – – – – – –
Alteration to Traffic Centre Building – 800 800 – – – – 800
District Municipality: 1,300 – – – – – – –
Roads - Worcester Upgrading 1,300 – – – – – – –
Other grant providers: 417 1,550 1,886 – – 1,050 (1,050) -100.0% 1,886
National Lottery Zwel sport grounds 125 1,050 1,050 – – 550 (550) -100.0% 1,050
National Lottery Zwel sport grounds – – 336 – – – – 336
United Bank - Assets to Fire Dept 100 – – – – – –
Don Workmanship and Materials 190 – – – – – –
Service Connections 2 – – – – – –
Public Connections 09/10 – – – – – – – –
Electricity Dept Mineral and Energy – – – – – – – –
Development BP to Total Garage – 500 500 – – 500 (500) -100.0% 500
Total Capital Transfers and Grants 5 49,543 30,567 31,996 500 15,439 10,080 5,359 53.2% 31,996
TOTAL RECEIPTS OF TRANSFERS & GRANTS 5 141,284 135,125 141,235 3,937 43,029 40,805 2,223 5.4% 141,235
WC025 Breede Valley - Supporting Table SC7 Monthly Budget Statement - transfers and grant expenditure - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands %
EXPENDITURE
Operating expenditure of Transfers and Grants
National Government: 55,120 58,844 58,844 4,827 9,594 25,330 (15,736) -62.1% 58,844
Local Government Equitable Share 53,333 56,804 56,804 4,734 9,467 23,290 (13,822) -59.4% 56,804
Finance Management 1,000 1,250 1,250 88 122 1,250 (1,128) -90.3% 1,250
Municipal Systems Improvement 787 790 790 5 5 790 (785) -99.3% 790
Provincial Government: 36,391 45,714 50,306 405 2,689 5,396 (2,707) -50.2% 50,306
Health subsidy 77 12 12 – – – – 12
Housing – 37,540 37,540 – – 4,100 (4,100) -100.0% 37,540
LGWSETA 444 600 600 15 23 84 (62) -73.2% 600
Learnership SETA – 500 500 – – 100 (100) -100.0% 500
Proclaimed Roads 9,010 115 115 – – – – 115
Proj Prepararion Fund Ground water – – 58 – – – – 58
Upgrading land ownership – – 81 – – – – 81
Medicinal Plants Projects De Doorns – – 67 – – – – 67
Work for water 3,397 5,267 5,267 236 477 878 (400) -45.6% 5,267
Add Staff at Publiv Liabraries 727 936 939 67 113 234 (121) -51.5% 939
CDW grant Operational Support 191 208 553 13 20 – 20 #DIV/0! 553
Geographic Information System 6 – 39 39 39 – 39 #DIV/0! 39
Housing Consumer Education grant 24 – 0 – – – – 0
Prov Mangement Support Grant - HR 208 – – – – – – –
Top Structures: Touwsriver – – 6 – – – – 6
Top Structures: Sunnyside Hostel 1 – – – – – – –
Top Structures: 708 Avian Park – – 222 – – – – 222
Top Structures - Additional 10/11 11,775 – – – – – – –
Top Structures - Avian Park 438 Houses 7,634 – – 35 2,017 – 2,017 #DIV/0! –
Top Structures - 331 People Housing Proj Zwel 2,564 – 2,621 – – – – 2,621
Land Rehabilitation Additional 10/11 – – – – – – – –
Dept Culture Affairs and Sport DE Doorns – – 500 – – – – 500
Dept Culture Affairs and Sport 08/09 – – 650 – – – – 650
Emergency relief - reintegration 270 – – – – – – –
Zwelethemba 242 Erven 62 – – – – – – –
EPWP Grant from Provincial 536 536 – – – – 536
District Municipality: 213 – 88 – – – – 88
Housing Consumer Education – – 6 – – – – 6
Capacity Buiilding for 20 Ward Commitees – – 34 – – – – 34
Facility Reg of Immovable Property BVM 149 – 1 – – – – 1
Clean up Campaign of Sanhills Village – – 9 – – – – 9
Waste Removal in Sandhills Village 20 – 38 – – – – 38
Emergency relief - reintegration 38 – – – – – – –
Tourism Development grant - Training 7 – – – – – – –
Other grant providers: 17 – 1 – – – – 1
Unicity Cape Town - Comm Kits – – 1 – – – – 1
Teerlapwerk 11 – – – – – – –
Lunch for eldary 1 – – – – – – –
Housing HCE Workshops 5 – 0 – – – – 0
Total operating expenditure of Transfers and Grants: 91,741 104,558 109,238 5,231 12,283 30,725 (18,442) -60.0% 109,238
Capital expenditure of Transfers and Grants
National Government: 18,390 26,982 26,982 9,030 3,155 9,030 (5,875) -65.1% 26,982
Municipal Infrastructure Grant (MIG) 18,390 25,482 25,482 7,530 3,142 7,530 (4,388) -58.3% 25,482
Integrated National Electification Program – 1,500 1,500 1,500 13 1,500 (1,487) -99.1% 1,500
Provincial Government: 29,436 2,035 3,129 – – – – 3,129
Add Staff at Publiv Liabraries 169 – 104 – – – – 104
De Doorns Taxi Shelter (Non Motorist) – – 37 – – – – 37
Speedcalming Springveld (Non Motorist) – – 110 – – – – 110
Upgrading Zwel Taxi Rank (Non Motorist) – – 65 – – – – 65
Proclaimed Roads 1,545 1,235 1,235 – – – – 1,235
Add De Doorns South of N1 27,717 – 778 – – – – 778
Prov Mangement Support Grant - HR 5 – – – – – – –
Alteration to Traffic Centre Building – 800 800 – – – – 800
District Municipality: 1,300 – – – – – – –
Roads - Worcester Upgrading 1,300 – – – – – – –
Other grant providers: 417 1,550 1,886 – – 1,050 (1,050) -100.0% 1,886
National Lottery Zwel sport grounds 125 1,050 1,050 – – 550 (550) -100.0% 1,050
National Lottery Zwel sport grounds – – 336 – – – – 336
United Bank - Assets to Fire Dept 100 – – – – – –
Don Workmanship and Materials 190 – – – – – –
Service Connections 2 – – – – – –
Public Connections 09/10 – – – – – – –
Electricity Dept Mineral and Energy – – – – – – – –
Development BP to Total Garage – 500 500 – – 500 (500) -100.0% 500
Total capital expenditure of Transfers and Grants 49,543 30,567 31,996 9,030 3,155 10,080 (6,925) -68.7% 31,996
TOTAL EXPENDITURE OF TRANSFERS AND GRANTS 141,284 135,125 141,235 14,261 15,438 40,805 (25,367) -62.2% 141,235
WC025 Breede Valley - Supporting Table SC8 Monthly Budget Statement - counillor and staff benefits - M02 August
2010/11 Budget Year 2011/12
Summary of Employee and Councillor remuneration Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands %
1 A B C D
Councillors (Political Office Bearers plus Other)
Salary 7,344 8,288 8,288 634 1,268 1,381 (113) -8% 8,288
Pension Contributions 763 835 835 48 96 139 (43) -31% 835
Medical Aid Contributions 150 193 193 8 16 32 (16) -51% 193
Motor vehicle allowance 1,208 1,317 1,317 177 354 220 135 61% 1,317
Cellphone allowance 509 640 640 45 90 107 640
Housing allowance 171 206 206 5 10 34 (24) -71% 206
Sub Total - Councillors 10,145 11,479 11,479 917 1,834 1,913 (79) -4% 11,479
% increase 4 13.1% 13.1% 13.1%
Senior Managers of the Municipality 3
Salary 3,121 3,289 3,289 264 527 548 (21) -4% 3,289
Pension Contributions 207 331 331 17 35 55 (20) -37% 331
Medical Aid Contributions 84 108 108 6 13 18 (5) -28% 108
Motor vehicle allowance 551 590 590 46 92 98 (6) -7% 590
Cellphone allowance 105 129 129 9 18 22 (4) -17% 129
Housing allowance – – – – – – – –
Performance Bonus 519 608 608 – – 101 (101) -100% 608
Other benefits or allowances 113 207 207 38 38 35 4 11% 207
In-kind benefits 2 – – – – – – – –
Sub Total - Senior Managers of Municipality 4,700 5,262 5,262 381 723 877 (154) -18% 5,262
% increase 4 12.0% 12.0% 12.0%
Other Municipal Staff
Basic Salaries and Wages 99,184 116,422 116,366 7,946 15,872 19,394 (3,523) -18% 116,366
Pension Contributions 16,418 19,539 19,521 1,391 2,787 3,254 (466) -14% 19,521
Medical Aid Contributions 11,805 18,945 18,922 1,035 2,075 3,154 (1,079) -34% 18,922
Motor vehicle allowance 3,971 4,735 4,735 337 673 789 (116) -15% 4,735
Cellphone allowance 349 448 448 32 64 75 (11) -14% 448
Housing allowance 972 1,248 1,248 78 148 208 (60) -29% 1,248
Overtime 10,239 5,493 5,641 762 762 940 (178) -19% 5,641
Performance Bonus – – – – – – – –
Other benefits or allowances 10,781 9,522 9,513 560 1,379 1,586 (207) -13% 9,513
In-kind benefits 2 – – – – – – – –
Sub Total - Other Municipal Staff 153,720 176,353 176,394 12,141 23,760 29,399 (5,639) -19% 176,394
% increase 4 14.7% 14.8% 14.8%
Total Parent Municipality 168,565 193,094 193,135 13,439 26,317 32,189 (5,872) -18% 193,135
14.6% 14.6% 14.6%
Unpaid salary, allowances & benefits in arrears:
TOTAL SALARY, ALLOWANCES & BENEFITS 168,565 193,094 193,135 13,439 26,317 32,189 (5,872) -18% 193,135
% increase 4 14.6% 14.6% 14.6%
TOTAL MANAGERS AND STAFF 158,420 181,615 181,657 12,522 24,483 30,276 181,657
WC025 Breede Valley - Supporting Table SC9 Monthly Budget Statement - actuals and revised targets for cash receipts - M02 August
2011/12 Medium Term Revenue &
Budget Year 2011/12
Description Ref Expenditure Framework
July August Sept October Nov Dec January Feb March April May June Budget Year Budget Year Budget Year
R thousands 1 Outcome Outcome Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget 2011/12 +1 2012/13 +2 2013/14
Cash Receipts By Source
Property rates 3,887 4,851 7,556 5,661 6,343 5,136 5,151 5,254 5,307 5,360 6,632 10,618 71,756 72,881 77,254
Property rates - penalties & collection charges 33 44 41 42 42 43 43 43 43 42 42 54 511 542 574
Service charges - electricity revenue 18,336 21,425 21,937 21,726 20,729 19,777 20,505 19,736 20,506 21,570 23,216 32,369 261,832 276,362 290,824
Service charges - water revenue 2,646 2,958 2,245 3,165 3,426 3,980 4,350 4,450 3,776 3,118 2,722 1,149 37,985 40,264 42,680
Service charges - sanitation revenue 2,311 2,914 3,480 3,589 4,262 3,547 4,189 4,485 3,938 2,786 2,705 3,792 41,998 44,518 47,189
Service charges - refuse 1,561 1,806 1,937 1,957 1,937 1,978 1,943 2,004 2,049 2,175 2,269 2,665 24,282 25,738 27,283
Service charges - other 1,799 7,243 – – – – – – – – – (9,042) – – –
Rental of facilities and equipment 834 842 925 933 917 914 927 989 985 992 998 1,156 11,412 12,097 12,823
Interest earned - external investments 211 364 345 480 690 802 780 680 820 780 650 899 7,500 7,950 8,427
Interest earned - outstanding debtors 177 190 192 176 176 162 169 163 165 165 162 149 2,046 2,169 2,299
Dividends received – – – – – – – – – – – – – – –
Fines 594 538 766 778 783 791 795 799 795 785 791 1,075 9,290 9,847 10,438
Licences and permits 239 233 269 250 194 221 216 199 196 181 183 146 2,527 2,678 2,839
Agency services – 339 340 315 360 340 305 301 301 286 281 594 3,763 3,988 4,228
Transfer receipts - operating 24,153 3,437 921 5,965 27,480 947 4,031 4,931 18,576 4,581 4,581 4,957 104,558 107,553 113,472
Other revenue 2,999 5,039 653 653 653 653 653 653 653 653 653 (6,079) 7,836 8,306 8,805
Cash Receipts by Source 59,780 52,223 41,606 45,689 67,992 39,290 44,057 44,687 58,110 43,473 45,884 44,502 587,294 614,894 649,135
–
Other Cash Flows by Source –
Transfer receipts - capital 14,939 500 3,165 3,265 2,765 3,165 599 4,000 3,528 – – (5,359) 30,567 30,983 72,688
Contributions & Contributed assets – – – – – – – – – – – – – – –
Proceeds on disposal of PPE – – – – – – – – 150 – – – 150 300 150
Short term loans – – – – – – – – – – – – – – –
Borrowing long term/refinancing – – – – – – 51,000 – – – – – 51,000 – –
Increase in consumer deposits – – – 8 – 9 – 9 – 9 – 18 53 55 58
Receipt of non-current debtors – – – – – – – – – – – – – – –
Receipt of non-current receivables – – (25) (25) (25) (25) (25) (25) (25) (25) (25) (75) (300) (200) (200)
Change in non-current investments (15,000) (10,000) 45,000 – (20,000) 10,000 5,000 – 15,000 10,000 – (30,000) 10,000 10,000 10,000
Total Cash Receipts by Source 59,719 42,723 89,746 48,937 50,732 52,439 100,631 48,671 76,763 53,457 45,859 9,086 678,764 656,032 731,831
–
Cash Payments by Type –
Employee related costs 11,961 12,522 14,926 15,190 15,199 15,255 15,298 15,235 15,305 15,305 15,311 20,150 181,657 191,121 207,270
Remuneration of councillors 917 917 957 956 957 956 957 956 957 957 956 1,035 11,479 12,167 12,897
Interest paid – – 14,432 – – – – – 16,949 – – – 31,382 32,082 29,485
Bulk purchases - Electricity 18,096 22,677 22,043 11,964 12,071 11,363 11,767 13,335 15,240 16,510 17,100 229 172,394 182,738 193,702
Bulk purchases - Water & Sewer 26 98 36 45 58 59 60 59 57 54 51 (37) 568 602 638
Other materials 407 2,416 3,800 3,850 3,830 3,850 3,850 4,015 4,025 4,250 3,920 8,462 46,675 48,806 51,205
Contracted services 13 285 101 215 250 240 210 235 245 215 210 422 2,640 2,772 2,980
Grants and subsidies paid - other municipalities – – – – – – – – – – – – – – –
Grants and subsidies paid - other 2 2 – 19 19 19 – 19 – 19 19 34 150 150 169
General expenses 10,972 23,134 9,227 10,478 8,428 9,129 9,729 9,979 10,017 9,948 9,815 (742) 120,114 116,156 122,626
Cash Payments by Type 42,394 62,050 65,522 42,717 40,812 40,871 41,871 43,833 62,796 47,258 47,382 29,551 567,057 586,594 620,974
–
Other Cash Flows/Payments by Type
Capital assets 1,567 2,475 12,609 7,884 19,583 10,621 11,238 6,514 6,841 6,587 6,786 29,487 122,191 47,160 76,804
Repayment of borrowing – – 11,267 – – – – – 12,133 – – – 23,399 24,178 28,203
Other Cash Flows/Payments – – – – – – – – – – – – – – –
Total Cash Payments by Type 43,961 64,525 89,398 50,601 60,395 51,492 53,109 50,347 81,769 53,845 54,168 59,038 712,647 657,932 725,980
–
NET INCREASE/(DECREASE) IN CASH HELD 15,758 (21,802) 348 (1,663) (9,663) 947 47,522 (1,676) (5,006) (387) (8,309) (49,953) (33,883) (1,900) 5,851
Cash/cash equivalents at the month/year beginning: 37,257 53,015 31,213 31,562 29,898 20,236 21,183 68,705 67,029 62,023 61,636 53,327 37,257 3,375 1,475
Cash/cash equivalents at the month/year end: 53,015 31,213 31,562 29,898 20,236 21,183 68,705 67,029 62,023 61,636 53,327 3,375 3,375 1,475 7,325
WC025 Breede Valley - NOT REQUIRED - municipality does not have entities or this is the parent municipality's budget - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands 1 %
Revenue By Source
Property rates –
Property rates - penalties & collection charges –
Service charges - electricity revenue –
Service charges - water revenue –
Service charges - sanitation revenue –
Service charges - refuse revenue –
Service charges - other –
Rental of facilities and equipment –
Interest earned - external investments –
Interest earned - outstanding debtors –
Dividends received –
Fines –
Licences and permits –
Agency services –
Transfers recognised - operational –
Other revenue –
Gains on disposal of PPE –
Total Revenue (excluding capital transfers and contributions) – – – – – – – –
Expenditure By Type
Employee related costs –
Remuneration of councillors –
Debt impairment –
Depreciation & asset impairment –
Finance charges –
Bulk purchases –
Other materials –
Contracted services –
Transfers and grants –
Other expenditure –
Loss on disposal of PPE –
Total Expenditure – – – – – – – –
–
Surplus/(Deficit) – – – – – – – –
Transfers recognised - capital –
Contributions recognised - capital –
Contributed assets –
Surplus/(Deficit) after capital transfers & contributions – – – – – – – –
Taxation –
Surplus/(Deficit) after taxation – – – – – – – –
WC025 Breede Valley - NOT REQUIRED - municipality does not have entities or this is the parent municipality's budget - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands %
Revenue By Municipal Entity
Insert name of municipal entity –
–
–
–
–
–
–
–
–
–
Total Operating Revenue 1 – – – – – – – –
Expenditure By Municipal Entity
Insert name of municipal entity –
–
–
–
–
–
–
–
–
–
Total Operating Expenditure 2 – – – – – – – –
Surplus/ (Deficit) for the yr/period – – – – – – – –
Capital Expenditure By Municipal Entity
Insert name of municipal entity –
–
–
–
–
–
–
–
–
Total Capital Expenditure 3 – – – – – – – –
WC025 Breede Valley - Supporting Table SC12 Monthly Budget Statement - capital expenditure trend - M02 August
2010/11 Budget Year 2011/12
Month % spend of
Audited Original Adjusted Monthly YearTD YTD YTD
YearTD actual Original
Outcome Budget Budget actual budget variance variance
Budget
R thousands %
Monthly expenditure performance trend
July 4,025 10,121 10,121 1,567 1,567 10,121 8,554 84.5% 1%
August 7,545 7,973 8,465 2,475 4,042 18,586 14,544 78.3% 4%
September 17,441 12,609 12,609 – 31,195 –
October 9,014 7,869 7,869 – 39,064 –
November 13,821 19,598 19,702 – 58,765 –
December 7,199 10,621 10,621 – 69,386 –
January 24,808 11,238 11,238 – 80,624 –
February 6,801 6,514 6,514 – 87,138 –
March 15,760 6,841 6,841 – 93,979 –
April 6,655 6,587 6,587 – 100,566 –
May 11,289 6,286 6,286 – 106,852 –
June 13,177 7,257 15,339 – 122,191 –
Total Capital expenditure 137,534 113,513 122,191 4,042
WC025 Breede Valley - Supporting Table SC13a Monthly Budget Statement - capital expenditure on new assets by asset class - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands 1 %
Capital expenditure on new assets by Asset Class/Sub-class
Infrastructure 130,156 109,597 117,121 2,195 3,762 18,066 14,305 79.2% 117,121
Infrastructure - Road transport 16,957 1,694 2,684 – – – – 2,684
Roads, Pavements & Bridges 11,450 1,694 2,684 – – – – 2,684
Storm water 5,507 – – – – – – –
Infrastructure - Electricity 14,939 47,720 53,763 81 205 6,069 5,864 96.6% 53,763
Generation – – – – – – – –
Transmission & Reticulation 14,899 47,460 53,458 56 178 6,069 5,891 97.1% 53,458
Street Lighting 40 261 305 24 27 – (27) #DIV/0! 305
Infrastructure - Water 6,489 13,104 13,596 397 406 586 180 30.7% 13,596
Dams & Reservoirs – – – – – – – –
Water purification – – – – – – – –
Reticulation 6,489 13,104 13,596 397 406 586 180 30.7% 13,596
Infrastructure - Sanitation 91,772 47,078 47,078 1,717 3,151 11,411 8,261 72.4% 47,078
Reticulation 7,641 225 225 8 9 225 216 96.1% 225
Sewerage purification 84,131 46,854 46,854 1,709 3,142 11,187 8,045 71.9% 46,854
Infrastructure - Other – – – 0 – – – –
Waste Management – – – – – – – –
Transportation – – – – – – – –
Gas – – – – – – – –
Other – – – 0 – – – –
Community 543 200 284 – – – – 284
Parks & gardens – – – – – – – –
Sportsfields & stadia – – – – – – – –
Swimming pools – – – – – – – –
Community halls – – – – – – – –
Libraries – – – – – – – –
Recreational facilities 125 – – – – – – –
Fire, safety & emergency 110 – – – – – – –
Security and policing 308 200 284 – – – – 284
Buses – – – – – – – –
Clinics – – – – – – – –
Museums & Art Galleries – – – – – – – –
Cemeteries – – – – – – – –
Social rental housing – – – – – – – –
Other – – – – – – – –
Heritage assets – – – – – – – –
Buildings – – – – – – – –
Other – – – – – – – –
–
Investment properties – – – – – – – –
Housing development – – – – – – – –
Other – – – – – – – –
Other assets 6,603 3,671 4,741 280 280 520 240 46.1% 4,741
General vehicles 2,745 930 930 280 280 – (280) #DIV/0! 930
Specialised vehicles 759 – – – – – – –
Plant & equipment 523 1,274 1,430 – 0 320 320 99.9% 1,430
Computers - hardware/equipment 382 – – – – – – –
Furniture and other office equipment 467 267 307 – – – – 307
Abattoirs – – – – – – – –
Markets – – – – – – – –
Civic Land and Buildings – – – – – – – –
Other Buildings 1,722 800 1,318 – – – – 1,318
Other Land – – – – – – – –
Surplus Assets - (Investment or Inventory) – – – – – – – –
Other 5 400 756 – – 200 200 100.0% 756
Agricultural assets – – – – – – – –
List sub-class – – – – – – – –
– – – – – – – –
Biological assets – – – – – – – –
List sub-class – – – – – – – –
– – – – – – – –
Intangibles 142 45 45 – – – – 45
Computers - software & programming 142 45 45 – – – – 45
Other – – – – – – – –
Total Capital Expenditure on new assets 1 137,444 113,513 122,191 2,475 4,042 18,586 14,544 78.3% 122,191
Specialised vehicles – – – – – – – –
Refuse – – – – – – – –
Fire – – – – – – – –
Conservancy – – – – – – – –
Ambulances – – – – – – – –
References
1. Total Capital Expenditure on new assets (SC13a) plus Total Capital Expenditure on renewal of existing assets (SC13b) must reconcile to total capital expenditure in Table C5
check balance -0 - - - - - -
WC025 Breede Valley - Supporting Table SC13b Monthly Budget Statement - capital expenditure on renewal of existing assets by asset class - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands 1 %
Capital expenditure on renewal of existing assets by Asset Class/Sub-class
Infrastructure 47 – – – – – – –
Infrastructure - Road transport – – – – – – – –
Roads, Pavements & Bridges – – – – – – – –
Storm water – – – – – – – –
Infrastructure - Electricity 47 – – – – – – –
Generation – – – – – – – –
Transmission & Reticulation 47 – – – – – – –
Street Lighting – – – – – – – –
Infrastructure - Water – – – – – – – –
Dams & Reservoirs – – – – – – – –
Water purification – – – – – – – –
Reticulation – – – – – – – –
Infrastructure - Sanitation – – – – – – – –
Reticulation – – – – – – – –
Sewerage purification – – – – – – – –
Infrastructure - Other – – – – – – – –
Waste Management – – – – – – – –
Transportation – – – – – – – –
Gas – – – – – – – –
Other – – – – – – – –
Community – – – – – – – –
Parks & gardens – – – – – – – –
Sportsfields & stadia – – – – – – – –
Swimming pools – – – – – – – –
Community halls – – – – – – – –
Libraries – – – – – – – –
Recreational facilities – – – – – – – –
Fire, safety & emergency – – – – – – – –
Security and policing – – – – – – – –
Buses – – – – – – – –
Clinics – – – – – – – –
Museums & Art Galleries – – – – – – – –
Cemeteries – – – – – – – –
Social rental housing – – – – – – – –
Other – – – – – – – –
Heritage assets – – – – – – – –
Buildings – – – – – – – –
Other – – – – – – – –
–
Investment properties – – – – – – – –
Housing development – – – – – – – –
Other – – – – – – – –
Other assets 43 – – – – – – –
General vehicles – – – – – – – –
Specialised vehicles – – – – – – – –
Plant & equipment 43 – – – – – – –
Computers - hardware/equipment – – – – – – – –
Furniture and other office equipment – – – – – – – –
Abattoirs – – – – – – – –
Markets – – – – – – – –
Civic Land and Buildings – – – – – – – –
Other Buildings – – – – – – – –
Other Land – – – – – – – –
Surplus Assets - (Investment or Inventory) – – – – – – – –
Other – – – – – – – –
Agricultural assets – – – – – – – –
List sub-class – – – – – – – –
– – – – – – – –
Biological assets – – – – – – – –
List sub-class – – – – – – – –
– – – – – – – –
Intangibles – – – – – – – –
Computers - software & programming – – – – – – – –
Other – – – – – – – –
Total Capital Expenditure on renewal of existing assets 1 90 – – – – – – –
Specialised vehicles – – – – – – – –
Refuse – – – – – – – –
Fire – – – – – – – –
Conservancy – – – – – – – –
Ambulances – – – – – – – –
References
1. Total Capital Expenditure on new assets (SC13a) plus Total Capital Expenditure on renewal of existing assets (SC13b) must reconcile to total capital expenditure in Table C5
check balance -0 - - - - - -
WC025 Breede Valley - Supporting Table SC13c Monthly Budget Statement - expenditure on repairs and maintenance by asset class - M02 August
2010/11 Budget Year 2011/12
Description Ref Audited Original Adjusted Monthly YearTD YTD YTD Full Year
YearTD actual
Outcome Budget Budget actual budget variance variance Forecast
R thousands 1 %
Repairs and maintenance expenditure by Asset Class/Sub-class
Infrastructure 25,341 28,337 28,389 1,335 1,619 4,732 3,112 65.8% 28,389
Infrastructure - Road transport 7,491 8,558 8,558 275 346 1,426 1,080 75.8% 8,558
Roads, Pavements & Bridges 6,497 7,560 7,560 275 345 1,260 915 72.6% 7,560
Storm water 994 998 998 – 1 166 166 99.6% 998
Infrastructure - Electricity 135 155 155 0 0 26 26 99.3% 155
Generation – – – – – – – –
Transmission & Reticulation – – – – – – – –
Street Lighting 135 155 155 0 0 26 26 99.3% 155
Infrastructure - Water 12,458 14,770 14,770 493 636 2,462 1,825 74.1% 14,770
Dams & Reservoirs – – – – – – – –
Water purification 3,009 4,414 4,414 163 206 736 529 71.9% 4,414
Reticulation 9,449 10,356 10,356 329 430 1,726 1,296 75.1% 10,356
Infrastructure - Sanitation 4,440 3,906 3,906 516 576 651 75 11.5% 3,906
Reticulation 3,414 3,316 3,316 511 571 553 (18) -3.3% 3,316
Sewerage purification 1,026 590 590 5 5 98 93 94.7% 590
Infrastructure - Other 817 949 1,001 51 60 167 106 63.8% 1,001
Waste Management 13 90 142 – – 24 24 100.0% 142
Transportation – – – – – – – –
Gas – – – – – – – –
Other 804 859 859 51 60 143 83 57.8% 859
Community – – – – – – – –
Parks & gardens – – – – – – – –
Sportsfields & stadia – – – – – – – –
Swimming pools – – – – – – – –
Community halls – – – – – – – –
Libraries – – – – – – – –
Recreational facilities – – – – – – – –
Fire, safety & emergency – – – – – – – –
Security and policing – – – – – – – –
Buses – – – – – – – –
Clinics – – – – – – – –
Museums & Art Galleries – – – – – – – –
Cemeteries – – – – – – – –
Social rental housing – – – – – – – –
Other – – – – – – – –
Heritage assets – – – – – – – –
Buildings – – – – – – – –
Other – – – – – – – –
–
Investment properties – – – – – – – –
Housing development – – – – – – – –
Other – – – – – – – –
Other assets 17,397 18,284 18,285 1,081 1,204 3,048 1,844 60.5% 18,285
General vehicles 5,057 4,845 4,845 305 333 807 474 58.8% 4,845
Specialised vehicles – – – – – – – –
Plant & equipment 4,436 4,831 4,834 377 428 806 378 46.9% 4,834
Computers - hardware/equipment – – – – – – – –
Furniture and other office equipment 3 30 30 – – 5 5 100.0% 30
Abattoirs – – – – – – – –
Markets – – – – – – – –
Civic Land and Buildings – – – – – – – –
Other Buildings 7,484 8,349 8,351 399 443 1,392 949 68.2% 8,351
Other Land – – – – – – – –
Surplus Assets - (Investment or Inventory) – – – – – – – –
Other 417 230 225 – – 38 38 100.0% 225
Agricultural assets – – – – – – – –
List sub-class – – – – – – – –
– – – – – – – –
Biological assets – – – – – – – –
List sub-class – – – – – – – –
– – – – – – – –
Intangibles – – – – – – – –
Computers - software & programming – – – – – – – –
Other – – – – – – – –
Total Repairs and Maintenance Expenditure 42,739 46,622 46,674 2,416 2,823 7,779 4,956 63.7% 46,674
Specialised vehicles – – – – – – – –
Refuse – – – – – – – –
Fire – – – – – – – –
Conservancy – – – – – – – –
Ambulances – – – – – – – –
References
Chart C1 2011/12 Capital Expenditure Monthly Trend: actual v target
Chart C1 2011/12 Capital Expenditure Monthly Trend: actual v target
Month 2010/11 Original Budget Adjusted Budget Monthly actual
Jul 4,025 10,121 10,121 1,567 25,000
Aug 7,545 7,973 8,465 2,475
Sep 17,441 12,609 12,609 –
Oct 9,014 7,869 7,869 – 20,000
Nov 13,821 19,598 19,702 –
Dec 7,199 10,621 10,621 –
Jan 24,808 11,238 11,238 – 15,000
R'000
Feb 6,801 6,514 6,514 –
Mar 15,760 6,841 6,841 –
Apr 6,655 6,587 6,587 – 10,000
May 11,289 6,286 6,286 –
Jun 13,177 7,257 15,339 –
5,000
–
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
2010/11 4,025 7,545 17,441 9,014 13,821 7,199 24,808 6,801 15,760 6,655 11,289 13,177
Original Budget 10,121 7,973 12,609 7,869 19,598 10,621 11,238 6,514 6,841 6,587 6,286 7,257
Adjusted Budget 10,121 8,465 12,609 7,869 19,702 10,621 11,238 6,514 6,841 6,587 6,286 15,339
Monthly actual 1,567 2,475 – – – – – – – – – –
Chart C2 2011/12 Capital Expenditure: YTD actual v YTD target Chart C2 2011/12 Capital Expenditure: YTD actual v YTD target
Month YearTD actual YearTD budget
Jul 1,567 10,121 140,000
Aug 4,042 18,586
Sep 31,195
120,000
Oct 39,064
Nov 58,765
Dec 69,386 100,000
Jan 80,624
Feb 87,138
80,000
Mar 93,979
R'000
Apr 100,566
May 106,852 60,000
Jun 122,191
40,000
20,000
–
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
YearTD actual 1,567 4,042 – – – – – – – – – –
YearTD budget 10,121 18,586 31,195 39,064 58,765 69,386 80,624 87,138 93,979 100,566 106,852 122,191
Chart C3 Aged Consumer Debtors Analysis
Chart C3 Aged Consumer Debtors Analysis
0-30 Days 31-60 Days 61-90 Days 91-120 Days 121-150 Dys 151-180 Dys 181 Dys-1 Yr Over 1Yr
80,000
Budget Year 2011/12 74,379 3,370 1,610 1,311 1,103 1,081 6,552 17,129
2010/11 70,660 3,202 1,529 1,245 1,048 1,027 6,224 16,273
70,000
60,000
50,000
R'000
40,000
30,000
20,000
10,000
–
0-30 Days 31-60 61-90 91-120 121-150 151-180 181 Dys-1 Over 1Yr
Days Days Days Dys Dys Yr
Budget Year 2011/12 74,379 3,370 1,610 1,311 1,103 1,081 6,552 17,129
2010/11 70,660 3,202 1,529 1,245 1,048 1,027 6,224 16,273
Chart C4 Consumer Debtors (total by Debtor Customer Category)
Chart C4 Consumer Debtors (total by Debtor Customer Category)
2010/11 Budget Year 2011/12
Government 2,030 2,093
Business 12,087 12,461 80,000
Households 73,868 76,153
Other 15,353 15,827 70,000
60,000
50,000
R'000
40,000
30,000
20,000
10,000
–
Government Business Households Other
2010/11 2,030 12,087 73,868 15,353
Budget Year 2011/12 2,093 12,461 76,153 15,827
Chart C5 Aged Creditors Analysis
Chart C5 Aged Creditors Analysis
Pensions /
Retirement Auditor 35,000
Bulk Electricity Bulk Water PAYE deductions VAT (output less input) deductions Loan repayments Trade Creditors General Other
2010/11 – – – – – – – – –
30,000
Budget Year 2011/12 22,962 60 – – 7,928 – 26,338 – 33,488
25,000
20,000
R'000
15,000
10,000
5,000
–
Bulk Bulk PAYE VAT Pensions Loan Trade Auditor Other
Electricit Water deductio (output / repayme Creditors General
y ns less Retireme nts
input) nt
deductio
ns
2010/11 – – – – – – – – –
Budget Year 2011/12 22,962 60 – – 7,928 – 26,338 – 33,488