The URL can be used to link to this page

Home My WebLink AboutFY 2014 TCMUD 1 Approved Budget General Fund Fire Fund Debt Service Fund Revenue 6,318,687 Revenue 27,950 Revenue 218,754 FY 2013 Tax Collections 99,250 FY 2013 Tax Collections 927,555 FY 2013 Tax Collections 389,216 Reserve Funds 0 FY 2013 PID Assessment 305,445 Reserve (PID Fees/Other)16,526 Total Revenue 6,417,937 Reserve Funds 0 Water Expense 3,932,956 Total Revenue 1,260,950 Total Revenue 624,495 Wastewater Expense 768,011 Fire Expense 1,260,950 Debt Service Expense 624,495 Collections Expense 472,170 Board of Directors Expense 22,661 Administration Expense 1,055,198 Non-Departmental Expense 166,940 Total Expense 6,417,937 Total Expense 1,260,950 Total Expense 624,495 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 0 2014 Property Value Summary Tax Rate Summary MUD Tarrant Co.294,553,622 2013 2014 MUD Denton Co.766,998,140 General Fund Tax 0.00989 0.00935 PID 349,570,865 I & S (Debt Service) Tax 0.01950 0.03666 Total Value:1,411,122,627 Fire Tax 0.10400 0.08738 Total Tax Rate:0.13339 0.13339 Increase:0.00000 PID Fire Assessment Rate 0.10400 0.08738 Reduction:-0.01662 Budget Summary TROPHY CLUB M.U.D. NO. 1 FY 2014 BUDGET APPROVED SEPTEMBER 17, 2013 1 Trophy Club MUD No.1 FY 2014 Budget September 17, 2013 GENERAL FUND Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2014 thru 6/30/13 Comments General Fund Revenues 135-40000-000-000 Property Taxes 99,884 99,884 99,250 100,089 Reduced due to reduction in Tarrant County Values 135-40002-000-000 Property Taxes/Delinquent 500 624 0 -317 Large refund to customer caused deficit balance (YTD). 135-40015-000-000 Property Taxes/P & I 1,200 1,200 900 806 135-43215-000-000 Insurance Settlement 0 0 0 0 135-47000-000-000 Water 3,545,609 3,545,609 3,749,310 2,097,484 See Schedule GF-D 135-47005-000-000 Sewer 1,653,747 1,653,747 1,708,321 1,282,332 See Schedule GF-E 135-47025-000-000 Penalties 64,580 64,580 64,522 41,514 See Schedule GF-D 135-47030-000-000 Service Charges (Disconnect Fees)11,625 11,625 9,075 9,233 See Schedule GF-D 135-47035-000-000 Plumbing Inspections 1,800 1,800 1,200 950 135-47045-000-000 Sewer Inspections 5,200 5,200 4,400 3,300 135-47070-000-000 TCCC Effluent Charges 77,575 77,575 79,586 31,892 See Schedule GF-E 135-48005-000-000 Utility Fees 644,000 644,000 582,109 397,900 See Schedule GF-D 135-49010-000-000 Interest Income 5,500 5,500 4,800 3,613 135-49016-000-000 Cell Tower Revenue 10,164 10,164 10,164 8,131 $847 per month 135-49018-000-000 Building Rent Income 7,000 7,000 7,000 5,250 $583.33 per month: Collection Barn Rent from Town 135-49030-000-000 Vending Revenue 350 350 350 317 WWTP and Collection Barn 135-49035-000-000 Prior Year Reserves 305,748 234,014 0 0 135-49036-000-000 GASB Reserves 0 0 8,964 0 135-49075-000-000 Oversize Meter Reimbursement 73,000 73,000 84,000 63,195 FY 2013 Annualized 135-49900-000-000 Miscellaneous Income 1,000 13,213 3,000 14,973 Will auction 2 vehicles this year 135-49901-000-000 Records Management Revenue 0 109 100 91 135-49905-000-000 Gas Well Revenue 200 286 885 663 FY 2013 Annualized Total 6,508,683 6,449,481 6,417,937 4,061,417 General Fund Expenses Water 135-50005-010-000 Salaries & Wages 213,321 213,321 287,709 120,323 SEE SCHEDULE GF-H; Moved Utility Superintendent to Water from Collections 135-50010-010-000 Overtime 13,250 19,250 13,391 10,043 SEE SCHEDULE GF-H 135-50016-010-000 Longevity 3,080 3,080 4,905 3,080 SEE SCHEDULE GF-H 135-50017-010-000 Certification 5,100 5,100 5,100 3,350 SEE SCHEDULE GF-H 135-50020-010-000 Retirement 32,725 57,748 27,847 40,473 SEE SCHEDULE GF-J 135-50026-010-000 Medical Insurance 28,920 28,920 48,334 17,471 SEE SCHEDULE GF-I 135-50027-010-000 Dental Insurance 2,091 2,091 3,932 1,256 SEE SCHEDULE GF-I 135-50028-010-000 Vision Insurance 519 519 873 294 SEE SCHEDULE GF-I 135-50029-010-000 Life Insurance & Other 1,204 1,532 3,306 1,036 SEE SCHEDULE GF-I 135-50030-010-000 Social Security Taxes 14,555 14,555 19,289 8,563 SEE SCHEDULE GF-H 135-50035-010-000 Medicare Taxes 3,404 3,404 4,511 2,003 SEE SCHEDULE GF-H 135-50040-010-000 Unemployment Taxes 945 945 54 46 SEE SCHEDULE GF-H 135-50045-010-000 Workman's Compensation 6,109 6,109 9,829 3,761 SEE SCHEDULE GF-H 135-50060-010-000 Pre-emp Physicals/Testing 200 200 200 167 135-50070-010-000 Employee Relations 350 350 300 112 135-55005-010-000 Engineering 3,000 2,000 3,000 0 135-55080-010-000 Maintenance & Repairs 50,000 50,000 50,000 25,312 135-55090-010-000 Vehicle Maintenance 3,700 4,650 5,000 3,681 2 Trophy Club MUD No.1 FY 2014 Budget September 17, 2013 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2014 thru 6/30/13 Comments 135-55105-010-000 Maintenance-Heavy Equipment 2,900 2,900 3,500 1,767 135-55135-010-000 Lab Analysis 4,500 5,384 5,500 4,300 TCEQ Estimate + monthly BacT & Reduced for PID Portion 135-55135-010-001 Lab Analysis for the PID 0 0 1,000 0 PID Portion 135-60010-010-000 Communications/Pagers/Mobiles 2,000 2,000 4,913 1,194 Moved Utility Superintendent position to Water from Collections; includes one on-call phone 135-60020-010-000 Electricity 162,410 162,410 162,160 80,769 SEE SCHEDULE GF-K 135-60066-010-000 Publications/Books/Subscripts 500 500 500 0 Need AAWA Standards Set 135-60070-010-000 Dues & Memberships 150 150 150 150 135-60080-010-000 Schools & Training 1,672 1,472 4,184 351 SEE SCHEDULE GF-G 135-60090-010-000 Safety Program 500 400 400 0 135-60100-010-000 Travel & per diem 700 800 1,450 552 SEE SCHEDULE GF-G 135-60105-010-000 Rent/Lease Equipment 500 500 500 24 135-60135-010-000 TCEQ Fees & Permits 35,800 42,743 47,400 43,294 Reg. Assessment ($18,800), Water System Fees ($8600) & NTGW Well Fees ($20,000) 135-60150-010-000 Wholesale Water 2,028,449 2,028,449 2,338,473 830,521 SEE SCHEDULE GF-C 135-60245-010-000 Miscellaneous Expenses 500 200 200 0 135-60280-010-000 Property Maintenance 4,200 4,200 3,500 932 Customer Property Repairs 135-60285-010-000 Lawn Equipment & Maintenance 250 250 250 0 135-60360-010-000 Furniture/Equipment < $5000 1,500 500 3,500 39 Includes $3000 for shelving for Water Building 135-65005-010-000 Fuel & Lube 17,661 17,661 23,181 8,603 SEE SCHEDULE GF-M 135-65010-010-000 Uniforms 2,680 2,680 3,270 1,618 SEE SCHEDULE GF-F 135-65030-010-000 Chemicals 6,200 6,200 5,000 3,484 135-65035-010-000 Small Tools 1,500 1,500 1,200 267 135-65040-010-000 Safety Equipment 2,000 1,000 1,000 257 135-65050-010-000 Meter Expense 143,550 143,550 143,550 148,263 Complete meter changeouts and new meters 135-69005-010-000 Capital Expenses 181,800 8,000 37,000 -1,095 SEE SCHEDULE GF-A 135-69008-010-000 Short Term Debt-Principal 387,037 366,000 489,980 0 SEE SCHEDULE GF-B 135-69009-010-000 Short Term Debt-Interest 21,037 19,268 10,377 SEE SCHEDULE GF-B 135-69195-010-000 Gasb34/Reserve for Replacement 30,000 30,000 30,000 30,000 135-69280-010-000 Capital Repairs 270,000 60,000 7,500 59,869 SEE SCHEDULE GF-A 135-69281-010-000 Capital Repair-Tank Inspection Contract 150,000 100,900 106,848 100,817 Annual contract: GST's increased amount due to increased size; no contract on Town EST Subtotal Water 3,821,431 3,425,159 3,932,956 1,567,323 Wastewater 135-50005-020-000 Salaries & Wages 196,781 196,781 202,894 129,096 SEE SCHEDULE GF-H 135-50010-020-000 Overtime 10,166 17,546 11,965 8,974 SEE SCHEDULE GF-H 135-50016-020-000 Longevity 2,858 2,858 2,998 2,858 SEE SCHEDULE GF-H 135-50017-020-000 Certification 4,200 4,200 4,800 3,050 SEE SCHEDULE GF-H 135-50020-020-000 Retirement 29,821 54,844 19,905 41,234 SEE SCHEDULE GF-J 135-50026-020-000 Medical Insurance 29,034 29,034 43,471 25,420 SEE SCHEDULE GF-I 135-50027-020-000 Dental Insurance 2,112 2,112 2,989 1,808 SEE SCHEDULE GF-I 135-50028-020-000 Vision Insurance 552 552 658 438 SEE SCHEDULE GF-I 135-50029-020-000 Life Insurance & Other 920 1,377 2,303 1,088 SEE SCHEDULE GF-I 135-50030-020-000 Social Security Taxes 13,268 13,268 13,805 7,897 SEE SCHEDULE GF-H 135-50035-020-000 Medicare Taxes 3,103 3,103 3,229 1,847 SEE SCHEDULE GF-H 135-50040-020-000 Unemployment Taxes 756 756 36 45 SEE SCHEDULE GF-H 135-50045-020-000 Workman's Compensation 2,939 2,939 6,552 5,960 SEE SCHEDULE GF-H 135-50060-020-000 Pre-emp Physicals/Testing 150 150 150 189 135-50070-020-000 Employee Relations 350 350 350 91 3 Trophy Club MUD No.1 FY 2014 Budget September 17, 2013 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2014 thru 6/30/13 Comments 135-55070-020-000 Independent Labor 1,000 84,418 0 77,500 FY 13 engineering fees paid here (plant upgrades) 135-55080-020-000 Maintenance & Repairs 40,000 41,205 35,000 42,089 135-55090-020-000 Vehicle Maintenance 2,000 3,350 2,000 4,518 135-55105-020-000 Maintenance-Heavy Equipment 1,500 1,500 500 1,081 135-55125-020-000 Dumpster Services 15,000 49,611 52,000 34,816 Dumpster Service increased costs 135-55135-020-000 Lab Analysis 30,000 30,000 30,000 22,584 135-60010-020-000 Communications/Pagers/Mobiles 2,700 3,981 3,329 1,642 Includes one on-call phone 135-60020-020-000 Electricity 153,045 153,045 148,229 94,721 SEE SCHEDULE GF-K 135-60066-020-000 Publications/Books/Subscripts 500 200 400 161 135-60080-020-000 Schools & Training 3,272 3,272 2,636 1,072 SEE SCHEDULE GF-G 135-60090-020-000 Safety Program 250 0 250 71 135-60100-020-000 Travel & per diem 1,400 1,400 1,050 3,257 SEE SCHEDULE GF-G 135-60105-020-000 Rent/Lease Equipment 1,500 1,500 1,500 1,123 135-60125-020-000 Advertising 2,000 300 0 113 135-60135-020-000 TCEQ Fees & Permits 56,000 15,600 17,150 7,887 Reg. Assessment ($8,550), Annual Fee ($8,600) 135-60245-020-000 Miscellaneous Expenses 200 200 200 202 135-60285-020-000 Lawn Equipment & Maintenance 500 500 500 412 135-60360-020-000 Furniture/Equipment < $5000 0 0 3,000 0 Ice Maker 135-65005-020-000 Fuel & Lube 8,527 10,527 14,720 8,097 SEE SCHEDULE GF-M 135-65010-020-000 Uniforms 2,574 1,574 1,752 1,324 SEE SCHEDULE GF-F 135-65030-020-000 Chemicals 10,000 38,346 39,000 22,791 135-65035-020-000 Small Tools 1,000 1,000 1,000 469 135-65040-020-000 Safety Equipment 250 500 250 552 135-65045-020-000 Lab Supplies 10,000 10,000 15,000 13,025 135-69005-020-000 Capital Expenses 241,200 446,484 31,000 442,195 SEE SCHEDULE GF-A 135-69008-020-000 Short Term Debt-Principal 0 0 20,020 0 SEE SCHEDULE GF-B 135-69009-020-000 Short Term Debt-Interest 0 0 1,422 0 SEE SCHEDULE GF-B 135-69280-020-000 Capital Repairs 158,000 0 30,000 0 SEE SCHEDULE GF-A Subtotal Wastewater 1,039,428 1,228,383 768,011 1,011,698 *MAJOR DIFFERENCE FROM FY 13 TO FY 14 IS NO CAPITAL PROJECTS Collection 135-50005-021-000 Salaries & Wages 156,475 156,475 90,299 106,687 SEE SCHEDULE GF-H; Moved Utility Superintendent to Water from Collections 135-50010-021-000 Overtime 7,297 12,158 10,028 7,521 SEE SCHEDULE GF-H 135-50016-021-000 Longevity 3,818 3,818 17,913 3,818 SEE SCHEDULE GF-H 135-50017-021-000 Certification 1,800 1,800 1,800 1,300 SEE SCHEDULE GF-H 135-50020-021-000 Retirement 23,574 42,910 9,025 32,726 SEE SCHEDULE GF-J 135-50026-021-000 Medical Insurance 20,198 25,940 23,668 18,979 SEE SCHEDULE GF-I 135-50027-021-000 Dental Insurance 1,409 1,812 1,703 1,333 SEE SCHEDULE GF-I 135-50028-021-000 Vision Insurance 357 383 314 285 SEE SCHEDULE GF-I 135-50029-021-000 Life Insurance & Other 1,008 1,223 1,066 805 SEE SCHEDULE GF-I 135-50030-021-000 Social Security Taxes 10,502 10,502 7,442 7,037 SEE SCHEDULE GF-H 135-50035-021-000 Medicare Taxes 2,456 2,456 1,741 1,646 SEE SCHEDULE GF-H 135-50040-021-000 Unemployment Taxes 567 567 198 34 SEE SCHEDULE GF-H 135-50045-021-000 Workman's Compensation 3,348 3,348 3,276 4,897 SEE SCHEDULE GF-H 135-50070-021-000 Employee Relations 250 250 200 108 135-55005-021-000 Engineering 1,500 0 1,500 0 135-55080-021-000 Maintenance & Repairs 35,000 20,000 23,801 17,463 4 Trophy Club MUD No.1 FY 2014 Budget September 17, 2013 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2014 thru 6/30/13 Comments 135-55090-021-000 Vehicle Maintenance 1,900 1,600 2,000 1,406 135-60010-021-000 Communications/Pagers/Mobiles 3,500 3,500 1,333 1,797 Some costs moved to Water 135-60020-021-000 Electricity 18,705 18,705 21,178 13,481 SEE SCHEDULE GK-K 135-60070-021-000 Dues & Memberships 250 250 250 250 135-60080-021-000 Schools & Training 826 826 1,711 830 SEE SCHEDULE GF-G 135-60090-021-000 Safety Program 500 300 300 0 135-60100-021-000 Travel & per diem 450 450 550 2,093 SEE SCHEDULE GF-G 135-60105-021-000 Rent/Lease Equipment 10,000 10,000 10,000 0 Funds allocated for rental equipment in disaster or emergency repair. 135-60245-021-000 Miscellaneous Expenses 100 100 100 0 135-65005-021-000 Fuel & Lube 12,117 12,117 22,397 6,511 SEE SCHEDULE GF-M 135-65010-021-000 Uniforms 2,220 2,220 1,040 934 135-65030-021-000 Chemicals 7,500 7,500 6,000 2,221 135-65035-021-000 Small Tools 1,500 1,250 1,000 70 135-65040-021-000 Safety Equipment 500 500 500 120 135-69005-021-000 Capital Expenses 90,000 90,000 100,000 15,276 See Schedule GF-A 135-69008-021-000 Short Term Debt-Principal 40,260 40,260 35,991 0 See Schedule GF-B 135-69009-021-000 Short Term Debt-Interest 0 0 2,846 0 See Schedule GF-B 135-69280-021-000 Capital Repairs 0 0 71,000 0 See Schedule GF-A Subtotal Collection 459,887 473,220 472,170 249,625 Board of Directors 135-50005-026-000 Salaries & Wages 10,000 10,000 10,000 7,500 135-50030-026-000 Social Security Taxes 620 620 620 465 135-50035-026-000 Medicare Taxes 145 145 145 109 135-50040-026-000 Unemployment Taxes 210 210 10 66 135-50045-026-000 Workman's Compensation 150 150 36 8 135-60066-026-000 Publications/Books/Subscripts 150 150 150 0 135-60070-026-000 Dues & Memberships 2,100 2,100 500 42 135-60075-026-000 Meetings 1,200 1,200 1,200 435 135-60080-026-000 Schools & Training 4,000 4,000 4,000 2,655 135-60100-026-000 Travel & per diem 5,000 5,000 5,000 5,326 135-60245-026-000 Miscellaneous Expenses 3,000 3,000 1,000 268 Subtotal Board of Directors 26,575 26,575 22,661 16,873 Administration 135-50005-030-000 Salaries & Wages 444,730 444,730 458,721 307,088 SEE SCHEDULE GF-H 135-50010-030-000 Overtime 1,500 1,500 500 240 SEE SCHEDULE GF-H 135-50016-030-000 Longevity 2,193 2,318 3,018 2,318 SEE SCHEDULE GF-H 135-50020-030-000 Retirement 60,441 104,801 41,419 78,319 SEE SCHEDULE GF-H 135-50026-030-000 Medical Insurance 44,066 49,049 57,923 35,885 SEE SCHEDULE GF-J 135-50027-030-000 Dental Insurance 3,379 3,379 5,100 3,184 SEE SCHEDULE GF-I 135-50028-030-000 Vision Insurance 795 945 1,087 694 SEE SCHEDULE GF-I 135-50029-030-000 Life Insurance & Other 2,500 2,582 4,483 2,069 SEE SCHEDULE GF-I 135-50030-030-000 Social Security Taxes 27,802 27,802 28,659 18,321 SEE SCHEDULE GF-I 135-50035-030-000 Medicare Taxes 6,502 6,502 6,702 4,285 SEE SCHEDULE GF-H 135-50040-030-000 Unemployment Taxes 1,537 1,537 63 439 SEE SCHEDULE GF-H 135-50045-030-000 Workman's Compensation 831 831 1,575 939 SEE SCHEDULE GF-H 135-50060-030-000 Pre-emp Physicals/Testing 250 250 200 39 5 Trophy Club MUD No.1 FY 2014 Budget September 17, 2013 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2014 thru 6/30/13 Comments 135-50070-030-000 Employee Relations 5,000 5,000 5,000 2,740 135-50075-030-000 Tuition Reimbursement 0 0 0 0 135-55030-030-000 Software & Support 63,555 63,555 59,698 51,759 SEE SCHEDULE GF-L 135-55070-030-000 Independent Labor 2,700 7,700 7,700 686 135-55080-030-000 Maintenance & Repairs 811 4,500 811 $3000 added for new light fixtures that are broken and repair of AV room 135-55100-030-000 Building Maint & Supplies 5,000 6,500 6,500 4,239 135-55120-030-000 Cleaning Services 20,200 20,200 19,140 13,876 Town share PWS building and PD building is ($11609) and is a credit in Contractual Services 135-55160-030-000 Professional Outside Services 15,000 15,000 15,000 6,974 SEMO previously budgeted here; $10,000 added for website development 135-55161-030-000 Town Personnel Contract 85,465 85,465 77,048 85,465 SEE SCHEDULE GF-L 135-55165-030-000 Collection Fees 0 160 200 160 135-55205-030-000 Utility Billing Contract 11,000 11,000 6,808 5,106 Cost for printing monthly statements: new contract resulted in lower cost 135-60005-030-000 Telephone 9,000 10,500 11,250 8,437 Includes $6540 for IT and $2,333 After Hours Answering Service 135-60010-030-000 Communications/Mobiles 3,575 3,575 3,589 2,622 Reviewed and adjusted phones 135-60020-030-000 Electricity 13,019 13,019 15,171 9,150 SEE SCHEDULE GF-K 135-60025-030-000 Water 3,100 3,100 1,500 653 Based on FY 13 consumption with a projected allowance for deviation 135-60030-030-000 Rent And/Or Usage 13,182 13,182 0 9,887 No longer will pay $1098 per month paid to Town 135-60035-030-000 Postage 23,000 26,604 28,500 21,163 135-60040-030-000 Bank Service Charges & Fees 18,000 28,330 28,330 20,869 135-60050-030-000 Bad Debt Expense 8,500 8,500 1,500 1,001 Lower cost due to increased quarterly reviews and write offs 135-60055-030-000 Insurance 35,000 50,694 53,561 50,944 During re-rate we increased some coverages and added items not previously insured 135-60066-030-000 Publications/Books/Subscripts 750 834 1,000 834 135-60070-030-000 Dues & Memberships 2,400 3,892 4,500 4,192 135-60075-030-000 Meetings 250 400 400 284 135-60080-030-000 Schools & Training 5,500 5,350 7,500 3,395 SEE SCHEDULE GF-G 135-60100-030-000 Travel & per diem 3,950 3,616 5,000 3,727 SEE SCHEDULE GF-G 135-60110-030-000 Physicals/Testing 500 500 200 0 135-60115-030-000 Elections 0 0 2,500 0 135-60125-030-000 Advertising 4,000 4,000 2,500 1,419 135-60235-030-000 Security 1,350 1,350 1,350 505 $1350 for IT 135-60245-030-000 Miscellaneous Expenses & DM Discretionary 15,000 13,500 22,870 1,035 Since last budget draft this was reduced for cell data plan increase (total of $647). 135-60270-030-000 4th of July Celebration 10,500 10,500 10,500 10,000 135-60281-030-000 Park Expense 0 42,500 0 31,727 135-60336-030-000 Intergov Trans Out (MUD I&S)0 0 0 161,000 135-60344-030-000 Intergov Trans Out (Fire Dept.)0 0 0 0 135-60360-030-000 Furniture/Equipment < $5000 2,500 2,500 2,500 3,538 135-65010-030-000 Uniforms 1,635 1,635 1,390 624 SEE SCHEDULE GF-F 135-65055-030-000 Hardware IT 20,188 20,188 13,562 12,129 SEE SCHEDULE GF-L 135-65085-030-000 Office Supplies 8,200 8,200 9,100 6,896 All departments combined. Includes $371 for IT 135-65090-030-000 Printer Supplies & Maintenance 5,732 5,732 5,732 2,291 SEE SCHEDULE GF-L 135-65095-030-000 Maintenance Supplies 2,000 1,500 2,500 2,216 135-65097-030-000 Vending Machine Supplies 500 500 200 50 Vending at WWTP and Collections Barn 135-65105-030-000 Printing 5,200 4,200 4,000 2,136 135-69005-030-000 Capital Expenses 0 0 0 0 SEE SCHEDULE GF-A 135-69170-030-000 Copier Lease Installments 3,450 3,450 3,450 2,312 SEE SCHEDULE GF-L 135-69195-030-000 Gasb34/Reserve for Replacement IT 26,911 26,911 0 26,911 SEE SCHEDULE GF-L Subtotal Administration 1,051,338 1,180,379 1,055,198 1,027,580 6 Trophy Club MUD No.1 FY 2014 Budget September 17, 2013 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2014 thru 6/30/13 Comments Non Departmental 135-55045-039-000 Legal 70,000 70,000 131,300 156,887 Special projects this year increased costs. Expect decrease next year. 135-55055-039-000 Auditing 21,200 21,200 21,840 20,700 135-55060-039-000 Appraisal 15,100 15,100 10,000 8,152 135-55065-039-000 Tax Admin Fees 3,800 3,800 3,800 2,391 Subtotal Non Departmental 110,100 110,100 166,940 188,130 TO MAINTAIN 2013 TAX RATE $66940 TO BE FUNDED THROUGH REVENUES (NOT O&M TAX) Total General Fund Revenues 6,508,683 6,449,481 6,417,937 Total General Fund Expenses 6,508,759 6,443,816 6,417,937 Net Budget Surplus (Deficit)-76 5,665 0 7 Trophy Club MUD No.1 FY 2014 Budget September 17, 2013 FIRE DEPARTMENT Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2014 thru 6/30/13 Comments Revenues 122-40001-000-000 Assessment - Emerg Svcs 252,084 252,084 305,445 254,600 Reduced due to reduction in Tarrant County Values 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700 700 0 66 122-40010-000-000 Property Taxes/MUD Fire 1,050,349 1,050,349 927,555 1,052,508 Reduced due to reduction in Tarrant County Values 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800 5,800 0 -3,238 Large refund to customer caused deficit balance (YTD). 122-40015-000-000 Property Taxes/Assessments P&I 750 750 750 703 122-40020-000-000 Property Taxes/Fire P&I 4,500 4,500 4,500 4,118 122-42014-000-000 Fire Permits/Sprinkler 6,000 6,000 6,000 4,800 122-43400-000-000 Fire Inspections 500 675 700 975 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000 10,000 10,000 10,000 122-49035-000-000 Prior Year Reserves 0 5,413 0 0 122-49900-000-000 Miscellaneous Income 1,200 5,200 6,000 7,314 Total 1,335,882 1,341,470 1,260,950 1,331,847 Expenses 122-50005-045-000 Salaries & Wages 444,717 444,717 455,916 311,183 SEE SCHEDULE GF-H 122-50010-045-000 Overtime 31,375 37,076 44,225 29,663 SEE SCHEDULE GF-H 122-50011-045-000 Holiday Pay 13,083 12,083 13,529 12,081 SEE SCHEDULE GF-H 122-50016-045-000 Longevity 4,266 4,266 4,768 4,266 SEE SCHEDULE GF-H 122-50017-045-000 Certification 4,896 6,024 4,350 3,957 SEE SCHEDULE GF-J 122-50020-045-000 Retirement 69,242 69,242 70,991 50,997 SEE SCHEDULE GF-I 122-50026-045-000 Medical Insurance 48,327 48,327 56,968 31,130 SEE SCHEDULE GF-I 122-50027-045-000 Dental Insurance 3,635 3,836 4,230 2,881 SEE SCHEDULE GF-I 122-50028-045-000 Vision Insurance 824 824 892 595 SEE SCHEDULE GF-I 122-50029-045-000 Life Insurance & Other 4,250 5,974 4,250 4,504 SEE SCHEDULE GF-I TOWN OVERBILLED AND WILL OWE A REFUND FOR FY 13 122-50030-045-000 Social Security Taxes 30,897 30,897 32,980 21,418 SEE SCHEDULE GF-H 122-50035-045-000 Medicare Taxes 7,226 7,226 7,713 5,009 SEE SCHEDULE GF-H 122-50040-045-000 Unemployment Taxes 1,481 1,980 2,259 134 SEE SCHEDULE GF-H 122-50045-045-000 Workman's Compensation 10,000 10,000 8,708 10,275 122-50060-045-000 Pre-employment Physicals/Test 675 675 500 283 122-50075-045-000 Tuition Reimbursement 1,500 1,500 600 0 Per Town: MUD FY 2014 share 122-55030-045-000 Software & Support 0 0 8,682 0 (NEW ACCOUNT) SEE SCHEDULE GF-L 122-55045-045-000 Legal 0 5,000 5,000 3,056 122-55080-045-000 Maintenance & Repairs 9,562 9,562 20,472 7,240 Maintenance Accounts Combined 122-55090-045-000 Vehicle Maintenance 14,850 14,600 14,850 5,177 122-55095-045-000 Equipment Maintenance 9,808 9,808 0 6,518 Combined with Acct No. 122-55080-045 122-55100-045-000 Building Maintenance 6,500 5,500 0 2,967 Combined with Acct No. 122-55080-045 122-55110-045-000 Maintenance-Radios 1,103 1,103 0 451 Combined with Acct No. 122-55080-045 122-55160-045-000 Professional Outside Services 2,500 0 0 0 122-60005-045-000 Telephone 106 106 100 50 122-60010-045-000 Communications/Mobiles 2,500 3,500 4,237 3,081 $2837 Cell & $1400 DENTON DISPATCH 122-60020-045-000 Electricity/Gas 6,167 6,167 6,568 5,840 SEE SCHEDULE GF-K: 50% PAID BY TOWN 122-60025-045-000 Water 1,400 1,400 1,500 911 50% PAID BY TOWN 8 Trophy Club MUD No.1 FY 2014 Budget September 17, 2013 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2014 thru 6/30/13 Comments 122-60030-045-000 Rent And/Or Usage 308,000 308,000 214,279 308,000 SEE SCHEDULE FD-B 122-60035-045-000 Postage 100 100 100 41 122-60055-045-000 Insurance 10,000 10,000 12,111 10,000 Calculated on TML re-rate 122-60066-045-000 Publications/Books/Subscrips 410 410 400 0 122-60070-045-000 Dues & Memberships 7,500 8,000 15,180 7,956 SEE SCHEDULE FD-A 122-60075-045-000 Meetings 75 75 0 0 122-60080-045-000 Schools & Training 5,000 5,000 4,280 2,698 SEE SCHEDULE FD-A 122-60096-045-000 Emergency Management 1,000 1,000 2,000 1,000 122-60100-045-000 Travel & per diem 4,800 4,800 4,577 2,789 SEE SCHEDULE FD-A 122-60110-045-000 Physicals/Testing 2,000 2,000 2,000 0 122-60125-045-000 Advertising 150 150 200 122 122-60160-045-000 Programs & Special Projects 4,200 4,200 4,500 2,416 122-60180-045-000 Fire Inspection/Enforcement 1,900 2,150 1,500 2,382 122-60195-045-000 Flags & Repair 2,543 2,293 2,000 1,558 122-60245-045-000 Miscellaneous Expense 1,237 1,237 1,000 585 122-65005-045-000 Fuel & Lube 10,000 10,000 11,698 5,065 SEE SCHEDULE GF-M 122-65010-045-000 Uniforms 4,357 3,357 3,360 1,739 122-65015-045-000 Protective Clothing 7,600 7,600 7,600 6,745 122-65030-045-000 Chemicals 1,000 1,000 1,000 822 122-65035-045-000 Small Tools 5,000 2,400 2,500 1,800 122-65085-045-000 Office Supplies 1,200 1,200 1,000 359 122-65095-045-000 Maintenance Supplies 2,785 1,988 0 1,259 Combined with Acct No. 122-55080-045 122-65105-045-000 Printing 106 0 100 0 122-69008-045-000 Short Term Debt -Principal 72,932 72,932 70,000 0 See Schedule GF-B 122-69009-045-000 Short Term Debt -Interest 0 0 3,031 0 See Schedule GF-B 122-69050-045-000 Radios 2,500 2,500 34,200 353 Radio system upgrade to digital; split with Town; total cost $68,400 122-69195-045-000 GASB34/Reserve for Replacement 145,598 145,598 67,647 41,890 Reduced to cover reduction in values from Tarrant Co. and maintain tax rate 122-69255-045-000 Airpacks 0 0 20,400 Replacement program for NFPA standards; 4 replaced per year on 3 year cycle Total 1,332,882 1,339,382 1,260,950 881,002 Total Fire Revenues 1,335,882 1,341,470 1,260,950 Total Fire Expenses 1,332,882 1,339,382 1,260,950 Net Budget Surplus (Deficit)3,000 2,088 0 9 Trophy Club MUD No.1 FY 2014 Budget September 17, 2013 DEBT SERVICE FUND Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2014 thru 6/30/13 Comments Debt Service Revenues 533-40000-000-000 Property Taxes 196,940 389,216 197,345 533-40002-000-000 Property Taxes/Delinquent 3,900 2,500 2,918 533-40015-000-000 Property Taxes/P & I 5,017 1,600 1,586 533-48005-000-000 Reserve Funds (PID Utility Fees/Other)345,000 16,526 161,000 533-49010-000-000 Interest Income 1,700 375 273 533-49015-000-000 Lease/Rental Income 308,000 214,279 308,000 See Schedule FD-B: New Calculation for Rent 533-49110-000-000 Premium on Bonds Sold 0 0 0 Total 860,557 0 624,495 671,121 Debt Service Expenses 533-70005-051-000 Paying Agent Fee 4,000 2,300 1,000 533-70025-051-000 Bond Interest Expense 229,033 197,195 114,516 See Schedule GF-B (Long Term Debt) 533-70035-051-000 Bond Principal Payment 605,000 425,000 0 See Schedule GF-B (Long Term Debt) Total 838,033 0 624,495 115,516 Total Debt Service Fund Revenues 860,557 0 624,495 Total Debt Service Fund Expenses 838,033 0 624,495 Transfer of Funds to (+) from (-) Cash on Hand 0 0 0 Net Budget Surplus (Deficit)22,525 0 0 10 SCHEDULE FD-A Fire Department Dues, Training, and Travel Account Description 13/14 Budget Detail 122-60070 Dues & Memberships Texas Commission on Fire Protection $1,445.00 $85.00 per FF X 17 Annual fee TCFP Training Facility $170.00 Annual fee SFFMA (Volunteer) $275.00 $100 per dept, $35 per FF (5) NEFDA $12,745.00 Annual fee increase due to equipment replacement Denton County Chiefs $280.00 Annual fee Tarrant County Chiefs $100.00 Annual fee International Fire Chiefs $165.00 Annual fee TOTAL:$15,180.00 122-60080 Schools and Training TCCC Live Fire Training $700.00 TCFP Annual Certification classes TCCC / NFA $680.00 8 classes @ $85.00 TCFP / TEEX / NFA on site classes $500.00 Instructor cost Haz-Mat Certification $700.00 (2) staff cert Conference regestration $1,700.00 SFR / Homeland / FMC / FDIC TOTAL:$4,280.00 122-60100 Travel and Per Diem Southwest Fire / Rescue (Chief Conf)$720.00 Chief or training officer conference. Homeland Security Conference $1,424.00 EMC and Training officer (2) Texas Fire Marshal Conference $712.00 Fire Marshal Fire Department Instructor Conf (FDIC) International Fire Chiefs $1,721.00 Chief or Training Officer TOTAL:$4,577.00 11 SCHEDULE FD-B RENT CALCULATION FOR FIRE STATION FY Bond Payment Reimburse Reserve ($933,700)*Total Rent 2014 146,183 68,096 214,279 2015 143,733 68,096 211,829 2016 146,283 68,096 214,379 2017 148,658 68,096 216,754 2018 150,858 68,096 218,954 2019 147,883 68,096 215,979 2020 149,908 68,096 218,004 2021 151,758 68,096 219,854 2022 153,433 68,096 221,529 2023 153,433 68,096 221,529 2024 153,183 68,096 221,279 2025 152,683 68,096 220,779 2026 148,083 68,096 216,179 2027 153,368 68,096 221,464 2028 153,243 68,096 221,339 2029 152,783 68,096 220,879 2030 152,113 68,096 220,209 2031 151,163 68,096 219,259 *Based on ave. rate of 3.9% for 20 years 12 SCHEDULE GF - A CAPITAL EXPENSES WATER - CAPITAL PURCHASES WATER - CAPITAL REPAIRS ADMINISTRATION - CAPITAL PURCHASES DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT Replacement of Truck- Unit #104 37,000 Water Line Replacement 223 Phoenix 7,500 Total:37,000 Total:7,500 Total:0 WASTEWATER - CAPITAL PURCHASES WASTEWATER - CAPITAL REPAIRS ADMINISTRATION - CAPITAL REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT Skid Loader 25,000 Repair Digester Blowers & Motors 30000 Aerator for Effluent 6,000 Total:0 Total:31,000 Total:30,000 COLLECTION - CAPITAL PURCHASES COLLECTION - CAPITAL REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT Replacement of Truck- Unit #301 45,000 Oakhill Ln 71,000 Smoke Testing & Manhole Repairs 55,000 0 0 0 Total:100,000 Total:71,000 FY 2013 Budgeted 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 COLLECTION - CAPITAL PURCHASES COLLECTION - CAPITAL REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT Lift Station No. 4 (Developer Cost Share Project)90,000 Total:90,000 Total:0 13 LONG TERM DEBT Par Principle FY 14 Interest 3/01 Interest 9/01 Subtotal Interest Total Maturity Date First Callable Date Project/Reason Series 2010 $2,000,000 $70,000.00 $38,091.25 $38,091.25 $146,182.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 $190,000.00 $28,525.00 $28,525.00 $247,050.00 9/1/2023 9/1/2020 Refund MUD #2 Unlimited Tax Bonds, 2002 and costs related to the issuance of the Bonds. Series 2013 $1,905,000 $165,000.00 $36,550.00 $27,412.50 $228,962.50 9/1/2023 9/1/2023 Refund MUD #2 Unlimited Tax Bonds Series 2003 and MUD #2 Unlimited Tax Refunding Bonds Series 2005 and costs related to the issuance of the Bonds. Total:$6,260,000 $425,000.00 $103,166.25 $94,028.75 $197,195.00 $622,195.00 SHORT TERM DEBT Outstanding Debt Principle FY 14 Interest 3/01 Interest 9/01 Subtotal Interest Total Payoff Date Project/Reason Department Contractual Obligation $70,000 $70,000.00 $1,515.50 $1,515.50 $3,031.00 $73,031.00 9/1/2014 2007 Fire Truck FIRE Notes Payable $71,982 $35,991.00 $1,423.00 $1,423.00 $2,846.00 $38,837.00 8/4/2015 2009 Gap Vax COLLECTIONS Revenue Note $367,000 $367,000.00 $5,266.45 $5,266.45 $10,532.90 $377,532.90 9/1/2014 2012 GST Expansion WATER Revenue Note $445,000 $143,000.00 $7,363.51 $2,793.50 $10,157.01 $153,157.01 9/1/2016 2013 Capital Projects 86% WATER & 14% WW Total:$953,982 $615,991.00 $15,568.46 $10,998.45 $26,566.91 $642,557.91 SCHEDULE GF - B DEBT PAYMENTS 14 ANNUALIZE GROWTH IN WATER METERS =5.50% PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2013 =4,050 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 4,069 18,491 75,233,605 2 NOV 4,087 13,162 53,795,223 3 DEC 4,106 10,586 43,466,935 4 JAN 4,125 9,366 38,633,014 5 FEB 4,144 7,897 32,724,565 6 MAR 4,163 10,510 43,748,759 7 APR 4,182 14,279 59,709,374 8 MAY 4,201 18,503 77,729,876 9 JUN 4,220 27,839 117,484,977 10 JUL 4,240 29,008 122,979,637 11 AUG 4,259 37,265 158,707,234 12 SEP 4,278 27,235 116,524,592 AVERAGE 4,173 18,678 TOTAL 940,737,792 CALCULATED AVERAGE WATER USE PER METER PER MONTH =(GALS/METER/MN)18,678 PROJECTED TOTAL NO. OF NEW RETAIL METERS IN FY13 =(METERS)228 Growth Rate Calculation Meters set June 2012 through May 2013:25 per month Growth Rate = Ave. New Meters Set/Total Meters at May 2013 (25*12)/3816 x 100% =7.8% 5.5% adopted by Board Purchased Water Expense (Projected Fort Worth Costs)Purchased Water (gallons):940,737,792 Out of District Volumetric Charge $1.8560 per 1000 gals $1,746,009 Rate of Use Charge $49,347 per month $592,164 SCHEDULE GF-C PROJECTED WATER USE PROJECTED RETAIL WATER SALES 15 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 253 111,576 298 125,746 343 137,631 380 157,288 458 208,694 387 200,363 311 112,350 241 83,134 204 52,059 210 55,824 155 43,979 195 71,7172,000 to 2,999 134 319,636 227 470,259 238 495,221 231 472,813 322 645,653 282 726,282 156 330,895 130 267,538 63 124,265 62 129,313 57 111,725 78 159,780 3,000 to 3,999 195 724,362 323 1,014,915 344 1,077,499 362 1,110,102 469 1,418,813 410 1,607,175 215 690,454 153 488,370 67 204,332 66 205,224 49 154,993 90 288,487 4,000 to 4,999 229 1,102,381 388 1,641,893 440 1,830,319 462 1,876,754 552 2,218,526 457 2,299,508 260 1,108,465 187 782,487 75 298,721 67 278,823 46 182,234 97 401,015 5,000 to 5,999 220 1,374,938 335 1,764,522 425 2,184,473 451 2,284,166 503 2,530,022 405 2,497,796 256 1,376,361 192 1,003,645 74 370,014 77 401,353 51 258,742 94 492,4836,000 to 6,999 206 1,521,055 306 1,901,944 372 2,303,197 419 2,526,383 423 2,548,736 330 2,335,772 269 1,729,213 199 1,253,434 76 460,196 73 465,975 48 289,221 106 668,6297,000 to 7,999 208 1,757,536 293 2,130,227 307 2,198,295 350 2,464,783 309 2,179,347 268 2,164,342 241 1,798,193 177 1,299,123 86 598,230 76 565,958 51 362,177 100 739,996 8,000 to 8,999 181 1,730,352 222 1,824,633 252 2,042,681 287 2,283,402 245 1,961,423 216 1,885,937 240 2,012,755 169 1,403,216 97 782,026 83 698,738 60 490,008 102 850,224 9,000 to 9,999 174 1,742,149 184 1,680,751 213 1,937,894 216 1,929,470 175 1,575,403 187 1,766,603 216 2,015,086 185 1,699,238 86 780,407 104 1,003,534 52 477,375 107 1,010,86410,000 to 14,999 153 1,741,358 163 1,645,112 169 1,657,312 184 1,839,623 142 1,427,913 153 1,531,144 195 2,038,316 171 1,766,888 101 1,012,138 95 1,012,143 55 554,197 105 1,081,99515,000 to 19,999 680 9,166,438 583 7,342,525 489 6,101,540 426 5,251,879 301 3,722,790 481 5,645,979 738 9,568,164 735 9,658,139 564 7,397,607 554 7,556,174 325 4,330,385 593 8,036,945 20,000 to 24,999 502 8,681,474 301 5,225,135 205 3,507,717 146 2,554,343 95 1,662,096 247 3,814,650 485 8,492,057 588 10,462,361 617 11,133,754 616 11,316,592 433 7,988,211 630 11,506,945 25,000 to 29,999 311 6,639,782 162 3,570,201 104 2,301,281 64 1,440,161 38 850,025 127 2,401,645 238 5,199,669 398 8,965,709 547 12,533,551 547 12,633,256 509 11,906,228 562 12,920,34630,000 to 34,999 206 5,255,323 78 2,071,701 53 1,412,401 30 817,928 19 534,651 64 1,446,299 121 3,145,939 234 6,341,318 449 12,556,679 428 11,871,079 487 13,723,685 412 11,450,30335,000 to 39,999 131 3,828,535 61 1,915,615 30 972,597 23 747,711 12 408,538 35 1,081,550 70 2,115,250 136 4,344,606 335 10,995,736 338 11,033,452 420 13,895,196 288 9,372,258 40,000 to 44,999 67 2,329,645 28 1,031,643 16 594,059 11 415,797 10 367,534 20 631,130 38 1,397,607 75 2,690,293 227 8,541,337 232 8,601,389 326 12,417,530 198 7,354,500 45,000 to 49,999 36 1,401,859 19 783,228 12 525,312 8 346,257 9 371,332 11 397,735 25 1,049,361 54 2,196,706 153 6,525,778 148 6,196,655 258 11,067,050 132 5,508,998 50,000 to 59,999 30 1,309,063 11 564,034 10 469,509 5 247,864 3 141,686 9 377,906 15 709,046 35 1,624,940 98 4,667,718 119 5,499,040 191 9,108,597 93 4,298,37860,000 to 69,999 37 1,951,652 20 1,089,759 16 904,234 10 543,260 13 696,002 13 725,776 22 1,152,768 32 1,730,136 110 5,992,445 112 5,932,227 259 14,077,751 104 5,625,928 70,000 +115 22,544,491 85 16,001,381 68 10,813,763 59 9,323,030 47 7,255,381 61 10,211,165 70 13,667,427 108 19,668,597 190 32,457,985 234 37,522,887 428 57,267,950 191 34,684,800 4,069 75,233,605 4,087 53,795,223 4,106 43,466,935 4,125 38,633,014 4,144 32,724,565 4,163 43,748,759 4,182 59,709,374 4,201 77,729,876 4,220 117,484,977 4,240 122,979,637 4,259 158,707,234 4,278 116,524,592 WATER USE FOR MONTH WATER RATES FOR ALL METER SIZES TOTAL USAGE:940,737,792 Gallons Included in Minimum Bill =0$ Amount of Minimum Bill =12.71MIN BILL =$12.71 0 to 6,999 $2.50 7,000 to 17,999 $3.05 18,000 to 25,999 $3.3026,000 to 50,999 $3.40 51,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 Usage0to1,999 $3,219 $279 $3,783 $314 $4,357 $344 $4,834 $393 $5,816 $522 $4,924 $501 $3,955 $281 $3,065 $208 $2,597 $130 $2,667 $140 $1,973 $110 $2,475 $1792,000 to 2,999 $1,700 $799 $2,879 $1,176 $3,029 $1,238 $2,940 $1,182 $4,093 $1,614 $3,579 $1,816 $1,981 $827 $1,656 $669 $801 $311 $783 $323 $730 $279 $996 $399 3,000 to 3,999 $2,475 $1,811 $4,111 $2,537 $4,374 $2,694 $4,598 $2,775 $5,958 $3,547 $5,216 $4,018 $2,728 $1,726 $1,949 $1,221 $856 $511 $834 $513 $627 $387 $1,150 $721 4,000 to 4,999 $2,908 $2,756 $4,929 $4,105 $5,587 $4,576 $5,866 $4,692 $7,013 $5,546 $5,812 $5,749 $3,304 $2,771 $2,371 $1,956 $952 $747 $846 $697 $580 $456 $1,230 $1,0035,000 to 5,999 $2,798 $3,437 $4,260 $4,411 $5,402 $5,461 $5,737 $5,710 $6,392 $6,325 $5,146 $6,244 $3,255 $3,441 $2,440 $2,509 $945 $925 $980 $1,003 $642 $647 $1,189 $1,2316,000 to 6,999 $2,620 $3,803 $3,888 $4,755 $4,732 $5,758 $5,331 $6,316 $5,381 $6,372 $4,196 $5,839 $3,423 $4,323 $2,531 $3,134 $965 $1,150 $930 $1,165 $612 $723 $1,352 $1,672 7,000 to 7,999 $2,639 $5,360 $3,725 $6,497 $3,902 $6,705 $4,455 $7,518 $3,928 $6,647 $3,405 $6,601 $3,063 $5,484 $2,254 $3,962 $1,088 $1,825 $963 $1,726 $644 $1,105 $1,276 $2,257 8,000 to 8,999 $2,307 $5,278 $2,816 $5,565 $3,204 $6,230 $3,643 $6,964 $3,111 $5,982 $2,744 $5,752 $3,047 $6,139 $2,147 $4,280 $1,237 $2,385 $1,054 $2,131 $765 $1,495 $1,296 $2,593 9,000 to 9,999 $2,212 $5,314 $2,340 $5,126 $2,711 $5,911 $2,746 $5,885 $2,224 $4,805 $2,378 $5,388 $2,746 $6,146 $2,352 $5,183 $1,098 $2,380 $1,326 $3,061 $666 $1,456 $1,362 $3,08310,000 to 14,999 $1,950 $5,311 $2,078 $5,018 $2,142 $5,055 $2,333 $5,611 $1,810 $4,355 $1,945 $4,670 $2,476 $6,217 $2,174 $5,389 $1,285 $3,087 $1,204 $3,087 $693 $1,690 $1,333 $3,300 15,000 to 19,999 $8,644 $27,958 $7,406 $22,395 $6,217 $18,610 $5,414 $16,018 $3,827 $11,355 $6,116 $17,220 $9,377 $29,183 $9,348 $29,457 $7,173 $22,563 $7,047 $23,046 $4,128 $13,208 $7,535 $24,513 20,000 to 24,999 $6,375 $28,649 $3,823 $17,243 $2,601 $11,575 $1,858 $8,429 $1,209 $5,485 $3,136 $12,588 $6,164 $28,024 $7,476 $34,526 $7,841 $36,741 $7,833 $37,345 $5,501 $26,361 $8,005 $37,973 25,000 to 29,999 $3,957 $22,575 $2,056 $12,139 $1,326 $7,824 $816 $4,897 $478 $2,890 $1,611 $8,166 $3,028 $17,679 $5,053 $30,483 $6,953 $42,614 $6,946 $42,953 $6,468 $40,481 $7,145 $43,92930,000 to 34,999 $2,621 $17,868 $997 $7,044 $672 $4,802 $384 $2,781 $244 $1,818 $816 $4,917 $1,543 $10,696 $2,976 $21,560 $5,709 $42,693 $5,439 $40,362 $6,185 $46,661 $5,234 $38,931 35,000 to 39,999 $1,664 $13,017 $772 $6,513 $378 $3,307 $291 $2,542 $158 $1,389 $448 $3,677 $886 $7,192 $1,728 $14,772 $4,257 $37,386 $4,294 $37,514 $5,332 $47,244 $3,659 $31,866 40,000 to 44,999 $849 $7,921 $358 $3,508 $202 $2,020 $139 $1,414 $124 $1,250 $250 $2,146 $484 $4,752 $956 $9,147 $2,885 $29,041 $2,947 $29,245 $4,148 $42,220 $2,519 $25,005 45,000 to 49,999 $452 $4,766 $238 $2,663 $154 $1,786 $103 $1,177 $111 $1,263 $134 $1,352 $324 $3,568 $686 $7,469 $1,942 $22,188 $1,876 $21,069 $3,282 $37,628 $1,679 $18,73150,000 to 59,999 $378 $4,582 $146 $1,974 $128 $1,643 $67 $868 $36 $496 $117 $1,323 $195 $2,482 $445 $5,687 $1,242 $16,337 $1,507 $19,247 $2,426 $31,880 $1,184 $15,04460,000 to 69,999 $476 $6,831 $259 $3,814 $206 $3,165 $125 $1,901 $160 $2,436 $160 $2,540 $277 $4,035 $412 $6,055 $1,396 $20,974 $1,429 $20,763 $3,294 $49,272 $1,326 $19,691 70,000 +$1,468 $78,906 $1,085 $56,005 $863 $37,848 $744 $32,631 $593 $25,394 $773 $35,739 $894 $47,836 $1,374 $68,840 $2,414 $113,603 $2,979 $131,330 $5,435 $200,438 $2,433 $121,397 $51,711 $247,220 $51,948 $172,801 $52,187 $136,552 $52,426 $119,704 $52,666 $99,490 $52,907 $136,248 $53,150 $192,801 $53,393 $256,508 $53,638 $397,589 $53,884 $416,719 $54,131 $543,739 $54,379 $393,518 $3,749,310 PROJECTED ANNUAL REVENUE GENERATED FROM PROPOSED RATES =$3,749,310 AMOUNT FROM BASE:$636,421 AMOUNT FROM USAGE:$3,112,889 TOTAL:$3,749,310 OTHER REVENUE SOURCES A B C D E MONTH SHUTOFFS FOR NON-PAYMENT LATE FEES ($/Month) PID MUD Jan-13 39 8 3 3272.63 Feb-13 31 11 3 9742.89 Mar-13 22 18 4 3134.38 Apr-13 22 30 2 2861.12 May-13 30 42 4 4819.66 Jun-13 30 24 5 7013.62 Jul-12 17 20 8 6192.95 Aug-12 25 12 4 5526.28 Sep-12 39 30 3 6111.26 Oct-12 32 17 2 5076.42 Nov-12 32 14 2 6058.41 Dec-12 44 14 4 4712.65 Total 363 232 41 $64,522 Average Per Month 30 21 4 $5,377 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):$9,075 SERVICE CHGS TOTAL LATE FEES:$64,522 PENALTIES REVENUE FOR MUD TAP FEES:$13,060 REVENUE FOR PID UTILITY FEES:$582,109 NEW METERS SET (TAP FEES) PID TABLE GF-D 2 TOTAL PROJECTED FY 2013 RETAIL WATER REVENUES Usage Groups TOTAL SCHEDULE GF-D FY 14 WATER REVENUE PROJECTION PROJECTED RETAIL WATER SALES FY 13 WATER USE CATEGORY 16 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug SepAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccounts Usage 0 to 1,999 253 111,576 298 125,746 343 137,631 380 157,288 458 208,694 387 200,363 311 112,350 241 83,134 204 52,059 210 55,824 155 43,979 195 71,717 2,000 to 2,999 134 319,636 227 470,259 238 495,221 231 472,813 322 645,653 282 726,282 156 330,895 130 267,538 63 124,265 62 129,313 57 111,725 78 159,780 3,000 to 3,999 195 724,362 323 1,014,915 344 1,077,499 362 1,110,102 469 1,418,813 410 1,607,175 215 690,454 153 488,370 67 204,332 66 205,224 49 154,993 90 288,487 4,000 to 4,999 229 1,102,381 388 1,641,893 440 1,830,319 462 1,876,754 552 2,218,526 457 2,299,508 260 1,108,465 187 782,487 75 298,721 67 278,823 46 182,234 97 401,015 5,000 to 5,999 220 1,374,938 335 1,764,522 425 2,184,473 451 2,284,166 503 2,530,022 405 2,497,796 256 1,376,361 192 1,003,645 74 370,014 77 401,353 51 258,742 94 492,4836,000 to 6,999 206 1,521,055 306 1,901,944 372 2,303,197 419 2,526,383 423 2,548,736 330 2,335,772 269 1,729,213 199 1,253,434 76 460,196 73 465,975 48 289,221 106 668,6297,000 to 7,999 208 1,757,536 293 2,130,227 307 2,198,295 350 2,464,783 309 2,179,347 268 2,164,342 241 1,798,193 177 1,299,123 86 598,230 76 565,958 51 362,177 100 739,9968,000 to 8,999 181 1,730,352 222 1,824,633 252 2,042,681 287 2,283,402 245 1,961,423 216 1,885,937 240 2,012,755 169 1,403,216 97 782,026 83 698,738 60 490,008 102 850,2249,000 to 9,999 174 1,742,149 184 1,680,751 213 1,937,894 216 1,929,470 175 1,575,403 187 1,766,603 216 2,015,086 185 1,699,238 86 780,407 104 1,003,534 52 477,375 107 1,010,864 10,000 to 14,999 153 1,741,358 163 1,645,112 169 1,657,312 184 1,839,623 142 1,427,913 153 1,531,144 195 2,038,316 171 1,766,888 101 1,012,138 95 1,012,143 55 554,197 105 1,081,995 15,000 to 19,999 680 N/A 583 N/A 489 N/A 426 N/A 301 N/A 481 N/A 738 N/A 735 N/A 564 N/A 554 N/A 325 N/A 593 N/A 20,000 to 24,999 502 N/A 301 N/A 205 N/A 146 N/A 95 N/A 247 N/A 485 N/A 588 N/A 617 N/A 616 N/A 433 N/A 630 N/A 25,000 to 29,999 311 N/A 162 N/A 104 N/A 64 N/A 38 N/A 127 N/A 238 N/A 398 N/A 547 N/A 547 N/A 509 N/A 562 N/A 30,000 to 34,999 206 N/A 78 N/A 53 N/A 30 N/A 19 N/A 64 N/A 121 N/A 234 N/A 449 N/A 428 N/A 487 N/A 412 N/A35,000 to 39,999 131 N/A 61 N/A 30 N/A 23 N/A 12 N/A 35 N/A 70 N/A 136 N/A 335 N/A 338 N/A 420 N/A 288 N/A40,000 to 44,999 67 N/A 28 N/A 16 N/A 11 N/A 10 N/A 20 N/A 38 N/A 75 N/A 227 N/A 232 N/A 326 N/A 198 N/A45,000 to 49,999 36 N/A 19 N/A 12 N/A 8 N/A 9 N/A 11 N/A 25 N/A 54 N/A 153 N/A 148 N/A 258 N/A 132 N/A 50,000 to 59,999 30 N/A 11 N/A 10 N/A 5 N/A 3 N/A 9 N/A 15 N/A 35 N/A 98 N/A 119 N/A 191 N/A 93 N/A 60,000 to 69,999 37 N/A 20 N/A 16 N/A 10 N/A 13 N/A 13 N/A 22 N/A 32 N/A 110 N/A 112 N/A 259 N/A 104 N/A 70,000 +115 N/A 85 N/A 68 N/A 59 N/A 47 N/A 61 N/A 70 N/A 108 N/A 190 N/A 234 N/A 428 N/A 191 N/A WASTEWATER RATES FOR ALL METER SIZES Gallons Included in Minimum Bill =0 $ Amount of Minimum Bill =12.71 MIN BILL =$12.710to6,999 $2.507,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,219 $279 $3,783 $314 $4,357 $344 $4,834 $393 $5,816 $522 $4,924 $501 $3,955 $281 $3,065 $208 $2,597 $130 $2,667 $140 $1,973 $110 $2,475 $1792,000 to 2,999 $1,700 $799 $2,879 $1,176 $3,029 $1,238 $2,940 $1,182 $4,093 $1,614 $3,579 $1,816 $1,981 $827 $1,656 $669 $801 $311 $783 $323 $730 $279 $996 $399 3,000 to 3,999 $2,475 $1,811 $4,111 $2,537 $4,374 $2,694 $4,598 $2,775 $5,958 $3,547 $5,216 $4,018 $2,728 $1,726 $1,949 $1,221 $856 $511 $834 $513 $627 $387 $1,150 $721 4,000 to 4,999 $2,908 $2,756 $4,929 $4,105 $5,587 $4,576 $5,866 $4,692 $7,013 $5,546 $5,812 $5,749 $3,304 $2,771 $2,371 $1,956 $952 $747 $846 $697 $580 $456 $1,230 $1,003 5,000 to 5,999 $2,798 $3,437 $4,260 $4,411 $5,402 $5,461 $5,737 $5,710 $6,392 $6,325 $5,146 $6,244 $3,255 $3,441 $2,440 $2,509 $945 $925 $980 $1,003 $642 $647 $1,189 $1,231 6,000 to 6,999 $2,620 $3,803 $3,888 $4,755 $4,732 $5,758 $5,331 $6,316 $5,381 $6,372 $4,196 $5,839 $3,423 $4,323 $2,531 $3,134 $965 $1,150 $930 $1,165 $612 $723 $1,352 $1,672 7,000 to 7,999 $2,639 $4,394 $3,725 $5,326 $3,902 $5,496 $4,455 $6,162 $3,928 $5,448 $3,405 $5,411 $3,063 $4,495 $2,254 $3,248 $1,088 $1,496 $963 $1,415 $644 $905 $1,276 $1,8508,000 to 8,999 $2,307 $4,326 $2,816 $4,562 $3,204 $5,107 $3,643 $5,709 $3,111 $4,904 $2,744 $4,715 $3,047 $5,032 $2,147 $3,508 $1,237 $1,955 $1,054 $1,747 $765 $1,225 $1,296 $2,1269,000 to 9,999 $2,212 $4,355 $2,340 $4,202 $2,711 $4,845 $2,746 $4,824 $2,224 $3,939 $2,378 $4,417 $2,746 $5,038 $2,352 $4,248 $1,098 $1,951 $1,326 $2,509 $666 $1,193 $1,362 $2,52710,000 to 14,999 $1,950 $4,353 $2,078 $4,113 $2,142 $4,143 $2,333 $4,599 $1,810 $3,570 $1,945 $3,828 $2,476 $5,096 $2,174 $4,417 $1,285 $2,530 $1,204 $2,530 $693 $1,385 $1,333 $2,705 15,000 to 19,999 $8,644 $20,404 $7,406 $17,481 $6,217 $14,674 $5,414 $12,779 $3,827 $9,034 $6,116 $14,437 $9,377 $22,133 $9,348 $22,065 $7,173 $16,932 $7,047 $16,635 $4,128 $9,743 $7,535 $17,784 20,000 to 24,999 $6,375 $15,048 $3,823 $9,023 $2,601 $6,138 $1,858 $4,386 $1,209 $2,853 $3,136 $7,403 $6,164 $14,548 $7,476 $17,646 $7,841 $18,508 $7,833 $18,488 $5,501 $12,985 $8,005 $18,894 25,000 to 29,999 $3,957 $9,339 $2,056 $4,854 $1,326 $3,129 $816 $1,926 $478 $1,128 $1,611 $3,803 $3,028 $7,148 $5,053 $11,927 $6,953 $16,411 $6,946 $16,396 $6,468 $15,268 $7,145 $16,866 30,000 to 34,999 $2,621 $6,187 $997 $2,354 $672 $1,586 $384 $905 $244 $576 $816 $1,926 $1,543 $3,643 $2,976 $7,024 $5,709 $13,475 $5,439 $12,837 $6,185 $14,598 $5,234 $12,355 35,000 to 39,999 $1,664 $3,929 $772 $1,823 $378 $892 $291 $688 $158 $373 $448 $1,056 $886 $2,090 $1,728 $4,078 $4,257 $10,049 $4,294 $10,135 $5,332 $12,586 $3,659 $8,63640,000 to 44,999 $849 $2,004 $358 $845 $202 $477 $139 $329 $124 $292 $250 $591 $484 $1,143 $956 $2,255 $2,885 $6,811 $2,947 $6,956 $4,148 $9,790 $2,519 $5,94645,000 to 49,999 $452 $1,066 $238 $561 $154 $363 $103 $244 $111 $261 $134 $317 $324 $764 $686 $1,620 $1,942 $4,584 $1,876 $4,427 $3,282 $7,746 $1,679 $3,96350,000 to 59,999 $378 $892 $146 $344 $128 $302 $67 $159 $36 $86 $117 $276 $195 $461 $445 $1,051 $1,242 $2,932 $1,507 $3,556 $2,426 $5,726 $1,184 $2,795 60,000 to 69,999 $476 $1,123 $259 $612 $206 $486 $125 $295 $160 $379 $160 $377 $277 $655 $412 $972 $1,396 $3,296 $1,429 $3,374 $3,294 $7,774 $1,326 $3,130 70,000 +$1,468 $3,464 $1,085 $2,561 $863 $2,038 $744 $1,756 $593 $1,399 $773 $1,825 $894 $2,111 $1,374 $3,244 $2,414 $5,697 $2,979 $7,030 $5,435 $12,828 $2,433 $5,743 $51,711 $93,769 $51,948 $75,958 $52,187 $69,748 $52,426 $65,828 $52,666 $58,167 $52,907 $74,548 $53,150 $87,725 $53,393 $96,999 $53,638 $110,401 $53,884 $111,876 $54,131 $116,355 $54,379 $110,525 PROJECTED ANNUAL REVENUE GENERATED FROM PROPOSED RATES =$1,708,321 AMOUNT FROM BASE:$636,421 AMOUNT FROM USAGE:$1,071,900 TOTAL:$1,708,321 Usage Groups TOTAL SCHEDULE GF-E PROJECTED RETAIL WASTEWATER SALES FY 14 WATER USECATEGORY PROJECTED FY 2013 RETAIL WATER REVENUES 17 SCHEDULE GF-F UNIFORMS WATER ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL ` UNIFORM SHIRTS 6 10 60 $8 $480 POLO SHIRTS 0 0 0 $35 $0 SWEATSHIRTS 6 5 30 $18 $540 PANTS 6 7 42 $25 $1,050 BOOTS 6 1 6 $175 $1,050 JACKET 1 1 1 $150 $150 TOTAL:$3,270 WASTEWATER ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 4 6 24 $8 $192 POLO SHIRTS 0 6 0 $35 $0 SWEATSHIRTS 4 5 20 $18 $360 PANTS 4 5 20 $25 $500 BOOTS 4 1 4 $175 $700 JACKET 0 1 0 $150 $0 TOTAL:$1,752 COLLECTIONS ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 2 10 20 $8 $160 POLO SHIRTS 0 6 0 $35 $0 SWEATSHIRTS 2 5 10 $18 $180 PANTS 2 7 14 $25 $350 BOOTS 2 1 2 $175 $350 JACKET 0 1 0 $150 $0 TOTAL:$1,040 ADMINISTRATION ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL POLO SHIRTS 7 4 28 $35 $980 SWEATER 4 1 4 $40 $160 PANTS 2 5 10 $25 $250 TOTAL:$1,390 18 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 8 $325 $2,600 $50 $300 Plumbing Class 1 $90 $90 $50 $50 Management Classes 0 $350 $0 $100 $0 Management Conferences 1 $350 $350 $400 $400 License Renewal 4 $111 $444 $100 $400 CDL Renewal 2 $75 $150 $0 $0 Miscellaneous Mileage/Travel (Miles)1,000 $0.55 $550 $0 $300 $4,184 $1,450 $5,634 WASTEWATER Wastewater Classes 5 $325 $1,625 $50 $250 Management Classes 0 $350 $0 $100 $0 Management Conferences 1 $350 $350 $400 $400 License Renewal 1 $111 $111 $100 $100 CDL Renewal 0 $75 $0 $0 $0 Miscellaneous Mileage/Travel (Miles)1,000 $0.55 $550 $0 $300 $2,636 $1,050 $3,686 COLLECTIONS Collections/Distribution Classes 3 $325 $975 $50 $150 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 $1,711 $550 $2,261 ADMINISTRATION Management Classes 2 $350 $700 $300 $600 Management Conferences 4 $350 $1,400 $400 $1,600 Elections Training 2 $350 $700 $400 $800 Public Funds Inv. Training 2 $300 $600 $100 $200 Govmt Accounting Conference 1 $350 $350 $400 $400 Software Training 4 $300 $1,200 $50 $200 HTML Training 1 $750 $750 $100 $100 Customer Service Conferences 2 $350 $700 $400 $800 CPA/CFE Classes/Renewal 1 $550 $550 Miscellaneous Mileage/Travel (Miles)1,000 $0.55 $550 $0 $300 $7,500 $5,000 $12,500 19 SCHEDULE GF-H SALARY WORKSHEET COLA Merit 50% Town Total Social TWC WORKERS Base Pay Base Pay Pay Pay Stipend Salaries OT Holiday Longevity Certification Security Medi UNEMP COMP FIRE DEPARTMENT %No Split With Split 2.0%0.0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%2.1% TO $4500 51.20% (Stipend Not Included)(9/year) Fire Chief 50.00%102,693 51,346 1,027 0 900 52,373 0 0 1,283 642 0 0 3,343 782 95 900 Fire Lieutenant 50.00%65,376 32,688 654 0 750 33,342 0 1,154 698 349 1,200 600 2,244 525 95 604 Fire Lieutenant 50.00%74,767 37,384 748 0 750 38,131 0 1,320 1,575 788 900 450 2,569 601 95 692 Fire Lieutenant 50.00%70,884 35,442 709 0 750 36,151 0 1,251 953 477 900 450 2,423 567 95 652 Fire Fighter/EMT-P 50.00%49,245 24,622 492 0 600 25,115 0 869 555 278 600 300 1,684 394 95 453 Fire Fighter/EMT-P 50.00%48,307 24,154 483 0 600 24,637 0 853 260 130 600 300 1,644 385 95 443 Engineer - Fire Fighter/EMT-P 50.00%61,145 30,572 611 0 600 31,184 0 1,079 1,013 507 600 300 2,088 488 95 562 Engineer - Fire Fighter/EMT-P 50.00%58,863 29,431 589 0 600 30,020 0 1,039 698 349 900 450 2,012 471 95 542 Engineer - Fire Fighter/EMT-P 50.00%60,139 30,069 601 0 600 30,671 0 1,062 773 387 1,200 600 2,066 483 95 556 Fire Fighter/EMT-P 50.00%54,855 27,427 549 0 600 27,976 0 968 773 387 600 300 1,874 438 95 505 Fire Fighter/EMT-P 50.00%50,464 25,232 505 0 600 25,737 0 891 600 300 600 300 1,725 403 95 464 Fire Fighter/EMT-P 50.00%45,407 22,704 454 0 600 23,158 0 802 215 108 600 300 1,548 362 95 417 Fire Fighter/EMT-P 50.00%47,438 23,719 474 0 600 24,193 0 837 140 70 0 0 1,593 373 95 429 Fire Fighter/EMT-P 50.00%45,407 22,704 454 0 600 23,158 0 802 0 0 0 0 1,523 356 95 410 Fire Fighter/EMT-P 50.00%34,055 17,028 341 0 0 17,368 0 601 0 0 0 0 1,114 261 95 300 Part-Time Staff 50.00%24,455 12,228 0 0 0 12,228 0 0 0 0 0 0 758 177 841 780 FTO 50.00%950 475 0 0 0 475 0 0 0 0 0 0 29 7 0 0 Built-in OT 50.00%63,509 31,755 0 0 0 N/A 31,755 0 0 0 0 0 1,969 460 0 0 OT Pay - Sick/Vac (less PT)50.00%13,689 6,845 0 0 0 N/A 6,845 0 0 0 0 0 424 99 0 0 Special Event OT 50.00%11,251 5,626 0 0 0 N/A 5,626 0 0 0 0 0 349 82 0 0 TOTAL:982,899 491,450 8,690 0 9,150 455,916 44,225 13,529 4,768 4,350 32,980 7,713 2259 8,708 COLA Merit Merit Total Social TWC Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare UNEMP WORKERS ADMINISTRATION %Base Pay Base Pay 3.0%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%.10% TO $9000 COMP District Manager 100%102,515 102,515 3,075 0 1,200 106,790 0 0 90 90 0 0 9 District Secretary 100%67,175 67,175 2,015 0 1,200 70,390 0 0 180 180 0 0 9 Fin. Analyst/HR Mgr 100%75,000 75,000 2,250 0 1,200 78,450 0 0 0 0 0 0 9 Finance Manager 100%80,401 80,401 2,412 0 1,200 84,013 0 0 1,980 1,980 0 0 9 Utility Billing/Admin Asst.100%39,817 39,817 1,195 0 1,040 42,052 0 0 488 488 0 0 9 Utility Billing/Admin Asst.100%33,792 33,792 1,014 0 1,040 35,845 0 0 145 145 0 0 9 Utility Billing/Admin Asst.100%38,000 38,000 1,140 0 1,040 40,180 0 0 135 135 0 0 9 Overtime Pay 500 DM Discretionary 1,000 TOTAL:436,700 436,700 13,101 0 7,920 458,721 500 0 3,018 0 28,659 6,702 63 1575 500,140 20 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 3.0%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%.10% TO $9000 COMP Utility Superintendent 100%68,497 68,497 2,055 0 1,500 72,052 0 0 1,913 1,913 0 0 9 Field Supervisor 100%56,478 56,478 1,694 0 1100 59,272 0 0 1372.5 1,373 1800 1800 9 Crew Leader 100%43,643 43,643 1,309 0 1040 45,992 0 0 1072.5 1,073 1200 1200 9 Utility Field Worker 100%39,840 39,840 1,195 0 1040 42,075 0 0 547.5 548 1200 1200 9 Utility Field Worker 100%33,280 33,280 998 0 1040 35,318 0 0 0 0 600 600 9 Utility Field Worker 100%32,000 32,000 0 0 0 32,000 0 0 300 300 9 Overtime Pay 13,391 DM Discretionary 1,000 TOTAL:273,737 273,737 7,252 0 5,720 287,709 13,391 0 4,905 5,100 19,289 4,511 54 9829 COLA Merit Merit Total Social TWC Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare UNEMP WORKERS WASTEWATER %Base Pay Base Pay 3.0%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%.10% TO $9000 COMP Wastewater Superintendent 100%60,800 60,800 1,824.01 0 1,500 64,124 - - 80 80 - - 9 Crew Leader 100%50,898 50,898 1,526.93 0 1,040 53,465 - - 1403 1,403 1,800 1,800 9 Utility Field Worker 100%45,188 45,188 1,355.64 0 1,040 47,584 - - 1013 1,013 1,800 1,800 9 Utility Field Worker 100%34,642 34,642 1,039.26 0 1,040 36,721 - - 503 503 1,200 1,200 9 Overtime Pay 11,965 - 0 0 - - DM Discretionary 1,000 - - 0 0 - - TOTAL:191,528 191,528 5,746 0 201,894 202,894 11,965 0 2,998 4,800 13,805 3,229 36 6552 COLA Merit Merit Total Social TWC Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare UNEMP WORKERS COLLECTIONS %Base Pay Base Pay 3.0%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%.10% TO $9000 COMP Crew Leader 100%49,073 49,073 1,472 0 1,040 51,586 0 0 1,485 1,485 1,200 1,200 9 Utility Field Worker 100%35,605 35,605 1,068 0 1,040 37,714 0 0 623 623 600 600 9 Overtime Pay 10,028 0 DM Discretionary 1,000 TOTAL:84,679 84,679 2,540 0 89,299 90,299 10,028 0 17,913 1,800 7,442 1,741 198 3276 21 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 TOWN 1 2 $181 $362 No coverage 0 $0 $0 No coverage 0 $0 $0 TOWN 2 2 $248 $495 Employee Only 2 $408 $816 Employee Only 3 $408 $1,224 TOWN 3 1 $254 $254 Employee & Spouse 1 $571 $571 Employee & Spouse 0 $571 $0 TOWN 4 10 $312 $3,119 Employee & Children 1 $697 $697 Employee & Children 1 $697 $697 Family 3 $1,005 $3,016 Family 2 $1,005 $2,011 TOTAL 15 $4,230 TOTAL 7 $5,100 TOTAL 6 $3,932 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 TOWN 1 5 $41 $203 No coverage 0 $0 $0 No coverage 0 $0 $0 TOWN 2 10 $69 $689 Employee Only 2 $115 $230 Employee Only 3 $115 $345 Employee & Spouse 1 $114 $114 Employee & Spouse 0 $114 $0 Employee & Children 1 $100 $100 Employee & Children 1 $100 $100 Family 3 $215 $644 Family 2 $215 $429 TOTAL 15 $892 TOTAL 7 $1,087 TOTAL 6 $873 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 TOWN 1 5 $2,652 $13,261 No coverage 0 $0 $0 No coverage 0 $0 $0 TOWN 2 3 $3,983 $11,948 Employee Only 4 $6,976 $27,904 Employee Only 5 $6,976 $34,880 TOWN 3 7 $4,537 $31,759 Employee & Spouse 1 $9,588 $9,588 Employee & Spouse 0 $9,588 $0 Employee & Children 2 $10,215 $20,430 Employee & Children 0 $10,215 $0 Family 0 $13,453 $0 Family 1 $13,453 $13,453 TOTAL 15 $56,968 TOTAL 7 $57,923 TOTAL 6 $48,334 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL $4,250 TOTAL $4,483 TOTAL $3,306 FOR ALL DEPARTMENTS EXCLUDING FIRE- A 10% INCREASE IN EMPLOYEE BENEFITS WAS BUDGETED AS RENEWAL IS NOT UNTIL JANUARY 2014 MEDICAL MEDICAL MEDICAL LIFE & OTHER LIFE & OTHER LIFE & OTHER DENTAL DENTAL DENTAL VISION VISION VISION 22 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 1 $408 $408 Employee Only 0 $408 $0 Employee & Spouse 1 $571 $571 Employee & Spouse 0 $571 $0 Employee & Children 0 $697 $0 Employee & Children 1 $697 $697 Family 2 $1,005 $2,011 Family 1 $1,005 $1,005 TOTAL 4 $2,989 TOTAL 2 $1,703 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 $115 $115 Employee Only 0 $115 $0 Employee & Spouse 1 $114 $114 Employee & Spouse 0 $114 $0 Employee & Children 0 $100 $0 Employee & Children 1 $100 $100 Family 2 $215 $429 Family 1 $215 $215 TOTAL 4 $658 TOTAL 2 $314 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 $6,976 $6,976 Employee Only 0 $6,976 $0 Employee & Spouse 1 $9,588 $9,588 Employee & Spouse 0 $9,588 $0 Employee & Children 0 $10,215 $0 Employee & Children 1 $10,215 $10,215 Family 2 $13,453 $26,906 Family 1 $13,453 $13,453 TOTAL 4 $43,471 TOTAL 2 $23,668 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL $2,303 TOTAL $1,066 LIFE & OTHER LIFE & OTHER DENTAL DENTAL VISION VISION MEDICAL MEDICAL 23 SCHEDULE GF-J RETIREMENT WORKSHEET FIRE DEPARTMENT WASTEWATER TMRS TCDRS TOTAL FY 2014 SALARY 14.55%TOTAL FY 2014 SALARY 8.98% Fire Chief 52,373 7620 Wastewater Superintendent 64,204 5,766 Fire Lieutenant 33,342 4851 Crew Leader 56,667 5,089 Fire Lieutenant 38,131 5548 Utility Field Worker 50,396 4,526 Fire Lieutenant 36,151 5260 Utility Field Worker 38,424 3,450 Fire Fighter/EMT-P 25,115 3654 Overtime Pay 11,965 1,074 Fire Fighter/EMT-P 24,637 3585 TOTAL:221,656 19,905 Engineer - Fire Fighter/EMT-P 31,184 4537 Engineer - Fire Fighter/EMT-P 30,020 4368 Engineer - Fire Fighter/EMT-P 30,671 4463 COLLECTIONS Fire Fighter/EMT-P 27,976 4070 TCDRS Fire Fighter/EMT-P 25,737 3745 TOTAL FY 2014 SALARY 8.98% Fire Fighter/EMT-P 23,158 3369 Crew Leader 54,271 4,874 Fire Fighter/EMT-P 24,193 3520 Utility Field Worker 38,936 3,496 Fire Fighter/EMT-P 23,158 3369 Overtime Pay 7,297 655 Fire Fighter/EMT-P 17,368 2527 TOTAL:100,504 9,025 Part-Time Staff 12,228 0 FTO 475 69 Overtime Pay (Total)44,225 6435 TOTAL:500,140 70,991 ADMINISTRATION TCDRS TOTAL FY 2014 SALARY 8.98% District Manager 106,880 9,598 District Secretary 70,570 6,337 Financial Anaylst & HR Manager 78,450 7,045 Finance Manager 85,993 7,722 Utility Billing/Admin Asst.42,539 3,820 Utility Billing/Admin Asst.35,990 3,232 Utility Billing/Admin Asst.40,315 3,620 Overtime Pay 500 45 TOTAL:461,238 41,419 WATER TCDRS TOTAL FY 2014 SALARY 8.98% Utility Superintendent 73,964 6,642 Field Supervisor 62,445 5608 Crew Leader 48,264 4334 Utility Field Worker 43,823 3935 Utility Field Worker 35,918 3225 Utility Field Worker 32,300 2901 Overtime Pay 13,391 1203 TOTAL:310,105 27,847 24 SCHEDULE GF-K Electricity & Gas Analysis for FY 2012-2013 Hudson Energy FY 2014 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 109560 8123 103344 7723 79944 6315 48192 4280 16560 1765 18480 2397 12720 2053 5760 1253 6240 1135 14640 1676 24480 2739 70800 5728 510,720 45,187 0.088478 49,706 2770721 135-60020-010 Elevated Tank-TW King 53 15 43 14 70 16 70 16 85 18 84 18 669 72 1022 104 986 100 102 19 69 16 60 15 3,313 423 0.127618 465 2828381 135-60020-010 Paluxy Well #4 3408 321 2912 276 2936 282 2904 279 13520 1263 12960 1007 13360 1038 12080 955 12400 972 640 215 2320 323 12800 998 92,240 7,930 0.085971 8,723 2829590 135-60020-010 Paluxy Well #2 15900 1205 14136 1112 14298 1115 14352 1119 15902 1218 15240 1176 15225 1195 14629 1156 14708 1149 10417 880 15142 1177 15203 1181 175,152 13,683 0.07812 15,051 2836131 135-60020-010 Water Plant/Water Barn 1396 224 1465 212 1506 211 1122 238 862 187 2275 387 5986 649 3364 481 4106 496 2380 385 1453 326 1434 239 27,349 4,037 0.147595 4,440 2836162 135-60020-010 Water plant pump station 63600 6885 106530 10489 76260 7974 43110 6040 3600 1257 2600 485 4600 1343 3600 574 3200 577 4000 1329 3600 1295 61400 6366 376,100 44,615 0.118626 49,077 8644641 135-60020-010 100 Municipal Dr, Unit B 26700 2853 400 844 400 667 18600 2413 45200 4024 616 3273 973 2614 22200 2551 22700 2616 32100 3176 39100 3992 2000 1026 210,989 30,047 0.142411 33,052 9130039 135-60020-010 2901 Bobcat Unit A, Elev Tank 2129 221 2293 192 2281 221 1560 155 9530 81 863 90 11160 84 993 102 1032 105 785 82 803 84 774 81 34,203 1,496 0.043753 1,646 TOTAL: 162,160 2828536 135-60020-020 Sewer Plant 147368 11311 133639 10491 144839 11332 141195 11491 148782 11627 143546 11290 151865 11804 155327 12140 160465 12563 132297 10515 119515 9693 131941 10496 1,710,779 134,753 0.078767 148,229 TOTAL:148,229 7716439 135-60020-021 WWTP Barn/Split Town/MUD 1079 132 824 115 695 109 601 99 613 104 631 154 2485 290 1733 241 1737 239 827 179 533 151 424 85 12,179 1,897 0.155736 2,086 8611313 135-60020-021 Collection Barn for Vac-Con 670 116 445 101 386 100 288 111 290 85 1035 216 7702 700 2599 308 6623 564 3426 359 533 165 304 86 24,301 2,912 0.119835 3,203 8251800 135-60020-021 310 Skyline-Lift Sta #6 495 162 435 158 510 171 395 164 500 108 500 115 600 105 500 -159 500 166 700 304 400 134 500 98 6,035 1,523 0.252406 1,676 5437067 135-60020-021 Lift Sta #2 Guard Light 70 13 70 13 70 13 70 13 70 13 70 13 70 13 70 13 70 13 70 26 70 13 70 13 840 171 0.203595 188 2820941 135-60020-021 Lift Station Trophy 20 336 41 263 34 295 37 279 36 293 37 286 36 374 44 299 37 309 38 359 81 269 34 317 39 3,679 494 0.134303 544 2828598 135-60020-021 Lift Station #4 848 87 736 77 768 81 672 72 640 69 800 84 800 84 640 69 640 69 800 152 800 83 960 98 9,104 1,025 0.112605 1,128 6245046 135-60020-021 Lift Station #2 1397 225 1271 169 1320 214 1245 209 1346 208 1449 222 1615 275 1368 214 1325 209 1512 438 1349 211 1470 233 16,667 2,826 0.169555 3,109 9215255 135-60020-021 Lift Station #1 915 119 810 182 720 129 660 111 900 197 800 121 1100 215 900 125 800 125 800 276 800 125 900 158 10,105 1,883 0.186363 2,072 9843774 135-60020-021 Lift Station #7 216 30 191 27 175 26 140 23 145 23 166 25 178 26 174 26 149 23 177 49 196 28 183 26 2,090 333 0.159177 366 8306586 135-60020-021 PID Lift Station #8 321 39 357 42 447 51 452 52 434 50 473 54 2309 47 464 53 461 68 432 95 486 54 441 50 7,077 656 0.092645 721 TOTAL:15,092 8797254 122-60020-045 Fire Station 9079 582 21533 1940 12865 1104 9826 881 9196 835 8669 829 9815 438 8678 811 8402 787 9482 851 9855 915 13039 1117 130,439 11,091 0.085032 12,201 TOTAL:12,201 Split 50/50 with Town:6,100 Direct Energy (Split with Town) This is only the MUD expense 2836100 135-60020-030 MUD & PW Bldgs 11543 1204 12146 1254 10179 1113 3461 943 8730 990 9180 1079 14490 1540 10680 1196 11310 1245 9870 1139 8880 1018 9840 1071 120,308 13,792 0.114638 15,171 TOTAL:15,171 Tri-County Meter # 165775 135-60020-021 Lift Station 3 3600 303 3572 301 3391 287 3151 276 2925 258 2954 261 2670 238 2912 257 2688 246 2842 266 3398 313 3805 317 37,908 3,323 0.087671 3,656 170037 135-60020-021 Lift Station 5 1875 170 1851 168 1828 166 1616 154 1499 145 1465 149 1312 137 1490 144 1452 145 1338 139 1739 173 2157 183 19,622 1,874 0.095506 2,061 170038 135-60020-021 Lift Station 5 (Backup)24 28 22 27 26 28 25 28 26 28 26 29 24 29 24 28 23 28 24 28 28 28 26 28 298 336 1.126007 369 TOTAL:6,086 Atmos - Gas @ Fire Station (Measures by Thousand Cubic Feet) Meter S/N 11N375438122-60020-045 Fire Station 1 17 3 27 2 24 2 51 7 58 12 101 36 233 14 108 13 93 7 58 46 45 26 34 170 850 4.984981 935 TOTAL:935 Split 5/50 with Town:467.33 Jun-13 Jul-12 Aug-12 Sept-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 25 SCHEDULE GF-L CONTRACTUAL SERVICES WITH TOWN OF TROPHY CLUB Department Amount FY 2014 Comment Amount FY 2013 135-55161-030-000 Information Technology 79,632 60% Town 40% MUD split of IT budget 78,461 Grounds Maintenance 9025 Includes all site except WWTP; 17 per year 9025 Janitorial Services -11,609 -7,131 TOTAL:77,048 80,355 Account Description Amount 135-55030-030 Software & Support Used R For Recurring, NR For Non-Recurring. *** - Non Dept Specific R-STW - GL/Payroll Software Lease & Maint 4,900$ R-STW - GL Support & Upgrades 4,250$ R-STW-Payroll software Lease & Maint 1,250$ R-STW Payroll Support & Upgrades 2,000$ R-STW - UB Software Lease & Maintenance 2,363$ R-STW - UB Support & Upgrades 2,625$ R-STW-AR Software Lease & Maint 1,500$ R-STW-AR Support & Upgrades 1,000$ R-STW Vision Reporting Annual Maintenance 846$ R-STW eFormz Annual Maintenance 250$ R-STW PowerHouse (Part of core apps) Lease & Maint 1,620$ R-Clear Rec Annual Maintenance 600$ 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.-$ 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.1,165$ R-Online Survey, 50% Shared. R-Anti-Virus Maintenance and Support, 40% Shared.452$ R-Malware-Bytes Maintenance and Support, 40% Shared.600$ 26 R-Micorsoft Tech Subscription, 50% Shared 250$ R-VMWare Annual Support, 50% Shared 2,690$ R-Veeam Annual Support, 50% Shared 2,124$ *** - MUD Manager Account Description Amount R-Agenda Maintenance and Support, 50% Shared.-$ R-Records Software Maint & Support (WinOc)-$ *** - Collection Department R-Automatic Meter Reading Maintenance 3,590$ R-Pipelogix Maintenance 1,900$ R-AudioTel Remit Plus Annual Support 1,750$ R-AudioTel Annual Scanner Support 585$ Totals:59,698$ 122-55030-045 Description Amount Software & Support - Fire Dept.R-Firehouse Support and Maintenance 1,575$ R-Fire- OSSI Support ( 3 units)375$ R-Denton County RMS Bandwidth, 50% shared 6,732$ Totals:8,682$ 135-65055-030 Description Amount 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$ R-Fire Extinguishers Maintenance 60$ ************************************************** GASB 34 Expenditures (Offsetting Revenue) ************************************************** NR - Replacement Computers 4,514$ NR - Replacement Servers -$ NR - Replacement Copiers & Printers NR - Replacement Infrastructure 4,450$ NR - Replacement Phones -$ NR - Replacement Audio Video -$ NR - Replacement Security -$ NR - Replacement Software NR - Replacement First Responders MDT -$ NR - Replacement Other -$ 8,964$ GASB REVENUE IN BUDGET Used R For Recurring, NR For Non-Recurring. Totals:13,562$ Account Description Amount 135-65090-030 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-030 27 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$ Account Description Amount 135-69195-030 Transfer to Future Replacment Reserve Description Amount Information Systems Replacement Fund -$ ($134,555 Total Assets) Totals:-$ 28 Schedule GF-M Fuel 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.228.55 $772.00 $3.38 INSPECTIONS 6 1 6 $50 $300 Dodge Dakota 609.57 $2,046.71 $3.36 Generator Maintenance $1,000 Dump Truck 164.40 $607.58 $3.70 Cat Backhoe 538.80 $1,990.00 $3.69 2004 Chevy 536.70 $1,960.10 $3.65 2007 Dodge 2500 1,073.36 $3,603.32 $3.36 2012 Ford crew cab 503.87 $1,727.15 $3.43 250 kw Generator 1,200.00 $4,320.00 $3.60 Average:4855.25 $17,026.86 $3.52 Total Fuel and Lube:$23,181 5340.78 $20,681 $3.87 10% Increase Wastewater Department 2013 Chevy Ext Cab 485.44 $1,699.72 $3.50 2013 Chevy 2WD Reg Cab 580.27 $2,032.28 $3.50 No. Vehicles No./Year Total/Year Cost Each Total Amt. Misc. WWTP 477.21 $1,588.54 $3.33 OIL CHANGES 4 4 16 $50 $800 GMC 1 ton 172.50 $563.66 $3.27 INSPECTIONS 4 1 4 $50 $200 Ford Backhoe 278.20 $1,021.11 $3.67 Generator Maintenance $1,120 650 kw Generator 1,000.00 $3,600.00 $3.60 Average:2993.62 $10,505.31 $3.48 3292.98 $12,600 $3.83 10% Increase Total Fuel and Lube:$14,720 Collection Department 2001 Ford F 150 849.17 $2,890.41 $3.40 Gap Vax 1,205.30 $4,377.78 $3.63 No. Vehicles No./Year Total/Year Cost Each Total Amt. Camera Van 101.89 $356.06 $3.49 OIL CHANGES 5 4 20 $50 $1,000 Ford F 350 Ext. Cab Dually 1,222.21 $4,117.16 $3.37 OIL- GAP VAX 1 1 1 $1,200 $1,200 2011 Ford F 150 Ext. Cab 379.90 $1,288.04 $3.39 INSPECTIONS 5 1 5 $50 $250 Portable Generator 300.00 $1,080.00 $3.60 Generator Maintenance $650 41 kw Generator @ Lift Station #1 500.00 $1,800.00 $3.60 AVERAGE:4558.47 $15,909.45 $3.50 10% Increase 5014.32 $19,297 $3.85 Total Fuel and Lube:$22,397 Fire Department Vehicle U681 289.05 $964.90 $3.34 Vehicle Q681 496.30 $1,805.75 $3.64 No. Vehicles No./Year Total/Year Cost Each Total Amt. Vehicle BRUS 681- Ford F-450 142.20 $519.59 $3.65 OIL CHANGES 3 1 3 $50 $150 Vehicle ENG 681- Pierce 2007 1,347.30 $4,904.38 $3.64 INSPECTIONS 5 1 5 $50 $250 Vehicle F Chief Exped 2009 372.19 $1,252.65 $3.37 AVERAGE:2647.04 $9,447.27 $3.53 10% Increase 2911.74 $11,298 $3.88 Total Fuel and Lube:$11,698 29 TAX WORKSHEET TOTAL FY 13 TAXABLE VALUES AND ESTIMATED REVENUES FROM AD VOLOREM TAX $0.13339 FIRE TAX/ASSESSMENT RATE NET TAX VALUE TARRANT COUNTY:294,553,622 TAX RATE FY 2013: 0.10400 DENTON COUNTY:766,998,140 DENTON CO. PID:349,570,865 REQUIRED REVENUE TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 FIRE Vals/100 =14,111,226.27 TOTAL FY 14 FY 2014 Tax/Assess Rate =0.08738 $0.13339 1,233,000 Revenue from MUD =927,555$ Revenue from PID =305,445$ Total:1,233,000$ I&S TAX RATE NET TAX VALUE TARRANT COUNTY:294,553,622 TAX RATE FY 2013: 0.01950 DENTON COUNTY:766,998,140 REQUIRED REVENUE TAX RATE = REQUIRED REVENUE/TOTAL VALS/100 I&S Vals/100 =10,615,517.62 FY 2014 Tax/Assess Rate =0.03666 389,216 Revenue from MUD =389,216$ Revenue from PID =-$ Total:389,216$ O&M TAX RATE NET TAX VALUE TARRANT COUNTY:294,553,622 TAX RATE FY 2013: $0.00989 DENTON COUNTY:766,998,140 REQUIRED REVENUE TAX RATE = REQUIRED REVENUE/TOTAL VALS/100 O&M Vals/100 =10,615,517.62 FY 2014 Tax/Assess Rate =0.00935 99,250 Revenue from MUD =99,250$ Revenue from PID =-$ Total:99,250$ 30 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.2%0.1%7.3%0.2%8.3%0.3%9.2%0.4%11.0%0.6%9.3%0.5%7.4%0.2%5.7%0.1%4.8%0.0%4.9%0.0%3.6%0.0%4.6%0.1% 2,000 to 2,999 3.3%0.4%5.5%0.9%5.8%1.1%5.6%1.2%7.8%2.0%6.8%1.7%3.7%0.6%3.1%0.3%1.5%0.1%1.5%0.1%1.3%0.1%1.8%0.1% 3,000 to 3,999 4.8%1.0%7.9%1.9%8.4%2.5%8.8%2.9%11.3%4.3%9.9%3.7%5.1%1.2%3.7%0.6%1.6%0.2%1.5%0.2%1.2%0.1%2.1%0.2% 3,000 to 3,999 5.6%1.5%9.5%3.1%10.7%4.2%11.2%4.9%13.3%6.8%11.0%5.3%6.2%1.9%4.4%1.0%1.8%0.3%1.6%0.2%1.1%0.1%2.3%0.3% 4,000 to 4,999 5.4%1.8%8.2%3.3%10.4%5.0%10.9%5.9%12.1%7.7%9.7%5.7%6.1%2.3%4.6%1.3%1.8%0.3%1.8%0.3%1.2%0.2%2.2%0.4% 5,000 to 5,999 5.1%2.0%7.5%3.5%9.1%5.3%10.2%6.5%10.2%7.8%7.9%5.3%6.4%2.9%4.7%1.6%1.8%0.4%1.7%0.4%1.1%0.2%2.5%0.6% 6,000 to 6,999 5.1%2.3%7.2%4.0%7.5%5.1%8.5%6.4%7.5%6.7%6.4%4.9%5.8%3.0%4.2%1.7%2.0%0.5%1.8%0.5%1.2%0.2%2.3%0.6% 7,000 to 7,999 4.5%2.3%5.4%3.4%6.1%4.7%6.9%5.9%5.9%6.0%5.2%4.3%5.7%3.4%4.0%1.8%2.3%0.7%2.0%0.6%1.4%0.3%2.4%0.7% 8,000 to 8,999 4.3%2.3%4.5%3.1%5.2%4.5%5.2%5.0%4.2%4.8%4.5%4.0%5.2%3.4%4.4%2.2%2.0%0.7%2.5%0.8%1.2%0.3%2.5%0.9% 9,000 to 13,999 3.8%2.3%4.0%3.1%4.1%3.8%4.5%4.8%3.4%4.4%3.7%3.5%4.7%3.4%4.1%2.3%2.4%0.9%2.2%0.8%1.3%0.3%2.5%0.9% 14,000 to 18,999 16.7%12.2%14.3%13.6%11.9%14.0%10.3%13.6%7.3%11.4%11.6%12.9%17.6%16.0%17.5%12.4%13.4%6.3%13.1%6.1%7.6%2.7%13.9%6.9% 19,000 to 23,999 12.3%11.5%7.4%9.7%5.0%8.1%3.5%6.6%2.3%5.1%5.9%8.7%11.6%14.2%14.0%13.5%14.6%9.5%14.5%9.2%10.2%5.0%14.7%9.9% 24,000 to 28,999 7.7%8.8%4.0%6.6%2.5%5.3%1.6%3.7%0.9%2.6%3.0%5.5%5.7%8.7%9.5%11.5%13.0%10.7%12.9%10.3%11.9%7.5%13.1%11.1% 29,000 to 33,999 5.1%7.0%1.9%3.9%1.3%3.2%0.7%2.1%0.5%1.6%1.5%3.3%2.9%5.3%5.6%8.2%10.6%10.7%10.1%9.7%11.4%8.6%9.6%9.8% 34,000 to 38,999 3.2%5.1%1.5%3.6%0.7%2.2%0.6%1.9%0.3%1.2%0.8%2.5%1.7%3.5%3.2%5.6%7.9%9.4%8.0%9.0%9.9%8.8%6.7%8.0% 39,000 to 43,999 1.6%3.1%0.7%1.9%0.4%1.4%0.3%1.1%0.2%1.1%0.5%1.4%0.9%2.3%1.8%3.5%5.4%7.3%5.5%7.0%7.7%7.8%4.6%6.3% 44,000 to 48,999 0.9%1.9%0.5%1.5%0.3%1.2%0.2%0.9%0.2%1.1%0.3%0.9%0.6%1.8%1.3%2.8%3.6%5.6%3.5%5.0%6.1%7.0%3.1%4.7% 49,000 to 58,999 0.7%1.7%0.3%1.0%0.2%1.1%0.1%0.6%0.1%0.4%0.2%0.9%0.4%1.2%0.8%2.1%2.3%4.0%2.8%4.5%4.5%5.7%2.2%3.7% 59,000 to 68,999 0.9%2.6%0.5%2.0%0.4%2.1%0.2%1.4%0.3%2.1%0.3%1.7%0.5%1.9%0.8%2.2%2.6%5.1%2.7%4.8%6.1%8.9%2.4%4.8% 69,000 +2.8%30.0%2.1%29.7%1.7%24.9%1.4%24.1%1.1%22.2%1.5%23.3%1.7%22.9%2.6%25.3%4.5%27.6%5.5%30.5%10.0%36.1%4.5%29.8% 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 8.0%5.7%4.6%4.0%3.5%4.6%6.3%8.3%12.5%13.2%16.9%12.4%100.0% MONTH Usage Groups TOTAL 3 YEAR AVERAGE PERCENT USE October November December January February March July August September 31 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) CATEGORY February March July August SeptemberWATER USE October November December January MONTHLY RETAIL CUSTOMER AND WATER USE BY CATEGORY 2009 2009 2009 2010 2010 2010 2010 2010 2010 2010 2010 2010 32 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) CATEGORY February March July August SeptemberWATER USE October November December January MONTHLY RETAIL CUSTOMER AND WATER USE BY CATEGORY 2010 2010 2010 2011 2011 2011 2011 2011 2011 2011 2011 2011 33 Year: FY 2012 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 172 61,000 261 99,000 314 105,000 409 175,000 381 149,000 377 144,000 310 108,000 210 58,000 195 45,000 200 32,000 118 31,000 189 75,000 2,000 to 2,999 67 134,000 187 374,000 198 396,000 273 546,000 282 564,000 254 508,000 171 342,000 87 174,000 51 102,000 40 80,000 41 82,000 66 132,000 3,000 to 3,999 100 300,000 245 735,000 268 804,000 398 1,194,000 380 1,140,000 370 1,110,000 267 801,000 75 225,000 67 201,000 41 123,000 46 138,000 88 264,000 4,000 to 4,999 105 420,000 292 1,168,000 328 1,312,000 478 1,912,000 484 1,936,000 446 1,784,000 297 1,188,000 88 352,000 61 244,000 52 208,000 35 140,000 81 324,000 5,000 to 5,999 90 450,000 234 1,170,000 381 1,905,000 435 2,175,000 419 2,095,000 370 1,850,000 275 1,375,000 107 535,000 66 330,000 56 280,000 48 240,000 86 430,000 6,000 to 6,999 112 672,000 243 1,458,000 322 1,932,000 348 2,088,000 377 2,262,000 339 2,034,000 267 1,602,000 102 612,000 83 498,000 36 216,000 35 210,000 89 534,000 7,000 to 7,999 101 707,000 227 1,589,000 278 1,946,000 285 1,995,000 270 1,890,000 257 1,799,000 226 1,582,000 87 609,000 79 553,000 49 343,000 43 301,000 84 588,000 8,000 to 8,999 115 920,000 177 1,416,000 245 1,960,000 198 1,584,000 224 1,792,000 221 1,768,000 208 1,664,000 107 856,000 90 720,000 45 360,000 58 464,000 79 632,000 9,000 to 9,999 130 1,170,000 171 1,539,000 193 1,737,000 148 1,332,000 169 1,521,000 171 1,539,000 186 1,674,000 149 1,341,000 90 810,000 69 621,000 48 432,000 103 927,000 10,000 to 14,999 120 1,200,000 155 1,550,000 168 1,680,000 142 1,420,000 136 1,360,000 152 1,520,000 176 1,760,000 117 1,170,000 99 990,000 61 610,000 64 640,000 90 900,000 15,000 to 19,999 655 8,559,000 557 7,111,000 474 5,945,000 296 3,701,000 330 4,144,000 421 5,321,000 605 7,735,000 631 8,264,000 544 7,075,000 402 5,296,000 364 4,738,000 544 7,136,000 20,000 to 24,999 593 10,624,000 323 5,792,000 199 3,540,000 113 1,978,000 101 1,800,000 182 3,238,000 379 6,714,000 644 11,566,000 576 10,398,000 526 9,517,000 497 8,965,000 608 10,928,000 25,000 to 29,999 383 8,799,000 188 4,312,000 116 2,631,000 54 1,223,000 49 1,114,000 77 1,725,000 162 3,710,000 489 11,217,000 496 11,325,000 535 12,294,000 533 12,243,000 512 11,781,000 30,000 to 34,999 276 7,626,000 104 2,885,000 40 1,108,000 16 440,000 23 648,000 30 848,000 65 1,813,000 312 8,664,000 366 10,192,000 441 12,356,000 464 12,974,000 390 10,892,000 35,000 to 39,999 192 6,283,000 68 2,217,000 25 818,000 15 482,000 13 421,000 21 698,000 39 1,284,000 181 5,933,000 299 9,798,000 360 11,863,000 379 12,457,000 244 7,998,000 40,000 to 44,999 92 3,509,000 33 1,244,000 14 533,000 8 302,000 8 302,000 12 448,000 26 982,000 124 4,693,000 181 6,824,000 250 9,476,000 273 10,389,000 183 6,928,000 45,000 to 49,999 47 2,003,000 26 1,117,000 10 434,000 7 302,000 10 433,000 8 340,000 13 563,000 87 3,723,000 118 5,056,000 154 6,596,000 211 9,072,000 115 4,927,000 50,000 to 59,999 36 1,718,000 13 624,000 9 432,000 2 95,000 1 49,000 5 244,000 14 669,000 48 2,285,000 96 4,590,000 155 7,425,000 152 7,287,000 76 3,644,000 60,000 to 69,999 48 2,640,000 15 832,000 17 934,000 5 277,000 12 694,000 7 392,000 13 724,000 45 2,470,000 98 5,358,000 135 7,421,000 164 8,993,000 90 4,918,000 70,000 +124 23,627,000 79 14,533,000 59 8,751,000 47 7,951,000 38 6,523,000 45 7,476,000 57 9,769,000 115 17,109,000 173 29,707,000 241 37,115,000 301 44,212,000 153 26,526,000 TOTAL 3,558 81,422,000 3,598 51,765,000 3,658 38,903,000 3,677 31,172,000 3,707 30,837,000 3,765 34,786,000 3,756 46,059,000 3,805 81,856,000 3,828 104,816,000 3,848 122,232,000 3,874 134,008,000 3,870 100,484,000 WATER USE PER METER 22,884 14,387 10,635 8,478 8,319 9,239 12,263 21,513 27,381 31,765 34,592 25,965 PER MONTH (GALLONS) MONTHLY RETAIL CUSTOMER AND WATER USE BY CATEGORY 2011 2011 2011 2012 2012 2012 2012 2012 2012 2012 2012 2012 SeptemberWATER USE October November December January CATEGORY February March July August 34 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 TOTAL 2010 2010 2010 2010 WATER USE October November December January February March July August September CATEGORY PERCENTAGE USE BY CATEGORY 2009 2009 2009 2010 2010 2010 2010 2010 35 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 TOTAL 2011 2011 2011 2011 WATER USE October November December January February March July August September CATEGORY PERCENTAGE USE BY CATEGORY 2010 2010 2010 2011 2011 2011 2011 2011 36 Year: FY 2012 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 4.8%0.1%7.3%0.2%8.6%0.3%11.1%0.6%10.3%0.5%10.0%0.4%8.3%0.2%5.5%0.1%5.1%0.0%5.2%0.0%3.0%0.0%4.9%0.1% 2,000 to 2,999 1.9%0.2%5.2%0.7%5.4%1.0%7.4%1.8%7.6%1.8%6.7%1.5%4.6%0.7%2.3%0.2%1.3%0.1%1.0%0.1%1.1%0.1%1.7%0.1% 3,000 to 3,999 2.8%0.4%6.8%1.4%7.3%2.1%10.8%3.8%10.3%3.7%9.8%3.2%7.1%1.7%2.0%0.3%1.8%0.2%1.1%0.1%1.2%0.1%2.3%0.3% 4,000 to 4,999 3.0%0.5%8.1%2.3%9.0%3.4%13.0%6.1%13.1%6.3%11.8%5.1%7.9%2.6%2.3%0.4%1.6%0.2%1.4%0.2%0.9%0.1%2.1%0.3% 5,000 to 5,999 2.5%0.6%6.5%2.3%10.4%4.9%11.8%7.0%11.3%6.8%9.8%5.3%7.3%3.0%2.8%0.7%1.7%0.3%1.5%0.2%1.2%0.2%2.2%0.4% 6,000 to 6,999 3.1%0.8%6.8%2.8%8.8%5.0%9.5%6.7%10.2%7.3%9.0%5.8%7.1%3.5%2.7%0.7%2.2%0.5%0.9%0.2%0.9%0.2%2.3%0.5% 7,000 to 7,999 2.8%0.9%6.3%3.1%7.6%5.0%7.8%6.4%7.3%6.1%6.8%5.2%6.0%3.4%2.3%0.7%2.1%0.5%1.3%0.3%1.1%0.2%2.2%0.6% 8,000 to 8,999 3.2%1.1%4.9%2.7%6.7%5.0%5.4%5.1%6.0%5.8%5.9%5.1%5.5%3.6%2.8%1.0%2.4%0.7%1.2%0.3%1.5%0.3%2.0%0.6% 9,000 to 9,999 3.7%1.4%4.8%3.0%5.3%4.5%4.0%4.3%4.6%4.9%4.5%4.4%5.0%3.6%3.9%1.6%2.4%0.8%1.8%0.5%1.2%0.3%2.7%0.9% 10,000 to 14,999 3.4%1.5%4.3%3.0%4.6%4.3%3.9%4.6%3.7%4.4%4.0%4.4%4.7%3.8%3.1%1.4%2.6%0.9%1.6%0.5%1.7%0.5%2.3%0.9% 15,000 to 19,999 18.4%10.5%15.5%13.7%13.0%15.3%8.1%11.9%8.9%13.4%11.2%15.3%16.1%16.8%16.6%10.1%14.2%6.7%10.4%4.3%9.4%3.5%14.1%7.1% 20,000 to 24,999 16.7%13.0%9.0%11.2%5.4%9.1%3.1%6.3%2.7%5.8%4.8%9.3%10.1%14.6%16.9%14.1%15.0%9.9%13.7%7.8%12.8%6.7%15.7%10.9% 25,000 to 29,999 10.8%10.8%5.2%8.3%3.2%6.8%1.5%3.9%1.3%3.6%2.0%5.0%4.3%8.1%12.9%13.7%13.0%10.8%13.9%10.1%13.8%9.1%13.2%11.7% 30,000 to 34,999 7.8%9.4%2.9%5.6%1.1%2.8%0.4%1.4%0.6%2.1%0.8%2.4%1.7%3.9%8.2%10.6%9.6%9.7%11.5%10.1%12.0%9.7%10.1%10.8% 35,000 to 39,999 5.4%7.7%1.9%4.3%0.7%2.1%0.4%1.5%0.4%1.4%0.6%2.0%1.0%2.8%4.8%7.2%7.8%9.3%9.4%9.7%9.8%9.3%6.3%8.0% 40,000 to 44,999 2.6%4.3%0.9%2.4%0.4%1.4%0.2%1.0%0.2%1.0%0.3%1.3%0.7%2.1%3.3%5.7%4.7%6.5%6.5%7.8%7.0%7.8%4.7%6.9% 45,000 to 49,999 1.3%2.5%0.7%2.2%0.3%1.1%0.2%1.0%0.3%1.4%0.2%1.0%0.3%1.2%2.3%4.5%3.1%4.8%4.0%5.4%5.4%6.8%3.0%4.9% 50,000 to 59,999 1.0%2.1%0.4%1.2%0.2%1.1%0.1%0.3%0.0%0.2%0.1%0.7%0.4%1.5%1.3%2.8%2.5%4.4%4.0%6.1%3.9%5.4%2.0%3.6% 60,000 to 69,999 1.3%3.2%0.4%1.6%0.5%2.4%0.1%0.9%0.3%2.3%0.2%1.1%0.3%1.6%1.2%3.0%2.6%5.1%3.5%6.1%4.2%6.7%2.3%4.9% 70,000 +3.5%29.0%2.2%28.1%1.6%22.5%1.3%25.5%1.0%21.2%1.2%21.5%1.5%21.2%3.0%20.9%4.5%28.3%6.3%30.4%7.8%33.0%4.0%26.4% 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 2011 2011 2011 2012 2012 2012 2012 2012 TOTAL 2012 2012 2012 2012 WATER USE October November December January February March July August September CATEGORY 37