Loading...
HomeMy WebLinkAbout2024-03 March Combined FinancialsCheck Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 03/01/2024 - 03/31/2024 Vendor Number Vendor Name Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular 2222 Aflac 4003 CW Janitorial Services 2862 Data Business Equipment 2711 Endress+Hauser Inc. 2635 Halff Associates Inc. 4033 Health Care Service Corporation 2641 Huber Technology Inc 2943 JP Morgan Chase Bank NA 3132 Legal Shield 3115 Metlife Group Benefits 2760 NDS Leasing 1466 Polydyne, Inc 1737 PVS DX INC 3176 Rey -Mar Construction 2698 Ritz Safety LLC 1578 Smith Pump Company, Inc. 1000 Trophy Club Mud (Water Bills) 3225 US Bank Voyager Fleet Systems 3280 Watts Ellison LLC 2970 Air Mac 2772 Allied Waste Industries 3127 Allied Welding Supply Inc. 1926 Badger Meter, Inc 3299 Bickerstaff Heath Delgado Acosta LLP 1250 Bio -Aquatic Testing Inc. 2683 Charter Communications 4003 CW Janitorial Services 3184 Dataprose LLC 1018 Denton Central Appraisal District 2497 DHS Automation Inc 3118 Exclusive Pest Control 2606 Fisery Solutions LLC 2804 Fortiline Inc. 3093 Four Man Furnace Inc. 2796 Garver 2795 Griswold Company 2635 Halff Associates Inc. 3195 Lou's Gloves Incorporated 2754 Lower Colorado River Authority 2787 Maguire Iron, Inc 4034 Marty Green Utilities 1056 Office Depot Inc 4019 Peterson Pump & Motor Service LLC 2801 Pipeline Analysis LLC 2698 Ritz Safety LLC 1578 Smith Pump Company, Inc. 3156 Southern Petroleum Lab Inc 3182 Strategic Government Resources 2440 Tarrant County Public Health Laboratory 2696 Texas Excavation Safety System 1081 Tri County Electric 2634 Valley Solvents & Chemicals 1058 Verizon Wireless Payment Date Payment Type Discount Amount Payment Amount Number 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/01/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 03/19/2024 Regular 0.00 775.40 10218 0.00 1,200.00 10219 0.00 322.00 10220 0.00 1,006.46 10221 0.00 3,286.59 10222 0.00 20,670.70 10223 0.00 2,252.71 10224 0.00 6,125.86 10225 0.00 15.95 10226 0.00 2,417.81 10227 0.00 175.00 10228 0.00 4,046.85 10229 0.00 1,557.08 10230 0.00 99,829.80 10231 0.00 398.62 10232 0.00 514.00 10233 0.00 144.10 10234 0.00 2,244.90 10235 0.00 1,069.67 10236 0.00 11,147.00 10237 0.00 9,912.15 10238 0.00 25.98 10239 0.00 4,576.00 10240 0.00 3,267.40 10241 0.00 1,290.00 10242 0.00 903.72 10243 0.00 480.00 10244 0.00 2,618.81 10245 0.00 1,967.85 10246 0.00 1,340.00 10247 0.00 490.00 10248 0.00 50.00 10249 0.00 11,264.25 10250 0.00 125.00 10251 0.00 30,093.00 10252 0.00 22,842.97 10253 0.00 1,255.85 10254 0.00 212.00 10255 0.00 828.00 10256 0.00 1,620.00 10257 0.00 1,180.00 10258 0.00 52.98 10259 0.00 1,250.00 10260 0.00 156,399.75 10261 0.00 122.70 10262 0.00 3,292.00 10263 0.00 5,106.00 10264 0.00 225.00 10265 0.00 430.00 10266 0.00 258.75 10267 0.00 990.72 10268 0.00 2,635.63 10269 0.00 583.69 10270 4/8/2024 3:14:43 PM Page 1 of 4 Check Report Vendor Number 2222 2691 3197 1030 2655 4003 2800 3292 1372 2635 4033 1834 3278 3132 3216 3115 2760 1238 1737 1578 3156 2240 1001 2798 3225 2977 Vendor Name Aflac All Test Fire Protection LLC BenefitMall City of Fort Worth Core & Main LP CW Janitorial Services Ferguson Enterprises LLC Grapevine Dodge Chrysler Jeep Hach Company Halff Associates Inc. Health Care Service Corporation Idexx Distribution, Inc Kyocera Document Solutions Legal Shield M3 Networks Metlife Group Benefits NDS Leasing North Texas Pump Co. PVS DX INC Smith Pump Company, Inc. Southern Petroleum Lab Inc Texas Social Security Program Town of Trophy Club Tyler Technologies Inc US Bank Voyager Fleet Systems Videotex Systems Inc. Date Range: 03/01/2024 - 03/31/2024 Payment Date Payment Type Discount Amount Payment Amount Number 03/28/2024 Regular 0.00 775.40 10271 03/28/2024 Regular 0.00 1,286.00 10272 03/28/2024 Regular 0.00 56.00 10273 03/28/2024 Regular 0.00 128,472.86 10274 03/28/2024 Regular 0.00 2,472.97 10275 03/28/2024 Regular 0.00 1,600.00 10276 03/28/2024 Regular 0.00 99.13 10277 03/28/2024 Regular 0.00 60,910.00 10278 03/28/2024 Regular 0.00 552.21 10279 03/28/2024 Regular 0.00 70,240.00 10280 03/28/2024 Regular 0.00 20,670.70 10281 03/28/2024 Regular 0.00 7,133.56 10282 03/28/2024 Regular 0.00 89.91 10283 03/28/2024 Regular 0.00 15.95 10284 03/28/2024 Regular 0.00 1,070.00 10285 03/28/2024 Regular 0.00 2,417.81 10286 03/28/2024 Regular 0.00 175.00 10287 03/28/2024 Regular 0.00 278.71 10288 03/28/2024 Regular 0.00 1,557.08 10289 03/28/2024 Regular 0.00 18,275.00 10290 03/28/2024 Regular 0.00 1,838.40 10291 03/28/2024 Regular 0.00 35.00 10292 03/28/2024 Regular 0.00 229,487.20 10293 03/28/2024 Regular 0.00 250.00 10294 03/28/2024 Regular 0.00 2,010.65 10295 03/28/2024 Regular 0.00 2,085.78 10296 Total Regular: 0.00 980,746.02 4/8/2024 3:14:43 PM Page 2 of 4 Check Report Vendor Number Payment Type: 3197 3113 3124 3197 3113 3124 3113 3124 Vendor Name Bank Draft BenefitMall TCDRS IRS Tax Payment BenefitMall TCDRS IRS Tax Payment TCDRS IRS Tax Payment Payment Type Regular Checks Manual Checks Voided Checks Bank Drafts E FT's Date Range: 03/01/2024 - 03/31/2024 Payment Date Payment Type Discount Amount Payment Amount Number 03/01/2024 03/31/2024 03/01/2024 03/15/2024 03/31/2024 03/15/2024 03/31/2024 03/28/2024 Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Total Bank Draft: Bank Code Prosperity Bank Summary Payable Count 117 0 0 8 0 Payment Count 79 0 0 8 0 Discount Payment 0.00 980,746.02 0.00 0.00 0.00 0.00 0.00 71,894.63 0.00 0.00 125 87 0.00 1,052,640.65 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 373.33 9,959.59 13,409.31 373.33 10,168.05 13,634.73 9,962.30 14,013.99 71,894.63 DFT0000141 DFT0000142 DFT0000143 DFT0000144 DFT0000145 DFT0000146 DFT0000147 DFT0000148 4/8/2024 3:14:43 PM Page 3 of 4 Check Report Date Range: 03/01/2024 - 03/31/2024 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 117 79 0.00 980,746.02 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 8 8 0.00 71,894.63 EFT's 0 0 0.00 0.00 125 87 0.00 1,052,640.65 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 3/2024 1,052,640.65 1,052,640.65 4/8/2024 3:14:43 PM Page 4 of 4 Adopted Budget vs YTD Actuals Revenues & Expenses 56,090,647 57,045,282 $14,423,933 $14,423,933 FY 2024 Combined Financials YTD as of 3/31/2024 YTD Revenues • YTD Expenses $1,450 $53,273 0% 52,071,227 29% $875,814 13% 54,043,518 57% 1% YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD ■ YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 0 Water Consumption Budget vs Actual 92,198,177 61,555,000 44,722,000 46,670,584 Budget Consumption 35,861,000 36,716,000 —1—Actual Consumption 41,156,060 Oct Nov Dec Jan Feb Mar 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption RRA 67R 52S7 896,850,906 Total Water Consumption ■ Budgeted Water Consumption ■ Projected Water Consumption Presented by: Finance Department $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 $676,430 Water Revenue Budget vs Actual $493,961 $554,257 $413,727 $401,119 $345,689 $369,594 $297,607 $272,019 $237,590 $236,061 $212,224 Budget Revenue --Actual Revenue Oct Nov Dec Jan Feb Mar $7,000,000 $6,000,000 $5,000,000 $4,000,000 53,000,000 $2,000,000 $1,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue $5,166,291 $6,057,031 52,510,794 Total Water Revenue $3,481,785 ■ Budgeted Water Revenue ■ Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses ■ Net Projected Water Revenue Minus Projected Expenses Fund: 135 - MUD 1 Ge Revenue Department: 000 - 135-000-40000-000 135-000-40002-000 135-000-40015-000 135-000-40025-000 135-000-47000-000 135-000-47005-000 135-000-47025-000 135-000-47030-000 135-000-47035-000 135-000-47045-000 135-000-47070-000 135-000-49011-000 135-000-49016-000 135-000-49026-000 135-000-49035-000 135-000-49036-000 135-000-49075-000 135-000-49141-000 135-000-49900-000 Trophy Club Municipal Utility District No. 1 neral Fund Revenue, Asset, Liability, & Equity Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Oversize Meter Reimbursement Interfund Transfer In Miscellaneous Income Department: 000 - Revenue, Asset, Liability, & Equity Total: Expense Department: 010 - Water 135-010-50005-000 135-010-50010-000 135-010-50016-000 135-010-50017-000 135-010-50020-000 135-010-50026-000 135-010-50027-000 135-010-50028-000 135-010-50029-000 135-010-50030-000 135-010-50035-000 135-010-50040-000 135-010-50045-000 135-010-50060-000 135-010-50070-000 135-010-55080-000 135-010-55085-000 135-010-55090-000 135-010-55105-000 135-010-55120-000 135-010-55135-000 135-010-55135-001 135-010-60010-000 135-010-60020-000 135-010-60066-000 135-010-60080-000 Original Current Total Budget Total Budget 85,733.51 300.00 300.00 143,223.25 6,939,998.00 3,679,786.00 105,800.00 3,350.00 300.00 100.00 70,000.00 150,000.00 49,320.00 25,000.00 1,933,264.00 50,000.00 2,058.00 1,178,400.00 7,000.00 14,423,932.76 85,733.51 300.00 300.00 143,223.25 6,939,998.00 3,679,786.00 105,800.00 3,350.00 300.00 100.00 70,000.00 150,000.00 49,320.00 25,000.00 1,933,264.00 50,000.00 2,058.00 1,178,400.00 7,000.00 14,423,932.76 Budget Report Account Summary For Fiscal: 2023-2024 Period Ending: 03/31/2024 Period Activity 895.81 43.91 70.81 0.00 401,118.65 295,806.09 5,476.38 375.00 0.00 0.00 142.40 48,306.53 8,240.00 0.00 0.00 0.00 0.00 0.00 0.00 760,475.58 Variance Fiscal Favorable Percent Activity (Unfavorable) Remaining 83,345.41 133.95 196.63 0.00 2,700,519.22 1,751,869.85 45,543.61 2,625.00 600.00 150.00 14,977.60 258,601.61 28,720.00 0.00 0.00 0.00 1,712.00 1,200,330.86 1,321.00 6,090,646.74 -2,388.10 -166.05 -103.37 -143,223.25 -4,239,478.78 -1,927,916.15 -60,256.39 -725.00 300.00 50.00 -55,022.40 108,601.61 -20,600.00 -25,000.00 -1,933,264.00 -50,000.00 -346.00 21,930.86 -5,679.00 -8,333,286.02 2.79 % 55.35 % 34.46 % 100.00 % 61.09 % 52.39 % 56.95 % 21.64 % 200.00 % 150.00 % 78.60 % 172.40 % 41.77 % 100.00 % 100.00 % 100.00 % 16.81 % 101.86 % 81.13 % 57.77% Revenue Total: 14,423,932.76 14,423,932.76 760,475.58 6,090,646.74 -8,333,286.02 57.77% Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental lnsurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis Lab Analysis for PID Communications/Mobiles Electricity Publications/Books/Subscripts Schools & Training 431,575.02 431,575.02 17,000.00 17,000.00 6,252.50 6,252.50 3,600.00 3,600.00 56,730.41 56,730.41 116,527.50 116,527.50 4,834.55 4,834.55 1,051.01 1,051.01 4,000.00 4,000.00 28,422.51 28,422.51 6,647.20 6,647.20 1,260.00 1,260.00 11,898.56 11,898.56 400.00 400.00 300.00 300.00 201,500.00 201,500.00 2,000.00 2,000.00 5,000.00 5,000.00 1,000.00 1,000.00 2,500.00 2,500.00 7,500.00 7,500.00 2,000.00 2,000.00 7,500.00 7,500.00 183,143.49 183,143.49 1,000.00 1,000.00 2,630.00 2,630.00 50,570.75 1,290.04 0.00 225.00 6,250.31 7,619.49 367.85 71.30 286.69 3,158.16 738.60 0.56 1,060.94 0.00 0.00 15,442.13 0.00 938.35 0.00 0.00 300.00 0.00 0.00 13,015.93 0.00 486.00 211,153.74 5,935.63 6,252.50 1,350.00 27,940.16 48,190.57 2,154.54 427.77 1,724.14 13,565.63 3,172.58 45.01 3,707.64 0.00 0.00 68,923.12 951.60 2,000.10 1,911.94 40.31 2,673.00 1,358.00 1,673.97 60,757.93 0.00 2,596.74 220,421.28 11,064.37 0.00 2,250.00 28,790.25 68,336.93 2,680.01 623.24 2,275.86 14,856.88 3,474.62 1,214.99 8,190.92 400.00 300.00 132,576.88 1,048.40 2,999.90 -911.94 2,459.69 4,827.00 642.00 5,826.03 122,385.56 1,000.00 33.26 51.07 % 65.08 % 0.00 % 62.50 % 50.75 % 58.64 % 55.43 % 59.30 % 56.90 % 52.27 % 52.27 % 96.43 % 68.84 % 100.00 % 100.00 % 65.79 % 52.42 % 60.00 % -91.19 % 98.39 % 64.36 % 32.10 % 77.68 % 66.82 % 100.00 % 1.26 % Budget Report 135-010-60100-000 135-010-60135-000 135-010-60135-001 135-010-60150-000 135-010-60285-000 135-010-60332-000 135-010-60334-000 135-010-65005-000 135-010-65010-000 135-010-65030-000 135-010-65050-000 135-010-65053-000 135-010-69005-000 135-010-69195-000 For Fiscal: 2023-2024 Period Ending: 03/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Travel & per diem 577.50 577.50 0.00 604.10 -26.60 -4.61 % TCEQ Fees & Permits 29,500.00 29,500.00 0.00 12,807.15 16,692.85 56.59 TCEQ Fees & Permits for PID 500.00 500.00 0.00 0.00 500.00 100.00 % Wholesale Water 2,655,497.13 2,655,497.13 128,472.86 812,355.08 1,843,142.05 69.41 % Lawn Equipment & Maintenance 12,500.00 12,500.00 600.00 4,800.00 7,700.00 61.60 % Interfund Transfer Out -Rev I&S 565,796.88 565,796.88 51,500.52 309,003.12 256,793.76 45.39 Interfund Transfer Out 0.00 0.00 0.00 920,912.00 -920,912.00 0.00 % Fuel & Lube 23,575.00 23,575.00 1,294.22 8,160.59 15,414.41 65.38 % Uniforms 4,355.00 4,355.00 159.99 1,652.91 2,702.09 62.05 % Chemicals 58,200.00 58,200.00 4,582.26 19,993.82 38,206.18 65.65 % Meter Expense 20,000.00 20,000.00 0.00 0.00 20,000.00 100.00 % Meter Change Out Program 124,500.00 124,500.00 47,150.00 47,150.00 77,350.00 62.13 % Capital Outlays 4,200,000.00 4,200,000.00 33,986.20 1,058,913.39 3,141,086.61 74.79 % 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 369,568.15 4,043,517.78 5,136,415.48 55.95% Department: 020 - Wastewater 135-020-50005-000 135-020-50010-000 135-020-50016-000 135-020-50017-000 135-020-50020-000 135-020-50026-000 135-020-50027-000 135-020-50028-000 135-020-50029-000 135-020-50030-000 135-020-50035-000 135-020-50040-000 135-020-50045-000 135-020-50060-000 135-020-50070-000 135-020-55080-000 135-020-55081-000 135-020-55085-000 135-020-55090-000 135-020-55091-000 135-020-55105-000 135-020-55120-000 135-020-55125-000 135-020-55135-000 135-020-60010-000 135-020-60020-000 135-020-60080-000 135-020-60100-000 135-020-60135-000 135-020-60285-000 135-020-60331-000 135-020-60332-000 135-020-60334-000 135-020-65005-000 135-020-65010-000 135-020-65030-000 135-020-65031-000 135-020-65045-000 135-020-69005-000 135-020-69008-000 135-020-69009-000 135-020-69195-000 Salaries & Wages 290,304.62 290,304.62 27,128.16 115,249.87 175,054.75 60.30 % Overtime 20,000.00 20,000.00 1,199.83 4,997.18 15,002.82 75.01 % Longevity 2,367.50 2,367.50 0.00 2,540.00 -172.50 -7.29 % Certification 5,100.00 5,100.00 225.00 1,350.00 3,750.00 73.53 % Retirement 40,934.05 40,934.05 3,426.35 15,417.45 25,516.60 62.34 % Medical Insurance 93,222.04 93,222.04 4,354.00 26,572.44 66,649.60 71.50 % Dental Insurance 3,385.28 3,385.28 202.37 1,106.64 2,278.64 67.31 % Vision Insurance 818.82 818.82 42.52 255.12 563.70 68.84 % Life Insurance & Other 3,000.00 3,000.00 170.26 1,017.56 1,982.44 66.08 % Social Security Taxes 20,507.87 20,507.87 1,721.92 7,432.80 13,075.07 63.76 % Medicare Taxes 4,796.20 4,796.20 402.70 1,738.28 3,057.92 63.76 % Unemployment Taxes 1,008.00 1,008.00 0.00 26.98 981.02 97.32 % Workman's Compensation 8,403.61 8,403.61 748.93 2,370.58 6,033.03 71.79 % Pre-emp Physicals/Testing 400.00 400.00 0.00 0.00 400.00 100.00 % Employee Relations 300.00 300.00 0.00 0.00 300.00 100.00 % Maintenance & Repairs 137,000.00 137,000.00 14,404.42 81,388.12 55,611.88 40.59 % Mainten & Repairs Collections 270,000.00 270,000.00 154,762.08 219,156.62 50,843.38 18.83 % Generator Maint. and Repair 11,000.00 11,000.00 0.00 6,478.06 4,521.94 41.11 % Vehicle Maintenance 4,600.00 4,600.00 0.00 227.94 4,372.06 95.04 % Veh Maintenance Collections 13,000.00 13,000.00 0.00 3,708.19 9,291.81 71.48 % Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 166.26 1,541.03 1,458.97 48.63 % Cleaning Services 2,000.00 2,000.00 0.00 40.31 1,959.69 97.98 % Dumpster Services 100,000.00 100,000.00 0.00 44,007.25 55,992.75 55.99 % Lab Analysis 55,000.00 55,000.00 3,466.80 32,405.62 22,594.38 41.08 % Communications/Mobiles 7,500.00 7,500.00 0.00 1,486.06 6,013.94 80.19 % Electricity 242,978.33 242,978.33 21,332.81 90,124.91 152,853.42 62.91 % Schools & Training 2,119.00 2,119.00 227.50 727.50 1,391.50 65.67 % Travel & per diem 527.50 527.50 0.00 0.00 527.50 100.00 % TCEQ Fees & Permits 12,000.00 12,000.00 0.00 9,888.02 2,111.98 17.60 % Lawn Equipment & Maintenance 16,000.00 16,000.00 2,910.00 8,240.00 7,760.00 48.50 % Interfund Transfer Out -Tax I&S 115,885.76 115,885.76 10,535.09 63,210.54 52,675.22 45.45 % Interfund Transfer Out -Rev I&S 698,542.63 698,542.63 63,548.65 381,291.90 317,250.73 45.42 % Interfund Transfer Out 0.00 0.00 0.00 96,630.00 -96,630.00 0.00 % Fuel & Lube 13,000.00 13,000.00 716.43 7,652.27 5,347.73 41.14 % Uniforms 3,520.00 3,520.00 0.00 1,181.63 2,338.37 66.43 % Chemicals 32,500.00 32,500.00 2,635.63 16,029.05 16,470.95 50.68 % Chemicals Collections 10,000.00 10,000.00 0.00 5,709.00 4,291.00 42.91 % Lab Supplies 33,000.00 33,000.00 7,133.56 24,830.56 8,169.44 24.76 % Capital Outlays 1,050,000.00 1,050,000.00 190,517.07 616,878.47 433,121.53 41.25 % Short Term Debt -Principal 22,398.34 22,398.34 0.00 22,132.30 266.04 1.19 % Short Term Debt -Interest 442.39 442.39 0.00 425.07 17.32 3.92 % GASB Reserve for Replacement 155,762.00 155,762.00 0.00 155,762.00 0.00 0.00 % Budget Report For Fiscal: 2023-2024 Period Ending: 03/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Department: 020 - Wastewater Total: 3,506,323.94 3,506,323.94 511,978.34 2,071,227.32 1,435,096.62 40.93% Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 15.00 15.00 0.66 3.96 11.04 73.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 115.99 695.94 804.06 53.60 % 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 % Department: 026 - Board of Directors Total: 11,765.00 11,765.00 116.65 1,449.90 10,315.10 87.68% Department: 030 - Administration 135-030-50005-000 Salaries & Wages 663,185.25 663,185.25 76,922.40 320,572.52 342,612.73 51.66 % 135-030-50010-000 Overtime 2,000.00 2,000.00 1,031.62 1,316.78 683.22 34.16 % 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 9,327.51 40,175.29 42,455.78 51.38 % 135-030-50026-000 Medical Insurance 108,759.00 108,759.00 6,531.00 39,858.66 68,900.34 63.35 % 135-030-50027-000 Dental Insurance 3,816.74 3,816.74 253.55 1,485.09 2,331.65 61.09 % 135-030-50028-000 Vision Insurance 886.17 886.17 55.36 332.13 554.04 62.52 % 135-030-50029-000 Life lnsurance & Other 4,800.00 4,800.00 386.51 2,299.31 2,500.69 52.10 % 135-030-50030-000 Social Security Taxes 41,398.50 41,398.50 4,700.21 18,885.86 22,512.64 54.38 % 135-030-50035-000 Medicare Taxes 9,681.91 9,681.91 1,099.25 4,533.25 5,148.66 53.18 % 135-030-50040-000 Unemployment Taxes 1,512.00 1,512.00 1.35 54.02 1,457.98 96.43 % 135-030-50045-000 Workman's Compensation 1,597.19 1,597.19 139.51 482.06 1,115.13 69.82 % 135-030-50060-000 Pre-emp Physicals/Testing 500.00 500.00 0.00 0.00 500.00 100.00 % 135-030-50070-000 Employee Relations 4,000.00 4,000.00 27.54 2,991.57 1,008.43 25.21 % 135-030-55030-000 Software & Support 130,311.00 130,311.00 4,146.72 113,263.34 17,047.66 13.08 % 135-030-55080-000 Maintenance & Repairs 23,000.00 23,000.00 3,497.50 6,615.74 16,384.26 71.24 % 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 7,854.70 5,970.30 43.18 % 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 Professional Outside Services 100,000.00 100,000.00 3,844.53 77,314.83 22,685.17 22.69 % Utility Billing Contract 9,000.00 9,000.00 1,083.51 4,307.32 4,692.68 52.14 % Telephone 6,000.00 6,000.00 489.40 2,933.86 3,066.14 51.10 % Communications/Mobiles 3,000.00 3,000.00 0.00 241.30 2,758.70 91.96 % Electricity/Gas 17,684.51 17,684.51 2,847.52 7,190.78 10,493.73 59.34 % Water 5,000.00 5,000.00 144.10 1,735.92 3,264.08 65.28 % Postage 30,000.00 30,000.00 3,805.54 15,482.57 14,517.43 48.39 % Service Charges & Fees 140,000.00 140,000.00 19,347.04 99,941.22 40,058.78 28.61 % Bad Debt Expense 13,000.00 13,000.00 0.00 0.00 13,000.00 100.00 % Insurance 116,158.22 116,158.22 9,618.44 57,710.64 58,447.58 50.32 % Dues & Memberships 6,800.00 6,800.00 380.00 2,016.00 4,784.00 70.35 % Schools & Training 3,900.00 3,900.00 -1,200.00 1,313.10 2,586.90 66.33 % Travel & per diem 1,227.50 1,227.50 0.00 0.00 1,227.50 100.00 % Elections 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % Lawn Equipment & Maintenance 5,000.00 5,000.00 469.67 3,287.69 1,712.31 34.25 % Furniture/Equipment < $5000 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % Uniforms 530.00 530.00 0.00 0.00 530.00 100.00 % Hardware 8,200.00 8,200.00 2,085.78 4,562.24 3,637.76 44.36 % Office Supplies 5,000.00 5,000.00 83.88 2,298.22 2,701.78 54.04 % Maintenance Supplies 5,000.00 5,000.00 618.02 4,253.39 746.61 14.93 % Copier Lease Installments 4,000.00 4,000.00 264.91 1,655.95 2,344.05 58.60 % 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 153,602.37 875,813.89 737,025.67 45.70% Department: 039 - Non Departmental 135-039-55045-000 Legal 65,000.00 65,000.00 0.00 21,468.95 43,531.05 66.97 % 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 1,967.85 6,078.42 6,992.58 53.50 % 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 1,967.85 53,272.66 59,798.34 52.89% Budget Report For Fiscal: 2023-2024 Period Ending: 03/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-039-55065-000 Expense Total: 14,423,932.76 14,423,932.76 1,037,233.36 7,045,281.55 7,378,651.21 51.16% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 -276,757.78 -954,634.81 -954,634.81 0.00% Report Surplus (Deficit): 0.00 0.00 -276,757.78 -954,634.81 -954,634.81 0.00% Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Total Asset: 122 - Trophy Club MUD Fire Dept. 1,201,633.54 1,201,633.54 Balance Sheet Funds 122 - 528 Account Summary As Of 03/31/2024 135 - MUD 1 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 General Fund Consolidated Bond Const- Bond 16" Revenue Bond GASB SWIFT Waterline Reserve Fund 10,545,620.02 4,916,432.58 921,573.52 0.00 967,893.79 10,545,620.02 4,916,432.58 921,573.52 0.00 967,893.79 Total 18,553,153.45 18,553,153.45 Liability 000 - Revenue, Asset, Liability, & Equity 44,116.73 Total Liability: 44,116.73 Equity 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 759,281.93 794,772.04 794,772.04 0.00 81,691.15 0.00 0.00 0.00 81,691.15 0.00 0.00 10,705,482.79 3,258,146.58 735,325.73 1,179,058.79 942,342.55 759,281.93 1,290,425.96 892,191.08 398,234.88 1,157,516.81 1,201,633.54 10,705,482.79 6,090, 646.74 7,045,281.55 -954,634.81 9,750,847.98 10,545,620.02 3,258,146.58 1,658,286.00 0.00 1,658,286.00 4,916,432.58 4916432.58 735,325.73 19,504.72 -85,051.92 104,556.64 839,882.37 921,573.52 1,179,058.79 21,272.07 1,200,330.86 -1,179,058.79 0.00 0.00 942,342.55 25,551.24 0.00 25,551.24 967,893.79 967,893.79 Monthly Financial Activity Footnotes: Fund 122 Activity Daily property tax deposits Monthly transfer OUT to MUD General Fund to cover Town transfers and any other A/P expenses Fund 135 Activity Daily property tax deposits All A/P checks are cut through the General Fund Monthly transfer IN to cover other fund A/P expenses Monthly transfer OUT for l&S Revenue Bond payments for Fund 534, 535, & 536 Monthly bank interest Fund 137 Activity Transfer IN at beginning of fiscal year based on yearly budget and transfer OUT at fiscal year-end based on reserves balances Fund 519 Activity Monthly bank interest Fund 520 Activity Transfer OUT to MUD General Fund to cover Interconnect Waterline construction project expenses Monthly bank interest Fund 528 Activity Monthly bank interest 920,579.92 920,579.92 17,579,638.37 17,579,638.37 9,105,686.73 9,052,751.57 52,935.16 17,632,573.53 18,553,153.45 4/11/2024 12:11:17 PM Page 1 of 1 Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Liability 000 - Revenue, Asset, Liability, & Equity Total Asset: Total Liability: 533 - MUD 1 I&S 534 - 2015 535 - 2016 Rev 536 - 2019 Rev Consolidated Revenue Bond Bond I&S-SWIFT Bond I&S- I&S W&WW System 514,915.77 289,185.21 136,307.58 111,033.73 514,915.77 289,185.21 136,307.58 111,033.73 Balance Sheet I&S Funds 533 - 536 Account Summary As Of 03/31/2024 Total 1,051,442.29 1,051,442.29 7,867.36 0.00 0.00 0.00 7,867.36 0.00 0.00 0.00 7,867.36 7,867.36 Equity 000 - Revenue, Asset, Liability, & Equity 85,836.20 39,137.14 11,713.62 6,476.05 143,163.01 Total Total Beginning Equity: 85,836.20 39,137.14 11,713.62 6,476.05 143,163.01 Total Revenue 483,905.96 338,166.82 151,351.21 209,351.43 1,182,775.42 Total Expense 62,693.75 88,118.75 26,757.25 104,793.75 282,363.50 Revenues Over/Under Expenses 421,212.21 250,048.07 124,593.96 104,557.68 900,411.92 Total Equity and Current Surplus (Deficit): 507,048.41 289,185.21 136,307.58 111,033.73 1,043,574.93 Total Liabilities, Equity and Current Surplus (Deficit): 514,915.77 289,185.21 136,307.58 111,033.73 1,051,442.29 4/11/2024 12:13:58 PM Monthly Financial Activity Footnotes: Fund 533 Activity Daily property tax deposits Monthly transfer IN from Fund 135 for PID portion of semi-annual GO Bond payments 3/1 & 9/1 GO Bond payments (Interest and Principal) Monthly bank interest Fund 534 Activity • Monthly transfer IN for semi-annual I&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Fund 535 Activity • Monthly transfer IN for semi-annual I&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Fund 536 Activity Monthly transfer IN for semi-annual I&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Page 1 of 1 CASH STATUS AS OF MARCH 2024 TexPool 0 & 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,815,828 $2,815,828 135-10300 Prosperity Bank (XXXXX2660) General Fund Operating * $146,355 $4,619,596 $4,765,951 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,967,621 $0 $1,967,621 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 51 9-1 11 55 Cash -Bond Escrow Bank of Texas (SWIFT) $836,522 $0 $836,522 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 $967,894 $0 $967,894 533-10250 TexPool Tax I & S (XXXXX0003) $507,048 $0 $507,048 533-10300 Prosperity Bank (XXXXX2660) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $289,185 $0 $289,185 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $136,308 $0 $136,308 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $111,034 $0 $111,034 $7,436,024 $17,399,474 Amount available in cash for spending (MUD Accounts) *3/31/2024 Customer Water Deposits $146,355 Fire Department Cash $7,436,024 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $1,145,236 $1,145,236 122-10300 Prosperity Bank (XXXXX2660) Fire Operating $0 $0 $0 $0 $1,145,236 $1,145,236 Amount available in cash for spending (Fire Department Accounts) $1,145,236 General Fund 135 Available $ 4,619,596 Prosperity General Fund $ 2,815,828 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 7,436,024 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 $ (954,635) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $9,750,848 ebills Bills Mailed Bank Draft Online Payments Late Notices Disconnects Connections MUD Connections Town March Utility Billing Report Fiscal Year 2023 - 2024 March 2023 April 2023 May 2023 June 2023 July 2023 August 2023 September 2023 October 2023 November 2023 December 2023 January 2024 February 2024 March 2024 1,773 1,767 1,794 1,766 1,750 1,744 1,742 1,745 1,740 1,737 1,736 1,734 1,744 3,744 3,743 3,734 3,755 3,749 3,747 3,747 3,737 3,739 3,742 3,726 3,729 3,737 599 590 588 589 585 578 572 569 562 567 568 565 565 3,016 2,998 2,754 3,134 3,101 2,957 3,086 3,072 3,006 3,133 3,023 3,036 3,246 413 289 290 327 327 268 344 255 298 342 249 298 299 0 8 9 9 13 7 7 13 4 5 4 8 7 3,394 3,394 3,394 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,394 1,443 1,443 1,443 1,443 1,443 1,443 1,443 1,444 1,444 1,446 1,446 1,447 1,447 March Permits Fiscal Year 2023 - 2024 Date of Permit Permit No. Customer Deposit Due to FW Water Oversize Meter Plumbing Inspections Sewer Inspections Fire Line Misc. Income Total $ - $ - $ - $ - $ - $ - $ - $ - Total $ - $ - $ - $ - $ - $ - $ - $ -