Loading...
HomeMy WebLinkAbout2022-0921A Resoluting Adopting 2023 Fiscal Year BudgetResolution No. 2022-0921A Approving Fiscal Year 2023 Budget Trophy Club Municipal Utility District No. 1 100 Municipal Drive Trophy Club, Texas 76262 (682) 831-4600 1 of 19 Trophy Club MUD No. 1 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget FY 2023 ADOPTED BUDGET TAX RATE SUMMARY COMPARISON Fiscal Years 2022 2023 % of Increase/Decrease Fiscal Years 2022 2023 % of Increase/Decrease M&O (General Fund) Tax M&O Fire Tax M&O Tax Rate Increase/Decrease: 0.00687 0.00393 -42.77% 0.06412 0.05625 -12.27% 0.07099 0.06019 -15.22% -0.00086 -0.01081 I & S (Debt Service) Tax Increase/Decrease: 0.03489 0.03115 -10.71% -0.00100 -0.00374 Total Tax Rate: 0.10588 0.09134 -13.74% Increase/Decrease: -0.00186 -0.01454 PROPERTY VALUE SUMMARY COMPARISON Fiscal Years 2022 2023 % of Increase/Decrease MUD Tarrant Co. MUD Denton Co. PID Out of District & PID 510,691,116 590,349,578 15.60% 1,468,987,935 1,645,315,777 12.00% 824,066,245 919,078,121 11.53% 266,888 704,864 164.10% Total Value: 2,804,012,184 3,155,448,340 12.53% FY 2023 BUDGET FUND SUMMARY General Fund Revenue 10,763,469 Tax Collections 87,956 PID Surcharges 145,029 Reserve Funds 736,900 Total Revenue 11,733,354 Water Expense 6,577,931 Wastewater Expense 3,491,931 Board of Directors Expense 11,765 Administration Expense 1,534,986 Non -Departmental Expense 116,740 Total Expense 11,733,354 Net Budget Surplus/Deficit Tax Debt Service Fund so Revenue 197,266 Tax Collections 696,446 PID Surcharge 116,245 Total Revenue 1,009,958 Debt Service Expense 1,009,958 Total Expense 1,009,958 Net Budget Surplus/Deficit $0 2 of 19 Fire Fund Revenue 22,000 Tax Collections 1,257,579 PID Assessment 517,385 Reserve Funds 0 Total Revenue 1,796,964 Fire Expense 1,796,964 Total Expense 1,796,964 Net Budget Surplus/Deficit $0 Revenue Debt Service Fund Revenue 1,259,714 Total Revenue 1,259,714 Debt Service Expense 1,259,714 Total Expense 1,259,714 Net Budget Surplus/Deficit $0 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget FY 2023 Budget Calendar 4/1/2022 - 4/29/2022 Create and update new FY base budget in Excel Create Budget Calendar 5/2/2022- 5/27/2022 Departmental budget meeting for base budget needs and wants, review calendar and set expectations 5/31/2022 - 6/4/2022 First round of Departmental Proposals should be submitted for review with supporting documents Detail explanation on account increases and capital request 6/8/2022 Budget meeting with Town/Fire staff to review and update the Fire Budget, Budget Committee meeting to review draft Present a projected General Fund and Fire Fund budget summary at the June Board meeting 6/8/2022 - 6/11/2022 Update excel budget worksheets YTD thru May, Revenue and Tax Bond Debt, TexPool Transfers (I&S) employee cost projections, preliminary tax valuations, and consumption forecasting and demands 6/14/2022 Meeting with General Manager, Operations Manager, and Finance Manager to discuss 5 year CIP projection Impact to rates and Cash Reserves, and overall projected budget review 6/17/2022 - 6/24/2022 Meet with department supervisors to address budget demands and required reductions All departmental budget proposal submissions and documents are due to Finance Department 6/25/2022 - 6/28/2022 Review and approve resubmittal department proposals, reach out to Fire Department/Town for proposed Fire Budget, update the excel budget with preliminary tax evaluations, and calculate preliminary District tax rate 6/29/2021 Meet with General Manager and department managers to present "proposed" budget. Review 5 year capital plan, preliminary tax valuations, and rate model parameters. 6/30/2022 Budget Committee Meeting to review initial draft budget and discuss potential rate impacts 7/1/2022 Provide consumption numbers and draft budget numbers for rate calculations to NewGen for rate assessment calculations 7/26/2022 Certified Tax Roll numbers released, update Tax Assessment worksheet, and update budget projections Calculate HS tax averages and Comptroller Developed Water District Voter -Approval Tax Rate Worksheet 7/27/2022 Final projected budget numbers to NewGen for rate assessment and updated Rate Model 8/3/2022 Budget Committee Meeting to review proposed rate scenarios and proposed budget Final updates before presented proposed budget at the August Board meeting 8/5/2022 Notify Town of Trophy Club of proposed Fire Assessment Rate 8/17/2022 Regular Board Meeting- Review proposed budget and recommended rate scenarios (NewGen PowerPoint) 8/22/2022 - 9/2/2022 Update District's website and Denton/Tarrant County TNT websites with Proposed Tax Rate and Public Hearing Notice Notice of Public Hearing for Proposed Tax Rate published in Star Telegram (minimum 7 days prior) 9/21/2022 Public Hearing/Board meeting for adoption of District Property Tax Rate Resolutions and FY 23 Budget Resolution 9/30/2022 Update Denton County and Tarrant County TNT websites with Adopted Tax Rates Update District's website with Adopted Tax Rates, Adopted Rate Order, and updated Notice to Purchaser *Some of the following dates are estimated and maybe subject to change as needed 3 of 19 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget TAX RATE ASSESSMENT PID ASSESSMENT & SURCHARGE CALCULATIONS FIRE TAX/ASSESSMENT RATE NET TAX VALUE: TARRANT COUNTY: $590,349,578 DENTON COUNTY: $1,645,315,777 DENTON CO. PID: $919,078,121 OUT OF DISTRICT & PID $704,864 REQUIRED REVENUE FIRE $1,774,964 M&O TAX/SURCHARGE RATE TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 31,554,483 FY 2023 Tax/Assess Rate = 0.05625 Revenue from MUD Tax = Revenue from PID Assess = NET TAX VALUE: $ 1,257,579 $ 517,385 Total: $ 1,774,964 TARRANT COUNTY: $590,349,578 DENTON COUNTY: $1,645,315,777 DENTON CO. PID: $919,078,121 REQUIRED REVENUE M&O 116,740 98,800 *MUD (All of Dept. 39 Budget) **ND (Legal and Auditor only Dept 39 Budget) I&S TAX/SURCHARGE RATE NEW DEBT: CALCULATE AMOUNT DUE FROM PID Certified 7/21/2022 7/25/2022 7/25/2022 Certified 7/21/2022 7/25/2022 7/25/2022 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 31,547,435 FY 2023 MUD M&O Tax Rate = 0.00393 FY 2023 PID Tax/Surcharge Rate = 0.00313 Revenue from MUD Tax = Revenue from PID Surcharge = $ 87,956 $ 28,784 NET TAX VALUE: Total: $ 116,740 TARRANT COUNTY: $590,349,578 DENTON COUNTY: $1,645,315,777 DENTON CO. PID: $919,078,121 REQUIRED REVENUE TAX DEBT 2014 AND AFTER (I&S) $399,013 MUD DEBT: CALCULATE MUD TAX Certified 7/21/2022 7/25/2022 7/25/2022 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 31,547,435 FY 2023 PID Surcharge Rate = 0.0126J ***NOT FINAL TAX RATE: ONLY USED TO CALCULATE PO SHARE Revenue from MUD Tax = Revenue from PID Surcharge = $ 282,767 $ 116,245 NET TAX VALUE: Total: $ 399,013 TARRANT COUNTY: $590,349,578 DENTON COUNTY: $1,645,315,777 REQUIRED REVENUE I&S MUD DEBT $696,446 Tax Rate Requirements 3.5% Overall Tax Rate FY 2023 0.09134 Voter Approval Rate 0.09658 Contributions Required $0 Certified 7/21/2022 7/25/2022 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 VaIs/100 = 22,356,654 FY 2023 Tax Rate = 0.03115 Revenue from MUD Tax = Revenue from PID = N/A 696,446 Total: $ 696,446 TAX COMPARISON 2022 2023 M&O (General Fund) Tax 0.00687 0.00393 M&O Fire Tax 0.06412 0.05625 M&C) Tax Rate 0.07099 0.06019 Increase/Decrease Rate: -0.00086 -0.01081 I & 5 (Debt Service) Tax 0.03489 0.03115 Increase/Decrease Rate: -0.00100 -0.00374 Total Tax Rate: 0.10588 0.09134 Increase/Decrease Rate: -0.00186 -0.01454 4 of 19 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget FIRE DEPARTMENT FUND Description FY 2021 Actual FY 2022 Adopted FY 2022 Amended FY 2022 Projected FY 2023 Adopted Budget vs Amended Budget % Change Revenues -Town Assessment - Emerg Svcs 507,446 528,546 528,546 528,546 517,385 (11,161) -2.11% Emer Svcs Assessment/Delinquent Property Taxes/Assessments P&I Fire Permits/Sprinkler & Plan Review Fire Inspections Denton/Tarrant County Pledge -Fire Grant Revenue 4,226 17,072 5,000 5,000 5,000 5,000 17,000 17,000 17,000 17,000 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Revenues -MUD Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&I Capital Leases -Other Financial Sources Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Miscellaneous Income Total Revenue 1 1 1 1 1,205,268 1,269,330 1,269,330 1,269,330 1,257,579 (11,751) -0.93% 32,221 - - - 0.00% 5,283 - - - - 0.00% - - - - - 0.00% - - - - 0.00% 57,369 57,700 57,700 57,700 - (57,700) -100.00% - - - - 0.00% - - - - 0.00% 1,828,885 1,877,576 1,877,576 1,877,576 1,796,964 (80,612) -4.29% Expenses -Town Salaries- Regular 697,488 709,025 728,028 681,186 716,522 (11,506) -1.58% Salaries- Part Time 49,275 50,078 50,078 24,493 50,000 (78) -0.16% Salaries- Merits - 13,550 13,550 - 35,337 21,787 160.79% Salaries- Overtime 115,592 84,405 84,405 134,845 83,580 (825) -0.98% Salaries- Longevity 7,343 7,254 7,254 7,574 7,607 353 4.87% Salaries- Stipend - - - - 0.00% Certification Pay 10,176 11,438 11,438 8,244 10,838 (600) -5.25% Salaries- Cell Phone Stipend 1,875 1,800 1,800 1,050 900 (900) -50.00% Retirement 113,794 110,223 110,223 110,737 111,785 1,562 1.42% Medical lnsurance 76,715 74,102 74,102 65,561 91,140 17,038 22.99% Dental lnsurance 5,559 5,582 5,581 4,073 6,544 963 17.25% Vision Insurance 513 539 539 517 631 92 17.07% Life lnsurance & Other 4,633 5,635 5,635 3,221 5,565 (70) -1.24% Social Security Taxes 52,773 52,084 52,084 51,613 51,444 (640) -1.23% Medicare Taxes 12,338 12,182 12,182 12,105 12,031 (151) -1.24% Unemployment Taxes 4,993 2,442 2,394 234 2,520 126 5.26% Workman's Compensation 17,868 17,816 17,816 13,608 19,047 1,231 6.91% Physicals/Testing 4,078 5,960 5,960 5,960 - (5,960) -100.00% Tuition Reimbursement 5,074 8,290 8,290 8,290 - (8,290) -100.00% Professional Outside Services 1,567 1,750 1,750 51,854 1,750 0.00% Software & Support 12,354 17,164 17,164 15,164 17,164 0.00% Tax Administration 1,521 1,605 1,605 1,600 1,600 (5) -0.31% Advertising - 1,500 1,500 - 1,000 (500) -33.33% Printing 280 500 500 300 300 (200) -40.00% Schools & Training 9,478 19,900 19,900 9,900 19,900 0.00% Electricity 5,530 8,400 8,400 7,000 8,400 - 0.00% Water 3,734 4,000 4,000 4,000 4,000 - 0.00% Telephone - - - - - 0.00% Communications/Mobiles 14,692 16,691 16,691 17,095 16,691 0.00% Building Maintenance 25,176 22,200 43,261 45,000 22,200 (21,061) -48.68% Vehicle Maintenance 17,136 40,800 40,800 28,800 40,800 0.00% Equipment Maintenance 10,241 18,715 18,715 10,715 18,715 - 0.00% 5 of 19 - 4.29% - 6.29% 1 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget FIRE DEPARTMENT FUND Description FY 2021 Actual FY 2022 Adopted FY 2022 Amended FY 2022 Projected FY 2023 Adopted Budget vs Amended Budget % Change Emergency Management 1,000 1,000 1,000 1,000 1,000 - 0.00% Dispatch- Denton County 3,946 4,020 4,020 4,020 5,061 1,041 25.90% Dues & Memberships 20,417 20,337 20,337 20,153 20,337 - 0.00% Flags & Repair 215 - - - - - 0.00% Travel & per diem 8,236 14,510 14,510 14,994 14,510 - 0.00% Office Supplies 327 500 500 500 500- 0.00% Printer Supplies 1,007 1,400 1,400 1,600 1,600 200 14.29% Postage 73 100 100 100 100- 0.00% Publications/Books/Subscripts 297 350 350 350 350- 0.00% Fuel 8,997 12,215 12,215 12,215 12,225 10 0.08% Uniforms 7,850 9,645 9,645 9,645 9,645- 0.00% Safety Equipment/Protective Clothing 8,970 27,700 27,700 15,000 40,000 12,300 44.40% Dispsable Supplies - - - 109 - - 0.00% Small Equipment 161 4,950 4,950 4,950 4,950 - 0.00% Hardware 1,106 4,458 4,458 2,431 4,458 - 0.00% Maintenance & Supplies 375 1,500 1,500 1,500 1,500 - 0.00% Miscellaneous Expense 3,562 4,000 4,000 4,000 4,000 - 0.00% Capital Outlays - - - - - - 0.00% Programs & Special Projects 9,649 16,931 16,931 11,818 16,931 - 0.00% Expenses -MUD Maintenance & Repairs (GASB34) - - - - - - 0.00% Rent And/or Usage 197,281 198,761 198,761 198,761 197,266 (1,495) -0.75% Insurance 19,789 21,000 21,000 21,000 23,100 2,100 10.00% Capital Outlays - - - - - - 0.00% Short Term Debt -Interest 6,127 3,101 3,101 3,101 - (3,101) -100.00% GASB34/Reserve for Replacement 81,420 81,420 81,420 81,420 81,420 - 0.00% Capital Leases- Principal 121,022 124,047 124,047 124,047 - (124,047) -100.00% Total Expense 1,783,622 1,877,576 1,917,591 1,857,454 1,796,964 (120,627) -6.29% Total Fire Revenues Total Fire Expenses Net Budget Surplus (Deficit) $ 1,828,885 $ 1,783,622 $ 45,262 $ 1,877,576 $ 1,877,576 $ 1,877,576 $ 1,917,591 $ (40,015) $ 1,877,576 $ 1,857,454 $ 20,122 $ 1,796,964 $ 1,796,964 (80,612) (120,627) 40,015 Town/MUD Fire Contract Calculation FY 2022 FY 2023 Fire Budget Less: Rent/Debt Service Less: TML Fire Insurance Less: Capital Outlays Less: Capital Leases Interest Less: Capital Leases Principal Less: GASB34/Reserve for Replacement Less: ESD Assessment Less: Fire Permits/Sprinkler Less: Fire Inspections Less: Denton County Fire Pledge Less: Grant Proceeds 1,877,576 198,761 21,000 3,101 124,047 81,420 528,546 5,000 17,000 1,796,964 197,266 23,100 81,420 517,385 5,000 17,000 Annual transfer to Town from MUD/Fire Budget $ 898,700 $ 955,793 Monthly payment to Town Oct -Sept $ 74,892 $ 79,649 6 of 19 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget GENERAL FUND Description FY 2021 Actual FY 2022 Adopted FY 2022 Amended FY 2022 Projected FY 2023 Adopted Budget vs Budget Net Budget % Change Revenues Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges (Disconnect Fees) Plumbing Inspections Sewer Inspections TCCC Effluent Charges Utility Fees Capital Lease- Other Fin Sources Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Loan Proceeds Oversize Meter Reimbursement Interfund Transfer In lntergov Transfer In Miscellaneous Income Records Management Revenue Recovery of Prior Year Expense Reimbursement 134,965 527 581 162,305 5,617,478 3,604,966 86,208 12,100 300 100 72,210 18,386 14,146 23,975 4,407 19,912 136,092 300 300 165,537 6,033,776 3,824,473 94,826 14,000 750 2,500 50,000 136,092 300 300 165,537 6,033,776 3,824,473 94,826 14,000 750 2,500 50,000 138,290 87,956 (48,136) -35.37% 300 0.00% 300 0.00% 145,029 (20,509) -12.39% 6,710,979 677,203 11.22% 3,839,686 15,213 0.40% 78,000 (16,826) -17.74% 5,600 (8,400) -60.00% 300 (450) -60.00% 100 (2,400) -96.00% 60,000 10,000 20.00% - 0.00% - 0.00% 20,000 5,000 33.33% 14,146 0.00% - - 0.00% 25,000 25,000 15,000 150.00% - 572,900 572,900 0.00% 164,000 164,000 0.00% - - 0.00% 2,261 2,058 0.00% - - 0.00% - - 0.00% 7,834 7,000 - 0.00% - - 0.00% 85,000 - - 0.00% - - 0.00% 511 165,537 6,644,036 3,814,243 100,000 5,000 450 100 110,000 15,000 15,000 60,000 14,146 14,146 14,146 10,000 25,000 524,000 2,058 2,058 7,000 7,000 Subtotal Revenues 9,772,566 10,370,758 10,909,758 11,172,408 11,733,354 1,362,596 13.14% Water Expenses 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 Engineering Maintenance & Repairs Generator Maintenance & Repairs Vehicle Maintenance Maintenance -Heavy Equipment Cleaning Services Lab Analysis - MUD Lab Analysis - PID Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships 353,851 402,468 372,468 342,000 407,139 4,671 1.16% 22,293 17,000 22,000 35,000 17,000 0.00% 5,435 5,829 5,829 5,713 5,983 154 2.64% 3,025 4,500 4,500 2,700 3,600 (900) -20.00% 35,652 46,074 46,074 46,074 51,201 5,127 11.13% 62,867 97,671 67,671 66,000 82,722 (14,949) -15.31% 3,835 5,594 5,594 4,150 4,876 (718) -12.83% 561 719 719 600 745 26 3.58% 3,787 4,620 4,620 3,700 2,400 (2,220) -48.05% 23,532 26,647 26,647 25,000 26,891 243 0.91% 5,503 6,232 6,232 6,000 6,289 57 0.91% 1,671 1,512 1,512 143 1,260 (252) -16.67% 12,500 11,604 11,604 11,604 11,249 (355) -3.06% 400 400 55 400 0.00% 103 300 300 300 300 0.00% 0.00% 80,718 110,000 200,000 350,000 229,800 119,800 108.91% 889 2,000 2,000 2,000 2,000 0.00% 7,879 5,000 10,000 10,000 5,000 0.00% 1,114 1,000 1,000 1,000 1,000 0.00% 1,198 2,000 2,000 2,000 2,500 500 25.00% 3,641 7,500 7,500 7,500 7,500 0.00% 2,047 2,000 2,000 2,000 2,000 0.00% 5,551 7,500 7,500 7,500 7,500 0.00% 123,528 131,689 131,689 131,689 228,250 96,561 73.33% 1,366 1,000 1,000 1,000 1,000 0.00% - 125 - 0.00% 7 of 19 Description Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits - MUD TCEQ Fees & Permits - PID Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Services Interfund Transfer Out- Revenue l&S Interfund Transfer Out- Bond Reserve Interfund Transfer Out -Bank Reserve Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Bond Related Expenses Subtotal Water Expenses FY 2021 Actual Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget GENERAL FUND FY 2022 Adopted FY 2022 Amended FY 2022 Projected FY 2023 Budget vs Budget % Adopted Budget Net Change 1,986 4,141 4,141 4,141 3,630 (511) -12.34% 105 - - 0.00% 988 988 - 938 (50) -5.06% - - - 0.00% 34,779 30,000 30,000 30,000 30,000 0.00% - 437 - 0.00% 1,893,513 2,508,611 2,508,611 2,606,581 2,640,131 131,520 5.24% - - - 0.00% 245 - - 0.00% 8,700 12,500 12,500 12,500 12,500 0.00% 565,819 569,454 569,454 569,455 567,782 (1,672) -0.29% - - - 0.00% - - - 0.00% 382 2,500 2,500 - 2,500 0.00% 14,940 15,000 15,000 22,000 15,000 0.00% 2,966 5,250 5,250 2,600 4,355 (895) -17.05% 25,231 25,000 25,000 28,000 25,000 0.00% 640 - - - 0.00% - - - 0.00% 9,287 20,000 20,000 2,500 20,000 0.00% 86,625 87,000 87,000 87,000 87,000 0.00% 689,134 905,000 1,429,000 1,100,000 1,752,000 847,000 93.59% 30,962 31,419 31,419 31,419 31,882 463 1.48% 2,314 1,404 1,404 1,404 470 (934) -66.50% 697,986 75,000 75,000 75,000 162,639 87,639 116.85% 107,607 113,500 113,500 113,500 113,500 0.00% 0.00% 4,935,767 1 5,307,626 1 5,871,626 1 5,750,390 1 6,577,931 1 1,270,306 1 23.93%1 Wastewater Expenses Salaries & Wages 458,805 478,934 418,934 418,934 309,655 (169,280) -35.35% Overtime 32,324 33,000 33,000 33,000 33,000 0.00% Longevity 7,420 7,956 7,956 7,956 4,035 (3,921) -49.28% Certification 7,800 8,400 8,400 6,000 6,300 (2,100) -25.00% Retirement 46,910 56,634 56,634 44,000 41,671 (14,962) -26.42% Medical Insurance 91,201 112,190 72,190 72,190 96,579 (15,611) -13.92% Dental Insurance 5,036 7,175 7,175 3,900 5,427 (1,748) -24.37% Vision Insurance 781 1,013 1,013 600 793 (220) -21.72% Life Insurance & Other 4,810 4,800 4,800 3,400 2,400 (2,400) -50.00% Social Security Taxes 30,252 32,754 32,754 24,500 21,885 (10,869) -33.18% Medicare Taxes 7,075 7,660 7,660 6,000 5,118 (2,542) -33.18% Unemployment Taxes 1,960 1,764 1,764 100 1,260 (504) -28.57% Workman's Compensation 16,302 14,153 14,153 14,153 8,987 (5,166) -36.50% Pre-emp Physicals/Testing - 400 400 400 400 0.00% Employee Relations 135 300 300 445 300 - 0.00% Engineering - - - 0.00% Independent Labor - - - 0.00% Maintenance & Repairs- WWTP 99,418 125,000 160,000 215,000 134,600 9,600 7.68% Maintenance & Repairs- Collections 187,743 222,500 222,500 315,000 281,000 58,500 26.29% Generator Maintenance & Repairs 4,055 9,000 9,000 9,000 9,000 0.00% Vehicle Maintenance- WWTP 2,831 4,600 4,600 1,500 4,600 - 0.00% Vehicle Maintenance- Collections 7,905 13,000 13,000 18,947 13,000 0.00% Maintenance -Heavy Equipment 1,390 3,000 3,000 3,000 3,000 - 0.00% Cleaning Services 1,197 2,000 2,000 2,000 2,000 0.00% Dumpster Services 92,408 100,000 100,000 100,000 100,000 - 0.00% Lab Analysis 40,690 40,000 40,000 40,000 40,000 0.00% Communications/Mobiles 5,997 7,500 7,500 7,500 7,500 0.00% Electricity 146,660 150,732 150,732 172,000 276,318 125,586 83.32% Publications/Books/Subscripts - - - - 0.00% 8 of 19 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget GENERAL FUND Description FY 2021 Actual FY 2022 Adopted FY 2022 Amended FY 2022 Projected FY 2023 Adopted Budget vs Budget Net Budget % Change Dues & Memberships- - - - - - 0.00% Schools & Training 2,827 4,652 4,652 2,000 3,630 (1,022) -21.97% Safety Program- - - - - - 0.00% Travel & per diem - 1,138 1,138 - 1,038 (100) -8.79% Rent/Lease Equipment 575 - - - - - 0.00% Advertising - - - - - - 0.00% TCEQ Fees & Permits 28,791 12,000 22,000 22,000 12,000 - 0.00% Miscellaneous Expenses- - - - - - 0.00% Property Maintenance- - - - - - 0.00% Lawn Services 10,430 16,000 16,000 10,000 16,000 - 0.00% Interfund Transfer Out -Tax I&S 114,681 115,924 115,924 115,924 116,245 321 0.28% Interfund Transfer Out- Revenue I&S 688,005 690,085 690,085 690,086 691,931 1,846 0.27% Interfund Transfer Out -Bond Reserve- - - - - - 0.00% Interfund Transfer Out -Bank Reserve 38,802 - - - - - 0.00% Furniture/Equipment < $5000 228 500 500 500 500 - 0.00% Fuel & Lube 13,408 12,500 12,500 12,500 12,500 - 0.00% Uniforms 4,168 6,205 6,205 6,205 4,415 (1,790) -28.85% Chemicals- WWTP 23,442 32,500 32,500 32,500 32,500 - 0.00% Chemicals- Collections 4,895 10,000 10,000 10,000 10,000 - 0.00% Small Tools 343 - - - - - 0.00% Safety Equipment 307 - - - - - 0.00% Lab Supplies 28,349 33,000 33,000 33,000 33,000 - 0.00% Capital Outlays 222,147 700,000 685,000 300,000 895,000 195,000 27.86% Short Term Debt -Principal 81,295 81,878 81,878 83,496 85,766 3,888 4.75% Short Term Debt -Interest 8,496 7,312 7,312 7,312 2,801 (4,511) -61.69% Gasb34/Reserve for Replacement 752,986 130,000 130,000 130,000 165,777 35,777 27.52% Capital Lease Issuance Cost - - - - - - 0.00% Subtotal Wastewater Expenses 3,325,280 3,298,159 3,228,159 2,975,047 3,491,931 193,772 5.88% Board of Directors Expenses Salaries & Wages Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses Subtotal Board of Directors Expenses Administration Expenses 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 Engineering 9 1,195 1,418 58 2,680 516,401 97 2,668 48,136 75,830 4,204 616 4,829 30,429 7,116 1,512 1,542 3,422 30 750 1,500 4,000 5,000 500 11,780 567,338 2,000 2,972 61,353 103,384 6,533 819 4,800 35,483 8,298 1,512 1,425 500 4,000 9 of 19 30 750 1,500 4,000 5,000 500 11,780 567,338 2,000 2,972 61,353 83,384 6,533 819 4,800 35,483 8,298 1,512 1,425 500 4,000 15 750 1,500 625 2,890 567,338 500 2,973 61,353 71,000 4,000 600 4,800 35,483 8,298 100 1,425 516 4,000 15 750 1,500 4,000 5,000 500 11,765 620,938 2,000 2,423 73,825 116,290 6,051 899 2,400 38,772 9,068 1,512 1,496 500 4,000 (15) (15) 53,600 (550) 12,472 12,906 (482) 80 (2,400) 3,289 769 71 0.00% 0.00% 0.00% 0.00% -50.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -0.13% 9.45% 0.00% -18.49% 20.33% 12.48% -7.37% 9.80% -50.00% 9.27% 9.27% 0.00% 4.97% 0.00% 0.00% 0.00% Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget GENERAL FUND Description FY 2021 Actual FY 2022 Adopted FY 2022 Amended FY 2022 Projected FY 2023 Adopted Budget vs Budget Net Budget % Change Software & Support Independent Labor Maintenance & Repairs Generator Maintenance & Repairs Building Maintenance & Supplies Cleaning Services Professional Outside Services Utility Billing Contract Telephone Communications/Mobiles Electricity Water Postage Bank Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Elections Advertising Security Miscellaneous Expenses General Manager Contingency Lawn Services Furniture/Equipment < $5000 Uniforms Hardware IT Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing Capital Outlays Copier Lease Installments IGasb34/Reserve for Replacement 96,552 122,310 122,310 105,000 131,700 9,390 7.68% 16,573 15,000 25,000 28,200 15,000 0.00% 94,832 40,000 40,000 46,000 40,000 0.00% 670 3,000 3,000 3,000 3,000 0.00% - - - 0.00% 17,315 12,000 12,000 12,000 12,000 0.00% 103,120 70,281 70,281 75,000 75,040 4,759 6.77% 7,188 9,000 9,000 9,000 9,000 - 0.00% 7,365 8,500 8,500 6,000 6,000 (2,500) -29.41% 2,700 3,000 3,000 3,000 3,000 - 0.00% 13,873 15,213 15,213 15,213 24,369 9,157 60.19% 3,828 5,000 5,000 5,000 5,000 0.00% 21,713 30,000 30,000 30,000 30,000 0.00% 90,222 85,000 85,000 95,000 95,000 10,000 11.76% 10,998 1,500 1,500 1,500 1,500 - 0.00% 80,698 84,000 84,000 84,000 88,200 4,200 5.00% 183 - - - 0.00% 6,017 6,000 6,500 6,500 6,500 500 8.33% 289 4,000 - - 0.00% 3,063 2,000 3,867 40,000 38,000 1900.00% 3,639 5,250 5,250 1,200 3,250 (2,000) -38.10% 304 1,588 1,587 800 1,588 0.00% - - - - - 0.00% 9,330 5,000 12,500 3,765 - (5,000) -100.00% 625 2,500 2,500 9,737 - (2,500) -100.00% 312 - - 0.00% 392 - - 112 - - 0.00% - - - 0.00% 4,012 5,000 5,000 5,000 5,000 - 0.00% - 10,000 10,000 3,284 10,000 0.00% 20,339 530 530 530 530 0.00% 4,682 21,400 21,400 21,400 8,400 (13,000) -60.75% 4,553 6,000 6,000 4,500 6,000 0.00% 123,356 - - 0.00% 3,168 4,000 4,000 5,514 4,000 - 0.00% - - - 0.00% 190,000 190,000 140,000 - (190,000) -100.00% - 4,000 4,000 4,000 4,000 - 0.00% 26,736 26,736 0.00% Subtotal Administration Expenses 1,448, 713 1 1,567,488 1 1,567,488 1 1,490, 506 1 1,534,986 (32,502)1 -2.07%I Non Departmental Expenses Legal (Auditing (Appraisal Tax Admin Fees Subtotal Non Departmental Expenses 42,018 21,000 11,122 3,821 77,961 135,000 100,000 33,800 33,800 12,055 12,055 4,850 4,850 185,705 150,705 60,000 33,800 12,311 3,874 109,985 65,000 33,800 12,940 5,000 116,740 (70,000) 885 150 (68,965) -51.85% 0.00% 7.34% 3.09% -37.14% Total General Fund Revenues $ 9,772,566 $ 10,370,758 $ 10,909,758 $ 11,172,408 $ 11,733,354 $ 1,362,596 13.14% Total General Fund Expenses $ 9,790,401 $ 10,370,758 $ 10,829,758 $ 10,328,819 $ 11,733,354 $ 1,362,596 13.14% Net Budget Surplus (Deficit) $ (17,835) $ 0 $ 80,000 $ 843,589 $ 0 $ - 10 of 19 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget TAX DEBT PAYMENTS LONG TERM TAX DEBT REVENUE DEBT PAYMENTS LONG TERM REVENUE DEBT MUD/PID Reimburse Par Amount Principal FY 2023 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2012 (Tax) MUD $2,355,000 $250,000 $3,750 $3,750 $7,500 $500 $258,000 9/1/2023 9/1/2020 Refund MUD 92 Unlimited Tax Bonds Series 2002 and costs of issuance Series 2013 (Tax) MUD 51,905,000 5215,000 $3,763 $3,763 $7,525 $500 $223,025 9/1/2023 9/1/2023 Refund MUD 92 Unlimited Tax Bonds Series 2003 & Unlimited Tax Refunding Bonds Series 2005 and costs of issuance Series 2020 (Tax) MUD 51,220,000 5115,000 $7,085 $7,085 514,170 $750 $129,920 9/1/2031 9/1/2031 Refund MUD 81 Unlimited Tax Bonds Series 2010 and costs of issuance of the Bonds, Trophy Club Fire Station SUBTOTAL MUD -ONLY TAX BONDS: 55,480,000 5580,000 $14,598 514,598 529,195 51,750 $610,945 Series 2014 (Tax) MUD/PID $5,765,000 $280,000 $59,306 $59,306 5118,613 5400 5399,013 9/1/2034 9/1/2024 Tax Bonds for WWTP Expansion SUBTOTAL MUD/PID TAX BONDS: $5,765,000 $280,000 559,306 559,306 5118,613 5400 5399,013 TOTAL ALL TAX BONDS: $11,245,000 $860,000 $73,904 573,904 $147,808 $2,150 $1,009,958 REVENUE DEBT PAYMENTS LONG TERM REVENUE DEBT CAPITAL LEASE PAYMENTS SHORT TERM REVENUE DEBT Revenue Rates Par Amount Principal FY 2023 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2015 (Revenue) WWTP $9,230,000 $420,000 592,119 592,119 5184,238 $400 $604,638 9/1/2035 9/1/2025 Revenue Bonds for WWTP Expansion Series 2016 (Revenue) SWIFT $4,635,000 $220,000 $27,569 $27,569 555,139 $400 $275,539 9/1/2036 9/1/2027 Revenue Bonds for Fort Worth Line NSII Series 2019 (Revenue) WT & WW $7,080,000 5165,000 5107,069 $107,069 $214,138 $400 $379,538 9/1/2049 9/1/2028 Revenue Bonds for 16in Water Line (77%) Overrun for WWTP Expansion (23%) TOTAL ALL REVENUE BONDS: $20,945,000 $805,000 $226,757 $226,757 $453,514 $1,200 $1,259,714 CAPITAL LEASE PAYMENTS SHORT TERM REVENUE DEBT 11 of 19 Revenue Rates Par Amount Principal FY 2023 Interest 2/01 Interest 8/01 Subtotal Interest Paying Agent Fee Total Payoff Date Reason Department Vaccon Truck (Water usage 43%) 5154,843 531,882 $470 $0 $470 $ - $32,352 2/1/2023 Replacement Water Vaccon Truck (WW usage 57%) $205,257 $42,262 $623 $0 $623 $ - $42,886 2/1/2023 Replacement Wastewater Camera Van 5205,504 $43,504 51,302 $876 $2,178 $ - $45,681 2/1/2024 Replacement Wastewater Total: $565,604 $117,648 $2,395 $876 $3,271 $ - $120,919 11 of 19 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget Annual Long -Term Debt Payments $2,500,000.00 WT & WW REV SERIES 2019 ($7,080,000) WT REV SERIES 2016 $2,000,000.00 - ($4,635,000) $1,500,000.00 - $1,000,000.00 - $500,000.00 - WW REV SERIES 2015 ($9,230,000) UTR GO SERIES 2020 ($1,220,000) ■ UTR GO SERIES 2014 ($5,765,000) ■ UTR GO SERIES 2013 ($1,910,000) ■ UTR GO SERIES 2012 ($2,355000) 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 $140,000.00 $120,000.00 $100,000.00 $80,000.00 $60,000.00 $40,000.00 $20,000.00 $- Annual Capital Lease Payments 2023 2024 CAMERA VAN LEASE 2019 ($210,000) ■ VAC TRUCK LEASE 2018 ($360,100.40) 12 of 19 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget CAPITAL OUTLAYS Department 1 FY 2023 1 FY 2024 1 FY 2025 1 FY 2026 1 FY 2027 Water Water Line Replacement $ 1,400,000 $ 1,442,000 $ 1,485,260 $ 1,529,818 $ 1,575,712 Pump Station Improvements $ 250,000 $ 1,000,000 $ 1,000,000 $ - $ - Fleet Replacement $ 102,000 $ 35,000 $ 41,000 $ - $ - Lift Station Generators $ - $ - $ - $ - $ Water Grand Totals $ 1,752,000 $ 2,477,000 $ 2,526,260 $ 1,529,818 $ 1,575,712 WASTEWATER Wastewater Line Improvements $ 100,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 Lift Station Improvements $ - $ 50,000 $ 50,000 $ 50,000 $ 50,000 Permeate Pump Piping $ 200,000 $ - $ - $ - $ - Lift Station Generators $ 500,000 $ - $ - $ - $ - WWTP Auto Sampler $ 10,000 $ - $ - $ - $ - WWTP VFDs $ 23,000 $ - $ - $ - $ - MBR CIP Tanks and Piping $ - $ 100,000 $ - $ - $ - Crane Pulley $ - $ 35,000 $ - $ - $ - Concrete Repairs $ - $ 35,000 $ - $ - $ - Fleet Replacement $ 62,000 $ 35,000 $ 125,000 $ - $ - $ - $ - $ - $ - Wastewater Grand Totals $ 895,000 $ 755,000 $ 675,000 $ 550,000 $ 550,000 ADMIN $ - $ - $ - $ - $ - $ - $ - $ - $ - $ $ - $ - $ - $ - $ Admin Grand Totals $ - $ - $ - $ - $ - 13 of 19 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget ANNUAL WATER CONSUMPTION AND REVENUE BY YEAR 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 Annual Consumption in (Thousand) Gallons 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $- Annual Water Revenue 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 AVERAGE MONTHLY METERS AND AVERAGE GALLONS BY YEAR 4,900 4,800 4,700 4,600 4,500 4,400 4,300 4,200 4,100 4,000 3,900 Average Monthly Meters 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 24,000 22,000 20,000 18,000 16,000 14,000 12,000 10,000 8,000 6,000 4,000 2,000 Average Monthly Gallons per Meter rt 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 ANNUAL WASTEWATER FLOW AND REVENUE BY YEAR 500,000 400,000 300,000 200,000 100,000 0 Annual WWTP Flow in (Thousand) Gallons 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 14 of 19 $4,500,000 $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $- Annual Wastewater Revenue 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget CERTIFICATE OF RESOLUTION 2022-0921A THE STATE OF TEXAS COUNTIES OF DENTON AND TARRANT I, the undersigned member of the Board of Directors of Trophy Club Municipal Utility District No. 1 of Denton and Tarrant Counties, Texas (the "District"), hereby certify as follows: 1. That I am the duly qualified Secretary of the Board of Directors of the District, and that, as such, I have custody of the minutes and records of the District. 2. That the Board of Directors of the District convened in Open Session at a Regular Meeting on September 21, 2022, at the regular meeting place thereof, and the roll was called of the duly constituted officers and members of the Board of Directors, to wit: Kevin R. Carr President Ben Brewster Vice President Doug Harper Secretary/Treasurer William C. Rose Director Tracey Hunter Director All members of the Board were present except " , thus constituting a quorum. Whereupon, among other business, the following was transacted at such meeting: A RESOLUTION APPROVING THE 2023 FISCAL YEAR BUDGET OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 and duly introduced for the consideration of the Board of Directors of the District. It was then duly moved and seconded that such Resolution be adopted and, after due discussion, such motion, carrying with it the adoption of such Resolution, prevailed, and carried by the following vote: AYES: 1( NAYS: ABSTENSIONS: 3. That a true, full and correct copy of such Resolution adopted at such meeting is attached to and follows this certificate; that such resolution has been duly recorded in the minutes of the Board of Directors for such meeting; that the persons named in the above and foregoing Paragraph 2 were the duly chosen, qualified and acting officers and members of the Board of Directors as indicated therein, that each was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of such meeting, and 15 of 19 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget that such Resolution would be introduced and considered for adoption at such meeting, and that each consented, in advance, to the holding of such meeting for such purpose; that the canvassing of the officers and members of the Board of Directors present at and absent from such meeting and of the votes of each on such motion, as set forth in the above and foregoing Paragraph 2, is true and correct; and that sufficient and timely notice of the hour, date, place and subject of such meeting was given and posted as required by Chapter 551, Texas Government Code, as amended. SIGNED AND SEALED the 21st day of September 2022. Doug Harper, ec etary/T surer Board of Directors Laurie Slaght, District Se 16 of 19 Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget RESOLUTION NO. 2022-0921A A RESOLUTION APPROVING THE 2023 FISCAL YEAR BUDGET OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district of the State of Texas created under Article XVI, Sec. 59 of the Texas Constitution, and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Section 49.057(b) of the Texas Water Code requires the board of directors of a water district to adopt an annual budget; WHEREAS, Title 30, Section 293.97(b), Texas Administrative Code, provides that an operating budget shall be passed and approved by a resolution of the governing board of a water district and shall be made a part of the governing board minutes; and WHEREAS, the Board of Directors of the District desires to adopt a budget for the 2022 fiscal year in an open, public meeting, proper notice of which has been given as required by law. NOW THEREFORE BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1: Section 1. That the facts and recitations found in the preamble of this Resolution are hereby found and declared to be true and correct and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. Section 2. That the annual budget of revenues and expenditures necessary for conducting the operations and affairs of the District for Fiscal Year 2023, attached hereto, and incorporated herein as Exhibit A, is hereby approved and adopted. Said budget document shall be on file for public inspection in the office of the District. Section 3. That the District's expenditures during the fiscal year shall be made in accordance with the approved budget and any amendments thereto approved by the Board of Directors. Section 4. A copy of this Resolution and the budget approved hereby shall be attached to the minutes of the Board's September 21, 2022, meeting. 17 of 19 Section 5. passage. Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget That this Resolution shall become effective immediately upon its RESOLVED, PASSED AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1, this the 21' day of September 2022. Kevin R. Carr, President Board of Directors Doug Harper,, ecretary/Tr surer Board of Directors au ie Slaght, District Secre 18 of 19 o������i�g1 n1JU����ii ���G.••••. '/*i•/ _�—;0 s •. •O C.• r C. -I• _ •• • ��`'�//LD1 i 11' `e\\�.�. Resolution No. 2022-0921A Approving Fiscal Year 2023 Budget EXHIBIT "A" (Approved FY 2023 Budget) 19 of 19