Loading...
HomeMy WebLinkAboutDocumentation_Regular_Tab 08_1/9/2025 Agenda Item #8. Regular Council STAFF MEMO Meeting: Regular Council - Jan 09 2025 Staff Contact: Jeremy Allen, Village Manager Department: Manager Manager's Report through December 31, 2024 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 $10.1 million, which represents 81% of the budgeted amount. Historically, 91% of ad valorem tax distribution receipted by the end of February. 3. Sales/use taxes (15%), which include local infrastructure surtax, insurance premium, utility, communication service and local business tax, are one/two month behind collection/reported period, with the exception of the Local Business Tax that are due October 1st and collected at 97%. Insurance premium tax ($370 thousand) to be collected at the year-end as one distribution. Sales/use taxes are on target for two month's collections. 4. Intergovernmental revenues (16%) which include municipal revenue sharing, half-cent sales tax, and local gas tax are one month behind the collection/reported period and is on a target for two month's collections. 5. Local discretionary infrastructure surtax(7%) - collected at $41 thousand, which represent 7% of the budgeted amount and is on target for one month's collections. 6. Revenues (Budgetary comparison) recorded in the General fund represents 60% of budgeted due to the distribution nature of Ad valorem taxes collected at 81%, representing 86% of overall General fund revenues at 12/31/2024. 7. Overall Expenditures (Budgetary comparison) in the General Fund represents 25% of budgeted. Not all the expenditures recorded for the services provided for the month of December 2024 and personnel expenditures recorded as paid not when accrued. 8. Revenues (Prior year comparison) all funds increased by $3.7 million (28%) mainly due to Ad valorem taxes collected $1.6 million (19%) higher than same period of prior year, increased land development and permit fees for ongoing projects. Also, interfund transfer to Vehicle Replacement fund recorded in the amount of around $1 million. Page 112 of 188 Agenda Item #8. 9. Expenditures (Prior year comparison) all funds are 27% increase due to police vehicles purchase, road and water utility capital projects started earlier 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 Dec 2024 v2 December 2024 Managers Report.ADA 2 December 2024 Grant Budget Worksheet 02-Nov Village Council Discretionary Funds Page 113 of 188 Q lt§ti�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/9 sracan Period Ending 12/31/2024 DB: Teauesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 2,430,681.28 Investments 13,173,342.61 Accounts Receivable 1,138,720.02 Due from Other Funds 0.00 Accrued Income Receivable 2,918.35 Inventories 57,274.69 Prepaids 32,950.54 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 16,835,887.49 *** Liabilities *** Accounts Payable 49.11 Accrued liabilities 17,938.50 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 1,594.38 Deferred Revenue 1,186,040.96 Other Current Liabilities 168.70 Customer Deposits 0.00 Noncurrent liabilities 0.00 Total Liabilities 1,205,791.65 *** 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 - Nonspendable 634,320.07 Fund Balance - Restricted 294,000.00 Fund Balance - Committed 500,000.00 Fund Balance - Assigned 831,382.00 Fund Balance - Unassigned 5,769,033.51 Total Fund Balance 8,028,735.58 Beginning Fund Balance - 23-24 8,028,735.58 Net of Revenues VS Expenditures - 23-24 774,319.71 *23-24 End FB/24-25 Beg FB 8,803,055.29 Net of Revenues VS Expenditures - Current Year 6,827,040.55 Ending Fund Balance 15,630,095.84 Total Liabilities And Fund Balance 16,835,887.49 * Year Not Closed Page 114 of 188 Q lt§ti�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/9 sracan Period Ending 12/31/2024 DB: Teauesta Fund 101 BUILDING FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 88,230.45 Investments 1,061,064.44 Accounts Receivable 58.15 Inventories 226.41 Prepaids 1F003.03 Total Assets 1,150,582.48 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities (120.00) Due to Other Governments 23,848.96 Total Liabilities 23,728.96 *** Fund Balance *** F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 10,656.92 Fund Balance - Restricted 1,052,159.01 Fund Balance - Assigned 828.00 Fund Balance - Unassigned 0.00 Total Fund Balance 1F063r643.93 Beginning Fund Balance - 23-24 1F063r643.93 Net of Revenues VS Expenditures - 23-24 (318,118.65) *23-24 End FB/24-25 Beg FB 745,525.28 Net of Revenues VS Expenditures - Current Year 381,328.24 Ending Fund Balance 1,126,853.52 Total Liabilities And Fund Balance 1,150,582.48 * Year Not Closed Page 115 of 188 Q lt§ti�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/9 sracan Period Ending 12/31/2024 DB: Teauesta Fund 301 CAPITAL IMPROVEMENT FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 239,601.96 Investments 662,521.26 Accounts Receivable 22,776.42 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 924,899.64 *** 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 361,198.50 Fund Balance - Committed 271,687.00 Fund Balance - Assigned 663,787.26 Fund Balance - Unassigned 0.00 Total Fund Balance 1,296,672.76 Beginning Fund Balance - 23-24 1,296,672.76 Net of Revenues VS Expenditures - 23-24 (465,147.56) *23-24 End FB/24-25 Beg FB 831,525.20 Net of Revenues VS Expenditures - Current Year 93,374.44 Ending Fund Balance 924,899.64 Total Liabilities And Fund Balance 924,899.64 * Year Not Closed Page 116 of 188 Q lt§ti�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/9 sracan Period Ending 12/31/2024 DB: Teauesta Fund 303 CAPITAL PROJECTS FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 19,358.34 Investments 946,161.26 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 965,519.60 *** 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 262,355.05 Fund Balance - Unassigned 0.00 Total Fund Balance 262,355.05 Beginning Fund Balance - 23-24 262,355.05 Net of Revenues VS Expenditures - 23-24 111143,579.22 *23-24 End FB/24-25 Beg FB 1,405,934.27 Net of Revenues VS Expenditures - Current Year (440,414.67) Ending Fund Balance 965,519.60 Total Liabilities And Fund Balance 965,519.60 * Year Not Closed Page 117 of 188 Q lt§ti�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/9 sracan Period Ending 12/31/2024 DB: Teauesta Fund 401 WATER FUND GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 2,236,036.71 Investments 9,067,212.44 Accounts Receivable 742,881.68 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Accrued Income Receivable 0.00 Inventories 409r394.80 Prepaids 9,158.81 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 320r873.30 Construction in Progress 2,441,135.80 Intangible Assets 0.00 Other Fixed Assets 0.00 Deferred Outflows 608r256.07 FIXED ASSETS 0.00 Total Assets 29,653,629.08 *** 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 30F475.00 Noncurrent liabilities 1,125,092.99 Other Long Term Liabilities 585,311.39 Def Inflows of Resources 524,664.00 Total Liabilities 2,712,412.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 406,555.63 Fund Balance - Committed 500,000.00 Fund Balance - Unassigned 8,650,264.75 Total Fund Balance 23,551,969.25 Beginning Fund Balance - 23-24 23,551,969.25 Net of Revenues VS Expenditures - 23-24 3,596,277.89 *23-24 End FB/24-25 Beg FB 27,148,247.14 Net of Revenues VS Expenditures - Current Year (207,030.38) Ending Fund Balance 26,941,216.76 Total Liabilities And Fund Balance 29,653,629.08 * Year Not Closed Page 118 of 188 Q lt§ti�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/9 sracan Period Ending 12/31/2024 DB: Teauesta Fund 402 REFUSE & RECYCLING GL Number Description Balance *** Assets *** Cash and Cash Equivalents 274,447.76 Investments 222,961.26 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 497,409.02 *** 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 47,572.37 Total Fund Balance 47,572.37 Beginning Fund Balance - 23-24 47,572.37 Net of Revenues VS Expenditures - 23-24 (10,474.34) *23-24 End FB/24-25 Beg FB 37,098.03 Net of Revenues VS Expenditures - Current Year 460F310.99 Ending Fund Balance 497,409.02 Total Liabilities And Fund Balance 497,409.02 * Year Not Closed Page 119 of 188 Q lt§ti�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/9 sracan Period Ending 12/31/2024 DB: Teauesta Fund 403 STORMWATER UTILITY GL Number Description Balance *** Assets *** Cash and Cash Equivalents 223,389.36 Investments 206,895.14 Accounts Receivable 3,343.06 Due from Other Funds 0.00 Inventories 378.50 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 2,947,682.12 *** 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 480F853.59 Total Fund Balance 2,512,538.65 Beginning Fund Balance - 23-24 2,512,538.65 Net of Revenues VS Expenditures - 23-24 (21,295.72) *23-24 End FB/24-25 Beg FB 2,491,242.93 Net of Revenues VS Expenditures - Current Year 404,160.05 Ending Fund Balance 2,895,402.98 Total Liabilities And Fund Balance 2,947,682.12 * Year Not Closed Page 120 of 188 Q lt§ti�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 8/9 sracan Period Ending 12/31/2024 DB: Teauesta Fund 501 VEHICLE REPLACEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 3,867.72 Investments 914,790.00 Machinery & Equipment 0.00 Total Assets 918,657.72 *** 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 - 23-24 0.00 Net of Revenues VS Expenditures - 23-24 0.00 *23-24 End FB/24-25 Beg FB 0.00 Net of Revenues VS Expenditures - Current Year 918,657.72 Ending Fund Balance 918,657.72 Total Liabilities And Fund Balance 918,657.72 * Year Not Closed Page 121 of 188 Q lt§ti�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 9/9 sracan Period Ending 12/31/2024 DB: Teauesta Fund 605 SPECIAL LAW ENFORCEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 8,710.05 Investments 231,485.01 Accounts Receivable 217.65 Inventories 0.00 Prepaids 0.00 Total Assets 240F412.71 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** Fund Balance - Nonspendable 3,584.52 Fund Balance - Restricted 298,779.06 Fund Balance - Assigned 13,034.00 Fund Balance - Unassigned 0.00 Total Fund Balance 315,397.58 Beginning Fund Balance - 23-24 315,397.58 Net of Revenues VS Expenditures - 23-24 (57,818.70) *23-24 End FB/24-25 Beg FB 257,578.88 Net of Revenues VS Expenditures - Current Year (17,166.17) Ending Fund Balance 240,412.71 Total Liabilities And Fund Balance 240,412.71 * Year Not Closed Page 122 of 188 Agenda Item #8. VILLAGE OF TEQUESTA Cash & Investments Unadjusted Unaudited 12/31/2024 Cash and cash equivalents Investments Total General Fund#001 $ 214305681 $ 139173,343 $ 155604M24 Building Fund#101 8 8,23 0 11061 M64 1,149,295 Capital Improvement Fund#301 23902 662,521 902,123 Capital Projects Fund#303 M358 946,161 965,520 Water Utility#401 212361037 %067,212 111303,249 Refuse &Recycling#402 2745448 222,961 497,409 Stormwater#403 2231389 206,895 430,285 Vehicle Replacement#501 308 914,790 918,658 Special Law Enforcement#605 8,710 2311485 2401195 Total Cash and Investments $ 515249324 $ 269486,433 $ 32,010,757 *Interfund transfer pending Page 123 of 188 VILLAGE OF TEQUESTA Agenda Item #8. REVENUE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 12/31/2023 12/31/2024 VARIANCE %VARIANCE NOTES REVENUES Fund 001-GENERAL FUND General Property Taxes 8,570,312 10,156,948 1,586,635 18.51% Advalorem taxes increase Sales&Use Taxes 270,279 255,960 (14,319) -5.30% Franchise fees-gross receipt 117,970 1041424 (13,546) -11.48% Licenses&Permits 640 41190 3,550 554.69% Rental and misc permits Intergovernmental Revenue 1971270 179,037 (18,233) -9.24% Fees decreased in FY 2025 Chgs for Services-Gen Gov 75,659 4941723 419,064 553.89% Land development fees based on the projects Indirect Costs 225,748 227,620 1,872 0.83% Rents&Royalties 1,855 8,983 71128 384.36% Recreation rentals increase Contributions&Donations 1,300 2,850 1,550 119.23% Differs from year to year,timing in recording Miscellaneous Revenues 15,153 4,007 (11,146) -73.55% Differs from year to year Chgs for Services-Public Safety 3201498 215,105 (105,393) -32.88%Timing in recording JIC emrgiency svcs Fines&Forfeitures 1,002 22,544 21,541 2148.78% Code enf fees collection increase Impact Fees 3,403 425 (2,977) -87.50% Differs from year to year based on the projects Grants and Contributions-Local 4,672 0 (4,672) -100.00% Differs from year to year Charges for Services-Recreation 441126 45,669 1,542 3.50% Unrestricted Investment Earning 1221433 30,380 (92,053) -75.19% Inv unrealized appr,rate decrease,FY2025 one month behind Other Financing Sources 11,668 231 (11,437) -98.02% Disposition of assets,differs from year to year Total General Fund 9,983,988 111753,094 1,769,107 17.72% Fund 101-BUILDING FUND Licenses&Permits 1281377 678,017 549,640 428.14% Varies year to year based upon activity/projects Charges for Services 406 0 (406) -100.00% Unrestricted Investment Earning 12,634 5,072 (7,562) -59.85% Interest rate decrease,FY2025 one month behind Total Building Fund 1411417 683,088 541,671 383.03% Fund 301-Capital Improvement Fund Sales&Use Taxes 85,565 87,693 21128 2.49% Year end adjustment pending Unrestricted Investment Earning 171161 5,681 (11,479) -66.89% Interest rate decrease,FY2025 one month behind Total Capital Improvement Fund 1021726 93,374 (9,351) -9.10% Fund 303-Capital Projects Fund Unrestricted Investment Earning 3,614 10,308 6,694 185.21% Investment balance increase Total Capital Projects Fund: 3,614 10,308 6,694 185.21% Fund 401-Water Fund Unrestricted Investment Earning 127,945 57,674 (70,270) -54.92% Inv unrealized appr,rate decrease,FY2025 one month behind Other Financing Sources 241709 25,335 625 2.53% Capital connect charge based on the projects Charges for Services 1/732/775 1,809,851 77,076 4.45% Total Water Fund: 1,885,430 1,892,860 71430 0.39% Fund 402-Refuse&Recycling Unrestricted Investment Earning 2,078 382 (1,697) -81.64% Inv unrealized appr,rate decrease,FY2025 one month behind Charges for Services 469,646 582,694 113,048 24.07% Advalorem taxes increase Total Refuse&Recycling: 4711725 5831076 111,351 23.61% Fund 403-Stormwater Utility Unrestricted Investment Earning 3,158 419 (2,739) -86.72% Inv unrealized appr,rate decrease,FY2025 one month behind Charges for Services 4311165 458,323 271158 6.30% Advalorem taxes increase Total Stormwater Utility: 434,323 458,742 241419 5.62% Fund 501-Vehicle Replacement Intragovernmental Revenue 0 124,512 124,512 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 11174,302 1,174,302 100.00% Fund 605-Special Law Enforcement Forfeitures 623 311747 31,124 4995.10% Differ from year to year Unrestricted Investment Earning 3,690 1,636 (2,054) -55.66% Inv unrealized appr,rate decrease,FY2025 one month behind Total Special Law Enforcement 4,313 33,383 29,070 674.07% TOTAL REVENUES-ALL FUNDS 13,027,534 16,682,228 3,654,693 28.05% NOTES are for differences grater than 10%and amounts over$1,000. Page 124 of 188 Agenda Item #8. VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 12/31/2023 12/31/2024 VARIANCE VARIANCE NOTES EXPENDITURES Fund 001-GENERAL FUND Council 15,209 18,580 3,372 22.17% Council expense Seat 1 Manager 82,556 79,172 (3,383) -4.10% Human Resources 121,010 1261P406 5,396 4.46% Village Clerk 117,960 116,347 (1,613) -1.37% Finance 195,071 186,585 (8,486) -4.35% Legal 65,689 23,475 (42,214) -64.26% Differs from year to year based upon service needs Comprehensive Planning 62,378 66,467 4,089 6.56% Life/health ins General Government 921767 163,025 70,259 75.74% Vehicle replacement svc charge implemented FY 25 IT 224,814 2371P155 12,340 5.49% Police Department 855,476 934,813 79,337 9.27% Reg&overtime disaster pay,pension contrib,eq maint Code Compliance 4,969 21,372 16,402 330.07% Full-time position filled in FY 25 Fire Control 1,054,423 11127,045 72,621 6.89% Reg&overtime disaster pay,health ins Public Works 339,799 3651P059 25,260 7.43% Leisure Services 3441488 329,734 (14,754) -4.28% Debt Service 3771233 381,028 3,795 1.01% Interfund Transfers 0 749,790 749,790 100.00% Transfers to Vehic repl fund recorded Total General Fund 3,953,841 4,926,054 9721,212 24.59% Fund 101-BUILDING FUND Building Department 254,894 2261P760 (28,134) -11.04% Comp abbbsenses&insp svcs Interfund Transfers 0 75,000 75,000 100.00% Differs from year to year Total Building Fund 254,894 301,760 46,866 18.39% Fund 301-Capital Improvement Fund General 5,580 0 (5,580) -100.00% Projects varies year to year Public Works 263,612 0 (263,612) -100.00% Projects varies year to year Miscellaneous projects 92,012 0 (92,012) -100.00% Projects varies year to year Total Capital Improvement Fund: 361,203 0 (361,203) -100.00% Fund 303-Capital Projects Fund Public Works 0 291.1767 2911,767 100.00% Projects varies year to year Parks 0 158,956 158,956 100.00% Projects varies year to year Total Capital Projects Fund: 0 450,723 450,723 100.00% Fund 401-Water Fund Water-Administration 498,946 4391P888 (59,058) -11.84% Insurance Water- Production 462,843 491,360 28,516 6.16% Water-Distribution 223,033 2061510 (16,523) -7.41% Water-Customer Service 671192 70,158 2,966 4.41% Renewal&Replacement 105,022 72,776 (32,246) -30.70% Differs from year to year based upon projects Capital Improvements 0 481,391 481,391 100.00% Differs from year to year based upon projects Debt Service 111,685 112,808 1,122 1.00% Interfund Transfers 0 225,000 225,000 100.00% Transfers to Vehic repl fund recorded Total Water Fund: 11468,722 2,099,890 6311,168 42.97% Fund 402-Refuse&Recycling Refuse and Recycling 1021240 1221P765 20,525 20.08% Fees increase Total Refuse&Recycling: 1021240 1221P765 20,525 20.08% Fund 403-Stormwater Utility Storm Water Utilities 90,715 54,532 (36,183) -39.89% Timing in recording drainage maint Renewal&Replacement 241,901 50 (241,851) -99.98% Differs from year to year based upon projects Total Stormwater Utility: 332,615 54,582 (278,033) -83.59% Fund 501-Vehicle Replacement General Government 0 255,644 255,644 100.00% Police vehicles purchase Total Vehicle Replacement 0 255,644 255,644 100.00% Fund 605-Special Law Enforcement Police 14,511 50,549 36,038 248.34% Differs from year to year based upon needs Total Special Law Enforcement: 14,511 50,549 36,038 248.34% TOTAL EXPENDITURES-ALL FUNDS 6,488,028 8,261,967 11773,939 27.34% NOTES are for differences grater than 10%and amounts over$1,000. Page 125 of 188 Agenda Item #8. THE VILLAGE OF TEQUESTA REVENUE REPORT-CASH BASIS,UNAUDITED FY 2025 FY 2025 25.00% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 12/31/2024 VARIANCE VARIANCE USED NOTES Fund 001-GENERAL FUND General Property Taxes 12,603,668 121603,668 31,150,917 10,156,948 71006,031 222.35% 80.59 Historically,91%receipted by the end of Feb Sales&Use Taxes 1.1498,293 11498,293 374,573 255,960 (118,613) -31.67% 17.08 state revs one month behind Franchise fees-gross receipt 614,820 614,820 153,705 1041P424 (49,281) -32.06% 16.98 one month behind Licenses&Permits 9,000 9,000 21250 4,190 1,940 86.22% 46.56 special events,vacational rental permits Indirect Costs 910,478 910,478 227,620 227,620 0 0.00% 25.00 Grants Federal 2,500 2,500 625 0 (625) -100.00% 0.00 Differ from year to year,timing of collection Grants-State 611,728 61,728 15,432 0 (15,432) -100.00% 0.00 Differ from year to year,timing of collection Intergovernmental Revenue 1,105,205 11,105,205 276,301 179,037 (97,264) -35.20% 16.20 Revs one month behind Grants and Contributions-Local 10,000 10,000 2,500 0 (2,500) -100.00% 0.00 Differ from year to year,timing of collection Chgs for Services-Gen Gov 345,956 345,956 86,489 4941723 408,234 472.01% 143.00 Land dev fees Chgs for Services-Public Safety 11,270,976 1.1270,976 317.1744 215,105 (102,639) -32.30% 16.92 Timing in recording JIC emrgiency svcs Charges for Services-Recr. 113,515 113,515 28,379 45,669 17,290 60.93% 40.23 Rec programs and other fees Fines&Forfeitures 13,585 13,585 3,396 22,544 19,148 563.78% 165.95 Code enf fines&fees Unrestricted Investment Earning 280,500 280,500 70,125 30,380 (39,745) -56.68% 10.83 Inv unrealized appr,one month behind Rents&Royalties 148,482 148,482 371121 8,983 (28,138) -75.80% 6.05 Timing in leases rev recording Impact Fees 4,500 4,500 11125 425 (700) -62.19% 9.45 Differ from yr to yr depending on projects/permits Contributions&Donations 2,000 2,000 500 2,850 2,350 470.00% 142.50 Differ from year to year events depending Miscellaneous Revenues 5,000 5,000 11250 4,007 21757 220.59% 80.15 Differ from year to year,ins claim Other Financing Sources 10,000 10,000 2,500 231 (2,269) -90.76% 2.31 assets disposition,differs from year to year Appropriate Fund Balance 500,000 500,000 0 Total General Fund 19,510,206 19,510,206 41752,552 111753,094 7,000,543 147.30% 60.24 Fund 101-BUILDING FUND Licenses&Permits 608,708 608,708 152.1177 678,017 525,840 345.54% 111.39 Varies year to year based upon activity/projects Unrestricted Investment Earning 25,003 25,003 6,251 5,072 (1,179) -18.86% 20.28 Rev recording one month behind Appropriate Fund Balance 618,094 618,094 0 0 Total Building Fund 1.1251,805 11251,805 158,428 683,088 524,661 331.17% 54.57 Fund 301-Capital Improvement Fund Sales&Use Taxes 850,467 850,467 212,617 87,693 (124,924) -58.76% 10.31 state revs two month behind,above budgeted Unrestricted Investment Earn 25,000 25,000 6,250 5,681 (569) -9.10% 22.72 Rev recording one month behind Grants-State 340,884 340,884 85,221 0 (85,221) -100.00% 0.00 Differ from year to year,timing of collection Total Capital Improvement Fund: 11216,351 11,216,351 304,088 93,374 (210,714) -69.29% 7.68 Fund 303-Capital Projects Fund Unrestricted Investment Earning 9,000 9,000 2250 10,308 8,058 358.15% 114.54 Investment balance increase Grants-State 162,500 162,500 40,625 0 (40,625) -100.00% 0.00 Differ from year to year,timing of collection Transfers In 11,280,210 1.1280,210 320,053 0 (320,053) -100.00% 0.00 FY 2025 not recorded,timing in recording Appropriate Fund Balance 249,790 249,790 0 Total Capital Projects Fund: 11,701,500 11701,500 362,928 10,308 (352,619) -97.16% 0.00 Fund 401-Water Fund Charges for Services 9,380,856 9,380,856 2,345,214 1,809,851 (535,363) -22.83% 19.29 Differ from year to year,timing of collection Unrestricted Investment Earn 250,000 250,000 62,500 57,674 (4,826) -7.72% 100.00 Inv unrealized appr,one month behind Miscellaneous Revenues 371272 371P272 9,318 0 (9,318) -100.00% 0.00 Differ from year to year Other Financing Sources(icl.loan) 10.1020,000 10,020,000 2.1505,000 25,335 (2,479,665) -98.99% 0.25 Loan proceeds Appropriate Fund Balance 2,075,949 2,075,949 0 0 Total Water Fund: 211764,077 211,764,077 4,922,032 1,892,860 (3,029,172) -61.54% 8.70 Fund 402-Refuse&Recycling Charges for Services 718,573 718,573 179,643 582,694 403,051 224.36% 81.09 Historically,91%receipted by the end of Feb Unrestricted Investment Earn 7,500 7,500 1,875 382 (1,493) -79.64% 5.09 Rev recording one month behind Appropriate Fund Balance 16,920 16,920 0 0 Total Refuse&Recycling: 742,993 742,993 181,518 583,076 401,558 221.22% 78.48 Fund 403-Stormwater Utility Grants State 194,500 194,500 48,625 0 (48,625) -100.00% 0.00 Differ from year to year,timing of collection Grants&Contributions 63,000 63,000 15,750 0 (15,750) -100.00% 0.00 Timing in revenue recording Charges for Services 570,600 570,600 142,650 458,323 315,673 221.29% 80.32 Historically,91%receipted by the end of Feb Unrestricted Investment Earn 8,500 8,500 21P125 419 (1,706) -80.27% 4.93 Rev recording one month behind Total Stormwater Utility: 836,600 836,600 209,150 458,742 249,592 119.34% 54.83 Fund 501-Vehicle Replacement Intragovernmental Revenue 498,046 498,046 124,512 124,512 0 0.00% 25.00 Transfers In 1,049,790 1,049,790 262.1448 1,049,790 787,343 300.00% 100.00 FY 2025 transfers recorded Total Vehicle Replacement 1,547,836 1,547,836 386,959 1,174,302 787,343 203.47% 75.87 Fund 605-Special Law Enforcement Forfeitures 126,009 126,009 31,502 31,747 245 0.78% 25.19 Differ from year to year,timing of collection Unrestricted Investment Earn 5,000 5,000 110250 1,636 386 30.88% 32.72 Total Special Law Enforcement 131,009 131,009 321752 33,383 631 1.93% 0.00 TOTAL REVENUES-ALL FUNDS 48,702,377 48,702,377 11,310,406 16,682,227 5,371,821 47.49% 34.25 NOTES are for differences grater than 10%and amounts over$1,000. Page 126 O A3anda THE VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED FY 2025 FY 2025 25.00% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 12/31/2024 VARIANCE VARIANCE USED Fund 001-General Fund Council 101,091 101,091 25,273 18,580 6,692 26.48% 18.38(1),(2) Manager 381,662 381,662 95,416 79,172 16,243 17.02% 20.74 Human Resources 501,502 501,502 125,376 126,406 (1,031) -0.82% 25.21 Village Clerk 464,414 464,414 116,104 116,347 (243) -0.21% 25.05 Finance 842,590 842,590 210,648 186,585 24,063 11.42% 22.14 Legal 246,500 246,500 61,625 23,475 38,150 61.91% 9.52 Comprehensive Planning 409,622 409,622 102,406 66,467 35,938 35.09% 16.23 General Government 770,667 770,667 192,667 163,025 29,641 15.38% 21.15 IT 612,423 612,423 153,106 237,155 (84,049) -54.90% 38.72(3) Police Department 4,357,428 4,357,428 1,089,357 934,813 154,544 14.19% 21.45(1),(2) Code Compliance 138,325 138,325 34,581 21,372 13,210 38.20% 15.45(1),(2) Fire Control 5,012,483 5,012,483 1,253,121 1,127,045 126,076 10.06% 22.48(1),(2) Public Works 1,796,551 1,796,551 449,138 365,059 84,078 18.72% 20.32(1),(2) Leisure Services 1,284,680 1,284,680 321,170 329,734 (8,564) -2.67% 25.67(3) Debt Service 487,300 487,300 121,825 381,028 (259,203) -212.77% 78.19(3) Interfund Transfers 2,030,000 2,030,000 507,500 749,790 (242,290) -47.74% 36.94(3) Allocate to Fund Balance* 72,968 72,968 Total General Fund 19,510,206 19,510,206 4,877,552 4,926,054 (48,502) -0.99% 25.25 Fund 101-BUILDING FUND Building&Zoning 1,176,805 1,176,805 294/201 226,760 67,441 22.92% 19.27(1),(2) Interfund Transfers 75,000 75,000 18,750 75,000 56,250 300.00% 0.00 Total Building Fund 1,251,805 1,251,805 312,951 301,760 11,191 3.58% Fund 301-Capital Improvement Fund General 1031000 103,000 25,750 0 25,750 100.00% 0.00 (2),(3) Parks 931,768 931,768 232,942 0 232,942 100.00% 0.00 (2),(3) Tequesta Drive(Bridge) 100,000 100,000 25,000 0 25,000 100.00% 0.00 (2),(3) Allocate to Fund Balance* 81,583 81,583 0 Total Capital Improvement Fund: 1,216,351 1,216,351 304,088 0 304,088 100.00% 0.00 Fund 303-Capital Projects Fund Public Works 880,000 880,000 220,000 2911#767 (71,767) -32.62% 33.16 (2),(3) Leisure Services 275,000 275,000 68,750 158,956 (90,206) -131.21% 0.00 (2),(3) Allocate to Fund Balance* 546,500 546,500 0.00 Total Capital Projects Fund: 1,701,500 1,701,500 425,375 450,723 (25,348) -5.96% 26.49 Fund 401-Water Fund Water-Administration 1,961,397 1,961,397 490,349 439,888 50,461 10.29% 22.43 Water- Production 2,408,397 2,408,397 602,099 491,360 110,740 18.39% 20.40 Water-Distribution 976,067 976,067 244,017 206,510 37,507 15.37% 21.16 Water-Customer Service 337,316 337,316 84,329 70,158 14,171 16.80% 20.80 Renewal&Replacement 4,243,000 4,243,000 1,060,750 72,776 987,974 93.14% 1.72 (2) Capital Improvement 11,120,000 11,120,000 2,780,000 481,391 2,298,609 82.68% 0.00(2) Debt Service 492,900 492,900 123,225 112,808 10,417 8.45% 22.89 Interfund Transfers 225,000 225,000 56,250 225,000 (168,750) -300.00% 100.00 Total Water Fund: 21,764,077 21,764,077 5,441,019 2,099,890 3,341,129 61.41% 9.65 Fund 402-Refuse&Recycling Refuse and Recycling 742,993 742,993 185,748 122,765 62,983 33.91% 16.52 (1),(2) Total Refuse&Recycling: 742,993 742,993 185,748 122,765 62,983 33.91% 16.52 Fund 403-Stormwater Utility Storm Water Utilities 283,289 283,289 70,822 54,532 16,290 23.00% 19.25 Renewal&Replacement 430,152 430,152 107,538 50 107,488 99.95% 0.01 (2),(3) Allocate to Fund Balance* 123,159 123,159 0 0 Total Stormwater Utility: 836,600 836,600 209,150 54,582 154,568 73.90% 6.52 Fund 501-Vehicle Replacement General Government 350,000 350,000 87,500 255,644 (168,144) -192.16% 73.04 TPD cars purchase Building 45,000 45,000 11,250 0 11,250 100.00% 0.00 Renewal&Replacement 172,500 172,500 43,125 0 43,125 100.00% 0.00 Other Nonoperating 980,336 980,336 245,084 0 245,084 100.00% 0.00 Total Vehicle Replacement 1,547,836 1,547,836 386,959 255,644 131,315 33.94% 16.52 Fund 605-Special Law Enforcement Police 131,009 131,009 32,752 50,549 (17,797) -54.34% 100.00 (2) Total Special Law Enforcement 131,009 131,009 32,752 50,549 (17,797) -54.34% 100.00 TOTAL EXPENDITURES-ALL FUNDS 48,702,377 48,702,377 12,175,594 8,261,967 3,913,627 32.14% 16.96 Notes: *Not included in Target Budget calculation (1)Personal expenditures/expenses recorded as when paid not when accrued.Personnel paid 12/19/24 for the period ended 12/14/24. Due to timing of payroll dates 17 days of personnel expenditures not reflected in December 2024. (2)Not all operating expenditures/expenses recorded for the services of December 2024.Expenditures recorded on a cash basis and adjusted to accrual at year end. Pa e 127 of 188 (3)Timing in expenditures/expenses recording and/or recorded as one time entry at year end. Agenda Item #8. December 2024 Department Reports Current Month 2023/2024 2022/2023 2021/2022 Totals Totals Totals Building Department Current Month 2023/2024 2022/2023 2021/2022 Meetings With Residents 13 110 317 306 Total Master Permits and subpermits Issued 93 1516 1372 1168 New Residential Construction Permits 1 12 5 11 Residential Remodel and additions Permits 5 79 874 671 Commercial Remodel and additions Permits 1 16 56 42 Tr^^'^o^FngitS 44 0 566 648 FIRE PERMITS 2 19 56 48 Residential Plan Reviews 81 1379 1074 1342 Commercial Plan Reviews 4-2 137 56 48 Total Inspections 280 4698 3483 4252 BTR Inspections 3 18 Trade Inspections 95 1300 Vacation Rentals Inspections 1 24 Certificates of Compliance 15 234 267 174 Over the Counter 9 227 243 159 Electronic 84 1295 1300 1263 Complaints or Compliments 4 40 3 3 Record Requests 8 260 246 348 Permit/Code Information Requests 40 417 308 944 Regular Council Meetings 1 13 12 13 Workshop Meeting 0 3 11 13 FFMA-ASFPM Meetings/Training 1 19 30 27 BCAIB-BOAF-BOATC/DBPR Meetings 3 16 22 21 LPA 0 3 24 Code Enforcement Current Month 2023/2024 2022/2023 2021/2022 Code Enforcement Inspections 22 253 175 291 Notices of Violation Issued 2 69 34 60 Rubbish and accumulation 0 7 3 26 Illegal RV/camper/trailer parking 0 32 67 122 Code Cases Opened 8 176 131 254 -By code officer 6 54 -Reactive 2 12 Code Cases Closed 3 99 101 257 Code Cases Cleared Within 30 Days 3 71 79 185 Code Cases Scheduled for Hearing 0 12 17 27 Magistrate Meeting 1 6 4 26 Meeting With Residents Regarding Violations 54 340 168 24S Community Development Current Month 2023/2024 2022/2023 2021/2022 Land Development Applications 4 28 63 48 Board/Council Meetings 3 47 48 14 Ongoing Projects 10 125 106 48 Development Order Time Extensions 0 1 1 - Public Records Requests 3 40 38 - Major Meetings and Conference Calls 6 109 100 61 Annexation 0 0 2 2 2GHO Projects-Reserve/Key Estates/Tequesta Country Club/Pelican Square/209 Tequesta Drive/236 US Highway/Tequesta Office Bldg./Seaglass/Savoy/Main 2 10 33 30 Community Center/Remembrance Park 0 10 8 2 Residents/Business Owners 9 101 59 27 DRC Meeting 1 4 6 1 Permits(New Single Family and Commercial) 2 24 22 38 Phone Calls/Emails/Walk-Ins 165 1235 3276 1825 Totals Totals Totals Fire Current Month 2023/2024 2022/2023 2021/2022 Station Maintenance 702 21282 9,049 8,277 Training 756 2,589 9,017 8,997 Fire Fighter Administrative Duties 714 2,148 8,700 8,328 COVID 0 0 8.50 330 Unit Response Data Fire 13 38 119 189 EMS 83 262 1,159 1,070 Special Operations 2 5 26 8 Other 4 21 58 61 Mutual Aid Given-Palm Beach County and Martin County Fire Rescue 14 42 223 173 Mutual Aid Received-Palm Beach County/Martin County Fire Rescue 10 31 164 127 COVID 0 0 4 8 Inspection Data New Construction 4 8 69 90 Annual Fire 27 100 345 544 New Business/New Occupation/Home Business 3 7 23 24 Re-Inspections 24 69 226 51 Food Truck/Tents 2 5 19 11 Public Relations Events Data Community Function Hours 91 255 656 651 Station Tours 5 17 130 93 Walk Ins 1 2 16 34 Overtime As of 12/31/2024 Actual Budget Goal/Actual% Overtime Budget $ 131,544.00 100%/30.85% 100%/100.06 100%/109% YTD Totals Totals Page 128 of 188 Agenda Item #8. Human Resources&Risk Management Current Month 2024/2025 2023/2024 2022/2023 Open Positions 2 6 16 21 Applications Received 114 284 573 500 Interviews Conducted 11 22 60 56 Onboardings-Hires 0 0 30 11 Ofboardings-Terms 1 1 15 11 Payroll Authorizations&Evaluations 6 52 339 265 EE Benefit Chgs&Verifications 4 10 120 124 EE Recognition-Individual 24 107 375 350 EE Recognition-Group 1 5 4 5 Training-Headcount 60 136 193 FMLA Requests 3 6 19 14 Work Comp Claims/FF Cancer Claims 1 5 17 8 Labor Relations(Grievances/Arbitrations/Negotiations etc) 3 4 48 41 Policy and Handbook updates 1 3 4 Records Requests 0 5 31 29 HR Information System Adjustments 690 2043 11,666 8359 Newsletter 1 4 13 14 Safety Meetings and Assessments 1 1 5 5 Auto,Property,Liability Claims 0 3 7 14 Totals Totals IT Current Month 2023/2024 2022/2023 2021/2022 Helpdesk Tickets 80 1460 1456 1473 Projects PD Laptop Order M365 configuration and testing Totals Parks and Recreation Current Month 2023/2024 2022/2023 2021/2022 Recreation Programs Tai Chi Classes 156 433 2141 2977 Summer Camp 0 0 1350 5100 Open Basketball 200 600 2750 3771 Senior Cinema 0 11 Kids Night Out At The Rec 0 13 30 104 Game Room 140 420 2173 2895 Open Pickleball 200 600 2430 2840 Tequesta Park Pickleball Program 304 916 1192 990 Gymnastics 1 347 3167 10267 16716 Facility/Field Rentals for Tequesta Park/Constitution Park/Recreation Center Rentals Constitution Park Pavilion Rentals 23 76 77 84 Good Shepard School Daddy Daughter Dance 0 0 200 200 Good Shepard School PE Class 107 319 897 930 Backpacking Event Rec Center 0 0 0 175 Lax Maniax Lacrosse 0 200 980 335 Creators Game 400 950 1100 2620 Rob Availi Baseball 350 350 1700 1050 Rob Avali Flag Football 0 100 300 300 Palm Beach Revolution(LAX) 400 800 640 240 Jupiter Senior Softball 0 0 300 0 Riverside Oaks 0 0 50 55 TCCCA 0 50 85 73 Tequesta Civic Association 25 25 0 15 Tequesta Trace 0 0 0 20 Tequesta Pines Home Meeting 0 50 0 65 George Town HOA 0 0 15 15 Rob Availi Soccer 0 0 150 150 JTAA Summer/Winter Soccer Camp 0 0 0 1800 Rob Availi Softball 0 0 70 140 David Atwell Baseball 0 0 400 100 Elections 0 700 700 400 JTAA Basketball 200 200 500 480 JTAA Baseball 0 0 350 0 Village Rec Center Rentals(Internal) 0 30 150 50 Shredding Event Tequesta Park 0 0 30 30 Tequesta Park Pickleball/Tennis Court Usage 1,500 4500 16,500 19,500 Food Packing Event Gym 0 0 0 400 Activity Room Rental Usage(non HOA) 30 60 200 200 Leatherback Lacrosse 0 100 Sharks Baseball 0 100 Special Events 0 Food Truck 0 800 4800 5,800 Tequesta Roots Festival 0 0 1500 0 Holiday In The Park 1200 1200 1200 1200 Santa Ride 700 700 700 700 Letters to Santa 40 40 45 41 Bridge The Gap 0 0 1500 1200 Movie In The Park 0 0 0 800 Pickleball Tournment 0 0 0 150 Run 4 The Pies 0 1800 1700 1700 Freedom Run 0 0 650 650 Bunny Hop 0 0 500 400 Earth Day Celebration 0 0 0 12 Totals Totals Page 129 of 188 Agenda Item #8. Police Department Current month 2023/2024 2022/2023 2021/2022 Communication Division Officer Initiated Calls 1787 25,772 6874 12504 Calls for Service 177 5,231 3931 2327 Fire Rescue 13 406 553 148 Patrol Division Reports Filed 25 628 264 268 Arrest 5 80 62 55 Crashes Investigated 8 180 313 110 Traffic Stops 120 4,872 2463 2032 Citations 44 931 469 373 Warnings 84 2,144 606 937 Administration Open Positions 0 1 4 2 Resignations 0 3 3 3 Public Records Request 40 987 480 552 Overtime Actual Budget Goal/Actual% Goal/Actual% Operations $ 118,856.00 96.15%/75.27/0 100%/75.27/ Sept Totals Totals Totals Public Works Current Month 2023/2024 2022/2023 2021/2022 Properties and Areas Mowed 4 times per month 33 492 393 429 Properties Trimmed Hedges 15 172 135 122 Properties Trimmed Palms and Trees 10 130 100 313 Flowers Planted/Trees 10 1433 1423 280 Properties Fertilized 0 4 4 0 Landscape equipment maintenance frequency per month 8 119 95 93 Sidewalk Repairs and or Grinding 0 58 57 45 Street Signs Replaced 4 90 81 32 Road Repairs 1 29 26 23 Pet Pots Maintained 2 times per week 8 111 87 72 Vegatation Debris in yards 90 990 720 990 Banners Hung 10 66 44 79 Indoor/Outdoor lights Repaired 12 119 89 80 Street Light Outages 2 137 121 57 Work Orders 317 5142 4154 4238 Standby Generator Maintenance 10 190 160 115 Fleet Maintenance-Vehicles Serviced 19 115 83 80 Surplus-Junked or Sold lems 0 69 68 91 811 Locates 4 70 61 22 Engineering Services 1 45 40 32 Resident Calls 11 258 194 161 Event Set-up 12 98 70 69 Projects 21 212 163 177 Totals Totals Totals Village Clerk's Office November 2023-2024 2022-2023 2021-2022 Agendas Compiled and Distributed 2 40 46 52 Minutes Completed(includes council,committees,spec meetings) 2 40 46 52 Council,Committee,Spec Magistrate,and Special Meeting Hours 2.75 64 89.75 90 Orders Processed 1 21 26 17 Resolutions Processed 3 25 21 34 Ordinances Processed 2 12 15 15 Agreements Processed 7 97 135 104 Legal Advertisements and Meeting Notices and union) 1 116 259 167 Bids/RFPs/Quotes 0 3 8 6 Public Records Processed 28 371 303 285 Lien Requests Processed/Revenues Generated Unk 204/$22135 358/$37840.50 402/$38,270 Records Imaged/pages scanned 1585 45409 42846 15633 Agenda/Minute Portal(iCompass)Total Monthly Visits 1594 25371 25622 23134 Agenda/Minute Portal(iCompass)Unique Monthly Visits 1196 18733 19998 15995 Notaries/Certification of Living 1 36 41 51 Clerk Requests Help Desk Tickets 7 181 35 121 Public Information Officer Facebook Posts(last 30days) 448 410 557 655 Facebook Messenger Responses(this does not include post responses) 3 61 59 61 Page Followers 6,430 6,233 5627 5367 Page Reach(#of unique users viewing content) 28,267 303,684 195,450 151305 Impressions(unable to access on Facebook) - - - - Reel Plays 1433 - comment) 1017 9311 33301 47721 Instagram Posts(last month) 27 264 334 433 Instagram Stories 19 213 356 387 Reels 10 12 22 14 Content Reach(#of unique users who saw post or story) 4460 23099 31893 22844 Impressions(#of times a story or post was viewed/appeared-no engagement r 35,769 126,162 235,359 227744 #of Instagram Followers 2,700 2,348 1,833 1515 #of Instagram Post likes for the month 923 4949 5086 6597 Reel Plays 9787 N/A Page Engagement(how many times an action was taken:liked,shared,comme 1367 7294 6918 7535 X Posts- NA 346 479 415 X Followers NA 995 966 932 X Impressions(#of times tweet was viewed or appeared in a user's timeline) NA 35,148 41,287 35874 Reach(not measured on twitter) NA NA NA NA #of Likes NA 84 111 93 Page 130 of 188 Agenda Item #8. X Engagement Rate(new analytic for X-formally Twitter) NA 9.4%high Unk Video Views NA N/A X Engagement(likes,link clicks,retweets,replies) NA 305 436 286 Nextdoor Posts(last month) NA 109 288 360 Followers(all Tequesta Subscribers,nextdoor does not have a follow option) NA NA NA NA Impressions(#of times a post was viewed) NA 14540 43610 57229 Reach(not provided) NA NA NA NA Engagement(#of interactions) NA 140 250 237 #of Thank you's NA 37 219 197 Website:VOTBot(Artificial Intelligence Quesitons Answered) 78 1029 1215 1201 Press Releases 0 4 8 9 CodeRed Messages Launched 3 59 60 67 Tequesta News Messages(Friday Newsletter) 3 42 45 42 Departmental/Mayor/Other Project Videos 0 3 8 16 Smoke Signals 0 4 4 4 Elections Election: Campaign Treasurer Reports/Candidate Documentation/Office Report 1 3 9 9 Election: Review Candidate Handbook 1 0 31 111 8 Election: Process filing/qualifying paperwork 1 21 21 61 5 Clerk&Public Information Officer Events&Meetings: ELECTIONS: Reminded Young and Painter of Campaign Report due dates,reminded French of Office Account Report due date.SOCIAL MEDIA:Cross posted Parks and Recreation posts to all social media platforms. BUSINESS OUTREACH: N/A ASSISTANCE: Provided assistance to departments for CivicPlus(website),iCompass(agenda software)and JustFOIA(public records software)and video production. MEETINGS/TRAINING:Oranized agenda training for March 2025.PARTNERSHIPS: Organized and held two sessions for the JHS Student Government Academy 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: Marketed Resident Academy,Toy Drive. Updated lobby TV as needed. MISC: Finalized and distsributed 2025 agenda deadline schedule and Smoke Signals schedule. Participated in International Day ceremonies. Provided research for department heads/manager. Processed records management disposition forms,processed oaths,proclamation,declarations, and council meeting recaps.Trained new employees/set up required software credentials:JustFOIA,iCompass,website,DemandStar,CivicOptimize etc. Created new accounts and established workflows for new employees. Created after meeting recaps,ordered office supplies and Amazon orders for Admin and Historicals, ordered business cards for staff(Clerk's Office does this for all employees),meeting setup/breakdown.Processed daily lien reports,invoices,council mail,admin phone support,Oaths and swearing in of new committee members and employees. Utilities Department-Water Distribution Current Month 2024/25 YTD 2023/24 YTD(FY24) 2022/23 YTD(FY23) Water Main Breaks(*-FY21&FY22 service line breaks combined w/water line breaks) 1 2 4 7 Service Line Breaks(*-FY21&FY22 service line breaks combined w/water line breaks) 0 0 17 14 Line Maintenance 13 171 576 181 Equipment Maintenance(Preventive Maintenance) 1 0 25 23 Meter Inspections 71 104 354 518 Meter Reader Related Work Orders 1 3 120 247 Work Orders(Non Meter)/Stormwater:Catchbasins,Outfalls,Pond Mowing&Inspectior 5 68 756 334 Construction Sites Inspected 17 57 189 177 Employee Call Back 15 37 84 71 Valves Exercised 0 15 54 87 Meter Set/Changed Out 1 23 88 77 Locates Performed 120 461 2250 2,982 Staff Out(Days) 58.63 122.88 400.46 346.54 Utilities Department-Customer Service Current Month 2023/2024 2022/23(FY22) 2021/2022(FY21) Leak Adjustment Requests 8 148 (not counted) (not counted) *Utility Billing/Customer Service dashboard in monthly report for Council Utilities Department-Water Production Current Month Calendar Yr 24**YTD Calendar Yr 23**YTD Calendar Yr 22**YTD Water Production Total(million gallons(MG)) 88.849 910.633 992.777 963.767 Maximum Day Production Demand Rate(million gallons per day(MGD)) 3.304 3.876 3.71 3.577 Average Daily Production Demand(MGD) 2.866 2.718 2.72 2.64 MGD Monthly Rainfall 5.62 71.55 106.64 78.03 inches **-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 131 of 188 1111 oil 111111111 CD E CL CD CD 231 .2 0 m Agenda Item #8. U LL >*% LO � � N 0 � CD U oN � � N O � U N LL. Page 133 of 188 Agenda Item #8. 01/02/2025 GL ACTIVITY REPORT FOR VILLAGE OF TEQUESTA FROM 001-100-540.307 TO 001-100-540.307 TRANSACTIONS FROM 11/01/2024 TO 11/30/2024 Date JNL Type Description Reference# Debits Credits Balance -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Fund 001 GENERAL FUND 11/01/2024 001-100-540.307 COUNCIL EXPENSES-SEAT 2-YOUNG BEG.BALANCE 2,513.90 11/06/2024 AP INV ALLEN/JERE HILTON CON HOTEL DEPOSIT FLC 11062024P 214.88 214.88 11/30/2024 001-100-540.307 END BALANCE 214.88 0.00 2,299.02 Page 134 of 188 Agenda Item #8. 01/02/2025 GL ACTIVITY REPORT FOR VILLAGE OF TEQUESTA FROM 001-100-540.301 TO 001-100-540.301 TRANSACTIONS FROM 11/01/2024 TO 11/30/2024 Date JNL Type Description Reference# Debits Credits Balance Fund 001 GENERAL FUND 11/01/2024 001-100-540.301 COUNCIL EXPENSES-SEAT 1-FRENCH BEG.BALANCE 547.88 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 11/30/2024 001-100-540.301 END BALANCE 645.49 0.00 (97.61) Page 135 of 188 Agenda Item #8. 01/02/2025 GL ACTIVITY REPORT FOR VILLAGE OF TEQUESTA FROM 001-100-540.306 TO 001-100-540.306 TRANSACTIONS FROM 11/01/2024 TO 11/30/2024 Date JNL Type Description Reference# Debits Credits Balance -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Fund 001 GENERAL FUND 11/01/2024 001-100-540.306 COUNCIL EXPENSES-SEAT 3-BRANDON BEG.BALANCE 3,000.00 No Activity 0.00 11/30/2024 001-100-540.306 END BALANCE 0.00 0.00 3,000.00 Page 136 of 188 Agenda Item #8. 01/02/2025 GL ACTIVITY REPORT FOR VILLAGE OF TEQUESTA FROM 001-100-540.308 TO 001-100-540.308 TRANSACTIONS FROM 11/01/2024 TO 11/30/2024 Date JNL Type Description Reference# Debits Credits Balance •----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Fund 001 GENERAL FUND 11/01/2024 001-100-540.308 COUNCIL EXPENSES-SEAT 4-PAINTER BEG.BALANCE 3,000.00 No Activity 0.00 11/30/2024 001-100-540.308 END BALANCE 0.00 0.00 3,000.00 Page 137 of 188 Agenda Item #8. 01/02/2025 GL ACTIVITY REPORT FOR VILLAGE OF TEQUESTA FROM 001-100-540.304 TO 001-100-540.304 TRANSACTIONS FROM 11/01/2024 TO 11/30/2024 Date JNL Type Description Reference# Debits Credits Balance •------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Fund 001 GENERAL FUND 11/01/2024 001-100-540.304 COUNCIL EXPENSES-SEAT 5-SARTORY BEG.BALANCE 210700.12 11/06/2024 AP INV DONALDSON/HILTON CON REFUND HOTEL DEPOS 11062024R 214.88 (214.88) 11/30/2024 001-100-540.304 END BALANCE 0.00 214.88 2,915.00 Page 138 of 188