Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2016-0812 Budget Workshop Complete Agenda Packet
BOARD OF DIRECTORS Special Meeting Agenda TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 August 12, 2016 9:00 a.m. Svore Municipal Boardroom SPECIAL MEETING BUDGET WORKSHOP CALL TO ORDER AND ANNOUNCE A QUORUM CITIZEN COMMENTS This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda. The Board is not permitted to take action on or discuss any presentations made to the Board at this time concerning an item not listed on the agenda. The Board will hear presentations on specific agenda items prior to the Board addressing those items. You may speak up to three (3) minutes or the time limit determined by the President or presiding officer. SPECIAL SESSION 1. Consider and take appropriate action regarding FY 2017 draft budget. attachment: draft budget for FY 2017 ADJOURN CERTIFICATION THE STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § THIS NOTICE CERTIFIES THAT BY 9:00 A.M. ON AUGUST 9, 2016 A COPY OF THE ABOVE AGENDA OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS SPECIAL MEETING TO BE HELD ON FRIDAY, AUGUST 12, 2016 AT 9:00 A.M., WAS POSTED ON THE FRONT WINDOW OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, ADMINISTRATION BUILDING LOCATED AT 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS, WHICH IS A PLACE CONVENIENT TO THE PUBLIC AND WITHIN THE BOUNDARIES OF THE DISTRICT AND NOTIFICATION WAS POSTED TO THE DISTRICT WEBSITE, IN ACCORDANCE WITH SECTION 49.063 OF THE WATER CODE AND SECTION 551.054 OF THE TEXAS GOVERNMENT CODE, AS AMENDED. Laurie Slaght, District Secretary Trophy Club Municipal Utility District No. 1 1 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T General Fund Fire Fund Tax Debt Service Fund Revenue Debt Service Fund Revenue 9,350,213 Revenue 21,075 Revenue 216,894 Revenue 892,849 FY 2017 Tax Collections 60,977 FY 2017 Tax Collections 1,035,810 FY 2017 Tax Collections 678,836 FY 2017 PID Surcharges 148,291 FY 2017 PID Assessment 472,439 PID Surcharge 120,492 Reserve Funds 0 Reserve Funds 0 Total Revenue 9,559,480 Total Revenue 1,529,324 Total Revenue 1,016,223 Total Revenue 892,849 Water Expense 5,336,780 Fire Expense 1,529,324 Debt Service Expense 1,013,133 Debt Service Expense 892,649 Wastewater Expense 2,676,015 Board of Directors Expense 26,338 Administration Expense 1,331,571 Non-Departmental Expense 188,775 Total Expense 9,559,480 Total Expense 1,529,324 Total Expense 1,013,133 Total Expense 892,649 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 3,090 Net Budget Surplus/Deficit 200 2017 Property Value Summary Tax Rate Summary MUD Tarrant Co.367,203,860 2016 2017 MUD Denton Co.1,024,172,857 O&M (General Fund) Tax 0.00472 0.00438 PID 634,300,287 I & S (Debt Service) Tax 0.05420 0.04839 Out of District & PID 314,500 Fire Tax 0.07222 0.07445 Total Value:2,025,991,504 Total Tax Rate:0.13114 0.12722 Increase/Decrease:-0.00392 PID Fire Assessment Rate 0.07222 0.07445 Increase/Decrease:0.00223 Budget Summary TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 FY 2017 BUDGET DRAFT - AUGUST 12, 2016 Trophy Club Municipal Utility District No. 1 2 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 FY 2017 BUDGET DRAFT-AUGUST 12, 2016 GENERAL FUND Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2017 thru 6/30/16 Comments General Fund Revenues 135-40000-000-000 Property Taxes 58,181 58,181 60,977 56,878 SEE SCHEDULE TAX_ASSESS 135-40002-000-000 Property Taxes/Delinquent 0 0 0 1,275 135-40015-000-000 Property Taxes/P & I 650 650 650 499 135-40025-000-000 PID Surcharges 146,125 146,125 148,291 0 SEE SCHEDULE TAX_ASSESS 135-47000-000-000 Water 5,080,244 5,080,244 6,436,734 2,537,934 SEE SCHEDULE GF-D 135-47005-000-000 Sewer 2,413,776 2,413,776 2,629,524 1,575,870 SEE SCHEDULE GF-E 135-47025-000-000 Penalties 90,985 90,985 119,260 71,465 SEE SCHEDULE GF-D 135-47030-000-000 Service Charges (Disconnect Fees)9,000 9,000 11,400 10,675 SEE SCHEDULE GF-D 135-47035-000-000 Plumbing Inspections 2,000 2,000 2,000 2,100 135-47045-000-000 Sewer Inspections 5,500 5,500 5,500 6,150 135-47070-000-000 TCCC Effluent Charges 61,330 61,330 61,188 12,542 SEE SCHEDULE GF-E 135-48005-000-000 Utility Fees 69,000 55,200 0 55,200 COMPLETION OF SCHEDULED UNITS 135-48010-000-000 Utility Billing Contract 0 0 14,400 0 TOWN OF TROPHY CLUB UTILITY BILLING CONTRACT $1200 MONTHLY 135-49010-000-000 Interest Income 6,000 10,000 8,001 9,428 LESS INTEREST INCOME PROJECTED 135-49016-000-000 Cell Tower Revenue 10,926 10,926 10,926 8,195 $910.53 PER MONTH 135-49018-000-000 Building Rent Income 7,000 7,000 7,000 5,250 $583.33 PER MONTH: COLLECTION BARN RENT FROM TOWN 135-49026-000-000 Proceeds from Sale of Assets 0 30,935 2,000 30,935 2007 DODGE 2500 TRUCK ESTIMATED SALVAGE $2,000 135-49035-000-000 Prior Year Reserves 8,020 548,668 0 0 135-49075-000-000 Oversize Meter Reimbursement 15,778 15,778 21,609 43,906 SEE SCHEDULE GF-D 135-49141-000-000 Interfund Transfer In 0 0 0 8,034 135-49900-000-000 Miscellaneous Income 63,249 63,249 20,000 28,744 SCRAP SALES;UTILITY BILLING MISCELLANEOUS CHARGES 135-49901-000-000 Records Management Revenue 20 20 20 28 REDUCED REVENUE 135-49903-000-000 Recovery of Prior Year Expense 0 0 0 0 Total 8,047,784 8,609,567 9,559,480 4,465,107 General Fund Expenses Water & Distribution 135-50005-010-000 Salaries & Wages 265,614 260,062 271,143 151,273 SEE SCHEDULE GF-H 135-50010-010-000 Overtime 19,500 19,500 19,500 10,030 SEE SCHEDULE GF-H 135-50016-010-000 Longevity 2,945 2,945 3,270 2,945 SEE SCHEDULE GF-H 135-50017-010-000 Certification 4,200 3,600 4,800 1,725 SEE SCHEDULE GF-H 135-50020-010-000 Retirement 25,558 25,018 27,151 14,596 SEE SCHEDULE GF-J 135-50026-010-000 Medical Insurance 51,398 51,398 55,914 27,943 SEE SCHEDULE GF-I 135-50027-010-000 Dental Insurance 3,999 3,999 4,159 2,102 SEE SCHEDULE GF-I 135-50028-010-000 Vision Insurance 910 910 910 473 SEE SCHEDULE GF-I 135-50029-010-000 Life Insurance & Other 2,803 2,803 2,803 1,759 SEE SCHEDULE GF-I 135-50030-010-000 Social Security Taxes 18,563 18,144 19,021 10,207 SEE SCHEDULE GF-H 135-50035-010-000 Medicare Taxes 4,341 4,243 4,448 2,387 SEE SCHEDULE GF-H 135-50040-010-000 Unemployment Taxes 1,242 1,026 1,026 859 SEE SCHEDULE GF-H 135-50045-010-000 Workman's Compensation 14,754 14,754 13,152 8,750 TML INVOICE AMOUNT 135-50060-010-000 Pre-emp Physicals/Testing 1,300 1,300 1,300 236 135-50070-010-000 Employee Relations 300 300 300 75 135-55005-010-000 Engineering 5,000 109,400 5,000 48,920 135-55080-010-000 Maintenance & Repairs 85,000 99,500 100,000 67,907 ADDITIONAL INFRASTRUCTURE MAINTENANCE 135-55085-010-000 Generator Maintenance & Repairs 0 0 3,000 0 MAINTENANCE & REPAIRS ON WATER GENERATOR 135-55090-010-000 Vehicle Maintenance 8,000 8,000 8,000 3,560 Trophy Club Municipal Utility District No. 1 3 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 FY 2017 BUDGET DRAFT-AUGUST 12, 2016 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2017 thru 6/30/16 Comments 135-55105-010-000 Maintenance-Heavy Equipment 3,500 3,500 3,500 2,893 135-55135-010-000 Lab Analysis - MUD 5,500 5,500 5,500 3,007 MONTHLY BAC T; QUARTERLY TCEQ SAMPLES 135-60010-010-000 Communications/Pagers/Mobiles 5,400 5,400 5,400 3,329 INCREASE IN COSTS 135-60020-010-000 Electricity 166,823 166,823 172,737 88,487 SEE SCHEDULE GF-K 135-60066-010-000 Publications/Books/Subscripts 500 500 750 716 135-60070-010-000 Dues & Memberships 500 500 500 11 135-60080-010-000 Schools & Training 5,773 5,773 4,222 1,520 SEE SCHEDULE GF-G 135-60090-010-000 Safety Program 400 400 400 249 135-60100-010-000 Travel & per diem 1,400 1,400 1,500 87 SEE SCHEDULE GF-G 135-60105-010-000 Rent/Lease Equipment 1,500 1,500 1,500 325 EMERGENCY EQUIPMENT RENTAL IF NEEDED 135-60135-010-000 TCEQ Fees & Permits - MUD 49,275 49,275 50,176 13,175 REG. ASSESSMENT ($22,500), WATER SYSTEM FEES ($7,676) & NTGW WELL FEES ($20,000) 135-60150-010-000 Wholesale Water 2,948,742 2,948,742 2,998,802 1,150,441 SEE SCHEDULE GF-C 135-60245-010-000 Miscellaneous Expenses 200 200 200 0 135-60280-010-000 Property Maintenance 3,500 3,500 5,000 2,281 MORE PROPERTY REPAIRS AFTER LINE BREAKS 135-60285-010-000 Lawn Equipment & Maintenance 250 250 14,750 0 MOWING $14,500 135-60332-010-000 Interfund Transfer Out- Revenue I&S 0 0 297,011 0 SEE SCHEDULE GF-B: FUNDS TO TRANSER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS 135-60333-010-000 Interfund Transfer Out- Debt Reserve 0 0 64,920 0 TRANSFER FOR BOND RESERVE 135-60334-010-000 Interfund Transfer Out-Bank Reserve Account 0 0 200,000 0 TRANSFER FOR BANK RESERVE ACCOUNT 135-60360-010-000 Furniture/Equipment < $5000 2,500 2,500 2,500 0 135-65005-010-000 Fuel & Lube 35,947 35,947 33,011 10,170 SEE SCHEDULE GF-M 135-65010-010-000 Uniforms 4,608 4,608 4,608 2,007 SEE SCHEDULE GF-F 135-65030-010-000 Chemicals 12,000 13,000 20,000 9,909 AMMONIA NEEDED FOR NEW SYSTEM 135-65035-010-000 Small Tools 1,200 1,200 1,200 130 135-65040-010-000 Safety Equipment 1,000 1,000 1,000 443 135-65050-010-000 Meter Expense 115,000 115,000 115,000 96,803 135-65053-010-000 Meter Change Out Program 50,000 77,325 81,500 77,325 FY 17 METER REPLACEMENTS, PROFILE HEAD REPLACEMENTS 225 @$140 EACH, METER TESTING 15 @ $115 EACH 135-69005-010-000 Capital Outlays 201,000 400,250 502,421 339,616 SEE SCHEDULE GF-A 135-69008-010-000 Short Term Debt-Principal 130,720 130,720 0 130,700 SEE SCHEDULE GF-B 135-69009-010-000 Short Term Debt-Interest 1,209 1,209 0 1,178 SEE SCHEDULE GF-B 135-69195-010-000 Gasb34/Reserve for Replacement 75,000 75,000 75,000 75,000 1/10 MAJOR MAINTENANCE COST TOWN'S ELEVATED STORAGE TANK $45,000 135-69281-010-000 Tank Inspection Contract 126,958 126,958 118,774 126,958 ANNUAL MAINTENANCE CONTRACT 135-55135-010-001 Lab Analysis - PID 5,000 5,000 5,000 1,198 PID PORTION 135-60135-010-001 TCEQ Fees & Permits- PID 5,000 5,000 5,000 0 WATER SYSTEM FEES ($2.45/CONNECTION) AND OTHER Subtotal Water 4,475,834 4,814,885 5,336,780 2,493,703 135-50005-020-000 Salaries & Wages 351,671 351,671 391,102 253,937 SEE SCHEDULE GF-H 135-50010-020-000 Overtime 19,500 29,500 29,500 24,904 SEE SCHEDULE GF-H 135-50016-020-000 Longevity 6,125 6,125 6,635 6,125 SEE SCHEDULE GF-H 135-50017-020-000 Certification 7,200 7,200 7,800 5,525 SEE SCHEDULE GF-H 135-50020-020-000 Retirement 33,652 33,652 39,584 25,535 SEE SCHEDULE GF-J 135-50026-020-000 Medical Insurance 65,989 65,989 73,022 47,329 SEE SCHEDULE GF-I 135-50027-020-000 Dental Insurance 4,184 4,184 4,592 2,902 SEE SCHEDULE GF-I 135-50028-020-000 Vision Insurance 972 972 1,031 657 SEE SCHEDULE GF-I 135-50029-020-000 Life Insurance & Other 3,655 3,655 4,485 3,051 SEE SCHEDULE GF-I 135-50030-020-000 Social Security Taxes 24,665 24,665 27,886 16,381 SEE SCHEDULE GF-H 135-50035-020-000 Medicare Taxes 5,768 5,768 6,522 3,831 SEE SCHEDULE GF-H 135-50040-020-000 Unemployment Taxes 1,449 1,204 1,197 1,204 SEE SCHEDULE GF-H 135-50045-020-000 Workman's Compensation 9,317 9,317 11,347 4,673 TML INVOICE AMOUNT Wastewater Trophy Club Municipal Utility District No. 1 4 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 FY 2017 BUDGET DRAFT-AUGUST 12, 2016 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2017 thru 6/30/16 Comments 135-50060-020-000 Pre-emp Physicals/Testing 300 300 300 238 135-50070-020-000 Employee Relations 650 650 650 420 135-55070-020-000 Independent Labor 50,000 50,000 20,000 24,133 POTENTIAL EMERGENCY WW/COLLECTION 135-55005-020-000 Engineering 0 0 70,000 0 SEWER SYSTEM STUDY 135-55080-020-000 Maintenance & Repairs 72,600 83,100 83,100 79,861 135-55085-020-000 Generator Maintenance & Repairs 0 0 20,000 0 MAINTENANCE & REPAIRS ON WW GENERATOR; 3 QUICK CONNECTS AT LIFT STATIONS $15,000 135-55090-020-000 Vehicle Maintenance 5,000 7,500 4,000 6,182 LOWER DUE TO SPLIT OF SOME VEHICLE MAINTENANCE BETWEEN WATER & WASTEWATER 135-55105-020-000 Maintenance-Heavy Equipment 500 500 500 291 135-55125-020-000 Dumpster Services 55,000 55,000 55,000 28,625 135-55135-020-000 Lab Analysis 35,000 35,000 25,000 27,711 LOWER DUE TO LESS TESTING AS FY 16 HAD MORE TESTING FOR THE WW PERMIT RENEWAL 135-60010-020-000 Communications/Pagers/Mobiles 5,400 5,400 5,400 4,240 135-60020-020-000 Electricity 161,582 161,582 158,627 81,179 SEE SCHEDULE GF-K 135-60066-020-000 Publications/Books/Subscripts 400 400 400 0 135-60070-020-000 Dues & Memberships 300 300 250 200 LOWER AMOUNT OF DUES 135-60080-020-000 Schools & Training 3,771 3,771 4,195 2,417 SEE SCHEDULE GF-G 135-60090-020-000 Safety Program 550 550 550 341 135-60100-020-000 Travel & per diem 1,600 1,600 1,600 745 SEE SCHEDULE GF-G 135-60105-020-000 Rent/Lease Equipment 9,000 9,000 9,000 4,589 EMERGENCY EQUIPMENT RENTAL IF NEEDED 135-60135-020-000 TCEQ Fees & Permits 37,150 37,150 17,150 14,579 REG. ASSESSMENT($8,550), ANNUAL FEE ($8,600) 135-60243-020-000 Prior Year Expense 0 0 0 0 135-60245-020-000 Miscellaneous Expenses 300 300 450 423 135-60280-020-000 Property Maintenance 0 0 6,622 0 MAINTENANCE FOR WWTP 135-60285-020-000 Lawn Equipment & Maintenance 500 500 11,600 0 MOWING FOR LIFT STATIONS $11,100 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706 119,706 120,492 79,804 TRANSFER OF PID SURCHARGE 135-60332-020-000 Interfund Transfer Out- Revenue I&S 444,831 444,831 595,638 358,397 SEE SCHEDULE GF-B2: FUNDS TO TRANSFER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS 135-60333-020-000 Interfund Transfer Out-Debt Reserve 123,336 123,336 123,492 92,502 TRANSFER FOR BOND RESERVE 135-60334-020-000 Interfund Transfer Out-Bank Reserve Account 0 0 200,000 0 TRANSFER FOR BANK RESERVE ACCOUNT 135-60360-020-000 Furniture/Equipment < $5000 0 0 0 0 135-65005-020-000 Fuel & Lube 32,021 32,021 28,088 7,953 SEE SCHEDULE GF-M 135-65010-020-000 Uniforms 4,241 4,241 4,459 2,734 SEE SCHEDULE GF-F 135-65030-020-000 Chemicals 27,000 27,000 25,000 21,183 LOWER CHLORINE NEED DUE TO REMOVAL OF CLARIFIERS AND FILTERS 135-65035-020-000 Small Tools 2,000 2,000 2,000 867 135-65040-020-000 Safety Equipment 750 750 750 577 135-65045-020-000 Lab Supplies 13,000 13,000 14,000 13,441 135-69005-020-000 Capital Outlays 150,000 356,000 463,000 269,447 SEE SCHEDULE GF-A 135-69008-020-000 Short Term Debt-Principal 21,280 21,280 0 21,277 SEE SCHEDULE GF-B 135-69009-020-000 Short Term Debt-Interest 197 197 0 197 SEE SCHEDULE GF-B 135-69195-020-000 Gasb34/Reserve for Replacement 0 0 30,000 0 NEW ACCOUNT FOR PLANNED REPLACEMENT OF WW/COLLECTION LINES Subtotal Wastewater 1,912,109 2,140,864 2,676,015 1,540,607 Board of Directors 135-50005-026-000 Salaries & Wages 12,500 12,500 12,500 5,600 135-50030-026-000 Social Security Taxes 775 775 775 347 135-50035-026-000 Medicare Taxes 181 181 181 81 135-50040-026-000 Unemployment Taxes 230 12 0 2 NOT REQUIRED 135-50045-026-000 Workman's Compensation 37 50 32 41 TML INVOICE AMOUNT 135-60066-026-000 Publications/Books/Subscripts 150 150 150 0 135-60070-026-000 Dues & Memberships 500 500 500 11 135-60075-026-000 Meetings 1,200 1,200 1,200 22 Trophy Club Municipal Utility District No. 1 5 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 FY 2017 BUDGET DRAFT-AUGUST 12, 2016 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2017 thru 6/30/16 Comments 135-60080-026-000 Schools & Training 4,000 4,000 4,000 1,875 135-60100-026-000 Travel & per diem 5,000 5,000 5,000 3,051 135-60245-026-000 Miscellaneous Expenses 2,000 2,000 2,000 220 Subtotal Board of Directors 26,573 26,368 26,338 11,250 Administration 135-50005-030-000 Salaries & Wages 488,508 493,632 548,110 340,819 SEE SCHEDULE GF-H 135-50010-030-000 Overtime 1,000 500 1,000 491 SEE SCHEDULE GF-H 135-50016-030-000 Longevity 3,823 3,823 4,400 3,823 SEE SCHEDULE GF-H 135-50020-030-000 Retirement 43,202 43,652 50,389 30,345 SEE SCHEDULE GF-H 135-50026-030-000 Medical Insurance 68,196 68,196 84,289 46,307 SEE SCHEDULE GF-I 135-50027-030-000 Dental Insurance 4,807 4,807 5,981 3,183 SEE SCHEDULE GF-I 135-50028-030-000 Vision Insurance 1,114 1,114 1,312 737 SEE SCHEDULE GF-I 135-50029-030-000 Life Insurance & Other 4,431 5,431 5,890 3,518 SEE SCHEDULE GF-I 135-50030-030-000 Social Security Taxes 30,823 31,141 34,590 19,914 SEE SCHEDULE GF-I 135-50035-030-000 Medicare Taxes 7,599 7,678 8,527 4,657 SEE SCHEDULE GF-H 135-50040-030-000 Unemployment Taxes 1,449 1,197 1,368 1,197 SEE SCHEDULE GF-H 135-50045-030-000 Workman's Compensation 1,554 1,554 1,784 1,623 TML INVOICE AMOUNT 135-50060-030-000 Pre-emp Physicals/Testing 500 500 500 0 135-50070-030-000 Employee Relations 5,000 4,500 5,000 3,101 135-55030-030-000 Software & Support 78,483 81,097 67,791 37,028 SEE SCHEDULE GF-L 135-55070-030-000 Independent Labor 12,000 12,000 12,000 1,289 135-55080-030-000 Maintenance & Repairs 29,500 7,000 7,000 6,088 135-55085-030-000 Generator Maintenance & Repairs 0 0 10,000 0 MAINTENANCE & REPAIRS ON ADMIN GENERATOR 135-55100-030-000 Building Maint & Supplies 7,000 7,000 7,000 6,377 135-55120-030-000 Cleaning Services 10,125 10,125 10,429 4,419 CLEANING CONTRACT INCREASE 135-55160-030-000 Professional Outside Services 61,075 72,575 63,325 58,045 M3 IT SERVICES $51,075 , CONTINUING DISCLOSURE REQUIREMENTS $2,250 135-55165-030-000 Collection Fees 200 200 200 0 135-55205-030-000 Utility Billing Contract 8,200 8,200 8,200 6,127 COST FOR PRINTING MONTHLY STATEMENTS 135-60005-030-000 Telephone 16,349 16,349 17,532 9,496 SEE SCHEDULE GF-L AND $2,500 AFTER HOURS ANSWERING SERVICE 135-60010-030-000 Communications/Mobiles 4,150 4,150 4,150 3,139 135-60020-030-000 Electricity 10,768 10,768 12,631 5,449 SEE SCHEDULE GF-K 135-60025-030-000 Water 1,500 1,500 1,500 634 135-60035-030-000 Postage 28,932 28,932 28,932 18,668 135-60040-030-000 Bank Service Charges & Fees 44,000 55,560 55,560 40,549 135-60050-030-000 Bad Debt Expense 3,500 3,500 3,500 3,023 135-60055-030-000 Insurance 52,797 52,797 55,692 25,305 TML INVOICE AMOUNT 135-60066-030-000 Publications/Books/Subscripts 1,600 1,600 1,600 260 135-60070-030-000 Dues & Memberships 6,000 6,000 6,000 5,306 135-60075-030-000 Meetings 400 400 400 68 135-60079-030-000 Public Education 5,000 5,000 10,000 4,230 ADDITIONAL CUSTOMER EDUCATION MATERIALS 135-60080-030-000 Schools & Training 9,935 9,935 9,240 3,382 SEE SCHEDULE GF-G 135-60100-030-000 Travel & per diem 5,400 5,400 5,500 3,201 SEE SCHEDULE GF-G 135-60110-030-000 Physicals/Testing 200 200 200 0 135-60115-030-000 Elections 7,500 7,500 7,500 3,210 POSSIBLE BOND ELECTION IN FY 17 135-60125-030-000 Advertising 7,500 7,500 7,500 62 135-60235-030-000 Security 1,350 1,350 1,350 0 SEE SCHEDULE GF-L 135-60245-030-000 Miscellaneous Expenses & DM Discretionary 17,500 17,500 17,500 5,277 135-60360-030-000 Furniture/Equipment < $5000 2,500 2,500 2,500 656 135-65010-030-000 Uniforms 1,855 1,855 1,855 23 SEE SCHEDULE GF-F Trophy Club Municipal Utility District No. 1 6 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 FY 2017 BUDGET DRAFT-AUGUST 12, 2016 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2017 thru 6/30/16 Comments 135-65055-030-000 Hardware IT 29,594 13,594 9,444 5,872 SEE SCHEDULE GF-L 135-65085-030-000 Office Supplies 9,000 9,000 9,000 4,128 ALL DEPARTMENTS COMBINED. 135-65090-030-000 Printer Supplies & Maintenance 4,003 4,003 2,000 1,005 SEE SCHEDULE GF-L 135-65095-030-000 Maintenance Supplies 5,000 5,000 5,000 2,709 135-65105-030-000 Printing 4,800 4,800 4,800 2,786 135-69005-030-000 Capital Outlays 56,000 56,000 107,001 10,118 SEE SCHEDULE GF-A 135-69170-030-000 Copier Lease Installments 4,600 4,600 4,600 2,443 SEE SCHEDULE GF-L Subtotal Administration 1,210,322 1,203,215 1,331,571 740,086 Non Departmental 135-55045-039-000 Legal 386,130 386,130 150,000 228,703 135-55055-039-000 Auditing 22,750 24,039 23,860 24,039 FY 17 CONTRACT PRICE 135-55060-039-000 Appraisal 10,265 10,265 11,115 8,094 TARRANT COUNTY $2,738; DENTON COUNTY $8,377 135-55065-039-000 Tax Admin Fees 3,800 3,800 3,800 2,469 Subtotal Non Departmental 422,945 424,234 188,775 263,305 Total General Fund Revenues 8,047,784 8,609,567 9,559,480 Total General Fund Expenses 8,047,784 8,609,567 9,559,480 Net Budget Surplus (Deficit)0 0 0 Trophy Club Municipal Utility District No. 1 7 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 FY 2017 BUDGET DRAFT-AUGUST 12, 2016 FIRE DEPARTMENT Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2017 thru 6/30/16 Revenues 122-40001-000-000 Assessment - Emerg Svcs 404,346 404,346 472,439 371,291 SEE SCHEDULE TAX_ASSESS 122-40003-000-000 Emer Svcs Assessmen/Delinquent 0 0 0 346 122-40010-000-000 Property Taxes/MUD Fire 889,963 889,963 1,035,810 870,276 SEE SCHEDULE TAX_ASSESS 122-40011-000-000 Property Taxes/Fire-Delinquent 0 0 0 9,698 122-40015-000-000 Property Taxes/Assessments P&I 750 0 750 0 122-40020-000-000 Property Taxes/Fire P&I 4,500 4,500 4,500 5,010 122-42014-000-000 Fire Permits/Sprinkler 5,000 5,000 5,000 4,800 122-43400-000-000 Fire Inspections 825 825 825 1,000 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000 10,000 10,000 10,000 FOR DENTON COUNTY READINESS FEE 122-49026-000-000 Proceeds from Sale of Assets 0 60,000 0 60,000 122-49035-000-000 Prior Year Reserves 0 0 0 0 122-49900-000-000 Miscellaneous Income 50,000 10,000 0 10,200 Total 1,365,384 1,384,634 1,529,324 1,342,620 Expenses 122-50005-045-000 Salaries & Wages 508,226 508,226 551,224 339,136 SEE SCHEDULE GF-H 122-50010-045-000 Overtime 48,735 48,735 50,237 44,665 SEE SCHEDULE GF-H 122-50011-045-000 Holiday Pay 15,852 15,852 0 14,718 SEE SCHEDULE GF-H 122-50016-045-000 Longevity 5,761 5,761 5,618 5,730 SEE SCHEDULE GF-H 122-50017-045-000 Certification 4,200 4,200 5,400 2,940 SEE SCHEDULE GF-J 122-50020-045-000 Retirement 75,571 75,571 80,434 50,616 SEE SCHEDULE GF-I 122-50026-045-000 Medical Insurance 65,546 65,546 68,414 39,910 SEE SCHEDULE GF-I- BASED ON TOWN'S BENFITS FOR FULL YEAR 122-50027-045-000 Dental Insurance 4,885 4,885 4,797 3,678 SEE SCHEDULE GF-I- BASED ON TOWN'S BENFITS FOR FULL YEAR 122-50028-045-000 Vision Insurance 859 859 479 734 SEE SCHEDULE GF-I- BASED ON TOWN'S BENFITS FOR FULL YEAR 122-50029-045-000 Life Insurance & Other 4,585 4,585 3,684 2,811 SEE SCHEDULE GF-I- BASED ON TOWN'S BENFITS FOR FULL YEAR 122-50030-045-000 Social Security Taxes 36,132 36,132 37,974 23,296 SEE SCHEDULE GF-H 122-50035-045-000 Medicare Taxes 8,450 8,450 8,881 5,447 SEE SCHEDULE GF-H 122-50040-045-000 Unemployment Taxes 1,724 2,000 1,467 2,085 SEE SCHEDULE GF-H 122-50045-045-000 Workman's Compensation 9,379 9,379 9,969 7,034 SEE SCHEDULE GF-H 122-50060-045-000 Pre-employment Physicals/Test 250 250 700 54 $350 EACH- 2 QUANTITY 122-50075-045-000 Tuition Reimbursement 0 0 1,300 0 MUD FY 2017 SHARE 122-55030-045-000 Software & Support 6,661 6,661 8,206 4,173 SEE SCHEDULE GF-L 122-55045-045-000 Legal 2,000 5,000 6,600 6,560 FIRE ILA 122-55080-045-000 Maintenance & Repairs 16,370 25,218 21,370 20,467 ANNUAL EXTRACTION CERTIFICATION TESTING $5000 122-55085-045-000 Generator Maintenance & Repairs 0 0 2,000 0 122-55090-045-000 Vehicle Maintenance 10,000 10,000 20,000 12,718 INCLUDES $3600 FOR TIRES FOR LADDER TRUCK AND ADDED NEW LADDER TRUCK 122-60005-045-000 Telephone 50 50 50 39 122-60010-045-000 Communications/Mobiles 6,653 7,706 8,931 5,937 SEE SCHEDULE GF-L 122-60020-045-000 Electricity/Gas 7,412 7,412 6,673 3,461 SEE SCHEDULE GF-K: 50% PAID BY TOWN 122-60025-045-000 Water 1,200 1,200 1,200 1,274 50% PAID BY TOWN 122-60026-045-000 Cable 1,920 1,920 1,920 1,395 NEW CABLE FOR EOC ROOM 122-60030-045-000 Rent And/Or Usage 214,379 214,379 216,754 214,379 SEE SCHEDULE FD-B Trophy Club Municipal Utility District No. 1 8 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 FY 2017 BUDGET DRAFT-AUGUST 12, 2016 Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2017 thru 6/30/16 122-60035-045-000 Postage 50 50 50 26 122-60055-045-000 Insurance 14,077 18,451 16,513 7,897 TML INVOICE 122-60066-045-000 Publications/Books/Subscrips 350 350 350 172 AERIAL TRAINING BOOK 122-60070-045-000 Dues & Memberships 15,582 15,582 15,582 15,457 SEE SCHEDULE FD-A 122-60080-045-000 Schools & Training 7,880 6,880 7,880 3,188 SEE SCHEDULE FD-A 122-60096-045-000 Emergency Management 1,000 1,000 1,000 0 122-60100-045-000 Travel & per diem 4,081 2,081 4,081 958 SEE SCHEDULE FD-A 122-60110-045-000 Physicals/Testing 4,700 4,700 8,085 6,804 ALL STAFF WILL DO PHYSICALS AND 2 HAZMAT FIT FOR DUTY 122-60125-045-000 Advertising 500 4,700 500 4,200 VOLUNTEER PROGRAM ADVERTISMENT 122-60160-045-000 Programs & Special Projects 7,500 7,500 7,500 1,129 $2750 FIRE EDUCATION SCHOOL; $3000 FIRE CAMP & CFA; EVENT COVERAGE 122-60180-045-000 Fire Inspection/Enforcement 500 500 500 359 122-60195-045-000 Flags & Repair 3,184 3,184 3,050 1,752 ADDITIONAL POLE MAINTENANCE 122-60243-045-000 Prior Year Expense 0 0 0 0 122-60245-045-000 Miscellaneous Expense 1,000 1,000 1,000 838 122-60280-045-000 Property Maintenance 0 0 12,000 0 MAINTENANCE AT FIRE STATION 122-65005-045-000 Fuel & Lube 15,122 15,122 21,111 3,272 INCREASE IN LUBE COSTS FOR LARGER ENGINE VEHICLES AND INCREASE IN FUEL USEAGE 122-65010-045-000 Uniforms 3,140 3,640 3,140 3,814 JACKETS AND SWEATSHIRTS 122-65015-045-000 Protective Clothing 9,000 9,000 28,000 4,566 REPLACE 6 SETS, ANNUAL INSPECTION & CLEANING OF ALL SETS; 2 SETS OF VESTS 122-65030-045-000 Chemicals 600 600 1,500 654 FOAM FOR NEW TRUCK 122-65035-045-000 Small Tools 2,000 2,000 6,000 1,862 TWO NEW SAWS 122-65055-045-000 Hardware 750 750 750 195 SEE SCHEDULE GF-L REPLACEMENT 122-65085-045-000 Office Supplies 500 500 500 328 122-65105-045-000 Printing 498 498 498 0 SEE SCHEDULE GF-L 122-69005-045-000 Capital Outlays 0 0 16,836 0 2QTY FIRE THERMAL IMAGER $8418 EACH 122-69008-045-000 Short Term Debt -Principal 0 0 0 0 122-69009-045-000 Short Term Debt -Interest 0 0 0 0 122-69050-045-000 Radios 8,000 8,000 29,000 0 FLASH UPGRADE $7,000, 2 QTY MOBILE $8,000 EA & SPARE PORTABLE $6,000 122-69195-045-000 GASB34/Reserve for Replacement 81,420 81,420 81,420 81,420 1/10 COST OF NEW FIRE ENGINE 122-69255-045-000 Airpacks 0 0 11,050 0 17 FACEMASKS WITH VOICE AMP 122-69305-045-000 Capital Leases 127,149 127,149 127,149 127,149 LEASE PAYMENT NO. 1 OF 7 FOR LADDER TRUCK Total 1,365,384 1,384,635 1,529,324 1,079,297 Total Fire Revenues 1,365,384 1,384,635 1,529,324 Total Fire Expenses 1,365,384 1,384,635 1,529,324 Net Budget Surplus (Deficit)0 0 0 Trophy Club Municipal Utility District No. 1 9 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T TAX DEBT SERVICE FUND (I&S) Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2017 thru 6/30/16 Comments Debt Service Revenues 533-40000-000-000 Property Taxes 667,898 0 673,336 653,129 533-40002-000-000 Property Taxes/Delinquent 2,300 0 3,500 4,784 533-40015-000-000 Property Taxes/P & I 1,800 0 2,000 2,556 533-48005-000-000 Reserve Funds (PID Utility Fees/Other)0 0 0 0 533-48015-000-000 WW Sales Revenue Transfer for Debt 0 0 0 0 SEE DEBT SVC I&S REVENUE 533-49010-000-000 Interest Income 140 0 140 1,191 533-49015-000-000 Lease/Rental Income 214,379 0 216,754 214,379 SEE SCHEDULE FD-B 533-49110-000-000 Premium on Bonds Sold 0 0 0 0 533-49141-000-000 Interfund Transfer In-PID Surchg 119,706 0 120,492 79,804 Total 1,006,223 0 1,016,223 955,843 Debt Service Expenses 533-70005-051-000 Paying Agent Fee 2,550 0 2,550 1,250 533-70025-051-000 Bond Interest Expense-Tax 316,983 0 300,583 158,691 SEE SCHEDULE GF-B1 (LONG TERM DEBT) 533-70035-051-000 Bond Principal Payment-Tax 685,000 0 710,000 0 SEE SCHEDULE GF-B1 (LONG TERM DEBT) 533-70040-051-000 Bond Interest Expense-Rev Bonds 0 0 0 0 SEE DEBT SVC I&S REVENUE 533-70045-051-000 Bond Principal Payment-Rev Bonds 0 0 0 0 SEE DEBT SVC I&S REVENUE Total 1,004,533 0 1,013,133 159,941 Total Debt Service Fund Revenues 1,006,223 0 1,016,223 Total Debt Service Fund Expenses 1,004,533 0 1,013,133 Net Budget Surplus (Deficit)1,690 0 3,090 Trophy Club Municipal Utility District No. 1 10 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T REVENUE DEBT SERVICE FUND (I&S) Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2017 thru 6/30/16 Comments Debt Service Revenues 534-49010-000-000 Interest Income 7 0 200 253 534-49110-000-000 Bond Premium 0 0 0 0 534-49142-000-000 Interfund Transfer In-Water Sales 0 0 297,011 0 Water Sales Revenue Transfer for Revenue Debt Payment 534-49143-000-000 Interfund Transfer In- WW Sales 444,831 0 595,638 358,397 WW Sales Revenue Transfer for Revenue Debt Payment Total 444,838 0 892,849 358,397 Debt Service Expenses 534-70040-051-000 Bond Interest Expense-Rev Bonds 234,838 0 387,649 117,619 See Schedule GF-B2 (Long Term Debt) 534-70045-051-000 Bond Principal Payment-Rev Bonds 210,000 0 505,000 0 See Schedule GF-B2 (Long Term Debt) Total 444,838 0 892,649 117,619 Total Debt Service Fund Revenues 444,838 0 892,849 Total Debt Service Fund Expenses 444,838 0 892,649 Net Budget Surplus (Deficit)0 0 200 Trophy Club Municipal Utility District No. 1 11 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T Debt Reserve Fund* Account Description Original Amend #1 PROPOSED YTD Total Budget Budget FY 2017 thru 6/30/16 Comments Debt Reserve Revenues 528-49010-000-000 Interest Income 0 0 300 283.05 528-49142-000-000 Interfund transfer In-Water 0 0 64,920 0 $5,410 FOR 12 MONTHS 528-49143-000-000 Interfund transfer In-WW 123,336 0 123,492 92,502 $10,291 FOR 12 MONTHS Total 123,336 0 188,712 92,785 Debt Reserve Expenses 0 0 0 0 Total 0 0 0 0 *Revenue bond covenants require 1 year debt service in reserves; usually allow 5 years from issuance date to accumulate the reserve. Total Debt Service Fund Revenues 123,336 0 188,712 92,785 Total Debt Service Fund Expenses 0 0 0 0 Net Budget Surplus (Deficit)123,336 0 188,712 92,785 Trophy Club Municipal Utility District No. 1 12 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE TAX_ASSESS TAX RATE AND PID ASSESSMENT & SURCHARGE CALCULATIONS FIRE TAX/ASSESSMENT RATE OVERALL TAX RATE FY 2017:$0.12722 NET TAX VALUE TARRANT COUNTY:367,203,860 7/25/2016 Certified DENTON COUNTY:1,024,172,857 7/16/2016 Certified DENTON CO. PID:634,300,287 7/8/2016 Certified OUT OF DISTRICT & PID 314,500 7/14/2016 REQUIRED REVENUE TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 FIRE Vals/100 =20,259,915.04 FY 2017 Tax/Assess Rate =0.07445 1,508,249 TAX COMPARISON TO FY 2016 Revenue from MUD Tax =1,035,810$ 2016 2017 Revenue from PID Assess =472,439$ O&M (General Fund) Tax 0.0047214 0.00438 Total:1,508,249$ I & S (Debt Service) Tax 0.0542003 0.04839 Fire Tax 0.072221 0.07445 O&M TAX/SURCHARGE RATE Total Tax Rate:0.13114 0.12722 NET TAX VALUE Increase/Decrease:-0.00392 TARRANT COUNTY:367,203,860 DENTON COUNTY:1,024,172,857 PID Fire Assessment Rate 0.07222 0.07445 DENTON CO. PID:634,300,287 Increase/Decrease:0.00222 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 O&M Vals/100 =20,256,770.04 FY 2017 Tax/Surcharge Rate =0.00438 88,775 Revenue from MUD Tax =60,977$ Revenue from PID Surcharge =27,798$ Total:88,775$ I&S TAX/SURCHARGE RATE NEW DEBT: CALCULATE AMOUNT DUE FROM PID NET TAX VALUE TARRANT COUNTY:367,203,860 DENTON COUNTY:1,024,172,857 DENTON CO. PID:634,300,287 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 TAX DEBT 2014 AND AFTER (I&S)Vals/100 =20,256,770.04 FY 2017 PID Surcharge Rate =0.01900 NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE 384,800 Revenue from MUD Tax =264,308$ Revenue from PID Surcharge =120,492$ Total:384,800$ MUD DEBT: CALCULATE MUD TAX NET TAX VALUE TARRANT COUNTY:367,203,860 DENTON COUNTY:1,024,172,857 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 I&S MUD DEBT Vals/100 =13,913,767.17 FY 2017 Tax Rate =0.04839 673,336 Revenue from MUD Tax =673,336$ Revenue from PID = N/A -$ Total:673,336$ Trophy Club Municipal Utility District No. 1 13 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE FD-A Fire Department Dues, Training, and Travel Account Description FY 2017 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,997 Denton County Chiefs $280 Annual fee Tarrant County Chiefs $100 Annual fee Texas Fire Chiefs $150 Annual fee International Fire Chiefs $165 Annual fee TOTAL:$15,582 122-60080 Schools and Training TCCC Live Fire Training $700 TCFP Annual Certification classes TCCC / NFA $2,000 8 NFA classes TCFP / TEEX / NFA on site classes $500 Instructor cost Haz-Mat Certification $1,480 (2) staff cert Conference registration $1,700 SFR / Homeland / FMC / FDIC Office Management Classes(Excel, Access)$1,500 TOTAL:$7,880 122-60100 Travel and Per Diem Southwest Fire / Rescue (Chief Conf)$941 Chief or training officer conference. Homeland Security Conference $800 EMC and Training officer (1) Texas Fire Marshal Conference $840 Fire Marshal Fire Department Instructor Conf (FDIC) International Fire Chiefs $1,500 Chief or Training Officer TOTAL:$4,081 Trophy Club Municipal Utility District No. 1 14 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE FD-B RENT CALCULATION FOR FIRE STATION FY Bond Payment Reimburse Reserve ($933,700)*Total Rent 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 Trophy Club Municipal Utility District No. 1 15 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE GF - A FY 17 CAPITAL OUTLAYS WATER - PURCHASES WATER - MAINTENANCE & REPAIRS ADMINISTRATION - PURCHASES DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT 3/4 TON TRUCK (USING CURRENT TRUCK BED)30,000 PUMP FOR WATER PLANT 370,000 DOCUMENT MANAGEMENT SYSTEM 37,001 SUNSET WATER LINES 40,000 PARKING BOLLARDS 10,000 14" INLINE VALVE 62,421 SECURITY SYSTEM 60,000 Total:30,000 Total:472,421 Total:107,001 WASTEWATER - PURCHASES WASTEWATER - MAINTENANCE & REPAIRS ADMINISTRATION - MAINTENANCE & REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT RIDING LAWN MOWER 5,000 INFLUENT PUMP 3 & 4 30,000 BACKHOE 80,000 DIGEST BLOWER 65,000 PORTABLE GENERATOR 48,000 LIFT STATION CONTROLS 1 & 2 35,000 OAKMONT SEWER 200,000 Total:133,000 Total:330,000 Total:0 Trophy Club Municipal Utility District No. 1 16 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T LONG TERM TAX DEBT MUD/PID Paid Par Principle FY 17 Interest 3/01 Interest 9/01 Subtotal Interest Total Maturity Date First Callable Date Project/Reason Series 2010 (Tax)MUD $2,000,000 $80,000 $34,329 $34,329 $68,658 $148,658 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 $205,000 $22,175 $22,175 $44,350 $249,350 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 $185,000 $21,388 $21,388 $42,775 $227,775 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 $470,000 $77,891 $77,891 $155,783 $625,783 Series 2014 (Tax) MUD/PID $5,765,000 $240,000 $72,400 $72,400 $144,800 $384,800 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 $240,000 $72,400 $72,400 $144,800 $384,800 TOTAL ALL BONDS:$12,025,000 $710,000 $150,291 $150,291 $300,583 $1,010,583 SCHEDULE GF - B1 TAX DEBT PAYMENTS Trophy Club Municipal Utility District No. 1 17 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T LONG TERM REVENUE DEBT MUD/PID Paid Par Principle FY 17 Interest 3/01 Interest 9/01 Subtotal Interest Total Maturity Date First Callable Date Project/Reason Series 2015 (Revenue)$9,230,000 $365,000 $115,319 $115,319 $230,638 $595,638 9/1/2035 9/1/2024 Revenue Bonds for WWTP Expansion Series 2016 (Revenue)$4,635,000 $140,000 $78,506 $78,506 $157,011 $297,011 Revenue Bonds for Fort Worth Line Phase 2 SUBTOTAL REVENUE BONDS:$13,865,000 $505,000 $193,824 $193,824 $387,649 $892,649 TOTAL ALL BONDS:$13,865,000 $505,000 $193,824 $193,824 $387,649 $892,649 SHORT TERM REVENUE DEBT Original PAR Outstanding Debt Principle FY 17 Interest 3/01 Interest 9/01 Subtotal Interest Total Payoff Date Project/Reason Department Total:$0 $0 $0 $0 $0 $0 $0 SCHEDULE GF - B2 REVENUE DEBT PAYMENTS Trophy Club Municipal Utility District No. 1 18 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T ANNUALIZE GROWTH IN WATER METERS =0.50% PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2016 =4,620 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) 4165 88,367,000 1 OCT 4,622 21,215 98,053,532 4175 61,354,333 2 NOV 4,624 14,694 67,945,062 4190 44,442,000 3 DEC 4,626 10,608 49,068,056 4197 39,052,333 4 JAN 4,628 9,304 43,056,545 4214 37,932,667 5 FEB 4,630 9,002 41,677,318 4245 42,722,000 6 MAR 4,632 10,063 46,608,730 4265 60,036,667 7 APR 4,633 14,075 65,218,679 4298 67,186,667 8 MAY 4,635 15,632 72,461,281 4321 85,208,667 9 JUN 4,637 19,721 91,454,114 4328 103,221,333 10 JUL 4,639 23,851 110,653,924 4362 130,171,333 11 AUG 4,641 29,840 138,493,242 4352 118,978,333 12 SEP 4,643 27,341 126,947,822 AVERAGE 4,633 17,112 TOTAL 951,638,307 CALCULATED AVERAGE WATER USE PER METER PER MONTH =(GALS/METER/MN)17,112 PROJECTED TOTAL NO. OF NEW RETAIL METERS IN FY17 =(METERS)23 Growth Rate Meters set June 2015 through May 2016:13.5 per month Growth Rate = Ave. New Meters Set/Total Meters at May 2016 (13.5*12)/4620*100%=3.51% .50% recommended Purchased Water (gallons):951,638,307 $2.3232 per 1000 gals $2,210,846 3.04% Increase $65,638 per month $787,656 3.01% Increase $25 per month $300 Total:$2,998,802 METERS FOR LAST THREE YEARS COMBINED WATER USE FOR LAST THREE YEARS COMBINED Service Charge SCHEDULE GF-C PROJECTED WATER USE PROJECTED RETAIL WATER SALES Purchased Water Expense (Projected Fort Worth Costs) Out of District Volumetric Charge Rate of Use Charge Growth is slowing significantly as build out approaches Trophy Club Municipal Utility District No. 1 19 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE GF-D PROJECTED WATER REVENUE FY 2013 Beginning End Block Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % ConsumptionBlockBlockValueAccountsReportedTotalBy Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block - 1,000 1,000 225 88,000 3,786,000 4.42%211 87,000 3,799,000 5.09%282 151,000 3,810,000 7.88%273 124,000 3,795,000 9.40%357 187,000 3,796,000 10.87%306 136,000 3,838,000 8.83%245 104,000 3,889,000 6.72%240 83,000 3,929,000 5.00%206 75,000 3,967,000 4.48%217 53,000 3,978,000 3.60%184 53,000 4,035,000 3.05%186 57,000 4,036,000 3.49%2,932 1,198,000 46,658,000 5.12%1,000 2,000 1,000 104 208,000 3,698,000 4.32%96 192,000 3,712,000 4.97%238 476,000 3,659,000 7.57%198 396,000 3,671,000 9.10%343 686,000 3,609,000 10.33%200 400,000 3,702,000 8.52%160 320,000 3,785,000 6.54%112 224,000 3,846,000 4.89%77 154,000 3,892,000 4.39%76 152,000 3,925,000 3.55%59 118,000 3,982,000 3.01%44 88,000 3,979,000 3.44%1,707 3,414,000 45,460,000 4.99%2,000 3,000 1,000 118 354,000 3,594,000 4.20%132 396,000 3,616,000 4.84%287 861,000 3,421,000 7.08%292 876,000 3,473,000 8.61%467 1,401,000 3,266,000 9.35%324 972,000 3,502,000 8.06%199 597,000 3,625,000 6.27%117 351,000 3,734,000 4.75%111 333,000 3,815,000 4.31%62 186,000 3,849,000 3.48%56 168,000 3,923,000 2.96%73 219,000 3,935,000 3.40%2,238 6,714,000 43,753,000 4.80%3,000 4,000 1,000 125 500,000 3,476,000 4.06%155 620,000 3,484,000 4.67%337 1,348,000 3,134,000 6.48%381 1,524,000 3,181,000 7.88%606 2,424,000 2,799,000 8.01%405 1,620,000 3,178,000 7.31%261 1,044,000 3,426,000 5.92%155 620,000 3,617,000 4.60%126 504,000 3,704,000 4.18%62 248,000 3,787,000 3.43%69 276,000 3,867,000 2.92%60 240,000 3,862,000 3.34%2,742 10,968,000 41,515,000 4.56%4,000 5,000 1,000 160 800,000 3,351,000 3.92%177 885,000 3,329,000 4.46%367 1,835,000 2,797,000 5.79%432 2,160,000 2,800,000 6.94%457 2,285,000 2,193,000 6.28%409 2,045,000 2,773,000 6.38%274 1,370,000 3,165,000 5.47%161 805,000 3,462,000 4.40%147 735,000 3,578,000 4.04%78 390,000 3,725,000 3.37%63 315,000 3,798,000 2.87%63 315,000 3,802,000 3.29%2,788 13,940,000 38,773,000 4.26% 5,000 6,000 1,000 150 900,000 3,191,000 3.73%180 1,080,000 3,152,000 4.22%309 1,854,000 2,430,000 5.03%443 2,658,000 2,368,000 5.87%361 2,166,000 1,736,000 4.97%330 1,980,000 2,364,000 5.44%270 1,620,000 2,891,000 5.00%164 984,000 3,301,000 4.20%148 888,000 3,431,000 3.87%73 438,000 3,647,000 3.30%64 384,000 3,735,000 2.82%64 384,000 3,739,000 3.23%2,556 15,336,000 35,985,000 3.95%6,000 7,000 1,000 159 1,113,000 3,041,000 3.55%176 1,232,000 2,972,000 3.98%282 1,974,000 2,121,000 4.39%387 2,709,000 1,925,000 4.77%272 1,904,000 1,375,000 3.94%311 2,177,000 2,034,000 4.68%277 1,939,000 2,621,000 4.53%169 1,183,000 3,137,000 3.99%148 1,036,000 3,283,000 3.71%81 567,000 3,574,000 3.24%49 343,000 3,671,000 2.77%93 651,000 3,675,000 3.18%2,404 16,828,000 33,429,000 3.67%7,000 8,000 1,000 152 1,216,000 2,882,000 3.37%175 1,400,000 2,796,000 3.74%259 2,072,000 1,839,000 3.80%311 2,488,000 1,538,000 3.81%211 1,688,000 1,103,000 3.16%232 1,856,000 1,723,000 3.97%242 1,936,000 2,344,000 4.05%154 1,232,000 2,968,000 3.77%136 1,088,000 3,135,000 3.54%102 816,000 3,493,000 3.16%60 480,000 3,622,000 2.74%84 672,000 3,582,000 3.10%2,118 16,944,000 31,025,000 3.41%8,000 9,000 1,000 136 1,224,000 2,730,000 3.19%178 1,602,000 2,621,000 3.51%215 1,935,000 1,580,000 3.27%209 1,881,000 1,227,000 3.04%144 1,296,000 892,000 2.55%206 1,854,000 1,491,000 3.43%251 2,259,000 2,102,000 3.63%206 1,854,000 2,814,000 3.58%158 1,422,000 2,999,000 3.39%97 873,000 3,391,000 3.07%76 684,000 3,562,000 2.69%106 954,000 3,498,000 3.02%1,982 17,838,000 28,907,000 3.17%9,000 14,000 5,000 713 8,543,000 11,531,000 13.47%828 9,891,000 10,514,000 14.08%711 8,366,000 5,237,000 10.83%621 7,190,000 3,586,000 8.89%368 4,258,000 2,846,000 8.15%663 7,723,000 4,866,000 11.20%777 9,055,000 7,432,000 12.85%841 10,110,000 11,376,000 14.47%828 9,922,000 12,535,000 14.15%626 7,634,000 15,340,000 13.89%446 5,423,000 16,609,000 12.55%598 7,179,000 15,767,000 13.63%8,020 95,294,000 117,639,000 12.91% 14,000 17,000 3,000 396 6,323,000 5,234,000 6.12%389 6,175,000 4,407,000 5.90%201 3,190,000 1,735,000 3.59%122 1,952,000 1,069,000 2.65%120 1,903,000 1,003,000 2.87%207 3,286,000 1,633,000 3.76%290 4,638,000 2,930,000 5.07%400 6,371,000 4,872,000 6.19%399 6,346,000 5,602,000 6.32%412 6,591,000 7,591,000 6.87%325 5,244,000 8,839,000 6.68%440 7,055,000 7,957,000 6.88%3,701 59,074,000 52,872,000 5.80%17,000 20,000 3,000 340 6,446,000 4,101,000 4.79%301 5,684,000 3,342,000 4.48%107 2,015,000 1,234,000 2.55%64 1,211,000 756,000 1.87%60 1,141,000 721,000 2.06%98 1,844,000 1,129,000 2.60%198 3,749,000 2,141,000 3.70%332 6,266,000 3,727,000 4.74%373 7,066,000 4,448,000 5.02%401 7,617,000 6,365,000 5.76%376 7,143,000 7,768,000 5.87%406 7,708,000 6,650,000 5.75%3,056 57,890,000 42,382,000 4.65%20,000 25,000 5,000 362 8,273,000 4,948,000 5.78%340 7,768,000 3,893,000 5.21%127 2,887,000 1,442,000 2.98%68 1,539,000 894,000 2.22%73 1,636,000 811,000 2.32%138 3,119,000 1,254,000 2.89%237 5,385,000 2,390,000 4.13%375 8,571,000 4,371,000 5.56%429 9,761,000 5,241,000 5.92%589 13,501,000 8,051,000 7.29%579 13,318,000 10,538,000 7.96%632 14,499,000 8,439,000 7.29%3,949 90,257,000 52,272,000 5.74%25,000 29,000 4,000 207 5,678,000 2,807,000 3.28%152 4,169,000 2,101,000 2.81%61 1,671,000 778,000 1.61%32 885,000 529,000 1.31%18 497,000 483,000 1.38%47 1,280,000 633,000 1.46%114 3,122,000 1,212,000 2.10%186 5,075,000 2,321,000 2.95%252 6,862,000 2,802,000 3.16%324 8,903,000 4,571,000 4.14%373 10,229,000 6,452,000 4.87%347 9,547,000 4,748,000 4.10%2,113 57,918,000 29,437,000 3.23%29,000 34,000 5,000 181 5,763,000 2,489,000 2.91%122 3,848,000 1,865,000 2.50%41 1,305,000 701,000 1.45%20 641,000 516,000 1.28%21 661,000 492,000 1.41%30 939,000 579,000 1.33%69 2,200,000 1,029,000 1.78%163 5,186,000 2,014,000 2.56%195 6,180,000 2,350,000 2.65%295 9,363,000 4,043,000 3.66%398 12,651,000 6,054,000 4.57%305 9,692,000 4,167,000 3.60%1,840 58,429,000 26,299,000 2.89% 34,000 39,000 5,000 107 3,952,000 1,754,000 2.05%90 3,305,000 1,350,000 1.81%15 556,000 556,000 1.15%13 476,000 424,000 1.05%9 327,000 416,000 1.19%19 701,000 470,000 1.08%44 1,610,000 724,000 1.25%101 3,739,000 1,355,000 1.72%102 3,757,000 1,604,000 1.81%195 7,198,000 2,828,000 2.56%265 9,730,000 4,340,000 3.28%196 7,201,000 2,877,000 2.49%1,156 42,552,000 18,698,000 2.05%39,000 44,000 5,000 73 3,037,000 1,265,000 1.48%49 2,067,000 1,016,000 1.36%8 338,000 496,000 1.03%10 420,000 370,000 0.92%13 549,000 372,000 1.06%11 461,000 392,000 0.90%19 793,000 567,000 0.98%51 2,122,000 928,000 1.18%72 3,012,000 1,159,000 1.31%130 5,457,000 1,997,000 1.81%184 7,697,000 3,221,000 2.43%136 5,681,000 2,037,000 1.76%756 31,634,000 13,820,000 1.52%44,000 50,000 6,000 60 2,851,000 1,141,000 1.33%32 1,505,000 937,000 1.25%9 425,000 539,000 1.12%9 420,000 378,000 0.94%4 196,000 392,000 1.12%12 560,000 392,000 0.90%15 715,000 583,000 1.01%26 1,229,000 883,000 1.12%48 2,252,000 998,000 1.13%92 4,364,000 1,696,000 1.54%168 7,955,000 2,795,000 2.11%92 4,347,000 1,739,000 1.50%567 26,819,000 12,473,000 1.37%50,000 59,000 9,000 32 1,749,000 1,256,000 1.47%32 1,743,000 1,115,000 1.49%10 551,000 726,000 1.50%5 283,000 519,000 1.29%10 554,000 522,000 1.49%8 439,000 507,000 1.17%17 942,000 731,000 1.26%38 2,064,000 1,019,000 1.30%40 2,176,000 1,103,000 1.25%64 3,513,000 1,807,000 1.64%134 7,284,000 2,726,000 2.06%73 3,961,000 1,814,000 1.57%463 25,259,000 13,845,000 1.52%59,000 69,000 10,000 18 1,160,000 1,148,000 1.34%17 1,079,000 986,000 1.32%13 849,000 702,000 1.45%5 307,000 502,000 1.24%2 130,000 512,000 1.47%4 248,000 492,000 1.13%10 624,000 644,000 1.11%14 898,000 882,000 1.12%13 850,000 983,000 1.11%45 2,869,000 1,424,000 1.29%73 4,683,000 2,026,000 1.53%42 2,683,000 1,455,000 1.26%256 16,380,000 11,756,000 1.29% 69,000 +105 25,404,000 18,159,000 21.22%91 19,940,000 13,661,000 18.30%62 13,680,000 9,402,000 19.45%49 10,218,000 6,837,000 16.94%50 9,047,000 5,597,000 16.02%48 9,813,000 6,501,000 14.96%61 13,811,000 9,602,000 16.60%81 19,678,000 14,089,000 17.91%90 24,169,000 17,959,000 20.27%121 29,741,000 21,392,000 19.36%165 38,198,000 26,813,000 20.26%125 32,580,000 23,955,000 20.70%1,048 246,279,000 173,967,000 19.10%3,923 85,582,000 85,582,000 100.00%3,923 74,668,000 74,668,000 100.00%3,941 48,339,000 48,339,000 100.00%3,944 40,358,000 40,358,000 100.00%3,966 34,936,000 34,936,000 100.00%4,008 43,453,000 43,453,000 100.00%4,030 57,833,000 57,833,000 100.00%4,086 78,645,000 78,645,000 100.00%4,098 88,588,000 88,588,000 100.00%4,142 110,474,000 110,474,000 100.00%4,166 132,376,000 132,376,000 100.00%4,165 115,713,000 115,713,000 100.00%48,392 910,965,000 910,965,000 100.00% FY 2014 Beginning End Block Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % ConsumptionBlockBlockValueAccountsReportedTotalBy Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block- 1,000 1,000 213 73,000 4,054,000 4.86%310 129,000 4,029,000 8.15%390 182,000 4,014,000 11.62%342 133,000 4,036,000 9.93%359 147,000 4,049,000 10.17%294 131,000 4,127,000 7.70%260 103,000 4,146,000 6.18%233 104,000 4,202,000 5.15%184 66,000 4,236,000 4.19%170 62,000 4,232,000 4.44%170 56,000 4,279,000 3.68%172 64,000 4,259,000 3.73%3,097 1,250,000 49,663,000 5.66%1,000 2,000 1,000 104 208,000 3,981,000 4.77%230 460,000 3,900,000 7.89%318 636,000 3,832,000 11.09%224 448,000 3,903,000 9.60%265 530,000 3,902,000 9.80%183 366,000 3,996,000 7.45%166 332,000 4,043,000 6.02%105 210,000 4,098,000 5.02%85 170,000 4,170,000 4.13%91 182,000 4,170,000 4.38%56 112,000 4,223,000 3.63%56 112,000 4,195,000 3.68%1,883 3,766,000 48,413,000 5.52%2,000 3,000 1,000 140 420,000 3,877,000 4.65%344 1,032,000 3,670,000 7.42%501 1,503,000 3,514,000 10.17%365 1,095,000 3,679,000 9.05%435 1,305,000 3,637,000 9.13%307 921,000 3,813,000 7.11%236 708,000 3,877,000 5.77%138 414,000 3,993,000 4.89%85 255,000 4,085,000 4.04%113 339,000 4,079,000 4.28%72 216,000 4,167,000 3.58%64 192,000 4,139,000 3.63%2,800 8,400,000 46,530,000 5.31% 3,000 4,000 1,000 137 548,000 3,737,000 4.48%439 1,756,000 3,326,000 6.73%586 2,344,000 3,013,000 8.72%515 2,060,000 3,314,000 8.15%483 1,932,000 3,202,000 8.04%354 1,416,000 3,506,000 6.54%284 1,136,000 3,641,000 5.42%154 616,000 3,855,000 4.72%116 464,000 4,000,000 3.96%122 488,000 3,966,000 4.16%85 340,000 4,095,000 3.52%80 320,000 4,075,000 3.57%3,355 13,420,000 43,730,000 4.99%4,000 5,000 1,000 171 855,000 3,600,000 4.31%391 1,955,000 2,887,000 5.84%532 2,660,000 2,427,000 7.02%495 2,475,000 2,799,000 6.89%500 2,500,000 2,719,000 6.83%402 2,010,000 3,152,000 5.88%258 1,290,000 3,357,000 5.00%155 775,000 3,701,000 4.53%110 550,000 3,884,000 3.84%126 630,000 3,844,000 4.04%92 460,000 4,010,000 3.45%102 510,000 3,995,000 3.50%3,334 16,670,000 40,375,000 4.60%5,000 6,000 1,000 178 1,068,000 3,429,000 4.11%348 2,088,000 2,496,000 5.05%443 2,658,000 1,895,000 5.48%467 2,802,000 2,304,000 5.67%468 2,808,000 2,219,000 5.57%357 2,142,000 2,750,000 5.13%288 1,728,000 3,099,000 4.62%182 1,092,000 3,546,000 4.34%105 630,000 3,774,000 3.74%140 840,000 3,718,000 3.90%100 600,000 3,918,000 3.37%71 426,000 3,893,000 3.41%3,147 18,882,000 37,041,000 4.22%6,000 7,000 1,000 199 1,393,000 3,251,000 3.90%303 2,121,000 2,148,000 4.34%314 2,198,000 1,452,000 4.20%384 2,688,000 1,837,000 4.52%318 2,226,000 1,751,000 4.40%283 1,981,000 2,393,000 4.46%276 1,932,000 2,811,000 4.19%169 1,183,000 3,364,000 4.12%115 805,000 3,669,000 3.63%142 994,000 3,578,000 3.76%102 714,000 3,818,000 3.28%108 756,000 3,822,000 3.35%2,713 18,991,000 33,894,000 3.87%7,000 8,000 1,000 166 1,328,000 3,052,000 3.66%226 1,808,000 1,845,000 3.73%244 1,952,000 1,138,000 3.29%303 2,424,000 1,453,000 3.58%273 2,184,000 1,433,000 3.60%288 2,304,000 2,110,000 3.94%207 1,656,000 2,535,000 3.78%169 1,352,000 3,195,000 3.91%128 1,024,000 3,554,000 3.52%144 1,152,000 3,436,000 3.61%87 696,000 3,716,000 3.20%95 760,000 3,714,000 3.26%2,330 18,640,000 31,181,000 3.56% 8,000 9,000 1,000 156 1,404,000 2,886,000 3.46%180 1,620,000 1,619,000 3.27%156 1,404,000 894,000 2.59%225 2,025,000 1,150,000 2.83%198 1,782,000 1,160,000 2.91%237 2,133,000 1,822,000 3.40%209 1,881,000 2,328,000 3.47%179 1,611,000 3,026,000 3.71%128 1,152,000 3,426,000 3.39%162 1,458,000 3,292,000 3.46%108 972,000 3,629,000 3.12%116 1,044,000 3,619,000 3.17%2,054 18,486,000 28,851,000 3.29%9,000 14,000 5,000 803 9,598,000 12,006,000 14.39%662 7,768,000 5,695,000 11.52%435 4,983,000 2,583,000 7.47%562 6,467,000 3,224,000 7.93%598 6,845,000 3,283,000 8.24%776 9,053,000 6,114,000 11.40%793 9,496,000 8,989,000 13.39%935 11,132,000 12,277,000 15.04%775 9,341,000 14,981,000 14.83%869 10,428,000 13,912,000 14.60%685 8,295,000 16,310,000 14.03%731 8,838,000 16,119,000 14.14%8,624 102,244,000 115,493,000 13.17%14,000 17,000 3,000 425 6,806,000 5,362,000 6.43%237 3,785,000 2,087,000 4.22%90 1,431,000 810,000 2.34%123 1,960,000 958,000 2.36%116 1,834,000 954,000 2.40%236 3,765,000 2,180,000 4.07%346 5,532,000 3,628,000 5.40%491 7,827,000 5,216,000 6.39%519 8,314,000 7,060,000 6.99%514 8,191,000 6,236,000 6.55%468 7,531,000 8,083,000 6.95%488 7,837,000 7,857,000 6.89%4,053 64,813,000 50,431,000 5.75%17,000 20,000 3,000 356 6,701,000 4,087,000 4.90%167 3,173,000 1,453,000 2.94%47 887,000 586,000 1.70%56 1,054,000 654,000 1.61%67 1,271,000 675,000 1.69%178 3,351,000 1,510,000 2.82%255 4,842,000 2,682,000 3.99%383 7,244,000 3,847,000 4.71%441 8,371,000 5,563,000 5.51%431 8,138,000 4,759,000 5.00%422 7,989,000 6,653,000 5.72%491 9,323,000 6,355,000 5.57%3,294 62,344,000 38,824,000 4.43%20,000 25,000 5,000 411 9,325,000 4,780,000 5.73%136 3,098,000 1,563,000 3.16%52 1,178,000 708,000 2.05%52 1,181,000 801,000 1.97%59 1,337,000 767,000 1.93%141 3,193,000 1,643,000 3.06%269 6,123,000 3,023,000 4.50%376 8,571,000 4,361,000 5.34%527 12,044,000 6,684,000 6.62%482 11,065,000 5,595,000 5.87%638 14,570,000 8,350,000 7.18%584 13,295,000 7,660,000 6.72%3,727 84,980,000 45,935,000 5.24% 25,000 29,000 4,000 220 6,024,000 2,584,000 3.10%66 1,802,000 836,000 1.69%16 437,000 429,000 1.24%27 734,000 479,000 1.18%32 865,000 425,000 1.07%70 1,916,000 902,000 1.68%140 3,825,000 1,589,000 2.37%225 6,139,000 2,262,000 2.77%307 8,415,000 3,656,000 3.62%228 6,225,000 2,949,000 3.10%358 9,828,000 4,678,000 4.02%323 8,842,000 4,311,000 3.78%2,012 55,052,000 25,100,000 2.86%29,000 34,000 5,000 183 5,841,000 2,194,000 2.63%43 1,373,000 766,000 1.55%17 545,000 457,000 1.32%22 706,000 483,000 1.19%13 411,000 419,000 1.05%50 1,570,000 790,000 1.47%107 3,420,000 1,362,000 2.03%145 4,592,000 1,847,000 2.26%231 7,363,000 3,154,000 3.12%202 6,433,000 2,595,000 2.72%288 9,160,000 4,118,000 3.54%273 8,706,000 3,854,000 3.38%1,574 50,120,000 22,039,000 2.51%34,000 39,000 5,000 85 3,111,000 1,456,000 1.74%19 691,000 590,000 1.19%11 412,000 388,000 1.12%10 374,000 399,000 0.98%13 483,000 361,000 0.91%15 552,000 637,000 1.19%50 1,844,000 939,000 1.40%89 3,272,000 1,261,000 1.54%147 5,427,000 2,184,000 2.16%124 4,576,000 1,760,000 1.85%199 7,298,000 2,847,000 2.45%170 6,214,000 2,649,000 2.32%932 34,254,000 15,471,000 1.76%39,000 44,000 5,000 63 2,632,000 1,095,000 1.31%16 676,000 517,000 1.05%10 422,000 332,000 0.96%8 332,000 345,000 0.85%7 289,000 301,000 0.76%14 591,000 570,000 1.06%24 1,007,000 746,000 1.11%44 1,816,000 895,000 1.10%94 3,925,000 1,544,000 1.53%84 3,532,000 1,236,000 1.30%127 5,319,000 2,046,000 1.76%109 4,569,000 1,988,000 1.74%600 25,110,000 11,615,000 1.32%44,000 50,000 6,000 38 1,800,000 1,004,000 1.20%12 556,000 514,000 1.04%9 421,000 331,000 0.96%7 331,000 371,000 0.91%6 276,000 318,000 0.80%9 420,000 600,000 1.12%21 995,000 755,000 1.12%38 1,796,000 850,000 1.04%62 2,944,000 1,386,000 1.37%43 2,013,000 1,039,000 1.09%82 3,859,000 1,775,000 1.53%103 4,871,000 1,725,000 1.51%430 20,282,000 10,668,000 1.22% 50,000 59,000 9,000 24 1,307,000 1,205,000 1.44%9 479,000 677,000 1.37%7 383,000 429,000 1.24%8 430,000 480,000 1.18%4 209,000 432,000 1.08%21 1,143,000 768,000 1.43%21 1,153,000 940,000 1.40%20 1,090,000 999,000 1.22%59 3,193,000 1,467,000 1.45%33 1,802,000 1,232,000 1.29%79 4,290,000 1,915,000 1.65%61 3,319,000 1,799,000 1.58%346 18,798,000 12,343,000 1.41%59,000 69,000 10,000 23 1,481,000 1,114,000 1.34%14 888,000 642,000 1.30%4 256,000 420,000 1.22%9 584,000 463,000 1.14%9 575,000 424,000 1.06%14 901,000 685,000 1.28%13 825,000 858,000 1.28%18 1,162,000 930,000 1.14%30 1,936,000 1,226,000 1.21%17 1,089,000 1,116,000 1.17%51 3,299,000 1,530,000 1.32%38 2,428,000 1,506,000 1.32%240 15,424,000 10,914,000 1.24%69,000 +99 21,516,000 14,685,000 17.60%58 12,190,000 8,188,000 16.56%40 7,665,000 4,905,000 14.19%41 10,336,000 7,507,000 18.47%38 10,020,000 7,398,000 18.57%61 13,757,000 9,548,000 17.81%80 17,312,000 11,792,000 17.56%83 19,626,000 13,899,000 17.03%106 24,649,000 17,335,000 17.16%103 25,623,000 18,516,000 19.44%124 30,686,000 22,130,000 19.03%132 31,605,000 22,497,000 19.73%965 224,985,000 158,400,000 18.06%4,194 83,439,000 83,439,000 100.00%4,210 49,448,000 49,448,000 100.00%4,222 34,557,000 34,557,000 100.00%4,245 40,639,000 40,639,000 100.00%4,261 39,829,000 39,829,000 100.00%4,290 53,616,000 53,616,000 100.00%4,303 67,140,000 67,140,000 100.00%4,331 81,624,000 81,624,000 100.00%4,354 101,038,000 101,038,000 100.00%4,340 95,260,000 95,260,000 100.00%4,393 116,290,000 116,290,000 100.00%4,367 114,031,000 114,031,000 100.00%51,510 876,911,000 876,911,000 100.00% FY 2015 Beginning End Block Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % ConsumptionBlockBlockValueAccountsReportedTotalBy Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block- 1,000 1,000 147 60,000 4,292,000 4.47%200 89,000 4,282,000 7.14%255 118,000 4,269,000 8.47%317 150,000 4,236,000 11.71%314 149,000 4,249,000 10.89%442 211,000 4,207,000 13.53%348 155,000 4,270,000 7.74%396 192,000 4,273,000 10.35%276 111,000 4,345,000 6.58%213 78,000 4,366,000 4.20%163 56,000 4,421,000 3.12%164 61,000 4,420,000 3.48%3,235 1,430,000 51,630,000 6.09% 1,000 2,000 1,000 79 158,000 4,232,000 4.40%145 290,000 4,193,000 6.99%213 426,000 4,151,000 8.23%315 630,000 4,086,000 11.30%322 644,000 4,100,000 10.50%511 1,022,000 3,996,000 12.85%256 512,000 4,115,000 7.46%354 708,000 4,081,000 9.88%130 260,000 4,234,000 6.42%98 196,000 4,288,000 4.13%61 122,000 4,365,000 3.08%67 134,000 4,359,000 3.43%2,551 5,102,000 50,200,000 5.92%2,000 3,000 1,000 105 315,000 4,153,000 4.32%231 693,000 4,048,000 6.75%352 1,056,000 3,938,000 7.81%500 1,500,000 3,771,000 10.43%464 1,392,000 3,778,000 9.68%744 2,232,000 3,485,000 11.21%436 1,308,000 3,859,000 7.00%509 1,527,000 3,727,000 9.03%168 504,000 4,104,000 6.22%109 327,000 4,190,000 4.03%56 168,000 4,304,000 3.03%76 228,000 4,292,000 3.37%3,750 11,250,000 47,649,000 5.62%3,000 4,000 1,000 122 488,000 4,048,000 4.21%276 1,104,000 3,817,000 6.37%501 2,004,000 3,586,000 7.11%584 2,336,000 3,271,000 9.05%567 2,268,000 3,314,000 8.49%734 2,936,000 2,741,000 8.81%471 1,884,000 3,423,000 6.21%512 2,048,000 3,218,000 7.79%260 1,040,000 3,936,000 5.96%129 516,000 4,081,000 3.93%73 292,000 4,248,000 2.99%77 308,000 4,216,000 3.31%4,306 17,224,000 43,899,000 5.18%4,000 5,000 1,000 129 645,000 3,926,000 4.09%304 1,520,000 3,541,000 5.91%512 2,560,000 3,085,000 6.12%624 3,120,000 2,687,000 7.43%583 2,915,000 2,747,000 7.04%591 2,955,000 2,007,000 6.45%457 2,285,000 2,952,000 5.35%547 2,735,000 2,706,000 6.55%259 1,295,000 3,676,000 5.57%120 600,000 3,952,000 3.80%54 270,000 4,175,000 2.94%75 375,000 4,139,000 3.25%4,255 21,275,000 39,593,000 4.67%5,000 6,000 1,000 133 798,000 3,797,000 3.95%344 2,064,000 3,237,000 5.40%461 2,766,000 2,573,000 5.10%506 3,036,000 2,063,000 5.71%476 2,856,000 2,164,000 5.54%399 2,394,000 1,416,000 4.55%354 2,124,000 2,495,000 4.53%482 2,892,000 2,159,000 5.23%300 1,800,000 3,417,000 5.18%124 744,000 3,832,000 3.69%60 360,000 4,121,000 2.91%91 546,000 4,064,000 3.20%3,730 22,380,000 35,338,000 4.17% 6,000 7,000 1,000 155 1,085,000 3,664,000 3.81%307 2,149,000 2,893,000 4.83%349 2,443,000 2,112,000 4.19%358 2,506,000 1,557,000 4.31%334 2,338,000 1,688,000 4.32%262 1,834,000 1,017,000 3.27%310 2,170,000 2,141,000 3.88%341 2,387,000 1,677,000 4.06%291 2,037,000 3,117,000 4.72%113 791,000 3,708,000 3.57%66 462,000 4,061,000 2.86%77 539,000 3,973,000 3.12%2,963 20,741,000 31,608,000 3.73%7,000 8,000 1,000 148 1,184,000 3,509,000 3.65%299 2,392,000 2,586,000 4.31%270 2,160,000 1,763,000 3.50%255 2,040,000 1,199,000 3.32%241 1,928,000 1,354,000 3.47%177 1,416,000 755,000 2.43%263 2,104,000 1,831,000 3.32%227 1,816,000 1,336,000 3.24%270 2,160,000 2,826,000 4.28%134 1,072,000 3,595,000 3.46%69 552,000 3,995,000 2.82%91 728,000 3,896,000 3.06%2,444 19,552,000 28,645,000 3.38%8,000 9,000 1,000 151 1,359,000 3,361,000 3.50%306 2,754,000 2,287,000 3.82%193 1,737,000 1,493,000 2.96%198 1,782,000 944,000 2.61%184 1,656,000 1,113,000 2.85%117 1,053,000 578,000 1.86%196 1,764,000 1,568,000 2.84%195 1,755,000 1,109,000 2.69%247 2,223,000 2,556,000 3.87%161 1,449,000 3,461,000 3.33%71 639,000 3,926,000 2.77%106 954,000 3,805,000 2.99%2,125 19,125,000 26,201,000 3.09%9,000 14,000 5,000 906 10,946,000 14,312,000 14.90%1,000 11,756,000 7,661,000 12.78%634 7,357,000 4,981,000 9.88%435 4,959,000 2,599,000 7.19%518 6,015,000 3,408,000 8.73%266 3,004,000 1,585,000 5.10%705 8,195,000 5,185,000 9.40%501 5,798,000 3,354,000 8.12%1,068 12,603,000 9,196,000 13.93%840 10,065,000 14,805,000 14.25%523 6,359,000 18,312,000 12.91%698 8,478,000 17,201,000 13.52%8,094 95,535,000 102,599,000 12.10%14,000 17,000 3,000 532 8,533,000 6,401,000 6.66%339 5,369,000 2,549,000 4.25%179 2,855,000 1,810,000 3.59%83 1,312,000 834,000 2.31%115 1,829,000 1,107,000 2.84%43 685,000 539,000 1.73%220 3,499,000 1,760,000 3.19%133 2,111,000 1,089,000 2.64%407 6,466,000 3,270,000 4.95%454 7,280,000 6,942,000 6.68%347 5,562,000 9,659,000 6.81%489 7,840,000 8,530,000 6.71%3,341 53,341,000 44,490,000 5.25% 17,000 20,000 3,000 452 8,568,000 4,844,000 5.04%180 3,407,000 1,733,000 2.89%130 2,457,000 1,318,000 2.61%60 1,132,000 616,000 1.70%65 1,232,000 820,000 2.10%27 506,000 422,000 1.36%137 2,590,000 1,191,000 2.16%78 1,467,000 747,000 1.81%247 4,647,000 2,209,000 3.35%419 7,933,000 5,571,000 5.36%428 8,121,000 8,516,000 6.00%463 8,760,000 7,036,000 5.53%2,686 50,820,000 35,023,000 4.13%20,000 25,000 5,000 494 11,331,000 5,581,000 5.81%166 3,786,000 1,946,000 3.25%114 2,571,000 1,506,000 2.99%51 1,153,000 718,000 1.99%84 1,892,000 947,000 2.43%31 702,000 552,000 1.78%120 2,697,000 1,247,000 2.26%63 1,417,000 852,000 2.06%257 5,836,000 2,346,000 3.55%531 12,143,000 6,803,000 6.55%664 15,169,000 11,354,000 8.00%642 14,669,000 8,864,000 6.97%3,217 73,366,000 42,716,000 5.04%25,000 29,000 4,000 228 6,238,000 2,930,000 3.05%91 2,479,000 1,024,000 1.71%65 1,760,000 847,000 1.68%18 486,000 432,000 1.19%30 828,000 546,000 1.40%20 550,000 346,000 1.11%51 1,397,000 678,000 1.23%28 774,000 518,000 1.25%102 2,769,000 1,131,000 1.71%293 8,037,000 3,764,000 3.62%430 11,789,000 6,891,000 4.86%345 9,417,000 5,040,000 3.96%1,701 46,524,000 24,147,000 2.85%29,000 34,000 5,000 196 6,253,000 2,579,000 2.68%42 1,346,000 943,000 1.57%44 1,395,000 789,000 1.56%19 610,000 459,000 1.27%29 925,000 524,000 1.34%9 292,000 356,000 1.14%38 1,194,000 597,000 1.08%29 921,000 490,000 1.19%59 1,867,000 1,001,000 1.52%248 7,891,000 3,274,000 3.15%393 12,496,000 6,449,000 4.55%328 10,432,000 4,590,000 3.61%1,434 45,622,000 22,051,000 2.60%34,000 39,000 5,000 127 4,692,000 1,749,000 1.82%31 1,142,000 748,000 1.25%28 1,027,000 605,000 1.20%14 511,000 365,000 1.01%18 670,000 408,000 1.05%10 369,000 304,000 0.98%19 689,000 453,000 0.82%15 547,000 372,000 0.90%42 1,562,000 769,000 1.17%148 5,441,000 2,244,000 2.16%292 10,737,000 4,699,000 3.31%212 7,804,000 3,206,000 2.52%956 35,191,000 15,922,000 1.88% 39,000 44,000 5,000 65 2,715,000 1,230,000 1.28%25 1,046,000 606,000 1.01%10 417,000 507,000 1.01%14 586,000 300,000 0.83%8 333,000 331,000 0.85%8 344,000 267,000 0.86%14 580,000 374,000 0.68%6 255,000 326,000 0.79%23 962,000 585,000 0.89%97 4,059,000 1,626,000 1.56%202 8,476,000 3,478,000 2.45%145 6,022,000 2,252,000 1.77%617 25,795,000 11,882,000 1.40%44,000 50,000 6,000 46 2,187,000 1,147,000 1.19%17 801,000 593,000 0.99%10 475,000 551,000 1.09%8 384,000 296,000 0.82%8 389,000 361,000 0.92%6 276,000 258,000 0.83%7 337,000 395,000 0.72%13 617,000 333,000 0.81%18 847,000 571,000 0.87%67 3,174,000 1,444,000 1.39%166 7,865,000 3,021,000 2.13%93 4,398,000 2,010,000 1.58%459 21,750,000 10,980,000 1.29%50,000 59,000 9,000 39 2,131,000 1,306,000 1.36%9 503,000 782,000 1.30%13 706,000 713,000 1.41%8 436,000 360,000 1.00%10 555,000 451,000 1.16%5 273,000 347,000 1.12%8 448,000 525,000 0.95%10 545,000 387,000 0.94%16 863,000 693,000 1.05%65 3,536,000 1,528,000 1.47%135 7,356,000 3,081,000 2.17%81 4,396,000 2,173,000 1.71%399 21,748,000 12,346,000 1.46%59,000 69,000 10,000 21 1,355,000 1,156,000 1.20%14 906,000 750,000 1.25%11 714,000 685,000 1.36%9 584,000 323,000 0.89%8 527,000 415,000 1.06%5 325,000 340,000 1.09%11 698,000 469,000 0.85%3 191,000 364,000 0.88%10 636,000 646,000 0.98%34 2,198,000 1,232,000 1.19%82 5,215,000 2,307,000 1.63%52 3,335,000 1,777,000 1.40%260 16,684,000 10,464,000 1.23%69,000 +104 25,039,000 17,863,000 18.59%67 14,351,000 9,728,000 16.23%62 13,426,000 9,148,000 18.14%27 6,907,000 5,044,000 13.95%36 7,692,000 5,208,000 13.34%31 7,718,000 5,579,000 17.94%42 18,507,000 15,609,000 28.31%35 10,588,000 8,173,000 19.79%60 15,512,000 11,372,000 17.23%104 26,400,000 19,224,000 18.50%193 39,782,000 26,465,000 18.66%151 37,767,000 27,348,000 21.50%912 223,689,000 160,761,000 18.95% 4,379 96,080,000 96,080,000 100.00%4,393 59,947,000 59,947,000 100.00%4,406 50,430,000 50,430,000 100.00%4,403 36,160,000 36,160,000 100.00%4,414 39,033,000 39,033,000 100.00%4,438 31,097,000 31,097,000 100.00%4,463 55,137,000 55,137,000 100.00%4,477 41,291,000 41,291,000 100.00%4,510 66,000,000 66,000,000 100.00%4,501 103,930,000 103,930,000 100.00%4,528 141,848,000 141,848,000 100.00%4,523 127,191,000 127,191,000 100.00%53,435 848,144,000 848,144,000 100.00%PROJECTED REVENUE Projected Number of Meters - Oct 1st 4,620 Projected Growth Rate 0.50% Projected Accounts 4,622 4,624 4,626 4,628 4,630 4,632 4,634 4,636 4,638 4,640 4,642 4,644 4,646 Projected Average Con per Account 21,217 14,808 10,632 9,340 9,000 10,115 14,103 15,772 19,819 23,904 29,858 27,338 17,240 Projected Consumption 98,065,559 68,473,408 49,184,261 43,223,548 41,668,783 46,854,925 65,351,655 73,120,233 91,920,999 110,913,615 138,600,586 126,959,447 80,098,957 Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue- 1,000 1,000 4.58%4,487,842 3.96 17,772$ 6.58%4,505,050 3.96 17,840$ 9.07%4,461,135 3.96 17,666$ 10.30%4,451,962 3.96 17,630$ 10.63%4,428,393 3.96 17,536$ 9.50%4,449,840 3.96 17,621$ 6.83%4,464,783 3.96 17,681$ 6.15%4,499,818 3.96 17,819$ 4.91%4,512,157 3.96 17,868$ 4.06%4,504,397 3.96 17,837$ 3.26%4,519,885 3.96 17,899$ 3.56%4,522,642 3.96 17,910$ 53,807,905 3.96 213,079$ 1,000 2,000 1,000 4.49%4,406,090 3.96 17,448 6.41%4,391,586 3.96 17,391 8.73%4,294,760 3.96 17,007 9.95%4,301,805 3.96 17,035 10.20%4,251,535 3.96 16,836 9.12%4,275,092 3.96 16,929 6.63%4,333,434 3.96 17,160 5.97%4,362,328 3.96 17,275 4.81%4,421,540 3.96 17,509 4.00%4,435,270 3.96 17,564 3.22%4,461,324 3.96 17,667 3.51%4,457,906 3.96 17,653 52,392,671 3.96 207,475 2,000 3,000 1,000 4.38%4,299,924 3.96 17,028 6.16%4,216,369 3.96 16,697 8.16%4,011,074 3.96 15,884 9.32%4,029,898 3.96 15,958 9.39%3,911,003 3.96 15,488 8.43%3,948,264 3.96 15,635 6.31%4,122,259 3.96 16,324 5.68%4,155,185 3.96 16,455 4.70%4,316,539 3.96 17,093 3.91%4,340,353 3.96 17,188 3.17%4,398,858 3.96 17,419 3.46%4,398,505 3.96 17,418 50,148,233 3.96 198,587 3,000 4,000 1,000 4.25%4,165,644 3.96 16,496 5.77%3,953,358 3.96 15,655 7.30%3,590,526 3.96 14,218 8.34%3,603,038 3.96 14,268 8.19%3,410,822 3.96 13,507 7.35%3,445,591 3.96 13,645 5.82%3,806,223 3.96 15,073 5.30%3,878,028 3.96 15,357 4.55%4,185,648 3.96 16,575 3.82%4,238,632 3.96 16,785 3.13%4,333,553 3.96 17,161 3.40%4,322,743 3.96 17,118 46,933,805 3.96 185,858 4,000 5,000 1,000 4.10%4,023,595 3.96 15,933 5.30%3,629,709 3.96 14,374 6.23%3,065,209 3.96 12,138 7.07%3,057,012 3.96 12,106 6.73%2,804,454 3.96 11,106 6.19%2,899,780 3.96 11,483 5.26%3,437,575 3.96 13,613 4.90%3,580,192 3.96 14,178 4.36%4,005,133 3.96 15,860 3.72%4,126,523 3.96 16,341 3.07%4,252,987 3.96 16,842 3.34%4,245,557 3.96 16,812 43,127,725 3.96 170,786 5,000 6,000 1,000 3.93%3,853,433 3.96 15,260 4.83%3,305,315 3.96 13,089 5.17%2,544,688 3.96 10,077 5.75%2,484,790 3.96 9,840 5.38%2,240,560 3.96 8,873 5.09%2,387,237 3.96 9,453 4.71%3,078,723 3.96 12,192 4.47%3,267,121 3.96 12,938 4.16%3,819,583 3.96 15,126 3.62%4,010,475 3.96 15,881 3.02%4,178,809 3.96 16,548 3.28%4,160,191 3.96 16,474 39,330,925 3.96 155,750 6,000 7,000 1,000 3.76%3,682,901 4.61 16,978 4.35%2,980,922 4.61 13,742 4.26%2,097,209 4.61 9,668 4.54%1,962,376 4.61 9,047 4.23%1,762,716 4.61 8,126 4.25%1,990,217 4.61 9,175 4.20%2,747,810 4.61 12,667 4.06%2,966,746 4.61 13,677 3.94%3,620,729 4.61 16,692 3.51%3,889,770 4.61 17,932 2.96%4,099,307 4.61 18,898 3.21%4,079,804 4.61 18,808 35,880,507 4.61 165,409 7,000 8,000 1,000 3.56%3,493,133 4.61 16,103 3.93%2,688,521 4.61 12,394 3.56%1,748,597 4.61 8,061 3.58%1,545,846 4.61 7,126 3.42%1,424,380 4.61 6,566 3.58%1,677,281 4.61 7,732 3.73%2,434,677 4.61 11,224 3.72%2,720,424 4.61 12,541 3.72%3,421,515 4.61 15,773 3.40%3,769,424 4.61 17,377 2.90%4,022,290 4.61 18,543 3.14%3,980,921 4.61 18,352 32,927,009 4.61 151,794 8,000 9,000 1,000 3.39%3,320,751 4.61 15,309 3.55%2,428,114 4.61 11,194 2.98%1,463,435 4.61 6,746 2.83%1,225,240 4.61 5,648 2.78%1,158,911 4.61 5,343 3.04%1,422,472 4.61 6,558 3.33%2,176,332 4.61 10,033 3.45%2,520,899 4.61 11,621 3.51%3,229,493 4.61 14,888 3.28%3,633,318 4.61 16,750 2.85%3,945,627 4.61 18,189 3.06%3,884,884 4.61 17,909 30,409,477 4.61 140,188 9,000 14,000 5,000 14.28%14,001,016 4.61 64,545 12.97%8,879,896 4.61 40,936 9.60%4,722,318 4.61 21,770 8.03%3,471,328 4.61 16,003 8.38%3,492,110 4.61 16,099 9.80%4,593,513 4.61 21,176 12.00%7,839,586 4.61 36,140 13.40%9,797,371 4.61 45,166 14.36%13,201,332 4.61 60,858 14.23%15,780,075 4.61 72,746 13.12%18,182,822 4.61 83,823 13.75%17,459,925 4.61 80,490 121,421,292 4.61 559,752 14,000 17,000 3,000 6.41%6,287,492 4.61 28,985 4.91%3,364,093 4.61 15,508 3.27%1,606,569 4.61 7,406 2.44%1,055,529 4.61 4,866 2.69%1,121,928 4.61 5,172 3.40%1,591,004 4.61 7,335 4.62%3,018,128 4.61 13,914 5.55%4,054,698 4.61 18,692 6.23%5,729,016 4.61 26,411 6.71%7,438,917 4.61 34,293 6.81%9,434,085 4.61 43,491 6.82%8,659,002 4.61 39,918 53,360,460 4.61 245,992 17,000 20,000 3,000 4.92%4,820,768 5.34 25,743 3.55%2,428,486 5.34 12,968 2.35%1,157,615 5.34 6,182 1.73%747,466 5.34 3,991 1.95%811,420 5.34 4,333 2.39%1,119,040 5.34 5,976 3.34%2,182,138 5.34 11,653 4.13%3,018,622 5.34 16,119 4.78%4,394,211 5.34 23,465 5.39%5,979,716 5.34 31,932 5.87%8,140,762 5.34 43,472 5.61%7,128,453 5.34 38,066 41,928,698 5.34 223,899 20,000 25,000 5,000 5.77%5,663,070 5.34 30,241 4.02%2,753,623 5.34 14,704 2.74%1,348,707 5.34 7,202 2.06%890,245 5.34 4,754 2.22%924,565 5.34 4,937 2.69%1,260,885 5.34 6,733 3.70%2,416,534 5.34 12,904 4.75%3,476,803 5.34 18,566 5.58%5,131,734 5.34 27,403 6.60%7,324,302 5.34 39,112 7.74%10,733,441 5.34 57,317 6.99%8,879,176 5.34 47,415 50,803,085 5.34 271,288 25,000 29,000 4,000 3.14%3,078,085 6.20 19,084 2.15%1,473,534 6.20 9,136 1.54%757,725 6.20 4,698 1.23%531,269 6.20 3,294 1.28%532,403 6.20 3,301 1.47%687,656 6.20 4,263 1.93%1,262,331 6.20 7,826 2.53%1,850,498 6.20 11,473 2.97%2,728,942 6.20 16,919 3.64%4,041,636 6.20 25,058 4.61%6,395,984 6.20 39,655 3.95%5,014,922 6.20 31,093 28,354,986 6.20 175,801 29,000 34,000 5,000 2.74%2,686,343 6.20 16,655 1.94%1,329,566 6.20 8,243 1.46%718,253 6.20 4,453 1.24%537,910 6.20 3,335 1.26%525,446 6.20 3,258 1.35%630,625 6.20 3,910 1.66%1,084,175 6.20 6,722 2.16%1,578,419 6.20 9,786 2.54%2,339,144 6.20 14,503 3.20%3,550,221 6.20 22,011 4.26%5,899,098 6.20 36,574 3.53%4,485,650 6.20 27,811 25,364,851 6.20 157,262 34,000 39,000 5,000 1.87%1,834,422 6.20 11,373 1.46%999,965 6.20 6,200 1.16%571,430 6.20 3,543 1.01%438,297 6.20 2,717 1.04%433,905 6.20 2,690 1.10%515,833 6.20 3,198 1.17%767,776 6.20 4,760 1.48%1,083,961 6.20 6,721 1.78%1,638,660 6.20 10,160 2.21%2,447,045 6.20 15,172 3.04%4,218,560 6.20 26,155 2.45%3,105,915 6.20 19,257 18,055,769 6.20 111,946 39,000 44,000 5,000 1.35%1,328,005 6.20 8,234 1.16%795,731 6.20 4,934 1.00%492,484 6.20 3,053 0.87%374,471 6.20 2,322 0.88%367,629 6.20 2,279 0.96%449,298 6.20 2,786 0.94%612,116 6.20 3,795 1.07%779,596 6.20 4,833 1.29%1,182,338 6.20 7,330 1.57%1,740,368 6.20 10,790 2.24%3,103,761 6.20 19,243 1.76%2,232,688 6.20 13,843 13,458,485 6.20 83,443 44,000 50,000 6,000 1.24%1,217,769 6.20 7,550 1.11%760,390 6.20 4,714 1.07%524,210 6.20 3,250 0.89%385,539 6.20 2,390 0.94%392,162 6.20 2,431 0.98%456,975 6.20 2,833 0.96%628,807 6.20 3,899 1.03%749,486 6.20 4,647 1.16%1,062,594 6.20 6,588 1.35%1,496,809 6.20 9,280 1.94%2,694,185 6.20 16,704 1.53%1,947,066 6.20 12,072 12,315,993 6.20 76,359 50,000 59,000 9,000 1.42%1,393,480 7.21 10,047 1.40%957,556 7.21 6,904 1.40%689,109 7.21 4,968 1.16%501,385 7.21 3,615 1.23%514,461 7.21 3,709 1.27%592,971 7.21 4,275 1.22%796,803 7.21 5,745 1.19%872,466 7.21 6,290 1.28%1,173,348 7.21 8,460 1.47%1,635,781 7.21 11,794 1.98%2,740,680 7.21 19,760 1.62%2,058,042 7.21 14,838 13,926,082 7.21 100,407 59,000 69,000 10,000 1.29%1,264,379 7.21 9,116 1.29%884,641 7.21 6,378 1.36%666,606 7.21 4,806 1.10%475,191 7.21 3,426 1.19%494,688 7.21 3,567 1.18%554,585 7.21 3,999 1.09%715,164 7.21 5,156 1.08%789,391 7.21 5,692 1.12%1,026,634 7.21 7,402 1.22%1,351,033 7.21 9,741 1.50%2,080,886 7.21 15,003 1.33%1,685,276 7.21 12,151 11,988,474 7.21 86,437 69,000 +19.13%18,757,418 7.21 135,241 17.16%11,746,982 7.21 84,696 17.59%8,652,602 7.21 62,385 16.55%7,152,950 7.21 51,573 16.00%6,665,292 7.21 48,057 16.87%7,906,764 7.21 57,008 20.54%13,426,280 7.21 96,803 17.94%13,118,182 7.21 94,582 18.26%16,780,708 7.21 120,989 19.10%21,179,549 7.21 152,705 19.31%26,763,683 7.21 192,966 20.68%26,250,178 7.21 189,264 178,400,588 7.21 1,286,268 100.00%98,065,559 515,141$ 100.00%68,473,408 347,697$ 100.00%49,184,261 245,184$ 100.00%43,223,548 210,945$ 100.00%41,668,783 203,213$ 100.00%46,854,925 231,723$ 100.00%65,351,655 335,284$ 100.00%73,120,233 374,428$ 100.00%91,920,999 477,873$ 100.00%110,913,615 588,289$ 100.00%138,600,586 753,329$ 100.00%126,959,447 684,672$ 954,337,019 4,967,780$ Total Base Projected Revenue Summary: Base Charges Rates Projected Revenue Rate Current Meter Monthly Volumetric Revenue 4,967,780$ 5/8" x 3/4"17.15 55,596 953,471$ Increment Count Revenue Base Charge Revenue 1"32.23 15.08 1,947 29,361$ Base 953,471$ 1 1/2"56.94 39.79 11 438 Increment (x 12)515,483 2"86.58 69.43 103 7,151 Base Subtotal1,468,954$ 3"155.76 138.61 21 2,911 4"254.59 237.44 11 2,612 6"501.64 484.49 1 484 Total Projected Revenue 6,436,734$ 42,957$ TABLE GF-D 2 A B C DMONTH SHUTOFFS FOR NON-PAYMENT LATE FEES ($/Month) METER SET FEES MUD Jan-16 40 9,896.38 6 $11,400 Feb-16 36 5,297.44 5 $119,260Mar-16 41 8,033.88 7 $21,609Apr-16 40 9,304.01 2May-15 29 8,422.15 4Jun-15 17 6,349.43 2Jul-15 24 8,144.46 1Aug-15 25 12,621.50 5Sep-15 34 16,723.68 11 Oct-15 64 13,106.13 9Nov-15 56 13,144.40 3 Dec-15 45 8,216.57 8 Total 451 $119,260 63 Average Per Month 38 $9,938 5 MARCHOCTOBERNOVEMBERDECEMBERJANUARYFEBURARY TOTALAPRILMAYJUNEJULYAUGUSTSEPTEMBER OCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCH TOTALJULYAUGUSTSEPTEMBERAPRILMAYJUNE OCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCH TOTALJULYAUGUSTSEPTEMBERAPRILMAYJUNE OCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCH TOTALAUGUSTSEPTEMBER Increment Above Base APRIL MAY JUNE JULY REVENUE FOR MUD TAP FEES: OTHER REVENUE SOURCES REVENUE FOR SHUTOFFS (MO. AVE. X 12 x $25):TOTAL LATE FEES: GROWTH RATE : .50% recommended Trophy Club Municipal Utility District No. 1 20 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,000 216 4,487,842 266 4,505,050 341 4,461,135 343 4,451,962 377 4,428,393 379 4,449,840 309 4,464,783 312 4,499,818 238 4,512,157 214 4,504,397 183 4,519,885 186 4,522,642 1,000 to 2,000 106 4,406,090 174 4,391,586 283 4,294,760 271 4,301,805 341 4,251,535 325 4,275,092 211 4,333,434 205 4,362,328 104 4,421,540 95 4,435,270 62 4,461,324 59 4,457,906 2,000 to 3,000 134 4,299,924 261 4,216,369 420 4,011,074 425 4,029,898 500 3,911,003 500 3,948,264 315 4,122,259 275 4,155,185 130 4,316,539 101 4,340,353 65 4,398,858 76 4,398,505 3,000 to 4,000 142 4,165,644 321 3,953,358 524 3,590,526 544 3,603,038 607 3,410,822 543 3,445,591 368 3,806,223 295 3,878,028 180 4,185,648 112 4,238,632 81 4,333,553 77 4,322,743 4,000 to 5,000 170 4,023,595 322 3,629,709 519 3,065,209 570 3,057,012 564 2,804,454 510 2,899,780 358 3,437,575 310 3,580,192 185 4,005,133 116 4,126,523 74 4,252,987 85 4,245,557 5,000 to 6,000 171 3,853,433 322 3,305,315 446 2,544,688 520 2,484,790 478 2,240,560 395 2,387,237 330 3,078,723 298 3,267,121 198 3,819,583 120 4,010,475 79 4,178,809 80 4,160,191 6,000 to 7,000 190 3,682,901 290 2,980,922 348 2,097,209 415 1,962,376 338 1,762,716 311 1,990,217 313 2,747,810 244 2,966,746 198 3,620,729 120 3,889,770 77 4,099,307 99 4,079,804 7,000 to 8,000 172 3,493,133 258 2,688,521 285 1,748,597 319 1,545,846 266 1,424,380 253 1,677,281 258 2,434,677 198 2,720,424 191 3,421,515 136 3,769,424 77 4,022,290 96 3,980,921 8,000 to 9,000 164 3,320,751 245 2,428,114 208 1,463,435 232 1,225,240 193 1,158,911 204 1,422,472 238 2,176,332 209 2,520,899 191 3,229,493 150 3,633,318 90 3,945,627 117 3,884,884 9,000 to 14,000 896 14,001,016 919 8,879,896 655 4,722,318 595 3,471,328 544 3,492,110 620 4,593,513 824 7,839,586 819 9,797,371 956 13,201,332 835 15,780,075 587 18,182,822 721 17,459,925 14,000 to 17,000 500 6,287,492 356 3,364,093 173 1,606,569 121 1,055,529 129 1,121,928 177 1,591,004 310 3,018,128 368 4,054,698 474 5,729,016 493 7,438,917 404 9,434,085 504 8,659,002 17,000 to 20,000 425 4,820,768 239 2,428,486 105 1,157,615 66 747,466 70 811,420 110 1,119,040 214 2,182,138 285 3,018,622 380 4,394,211 447 5,979,716 435 8,140,762 484 7,128,453 20,000 to 25,000 469 5,663,070 237 2,753,623 108 1,348,707 63 890,245 79 924,565 113 1,260,885 227 2,416,534 293 3,476,803 434 5,131,734 573 7,324,302 667 10,733,441 661 8,879,176 25,000 to 29,000 242 3,078,085 114 1,473,534 52 757,725 28 531,269 29 532,403 50 687,656 110 1,262,331 158 1,850,498 237 2,728,942 302 4,041,636 412 6,395,984 361 5,014,922 29,000 to 34,000 207 2,686,343 76 1,329,566 38 718,253 22 537,910 23 525,446 32 630,625 77 1,084,175 121 1,578,419 174 2,339,144 266 3,550,221 383 5,899,098 322 4,485,650 34,000 to 39,000 118 1,834,422 52 999,965 20 571,430 14 438,297 15 433,905 16 515,833 41 767,776 74 1,083,961 104 1,638,660 167 2,447,045 268 4,218,560 206 3,105,915 39,000 to 44,000 74 1,328,005 33 795,731 10 492,484 12 374,471 10 367,629 12 449,298 21 612,116 36 779,596 68 1,182,338 111 1,740,368 182 3,103,761 139 2,232,688 44,000 to 50,000 53 1,217,769 23 760,390 10 524,210 9 385,539 7 392,162 10 456,975 16 628,807 28 749,486 46 1,062,594 72 1,496,809 148 2,694,185 102 1,947,066 50,000 to 59,000 35 1,393,480 18 957,556 11 689,109 8 501,385 9 514,461 12 592,971 17 796,803 24 872,466 41 1,173,348 58 1,635,781 123 2,740,680 76 2,058,042 59,000 to 69,000 23 1,264,379 17 884,641 10 666,606 8 475,191 7 494,688 8 554,585 12 715,164 13 789,391 19 1,026,634 34 1,351,033 73 2,080,886 47 1,685,276 69,000 ++114 18,757,418 80 11,746,982 60 8,652,602 43 7,152,950 45 6,665,292 51 7,906,764 66 13,426,280 72 13,118,182 92 16,780,708 117 21,179,549 171 26,763,683 145 26,250,178 WASTEWATER RATES FOR ALL METER SIZES Gallons Included in Minimum Bill =0 % of Sewer Meters not Subject to Cap 2.23%$ Amount of Minimum Bill =17.5 MIN BILL =$17.50 0 to 6,999 $2.84 7,000 to 18,000 $2.84 Oct 10 Nov 11 Dec 12 Jan 1 Feb 2 Mar 3 Apr 4 May 5 Jun 6 Jul 7 Aug 8 Sep 9 Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Accounts Usage Accounts Usage Accounts Usage 0 to 1,000 $3,787 $12,745 $4,658 $12,794 $5,971 $12,670 $5,994 $12,644 $6,602 $12,577 $6,632 $12,638 $5,406 $12,680 $5,468 $12,779 $4,170 $12,815 $3,753 $12,792 $3,209 $12,836 $3,250 $12,844 1,000 to 2,000 $1,858 $12,513 $3,043 $12,472 $4,953 $12,197 $4,740 $12,217 $5,961 $12,074 $5,690 $12,141 $3,688 $12,307 $3,593 $12,389 $1,828 $12,557 $1,657 $12,596 $1,092 $12,670 $1,040 $12,660 2,000 to 3,000 $2,350 $12,212 $4,567 $11,974 $7,343 $11,391 $7,442 $11,445 $8,756 $11,107 $8,751 $11,213 $5,520 $11,707 $4,807 $11,801 $2,279 $12,259 $1,776 $12,327 $1,142 $12,493 $1,326 $12,492 3,000 to 4,000 $2,486 $11,830 $5,620 $11,228 $9,172 $10,197 $9,519 $10,233 $10,614 $9,687 $9,502 $9,785 $6,439 $10,810 $5,166 $11,014 $3,143 $11,887 $1,958 $12,038 $1,409 $12,307 $1,351 $12,277 4,000 to 5,000 $2,978 $11,427 $5,633 $10,308 $9,088 $8,705 $9,976 $8,682 $9,871 $7,965 $8,923 $8,235 $6,268 $9,763 $5,430 $10,168 $3,231 $11,375 $2,026 $11,719 $1,297 $12,078 $1,494 $12,057 5,000 to 6,000 $2,984 $10,944 $5,633 $9,387 $7,813 $7,227 $9,108 $7,057 $8,365 $6,363 $6,912 $6,780 $5,780 $8,744 $5,210 $9,279 $3,463 $10,848 $2,108 $11,390 $1,390 $11,868 $1,407 $11,815 6,000 to 7,000 $3,321 $10,459 $5,078 $8,466 $6,087 $5,956 $7,262 $5,573 $5,923 $5,006 $5,448 $5,652 $5,469 $7,804 $4,272 $8,426 $3,469 $10,283 $2,101 $11,047 $1,347 $11,642 $1,731 $11,587 7,000 to 8,000 $3,016 $9,920 $4,522 $7,635 $4,979 $4,966 $5,589 $4,390 $4,647 $4,045 $4,436 $4,763 $4,512 $6,914 $3,461 $7,726 $3,344 $9,717 $2,377 $10,705 $1,341 $11,423 $1,681 $11,306 8,000 to 9,000 $2,867 $9,431 $4,290 $6,896 $3,633 $4,156 $4,065 $3,480 $3,372 $3,291 $3,564 $4,040 $4,157 $6,181 $3,649 $7,159 $3,338 $9,172 $2,627 $10,319 $1,583 $11,206 $2,042 $11,033 9,000 to 14,000 $15,677 $39,763 $16,086 $25,219 $11,465 $13,411 $10,407 $9,859 $9,512 $9,918 $10,852 $13,046 $14,418 $22,264 $14,327 $27,825 $16,725 $37,492 $14,604 $44,815 $10,267 $51,639 $12,618 $49,586 14,000 to 17,000 $8,758 $17,856 $6,234 $9,554 $3,027 $4,563 $2,110 $2,998 $2,250 $3,186 $3,093 $4,518 $5,425 $8,571 $6,443 $11,515 $8,297 $16,270 $8,631 $21,127 $7,076 $26,793 $8,821 $24,592 17,000 to 20,000 $7,431 $1,484 $4,186 $818 $1,829 $364 $1,158 $231 $1,231 $247 $1,928 $377 $3,739 $731 $4,990 $983 $6,644 $1,332 $7,824 $1,620 $7,610 $1,723 $8,466 $1,795 20,000 to 25,000 $8,201 $1,660 $4,147 $832 $1,887 $385 $1,100 $231 $1,384 $278 $1,973 $393 $3,967 $783 $5,122 $1,033 $7,596 $1,530 $10,019 $2,054 $11,676 $2,532 $11,566 $2,398 25,000 to 29,000 $4,240 $868 $1,996 $410 $915 $193 $495 $112 $513 $115 $872 $182 $1,933 $387 $2,762 $555 $4,139 $830 $5,285 $1,095 $7,207 $1,549 $6,319 $1,320 29,000 to 34,000 $3,625 $745 $1,337 $296 $657 $150 $392 $96 $404 $97 $566 $130 $1,356 $284 $2,120 $436 $3,037 $630 $4,659 $964 $6,698 $1,436 $5,640 $1,179 34,000 to 39,000 $2,065 $444 $904 $207 $348 $91 $238 $66 $256 $68 $280 $77 $716 $162 $1,290 $273 $1,822 $393 $2,921 $618 $4,693 $1,012 $3,598 $768 39,000 to 44,000 $1,301 $291 $581 $143 $180 $60 $206 $56 $179 $52 $210 $62 $361 $96 $635 $150 $1,183 $263 $1,945 $419 $3,184 $702 $2,428 $527 44,000 to 50,000 $932 $225 $394 $111 $180 $62 $154 $49 $115 $43 $172 $56 $273 $83 $484 $124 $802 $194 $1,263 $295 $2,582 $580 $1,793 $408 50,000 to 59,000 $615 $186 $323 $112 $193 $74 $135 $53 $154 $57 $216 $72 $292 $97 $428 $123 $720 $189 $1,013 $264 $2,160 $516 $1,338 $343 59,000 to 69,000 $401 $144 $291 $102 $180 $71 $148 $54 $122 $51 $146 $58 $215 $79 $220 $85 $332 $118 $600 $181 $1,279 $335 $822 $237 69,000 ++$1,994 $1,504 $1,395 $965 $1,056 $716 $753 $572 $795 $548 $891 $642 $1,160 $1,034 $1,252 $1,029 $1,603 $1,317 $2,051 $1,667 $2,992 $2,170 $2,540 $2,065 REVENUE:$80,885 $166,652 $80,920 $129,930 $80,955 $97,605 $80,990 $90,097 $81,025 $86,776 $81,060 $94,861 $81,095 $121,481 $81,130 $134,873 $81,165 $161,470 $81,200 $180,052 $81,235 $199,511 $81,270 $193,287 PROJECTED ANNUAL REVENUE GENERATED FROM PROPOSED RATES =$0 AMOUNT FROM BASE:$972,930 AMOUNT FROM USAGE:$1,656,594 TOTAL:$2,629,524 TROPHY CLUB COUNTRY CLUB EFFLUENT REVENUE Month Mil Gals Charges Jul-15 21.783 $15,248 Aug-15 26.994 $18,896 Sep-15 20.717 $14,502 Oct-15 8.506 $5,954 Nov-15 0.005 $4 Dec-15 0.009 $6 Jan-16 0.070 $49 Feb-16 0.821 $575 Mar-16 1.16 $812 Apr-16 6.209 $4,346 May-16 0 $0 Jun-16 6.856 $796 TOTAL:93.06 $61,188 Usage Groups SCHEDULE GF-E PROJECTED RETAIL WASTEWATER SALES FY 15 WATER USE CATEGORY PROJECTED FY 2015 RETAIL WASTEWATER REVENUES Trophy Club Municipal Utility District No. 1 21 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE GF-F UNIFORMS WATER ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 6 10 60 $14 $810 POLO SHIRTS 6 4 24 $17 $408 SWEATSHIRTS 6 5 30 $18 $540 PANTS 6 7 42 $25 $1,050 BOOTS 6 1 6 $175 $1,050 JACKET 5 1 5 $150 $750 TOTAL:$4,608 WASTEWATER ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 7 6 42 $18 $756 POLO SHIRTS 7 0 0 $35 $0 SWEATSHIRTS 7 2 14 $27 $378 PANTS 7 5 35 $30 $1,050 BOOTS 7 1 7 $175 $1,225 JACKET 2 1 7 $150 $1,050 TOTAL:$4,459 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 Trophy Club Municipal Utility District No. 1 22 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T 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 Classes 6 $325 $1,950 $50 $300 CSI Class 2 $230 $460 $50 $100 CSI Renewals 0 $111 $0 $50 $0 Management Classes 1 $350 $350 $100 $0 Management Conferences 2 $350 $700 $400 $400 License Renewal 2 $111 $222 $100 $400 CDL Renewal 0 $75 $0 $0 $0 Miscellaneous Mileage/Travel (Miles)1,000 $0.54 $540 $0 $300 $4,222 $1,500 $5,722 WASTEWATER Wastewater 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 2 $75 $150 $0 $0 Miscellaneous Mileage/Travel (Miles)1,000 $0.54 $540 $0 $300 $4,195 $1,600 $5,795 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 3 $300 $900 $100 $300 Govmt Accounting Conference 2 $350 $700 $400 $800 Software Training 3 $300 $900 $50 $150 AWWA Customer Service Workshop 1 $150 $150 $650 $650 CGFO Application and Testing 1 $500 $500 $100 $100 Customer Service Conferences 1 $350 $350 $200 $200 CPA/CFE Classes/Renewal 1 $900 $900 $0 $0 Miscellaneous Mileage/Travel (Miles)1,000 $0.54 $540 $0 $300 Miscellaneous Travel (Legal)3 $500 $1,500 $0 $0 $9,240 $5,500 $14,740 Trophy Club Municipal Utility District No. 1 23 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE GF-H SALARY WITHOUT FIRE STIPEND WORKSHEET 50% Town Total Social TWC WORKERS Base Pay Base Pay COLA Merit Stipend Salaries OT Holiday Longevity Certification Security Medi UNEMP COMP FIRE DEPARTMENT %No Split With Split Pay Pay ($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%1.9% TO $4500 (9/year) ** Fire Chief 50.00%120,016 60,008 0 60,008 0 0 0 0 0 0 3,720 870 86 1,116 Fire Captain 50.00%73,337 36,669 0 36,669 3,403 0 484 484 600 600 2,552 597 86 682 Fire Captain 50.00%82,349 41,175 0 41,175 3,831 0 919 919 450 450 2,875 672 86 766 Fire Captain 50.00%79,290 39,645 0 39,645 3,680 0 608 608 600 600 2,761 646 86 738 Fire Fighter/EMT-P 50.00%54,651 27,326 0 27,326 2,550 0 413 413 450 450 1,906 446 86 508 Fire Fighter/EMT-P 50.00%54,155 27,078 0 27,078 2,480 0 326 326 0 0 1,853 433 86 504 Engineer - Fire Fighter/EMT-P 50.00%67,715 33,857 0 33,857 3,153 0 638 638 450 450 2,362 552 86 630 Engineer - Fire Fighter/EMT-P 50.00%66,392 33,196 0 33,196 3,080 0 480 480 450 450 2,307 539 86 618 Engineer - Fire Fighter/EMT-P 50.00%66,723 33,361 0 33,361 3,111 0 518 518 600 600 2,331 545 86 621 Fire Fighter/EMT-P 50.00%61,211 30,605 0 30,605 2,852 0 518 518 450 450 2,134 499 86 569 Fire Fighter/EMT-P 50.00%57,821 28,910 0 28,910 2,693 0 435 435 450 450 2,014 471 86 538 Fire Fighter/EMT-P 50.00%50,462 25,231 0 25,231 2,290 0 45 45 0 0 1,709 400 86 469 Fire Fighter/EMT-P 50.00%56,085 28,042 0 28,042 2,598 0 236 236 450 450 1,942 454 86 522 Fire Fighter/EMT-P 50.00%52,529 26,265 0 26,265 2,378 0 0 0 0 0 1,776 415 86 489 Fire Fighter/EMT-P 50.00%51,537 25,769 0 25,769 2,374 0 0 0 450 450 1,773 415 86 479 Fire Fighter/EMT-P 50.00%50,077 25,038 0 25,038 2,268 0 0 0 0 0 1,693 396 86 466 Part-Time Staff 50.00%27,284 13,642 0 0 0 13,642 0 0 0 0 0 0 846 198 43 50.00%0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Aggregate OT 50.00%30,812 15,406 0 0 0 15,406 7,498 0 0 0 0 0 1,420 332 56 254 TOTAL:1,071,635 551,224 0 0 551,224 50,237 0 5,618 5,400 37,974 8,881 1467 9,969 * Merit up to 2% 10/1/16 and up to 2% 4/01/17; amount included in base Total w/OT: ** Holiday pay is now included in base pay and no longer budgeted separately COLA Merit Merit Total Social TWC UNEMP WORKERS Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare 1.90%COMP ADMINISTRATION %Base Pay Base Pay 2.0%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%UP TO $9000 General Manager 100%118,481 118,481 2,370 0 1,500 122,350 0 0 270 270 0 0 7,619 1,888 171 223 District Secretary 100%77,975 77,975 1,560 0 1,100 80,635 0 0 540 540 0 0 5,066 1,250 171 223 Administration Manager 100%85,663 85,663 1,713 0 1,100 88,476 0 0 240 240 0 0 5,515 1,366 171 223 Finance Manager 100%90,009 90,009 1,800 0 1,100 92,909 0 0 2,000 2,000 0 0 6,008 1,463 171 223 Utility Billing Clerk 100%45,808 45,808 916 0 1,040 47,764 0 0 758 758 0 0 3,055 748 171 223 Reception/Utility Billing Clerk 100%29,268 29,268 585 0 1,040 30,893 0 0 120 120 0 0 1,930 478 171 223 Communications Specialist 100%50,003 50,003 0 0 1,040 51,043 0 0 473 473 0 0 3,223 794 171 223 Administrative Assistant 100%32,000 32,000 0 0 1,040 33,040 0 0 0 0 0 0 2,048 509 171 223 Overtime Pay 1,000 62 15 DM Discretionary 1,000 62 15 TOTAL:529,206 529,206 8,944 0 8,960 548,110 1,000 0 4,400 0 34,590 8,527 1,368 1,784 Included in base * Included in base * Included in base * 601,460 Included in base * Included in base * Included in base * Included in base * Included in base * Included in base * Included in base * Included in base * Included in base * Included in base * Included in base * Included in base * Included in base * Trophy Club Municipal Utility District No. 1 24 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE GF-H SALARY WORKSHEET COLA Merit Merit Total Social TWC UNEMP WORKERS Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare 1.90%COMP WATER & DISTRIBUTION %Base Pay Base Pay 2.0%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%UP TO $9000 Water Superintendent 100%74,275 74,275 1,486 0 1,500 77,261 0 0 1643 1643 0 0 4,994 1,168 171 2,192 Crew Leader 100%49,856 49,856 997 0 1,040 51,893 0 0 1343 1343 1500 1500 3,570 835 171 2,192 Utility Field Worker 100%38,771 38,771 775 0 1,040 40,587 0 0 200 200 900 900 2,653 620 171 2,192 Utility Field Worker 100%40,000 40,000 0 0 1,040 41,040 0 0 0 0 900 900 2,656 621 171 2,192 Utility Field Worker 100%28,080 28,080 562 0 1,040 29,682 0 0 85 85 900 900 1,962 459 171 2,192 Utility Field Worker 100%28,080 28,080 562 0 1,040 29,682 0 0 0 0 600 600 1,915 448 171 2,192 Overtime Pay 19,500 1,209 283 DM Discretionary 1,000 62 15 TOTAL:259,062 259,062 4,381 0 6,700 271,143 19,500 0 3,270 4,800 19,021 4,448 1,026 13,152 COLA Merit Merit Total Social TWC UNEMP WORKERS Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare 1.90%COMP WASTEWATER & COLLECTIONS %Base Pay Base Pay 2.0%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%UP TO $9000 Wastewater Superintendent 100%72,300 72,300 1,446.00 0 1,400 75,146 0 0 260 260 - - 4,691 1,097 171 1,621 Wastewater Shift Supervisor 100%56,002 56,002 1,120.04 0 1,040 58,162 0 0 0 0 900 600 3,699 865 171 1,621 Crew Leader 100%57,490 57,490 1,149.80 0 1,040 59,680 0 0 1673 1,673 1,800 1,800 4,131 966 171 1,621 Utility Field Worker 100%51,375 51,375 1,027.51 0 1,040 53,443 0 0 1283 1,283 1,800 1,800 3,696 864 171 1,621 Utility Field Worker 100%41,663 41,663 833.25 0 1,040 43,536 0 0 773 773 1,200 1,200 2,944 688 171 1,621 Crew Leader 100%55,751 55,751 1,115.03 0 1,040 57,906 0 0 1,755 1,755 1,200 1,200 3,957 925 171 1,621 Utility Field Worker 100%40,381 40,381 807.62 0 1,040 42,229 0 0 893 893 1,200 1,200 2,878 673 171 1,621 Overtime Pay 29,500 - 0 0 - - 1,829 428 DM Discretionary 1,000 - - 0 0 - - 62 15 TOTAL:374,963 374,963 7,499 0 7,640 391,102 29,500 0 6,635 7,800 27,886 6,522 1,197 11,347 Trophy Club Municipal Utility District No. 1 25 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T 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 $166 $498 No coverage 0 $0 $0 Employee & Spouse 2 $233 $465 Employee Only 2 $481 $962 Employee & Children 1 $267 $267 Employee & Spouse 2 $661 $1,321 Family 10 $357 $3,566 Employee & Children 1 $753 $753 Family 3 $981 $2,944 TOTAL 16 $4,797 TOTAL 8 $5,981 NO. EMPLOYEES ANNUAL RATE (TCMUD Share @ 50%) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED Employee Only 6 $23 $135 No coverage 0 $0 $0 Employee and Family 10 $34 $343 Employee Only 2 $119 $239 Employee & Spouse 2 $161 $323 Employee & Children 1 $156 $156 Family 3 $198 $594 TOTAL 16 $479 TOTAL 8 $1,312 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,686 $13,428 No coverage 0 $ - $0 Employee & Spouse 3 $4,747 $14,242 Employee Only 3 8,345$ $25,036 Employee & Children 2 $3,928 $7,857 Employee & Spouse 2 11,266$ $22,533 Family 6 $5,481 $32,887 Employee & Children 2 11,266$ $22,533 Family 1 14,187$ $14,187 TOTAL 16 $68,414 TOTAL 8 $84,289 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL $3,684 TOTAL $5,890 DENTAL DENTAL MEDICAL MEDICAL LIFE & OTHER LIFE & OTHER VISION VISION Trophy Club Municipal Utility District No. 1 26 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T 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 3 $481 $1,443 Employee Only 3 $481 $1,443 Employee & Spouse 0 $661 $0 Employee & Spouse 1 $661 $661 Employee & Children 1 $753 $753 Employee & Children 2 $753 $1,507 Family 2 $981 $1,963 Family 1 $981 $981 TOTAL 6 $4,159 TOTAL 7 $4,592 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 3 $119 $358 Employee Only 3 $119 $358 Employee & Spouse 0 $161 $0 Employee & Spouse 1 $161 $161 Employee & Children 1 $156 $156 Employee & Children 2 $156 $313 Family 2 $198 $396 Family 1 $198 $198 TOTAL 6 $910 TOTAL 7 $1,030 NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEES ANNUAL RATE (TCMUD Share) DISTRICT ANNUAL COST PROJECTED No coverage 0 $ - $0 No coverage 0 $ - $0 Employee Only 5 8,345$ $41,727 Employee Only 3 8,345$ $25,036 Employee & Spouse 0 11,266$ $0 Employee & Spouse 1 11,266$ $11,266 Employee & Children 0 11,266$ $0 Employee & Children 2 11,266$ $22,533 Family 1 14,187$ $14,187 Family 1 14,187$ $14,187 TOTAL 6 $55,914 TOTAL 7 $73,022 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL $2,803 TOTAL $4,485 VISION FOR ALL DEPARTMENTS ( EXCEPT FIRE) A 10% INCREASE IN EMPLOYEE BENEFITS WAS BUDGETED LIFE & OTHER DENTAL VISION MEDICALMEDICAL LIFE & OTHER DENTAL Trophy Club Municipal Utility District No. 1 27 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE GF-J RETIREMENT WORKSHEET FIRE DEPARTMENT Oct-Dec Jan-Sept TMRS TMRS TMRS TOTAL FY 2017 SALARY 12.75%13.26%FY 17 Total WATER Oct-Dec Jan-Sept Fire Chief 60,008 1913 5968 7881 TCDRS TCDRS TCDRS Fire Lieutenant 41,156 1312 4093 5405 TOTAL FY 2017 SALARY 8.73%9.25%FY 17 Total Fire Lieutenant 46,374 1478 4612 6090 Water Superintendent 78,903 1722 5474 7196 Fire Lieutenant 44,533 1419 4429 5848 Crew Leader 54,735 1195 3797 4992 Fire Fighter/EMT-P 30,738 980 3057 4037 Utility Field Worker 41,687 910 2892 3802 Fire Fighter/EMT-P 29,883 953 2972 3924 Utility Field Worker 41,940 915 2910 3825 Engineer - Fire Fighter/EMT-P 38,098 1214 3789 5003 Utility Field Worker 30,667 669 2127 2797 Engineer - Fire Fighter/EMT-P 37,206 1186 3700 4886 Utility Field Worker 30,282 661 2101 2762 Engineer - Fire Fighter/EMT-P 37,590 1198 3738 4936 Overtime Pay 19,500 426 1353 1778 Fire Fighter/EMT-P 34,425 1097 3424 4521 TOTAL:297,713 6,498 20,654 27,151 Fire Fighter/EMT-P 32,488 1036 3231 4267 Fire Fighter/EMT-P 27,566 879 2741 3620 Fire Fighter/EMT-P 31,326 999 3115 4114 Fire Fighter/EMT-P 28,643 913 2848 3761 Fire Fighter/EMT-P 28,592 911 2844 3755 WASTEWATER Oct-Dec Jan-Sept Fire Fighter/EMT-P 27,307 870 2716 3586 TCDRS TCDRS TCDRS Part-Time Staff 13,642 435 1357 1792 TOTAL FY 2017 SALARY 8.73%9.25%FY 17 Total 0 0 0 0 Wastewater Superintendent 75,406 1,646 5231 6877 Overtime Pay (Total)22,904 730 2278 3008 Wastewater Shift Supervisor 58,762 1,282 4077 5359 TOTAL:612,478 19,523 60,911 80,434 Crew Leader 63,152 1,378 4381 5759 Utility Field Worker 56,525 1,234 3921 5155 Utility Field Worker 45,508 993 3157 4150 Crew Leader 60,861 1,328 4222 5551 Utility Field Worker 44,321 967 3075 4042 ADMINISTRATION Oct-Dec Jan-Sept Overtime Pay 29,500 644 2047 2690 TCDRS TCDRS TCDRS TOTAL:434,037 9,473 30,111 39,584 TOTAL FY 2017 SALARY 8.73%9.25%FY 17 Total General Manager 122,620 2,676 8,507 11,183 District Secretary 81,175 1,772 5,631 7,403 Administration Manager 88,716 1,936 6,155 8,091 Finance Manager 94,909 2,071 6,584 8,656 Utility Billing Clerk 48,521 1,059 3,366 4,425 Reception/Utility Billing Clerk 31,013 677 2,152 2,828 Communications Specialist 51,516 1,124 3,574 4,698 Vacant 33,040 721 2,292 3,013 Overtime Pay 1,000 22 69 91 TOTAL:552,510 12,059 38,330 50,389 Trophy Club Municipal Utility District No. 1 28 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE GF-K Electricity & Gas Analysis for FY 2016-2017 Hudson Energy FY 2017 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 5% INCREASE 2836193 135-60020-010 Water Well #1, Well #3 54,480 $4,333 74,640 $5,402 151,625 $12,073 75,120 $5,463 59250 $4,586 33840 $3,149 28800 $2,901 23520 $2,563 25,920 $2,698 39,120 $3,405 38400 $3,310 51120 $4,029 655,835 53,912 0.082203359 $56,607 2770721 135-60020-010 Elevated Tank-TW King 409 $44 88 $17 312 $45 101 $18 134 $21 164 $23 505 $51 1603 $143 908 $86 612 $61 586 $58 616 $61 6,038 629 0.104092415 $660 2828381 135-60020-010 Paluxy Well #4 12,880 $895 12,320 $864 20,591 $1,646 12,240 $863 13120 $909 12720 $884 13600 $930 12720 $882 12,320 $864 13,600 $929 12320 $854 12800 $883 161,231 11,404 0.070728582 $11,974 2829590 135-60020-010 Paluxy Well #2 15,458 $1,078 14,688 $1,027 24,128 $1,921 14,436 $1,026 15519 $1,082 15769 $1,077 16416 $1,118 4724 $498 13,654 $995 16,457 $1,118 14898 $1,047 15465 $1,061 181,612 13,050 0.071854668 $13,702 2836131 135-60020-010 Water Plant/Water Barn 1,839 $212 2,258 $248 2,988 $1,679 1,721 $220 1316 $188 2614 $395 4329 $496 4781 $548 1,845 $330 1,519 $282 1178 $196 1592 $176 27,980 4,969 0.177593638 $5,218 2836162 135-60020-010 Water plant pump station 68,000 $6,511 91,000 $8,853 40,907 $8,080 84,400 $8,591 65000 $7,491 38000 $3,939 36800 $3,716 31600 $5,025 35,800 $3,340 44,000 $4,751 39000 $3,877 39000 $3,704 613,507 67,879 0.110641264 $71,273 8644641 135-60020-010 100 Municipal Dr, Unit B 300 $57 400 $1,504 78953 $7,784 300 $57 300 $57 300 $57 400 $1,613 300 $56 300 $58 300 $58 300 $58 300 $58 82,453 11,417 0.138463124 $11,988 9130039 135-60020-010 2901 Bobcat Unit A, Elev Tank 1222 $113 1368 $125 1314 $97 1441 $131 677 $198 525 $54 677 $66 1034 $96 977 $92 1004 $95 1011 $95 986 $92 12,236 1,253 0.102372507 $1,315 TOTAL: $172,737 2828536 135-60020-020 Sewer Plant 135,658 $9,482 135,658 $9,482 211,950 $16,910 131031 $9,243 139848 $9,839 136492 $9,646 137461 $9,545 123943 $8,717 119,821 $8,793 124,052 $8,827 110901 $8,312 128970 $17,856 1,635,785 126,652 0.077425585 $132,984 8611313 135-60020-020 Maintenance Barn 449 $108 399 $104 336 $102 419 $203 723 $173 4849 $173 7612 $685 7247 $610 5,027 $488 4,779 $444 3793 $454 1001 $214 36,634 3,756 0.102532893 $3,944 8251800 135-60020-020 310 Skyline-Lift Sta #6 700 $151 700 $322 900 $188 600 $123 700 $129 600 $115 700 $112 800 $181 600 $127 600 $113 500 $84 600 $90 8,000 1,734 0.216797500 $1,821 5437067 135-60020-020 Lift Sta #2 Guard Light 70 $12 70 $25 70 $12 70 $12 70 $12 70 $12 70 $12 70 $12 70 $12 70 $12 70 $12 70 $12 840 161 0.191511905 $169 2820941 135-60020-020 Lift Station Trophy 20 285 $34 200 $61 209 $27 191 $26 260 $31 333 $37 300 $34 262 $31 221 $29 286 $33 258 $31 288 $34 3,093 408 0.131943097 $429 6245046 135-60020-020 Lift Station #2 1,310 $268 1,030 $430 1,042 $156 966 $152 1177 $182 1346 $240 1461 $244 1253 $232 1,216 $265 1,341 $214 1201 $269 1297 $182 14,640 2,834 0.193590164 $2,976 9215255 135-60020-020 Lift Station #1 900 $131 700 $203 800 $77 800 $77 900 $85 1100 $102 1200 $109 900 $84 900 $88 1100 $102 900 $84 1100 $102 11,300 1,245 0.110199115 $1,308 9843774 135-60020-020 Lift Station #7 232 $29 220 $28 211 $27 198 $26 219 $28 270 $32 270 $32 759 $73 738 $74 543 $55 591 $59 601 $60 4,852 522 0.107673124 $549 8306586 135-60020-020 PID Lift Station #8 569 $58 569 $57 572 $58 552 $56 575 $58 687 $67 636 $62 667 $65 646 $64 679 $67 680 $67 641 $63 7,473 742 0.099344306 $780 0051720 135-60020-020 PID Lift Station #9 300 $38 400 $47 300 $38 300 $38 300 $38 400 $47 500 $55 400 $46 500 $56 500 $56 500 $6 600 $64 5,000 527 0.105438000 $554 0199280 135-60020-020 Lift Station #4 (new)950 $97 800 $83 1195 $156 750 $79 950 $97 1000 $101 1100 $109 950 $96 850 $88 1000 $102 950 $97 1000 $102 11,495 1,207 0.105043062 $1,268 TOTAL:$146,780 8797254 122-60020-045 Fire Station 7576 $572 7838 $586 10966 $932 5788 $459 5044 $416 4519 $370 4821 $387 4367 $357 4,024 $341 4579 $373 4699 $382 5730 $447 69,950 5,620 0.080344406 $5,901 MUD SHARE ONLY MUD SHARE ONLY TOTAL:$5,901 Direct Energy (Split with Town) MUD 1/2 usage 2836100 135-60020-030 MUD & PW Bldgs 11,040 $906 12,090 $968 11,490 $943 9,330 $1,630 8,130 $746 10,740 $914 13,170 $1,236 13,080 $1,242 9,000 $893 8,340 $950 7,440 $788 8,527 $813 122,377 12,030 0.098301029 $12,631 TOTAL:$12,631 Tri-County Meter # 165775 135-60020-020 Lift Station 3 3618 $341 3649 $325 5070 $416 3745 $323 3466 $301 4015 $345 3206 $281 2907 $257 3509 $305 3736 $342 3595 $321 5259 $458 45,775 4,014 0.087698744 $4,215 170037 135-60020-020 Lift Station 5 1696 $174 1791 $173 2199 $195 1672 $157 1895 $177 2217 $202 1856 $174 1713 $162 1895 $177 2005 $196 1961 $187 3245 $293 24,145 2,265 0.093811141 $2,378 170038 135-60020-020 Lift Station 5 (Backup)23 $28 24 $28 26 $28 24 $28 24 $28 29 $28 24 $28 24 $28 26 $28 24 $28 24 $28 27 $28 299 334 1.115484950 $350 TOTAL:$6,944 MP2 Energy - Electricity for Construction Trailer at WWTP Meter # 134143877LG 135-60020-020 WWTP 1593 $1,035 4219 $291 4547 $324 2470 $267 2347 $313 1799 $270 1942 $224 18,917 2,724 0.144005921 $2,860 Dec 15 Includes $712 in temporary facilities charges.TOTAL:$4,903 Atmos - Gas @ Fire Station (Measures by Thousand Cubic Feet) MUD 1/2 usage Meter S/N 11N375438 122-60020-045 Fire Station 25 $35 18.5 $32 20 $33 25 $36 22.5 $35 136 $102 267 $156 211 $121 48.5 $45 52.5 $45 18.5 $30 43 $65 888 735 0.828090141 $772 TOTAL:$772 Jun-16 Jul-15 Aug-15 Sept-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Trophy Club Municipal Utility District No. 1 29 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T SCHEDULE GF-L INFORMATION TECHNOLOGY Account Description Amount 135-55160-030 Description Professional Outside Services M3- It & Cell Phone Support $51,075 Totals:51,075$ 135-55030-030 Description Software & Support Used R For Recurring, NR For Non-Recurring. R-Internet Connectivity-WSC 14,400$ R-Internet Connectivity-ATT (Backup & WWTP)3,816$ R-Internet Connectivity-Pump Room at Water Plant/SCADA 1,040$ R-E-Fax 132$ R-STW-Annual Support 29,000$ R-Clear Rec Annual Maintenance 600$ R-Web Hosting -$ R-Web Maintenance (Domains, SSL Cert, etc)116$ R-Mail Chimp 240$ R-Photoshop 120$ R- Timeclock Plus Support 2,460$ Replacement for Connect CTY 6,000$ R-Annual Support for Website-Four Man Furnace 2,000$ R-Automatic Meter Reading -Badger 2,500$ R-Pipelogix Maintenance 1,980$ R-AudioTel Remit Plus Annual Support 1,802$ R-AudioTel Annual Scanner Support 585$ R-SCADA Support (Includes Win-911)1,000$ Totals:67,791$ 135-60005-030 Description Telephone Main Phone Numbers & Long Distance 50% Shared 6,000$ WWTP Phone Service 5,784$ Phone System Maintenance, 50% Shared.2,248$ Repairs (Non-Maintenance), 50% Shared.1,000$ Totals:15,032$ 135-60235-030 Description Security R-Access Control System, 50% Shared 1350 Totals:1,350$ Trophy Club Municipal Utility District No. 1 30 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T 122-55030-045 Description Amount Software & Support - Fire Dept.R-Firehouse Support and Maintenance 1,570$ 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-Anti-Virus Maintenance and Support, 50% shared.38$ R-Malware-Bytes Maintenance and Support, 50% shared.48$ R-Hosted Exchange, 50% shared 510$ R-Web Hosting, 50% shared 60$ R-OSSI Support and Maintenance ( 3 units)228$ Totals:8,206$ 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 Totals:750$ 135-65055-030 Description Amount Hardware R-A/V Miscellaneous Equipment, 50% Shared.1,200$ Replacement Hardware- See List below *8,244$ Totals:9,444$ 122-65105-045 Description Printing 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$ Trophy Club Municipal Utility District No. 1 31 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T 135-65090-030 Printer Supplies Description Toner and Cartridges 2,000$ Totals:2,000$ 135-69170-030 Copier Rental/Lease Description Amount Copier Lease 4,600$ Totals:4,600$ 122-60010-045 Description Amount Communications /Mobiles Cell Phones/Data cards (50% Shared)3,247$ Active 911 240$ Denton County Dispatcher 5,444$ Totals:8,931$ *Latitude Laptop 1,869.00$ 2 3,738.00$ Dell Docking station for Latitude 179.00$ 2 358.00$ Dell 22 inch Monitor 219.00$ 6 1,314.00$ Dell Monitor Stand 189.00$ 0 -$ Dell OptiPlex Desktop 1,259.00$ 2 2,518.00$ Keyboard/Mouse Combo 79.00$ 4 316.00$ 8,244.00$ Trophy Club Municipal Utility District No. 1 32 of 33 August 12, 2016 Budget Workshop Agenda Packet DRAF T 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. 7 4 28 $50 $1,400 MISC Gas 100.00 $250.00 $2.50 MISC Diesel 300.00 $900.00 $3.00 D-2001 Ford F650 Unit#10 300.00 $900.00 $3.00 G-2007 Dodge Unit#103 1,500.00 $3,750.00 $2.50 G-2016 Dodge 1500 Unit#109 850.00 $2,125.00 $2.50 G-2011 Ford F150 Unit#101 1,800.00 $4,500.00 $2.50 G-2012 Ford F250 Unit #102 850.00 $2,125.00 $2.50 D-2015 Ford F350 Unit#107 1,300.00 $3,900.00 $3.00 G-2015 Ford Escape Unit#521 450.00 $1,125.00 $2.50 D-Portable Generators Unit# 8 & #9 100.00 $300.00 $3.00 D-Caterpillar Generator Unit #49 750.00 $2,250.00 $3.00 D-350 kw Generator Unit#55 1,200.00 $3,600.00 $3.00 Total Fuel and Lube:$33,011 TOTAL 9500.00 $25,725.00 $2.75 10450.00 $31,611 $3.03 10% Increase Wastewater Department MISC Gas 150.00 $375.00 $2.50 MISC Diesel 400.00 $1,200.00 $3.00 G-2013 Chevy C1500 Unit#200 1,500.00 $3,750.00 $2.50 G-2013 Chevy C1500 Unit#201 1,650.00 $4,125.00 $2.50 D-2009 Gap Vax Unit #303 800.00 $2,400.00 $3.00 No. Vehicles No./Year Total/Year Cost Each Total Amt. G-2001 GMC Camera Van Unit#302 200.00 $500.00 $2.50 OIL CHANGES 4 4 16 $50 $800 D-2015 Chevy 3500 Unit#203 1,200.00 $3,600.00 $3.00 OIL- GAP VAX 1 1 1 $1,200 $1,200 D-58 kW Portable Generator Unit# PID 300.00 $900.00 $3.00 D-41 kw Generator @ Lift Station #54 500.00 $1,500.00 $3.00 D-600 kw Generator Unit#41 1,000.00 $3,000.00 $3.00 Total Fuel and Lube:$28,088 TOTAL 7700.00 $21,350.00 $2.80 8470.00 $26,088 $3.08 10% Increase Fire Department MISC Gas 15.00 $37.50 $2.50 No. Vehicles No./Year Total/Year Cost Each Total Amt. G-Vehicle U681-2011 Ford 150 350.00 $875.00 $2.50 OIL CHANGES-Gas 1 6 6 $60 $360 D-Vehicle T681-2015 Ladder Truck 800.00 $2,400.00 $3.00 OIL CHANGES-Diesel 0 4 1 $120 $120 D-Veh BRUS B681- 2011 Ford Brush 225.00 $675.00 $3.00 Fire Engine 1 1 1 $3,400 $3,400 D-Vehicle ENG E681- 2007 Fire Engine 1,200.00 $3,600.00 $3.00 Ladder Truck 1 1 1 $5,000 $5,000 D-160 kW Generator-Unit#52 600.00 $1,800.00 $3.00 Brush Truck 1 1 1 $1,295 $1,295 TOTAL 3190.00 $9,387.50 $2.83 3509.00 $10,936 $3.12 10% Increase Total Fuel and Lube:$21,111 Trophy Club Municipal Utility District No. 1 33 of 33 August 12, 2016 Budget Workshop Agenda Packet