Loading...
HomeMy WebLinkAbout2024-04 April Combined FinancialsNI TROPHY CLUB MUNICIPAL UTILITY DISTRICT Trophy Club Municipal Utility District No. 1 Check Report By Check Number Date Range: 04/01/2024 - 04/30/2024 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: Prosperity Bank -Prosperity Bank 3298 308 Construction LLC 04/08/2024 Regular 0.00 29,185.17 10304 3045 3RD Eye Surveillance LLC 04/08/2024 Regular 0.00 349.00 10305 3127 Allied Welding Supply Inc. 04/08/2024 Regular 0.00 27.12 10306 1005 Atlas Utility Supply Co. 04/08/2024 Regular 0.00 47,150.00 10307 4018 BP Energy Holding Company LLC 04/08/2024 Regular 0.00 37,196.26 10308 1030 City of Fort Worth 04/08/2024 Regular 0.00 4,953.00 10309 2655 Core & Main LP 04/08/2024 Regular 0.00 1,382.20 10310 3184 Dataprose LLC 04/08/2024 Regular 0.00 4,889.05 10311 2804 Fortiline Inc. 04/08/2024 Regular 0.00 6,102.00 10312 2788 G -Force Parking Lot Striping 04/08/2024 Regular 0.00 1,966.50 10313 4004 lnsituform Technologies LLC 04/08/2024 Regular 0.00 70,995.00 10314 2808 J&J Ramirez Tree Trimmers LLC 04/08/2024 Regular 0.00 2,000.00 10315 2943 JP Morgan Chase Bank NA 04/08/2024 Regular 0.00 8,906.89 10316 3179 NewGen Strategies & Solutions 04/08/2024 Regular 0.00 2,445.00 10317 2801 Pipeline Analysis LLC 04/08/2024 Regular 0.00 13,827.00 10318 3176 Rey -Mar Construction 04/08/2024 Regular 0.00 38,380.00 10319 3156 Southern Petroleum Lab Inc 04/08/2024 Regular 0.00 338.40 10320 3182 Strategic Government Resources 04/08/2024 Regular 0.00 1,034.89 10321 2440 Tarrant County Public Health Laboratory 04/08/2024 Regular 0.00 300.00 10322 2696 Texas Excavation Safety System 04/08/2024 Regular 0.00 318.55 10323 1000 Trophy Club Mud (Water Bills) 04/08/2024 Regular 0.00 144.10 10324 2798 Tyler Technologies Inc 04/08/2024 Regular 0.00 11,657.35 10325 3280 Watts Ellison LLC 04/08/2024 Regular 0.00 3,979.67 10326 2691 All Test Fire Protection LLC 04/24/2024 Regular 0.00 961.60 10327 3299 Bickerstaff Heath Delgado Acosta LLP 04/24/2024 Regular 0.00 1,897.50 10328 4018 BP Energy Holding Company LLC 04/24/2024 Regular 0.00 33,069.06 10329 2683 Charter Communications 04/24/2024 Regular 0.00 903.74 10330 3187 CLS Sewer Equipment Co.lnc 04/24/2024 Regular 0.00 593.33 10331 2606 Fisery Solutions LLC 04/24/2024 Regular 0.00 50.00 10332 2796 Garver 04/24/2024 Regular 0.00 5,007.00 10333 2635 Halff Associates Inc. 04/24/2024 Regular 0.00 7,674.85 10334 3278 Kyocera Document Solutions 04/24/2024 Regular 0.00 108.29 10335 2760 NDS Leasing 04/24/2024 Regular 0.00 175.00 10336 4019 Peterson Pump & Motor Service LLC 04/24/2024 Regular 0.00 1,760.00 10337 2440 Tarrant County Public Health Laboratory 04/24/2024 Regular 0.00 210.00 10338 1001 Town of Trophy Club 04/24/2024 Regular 0.00 136,746.38 10339 1081 Tri County Electric 04/24/2024 Regular 0.00 739.22 10340 1058 Verizon Wireless 04/24/2024 Regular 0.00 583.68 10341 2970 Air Mac 04/24/2024 Regular 0.00 11,364.34 10342 2772 Allied Waste Industries 04/24/2024 Regular 0.00 9,306.80 10343 1005 Atlas Utility Supply Co. 04/24/2024 Regular 0.00 35,500.00 10344 1030 City of Fort Worth 04/24/2024 Regular 0.00 158,127.35 10345 2655 Core & Main LP 04/24/2024 Regular 0.00 3,682.23 10346 2800 Ferguson Enterprises LLC 04/24/2024 Regular 0.00 371.45 10347 2796 Garver 04/24/2024 Regular 0.00 15,774.20 10348 3132 Legal Shield 04/24/2024 Regular 0.00 15.95 10349 2784 Manning Concrete Sawing 04/24/2024 Regular 0.00 3,717.00 10350 1737 PVS DX INC 04/24/2024 Regular 0.00 778.54 10351 3176 Rey -Mar Construction 04/24/2024 Regular 0.00 27,215.30 10352 1578 Smith Pump Company, Inc. 04/24/2024 Regular 0.00 8,247.80 10353 3156 Southern Petroleum Lab Inc 04/24/2024 Regular 0.00 2,176.80 10354 1001 Town of Trophy Club 04/24/2024 Regular 0.00 99,620.00 10355 3197 BenefitMall 04/12/2024 Bank Draft 0.00 373.33 DFT0000149 3113 TCDRS 04/30/2024 Bank Draft 0.00 9,843.77 DFT0000150 5/14/2024 11:30:22 AM Page 1 of 3 Check Report Date Range: 04/01/2024 - 04/30/2024 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 3124 IRS Tax Payment 04/12/2024 Bank Draft 0.00 13,259.70 DFT0000151 3294 Texas Workforce Commission 04/12/2024 Bank Draft 0.00 1,638.00 DFT0000152 3197 BenefitMall 04/26/2024 Bank Draft 0.00 373.33 DFT0000153 3113 TCDRS 04/30/2024 Bank Draft 0.00 14,901.43 DFT0000154 3124 IRS Tax Payment 04/26/2024 Bank Draft 0.00 25,515.67 DFT0000155 Bank Code Prosperity Bank Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 75 52 0.00 853,904.56 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 7 7 0.00 65,905.23 EFT's 0 0 0.00 0.00 82 59 0.00 919,809.79 5/14/2024 11:30:22 AM Page 2 of 3 Check Report Date Range: 04/01/2024 - 04/30/2024 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 75 52 0.00 853,904.56 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 7 7 0.00 65,905.23 EFT's 0 0 0.00 0.00 82 59 0.00 919,809.79 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 4/2024 919,809.79 919,809.79 5/14/2024 11:30:22 AM Page 3 of 3 TROPHY CLUB 1 1 MUNICIPAL UTILITY DISTRICT Trophy Club Municipal Utility District No. 1 Budget Report Account Summary For Fiscal: 2023-2024 Period Ending: 04/30/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 662.91 84,008.32 -1,725.19 2.01 % 135-000-40002-000 Property Taxes/Delinquent 300.00 300.00 -69.97 63.98 -236.02 78.67 % 135-000-40015-000 Property Taxes/P & 1 300.00 300.00 47.11 243.74 -56.26 18.75 % 135-000-40025-000 PID Surcharges 143,223.25 143,223.25 0.00 0.00 -143,223.25 100.00 % 135-000-47000-000 Water 6,939,998.00 6,939,998.00 479,045.25 3,179,564.47 -3,760,433.53 54.18 % 135-000-47005-000 Sewer 3,679,786.00 3,679,786.00 300,031.54 2,051,901.39 -1,627,884.61 44.24 % 135-000-47025-000 Penalties 105,800.00 105,800.00 4,755.26 50,298.87 -55,501.13 52.46 % 135-000-47030-000 Service Charges 3,350.00 3,350.00 150.00 2,775.00 -575.00 17.16 % 135-000-47035-000 Plumbing Inspections 300.00 300.00 600.00 1,200.00 900.00 400.00 % 135-000-47045-000 Sewer Inspections 100.00 100.00 200.00 350.00 250.00 350.00 % 135-000-47070-000 TCCC Effluent Charges 70,000.00 70,000.00 0.00 14,977.60 -55,022.40 78.60 % 135-000-49011-000 Interest Income 150,000.00 150,000.00 45,338.70 303,940.31 153,940.31 202.63 % 135-000-49016-000 Cell Tower Revenue 49,320.00 49,320.00 0.00 28,720.00 -20,600.00 41.77 % 135-000-49026-000 Proceeds from Sale of Assets 25,000.00 25,000.00 51,450.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 1,712.00 3,424.00 1,366.00 166.38 % 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 1,500.00 2,821.00 -4,179.00 59.70 % Department: 000 - Revenue, Asset, Liability, & Equity Total: 14,423,932.76 14,423,932.76 885,422.80 6,976,069.54 -7,447,863.22 51.64% Revenue Total: 14,423,932.76 14,423,932.76 885,422.80 6,976,069.54 -7,447,863.22 51.64% Expense Department: 010 - Water 135-010-50005-000 Salaries & Wages 431,575.02 431,575.02 33,743.25 244,896.99 186,678.03 43.26 % 135-010-50010-000 Overtime 17,000.00 17,000.00 323.59 6,259.22 10,740.78 63.18 % 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 225.00 1,575.00 2,025.00 56.25 % 135-010-50020-000 Retirement 56,730.41 56,730.41 4,115.03 32,055.19 24,675.22 43.50 % 135-010-50026-000 Medical Insurance 116,527.50 116,527.50 7,619.49 55,810.06 60,717.44 52.11 % 135-010-50027-000 Dental Insurance 4,834.55 4,834.55 367.85 2,522.39 2,312.16 47.83 % 135-010-50028-000 Vision Insurance 1,051.01 1,051.01 71.30 499.07 551.94 52.52 % 135-010-50029-000 Life Insurance & Other 4,000.00 4,000.00 286.69 2,010.83 1,989.17 49.73 % 135-010-50030-000 Social Security Taxes 28,422.51 28,422.51 2,076.52 15,642.15 12,780.36 44.97 % 135-010-50035-000 Medicare Taxes 6,647.20 6,647.20 485.63 3,658.21 2,988.99 44.97 % 135-010-50040-000 Unemployment Taxes 1,260.00 1,260.00 539.99 585.00 675.00 53.57 % 135-010-50045-000 Workman's Compensation 11,898.56 11,898.56 1,060.94 4,768.58 7,129.98 59.92 % 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 23,519.45 92,442.57 109,057.43 54.12 % 135-010-55085-000 Generator Maint. and Repair 2,000.00 2,000.00 12,518.33 13,469.93 -11,469.93 -573.50 % 135-010-55090-000 Vehicle Maintenance 5,000.00 5,000.00 0.00 2,000.10 2,999.90 60.00 % 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 714.00 3,387.00 4,113.00 54.84 % 135-010-55135-001 Lab Analysis for PID 2,000.00 2,000.00 744.00 2,102.00 -102.00 -5.10 % 135-010-60010-000 Communications/Mobiles 7,500.00 7,500.00 334.72 2,008.69 5,491.31 73.22 % 135-010-60020-000 Electricity 183,143.49 183,143.49 19,592.51 80,350.44 102,793.05 56.13 % 135-010-60066-000 Publications/Books/Subscripts 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 135-010-60080-000 Schools & Training 2,630.00 2,630.00 0.00 2,596.74 33.26 1.26 % 5/14/2024 11:32:39 AM Page 1 of 6 Budget Report For Fiscal: 2023-2024 Period Ending: 04/30/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 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 0.00 12,807.15 16,692.85 56.59 % 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 158,127.35 970,482.43 1,685,014.70 63.45 % 135-010-60285-000 Lawn Equipment & Maintenance 12,500.00 12,500.00 0.00 4,800.00 7,700.00 61.60 % 135-010-60332-000 Interfund Transfer Out -Rev I&S 565,796.88 565,796.88 0.00 309,003.12 256,793.76 45.39 % 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,541.98 9,702.57 13,872.43 58.84 % 135-010-65010-000 Uniforms 4,355.00 4,355.00 0.00 1,652.91 2,702.09 62.05 % 135-010-65030-000 Chemicals 58,200.00 58,200.00 4,460.77 24,454.59 33,745.41 57.98 % 135-010-65050-000 Meter Expense 20,000.00 20,000.00 0.00 0.00 20,000.00 100.00 % 135-010-65053-000 Meter Change Out Program 124,500.00 124,500.00 35,500.00 82,650.00 41,850.00 33.61 % 135-010-69005-000 Capital Outlays 4,200,000.00 4,200,000.00 314,307.00 1,373,220.39 2,826,779.61 67.30 % 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 622,275.39 4,665,793.17 4,514,140.09 49.17% Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 290,304.62 290,304.62 16,870.50 132,120.37 158,184.25 54.49 % 135-020-50010-000 Overtime 20,000.00 20,000.00 358.30 5,355.48 14,644.52 73.22 % 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 375.00 1,725.00 3,375.00 66.18 % 135-020-50020-000 Retirement 40,934.05 40,934.05 2,112.47 17,529.92 23,404.13 57.18 % 135-020-50026-000 Medical Insurance 93,222.04 93,222.04 4,354.00 30,926.44 62,295.60 66.82 % 135-020-50027-000 Dental Insurance 3,385.28 3,385.28 202.37 1,309.01 2,076.27 61.33 % 135-020-50028-000 Vision Insurance 818.82 818.82 42.52 297.64 521.18 63.65 % 135-020-50029-000 Life Insurance & Other 3,000.00 3,000.00 170.26 1,187.82 1,812.18 60.41 % 135-020-50030-000 Social Security Taxes 20,507.87 20,507.87 1,052.37 8,485.17 12,022.70 58.62 % 135-020-50035-000 Medicare Taxes 4,796.20 4,796.20 246.13 1,984.41 2,811.79 58.63 % 135-020-50040-000 Unemployment Taxes 1,008.00 1,008.00 324.00 350.98 657.02 65.18 % 135-020-50045-000 Workman's Compensation 8,403.61 8,403.61 748.93 3,119.51 5,284.10 62.88 % 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 27,594.34 108,982.46 28,017.54 20.45 % 135-020-55081-000 Mainten & Repairs Collections 270,000.00 270,000.00 24,815.80 243,972.42 26,027.58 9.64 % 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 593.33 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 17,899.46 61,906.71 38,093.29 38.09 % 135-020-55135-000 Lab Analysis 55,000.00 55,000.00 5,103.60 37,509.22 17,490.78 31.80 % 135-020-60010-000 Communications/Mobiles 7,500.00 7,500.00 200.71 1,686.77 5,813.23 77.51 % 135-020-60020-000 Electricity 242,978.33 242,978.33 39,301.91 129,426.82 113,551.51 46.73 % 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 0.00 8,240.00 7,760.00 48.50 % 135-020-60331-000 Interfund Transfer Out -Tax l&S 115,885.76 115,885.76 0.00 63,210.54 52,675.22 45.45 % 135-020-60332-000 Interfund Transfer Out -Rev l&S 698,542.63 698,542.63 0.00 381,291.90 317,250.73 45.42 % 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 522.50 8,174.77 4,825.23 37.12 % 135-020-65010-000 Uniforms 3,520.00 3,520.00 0.00 1,181.63 2,338.37 66.43 % 135-020-65030-000 Chemicals 32,500.00 32,500.00 0.00 16,029.05 16,470.95 50.68 % 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 789.66 25,620.22 7,379.78 22.36 % 135-020-69005-000 Capital Outlays 1,050,000.00 1,050,000.00 53,934.50 670,812.97 379,187.03 36.11 % 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 % 5/14/2024 11:32:39 AM Page 2 of 6 Budget Report For Fiscal: 2023-2024 Period Ending: 04/30/2024 Original Current Total Budget Total Budget Period Activity Fiscal Activity Variance Favorable Percent (Unfavorable) Remaining Department: 020 - Wastewater Total: 3,506,323.94 3,506,323.94 197,612.66 2,268,839.98 1,237,483.96 35.29% Department: 026 - Board of Directors 135-026-50045-000 135-026-60070-000 135-026-60075-000 135-026-60080-000 135-026-60100-000 135-026-60245-000 Department: 030 - 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-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-60080-000 135-030-60100-000 135-030-60115-000 135-030-60285-000 135-030-60360-000 135-030-65010-000 135-030-65055-000 135-030-65085-000 135-030-65095-000 135-030-69170-000 135-030-69195-000 Department: 039 - 135-039-55045-000 135-039-55055-000 135-039-55060-000 Workman's Compensation Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses Department: 026 - Board of Directors Total: Administration 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 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 Schools & Training Travel & per diem Elections Lawn Equipment & Maintenance Furniture/Equipment < $5000 Uniforms Hardware Office Supplies Maintenance Supplies Copier Lease Installments GASB Reserve for Replacement Department: 030 - Administration Total: Non Departmental Legal Auditing Appraisal 15.00 750.00 1,500.00 4,000.00 5,000.00 500.00 11,765.00 663,185.25 2,000.00 2,532.50 82,631.07 108,759.00 3,816.74 886.17 4,800.00 41,398.50 9,681.91 1,512.00 1,597.19 500.00 4,000.00 130,311.00 23,000.00 1,000.00 13,825.00 100,000.00 9,000.00 6,000.00 3,000.00 17,684.51 5,000.00 30,000.00 140,000.00 13,000.00 116,158.22 6,800.00 3,900.00 1,227.50 10,000.00 5,000.00 3,000.00 530.00 8,200.00 5,000.00 5,000.00 4,000.00 24,903.00 15.00 750.00 1,500.00 4,000.00 5,000.00 500.00 11,765.00 0.66 0.00 0.00 0.00 0.00 0.00 4.62 750.00 695.94 0.00 0.00 0.00 10.38 69.20 % 0.00 0.00 % 804.06 53.60 % 4,000.00 100.00 % 5,000.00 100.00 % 500.00 100.00 % 663,185.25 2,000.00 2,532.50 82,631.07 108,759.00 3,816.74 886.17 4,800.00 41,398.50 9,681.91 1,512.00 1,597.19 500.00 4,000.00 130,311.00 23,000.00 1,000.00 13,825.00 100,000.00 9,000.00 6,000.00 3,000.00 17,684.51 5,000.00 30,000.00 140,000.00 13,000.00 116,158.22 6,800.00 3,900.00 1,227.50 10,000.00 5,000.00 3,000.00 530.00 8,200.00 5,000.00 5,000.00 4,000.00 24,903.00 0.66 78,300.16 303.56 0.00 9,401.05 6,531.00 253.55 55.36 386.56 4,749.38 1,110.74 647.98 139.51 210.45 0.00 7,843.59 4,678.60 0.00 1,600.00 7,755.41 177.79 0.00 48.25 2,623.11 0.00 330.92 358.20 0.00 9,618.44 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 71.47 0.00 283.29 0.00 1,450.56 398,872.68 1,620.34 2,597.50 49,576.34 46,389.66 1,738.64 387.49 2,685.87 23,635.24 5,643.99 702.00 621.57 210.45 2,991.57 121,106.93 11,294.34 1,348.04 9,454.70 85,070.24 4,485.11 2,933.86 289.55 9,813.89 1,735.92 15,813.49 100,299.42 0.00 67,329.08 2,016.00 1,313.10 0.00 0.00 3,287.69 0.00 0.00 4,562.24 2,369.69 4,253.39 1,939.24 24,903.00 10,314.44 87.67% 264,312.57 39.86 % 379.66 18.98 % -65.00 -2.57 % 33,054.73 40.00 % 62,369.34 57.35 % 2,078.10 54.45 % 498.68 56.27 % 2,114.13 44.04 % 17,763.26 42.91 % 4,037.92 41.71 % 810.00 53.57 % 975.62 61.08 % 289.55 57.91 % 1,008.43 25.21 % 9,204.07 7.06 % 11,705.66 50.89 % -348.04 -34.80 % 4,370.30 31.61 % 14,929.76 14.93 % 4,514.89 50.17 % 3,066.14 51.10 % 2,710.45 90.35 % 7,870.62 44.51 % 3,264.08 65.28 % 14,186.51 47.29 % 39,700.58 28.36 % 13,000.00 100.00 % 48,829.14 42.04 % 4,784.00 70.35 % 2,586.90 66.33 % 1,227.50 100.00 % 10,000.00 100.00 % 1,712.31 34.25 % 3,000.00 100.00 % 530.00 100.00 % 3,637.76 44.36 % 2,630.31 52.61 % 746.61 14.93 % 2,060.76 51.52 % 0.00 0.00 % 1,612,839.56 1,612,839.56 65,000.00 30,000.00 13,071.00 65,000.00 30,000.00 13,071.00 137,478.37 1,013,292.26 599,547.30 37.17% 3,712.00 0.00 0.00 25,180.95 21,784.29 6,078.42 39,819.05 61.26 % 8,215.71 27.39 % 6,992.58 53.50 % 5/14/2024 11:32:39 AM Page 3 of 6 Budget Report For Fiscal: 2023-2024 Period Ending: 04/30/2024 135-039-55065-000 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 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,712.00 56,984.66 56,086.34 49.60% Expense Total: 14,423,932.76 14,423,932.76 961,079.08 8,006,360.63 6,417,572.13 44.49% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 -75,656.28 -1,030,291.09 -1,030,291.09 0.00% Report Surplus (Deficit): 0.00 0.00 -75,656.28 -1,030,291.09 -1,030,291.09 0.00% 5/14/2024 11:32:39 AM Page 4 of 6 Budget Report For Fiscal: 2023-2024 Period Ending: 04/30/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 885,422.80 6,976,069.54 -7,447,863.22 51.64% Revenue Total: 14,423,932.76 14,423,932.76 885,422.80 6,976,069.54 -7,447,863.22 51.64% 9,179,933.26 3,506,323.94 11,765.00 1,612,839.56 113,071.00 9,179,933.26 3,506,323.94 11,765.00 1,612,839.56 113,071.00 622,275.39 197,612.66 0.66 137,478.37 3,712.00 4,665,793.17 2,268,839.98 1,450.56 1,013,292.26 56,984.66 4,514,140.09 1,237,483.96 10,314.44 599,547.30 56,086.34 49.17% 35.29% 87.67% 37.17% 49.60% Expense Total: 14,423,932.76 14,423,932.76 961,079.08 8,006,360.63 6,417,572.13 44.49% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 -75,656.28 -1,030,291.09 -1,030,291.09 0.00% Report Surplus (Deficit): 0.00 0.00 -75,656.28 -1,030,291.09 -1,030,291.09 0.00% 5/14/2024 11:32:39 AM Page 5 of 6 Budget Report For Fiscal: 2023-2024 Period Ending: 04/30/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 0.00 0.00 -75,656.28 -1,030,291.09 -1,030,291.09 -75,656.28 -1,030,291.09 -1,030,291.09 5/14/2024 11:32:39 AM Page 6 of 6 ebills Bills Mailed Bank Draft Online Payments Late Notices Disconnects District Connections Town Connections April 2024 Utility Billing Report April 2023 May 2023 June 2023 July 2023 August 2023 September 2023 October 2023 November 2023 December 2023 January 2024 February 2024 March 2024 April 2024 1,767 1,794 1,766 1,750 1,744 1,742 1,745 1,740 1,737 1,736 1,734 1,744 1,741 3,743 3,734 3,755 3,749 3,747 3,747 3,737 3,739 3,742 3,726 3,729 3,737 3,747 590 588 589 585 578 572 569 562 567 568 565 565 562 2,998 2,754 3,134 3,101 2,957 3,086 3,072 3,006 3,133 3,023 3,036 3,246 2,992 289 290 327 327 268 344 255 298 342 249 298 299 245 8 9 9 13 7 7 13 4 5 4 8 7 3 3,394 3,394 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,394 3,394 1,443 1,443 1,443 1,443 1,443 1,443 1,444 1,444 1,446 1,446 1,447 1,447 1,450 April 2024 Permits Date of Permit Permit No. Customer Deposit Due to FW Water Oversize Meter Plumbing Inspections Sewer Inspections Fire Line Misc. Income Total 4/2/2024 2024-05 $ 100.00 $ 4,953.00 $ 428.00 $ 150.00 $ 50.00 $ - $ - $ 5,681.00 4/10/2024 2024-06 $ 100.00 $ 4,953.00 $ 428.00 $ 150.00 $ 50.00 $ 1,500.00 $ 7,181.00 4/15/2024 2024-07 $ 100.00 $ 4,953.00 $ 428.00 $ 150.00 $ 50.00 $ 5,681.00 4/24/2024 2024-08 $ 100.00 $ 4,953.00 $ 428.00 $ 150.00 $ 50.00 $ 5,681.00 Total $ 400.00 $ 19,812.00 $ 1,712.00 $ 600.00 $ 200.00 $ 1,500.00 $ - $ 24,224.00