Loading...
HomeMy WebLinkAbout2021-0816 August 16 2021 Regular Meeting Agenda PacketMonday, August 16, 2021 TROPHY CLUB MUNICIPAL UTILITY DISTRICT August 16, 2021 Regular Meeting Agenda Packet BOARD OF DIRECTORS REGULAR MEETING TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 6:30 P.M. Svore Municipal Boardroom REGULAR MEETING AGENDA PACKET 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 comments made to the Board at this time concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the President or presiding officer. To speak during this item, you must complete the Speaker's form that includes the topic(s) of your statement. Citizen Comments should be limited to matters over which the Board has authority. REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Water Operations Report c. Wastewater System Reports d. Finance Reports attachments: Staff Reports CONSENT AGENDA All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that item will be removed from the consent agenda and will be considered separately. 2. Consider and act to approve the Consent Agenda. a. July 2021 Combined Financials b. July 27, 2021 Joint Meeting Minutes c. July 27, 2021 Regular Meeting Minutes d. Approve Interlocal Cooperation Agreement with Denton County for Property Tax Assessment and Collection effective October 1, 2021 with automatic renewals through tax year 2023. attachments: July Combined Financials July 27, 2021 Joint Meeting Minutes 1of69 August 16, 2021 Regular Meeting Agenda Packet July 27, 2021 Regular Meeting Minutes Denton County ILA REGULAR SESSION 3. Receive Master Plan update from Halff Associates. 4. Consider and take appropriate action regarding water and sewer rates for Fiscal Year 2022: a. Receive report from Rate Committee. b. Consider and take appropriate action regarding rate assumptions and projections for FY2022 Budget. (Staff/NewGen) 5. Consider and take appropriate action regarding Fiscal Year 2022 Budget Matters: a. Report from Budget Committee b. Discussion regarding the Draft Fiscal Year 2022 Budget. attachment: FY2022 Budget Draft 6. Consider and take appropriate action regarding tax rates for 2021 tax year: a. Approve proposed tax rate for 2021 tax year: and, b. Schedule date and authorize publication of notice for hearing regarding adoption of final tax rates for 2021 tax year. attachment: Proposed Tax Rate 7. Consider and act to ratify and approve fire department budget for Fiscal Year 2022 pursuant to July 27, 2021 special meeting. 8. Discussion and possible action regarding GASB reserves and fire department ladder truck lease. EXECUTIVE SESSION 9. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Consult with legal counsel regarding the existing Interlocal Cooperation Agreement for Administration of Fire Protection Services between the District and the Town of Trophy Club, and seek legal advice regarding the potential renewal, termination, modification, or replacement thereof. 10. Deliberations pursuant to Section 551.074(a)(1) of the Texas Open Meetings Act regarding appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee: General Manager annual review. 2 of 69 August 16, 2021 Regular Meeting Agenda Packet REGULAR SESSION 11. Consider and take appropriate action regarding Executive Session. 12. Items for future agendas: 13. Set future Meeting dates — Monday, September 20, 2021 at 6:30 p.m. attachment: Meeting Calendar *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION, DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE MODIFIES THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 3 of 69 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 1. August 16, 2021 Regular Meeting Agenda Packet Monthly Water Operations Report Water Billed FY October November December January February March April May June July August September Total Year 2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397 2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371 2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 110,072 130,945 114,497 900,769 2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 92,913 113,135 110,873 864,483 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792 2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766 2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747 96,174 131,472 114,784 746,055 2020 102,150 40,988 43,946 36,418 31,000 34,047 53,755 67,030 96,195 123,309 118,522 83,570 830,930 2021 1 98,232 1 57,380 1 40,841 1 42,725 1 40,786 1 41,078 1 67,776 1 50,736 1 64,195 1 100,853 1 1 1 604,602 WATER BILLED IN THOUSANDS OF GALLONS ,000 120,000 100,000 80,000 60,000 40,000 20,000 March Ap -2017 -2018 2019 -2020 -2021 Water Jumped FY October November December January February March April May June July August September Total Year 2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301 2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723 2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210 2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819 2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237 2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193 2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053 2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344 2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090 2020 112,971 48,627 49,384 40,726 35,749 38,576 57,714 74,153 106,219 136,306 130,721 89,514 920,660 2021 I 106,660 l 66,304 I 46,962 l 50,538 I 47,733 l 44,191 I 75,866 l 56,985 I 73,907 l 113,015 I lI 682,161] WATER PUMPED IN THOUSANDS OF GALLONS October November December January February March April May June July August September -2017 -2018 -2019 -202 -202 FY October 2015 Total 4353 2016 Total 4531 2017 Total 4644 2018 Total 4701 2019 Total 4741 2020 Total 4795 2020 MUD 3351 2020 PID 1444 2021 Total 4837 2021 MUD 3393 2021 PID 1444 November December 4363 4377 4538 4556 4647 4661 4706 4712 4743 4745 4796 4797 3352 3353 1444 1444 4837 4837 3393 3393 1444 1444 Active Connections January February 4404 4413 4568 4593 4657 4663 4716 4720 4753 4753 4797 4807 3353 3363 1444 1444 4837 4837 3393 3393 1444 1444 March April 4429 4443 4604 4607 4666 4670 4724 4724 4758 4761 4807 4816 3363 3372 1444 1444 4 of 69 4837 4837 3393 3393 1444 1444 May June 4459 4478 4616 4622 4676 4685 4728 4732 4762 4768 4817 4830 3373 3386 1444 1444 4837 4839 3393 3395 1444 1444 July 4486 4627 4690 4735 4770 4836 3392 1444 August September 4498 4517 4632 4636 4696 4700 4736 4738 4773 4782 4836 4837 3392 3393 1444 1444 4841 3397 1444 August 16, 2021 Regular Meeting Agenda Packet July 2021 Results Ammonia -N CBOD5 TSS Date % Removal % Removal % Removal Influent Effluent Influent Effluent Influent Effluent 6 -Jul 42.0 0.20 99.5% 298 2.0 99.3% 179 1.0 99.4% 8 -Jul 30.2 0.20 99.3% 291 2.0 99.3% 183 1.0 99.5% 12 -Jul 44.2 0.20 99.5% 299 2.0 99.3% 303 1.0 99.7% 15 -Jul 49.8 0.20 99.6% 294 2.0 99.3% 259 1.0 99.6% 19 -Jul 50.5 0.20 99.6% 292 2.0 99.3% 302 1.0 99.7% 22 -Jul 45.0 0.20 99.6% 291 2.0 99.3% 245 1.0 99.6% 26 -Jul 51.0 0.20 99.6% 283 2.0 99.3% 227 1.0 99.6% 28 -Jul 53.0 0.20 99.6% 282 2.0 99.3% 144 1.0 99.3% IReport Ammonia -N CBOD5 TSS 0.20 1 99.5% 2.0 1 99.3% 1.0 1 99.5% 5 of 69 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 6.0 5.0 4.0 3.0 2.0 1.0 0.0 August 16, 2021 Regular Meeting Agenda Packet Ammonia Nitrogen Permit Limit 3 (Jan - March) Permit Limit - 1 from April - August 0.378 Permit Limit 3 (Sept. - Dec.) 0.20 0.20 0.20 0.20 0.20 0.20 0.20 0.205 0'295 0.225 0.209 0.20 Jul 20 Aug 20 Sep 20 Oct 20 Nov 20 Dec 20 Jan 21 Feb 21 Mar 21 Apr 21 May 21 Jun 21 Jul 21 99.6% 99.6% 99.6% 99.6% 99.6% 99.6% 99.6% 98.7% 99.4% 99.5% 99.4% 99.5% 99.5% Carbonaceous Biochemical Demand (CBOD5) 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Permit Limit 5 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 IIIII[IIIIIIIIILIJIIIIIIII Jul 20 Aug 20 Sep 20 Oct 20 Nov 20 Dec 20 Jan 21 Feb 21 Mar 21 Apr 21 May 21 Jun 21 Jul 21 99.3% 99.3% 99.3% 99.3% 99.4% 93.3% 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 6 of 69 Nh3Ave - Permit Limit - %Removal Bod Bod Aver - Permit Limit - %Removal 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 August 16, 2021 Regular Meeting Agenda Packet Total Suspended Solids (TSS) 1.0 1.0 1.0 1.0 .. .. .. .. .. .. .. .. .. .. .. .. 1.0 1.0 1.0 1.0 1.0 1.0 Permit Limit 12 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Jul 20 Aug 20 Sep 20 Oct 20 Nov 20 Dec 20 Jan 21 Feb 21 Mar 21 Apr 21 May 21 Jun 21 Jul 21 99.5% 99.5% 99.6% 99.6% 99.6% 99.6% 99.5% 99.5% 99.6% 99.5% 99.6% 99.4% 99.5% Nitrate - Nitrogen Permit Limit 24 4.9 4.95 4.6 4.94 5.84.90 5.8 5.0 5.8 5.1 5.8 5.1 5.6 5.25 5.55.21 5.8 5.27 5.5 5.35 5.0 5.42 5.9 5.49 4.75.48 111111111111111111 1 Jul -20 Aug -20 Sep -20 Oct -20 Nov -20 Dec -20 Jan -21 7 of 69 Feb -21 Mar -21 Apr -21 May -21 Jun -21 Jul -21 TSS TSS Ave - Permit Limit - %Removal N -N N -N Aver - Permit Limit 10 9 8 7 6 5 4 3 2 1 0 August 16, 2021 Regular Meeting Agenda Packet E. Coli Permit Limit 126 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1111 1. L I 1' 1 11111111 11 Jul -20 Aug -20 Sep -20 Oct -20 Nov -20 Permit Limit High 9 Dec -20 Jan -21 Feb -21 Mar -21 Potential for Hydrogen (pH) Apr -21 May -21 Permit Limit Low 6 Jun -21 Jul -21 7.46 7.59 7.66 7 59 7.86 7.67 7.64 -.48 7.19 7.11 7.21 7.367.21 7.21 7.25 7.36 7.35 ' 7A 7.51 7.58 6.8 6.88 7.05 7.05 7.07 7.12 7.13 7.16 7.21 7.2 7.24 1 6.7 -'14 6.92 6.72 6.96 6.96 E.531 1 Jul -20 Aug -20 Sep -20 Oct -20 Nov -20 Dec -20 Jan -21 Feb -21 Mar -21 8 of 69 Apr -21 May -21 Jun -21 Jul -21 - 1.2 - 1.0 - 0.8 - 0.6 - 0.4 - 0.2 0.0 9 8 ■ Permit Limit • E Coll • E Coli Ave. 7 •pH Min 6 5 4 3 2 1 0 • pH Max • pH Aver 1 9 8 7 6 Permit Limit Max 9 Dissolved Oxygen (DO) August 16, 2021 Regular Meeting Agenda Packet Permit Limit Min 6 7.93 7.83 7.77 7.73 7.73 7.74 7.69 7.77 7.81 7.84 7.68 7.85 7.4 Jul -20 Aug -20 Sep -20 Oct -20 Nov -20 Dec -20 Jan -21 9 of 69 Feb -21 Mar -2 Apr -21 May -21 Jun -21 Jul -21 apackamt2 skrolczyk Begin Date: 07/01/2021 End Date: 07/31/2021 Totals for Check: 7632 ::::411111P•LW 1A11114W : :i.1•1:11: • : . • • • : • : • : • : • : • : • : • • : • : : :Date.StatN• 00010110635102A 06/30/21 998 . FAJPIOUGHS, Tot6ti.feir;:thiCk: ••• • ••••••998 'Cf ilk; 4abilEL:•T:••••••••••••••••••••••••••••• Totals for Check: 7634 :1'otaLs for Check: 7635 U90123 00 0 0 0 '0 06/30/21 17003911M 06/30/21' Fran Fran Ant: Trophy Club MUD No.1 A AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 : • : • : • : • 400- :•:•:•. 998 CELPA, JOSE U90211400239014 06/30/21 P 135 -20050 - Totals for Check: 7636 •-•:•:•:•:. 998 . CRO. VAVGIV: • • : • • • : • : • Iiitilti:*01;.:010k; 7637 •••••••••••••• ..•.•.-.•.•.-.•.•........•. Totals for Check: 7638 00 000 0 0 00.0 000 708104A 06/30/21 P 135-20050-000- 8103A 06/30/21 'P''• '' 135-2 0 0 0 0 0 0 0 0 0 000 000 000 .1.1w 09141 2Q1112egular Meeting Agenda Pat 1 ...................... ..... • ..... • . • . • ... • . • • • . • .. • • . • • • • • . • • . • . . • . • .... "A8:18" 7632 07/09/21 38.78 A/P Vendors •:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: .05,48:.: . 7633 07/09/21 :•:::::•••••••••••••••••••••••••••••••••••••••••••••••••••••••:•:•:•:::::.:05.48::::. •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••:*: • .. :•••••••••••••••••••••••••••••••••••••••••••••••••••••••:•:•::::::::::::: . ::::::: ::•::•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:• 123.95 Wendors.:-..-:•••••••••••••••••••••••••••••••••••••••••••••:.:90,14.:•:-..7§3.:.07/99(31......:-:-:-:-:-:-:-:•:-••• • 90• • .•. .....•.•.•.•.•.•............... .................... • •...•.•...•...•.•.•.•.•.•.•.•. .•.•.•.•.•.•.•.•.•.• •.•.•.•.•.•.•.•.•.. •..• •.•.•.•.•.•.•.•.•.•.•.•. 08.31 08.31 A/P Vendors 123.81 7637 07/09/21 123.81 Aip vendo 18.72 998. GeftE80.8RAICK • U9012828010901A•08/88/74::::P.::::•.• 02.89 7639 07/09/21. 02.89 • : • : • : • : • : • : • : : : : : : : : : • • • . . . . . • . • ' . ' • ' . ' • . • • . • . • . • . • ' • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . . • . • . • . • . • . • . • . • . • . • . • . • . • . • ' . • . . . • . • . • . • . • . • • . • . • . • . • . • . • . • . . . . . . . . . . . . • . • . • . • . • . • . • . • . • . • . • . • . . • . • . • . • . • . • . . . . . . . . . . . . • . • . • . • . • . • . • . • . • . • . • . • . . . A A 998 GRANT; 'JARED U9022O007902A 06/30/21 P''''''135 -20050o 000 " A/P Vend:WS" " 39.28 7640 07/09/21 Totals for Check: 7640 39.28 448..j0§00i;.snins Totals for Check: 7642 10304: PAWCTA 00 000 ]35- 31:342itk 86/30/21 'P 10150 -000 000jp5293 : '.....%••• • • •••• 7642 • 00/000 :::!.1001..10.300081.88A::06130/21:•:•::P.:•:•:•:•:•.•:•2p858toppowt•:•:•:-:•:A/P. Yenclors•:-:•:•••• • • • • • • • • • • •••.• • • • • • 998 KESNER, JASON U0010070492105A 06/30/21 P ''''''1.35200 0 Totals for Check: 7644 998, . . • • • • • 998 MCCLURE, JAMES E. Totals for Check: 7646 U902327002490*. P 06/30/2021 06/30/ZI P 1J0050060530103A 720.0 •0 ,20050, 000 000 • • : : : : : : : : : •: •: •: 52.93 • • • • • • : : : : : : : . . • . • . • . • . : 07/act • • ... ......... • . 06.60 ...7644 07/09/21 ......•.•.•.•.•.• 06.60 07/09/21 : .49.43 7645 18.41 . . . . • . • . • . • . apackamt2 skrolczyk Begin Date: 07/01/2021 End Date: 07/31/2021 :•:.: l*M0eri: :•:.: :•:•:.: :•:.: : • • • • • • :•:•:•:•:. • • • • • • ••• • ••• • ••• • ••••••• 998 ROBINSON, HEATHER L. Totals for Check: 7648 998 ROMERS, NICK TOtalS: for Check: • • ' 948 STEELE, .JAY & r;t4tiGett Totals for Check: 7650 • :998: JOHN:: •• thLiek! 7651• • : %." 998 TIMIINS, NORMAN Totals for Check: 7652 • 998 WANG, YO)C1.A0 •.• Total.s for Check: 7653 998 *MIER, KELLY " " Totals for Check: 7654 Fran Ant: Date Stat No mter • . . 00020001021205A 06/30/21 • • 135-20050- 000 U9012.320002901A 06/30/21 ' :•:• '•:•:•:•:•:-:-:•:-:-:-:- • • 0:0 0 0 0 0 0 0 06/30/21..........13! 00 0 000 000- 000 000 000 110050060508108A 135-20050-000-000 : U0020001119206A 06/30/21 P 135-20050- 1.10020001173211A 06/30/21 P 135-20050- 00 0 000 000 000 000 Trophy Club MUD No.1 A AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 . . .•.•.•.•.•.•.•.•.•.• w O93 2Q012egu la r Meeting Agenda Parr 2 .................... ..... .•.•.•.•.•.•.•.• • •.•. 24.82 7648 07/09/11" 24.82 A/P Vendors :::•::•:•::•:::•::•:•::•:•::•:::::•:•:].,37:: 7649 07/09/21 : • • AA/Pyen. cjc,rs • • • 11.10 • 12.75: •••.2.75 " " " " " : :•:•:•:•:•:•: . 46.92 7652 07/09/21 46.92 A/P Vendors 19.66 19.66 WPVefldors " 25.25 25.25 7653 07/09/21 .•.•.•.•.•...•.•.•.•. .•.•.•.•.•.•.•.•.•.•.• • •7•64•••07i09i1 • • • • • • • • • • • • • • •••••••••2222:•:AF.LAC:•:•:-..--•-••••••••••••••••••••••••:-•••:-:.:FRO0727:•:•:.:•996.06/11./2.1.:-:•:P:•:-:-:•.-.-:•33521312000,000.-:•:-.....Aflac 2222 AFL 728 996 06/25 '21 P 135-21312-000000 c • •166 Totals for Check 7655 333 20 " ....•.•.•.•.•..... . . . . ............. 1030 CITY OF FORT NOM Totals for Check: 7656 • :•:•:•:•:•:•:•:•:•:•:•: :•: : :•: :•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: :•:•:•:•••••••••••••:•:-:•:•:-:•:•:• 06/30/21 06/30/21 P 10 135-60150-010- 3193 Cal,UPAY, ::::::::.31.93: ••••••••••••••••••• 3184 DATAPROSELLC" 3184 DATAPROSE LLC Totals for Check: 7659 • • • • • • • • • PR00727 ..PRO0728 " " • DP2102253 DP2102253 996 06/11/21 99606/25/21 06/30/21 06/30/21 000 :•:•:-:•:•:-: : : : : : 135,65080.40B1. • 6010i000-:. .•.• 000 Wholesale hkater •.-.•.•.-.•.•...•.•...•.•...•..•.•.-.•.•.•.•.•.•...•.....•.....•. 120,889.36 7656 07/09/21 120,889.36 0: .•••••• 54 * 1657 O1J08/2. • • '&4.06 • • P 335-21313- Cafe 125 -Medical Rajah 490.40 P::::::::::.:::I3521.313t ..... ::::::Cat.a.1.25leclical...Beinih.::::. '•:•:•:•:•:•:•:•:•:•:•:490::40. '-'-:•:-:-::::::::::::::::::::::::::::::::::: • '•:-:-:•:-:::::,•:•:-:•:::::::-:::•:-:•:-:::•:-:-...-.**•'::::::::::::::::*9;90:.t4:: •••::::::::::::::::::::::.:•:::::.::. P 3013-6063566- oo, .posta0e... 1,651.74 P 30 135-55205-030-000 Utility Billing Contract 569.44 2,221.18 • Mr 07/01i21 2611::•66Ji-tal:Atr Contro'L, Inc 2E6235 06/30/21. 1' 3 1.35-60235-030-0 T6t.t.§ for CheCk! • •itrio • 000 . ...•.•.•.•.•.•.•.•.•.•. . Chemicals 7658 07/09/21 7658 07/09/21 7659 .07/09/21. 7659 07/09/21 2400 756() 07/09/21 •••••••••••••••••••••••••• .•.•.•.•.•.•.•.• .•.•.•.•.•.•.•.•.• :•:•:• :•:• . . .'.•.'.•. . . . .•.•.•.•. apackamt2 skrolczyk Begin Date: 07/01/2021 End Date: 07/31/2021 • ••• • • • • 2606 Fisery Solutions, LLC Totals for Check: 7662 Halff .AssOCiate?.. ••••••.:.•: • • • 3124•IkS.Tai'PaYiiient% 3124 IRS Tax Payment Fran Ant: 91928668 07/06/21 • **P 30 135-.00,0-030- 0054947 . . PR00727 PR00727 3124 IRS Tax Parent PR00727 3124 IRS Tax Paynient: • • TaxIRS : PO*** .PR00728 Tota3 :fOr Check: 7664 2943 JFMORGAN CHASE BAN( NA 06282021 2943 JECIORGAN CHASE BAN( NA 06282021 ::•:•:•Tat.als for Check: 7665 07/07/21 P 10 335-55080-010- 446.661h1 •Ii• • •• • .135213020.00. 996 06/11/21 P 135-21303- 996 06/11/21 P 135-21364- -:•1.35213.02400000.-: ' 0 ' 0 ' :000j 06/28/21 P 06/28/21 P 0 0 0 0 0 0 Trophy Club RD No.1 A AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 ••••••:1F,•••TP1911::::::::*•-•-•-•-• •-•-• -•-• ••••••••••••.-.• Service Charges & Fees • " " " " • " maintenance 4 Regal -Ts 09141 2Q011Begular Meeting Agenda Parr 3 ..... . . . . . . . . •:•:::::::• 5000 766207/09/21 50.00 ••••••••••••••••:.:•:.:•:•:.: : • • • Social Security Taxes 6,362.46 7664 07/09/21 Medicare Taxes 1,488.00 7664 07/09/21 • • ••••:-:•:-:-:-:-:-:-:-:•: " •-•.-:-: SO.a Seurttf Taxes 6,333 26 7664 07/09/21 Taxes : : : : : .•... .•.•.•...•.•. . • " • " 25,875:56" 135-20060-000-000 Procurement Clearing 7,263.15 7665 07/09/21 533-20060-000-000 Procurement Clearing 339.20 7665 07/09/21 7,402.35 31.67 •KEYST�E PARK 170125 """"07/08/21 P 30 135 - Totals for Check: 7666 .000 0 0 0 00 :::::::-:•$1-12:::149211-:•Sh1-014 • • • •••••:••::::••••• 6• • • • • • • 99P:136/4/4••••:::Ii::::::::::::".•05131.0°000 Legal Plai • ••••::•••••••••••••• .••••••••:•:•:•:•:•:•:••••••••••••• ••••••••••••••••••••••••••••••• •.• • r•••••••••••••••:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:••.• Tot&.s for Check 7667 • •.- • • ••• 2754 LOWER COLORADO RIVER AUTHORITY LAB -0051388 Totals for Check: 7668 : : : : : : : : : : : : : : : : : : : : : :•:•: :• •• : : : : : :•totits: for heck 1€€9 3156 OXIDOR LABORATORIES LLC Totals for Check: 7670 . • • • • • • Totats for heck 7671 06/30/21 P 10 135-55135-010-000 Lab Analysis 70050507001 04/24/21... 21070027 3176 REY-MAR CONSTRUCTION PAY APP 4 Totals for Check: 7672 • •• • • • • • • • PR00727 996 06/11/Zi: 3113 TWS• • 06/25,21 " • tOi.;41:§•••frie Check: 7673............ •:•:•:•:•:•:•:•:•:•:•:•:• •••••.•.•.•.•.•.•.•.• • 07/01/21 P 20 135-55135-020- /08 •.•..•.•.. 0 0 0 •.. • .• • .. • • ••.•..•••... ...•.•.•.•.•.•.•.•.•.•.•.•.. 06/30/21 P 10 135 -69005 -010 - :135 -i21317 -o ..•.•.•.•.•.•.•.•.•.•.•.•. 0 0 0 Lab Analysis 25.00 17 44 7667 07/09/21 3490 • 213.92 7668 07/09/21 213.92 . .. • ... . :•:07 . •.'.•.. 259.90 7670 07/09/21 259.90 • . : : : : : : : 7 : : : : : : Capital Outlays 78,133.50 7672 07/09/21 78,133.50 3:•:07/09/23;::: Service Charges & Fees • • • • • • • •.•..... ....•.•.•.•. apackomt2 skrolczyk Begin Date: 07/01/2021 End Date: 07/31/2021 : NUN'. • :• : •: • .2781 ftico Industrles- Totals for Check: 7675 Fran Ant: : • . : •::: 71667509 06/17/21 P 20 135-55080-020- : ". :1.000 : :1IY CL.W PIJD: (iPfk:1131BILLS) 06/30/2021, ..Valle4,rSolvent Company, INC 72359 2634 Valley Solvent CognsTy, INC 72359 Totals for Check: 7678 0 0 0 Trophy Club MUD No.1 A AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 • -• • • -• •:• • .• ".• :• • • :• • :•. . Maintenance & Repairs I tw 09141. 2Q113aBegu la r Meeting Agenda Parr 4 •va ••:.• '''' ............. 1641-44 7675.07/09/21 1,641.44 135 -25048 -:..:Tow -Storni Drainage : :•:••••••••••••••••••••••••••36 291 02•••••• 7676..07/09/21. • • • • • • • • • o o o 0 : 135-27 - 07/09/21 000 000 o o o 1.35-25010-0o -GOO. Refuse Tax 6,738 86 7676 07/09/21 •45: 122-60337-045- : 000 192,764.06 -.•.• -.••.•.•.• • • • • ....•...•...•.. 06/15/21* P " 10 "135-65030010-- 0 0 0 " Chemicals 06/15/21 P 10 135-65030-010-0oo Chemicals • ::1.15*,!60265010 0_. • • • 2Ei(i• loikft LLt• • • • • •titOg• • • • • • • • 01/0iiti• • • ii• • • 10. • 7.35662.8Sci30 .0 0 • • • Equtflent&Mai.ntenaiTotal.s for Check: 7679 •:- 99607104/21-:•.•. : • • •§cieT .••••: .•••:.1357213127 Aflac 2222000000 Aflac •!°.•••• • •r7L. : : • 2772 Allied Waste Industries 0615-001032263 06/30/21 P Totals for Check: 7681 20 135-55125-020- 0 0 0 • ...:.:::07/070021:::::::::::07/0712.1:-: . *,!50C99.4010,! 3397 BeneflfU 07/07/2021 Ol/Ornl 20 135-50029-020-000 " " • 3197 13eriefilflaill " " " " " " • " 07/07/2021 " 07/0/21" • P" 30 135 -50029 -030 - Totals for Check: 7682 0 0 0 Duipster Services • :• : :• :• :• r••••• • • • 'Life InUranCe'&10fhe'i.:.:•:.:.:.:.:.:. •:•::•••• 472'08 7678 07/09/21 40.00 7678 07/09/21 512.08 600.00 7679 07/09/21 770.00 7679 07/09/21 .• .• • • • •.• • " 469.67 7679 07/09/21 1,839.67 7680 07/27/21 166.60:: 7680 07/27/21 •.• • 5,469.36 7681 07/27/21 5,469.36 * 64.00 .•.•.•.•.•.•.•. . . .'.•.'.•. ::::::-:•2683:. :Charter: Conrueications::•:•:•::::::: -. 7 .,q?o.7..of)?; • : • : • :-.. :wow. 4 .: • :P:•:•:-*30.•:•1355503003&000-•••••••••Sofbrare.&•Suppprt.•••••••••••••••••••••••••••••••••••........899-,99.:*•*:.• 683:.:07/27.*: :::::::ti,4.;i1.;i.:Efor.:4;Iiiiki•••:::•:Ekb::::::::::.:::::::::::::::::::::::::::::::•:•:::::::::::-:-:-:-:-:-:-:-::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::••••••••••••••••••••••::':::*:•:*:•:.:*::::::::::::::::::::::::::::::::*:*:*:*:Rone• 7*.*••••:*"..-.-- ::•.*. .....:.::::::::•::•:::::::•:"::::.:::•::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::.::::::::::::::......................:::.:::::: ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::•::•::::.]::::::::::::::::::::::::::::::::::::::::::::::-:-.-.-..... • • • • • 1030 Cit.e.)0 taFit.vbitrii.•.....'...............6/36t2iiriFiAt-r...bii202i..-01.........*:*:itioiiii:0 0 000 ........ .. ........:*.0.6t.'iii6.1...14iii. 6. .e,i1.1.1.3.&i. Fees ........70,33000 ' -.i.t....ii......:iiilifZi::::::::::::::::::::::::::::::.:::::::::::::*:**::.::::*:::::::::::::::::::::::* 0 Totals for Check: 7684 70,330.00 :Connunity:National:Title:LLC-x:PARCEL:4:::.: 07/16/21 P 10 520 -69005 -010 -000.:::::::.:pvital:Ou4ws: , -• 9 • 07/16/21 0 0 520-69005-010- **: WEIS:Outl.ays• : : : : : :1 065 00: : l'otals for theck 7685 2,137 67 : ........ .............. ......................................................................................... 0 0 0 0 0 0 0 0 0 000 Cafe 125 -Medical Reimb Cafe 125 -Medical Reinb . .•.•.•.•. apackamt2 skrolczyk Begin Date: 07/01/2021 End Date: 07/31/2021 ••••••••••677 gitaI Atr Corrtroi., Inc Totals for Check: 7687 ••••:: : • • • : : • • •:•.• .•.•.•.•. .• • • . 2056347 07/18/11" 36 135-60135-030-000 'Securtty-- Fran Put: •••••••• •• •:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: :•:•:•:•:•:•:•:•:•:•:•:•:• Trophy Club MUD No.1 A AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 09141 2Q1112egu la r Meeting Agenda PaRiget 5 . .. ..., . Value ither• •: •• •. :• ••.• •.•.• . . . ... ... . . • • ..... . 24.00 7687 07/27/21 24.00 •::•;,•,1737 DPC DEUS-FRIES, :•:•:•:•:•: : . 767003416-21 07/21/21: : P 10 135-65030-010-000 ChenliCal;s • • • • • • • • • • • • • • • • • • • 157 51 7688 07/27/21' • • • • • • • • • • • • • • • • • • • • • • • • • • .......... 7689 1832FIRST FINANCIAL BANK " 1832 FIRST FINANCIAL BN1( 1832 FIRST FINANCIAL BANK FIRST FINANCIAL BNI(..:•:•:•:•:-: :::104S.for Check: 7689 2635 Halff Associates, INC 2635 Halff Associates, INC 2635 Halff Associates, INC •:::•:• : 2635 : Haff 2635 HaLff Associ.ateS, DIC " • Total -kW CheCk! " 7690' " " • ' " 3372 HA01 OIPPNY •.• ••• • • • • • ••••••••••••••••••••:-:::15551.8855::: • P : " 155516853" 07/13/21 P " 3.35-21309- - " 355516853 07/13/21 P 135-21311- - Voluntary Life 155516853 07/13/21 P 10 135-50029-010- Life Insurance & Other 355518853 .. 07/13/21 P . 20. .135750029-020- .... 155516853 07/13/21 P::::::30::'.335•,.50029-030- . Imo -62i'87/16/21.'4'.••••i0"..1.3866009020006•• • ••81•iiiii-t.feiiii:iiiii.iiiii.:.:.:.•••••••••••••••••••• ...... 9 0000 -821 07/19/21 P 20 135-69008-020-000 Short Tem Debt -Principal 9 0000- '1-821 07/19/21 P 10 135-69009-010-000 Short Tem Debt -Interest : 93500005391-821 07/19/21% .P: :-.-20 3.35-69009-020-000 Short Tenn Debt -Interest-.-: •-::: •-• • • ::: • • • • • 10055423 —07/14/21"1'" 10 135-69005-010-000 " Capital Outlays -- 10055423 07/14/21 P 20 135-69005-020-000 Capital Outlays 10055465 07/14/21 P 30 135-55030-030-000 Software & Support 10055424 07/14/21 P 10.1357690057010-70.60::.:-.-:•:ciTital .Outlays, *:"••10055612::::::•::::01402.1.:•••:::0 • •.....•20..• • 7020-000 TCEQ: .... . . . 32538848 07/08/21 P 10 135-65030-010-000 Chemicals its 2676 HUnaiaint ' 2676 Humana Inc 2676 Humana Inc Hummainc...x.x. .•.•.•.•.•.•.•.•.•.•.•.•.•.•...•.•...•.•...•.•..•.•.•.'.•.'.'.•.'.'.•.'.' 00'0 000 000 000 000 000 000 . . ....•.•.•.•.•.•.•.-.•..-..... ...-.•.•.•.•.-.-.•.-.•.•.-.•.-.-.•.-.•.•.-.•.•.-.•.•.•.•.•.•.•.. 2775 HUDSON ENERGY SERVICES, LLC 52107 0001-17 07/15/21 P 30 135-60020-030- 2775 HUDSON ENERGY SERVICES, LLC 52107 0001-17 07/15/21 P 10 135-60020-010- Totals for Check: 7694 000 000 000 :::•:- -3324 IRS•T:POY.drn:t:::::::::::::::::::::::::::::PRO0729:::: :.: : 996: 67109/23.::::: P:•:::•:•:::•••13521302,000 334::ii/i5.21-*:t4$006t::::::::::::::::*0720:•:•:•:•69.6:7/00/.21:::::iFi•::::::::::::i:1.352136:3410.006.6. 3124 Itt5Tak'Paynri0:::*.::*.:•.:::::•:• PRO0129::.:H.:E688:67/09/4.::.::::0::::::::::::::33521304 .. . : : : : : : : : : : _ __ ... __... • • • 3124 IRS Tax Paynant• • • • • • • • • • • • • • PRO0731. • • • 996 ci7t2E/21 ... P • • • ' ' 135-21302- .. 000 PR00731 996 07/23/21 P 135-21303- PR00731 996 07/23/21 P 135-21304- 000 000 000 000 000 000 000 000 . • Soctal Securtty Taxes• • ' . Social Security Taxes Medicare Taxes Electricity/Gas Electricity " Independent' LANJor • • " • " • • • 20,325.29 7689 07/27/21 923.55 7689 07/27/21 •:-.-1,224.22 7689 07/27/21 ". ••• "••.: : ••••.-:. 24,988.47 • • • 7,277.00 7690 07/27/21 5,345.00 7690 07/27/21 2,498.75 7690 07/27/21 27,330.00 .2;329.63 500.00 ' 45;280.58 7690 1,370.41 7691 07/27/21 172.26 7692 '07/27/21 366.95 7692 07/27/21 155.43 7692 07/27/21 •::175.56 •• • •:-2,97 43 1,024.61 7693 07/27/21 12,868.52 7693 07/27/21 :•:•:•:•:•:•:•••••••••••••••••••••••••••••••••••••••••••••••• coo 000.00 ....•.•.•.•. apackamt2 skrolczyk Begin Date: 07/01/2021 End Date: 07/31/2021 From ABC Trophy Club Ili) No.1 A AP Checks For DateANnount Range .00 To Amt: 99,999,999.99 4,1 ••••••::!?,••F:WP19!1::::::::*••••-••••••••'-'•*:•••::::•••• 30 133 -330.0.0030 - Maintenance &Pairs 0 0 0 000 000 0 0 0 000 Totals for Check: 7699 06/30/21 P 39 135 -55045 -039 - 06/30/21.:::P: :9::135,.55045039-700p.: 10 135-55120-010- 20 135-55120-020- 30 135-55120-030- 000 000 000 000 091/61.2Q012egular Meeting Agenda PaBiget 6 ...................... ..... r .00 • Copier Lease Installments . 7697 07/27/21... :•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:••.• • . :•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: •.•.•.•.•.•.•.•.•.•.•.•.•.•........... •.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•. Legal. Plan 17.44 7698 07/27/21 34.90 • • 484.00 7699 -07/27•/2I•:•:•:•:•:•:•:•:•:•: 450.00 7699 .....••- •• •. Legal Legal 2,990.00 7700 07/27/21 1,125.00 7700 07/27/21 4,115.00 ............. • • • 87.50 • • '7701 • 0//17./21 • ••••••••••••••••••• ••••• 87.50 7701 07/27/21 869.06 7701 07/27/21 3115 IETLIFE GROUP BENEFITS .......08012021 •07/15/21 20 335-50029-020-000 " Life Insuraike & Mbar 165.40 770207/27/21" " " ' • " • " 3115 I€TLIFE GROUP BENEFITS 08012021 07/15/21 P 30 135-50029-030- 3115 IETLIFE GROUP BENEFITS 08012021 :•0 0 0 1 181774594001 07/15/21 P 135-21315- 000 0 0 0 000 .•.•.•.•.•.•. 06/29/21 P 30 135-65085-030- 07/12/21 P 30 135-65095-030- 000 000 -2100122 ...07/07/21 20 135-55135-020- oaa 21060542 06/30/21 P 20 135 -55135 -020 - 21070306 07/15/21 P 20 135-55135-020- 000 000 Life Insurance & Other Short Tenn Disability • •.•.•...•.•.•.•.•.•.•.•.•.•.•.•..•.•.•.•.•.•.•.•.•.•. ........•.•.•.•.•...•.•...•.•.•.•...•.•...•.•...•...•.•.•.•.• :•:•:21070231 .•:•:•:•:67/14/21•:•:11:•:•:•20....135.,55135,620,000-:•:. ............. Office Supplies Maintenance Supplies ............. : 182.22 7702 07/27/21 85.46 7702 07/27/21 175.00 519.54 7705 07/27/21 71.12 7705 07/27/21 lab Analysis • ::::::::::::: : Lab Analysis • • • • • • • • • • • • • • 259.90 7706 07a7/21 • • Lab Analysis 368.00 7706 07/27/21 Lab Analysis 259.90 7706 07/27/21 ....Lab Analysts•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: :Lab AndLym.-:-: .368.00 .•.•.•.•.•.•.•.•.• ....•.•.•.•. apackant2 skrolczyk Begin Date: 07/01/2021 End Date: 07/31/2021 From Amt: ::•:•:•:. . . . . Trophy Club MJD No.1 A AP Checks For DateAknount Range .00 To Amt: 99,999,999.99 Date. Stat No Number : :•:•:•:•. • ......... 3156 OXIDOR LABORATORIES LLC " 21070440 07/22/21" P 20 135-55135-020- "" Lab Analysig""" Totals for Check: 7706 000 .14:g 09141.2Q1112egular Meeting Agenda Pat 7 •••••so'.41"••••••4.(!v!!$•••:•:•••:•••••:. ' ••••259'.9.0••••• 770607/27/21 2,251.70 . . 31.34, Prune 07/20/21 . P . 20 . .135755080-.0207000 : • :•:. Maintenan.ce. 4:Repairs. 000 Totals for Check: 7708 1,534.00 CRUTION:::::-:::::::::::::FArpFl:*:—:•:,..07/19/7.1.:-:,.:132/.-:-:10.:13509005,010'000%.CapitLOutJays•7709 07/21/21 . • • • • .... • • ••••••••":•:::••• • Totais for Check 7709 ............ ...................................... 440 34 • • • • 2440 TARRANT CTY PUBLIC HEALTH LAB 35381 '06/30/21"0'"10"135-55135010-001—"Lcib"AnnlYiOr'FIO"'"'"""80.00 7710 07/27/21 — 2440 TARRANT CTY PUBLIC HEALTH LAB 35380 Totals for Check: 7710 06/30/21 P 10 135-55135-010-000 Lab Analysis 240.00 7710 07/27/21 320.00 • ••••.•.•••.••••••••••• • . •.• • • ••• • • •••• • . • • . • • • • •••••••• • • • • • • • • • • • • • • • • • • • • .. • • • • ..•.• „ •3113 TQES PR00729 996 07/09/21. P 135-21317-000-::: T 8.45890 7711 07,27/21 ...... . . • ••• 1081 TRI COUNTY ELECTRIC 78767881 07/07/21 P 20 135 -.00),o -020-00o Electricity 583.15 7712 07/27/21 2576 ,.tma STATES mstir': : • • " 2576 • UNITED STATES 'TREASURY- " " F7202021" " ' • '07/23/21 " 13 " 20 "135-50026021/-000 " " MediCal: •IntUranCe " " • ' • " • " " " " 26:79 77L3"07/27/21" ' " • " • ' • • ' • " • ' • • ' • " • ' • Medical Insurance 2576 UNITED STATES TREASURY F720-2021 07/23/21 P 30 135 -50026 -030 - Totals for Check: 7713 3225:::11S: Bank Voyager FI.eet::SyStenis .07/24/21 3225 L Vpyaijer'Fleet:SySten*:. 869338111240:::: -:•: 000 26.78 7713 07/27/21 80.36 135-65005410- ••••••••••Fiiel'&' '' •:•:•:•:•:•:•:•:•:•:•:•:• 000 .• •. .•.•.-.-..........- ...................... 435 65005026,000::::::::::PUet:SCLobe 560:41 " 2;013:65 • • 2634 Valley Solvent Canpany, INC 73845 07/20/21 P 20 135-65030-020-000 Chemicals 821.00 7715 07/27/21 " ••• ......... ............. • • • • • • • • ........ • . • • • • •••••••••••• • .... • • ...... • • . • 1058 VERIZON WIRELESS Totals for Check: 7716 9883051129 07/01/21 P 20 135-60010-020-000 . . . .::::::.-399:23 7716 07/27/21 751.78 000 000 000 . • • ••••.. : : • : : : : : : : : : : : • : : : : : : : : '-'• • 542.59 493.60 1,036.19 Lb SjJL Lab Supplies ..•.•. :7717.:::07/30/4 •:•:•:•:•:•:-:::::::::-:•: 7718 07/30/21 7718 07/30/21 ....•.•.•.•. apackaut2 skrolczyk Trophy Club MJD No.1 A Begin Date: 07/01/2021 End Date: 07/31/2021 2021-0796 Fran Ant: . .... . . . .•.•.•.•.•.•.•.• 07/19/21 P 10 135-55080-010- AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 w 091412Q012egular Meeting Agenda Pat 8 "LUIJ1.. . ......... . . . . ....... . . . ••••:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: Valae:•:.:•: : • •:.: :.:.:.:.:.:.:.:.:.:.:.:.:. . . . . 000 6;851:11 Maintenance & Repairs 3,850.00 Grand Totals: 982,086.15 •:•:•:•:•:•:•:•:•:•:•:•:•:•:•: • * End of Report 7720 07/30/21 07210/21, ••:•:•:•••••••••••.•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•• • • • ••:•:•:•:•:•:•:•••• ••••:•••••••••••.•:•:•: .•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•. • • • . . . . :.:.:.:.: :.:.::-. : : : :-:•:•:•:•:•:•:- : : : : : : • • • :•:•:•:•:- • • • • : ••••:•::::::::::::::::::::::::::: ."-*. • .• ••:•:•:•••••••••••.•:•:•: • • ••••••.•: •:•:•:•:•:•:•:• . .•.•.•.•.•.•.• .•.•.•.•.•.•.•.•.• • •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••.....•••••••••••••••••••••••••••••••••••••••••••.........••••••••••••••••••••••••••• • ••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• . . . . . . . . . . . . ........ • • • . . . . . .'.'.'.'.'.'.'.'. . . . . . . . . . . .'.'.'.'. ••••••••.••••:••.••••:••.....X. ••••••••••:•:•:•:•:•:•:•:•:•:•:•:•: . . . . . . ............. .............. • • • • - • • • • • • • • • • • • • - - • - • • . ......... . . . ............ • - • •• . . ................... . . . . . ............... . . . . . ............... . . . . . ............... . ................... . . . . ......... .................. . . . . . ............. . . . ................. . . . . . ............... . . . . . ............... . . . . . . ............... . . . . . ............... . • • • • • •••••••••••••••••••... • • • • • • •• • • • • • • • . . . . . ........ .......... .............. . . ............ .............. ................... . . . . . . . . ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections Connections Active Residential Active Commercial Active Residential Active Commercial MUD PID MUD MUD PID PID August 16, 2021 Regular Meeting Agenda Packet July Utility Billing Report Fiscal Year 2020 - 2021 July August September October November December January February March April May June July 2020 2020 2020 2020 2020 2020 2021 2021 2021 2021 2021 2021 2021 995 1004 1015 1031 1055 1065 1084 1085 1095 1129 1141 1155 1184 3841 3882 3932 3921 3902 3884 3896 3888 3890 3875 3869 3881 3882 653 650 648 651 649 653 645 653 660 663 667 668 664 1239 1258 1278 1282 1297 1302 1319 1330 1331 1331 1357 1362 1376 1,144 1,203 1201 1258 1188 1234 1205 1124 1,211 1,185 1,201 1,206 1,190 419" 479" 423 442 380 329 369 358" 309 332 387 345 345 0* 0* 0* 39 25 20 13 26 0** 17 23 15 25 3392 3392 3393 3393 3393 3393 3393 3393 3393 3393 3393 3397 3397 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 - 3114 3113 3112 3114 3111 3117 3109 - - 251 253 253 253 253 255 255 1405 1406 1404 1406 1405 1405 1404 37 37 37 37 37 37 37 Date of Permit Permit No. Total $ A In response to COVID-19 the District has suspended Late Notices * In response to COVID-19 the District has suspended Disconnects AA In response to extreme weather the District has suspended Late Notices ** In response to extreme weather the District has suspended Disconnects Customer Due to FW Deposit Water July Permits Fiscal Year 2021 Oversize Plumbing Sewer Meter Inspections Inspections 18 of 69 $ - $ Fire Line Misc. Income Total $ $ CASH STATUS AS OF JULY 2021 135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating *** 135-10300 Prosperity Bank (XXX8701) General Fund Operating 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) 135-11100 Petty Cash Administration 135-11150 Petty Cash Utility Billing 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement 517-10250 TexPool Construction Tax (X)XXX011) WWTP Improvements 517-10300 Prosperity Bank Construction WWTP Improvements 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 520-11155 Cash -Bond Escrow Bank of Texas (Water & Waste Water Systems) 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements 533-10250 TexPool Tax I & S (XXXXX0003) 533-10300 Prosperity Bank (XXX8701) Tax I&S 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems Amount available in cash (MUD Accounts) Amount available for spending (MUD Accounts) *07/31/2021 Customer Water Deposits $312,280 Fire Department Cash 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash 122-10300 Prosperity Bank (XXX8701) Fire Operating Amount available in cash (Fire Department Accounts) Amount available for spending (Fire Department Accounts) Total General Fund 135 Available for Spending General Fund 135 Fund Balances Nonspendable Fund Balance (Prepaids) Assigned Fund Balance (FY2020 Capital Projects plus prior year carry forward) Unassigned Fund Balance Current Year Revenue/Expenses Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 19 of 69 August 16, 2021 Regular Meeting Agenda Packet Restricted - Unable to be spent $0 $312,280 $1,999,887 $0 $0 $2,007,484 $0 $0 $0 $785,029 $157,455 $15 $3,892,831 $894,274 $923,901 $0 $471,850 $225,243 $233,102 $11,903,351 1 so $0 Unrestricted - Available for spending $4,501,328 $2,278,225 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,780,153 1 $0 1 $6,780,153 $6,780,153 $835,426 $0 $835,426 l $835,426 $835,426 Total in Accounts (Restricted & Unrestricted) $4,501,328 $2,590,505 $1,999,887 $150 $450 $2,007,484 $0 $0 $0 $785,029 $157,455 $15 $3,892,831 $894,274 $923,901 $0 $471,850 $225,243 $233,102 $18,683,504 General Fund 135 Available 2,278,225 Prosperity General Fund 4,501,328 Texpool General Fund 600 Petty Cash 6,780,153 3,486 1,518,116 7,651,523 461,673 $9,634,798 $835,426 $0 $835,426 August 16, 2021 Regular Meeting Agenda Packet FY 2021 General Fund YTD Budget Variance 135-40002-000-000 135-40015-000-000 135-40025-000-000 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 135-48010-000-000 135-49000-000-000 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49035-000-000 135-49036-000-000 135-49005-000-000 135-49075-000-000 135-49141-000-000 135-49145-000-000 135-49900-000-000 135-49901-000-000 135-49903-000-000 135-00000-000-000 Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges (Disconnect Fees) Plumbing Inspections Sewer Inspections TCCC Effluent Charges Utility Fees Capital Lease- Other Fin Sources Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Loan Proceeds Oversize Meter Reimbursement Interfund Transfer In Intergov Transfer In Miscellaneous Income Records Management Revenue Recovery of Prior Year Expense Reimbursement (Total 300 547 (29) 518 94.76% 300 367 108 475 129.33% 163,725 163,725 0.00% 5,932,489 5,639,480 650,853 4,194,922 74.38% 3,677,146 3,560,000 324,097 2,920,089 82.02% 112,608 74,000 9,671 63,137 85.32% 16,550 11,500 1,325 10,025 87.17% 750 300 300 100.00% 2,500 100 100 100.00% 50,000 42,000 15,758 46,310 110.26% 0.00% 0.00% 100,000 18,090 1,410 15,747 87.05% 14,146 14,146 1,179 11,788 83.33% - - - 0.00% 5,000 19,575 19,575 100.00% 0.00% 0.00% 0.00% 8,232 4,407 4,407 100.00% 0.00% 0.00% 7,000 18,488 249 18,736 101.35% 0.00% 0.00% 0.00% 10,227,277 I 9,703,255 I 1,005,731 I 7,440,355 29 (108) 163,725 1,444,558 639,911 10,863 1,475 (4,310) 2,343 2,358 (249) 76.68% 2,262,900 Water 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 135-55005-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 135-55135-010-001 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60135-010-001 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 135-60360-010-000 135-65005-010-000 135-65010-010-000 'General Fund Expenses Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Maintenance & Repairs Generator Maintenance & Repairs Vehicle Maintenance Maintenance -Heavy Equipment Cleaning Services Lab Analysis - MUD Lab Analysis - PID Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits - MUD TCEQ Fees & Permits - PID Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out- Revenue l&S Interfund Transfer Out- Bond Reserve Interfund Transfer Out -Bank Reserve Account Furniture/Equipment < $5000 Fuel & Lube Uniforms 365,309 17,000 5,435 6,000 36,520 86,182 4,933 789 3,289 24,412 5,709 1,080 10,877 400 300 20,000 124,000 96,000 3,000 2,000 5,000 7,657 3,500 3,500 1,000 1,000 7,500 7,500 2,000 2,000 7,500 7,500 123,487 123,487 1,000 1,366 500 500 7,426 2,500 400 400 2,875 500 1,500 30,000 30,000 2,596,295 2,316,841 200 - 3,000 1,000 14,750 10,000 565,820 565,820 75,000 75,000 2,500 383 15,000 15,000 20 611 3,500 358,000 24,000 5,435 3,025 36,520 65,000 4,000 580 3,800 24,412 5,709 1,200 12,500 400 300 26,580 285,140 79.65% 1,415 19,646 81.86% 5,435 100.00% 250 2,525 83.47% 2,621 30,683 84.02% 5,078 53,616 82.49% 312 3,252 81.29% 45 479 82.50% 289 3,219 84.72% 1,742 19,169 78.52% 407 4,483 78.52% 756 1,671 139.25% 901 10,697 85.58% 0.00% 103 34.38% 0.00% 12,661 69,730 72.64% 0.00% 80 7,737 101.04% 1,114 31.83% 88 788 78.75% 240 3,041 40.54% 80 1,593 79.66% 354 3,876 51.68% 12,869 97,775 79.18% 1,366 100.00% 0.00% 111 1,986 79.44% 105 26.25% 0.00% 0.00% 24,018 80.06% 0.00% 189,064 1,320,740 57.01% 0.00% 140 140 14.00% 1,200 7,500 75.00% 51,438 514,381 90.91% 0.00% 0.00% 383 100.00% 1,453 11,894 79.29% 2,966 84.75% 72,860 4,354 500 5,837 11,384 748 101 581 5,244 1,226 (471) 1,803 400 197 26,270 2,000 (80) 2,386 213 4,459 407 3,624 25,713 500 514 295 500 5,982 996,101 860 2,500 51,438 75,000 3,106 534 Description FY 2021 Adopted Amended Budget July Totals YTD Total 7/31/2021 YTD % Budget (83% Target) Remaining Budget General Fund Revenues i i 135-40000-000-000 Property Taxes 136,531 136,531 1,110 134,226 98.31% 2,305 135-40002-000-000 135-40015-000-000 135-40025-000-000 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 135-48010-000-000 135-49000-000-000 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49035-000-000 135-49036-000-000 135-49005-000-000 135-49075-000-000 135-49141-000-000 135-49145-000-000 135-49900-000-000 135-49901-000-000 135-49903-000-000 135-00000-000-000 Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges (Disconnect Fees) Plumbing Inspections Sewer Inspections TCCC Effluent Charges Utility Fees Capital Lease- Other Fin Sources Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Loan Proceeds Oversize Meter Reimbursement Interfund Transfer In Intergov Transfer In Miscellaneous Income Records Management Revenue Recovery of Prior Year Expense Reimbursement (Total 300 547 (29) 518 94.76% 300 367 108 475 129.33% 163,725 163,725 0.00% 5,932,489 5,639,480 650,853 4,194,922 74.38% 3,677,146 3,560,000 324,097 2,920,089 82.02% 112,608 74,000 9,671 63,137 85.32% 16,550 11,500 1,325 10,025 87.17% 750 300 300 100.00% 2,500 100 100 100.00% 50,000 42,000 15,758 46,310 110.26% 0.00% 0.00% 100,000 18,090 1,410 15,747 87.05% 14,146 14,146 1,179 11,788 83.33% - - - 0.00% 5,000 19,575 19,575 100.00% 0.00% 0.00% 0.00% 8,232 4,407 4,407 100.00% 0.00% 0.00% 7,000 18,488 249 18,736 101.35% 0.00% 0.00% 0.00% 10,227,277 I 9,703,255 I 1,005,731 I 7,440,355 29 (108) 163,725 1,444,558 639,911 10,863 1,475 (4,310) 2,343 2,358 (249) 76.68% 2,262,900 Water 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 135-55005-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 135-55135-010-001 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60135-010-001 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 135-60360-010-000 135-65005-010-000 135-65010-010-000 'General Fund Expenses Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Maintenance & Repairs Generator Maintenance & Repairs Vehicle Maintenance Maintenance -Heavy Equipment Cleaning Services Lab Analysis - MUD Lab Analysis - PID Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits - MUD TCEQ Fees & Permits - PID Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out- Revenue l&S Interfund Transfer Out- Bond Reserve Interfund Transfer Out -Bank Reserve Account Furniture/Equipment < $5000 Fuel & Lube Uniforms 365,309 17,000 5,435 6,000 36,520 86,182 4,933 789 3,289 24,412 5,709 1,080 10,877 400 300 20,000 124,000 96,000 3,000 2,000 5,000 7,657 3,500 3,500 1,000 1,000 7,500 7,500 2,000 2,000 7,500 7,500 123,487 123,487 1,000 1,366 500 500 7,426 2,500 400 400 2,875 500 1,500 30,000 30,000 2,596,295 2,316,841 200 - 3,000 1,000 14,750 10,000 565,820 565,820 75,000 75,000 2,500 383 15,000 15,000 20 611 3,500 358,000 24,000 5,435 3,025 36,520 65,000 4,000 580 3,800 24,412 5,709 1,200 12,500 400 300 26,580 285,140 79.65% 1,415 19,646 81.86% 5,435 100.00% 250 2,525 83.47% 2,621 30,683 84.02% 5,078 53,616 82.49% 312 3,252 81.29% 45 479 82.50% 289 3,219 84.72% 1,742 19,169 78.52% 407 4,483 78.52% 756 1,671 139.25% 901 10,697 85.58% 0.00% 103 34.38% 0.00% 12,661 69,730 72.64% 0.00% 80 7,737 101.04% 1,114 31.83% 88 788 78.75% 240 3,041 40.54% 80 1,593 79.66% 354 3,876 51.68% 12,869 97,775 79.18% 1,366 100.00% 0.00% 111 1,986 79.44% 105 26.25% 0.00% 0.00% 24,018 80.06% 0.00% 189,064 1,320,740 57.01% 0.00% 140 140 14.00% 1,200 7,500 75.00% 51,438 514,381 90.91% 0.00% 0.00% 383 100.00% 1,453 11,894 79.29% 2,966 84.75% 72,860 4,354 500 5,837 11,384 748 101 581 5,244 1,226 (471) 1,803 400 197 26,270 2,000 (80) 2,386 213 4,459 407 3,624 25,713 500 514 295 500 5,982 996,101 860 2,500 51,438 75,000 3,106 534 Account 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 135-70040-010-000 Wastewater 135-50005-020-000 135-50010-020-000 135-50016-020-000 135-50017-020-000 135-50020-020-000 135-50026-020-000 135-50027-020-000 135-50028-020-000 135-50029-020-000 135-50030-020-000 135-50035-020-000 135-50040-020-000 135-50045-020-000 135-50060-020-000 135-50070-020-000 135-55005-020-000 135-55070-020-000 135-55080-020-000 135-55081-020-000 135-55085-020-000 135-55090-020-000 135-55091-020-000 135-55105-020-000 135-55120-020-000 135-55125-020-000 135-55135-020-000 135-60010-020-000 135-60020-020-000 135-60066-020-000 135-60070-020-000 135-60080-020-000 135-60090-020-000 135-60100-020-000 135-60105-020-000 135-60125-020-000 135-60135-020-000 135-60245-020-000 135-60280-020-000 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65031-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 135-70020-020 Board of Directors 135-50005-026-000 135-50030-026-000 135-50035-026-000 135-55040-026-000 Description Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Bond Related Expenses 'Subtotal Water August 16, 2021 Regular Meeting Agenda Packet FY 2021 Adopted Amended Budget July Totals YTD Total 7/31/2021 YTD % Budget (83% Target) Remaining Budget Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Independent Labor Maintenance & Repairs- WWTP Maintenance & Repairs- Collections Generator Maintenance & Repairs Vehicle Maintenance- WWTP Vehicle Maintenance- Collections Maintenance -Heavy Equipment Cleaning Services Dumpster Services Lab Analysis Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment Advertising TCEQ Fees & Permits Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out- Revenue I&S Interfund Transfer Out -Bond Reserve Interfund Transfer Out -Bank Reserve Account Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals- WWTP Chemicals- Collections Small Tools Safety Equipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Capital Lease Issuance Cost 'Subtotal Wastewater 1 Salaries & Wages Social Security Taxes Medicare Taxes Unemployment Taxes 25,000 25,000 2,528 21,045 84.18% 3,955 1,200 1,200 0.00% 1,200 1,000 1,000 0.00% 1,000 70,000 10,000 9,287 92.87% 713 87,000 87,000 86,625 99.57% 375 740,000 835,000 78,047 663,682 79.48% 171,318 30,962 30,962 30,962 100.00% (0) 2,324 2,324 924 2,314 99.57% 10 75,000 75,000 75,000 100.00% - 108,000 108,000 106,707 98.80% 1,293 - - 0.00% - 5,327,165' 4,993,821 1 391,672 1 3,506,871 1 70.22% 1 1,486,949 I I 1 1 1 I 483,633 465,000 33,705 368,355 79.22% 96,645 33,000 33,000 2,001 26,237 79.51% 6,763 7,420 7,420 7,420 100.00% - 8,100 8,100 675 6,450 79.63% 1,650 49,358 49,358 3,376 40,119 81.28% 9,239 122,035 93,300 7,057 76,715 82.22% 16,585 6,443 5,150 392 4,233 82.20% 917 1,098 800 59 659 82.42% 141 4,725 4,725 399 4,106 86.89% 619 32,993 30,500 2,171 24,438 80.12% 6,062 7,716 7,200 508 5,715 79.38% 1,485 1,440 1,600 756 1,960 122.47% (360) 14,607 16,302 1,218 13,866 85.05% 2,436 400 400 - 0.00% 400 300 300 135 45.10% 165 30,000 0.00% - 15,000 0.00% - 108,000 85,000 5,531 70,827 83.33% 14,173 157,500 157,500 3,673 112,906 71.69% 44,594 10,000 8,000 46 46 0.58% 7,954 4,000 4,000 2,708 67.69% 1,292 13,000 8,500 6,464 76.05% 2,036 3,000 1,000 322 32.16% 678 1,500 1,000 88 788 78.75% 213 100,000 100,000 5,469 74,833 74.83% 25,167 40,000 40,000 2,252 32,643 81.61% 7,357 7,500 7,500 398 4,792 63.90% 2,708 157,735 157,735 13,397 118,953 75.41% 38,782 200 200 0.00% 200 300 300 0.00% 300 4,991 3,500 2,705 77.29% 795 1,000 1,000 0.00% 1,000 1,575 1,575 0.00% 1,575 5,000 1,200 575 47.94% 625 2,500 - 0.00% - 45,000 45,000 500 28,591 63.54% 16,409 450 0.00% - 5,000 0.00% - 14,000 10,000 1,540 8,890 88.90% 1,110 114,681 114,681 10,426 104,256 90.91% 10,426 688,005 688,005 62,546 625,459 90.91% 62,546 - - - 0.00% 75,000 75,000 38,802 51.74% 36,198 2,000 36 192 228 634.65% (192) 12,500 12,500 560 11,346 90.77% 1,154 6,280 4,500 4,168 92.62% 332 25,000 25,000 821 18,063 72.25% 6,937 17,500 6,500 4,895 75.31% 1,605 1,200 - - 0.00% - 1,200 600 252 42.00% 348 28,000 28,000 1,041 25,880 92.43% 2,120 335,000 250,500 5,345 157,803 63.00% 92,697 81,273 81,273 20,325 81,295 100.03% (22) 8,532 8,532 3,740 8,496 99.58% 36 130,000 130,000 130,000 100.00% - - - 0.00% - 3,026,6901 2,781,292 1 190,207 1 2,257,391 1 81.16% 1 523,901 0.00% 0.00% 0.00% 21 of 69 - 0.00% August 16, 2021 Regular Meeting Agenda Packet Account Description FY 2021 Adopted Amended Budget July Totals YTD Total 7/31/2021 YTD % Budget (83% Target) Remaining Budget 135-50045-026-000 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Workman's Compensation Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 30 150 750 1,300 4,000 5,000 2,000 10 1,195 1,300 58 1 8 79.00% 0.00% 1,195 100.00% 1,099 84.56% 0.00% 0.00% 58 100.00% 2 201 1Subtotal Board of Directors 13,230 I 2,563 2,360 I 92.09% 203 Administration 135-50005-030-000 135-50010-030-000 135-50016-030-000 135-50020-030-000 135-50026-030-000 135-50027-030-000 135-50028-030-000 135-50029-030-000 135-50030-030-000 135-50035-030-000 135-50040-030-000 135-50045-030-000 135-50060-030-000 135-50070-030-000 135-55005-030-000 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55100-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60115-030-000 135-60125-030-000 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60285-030-000 135-60360-030-000 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 135-69005-030-000 135-69170-030-000 Salaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Software & Support Independent Labor Maintenance & Repairs Generator Maintenance & Repairs Building Maintenance & Supplies Cleaning Services Professional Outside Services Utility Billing Contract Telephone Communications/Mobiles Electricity Water Postage Bank Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Elections Advertising Security Miscellaneous Expenses General Manager Contingency Lawn Equipment & Maintenance Furniture/Equipment < $5000 Uniforms Hardware IT Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing Capital Outlays Copier Lease Installments 626,592 510,100 39,517 409,616 80.30% 2,000 74 6 80 107.72% 2,668 2,668 2,668 100.00% 58,550 50,250 3,668 40,790 81.17% 136,834 75,850 5,870 64,144 84.57% 7,109 4,250 327 3,549 83.50% 1,138 625 45 526 84.23% 4,730 4,730 399 4,063 85.89% 39,138 30,250 2,319 24,197 79.99% 9,153 7,050 542 5,659 80.27% 1,440 1,440 648 1,512 105.00% 1,573 1,700 129 1,285 75.59% 500 - - 0.00% 8,000 4,000 102 3,422 85.55% - - - 0.00% 126,854 96,500 4,410 80,469 83.39% 15,000 20,000 1,000 14,573 72.86% 40,000 108,050 18,000 71,518 66.19% 10,000 3,000 0.00% - - 0.00% 15,000 15,000 869 14,511 96.74% 104,925 104,925 12,604 82,690 78.81% 9,000 9,000 5,448 60.53% 9,680 8,000 436 6,580 82.25% 3,000 3,000 225 2,250 75.00% 14,512 14,512 1,025 11,928 82.20% 5,000 3,750 394 3,052 81.39% 30,000 30,000 414 16,508 55.03% 67,000 82,000 6,596 67,643 82.49% 1,500 1,500 - 0.00% 84,000 84,000 6,725 67,249 80.06% 1,000 250 183 73.36% 6,000 6,000 71 6,017 100.28% 400 240 49 289 120.47% 6,000 3,063 3,063 100.00% 6,850 4,000 535 3,304 82.60% 3,575 600 301 50.18% 200 0.00% 5,000 9,330 9,330 100.00% 2,500 - - 0.00% 1,288 1,288 24 264 20.50% 500 500 392 78.40% 17,000 17,000 - 0.00% 5,000 5,000 470 3,073 61.46% 2,500 - - 0.00% 2,050 1,000 0.00% 20,253 20,339 20,339 100.00% 6,000 4,000 592 3,573 89.32% 0.00% 4,000 4,000 337 3,624 90.60% 2,500 - - 0.00% 138,000 129,975 1,096 88,915 68.41% 4,000 4,000 261 2,579 64.48% 100,484 (6) 9,460 11,706 701 99 667 6,053 1,391 (72) 415 578 16,031 5,427 36,532 3,000 489 22,235 3,552 1,420 750 2,583 698 13,492 14,357 1,500 16,751 67 (17) (49) 696 299 1,024 108 17,000 1,927 1,000 427 376 41,060 1,421 1Subtotal Administration 1,669, 510 1 1,486,808 1 109,704 1 1,151,174 I 77.43% 335,634 Non Departmental 135-55045-039-000 1 135-55055-039-000 1 135-55060-039-000 135-55065-039-000 Legal Auditing Appraisal Tax Admin Fees 135,000 50,000 4,115 27,090 54.18% 33,800 26,000 21,000 80.77% 11,925 11,925 8,974 75.26% 4,850 4,850 3,821 78.78% 22,910 5,000 2,951 1,029 (Subtotal Non Departmental 185,575 92,775 4,115 60,885 65.63% 31,890 Total General Fund Revenues 10,227,277 9,703,255 1,005,731 7,440,355 76.68% 2,262,900 Total General Fund Expenses 10,222,170 9,357,258 695,699 6,978,681 74.58% 2,378,577 Net Budget Surplus (Deficit) 5,107 345,998 310,032 461,674 2.10% 22 of 69 August 16, 2021 Regular Meeting Agenda Packet FY 2021 Combined Financials YTD as of 07/31/2021 Adopted Budget vs YTD Actuals Revenues & Expenses • YTD Revenues • YTD Expenses . Amended Revenues 11.1 • Amended Expenses r Adopted Revenues Adopted Expenses $6,978,681 59,357,258 52,360 0% 51,151,174 17% $60,885 1% YTD Expense By Departments 53,506,871 50% YTD Expense- Water 52,257,391 YTD Expense- WW 32% YTD Expense- Admin • YTD Expense- BOD • YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 115,781,000 100,000,000 80,000,000 60,000,000 61402,206 40,000,000 69,156,299 20,000,000 Water Consumption Budget vs Actual 61,136,000 46,305,000 43,092,000 38,117,386 0 42,932,939 47,602,205 105,962,511 96,013,079 - 73,522,000 69,013,25 36,365,918 40,786,000 --Budget Consumption Oct Nov Dec Jan Feb 58,087,848 50,738,000 41,078,000 —0—Actual Consumption 100,853,000 69,501,000 Mar Apr May Jun Jul 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption 839,853,055 857,991,412 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department 5800,000 5700,000 5600,000 5500,000 5400,000 5490,157 $412,932 5300,000 5200,000 5100,000 Water Revenue Budget vs Actual 5635,974 5521,136 5483,450 5447, 160 5465,093 \ 5348,784 5371,601 5323,259 Sa_aj1■ J \ 5326,348 5313,020 50 $326,759 5327,587 5423,447 —0—Budget Revenue —0—Actual Revenue 379,555 5691,059 - 5650,853 $446,839 Oct Nov Dec Jan Feb Mar Apr May Jun Jul $7,000,000 $6,000,000 55,000,000 $4,000,000 $3,000,000 $2,000,000 51,000,000 50 Adopted Budget Water Revenue Vs Projected Water Revenue 55,932,489 55,599,274 $3,336,194 53,370,365 Total Water Revenue • Budgeted Water Revenue • Projected Water Revenue • Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses 23 of 69 August 16, 2021 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET JULY 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 835,426 PREPAID EXPENSES 3,298 ADVALOREM PROPERTY TAXES RECEIVABLE 21,188 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 859,912 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 4,476 TOTAL LIABILITIES 4,476 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 668,784 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 186,652 TOTAL FUND BALANCE 855,436 TOTAL LIABILITIES AND FUND BALANCE 859,912 24 of 69 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET JULY 2021 August 16, 2021 Regular Meeting Agenda Packet 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,590,505 2,590,505 CASH IN BANK -SAVINGS -CASH RESERVE 1,999,887 1,999,887 INVESTMENTS-TEXPOOL 4,501,328 2,007,484 6,508,812 PREPAID EXPENSES 21,433 21,433 ADVALOREM PROPERTY TAXES RECEIVABLE 2,200 2,200 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,248,179 1,248,179 TOTAL ASSETS 10,364,133 2,007,484 12,371,617 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 448 448 ACCOUNTS AND OTHER PAYABLES 416,607 416,607 CUSTOMER DEPOSITS 312,280 312,280 TOTAL LIABILITIES 729,334 729,334 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,518,116 1,518,116 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 315,000 315,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 460,899 460,899 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 558,704 558,704 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 472,881 472,881 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 200,000 200,000 UNASSIGNED FUND BALANCE 7,651,523 7,651,523 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 461,674 461,674 TOTAL FUND BALANCE 9,634,799 2,007,484 11,642,283 TOTAL LIABILITIES AND FUND BALANCE 10,364,133 2,007,484 12,371,617 25 of 69 August 16, 2021 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET JULY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 26 of 69 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION (199,119) 199,119 August 16, 2021 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JULY 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,029 TOTAL ASSETS 785,029 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 27 of 69 81,691 81,691 703,276 62 703,338 785,029 August 16, 2021 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET JULY 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND 157,470 3,892,831 TOTAL ASSETS 4,050,301 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 28 of 69 4,151,383 (101,082) 4,050,301 4,050,301 August 16, 2021 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET JULY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,274 TOTAL ASSETS 894,274 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 893,867 NET REVENUES / EXPENDITURES 406 TOTAL FUND BALANCE 894,274 TOTAL LIABILITIES AND FUND BALANCE 894,274 29 of 69 August 16, 2021 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET JULY 2021 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 533 INTEREST & SINKING DEBT 923,901 11,925 TOTAL ASSETS 935,827 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 64,064 2,322 TOTAL LIABILITIES 66,386 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (19,950) 889,391 TOTAL FUND BALANCE 869,441 TOTAL LIABILITIES AND FUND BALANCE 935,827 30 of 69 August 16, 2021 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JULY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 471,850 TOTAL ASSETS 471,850 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 31 of 69 25,988 445,862 471,850 471,850 August 16, 2021 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET JULY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 225,243 TOTAL ASSETS 225,243 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 32 of 69 5,625 219,618 225,243 225,243 August 16, 2021 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JULY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 233,102 TOTAL ASSETS 233,102 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 232,571 TOTAL FUND BALANCE 233,102 TOTAL LIABILITIES AND FUND BALANCE 233,102 33 of 69 August 16, 2021 Regular Meeting Agenda Packet SPECIAL SESSION JOINT MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS July 27, 2021 at 5:30 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a Special Session Joint Meeting with the Town of Trophy Club Town Council on July 27, 2021 at 5:30 p.m., in the Boardroom of the District Administration Building and was open to the public. STATE OF TEXAS COUNTIES OF DENTON AND TARRANT BOARD MEMBERS PRESENT: Steve Flynn President Mark Chapman Kelly Castonguay William C. Rose Kevin Carr STAFF PRESENT: Alan Fourmentin Laurie Slaght Steven Krolczyk Vice President Secretary/Treasurer Director Director General Manager District Secretary Finance Manager TOWN COUNCIL PRESENT: Alicia Fleury Greg Lamont Greg Wilson Dennis Sheridan Karl Monger Philip Shoffner § § Mayor Council Member, Place 1 Council Member, Place 2 arrived at 6:07 Council Member, Place 3 Council Member, Place 4 Council Member, Place 6 TOWN STAFF PRESENT: Wade Carroll Leticia Vacek Mike Erwin Jack Taylor David Dodd Town Manager Town Secretary Finance Manager Fire Chief Town Attorney CALL TO ORDER AND ANNOUNCE A QUORUM President Flynn announced the date of July 27, 2021, called the meeting to order and announced a quorum present at 5:37 p.m. 34 of 69 August 16, 2021 Regular Meeting Agenda Packet CITIZEN COMMENTS Nick Sanders 7 Hayes Court REGULAR SESSION 1. Consider and take appropriate action regarding the Fire Protection Services Fiscal Year 2021 Budget. Fire Chief Jack Taylor presented the proposed Fiscal Year 2021 Fire Protection Services Budget and answered questions related thereto. Motion made by Director Castonguay and seconded by Director Carr to adopt the FY 2022 Fire Department Budget. Motion carried unanimously ADJOURN President Flynn called the meeting adjourned at 6:48 p.m. Steve Flynn, President Kelly Castonguay, Secretary/Treasurer Laurie Slaght, District Secretary 35 of 69 (SEAL) August 16, 2021 Regular Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS JULY 27, 2021 at 6:00 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a regular session meeting on Tuesday, July 27, 2021 at 6:00 p.m., in the Boardroom of the Administration Building, 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: Steve Flynn Mark Chapman Kelly Castonguay William C. Rose Kevin R. Carr STAFF PRESENT: Alan Fourmentin Laurie Slaght Mike McMahon Steven Krolczyk Tony Corbett President Vice President Secretary/Treasurer Director Director General Manager District Secretary Operations Manager Finance Manager Legal Counsel GUESTS PRESENT: Leah Hodge Halff Associates Emily Wright Halff Associates § CALL TO ORDER AND ANNOUNCE A QUORUM President Flynn announced the date of July 27, 2021, announced a quorum present and called the meeting to order at 7:01 p.m. CITIZEN COMMENTS There were no citizen comments REPORTS & UPDATES 1. Staff Reports a. b. c. d. Capital Improvement Projects Water Operations Report Wastewater System Reports Finance Reports General Manager presented the monthly staff reports and answered questions related thereto. 36 of 69 August 16, 2021 Regular Meeting Agenda Packet CONSENT AGENDA 2. Consider and act to approve the Consent Agenda. a. June 2021 Combined Financials b. June 16, 2021 Regular Meeting Minutes c. Quarterly Investment Report— 3rd Quarter FY2021 d. Tax Collection Report — 3rd Quarter FY2021 Motion made by Director Rose and seconded by Director Castonguay to approve the consent agenda as presented. Motion carried unanimously REGULAR SESSION 3. Receive update on Risk and Resiliency Assessment from Halff Associates and take appropriate action related thereto. Emily Wright with Halff Associates presented the Board with the results of the Risk and Resiliency Assessment. Discussion only 4. Consider and take appropriate action to award bid and approve Contract No. 2021072701 for construction of Interconnect Waterline Project and authorize the General Manager to execute the construction contract documents. Motion made by Director Rose and seconded by Director Chapman to award the bid and approve contract 2021072701 for the construction of the interconnect waterline project for an amount not to exceed $3,165,601.45 to M -Co construction and authorize the General Manager to execute the contract. Motion carried unanimously 5. Consider and take appropriate action to adopt Order No. 2021-0727A Declaring certain scrap metal to be Surplus Property and Authorizing the Disposition Thereof. Motion made by Director Rose and seconded by Director Castonguay to adopt Order No. 2021-0727A Declaring certain Scrap metal to be Surplus Property and Authorizing Disposition thereof. Motion carried unanimously 6. Consider and act to approve Resolution No. 2021-0727A Amending the Fiscal Year 2021 Budget. Motion made by Director Flynn and seconded by Director Castonguay to approve Resolution No. 2021- 37 of 69 August 16, 2021 Regular Meeting Agenda Packet 0727A Amending the Fiscal Year 2021 Budget. Motion carried unanimously 7. Consider and act to approve Master Service Agreement with Garver, LLC for Professional Engineering Services and authorize the General Manager to execute the contract. Motion made by Director Rose and seconded by Director Castonguay to approve Master Services Agreement with Garver, LLC for Professional Engineering Services and authorizing the General Manager to execute the contract. Motion carried unanimously The Board convened into Executive Session at 7:38 p.m. EXECUTIVE SESSION 8. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Consult with legal counsel regarding the existing Interlocal Cooperation Agreement for Administration of Fire Protection Services between the District and the Town of Trophy Club, and seek legal advice regarding the potential renewal, termination, modification, or replacement thereof. 9. Deliberations pursuant to Section 551.074(a)(1) of the Texas Open Meetings Act regarding appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee: General Manager annual review. The Board reconvened into Regular Session at 8:52 p.m. REGULAR SESSION 10. Consider and take appropriate action regarding matters discussed in Executive Session, including action relating to the renewal, termination, modification, or replacement of the Interlocal Cooperation Agreement for Administration of Fire Protection Services between the District and the Town of Trophy Club. Motion made by Director Rose and seconded by Director Carr to approve the Amended and Restated Fire Interlocal Agreement for Fire Protection Services and have it transmitted to the Town. 38 of 69 August 16, 2021 Regular Meeting Agenda Packet Motion carried unanimously 11. Items for future agendas: ratification of July meeting Fire Reserves Fire Truck payment pros and cons 12. Set future Meeting dates — Monday, August 16, 2021 at 6:30 p.m. ADJOURN President Flynn called the meeting adjourned at 8:56 p.m. Steve Flynn, President Kelly Castonguay, Secretary/Treasurer Laurie Slaght, District Secretary 39 of 69 (SEAL) August 16, 2021 Regular Meeting Agenda Packet THE STATE OF TEXAS § COUNTY OF DENTON § INTERLOCAL COOPERATION AGREEMENT FOR PROPERTY TAX ASSESSMENT AND COLLECTION BETWEEN DENTON COUNTY, TEXAS AND TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 , TEXAS INTERLOCAL COOPERATION AGREEMENT —TAX COLLECTION THIS AGREEMENT is made and entered into by and between DENTON COUNTY, a political subdivision of the State of Texas, hereinafter referred to as "COUNTY," and TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 , Denton County, Texas, also a political subdivision of the State of Texas, hereinafter referred to as " DISTRICT." WHEREAS, COUNTY and DISTRICT mutually desire to be subject to the provisions of Texas Government Code, Chapter 791, the Interlocal Cooperation Act, and Section 6.24 of the Texas Tax Code, and; WHEREAS, DISTRICT has the authority to contract with the COUNTY for the COUNTY to act as tax assessor and collector for DISTRICT and COUNTY has the authority to so act. Page 1 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 40 of 69 August 16, 2021 Regular Meeting Agenda Packet NOW THEREFORE, COUNTY and DISTRICT, for and in consideration of the mutual promises, covenants, and agreements herein contained, do agree as follows: Throughout this Agreement, the term "Property Tax Code" means Title 1 of the Texas Tax Code. Throughout this Agreement, the term "tax year" means the calendar year in which the applicable tax lien attaches to the taxable property. The term "collection year" refers to the period commencing on October 1st of the applicable tax year and continuing through the end of the applicable term (September 30th of the following year), in which collection and billing services are to be performed under this Agreement. I. The effective date of this Agreement shall be October 1, 2021. The initial term of this Agreement shall be for a period of one year beginning on the effective date and ending September 30, 2022. The initial term of the Agreement is for tax year 2021 property tax rate calculation, billing, and collection services. Following the initial term, this Agreement shall automatically renew for subsequent one-year terms, unless written notice of termination is provided by COUNTY or DISTRICT no later than one hundred -eighty (180) days prior to the expiration date of the then -current term of the Agreement. If said notice is provided, this Agreement shall terminate at the end of the then -current term. Each renewal term shall be for property tax rate calculation, billing and collection services for the applicable tax year (the first renewal term will be for tax year 2022, the second renewal terms for tax year 2023, etc.). Page 2 of 15 II. SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 41 of 69 August 16, 2021 Regular Meeting Agenda Packet For the purposes and consideration herein stated and contemplated, COUNTY shall provide the following necessary and appropriate services for DISTRICT to the maximum extent authorized by this Agreement, without regard to race, sex, religion, color, age, disability, or national origin: 1. COUNTY, by and through its duly qualified tax assessor -collector, shall serve as Tax Assessor -Collector for DISTRICT for ad valorem tax collection for the tax year. COUNTY agrees to perform all necessary ad valorem assessing and collecting duties for DISTRICT and DISTRICT does hereby expressly authorize COUNTY to do and perform all acts necessary and proper to assess and collect taxes for DISTRICT. COUNTY agrees to collect base taxes, penalties, interest, and attorney's fees. 2. COUNTY agrees to prepare and mail all current and delinquent tax statements required by statute, supplemental changes for applicable property accounts, as well as prepare and mail any other mailing as deemed necessary and appropriate by COUNTY; provide daily, monthly and annual collection reports to DISTRICT; prepare tax certificates; develop and maintain both current and delinquent tax rolls, disburse tax monies to DISTRICT daily (business day) based on prior day tax postings, approve and refund overpayment or erroneous payment of taxes for DISTRICT pursuant to Property Tax Code Section 31 from available current tax collections of DISTRICT; and to meet the requirements of Section 26.04 and Section 42 Subchapter C and develop and maintain such other records and forms as are necessary or required by State law, rules, or regulations. If daily disbursal is to be delayed, COUNTY will notify DISTRICT in the secured web entity folder the reason for the delay. Page 3 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 42 of 69 August 16, 2021 Regular Meeting Agenda Packet 3. COUNTY further agrees that it make for DISTRICT the property tax rate calculations required by Property Code Section 26.04 (currently identified in the Section by terms "no new revenue tax rate" and "voter -approval tax rate") and will do so in accordance with all requirements therein. All such rate calculations will be performed using only the Texas State Comptroller's "Truth In Taxation" formulas, and at no additional cost to DISTRICT. The information concerning the rate calculations described in this Article II.3 and publications will be provided to DISTRICT in the form prescribed by the Comptroller of Public Accounts of the State of Texas, and as required by Section 26. DISTRICT shall be responsible for all publications as required by Chapter 26. In the event DISTRICT requires early calculation based on certified estimate values, COUNTY will perform the tax rate calculations described in this Article II.3 and provide the required publications to DISTRICT in the same manner as performing the tax rate calculations pursuant to the annual appraisal district reports required to be Certified on July 25 of each tax year. 4. COUNTY agrees, upon request, to offer guidance and the necessary forms for posting notices as required by Chapter 26 of the Property Tax Code if DISTRICT requests such no less than 7 days in advance of the intended publication date. DISTRICT must approve all calculations and notices, in the format required by COUNTY and Property Tax Code Section 26. The accuracy and timeliness of all required notices are the responsibility of DISTRICT. COUNTY will update tax transparency databases, as required in Property Tax Code Section 26.17(b),(5A,B),(7),(12,),(13) and 26.17(e)(2) with applicable Truth In Taxation worksheets and Notices. DISTRICT is responsible for any other required information posted on a tax transparency Page 4 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 43 of 69 August 16, 2021 Regular Meeting Agenda Packet database. This Agreement is subject to and the parties herein shall comply with all applicable provisions of the Property Tax Code and all other applicable Texas statutes. COUNTY will submit to DISTRICT approval forms of the tax rate calculation and required notices. DISTRICT must return executed approval forms to tax assessor/collector as required by law and this agreement. 5. Should DISTRICT vote to increase its tax rate above the statutory voter approval limit (also known as the "rollback" or the "voter approval" rate), the required publication of notices shall be the responsibility of the DISTRICT. Should DISTRICT roll back the tax rate as a result of Tax Rate Election, the required publication of notices shall be the responsibility of DISTRICT. 6. COUNTY agrees to develop and maintain written policies and procedures of its operation. COUNTY further agrees to make available full information about the operation of the County Tax Office to DISTRICT, and to promptly furnish written reports to keep DISTRICT informed of all financial information affecting it. 7. DISTRICT agrees to promptly deliver to COUNTY all records that it has accumulated and developed in the assessment and collection of taxes, and to cooperate in furnishing or locating any other information and records needed by COUNTY to perform its duties under the terms and conditions of this Agreement. 8. COUNTY agrees to allow an audit of the tax records of DISTRICT in COUNTY'S possession during normal working hours with at least 72 hours advance written notice to COUNTY. The expense of any and all such audits shall be paid by DISTRICT. A copy of any and all such audits shall be furnished to COUNTY. Page 5 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 44 of 69 August 16, 2021 Regular Meeting Agenda Packet 9. If required by DISTRICT, COUNTY agrees to obtain a surety bond for the County Tax Assessor/Collector. Such bond will be conditioned upon the faithful performance of the Tax Assessor/Collector's lawful duties, will be made payable to DISTRICT and in an amount determined by the governing body of DISTRICT. The premium for any such bond shall be borne solely by DISTRICT. 10. COUNTY agrees that it will post a notice on its website, as a reminder that delinquent tax penalties will apply to all assessed taxes that are not paid by January 31' of the collection year. 11. COUNTY agrees that it will post to a secure website collection reports for DISTRICT listing current taxes, delinquent taxes, penalties and interest on a daily basis through September 30th of the collection year. COUNTY will provide monthly Maintenance and Operation (hereinafter referred to as "MO"), and Interest and Sinking (hereinafter referred to as "IS") collection reports; provide monthly recap reports; and provide monthly attorney fee collection reports. 12. DISTRICT retains its right to select its own delinquent tax collection attorney and COUNTY agrees to reasonably cooperate with the attorney selected by DISTRICT in the collection of delinquent taxes and related activities. 13. DISTRICT will provide COUNTY with notice of any change in collection attorney at least 7 days before the effective date of the new collection attorney contract. III. COUNTY hereby designates the Denton County Tax Assessor/ Collector to act on behalf of the County Tax Office and to serve as Liaison for COUNTY with DISTRICT. The County Tax Assessor/Collector, and/or his/her designated substitute, shall ensure the Page 6 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 45 of 69 August 16, 2021 Regular Meeting Agenda Packet performance of all duties and obligations of COUNTY; shall devote sufficient time and attention to the execution of said duties on behalf of COUNTY in full compliance with the terms and conditions of this Agreement; and shall provide immediate and direct supervision of the County Tax Office employees, agents, contractors, subcontractors, and/or laborers, if any, in the furtherance of the purposes, terms and conditions of this Agreement for the mutual benefit of COUNTY and DISTRICT. IV. COUNTY accepts responsibility for the acts, negligence, and/or omissions related to property tax service of all COUNTY employees and agents, sub -contractors and/or contract laborers, and for those actions of other persons doing work under a contract or agreement with COUNTY to the extent allowed by law. V. DISTRICT accepts responsibility for the acts, negligence, and/or omissions of all DISTRICT employees and agents, sub -contractors and/or contract laborers, and for those of all other persons doing work under a contract or agreement with DISTRICT to the extent allowed by law. VI. DISTRICT understands and agrees that DISTRICT, its employees, servants, agents, and representatives shall at no time represent themselves to be employees, servants, agents, and/or representatives of COUNTY. COUNTY understands and agrees that COUNTY, its employees, servants, agents, and representatives shall at no time represent themselves to be employees, servants, agents, and/or representatives of DISTRICT. Page 7 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 46 of 69 August 16, 2021 Regular Meeting Agenda Packet VII. For the services rendered during the tax year, DISTRICT agrees to pay COUNTY for the receipting, bookkeeping, issuing, and mailing of tax statements as follows: 1. The current tax statements will be mailed by October 10th of the tax year or as soon thereafter as practical. The DISTRICT must adopt its tax year tax rate on or before September 30th of the applicable tax year, if that rate does not exceed the voter -approval tax rate not later than the deadline set forth in Property Tax Code 26.05(a), Election Code 3.005 and 41.001. In order to expedite mailing of tax statements, DISTRICT shall adopt and then deliver its adopted tax rate to COUNTY no later than the applicable adoption deadline described herein. Failure by DISTRICT to adopt and then deliver the adopted tax rate to COUNTY by said applicable adoption deadline may result in delay of processing and mailing DISTRICT tax statements. DISTRICT agrees to assume the costs for additional delayed tax statements, processing and mailing as determined by COUNTY. An additional notice will be sent during the month of March following the initial mailing provided that DISTRICT has requested such a notice on or before February 28th of the collection year. During the initial term of this Agreement, the fee for this service will be $1.00 per statement. During the first and second renewal terms of this Agreement, the fee for this service will be the per statement rate approved by Commissioners Court for the applicable tax year, provided notice of that rate is provided to DISTRICT as described in Section 8 of this Article VII. In the event COUNTY does not provide DISTRICT with said notice, the rate charged during the preceding term will apply. Page 8 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 47 of 69 August 16, 2021 Regular Meeting Agenda Packet 2. At least 30 days, but no more than 60 days prior to April 1St of the collection year and following the initial mailing, a delinquent tax statement meeting the requirements of Section 33.11 of the Texas Property Tax Code will be mailed to the owner of each parcel having delinquent taxes. 3. At least 30 days, but no more than 60 days prior to July 1st of the collection year and following the initial mailing, a delinquent tax statement meeting the requirements of Section 33.07 of the Texas Property Tax Code will be mailed to the owner of each parcel having delinquent taxes. 4. For accounts that become delinquent on or after June 1' of the collection year, COUNTY shall mail a delinquent tax statement meeting the requirements of Section 33.08 of the Property Tax Code to the owner of each parcel having delinquent taxes. 5. For accounts that become delinquent on February 1 st of the tax year, COUNTY, in its sole discretion, may mail a reminder notice to the owner of each parcel having delinquent taxes not including February 33.11 notices. 6. In event of a tax rate change resulting from a rollback or tax approval election that taxes place after tax bills for DISTRICT have been mailed, DISTRICT agrees to pay COUNTY a programming charge of $5,000.00. COUNTY will, pursuant to Property Tax Code Section 26.07(f) or 26.075(j) will mail corrected statements to the owner of each property. The fee for this service will be the same per statement rate described in Section 1 of this Article VII. When a refund is required per Property Tax Code Section 26.07(g) or 26.075(k), COUNTY will charge a $.25 processing fee per check, in addition to the corrected statement mailing costs. Issuance of refunds, in the event of a Page 9 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 48 of 69 August 16, 2021 Regular Meeting Agenda Packet successful rollback election will be the responsibility of the COUNTY. DISTRICT will be billed for the refunds, postage, and processing fees. 7. DISTRICT understands and agrees that COUNTY will, no later than January 31' of the tax year, deduct from current collections of DISTRICT's the "Total Cost" of providing all services described in Sections 1-5 above. This "Total Cost" includes any such services that have not yet been performed at the time of deduction. During the initial term of this Agreement, the "Total Cost" of providing all services described in Sections 1- 5 above shall be the total of: $1.00 (the "per parcel rate") x the total number of parcels listed on DISTRICT's preceding tax year Tax Roll on September 30th of the tax year. During the first and second renewal terms of this agreement, the "per parcel rate" will be the per parcel rate approved by Commissioners Court for the applicable tax year, provided notice of that rate is provided to DISTRICT as described in Section 1 and 8 of this Article VII. In the event COUNTY does not provide DISTRICT with said notice, the per parcel rate charged during the preceding term will apply. In the event that a rollback or tax approval election as described in Section 6 of this Article VII takes place, COUNTY shall bill DISTRICT for the applicable programming charge, check processing fees, refunds paid, and refund postage costs. DISTRICT shall pay COUNTY all billed amounts within 30 days of its receipt of said bill. In the event costs for additional delayed tax statements, processing and mailing are incurred as described in Section 1 of this Article VII, COUNTY shall bill DISTRICT for such amounts. DISTRICT shall pay COUNTY all such billed amounts within 30 days of its receipt of said bill. Page 10 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 49 of 69 August 16, 2021 Regular Meeting Agenda Packet 8. The County Budget Office establishes collection rates annually based on a survey of actual annual costs incurred by the County in performing tax collection services. The collection rate for each tax year is approved by County Commissioners' Court, and all entities are assessed the same per parcel collection rate. Following approval of the collection rate for each tax year, COUNTY will, at least sixty (60) days prior to the expiration date of the then -current term of this Agreement, provide DISTRICT with written notice of that rate. VIII. COUNTY agrees to remit all taxes, penalties, and interest collected on DISTRICT's behalf and to deposit such funds into the DISTRICT's depositories, as designated: 1. For deposits of tax, penalties, and interest, payment shall be by wire transfer or ACH to DISTRICT's depository accounts only, and segregated into the appropriate MO and IS accounts (and Contract Rate account), as applicable, specified on the Direct Deposit Authorization executed between the DISTRICT and COUNTY. Only in the event of failure of electronic transfer protocol will a check for deposits of tax, penalty and interest be sent by mail to DISTRICT 2. In anticipation of renewal of this Agreement, COUNTY further agrees that deposits will be made daily through September 30th of the collection year. It is expressly understood, however, that this obligation of COUNTY shall not survive termination of this Agreement, whether by termination by either party or by failure of the parties to renew this Agreement. In event that COUNTY experiences shortage in collections as a result of an outstanding tax debt of DISTRICT, the DISTRICT agrees a payment in the amount of shortage shall Page 11 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 50 of 69 August 16, 2021 Regular Meeting Agenda Packet be made by check or ACH to COUNTY within 15 days after notification of such shortage. Failure to remit payment of shortage restricts release of collected taxes until such time as payment is remitted. IX. In the event of termination, the terminating party shall be obligated to make such payments as are required by this Agreement through the balance of the tax year in which notice is given. COUNTY shall be obligated to provide services pursuant to this Agreement during such period. X. This Agreement represents the entire agreement between DISTRICT and COUNTY and supersedes all prior negotiations, representations, and/or agreements, either written or oral. This Agreement may be amended only by written instrument signed by the governing bodies of both DISTRICT and COUNTY or those authorized to sign on behalf of those governing bodies. XI. Any and all written notices required to be given under this Agreement shall be delivered or mailed to the listed addresses: COUNTY: County Judge of Denton County 110 West Hickory Denton, Texas 76201 Telephone: 940-349-2820 Page 12 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 51 of 69 August 16, 2021 Regular Meeting Agenda Packet DISTRICT: Trophy Club Municipal Utility District No. 1 100 Municipal Drive Trophy Club, Texas 76262 XII. DISTRICT hereby designates Alan Fourmentin, General Manager to act on behalf of DISTRICT, and to serve as Liaison for DISTRICT to ensure the performance of all duties and obligations of DISTRICT as stated in this Agreement. DISTRICT's designee shall devote sufficient time and attention to the execution of said duties on behalf of DISTRICT in full compliance with the terms and conditions of this Agreement; shall provide immediate and direct supervision of the DISTRICT employees, agents, contractors, subcontractors, and/or laborers, if any, in the furtherance of the purposes, terms and conditions of this Agreement for the mutual benefit of DISTRICT and COUNTY. XIII. In the event that any portion of this Agreement shall be found to be contrary to law, it is the intent of the parties that the remaining portions shall remain valid and in full force and effect to the extent possible. XIV. The undersigned officers and/or agents of the parties are the properly authorized officials and have the necessary DISTRICT to execute this agreement on behalf of the Page 13 of 15 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 52 of 69 August 16, 2021 Regular Meeting Agenda Packet parties. Each party hereby certifies to the other that any resolutions necessary for this Agreement have been duly passed and are now in full force and effect. Executed in triplicate originals this. 16th day of August Page 14 of 15 20 21 SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 53 of 69 August 16, 2021 Regular Meeting Agenda Packet COUNTY DISTRICT Denton County Texas 110 West Hickory Denton, Texas 76201 Trophy Club Municipal Utility District No. 1 100 Municipal Drive Trophy Club, Texas 76262 Email: Phone: (682) 831-4600 BY: BY: Honorable Andy Eads Name: Steve Flynn County Judge Title: Board President ATTEST: ATTEST: BY: BY: Juli Luke Name Kelly Castonguay Denton County Clerk Title Board Secretary/Treasurer APPROVED FORM AND CONTENT: APPROVED AS TO FORM: Michelle French Denton County Tax Assessor/Collector Page 15of15 Denton County Attorney SPECIAL WATER_WCID_FWSD Multi Year ILA (2021) 54 of 69 Trophy Club MUD No. 1 August 16, 2021 Regular Meeting Agenda Packet FY 2022 DRAFT BUDGET FY 2022 BUDGET FUND SUMMARY General Fund Revenue 9,883,460 Tax Collections 136,092 PID Surcharges 165,537 Reserve Funds 0 Total Revenue 10,185,089 Water Expense 5,262,306 Wastewater Expense 3,247,982 Board of Directors Expense 11,780 Administration Expense 1,477,317 Non -Departmental Expense 185,705 Total Expense 10,185,089 Net Budget Surplus/Deficit Tax Debt Service Fund so Revenue 198,761 Tax Collections 690,667 PID Surcharge 115,924 Total Revenue 1,005,353 Debt Service Expense 1,005,353 Total Expense 1,005,353 Net Budget Surplus/Deficit so 55 of 69 Fire Fund Revenue 22,000 Tax Collections 1,269,330 PID Assessment 528,546 Reserve Funds 57,700 Total Revenue 1,877,576 Fire Expense 1,877,576 Total Expense 1,877,576 Net Budget Surplus/Deficit Revenue Debt Service Fund so Revenue 1,259,540 Total Revenue 1,259,540 Debt Service Expense 1,259,540 Total Expense 1,259,540 Net Budget Surplus/Deficit so TAX RATE SUMMARY COMPARISON Fisc s 2021 2022 % of Increase/Decrease M&O (General Fund) Tax M&O Fire Tax M&O Tax Rate Increase/Decrease: 0.00709 0.00687 -3.05% 0.06476 0.06412 -0.99° 0.07185 0.07099 -1.19% -0.00301 -0.00086 I & S (Debt Service) Tax Increase/Decrease: 0.03589 0.03489 -2.79% -0.00198 -0.00100 Total Tax Rate: 0.10774 0.10588 -1.72% Increase/Decrease: -0.00499 -0.00186 FY 2022 BUDGET FUND SUMMARY General Fund Revenue 9,883,460 Tax Collections 136,092 PID Surcharges 165,537 Reserve Funds 0 Total Revenue 10,185,089 Water Expense 5,262,306 Wastewater Expense 3,247,982 Board of Directors Expense 11,780 Administration Expense 1,477,317 Non -Departmental Expense 185,705 Total Expense 10,185,089 Net Budget Surplus/Deficit Tax Debt Service Fund so Revenue 198,761 Tax Collections 690,667 PID Surcharge 115,924 Total Revenue 1,005,353 Debt Service Expense 1,005,353 Total Expense 1,005,353 Net Budget Surplus/Deficit so 55 of 69 Fire Fund Revenue 22,000 Tax Collections 1,269,330 PID Assessment 528,546 Reserve Funds 57,700 Total Revenue 1,877,576 Fire Expense 1,877,576 Total Expense 1,877,576 Net Budget Surplus/Deficit Revenue Debt Service Fund so Revenue 1,259,540 Total Revenue 1,259,540 Debt Service Expense 1,259,540 Total Expense 1,259,540 Net Budget Surplus/Deficit so PROPERTY VALUE SUMMARY COMPARISON Fiscal Years 2021 2022 % of Increase/Decrease MUD Tarrant Co. MUD Denton Co. PID Out of District & PID 522,432,262 510,691,116 -2.25% 1,403,005,151 1,468,987,935 4.70% 788,523,995 824,066,245 4.51% 276,544 266,888 -3.49% Total Value: 2,714,237,952 2,804,012,184 3.31% FY 2022 BUDGET FUND SUMMARY General Fund Revenue 9,883,460 Tax Collections 136,092 PID Surcharges 165,537 Reserve Funds 0 Total Revenue 10,185,089 Water Expense 5,262,306 Wastewater Expense 3,247,982 Board of Directors Expense 11,780 Administration Expense 1,477,317 Non -Departmental Expense 185,705 Total Expense 10,185,089 Net Budget Surplus/Deficit Tax Debt Service Fund so Revenue 198,761 Tax Collections 690,667 PID Surcharge 115,924 Total Revenue 1,005,353 Debt Service Expense 1,005,353 Total Expense 1,005,353 Net Budget Surplus/Deficit so 55 of 69 Fire Fund Revenue 22,000 Tax Collections 1,269,330 PID Assessment 528,546 Reserve Funds 57,700 Total Revenue 1,877,576 Fire Expense 1,877,576 Total Expense 1,877,576 Net Budget Surplus/Deficit Revenue Debt Service Fund so Revenue 1,259,540 Total Revenue 1,259,540 Debt Service Expense 1,259,540 Total Expense 1,259,540 Net Budget Surplus/Deficit so August 16, 2021 Regular Meeting Agenda Packet TAX RATE ASSESSMENT PID ASSESSMENT & SURCHARGE CALCULATIONS FIRE TAX/ASSESSMENT RATE NET TAX VALUE: TARRANT COUNTY: $510,691,116 DENTON COUNTY: $1,468,987,935 DENTON CO. PID: $824,066,245 OUT OF DISTRICT & PID $266,888 REQUIRED REVENUE FIRE $1,797,876 M&O TAX/SURCHARGE RATE TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 28,040,122 FY 2022 Tax/Assess Rate = 0.06412 Revenue from MUD Tax = Revenue from PID Assess = NET TAX VALUE: Total: $ TARRANT COUNTY: $510,691,116 DENTON COUNTY: $1,468,987,935 DENTON CO. PID: $824,066,245 REQUIRED REVENUE M&O 185,705 168,800 *MUD (All of Dept. 39 Budget) **ND (Legal and Auditor only Dept 39 Budget) I&S TAX/SURCHARGE RATE NEW DEBT: CALCULATE AMOUNT DUE FROM PID 1,269,330 528,546 1,797,876 Certified 7/23/2021 7/26/2021 7/26/2021 7/26/2021 Certified 7/23/2021 7/26/2021 7/26/2021 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 28,037,453 FY 2022 MUD M&O Tax Rate = 0.00687 FY 2022 PID Tax/Surcharge Rate = 0.00602 Revenue from MUD Tax = Revenue from PID Surcharge = NET TAX VALUE: $ $ Total: $ TARRANT COUNTY: $510,691,116 DENTON COUNTY: $1,468,987,935 DENTON CO. PID: $824,066,245 REQUIRED REVENUE TAX DEBT 2014 AND AFTER (I&S) $394,413 MUD DEBT: CALCULATE MUD TAX 136,092 49,613 185,705 Certified 7/23/2021 7/26/2021 7/26/2021 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 28,037,453 FY 2022 PID Surcharge Rate = 0.01407] ***NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE Revenue from MUD Tax = $ 278,488 Revenue from PID Surcharge = $ 115,924 Total: $ 394,413 NET TAX VALUE: TARRANT COUNTY: $510,691,116 DENTON COUNTY: $1,468,987,935 REQUIRED REVENUE I&S MUD DEBT $690,667 Tax Rate Requirements 3.5% Overall Tax Rate FY 2022 0.10588 Voter Approval Rate 0.10588 Contributions Required $57,700 Certified 7/23/2021 7/26/2021 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Va Is/100 = 19,796,791 FY 2022 Tax Rate = 0.03489 Revenue from MUD Tax = Revenue from PID = N/A 690,667 M&O (General Fund) Tax M&O Fire Tax M&O Tax Rate Increase/Decrease Rate: I & 5 (Debt Service) Tax Increase/Decrease Rate: Total Tax Rate: Increase/Decrease Rate: 56 of 69 Total: $ 690,667 TAX COMPARISON 2021 0.00709 0.06476 2022 0.00687 0.06412 0.07185 0.07099 -0.00301 -0.00086 0.03589 0.03489 -0.00198 -0.00100 0.10774 0.10588 -0.00499 -0.00186 August 16, 2021 Regular Meeting Agenda Packet GENERAL FUND Description FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2021 FY 2022 Budget vs Prior Year 010 Total FY 2021 FY 2021 Actual Actual Actual Actual Adopted Amended Proposed Budget Net Change % 7/31/2021 % of Budget Projections Property Taxes 61,008 122,279 125,687 135,857 136,531 136,531 136,092 (4391 -0.32% 134,226 98.31% 136,531 Property Taxes/Delinquent 290 347 1327) 402 300 547 300 - 0.0096 518 94.7696 518 Property Taxes/P & I 350 530 570 769 300 367 300 - 0.00% 475 129.33% 475 PID Surcharges 103,619 195 528 163 043 164 700 163 725 163 725 165,537 1,812 1.1196 - 0.00% 163 725 Comments Water 5,822,785 6,035,804 5,243,386 5,765,931 5,932,489 5,639,480 5,848,107 (84,382) -1.42% 4,194,922 74.38% 5,599,274 Decrease Projected Consumption Demand Over Poor Year Sewer 2,587,176 3 035 824 3 124 552 3 254 599 3677146 3,560,000 3,824,473 147,327 4.01% 2 920 089 82.02% 3560000 Increase Due to Winter Average Tier Class Penalties 121,528 119,594 98,969 61,753 112,608 74,000 94,826 (17,782) -15.79% 63,137 85.32% 74,000 Decrease In Late Payments Service Charges (Disconnect Fees) 14,100 13 881 15 850 9 950 16 550 11,500 14,000 (2,550) -15.41% 10025 87.17% 11500 Decrease In Missed Payments/Disconnects Plumbing Inspections 2,400 2,200 2,750 5,300 750 300 750 0.00% 300 100.00% 300 Sewer Inspections 4,800 5800 4150 5050 2500 100 2,500 - 0.00% 100 100.00% 100 TCCC Effluent Charges 87,159 81,611 57,003 89,037 50,000 42,000 50,000 - 0.00% 46,310 110.26% 46,310 Utility Fees - - - - - - 0.00% - 0.00% Capital Lease- Other Fin Sources - - 205,504 - - - - - 0.00% - 0.00% Interest Income 18,940 61282 139 388 81518 100000 18,090 15,000 (85,000) -85.00% 15747 87.05% 18090 Interest Rates Declined To Near Zero- Post Pandemic Cell Tower Revenue 10,926 12,077 15,651 12,967 14,146 14,146 14,146 0.00% 11,788 83.33% 14,146 Building Rent Income 7,000 7000 7000 5833 - - - - 0.0096 - 0.0096 Proceeds from Sale of Assets 39,899 15,400 52,600 12,520 5,000 19,575 10,000 5,000 100.0096 19,575 100.0096 19,575 Surplus and Auction Items Prior Year Reserves - - - - - - 0.0096 - 0.0096 GASB Reserves - - 150,000 - - - 0.0096 - 0.00% Loan Proceeds - 360 100 32080 - - - 0.00% - 0.00% Oversize Meter Reimbursement 20,864 14,237 41,295 19,732 8,232 4,407 2,058 (6,174) -75.00% 4,407 100.0096 4,407 Decrease In New Meter Installs Interfund Transfer In - 797 834 32080 - - - - - 0.0096 - 0.0096 - Intergov Transfer In - - - - - - 0.00% - 0.0096 Miscellaneous Income (27,448) 16547 14216 35761 7000 18488 7,000 - 0.0096 18736 101.35% 18736 District Related Impact Fees Records Management Revenue 32 2 6 - - - - - 0.00% - 0.0096 Recovery of Prior Year Expense 81,791 - - - - - - - 0.00% - 0.00% Reimbursement - - - - - - - 0.00% - 0.0096 i Water Expenses (Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Maintenance & Repairs Generator Maintenance & Repairs Vehicle Maintenance Maintenance -Heavy Equipment Cleaning Services Lab Analysis - MUD Lab Analysis - PID Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits - MUD TCEQ Fees & Permits - PID Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Services Interfund Transfer Out- Revenue 165 Interfund Transfer Out- Bond Reserve Interfund Transfer Out -Bank Reserve Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense 8,957,220 10,897,878 9,525,45 10,227,277 9,703,255 10,185,089 (42,188) 232,082 245,349 308,939 358,683 365,309 358,000 402,468 37,160 10.17 285,140 79.6596- 358,000 COLA and Merit Increase Based on Regional CPI, Fill Vacant Position 13,069 14 433 12 323 20 986 17 000 24,000 17,000 - 0.00% 19 646 81.8696 24 000 3,270 3,310 3,620 5,083 5,435 5,435 5,829 394 7.24% 5,435 100.00% 5,435 2,600 2,425 2,125 4,900 6,000 3,025 4,500 (1,500) -25.0056 2,525 83.47% 3,025 21,489 24,919 30,416 35,476 36,520 36,520 46,074 9,554 26.16% 30,683 84.02% 36,520 Increase in Retirement Rate Post -Pandemic Economy 30,038 32,816 41,853 59,351 86,182 65,000 87,351 1,170 1.36% 53,616 82.49% 65,000 2,942 2,589 2,995 3,641 4,933 4,000 5,594 660 13.39% 3,252 81.29% 4,000 578 460 490 563 789 580 719 (70) -8.87% 479 82.50% 580 2,576 2,573 2,574 3,752 3,289 3,800 4,620 1,331 40.49% 3,219 84.72% 3,800 15,286 16,345 19,845 23,871 24,412 24,412 26,647 2,235 9.16% 19,169 78.52% 24,412 3,575 3,823 4,641 5,583 5,709 5,709 6,232 523 9.16% 4,483 78.52% 5,709 51 819 47 974 1,080 1,200 1,512 432 40.00% 1,671 139.25% 1,671 TWC Rate Increase For All Government Entities 11,864 10,799 10,901 8,846 10,877 12,500 11,604 727 6.68% 10,697 85.58% 12,500 347 285 370 235 400 400 400 - 0.00% - 0.00% 400 187 178 74 87 300 300 300 - 0.00% 103 34.38% 300 25,390 - 6,069 - 20,000 - - (20,000) -100.0096 - 0.00% - 87,258 100,901 128,828 60,089 124,000 96,000 110,000 (14,0001 -11.29% 69,730 72.64% 96,000 Infrastructure Maintenance, Quick Connects, Fire Hydrants, Spare Parts, Pump Repair, & Point Repairs 2,459 770 1,906 847 3,000 2,000 2,000 (1,000) -33.3356 - 0.00% 2,000 2,253 5,216 4,770 6,003 5,000 7,657 5,000 - 0.00% 7,737 101.04% 7,737 - 35 - 1,828 3,500 3,500 1,000 (2,500) -71.43% 1,114 31.83% 3,500 Backhoe and Valve Trailer - 175 1,050 1,000 1,000 2,000 1,000 100.00% 788 78.75% 1,000 Adiust Cleaning Schedule 3,948 7,413 8,104 4,561 7,500 7,500 7,500 - 0.0096 3,041 40.5496 7,500 2,183 1,753 1,799 2,216 2,000 2,000 2,000 - 0.00% 1,593 79.66% 2,000 4,589 3,973 3,771 5,334 7,500 7,500 7,500 - 0.0096 3,876 51.68% 7,500 Cell Phones & Tablets 156,752 140,190 113,377 131,998 123,487 123,487 131,689 8,201 6.64% 97,775 79.1896 123,487 767 767 790 850 1,000 1,366 1,000 - 0.00% 1,366 100.00% 1,366 - - 122 105 500 500 - (5001 -100.00% - 0.00% 500 Reclass Cost to Schools & Training 936 2,889 3,581 2,920 7,426 2,500 4,141 (3,285) -44.2496 1,986 79.4496 2,500 - 8 - - 400 400 - (4001 -100.00% 105 26.25% 400 Reclass Cost to Schools & Training 124 87 2,544 - 2,875 500 988 (1,888) -65.6536 - 0.00% 500 - - - - 1,500 - - 11,5001 -100.00% - 0.00% - Reclass Cost to Maintenance & Repairs 31,064 24,220 21,084 25,706 30,000 30,000 30,000 - 0.00% 24,018 80.06% 30,000 Water System Fees ($10,000) & NTGCD Well Fees ($20,000) - - - - - - 0.00% - 0.00% - 2,068,311 2,257,593 1,977,849 1,865,024 2,596,295 2,316,841 2,508,611 (87,684) -3.38% 1,320,740 57.01% 2,316,841 103 - - - 200 - (2001 -100.0096 - 0.00% - 775 975 612 1,392 3,000 1,000 - (3,000) -100.00% 140 14.00% 1,000 Reclass Cost to Maintenance & Repairs 8,250 11,250 8,090 6,000 14,750 10,000 12,500 (2,2501 -1525% 7.500 7500% 10.000 Updated Mowing Schedule 240,822 278,084 276,901 527,381 565,820 565,820 569,454 3,635 0.64% 514,381 90.91% 565,820 48,047 48.996 55,200 36.800 - - - 0 00% - 0 00% - 75,000 75,000 - (75,000) -100.0036 - 0.00% 75,000 - 5.020 562 2,500 383 2,500 - 000% 383 10000% 383 Replacing Chairs & Office Furniture 8,733 11,489 10,479 10,066 15,000 15,000 15,000 - 0.00% 11,894 79.29% 15,000 3.064 2,632 2,219 3.425 5.190 3,500 5,250 60 116% 2.966 84 75% 3.500 24,217 18,687 22,270 21,491 25,000 25,000 25,000 - 0.00% 21,045 84.18% 25,000 868 - - - 1,200 1,200 - (1,2001 -10000% - 000% 1.200 Reclass Cost to Maintenance & Repairs 507 1,081 641 - 1,000 1,000 - (1,000) -100.00% - 0.00% 1,000 Reclass Cost to Maintenance & Repairs 24,000 24,976 55,003 61,774 70,000 10,000 20,000 (50,0001 -7143% 9.287 92 87% 10.000 Meter Installs Reduced Due To Build Out 57 of 69 August 16, 2021 Regular Meeting Agenda Packet GENERAL FUND Description Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract I Bond Related Expenses 'Subtotal Water Expenses 1 Wastewater Expenses 'Salaries & Wages 2018 FY 2019 dual Actual 71160 82,313 86,949 323,263 488,427 1,147,521 30 068 2,271 4,124 75,000 75 000 75 000 126,958 107,864 99,877 39,160 4,630,096 1 1 3,681,756 1 4,066,003 1 'Overtime Lon evity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Independent Labor Maintenance & Repairs- WWTP Maintenance & Repairs- Collections Generator Maintenance & Repairs Vehicle Maintenance- WWTP Vehicle Maintenance- Collections Maintenance -Heavy Equipment Cleaning Services Dumpster Services Lab Analysis Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment Advertising TCEQ Fees & Permits Miscellaneous Expenses Property Maintenance Lawn Services Interfund Transfer Out -Tax I&S Interfund Transfer Out- Revenue I&S Interfund Transfer Out -Bond Reserve Interfund Transfer Out -Bank Reserve Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals- WWTP Chemicals- Collections Small Tools Safety Equipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Capital Lease Issuance Cost Subtotal Wastewater Expenses Board of Directors Expenses Salaries & Wages Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training 387,947 31,979 6,635 8,275 38,208 55,136 4,464 954 4,552 25,343 5,927 63 14,903 80 461 852 19,449 97,990 6,076 9,836 24 56,329 32,416 5,460 145,449 150 267 2,959 291 2,625 4,086 32,564 113 6,490 120,492 595,638 180,417 8,722 3,754 25,101 2,191 517 13,258 276,328 FY 2020 Actual 36,900 451,480 30 512 3,230 475 899 102,077 1,220 4,410,770 1 362 490 3;4641 425 068 37,047 33,704 22,679 7415 7445 6873 8,436 8,575 7,575 38361 37618 42091 65,584 60,272 84,736 4692 4181 4900 803 677 784 4 205 4 088 4 563 23,764 23,840 27,142 5 558 5 576 6 348 1,134 54 1,100 16 176 14 119 12 653 273 190 357 76 105 23,200 2 145 2 921 3 000 74,141 114,795 87,020 27 259 1,595 6,160 3,198 9 572 2 894 1 203 2,173 395 8 781 1471 263 1,050 68,016 71,124 91,387 31,558 33,902 37,205 4,844 4,927 5,716 161,571 147,288 132,686 FY 2021 Adopted 87,000 740,000 30 962 2,324 75 000 108,000 FY 2021 Amended 87,000 835,000 30,962 FY 2022 FY 2021 FY 2021 ProposedI Budget tNet I change % vs Pnor Year 911) Tote; % of Buffet Project 87,000 870,000 31,419 Comments 0.009G 86,625 99.579,0 87000 Annual Meter Re lacements & Meter Testing 130,000 17.57% 663,682 79.48% 835,000 Schedule Capital Replacement 457 1.48% 30 962 100.00% 30 962 2,324 1,404 (920) -39.5994 2,314 99.5796 2,324 75,000 75,000 - 0.00% 75 000 100.00% 75 000 1/10 Major Maintenance, Cost Town's Elevated Storage Tank $45,000 5,327,165 1 483 633 33,000 7 420 8,100 49 358 122,035 6 443 1,098 4 725 32,993 7 716 1,440 14 607 400 300 30,000 15 000 108,000 157 500 10,000 4 000 13,000 3 000 1,500 100,000 40,000 7,500 157,735 200 60 191 216 300 658 1,794 4,349 4,991 352 314 109 1,000 90 2,523 411 1,575 - 3,491 - 5,000 - - - 2,500 30,273 16,545 10,088 45,000 0 4 - 450 274 4,134 2,618 5,000 8,730 7,119 6,525 14,000 122,043 120,053 114,563 114,681 598,738 596,238 673,867 688,005 123,336 125,184 46,000 - 75,000 1,762 791 1,055 2,000 9,009 12,243 8,220 12,500 2,930 2,713 3,732 6,280 19,716 31,632 23,055 25,000 10,449 17,500 1,436 1,143 - 1,200 1,158 1,638 1,167 1,200 600 20,748 18,456 26,446 28,000 28,000 128,991 756,778 324,270 335,000 250,500 - 58,709 79,142 81,273 81,273 3,011 9,458 11,269 8,532 8,532 30,000 30,000 530,899 130,000 130,000 1,500 1,500 - 2,034,586 1 2,750,762 1 2,941,991 1 3,026,690 1 2,781,292 I 3,247,982 I 221, 108,000 113,500 5,500 5.0996 106,707 98.8096 108,000 (2) EST & (2) GST 465,000 33,000 7,420 8,100 49,358 93,300 5,150 800 4,725 30,500 7,200 1,600 16,302 400 300 478,934 33,000 7,956 8,400 56,634 97,013 7,175 1,013 4,800 32,754 7,660 1,764 14,153 400 300 (4,699) 536 300 7,276 (25,022) 732 (85) 75 (239) (56) 324 (454) 85,000 157,500 8,000 4,000 8,500 1,000 1,000 100,000 40,000 7,500 157,735 200 300 3,500 1,000 1,575 1,200 125,000 222,500 9,000 4,600 13,000 3,000 2,000 100,000 40,000 7,500 150,732 (30,000) (15,000) 17,000 65,000 (1,000) 600 500 (7,003) (200) (300) 4,652 (339) (1,000) 1,138 (438) (5,000) (2,500) 45,000 12,000 (33,000) (450) (5,000) 10,000 16,000 2,000 114,681 115,924 1,243 688,005 690,085 2,081 75,000 36 12,500 4,500 25,000 6,500 500 12,500 6,205 32,500 10,000 33,000 665,000 81,878 7,312 130,000 (75,000) (1,500) (75) 7,500 (7,500) (1,200) (1,200) 5,000 330,000 605 (1,220) 0.00% 0.97% 0.00% 7.22% 3.70% 14.74% -20.50% 11.37% -7.76% 1.59% -0.73% -0.73% 22.50% -3.11% 0.00% 0.00% -100.00% -100.00% 15.74% 41.27% -10.00% 15.00% 0.00% 0.00% 33.33% 0.00% 0.00% 0.00% -4.44% -100.00% -100.00% -6.79% -100.00% -27.78% -100.00% -100.00% -73.33% -100.00% -100.00% 14.29% 1.08% 0.30% 0 00% -100.00% -75 00% 0.00% -119% 30.00% -42 86% -100.00% -100 00% 17.86% 98 51% 0.74% -14 30% 0.00% 0 00% 368 355 26,237 7 420 6,450 40119 76,715 4 233 659 4106 24,438 5 715 1,960 13 866 135 0.00% 79.22% 79.51% 100.00% 79.63% 81.28% 82.22% 82.20% 82.42% 86.89% 80.12% 79.38% 122.47% 85.05% 0.00% 45.10% 0.00% 0.00% 70,827 83.33% 112 906 71.69% 46 0.58% 2 708 67.69% 6,464 76.05% 322 32.16% 788 78.75% 74,833 74.83% 32,643 81.61% 4,792 63.90% 118,953 75.41% 0.00% 0.00% 2,705 77.29% 0.00% 0.00% 575 47.94% 0.00% 28,591 63.54% 0.00% 0.00% 8,890 88.90% 104,256 90.91% 625,459 90.91% 0 00% 38,802 51.74% 228 634 65% 11,346 90.77% 4,168 92 62% 18,063 72.25% 4,895 75 31% 0.00% 252 42 00% 25,880 92.43% 157,803 63 00% 81,295 100.03% 8.496 99 58% 130,000 100.00% 0 00% 465 000 33,000 7 420 COLA and Merit Increase Based on Regional CPI, Removal of (1) FTE 8,100 49 358 Increase in Retirement Rate Post -Pandemic Economy 93,300 5 150 800 4 725 30,500 7 200 1,960 TWC Rate Increase For All Government Entities 16 302 400 300 Reclass Cost to Maintenance & Repairs Collections 85,000 Spare Parts Inventory, WWTP Maintenance, Plug Valve, Rotor & Stator, Sludge Feed, Huber Parts, UV Parts 157 500 L5 Maintenance, LS Pumps, I&I, Point Repairs, and Manhole Rehab & Replacement 8,000 4000 1/2 Ton Truck 011 Changes, Tires, & Hoses 8,500 Camera Van, 1 Ton Truck, Vac Truck Oil Changes, Tires, & Hoses 1000 Backhoe 1,000 Adjust Cleaning Schedule 100,000 Sludge Haul Off 40,000 7,500 Cell Phones & Tablets 157,735 200 Reclass Cost to Schools And Training 300 Reclass Cost to Schools And Training 3,500 1,000 Reclass Cost to Maintenance & Repairs 1,575 1,200 Reclass Cost to Maintenance & Repairs 45,000 Decrease Due to Permit Renewal in 2020 - Reclass to Maintenance and Repairs WWTP 10,000 Updated Mowing Schedule 114,681 688,005 75,000 228 Office Chairs 12,500 4,500 25,000 Increase Due To MBR Chemical Cleaning Monthly 6,500 Reallocated Decrease to Chemicals WWTP - Reclass Cost to Maintenance & Repairs 600 Reclass Cost to Maintenance & Repairs 28,000 Increase Due to Lab Equipment Upgrades 242,500 Schedule Capital Replacement 81,273 8.532 130,000 Planned Replacement of Wastewater Infrastructure, MBR 10 -Year Replacement 2,234,770 1 30 145 3,557 29 650 135 2,755 25 24 650 675 105 1,034 920 - 0 00% 0.00% 0 00% - - - - 0.00% 30 10 30 - 0 00% 150 - - (150) -100.00% 750 1,195 750 - 000% 1,300 1,300 1,500 200 15.38% 4,000 - 4,000 - 000% 58 of 69 8 1,195 1,099 0 00% 0.00% 0 00% 0.00% 79 00% 0.00% 100 00% 84.56% 0 00% 10 1,195 1,500 August 16, 2021 Regular Meeting Agenda Packet GENERAL FUND cription Travel & per diem Miscellaneous Expenses (Subtotal Board of Directors Expenses FY 2017 Actual FY 2018 Actual FY 20 FY 2020 ual FY 2021 Adopted FY 2021 FY 2022 Amended Propose Budget vs Prior Year Budget Net Change % 91D Total 7/31/2021 FY 2021 % of Budget FY 2021 Pro)ect(a8t_ Comments (Administration Expenses rSalaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Software & Support Independent Labor Maintenance & Repairs Generator Maintenance & Repairs Building Maintenance & Supplies Cleaning Services Professional Outside Services Utility Billing Contract Telephone Communications/Mobiles Electricity Water Postage Bank Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Elections Advertising Security Miscellaneous Expenses General Manager Contingency Lawn Services Furniture/Equipment < $5000 Uniforms Hardware IT Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing Capital Outlays Copier Lease Installments Ildminlstration Expenses 2,690 4,768 800 - 75 1,474 6.498 9.811 2500 1 1.733 432,978 3,498 3,418 37,687 44,204 3,938 842 4,426 25,994 6,079 294 1,796 701 2,692 383,692 566 3,548 36 819 49,850 3 277 590 3 735 23,075 5 397 1,146 1482 212 4 351 380,629 58 1,833 35 474 51,652 3 409 547 3894 22,675 5 303 60 1239 180 3 165 453,839 50 2,208 41774 80,099 4 436 667 4 307 26,325 6157 1,008 1178 5,000 2,000 13.230 626,592 2 000 2,668 58 550 136,834 7109 1,138 4 730 39,138 9153 1,440 1573 500 3 140 8 000 58 2.5 510,100 74 2,668 50,250 75,850 4,250 625 4,730 30,250 7,050 1,440 1,700 4,000 00 0.00% 500 (1,500) -75.00% 11a . (1,450) -10.96% 567,338 2,000 2,972 61,353 92,393 6,533 819 4,800 35,483 8,298 1,512 1,425 500 4,000 (59,254)- -9.4696- 0.00% 305 11.42% 2,802 4.79% 58 2,360 (44,441) -32.4896 (577) -8.11% (319) -28.0196 70 1.48% (3,655) -9.34% (855) -9.34% 72 5.00% (148) -9.41% 0.00% 100.00% 92.09% 58 409,616 80.30% 510,100 -COLA and Merit Increase Based on Regional CPI, Removal of (2) FTE 80 107.72% 80 2,668 100.00% 2,668 40 790 81.1796 50 250 64,144 84.57% 75,850 Increase in Retirement Rate Post -Pandemic Economy 3 549 83.50% 4 250 526 84.23% 625 4063 85.89% 4730 24,197 79.99% 30,250 5 659 80.27% 7 050 1,512 105.00% 1285 75.59% 0.00% 3422 85.55% 4000 0.00% 80469 83.39% 96500 Schedule Information Technology 14,573 72.86% 20,000 Human Resource Management 71 518 66.19% 71 518 Admin Building, Annex Building, & Parking Lots 0.00% 0.00% 14,511 96.74% 15,000 Adjust Cleaning Schedule 82 690 78.81% 104 925 IT Services 5,448 60.53% 6 580 82.25% 2,250 75.00% 3,000 11928 82.20% 14 512 3,052 81.39% 3,750 100% Mud Water Bill No Longer Spilt 16 508 55.03% 30000 Prepaid Postage For Meter, Monthly Meter Lease 67,643 82.49% 0.00% 67,249 80.06% 183 73.36% 6,017 100.28% 289 120.47% 3,063 100.00% 3,304 82.60% 301 50.18% 0.00% 9,330 100.00% 0.00% 264 20.50% 392 78.40% 0.00% 3,073 61.46% 5,000 Updated Mowing Schedule - 0.00% - Replace Office Furniture 0.00% 1,000 20,339 100.00% 20,339 Replacing Out of Warranty and Unsupported Hardware 3,573 89.32% 4,000 All Departments Combined - 0.00% - Reclass to Office Supplies 3,624 90.60% 4,000 All Departments Combined Cleaning and Paper Goods 0.00% 88,915 68.41% 200,000 Schedule Capital Replacement 0.00% (4,000) -50.00% 1,512 TWC Rate Increase For All Government Entities 1 700 Departmental Expenses egal IAudmng Appraisal (Tax Admin Fees !Subtotal Non Departmental Expenses 88,943 30,925 826 485 7,705 6,705 63,965 7,514 14,081 3,621 11,002 1,041 27,334 52,782 1,674 59,614 770 4,851 122 4,972 2,255 7,112 2,961 2,323 503 68 007 153,669 10 584 5,205 139 396 152,578 5 676 124 037 90,481 18 794 928 1,169 126 854 15,000 40 000 10,000 96,500 20,000 108,050 3,000 122,310 15,000 40,000 3,000 0.00% (4,544) -3.58% 0.00% 0.00% (7,000) -70.00% 0.00% 1,056 475 2,300 5,353 754 3,985 2,593 129,301 3,929 1,122,380 1 18,762 18,809 10,713 2,562 10,046 62 300 7,063 18 246 2,986 6 591 719 21120 62,356 10,429 69 427 6,974 17 696 2,853 6 792 682 21 652 66,236 76,999 75,633 360 - 3,988 4,269 134 176 561 3,238 1,172 1,677 218 220 925 442 169 17,000 212 747 6,802 5,331 2,365 4,199 144 48,355 3,231 1,123,16f1 51,171 25,659 10,696 2,968 1,222 288 124 1,579 746 5,526 6,651 17,143 15,000 57 100 104 925 7,132 9,000 24 055 9 680 2,784 3,000 6 315 14 512 1,945 5,000 20 402 30 000 73,964 67,000 16,874 1,500 79,988 84,000 125 1,000 4,607 6,000 149 400 1,875 6,000 3,018 6,850 1,205 3,575 200 138 5,000 6,112 2,500 264 1,288 6,096 500 17,000 5,000 2,027 2,500 2,050 24,611 20,253 5,383 6,000 15,000 104,925 9,000 8,000 3,000 14,512 3,750 30,000 82,000 1,500 84,000 250 6,000 240 3,063 4,000 600 12,000 61,100 9,000 8,500 3,000 15,213 5,000 30,000 85,000 1,500 84,000 6,000 2,000 5,250 1,588 9,330 5,000 1,288 500 17,000 5,000 1,000 20,339 4,000 4,849 4,596 4,000 4,000 2,500 - 67,391 156,107 138,000 129,975 3,306 3,027 4,000 4,000 1,185,147 1 1,386,708 1 1,669,510 1 1,486,808 38,579 26,460 11,057 3,653 109,011 31,908 11,909 3,756 35,000 33,800 11,925 4,850 50,000 26,000 11,925 4,850 2,500 5,000 10,000 530 21,400 6,000 4,000 120,000 4,000 1,477,317 I (192,193 (3,000) -20.0096 (43,825) -41.77% 0.00% (1,180) -12.19% 3,000 - Reclass to Maintenance & Repairs 0.00% 701 4.83% 0.00% 0.00% 18,000 26.87% 0.00% 0.00% (1,000) -100.0096 0.00% (400) -100.0056 (4,000) -66.67% (1,600) -23.36% (1,988) -55.59% (200) -100.0056 0.00% 0.00% (1,288) -100.00% (500) -100.0056 (17,000) -100.00% 0.00% 7,500 300.00% (1,520) -74.15% 1,147 5.66% 0.00% 0.00% 0.00% (2,500) -100.00% (18,000) -13.04% 0.00% 135,000 33,800 12,055 4,850 130 0.00% 0.00% 1.09% 0.00% X07% 9,000 Cost For Printing Monthly Statements 8 000 82,000 Increase Online Payments/Increase Payment Fees 1,500 84,000 Projected TML Increase 5% 250 Reclass to Schools and Training 6,017 TX Comp, TML, NCTCOG, TRWA, GFOA, GFOAT, ICMA, TCMA, ASPA, APWA 289 3,063 4,000 600 9,330 Mud Board Election 1,288 Reclass to Software and Support 500 2,579 64.48% 4,000 27,090 21,000 8,974 3,821 54.18% 80.77% 75.26% 78.78% 50,000 26,000 11,925 4,850 (Total General Fund Revenues I`y Total General Fund Expenses Net Budget Surplus (Deficit) $ 8,957,220 $ 7.196.250 $ 1,760,970 $ 10,897,878 $ 7.424.061 $ 3,473,817 $ 9,525,452 $ 8,748,253 $ 777,200 $ 9,661,678 $ 8,897,786 $ 763,892 $ 10,227,277 $ 10,222,170 $ 5,107 $ 9,703,255 $ 10,185,089 $ 9,357,258 $ 10,185,089 $ 345,998 $ - $ (42,188) $ (37,081) $ (5,107) -0.41% -0.36% $ 7,440,355 $ 6,978,681 $ 461,674 76.68% 74.58% $ 9,667,687 $ 9,367,196 $ 300,491 59 of 69 Appraisal Fees Tarrant County $2,800; Denton County $9255 Tax Admin Fees At $1 Per Parcel August 16, 2021 Regular Meeting Agenda Packet FIRE DEPARTMENT Description FY 2019 Actual FY 2020 Actual FY 2021 Adopted FY 2021 Amended FY 2021 Projected FY 2022 Proposed Budget % Change Revenues -Town Assessment - Emerg Svcs Emer Svcs Assessment/Delinquent Property Taxes/Assessments P&I Fire Permits/Sprinkler & Plan Review Fire Inspections Denton/Tarrant County Pledge -Fire Grant Revenue 500,667 513,618 57,841 47,977 7,367 17,072 17,009 510,812 512,258 35,000 35,000 16,000 17,072 510,808 528,546 3.18% 0.00% 0.00% 5,000 5,000 -85.71% - 0.00% 17,072 17,000 -0.42% 0.00% Revenues -MUD Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&I Capital Leases -Other Financial Sources Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Miscellaneous Income Total Revenue Expenses -Town Salaries- Regular Salaries- Part Time Salaries- Merits Salaries- Overtime Salaries- Longevity Salaries- Stipend Certification Pay Salaries- Cell Phone Stipend Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Physicals/Testing Tuition Reimbursement Professional Outside Services Software & Support Tax Administration Advertising Printing Schools & Training Electricity Water Telephone Communications/Mobiles Building Maintenance Vehicle Maintenance 1 1 1 1 1,103,690 1,223,805 1,246,877 1,246,877 1,246,877 1,269,330 1.80% 3,166 3,736 - 32,399 - 0.00% 5,126 6,897 - 3,336 - 0.00% - - 0.00% - - 0.00% - 57,700 0.00% - 0.00% 135,611 24,423 - - - 0.00% 1,813,468 1,854,538 1,808,689 1,811,207 1,815,492 1,877,576 3.66% 665,043 671,577 670,420 711,424 695,199 709,025 -0.34% 50,078 50,078 54,071 50,078 0.00% - - 13,550 0.00% 91,609 75,008 72,896 93,476 118,359 84,405 -9.70% 6,358 6,838 6,730 6,730 7,343 7,254 7.79% - 1,875 1,875 - -100.00% 7,564 9,063 9,750 9,750 9,700 11,438 17.31% - - 1,800 0.00% 103,227 100,538 106,114 106,114 112,516 110,223 3.87% 93,982 76,605 78,087 78,087 76,059 74,102 -5.10% 5,447 5,514 6,045 6,045 5,594 5,582 -7.66% 599 525 576 576 512 539 -6.42% 3,989 4,087 5,171 5,171 4,642 5,635 8.97% 46,593 44,880 51,123 51,123 52,558 52,084 1.88% 10,893 10,496 11,956 11,956 12,288 12,182 1.89% 291 426 1,625 1,625 2,394 2,442 50.28% 9,638 15,004 20,177 20,177 17,842 17,816 -11.70% 3,117 3,867 6,675 6,675 4,033 5,960 -10.71% 3,289 1,497 8,290 8,290 5,637 8,290 0.00% 550 1,750 1,750 2,089 1,750 0.00% 12,123 12,495 17,164 17,164 16,854 17,164 0.00% 1,529 1,605 1,605 2,028 1,605 0.00% 1,500 1,500 - 1,500 0.00% 219 141 500 500 373 500 0.00% 12,887 14,427 19,900 19,900 11,364 19,900 0.00% 4,790 4,970 8,400 8,400 4,818 8,400 0.00% 2,823 3,935 4,000 4,000 3,114 4,000 0.00% - - - 0.00% 12,792 12,345 16,691 16,691 20,378 16,691 0.00% 24,520 22,727 22,200 22,200 14,995 22,200 0.00% 46,433 31,865 40,800 40,800 12,590 40,800 0.00% 60 of 69 August 16, 2021 Regular Meeting Agenda Packet FIRE DEPARTMENT Description FY 2019 Actual FY 2020 Actual FY 2021 Adopted FY 2021 Amended FY 2021 Projected FY 2022 Proposed Budget % Change Equipment Maintenance 11,202 5,719 18,000 18,000 7,984 18,715 3.97% Emergency Management 1,000 1,000 1,000 1,000 1,333 1,000 0.00% Dispatch- Denton County 3,706 3,986 3,946 3,946 5,261 4,020 1.88% Dues & Memberships 19,616 19,782 20,337 20,337 21,854 20,337 0.00% Flags & Repair 9,441 - - - - - 0.00% Travel & per diem 11,153 5,326 14,510 14,510 12,801 14,510 0.00% Office Supplies 317 390 500 500 319 500 0.00% Printer Supplies 1,020 - 1,400 1,400 1,175 1,400 0.00% Postage 82 31 100 100 89 100 0.00% Publications/Books/Subscripts 344 334 350 350 - 350 0.00% Fuel 10,611 6,959 12,215 12,215 8,630 12,215 0.00% Uniforms 5,787 7,001 9,645 9,645 10,052 9,645 0.00% Safety Equipment/Protective Clothing 31,343 24,353 27,700 27,700 361 27,700 0.00% Small Equipment 6,428 3,591 4,950 4,950 215 4,950 0.00% Hardware 3,268 2,592 4,458 4,458 1,272 4,458 0.00% Maintenance & Supplies 444 1,113 1,500 1,500 - 1,500 0.00% Miscellaneous Expense 3,949 27,936 4,000 4,000 1,759 4,000 0.00% Capital Outlays - - - - - - 0.00% Programs & Special Projects 13,309 18,023 17,005 17,005 4,714 16,931 -0.44% Expenses -MUD Maintenance & Repairs (GASB34) 5,900 - - - - 0.00% Rent And/or Usage 215,979 218,004 197,281 197,281 197,281 198,761 0.75% Insurance 17,895 19,691 21,000 21,000 19,800 21,000 0.00% Capital Outlays 64,482 39,743 - - - - 0.00% Short Term Debt -Interest 11,958 9,078 6,127 6,127 6,127 3,101 -49.38% GASB34/Reserve for Replacement 81,420 81,420 81,420 81,420 81,420 81,420 0.00% Capital Leases- Principal 115,190 118,070 121,022 121,022 121,022 124,047 2.50% Total 1,810,249 1,748,871 1,808,689 1,872,148 1,772,694 1,877,576 0.29% Total Fire Revenues $ 1,813,468 $ 1,854,538 $ 1,808,689 $ 1,811,207 $ 1,815,492 $ 1,877,576 3.66% Total Fire Expenses $ 1,810,249 $ 1,748,871 $ 1,808,689 $ 1,872,148 $ 1,772,694 $ 1,877,576 0.29% Net Budget Surplus (Deficit) $ 3,219 $ 105,667 $ - $ (60,941) $ 42,798 $ - Town/MUD Fire Contract Calculation FY 2021 FY 2022 Fire Budget 1,808,689 1,877,576 Less: Rent/Debt Service 197,281 198,761 Less: TML Fire Insurance 21,000 21,000 Less: Capital Outlays - - Less: Capital Leases Interest 6,127 3,101 Less: Capital Leases Principal 121,022 124,047 Less: GASB34/Reserve for Replacement 81,420 81,420 Less: ESD Assessment 510,812 528,546 Less: Fire Permits/Sprinkler 35,000 5,000 Less: Fire Inspections - - Less: Denton County Fire Pledge 16,000 17,000 Less: Grant Proceeds - - Transfer to Town from MUD/Fire Budget $ 820,027 $ 898,700 Monthly payment to Town Oct -Sept $ 68,336 $ 74,892 61 of 69 MUD/PID Paid 1 Par Principal FY22 1 Interest 3/01 i Interest 9/01 1 Subtotal Interest Paying Agent Fee 1 Total 1 Maturity Date i First Callable Date Project/Reason Series 2010 (Tax) MUD $2,000,000 $0 $0 $0 $0 $0 $0 9/1/2021 N/A Trophy Club Fire Station and costs related to the issuance of the Bonds. Refund 2020 Series 2012 (Tax) MUD $2,355,000 $240,000 $7,350 $7,350 $14,700 $500 $255,200 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 $210,000 $6,913 $6,913 $13,825 $500 $224,325 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. Series 2020 (Tax) MUD $1,220,000 $115,000 $7,833 $7,833 $15,665 $750 $131,415 9/1/2031 9/1/2031 Refund MUD #1 Unlimited Tax Bonds Series 2010 and costs related to the issuance of the Bonds, Trophy Club Fire Station and costs related to the issuance of the Bonds. SUBTOTAL MUD -ONLY TAX BONDS: $20,945,000 $7,480,000 $565,000 $22,095 $22,095 $44,190 $1,750 $610,940 Series 2014 (Tax) MUD/PID $5,765,000 $270,000 $62,006 $62,006 $124,013 $400 $394,413 9/1/2034 9/1/2024 Tax Bonds for Wastewater Plant Expansion Issued 10/1/2014 SUBTOTAL ALL MUD/PID TAX BONDS: $5,765,000 $270,000 $62,006 $62,006 $124,013 $400 $394,413 TOTAL ALL TAX BONDS: $13,245,000 $835,000 $84,101 $84,101 $168,203 $2,150 $1,005,353 TAX DEBT PAYMENTS LONG TERM TAX DEBT August 16, 2021 Regular Meeting Agenda Packet LONG TERM REVENUE DEBT REVENUE DEBT PAYMENTS MUD/PID Paid Par 1 Principal FY 22 Interest 3/01 Interest 9/01 Subtotal Interest l Paying Agent Fee Total 1 Maturity Date l First Callable Date Project/Reason Series 2015 (Revenue) WWTP $9,230,000 $410,000 $96,219 $96,219 $192,438 $400 $602,838 9/1/2035 9/1/2025 Revenue Bonds for WWTP Expansion Series 2016 (Revenue) SWIFT $4,635,000 $220,000 $28,482 $28,482 $56,965 $400 $277,365 9/1/2036 9/1/2027 Revenue Bonds for Fort Worth Line NSII Camera Van $205,504 $40,230 $2,922 $2,529 $5,451 $45,681 2/1/2024 Replacement Revenue Bonds for 16in Water Line (77%) and Series 2019 (Revenue) Water & Waste Water Systems $565,604 $7,080,000 $160,000 $109,469 $109,469 $218,938 $400 $379,338 9/1/2049 9/1/2028 Overrun for WWTP Expansion (23%) TOTAL ALL REVENUE BONDS: $20,945,000 $790,000 $234,170 $234,170 $468,340 $1,200 $1,259,540 SHORT TERM REVENUE DEBT CAPITAL LEASE PAYMENTS MUD/PID Paid Original PAR 1 Principal FY 22 Interest 2/01 Interest 8/01 Subtotal Interest Total Payoff Date Project/Reason Department Vaccon Truck (Water usage 43%) $154,843 $31,419 $934 $470 $1,404 $32,823 2/1/2023 Replacement Water Vaccon Truck (WW usage 57%) $205,257 $41,648 $1,238 $623 $1,861 $43,509 2/1/2023 Replacement Wastewater Camera Van $205,504 $40,230 $2,922 $2,529 $5,451 $45,681 2/1/2024 Replacement Wastewater Total: $565,604 $113,297 $5,094 $3,623 $8,716 $122,013 62 of 69 August 16, 2021 Regular Meeting Agenda Packet CAPITAL OUTLAYS Category FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 Notes Water Water Line Replacement $ 575,000 $ 632,500 $ 695,750 $ 765,325 $ 841,858 Totals Based on Approximate Escalator Inflation Pump Head Discharge $ 25,000 $ 25,000 $ - $ - $ - Replace #2 and #4 Valve Replacement/Addition $ 50,000 $ 55,000 $ 60,000 $ 65,000 $ 70,000 Yearly Change Out SCADA Upgrade $ 100,000 $ - $ - $ - $ - New District SCADA System Concrete Pad for Dumpster $ 30,000 $ - $ - $ - $ - Barn Repairs $ 25,000 $ - $ - $ - $ - Add Office in Barn & Update Exterior Fencing $ 15,000 $ 30,000 $ 15,000 $ - $ - Well Fence Improvements Fleet Replacement $ 50,000 $ 35,000 $ 41,000 $ - $ - I Water Grand Totals $ 870,000 $ 777,500 $ 811,750 $ 830,325 $ 911,858 WASTEWATER LS #1 Upgrades $ 300,000 $ - $ - $ - $ - Lift Station #1 Access Easement WWTP Crane $ 15,000 $ - $ - $ - $ - WWTP Crane Modification MBR Return Pumps $ 85,000 $ - $ - $ - $ - SCADA Upgrade $ 100,000 $ - $ - $ - $ - New District SCADA System Permeate Pump Piping $ 60,000 $ - $ - $ - $ - Lift Station Fencing $ 20,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 Lift Station Fence Improvements Lift Station Generators $ 85,000 $ 85,000 $ 85,000 $ - $ - Lift Station #2 and #5 Fleet Truck Replacement $ - $ 35,000 $ 35,000 $ - $ - Wastewater Grand Totals $ 665,000 $ 125,000 $ 125,000 $ 5,000 $ 5,000 ADMIN New ERP System Deployment $ 100,000 $ - $ - $ - $ - Enterprise Resource Planning (UB/Accounting Software) Pavement and Driveway Repair $ 20,000 $ 20,000 $ - $ - $ - Admin MUD Building Fleet Replacement $ - $ 35,000 $ - $ - $ - Admin Grand Totals $ 120,000 $ 55,000 $ - $ - $ - 63 of 69 August 16, 2021 Regular Meeting Agenda Packet WATER ACTUALS & PROJECTION CHARTS 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 Consumption in (Thousand) Gallons 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 70,000 65,000 60,000 55,000 50,000 45,000 40,000 35,000 30,000 25,000 20,000 15,000 10,000 5,000 Total Connections 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $- Revenue by Year 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 24,000 22,000 20,000 18,000 16,000 14,000 12,000 10,000 8,000 6,000 4,000 2,000 Consumption Per Connection by Year 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 64 of 69 Account 135-55160-030 Professional Outside Services August 16, 2021 Regular Meeting Agenda Packet INFORMATION TECHNOLOGY I Description 1 1 Amount 1 Description M3- It & Cell Phone Support, includes Mobile Client $ 61,100 Totals: $ 61,100 135-55030-030 Description Software & Support Used R For Recurring, NR For Non -Recurring. R -Internet Connectivity- Charter Spectrum $ 12,000 R -Internet Connectivity -ATT (Backup & WWTP) $ 2,000 R -Internet Connectivity -Pump Room at Water Plant/SCADA $ 1,000 R- M3- Microft Office 365 Licenses $ 6,300 R- ERP/Budget Annual Software Plus Support $ 59,000 R -Clear Rec Annual Maintenance $ 600 Notifcations (Dail My Calls) $ 2,000 R -Web Hosting (Gov) $ 1,000 R -Web Maintenance (Domains, SSL Cert, etc) $ 1,200 R- Adobe Licenses/Support $ 600 R-Timeclock Plus License and Support $ 1,500 R- MCCI Annual Support Online Records $ 5,200 R -Annual Support for Website -Four Man Furnace $ 2,000 R- Meter Support $ 1,500 R-AudioTel Remit Plus Annual Support $ 2,000 R-AudioTel Annual Scanner Support $ 600 R-SCADA Support (Includes Win -911) $ 1,000 R- Monitoring Service $ 310 R -3RD Eye Secutiry Support $ 2,500 R- Element Annual CMMS License Fee $ 10,000 R- Halff GIS/CMMS Hosting and Annual Software Support $ 10,000 NR- VMWare Software & Support (3 yrs support) $ - Totals: $ 122,310 135-60005-030 Description Telephone R- 8x8 Phone System $ 5,500 R-Afterhours answering service $ 3,000 Phone System Maintenance/Replacement $ - Totals: $ 8,500 135-60235-030 Description Security $ Totals: 135-65055-030 Description Qty Per Item Hardware Replacement Hardware: 135-65105030 Printing 135-65090-030 Printer Supplies Dell Laptop Dell Docking Station Dell Monitor Dell Monitor Stand Dell Desktop Keyboard/Mouse combo Network SAN ( Warranty Renewal) Server Printers Totals: Totals: Description Events or Special Mailers 2 $ 2 $ 4 $ 2 $ 2 $ 2 $ Description Toner and Cartridges $ Totals: Copier Lease & Copies Totals: Grand Total: 135-69170-030 Copier Rental/Lease Description 65 of 69 Amount 1,900 $ 3,800 200 $ 400 200 $ 800 200 $ 400 1,350 $ 2,700 150 $ 300 6,500 $ 13,000 $ 13,000 - $ $ 21,400 4,000 $ 4,000 $ 217,310 August 16, 2021 Regular Meeting Agenda Packet WATER DISTRICT NOTICE OF PUBLIC HEARING ON TAX RATE The Trophy Club Municipal Utility District No. 1 will hold a public hearing on a proposed tax rate for the tax year 2021 on Monday, September 20, 2021 at 6:3o p.m. at the Svore Municipal Building, 100 Municipal Drive, Trophy Club, Texas. Your individual taxes may increase at a greater or lesser rate, or even decrease, depending on the tax rate that is adopted and on the change in the taxable value of your property in relation to the change in taxable value of all other property. The change in the taxable value of your property in relation to the change in taxable value of all other property determines the distribution of the tax burden among all property owners. FOR the proposal: AGAINST the proposal: PRESENT and not voting: ABSENT: The following table compares taxes on an average residence homestead in this taxing unit last year to taxes proposed on the average residence homestead this year. Last Year This year Total tax rate (per $100 of value) $0.10774/$100 $0.10888/$1oo Adopted Proposed Difference in rates per $100 of value ($0.(0186)/$1oo Percentage increase/decrease in rates (+/-) (1.73%) Average appraised residence homestead value $467,046 $491,790 General homestead exemptions available (excluding 65 years of age or older or disabled person's exemptions) Average residence homestead taxable value Tax on average residence homestead Annual increase/decrease in taxes if proposed tax rate is adopted (+/-) and percentage of increase (+/-) $1,5o5 $4,172 $465,541 $487,618 $5o1.57 $516.29 $14.72 2.93% NOTICE OF VOTE ON TAX RATE If the district adopts a combined debt service, operation and maintenance and contract tax rate that would result in the taxes on the average residence homestead increasing by more than 3.5 percent, an election must be held to determine whether to approve the operation and maintenance tax rate under Section 49.23602, Water Code. The 86th Texas Legislature modified the manner in which the voter -approval tax rate is calculated to limit the rate of growth of property taxes in the state. 66 of 69 August 16, 2021 Regular Meeting Agenda Packet 2021 Developed Water District Voter -Approval Tax Rate Worksheet Trophy Club Municipal Utility District No. 1 Water District Name 100 Municipal Drive, Trophy Club TX. 76262 Water District's Address, City, State, ZIP Code Form 50-860 682-831-4600 Phone (area code and number) TCMUD.org Water District's Website Address GENERAL INFORMATION: The Comptroller's office provides this worksheet to assist water districts in determining their voter -approval tax rate. The information provided in this worksheet is offered as technical assistance and not legal advice. Water districts should consult legal counsel for interpretations of law regarding tax rate preparation and adoption. SECTION 1:Voter-Approval Tax Rate The voter -approval tax rate for developed water districts is the current year's debt service, contract and unused increment tax rates plus the maintenance and operation (M&O) tax rate that would impose no more than 1.035 times the amount of M&O tax imposed by the water district in the preceding year on the average appraised value of a residence homestead in the water district. The average appraised value disregards any homestead exemption available only to people with disabilities or those age 65 or older. The calculation process starts after the chief appraiser delivers to the taxing unit the certified appraisal roll or certified estimate of value and the estimated values of properties under protest. The designated officer or employee shall certify that the officer or employee has accurately calculated the tax rates and used values shown for the certified appraisal roll or certified estimate. The officer or employee submits the rates to the governing body by Aug. 7 or as soon thereafter as practicable. If any part of the developed water district is located in an area declared a disaster area during the current tax year by the governor or by the president, the board of the district may calculate the voter -approval tax rate in the manner provided in Water Code Section 49.23601(a) and determine whether an election is required to approve the adopted tax rate in the manner provided in Water Code Section 49.23601(c). In such cases, the developed water district may use Comptroller Form 50-858 Water District Voter -Approval Tax Rate Worksheet for Low Tax Rate and Developing Districts to calculate its voter -approval tax rate. Line Worksheet Amount/Rate 1. 2. 3. 4. 5. 6. 7. 8. 10. 11. 12. 13. 14. 2020 average appraised value of residence homestead. 2020 general exemptions available for the average homestead. Excluding age 65 or older or disabled persons exemptions.' 2020 average taxable value of residence homestead. Line 1 minus Line 2. 2020 adopted M&O tax rate. 2020 M&O tax on average residence homestead. Multiply Line 3 by Line 4, divide by $100. Highest M&O tax on average residence homestead with increase. Multiply Line 5 by 1.035.' 2021 average appraised value of residence homestead. 2021 general exemptions available for the average homestead. Excluding age 65 or older or disabled persons exemptions. 2021 average taxable value of residence homestead. Line 7 minus Line 8. Highest 2021 M&O tax rate. Line 6 divided by Line 9, multiply by 5100.5 2021 debt tax rate. 2021 contract tax rate. 2020 unused increment rate. Subtract the 2020 actual tax rate and the 2020 unused increment rate from the 2020 voter -approval tax rate. If the number is less than zero, enter zero. 2019 unused increment rate. Subtract the 2019 actual tax rate and the 2019 unused increment rate from the 2019 voter -approval tax rate. lithe number is less than zero, enter zero. If the year is prior to 2020, enter zero. ' Tex. Water Code § 49.236(a)(2)(C) Tex. Water Code § 49.236(a)(2)(D) Tex. Water Code § 49.23602(a)(2)(A) ' Tex. Water Code § 49.236(a)(2)(E) Tex. Water Code § 49.236(a)(2)(F) Form developed by: Texas Comptroller of Public Accounts, Property Tax Assistance Division 67 of 69 467,046 $ 1.505 465.541 5 0.07185 /slop 334 $ 346 491,790 4,172 487,618 0.07099 /5100 $ 0.03489 /5100 0.00000 /5100 $ 0.00000 /5100 0.00000 /5100 For additional copies, visit: comptroller.texas.gov/taxes/property-tax 50-860 • 6-21/2 2021 Developed Water District Voter -Approval Tax Rate Worksheet August 16, 2021 Regular Meeting Agenda Packet Form 50-860 Amount/Rate 15. 2018 unused increment rate. Subtract the 2018 actual tax rate and the 2018 unused increment rate from the 2018 voter -approval tax rate. If the number is less than zero, enter zero. If the year is prior to 2020, enter zero. 16. 2021 total unused increment rate. 6 Add Lines 13,14 and 15. 17. 2021 voter -approval tax rate. Add lines 10,11,12 and 16. $ 0.00000 /5100 $ 0.00000 /5100 $ 0.10588 /5100 SECTION 2: Mandatory Tax Election Rate The mandatory tax election rate is the highest total tax rate a developed water district may adopt without holding an election. The mandatory tax election rate is the rate that would impose 1.035 times the amount of tax imposed by the district in the preceding year on the average appraised value of a residence homestead in the water district plus the unused increment rate. The average appraised value disregards any homestead exemption available only to people with disabilities or those age 65 or older.' Worksheet Amount/Rate 18. 2020 average taxable value of residence homestead. Enter the amount from Line 3. 19. 2020 adopted total tax rate. 465,541 0.10774 /$100 20. 2020 total tax on average residence homestead. Multiply Line 18 by Line 19. 21. 2021 mandatory election amount of taxes per average residence homestead. Multiply Line 20 by 1.035. 22. 2021 mandatory election tax rate, before unused increment. Divide Line 21 by Line 9 and multiply by $100. 23. 2021 mandatory tax election rate. Add Line 16 and Line 22. 502 519 0.10646 /5100 0.10646 /5100 SECTION 3:Taxing Unit Representative Name and Signature Enter the name of the person preparing the voter -approval tax rate and mandatory tax election rate as authorized by the governing body of the water district. By signing below, you certify that you are the designated officer or employee of the taxing unit and have calculated the tax rates in accordance with requirements in Water Code.' here rint* Steven Krolczyk Printed Name of Water District Representative sign here ir Water District Representative Tex. Tax Code § 26.013 ' Tex. Water Code § 49.23602(a)(2) Tex. Water Code § 49.23602 8/11/21 Date For additional copies, visit: comrtfegitrdt§xas.gov/taxes/property-tax Page 2 TC Meeting Spaces Calendars Svore Board Room September n Sun Mon Tue s Aug 29, 2021 30 31 3 5 6 7 8 Wed Sep 1 August 16, 2021 Regular Meeting Agenda Packe? Modifier Thu 2 8 9 Fri Sat 3 4 12 13 9 19 14 15 16 17 11 18 20 6:30pm fJ Board of D 21 22 23 24 ® 26 27 28 69 of 69 29 30 Oct 1 25 2 Powered by ::: teamup