Loading...
HomeMy WebLinkAboutDocumentation_Regular_Tab 11_6/12/2025 Agenda Item #11. Regular Council STAFF MEMO x Meeting: Regular Council - Jun 12 2025 Staff Contact: Jeremy Allen, Village Manager Department: Manager ffWfflWW i Monthly Manager's Report 1. The Financial Reports presented above are unadjusted and unaudited. The Village considers revenues available if collected within 60 days of the current fiscal period. This means that there are additional revenues and expenditures that have not been recorded to date and that will be recorded once year-end adjustments are completed. Additionally, during the year, revenues and expenses are recorded on a modified accrual basis (similar to a cash basis). This will result in significant differences between our beginning balances in the enterprise funds (water, refuse and recycling and stormwater) and the adjusted ending balances as these funds report on a full accrual basis. 2. Property Taxes — collected at $12.5 million, which represents 99% of the budgeted amount. Historically, 91% of ad valorem tax distribution is receipted by the end of February. 3. Sales/use taxes (51%), which include local infrastructure surtax, insurance premium, utility, communication service and local business tax, are one/two months behind collection/reported period, with the exception of the Local Business Tax that are due October 1st and collected at 105%. Insurance premium tax ($370 thousand) to be collected at the year-end as one distribution. Sales/use taxes are on target for seven months' collections. 4. Intergovernmental revenues (57%), which include municipal revenue sharing, half-cent sales tax, and local gas tax are one month behind the collection/reported period and are on a target for seven months' collections. 5. Local discretionary infrastructure surtax(54%) - collected at $283 thousand, which represents 54% of the budgeted amount and is on target for six months' collections. 6. Revenues (Budgetary comparison) recorded in the General fund represent 86% of the budgeted due to the distribution nature of Ad valorem taxes collected at 99%, representing 73% of overall General fund revenues at 5/31/2025. 7. Overall Expenditures (Budgetary comparison) in the General Fund represent 60% of the budget. Not all the expenditure recorded for the services provided for the month of May 2025 and personnel expenditure recorded as paid not when accrued. 8. Revenues (Prior year comparison) all funds increased by $6.3 million(27%) mainly due to Ad valorem taxes collected $1.1 million (10%) higher than same period of prior year, increased land development (246%) and permit (152%) fees for ongoing projects. Also, interfund transfer Page 272 of 426 Agenda Item #11. to Vehicle Replacement fund is recorded in the amount of around $1 million (100%). State revolving fund construction loan for the water utility received in the amount of$1.9 million. 9. Expenditures (Prior year comparison) all funds increased by $2.4 million (14%) increase due to vehicles purchase, water utility capital projects in FY 2025, and interfund transfers recorded earlier in the year. This document and any attachments may be reproduced upon request in an alternative format by completing our Accessibility Feedback Form, sending an e-mail to the Village Clerk or calling 561- 768-0443. BUDGET • • BUDGET AMOUNT NA AMOUNT AVAILABLE NA EXPENDITURE AMOUNT: NA FUNDING SOURCES: NA IS THIS A PIGGYBACK: ❑ Yes ❑ N/A DID YOU OBTAIN 3 QUOTES? ❑ Yes ❑ N/A COMMENTS/EXPLANATION ON SELECTIONNA May 2025 May 2025 Managers Report.ADA - (1) 2Copy of May 2025 Grant Budget Worksheet (1) Full Village Council Discretionary Funds C Page 273 of 426 0ifIt§ti##1 1. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/9 Period Ending 05/31/2025 DB: Teauesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 675,775.05 Investments 13,038,473.93 Accounts Receivable 1,193, 920.85 Due from Other Funds 0.00 Accrued Income Receivable 2, 918.35 Inventories 59,504.65 Prepaids 97,567.68 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 15,068,160.51 *** Liabilities *** Accounts Payable 49.11 Accrued liabilities 1,950.55 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 1,480.13 Deferred Revenue 1,018,714.82 Other Current Liabilities 0.00 Customer Deposits 0.00 Noncurrent liabilities 0.00 Total Liabilities 1,022,194.61 *** Fund Balance *** F/B - Reserved for Inventories 0.00 F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Ncnspendable 761,073.22 Fund Balance - Restricted 301,000.00 Fund Balance - Committed 500,000.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 7,240, 982.07 Total Fund Balance 8,803,055.29 Beginning Fund Balance 8,803,055.29 Net of Revenues VS Expenditures 5,242,910.61 Ending Fund Balance 14,045,965.90 Total Liabilities And Fund Balance 15,068,160.51 Page 274 of 426 0ifIt§ti##1 1. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/9 Period Ending 05/31/2025 DB: Teauesta Fund 101 BUILDING FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 79,876.02 Investments 1,078,247.08 Accounts Receivable 28.47 Inventories (7.38) Prepaids 1,273.67 Total Assets 1,159,417.86 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities (120.00) Due to Other Governments 8,252.38 Total Liabilities 8,132.38 *** Fund Balance *** F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 16,593.86 Fund Balance - Restricted 728, 931.42 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 0.00 Total Fund Balance 745,525.28 Beginning Fund Balance 745,525.28 Net of Revenues VS Expenditures 405,760.20 Ending Fund Balance 1,151,285.48 Total Liabilities And Fund Balance 1,159,417.86 Page 275 of 426 0ifIt§ti##1 1. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/9 Period Ending 05/31/2025 DB: Teauesta Fund 301 CAPITAL IMPROVEMENT FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 649,578.10 Investments 673, 685.19 Accounts Receivable 20,535.57 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 1,343,798.86 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 0.00 Fund Balance - Restricted 401,490.00 Fund Balance - Committed 368,344.94 Fund Balance - Assigned 61, 690.26 Fund Balance - Unassigned 0.00 Total Fund Balance 831,525.20 Beginning Fund Balance 831,525.20 Net of Revenues VS Expenditures 512,273.66 Ending Fund Balance 1,343,798.86 Total Liabilities And Fund Balance 1,343,798.86 Page 276 of 426 0ifIt§ti##1 1. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/9 Period Ending 05/31/2025 DB: Teauesta Fund 303 CAPITAL PROJECTS FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 85,279.14 Investments 443,542.93 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 528,822.07 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 1,388,526.77 Fund Balance - Unassigned 0.00 Total Fund Balance 1,388,526.77 Beginning Fund Balance 1,388,526.77 Net of Revenues VS Expenditures (859,704.70) Ending Fund Balance 528,822.07 Total Liabilities And Fund Balance 528,822.07 Page 277 of 426 0ifIt§ti##1 1. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/9 Period Ending 05/31/2025 DB: Teauesta Fund 401 WATER FUND GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 4,056,457.47 Investments 9,722,401.13 Accounts Receivable 700, 673.53 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Accrued Income Receivable 0.00 Inventories 410,311.49 Prepaids 31,082.80 Other Assets - Current 0.00 Land 83,335.00 Other Assets - Non Current 83,335.00 INFRASTRUCTURE 13,539,107.06 Buildings 178,621.41 Improvements Other Than Bldgs. 17,616.00 Machinery & Equipment 320,873.30 Construction in Progress 2,856,905.43 Intangible Assets 0.00 Other Fixed Assets 0.00 Deferred Outflows 580,862.07 FIXED ASSETS 0.00 Total Assets 32,498,246.69 *** Liabilities *** Accounts Payable 725.33 Accrued liabilities (75.00) Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 303.98 Deferred Revenue 0.00 Current Portion of Debt 445, 914.63 Other Current Liabilities 0.00 Customer Deposits 32,025.00 Noncurrent liabilities 1,125,092.99 Other Long Term Liabilities 457,931.39 Def Inflows of Resources 201,151.00 Total Liabilities 2,263,069.32 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 13, 995,148.87 Net Assets, Restricted 0.00 Fund Balance - Restricted 420, 915.00 Fund Balance - Committed 500,000.00 Fund Balance - Unassigned 12, 655, 682.27 Total Fund Balance 27,571,746.14 Beginning Fund Balance 27,571,746.14 Net of Revenues VS Expenditures 2,663,431.23 Ending Fund Balance 30,235,177.37 Total Liabilities And Fund Balance 32,498,246.69 Page 278 of 426 0ifIt§ti##1 1. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/9 Period Ending 05/31/2025 DB: Teauesta Fund 402 REFUSE & RECYCLING GL Number Description Balance *** Assets *** Cash and Cash Equivalents 86,337.29 Investments 226,339.25 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 312,676.54 *** Liabilities *** Accounts Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** F/B - Unreserved/Undesignated 0.00 Fund Balance - Unassigned 37,098.03 Total Fund Balance 37,098.03 Beginning Fund Balance 37,098.03 Net of Revenues VS Expenditures 275,578.51 Ending Fund Balance 312,676.54 Total Liabilities And Fund Balance 312,676.54 Page 279 of 426 0ifIt§ti##1 1. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/9 Period Ending 05/31/2025 DB: Teauesta Fund 403 STORMWATER UTILITY GL Number Description Balance *** Assets *** Cash and Cash Equivalents 320,384.34 Investments 210,035.95 Accounts Receivable 3,032.89 Due from Other Funds 0.00 Inventories 1,225.21 Prepaids 0.00 Other Assets - Current 0.00 Other Assets - Non Current 0.00 INFRASTRUCTURE 2,465,807.41 Buildings 0.00 Improvements Other Than Bldgs. 0.00 Machinery & Equipment 3,504.65 Construction in Progress 0.00 Deferred Outflows 44,364.00 Total Assets 3,048,354.45 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 0.00 Current Portion of Debt 0.00 Other Long Term Liabilities 39, 999.14 Def Inflows of Resources 12,280.00 Total Liabilities 52,279.14 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 2,031, 685.06 Fund Balance - Unassigned 460,057.87 Total Fund Balance 2,491,742.93 Beginning Fund Balance 2,491,742.93 Net of Revenues VS Expenditures 504,332.38 Ending Fund Balance 2,996,075.31 Total Liabilities And Fund Balance 3,048,354.45 Page 280 of 426 0ifIt§ti##1 1. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 8/9 Period Ending 05/31/2025 DB: Teauesta Fund 501 VEHICLE REPLACEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 169,700.03 Investments 919,542.05 Machinery & Equipment 0.00 Total Assets 1,089,242.08 *** Liabilities *** Accounts Payable 0.00 Total Liabilities 0.00 *** Fund Balance *** N.A., Inv in Cap, net of debt 0.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 0.00 Total Fund Balance 0.00 Beginning Fund Balance 0.00 Net of Revenues VS Expenditures 1,089,242.08 Ending Fund Balance 1,089,242.08 Total Liabilities And Fund Balance 1,089,242.08 Page 281 of 426 0ifIt§ti##1 1. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 9/9 Period Ending 05/31/2025 DB: Teauesta Fund 605 SPECIAL LAW ENFORCEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 153, 906.57 Investments 134,502.18 Accounts Receivable 0.00 Inventories 0.00 Prepaids 0.00 Total Assets 288,408.75 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** Fund Balance - Nonspendable 0.00 Fund Balance - Restricted 257,578.88 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 0.00 Total Fund Balance 257,578.88 Beginning Fund Balance 257,578.88 Net of Revenues VS Expenditures 30,829.87 Ending Fund Balance 288,408.75 Total Liabilities And Fund Balance 288,408.75 Page 282 of 426 Agenda Item #11. VILLAGE OF TEQUESTA Cash& Investments Unadjusted Unaudited 5/31/2025 Cash and cash equivalents Investments Total General Fund 9001 $ 675,775 $ 13,038,474 $ 13,714,249 Building Fund#101 79,876 1,078,247 1,158,123 Capital Improvement Fund 4301 649,578 673,685 1,323,263 Capital Projects Fund#303 85,279 443,543 528,822 Water Utility#401 4,056,457 9,722,401 13,778,859 Refuse &Recycling#402 86,337 226,339 312,677 Stormwater#403 320,384 210,036 530,420 Vehicle Replacement#501 169,700 919,542 1,089,242 Special Law Enforcement#605 153,907 134,502 288,409 Total Cash and Investments $ 6,277,294 $ 26,446,770 $ 32,724,064 *Interfund transfer pending Page 283 of 426 VILLAGE OF TEQUESTA Agenda Item #11. REVENUE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 5/31/2024 5/31/2025 VARIANCE I %VARIANCE NOTES REVENUES Fund 001-GENERAL FUND General Property Taxes 11,334,881 12,468,773 1,133,891 10.00%Ad Valorem taxes increase Sales&Use Taxes 698,704 701,188 2,484 0.36% Franchise fees-gross receipt 335,404 316,402 (19,002) -5.67% Licenses&Permits 3,500 4,620 1,120 32.00% Rental and misc permits Grants-Federal 0 2,069 2,069 100.00% Differs from year to year Grants-State 24,144 27,451 3,306 13.69% Differs from year to year Intergovernmental Revenue 659,183 630,359 (28,824) -4.37% Chgs for Services-Gen Gov 155,643 537,952 382,309 245.63% Land development fees based on the projects Indirect Costs 601,994 606,985 4,991 0.83% Rents&Royalties 193,804 186,628 (7,176) -3.70%Timing in cell tower leases revenue recording Contributions&Donations 1,450 13,874 12,424 856.84% Bricks engravings Miscellaneous Revenues 20,891 63,008 42,117 201.60% Differs from year to year,insurance reimbursements Chgs for Services-Public Safety 720,238 1,061,977 341,739 47.45% EMS fees collection increase Fines&Forfeitures 9,878 30,649 20,770 210.26% Code enforcement fins&fees collection increase Impact Fees 11,154 2,127 (9,027) -80.93% Differs from year to year based on the projects Charges for Services-Recreation 123,770 141,093 17,323 14.00%Tequesta Fest and rec program fees increase Grants&Contributions-Local 19,267 5,081 (14,186) -73.63% Differs from year to year Unrestricted Investment Earning 383,238 2S2,466 (130,773) -34.12% Unrealized appr,rate decrease,FY202S-1/month behind Other Financing Sources 50,664 35,231 (15,433) -30.46% Disposition of assets,differs from year to year Total General Fund 1S,347,807 17,087,932 1,740,125 11.34% Fund 101-BUILDING FUND Licenses&Permits 445,551 1,120,910 675,359 151.58%Varies year to year based upon activity/projects Charges for Services 1,214 3,018 1,804 148.56%Admin fees from other gov,based on permit collections Miscellaneous Revenues 2 213 211 14073.33% Differs from year to year Unrestricted Investment Earning 29,395 22,761 (6,635) -22.57% Interest rate decrease,FY2025 one month behind Total Building Fund 476,162 1,146,902 670,739 140.86% Fund 301-Capital Improvement Fund Sales&Use Taxes 477,924 504,147 26,222 5.49% Unrestricted Investment Earning 38,564 21,040 (17,524) -45.44% Interest rate decrease,FY2025 one month behind Other Financing Sources 80,496 0 (80,496) -100.00% Financed purchase in FY 2024,tasers Total Capital Improvement Fund 596,985 525,187 (71,798) -12.03% Fund 303-Capital Projects Fund Unrestricted Investment Earning 8,187 23,513 15,327 187.22% Investment balance increase Total Capital Projects Fund: 8,187 23,513 15,327 187.22% Fund 401-Water Fund Miscellaneous Revenues 32,176 4,751 (27,425) -85.24% Differs from year to year,Tropic Vista asessment paid off Grants-State 2,456 0 (2,456) -100.00% Differ from year to year Unrestricted Investment Earning 316,390 217,004 (99,386) -31.41% Unrealized appr,rate decrease,FY2025-1/month behind Other Financing Sources 48,831 1,901,663 1,8S2,832 3794.36% Loan proceeds received-State revolving fund loan Charges for Services 5,208,644 5,654,648 446,004 8.56% Total Water Fund: 5,608,497 7,778,065 2,169,568 38.68% Fund 402-Refuse&Recycling Unrestricted Investment Earning 8,661 7,294 (1,366) -15.78% Rate decrease,FY2025 one month behind Charges for Services 577,610 698,157 120,547 20.87% Non Ad Valorem charges increase Total Refuse&Recycling: 586,270 705,451 119,181 20.33% Fund 403-Stormwater Utility Miscellaneous Revenues 5,515 10,000 4,485 81.32% Differ from year to year Grants-State 0 145,000 145,000 100,00% Differ from year to year Unrestricted Investment Earning 9,966 7,280 (2,687) -26.96% Interest rate decrease,FY2025 one month behind Other Financing Sources 0 5,950 5,950 100,00% Disposition of assets Charges for Services 527,520 557,036 29,517 5.60% Nan Ad Valorem charges increase Total Stormwater Utility: 543,001 725,266 182,265 33.57% Fund 501-Vehicle Replacement Intragovernmental Revenue 0 332,031 332,031 100.00% New fund created FY 2025 Unrestricted Investment Earning 0 16,953 16,953 100.00% New fund created FY 2025 Transfers in 0 1,049,790 1,049,790 100.00% New fund created FY 2025 Total Vehicle Replacement 0 1,398,774 1,398,774 100.00% Fund 605-Special Law Enforcement Miscellaneous Revenues 0 14S 14S 100.00% Differ from year to year Forfeitures 7,543 122,606 115,063 1525.50% Differ from year to year Unrestricted Investment Earning 8,388 5,251 (3,136) -37.39% Interest rate decrease,FY202S one month behind Total Special Law Enforcement 15,930 128,003 112,072 703.52% TOTAL REVENUES-ALL FUNDS 23,182,839 29,S19,093 6,336,2S4 27.33% 426 NOTES are for differences grater than 10%and amounts over$1,000. VILLAGE TEQUESTA Agenda Item #11. EXPENDITURE REPORTO-FCASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE % DESCRIPTION 5/31/2024 5/31/2025 VARIANCE VARIANCE NOTES EXPENDITURES Fund 001-GENERAL FUND Council 50,949 40,648 (10,301) -20.22% Comp system maint&supply decrease Manager 248,752 230,618 (18,134) -7.29% Retirement leave payout in FY 2024 Human Resources 286,375 315,602 29,227 10.21% P/T salaries and other contractual svcs Village Clerk 281,232 280,381 (851) -0.30% Finance 539,044 550,268 11,224 2.08% Legal 138,979 67,150 (71,830) -51.68% Differs from year to year based upon service needs Comprehensive Planning 192,759 199,202 6,443 3.34% General Government 200,826 451,577 250,750 124.86% Vehicle replacement svc charge implemented FY 25 IT 413,391 483,942 70,551 17.07% Comp system maint&supply increase Police Department 2,403,583 2,717,533 313,950 13.06% Reg&O/T disaster pay,pension contrib,comp.absenses Code Compliance 31,871 65,044 33,173 104.08% Full-time position filled in FY 25 Fire Control 3,658,951 3,249,497 (409,453) -11.19% Vehicles FY2024$736K,reg.salaries,O/T incr.,comp.abs. Public Works 987,806 1,054,741 66,935 6.78% Leisure Services 883,963 906,208 22,245 2.52% Debt Service 524,222 482,821 (41,401) -7.90% Debt service paid off Interfund Transfers 0 749,790 749,790 100.00% Transfers to Vehicel replacement fund recorded Total General Fund 10,842,704 11,845,022 1,002,318 9.24% Fund 101-BUILDING FUND Building Department 695,801 666,142 (29,659) -4.26% Interfund Transfers 0 75,000 75,000 100.00% Transfer to Vehicle Replacement Fund Total Building Fund 695,801 741,142 45,341 6.52% Fund 301-Capital Improvement Fund General 6,975 787 (6,188) -88.72% Capital projects varies year to year Public Works 478,161 0 (478,161) -100.00% Capital projects varies year to year Parks 9,466 0 (9,466) -100.00% Capital projects varies year to year Tequesta Bridge 0 12,126 12,126 100.00% Capital projects varies year to year Miscellaneous projects 309,322 0 (309,322) -100.00% Capital projects varies year to year Total Capital Improvement Fund: 803,924 12,913 (791,011) -98.39% Fund 303-Capital Projects Fund Public Works 0 308,494 308,494 100.00% Capital projects varies year to year Parks 81,903 574,724 492,821 100.00% Capital projects varies year to year Total Capital Projects Fund: 81,903 883,218 801,315 100.00% Fund 401-Water Fund Water-Administration 1,107,069 1,222,740 115,671 10.45% Reg.salaries,P/T positions,management fees Water- Production 1,389,529 1,435,421 45,891 3.30% Water-Distribution 540,231 581,391 41,160 7.62% Water-Customer Service 209,077 233,820 24,743 11.83% Bad debt/write off accounts,health ins. Renewal&Replacement 425,522 403,156 (22,366) -5.26% Differs from year to year based upon projects Capital Improvements 295,200 704,267 409,067 138.57% Differs from year to year based upon projects Debt Service 308,268 308,839 571 0.19% Interfund Transfers 0 225,000 225,000 100.00% Transfers to Vehicel replacement fund recorded Total Water Fund: 4,274,896 5,114,634 839,738 19.64% Fund 402-Refuse&Recycling Refuse and Recycling 358,028 429,873 71,845 20.07% WM fees increase for automated trash pickup Total Refuse&Recycling: 358,028 429,873 71,845 20.07% Fund 403-Stormwater Utility Storm Water Utilities 194,716 158,156 (36,560) -18.78% Timing in recording drainage maint&engineering exp Renewal&Replacement 0 62,778 62,778 100.00% Differs from year to year based upon projects Total Stormwater Utility: 194,716 220,934 26,218 13.46% Fund 501-Vehicle Replacement General Government 0 309,532 309,532 100.00% Vehicles purchase Total Vehicle Replacement 0 309,532 309,532 100.00% Fund 605-Special Law Enforcement Police 40,787 97,173 56,386 138.24% P/T police officer,marine unit operations&furniture Total Special Law Enforcement: 40,787 97,173 56,386 138.24% TOTAL EXPENDITURES-ALL FUNDS 17,292,759 19,654,439 2,361,680 13.66% NOTES are for differences grater than 10%and amounts over$1,000. Page 285 of 426 THE VILLAGE OF TEC UESTA Agenda Item #11, REVENUE REPORT-CASH BASIS,UNAUDITED FY 1015 FY 1015 66.67% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 5/31/2025 VARIANCE VARIANCE USED NOTES Fund 001-GENERAL FUND General Property Taxes 12,603,668 12,603,668 8,402,445 12,468,773 4,066,327 48.39% 98.93 Historically,91 receiptedby the end ofFeb State revs one month behind,record-cash basis,ins prom Sales&Use Taxes 1,498,293 1,498,293 998,862 701,188 (297,674) -29.80% 46.80 tax received as one distrm at FYe i$307Ki Franchise fees-gross receipt 614,820 614,820 409,880 316,402 (93,478) -22.81% 51.46 One month behind Licenses&Permits 9,000 9,000 6,000 4,620 (1,380) -23.00% 51.33 Special events,vacational rental permits Indirect Costs 910,478 910,478 6D6,985 606,985 0 0.00% 66.67 Grants Federal 2,500 2,500 1,667 2,069 403 24.16% 82.77 Differ from year to year,timing of collection Grants-State 61,728 91,728 61,152 27,451 (33,701) -55.11% 29.93 Differfrom yearboyear,timing of collection Intergovernmental Revenue 1,105,205 1,105,205 736,803 630,359 (106,445) -14.45% 57.04 Revs one month behind Grants and Contributions-Local 10,000 10,000 6,667 5,081 (1,585) -23.78% 50.81 Differfrom year to year,timing of collection Chgs for Services-Gen Gov 345,956 345,956 230,637 537,952 307,314 133.25% 155.50 Land devfees Chgs for Services-Public Safety 1,270,976 1,420,976 947,317 1,061,977 114,660 12.10% 74.74 EMS fees collection increase Charges for Services-Recr. 113,515 113,515 75,677 141,093 65,417 86.44% 124.29 Teq fest fees,roc programs,other rec fees increase Fines&Forfeitures 13,585 13,585 9,057 30,649 21,592 238.41% 225.61 code enf fines&fees collections increase Unrestricted Investment Earning 280,500 402,243 268,162 252,466 (15,696) -5.85% 62.76 One month behind,above budgeted Rents&Royalties 148,482 148,482 98,988 186,628 87,640 88.54% 125.69 Cell tower leases rev recorded In full Im pact Fees 4,500 4,500 3,000 2,127 (873) -29.11% 47.26 Differ from yr to yr depending on projects/permits Contributions&Donations 2,000 2,000 1,333 13,874 12,541 940.56% 693.71 Differfrom yeartoyear,bricks engravings Miscellaneous Revenues 5,000 15,000 10,000 63,008 53,008 530.08% 420.05 Differ from year to year,insclaims,legal settlements Other Financing Sources 10,000 10,000 6,667 3S,231 28,564 428.47% 3S2.31 Assets disposition,differs from year to year Appropriate Fund Balance 500,000 500,000 0 Total General Fund 19,510,206 19,821,949 12,881,299 17,087,932 4,206,633 32.66% 86.21 Fund 101-BUILDING FUND Licenses&Permits 608,708 608,708 405,805 1,120,910 715,105 176.22% 184.15 variesyearto year based upon activity/projects Chgs for Sery-Gen Gov 0 0 0 3,018 3,018 100.00% 100.00 Admin fees from other gov Unrestricted Investment Earning 25,003 25,003 16,669 22,761 6,092 36.55% 91.03 Rev recording one month behind,above budgeted Miscellaneous Revenues 0 0 0 213 213 100.00% 0.00 Appropriate Fund Balance 618,094 618,094 0 0 Total Building Fund 1,251,805 1,251,805 422,474 1,146,902 724,428 171.47% 91.62 Fund 301-Capital Improvement Fund Sales&Use Taxes 850,467 850,467 566,978 504,147 (62,832) -11.08% 59.28 State revs two month behind Grants-State 340,884 340,884 0 0 0 100.00% 0.00 Differfrom yeartoyear,timing ofcollection Unrestricted Investment Earn 25,000 25,000 16,667 21,040 4,373 26.24% 84.16 Investment balance increase Total Capital Improvement Fund: 1,216,351 1,216,351 583,645 525,187 (58,458) -10.02% 43.18 Fund 303-Capital Projects Fund Grants-State 162,500 162,500 108,333 0 (108,333) -100.00% 0.00 Differfrom yeartoyear,timing ofcollection Unrestricted Investment Earning 9,000 9,000 6,000 23,513 17,513 291.89% 261.26 Investment balance increase Transfers In 1,280,210 1,280,210 853,473 0 (853,473) -100.00% 0.00 FY 2025 not recorded,timing in recording Appropriate Fund Balance 249,790 249,790 0 Total Capital Projects Fund: 1,701,500 1,701,500 967,807 23,513 (944,293) -97.57% 0.00 Fund 401-Water Fund Charges for Services 9,380,856 9,380,856 6,253,904 5,654,648 (599,256) -9.58% 60.28 Rev recording one month behind,above budgeted Unrestricted Investment Earn 250,000 250,000 166,667 217,004 50,337 30.20% 86.80 One month behind,above budgeted Miscellaneous Revenues 37,272 37,272 24,848 4,751 (20,097) -80.88% 12.75 Differ from year to year Other Financing Sources(icl.loan) 10,020,000 10,805,000 7,203,333 1,901,663 (5,301,670) -73.60% 17.60 Loan proceeds,partial loan receipt Appropriate Fund Balance 2,075,949 2,075,949 0 0 Total Water Fund: 21,764,077 22,549,077 13,648,752 7,778,065 (5,870,687) -43.01% 34.49 Fund 402-Refuse&Recycling Charges for Services 718,573 718,573 479,049 698,157 219,108 45.74% 97.16 Historically,91%receiptedby the end ofFeb Unrestricted Investment Earn 7,500 7,500 5,000 7,294 2,294 45.89% 97.26 Rev recording one month behind,above budgeted Appropriate Fund Balance 16,920 16,920 0 0 Total Refuse&Recycling: 742,993 742,993 484,049 705,451 221,403 45.74% 94.95 Fund 403-Stormwater Utility Grants State 194,500 194,500 129,667 145,000 15,333 11.83% 74.55 Differfrom yeartoyear,timing ofcollection Grants&Contributions-Local 63,000 63,000 42,000 0 (42,000) -100.00% 0.00 Timing in revenue recording Charges for Services 570,600 570,600 380,400 557,036 176,636 46.43% 97.62 Historically,91%receipted by the end of Feb Unrestricted Investment Earn 8,500 8,500 5,667 7,280 1,613 28.47% 85.64 Rev recording one month behind,above budgeted Other Financing Sources 0 0 0 5,950 5,950 100.00% 100.00 Disposition offi.ed as sets Miscellaneous Revenues 0 0 0 10,000 10,000 100.00% 100.DD Differ from year to year Total Stormwater Utility: 836,600 836,600 557,733 725,266 167,533 30.04% 86.69 Fund 501-Vehicle Replacement Intragovernmental Revenue 498,046 498,046 332,031 332,031 0 0.00% 66.67 Unrestricted Investment Earn 0 0 0 16,953 16,953 100.00% 100.DD Rev recording one month behind,above budgeted Transfers In 1,049,790 1,049,790 699,860 1,049,790 349,930 50.00% 100.00 FY 2025 transfers recorded in full Total Vehicle Replacement 1,547,836 1,547,836 1,031,891 1,398,774 366,883 35.55% 90.37 Fund 605-Special Law Enforcement Forfeitures 126,009 126,009 84,006 122,606 38,600 45.95% 97.31) Differfrom year to year,timing of collection Unrestricted Investment Earn 5,000 5,000 3,333 5,251 1,918 57.54% 105.03 Rev recording one month behind,above budgeted Miscellaneous Revenues 0 0 0 145 145 100.00% 100.00 Differ from year to year Appropriate Fund Balance 0 15,000 0 Total Special Law Enforcement 131,009 146,009 87,339 128,003 40,663 46.56% 0.00 TOTAL REVENUES-ALL FUNDS 48,702,377 49,814,120 30,664,989 29,519,093 (1,145,896) -3.74% 59.26 Page 286 of 426 NOTES are for differences grater than 10%and amounts over$1,000. THE VILLAGE OF TEQUESTA A EXPENDITURE REPORT-CASH BASIS,UNAUDITED FY 2021 FY 2021 66.67% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 5/31/2025 VARIANCE VARIANCE USED Fund 001-General Fund Council 101,091 101,091 67,394 40,648 26,746 39.69% 40.21(1),(2) Manager 381,662 381,662 254,441 230,618 23,823 9.36% 60.42(1),(2) Human Resources 501,502 501,502 334,335 315,602 18,733 5.60% 62.93(1),(2) Village Clerk 464,414 464,414 309,609 280,381 29,228 9.44% 60.37(1),(2) Finance 842,590 842,590 561,727 550,268 11,459 2.04% 65.31 Legal 246,500 246,500 164,333 67,150 97,184 59.14% 27.24(1),(2) Comprehensive Planning 409,622 409,622 273,081 199,202 73,879 27.05% 48.63(1),(2) General Government 770,667 770,667 513,778 451,577 62,201 12.11% 58.60(p,(z) IT 612,423 612,423 408,282 483,942 (75,660) -18.53% 79.02(3) Police Department 4,357,428 4,459,171 2,972,781 2,717,533 255,248 8.59% 60.94(1),(2) Code Compliance 138,325 138,325 92,217 65,044 27,173 29.47% 47.02(1),(2) Fire Control 5,012,483 5,440,534 3,627,023 3,249,497 377,525 10.41% 59.73(1),(2) Public Works 1,796,551 1,852,022 1,234,681 1,054,741 179,940 14.57% 56.95(1),(2) Leisure Services 1,284,680 1,284,680 856,453 906,208 (49,755) -5.81% 70.54(3) Debt Service 487,300 487,300 324,867 482,821 (157,954) -48.62% 99.08(3) Interfund Transfers 2,030,000 1,8D1,949 1,201,299 749,790 451,509 37.59% 41.61(3) Allocate to Fund Balance* 72,968 72,968 Total General Fund 19,510,206 19,867,420 13,244,946 11,845,022 1,399,925 10.57% 59.62 Fund 101-BUILDING FUND Building&Zoning 1,176,805 1,187,805 791,870 666,142 125,728 15.88% 56.08(1),(2) Interfund Transfers 75,000 75,000 50,000 75,000 25,000 50.00% 0.00 Total Building Fund 1,251,805 1,262,805 841,870 741,142 100,728 11.96% Fund 301-Capital Improvement Fund General 103,000 103,000 68,667 787 67,880 98.85% 0.76 (2),(3) Parks 931,768 931,768 621,179 0 621,179 100.00% 0.00 (2),(3) Tequesta Drive(Bridge) 100,000 100,000 66,667 12,126 54,541 81.81% 12.13 (2),(3) Allocate to Fund Balance* 81,583 81,583 0 Total Capital Improvement Fund: 1,216,351 1,216,351 810,901 12,913 797,988 98.41% 1.06 Fund 303-Capital Projects Fund Public Works 880,000 1,197,831 798,554 308,494 490,059 61.37% 25.75 (2),(3) Leisure Services 275,000 1,124,887 749,924 574,724 175,201 23.36% 0.00 (2),(3) Allocate to Fund Balance* 546,500 546,500 0.00 Total Capital Projects Fund: 1,701,500 2,869,217 1,912,811 883,218 1,029,593 53.83% 30.78 Fund 401-Water Fund Water-Administration 1,961,397 1,984,919 1,323,279 1,222,740 100,540 7.60% 61.60 Water- Production 2,408,397 2,408,397 1,605,598 1,435,421 170,177 10.60% 59.60 Water-Distribution 976,067 976,067 650,711 581,391 69,321 10.65% 59.56 Water-Customer Service 337,316 337,316 224,877 233,820 (8,943) -3.98% 69.32 Renewal&Replacement 4,243,000 4,548,802 3,032,535 403,156 2,629,378 86.71% 8.86 (2) Capital Improvement 11,120,000 13,177,108 8,784,739 704,267 8,080,472 91.98% 0.00(2) Debt Service 492,900 492,900 328,600 308,839 19,761 6.01% 62.66 Interfund Transfers 225,000 225,000 150,000 225,000 (75,000) -50.00% 100.00 Total Water Fund: 21,764,077 24,150,509 16,100,339 5,114,634 10,985,705 68.23% 21.18 Fund 402-Refuse&Recycling Refuse and Recycling 742,993 742,993 495,329 429,873 65,456 13.21% 57.86 Total Refuse&Recycling: 742,993 742,993 495,329 429,873 65,456 13.21% 57.86 Fund 403-Stormwater Utility Storm Water Utilities 283,289 288,188 192,125 158,156 33,969 17.68% 54.88 Renewal&Replacement 430,152 430,152 286,768 62,778 223,990 78.11% 14.59 (2),(3) Allocate to Fund Balance* 123,159 123,159 0 0 Total Stormwater Utility: 836,600 841,499 560,999 220,934 340,066 60.62% 26.25 Fund 501-Vehicle Replacement General Government 350,000 350,000 233,333 309,532 (76,198) -32.66% 88.44 TPD cars purchase Building 45,000 45,000 30,000 0 30,000 100.00% 0.00 Renewal&Replacement 172,500 172,500 115,000 0 115,000 100.00% 0.00 Other Nonoperating 980,336 98D,336 653,557 0 653,557 100.00% 0.00 Total Vehicle Replacement 1,547,836 1,547,836 1,031,891 309,532 722,359 70.00% 20.00 Fund 605-Special Law Enforcement Police 131,009 146,009 97,339 97,173 167 0.17% 100.D0 (2) Total Special Law Enforcement 131,009 146,009 97,339 97,173 167 0.17% 100.D0 TOTAL EXPENDITURES-ALLFUNDS 48,702,377 52,644,639 35,096,426 19,654,439 15,441,987 44.00% 37.33 Notes: *Not included in Target Budget calculation (1)Personal expenditures/expenses recorded as when paid not when accrued.Personnel paid 5/22/25 for the period ended 5/17/25. Due to timing of payroll dates 14 days of personnel expenditures not reflected in May 2025. (2)Not all operating expenditures/expenses recorded for the services of May 2025.Expenditures recorded on a cash basis and adjusted to accrual at year end. (3)Timing in expenditures/expenses recording and/or recorded as one time entry at year end. Page 287 of 426 Agenda Item #11. May 2025 Department Reports Current Month 2024/2025 2023/2024 2022/2023 Building Department Current Month 2024/2025 2023/2024 2022/2023 Total Master Permits and subpermits Issued 115 462 1516 1372 New Residential Construction Permits 1 2 12 5 Residential Remodel and additions Permits 15 58 79 874 Commercial Remodel and additions Permits 1 7 16 56 Residential Plan Reviews 108 418 1379 1074 Commercial Plan Reviews 7 44 137 56 Total Inspections 302 1350 4698 3483 BTR Inspections 2 9 18 Trade Inspections 96 516 1300 Vacation Rentals Inspections 2 4 24 Certificates of Compliance 113 336 234 267 Certificates of Ocupancy 1 1 Record Requests 17 93 260 246 Permit/Code Information Requests 41 142 417 308 Meetings/Training 3 9 19 30 BCAIB-BOAF-BOATC/DBPR Meetings 3 9 16 22 LPA 0 3 3 24 Code Enforcement Current Month 2024/2025 2023/2024 2022/2023 Code Enforcement Inspections 27 135 253 175 Notices of Violation Issued 3 24 69 34 Code Cases Opened 26 48 176 131 -By code officer 24 52 54 -Reactive 2 6 12 Code Cases Closed 37 11 99 101 Code Cases Cleared Within 30 Days 33 11 71 79 Code Cases Scheduled for Hearing 0 14 12 17 Magistrate Meeting 0 41 6 4 Meeting With Residents Regarding Violations 46 2721 340 168 Community Development Current Month 2024/2025 2023/2024 2022/2023 Land Development Applications 1 13 28 63 Ongoing Projects 18 85 125 106 Development Order Time Extensions 0 0 1 1 Public Records Requests 7 27 40 38 Major Meetings and Conference Calls 18 92 109 100 Residents/Business Owners 17 81 101 59 DRC Meeting 0 1 4 6 Permits(New Single Family and Commercial) 3 14 24 22 Phone Calls/Emails/Walk-Ins 85 495 1235 3276 Totals Totals Fire Current Month 2024/2025 2023/2024 2022/2023 Unit Response Data Fire 15 102 38 119 EMS 91 762 262 1,159 Special Operations 0 11 5 26 Other 4 42 21 58 Mutual Aid Given-Palm Beach County and Martin County Fire Rescue 9 130 42 223 Mutual Aid Received- Palm Beach County/Martin County Fire Rescue 12 1071 31 164 COVID 0 01 0 4 Page 288 of 426 Agenda Item #11. Inspection Data New Construction 2 30 8 69 Annual Fire 33 271 100 345 New Business/New Occupation/Home Business 7 21 7 23 Re-Inspections 14 155 69 226 Food Truck/Tents 2 13 5 19 Public Relations Events Data Community Function Hours 10 370 255 656 Training 812 6,530 2,589 9,017 Overtime As of 5/31/2025 Actual Budget Goal/Actual% Overtime Budget $ 164,544.00 64.36% 100%/30.85% 100%/100.06 YTD Human Resources&Risk Management Current Month 2024/2025 2023/2024 2022/2023 Open Positions 1 14 16 15 Applications Received 58 453 573 511 Onboardings-Hires 2 10 30 12 Offboardings-Terms 2 8 15 10 Payroll Authorizations& Evaluations 3 93 339 96 FMLA Requests 1 11 19 12 Work Comp Claims/FF Cancer Claims 1 12 17 13 Labor Relations(Grievances/Arbitrations/Negotiations etc) 6 17 48 23 Records Requests 1 12 31 13 HR Information System Adjustments 693 6123 11,666 6816 Safety Meetings and Assessments 0 4 5 4 Auto, Property, Liability Claims 3 5 7 8 Totals IT Current Month 2024/2025 2023/2024 2022/2023 Helpdesk Tickets 136 714 1460 1456 Projects M365 Migration Budget Parks and Recreation Current Month 2024/2025 2023/2024 2022/2023 Recreation Programs All Programs 270 3192 Summer Camp 0 0 0 1350 Kids Night Out At The Rec 0 37 13 30 Gymnastics 1 237 1896 3167 10267 Facility/Field Rentals for Tequesta Park/Constitution Park/Recreation Center Rentals Constitution Park Pavilion Rentals 27 209 76 77 Recreation Center Facility Rentals (Include JTAA, HOA,Good Sheppard,etc.. 15 40 Field Reservations(#of times not estimated attendance) 25 141 Special Events Food Truck 0 800 800 4800 Tequesta Roots Festival 0 1200 1500 1500 Holiday In The Park 0 1200 1200 1200 Santa Ride 0 700 700 700 Letters to Santa 0 40 40 45 Bridge The Gap 0 0 0 1500 Movie In The Park 0 0 0 0 Pickleball Tournment 0 0 0 0 Run 4 The Pies 1 0 0 1800 1700 Freedom Run 0 0 0 650 Page 289 of 426 Agenda Item #11. Bunny Hop 0 500 500 500 Earth Day Celebration 0 0 0 0 Totals Police Current month 2024/2025 2023/2024 2022/2023 Communication Division Officer Initiated Calls 1791 10,486 12226 Calls for Service 118 2,647 2776 Fire Rescue 27 282 237 Patrol Division Reports Filed 21 346 371 Arrest 1 40 45 Crashes Investigated 12 122 143 Traffic Stops 50 1,789 2855 Citations 8 588 747 Warnings 15 751 1695 Administration Public Records Request 47 547 474 Overtime Actual Budget Goal/Actual% Operations $ 86,546.03 65.5%/66.7% Totals Totals Public Works Current month 2024/2025 2023/2024 2022/2023 Equipment Maintenance 8 37 119 95 Sidewalk Repairs and or Grinding 10 18 58 57 Street Signs Replaced 6 34 90 81 Road Repairs 3 12 29 26 Indoor/Outdoor lights Repaired 4 13 119 89 Street Light Outages 1 14 137 121 Work Orders 272 1480 5142 4154 Standby Generator Maintenance 14 64 190 160 Fleet Maintenance-Vehicles Serviced 3 14 115 83 Surplus-Junked or Sold lems 1 19 69 68 Engineering Services 4 9 45 40 Resident Calls 9 48 258 194 Projects 10 89 212 163 Totals Totals Village Clerk's Office MAY 2024/2025 2023-2024 2022-2023 Agendas Compiled and Distributed 1 40 46 Minutes Completed (includes council,committees,spec meetings) 1 40 46 Council,Committee,Spec Magistrate,and Special Meeting Hours 4 64 89.75 Orders Processed 1 21 26 Resolutions Processed 1 25 21 Ordinances Processed 0 12 15 Agreements Processed 5 97 135 Public Records Processed 30 371 303 Agenda/Minute Portal (iCompass)Total Monthly Visits 2710 25371 25622 Agenda/Minute Portal (iCompass) Unique Monthly Visits 1705 18733 19998 Public Information Officer Social Media Post(Number of Post to all social) 38 Content Interaction (Likes,shares,comments, etc) 344 410 557 Facebook Messenger Responses(this does not include post responses) 10 61 59 Website:VOTBot(Artificial Intelligence Quesitons Answered) 70 1 10291 1215 Page 290 of 426 Agenda Item #11. Press Releases 0 4 8 CodeRed Messages Launched 6 59 60 Tequesta News Messages(Friday Newsletter) 5 42 45 Departmental/Other Project Videos/Reels 2 3 8 Smoke Signals 1 4 4 Elections Election: Campaign Treasurer Reports/Candidate Documentation/Office Report 0 3 9 Election: Review Candidate Handbook 0 3 11 Election: Process filing/qualifying paperwork 0 21 6 Clerk&Public Information Officer Events&Meetings: ELECTIONS: Monitoring proposed legislation. SOCIAL MEDIA:May 8 agenda (997 views), Mobility Plan (1.3K views) ASSISTANCE: Provided assistance to departments for CivicPlus(website), iCompass(agenda software)and JustFOIA(public records software)and video production. MEETINGS/TRAINING: Continued preparations for the Palm Beach County League of Cities luncheon PARTNERSHIPS: N/A WEBMASTER: Serves as the Village's Webmaster and makes changes and updates as necessary,trains and assists staff and other departmental employees on website usage and tasks. Responded to and trained VOTBot(AI) online inquiries. PUBLIC INFORMATION OFFICER: Attended PBCLOC Luncheon Installation for Mayor and published writeup. Internal branding project kick-off with Clerk team to standardize publications. Compiled Smoke Signals for publication in May. Udated lobby TV as needed.Attended PIO-Co-op Meeting.Answered PIO questions for various departmetnal PIO liaisons. MISC: Noticed meetings and ordinances via the public notice portal and mailed and emailed to residents who requested per state law. Participated in International Day ceremonies. Provided research for department heads/manager. Processed records management disposition forms, processed oaths, proclamation,and declarations. Trained new employees/set up required software credentials: JustFOIA, iCompass,website, DemandStar,CivicOptimize etc. Created new accounts and established workflows for new employees. Ordered office supplies and Amazon orders for Admin and Historicals, meeting setup/breakdown. Processed daily lien reports, invoices,council mail,admin phone support,Oaths and swearing in of new committee members and employees. Current Month 2024/25 YTD 2023/24 YTD Utilities Department-Water Distribution (FY24) Water Main Breaks(* FY21&FY22 service line breaks combined w/water line breaks) 0 3 4 Service Line Breaks(* FY21&FY22 service line breaks combined w/water line breaks) 1 0 1 17 Line Maintenance 75 503 576 Meter Reader Related Work Orders 0 23 120 Work Orders(Non Meter)/Stormwater:Catchbasins,Outfalls,Pond Mowing&Inspections,el 181 544 756 Employee Call Back 3 64 84 Meter Set/Changed Out 5 64 88 Utilities Department-Customer Service Current Month 2023/2024 2022/23(FY22) Leak Adjustment Requests 2 180 (not counted) *Utility Billing/Customer Service dashboard in monthly report for Council Utilities Department-Water Production Current Month 2025 YTD CalendarYr24**YT Calendar Yr23**YTD Water Production Total(million gallons(MG)) 104.023 455.928 999.482 992.777 Maximum Day Production Demand Rate(million gallons per day(MGD)) 3.770 4.015 3.876 3.71 Average Daily Production Demand(MGD) 3.356 2.941 2.738 2.72 Monthly Rainfall 3.18 21.98 77.17 106.64 **-SFWMD water use permits(WUP)are based on a"water year"which is a calendar year;we are permitted based on the calendar year.Our maximum permitted annual daily production is 6.3 MGD with a total permitted quantity of 401 MG from the Surficial aquifer and 1251 MG from the upper Floridan aquifer Projects: see monthly Utilities Department report on Village Council agenda Page 291 of 426 Agenda Item #11. n gin uQF VC 2 2 Page 292 of 426 E nsanea Item xn. LO U � 0 � CDCN N � O CN CD � U N 000�� Page 293 of 426 � N Q 0 � Agenda Item #11. Village Council Mayor Molly Young GLACTIVITY REPORT FOR VILLAGE OF TEQUESTA FROM 001-100-540.307 TO 001-100-540.307 TRANSACTIONS FROM 10/01/2024 TO 05/31/2025 Created 06/04/2025 Date 1NL Type Description Reference# Debits Credits Balance ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Fund 001 GENERAL FUND 10/01/2024 001-100-540.307 COUNCIL EXPENSES-SEAT 2 BEG.BALANCE $ 3,000.00 10/04/2024 AP INV DONALDSON/HILTON CON HOTEL FLC MTG M YO 10042024E 285.75 (285.75) 10/04/2024 AP INV DONALDSON/HILTON CON REFUND HOTEL TAX F 10042024J 31.75 31.75 10/08/2024 AP INV RMBTRAVEL EXP FLC POLICYCOMM MTG M YOU 10032024 200.35 (200.35) 11/06/2024 AP INV ALLENMERE HILTON CON HOTEL DEPOSIT FLC 11062024P 214.88 (214.88) 12/06/2024 AP INV DONALDSON/HILTON CON HOTEL HILTON FLC M 12062024T 399.98 (399.98) 01/23/2025 AP INV RMB TRAVEL EXPENSE FLC MTG M YOUNG 12/04 01062025 278.24 (278.24) 02/27/2025 AP INV DONALDSON/EVO ITALIA GIFT CARD DONATION 02272025H 100.00 (100.00) 02/27/2025 AP INV DONALDSON/TST PALM B GIFT CARD DONATION 02272025I 25.00 (25.00) 02/27/2025 AP INV DONALDSON/LS TIDE& GIFT CARD DONATION 02272025J 100.00 (100.00) 02/27/2025 AP INV DONALDSON/TST HOG SN GIFT CARD DONATION 02272025P 75.00 (75.00) 03/06/2025 AP INV DONALDSON/ALOFTTALL HOTELALOFT PBC DA 03062025I 538.00 (538.00) 06/04/2025 001-100-540.307 END BALANCE $ 2,217.20 $ 31.75 $ 814.55 Page 294 of 426 Agenda Item #11. Village Council Vice-Mayor Laurie Brandon GLACTIVITY REPORT FOR VILLAGE OF TEQUESTA FROM 001-100-540.306 TO 001-100-540.306 TRANSACTIONS FROM 10/01/2024TO 05/31/2025 Created 06/04/2025 Date JNL Type Description Reference# Debits Credits Balance -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Fund 001 GENERAL FUND 10/01/2024 001-100-540.306 COUNCIL EXPENSES-SEAT 3 BEG.BALANCE 3,000.00 01/14/2025 AP INV ACCT#28729195294108/26-09/25/24 MGR/CNC 287291952941X1024 40.28 (40.28) 01/14/2025 AP INV ACCT#28729195294109/26-10/25/24 MGR/CNC 287291952941X1124 40.30 (40.30) 01/14/2025 AP INV ACCT#287291952941 10/26-11/25/24 MGR/CNC 287291952941X1224 40.30 (40.30) 01/14/2025 AP INV ACCT#287291952941 11/26-12/25/24 MGR/CNC 287291952941XO125 40.30 (40.30) 01/14/2025 AP INV ACCT#28729195294105/26-06/25/24 MGR/CNC 287291952941XO724 40.27 (40.27) 01/14/2025 AP INV ACCT#28729195294107/26-08/25/24 MGR/CNC 287291952941XO924 40.28 (40.28) 02/06/2025 AP INV ACCT#287291952941 12/26-01/25/25 MGR/CNC 287291952941XO225 40.30 (40.30) 03/07/2025 AP INV ACCT#28729195294101/26-02/25/25 MGR/CNC 287291952941XO325 40.30 (40.30) 04/01/2025 AP INV ACCT#28729195294102/26-03/25/25 MGR/CNC 287291952941XO425 40.30 (40.30) 05/02/2025 AP INV ACCT#28729195294103/26-04/25/25 MGR/CNC 287291952941XO525 40.30 (40.30) 06/04/2025 001-100-540.306 END BALANCE 402.93 0.00 2,597.07 Page 295 of 426 Agenda Item #11. Village Council Member Jayson French GLACTIVITY REPORT FOR VILLAGE OF TEQUESTA FROM 001-100-540.301 TO 001-100-540.301 TRANSACTIONS FROM 10/01/2024 TO 05/31/2025 Created 06/04/2025 Date JNL Type Description Reference# Debits Credits Balance --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Fund 001 GENERAL FUND 10/01/2024 COUNCIL EXPENSES-SEAT 1 BEG.BALANCE $ 3,000.00 10/01/2024 AP INV DONALDSON/HILTON CON HOTEL DEPOSIT FLC 07312024J 214.88 (214.88) 10/03/2024 AP INV DONALDSON/PALM BEACH TRN BBH NPBC CHAMB 10032024C 35.00 (35.00) 10/04/2024 AP INV DONALDSON/BW BW-190 TRN BETTER WORLD G 10042024C 1,151.10 (1,151.10) 10/04/2024 GJ JE DONALDSON/HILTON CON HOTEL FLC MTG J FR 21225 53.55 (53.55) 10/05/2024 AP INV DONALDSON/HILTON CON HOTEL FLC MTG J FR 10052024B 467.89 (467.89) 10/05/2024 AP INV DONALDSON/HILTON CON REFUND HOTEL TAX F 10052024E 27.46 27.46 10/23/2024 AP INV SNYDER/JEF FLORIDA LE TRN FLC LEGISLATIV 10232024L 325.00 (325.00) 10/23/2024 AP INV SNYDER/JEF HILTON CON HOTEL ADV DEPOSIT 10232024M 204.75 (204.75) 11/08/2024 AP INV ALLEN/JERE HILTON CON HOTEL FLC MTG J FR 11082024D 290.89 (290.89) 11/09/2024 AP INV ALLEN/JERE HILTON CON HOTEL FLC MTG J FR 11092024 354.60 (354.60) 12/04/2024 AP INV SNYDER/JEF HILTON CON REFUND PARTIAL HOT 12042024N 34.75 34.75 12/07/2024 AP INV DONALDSON/HILTON CON HOTEL HILTON FLC M 12072024E 296.80 (296,80) 01/14/2025 Tranfer CONTRIBUTION FROM MR.PAINTER 1,013.82 1,013.82 01/15/2025 AP INV RMB TRAVEL EXPENSE FLC MTG J FRENCH 12/0 12042024 681.57 (681,57) 06/04/2025 001-100-540.301 END BALANCE $4,076.03 $ 1,076.03 $ Page 296 of 426 Agenda Item #11. Village Council Member Patrick Painter GLACTIVITY REPORT FORVILLAGE OFTEQUESTA FROM 001-100-540.308 TO 001-100-540.308 TRANSACTIONS FROM 10/01/2024TO 05/31/2025 Created 06/04/2025 Date JNL Type Description Reference# Debits Credits Bata Fund001GENERALFUND 10/01/2024 001-100-540.308000NCIL EXPENSES-SEAT 4 BEG.BALANCE $ 3,000.00 01/14/2025 Transfer TRANSFER TO MR.FRENCH 1,013.82 (1,013.82) 01/03/2025 AP INV EATALIANO DINNER FOR PUBLIC SAFETY 01032025N 351.00 (351.00) 06/04/2025 001-100-540.308 END BALANCE $ 1,013.82 $ - $ 1,986.18 Page 297 of 426 Agenda Item #11. Village Council Member Rick Sartory GLACTIVITY REPORT FOR VILLAGE OF TEQUESTA FROM 001-100-540.304TO 001-100-540.304 TRANSACTIONS FROM 10/01/2024 TO 05/31/2025 Created 06/04/2025 Date JNL Type Description Reference# Debits Credits Balance -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Fund 001 GENERAL FUND 10/01/2024 001-100-540.304 COUNCIL EXPENSES-SEAT 5 BEG.BALANCE $ 3,000.00 10/01/2024 AP INV DONALDSON/PALM BEACH TRN BBH/BAH NPBC C 09272024C 85.00 (85.00) 10/04/2024 AP INV DONALDSON/HILTON CON HOTEL FLC MTG R SA 10042024D 53.55 (53.55) 10/04/2024 GJ JE DONALDSON/HILTON CON HOTEL FLC MTG J FIR 21225 53.55 53.55 10/08/2024 AP INV DONALDSON/HILTON CON HOTEL DEPOSIT FLC 10082024C 214.88 (214.88) 11/06/2024 AP INV DONALDSON/HILTON CON REFUND HOTEL DEPOS 11062024R 214.88 214.88 06/04/2025 001-100-540.304 END BALANCE $ 353.43 $ 268.43 $ 2,915.00 Page 298 of 426