Loading...
HomeMy WebLinkAbout2024-07 July Combined financialsNA TROPHY CLUB MUNICIPAL UTILITY DISTRICT Trophy Club Municipal Utility District No. 1 Vendor Number Vendor Name Bank Code: Prosperity Bank -Prosperity Bank Check Report By Check Number Date Range: 07/01/2024 - 07/31/2024 Payment Date Payment Type Discount Amount Payment Amount Number 4004 Insituform Technologies LLC 07/08/2024 Regular 0.00 62,922.50 10521 1737 PVS DX INC 07/08/2024 Regular 0.00 2,530.26 10522 3176 Rey -Mar Construction 07/08/2024 Regular 0.00 122,404.65 10523 3156 Southern Petroleum Lab Inc 07/08/2024 Regular 0.00 3,603.60 10524 1005 Atlas Utility Supply Co. 07/08/2024 Regular 0.00 19,740.00 10525 2655 Core & Main LP 07/08/2024 Regular 0.00 2,303.58 10526 2497 DHS Automation Inc 07/08/2024 Regular 0.00 8,280.08 10527 2804 Fortiline Inc. 07/08/2024 Regular 0.00 1,590.00 10528 2526 Scoop 07/08/2024 Regular 0.00 4,132.00 10529 1578 Smith Pump Company, Inc. 07/08/2024 Regular 0.00 10,848.00 10530 4005 Aurora Patricia Albrecht 07/08/2024 Regular 0.00 291.66 10531 1926 Badger Meter, Inc 07/08/2024 Regular 0.00 3,051.92 10532 4003 CW Janitorial Services 07/08/2024 Regular 0.00 1,600.00 10533 3184 Dataprose LLC 07/08/2024 Regular 0.00 2,628.90 10534 2804 Fortiline Inc. 07/08/2024 Regular 0.00 89.39 10535 4033 Health Care Service Corporation 07/08/2024 Regular 0.00 18,493.70 10536 2943 JP Morgan Chase Bank NA 07/08/2024 Regular 0.00 8,003.00 10537 3278 Kyocera Document Solutions 07/08/2024 Regular 0.00 88.00 10538 2784 Manning Concrete Sawing 07/08/2024 Regular 0.00 2,032.90 10539 2760 NDS Leasing 07/08/2024 Regular 0.00 183.75 10540 3134 Prime Controls LP 07/08/2024 Regular 0.00 1,406.00 10541 2526 Scoop 07/08/2024 Regular 0.00 95.45 10542 3182 Strategic Government Resources 07/08/2024 Regular 0.00 382.50 10543 2440 Tarrant County Public Health Laboratory 07/08/2024 Regular 0.00 800.00 10544 2696 Texas Excavation Safety System 07/08/2024 Regular 0.00 416.30 10545 1001 Town of Trophy Club 07/08/2024 Regular 0.00 231,268.23 10546 1000 Trophy Club Mud (Water Bills) 07/08/2024 Regular 0.00 490.50 10547 3225 US Bank Voyager Fleet Systems 07/08/2024 Regular 0.00 2,257.80 10548 **Void** 07/23/2024 Regular 0.00 0.00 10550 **Void** 07/23/2024 Regular 0.00 0.00 10551 **Void** 07/23/2024 Regular 0.00 0.00 10552 **Void** 07/23/2024 Regular 0.00 0.00 10553 **Void** 07/23/2024 Regular 0.00 0.00 10554 **Void** 07/23/2024 Regular 0.00 0.00 10555 **Void** 07/23/2024 Regular 0.00 0.00 10556 **Void** 07/23/2024 Regular 0.00 0.00 10557 **Void** 07/23/2024 Regular 0.00 0.00 10558 **Void** 07/23/2024 Regular 0.00 0.00 10559 **Void** 07/23/2024 Regular 0.00 0.00 10560 2222 Aflac 07/23/2024 Regular 0.00 365.13 10561 1499 Aldinger Company 07/23/2024 Regular 0.00 293.00 10562 1030 City of Fort Worth 07/23/2024 Regular 0.00 34,671.00 10563 2804 Fortiline Inc. 07/23/2024 Regular 0.00 170.00 10564 2759 Hardys Painting 07/23/2024 Regular 0.00 1,609.00 10565 3076 HD Supply Facilities Maint LTD 07/23/2024 Regular 0.00 53.12 10566 3115 Metlife Group Benefits 07/23/2024 Regular 0.00 2,157.05 10567 3134 Prime Controls LP 07/23/2024 Regular 0.00 8,451.00 10568 1081 Tri County Electric 07/23/2024 Regular 0.00 682.57 10569 2798 Tyler Technologies Inc 07/23/2024 Regular 0.00 11,703.05 10570 3280 Watts Ellison LLC 07/23/2024 Regular 0.00 3,089.67 10571 2222 Aflac 07/23/2024 Regular 0.00 443.86 10572 3132 Legal Shield 07/23/2024 Regular 0.00 15.95 10573 2655 Core & Main LP 07/23/2024 Regular 0.00 9,850.00 10574 2797 Global Pump Solutions 07/23/2024 Regular 0.00 14,216.00 10575 8/12/2024 9:43:58 AM Page 1 of 3 Check Report Vendor Number 4004 1051 3156 4018 Vendor Name Insituform Technologies LLC Millican Well Service LLC Southern Petroleum Lab Inc BP Energy Holding Company LLC Payment Type Regular Checks Manual Checks Voided Checks Bank Drafts EFT's Payment Date Payment Type 07/23/2024 Regular 07/23/2024 Regular 07/23/2024 Regular 07/23/2024 Regular Bank Code Prosperity Bank Summary Payable Count 75 0 0 0 0 75 Payment Count 47 0 11 0 0 58 Date Range: 07/01/2024 - 07/31/2024 Discount Amount 0.00 0.00 0.00 0.00 Discount Payment 0.00 962,478.32 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 962,478.32 Payment Amount 199,034.00 126,434.33 2,176.80 35,128.12 Number 10576 10577 10578 10579 8/12/2024 9:43:58 AM Page 2 of 3 Check Report Date Range: 07/01/2024 - 07/31/2024 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 75 47 0.00 962,478.32 Manual Checks 0 0 0.00 0.00 Voided Checks 0 11 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 0 0 0.00 0.00 75 58 0.00 962,478.32 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 7/2024 962,478.32 962,478.32 8/12/2024 9:43:58 AM Page 3 of 3 $10,218, $10,536,71 • 135 YTD Revenues • 135 YTD Expenses Adopted Revenues Adopted Expenses FY 2024 Combined Financials YTD as of 7/31/2024 Adopted Budget vs YTD Actuals Revenues & Expenses 453 0 $14,423,933 $14,423,933 $1,801 $63,317 0% $3,236,884 31% $1,316,947 12% biL Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 92,198,177 61,555,000 60,000,000 40,000,000 51,503,997 20,000,000 Water Consumption Budget vs Actual 112,006,200 0 48,355,000 46,670,584 59,737,002 44,722,000 82,105,000 42,063,017 37,451,315 65,644,597 41,156,060 35,861,000 36,716,000 --Budget Consumption —A—Actual Consumption ik 134,554,000 93,656,387 7,226,660 Oct Nov Dec Jan Feb Mar Apr May Jun Jul 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 884, 572,143 • Budgeted Water Consumption • Projected Water Consumption 1% 56% YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD • YTD Expense- Non Dept s1,000,000 $900,000 $800,000 3676,430 $700,000 $600,00664,453 8493,96 $500,0005 $400,000 $433,720 $410,580 $300,000 $200,000 5100,000 Water Revenue Budget vs Actual $957,412-------� $606,103 5952, 5413,727 8401,119 5345,689 3369,594 $479,045 $450,062 50 Oct $237,590 $340,780 —0—Budget Revenue 0404,800 $382,397 —*-Actual Revenue 90,412 565,055 Nov Dec Jan Feb Mar Apr May Jun Jul $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue $6,939,988 $7,350,701 $4,284,491 Total Water Consumption Total Water Revenue $4,820,244 • 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: 07/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 135 - MUD 1 General Fund Revenue 135-000-40000-000 Property Taxes 85,733.51 85,733.51 0.00 84,487.92 -1,245.59 1.45 % 135-000-40002-000 Property Taxes/Delinquent 300.00 300.00 0.00 -951.20 -1,251.20 417.07 % 135-000-40015-000 Property Taxes/P & I 300.00 300.00 0.00 314.49 14.49 104.83 % 135-000-40025-000 PID Surcharges 143,223.25 143,223.25 12,082.57 120,858.83 -22,364.42 15.62 % 135-000-47000-000 Water 6,939,998.00 6,939,998.00 957,411.64 5,193,140.51 -1,746,857.49 25.17 % 135-000-47005-000 Sewer 3,679,786.00 3,679,786.00 302,482.12 2,947,449.88 -732,336.12 19.90 % 135-000-47025-000 Penalties 105,800.00 105,800.00 5,902.69 70,389.23 -35,410.77 33.47 % 135-000-47030-000 Service Charges 3,350.00 3,350.00 50.00 3,250.00 -100.00 2.99 % 135-000-47035-000 Plumbing Inspections 300.00 300.00 450.00 2,100.00 1,800.00 700.00 % 135-000-47045-000 Sewer Inspections 100.00 100.00 150.00 650.00 550.00 650.00 % 135-000-47070-000 TCCC Effluent Charges 70,000.00 70,000.00 22,700.00 46,456.80 -23,543.20 33.63 % 135-000-49011-000 Interest Income 150,000.00 150,000.00 39,112.69 434,224.00 284,224.00 289.48 % 135-000-49016-000 Cell Tower Revenue 49,320.00 49,320.00 4,120.00 49,320.00 0.00 0.00 % 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 1,284.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 4,500.00 8,989.73 1,989.73 128.42 % Revenue Total: 14,423,932.76 14,423,932.76 1,350,245.71 10,218,453.05 -4,205,479.71 29.16% Expense 135-010-50005-000 Salaries & Wages 431,575.02 431,575.02 33,875.18 346,241.89 85,333.13 19.77 % 135-010-50010-000 Overtime 17,000.00 17,000.00 562.40 8,992.21 8,007.79 47.10 % 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 450.00 2,250.00 1,350.00 37.50 % 135-010-50020-000 Retirement 56,730.41 56,730.41 4,186.52 44,625.56 12,104.85 21.34 % 135-010-50026-000 Medical Insurance 116,527.50 116,527.50 7,619.49 78,668.53 37,858.97 32.49 % 135-010-50027-000 Dental Insurance 4,834.55 4,834.55 367.85 3,625.94 1,208.61 25.00 % 135-010-50028-000 Vision Insurance 1,051.01 1,051.01 71.30 712.97 338.04 32.16 % 135-010-50029-000 Life Insurance & Other 4,000.00 4,000.00 286.69 2,883.90 1,116.10 27.90 % 135-010-50030-000 Social Security Taxes 28,422.51 28,422.51 2,091.88 21,919.91 6,502.60 22.88 % 135-010-50035-000 Medicare Taxes 6,647.20 6,647.20 489.22 5,126.38 1,520.82 22.88 % 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 7,951.40 3,947.16 33.17 % 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 29,450.18 136,056.22 65,443.78 32.48 % 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 1,548.40 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 590.00 4,427.00 3,073.00 40.97 % 135-010-55135-001 Lab Analysis for PID 2,000.00 2,000.00 210.00 2,432.00 -432.00 -21.60 % 135-010-60010-000 Communications/Mobiles 7,500.00 7,500.00 0.00 2,678.17 4,821.83 64.29 % 135-010-60020-000 Electricity 183,143.49 183,143.49 24,861.54 113,640.18 69,503.31 37.95 % 135-010-60035-000 Postage 0.00 0.00 95.45 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 % 135-010-60080-000 Schools & Training 2,630.00 2,630.00 125.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 0.00 15,134.15 14,365.85 48.70 % 8/12/2024 9:32:19 AM Page 1 of 5 Budget Report For Fiscal: 2023-2024 Period Ending: 07/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 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 0.00 1,323,789.01 1,331,708.12 50.15 % 135-010-60285-000 Lawn Equipment & Maintenance 12,500.00 12,500.00 900.00 6,900.00 5,600.00 44.80 % 135-010-60332-000 Interfund Transfer Out -Rev I&S 565,796.88 565,796.88 51,500.52 515,005.20 50,791.68 8.98 % 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,779.13 13,910.29 9,664.71 41.00 % 135-010-65010-000 Uniforms 4,355.00 4,355.00 138.55 1,991.46 2,363.54 54.27 % 135-010-65030-000 Chemicals 58,200.00 58,200.00 4,833.84 30,650.88 27,549.12 47.34 % 135-010-65050-000 Meter Expense 20,000.00 20,000.00 19,740.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 149.00 149.00 -149.00 0.00 % 135-010-69005-000 Capital Outlays 4,200,000.00 4,200,000.00 250,658.33 1,794,819.95 2,405,180.05 57.27 % 135-010-69195-000 GASB Reserve for Replacement 378,659.00 378,659.00 0.00 378,659.00 0.00 0.00 % 135-020-50005-000 Salaries & Wages 290,304.62 290,304.62 11,066.66 170,843.59 119,461.03 41.15 % 135-020-50010-000 Overtime 20,000.00 20,000.00 1,739.07 8,564.83 11,435.17 57.18 % 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 400.00 2,500.00 2,600.00 50.98 % 135-020-50020-000 Retirement 40,934.05 40,934.05 1,584.69 22,654.84 18,279.21 44.66 % 135-020-50026-000 Medical Insurance 93,222.04 93,222.04 3,265.50 41,811.44 51,410.60 55.15 % 135-020-50027-000 Dental Insurance 3,385.28 3,385.28 119.63 1,750.64 1,634.64 48.29 % 135-020-50028-000 Vision Insurance 818.82 818.82 25.69 391.54 427.28 52.18 % 135-020-50029-000 Life Insurance & Other 3,000.00 3,000.00 170.26 1,715.60 1,284.40 42.81 % 135-020-50030-000 Social Security Taxes 20,507.87 20,507.87 787.48 11,014.18 9,493.69 46.29 % 135-020-50035-000 Medicare Taxes 4,796.20 4,796.20 184.17 2,575.89 2,220.31 46.29 % 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 5,366.30 3,037.31 36.14 % 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 11,564.50 124,992.31 12,007.69 8.76 % 135-020-55081-000 Mainten & Repairs Collections 270,000.00 270,000.00 982.50 246,918.83 23,081.17 8.55 % 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 0.00 68,163.17 31,836.83 31.84 % 135-020-55135-000 Lab Analysis 55,000.00 55,000.00 5,780.40 48,063.22 6,936.78 12.61 % 135-020-60010-000 Communications/Mobiles 7,500.00 7,500.00 0.00 2,088.15 5,411.85 72.16 % 135-020-60020-000 Electricity 242,978.33 242,978.33 46,341.14 198,247.93 44,730.40 18.41 % 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 11,500.00 4,500.00 28.13 % 135-020-60331-000 Interfund Transfer Out -Tax l&S 115,885.76 115,885.76 10,535.09 105,350.90 10,534.86 9.09 % 135-020-60332-000 Interfund Transfer Out -Rev I&S 698,542.63 698,542.63 63,548.65 635,486.50 63,056.13 9.03 % 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 478.67 9,273.96 3,726.04 28.66 % 135-020-65010-000 Uniforms 3,520.00 3,520.00 149.90 1,731.53 1,788.47 50.81 % 135-020-65030-000 Chemicals 32,500.00 32,500.00 0.00 21,300.31 11,199.69 34.46 % 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 53.12 26,116.94 6,883.06 20.86 % 135-020-69005-000 Capital Outlays 1,050,000.00 1,050,000.00 282,804.15 1,161,707.89 -111,707.89 -10.64 % 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 % 135-026-50045-000 Workman's Compensation 15.00 15.00 0.66 6.60 8.40 56.00 % 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 115.99 1,043.91 456.09 30.41 % 8/12/2024 9:32:19 AM Page 2 of 5 Budget Report For Fiscal: 2023-2024 Period Ending: 07/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-026-60080-000 Schools & Training 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00 % 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 % 135-030-50005-000 Salaries & Wages 663,185.25 663,185.25 46,189.75 534,479.49 128,705.76 19.41 % 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 5,524.77 65,634.60 16,996.47 20.57 % 135-030-50026-000 Medical Insurance 108,759.00 108,759.00 5,986.75 64,349.91 44,409.09 40.83 % 135-030-50027-000 Dental Insurance 3,816.74 3,816.74 235.11 2,443.96 1,372.78 35.97 % 135-030-50028-000 Vision Insurance 886.17 886.17 50.93 540.28 345.89 39.03 % 135-030-50029-000 Life Insurance & Other 4,800.00 4,800.00 293.50 3,818.69 981.31 20.44 % 135-030-50030-000 Social Security Taxes 41,398.50 41,398.50 2,755.43 31,724.74 9,673.76 23.37 % 135-030-50035-000 Medicare Taxes 9,681.91 9,681.91 644.41 7,535.87 2,146.04 22.17 % 135-030-50040-000 Unemployment Taxes 1,512.00 1,512.00 38.19 857.19 654.81 43.31 % 135-030-50045-000 Workman's Compensation 1,597.19 1,597.19 139.51 1,040.10 557.09 34.88 % 135-030-50060-000 Pre-emp Physicals/Testing 500.00 500.00 0.00 248.45 251.55 50.31 % 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 3,575.08 135,925.16 -5,614.16 -4.31 % 135-030-55080-000 Maintenance & Repairs 23,000.00 23,000.00 1,609.00 18,031.71 4,968.29 21.60 % 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-55120-000 Cleaning Services 13,825.00 13,825.00 1,600.00 13,254.70 570.30 4.13 % 135-030-55160-000 Professional Outside Services 100,000.00 100,000.00 1,059.57 89,119.51 10,880.49 10.88 % 135-030-55205-000 Utility Billing Contract 9,000.00 9,000.00 634.48 5,756.23 3,243.77 36.04 % 135-030-60005-000 Telephone 6,000.00 6,000.00 438.11 4,250.44 1,749.56 29.16 % 135-030-60010-000 Communications/Mobiles 3,000.00 3,000.00 0.00 386.05 2,613.95 87.13 % 135-030-60020-000 Electricity/Gas 17,684.51 17,684.51 3,176.98 14,237.98 3,446.53 19.49 % 135-030-60025-000 Water 5,000.00 5,000.00 490.50 2,226.42 2,773.58 55.47 % 135-030-60035-000 Postage 30,000.00 30,000.00 2,511.92 20,330.92 9,669.08 32.23 % 135-030-60040-000 Service Charges & Fees 140,000.00 140,000.00 20,203.21 144,911.24 -4,911.24 -3.51 % 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 96,184.40 19,973.82 17.20 % 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 2,515.33 -2,515.33 0.00 % 135-030-60285-000 Lawn Equipment & Maintenance 5,000.00 5,000.00 649.67 4,876.70 123.30 2.47 % 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 0.00 4,562.24 3,637.76 44.36 % 135-030-65085-000 Office Supplies 5,000.00 5,000.00 284.87 2,858.82 2,141.18 42.82 % 135-030-65095-000 Maintenance Supplies 5,000.00 5,000.00 321.30 5,467.97 -467.97 -9.36 % 135-030-69170-000 Copier Lease Installments 4,000.00 4,000.00 271.75 2,468.48 1,531.52 38.29 % 135-030-69195-000 GASB Reserve for Replacement 24,903.00 24,903.00 0.00 24,903.00 0.00 0.00 % 135-039-55045-000 Legal 65,000.00 65,000.00 0.00 29,545.70 35,454.30 54.55 % 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 % Expense Total: 14,423,932.76 14,423,932.76 989,931.49 10,536,710.08 3,887,222.68 26.95% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 360,314.22 -318,257.03 -318,257.03 0.00% Report Surplus (Deficit): 0.00 0.00 360,314.22 -318,257.03 -318,257.03 0.00% 8/12/2024 9:32:19 AM Page 3 of 5 Budget Report For Fiscal: 2023-2024 Period Ending: 07/31/2024 Group Summary Variance Original Current Period Fiscal Favorable Percent Account Type Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 135 - MUD 1 General Fund Revenue 14,423,932.76 14,423,932.76 1,350,245.71 10,218,453.05 -4,205,479.71 29.16% Expense 14,423,932.76 14,423,932.76 989,931.49 10,536,710.08 3,887,222.68 26.95% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 360,314.22 -318,257.03 -318,257.03 0.00% Report Surplus (Deficit): 0.00 0.00 360,314.22 -318,257.03 -318,257.03 0.00% 8/12/2024 9:32:19 AM Page 4 of 5 Budget Report For Fiscal: 2023-2024 Period Ending: 07/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 360,314.22 -318,257.03 -318,257.03 0.00 0.00 360,314.22 -318,257.03 -318,257.03 8/12/2024 9:32:19 AM Page 5 of 5 CASH STATUS AS OF JULY 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,467,331 $2,467,331 135-10300 Prosperity Bank (XXXXX2660) General Fund Operating * $147,880 $4,766,753 $4,914,633 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,983,072 $0 $1,983,072 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) $845,600 $0 $845,600 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 $985,203 $0 $985,203 533-10250 TexPool Tax I & S (XXXXX0003) $560,692 $0 $560,692 533-10300 Prosperity Bank (XXXXX2660) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $518,298 $0 $518,298 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $239,035 $0 $239,035 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $252,146 $0 $252,146 $7,234,684 $17,768,094 Amount available in cash for spending (MUD Accounts) *7/31/2024 Customer Water Deposits $147,880 Fire Department Cash $7,234,684 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $766,241 $766,241 122-10300 Prosperity Bank (XXXXX2660) Fire Operating $0 $0 $0 $0 $766,241 $766,241 Amount available in cash for spending (Fire Department Accounts) $766,241 General Fund 135 Available $ 4,766,753 Prosperity General Fund $ 2,467,331 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 7,234,684 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 $ (318,257) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,387,226