The URL can be used to link to this page

Home My WebLink AboutDocumentation_Regular_Tab 06_2/10/2022Agenda Item #6. Regular Council STAFF MEMO Meeting: Regular Council - Feb 10 2022 Staff Contact: Jeremy Allen, Village Manager Department: Manager Manager's Report Through January CRY: 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 $7.2 million, which represents 88% of the budgeted amount. It is $515 thousands (8%) 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 (23%), which include local infrastructure surtax, insurance premium, utility, communication service and local business tax, fell below budget target due to the distribution to be one/two month behind the collection/reported period and Insurance premium tax ($263 thousand) to be collected at the year-end as one distribution, with the exception of the Local Business Tax collected at 90%. Sales/use taxes are on target for three month's collections. 4. Intergovernmental revenues (28%) which include municipal revenue sharing, half -cent sales tax, local gas tax, fall below budget target due to the distribution to be one month behind the collection/reported period and is slightly above target for three month's collections. 5. Local discretionary infrastructure surtax(16%) - collected at $75 thousand, which represent 16% of the budgeted amount for only two month's collection/reported period and is on a target for three month's collections. 6. Revenues (Budgetary comparison) recorded in the General fund represents 52% of budgeted due to the distribution nature of Ad valorem taxes collected at 88%, representing 81 % of overall General fund revenues at 1/31/2022. 7. Overall Expenditures (Budgetary comparison) in the General Fund represents 26% of budgeted. Not all the expenditures recorded for the services provided up to 1/31/22 and personnel expenditures recorded as paid not when accrued. Page 63 of 243 Agenda Item #6. 8. Revenues (Prior year comparison) all funds decreased due to loan proceeds recorded in FY 2021 ($6.9 millions) and offset by Ad valorem taxes collected $515 thousand higher than same period of prior year. 9. Expenditures (Prior year comparison) all funds has increased by $818 thousand (12%) due to debt service for capital projects and Recreation Facility project expenditures. 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. BUDGETED AMOUNT: NA AVAILABLE AMOUNT: NA EXPENDITURE AMOUNT: NA Additional Budgetary Information: Funding Source(s): NA NA Jan 2022 reports Copy of January 2022 Grant Budget Worksheet Page 64 of 243 G'� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/8 ?�Sooraicaftnot�i Period Ending 01/31/2022 DB: Tequesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 4,264,524.29 Investments 6,025,071.96 Accounts Receivable 399,052.25 Due from Other Funds 0.00 Inventories 79,416.78 Prepaids 354,964.74 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 11,123,030.02 *** Liabilities *** Accounts Payable 326,979.70 Accrued liabilities 138,228.68 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 1,205.54 Deferred Revenue 107,742.73 Other Current Liabilities 238.47 Customer Deposits 0.00 Noncurrent liabilities 0.00 Total Liabilities 574,395.12 *** 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 732,799.97 Fund Balance - Restricted 364,007.00 Fund Balance - Committed 500,000.00 Fund Balance - Assigned 55,709.00 Fund Balance - Unassigned 1,741,952.67 Total Fund Balance 3,394,468.64 Beginning Fund Balance - 20-21 3,394,468.64 Net of Revenues VS Expenditures - 20-21 2,811,910.94 *20-21 End FB/21-22 Beg FB 6,206,379.58 Net of Revenues VS Expenditures - Current Year 4,342,255.32 Ending Fund Balance 10,548,634.90 Total Liabilities And Fund Balance 11,123,030.02 * Year Not Closed Page 65 of 243 G'� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/8 ?�Sooraicaftnot�i Period Ending 01/31/2022 DB: Tequesta Fund 101 BUILDING FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 970F626.71 Investments 0.00 Accounts Receivable 17.07 Inventories 190.75 Prepaids 2,830.58 Total Assets 973,665.11 *** Liabilities *** Accounts Payable 887.57 Accrued liabilities (18,386.24) Due to Other Governments 3,298.07 Total Liabilities (14,200.60) *** Fund Balance *** F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 11,454.70 Fund Balance - Restricted 864,932.12 Fund Balance - Unassigned (220F453.65) Total Fund Balance 655,933.17 Beginning Fund Balance - 20-21 655,933.17 Net of Revenues VS Expenditures - 20-21 220F453.65 *20-21 End FB/21-22 Beg FB 876,386.82 Net of Revenues VS Expenditures - Current Year 111,478.89 Ending Fund Balance 987,865.71 Total Liabilities And Fund Balance 973,665.11 * Year Not Closed Page 66 of 243 G'� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/8 ?�Sooraicaftnot�i Period Ending 01/31/2022 DB: Tequesta Fund 301 CAPITAL IMPROVEMENT FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 353,324.98 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 353,324.98 *** 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 59,172.00 Fund Balance - Committed 262,429.00 Fund Balance - Assigned 31,690.26 Fund Balance - Unassigned (34,635.73) Total Fund Balance 318,655.53 Beginning Fund Balance - 20-21 318,655.53 Net of Revenues VS Expenditures - 20-21 34,635.73 *20-21 End FB/21-22 Beg FB 353,291.26 Net of Revenues VS Expenditures - Current Year 33.72 Ending Fund Balance 353,324.98 Total Liabilities And Fund Balance 353,324.98 * Year Not Closed Page 67 of 243 G'� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/8 ?�Sooraicaftnot�i Period Ending 01/31/2022 DB: Tequesta Fund 303 CAPITAL PROJECTS FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 1,496,648.41 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 1,496,648.41 *** Liabilities *** Accounts Payable 954.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 954.00 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 2,550,094.11 Fund Balance - Unassigned (2,493,828.32) Total Fund Balance 56,265.79 Beginning Fund Balance - 20-21 56,265.79 Net of Revenues VS Expenditures - 20-21 21,493,828.32 *20-21 End FB/21-22 Beg FB 2,550,094.11 Net of Revenues VS Expenditures - Current Year (1,054,399.70) Ending Fund Balance 1,495,694.41 Total Liabilities And Fund Balance 1,496,648.41 * Year Not Closed Page 68 of 243 G'� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/8 ?�Sooraicaftnot�i Period Ending 01/31/2022 DB: Tequesta Fund 401 WATER FUND GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 2,393,166.98 Investments 4,040,998.33 Accounts Receivable 661,082.99 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Inventories 225,698.20 Prepaids 22,647.97 Other Assets - Current 0.00 Land 83,335.00 Other Assets - Non Current 83,335.00 INFRASTRUCTURE 15,249,991.62 Buildings 224,255.54 Improvements Other Than Bldgs. 24,662.40 Machinery & Equipment 306,345.95 Construction in Progress 216,729.93 Intangible Assets 8r038.08 Other Fixed Assets 0.00 Deferred Outflows 548,103.80 FIXED ASSETS 0.00 Total Assets 24,005,056.79 *** Liabilities *** Accounts Payable 26,400.49 Accrued liabilities (117,066.33) Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 251.53 Deferred Revenue 0.00 Current Portion of Debt 391,728.09 Other Current Liabilities 0.00 Customer Deposits 47,031.74 Noncurrent liabilities 2,344,386.67 Other Long Term Liabilities 415,756.86 Def Inflows of Resources 478,636.00 Total Liabilities 3,587,125.05 *** 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 11,584,763.87 Net Assets, Restricted 0.00 Fund Balance - Restricted 376,728.00 Fund Balance - Committed 500,000.00 Fund Balance - Unassigned 6,846,735.86 Total Fund Balance 19,308,227.73 Beginning Fund Balance - 20-21 19,308,227.73 Net of Revenues VS Expenditures - 20-21 913,413.04 *20-21 End FB/21-22 Beg FB 20,221,640.77 Net of Revenues VS Expenditures - Current Year 196,290.97 Ending Fund Balance 20,417,931.74 Total Liabilities And Fund Balance 24,005,056.79 * Year Not Closed Page 69 of 243 G'� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/8 ?�Sooraicaftnot�i Period Ending 01/31/2022 DB: Tequesta Fund 402 REFUSE & RECYCLING GL Number Description Balance *** Assets *** Cash and Cash Equivalents 440F751.35 Investments 0.00 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 440F751.35 *** 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 118,576.84 Total Fund Balance 118,576.84 Beginning Fund Balance - 20-21 118,576.84 Net of Revenues VS Expenditures - 20-21 (24,293.08) *20-21 End FB/21-22 Beg FB 94,283.76 Net of Revenues VS Expenditures - Current Year 346,467.59 Ending Fund Balance 440F751.35 Total Liabilities And Fund Balance 440F751.35 * Year Not Closed Page 70 of 243 G'� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/8 ?�Sooraicaftnot�i Period Ending 01/31/2022 DB: Tequesta Fund 403 STORMWATER UTILITY GL Number Description Balance *** Assets *** Cash and Cash Equivalents 115,668.62 Investments 0.00 Accounts Receivable 716.43 Due from Other Funds 0.00 Inventories 686.69 Prepaids 517.71 Other Assets - Current 0.00 Other Assets - Non Current 0.00 INFRASTRUCTURE 2,003,395.44 Buildings 0.00 Improvements Other Than Bldgs. 0.00 Machinery & Equipment 17,118.63 Construction in Progress 0.00 Deferred Outflows 25,859.00 Total Assets 2,163,962.52 *** Liabilities *** Accounts Payable 6,096.73 Accrued liabilities (8,490.04) 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 14,769.37 Def Inflows of Resources 10,773.00 Total Liabilities 23,149.06 *** 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 1,236,387.06 Fund Balance - Unassigned 797,975.14 Total Fund Balance 2,034,362.20 Beginning Fund Balance - 20-21 2,034,362.20 Net of Revenues VS Expenditures - 20-21 (57,963.36) *20-21 End FB/21-22 Beg FB 1,976,398.84 Net of Revenues VS Expenditures - Current Year 164,414.62 Ending Fund Balance 2,140,813.46 Total Liabilities And Fund Balance 2,163,962.52 * Year Not Closed Page 71 of 243 G'� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 8/8 ?�Sooraicaftnot�i Period Ending 01/31/2022 DB: Tequesta Fund 605 SPECIAL LAW ENFORCEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 121,886.38 Investments 0.00 Accounts Receivable 0.00 Inventories 0.00 Prepaids 8,540.61 Total Assets 130F426.99 *** Liabilities *** Accounts Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** Fund Balance - Nonspendable 13,352.35 Fund Balance - Restricted 143,688.75 Fund Balance - Assigned 0.00 Fund Balance - Unassigned (72,064.76) Total Fund Balance 84,976.34 Beginning Fund Balance - 20-21 84,976.34 Net of Revenues VS Expenditures - 20-21 72,064.76 *20-21 End FB/21-22 Beg FB 157,041.10 Net of Revenues VS Expenditures - Current Year (26,614.11) Ending Fund Balance 130F426.99 Total Liabilities And Fund Balance 130F426.99 * Year Not Closed Page 72 of 243 Agenda Item #6. VILLAGE OF TEQUESTA Cash &Investments Unadjusted Unaudited 1/31/2022 General Fund #001 Building Fund # 101 Capital Improvement Fund #301 Capital Projects Fund #3 03 Water Utility #401 Refuse & Recycling #402 Stormwater #403 Special Law Enforcement #605 Total Cash and Investments SBA Prime Cash Investments Total $ 412641524 $ 610259072 $ 1012891596 9703627 0 9701627 3531325 0 3531325 1,496,648 0 1,496,648 213931167 410401998 614341165 4405751 0 4409751 1151669 0 1151669 1211886 0 12106 $ 1091569598 $ 10,0669070.29 $ 20,2229668.01 Page 73 of 243 Agenda Item #6. VILLAGE OF TEQUESTA REVENUE AND EXPENDITURE REPORT - UNADJUSTED, UNAUDITED 1/31/2022 YTD BALANCE YTD BALANCE DESCRIPTION 1/31/2021 1/31/2022 VARIANCE % VARIANCE NOTES REVENUES Fund 001 - GENERAL FUND General Property Taxes 6,661,042 71176,021 514,978 7.73% Historically, 91% receipted by the end of Feb Sales & Use Taxes 403,208 440,041 36,833 9.13% State revenues distributions increase Franchise fees - gross receipt 168,635 171,911 3,276 1.94% Licenses & Permits 340 510 170 50.00% Intergovernmental Revenue 214,932 250,318 35,386 16.46% State revenues distributions increase Chgs for Services - Gen Gov 289,645 138,459 (151,185) -52.20% Decrease in large projects - land development fees Intragovernmental Revenue 343,766 285,447 (58,318) -16.96% Decrease in admin fees from Water fund Rents & Royalties 78,426 80,719 21293 2.92% Contributions & Donations 0 3,350 3,350 100.00% Differs from year to year Miscellaneous Revenues 701 552 (149) -21.26% Chgs for Services - Public Safety 449,520 3241285 (125,234) -27.86% Timing in EMS fees recording Fines & Forfeitures 4,393 41708 315 7.17% Impact Fees 7,684 2,127 (5,558) -72.33% Differs from year to year, decrease in new projects Grants - State 13,605 0 (13,605) -100.00% Differs from year to year Charges for Services - Recr. 30 699 669 2230.67% Unrestricted Investment Earning 1,647 882 (765) -46.45% Other Financing Sources 5,830 965 (4,865) -83.45% Sale of assets differ from year to year Total General Fund 8,643,404 8,880,995 237,590 2.75% Fund 101 - BUILDING FUND Licenses & Permits 360,175 321,512 (38,662) -10.73% Decrease in large projects Charges for Services 834 450 (383) -45.99% Unrestricted Investment Earning 338 110 (228) -67.48% Total Building Fund 361,346 322,073 (39,274) -10.87% Fund 301 - Capital Improvement Fund Unrestricted Investment Earning 134 34 (101) -74.91% Total Capital Improvement Fund 134 34 (101) -74.91% Fund 303 - Capital Projects Fund Unrestricted Investment Earning 27 308 280 1022.35% Other Financing Sources 6,890,000 0 (6,890,000) -100.00% Loan proceeds for capital projects recv'd in previous yr Total Capital Projects Fund: 6,890,027 308 (6,889,720) -100.00% Fund 401 - Water Fund Miscellaneous Revenues 471169 25,123 (22,046) -46.74% Differs from year to year (credit recorded in FY 2021) Other Financing Sources 671145 13,745 (53,400) -79.53% Sale of assets differ from year to year Unrestricted Investment Earning 2,305 782 (1,522) -66.06% Interest rate decrease Charges for Services 1,535,651 1,812,759 277,107 18.04% Timing in Water revenues billing/recording Total Water Fund: 1,652,270 1,852,409 200,139 12.11% Fund 402 - Refuse & Recycling Unrestricted Investment Earning 79 25 (53) -67.72% Charges for Services 4211253 436,047 141794 3.51% Total Refuse & Recycling: 421,331 436,073 141741 3.50% Fund 403 - Stormwater Utility Unrestricted Investment Earning 364 9 (355) -97.53% Charges for Services 383,546 417,501 33,955 8.85% Total Stormwater Utility: 383,909 417,510 33,600 8.75% Fund 605 - Special Law Enforcement Unrestricted Investment Earning 36 18 (18) -51.05% Total Special Law Enforcement 36 18 (18) -51.05% TOTAL REVENUES - ALL FUNDS 18,352,459 11,909,417 (6,443,042) -35.11% TOTAL REVENUE LESS TRANSFERS 18,352,459 11,909,417 (6,443,042) -35.11% NOTES are for differences grater then 10% and amounts over $1,000. Page 74 of 243 genda Item #6. VILLAGE OF TEQUESTA EXPENDITURE REPORT - UNADJUSTED, UNAUDITED 1/31/2022 YTD BALANCE YTD BALANCE DESCRIPTION 1/31/2021 1/31/2022 VARIANCE VARIANCE NOTES EXPENDITURES Fund 001 - GENERAL FUND Council 16,518 22,692 6,174 37.38% Computer system maintenance, council exp. Manager 88,046 89,379 1,333 1.51% Human Resources 118,899 1211725 2,827 2.38% Village Clerk 97,279 102,529 5,250 5.40% Finance 2041498 1981627 (5,871) -2.87% Legal 53,279 43,927 (9,352) -17.55% Differs from year to year Comprehensive Planning 38,666 37,843 (823) -2.13% General Government 103,575 93,545 (10,029) -9.68% IT 266,280 203,899 (62,381) -23.43% Decrease in equipment purchases/IT projects Police Department 1,064,243 1,037,238 (27,005) -2.54% Code Compliance 25,722 29,985 41263 16.57% Additional Part time salaries Fire Control 1,566,978 1,350,184 (216,793) -13.84% Vehicle purchase in 2021 ($299K) Public Works 378,801 430,315 51,514 13.60% Misc. projects, path way maint. increase Leisure Services 248,084 313,017 64,934 26.17% Salaries, builders risk ins, special events exp increase Debt Service 182,779 462,972 280,193 153.30% New debt service (rec.center, vehicles & SAN project ) Total General Fund 41453,645 4/537/878 841232 1.89% Fund 101 - BUILDING FUND Building Department 2011227 210,594 9,367 4.65% Total Building Fund 2011227 210,594 9,367 4.65% Fund 301 - Capital Improvement Fund Public Works 1,080 0 (1,080) -100.00% Projects differ from year to year Parks 3,600 0 (3,600) -100.00% Projects differ from year to year Total Capital Improvement Fund: 4,680 0 (4,680) -100.00% Fund 303 - Capital Projects Fund Recreation Center 185,208 1,054,708 869,500 469.47% Recreation Center project Total Capital Projects Fund: 185,208 1,054,708 869,500 100.00% Fund 401 - Water Fund Water -Administration 497,546 519,797 221251 4.47% Water - Production 581,864 523,433 (58,431) -10.04% Timing in expense recording (pension expense FY) Water -Distribution 321,362 201,023 (120,339) -37.45% Vacant position, water system maint, pension exp timing Water -Customer Service 71,917 78,390 6,473 9.00% Renewal & Replacement 213,687 193,915 (19,773) -9.25% Debt Service 146,352 139,887 (6,464) -4.42% Other Nonoperating 3,045 0 (3,045) -100.00% Differs from year to year - loss on disposal of CA Total Water Fund: 1,835,772 1,656,445 (179,327) -9.77% Fund 402 - Refuse & Recycling Refuse and Recycling 128,492 89,605 (38,887) -30.26% Timing in expense recording Total Refuse & Recycling: 128,492 89,605 (38,887) -30.26% Fund 403 - Stormwater Utility Storm Water Utilities 105,053 106,889 1,836 1.75% Renewal & Replacement 87,612 146,205 58,593 66.88% Drainage improvements Other Nonoperating 8,820 0 (8,820) -100.00% Differs from year to year - loss on disposal of CA Total Stormwater Utility: 201,485 253,095 51,610 25.61% Fund 605 - Special Law Enforcement Police 0 26,632 26,632 100.00% Exp. vary from yr to yr, not spent evenly throughout the yr Total Special Law Enforcement: 0 26,632 26,632 100.00% TOTAL EXPENDITURES - ALL FUNDS 7,010,509 7,828,956 818,446 11.67% TOTAL EXP LESS TRANSFERS 7,010,509 7,828,956 818,446 11.67% * Varies by department, different expenditures have not been recorded in FY 2022 vs FY 2021. NOTES are for differences grater then 10% and amounts over $1,000. Page 75 of 243 Benda Item #6. THE VILLAGE OF TEQUESTA REVENUE REPORT - UNADJUSTED, UNAUDITED 1/31/2022 FY 2022 FY 2022 33.33 % ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT % BDGT DESCRIPTION BUDGET BUDGET BUDGET 1/31/2022 VARIANCE VARIANCE USED NOTES Fund 001- GENERAL FUND General Property Taxes 8,158,070 8,158,070 2,719,357 7,176,021 4,456,664 163.89% 87.96 Historically, 91% receipted by the end of Feb Sales & Use Taxes 1,910,660 1,910,660 636,887 440,041 (196,845) -30.91% 23.03 State revenues one/two month behind Franchise fees - gross receipt 462,000 462,000 154,000 171,911 17,911 11.63% 37.21 Franchise receipts one month behind Licenses & Permits 1,000 1,000 333 510 177 53.00% 51.00 Intragovernmental Revenue 856,310 856,310 285,437 285,447 11 0.00% 33.33 Grants Federal 20,400 1,165,630 388,543 0 (388,543) -100.00% 0.00 ARPA funds are not yet received Grants - State 12,000 12,000 4,000 0 (4,000) -100.00% 0.00 Differ from year to year Intergovernmental Revenue 907,320 907,320 302,440 250,318 (52,122) -17.23% 27.59 State rev is one/two month behind Chgs for Services - Gen Gov 195,500 195,500 65,167 138,459 73,293 112.47% 70.82 Land development fees Chgs for Services - Public Safety 1,265,570 1,267,660 422,553 324,285 (98,268) -23.26% 25.58 Timing in revenue recording - EMS svcs Charges for Services - Recr. 46,190 46,190 15,397 699 (14,697) -95.46% 1.51 No programs due to construction Fines & Forfeitures 18,500 18,500 6,167 4,708 (1,459) -23.66% 25.45 Code enforcement fees differs Unrestricted Investment Earning 8,300 8,300 2,767 882 (1,885) -68.13% 10.62 Receipts are one month behind in recording Rents & Royalties 255,190 255,190 85,063 80,719 (4,344) -5.11% 31.63 Impact Fees 1,500 1,500 500 2,127 1,627 325.32% 141.77 Differ from year to year Contributions & Donations 2,000 2,000 667 3,350 2,683 402.50% 167.50 Tequesta fest contributions received Miscellaneous Revenues 12,230 12,230 4,077 552 (3,524) -86.45% 4.52 Differ from year to year Other Financing Sources (lease) 0 1,865,588 621,863 965 (620,898) -99.84% 0.05 Lease has not been received/recorded Appropriate Fund Balance 1,145,230 55,710 0 0 Total General Fund 151277,970 17/201/358 5,733,786 8/880/995 31147,209 54.89% 51.63 Fund 101- BUILDING FUND Licenses & Permits 503,000 503,000 167,667 321,512 153,846 91.76% 63.92 Fees collected for projects Chgs for Sery - Gen Gov 1,400 1,400 0 450 450 100.00% 0.00 Unrestricted Investment Earning 0 0 0 110 110 100.00% 0.00 Appropriate Fund Balance 171,860 171,860 0 0 Total Building Fund 676,260 676,260 225,420 322,073 96,653 42.88% 47.63 Fund 301- Capital Improvement Fund Unrestricted Investment Earn 1,000 1,000 333 34 (300) -89.88% 3.37 Receipts are one month behind in recording Transfers In 677,260 677,260 225,753 0 (225,753) -100.00% 0.00 Timing in revenue recording Appropriate Fund Balance 87,000 87,000 0 0 Total Capital Improvement Fund: 765,260 765,260 255,087 34 (255,053) -99.99% 0.00 Fund 303 - Capital Projects Fund Unrestricted Investment Earning 500 500 167 308 141 84.72% 100.00 Transfers In 87,000 87,000 29,000 0 (29,000) -100.00% 0.00 Timing in revenue recording Appropriate Fund Balance 254,500 2,613,138 0 0 Total Capital Projects Fund: 342,000 2,700,638 900,213 308 (899,905) -99.97% 0.00 Fund 401- Water Fund Charges for Services 6,346,500 6,346,500 2,115,500 1,812,759 (302,741) -14.31% 28.56 Timing in Water revenues billing/recording Unrestricted Investment Earn 8,400 8,400 2,800 782 (2,018) -72.06% 9.31 Receipts are one month behind in recording Miscellaneous Revenues 48,500 48,500 16,167 25,123 8,956 55.40% 51.80 Revenue receipted as a one time deposit Other Financing Sources (loan) 4,457,000 4,457,000 1,485,667 13,745 (1,471,922) -99.07% 0.31 Loan proceeds recorded when received Appropriate Fund Balance 2,076,950 2,643,746 0 0 Total Capital Projects Fund: 12,937,350 13,504,146 4,501,382 1,852,409 (2,648,973) -58.85% 13.72 Fund 402 - Refuse & Recycling Charges for Services 500,940 500,940 166,980 436,047 269,067 161.14% 87.05 Historically, 91% receipted by the end of Feb Unrestricted Investment Earn 500 500 167 25 (141) -84.76% 5.08 Appropriate Fund Balance 28,570 28,570 0 0 Total Refuse & Recycling: 530,010 530,010 176,670 436,073 259,403 146.83% 82.28 Fund 403 - Stormwater Utility Grants & Contributions 30,000 30,000 10,000 0 (10,000) -100.00% 0.00 Differ from year to year Charges for Services 497,810 497,810 165,937 417,501 251,564 151.60% 83.87 Historically, 91% receipted by the end of Feb Unrestricted Investment Earn 1,400 1,400 467 9 (458) -98.08% 0.64 Transfers In 150,000 150,000 0 Appropriate Fund Balance 0 47,352 0 0 Total Stormwater Utility: 679,210 726,562 242,187 417,510 175,322 72.39% 57.46 Fund 605 - Special Law Enforcement Unrestricted Investment Earn 0 0 0 18 18 100.00% 0.00 Appropriate Fund Balance 74,920 87,170 0 0 0.00 Total Special Law Enforcement 74,920 87,170 29,057 18 (29,039) 0.00 TOTAL REVENUES - ALL FUNDS 31,282,980 36,191,404 12,063,801 11,909,417 (154,384) -1.28% 32.91 TOTAL REV - LESS TFRS AND APPR 26,529,690 29,542,598 9,847,533 11,909,417 2,061,885 20.94% 40.31 NOTES are for differences grater then 10% and amounts over $1,000. Page 76 of 243 1 4- o% wft 4IM Age THE VILLAGE OF TEQUESTA EXPENDITURE REPORT - UNADJUSTED, UNAUDITED 1/31/2022 FY 2022 FY 2022 33.33 % ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT % BDGT DESCRIPTION BUDGET BUDGET BUDGET 1/31/2022 VARIANCE VARIANCE USED Fund 001- General Fund Council 77,350 77,350 25,783 22,692 (3,092) -11.99% 29.34 (1), (2) Manager 306,720 306,720 102,240 89,379 (12,861) -12.58% 29.14 (1), (2) Human Resources 385,040 385,040 128,347 121,725 (6,621) -5.16% 31.61 (1), (2) Village Clerk 373,940 373,940 124,647 102,529 (22,118) -17.74% 27.42 (1), (2) Finance 715,220 715,220 238,407 198,627 (39,780) -16.69% 27.77 (1), (2) Legal 190,000 190,000 63,333 43,927 (19,406) -30.64% 23.12 (1), (2) Comprehensive Planning 281,540 281,540 93,847 37,843 (56,004) -59.68% 13.44 (1), (2) General Government 314,310 314,310 104,770 93,545 (11,225) -10.71% 29.76 (1), (2) IT 476,650 476,650 158,883 203,899 45,016 28.33% 42.78 (3) Police Department 3,558,370 3,603,969 1,201,323 1,037,238 (164,085) -13.66% 28.78 (1), (2) Code Compliance 124,480 124,480 41,493 29,985 (11,508) -27.74% 24.09 (1), (2) Fire Control 4,172,295 6,050,084 2,016,695 1,350,184 (666,510) -33.05% 22.32 (1), (2) Public Works 1,546,915 1,546,915 515,638 430,315 (85,323) -16.55% 27.82 (1), (2) Leisure Services 942,080 942,080 314,027 313,017 (1,009) -0.32% 33.23 (3) Debt Service 886,280 8861280 295,427 462,972 167,545 56.71% 52.24 New debt service Interfund Transfers 827,260 827,260 275,753 0 (275,753) -100.00% 0.00 (3) Other Nonoperating 99,520 99,520 33,173 0 (33,173) -100.00% 0.00 Total General Fund 15,277,970 17,201,358 5,733,786 4,537,878 (1,195,908) -20.86% 26.38 Fund 101- BUILDING FUND Building & Zoning 676,260 676,260 225,420 210,594 (14,826) -6.58% 31.14 (1), (2) Total Building Fund 676,260 676,260 225,420 210,594 (14,826) -6.58% Fund 301- Capital Improvement Fund Public Works 419,590 419,590 139,863 0 (139,863) -100.00% 0.00 (2) Interfund Transfers 87,000 87,000 29,000 0 (29,000) -100.00% 0.00 (3) Other Nonoperating 258,670 258,670 86,223 0 (86,223) -100.00% 0.00 (3) Total Capital Improvement Fund: 765,260 765,260 255,087 0 (255,087) -100.00% 0.00 Fund 303 - Capital Projects Fund Public Works 255,000 255,000 85,000 0 (85,000) -100.00% 0.00 Recreation Center 87,000 2,445,638 815,213 1,054,708 239,495 29.38% 43.13 Total Capital Projects Fund: 342,000 2,700,638 900,213 1,054,708 154,495 17.16% 39.05 Fund 401- Water Fund Water -Administration 1,377,790 1,483,036 494,345 519,797 25,451 5.15% 35.05 Water - Production 1,945,290 1,945,290 648,430 523,433 (124,997) -19.28% 26.91 (1), (2) Water -Distribution 742,350 742,350 247,450 201,023 (46,427) -18.76% 27.08 (1), (2) Water -Customer Service 279,450 279,450 93,150 78,390 (14,760) -15.85% 28.05 (1), (2) Renewal & Replacement 3,657,000 4,118,550 1,372,850 193,915 (1,178,935) -85.88% 4.71 (2) Capital Improvement 4,442,000 4,442,000 1,480,667 0 (1,480,667) -100.00% 0.00 (2) Debt Service 493,470 4931470 164,490 139,887 (24,603) -14.96% 28.35 Other Nonoperating 0 0 0 0 0.00% 0.00 Total Capital Projects Fund: 12,937,350 13,504,146 4,501,382 1,656,445 (2,844,937) -63.20% 12.27 Fund 402 - Refuse & Recycling Refuse and Recycling 530,010 530,010 176,670 89,605 (87,065) -49.28% 16.91 (1), (2) Other Nonoperating 0 0 0 0 0 0.00% 0.00 Total Refuse & Recycling: 530,010 530,010 176,670 89,605 (87,065) -49.28% 16.91 Fund 403 - Stormwater Utility Storm Water Utilities 351,690 376,615 125,538 106,889 (18,649) -14.86% 28.38 (1), (2) Renewal & Replacement 282,000 304,427 101,476 146,205 44,730 44.08% 48.03 (2), (3) Other Nonoperating 45,520 45,520 15,173 0 (15,173) -100.00% 0.00 (3) Total Stormwater Utility: 679,210 726,562 242,187 253,095 10,908 4.50% 34.83 Fund 605 - Special Law Enforcement Police 74,920 87,170 29,057 26,632 (2,425) -8.35% 100.00 (2) Total Special Law Enforcement 74,920 87,170 29,057 26,632 (2,425) -8.35% 100.00 TOTAL EXPENDITURES - ALL FUNDS 31,282,980 36,191,404 12,063,801 7,828,956 (4,234,845) -35.10% 21.63 Notes: (1) Personal expenditures/expenses recorded as when paid not when accrued. Personnel paid 1/20/22 for the period ended 1/15/22. 16 days of personnel expenditures not reflected in December 2021. (2) Not all operating expenditures/expenses recorded for the services of January 2022. Expenditures recorded on a cash basis and adjusted at year end. (3) Timing in expenditures/expenses recording or/and recorded as one time entry. Page 77 of 243 Agenda m cr d �N If I V ■ fn (n Cn ca cn cn cn cn cn En cn cn co to to cn Q Q Q V a) > a) Z Z Z O � � i rY+ O U `�_ U C C -0 -a C m (A i 0•� E U) N a) O 0 O 0 c c U) a) ( a) O L O L O L O U U LL LL 0 0 2 2 2 N LO N 1:31 � O LO O O O LO O O O O O O M co 00 't O O O O 0= CO In N LO O O O O O O w ,:1- M ti r CO M 00 O � O O O O O O O M O M M O) O O Lll W W J L N r r M LO LO LO O f� Q > V r J J J X W > R R LO LO p p p p p l` 0o 0o p N m O O O O O CO lq4- 00 O > 00 f-- ti f-- LO w In w O O O O O O 4 LO 00 N r O O O L11 O r N O) O M O O O O M r O_ � cM CO � O O O O � N It w W W Q > LO LO LO r M r r O O O oo ti N LO O C) 00 r L- LO rn rn C) m 3 O O O N Q O ~ C C)N CO CD C:)00 CDT a) O N r O 4 LO LO O ciN co 00 C C).. W N CO 00 .. N O O LO CO � H} Ef} ff} U) Id4 � i i i i i 6 r c" M O O O O O CO O) ~ (D Zt N O O ti LO Zt Ef} O O N M LO M N O O N 69- � E!} CO � � b4 6�} �} t O O m O O O O O %+ CD CD CD CDCDO O O N O O O O to O O CD 6q K} N C � O O CD O O O co 4 LO � o0 N 00 r O 6 N E Q LO C)C) O . C) CD C)O CD a) O 0") M ti r N O 00 r m N N O O O ti� f- CM 613- O 6 O O O O r r (•7 r r O O f� ~ i r CO O LO 00 r O r LO r O LO O LO y} ea E03- LO K-} K} K} U} Ei} ffl ffl E{} r O m W N N r co O O N r •r m O O O N N O CNCN N N C7 E D N N CD N N O N p p N p O N M r r N O N N r M N N ~ N M M N M M \ r M CD (D LL LL LL j LL LL d� O O N r r m Cu ; O N N N O O Np O Np N N r p N Np N N p N O O N LO r O N N r N N O N O NOj N N C) N � N N r W N cM N I- r CO LO O LL LL M M LL LL LL LL CO }, U) a) � V`/J ca U) OL yW+ OL C C C fn 0 a)a0 0E a) OL O E Q) U L) Q N 2 U 0 L W O L O L + L A C }, C O C O E C w C C w w c c m E cn i 0 — w O O w Opp CN (� V O a) 4-ca 0 > W > WZ3� C 4O Z3CL — CL _ O (u C 'C U -t� O O U U O-1� O (� J (� N +� +� a) U U _0 Q O w 0 0 (a (j m om += N E m 4) 70 "O " 4) m E m E Q Q Q U (n O O O O O m C E) U- d m LL LL LL LL OL L d LL LL LL U a) � 07 v7 (n C a) 70 iO m _ O _ O > > O > > O > > a) > 4) L -0 CL in O N a) m m0 V V VC'J m O O Q) 0 1-1 U a a>> + a) a) a> `~ n a L OL a LL E E O U O U E 06 06 (n �. O p M C w E r M O L U U � U +_ 40 ... � �--, +r a) cn cn co C cz O iLQ E ca m "' a) C� cv L U > O _ C a) +� +: c E O O � � � p_ U LL o a) ffcna V > //fin� V a--• � Q O U � � J m o E 4-1 U ui caLi Cl) � � � � < 0 m 000 d d d 0 Zll� a) a) ll� 0 U I LL I U 1 0- En Q CO CO o U LIM Page 78 of 243