The URL can be used to link to this page

Home My WebLink AboutFY 2015 TCMUD 1 Approved Budget1 General Fund Fire Fund Debt Service Fund Revenue 8,067,772 Revenue 27,950 Revenue 573,842 FY 2015 Tax Collections 167,857 FY 2015 Tax Collections 872,859 FY 2015 Tax Collections 466,019 FY 2015 PID Surcharges 133,997 FY 2015 PID Assessment 357,462 Reserve (PID Fees/Other)100,000 Reserve Funds 74,706 Reserve Funds 125,670 Total Revenue 8,444,333 Total Revenue 1,383,940 Total Revenue 1,139,861 Water Expense 5,386,025 Fire Expense 1,383,940 Debt Service Expense 1,137,936 Wastewater Expense 1,462,117 Board of Directors Expense 22,881 Administration Expense 1,287,018 Non-Departmental Expense 286,291 Total Expense 8,444,334 Total Expense 1,383,940 Total Expense 1,137,936 Net Budget Surplus/Deficit -1 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 1,925 2015 Property Value Summary Tax Rate Summary MUD Tarrant Co.294,312,465 2014 2015 MUD Denton Co.835,270,435 O&M (General Fund) Tax 0.00935 0.01486 PID 462,597,909 I & S (Debt Service) Tax 0.03666 0.04126 Total Value:1,592,180,809 Fire Tax 0.08738 0.07727 Total Tax Rate:0.13339 0.13339 Increase/Decrease:0.00000 PID Fire Assessment Rate 0.08738 0.07727 Reduction:-0.01011 Budget Summary TROPHY CLUB M.U.D. NO. 1 FY 2015 BUDGET SEPTEMBER 16, 2014 Trophy Club MUD No.1 FY 2015 Budget 09/16/14 2 GENERAL FUND Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2015 thru 6/30/14 Comments General Fund Revenues 135-40000-000-000 Property Taxes 99,250 99,250 167,857 98,185 SEE SCHEDULE TAX_ASSESS 135-40002-000-000 Property Taxes/Delinquent 0 0 0 130 135-40015-000-000 Property Taxes/P & I 900 900 900 514 135-40025-000-000 PID Surcharges 0 0 133,997 SEE SCHEDULE TAX_ASSESS 135-43215-000-000 Insurance Settlement 0 0 0 82 135-47000-000-000 Water 3,749,310 3,749,310 5,286,045 2,055,705 SEE SCHEDULE GF-D 135-47005-000-000 Sewer 1,708,321 1,708,321 2,270,982 1,393,288 SEE SCHEDULE GF-E 135-47025-000-000 Penalties 64,522 64,522 63,416 35,858 SEE SCHEDULE GF-D 135-47030-000-000 Service Charges (Disconnect Fees)9,075 9,075 8,000 6,827 SEE SCHEDULE GF-D 135-47035-000-000 Plumbing Inspections 1,200 2,000 2,000 1,950 135-47045-000-000 Sewer Inspections 4,400 5,000 5,000 6,150 135-47070-000-000 TCCC Effluent Charges 79,586 79,586 86,815 38,402 SEE SCHEDULE GF-E 135-48005-000-000 Utility Fees 582,109 582,109 184,000 259,900 SEE SCHEDULE GF-D 135-49010-000-000 Interest Income 4,800 4,800 5,000 4,531 135-49016-000-000 Cell Tower Revenue 10,164 10,164 10,164 8,195 NEW CONTRACT UNDER NEGOTIATION; INCREASE NOT REQUESTED BUT REMOVAL OF UNUSED EQUIPMENT. 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 227 WWTP AND COLLECTION BARN 135-49035-000-000 Prior Year Reserves 0 880,000 0 0 135-49036-000-000 GASB Reserves 8,964 8,964 74,706 0 SEE SCHEDULE GF-L; GASB RESERVES FOR SCHEDULED COMPUTER REPLACEMENTS 135-49075-000-000 Oversize Meter Reimbursement 84,000 84,000 84,000 64,346 135-49900-000-000 Miscellaneous Income 3,000 3,000 54,000 71,976 MOSTLY INTEREST DUE ON PID UTILITY FEES ($70K RECEIVED FY 14 AND $51K EXPECTED FY 15) 135-49901-000-000 Records Management Revenue 100 100 100 36 135-49903-000-000 Recovery of Prior Year Expense 0 4,087 0 4,087 135-49905-000-000 Gas Well Revenue 885 885 0 0 Total 6,417,937 7,303,424 8,444,333 4,055,639 General Fund Expenses Water & Distribution 135-50005-010-000 Salaries & Wages 287,709 287,709 301,101 196,217 SEE SCHEDULE GF-H 135-50010-010-000 Overtime 13,391 16,391 19,500 14,208 SEE SCHEDULE GF-H 135-50016-010-000 Longevity 4,905 4,905 5,343 4,905 SEE SCHEDULE GF-H 135-50017-010-000 Certification 5,100 5,100 4,800 3,150 SEE SCHEDULE GF-H 135-50020-010-000 Retirement 27,847 27,847 29,349 19,974 SEE SCHEDULE GF-J 135-50026-010-000 Medical Insurance 48,334 48,334 44,988 29,821 SEE SCHEDULE GF-I (Updated with Board approved plan rates) 135-50027-010-000 Dental Insurance 3,932 3,932 3,288 2,175 SEE SCHEDULE GF-I 135-50028-010-000 Vision Insurance 873 873 834 533 SEE SCHEDULE GF-I 135-50029-010-000 Life Insurance & Other 3,306 3,306 3,074 1,898 SEE SCHEDULE GF-I 135-50030-010-000 Social Security Taxes 19,289 19,289 21,135 13,809 SEE SCHEDULE GF-H 135-50035-010-000 Medicare Taxes 4,511 4,511 4,943 3,230 SEE SCHEDULE GF-H 135-50040-010-000 Unemployment Taxes 54 1,244 1,242 1,244 SEE SCHEDULE GF-H 135-50045-010-000 Workman's Compensation 9,829 9,829 16,020 7,222 TML INVOICE AMOUNT 135-50060-010-000 Pre-emp Physicals/Testing 200 350 1,000 297 NEW $75 DOT PHYSICAL FEE 135-50070-010-000 Employee Relations 300 300 300 181 135-55005-010-000 Engineering 3,000 6,000 10,000 0 135-55080-010-000 Maintenance & Repairs 50,000 61,000 71,242 50,677 ADDITIONAL MAINTENANCE FY 15 (REDUCED BY $3758 TO HELP FUND CAPITAL PROJECTS) 135-55090-010-000 Vehicle Maintenance 5,000 5,000 8,000 3,013 ADDITIONAL VEHICLE MAINTENANCE FY 15 Trophy Club MUD No.1 FY 2015 Budget 09/16/14 3 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2015 thru 6/30/14 Comments 135-55105-010-000 Maintenance-Heavy Equipment 3,500 2,500 3,500 248 ADDITIONAL MAINTENANCE-HEAVY EQUIPMENT FY 15 135-55135-010-000 Lab Analysis - MUD 5,500 5,500 5,500 3,281 TCEQ ESTIMATE + MONTHLY BAC T & REDUCED FOR PID PORTION 135-60010-010-000 Communications/Pagers/Mobiles 4,913 4,913 4,913 3,448 135-60020-010-000 Electricity 162,160 155,160 170,765 87,658 SEE SCHEDULE GF-K 135-60066-010-000 Publications/Books/Subscripts 500 2,538 500 2,716 135-60070-010-000 Dues & Memberships 150 300 500 289 135-60080-010-000 Schools & Training 4,184 1,500 4,138 1,671 SEE SCHEDULE GF-G 135-60090-010-000 Safety Program 400 0 400 0 135-60100-010-000 Travel & per diem 1,450 279 1,500 173 SEE SCHEDULE GF-G 135-60105-010-000 Rent/Lease Equipment 500 500 1,500 60 EMERGENCY EQUIPMENT RENTAL IF NEEDED 135-60135-010-000 TCEQ Fees & Permits - MUD 47,400 47,400 49,275 32,464 REG. ASSESSMENT ($22,500), WATER SYSTEM FEES ($6,775) & NTGW WELL FEES ($20,000) 135-60150-010-000 Wholesale Water 2,338,473 2,338,473 2,928,308 1,145,633 SEE SCHEDULE GF-C 135-60245-010-000 Miscellaneous Expenses 200 200 200 0 135-60280-010-000 Property Maintenance 3,500 3,500 3,500 1,290 135-60285-010-000 Lawn Equipment & Maintenance 250 250 250 0 135-60360-010-000 Furniture/Equipment < $5000 3,500 2,000 3,500 1,664 135-65005-010-000 Fuel & Lube 23,181 22,181 29,173 9,628 SEE SCHEDULE GF-M 135-65010-010-000 Uniforms 3,270 2,500 3,620 1,939 SEE SCHEDULE GF-F 135-65030-010-000 Chemicals 5,000 5,000 7,000 4,491 ADDITIONAL CHEMICALS USE 135-65035-010-000 Small Tools 1,200 1,200 1,200 491 135-65040-010-000 Safety Equipment 1,000 1,000 1,000 345 135-65050-010-000 Meter Expense 143,550 143,550 161,500 76,145 ADDED $18,000 SOLANA CHANGE OUT -COMPLETE METER CHANGEOUTS AND NEW METERS 135-69005-010-000 Capital Outlays 44,500 35,681 1,089,006 35,680 SEE SCHEDULE GF-A 135-69006-010-000 Long Term Debt Payment from Water Sales 0 0 0 SEE SCHEDULE GF-B: FUNDS TO TRANSER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS 135-69008-010-000 Short Term Debt-Principal 489,980 489,980 129,000 122,980 SEE SCHEDULE GF-B 135-69009-010-000 Short Term Debt-Interest 19,268 19,268 3,612 11,621 SEE SCHEDULE GF-B 135-69195-010-000 Gasb34/Reserve for Replacement 30,000 0 75,000 0 1/10 MAJOR MAINTENANCE COST TOWN'S ELEVATED STORAGE TANK $45,000 135-69281-010-000 Tank Inspection Contract 106,848 100,848 151,507 100,817 ANNUAL CONTRACT: GST's INCREASED AMOUNT DUE TO INCREASED SIZE; PAX MIXERS AND INSTALLATION 135-55135-010-001 Lab Analysis - PID 1,000 2,000 5,000 2,742 PID PORTION 135-60135-010-001 TCEQ Fees & Permits- PID 0 5,000 5,000 2,496 WATER SYSTEM FEES ($2.15/CONNECTION) AND OTHER Subtotal Water 3,932,956 3,899,140 5,386,025 2,002,522 135-50005-020-000 Salaries & Wages 293,193 293,193 305,744 194,386 SEE SCHEDULE GF-H 135-50010-020-000 Overtime 21,993 21,993 19,500 14,456 SEE SCHEDULE GF-H 135-50016-020-000 Longevity 20,911 5,106 5,617 5,105 SEE SCHEDULE GF-H 135-50017-020-000 Certification 6,600 6,600 6,600 4,950 SEE SCHEDULE GF-H 135-50020-020-000 Retirement 28,930 28,930 29,948 20,480 SEE SCHEDULE GF-J 135-50026-020-000 Medical Insurance 67,139 67,139 61,001 44,483 SEE SCHEDULE GF-I (Updated with Board approved plan rates) 135-50027-020-000 Dental Insurance 4,692 4,692 4,146 2,966 SEE SCHEDULE GF-I 135-50028-020-000 Vision Insurance 972 972 990 675 SEE SCHEDULE GF-I 135-50029-020-000 Life Insurance & Other 3,369 3,369 3,194 2,369 SEE SCHEDULE GF-I 135-50030-020-000 Social Security Taxes 21,247 21,247 21,680 12,564 SEE SCHEDULE GF-H 135-50035-020-000 Medicare Taxes 4,970 4,970 5,070 2,938 SEE SCHEDULE GF-H 135-50040-020-000 Unemployment Taxes 234 1,242 1,242 1,242 SEE SCHEDULE GF-H 135-50045-020-000 Workman's Compensation 9,828 9,828 16,020 7,224 TML INVOICE AMOUNT 135-50060-020-000 Pre-emp Physicals/Testing 150 150 150 63 135-50070-020-000 Employee Relations 550 550 550 296 135-55070-020-000 Independent Labor 1,500 880,000 0 606,302 FY 14 ENGINEERING FEES PAID HERE (PLANT UPGRADES) Wastewater & Collections (For Comparision purposes- Collections for FY 14 has been added to Wastewater FY 14) Trophy Club MUD No.1 FY 2015 Budget 09/16/14 4 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2015 thru 6/30/14 Comments 135-55080-020-000 Maintenance & Repairs 58,801 50,571 58,000 42,164 135-55090-020-000 Vehicle Maintenance 4,000 4,000 3,000 2,665 135-55105-020-000 Maintenance-Heavy Equipment 500 0 500 0 135-55125-020-000 Dumpster Services 52,000 47,000 55,000 41,296 INCREASED COSTS 135-55135-020-000 Lab Analysis 30,000 30,000 25,000 18,786 135-60010-020-000 Communications/Pagers/Mobiles 4,662 4,662 4,662 3,547 135-60020-020-000 Electricity 169,407 159,407 149,292 93,964 SEE SCHEDULE GF-K 135-60066-020-000 Publications/Books/Subscripts 400 400 400 351 135-60070-020-000 Dues & Memberships 250 250 250 0 135-60080-020-000 Schools & Training 4,347 2,547 4,065 1,458 SEE SCHEDULE GF-G 135-60090-020-000 Safety Program 550 800 550 509 135-60100-020-000 Travel & per diem 1,600 1,300 1,600 1,124 SEE SCHEDULE GF-G 135-60105-020-000 Rent/Lease Equipment 11,500 6,500 9,000 300 EMERGENCY EQUIPMENT RENTAL IF NEEDED 135-60135-020-000 TCEQ Fees & Permits 17,150 17,150 17,150 8,919 REG. ASSESSMENT($8,550), ANNUAL FEE ($8,600) 135-60243-020-000 Prior Year Expense 0 3,554 0 3,554 135-60245-020-000 Miscellaneous Expenses 300 300 300 0 135-60285-020-000 Lawn Equipment & Maintenance 500 250 500 0 135-60360-020-000 Furniture/Equipment < $5000 3,000 1,079 0 1,079 135-65005-020-000 Fuel & Lube 37,117 35,347 36,328 17,194 SEE SCHEDULE GF-M 135-65010-020-000 Uniforms 2,792 2,792 2,778 2,252 SEE SCHEDULE GF-F 135-65030-020-000 Chemicals 45,000 33,000 30,000 21,193 135-65035-020-000 Small Tools 2,000 600 2,000 221 135-65040-020-000 Safety Equipment 750 1,250 750 865 135-65045-020-000 Lab Supplies 15,000 15,000 13,000 10,004 135-69005-020-000 Capital Outlays 232,000 114,000 150,000 68,300 SEE SCHEDULE GF-A 135-69007-020-000 Long Term Debt Payment from WW Sales 0 0 357,538 0 SEE SCHEDULE GF-B: FUNDS TO TRANSFER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS 135-69008-020-000 Short Term Debt-Principal 56,011 56,011 56,991 20,020 SEE SCHEDULE GF-B 135-69009-020-000 Short Term Debt-Interest 4,268 4,268 2,011 1,044 SEE SCHEDULE GF-B Subtotal Wastewater 1,240,181 1,942,017 1,462,117 1,281,308 Board of Directors 135-50005-026-000 Salaries & Wages 10,000 10,000 10,000 6,500 135-50030-026-000 Social Security Taxes 620 620 620 403 135-50035-026-000 Medicare Taxes 145 145 145 94 135-50040-026-000 Unemployment Taxes 10 230 230 95 135-50045-026-000 Workman's Compensation 36 36 36 27 135-60066-026-000 Publications/Books/Subscripts 150 150 150 0 135-60070-026-000 Dues & Memberships 500 500 500 35 135-60075-026-000 Meetings 1,200 1,200 1,200 133 135-60080-026-000 Schools & Training 4,000 4,000 4,000 632 135-60100-026-000 Travel & per diem 5,000 5,000 5,000 42 135-60245-026-000 Miscellaneous Expenses 1,000 1,000 1,000 179 Subtotal Board of Directors 22,661 22,881 22,881 8,139 Administration 135-50005-030-000 Salaries & Wages 458,721 458,721 477,578 318,804 SEE SCHEDULE GF-H 135-50010-030-000 Overtime 500 750 1,000 746 SEE SCHEDULE GF-H 135-50016-030-000 Longevity 3,018 3,018 3,283 3,078 SEE SCHEDULE GF-H 135-50020-030-000 Retirement 41,419 41,419 42,840 29,945 SEE SCHEDULE GF-H 135-50026-030-000 Medical Insurance 57,923 57,923 65,015 42,160 SEE SCHEDULE GF-I (Updated with Board approved plan rates) Trophy Club MUD No.1 FY 2015 Budget 09/16/14 5 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2015 thru 6/30/14 Comments 135-50027-030-000 Dental Insurance 5,100 5,100 4,944 3,107 SEE SCHEDULE GF-I 135-50028-030-000 Vision Insurance 1,087 1,087 1,158 737 SEE SCHEDULE GF-I 135-50029-030-000 Life Insurance & Other 4,483 5,500 4,333 3,564 SEE SCHEDULE GF-I 135-50030-030-000 Social Security Taxes 28,659 28,659 30,079 19,543 SEE SCHEDULE GF-I 135-50035-030-000 Medicare Taxes 6,702 6,702 7,422 4,571 SEE SCHEDULE GF-H 135-50040-030-000 Unemployment Taxes 63 1,449 1,449 1,449 SEE SCHEDULE GF-H 135-50045-030-000 Workman's Compensation 1,575 1,575 1,636 1,158 TML INVOICE AMOUNT 135-50060-030-000 Pre-emp Physicals/Testing 200 200 500 0 135-50070-030-000 Employee Relations 5,000 5,000 5,000 2,733 135-55030-030-000 Software & Support 59,698 59,698 75,588 42,387 SEE SCHEDULE GF-L 135-55070-030-000 Independent Labor 7,700 7,000 8,000 8,400 $3000 IT -SEE SCHEDULE GF-L 135-55080-030-000 Maintenance & Repairs 4,500 4,500 4,500 428 $3000 ADDED FOR NEW LIGHT FIXTURES THAT ARE BROKEN AND REPAIR OF AV ROOM 135-55100-030-000 Building Maint & Supplies 6,500 6,500 6,500 2,587 135-55120-030-000 Cleaning Services 19,140 19,140 8,100 12,760 CLEANING FOR TCMUD BUILDING ONLY 135-55160-030-000 Professional Outside Services 15,000 10,000 58,000 0 M3 IT SERVICES $48,000 -SEE SCHEDULE GF-L 135-55161-030-000 Town Personnel Contract 77,048 77,048 6,170 77,048 SEE SCHEDULE GF-L 135-55165-030-000 Collection Fees 200 200 200 0 135-55205-030-000 Utility Billing Contract 6,808 6,808 8,200 5,825 COST FOR PRINTING MONTHLY STATEMENTS 135-60005-030-000 Telephone 11,250 11,250 13,360 9,607 INCLUDES $10,860 FOR IT ( WWTP WAS NOT ADDED IN PRIOR YR) AND $2,500 AFTER HOURS ANSWERING SERVICE 135-60010-030-000 Communications/Mobiles 3,589 4,057 4,057 2,665 135-60020-030-000 Electricity 15,171 15,171 14,978 11,834 SEE SCHEDULE GF-K 135-60025-030-000 Water 1,500 1,500 1,500 710 135-60035-030-000 Postage 28,500 28,500 28,500 18,721 135-60040-030-000 Bank Service Charges & Fees 28,330 28,330 32,000 23,394 BANK FEES INCREASING DUE TO MORE ONLINE PAYMENTS 135-60050-030-000 Bad Debt Expense 1,500 6,200 6,200 4,352 135-60055-030-000 Insurance 53,561 53,561 48,751 38,756 TML INVOICE AMOUNT 135-60066-030-000 Publications/Books/Subscripts 1,000 1,000 1,000 401 135-60070-030-000 Dues & Memberships 4,500 4,500 5,000 4,312 135-60075-030-000 Meetings 400 400 400 27 135-60079-030-000 Public Education 0 5,000 5,000 275 135-60080-030-000 Schools & Training 7,500 6,800 10,235 2,849 SEE SCHEDULE GF-G 135-60100-030-000 Travel & per diem 5,000 5,000 5,400 2,409 SEE SCHEDULE GF-G 135-60110-030-000 Physicals/Testing 200 200 200 0 135-60115-030-000 Elections 2,500 2,500 0 3,709 NO ELECTION TO BE HELD IN FY 15 135-60125-030-000 Advertising 2,500 2,500 2,500 589 135-60235-030-000 Security 1,350 1,350 1,350 124 $1350 FOR IT 135-60245-030-000 Miscellaneous Expenses & DM Discretionary 22,870 17,870 17,500 1,956 REDUCED TO FUND CAPITAL IMPROVEMENTS 135-60270-030-000 4th of July Celebration 10,500 10,500 10,000 0 135-60336-030-000 Intergov Trans Out (MUD I&S)0 0 0 0 135-60344-030-000 Intergov Trans Out (Fire Dept.)0 0 0 0 135-60360-030-000 Furniture/Equipment < $5000 2,500 2,500 10,475 2,564 1/2 SCREEN $1800, BOARDROOM CHAIRS $ 4375 ( COST SPLIT WITH TOWN); BINDING MACHINE $1800 135-65010-030-000 Uniforms 1,390 1,390 1,855 999 SEE SCHEDULE GF-F 135-65055-030-000 Hardware IT 13,562 13,562 75,966 7,366 SEE SCHEDULE GF-L REDUCED BY $8,250 135-65085-030-000 Office Supplies 9,100 9,100 9,000 3,560 ALL DEPARTMENTS COMBINED. INCLUDES $371 FOR IT 135-65090-030-000 Printer Supplies & Maintenance 5,732 5,732 4,732 3,652 SEE SCHEDULE GF-L 135-65095-030-000 Maintenance Supplies 2,500 2,500 5,000 2,241 NEW VACUUM AND SMALL CLEANING EQUIPMENT 135-65097-030-000 Vending Machine Supplies 200 200 200 77 VENDING AT WWTP AND COLLECTIONS BARN 135-65105-030-000 Printing 4,000 4,000 4,800 3,424 ADDITIONAL PRINTING FOR CUSTOMER PUBLICATIONS 135-69005-030-000 Capital Outlays 0 0 125,000 0 SEE SCHEDULE GF-A Trophy Club MUD No.1 FY 2015 Budget 09/16/14 6 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2015 thru 6/30/14 Comments 135-69170-030-000 Copier Lease Installments 3,450 3,450 4,236 1,926 SEE SCHEDULE GF-L 135-69195-030-000 Gasb34/Reserve for Replacement IT 0 0 16,329 0 SEE SCHEDULE GF-L Subtotal Administration 1,055,198 1,056,619 1,287,018 733,529 Non Departmental 135-55045-039-000 Legal 131,300 347,126 250,000 264,211 135-55055-039-000 Auditing 21,840 21,840 22,491 21,200 135-55060-039-000 Appraisal 10,000 10,000 10,000 8,158 135-55065-039-000 Tax Admin Fees 3,800 3,800 3,800 2,451 Subtotal Non Departmental 166,940 382,767 286,291 296,021 Total General Fund Revenues 6,417,937 7,303,424 8,444,333 Total General Fund Expenses 6,417,937 7,303,424 8,444,333 Net Budget Surplus (Deficit)0 0 0 Trophy Club MUD No.1 FY 2015 Budget 09/16/14 7 FIRE DEPARTMENT Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2015 thru 6/30/14 Revenues 122-40001-000-000 Assessment - Emerg Svcs 305,445 305,445 357,462 309,220 SEE SCHEDULE TAX_ASSESS 122-40003-000-000 Emer Svcs Assessmen/Delinquent 0 0 0 1,581 122-40010-000-000 Property Taxes/MUD Fire 927,555 927,555 872,859 917,179 SEE SCHEDULE TAX_ASSESS 122-40011-000-000 Property Taxes/Fire-Delinquent 0 0 0 1,345 122-40015-000-000 Property Taxes/Assessments P&I 750 750 750 730 122-40020-000-000 Property Taxes/Fire P&I 4,500 4,500 4,500 4,891 122-42014-000-000 Fire Permits/Sprinkler 6,000 6,000 6,000 4,000 122-43400-000-000 Fire Inspections 700 700 700 750 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000 10,000 10,000 0 122-49035-000-000 Prior Year Reserves 0 0 125,670 0 FROM GASB 137-32112-000-000 122-49900-000-000 Miscellaneous Income 6,000 6,000 6,000 6,050 Total 1,260,950 1,260,950 1,383,940 1,245,746 Expenses 122-50005-045-000 Salaries & Wages 455,916 455,916 469,067 327,223 SEE SCHEDULE GF-H 122-50010-045-000 Overtime 44,225 44,225 46,745 25,588 SEE SCHEDULE GF-H 122-50011-045-000 Holiday Pay 13,529 13,529 14,930 13,290 SEE SCHEDULE GF-H 122-50016-045-000 Longevity 4,768 4,768 5,505 4,655 SEE SCHEDULE GF-H 122-50017-045-000 Certification 4,350 4,350 4,800 3,339 SEE SCHEDULE GF-J 122-50020-045-000 Retirement 70,991 70,991 91,396 53,095 SEE SCHEDULE GF-I 122-50026-045-000 Medical Insurance 56,968 56,968 59,169 37,458 SEE SCHEDULE GF-I 122-50027-045-000 Dental Insurance 4,230 4,230 4,390 3,056 SEE SCHEDULE GF-I 122-50028-045-000 Vision Insurance 892 892 811 624 SEE SCHEDULE GF-I 122-50029-045-000 Life Insurance & Other 4,250 4,250 4,030 2,849 SEE SCHEDULE GF-I 122-50030-045-000 Social Security Taxes 32,980 32,980 33,421 21,398 SEE SCHEDULE GF-H 122-50035-045-000 Medicare Taxes 7,713 7,713 7,292 5,003 SEE SCHEDULE GF-H 122-50040-045-000 Unemployment Taxes 2,259 2,259 1,657 1,601 SEE SCHEDULE GF-H 122-50045-045-000 Workman's Compensation 8,708 8,708 8,692 5,965 122-50060-045-000 Pre-employment Physicals/Test 500 500 250 206 122-50075-045-000 Tuition Reimbursement 600 600 300 0 MUD FY 2015 SHARE 122-55030-045-000 Software & Support 8,682 6,834 7,378 0 SEE SCHEDULE GF-L 122-55045-045-000 Legal 5,000 3,391 1,500 -2,506 (YTD amount includes refund from Interpleador filed regarding building) 122-55080-045-000 Maintenance & Repairs 20,472 20,472 18,552 14,710 MOVED CABLE TO ITS OWN ACCOUNT 122-55090-045-000 Vehicle Maintenance 14,850 14,850 12,000 7,024 122-60005-045-000 Telephone 100 100 50 20 122-60010-045-000 Communications/Mobiles 4,237 4,237 5,000 3,430 INCLUDES $1400 DENTON DISPATCH 122-60020-045-000 Electricity/Gas 6,568 9,268 9,026 5,141 SEE SCHEDULE GF-K: 50% PAID BY TOWN 122-60025-045-000 Water 1,500 1,500 1,200 769 50% PAID BY TOWN 122-60026-045-000 Cable 0 0 1,920 0 MOVED CABLE FROM MAINTENANCE & REPAIRS 122-60030-045-000 Rent And/Or Usage 214,279 214,279 211,829 214,279 SEE SCHEDULE FD-B 122-60035-045-000 Postage 100 100 100 37 122-60055-045-000 Insurance 12,111 12,111 12,179 9,125 Trophy Club MUD No.1 FY 2015 Budget 09/16/14 8 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2015 thru 6/30/14 122-60066-045-000 Publications/Books/Subscrips 400 400 200 113 122-60070-045-000 Dues & Memberships 15,180 15,180 15,180 8,412 SEE SCHEDULE FD-A 122-60080-045-000 Schools & Training 4,280 4,280 4,280 4,482 SEE SCHEDULE FD-A 122-60096-045-000 Emergency Management 2,000 2,000 1,400 1,609 122-60100-045-000 Travel & per diem 4,577 4,577 13,577 2,490 SEE SCHEDULE FD-A 122-60110-045-000 Physicals/Testing 2,000 2,000 2,000 0 122-60125-045-000 Advertising 200 0 5,100 200 Volunteer recruitment program advertisements and billing inserts 122-60160-045-000 Programs & Special Projects 4,500 4,500 4,500 1,435 122-60180-045-000 Fire Inspection/Enforcement 1,500 1,500 1,000 249 122-60195-045-000 Flags & Repair 2,000 2,000 2,000 1,540 122-60243-045-000 Prior Year Expense 0 3,457 0 3,457 122-60245-045-000 Miscellaneous Expense 1,000 1,000 1,000 160 122-65005-045-000 Fuel & Lube 11,698 10,198 10,454 6,294 SEE SCHEDULE GF-M 122-65010-045-000 Uniforms 3,360 3,360 2,000 2,785 122-65015-045-000 Protective Clothing 7,600 7,600 5,200 5,954 122-65030-045-000 Chemicals 1,000 500 200 420 122-65035-045-000 Small Tools 2,500 2,500 2,500 694 122-65055-045-000 Hardware 0 0 9,000 0 SEE SCHEDULE GF-L REPLACEMENT LAPTOPS FOR FIRE-COST SPLIT 50% WITH TOWN 122-65085-045-000 Office Supplies 1,000 500 500 233 122-65105-045-000 Printing 100 100 548 0 SEE SCHEDULE GF-L /INCLUDES IT PRINTING COSTS AND OUTSIDE PRINTING 122-69008-045-000 Short Term Debt -Principal 70,000 70,000 158,262 0 SEE SCHEDULE GF-B 122-69009-045-000 Short Term Debt -Interest 3,031 3,031 50,000 1,516 SEE SCHEDULE GF-B 122-69050-045-000 Radios 34,200 34,200 23,500 32,693 CONTINUATION OF RADIO REPLACEMENTS 122-69195-045-000 GASB34/Reserve for Replacement 67,647 67,647 17,950 0 122-69255-045-000 Airpacks 20,400 20,400 20,400 982 REPLACEMENT PROGRAM FOR NFPA STANDARDS; 4 REPLACED PER YEAR ON 3 YEAR CYCLE Total 1,260,950 1,260,950 1,383,940 833,096 Total Fire Revenues 1,260,950 1,260,950 1,383,940 Total Fire Expenses 1,260,950 1,260,950 1,383,940 Net Budget Surplus (Deficit)0 0 0 Trophy Club MUD No.1 FY 2015 Budget 09/16/14 9 DEBT SERVICE FUND (I&S) Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2015 thru 6/30/14 Comments Debt Service Revenues 533-40000-000-000 Property Taxes 389,216 389,216 466,019 384,970 533-40002-000-000 Property Taxes/Delinquent 2,500 2,500 2,500 459 533-40015-000-000 Property Taxes/P & I 1,600 1,600 1,600 2,050 533-48005-000-000 Reserve Funds (PID Utility Fees/Other)16,525 16,525 100,000 0 533-48010-000-000 Water Sales Revenue Transfer for Debt 0 0 0 533-48015-000-000 WW Sales Revenue Transfer for Debt 0 0 357,538 Revenue Debt Payment + PID Surcharge for I&S 533-49010-000-000 Interest Income 375 375 375 70 533-49015-000-000 Lease/Rental Income 214,279 214,279 211,829 214,279 See Schedule FD-B 533-49110-000-000 Premium on Bonds Sold 0 0 0 0 Total 624,495 624,495 1,139,861 601,828 Debt Service Expenses 533-70005-051-000 Paying Agent Fee 2,300 2,300 2,550 1,000 Increase in Administration Fee 533-70025-051-000 Bond Interest Expense-Tax 197,195 197,195 403,103 103,166 See Schedule GF-B (Long Term Debt) 533-70035-051-000 Bond Principal Payment-Tax 425,000 425,000 440,000 0 See Schedule GF-B (Long Term Debt) 533-70040-051-000 Bond Interest Expense-Rev Bonds 0 0 292,283 See Schedule GF-B (Long Term Debt) 533-70045-051-000 Bond Principal Payment-Rev Bonds 0 0 0 See Schedule GF-B (Long Term Debt) Total 624,495 624,495 1,137,936 104,166 Total Debt Service Fund Revenues 624,495 624,495 1,139,861 Total Debt Service Fund Expenses 624,495 624,495 1,137,936 Transfer of Funds to (+) from (-) Cash on Hand 0 0 0 Net Budget Surplus (Deficit)0 0 1,925 10 SCHEDULE FD-A Fire Department Dues, Training, and Travel Account Description FY 2015 Budget Detail 122-60070 Dues & Memberships Texas Commission on Fire Protection $1,445 $85.00 per FF X 17 Annual fee TCFP Training Facility $170 Annual fee SFFMA (Volunteer) $275 $100 per dept, $35 per FF (5) NEFDA $12,745 Annual fee increase due to equipment replacement Denton County Chiefs $280 Annual fee Tarrant County Chiefs $100 Annual fee International Fire Chiefs $165 Annual fee TOTAL:$15,180 122-60080 Schools and Training TCCC Live Fire Training $700 TCFP Annual Certification classes TCCC / NFA $680 8 classes @ $85.00 TCFP / TEEX / NFA on site classes $500 Instructor cost Haz-Mat Certification $700 (2) staff cert Conference regestration $1,700 SFR / Homeland / FMC / FDIC TOTAL:$4,280 122-60100 Travel and Per Diem Southwest Fire / Rescue (Chief Conf)$720 Chief or training officer conference. Fire Truck Inspection Visits to Manufacturer $9,000 3 inspection visits for up to 3 persons Homeland Security Conference $1,424 EMC and Training officer (2) Texas Fire Marshal Conference $712 Fire Marshal Fire Department Instructor Conf (FDIC) International Fire Chiefs $1,721 Chief or Training Officer TOTAL:$13,577 11 SCHEDULE FD-B RENT CALCULATION FOR FIRE STATION FY Bond Payment Reimburse Reserve ($933,700)*Total Rent 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 FY 15 CAPITAL OUTLAYS WATER - PURCHASES WATER - MAINTENANCE & REPAIRS ADMINISTRATION - PURCHASES DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT GPS System 10,100 10 Valves $6500 each 65,000 SUV 25,000 Backhoe 0 Ft. Worth Water Line 650,000 1 ton Truck 45,000 12 inch valve @ water plant 10,000 1/2 ton Truck 0 Pin Oak (Streets Project)80,156 Timber Line Ct. (Streets Project)31,250 Pebble Beach ( Streets Project)197,500 Total:55,100 Total:1,033,906 Total:25,000 WASTEWATER - PURCHASES WASTEWATER - MAINTENANCE & REPAIRS ADMINISTRATION - MAINTENANCE & REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT Crane Truck Bed 30,000 Drainage for Lift #2 120,000 Front Office Remodel (UB Booths)100,000 Oakhill Sewer Line Rehab 0 Total:30,000 Total:120,000 Total:100,000 Changes from 8/06/14 draft to fund Streets Projects Reduced Oakhill Sewer Line Rehab -$80,000.00 Reduced Backhoe -$110,000.00 Reduced 1/2 ton truck -$30,000.00 Reduced Fund 135 Water Maintenance & Repairs -$3,758.00 Used previous overage Fund 135 balance from budget 8/19/14 -$95,148.00 Added Pin Oak (Streets Project)$80,156.00 Added Timber Line Ct. (Streets Project)$31,250.00 Added Pebble Beach (Streets Project)$197,500.00 Added funding for Town 4th of July $10,000.00 Net Total $0.00 13 LONG TERM DEBT MUD/PID Paid Par Principle FY 15 Interest 3/01 Interest 9/01 Subtotal Interest Total Maturity Date First Callable Date Project/Reason Series 2010 (Tax)MUD $2,000,000 $70,000 $36,867 $36,867 $73,733 $143,733 9/1/2031 9/1/2020 Trophy Club Fire Station and costs related to the issuance of the Bonds. Series 2012 (Tax)MUD $2,355,000 $195,000 $26,625 $26,625 $53,250 $248,250 9/1/2023 9/1/2020 Refund MUD #2 Unlimited Tax Bonds, 2002 and costs related to the issuance of the Bonds. Series 2013 (Tax)MUD $1,905,000 $175,000 $25,763 $25,763 $51,525 $226,525 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. SUBTOTAL MUD-ONLY TAX BONDS:$6,260,000 $440,000 $89,254 $89,254 $178,508 $618,508 Series 2015 (Tax) MUD/PID $5,765,000 $0 $0 $224,595 $224,595 $224,595 9/1/2035 9/1/2024 Tax Bonds for Wastewater Plant Expansion Issued 10/1/2014 SUBTOTAL ALL MUD/PID TAX BONDS:$5,765,000 $0 $0 $224,595 $224,595 $224,595 SUBTOTAL ALL TAX BONDS:$12,025,000 $440,000 $89,254 $313,849 $403,103 $843,103 Series 2015 (Revenue)$9,230,000 $0 $0 $292,283 $292,283 $292,283 9/1/2035 9/1/2024 Revenue Bonds for Wastewater Plan Expansion- Issued 1/1/2015 SUBTOTAL REVENUE BONDS:$9,230,000 $0 $0 $292,283 $292,283 $292,283 TOTAL ALL BONDS:$21,255,000 $440,000 $89,254 $606,132 $695,386 $1,135,386 SHORT TERM DEBT Original PAR Outstanding Debt Principle FY 15 Interest 3/01 Interest 9/01 Subtotal Interest Total Payoff Date Project/Reason Department Notes Payable $179,955 $35,991 $35,991 $1,423 $0 $1,423 $37,414 8/4/2015 2009 Gap Vax WW 2013 Revenue Note $445,000 $302,000 $150,000 $2,794 $1,406 $4,200 $154,200 9/1/2016 2013 Capital Projects 86% WATER & 14% WW 2015 Fire Truck Lease $1,250,000 $1,250,000 $158,262 $50,000 $0 $50,000 $208,262 1/1/2022 2015 Fire Truck Fire Total:$1,874,955 $1,587,991 $344,253 $54,217 $1,406 $55,623 $399,876 SCHEDULE GF - B DEBT PAYMENTS 14 ANNUALIZE GROWTH IN WATER METERS =3.25% PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2015 =4,334 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,346 22,478 97,683,709 2 NOV 4,358 16,703 72,785,432 3 DEC 4,369 12,442 54,361,355 4 JAN 4,381 9,860 43,198,141 5 FEB 4,393 8,574 37,666,542 6 MAR 4,405 12,110 53,345,067 7 APR 4,417 15,132 66,835,118 8 MAY 4,429 20,045 88,773,695 9 JUN 4,441 26,992 119,865,039 10 JUL 4,453 32,148 143,147,983 11 AUG 4,465 39,309 175,508,956 12 SEP 4,477 30,393 136,067,094 AVERAGE 4,411 20,515 TOTAL 1,089,238,129 CALCULATED AVERAGE WATER USE PER METER PER MONTH =(GALS/METER/MN)20,515 PROJECTED TOTAL NO. OF NEW RETAIL METERS IN FY15 =(METERS)143 Growth Rate Calculation Meters set June 2013 through May 2014:15 per month Growth Rate = Ave. New Meters Set/Total Meters at May 2015 (15*12)/4268 x 100% =4.2% 3.25% recommended Purchased Water Expense (Projected Fort Worth Costs)Purchased Water (gallons):1,089,238,129 Out of District Volumetric Charge $2.100 per 1000 gals $2,287,400 Rate of Use Charge (8.18% Increase)$53,384 per month $640,608 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 1,000 234 89,398 273 111,268 337 157,091 379 168,279 465 228,449 338 144,790 299 113,034 252 81,008 221 89,355 229 224,651 176 35,545 202 189,303 2,000 112 228,127 181 391,845 235 497,358 250 523,099 358 723,307 218 486,537 165 350,631 118 233,619 73 144,711 68 140,605 55 142,717 65 134,222 3,000 136 412,356 249 808,475 310 983,996 363 1,137,686 480 1,450,431 323 1,090,038 227 739,615 129 417,520 87 299,660 57 169,931 51 186,711 79 239,942 4,000 167 709,217 283 1,222,490 389 1,625,282 473 1,959,743 605 2,435,832 407 1,813,662 274 1,182,569 167 710,895 99 431,620 62 273,366 51 235,224 75 318,244 5,000 159 834,844 266 1,428,372 420 2,213,305 480 2,480,943 511 2,581,166 387 2,109,191 261 1,395,923 178 932,972 99 565,568 73 406,928 56 291,562 74 391,305 6,000 155 957,890 267 1,712,453 357 2,250,408 454 2,776,830 433 2,621,307 343 2,227,113 264 1,687,889 174 1,115,897 115 732,669 62 405,870 50 310,326 81 506,546 7,000 166 1,215,137 255 1,905,220 315 2,319,662 378 2,694,469 305 2,146,834 298 2,244,627 244 1,801,387 170 1,248,912 115 858,408 67 504,828 50 386,292 88 633,445 8,000 155 1,270,756 213 1,802,540 281 2,344,428 305 2,468,962 254 2,050,958 252 2,133,470 238 1,994,668 165 1,382,910 118 1,019,565 82 713,596 57 510,576 84 705,156 9,000 167 1,532,326 200 1,886,674 236 2,231,351 230 2,078,385 180 1,633,309 226 2,108,087 235 2,190,623 202 1,874,528 124 1,201,352 87 827,078 63 646,723 102 982,562 10,000 to 14,000 569 6,698,053 617 7,167,329 569 6,851,408 456 5,308,630 351 3,949,232 519 6,720,783 610 7,766,132 606 7,096,464 538 7,035,461 388 5,061,502 310 4,246,945 439 5,630,062 15,000 to 17,000 565 8,534,036 487 7,360,924 349 5,017,055 272 3,669,763 183 2,587,659 417 5,361,048 501 7,022,026 568 8,566,299 472 7,305,529 425 6,710,462 305 5,057,112 452 7,123,642 18,000 to 20,000 263 4,913,649 187 3,436,058 81 1,620,757 44 874,606 45 838,031 73 1,639,592 147 3,148,014 268 4,880,742 270 5,489,306 271 5,442,041 250 5,404,044 284 5,835,496 21,000 to 25,000 489 10,454,551 335 7,240,892 197 4,104,416 111 2,193,999 83 1,697,982 249 4,460,518 386 7,358,044 521 11,094,350 580 12,516,916 628 13,929,792 527 12,662,266 631 14,119,019 26,000 to 29,000 311 8,062,586 160 4,235,409 86 2,220,126 49 1,154,208 24 615,753 120 2,466,820 199 4,499,421 286 7,478,781 409 10,510,882 437 11,577,401 429 11,908,228 470 12,200,307 30,000 to 34,000 231 7,178,267 105 3,261,975 56 1,706,788 31 924,910 22 663,311 74 1,929,656 122 3,395,451 206 6,334,853 358 10,862,421 422 13,087,922 452 14,685,559 383 11,869,814 35,000 to 39,000 134 4,840,963 75 2,711,496 24 852,748 16 531,571 10 368,511 36 1,145,201 76 2,489,427 133 4,815,748 217 7,599,627 298 10,743,691 357 13,191,481 271 9,764,549 40,000 to 44,000 78 3,201,752 39 1,584,616 15 658,352 9 414,331 11 473,361 21 759,110 32 1,189,994 72 2,874,060 150 5,960,419 213 8,711,102 274 11,493,178 191 7,802,170 45,000 to 50,000 53 2,512,436 25 1,162,813 12 586,305 8 379,304 6 261,671 14 643,608 27 1,187,489 48 2,145,422 115 5,175,433 166 7,645,299 235 11,222,643 137 6,371,116 51,000 to 59,000 44 2,300,697 21 1,129,315 14 826,058 6 345,205 8 443,248 13 593,102 20 1,059,157 40 2,135,895 78 4,090,307 113 5,925,609 184 10,010,891 111 5,858,664 60,000 to 69,000 30 1,823,584 23 1,438,082 14 889,222 8 461,255 8 462,522 10 596,645 19 1,034,839 26 1,599,715 56 3,192,713 95 5,700,199 187 11,009,784 78 4,645,661 70,000 +125 30,108,452 101 20,738,660 65 14,423,357 66 10,623,164 54 9,509,000 70 12,564,780 70 15,206,507 107 21,753,106 150 34,663,252 204 44,898,395 342 61,871,149 186 40,972,649 4,346 97,879,076 4,363 72,736,908 4,362 54,379,475 4,387 43,169,342 4,394 37,741,875 4,409 53,238,377 4,415 66,812,840 4,436 88,773,695 4,444 119,745,174 4,447 143,100,267 4,463 175,508,956 4,483 136,293,873 WATER USE FOR MONTH WATER RATES FOR ALL METER SIZES TOTAL USAGE:1,089,379,857 Gallons Included in Minimum Bill =0 $ Amount of Minimum Bill =12.71 MIN BILL =$12.71 0 to 6,000 $2.70 7,000 to 17,000 $3.14 18,000 to 25,000 $3.64 26,000 to 50,000 $4.23 51,000 + $4.91 Oct 10 Nov 11 Dec 12 Jan 1 Feb 2 Mar 3 Apr 4 May 5 Jun 6 Jul 7 Aug 8 Sep 9 Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Accounts Usage Accounts Usage Accounts Usage 1,000 $2,977 $241 $3,476 $300 $4,283 $424 $4,816 $454 $5,905 $617 $4,301 $391 $3,804 $305 $3,207 $219 $2,806 $241 $2,910 $607 $2,243 $96 $2,569 $511 2,000 $1,424 $616 $2,299 $1,058 $2,989 $1,343 $3,182 $1,412 $4,555 $1,953 $2,768 $1,314 $2,100 $947 $1,506 $631 $924 $391 $862 $380 $695 $385 $827 $362 3,000 $1,734 $1,113 $3,166 $2,183 $3,944 $2,657 $4,608 $3,072 $6,098 $3,916 $4,107 $2,943 $2,890 $1,997 $1,639 $1,127 $1,102 $809 $728 $459 $649 $504 $1,010 $648 4,000 $2,124 $1,915 $3,591 $3,301 $4,945 $4,388 $6,006 $5,291 $7,689 $6,577 $5,178 $4,897 $3,477 $3,193 $2,121 $1,919 $1,254 $1,165 $782 $738 $654 $635 $954 $859 5,000 $2,026 $2,254 $3,386 $3,857 $5,335 $5,976 $6,104 $6,699 $6,500 $6,969 $4,914 $5,695 $3,316 $3,769 $2,261 $2,519 $1,262 $1,527 $931 $1,099 $709 $787 $936 $1,057 6,000 $1,964 $2,586 $3,391 $4,624 $4,542 $6,076 $5,772 $7,497 $5,498 $7,078 $4,355 $6,013 $3,351 $4,557 $2,213 $3,013 $1,463 $1,978 $791 $1,096 $631 $838 $1,031 $1,368 7,000 $2,115 $3,816 $3,237 $5,982 $4,008 $7,284 $4,801 $8,461 $3,871 $6,741 $3,785 $7,048 $3,104 $5,656 $2,162 $3,922 $1,462 $2,695 $854 $1,585 $640 $1,213 $1,119 $1,989 8,000 $1,971 $3,990 $2,713 $5,660 $3,566 $7,362 $3,874 $7,753 $3,226 $6,440 $3,202 $6,699 $3,020 $6,263 $2,098 $4,342 $1,499 $3,201 $1,043 $2,241 $725 $1,603 $1,073 $2,214 9,000 $2,121 $4,812 $2,542 $5,924 $3,004 $7,006 $2,919 $6,526 $2,287 $5,129 $2,870 $6,619 $2,990 $6,879 $2,562 $5,886 $1,581 $3,772 $1,100 $2,597 $806 $2,031 $1,291 $3,085 10,000 to 14,000 $7,233 $21,032 $7,848 $22,505 $7,227 $21,513 $5,791 $16,669 $4,467 $12,401 $6,601 $21,103 $7,754 $24,386 $7,703 $22,283 $6,832 $22,091 $4,934 $15,893 $3,945 $13,335 $5,581 $17,678 15,000 to 17,000 $7,179 $26,797 $6,190 $23,113 $4,431 $15,754 $3,460 $11,523 $2,322 $8,125 $5,298 $16,834 $6,368 $22,049 $7,214 $26,898 $6,001 $22,939 $5,403 $21,071 $3,879 $15,879 $5,741 $22,368 18,000 to 20,000 $3,349 $17,886 $2,381 $12,507 $1,029 $5,900 $559 $3,184 $573 $3,050 $922 $5,968 $1,871 $11,459 $3,407 $17,766 $3,430 $19,981 $3,450 $19,809 $3,180 $19,671 $3,612 $21,241 21,000 to 25,000 $6,221 $38,055 $4,263 $26,357 $2,498 $14,940 $1,409 $7,986 $1,054 $6,181 $3,170 $16,236 $4,901 $26,783 $6,628 $40,383 $7,377 $45,562 $7,978 $50,704 $6,703 $46,091 $8,021 $51,393 26,000 to 29,000 $3,951 $34,105 $2,032 $17,916 $1,098 $9,391 $625 $4,882 $301 $2,605 $1,531 $10,435 $2,529 $19,033 $3,632 $31,635 $5,197 $44,461 $5,549 $48,972 $5,453 $50,372 $5,968 $51,607 30,000 to 34,000 $2,941 $30,364 $1,337 $13,798 $713 $7,220 $389 $3,912 $276 $2,806 $945 $8,162 $1,550 $14,363 $2,617 $26,796 $4,546 $45,948 $5,359 $55,362 $5,750 $62,120 $4,866 $50,209 35,000 to 39,000 $1,708 $20,477 $959 $11,470 $308 $3,607 $203 $2,249 $132 $1,559 $461 $4,844 $962 $10,530 $1,696 $20,371 $2,760 $32,146 $3,793 $45,446 $4,538 $55,800 $3,449 $41,304 40,000 to 44,000 $989 $13,543 $490 $6,703 $191 $2,785 $120 $1,753 $146 $2,002 $273 $3,211 $410 $5,034 $913 $12,157 $1,904 $25,213 $2,708 $36,848 $3,488 $48,616 $2,421 $33,003 45,000 to 50,000 $678 $10,628 $320 $4,919 $148 $2,480 $100 $1,604 $71 $1,107 $184 $2,722 $341 $5,023 $609 $9,075 $1,468 $21,892 $2,110 $32,340 $2,985 $47,472 $1,743 $26,950 51,000 to 59,000 $562 $11,296 $270 $5,545 $183 $4,056 $81 $1,695 $104 $2,176 $160 $2,912 $256 $5,200 $513 $10,487 $998 $20,083 $1,435 $29,095 $2,337 $49,153 $1,412 $28,766 60,000 to 69,000 $382 $8,954 $290 $7,061 $176 $4,366 $104 $2,265 $99 $2,271 $128 $2,930 $236 $5,081 $330 $7,855 $708 $15,676 $1,209 $27,988 $2,376 $54,058 $994 $22,810 70,000 +$1,585 $147,832 $1,278 $101,827 $823 $70,819 $837 $52,160 $681 $46,689 $888 $61,693 $888 $74,664 $1,355 $106,808 $1,904 $170,197 $2,593 $220,451 $4,342 $303,787 $2,362 $201,176 $55,234 $402,312 $55,458 $286,610 $55,441 $205,346 $55,759 $157,047 $55,854 $136,391 $56,042 $198,670 $56,119 $257,171 $56,384 $356,093 $56,480 $501,970 $56,520 $614,780 $56,730 $774,447 $56,978 $580,600 $5,144,435 PROJECTED ANNUAL REVENUE GENERATED FROM PROPOSED RATES =$5,144,435 AMOUNT FROM BASE:$672,999 Additional Base $141,610.56 AMOUNT FROM USAGE:$4,471,436 TOTAL:$5,286,045 OTHER REVENUE SOURCES Base rates for Meters other than 5/8 A B C D E Size Accounts as of 6/26/14 Rate 12 months MONTH SHUTOFFS FOR NON-PAYMENT LATE FEES ($/Month) 1"1650 $4.00 $79,200.00 PID MUD 1.5"20 $13.71 $3,290.40 Jan-14 28 17 11 3298.09 2"90 $25.35 $27,378.00 Feb-14 11 14 2 4737.93 3"17 $52.52 $10,714.08 Mar-14 14 5 11 3939.68 4"13 $91.33 $14,247.48 Apr-14 35 13 6 3693.08 6"3 $188.35 $6,780.60 May-14 31 8 5 3961.81 Jun-13 30 23 3 7013.62 Total $141,610.56 Jul-13 34 21 11 4371.56 Aug-13 24 9 6 5682.15 Sep-13 37 20 4 7809.2 Oct-13 26 15 8 7531.17 Nov-13 33 13 6 5791.4 Dec-13 17 18 1 5586.4 Total 320 176 74 $63,416 Average Per Month 27 15 6 $5,285 3.25%recommended GROWTH RATE BASED ON (AVE./MONTH X 12) NEW METERS SET:REVENUE FOR SHUTOFFS (MO. AVE. X 12 x $25):$8,000 SERVICE CHGS TOTAL LATE FEES:$63,416 PENALTIES REVENUE FOR MUD TAP FEES:$21,608 REVENUE FOR PID UTILITY FEES:$184,000 NEW METERS SET (TAP FEES) PID TABLE GF-D 2 TOTAL PROJECTED FY 2015 RETAIL WATER REVENUES Usage Groups TOTAL SCHEDULE GF-D FY 15 WATER REVENUE PROJECTION PROJECTED RETAIL WATER SALES WATER USE CATEGORY 16 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug SepAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccounts Usage 1,000 234 89,398 273 111,268 337 157,091 379 168,279 465 228,449 338 144,790 299 113,034 252 81,008 221 89,355 229 224,651 176 35,545 202 189,303 2,000 112 228,127 181 391,845 235 497,358 250 523,099 358 723,307 218 486,537 165 350,631 118 233,619 73 144,711 68 140,605 55 142,717 65 134,222 3,000 136 412,356 249 808,475 310 983,996 363 1,137,686 480 1,450,431 323 1,090,038 227 739,615 129 417,520 87 299,660 57 169,931 51 186,711 79 239,942 4,000 167 709,217 283 1,222,490 389 1,625,282 473 1,959,743 605 2,435,832 407 1,813,662 274 1,182,569 167 710,895 99 431,620 62 273,366 51 235,224 75 318,244 5,000 159 834,844 266 1,428,372 420 2,213,305 480 2,480,943 511 2,581,166 387 2,109,191 261 1,395,923 178 932,972 99 565,568 73 406,928 56 291,562 74 391,305 6,000 155 957,890 267 1,712,453 357 2,250,408 454 2,776,830 433 2,621,307 343 2,227,113 264 1,687,889 174 1,115,897 115 732,669 62 405,870 50 310,326 81 506,546 7,000 166 1,215,137 255 1,905,220 315 2,319,662 378 2,694,469 305 2,146,834 298 2,244,627 244 1,801,387 170 1,248,912 115 858,408 67 504,828 50 386,292 88 633,445 8,000 155 1,270,756 213 1,802,540 281 2,344,428 305 2,468,962 254 2,050,958 252 2,133,470 238 1,994,668 165 1,382,910 118 1,019,565 82 713,596 57 510,576 84 705,156 9,000 167 1,532,326 200 1,886,674 236 2,231,351 230 2,078,385 180 1,633,309 226 2,108,087 235 2,190,623 202 1,874,528 124 1,201,352 87 827,078 63 646,723 102 982,56210,000 to 14,000 569 6,698,053 617 7,167,329 569 6,851,408 456 5,308,630 351 3,949,232 519 6,720,783 610 7,766,132 606 7,096,464 538 7,035,461 388 5,061,502 310 4,246,945 439 5,630,062 15,000 to 17,000 565 8,534,036 487 7,360,924 349 5,017,055 272 3,669,763 183 2,587,659 417 5,361,048 501 7,022,026 568 8,566,299 472 7,305,529 425 6,710,462 305 5,057,112 452 7,123,642 18,000 to 20,000 263 N/A 187 N/A 81 N/A 44 N/A 45 N/A 73 N/A 147 N/A 268 N/A 270 N/A 271 N/A 250 N/A 284 N/A21,000 to 25,000 489 N/A 335 N/A 197 N/A 111 N/A 83 N/A 249 N/A 386 N/A 521 N/A 580 N/A 628 N/A 527 N/A 631 N/A 26,000 to 29,000 311 N/A 160 N/A 86 N/A 49 N/A 24 N/A 120 N/A 199 N/A 286 N/A 409 N/A 437 N/A 429 N/A 470 N/A 30,000 to 34,000 231 N/A 105 N/A 56 N/A 31 N/A 22 N/A 74 N/A 122 N/A 206 N/A 358 N/A 422 N/A 452 N/A 383 N/A35,000 to 39,000 134 N/A 75 N/A 24 N/A 16 N/A 10 N/A 36 N/A 76 N/A 133 N/A 217 N/A 298 N/A 357 N/A 271 N/A 40,000 to 44,000 78 N/A 39 N/A 15 N/A 9 N/A 11 N/A 21 N/A 32 N/A 72 N/A 150 N/A 213 N/A 274 N/A 191 N/A45,000 to 50,000 53 N/A 25 N/A 12 N/A 8 N/A 6 N/A 14 N/A 27 N/A 48 N/A 115 N/A 166 N/A 235 N/A 137 N/A51,000 to 59,000 44 N/A 21 N/A 14 N/A 6 N/A 8 N/A 13 N/A 20 N/A 40 N/A 78 N/A 113 N/A 184 N/A 111 N/A 60,000 to 69,000 30 N/A 23 N/A 14 N/A 8 N/A 8 N/A 10 N/A 19 N/A 26 N/A 56 N/A 95 N/A 187 N/A 78 N/A70,000 +125 N/A 101 N/A 65 N/A 66 N/A 54 N/A 70 N/A 70 N/A 107 N/A 150 N/A 204 N/A 342 N/A 186 N/A WASTEWATER RATES FOR ALL METER SIZES Gallons Included in Minimum Bill =0 $ Amount of Minimum Bill =14.58 MIN BILL =$14.58 0 to 6,999 $2.50 7,000 to 18,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 Usage 1,000 $3,414 $223 $3,987 $278 $4,913 $393 $5,524 $421 $6,774 $571 $4,934 $362 $4,364 $283 $3,678 $203 $3,219 $223 $3,338 $562 $2,573 $89 $2,947 $473 2,000 $1,633 $570 $2,637 $980 $3,429 $1,243 $3,651 $1,308 $5,225 $1,808 $3,176 $1,216 $2,409 $877 $1,728 $584 $1,060 $362 $989 $352 $797 $357 $949 $336 3,000 $1,989 $1,031 $3,632 $2,021 $4,524 $2,460 $5,286 $2,844 $6,995 $3,626 $4,712 $2,725 $3,315 $1,849 $1,880 $1,044 $1,264 $749 $835 $425 $744 $467 $1,158 $600 4,000 $2,436 $1,773 $4,119 $3,056 $5,672 $4,063 $6,890 $4,899 $8,820 $6,090 $5,940 $4,534 $3,989 $2,956 $2,433 $1,777 $1,439 $1,079 $897 $683 $750 $588 $1,095 $796 5,000 $2,325 $2,087 $3,884 $3,571 $6,120 $5,533 $7,002 $6,202 $7,456 $6,453 $5,637 $5,273 $3,803 $3,490 $2,594 $2,332 $1,448 $1,414 $1,068 $1,017 $814 $729 $1,073 $978 6,000 $2,253 $2,395 $3,890 $4,281 $5,211 $5,626 $6,621 $6,942 $6,307 $6,553 $4,996 $5,568 $3,844 $4,220 $2,538 $2,790 $1,678 $1,832 $908 $1,015 $724 $776 $1,182 $1,266 7,000 $2,427 $3,038 $3,713 $4,763 $4,598 $5,799 $5,507 $6,736 $4,441 $5,367 $4,342 $5,612 $3,561 $4,503 $2,480 $3,122 $1,677 $2,146 $979 $1,262 $734 $966 $1,284 $1,584 8,000 $2,261 $3,177 $3,113 $4,506 $4,091 $5,861 $4,444 $6,172 $3,700 $5,127 $3,673 $5,334 $3,465 $4,987 $2,406 $3,457 $1,719 $2,549 $1,197 $1,784 $832 $1,276 $1,231 $1,763 9,000 $2,433 $3,831 $2,916 $4,717 $3,446 $5,578 $3,348 $5,196 $2,624 $4,083 $3,293 $5,270 $3,430 $5,477 $2,939 $4,686 $1,814 $3,003 $1,262 $2,068 $925 $1,617 $1,480 $2,456 10,000 to 14,000 $8,297 $16,745 $9,003 $17,918 $8,291 $17,129 $6,643 $13,272 $5,125 $9,873 $7,572 $16,802 $8,895 $19,415 $8,836 $17,741 $7,838 $17,589 $5,659 $12,654 $4,525 $10,617 $6,402 $14,07515,000 to 17,000 $8,235 $21,335 $7,101 $18,402 $5,083 $12,543 $3,969 $9,174 $2,664 $6,469 $6,077 $13,403 $7,305 $17,555 $8,276 $21,416 $6,884 $18,264 $6,197 $16,776 $4,450 $12,643 $6,585 $17,809 18,000 to 20,000 $3,842 $11,857 $2,731 $8,428 $1,180 $3,642 $641 $1,978 $657 $2,028 $1,058 $3,265 $2,146 $6,623 $3,909 $12,064 $3,935 $12,145 $3,957 $12,214 $3,647 $11,257 $4,143 $12,787 21,000 to 25,000 $7,136 $22,024 $4,890 $15,092 $2,865 $8,843 $1,617 $4,990 $1,209 $3,731 $3,637 $11,224 $5,623 $17,353 $7,603 $23,465 $8,462 $26,118 $9,151 $28,245 $7,689 $23,732 $9,202 $28,40026,000 to 29,000 $4,533 $13,990 $2,331 $7,196 $1,260 $3,887 $716 $2,211 $346 $1,067 $1,756 $5,420 $2,901 $8,953 $4,166 $12,858 $5,962 $18,401 $6,366 $19,648 $6,255 $19,307 $6,846 $21,128 30,000 to 34,000 $3,374 $10,414 $1,534 $4,734 $818 $2,524 $446 $1,378 $316 $976 $1,084 $3,347 $1,778 $5,488 $3,002 $9,266 $5,215 $16,096 $6,147 $18,972 $6,596 $20,357 $5,582 $17,22835,000 to 39,000 $1,959 $6,047 $1,100 $3,394 $353 $1,090 $233 $718 $151 $466 $529 $1,634 $1,104 $3,408 $1,946 $6,005 $3,167 $9,773 $4,351 $13,429 $5,206 $16,067 $3,956 $12,21040,000 to 44,000 $1,135 $3,503 $562 $1,736 $219 $676 $137 $423 $167 $516 $313 $965 $470 $1,452 $1,047 $3,232 $2,184 $6,740 $3,106 $9,586 $4,002 $12,351 $2,778 $8,573 45,000 to 50,000 $777 $2,400 $367 $1,132 $170 $525 $114 $353 $82 $252 $211 $651 $392 $1,209 $698 $2,155 $1,684 $5,197 $2,420 $7,469 $3,424 $10,569 $2,000 $6,17251,000 to 59,000 $645 $1,989 $310 $956 $210 $649 $93 $286 $119 $368 $184 $568 $294 $906 $588 $1,816 $1,144 $3,532 $1,646 $5,081 $2,681 $8,276 $1,620 $5,001 60,000 to 69,000 $439 $1,354 $332 $1,025 $201 $622 $120 $370 $114 $351 $147 $453 $271 $835 $378 $1,167 $813 $2,508 $1,387 $4,280 $2,725 $8,411 $1,140 $3,520 70,000 +$1,819 $5,613 $1,466 $4,526 $945 $2,916 $961 $2,965 $781 $2,410 $1,019 $3,145 $1,018 $3,143 $1,554 $4,797 $2,185 $6,743 $2,974 $9,179 $4,981 $15,373 $2,709 $8,361REVENUE:$63,361 $135,396 $63,617 $112,712 $63,598 $91,602 $63,962 $78,839 $64,071 $68,185 $64,288 $96,770 $64,376 $114,982 $64,679 $135,976 $64,790 $156,463 $64,836 $166,702 $65,076 $175,824 $65,361 $165,515 PROJECTED ANNUAL REVENUE GENERATED FROM PROPOSED RATES =$2,270,982 AMOUNT FROM BASE:$772,016 AMOUNT FROM USAGE:$1,498,965 TOTAL:$2,270,982 TROPHY CLUB COUNTRY CLUB EFFLUENT REVENUE Month Mil Gals Charges Jul-13 21.958 $15,371Aug-13 23.94 $16,758Sep-13 22.842 $15,989 Oct-13 10.389 $7,272Nov-13 0.747 $523Dec-13 0.196 $137 Jan-14 0.267 $187Feb-14 0.327 $229 Mar-14 2.818 $1,973 Apr-14 10.87 $7,609May-14 13.617 $9,532 Jun-14 16.051 $11,235 TOTAL:124.022 $86,815 Usage Groups SCHEDULE GF-E PROJECTED RETAIL WASTEWATER SALES FY 15 WATER USECATEGORY PROJECTED FY 2015 RETAIL WASTEWATER 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 5 2 10 $35 $350 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,620 WASTEWATER ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 6 6 36 $8 $288 POLO SHIRTS 0 6 0 $35 $0 SWEATSHIRTS 6 5 30 $18 $540 PANTS 6 5 30 $25 $750 BOOTS 6 1 6 $175 $1,050 JACKET 1 1 1 $150 $150 TOTAL:$2,778 ADMINISTRATION ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL POLO SHIRTS 7 5 35 $35 $1,225 (Director) SHIRTS 5 2 10 $35 $350 SWEATER 7 1 7 $40 $280 PANTS 0 0 0 $25 $0 TOTAL:$1,855 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 Plumbing License Renewal 1 $55 $55 $50 $50 Management Classes 0 $350 $0 $100 $0 Management Conferences 1 $350 $350 $400 $400 License Renewal 3 $111 $333 $100 $400 CDL Renewal 2 $75 $150 $0 $0 Miscellaneous Mileage/Travel (Miles)1,000 $0.56 $560 $0 $300 $4,138 $1,500 $5,638 WASTEWATER Wastewater/Distribution Classes 8 $325 $2,600 $50 $400 Management Classes 0 $350 $0 $100 $0 Management Conferences 1 $350 $350 $400 $400 License Renewal 5 $111 $555 $100 $500 CDL Renewal 0 $75 $0 $0 $0 Miscellaneous Mileage/Travel (Miles)1,000 $0.56 $560 $0 $300 $4,065 $1,600 $5,665 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 2 $350 $700 $400 $800 Software Training 4 $300 $1,200 $50 $200 Content Management System Training 1 $1,275 $1,275 $100 $100 Customer Service Conferences 2 $350 $700 $400 $800 CPA/CFE Classes/Renewal 1 $900 $900 $0 $0 Miscellaneous Mileage/Travel (Miles)1,000 $0.56 $560 $0 $300 Miscellaneous Travel (Legal)3 $500 $1,500 $0 $0 $10,235 $5,400 $15,635 19 SCHEDULE GF-H SALARIES 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 0.0%3.0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%2.3% TO $4500 (1/2 Yr) (9/year) Fire Chief 50.00%104,743 52,372 0 786 0 53,157 0 0 683 683 0 0 3,338 781 104 1,004 Fire Lieutenant 50.00%66,684 33,342 0 500 0 33,848 3,222 1,255 394 394 600 600 2,438 523 104 639 Fire Lieutenant 50.00%76,263 38,132 0 572 0 38,701 3,687 1,435 829 829 450 450 2,796 601 104 731 Fire Lieutenant 50.00%72,302 36,151 0 542 0 36,686 3,490 1,360 518 518 600 600 2,645 568 104 693 Fire Fighter/EMT-P 50.00%50,230 25,115 0 377 0 25,499 2,419 945 323 323 750 750 1,856 399 104 481 Fire Fighter/EMT-P 50.00%49,274 24,637 0 370 0 25,009 2,340 927 236 236 0 0 1,768 379 104 472 Engineer - Fire Fighter/EMT-P 50.00%62,368 31,184 0 468 0 31,652 3,010 1,174 548 548 450 450 2,284 490 104 598 Engineer - Fire Fighter/EMT-P 50.00%60,040 30,020 0 450 0 30,476 2,889 1,130 390 390 450 450 2,191 470 104 575 Engineer - Fire Fighter/EMT-P 50.00%61,342 30,671 0 460 0 31,135 2,965 1,154 428 428 600 600 2,250 483 104 588 Fire Fighter/EMT-P 50.00%55,952 27,976 0 420 0 28,394 2,690 1,053 428 428 300 300 2,038 438 104 536 Fire Fighter/EMT-P 50.00%51,473 25,737 0 386 0 26,127 2,478 969 345 345 300 300 1,874 402 104 493 Fire Fighter/EMT-P 50.00%47,321 23,661 0 355 0 24,022 2,303 872 225 225 300 0 1,700 364 104 444 Fire Fighter/EMT-P 50.00%48,387 24,194 0 363 0 24,561 2,287 911 98 98 300 300 1,746 375 104 464 Fire Fighter/EMT-P 50.00%47,316 23,658 0 355 0 24,015 2,234 890 60 60 0 0 1,686 362 104 453 Fire Fighter/EMT-P 50.00%46,419 23,210 0 348 0 23,558 2,141 855 0 0 0 0 1,646 354 104 435 Fire Fighter/EMT-P NEW 50.00%0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Part-Time Staff 50.00%24,455 12,228 0 0 0 12,228 0 0 0 0 0 0 758 177 104 86 FTO 50.00%0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50.00%0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 0 0 50.00%0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 0 0 Special Event OT 50.00%13,182 6,591 0 0 0 N/A 8,591 0 0 0 0 0 409 125 0 0 TOTAL:924,569 462,284 0 6,751 0 469,067 46,745 14,930 5,505 4,800 33,421 7,292 1657 8,692 Total w/OT: * Removed New Fire Fighter position ** Removed Stipend COLA Merit Merit Total Social TWC UNEMP WORKERS Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare 2.30%COMP ADMINISTRATION %Base Pay Base Pay 1.7%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%UP TO $9000 General Manager 100%110,591 110,591 1,880 0 1,500 113,971 0 0 150 150 0 0 7,085 1,757 207 234 District Secretary 100%70,390 70,390 1,197 0 1,400 72,987 0 0 240 240 0 0 4,555 1,128 207 234 Administration Manager 100%78,450 78,450 1,334 0 1,400 81,184 0 0 120 120 0 0 5,048 1,252 207 234 Finance Manager 100%84,013 84,013 1,428 0 1,400 86,841 0 0 2,000 2,000 0 0 5,632 1,370 207 234 Utility Billing Clerk 100%42,052 42,052 715 0 1,040 43,807 0 0 578 578 0 0 2,788 684 207 234 Reception/Utility Billing Clerk 100%33,280 33,280 566 0 1,040 34,886 0 0 0 0 0 0 2,163 537 207 234 Communications Specialist 100%40,180 40,180 683 0 1,040 41,903 0 0 195 195 0 0 2,622 648 207 234 Overtime Pay 1,000 62 15 DM Discretionary 2,000 124 31 TOTAL:458,956 458,956 7,802 0 8,820 477,578 1,000 0 3,283 0 30,079 7,422 1,449 1,636 515,813 20 SCHEDULE GF-H COLA Merit Merit Total Social TWC UNEMP WORKERS Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare 2.30%COMP WATER & DISTRIBUTION %Base Pay Base Pay 1.7%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%UP TO $9000 Utility Superintendent 100%71,302 71,302 1,212 0 1,400 73,914 0 0 2,000 2,000 0 0 4,831 1,130 207 2,670 Field Supervisor 100%59,273 59,273 1,008 0 1,100 61,381 0 0 1462.5 1,463 1800 1800 4,210 985 207 2,670 Crew Leader 100%45,992 45,992 782 0 1,040 47,814 0 0 1162.5 1,163 1500 1500 3,295 771 207 2,670 Utility Field Worker 100%42,076 42,076 715 0 1,040 43,831 0 0 637.5 638 600 600 2,871 671 207 2,670 Utility Field Worker 100%35,360 35,360 601 0 1,200 37,161 0 0 80 80 600 600 2,388 559 207 2,670 Utility Field Worker 100%33,800 33,800 0 0 1,200 35,000 0 0 0 0 300 300 2,207 516 207 2,670 Overtime Pay 19,500 1,209 283 DM Discretionary 2,000 124 29 TOTAL:287,803 287,803 4,318 0 6,980 301,101 19,500 0 5,343 4,800 21,135 4,943 1,242 16,020 COLA Merit Merit Total Social TWC UNEMP WORKERS Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare 2.30%COMP WASTEWATER & COLLECTIONS %Base Pay Base Pay 1.7%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%UP TO $9000 Wastewater Superintendent 100%64,124 64,124 1,090.11 0 1,400 66,614 0 0 140 140 - - 4,147 970 207 2,670 Crew Leader 100%53,465 53,465 908.91 0 1,040 55,414 0 0 1493 1,493 1,800 1,800 3,844 899 207 2,670 Utility Field Worker 100%47,584 47,584 808.93 0 1,040 49,433 0 0 1103 1,103 1,800 1,800 3,425 801 207 2,670 Utility Field Worker 100%37,252 37,252 633.28 0 1,500 39,385 0 0 593 593 1,200 1,200 2,664 623 207 2,670 Crew Leader 100%51,586 51,586 876.96 0 1,040 53,503 0 0 1,575 1,575 1,200 1,200 3,661 856 207 2,670 Utility Field Worker 100%37,714 37,714 641.14 0 1,040 39,395 0 0 713 713 600 600 2,605 609 207 2,670 Overtime Pay 19,500 - 0 0 - - 1,209 283 DM Discretionary 2,000 - - 0 0 - - 124 29 TOTAL:291,725 291,725 4,959 0 7,060 305,744 19,500 0 5,617 6,600 21,680 5,070 1,242 16,020 21 SCHEDULE GF-I BENEFITS WORKSHEET FIRE DEPARTMENT ADMINISTRATION NO. EMPLOYEES ANNUAL RATE (TCMUD Share @ 50%) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED Employee Only 3 $194 $582 No coverage 0 $0 $0 Employee & Spouse 2 $265 $530 Employee Only 1 $432 $432 Employee & Children 1 $272 $272 Employee & Spouse 2 $594 $1,188 Family 9 $334 $3,006 Employee & Children 1 $678 $678 Family 3 $882 $2,646 TOTAL 15 $4,390 TOTAL 7 $4,944 NO. EMPLOYEES ANNUAL RATE (TCMUD Share @ 50%) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED Employee Only 8 $41 $328 No coverage 0 $0 $0 Employee and Family 7 $69 $483 Employee Only 1 $120 $120 Employee & Spouse 3 $162 $486 Employee & Children 1 $156 $156 Family 2 $198 $396 TOTAL 15 $811 TOTAL 7 $1,158 NO. EMPLOYEES ANNUAL RATE (TCMUD Share @ 50%) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED Employee Only 5 $2,785 $13,925 No coverage 0 $0 $0 Employee & Spouse 2 $4,182 $8,364 Employee Only 3 $7,498 $22,494 Employee & Children 1 $3,532 $3,532 Employee & Spouse 2 $10,513 $21,026 Family 7 $4,764 $33,348 Employee & Children 1 $9,240 $9,240 Family 1 $12,255 $12,255 TOTAL 15 $59,169 TOTAL 7 $65,015 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL $4,030 TOTAL $4,333 DENTAL DENTAL MEDICAL MEDICAL LIFE & OTHER LIFE & OTHER VISION VISION 22 SCHEDULE GF-I BENEFITS WORKSHEET WATER WASTEWATER 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 4 $432 $1,728 Employee Only 1 $432 $432 Employee & Spouse 0 $594 $0 Employee & Spouse 1 $594 $594 Employee & Children 1 $678 $678 Employee & Children 2 $678 $1,356 Family 1 $882 $882 Family 2 $882 $1,764 TOTAL 6 $3,288 TOTAL 6 $4,146 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 4 $120 $480 Employee Only 1 $120 $120 Employee & Spouse 0 $162 $0 Employee & Spouse 1 $162 $162 Employee & Children 1 $156 $156 Employee & Children 2 $156 $312 Family 1 $198 $198 Family 2 $198 $396 TOTAL 6 $834 TOTAL 6 $990 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 6 $7,498 $44,988 Employee Only 1 $7,498 $7,498 Employee & Spouse 0 $10,513 $0 Employee & Spouse 1 $10,513 $10,513 Employee & Children 0 $9,240 $0 Employee & Children 2 $9,240 $18,480 Family 0 $12,255 $0 Family 2 $12,255 $24,510 TOTAL 6 $44,988 TOTAL 6 $61,001 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL $3,074 TOTAL $3,194 LIFE & OTHER DENTAL VISION MEDICALMEDICAL LIFE & OTHER DENTAL VISION FOR ALL DEPARTMENTS (EXCLUDING FIRE) A 10% INCREASE IN EMPLOYEE BENEFITS WAS BUDGETED AS RENEWAL IS NOT UNTIL DECEMBER 2014 23 SCHEDULE GF-J RETIREMENT WORKSHEET FIRE DEPARTMENT Oct-Dec Jan-Sept TMRS TMRS TMRS TOTAL FY 2015 SALARY 14.71%17.62%FY 15 Total WATER Oct-Dec Jan-Sept Fire Chief 53,840 1980 7115 9095 TCDRS TCDRS TCDRS Fire Lieutenant 39,319 1446 5196 6642 TOTAL FY 2015 SALARY 8.98%8.91%FY 15 Total Fire Lieutenant 45,102 1659 5960 7619 Utility Superintendent 75,914 1704 5073 6777 Fire Lieutenant 42,654 1569 5637 7205 Field Supervisor 64,643 1451 4320 5771 Fire Fighter/EMT-P 29,936 1101 3956 5057 Crew Leader 50,476 1133 3373 4506 Fire Fighter/EMT-P 28,512 1049 3768 4816 Utility Field Worker 45,069 1012 3012 4024 Engineer - Fire Fighter/EMT-P 36,833 1355 4867 6222 Utility Field Worker 37,841 850 2529 3378 Engineer - Fire Fighter/EMT-P 35,335 1299 4670 5969 Utility Field Worker 35,300 792 2359 3151 Engineer - Fire Fighter/EMT-P 36,282 1334 4795 6129 Overtime Pay 19,500 438 1303 1741 Fire Fighter/EMT-P 32,865 1209 4343 5552 TOTAL:328,744 7,380 21,968 29,349 Fire Fighter/EMT-P 30,218 1111 3993 5105 Fire Fighter/EMT-P 27,422 1008 3624 4632 Fire Fighter/EMT-P 28,157 1035 3721 4756 Fire Fighter/EMT-P 27,200 1000 3594 4595 Fire Fighter/EMT-P 26,554 977 3509 4486 WASTEWATER Oct-Dec Jan-Sept Fire Fighter/EMT-P NEW 0 0 0 0 TCDRS TCDRS TCDRS Part-Time Staff 12,228 450 1616 2066 TOTAL FY 2015 SALARY 8.98%8.91%FY 15 Total 0 0 0 0 Wastewater Superintendent 66,754 1,499 4461 5959 Overtime Pay (Total)8,591 316 1135 1451 Crew Leader 58,707 1,318 3923 5241 TOTAL:541,048 19,897 71,499 91,396 Utility Field Worker 52,336 1,175 3497 4672 Utility Field Worker 41,178 924 2752 3676 Crew Leader 56,278 1,263 3761 5024 Utility Field Worker 40,708 914 2720 3634 Overtime Pay 19,500 438 1303 1741 ADMINISTRATION Oct-Dec Jan-Sept TOTAL:335,461 7,531 22,417 29,948 TCDRS TCDRS TCDRS TOTAL FY 2015 SALARY 8.98%8.91%FY 15 Total General Manager 114,121 2,562 7,626 10,188 District Secretary 73,227 1,644 4,893 6,537 Administration Manager 81,304 1,825 5,433 7,258 Finance Manager 88,841 1,994 5,937 7,931 Utility Billing/Admin Asst.44,385 996 2,966 3,962 Utility Billing/Admin Asst.34,886 783 2,331 3,114 Utility Billing/Admin Asst.42,098 945 2,813 3,758 Overtime Pay 1,000 22 67 89 TOTAL:479,861 10,773 32,067 42,840 24 SCHEDULE GF-K Electricity & Gas Analysis for FY 2014-2015 Hudson Energy FY 2015 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 Annual Total $Cost per KWH 10% INCREASE 2836193 135-60020-010 Water Well #1, Well #3 79440 $6,276 66960 $5,473 88560 $6,876 69120 $5,638 46080 $4,171 14400 $1,650 5280 $1,055 240 683 0 $656 0 $656 32640 $3,386 72480 $5,928 475,200 $42,448 0.089326599 $46,693 2770721 135-60020-010 Elevated Tank-TW King 52 $14 123 $21 122 $21 140 $23 165 $25 426 $49 220 $30 608 $66 901 $94 204 $28 225 $30 75 $16 3,261 $417 0.127874885 $459 2828381 135-60020-010 Paluxy Well #4 12800 $998 12240 $962 12560 $982 12240 $962 13120 $1,018 12800 $998 3680 $417 0 $45 80 $38 10480 $851 13520 $1,046 13040 $1,016 116,560 $9,333 0.080070350 $10,266 2829590 135-60020-010 Paluxy Well #2 16070 $1,230 14429 $1,124 14811 $1,149 14305 $1,116 15435 $1,188 3778 $461 2763 $389 6 $134 7 $123 13186 $1,073 16614 $1,285 15816 $1,226 127,220 $10,498 0.082518472 $11,548 2836131 135-60020-010 Water Plant/Water Barn 1956 $239 1896 $235 2036 $282 1679 $224 1292 $288 5390 $698 7177 $747 6948 $750 4552 $582 2272 $400 1412 $319 1359 $186 37,969 $4,950 0.130369512 $5,445 2836162 135-60020-010 Water plant pump station 47600 $6,241 66600 $7,437 72200 $7,990 8800 $2,464 4000 $1,327 36400 $3,983 8800 $2,286 20200 $3,030 3400 $1,391 30200 $3,706 20800 $3,140 29200 $5,661 348,200 $48,656 0.139735784 $53,522 8644641 135-60020-010 100 Municipal Dr, Unit B 33600 $3,815 13700 $2,523 20000 $3,026 52600 $5,097 37200 $3,924 2500 $1,494 20600 $2,631 11300 $2,025 28600 $3,263 15200 $2,375 35600 $3,899 33500 $3,735 304,400 $37,807 0.124200920 $41,587 9130039 135-60020-010 2901 Bobcat Unit A, Elev Tank 756 $79 775 $160 2281 $221 727 $76 733 $77 829 $86 770 $81 710 $75 729 $78 731 $78 770 $81 300 $40 10,111 $1,132 0.111995846 $1,246 TOTAL: $170,765 2828536 135-60020-020 Sewer Plant 127272 $10,195 125916 $10,108 121666 $9,808 108509 $8,881 118807 $9,537 123300 $9,823 112993 $9,133 100917 $8,480 105688 $8,777 114160 $9,415 119896 $9,939 131486 $10,631 1,410,610 $114,727 0.081331800 $126,200 TOTAL:$126,200 7716439 135-60020-021 WWTP Barn/MUD Share Only 597 $96 677 $97 539 $85 505 $87 453 $137 2394 $281 3208 $331 3198 $364 2033 $255 771 $176 456 $125 492 $76 15,323 $2,110 0.137701494 $2,321 8611313 135-60020-021 Collection Barn for Vac-Con 399 $92 378 $84 364 $106 285 $78 240 $83 6588 $571 8215 $667 7758 $646 6017 $524 4290 $414 1745 $250 309 $142 36,588 $3,657 0.099950804 $4,023 8251800 135-60020-021 310 Skyline-Lift Sta #6 600 $132 400 $92 400 $100 500 $99 600 $134 700 $134 700 $184 800 $212 600 $126 800 $170 500 $127 500 $89 7,100 $1,599 0.225211268 $1,759 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 $30 70 $13 70 $13 840 $174 0.207619048 $192 2820941 135-60020-021 Lift Station Trophy 20 309 $38 283 $36 278 $35 243 $32 270 $35 322 $39 422 $49 332 $40 353 $42 344 $42 317 $39 300 $37 3,773 $464 0.122979062 $510 2828598 135-60020-021 Lift Station #4 (old)800 $83 800 $83 640 $69 640 $69 800 $84 320 $39 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 4,000 $427 0.106750000 $470 6245046 135-60020-021 Lift Station #2 1401 $322 1186 $245 1177 $259 1155 $268 1298 $261 1274 $246 1398 $198 1128 $172 1222 $178 1252 $180 1443 $276 1584 $211 15,518 $2,816 0.181466684 $3,098 9215255 135-60020-021 Lift Station #1 900 $158 700 $111 800 $119 800 $119 800 $119 800 $119 1000 $211 800 $29 800 $124 800 $185 800 $116 800 $116 9,800 $1,526 0.155714286 $1,679 9843774 135-60020-021 Lift Station #7 175 $26 172 $25 197 $28 155 $24 162 $25 194 $28 185 $27 210 $29 178 $26 183 $26 216 $30 202 $28 2,229 $322 0.144459399 $354 8306586 135-60020-021 PID Lift Station #8 378 $44 419 $93 484 $10 505 $76 502 $56 529 $58 791 $83 494 $55 464 $53 494 $56 551 $61 561 $62 6,172 $707 0.114549579 $778 0051720 135-60020-021 PID Lift Station #9 100 $20 200 $51 100 $20 200 $30 100 $20 200 $30 200 $30 200 $30 100 $20 200 $30 200 $30 300 $40 2,100 $351 0.167142857 $386 0199280 135-60020-021 PID Lift Station #4 (new)0 $87 650 $75 950 $105 800 $90 700 $81 800 $91 800 $91 800 $92 5,500 $712 0.129454545 $783 TOTAL:$16,352 8797254 122-60020-045 Fire Station 7716 $635 7404 $630 7203 $601 5613 $496 4235 $407 4477 $411 4922 $442 4311 $401 4102 $393 4174 $401 4746 $434 5587 $492 64,490 $5,743 0.089052566 $6,317 MUD SHARE ONLY TOTAL:$6,317 Direct Energy (Split with Town) MUD 1/2 usage 2836100 135-60020-030 MUD & PW Bldgs 12,060 $1,261 11,400 $1,207 10,680 $1,147 8,940 $1,005 7,560 $888 25,830 $2,934 6,960 $555 15,660 $1,255 12,090 $1,149 9,060 $861 9,664 $541 8,527 $813 138,431 13,616 0.098359472 $14,978 TOTAL:$14,978 Tri-County Meter # 165775 135-60020-021 Lift Station 3 3288 $304 3347 $292 3505 $304 3325 $299 2921 $266 3107 $281 2607 $240 2855 $275 3163 $359 2873 $328 3163 $359 4161 $485 38,315 3,792 0.098969072 $4,171 170037 135-60020-021 Lift Station 5 1933 $189 1844 $172 1893 $176 1678 $164 1459 $146 1329 $135 1198 $124 1369 $145 1429 $176 1361 $145 1429 $176 2033 $250 18,955 1,998 0.105407544 $2,198 170038 135-60020-021 Lift Station 5 (Backup)24 $28 23 $28 27 $28 25 $28 27 $28 25 $28 23 $28 26 $28 24 $28 24 $28 24 $28 25 $29 297 337 1.135084175 $371 TOTAL:$6,740 Atmos - Gas @ Fire Station (Measures by Thousand Cubic Feet) MUD 1/2 usage Meter S/N 11N37543122-60020-045 Fire Station 39 $61 43 $64 42 $65 47 $69 90 $95 696 $475 694 $482 753 $521 408 $360 96 $116 29 $61 63 $93 3,000 2,462 0.820666667 $2,708 TOTAL:$2,708 Jun-14 Jul-13 Aug-13 Sept-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 25 SCHEDULE GF-L CONTRACTUAL SERVICES WITH TOWN OF TROPHY CLUB Department Amount FY 2015 Comment Amount FY 2014 135-55161-030-000 Information Technology- 70% Town 30% MUD IT Budget 0 Information Technology- 60% Town 40% MUD IT Budget 79,632 Grounds Maintenance 9025 Includes all site except WWTP; 17 per year 9025 Town Portion of cleaning for TCMUD Building -2,855 Facility Maintenance -11,609 TOTAL:6,170 77,048 Account Description Amount 135-55130-030 Professional Outside Services $48,000 Totals:48,000$ 135-55030-030 Software & Support Used R For Recurring, NR For Non-Recurring. *** - Non Dept Specific R-STW - GL Support & Upgrades 4,250$ R-STW Payroll Support & Upgrades 1,000$ R-STW - UB Support & Upgrades 2,625$ R-STW-AR Support & Upgrades 1,000$ R-STW- Base Financials Lease and Mainteneance 5,860$ R-STW- UB and CR Lease and Maintenance 2,385$ R-STW-Misc, A/R Pcard, Report Dist 3,620$ R-STW-- STW Tools Maintenance 1,500$ R-STW Vision Reporting Annual Maintenance 973$ R-STW eFormz Annual Maintenance 250$ R-Clear Rec Annual Maintenance 600$ R-STW PowerHouse (Part of core apps) Lease & Maint 1,650$ R-Internet Connectivity, 50% Shared.10,500$ R-Web Hosting 300$ R-Web Streaming Provider, 50% Shared 600$ R-Web Maintenance (Domains, SSL Cert, etc)85$ R-Symantec Image Maintenance, Shared.-$ R-TotalInfo for PEG Channel, 50% shared.500$ R-Firewall Security Updates & Suppt, 50% Shared.-$ R-Network Security Software, 50% Shared.-$ R-Miscellaneous Software and Licensing 20,570$ R-Connect-CTY Maintenance, 50% Shared.3,650$ R-Electronic Timeclock/Payroll Main, 50% Shared.1,230$ R-Helpdesk Software Maintenance, 50% Shared.-$ R-Barracuda Mail Screening, Shared.-$ R-ListServ, 50% Shared.450$ R-Fuel Master Maintenance, 50% Shared.1,165$ Contract expires 2015 R-Annual Support for Website 3,000$ R-Automatic Meter Reading Maintenance 3,590$ R-Pipelogix Maintenance 1,900$ R-AudioTel Remit Plus Annual Support 1,750$ 26 R-AudioTel Annual Scanner Support 585$ *** - MUD Manager Totals:75,588$ 135-55070-030 Independent Labor R-Consulting and Support Fees 27,550 (one-time setup fees for M3)Totals:27,550$ 135-60005-030 Telephone Main Phone Numbers/Local Service, 50% Shared 5,040$ WWTP Phone Service 5,760$ Phone System Maintenance, 50% Shared.-$ Repairs (Non-Maintenance), 50% Shared.-$ IS Dept Long Distance, 50% Shared.-$ Totals:10,800$ 135-60235-030 Security R-access Control System, 50% Shared 1350 Totals:1,350$ 122-55030-045 Description Amount Software & Support - Fire Dept.R-Firehouse Support and Maintenance 570$ R-Fire- OSSI Support ( 3 units)228$ R-Denton County RMS Bandwidth, 50% shared 5,700$ R-Web Maintenance (Domains, SSL Cert, etc) 50% shared 10$ R-Symantec Image Maintenance, 50% shared 42$ R-Barracuda Mail Screening, 50% shared.41$ R-Anti-Virus Maintenance and Support, 50% shared.38$ R-Malware-Bytes Maintenance and Support, 50% shared.48$ R-Hosted Exchange, 50% shared 510$ NR-Adobe Upgrade, 50% shared 131$ R-Web Hosting, 50% shared 60$ Totals:7,378$ 122-65055-045 Description Amount Hardware R-Repair and Maintenance 750$ NR-Replacement Computers -$ NR-Replacement Copiers & Printers -$ NR-Replacement First Responders MDT, 50% shared 8,250$ Totals:9,000$ 135-65055-030 Description Amount Hardware R-Backup Tape Replacement, 50% Shared.-$ R-Accessories, mice, keyboards, etc, 50% Shared.-$ R-Repair and Maintenance -$ R-Network Hardware -$ R-A/V Miscellaneous Equipment, 50% Shared.1,200$ 27 R-Fire Extinguishers Maintenance 60$ ************************************************** GASB 34 Expenditures (Offsetting Revenue) ************************************************** LAPTOPS FOR WATER ONLY: FIRE MOVED TO 122 ACCOUNT NR - Replacement Computers 6,337$ NR - Replacement Servers -$ NR - Replacement Copiers & Printers -$ NR - Replacement Infrastructure 68,369$ NR - Replacement Phones -$ NR - Replacement Audio Video -$ NR - Replacement Security -$ NR - Replacement Software -$ NR - Replacement First Responders MDT -$ NR - Replacement Other -$ 74,706$ GASB REVENUE IN BUDGET Used R For Recurring, NR For Non-Recurring. Totals:75,966$ 13565085-030 Office Supplies CD/DVD Media ( All depts receive media from IS)371 Totals:371$ 122-65105-045 Printing 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.498$ Totals:498$ 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.4,732$ Totals:4,732$ 135-69170-030 Copier Rental/Lease Description Amount 28 Monthly lease for the following copiers. Administration Copier BW (7667) Color (2000) Month 4,236$ Public Works Copier -$ Totals:4,236$ Account Description Amount 135-69195-030 Transfer to Future Replacment Reserve Description Amount Information Systems Replacement Fund 16,329$ ($134,555 Total Assets) Totals:16,329$ 29 SCHEDULE GF-M FUEL & ROUTINE VEHICLE & GENERATOR MAINTENANCE COSTS 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.14.50 $48.51 $3.35 Generator Maintenance $1,000 Dodge Dakota 455.17 $1,496.78 $3.29 Dump Truck 263.10 $945.82 $3.59 2004 Chevy 553.20 $1,993.57 $3.60 2007 Dodge 2500 1,165.88 $3,818.54 $3.28 2002 Ford 1,245.34 $4,105.40 $3.30 2011 Ford F 150 Ext. Cab 424.85 $1,272.14 $2.99 2012 Ford crew cab 847.78 $2,797.92 $3.30 MISC Diesel 409.00 $1,466.45 $3.59 250 kw Generator 1,200.00 $4,320.00 $3.60 Total Fuel and Lube:$29,173 Average:6578.82 $22,265.13 $3.39 7236.70 $26,973 $3.73 10% Increase Wastewater Department 2013 Chevy Ext Cab 1,607.54 $5,299.11 $3.30 2013 Chevy 2WD Reg Cab 1,526.82 $5,029.36 $3.29 Misc. WWTP 158.41 $520.62 $3.29 GMC 1 ton 29.09 $92.48 $3.18 Ford Backhoe 252.00 $907.65 $3.60 650 kw Generator 1,000.00 $3,600.00 $3.60 Gap Vax 1,002.60 $3,613.35 $3.60 No. Vehicles No./Year Total/Year Cost Each Total Amt. Camera Van 78.90 $245.15 $3.11 OIL CHANGES 9 4 36 $50 $1,800 Ford F 350 Ext. Cab Dually 1,156.09 $3,813.74 $3.30 OIL- GAP VAX 1 1 1 $1,200 $1,200 MISC Diesel 9.30 $33.48 $3.60 Generator Maintenance $1,770 Portable Generator 300.00 $1,080.00 $3.60 41 kw Generator @ Lift Station #1 500.00 $1,800.00 $3.60 AVERAGE:7620.75 $26,034.94 $3.42 Total Fuel and Lube:$36,328 8382.83 $31,558 $3.76 10% Increase Fire Department Vehicle U681 345.34 $1,146.90 $3.32 No. Vehicles No./Year Total/Year Cost Each Total Amt. Vehicle Q681 275.00 $988.11 $3.59 OIL CHANGES 3 1 3 $50 $150 Vehicle BRUS 681- Ford F-450 114.20 $411.44 $3.60 Vehicle ENG 681- Pierce 2007 1,379.50 $4,954.77 $3.59 Vehicle F Chief Exped 2009 335.47 $1,098.48 $3.27 Total Fuel and Lube:$10,454 AVERAGE:2449.51 $8,599.70 $3.48 2694.46 $10,304 $3.82 10% Increase 30 SCHEDULE TAX_ASSESS TAX RATE AND PID ASSESSMENT & SURCHARGE CALCULATIONS FIRE TAX/ASSESSMENT RATE OVERALL TAX RATE FY 2015:$0.13339 NET TAX VALUE TARRANT COUNTY:294,312,465 Revised certified values 8/28/14 DENTON COUNTY:835,270,435 DENTON CO. PID:462,597,909 REQUIRED REVENUE TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 FIRE Vals/100 =15,921,808.09 FY 2015 Tax/Assess Rate =0.07727 1,230,320 TAX COMPARISON TO FY 2014 Revenue from MUD Tax =872,859$ 2014 2015 Revenue from PID Assess =357,462$ O&M (General Fund) Tax 0.00935 0.01486 Total:1,230,320$ I & S (Debt Service) Tax 0.03666 0.04126 Fire Tax 0.08738 0.07727 O&M TAX/SURCHARGE RATE Total Tax Rate:0.13339 0.13339 NET TAX VALUE Increase/Decrease:0.00000 TARRANT COUNTY:294,312,465 DENTON COUNTY:835,270,435 PID Fire Assessment Rate 0.08738 0.07727 DENTON CO. PID:462,597,909 Reduction:-0.01011 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 O&M Vals/100 =15,921,808.09 FY 2015 Tax/Surcharge Rate =0.01486 236,600 Revenue from MUD Tax =167,857$ Revenue from PID Surcharge =68,743$ Total:236,600$ I&S TAX/SURCHARGE RATE NEW DEBT: CALCULATE AMOUNT DUE FROM PID NET TAX VALUE TARRANT COUNTY:294,312,465 DENTON COUNTY:835,270,435 DENTON CO. PID:462,597,909 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 NEW DEBT (I&S)Vals/100 =15,921,808.09 FY 2015 PID Surcharge Rate =0.01411 NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE 224,595 Revenue from MUD Tax =159,340$ Revenue from PID Surcharge =65,255$ Total:224,595$ MUD DEBT: CALCULATE MUD TAX NET TAX VALUE TARRANT COUNTY:294,312,465 Surcharge per Connection Calculation DENTON COUNTY:835,270,435 No. PID Connections 08/31/14 1255 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Total Surcharge to be collected:133,997$ I&S MUD DEBT Vals/100 =11,295,829.00 Surcharge/Connection/Year $106.77 FY 2015 Tax Rate =0.04126 Surcharge/Connection/Month $8.90 466,019 Revenue from MUD Tax =466,019$ Revenue from PID = N/A -$ Total:466,019$ 31 April May JuneAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccounts Usage Accounts Usage Accounts Usage Accounts Usage 1,000 to 1,000 5.4%0.1%6.3%0.2%7.7%0.3%8.6%0.4%10.6%0.6%7.7%0.3%6.8%0.2%5.7%0.1%5.0%0.1%5.1%0.2%4.0%0.0%4.5%0.1% 2,000 to 2,000 2.6%0.2%4.2%0.5%5.4%0.9%5.7%1.2%8.2%1.9%4.9%0.9%3.7%0.5%2.7%0.3%1.6%0.1%1.5%0.1%1.2%0.1%1.5%0.1% 3,000 to 3,000 3.1%0.4%5.7%1.1%7.1%1.8%8.3%2.6%10.9%3.9%7.3%2.0%5.1%1.1%2.9%0.5%2.0%0.2%1.3%0.1%1.1%0.1%1.8%0.2% 4,000 to 4,000 3.8%0.7%6.5%1.7%8.9%3.0%10.8%4.5%13.8%6.5%9.2%3.4%6.2%1.8%3.8%0.8%2.2%0.4%1.4%0.2%1.2%0.1%1.7%0.2% 5,000 to 5,000 3.7%0.9%6.1%2.0%9.6%4.1%11.0%5.7%11.6%6.9%8.8%4.0%5.9%2.1%4.0%1.1%2.2%0.5%1.6%0.3%1.2%0.2%1.6%0.3% 6,000 to 6,000 3.6%1.0%6.1%2.4%8.2%4.1%10.4%6.4%9.8%7.0%7.8%4.2%6.0%2.5%3.9%1.3%2.6%0.6%1.4%0.3%1.1%0.2%1.8%0.4% 7,000 to 7,000 3.8%1.2%5.8%2.6%7.2%4.3%8.6%6.2%6.9%5.7%6.8%4.2%5.5%2.7%3.8%1.4%2.6%0.7%1.5%0.4%1.1%0.2%2.0%0.5% 8,000 to 8,000 3.6%1.3%4.9%2.5%6.4%4.3%7.0%5.7%5.8%5.4%5.7%4.0%5.4%3.0%3.7%1.6%2.7%0.9%1.8%0.5%1.3%0.3%1.9%0.5% 9,000 to 9,000 3.8%1.6%4.6%2.6%5.4%4.1%5.2%4.8%4.1%4.3%5.1%4.0%5.3%3.3%4.6%2.1%2.8%1.0%1.9%0.6%1.4%0.4%2.3%0.7% 10,000 to 14,000 13.1%6.9%14.2%9.8%13.0%12.6%10.4%12.3%8.0%10.5%11.8%12.6%13.8%11.6%13.7%8.0%12.1%5.9%8.7%3.5%7.0%2.4%9.8%4.1% 15,000 to 17,000 13.0%8.7%11.2%10.1%8.0%9.2%6.2%8.5%4.2%6.9%9.5%10.0%11.3%10.5%12.8%9.6%10.6%6.1%9.5%4.7%6.8%2.9%10.1%5.2% 18,000 to 20,000 6.1%5.0%4.3%4.7%1.9%3.0%1.0%2.0%1.0%2.2%1.6%3.1%3.3%4.7%6.1%5.5%6.1%4.6%6.1%3.8%5.6%3.1%6.3%4.3% 21,000 to 25,000 11.3%10.7%7.7%9.9%4.5%7.6%2.5%5.1%1.9%4.5%5.7%8.4%8.7%11.0%11.8%12.5%13.1%10.4%14.1%9.7%11.8%7.2%14.1%10.4% 26,000 to 29,000 7.2%8.3%3.7%5.8%2.0%4.1%1.1%2.7%0.5%1.6%2.7%4.6%4.5%6.7%6.5%8.4%9.2%8.8%9.8%8.1%9.6%6.8%10.5%9.0% 30,000 to 34,000 5.3%7.3%2.4%4.5%1.3%3.1%0.7%2.1%0.5%1.8%1.7%3.6%2.8%5.1%4.6%7.1%8.1%9.1%9.5%9.1%10.1%8.4%8.6%8.7% 35,000 to 39,000 3.1%5.0%1.7%3.7%0.6%1.6%0.4%1.2%0.2%1.0%0.8%2.1%1.7%3.7%3.0%5.4%4.9%6.3%6.7%7.5%8.0%7.5%6.1%7.2% 40,000 to 44,000 1.8%3.3%0.9%2.2%0.3%1.2%0.2%1.0%0.3%1.3%0.5%1.4%0.7%1.8%1.6%3.2%3.4%5.0%4.8%6.1%6.1%6.5%4.3%5.7% 45,000 to 50,000 1.2%2.6%0.6%1.6%0.3%1.1%0.2%0.9%0.1%0.7%0.3%1.2%0.6%1.8%1.1%2.4%2.6%4.3%3.7%5.3%5.3%6.4%3.1%4.7% 51,000 to 59,000 1.0%2.4%0.5%1.6%0.3%1.5%0.1%0.8%0.2%1.2%0.3%1.1%0.5%1.6%0.9%2.4%1.8%3.4%2.5%4.1%4.1%5.7%2.5%4.3% 60,000 to 69,000 0.7%1.9%0.5%2.0%0.3%1.6%0.2%1.1%0.2%1.2%0.2%1.1%0.4%1.5%0.6%1.8%1.3%2.7%2.1%4.0%4.2%6.3%1.7%3.4% 70,000 +2.9%30.8%2.3%28.5%1.5%26.5%1.5%24.6%1.2%25.2%1.6%23.6%1.6%22.8%2.4%24.5%3.4%28.9%4.6%31.4%7.7%35.3%4.2%30.1% 100.0%100.2%100.1%99.9%99.8%100.0%100.1%99.9%100.0%100.2%100.1%99.8%100.0%100.0%100.2%100.0%100.1%99.9%99.9%100.0%100.0%100.0%100.1%100.2% WATER USE % BY 8.8%6.6%4.9%3.9%3.4%4.8%6.1%8.1%11.0%13.3%16.3%12.7%100.1% MONTH 3 YEAR AVERAGE PER MONTH October November December January February March April May June July August September 81,039,000 60,909,000 45,352,333 36,387,000 31,664,333 44,535,000 56,168,000 75,156,000 101,938,667 122,582,000 150,233,000 116,577,333 Usage Groups TOTAL 3 YEAR AVERAGE PERCENT USE October November December January February March July August September 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 1,000 to 1,000 184 64,000 205 78,000 243 102,000 262 102,000 419 225,000 182 56,000 199 69,000 192 70,000 158 46,000 170 51,000 150 49,000 144 50,000 2,000 to 2,000 106 212,000 162 324,000 159 318,000 159 318,000 279 558,000 105 210,000 92 184,000 102 204,000 57 114,000 58 116,000 43 86,000 56 112,000 3,000 to 3,000 120 360,000 235 705,000 225 675,000 222 666,000 365 1,095,000 139 417,000 117 351,000 136 408,000 50 150,000 47 141,000 31 93,000 46 138,000 4,000 to 4,000 181 724,000 248 992,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,000 146 730,000 246 1,230,000 308 1,540,000 340 1,700,000 411 2,055,000 214 1,070,000 125 625,000 182 910,000 50 250,000 57 285,000 36 180,000 42 210,000 6,000 to 6,000 125 750,000 237 1,422,000 266 1,596,000 351 2,106,000 349 2,094,000 208 1,248,000 142 852,000 177 1,062,000 69 414,000 52 312,000 30 180,000 58 348,000 7,000 to 7,000 155 1,085,000 227 1,589,000 232 1,624,000 282 1,974,000 224 1,568,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,000 119 952,000 178 1,424,000 201 1,608,000 257 2,056,000 202 1,616,000 187 1,496,000 158 1,264,000 158 1,264,000 81 648,000 65 520,000 32 256,000 57 456,000 9,000 to 9,000 145 1,305,000 151 1,359,000 185 1,665,000 214 1,926,000 139 1,251,000 192 1,728,000 165 1,485,000 163 1,467,000 75 675,000 58 522,000 40 360,000 57 513,000 10,000 to 14,000 571 6,828,000 622 7,353,000 594 6,930,000 543 6,240,000 316 3,558,000 718 8,481,000 675 8,044,000 674 8,012,000 450 5,465,000 362 4,423,000 196 2,352,000 348 4,233,000 15,000 to 17,000 333 5,282,000 223 3,528,000 190 3,012,000 116 1,834,000 88 1,388,000 308 4,882,000 389 6,227,000 332 5,310,000 317 5,079,000 280 4,483,000 153 2,469,000 257 4,122,000 18,000 to 20,000 266 5,048,000 187 3,553,000 125 2,375,000 82 1,532,000 35 655,000 207 3,906,000 289 5,460,000 122 4,396,000 334 6,342,000 303 5,743,000 167 3,181,000 311 5,912,000 21,000 to 25,000 316 7,230,000 158 3,609,000 114 2,617,000 73 1,642,000 22 506,000 221 5,012,000 320 7,279,000 278 6,352,000 477 10,934,000 442 10,139,000 351 8,080,000 530 12,174,000 26,000 to 29,000 163 4,458,000 62 1,685,000 62 1,699,000 29 794,000 15 413,000 96 2,621,000 161 4,426,000 134 3,654,000 301 8,280,000 322 8,835,000 315 8,677,000 332 9,111,000 30,000 to 34,000 138 4,396,000 60 1,920,000 29 917,000 24 758,000 8 251,000 68 2,148,000 114 3,615,000 109 3,464,000 286 9,074,000 311 9,889,000 373 11,924,000 315 10,100,000 35,000 to 39,000 63 2,316,000 32 1,163,000 21 768,000 101 370,000 8 299,000 32 1,170,000 62 2,273,000 54 1,961,000 192 7,065,000 250 9,188,000 303 11,224,000 238 8,771,000 40,000 to 44,000 39 1,623,000 15 626,000 10 420,000 7 301,000 7 290,000 25 1,038,000 32 1,349,000 34 1,415,000 121 5,055,000 168 7,063,000 248 10,412,000 166 6,947,000 45,000 to 50,000 38 1,799,000 8 384,000 15 711,000 8 383,000 5 235,000 18 860,000 26 1,226,000 27 1,269,000 94 4,410,000 126 5,961,000 230 10,889,000 153 7,230,000 51,000 to 59,000 32 1,752,000 25 1,362,000 14 776,000 8 444,000 7 371,000 14 753,000 23 1,251,000 17 926,000 71 3,856,000 110 5,991,000 260 14,266,000 105 5,711,000 60,000 to 69,000 13 843,000 18 1,171,000 10 660,000 10 645,000 7 459,000 10 647,000 14 882,000 14 883,000 39 2,487,000 63 4,010,000 154 9,809,000 74 4,722,000 70,000 +83 24,735,000 62 18,216,000 58 15,220,000 48 10,536,000 39 7,311,000 63 14,370,000 58 14,879,000 69 16,819,000 114 30,628,000 165 38,939,000 362 73,821,000 148 42,464,000 TOTAL 3,336 72,492,000 3,361 53,693,000 3,370 46,469,000 3,462 37,631,000 3,386 27,962,000 3,400 54,267,000 3,433 63,207,000 3,331 61,805,000 3,481 101,774,000 3,502 117,124,000 3,545 168,709,000 3,543 123,910,000 WATER USE PER METER 21,730 15,975 13,789 10,870 8,258 15,961 18,412 18,554 29,237 33,445 47,591 34,973 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 1,000 to 1,000 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,000 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,000 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,000 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,000 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,000 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,000 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,000 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,000 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,000 634 7,644,000 619 7,266,000 582 6,725,000 399 4,536,000 424 4,874,000 517 6,001,000 686 8,070,000 608 7,334,000 537 6,475,000 368 4,481,000 355 4,283,000 510 6,176,000 15,000 to 17,000 395 6,311,000 228 3,626,000 155 2,470,000 101 1,605,000 85 1,336,000 144 2,292,000 283 4,509,000 402 6,417,000 332 5,335,000 289 4,621,000 268 4,313,000 372 5,956,000 18,000 to 20,000 339 6,428,000 188 3,561,000 104 1,970,000 51 958,000 58 1,094,000 94 1,786,000 191 3,630,000 382 7,249,000 350 6,653,000 332 6,321,000 302 5,747,000 360 6,832,000 21,000 to 25,000 383 8,879,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 26,000 to 29,000 238 6,486,000 88 2,405,000 36 988,000 13 350,000 18 498,000 20 548,000 52 1,423,000 259 7,074,000 298 8,152,000 347 9,536,000 387 10,664,000 315 8,642,000 30,000 to 34,000 198 6,303,000 75 2,382,000 26 833,000 18 572,000 16 501,000 27 858,000 44 1,394,000 204 6,473,000 326 10,403,000 389 12,408,000 378 12,037,000 284 9,023,000 35,000 to 39,000 105 3,869,000 37 1,359,000 14 518,000 6 222,000 10 372,000 15 548,000 32 1,182,000 132 4,863,000 191 7,019,000 270 9,951,000 296 10,919,000 185 6,833,000 40,000 to 44,000 61 2,538,000 24 1,002,000 12 509,000 7 292,000 8 343,000 7 290,000 12 508,000 92 3,838,000 125 5,216,000 178 7,451,000 226 9,472,000 124 5,167,000 45,000 to 50,000 41 1,943,000 20 939,000 10 477,000 4 185,000 3 139,000 7 334,000 17 804,000 65 3,050,000 120 5,670,000 176 8,370,000 192 9,087,000 100 4,724,000 51,000 to 59,000 44 2,400,000 15 832,000 16 874,000 4 217,000 8 454,000 6 332,000 13 724,000 42 2,290,000 93 5,058,000 122 6,641,000 149 8,093,000 85 4,618,000 60,000 to 69,000 22 1,399,000 11 708,000 8 516,000 5 325,000 9 559,000 7 461,000 8 506,000 31 2,010,000 44 2,807,000 78 4,974,000 105 6,705,000 40 2,559,000 70,000 +108 26,009,000 70 16,426,000 54 10,641,000 43 7,686,000 34 7,462,000 40 8,174,000 50 10,668,000 89 18,441,000 139 37,838,000 186 50,837,000 217 54,013,000 122 33,892,000 TOTAL 3,560 85,043,000 3,600 54,366,000 3,660 41,249,000 3,677 31,172,000 3,708 32,095,000 3,766 35,885,000 3,757 47,464,000 3,807 85,018,000 3,833 115,454,000 3,858 140,148,000 3,880 149,614,000 3,874 110,109,000 WATER USE PER METER 23,888 15,102 11,270 8,478 8,656 9,529 12,633 22,332 30,121 36,327 38,560 28,423 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 2013 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 1,000 to 1,000 225 88,000 211 87,000 282 151,000 273 124,000 357 187,000 306 136,000 245 104,000 240 83,000 206 75,000 217 53,000 184 53,000 186 57,000 2,000 to 2,000 104 208,000 96 192,000 238 476,000 198 396,000 343 686,000 200 400,000 160 320,000 112 224,000 77 154,000 76 152,000 59 118,000 44 88,000 3,000 to 3,000 118 354,000 132 396,000 287 861,000 292 876,000 467 1,401,000 324 972,000 199 597,000 117 351,000 111 333,000 62 186,000 56 168,000 73 219,000 4,000 to 4,000 125 500,000 155 620,000 337 1,348,000 381 1,524,000 606 2,424,000 405 1,620,000 261 1,044,000 155 620,000 126 504,000 62 248,000 69 276,000 60 240,000 5,000 to 5,000 160 800,000 177 885,000 367 1,835,000 432 2,160,000 457 2,285,000 409 2,045,000 274 1,370,000 161 805,000 147 735,000 78 390,000 63 315,000 63 315,000 6,000 to 6,000 150 900,000 180 1,080,000 309 1,854,000 443 2,658,000 361 2,166,000 330 1,980,000 270 1,620,000 164 984,000 148 888,000 73 438,000 64 384,000 64 384,000 7,000 to 7,000 159 1,113,000 176 1,232,000 282 1,974,000 387 2,709,000 272 1,904,000 311 2,177,000 277 1,939,000 169 1,183,000 148 1,036,000 81 567,000 49 343,000 93 651,000 8,000 to 8,000 152 1,216,000 175 1,400,000 259 2,072,000 311 2,488,000 211 1,688,000 232 1,856,000 242 1,936,000 154 1,232,000 136 1,088,000 102 816,000 60 480,000 84 672,000 9,000 to 9,000 136 1,224,000 178 1,602,000 215 1,935,000 209 1,881,000 144 1,296,000 206 1,854,000 251 2,259,000 206 1,854,000 158 1,422,000 97 873,000 76 684,000 106 954,000 10,000 to 14,000 713 8,543,000 828 9,891,000 711 8,366,000 621 7,190,000 368 4,258,000 663 7,723,000 777 9,055,000 841 10,110,000 828 9,922,000 626 7,634,000 446 5,423,000 598 7,179,000 15,000 to 17,000 396 6,323,000 389 6,175,000 201 3,190,000 122 1,952,000 120 1,903,000 207 3,286,000 290 4,638,000 400 6,371,000 399 6,346,000 412 6,591,000 325 5,244,000 440 7,055,000 18,000 to 20,000 340 6,446,000 301 5,684,000 107 2,015,000 64 1,211,000 60 1,141,000 98 1,844,000 198 3,749,000 332 6,266,000 373 7,066,000 401 7,617,000 376 7,143,000 406 7,708,000 21,000 to 25,000 362 8,273,000 340 7,768,000 127 2,887,000 68 1,539,000 73 1,636,000 138 3,119,000 237 5,385,000 375 8,571,000 429 9,761,000 589 13,501,000 579 13,318,000 632 14,499,000 26,000 to 29,000 207 5,678,000 152 4,169,000 61 1,671,000 32 885,000 18 497,000 47 1,280,000 114 3,122,000 186 5,075,000 252 6,862,000 324 8,903,000 373 10,229,000 347 9,547,000 30,000 to 34,000 181 5,763,000 122 3,848,000 41 1,305,000 20 641,000 21 661,000 30 939,000 69 2,200,000 163 5,186,000 195 6,180,000 295 9,363,000 398 12,651,000 305 9,692,000 35,000 to 39,000 107 3,952,000 90 3,305,000 15 556,000 13 476,000 9 327,000 19 701,000 44 1,610,000 101 3,739,000 102 3,757,000 195 7,198,000 265 9,730,000 196 7,201,000 40,000 to 44,000 73 3,037,000 49 2,067,000 8 338,000 10 420,000 13 549,000 11 461,000 19 793,000 51 2,122,000 72 3,012,000 130 5,457,000 184 7,697,000 136 5,681,000 45,000 to 50,000 60 2,851,000 32 1,505,000 9 425,000 9 420,000 4 196,000 12 560,000 15 715,000 26 1,229,000 48 2,252,000 92 4,364,000 168 7,955,000 92 4,347,000 51,000 to 59,000 32 1,749,000 32 1,743,000 10 551,000 5 283,000 10 554,000 8 439,000 17 942,000 38 2,064,000 40 2,176,000 64 3,513,000 134 7,284,000 73 3,961,000 60,000 to 69,000 18 1,160,000 17 1,079,000 13 849,000 5 307,000 2 130,000 4 248,000 10 624,000 14 898,000 13 850,000 45 2,869,000 73 4,683,000 42 2,683,000 70,000 +105 25,404,000 91 19,940,000 62 13,680,000 49 10,218,000 50 9,047,000 48 9,813,000 61 13,811,000 81 19,678,000 90 24,169,000 121 29,741,000 165 38,198,000 125 32,580,000 TOTAL 3,923 85,582,000 3,923 74,668,000 3,941 48,339,000 3,944 40,358,000 3,966 34,936,000 4,008 43,453,000 4,030 57,833,000 4,086 78,645,000 4,098 88,588,000 4,142 110,474,000 4,166 132,376,000 4,165 115,713,000 WATER USE PER METER 21,815 19,033 12,266 10,233 8,809 10,842 14,351 19,247 21,617 26,672 31,775 27,782 PER MONTH (GALLONS) MONTHLY RETAIL CUSTOMER AND WATER USE BY CATEGORY 2012 2012 2012 2013 2013 2013 2013 2013 2013 2013 2013 2013 SeptemberWATER USE October November December January CATEGORY February March July August 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 1,000 to 1,000 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,000 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,000 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,000 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,000 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,000 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,000 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,000 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,000 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,000 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 17,000 17.8%11.4%17.28%15.40%14.6%15.1%12.8%15.5%7.16%11.00%19.4%16.2%19.3%14.0%18.1%13.3%13.5%6.5%11.2%4.8%5.8%1.8%10.1%4.2% 18,000 to 20,000 0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0% 21,000 to 25,000 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.2%8.2%7.8%3.4%13.9%7.9% 26,000 to 29,000 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%15.0%10.8% 30,000 to 34,000 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,000 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,000 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 50,000 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% 51,000 to 59,000 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,000 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.0%1.38%25.99%2.2%25.9%2.0%22.0%2.4%26.8%4.1%27.0%6.4%31.3%13.5%40.8%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 1,000 to 1,000 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,000 1.9%0.2%5.2%0.7%5.4%1.0%7.4%1.8%7.6%1.8%6.7%1.4%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,000 2.8%0.4%6.8%1.4%7.3%1.9%10.8%3.8%10.2%3.6%9.8%3.1%7.1%1.7%2.0%0.3%1.7%0.2%1.1%0.1%1.2%0.1%2.3%0.2% 4,000 to 4,000 2.9%0.5%8.1%2.1%9.0%3.2%13.0%6.1%13.1%6.0%11.8%5.0%7.9%2.5%2.3%0.4%1.6%0.2%1.3%0.1%0.9%0.1%2.1%0.3% 5,000 to 5,000 2.5%0.5%6.5%2.2%10.4%4.6%11.8%7.0%11.3%6.5%9.8%5.2%7.3%2.9%2.8%0.6%1.7%0.3%1.5%0.2%1.2%0.2%2.2%0.4% 6,000 to 6,000 3.1%0.8%6.8%2.7%8.8%4.7%9.5%6.7%10.2%7.0%9.0%5.7%7.1%3.4%2.7%0.7%2.2%0.4%0.9%0.2%0.9%0.1%2.3%0.5% 7,000 to 7,000 2.8%0.8%6.3%2.9%7.6%4.7%7.8%6.4%7.3%5.9%6.8%5.0%6.0%3.3%2.3%0.7%2.1%0.5%1.3%0.2%1.1%0.2%2.2%0.5% 8,000 to 8,000 3.2%1.1%4.9%2.6%6.7%4.8%5.4%5.1%6.0%5.6%5.9%4.9%5.5%3.5%2.8%1.0%2.3%0.6%1.2%0.3%1.5%0.3%2.0%0.6% 9,000 to 9,000 3.7%1.4%4.8%2.8%5.3%4.2%4.0%4.3%4.6%4.7%4.5%4.3%5.0%3.5%3.9%1.6%2.3%0.7%1.8%0.4%1.2%0.3%2.7%0.8% 10,000 to 14,000 17.8%9.0%17.2%13.4%15.9%16.3%10.9%14.6%11.4%15.2%13.7%16.7%18.3%17.0%16.0%8.6%14.0%5.6%9.5%3.2%9.1%2.9%13.2%5.6% 15,000 to 17,000 11.1%7.4%6.3%6.7%4.2%6.0%2.7%5.1%2.3%4.2%3.8%6.4%7.5%9.5%10.6%7.5%8.7%4.6%7.5%3.3%6.9%2.9%9.6%5.4% 18,000 to 20,000 9.5%7.6%5.2%6.6%2.8%4.8%1.4%3.1%1.6%3.4%2.5%5.0%5.1%7.6%10.0%8.5%9.1%5.8%8.6%4.5%7.8%3.8%9.3%6.2% 21,000 to 25,000 10.8%10.4%5.2%7.9%3.2%6.4%1.5%3.9%1.3%3.5%2.0%4.8%4.3%7.8%12.8%13.2%12.9%9.8%13.9%8.8%13.7%8.2%13.2%10.7% 26,000 to 29,000 6.7%7.6%2.4%4.4%1.0%2.4%0.4%1.1%0.5%1.6%0.5%1.5%1.4%3.0%6.8%8.3%7.8%7.1%9.0%6.8%10.0%7.1%8.1%7.8% 30,000 to 34,000 5.6%7.4%2.1%4.4%0.7%2.0%0.5%1.8%0.4%1.6%0.7%2.4%1.2%2.9%5.4%7.6%8.5%9.0%10.1%8.9%9.7%8.0%7.3%8.2% 35,000 to 39,000 2.9%4.5%1.0%2.5%0.4%1.3%0.2%0.7%0.3%1.2%0.4%1.5%0.9%2.5%3.5%5.7%5.0%6.1%7.0%7.1%7.6%7.3%4.8%6.2% 40,000 to 44,000 1.7%3.0%0.7%1.8%0.3%1.2%0.2%0.9%0.2%1.1%0.2%0.8%0.3%1.1%2.4%4.5%3.3%4.5%4.6%5.3%5.8%6.3%3.2%4.7% 45,000 to 50,000 1.2%2.3%0.6%1.7%0.3%1.2%0.1%0.6%0.1%0.4%0.2%0.9%0.5%1.7%1.7%3.6%3.1%4.9%4.6%6.0%4.9%6.1%2.6%4.3% 51,000 to 59,000 1.2%2.8%0.4%1.5%0.4%2.1%0.1%0.7%0.2%1.4%0.2%0.9%0.3%1.5%1.1%2.7%2.4%4.4%3.2%4.7%3.8%5.4%2.2%4.2% 60,000 to 69,000 0.6%1.6%0.3%1.3%0.2%1.3%0.1%1.0%0.2%1.7%0.2%1.3%0.2%1.1%0.8%2.4%1.1%2.4%2.0%3.5%2.7%4.5%1.0%2.3% 70,000 +3.0%30.6%1.8%30.1%1.4%25.7%1.1%24.6%0.8%23.2%1.4%22.8%1.4%22.6%2.1%22.0%3.4%33.1%4.6%36.1%5.7%36.1%3.0%30.9% 100.0%100.0%99.9%99.9%99.9%99.9%99.9%99.9%99.9%100.0%100.3%100.0%100.1%100.1%99.8%100.3%99.8%100.3%99.8%99.8%100.1%100.0%99.9%100.1% 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 Year: FY 2013 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 1,000 to 1,000 5.7%0.1%5.4%0.1%7.2%0.3%6.9%0.3%9.0%0.5%7.6%0.3%6.1%0.2%5.9%0.1%5.0%0.1%5.2%0.0%4.4%0.0%4.5%0.0% 2,000 to 2,000 2.7%0.2%2.4%0.3%6.0%1.0%5.0%1.0%8.6%2.0%5.0%0.9%4.0%0.6%2.7%0.3%1.9%0.2%1.8%0.1%1.4%0.1%1.1%0.1% 3,000 to 3,000 3.0%0.4%3.4%0.5%7.3%1.8%7.4%2.2%11.8%4.0%8.1%2.2%4.9%1.0%2.9%0.4%2.7%0.4%1.5%0.2%1.3%0.1%1.8%0.2% 4,000 to 4,000 3.2%0.6%4.0%0.8%8.6%2.8%9.7%3.8%15.3%6.9%10.1%3.7%6.5%1.8%3.8%0.8%3.1%0.6%1.5%0.2%1.7%0.2%1.4%0.2% 5,000 to 5,000 4.1%0.9%4.5%1.2%9.3%3.8%11.0%5.4%11.5%6.5%10.2%4.7%6.8%2.4%3.9%1.0%3.6%0.8%1.9%0.4%1.5%0.2%1.5%0.3% 6,000 to 6,000 3.8%1.1%4.6%1.4%7.8%3.8%11.2%6.6%9.1%6.2%8.2%4.6%6.7%2.8%4.0%1.3%3.6%1.0%1.8%0.4%1.5%0.3%1.5%0.3% 7,000 to 7,000 4.1%1.3%4.5%1.6%7.2%4.1%9.8%6.7%6.9%5.4%7.8%5.0%6.9%3.4%4.1%1.5%3.6%1.2%2.0%0.5%1.2%0.3%2.2%0.6% 8,000 to 8,000 3.9%1.4%4.5%1.9%6.6%4.3%7.9%6.2%5.3%4.8%5.8%4.3%6.0%3.3%3.8%1.6%3.3%1.2%2.5%0.7%1.4%0.4%2.0%0.6% 9,000 to 9,000 3.5%1.4%4.5%2.1%5.5%4.0%5.3%4.7%3.6%3.7%5.1%4.3%6.2%3.9%5.0%2.4%3.9%1.6%2.3%0.8%1.8%0.5%2.5%0.8% 10,000 to 14,000 18.2%10.0%21.1%13.2%18.0%17.3%15.7%17.8%9.3%12.2%16.5%17.8%19.3%15.7%20.6%12.9%20.2%11.2%15.1%6.9%10.7%4.1%14.4%6.2% 15,000 to 17,000 10.1%7.4%9.9%8.3%5.1%6.6%3.1%4.8%3.0%5.4%5.2%7.6%7.2%8.0%9.8%8.1%9.7%7.2%9.9%6.0%7.8%4.0%10.6%6.1% 18,000 to 20,000 8.7%7.5%7.7%7.6%2.7%4.2%1.6%3.0%1.5%3.3%2.4%4.2%4.9%6.5%8.1%8.0%9.1%8.0%9.7%6.9%9.0%5.4%9.7%6.7% 21,000 to 25,000 9.2%9.7%8.7%10.4%3.2%6.0%1.7%3.8%1.8%4.7%3.4%7.2%5.9%9.3%9.2%10.9%10.5%11.0%14.2%12.2%13.9%10.1%15.2%12.5% 26,000 to 29,000 5.3%6.6%3.9%5.6%1.5%3.5%0.8%2.2%0.5%1.4%1.2%2.9%2.8%5.4%4.6%6.5%6.1%7.7%7.8%8.1%9.0%7.7%8.3%8.3% 30,000 to 34,000 4.6%6.7%3.1%5.2%1.0%2.7%0.5%1.6%0.5%1.9%0.7%2.2%1.7%3.8%4.0%6.6%4.8%7.0%7.1%8.5%9.6%9.6%7.3%8.4% 35,000 to 39,000 2.7%4.6%2.3%4.4%0.4%1.2%0.3%1.2%0.2%0.9%0.5%1.6%1.1%2.8%2.5%4.8%2.5%4.2%4.7%6.5%6.4%7.4%4.7%6.2% 40,000 to 44,000 1.9%3.5%1.2%2.8%0.2%0.7%0.3%1.0%0.3%1.6%0.3%1.1%0.5%1.4%1.2%2.7%1.8%3.4%3.1%4.9%4.4%5.8%3.3%4.9% 45,000 to 50,000 1.5%3.3%0.8%2.0%0.2%0.9%0.2%1.0%0.1%0.6%0.3%1.3%0.4%1.2%0.6%1.6%1.2%2.5%2.2%4.0%4.0%6.0%2.2%3.8% 51,000 to 59,000 0.8%2.0%0.8%2.3%0.3%1.1%0.1%0.7%0.3%1.6%0.2%1.0%0.4%1.6%0.9%2.6%1.0%2.5%1.5%3.2%3.2%5.5%1.8%3.4% 60,000 to 69,000 0.5%1.4%0.4%1.4%0.3%1.8%0.1%0.8%0.1%0.4%0.1%0.6%0.2%1.1%0.3%1.1%0.3%1.0%1.1%2.6%1.8%3.5%1.0%2.3% 70,000 +2.7%29.7%2.2%26.6%1.5%28.2%1.1%25.2%1.2%25.9%1.5%22.6%1.6%24.0%1.8%25.3%2.0%27.6%2.7%26.7%4.1%28.9%2.9%28.3% 100.0%100.0%99.9%99.9%99.9%99.9%99.9%99.9%99.9%100.0%100.3%100.0%100.1%100.1%99.8%100.3%99.8%100.3%99.8%99.8%100.1%100.0%99.9%100.1% WATER USE % BY MONTH PERCENTAGE USE BY CATEGORY 2012 2012 2012 2013 2013 2013 2013 2013 TOTAL 2013 2013 2013 2013 WATER USE October November December January February March July August September CATEGORY