Page 1 of32 12/11/2008
Municipality of Trent Hills STATEMENT OF CASH FLOWS YTD From 1/1/2008 To 11/30/2008
2007 BUDGET
2007 Year End
2008 BUDGET
2008 To Nov 30/08
2009 Draft Budget
Comments or Change
Page 2 of32 12/11/2008
Municipality of Trent Hills Water and Sewer Budget Report Campbellford Water System Campbellford Water - Revenue 1787170
01-430-1-00000-6062050 01-430-1-00000-6062100 01-430-1-00000-6062150 01-430-1-00000-6062200 01-430-1-00000-6062250 01-430-1-00000-6062300 01-430-1-00000-6082300 01-430-1-00000-6091050 01-430-1-00000-6094200 01-430-1-00000-7001000
Water - C'ford Admin - Charges - Residential Water - C'ford Admin - Charges - General Service Water - C'ford Admin - Charges - Bulk Sales Water - C'ford Admin - Connects/Disconnects Water - C'ford Admin - Contracted Services Water - C'ford Admin - Hydrant Rentals Water - C'ford Admin - Late Payment Charges Water - C'ford Admin - Invest Income Own Funds Water - C'ford Admin - Miscellaneous Water - C'ford Admin - Transfer From Reserves Total Campbellford Water - Revenue Campbellford Water - Expenditure Total Campbellford Water - Expenditures 01-430-1-00000-8011050 Water - C'ford Admin - Regular Wages 01-430-1-00000-8011075 Water - C'ford Admin - Heath & Safety Training 01-430-1-00000-8011100 Water - C'ford Admin - Overtime Wages 01-430-1-00000-8011150 Water - C'ford Admin - Stand By / On Call 01-430-1-00000-8011200 Water - C'ford Admin - Vacation Wages 01-430-1-00000-8011250 Water - C'ford Admin - Sick Wages 01-430-1-00000-8015000 Water - C'ford Admin - Employee Benefits 01-430-1-00000-8015300 Water - C'ford Admin - Health, Dental, Life etc. 01-430-1-00000-8030200 Water - C'ford Admin - Granulars 01-430-1-00000-8030600 Water - C'ford Admin - Hot Mix 01-430-1-00000-8030700 Water - C'ford Admin - Chemicals 01-430-1-00000-8030750 Water - C'ford Admin - Parts 01-430-1-00000-8030950 Water - C'ford Admin - Signs 01-430-1-00000-8031100 Water - C;ford Admin - Fuel 01-430-1-00000-8031300 Water - C'ford Admin - Mileage 01-430-1-00000-8031350 Water - C'ford Admin - Training & Courses 01-430-1-00000-8031400 Water - C'ford Admin - Equipment Purchases 01-430-1-00000-8031450 Water - C'ford Admin - Clothing Expense 01-430-1-00000-8032050 Water - C'ford Admin - Office Supplies 01-430-1-00000-8032200 Water - C'ford Admin - Caretaking Supplies 01-430-1-00000-8032250 Water - C'ford Admin - Postage 01-430-1-00000-8032350 Water - C'ford Admin - Health & Safety 01-430-1-00000-8032400 Water - C'ford Admin - General Materials 01-430-1-00000-8032450 Water - C'ford Admin - Advertising & Promotion 01-430-1-00000-8032650 Water - C'ford Admin - Dues & Subscriptions 01-430-1-00000-8032700 Water - C'ford Admin - Computer Expenses 01-430-1-00000-8032800 Water - C'ford Admin - Licences 01-430-1-00000-8033150 Water - C'ford Admin - Lab Supplies 01-430-1-00000-8041050 Water - C'ford Admin - Contracted Services 01-430-1-00000-8041150 Water - C'ford Admin - Hydro 01-430-1-00000-8041200 Water - C'ford Admin - Water 01-430-1-00000-8041250 Water - C'ford Admin - Sewer 01-430-1-00000-8041300 Water - C'ford Admin - Heat 01-430-1-00000-8041350 Water - C'ford Admin - Courier 01-430-1-00000-8041400 Water - C'ford Admin - Telephone 01-430-1-00000-8041500 Water - C'ford Admin - Insurance 01-430-1-00000-8041600 Water - C'ford Admin - Accounting & Audit 01-430-1-00000-8041650 Water - C'ford Admin - Service Contracts 01-430-1-00000-8041750 Water - C'ford Admin - Equipment Repairs 01-430-1-00000-8041950 Water - C'ford Admin - Lab Testing Fees 01-430-1-00000-8045050 Water - C'ford Admin - Engineering Services 01-430-1-00000-8050100 Water - C'ford Admin - Land Rental 01-430-1-00000-8050200 Water - C'ford Admin - Equipment Rental 01-430-1-00000-8050225 Water - C'ford Admin - Equipment Rental - Int 01-430-1-00000-8051100 Water - C'ford Admin - Interest on Late Payments 01-430-1-00000-8051150 Water - C'ford Admin - Interest & Bank Charges 01-430-1-00000-8051650 Water - C'ford Admin - Bad Debts Total C. Water - Administration 01-430-1-75200-8011050 Water - C - Billing & Collecting - Full time Wages 01-430-1-75200-8011100 Water - C - Billing & Collecting - Full time - OT 01-430-1-75200-8015000 Water - C - Billing & Collecting - Employee Benefi 01-430-1-75200-8030750 Water - C - Billing & Collecting - Parts 01-430-1-75200-8032050 Water - C - Billing & Collecting - Supplies - Offi 01-430-1-75200-8032200 Water - C - Billing & Collecting - Supplies - Care 01-430-1-75200-8032250 Water - C - Billing & Collecting - Postage 01-430-1-75200-8032350 Water - C - Billing & Collecting - Health & Safety
($534,240) -548,349 -13,969 -1,577 -5,399 -36,000 -1,251 -1,929 -2,933 0 -1,145,647
($501,571.02) -548,448.33 -24,044.67 -1,957.00 -10,791.08 -36,000.00 -18,884.34 0 -5,765.00 376,090.58 -771,371
($501,183.00) -548,124.00 -15,045.00 -1,500.00 -5,000.00 -36,000.00 -15,000.00 0 -2,500.00 0 -1,124,352
(445,569.83) (510,918.20) (10,391.47) (2,332.00) (3,097.60) (15,054.21) (4,405.00) (991,768.31)
(501,183.00) (548,124.00) (15,045.00) (1,500.00) (5,000.00) (36,000.00) (15,000.00) (2,500.00) -1,124,352
0 $48,700 0 0 0 19,100 4,700 52,325 0 0 0 0 0 0 0 0 2,500 0 2,600 500 0 0 0 0 0 0 0 0 0 500 0 0 0 0 0 0 25,000 0 0 0 0 0 0 0 0 0 0 0 155,925 $40,100 0 11,546 0 0 0 3,400 0
0 $119,698.06 0 13,959.62 6,018.19 27,288.70 4,936.79 51,454.76 -812.69 1,598.80 5,550.00 102,951.10 24,898.50 38.79 7,306.47 2,634.83 3,525.62 13,827.08 2,951.55 676.57 20 3,484.00 1,829.42 2,747.11 66.67 498.05 1,431.56 355.25 3,125.52 20,443.74 69,285.79 23 577.26 48 647.04 4,850.13 29,774.06 778 4,410.13 11,966.26 8,213.00 1,961.60 220 1,021.76 425 324.72 0 5,061.22 562,091 $0.00 0 0 0 0 0 0 0
0 $54,567.00 0 0 0 0 0 59,284.00 0 0 0 0 0 0 6,000.00 2,800.00 5,500.00 0 2,700.00 500 0 0 25 500 100 500 0 350 0 0 150 0 0 0 100 1,000.00 28,000.00 0 3,800.00 2,500.00 0 0 250 0 0 350 0 4,000.00 172,976 $19,026.00 0 0 100 300 20 350 100
39,956.08 5,661.04 403.01 10,700.61 4,380.39 18,508.64 892.87 97.14 2,416.66 54.00 1,568.77 358.16 149.62 91.34 229.76 289.56 106.53 37.32 807.19 28,752.15 3,619.05 220.00 192.29 20.94 119,513.12 20,149.73 42.60 5,657.92 -
0 58,755 51,118 3,500 2,700 500
500 100 500 350
150
100 1,000 29,309 3,800 250 350 50 4,000 157,032 19,645 -
01-430-1-75200-8032400 01-430-1-75200-8032700 01-430-1-75200-8041150 01-430-1-75200-8041200 01-430-1-75200-8041250 01-430-1-75200-8041300 01-430-1-75200-8041400 01-430-1-75200-8041500 01-430-1-75200-8041600 01-430-1-75200-8045150 01-430-1-75300-8031100 01-430-1-75350-8011050 01-430-1-75350-8011100 01-430-1-75350-8015000 01-430-1-75350-8030700 01-430-1-75350-8030750 01-430-1-75350-8030950 01-430-1-75350-8031100 01-430-1-75350-8031400 01-430-1-75350-8032350 01-430-1-75350-8032400 01-430-1-75350-8032700 01-430-1-75350-8033150 01-430-1-75350-8041050 01-430-1-75350-8041150 01-430-1-75350-8041250 01-430-1-75350-8041350 01-430-1-75350-8041400 01-430-1-75350-8041650 01-430-1-75350-8041750 01-430-1-75350-8041950 01-430-1-75350-8050200 01-430-1-75350-8051100 01-430-1-75400-8011050 01-430-1-75400-8011100 01-430-1-75400-8015000 01-430-1-75400-8030700 01-430-1-75400-8030750 01-430-1-75400-8032400 01-430-1-75400-8041050 01-430-1-75400-8041150 01-430-1-75400-8041750 01-430-1-75450-8011050 01-430-1-75450-8011100 01-430-1-75450-8015000 01-430-1-75450-8030200 01-430-1-75450-8030600 01-430-1-75450-8030750 01-430-1-75450-8031400 01-430-1-75450-8032400 01-430-1-75450-8032800 01-430-1-75450-8041050 01-430-1-75450-8041150 01-430-1-75450-8045050 01-430-1-75450-8050200 01-430-1-75500-6073125 01-430-1-75500-8011050 01-430-1-75500-8011100 01-430-1-75500-8015000 01-430-1-75500-8030200 01-430-1-75500-8030600 01-430-1-75500-8030750 01-430-1-75500-8032400 01-430-1-75500-8041050 01-430-1-75500-8041750 01-430-1-75500-8050200 01-430-1-75550-8011050 01-430-1-75550-8011100 01-430-1-75550-8015000 01-430-1-75550-8032400
Water - C - Billing & Collecting - General Materia Water - C - Billing & Collecting - Computer Expens Water - C - Billing & Collecting - Hydro Water - C - Billing & Collecting - Water Water - C - Billing & Collecting - Sewer Water - C - Billing & Collecting - Heat Water - C - Billing & Collecting - Telephone Water - C - Billing & Collecting - Insurance Water - C - Billing & Collecting - Accounting/Audi Water - C - Billing & Collecting - Consulting Serv Total C. Water - Billing & Collecting Water - C - Truck Maintenance - Fuel Total C. Water - Truck Maintenance Water - C - Filtration Plant - Full time Wages Water - C - Filtration Plant - Full time - OT Water - C - Filtration Plant - Employee Benefits Water - C - Filtration Plant - Chemicals Water - C - Filtration Plant - Parts Water - C - Filtration Plant - Signs Water - C - Filtration Plant - Fuel Water - C - Filtration Plant - Equipment Purchases Water - C - Filtration Plant - Health & Safety Water - C - Filtration Plant - General Materials Water - C - Filtration Plant - Computer Expense Water - C - Filtration Plant - Lab Supplies Water - C - Filtration Plant - Contracted Services Water - C - Filtration Plant - Hydro Water - C - Filtration Plant - Sewer Water - C - Filtration Plant - Courier Water - C - Filtration Plant - Telephone Water - C - Filtration Plant - Service Contracts Water - C - Filtration Plant - Equipment Repairs Water - C - Filtration Plant - Lab testing Water - C - Filtration Plant - Equipment Rental Water - C - Filtration Plant - Interest on Late Pa Total C. Water - Filtration Plant Water - C - Water Tower - Full time Wages Water - C - Water Tower - Full time - OT Water - C - Water Tower - Employee Benefits Water - C - Water Tower - Chemicals Water - C - Water Tower - Parts Water - C - Water Tower - General Materials Water - C - Water Tower - Contracted Services Water - C - Water Tower - Hydro Water - C - Water Tower - Equipment Repairs Total C. Water - Water Tower Water - C - Watermain Maint - Full time Wages Water - C - Watermain Maint - Full time - OT Water - C - Watermain Maint - Employee Benefits Water - C - Watermain Maint - Granulars Water - C - Watermain Maint - Hot Mix Water - C - Watermain Maint - Parts Water - C - Watermain Maint - Equipment Purchases Water - C - Watermain Maint - General Materials Water - C - Watermain Maint - Licences Water - C - Watermain Maint - Contracte Water - C - Watermain Maint - Hydro Water - C - Watermain Maint - Engineering Services Water - C - Watermain Maint - Equipment Rental Total C. Water - Watermain Maintenance Water - C - Water Service Maint - Equip Rent - Int Water - C - Water Service Maint - Full time Wages Water - C - Water Service Maint - Full time - OT Water - C - Water Service Maint - Employee Benefit Water - C - Water Service Maint - Granulars Water - C - Water Service Maint - Hot Mix Water - C - Water Service Maint - Parts Water - C - Water Service Maint - General Material Water - C - Water Service Maint - Contracted Servi Water - C - Water Service Maint - Equipment Repair Water - C - Water Service Maint - Equipment Rental Total C. Water - Water Service Maintenance Water - C - Locates - Full time Wages Water - C - Locates - Full time - OT Water - C - Locates - Employee Benefits Water - C - Locates - General Materials
0 0 0 0 0 0 0 2,400 0 0 57,446 $7,254 7,254 $36,740 7,500 8,000 100,000 0 0 0 3,500 0 0 0 0 7,500 60,000 0 0 0 0 7,500 5,900 0 0 236,640 $9,371 0 1,200 3,500 0 0 0 4,000 1,000 19,071 $20,803 1,500 2,200 0 0 1,000 0 0 0 0 0 0 3,000 28,503 $0 8,109 0 1,500 0 0 2,200 0 1,000 0 2,800 15,609 $2,343 0 500 0
0 0 0 0 0 0 0 0 0 0 0 $0.00 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0
100 450 150 25 20 50 250 2,800.00 800 0 24,541 $11,000.00 11,000 $54,221.00 0 0 100,000.00 7,500.00 0 2,000.00 7,500.00 0 1,000.00 1,000.00 3,000.00 7,500.00 60,000.00 600 275 4,000.00 750 7,500.00 12,000.00 0 20 268,866 $9,363.00 0 0 3,800.00 0 250 1,000.00 4,000.00 1,000.00 19,413 $11,577.00 0 0 500 1,500.00 2,000.00 250 500 50 1,000.00 0 500 4,000.00 21,877 $0.00 18,108.00 0 0 1,500.00 5,500.00 4,000.00 350 500 300 1,500.00 31,758 $6,323.00 0 0 200
2,685.64 479.85 29,015.74 33,286.93 9,071.14 11,486.96 65,537.27 9,010.13 24.30 1,405.98 6,115.93 116.61 1,151.35 1,271.55 2,314.21 4,053.83 45,657.90 456.70 331.15 3,691.81 600.00 7,080.94 10,420.06 237.05 78.20 213,400.00 7,882.33 467.32 2,241.42 3,090.14 3,286.76 1,677.71 3,411.69 1,640.81 23,698.18 11,261.59 319.55 3,145.91 6,625.00 993.82 35.99 170.15 382.92 103.19 23,038.12 1,050.00 12,518.15 974.83 3,702.53 1,363.00 5,195.00 12,871.97 362.72 3,661.17 90.35 1,284.88 43,074.60 2,640.87 125.31 768.33 89.69
2,738 22,383 10,000 10,000 55,979 100,000 7,500 1,500 5,000 1,000 1,500 3,000 5,000 60,000 600 300 4,000 750 7,500 10,000 250 100 263,979 9,605 3,000 3,000 250 1,500 4,000 1,500 22,855 11,940 7,500 2,500 250 500 2,000 24,690 18,633 1,500 5,000 5,000 300 4,000 1,500 35,933 6,459 200
Page 3 of32 12/11/2008
01-430-1-75550-8041750
Water - C - Locates - Equipment Repairs Total C. Water - Locates 01-430-1-75600-8011050 Water - C - Disconnect/Reconnect - Full time Wages 01-430-1-75600-8015000 Water - C - Disconnect/Reconnect - Employee Benefi Total C. Water - Disconnect/Reconnect 01-430-1-75750-8011050 Water - C - Hydrant Maint - Full time Wages 01-430-1-75750-8011100 Water - C - Hydrant Maint - Full time - OT 01-430-1-75750-8015000 Water - C - Hydrant Maint - Employee Benefits 01-430-1-75750-8030750 Water - C - Hydrant Maint - Parts 01-430-1-75750-8032400 Water - C - Hydrant Maint - General Materials 01-430-1-75750-8041050 Water - C - Hydrant Maint - Contracted Services Total C. Water - Hydrant Maintenance 01-430-1-75800-8011050 Water - C - Water Meter Maint - Full time Wages 01-430-1-75800-8015000 Water - C - Water Meter Maint - Employee Benefits 01-430-1-75800-8030750 Water - C - Water Meter Maint - Parts 01-430-1-75800-8031400 Water - C - Water Meter Maint - Equipment Purchase 01-430-1-75800-8032400 Water - C - Water Meter Maint - General Materials 01-430-1-75800-8041050 Water - C - Water Meter Maint - Contracted Service Total C. Water - Water Meter Maintenance 01-430-1-75850-8011050 Water - C - Health/Safety/Training - Full time Wag 01-430-1-75850-8015000 Water - C - Health/Safety/Training - Employee Bene Total C. Water - Health/Safety/Training 01-430-1-75900-8011150 Water - C - On Call - Full time - On Call 01-430-1-75900-8015000 Water - C - On Call - Employee Benefits 01-430-1-75900-8031450 Water - C - On Call - Clothing Expense Total C. Water - On Call 01-430-1-75950-8011050 Water - C - Misc Other Mun - Full time Wages 01-430-1-75950-8011100 Water - C - Misc Other Mun - Full time - OT 01-430-1-75950-8015000 Water - C - Misc Other Mun - Employee Benefits Total C. Water - Misc. Other Mun. Total Campbellford Water - Expenditures Campbellford Water Capital Expenditures 02-430-1-00000-7090050 Don't use - Water - C - LTD Proceeds 02-430-1-00000-8011050 Don't Use - Water - C'ford Capital - Regular Wages 02-430-1-00000-8015000 Dont' Use - Water - C'ford Capital - Employee Bene 02-430-1-00000-8041050 Don't Use - Water - C'ford Capital - Contract Serv 02-430-1-00000-8041350 Don't Use - Water - C'ford Capital - Courier 02-430-1-00000-8042050 Don't Use - Water - C'ford Capital - Const Cont 02-430-1-00000-8045050 Don't Use - Water - C'ford Capital - Eng Serv 02-430-1-00000-8051050 Don't Use -OSIFA LTD - Interest on Short Term Debt 02-430-1-00085-8011050 Don't Use -Water-C''ford-Dist'n -Full Time-Regular 02-430-1-00085-8011100 Don't Use - Water-C'ford-Dist'n -Full Time-OT 02-430-1-00085-8015000 Don't Use - Water-C'ford-Dist'n -Emp Ben 02-430-1-00085-8032450 Don't Use - Water-C'ford Dist'n - Advertrising 02-430-1-00085-8032800 Don't Use - Water-C'ford-Dist'n -Licences 02-430-1-00085-8041050 Don't Use - Water-C'ford-Dist'n -Contracted Serv 02-430-1-00085-8042050 Don't Use - Water-C'ford-Dist'n -Const'n Cont 02-430-1-00085-8045050 Don't Use - Water-C'ford-Dist'n -Engineering Serv 02-430-1-00100-8011050 Don't Use -Water-C'ford-Rd Reconst'n-Full Time-Reg 02-430-1-00100-8011100 Don't Use - Water-C'ford-Rd Reconst'n-Full Time-OT 02-430-1-00100-8015000 Don't Use - Water-C'ford-Rd Reconst'n-Emp Ben 02-430-1-00100-8042050 Don't Use - Water-C'ford-Rd Reconst'n-Const'n Cont 02-430-1-00100-8045050 Don't Use - Water-C'ford-Rd Reconst'n-Eng Serv 02-430-1-00201-8041700 BUILDING IMPROVEMENTS - Facility Repairs 02-430-1-00351-8011050 SCADA UPGRADES - Full time Wages 02-430-1-00501-8032400 WATER METERS - General Materials 02-430-1-00502-8011050 FIRE HYDRANT PAINTING - Full time Wages 02-430-1-00502-8032300 GAC REPLACEMENT - Miscellaneous 02-430-1-00601-8032300 CAPITAL LOAN PAYMENTS - Miscellaneous 02-430-1-00601-8051150 CAPITAL LOAN PAYMENT - Interest & Bank Charges 02-430-1-00601-8071000 CAPITAL LOAN PAYMENT - Principal Payments - Loans 02-430-1-00650-8032300 Don't Use - Water - Treat Plant UV Trans. Meter 02-430-1-00652-8011050 HIGHLIFT PUMP REPLACEMENT - Full time Wages 02-430-1-00653-8032300 WATER PLANT THM OPTIMIZATION STUDY 02-430-1-00654-8032300 WATER PLANT -SPILL CONTAINER 02-430-1-00655-8032300 WATER PLANT - CLARIFYER UPGRADES 02-430-1-00751-8011050 WATER TOWER UPGRADES - Full time Wages 02-430-1-00751-8041050 WATER TOWER UPGRADES - Contracted Services 02-430-1-00752-8032300 WATER TOWER INSPECTIONS 02-430-1-00851-8011050 MARKET STREET - -Full time Wages 02-430-1-00851-8015000 MARKET STREET - Employee Benefits 02-430-1-00851-8042050 MARKET STREET - Construction Contracts 02-430-1-00851-8045050 MARKET STREET - Engineering Expense 02-430-1-00852-8011050 IRETON STREET - Full time Wages 02-430-1-00852-8015000 IRETON STREET - Employee Benefits 02-430-1-00853-8011050 FRONT STREET - Full time Wages
0 2,843 $880 0 $880 $4,078 0 1,000 0 0 0 5,078 $3,000 0 1,000 0 0 1,000 5,000 $16,338 0 16,338 $4,500 1,096 0 5,596 $2,500 0 0 2,500 558,683
0 0 $0.00 0 $0 $0.00 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 $0.00 0 0 $0.00 0 0 0 $0.00 0 0 0 562,091
200 6,723 $1,591.00 0 $1,591 $7,833.00 0 0 750 200 150 8,933 $4,613.00 0 7,500.00 100 100 1,000.00 13,313 $4,173.00 0 4,173 $7,579.00 0 150 7,729 $23,467.00 0 0 23,467 616,360
$0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20,000 50,000 3,000 0 0 0 0 5,000 0 10,000 5,000 15,000 0 0 10,000 81,400 0 0 120,750 0 0 0
($600,000.00) 1,623.72 405.99 6,263.41 6.35 -0.01 545.93 25,193.00 5,168.96 619.16 1,447.20 258.72 325.83 4,862.97 521,225.62 57,271.06 636.85 14.39 162.84 118,968.12 8,242.13 0 0 0 0 0 9,070.86 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
$0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10,000.00 110,000.00 50,000.00 7,000.00 50,000.00 47,171.00 0 0 0 15,000.00 10,000.00 0 15,000.00 100,000.00 0 0 113,124.00 0 0 0 0 0 0
3,624.20 872.54 240.62 1,113.16 3,020.76 237.84 901.67 135.00 51.33 4,346.60 1,503.82 399.05 672.31 64.65 68.31 2,708.14 114.92 32.18 147.10 4,728.54 1,291.91 6,020.45 11.63 93.04 26.17 130.84 469,830.25 54,517.19 19,373.92 12,865.20 4824.41 0 555.72 158.96 24913.73 3394.79 50.52 12.63 50.52
200 6,859 1,629 $1,629 8,050 2,000 200 7,500 17,750 4,733 2,500 100 500 7,833 4,317 4,317 7,891 7,891 23,925 23,925 607,076 47,122 -
Page 4 of32 12/11/2008
02-430-1-00853-8015000 02-430-1-00853-8045050 02-430-1-00854-8011050 02-430-1-00854-8015000 02-430-1-00854-8045050 02-430-1-00855-8045050 02-430-1-00858-8011050 02-430-1-00858-8015000 02-430-1-00859-8011050 02-430-1-00859-8032800 02-430-1-00859-8045050 02-430-1-00898-8032300 02-430-1-00899-8011050 02-430-1-01010-8045050 02-430-1-01251-8011050 02-430-1-01251-8045050 02-430-1-01254-8032800 02-430-1-01502-7001000 02-430-1-01503-7001000
Budgeted in 2007
FRONT STREET - Employee Benefits FRONT STREET - Engineering Expense RIVER STREET - Full time Wages RIVER STREET - Employee Benefits RIVER STREET - Engineering Expense QUEEN STREET - Engineering Expense FRONT ST (RANNEY TO ARENA) - Full time Wages FRONT ST (RANNEY TO ARENA) - Employee Benefits UPPER GARRY ST - Full time Wages UPPER GARRY - Licences UPPER GARRY ST - Engineering Services WATER DIST SYSTEM DESIGN - Miscellaneous MISCELLANEOUS CONSTRUCTION - Full time Wages DOXSEE STREET - Engineering Expense ASSET MANAGEMENT - Full time Wages ASSET MANAGEMENT - Engineering Services QMS STUDY - Licences TRANSFER FROM RESERVES - Operations -Trs from Rese TRANSFER FROM RESERVES - Capital - Trs from Reserv Canrobert St. - Bridge St to Garry St Isabella St. - Oliver st to Cromwell St Kent St. - Church St. to dead end Oliver St. - Isabella to Major St. Water Tower Painting & Repairs - Trans from Reserve Water Tower Painting & Repairs STUDY High Lift Pump Repairs Clarifier Repairs & Painting Water Tower Painting & Repairs
0 159,180 0 0 71,400 95,760 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 25,000.00 0 125,000.00 0 0 53,000.00 719,204.00 0 32,500.00 0 27,500.00 -1,346,499.00 -163,000.00
14.15 5243.94 50.52 14.15 750.25 345.83 623.08 184.57 0 1200 569.67 0 0 1046.48 0 3997.63 0 0 0
-
15,000 10,000
646,490 162,313 0 134,757.86 72,122 59,526 -46,967 -507,992 (387,180.20) -445,154 ============== ============== ============= ============== =============
Page 5 of32 12/11/2008
Warkworth Water System Warkworth Water - Revenue 01-430-3-00000-6062050 Water - W'worth Admin - Charges - Residential 01-430-3-00000-6062100 Water - W'worth Admin - Charges - General Service 01-430-3-00000-6062150 Water - W'worth Admin - Charges - Bulk Sales 01-430-3-00000-6062200 Water - W'worth Admin - Connects/Disconnects 01-430-3-00000-6062300 Water - W'worth Admin - Hydrant Rentals 01-430-3-00000-6064150 Water - W'worth Admin - Local Improvements 01-430-3-00000-6082300 Water - W'worth Admin - Late Payment Charges 01-430-3-00000-6094200 Water - W'worth Admin - Miscellaneous 01-430-3-00000-7001000 Water - W'worth Admin -Transfer From Reserves 01-430-3-00000-7090050 Water - W'worth Admin - Proceeds From Loans Total Warkworth Water - Revenue Warkworth Water - Expenditures Total Warkworth Water - Expenditures 01-430-3-00000-8011050 Water - W'worth Admin - Regular Wages 01-430-3-00000-8011075 Water - W'worth Admin - Health & Safety Training 01-430-3-00000-8011100 Water - W'worth Admin - Overtime Wages 01-430-3-00000-8011150 Water - W'worth Admin - Stand By / On Call 01-430-3-00000-8011200 Water - W'worth Admin - Vacation Wages 01-430-3-00000-8011250 Water - W'worth Admin - Sick Wages 01-430-3-00000-8015000 Water - W'worth Admin - Employee Benefits 01-430-3-00000-8030200 Water - W'worth Admin - Granulars 01-430-3-00000-8030700 Water - W'worth Admin - Chemicals 01-430-3-00000-8030750 Water - W'worth Admin - Parts 01-430-3-00000-8030950 Water - W'worth Admin - Signs 01-430-3-00000-8031100 Water - W'worth Admin - Fuel 01-430-3-00000-8031300 Water - W'worth Admin - Mileage 01-430-3-00000-8031350 Water - W'worth Admin - Training & Courses 01-430-3-00000-8031400 Water - W'worth Admin - Equipment Purchases 01-430-3-00000-8031450 Water - W'worth Admin - Clothing Expense 01-430-3-00000-8032050 Water - W'worth Admin - Office Supplies 01-430-3-00000-8032200 Water - W'worth Admin - Caretaking Supplies 01-430-3-00000-8032250 Water - W'worth Admin - Postage 01-430-3-00000-8032350 Water - W'worth Admin - Health & Safety 01-430-3-00000-8032400 Water - W'worth Admin - General Materials 01-430-3-00000-8032450 Water - W'worth Admin - Advertising & Promotion 01-430-3-00000-8032650 Water - W'worth Admin - Dues & Subscriptions 01-430-3-00000-8032700 Water - W'worth Admin - Computer Expenses 01-430-3-00000-8032800 Water - W'worth Admin - Licences 01-430-3-00000-8033150 Water - W'worth Admin - Lab Suppies 01-430-3-00000-8041050 Water - W'worth Admin - Contracted Services 01-430-3-00000-8041150 Water - W'worth Admin - Hydro 01-430-3-00000-8041200 Water - W'worth Admin - Water 01-430-3-00000-8041250 Water - W'worth Admin - Sewer 01-430-3-00000-8041300 Water - W'worth Admin - Heat 01-430-3-00000-8041350 Water - W'worth Admin - Courier 01-430-3-00000-8041400 Water - W'worth Admin - Telephone 01-430-3-00000-8041500 Water - W'worth Admin - Insurance 01-430-3-00000-8041600 Water - W'worth Admin - Accounting & Audit 01-430-3-00000-8041650 Water - W'worth Admin - Service Contracts 01-430-3-00000-8041750 Water - W'worth Admin - Equipment Repairs 01-430-3-00000-8041950 Water - W'worth Admin - Lab Testing Fees 01-430-3-00000-8042150 Water - W'worth Admin - Computer Maintenance 01-430-3-00000-8045050 Water - W'worth Admin - Engineering Services 01-430-3-00000-8050100 Water - W'worth Admin - Land Rental 01-430-3-00000-8051100 Water - W'worth Admin - Interest on Late Payments 01-430-3-00000-8051750 Water - W'worth Admin - Interest on RBC LTD 01-430-3-00000-8071200 Water - W'worth Admin - Loan - principal paid on R Total W/W Water - Administration 01-430-3-75200-8011050 Water - W - Billing & Collecting - Full time Wages 01-430-3-75200-8015000 Water - W - Billing & Collecting - Employee Benfit 01-430-3-75200-8030750 Water - W - Billing & Collecting - Parts 01-430-3-75200-8032050 Water - W - Billing & Collecting - Supplies - Offi 01-430-3-75200-8032200 Water - W - Billing & Collecting - Supplies - Care 01-430-3-75200-8032250 Water - W - Billing & Collecting - Postage 01-430-3-75200-8032350 Water - W - Billing & Collecting - Health & Safety 01-430-3-75200-8032400 Water - W - Billing & Collecting - General Materia 01-430-3-75200-8032700 Water - W - Billing & Collecting - Computer Expens 01-430-3-75200-8041150 Water - W - Billing & Collecting - -Hydro 01-430-3-75200-8041200 Water - W - Billing & Collecting - Water 01-430-3-75200-8041250 Water - W - Billing & Collecting - Sewer 01-430-3-75200-8041300 Water - W - Billing & Collecting - Heat 01-430-3-75200-8041400 Water - W - Billing & Collecting - Telephone 01-430-3-75200-8041500 Water - W - Billing & Collecting - Insurance 01-430-3-75200-8041600 Water - W - Billing & Collecting - Accounting/Audi
Page 6 of32 12/11/2008 ($159,480) -71,437 0 -190 -7,000 -749 0 -205 0 0 -239,061
($143,696.57) -79,380.64 0 -419 -7,000.00 0 -3,071.56 -470.18 -8,237.52 0 -242,275
($143,524.00) -79,368.00 0 -300 -7,000.00 0 0 -250 0 0 -230,442
-118357.32 -65850.47 -138.6 -84 0 0 -2540.51 -132.35 0 -103451 (290,554.25)
(143,524.00) (79,368.00) (300.00)
0 $27,170 0 0 0 6,900 1,650 15,800 0 0 0 0 0 0 2,000 0 0 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4,000 0 1,500 0 0 0 0 0 0 0 0 59,520 $7,420 1,000 0 0 0 600 0 0 0 0 0 0 0 0 400 0
0 $46,047.78 0 11,655.48 2,197.66 8,155.30 1,661.36 17,331.39 184.98 16,156.53 959.23 38.8 2,738.69 2,322.47 1,782.59 3,424.59 133.9 166.4 3 597 831.5 1,206.35 66.67 285.89 1,820.80 49 2,085.99 9,189.45 18,409.40 4 2 8 94.59 2,342.36 4,790.57 133 2,127.64 9,233.09 5,563.80 1,122.15 471.69 102 19.44 22,536.77 13,782.38 211,836 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 $23,323.00 0 0 0 0 0 24,917.00 0 0 0 0 2,000.00 2,500.00 3,000.00 0 0 150 0 0 25 400 100 300 500 50 0 0 0 0 0 0 0 1,000.00 4,500.00 0 1,600.00 1,000.00 0 0 0 100 250 0 0 65,715 $8,330.00 0 100 100 20 600 100 50 100 25 20 20 20 50 500 150
14538.88 1839.2 176.82 0 3403.13 1741.75 6430.42 0 0 0 0 0 326 2301.64 0 64.78 358.16 0 0 0 2.79 91.34 229.77 0 283.34 0 0 0 0 0 807.22 4581.39 0 1523.81 0 0 0 0 100 0 0 0 38,800.44 1479.11 401.1 0 0 0 0 0 0 0 0 0 0 0 0 473.94 0
25,081 21,346 -
(7,000.00) (250.00) -230,442
2,500 2,000 200 400 100 300 500 200 1,000 4,670 1,600 100 59,997 8,600 483 -
01-430-3-75200-8045150 01-430-3-75300-8031100 01-430-3-75350-8011050 01-430-3-75350-8011100 01-430-3-75350-8015000 01-430-3-75350-8030700 01-430-3-75350-8030750 01-430-3-75350-8030950 01-430-3-75350-8031100 01-430-3-75350-8031400 01-430-3-75350-8032350 01-430-3-75350-8032400 01-430-3-75350-8032700 01-430-3-75350-8033150 01-430-3-75350-8041050 01-430-3-75350-8041150 01-430-3-75350-8041350 01-430-3-75350-8041400 01-430-3-75350-8041650 01-430-3-75350-8041750 01-430-3-75350-8041950 01-430-3-75350-8051100 01-430-3-75400-8011050 01-430-3-75400-8011100 01-430-3-75400-8015000 01-430-3-75400-8041150 01-430-3-75400-8041400 01-430-3-75400-8050100 01-430-3-75450-8011050 01-430-3-75450-8011100 01-430-3-75450-8015000 01-430-3-75450-8030200 01-430-3-75450-8030750 01-430-3-75450-8031400 01-430-3-75450-8032400 01-430-3-75450-8045050 01-430-3-75450-8050200 01-430-3-75500-8011050 01-430-3-75500-8011100 01-430-3-75500-8015000 01-430-3-75500-8030200 01-430-3-75500-8030750 01-430-3-75500-8032400 01-430-3-75500-8041750 01-430-3-75500-8050200 01-430-3-75550-8011050 01-430-3-75550-8015000 01-430-3-75550-8032400 01-430-3-75550-8041750 01-430-3-75600-8011050 01-430-3-75600-8011100 01-430-3-75600-8015000 01-430-3-75750-8011050 01-430-3-75750-8011100 01-430-3-75750-8015000 NEW 01-430-3-75800-8011050 01-430-3-75800-8015000 01-430-3-75800-8031400 01-430-3-75800-8032400 01-430-3-75800-8041050 01-430-3-75850-8011050 01-430-3-75850-8015000 01-430-3-75900-8011150 01-430-3-75900-8015000
Water - W - Billing & Collecting - Consulting Serv Total W/W Water - Billing & Collecting Water - W - Truck Maintenance - Fuel Total W/W Water - Truck Maintenance Water - W - Filtration Plant - Full time Wages Water - W - Filtration Plant - Full time - OT Water - W - Filtration Plant - Employee Benefits Water - W - Filtration Plant - Chemicals Water - W - Filtration Plant - Parts Water - W - Filtration Plant - Signs Water - W - Filtration Plant - Fuel Water - W - Filtration Plant - Equipment Purchases Water - W - Filtration Plant - Health & Safety Water - W - Filtration Plant - General Materials Water - W - Filtration Plant - Computer Expenses Water - W - Filtration Plant - Lab Supplies Water - W - Filtration Plant - Contracted Services Water - W - Filtration Plant - Hydro Water - W - Filtration Plant - Courier Water - W - Filtration Plant - Telephone Water - W - Filtration Plant - Service Contracts Water - W - Filtration Plant - Equipment Repairs Water - W - Filtration Plant - Lab Testing Fees Water - W - Filtration Plant - Interest on Late P Total W/W Water - Filtration Plant Water - W - Water Tower - Full time Wages Water - W - Water Tower - Full time - OT Water - W - Water Tower - Employee Benefits Water - W - Water Tower - Hydro Water - W - Water Tower - Telephone Water - W - Water Tower - Land Rental Total W/W Water - Water Tower Water - W - Watermain Maint - Full time Wages Water - W - Watermain Maint - Full time - OT Water - W - Watermain Maint - Employee Benefits Water - W - Watermain Maint - Granulars Water - W - Watermain Maint - Parts Water - W - Watermain Maint - Equipment Purchases Water - W - Watermain Maint - General Materials Water - W'worth- Watermain Maint- Engineering Serv Water - W - Watermain Maint - Equipment Rental Total W/W Water - Watermain Maintenance Water - W - Water Service Maint - Full time Wages Water - W - Water Service Maint - Full time - OT Water - W - Water Service Maint - Employee Benefit Water - W - Water Service Maint - Granulars Water - W - Water Service Maint - Parts Water - W - Water Service Maint - General Material Water - W - Water Service Maint - Equipment Repair Water - W - Water Service Maint - Equipment Rental Total W/W Water - Water Service Maintenance Water - W - Locates - Full time Wages Water - W - Locates - Employee Benefits Water - W - Locates - General Materials Water - W - Locates - Equipment Repairs Total W/W Water - Locates Water - W - Disconnect/Reconnect - Full time Wages Water - W - Disconnect/Reconnect - Full time - OT Water - W - Disconnect/Reconnect - Employee Benefi Total W/W Water - Disconnect/Reconnect Water - W - Hydrant Maint - Full time Wages Water - W - Hydrant Maint - Full time - OT Water - W - Hydrant Maint - Employee Benefits Water - W - Hydrant Maint - Parts Total W/W Water - Hydrant Maintenance Water - W - Water Meter Maint - Full time Wages Water - W - Water Meter Maint - Employee Benefits Water - W - Water Meter Maint - Equipment Purchase Water - W - Water Meter Maint - General Materials Water - W - Water Meter Maint - Contracted Service Total W/W Water - Water Meter Maintenace Water - W - Health/Safety/Training - Full time Wag Water - W - Health/Safety/Training - Employee Bene Total W/W Water - Health/Safety/Training Water - W - On Call - Full time - On Call Water - W - On Call - Employee Benefits
0 9,420 $6,184 6,184 $22,500 8,500 7,500 17,000 0 0 1,000 2,500 0 0 0 2,000 3,500 25,800 0 0 0 7,500 7,200 0 105,000 $795 0 100 0 0 0 $895 $4,300 500 1,000 0 200 0 0 0 0 6,000 $2,531 0 500 0 250 0 0 500 3,781 $300 100 0 0 $400 $273 0 0 $273 $628 600 300 0 1,528 $535 0 0 0 0 $535 $5,766 0 5,766 $1,684 400
0 0 $0.00 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 $0 $0.00 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 $0.00 0 0 0 $0 $0.00 0 0 $0 $0.00 0 0 0 0 $0.00 0 0 0 0 $0 $0.00 0 0 $0.00 0
0 10,185 $4,000.00 4,000 $22,396.00 0 0 17,000.00 500 50 1,000.00 2,500.00 750 200 0 2,000.00 3,500.00 20,000.00 0 1,200.00 700 7,500.00 7,000.00 20 86,316 $3,876.00 0 0 50 350 2 $4,278 $4,796.00 0 0 250 100 250 400 0 250 6,046 $7,502.00 0 0 200 500 150 300 500 9,152 $2,620.00 0 200 200 $3,020 $663.00 0 0 $663 $3,284.00 0 0 0 3,284 $1,928.00 0 100 100 250 $2,378 $1,726.00 0 1,726 $3,130.00 0
959.7 3,313.85 20204.77 7468.45 7513.42 11781.31 990.65 0 835.82 6640.78 116.6 211.66 1115.47 85.44 5170.65 15507.91 17.06 660.77 396 10575.25 6996 0 96,288.01 377.51 381.33 212.12 0 305.56 1 1,277.52 3166.89 294.78 939.09 0 0 35.99 148.56 103.19 0 4,688.50 797.32 194.08 265.39 0 0 0 90.35 0 1,347.14 630.46 176.08 89.69 0 896.23 275.2 50.52 93.45 419.17 903.39 0 252.32 0 1,155.71 644 168.02 0 25.47 457.16 1,294.65 52.95 14.84 67.79 1729.58 473
9,083 3,500 3,500 23,122 17,000 0 1,000 5,000 200 1,200 1,000 4,000 20,000 1,200 700 10,500 7,000 91,923 3,976 50 350 2 $4,378 4,946 250 100 250 400 250 6,196 7,720 200 500 150 300 500 9,370 2,677 100 100 $2,877 679 0 $679 3,375 2,500 5,875 1,978 100 500 $2,578 1,786 1,786 3,259 -
Page 7 of32 12/11/2008
Total W/W Water - On Call 01-430-3-75950-8011050 Water - W - Other Mun - Full time Wages Total W/W Water - Other Munic. Total Warkworth Water - Expenditures Warkworth Water Capital Expenditures 02-430-3-00000-8011050 Don't Use - Water - W'worth - Regular Wages 02-430-3-00000-8015000 Don't Use - Water - W'worth - Employee Benefits 02-430-3-00000-8041350 Don't Use - Water - W'worth Capital - Courier 02-430-3-00000-8045050 Don't Use - Water - W'worth Capital - Eng Serv 02-430-3-00000-8051050 Don't Use -OSIFA LTD - Interest on Short Term Debt 02-430-3-00085-8011050 Don't Use - Water-W'worth-Dist'n -Full Time-Reg 02-430-3-00085-8011100 Don't Use - Water-W'worth-Dist'n -Full Time-OT 02-430-3-00085-8015000 Don't Use - Water-W'worth-Dist'n System-Emp Ben 02-430-3-00085-8030200 Don't Use - Water-W'worth-Dist'n System-Granulars 02-430-3-00085-8032400 Don't Use -Water-W'worth-Dist'n System-General Mat 02-430-3-00085-8032800 Don't Use - Water-W'worth-Dist'n System-Licences 02-430-3-00085-8041050 Don't Use - Water-W'worth-Dist'n System-Cont Serv 02-430-3-00085-8041350 Don't Use - Water-W'worth-Dist'n System - Courier 02-430-3-00085-8042050 Don't Use -Water-W'worth-Dist'n System-Const'n Con 02-430-3-00085-8045050 Don't Use - Water-W'worth-Dist'n System-Eng Serv 02-430-3-00085-8050150 Don't Use - Water-W'worth-Dist'n System-Mach Ren 02-430-3-00201-6041050 BUILDING IMPROVEMENTS -Ont Cond Grant - OSTAR 02-430-3-00201-8032300 BUILDING IMPROVEMENTS - Miscellaneous 02-430-3-00251-8032300 FURNITURE/FIXTURES - Miscellaneous 02-430-3-00352-8032300 COMPUTER SOFTWARE - Miscellaneous 02-430-3-00401-8031400 GAC REPLACEMENT - Equipment Purchase 02-430-3-00601-8032300 CAPITAL LOAN PAYMENT - Miscellaneous 02-430-3-00601-8051050 CAPITAL LOAN REPAYMENT - Interest on STD 02-430-3-00601-8051150 CAPITAL LOAN PAYMENT - Interest & Bank Charges 02-430-3-00601-8071000 CAPITAL LOAN PAYMENT - Principal Payments - Loans 02-430-3-00751-8011050 WATER TOWER - Full time Wages 02-430-3-00751-8015000 WATER TOWER - Employee Benefits 02-430-3-00751-8032300 WATER TOWER - Miscellaneous 02-430-3-00751-8042050 WATER TOWER - Construction Contract 02-430-3-00852-8011050 OLD HASTINGS ROAD - Full time Wages 02-430-3-00852-8015000 OLD HASTINGS ROAD - Employee Benefits 02-430-3-00852-8042050 OLD HASTINGS ROAD - Construction Contracts 02-430-3-00852-8042200 OLD HASTINGS ROAD - Other Contracted Services 02-430-3-00852-8045050 OLD HASTINGS ROAD - Engineering Expense 02-430-3-00853-8011050 PERCY STREET - Full time Wages 02-430-3-00853-8015000 PERCY STREET - Employee Benefits 02-430-3-00853-8042050 PERCY STREET - Construction Contracts 02-430-3-00853-8042200 PERCY STREET - Other Contracted Services 02-430-3-00853-8045050 PERCY STREET - Engineering services 02-430-3-00899-7090050 MISC CONSTRUCTION - Proceeds from Loans 02-430-3-00899-8011050 MISC CONSTRUCTION - Full time Wages 02-430-3-01251-8032300 THM OPTIMIZATION - Miscellaneous 02-430-3-01251-8045050 ASSET MANAGEMENT - Engineering Services 02-430-3-01252-8011050 ASSET MANAGEMENT - Full time Wages 02-430-3-01252-8045050 ASSET MANAGEMENT - Engineering Services 02-430-3-01254-8032800 QMS STUDY - Licences 02-430-3-01502-7001000 TRANSFER FROM RESERVES - Trs from Reserves 02-430-3-01503-6031100 OSTAR - FED TOP UP - Federal Grant Water Distribution Needs Study SCADA Upgrades/Computor Software Stairs to Clarifier and filters Total Warkworth Water Capital Expenditures TOTAL WARKWORTH WATER SYSTEM
2,084 $0 $0 201,386
0 $0.00 $0 211,836
3,130 $8,533.00 $8,533 208,426
2,202.58 151,751.59
$0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 49,970 0 0 0 0 0 0 0 264,000 0 0 0 0 86,900 0 0 0 0 0 0 0 0 0 0 0 0 0
$650.91 162.77 6.09 1,253.35 5,221.64 4,492.53 931.94 1,356.21 36.59 550 912.03 220.15 18.53 325,273.23 43,676.70 966 0 0 0 0 0 8,195.54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
$0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -103,451.00 5,000.00 10,000.00 5,000.00 15,000.00 54,280.64 0 0 0 0 0 15,000.00 0 888 0 0 0 0 1,739.00 0 0 0 0 -382,661.00 380,034.00 10,000.00 0 10,000.00 0 10,000.00 -80,000.00 0
2006.92 23291.76 20581.42 202.08 57.92 0 3047.62 1397.72 381.27 1984.89 73.75 7790.07 151.56 42.45 1984.89 73.75 21.56 1,452.24 421.45 (49,940.56)
400,870 363,195
393,924 363,484
-49,170 -71,186
15,022.76 (123,779.90)
3,259 8,700 $8,700 210,201 113,418 0 0 5,000 118,418 98,177
Page 8 of32 12/11/2008
Hastings Water System Hastings Water - Revenue 01-430-4-00000-6062050 01-430-4-00000-6062100 01-430-4-00000-6062150 01-430-4-00000-6062200 01-430-4-00000-6062250 01-430-4-00000-6062300 01-430-4-00000-6064150 01-430-4-00000-6082300 01-430-4-00000-6094200 01-430-4-00000-7001000
Water - Hastings Admin - Charges - Residential Water - Hastings Admin - Charges - General Service Water - Hastings Admin - Charges - Bulk Sales Water - Hastings Admin - Connects/Disconnects Water - Hastings Admin - Contracted Services Water - Hastings Admin - Hydrant Rentals Water - Hastings Admin - Local Improvements Water - Hastings Admin - Late Payment Charges Water - Hastings Admin - Miscellaneous Water - Hastings Admin - Transfer From Reserves Total Hastings Water - Revenue Hastings Water - Expenditures Total Hastings Water Expenditures 01-430-4-00000-8011050 Water - Hastings Admin - Regular Wages 01-430-4-00000-8011075 Water - Hastings Admin - Health & Safety Training 01-430-4-00000-8011100 Water - Hastings Admin - Overtime Wages 01-430-4-00000-8011150 Water - Hastings Admin - Stand By / On Call 01-430-4-00000-8011200 Water - Hastings Admin - Vacation Wages 01-430-4-00000-8011250 Water - Hastings Admin - Sick Wages 01-430-4-00000-8015000 Water - Hastings Admin - Employee Benefits 01-430-4-00000-8030200 Water - Hastings Admin - Granulars 01-430-4-00000-8030600 Water - Hastings Admin - Hot Mix 01-430-4-00000-8030700 Water - Hastings Admin - Chemicals 01-430-4-00000-8030750 Water - Hastings Admin - Parts 01-430-4-00000-8030800 Water - Hastings Admin - Paint 01-430-4-00000-8030900 Water - Hastings Admin - Concrete 01-430-4-00000-8030950 Water - Hastings Admin - Signs 01-430-4-00000-8031100 Water - Hastings Admin - Fuel 01-430-4-00000-8031300 Water - Hastings Admin - Mileage 01-430-4-00000-8031350 Water - Hastings Admin - Training & Courses 01-430-4-00000-8031400 Water - Hastings Admin - Equipment Purchases 01-430-4-00000-8031450 Water - Hastngs Admin - Clothing Expense 01-430-4-00000-8032050 Water - Hastings Admin - Office Supplies 01-430-4-00000-8032200 Water - Hastings Admin - Caretaking Supplies 01-430-4-00000-8032250 Water - Hastings Admin - Postage 01-430-4-00000-8032350 Water - Hastings Admin - Health & Safety 01-430-4-00000-8032400 Water - Hastings Admin - General Materials 01-430-4-00000-8032450 Water - Hastings Admin - Advertising & Promotion 01-430-4-00000-8032650 Water - Hastings Admin - Dues & Subscriptions 01-430-4-00000-8032700 Water - Hastings Admin - Computer Expenses 01-430-4-00000-8032800 Water - Hastings Admin - Licences 01-430-4-00000-8033150 Water - Hastings Admin - Lab Supplies 01-430-4-00000-8041050 Water - Hastings Admin - Contracted Services 01-430-4-00000-8041150 Water - Hastings Admin - Hydro 01-430-4-00000-8041200 Water - Hastings Admin - Water 01-430-4-00000-8041250 Water - Hastings Admin - Sewer 01-430-4-00000-8041300 Water - Hastings Admin - Heat 01-430-4-00000-8041350 Water - Hastings Admin - Courier 01-430-4-00000-8041400 Water - Hastings Admin - Telephone 01-430-4-00000-8041500 Water - Hastings Admin - Insurance 01-430-4-00000-8041550 Water - Hastings Admin - Legal 01-430-4-00000-8041600 Water - Hastings Admin - Accounting & Audit 01-430-4-00000-8041650 Water - Hastings Admin - Service Contracts 01-430-4-00000-8041750 Water - Hastings Admin - Equipment Repairs 01-430-4-00000-8041950 Water - Hastings Admin - Lab Testing Fees 01-430-4-00000-8042150 Water - Hastings Admin - Computer Maintenance 01-430-4-00000-8045050 Water - Hastings Admin - Engineering Services 01-430-4-00000-8050100 Water - Hastings Admin - Land Rental 01-430-4-00000-8050200 Water - Hastings Admin - Equipment Rental 01-430-4-00000-8051100 Water - Hastings Admin - Interest on Late Payment 01-430-4-00000-8051750 Water - Hastings Admin - Interest on RBC LTD 01-430-4-00000-8071100 Water - Hastings Admin - Water loan - principal 01-430-4-00000-8071200 Water - Hastings Admin - Loan - principal pd RBC Total H. Water - Administration 01-430-4-75200-8011050 Water - H - Billing & Collecting - Full time Wages 01-430-4-75200-8011100 Water - H - Billing & Collecting - Full time - OT 01-430-4-75200-8015000 Water - H - Billing & Collecting - Employee Benefi 01-430-4-75200-8030750 Water - H - Billing & Collecting - Parts 01-430-4-75200-8032050 Water - H - Billing & Collection - Supplies - Offi 01-430-4-75200-8032200 Water - H - Billing & Collecting - Supplies - Care 01-430-4-75200-8032250 Water - H - Billing & Collecting - Postage 01-430-4-75200-8032350 Water - H - Billing & Collecting - Health & Safety 01-430-4-75200-8032400 Water - H - Billing & Collecting - General Materia 01-430-4-75200-8032700 Water - H - Billing & Collecting - Computer Expens
Page 9 of32 12/11/2008 ($305,386) -120,300 -10,764 -1,054 -1,431 -12,400 -8,481 -1,098 -363 0 -461,277
($247,391.01) -131,731.77 -12,859.61 -1,077.00 -43,699.07 -9,000.00 0 -6,757.73 -1,169.09 -37,459.51 -491,145
($255,392.00) -130,360.00 -12,860.00 -1,077.00 -1,500.00 -12,400.00 -8,481.00 -1,500.00 -400 0 -423,970
-245336.8 -126275.18 -5709.33 -1261 -168.35 0 0 -6661.34 -916 0 (386,328.00)
(255,392.00) (130,360.00) (12,860.00) (1,077.00) (1,500.00) (12,400.00) (8,481.00) (1,500.00) (400.00) -423,970
0 $30,500 0 0 0 8,700 2,000 25,050 0 0 0 0 0 0 0 0 0 0 0 0 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 15,600 0 0 1,850 0 0 0 0 0 0 0 0 0 0 84,200 $11,230 0 3,200 0 0 0 1,150 0 0 0
0 $61,002.37 0 10,845.00 2,745.43 10,034.12 2,015.24 21,533.45 1,678.73 2,985.00 21,642.07 9,301.20 97.59 1,350.00 38.79 3,102.26 2,401.57 1,823.17 229.95 133.91 204.33 7 1,194.00 77.18 1,781.12 66.66 285.89 2,734.06 1,096.00 2,994.02 12,987.99 4,080.26 1,432.40 833.84 13,481.08 93.42 1,880.76 17,659.52 490.11 267 2,465.06 7,210.84 6,284.16 2,722.20 439.43 80 6,789.13 19.43 47,378.44 3,032.68 28,974.33 322,002 $0.00 0 0 0 0 0 0 0 0 0
0 $24,361.00 0 0 0 0 0 26,948.00 0 0 0 0 0 0 0 2,500.00 2,500.00 3,000.00 0 0 100 0 0 0 500 0 300 0 500 0 0 0 0 0 0 50 1,000.00 18,000.00 0 0 2,000.00 1,000.00 0 0 0 100 0 25 0 0 0 82,884 $6,932.00 0 0 100 100 20 1,250.00 100 100 150
18223.29 2197.29 257.76 0 4090.02 2014.97 8030.28 0 0 0 0 0 0 0 0 97.14 2301.67 0 369.83 358.13 0 0 0 2.77 91.34 229.75 0 283.33 0 619.63 0 237.4 -237.4 0 0 807.13 17756.82 0 0 1904.76 0 0 0 0 80 0 0 0 0 0 59,715.91 2927.86 79.04 829.67 0 0 0 0 0 0 0
0 26,327 23,968 2,500 3,000 500 200 200 100 300 500 1,000 18,101 2,000 100 78,796 6,726 -
01-430-4-75200-8041150 01-430-4-75200-8041200 01-430-4-75200-8041250 01-430-4-75200-8041300 01-430-4-75200-8041400 01-430-4-75200-8041500 01-430-4-75200-8041600 01-430-4-75200-8045150 01-430-4-75300-8031100 01-430-4-75350-8011050 01-430-4-75350-8011100 01-430-4-75350-8015000 01-430-4-75350-8030700 01-430-4-75350-8030750 01-430-4-75350-8031100 01-430-4-75350-8031400 01-430-4-75350-8032350 01-430-4-75350-8032400 01-430-4-75350-8032700 01-430-4-75350-8033150 01-430-4-75350-8041050 01-430-4-75350-8041150 01-430-4-75350-8041200 01-430-4-75350-8041250 01-430-4-75350-8041300 01-430-4-75350-8041350 01-430-4-75350-8041400 01-430-4-75350-8041650 01-430-4-75350-8041750 01-430-4-75350-8041950 01-430-4-75400-8011050 01-430-4-75400-8011100 01-430-4-75400-8015000 01-430-4-75400-8041150 01-430-4-75450-8011050 01-430-4-75450-8011100 01-430-4-75450-8015000 01-430-4-75450-8030200 01-430-4-75450-8030600 01-430-4-75450-8030750 01-430-4-75450-8031400 01-430-4-75450-8032400 01-430-4-75450-8032800 01-430-4-75450-8045050 01-430-4-75450-8050200 01-430-4-75500-8011050 01-430-4-75500-8011100 01-430-4-75500-8015000 01-430-4-75500-8030200 01-430-4-75500-8030600 01-430-4-75500-8030750 01-430-4-75500-8030900 01-430-4-75500-8032400 01-430-4-75500-8041750 01-430-4-75500-8050200 01-430-4-75550-8011050 01-430-4-75550-8011100 01-430-4-75550-8015000 01-430-4-75550-8032400 01-430-4-75550-8041750 01-430-4-75600-8011050 01-430-4-75600-8011100 01-430-4-75600-8015000 01-430-4-75750-8011050 01-430-4-75750-8015000 01-430-4-75750-8030750 01-430-4-75800-8011050
Water - H - Billing & Collecting - Hydro Water - H - Billing & Collecting - Water Water - H - Billing & Collecting - Sewer Water - H - Billing & Collecting - Heat Water - H - Billing & Collecting - Telephone Water - H - Billing & Collecting - Insurance Water - H - Billing & Collecting - Accounting/Audi Water - H - Billing & Collecting - Consulting Serv Total H. Water - Billing & Collecting Water - H - Truck Maintenance - Fuel Total H. Water - Truck Maintenance Water - H - Filtration Plant - Full time Wages Water - H - Filtration Plant - Full time - OT Water - H - Filtration Plant - Employee Benefits Water - H - Filtration Plant - Chemicals Water - H - Filtration Plant - Parts Water - H - Filtration Plant - Fuel Water - H - Filtration Plant - Equipment Purchases Water - H - Filtration Plant - Health & Safety Water - H - Filtration Plant - General Materials Water - H - Filtration Plant - Computer Expense Water - H - Filtration Plant - Lab Supplies Water - H - Filtration Plant - Contracted Services Water - H - Filtration Plant - Hydro Water - H - Filtration Plant - Water Water - H - Filtration Plant - Sewer Water - H - Filtration Plant - Heat Water - H - Filtration Plant - Courier Water - H - Filtration Plant - Telephone Water - H - Filtration Plant - Service Contracts Water - H - Filtration Plant - Equipment Repairs Water - H - Filtration Plant - Lab Testing Fees Total H. Water - Filtration Plant Water - H - Water Tower - Full time Wages Water - H - Water Tower - Full time - OT Water - H - Water Tower - Employee Benefits Water - H - Water Tower - Hydro Total H. Water - Water Tower Water - H - Watermain Maint - Full time Wages Water - H - Watermain Maint - Full time - OT Water - H - Watermain Maint - Employee Benefits Water - H - Watermain Maint - Granulars Water - H - Watermain Maint - Hot Mix Water - H - Watermain Maint - Parts Water - H - Watermain Maint - Equipment Purchases Water - H - Watermain Maint - General Materials Water - H - Watermain Maint - Licences Total H. Water - Watermain Maintenance Water -Hastings- Watermain Maint- Engineering Serv Water - H - Watermain Maint - Equipment Rental Water - H - Water Service Maint - Full time Wages Water - H - Water Service Maint -Full time - OT Water - H - Water Service Maint - Employee Benefit Water - H - Water Service Maint - Granulars Water - H - Water Service Maint - Hot Mix Water - H - Water Service Maint - Parts Water - H - Water Service Maint - Concrete Water - H - Water Service Maint - General Material Water - H - Water Service Maint - Equipment Repair Water - H - Water Service Maint - Equipment Rental Total H. Water - Water Service Maintenance Water - H - Locates - Full time Wages Water - H - Locates - Full time - OT Water - H - Locates - Employee Benefits Water - H - Locates - General Materials Water - H - Locates - Equipment Repairs Total H. Water - Locates Water - H - Disconnect-Reconnect - Full time Wages Water - H - Disconnect/Reconnect - Full time - OT Water - H - Disconnect/Reconnect - Employee Benefi Total H. Water - Disconnect/Reconnect. Water - H - Hyrdrant Maint - Full time Wages Water - H - Hydrant Maint - Employee Benefits Water - H - Hydrant Maint - Parts Total H. Water - Hydrant Maintenance Water - H - Water Meter Maint - Full time Wages
0 0 0 0 0 800 0 0 16,380 $4,771 4,771 $22,000 7,500 7,000 20,000 0 0 3,000 0 0 0 0 31,380 20,000 0 0 12,000 0 0 0 3,500 5,200 131,580 $3,319 0 750 1,200 5,269 $8,164 1,000 2,200 0 3,500 1,000 0 500 0 16,364 $0 500 2,500 0 800 0 0 300 0 0 0 500 4,600 $851 0 200 0 0 1,051 $583 0 0 $583 $1,582 500 0 2,082 $4,500
0 0 0 0 0 0 0 0 0 $0.00 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 0 0 0 0 0 $0.00 0 0 $0 $0.00 0 0 0 $0.00
100 20 20 25 100 1,000.00 300 0 10,317 $5,000.00 5,000 $28,356.00 0 0 22,000.00 7,500.00 700 3,000.00 0 1,000.00 0 3,000.00 5,000.00 25,000.00 1,500.00 1,000.00 15,000.00 100 1,000.00 600 3,000.00 8,000.00 125,756 $4,586.00 0 0 1,200.00 5,786 $5,673.00 0 0 250 1,500.00 100 250 350 700 8,823 $0.00 1,000.00 8,873.00 0 0 1,000.00 1,500.00 500 1,500.00 350 300 1,000.00 16,023 $3,099.00 0 0 150 200 3,449 $782.00 0 0 $782 $3,866.00 0 400 4,266 $2,272.00
0 0 0 0 0 947.87 0 2879.09 7,663.53 24265.14 8188.71 8853.56 14479.24 3856.11 634.29 2185.51 116.6 765.43 2962.4 902.15 8430.11 16922.12 1187 1066.24 10649.72 74.6 809.99 396 3364.61 7478 117,587.53 4784.23 619.98 1491.98 1067.44 7,963.63 6358.61 1472.89 2166.36 461.64 0 473.39 36 148.54 0 11,117.43 103.18 1473.5 1985.93 166.44 602.08 489.29 2025 0 0 86.96 90.35 501.6 7,524.33 671.94 23.9 192.99 89.68 0 978.51 978.79 45.79 279.15 1,303.73 1128.85 325.24 2117.5 3,571.59 554.58
966 7,692 3,500 3,500 29,270 22,000 5,000 700 2,500 500 3,500 2,000 7,000 25,000 1,500 1,000 15,000 100 1,000 600 3,500 8,000 128,170 4,704 1,200 5,904 5,850 500 3,500 500 250 300 700 11,600 9,131 1,000.00 2,500.00 500.00 1,500.00 350.00 300.00 1,000.00 16,281 3,165 100 100 3,365 801 $801 3,973 2,500 6,473 2,331
Page 10 of32 12/11/2008
01-430-4-75800-8011100 01-430-4-75800-8015000 01-430-4-75800-8030750 01-430-4-75800-8032400 01-430-4-75800-8041050
Water - H - Water Meter Maint - Full time - OT Water - H - Water Meter Maint - Employee Benefits Water - H - Water Meter Maint - Parts Water - H - Water Meter Maint - General Materials Water - H - Water Meter Maint - Contracted Service Total H. Water - Water Meter Maintenance 01-430-4-75850-8011050 Water - H - Health/Safety/Training/ - Full time Wa 01-430-4-75850-8015000 Water - H - Health/Safety/Training - Employee Bene Total H. Water - Health/Safety/Training 01-430-4-75900-8011150 Water - H - On Call - Full time - On Call 01-430-4-75900-8015000 Water - H - On Call - Employee Benefits 01-430-4-75900-8031450 Water - H - On Call - Clothing Expense Total H. Water - On Call 01-430-4-75950-8011050 Water - H - Other Mun - Full time Wages Total H. Water - Other Munic. Total Hastings Water - Expenditures Hastings Water Capital Expenditures 02-430-4-00000-6041000 Don't Use - Water - Hastings - Ont Cond Grant 02-430-4-00000-8045050 Don't Use - Water - Hastings - Engineering Serv 02-430-4-00000-8051050 Don't Use -OSIFA LTD - Interest on Short Term Debt 02-430-4-00050-8011050 Don't Use - Water - Hastings - Capital Salary 02-430-4-00050-8015000 Don't Use -Water - Hastings - Capital Emp Benefits 02-430-4-00085-8011050 Don't Use - Water-Hast-Dist'n System-Full Time-Reg 02-430-4-00085-8011100 Don't Use - Water-Hast-Dist'n System-Full Time-OT 02-430-4-00085-8015000 Don't Use - Water-Hast-Dist'n System-Emp Ben 02-430-4-00085-8030750 Don't Use - Argyle Street - Parts 02-430-4-00085-8032800 Don't Use -Water-Hastings- Dist'n System - Licence 02-430-4-00085-8042050 Don't Use - Water-Hast-Dist'n System-Const'n Cont 02-430-4-00085-8045050 Don't Use - Water-Hast-Dist'n System-Eng Serv 02-430-4-00201-6041050 BUILDING IMPROVEMENTS - Ont Cond Grant - OSTAR 02-430-4-00201-8041700 BUILDING IMPROVEMENTS - Facility Repairs 02-430-4-00251-8041050 HASTINGS WATER TOWER - Contracted Services 02-430-4-00401-8031400 GAC REPLACEMENT - Equipment Purchases 02-430-4-00402-8031400 EQUIPMENT PURCHASES - Equipment Purchases 02-430-4-00601-8032300 CAPITAL LOAN PAYMENT - Miscellaneous 02-430-4-00601-8051150 CAPITAL LOAN PAYMENT - Interest & Bank Charges 02-430-4-00601-8071000 CAPITAL LOAN PAYMENT - Principal Payments - Loans 02-430-4-00651-8011050 WATER PLANT GENERAL REPAIRS - Full time Wages 02-430-4-00651-8041050 WATER PLANT GENERAL REPAIRS - Contracted Services 02-430-4-00751-8032300 WATER TOWER - Miscellaneous 02-430-4-00751-8032400 WATER TOWER - General Materials 02-430-4-00751-8042050 WATER TOWER - Construction Contracts 02-430-4-00752-6094200 WATER TOWER REPAIRS - Miscellaneous Revenue 02-430-4-00752-8011050 WATER TOWER REPAIRS - Full time Wages 02-430-4-00752-8015000 WATER TOWER REPAIRS - Employee Benefits 02-430-4-00752-8042050 WATER TOWER REPAIRS - Construction Contracts 02-430-4-00851-8011050 FRONT STREET - Full time Wages 02-430-4-00852-8045050 2ND RIVER CROSSING - Engineering Services 02-430-4-00853-8030750 ARGYLE STREET - Parts 02-430-4-01251-8011050 ASSET MANAGEMENT - Full time Wages 02-430-4-01251-8045050 ASSET MANAGEMENT - Engineering Services 02-430-4-01254-8032800 QMS STUDY - Licences 02-430-4-01502-7001000 TRANSFER FROM RESERVES - Transfers from Reserves 02-430-4-01503-6031100 OSTAR - FED TOP UP - Fed Grant Front St. - William St. to Elizabeth St. SCADA Upgrades Total Hastings Water Capital Expenditures TOTAL HASTINGS WATER SYSTEM
0 719 0 0 0 5,219 $7,240 0 7,240 $2,000 495 0 2,495 $0 $0 281,834
0 0 0 0 0 0 $0.00 0 0 $0.00 0 0 0 $0.00 $0 322,002
0 0 250 0 500 3,022 $2,043.00 0 2,043 $3,707.00 0 150 3,857 $10,667.00 $10,667 282,675
17.45 149.89 2203.09 25.47 0 2,950.48 52.95 14.84 67.79 2139.04 584.19 0 2,723.23 223,167.69
1,000 50 2,000 5,381 2,113 2,113 3,860 3,860 10,875 $10,875 284,811
$0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 171,097 0 0 15,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
($500,000) 315.15 36,710.00 19.18 1.92 662.47 446.05 277.14 12,082.05 1,200.00 24,984.03 9,325.31 0 0 3,074.00 0 0 58,096.35 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
$0.00 0 0 0 0 0 0 0 0 0 0 0 -354,436.44 5,000.00 0 22,000.00 7,000.00 170,856.00 0 0 5,000.00 0 11,926.00 0 0 0 0 0 0 0.00 25000 0 12,500.00 0 12,500.00 -70,926.00 0
39.52 9.88 27,409.70 73439.48 84780.62 0 1296 0 912.6 11837.6 -32190.48 1658.74 478.59 32190.48 0 8042.18 2143.9 0 3121.09 0 0 (354,436.44)
170,856 -
186,097 6,654
-352,806 -521,949
-153,580 -294,875
(139,266.54) (302,426.85)
0 0 0 5,000 175,856 36,697
Page 11 of32 12/11/2008
Campbellford Sewer System Campbellford Sanitary Sewer Revenue 01-410-1-00000-6063050 Sanitary - C'ford Admin - Charges - Residential 01-410-1-00000-6063100 Sanitary - C'ford Admin - Charges - General Serv 01-410-1-00000-6063150 Sanitary - C'ford Admin - Sewer Connections 01-410-1-00000-6073100 Sanitary - C'ford Admin - Equipment Rental 01-410-1-00000-6073125 Sanitary - C'ford Admin - Equipment Rental (Intern 01-410-1-00000-6082300 Sanitary - C'ford Admin - Late Payment Charges 01-410-1-00000-6094200 Sanitary - C'ford Admin - Miscellaneous Income 01-410-1-00000-7001000
Sanitary - C'ford Admin - Transfer From Reserves Total Campbellford Sanitary Sewer Revenue Campbellford Sanitary Sewer Expenditures Total Campbellford Sanitary Sewer Expenditures 01-410-1-00000-8011050 Sanitary - C'ford Admin - Regular Wages 01-410-1-00000-8011075 Sanitary - C'ford Admin - Health & Safety Training 01-410-1-00000-8011100 Sanitary - C'ford Admin - Overtime Wages 01-410-1-00000-8011150 Sanitary - C'ford Admin - Stand By / On Call 01-410-1-00000-8011200 Sanitary - C'ford Admin - Vacation Wages 01-410-1-00000-8011250 Sanitary - C'ford Admin - Sick Wages 01-410-1-00000-8015000 Sanitary - C'ford Admin - Employee Benefits 01-410-1-00000-8030750 Sanitary - C'ford Admin - Parts 01-410-1-00000-8030800 Sanitary - C'ford Admin - Paint 01-410-1-00000-8031000 Sanitary - C'ford Admin - Tools & Sundry 01-410-1-00000-8031100 Sanitary - C'ford Admin - Fuel 01-410-1-00000-8031300 Sanitary - C'ford Admin - Mileage 01-410-1-00000-8031350 Sanitary - C'ford Admin - Training & Courses 01-410-1-00000-8031400 01-410-1-00000-8031450 01-410-1-00000-8032050 01-410-1-00000-8032200 01-410-1-00000-8032250 01-410-1-00000-8032350 01-410-1-00000-8032400 01-410-1-00000-8032450 01-410-1-00000-8032500 01-410-1-00000-8032650 01-410-1-00000-8032700 01-410-1-00000-8032800 01-410-1-00000-8033050 01-410-1-00000-8041050 01-410-1-00000-8041150 01-410-1-00000-8041200 01-410-1-00000-8041250 01-410-1-00000-8041300 01-410-1-00000-8041350 01-410-1-00000-8041400 01-410-1-00000-8041500 01-410-1-00000-8041600 01-410-1-00000-8041650 01-410-1-00000-8041750 01-410-1-00000-8041950 01-410-1-00000-8045050 01-410-1-00000-8050100 01-410-1-00000-8050200 01-410-1-00000-8050225 01-410-1-00000-8051100 01-410-1-00000-8051150 01-410-1-00000-8051750 01-410-1-00000-8071200 01-410-1-71050-6073125 01-410-1-71050-8011050 01-410-1-71050-8011100 01-410-1-71050-8015000 01-410-1-71050-8032500 01-410-1-71050-8041050 01-410-1-71100-8011050 01-410-1-71100-8015000 01-410-1-71100-8030750 01-410-1-71100-8041050 01-410-1-71150-6073125 01-410-1-71150-8011050
Sanitary - C'ford Admin - Equipment Purchases Sanitary - C'ford Admin - Clothing Expense Sanitary - C'ford Admin - Office Supplies Sanitary - C'ford Admin - Caretaking Supplies Sanitary - C'ford Admin - Postage Sanitary - C'ford Admin - Health & Safety Sanitary - C'ford Admin - General Materials Sanitary - C'ford Admin - Advertising & Promotio Sanitary - C'ford Admin - Tipping & Collection Sanitary - C'ford Admin - Dues & Subscriptions Sanitary - C'ford Admin - Computer Expenses Sanitary - C'ford Admin - Licences Sanitary - C'ford Admin - Meals Sanitary - C'ford Admin - Contracted Services Sanitary - C'ford Admin - Hydro Sanitary - C'ford Admin - Water Sanitary - C'ford Admin - Sewer Sanitary - C'ford Admin - Heat Sanitary - C'ford Admin - Courier Sanitary - C'ford Admin - Telephone Sanitary - C'ford Admin - Insurance Sanitary - C'ford Admin - Accounting & Audit Sanitary - C'ford Admin - Service Contracts Sanitary - C'ford Admin - Equipment Repairs Sanitary - C'ford Admin - Lab Testing Fees Sanitary - C'ford Admin - Engineering Services Sanitary - C'ford Admin - Land Rental Sanitary - C'ford Admin - Equipment Rental Sanitary - C'ford Admin - Equipment Rental - Int Sanitary - C'ford Admin - Interest on Late Paymen Sanitary - C'ford Admin - Interest & Bank Charges Sanitary - C'ford Admin - Interest on RBC LTD Sanitary - C'ford Admin - Loan - principal paid on Total C. Sanitary - Administration Sanitary - C - Sewer Flushing - Equip Rent - Inter Sanitary - C - Sewer Flushing - Full time Wages Sanitary - C - Sewer Flushing - Full time - OT Sanitary - C - Sewer Flushing - Employee Benefits Sanitary - C - Sewer Flushing - Tipping and Collec Sanitary - C - Sewer Flushing - Contracted Service Total C. Sanitary - Sewer Flushing Sanitary - C - Sewer Collapse/Lat - Full time Wage Sanitary - C - Sewer Collapse/Lat - Employee Benef Sanitary - C - Sewer Collapse/Lat - Parts Sanitary - C - Sewer Collapse/Lat - Contracted Ser Total C. Sanitary - Sewer Collapse/Lat Sanitary - C - CCTV - Equipment Rental - Internal Sanitary - C - CCTV - Full time Wages
Page 12 of32 12/11/2008 ($631,775) -370,549 -250 0 0 -6,838 0
($591,130.24) -361,542.07 -650 -2,041.00 18 0 -470.75
($596,024.00) -361,007.00 0 0 0 0 0
-519925.75 -321451.22 -250 0 0 0 -544.5
(596,024) (361,007) -
0 -1,009,412
213,980.92 -741,835
-213,980.92 -1,171,012
0 (842,171.47)
-957,031
0 $27,494 0 0 0 0 0 22,105 0 0 0 2,500 0 0
0 $30,746.15 0 1,727.90 1,830.53 843.92 153.44 14,629.59 2,354.27 390.36 239.46 2,184.15 0 0
0 $52,470.00 0 0 0 0 0 29,211.00 150 300 5,000.00 2,500.00 5,000.00 10,000.00
22325.95 1487.54 1637 0 1968.98 416.24 7939.63 0 170.04 589.7 0 0 1493.33
0 25,400 23,675 150.00 300.00 5,000.00 2,500.00 500.00 10,000.00
0 1,500 0 0 3,000 1,000 0 0 500 500 500 1,500 0 8,000 0 0 0 0 0 1,000 22,000 0 0 0 0 0 220 0 0 0 0 0 0 91,819 $0 0 0 0 0 15,000 15,000 $20,000 0 0 6,805 26,805 $0 0
0 1,553.36 260 18 3,185.00 0 159.96 0 5,316.75 0 387 1,507.74 28.42 40,637.48 48,133.01 13,941.43 18,665.37 14,660.82 6.09 833.31 25,923.30 712 274,843.71 105.3 67.5 1,715.60 220 1,613.16 2,923.00 0 334.63 17,158.68 10,493.40 540,504 $0.00 0 0 0 0 0 0 $0.00 0 0 0 0 $0.00 0
0 1,500.00 1,000.00 100 3,200.00 1,000.00 100 1,000.00 500 1,000.00 500 1,500.00 500 5,000.00 0 0 0 0 100 1,000.00 26,000.00 0 0 0 0 1,000.00 220 0 0 0 0 0 0 149,851 $0.00 19,176.00 0 0 400 20,000.00 39,576 $0.00 0 1,000.00 0 1,000 $0.00 0
370.98 635.02 0 0 0 0 2789.86 0 2334.15 36.42 0 75 0 237.5 40409.25 13289.23 17807.56 23507.13 26.57 589.74 27361.94 0 131738.93 0 0 238.57 220 0 0 3.64 304.49 0 0 300,004.39 48 1659.99 196.32 520.73 0 4350 6,775.04 678.52 182.01 1552.09 0 2,412.62 294 2975.94
OCWA 2008
(100,000) unbilled
moved from office 1,000.00 supplies 1,500.00 1,000.00 100.00 3,200.00 1,000.00 100.00 JE 1,000.00 - JE 500.00 500.00 1,500.00 500.00 5,000.00 Louden 100.00 1,000.00 27,892 - JE 1,000.00 220.00 114,637 5,543 400 10,000 15,943 12,324 2,500 3,000 17,824 5,543
01-410-1-71150-8015000 01-410-1-71150-8041050 01-410-1-71150-8041750 01-410-1-71200-6073125 01-410-1-71200-8011050 01-410-1-71200-8011100 01-410-1-71200-8015000 01-410-1-71200-8030750 01-410-1-71200-8032400 01-410-1-71200-8041050 01-410-1-71250-8011050 01-410-1-71250-8011100 01-410-1-71250-8015000 01-410-1-71250-8030750 01-410-1-71250-8031400 01-410-1-71250-8041050 01-410-1-71300-6073125 01-410-1-71300-8011050 01-410-1-71300-8011100 01-410-1-71300-8015000 01-410-1-71300-8030800 01-410-1-71350-8032500 01-410-1-71350-8041050 01-410-1-71350-8041150 01-410-1-71350-8041200 01-410-1-71350-8041250 01-410-1-71350-8041300 01-410-1-71350-8041650 01-410-1-71400-8041050 01-410-1-71500-8011050 01-410-1-71500-8015000 01-410-1-71500-8032800 01-410-1-71500-8045050 01-410-1-71550-8011050 ??-???-?-?????-8011050 01-410-1-71550-8045150 01-410-1-71600-8041050 01-410-1-71650-8011050 01-410-1-75900-8011150 01-410-1-75900-8015000
Sanitary - C - CCTV - Employee Benefits Sanitary - C - CCTV - Contracted Services Sanitary - C - CCTV - Equipment Repairs Total C. Sanitary - CCTV Sanitary - C - Sewer Repairs - Equip Rent - Intern Sanitary - C - Sewer Repairs - Full time Wages Sanitary - C - Sewer Repairs - Full time - OT Sanitary - C - Sewer Repairs - Employee Benefits Sanitary - C - Sewer Repairs - Parts Sanitary - C - Sewer Repairs - General Materials Sanitary - C - Sewer Repairs - Contracted Services Total C. Sanitary - Sewer REpairs Sanitary - C - Flow Monitoring - Full time Wages Sanitary - C - Flow Monitoring - Full time - OT Sanitary - C - Flow Monitoring - Employee Benefits Sanitary - C - Flow Monitering - Parts Sanitary - C - Flow Monitoring - Equipment Purchas Sanitary - C - Flow Monitoring - Contracted Serv Total C. Sanitary - Flow Monitoring Sanitary - C - Sewer Locates - Equip Rent - Intern Sanitary - C - Sewer Locates - Full time Wages Sanitary - C - Sewer Locates - Full time - OT Sanitary - C - Sewer Locates - Employee Benefits Sanitary - C - Sewer Locates - Paint Total C. Sanitary - Sewer Locates Sanitary - C - Treatment - Tipping and Collection Sanitary - C - Treatment - Contracted Services Sanitary - C - Treatment - Hydro Sanitary - C - Treatment - Water Sanitary - C - Treatment - Sewer Sanitary - C - Treatment - Heat Sanitary - C - Treatment - Service Contracts Total C. Sanitary - Treatment Sanitary - C - Biosolids - Contracted Services Total C. Sanitary - Biosolids Sanitary - C - Sewer Maintenance - Full time Wages Sanitary - C - Sewer Maintenance - Employee Benefi Sanitary - C - Sewer Maintenance - Licences Sanitary - C - Sewer Maintenance - Engineering Ser Total C. Sanitary - Sewer Maintenance Sanitary - C - Billing/Collections - Full time Wag Sanitary - C - Health & Safety Sanitary - C - Billing/Collections - Consulting Se Total C. Sanitary - Billing/Collections Sanitary - C - Corewall Inspect & Repair -Cont Ser Total C. Sanitary - Corewall Inspect. & Repair Sanitary - C - Manhole Repairs/ Adj - Full Time Wa Total C. Sanitary - Manhole Repairs/ Adj. Sanitary - C - On Call - Full time - On Call Sanitary - C - On Call - Employee Benefits Total C. Sanitary - On Call Total Campbellford Sanitary Sewer Expenditures
0 15,000 0 15,000 $0 5,000 0 0 0 0
0 0 0 0 $0.00 0 0 0 0 0
0 15,000.00 200 15,200 $0.00 5,273.00 0 0 2,000.00 100
855.15 1395 0 5,520.09 2103.5 4157.2 1138.15 1442.76 1240.92 219.86
15,000 20,000 $0 0 0 0 0 10,000 10,000 $0 2,000 0 0 0 2,000 $0 0 60,000 20,000 20,000 38,423 143,453 281,876 $82,537 82,537 $2,000 0 0 0 2,000 $0 $0 0 $20,000 20,000 $5,000 5,000 $3,681 0 3,681 575,718
0 0 $0.00 0 0 0 0 0 0 $0.00 0 0 0 0 0 $0.00 0 0 0 0 0 0 0 $0.00 0 $0.00 0 0 0 0 $0.00 $0.00 0 $0.00 0 $0.00 0 $0.00 0 0 540,504
35,000.00 42,373 $0.00 0 0 5,000.00 0 5,000.00 10,000 $0.00 1,918.00 0 0 100 2,018 $5,000.00 0 50,000.00 15,000.00 15,500.00 15,000.00 369,413.00 469,913 $0.00 0 $1,918.00 0 50 1,000.00 2,968 $10,472.00 $0.00 0 10,472 $0.00 0 $0.00 0 $0.00 0 0 743,371
2562.81 12,865.20 360.12 318.6 184.67 1321.88 2099.9 0 4,285.17 450 2979.57 30.53 820.09 102.12 4,382.31 21588.7 2248.75 3700.22 0 0 4791.43 57174.24 89,503.34 269.43 66.23 335.66 399.88 400 2502.56 680.65 3,183.21 429,666.91
10,000 200 15,743 11,914 4,000 1,100 removed 3,000 for parts and general 16,000 materials 33,014 17,149 5,000 2,500 24,649 4,422 150 4,572 5,000 JE 50,000 15,000 15,500 15,000 374,568 475,068 0 3,595 50 1,000 4,645 11,962 3,595 15,557 0 0 0 721,652
Page 13 of32 12/11/2008
Campbellford Sanitary Capital Expenditures 02-410-1-00000-7090050 Don't Use - Sanitary - C - LTD Proceeds $0 ($410,500.00) $0.00 02-410-1-00000-8041050 Don't Use - Sanitary - C'ford Capital - Cont Serv 0 28,679.52 0 02-410-1-00000-8045050 Don't Use - Sanitary - C'ford Capital - Eng Serv 0 5,595.07 0 02-410-1-00000-8051050 Don't Use -OSIFA LTD - Interest on Short Term Debt 0 17,235.58 0 02-410-1-00065-8041350 Don't Use - Sanitary - C'ford -Treat Plant - Couri 0 14.69 0 02-410-1-00065-8042050 Don't Use -Sanitary-C'ford- Treat Plant-Const Cont 0 5,241,742.07 0 02-410-1-00065-8045050 Don't Use - Sanitary - C'ford - Treat Plant - Eng 0 153,924.47 0 02-410-1-00065-8045150 Dont' Use -Sanitary - C'ford - Treat Plant-Consult 0 38,452.07 0 02-410-1-00085-8011050 Don't Use - Sanitary-C'ford-Dist'n -Full Time-Reg 0 163.5 0 02-410-1-00085-8011100 Don't Use - Sanitary-C'ford-Dist'n-Full Time-Over 0 50.94 0 02-410-1-00085-8015000 Don't Use - Sanitary-C'ford-Dist'n-Employee Ben 0 53.62 0 02-410-1-00085-8030200 Don't Use - Sanitary-C'ford-Dist'n -Granulars 0 31.12 0 02-410-1-00085-8032450 Don't Use - Sanitary-C'ford-Dist'n - Advertising 0 258.73 0 02-410-1-00085-8032800 Don't Use - Sanitary-C'ford-Dist'n-Licences 0 220 0 02-410-1-00085-8041050 Don't Use -Sanitary-C'ford-Dist'n -Contracted Serv 0 29,320.49 0 02-410-1-00085-8041350 Don't Use - Sanitary-C'ford-Dist'n - Courier 0 12.18 0 02-410-1-00085-8042050 Don't Use -Sanitary-C'ford-Dist'n Const'n Contract 0 581,081.29 0 02-410-1-00085-8045050 Don't Use - Sanitary-C'ford-Dist'n -Eng Serv 0 93,636.17 0 02-410-1-00085-8050150 Don't Use - Sanitary-C'ford-Dist'n -Mach Ren 0 603.75 0 02-410-1-00100-8045050 Dont't Use - Sanitary -C'ford-Rd Reconst'n-Eng Ser 0 4,317.82 0 02-410-1-00125-8045050 Don't Use - Sanitary - C'ford - Studies - Eng Ser 0 589.11 0 02-410-1-00135-8041050 Don't Use - Sanitary - C'ford - OCWA Cap- Cont Ser 0 28,959.53 0 02-410-1-00601-8032300 CAPITAL LOAN PAYMENT - Miscellan 60,066 6,205.97 328,835.00 02-410-1-00601-8051050 CAPITAL LOAN PAYMENT - Interest on Short Term Debt 0 0 0 137865.94 02-410-1-00601-8051150 CAPITAL LOAN PAYMENT - Interest & Bank Charges 0 0 0 43772.94 02-410-1-00601-8071000 CAPITAL LOAN PAYMENT - Principal Payments - Loans 0 0 0 27218.31 02-410-1-00651-8042050 WPCP PLANT UPGRADE - Contract Costs 0 0 0 1162569.86 02-410-1-00651-8045050 WPCP PLANT UPGRADE - Engineering Expenses 0 0 0 62642.08 02-410-1-00652-8011050 BIOSOLIDS STORAGE - Full time Wages 0 0 85,000.00 0 02-410-1-00652-8045050 BIOSOLIDS STORAGE - Engineering Services 0 0 0 1663.01 02-410-1-00654-8041050 OCWA - PLANT CAPITAL - Contracted Services 0 0 0 1377.39 02-410-1-00655-8032300 TREATMENT PLANT - OPERATOR - Miscellaneous 0 0 47,725.00 33208.73 02-410-1-00702-8032300 PUMPING STATION - OPERATOR - Miscellaneous 0 0 20,500.00 2415 02-410-1-00851-8042050 MARKET STREET - Construction Contracts 0 0 0 178902.24 02-410-1-00851-8045050 MARKET STREET - Engineering Expenses 449,000 0 0 17350.94 02-410-1-00853-8011050 FRONT STREET - Full time Wages 250,600 0 0 0 02-410-1-00853-8045050 FRONT STREET - Engineering Expense 0 0 0 7150.86 02-410-1-00854-8042050 RIVER STREET - Construction Contracts 0 0 0 11598.01 02-410-1-00854-8045050 RIVER STREET - Engineering Expense 193,800 0 0 1742.5 02-410-1-00855-8045050 QUEEN STREET - Engineering Expense 103,800 0 0 324.81 02-410-1-00857-7001000 COMBINED SEWER SEPARATION - Transfer from Reserves 0 0 -20,000.00 0 02-410-1-00857-8011050 COMBINED SEWER SEPARATION - Full time Wages 25,000 0 25,000.00 0 02-410-1-00859-8011050 UPPER GARRY STREET - Full time Wages 30,000 0 50,000.00 0 02-410-1-00859-8032800 UPPER GARRY STREET - Licences 0 0 0 1100 02-410-1-00859-8045050 UPPER GARRY STREET - Engineering Services 0 0 0 1540.76 02-410-1-00860-8011050 FRONT ST - RANNEY TO ARENA - Full time Wages 0 0 75,000.00 0 02-410-1-00860-8042050 FRONT ST - RANNEY TO ARENA - Construction Contract 0 0 0 14522.82 02-410-1-00899-7090050 DIST SYSTEM - LTD PROCEEDS 0 0 -125,000.00 0 02-410-1-01010-8042050 DOXSEE STREET - Construction Contracts 105,350 30,645.63 9,554.33 0 02-410-1-01010-8045050 DOXSEE STREET - Engineering Services 0 4,443.66 0 1115.46 02-410-1-01251-7001000 BIOSOLIDS EA - Transfers from Reserves 0 0 -19,700.00 0 02-410-1-01251-7090050 BIOSOLIDS EA - Proceeds from Loans 0 0 -65,300.00 0 02-410-1-01252-7001000 ASSET MANAGEMENT - Transfer from Reserves 0 0 -38,407.63 0 02-410-1-01252-8011050 ASSET MANAGEMENT - Full time Wages 0 0 38,407.63 0 02-410-1-01252-8045050 ASSET MANAGEMENT - Engineering Services 0 0 0 795.64 02-410-1-01253-8011050 I/I PROGRAM - Full time Wages 0 0 15,000.00 0 02-410-1-01253-8030750 I/I PROGRAM - Parts 0 0 0 10379.3 02-New PLANT CAPITAL 02-New PUMP STATION CAPITAL 02-New Build Canada - Federal Portion 02-New Build Canada - Provincial Portion 02-New Oliver Market - Isabella 02-New Oliver Isabella - Major 02-New Isabella Oliver - Cromwell 02-New Major Oliver - Front N 02-New L. Garry Wellington-Canrobert Total Campbellford Sanitary Capital Expenditures 1,217,616 5,855,737 426,614 1,719,256.60 TOTAL CAMPBELLFORD SANITARY SEWER 783,922 5,654,406 -1,027 1,306,752.04 ============== ============== ============= ==============
Page 14 of32 12/11/2008 621,594 CO
CO CO
CO
CO
CO CO 26,075 16,750
664,419 429,040 =============
Hastings Sewer System Hastings Sanitary Sewer Revenues 01-410-4-00000-6063050 Sanitary - Hastings Admin - Charges - Residential 01-410-4-00000-6063100 Sanitary - Hastings Admin - Charges - General Serv 01-410-4-00000-6063150 Sanitary - Hastings Admin - Sewer Connections 01-410-4-00000-6064150 Sanitary - Hastings Admin - Local Improvements 01-410-4-00000-6073100 Sanitary - Hastings Admin - Equipment Rental 01-410-4-00000-6073125 Sanitary - Hastings Admin - Equipment Rental - Int 01-410-4-00000-6082300 Sanitary - Hastings Admin - Late Payment Charges 01-410-4-00000-7001000 Sanitary - Hastings Admin - Transfer From Reserves Total Hastings Sanitary Sewer Revenues Hastings Sanitary Sewer Expenditures Total Hastings Sanitary Sewer Expenditures 01-410-4-00000-8011050 Sanitary - Hastings Admin - Regular Wages 01-410-4-00000-8011100 Sanitary - Hastings Admin - Overtime Wages 01-410-4-00000-8011150 Sanitary - Hastings Admin - Stand By / On Call 01-410-4-00000-8015000 Sanitary - Hastings Admin - Employee Benefits 01-410-4-00000-8030200 Sanitary - Hastings Admin - Granulars 01-410-4-00000-8030750 Sanitary - Hastings Admin - Parts 01-410-4-00000-8030800 Sanitary - Hastings Admin - Paint 01-410-4-00000-8031100 Sanitary - Hastings Admin - Fuel 01-410-4-00000-8032050 Sanitary - Hastings Admin - Office Supplies 01-410-4-00000-8032200 Sanitary - Hastings Admin - Caretaking Supplies 01-410-4-00000-8032250 Sanitary - Hastings Admin - Postage 01-410-4-00000-8032350 Sanitary - Hastings Admin - Health & Safety 01-410-4-00000-8032400 Sanitary - Hastings Admin - General Materials 01-410-4-00000-8032450 Sanitary - Hastings Admin - Advertising 01-410-4-00000-8032500 Sanitary - Hastings Admin - Tipping & Collection 01-410-4-00000-8032650 Sanitary - Hastings Admin - Dues & Subscriptions 01-410-4-00000-8032700 Sanitary - Hastings Admin - Computer Expenses 01-410-4-00000-8041050 Sanitary - Hastings Admin - Contracted Services 01-410-4-00000-8041150 Sanitary - Hastings Admin - Hydro 01-410-4-00000-8041200 Sanitary - Hastings Admin - Water 01-410-4-00000-8041250 Sanitary - Hastings Admin - Sewer 01-410-4-00000-8041300 Sanitary - Hastings Admin - Heat 01-410-4-00000-8041400 Sanitary - Hastings Admin - Telephone 01-410-4-00000-8041500 Sanitary - Hastngs Admin - Insurance 01-410-4-00000-8041600 Sanitary - Hastings Admin - Accounting & Audit 01-410-4-00000-8041650 Sanitary - Hastings Admin - Service Contracts 01-410-4-00000-8041750 Sanitary - Hastings Admin - Equipment Repairs 01-410-4-00000-8050100 Sanitary - Hastings Admin - Land Rental 01-410-4-00000-8050150 Sanitary - Hastings Admin - Machinery Rental 01-410-4-00000-8050225 Sanitary - Hastings Admin - Equipment Rental - Int 01-410-4-00000-8071100 Sanitary - Hastings Admin - Water Loan Total H. Sanitary - Administration 01-410-4-71050-8011050 Sanitary - H - Sewer Flushing - Full time Wages 01-410-4-71050-8015000 Sanitary - H - Sewer Flushing - Employee Benefits 01-410-4-71050-8041050 Sanitary - H - Sewer Flushing - Contracted Service Total H. Sanitary - Sewer Flushing 01-410-4-71100-8011050 Sanitary - H - Sewer Collapse/Lat - Full time Wage 01-410-4-71100-8030200 Sanitary - H - Sewer Collapse/Lat - Granulars 01-410-4-71100-8041050 Sanitary - H - Sewer Collapse/Lat - Contracted Ser Total H. Sanitary - Sewer Collapse/Lat 01-410-4-71150-8011050 Sanitary - H - CCTV - Full time Wages 01-410-4-71150-8015000 Sanitary - H - CCTV - Employee Benefits 01-410-4-71150-8041050 Sanitary - H - CCTV - Contracted Services Total H. Sanitary - CCTV 01-410-4-71200-6073125 Sanitary - H - Sewer Repairs - Equip Rent - Intern 01-410-4-71200-8011050 Sanitary - H - Sewer Repairs - Full time Wages 01-410-4-71200-8011100 Sanitary - H - Sewer Repairs - Full time - OT 01-410-4-71200-8015000 Sanitary - H - Sewer Repairs - Employee Benefits 01-410-4-71200-8030750 Sanitary - H - Sewer Repairs - Parts 01-410-4-71200-8041050 Sanitary - H - Sewer Repairs - Contracted Services 01-410-4-71200-8050150 Sanitary - H - Sewer Repairs - Machinery Rental Total H. Sanitary - Sewer Repairs 01-410-4-71250-8011050 Sanitary - H - Flow Monitoring - Full time Wages 01-410-4-71250-8015000 Sanitary - H - Flow Monitoring - Employee Benefits 01-410-4-71250-8041050 Sanitary - H - Flow Monitoring - Contracted Servic Total H. Sanitary - Flow Monitoring 01-410-4-71300-6073125 Sanitary - H - Sewer Locates - Equip Rent - Intern 01-410-4-71300-8011050 Sanitary - H - Sewer Locates - Full time Wages 01-410-4-71300-8015000 Sanitary - H - Sewer Locates - Employee Benefits 01-410-4-71300-8030800 Sanitary - H - Sewer Locates - Paint Total H. Sanitary - Sewer Locates 01-410-4-71350-8011050 Sanitary - H - Treatment - Full time Wages 01-410-4-71350-8041150 Sanitary - H - Treatment - Hydro
Page 15 of32 12/11/2008 ($271,450) -91,000 -600 -23,562 0 0 -3,939 -234 -390,785
($259,035.45) -104,940.07 -850 -23,169.86 -1,067.00 18 0 97,000.46 -292,044
($271,450.00) -91,000.00 0 -23,562.00 0 0 0 0 -386,012
-257021.15 -95356.59 -450 -23365.92 0 0 0 0 (376,193.66)
(271,450.00) (100,000.00) (23,562.00) -395,012
0 $37,282 0 2,000 17,753 0 0 0 698 0 0 1,000 500 1,200 0 10,000 0 0 10,000 0 0 0 0 500 12,500 0 0 0 0 0 0 0 93,433 $0 0 6,800 6,800 $1,500 0 3,000 4,500 $0 0 6,800 6,800 $0 16,000 0 0 0 5,000 0 21,000 $0 0 2,000 2,000 $0 775 0 0 $775 $0 34,198
0 $13,632.81 831.09 0 3,407.71 134.35 118.69 97.59 992.8 81 6 995 0 25 1,279.20 0 0 121 11,280.22 37,722.23 35,759.87 44,337.57 14 447.58 14,974.20 222 107,100.61 105.3 80 3,395.64 1,139.00 49.65 278,350 $0.00 0 0 0 $0.00 0 0 0 $0.00 0 0 0 $0.00 0 0 0 0 0 0 0 $0.00 0 0 0 $0.00 0 0 0 $0 $0.00 0
0 $23,144.00 0 0 10,622.00 0 0 0 1,000.00 0 0 1,000.00 0 0 0 0 0 0 0 0 0 0 0 500 0 0 0 0 100 0 0 0 36,366 $0.00 0 7,000.00 7,000 $0.00 1,000.00 3,000.00 4,000 $0.00 0 2,000.00 2,000 $0.00 0 0 0 1,000.00 10,000.00 0 11,000 $0.00 0 2,000.00 2,000 $0.00 0 0 100 $100 $765.00 35,000.00
9427.56 336.1 0 2392.86 0 0 0 0 0 0 0 0 0 0 0 36.43 0 2070 29236 27918.66 34619.14 0 462.62 15861.08 0 66182.43 0 80 264.16 0 31991.32 220,878.36 211.91 58.16 1140 1,410.07 172.00 48.17 220.17 54 284.8 296.4 363.72 495.8 310 177.12 1,981.84 122.1 34.19 0 156.29 186 1748.01 462.38 2,396.39 0 2960.12
0 7,495 6,986 1,000 1,000 500 16,168 100 33,249 1,091 2,500 3,591 2,421 1,000 3,000 6,421 1,091 1,000 2,091 2,182 1,000 2,500 5,682 4,629 1,000 5,629 927 100 $1,027 582 35,000
01-410-4-71350-8041200 01-410-4-71350-8041250 01-410-4-71350-8041650
Sanitary - H - Treatment - Water 6,000 0 38,000.00 0 Sanitary - H - Treatment - Sewer 8,000 0 45,000.00 0 Sanitary - H - Treatment - Service Contracts 97,076 0 173,943.00 21288.85 Total H. Sanitary - Treatment 145,274 0 292,708 24,248.97 01-410-4-71400-8011050 Sanitary - H - Arena Pump #1 - Full time Wages $0 $0.00 $5,459.00 Total H. Sanitary - Arena Pump #1 $0 $0 $5,459 01-410-4-71400-8041050 Sanitary - H - Biosolids Management $1,000 $0.00 $0.00 01-410-4-71400-8041650 Sanitary - H - Biosolids Handling 10,000 0 0 Total H. Sanitary - Biosolids 11,000 0 0 ??-???-?-?????-8011050 Sanitary - H - Manhole Repairs $0 $0.00 $0.00 Total H. Sanitary - Manhole Repairs $0 $0 $0 ??-???-?-?????-8011050 Sanitary - H - Sanitary Sewer Maintenance $0 $0.00 $0.00 Total H. Sanitary - Sanitary Sewer Mtce 0 0 0 0 01-410-4-71550-8011050 Sanitary - H - Billing/Collections - Full time Wag $0 $0.00 $3,808.00 01-410-4-71550-8045150 Sanitary - H - Billing/Collections - Consulting Se 0 0 0 2,479.23 Total H. Sanitary - Billing/Collections $0 $0 $3,808 2,479.23 Total H. Sanitary - On Call 0 0 0 Total Hastings Sanitary Sewer Expenditures 291,582 278,350 364,441 253,771 Hastings Sanitary Capital Expenditures 02-410-4-00000-8031400 Don't Use - Sanitary - Capital - Equipment Purchas $0 ($11,512.33) $0.00 02-410-4-00065-8041050 Don't Use -Sanitary -Hast-Treatment Plant-Cont Ser 0 10,032.30 0 02-410-4-00065-8045050 Dont Use - Sanitary - Hast - Treatment Plant - Eng 0 61,987.11 0 02-410-4-00065-8045150 Don't Use Sanitary - Hast - Treatment Plant - Cons 0 21,887.68 0 02-410-4-00070-8041050 Don't Use - Sanitary-Hast-Pumping Stn-Cont Serv 0 6,783.42 0 02-410-4-00100-8042050 Don't Use -Sanitary-Hast-Rd Reconst'n-Const'n Cont 0 40,696.48 0 02-410-4-00601-8032300 CAPITAL LOAN PAYMENT - Miscellan 0 0 77,302.00 02-410-4-00651-7001000 WCPC PLANT UPGRADES - Transfer from Reserves 0 0 -424,515.63 02-410-4-00651-7090050 WCPC PLANT UPGRADES - Proceeds from Loans 0 0 -2,475,484.37 02-410-4-00651-8011050 WCPC PLANT UPGRADES - Full time Wages 22,000 0 11,250.00 02-410-4-00651-8042050 WPCP PLANT UPGRADES - Construction Contract 0 0 0 1121170.05 02-410-4-00651-8045050 WPCP PLANT UPGRADES - Engineering Expense 2,400,000 0 2,900,000.00 155233.51 02-410-4-00654-8041650 OCWA - PLANT CAPITAL - Service Contracts 0 0 0 2131.75 02-410-4-00701-8011050 PUMP STATION CAPITAL - Full time Wages 12,000 0 18,500.00 0 02-410-4-00850-8032300 Don't Use - Sanitary - Dist Station 20,000 0 0 1811.25 02-410-4-01010-8042050 BRIDGE/FRONT STREET - Construction Contracts 0 0 40,696.48 0 02-410-4-01251-8045050 BIOSOLIDS EA - Engineering Expenses 0 0 0 661.63 02-410-4-01252-8011050 ASSET MANAGEMENT - Full time Wages 0 0 20,000.00 420 02-410-4-01252-8045050 ASSET MANAGEMENT - Engineering Services 0 0 0 0 02-410-4-01253-8011050 I/I PROGRAM - Full time Wages 0 0 17,000.00 3218.16 02-410-4-01253-8030750 I/I PROGRAM - Parts 0 0 0 0 02-410-4-01502-7001000 TRANSFER FROM RESERVES - Transfer from Reserves 0 0 -184,748.48 6923.34 02-New COLLECTION SYSEM CAPITAL 02-New PUMP STATION CAPITAL 02-New PLANT CAPITAL Total Hastings Sanitary Capital Expenditures 2,454,000 129,875 0 1,291,569.69 TOTAL HASTINGS SANITARY SEWER SYSTEM 2,354,797 116,181 -21,571 1,169,147.35 ============== ============== ============= ==============
38,000 45,000 177,272 295,854 4,151 $4,151 0 927 $927 911 911 3,530 $3,530 0 363,063 154,605 CO CO CO CO CO CO 9,000 12,200 175,805 143,856 =============
Page 16 of32 12/11/2008
Warkworth Sewer System Warkworth Sanitary Sewer Revenue 01-410-3-00000-6063050 Sanitary - W'worth Admin - Charges - Residential 01-410-3-00000-6063100 Sanitary - W'worth Admin - Charges - General Servi 01-410-3-00000-6063150 Sanitary - W'worth Admin - Sewer Connections 01-410-3-00000-6064150 Sanitary - W'worth Admin - Local Improvements 01-410-3-00000-6073100 Sanitary - W'worth Admin - Equipment Rental 01-410-3-00000-6082300 Sanitary - W'worth Admin - Late Payment Charges 01-410-3-00000-7090050 Sanitary - W'worth Admin - Proceeds From Loans Total Warkworth Sanitary Sewer Revenue Warkworth Sanitary Sewer Expenditures Total Warkworth W/W Sanitary - Administration 01-410-3-00000-8011050 Sanitary - W'worth Admin - Regular Wages 01-410-3-00000-8011100 Sanitary - W'worth Admin - Overtime Wages 01-410-3-00000-8015000 Sanitary - W'worth Admin - Employee Benefits 01-410-3-00000-8030700 Sanitary - W'worth Admin - Chemicals 01-410-3-00000-8030750 Sanitary - W'worth Admin - Parts 01-410-3-00000-8031000 Sanitary - W'worth Admin - Tools & Sundry 01-410-3-00000-8031100 Sanitary - W'worth Admin - Fuel 01-410-3-00000-8032050 Sanitary - W'worth Admin - Office Supplies 01-410-3-00000-8032200 Sanitary - W'worth Admin - Caretaking Supplies 01-410-3-00000-8032250 Sanitary - W'worth Admin - Postage 01-410-3-00000-8032400 Sanitary - W'worth Admin - General Materials 01-410-3-00000-8032650 Sanitary - W'worth Admin - Dues & Subscriptions 01-410-3-00000-8032700 Sanitary - W'worth Admin - Computer Expenses 01-410-3-00000-8041050 Sanitary - W'worth Admin - Contracted Services 01-410-3-00000-8041150 Sanitary - W'worth Admin - Hydro 01-410-3-00000-8041200 Sanitary - W'worth Admin - Water 01-410-3-00000-8041250 Sanitary - W'worth Admin - Sewer 01-410-3-00000-8041300 Sanitary - W'worth Admin - Heat 01-410-3-00000-8041400 Sanitary - W'worth Admin - Telephone 01-410-3-00000-8041500 Sanitary - W'worth Admin - Insurance 01-410-3-00000-8041600 Sanitary - W'worth Admin - Accounting & Audit 01-410-3-00000-8041650 Sanitary - W'worth Admin - Service Contracts 01-410-3-00000-8041750 Sanitary - W'worth Admin - Equipment Repairs 01-410-3-00000-8041950 Sanitary - W'worth Admin - Lab Testing Fees 01-410-3-00000-8050100 Sanitary - W'worth Admin - Land Rental 01-410-3-00000-8050225 Sanitary - W'worth Admin - Equipment Rental - Int Total W/W Sanitary - Sewer Flushing 01-410-3-71050-8011050 Sanitary - W - Sewer Flushing - Full time Wages 01-410-3-71050-8015000 Sanitary - W - Sewer Flushing - Employee Benefits 01-410-3-71050-8041050 Sanitary - W - Sewer Flushing - Contracted Service Total W/W Sanitary - Sewer Collapse/Lat 01-410-3-71100-8011050 Sanitary - W - Sewer Collapse/Lat - Full time Wage 01-410-3-71100-8015000 Sanitary - W - Sewer Collapse/Lat - Employee Bene 01-410-3-71100-8030750 Sanitary - W - Sewer Collapse/Lat - Parts 01-410-3-71100-8041050 Sanitary - W - Sewer Collapse/Lat - Contracted Ser Total W/W Sanitary - CCTV 01-410-3-71150-8011050 Sanitary - W - CCTV - Full time Wages 01-410-3-71150-8015000 Sanitary - W - CCTV - Employee Benefits 01-410-3-71150-8041050 Sanitary - W - CCTV - -Contracted Services Total W/W Sanitary - CCTV 01-410-3-71200-6073125 Sanitary - W - Sewer Repairs - Equip Rent - Intern 01-410-3-71200-8011050 Sanitary - W - Sewer Repairs - Full time Wages 01-410-3-71200-8011100 Sanitary - W - Sewer Repairs - Full time Wages 01-410-3-71200-8015000 Sanitary - W - Sewer Repairs - Employee Benefits 01-410-3-71200-8030750 Sanitary - W - Sewer Repairs - Parts 01-410-3-71200-8041050 Sanitary - W - Sewer Repairs - Contracted Services Total W/W Sanitary - Sewer Repairs 01-410-3-71250-8011050 Sanitary - W - Flow Monitoring - Full time Wages 01-410-3-71250-8011100 Sanitary - W - Flow Monitoring - Full time - O/T 01-410-3-71250-8015000 Sanitary - W - Flow Monitoring - Employee Benefits 01-410-3-71250-8041050 Sanitary - W - Flow Monitoring - Contracted Servic Total W/W Sanitary - Flow Monitoring 01-410-3-71300-6073125 Sanitary - W - Sewer Locates - Equip Rent - Intern 01-410-3-71300-8011050 Sanitary - W - Sewer Locates - Full time Wages 01-410-3-71300-8015000 Sanitary - W - Sewer Locates - Employee Benefits 01-410-3-71300-8030800 Sanitary - W - Sewer Locates - Paint Total W/W Sanitary - Sewer Locates 01-410-3-71350-8011050 Sanitary - W - Treatment - Full time Wages 01-410-3-71350-8011100 Sanitary - W - Treatment - Full time - OT 01-410-3-71350-8015000 Sanitary - W - Treatment - Employee Benefits 01-410-3-71350-8030700 Sanitary - W - Treatment - Chemicals 01-410-3-71350-8032400 Sanitary - W - Treatment - General Materials 01-410-3-71350-8041050 Sanitary - W - Treatment - Contracted Services 01-410-3-71350-8041950 Sanitary - W - Treatment - Lab testing
Page 17 of32 12/11/2008 ($40,513) -24,766 -1,051 -3,456 0 -1,045 0 -70,831
($36,796.90) -30,300.98 0 -3,455.52 -470 0 0 -71,023
($40,513.00) -24,766.00 0 -3,456.00 0 0 0 -68,735
0 $12,305 1,500 18,106 0 0 900 1,000 0 0 500 0 0 0 0 2,500 0 0 0 1,500 650 0 500 0 0 100 0 39,561 $0 0 5,000 5,000 $5,000 0 500 3,000 8,500 $0 0 5,400 5,400 $0 0 200 0 0 9,800 10,000 $0 0 0 1,500 1,500 $0 500 0 0 $500 $14,112 1,000 3,000 3,000 1,000 0 7,000
0 $16,401.14 3,749.16 4,874.07 2,215.50 106.96 0 1,080.50 41 3 498 39.36 0 60 19,215.82 2,462.13 3 2 7 1,407.23 773.59 111 673.34 643.33 6,883.50 100 572 61,923 $0.00 0 0 0 $0.00 0 0 0 0 $0.00 0 0 0 $0.00 0 0 0 0 0 0 $0.00 0 0 0 0 $0.00 0 0 0 $0 $0.00 0 0 0 0 0 0
0 $14,839.00 0 17,000.00 0 0 0 1,000.00 0 0 500 0 0 0 0 2,700.00 0 0 0 1,300.00 0 0 500 0 0 100 0 37,939 $0.00 0 5,000.00 5,000 $0.00 0 500 3,000.00 3,500 $0.00 0 5,000.00 5,000 $0.00 0 0 0 1,000.00 10,000.00 11,000 $0.00 0 0 1,500.00 1,500 $0.00 0 0 100 $100 $2,125.00 0 0 3,000.00 0 0 7,000.00
-36169.35 -26698.05 0 -3455.52 0 0 -122745 (189,067.92) 6951.34 342.28 2015.94 0 0 0 0 0 . 0 0 0 36.43 0 0 2046.73 0 0 0 1172.31 789.89 0 743.95 0 0 100 0 14,198.87 746.47 210.28 3240 4,196.75 54.75 9.31 64.06 568.24 172.84 1620.33 2,361.41 96.00 755.17 147.24 251.20 6,996.26 8,245.87 830.13 49.08 246.16 1,125.37 102.00 817.24 210.60 1,129.84 56.94 471.52 143.9 0 9.24 75 4666.57
(40,513) (34,000) (3,456) -77,969 0 15,422 11,613 1,000 500 2,700 1,300 805 500 100 33,940 1,500 2,500 4,000 0 500 1,000 1,500 2,171 2,500 4,671 2,517 1,000 2,500 6,017 4,545 1,500 6,045 2,211 100 $2,311 1,500 3,000 5,500
4,545
2,211
Total W/W Sanitary - Treatment 29,112 0 12,125 5,423.17 01-410-3-71400-8011050 Sanitary - W - Arena Pump #1 - Full time Wages $2,500 $0.00 $2,684.00 1515.74 01-410-3-71400-8011100 Sanitary - W - Arena Pump #1 - Full time - OT 1,000 0 0 620.47 01-410-3-71400-8015000 Sanitary - W - Arena Pump #1 - Employee Benefits 1,000 0 0 571.4 01-410-3-71400-8030750 Sanitary - W - Arena Pump #1 - Parts 300 0 300 285.11 01-410-3-71400-8031100 Sanitary - W - Arena Pump #1 - Fuel 250 0 250 231.38 01-410-3-71400-8041050 Sanitary - W - Arena Pump #1 - Contracted Services 3,500 0 1,000.00 4635.72 01-410-3-71400-8041400 Sanitary - W - Arena Pumb #1 - Telephone 200 0 200 195.96 01-410-3-71400-8041650 Sanitary - W - Arena Pump #1 - Service Contracts 200 0 200 396 01-410-3-71400-8041750 Sanitary - W - Arena Pump #1 - Equipment Repair 1,000 0 1,000.00 4811.5 Total W/W Sanitary - Arena Pump #1 9,950 0 5,634 13,263.28 01-410-3-71450-8011050 Sanitary - W - George St Pump #2 - Full time Wages $1,000 $0.00 $0.00 01-410-3-71450-8011100 Sanitary - W - George St Pump #2 - Full time - OT 100 0 0 01-410-3-71450-8015000 Sanitary - W - George St Pump #2 - Employee Benefi 200 0 0 01-410-3-71450-8031100 Sanitary - W - George St Pump #2 - Fuel 0 0 100 01-410-3-71450-8041050 Sanitary - W - George St Pump #2 - Contracted Serv 1,000 0 1,000.00 Total W/W Sanitary - George St Pump #2 2,300 0 1,100 01-410-3-71500-8011050 Sanitary - W - Sewer Maintenance - Full time Wages $4,250 $0.00 $0.00 5817.31 01-410-3-71500-8011100 Sanitary - W - Sewer Maintenance - Full time - OT 1,500 0 0 2162.45 01-410-3-71500-8015000 Sanitary - W - Sewer Maintenance - Employee Benefi 0 0 0 2178.34 ??-???-?-New-8011050 Sanitary - W - Manhole Repairs- Full Time Wages ??-???-?-New-8011050 Sanitary - W - Hydrant Mtce - Full Time Wages ??-???-?-New-8011050 Sanitary - W - Water Meter Mtce - Full Time Wages Total W/W Sanitary - Sewer Maintenance 5,750 0 0 10,158.10 01-410-3-71550-8045150 Sanitary - W - Billing/Collections - Consulting Se $0 $0.00 $0.00 799.75 ??-???-?-New-8011050 Sanitary - W - Billing/Collections - Full Time Wages Total W/W Sanitary - Billing/Collections 800 Total W/W Sanitary - On Call 0 0 0 Total Warkworth Sanitary Sewer Expenditures 117,573 61,923 82,898 60,966.47 Warkwoth Sanitary Capital Expenditures 02-410-3-00085-8032800 Don't Use - Sanitary-W'worth-Dist'n System-Lic $0 $1,370.00 $0.00 02-410-3-00085-8041050 Don't Use Sanitary-W'worth-Dist'n System- Cont Ser 0 4,500.00 0 02-410-3-00085-8042050 Don't Use -Sanitary-W'worth-Dist'n System-Con Cont 0 23,992.26 0 02-410-3-00085-8045050 Don't Use - Sanitary-W'worth-Dist'n System-Eng Ser 0 33,546.20 0 02-410-3-00125-8045150 Don't UseSanitary -W'worth - Studies - Consult Ser 0 3,208.88 0 02-410-3-00601-8032300 CAPITAL LOAN PAYMENT - Miscellan 0 0 8,802.00 02-410-3-00601-8051050 CAPITAL LOAN REPAYMENT - Interest on STD 0 0 0 850.77 02-410-3-00650-7090050 Don't Use - Water Dist - LTD Proceeds -100,000 0 0 02-410-3-00651-7090050 TREATMENT PLANT - Proceeds from Loans 0 0 -60,470.00 02-410-3-00801-7001000 LAGOON TREATMENT SYSTEM - Transfer from Reserves 0 0 -88,845.00 02-410-3-00801-8011050 LAGOON TREATMENT SYSTEM - Full time Wages 0 0 18,845.00 02-410-3-00801-8032300 LAGOON TREATMENT SYSTEM - Miscellaneos 0 0 70,000.00 02-410-3-00852-7001000 OLD HASTINGS ROAD - Transfer from Reserves 0 0 -24,824.00 02-410-3-00852-8042050 OLD HASTINGS ROAD - Construction Contracts 0 0 52,294.42 5076.38 02-410-3-00852-8045050 OLD HASTINGS ROAD - Engineering Expense 75,000 0 0 6159.71 02-410-3-00853-8042050 PERCY STREET - Construction Contracts 0 0 0 5197.17 02-410-3-00853-8045050 PERCY STREET- Engineering Services 0 0 0 419.45 02-410-3-01250-8032300 Don't Use - Sanitary - Studies 80,000 0 0 0 02-410-3-01253-8011050 ASSET MANAGEMENT - Full time Wages 0 0 18,000.00 0 02-410-3-01253-8045050 ASSET MANAGEMENT - Engineering Services 0 0 0 1297.94 02-410-3-01254-8011050 I/I PROGRAM - Full time Wages 15,000 0 15,000.00 3251.47 02-410-3-01254-8015000 I/I PROGRAM - Employee Benefits 0 0 0 914.51 02-410-3-01254-8030750 I/I PROGRAM - Parts 0 0 0 589.1 02-420-0-00853-8045050 PERCY ST. - Engineering Services 0 0 0 1016.07 02-New TREATMENT/COLLECTION CAPITAL Total Warkwoth Sanitary Capital Expenditures 70,000 66,617 8,802 24,772.57 TOTAL WARKWORTH SANITARY SEWER SYSTEM 116,742 57,517 22,965 (103,328.88) ============== ============== ============= ==============
Net Surplus/Deficit - Water/Wastewater Systems
3,684,836
5,622,672
-873,686
1,559,183.56
10,000 4,024 300 250 2,500 200 450 2,500 10,224 100 1,000 1,100 1,500 2,097 2,226 2,812 8,635 4,118 4,118 0 92,561 43,586 CO CO CO CO CO 43,586 58,178 =============
320,794
-2,125
4,590
0
8,635
9,663
Page 18 of32 12/11/2008
Page 19 of32 12/11/2008
Levy Wages Water/Waste Wages
(354,655) 6,345,664.05 #REF! #REF! #REF! #REF! #REF! Levy Wages 1,894,049 Water/Waste Wages
3,141,990 #REF! #REF! #REF! 5,388,685
#REF! 184.51%
Municipality of Trent Hills Total Campbellford Water - Revenue Total Campbellford Water - Expenditures C. Water - Administration C. Water - Billing & Collecting C. Water - Truck Maintenance C. Water - Filtration Plant C. Water - Water Tower C. Water - Watermain Maintenance C. Water - Water Service Maintenance C. Water - Locates C. Water - Disconnect/Reconnect C. Water - Hydrant Maintenance C. Water - Water Meter Maintenance C. Water - Health/Safety/Training C. Water - On Call C. Water - Misc. Other Mun. Total Campbellford Water - Expenditures Total Campbellford Water - Capital TOTAL CAMPBELLFORD WATER SYSTEM Total Warkworth Water - Revenue Total Warkworth Water - Expenditures W/W Water - Administration W/W Water - Billing & Collecting W/W Water - Truck Maintenance W/W Water - Filtration Plant W/W Water - Water Tower W/W Water - Watermain Maintenance W/W Water - Water Service Maintenance W/W Water - Locates W/W Water - Disconnect/Reconnect W/W Water - Hydrant Maintenance W/W Water - Water Meter Maintenace W/W Water - Health/Safety/Training W/W Water - On Call W/W Water - Other Munic. Total Warkworth Water - Expenditures Total Warkworth Water Capital Expenditures TOTAL WARKWORTH WATER SYSTEM Total Hastings Water - Revenue Total Hastings Water Expenditures H. Water - Administration H. Water - Billing & Collecting H. Water - Truck Maintenance H. Water - Filtration Plant H. Water - Water Tower H. Water - Watermain Maintenance H. Water - Water Service Maintenance H. Water - Locates
2007 BUDGET
2007 2008 BUDGET Year End -1,145,647 -771,371 -1,124,352 0 0 0 155,925 562,091 172,976 57,446 0 24,541 7,254 0 11,000 236,640 0 268,866 19,071 0 19,413 28,503 0 21,877 15,609 0 31,758 2,843 0 6,723 $880 $0 $1,591 5,078 0 8,933 5,000 0 13,313 16,338 0 4,173 5,596 0 7,729 2,500 0 23,467 558,683 562,091 616,360 646,490 162,313 0 59,526 -46,967 -507,992 ============== ============== ============= -239,061 -242,275 -230,442 0 0 0 59,520 211,836 65,715 9,420 0 10,185 6,184 0 4,000 105,000 0 86,316 $895 $0 $4,278 6,000 0 6,046 3,781 0 9,152 $400 $0 $3,020 $273 $0 $663 1,528 0 3,284 $535 $0 $2,378 5,766 0 1,726 2,084 0 3,130 $0 $0 $8,533 201,386 211,836 208,426 400,870 393,924 -49,170 363,195 363,484 -71,186 ============== ============== ============= -461,277 -491,145 -423,970 0 0 0 84,200 322,002 82,884 16,380 0 10,317 4,771 0 5,000 131,580 0 125,756 5,269 0 5,786 16,364 0 8,823 4,600 0 16,023 1,051 0 3,449
H. Water - Disconnect/Reconnect. H. Water - Hydrant Maintenance H. Water - Water Meter Maintenance H. Water - Health/Safety/Training H. Water - On Call H. Water - Other Munic. Total Hastings Water - Expenditures Total Hastings Water Capital Expenditures TOTAL HASTINGS WATER SYSTEM
$583 $0 $782 2,082 0 4,266 5,219 0 3,022 7,240 0 2,043 2,495 0 3,857 $0 $0 $10,667 281,834 322,002 282,675 186,097 -352,806 -153,580 6,654 -521,949 -294,875 ============== ============== ============= Total Campbellford Sanitary Sewer Revenue -1,009,412 -741,835 -1,171,012 Total Campbellford Sanitary Sewer Expenditures 0 0 0 C. Sanitary - Administration 91,819 540,504 149,851 C. Sanitary - Sewer Flushing 15,000 0 39,576 C. Sanitary - Sewer Collapse/Lat 26,805 0 1,000 C. Sanitary - CCTV 15,000 0 15,200 C. Sanitary - Sewer REpairs 20,000 0 42,373 C. Sanitary - Flow Monitoring 10,000 0 10,000 C. Sanitary - Sewer Locates 2,000 0 2,018 C. Sanitary - Treatment 281,876 0 469,913 C. Sanitary - Biosolids 82,537 0 0 C. Sanitary - Sewer Maintenance 2,000 0 2,968 C. Sanitary - Billing/Collections $0 $0 $0 C. Sanitary - Corewall Inspect. & Repair 20,000 0 0 C. Sanitary - Manhole Repairs/ Adj. 5,000 0 0 C. Sanitary - On Call 3,681 0 0 Total Campbellford Sanitary Sewer Expenditures 575,718 540,504 732,899 Total Campbellford Sanitary Capital Expenditures 1,217,616 5,855,737 426,614 TOTAL CAMPBELLFORD SANITARY SEWER 783,922 5,654,406 -11,499 ============== ============== ============= Total Hastings Sanitary Sewer Revenues -390,785 -292,044 -386,012 Total Hastings Sanitary Sewer Expenditures 0 0 0 H. Sanitary - Administration 93,433 278,350 36,366 H. Sanitary - Sewer Flushing 6,800 0 7,000 H. Sanitary - Sewer Collapse/Lat 4,500 0 4,000 H. Sanitary - CCTV 6,800 0 2,000 H. Sanitary - Sewer Repairs 21,000 0 11,000 H. Sanitary - Flow Monitoring 2,000 0 2,000 H. Sanitary - Sewer Locates $775 $0 $100 H. Sanitary - Treatment 145,274 0 292,708 H. Sanitary - Arena Pump #1 $0 $0 $5,459 H. Sanitary - Biosolids 11,000 0 0 H. Sanitary - Manhole Repairs $0 $0 $0 H. Sanitary - Billing/Collections $0 $0 $3,808 H. Sanitary - Sewer Maintenance 0 0 0 H. Sanitary - On Call 0 0 0 Total Hastings Sanitary Sewer Expenditures 291,582 278,350 364,441 Total Hastings Sanitary Capital Expenditures 2,454,000 129,875 0 TOTAL HASTINGS SANITARY SEWER SYSTEM 2,354,797 116,181 -21,571 ============== ============== ============= Total Warkworth Sanitary Sewer Revenue -70,831 -71,023 -68,735 Total Warkworth W/W Sanitary - Administration 0 0 0
W/W Sanitary - Sewer Flushing 39,561 61,923 37,939 W/W Sanitary - Sewer Collapse/Lat 5,000 0 5,000 W/W Sanitary - CCTV 8,500 0 3,500 W/W Sanitary - CCTV 5,400 0 5,000 W/W Sanitary - Sewer Repairs 10,000 0 11,000 W/W Sanitary - Flow Monitoring 1,500 0 1,500 W/W Sanitary - Sewer Locates $500 $0 $100 W/W Sanitary - Treatment 29,112 0 12,125 W/W Sanitary - Arena Pump #1 9,950 0 5,634 W/W Sanitary - George St Pump #2 2,300 0 1,100 W/W Sanitary - Sewer Maintenance 5,750 0 0 W/W Sanitary - Billing/Collections $0 $0 $0 W/W Sanitary - On Call 0 0 0 Total Warkworth Sanitary Sewer Expenditures 117,573 61,923 82,898 Total Warkwoth Sanitary Capital Expenditures 70,000 66,617 8,802 TOTAL WARKWORTH SANITARY SEWER SYSTEM 116,742 57,517 22,965 ============== ============== =============
Net Surplus/Deficit - Water/Wastewater Systems 3,684,836 5,622,672
-884,158
2007 Capital -507,992 -11,499 -294,875 0 -71,186 8,802 -876,750
Total -507,992 415,116 -448,456 364,441 -120,357 91,700 -205,547
Operations Campbellford Water Campbellford Sewage Hastings Water Hastings Sewage Warkworth Water Warkworth Sewage Total
0 426,614 -153,580 364,441 -49,170 82,898 671,203
2008 2009 To Nov 30/08 Draft Budget (991,768.31) -1,124,352 0 119,513.12 157,032 29,015.74 22,383 10,000 213,400.00 263,979 23,698.18 22,855 23,038.12 24,690 43,074.60 35,933 3,624.20 6,859 1,113.16 $1,629 4,346.60 17,750 2,708.14 7,833 147.10 4,317 6,020.45 7,891 130.84 23,925 469,830.25 607,076 134,757.86 72,122 (387,180.20) -445,154 ============== ============= (290,554.25) -230,442 38,800.44 59,997 3,313.85 9,083 3,500 96,288.01 91,923 1,277.52 $4,378 4,688.50 6,196 1,347.14 9,370 896.23 $2,877 419.17 $679 1,155.71 5,875 1,294.65 $2,578 67.79 1,786 2,202.58 3,259 $8,700 151,751.59 210,201 15,022.76 118,418 (123,779.90) 98,177 ============== ============= (386,328.00) -423,970 0 59,715.91 78,796 7,663.53 7,692 3,500 117,587.53 128,170 7,963.63 5,904 11,117.43 11,600 7,524.33 16,281 978.51 3,365
Rev Debt -1,180,570
Capital
47,122
25,000
113,418
5,000
-241,964
-445,169
1,303.73 $801 3,571.59 6,473 2,950.48 5,381 67.79 2,113 2,723.23 3,860 $10,875 223,167.69 284,811 (139,266.54) 175,856 (302,426.85) 36,697 ============== ============= (842,171.47) -957,031 0 300,004.39 114,637 6,775.04 15,943 2,412.62 17,824 5,520.09 15,743 12,865.20 33,014 4,285.17 24,649 4,382.31 4,572 89,503.34 475,068 0 335.66 4,645 399.88 $15,557 0 0 3,183.21 0 429,666.91 721,652 1,719,256.60 664,419 1,306,752.04 429,040 ============== ============= (376,193.66) -395,012 0 220,878.36 33,249 1,410.07 3,591 6,421 220.17 2,091 1,981.84 5,682 156.29 5,629 2,396.39 $1,027 24,248.97 295,854 $4,151 0 $927 2,479.23 $3,530 911 0 253,771.32 363,063 1,291,569.69 175,805 1,169,147.35 143,856 ============== ============= (189,067.92) -77,969 0
170,856
5,000
-1,004,883
621,594
42,825
154,605
21,200
-414,763
-81,867
14,198.87 33,940 4,196.75 4,000 64.06 1,500 2,361.41 4,671 8,245.87 6,017 1,125.37 6,045 1,129.84 $2,311 5,423.17 10,000 13,263.28 10,224 1,100 10,158.10 8,635 799.75 $4,118 0 60,966.47 92,561 24,772.57 43,586 (103,328.88) 58,178 ============== ============= Total Capital Total Debt
1,559,183.56
320,794 Rev
43,586
0 Err:522
1,151,181
-3,208,776
-3,369,215 -3,537,676 -160,439 -168,461
Operations
Operations 72,122 664,419 175,856 363,063 118,418 92,561 1,486,439
2008 Capital -445,154 429,040 36,697 175,805 98,177 43,586 338,151
Total -373,032 1,093,459 212,553 538,868 216,595 136,147 1,824,590
Operations 72,122 237,805 329,436 -1,378 167,588 9,663 815,236
Difference Capital 62,838 440,539 331,572 175,805 169,363 34,784 1,214,901
-3,714,559 -3,900,287 -176,884 -185,728
Total 134,960 678,343 661,009 174,427 336,951 44,447 2,030,137
CAMPBELLFORD WATER SYSTEM
Updated December 2009
Municipality of Trent Hills Public Works Dept.
Campbellford Water System Program - 10 year Forecast Water Distribution System & Water Tower
Project No. Watermain Replacements (Cast Iron) 1 Balaclava St. - Simpson St to Pellisier St 2 Burnbrae Rd. West - Centre St to Dead end 3 Booth St.- Second St to 100 m n. of River St 6 Canrobert St. - Bridge St to Garry St 7 Church St. - Kent St to 495 m Northwest 10 Cromwell St. - Market St to Isabella St 11 Circle Dr. - Elmore St. to 45 m East 12 Doxee St. - Second St to River St 13 Doxee St. - Bridge St to Market St 17 First St. - Centre St to King St 18 Front St. - Major St to Arena 22 Inkerman St. - Raglan to Canrobert St. 23 Inkerman St . Pellsier St. to Raglan St. 25 Isabella St. - Oliver st to Cromwell St Isabella St. - Cromwell st to Steelcrest St Kent St. - Church St. to dead end 28 King St. - First St to 50 m North 29 King St. - First St to 135m Southeast Leonard's Lane 31 Market St. - Cromwell St. to Steelcrest Rd. 34 Napier St. - Queen St. to Kent St. 35 Nelson St. - Queen St. to Dead end 37 Oliver St. - Isabella to Major St. 38 Pellisier St. - Alma St to Balaclava St 39 Pellisier St. - Balaclava St. to Inkerman St. 40 Pellsier St. - Inkerman St. to Bridge St. Portage Street 44 Ranney St. - Market St to Bridge St 44 Ranney St. - River St. to Bridge St. 46 River St. - Booth St to Centre St 47 Richard St. - Garry St to dead end 49 Saskatoon Ave. - River Crossing to Dead end 53 Victoria St. - Grand Road to Albert Lane 54 Victoria St. - Grand Road to 454 m West 56 Wallace St. - Henson Rd to Alma St 58 Easement No. 9 - First St to 85 m Southeast Project No. Watermain Looping (New mains) 1 Burnbrae Rd. - to Burnbrae Gardens 3 Garry St. - Pellisier St to Raglan St 4 Kent St. - Wellington St. to Napier St. St. Kent St. - Napier St. to Church St. 5 King St. - Dead end to First St. 6 Pellisier St. Bridge St. to Garry St. 7 River St. - Booth St to 50 m West 8 Roscoe Ave. - First St. to Burnbrae Rd. 9 Trent Drive - Parklane Blvd.to Gair, Tanner Rd. 10 Union St. - Market St to Naseby St 11 Rupert St.. - Hillcrest St to Naseby St 12 Wilcox St. - Grand Rd to Henson Rd
Notes:
Length Comments 140 m - 200 mm 210 m - 150 mm 320 m - 200 mm 100 m - 200 mm 495 m - 200 mm 150 m - 150 mm 45 m - 150 mm 180 m - 200 mm 300 m - 200 mm 125 m - 150 mm (repl. 100 mm) 150 m - 200 mm 120 m - 150 mm 130 m - 150 mm 100 m - 200 mm 100 m - 200 mm 100 m - 200 mm 50 m - 150 mm (repl. 100 mm) 135 m - 150 mm 80 m - 50 mm 175 m - 200 mm 100 m - 200 mm 90 m - 200 mm 140 m - 200 mm 150 m - 150 mm 60 m - 150 mm 80 m - 150 mm 150 m - 150 mm 250 m - 200 mm 150 m - 150 mm 70 m - 200 mm 100 m - 150 mm (repl. 100 mm) 120 m - 150 mm 70 m - 200 mm 350 m - 200 mm 100 m - 150 mm 85 m - 150 mm (repl. 100 mm) Comments 250 m - 200 mm 85 m - 150 mm 180 m - 300 mm 100 m - 300 mm 120 m - 150 mm 110 m - 150 mm 50 m - 150 mm 170 m - 150 mm 350 m - 200 mm 210 m - 150 mm 100 m - 150 mm 260 m - 200 mm
General Upgrades Water Meter Replacement Old Meters/Breakdowns Mapping, drawings &studies Annual Fire hydrant Painting maintenance issue Water Tower Painting & Repairs Internal lining Repairs Watermain Design Watermain Repairs & Upgrades 12,906 metres 1. All estimates are preliminary and are subject to more detailed review.
Priority 2015 2010 2018 2011 2018 2009 2013 2014 2013 2010 2008 2016 2016 2009 2010 2009 2010 2010 2008 2008 2011 2011 2009 2019 2019 2019 2019 2019 2015 2011 2009 2012 2012 2012 2010 Priority 2013 2011 2012 2010 2019 2015 2013 2017 2017 2017 2017
2014 2008 2008
Project No.
Water plant Upgrades Comments Building Repairs 1 GAC Replacement 3 Year cycle THM Optimization Study High Lift Pump Repairs Breakdown Maintenance Upgrade SCADA System Dakins Engineering Study Asset Management DWQMS Clarifier Repairs & Painting Maintenance (prolong system life ) Notes: 1. All estimates are preliminary and are subject to more detailed review.
2008 2008 2008 2008 2008 2008 2008 2008
Cost/Estimate $80,500 $115,500 $184,000 $57,500 $284,625 $82,500 $24,750 $103,500 $172,500 $68,750 $125,000 $66,000 $71,500 $57,500 $57,500 $57,500 $27,500 $74,250 $25,000 $113,124 $57,500 $51,750 $80,500 $82,500 $33,000 $44,000 $82,500 $143,750 $82,500 $40,250 $55,000 $60,000 $40,250 $201,250 $55,000 $46,750
2009
Estimate $143,750 $46,750 $144,000 $80,000 $66,000 $60,500 $27,500 $93,500 $199,500 $115,500 $55,000 $149,500
2009
Capital Loan Payments
2011
2012
2013
2014
2015 80,500 115,500
2016
2017
2018
2019
2020 184,000
57,500 284,625 82,500 24,750 103,500 172,500 68,750 66,000 71,500
27,500 74,250 57,500 51,750 82,500 33,000 44,000 143,750 82,500 40,250 55,000 60,000 40,250 201,250 55,000 46,750 2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
66,000 $60,500 27,500
$50,000 $1,474 $7,000 $100,000 $53,000 $7,500,739
Estimate $10,000 $55,000 $10,000 $15,000 $110,000 $32,500 $27,500 $15,000 $265,000
2010
200,000
$-
2009
$-
2010
$-
2011
$-
2012
$-
2013
200,000
200,000
200,000
200,000
200,000
200,000
200,000
$1,217,250
$678,500
$400,000
$857,125
$240,250
2015
2016
2017
2014
60,000
2018
$523,250
2019
64,500
$244,500
2020 69,338
15,000
$15,000
10,000 $25,000
50,000 $65,000
50,000 $50,000
$60,000
$47,171
$47,171
$47,171
$47,171
$47,171
$47,171
$47,171
$47,171
$47,171
$47,171
$47,171
$47,171
$72,171
$112,171
$97,171
$107,171
$47,171
$1,264,421
$725,671
$511,671
$904,296
$287,421
$570,421
$361,009
$512,171 (440,000)
$512,171 (400,000) (840,000)
$512,171 (415,000) (815,000)
$512,171 (405,000) (820,000)
$512,171 (465,000) (870,000)
$512,171 752,250 287,250
$512,171 213,500 965,750
$512,171 (500) 213,000
$512,171 392,125 391,625
$512,171 (224,750) 167,375
$512,171 58,250 (166,500)
$512,171 (151,163) (92,913)
$-
$-
$-
$64,500
$-
$-
$-
$69,338
Reserves TOTALS
Grand Total
$7,765,739
25,608.55
WARKWORTH WATER SYSTEM
Updated October 2008
Municipality of Trent Hills Public Works Dept. Water Distribution System Project No. Description 2 Main St. - Bridge to Concession St. 3 Water Tower trunk main 4 Church St. - Main St. to George St. 5 Church St. - Main St. Centre St. 6 Church St. - Centre St. to East St. 7 Church St. - East st. to 200 m east 8 Mill St. - George St. to Old Hastings Rd. 9 Mill St. - Old Hastings Rd. to Cty Rd. 25 10 Mill St. - Cty Rd. 25 to West St. 11 Mill St. - West St. to 150 m west 12 Banta Rd. - WTP to Mill St. 13 Old Hastings Rd. - Mill St. to Cnty Rd. 2 15 Percy St. - Old Hastings Rd. to 170 m north 16 George St. - Church St. to 300 m south 17 Centre St. - Main St. to East St. 18 Centre St. - Church St. to East St. 19 Walter St. - George St. to Benfield St. 20 Benfield St. - Walter St. to Mill St. General Upgrades Leak Detection Program Water Distribution Needs Study Booster pumping Station
Comments Priority Estimate 2008 75 m - 200 mm (Looping) $71,250 140 m - 250 mm (AC replacement, upgrade $112,000 from 200 mm) 90 m - 250 mm (AC replacement, upgrade $72,000 from 200 mm) 140 m - 250 mm (AC replacement, upgrade $91,000 from 150 mm) 135 m - 200 mm (AC replacement, upgrade $77,625 from 150 mm) 200 m - 200 mm (AC replacement, upgrade $115,000 from 150 mm) 80 m - 250 mm (AC replacement, upgrade $52,000 from 200 mm) 300 m - 200 mm (AC replacement, upgrade $172,500 from 150 mm) 140 m - 200 mm (AC replacement, upgrade $80,500 from 150 mm) 150 m - 150 mm (AC replacement) $82,500 890 m - 200 mm (AC replacement, upgrade $511,750 from 150 mm) 810 m - 200 mm (AC replacement, upgrade $280,656 from 150 mm) 170 m - 150 mm (AC replacement) $93,500 300 m - 200 mm (AC replacement, upgrade $172,500 from 150 mm) 110 m - 200 mm (AC replacement, upgrade $63,250 from 150 mm) 200 m - 150 mm (AC replacement) $110,000 175 m - 150 mm (AC replacement) $96,250 85 m - 150 mm (watermain loop, eliminates $46,750 dead-ends)
2 year cycle Identify priorities Old Hastings Rd. Orchard Hills Development Fencing - security
Water Tower Upgrades Digital Mapping
4715 metres
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
$40,000
$15,000
15,000
$2,656,763
$15,000
$-
$-
$-
$-
$-
$-
$-
$-
$-
$-
$-
$-
Notes: 1. All estimates are preliminary and are subject to more detailed review. Water Treatment Plant Water Treatment Plant Rehabilitation Project No. Description Comments Priority Estimate 2008 2009 Building Improvements $5,000 5,000 Furniture/Fixtures $10,000 10,000 SCADA Upgrades/Computor Software $5,000 5,000 5,000 1 GAC Replacement 5 Year cycle $15,000 15,000 13 Stairs to Clarifier and filters safety Assurance Issue $5,000 14 THM Optimization Study $10,000 10,000 15 Asset Management $10,000 10,000 DWQMS $10,000 10,000 Notes: 1. All estimates are preliminary and are subject to more detailed review. $701,336 $65,000 $5,000 Long Term Debt Long Term Debt
2010
$-
2011
2012
$-
2013
$-
2014
$-
$-
2015
$-
2016
$-
2017
$-
2018
$-
2019
$-
2020
$-
$69,925
$113,418
$113,418
$113,418
$113,418
$113,418
$113,418
$113,418 $113,418
$113,418 $113,418 $113,418 $113,418
$149,925
$118,418
$113,418
$113,418
$113,418
$113,418
$113,418
$113,418 $113,418
$113,418 $113,418 $113,418 $113,418
Reserves TOTALS
$3,358,099
HASTINGS WATER SYSTEM Municipality of Trent Hills Public Works Dept. Water Distribution System & Tower Project No. Watermain Replacement Units Comments Priority Estimate 2008 2009 2010 1 Easemenmt - WTP to Front St. 80 m - 250 mm 2009 $48,000 $$2 Front St. - William St. to Elizabeth St. 138 m - 250 mm 2009 $89,700 3 Front St. - Elizabeth St. to New St. 168 m - 250 mm 2010 $117,600 4 Front St. - New St. To Hope St. 121 m - 250 mm 2011 $84,700 5 Front St. - Hope St. To Trent St. 114 m - 250 mm 2012 $79,800 6 Front St. - Trent St. To Bridge St. 155 m - 250 mm 2013 $108,500 7 Front St. - Bridge St. To Victoria St. 149 m - 200 mm 2019 $85,675 8 Front St. - Victoria St. To Dead end 200 m - 200 mm 2019 $115,000 11 Albert St. - Victoria St to Wellington St 150 m - 200 mm 2016 $86,250 12 Albert St. - Wellington St to Nelson St 155 m - 200 mm 2017 $89,125 14 Victoria St - Albert St to Front St 215 m - 150 mm 2020 $123,625 16 Bridge St. - Water St to Bay St 262 m 250 mm (upgrade from 150 2014 mm) $183,400 17 Bridge St. - Bay St to Queen St 150 m 250 mm (upgrade from 150 2015 mm) $105,000 22 Clyde St. - Water St to Bay St 322 m - 150 mm $177,100 23 Park St. - Water St to Bay St 287 m - 150 mm $157,850 24 Bay St. - Bridge St to Park St 159 m - 150 mm $87,450 25 Bay St. - Park St to Clyde St 144 m - 150 mm $79,200 22 Queen St. - Bridge St. to Argyle St. 120 m - 150 mm $66,000 24 Baker St. - Bridge St. to 80 m West 80 m - 150 mm $44,000 25 Wellington St. - Albert St. to Division St. 120 m - 150 mm $66,000 26 Nelson St. - Albert St. to Division St. 80 m - 150 mm $44,000 Watermain Looping (New mains) 27 Wellington St. - Albert St. to Front St. 200 m - 150 mm $110,000 28 2 nd River Crossing 460 m - 400 mm (120 m bore under river) $25,000 25,000 29 3 rd River Crossing - Parklane to Homewood 330 m - 400 mm (140 m bore under river) General Upgrades 30 Leak Detection Program 31 Fire Hydrant Painting 33 Corner Drawings/Digital Mapping 37 Water Tower Repairs/Replacement Notes: 1. All estimates are preliminary and are subject to more detailed review.
2011
2012
2013
2014 48000
2015
2016
2017
2018
2019
2020
117,600 84,700 79,800 108,500 85,675 115,000 86,250 89,125 123,625 183,400 105,000
-
2 year cycle Develop digital systems mapping; Fence, Lining repairs 5,819 meters
$3,123,433
11,956 $36,956
$-
$-
$-
$-
$-
$622,000
$105,000
$86,250
$89,125
$85,675
2016
2017
2018
$115,000
$123,625
HASTINGS -(con't) Water Treatment Plant Project No. Description Units Comments Building Maintenance Co2 Filters 2 GAC Replacement 4 Year cycle 3 THM Optimization Study 4 Equipment Purchases/Filter CO2 cleaning DWQMS Asset Management SCADA Upgrades Notes: 1. All estimates are preliminary and are subject to more detailed review.
Water Treatment Plant Rehabilitation Priority 2008 2008 2008 2008 2008 2008 2009
Estimate $5,000 $22,000 $10,000 $7,000 $12,500 $12,500 $5,000 $3,340,987
LTD (Debts as of Jan. 2003) Long Term Debt
2008 5,000 22,000 10,000 7,000 12,500 12,500
2009
2010
2011
2012
2013
2014
2015
30,000
$69,000
5,000 $5,000
$170,856
$170,856
$170,856
$170,856
$170,856
$170,856
$276,812
$175,856
$170,856
$170,856
$200,856
$170,856
$-
$-
$30,000
2019
30,750
$-
$-
2020 31,519
$10,000
$30,750
$-
$-
$-
$41,519
$170,856
$170,856
$170,856
$170,856
$170,856
$170,856
$170,856
$792,856
$285,856
$287,856
$259,981
$256,531
$285,856
$336,000
Reserves TOTALS
$6,464,420
Yellow is cut completely from budget. Green is carry-over Red is cut from proposed 2009 due to current budget's lack of funding. Blue is cut if necessary. The watermain work proposed in Hastings for 2009 was coordinated with road work in the roads budget. The dist. needs study proposed for Warkworth was originally set at $40,000. I revised this amount to $20,000 which should be enough for the assessment required and flow testing.
12/11/2008 WASTEWATER COLLECTION SYSTEM FORECAST
CAMPBELLFORD STREET DESCRIPTION Oliver Market - Isabella Market - Isabella Oliver Isabella - Major Isabella - Major Isabella Oliver - Cromwell Oliver - Cromwell Major Oliver - Front O N liver - Front N L. Garry Wellington-Canrobert Wellington-Canrobert Canrobert Bridge - Kent Richard all First King - Centre Simpson Balaclava - Creek Victoria Grand Rd - Albert Victoria Albert - to end Doxsee N Bridge - Market Circle Dr. all Doxsee S River - 2nd St Raglan S Bridge - Inkerman Raglan S Inkerman - Balaclava Raglan S Balaclava - Grand Rd Raglan N Bridge - end Balaclava Simpson - Pellissier River St Booth - Ranney Inkerman Canrobert- Raglan Inkerman Pellissier - Raglan Frank St. all Saskatoon 2nd St. - soccer field Booth River - culdesac Church Queen - Kent Albert L Carlaws - Victoria Albert L Carlaws - Grand Ranney N Bridge - Market Ranney S Bridge - 2nd St. Pellissier all Portage Garry - 150 m Inkerman Simpson - Pellissier TOTAL SEWER COLLECTION SYSTEM TREATMENT (PLANT) CAPITAL PUMP STATION CAPITAL DEBT REPAYMENT TOTAL
Length
CS 161 yes 161 yes 92 yes 130 no 215 yes 135 yes 75 yes 125 yes 50 yes 70 yes 300 yes 335 no 50 yes 182 no 100 yes 100 yes 50 yes 110 yes 126 yes 115 yes 200 yes 180 yes 185 yes 160 yes 140 yes 118 yes 100 yes 80 yes 315 no 367 no 280 no 150 no 145 no
Priority Estimate BCP(FED/PROV) 1 $100,000 $66,666 1 $100,000 $66,666 1 $93,750 $62,500 2 $87,500 $58,333 2 $133,500 3 $74,250 3 $41,250 3 $68,750 3 $27,500 4 $38,500 4 $165,000 5 $184,250 5 $27,500 6 $100,100 6 $55,000 6 $55,000 7 $27,500 7 $60,500 7 $69,300 7 $63,250 8 $110,000 8 $99,000 9 101,750 9 88,000 10 $77,000 10 $64,900 10 $55,000 11 $44,000 11 $173,250 12 $210,850 13 $154,000 13 $43,000 14 $79,500 $2,872,650 $254,165 $58,900 $16,750 $$5,820,950 $508,330
CAPITAL BUDGET Sur/Def
2009
2010
2011
2012
2013
2014 $100,000 $100,000 $93,750 $87,500 $133,500 $74,250 $41,250 $68,750 $27,500 $38,500
2015
2016
2017
2018
2019
2020
$165,000 $184,250 $27,500 $100,100 $55,000 $55,000 $27,500 $60,500 $69,300 $63,250 $110,000 $99,000 $101,750 $88,500 $77,000 $64,900 $55,000 $44,000 $173,250 $210,850 $154,000 $43,000 $79,500
. $$26,075 $16,750 $621,594 $664,419 $664,419 $-
$$30,000 $16,750 $621,594 $668,344 $780,000 $(111,656) $(111,656)
$$35,000 $16,750 $621,594 $673,344 $780,000 $(106,656) $(218,312)
$$40,000 $16,750 $621,594 $678,344 $780,000 $(101,656) $(319,968)
$$45,000 $16,750 $621,594 $683,344 $780,000 $(96,656) $(416,624)
$892,600 $50,000 $16,750 $621,594 $1,580,944 $780,000 $800,944 $384,320
$137,500 $55,000 $16,750 $621,594 $830,844 $800,000 $30,844 $415,164
$165,000 $60,000 $16,750 $621,594 $863,344 $830,000 $33,344 $448,508
$184,250 $60,000 $16,750 $621,594 $882,594 $860,000 $22,594 $471,102
$193,050 $60,000 $16,750 $621,594 $891,394 $890,000 $1,394 $472,496
$209,000 $60,000 $16,750 $621,594 $907,344 $920,000 $(12,656) $459,840
$190,250 $60,000 $16,750 $621,594 $888,594 $950,000 $(61,406) $398,434
0 0 2500 2500
0 0 2500 2500
$43,586 48586 48586 $$-
$43,586 48586 55000 $(6,414) $(6,414)
0 0 2500 2500 0 $43,586 48586 55000 $(6,414) $(12,828)
0 0 2500 2500 0 $43,586 48586 55000 $(6,414) $(19,242)
30000 30000 5000 5000 23000 $16,954 79954 55000 $24,954 $5,712
5000 5000 5000 5000 23000 $16,954 54954 55000 $(46) $5,666
5000 5000 5000 5000 23000 $16,954 54954 55000 $(46) $5,620
5000 5000 5000 5000 23000 $16,954 54954 55000 $(46) $5,574
5000 5000 5000 5000 23000 $16,954 54954 55000 $(46) $5,528
5000 5000 5000 5000 23000 $16,954 54954 55000 $(46) $5,482
5000 5000 5000 5000 23000 $16,954 54954 55000 $(46) $5,436
0 0 $$15,000 $5,000 $154,605 174605 174605 $$-
0 0 $$15,000 $5,000 $154,605 174605 190000 $(15,395) $(15,395)
0 0 $$15,000 $5,000 $154,605 174605 190000 $(15,395) $(30,790)
0 0 $$15,000 $5,000 $154,605 174605 190000 $(15,395) $(46,185)
37500 37500 $$15,000 $5,000 $154,605 212105 190000 $22,105 $(24,080)
7500 7500 $$15,000 $5,000 $154,605 182105 195000 $(12,895) $(36,975)
7500 7500 $$20,000 $5,000 $154,605 187105 200000 $(12,895) $(49,870)
7500 7500 $$25,000 $5,000 $154,605 192105 205000 $(12,895) $(62,765)
7500 7500 $$30,000 $5,000 $154,605 197105 210000 $(12,895) $(75,660)
7500 7500 $$35,000 $5,000 $154,605 202105 215000 $(12,895) $(88,555)
7500 7500 $$40,000 $5,000 $154,605 207105 220000 $(12,895) $(101,450)
WARKWORTH George Mill-Walter George Conc. St. W-Walter Reserve for future work TOTAL SEWER COLLECTION SYSTEM TREATMENT (LAGOON) CAPITAL PUMP STATION CAPITAL SANITARY SYSTEM DEBT REPAYMENT TOTAL
1 1
5000 5000
-
10000 $$-
0
$20000
0
Sur/Def
0 0 0 $43,586 43586 43586 $-
HASTINGS Front West Elizabeth - Park lane RES TOTAL SEWER COLLECTION SYSTEM STUDY -I/I PROGRAM TREATMENT (PLANT) CAPITAL PUMP STATION CAPITAL DEBT REPAYMENT TOTAL
1
25000 10000 35000 $$$-
0 0 0
$70000 Sur/Def
0
0 $$12,200 $9,000 $154,605 175805 175805 $-