Loading...
HomeMy WebLinkAboutDocumentation_Regular_Tab 08_12/12/2024 Agenda Item #8. Regular Council STAFF MEMO Meeting: Regular Council - Dec 12 2024 Staff Contact: Jeremy Allen, Village Manager Department: Manager Monthly Manager's Report through November 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 $2.1 million, which represents 17% of the budgeted amount. Historically, 91% of ad valorem tax distribution receipted by the end of February. 3. Sales/use taxes (8%), 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 96%. Insurance premium tax ($370 thousand) to be collected at the year-end as one distribution. Sales/use taxes are on target for one month's collections. 4. Intergovernmental revenues (9%) 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 one month's collections. 5. Revenues (Budgetary comparison) recorded in the General fund represents 14% of budgeted and overall on target. 6. Overall Expenditures (Budgetary comparison) in the General Fund represents 15% of budgeted. Not all the expenditures recorded for the services provided for the month of November and personnel expenditures recorded as paid not when accrued. 7. Revenues (Prior year comparison) all funds are 18% decrease due to timing difference in investment revenue recording and ad valorem two distributions vs three in FY 2024. 8. Expenditures (Prior year comparison) all funds are 18% increase due to road and water utility capital projects started earlier in FY 2025. Page 92 of 393 Agenda Item #8. 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 INFORMATION: 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 ATTACHMENTS: I=ql Nov 2024 November 2024 Managers Report.ADA (1) November 2024 Grant Budget Worksheet Page 93 of 393 Q it tit #80 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/9 s racanati Period Ending 11/30/2024 DB: Teauesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 539,363.43 Investments 8,040,718.07 Accounts Receivable 909,634.21 Due from Other Funds 0.00 Accrued Income Receivable 1,978.14 Inventories 46,149.79 Prepaids 30r942.95 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 9,568,786.59 *** Liabilities *** Accounts Payable 49.11 Accrued liabilities 21,226.10 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 1,412.70 Deferred Revenue 782,985.43 Other Current Liabilities 168.70 Customer Deposits 0.00 Noncurrent liabilities 0.00 Total Liabilities 805,842.04 *** 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 848,090.81 *23-24 End FB/24-25 Beg FB 8,876,826.39 Net of Revenues VS Expenditures - Current Year (113,881.84) Ending Fund Balance 8,762,944.55 Total Liabilities And Fund Balance 9,568,786.59 * Year Not Closed Page 94 of 393 Q it tit #80 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/9 s racanati Period Ending 11/30/2024 DB: Teauesta Fund 101 BUILDING FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 62,991.03 Investments 651,217.85 Accounts Receivable 48.07 Inventories 527.82 Prepaids 1F003.03 Total Assets 715,787.80 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities (120.00) Due to Other Governments 6,477.02 Total Liabilities 6,357.02 *** 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 (316,181.22) *23-24 End FB/24-25 Beg FB 747,462.71 Net of Revenues VS Expenditures - Current Year (38,031.93) Ending Fund Balance 709r430.78 Total Liabilities And Fund Balance 715,787.80 * Year Not Closed Page 95 of 393 Q it tit #80 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/9 s racanati Period Ending 11/30/2024 DB: Teauesta Fund 301 CAPITAL IMPROVEMENT FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 176,787.23 Investments 657,579.89 Accounts Receivable 39,810.04 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 874,177.16 *** 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 42,651.96 Ending Fund Balance 874,177.16 Total Liabilities And Fund Balance 874,177.16 * Year Not Closed Page 96 of 393 Q it tit #80 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/9 s racanati Period Ending 11/30/2024 DB: Teauesta Fund 303 CAPITAL PROJECTS FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 11,773.02 Investments lr 036r 678.49 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 1F048r451.51 *** 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 (357,482.76) Ending Fund Balance 1F048r451.51 Total Liabilities And Fund Balance 1F048r451.51 * Year Not Closed Page 97 of 393 Q it tit #80 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/9 s racanati Period Ending 11/30/2024 DB: Teauesta Fund 401 WATER FUND GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 344,392.25 Investments 10,868,526.41 Accounts Receivable 935,435.76 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Accrued Income Receivable 0.00 Inventories 258,400.11 Prepaids 4,643.02 Other Assets - Current 0.00 Land 83,335.00 Other Assets - Non Current 83,335.00 INFRASTRUCTURE 14,109,401.92 Buildings 193,832.79 Improvements Other Than Bldgs. 19,964.80 Machinery & Equipment 209,631.65 Construction in Progress 1,342,203.25 Intangible Assets 0.00 Other Fixed Assets 0.00 Deferred Outflows 608r256.07 FIXED ASSETS 0.00 Total Assets 28,978,023.03 *** Liabilities *** Accounts Payable (0.01) 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 585,311.39 Def Inflows of Resources 524,664.00 Total Liabilities 2,713,236.98 *** 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 2,823,294.65 *23-24 End FB/24-25 Beg FB 26,375,263.90 Net of Revenues VS Expenditures - Current Year (110,477.85) Ending Fund Balance 26,264,786.05 Total Liabilities And Fund Balance 28,978,023.03 * Year Not Closed Page 98 of 393 Q it tit #80 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/9 s racanati Period Ending 11/30/2024 DB: Teauesta Fund 402 REFUSE & RECYCLING GL Number Description Balance *** Assets *** Cash and Cash Equivalents 128,175.68 Investments 22,722.01 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 150,897.69 *** 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 113,799.66 Ending Fund Balance 150,897.69 Total Liabilities And Fund Balance 150,897.69 * Year Not Closed Page 99 of 393 Q it tit #80 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/9 s racanati Period Ending 11/30/2024 DB: Teauesta Fund 403 STORMWATER UTILITY GL Number Description Balance *** Assets *** Cash and Cash Equivalents 77,786.88 Investments 26,717.97 Accounts Receivable 2,528.03 Due from Other Funds 0.00 Inventories 792.77 Prepaids 0.00 Other Assets - Current 0.00 Other Assets - Non Current 0.00 INFRASTRUCTURE 1,991,156.88 Buildings 0.00 Improvements Other Than Bldgs. 0.00 Machinery & Equipment 7,009.31 Construction in Progress 217,649.50 Deferred Outflows 44,364.00 Total Assets 2,368,005.34 *** 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 (274,792.09) *23-24 End FB/24-25 Beg FB 2,237,746.56 Net of Revenues VS Expenditures - Current Year 77,979.64 Ending Fund Balance 2,315,726.20 Total Liabilities And Fund Balance 2,368,005.34 * Year Not Closed Page 100 of 393 Q it tit #80 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 8/9 s racanati Period Ending 11/30/2024 DB: Teauesta Fund 501 VEHICLE REPLACEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents (98,292.32) Machinery & Equipment 0.00 Total Assets (98,292.32) *** 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 (98,292.32) Ending Fund Balance (98,292.32) Total Liabilities And Fund Balance (98,292.32) * Year Not Closed Page 101 of 393 Q it tit #80 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 9/9 s racanati Period Ending 11/30/2024 DB: Teauesta Fund 605 SPECIAL LAW ENFORCEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 45,266.05 Investments 229,961.21 Accounts Receivable 217.65 Inventories 0.00 Prepaids 0.00 Total Assets 275,444.91 *** 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,866.03 Ending Fund Balance 275,444.91 Total Liabilities And Fund Balance 275,444.91 * Year Not Closed Page 102 of 393 Agenda Item #8. VILLAGE OF TEQUESTA Cash & Investments Unadjusted Unaudited 11/30/2024 Cash and cash equivalents Investments Total General Fund#001 $ 5395363 $ 85040,718 $ 8558002 Building Fund#101 62,991 651,218 714,209 Capital Improvement Fund#301 176,787 657,580 834,367 Capital Projects Fund#303 11,773 I M36,678 1 M48,452 Water Utility#401 344,392 105868,526 11,212,919 Refuse &Recycling#402 1285176 22,722 150,898 Stormwater#403 771787 26,718 104,505 Vehicle Replacement#501 (98,292) * - (98,292) Special Law Enforcement#605 451266 229,961 275,227 Total Cash and Investments $ 192889243 $ 219534,122 $ 2298229365 *Interfund transfer pending Page 103 of 393 VILLAGE OF TEQUESTA Agenda Item #8. REVENUE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 11/30/2023 11/30/2024 VARIANCE %VARIANCE NOTES REVENUES Fund 001-GENERAL FUND General Property Taxes 3,325,111 21,116,377 (1,208,734) -36.35%Three distributions in FY 24 vs only two in FY 25 Sales&Use Taxes 175,721 1721484 (3,237) -1.84% Franchise fees-gross receipt 62,833 53,906 (8,927) -14.21% Licenses&Permits 540 3,590 3,050 564.81% Rental and misc permits Intergovernmental Revenue 105,059 98,964 (6,095) -5.80% Fees decreased Chgs for Services-Gen Gov 41,972 41,045 (927) -2.21% Land development fees based on the projects Indirect Costs 150,498 1511746 11248 0.83% Rents&Royalties 11430 3,118 1,688 118.01% Recreation rentals increase Contributions&Donations 0 2,850 2,850 100.00% Differs from year to year,timing in recording Miscellaneous Revenues 155 76 (79) -51.07% Chgs for Services-Public Safety 88,395 158,246 69,851 79.02% EMS transport fees collection increase Fines&Forfeitures 345 22,088 211742 6294.28% Code enf fees collection increase Impact Fees 851 425 (425) -50.00% Charges for Services-Recreation 27,078 28,945 1,866 6.89% Unrestricted Investment Earning 45,325 (61,616) (106,941) -235.94%Timing in recording Other Financing Sources 11,668 0 (11,668) -100.00% Disposition of assets Total General Fund 4,036,982 21,7921244 (1,244,739) -30.83% Fund 101-BUILDING FUND Licenses&Permits 781668 113,080 341412 43.74% Varies year to year based upon activity/projects Miscellaneous Revenues 0 2 2 100.00% Unrestricted Investment Earning 8,432 0 (8,432) -100.00%Timing in recording Total Building Fund 871100 113,081 25,982 29.83% Fund 301-Capital Improvement Fund Sales&Use Taxes 22,515 42,652 20,137 89.44% Year end adjustment pending Unrestricted Investment Earning 11,680 0 (11,680) -100.00%Timing in recording Total Capital Improvement Fund 341195 42,652 8,457 24.73% Fund 303-Capital Projects Fund Unrestricted Investment Earning 2,334 0 (2,334) -100.00%Timing in recording Total Capital Projects Fund: 2,334 0 (2,334) -100.00% Fund 401-Water Fund Unrestricted Investment Earning 70,535 (63,002) (133,537) -189.32%Timing in recording Other Financing Sources 19,061 25,335 6,274 32.92% Capital connect charge based on the projects Charges for Services 1,028,913 1,325,226 296,314 28.80% Year end adjustment pending Total Water Fund: 11118,508 11287,559 169,051 15.11% Fund 402-Refuse&Recycling Unrestricted Investment Earning 720 0 (720) -100.00%Timing in recording Charges for Services 159,056 113,800 (45,256) -28.45%Three distributions in FY 24 vs only two in FY 25 Total Refuse&Recycling: 159,776 113,800 (45,976) -28.78% Fund 403-Stormwater Utility Unrestricted Investment Earning 2,007 0 (2,007) -100.00%Timing in recording Charges for Services 166,537 115,093 (51,444) -30.89%Three distributions in FY 24 vs only two in FY 25 Total Stormwater Utility: 168,544 115,093 (53,451) -31.71% Fund 501-Vehicle Replacement Intragovernmental Revenue 0 83,008 83,008 100.00% New fund created FY 2025 Total Vehicle Replacement 0 83,008 83,008 100.00% Fund 605-Special Law Enforcement Forfeitures 0 311747 311,747 100.00% Differ from year to year Unrestricted Investment Earning 2,399 0 (2,399) -100.00%Timing in recording Total Special Law Enforcement 2,399 311747 29,348 1223.19% TOTAL REVENUES-ALL FUNDS 5,609,839 4,579,183 (1,030,656) -18.37% NOTES are for differences grater than 10%and amounts over$1,000. Page 104 of 393 Agenda Item #8. VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 11/30/2023 11/30/2024 VARIANCE VARIANCE NOTES EXPENDITURES Fund 001-GENERAL FUND Council 10,520 141P298 3,779 35.92% Council expense Seat 1 Manager 471480 521P169 4,690 9.88% Human Resources 73,407 791P758 6,352 8.65% Village Clerk 811486 741778 (6,708) -8.23% Finance 140,879 128.1091 (12,788) -9.08% Legal 11,047 14,091 3,044 27.55% Differs from year to year based upon service needs Comprehensive Planning 341P434 42,283 7,849 22.80% Life/health ins General Government 59,397 116,540 571,144 96.21% Vehicle replacement svc charge implemented FY 25 IT 187,378 189,773 2,394 1.28% Police Department 549,139 652,595 103,456 18.84% Reg&overtime disaster pay,pension contrib,eq maint Code Compliance 1,807 13,350 11,543 638.83% Full-time position filled in FY 25 Fire Control 639,578 714,142 74,564 11.66% Reg&overtime disaster pay,health ins Public Works 223,022 1991P841 (23,180) -10.39% Timing in recording(FEC leases,etc.) Leisure Services 193,350 237,858 44,508 23.02% General maint,rec program exp Debt Service 368,287 376,556 8,268 2.25% Total General Fund 2,621,211 2,906,126 284,914 10.87% Fund 101-BUILDING FUND Building Department 166,798 151.1112 (15,686) -9.40% Total Building Fund 166,798 1511112 (15,686) -9.40% Fund 301-Capital Improvement Fund General 3,836 0 (3,836) -100.00% Projects varies year to year Public Works 24,666 0 (24,666) -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: 120,514 0 (120,514) -100.00% Fund 303-Capital Projects Fund Public Works 0 291.1767 2911,767 100.00% Projects varies year to year Parks 0 65,715 65,715 100.00% Projects varies year to year Total Capital Projects Fund: 0 357.1483 3571,483 100.00% Fund 401-Water Fund Water-Administration 333,569 3381P446 4,877 1.46% Water- Production 320,458 306,312 (14,146) -4.41% Water-Distribution 159,713 1351997 (23,716) -14.85% Timing in exp recording Water-Customer Service 421442 41,166 (1,275) -3.00% Renewal&Replacement 60,657 201944 (39,712) -65.47% 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 72,626 73,780 11154 1.59% Total Water Fund: 989,465 1,398,037 408,572 41.29% Fund 402-Refuse&Recycling Refuse and Recycling 511120 0 (51,120) -100.00% Timing in exp recording Total Refuse&Recycling: 511120 0 (51,120) -100.00% Fund 403-Stormwater Utility Storm Water Utilities 70,234 37,063 (33,170) -47.23% Timing in recording drainage maint Renewal&Replacement 233,001 50 (232,951) -99.98% Differs from year to year based upon projects Total Stormwater Utility: 303,234 371P113 (266,121) -87.76% Fund 501-Vehicle Replacement General Government 0 181,300 181,300 100.00% Police vehicles purchase Total Vehicle Replacement 0 181,300 181,300 100.00% Fund 605-Special Law Enforcement Police 6,588 13,881 71,293 110.71% Differs from year to year based upon needs Total Special Law Enforcement: 6,588 13,881 71,293 110.71% TOTAL EXPENDITURES-ALL FUNDS 41258,929 5,045,051 786,122 18.46% NOTES are for differences grater than 10%and amounts over$1,000. Page 105 of 393 Agenda Item #8. THE VILLAGE OF TEQUESTA REVENUE REPORT-CASH BASIS,UNAUDITED FY 2025 FY 2025 16.67% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 11/30/2024 VARIANCE VARIANCE USED NOTES Fund 001-GENERAL FUND General Property Taxes 12,603,668 121603,668 21,100,611 2,1161377 15,765 0.75% 16.79 Historically,91%receipted by the end of Feb Sales&Use Taxes 1.1498,293 11498,293 249,716 172,484 (77,231) -30.93% 11.51 state revs one month behind Franchise fees-gross receipt 614,820 614,820 102,470 53,906 (48,564) -47.39% 8.77 one month behind Licenses&Permits 9,000 9,000 1,500 3,590 2,090 139.33% 39.89 special events,vacational rental permits Indirect Costs 910,478 910,478 1511746 151,746 0 0.00% 16.67 Grants Federal 2,500 2,500 417 0 (417) -100.00% 0.00 Differ from year to year,timing of collection Grants-State 611,728 61,728 10,288 0 (10,288) -100.00% 0.00 Differ from year to year,timing of collection Intergovernmental Revenue 1,105,205 11,105,205 1841,201 98,964 (85,237) -46.27% 8.95 Revs one month behind Grants and Contributions-Local 10,000 10,000 1,667 0 (1,667) -100.00% 0.00 Differ from year to year,timing of collection Chgs for Services-Gen Gov 345,956 345,956 57,659 41,045 (16,614) -28.81% 11.86 Land dev fees,certif copies Chgs for Services-Public Safety 11,270,976 1.1270,976 211,829 158,246 (53,584) -25.30% 12.45 Charges for Services-Recr. 113,515 113,515 18,919 28,945 10,025 52.99% 25.50 Rec program fees Fines&Forfeitures 13,585 13,585 210264 22,088 19,824 875.54% 162.59 Code enf fines&fees Unrestricted Investment Earning 280,500 280,500 46,750 (61,616) (108,366) -231.80% (21.97)Timing in recording Rents&Royalties 148,482 148,482 241P747 3,118 (21,630) -87.40% 2.10 Timing in leases rev recording Impact Fees 4,500 4,500 750 425 (325) -43.29% 9.45 Differ from yr to yr depending on projects/permits Contributions&Donations 2,000 2,000 333 2,850 2,517 755.00% 142.50 Differ from year to year events depending Miscellaneous Revenues 5,000 5,000 833 76 (757) -90.88% 1.52 Other Financing Sources 10,000 10,000 1,667 0 (1,667) -100.00% 0.00 Appropriate Fund Balance 500,000 500,000 0 Total General Fund 19,510,206 19,510,206 3,168,368 2/792/244 (376,124) -11.87% 14.31 Fund 101-BUILDING FUND Licenses&Permits 608,708 608,708 101.1451 113,080 11,628 11.46% 18.58 Varies year to year based upon activity/projects Unrestricted Investment Earning 25,003 25,003 4,167 0 (4,167) -100.00% 0.00 Timing in recording Appropriate Fund Balance 618,094 618,094 0 0 Total Building Fund 1.1251,805 11251,805 105,619 113,080 710461 7.06% 9.03 Fund 301-Capital Improvement Fund Sales&Use Taxes 850,467 850,467 1411745 42,652 (99,093) -69.91% 5.02 state revs two month behind,above budgeted Unrestricted Investment Earn 25,000 25,000 41167 0 (4,167) -100.00% 100.00 Timing in recording Grants-State 340,884 340,884 561814 0 (56,814) -100.00% 0.00 Differ from year to year,timing of collection Total Capital Improvement Fund: 11216,351 11,216,351 2021,725 42,652 (160,073) -78.96% 3.51 Fund 303-Capital Projects Fund Unrestricted Investment Earning 9,000 9,000 1500 0 (1,500) -100.00% 100.00 Timing in recording Grants-State 162,500 162,500 27,083 0 (27,083) -100.00% 0.00 Differ from year to year,timing of collection Transfers In 11,280,210 1.1280,210 213,368 0 (213,368) -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 241,952 0 (241,952) -100.00% 0.00 Fund 401-Water Fund Charges for Services 9,380,856 9,380,856 1,563,476 1,325,226 (238,250) -15.24% 14.13 FYE adjustments pending Unrestricted Investment Earn 250,000 250,000 41,667 (63,002) (104,669) -251.20% 100.00 Timing in recording Miscellaneous Revenues 371272 371P272 6,212 0 (6,212) -100.00% 0.00 Differ from year to year Other Financing Sources(icl.loan) 10.1020,000 10,020,000 1.1670,000 25,335 (1,644,665) -98.48% 0.25 Loan proceeds Appropriate Fund Balance 2,075,949 2,075,949 0 0 Total Water Fund: 211764,077 211,764,077 3,281,355 11287,559 (1,993,796) -60.76% 5.92 Fund 402-Refuse&Recycling Charges for Services 718,573 718,573 119,762 113,800 (5,963) -4.98% 15.84 Historically,91%receipted by the end of Feb Unrestricted Investment Earn 7,500 7,500 1,250 0 (1,250) -100.00% 0.00 Timing in recording Appropriate Fund Balance 16,920 16,920 0 0 Total Refuse&Recycling: 742,993 742,993 121,012 113,800 (7,213) -5.96% 15.32 Fund 403-Stormwater Utility Grants State 194,500 194,500 321417 0 (32,417) -100.00% 0.00 Differ from year to year,timing of collection Grants&Contributions 63,000 63,000 10,500 0 (10,500) -100.00% 0.00 Timing in revenue recording Charges for Services 570,600 570,600 95,100 115,093 19,993 21.02% 20.17 Historically,91%receipted by the end of Feb Unrestricted Investment Earn 8,500 8,500 1,417 0 (1,417) -100.00% 0.00 Timing in recording Total Stormwater Utility: 836,600 836,600 139,433 115,093 (24,340) -17.46% 13.76 Fund 501-Vehicle Replacement Intragovernmental Revenue 498,046 498,046 83,008 83,008 0 0.00% 16.67 Transfers In 1,049,790 1,049,790 174,965 (174,965) -100.00% 0.00 FY 2025 not recorded,timing in recording Total Vehicle Replacement 1,547,836 1,547,836 257,973 83,008 (174,965) -67.82% 5.36 Fund 605-Special Law Enforcement Forfeitures 126,009 126,009 21,002 31,747 10,746 51.17% 25.19 Differ from year to year,timing of collection Unrestricted Investment Earn 5,000 5,000 833 0 (833) -100.00% 0.00 Timing in recording Total Special Law Enforcement 131,009 131,009 21,835 31,747 9,912 45.40% 0.00 TOTAL REVENUES-ALL FUNDS 48,702,377 48,702,377 7,540,271 4,579,182 (2,961,089) -39.27% 9.40 NOTES are for differences grater than 10%and amounts over$1,000. Page 1 U6 O A3anda THE VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED FY 2025 FY 2025 16.67 ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 11/30/2024 VARIANCE VARIANCE USED Fund 001-General Fund Council 101,091 101,091 16,849 14,298 2,550 15.14% 14.14(1),(2) Manager 381,662 381,662 63,610 52,169 11,441 17.99% 13.67 Human Resources 501,502 501,502 83,584 79,758 3,825 4.58% 15.90 Village Clerk 464,414 464,414 77,402 74,778 2,624 3.39% 16.10 Finance 842,590 842,590 140,432 128,091 12,341 8.79% 15.20 Legal 246,500 246,500 41,083 14,091 26,992 65.70% 5.72 Comprehensive Planning 409,622 409,622 68,270 42,283 25,987 38.06% 10.32 General Government 770,667 770,667 128,445 116,540 11,904 9.27% 15.12 IT 612,423 612,423 102,071 189,773 (87,702) -85.92% 30.99(3) Police Department 4,357,428 4,357,428 726,238 652,595 73,643 10.14% 14.98(1),(2) Code Compliance 138,325 138,325 23,054 13,350 9,704 42.09% 9.65(1),(2) Fire Control 5,012,483 5,012,483 835,414 714,142 121,272 14.52% 14.25(1),(2) Public Works 1,796,551 1,796,551 299,425 199,841 99,584 33.26% 11.12(1),(2) Leisure Services 1,284,680 1,284,680 214,113 237,858 (23,745) -11.09% 18.51(3) Debt Service 487,300 487,300 81,217 376,556 (295,339) -363.64% 77.27(3) Interfund Transfers 2,030,000 2,030,000 338,333 0 338,333 100.00% 0.00(3) Allocate to Fund Balance* 72,968 72,968 Total General Fund 19,510,206 19,510,206 3,251,701 2,906,126 345,575 10.63% 14.90 Fund 101-BUILDING FUND Building&Zoning 1,176,805 1,176,805 196,134 151,112 45,022 22.95% 12.84(1),(2) Interfund Transfers 75,000 75,000 12,500 0 (12,500) -100.00% 0.00 Total Building Fund 1,251,805 1,251,805 208,634 151,112 57,522 27.57% Fund 301-Capital Improvement Fund General 1031000 103,000 17,167 0 17,167 100.00% 0.00 (2),(3) Parks 931,768 931,768 155,295 0 155,295 100.00% 0.00 (2),(3) Tequesta Drive(Bridge) 100,000 100,000 16,667 0 16,667 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 202,725 0 202,725 100.00% 0.00 Fund 303-Capital Projects Fund Public Works 880,000 880,000 146,667 2911#767 (145,101) -98.93% 33.16 (2),(3) Leisure Services 275,000 275,000 45,833 65,715 (19,882) -43.38% 0.00 (2),(3) Allocate to Fund Balance* 546,500 546,500 0.00 Total Capital Projects Fund: 1,701,500 1,701,500 283,583 357,483 (73,899) -26.06% 21.01 Fund 401-Water Fund Water-Administration 1,961,397 1,961,397 326,900 338,446 (11,546) -3.53% 17.26 Water- Production 2,408,397 2,408,397 401,400 306,312 95,087 23.69% 12.72 Water-Distribution 976,067 976,067 162,678 135,997 26,681 16.40% 13.93 Water-Customer Service 337,316 337,316 56,219 41,166 15,053 26.78% 12.20 Renewal&Replacement 4,243,000 4,243,000 707,167 20,944 686,222 97.04% 0.49 (2) Capital Improvement 11,120,000 11,120,000 1,853,333 481,391 1,371,942 74.03% 0.00(2) Debt Service 492,900 492,900 82,150 73,780 8,370 10.19% 14.97 Interfund Transfers 225,000 225,000 37,500 0 37,500 100.00% 0.00 Total Water Fund: 21,764,077 21,764,077 3,627,346 1,398,037 2,229,310 61.46% 6.42 Fund 402-Refuse&Recycling Refuse and Recycling 742,993 742,993 123,832 0 123,832 100.00% 0.00 (1),(2) Total Refuse&Recycling: 742,993 742,993 123,832 0 123,832 100.00% 0.00 Fund 403-Stormwater Utility Storm Water Utilities 283,289 283,289 47,215 37,063 10,151 21.50% 13.08 Renewal&Replacement 430,152 430,152 71,692 0 71,692 100.00% 0.00 (2),(3) Allocate to Fund Balance* 123,159 123,159 0 0 Total Stormwater Utility: 836,600 836,600 139,433 37,063 102,370 73.42% 4.43 Fund 501-Vehicle Replacement General Government 350,000 350,000 58,333 181,300 (122,967) -210.80% 51.80 Building 45,000 45,000 7,500 0 7,500 100.00% 0.00 Renewal&Replacement 172,500 172,500 28,750 0 28,750 100.00% 0.00 Other Nonoperating 980,336 980,336 163,389 0 163,389 100.00% 0.00 Total Vehicle Replacement 1,547,836 1,547,836 257,973 181,300 76,673 29.72% 11.71 Fund 605-Special Law Enforcement Police 131,009 131,009 21,835 13,881 7,954 36.43% 100.00 (2) Total Special Law Enforcement 131,009 131,009 21,835 13,881 7,954 36.43% 100.00 TOTAL EXPENDITURES-ALL FUNDS 48,702,377 48,702,377 8,117,063 5,045,001 3,072,062 37.85% 10.36 Notes: *Not included in Target Budget calculation (1)Personal expenditures/expenses recorded as when paid not when accrued.Personnel paid 11/21/24 for the period ended 11/16/24. Due to timing of payroll dates 14 days of personnel expenditures not reflected in November 2024. (2)Not all operating expenditures/expenses recorded for the services of November 2024.Expenditures recorded on a cash basis and adjusted to accrual at year end. Pa e 107 of 393 (3)Timing in expenditures/expenses recording and/or recorded as one time entry at year end. Agenda Item #8. November 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 11 99 317 306 Total Master Permits and subpermits Issued 113 1403 1372 1168 New Residential Construction Permits 1 11 5 11 Residential Remodel and additions Permits 4 75 874 671 Commercial Remodel and additions Permits 2 14 56 42 Trade PeFMitS 0 0 566 648 FIRE PERMITS 2 17 56 48 Residential Plan Reviews 103 1276 1074 1342 Commercial Plan Reviews -10 127 56 48 Total Inspections 346 4352 3483 4252 BTR Inspections 3 15 Trade Inspections 157 1143 Vacation Rentals Inspections 4 20 Certificates of Compliance 5 229 267 174 Over the Counter 12 215 243 159 Electronic 101 1194 1300 1263 Complaints or Compliments 4 36 3 3 Record Requests 18 242 246 348 Permit/Code Information Requests 27 390 308 944 Regular Council Meetings 1 12 12 13 Workshop Meeting 1 2 11 13 FFMA-ASFPM Meetings/Training 3 16 30 27 BCAIB-BOAF-BOATC/DBPR Meetings 2 14 22 21 LPA 0 3 24 Code Enforcement Current Month 2023/2024 2022/2023 2021/2022 Code Enforcement Inspections 29 224 175 291 Notices of Violation Issued 3 66 34 60 Rubbish and accumulation 0 7 3 26 Illegal RV/camper/trailer parking 0 32 67 122 Code Cases Opened 13 163 131 254 -By code officer 11 43 -Reactive 2 10 Code Cases Closed 4 95 101 257 Code Cases Cleared Within 30 Days 3 68 79 185 Code Cases Scheduled for Hearing 0 12 17 27 Magistrate Meeting 2 4 4 26 Meeting With Residents Regarding Violations 63 277 168 245 Community Development Current Month 2023/2024 2022/2023 2020/2021 Land Development Applications 6 28 63 48 Board/Council Meetings 3 47 48 14 Ongoing Projects 14 115 106 48 Development Order Time Extensions 0 1 1 - Public Records Requests 1 37 38 - Major Meetings and Conference Calls 6 103 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 Street/250 Beach 2 8 33 30 Community Center/Remembrance Park 0 10 8 2 Residents/Business Owners 8 92 59 27 DRC Meeting 0 3 6 1 Permits(New Single Family and Commercial) 1 22 22 38 Phone Calls/Emails/Walk-Ins 140 1070 3276 1825 Totals Totals Totals Fire Current Month 2023/2024 2022/2023 2021/2022 Station Maintenance 721 1,580 9,049 8,277 Training 709 1,833 9,017 8,997 Fire Fighter Administrative Duties 666 11434 8,700 8,328 COVID 0 0 8.50 330 Page 108 of 393 Agenda Item #8. Unit Response Data Fire 9 25 119 189 EMS 77 179 1,159 1,070 Special Operations 0 3 26 8 Other 9 17 58 61 Mutual Aid Given-Palm Beach County and Martin County Fire Rescue 13 28 223 173 Mutual Aid Received-Palm Beach County/Martin County Fire Rescue 10 21 164 127 COVID 0 0 4 8 Inspection Data New Construction 2 4 69 90 Annual Fire 29 73 345 544 New Business/New Occupation/Home Business 4 4 23 24 Re-Inspections 22 45 226 51 Food Truck/Tents 1 3 19 11 Public Relations Events Data Community Function Hours 100 164 656 651 Station Tours 1 12 130 93 Walk Ins 1 1 16 34 Overtime As of 10/31/2024 Actual Budget Goal/Actual% Overtime Budget $ 131,544.00 100%/8.6% 100%/100.06 100%/109% YTD Totals Totals Human Resources&Risk Management Current Month 2024/2025 2023/2024 2022/2023 Open Positions 1 4 16 21 Applications Received 23 170 573 500 Interviews Conducted 11 11 60 56 Onboardings-Hires 0 0 30 11 Offboardings-Terms 0 0 15 11 Payroll Authorizations&Evaluations 8 46 339 265 EE Benefit Chgs& Verifications 4 6 120 124 EE Recognition-Individual 46 83 375 350 EE Recognition-Group 3 4 4 5 Training-Headcount 7 60 136 193 FMLA Requests 0 3 19 14 Work Comp Claims/FF Cancer Claims 3 4 17 8 Labor Relations(Grievances/Arbitrations/Negotiations etc) 1 1 48 41 Policy and Handbook updates 1 1 3 4 Records Requests 4 5 31 29 HR Information System Adjustments 522 1353 11,666 8359 Newsletter 2 3 13 14 Safety Meetings and Assessments 0 0 5 5 Auto,Property,Liability Claims 1 3 7 14 Totals Totals IT Current Month 2024/2025 2023/2024 2022/2023 Helpdesk Tickets 101 218 1456 1473 Projects PD Laptop Order M365 Prep Totals Parks and Recreation Current Month 2024/2025 2023/2024 2022/2023 Recreation Programs Tai Chi Classes 132 277 2141 2977 Summer Camp 0 0 1350 5100 Open Basketball 200 400 2750 3771 Senior Cinema 0 11 Kids Night Out At The Rec 13 13 30 104 Game Room 140 280 2173 2895 Open Pickleball 200 400 2430 2840 Tequesta Park Pickleball Program 278 612 1192 990 Gymnastics 1202 2820 10267 16716 Facility/Field Rentals for Tequesta Park/Constitution Park/Recreation Center Rentals Constitution Park Pavilion Rentals 25 53 77 84 Good Shepard School Daddy Daughter Dance 0 0 200 200 Page 109 of 393 Agenda Item #8. Good Shepard School PE Class 78 212 897 930 Backpacking Event Rec Center 0 0 0 175 Lax Maniax Lacrosse 0 200 980 335 Creators Game 400 550 1100 2620 Rob Availi Baseball 0 0 1700 1050 Rob Avali Flag Football 0 100 300 300 Palm Beach Revolution(LAX) 400 400 640 240 Jupiter Senior Softball 0 0 300 0 Riverside Oaks 0 0 50 55 TCCCA 25 50 85 73 Tequesta Civic Association 25 25 0 15 Tequesta Trace 0 0 0 20 Tequesta Pines Home Meeting 25 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 700 700 700 400 JTAA Basketball 0 0 500 480 JTAA Baseball 0 0 350 0 Village Rec Center Rentals(Internal) 30 30 150 50 Shredding Event Tequesta Park 0 0 30 30 Tequesta Park Pickleball/Tennis Court Usage 1,500 3000 16,500 19,500 Food Packing Event Gym 0 0 0 400 Activity Room Rental Usage(non HOA) 30 30 200 200 Leatherback Lacrosse 100 100 Sharks Baseball 100 100 Special Events 0 Food Truck 0 800 4800 5,800 Tequesta Roots Festival 0 0 1500 0 Holiday In The Park 0 0 1200 1200 Santa Ride 0 0 700 700 Letters to Santa 0 0 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 1800 1800 1700 1700 Freedom Run 0 0 650 650 Bunny Hop 0 0 500 400 Earth Day Celebration 0 0 0 12 Totals Totals Police Department Current month 2022/2023 2019/2020 2020/2021 Communication Division Officer Initiated Calls 1397 251772 6874 12504 Calls for Service 199 5,231 3931 2327 Fire Rescue 23 406 553 148 Patrol Division Reports Filed 20 628 264 268 Arrest 3 80 62 55 Crashes Investigated 8 180 313 110 Traffic Stops 111 4,872 2463 2032 Citations 51 931 469 373 Warnings 90 21144 606 937 Administration Open Positions 0 1 4 2 Resignations 0 3 3 3 Public Records Request 33 987 480 552 Overtime Actual Budget Goal/Actual% Goal/Actual% Operations $ 118,856.00 96.15%/75.27% 100%/75.27% Sept Totals Totals Totals Public Works Current Month 2024/2025 2023/2024 2022/2023 Properties and Areas Mowed 4 times per month 33 459 393 429 Page 110 of 393 Agenda Item #8. Properties Trimmed Hedges 12 157 135 122 Properties Trimmed Palms and Trees 10 120 100 313 Flowers Planted/Trees 0 1423 1423 280 Properties Fertilized 0 4 4 0 Landscape equipment maintenance frequency per month 8 111 95 93 Sidewalk Repairs and or Grinding 1 58 57 45 Street Signs Replaced 2 86 81 32 Road Repairs 1 28 26 23 Pet Pots Maintained 2 times per week 8 103 87 72 Vegatation Debris in yards 90 900 720 990 Banners Hung 6 56 44 79 Indoor/Outdoor lights Repaired 6 107 89 80 Street Light Outages 4 135 121 57 Work Orders 330 4825 4154 4238 Standby Generator Maintenance 10 180 160 115 Fleet Maintenance-Vehicles Serviced 3 96 83 80 Surplus-Junked or Sold lems 1 69 68 91 811 Locates 2 66 61 22 Engineering Services 2 44 40 32 Resident Calls 23 247 194 161 Event Set-up 10 86 70 69 Projects 16 191 163 177 Totals Totals Totals Village Clerk's Office November 2024-2024 2023-2023 2022-2022 Agendas Compiled and Distributed 3 38 46 52 Minutes Completed(includes council,committees,spec meetings) 3 38 46 52 Council,Committee,Spec Magistrate,and Special Meeting Hours 3.75 61.25 89.75 90 Orders Processed 5 20 26 17 Resolutions Processed 3 22 21 34 Ordinances Processed 2 10 15 15 Agreements Processed 15 90 135 104 Legal Advertisements and Meeting Notices Legal Adv.&Notices(including Ordinances,meeting notices,shade meeting, and union) 14 115 259 167 Bids/RFPs/Quotes 0 3 8 6 Public Records Processed 20 343 303 285 Lien Requests Processed/Revenues Generated 20 204/$22135 358/$37840.50 402/$38,270 Records Imaged/pages scanned 1943 43824 42846 15633 Agenda/Minute Portal(iCompass)Total Monthly Visits 1881 23777 25622 23134 Agenda/Minute Portal(iCompass)Unique Monthly Visits 1377 17537 19998 15995 Notaries/Certification of Living 3 35 41 51 Clerk Requests Help Desk Tickets 7 174 35 121 Public Information Officer Facebook Posts(last 30days) 32 410 557 655 Facebook Messenger Responses(this does not include post responses) 4 61 59 61 Page Followers 6,401 6,233 5627 5367 Page Reach(#of unique users viewing content) 18,700 303,684 1951450 151305 Impressions(unable to access on Facebook) - - - - Reel Plays 2048 - Page Engagement(how many times an action was taken-liked,shared, comment) 429 9311 33301 47721 Instagram Posts(last month) 18 264 334 433 Instagram Stories 25 213 356 387 Reels 3 12 22 14 Content Reach(#of unique users who saw post or story) 2591 23099 31893 22844 Impressions(#of times a story or post was viewed/appeared-no engagement 211328 1261162 235,359 227744 #of Instagram Followers 2,634 2,348 1,833 1515 #of Instagram Post likes for the month 187 4949 5086 6597 Reel Plays 3776 N/A Page Engagement(how many times an action was taken:liked,shared,comml 464 7294 6918 7535 X Posts- 29 346 479 415 X Followers 1046 995 966 932 X Impressions(#of times tweet was viewed or appeared in a user's timeline) 11400 35,148 411287 35874 Page 111 of 393 Agenda Item #8. Reach(not measured on twitter) NA NA NA NA #of Likes 5 84 111 93 X Engagement Rate(new analytic for X-formally Twitter) 3.10% 9.4%high Unk Video Views 197 N/A X Engagement(likes,link clicks,retweets,replies) 12 305 436 286 Nextdoor Posts(last month) N/A 109 288 360 Followers(all Tequesta Subscribers,nextdoor does not have a follow option) N/A 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) 63 951 1215 1201 Press Releases 0 4 8 9 CodeRed Messages Launched 4 56 60 67 Tequesta News Messages(Friday Newsletter) 4 39 45 42 Departmental/Mayor/Other Project Videos 0 3 8 16 Smoke Signals 1 4 4 4 Elections Election: Campaign Treasurer Reports/Candidate Documentation/Office Report 0 2 9 9 Election: Review Candidate Handbook 0 3 11 8 Election: Process filing/qualifying paperwork 2 2 6 1 5 Clerk&Public Information Officer Events&Meetings: ELECTIONS: Assisted the poll workers and elections office in preparing and hosting Election Day voting oversight.Processed signature petitions for 2 candidates;qualified 2 candidates,imaged candidate files,reminded candidates of upcoming reporting dates and to close their bank accounts. Processed election assessesment. SOCIAL MEDIA: Cross posted Parks and Recreation posts to all social media platforms. Diana has mad video editing and social media skills and shot and created 4 Reels(one not used due to FDOT regulations). 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: Held PIO social media training(Diana prepared and presented). ARTNERSHIPS: 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,Pie it Foward,Toy Drive,finalized JHS Student Government academy and other VOT events. Updated lobby TV as needed. MISC: Began the 2025 agenda deadline schedule, worked with governemental associations in regards to council appointments and attedance,Created 2025 Res/Ord tracking chart,reported records compliance to state of Florida,researched Military to Mainstreet program,vehicle title research and processing for sale.Distributed pies to residents who purchased. Participated in badge pinning,oath of office,and 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 Utilities Department-Water Distribution Current Month 2024/25 YTD(FY24) 2023/24 YTD(FY24) 2022/23 YTD(FY23) Water Main Breaks(*-FY21&FY22 service line breaks combined w/water line breaks) 0 1 4 7 Service Line Breaks(*-FY21&FY22 service line breaks combined w/water line breaks) 0 0 17 14 Line Maintenance 64 158 576 181 Equipment Maintenance(Preventive Maintenance) 0 0 25 23 Meter Inspections 26 33 354 518 Meter Reader Related Work Orders 1 2 120 247 Work Orders(Non Meter)/Stormwater:Catchbasins,Outfalls,Pond Mowing&Inspectioi 26 63 756 334 Construction Sites Inspected 16 40 189 177 Employee Call Back 11 22 84 71 Valves Exercised 15 15 54 87 Meter Set/Changed Out 21 22 88 77 Locates Performed 173 341 2250 2,982 Staff Out(Days) 47.69 64.25 400.46 346.54 Utilities Department-Customer Service Current Month 2022/2023 2021/22(FY22) 2020/2021(FY21) Leak Adjustment Requests 6 140 (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)) 85.999 910.633 992.777 963.767 Maximum Day Production Demand Rate(million gallons per day(MGD)) 3.262 3.876 3.71 3.577 Average Daily Production Demand(MGD) 2.867 2.718 2.72 2.64 MGD Monthly Rainfall 0.40 71.55 106.64 78.03 inches Page 112 of 393 Agenda Item #8. **-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 113 of 393 Agenda Item#8. C .2 I E E CD LIU LIU CLCL . . . . . . -cz 2E 2E tr, 16�1 ;� z� .. .- a :� < y y LU LU a0f < Z: T (1) 0 CD (l) C) C) CD LO C) C) C) CD CD 4) 0 CD N CD C) q 0� q q q q q co 4, 6 6 -4 6 6 CD 00 CD CD CD CD C) >w 00 Ea N Ci'> GG 6s (N to C) 6->CIG 60 0 IQ 't P-� IQ (l) M LO 00 00 4, 00 GP* Cl) (14 CL (1) EA 61) X LU C, CD C� a C) a LO a (D C) C) C, C) LO . . q q q q q q q C� q q (D C> C) C) C) C) C) M C) C:) CD C) C) > N ss 0 M > 00 CY) 4) U w n LO n CD CD M n 0 LQ C) q 0 C) M C) C) CD 0 N (0 N U�l 61�1 V) 0 C) (0 6s EA cc 70 (C� C� lz� M Cli al =5 00 co C) 00 C) CN LO 0) Cl) It 6e, ut, 6s CL 66, U'l x LU 0 0 CD C:) CD C:) C) Ul) C) LO CD C) (n q q q q q q q (:)� q O� I I q q C:) 4) 0 0 C) CD C:) C:) C:) 0) M co C:) C:) O :3 U9 (.0 C) U'Y U7(fl W, M I- cc W, GF) 0) N a) �64�6s > CO C5 C6 co 4) SO C) C) O 0 M C) C) C) CD CD C)C) C)C) C) C) 00 q q C� q lz� Q. C� q C� q (::, GS 0 0 C, CD co a M C) C) C) F-- LQ fC 0 0 64 C) M 6q 61) EA 6s (6 CD C�LQ Lr� 't 0) N0 r- N r.- GG 0 M V>Gp� �T 61) LO 69� 0 0 C, C) 00 CD CD CD CD CD 0 0 LO (D C) CD C) CD CD G� NC) C) C) C) Ci C> C) Cl) C) C) CD 0) co LO 0 (D — C) CD C) 0 0 0 00 C) 0') C) C) C) Iq [I- r- 0 (0 00 C:) C) C) CD E 0 LO N Lr� ',�t C� C> a C) C\l C� C� =�Ci 06 N Z! 04 r.- r-- t` C) L6 L6 6 r- M LO LO C) LO 6F> C> U>01), co z N N 0) 0 ; V 6�> M LO 603, EA V� 1- LO:, Qa l(l) x 0) 0) 609- 60) M co 6 LOEA co LO (0.2 1�1- LO N N cq N N N N 0 C:) n Ln M C, C) n n N M LO !2� C!-4 !�� ��4 CO CD N CD CD CD CD cq N NC) Q < < F- >- LL z z LL -'T Cl) M -IT 'r 1* �T cli Z w MN N 1* N N N -q N N It 0 C) N n n n N (n n C4 M N N n N N N n N W t; NO CN N N cli N C) 0 'IT C) 0 C) C) — C4 'T 'IT N N N N N N 00 — Cj C\j w CD S2 >- 0) LL LL Q0 (0 t M LL LL LL LL LL LL . . . . . . U) (1) (0 Cl) 0 0 0 C) CO CO 2 2 2 2 0 LD .0 M ML) a- a- O 'U16 C: 0 .- .- .0 — — .2 E E E _0 _0 M co �p N E2 E E 0) a) 2m a) 2 0 (D 0 0 2 C) C) 0 0 -C� 0- c (D �:, >1 c r- C: c: -LD U) LLJ 0) 0) Q) (D 0 0 +C� 0) a) r 1�0- 2 $� E) 2) .5 .5 L cn E cu M - - 0 a) c c 0 cu E E _j (n LU w (n rn ( E E 15 C: c 0 0 a) L-D LU LU 0 >1 5; 5 c C: c 2: 0 -�6 -(� =5 =3 LLJ M 0 M 0 .21.0 0 0 E F= 2� U) _0 ±:! = 00 0 0 im M a) M M M 0 CL cm CL 0- 0� a) cu 00 CUM cum WO -C .2) MmEMEE '2 ' UL) O) a) 00 .2 0 M M M 0 0 co co M M 0 C) E E 08 �5EotQ) 008 -ffi 88 0X 0 in co F 6 0 LL E: M < 0 0 M LL LL a_ EL 0- a- LL LL -j LL a) cn cn w0 0 0 a) .0 > -0 a) LU a) E -0 6 _j a) .2 .2? a) a) 0 -0 '6,0 pj aai U- > > > U) < 5 U- U cq ❑ rn -2 co 0 > 0 CO > 2 E E (1) CY) -C ME, cu U) U) U) o E E CO 0- > H 0 �M CY) CL C cu cu .2) W cf) .2 -0 cz E cu L) o z > cc -1- .2 .2 Z 5 co M M LU LL LL c i Cl) 2 U) 12 CD E E Q) ED E w Page 114 of 393 Z6 = = E cn (n .7 0 0 0 M a) (3) Of a-I<1 0- T- 0 0 -1 d Of �1-1 1 1 . . I I I . 1 0