HomeMy WebLinkAbout2023-0215 February 15,2023 Regular Meeting Agenda PacketSPA
TROPHY CLUB
MUNICIPAL /
UTILITY
DISTRICT
BOARD OF DIRECTORS
REGULAR MEETING
February 15, 2023 Agenda Packet
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
100 MUNICIPAL DRIVE
TROPHY CLUB, TEXAS 76262
Wednesday, February 15, 2023
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. January 2023 Combined Financials
b. January 18, 2023 Regular Meeting Minutes
Attachments: January Financials
January 18, 2023 Meeting Minutes
REGULAR SESSION
3. Discussion and possible action regarding customer deposits. (Carr)
1of32
February 15, 2023 Agenda Packet
Attachment: Staff Report
4. Discussion and possible action regarding District Reserve Policy (Rose)
Attachment: Reserve Charts
5. Receive update from Strategic Committee. (Carr/Brewster)
EXECUTIVE SESSION
6. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in
Executive Session on a matter in which the duty of the attorney to the Governmental Body under the
Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open
Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation
or settlement offers:
a. Consult with legal counsel to secure legal advice concerning joint strategic planning with the Town
of Trophy Club.
REGULAR SESSION
7. Consider and act regarding items discussed in Executive Session.
8. Discussion and possible action regarding approval of publication for Request for Qualifications (RFQ) for
general legal counsel. (Brewster)
9. Items for future agendas:
10. Set future Meeting dates - March 22, 2023 at 6:30 p.m.
Attachment: March 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
2 of 32
15,1
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
February 15, 2023 Agenda Packet
Capital Improvement Projects
• FY 2022 Water Line Project — Final punch list items have been completed along Creek Courts
Drive and Wilshire Drive. Contingency allowances will be utilized to replace five service lines
on Hilltop Court, two service lines on Oak Hill Drive, and one three-inch service line on
Village Circle in Solana, which are expected to be completed within the next few weeks.
• FY 2023 Water Line Project — Design is in progress for the replacement of approximately
6,000 linear feet of water lines along and adjacent to Sunset Drive, Berkshire Court, Lee
Court, Riviera Court, and Skyline Drive as a part of FY 2023 Capital Improvement Projects.
The design is 90% complete and bidding is scheduled for March 2023.
• Pump Station Improvement Project — Design is in progress for the replacement of two (2)
vertical turbine pumps, incorporation of variable frequency drives, and replacement of
discharge header piping and valves within the high service pump station. The design is 60%
complete and bidding is scheduled for July 2023.
• Supervisory Control and Data Acquisition (SCADA) Upgrades — The new system is in full
operation and hardware has been installed to provide redundancy between the water and
wastewater facilities.
• Membrane Bioreactor (MBR) Piping Improvements — Materials have been ordered and
construction will commence at the wastewater treatment plant once received. The
expected project completion is June 2023.
• Lift Station #1 — The cleaning and sand blasting of the wet well is complete. Grouting and
epoxy coating the wet well was delayed due to weather. Installation of pump rails, pumps,
pipe, valves, instrumentation, and electrical panels will begin once the wet well is coated,
and concrete is complete. Most of this work is expected to be performed in February.
• Lift Station Generators — This project consists of installation of onsite diesel generators and
automatic transfer switches at eight (8) lift station sites allowing for further resiliency within
the wastewater collections system during power outages. Notice to Procure was provided
to the contractor in November 2022. Delivery of the generators is scheduled for December
2023 with an anticipated completion date of April 2024. The schedule to begin underground
and sitework will be dependent on the generator delivery dates.
3 of 32
15,1
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
February 15, 2023 Agenda Packet
• FY 2023 Wastewater Improvements — Proposals are being obtained to complete
recommended rehabilitation and repairs resulting from the annual wastewater system
analysis performed in FY 2022.
• FY 2023 Lift Station Improvements — Replacement of piping and valves at Lift Station #2 has
been completed. Materials for Lift Station #3 have been received and the replacement
schedule is in progress.
• Southlake emergency connection — An evaluation was performed to determine the
feasibility of an emergency connection of the District water system to the City of Southlake
water system. An emergency connection between the District and Southlake water systems
is intended to allow the District to meet customer demands in emergency scenarios where
the District requires supplemental water supply if the District's primary water supply being
unavailable or the occurrence of significant pipe break(s). It is anticipated that the
Southlake system can provide the service capacities to the District system at the emergency
connection; however, Southlake plans to perform a Water Master Plan Update that will
more accurately determine the impact of this emergency connection on their system, and
further confirm that an emergency demand could be met. This is expected to be completed
in the fall of 2023.
4 of 32
160,000
140,000
120,000
100,000
80,000
60,000
40,000
20,000
0
IM
Water Billed
February 15, 2023 Agenda Packet
-2019 -2020 -2021 -2022 -2023
FY October November December January February March April May June July August September Total Year
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 48,488 49,322 40,021 44,588 72,448 85,474 119,711 141,177 143,845 108,377 986,476
2023 101,683 49,007 52,466 57,576 260,732
160,000
140,000
120,000
100,000
80,000
60,000
40,000
20,000
0
Water Pumped
FY October November December January February March April May June July August September Total Year
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 54,930 52,679 49,094 51,606 81,977 92,915 133,828 152,199 161,534 117,252 1,101,020
2023 114,089 54,777 57,827 57,758 284,451
5 of 32
7
6
5
0
7 4
0
2 2
0
• Min
• Max
• Avg
20.0
18.0
16.0
14.0
12.0
10.0
8.0
6.0
4.0
2.0
0.0
February 15, 2023 Agenda Packet
Water Production
Jan -22
1.750
1.650
1.550
1.450
1.350
1.250
1.150
1.050
0.950
0.850
0.750
Jan -22
1.300
3.260
1.659
Feb -22
Mar -22
Apr -22
Feb -22
1.422
1.873
1.554
Mar -22
Apr -22
1.407
1.686
2.942
3.593
1.926
2.603
May -22
May -22
1.660
4.685
3.325
Jun -22
Jun -22
3.173
5.767
4.183
Jul -22
Jul -22
3.915
7.100
5.748
Wastewater Treated
Aug -22
Aug -22
2.348
7.325
4.704
Sep -22
Sep -22
1.889
5.277
3.948
I I .11 Ih
Oct -22 Nov -22
Oct -22
1.842
5.00
3.662
Nov -22
1.401
2.57
1.834
Dec -22 Jan -23
Dec -22 Jan -23
1.115 1.225
2.72 2.51
1.657 1.759
■ � �� ■� 1� 1� I� ■I II I I I
Jan -22
Jan -22 Feb -22
Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22
Daily Avg Flow Daily Max Flow -Daily Avg Max
Feb -22 Mar -22
Sep -22
Carbonaceous Biochemical Oxygen Demand (CBOD)
Apr -22 May -22 Jun -22 Jul -22
Oct -22 Nov -22
Aug -22 Sep -22 Oct -22 Nov -22
CBOD Avg - CBOD Max Daily Avg Max -Daily Max
6 of 32
Dec -22 Jan -23
J
Dec -22 Jan -23
40.0
35.0
30.0
25.0
20.0
15.0
10.0
5.0
0.0
10.00
9.00
8.00
7.00
6.00
5.00
4.00
3.00
2.00
1.00
0.00
Jan -22 Feb -22
Mar -22 Apr -22
Total Suspended Solids (TSS)
May -22 Jun -22 Jul -22 Aug -22
TSS Avg .TSS Max -Daily Avg Max -Daily Max
Ammonia Nitrogen (NH3)
Jan -22 Feb -22 Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22
50.0
40.0
30.0
20.0
10.0
0.0
M
Jan -22
NH3 Avg :NH3 Max
Daily Avg Max -Daily Max
Nitrate -Nitrogen (NO3)
Sep -22
February 15, 2023 Agenda Packet
Oct -22 Nov -22
Sep -22
Oct -22 Nov -22
Dec -22 Jan -23
Dec -22 Jan -23
Feb -22 Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23
NO3 Avg NO3 Max -Daily Avg Max -Daily Max
7 of 32
9
8.5
8
7.5
7
6.5
6
9.0
8.5
8.0
7.5
7.0
6.5
6.0
400
350
300
250
200
150
100
50
0
Potential of Hydrogen (pH)
February 15, 2023 Agenda Packet
11111111111 Ilinilli
Jan -22 Feb -22 Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23
pH Min pH Max pH Avg -Daily Avg Min -Daily Avg Max
Dissolved Oxygen (DO)
Jan -22 Feb -22 Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23
1.0
5.2
Jan -22 Feb -22
DO Min DO Max DO Avg -Daily Avg Min -Daily Avg Max
Escherichia coli (E. coli)
*Sep -22 is an outlier sample
1.0 1.0 1.0 1.0 1.0 2.0
Mar -22 Apr -22
May -22 Jun -22
307.0
3.0 1.0
6.3
2.0
Jul -22 Aug -22 *Sep -22 Oct -22 Nov -22 Dec -22 Jan -23
E. coli Avg E. coli Max -Daily Avg Max -Daily Max
8 of 32
February 15, 2023 Agenda Packet
Check Report
Trophy Club Municipal Utility District No. 1 By Check Number
Date Range: 01/01/2023 - 01/31/2023
Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number
Bank Code: Prosperity Bank -Prosperity Bank
Payment Type: Regular
2970 Air Mac 01/06/2023 Regular 0.00 552.00 9247
3197 BenefitMall 01/06/2023 Regular 0.00 52.00 9248
2497 DHS Automation Inc 01/06/2023 Regular 0.00 21,660.00 9249
3118 Exclusive Pest Control 01/06/2023 Regular 0.00 355.00 9250
3093 Four Man Furnace Inc. 01/06/2023 Regular 0.00 2,983.75 9251
4033 Health Care Service Corporation 01/06/2023 Regular 0.00 21,649.11 9252
2943 JP Morgan Chase Bank NA 01/06/2023 Regular 0.00 14,667.85 9253
3216 M3 Networks 01/06/2023 Regular 0.00 669.00 9257
3115 Metlife Group Benefits 01/06/2023 Regular 0.00 470.20 9258
2842 Omnisite 01/06/2023 Regular 0.00 290.00 9259
3110 Pump Solutions Inc 01/06/2023 Regular 0.00 4,680.00 9260
3156 Southern Petroleum Lab Inc 01/06/2023 Regular 0.00 988.80 9261
2696 Texas Excavation Safety System 01/06/2023 Regular 0.00 180.50 9262
1000 Trophy Club Mud (Water Bills) 01/06/2023 Regular 0.00 451.90 9263
2798 Tyler Technologies Inc 01/06/2023 Regular 0.00 5,591.30 9264
2634 Valley Solvents & Chemicals 01/06/2023 Regular 0.00 1,628.45 9265
2772 Allied Waste Industries 01/18/2023 Regular 0.00 7,920.53 9266
3127 Allied Welding Supply Inc. 01/18/2023 Regular 0.00 19.21 9267
1005 Atlas Utility Supply Co. 01/18/2023 Regular 0.00 3,676.54 9268
2738 Community National Title LLC 01/18/2023 Regular 0.00 1,126.47 9269
3184 Dataprose LLC 01/18/2023 Regular 0.00 2,402.00 9270
1179 Denton County Tax Office 01/18/2023 Regular 0.00 30.25 9271
1737 DPC Industries Inc. 01/18/2023 Regular 0.00 1,557.08 9272
2606 Fisery Solutions LLC 01/18/2023 Regular 0.00 50.00 9273
2796 Garver 01/18/2023 Regular 0.00 1,558.17 9274
1372 Hach Company 01/18/2023 Regular 0.00 1,768.04 9275
2635 Halff Associates Inc. 01/18/2023 Regular 0.00 3,515.66 9276
2775 Hudson Energy Services LLC 01/18/2023 Regular 0.00 23,370.55 9277
3278 Kyocera Document Solutions 01/18/2023 Regular 0.00 120.79 9278
2754 Lower Colorado River Authority 01/18/2023 Regular 0.00 213.92 9279
2643 Mclean & Howard LLP 01/18/2023 Regular 0.00 2,775.00 9280
2983 NTTA 01/18/2023 Regular 0.00 44.79 9281
1056 Office Depot Inc 01/18/2023 Regular 0.00 604.30 9282
1466 Polydyne, Inc 01/18/2023 Regular 0.00 4,046.85 9283
3176 Rey -Mar Construction 01/18/2023 Regular 0.00 252,606.40 9284
2698 Ritz Safety LLC 01/18/2023 Regular 0.00 123.55 9285
3156 Southern Petroleum Lab Inc 01/18/2023 Regular 0.00 1,455.60 9286
3182 Strategic Government Resources 01/18/2023 Regular 0.00 630.00 9287
2659 Tarrant Appraisal District 01/18/2023 Regular 0.00 2,609.26 9288
2440 Tarrant County Public Health Laboratory 01/18/2023 Regular 0.00 520.00 9289
1081 Tri County Electric 01/18/2023 Regular 0.00 800.34 9290
2798 Tyler Technologies Inc 01/18/2023 Regular 0.00 5,563.60 9291
2858 Utility Service Co, Inc. 01/18/2023 Regular 0.00 46,558.26 9292
2634 Valley Solvents & Chemicals 01/18/2023 Regular 0.00 846.05 9293
1058 Verizon Wireless 01/18/2023 Regular 0.00 857.12 9294
2222 Aflac 01/30/2023 Regular 0.00 405.80 9296
2970 Air Mac 01/30/2023 Regular 0.00 2,313.71 9297
3197 BenefitMall 01/30/2023 Regular 0.00 52.00 9298
1030 City of Fort Worth 01/30/2023 Regular 0.00 146,967.32 9299
1737 DPC Industries Inc. 01/30/2023 Regular 0.00 1,557.08 9300
1832 First Financial Bank 01/30/2023 Regular 0.00 98,078.79 9301
3258 Francotyp-Postalia, Inc. 01/30/2023 Regular 0.00 134.50 9302
2796 Garver 01/30/2023 Regular 0.00 30,021.77 9303
2/8/2023 6:04:21 PM Page 1 of 4
9 of 32
Check Report
Vendor Number
1372
4033
3132
3195
2754
3216
3186
3115
2392
2760
3176
2698
2809
2805
2695
3156
2798
3225
2634
3280
Vendor Name
Hach Company
Health Care Service Corporation
Legal Shield
Lou's Gloves Incorporated
Lower Colorado River Authority
M3 Networks
Member's Building Maintenance
Metlife Group Benefits
Mickey D Carson Dba/Nusco
NDS Leasing
Rey -Mar Construction
Ritz Safety LLC
Rod L Abbott CPA LLC
Scott Tucker Construction LLC
Southern Floors & Renovations
Southern Petroleum Lab Inc
Tyler Technologies Inc
US Bank Voyager Fleet Systems
Valley Solvents & Chemicals
Watts Ellison LLC
Payment Date
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
01/30/2023
Payment Type
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Regular
Total Regular:
February 15, 2023 Agenda Packet
Date Range: 01/01/2023 - 01/31/2023
Discount Amount
0.00 472.74 9304
0.00 24,291.29 9305
0.00 34.90 9306
0.00 244.00 9307
0.00 213.92 9308
0.00 562.00 9309
0.00 1,289.80 9310
0.00 4,116.98 9311
0.00 5,709.00 9312
0.00 175.00 9313
0.00 13,205.00 9314
0.00 189.47 9315
0.00 11,451.39 9316
0.00 211,627.43 9317
0.00 7,421.30 9318
0.00 757.20 9319
0.00 2,928.00 9320
0.00 2,398.70 9321
0.00 2,658.40 9322
0.00 650.38 9323
0.00 1,014,168.06
Payment Amount Number
2/8/2023 6:04:21 PM Page 2 of 4
10of32
February 15, 2023 Agenda Packet
Check Report Date Range: 01/01/2023 - 01/31/2023
Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number
Payment Type: Bank Draft
3197 BenefitMall 01/06/2023 Bank Draft 0.00 266.67 DFT0000029
3113 TCDRS 01/31/2023 Bank Draft 0.00 11,006.75 DFT0000030
3124 IRS Tax Payment 01/06/2023 Bank Draft 0.00 15,433.79 DFT0000031
3197 BenefitMall 01/20/2023 Bank Draft 0.00 266.67 DFT0000032
3113 TCDRS 01/31/2023 Bank Draft 0.00 9,868.93 DFT0000033
3124 IRS Tax Payment 01/20/2023 Bank Draft 0.00 13,575.20 DFT0000034
3113 TCDRS 01/31/2023 Bank Draft 0.00 526.65 DFT0000035
3124 IRS Tax Payment 01/20/2023 Bank Draft 0.00 754.93 DFT0000036
Total Bank Draft: 0.00 51,699.59
Bank Code Prosperity Bank Summary
Payable Payment
Payment Type Count Count Discount Payment
Regular Checks 107 73 0.00 1,014,168.06
Manual Checks 0 0 0.00 0.00
Voided Checks 0 0 0.00 0.00
Bank Drafts 8 8 0.00 51,699.59
EFT's 0 0 0.00 0.00
115 81 0.00 1,065,867.65
2/8/2023 6:04:21 PM Page 3 of 4
11 of 32
Check Report
February 15, 2023 Agenda Packet
Date Range: 01/01/2023 - 01/31/2023
All Bank Codes Check Summary
Payable Payment
Payment Type Count Count Discount Payment
Regular Checks 107 73 0.00 1,014,168.06
Manual Checks 0 0 0.00 0.00
Voided Checks 0 0 0.00 0.00
Bank Drafts 8 8 0.00 51,699.59
EFT's 0 0 0.00 0.00
115 81 0.00 1,065,867.65
Fund Summary
Fund Name Period Amount
996 MUD Consolidated Cash 1/2023 1,065,867.65
1,065,867.65
2/8/2023 6:04:21 PM Page 4 of 4
12of32
CASH STATUS AS OF JANUARY 2023
135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating ***
135-10300 Prosperity Bank (XXX8701) General Fund Operating
135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724)
135-11100 Petty Cash Administration
135-11150 Petty Cash Utility Billing
137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement
519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT
519-11155 Cash -Bond Escrow Bank of Texas (SWIFT)
520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018)
520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019
528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements
533-10250 TexPool Tax I & S (XXXXX0003)
533-10300 Prosperity Bank (XXX8701) Tax I&S
534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements
535-10250 Texpool Revenue I & S (XXXXX017) SWIFT
536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems
Amount available in cash for spending (MUD Accounts)
*1/31/2023 Customer Water Deposits $328,185
Fire Department Cash
1122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash
122-10300 Prosperity Bank (XXX8701) Fire Operating
Amount available in cash for spending (Fire Department Accounts)
Total General Fund 135 Available for Spending
General Fund 135 Fund Balances
Nonspendable Fund Balance (Prepaids)
Assigned Fund Balance (FY2023 Capital Projects plus prior year carry forward)
Unassigned Fund Balance
Current Year Revenue/Expenses
Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135
13 of 32
February 15, 2023 Agenda Packet
Restricted -
Unable to be spent
$o
$328,185
$1,895,730
$0
$0
$3,422,147
$0
$794,335
$1,289,991
$0
$911,864
$659,283
$0
$249,400
$107,388
$140,225
$o
so
Unrestricted -
Available for
spending
$3,086,464
$4,652,519
$0
$150
$450
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$7,739,583 1
$0 1
$7,739,583
$1,349,157
$0
$1,349,157
$1,349,157
Total in Accounts
(Restricted &
Unrestricted)
$3,086,464
$4,980,704
$1,895,730
$150
$450
$3,422,147
$0
$794,335
$1,289,991
$0
$911,864
$659,283
$0
$249,400
$107,388
$140,225
$17,538,131
General Fund 135 Available
$ 4,652,519 Prosperity General Fund
$ 3,086,464 Texpool General Fund
$ 600 Petty Cash
$ 7,739,583
$ 3,880
$ 4,770,878
$ 5,672,780
$ (200,938)
$10,246,600
$1,349,157
$0
$1,349,157
February 15, 2023 Agenda Packet
January Utility Billing Report
Fiscal Year 2022 - 2023
January February March April May June July August September October November December January
2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2023
e b i I I s 1,388 1,420 1,424 1,465 1,518 1,566 1,592 1,629 1,654 1,667 1,710 1,746 1,765
Bills Mailed 3,855 3,872 3,864 3,868 3,865 3,882 3,872 3,850 3,832 3,822 3,801 3,768 3,741
Bank Draft 668 670 671 676 692 700 697 704 703 706 711 630 606
Credit Card Draft 1,437 1,431 1,442 1,455 1,450 1,456 1,471 1,484 1,481 1,501 1,494
2,251 2,540
Online Payments 1,174 1,138 1,225 1,171 1,196 1,188 1,220 1,170 1,203 1,159 1,049
Late Notices 377 362 326 355 284 339 387 310 326 337 0 0 0
Disconnects 3 5 8 9 9 4 7 5 2 0 4 0 0
Connections MUD
Connections PID
3398 3401 3402 3400 3400 3401 3401 3398 3399 3399 3399 3399 3394
1443 1443 1443 1443 1443 1443 1443 1443 1444 1444 1444 1444 1444
Date of
Permit
Permit No.
January Permits
Fiscal Year 2023
Customer Due to FW Oversize Plumbing Sewer
Deposit Water Meter Inspections Inspections
Fire Line Misc. Income Total
$
Total $ - $ - $ - $ - $ - $ - $ - $
14of32
February 15, 2023 Agenda Packet
FY 2023 Combined Financials
YTD as of 1/31/2023
YTD
Revenues
1119 YTD
Expenses
Adopted Budget vs YTD Actuals Revenues & Expenses
$3,383,474
$3,584,412
$11,733,354
$11,733,354
$1,212 538,952
0% 1%
$596,056
17%
$1,240,337
34%
$1,707,854
48%
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
0
88,979,203
Water Consumption Budget vs Actual
101,683,000
41,702,881
49,007,000
52,466,000
41,572,326
—8—Budget Consumption —*-Actual Consumption
Oct Nov Dec
57,576,000
36,351,669
Jan
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
808,128,121
Total Water Consumption
• Budgeted Water Consumption
• Projected Water Consumption
Presented by:
Finance Department
51,000,000
$900,000
5800,000
$700,000
$600,000
$500,000
$400,000
$300,000
$200,000
$100,000
50
Water Revenue Budget vs Actual
8365,714
—0—Budget Revenue --Actual Revenue
Oct Nov Dec Jan
$8,000,000
57,000,000
$6,000,000
55,000,000
$4,000,000
53,000,000
$2,000,000
$1,000,000
$0
Adopted Budget Water Revenue Vs Projected Water Revenue
56,710,979 $6,818,946
$4,070,848 $4,231,816
Total Water Revenue
• Budgeted Water Revenue
• Projected Water Revenue
Net Budgeted Water Revenue
Minus Budgeted Expenses
• Net Projected Water Revenue
Minus Projected Expenses
15of32
TGfPHV CLUB
ME[NEG]AAL
[lrILE7Y
I][5711.I I:,
Trophy Club Municipal Utility District No. 1
Fund: 135 - MUD 1 General Fund
CURRENT MONTH
ACTUAL BUDGETED VARIANCE
REVENUE SUMMARY
Revenue, Asset, Liability, & Equity 799,950.11
TOTAL REVENUE 799,950.11
EXPENSE SUMMARY
Revenue, Asset, Liability, & Equity 0.00
Water 606,136.32
Wastewater 489,466.20
Board of Directors 115.61
Administration 130,815.61
Non Deparmental 16,835.65
TOTAL EXPENSE 1,243,369.39
REVENUE OVER/(UNDER) EXPENDITURE (443,419.28)
2/10/2023 12:52:55 AM
977,388.37 (177,438.26)
977,388.37 (177,438.26)
0.00 0.00
547,941.66 (58,194.66)
290,877.74 (198,588.46)
980.01 864.40
127,864.23 (2,951.38)
9,724.44 (7,111.21)
977,388.08 (265,981.31)
0.29 (443,419.57)
YEAR TO DATE
ACTUAL BUDGETED
3,383,474.08 3,909,553.48
3,383,474.08 3,909,553.48
0.00 0.00
1,707,854.17 2,191,766.64
1,240,336.76 1,163,510.96
1,212.44 3,920.04
596,055.84 511,456.92
38,952.49 38,897.76
3,584,411.70 3,909,552.32
February 15, 2023 Agenda Packet
Budget Variance Report
As Of: 01/31/2023
VARIANCE
(526,079.40) 29
(526,079.40) 29
ANNUAL BUDGET
TOTAL REMAINING %
11,733,354.00 (8,349,879.92) 71
11,733,354.00 (8,349,879.92) 71
0.00 0.00
483,912.47 26 6,577,932.00
(76,825.80) 36 3,491,931.00
2,707.60 10 11,765.00
(84,598.92) 39 1,534,986.00
(54.73) 33 116,740.00
325,140.62 31 11,733,354.00
(200,937.62) 1.16 (200,938.78)
16 of 32
0.00
(4,870,077.83)
(2,251,594.24)
(10,552.56)
(938,930.16)
(77,787.51)
74
64
90
61
67
8,148,942.30 69
0.00 (16,498,822.22)
Page 1 of 1
Trophy Club Municipal Utility District No. 1
Fund: 135 - MUD 1 General Fund
Revenue
Department: 000 - Revenue,
135-000-40000-000
135-000-40002-000
135-000-40015-000
135-000-40025-000
135-000-47000-000
135-000-47005-000
135-000-47025-000
135-000-47030-000
135-000-47035-000
135-000-47045-000
135-000-47070-000
135-000-49011-000
135-000-49016-000
135-000-49026-000
135-000-49035-000
135-000-49036-000
135-000-49075-000
135-000-49900-000
Total Departme
Expense
Department: 010 - Water
135-010-50005-000
135-010-50010-000
135-010-50016-000
135-010-50017-000
135-010-50020-000
135-010-50026-000
135-010-50027-000
135-010-50028-000
135-010-50029-000
135-010-50030-000
2/10/2023 1:22:24 AM
Asset, Liability, & Equity
Property Taxes
Property Taxes/Delinquent
Property Taxes/P & I
PID Surcharges
Water
Sewer
Penalties
Service Charges
Plumbing Inspections
Sewer Inspections
TCCC Effluent Charges
Interest Income
Cell Tower Revenue
Proceeds from Sale of Assets
Prior Year Reserves
GASB Reserves
Oversize Meter Reimbursement
Miscellaneous Income
nt: 000 - Revenue, Asset, Liability, & Equity:
Salaries & Wages
Overtime
Longevity
Certification
Retirement
Medical Insurance
Dental Insurance
Vision Insurance
Life Insurance & Other
Social Security Taxes
Total Revenue:
January
Budget
January
Activity
Variance
Favorable Percent
(Unfavorable) Remaining
YTD
Budget
February 15, 2023 Agenda Packet
Monthly Budget Report
Account Summary
For Fiscal: Current Period Ending: 01/31/2023
YTD
Activity
Variance
Favorable Percent
(Unfavorable) Remaining
Total Budget
7,326.73 30,181.59 22,854.86 311.94% 29,306.92 70,020.37 40,713.45 138.92% 87,956.00
24.99 52.81 27.82 111.32% 99.96 870.95 770.99 771.30% 300.00
24.99 49.79 24.80 99.24% 99.96 347.26 247.30 247.40% 300.00
12,080.91 0.00 -12,080.91 -100.00% 48,323.64 0.00 -48,323.64 -100.00% 145,029.00
559,024.55 424,444.64 -134,579.91 -24.07% 2,236,098.20 1,968,047.44 -268,050.76 -11.99% 6,710,979.00
319,845.84 624,201.21 304,355.37 95.16% 1,279,383.36 1,202,021.10 -77,362.26 -6.05% 3,839,686.00
6,497.40 0.00 -6,497.40 -100.00% 25,989.60 5,923.46 -20,066.14 -77.21% 78,000.00
466.48 0.00 -466.48 -100.00% 1,865.92 5,181.92 3,316.00 177.71% 5,600.00
24.99 0.00 -24.99 -100.00% 99.96 0.00 -99.96 -100.00% 300.00
8.33 0.00 -8.33 -100.00% 33.32 0.00 -33.32 -100.00% 100.00
4,998.00 -316,033.13 -321,031.13 -6,423.19% 19,992.00 11,810.40 -8,181.60 -40.92% 60,000.00
1,666.00 32,991.39 31,325.39 1,880.28% 6,664.00 111,128.24 104,464.24 1,567.59% 20,000.00
1,178.36 1,178.81 0.45 0.04% 4,713.44 4,715.24 1.80 0.04% 14,146.00
2,082.50 0.00 -2,082.50 -100.00% 8,330.00 391.30 -7,938.70 -95.30% 25,000.00
47,722.57 0.00 -47,722.57 -100.00% 190,890.28 0.00 -190,890.28 -100.00% 572,900.00
13,661.20 0.00 -13,661.20 -100.00% 54,644.80 0.00 -54,644.80 -100.00% 164,000.00
171.43 0.00 -171.43 -100.00% 685.72 0.00 -685.72 -100.00% 2,058.00
583.10 2,883.00 2,299.90 394.43% 2,332.40 3,016.40 684.00 29.33% 7,000.00
977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00
977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00
33,914.67 31,843.32 2,071.35 6.11% 135,658.68 125,682.66 9,976.02 7.35% 407,139.00
1,416.10 2,031.72 -615.62 -43.47% 5,664.40 4,845.52 818.88 14.46% 17,000.00
498.38 0.00 498.38 100.00% 1,993.52 0.00 1,993.52 100.00% 5,983.00
299.88 0.00 299.88 100.00% 1,199.52 0.00 1,199.52 100.00% 3,600.00
4,264.96 4,065.01 199.95 4.69% 17,059.84 15,716.99 1,342.85 7.87% 51,200.00
6,890.74 7,318.18 -427.44 -6.20% 27,562.96 24,551.92 3,011.04 10.92% 82,722.00
406.17 306.68 99.49 24.49% 1,624.68 1,322.56 302.12 18.60% 4,876.00
62.05 63.32 -1.27 -2.05% 248.20 206.42 41.78 16.83% 745.00
199.92 421.71 -221.79 -110.94% 799.68 1,544.59 -744.91 -93.15% 2,400.00
2,240.02 2,077.32 162.70 7.26% 8,960.08 7,948.70 1,011.38 11.29% 26,891.00
17 of 32
Page 1 of 7
February 15, 2023 Agenda Packet
Monthly Budget Report For Fiscal: Current Period Ending: 01/31/2023
Variance Variance
January January Favorable Percent YTD YTD Favorable Percent
Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget
135-010-50035-000 Medicare Taxes 523.87 485.82 38.05 7.26% 2,095.48 1,658.96 436.52 20.83% 6,289.00
135-010-50040-000 Unemployment Taxes 104.95 32.04 72.91 69.47% 419.80 32.04 387.76 92.37% 1,260.00
135-010-50045-000 Workman's Compensation 937.04 1,109.40 -172.36 -18.39% 3,748.16 4,437.60 -689.44 -18.39% 11,249.00
135-010-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 133.28 0.00 133.28 100.00% 400.00
135-010-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 99.96 132.95 -32.99 -33.00% 300.00
135-010-55080-000 Maintenance & Repairs 19,142.34 13,620.40 5,521.94 28.85% 76,569.36 39,703.18 36,866.18 48.15% 229,800.00
135-010-55085-000 Generator Maint. and Repair 166.60 0.00 166.60 100.00% 666.40 875.96 -209.56 -31.45% 2,000.00
135-010-55090-000 Vehicle Maintenance 416.50 285.43 131.07 31.47% 1,666.00 1,255.73 410.27 24.63% 5,000.00
135-010-55105-000 Maintenance-Backhoe/SkidLoader 83.30 0.00 83.30 100.00% 333.20 0.00 333.20 100.00% 1,000.00
135-010-55120-000 Cleaning Services 208.25 161.23 47.02 22.58% 833.00 644.91 188.09 22.58% 2,500.00
135-010-55135-000 Lab Analysis 624.75 653.92 -29.17 -4.67% 2,499.00 1,253.92 1,245.08 49.82% 7,500.00
135-010-55135-001 Lab Analysis for PID 166.60 80.00 86.60 51.98% 666.40 240.00 426.40 63.99% 2,000.00
135-010-60010-000 Communications/Mobiles 624.75 479.79 144.96 23.20% 2,499.00 1,822.73 676.27 27.06% 7,500.00
135-010-60020-000 Electricity 19,013.22 8,720.19 10,293.03 54.14% 76,052.88 36,139.66 39,913.22 52.48% 228,250.00
135-010-60066-000 Publications/Books/Subscripts 83.30 0.00 83.30 100.00% 333.20 0.00 333.20 100.00% 1,000.00
135-010-60080-000 Schools & Training 302.37 0.00 302.37 100.00% 1,209.48 1,131.88 77.60 6.42% 3,630.00
135-010-60100-000 Travel & per diem 78.13 44.79 33.34 42.67% 312.52 44.79 267.73 85.67% 938.00
135-010-60135-000 TCEQ Fees & Permits 2,499.00 51.38 2,447.62 97.94% 9,996.00 15,883.03 -5,887.03 -58.89% 30,000.00
135-010-60135-001 TCEQ Fees & Permits for PID 0.00 213.92 -213.92 0.00% 0.00 213.92 -213.92 0.00% 0.00
135-010-60150-000 Wholesale Water 219,922.99 146,967.32 72,955.67 33.17% 879,691.96 534,851.98 344,839.98 39.20% 2,640,132.00
135-010-60285-000 Lawn Equipment & Maintenance 1,041.25 0.00 1,041.25 100.00% 4,165.00 600.00 3,565.00 85.59% 12,500.00
135-010-60332-000 Interfund Transfer Out -Rev I&S 47,296.24 51,616.66 -4,320.42 -9.13% 189,184.96 206,466.64 -17,281.68 -9.13% 567,782.00
135-010-60360-000 Furniture/Equipment < $5000 208.25 0.00 208.25 100.00% 833.00 0.00 833.00 100.00% 2,500.00
135-010-65005-000 Fuel & Lube 1,249.50 1,486.25 -236.75 -18.95% 4,998.00 5,977.82 -979.82 -19.60% 15,000.00
135-010-65010-000 Uniforms 362.77 382.50 -19.73 -5.44% 1,451.08 2,033.58 -582.50 -40.14% 4,355.00
135-010-65030-000 Chemicals 2,082.50 6,200.99 -4,118.49 -197.77% 8,330.00 15,629.77 -7,299.77 -87.63% 25,000.00
135-010-65050-000 Meter Expense 1,666.00 0.00 1,666.00 100.00% 6,664.00 0.00 6,664.00 100.00% 20,000.00
135-010-65053-000 Meter Change Out Program 7,247.10 0.00 7,247.10 100.00% 28,988.40 0.00 28,988.40 100.00% 87,000.00
135-010-69005-000 Capital Outlays 145,941.60 246,506.40 -100,564.80 -68.91% 583,766.40 349,148.80 234,617.60 40.19% 1,752,000.00
135-010-69008-000 Short Term Debt -Principal 2,655.77 31,882.11 -29,226.34 -1,100.48% 10,623.08 31,882.11 -21,259.03 -200.12% 31,882.00
135-010-69009-000 Short Term Debt -Interest 39.15 470.26 -431.11 -1,101.17% 156.60 470.26 -313.66 -200.29% 470.00
135-010-69195-000 GASB Reserve for Replacement 13,547.82 0.00 13,547.82 100.00% 54,191.28 162,639.00 -108,447.72 -200.12% 162,639.00
135-010-69281-000 Water Tank Inspection Contract 9,454.55 46,558.26 -37,103.71 -392.44% 37,818.20 110,863.59 -73,045.39 -193.15% 113,500.00
Total Department: 010 - Water: 547,941.66 606,136.32 -58,194.66 -10.62% 2,191,766.64 1,707,854.17 483,912.47 22.08% 6,577,932.00
Department: 020 - Wastewater
135-020-50005-000 Salaries & Wages 25,794.26 29,345.73 -3,551.47 -13.77% 103,177.04 116,770.44 -13,593.40 -13.17% 309,655.00
135-020-50010-000 Overtime 2,748.90 1,579.89 1,169.01 42.53% 10,995.60 5,885.10 5,110.50 46.48% 33,000.00
135-020-50016-000 Longevity 336.11 0.00 336.11 100.00% 1,344.44 0.00 1,344.44 100.00% 4,035.00
135-020-50017-000 Certification 524.79 0.00 524.79 100.00% 2,099.16 0.00 2,099.16 100.00% 6,300.00
135-020-50020-000 Retirement 3,471.19 3,711.07 -239.88 -6.91% 13,884.76 14,772.44 -887.68 -6.39% 41,671.00
135-020-50026-000 Medical lnsurance 8,045.03 6,755.26 1,289.77 16.03% 32,180.12 24,467.23 7,712.89 23.97% 96,579.00
135-020-50027-000 Dental Insurance 452.06 236.80 215.26 47.62% 1,808.24 1,206.34 601.90 33.29% 5,427.00
2/10/2023 1:22:24 AM Page 2 of 7
18 of 32
February 15, 2023 Agenda Packet
Monthly Budget Report For Fiscal: Current Period Ending: 01/31/2023
Variance Variance
January January Favorable Percent YTD YTD Favorable Percent
Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget
135-020-50028-000 Vision Insurance 66.05 60.22 5.83 8.83% 264.20 197.00 67.20 25.44% 793.00
135-020-50029-000 Life Insurance & Other 199.92 392.71 -192.79 -96.43% 799.68 1,450.77 -651.09 -81.42% 2,400.00
135-020-50030-000 Social Security Taxes 1,823.02 1,884.41 -61.39 -3.37% 7,292.08 7,522.63 -230.55 -3.16% 21,885.00
135-020-50035-000 Medicare Taxes 426.32 440.70 -14.38 -3.37% 1,705.28 1,759.33 -54.05 -3.17% 5,118.00
135-020-50040-000 Unemployment Taxes 104.95 30.93 74.02 70.53% 419.80 32.72 387.08 92.21% 1,260.00
135-020-50045-000 Workman's Compensation 748.61 886.28 -137.67 -18.39% 2,994.44 3,545.12 -550.68 -18.39% 8,987.00
135-020-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 133.28 0.00 133.28 100.00% 400.00
135-020-50070-000 Employee Relations 24.99 205.13 -180.14 -720.85% 99.96 663.09 -563.13 -563.36% 300.00
135-020-55080-000 Maintenance & Repairs 11,212.18 7,091.03 4,121.15 36.76% 44,848.72 63,687.27 -18,838.55 -42.00% 134,600.00
135-020-55081-000 Mainten & Repairs Collections 23,407.30 1,250.15 22,157.15 94.66% 93,629.20 25,102.03 68,527.17 73.19% 281,000.00
135-020-55085-000 Generator Maint. and Repair 749.70 0.00 749.70 100.00% 2,998.80 2,836.29 162.51 5.42% 9,000.00
135-020-55090-000 Vehicle Maintenance 383.18 204.74 178.44 46.57% 1,532.72 491.81 1,040.91 67.91% 4,600.00
135-020-55091-000 Veh Maintenance Collections 1,082.90 0.00 1,082.90 100.00% 4,331.60 3,795.56 536.04 12.38% 13,000.00
135-020-55105-000 Maintenance-Backhoe/SkidLoader 249.90 0.00 249.90 100.00% 999.60 1,408.94 -409.34 -40.95% 3,000.00
135-020-55120-000 Cleaning Services 166.60 161.22 5.38 3.23% 666.40 644.89 21.51 3.23% 2,000.00
135-020-55125-000 Dumpster Services 8,330.00 7,920.53 409.47 4.92% 33,320.00 23,294.85 10,025.15 30.09% 100,000.00
135-020-55135-000 Lab Analysis 3,332.00 2,212.80 1,119.20 33.59% 13,328.00 15,877.77 -2,549.77 -19.13% 40,000.00
135-020-60010-000 Communications/Mobiles 624.75 667.33 -42.58 -6.82% 2,499.00 1,809.04 689.96 27.61% 7,500.00
135-020-60020-000 Electricity 23,017.28 14,280.50 8,736.78 37.96% 92,069.12 43,080.15 48,988.97 53.21% 276,318.00
135-020-60080-000 Schools & Training 302.37 0.00 302.37 100.00% 1,209.48 576.00 633.48 52.38% 3,630.00
135-020-60100-000 Travel & per diem 86.46 0.00 86.46 100.00% 345.84 0.00 345.84 100.00% 1,038.00
135-020-60135-000 TCEQ Fees & Permits 999.60 0.00 999.60 100.00% 3,998.40 9,888.02 -5,889.62 -147.30% 12,000.00
135-020-60285-000 Lawn Equipment & Maintenance 1,332.80 0.00 1,332.80 100.00% 5,331.20 710.00 4,621.20 86.68% 16,000.00
135-020-60331-000 Interfund Transfer Out -Tax l&S 9,683.20 10,567.73 -884.53 -9.13% 38,732.80 42,270.92 -3,538.12 -9.13% 116,245.00
135-020-60332-000 Interfund Transfer Out -Rev l&S 57,637.85 62,902.88 -5,265.03 -9.13% 230,551.40 251,611.52 -21,060.12 -9.13% 691,931.00
135-020-60360-000 Furniture/Equipment < $5000 41.65 0.00 41.65 100.00% 166.60 0.00 166.60 100.00% 500.00
135-020-65005-000 Fuel & Lube 1,041.25 912.45 128.80 12.37% 4,165.00 4,631.28 -466.28 -11.20% 12,500.00
135-020-65010-000 Uniforms 367.76 968.67 -600.91 -163.40% 1,471.04 2,288.35 -817.31 -55.56% 4,415.00
135-020-65030-000 Chemicals 2,707.25 6,705.25 -3,998.00 -147.68% 10,829.00 9,962.15 866.85 8.00% 32,500.00
135-020-65031-000 Chemicals Collections 833.00 5,709.00 -4,876.00 -585.35% 3,332.00 6,002.80 -2,670.80 -80.16% 10,000.00
135-020-65045-000 Lab Supplies 2,748.90 244.00 2,504.90 91.12% 10,995.60 15,308.30 -4,312.70 -39.22% 33,000.00
135-020-69005-000 Capital Outlays 74,553.50 256,412.37 -181,858.87 -243.93% 298,214.00 305,283.19 -7,069.19 -2.37% 895,000.00
135-020-69008-000 Short Term Debt -Principal 7,144.30 63,804.49 -56,660.19 -793.08% 28,577.20 63,804.49 -35,227.29 -123.27% 85,766.00
135-020-69009-000 Short Term Debt -Interest 233.32 1,921.93 -1,688.61 -723.73% 933.28 1,921.93 -988.65 -105.93% 2,801.00
135-020-69195-000 GASB Reserve for Replacement 13,809.22 0.00 13,809.22 100.00% 55,236.88 165,777.00 -110,540.12 -200.12% 165,777.00
Total Department: 020 - Wastewater: 290,877.74 489,466.20 -198,588.46 -68.27% 1,163,510.96 1,240,336.76 -76,825.80 -6.60% 3,491,931.00
Department: 026 - Board of Directors
135-026-50045-000 Workman's Compensation 1.24 0.62 0.62 50.00% 4.96 2.48 2.48 50.00% 15.00
135-026-60070-000 Dues & Memberships 62.47 0.00 62.47 100.00% 249.88 750.00 -500.12 -200.14% 750.00
135-026-60075-000 Meetings 124.95 114.99 9.96 7.97% 499.80 459.96 39.84 7.97% 1,500.00
135-026-60080-000 Schools & Training 333.20 0.00 333.20 100.00% 1,332.80 0.00 1,332.80 100.00% 4,000.00
135-026-60100-000 Travel & per diem 416.50 0.00 416.50 100.00% 1,666.00 0.00 1,666.00 100.00% 5,000.00
2/10/2023 1:22:24 AM Page 3 of 7
19 of 32
Monthly Budget Report
135-026-60245-000
Miscellaneous Expenses
Total Department: 026 - Board of Directors:
Department: 030 - Administration
135-030-50005-000
135-030-50010-000
135-030-50016-000
135-030-50020-000
135-030-50026-000
135-030-50027-000
135-030-50028-000
135-030-50029-000
135-030-50030-000
135-030-50035-000
135-030-50040-000
135-030-50045-000
135-030-50060-000
135-030-50070-000
135-030-55030-000
135-030-55070-000
135-030-55080-000
135-030-55085-000
135-030-55120-000
135-030-55160-000
135-030-55205-000
135-030-60005-000
135-030-60010-000
135-030-60020-000
135-030-60025-000
135-030-60035-000
135-030-60040-000
135-030-60050-000
135-030-60055-000
135-030-60070-000
135-030-60079-000
135-030-60080-000
135-030-60100-000
135-030-60245-000
135-030-60285-000
135-030-60360-000
135-030-65010-000
135-030-65055-000
135-030-65085-000
Salaries & Wages
Overtime
Longevity
Retirement
Medical Insurance
Dental Insurance
Vision Insurance
Life Insurance & Other
Social Security Taxes
Medicare Taxes
Unemployment Taxes
Workman's Compensation
Pre-emp Physicals/Testing
Employee Relations
Software & Support
Independent Labor
Maintenance & Repairs
Generator Maint. and Repair
Cleaning Services
Professional Outside Services
Utility Billing Contract
Telephone
Communications/Mobiles
Electricity/Gas
Water
Postage
Service Charges & Fees
Bad Debt Expense
Insurance
Dues & Memberships
Public Education
Schools & Training
Travel & per diem
Miscellaneous Expenses
Lawn Equipment & Maintenance
Furniture/Equipment < $5000
Uniforms
Hardware
Office Supplies
February 15, 2023 Agenda Packet
For Fiscal: Current Period Ending: 01/31/2023
Variance Variance
January January Favorable Percent YTD YTD Favorable Percent
Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget
0.00 41.65 100.00% 166.60 100.00%
980.01 115.61 864.40 88.20% 3,920.04 1,212.44 2,707.60 69.07% 11,765.00
51,724.13 47,861.04 3,863.09 7.47% 206,896.52 178,684.19 28,212.33 13.64% 620,938.00
166.60 207.04 -40.44 -24.27% 666.40 509.18 157.22 23.59% 2,000.00
201.83 0.00 201.83 100.00% 807.32 0.00 807.32 100.00% 2,423.00
6,149.53 5,741.18 408.35 6.64% 24,598.12 21,559.55 3,038.57 12.35% 73,824.00
9,686.95 4,503.51 5,183.44 53.51% 38,747.80 22,496.07 16,251.73 41.94% 116,290.00
504.04 206.34 297.70 59.06% 2,016.16 1,132.52 883.64 43.83% 6,051.00
74.88 46.50 28.38 37.90% 299.52 185.90 113.62 37.93% 899.00
199.92 490.27 -290.35 -145.23% 799.68 1,927.01 -1,127.33 -140.97% 2,400.00
3,229.70 2,871.93 357.77 11.08% 12,918.80 10,382.75 2,536.05 19.63% 38,772.00
755.36 671.66 83.70 11.08% 3,021.44 2,494.06 527.38 17.45% 9,068.00
125.94 40.78 85.16 67.62% 503.76 42.57 461.19 91.55% 1,512.00
124.61 107.60 17.01 13.65% 498.44 430.40 68.04 13.65% 1,496.00
41.65 0.00 41.65 100.00% 166.60 0.00 166.60 100.00% 500.00
333.20 0.00 333.20 100.00% 1,332.80 2,563.57 -1,230.77 -92.34% 4,000.00
10,970.61 1,033.44 9,937.17 90.58% 43,882.44 65,585.41 -21,702.97 -49.46% 131,700.00
1,249.50 879.44 370.06 29.62% 4,998.00 3,323.19 1,674.81 33.51% 15,000.00
3,332.00 7,860.81 -4,528.81 -135.92% 13,328.00 8,815.69 4,512.31 33.86% 40,000.00
249.90 0.00 249.90 100.00% 999.60 0.00 999.60 100.00% 3,000.00
999.60 967.35 32.25 3.23% 3,998.40 4,167.64 -169.24 -4.23% 12,000.00
6,250.83 0.00 6,250.83 100.00% 25,003.32 66,777.26 -41,773.94 -167.07% 75,040.00
749.70 657.17 92.53 12.34% 2,998.80 1,951.62 1,047.18 34.92% 9,000.00
499.80 438.21 61.59 12.32% 1,999.20 1,801.33 197.87 9.90% 6,000.00
249.90 0.00 249.90 100.00% 999.60 0.00 999.60 100.00% 3,000.00
2,029.93 1,170.20 859.73 42.35% 8,119.72 2,826.31 5,293.41 65.19% 24,369.00
416.50 385.72 30.78 7.39% 1,666.00 1,582.98 83.02 4.98% 5,000.00
2,499.00 1,885.97 613.03 24.53% 9,996.00 6,089.42 3,906.58 39.08% 30,000.00
7,913.50 11,427.58 -3,514.08 -44.41% 31,654.00 28,040.08 3,613.92 11.42% 95,000.00
124.95 0.00 124.95 100.00% 499.80 48.65 451.15 90.27% 1,500.00
7,347.06 8,117.81 -770.75 -10.49% 29,388.24 32,471.24 -3,083.00 -10.49% 88,200.00
541.45 259.00 282.45 52.17% 2,165.80 1,968.00 197.80 9.13% 6,500.00
3,332.00 1,052.50 2,279.50 68.41% 13,328.00 11,532.60 1,795.40 13.47% 40,000.00
270.72 120.00 150.72 55.67% 1,082.88 120.00 962.88 88.92% 3,250.00
132.28 0.00 132.28 100.00% 529.12 0.00 529.12 100.00% 1,588.00
0.00 0.00 0.00 0.00% 0.00 88.00 -88.00 0.00% 0.00
416.50 650.38 -233.88 -56.15% 1,666.00 1,120.05 545.95 32.77% 5,000.00
833.00 8,724.00 -7,891.00 -947.30% 3,332.00 8,724.00 -5,392.00 -161.82% 10,000.00
44.14 0.00 44.14 100.00% 176.56 0.00 176.56 100.00% 530.00
699.72 0.00 699.72 100.00% 2,798.88 384.50 2,414.38 86.26% 8,400.00
499.80 1,098.61 -598.81 -119.81% 1,999.20 2,237.69 -238.49 -11.93% 6,000.00
2/10/2023 1:22:24 AM Page 4 of 7
20 of 32
February 15, 2023 Agenda Packet
Monthly Budget Report For Fiscal: Current Period Ending: 01/31/2023
135-030-65095-000
135-030-69005-000
135-030-69170-000
135-030-69195-000
Maintenance Supplies
Capital Outlays
Copier Lease Installments
GASB Reserve for Replacement
Total Department: 030 - Administration:
Department: 039 - Non Deparmental
135-039-55045-000 Legal
135-039-55055-000 Auditing
135-039-55060-000 Appraisal
135-039-55065-000
Tax Admin Fees
Total Department: 039 - Non Deparmental:
Total Expense:
Total Revenues
Total Fund: 135 - MUD 1 General Fund:
Report Total:
Variance Variance
January January Favorable Percent YTD YTD Favorable Percent
Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget
333.20 692.18 -358.98 -107.74% 1,332.80 2,261.02 -928.22 -69.64% 4,000.00
0.00 20,351.60 -20,351.60 0.00% 0.00 73,912.60 -73,912.60 0.00% 0.00
333.20 295.79 37.41 11.23% 1,332.80 1,082.79 250.01 18.76% 4,000.00
2,227.10 0.00 2,227.10 100.00% 8,908.40 26,736.00 -17,827.60 -200.12% 26,736.00
127,864.23 130,815.61 -2,951.38 -2.31% 511,456.92 596,055.84 -84,598.92 -16.54% 1,534,986.00
5,414.50 2,775.00 2,639.50 48.75% 21,658.00 7,582.50 14,075.50 64.99% 65,000.00
2,815.54 11,451.39 -8,635.85 -306.72% 11,262.16 22,551.10 -11,288.94 -100.24% 33,800.00
1,077.90 2,609.26 -1,531.36 -142.07% 4,311.60 4,772.89 -461.29 -10.70% 12,940.00
416.50 0.00 416.50 100.00% 1,666.00 4,046.00 -2,380.00 -142.86% 5,000.00
9,724.44 16,835.65 -7,111.21 -73.13% 38,897.76 38,952.49 -54.73 -0.14% 116,740.00
977,388.08 1,243,369.39 -265,981.31 -27.21% 3,909,552.32 3,584,411.70 325,140.62 8.32% 11,733,354.00
977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00
0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00
0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00
2/10/2023 1:22:24 AM Page 5 of 7
21 of 32
February 15, 2023 Agenda Packet
Monthly Budget Report For Fiscal: Current Period Ending: 01/31/2023
Group Summary
Variance Variance
January January Favorable Percent YTD YTD Favorable Percent
Departmen... Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget
Fund: 135 - MUD 1 General Fund
Revenue
000 - Revenue, Asset, Liability, & Equity 977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00
Total Revenue: 977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00
Expense
010 - Water
020 - Wastewater
026 - Board of Directors
030 - Administration
039 - Non Deparmental
Total Expense:
Total Revenues
Total Fund: 135 - MUD 1 General Fund:
Report Total:
547,941.66 606,136.32 -58,194.66 -10.62% 2,191,766.64 1,707,854.17 483,912.47 22.08% 6,577,932.00
290,877.74 489,466.20 -198,588.46 -68.27% 1,163,510.96 1,240,336.76 -76,825.80 -6.60% 3,491,931.00
980.01 115.61 864.40 88.20% 3,920.04 1,212.44 2,707.60 69.07% 11,765.00
127,864.23 130,815.61 -2,951.38 -2.31% 511,456.92 596,055.84 -84,598.92 -16.54% 1,534,986.00
9,724.44 16,835.65 -7,111.21 -73.13% 38,897.76 38,952.49 -54.73 -0.14% 116,740.00
977,388.08 1,243,369.39 -265,981.31 -27.21% 3,909,552.32 3,584,411.70 325,140.62 8.32% 11,733,354.00
977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00
0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00
0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00
2/10/2023 1:22:24 AM Page 6 of 7
22 of 32
February 15, 2023 Agenda Packet
Monthly Budget Report For Fiscal: Current Period Ending: 01/31/2023
Fund Summary
Variance Variance
January January Favorable Percent YTD YTD Favorable Percent
Fund Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget
135 - MUD 1 General Fund 0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00
Report Total: 0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00
2/10/2023 1:22:24 AM Page 7 of 7
23 of 32
TROPHY CLUB
MUNEMPAL
ur1LE7Y
IIISTRI CT
Department
Trophy Club Municipal Utility District No. 1
Asset
000 - Revenue, Asset, Liability, & Equity
Liability
000 - Revenue, Asset, Liability, & Equity
Total Asset:
Total Liability:
Equity
000 - Revenue, Asset, Liability, & Equity
Total Total Beginning Equity:
Total Revenue
Total Expense
Revenues Over/Under Expenses
Total Equity and Current Surplus (Deficit):
Total Liabilities, Equity and Current Surplus (Deficit):
2/10/2023 12:46:56 AM
122 - Trophy Club
MUD Fire Dept.
February 15, 2023 Agenda Packet
Balance Sheet Funds 122 - 528
Account Summary
As Of 01/31/2023
135 - MUD 1 137 - MUD 1 519-2016 Rev 520 -Revenue 528-2015
General Fund Consolidated Bond Const -SWIFT Bond 16" Revenue Bond
GASB Waterline Reserve Fund
1,612,572.86 11,135,421.41 3,422,146.58 794,334.82 1,289,991.49 911,863.95
1,612,572.86 11,135,421.41 3,422,146.58 794,334.82 1,289,991.49 911,863.95
242,457.11 888,820.96 0.00 81,691.15 158,280.07 0.00
242,457.11 888,820.96 0.00 81,691.15 158,280.07 0.00
681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41
681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41
1,016,220.30 3,383,474.08 436,572.00 7,113.47 16,950.57 11,259.54
327,908.12 3,584,411.70 0.00 0.00 224,336.08 0.00
688,312.18 -200,937.62 436,572.00 7,113.47 -207,385.51 11,259.54
1,370,115.75 10,246,600.45 3,422,146.58 712,643.67 1,131,711.42 911,863.95
1,612,572.86 11,135,421.41 3,422,146.58 794,334.82 1,289,991.49 911,863.95
24 of 32
Total
19,166, 331.11
19,166,331.11
1,371,249.29
1,371,249.29
17,060,147.76
17,060,147.76
4,871,589.96
4,136, 655.90
734,934.06
17,795,081.82
19,166,331.11
Page 1 of 1
TROPHY CLUB
MUNEMPAL
ur1LE7Y
IIISTRI CT
Department
Trophy Club Municipal Utility District No. 1
Asset
000 - Revenue, Asset, Liability, & Equity
Liability
000 - Revenue, Asset, Liability, & Equity
Total Asset:
Total Liability:
Equity
000 - Revenue, Asset, Liability, & Equity
Total Total Beginning Equity:
Total Revenue
Total Expense
Revenues Over/Under Expenses
Total Equity and Current Surplus (Deficit):
Total Liabilities, Equity and Current Surplus (Deficit):
2/10/2023 12:47:44 AM
533- MUD 1I&S 534-2015
Consolidated Revenue Bond I&S
535 - 2016 Rev
Bond I&S-SWIFT
536 - 2019 Rev
Bond I&S-
W&WW System
785, 3 69.91 249,399.96 107, 3 87.73 140, 225.28
785,369.91 249, 399.96 107, 387.73 140, 22 5.28
173,902.75 0.00 0.00 0.00
173,902.75 0.00 0.00 0.00
4,145.11 27,958.35 6,554.77 1,429.17
4,145.11 27,958.35 6,554.77 1,429.17
607,322.05 221,441.61 100,832.96 138,796.11
0.00 0.00 0.00 0.00
607,322.05 221,441.61 100,832.96 138,796.11
611,467.16 249,399.96 107,387.73 140,225.28
785,369.91 249, 399.96 107, 387.73 140, 22 5.28
25 of 32
February 15, 2023 Agenda Packet
Balance Sheet I&S Funds 533 - 536
Account Summary
As Of 01/31/2023
Total
1,282,382.88
1,282,382.88
173,902.75
173,902.75
40,087.40
40,087.40
1,068,392.73
0.00
1,068,392.73
1,108,480.13
1,282,382.88
Page 1 of 1
February 15, 2023 Agenda Packet
REGULAR MEETING MINUTES
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
January 18, 2023 at 6:30 p.m.
Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in regular
session on Wednesday, January 18, 2023 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:
Kevin R. Carr President
Ben Brewster Vice President
Doug Harper Secretary/Treasurer
William C. Rose Director
BOARD MEMBERS ABSENT:
Tracy Hunter Director
STAFF PRESENT:
Alan Fourmentin
Laurie Slaght
Mike McMahon
Steven Krolczyk
Tony Corbett
General Manager
District Secretary
Operations Manager
Finance Manager
Legal Counsel
CALL TO ORDER AND ANNOUNCE A QUORUM
President Carr announced the date of Wednesday, January 18, 2022, called the meeting to order and
announced a quorum present at 6:32 p.m.
CITIZEN COMMENTS
There were no citizens wishing to speak.
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 staff reports to the Board and answered
questions related thereto.
CONSENT AGENDA
2. Consider and act to approve the Consent Agenda.
26 of 32
February 15, 2023 Agenda Packet
a. December 2022 Combined Financials
b. December 14, 2022 Regular Meeting Minutes
c. Quarterly Investment Report — 1St Quarter FY2023
d. Tax Collections Report —1St Quarter FY2023
Director Rose removed item d. from the consent agenda for further discussion.
Motion made by Director Brewster and seconded by Director Rose to approve consent agenda items a.,
b., and c.
Motion carried unanimously.
Motion made by Director Rose seconded by Director Brewster to approve consent agenda item d. as
presented.
Motion carried unanimously.
REGULAR SESSION
3. Receive update from Audit Committee. (Rose, Hunter)
Director Rose and Director Hunter were selected for the Audit Committee. Director Rose met with the
auditor and staff. Director Rose was very pleased with the audit findings.
4. Consider and take appropriate action to approve the Fiscal Year 2022 Annual Financial Audit Report
prepared by Rod Abbott PLLC.
Rod Abbott CPA PLLC., presented the Board with the findings of the audit and answered questions
related thereto. Mr. Abbott stated the District had no misstatements or material defects. Mr. Abbott
stated the District had a clean audit.
Motion made by Director Rose and seconded by Director Harper to approve the Fiscal Year 2022 Annual
Financial Audit Report prepared by Rod Abbott PLLC.
Motion carried unanimously.
The Board convened into Executive Session at 7:29 p.m.
EXECUTIVE SESSION
5. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in
Executive Session on a matter in which the duty of the attorney to the Governmental Body under the
Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open
Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation
or settlement offers:
27 of 32
February 15, 2023 Agenda Packet
a. Consult with legal counsel to secure legal advice concerning the adoption of rules restricting
electioneering and installation of political signs on District property.
b. Consult with legal counsel to secure legal advice regarding the annexation of, or provision of out -of -
District service to, real property located outside the District's boundaries.
The Board reconvened into Regular Session at 8:36 p.m.
REGULAR SESSION
6. Consider and act regarding items discussed in Executive Session.
Item a. No action taken.
Item b. Discussion only. Direction was provided to the General Manager to continue to communicate
with the Town Manager regarding service to out of District properties.
7. Items for future agendas:
8. Customer Deposits
Strategic Committee meeting update (Carr/Brewster)
Reserve Balance discussion (Rose)
9. Set future Meeting dates - February 15, 2023 at 6:30 p.m.
ADJOURN
President Carr called the meeting adjourned at 8:40 p.m.
Kevin Carr, President
Doug Harper, Secretary/Treasurer
Laurie Slaght, District Secretary
28 of 32
(SEAL)
1511
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
STAFF REPORT
February 15, 2023
February 15, 2023 Agenda Packet
AGENDA ITEM: Discussion and possible action regarding customer deposits.
DESCRIPTION: The District's staff has reached out to various municipalities to review the current
customer deposit trends for the surrounding area. Out of over 40 responses received, the conclusion
was that more than 80% of the entities apply the customer deposits to their final bill regardless of
account start date.
Name
Keller
Westlake
NRH
Grapevine
Northlake
Roanoke
Southlake
Deposit Taken
At time of service
Both
At time of service
Applied to first bill
At time of service
At time of service
At time of service
Deposit Applied
Applied to final bill
Applied to final bill
Applied to final bill
Applied to final bill
Applied to final bill
Applied to final bill
2 years of good history
29 of 32
Deposit Types
Cash, Check, CC
Check
Cash, Check, CC
Various
Various
Cash, Check, CC
Cash, Check, CC
Deposit Amount
Residential- $80
Depends on meter size
Residential- $100
Residential- $50
Residential- $150
Residential- $90
Residential- $75
Financial Institutions
Cash Types
i
Cash Report Graphs
1/31/2023
February 15, 2023 Agenda Packet
Prosperity- Depository
Texpool- Investment
Escrow- Investment Holding
Customer Deposits
• Committed Fire Funds
• Committed Bond Reserves
Committed Bond Funds
Committed Bond Escrows
Non -Spendable
• Assigned Fund Capital Projects
Unrestricted Fund Reserves
$3,880
0%
Cash in Funds
$10,000,000
$9,000,000
$8,000,000
$7,000,000
$6,000,000
$5,000,000
$4,000,000
$3,000,000
$2,000,000
$1,000,000
$o
$1,349,157
■
$9,963,498
$3,422,147
$794,335
so
30 o
• 122 -Fire
135 - Operating
137 - GASB Reserves
517 - WWTP Const.
519- Const. Swift
• 520 -Const. WT & WW
• 528 - Bond Reserve 1
• 533 -Tax I&S
534-I&S WWTP
• 535 - l&S Swift
• 536 - l&S WT & WW
$1,289,991
$911,864 $659,283
■-_ $249,400 $107,388 $140,22rL
February 15, 2023 Agenda Packet
$12,000,000
$10,000,000
■
$8,000,000
1
$6,000,000
L
$4,000,000
$2,000,000
$0
Min
• Actuals
• Max
Operating Reserves
$1,446,578
$1,330,031
$2,893,156
TCMUD Reserve Targets and Actuals
Equipment Replacement Rehabilitation & Replacement
Reserves (GASB) Reserves
$1,653,325 $1,482,870
$3,422,147 $1,895,730
$3,306,651 $1,997,374
Emergency Capital Reserves
$500,000
$500,000
$550,000
t
Debt Service Reserves Rate Stabilization Reserves Undesignated Reserves Total Reserves Target
$865,843 $1,221,254
$911,864 $1,110,000
$911,864 $1,424,797
$411,864
$7,169,871
$9,581,636
$11,083,841
Cash Reserve Standards 'Reserve Fund Categories 'Targets [Min Max Actuals
Budgeted Expense $11,733,354 Operating Reserves 45-90 Days 31,446,578 $2,893,156 $1,330,031
District Assets $110,221,694 Equipment Replacement Reserves(GASB) 1.5% of Assets $1,653,325 $3,306,651 $3,422,147
Annual Net Water Revenue 54,070,848 Rehabilitation & Replacement Reserves TBD at Budget $1,482,870 $1,997,374 $1,895,730
Customer Deposits $328,185 Emergency Capital Reserves TBD $500,000 $550,000 $500,000
Assigned Fund Capital Projects $4,770,878 Debt Service Reserves Bond Covenants $865,843 $911,864 $911,864
Rate Stabilization Reserves 30-35% Net Water Rev $1,221,254 $1,424,797 $1,110,000
Undesignated Reserves 5411,864
(Total Reserves Target $7,169,871 $11,083,841 $9,581,636
31 of 32
Board of Directors Regul-
Trophy Club Municipal Utility District No. 1
March 2023
9
10
11
Sun
Feb 26, 2023
5
12
12 19
13
Mon Tue
L
6
13
20
26 27
28
Wed
Mar 1
February 15, 2023 Agenda PackCed�rie Slaght
Thu Fri
10
Sat
11
14
15
16
17
21
22
23 24
18
25
_9 30 31 Apr 1
32 of 32
Printed on: 02/10/2023 7:47am 0 Central Time US & Ca Powered by _ teamup