The URL can be used to link to this page

Home My WebLink About2021-1214 December 14, 2021 Complete Agenda PacketTROPHY CLUB MUNICIPAL UTILITY DISTRICT December 14, 2021 Complete Agenda Packet BOARD OF DIRECTORS REGULAR MEETING TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 Tuesday, December 14, 2021 6:30 P.M. Svore Municipal Boardroom REGULAR MEETING AGENDA 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. November 2021 Combined Financials b. November 15, 2021, Regular Meeting Minutes attachments: Combined Financials Meeting Minutes REGULAR SESSION 1of61 December 14, 2021 Complete Agenda Packet 3. Consider and act regarding approval of work order with Pipeline Analysis, LLC for professional engineering services related to the District wastewater collection system and authorize the General Manager to execute the necessary work order documents. attachment: Staff Report 4. Consider and act regarding approval of Contract No. 2021121401 with Core Construction for services related to the construction of office space within the water maintenance facility and authorize the General Manager to execute the contract documents. attachments: Staff Report 5. Consider and act regarding approval of proposal by Prime Controls, LP for services related to the District supervisory control and data acquisition (SCADA) system and authorize the General Manager to execute the necessary documents to implement Board action. attachments: Staff Report 6. Items for future agendas: 7. Future Meeting dates —January 19, 2022, at 6:30 p.m. February 22, 2022, at 6:30 p.m. attachment: January 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 DISTRICTS PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 2of61 December 14, 2021 Complete Agenda Packet Monthly Water Operations Report Water Billed FY October November December January February March April May June July August September Total Year 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 98,232 57,380 40,841 42,725 40,786 41,078 67,776 50,736 64,195 100,853 97,864 112,674 815,140 2022 78,390 54,635 ' ■ 133,025 140,0 1 ■ 120,000 100,000 80,000 60,000 40,000 20,000 0 M. October November De WATER BILLED IN THOUSANS OF GALLONS 2018 2019 2020 - 2021 - 2022 July August September Water Pumped FY October November December January February March April May June July August September Total Year 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 106,660 66,304 46,962 50,538 47,733 44,191 75,866 56,985 73,907 113,015 109,492 123,206 914,859 2022 91,078 61,928 ■ Ml 153,006 F 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 WATER PUMPED IN THOUSANDS GALLONS 2018 - 2019 - 2020 - 2021 - 2022 Active Connections FY October I November December January February March April May June July August September 2017 Total 4644 1 4647 4661 4657 4663 4666 4670 4676 4685 4690 4696 4700 2018 Total 4701 1 4706 4712 4716 4720 4724 4724 4728 4732 4735 4736 4738 2019 Total 4741 1 4743 4745 4753 4753 4758 4761 4762 4768 4770 4773 4782 2020 Total 4795 4796 4797 4797 4807 4807 4816 4817 4830 4836 4836 4837 2021 Total 4837 4837 4837 4837 4837 4837 4837 4837 4839 4841 4841 4840 2021 MUD 3393 3393 3393 3393 3393 3393 3393 3393 3395 3397 3397 3396 2021 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 2022 Total 4841 4841 2022 MUD 3397 3398 2022 PID 1444 1443 3 of 61 Date 1 -Nov 4 -Nov Ammonia -N Influent Effluent 52.5 0.20 58.0 0.20 8 -Nov 58.0 11 -Nov 58.0 15 -Nov 61.2 18 -Nov 50.0 22 -Nov 65.8 23 -Nov 58.8 1 Report 1 Removal 99.6% 99.7 0.20 99.7% 0.20 99.7% 0.20 99.7% 0.20 99.6% 0.20 99.7% 0.20 99.7% Ammonia -N 0.20 99.7% December 14, 2021 Complete Agenda Packet November 2021 Results CBOD5 TSS % Removal Influent Effluent Influent Effluent 302 2.0 99.3% 346 1.0 283 2.0 99.3% 318 1.0 282 2.0 99.3% 287 1.0 290 2.0 99.3% 247 1.0 292 2.0 99.3% 302 1.0 294 2.0 99.3% 342 1.0 290 2.0 99.3% 374 1.0 298 2.0 99.3% 268 1.0 CBOD5 2.0 1 99.3% 4of61 Removal 99.7 99.7 99.7 99.6% 99.7 99.7 99.7 99.6% TSS 1.0 1 99.7% 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 December 14, 2021 Complete Agenda Packet Ammonia Nitrogen Permit Limit 3 (Jan - March) 0.20 0.20 0.20 0.205 0.378 Permit Limit 3 (Sept. - Dec.) Permit Limit - 1 from April - August 0.295 0.225 0.209 0.20 0.20 0.2 0.2 0.2 Nov 20 Dec 20 Jan 21 Feb 21 Mar 21 Apr 21 May 21 Jun 21 Jul 21 Aug 21 Sep 21 Oct 21 Nov 21 99.6% 99.6% 99.6% 98.7% 99.4% 99.5% 99.4% 99.5% 99.5% Carbonaceous Biochemical Demand (CBOD5) 99.6% 99.6% 99.7% 99.7% 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 Nov 20 Dec 20 Jan 21 Feb 21 Mar 21 Apr 21 May 21 Jun 21 Jul 21 Aug 21 Sep 21 Oct 21 Nov 21 99.4% 93.3% 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 5of61 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 December 14, 2021 Complete 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 Nov 20 Dec 20 Jan 21 Feb 21 Mar 21 Apr 21 May 21 Jun 21 Jul 21 Aug 21 Sep 21 Oct 21 Nov 21 99.6% 99.6% 99.5% 99.5% 99.6% 99.5% 99.6% 99.4% 99.5% 99.6% 99.6% 99.6% 99.7% Nitrate - Nitrogen Permit Limit 24 5.8 5.1 5.8 5.1 5.65.25 5.55.21 5.85.27 5.5 5.35 5.0 5.42 5.95.49 4.7 5.1 5.15.51 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 7.3 5.64 1 5.7 5.65 6.2 5.7 Nov -20 Dec -20 Jan -21 Feb -21 Mar -21 Apr -21 May -21 6of61 Jun -21 Jul -21 Aug -21 Sep -21 Oct -21 Nov -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 December 14, 2021 Complete 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.1- I- I1 1 11111111 1111 Nov -20 Dec -20 Jan -21 Feb -21 Mar -21 Permit Limit High 9 Apr -21 May -21 Jun -21 Jul -21 Potential for Hydrogen (pH) Aug -21 Sep -21 Permit Limit Low 6 Oct -21 Nov -21 7.86 7.79 7.67 7.71 7.71 -.75 7.59 7.66 7.64 7.66 7.64 7.63 I 7.64 7.59 7.46 7.51 7.58 7.57 1 7.53 7.52 7.36 7.35 7'4 7.39 `.36 1.21 7.21 7.21 7.25 7.16 I17.21 7.2 7.24 17.07 7.12 7.13 7.05 11 5 E.88 Nov -20 Dec -20 Jan -21 Feb -21 Mar -21 Apr -21 May -21 Jun -21 Jul -21 7of61 Aug -21 Sep -21 Oct -21 Nov -21 1.2 1.0 0.8 0.6 0.4 0.2 0.0 8 7.8 ■ Permit Limit • E Coll • E Coli Ave. 7.6 ElpH Min 7.4 7.2 • pH Max 7 6.8 • pH Aver 6.6 6.4 6.2 9 8 7 6 Permit Limit Max 9 Dissolved Oxygen (DO) December 14, 2021 Complete Agenda Packet Permit Limit Min 6 7.73 7.74 7.69 7.77 7.81 7.84 7.85 7.68 7.4 1 7.7 7.1 1 7.8 7.9 Nov -20 Dec -20 Jan -21 Feb -21 Mar -21 Apr -21 May -21 8of61 Jun -21 Jul -21 Aug -21 Sep -21 Oct -21 Nov -21 apackamt2 skrolczyk Begin Date: 11/01/2021 End Date: 11/30/2021 .. �eaR+u[::MC�NuF:+'k�PC�:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:�:�:��rvu.��V:�F+.�1�:�:�:JaiYuL,��;�.�rW�; :::Number ::::::::::::::::::::::::::::::: :::::::: Date•::• • SGat':1 998 CONARTY,'ROBIN .'.......... 00020001144202A 10/31/21. -0 Totals for Check: 7976 • 998 COX, J0kf1•SI"10N•::•:•:•:•:•:•:•:<•: Totals for:Check..::7977 Totals for Check: 7978 ;;.998 .DAMS, LONNIE (JEREMY) ::: Tatals for.Check: 7979 998 KAEINI, OLIVER Totals for Check: 7980 998 KINZIE,: Totals for: Check: 7961 :........................ ..................................... Totals for Check: 7982 :•:998: LFFFIIJ(#IIELL,:.LANCE. >::•:•: :::Tatals:ffor.' Check:. 7983: ................................. 998 PETERS, ERIC Totals for Check: 7984 998 RANDALL,. WI*L .Totals • for: Clieck::.:.:.7985.• :......................... 998 'RICE,' JOIN .:.:.:.:.:.:. Totals for Check: 7986 :: :T`•& 1s: for Check: 998 SINGH, MANINDERJIT Totals for Check: 7988 998: SUES5;..GARY..: E.15:for .ChecK;::::::T ................ .. 998. Totals for Check: 7990 ................................... 000301012492044 10/31/21 ooc.000. 17102A 10/31/21 U0@5009071614W: i0/31/zl : 00020001080216A 10/31/21 P U0010010023109A 10/31/21 P 011v0 00a1,o,• 10/31/21"P U0010170032108A: •10/.3W2.1:-: : : 0:: • : •: 161242205A 10/31/21 P""' Fran Amt: •:•:•;• .................. ::Number.•:•:•:•:•:•:•:•:•::• • : • : • :7 3ry-20050 000- 000 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 :•:Uljti6Z:Lp XVII•:•:•:•:•: •:•:•: •:•: •:':•: •:':•: •:•:': .............................. A/P Vendors 135-20050-000-000:•: •. 135-20050- •135-20050- .135-200' 0- 000 000 -:135-20050-0007000-:. 00 0 '135-20050- 000 ..-.4.903517.00059024..10/31/21..:.P 135-20050=4410- 10652051 11/3I/21" 'P " " " 135-20050- - 00/000 000 000204500102021 10/31/21 U9022010028902410/31/21 ' 00:0.,0 0,0 .100 I06A 10/31/21 P 0or.0I 00 0 0 0'0 •:•:•:135:20050-F ................ 00 0 -20050- 000 000 000 000 000 000 000 A/P Vendors:.: A/P Vendors'''''''' December 14, 2021 Complete Agenda Packet 12/08/21 12:07 Page 1 Line .LL ll Value:: 5i4:03 514.03 :•:•:•:•:•:•:•:•:•: aub Ner•::•:•Date:• :• :• :• :• :• ::•:::•:::•::•:•• ::::•::•:::•::::•:• :• •: 7976 11/05/21 :::::::::::::::::::::::::::::::::::::::::: ••••••••••••••••••..:.:.:.:.:34;88:.:.,7977:.:3,2105/1. is 54:88.:: .•:•:•:16.26' 7978•'•7110.5/21.::.::.:':':':':': • 16.26 • ...................... A/P Vendors WP Vendo • :60.98:-:•:•:7971-:-: :60.98 1-:••••••••••••••••••••• 29.59 7980 11/05/21 29.59 137.98 7981 11/05/21 137.98 "' "' ""' ". . "" 71.79 7982' ]1%05/21 71.79 A/P Vendors :::53.76 7983 11/05/21 •:.:.:53.76 . . • 14:43 7984 11/05/2i*' 14.43 50.96 A1F Ye�tdo[s:::::::::•:•:•:•:•:•:•:::::31:58:: A/P Vendors ::11/e.5121••• 26.15 7988 11/05/21 26.15 25.98 ::25.98 7989..11/0.5/21 113.56"''.7990%.11/05/2i.. 113.56 •:•:•:A/P.VendoCS•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•::38.93. 7991 11/05/21 • apackamt2 skrolczyk Begin Date: 11/01/2021 End Date: 11/30/2021 • flier•: •: •: •:•: :1030' CIT1':OF'ite item' Totals for Check: 7992 AFIwL4e:'WNW. : 4 POLA i'v: Date::.:.Stat ::P 10/22/2021 :3186 MEMBER'S BUILDING MAINTENANCE.:•TC2109T010 ;:.:3386;: MEMBER'S BUILDING;MAm1BVANce :TC2109TCMUD 3186: MEMBER'S:BUILDING:MAIN ENNICE::TC2109TOVD ............................................... 10/22/21:': P : 10: 09/30/21::f!:::70: .................. 0930• •:•:F!:::::::0: ... .......... 3225 US Bank Voyager Fleet Systems 8693381112144-A 09/30/21 P 10 :::•:•3225::US Bank:Voyager:•Fleet $ystens::86.43387:112144:-A:09/30/2.1•:•: :•:•:•2a • :•:•:•Tatels:for :Check: 7994 • 28055: 28055 28055 3280 WATTS ELLISON LLC 3280 WATTS ELLISON LLC 3280 WATTS ELLISON LLC Totals for Check: 7995 3i38:.Exclus ve.Pest:Control :: Totals for• Check 7996.. 2676 Humana Inc :2676 Humana:Ina>::::: :: 2676:: 2676 Humana :Iric::::::: 2676 Humana 'Inc 2676 Humana Inc Totals for Check: 7997 ........................................... .... 67 : KE STOME PARK:SECRETARIAL•: ks:for. tlieck::::799$:•:•:.:•:.:.:•:.: ........................... 3115 METLIFE GROUP BENEFITS 3115 METLIFE GROUP BENEFITS :: •3115::METL1FE:ti301P BENEFITS 3176 REY-MAR COMS1RUCTION Totals for Check: >:2TA2 :�A11'ied• Totals: for•:Chet ................ :000 155516925 :::155516925 :: ::•::155516925 155516925. 155516925 155516925 •:17 09/30/21 P 10 09/30/21 P 20 09/30/21 P 30 (04/21 : P : 20 10/13/21 P • >:••:.10/33/21::.:P:::> 10 '%I.0113/21%.'.P." 20 10/13/21 P 30 Fran Pmt: 135-60150-010- 000 :135;557?0�011�T OOp:•:•:•:•: 135=55120;030 • • . • • . • • . ervLceS:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: ..................................................... ...................................................... Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 Wholesale Water Gle�r?i►19 Service&•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: CLe41Servite9: . ... ...... .................... 135-65005-010-000 Fuel. & Lube :•1356500-020000-: •:Fuel Sf. lub•: •: .. ................................................ 135-60285-010- 135-60285-020- 135-60285-030- 13555080. 000 000 000 Lawn Equipment & Maintenant Lawn Equipment & Maintenance Lam Equipment & Maintenance maintenance 135-21308-000 000 Dental irs 135-21309-000-000 ::•:::Vision ............. kife:Insevance & Other•::: Life Insurance•&'Other•• Life Insurance & Other 000 000 135-50029-010-000 135-50029-020- 135-50029-030- 000 000 ................................................ • 10/15/2021 10/15/21 P 10 135-50029-010- 10/15/2021 10/15/21 P 20 135-50029-020- 000 000 10/15/21121 < ::11/]5/21 ::A::: 30 135-50029-030-0 0 0. ; .:.:.:.:.:.:.:]35-23315-0.0.0, p06 • 214FRESEID1N1 11/02/21 P 20 135 -55081 -020 - 1512 ANBD Totals for Check: 8002 .................................. ................................. .................................. ................................ pP7'I:IC::::::::::::::::::::: 55125F 197345 10/19/21 P 26 135-60070-026- ...'..•.•.•.•.•........ 35-60070-026- ................ ...................................... ....................................... ...................................... 000 000 ................ Life Insurance & Other Life Insurance & Other December 14, 2021 Complete Agenda Packet 12/08/21 12:07 Page 2 b•: Date: 84,846.92 799•2 '11/• 05/21 '' 84,846.92 161.23 :•:!•:7993:•:11/a5/Z3:•:•:•:<•:•:•:•:•:•:•:<•:•:•:•:•:•:•:<•:•:•:•:•:•:•:<•:•:•:• 1,289.80 ................................................. 355.07 166.34 521.41. 600.00 770.00 469.67 1,839.67 7994 11/05/21 7994:::31/05/21 7995 11/05/21 7995 11/05/21 7995 11/05/21 119:08 7996 11!08/21 119.x .............. 1,342.43 7997 11/08/21 : :172.26:::: 7997 : 1i/08/21 ::::7997 ::14/08/2T 175:56'. 7997''11/08/21' 184.80 7997 11/08/21 2,397.43 123.37 7999 11/08/21 165.40 7999 11/08/21 :•:Life Insurance& Other.:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:182:71:•:•::7999 11/08/21 :::561.0 :•Ferm:Disabili::85:AG:•:•::7999 : W.O.8 i ...................................... Mainten & Repairs Collections .................... er: Dues & Manberships ................... .................. ................... .................. 10 of 61 6,699.00 6,699.00 :000 11/08/21 6,210.20. 8001 11/08/21 ....................... • ........................... 700.00 8002 11/08/21 700.00 ........................................ ....................................... ........................................ ....................................... ..: :1:813.63 •: •:8(Nf : 12705133:•::•:::•::•:•::•: apackamt2 skrolczyk Begin Date: 11/01/2021 End Date: 11/30/2021 Fran Amt: >rMmber:: >: :: >: .• Date >: Stat Na iVimber 3184 DATAPROSE LLC DP2103916 10/31/21:.:.P 30 135 -55205 -030 - Totals for Check: 8003 2677. Digital Air: Control;: In ::•:•:: 2057328:: ;:•:• Tot04:for:Check..::8004......................::: • ' ' ' 1737 DPC WX15Ti2IES," INC' • ....... "11005357-21 Totals for Check: 8005 2606::Fiserv:Solutions,:UX :9' : :TCEa]S:for Check: 8006 '3258 FRANCOTYP-POSTALIA, INC. RI105082859 Totals for Check: 8007 k119 1372: HACK: COMPANY.:: Totals for. Check:.. 8008 3124 • "IRS Tait "Payment 3124 IRS Tax Payment 3124 IRS Tax Payment :":Totals: for. • Eheck: :8009: :::2790 : N=Co'Construction, Inc Totals for Check: 8010 2603 METRO FIRE APPARATUS Totals for Check: 8011.::: • " " Totals • for ••8012' " " ' " " .... . 3156 OXIDOR LAB0RAT0RIES LLC LABORATORIES LLC::.:.:.: 3156 OXIDOR LAB ORATORIES.LLC•:• ........................................ 10/31/21 P .::30. 135760235-030- 10/18,21 000 000 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 December 14, 2021 Complete Agenda Packet 12/08/21 12:07 Page 3 l►aiue: Mirinber :•:• oate:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: • uttttty siiit„y comro�t •••••••••••••• •5fl. ` soo3 iiias/2i 2,383.95 Securi' 10.•135-65030-010-000 Che�ntt&S .01/zl:•:•:P:•:•:::30 :1335-00040030000.:: • • •• 10/15/21 P 30 135-60035-030- rvice: Charges: "&: 32706897 10/21/21 P •:10::135=65030=010-000 Chemicals PR00738 996 10/29/21. 'P PR00738 996 10/29/21 P PR00738 996 10/29/21 P .......................... 169751-1 74231617 135-21"302- 135-21303- 135-21304- -o 10/22/21 P 45 122-69005-045- 000 70=O OOO::: FMH Taxes... Social Security Taxes Medicare Taxes DLtat QlitdVs Capital Outlays Lyse :]h tonnieets:: :•:•:•24:00:•:•:•8004:•:�/.08'/2i.:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:• 1,123.40 :50.00 • 8006 WO8/21 113:04 8007 11/08/21 113.04 887.78 8008 11/08/21 887.78 5;926.64 8009 ' 11/08/21 ''' 6,868.26 8009 11/08/21 1,606.24 8009 11/08/21 :•:-14;401J.4 157;605: 730,000.00 8011 11/08/21 730;000:00:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:• .... $o i ii os z ...175.00 21110026 11/01/21 P 20 135-55135-020-000 Lab Analysis 1,784.80 8013 11/08/21 = 21A0485:.>:.:.:.:.:.:11/.?Bh1::.:A:.:.:.20.::135-55135-020-000::.:.:.>:Lau Analysis::::»»::»::::>::>::»::»::::: ::368.00 8013 11/08/21 _:21110034::::... 11/02/2,1:::::P 0 ...2• 135'5.]35.020:000Lab ..... Analysis:::::::::::::::::::::::::::::::::::::::::::::::368.00; 8013, .11../08/23; ............................................................. :•:.:.2/..., so-: 2789 Relevant Solutions Totals for Check: 8014 ........................ • 3119212 2696 Texas Excavation Safety System 21-22693 Totals for Check: 8016 ..................... ...................... ....................... ....................... :•:•:•:•QQ1 : :Q� ?R9P#h C 10/29/21 P 20 135-55080-020- 000 Maintenance & Repairs 10/31/21 P 30 135 .00.0-030 000 Service Charges & Fees ...................................... ............................... ............................................... ............................................... ............................................... 141.00 8014 11/08/21 141.00 • 188.10 8016 11/08/21 188.10 ................ ....... ............... ....................................... ........................................ ....................................................................................... ,5040000.-.• tQwt►-$k4�7�t ptaula9Q : `;SXp. 80 :: l i ::::::::: : • apackanfi2 skrolczyk Begin Date: 11/01/2021 End Date: 11/30/2021 ........................................................ :::Akmber:::::::::::: ::::::::::::::::::::::::::Date•::•S 1001'••TOMN'OF TROPHY CLUB 1001 TOM OF TROPHY CLUB OCT REFUSE 10/31/21 P Totals for Check: 8017 • #Qr tti • Fran Amt: : &unbar 135 -25010 - Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 December 14, 2021 Complete Agenda Packet 12/08/21 12:07 Page 4 :•: �s:4)!..W1l:•:•::•:•:•:•:•:•:•::•:•:•:•:•:•:• :: il•.4�:4i 1 Refuse Tax ............................................................................................. ........ .................................................................................................... : A;:(.WATER:8ILI5)::::10.3If2021:::::::::::1�/31/21,:::T•••::::30:::135=60025=030=a•�•u.::::::::: VBtEt::::::::::::::::::::::::::::::::::::::::::: 1973 TX COMMISSION FNVIROVENTAL QU CW.)0067141 Totals for Check: 8019 ........................... • 126}::Tl( Oft** ....................... Totals for:(hecki:: X020: 3225 US Bank Voyager Fleet System 3225 US Bank Voyager Fleet Systems Totals for : Check:•8021 10/31/21 P 20 135-60135-020- 8693381112144-B 10/24/21 P 10 135-65005-010- 8693381112144-B 10/24/21 P 20 135-65005-020- 3280 WATTS'ELLZSON LLC :28004: 11L01/21 ::x'..::10 25-60285-010- '3280 WATTS ELLISON LLC 28004" ........11/01/21.. 'P'' 20 135-60285-020- 3280 WATTS ELLISON LLC 28004 11/01/21 P 30 135-60285-030- 3280 WATTS ELLISON LLC 28003 10/31/21 P 20 135-55081-020- 000 000 000 000 000 000 000 Totals: for Ci f .. _4 ... :::2278 ty o Sz�uthtal9e :::::::::::::::::::::: }�AN�t::.d0446:3: • a111�8i21:::::x::::::::::::::135.. 9900 .Q00 Totals for Check:...8023........................................................... 2943 JPMORGAN CHASE ONE NA Totals for.Checks:: 8024:::::: ........................... 1238::Ni�tiH: fdlAS :PUf: Tota)§ for Check: • • • • •8025 2683 Charter Communications ::: T'ota'ls:for. Cheek :::8026 3241•:•C1Ssie:E11eine . Totals' for'Check:'• • 8027•••••••• 1179 DENTON COUNTY TAX OFFICE •:•:•Totals .for:Check 8028 ::::::•:•:•:•:•:•:•: :................................... :2750: HantfUnq Sys & Convekcirss:::::1X-6445 10/26/2021 10/26/21 P 14880 135- 00.0 000 55080-020= 000 TCEQ Fees & Permits ' :MFilbe:•:•: Fuel & Lube Fuel & Lube :Lain Equtpment & Maintenance: ...... .. .... .. .. ........ • Lain Equipment &Maintenance... Lawn Equipment & Maintenance Mainten & Repairs Collections Mkscetiaiteais:lncini :::::: ::;701:72:.: 19,701:72•' ' 80;124:12%%%4017—ii/O8/21- 6,648.78 0,724:12%•••8017"11/08/21"6,648.78 8017 11/08/21 122,883.40 ............................................. ........................................... ............................................. ............................................. 9,888.02 8019 11/08/21 9,888.02 ......................... • • 100.,09,:::::.8.020:::11/48.•21 958.25 8021 11/08/21 682.19 8021 11/08/21 1,640.44 600.00 8022 11/08/21- 770.00 8022 11/08/21 469.67 8022 11/08/21 1,200.00 8022 11/08/21 3, 39:67. Procurawant Clearing •: •: hlaiirteria�ice :6 71672110621 11/06/21 P 30 135-55030-030-000 Software & Support =55091-020:000:•:•:•:•:•Y •04a nfenanCe:CO. • 1402172-2021 11/15/21 P 20 135-55090-020- .. TotaL4 for Check:.' 8029........... 11/04i21 20 : 135-55080-020- . 000 000 Vehicle Maintenance Maintenance &Repairs::.:. IMI -36015 11/08/21 P 20 135-55081-020-000 Heinen & Repairs Collections INV -36014........:..11/08/21;.:..:.:..20:,:135-55081-020-000 :,.:...;:Mainten.& Repai.rs..Collections. 8,011.89 8024 11/08/21 8,011.89: 470:x)0 ::8625:::11/08/21: ••.970:00 899.00 8026 11/15/21 22.00 8028 11/15/21 675.00 8029>1 675.00 . . 11,452.50 8030 11/15/21 17 , 850.00 .00„30:41,45/4 :::29;30Z;50.. apackamt2 skrolczyk Begin Date: 11/01/2021 End Date: 11/30/2021 ::•:• &ioI3er•::•:•::•:•:::•:•:: • ::•:•::•:•::•:::•:•:•:•:: ::•:•:•:•::•:•::•:Date :: Stat Fla.: 3195 LOU'S GLOVES INCORPORATED 046490 ....•..71%08721. P 20 Totals for Check: 8031 1053 : NORTH CENTRAL TX COG.:•:•:•:C•: Totals: for: Check::.. 8032....... .................. ............ 1056 OFFICE DEPOT, INC 1056 OFFICE DEPOT, INC :::•: 1,056:•:OFFICE: DEPOT, :•:•:••tatalS•for Check: 8033 ........ .. .. .. .. .... ....... 3156 OXIDOR LABORATORIES LLC 21110153 Totals for Check: 8034 INV -00000'9951: 10/29/21 '207876310001 2086 :•0.001 206449485001 206449485001 :•:•:2648 : RLC:Controls.:•:•: ? T6ta1S for: Check:_ 8035 " ''' 2659 TARRANF APPRAISAL DISTRICT Totals for Check: 8036 >. 2440. TPJ WIr: CTY :PUBLIC: HEALTH: LPB :.:.:.:.:.2440:; TfilWf CTY::PIBLIC : HEALTH:: LAB; asCheck... 8037 1081 TRI COUNTY ELECTRIC Totals for Check: 8038 '::1058 'U10140'WIREL£S ::::1058: • •VERI7ON: WIRELESS:::::: ••" • TotalS•for Check: • 8039 •• ••• • ••' 8858 P 30: 11/05j21 P 30 11/02/21 P 30 10/29/21 P 30 11/09/21 P 20 11/09/21 P Fran Amt: 135-55080-020- 735-60070.030- :ii5-65085=030- 135-65085-030- 135-65085-030- 000 000 000 000 000 .135=65995-030.000 135-55135-020- 20 135-55080-020- ........................... 1.1.092021. " • " .11/09/21. • P. • 39' 35907::::::. 79274533 135-55050- 11/01/21 P 20 135- 9891774906:::;:::::; 3]JOt • •:9$41719008:• 1/01 2767 InSpeyer Hunan Resource Svc 202111012010TC- ::: TmtaLs:for. Check::: 8040 ::::::::::::::::•::•::: 3731 . North :lexas:Groarer: ::::: E111=01514:::: : • Totals for' Ch k:.. •8041. ...... . 2792 Prosery Crane 2792 .Prosery .Crane..: .................................... .................................... .................................... Totals for Check: 8043 IS3065-IN IS3353-IN .80083422. • 10/01/21 :00/0 -020- 000 000 000 �60010�010- 0 0.0 600]d�=020-006 P 30 135-55070-030- 11:::10::135=60135-010:-000::: 09/30/21 V 20 135-55080-020- .09/30/21..;.V.:..20 135-55080-020- . 10%29/21... P... 10..135-55080-010- J17 000 000 000 000 .135.55080.020.000 ; Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 Maintenance & Repairs ........... Dues:& Mei#0erships ••'OfftO Supplies Office Supplies Office Supplies :.:Maintenance•:Su !J. s: Lab Analysis' Maintenance & Repairs Lab -Analysis.: lysis. : for • Electricity • uriicat OflsJMpt Icat ons/Mobil Independent Labor • ••:••:•TG :Peek &:Penntts••:••:••:••: Maintenance & Repairs ::: Maurteian0 e: &. Repairs •Mai itenance •& :::Matntena,ce,1 Repairs . December 14, 2021 Complete Agenda Packet 12/08/21 12:07 Page 5 .'ws ::: JIeuK.;. {.. {........... .............. . Date 431: apackaut2 skrolczyk Begin Date: 11/01/2021 End Date: 11/30/2021 :2635lff Associates, INC** 2635 Halff Associates, INC Fran Mt: . . ....... ....... • 10062152 """ 11/10/21 P 10 135-69005 010 10062239 11/11/21 P 30 135-55030-030- 2635 Halff Associates, INC 10062148 :•:2635 . Haff::Associaies, :•• .2635 Hallf: teieSU 1006215J. ••• '..• 2635 •Helft Msoeiaies, 324C • • • • • 10062151 Totals for Check: 8045 000 000 Trophy Club MUD No.1 AP Checks For Date/Mount Range .00 To Amt: 99,999,999.99 "CapttaL outlays Software & Support 11/10/21 P 10 520-69005-010- 11/10/2110:135769005-0107000: ' 11/10/21 20 135-69005-020- 000 000 Capital Outlays ..CaPitata;:OixtQut.75.00 8045 11/18/21 cccipapl1t1-ays 879 00 8045 11/18/21,: . . . 8045 11/18/21 20,035.15 December 14, 2021 Complete Agenda Packet 12/08/21 12:07 Page 6 •:.: : : :•:.: 4,140.00 8045 11/18/21 1,607.40 8045 11/18/21 5,083.75 8045 11/18/21 1.372 HAO4 ectraNY : : : :12735449: 11/08/212"f"."- -20.....135-.65045-020-000::: Lab Supplies : •• •• •••••••••••• •• •• • 83.02 11/18 21 : : : .::::::•:•1372: :KO 31128516 11.'03/21 1.1g ficaln Chenicals Total• • s for Check: 8046• •:.: : : : : : : : : : : : : • • • : :•:•:•:•:•:•: • : : : : : : : : : : : : : : : : : : : : : : : : : : 3076 HD SUPPLY FACILITIES MINT LTD 778019 Totals for Check: 8047 :•:-:•:•:-:•:•:-:•:•::•:•:::::::•:•:-:-:•:-:•:' • : 10.00$01d. .•.•.•.•.•.•.•.•.-.•.•.-.•.•.-.•.•.-.• .• 2643 McLean & Howard, L.L.P. 40910 Totals for Check: 8049 3134 Prime Controls, LP Totals for Check: 8051 11/01/21 P 10 135-55080-010- I0/o1/21•::P.::•:20::135: 65045020- 10/31121 P 39 135-55045-039- 000 000 0 0 0 • • • ... • Maintenance & Repairs Lab SupplieS. • Legal • • .•....•.•.•...•.•...•..... SM 7837 •-:•:•:•:•:•:•:•:-:•:•:-:•:•:•:•:•:-:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:• 2789 ReLevant SoLutions 3121267 •totats:•fik•:•chkk•:8062 2789 Relevant Solutions 3121283 Totals for Check: 8053 ::::::: 2659 TARRANT APPRAISAL DISTRICT 11152021 Totals for Check: 8055 108:::t4trfi193:tiIRLX SThDLE Teteti:ior: • k:: : 8056:-::: : . •. ....•.•.•.•.•.. . . . 2222 AFLAC Totals for Check: 8057 ....•.....•.•. 278 PRO0739 952.00 8047 11/18/21 952.00 .............:::::•:•:•:•:•:•:•:•:. 1,690.00 8049 11/18/21 1,690.00 ::::•:•:•:•: :•:.: :•:.: ....... ....... ....... '.'.......•.•.•.•.•.•.".'.•.' ..•.'.'.'.'.'.•.'.•.•.'..•.".•.•.•.•.•.•.•.•.•.•.•.....•.•.•.•.•.•.•.•.•.•.•.•.. ...............•..•.•.•.•.•.•.•.•.•.•.•.•....•.•.•.•.•.•.•.•.•.•.•.•.. . . .......... . .............................................. 11/05/21 P 20 135-55080-020- 11/11/21 P 20 135-55080-020 . • • • • • . • • .. • ..•.............. 000 000 000 .•.-.•.•.-.•.•.-.•.•.•.•.•.•.•.•.•. •• : ;0204 •.•.•.•.•.•.•... ...•.•.•.- -.• 11/15/21 P 39 135-55060-039- 996 11/12/21 V •.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•........ •.•.•.•.•.•.•.•.•.•.•.•.•.•.•... .....•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•. 9504.5..4 .•.•.•. 000 .•.•.•.•.•.•.•.•.•.•.•.•.. 135-21312- 000 000 ....•.•.•.•.•.•.•.•... :2 41007... Maiirtenance & Repairs •••••••••:-:•:•:-:•:•:•:•:-:•:•:- Rateistaace::&:. 2 • .•.•.•:•:•:•:•:•:•:•:•:•:•:•:•:•.• • Maintenance & Repairs Appraisal :•:•:•:•:•:•:•:•:•:•:•:•:•'• .•.•.•.•.•.•.•.•.•.•.. • •.•.•.•.•.•.•.•.•.•.•.. Aflac 14 of 61 867.00 8051 11/18/21 867.00 • • . 760.69 8053 11/18/21 760.69 .•.•.•.•.•.•.•....•........•.•.•.•.•.•.•.•.•.• .::::::::•:•:•:•:•:•:•:•:•:•:•:•:•:•••••••••••••••:•:•:•:•:•:•:•:. •'•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:• 2,859.73 8055 11/18/21 2,859.73 9:i0;00::•:•• .•.• •.•.• • •.• 166.60 8057 11/19/21 166.60 • • • .....•.•.•.•.•.•.•.. • • •••••••• ..•.•.•.•.•.•.•."... .....•.•.•.•.•.•.•.. • •.•.•.'. . • '•'• • • • • • • • • • • • '•'•'• • • • ....•.•.•.•. apackamt2 skrolczyk Begin Date: 11/01/2021 End Date: 11/30/2021 Fran Amt: .. he!�[::MC�NuI�:+'k�PC�:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:�:�:��Iv!+.��V:�M�7�:�:�:JA!Yuti��:�#dW�::uel+}:�!+44V4�14�:�:•:•:•:• :.:•.:••A•k•m•b•er:.>:.:.>:.:.:::>:.:.:.:.:.:.:.:.:.:.:.:.:•::.:•::.:.>:.:.:.:.:.:.:.:.:Date:::.Sta•n• Na Nester .:.:.:. Totals for Check: 8058 >: 3124 IRS Tax Payment 3124 IRS:Tax Plmr3r►t:•:•:•:•:•:•:•:•:•:•: Trophy Club MUD No.1 AP Checks For Date/Amount Range { .00 To Amt: 99,999,999.99 • •:F L.:F:yiy4411•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: December 14, 2021 Complete Agenda Packet 12/08/21 12:07 Page 7 ia!C4�ti uig4M1:•• ••• Mirinber : Date•.:.:.:.:.:.:::::.:.:.•:•:•:•:•.•:•:•'•-••••••••••••••:•••••• 490:40::: PR00739 996 11/12/21 V 135-21302-000-000 P1 Taxes 5,651.32 8059 11/19/21 PR00739 996 11/12/21 V :•:•: 135-21303-000-000 :•: 3FlS.Tax P'aymecyst.:: ?:::!:i:: PR00739 996 11/12/21 V ::135-21304-000-000 3132 Legal Shield Totals for Check: 8060 .................................... ................................... ...................................... ::1o#als: for: fiFieck: 3111 North Texas Groundwater INV -01514A 09/30/21 P 10 135 -60135 -010 - Totals for Check: 8062 PR00739 996 11/12/21 V 135-23310- 0 000 ....................................... .. L?b=21317= 000 .............................................................. ............................................................... :::2792 : PitlSeC�t :G"dite:: •:-:..-1,543,54 (10/40/2.1.:::: • :•:•2152::Proserv:Crane•:•: ::: 3065:I A ::::09 /Il • • Totals'for Check: • • 8063'.•.•.•.•.•.•...•.• • ....................... . Grand Totals: ............................................... • 000 000 Social Security:Taxes:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:6,635;7Q:•:•:•8059:•:1k/19/?1: : Legal Plan ........................ ....................... TCEQ Fees & Pennits .................................. .................................. ]35-55080-020-000: Naiirtenance:&:A i35=55980=0204000 Maint000. • 17.46 8060 11/19/21 17.46 ............................................ ............................................. :�:�:�:�:�: 9, 5,661.80 8062 11/29/21 5,661.80 ......................... 1;221.96 8003:;a1j39/21:::: 1,665:43 8063 71/29/21::: 2,887.39 1,312,260.63 ........................................... ................................................................................................................................................................................................................................................................................................................................ ............................................................................................................................................................................. ..................................................................................................................................................................................... ...................................................................................................................................................................................... ..................................................................................................................................................................................... ..................................................................................................................................................................................... ..................................................................................................................................................................................... ...................................................................................................................................................................................... ..................................................................................................................................................................................... ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects December 14, 2021 Complete Agenda Packet November Utility Billing Report Fiscal Year 2021- 2022 November December January February March April May June July August September October November 2020 2020 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 1055 1065 1084 1085 1095 1129 1141 1155 1184 1264 1267 1338 1360 3902 3884 3896 3888 3890 3875 3869 3881 3882 3884 3878 3868 3863 649 653 645 653 660 663 667 668 664 658 659 675 655 1297 1302 1319 1330 1331 1331 1357 1362 1376 1386 1400 1414 1415 1188 1234 1205 1124 1,211 1,185 1,201 1,206 1,190 1,186 1191 1185 1166 380 329 369 358AA 309 332 387 345 345 327 336 390 293 25 20 13 26 0** 17 23 15 25 22 23 18 12 Connections MUD 3393 3393 3393 3393 3393 3393 3393 3397 3397 3397 3397 3397 3398 Connections PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1443 Active Residential MUD - 3114 3113 3112 3114 3111 3117 3109 3114 3111 3113 3111 Active Commercial MUD - - 251 253 253 253 253 255 255 254 255 255 255 Active Residential PID 1405 1406 1404 1406 1405 1405 1404 1406 1406 1406 1406 Active Commercial PID - - 37 37 37 37 37 37 37 37 37 37 37 Date of Permit Permit No. AA In response to extreme weather the District has suspended Late Notices ** In response to extreme weather the District has suspended Disconnects November Permits Fiscal Year 2022 Customer Due to FW Oversize Plumbing Sewer Deposit Water Meter Inspections Inspections Fire Line Misc. Income Total Total $ - $ - $ - $ - $ - $ - $ - $ 16 of 61 December 14, 2021 Complete Agenda Packet FY 2022 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 300 300 165,537 6,033,776 3,824,473 94,826 14,000 750 2,500 50,000 15,000 14,146 10,000 2,058 7,000 300 300 165,537 6,033,776 3,824,473 94,826 14,000 750 2,500 50,000 15,000 14,146 10,000 2,058 7,000 17 (220) 6 858,064 599,592 15,274 1,500 739 12,314 1,522 3,020 2,358 3,536 (4) 402,228 314,072 (1,186) 625 234 20,115 -73.22% 1.96% 0.00% 14.22% 15.68% 16.11% 10.71% 0.00% 0.00% 24.63% 0.00% 0.00% 20.13% 25.00% 0.00% 201.15% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 414 5.91% 0.00% 0.00% 0.00% 520 294 165,537 5,175,712 3,224,881 79,552 12,500 750 2,500 37,686 11,980 10,610 (10,115) 2,058 6,586 ITotal 10,370,758 I 10,370,758 I 729,396 I 1,526,577 I 14.72% 1 8,844,181 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 402,468 17,000 5,829 4,500 46,074 97,671 5,594 719 4,620 26,647 6,232 1,512 11,604 400 300 402,468 17,000 5,829 4,500 46,074 97,671 5,594 719 4,620 26,647 6,232 1,512 11,604 400 300 26,473 1,024 5,713 150 3,096 4,625 292 41 289 2,037 476 22,059 2,078 5,713 400 6,963 9,250 584 82 578 3,500 819 12.06% 12.22% 98.00% 8.89% 15.11% 9.47% 10.43% 11.46% 12.50% 13.14% 13.14% 0.00% 909 1,818 15.67% 0.00% 0.00% 0.00% 110,000 110,000 45,403 45,574 41.43% 2,000 2,000 - 0.00% 5,000 5,000 17 903 18.07% 1,000 1,000 - 0.00% 2,000 2,000 161 161 8.06% 7,500 7,500 220 220 2.93% 2,000 2,000 80 80 4.00% 7,500 7,500 487 939 12.51% 131,689 131,689 11,243 24,279 18.44% 1,000 1,000 - 0.00% - - - 0.00% 4,141 4,141 525 919 22.19% - - 0.00% 988 - - 0.00% - - 0.00% 30,000 8,455 8,455 28.18% - - - 0.00% 2,508,611 228,602 228,602 9.11% - - 0.00% - 0.00% 12,500 12,500 600 4.80% 569,454 569,454 51,769 9.09% - - 0.00% - - 0.00% 2,500 - 0.00% 15,000 1,657 2,615 17.43% 5,250 823 823 15.68% 988 30,000 2,508,611 2,500 15,000 5,250 1/ Ot b1 380,409 14,922 117 4,100 39,111 88,421 5,010 637 4,042 23,147 5,413 1,512 9,786 400 300 64,426 2,000 4,097 1,000 1,839 7,280 1,920 6,561 107,410 1,000 3,222 988 21,545 2,280,009 11,900 517,685 2,500 12,385 4,427 Description FY 2021 Adopted Amended Budget November Totals YTD Total 11/30/2021 YTD % Budget (16.66% Target) Remaining Budget General Fund Revenues 135-40000-000-000 Property Taxes 136,092 136,092 8,791 12,962 9.52% 123,130 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 300 300 165,537 6,033,776 3,824,473 94,826 14,000 750 2,500 50,000 15,000 14,146 10,000 2,058 7,000 300 300 165,537 6,033,776 3,824,473 94,826 14,000 750 2,500 50,000 15,000 14,146 10,000 2,058 7,000 17 (220) 6 858,064 599,592 15,274 1,500 739 12,314 1,522 3,020 2,358 3,536 (4) 402,228 314,072 (1,186) 625 234 20,115 -73.22% 1.96% 0.00% 14.22% 15.68% 16.11% 10.71% 0.00% 0.00% 24.63% 0.00% 0.00% 20.13% 25.00% 0.00% 201.15% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 414 5.91% 0.00% 0.00% 0.00% 520 294 165,537 5,175,712 3,224,881 79,552 12,500 750 2,500 37,686 11,980 10,610 (10,115) 2,058 6,586 ITotal 10,370,758 I 10,370,758 I 729,396 I 1,526,577 I 14.72% 1 8,844,181 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 402,468 17,000 5,829 4,500 46,074 97,671 5,594 719 4,620 26,647 6,232 1,512 11,604 400 300 402,468 17,000 5,829 4,500 46,074 97,671 5,594 719 4,620 26,647 6,232 1,512 11,604 400 300 26,473 1,024 5,713 150 3,096 4,625 292 41 289 2,037 476 22,059 2,078 5,713 400 6,963 9,250 584 82 578 3,500 819 12.06% 12.22% 98.00% 8.89% 15.11% 9.47% 10.43% 11.46% 12.50% 13.14% 13.14% 0.00% 909 1,818 15.67% 0.00% 0.00% 0.00% 110,000 110,000 45,403 45,574 41.43% 2,000 2,000 - 0.00% 5,000 5,000 17 903 18.07% 1,000 1,000 - 0.00% 2,000 2,000 161 161 8.06% 7,500 7,500 220 220 2.93% 2,000 2,000 80 80 4.00% 7,500 7,500 487 939 12.51% 131,689 131,689 11,243 24,279 18.44% 1,000 1,000 - 0.00% - - - 0.00% 4,141 4,141 525 919 22.19% - - 0.00% 988 - - 0.00% - - 0.00% 30,000 8,455 8,455 28.18% - - - 0.00% 2,508,611 228,602 228,602 9.11% - - 0.00% - 0.00% 12,500 12,500 600 4.80% 569,454 569,454 51,769 9.09% - - 0.00% - - 0.00% 2,500 - 0.00% 15,000 1,657 2,615 17.43% 5,250 823 823 15.68% 988 30,000 2,508,611 2,500 15,000 5,250 1/ Ot b1 380,409 14,922 117 4,100 39,111 88,421 5,010 637 4,042 23,147 5,413 1,512 9,786 400 300 64,426 2,000 4,097 1,000 1,839 7,280 1,920 6,561 107,410 1,000 3,222 988 21,545 2,280,009 11,900 517,685 2,500 12,385 4,427 December 14, 2021 Complete Agenda Packet Account FY 2021 Adopted Amended Budget November Totals YTD Total 11/30/2021 YTD % Budget (16.66% Target) Remaining Budget 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 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 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 1Subtotal Wastewater Salaries & Wages Social Security Taxes Medicare Taxes Unemployment Taxes 1 25,000 20,000 87,000 905,000 31,419 1,404 75,000 113,500 25,000 20,000 87,000 905,000 31,419 1,404 75,000 113,500 3,182 5,542 12,119 12,119 75,000 64,305 64,305 603,223 1 5,307,626 1 5,307,626 1 422,403 1 478,934 33,000 7,956 8,400 56,634 112,190 7,175 1,013 4,800 32,754 7,660 1,764 14,153 400 300 125,000 222,500 9,000 4,600 13,000 3,000 2,000 100,000 40,000 7,500 150,732 4,652 1,138 478,934 33,000 7,956 8,400 56,634 112,190 7,175 1,013 4,800 32,754 7,660 1,764 14,153 400 300 125,000 222,500 9,000 4,600 13,000 3,000 2,000 100,000 40,000 7,500 150,732 4,652 1,138 35,735 2,987 7,955 675 4,394 7,030 392 59 363 2,840 664 64,238 5,035 7,955 1,350 9,585 14,060 783 119 726 4,752 1,111 1,118 2,236 22,728 36,463 22 836 161 2,916 436 13,869 27,072 38,041 22 836 161 6,210 6,692 872 27,065 225 2,827 12,000 12,000 9,888 16,000 115,924 690,085 500 12,500 6,205 32,500 10,000 33,000 700,000 81,878 7,312 130,000 16,000 115,924 690,085 500 12,500 6,205 32,500 10,000 33,000 700,000 81,878 7,312 130,000 977 175 942 770 10,539 62,735 1,659 1,506 942 6,819 14,167 1,225 1,225 130,000 22.17% 0.00% 0.00% 0.00% 0.00% 1.34% 0.00% 0.00% 100.00% 56.66% 0.00% 11.37% 19,458 20,000 87,000 892,881 31,419 1,404 49,195 4,704,403 13.41% 414,696 15.26% 27,965 99.99% 1 16.07% 7,050 16.93% 47,049 12.53% 98,130 10.92% 6,392 11.71% 894 15.12% 4,074 14.51% 28,002 14.51% 6,549 0.00% 1,764 15.80% 11,917 0.00% 400 0.00% 300 0.00% - 0.00% - 21.66% 97,929 17.10% 184,459 0.00% 9,000 0.48% 4,578 6.43% 12,164 0.00% 3,000 8.06% 1,839 6.21% 93,790 16.73% 33,308 11.62% 6,628 17.96% 123,667 0.00% 0.00% 7.21% 1,825 0.00% - 0.00% 1,138 0.00% 0.00% - 82.40% 2,112 0.00% - 0.00% - 4.81% 15,230 9.09% 105,385 9.09% 627,350 0.00% 0.00% - 0.00% 500 13.27% 10,841 24.28% 4,699 2.90% 31,558 0.00% 10,000 0.00% 0.00% - 42.93% 18,833 0.18% 698,775 0.00% 81,878 0.00% 7,312 100.00% 0.00% 13.73% 2,845,471 3,298,159 1 3,298,159 1 152,005 1 452,688 18 01 61 0.00% 0.00% 0.00% 0.00% Account December 14, 2021 Complete Agenda Packet Description FY 2021 Adopted Amended Budget November Totals YTD Total 11/30/2021 YTD % Budget (16.66% 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 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 Non Departmental 135-55045-039-000 135-55055-039-000 135-55060-039-000 135-55065-039-000 Workman's Compensation Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 'Subtotal Board of Directors 1 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 1Subtotal Administration Legal Auditing Appraisal Tax Admin Fees 'Subtotal Non Departmental 1 30 750 1,500 4,000 5,000 500 11,780 1 1 1 567,338 2,000 2,972 61,353 103,384 6,533 819 4,800 35,483 8,298 1,512 1,425 500 4,000 122,310 15,000 40,000 3,000 12,000 70,281 9,000 8,500 3,000 15,213 5,000 30,000 85,000 1,500 84,000 6,000 1 30 750 1,500 4,000 5,000 500 11,780 1 1 115 116 1 2 700 230 932 1 5.73% 0.00% 93.33% 15.33% 0.00% 0.00% 0.00% 7.91% 1 1 1 567,338 42,939 77,093 13.59% 2,000 - 6 0.31% 2,972 2,973 2,973 100.02% 61,353 4,261 9,995 16.29% 103,384 5,843 11,686 11.30% 6,533 327 655 10.02% 819 45 90 10.99% 4,800 399 798 16.63% 35,483 2,703 4,791 13.50% 8,298 632 1,121 13.50% 1,512 - 0.00% 1,425 126 252 17.67% 500 - 0.00% 4,000 - 0.00% - - 0.00% 122,310 3,247 23,601 19.30% 15,000 1,595 2,595 17.30% 40,000 463 1.16% 3,000 - 0.00% - - 0.00% 12,000 967 967 8.06% 70,281 66,240 94.25% 9,000 572 6.36% 8,500 502 1,005 11.82% 3,000 225 450 15.00% 15,213 903 1,892 12.44% 5,000 332 690 13.79% 30,000 (1) 2,338 7.79% 85,000 7,506 16,014 18.84% 1,500 - - 0.00% 84,000 7,307 14,614 17.40% - 0.00% 6,000 100 1,464 24.40% - 0.00% 2,000 2,000 3,254 3,629 181.45% 5,250 5,250 - 0.00% 1,587 1,587 - - 0.00% - 0.00% 5,000 5,000 - - 0.00% 2,500 2,500 - 0.00% 24 24 0.00% - 0.00% 0.00% 5,000 470 9.39% 10,000 - - 0.00% 530 - 0.00% 21,400 84 84 0.39% 6,000 289 465 7.74% 0.00% 4,000 4,000 449 802 20.04% 0.00% 190,000 - 0.00% 4,000 271 545 13.62% 1,567,488 1 87,302 1 248,381 1 15.85% 5,000 10,000 530 21,400 6,000 190,000 4,000 1,567,488 1 135,000 33,800 12,055 4,850 I 185,705 I I 1 1 135,000 2,065 33,800 - 12,055 5,498 4,850 - 185,705 I 7,563 I 2,065 5,498 7,563 1 1 1.53% 0.00% 45.61% 0.00% 4.07% MI 28 50 1,270 4,000 5,000 500 10,848 490,245 1,994 (1) 51,358 91,698 5,878 729 4,002 30,692 7,177 1,512 1,173 500 4,000 98,709 12,405 39,537 3,000 11,033 4,041 8,428 7,496 2,550 13,321 4,310 27,662 68,986 1,500 69,386 4,536 (1,629) 5,250 1,587 5,000 2,500 (24) 4,530 10,000 530 21,316 5,536 3,198 190,000 3,455 1,319,107 132,935 33,800 6,557 4,850 178,142 Total General Fund Revenues Total General Fund Expenses Net Budget Surplus (Deficit) 10,370,758 10,370,758 729,396 10,370,758 10,370,758 669,390 60,006 1,526,577 1,312,786 213,791 14.72% 12.66% 2.06% 8,844,181 9,057,972 213,791 19 of 61 CASH STATUS AS OF NOVEMBER 2021 1 35-1 02 50 TexPool 0 & M (XXXXX0002)-General Fund Operating *** 1 35-1 03 00 Prosperity Bank (XXX8701) General Fund Operating 1 35-1 03 05 Prosperity Bank Reserve -Savings Acct (XXXXX7724) 1 35-1 11 00 Petty Cash Administration 1 35-1 11 50 Petty Cash Utility Billing 1 37-1 02 50 TexPool 0 & M (XXXXX0002) GASB Replacement 51 9-1 02 50 Texpool Revenue Bond Construction (XXXXX015) SWIFT 51 9-111 55 Cash -Bond Escrow Bank of Texas (SWIFT) 520-1 02 50 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) 520-1 03 00 Prosperity Bank Construction Water & Waste Water Systems 2019 528-1 02 50 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements 533-1 02 50 TexPool Tax I & S (XXXXX0003) 533-1 03 00 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) *11/30/2021 Customer Water Deposits $311,790 Fire Department Cash 11 22-1 02 50 ITexPool 0 & M (XXXXX0002)-Fire Operating Cash 1122-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 20 of 61 December 14, 2021 Complete Agenda Packet Restricted - Unable to be spent $o $311,790 $2,001,893 $0 $0 $2,985,575 $0 $785,043 $4,032,256 $0 $894,366 $108,185 $0 $80,868 $30,872 $35,052 $11,265,900 1 Unrestricted - Available for spending $2,815,233 $3,509,965 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,325,798 1 $0 1 $6,325,798 $6,325,798 $1,076,474 $0 $1,076,474 1 $1,076,474 $1,076,474 Total in Accounts (Restricted & Unrestricted) $2,815,233 $3,821,755 $2,001,893 $150 $450 $2,985,575 $0 $785,043 $4,032,256 $0 $894,366 $108,185 $0 $80,868 $30,872 $35,052 $17,591,697 General Fund 135 Available 3,509,965 Prosperity General Fund 2,815,233 Texpool General Fund 600 Petty Cash 6,325,798 3,880 3,097,390 6,054,023 213,791 $9,369,083 $1,076,474 $0 $1,076,474 December 14, 2021 Complete Agenda Packet FY 2022 Combined Financials YTD as of 11/30/2021 • YTD Revenues Expenses Adopted Budget vs YTD Actuals Revenues & Expenses 51,526,577 $1,312,786 $932 $7,563 YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD • YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 Water Consumption Budget vs Actual 78,390,000 80,639,404 51,338,613 54,635,000 Budget Consumption —,~Actual Consumption Oct Nov 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 834,099,338 835,146,320 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $900,000 5800,000 $700,000 5600,000 $500,000 $400,000 $300,000 $200,000 $100,000 So $455,836 Water Revenue Budget vs Actual 3569,186 8402,228 ./ $398,851 1 Budget Revenue --Actual Revenue Oct Nov $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $5,923,802 $3,525,165 $3,420,126 Total Water Revenue • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses 21 of 61 December 14, 2021 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,076,474 PREPAID EXPENSES 16,631 ADVALOREM PROPERTY TAXES RECEIVABLE 1,157,226 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 2,250,331 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 22 of 61 1,140,514 629,193 1,769,707 723,260 (242,636) 480,624 2,250,331 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET NOVEMBER 2021 December 14, 2021 Complete Agenda Packet 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,821,755 3,821,755 CASH IN BANK -SAVINGS -CASH RESERVE 2,001,893 2,001,893 INVESTMENTS-TEXPOOL 2,815,233 2,985,575 5,800,808 PREPAID EXPENSES 98,485 98,485 ADVALOREM PROPERTY TAXES RECEIVABLE 123,901 123,901 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,684,263 1,684,263 TOTAL ASSETS 10,546,130 2,985,575 13,531,705 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 122,149 122,149 ACCOUNTS AND OTHER PAYABLES 743,108 743,108 CUSTOMER DEPOSITS 311,790 311,790 TOTAL LIABILITIES 1,177,047 1,177,047 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,880 3,880 ASSIGNED FUND BALANCE 3,097,390 3,097,390 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 360,000 360,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 1,113,885 1,113,885 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 1,211,690 1,211,690 ASSIGNED FUND BALANCE/FIRE DEPARTMENT - - ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 300,000 300,000 UNASSIGNED FUND BALANCE 6,054,023 6,054,023 COMMITTED FUND BALANCE - - NET REVENUES / EXPENDITURES 213,791 213,791 TOTAL FUND BALANCE 9,369,083 2,985,575 12,354,658 TOTAL LIABILITIES AND FUND BALANCE 10,546,130 2,985,575 13,531,705 23 of 61 December 14, 2021 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET NOVEMBER 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 24 of 61 RE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION December 14, 2021 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET NOVEMBER 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 519 REVENUE BOND CONSTRUCTION 785,043 TOTAL ASSETS 785,043 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 25 of 61 81,691 81,691 703,345 7 703,352 785,043 December 14, 2021 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET NOVEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 4,032,256 TOTAL ASSETS 4,032,256 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 1,159,964 TOTAL LIABILITIES 1,159,964 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (1,159,717) TOTAL FUND BALANCE 2,872,292 TOTAL LIABILITIES AND FUND BALANCE 4,032,256 26 of 61 December 14, 2021 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET NOVEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,366 TOTAL ASSETS 894,366 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 894,311 NET REVENUES / EXPENDITURES 55 TOTAL FUND BALANCE 894,366 TOTAL LIABILITIES AND FUND BALANCE 894,366 27 of 61 December 14, 2021 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET NOVEMBER 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 108,185 629,993 TOTAL ASSETS 738,178 LIABILITIES AND FUND BALANCE LIABILITIES 57,356 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 618,987 ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 676,343 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (14,841) 76,676 TOTAL FUND BALANCE 61,835 TOTAL LIABILITIES AND FUND BALANCE 738,178 28 of 61 December 14, 2021 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET NOVEMBER 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 80,868 TOTAL ASSETS 80,868 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 26,061 54,807 80,868 TOTAL LIABILITIES AND FUND BALANCE 80,868 29 of 61 December 14, 2021 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET NOVEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 30,872 TOTAL ASSETS 30,872 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 5,656 25,216 30,872 TOTAL LIABILITIES AND FUND BALANCE 30,872 30 of 61 December 14, 2021 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET NOVEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 35,052 TOTAL ASSETS 35,052 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 34,487 TOTAL FUND BALANCE 35,052 TOTAL LIABILITIES AND FUND BALANCE 35,052 31 of 61 December 14, 2021 Complete Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS November 15, 2021, at 6:30 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a regular session meeting on November 15, 2021, at 6:30 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 President Kelly Castonguay Secretary/Treasurer William C. Rose Director Kevin R. Carr Director BOARD MEMBERS ABSENT: Mark Chapman Vice President STAFF PRESENT: Alan Fourmentin Laurie Slaght Mike McMahon Steven Krolczyk Tony Corbett General Manager District Secretary Operations Manager Finance Manager Legal Counsel (via Zoom) GUESTS PRESENT: Jack Taylor Trophy Club Fire Chief CALL TO ORDER AND ANNOUNCE A QUORUM President Flynn announced the date of November 15, 2021, called the meeting to order and announced a quorum present at 6:30 p.m. CITIZEN COMMENTS There were no citizen comments REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Water Operations Report c. Wastewater System Reports d. Finance Reports General Manager Alan Fourmentin presented the monthly reports and answered questions related thereto. 32 of 61 December 14, 2021 Complete Agenda Packet CONSENT AGENDA 2. Consider and act to approve the Consent Agenda. a. October 2021 Combined Financials b. October 19, 2021, Regular Meeting Minutes c. Appointments to Fort Worth Wholesale Advisory Committee for FY2022. Motion made by Director Rose and seconded by Director Castonguay to approve the consent agenda as presented. Motion carried unanimously REGULAR SESSION 3. Discuss and possible action to authorize Denton County to waive the penalty and interest on delinquent taxes for Parcel 726658DEN-Quasar Hotels LLC. Motion made by Director Carr and seconded by Director Flynn to waive the penalty and interest on delinquent taxes for Parcel 726658DEN-Quasar Hotels LLC. Motion carried unanimously 4. Consider and take appropriate action to appoint two (2) directors to serve on the Audit Committee. Director Rose nominated Director Castonguay to serve on the Audit Committee. Director Castonguay nominated Director Rose to serve on the Audit Committee Motion by Director Flynn and seconded by Director Rose to have Director Castonguay and Director Rose serve on the Audit Committee. Motion carried unanimously 5. Consider and act regarding approval of employee health and ancillary benefits for the calendar year beginning January 1, 2022, and ending December 31, 2022, and authorize the General Manager to execute the necessary documents to implement the Board action. Motion made by Director Rose and seconded by Director Castonguay to approve the United Healthcare All Savers renewal at the $1,500 deductible for employee medical benefits and Humana Dental and Vision and MetLife, long-term disability and life accidental life and dismemberment benefits for the calendar year beginning January 1, 2022, and ending December 31, 2022, and authorize the General Manager to execute the necessary documents to implement Board action. For: Rose, Flynn, Castonguay Oppose: Carr 33 of 61 December 14, 2021 Complete Agenda Packet Motion passed 3-1 6. Consider and take appropriate action regarding approval of purchase of a 2022 Dodge Ram 3500 Reg Cab truck for the water department to be purchased through the Buy Board contract at Grapevine Dodge Chrysler Jeep for an amount not to exceed $42,336 and authorize the General Manager to execute the necessary documents to complete the vehicle purchase. Item is tabled 7. Discussion and possible action regarding solar options related to the wastewater treatment plant. Discussion only, no action taken. 8. Discussion and possible action regarding remodeling the Annex building, including potential action relating to approval of architectural and construction services. The Board would like to have the Strategic Partnership Committee meet with the Town committee members and determine the next steps for the annex building. Direction only, no action taken. 9. Items for future agendas: Annex building 10. Upcoming Meeting dates—Tuesday, December 14th at 6:30 p.m. 11. Discussion and action regarding meeting dates for the months of January and February 2022. The January regular Board meeting will be held on Wednesday, January 19, 2022; a special session workshop will immediately follow. The February regular Board meeting will be held on Tuesday, February 22, 2022. ADJOURN President Flynn called the meeting adjourned at 7:29 p.m. Steve Flynn, President Kelly Castonguay, Secretary/Treasurer Laurie Slaght, District Secretary 34 of 61 (SEAL) 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT STAFF REPORT December 14, 2021 December 14, 2021 Complete Agenda Packet AGENDA ITEM: Consider and act regarding approval of work order with Pipeline Analysis, LLC for professional engineering services related to the District wastewater collection system and authorize the General Manager to execute the necessary work order documents. DESCRIPTION: The purpose of this work order is to continue the multi-year phased systematic condition assessment of the entire District wastewater collection system to identity system defects that contribute to wet weather infiltration and/or inflow. Best management practice is to perform a condition assessment of the wastewater collection system assets followed by repairs and rehabilitation. Such inspections and testing will identify system defects that, if repaired early, will minimize rehabilitation costs, and extend the life of system assets. The District wastewater collection system has been divided into multiple study areas to be performed over an eleven (11) year period. This will be the second year of condition assessment efforts, which also coincide with the sanitary sewer overflow initiative (SSOI) executed with the Texas Commission on Environmental Quality (TCEQ) in September 2021 and expires September 2032. This work order includes smoke testing, cleaning, and CCTV of approximately 38,012 linear feet of pipe and inspection of approximately 374 manholes. Upon completion of this work order and subsequent years of studies, the results will assist in determining annual capital improvement funding, long-term asset management needs, implementation with our computerized maintenance management system (CMMS), further refinement of the geographic information system (GIS), and provide the necessary data needed for annual reporting to TCEQ. ATTACHMENT: Work Order No. 1 RECOMMENDATION: Staff recommends the Board of Directors approve the work order agreement with Pipeline Analysis, LLC for professional engineering services related to the District wastewater collection system at a total cost not to exceed $188,246.52 and authorize the General Manager to execute the necessary work order documents. 35 of 61 December 14, 2021 Complete Agenda Packet Multi Year Concept Proposal Sanitary Sewer Condition Assessment And Infiltration/Inflow Reduction Program Work Order No.1 Alan Fourmentin General Manager afourmentinltcrnud.ara November 17, 2021 PIPELINE ANALYSIS' WASTEWATER COLLECTION ENGfNEERS PIPELINE ANALYSIS LLC 1115 Main Street Garland, Texas 75040 800-637-0164 36 of 61 December 14, 2021 Complete Agenda Packet WORK ORDER NO.1 SCOPE OF SERVICES PURPOSE The purpose of this project is to perform the Year 2 phased systematic condition assessment of the District wastewater collection system to identity system defects that contribute to wet weather infiltration/inflow. Best management practice is to perform a condition assessment of the wastewater collection system assets followed by repairs and rehabilitation. Such inspections and testing will identify system defects that, if repaired early, will minimize rehabilitation costs, and extend the life of system assets. A work order will be prepared for each annual phase of work. The work order will include detailed quantities of work, basin identification, schedule and fee. All work will follow the Pipeline Analysis LLC Master Service Agreement Contract No. 2021101801. The District wastewater collection system consists of approximately 371,320 linear feet of mainline sewer and 1,600 manholes. Exhibit A presents the estimated cost for Work Order 1. Such a program can be budgeted each year and the cost of system repairs can then also be included in an annual repair budget. The following summarizes the project tasks and approach to this phased project: Work Tasks TASK 100 MOBILIZATION Mobilize project team and coordinate startup. Establish personnel assignments and responsibilities. Inventory equipment needs and order expendable supplies. Review all relevant existing materials, previous reports, etc. developed for or by the District concerning this project, including, but not limited to, the following: 1. Previous studies for the service areas to be investigated 2. Sewer maps Deliverable: 1. Delivery of equipment and personnel 2. Work maps of Basin with delineated boundaries 3. New manhole numbering protocol To Be Provided by the District: • Access for placement of equipment and personnel • Copies of all applicable reports, maps and historical data for the study area at no cost to ENGINEER • As -built drawings, sewer key maps, street plans, electronic aerial photographs if available and if requested at no cost to ENGINEER 37 of 61 December 14, 2021 Complete Agenda Packet TASK 200 MANHOLE/PIPE INSPECTION The existing GIS maps will be used and updated during the course of field inspections. Field verification of the map will be necessary to resolve flow directions, "race track" connections, split flow locations, and identify assets not shown on the existing sewer maps. The updated maps will be used for subsequent field testing and inspections. Work Order 1 includes the inspection and map update of Basins 1, 2 and 5 consisting of approximately 374 manholes. Note that Basin 1 was smoke tested in Year 1 but manholes and map updates are being complete in the Year 2 work schedule. Manholes can be a significant source of extraneous infiltration/inflow and thereby reduce system wet weather capacity. For this reason, each manhole within the District will be inspected and undergo a condition assessment. The data gathered during this phase of the project will be used to prioritize manholes for rehabilitation and establish the base data necessary to accurately determine mainline sewer rehabilitation alternatives and costs. Other important deliverables resulting from this work task are the updating of the collection system map, determination of debris levels in pipes and verification of pipe sizes. This information is critical in preparing subsequent rehabilitation plans, cleaning requirements to restore capacity and updating of the system maps. Inspection personnel will use digital cameras during the inspection of all manholes on this project. All photographs will be included in the field inspection computer database so that a permanent electronic record can be maintained. During inspection, each of the following types of information will be obtained to establish the condition and prioritize least cost repairs: 1. Manhole/Cleanout ID 2. Inspection Status — (including buried, could not locate, etc) 3. Address and GPS coordinates (sub -meter x,y) of manhole 4. Surface cover, grade, type of cover (paved, yard, etc.) 5. Material of construction — brick, concrete, etc. 6. Area and Internal photos of manhole 7. All incoming and outgoing pipe depths from rim to invert 8. All incoming and outgoing pipe digital photographs 9. Defects — Active, Evidence or No Infiltration/Inflow with digital photographs 10. Field corrections to collection system map Upon completion of the manhole inspection, a prioritized manhole rehabilitation report will be prepared that will include: • Documentation with summary of field observations • List of manholes/lines requiring immediate attention • Digital photos • Documentation for preparing manhole rehabilitation quantities • Field updated map(s) • Prioritized Manhole Repair Recommendations and Cost Estimates To Be Provided by the District: 38 of 61 December 14, 2021 Complete Agenda Packet • Access (if requested) to manholes that are buried or could not be opened. • Assistance in locating assets (if requested) Measurement of Payment: Payment for this work task shall be a unit price for each manhole documented. Those manholes that are located, but buried or could not be opened will be noted and a list provided to the District. Manholes that could not be located using metal detectors or probes will be listed as Could Not Locate (CNL). CNL manholes will not be billed. Manholes located, but were buried or could not be opened will be billed. The District will provide replacement covers at no cost should a cover be broken while attempting opening. TASK 300 SMOKE TESTING OF STUDY AREA Smoke testing of Basins 2 and 5 will provide detailed information on wet weather inflow sources for the study area. In order to identify defects in the lines, a non-toxic smoke will be forced into the sewer by high capacity blowers. Data documentation includes measurements from two permanent points and will be sufficient to establish the location of each defect and determine the best repair method and priority. Color digital photographs will be taken to document each defect during the smoke test. The estimated total footage to be smoke tested is 38,012 linear feet. Forty-eight (48) hours prior to testing, door hangers will be used to notify residents. A telephone number will be provided for those individuals with questions or for anyone requiring special assistance. Each day the fire department will be notified of the crew location since smoke may enter homes through defective plumbing. To Be Provided by the District: • Review and approval of Notice to Residents • Letter of introduction to be carried by field crews • Previous smoke testing data, if any Final Report Deliverables: • Defects listing and database • Defect location sketch • Digital photographs • Smoke Notification Flyers and Notification of Residents • Priority ranking of defects (both private and public sector) • Repair methods and estimated costs 39 of 61 December 14, 2021 Complete Agenda Packet 511 TROPHY CLUB MUNI CIPAL tr ILI Y DIsTRL 1' SMOKE TESTING NOTICE TO RESIDENT For the next few days, inspection crews will conduct a physical survey of the wastewater collection system. Pipeline Analysis will perform this study, which involves opening manholes in the streets and backyard utility easements. Information gained from this study will be used to repair and improve the wastewater collection system. One important task of the survey will be smoke testing of sewer lines to locate breaks and defects in the system. During this testing, white smoke will exit through vent pipes on the roofs of homes and through sewer line breaks. The smoke is non-toxic, leaves no residue, and creates no fire hazard. The smoke should not enter your home unless defective plumbing exists or drain traps are dry. If you have seldom -used drains, please pour a gallon of water in the drain to fill the drain trap. This procedure will help prevent the possibility of smoke entering your living areas through those drains. Field crews will perform testing of all sewers in the area. At no time will field crews have to enter your business or residence. Your cooperation is appreciated. Should you have any additional questions concerning this study or if you desire special assistance, please phone: 800-637-0164 PIPELINE ANALYSIS'" WASTEWATER COLLECTION SYSTEM ENGINEERS 40 of 61 December 14, 2021 Complete Agenda Packet Task 400 Dye Flooding Dye water testing can be anticipated to assist in locating specific defects during the evaluation. Non-toxic dye will be introduced as a powder or liquid. Cross -connections, roof drains and area drains that are suspected of being connected to the sanitary sewer will be positively identified using the dye tracer procedure. Field documentation and photographs will be used to record all findings. Internal inspection will determine the exact source of the `cross -connection' and establish the best repair option (i.e., point repair, direct connection, etc.). Three dye flood locations are estimated. To Be Provided by the District: • Water for dye flooding at no cost to Engineer TASK 500 & 600 CLEANING AND CCTV Preparatory cleaning shall consist of hydraulic jet cleaning to facilitate the internal CCTV inspection. Preparatory cleaning will consist of not more than three passes of the jet hose (normal cleaning). Heavy cleaning to remove large deposits of debris is not included in this work task. Debris will be removed from the line and transported for disposal. CCTV investigation is found to be critical in establishing the mainline condition and best practical repair methods. The total footage in Basins 2 and 5 for cleaning and CCTV inspection is estimated to be 38,012 linear feet. The following information will be gathered: 1. Field forms, equipment, supplies and oversight QA/QC 2. Document findings. Data to include: a. Date inspected b. Line segment being inspected c. Project name d. Location (Address) e. Footage location from manhole f. Defect code and/or type and severity rating using the national Pipeline Assessment Certification Program (PACP) codes g. Pipeline surface cover 3. Review video and logs 4. Provide reports on of segments televised in electronic format 5. Summary of line segments cleaned and CCTV'd 6. Results of TV inspection provided on printed logs 7. Prepare prioritized mainline rehabilitation plan To Be Provided by the District: • Access to site of work for placement of equipment and personnel 41 of 61 December 14, 2021 Complete Agenda Packet • Disposal of any debris removed from the sewer system • Water for cleaning and dye testing at no cost to engineer • Listing of problem mainline sewers within the study area Measurement of Payment: Pipeline Analysis will invoice for the actual linear feet of sewer cleaned per the unit price specified in Exhibit A. In the case of CCTV, should the camera not be able to pass the entire length of the segment (due to protruding taps, roots, dropped joints, etc.), then an attempt will be made from the opposite direction (if possible). Where a reverse setup was attempted, then the entire segment length will be billed at the unit price specified. If a reverse setup cannot be performed, then the actual segment footage CCTV'd will be billed. TASK 700 ADMINISTRATION AND PROJECT MANAGEMENT This task includes internal project administration and oversight including scheduling, budget, quality assurance and control meetings and reporting. The project schedule will be reviewed and milestones for the completion of each task will be assigned. The project schedule will be reviewed and updated monthly to ensure that all tasks are completed in a timely and organized fashion. Management work items include: 1. Field crew supervision and project planning 2. Prepare monthly billings 3. Schedule equipment and order supplies Major system deficiencies that are identified during the field inspections that if corrected would result in significant reduction in Nor is deemed to be of a safety concern will be recorded and forwarded as soon as possible to the District's designated project manager. Likewise, should the District undertake a major repair within the study area, they will notify ENGINEER to determine the impact on data analysis. Deliverables: 1. Monthly invoice 2. Status reports 3. Project schedule and updates To Be Provided by the District: • All reports or materials deemed necessary by ENGINEER and identified during the course of the project that is not specifically stated above will be provided at no additional cost to the ENGINEER 42 of 61 December 14, 2021 Complete Agenda Packet TASK 800 DEFECT ANALYSIS/ REHABILITATION This project will generate a considerable amount of data that will require proper entry and quality control. Data collection will include the following: 1. All collected data will be integrated into the project existing defect database and will be compatible with ArcGIS. 2. All collected defect data will be correlated between sources to address duplicate defects that were identified by different testing methods. Identify duplicate defects to ensure multiple rehabilitation methods are not recommended for the same defect. 3. Defect data will be presented graphically (data visualization). 4. Much of the baseline data required for rehabilitation decision is gathered during the normal course of field investigations. For example, "area photos" are taken of each manhole in the direction of the outgoing pipe. This photograph not only shows the location of the manhole but also provide data on the line cover and easement conditions. 5. Since private sector defects can contribute to excessive inflow, proper documentation for subsequent repair is important. Property owner address, photograph and sufficient information to document the defect will be recorded and incorporated into the District database. Private sector defects will be prioritized and repair methods/costs established. 6. Rehabilitation recommendations will consider the best repair for the particular asset (manhole, pipeline, etc.) being rehabilitated. A long-term least -cost solution may have an initial higher cost, but provide a higher level of service and lower operating and maintenance cost. Supporting data will be provided on accompanying flash drive. To Be Provided by the District: • Complaint records and SSO database if requested • Review and comments on rehabilitation methods, cost estimates, and alternatives TASK 900 FINAL SSES REPORT AND TCEQ ANNUAL PROGRESS REPORT Prepare and submit three (3) Final SSES Reports and electronic data that includes the following: • Executive Summary • Description of all tasks • Manhole and pipe inspection summary/inventory • Manhole and pipeline defect summary • Service lateral defect summary • Smoke test data summary • CCTV data summary • Recommendations and Cost Estimates for Private and Public sector repairs Compile applicable information necessary to complete and submit the TCEQ SSOI Annual Progress Report (TCEQ Form 20595) on behalf of the District as stipulated in the SSOI Agreement Enforcement Case No. 59814. 43 of 61 December 14, 2021 Complete Agenda Packet Basin 1 Study Area Map Manhole Inspection Only 44 of 61 December 14, 2021 Complete Agenda Packet Basin 2 Study Area Map Manhole Inspection, Smoke Testing and CCTV Inspection 45 of 61 December 14, 2021 Complete Agenda Packet Basin 5 Study Area Map Manhole Inspection, Smoke Testing and CCTV Inspection 46 of 61 December 14, 2021 Complete Agenda Packet Exhibit A Project Cost and Schedule Year 2 — Basins 1, 2 and 5 Basins 1, 2 and 5 Condition Assessment Task Description Estimated Quantity Unit Price Total 100 Mobilization L.S. L.S. 200 Manhole/Pipe Inspection -(100%) 374 $115.00 300 Smoke Testing, Public Awareness, Data Entry & Analysis (100%) 38,012 $ 0.56 400 Dye Flooding 3 $225.00 500 Reparatory Cleaning 38,012 $ 1.55 600 CCTV Inspection 38,012 $ 1.35 700 Admin.,Project Mgt. L.S. L.S. 800 Defect Analysis/Rehab. L.S. L.S. 900 Database, Cost Estimates, Mapping, Final Reports L.S. L.S. $ 1,650.00 $ 43,010.00 $ 21,286.72 $ 675.00 $ 58,918.60 $ 51,316.20 $ 1,575.00 $ 1,375.00 $ 8,440.00 Total Not To Exceed $188,246.52 Task Description Month 1 2 3 4 5 6 7 8 100 Mobilization 200 Manhole/Ripe Inspection -(100%) 300 Smoke Testing, Public Awareness, Data Entry & Analysis (100%) 400 Dye Flooding 500 Preparatory Cleaning 600 CCTV Inspection 700 Admin.,Project Mgt. 800 Defect Analysis/Rehab. 900 Database, Cost Estimates, Mapping, Final Reports 47 of 61 Estimated Quantity 374 38,012 5 38,012 38,012 December 14, 2021 Complete Agenda Packet WORK ORDER MANAGER The Work Order Manager will be the primary contact person during performance of this work and will provide the ENGINEER the basin study area(s) to be inspected. All correspondence or inquiries should be addressed to the Work Order Manager. This work task will be coordinated by: Alan Fourmentin General Manager 682-831-4600 afourmentin aatcmud.orq APPROVAL The undersigned has reviewed and approved this Work Order and authorizes Pipeline Analysis LLC to perform the work as presented: Authorized by: Alan Fourmentin General Manager (Date) ACCEPTED BY The undersigned has reviewed and approved this Work Order. Pipeline Analysis is authorized to perform the scope of services in Work Order 1 as presented without exceeding contract not -to -exceed limits. Authorized by: James H. Forbes, Jr., P.E. President November 17, 2021 48 of 61 TROPHIC CLUB MUNICIPAL UTILITY' DISTRICT STAFF REPORT December 14, 2021 December 14, 2021 Complete Agenda Packet AGENDA ITEM: Consider and act regarding approval of Contract No. 2021121401 with Core Construction for services related to the construction of office space within the water maintenance facility and authorize the General Manager to execute the contract documents DESCRIPTION: The purpose of this construction is to provide office space for the Water Supervisor and a location for a general use computer for staff accessing District files and work orders. The existing area was previously utilized as storage and no longer needed. This office space will allow efficiency of staff oversight, vendor access, utilization of newly integrated CMMS, and forthcoming electronic resource planning software. ATTACHMENT: Proposal Job Order Contract RECOMMENDATION: Staff recommends the Board of Directors approve Contract No. 2021121401 with Core Construction for services related to the construction of office space within the water maintenance facility at a total cost not to exceed $37,013 and authorize the General Manager to execute the contract documents. 49 of 61 December 14, 2021 Complete Agenda Packet CARE Date: November 30th 2021 Owner: Trophy Club Municipal Utility District No. 1 Project: 21-04-118 — Maintenance Office Build Out Location: Trophy Club, Texas Procurement: Equalis Group: EQ -101519-02A 6320 Research Rd. Frisco, TX 75033 T 972.668.9340 F 972.668.9351 CORE Construction is pleased to provide you with this proposal. Enclosed you will find the basis of estimate clarifications and schedule of values which includes the requested scope of work, general conditions, sales tax, bonds, insurances, and fee. Total Proposal - $37,013 We look forward to a successful and enjoyable project together. Thank you for this opportunity, please do not hesitate to contact me directly with any questions or comments. Respectfully submitted, 2a/rvve/1- nolzwirkv. James Norwine CORE Construction Services of Texas, Inc. 50 of 61 www.coreconstruction.com December 14, 2021 Complete Agenda Packet The Basis of Estimate is a written explanation clarifying the scope, assumptions and exclusions used in establishing this proposal. All costs are developed through site walk conducted, and the scope clarifications below. Assumptions, Clarifications, & Exclusions Schedule • Anticipated Start: Two weeks from approved PO • Long Lead Items: N/A • Projected Duration: 2 weeks Contingency & Allowances • We have included a 5% Contractor Contingency in this proposal — Construction Contingency is intended to be used at CORE's discretion to cover costs that have not been identified as a trade specific scope during the scope walk-thru and/or (if provided) project plans and specifications and may require further clarification or coordination. These costs may include but are not limited to scope gap, coordination issues, overtime, expediting, missed scope during, etc. Construction Contingency does not account for design revisions or additional scope requests made by the Owner or Architect. • We have NOT included a Design Contingency in this proposal - Design Contingency is intended to be used at CORE's discretion to cover costs associated with the completion of the design and/or scopes of work for which sufficient detail was not available to determine a definitive cost. A reasonable estimate for an assumed scope and quality is included as a placeholder. General Assumptions • This cost proposal is considered a Lump Sum, not line -item Estimate. • General Conditions and/or General Requirements are considered cost of the work. • A registered professional did not provide sealed plans or specifications. CORE Construction Services of Texas, Inc. shall not be held responsible for performance of systems or equipment, code interpretations, engineering, etc. requirements and will perform the requested scope of work as defined by the Owner representative(s). • Proposal valid for 30 days, unless otherwise directed by CORE Construction. Specific Assumptions • General finish out permit included. DEMOLITION — • Remove existing light fixtures, plywood on walls, cut opening in existing wall for new door, cut opening in existing wall for new window. INTERIOR FINISHES — • Doors, Frames, & Hardware — 0 www.coreconstruction.com 51 of 61 December 14, 2021 Complete Agenda Packet o Provide and install two (2) new doors, frames and hardware, residential style o Provide and install two (2) new windows, residential style • Metal Studs, Drywall & Paint — o Build new partition wall to divide current space into two. o New framing to be metal stud. o Drywall all walls and ceiling. o Tap, Bed, and paint all new walls and ceiling o Framing and blocking needed for new doors and windows • Flooring — o Existing concrete floor to be cleaned and stained. MEP SYSTEMS — • Electrical System — o Provide and install four (4) new surface mounted, Flat panel, LED lights. o Provide and install nine (9) outlets • HVAC — o Provide and install new supply and return grills for new space. To be run from existing system serving the adjacent break room. Specific Exclusions • Removal of materials and equipment currently stored in space. • Hazardous Material Abatement • Costs associated with Material Testing and/or Special Inspections • Costs associated with General Building Inspections • FF & E — Furniture, Fixtures, and Equipment (by Owner) • Structural modifications (i.e. - Steel, Concrete & Masonry removal or replacement) • Signage (by Owner) • Visual Display Boards • Finish Carpentry & Millwork • Fire Sprinkler & Alarm Systems • Fire Extinguisher's, AED's & Cabinets • HVAC Systems, Controls & Test and Balance • Access Doors & Frames • Security Systems (i.e. - Camera's, Access Control, etc.) • Structured Cabling (i.e. - Voice & Data, Cable, etc.) • Audio/Visual Systems (i.e. - Displays, Speakers, Projectors, Screens, etc.) X Trophy Club Municipal Utility District No. 1 Approved By: 52 of 61 0 www.coreconstruction.com mber 14, 2021 Complete Agenda Packet ©equa ROUP is G CORE Construction & Equalis Group Publicly Procured Master Agreement Contract #R10 -1117E Region 10 Education Service Center (Region 10), an Equalis Group Lead Agency, issued RFP #R10-1117 for Texas Job Order Contracting (JOC) on February 5, 2021, and subsequently entered into Contract #R10 -1117E with CORE Construction as the lowest responsive and responsible bidder. Contract Information Effective Date: Expiration Date: Renewable Through: May 1, 2021 April 30, 2023 April 30, 2026 Additional information regarding the procurement process and contract award can be found on the Texas JOC — CORE Construction Landing Page at the Equalis Group website, including the CORE Construction products and services available through the Master Agreement, RFP and scoring documents, the Master Agreement between Region 10 and CORE Construction, and pricing/discount model. Entities Eligible to Purchase from CORE Construction through the Master Agreement This contract vehicle is immediately available to existing Equalis Group Members. Not a Member yet? Any public sector entity in the country can join Equalis Group and begin utilizing any Equalis Group competitively solicited master agreement by completing the membership registration form. New Members receive a fully executed copy of their completed membership form via email immediately and will receive their Equalis Group membership number within one -to -two days. There are no dues, fees, or obligations and completing the form takes less than five minutes. Help with Membership, Procurement Questions & Navigating Our Contract Portfolio Equalis Group's dedicated Member Engagement Team exists to support our Members. The team is readily accessible and is prepared to answer questions about membership, public sector purchasing compliance, Equalis Group's procurement and contracting processes, and our portfolio of more than 100 already -procured contract vehicles. Current and prospective Members can find their Member Engagement Team point person and direct contact information here. View all Equalis Group contracts and download a sortable Excel file with key information about each contract in our ever- expanding portfolio here. About Equalis Equalis Group is a Public Sector purchasing cooperative. We deliver compliant, publicly procured cooperative agreements that Public Sector entities across the country can utilize to: i) quickly acquire the products and services they need; 11) receive better pricing through the collective buying power of Equalis Group Members; and, iii) save time through Equalis Group's legal and compliant alternative to conducting their own resource -consuming solicitation process. Equalis Group partners with two primary Lead Agencies, Region 10 Education Service Center (Region 10) in Texas and The Cooperative Council of Governments (CCOG) in Ohio, to conduct rigorous and transparent competitive public sector procurement processes for critical products and services. Winning suppliers, distributors, and manufacturers are selected based on both qualitative criteria and pricing. We then establish compliant already -procured Master Agreements with the winning vendors. Equalis Group 1 5550 Granite Pkwy. Ste 298 Plano, TX 75024 1 www.equalisgroup.org 53 of 61 TROPHIC CLUB MUNICIPAL UTILITY' DISTRICT STAFF REPORT December 14, 2021 December 14, 2021 Complete Agenda Packet AGENDA ITEM: Consider and act regarding approval of proposal with Prime Controls, LP for services related to the District supervisory control and data acquisition (SCADA) system and authorize the General Manager to execute the necessary work order documents to implement Board action. DESCRIPTION: The purpose of this agreement is to upgrade the SCADA Human Machine Interface (HMI) software for the district water distribution, wastewater treatment and collections systems and intended to provide an updated robust system that is scalable and resilient to meet the current and future demands of the district. The current HMI application, National Instruments Lookout, used for monitoring and control of the water system is running the legacy HMI application software, which is considered end of life and is no longer supported by the manufacturer. The existing controls system software will be transitioned to the new HMI application Factory Talk View for the water distribution system including installation of the software, configuration of water system historian, and development of operational reports and associated training. The existing HMI application for the wastewater treatment plant was developed around the Kubota membrane system utilizing Rockwell Automation Factory Talk View Site Edition Version 8.20. This agreement will upgrade the existing application from version 8.20 to version 11 and relicensing to the district. Updates will provide installation of the software, configuration of wastewater treatment plant historian, migration of the lift station control from the water distribution system to the wastewater system HMI application, addition of a wastewater collections screen for monitoring and control of lift stations, addition of applicable lift station points to the wastewater treatment plant historian, and development of operational reports and associated training. ATTACHMENT: Proposal RECOMMENDATION: Staff recommends the Board of Directors approve the proposal with Prime Control, LP for services related to the District SCADA system at a total cost not to exceed $228,364 and authorize the General Manager to execute the necessary documents to implement Board action. 54 of 61 December 14, 2021 Complete Agenda Packet PRIME CONTROLS 1725 LAKEPOINTE DRIVE i LEWISVILLE, TX 75057 PHONE 972-221-4849 n FAX 972-420-4842 December 3, 2021 To: Trophy Club Municipal Utility District No. 1 Attn: Mike McMahon- Operations Manager Ref: HMI System Upgrades Water Distribution & Wastewater Treatment Systems Prime Controls Quote No.: TCMHMIU8321R2 PRIME CONTROLS PROPOSAL Prime Controls, L.P. understands that Trophy Club Municipal Utility District No. 1 (the "District") is seeking to upgrade their Human Machine Interface (HMI) software for the Wastewater Water Treatment and Water Distributions Systems. This upgrade project is intended to provide a robust system that is scalable and resielent to meet the current and future demands for the district. The scope of services described below are based on our site observations and discussions with operations staff. Our proposal is based the recommendations described in Section A "Systems Overview" and is based on providing the following major products, equipment, and services detailed in section B & C of this proposal. Our proposal is considered complete, with the exception of those items specifically excluded within the "Exclusions" section C of this proposal. A. SYSTEM OVERVIEW WATER DISTRIBUTION SYSTEM The HMI application used for monitoring and control of the Water Delivery system resides at the Main Pump Station facility. There is one (1) operator workstation, at the Main Pump Station that is running the legacy HMI application software, (National Instruments Lookout). This application is considered end of life and is not supported by the manufacture anymore. The following equipment/systems are monitored and controlled through this application: • East & West Elevated Storage Tanks (EST) • East & West Ground Storage Tanks (GST) • Well Pumps 1&2 • Pump Station Generator • Influent & Effluent Meter Vaults • Nine (9) wastewater lift stations Prime Controls Proposal Page 1 of 5 55 of 61 PRIME CONTROLS December 14, 2021 Complete Agenda Packet Water Distribution System Improvements/ Enhancements Based our site observations and discussions with operations staff we are proposing the following improvements/ enhancements to the system. ITEM 1. 2. 3. 4. 6. DESCRIPTION Upgrade the Legacy HMI application from Lookout to Factory Talk View SE. Hosted on a redundant server located at the operations building and WWTP facility. Develop and deploy new control screens based on Factory Talk Objects. Furnish, install, and configure network switch, cellular modem in the existing PLC enclosure at the pumpstation control bld. Setup, configure, and deploy the new HMI application in a virtualized environment with the systems redundancy. Redundant application to be installed on District provided servers/ hardware located at the operations building. Migrate nine (9) lift stations to the Wastewater and Collections systems HMI application (Reference WWTP Scope) 7. Reconfigure the existing operator workstation computer to be utilized as a client operator station connected to the server -based application WASTEWATER & COLLECTIONS SYSTEM The HMI application utilized for monitoring and control of the Wastewater Treatment system resides the at the Wastewater Treatment Facility. There are three (3) local operator workstations at this facility that are used for monitoring and controlling the treatment process. The HMI application for this system is Rockwell Automation Factory Talk View Site Edition Version 8.20. The following equipment/systems are monitored and controlled through this application: • Kubota Membrane System • PA & WAS System • Influent Flow & Bar Screen • Plant Lift Station • Grit System • Plant Effluent & UV System Wastewater System Improvements/ Enhancements The existing HMI application for the Wastewater Treatment Plant was developed around the Kubota Membrane system. Based our site observations and discussions with operations staff we are recommending that the HMI application, for this facility, be upgraded to the latest version verses being replaced. In addition to upgrading the software to latest version we are the proposing the following enhancements to the system. Prime Controls Proposal Page 2 of 5 56 of 61 PRIME CONTROLS December 14, 2021 Complete Agenda Packet ITEM DESCRIPTION 1. Upgrade the Factory Talk View Site Edition HMI application from version 8.20 to version 11. 2. Relicense the Factory Talk HMI software to the District. Tech Connect software agreement will need to be established between Rockwell Automation and the District in order to upgrade to the latest version. 3. Furnish and install a wall mounted network rack with server, network switch, and UPS backup in the operations building. Reconfigure the existing HMI application in a virtualized environment with systems redundancy. Redundant application to be installed on District provided servers/ hardware located at the operations building. 4. Provide, Install, and configure a 1000 Tag Plant Historian. 5. Migrate the remote lift station control from the Water Distribution system to the Wastewater Treatment HMI application. Add a collections screen, for monitor and control of the remote lift stations and add applicable points to Plant Historian. 6. Establish remote connectivity for monitoring and control of the lift stations via cellular modem link and District leased fiber. 7. Setup and configure VPN Tunnels for cellular communication between the Water PS the Wastewater Treatment Plant. 8. Setup and configure XL reporter to pull data points from the plant Historian. 9. Develop 1-2 Plant reports for plant staff and provide training on how to pull in historical data from the historian and develop reports in XL reporter. B. CONTROL PANELS AND MAJOR PRODUCTS Material shall be furnished per plans and specifications. Major products and control panels to be furnished by Prime Controls include the following: WATER DISTRIBUTION SYSTEM ITEM QTY DESCRIPTION 1. 1 Cellular Modem 2. 1 Din Rail Mounted Network Switch 3. 1 Data Concentrator PLC Enclosure with Cellular Modem for Remote Site Communications - Installed in Operations Building WASTEWATER TREATMENT PLANT & COLLECTIONS SYSTEMS ITEM QTY DESCRIPTION 4. 1 Wall Mount Network Rack including (Installed in the Operations Bld.) • Dell Server • Rack Mount Network Switch • UPS & Power Distribution 5. 1 Cellular Modem & Network Switch -(Installed in network rack at the WWTP plant Ops Bld.) Prime Controls Proposal Page 3 of 5 57 of 61 PRIME CONTROLS December 14, 2021 Complete Agenda Packet CONTROL SYSTEM SOFTWARE 6. 1 Licensed Copy of Factory Talk View SE Unlimited Display Redundant Server software 7. LOT Licensed Copies of Factory Talk View SE 10 Client Bundle 8. 1 Licensed Copy or Factory Talk Server OPC Server Enterprise Software -2nd License for systems redundancy 9. 1 Licensed Copy of Factory Talk Historian 1K I/O Tags with advanced server options for reporting 10. 1 Licensed Copy of XL reporter 11. 2 Licensed Copies of Kepware enterprise (OPC software needed to communicate with Water System PLC's) C. SERVICES Services to be provided by Prime Controls include the following major items: ITEM SERVICE 1. Onsite field assessment and testing of the existing controls system prior to upgrade. 2. Administer 1-2 control system / HMI workshops with operations staff during the design and development phase of the new control screens. 3. HMI/SCADA System Software Development and Programming Services associated with migrating the existing legacy controls system software (National Instruments Lookout) to the new HMI application Factory Talk View for the Water Distribution System. 4. HMI/SCADA System Software Development and Programming Services associated with adding new controls screens to the Wastewater Treatment HMI Application. 5. Setup and configuration services associated with migrating the existing operator workstation(s) from the legacy HMI application to the new system. 6. Field Calibration, Check -Out and Start -Up Services 7. Factory and Site Acceptance Testing with operations staff prior to onsite deployment. 8. Operator and Maintenance training services. 9. Operations and Maintenance Documentation for new hardware and software. 10. One year (1) warranty services for provided equipment and systems upon final completion of the project. D. PROPOSAL EXCLUSIONS The following items are not included in our pricing and shall be the responsibility of others: ITEM EXCLUSION 1. Furnishing / providing server and operator workstation hardware associated at the Operations Center for backup and redundancy. Any hardware required will be provided by the Trophy Club MUD No.1 IT Department. Hardware sizing requirements /specifications for procurement purposes will be provided by Prime Controls. Prime Controls Proposal Page 4 of 5 58 of 61 PRIME 1 CONTROLS December 14, 2021 Complete Agenda Packet ITEM EXCLUSION 2. Furnishing/ providing Microsoft, virtualization, or remote accessibility software. All software will be provided by Trophy Club Municipal Utility District No. 1 IT Department unless specifically listed above. 3. Furnishing or installation of network hardware and infrastructure for connection between the Operations center and the Wastewater Treatment and Water Distribution Facilities. 4. Internet service provider data plan services /expenses for cellular modems. 5. Furnishing or installation of remote alarming software. 6. Disposal of removed or demolished material. Such material will be turned over to the owner for salvage or disposal. E. PROPOSAL CLARIFICATIONS ITEM CLARIFICATION 1. Pricing does not include Sales Taxes or Bonding costs. 2. Pricing shall be valid for 90 days only from proposal date. 3. Pricing is based on the assumption that, once Prime Controls receives an order or notice to Proceed, the project will proceed without interruption. Should any interruptions occur due to Force Majeure, Prime Controls reserves the right to adjust pricing accordingly. 4. Pricing is based on GSA Agreement / Contract # GS -35F -0455W F. PROPOSAL PRICING Item Description Pricing 1 Controls Systems work associated with the Water Distribution System $48,366.00 2 Controls Systems work associated with the Wastewater Treatment $72,550.00 System ' 3 Controls System Software (Combined Factory Talk Package) $64,391.00 4 Controls System Hardware $43,057.00 TOTAL AMOUNT $228,364.00 We sincerely appreciate this opportunity and look forward to being of service for this work. Thanks again and please feel free to call if there are any questions. Sincerely, Prime Controls, LP Lain Cloy, PMP Account Manager Ph. 972-221-4849 Email I.cloyParime-controls.com Prime Controls Proposal Page 5 of 5 59 of 61 1 West Tower Control Room Main Pump Station MCP CONTROL PANEL I�� • -- • � MAG3 Data Concentrator & Cell Modem December 14, 2021 Complete Agenda Packet Trophy Club Municipal Utility District No. 1 Current & Proposed Network Architecture Client Ws 1 City Operations r 'r afar, Redundant VM Server (Secondary) Provided by Trophy Club Factory Talk Server • SCADA App & I/O WWTP Facility Admin Building NETWORK RACK 60 of 61 Network Switch Ilrs=r,ri Server (()) Cell Modem Operations Building East Tower (Repeater Site) Client WS 1 Factory Talk Server (Primary) • SCALA App & I/O • Historian • Reporting App Control Room MBR Control Panel MCP CONTROL PANEL RIO 1& 2 RIO 3&4 RIO 5 & 6 RIO I W L5#1 LS#2 LS # 3 LS#4 LS#5 L5#6 L5#7 L5#8 LS#9 Trophy Club Municipal Utility District No. Calendars Board Room -nuary Sun 1 Dec 26, 2021 2 3 4 5 2 9 16 23 6 30 December 14, 2021 Complete Agenda Packet Laurie Slaght Mon Tue Wed Thu Fri Sat 27 3 10 17 24 28 29 30 31 4 11 18 25 5 12 19 6:30pm Board of Dir 26 6 13 20 27 7 14 21 28 Jan 1 8 15 22 29 31 Feb 1 2 3 4 5 61 of 61 0 Central Time US & Ca Powered by T teamup