Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-0731 July 31, 2018Special Meeting Minutes - Budget Workshop
July 31, 2018 Special Meeting Budget Workshop Minutes SPECIAL MEETING BUDGET WORKSHOP MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS July 31, 2018 at 6:30 P.M. 100 Municipal Drive, Trophy Club, Texas 76262 Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a Special Meeting Budget Workshop on July 31, 2018 at 6:30 P.M., in the Svore Municipal Boardroom of the Districts Administration Building located at 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Gregory Wilson President William C. Rose Vice President Steve Flynn Secretary/Treasurer Kelly Castonguay Director Mark Chapman Director STAFF PRESENT: John Carman Laurie Slaght Mike McMahon Steven Krolczyk General Manager District Secretary Water Superintendent Finance Manager CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of Tuesday, July 31, 2018, called the meeting to order and announced a quorum present at 6:36 p.m. CITIZEN COMMENTS There were no Citizen Comments REGULAR SESSION 1. Consider and take appropriate action regarding FY 2019 draft budget. Steven Krolczyk, Finance Manager provided the Board with a Draft budget overview. Staff answered questions related thereto. Discussion only, no action taken. 2. Set future meeting date: August 20, 2018 Regular Meeting. 1 of 2 July 31, 2018 Special Meeting Budget Workshop Minutes Motion made by Director Rose and seconded by Director Castonguay to adjourn the Special Meeting. Motion carried unanimously ADJOURN Director Wilson called the Special Meeting Budget Workshop adjourned 9:19 p.m. e, Gregor f ilson, President Steve Flynn, Secretary/Trgsurer 0 MUll NIC ��pQCrp�aAN7'0°.�i p ((44L) • 01 /4try Dts-C Laurie Slaght, District Secret /ill/11111,111�� 2 of 2 General Fund Revenue FY 2019 Tax Collections FY 2019 PID Surcharges Reserve Funds Total Revenue Water Expense Wastewater Expense Board of Directors Expense Administration Expense Non -Departmental Expense Total Expense 10,187,785 132,384 171,983 0 10,492,152 5,617,629 2,861,306 13,230 1,528,343 184,314 10,204,822 Net Budget Surplus/Deficit 287,330 2019 PROPERTY VALUE SUMMARY MUD Tarrant Co. 433,850,584 MUD Denton Co. 1,228,583,025 PID 745,061,830 Out of District & PID 314,500 Total Value: 2,407,809,939 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY Fire Fund Revenue 75,000 FY 2019 Tax Collections 1,201,853 FY 2019 PID Assessment 538,869 Reserve Funds 0 Total Revenue 1,815,722 Fire Expense 1,815,722 Total Expense 1,815,722 Net Budget Surplus/Deficit 0 TAX RATE SUMMARY BUDGET SUMMARY Tax Debt Service Fund Revenue FY 2019 Tax Collections PID Surcharge 217,979 690,975 120,053 Total Revenue 1,029,008 Debt Service Expense 1,023,208 Total Expense 1,023,208 Net Budget Surplus/Deficlt 5,800 Revenue Debt Service Fund WWTP Revenue Total Revenue 599,738 599,738'. Debt Service Expense Total Expense 598,738 598,738 Net Budget Surplus/Deficit 1,000 Revenue Debt Service Fund SWIFT Revenue 278,684 Total Revenue 278,684 Debt Service Expense 278,084 Total Expense 278,084 Net Budget Surplus/Deficlt 600 1 of 16 2018 2019 0&M (General Fund) Tax 0.00788 0.00766 I & 5 (Debt Service) Tax 0.04363 0.04134 Fire Tax 0.06870 0,07229 Total Tax Rate: 0.12021 0.12129 Increase/Decrease: 0.00108 PID Fire Assessment Rate 0.06870 0.07229 Increase/Decrease: 0.00359 Revenue Debt Service Fund WWTP Revenue Total Revenue 599,738 599,738'. Debt Service Expense Total Expense 598,738 598,738 Net Budget Surplus/Deficit 1,000 Revenue Debt Service Fund SWIFT Revenue 278,684 Total Revenue 278,684 Debt Service Expense 278,084 Total Expense 278,084 Net Budget Surplus/Deficlt 600 1 of 16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY GENERAL FUND Account FY 2015 Description Actual FY 2016 Actual FY 2017 Actual FY 2018 Budget FY 2019 Proposed 970 Total thru 06/30/2018 %of Budget Comments General Fund Revenues Salaries & Wages 221,838 219.077 232.082 274,279 321,604 168,037 135-40000-000000 Property Taxes 167,935 57,250 61,008 120,950 132,384 121,785 100.69% SEE SCHEDULE TAX ASSESS 135-40002-000-000 Property Taxes/Delinquent 464 2,192 290 200 300 345 172.31% 3,310 135-40015-000-000 Property Taxes/P & I 727 746 350 200 300 513 256.49% 1,600 135-40025-000-000 PID Surcharges 30.645 146,125 103,619 177,839 171,983 27,843 0.0074 SEE SCHEDULE TAX ASSESS 135-47000-000-000 Water 3,781,229 4,210,866 5,822,785 6,464,019 6,602638 3,886,089 60.12% SEE SCHEDULE GF -D 135.47005.000,000 Sewer 2,179,235 2,359,115 2.587,176 2,976,365 3,289,061 2,209,522 74.24% SEE SCHEDULE GF -E-2 135.47025.000.000 Penalties 100,639 101,584 121,528 106,279 136,418 80,968 76.18% SEE SCHEDULEGF-D 135.47030.000,000 Service Charges (Disconnect Fees) 10,599 12,850 14,100 21,350 17,000 10,600 49.65% SEE SCHEDULE GF -D 135-47035-000-000 Plumbing Inspections 2,450 2.600 2,400 1,500 1.500 1,800 120.0036 11,156 135.47045.000,000 Sewer Inspections 7,350 7,650 4,800 4,500 4,500 4,600 102.22% 2,609 135-47070-000-000 TCCC Effluent Charges 67,064 45,511 87,159 60,000 60,000 42,121 70.20% GOLF COURSE EFFLUENT 135-48010-000.000 Utility Fees 239,200 55,200 8,975 - - - 0.0036 8.099 135-49010-000-000 Interest Income 6,117 12,652 18,940 12,000 20,000 37,768 314.73% LESS INTEREST INCOME PROJECTED 135-49016-000,000 Cell Tower Revenue 10,926 10,926 10,926 10,926 14,146 8,741 80.0016 51,178.81 PER MONTH 135.49018.000,000 Building Rent Income 7,000 7.000 7,000 7.000 7,000 5,250 75.00% 5583.33 PER MONTH: COLLECTION BARN RENT FROM TOWN 135.49026-000000 Proceeds from Sale of Assets 46,750 30,935 39,899 2,000 10,000 15,400 770.00% CAMAERA VAN PLUS EQUIPMENT 135-49035-000-000 Prior Year Reserves -•- Generator Maintenance & Repairs - - - - 0.00% • 135.49036.000,000 GASB Reserves 74,706 13,088 7,466 - - - 0.00% 4,211 135.49075.006000 Oversize Meter Reimbursement 58.023 51,654 20,864 18,179 .18,522 11,493 63.22% SEE SCHEDULE GF -D 135-49141-000-000 Interfund Transfer In - 8,034 - - - 1,851,769 0.00% TRANSFER OF FUNDS INTO GENERAL FUND 135.49145.000-000 Intergov Transfer In 1,074.337 Communications/Mobiles - 4,717 - - 0.0016 2.863 135.49900.000,000 Miscellaneous Income 98,675 28,818 (27,4481 5,000 7,000 59,001 1180.03% SCRAPSALES;UTILITY BILLING MISCELLANEOUS CHARGES; NSA 135.49901-000-000 Records Management Revenue 18 44 32 20 - - 0.00% REDUCED REVENUE 135-49903-000-000 Recovery of Prior Year Expense - - 81.791 - - • 0.00°.4 - 135.00000.000,000 Reimbursement from 2.42 Revenue Bond -Eng 135-60080-010-000 Schools & Training 1,353 260,000 - • 0.0016 1,537 55.18% Total 7,964,090 7,164,842 8,957,219 10,248,327 10,492,152 8,347,765 81.45% Water General Fund Expenses 135.50005-016000 Salaries & Wages 221,838 219.077 232.082 274,279 321,604 168,037 61.26% SEE SCHEDULE GF -H 135.50010-010-000 Overtime 16,318 13,385 13,069 20,000 20,000 8,068 40.34% SEE SCHEDULE 0F -H 135-50016.010-000 Longevity 2,705 2,945 3,270 3,425 4,693 3,310 96.64% SEE SCHEDULE GF -II 135.50017-010-000 Certification 2,725 2.400 2.600 3,300 4,200 1,600 48.48% SEE SCHEDULE GF -H 135.50020-010-000 Retirement 21,735 20,866 21,489 27,843 33,304 18,154 65.20% SEE SCHEDULE GF -1 135.50026-010-000 Medical Insurance 36,698 38,990 30,038 52,196 58,832 23,953 45.8915 SEE SCHEDULE GF -1 135.50027-010.000 Dental Insurance 2,927 - 2,944 2,942 5,182 4,067 1,948 37.59% SEE SCHEOULEGP-I 135-50028-010-000 Vision Insurance 677 662 578 994 677 352 35.43% SEE SCHEDULE GF -I 135.50029.010.000 Life Insurance & Other 2,975 2,361 2,576 2,982 3,430 1,908 63.99% SEE SCHEDULE GF -I 135.50030-010-000 Social Security Taxes 14,868 14,627 15.286 18,662 21,731 11,156 59.78% SEE SCHEDULE GF -H 135-50035-010-000 Medicare Taxes 3,477 3,421 3,575 4,365 5,082 2,609 59.78% SEE SCHEDULE OF -H 135-50040-010.000 Unemployment Taxes 24 859 51 1,080 1,080 819 75.80% SEE SCHEDULE 0E -H 135.50045-010-000 Workman's Compensation 8,975 12,438 11.864 11.854 12,722 8.099 68.32% TML INVOICE AMOUNT 135.50060.010-000 Pre-emp Physicals/Testing 1.037 236 347 200 200 226 113.03% 135-50070-010-000 Employee Relations 192 112 187 300 300 19 6.3354 135-55005.010000 Engineering 1,710 109,670 25,390 275,000 20,000 - 0.0036 135.55086010.000 Maintenance & Repairs 62,171 84,225 87,258 100,000 100,000 51,009 51.01% ADDITIONAL INFRASTRUCTURE MAINTENANCE 135.55085.010-000 Generator Maintenance & Repairs - - 2.459 3,000 3,000 • 0.00% MAINTENANCE & REPAIRS ON WATER GENERATOR 135.55090.010-000 Vehicle Maintenance 7,466 6,229 2,253 4,000 5,000 4,211 105.28% 135.55105-010600 Maintenance -Heavy Equipment 4,417 2,893 - 3,500 3,500 35 1.00% 135-55135.010-000 Lab Analysts• MUD 4,961 6,389 3,948 5,500 6,500 6,045 109.91% MONTHLY BAC T; QUARTERLY TCEQ SAMPLES 135-60010-010000 Communications/Mobiles 3,997 4,717 4,589 4,700 5,000 2.863 60.91% CELL PHONE SERVICE MONTHLY, NEW EMPLOYEES, & REPLACEMENTS CELL PHONES 135-60020-010-000 Electricity 147,907 150,535 156,752 175,356 154,204 94,949 54,15% SEE SCHEDULE GF -K 135-60066-010-000 Publications/Books/Subscripts 739 716 767 1,000 1,000 767 76.70% AWWA STANDARDS 135.60070.010000 Dues & Memberships • 11 - 500 500 - 0.00% 135-60080-010-000 Schools & Training 1,353 1,545 936 2,785 4,651 1,537 55.18% SEE SCHEDULE GF -G 2 of 16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY GENERAL FUND Account Description FY 2015 Actual FY 2016 Actual FY 2017 Actual FY 2018 Budget FY 2019 Proposed YTD Total thru 06/30/2018 %ol Budget Comments 135.60090010-000 Safety Program - 249 - 400 400 8 2.09% SEE SCHEDULE 08-9 135.60100-010-000 Travel & per diem 200 87 124 1,735 2,345 87 5.0451 SEE SCHEDULE GF -G 135.60105010-000 Rent/Lease Equipment - 379 - 1,500 1,500 - 0.00% EMERGENCY EQUIPMENT RENTAL IF NEEDED 135.60135010.000 TCEQ Fees & Permits- MUD 30,058 17,788 31.064 55,176 58,000 17,410 31.55% REG. ASSESSMENT (50), WATER SYSTEM FEE5 (510,000) & NTGW WELL FEES (520,000) 135.60150010.000 Wholesale Water 2,266,895 2030,607 2,068,311 2.823,170 3,014.491 1.244,668 44.095: SEE 558E081E 0F.0 135.60245010.000 Miscellaneous Expenses- 57,602 - 103 200 200 - 0.0096 SEE SCHEDULE 07.1 135.60280-010-000 Property Maintenance 1,583 2.643 775 3,000 3,000 503 16.76% PROPERTY REPAIRS AFTER LINE BREAKS 135.60285010-000 lawn Equipment & Maintenance - 930 8,250 14,750 14,750 7,500 50.85% MOWING 514,750 135.60332.010.000 Interfund Transfer Out. Revenue MS - - 240,822 278,084 586,392 227,523 81.82% SEE SCHEDULE GF -B: FUNDS TO 7066565 TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS 135.60333.010.000 Interfund Transfer Out- Bond Reserve - - 48,047 48,996 55,193 36,747 75.00% SWIFT REVENUE BOND RESERVE PER COVENANTS 135.60334010.000 Interfund Transfer Out -Bank Reserve Account-•- 4,523 5,519 5,927 200000 200,000 1.053,935 526,97% TRANSFER FOR BANK RESERVE ACCOUNT 135.60360.010.000 Furniture/Equipment< 55000 1,823- 1,204 - 2,500 2,500 5,020 200.79% SEE SCHEDULE GF -9 135-65005.010-000 Fuel &Lube 12,517 12,647 8,733 15,000 15,000 7,954 53.0291 ALL WATER TRUCKS, GAS TANK TRAILER (MSC GAS), AND GM VEHICLE 135-65010-010-000 Uniforms 3.185 2,170 3,064 4,488 5,190 1,249 27.83% SEE SCHEDULE GF -F 135.65030-010-000 Chemicals 10,195 13,070 24,217 20,000 20000 13,450 67.25% AMMONIA NEEDED FOR NEW SYSTEM 135.65035010-000 Small Tools 995 868 868 1,200 1,200 - 0.00% LS 81 ENGINEERING 135.65040010000 Safety Equipment 457 719 507 1,000 1,000 583 58.3096 POTENTIAL EMERGENCY W W/COLLECTION 135-65050-010-000 Meter Expense 119,269 88,942 24,000 50,000 70,000 24,976 49.95% CSEP CODED HERE IN CURRENT YEAR 135.65053010.000 Meter Change Out Program - 77,325 71,160 84,000 87,000 48,900 58.21% FY 19 METER REPLACEMENTS, PROFILE HEAD REPLACEMENTS @5150 EACH, METER TESTING @ 5115 EACH 135.69005010.000 Capital Outlays 439,705 1,492,504 323,263 810,012 453,000 557,431 68.82% SEE SCHEDULE GF.A 13569008010.000 Short Term Debt -Principal 129,000 130,700 - 38,731 30,068 - 0.00% SEE SCHEDULE OF -B 135.69009,010-000 Short Term Debt -Interest 3,632 1,178 - 5,713 4,124 - 0.0014 SEE SCHEDULE GF.6 135-69195.010000 Gasb34/Reserve for Replacement 75,000 75,000 75,000 75,000 75,000 75,000 100.00% 1/10 MAJOR MAINTENANCE COST TOWN'S ELEVATED STORAGE TANK 545,000 135.69281.010,000 Water Tank Inspection Contract 126,958 126,958 126,958 118,774 120,000 107,864 90.81% ANNUAL MAINTENANCE CONTRACT 135.55135010-001 Lab Analysis - PID 3,046 1,725 2.183 2,000 2,000 1,200 60.00% PID PORTION 135-60135010-001 TCEQ Fees & Permits - PID- 135 - -•- 200 200 - 0.00% 135.60070.020.000 Subtotal Water 3,796,451 4,777,812 3,681,756 5,657,433 5,617,629 3,843,684 67.94% ANNUAL DUES Wastewater 135-50005.020,000 Salaries & Wages 305,552 369.462 387,947 410,866 429,182 273,390 66.5494 SEE SCHEDULE 08-9 135.50010.020000 Overtime 27,622 35,175 31,979 30,000 30,000 26,289 87.63% SEE SCHEDULE 08-9 135-50016.020000 Longevity 5,615 6,125 6,635 7,415 7,445 7,415 1000051 SEE SCHEDULE 07-11 135.50017-020,000 Certification 6,600 7,611 8.275 8,400 8,700 6,336 75.43% SEE SCHEDULE GF -FI 135.50020-020.000 Retirement 30.826 36,694 38,208 42,243 43,968 30,446 72.07% SEE SCHEDULE OF -1 135.50026,020-000 Medical Insurance 57,602 66,679 55,136 62,175 94,297 49,012 78.83% SEE SCHEDULE 07.1 135.50027.020000 Dental Insurance 3,682 4,119 4.464 5,271 6,251 3,576 67.84% SEE SCHEDULE GF.I 135-50028020,000 Vision Insurance 853 930 954 1,114 995 626 56.19% SEE SCHEDULE GF.I 135.50029-020-000 Ufe Insurance & Other 4,399 4,116 4,552 4,281 4,923 3,319 77.53% SEE SCHEDULE OF -I 135.50030-020,000 Social Security Taxes 19,403 23,597 25343 28,314 29,470 18,044 63.73% SEE SCHEDULE GF -1-1 135-50035.020.000 Medicare Taxes 4,523 5,519 5,927 6,622 6,892 4,220 63.7354 SEE SCHEDULE GF -9 135.50040-020-000 Unemployment Taxes 14 1,204 63 1,260 1,260 1,134 90.00% SEE SCHEDULE GF -9 135-50045.020.000 Workman's Compensation 8,975 7,003 14,903 17,990 17,217 12,132 67.44% TML INVOICE AMOUNT 135-50060.020-000 Pre-emp Physicals/Testing 189 238 g0 300 400 126 42.00% 135.50070.020-000 Employee Relations 523 722 461 350 300 - 0.00"% 135.55005.020-000 Engineering- - 852 - 30,000 - 0.00% LS 81 ENGINEERING 135.55070.020.000 Independent Labor- 27,109 19,449 20,550 15,000 2,145 10.44% POTENTIAL EMERGENCY W W/COLLECTION 135.55080.020,000 Maintenance & Repairs 96,664 173,132 97,990 86,100 88,000 64,183 74.55% CSEP CODED HERE IN CURRENT YEAR 135-55085-020-000 Generator Maintenance & Repairs - - 6.076 14.000 6,000 29 0.2151 MAINTENANCE & REPAIRS ON WW GENERATOR 135.55090020,000 Vehicle Maintenance 3,540 7,165 9.836 8,000 5,000 6,804 85.05% 135.55105.020.000 Maintenance -Heavy Equipment 803 742 24 500 1,500 395 79.0894 135.55125.020-000 Dumpster Services 48.977 41,801 56,329 60,000 75,000 57,580 95.9794 INCREASE DUE TO NEW SYSTEM 135.55135-020-000 Lab Analysis 26,355 37,393 32,416 30,000 35,000 24,158 80.53% INCREASE FOR MORE TESTING, ADDING VIRUS TESTING 135-60010.020,000 Communications/Pagers/Mobiles 5,274 5,888 5,460 4,700 5,000 3.725 79.26°% CELL PHONE SERVICE MONTHLY, NEW EMPLOYEES, & REPLACEMENTS CELL PHONES 135.60020020,000 Electricity 136.622 131,275 145,449 266.709 174,165 121,836 45.68% SEE SCHEDULE GF -K ADJUSTED COST FOR REAL DATA 135.60066,020-000 Publications/Books/Subscripts 135 - 150 200 200 - 0.00% 135.60070.020.000 Dues & Memberships 307 300 267 300 300 - 0.00% ANNUAL DUES 135.60080-020000 Schools & Training 1,526 3,361 2,959 5,677 7,155 658 11.59% SEE SCHEDULE 08.5 135.60090020000 Safety Program - 341 291 550 1,000 352 63.9554 135.60100-020-000 Travel & per diem 2,257 977 2,625 1,535 1,895 90 5.5354 SEE SCHEDULE GF -G 135-60105-020000 Rent/Lease Equipment 1 8,639 - 5,000 5,000 - 0.00% EMERGENCY EQUIPMENT RENTAL IF NEEDED 135.60125,020-000 Advertising- 4,086 5,000 1,000 - 0.0096 3 of 16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY GENERAL FUND Account Deurlption FY 2015 Actual FY 2016 Actual FY 2017 Actual FY 2018 Budget FY 2019 Proposed YTD Total thru 06/30/2016 Xal Budget Comments 135.60135-020-000 ICED Fees & Permits 9,019 18,527 32,564 85,000 20,000 30,273 35.61% REG. ASSESSMENT($O), ANNUAL FEE (512,000),'FY185OAH(75,000) 135-60245-020-000 Miscellaneous Expenses 19 423 113 450 450 0 0.00% SEE SCHEDULE GF•H 135-60280-020-000 Property Maintenance- 216 - - 4,000 5,000 42 1.05% MAINTENANCE FOR W WTP 135-60285-020.000 Lawn Equipment &Maintenance 785 • 6,490 11,600 11,600 5,780 49.83% MOWING FOR LIFT STATIONS 511,100 135.60331-020-000 Interfund Transfer Out -Tax 185 30,645 119,706 120,492 122,043 120.053 99,853 81.82% TRANSFER OF PID SURCHARGE 135-60332,020-000 Interfund Transfer Out- Revenue l&S 136.989 444,838 595,638 598,738 690,830 489,876 81.82% SEE SCHEDULE GF -82: FUNDS TO TRANSFER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS 135-60333-020-000 Interfund Transfer Out -Bond Reserve 71,946 123,336 - 123,336 125,187 92,502 75.00% TRANSFER FOR BOND RESERVE 135.60334.020-000 Interfund Transfer Out•Bank Reserve Account - - 180,417 200,000 200,000 343,401 171.70% TRANSFER FOR BANK RESERVE ACCOUNT 135.60360020-000 Furniture/Equipment< 55000- 2,950 - - 4,000 3,500 1,762 44.05% SEE SCHEDULE GF -H 135-65005.020.000 Fuel & Lube 17,164 10,253 8,722 12,500 12,500 6,910 55.28% WASTEWATER TRUCKS, AND MISC FUELING (LIFT STATION GENERATORS) 135.65010.020,000 Uniforms 2.598 4,142 3,754 4,459 5,495 1,775 39.8096 SEE SCHEDULE GF -F 135.65030-020-000 Chemicals 21,409 28,882 25,101 27,500 30,000 9,234 33.5816 INCREASE DUE TO MBR CHEMICAL CLEANING MONTHLY 135-65035-020-000 Small Tools 1,504 1,787 2.191 1,000 1,200 1,390 138.99% 135-65040-020-000 Safety Equipment 626 577 517 750 1,200 1,158 154.33% CHRISTMAS PARTY, STAFF MEETINGS 135-65045-020-000 Lab Supplies 12,341 17,349 13,258 14,000 17,000 15,644 111.74% 135-69005-020-000 Capital Outlays 196,760 188,556 276,328 547,327 330,000 106,519 19.46% SEE SCHEDULE GF -A 135.69008-020-000 Short Term Debt•Principal 56.991 21,277 - 51,342 109,858 - 0.0096 SEE SCHEDULE 01-B 135.69009-020.000 Short Term Debt -Interest 1,952 197 - 7,573 14,917 - 0.00% SEE SCHEDULE GF -B 135-69195-020-000 Gasb34/Reserve for Replacement 535 6,284 - 30,000 30,000 30,000 100.00% PLANNED REPLACEMENT OF WW INFRASTRUCTURE 135.55085-034000 Subtotal Wastewater 1,359,587 1,987,167 2,234,770 2,981,140 2,861,306_ 1,954,139 65.5536 MAINTENANCE & REPAIRS ON ADMIN GENERATOR Board of Directors 0.00% 135-50005.026.000 Salaries & Wages 14,900 9,100 -- 432,863 - - 0.00% SEE SCHEDULE GF -H 135.50030-026.000 Social Security Taxes 924 564- • 2,000 - - 0.00% SEE SCHEDULE GF•H 135.50035-026-000 Medicare Taxes 216 132- 3.418 - - - 0.00% SEE SCHEDULE 07-11 135-55040026,000 Unemployment Taxes 67 2- 37,687 - - - 0.00% SEE SCHEDULE 00-6 135-50045-026.000 Workman's Compensation 35 50 30 30 30 22 72.60% TML INVOICE AMOUNT 135.60066-026-000 Publications/Books/Subscripts - - - 150 150 - 0.00% SEE SCHEDULE GF -I 135.60070-026,000 Dues & Memberships 35 11 - 600 750 650 108.3396 SEE SCHEDULE GF -I 135.60075-026.000 Meetings 276 474 145 1,200 1,300 1,259 104.90% SEE SCHEDULE GF -I 135-60080-026.000 Schools & Training 2,950 1,875 3,557 4,000 4,000 1,540 38.50% SEE SCHEDULE GF -H 135-60100026,000 Travel &per diem 3,479 3,314 2,690 5,000 5,000 4,352 87.05% SEE SCHEDULE GF -H 135-60245-026-000 Miscellaneous Expenses 1,659 260 75 2,000 2,000 1,404 70.21% SEE SCHEDULE GF•H 135-50045-030-000 Subtotal Board of Directors 24,541 15,782 6,498 12,980 13,230 9,227 71.09% TML INVOICE AMOUNT Administration 0.00% 135.50005-030-000 Salaries & Wages 464.345 '484,728 432,978 432,863 427,426 283,511 65.5056 SEE SCHEDULE GF -H 135.50010-030-000 Overtime 608 901 3,498 2,000 2,000 557 27.85% SEE SCHEDULE GF•H 135.50016.030-000 Longevity 3,283 3,823 3.418 3.548 1,833 3,548 99.99% SEE SCHEDULE 07-11 135-50020-030-000 Retirement 41,787 42,642 37,687 40,553 39,891 28,911 71.29% SEE SCHEDULE 00-6 135-50026-030-000 Medical Insurance 61,099 61,243 44,204 63.485 75,343 35,039 55.19% SEE SCHEOULE 07-1 135.50027-030-000 Dental Insurance 3,754 4,207 3,938 5.502 4,700 2.498 45.41% SEE SCHEDULE GF -I 135.50028-030-000 Vision Insurance 1,012 975 842 1.173 768 462 39.42% SEE SCHEDULE GF -I 135-50029-030-000 Ufe Insurance & Other 5,203 4,678 4,426 5,059 4,923 2,813 55.61% SEE SCHEDULE GF -I 135-50030-030-000 Social Security Taxes 27,363 28,227 25,994 27.181 26,738 17,137 63.05% SEE SCHEDULE GF -H 135.50035-030-000 Medicare Taxes 6,399 6,601 6,079 6,357 6,253 4,008 63.05% SEE SCHEDULE GF -H 135.50040-030-000 Unemployment Taxes 144 1,349 _ 294 1,260 1,260 1,001 79.45% SEE SCHEDULE GF•H 135-50045-030-000 Workman's Compensation 1,048 2,067 1,796 1,529 1,256 1,112 72.7156 TML INVOICE AMOUNT 135-50060-030000 Pre•emp Physicals/Testing 38 147 701 500 500 212 42.3896 135-50070-030-000 Employee Relations 2,796 3,421 2,692 4,960 5,000 3,147 63.45% CHRISTMAS PARTY, STAFF MEETINGS 135.55005.030-000 Engineering - 4,365 - - - - 0.00% 135-55030.030-000 Software & Support 112,750 47,907 88,943 78,391 - 77,849 62,466 79.68% SEE SCHEDULE GF -L 135.55045-030-000 Legal- - - - - - 0.00% 135.55070-030-000 Independent Labor 57,935 1.806 30,925 154,000 175.000 113,701 73.83% VIDEO OF MEETINGS, GM CONTRACT 135.55080-030-000 Maintenance &Repairs 535 6,284 826 14,010 10,000 5,161 36.86% AC PREVENTATIVE MAINT AGREEMENT 5600, BUILDING MAINT MERGED, LOSS OF TOWN SHARED EXPENSE 135.55085-034000 Generator Maintenance & Repairs 6,368 - 485 10.000 10,000 4,625 46.25% MAINTENANCE & REPAIRS ON ADMIN GENERATOR 135.55100030000 Building Malnt & Supplies 7,530 6,890 7,705 - - • 0.00% RECIASS TO MAINTENANCE & REPAIRS 135.55120-030-000 Cleaning Services 22,602 7,017 6,705 10,000 10,000 6,570 65.70% CLEANING CONTRACT INCREASE 135-55160-030-000 Professional Outside Services 26,170 69,683 63,965 63.325 66.055 59,240 93.55% M3 IT SERVICES 559,205, NEWGEN STRATEGIES 135-55165.030-000 Collection Fees- - 200 - - 0.00% 135.55205.030-000 Utility Billing Contract 7,872 8,516 7,514 9,000 9,000 5,707 63.42% COST FOR PRINTING MONTHLY STATEMENTS 4of16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY GENERAL FUND Account Description FY 2015 Actual FY 2016 Actual FY 2017 Actual FY 2018 Budget FY 2019 Proposed YTD Total thru 06/30/2018 56 of Budget Comments 135.60005.030.000 Telephone 11,851 13,723 14,081 27,300 23,500 12,090 44.29% SEE SCHEDULE GF -L, PREVIOUSLY SHARED WITH TOWN 135-60010-030-000 Communications/Mobiles 4,053 4,041 3,621 4,000 4,000 2,274 56.85% CELL PHONE SERVICE MONTHLY, NEW EMPLOYEES, & REPLACEMENTS CELL PHONES 135-60020-030-000 Electricity 11.326 7,245 11,002 16,261 8,690 4,815 29.61% SEE SCHEDULE 68-6. 100% OF MUD/ANNEX BILL 135-60025-030.000 Water 922 934 1,041 2,500 2,000 524 20.9696 100% WATER BILL 135.60035.030-000 Postage 31,693 27,203 27,334 30,000 30,000 17,580 58.6096 PPD POSTAGE FOR METER, MONTHY METER LEASE 135-60040-030-000 Bank Service Charges & Fees 45,820 51,500 52,782 55,560 55,560 43,616 78.5094 135-60050-030-000 Bad Debt Expense 1,712 3,459 1.674 1,500 1,500 - 0.00% 135.60055.030-000 Insurance 49,110 33,573 59,614 56,000 65,000 58,698 104.82% TML INVOICE AMOUNT 135-60066-030-000 Publications/Books/Subscripts 1,225 260 770 1,600 1,000 206 12.90% 135-60070-030-000 Dues & Memberships 4,558 5.656 4,851 6,000 6,000 3,828 63.81% 135.60075.030-000 Meetings 60 163 122 400 400 81 20.13% 135.60079-030-000 Public Education 3,385 4,230 4,972 6,000 6,000 - 0.0056 ADDITIONAL CUSTOMER EDUCATION MATERIALS, WATERFEST 135-60080.030-000 Schools & Training 2,938 3.382 2,255 7.600 8,950 3,143 41.36% SEE SCHEDULE GF•G 135-60100-030-000 Travel & per diem 2,018 3,562 7,112 4,885 4,345 1,575. 32.24% SEE SCHEDULE GF -0 135.60110-030.000 Physlcels/Festing - - 200 200 - 0.00% 135-60115.030-000 Elections 1,289 3.610 2,961 4,500 - 220 4.8996 MUD BOARD ELECTION 135.60125.030-000 Advertising 6,983 1,549 2,323 2,500 25,000 150 6.0094 REBRANDING7777 135-60235-030-000 Security 60 - - 2,700 1,288 144 5.33% SEE SCHEDULE GF -L 135-60245.030-000 Miscellaneous Expenses 10,801 5,448 503 500 500 125 24.90% 135-60246.030-000 General Manager Contingency- 17,000 17,000 17,000 100.00% 135.60270-030-000 4th ofJuly Celebration 10,000 - - - - - 0.00% 135-60285.030-000 Lawn Equipment & Maintenance- - - - - - 0.0094 135-60336.030-000 Interfund Trans Out (MUD1 I&5( 14,000 - - -- - 0.00% 135.60360-030-000 Furniture/Equipments 55000 6,339 656 1,056 2,500 2,500 212 8.4896 135-65010-030-000 Uniforms 1,043 23 475 700 2,050 274 39.10% SEE SCHEDULE GF -F 135-65055.030000 Hardware IT 35,172 7,238 2,300 7,420 7,064 2,007 27.04% SEE SCHEDULE GF -L 135-65085-030-000 Office Supplies 8,145 5,632 5,353 7,000 6,000 3,871 55.2996 ALL DEPARTMENTS COMBINED (PENS, PAPER CLIPS, STAPLES, ETC.( 135.65090-030.000 Printer Supplies & Maintenance 2,870 1,302 754 2.000 3,500 2,049 102.43% SEE SCHEDULE GF -L, RECLASS PAPER WITH TONNER 135-65095-030000 Maintenance Supplies 4,461 3,632 3,985 4,000 4,000 3,420 85.50% ALL DEPARTMENTS COMBINED [LEAING SUPPLIES, PLATES, PAPER TOWELS, ETC.) 135-65105-030-000 Printing 1,333 3.232 2,593 4,000 2,500 144 3.60% SEE SCHEDULE GF -1. 135.69005-030-000 Capital Outlays 61.822 24,907 129,301 13,000 280,000 48,355 371.9694 SEE SCHEDULE GF -A 135.69170.030-000 Copier Lease Installments 3,485 3,888 3,929 4,600 4,000 2,217 48.19% SEE SCHEDULE GF -1.. Subtotal Administration 1,199,115 1,017,525 1,122,380 1,227,111 1,528,343 870,043 70.90% Non Depertmentel 135.55045.039-000 Legal 495,151 338,721 118,762 137.000 137.000 99,199 72.4194 135-55055.039,000 Auditing 16,836 29,039 18,809 24,500 30,800 25,659 104.73% FY 19 CONTRACT PRICE 025,300, ADDITIONAL FEES UP TO 55,500 135-55060-039-000 Appraisal 9,846 10,088 10,713 11,446 11,714 8,684 75.87% PROTECTED TARRANT COUNTY 52,758; DENTON COUNTY 58,956.12 135-55065.039-000 Tax Ad min Fees 2,456 2,469 2,562 3,800 4,800 2,968 78.12% Subtotal Nan Departmental 524,289 380,317 150,846 176,746 184,314 136,510 77.24% Total General Fund Revenues 7,964,090 7,164,842 8,957,219 10,248,327 10,492,152 8,347,765 Total General Fund Expenses 6,903,983 8,178,601 7,196,249 10,055,410 10,204,822 6,813,603 Net Budget Surplus (Deficit( 1,060,107 (1,013,759) 1,760,970 192,917 287,330 1,534,162 5 of 16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY FIRE DEPARTMENT Account Description FY 2016 FY 2016 FY 2017 FY 2017 FY2018 FY 2019 YTD Total thru 06/30/2018 Comments Budget Actual Budget Actual Budget Proposed Revenues -Town 122-40001-000-000 Assessment - Emerg Svcs 404,346 403,838 472,439 427,439 486,626 538,869 SEE SCHEDULE TAX_ASSESS 122-40003-000-000 Emer Svcs Assessmen/Delinquent - 346 - - - - 122-40015-000-000 Property Taxes/Assessments P&I - - 750 750 - - 122-42014-000,000 Fire Permits/Sprinkler & Plan Review 5,000 5,200 5,000 5,000 100 65,000 122-43400-000-000 Fire Inspections 825 1,075 825 825 - - 122-43415-000-000 Denton/Tarrant Cty Pledge -Fire 10,000 10,000 10,000 10,000 10,000 10,000 10,000 Revenues -MUD 122-40001-000-000 Assessment-Emerg Svcs Relmb from Town - - - 112 - - 122-40010-000-000 Property Taxes/MUD Fire 889,963 875,978 1,035,810 1,036,680 1,054,433 1,201,853 1,061,756 SEE SCHEDULE TAX_ASSESS 122-40011-000-000 Property Taxes/Fire-Dellnquent - 18,076 - 3,196 - - 3,903 122-40020-000-000 Property Taxes/Fire P&I 4,500 7,621 4,500 4,184 - - 4,632 122-49000-000-000 Capital Leases -Other Financial Sources - - 122-49026-000-000 Proceeds from Sale of Assets 60,000 60,000 - 60,000 - - - 122-49035-000-000 Prior Year Reserves - - - - - - 122-49036-000,000 GASB Reserves - 36,182 - 23,164 - - - 122-49900-000-000 Miscellaneous Income 10,001 11,100 - 149 - - - Total Revenue 1,384,635 1,429,416 1,529,324 1,571,499 1,551,159 1,815,722 1,080,291 6 of 16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY FIRE DEPARTMENT Account Description FY 2016 FY 2016 FY 2017 FY 2017 FY2018 FY 2019 YTD Total thru 06/30/2018 Comments Budget Actual Budget Actual Budget Proposed Expenses -Town 122-50005-045-000 Salaries & Wages 508,226 511,904 551,224 537,947 558,792 638,481 122-50010-045-000 Overtime 48,735 58,952 50,237 74,868 50,122 73,688 122-50011-045-000 Holiday Pay 15,852 14,718 - - - - 122-50016-045-000 Longevity 5,761 5,730 5,618 5,599 5,879 6,566 122-50017-045-000 Certification 4,200 4,740 5,400 4,988 4,950 4,950 122-50020-045-000 Retirement 75,571 71,888 80,434 79,312 81,248 90,511 122-50026-045-000 Medical Insurance 65,546 56,876 68,414 61,919 85,723 85,791 122-50027-045-000 Dental Insurance 4,885 5,016 4,797 4,373 4,285 4,998 122-50028-045-000 Vision Insurance 859 968 479 429 433 536 122-50029-045-000 Life Insurance & Other 4,585 4,016 3,684 2,853 3,746 4,068 122-50030,045-000 Social Security Taxes 36,132 32,993 37,974 34,575 37,565 43,901 122-50035-045-000 Medicare Taxes 8,450 7,714 8,881 8,084 8,785 10,267 122-50040-045-000 Unemployment Taxes 2,000 2,125 1,467 144 1,424 1,628 122-50045-045-000 Workman's Compensation 9,379 9,379 9,969 7,885 10,139 11,203 122-50060-045-000 Pre-employment Physicals/Test 250 54 700 2,917 4,600 7,794 122-50075-045-000 Tuition Reimbursement - - 1,300 2,184 5,075 9,600 122-55030-048,000 Software & Support 6,661 5,561 8,206 608 6,943 12,813 122-55045-045-000 Legal 5,000 6,560 6,600 - - - 122-55080.045,000 Maintenance & Repairs/Equipment 25,218 54,653 21,370 5,214 17,240 21,900 122-55085-045-000 Generator Maintenance & Repairs - - 2,000 - - 122-55090-045-000 Vehicle Maintenance 10,000 14,808 20,000 23,053 46,000 48,500 122-55100-045-000 Building Maintenance - - - 13,758 16,750 93,000 $75000 - 2019 Exhaust Reclamation System 122-55160-045-000 Professional Outside Services - 2,744- 2,327 2,723 3,000 122-60005-045-000 Telephone 50 59 50 - - - 122-60010.045,000 Communications/Mobiles 7,706 6,835 8,931 11,235 13,245 8,925 122-60020-045-000 Electricity/Gas 7,412 5,686 6,673 6,446 8,140 8,000 122-60025-045-000 Water 1,200 2,0271, 1,200 2,758 4,648 3,800 122.60026-045-000 Cable 1,920 1,9201 1,920 - - - 122-60035-045,000 Postage 50 46 50 57 50 100 122-60066-045-000 Publications/Books/Subscrlps 350 172 350 350 350 350 122-60070-045-000 Dues & Memberships 15,582 15,457 15,582 15,404 19,295 20,417 122-60080-045-000 Schools & Training 6,880 3,743 7,880 3,825 15,670 24,090 122-60096-045-000 Emergency Management 1,000 1,000 1,000 1,919 1,000 1,000 122-60100-045-000 Travel & per diem 2,081 1,147 4,081 1,979 7,066 13,507 122-60110-045-000 Physicals/Testing 4,700 6,804 8,085 - - - 122-60125-045-000 Advertising 4,700 4,200 500 398 500 750 122-60160-045-000 Programs & Special Projects 7,500 3,671 7,500 6,581 13,750 15,300 122-60180-045-000 Fire Inspection/Enforcement 500 359 500 - - - 122-60195-045-000 Flags & Repair 3,184 2,355 3,050 3,311 3,500 9,419 122-60243-045-000 Prior Year Expense - - - - - 122-60245-045-000 Miscellaneous Expense 1,001 1,119 1,000 767 6,000 6,000 122-60280-045-000 Property Maintenance - - 12,000 - - - 7 of 16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY FIRE DEPARTMENT Account Description FY 2016 FY 2016 FY 2017 FY 2017 FY2018 FY 2019 YTD Total thru 06/30/2018 Comments Budget Actual Budget Actual Budget Proposed 122-66500-045-000 Dispatch -Denton County - - - 2,376 - 3,481 122-65005-045-000 Fuel 15,122 4,729 21,111 15,614 13,613 13,933 122-65010-045-000 Uniforms 3,640 9,516 3,140 9,266 6,687 5,907 122-65015-045-000 Protective Clothing 9,000 47,907 28,000 27,815 30,200 31,600 122-65030-045-000 Chemicals 600 1,191 1,500 - - - 122-65035-045-000 Small Tools/Equipment 2,000 1,868 6,000 17,681 5,000 25,800 517500- 2019 & 2020 Extrication Tools 122-65055-045-000 Hardware 750 394 750 - 1,100 4,200 122-65085-045-000 Office Supplies 500 328 500 815 250 250 122-65095-045-000 Maintenance & Supplies- - - 410 1,500 1,500 122-65105-045-000 Printing 498 - 498 265 250 250 122-00000-045-000 Printer Supplies - - - - 1,400 1,400 122-69050-045-000 Radios 8,000 7,934 29,000 - - - 122-69255-045-000 Airpacks - - 11,050 - - - 122-83700-045-000 Capital Expenses - - - 28,962 - - 9,750 Expenses -MUD 122-55080-045-000 Maintenance & Repairs (GASB34) - - - - - 1,490 122-60030-045-000 Rent And/Or Usage 214,379 214,379 216,754 214,379 218,954 215,979 218,954 SEE SCHEDULE FD -8 122-60055-045-000 Insurance 18,451 9,072 16,513 9,072 18,000 18,000 11,429 TML INVOICE 122-60337-045-000 Transfer to Town/Fire Budget - - - - - - 507,425 122-69005-045-000 Capital Outlays - 7,918 16,836 7,918 - - - 122-69008-045-000 Short Term Debt -Principal - - - - - - - 122-69009-045-000 Short Term Debt -Interest - - - - - - - 122-69195-045-000 GASB34/Reserve for Replacement 81,420 81,420 81,420 81,420 81,420 81,420 81,420 ANNUAL RESERVE FOR NEW FIRE ENGINE 122-69305-045-000 Capital Leases 127,149 127,149 127,149 127,149 127,149 127,149 127,149 LEASE PAYMENT NO. 4 OF 7 FOR LADDER TRUCK Total 1,384,635 1,441,804 1,529,327 1,471,209 1,551,159 1,815,722 957,617 Total Fire Revenues 1,384,635 1,429,416 1,529,324 1,571,499 1,551,159 1,815,722 Total Fire Expenses 1,384,635 1,441,804 1,529,324 1,471,209 1,551,159 1,815,722 Net Budget Surplus (Deficit) - (12,388) - 100,290 - - Town/MUD Fire Contract Calculation FY 2019 Fire Budget 1,815,722 Less: Rent/Debt Service 215,979 Less: Capital Leases 127,149 Less: ESD Assessment 538,869 Less: TML Fire Insurance 18,000 Less: Capital Outlays _ - Less: GA5834/Reserve for Replacement 81,420 Less: Denton County Fire Pledge 10,000 Less: Fire Permits/Sprinkler 65,000 Less: Fire Inspections - 122-60337-045-000 Transfer to Town from MUD/Fire Budget 759,305 Monthly payment to Town Oct 18 -Sept 19 63,275 8 of 16 Total: 5 184,314 1 FIRE TAX/ASSESSMENT RATE, TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY SCHEDULE TAX_ASSESS TAX RATE AND PID ASSESSMENT & SURCHARGE CALCULATIONS NET TAX VALUE: TARRANT COUNTY: 5433,850,584 42,941 07/20/18 DENTON COUNTY: 51,228583,025 42,934 07/23/18 DENTON CO. PID: 5745,061,830 42,934 07/23/18 OUT OF DISTRICT & PID 5314,500 42,934 777 REQUIRED REVENUE TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VAL5/100 FIRE 51,740,722 O&M TAX/SURCHARGE RATE TARRANT COUNTY: DENTON COUNTY: DENTON CO. PID: 6.13/100 = 24,078.099 FV 2019 Tax/Assess Rate = 0.072291 Revenue from MUD Tax = Revenue from PID Assess 5 1,201,853 5 538,869 Total: $ 1,740,7221 NET TAX VALUE: 433,850,584 1,228,583,025 745,061,830 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VAL5/100 O&M 184,314 167,800 )65 TAX/SURCHARGE RATE MUD PID Vats/100 = 24,074,954 FY 2019 MUD O&M Tax Rate = 0.00766 FY 2019 PID Tax/Surcharge Rata = 0.00697 Revenue from MUD Tax Revenue from PID Surcharge = [OVERALL TAX RATE FY 2019: $0.121283161 TAX COMPARISON TO FY 2018 0&M (General Fund)Tax 1 & 5 (Debt Service) Tax Fire Tax 2018 2019 0.00788 0.00766 0.04363 0.04134 0.06870 0.07229 Total Tax Rate: 0.120210 0.12129 Increase/Decrease: 0.00108 PID Ire Assessment Rate 0.06870 0.07229 Increase/Decrease: 0.00359 MAX ROLLBACK RATE 5 132,384 (A11 of Dept. 39 Budget) $ 51,930 (Legal and Auditor only In Dept 39 Budget) NEW DEBT: CALCULATE AMOUNT DUE FROM PID NET TAX VALUE: TARRANT COUNTY: DENTON COUNTY: DENTON CO. PID: 5433,850,584 51,228,583,025 $745,061,830 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VATS/100 TAX DEBT 2014 AND AFTER 111),S) $387,925 MUD DE8T: CALCULATE MUD TAX Vats/100= 24,074,954 NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE 1FY 2019 PID Surcharge Rate = 0.016111 Revenue from MUD Tax = 5 267,872 Revenue from PID Surcharge • $ 120,053 Total: $ 387,925 NET TAX VALUE: TARRANT COUNTY: DENTON COUNTY: $433,850,584 51,228,583,025 REQUIRED REVENUE I&5 MUD DEBT $687,175 TAX/SURCHARGE RATE x REQUIRED REVENUE/TOTAL VALS/100 Vats/100 = 16,624,336 0.041341 1FY 2019 Tax Rete = Revenue from MUD Tax Revenue from PIO = N/A $ 687,175 Total: 5 687,1751 0.1166 9 of 16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY SCHEDULE GF - A FY 2019 CAPITAL OUTLAYS WATER - PURCHASES WATER - MAINTENANCE & REPAIRS DESCRIPTION AMOUNT On Call Truck (Water) 28,000 Total: WASTEWATER - PURCHASES $28,000 DESCRIPTION AMOUNT Back Up Generator (WW) 75,000 Total: $75,000 DESCRIPTION AMOUNT AMOUNT Water Line Replacement- Carnoustie\Creek Courts Spare Part Inventory 275,000 Valve Replacement 30,000 50,000 Fencing Budget Software 100,000 Point to Point Communication/Town Project 30,000 Total: $425,000 WASTEWATER - MAINTENANCE & REPAIRS DESCRIPTION AMOUNT LS Upgrades (Lights, Control Pannels, Quick Connects) 75,000 Spare Part Inventory 50,000 LS #1 Engineering 30,000 In -Plant Water System 100,000 Budget Software 20,000 Total: $255,000 ADMINISTRATION - PURCHASES/SOFTWARE DESCRIPTION AMOUNT GIS Mapping development 30,000 CMMS (Asset Management) Development 35,000 Board Room Audio and Video Improvements 100,000 Phase 2 WWTP Security Improvements 65,000 Budget Software 20,000 Point to Point Communication/Town Project 30,000 Total: ADMINISTRATION - MAINTENANCE & REPAIRS $280,000 DESCRIPTION AMOUNT Total: so 10 of 16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY SCHEDULE GF - Bl TAX DEBT PAYMENTS LONG TERM TAX DEBT 11 of 16 MUD/PID PaId Par Principal FY 19 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Protect/Reason Series 2010 (Tax) MUD 52,000,000 585,000 531,441 531,441 562,883 5750 5148,633 9/1/2031 9/1/2020 Trophy Club Fire Station and costs related to the Issuance of the Bonds. Series 2012 (Tax) MUD 52,355,000 5225,000 516,988 516,988 533,975 5500 5259,475 9/1/2023 9/1/2020 Refund MUD 82 Unlimited Tax Bonds, 2002 and costs related to the Issuance of the Bonds. Series 2013 (Tax) MUD 51,905,000 5195,000 515,838 515,838 531,675 5500 5227,175 9/1/2023 9/1/2023 Refund MUD 82 Unlimited Tax Bonds Series 2003 and MUD 82 Unlimited Tax Refunding Bonds Series 2005 and costs related to the Issuance of the Bonds. SUBTOTAL MUD•ONLY TAX BONDS: 56,260,000 5505,000 $64,266 564,766 $128,533 51,750 5635,283 Series 2014 (Tax) MUD/PID 55,765,000 5250,000 568,763 568,763 5137,525 5400 5387,925 9/1/2035 9/1/2024 Tax Bonds for Wastewater Plant Expansion Issued 10/1/2014 SUBTOTAL ALL MUD/PID TAX BONDS: 55,765,000 5200,000 $68,763 568,763 5137,525 5400 5387,925 TOTAL ALL BONDS: 512,025,000 $755,000 5133,029 5133,029 5266,058 52,150 $1,023,208 11 of 16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY SCHEDULE GF - B2 REVENUE DEBT PAYMENTS LONG TERM REVENUE DEBT SHORT TERM REVENUE DEBT MUD/PID Paid Par Principal FY 19 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2015 (Revenue) WWTP 5154,843 59,230,000 5375,000 5111,669 5111,669 5223,338 5400 5598,738 9/1/2035 9/1/2024 Revenue Bonds for WWTP Expansion SUBTOTAL REVENUE BONDS: 5205,257 $9,230,000 $375,000 $111,669 $111,669 $223,338 $400 $598,738 Replacement Wastewater Series 2016 (Revenue) SWIFT 5210,000 54,635,000 5215,000 531,342 $31,342 562,684 5400 5278,084 Replacement Revenue Bonds for Fort Worth Line Phase 2 SUBTOTAL REVENUE BONDS: 5570,100 54,635,000 $215,000 531,342 531,342 562,684 5400 5278,084 'Series 2018 (Revenue) 16 Inch Water 57,200,000 5317,130 50 582,870 $82,870 5400 5400,400 Revenue Bonds for 16in Water Line (77%) and Overrun for WWTP Expansion (23%) SUBTOTAL REVENUE BONDS: 57,200,000 $317,130 $0 582,870 582,870 5400 5400,400 TOTAL ALL 00905: 521,065,000 5907,130 5143,011 5225,881 5368,891 51,200 51,277,221 SHORT TERM REVENUE DEBT ('Projected Par and Payments 12 of 16 Original PAR Outstanding Debt Principal FY 19 Interest 2/1 Interest 8/01 Subtotal Interest Total Payoff Date Protect/Reason Department Vaccon and Camera Van (Water 43%) 5154,843 5242,872 530,068 52,284 51,840 54,124 534,193 Replacement Water Vaccon and Camera Van (WW 57%) 5205,257 5321,947 539,858 53,028 52,440 $5,467 545,325 Replacement Wastewater Camera Van 5210,000 5210,000 570,000 54,725 54,725 59,450 579,450 Replacement Wastewater Total: 5570,100 5774,818 $139,927 510,036 $9,005 519,042 5158,968 ('Projected Par and Payments 12 of 16 AVG METERS A5 OF COMPLETED LAST THREE FISCAL YEARS AVG WATER USE OF COMPLETED LAST THREE FISCAL YEARS 100,906,333 59,541,000 44,636,333 38,902,000 42,846,000 52,877,000 59,388,667 67,059,333 87,210,000 119,888,667 137,177,000 119,590,000 4535 4542 4559 4555 4565 4583 4596 4612 4643 4635 4644 4641 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY SCHEDULE GF -C PROJECTED WATER USE PROJECTED FORT WORTH WATER COST ANNUALIZE GROWTH IN WATER METERS = PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2019 = 0.50°S 4,742 Growth is slowing significantly as build out approaches .05% recommended Purchased Water Expense (Projected Fort Worth Costs) Purchased Water (gallons): PROJECTED EOM AND AVERAGE WATER USE PER METER FOR PROJECTED WATER USE MONTHITEM NO. MONTH AVERAGE ANNUAL NO. OF WATER METERS THE LAST 3 COMPLETE FISCAL YEARS (GALLONS) GALLON (GALLONS) 1 OCT 4,744 22,249 105,548,407 2 NOV 4,746 13,109 62,214,610 3 DEC 4,748 9,792 46,489,511 4 JAN 4,750 8,541 40,569,584 5 FEB 4,752 9,385 44,596,824 6 MAR 4,754 11,538 54,852,395 7 APR 4,756 12,922 61,454,195 8 MAY 4,758 14,540 69,179,725 9 JUN 4,760 18,784 89,410,515 10 JUL 4,762 25,868 123,177,209 11 AUG 4,764 29,539 140,715,112 12 SEP 4,766 ,a 25,768 122,804,948 AVERAGE 4,755 16,836 TOTAL 961,013,035 CALCULATED AVERAGE WATER USE PER METER PER MONTH = (GALS/METER/MN) 16,836 PROJECTED TOTAL NO. OF NEW RETAIL METERS IN FY19 = (METERS) 24 PROJECTED TOTAL OF ADDITIONAL GALLONS IN FY19 = (GALLONS) 404,070 Growth is slowing significantly as build out approaches .05% recommended Purchased Water Expense (Projected Fort Worth Costs) Purchased Water (gallons): 961,013,035 Out of District Volumetric Charge Per 1000 Gallons $2.46 $2,363,227 Rate of Use Charge Monthly $44,246.97 $530,964 Increase Monthly Rate of Use Charge- Projected True Up $10,000.00 $120,000 Service Charge Monthly $25 $300 Total: $3,014,491 13of16 1=1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY PROKM0 %MG MEW! -: ..":"...: ... -:33::" :37..: 7.= ... -::-- = •=- 77:.::: 7.--- .., 2 IFS :I::: iz.... I":' -'i '..: :: :: :7:, ''''' .:'.'• ..*:',..,!:: .rii.-- ...... „.... ..,.. - ...,. ,.... ... ..... .-- :F.i F'S .. = 7x:r: ;IS 14 of 16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY SCHEDULE GF -E PROJECTED RETAIL WASTEWATER SALES FY 2019 W111106 Neu 339 784 Apr 8939 Jul Am 7.8 G 89 1100 444,0]44 UN. 2669269 Wye Ma.. 9sye 4439!61* 6.39 Cisme 4990960 U.1e A(`1m11n1e Ci3ye A.mn3e .3e Wage 4110 19453115 usys .e3e 0 to 1000 16 9636 320 239) 4 588 686 95/9. 9143592 314 6.51968 160 451151! +534 VI 325 6552301 105611 4,639311 179 4969610 1,000 2006 to 2001 121 159 3,511612 4471131 272 375 4441932 4,165,114 3393 BO 3A2 4 109180 13,7 4 km MI Ile 474 4,36,545 86641 241 4,412,431 ,307 221 4.401,319 6419 135 4938,641 40..99 96 104 4,551363 379 714900 33 063 4,5}],189 di 111 591,093 4,50994) 3700 to 4 UV 181 42)191) 413 !,)9092641 e ell 9757 ,632;+21 041 ,•+15 611 175 )51),611 29051.17 531 496 7379941 3046 343 IIB 422 3,361.477 • 436 3,246,959 3,356,021 240 248 4,1)640) 9939901 132 122 4,49,614 4,}12,9]0MI 301 4,439,592 1,311 130 111 4,191,935 4.}61,26} 5010 In 6 000 114 3 903 511 42 3971357 1 318 191 753 9979233 410 2 311 207 397 0,549)1} 49 3943849 356 294},661 19 3603831 136 309104 106 4,140,004 115 41•]01) 6000 to 7,000 119 1,24,314 792 3,639,49 1840,411 1,929077 366 1,96126 311 2,159612 301 1,595,695 761 3,539,160 7,324.294 16 1955511 122 4,133,693 195 4,001414 7000 3010 ea 7 WO 909 let 129 In 245 ]331,982 206)}34 711 1249,489 926,41 1499129 1,115.637 263 374 1439,309 1573335 215 233 2,1174]5 231 211 3,110,16) 2,080,261 3,163,161 2916,510 351 169 9709,514 3451,311 115 125 4,011,351 1,1960! 156 16 363492 01244 990 14,339 916 1 14,322968 ,32791 7,12801 43) ?204,.32 310,001 639 5,136,101 613 9017.317 694,011 755 ],600,012 1449 1915!36 15,100,114 )82 17,411410 116,169749 14,09 12 MO 11,000 }03900 •27 309375 605251 126 1361,12* 947,87;4 98 626 194 19.10363 361548 MI 1616886 295 7,71],139 314 4,457,101 ]358,108 517 7,176592 5,79?295 466 3,595,561 7,194,49 535 355 IA60 6,055,496 20,09 7509 15000 to NOLO 59 215 5581,520 2,962,711 90 7065101 18.1332 093,211 MO. IS 759,511 09513 129 6,312 lil 1,717,963 901,153 229 113 9516,675 1,34.165 47 153 3,6)4,553 9015,103 556 302 7.043,949 3939060 621 6,133,5. 9206560 539 306 7,373 025 4,033,713 9009 to 4,90 199 2567365 56 1011933 136,779 Ii95 47 15635 1,118,2 - 1,977,703 259 3,376 423 330 4,773641 212 34,000 tO 39000 110 1.15596 40 761,196 i7 ,751 4 6519 22 5442,056 605420 57- 316,5}53 79 1,20,696 155 9X0792 323 3359716 165 7,439)14 19,000 95,000 to 44000 5090 62 1,261,693 1,191,173 26 IS 594,321 531.106 6,506 ),D4 5,735 9s} 166,115 463546 65516 96583 50} 10* >3 626,743 Np 3i 9,373 611,146 71 9663,976 ]45) 323 825Y2 0,118066 107 7 1:9.30+ 1 554 365 50002 4908 to 5?NO to 66 800 21 11)1,)39 9101 462 18 )5145-6 604982 091 10 .1407 422336 70904 11 73,04!7419 54,3.6 953)i 506,].» 202417 630,19 IB 931,017 77 1,552,14 914 92 52 3259641 1,754763 57 6990 • • 105 25,918199 Ll 1`.556.699 5. 9.49.031 33 7,346.136 44 8,013.. 51 15253.0 51 14015.26 58 17,123,956 28 .3.435970 111 31,996,561 351 87,717,103 139 11041.1.3 15of16 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 DRAFT FY 19 BUDGET SUMMARY SCHEDULE GF -E-2 PROJECTED RETAIL WASTEWATER SALES FY 2019 Rates Minimum Charge All Meter Sizes Residential (Winter Average) Commercial Total $19.60 $19.60 Volumetric Charge (000's) 0.4,000 53.18 4,001-8,000 $4.51 8,001-12,000 $6.43 12,000+ 59.14 Commercial $5.92 Billing Determinants Annual 9 of Meters Volumes (000's) 0 -4,000 gallons 4,001- 8,000 gallons 8,001- 12,000 gallons > 12,001 gallons Commercial (000's) 52,968 190,040 100,184 39,464 36,844 1,278 54,246 190,040 100,184 39,464 36,844 366,532 366,532 97,834 97,834 Projected Revenue Meter Charge Revenue Residential 0 -4,000 gallons 4,001- 8,000 gallons 8,001-12,000 gallons > 12,001 gallons Subtotal Commercial Total Revenue $1,038,163 $604,327 5451,830 $253,754 $336,754 525,056 51,063,219 $604,327 $451,830 $253,754 $336,754 51,646,665 50 $1,646,665 $579,177 $579,177 $2,684,828 $604,233 $3,289,061 Revenue Requirement 53,292,584 Over/(Under) Recovery (5) -53,523 Over/(Under) Recovery (%) -0.11% 16of16