Loading...
HomeMy WebLinkAbout2024-08 August Combined Financials4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT No. Trophy Club Municipal Utility District No. 1 Vendor Number Vendor Name Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular Check Report By Check Number Date Range: 08/01/2024 - 08/31/2024 Payment Date Payment Type Discount Amount Payment Amount Number 3213 Alan'S Gates, Inc. 08/09/2024 Regular 0.00 145.00 10580 1512 Association of Water Board Directors 08/09/2024 Regular 0.00 90.00 10581 3197 BenefitMall 08/09/2024 Regular 0.00 52.00 10582 4018 BP Energy Holding Company LLC 08/09/2024 Regular 0.00 38,568.97 10583 2920 CareNow Corporate 08/09/2024 Regular 0.00 38.00 10584 2683 Charter Communications 08/09/2024 Regular 0.00 903.74 10585 4006 Consor Engineers LLC 08/09/2024 Regular 0.00 2,280.00 10586 4003 CW Janitorial Services 08/09/2024 Regular 0.00 1,600.00 10587 3184 Dataprose LLC 08/09/2024 Regular 0.00 2,623.21 10588 2497 DHS Automation Inc 08/09/2024 Regular 0.00 2,728.46 10589 4088 Entech Sales & Service, LLC 08/09/2024 Regular 0.00 305.00 10590 2558 First Check Applicant Screenin 08/09/2024 Regular 0.00 66.95 10591 2606 Fisery Solutions LLC 08/09/2024 Regular 0.00 50.00 10592 2796 Garver 08/09/2024 Regular 0.00 303.00 10593 2635 Halff Associates Inc. 08/09/2024 Regular 0.00 1,260.49 10594 4033 Health Care Service Corporation 08/09/2024 Regular 0.00 21,759.20 10595 2783 JJ HVAC LLC 08/09/2024 Regular 0.00 630.00 10596 2943 JP Morgan Chase Bank NA 08/09/2024 Regular 0.00 6,959.71 10597 3278 Kyocera Document Solutions 08/09/2024 Regular 0.00 125.30 10598 3216 M3 Networks 08/09/2024 Regular 0.00 6,239.64 10599 4089 Mas Talent LLC 08/09/2024 Regular 0.00 1,875.00 10600 3115 Metlife Group Benefits 08/09/2024 Regular 0.00 2,491.09 10601 2760 NDS Leasing 08/09/2024 Regular 0.00 367.50 10602 1056 Office Depot Inc 08/09/2024 Regular 0.00 79.78 10603 2842 Omnisite 08/09/2024 Regular 0.00 64.96 10604 1737 PVS DX INC 08/09/2024 Regular 0.00 1,557.08 10605 4085 The Liston Law Firm, P.C. 08/09/2024 Regular 0.00 2,310.75 10606 1001 Town of Trophy Club 08/09/2024 Regular 0.00 130,783.26 10607 1058 Verizon Wireless 08/09/2024 Regular 0.00 583.84 10608 2222 Aflac 08/09/2024 Regular 0.00 221.93 10619 2772 Allied Waste Industries 08/09/2024 Regular 0.00 14,526.45 10620 3132 Legal Shield 08/09/2024 Regular 0.00 7.98 10621 3176 Rey -Mar Construction 08/09/2024 Regular 0.00 296,067.50 10622 3156 Southern Petroleum Lab Inc 08/09/2024 Regular 0.00 3,265.20 10623 2683 Charter Communications 08/21/2024 Regular 0.00 903.74 10630 2497 DHS Automation Inc 08/21/2024 Regular 0.00 1,655.00 10631 4088 Entech Sales & Service, LLC 08/21/2024 Regular 0.00 9,874.00 10632 3118 Exclusive Pest Control 08/21/2024 Regular 0.00 125.00 10633 2606 Fisery Solutions LLC 08/21/2024 Regular 0.00 50.00 10634 3258 Francotyp-Postalia, Inc. 08/21/2024 Regular 0.00 170.88 10635 2796 Garver 08/21/2024 Regular 0.00 1,654.00 10636 2635 Halff Associates Inc. 08/21/2024 Regular 0.00 4,397.59 10637 3278 Kyocera Document Solutions 08/21/2024 Regular 0.00 125.82 10638 2754 Lower Colorado River Authority 08/21/2024 Regular 0.00 439.00 10639 3216 M3 Networks 08/21/2024 Regular 0.00 1,103.00 10640 3111 North Texas Groundwater 08/21/2024 Regular 0.00 1,290.40 10641 4019 Peterson Pump & Motor Service LLC 08/21/2024 Regular 0.00 640.00 10642 2696 Texas Excavation Safety System 08/21/2024 Regular 0.00 453.10 10643 4085 The Liston Law Firm, P.C. 08/21/2024 Regular 0.00 1,283.75 10644 1081 Tri County Electric 08/21/2024 Regular 0.00 642.87 10645 3225 US Bank Voyager Fleet Systems 08/21/2024 Regular 0.00 2,225.74 10646 1058 Verizon Wireless 08/21/2024 Regular 0.00 583.80 10647 3280 Watts Ellison LLC 08/21/2024 Regular 0.00 3,089.67 10648 9/9/2024 2:58:42 PM Page 1 of 4 Check Report Date Range: 08/01/2024 - 08/31/2024 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 1030 City of Fort Worth 08/21/2024 Regular 0.00 641,199.99 10649 2796 Garver 08/21/2024 Regular 0.00 1,351.88 10650 2635 Halff Associates Inc. 08/21/2024 Regular 0.00 800.00 10651 1578 Smith Pump Company, Inc. 08/21/2024 Regular 0.00 5,025.00 10652 3156 Southern Petroleum Lab Inc 08/21/2024 Regular 0.00 1,838.40 10653 1001 Town of Trophy Club 08/21/2024 Regular 0.00 99,620.00 10654 3300 2T Underground LLC 08/29/2024 Regular 0.00 307,087.50 10655 2655 Core & Main LP 08/29/2024 Regular 0.00 181.29 10656 2804 Fortiline Inc. 08/29/2024 Regular 0.00 55,619.57 10657 2635 Halff Associates Inc. 08/29/2024 Regular 0.00 9,800.00 10658 1466 Polydyne, Inc 08/29/2024 Regular 0.00 4,046.85 10659 1737 PVS DX INC 08/29/2024 Regular 0.00 1,946.35 10660 3176 Rey -Mar Construction 08/29/2024 Regular 0.00 117,610.00 10661 3156 Southern Petroleum Lab Inc 08/29/2024 Regular 0.00 338.40 10662 2222 Aflac 08/29/2024 Regular 0.00 930.70 10663 3197 BenefitMall 08/29/2024 Regular 0.00 52.00 10664 1250 Bio -Aquatic Testing Inc. 08/29/2024 Regular 0.00 1,290.00 10665 4018 BP Energy Holding Company LLC 08/29/2024 Regular 0.00 44,421.37 10666 2655 Core & Main LP 08/29/2024 Regular 0.00 225.42 10667 4003 CW Janitorial Services 08/29/2024 Regular 0.00 1,600.00 10668 1026 Federal Express Corp 08/29/2024 Regular 0.00 87.00 10669 4033 Health Care Service Corporation 08/29/2024 Regular 0.00 20,670.70 10670 3132 Legal Shield 08/29/2024 Regular 0.00 7.97 10671 3115 Metlife Group Benefits 08/29/2024 Regular 0.00 2,385.03 10672 3179 NewGen Strategies & Solutions 08/29/2024 Regular 0.00 2,672.50 10673 1238 North Texas Pump Co. 08/29/2024 Regular 0.00 857.38 10674 3134 Prime Controls LP 08/29/2024 Regular 0.00 847.00 10675 2440 Tarrant County Public Health Laboratory 08/29/2024 Regular 0.00 870.00 10676 1481 TML Intergovernmental Risk 08/29/2024 Regular 0.00 1,250.00 10677 3225 US Bank Voyager Fleet Systems 08/29/2024 Regular 0.00 2,232.64 10678 Total Regular: 0.00 1,898,503.29 9/9/2024 2:58:42 PM Page 2 of 4 Check Report Date Range: 08/01/2024 - 08/31/2024 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payment Type: Bank Draft 3197 BenefitMall 08/02/2024 Bank Draft 0.00 248.33 DFT0000175 3113 TCDRS 08/31/2024 Bank Draft 0.00 9,250.72 DFT0000176 3124 IRS Tax Payment 08/02/2024 Bank Draft 0.00 12,596.00 DFT0000177 3197 BenefitMall 08/16/2024 Bank Draft 0.00 248.33 DFT0000179 3113 TCDRS 08/31/2024 Bank Draft 0.00 9,664.10 DFT0000180 3124 IRS Tax Payment 08/16/2024 Bank Draft 0.00 13,004.68 DFT0000181 3113 TCDRS 08/31/2024 Bank Draft 0.00 18,062.09 DFT0000182 3124 IRS Tax Payment 08/30/2024 Bank Draft 0.00 28,937.11 DFT0000183 3113 TCDRS 08/31/2024 Bank Draft 0.00 -9,006.07 DFT0000184 3124 IRS Tax Payment 08/30/2024 Bank Draft 0.00 -16,161.53 DFT0000185 3113 TCDRS 08/31/2024 Bank Draft 0.00 -573.94 DFT0000186 3124 IRS Tax Payment 08/16/2024 Bank Draft 0.00 -645.79 DFT0000187 3124 IRS Tax Payment 08/30/2024 Bank Draft 0.00 229.10 DFT0000189 Total Bank Draft: 0.00 65,853.13 Bank Code Prosperity Bank Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 109 83 0.00 1,898,503.29 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 13 13 0.00 65,853.13 EFT's 0 0 0.00 0.00 122 96 0.00 1,964,356.42 9/9/2024 2:58:42 PM Page 3 of 4 Check Report Date Range: 08/01/2024 - 08/31/2024 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 109 83 0.00 1,898,503.29 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 13 13 0.00 65,853.13 EFT's 0 0 0.00 0.00 122 96 0.00 1,964,356.42 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 8/2024 1,964,356.42 1,964,356.42 9/9/2024 2:58:42 PM Page 4 of 4 FY 2024 Combined Financials YTD as of 8/31/2024 Adopted Budget vs YTD Actuals Revenues & Expenses • 135 YTD Revenues ■ 135 YTD Expenses Revenues vs Expenses Adopted Revenues Adopted Expenses 160,000,000 140,000,000 120,000,000 100,000,000 80,000,000 92,198,177 r 514,423,933 514,423,933 $0 52,000,000 54,000,000 56,000,000 58,000,000 510,000,000 $12,000,000 514,000,000 60,000,000 $1,891 $66,912 0% $1,474,76 12% 28% 0% Water Budget vs Actual Water Consumption Budget vs Actual 153,267,000 —0—Budget Consumption —*-Actual Consumption — 112,006,200 61,555,000 40,000,000 51,503,997 20,000,000 48,355,000 42,063,017 37,451,315 4,554,000 115,:00,853 17,306,121 82,105,000 59,737,002 93,656,387 44,722,000 46,670,584 65,644,597 41,156,060 35,861,000 36,716,000 226,660 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Adopted Budget Water Consumption Vs Actual Water Consumption 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 Presented by: Finance Department 868,678,857 922,038,290 • Budgeted Water Consumption • Projected Water Consumption $1,200,000 —0—Budget Revenue —&-Actual Revenue 51,100,000 $7,424,324 60% YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD • YTD Expense- Non Dept Water Revenue Budget vs Actual 51,000,000 5900,000 5800,000 $676,430 5493,961 $400,000 $433,720 $410,580 5300,000 $200,000 5100,000 $606,103 $479,045 $450,062 $413,727 $401,119 $345,689$369,594 51 $957,412 $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 50 5237,590 8340,780 $390,412 $404,800 $382,397 01,139,6 2,640 $565,055 e1,462 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Adopted Budget Water Revenue Vs Projected Water Revenue $6,939,988 $7,301,502 54,284,491 Total Water Consumption Total Water Revenue 54,733,599 • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses TROPHY CLUB 1 1 MUNICIPAL UTILITY DISTRICT Trophy Club Municipal Utility District No. 1 Budget Report Account Summary For Fiscal: 2023-2024 Period Ending: 08/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 135 - MUD 1 General Fund Revenue Department: 000 - Revenue, Asset, Liability, & Equity 135-000-40000-000 Property Taxes 85,733.51 85,733.51 294.76 85,296.50 -437.01 0.51 % 135-000-40002-000 Property Taxes/Delinquent 300.00 300.00 6.50 -1,360.40 -1,660.40 553.47 % 135-000-40015-000 Property Taxes/P & I 300.00 300.00 37.95 434.37 134.37 144.79 % 135-000-40025-000 PID Surcharges 143,223.25 143,223.25 12,085.05 132,943.88 -10,279.37 7.18 % 135-000-47000-000 Water 6,939,998.00 6,939,998.00 1,090,481.50 6,283,622.01 -656,375.99 9.46 % 135-000-47005-000 Sewer 3,679,786.00 3,679,786.00 315,210.68 3,262,660.56 -417,125.44 11.34 % 135-000-47025-000 Penalties 105,800.00 105,800.00 12,783.75 83,172.98 -22,627.02 21.39 % 135-000-47030-000 Service Charges 3,350.00 3,350.00 225.00 3,475.00 125.00 103.73 % 135-000-47035-000 Plumbing Inspections 300.00 300.00 0.00 2,100.00 1,800.00 700.00 % 135-000-47045-000 Sewer Inspections 100.00 100.00 0.00 650.00 550.00 650.00 % 135-000-47070-000 TCCC Effluent Charges 70,000.00 70,000.00 22,949.60 69,406.40 -593.60 0.85 % 135-000-49011-000 Interest Income 150,000.00 150,000.00 41,854.97 481,369.87 331,369.87 320.91 % 135-000-49016-000 Cell Tower Revenue 49,320.00 49,320.00 -4,120.00 45,200.00 -4,120.00 8.35 % 135-000-49026-000 Proceeds from Sale of Assets 25,000.00 25,000.00 0.00 51,450.00 26,450.00 205.80 % 135-000-49035-000 Prior Year Reserves 1,933,264.00 1,933,264.00 0.00 0.00 -1,933,264.00 100.00 % 135-000-49036-000 GASB Reserves 50,000.00 50,000.00 0.00 0.00 -50,000.00 100.00 % 135-000-49075-000 Oversize Meter Reimbursement 2,058.00 2,058.00 0.00 5,992.00 3,934.00 291.16 % 135-000-49141-000 Interfund Transfer In 1,178,400.00 1,178,400.00 0.00 1,200,330.86 21,930.86 101.86 % 135-000-49900-000 Miscellaneous Income 7,000.00 7,000.00 246.07 9,235.80 2,235.80 131.94 % Department: 000 - Revenue, Asset, Liability, & Equity Total: 14,423,932.76 14,423,932.76 1,492,055.83 11,715,979.83 -2,707,952.93 18.77% Revenue Total: 14,423,932.76 14,423,932.76 1,492,055.83 11,715,979.83 -2,707,952.93 18.77% Expense Department: 010 - Water 135-010-50005-000 Salaries & Wages 431,575.02 431,575.02 50,296.49 396,538.38 35,036.64 8.12 % 135-010-50010-000 Overtime 17,000.00 17,000.00 1,812.96 10,805.17 6,194.83 36.44% 135-010-50016-000 Longevity 6,252.50 6,252.50 0.00 6,252.50 0.00 0.00 % 135-010-50017-000 Certification 3,600.00 3,600.00 350.00 2,600.00 1,000.00 27.78 % 135-010-50020-000 Retirement 56,730.41 56,730.41 6,295.16 50,920.72 5,809.69 10.24 % 135-010-50026-000 Medical Insurance 116,527.50 116,527.50 7,631.12 86,299.65 30,227.85 25.94 % 135-010-50027-000 Dental Insurance 4,834.55 4,834.55 368.24 3,994.18 840.37 17.38 % 135-010-50028-000 Vision Insurance 1,051.01 1,051.01 71.39 784.36 266.65 25.37 % 135-010-50029-000 Life Insurance & Other 4,000.00 4,000.00 560.38 3,444.28 555.72 13.89 % 135-010-50030-000 Social Security Taxes 28,422.51 28,422.51 3,181.33 25,101.24 3,321.27 11.69 % 135-010-50035-000 Medicare Taxes 6,647.20 6,647.20 744.02 5,870.40 776.80 11.69 % 135-010-50040-000 Unemployment Taxes 1,260.00 1,260.00 0.00 585.00 675.00 53.57 % 135-010-50045-000 Workman's Compensation 11,898.56 11,898.56 1,060.94 9,012.34 2,886.22 24.26 % 135-010-50060-000 Pre-emp Physicals/Testing 400.00 400.00 0.00 0.00 400.00 100.00 % 135-010-50070-000 Employee Relations 300.00 300.00 0.00 0.00 300.00 100.00 % 135-010-55080-000 Maintenance & Repairs 201,500.00 201,500.00 13,799.46 149,855.68 51,644.32 25.63 % 135-010-55085-000 Generator Maint. and Repair 2,000.00 2,000.00 0.00 13,469.93 -11,469.93 -573.50 % 135-010-55090-000 Vehicle Maintenance 5,000.00 5,000.00 0.00 4,586.53 413.47 8.27 % 135-010-55105-000 Maintenance-Backhoe/SkidLoader 1,000.00 1,000.00 0.00 1,911.94 -911.94 -91.19 % 135-010-55120-000 Cleaning Services 2,500.00 2,500.00 0.00 40.31 2,459.69 98.39 % 135-010-55135-000 Lab Analysis 7,500.00 7,500.00 750.00 5,177.00 2,323.00 30.97 % 135-010-55135-001 Lab Analysis for PID 2,000.00 2,000.00 559.00 2,991.00 -991.00 -49.55 % 135-010-60010-000 Communications/Mobiles 7,500.00 7,500.00 2,255.79 4,933.96 2,566.04 34.21 % 135-010-60020-000 Electricity 183,143.49 183,143.49 21,290.79 134,930.97 48,212.52 26.32 % 135-010-60035-000 Postage 0.00 0.00 0.00 95.45 -95.45 0.00 % 135-010-60066-000 Publications/Books/Subscripts 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 9/10/2024 12:15:09 PM Page 1 of 6 Budget Report For Fiscal: 2023-2024 Period Ending: 08/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-010-60080-000 Schools & Training 2,630.00 2,630.00 0.00 3,671.74 -1,041.74 -39.61 % 135-010-60100-000 Travel & per diem 577.50 577.50 0.00 604.10 -26.60 -4.61 % 135-010-60135-000 TCEQ Fees & Permits 29,500.00 29,500.00 1,290.40 16,424.55 13,075.45 44.32 % 135-010-60135-001 TCEQ Fees & Permits for PID 500.00 500.00 0.00 0.00 500.00 100.00 % 135-010-60150-000 Wholesale Water 2,655,497.13 2,655,497.13 641,199.99 1,964,989.00 690,508.13 26.00 % 135-010-60285-000 Lawn Equipment & Maintenance 12,500.00 12,500.00 900.00 7,800.00 4,700.00 37.60 % 135-010-60332-000 Interfund Transfer Out -Rev l&S 565,796.88 565,796.88 51,500.52 566,505.72 -708.84 -0.13 % 135-010-60334-000 Interfund Transfer Out 0.00 0.00 0.00 920,912.00 -920,912.00 0.00 % 135-010-65005-000 Fuel & Lube 23,575.00 23,575.00 1,698.21 15,608.50 7,966.50 33.79 % 135-010-65010-000 Uniforms 4,355.00 4,355.00 0.00 1,991.46 2,363.54 54.27 % 135-010-65030-000 Chemicals 58,200.00 58,200.00 3,910.14 34,561.02 23,638.98 40.62 % 135-010-65050-000 Meter Expense 20,000.00 20,000.00 0.00 19,740.00 260.00 1.30 % 135-010-65053-000 Meter Change Out Program 124,500.00 124,500.00 0.00 82,650.00 41,850.00 33.61 % 135-010-65085-000 Office Supplies 0.00 0.00 0.00 149.00 -149.00 0.00 % 135-010-69005-000 Capital Outlays 4,200,000.00 4,200,000.00 695,037.00 2,489,856.95 1,710,143.05 40.72 % 135-010-69195-000 GASB Reserve for Replacement 378,659.00 378,659.00 0.00 378,659.00 0.00 0.00 % Department: 010 - Water Total: 9,179,933.26 9,179,933.26 1,506,563.33 7,424,324.03 1,755,609.23 19.12% Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 290,304.62 290,304.62 16,176.76 187,020.35 103,284.27 35.58 % 135-020-50010-000 Overtime 20,000.00 20,000.00 1,917.03 10,481.86 9,518.14 47.59 % 135-020-50016-000 Longevity 2,367.50 2,367.50 0.00 2,540.00 -172.50 -7.29 % 135-020-50017-000 Certification 5,100.00 5,100.00 175.00 2,675.00 2,425.00 47.55 % 135-020-50020-000 Retirement 40,934.05 40,934.05 2,192.26 24,847.10 16,086.95 39.30 % 135-020-50026-000 Medical Insurance 93,222.04 93,222.04 6,519.37 48,330.81 44,891.23 48.16 % 135-020-50027-000 Dental Insurance 3,385.28 3,385.28 201.97 2,118.06 1,267.22 37.43 % 135-020-50028-000 Vision Insurance 818.82 818.82 25.60 450.80 368.02 44.95 % 135-020-50029-000 Life Insurance & Other 3,000.00 3,000.00 319.29 2,034.89 965.11 32.17 % 135-020-50030-000 Social Security Taxes 20,507.87 20,507.87 1,101.39 12,115.57 8,392.30 40.92 % 135-020-50035-000 Medicare Taxes 4,796.20 4,796.20 257.59 2,833.48 1,962.72 40.92 % 135-020-50040-000 Unemployment Taxes 1,008.00 1,008.00 0.00 350.98 657.02 65.18 % 135-020-50045-000 Workman's Compensation 8,403.61 8,403.61 748.93 6,115.23 2,288.38 27.23 % 135-020-50060-000 Pre-emp Physicals/Testing 400.00 400.00 0.00 0.00 400.00 100.00 % 135-020-50070-000 Employee Relations 300.00 300.00 0.00 0.00 300.00 100.00 % 135-020-55080-000 Maintenance & Repairs 137,000.00 137,000.00 4,194.38 129,186.69 7,813.31 5.70 % 135-020-55081-000 Mainten & Repairs Collections 270,000.00 270,000.00 5,665.00 252,583.83 17,416.17 6.45 % 135-020-55085-000 Generator Maint. and Repair 11,000.00 11,000.00 0.00 6,478.06 4,521.94 41.11 % 135-020-55090-000 Vehicle Maintenance 4,600.00 4,600.00 0.00 227.94 4,372.06 95.04 % 135-020-55091-000 Veh Maintenance Collections 13,000.00 13,000.00 0.00 4,301.52 8,698.48 66.91 % 135-020-55105-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 0.00 1,541.03 1,458.97 48.63 % 135-020-55120-000 Cleaning Services 2,000.00 2,000.00 0.00 40.31 1,959.69 97.98 % 135-020-55125-000 Dumpster Services 100,000.00 100,000.00 14,526.45 82,689.62 17,310.38 17.31 % 135-020-55135-000 Lab Analysis 55,000.00 55,000.00 6,732.00 54,795.22 204.78 0.37 % 135-020-60010-000 Communications/Mobiles 7,500.00 7,500.00 1,106.01 3,194.16 4,305.84 57.41 % 135-020-60020-000 Electricity 242,978.33 242,978.33 22,068.47 220,316.40 22,661.93 9.33 % 135-020-60035-000 Postage 0.00 0.00 87.00 87.00 -87.00 0.00 % 135-020-60080-000 Schools & Training 2,119.00 2,119.00 0.00 727.50 1,391.50 65.67 % 135-020-60100-000 Travel & per diem 527.50 527.50 0.00 0.00 527.50 100.00 % 135-020-60135-000 TCEQ Fees & Permits 12,000.00 12,000.00 0.00 9,888.02 2,111.98 17.60 % 135-020-60285-000 Lawn Equipment & Maintenance 16,000.00 16,000.00 1,540.00 13,040.00 2,960.00 18.50 % 135-020-60331-000 Interfund Transfer Out -Tax l&S 115,885.76 115,885.76 10,535.09 115,885.99 -0.23 0.00 % 135-020-60332-000 Interfund Transfer Out -Rev I&S 698,542.63 698,542.63 63,548.65 699,035.15 -492.52 -0.07 % 135-020-60334-000 Interfund Transfer Out 0.00 0.00 0.00 96,630.00 -96,630.00 0.00 % 135-020-65005-000 Fuel & Lube 13,000.00 13,000.00 534.43 9,808.39 3,191.61 24.55 % 135-020-65010-000 Uniforms 3,520.00 3,520.00 0.00 1,731.53 1,788.47 50.81 % 135-020-65030-000 Chemicals 32,500.00 32,500.00 4,046.85 25,347.16 7,152.84 22.01 % 135-020-65031-000 Chemicals Collections 10,000.00 10,000.00 0.00 5,709.00 4,291.00 42.91 % 135-020-65045-000 Lab Supplies 33,000.00 33,000.00 0.00 26,116.94 6,883.06 20.86 % 135-020-69005-000 Capital Outlays 1,050,000.00 1,050,000.00 89,155.45 1,250,863.34 -200,863.34 -19.13 % 9/10/2024 12:15:09 PM Page 2 of 6 Budget Report For Fiscal: 2023-2024 Period Ending: 08/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-020-69008-000 Short Term Debt -Principal 22,398.34 22,398.34 0.00 22,132.30 266.04 1.19 % 135-020-69009-000 Short Term Debt -Interest 442.39 ' 442.39 0.00 425.07 17.32 3.92 % 135-020-69195-000 GASB Reserve for Replacement 155,762.00 155,762.00 0.00 155,762.00 0.00 0.00 % Department: 020 - Wastewater Total: 3,506,323.94 3,506,323.94 253,374.97 3,490,458.30 15,865.64 0.45% Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 15.00 . 15.00 0.66 7.26 7.74 51.60 % 135-026-60070-000 Dues & Memberships 750.00 750.00 0.00 750.00 0.00 0.00 % 135-026-60075-000 Meetings 1,500.00 1,500.00 0.00 1,043.91 456.09 30.41 % 135-026-60080-000 Schools & Training 4,000.00 4,000.00 90.00 90.00 3,910.00 97.75 % 135-026-60100-000 Travel & per diem 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % 135-026-60245-000 Miscellaneous Expenses 500.00 500.00 0.00 0.00 500.00 100.00 % Department: 026 - Board of Directors Total: 11,765.00 11,765.00 90.66 1,891.17 9,873.83 83.93% Department: 030 - Administration 135-030-50005-000 Salaries & Wages 663,185.25 663,185.25 73,615.63 608,095.12 55,090.13 8.31 % 135-030-50010-000 Overtime 2,000.00 2,000.00 0.00 1,620.34 379.66 18.98 % 135-030-50016-000 Longevity 2,532.50 2,532.50 0.00 2,597.50 -65.00 -2.57 % 135-030-50020-000 Retirement 82,631.07 82,631.07 8,994.45 74,629.05 8,002.02 9.68 % 135-030-50026-000 Medical Insurance 108,759.00 108,759.00 7,075.25 71,425.16 37,333.84 34.33 % 135-030-50027-000 Dental Insurance 3,816.74 3,816.74 253.55 2,715.96 1,100.78 28.84 % 135-030-50028-000 Vision Insurance 886.17 886.17 55.36 600.07 286.10 32.29 % 135-030-50029-000 Life Insurance & Other 4,800.00 4,800.00 822.30 4,640.99 159.01 3.31 % 135-030-50030-000 Social Security Taxes 41,398.50 41,398.50 4,455.83 36,180.57 5,217.93 12.60 % 135-030-50035-000 Medicare Taxes 9,681.91 9,681.91 1,042.08 8,577.95 1,103.96 11.40 % 135-030-50040-000 Unemployment Taxes 1,512.00 1,512.00 78.82 936.01 575.99 38.09 % 135-030-50045-000 Workman's Compensation 1,597.19 1,597.19 139.51 1,179.61 417.58 26.14 % 135-030-50060-000 Pre-emp Physicals/Testing 500.00 500.00 104.95 353.40 146.60 29.32 % 135-030-50070-000 Employee Relations 4,000.00 4,000.00 0.00 3,111.83 888.17 22.20 % 135-030-55030-000 Software & Support 130,311.00 130,311.00 9,671.56 145,596.72 -15,285.72 -11.73 % 135-030-55080-000 Maintenance & Repairs 23,000.00 23,000.00 7,249.00 25,280.71 -2,280.71 -9.92 % 135-030-55085-000 Generator Maint. and Repair 1,000.00 1,000.00 0.00 1,348.04 -348.04 -34.80 % 135-030-55100-000 Building Maint & Supplies 0.00 0.00 305.00 305.00 -305.00 0.00 % 135-030-55120-000 Cleaning Services 13,825.00 13,825.00 3,200.00 16,454.70 -2,629.70 -19.02 % 135-030-55160-000 Professional Outside Services 100,000.00 100,000.00 11,507.21 100,626.72 -626.72 -0.63 % 135-030-55205-000 Utility Billing Contract 9,000.00 9,000.00 632.40 6,388.63 2,611.37 29.02 % 135-030-60005-000 Telephone 6,000.00 6,000.00 0.00 4,250.44 1,749.56 29.16 % 135-030-60010-000 Communications/Mobiles 3,000.00 3,000.00 96.54 482.59 2,517.41 83.91 % 135-030-60020-000 Electricity/Gas 17,684.51 17,684.51 1,704.98 15,942.96 1,741.55 9.85 % 135-030-60025-000 Water 5,000.00 5,000.00 0.00 2,226.42 2,773.58 55.47 % 135-030-60035-000 Postage 30,000.00 30,000.00 2,161.69 22,492.61 7,507.39 25.02 % 135-030-60040-000 Service Charges & Fees 140,000.00 140,000.00 9,187.49 154,098.73 -14,098.73 -10.07 % 135-030-60050-000 Bad Debt Expense 13,000.00 13,000.00 0.00 0.00 13,000.00 100.00 % 135-030-60055-000 Insurance 116,158.22 116,158.22 9,618.44 105,802.84 10,355.38 8.91 % 135-030-60070-000 Dues & Memberships 6,800.00 6,800.00 0.00 2,016.00 4,784.00 70.35 % 135-030-60080-000 Schools & Training 3,900.00 3,900.00 0.00 1,313.10 2,586.90 66.33 % 135-030-60100-000 Travel & per diem 1,227.50 1,227.50 0.00 0.00 1,227.50 100.00 % 135-030-60115-000 Elections 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % 135-030-60245-000 Miscellaneous Expenses 0.00 0.00 0.00 1,854.76 -1,854.76 0.00 % 135-030-60285-000 Lawn Equipment & Maintenance 5,000.00 5,000.00 649.67 5,526.37 -526.37 -10.53 % 135-030-60360-000 Furniture/Equipment < $5000 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % 135-030-65010-000 Uniforms 530.00 530.00 0.00 0.00 530.00 100.00 % 135-030-65055-000 Hardware 8,200.00 8,200.00 5,136.64 9,698.88 -1,498.88 -18.28 % 135-030-65085-000 Office Supplies 5,000.00 5,000.00 79.78 2,938.60 2,061.40 41.23 % 135-030-65095-000 Maintenance Supplies 5,000.00 5,000.00 0.00 5,467.97 -467.97 -9.36 % 135-030-69170-000 Copier Lease Installments 4,000.00 4,000.00 618.62 3,087.10 912.90 22.82 % 135-030-69195-000 GASB Reserve for Replacement 24,903.00 24,903.00 0.00 24,903.00 0.00 0.00 % Department: 030 - Administration Total: 1,612,839.56 1,612,839.56 158,456.75 1,474,766.45 138,073.11 8.56% 9/10/2024 12:15:09 PM Page 3 of 6 Budget Report For Fiscal: 2023-2024 Period Ending: 08/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Department: 039 - Non Departmental 135-039-55045-000 Legal 65,000.00 65,000.00 3,594.50 33,140.20 31,859.80 49.02 135-039-55055-000 Auditing 30,000.00 30,000.00 0.00 21,784.29 8,215.71 27.39 135-039-55060-000 Appraisal 13,071.00 13,071.00 0.00 8,046.27 5,024.73 38.44 135-039-55065-000 Tax Admin Fees 5,000.00 5,000.00 0.00 3,941.00 1,059.00 21.18 Department: 039 - Non Departmental Total: 113,071.00 113,071.00 3,594.50 66,911.76 46,159.24 40.82% Expense Total: 14,423,932.76 14,423,932.76 1,922,080.21 12,458,351.71 1,965,581.05 13.63% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 -430,024.38 -742,371.88 -742,371.88 0.00% Report Surplus (Deficit): 0.00 0.00 -430,024.38 -742,371.88 -742,371.88 0.00% 9/10/2024 12:15:09 PM Page 4 of 6 Budget Report For Fiscal: 2023-2024 Period Ending: 08/31/2024 Group Summary Department Fund: 135 - MUD 1 General Fund Revenue 000 - Revenue, Asset, Liability, & Equity Expense 010 - Water 020 - Wastewater 026 - Board of Directors 030 - Administration 039 - Non Departmental Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 14,423,932.76 14,423,932.76 1,492,055.83 11,715,979.83 -2,707,952.93 18.77% Revenue Total: 14,423,932.76 14,423,932.76 1,492,055.83 11,715,979.83 -2,707,952.93 18.77% 9,179,933.26 9,179,933.26 1,506,563.33 7,424,324.03 1,755,609.23 19.12% 3,506,323.94 3,506,323.94 253,374.97 3,490,458.30 15,865.64 0.45% 11,765.00 11,765.00 90.66 1,891.17 9,873.83 83.93% 1,612,839.56 1,612,839.56 158,456.75 1,474,766.45 138,073.11 8.56% 113,071.00 113,071.00 3,594.50 66,911.76 46,159.24 40.82% Expense Total: 14,423,932.76 14,423,932.76 1,922,080.21 12,458,351.71 1,965,581.05 13.63% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 -430,024.38 -742,371.88 -742,371.88 0.00% Report Surplus (Deficit): 0.00 0.00 -430,024.38 -742,371.88 -742,371.88 0.00% 9/10/2024 12:15:09 PM Page 5 of 6 Budget Report For Fiscal: 2023-2024 Period Ending: 08/31/2024 Fund Summary Fund 135 - MUD 1 General Fund Report Surplus (Deficit): Variance Original Current Period Fiscal Favorable Total Budget Total Budget Activity Activity (Unfavorable) 0.00 0.00 -430,024.38 -742,371.88 -742,371.88 0.00 0.00 -430,024.38 -742,371.88 -742,371.88 9/10/2024 12:15:09 PM Page 6 of 6 CASH STATUS AS OF AUGUST 2024 TexPool O & M (XXXXX0002)-Fire Operating Cash Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) 135-10250 TexPool 0 & M (XXXXX0002) General Fund Operating Prosperity Bank (XXXXX2660) Fire Operating $0 $2,378,917 $2,378,917 135-10300 Prosperity Bank (XXXXX2660) General Fund Operating * $150,355 $4,244,934 $4,395,289 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,993,668 $0 $1,993,668 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement $4,916,433 $0 $4,916,433 519-10300 Prosperity Bank (XXXXX2660) SWIFT $85,052 $0 $85,052 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) $848,572 $0 $848,572 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 $989,636 $0 $989,636 533-10250 TexPool Tax I & S (XXXXX0003) $101,195 $0 $101,195 533-10300 Prosperity Bank (XXXXX2660) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $52,732 $0 $52,732 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $18,072 $0 $18,072 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $12,836 $0 $12,836 $6,624,451 $15,793,001 Amount available in cash for spending (MUD Accounts) *8/31/2024 Customer Water Deposits $150,355 Fire Department Cash $6,624,451 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $675,863 $675,863 122-10300 Prosperity Bank (XXXXX2660) Fire Operating $0 $55,363 $55,363 $0 $731,226 $731,226 Amount available in cash for spending (Fire Department Accounts) $731,226 General Fund 135 Available $ 4,244,934 Prosperity General Fund $ 2,378,917 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 6,624,451 General Fund 135 Fund Balances 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 $ (742,372) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $9,963,111