Loading...
HomeMy WebLinkAbout2024-09 September Combined Financials10/4/2024 9:31:52 AM Page 1 of 3 Check Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 09/01/2024 - 09/30/2024 Vendor Number Vendor Name Payment Amount NumberPayment TypePayment Date Discount Amount Bank Code: Prosperity Bank-Prosperity Bank Payment Type: Regular 2222 Aflac 09/17/2024 10689221.93Regular 0.00 1512 Association of Water Board Directors 09/17/2024 1069045.00Regular 0.00 2683 Charter Communications 09/17/2024 10691903.74Regular 0.00 3184 Dataprose LLC 09/17/2024 106922,827.43Regular 0.00 2497 DHS Automation Inc 09/17/2024 106933,993.52Regular 0.00 3118 Exclusive Pest Control 09/17/2024 10694245.00Regular 0.00 2606 Fiserv Solutions LLC 09/17/2024 1069550.00Regular 0.00 2804 Fortiline Inc.09/17/2024 106963,549.00Regular 0.00 2796 Garver 09/17/2024 106974,449.92Regular 0.00 2635 Halff Associates Inc.09/17/2024 106981,502.63Regular 0.00 2759 Hardys Painting 09/17/2024 1069921,880.00Regular 0.00 4004 Insituform Technologies LLC 09/17/2024 1070033,343.25Regular 0.00 2943 JP Morgan Chase Bank NA 09/17/2024 107015,534.00Regular 0.00 2782 Kubota Membrane Usa Corp 09/17/2024 107025,400.00Regular 0.00 3278 Kyocera Document Solutions 09/17/2024 10703108.80Regular 0.00 3132 Legal Shield 09/17/2024 107047.98Regular 0.00 2754 Lower Colorado River Authority 09/17/2024 10705801.00Regular 0.00 4089 Mas Talent LLC 09/17/2024 107065,737.50Regular 0.00 1050 Michael'S Keys Inc.09/17/2024 10707240.00Regular 0.00 2763 Novotx 09/17/2024 1070810,609.00Regular 0.00 4019 Peterson Pump & Motor Service LLC 09/17/2024 10709800.00Regular 0.00 3176 Rey-Mar Construction 09/17/2024 1071085,994.00Regular 0.00 4002 SmartSights Technologies LLC 09/17/2024 107111,450.00Regular 0.00 3156 Southern Petroleum Lab Inc 09/17/2024 107123,265.20Regular 0.00 2440 Tarrant County Public Health Laboratory 09/17/2024 10713420.00Regular 0.00 2696 Texas Excavation Safety System 09/17/2024 10714341.55Regular 0.00 4085 The Liston Law Firm, P.C.09/17/2024 107155,273.25Regular 0.00 1001 Town of Trophy Club 09/17/2024 10716227,485.32Regular 0.00 1081 Tri County Electric 09/17/2024 10717598.53Regular 0.00 1058 Verizon Wireless 09/17/2024 10718583.80Regular 0.00 3280 Watts Ellison LLC 09/17/2024 107193,089.67Regular 0.00 430,751.02Total Regular: 0.00 Check Report Date Range: 09/01/2024 - 09/30/2024 10/4/2024 9:31:52 AM Page 2 of 3 Vendor Number Vendor Name Payment Amount NumberPayment TypePayment Date Discount Amount Payment Type: Bank DraŌ 3197 BenefitMall 09/13/2024 DFT0000193248.33Bank Draft 0.00 3113 TCDRS 09/30/2024 DFT00001949,085.36Bank Draft 0.00 3124 IRS Tax Payment 09/13/2024 DFT000019512,380.12Bank Draft 0.00 3197 BenefitMall 09/27/2024 DFT0000197248.33Bank Draft 0.00 3113 TCDRS 09/30/2024 DFT00001989,270.97Bank Draft 0.00 3124 IRS Tax Payment 09/27/2024 DFT000019912,087.80Bank Draft 0.00 43,320.91Total Bank Draft: 0.00 Regular Checks Manual Checks Voided Checks Discount Payment CountPayment Type Bank Code Prosperity Bank Summary Bank Drafts EFT's 31 0 0 6 0 0.00 0.00 0.00 0.00 0.00 37 0.00 Payment 430,751.02 0.00 0.00 43,320.91 0.00 474,071.93 Payable Count 45 0 0 6 0 51 Check Report Date Range: 09/01/2024 - 09/30/2024 Page 3 of 310/4/2024 9:31:52 AM All Bank Codes Check Summary Payment Type Discount Payment Count Payment Payable Count Regular Checks Manual Checks Voided Checks Bank Drafts EFT's 31 0 0 6 0 0.00 0.00 0.00 0.00 0.00 37 0.00 430,751.02 0.00 0.00 43,320.91 0.00 474,071.93 45 0 0 6 0 51 Fund Name AmountPeriod Fund Summary 996 MUD Consolidated Cash 474,071.939/2024 474,071.93 FY 2024 Combined Financials YTD as of 9/30/2024 Water Budget vs Actual 20,000,000 40,000,000 60,000,000 80,000,000 100,000,000 120,000,000 140,000,000 160,000,000 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Water Consumption Budget vs Actual Budget Consumption Actual Consumption $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 $1,000,000 $1,100,000 $1,200,000 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Water Revenue Budget vs Actual Budget Revenue Actual Revenue $6,939,988 $7,123,854 $4,284,491 $4,505,292 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 Total Water Revenue Adopted Budget Water Revenue Vs Projected Water Revenue Budgeted Water Revenue Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses Net Projected Water Revenue Minus Projected Expenses $14,423,933 $14,423,933 $13,525,810 $13,008,905 $500,000 $2,500,000 $4,500,000 $6,500,000 $8,500,000 $10,500,000 $12,500,000 $14,500,000 Revenues vs Expenses Adopted Budget vs YTD Actuals Revenues & Expenses 135 YTD Revenues 135 YTD Expenses Adopted Revenues Adopted Expenses 868,678,857 935,694,202 0 100,000,000 200,000,000 300,000,000 400,000,000 500,000,000 600,000,000 700,000,000 800,000,000 900,000,000 1,000,000,000 Total Water Consumption Adopted Budget Water Consumption Vs Actual Water Consumption Budgeted Water Consumption Projected Water Consumption $8,142,745 60% $3,696,802 27% $1,609,942 12% $2,169 0% $74,153 1% YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD YTD Expense- Non Dept Presented by: Finance Department 10/8/2024 4:26:17 PM Page 1 of 6 Budget Report Trophy Club Municipal Utility District No. 1 Account Summary For Fiscal: 2023-2024 Period Ending: 09/30/2024 Fiscal AcƟvity Variance Favorable (Unfavorable) Percent Remaining Current Total Budget Period AcƟvity Original Total Budget Fund: 135 - MUD 1 General Fund Revenue Department: 000 - Revenue, Asset, Liability, & Equity Property Taxes 85,733.51 85,329.18 -404.33 0.47 %32.68135-000-40000-000 85,733.51 Property Taxes/Delinquent 300.00 -1,360.40 -1,660.40 553.47 %0.00135-000-40002-000 300.00 Property Taxes/P & I 300.00 440.27 140.27 146.76 %5.90135-000-40015-000 300.00 PID Surcharges 143,223.25 145,030.72 1,807.47 101.26 %12,086.84135-000-40025-000 143,223.25 Water 6,939,998.00 7,123,853.96 183,855.96 102.65 %840,231.95135-000-47000-000 6,939,998.00 Sewer 3,679,786.00 3,570,724.14 -109,061.86 2.96 %308,063.58135-000-47005-000 3,679,786.00 Penalties 105,800.00 94,031.07 -11,768.93 11.12 %10,858.09135-000-47025-000 105,800.00 Service Charges 3,350.00 3,650.00 300.00 108.96 %175.00135-000-47030-000 3,350.00 Plumbing Inspections 300.00 2,550.00 2,250.00 850.00 %450.00135-000-47035-000 300.00 Sewer Inspections 100.00 700.00 600.00 700.00 %50.00135-000-47045-000 100.00 TCCC Effluent Charges 70,000.00 90,091.20 20,091.20 128.70 %20,684.80135-000-47070-000 70,000.00 Interest Income 150,000.00 521,770.85 371,770.85 347.85 %40,400.98135-000-49011-000 150,000.00 Cell Tower Revenue 49,320.00 49,320.00 0.00 0.00 %4,120.00135-000-49016-000 49,320.00 Proceeds from Sale of Assets 25,000.00 51,450.00 26,450.00 205.80 %0.00135-000-49026-000 25,000.00 Prior Year Reserves 1,933,264.00 0.00 -1,933,264.00 100.00 %0.00135-000-49035-000 1,933,264.00 GASB Reserves 50,000.00 50,000.00 0.00 0.00 %0.00135-000-49036-000 50,000.00 Oversize Meter Reimbursement 2,058.00 8,025.60 5,967.60 389.97 %2,033.60135-000-49075-000 2,058.00 Interfund Transfer In 1,178,400.00 1,200,330.86 21,930.86 101.86 %0.00135-000-49141-000 1,178,400.00 Miscellaneous Income 7,000.00 12,967.25 5,967.25 185.25 %3,731.45135-000-49900-000 7,000.00 Department: 000 - Revenue, Asset, Liability, & Equity Total: 13,008,904.701,242,924.8714,423,932.76 14,423,932.76 -1,415,028.06 9.81% Revenue Total: 13,008,904.701,242,924.8714,423,932.76 14,423,932.76 -1,415,028.06 9.81% Expense Department: 010 - Water Salaries & Wages 431,575.02 441,760.09 -10,185.07 -2.36 %45,221.71135-010-50005-000 431,575.02 Overtime 17,000.00 12,747.22 4,252.78 25.02 %1,942.05135-010-50010-000 17,000.00 Longevity 6,252.50 6,252.50 0.00 0.00 %0.00135-010-50016-000 6,252.50 Certification 3,600.00 2,950.00 650.00 18.06 %350.00135-010-50017-000 3,600.00 Retirement 56,730.41 56,622.38 108.03 0.19 %5,701.66135-010-50020-000 56,730.41 Medical Insurance 116,527.50 96,417.83 20,109.67 17.26 %10,118.18135-010-50026-000 116,527.50 Dental Insurance 4,834.55 4,482.33 352.22 7.29 %488.15135-010-50027-000 4,834.55 Vision Insurance 1,051.01 879.02 171.99 16.36 %94.66135-010-50028-000 1,051.01 Life Insurance & Other 4,000.00 3,444.28 555.72 13.89 %0.00135-010-50029-000 4,000.00 Social Security Taxes 28,422.51 27,953.93 468.58 1.65 %2,852.69135-010-50030-000 28,422.51 Medicare Taxes 6,647.20 6,537.57 109.63 1.65 %667.17135-010-50035-000 6,647.20 Unemployment Taxes 1,260.00 585.00 675.00 53.57 %0.00135-010-50040-000 1,260.00 Workman's Compensation 11,898.56 10,073.25 1,825.31 15.34 %1,060.91135-010-50045-000 11,898.56 Pre-emp Physicals/Testing 400.00 0.00 400.00 100.00 %0.00135-010-50060-000 400.00 Employee Relations 300.00 101.06 198.94 66.31 %0.00135-010-50070-000 300.00 Maintenance & Repairs 201,500.00 184,539.99 16,960.01 8.42 %8,801.38135-010-55080-000 201,500.00 Generator Maint. and Repair 2,000.00 13,469.93 -11,469.93 -573.50 %0.00135-010-55085-000 2,000.00 Vehicle Maintenance 5,000.00 5,276.98 -276.98 -5.54 %331.49135-010-55090-000 5,000.00 Maintenance-Backhoe/SkidLoader 1,000.00 1,911.94 -911.94 -91.19 %0.00135-010-55105-000 1,000.00 Cleaning Services 2,500.00 40.31 2,459.69 98.39 %0.00135-010-55120-000 2,500.00 Lab Analysis 7,500.00 6,398.00 1,102.00 14.69 %420.00135-010-55135-000 7,500.00 Lab Analysis for PID 2,000.00 3,111.00 -1,111.00 -55.55 %120.00135-010-55135-001 2,000.00 Communications/Mobiles 7,500.00 5,268.78 2,231.22 29.75 %334.82135-010-60010-000 7,500.00 Electricity 183,143.49 161,117.58 22,025.91 12.03 %26,186.61135-010-60020-000 183,143.49 Postage 0.00 95.45 -95.45 0.00 %0.00135-010-60035-000 0.00 Publications/Books/Subscripts 1,000.00 0.00 1,000.00 100.00 %0.00135-010-60066-000 1,000.00 Budget Report For Fiscal: 2023-2024 Period Ending: 09/30/2024 10/8/2024 4:26:17 PM Page 2 of 6 Fiscal AcƟvity Variance Favorable (Unfavorable) Percent Remaining Current Total Budget Period AcƟvity Original Total Budget Schools & Training 2,630.00 3,782.74 -1,152.74 -43.83 %0.00135-010-60080-000 2,630.00 Travel & per diem 577.50 611.54 -34.04 -5.89 %7.44135-010-60100-000 577.50 TCEQ Fees & Permits 29,500.00 16,424.55 13,075.45 44.32 %0.00135-010-60135-000 29,500.00 TCEQ Fees & Permits for PID 500.00 0.00 500.00 100.00 %0.00135-010-60135-001 500.00 Wholesale Water 2,655,497.13 2,337,779.65 317,717.48 11.96 %372,790.65135-010-60150-000 2,655,497.13 Lawn Equipment & Maintenance 12,500.00 9,600.00 2,900.00 23.20 %1,800.00135-010-60285-000 12,500.00 Interfund Transfer Out-Rev I&S 565,796.88 566,505.72 -708.84 -0.13 %0.00135-010-60332-000 565,796.88 Interfund Transfer Out 0.00 920,912.00 -920,912.00 0.00 %0.00135-010-60334-000 0.00 Fuel & Lube 23,575.00 16,564.68 7,010.32 29.74 %956.18135-010-65005-000 23,575.00 Uniforms 4,355.00 1,991.46 2,363.54 54.27 %0.00135-010-65010-000 4,355.00 Chemicals 58,200.00 37,791.01 20,408.99 35.07 %3,229.99135-010-65030-000 58,200.00 Safety Equipment 0.00 2,359.58 -2,359.58 0.00 %0.00135-010-65040-000 0.00 Meter Expense 20,000.00 19,740.00 260.00 1.30 %0.00135-010-65050-000 20,000.00 Meter Change Out Program 124,500.00 82,650.00 41,850.00 33.61 %0.00135-010-65053-000 124,500.00 Office Supplies 0.00 308.91 -308.91 0.00 %159.91135-010-65085-000 0.00 Capital Outlays 4,200,000.00 2,695,027.27 1,504,972.73 35.83 %205,170.32135-010-69005-000 4,200,000.00 GASB Reserve for Replacement 378,659.00 378,659.00 0.00 0.00 %0.00135-010-69195-000 378,659.00 Department: 010 - Water Total: 8,142,744.53688,805.979,179,933.26 9,179,933.26 1,037,188.73 11.30% Department: 020 - Wastewater Salaries & Wages 290,304.62 201,480.36 88,824.26 30.60 %14,460.01135-020-50005-000 290,304.62 Overtime 20,000.00 11,695.81 8,304.19 41.52 %1,213.95135-020-50010-000 20,000.00 Longevity 2,367.50 2,540.00 -172.50 -7.29 %0.00135-020-50016-000 2,367.50 Certification 5,100.00 2,850.00 2,250.00 44.12 %175.00135-020-50017-000 5,100.00 Retirement 40,934.05 26,748.98 14,185.07 34.65 %1,901.88135-020-50020-000 40,934.05 Medical Insurance 93,222.04 52,635.25 40,586.79 43.54 %4,304.44135-020-50026-000 93,222.04 Dental Insurance 3,385.28 2,275.82 1,109.46 32.77 %157.76135-020-50027-000 3,385.28 Vision Insurance 818.82 501.49 317.33 38.75 %50.69135-020-50028-000 818.82 Life Insurance & Other 3,000.00 2,034.89 965.11 32.17 %0.00135-020-50029-000 3,000.00 Social Security Taxes 20,507.87 13,058.90 7,448.97 36.32 %943.33135-020-50030-000 20,507.87 Medicare Taxes 4,796.20 3,054.10 1,742.10 36.32 %220.62135-020-50035-000 4,796.20 Unemployment Taxes 1,008.00 350.98 657.02 65.18 %0.00135-020-50040-000 1,008.00 Workman's Compensation 8,403.61 6,864.15 1,539.46 18.32 %748.92135-020-50045-000 8,403.61 Pre-emp Physicals/Testing 400.00 0.00 400.00 100.00 %0.00135-020-50060-000 400.00 Employee Relations 300.00 0.00 300.00 100.00 %0.00135-020-50070-000 300.00 Maintenance & Repairs 137,000.00 139,692.55 -2,692.55 -1.97 %9,227.43135-020-55080-000 137,000.00 Mainten & Repairs Collections 270,000.00 258,225.10 11,774.90 4.36 %5,612.79135-020-55081-000 270,000.00 Generator Maint. and Repair 11,000.00 6,478.06 4,521.94 41.11 %0.00135-020-55085-000 11,000.00 Vehicle Maintenance 4,600.00 227.94 4,372.06 95.04 %0.00135-020-55090-000 4,600.00 Veh Maintenance Collections 13,000.00 5,001.52 7,998.48 61.53 %700.00135-020-55091-000 13,000.00 Maintenance-Backhoe/SkidLoader 3,000.00 1,541.03 1,458.97 48.63 %0.00135-020-55105-000 3,000.00 Cleaning Services 2,000.00 40.31 1,959.69 97.98 %0.00135-020-55120-000 2,000.00 Dumpster Services 100,000.00 88,121.03 11,878.97 11.88 %5,431.41135-020-55125-000 100,000.00 Lab Analysis 55,000.00 61,325.62 -6,325.62 -11.50 %4,353.60135-020-55135-000 55,000.00 Communications/Mobiles 7,500.00 3,394.87 4,105.13 54.74 %200.71135-020-60010-000 7,500.00 Electricity 242,978.33 244,330.58 -1,352.25 -0.56 %24,014.18135-020-60020-000 242,978.33 Postage 0.00 87.00 -87.00 0.00 %0.00135-020-60035-000 0.00 Schools & Training 2,119.00 841.25 1,277.75 60.30 %113.75135-020-60080-000 2,119.00 Travel & per diem 527.50 0.00 527.50 100.00 %0.00135-020-60100-000 527.50 TCEQ Fees & Permits 12,000.00 9,888.02 2,111.98 17.60 %0.00135-020-60135-000 12,000.00 Lawn Equipment & Maintenance 16,000.00 15,170.00 830.00 5.19 %2,130.00135-020-60285-000 16,000.00 Interfund Transfer Out-Tax I&S 115,885.76 115,885.99 -0.23 0.00 %0.00135-020-60331-000 115,885.76 Interfund Transfer Out-Rev I&S 698,542.63 699,035.15 -492.52 -0.07 %0.00135-020-60332-000 698,542.63 Interfund Transfer Out 0.00 96,630.00 -96,630.00 0.00 %0.00135-020-60334-000 0.00 Fuel & Lube 13,000.00 10,691.83 2,308.17 17.76 %850.88135-020-65005-000 13,000.00 Uniforms 3,520.00 1,731.53 1,788.47 50.81 %0.00135-020-65010-000 3,520.00 Chemicals 32,500.00 25,347.16 7,152.84 22.01 %0.00135-020-65030-000 32,500.00 Chemicals Collections 10,000.00 5,709.00 4,291.00 42.91 %0.00135-020-65031-000 10,000.00 Lab Supplies 33,000.00 26,116.94 6,883.06 20.86 %0.00135-020-65045-000 33,000.00 Budget Report For Fiscal: 2023-2024 Period Ending: 09/30/2024 10/8/2024 4:26:17 PM Page 3 of 6 Fiscal AcƟvity Variance Favorable (Unfavorable) Percent Remaining Current Total Budget Period AcƟvity Original Total Budget Capital Outlays 1,050,000.00 1,376,879.51 -326,879.51 -31.13 %1,278.92135-020-69005-000 1,050,000.00 Short Term Debt-Principal 22,398.34 22,132.30 266.04 1.19 %0.00135-020-69008-000 22,398.34 Short Term Debt-Interest 442.39 425.07 17.32 3.92 %0.00135-020-69009-000 442.39 GASB Reserve for Replacement 155,762.00 155,762.00 0.00 0.00 %0.00135-020-69195-000 155,762.00 Department: 020 - Wastewater Total: 3,696,802.0978,090.273,506,323.94 3,506,323.94 -190,478.15 -5.43% Department: 026 - Board of Directors Workman's Compensation 15.00 7.92 7.08 47.20 %0.66135-026-50045-000 15.00 Dues & Memberships 750.00 750.00 0.00 0.00 %0.00135-026-60070-000 750.00 Meetings 1,500.00 1,275.89 224.11 14.94 %115.99135-026-60075-000 1,500.00 Schools & Training 4,000.00 135.00 3,865.00 96.63 %0.00135-026-60080-000 4,000.00 Travel & per diem 5,000.00 0.00 5,000.00 100.00 %0.00135-026-60100-000 5,000.00 Miscellaneous Expenses 500.00 0.00 500.00 100.00 %0.00135-026-60245-000 500.00 Department: 026 - Board of Directors Total: 2,168.81116.6511,765.00 11,765.00 9,596.19 81.57% Department: 030 - Administration Salaries & Wages 663,185.25 673,563.05 -10,377.80 -1.56 %65,467.93135-030-50005-000 663,185.25 Overtime 2,000.00 1,629.21 370.79 18.54 %8.87135-030-50010-000 2,000.00 Longevity 2,532.50 2,597.50 -65.00 -2.57 %0.00135-030-50016-000 2,532.50 Retirement 82,631.07 82,468.28 162.79 0.20 %7,839.23135-030-50020-000 82,631.07 Medical Insurance 108,759.00 80,078.73 28,680.27 26.37 %8,653.57135-030-50026-000 108,759.00 Dental Insurance 3,816.74 3,051.92 764.82 20.04 %335.96135-030-50027-000 3,816.74 Vision Insurance 886.17 673.43 212.74 24.01 %73.36135-030-50028-000 886.17 Life Insurance & Other 4,800.00 4,655.36 144.64 3.01 %14.37135-030-50029-000 4,800.00 Social Security Taxes 41,398.50 40,100.41 1,298.09 3.14 %3,919.84135-030-50030-000 41,398.50 Medicare Taxes 9,681.91 9,494.68 187.23 1.93 %916.73135-030-50035-000 9,681.91 Unemployment Taxes 1,512.00 936.01 575.99 38.09 %0.00135-030-50040-000 1,512.00 Workman's Compensation 1,597.19 1,319.12 278.07 17.41 %139.51135-030-50045-000 1,597.19 Pre-emp Physicals/Testing 500.00 353.40 146.60 29.32 %0.00135-030-50060-000 500.00 Employee Relations 4,000.00 3,176.98 823.02 20.58 %0.00135-030-50070-000 4,000.00 Software & Support 130,311.00 160,832.81 -30,521.81 -23.42 %14,844.28135-030-55030-000 130,311.00 Maintenance & Repairs 23,000.00 26,135.71 -3,135.71 -13.63 %615.00135-030-55080-000 23,000.00 Generator Maint. and Repair 1,000.00 1,348.04 -348.04 -34.80 %0.00135-030-55085-000 1,000.00 Building Maint & Supplies 0.00 332.98 -332.98 0.00 %0.00135-030-55100-000 0.00 Cleaning Services 13,825.00 18,054.70 -4,229.70 -30.59 %1,600.00135-030-55120-000 13,825.00 Professional Outside Services 100,000.00 100,867.35 -867.35 -0.87 %1,362.50135-030-55160-000 100,000.00 Utility Billing Contract 9,000.00 7,028.66 1,971.34 21.90 %0.00135-030-55205-000 9,000.00 Telephone 6,000.00 5,446.07 553.93 9.23 %724.77135-030-60005-000 6,000.00 Communications/Mobiles 3,000.00 530.86 2,469.14 82.30 %48.27135-030-60010-000 3,000.00 Electricity/Gas 17,684.51 17,786.45 -101.94 -0.58 %1,843.49135-030-60020-000 17,684.51 Water 5,000.00 2,226.42 2,773.58 55.47 %0.00135-030-60025-000 5,000.00 Postage 30,000.00 24,680.01 5,319.99 17.73 %0.00135-030-60035-000 30,000.00 Service Charges & Fees 140,000.00 165,396.64 -25,396.64 -18.14 %10,956.36135-030-60040-000 140,000.00 Bad Debt Expense 13,000.00 0.00 13,000.00 100.00 %0.00135-030-60050-000 13,000.00 Insurance 116,158.22 115,421.26 736.96 0.63 %9,618.42135-030-60055-000 116,158.22 Dues & Memberships 6,800.00 2,380.00 4,420.00 65.00 %112.00135-030-60070-000 6,800.00 Schools & Training 3,900.00 1,313.10 2,586.90 66.33 %0.00135-030-60080-000 3,900.00 Travel & per diem 1,227.50 0.00 1,227.50 100.00 %0.00135-030-60100-000 1,227.50 Elections 10,000.00 0.00 10,000.00 100.00 %0.00135-030-60115-000 10,000.00 Miscellaneous Expenses 0.00 1,961.15 -1,961.15 0.00 %0.00135-030-60245-000 0.00 Lawn Equipment & Maintenance 5,000.00 6,465.71 -1,465.71 -29.31 %939.34135-030-60285-000 5,000.00 Furniture/Equipment < $5000 3,000.00 189.00 2,811.00 93.70 %189.00135-030-60360-000 3,000.00 Uniforms 530.00 0.00 530.00 100.00 %0.00135-030-65010-000 530.00 Hardware 8,200.00 9,698.88 -1,498.88 -18.28 %0.00135-030-65055-000 8,200.00 Office Supplies 5,000.00 3,616.46 1,383.54 27.67 %209.36135-030-65085-000 5,000.00 Maintenance Supplies 5,000.00 5,866.45 -866.45 -17.33 %161.79135-030-65095-000 5,000.00 Printing 0.00 108.80 -108.80 0.00 %108.80135-030-65105-000 0.00 Copier Lease Installments 4,000.00 3,253.35 746.65 18.67 %166.25135-030-69170-000 4,000.00 GASB Reserve for Replacement 24,903.00 24,903.00 0.00 0.00 %0.00135-030-69195-000 24,903.00 Budget Report For Fiscal: 2023-2024 Period Ending: 09/30/2024 10/8/2024 4:26:17 PM Page 4 of 6 Fiscal AcƟvity Variance Favorable (Unfavorable) Percent Remaining Current Total Budget Period AcƟvity Original Total Budget Department: 030 - Administration Total: 1,609,941.94130,869.001,612,839.56 1,612,839.56 2,897.62 0.18% Department: 039 - Non Departmental Legal 65,000.00 38,413.45 26,586.55 40.90 %0.00135-039-55045-000 65,000.00 Auditing 30,000.00 21,784.29 8,215.71 27.39 %0.00135-039-55055-000 30,000.00 Appraisal 13,071.00 10,014.12 3,056.88 23.39 %1,967.85135-039-55060-000 13,071.00 Tax Admin Fees 5,000.00 3,941.00 1,059.00 21.18 %0.00135-039-55065-000 5,000.00 Department: 039 - Non Departmental Total: 74,152.861,967.85113,071.00 113,071.00 38,918.14 34.42% Expense Total: 13,525,810.23899,849.7414,423,932.76 14,423,932.76 898,122.53 6.23% Fund: 135 - MUD 1 General Fund Surplus (Deficit): -516,905.53343,075.130.00 0.00 -516,905.53 0.00% Report Surplus (Deficit): 343,075.13 -516,905.530.00 0.00 -516,905.53 0.00% Budget Report For Fiscal: 2023-2024 Period Ending: 09/30/2024 10/8/2024 4:26:17 PM Page 5 of 6 Group Summary Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityDepartment Current Total Budget Original Total Budget Percent Remaining Fund: 135 - MUD 1 General Fund Revenue 000 - Revenue, Asset, Liability, & Equity 13,008,904.701,242,924.8714,423,932.76 14,423,932.76 -1,415,028.06 9.81% 13,008,904.701,242,924.8714,423,932.76 14,423,932.76 -1,415,028.06Revenue Total:9.81% Expense 010 - Water 8,142,744.53688,805.979,179,933.26 9,179,933.26 1,037,188.73 11.30% 020 - Wastewater 3,696,802.0978,090.273,506,323.94 3,506,323.94 -190,478.15 -5.43% 026 - Board of Directors 2,168.81116.6511,765.00 11,765.00 9,596.19 81.57% 030 - Administration 1,609,941.94130,869.001,612,839.56 1,612,839.56 2,897.62 0.18% 039 - Non Departmental 74,152.861,967.85113,071.00 113,071.00 38,918.14 34.42% 13,525,810.23899,849.7414,423,932.76 14,423,932.76 898,122.53Expense Total:6.23% -516,905.53343,075.130.00 0.00 -516,905.53Fund: 135 - MUD 1 General Fund Surplus (Deficit):0.00% Report Surplus (Deficit): 343,075.13 -516,905.530.00 0.00 -516,905.53 0.00% Budget Report For Fiscal: 2023-2024 Period Ending: 09/30/2024 10/8/2024 4:26:17 PM Page 6 of 6 Fund Summary Fiscal AcƟvity Variance Favorable (Unfavorable)Fund Period AcƟvity Current Total Budget Original Total Budget 135 - MUD 1 General Fund -516,905.53343,075.130.00 0.00 -516,905.53 Report Surplus (Deficit): 343,075.13 -516,905.530.00 0.00 -516,905.53 135-10250 TexPool O & M (XXXXX0002) General Fund Operating $0 $2,462,580 $2,462,580 135-10300 Prosperity Bank (XXXXX2660) General Fund Operating * $148,950 $5,351,926 $5,500,876 135-10305 Prosperity Bank Reserve-Savings Acct (XXXXX7724) $1,998,815 $0 $1,998,815 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 137-10250 TexPool O & M (XXXXX0002) GASB Replacement $4,866,433 $0 $4,866,433 519-10300 Prosperity Bank (XXXXX2660) SWIFT $85,052 $0 $85,052 519-11155 Cash-Bond Escrow Bank of Texas (SWIFT) $854,731 $0 $854,731 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $0 $0 $0 520-10300 Prosperity Bank (XXXXX2660)- Construction Water & Waste Water Systems $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $993,836 $0 $993,836 533-10250 TexPool Tax I & S (XXXXX0003) $102,140 $0 $102,140 533-10300 Prosperity Bank (XXXXX2660) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $52,955 $0 $52,955 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $18,149 $0 $18,149 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $12,891 $0 $12,891 $7,815,106 $16,949,058 Amount available in cash for spending (MUD Accounts)$7,815,106 *9/30/2024 Customer Water Deposits $148,950 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $576,838 $576,838 122-10300 Prosperity Bank (XXXXX2660) Fire Operating $0 $55,363 $55,363 $0 $632,201 $632,201 Amount available in cash for spending (Fire Department Accounts)$632,201 5,351,926$ Prosperity General Fund 2,462,580$ Texpool General Fund 600$ Petty Cash Total General Fund 135 Available for Spending 7,815,106$ Nonspendable Fund Balance (Prepaids) 3,880$ Assigned Fund Balance (FY2024 Capital Projects plus prior year carry forward) 6,516,007$ Unassigned Fund Balance 4,185,596$ Current Year Revenue/Expenses (516,906)$ Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,188,577 General Fund 135 Available General Fund 135 Fund Balances Fire Department Cash CASH STATUS AS OF SEPTEMBER 2024 Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) Restricted/ Investment Account Sec Beginning Value Ending Market Unrestricted Type Number Type Yield % 6/30/2024 Deposits Withdrawals Interest 9/30/2024 Maturity Unrestricted- 122 CK XXXX2660 Prosperity Bank Consolidated Cash-Fire Dept 0.35% 946 54,417 - - 55,363 N/A Restricted- 122 PF TexPool Municipal Fund-Fire Dept 4.98% 863,969 11,728 (298,860) - 576,838 N/A Unrestricted- 135 CK XXXX2660 Prosperity Bank Consolidated Cash-General Fund 0.35% 4,912,889 4,654,232 (4,070,971) 4,726 5,500,875 N/A Unrestricted- 135 PF XXXXX0002 TexPool Municipal Fund-Operating 4.98% 2,780,223 88,013 (513,296) 107,640 2,462,580 N/A Restricted SA XXXXX7724 Prosperity Bank Cash Reserve- Money Mkt 3.19% 1,983,072 - - 15,744 1,998,815 N/A Restricted- 137 PF TexPool Municipal Fund-GASB Replacement 4.98% 4,916,433 - (50,000) - 4,866,433 N/A Restricted- 519 CK XXXX2660 Prosperity Bank Consolidated Cash-Tax SWIFT 0.35% 85,052 - - - 85,052 N/A Restricted- 519 PF XXXXX00015 Texpool Revenue Bond Construction-SWIFT 4.98% - - - - - N/A Restricted- 519 ES 82-1747-01-1 Revenue Bond Series 2016 Escrow- BOK 3.19% 836,522 - - 18,210 854,732 Restricted- 520 PF XXXXX00018 Texpool Revenue Bond Construction Series 2019 4.98% - - - - - N/A Restricted- 528 PF XXXXX00014 Texpool Revenue Bond Reserve 4.98% 980,774 - - 13,062 993,836 N/A Restricted- 533 CK XXXX2660 Prosperity Bank Consolidated Cash-Tax I&S 0.35% - - - - - N/A Restricted- 533 PF XXXXX0003 TexPool Tax Debt Service 4.98% 537,091 32,653 (472,638) 5,033 102,140 N/A Restricted- 534 PF XXXXX00013 Texpool Revenue Bond I&S 4.98% 405,003 166,810 (523,119) 4,261 52,955 N/A Restricted- 535 PF XXXXX00017 Texpool Revenue Bond I&S-SWIFT 4.98% 188,266 74,704 (246,757) 1,936 18,149 N/A Restricted- 536 PF XXXXX00020 Texpool Revenue Bond I&S Series 2019 4.98% 182,073 103,633 (274,794) 1,978 12,891 N/A CK Checking 18,672,313$ 5,186,190$ (6,450,434)$ 172,590$ 17,580,659$ MM Money Market PF Pools & Funds SA Savings Accounts ES Escrow/ Treasuries CD Certificate of Deposit Prepared By Regina Van Dyke DATE Investment Officer Alan Fourmentin DATE Investment Policy and the Public Funds Investment Act. Trophy Club Municipal Utility District No. 1 Quarterly Investment Report For Ending Period 09/30/2024 (July, August, September) I certify that this Investment Report complies with requirements of the District's