Loading...
HomeMy WebLinkAboutDocumentation_Regular_Tab 08_5/9/2024 Agenda Item #8. Regular Council STAFF MEMO Meeting: Regular Council - May 09 2024 Staff Contact: Jeremy Allen, Village Manager Department: Manager Village Manager Standing Report 1. The Financial Reports presented above are unadjusted and unaudited. The Village considers revenues available if collected within 60 days of the current fiscal period. This means that there are additional revenues and expenditures that have not been recorded to date and that will be recorded once year-end adjustments are completed. Additionally, during the year, revenues and expenses are recorded on a modified accrual basis (similar to a cash basis). This will result in significant differences between our beginning balances in the enterprise funds (water, refuse and recycling and stormwater) and the adjusted ending balances as these funds report on a full accrual basis. 2. Property Taxes — collected at $11 million, which represents 96% of the budgeted amount. It is $1.7 million (19%) higher than for the same period of the prior fiscal year. Historically, 91% of ad valorem tax distribution receipted by the end of February. 3. Sales/use taxes (47%), 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 108%. Insurance premium tax ($307 thousand) to be collected at the year-end as one distribution. Sales/use taxes are on target for six months collections. 4. Intergovernmental revenues (58%) which include municipal revenue sharing, half-cent sales tax, and local gas tax are one month behind the collection/reported period. It is slightly above budget target for six months collections due to the half-cent sales tax revenue increase (by 11%) collection/distribution. 5. Revenues (Budgetary comparison) recorded in the General fund represents 83% of budgeted due to the distribution nature of Ad valorem taxes collected at 96%, representing 79% of overall General fund revenues at 4/30/2024. 6. Overall Expenditures (Budgetary comparison) in the General Fund represents 51% of budgeted. Not all the expenditures recorded for the services provided for the month of April 2024 and personnel expenditures recorded as paid not when accrued. 7. Revenues (Prior year comparison) all funds increased by $2.4 million (13%) mainly due to Ad valorem taxes collected $1.7 million (19%) higher than same period of prior year, increased investment earnings and implementation of a new capital recovery charge in water fund. Page 101 of 226 Agenda Item #8. 8. Expenditures (Prior year comparison) all funds increased by $2 million (16%) due to capital improvement and storm water projects and fire truck purchase in FY 2024. 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 N/A AMOUNT AVAILABLE N/A EXPENDITURE AMOUNT: N/A FUNDING SOURCES: N/A IS THIS A PIGGYBACK: ❑ Yes ❑ N/A DID YOU OBTAIN 3 QUOTES? ❑ Yes ❑ N/A COMMENTS/EXPLANATION ON SELECTIONN/A Apr 2024 Page 102 of 226 4 02f Itotr / � BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/8 �+ rr acan Period Ending 04/30/2024 DB: Teauesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 872,437.64 Investments 11,848,315.76 Accounts Receivable 1,059,776.18 Due from Other Funds 0.00 Accrued Income Receivable 20,458.14 Inventories 44, 939.40 Prepaids 74,312.54 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 13,920,239.66 *** Liabilities *** Accounts Payable (81.95) Accrued liabilities 4,152.23 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 2, 637.34 Deferred Revenue 804, 687.83 Other Current Liabilities 413.55 Customer Deposits 0.00 Noncurrent liabilities 0.00 Total Liabilities 811,809.00 *** Fund Balance *** F/B - Reserved for Inventories 0.00 F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Ncnspendable 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 8,028,735.58 Net of Revenues VS Expenditures 5,079,695.08 Ending Fund Balance 13,108,430.66 Total Liabilities And Fund Balance 13,920,239.66 Page 103 of 226 4 0ifItotr / � BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/8 rr acan Period Ending 04/30/2024 DB: Teauesta Fund 101 BUILDING FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 70,879.09 Investments 759,714.49 Accounts Receivable 46.81 Inventories (55.52) Prepaids 3,063.90 Total Assets 833,648.77 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Due to Other Governments 3,305.11 Total Liabilities 3,305.11 *** 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 1,063,643.93 Beginning Fund Balance 1,063,643.93 Net of Revenues VS Expenditures (233,300.27) Ending Fund Balance 830,343.66 Total Liabilities And Fund Balance 833,648.77 Page 104 of 226 4 0ifItotr / � BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/8 rr acan Period Ending 04/30/2024 DB: Teauesta Fund 301 CAPITAL IMPROVEMENT FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 112,861.90 Investments 922,521.52 Accounts Receivable (4,044.60) Due from Other Funds 0.00 Prepaids 0.00 Total Assets 1,031,338.82 *** 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 1,296,672.76 Net of Revenues VS Expenditures (265,333.94) Ending Fund Balance 1,031,338.82 Total Liabilities And Fund Balance 1,031,338.82 Page 105 of 226 4 02f Itotr / � BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/8 �+ rr acan Period Ending 04/30/2024 DB: Teauesta Fund 303 CAPITAL PROJECTS FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 2,848.04 Investments 260,783.40 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 263,631.44 *** 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 262,355.05 Net of Revenues VS Expenditures 1,276.39 Ending Fund Balance 263,631.44 Total Liabilities And Fund Balance 263,631.44 Page 106 of 226 4 0ifItotr / � BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/8 rr acan Period Ending 04/30/2024 DB: Teauesta Fund 401 WATER FUND GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 903,255.75 Investments 9,391,805.66 Accounts Receivable 586,781.21 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Accrued Income Receivable 18,480.00 Inventories 254,260.08 Prepaids 21,184.54 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 779,719.98 FIXED ASSETS 0.00 Total Assets 27,913,856.63 *** Liabilities *** Accounts Payable (0.01) Accrued liabilities 0.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 431,555.63 Other Current Liabilities 0.00 Customer Deposits 45,290.00 Noncurrent liabilities 1,546,007.99 Other Long Term Liabilities 614,526.23 Def Inflows of Resources 538,011.00 Total Liabilities 3,175,694.82 *** 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,551,969.25 Net of Revenues VS Expenditures 1,186,192.56 Ending Fund Balance 24,738,161.81 Total Liabilities And Fund Balance 27,913,856.63 Page 107 of 226 4 0ifItotr / � BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/8 rr acan Period Ending 04/30/2024 DB: Teauesta Fund 402 REFUSE & RECYCLING GL Number Description Balance *** Assets *** Cash and Cash Equivalents 58, 659.75 Investments 259,589.91 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 318,249.66 *** 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 47,572.37 Net of Revenues VS Expenditures 270,677.29 Ending Fund Balance 318,249.66 Total Liabilities And Fund Balance 318,249.66 Page 108 of 226 4 0ifItotr / � BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/8 rr acan Period Ending 04/30/2024 DB: Teauesta Fund 403 STORMWATER UTILITY GL Number Description Balance *** Assets *** Cash and Cash Equivalents 100,203.96 Investments 298,038.31 Accounts Receivable 662.48 Due from Other Funds 0.00 Inventories (150.90) 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 58,819.00 Total Assets 2,673,388.54 *** 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 42,744.70 Def Inflows of Resources 13, 630.00 Total Liabilities 56,374.70 *** 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 480,853.59 Total Fund Balance 2,512,538.65 Beginning Fund Balance 2,512,538.65 Net of Revenues VS Expenditures 104,475.19 Ending Fund Balance 2,617,013.84 Total Liabilities And Fund Balance 2,673,388.54 Page 109 of 226 4 02f Itotr / � BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 8/8 �+ rr acan Period Ending 04/30/2024 DB: Teauesta Fund 605 SPECIAL LAW ENFORCEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 25, 665.47 Investments 267, 972.28 Accounts Receivable 217.65 Inventories 0.00 Prepaids 0.00 Total Assets 293,855.40 *** Liabilities *** Accounts Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** Fund Balance - Ncnspendable 3,584.52 Fund Balance - Restricted 298,780.00 Fund Balance - Assigned 13,034.00 Fund Balance - Unassigned (0.94) Total Fund Balance 315,397.58 Beginning Fund Balance 315,397.58 Net of Revenues VS Expenditures (21,542.18) Ending Fund Balance 293,855.40 Total Liabilities And Fund Balance 293,855.40 Page 110 of 226 Agenda Item #8. VILLAGE OF TEQUESTA Cash&Investments Unadjusted Unaudited 4/30/2024 Cash and cash equivalents Investments Total General Fund#001 $ 872,438 $ 11,848,316 $ 12,720,753 Building Fund#101 70,879 759,714 830,594 Capital Improvement Fund#301 112,862 922,522 1,035,383 Capital Projects Fund#303 2,848 260,783 263,631 Water Utility#401 903,256 9,391,806 10,295,061 Refuse &Recycling#402 58,660 259,590 318,250 Stormwater#403 100,204 298,038 398,242 Special Law Enforcement#605 25,665 267,972 293,638 Total Cash and Investments $ 2,146,812 $ 24,008,741 $ 26,155,553 *Interfund transfer pending Page 111 of 226 VILLAGE OF TEQUESTA Agenda Item #8. REVENUE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 4/30/2023 4/30/2024 VARIANCE %VARIANCE NOTES REVENUES Fund 001-GENERAL FUND General Property Taxes 9,311,857 11,040,665 1,728,808 18.57% Advalorem taxes increase Sales&Use Taxes 940,043 611,765 (328,277) -34.92% Infrastructure&Utility tax recorded in fund#301 in FY24 Franchise fees-gross receipt 280,834 294,235 13,401 4.77% Licenses&Permits 5,280 2,600 (2,680) -50.76% Rental permits Grants-Federal 47,475 0 (47,475) -100.00% Differs from year to year Grants-State 7,924 19,272 11,348 143.21% Differs from year to year Intergovernmental Revenue 549,917 563,443 13,526 2.46% Chgs for Services-Gen Gov 151,387 135,443 (15,945) -10.53% Land development fees based on the projects Indirect Costs 503,460 526,745 23,285 4.62% Rents&Royalties 222,179 190,499 (31,680) -14.26%Timing in leases revenue recording Contributions&Donations 14,734 1,450 (13,284) -90.16% Differs from year to year,timing in recording Miscellaneous Revenues 25,738 20,618 (5,121) -19.90% Differs from year to year Chgs for Services-Public Safety 599,407 686,766 87,359 14.57% EMS fees collection increase Fines&Forfeitures 6,685 8,817 2,133 31.90% Code enforcement fees Impact Fees 1,764 11,154 9,390 532.21% Impact fees based on the projects Grants and Contributions-Local 8,675 0 (8,675) -100.00% Differs from year to year Charges for Services-Recreation 59,500 114,816 55,316 92.97% Recreation programs fees increase Unrestricted Investment Earning 226,913 240,125 13,212 5.82%Active investing,balance and rate increases Other Financing Sources 10,000 46,668 36,668 366.68% Sale of assets(fire truck) Total General Fund 12,973,771 14,515,080 1,541,309 11.88% Fund 101-BUILDING FUND Licenses&Permits 411,261 339,048 (72,213) -17.56%Varies year to year based upon activity/projects Charges for Services 1,341 1,214 (127) -9.45% Miscellaneous Revenues 0 2 2 100.00% Unrestricted Investment Earning 13,820 23,089 9,269 67.07%Active investing,balance and rate increases Total Building Fund 426,422 363,353 (63,069) -14.79% Fund 301-Capital Improvement Fund Sales&Use Taxes 0 375,652 375,652 100.00% Infrastructure surtax and water utility tax Unrestricted Investment Earning 13,341 29,790 16,449 123.30% Active investing,balance and rate increases Total Capital Improvement Fund 13,341 405,442 392,101 100.00% Fund 303-Capital Projects Fund Unrestricted Investment Earning 0 6,553 6,553 100.00% Active investing,balance and rate increases Total Capital Projects Fund: 0 6,553 6,553 100.00% Fund 401-Water Fund Miscellaneous Revenues 30,783 31,881 1,098 3.57% Fines&Forfeitures 750 0 (750) -100.00% Unrestricted Investment Earning 125,454 206,573 81,118 64.66% Active investing,balance and rate increases Other Financing Sources 80,697 45,065 (35,631) -44.15% Capital connect charge based on the projects Charges for Services 3,804,649 4,409,852 605,203 15.91% New Capital Recovery charge implemented in FY 2024 Total Water Fund: 4,042,332 4,693,370 651,038 16.11% Fund 402-Refuse&Recycling Unrestricted Investment Earning 304 6,606 6,302 2072.59%Active investing,balance and rate increases Charges for Services 555,442 570,941 15,499 2.79% Total Refuse&Recycling: 555,746 577,547 21,801 3.92% Fund 403-Stormwater Utility Miscellaneous Revenues 0 5,515 5,515 100.00% Grants and Contributions-Local 14,385 0 (14,385) -100.00% Differ from year to year Unrestricted Investment Earning 275 7,713 7,438 2706.53% Active investing,balance and rate increases Charges for Services 502,046 510,436 8,390 1.67% Total Stormwater Utility: 516,705 523,664 6,959 1.35% Fund 605-Special Law Enforcement Forfeitures 194,548 623 (193,925) -99.68% Differ from year to year Unrestricted Investment Earning 1,619 6,674 5,055 312.21% Active investing,balance and rate increases Total Special Law Enforcement 196,167 7,298 (188,870) -96.28% TOTAL REVENUES-ALL FUNDS 18,724,485 21,092,307 2,367,822 12.65% NOTES are for differences grater than 10%and amounts over$1,000. Page 112 of 226 Agenda Item #8. VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE % DESCRIPTION 4/30/2023 4/30/2024 VARIANCE VARIANCE NOTES EXPENDITURES Fund 001-GENERAL FUND Council 31,703 34,124 2,421 7.64% Manager 175,451 214,704 39,253 22.37% Wages,sick leave buy back-retirement,insurance Human Resources 230,832 254,796 23,964 10.38% Wages,sick leave buy back,employee recogn,recruit Village Clerk 230,576 245,592 15,016 6.51% Finance 424,095 475,124 51,028 12.03% Wages,ClearGov software purchase$24K,auditing svcs Legal 106,421 124,148 17,726 16.66% Differs from year to year based upon service needs Comprehensive Planning 156,890 164,480 7,590 4.84% General Government 139,996 179,793 39,797 28.43% Other contractual svcs and insurance increase IT 318,472 363,663 45,191 14.19% Wages,computer system maint&supply,contr svcs Police Department 2,078,136 1,971,964 (106,172) -5.11% Timing in payments recording Code Compliance 48,360 23,052 (25,308) -52.33% Vacancies Fire Control 2,410,409 3,225,535 815,126 33.82% Fire truck purchase Public Works 834,260 851,778 17,519 2.10% Leisure Services 701,889 786,882 84,993 12.11% P/T salaries,ins,program fees and misc park projects Debt Service 568,887 519,749 (49,138) -8.64% Pumper financed purchase paid in full Total General Fund 8,456,377 9,435,384 979,007 11.58% Fund 101-BUILDING FUND Building Department 511,888 596,653 84,766 16.56% Regular salaries,comp abs,other contr svcs increase Total Building Fund 511,888 596,653 84,766 16.56% Fund 301-Capital Improvement Fund General 0 6,975 6,975 100.00% Projects varies year to year Public Works 3,675 478,161 474,486 12911.17% Projects varies year to year Parks 0 9,466 9,466 100.00% Projects varies year to year Miscellaneous projects 127,174 176,174 49,001 38.53% Projects varies year to year Total Capital Improvement Fund: 130,849 670,776 539,927 100.00% Fund 303-Capital Projects Fund Parks 0 5,276 5,276 100.00% Projects varies year to year Total Capital Projects Fund: 0 5,276 5,276 100.00% Fund 401-Water Fund Water-Administration 815,627 985,794 170,167 20.86% Insurance,engineering svcs,comp system maint Water- Production 1,141,199 1,100,373 (40,826) -3.58% Water-Distribution 478,943 406,738 (72,205) -15.08% Pension exp-timing in recording,ins,water system maint Water-Customer Service 175,408 177,887 2,479 1.41% Renewal&Replacement 400,088 421,913 21,825 5.46% Differs from year to year based upon projects Capital Improvements 0 146,025 146,025 100.00% Differs from year to year based upon projects Debt Service 267,083 268,499 1,416 0.53% Other Nonoperating 0 (51) (51) -100.00% Total Water Fund: 3,278,348 3,507,178 228,830 6.98% Fund 402-Refuse&Recycling Refuse and Recycling 301,232 306,870 5,638 1.87% Total Refuse&Recycling: 301,232 306,870 5,638 1.87% Fund 403-Stormwater Utility Storm Water Utilities 168,711 177,288 8,577 5.08% Renewal&Replacement 23,532 241,901 218,369 927.96% Differs from year to year based upon projects Total Stormwater Utility: 192,243 419,189 226,946 118.05% Fund 605-Special Law Enforcement Police 71,291 28,840 (42,451) -59.55% Differs from year to year based upon needs Total Special Law Enforcement: 71,291 28,840 (42,451) -59.55% TOTAL EXPENDITURES-ALL FUNDS 12,942,227 14,970,166 2,027,939 15.67% NOTES are for differences grater than 10%and amounts over$1,000. Page 113 of 226 Benda Item #8. THE VILLAGE OFTEQUESTA REVENUE REPORT-CASH BASIS,UNAUDITED FY 2024 FY 2024 58.33% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 4/30/2024 VARIANCE VARIANCE USED NOTES Fund 001-GENERAL FUND General Property Taxes 11,524,090 11,524,090 6,722,386 11,040,665 4,318,279 64.24% 95.81 Historically,91%receipted bythe end of Feb State revs two month behind,record-cash basis,ins preen Sales&Use Taxes 1,350,252 1,350,252 787,647 611,765 (175,882) -22.33% 45.31 tax received as one distrib at FYE($30710 Franchise fees-gross receipt 530,938 530,938 309,714 294,235 (15,479) -5,00% 55.42 One month behind Licenses&Permits 9,000 9,000 5,250 2,600 (2,650) -50.48% 28.89 special events,vacational rental permits Indirect Costs 902,991 902,991 526,745 526,745 0 0.00% 58.33 Grants Federal 25,737 25,737 15,013 0 (15,013) -100.00% 0.00 Differ from year to year,timing of collection Grants-State 77,000 137,728 80,341 19,272 (61,069) -76.01% 13.99 Differ from year to year,timing of collection Intergovernmental Revenue 984,222 984,222 574,130 563,443 (10,687) -1.86% 57.25 State revs one more month to he recorded Grants and Contributions-Local 14,084 14,084 8,216 0 (8,216) -100.00% 0.00 Differ from year to year,timing of collection Chgs for Services-Gen Gov 208,645 208,645 121,710 135,443 13,733 11.28% 64.92 Land development fees based on projects Chgs for Services-Public Safety 1,227,355 1,227,355 715,957 686,766 (29,191) -4.08% 55.95 Charges for Services-Recr. 62,500 62,500 36,458 114,816 78,358 214.92% 183.71 Rec program fees increase Fines&Forfeitures 18,275 18,275 10,660 8,817 (1,843) -17.29% 48.25 Code enrfines&fees Unrestricted Investment Earning 280,500 280,500 163,625 240,125 76,500 46.75% 85.61 Active investing,balance and rate increases Rents&Royalties 188,839 188,839 110,156 190,499 80,343 72.94% 100.88 Timing in revenue recording Impact Fees 8,169 8,169 4,765 11,154 6,389 134.07% 136.54 Differ from yr to yr depending on projects/permits Contributions&Donations 10,000 30,000 17,500 1,450 (16,050) -91,71% 4.83 Differ from year to year events depending Miscellaneous Revenues 13,205 13,205 7,703 20,618 12,915 167.66% 156.13 Differ from year to year Other Financing Sources 8,398 8,398 4,899 46,668 41,769 852,63% 555.70 sale of assets(fire truck) Appropriate Fund Balance 0 0 0 Total General Fund 17,444,200 17,524,928 10,222,875 14,515,080 4,292,205 41.99% 82.83 Fund 101-BUILDING FUND Licenses&Permits 608,708 608,708 355,080 339,048 (16,032) -4.51% 55.70 varies year to year based upon activity/projects Chgs for Sery-Gen Gov 0 0 0 1,214 1,214 100,00% 100.00 Unrestricted Investment Earning 15,000 15,000 8,750 23,089 14,339 163.88% 153.93 Active investing,balance and rate increases Miscellaneous Revenues 0 0 0 2 2 100,00% 0.00 Appropriate Fund Balance 564,262 612,632 0 Total Building Fund 1,187,970 1,236,340 363,830 363,353 (476) -0.13% 29.39 Fund 301-Capital Improvement Fund Sales&Use Taxes 757,055 757,055 441,615 375,652 (65,963) -14.94% 49.62 state revstwo month behind,above budgeted Unrestricted Investment Earn 0 0 0 29,790 29,790 100.00% 100.00 Active investing,balance and rate increases Transfers In 15,000 15,000 8,750 0 (8,750) -100.00% 0.00 FY 2024 not recorded,tfrs recorded at year end Appropriate Fund Balance 481,909 481,909 0 Total Capital Improvement Fund: 1,253,964 1,253,964 450,365 405,442 (44,923) -9.97% 32.33 Fund 303-Capital Projects Fund Unrestricted Investment Earning 0 0 0 6,553 6,553 100.00% 100.00 Active investing,balance and rate increases Grants-State 200,000 200,000 116,667 0 (116,667) -100.00% 0.00 Timing in revenue recording Transfers In 1,884,895 1,884,895 1,099,522 0 (1,099,522) -100.00% 0.00 FY2024 not recorded,tfrs recorded atyearend Total Capital Projects Fund: 2,084,895 2,084,895 1,216,189 6,553 (1,209,636) -99.46% 0.00 Fund 401-Water Fund Charges for Services 8,234,600 8,234,600 4,803,517 4,409,852 (393,665) -8,20% 53.55 watersales revenue recording one month behind Unrestricted Investment Earn 0 0 0 206,573 206,573 100.00% 100.00 Active investing,balance and rate increases Miscellaneous Revenues 37,272 37,272 21,742 31,881 10,139 46,63% 85.53 Differfromyeartoyear Other Financing Sources(icl.loan) 8,620,000 8,620,000 5,028,333 45,065 (4,983,268) -99.10% 0.52 Loan proceeds,recorded when received Appropriate Fund Balance 2,112,271 2,112,271 0 0 Total Water Fund: 19,004,143 19,004,143 9,853,592 4,693,370 (5,160,222) -52,37% 24.70 Fund 402-Refuse&Recycling Charges for Services 592,403 592,403 345,568 570,941 225,373 65,22% 96.38 Historically,91%receipted bythe end of Feb Unrestricted Investment Earn 500 500 292 6,606 6,314 2164.91% 1,321.20 Active investing,balance and rate increases Appropriate Fund Balance 19,697 19,697 0 0 Total Refuse&Recycling: 612,600 612,600 345,860 577,547 231,687 66.99% 94.28 Fund 403-Stormwater Utility Grants&Contributions 252,500 252,500 147,292 0 (147,292) -100.00% 0.00 Timing in revenue recording Charges for Services 545,550 545,550 318,238 510,436 192,198 60.39% 93.56 Historically,91%receipted bythe end ofFeb Unrestricted Investment Earn 500 500 292 7,713 7,422 2544.52% 1,542.64 Active investing,balance and rate increases Miscellaneous Revenues 0 0 0 5,515 5,515 100.00% 100.00 Differ from year to year Appropriate Fund Balance 28,768 28,768 0 Total Stormwater Utility: 827,318 827,318 465,821 523,664 57,843 12.42% 63.30 Fund 605-Special Law Enforcement Forfeitures 25,000 25,000 14,583 623 (13,960) -95.73% 2.49 Differ from year to year,timing of collection Unrestricted Investment Earn 1,500 1,500 875 6,674 5,799 662.79% 0.00 Active investing,balance and rate increases Appropriate Fund Balance 138,161 138,161 0 0 0.00 Total Special Law Enforcement 164,661 164,661 15,458 7,298 (8,161) -52.79% 0.00 TOTAL REVENUES-ALL FUNDS 42,579,751 42,708,849 22,933,990 21,092,307 (1,841,683) -8,03% 49.39 Page 114 of 226 NOTES are for differences grater than 10%and amounts over$1,000. A THE VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED FY 2024 FY 2024 58.33% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 4/30/2024 VARIANCE VARIANCE USED Fund 001-General Fund Council 74,640 74,640 43,540 34,124 9,416 21.63% 45.72(1),(2) Manager 362,368 362,368 211,381 214,704 (3,322) -1.57% 59.25(1),(2) Human Resources 456,599 456,599 266,349 254,796 11,554 4.34% 55.80(1),(2) Village Clerk 447,453 447,453 261,014 245,592 15,422 5.91% 54.89(1),(2) Finance 807,224 807,224 470,881 475,124 (4,243) -0.90% 58.86 Legal 195,000 195,000 113,750 124,148 (10,398) -9.14% 63.67(1),(2) Comprehensive Planning 495,338 508,808 296,805 164,480 132,324 44.58% 32.33(1),(2) General Government 328,215 329,212 192,040 179,793 12,247 6.38% 54.61(1),(2) IT 535,503 549,931 320,793 363,663 (42,870) -13.36% 66.13(3) Police Department 3,748,841 3,829,569 2,233,915 1,971,964 261,951 11.73% 51.49(1),(2) Code Compliance 109,261 109,261 63,736 23,052 40,684 63.83% 21.10(1),(2) Fire Control 4,764,250 5,501,292 3,209,087 3,225,535 (16,448) -0.51% 58.63(1),(2) Public Works 1,626,076 1,682,545 981,484 851,778 129,706 13.22% 50.62(1),(2) Leisure Services 1,201,176 1,210,152 705,922 786,882 (80,960) -11.47% 65.02(3) Debt Service 542,250 542,250 316,313 519,749 (203,437) -64.32% 95.85(3) Interfund Transfers 1,700,008 1,700,008 991,671 0 991,671 100.00% 0.00(3) Allocate to Fund Balance* 49,998 49,998 Total General Fund 17,444,200 18,356,310 10,707,848 9,435,384 1,272,464 11.88% 51.40 Fund 101-BUILDING FUND Building&Zoning 1,187,970 1,237,167 721,681 596,653 125,027 17.32% 48.23(1),(2) Total Building Fund 1,187,970 1,237,167 721,681 596,653 125,027 17.32% Fund 301-Capital Improvement Fund General 65,000 65,000 37,917 6,975 30,942 81.60% 10.73 (2),(3) Public Works 210,000 805,782 470,040 478,161 (8,121) -1.73% 59.34 (2),(3) Parks 175,077 175,077 102,128 9,466 92,662 90.73% 5.41 (2),(3) Tequesta Drive(Bridge) 44,000 44,000 25,667 0 25,667 100.00% 0.00 (2),(3) Tequesta Park 250,000 250,000 145,833 0 145,833 100.00% 0.00 (2),(3) Misc Projects 310,000 331,314 193,267 176,174 17,093 8.84% 53.17 (2),(3) Interfund Transfers 199,887 199,887 Total Capital Improvement Fund: 1,253,964 1,871,061 1,091,452 670,776 420,676 38.54% 35.85 Fund 303-Capital Projects Fund Public Works 710,000 710,000 414,167 0 414,167 100.00% 0.00 (2),(3) Leisure Services 1,250,000 1,250,000 729,167 5,276 723,890 99.28% 0.00 (2),(3) Allocate to Fund Balance* 124,895 124,895 0.00 Total Capital Projects Fund: 2,084,895 2,084,895 1,216,189 5,276 1,210,913 99.57% 0.25 Fund 401-Water Fund Water-Administration 1,711,930 1,832,727 1,069,091 985,794 83,297 7.79% 53.79 Water- Production 2,280,598 2,305,499 1,344,874 1,100,373 244,502 18.18% 47.73 (1),(2) Water-Distribution 889,331 890,761 519,611 406,738 112,873 21.72% 45.66 Water-Customer Service 320,184 320,184 186,774 177,887 8,887 4.76% 55.56 Renewal&Replacement 3,753,000 4,382,290 2,556,336 421,913 2,134,423 83.50% 9.63 (2) Capital Improvement 9,555,000 11,630,465 6,784,438 146,025 6,638,412 97.85% 0.00(2) Debt Service 494,100 494,100 288,225 268,499 19,726 6.84% 54.34 Other Nonoperating 0 0 0 (51) (51) -100.00% 0.00 Total Water Fund: 19,004,143 21,856,025 12,749,348 3,507,178 9,242,170 72.49% 16.05 Fund 402-Refuse&Recycling Refuse and Recycling 612,600 612,600 357,350 306,870 50,480 14.13% 50.09 (1),(2) Total Refuse&Recycling: 612,600 612,600 357,350 306,870 50,480 14.13% 50.09 Fund 403-Stormwater Utility Storm Water Utilities 373,318 459,261 267,902 177,288 90,614 33.82% 38.60 (1),(2) Renewal&Replacement 454,000 701,196 409,031 241,901 167,130 40.86% 34.50 (2),(3) Total Stormwater Utility: 827,318 1,160,457 676,933 419,189 257,744 38.08% 36.12 Fund 605-Special Law Enforcement Police 164,661 177,695 103,655 28,840 74,816 72.18% 100.00 (2) Total Special Law Enforcement 164,661 177,695 103,655 28,840 74,816 72.18% 100.00 TOTAL EXPENDITURES-ALLFUNDS 42,579,751 47,356,210 27,624,456 14,970,166 12,654,290 45.81% 31.61 Notes: *Not included in Target Budget calculation (1)Personal expenditures/expenses recorded as when paid not when accrued.Personnel paid 4/25/24 for the period ended 4/20/24. Due to timing of payroll dates 10 days of personnel expenditures not reflected in April 2024. (2)Not all operating expenditures/expenses recorded for the services of April 2024.Expenditures recorded on a cash basis and adjusted to accrual at year end. Page 5 f 226 (3)Timing in expenditures/expenses recording and/or recorded as one time entry at year end.