Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
FY 2013 TCMUD 1 Approved Budget
General Fund Fire Fund Debt Service Fund Revenue 6,103,627 Revenue 33,450 Revenue 318,617 FY 2012 Tax Collections 99,884 FY 2012 Tax Collections 1,050,349 FY 2012 Tax Collections 196,940 Reserve Funds 305,748 FY 2012 PID Assessment 252,084 PID Utility Fees (Reserve)345,000 Total Revenue 6,509,259 Reserve Funds 0 0 Water Expense 3,821,431 Total Revenue 1,335,882 Total Revenue 860,557 Wastewater Expense 1,039,428 Fire Expense 1,335,882 Debt Service Expense 838,033 Collections Expense 459,887 Board of Directors Expense 26,575 Administration Expense 1,051,838 Non-Departmental Expense 110,100 Total Expense 6,509,259 Total Expense 1,335,882 Total Expense 838,033 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 22,525 2012 2013 General Fund Tax 0.00989 0.00989 I & S (Debt Service) Tax 0.05586 0.01950 Fire Tax 0.10925 0.10400 Total Tax Rate:0.17500 0.13339 Reduction:-0.04161 PID Fire Assessment Rate 0.10925 0.10400 Reduction:-0.00525 Tax Rate Summary Budget Summary TROPHY CLUB M.U.D. NO. 1 FY 2013 BUDGET APPROVED 9/18/2012 Trophy Club MUD No. 1 FY 2013 Budget - Proposed September 18, 2012 GENERAL FUND Account Description FY 2012 Original FY 2012 ADOPTED Budget Amended FY 2013 Comments General Fund Revenues 135-40000-000-000 Property Taxes -97,495 -97,495 99,884 135-40002-000-000 Property Taxes/Delinquent -451 500 135-40015-000-000 Property Taxes/P & I -1,334 -200 1,200 135-43215-000-000 Insurance Settlement 0 -3,999 0 135-47000-000-000 Water -3,282,395 -3,357,395 3,545,609 135-47005-000-000 Sewer -1,881,807 -1,946,907 1,653,747 135-47010-000-000 Commercial Water 0 0 0 Account combined with 135-47000-000-000 135-47015-000-000 Commercial Sewer 0 0 0 Account combined with 135-47005-000-000 135-47020-000-000 Standby -775 -775 576 8 lots x $6 per month 135-47025-000-000 Penalties -50,800 -45,000 64,580 See Schedule GF-D 135-47030-000-000 Service Charges -17,500 -15,000 11,625 See Schedule GF-D 135-47035-000-000 Plumbing Inspections -1,200 -1,500 1,800 135-47045-000-000 Sewer Inspections -4,500 -4,500 5,200 135-47070-000-000 TCCC Effluent Charges -57,500 -75,000 77,575 Based on monthly average of 9.75 MG @ 135-47270-000-000 Fire Line -5,000 0 0 Miscoded to GF FY 2012: Previous years in Fire Department and moved there in FY 2012 Budget Amend #3 135-47400-000-000 Water-Out of Dist/Port Meters 0 0 0 Account combined with 135-47000-000-000 135-47405-000-000 Out of District Sewer 0 0 0 Account combined with 135-47000-000-000 135-47410-000-000 Out of Dist/Portable Penalties 0 0 0 Account combined with 135-47025-000-000 135-47600-000-000 PID #1 Water 0 0 0 Account combined with 135-47000-000-000 135-47605-000-000 PID #1 Sewer 0 0 0 Account combined with 135-47000-000-000 135-48005-000-000 Utility Fees -338,880 -621,000 644,000 Based on 280 connections in FY 2013 135-49005-000-000 Loan Proceeds 0 -1,100,000 0 GST expansion loan 135-49010-000-000 Interest Income -4,500 -4,500 5,500 135-49015-000-000 Fire Dept. Lease/Rental income 0 0 0 Income in Debt Service Budget 135-49016-000-000 Cell Tower Revenue -10,164 10,164 $847 per month 135-49018-000-000 Building Rent Income -7,000 -7,000 7,000 $583.33 per month: Collection Barn Rent from Town 135-49030-000-000 Vending Revenue -600 -600 350 WWTP and Collection Barn 135-49035-000-000 Prior Year Reserves -241,981 0 305,748 135-49036-000-000 GASB Reserves -26,911 -103,966 0 135-49075-000-000 Oversize Meter Reimbursement -64,000 -77,800 73,000 FY 2012 Annualized 135-49900-000-000 Miscellaneous Income -10,000 -9,705 1,000 135-49905-000-000 Gas Well Revenue -800 -123 200 Total -6,094,978 -7,483,080 6,509,259 General Fund Expenses Water 135-50005-010-000 Salaries & Wages 199,759 160,600 213,321 SEE SCHEDULE GF-H 135-50010-010-000 Overtime 13,250 13,250 13,250 SEE SCHEDULE GF-H 135-50016-010-000 Longevity 2,620 2,620 3,080 SEE SCHEDULE GF-H 135-50017-010-000 Certification 1,800 1,800 5,100 SEE SCHEDULE GF-H 135-50020-010-000 Retirement 25,508 25,508 32,725 SEE SCHEDULE GF-J 135-50026-010-000 Medical Insurance 22,607 22,607 28,920 SEE SCHEDULE GF-I 135-50027-010-000 Dental Insurance 2,169 2,169 2,091 SEE SCHEDULE GF-I 135-50028-010-000 Vision Insurance 576 576 519 SEE SCHEDULE GF-I 135-50029-010-000 Life Insurance & Other 1,161 1,161 1,204 SEE SCHEDULE GF-I 2 Trophy Club MUD No. 1 FY 2013 Budget - Proposed September 18, 2012 Account Description FY 2012 Original FY 2012 ADOPTED Budget Amended FY 2013 Comments 135-50030-010-000 Social Security Taxes 13,481 12,000 14,555 SEE SCHEDULE GF-H 135-50035-010-000 Medicare Taxes 3,153 2,700 3,404 SEE SCHEDULE GF-H 135-50040-010-000 Unemployment Taxes 945 945 945 SEE SCHEDULE GF-H 135-50045-010-000 Workman's Compensation 5,581 5,581 6,109 SEE SCHEDULE GF-H 135-50060-010-000 Pre-emp Physicals/Testing 200 200 200 135-50070-010-000 Employee Relations 350 350 350 135-55005-010-000 Engineering 1,500 500 3,000 135-55070-010-000 Independent Labor 500 0 0 135-55080-010-000 Maintenance & Repairs 63,500 29,500 50,000 Combined 135-65095-010-000 with this account 135-55090-010-000 Vehicle Maintenance 3,380 3,380 3,700 135-55100-010-000 Building Maint & Supplies 0 750 0 Combined with Maint & Repairs 135-55080 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900 2,900 2,900 135-55135-010-000 Lab Analysis 4,500 4,500 4,500 TCEQ Estimate + monthly BacT 135-60010-010-000 Communications/Pagers/Mobiles 1,599 2,100 2,000 135-60020-010-000 Electricity 162,000 100,000 162,410 SEE SCHEDULE GF-K 135-60035-010-000 Postage 0 688 0 Moved to Adminstration Expenses 135-60050-010-000 Bad Debt Expense 4,200 4,200 0 Moved to Adminstration Expenses 135-60066-010-000 Publications/Books/Subscripts 50 85 500 Need AAWA Standards Set 135-60070-010-000 Dues & Memberships 150 150 150 135-60080-010-000 Schools & Training 2,800 2,800 1,672 135-60090-010-000 Safety Program 500 500 500 135-60100-010-000 Travel & per diem 3,200 3,200 700 135-60105-010-000 Rent/Lease Equipment 500 500 500 135-60135-010-000 TCEQ Fees & Permits 6,600 33,100 35,800 Reg. Assessment ($27,800) & Water System Fees ($8000) 135-60150-010-000 Wholesale Water 1,720,000 1,720,000 2,028,449 See Schedule GF-C 135-60245-010-000 Miscellaneous Expenses 1,000 500 500 135-60280-010-000 Property Maintenance 4,200 2,200 4,200 135-60285-010-000 Lawn Equipment & Maintenance 2,000 2,000 250 135-60360-010-000 Furniture/Equipment < $5000 1,500 1,500 1,500 135-65005-010-000 Fuel & Lube 15,216 15,216 17,661 135-65010-010-000 Uniforms 3,690 3,690 2,680 135-65030-010-000 Chemicals 6,200 5,000 6,200 Addition of ammonia to groundwater increases chemicals 135-65035-010-000 Small Tools 2,500 1,500 1,500 135-65040-010-000 Safety Equipment 2,500 1,000 2,000 Need eyewash at sites 135-65050-010-000 Meter Expense 85,000 100,000 143,550 Complete meter changeouts and new meters 135-65055-010-000 Hardware 0 1,000 0 Combined with Maint & Repairs 135-55080 135-65085-010-000 Office Supplies 30 0 Moved to Adminstration Expenses 135-65095-010-000 Maintenance Supplies 0 32,000 0 Combined with Maint & Repairs 135-55080 135-65100-010-000 Copies 0 50 0 Moved to Adminstration Expenses 135-65105-010-000 Printing 0 150 0 Moved to Adminstration Expenses 135-69005-010-000 Capital Expenses 888,432 1,455,600 181,800 See Schedule GF-A 135-69008-010-000 Short Term Debt 0 421,050 387,037 See Schedule GF-B 135-69035-010-000 Vehicles 27,000 30,215 0 135-69195-010-000 Gasb34/Reserve for Replacement 30,000 30,000 30,000 135-69280-010-000 Capital Repairs 24,000 24,000 270,000 See Schedule GF-A 135-69281-010-000 Capital Repair-Tank Inspection Contract 124,771 108,817 150,000 Annual inspection contract for tanks: includes new EST 135-69295-010-000 Unexpected Maintenance 0 250 0 Combined with Maint & Repairs 135-55080 3 Trophy Club MUD No. 1 FY 2013 Budget - Proposed September 18, 2012 Account Description FY 2012 Original FY 2012 ADOPTED Budget Amended FY 2013 Comments 135-69305-010-000 Capital Leases 11,490 10,145 0 Vac Hunter Trailer paid off FY 2012 Subtotal Water 3,500,538 4,406,833 3,821,431 Wastewater 135-50005-020-000 Salaries & Wages 182,147 182,147 196,781 SEE SCHEDULE GF-H 135-50010-020-000 Overtime 10,166 10,166 10,166 SEE SCHEDULE GF-H 135-50016-020-000 Longevity 3,976 3,976 2,858 SEE SCHEDULE GF-H 135-50017-020-000 Certification 2,400 2,400 4,200 SEE SCHEDULE GF-H 135-50020-020-000 Retirement 27,816 27,816 29,821 SEE SCHEDULE GF-J 135-50026-020-000 Medical Insurance 30,805 30,805 29,034 SEE SCHEDULE GF-I 135-50027-020-000 Dental Insurance 1,981 1,981 2,112 SEE SCHEDULE GF-I 135-50028-020-000 Vision Insurance 552 552 552 SEE SCHEDULE GF-I 135-50029-020-000 Life Insurance & Other 884 884 920 SEE SCHEDULE GF-I 135-50030-020-000 Social Security Taxes 8,597 11,293 13,268 SEE SCHEDULE GF-H 135-50035-020-000 Medicare Taxes 2,011 2,645 3,103 SEE SCHEDULE GF-H 135-50040-020-000 Unemployment Taxes 567 567 756 SEE SCHEDULE GF-H 135-50045-020-000 Workman's Compensation 2,685 2,685 2,939 SEE SCHEDULE GF-H 135-50060-020-000 Pre-emp Physicals/Testing 200 150 135-50070-020-000 Employee Relations 350 350 350 135-55070-020-000 Independent Labor 750 32,000 1,000 135-55080-020-000 Maintenance & Repairs 28,535 43,000 40,000 135-55090-020-000 Vehicle Maintenance 4,998 1,500 2,000 135-55100-020-000 Building Maint & Supplies 0 1,400 0 Combined with Maint & Repairs 135-55080 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950 2,950 1,500 135-55125-020-000 Dumpster Services 35,000 35,000 15,000 $750 per 20 ton load x 3 per month 135-55135-020-000 Lab Analysis 22,760 25,000 30,000 135-60005-020-000 Telephone 0 100 0 Moved to Adminstration Expenses 135-60010-020-000 Communications/Pagers/Mobiles 3,000 3,000 2,700 135-60020-020-000 Electricity 205,000 110,000 153,045 SEE SCHEDULE GF-K 135-60025-020-000 Water 1,900 1,900 0 Delete Account: Do not bill for water 135-60035-020-000 Postage 0 120 0 Moved to Adminstration Expenses 135-60066-020-000 Publications/Books/Subscripts 500 500 500 135-60080-020-000 Schools & Training 1,320 1,320 3,272 135-60090-020-000 Safety Program 200 200 250 135-60100-020-000 Travel & per diem 1,750 1,750 1,400 135-60105-020-000 Rent/Lease Equipment 200 200 1,500 135-60125-020-000 Advertising 1,500 2,000 135-60135-020-000 TCEQ Fees & Permits 7,500 7,500 56,000 Reg. Assessment ($8,300), Annual Fee ($7,500), Fines ($40,200) NEW Supplemental Environmental project (SEP)0 Fine amount in TCEQ fees to be moved here if TCEQ approves SEP 135-60245-020-000 Miscellaneous Expenses 525 525 200 135-60285-020-000 Lawn Equipment & Maintenance 525 525 500 135-65005-020-000 Fuel & Lube 6,875 6,875 8,527 135-65010-020-000 Uniforms 3,140 3,140 2,574 135-65030-020-000 Chemicals 13,180 13,180 10,000 135-65035-020-000 Small Tools 1,260 1,260 1,000 135-65040-020-000 Safety Equipment 925 925 250 135-65045-020-000 Lab Supplies 19,160 12,000 10,000 135-65055-020-000 Hardware 0 525 0 Combined with Maint & Repairs 135-55080 4 Trophy Club MUD No. 1 FY 2013 Budget - Proposed September 18, 2012 Account Description FY 2012 Original FY 2012 ADOPTED Budget Amended FY 2013 Comments 135-65085-020-000 Office Supplies 0 400 0 Moved to Adminstration Expenses 135-65095-020-000 Maintenance Supplies 0 8,860 0 Combined with Maint & Repairs 135-55080 135-65115-020-000 Other Consumables 0 110 0 Moved to Adminstration Expenses 135-69005-020-000 Capital Expenses 161,189 111,021 241,200 See Schedule GF-A 135-69008-020-000 Short Term Debt 0 118,731 0 135-69280-021-000 Capital Repairs 56,000 56,000 158,000 See Schedule GF-A Subtotal Wastewater 854,079 881,484 1,039,428 Collection 135-50005-021-000 Salaries & Wages 145,481 145,481 156,475 SEE SCHEDULE GF-H 135-50010-021-000 Overtime 7,297 7,297 7,297 SEE SCHEDULE GF-H 135-50016-021-000 Longevity 3,548 3,548 3,818 SEE SCHEDULE GF-H 135-50017-021-000 Certification 1,500 1,500 1,800 SEE SCHEDULE GF-H 135-50020-021-000 Retirement 21,074 21,074 23,574 SEE SCHEDULE GF-J 135-50026-021-000 Medical Insurance 22,983 22,983 20,198 SEE SCHEDULE GF-I 135-50027-021-000 Dental Insurance 1,533 1,533 1,409 SEE SCHEDULE GF-I 135-50028-021-000 Vision Insurance 357 357 357 SEE SCHEDULE GF-I 135-50029-021-000 Life Insurance & Other 978 978 1,008 SEE SCHEDULE GF-I 135-50030-021-000 Social Security Taxes 9,785 9,785 10,502 SEE SCHEDULE GF-H 135-50035-021-000 Medicare Taxes 2,288 2,288 2,456 SEE SCHEDULE GF-H 135-50040-021-000 Unemployment Taxes 567 567 567 SEE SCHEDULE GF-H 135-50045-021-000 Workman's Compensation 3,056 3,056 3,348 SEE SCHEDULE GF-H 135-50070-021-000 Employee Relations 250 250 250 135-55005-021-000 Engineering 1,500 1,500 1,500 135-55070-021-000 Independent Labor 200 200 0 135-55080-021-000 Maintenance & Repairs 42,250 15,000 35,000 135-55090-021-000 Vehicle Maintenance 1,943 1,943 1,900 135-55100-021-000 Building Maint & Supplies 0 750 0 Combined with Maint & Repairs 135-55080 135-60005-021-000 Telephone 50 0 Moved to Adminstration Expenses 135-60010-021-000 Communications/Pagers/Mobiles 2,796 2,796 3,500 135-60020-021-000 Electricity 23,625 15,000 18,705 SEE SCHEDULE GK-K 135-60025-021-000 Water 750 750 Delete Account: Do not bill for water 135-60035-021-000 Postage 0 150 0 Moved to Adminstration Expenses 135-60070-021-000 Dues & Memberships 255 255 250 135-60080-021-000 Schools & Training 2,818 2,818 826 135-60090-021-000 Safety Program 750 750 500 135-60100-021-000 Travel & per diem 1,500 1,500 450 135-60105-021-000 Rent/Lease Equipment 44,107 76,098 10,000 Funds allocated for rental equipment in disaster or emergency repair. 135-60245-021-000 Miscellaneous Expenses 100 100 100 135-60280-021-000 Property Maintenance 0 1,000 0 Combined with Maint & Repairs 135-55080 135-65005-021-000 Fuel & Lube 11,700 11,700 12,117 135-65010-021-000 Uniforms 2,505 2,505 2,220 135-65030-021-000 Chemicals 12,500 6,500 7,500 135-65035-021-000 Small Tools 1,500 1,500 1,500 135-65040-021-000 Safety Equipment 1,150 1,150 500 135-65055-021-000 Hardware 0 750 0 Combined with Maint & Repairs 135-55080 135-65095-021-000 Maintenance Supplies 0 6,050 0 Combined with Maint & Repairs 135-55080 135-69005-021-000 Capital Expenses 15,000 15,000 90,000 See Schedule GF-A 5 Trophy Club MUD No. 1 FY 2013 Budget - Proposed September 18, 2012 Account Description FY 2012 Original FY 2012 ADOPTED Budget Amended FY 2013 Comments 135-69008-021-000 Short Term Debt 15,000 0 40,260 135-69035-021-000 Vehicles 0 0 Delete Account: Included with Capital Expenses 135-69280-021-000 Capital Repairs 20,000 80,000 0 See Schedule GF-A Subtotal Collection 422,646 466,512 459,887 Board of Directors 135-50005-026-000 Salaries & Wages 10,000 10,000 10,000 135-50030-026-000 Social Security Taxes 620 620 620 135-50035-026-000 Medicare Taxes 145 145 145 135-50040-026-000 Unemployment Taxes 210 210 210 135-50045-026-000 Workman's Compensation 120 120 150 135-60035-026-000 Postage 0 50 0 Moved to Adminstration Expenses 135-60066-026-000 Publications/Books/Subscripts 50 0 150 135-60070-026-000 Dues & Memberships 2,100 2,100 2,100 135-60075-026-000 Meetings 1,278 1,278 1,200 135-60080-026-000 Schools & Training 4,150 4,150 4,000 135-60100-026-000 Travel & per diem 6,199 6,199 5,000 135-60245-026-000 Miscellaneous Expenses 3,200 3,200 3,000 135-65085-026-000 Office Supplies 0 50 0 Moved to Adminstration Expenses Subtotal Board of Directors 28,072 28,122 26,575 Administration (Combined Managers Office, HR, Finance, IT, Facilities Maintenance, & UB) 135-50005-030-000 Salaries & Wages 447,693 416,181 444,730 SEE SCHEDULE GF-H 135-50010-030-000 Overtime 4,000 4,028 1,500 SEE SCHEDULE GF-H 135-50016-030-000 Longevity 3,888 3,888 2,193 SEE SCHEDULE GF-H 135-50020-030-000 Retirement 63,698 59,286 60,441 SEE SCHEDULE GF-H 135-50026-030-000 Medical Insurance 51,206 42,179 44,066 SEE SCHEDULE GF-J 135-50027-030-000 Dental Insurance 3,590 3,041 3,379 SEE SCHEDULE GF-I 135-50028-030-000 Vision Insurance 946 808 795 SEE SCHEDULE GF-I 135-50029-030-000 Life Insurance & Other 2,736 2,508 2,500 SEE SCHEDULE GF-I 135-50030-030-000 Social Security Taxes 27,604 25,650 27,802 SEE SCHEDULE GF-I 135-50035-030-000 Medicare Taxes 6,456 5,999 6,502 SEE SCHEDULE GF-H 135-50040-030-000 Unemployment Taxes 1,702 1,513 1,537 SEE SCHEDULE GF-H 135-50045-030-000 Workman's Compensation 1,887 1,026 831 SEE SCHEDULE GF-H 135-50060-030-000 Pre-emp Physicals/Testing 250 88 250 135-50070-030-000 Employee Relations 6,967 6,967 5,000 135-50075-030-000 Tuition Reimbursement 1,561 1,561 0 135-55030-030-000 Software & Support 64,149 64,149 63,555 SEE SCHEDULE GF-L 135-55070-030-000 Independent Labor 3,290 3,290 2,700 135-55075-030-000 Records Management 500 500 500 135-55100-030-000 Building Maint & Supplies 5,000 14,169 5,000 135-55120-030-000 Cleaning Services 0 25,000 20,200 Half cleaning costs ($10,100) is a credit in SEMO 135-55160-030-000 Professional Outside Services 181,870 191,093 15,000 SEMO previously budgeted here; $10,000 added for website development 135-55161-030-000 SEMO (Town of TC)181,870 0 85,465 SEE SCHEDULE GF-L 135-55205-030-000 Utility Billing Contract 11,000 11,000 11,000 Cost for printing monthly statements 135-60005-030-000 Telephone 7,071 7,221 9,000 135-60010-030-000 Communications/Pagers/Mobiles 3,575 3,575 3,575 135-60020-030-000 Electricity 21,940 21,940 13,019 135-60025-030-000 Water 1,093 1,093 3,100 6 Trophy Club MUD No. 1 FY 2013 Budget - Proposed September 18, 2012 Account Description FY 2012 Original FY 2012 ADOPTED Budget Amended FY 2013 Comments 135-60030-030-000 Rent And/Or Usage 13,182 13,182 13,182 $1098 per month paid to Town 135-60035-030-000 Postage 18,806 20,606 23,000 135-60040-030-000 Bank Service Charges & Fees 18,079 29,419 18,000 135-60050-030-000 Bad Debt Expense 4,200 4,200 8,500 Moved from Water Expenses 135-60055-030-000 Insurance 32,635 32,635 35,000 135-60066-030-000 Publications/Books/Subscripts 1,435 1,435 750 135-60070-030-000 Dues & Memberships 3,028 3,028 2,400 135-60075-030-000 Meetings 750 750 250 135-60080-030-000 Schools & Training 5,949 5,949 5,500 See Schedule GF-G 135-60100-030-000 Travel & per diem 5,964 4,456 3,950 See Schedule GF-G 135-60110-030-000 Physicals/Testing 1,560 1,560 500 135-60115-030-000 Elections 2,500 2,500 0 135-60125-030-000 Advertising 5,910 5,910 4,000 135-60130-030-000 Reg Assessment Fee (5%)22,500 22,500 0 Moved to TCEQ fees (water and wastewater) 135-60235-030-000 Security 1,350 1,350 1,350 135-60245-030-000 Miscellaneous Expenses & DM Discretionary 610 610 15,000 Added funds for DM's discretionary use for emergency repair or purchase 135-60270-030-000 4th of July Celebration 10,000 10,500 10,500 135-60360-030-000 Furniture/Equipment < $5000 4,725 6,975 2,500 135-65010-030-000 Uniforms 0 0 1,635 See Schedule GF-F 135-65055-030-000 Hardware IT 83,238 83,238 20,188 See Schedule GF-L 135-65085-030-000 Office Supplies 4,807 4,807 8,200 All departments combined. 135-65090-030-000 Printer Supplies & Maintenance 5,732 5,732 5,732 See Schedule GF-L 135-65095-030-000 Maintenance Supplies 2,205 2,205 2,000 135-65097-030-000 Vending Machine Supplies 1,000 1,000 500 Vending at WWTP and Collections Barn 135-65105-030-000 Printing 4,446 4,681 5,200 135-69170-030-000 Copier Lease Installments 3,450 3,450 3,450 See Schedule GF-L 135-69195-030-000 Gasb34/Reserve for Replacement IT 26,911 26,911 26,911 135-60344-030-000 Intergov Trans Out (Fire Dept.)0 2,278 0 Subtotal Administration 1,390,514 1,217,342 1,051,838 Non Departmental 135-55045-039-000 Legal 55,000 70,000 70,000 135-55055-039-000 Auditing 20,200 20,200 21,200 135-55060-039-000 Appraisal 20,000 20,000 15,100 135-55065-039-000 Tax Admin Fees 3,629 3,629 3,800 135-60344-039-000 Intergov Trans Out (Fire CIP)0 2,278 0 Subtotal Non Departmental 98,829 116,107 110,100 Total General Fund Revenues 6,094,978 7,483,080 6,509,259 Total General Fund Expenses 6,294,678 7,116,400 6,509,259 Net Budget Surplus (Deficit)-199,700 366,680 0 7 Trophy Club MUD No. 1 FY 2013 Budget - Proposed September 18, 2012 FIRE DEPARTMENT Account Description FY 2012 Original FY 2012 ADOPTED Budget Amended FY 2013 Comments Revenues 122-40001-000-000 Assessment - Emerg Svcs -193,233 -193,233 252,084 122-40003-000-000 Emer Svcs Assessmen/Delinquent 0 -4,900 4,700 122-40010-000-000 Property Taxes/MUD Fire -1,076,976 -1,076,976 1,050,349 122-40011-000-000 Property Taxes/Fire-Delinquent 0 -5,603 5,800 122-40015-000-000 Property Taxes/Assessments P&I 0 -725 750 122-40020-000-000 Property Taxes/Fire P&I -7,500 -7,500 4,500 122-42014-000-000 Fire Permits/Sprinkler 0 -6,000 6,000 122-43400-000-000 Fire Inspections 0 -500 500 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire -10,000 -10,000 10,000 122-43599-000-000 Misc Fire Revenue -1,124 -1,124 0 122-49035-000-000 Prior Year Reserves -23,101 0 0 122-49900-000-000 Miscellaneous Income -1,124 -9,122 1,200 Total 1,313,058 1,315,683 1,335,882 Expenses 122-50005-045-000 Salaries & Wages 425,748 425,748 444,717 SEE SCHEDULE GF-H 122-50010-045-000 Overtime 42,000 42,000 31,375 SEE SCHEDULE GF-H 122-50011-045-000 DPS Holiday Pay 12,133 13,773 13,083 SEE SCHEDULE GF-H 122-50016-045-000 Longevity 3,647 3,647 4,266 SEE SCHEDULE GF-H 122-50017-045-000 Certification 4,073 4,073 4,896 SEE SCHEDULE GF-J 122-50020-045-000 Retirement 68,264 68,264 69,242 SEE SCHEDULE GF-I 122-50026-045-000 Medical Insurance 53,184 53,184 48,327 SEE SCHEDULE GF-I 122-50027-045-000 Dental Insurance 3,288 3,288 3,635 SEE SCHEDULE GF-I 122-50028-045-000 Vision Insurance 857 857 824 SEE SCHEDULE GF-I 122-50029-045-000 Life Insurance & Other 2,740 2,740 4,250 SEE SCHEDULE GF-I 122-50030-045-000 Social Security Taxes 30,231 30,231 30,897 SEE SCHEDULE GF-H 122-50035-045-000 Medicare Taxes 7,070 7,070 7,226 SEE SCHEDULE GF-H 122-50040-045-000 Unemployment Taxes 1,476 1,476 1,481 SEE SCHEDULE GF-H 122-50045-045-000 Workman's Compensation 8,793 9,209 10,000 122-50060-045-000 Pre-employment Physicals/Test 675 675 675 135-50075-045-000 Tuition Reimbursement 0 0 1,500 Previously budgeted in GF but should be FD 122-55080-045-000 Maintenance & Repairs 9,562 9,562 9,562 122-55090-045-000 Vehicle Maintenance 14,850 14,850 14,850 122-55095-045-000 Equipment Maintenance 9,808 9,808 9,808 122-55100-045-000 Building Maintenance 11,000 11,000 6,500 122-55110-045-000 Maintenance-Radios 1,103 1,103 1,103 122-55160-045-000 Professional Outside Services 20,000 19,623 2,500 135-55161-045-000 SEMO (Town of TC)0 0 0 NOTHING BUDGETED FOR FD IN SEMO 122-60005-045-000 Telephone 106 106 106 122-60010-045-000 Communications/Pagers/Mobiles 4,411 4,411 2,500 122-60020-045-000 Electricity/Gas 18,270 18,270 6,167 SEE SCHEDULE GF-K: 50% PAID BY TOWN 122-60025-045-000 Water 3,289 3,289 1,400 50% PAID BY TOWN 122-60030-045-000 Rent And/Or Usage 308,000 308,000 308,000 122-60035-045-000 Postage 97 97 100 8 Trophy Club MUD No. 1 FY 2013 Budget - Proposed September 18, 2012 Account Description FY 2012 Original FY 2012 ADOPTED Budget Amended FY 2013 Comments 122-60055-045-000 Insurance 20,974 20,974 10,000 122-60066-045-000 Publications/Books/Subscrips 401 401 410 122-60070-045-000 Dues & Memberships 8,560 8,560 7,500 122-60075-045-000 Meetings 0 75 75 122-60080-045-000 Schools & Training 6,946 6,946 5,000 122-60096-045-000 Emergency Management 1,000 1,000 1,000 122-60100-045-000 Travel & per diem 6,788 6,788 4,800 122-60110-045-000 Physicals/Testing 1,918 1,918 2,000 122-60125-045-000 Advertising 156 156 150 122-60160-045-000 Programs & Special Projects 4,162 4,162 4,200 122-60180-045-000 Fire Inspection/Enforcement 1,900 1,900 1,900 122-60195-045-000 Flags & Repair 2,543 2,543 2,543 122-60245-045-000 Miscellaneous Expense 1,237 1,237 1,237 122-65005-045-000 Fuel & Lube 17,414 17,414 10,000 122-65010-045-000 Uniforms 4,357 4,357 4,357 122-65015-045-000 Protective Clothing 7,600 7,600 7,600 122-65030-045-000 Chemicals 1,545 1,545 1,000 122-65035-045-000 Small Tools 8,371 8,371 5,000 122-65085-045-000 Office Supplies 329 1,200 1,200 122-65095-045-000 Maintenance Supplies 2,785 2,785 2,785 122-65105-045-000 Printing 106 106 106 122-69006-045-000 Grant Match 3,000 3,000 3,000 122-69035-045-000 Vehicles 13,709 13,709 0 122-69050-045-000 Radios 2,500 2,500 2,500 122-69195-045-000 GASB34/Reserve for Replacement 41,890 41,890 145,598 122-69251-045-000 Short Term Debt (Engine 681 Payment)73,203 73,203 72,932 122-69255-045-000 Airpacks 13,865 13,865 0 Delete Account: Paid in Full Total 1,311,934 1,314,559 1,335,882 Total Fire Revenues 1,313,058 1,315,683 1,335,882 Total Fire Expenses 1,311,934 1,314,559 1,335,882 Net Budget Surplus (Deficit)1,124 1,124 0 9 Trophy Club MUD No. 1 FY 2013 Budget - Proposed September 18, 2012 DEBT SERVICE FUND Account Description FY 2012 Original Amend #3 ADOPTED Budget Budget FY 2013 Comments Debt Service Revenues 533-40000-000-000 Property Taxes -550,663 -546,716 196,940 533-40002-000-000 Property Taxes/Delinquent 0 -3,947 3,900 533-40015-000-000 Property Taxes/P & I -5,017 -5,017 5,017 533-48005-000-000 Reserve Funds from PID Utility Fees -6,120 -6,120 345,000 Add $345K and subsequently reduce tax rate 533-49010-000-000 Interest Income -500 -1,700 1,700 533-49015-000-000 Lease/Rental Income -308,000 -308,000 308,000 Rent revenue to debt service 533-49110-000-000 Premium on Bonds Sold 0 0 0 Total -870,300 -871,500 860,557 Debt Service Expenses 533-70005-051-000 Paying Agent Fee 4,000 4,000 4,000 533-70025-051-000 Bond Interest Expense 301,300 301,300 229,033 See Schedule GF-B (Long Term Debt) 533-70035-051-000 Bond Principal Payment 565,000 565,000 605,000 See Schedule GF-B (Long Term Debt) Total 870,300 870,300 838,033 Total Debt Service Fund Revenues 870,300 871,500 860,557 Total Debt Service Fund Expenses 870,300 870,300 838,033 Transfer of Funds to (+) from (-) Cash on Hand 0 0 0 Net Budget Surplus (Deficit)0 1,200 22,525 10 SCHEDULE GF - A CAPITAL EXPENSES WATER - CAPITAL PURCHASES WATER - CAPITAL REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT Ammonia System for Wells 176,000 Indian Creek Waterline Upgrade 140,000 Security Cameras 5,800 Pin Oak Waterline Upgrade 70,000 Upgrade City of FW Meter 60,000 Total:181,800 Total:270,000 WASTEWATER - CAPITAL PURCHASES WASTEWATER - CAPITAL REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT Purchase of Property*125,000 Plant Piping Coatings & Handrail Replacement 150,000 Vehicle (SUV)19,500 Repair/replace waste pump 8,000 Vehicle (1/2 ton)30,000 Security Cameras 8,200 Sludge Blanket Level Indicator 18,000 VFD for Blowers 35,000 Portable Submersible Pump 5,500 Total:241,200 Total:158,000 *$75K for property, $50K for appraisal, survey, legal COLLECTION - CAPITAL PURCHASES COLLECTION - CAPITAL REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT Lift Station No. 4 (Developer Cost Share Project)90,000 0 0 0 0 Total:90,000 Total:0 FY 2012 Budgeted Capital Expenses WATER WASTEWATER WASTEWATER CAPITAL REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT Ground Storage Expansion 1,039,100 New replacement pumps 17,500 Repair worn pumps 13,500 AMR Meter Replacement 89,000 Truck 18,521 Replace bad bearings on digester blower 7,500 Round-about Water Line Relocation 187,500 Master Plan: 5/10 year improvement plan 75,000 Repair wires on security fence 4,000 MUD Share Municipal Drive Street Repair 75,000 Total:111,021 Repair aeration blower panels 10,000 Upgrade high speed pump to VFD 15,000 Replacement bags for filters ($1750 x 12)21000 Master Plan: 5/10 year improvement plan 50,000 Total:56,000 Total:1,455,600 11 SCHEDULE GF - B DEBT PAYMENTS LONG TERM DEBT Par Principle Interest 3/01 Interest 9/01 Subtotal Interest Total Maturity Date First Callable Date Project/Reason Series 2003 $1,200,000 $60,000.00 $15,645.00 $15,645.00 $91,290.00 9/1/2023 9/1/2013 FDIC Settlement and costs related to the issuance of the Bonds. Series 2005 $3,134,997 $295,000.00 $29,267.50 $29,267.50 $353,535.00 9/1/2023 9/1/2013 Refund 2006-2013 maturies of the District's Unlimited Tax Refunding Bonds, Series 1995, and costs related to the issuance of the Bonds. Series 2010 $2,000,000 $65,000.00 $39,228.75 $39,228.75 $143,457.50 9/1/2031 9/1/2020 Trophy Club Fire Station and costs related to the issuance of the Bonds. Series 2012 $2,355,000 $185,000.00 $30,375.00 $30,375.00 $245,750.00 9/1/2023 9/1/2020 Refund MUD #2 Unlimited Tax Bonds, 2002 and costs related to the issuance of the Bonds. Total:$8,689,997 $605,000.00 $114,516.25 $114,516.25 $229,032.50 $834,032.50 SHORT TERM DEBT WATER DESCRIPTION AMOUNT Ground Storage Expansion $387,037.10 FY 2012-2014 Total:$387,037.10 COLLECTIONS DESCRIPTION AMOUNT Gapvax $40,260.43 FY 2012-2015 Total:$40,260.43 FIRE DESCRIPTION AMOUNT Fire Truck $72,932.10 FY 2012-2014 Total:$72,932.10 12 ANNUALIZE GROWTH IN WATER METERS =5.50% PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2012 =3,916 ITEM MONTH PROJECTED AVERAGE PROJECTED NO.EOM AND AVERAGE WATER USE MONTHLY ANNUAL NO. OF PER METER WATER WATER FOR LAST USE PER METERS 3 YEARS MONTH (GALLONS)(GALLONS) 1 OCT 3,934 17,597 69,225,177 2 NOV 3,952 13,847 54,721,981 3 DEC 3,970 10,952 43,480,564 4 JAN 3,988 10,476 41,782,388 5 FEB 4,007 8,795 35,239,525 6 MAR 4,025 11,697 47,081,392 7 APR 4,043 15,162 61,307,154 8 MAY 4,062 15,209 61,776,609 9 JUN 4,081 24,586 100,325,229 10 JUL 4,099 29,858 122,392,840 11 AUG 4,118 34,311 141,293,684 12 SEP 4,137 26,528 109,741,871 AVERAGE 4,035 18,252 TOTAL 888,368,413 CALCULATED AVERAGE WATER USE PER METER PER MONTH =(GALS/METER/MN)18,252 PROJECTED TOTAL NO. OF NEW RETAIL METERS IN FY13 =(METERS)221 Growth Rate Calculation Meters set June 2011 through May 2012:25 per month Growth Rate = Ave. New Meters Set/Total Meters at May 2012 (25*12)/3816 x 100% =7.8% 5.5% adopted by Board Purchased Water Expense Purchased Water (gallons):888,368,413 Out of District Volumetric Charge $1.74 per 1000 gals $1,545,761 Rate of Use Charge $40,199 per month $482,388 SCHEDULE GF-C PROJECTED WATER USE PROJECTED RETAIL WATER SALES 13 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug SepAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccounts Usage0to1,999 248 106,145 271 120,388 315 136,239 309 121,169 405 203,215 339 183,617 267 94,004 262 105,020 219 70,228 204 61,196 180 61,227 199 69,5032,000 to 2,999 133 306,898 190 412,239 230 482,634 180 363,507 285 600,247 241 660,709 142 296,318 164 350,067 85 190,618 61 130,552 68 141,294 80 164,6133,000 to 3,999 193 687,637 277 912,033 344 1,082,666 277 856,539 427 1,357,896 335 1,420,289 171 533,372 224 735,142 92 321,041 64 203,988 58 197,811 91 288,9874,000 to 4,999 234 1,072,990 352 1,539,512 446 1,863,867 387 1,577,982 506 2,121,419 382 2,030,777 228 950,261 278 1,206,703 105 481,561 60 257,025 60 259,038 107 449,9425,000 to 5,999 231 1,363,736 318 1,718,270 403 2,082,719 395 2,013,911 480 2,504,356 367 2,346,223 253 1,330,365 264 1,424,980 111 645,426 74 387,577 71 409,752 97 515,7876,000 to 6,999 216 1,513,724 290 1,838,659 376 2,324,761 415 2,520,871 408 2,527,849 302 2,165,744 260 1,647,119 274 1,762,693 115 832,699 80 505,890 72 485,108 120 764,5357,000 to 7,999 217 1,742,167 280 2,075,787 294 2,114,605 346 2,460,983 309 2,227,138 266 2,148,481 236 1,741,123 238 1,775,048 133 1,103,578 76 571,167 67 532,206 123 914,5168,000 to 8,999 196 1,769,857 230 1,902,501 235 1,907,347 320 2,575,188 246 2,002,780 216 1,858,146 240 1,998,613 215 1,834,765 124 1,126,987 82 697,639 73 654,661 121 1,016,9419,000 to 9,999 173 1,686,787 183 1,681,789 220 1,994,309 230 2,086,334 188 1,691,497 196 1,834,605 218 2,021,093 201 1,896,542 118 1,240,689 97 950,584 66 664,080 119 1,141,31510,000 to 14,999 159 1,739,859 160 1,621,595 153 1,507,326 194 1,958,201 143 1,457,742 155 1,516,021 196 2,035,398 186 1,921,253 123 1,397,865 90 979,143 74 857,182 126 1,320,56115,000 to 19,999 688 9,054,653 610 7,661,077 454 5,714,795 504 6,233,932 322 3,944,478 556 6,467,414 735 9,476,042 688 8,922,602 600 8,487,514 503 6,992,711 392 5,778,912 602 8,175,76920,000 to 24,999 453 7,896,285 315 5,419,300 199 3,403,079 176 3,066,827 121 2,020,399 288 4,489,995 464 8,106,849 417 7,203,153 576 10,754,865 561 10,444,189 445 8,844,985 597 10,941,26525,000 to 29,999 285 6,098,738 174 3,757,576 92 2,016,049 78 1,721,434 39 856,320 151 2,967,697 247 5,423,640 253 5,568,132 457 10,407,070 484 11,402,933 483 11,779,183 504 11,508,26430,000 to 34,999 165 4,285,038 83 2,152,398 55 1,484,137 43 1,176,871 22 586,151 71 1,657,265 135 3,574,207 136 3,624,228 366 9,848,593 424 11,741,553 435 12,438,554 370 10,227,94235,000 to 39,999 99 2,978,990 55 1,752,927 30 966,718 26 856,539 15 467,511 37 1,169,188 74 2,288,800 76 2,345,452 254 7,908,972 340 11,064,313 349 11,392,981 254 8,197,71840,000 to 44,999 52 1,846,005 27 979,523 17 631,918 18 675,482 9 351,221 21 712,498 40 1,473,415 34 1,241,710 177 6,263,638 234 8,677,652 282 10,578,187 172 6,299,18345,000 to 49,999 28 1,137,600 18 736,923 9 415,964 8 323,117 8 344,173 10 397,053 25 1,042,222 25 1,011,077 121 4,899,215 163 6,768,324 208 8,576,527 111 4,568,92050,000 to 59,999 21 962,230 12 585,525 10 488,432 6 299,440 6 271,344 11 451,981 14 649,856 19 887,524 66 2,906,087 118 5,426,083 155 7,074,104 76 3,401,99860,000 to 69,999 32 1,691,402 18 983,172 15 817,435 13 722,835 11 607,294 13 768,996 22 1,162,792 19 1,013,136 81 4,166,841 133 6,878,478 215 11,016,198 86 4,594,52670,000 +111 21,284,434 89 16,870,787 72 12,045,565 62 10,171,226 57 9,096,496 68 11,834,692 77 15,461,664 89 16,947,383 157 27,271,742 252 38,251,842 363 49,551,695 181 35,179,586 3,934 69,225,177 3,952 54,721,981 3,970 43,480,564 3,988 41,782,388 4,007 35,239,525 4,025 47,081,392 4,043 61,307,154 4,062 61,776,609 4,081 100,325,229 4,099 122,392,840 4,118 141,293,684 4,137 109,741,871 WATER USE FOR MONTH WATER RATES FOR ALL METER SIZES TOTAL USAGE:888,368,413 Gallons Included in Minimum Bill =0$ Amount of Minimum Bill =12.71MIN BILL =$12.710to6,999 $2.507,000 to 17,999 $3.0518,000 to 25,999 $3.3026,000 to 50,999 $3.4051,000 + $3.50 Oct 10 Nov 11 Dec 12 Jan 1 Feb 2 Mar 3 Apr 4 May 5 Jun 6 Jul 7 Aug 8 Sep 9 Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,999 $3,150 $265 $3,439 $301 $4,001 $341 $3,934 $303 $5,152 $508 $4,307 $459 $3,394 $235 $3,330 $263 $2,783 $176 $2,598 $153 $2,291 $153 $2,527 $174 2,000 to 2,999 $1,687 $767 $2,418 $1,031 $2,928 $1,207 $2,283 $909 $3,619 $1,501 $3,069 $1,652 $1,807 $741 $2,087 $875 $1,086 $477 $773 $326 $869 $353 $1,011 $412 3,000 to 3,999 $2,447 $1,719 $3,526 $2,280 $4,378 $2,707 $3,521 $2,141 $5,425 $3,395 $4,253 $3,551 $2,176 $1,333 $2,852 $1,838 $1,165 $803 $820 $510 $736 $495 $1,155 $722 4,000 to 4,999 $2,972 $2,682 $4,472 $3,849 $5,672 $4,660 $4,915 $3,945 $6,435 $5,304 $4,858 $5,077 $2,898 $2,376 $3,530 $3,017 $1,333 $1,204 $757 $643 $757 $648 $1,365 $1,125 5,000 to 5,999 $2,940 $3,409 $4,038 $4,296 $5,125 $5,207 $5,023 $5,035 $6,101 $6,261 $4,671 $5,866 $3,212 $3,326 $3,357 $3,562 $1,407 $1,614 $936 $969 $904 $1,024 $1,236 $1,289 6,000 to 6,999 $2,750 $3,784 $3,684 $4,597 $4,777 $5,812 $5,279 $6,302 $5,187 $6,320 $3,844 $5,414 $3,301 $4,118 $3,478 $4,407 $1,468 $2,082 $1,013 $1,265 $918 $1,213 $1,530 $1,911 7,000 to 7,999 $2,758 $5,314 $3,553 $6,331 $3,739 $6,450 $4,403 $7,506 $3,925 $6,793 $3,381 $6,553 $3,000 $5,310 $3,029 $5,414 $1,694 $3,366 $969 $1,742 $855 $1,623 $1,560 $2,789 8,000 to 8,999 $2,490 $5,398 $2,928 $5,803 $2,982 $5,817 $4,069 $7,854 $3,125 $6,108 $2,740 $5,667 $3,044 $6,096 $2,728 $5,596 $1,577 $3,437 $1,042 $2,128 $932 $1,997 $1,532 $3,102 9,000 to 9,999 $2,203 $5,145 $2,329 $5,129 $2,797 $6,083 $2,920 $6,363 $2,392 $5,159 $2,493 $5,596 $2,773 $6,164 $2,554 $5,784 $1,497 $3,784 $1,230 $2,899 $843 $2,025 $1,516 $3,481 10,000 to 14,999 $2,020 $5,307 $2,034 $4,946 $1,946 $4,597 $2,469 $5,973 $1,823 $4,446 $1,964 $4,624 $2,496 $6,208 $2,363 $5,860 $1,568 $4,263 $1,141 $2,986 $944 $2,614 $1,604 $4,028 15,000 to 19,999 $8,750 $27,617 $7,752 $23,366 $5,776 $17,430 $6,402 $19,013 $4,096 $12,031 $7,061 $19,726 $9,343 $28,902 $8,739 $27,214 $7,620 $25,887 $6,389 $21,328 $4,988 $17,626 $7,657 $24,936 20,000 to 24,999 $5,755 $26,058 $4,007 $17,884 $2,525 $11,230 $2,239 $10,121 $1,533 $6,667 $3,661 $14,817 $5,893 $26,753 $5,297 $23,770 $7,320 $35,491 $7,124 $34,466 $5,661 $29,188 $7,587 $36,106 25,000 to 29,999 $3,622 $20,736 $2,207 $12,776 $1,164 $6,855 $990 $5,853 $494 $2,911 $1,917 $10,090 $3,143 $18,440 $3,215 $18,932 $5,810 $35,384 $6,157 $38,770 $6,143 $40,049 $6,409 $39,128 30,000 to 34,999 $2,092 $14,569 $1,058 $7,318 $705 $5,046 $547 $4,001 $280 $1,993 $897 $5,635 $1,713 $12,152 $1,733 $12,322 $4,654 $33,485 $5,389 $39,921 $5,529 $42,291 $4,699 $34,775 35,000 to 39,999 $1,260 $10,129 $702 $5,960 $375 $3,287 $328 $2,912 $185 $1,590 $474 $3,975 $940 $7,782 $965 $7,975 $3,222 $26,891 $4,316 $37,619 $4,437 $38,736 $3,227 $27,872 40,000 to 44,999 $662 $6,276 $340 $3,330 $217 $2,149 $233 $2,297 $110 $1,194 $273 $2,422 $509 $5,010 $435 $4,222 $2,249 $21,296 $2,980 $29,504 $3,578 $35,966 $2,184 $21,417 45,000 to 49,999 $358 $3,868 $228 $2,506 $119 $1,414 $96 $1,099 $102 $1,170 $133 $1,350 $315 $3,544 $317 $3,438 $1,544 $16,657 $2,070 $23,012 $2,648 $29,160 $1,416 $15,534 50,000 to 59,999 $270 $3,368 $154 $2,049 $133 $1,710 $79 $1,048 $76 $950 $136 $1,582 $182 $2,274 $248 $3,106 $840 $10,171 $1,499 $18,991 $1,964 $24,759 $962 $11,907 60,000 to 69,999 $405 $5,920 $226 $3,441 $185 $2,861 $166 $2,530 $134 $2,126 $162 $2,691 $278 $4,070 $239 $3,546 $1,032 $14,584 $1,695 $24,075 $2,732 $38,557 $1,099 $16,081 70,000 +$1,410 $74,496 $1,135 $59,048 $915 $42,159 $794 $35,599 $730 $31,838 $861 $41,421 $975 $54,116 $1,132 $59,316 $1,993 $95,451 $3,204 $133,881 $4,611 $173,431 $2,303 $123,129 $50,000 $226,826 $50,230 $176,240 $50,460 $137,020 $50,691 $130,804 $50,923 $108,263 $51,157 $148,168 $51,391 $198,949 $51,627 $200,456 $51,864 $336,503 $52,101 $415,188 $52,340 $481,909 $52,580 $369,919 $3,545,609 PROJECTED ANNUAL REVENUE GENERATED FROM PROPOSED RATES =$3,545,609 AMOUNT FROM BASE:$615,364 AMOUNT FROM USAGE:$2,930,245 TOTAL:$3,545,609 OTHER REVENUE SOURCES A B C C D MONTH SHUTOFFS FOR NON-PAYMENT LATE FEES ($/Month) PID MUD Jan-12 69 35 7 4,423$ Feb-12 27 22 3 2,901$ Mar-12 16 25 6 2,801$ Apr-12 26 21 1 2,313$ May-12 21 20 4 2,973$ Jun-11 26 25 2 5,173$ Jul-11 50 30 5 7,403$ Aug-11 27 12 1 5,875$ Sep-11 60 25 1 7,941$ Oct-11 53 19 0 9,287$ Nov-11 43 18 4 8,885$ Dec-11 47 46 7 4,605$ Total 465 298 41 64,580$ Average Per Month 39 25 3 5,382$ GROWTH RATE BASED ON (AVE./MONTH X 12) NEW METERS SET:5.50%adopted by board REVENUE FOR SHUTOFFS (MO. AVE. X 12 x $25):$11,625 SERVICE CHGS UTILITY FEES:280 x 2300 TOTAL LATE FEES:$64,580 PENALTIES $644,000 REVENUE FOR MUD TAP FEES:$11,972 REVENUE FOR PID UTILITY FEES:$685,400 DEBT SERVICE BUDGET SCHEDULE GF-D FY 13 WATER REVENUE PROJECTION PROJECTED RETAIL WATER SALES FY 13 WATER USECATEGORY NEW METERS SET (TAP FEES) PID TABLE GF-D 2 TOTAL PROJECTED FY 2013 RETAIL WATER REVENUES Usage Groups TOTAL 14 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,999 248 106,145 271 120,388 315 136,239 309 121,169 405 203,215 339 183,617 267 94,004 262 105,020 219 70,228 204 61,196 180 61,227 199 69,503 2,000 to 2,999 133 306,898 190 412,239 230 482,634 180 363,507 285 600,247 241 660,709 142 296,318 164 350,067 85 190,618 61 130,552 68 141,294 80 164,6133,000 to 3,999 193 687,637 277 912,033 344 1,082,666 277 856,539 427 1,357,896 335 1,420,289 171 533,372 224 735,142 92 321,041 64 203,988 58 197,811 91 288,987 4,000 to 4,999 234 1,072,990 352 1,539,512 446 1,863,867 387 1,577,982 506 2,121,419 382 2,030,777 228 950,261 278 1,206,703 105 481,561 60 257,025 60 259,038 107 449,942 5,000 to 5,999 231 1,363,736 318 1,718,270 403 2,082,719 395 2,013,911 480 2,504,356 367 2,346,223 253 1,330,365 264 1,424,980 111 645,426 74 387,577 71 409,752 97 515,787 6,000 to 6,999 216 1,513,724 290 1,838,659 376 2,324,761 415 2,520,871 408 2,527,849 302 2,165,744 260 1,647,119 274 1,762,693 115 832,699 80 505,890 72 485,108 120 764,5357,000 to 7,999 217 1,742,167 280 2,075,787 294 2,114,605 346 2,460,983 309 2,227,138 266 2,148,481 236 1,741,123 238 1,775,048 133 1,103,578 76 571,167 67 532,206 123 914,516 8,000 to 8,999 196 1,769,857 230 1,902,501 235 1,907,347 320 2,575,188 246 2,002,780 216 1,858,146 240 1,998,613 215 1,834,765 124 1,126,987 82 697,639 73 654,661 121 1,016,941 9,000 to 9,999 173 1,686,787 183 1,681,789 220 1,994,309 230 2,086,334 188 1,691,497 196 1,834,605 218 2,021,093 201 1,896,542 118 1,240,689 97 950,584 66 664,080 119 1,141,315 10,000 to 14,999 159 1,739,859 160 1,621,595 153 1,507,326 194 1,958,201 143 1,457,742 155 1,516,021 196 2,035,398 186 1,921,253 123 1,397,865 90 979,143 74 857,182 126 1,320,56115,000 to 19,999 688 N/A 610 7,661,077 454 5,714,795 504 6,233,932 322 3,944,478 556 6,467,414 735 9,476,042 688 8,922,602 600 8,487,514 503 6,992,711 392 5,778,912 602 8,175,769 20,000 to 24,999 453 N/A 315 5,419,300 199 3,403,079 176 3,066,827 121 2,020,399 288 4,489,995 464 8,106,849 417 7,203,153 576 10,754,865 561 10,444,189 445 8,844,985 597 10,941,265 25,000 to 29,999 285 N/A 174 3,757,576 92 2,016,049 78 1,721,434 39 856,320 151 2,967,697 247 5,423,640 253 5,568,132 457 10,407,070 484 11,402,933 483 11,779,183 504 11,508,264 30,000 to 34,999 165 N/A 83 2,152,398 55 1,484,137 43 1,176,871 22 586,151 71 1,657,265 135 3,574,207 136 3,624,228 366 9,848,593 424 11,741,553 435 12,438,554 370 10,227,94235,000 to 39,999 99 N/A 55 1,752,927 30 966,718 26 856,539 15 467,511 37 1,169,188 74 2,288,800 76 2,345,452 254 7,908,972 340 11,064,313 349 11,392,981 254 8,197,718 40,000 to 44,999 52 N/A 27 979,523 17 631,918 18 675,482 9 351,221 21 712,498 40 1,473,415 34 1,241,710 177 6,263,638 234 8,677,652 282 10,578,187 172 6,299,183 45,000 to 49,999 28 N/A 18 736,923 9 415,964 8 323,117 8 344,173 10 397,053 25 1,042,222 25 1,011,077 121 4,899,215 163 6,768,324 208 8,576,527 111 4,568,920 50,000 to 59,999 21 N/A 12 585,525 10 488,432 6 299,440 6 271,344 11 451,981 14 649,856 19 887,524 66 2,906,087 118 5,426,083 155 7,074,104 76 3,401,99860,000 to 69,999 32 N/A 18 983,172 15 817,435 13 722,835 11 607,294 13 768,996 22 1,162,792 19 1,013,136 81 4,166,841 133 6,878,478 215 11,016,198 86 4,594,52670,000 +111 N/A 89 16,870,787 72 12,045,565 62 10,171,226 57 9,096,496 68 11,834,692 77 15,461,664 89 16,947,383 157 27,271,742 252 38,251,842 363 49,551,695 181 35,179,586 WASTEWATER RATES FOR ALL METER SIZES Gallons Included in Minimum Bill =0 $ Amount of Minimum Bill =12.71 MIN BILL =$12.710to6,999 $2.50 7,000 to 12,000 $2.50 Oct 10 Nov 11 Dec 12 Jan 1 Feb 2 Mar 3 Apr 4 May 5 Jun 6 Jul 7 Aug 8 Sep 9Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Accounts Usage Accounts Usage Accounts Usage0to1,999 $3,150 $265 $3,439 $301 $4,001 $341 $3,934 $303 $5,152 $508 $4,307 $459 $3,394 $235 $3,330 $263 $2,783 $176 $2,598 $153 $2,291 $153 $2,527 $174 2,000 to 2,999 $1,687 $767 $2,418 $1,031 $2,928 $1,207 $2,283 $909 $3,619 $1,501 $3,069 $1,652 $1,807 $741 $2,087 $875 $1,086 $477 $773 $326 $869 $353 $1,011 $412 3,000 to 3,999 $2,447 $1,719 $3,526 $2,280 $4,378 $2,707 $3,521 $2,141 $5,425 $3,395 $4,253 $3,551 $2,176 $1,333 $2,852 $1,838 $1,165 $803 $820 $510 $736 $495 $1,155 $7224,000 to 4,999 $2,972 $2,682 $4,472 $3,849 $5,672 $4,660 $4,915 $3,945 $6,435 $5,304 $4,858 $5,077 $2,898 $2,376 $3,530 $3,017 $1,333 $1,204 $757 $643 $757 $648 $1,365 $1,1255,000 to 5,999 $2,940 $3,409 $4,038 $4,296 $5,125 $5,207 $5,023 $5,035 $6,101 $6,261 $4,671 $5,866 $3,212 $3,326 $3,357 $3,562 $1,407 $1,614 $936 $969 $904 $1,024 $1,236 $1,289 6,000 to 6,999 $2,750 $3,784 $3,684 $4,597 $4,777 $5,812 $5,279 $6,302 $5,187 $6,320 $3,844 $5,414 $3,301 $4,118 $3,478 $4,407 $1,468 $2,082 $1,013 $1,265 $918 $1,213 $1,530 $1,911 7,000 to 7,999 $2,758 $4,355 $3,553 $5,189 $3,739 $5,287 $4,403 $6,152 $3,925 $5,568 $3,381 $5,371 $3,000 $4,353 $3,029 $4,438 $1,694 $2,759 $969 $1,428 $855 $1,331 $1,560 $2,286 8,000 to 8,999 $2,490 $4,425 $2,928 $4,756 $2,982 $4,768 $4,069 $6,438 $3,125 $5,007 $2,740 $4,645 $3,044 $4,997 $2,728 $4,587 $1,577 $2,817 $1,042 $1,744 $932 $1,637 $1,532 $2,5429,000 to 9,999 $2,203 $4,217 $2,329 $4,204 $2,797 $4,986 $2,920 $5,216 $2,392 $4,229 $2,493 $4,587 $2,773 $5,053 $2,554 $4,741 $1,497 $3,102 $1,230 $2,376 $843 $1,660 $1,516 $2,853 10,000 to 14,999 $2,020 $4,350 $2,034 $4,054 $1,946 $3,768 $2,469 $4,896 $1,823 $3,644 $1,964 $3,790 $2,496 $5,088 $2,363 $4,803 $1,568 $3,495 $1,141 $2,448 $944 $2,143 $1,604 $3,301 15,000 to 19,999 $8,750 $20,653 $7,752 $18,298 $5,776 $13,633 $6,402 $15,112 $4,096 $9,668 $7,061 $16,667 $9,343 $22,053 $8,739 $20,626 $7,620 $17,987 $6,389 $15,081 $4,988 $11,773 $7,657 $18,074 20,000 to 24,999 $5,755 $13,584 $4,007 $9,457 $2,525 $5,959 $2,239 $5,284 $1,533 $3,618 $3,661 $8,642 $5,893 $13,909 $5,297 $12,503 $7,320 $17,277 $7,124 $16,815 $5,661 $13,363 $7,587 $17,90925,000 to 29,999 $3,622 $8,548 $2,207 $5,209 $1,164 $2,747 $990 $2,337 $494 $1,166 $1,917 $4,524 $3,143 $7,420 $3,215 $7,588 $5,810 $13,715 $6,157 $14,532 $6,143 $14,500 $6,409 $15,129 30,000 to 34,999 $2,092 $4,937 $1,058 $2,498 $705 $1,663 $547 $1,292 $280 $661 $897 $2,117 $1,713 $4,043 $1,733 $4,090 $4,654 $10,985 $5,389 $12,720 $5,529 $13,050 $4,699 $11,091 35,000 to 39,999 $1,260 $2,974 $702 $1,656 $375 $885 $328 $774 $185 $437 $474 $1,119 $940 $2,220 $965 $2,279 $3,222 $7,606 $4,316 $10,187 $4,437 $10,472 $3,227 $7,616 40,000 to 44,999 $662 $1,562 $340 $802 $217 $512 $233 $550 $110 $260 $273 $644 $509 $1,201 $435 $1,028 $2,249 $5,309 $2,980 $7,034 $3,578 $8,446 $2,184 $5,15545,000 to 49,999 $358 $846 $228 $537 $119 $282 $96 $227 $102 $240 $133 $314 $315 $744 $317 $747 $1,544 $3,644 $2,070 $4,886 $2,648 $6,251 $1,416 $3,343 50,000 to 59,999 $270 $637 $154 $364 $133 $314 $79 $187 $76 $180 $136 $322 $182 $429 $248 $585 $840 $1,983 $1,499 $3,538 $1,964 $4,637 $962 $2,271 60,000 to 69,999 $405 $956 $226 $534 $185 $437 $166 $391 $134 $317 $162 $382 $278 $655 $239 $565 $1,032 $2,436 $1,695 $4,001 $2,732 $6,449 $1,099 $2,594 70,000 +$1,410 $3,328 $1,135 $2,679 $915 $2,160 $794 $1,874 $730 $1,723 $861 $2,033 $975 $2,301 $1,132 $2,673 $1,993 $4,705 $3,204 $7,563 $4,611 $10,884 $2,303 $5,436 $50,000 $88,000 $50,230 $76,590 $50,460 $67,334 $50,691 $69,366 $50,923 $60,005 $51,157 $77,175 $51,391 $86,593 $51,627 $85,214 $51,864 $104,173 $52,101 $108,218 $52,340 $110,481 $52,580 $105,233 PROJECTED ANNUAL REVENUE GENERATED FROM PROPOSED RATES =$1,653,747 AMOUNT FROM BASE:$615,364 AMOUNT FROM USAGE:$1,038,383 TOTAL:$1,653,747 SCHEDULE GF-E PROJECTED RETAIL WASTEWATER SALES FY 13 WATER USE CATEGORY PROJECTED FY 2013 RETAIL WATER REVENUES Usage Groups TOTAL 15 SCHEDULE GF-F UNIFORMS WATER ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL ` UNIFORM SHIRTS 4 10 40 $8 $320 POLO SHIRTS 0 0 0 $35 $0 SWEATSHIRTS 4 5 20 $18 $360 PANTS 4 7 28 $25 $700 BOOTS 4 1 4 $175 $700 JACKET 4 1 4 $150 $600 TOTAL:$2,680 WASTEWATER ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 3 6 18 $8 $144 POLO SHIRTS 1 6 6 $35 $210 SWEATSHIRTS 3 5 15 $18 $270 PANTS 4 5 20 $25 $500 BOOTS 4 1 4 $175 $700 JACKET 5 1 5 $150 $750 TOTAL:$2,574 COLLECTIONS ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 3 10 30 $8 $240 POLO SHIRTS 1 6 6 $35 $210 SWEATSHIRTS 3 5 15 $18 $270 PANTS 3 7 21 $25 $525 BOOTS 3 1 3 $175 $525 JACKET 3 1 3 $150 $450 TOTAL:$2,220 ADMINISTRATION ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL POLO SHIRTS 7 5 35 $35 $1,225 SWEATER 4 1 4 $40 $160 PANTS 2 5 10 $25 $250 TOTAL:$1,635 16 SCHEDULE GF-G TRAVEL & TRAINING Training Number to Attend Estimated Class Cost/Person Total Training Estimated Travel & Per Diem Cost Per Person Total Travel & Per Diem Total Dept. Cost WATER Water/WW Classes 4 $225 $900 $50 $200 Management Classes 0 $350 $0 $100 $0 Management Conferences 0 $350 $0 $400 $0 License Renewal 2 $111 $222 $100 $200 Miscellaneous Mileage/Travel (Miles)1,000 $0.55 $550 $0 $300 $1,672 $700 $2,372 WASTEWATER Wastewater Classes 8 $225 $1,800 $50 $400 Management Classes 1 $350 $350 $100 $100 Management Conferences 1 $350 $350 $400 $400 License Renewal 2 $111 $222 $100 $200 Miscellaneous Mileage/Travel (Miles)1,000 $0.55 $550 $0 $300 $3,272 $1,400 $4,672 COLLECTIONS Collections/Distribution Classes 0 $225 $0 $50 $0 Plumbing Class 1 $90 $90 $50 $50 Management Conferences 0 $350 $0 $400 $0 License Renewal 1 $111 $111 $100 $100 CDL Renewal 1 $75 $75 $0 $0 Miscellaneous Mileage/Travel (Miles)1,000 $0.55 $550 $0 $300 $826 $450 $1,276 AMINISTRATION Management Classes 3 $350 $1,050 $300 $900 Management Conferences 2 $350 $700 $400 $800 Elections Training 2 $350 $700 $400 $800 Public Funds Inv. Training 1 $300 $300 $100 $100 Govmt Accounting Conference 0 $350 $0 $400 $0 Software Training 5 $300 $1,500 $50 $250 Customer Service Conferences 2 $350 $700 $400 $800 Miscellaneous Mileage/Travel (Miles)1,000 $0.55 $550 $0 $300 $5,500 $3,950 $9,450 17 SCHEDULE GF-H SALARY WORKSHEET *COLA Merit Merit Total Social TWC Base Pay Base Pay Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medi UNEMP WORKERS FIRE DEPARTMENT %No Split With Split 1.5%0.0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%2.1% TO $4700 COMP Fire Chief 51.00%100,447 51,228 768 0 400 52,397 0 0 1,193 608 0 0 99 Fire Lieutenant 51.00%63,947 32,613 489 0 400 33,502 0 1,160 608 310 1,200 612 99 Fire Lieutenant 51.00%73,133 37,298 559 0 800 38,657 0 1,338 1,478 754 900 459 99 Fire Lieutenant 51.00%69,334 35,360 530 0 800 36,691 0 1,270 863 440 900 459 99 Fire Fighter/EMT-P 51.00%48,168 24,566 368 0 400 25,334 0 877 465 237 600 306 99 Fire Fighter/EMT-P 51.00%47,251 24,098 361 0 400 24,860 0 861 200 102 0 0 99 Engineer - Fire Fighter/EMT-P 51.00%59,808 30,502 458 0 400 31,360 0 1,086 923 470 600 306 99 Engineer - Fire Fighter/EMT-P 51.00%57,576 29,364 440 0 400 30,204 0 1,046 608 310 900 459 99 Engineer - Fire Fighter/EMT-P 51.00%58,824 30,000 450 0 400 30,850 0 1,068 683 348 900 459 99 Fire Fighter/EMT-P 51.00%53,655 27,364 410 0 800 28,575 0 989 683 348 600 306 99 Fire Fighter/EMT-P 51.00%49,361 25,174 378 0 400 25,952 0 898 510 260 600 306 99 Fire Fighter/EMT-P 51.00%46,656 23,795 357 0 400 24,552 0 850 155 79 0 0 99 Fire Fighter/EMT-P 51.00%45,408 23,158 347 0 400 23,905 0 827 0 0 600 306 99 Fire Fighter/EMT-P 51.00%45,408 23,158 347 0 23,505 0 814 0 0 600 306 99 Part-Time Staff 51.00%27,768 14,162 212 0 0 14,374 0 0 0 0 0 0 99 FTO 51.00%0 0 0 0 0 0 0 0 0 1,200 612 Overtime Pay 31,375 TOTAL:846,744 431,839 6,478 0 6,400 444,717 31,375 13,083 4,266 4,896 30,897 7,226 1481 10,000 COLA Merit Merit Total Social TWC Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare UNEMP WORKERS ADMINISTRATION %Base Pay Base Pay 1.5%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%2.1% TO $9000 COMP District Manager 100%101,000 101,000 1,515 0 0 102,515 0 0 0 0 0 0 189 MUD Secretary 100%65,000 65,000 975 0 1,200 67,175 0 0 0 0 0 0 189 PT Coverage - Admin Assistant 100%1,200 1,200 0 0 0 1,200 0 0 0 0 0 0 25 Fin. Analyst/HR Mgr (Vacant)100%70,000 70,000 0 0 0 70,000 0 0 0 0 0 0 189 Finance Manager 100%78,031 78,031 1,170 0 1,200 80,401 0 0 1,913 1,913 0 0 189 Utility Billing/Admin Asst.100%38,205 38,205 573 0 1,040 39,818 0 0 280 280 0 0 189 Utility Billing/Admin Asst.100%32,779 32,779 492 0 1,040 34,310 0 0 0 0 0 0 189 Utility Billing/Admin Asst.100%32,779 32,779 492 0 1,040 34,310 0 0 0 0 0 0 189 Utility Billing/Admin Asst. (PT)100%14,000 14,000 0 0 0 14,000 189 DM Discretionary 1,000 Overtime Pay 1,500 TOTAL:432,993 432,993 5,217 0 5,520 444,730 1,500 0 2,193 0 27,802 6,502 1,537 831 18 SCHEDULE GF-H SALARY WORKSHEET COLA Merit Merit Total Social TWC Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare UNEMP WORKERS WATER %Base Pay Base Pay 1.5%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%2.1% TO $9000 COMP Field Supervisor 100%55,879 55,879 838 0 1100 57,817 0 0 1305 1305 1800 1800 189 Crew Leader 100%42,641 42,641 640 0 1040 44,321 0 0 1005 1005 1500 1500 189 Utility Field Worker 100%39,113 39,113 587 0 1040 40,740 0 0 480 480 900 900 189 Utility Field Worker 100%33,697 33,697 505 0 1040 35,242 0 0 290 290 600 600 189 Utility Field Worker 100%34,200 34,200 0 0 0 34,200 300 189 Overtime Pay 13,250 DM Discretionary 1,000 TOTAL:205,531 205,531 2,570 0 212,321 213,321 13,250 0 3,080 5,100 14,555 3,404 945 6109 COLA Merit Merit Total Social TWC Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare UNEMP WORKERS WASTEWATER %Base Pay Base Pay 1.5%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%2.1% TO $9000 COMP Asst. Superintendent/WW 100%56,500 56,500 847.50 - 3,500 60,848 - - - - - - 189 Crew Leader 100%51,508 51,508 772.62 - 1,040 53,320 - - 1,335 1,335 1,800 1,800 189 Utility Field Worker 100%44,756 44,756 671.34 - 1,040 46,468 - - 945 945 1,800 1,800 189 Utility Field Worker 100%33,602 33,602 504.02 - 1,040 35,146 - - 578 578 600 600 189 Overtime Pay 10,166 - - - - - DM Discretionary 1,000 - - - - - - TOTAL:186,366 186,366 2,795 0 195,781 196,781 10,166 0 2,858 4,200 13,268 3,103 756 2939 COLA Merit Merit Total Social TWC Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare UNEMP WORKERS COLLECTIONS %Base Pay Base Pay 1.5%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%2.1% TO $9000 COMP Utility Superintendent 100%66,500 66,500 997 0 1,500 68,997 0 0 1,845 1,845 0 0 189 Crew Leader 100%48,506 48,506 728 0 1,040 50,273 0 0 1,418 1,418 1,200 1,200 189 Utility Field Worker 100%34,645 34,645 520 0 1,040 36,204 0 0 555 555 600 600 189 Overtime Pay 7,297 0 DM Discretionary 1,000 TOTAL:149,650 149,650 2,245 0 155,475 156,475 7,297 0 3,818 1,800 10,502 2,456 567 3348 19 SCHEDULE GF-I BENEFITS WORKSHEET FIRE DEPARTMENT ADMINISTRATION WATER NO. EMPLOYEES ANNUAL RATE (TCMUD Share @ 50%) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEE S ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED No coverage 0 $0 $0 No coverage 0 $0 $0 No coverage 0 $0 $0 Employee Only 3 $171 $512 Employee Only 3 $341 $1,023 Employee Only 3 $341 $1,023 Employee & Spouse 1 $234 $234 Employee & Spouse 0 $467 $0 Employee & Spouse 0 $467 $0 Employee & Children 1 $240 $240 Employee & Children 0 $479 $0 Employee & Children 1 $479 $479 Family 9 $295 $2,651 Family 4 $589 $2,356 Family 1 $589 $589 TOTAL 14 $3,635 TOTAL 7 $3,379 TOTAL 5 $2,091 NO. EMPLOYEES ANNUAL RATE (TCMUD Share @ 50%) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEE S ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED No coverage 0 $0 $0 No coverage 0 $0 $0 No coverage 0 $0 $0 Employee Only 5 $41 $203 Employee Only 3 $81 $243 Employee Only 3 $81 $243 Employee & Spouse 1 $69 $69 Employee & Spouse 0 $138 $0 Employee & Spouse 0 $138 $0 Employee & Children 1 $69 $69 Employee & Children 1 $138 $138 Employee & Children 1 $138 $138 Family 7 $69 $483 Family 3 $138 $414 Family 1 $138 $138 TOTAL 14 $824 TOTAL 7 $795 TOTAL 5 $519 NO. EMPLOYEES ANNUAL RATE (TCMUD Share @ 50%) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEE S ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED No coverage 0 $0 $0 No coverage 0 $0 $0 No coverage 0 $0 $0 Employee Only 6 $2,526 $15,156 Employee Only 4 $5,052 $20,208 Employee Only 4 $5,052 $20,208 Employee & Spouse 1 $3,818 $3,818 Employee & Spouse 0 $7,635 $0 Employee & Spouse 0 $7,635 $0 Employee & Children 1 $3,217 $3,217 Employee & Children 1 $6,434 $6,434 Employee & Children 0 $6,434 $0 Family 6 $4,356 $26,136 Family 2 $8,712 $17,424 Family 1 $8,712 $8,712 TOTAL 14 $48,327 TOTAL 7 $44,066 TOTAL 5 $28,920 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL $4,250 TOTAL $2,500 TOTAL $1,204 *Includes Vacant F&HR Manager at Family DENTAL DENTAL DENTAL VISION VISION VISION MEDICAL MEDICAL MEDICAL LIFE & OTHER LIFE & OTHER LIFE & OTHER 20 SCHEDULE GF-I BENEFITS WORKSHEET WASTEWATER COLLECTIONS NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED No coverage 0 $0 $0 No coverage 0 $0 $0 Employee Only 0 $341 $0 Employee Only 1 $341 $341 Employee & Spouse 2 $467 $934 Employee & Spouse 0 $467 $0 Employee & Children 0 $479 $0 Employee & Children 1 $479 $479 Family 2 $589 $1,178 Family 1 $589 $589 TOTAL 4 $2,112 TOTAL 3 $1,409 NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED No coverage 0 $0 $0 No coverage 0 $0 $0 Employee Only 0 $81 $0 Employee Only 1 $81 $81 Employee & Spouse 2 $138 $276 Employee & Spouse 0 $138 $0 Employee & Children 0 $138 $0 Employee & Children 1 $138 $138 Family 2 $138 $276 Family 1 $138 $138 TOTAL 4 $552 TOTAL 3 $357 NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED No coverage 0 $0 $0 No coverage 0 $0 $0 Employee Only 1 $5,052 $5,052 Employee Only 1 $5,052 $5,052 Employee & Spouse 2 $7,635 $15,270 Employee & Spouse 0 $7,635 $0 Employee & Children 0 $6,434 $0 Employee & Children 1 $6,434 $6,434 Family 1 $8,712 $8,712 Family 1 $8,712 $8,712 TOTAL 4 $29,034 TOTAL 3 $20,198 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL $920 TOTAL $1,008 LIFE & OTHER LIFE & OTHER DENTAL DENTAL VISION VISION MEDICAL MEDICAL 21 SCHEDULE GF-J RETIREMENT WORKSHEET FIRE DEPARTMENT WASTEWATER TMRS TMRS TOTAL FY 2013 SALARY 14%TOTAL FY 2013 SALARY 14% Thomas, Danny Fire Chief 53,005 7421 Schlielig, Karl Asst. Superintendent/Wastewater 60,848 8,519 Sipes, Gary Fire Lieutenant 35,584 4982 Richey, Jeff Crew Leader 56,455 7,904 Beck, Shane Fire Lieutenant 41,208 5769 Valadez, Orly Utility Field Worker 49,213 6,890 Hurd, Donnie Fire Lieutenant 38,860 5440 Burchfield, Greg Utility Field Worker 36,323 5,085 Tackett, Matthew Fire Fighter/EMT-P 26,754 3746 Overtime Pay 10,166 1,423 Johnson, Sam Fire Fighter/EMT-P 25,822 3615 TOTAL:213,005 29,821 Hards, Dusten Engineer - Fire Fighter/EMT-P 33,222 4651 Garrett, Shawn Engineer - Fire Fighter/EMT-P 32,019 4483 Boos, Gregory Engineer - Fire Fighter/EMT-P 32,725 4582 COLLECTIONS Peters, Brian Fire Fighter/EMT-P 30,218 4230 TMRS Rusk, Darryl "Steve"Fire Fighter/EMT-P 27,416 3838 TOTAL FY 2013 SALARY 14% Cloud, Casey Fire Fighter/EMT-P 25,481 3567 Womack, Adrian Utility Superintendent 70,842 9,918 Eric Sampson Fire Fighter/EMT-P 25,039 3505 Roberts, DeWayne Crew Leader 52,891 7,405 Vacant Fire Fighter/EMT-P 24,625 3447 Utility Field Worker 37,359 5,230 Various Part-Time Staff 14,374 0 Ramirez, Jason FTO 612 86 Overtime Pay 7,297 1,022 Overtime Pay 42,000 5880 TOTAL:168,389 23,574 TOTAL:508,962 69,242 ADMINISTRATION TMRS TOTAL FY 2013 SALARY 14% Jennifer McKnight District Manager 102,515 14,352 Laurie Slaght MUD Secretary 67,175 9,405 Thomas, Tammy Part-Time Coverage - Admin Assistant 1,200 0 Vacant Finance & HR Manager (Vacant)70,000 9,800 Gonzales, Renae Senior Accountant 82,314 11,524 D'Andria, Nicole Utility Billing/Admin Asst.40,098 5,614 Schaefer, Marsha Utility Billing/Admin Asst.34,310 4,803 Schultz, Kari Utility Billing/Admin Asst.34,310 4,803 Cook, Gina Utility Billing/Admin Asst. (Part Time)14,000 0 Overtime Pay 1,000 140 TOTAL:446,922 60,441 WATER TMRS TOTAL FY 2013 SALARY 14% McMahon, Mike Field Supervisor 60,922 8529 Cooper, Bert Crew Leader 46,826 6556 Perry, Charles Utility Field Worker 42,120 5897 Holt, Lance Utility Field Worker 36,132 5059 Vacant Utility Field Worker 34,500 4830 Overtime Pay 13,250 1855 TOTAL:233,751 32,725 22 SCHEDULE GF-K Electricity & Gas Analysis for FY 2011-2012 Hudson Energy FY 2012 ESID #Expense Acct Location KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed Total KWH Total $ Cost per KWH 10% INCREASE 2836193 135-60020-010 Water Well #1, Well #3 98,160 8,679 109,128 9,524 91,392 8,162 74,832 6,882 23,808 2,914 10,968 1,778 18,144 1,863 15,144 1,662 15,384 1,676 17,016 1,784 39,888 3,651 75,264 5,924 572,112 52,714 0.092139 57,985 2770721 135-60020-010 Elevated Tank-TW King 44 14 49 14 59 15 66 16 77 17 518 63 1,221 121 997 101 990 100 1,074 108 275 35 51 14 4,347 511 0.117442 562 2828381 135-60020-010 Paluxy Well #4 2,992 317 3,104 329 2,952 315 2,784 298 2,760 295 3,088 328 3,344 314 2,832 268 2,784 263 2,976 281 3,096 292 3,064 290 32,800 3,309 0.100874 3,640 2829590 135-60020-010 Paluxy Well #2 15,072 1,370 15,372 1,393 14,784 1,350 14,250 1,308 14,406 1,320 16,056 1,442 17,184 1,311 14,670 1,136 14,634 1,123 16,188 1,230 14,610 1,123 14,988 1,153 166,026 14,029 0.084497 15,432 2836131 135-60020-010 Water Plant/Water Barn 1,560 329 1,824 322 1,512 291 840 199 552 169 2,976 563 3,912 527 4,368 548 1,992 390 696 235 672 170 888 183 21,096 3,691 0.174945 4,060 2836162 135-60020-010 Water plant pump station 85,560 9,065 115,830 12,366 98,820 11,105 60,720 7,433 40,080 4,847 36,210 3,927 32,760 3,317 26,640 2,952 28,560 3,295 38,370 3,469 47,580 5,110 43,710 4,902 616,470 68,319 0.110823 75,151 8644641 135-60020-010 100 Municipal Dr, Unit B 0 625 0 625 0 625 600 220 600 578 700 585 700 55 700 55 700 48 700 10 700 10 17,000 1,501 21,700 4,926 0.227016 5,419 9130039 135-60020-010 2901 Bobcat Unit A, Elev Tank 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,267 148 1,267 148 0.116898 163 TOTAL: 162,410 2828536 135-60020-020 Sewer Plant 175,466 15,178 172,993 15,382 168,700 15,118 164,588 14,832 159,690 14,378 134,286 12,915 149,339 11,460 125,191 9,990 124,053 9,838 130,377 10,252 123,901 9,837 129,719 10,205 1,627,926 139,132 0.085466 153,045 TOTAL:153,045 7716439 135-60020-021 WWTP Barn/Split Town/MUD 1,005 166 984 133 1,110 148 873 133 683 118 623 250 750 123 612 114 557 101 678 96 775 100 750 114 8,722 1,502 0.172198 1,652 8611313 135-60020-021 Collection Barn for Vac-Con 840 204 528 130 720 130 480 143 768 212 3,144 468 7,824 666 2,928 351 1,800 277 384 130 528 107 432 117 19,992 2,805 0.140292 3,085 8251800 135-60020-021 310 Skyline-Lift Sta #6 525 144 675 177 435 158 435 158 405 176 870 185 690 163 525 152 615 169 540 164 675 173 465 160 6,315 1,815 0.287408 1,996 5437067 135-60020-021 Lift Sta #2 Guard Light 70 15 70 15 70 15 70 15 70 15 70 14 70 13 70 13 70 13 70 13 70 13 70 13 770 155 0.200714 170 2820941 135-60020-021 Lift Station Trophy 20 338 48 293 43 249 38 305 45 320 46 407 51 394 46 362 43 342 41 411 47 358 42 347 42 3,715 485 0.130665 534 2828598 135-60020-021 Lift Station #4 848 160 816 143 784 134 768 139 768 139 816 124 880 124 816 120 816 126 912 133 752 109 800 112 8,864 1,431 0.161489 1,575 6245046 135-60020-021 Lift Station #2 1,224 221 1,200 190 1,200 191 1080 181 1,056 171 1,368 187 1,656 161 1,584 232 1,536 227 1,944 260 1,368 223 1,416 226 14,688 2,209 0.150397 2,430 9215255 135-60020-021 Lift Station #1 855 219 705 119 810 156 870 223 795 134 1,035 210 1,155 207 1,005 197 945 191 1,155 211 870 116 810 112 9,855 1,885 0.191248 2,073 9843774 135-60020-021 Lift Station #7 47 15 82 19 75 19 83 20 74 19 101 20 119 21 128 21 110 20 117 20 134 22 146 23 1,099 218 0.198553 240 8306586 135-60020-021 PID Lift Station #8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 302 35 368 43 478 53 846 97 0.114362 106 TOTAL:13,862 8797254 122-60020-045 Fire Station 2,680 251 10,706 1,249 10,705 1,005 16687 1,388 7,956 758 9,352 871 9,234 836 7,881 748 7,963 752 10,038 894 9,923 892 12,363 1,059 105,450 9,810 0.09303 10,791 TOTAL:10,791 Split 50/50 with Town:5,396 Direct Energy (Split with Town) This is only the MUD expense 2836100 135-60020-027 MUD & PW Bldgs 6,706 1,315 13,905 1,426 12,190 1,288 8599 986 8,145 976 11,880 1,290 12,523 1,342 10,422 1,188 9,194 1,051 8,973 988 8,771 972 0 0 102,335 11,835 0.115652 13,019 TOTAL:13,019 Tri-County Meter # 165775 135-60020-021 Lift Station 3 3239 325 3312 323 3058 285 2604 246 2745 258 2563 243 2613 234 2615 234 2980 278 2842 266 2951 260 0 0 28,680 2,686 0.093643 2,954 170037 135-60020-021 Lift Station 5 1711 184 1634 173 1602 161 1314 137 1319 137 1123 121 1179 120 1195 121 1307 136 1338 139 1552 149 0 0 13,936 1,439 0.103244 1,583 170038 135-60020-021 lift Station 5 (Backup)21 28 22 28 26 28 23 28 28 28 25 28 23 28 24 28 26 28 24 28 25 28 0 0 243 278 1.143539 306 TOTAL:4,843 Atmos - Gas @ Fire Station (Measures by Thousand Cubic Feet) Meter S/N 11N375438122-60020-045 Fire Station 7 77.34 5.9 65.19 22.4 185.62 43.7 320.07 43.6 300.38 41.9 265.99 16.3 108.19 6.2 54.11 6.1 48.32 2.8 32.34 196 1,403 7.164063 1,544 TOTAL:1,544 Split 5/50 with Town:771.89 12-Jun Jul-11 Aug-11 Sept-11 Oct-11 Nov-11 Dec-11 Jan-12 12-Feb 12-Mar 12-Apr May-12 23 SCHEDULE GF-L SEMO Account Number Department Amount FY 2013 Comment Amount FY 2012 135-55160-027 Information Technology 78,461 60% Town 40% MUD split of IT budget 90,576 Human Resources Payroll 8,050 MUD Payroll Services through January 1st 68,053 Public Relations 0 24,711 Community Development/Permitting 0 17,500 Grounds Maintenance 9025 Includes all site except WWTP; 17 per year 0 Janitorial Services -10,071 10,071 TOTAL:85,465 210,911 Information Systems Account Number Description Description Amount 135-55030-027 Software & Support Used R For Recurring, NR For Non-Recurring. *** - Non Dept Specific R-STW - GL/Payroll Software Lease & Maint 7,770$ R-STW - GL Support & Upgrades 5,250$ R-STW - UB Software Lease & Maintenance 2,363$ R-STW - UB Support & Upgrades 2,625$ R-Internet Connectivity, 50% Shared.10,500$ R-Web Hosting 300$ R-Web Streaming Provider, 50% Shared 300$ R-Web Maintenance (Domains, SSL Cert, etc)85$ R-Blackberry (BES) Annual Support TX2, Shared 313$ R-Blackberry Device Support for BES (x27 devices) Split 30% MUD($1368)411$ R-Symantec Image Maintenance, 40% Shared.140$ R-TotalInfo for PEG Channel, 50% shared.500$ R-Firewall Security Updates & Suppt, 50% Shared.450$ R-CRM Software Maintenance, 50% Shared.638$ R-Network Security Software, 50% Shared.1,250$ R-Miscellaneous Software and Licensing, 50% Shared 1,450$ R-Connect-CTY Maintenance, 50% Shared.3,650$ R-Electronic Timeclock/Payroll Main, 50% Shared.1,230$ R-Helpdesk Software Maintenance, 50% Shared.215$ R-Postini Mail Screening, 50% Shared.144$ R-ListServ, 50% Shared.450$ R-Fuel Master Maintenance, 50% Shared.750$ R-Online Survey, 50% Shared.250$ R-Anti-Virus Maintenance and Support, 40% Shared.452$ R-Malware-Bytes Maintenance and Support, 40% Shared.600$ R-Micorsoft Tech Subscription, 50% Shared 250$ NR-AE Upgrade, 50% Shared 3,000$ R-VMWare Annual Support, 50% Shared 2,690$ R-Veeam Annual Support, 50% Shared 2,124$ *** Fire Department R-Firehouse Support and Maintenance 1,575$ *** - MUD Manager R-Agenda Maintenance and Support, 50% Shared.4,590$ *** - Collection Department R-Automatic Meter Reading Maintenance 3,590$ R-Pipelogix Maintenance 1,900$ R-AudioTel Remit Plus Annual Support 1,750$ 24 Totals:63,555$ SCHEDULE GF-L SEMO 135-65055-027 Hardware R-Backup Tape Replacement, 50% Shared.480$ R-Accessories, mice, keyboards, etc, 50% Shared.358$ R-Repair and Maintenance 2,000$ R-Network Hardware 500$ R-A/V Miscellaneous Equipment, 50% Shared.1,200$ ************************************************** GASB 34 Expenditures (Offsetting Revenue) ************************************************** NR - Replacement Computers 6,650$ NR - Replacement Servers -$ NR - Replacement Copiers & Printers 2,500$ NR - Replacement Infrastructure 3,250$ NR - Replacement Phones -$ NR - Replacement Audio Video -$ NR - Replacement Security -$ NR - Replacement Software 3,250$ NR - Replacement First Responders MDT -$ NR - Replacement Other -$ 15,650$ Used R For Recurring, NR For Non-Recurring. Totals:20,188$ 135-65090-027 Printer Supplies We use the following formula to determine the annual costs. We take the average toner yield and divide it by the page counts to determine the amount of toner needed per device. We have also included a few maintenance kits for the older printers. It does include all the plotter supplies.5,732$ Totals:5,732$ 135-69170-027 Copier Rental/Lease Description Amount Monthly lease for the following copiers. Administration Copier, 50% Shared.1,900$ Public Works Copier, 50% Shared.1,550$ Totals:3,450$ 25 SCHEDULE GF-M FUEL LUBE Water Department Gallons Price Average Price /Gallon No. Vehicles No./Year Total/Year Cost Each Total Amt. OIL CHANGES 6 4 24 $50 $1,200 Golf Carts/ pumps/mowers/misc.496.70 $1,710.44 $3.44 INSPECTIONS 6 1 6 $50 $300 Dodge Dakota 345.14 $1,177.49 $3.41 Generator Maintenance $1,000 Ford f-350 Dually 328.18 $1,138.43 $3.47 Generator Fuel $500 Dump Truck 133.50 $481.60 $3.61 Cat Backhoe 608.30 $2,258.23 $3.71 2004 Chevy 501.10 $1,989.20 $3.97 2007 Dodge 2500 930.13 $3,301.16 $3.55 2012 Ford crew cab 56.53 $189.38 $3.35 Total Fuel and Lube:$17,661 Average:3399.58 $12,245.93 $3.56 3739.54 $14,661 $3.92 10% Increase Wastewater Department Ford F-350 56.06 $180.23 $3.21 No. Vehicles No./Year Total/Year Cost Each Total Amt. Misc. WWTP 132.50 $445.13 $3.36 OIL CHANGES 4 4 16 $50 $800 Ford F-150 453.91 $1,574.40 $3.47 INSPECTIONS 4 1 4 $50 $200 GMC 1 ton 90.75 $310.07 $3.42 Generator Maintenance $1,120 Ford Backhoe 98.30 $364.20 $3.70 Generator Fuel $2,000 Ford F 350 Ex. Cab 207.77 $716.13 $3.45 Average:1039.29 $3,590.16 $3.50 Total Fuel and Lube:$8,527 1143.22 $4,407 $3.86 10% Increase Collection Department Ford F 150 353.98 $1,223.38 $3.46 No. Vehicles No./Year Total/Year Cost Each Total Amt. Gap Vax 863.70 $3,242.24 $3.75 OIL CHANGES 5 4 20 $50 $1,000 Camera Van 43.18 $152.49 $3.53 INSPECTIONS 5 1 5 $50 $250 Ford F 150 19.96 $64.87 $3.25 Generator Maintenance $650 Ford F 350 Ext. Cab Dually 831.06 $2,864.28 $3.45 Generator Fuel $500 Ford F 150 164.54 $559.48 $3.40 AVERAGE:2276.42 $8,106.74 $3.53 Total Fuel and Lube:$12,117 2504.06 $9,717 $3.88 10% Increase N/awomack/private 26 TAX WORKSHEET TAXABLE VALUES AND ESTIMATED REVENUES FROM AD VOLOREM TAX NET TAX VALUE TARRANT COUNTY:276,634,946 DENTON COUNTY:733,315,607 DENTON CO. PID:242,388,092 CARR REQUEST REQUIRED REVENUE FY 2012 TAX RATE REVENUE FY 2013 SCENARIO 1 TAX RATE REVENUE SCENARIO 2 TAX RATE REVENUE SCENARIO 3 TAX RATE REVENUE FIRE TAX:0.10925 1,103,371 0.104 1,050,349 0.105 1,060,448 0.106 1,070,548 FIRE PID:0.10925 264,809 0.104 252,084 0.105 254,507 0.106 256,931 1,335,882 FIRE TOTAL:1,368,180 TOTAL:1,302,432 TOTAL:1,314,956 TOTAL:1,327,479 838,033 I&S 0.05586 564,158 0.0195 196,940 0.05586 564,158 110,100 O&M 0.00989 99,884 0.00989 99,884 0.00989 99,884 27 April May June Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,999 6.3%0.2%6.8%0.2%7.9%0.3%7.8%0.3%10.1%0.6%8.4%0.4%6.6%0.2%6.5%0.2%5.4%0.1%5.0%0.1%4.4%0.0%4.8%0.1% 2,000 to 2,999 3.4%0.4%4.8%0.8%5.8%1.1%4.5%0.9%7.1%1.7%6.0%1.4%3.5%0.5%4.0%0.6%2.1%0.2%1.5%0.1%1.7%0.1%1.9%0.2% 3,000 to 3,999 4.9%1.0%7.0%1.7%8.7%2.5%6.9%2.1%10.7%3.9%8.3%3.0%4.2%0.9%5.5%1.2%2.2%0.3%1.6%0.2%1.4%0.1%2.2%0.3% 3,000 to 3,999 5.9%1.6%8.9%2.8%11.2%4.3%9.7%3.8%12.6%6.0%9.5%4.3%5.6%1.6%6.8%2.0%2.6%0.5%1.5%0.2%1.4%0.2%2.6%0.4% 4,000 to 4,999 5.9%2.0%8.0%3.1%10.2%4.8%9.9%4.8%12.0%7.1%9.1%5.0%6.3%2.2%6.5%2.3%2.7%0.6%1.8%0.3%1.7%0.3%2.4%0.5% 5,000 to 5,999 5.5%2.2%7.3%3.4%9.5%5.3%10.4%6.0%10.2%7.2%7.5%4.6%6.4%2.7%6.7%2.9%2.8%0.8%1.9%0.4%1.8%0.3%2.9%0.7% 6,000 to 6,999 5.5%2.5%7.1%3.8%7.4%4.9%8.7%5.9%7.7%6.3%6.6%4.6%5.8%2.8%5.9%2.9%3.3%1.1%1.9%0.5%1.6%0.4%3.0%0.8% 7,000 to 7,999 5.0%2.6%5.8%3.5%5.9%4.4%8.0%6.2%6.1%5.7%5.4%3.9%5.9%3.3%5.3%3.0%3.0%1.1%2.0%0.6%1.8%0.5%2.9%0.9% 8,000 to 8,999 4.4%2.4%4.6%3.1%5.5%4.6%5.8%5.0%4.7%4.8%4.9%3.9%5.4%3.3%4.9%3.1%2.9%1.2%2.4%0.8%1.6%0.5%2.9%1.0% 9,000 to 13,999 4.0%2.5%4.1%3.0%3.9%3.5%4.9%4.7%3.6%4.1%3.8%3.2%4.9%3.3%4.6%3.1%3.0%1.4%2.2%0.8%1.8%0.6%3.1%1.2% 14,000 to 18,999 17.5%13.1%15.4%14.0%11.4%13.1%12.6%14.9%8.0%11.2%13.8%13.7%18.2%15.5%16.9%14.4%14.7%8.5%12.3%5.7%9.5%4.1%14.6%7.5% 19,000 to 23,999 11.5%11.4%8.0%9.9%5.0%7.8%4.4%7.3%3.0%5.7%7.2%9.5%11.5%13.2%10.3%11.7%14.1%10.7%13.7%8.5%10.8%6.3%14.4%10.0% 24,000 to 28,999 7.2%8.8%4.4%6.9%2.3%4.6%2.0%4.1%1.0%2.4%3.7%6.3%6.1%8.8%6.2%9.0%11.2%10.4%11.8%9.3%11.7%8.3%12.2%10.5% 29,000 to 33,999 4.2%6.2%2.1%3.9%1.4%3.4%1.1%2.8%0.6%1.7%1.8%3.5%3.3%5.8%3.4%5.9%9.0%9.8%10.3%9.6%10.6%8.8%8.9%9.3% 34,000 to 38,999 2.5%4.3%1.4%3.2%0.7%2.2%0.6%2.1%0.4%1.3%0.9%2.5%1.8%3.7%1.9%3.8%6.2%7.9%8.3%9.0%8.5%8.1%6.1%7.5% 39,000 to 43,999 1.3%2.7%0.7%1.8%0.4%1.5%0.5%1.6%0.2%1.0%0.5%1.5%1.0%2.4%0.8%2.0%4.3%6.2%5.7%7.1%6.8%7.5%4.2%5.7% 44,000 to 48,999 0.7%1.6%0.5%1.3%0.2%1.0%0.2%0.8%0.2%1.0%0.3%0.8%0.6%1.7%0.6%1.6%3.0%4.9%4.0%5.5%5.1%6.1%2.7%4.2% 49,000 to 58,999 0.5%1.4%0.3%1.1%0.3%1.1%0.2%0.7%0.2%0.8%0.3%1.0%0.4%1.1%0.5%1.4%1.6%2.9%2.9%4.4%3.8%5.0%1.8%3.1% 59,000 to 68,999 0.8%2.4%0.5%1.8%0.4%1.9%0.3%1.7%0.3%1.7%0.3%1.6%0.5%1.9%0.5%1.6%2.0%4.2%3.3%5.6%5.2%7.8%2.1%4.2% 69,000 +2.8%30.7%2.3%30.8%1.8%27.7%1.6%24.3%1.4%25.8%1.7%25.1%1.9%25.2%2.2%27.4%3.8%27.2%6.2%31.3%8.8%35.1%4.4%32.1% 100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0% WATER USE % BY 5.6%8.1%9.0%12.9%10.4%10.9%10.9%8.3%6.9%6.4%5.9%4.6%100.0% MONTH Usage Groups TOTAL 3 YEAR AVERAGE PERCENT USE October November December January February March July August September 28 Year: FY 2009 April May June Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,999 149 56,000 176 72,000 217 92,000 200 73,000 223 97,000 221 79,000 173 59,000 232 93,000 204 64,000 164 46,000 163 53,000 177 60,000 2,000 to 2,999 63 126,000 89 178,000 160 320,000 122 244,000 167 334,000 134 268,000 118 236,000 155 310,000 96 192,000 35 70,000 62 124,000 62 124,000 3,000 to 3,999 92 276,000 122 366,000 243 729,000 159 477,000 246 738,000 156 468,000 133 399,000 230 690,000 113 339,000 35 105,000 60 180,000 79 237,000 4,000 to 4,999 115 460,000 188 752,000 313 1,252,000 253 1,012,000 328 1,312,000 222 888,000 186 744,000 288 1,152,000 122 488,000 31 124,000 63 252,000 97 388,000 5,000 to 5,999 116 580,000 178 890,000 291 1,455,000 259 1,295,000 322 1,610,000 242 1,210,000 232 1,160,000 261 1,305,000 140 700,000 43 215,000 89 445,000 85 425,000 6,000 to 6,999 131 786,000 186 1,116,000 296 1,776,000 303 1,818,000 300 1,800,000 233 1,398,000 213 1,278,000 263 1,578,000 161 966,000 49 294,000 86 516,000 112 672,000 7,000 to 7,999 120 840,000 178 1,246,000 219 1,533,000 247 1,729,000 239 1,673,000 221 1,547,000 188 1,316,000 219 1,533,000 177 1,239,000 46 322,000 76 532,000 126 882,000 8,000 to 8,999 141 1,128,000 182 1,456,000 178 1,424,000 256 2,048,000 200 1,600,000 192 1,536,000 184 1,472,000 200 1,600,000 139 1,112,000 40 320,000 81 648,000 114 912,000 9,000 to 9,999 119 1,071,000 152 1,368,000 187 1,683,000 166 1,494,000 178 1,602,000 171 1,539,000 170 1,530,000 168 1,512,000 149 1,341,000 46 414,000 74 666,000 119 1,071,000 10,000 to 14,999 123 1,230,000 132 1,320,000 114 1,140,000 152 1,520,000 122 1,220,000 136 1,360,000 159 1,590,000 139 1,390,000 137 1,370,000 45 450,000 100 1,000,000 129 1,290,000 15,000 to 19,999 611 7,848,000 562 7,189,000 342 4,375,000 444 5,556,000 334 4,224,000 539 6,851,000 534 6,778,000 450 5,697,000 556 7,137,000 247 3,228,000 470 6,103,000 507 6,544,000 20,000 to 24,999 418 7,516,000 320 5,713,000 163 2,906,000 169 2,990,000 145 2,555,000 256 4,529,000 292 5,203,000 173 3,076,000 414 7,362,000 342 6,122,000 460 8,293,000 465 8,334,000 25,000 to 29,999 281 6,397,000 193 4,383,000 73 1,666,000 79 1,789,000 45 1,019,000 125 2,849,000 168 3,806,000 95 2,166,000 235 5,345,000 330 7,612,000 408 9,320,000 325 7,411,000 30,000 to 34,999 150 4,149,000 102 2,829,000 42 1,159,000 44 1,230,000 26 720,000 43 1,187,000 91 2,527,000 47 1,307,000 139 3,836,000 377 10,522,000 292 8,118,000 251 6,960,000 35,000 to 39,999 97 3,189,000 48 1,563,000 22 717,000 20 662,000 16 524,000 24 786,000 46 1,510,000 20 660,000 81 2,648,000 318 10,505,000 176 5,781,000 142 4,657,000 40,000 to 44,999 48 1,797,000 26 982,000 15 563,000 24 907,000 5 194,000 15 577,000 28 1,044,000 13 485,000 49 1,852,000 224 8,515,000 142 5,390,000 103 3,870,000 45,000 to 49,999 25 1,070,000 21 887,000 3 128,000 5 211,000 7 307,000 7 301,000 11 472,000 8 349,000 35 1,516,000 169 7,281,000 76 3,253,000 56 2,403,000 50,000 to 59,999 13 626,000 13 620,000 9 429,000 4 187,000 8 383,000 8 382,000 10 478,000 6 290,000 13 618,000 132 6,323,000 54 2,589,000 29 1,390,000 60,000 to 69,999 30 1,662,000 8 445,000 11 624,000 12 651,000 6 341,000 7 401,000 12 662,000 8 445,000 22 1,225,000 164 8,959,000 51 2,797,000 40 2,218,000 70,000 +101 18,643,000 80 15,227,000 62 10,756,000 51 9,165,000 58 10,509,000 56 10,353,000 65 12,672,000 57 9,623,000 77 14,560,000 251 34,533,000 127 23,964,000 115 24,849,000 TOTAL 2,943 59,450,000 2,956 48,602,000 2,960 34,727,000 2,969 35,058,000 2,975 32,762,000 3,008 38,509,000 3,013 44,936,000 3,032 35,261,000 3,059 53,910,000 3,088 105,960,000 3,110 80,024,000 3,133 74,697,000 WATER USE PER METER 20,200 16,442 11,732 11,808 11,012 12,802 14,914 11,630 17,623 34,313 25,731 23,842 PER MONTH (GALLONS) MONTHLY RETAIL CUSTOMER AND WATER USE BY CATEGORY 2008 2008 2008 2009 2009 2009 2009 2009 2009 2009 2009 2009 SeptemberWATER USE October November December January CATEGORY February March July August 29 Year: FY 2010 April May June Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,999 259 107,000 265 117,000 288 122,000 275 109,000 332 141,000 404 184,000 265 93,000 197 71,000 151 34,000 153 50,000 117 30,000 152 54,000 2,000 to 2,999 151 302,000 209 418,000 231 462,000 149 298,000 239 478,000 337 674,000 129 258,000 132 264,000 49 98,000 54 108,000 58 116,000 73 146,000 3,000 to 3,999 250 750,000 314 942,000 353 1,059,000 282 846,000 413 1,239,000 504 1,512,000 160 480,000 165 495,000 53 159,000 74 222,000 47 141,000 92 276,000 4,000 to 4,999 267 1,068,000 409 1,636,000 444 1,776,000 346 1,384,000 444 1,776,000 493 1,972,000 212 848,000 190 760,000 56 224,000 68 272,000 47 188,000 107 428,000 5,000 to 5,999 293 1,465,000 340 1,700,000 365 1,825,000 347 1,735,000 415 2,075,000 422 2,110,000 242 1,210,000 183 915,000 70 350,000 78 390,000 43 215,000 104 520,000 6,000 to 6,999 261 1,566,000 274 1,644,000 333 1,998,000 338 2,028,000 326 1,956,000 281 1,686,000 264 1,584,000 209 1,254,000 41 246,000 91 546,000 54 324,000 117 702,000 7,000 to 7,999 246 1,722,000 267 1,869,000 252 1,764,000 298 2,086,000 269 1,883,000 219 1,533,000 248 1,736,000 172 1,204,000 63 441,000 91 637,000 45 315,000 111 777,000 8,000 to 8,999 207 1,656,000 190 1,520,000 183 1,464,000 248 1,984,000 182 1,456,000 136 1,088,000 230 1,840,000 152 1,216,000 74 592,000 93 744,000 61 488,000 115 920,000 9,000 to 9,999 151 1,359,000 135 1,215,000 153 1,377,000 169 1,521,000 128 1,152,000 106 954,000 188 1,692,000 150 1,350,000 53 477,000 130 1,170,000 43 387,000 108 972,000 10,000 to 14,999 147 1,470,000 110 1,100,000 84 840,000 155 1,550,000 107 1,070,000 62 620,000 176 1,760,000 153 1,530,000 81 810,000 118 1,180,000 38 380,000 103 1,030,000 15,000 to 19,999 433 5,542,000 316 3,992,000 253 3,214,000 317 3,939,000 183 2,258,000 125 1,559,000 568 7,167,000 582 7,456,000 407 5,365,000 579 7,493,000 256 3,369,000 579 7,508,000 20,000 to 24,999 204 3,601,000 123 2,178,000 78 1,364,000 100 1,755,000 53 937,000 46 816,000 284 5,056,000 384 6,890,000 427 7,650,000 521 9,307,000 328 5,945,000 483 8,647,000 25,000 to 29,999 86 1,944,000 62 1,398,000 34 779,000 33 753,000 23 525,000 20 455,000 114 2,587,000 245 5,605,000 403 9,205,000 401 9,149,000 405 9,355,000 374 8,543,000 30,000 to 34,999 51 1,403,000 26 699,000 23 640,000 21 585,000 8 225,000 9 249,000 51 1,413,000 129 3,592,000 379 10,636,000 250 6,992,000 371 10,359,000 259 7,190,000 35,000 to 39,999 21 692,000 22 727,000 20 652,000 22 730,000 11 359,000 14 460,000 25 827,000 61 2,005,000 289 9,530,000 203 6,653,000 326 10,774,000 172 5,683,000 40,000 to 44,999 17 638,000 13 485,000 8 302,000 11 415,000 8 294,000 4 149,000 22 830,000 30 1,136,000 209 7,878,000 110 4,179,000 257 9,749,000 94 3,574,000 45,000 to 49,999 9 384,000 9 392,000 9 386,000 5 216,000 5 211,000 2 83,000 16 692,000 23 988,000 142 6,074,000 68 2,914,000 196 8,392,000 62 2,639,000 50,000 to 59,999 7 332,000 8 387,000 5 234,000 4 191,000 3 141,000 2 97,000 4 194,000 18 866,000 83 3,969,000 47 2,246,000 139 6,686,000 36 1,730,000 60,000 to 69,999 13 723,000 8 437,000 10 555,000 10 554,000 11 597,000 9 498,000 13 711,000 17 937,000 98 5,365,000 38 2,057,000 198 10,844,000 58 3,183,000 70,000 +67 11,046,000 57 10,954,000 45 7,596,000 41 6,714,000 31 4,510,000 32 4,835,000 51 10,571,000 76 15,154,000 162 26,158,000 131 23,948,000 291 40,667,000 117 25,306,000 TOTAL 3,140 37,770,000 3,157 33,810,000 3,171 28,409,000 3,171 29,393,000 3,191 23,283,000 3,227 21,534,000 3,262 41,549,000 3,268 53,688,000 3,290 95,261,000 3,298 80,257,000 3,320 118,724,000 3,316 79,828,000 WATER USE PER METER 12,029 10,710 8,959 9,269 7,296 6,673 12,737 16,428 28,955 24,335 35,760 24,074 PER MONTH (GALLONS) MONTHLY RETAIL CUSTOMER AND WATER USE BY CATEGORY 2009 2009 2009 2010 2010 2010 2010 2010 2010 2010 2010 2010 SeptemberWATER USE October November December January CATEGORY February March July August 30 Year: FY 2011 April May June Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,999 187 65,000 209 78,000 249 102,000 266 102,000 423 226,000 184 56,000 205 69,000 196 70,000 169 47,000 176 52,000 155 49,000 149 50,000 2,000 to 2,999 106 212,000 162 324,000 159 318,000 159 318,000 279 558,000 106 212,000 92 184,000 103 206,000 58 116,000 59 118,000 44 88,000 56 112,000 3,000 to 3,999 120 360,000 235 705,000 226 678,000 223 669,000 365 1,095,000 141 423,000 117 351,000 136 408,000 50 150,000 47 141,000 31 93,000 46 138,000 4,000 to 4,999 181 724,000 249 996,000 309 1,236,000 326 1,304,000 441 1,764,000 199 796,000 146 584,000 180 720,000 71 284,000 46 184,000 32 128,000 52 208,000 5,000 to 5,999 146 730,000 247 1,235,000 308 1,540,000 340 1,700,000 411 2,055,000 214 1,070,000 125 625,000 183 915,000 50 250,000 57 285,000 36 180,000 43 215,000 6,000 to 6,999 125 750,000 237 1,422,000 267 1,602,000 351 2,106,000 349 2,094,000 208 1,248,000 142 852,000 178 1,068,000 69 414,000 52 312,000 31 186,000 58 348,000 7,000 to 7,999 155 1,085,000 227 1,589,000 232 1,624,000 282 1,974,000 226 1,582,000 194 1,358,000 126 882,000 177 1,239,000 74 518,000 47 329,000 39 273,000 54 378,000 8,000 to 8,999 119 952,000 179 1,432,000 201 1,608,000 258 2,064,000 203 1,624,000 187 1,496,000 159 1,272,000 159 1,272,000 81 648,000 66 528,000 32 256,000 58 464,000 9,000 to 9,999 146 1,314,000 151 1,359,000 185 1,665,000 215 1,935,000 139 1,251,000 193 1,737,000 165 1,485,000 163 1,467,000 76 684,000 58 522,000 41 369,000 57 513,000 10,000 to 14,999 109 1,090,000 142 1,420,000 171 1,710,000 156 1,560,000 112 1,120,000 173 1,730,000 134 1,340,000 154 1,540,000 75 750,000 54 540,000 37 370,000 68 680,000 15,000 to 19,999 600 7,806,000 582 7,463,000 500 6,375,000 437 5,429,000 243 3,018,000 670 8,623,000 669 8,624,000 627 8,076,000 473 6,185,000 395 5,184,000 205 2,670,000 357 4,708,000 20,000 to 24,999 462 8,275,000 310 5,582,000 238 4,232,000 149 2,631,000 85 1,473,000 393 6,961,000 551 9,784,000 461 8,153,000 553 9,951,000 497 8,936,000 276 4,995,000 493 8,915,000 25,000 to 29,999 316 7,230,000 158 3,609,000 114 2,617,000 73 1,642,000 23 529,000 221 5,012,000 320 7,279,000 278 6,352,000 478 10,956,000 443 10,162,000 351 8,080,000 530 12,174,000 30,000 to 34,999 195 5,418,000 69 1,895,000 69 1,909,000 37 1,033,000 18 503,000 121 3,367,000 187 5,203,000 158 4,373,000 379 10,620,000 395 11,025,000 395 11,077,000 390 10,850,000 35,000 to 39,999 120 3,926,000 63 2,060,000 29 952,000 19 618,000 7 231,000 53 1,743,000 110 3,600,000 107 3,511,000 252 8,273,000 295 9,694,000 353 11,622,000 309 10,175,000 40,000 to 44,999 60 2,266,000 25 933,000 18 681,000 8 300,000 8 309,000 33 1,255,000 47 1,778,000 41 1,542,000 177 6,680,000 231 8,713,000 291 11,039,000 225 8,506,000 45,000 to 49,999 34 1,453,000 12 506,000 11 480,000 8 346,000 7 300,000 17 728,000 34 1,467,000 30 1,270,000 121 5,195,000 154 6,620,000 243 10,421,000 157 6,732,000 50,000 to 59,999 32 1,529,000 8 384,000 11 531,000 7 338,000 3 145,000 16 770,000 21 1,009,000 24 1,134,000 67 3,197,000 103 4,926,000 189 9,044,000 124 5,925,000 60,000 to 69,999 33 1,810,000 28 1,542,000 14 776,000 9 504,000 8 431,000 15 813,000 28 1,542,000 21 1,164,000 79 4,336,000 116 6,351,000 286 15,826,000 115 6,300,000 70,000 +97 21,742,000 76 13,942,000 65 10,433,000 57 8,415,000 47 7,131,000 75 13,903,000 68 13,532,000 82 16,271,000 142 25,716,000 223 34,045,000 482 60,311,000 211 35,091,000 TOTAL 3,343 68,737,000 3,369 48,476,000 3,376 41,069,000 3,380 34,988,000 3,397 27,439,000 3,413 53,301,000 3,446 61,462,000 3,458 60,751,000 3,494 94,970,000 3,514 108,667,000 3,549 147,077,000 3,552 112,482,000 WATER USE PER METER 20,561 14,389 12,165 10,351 8,077 15,617 17,836 17,568 27,181 30,924 41,442 31,667 PER MONTH (GALLONS) MONTHLY RETAIL CUSTOMER AND WATER USE BY CATEGORY 2010 2010 2010 2011 2011 2011 2011 2011 2011 2011 2011 2011 SeptemberWATER USE October November December January CATEGORY February March July August 31 Year: FY 2009 April May June Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,999 5.1%0.1%5.95%0.15%7.3%0.3%6.7%0.2%7.50%0.30%7.4%0.2%5.7%0.1%7.7%0.3%6.7%0.1%5.3%0.0%5.2%0.1%5.7%0.1% 2,000 to 2,999 2.1%0.2%3.01%0.36%5.4%0.9%4.1%0.7%5.61%1.02%4.5%0.7%3.9%0.5%5.1%0.9%3.1%0.4%1.1%0.1%2.0%0.2%2.0%0.2% 3,000 to 3,999 3.1%0.5%4.13%0.76%8.2%2.1%5.4%1.4%8.27%2.25%5.2%1.2%4.4%0.9%7.6%2.0%3.7%0.6%1.1%0.1%1.9%0.2%2.5%0.3% 4,000 to 4,999 3.9%0.8%6.36%1.54%10.6%3.6%8.5%2.9%11.02%4.00%7.4%2.3%6.2%1.7%9.5%3.3%4.0%0.9%1.0%0.1%2.0%0.3%3.1%0.5% 5,000 to 5,999 3.9%1.0%6.02%1.84%9.8%4.2%8.7%3.7%10.83%4.92%8.0%3.1%7.7%2.6%8.6%3.7%4.6%1.3%1.4%0.2%2.9%0.6%2.7%0.6% 6,000 to 6,999 4.5%1.3%6.30%2.29%10.0%5.1%10.2%5.2%10.08%5.49%7.8%3.6%7.1%2.9%8.7%4.5%5.3%1.8%1.6%0.3%2.8%0.6%3.6%0.9% 7,000 to 7,999 4.1%1.4%6.02%2.57%7.4%4.4%8.3%4.9%8.03%5.11%7.4%4.0%6.2%2.9%7.2%4.4%5.8%2.3%1.5%0.3%2.4%0.7%4.0%1.2% 8,000 to 8,999 4.8%1.9%6.15%2.99%6.0%4.1%8.6%5.8%6.73%4.88%6.4%4.0%6.1%3.3%6.6%4.5%4.6%2.1%1.3%0.3%2.6%0.8%3.6%1.2% 9,000 to 9,999 4.0%1.8%5.15%2.82%6.3%4.9%5.6%4.3%5.98%4.89%5.7%4.0%5.6%3.4%5.5%4.3%4.9%2.5%1.5%0.4%2.4%0.8%3.8%1.4% 10,000 to 14,999 4.2%2.1%4.46%2.71%3.9%3.3%5.1%4.3%4.10%3.73%4.5%3.5%5.3%3.5%4.6%3.9%4.5%2.5%1.5%0.4%3.2%1.3%4.1%1.7% 15,000 to 19,999 20.8%13.2%19.01%14.79%11.6%12.6%15.0%15.9%11.23%12.89%17.9%17.8%17.7%15.1%14.8%16.2%18.2%13.2%8.0%3.0%15.1%7.6%16.2%8.8% 20,000 to 24,999 14.2%12.7%10.83%11.76%5.5%8.4%5.7%8.5%4.87%7.80%8.5%11.8%9.7%11.6%5.7%8.7%13.5%13.7%11.1%5.8%14.8%10.4%14.8%11.2% 25,000 to 29,999 9.5%10.8%6.53%9.02%2.5%4.8%2.7%5.1%1.51%3.11%4.2%7.4%5.6%8.5%3.1%6.1%7.7%9.9%10.7%7.2%13.1%11.6%10.4%9.9% 30,000 to 34,999 5.1%7.0%3.45%5.82%1.4%3.3%1.5%3.5%0.88%2.19%1.4%3.1%3.0%5.6%1.6%3.7%4.6%7.1%12.2%9.9%9.4%10.2%8.0%9.3% 35,000 to 39,999 3.3%5.4%1.62%3.21%0.7%2.1%0.7%1.9%0.54%1.60%0.8%2.0%1.5%3.4%0.7%1.9%2.6%4.9%10.3%9.9%5.7%7.2%4.5%6.2% 40,000 to 44,999 1.6%3.0%0.88%2.02%0.5%1.6%0.8%2.6%0.16%0.60%0.5%1.5%0.9%2.3%0.4%1.4%1.6%3.4%7.3%8.0%4.6%6.7%3.3%5.2% 45,000 to 49,999 0.8%1.8%0.71%1.83%0.1%0.4%0.2%0.6%0.24%0.93%0.2%0.8%0.4%1.1%0.3%1.0%1.2%2.8%5.5%6.9%2.4%4.1%1.8%3.2% 50,000 to 59,999 0.4%1.1%0.44%1.27%0.3%1.2%0.1%0.5%0.27%1.17%0.3%1.0%0.3%1.1%0.2%0.8%0.4%1.2%4.3%6.0%1.7%3.2%0.9%1.9% 60,000 to 69,999 1.0%2.8%0.27%0.92%0.4%1.8%0.4%1.9%0.20%1.04%0.2%1.1%0.4%1.5%0.3%1.3%0.7%2.3%5.3%8.5%1.6%3.5%1.3%3.0% 70,000 +3.4%31.4%2.71%31.33%2.1%31.0%1.7%26.1%1.95%32.08%1.9%26.9%2.2%28.2%1.9%27.3%2.6%27.0%8.1%32.6%4.1%30.0%3.7%33.3% 100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0% WATER USE % BY MONTH PERCENTAGE USE BY CATEGORY 2008 2008 2008 2009 2009 2009 2009 2009 TOTAL 2009 2009 2009 2009 WATER USE October November December January February March July August September CATEGORY 32 Year: FY 2010 April May June Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,999 8.3%0.3%8.39%0.35%9.1%0.4%8.7%0.4%10.40%0.61%12.5%0.9%8.1%0.2%6.0%0.1%4.6%0.0%4.6%0.1%3.5%0.0%4.6%0.1% 2,000 to 2,999 4.8%0.8%6.62%1.23%7.3%1.6%4.7%1.0%7.49%2.05%10.4%3.1%4.0%0.6%4.0%0.5%1.5%0.1%1.6%0.1%1.8%0.1%2.2%0.2% 3,000 to 3,999 8.0%2.0%9.95%2.79%11.1%3.7%8.9%2.9%12.95%5.32%15.6%7.0%4.9%1.2%5.1%0.9%1.6%0.2%2.2%0.3%1.4%0.1%2.8%0.4% 4,000 to 4,999 8.5%2.8%12.96%4.84%14.0%6.3%10.9%4.7%13.91%7.63%15.3%9.2%6.5%2.0%5.8%1.4%1.7%0.2%2.1%0.3%1.4%0.2%3.2%0.5% 5,000 to 5,999 9.3%3.9%10.77%5.03%11.5%6.4%10.9%5.9%13.01%8.91%13.1%9.8%7.4%2.9%5.6%1.7%2.1%0.4%2.4%0.5%1.3%0.2%3.1%0.7% 6,000 to 6,999 8.3%4.2%8.67%4.86%10.5%7.0%10.7%6.9%10.21%8.40%8.7%7.8%8.1%3.8%6.4%2.3%1.3%0.3%2.8%0.7%1.6%0.3%3.5%0.9% 7,000 to 7,999 7.8%4.6%8.46%5.53%8.0%6.2%9.4%7.1%8.43%8.09%6.8%7.1%7.6%4.2%5.3%2.2%1.9%0.5%2.8%0.8%1.4%0.3%3.4%1.0% 8,000 to 8,999 6.6%4.4%6.02%4.49%5.8%5.2%7.8%6.8%5.71%6.25%4.2%5.1%7.1%4.4%4.7%2.3%2.3%0.6%2.8%0.9%1.8%0.4%3.5%1.2% 9,000 to 9,999 4.8%3.6%4.28%3.60%4.8%4.9%5.3%5.2%4.01%4.95%3.3%4.4%5.8%4.1%4.6%2.5%1.6%0.5%3.9%1.5%1.3%0.3%3.3%1.2% 10,000 to 14,999 4.7%3.9%3.48%3.25%2.7%3.0%4.9%5.3%3.35%4.60%1.9%2.9%5.4%4.2%4.7%2.9%2.5%0.9%3.6%1.5%1.2%0.3%3.1%1.3% 15,000 to 19,999 13.8%14.7%10.01%11.81%8.0%11.3%10.0%13.4%5.74%9.69%3.9%7.2%17.4%17.3%17.8%13.9%12.4%5.6%17.6%9.3%7.7%2.8%17.5%9.4% 20,000 to 24,999 6.5%9.5%3.90%6.44%2.5%4.8%3.2%6.0%1.66%4.03%1.4%3.8%8.7%12.2%11.8%12.8%13.0%8.0%15.8%11.6%9.9%5.0%14.6%10.8% 25,000 to 29,999 2.7%5.2%1.96%4.13%1.1%2.8%1.0%2.6%0.72%2.25%0.6%2.1%3.5%6.2%7.5%10.4%12.3%9.7%12.2%11.4%12.2%7.9%11.3%10.7% 30,000 to 34,999 1.6%3.7%0.82%2.07%0.7%2.3%0.7%2.0%0.25%0.97%0.3%1.2%1.6%3.4%4.0%6.7%11.5%11.2%7.6%8.7%11.2%8.7%7.8%9.0% 35,000 to 39,999 0.7%1.8%0.70%2.15%0.6%2.3%0.7%2.5%0.34%1.54%0.4%2.1%0.8%2.0%1.9%3.7%8.8%10.0%6.2%8.3%9.8%9.1%5.2%7.1% 40,000 to 44,999 0.5%1.7%0.41%1.43%0.2%1.1%0.3%1.4%0.25%1.26%0.1%0.7%0.7%2.0%0.9%2.1%6.4%8.3%3.3%5.2%7.7%8.2%2.8%4.5% 45,000 to 49,999 0.3%1.0%0.29%1.16%0.3%1.4%0.2%0.7%0.16%0.91%0.1%0.4%0.5%1.7%0.7%1.8%4.3%6.4%2.1%3.6%5.9%7.1%1.9%3.3% 50,000 to 59,999 0.2%0.9%0.25%1.15%0.2%0.8%0.1%0.7%0.09%0.61%0.1%0.4%0.1%0.5%0.6%1.6%2.5%4.2%1.4%2.8%4.2%5.6%1.1%2.2% 60,000 to 69,999 0.4%1.9%0.25%1.29%0.3%2.0%0.3%1.9%0.35%2.56%0.3%2.3%0.4%1.7%0.5%1.7%3.0%5.6%1.2%2.6%6.0%9.1%1.8%4.0% 70,000 +2.1%29.3%1.81%32.40%1.4%26.7%1.3%22.8%0.97%19.37%1.0%22.5%1.6%25.4%2.3%28.2%4.9%27.5%4.0%29.8%8.8%34.3%3.5%31.7% 100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0% WATER USE % BY MONTH PERCENTAGE USE BY CATEGORY 2009 2009 2009 2010 2010 2010 2010 2010 TOTAL 2010 2010 2010 2010 WATER USE October November December January February March July August September CATEGORY 33 Year: FY 2011 April May June Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,999 5.6%0.1%6.20%0.16%7.4%0.3%7.9%0.3%12.45%0.82%5.4%0.1%6.0%0.1%5.7%0.1%4.8%0.1%5.0%0.1%4.4%0.0%4.2%0.0% 2,000 to 2,999 3.2%0.3%4.81%0.67%4.7%0.8%4.7%0.9%8.22%2.04%3.1%0.4%2.7%0.3%3.0%0.3%1.7%0.1%1.7%0.1%1.2%0.1%1.6%0.1% 3,000 to 3,999 3.6%0.5%6.98%1.45%6.7%1.7%6.6%1.9%10.74%3.99%4.1%0.8%3.4%0.6%3.9%0.7%1.4%0.2%1.3%0.1%0.9%0.1%1.3%0.1% 4,000 to 4,999 5.4%1.1%7.39%2.06%9.2%3.0%9.7%3.7%12.98%6.43%5.8%1.5%4.2%1.0%5.2%1.2%2.0%0.3%1.3%0.2%0.9%0.1%1.5%0.2% 5,000 to 5,999 4.4%1.1%7.33%2.55%9.1%3.8%10.1%4.9%12.10%7.49%6.3%2.0%3.6%1.0%5.3%1.5%1.4%0.3%1.6%0.3%1.0%0.1%1.2%0.2% 6,000 to 6,999 3.7%1.1%7.03%2.93%7.9%3.9%10.4%6.0%10.27%7.63%6.1%2.3%4.1%1.4%5.1%1.8%2.0%0.4%1.5%0.3%0.9%0.1%1.6%0.3% 7,000 to 7,999 4.6%1.6%6.74%3.28%6.9%4.0%8.3%5.6%6.66%5.76%5.7%2.6%3.7%1.4%5.1%2.0%2.1%0.5%1.3%0.3%1.1%0.2%1.5%0.3% 8,000 to 8,999 3.6%1.4%5.32%2.95%6.0%3.9%7.6%5.9%5.97%5.92%5.5%2.8%4.6%2.1%4.6%2.1%2.3%0.7%1.9%0.5%0.9%0.2%1.6%0.4% 9,000 to 9,999 4.4%1.9%4.48%2.80%5.5%4.1%6.4%5.5%4.10%4.56%5.7%3.3%4.8%2.4%4.7%2.4%2.2%0.7%1.7%0.5%1.2%0.3%1.6%0.5% 10,000 to 14,999 3.3%1.6%4.21%2.93%5.1%4.2%4.6%4.5%3.29%4.08%5.1%3.3%3.9%2.2%4.5%2.5%2.1%0.8%1.5%0.5%1.0%0.3%1.9%0.6% 15,000 to 19,999 18.0%11.4%17.28%15.40%14.8%15.5%12.9%15.5%7.16%11.00%19.6%16.2%19.4%14.0%18.1%13.3%13.5%6.5%11.2%4.8%5.8%1.8%10.1%4.2% 20,000 to 24,999 13.8%12.0%9.20%11.51%7.1%10.3%4.4%7.5%2.50%5.37%11.5%13.1%16.0%15.9%13.3%13.4%15.8%10.5%14.1%8.2%7.8%3.4%13.9%7.9% 25,000 to 29,999 9.5%10.5%4.69%7.45%3.4%6.4%2.2%4.7%0.68%1.93%6.5%9.4%9.3%11.8%8.0%10.5%13.7%11.5%12.6%9.4%9.9%5.5%14.9%10.8% 30,000 to 34,999 5.8%7.9%2.05%3.91%2.1%4.7%1.1%3.0%0.52%1.83%3.6%6.3%5.4%8.5%4.6%7.2%10.9%11.2%11.2%10.1%11.1%7.5%11.0%9.6% 35,000 to 39,999 3.6%5.7%1.87%4.25%0.9%2.3%0.6%1.8%0.21%0.84%1.6%3.3%3.2%5.9%3.1%5.8%7.2%8.7%8.4%8.9%10.0%7.9%8.7%9.1% 40,000 to 44,999 1.8%3.3%0.74%1.92%0.5%1.7%0.2%0.9%0.24%1.13%1.0%2.4%1.4%2.9%1.2%2.5%5.1%7.0%6.6%8.0%8.2%7.5%6.3%7.6% 45,000 to 49,999 1.0%2.1%0.36%1.05%0.3%1.2%0.2%1.0%0.20%1.09%0.5%1.4%1.0%2.4%0.9%2.1%3.5%5.5%4.4%6.1%6.8%7.1%4.4%6.0% 50,000 to 59,999 1.0%2.2%0.23%0.79%0.3%1.3%0.2%1.0%0.09%0.53%0.5%1.4%0.6%1.6%0.7%1.9%1.9%3.4%2.9%4.5%5.3%6.2%3.5%5.3% 60,000 to 69,999 1.0%2.6%0.83%3.18%0.4%1.9%0.3%1.4%0.24%1.57%0.4%1.5%0.8%2.5%0.6%1.9%2.3%4.6%3.3%5.8%8.1%10.8%3.2%5.6% 70,000 +2.9%31.6%2.26%28.76%1.9%25.4%1.7%24.1%1.38%25.99%2.2%26.1%2.0%22.0%2.4%26.8%4.1%27.1%6.4%31.3%13.6%41.0%5.9%31.2% 100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0% WATER USE % BY MONTH PERCENTAGE USE BY CATEGORY 2010 2010 2010 2011 2011 2011 2011 2011 TOTAL 2011 2011 2011 2011 WATER USE October November December January February March July August September CATEGORY 34