Loading...
HomeMy WebLinkAboutDocumentation_Regular_Tab 13_2/8/2024 Agenda Item #13. Regular Council STAFF MEMO Meeting: Regular Council - Feb 08 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 $9 million, which represents 78% of the budgeted amount. Historically, 91% of ad valorem tax distribution receipted by the end of February. 3. Sales/use taxes (27%), 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 95%. Insurance premium tax ($307 thousand) to be collected at the year-end as one distribution. Sales/use taxes are on target for three months collections. 4. Intergovernmental revenues (29%) 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 three months collections due to the half-cent sales tax revenue increase collection/distribution. 5. Revenues (Budgetary comparison) recorded in the General fund represents 62% of budgeted due to the distribution nature of Ad valorem taxes collected at 78%, representing 83% of overall General fund revenues at 1/31/2024. 6. Overall Expenditures (Budgetary comparison) in the General Fund represents 27% of budgeted. Not all the expenditures recorded for the services provided for the month of January 2024 and personnel expenditures recorded as paid not when accrued. 7. Revenues (Prior year comparison) all funds increased mainly due to Ad valorem taxes collected $913 thousand (11%) higher than same period of prior year, increased investment earnings and offset by change in leases revenue recording. 8. Expenditures (Prior year comparison) all funds slightly increased due to roads and storm water projects started earlier in FY 2024. Page 222 of 590 Agenda Item #13. 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 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 Jan 2024 January 2024 Managers Report.ADA (1) January 2024 Grant Budget Worksheet 2 Page 223 of 590 / I �t 3� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/8 Period Ending 01/31/2024 DB: Teauesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 2,137,071.93 Investments 11,450, 988.87 Accounts Receivable 1,119, 625.98 Due from Other Funds 0.00 Accrued Income Receivable 20,458.14 Inventories 43,365.01 Prepaids 67,169.11 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 14,838,679.04 *** Liabilities *** Accounts Payable (472.95) Accrued liabilities 10,441.81 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 1,461.67 Deferred Revenue 956, 607.32 Other Current Liabilities 413.55 Customer Deposits 0.00 Noncurrent liabilities 0.00 Total Liabilities 968,451.40 *** 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 812,308.18 Fund Balance - Restricted 288,000.00 Fund Balance - Committed 500,000.00 Fund Balance - Assigned 2,036,098.00 Fund Balance - Unassigned 4,375,472.92 Total Fund Balance 8,011,879.10 Beginning Fund Balance - 22-23 8,011,879.10 Net of Revenues VS Expenditures - 22-23 16,856.48 *22-23 End FB/23-24 Beg FB 8,028,735.58 Net of Revenues VS Expenditures - Current Year 5,841,492.06 Ending Fund Balance 13,870,227.64 Total Liabilities And Fund Balance 14,838,679.04 * Year Not Closed Page 224 of 590 / �t 3� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/8 I Period Ending 01/31/2024 DB: Teauesta Fund 101 BUILDING FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 193,791.95 Investments 700, 904.65 Accounts Receivable 36.37 Inventories 86.95 Prepaids 2, 912.19 Total Assets 897,732.11 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Due to Other Governments 5,776.13 Total Liabilities 5,776.13 *** Fund Balance *** F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 10,303.06 Fund Balance - Restricted 832,828.08 Fund Balance - Assigned 29,399.00 Fund Balance - Unassigned 0.00 Total Fund Balance 872,530.14 Beginning Fund Balance - 22-23 872,530.14 Net of Revenues VS Expenditures - 22-23 191,113.79 *22-23 End FB/23-24 Beg FB 1,063,643.93 Net of Revenues VS Expenditures - Current Year (171,687.95) Ending Fund Balance 891,955.98 Total Liabilities And Fund Balance 897,732.11 * Year Not Closed Page 225 of 590 / �t 3� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/8 I Period Ending 01/31/2024 DB: Teauesta Fund 301 CAPITAL IMPROVEMENT FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 39,045.93 Investments 899, 910.74 Accounts Receivable (3,885.91) Due from Other Funds 0.00 Prepaids 0.00 Total Assets 935,070.76 *** 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 568,199.33 Fund Balance - Committed 312,722.00 Fund Balance - Assigned 31, 690.26 Fund Balance - Unassigned 0.00 Total Fund Balance 912,611.59 Beginning Fund Balance - 22-23 912,611.59 Net of Revenues VS Expenditures - 22-23 384,061.17 *22-23 End FB/23-24 Beg FB 1,296,672.76 Net of Revenues VS Expenditures - Current Year (361,602.00) Ending Fund Balance 935,070.76 Total Liabilities And Fund Balance 935,070.76 * Year Not Closed Page 226 of 590 / �t 3� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/8 I Period Ending 01/31/2024 DB: Teauesta Fund 303 CAPITAL PROJECTS FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 3,124.29 Investments 262,845.03 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 265,969.32 *** 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 136,378.12 Fund Balance - Unassigned 0.00 Total Fund Balance 136,378.12 Beginning Fund Balance - 22-23 136,378.12 Net of Revenues VS Expenditures - 22-23 125,976.93 *22-23 End FB/23-24 Beg FB 262,355.05 Net of Revenues VS Expenditures - Current Year 3,614.27 Ending Fund Balance 265,969.32 Total Liabilities And Fund Balance 265,969.32 * Year Not Closed Page 227 of 590 / I �t 3� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/8 Period Ending 01/31/2024 DB: Teauesta Fund 401 WATER FUND GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 1,154, 906.67 Investments 8,853,073.81 Accounts Receivable 587, 634.10 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Accrued Income Receivable 18,480.00 Inventories 253,030.80 Prepaids 13,846.59 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,619,061.36 *** Liabilities *** Accounts Payable 2,479.99 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 277.32 Deferred Revenue 0.00 Current Portion of Debt 431,555.63 Other Current Liabilities 0.00 Customer Deposits 39,890.00 Noncurrent liabilities 1,546,007.99 Other Long Term Liabilities 614,526.23 Def Inflows of Resources 538,011.00 Total Liabilities 3,172,748.16 *** 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 391,822.25 Fund Balance - Committed 500,000.00 Fund Balance - Unassigned 8, 919,488.87 Total Fund Balance 21,396,074.99 Beginning Fund Balance - 22-23 21,396,074.99 Net of Revenues VS Expenditures - 22-23 2,155,894.26 *22-23 End FB/23-24 Beg FB 23,551,969.25 Net of Revenues VS Expenditures - Current Year 894,343.95 Ending Fund Balance 24,446,313.20 Total Liabilities And Fund Balance 27,619,061.36 * Year Not Closed Page 228 of 590 / �t 3� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/8 I Period Ending 01/31/2024 DB: Teauesta Fund 402 REFUSE & RECYCLING GL Number Description Balance *** Assets *** Cash and Cash Equivalents 331,741.66 Investments 58,859.56 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 390,601.22 *** 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 72,642.83 Total Fund Balance 72,642.83 Beginning Fund Balance - 22-23 72,642.83 Net of Revenues VS Expenditures - 22-23 (25,070.46) *22-23 End FB/23-24 Beg FB 47,572.37 Net of Revenues VS Expenditures - Current Year 343,028.85 Ending Fund Balance 390,601.22 Total Liabilities And Fund Balance 390,601.22 * Year Not Closed Page 229 of 590 / �t 3� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/8 I Period Ending 01/31/2024 DB: Teauesta Fund 403 STORMWATER UTILITY GL Number Description Balance *** Assets *** Cash and Cash Equivalents 357,754.38 Investments 47,403.10 Accounts Receivable 3,257.30 Due from Other Funds 0.00 Inventories 76.70 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,683,126.17 *** Liabilities *** Accounts Payable (550.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 55,824.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 1,236,387.06 Fund Balance - Unassigned 711, 661.18 Total Fund Balance 1,948,048.24 Beginning Fund Balance - 22-23 1,948,048.24 Net of Revenues VS Expenditures - 22-23 564,490.41 *22-23 End FB/23-24 Beg FB 2,512,538.65 Net of Revenues VS Expenditures - Current Year 114,762.82 Ending Fund Balance 2,627,301.47 Total Liabilities And Fund Balance 2,683,126.17 * Year Not Closed Page 230 of 590 / I �t 3� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 8/8 Period Ending 01/31/2024 DB: Teauesta Fund 605 SPECIAL LAW ENFORCEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 39, 993.77 Investments 264, 987.41 Accounts Receivable 217.65 Inventories 0.00 Prepaids 0.00 Total Assets 305,198.83 *** Liabilities *** Accounts Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** Fund Balance - Ncnspendable 8,540.61 Fund Balance - Restricted 80,795.97 Fund Balance - Assigned 44,186.00 Fund Balance - Unassigned 0.00 Total Fund Balance 133,522.58 Beginning Fund Balance - 22-23 133,522.58 Net of Revenues VS Expenditures - 22-23 181,875.00 *22-23 End FB/23-24 Beg FB 315,397.58 Net of Revenues VS Expenditures - Current Year (10,198.75) Ending Fund Balance 305,198.83 Total Liabilities And Fund Balance 305,198.83 * Year Not Closed Page 231 of 590 Agenda Item #13. VILLAGE OF TEQUESTA Cash&Investments Unadjusted Unaudited O1/31/2024 Cash and cash equivalents Investments Total General Fund#001 $ 2,137,072 $ 11,450,989 $ 13,588,061 Building Fund#101 193,792 700,905 894,697 Capital Improvement Fund#301 39,046 899,911 938,957 Capital Projects Fund#303 3,124 262,845 265,969 Water Utility#401 1,154,907 8,853,074 10,007,980 Refuse &Recycling#402 331,742 58,860 390,601 Stormwater#403 357,754 47,403 405,157 Special Law Enforcement#605 39,994 264,987 304,981 Total Cash and Investments $ 4,257,431 $ 22,538,973 $ 26,796,404 *Interfund transfer pending Page 232 of 590 VILLAGE OF TEQUESTA Agenda Item #13. REVENUE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 1/31/2023 01/31/2024 VARIANCE %VARIANCE NOTES REVENUES Fund 001-GENERAL FUND General Property Taxes 8,047,800 8,960,445 912,645 11.34% Advalorem taxes increase Sales&Use Taxes 470,426 360,207 (110,219) -23.43% Infrastructure&Utility tax recorded in fund#301 in FY24 Franchise fees-gross receipt 153,134 166,140 13,007 8.49% Licenses&Permits 2,680 1,520 (1,160) -43.28% Rental permits decrease Grants-Federal 3,645 0 (3,645) -100.00% Differs from year to year Grants-State 0 4,672 4,672 100.00% Differs from year to year Intergovernmental Revenue 268,167 282,116 13,948 5.20% Chgs for Services-Gen Gov 113,022 92,622 (20,400) -18.05% Land development fees based on the projects Indirect Costs 287,691 300,997 13,306 4.62% Rents&Royalties 176,649 3,740 (172,910) -97.88%Timing in leases revenue recording Contributions&Donations 12,673 1,450 (11,223) -88.56% Differs from year to year Miscellaneous Revenues 17,519 15,193 (2,326) -13.27% Differs from year to year Chgs for Services-Public Safety 343,504 401,802 58,297 16.97% EMS transport fees collection increase Fines&Forfeitures 3,756 1,582 (2,174) -57.88% Code enf fines revenue Impact Fees 1,701 3,828 2,127 125.00% Impact fees based on the projects Charges for Services-Recreation 31,885 65,058 33,173 104.04% Recreation programs fees increase Unrestricted Investment Earning 101,208 122,433 21,225 20.97% Active investing,balance and rate increases Other Financing Sources 10,000 11,668 1,668 100.00% Total General Fund 10,045,462 10,795,472 750,010 7.47% Fund 101-BUILDING FUND Licenses&Permits 203,119 154,767 (48,352) -23.80%Varies year to year based upon activity/projects Charges for Services 373 35 (338) -90.52% Miscellaneous Revenues 0 2 2 100.00% Unrestricted Investment Earning 7,317 12,634 5,316 72.66%Active investing,balance and rate increases Total Building Fund 210,809 167,437 (43,372) -20.57% Fund 301-Capital Improvement Fund Sales&Use Taxes 0 150,857 150,857 100.00% Infrastructure surtax and water utility tax Unrestricted Investment Earning 4,964 17,161 12,197 100.00% Active investing,balance and rate increases Total Capital Improvement Fund 4,964 168,018 163,054 100.00% Fund 303-Capital Projects Fund Unrestricted Investment Earning 0 3,614 3,614 100.00% Active investing,balance and rate increases Total Capital Projects Fund: 0 3,614 3,614 100.00% Fund 401-Water Fund Miscellaneous Revenues 25,710 24,698 (1,012) -3.94% Fines&Forfeitures 750 0 (750) -100.00% Unrestricted Investment Earning 60,585 127,945 67,359 111.18% Active investing,balance and rate increases Other Financing Sources 26,031 26,101 70 0.27% Sale of assets Charges for Services 1,973,690 2,429,786 456,095 23.11% New Capital Recovery charge implemented in FY 2024 Total Water Fund: 2,086,767 2,608,530 521,763 25.00% Fund 402-Refuse&Recycling Unrestricted Investment Earning 0 2,078 2,078 100.00%Active investing,balance and rate increases Charges for Services 494,125 494,311 186 0.04% Total Refuse&Recycling: 494,125 496,389 2,264 0.46% Fund 403-Stormwater Utility Miscellaneous Revenues 0 5,300 5,300 100.00% Unrestricted Investment Earning 0 3,158 3,158 100.00% Active investing,balance and rate increases Charges for Services 415,581 448,126 32,545 7.83% Total Stormwater Utility: 415,581 456,584 41,003 9.87% Fund 605-Special Law Enforcement Forfeitures 15,883 623 (15,260) -96.08% Differ from yeat to year Unrestricted Investment Earning 856 3,690 2,834 331.11% Active investing,balance and rate increases Total Special Law Enforcement 16,739 4,313 (12,426) -74.24% TOTAL REVENUES-ALL FUNDS 13,274,446 14,700,356 1,425,910 10.74% NOTES are for differences grater than 10%and amounts over$1,000. Page 233 of 590 Agenda Item #13. VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE % DESCRIPTION 1/31/2023 01/31/2024 VARIANCE VARIANCE NOTES EXPENDITURES Fund 001-GENERAL FUND Council 17,470 18,741 1,270 7.27% Manager 94,951 107,537 12,586 13.26% Sick leave buy back option Human Resources 134,357 149,910 15,553 11.58% Sick leave buy back option Village Clerk 114,946 142,299 27,353 23.80% Codification,other contr.svcs,legal adv.increase Finance 225,666 277,652 51,986 23.04% ClearGov software purchase$24K,timing in auditing svcs Legal 43,992 81,983 37,991 86.36% Differs from year to year based upon service needs Comprehensive Planning 56,583 89,095 32,512 57.46% Personnel full time salaries FY24 vs contracting FY23 General Government 79,343 103,745 24,402 30.76% Other contractual svcs and insurance increase IT 214,406 256,233 41,827 19.51% Computer system maint Police Department 1,206,341 1,117,336 (89,005) -7.38% Overtime&other contr.svcs. Code Compliance 30,760 5,123 (25,637) -83.35% Vacant position Fire Control 1,368,067 1,373,331 5,264 0.38% Public Works 484,110 445,328 (38,781) -8.01% Build repair/maint,landscape,other svcs Leisure Services 457,584 403,885 (53,699) -11.74% Timing in special event exp processing Debt Service 427,639 381,706 (45,933) -10.74% Pumper financed purchase paid in full Total General Fund 4,956,215 4,953,904 (2,311) -0.05% Fund 101-BUILDING FUND Building Department 305,779 339,125 33,346 10.91% Regular salaries,comp abs.,other contr svcs increase Total Building Fund 305,779 339,125 33,346 10.91% Fund 301-Capital Improvement Fund Miscellaneous projects,M&E 78,474 529,620 451,146 100.00% Projects varies year to year,roads projects Total Capital Improvement Fund: 78,474 529,620 451,146 100.00% Fund 303-Capital Projects Fund Total Capital Projects Fund: 0 0 0 #DIV/01 Fund 401-Water Fund Water-Administration 492,745 571,849 79,103 16.05% Insurance Water- Production 629,128 546,056 (83,072) -13.20% Pension exp-timing in recording,health ins.,chemicals Water-Distribution 290,513 223,814 (66,698) -22.96% Pension exp-timing in recording,water system maint Water-Customer Service 89,319 86,926 (2,393) -2.68% Renewal&Replacement 350,350 134,708 (215,642) -61.55% Differs from year to year based upon projects Debt Service 149,620 150,833 1,212 0.81% Total Water Fund: 2,001,675 1,714,186 (287,489) -14.36% Fund 402-Refuse&Recycling Refuse and Recycling 150,925 153,360 2,435 1.61% Total Refuse&Recycling: 150,925 153,360 2,435 1.61% Fund 403-Stormwater Utility Storm Water Utilities 121,829 99,921 (21,909) -17.98% Drainage maint projects Renewal&Replacement 14,485 241,901 227,416 1570.01% Differs from year to year based upon projects Total Stormwater Utility: 136,314 341,821 205,507 150.76% Fund 605-Special Law Enforcement Police 44,747 14,511 (30,235) -67.57% Differs from year to year based upon needs Total Special Law Enforcement: 44,747 14,511 (30,235) -67.57% TOTAL EXPENDITURES-ALL FUNDS 7,674,131 8,046,527 372,397 4.85% NOTES are for differences grater than 10%and amounts over$1,000. Page 234 of 590 Benda Item #13. THE VILLAGE OFTEQUESTA REVENUE REPORT-CASH BASIS,UNAUDITED FY 2024 FY 2024 33.33% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 01/31/2024 VARIANCE VARIANCE USED NOTES Fund 001-GENERAL FUND General Property Taxes 11,524,090 11,524,090 3,841,363 8,960,445 5,119,082 133.26% 77.75 Historically,91%receipted bythe end ofFeb State revs two month behind,record-cash basis,ins prem Sales&Use Taxes 1,350,252 1,350,252 450,084 360,207 (89,877) -19.97% 26.68 tax received as one distrib at FYF($3071) Franchise fees-gross receipt 530,938 530,938 176,979 166,140 (10,839) -6.12% 31.29 one month behind Licenses&Permits 9,000 9,000 3,000 1,520 (1,480) -49.33% 16.89 special events,vacational rental permits Indirect Costs 902,991 902,991 300,997 300,997 0 0.00% 33.33 Grants Federal 25,737 25,737 8,579 0 (8,579) -100.00% 0.00 Differ from year to year,timing of collection Grants-State 77,000 77,000 25,667 4,672 (20,994) -81.80% 6.07 Differ from year to year,timing of collection Intergovernmental Revenue 984,222 984,222 328,074 282,116 (45,958) -14.01% 28.66 State revs one/two more months to be recorded Grants and Contributions-Local 14,084 14,084 4,695 0 (4,695) -100.00% 0.00 Differ from year to year Chgs for Services-Gen Gov 208,645 208,645 69,548 92,622 23,074 33.18% 44.39 Land development fees based on projects Chgs for Services-Public Safety 1,227,355 1,227,355 409,118 401,953 (7,165) -1.75% 32.75 Charges for Services-Recr. 62,500 62,500 20,833 65,058 44,225 212.28% 104.09 Program fees increase Fines&Forfeitures 18,275 18,275 6,092 1,582 (4,510) -74.03% 8.66 Code enffees decreased Unrestricted Investment Earning 280,500 280,500 93,500 122,433 28,933 30.94% 43.65 Active investing,balance and rate increases Rents&Royalties 188,839 188,839 62,946 3,740 (59,207) -94.06% 1.98 Timing in revenue recording,cash basis Impact Fees 8,169 8,169 2,723 3,828 1,105 40.58% 46.86 Differ from year to year depending on projects/permits Contributions&Donations 10,000 10,000 3,333 1,450 (1,883) -56.50% 14.50 Differ from year to year events depending Miscellaneous Revenues 13,205 13,205 4,402 15,193 10,792 245.17% 115.06 Differ from year to year Other Financing Sources 8,398 8,398 2,799 11,668 8,868 316.80% 138.93 Sale of assets Appropriate Fund Balance 0 0 0 Total General Fund 17,444,200 17,444,200 5,814,733 10,795,624 4,980,890 85.66% 61.89 Fund 101-BUILDING FUND Licenses&Permits 608,708 608,708 202,903 154,767 (48,136) -23.72% 25.43 varies yearto year based upon activity/projects Chgs for Sery-Gen Gov 0 0 0 35 35 100.00% 100.00 Unrestricted Investment Earning 15,000 15,000 5,000 12,634 7,634 152.67% 84.22 Active investing,balance and rate increases Miscellaneous Revenues 0 0 0 2 2 100.00% 0.00 Appropriate Fund Balance 564,262 564,262 0 0 Total Building Fund 1,187,970 1,187,970 207,903 167,437 (40,465) -19.46% 14.09 Fund 301-Capital Improvement Fund Sales&Use Taxes 757,055 757,055 252,352 150,857 (101,494) -40.22% 19.93 state revstwo month behind,record-cash basis Unrestricted Investment Earn 0 0 0 17,161 17,161 100.00% 100.00 Active investing,balance and rate increases Transfers In 15,000 15,000 5,000 0 (5,000) -100.00% 0.00 FY 2024 not recorded,transfers recorded at year end Appropriate Fund Balance 481,909 481,909 0 Total Capital Improvement Fund: 1,253,964 1,253,964 257,352 168,018 (89,334) -34.71% 13.40 Fund 303-Capital Projects Fund Unrestricted Investment Earning 0 0 0 3,614 3,614 100.00% 100.00 Active investing,balance and rate increases Grants-State 200,000 200,000 66,667 0 (66,667) -100.00% 0.00 Timing in revenue recording Transfers In 1,884,895 1,884,895 628,298 0 (628,298) -100.00% 0.00 FY 2024 not recorded,transfers recorded at year end Total Capital Projects Fund: 2,084,895 2,084,895 694,965 3,614 (691,351) -99.48% 0.00 Fund 401-Water Fund Charges for Services 8,234,600 8,234,600 2,744,867 2,429,786 (315,081) -11.48% 29.51 watersales revenue one month behind Unrestricted Investment Earn 0 0 0 127,945 127,945 100.00% 100.00 Active investing,balance and rate increases Miscellaneous Revenues 37,272 37,272 12,424 24,698 12,274 98.79% 66.26 Differfromyeartoyear Other Financing Sources(icl.loan) 8,620,000 8,620,000 2,873,333 26,101 (2,847,232) -99.09% 0.30 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 5,630,624 2,608,529 (3,022,095) -53.67% 13.73 Fund 402-Refuse&Recycling Charges for Services 592,403 592,403 197,468 494,311 296,843 150.32% 83.44 Historically,91%receipted bythe end of Feb Unrestricted Investment Earn 500 500 167 2,078 1,912 1147.02% 415.67 Active investing,balance and rate increases Appropriate Fund Balance 19,697 19,697 0 0 Total Refuse&Recycling: 612,600 612,600 197,634 496,389 298,755 151.17% 81.03 Fund 403-Stormwater Utility Grants&Contributions 252,500 252,500 84,167 0 (84,167) -100.00% 0.00 Timing in revenue recording Charges for Services 545,550 545,550 181,850 448,126 266,276 146.43% 82.14 Historically,91%receipted bythe end of Feb Unrestricted Investment Earn 500 500 167 3,158 2,991 1794.69% 631.56 Active investing,balance and rate increases Miscellaneous Revenues 0 0 0 5,300 5,300 100.00% 100.00 Appropriate Fund Balance 28,768 28,768 9,589 Total Stormwater Utility: 827,318 827,318 275,773 456,584 180,811 65.57% 55.19 Fund 605-Special Law Enforcement Forfeitures 25,000 25,000 8,333 623 (7,710) -92.52% 2.49 Differfrom year to year,timing of collection Unrestricted Investment Earn 1,500 1,500 500 3,690 3,190 637.91% 0.00 Active investing,balance and rate increases Appropriate Fund Balance 138,161 138,161 46,054 0 0.00 Total Special Law Enforcement 164,661 164,661 54,887 4,313 (50,574) -92.14% 0.00 TOTAL REVENUES-ALL FUNDS 42,579,751 42,579,751 13,133,871 14,700,508 1,566,637 11.93% 34.52 NOTES are for differences grater than 10%and amounts over$1,000. Page 235 of 590 A THE VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED FY 2024 FY 2024 33.33% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 01/31/2024 VARIANCE VARIANCE USED Fund 001-General Fund Council 74,640 74,640 24,880 18,741 6,139 24.68% 25.11(1),(2) Manager 362,368 362,368 120,789 107,537 13,252 10.97% 29.68(1),(2) Human Resources 456,599 456,599 152,200 149,910 2,290 1.50% 32.83(1),(2) Village Clerk 447,453 447,453 149,151 142,299 6,852 4.59% 31.80(1),(2) Finance 807,224 807,224 269,075 277,652 (8,578) -3.19% 34.40 Legal 195,000 195,000 65,000 81,983 (16,983) -26.13% 42.04(1),(2) Comprehensive Planning 495,338 508,808 169,603 89,095 80,508 47.47% 17.51(1),(2) General Government 328,215 329,212 109,737 103,745 5,992 5.46% 31.51(1),(2) IT 535,503 549,931 183,310 256,233 (72,922) -39.78% 46.59(3) Police Department 3,748,841 3,748,841 1,249,614 1,117,336 132,278 10.59% 29.80(1),(2) Code Compliance 109,261 109,261 36,420 5,123 31,298 85.93% 4.69(1),(2) Fire Control 4,764,250 5,501,292 1,833,764 1,373,331 460,433 25.11% 24.96(1),(2) Public Works 1,626,076 1,682,545 560,848 445,328 115,520 20.60% 26.47(1),(2) Leisure Services 1,201,176 1,210,152 403,384 403,885 (501) -0.12% 33.37(3) Debt Service 542,250 542,250 180,750 381,706 (200,956) -111.18% 70.39(3) Interfund Transfers 1,700,008 1,700,008 566,669 0 566,669 100.00% 0.00(3) Allocate to Fund Balance* 49,998 49,998 Total General Fund 17,444,200 18,275,582 6,091,861 4,953,904 1,137,957 18.68% 27.11 Fund 101-BUILDING FUND Building&Zoning 1,187,970 1,188,797 396,266 339,125 57,141 14.42% 28.53(1),(2) Allocate to Fund Balance* 0 0 Total Building Fund 1,187,970 1,188,797 396,266 339,125 57,141 14.42% Fund 301-Capital Improvement Fund General 65,000 65,000 21,667 6,975 14,692 67.81% 10.73 (2),(3) Public Works 210,000 805,782 268,594 430,633 (162,039) -60.33% 53.44 (2),(3) Parks 175,077 175,077 58,359 0 58,359 100.00% 0.00 (2),(3) Tecluesta Drive(Bridge) 44,000 44,000 14,667 0 14,667 100.00% 0.00 (2),(3) Tequesta Park 250,000 250,000 83,333 0 83,333 100.00% 0.00 (2),(3) Misc Projects 310,000 331,314 110,438 92,012 18,426 16.68% 27.77 (2),(3) Interfund Transfers 199,887 199,887 Total Capital Improvement Fund: 1,253,964 1,871,061 623,687 529,620 94,067 15.08% 28.31 Fund 303-Capital Projects Fund Public Works 710,000 710,000 236,667 0 236,667 100.00% 0.00 (2),(3) Leisure Services 1,250,000 1,250,000 416,667 0 416,667 100.00% 0.00 (2),(3) Allocate to Fund Balance* 124,895 124,895 0.00 Total Capital Projects Fund: 2,084,895 2,084,895 694,965 0 694,965 100.00% 0.00 Fund 401-Water Fund Water-Administration 1,711,930 1,832,727 610,909 571,849 39,060 6.39% 31.20 Water- Production 2,280,598 2,305,499 768,500 546,056 222,443 28.95% 23.68 Water-Distribution 889,331 890,761 296,920 223,814 73,106 24.62% 25.13 Water-Customer Service 320,184 320,184 106,728 86,926 19,802 18.55% 27.15 Renewal&Replacement 3,753,000 4,382,290 1,460,763 134,708 1,326,055 90.78% 3.07 (2) Capital Improvement 9,555,000 11,630,465 3,876,822 0 3,876,822 100.00% 0.00(2) Debt Service 494,100 494,100 164,700 150,833 13,867 8.42% 30.53 Total Water Fund: 19,004,143 21,856,025 7,285,342 1,714,186 5,571,156 76.47% 7.84 Fund 402-Refuse&Recycling Refuse and Recycling 612,600 612,600 204,200 153,360 50,840 24.90% 25.03 (1),(z) Total Refuse&Recycling: 612,600 612,600 204,200 153,360 50,840 24.90% 25.03 Fund 403-Stormwater Utility Storm Water Utilities 373,318 459,261 153,087 99,921 53,166 34.73% 21.76 (1),(2) Renewal&Replacement 454,000 701,196 233,732 241,901 (8,169) -3.49% 34.50 (2),(3) Total Stormwater Utility: 827,318 1,160,457 386,819 341,821 44,998 11.63% 29.46 Fund 605-Special Law Enforcement Police 164,661 177,695 59,232 14,511 44,720 75.50% 100.00 (2) Total Special Law Enforcement 164,661 177,695 59,232 14,511 44,720 75.50% 100.00 TOTAL EXPENDITURES-ALLFUNDS 42,579,751 47,227,112 15,742,371 8,046,527 7,695,843 48.89% 17.04 Notes: *Not included in Target Budget calculation (1)Personal expenditures/expenses recorded as when paid not when accrued.Personnel paid 1/18/24 for the period ended 1/13/24. Due to timing of payroll dates 18 days of personnel expenditures not reflected in January 2024. (2)Not all operating expenditures/expenses recorded for the services of January 2024.Expenditures recorded on a cash basis and adjusted to accrual at year end. Page 236 f 590 (3)Timing in expenditures/expenses recording and/or recorded as one time entry at year end. Agenda Item #13. I- 00 M n O 'j- Ln I- O N N M —1 N ri M M LV r-I (V 00 m ri Ln M W N lD 00 Ln N N Ln ri O l0 M r-1 00 00 r-1 r-1 N N 00 Ln N ri O N L1 M M 00 l0 ri O 't N N rl ri ri ri fV N N cI ri cI N N N O O N N O O N N r-I N N N LA N N N (p N l000 ri 00 N N 't cn M 00 � N c I N I� LD c-I N DO 00 Ln l0 M M 1l ri O L.0 \ ++ \ O Il � n Ln M � � \ a) N Ln Ln ri ri 't M � N N c-I r-I N N t.0 N N 0 N M l0 l0 c-I ri M Ql N N ri N N O ~ O O N N N Il N Ln I:t LD w LD lD M M O M L9 00 N ri O N Ln M I� ri ri r-I I%l I,, Ln W Ln I� Ln 00 l0 T O :1- O ri ri M N N I� M w M O N M M c•n 00 Ln O �t N N M N M M r-I r"1 N N r-1 r I M ri N N N N a\i N N O O O N N N M � � O O O N N M n n O n Ln CD Ln N Ln O M O ri \ \ I- r-1 Ln N 't N M O ll) ri lfl Ln M N N c I N \ N N M N N N N cn cI N N N M 01 M N rI N N N N O O O N N N s s s c c c C0 C0 0 G c r- N O O l0 � O N ri 0 I- M ri r, N ri O O O O 00 ri r- w � L L L 3 3 3 U U U N L. O Q Q7 al _0 N E E +J L VI E L VI L ++ Ln in aN., C 0 aJ bD o •- N 0A }j dA CL .+� � :� o o Ln o V) 4 L CZ O m U N in H a ra W U Q N + c N Z- v o ao \ CO 0) v 0) o a� i co + ca O aUi co E a0 0 Q Ln — c� > a', Q Q a f6 T z u U v E to v 0 o v °C c E E - v - ai H } o E L ai -0 L _ o f °c c V) c �, o v o n o 2 .� v Q ac, •- M �, c v v T E a) c c o u +- v V) c — v O n v a — + g U c o 0 o a, c U 0) Ci u O U a) _ c0 c — ra U +' ai a) O VL a _0 a Q s_ > U Ln n Ln 'U G .� 'U Q aa) Q" , a1 U U +•+ aJ o O L LL. O \ aJ W m Lnn '+� L � +� L_ Ln Q V) c (D •E .� 0c U U O Ln O o > Ln Ln i Q m c ,n ca L6 aci N — O U ate- O +� La VL Lu n U U + _ E ai E _ _ v '+- LF L Q Y Q m U v � � E w ai E 48 � u a, U E ° E to o Q a ' � 3� of 590 a� m o m v o o ' 2 M v > v o v 0 v LL. U a o 0 z oc v U- oc v m > U O w v = a = LL CO U z _ v U Agenda Item #13. O r-1 ri 1-, 00 -:T 00 -1 N O N r� r-1 w M N r� N O 00 m Ln N 1l L0 ri M ri Ln R:T ri R:T lD M N M N Ln r-1 1- �t O 1-1 Ln M M N r-I r'1 00 r'1 N N 00 r1 Q1 O O O O ~ O N N 00 Ln (n N n r" Ln 00 rV r-1 O r-1 M N O 00 O N 1, Ln l0 M r-1 M LD N N N 00 0o -zt �t M Ln -1 00 O O rMI O O I� M c I d) c I O =A O w � r- Ln 00 w Ln N N N Ol O Ol O O N N M r 00 M 00 w 1-1 00 O N M 00 M w N w 1- � 00 O M O 00 c-1 M 1� c I w w I;t O M O M Ln N n r" M N M 00 r" w11, N r-I M N M N M M M -1 M y1 O 4 00 00 00 1 76 N O N O ~ O N I I I N M Ln O O rr4 0000 O r-1 � O NM Ln 00 N w -1 w :I- w 00 � O 1- M w M 00 r1 00 kD N 00 00 00 M O H 0 N N N N ri 1O M a-+ M O O ~ O N N ri M w O 00 O O O 1\ O M O r-i Ln N O N rV ri N O -i M Ln M -:t W N c-I ri N r-1 CCO CCO N c-i Ln G G C C L L L L 3 3 V V N c � ra U � a - L a w w -0 U c O V Q V o > V ro i - c C N i i a ra +� o cr V � ro c 0 M CL rya ra 4- O _O U c rya GJ N -r- co N 7 V � 0 n `� 2 Ln aJ V a; Ln 4 E LL of°i > ado � g V M D a � o m r6 Uu a Ln a h c 0 CL6 � N w m aa"•+ M _0 4-1 00 a ao E x a ra v, p E a c = a E w Y a c E ca V a an E 0 > o v M aUl a LL a aj bU Q 7 {A N O L a U ++ 0 a � � c a > N � (6 In a ra ra aa� bn — ca M i V t a a u 0 °C ' cr Ln c c in r° c E a n ' -c 0 v 'v, O Q Q a a E — �, a o v, a u Ln o = 'o c L 4- auLn Lni rn `� > CO ai c Q ai 3 a +- — ,., — ro 0 vai vai > 0 .� 0 ra c a z ra O_ Ln U W � ra ca L ucn a \ Q oc , a c a v, V a � c c V U ._ O L x " -- E a } a 0 c O DC U- w Ln O 21 2-1 a s '1w 0 a O ca E c • 'E L` +, _0 _ !21 ra en > c = E �, v � o + a > 0 0 `a a' � o c a � `a c c7 s 0 a m a � `a `� � O = a e 3 of 590 V V w CO O O a Q N Lo m V 0 a 0_ can H i i V 5 Agenda Item #13. O l0 M M � M D1 1- l0 M M M LO00 N N ri o 0 0 0 O 1- w 00 lO M N LO .-I M M w O �t N lD LO M w M :t M r-I -1 M N ri M N O M 'l- N N Ln 00 N N Ln 1, lD Ln ri N Ln M l0 ri ri N c I LO N LO M r1 M N I� N o O 00 N ti O N 0 00 O � � c I c I 1-1 M \ c I O l0 1--1 c-I Ln O Ln M -zt 00 ri �t M M �t Ln �t M IzT N Ill ri Ln M M N O Ln 1--1 ci w N Lrl M ri N Ln 1-1 ri Ln l0 Q N Ln N c-I M c-I 00 r6 +M+ \ (0 o N 0 p `" N ri (14 O N ri qzl- 00 N Ln lD l0 L,O r 1 W n n 00 N M Lr) I, M n n L.D N r r) M ri (.0 M N ri ri M ri 0) ci O ri M N r-I ri ri rn N M N o ~ M } N N O l0 Ln c-I �t N O ri O o N 0) O M M O N W O M ri N N M -:t 1,0 ri ri O c-I M N y,, o t c-I M M c-I 0) a ++ Ln 1Do = 3 0 0 co _ a+ fC � � L v � Q v U � a a � E O N co N rp 4 J j N M on co a a M z E N c O OC O _ 4- 0 06 rB V) 0 H H I_-O Q a O 4J Ln aLn Q i 7 7 O i Q cu V) E L , a--� a V > co _ c Q V) a 4- a r a > LL a Y a z 4-1 � C > +' Ln 0 O LA L O c� Lnn a w +, _ v 0 3 C7 n > ca 0 H LL cn U a O +� cn �+ �--i aLn .� Y C >� 3 bA of = H N � U r0 � O C by >; (C Ln L O O +t O -O C � O bA C n U � O c +J 0 O LL. V, O f L- H n m 0 'n U bA bD C U O .O a Q O = Cr r6 a a > o U co c w o Y a o ° Q w bn v o v o L a no O u a c a ° E E o_ ra .a — � o O � U oc o a a U a z Q z oc Li- U vl N N .Q v �° `O m •E Q Y LO U O `n 1 O L^ > ° M L1J L1J LU " C ° M o v Of 590 a 0 O Q S 0101 a w w w H LL � � D_ = 2r A Q Agenda Item #13. N 4 7 \ / 0 z \ / 0 » \ - E ~ / < o o # / o S 0 3 % ? / m % % 0 0 0 0 � 00 m Ln 0 0 » \ o o < Ln g o 0 0 0 o z m z o z o m % / \ ? ~ / $ / q Ln 3 g r-l� m Q 0 \ 3 z e m z � � m m � � \ m - � 0 0 o o 0 » o 0a) M 0 G g m o o \ 0 0 0 0 0 0 0 o g o 0 0 0 0 r 0 2 � J u u § / � � a § 41 0 u / 2 2 1 7 E o / \ / y 2 m / B ■ } f M } u = o = a e \ 0 \ ƒ \ k 0 3 ƒ � 2 E / $ -R % .- \ \ ƒ \ / / u / 2 ƒ £ / \ 5 u t § 2 / ƒ f } / 0 \ 7 e J � m > u e ƒ 0) ® \ e I u M ± ± 2 2 Lu ® . u § u D. \ E E % M Ora > 2 = � o o / \ o O E e 2 g § 2 \ E / \ M e E O o e i R m U 2 o u •- - £ e e S .� \ 3 = 2 e . u G G 2 2 3 ® 5 = = u = e f 3 3 3 \ u y = E G >. / m m M fu \ > > COw > a E = 2 » o / _ _ g � % < r 2 r_ ± g _ _ > < < / « u . e E = E e = E 2 2 = o 0 u m \ = k ' 2 / f ƒ § O 5g0 \ o / / / ? / � / / / / m 3 u 2 2 2 2 / / / / R � Agenda Item #13. rl � o 00 00 LO M O O� O O 00 Ln O O O M l0 Lnn N -1 N O N O y� N O M lzt t o 0 0 � 00 � O C\i 00 m Ln N � H � O N O O O O O O O O O O O O 0 O 0 _q O O O O O O N 0 -;t r-I O O 00 Ln M O O O O 0 O 0 �t O O Ln O Ln O 00 rl 1-1 O �t 0 O Ln N rl N 00 .--1 I-, �.o ItCA r-1 00 Lr' rr ri -1 -1 _ N 4 M I'D C* O O 00 (14 cV O N O O 0 00 O 0 O 0 00 0 0 O O O O -1 O O O 0 0 0 O 0 ci chi (1 Ln N rl S Li 41 _ Oc E al l0 ++ r, N Ln = 00 N aJ L L 3 V aJ C V) E i Q C2 0 QJ E U U - .E U v a o +a _ N — E V) — 73 - > +, C A a; E a v +, 41 c o �_ U ro v�i O 4� ~ N W M L E rLa Ca) a) 0 VI m > > L �' V, O C r C a1 C N +, O a1 O N a-' W f6 Ln C L.L E g o a, w a- c ai Y LL CC N v -C H Cl co U u U m E _ — > > v � cB V) Q O Lco -IZZ n ro ii W " n 1 > O P S ra E 2 0 Ln3 u O 0 0Ln Q a) � U •U �_ N W . � = L.L. L •} [6 L O Qf i Q U > U Q a) s 0 a) O a s C +� p ,C C a) C — i E O U U- L CC Q o o � °' Q � a) o Q. o a, a, o a, u � �' � M M o e A41 of 590 � N w ii Co H Li (A W 2 (!) w CO 0 � LL m I w V d Agenda Item #13. / N o M m � � § ) 2 N o 0 2 m » q 0 \ / ~ rn / 6 0 0 $ rQ j p 3 Lr)- % 2 7 @ _ } / § \ 0 ƒ e 0 - m % e@ o / N e m o m Ln � m � c e o � $ ® o e N � @ I It 3 0 � m � � � e 00 o@ � m � » M » = m � -1 00@ � m z m � # @ e m e e � K ® � � § o \ \ / e m \ f / / % \ \ / \ \ � \ / \ \ / \ / \ / % % 7 \ + ; \ e e � $ m biD \00 k m » ® r 200 > m / o 0 o r c # o 0 \ 0 2 e o _ e O m m@ c = e e@ e 2 \ e e@ e m � @ § e 2 w V1. 3 0 E _ \ 0 & E _ % ± o E \ % / \ u 'k / } ? \ \ Qj c \ c 3 o p .E 2 'e = 2 E k E f / ƒ / / / $ \ ƒ 2 ® $ ® > 0 # e G = s -0 ƒ / 2 = g ± ' m g / e o E r / ai e k \ ) 0 § ® / f < E E a � - « _ _ } ( & 0 » 2 0 _ § § 2 " a / w G = } e e 2 / r A 7 2 2 § \ \ \ ƒ w / M / 2 ® ( / 7 � k \ t u o a } CC U u 2 2 2 g k % .\ k > 0 I t ƒ g 3 \ [ u £ \ = E g 2 E » _ fu — m e - � = » ' u \ £ \ « 2 u • / / G = > 2 _ E / 2 2 2 2 % ¥ t o s a 5 ) / d e o 4 O ƒ \ / / / / / -0 k \ / - \ \ 0 \ \ % / E e — � ®r- E< o O � 3 CL 2 7 � > = 3 t R \ 3 LA \ w 2 0 5g0 Agenda Item #13. N O N � N R N I- ul 00 M m m Ir) ^ O N M n � U) n u1 ++ 4 N N O I, Kt o c:, l0 l0 00 M (.0 rl Ol Lr) ul `1 lD M M -1r- M 00 00 I� ri Ql M O N Lfl Ln Ql c-I M �--I i--I -1 N V)- c-I N M U) Ln � M N N �1 lD I, H N I N N N ° O M � N O O M Ol N tD i0 ^ i0 I_r) � M M 00 � N CY) I, M 00 N O lD N Ol M M l00 r-I 0 00 I� ++ M Ln 00 O I- 00 l0 61 Lr) M M In DO aj N N a--Ir14 Ln Ln l0 N p Ql N 00 ci N M IT N 1 Ln Ln M (M M M m M c-I Ln W ~ O -100 N N Ln M N O fp N L N 00 w -1 N -1 w N M p Ql 00 C un u m .1 O I, -1 N m W �o L M r�-I 00 N 0r140 -1 r-I p � nj N N N -I I.fj N -I (,j O M L LO 00 w -1 N M O fQ r I O M l0 r1 N N N 00 N p 00 O 00 Ln Ln M c-I O I� ci N M w -i Ln M c-I N c-I c-I N N � fa N .--I N c-I N F� tw a C to O N tE Q 76 0 n n L Lnc C L L -6 a) 3 V1 4- = W Y .a O a) V) L 2 O +� n a) c tia o v L o U C n O Q Y n O +� N cv cv In a--I Ul 4. n O v C) >• +, a) ra C) s o c o .O C v c c a Y ° a > O c� a c ° c O u cNv u E U L o O o M 0) c 3 v - in EO U nz c j n tW u cv O (n 4 of U +, C a) i6 - co 0 - O Y o a C7 +� - 3 U- a) 3 a O a� z L ' a� c E L E bA O a) n 0 +, L O aJ - U L Q) > 4-1 a) 4-1 c dA c n n n vn an >- an " s v c 30 cn ca O O L >- a) N 0 E ul i N E a U U U J aJ cu � 0 3 c `i a� a) C) 0 6 V, v c, L a *' v O 3 Y s0 lz a) �n �n c •+•� a) U N L L .� N to C h h 4- O O C -0 a) a) O Ln W a) O +- O U Q O O Z� C M N 0 C aJ co a) O L.L. d a) °) a +�� � WU U u E z = ct o a m o v Ln L E o v � E E E O_ Q E Ln ° a1 0?S CJ N C) +1 4- `.� coo t C n can W in rL6 a) d {n LbD E E E u �, '� > c°°a c c v E o a o M a E o U U j O c W a W LL u a) E U G o p a� 'v � M +1 n +J +J c O U w > Q = O C — 4 Y O U- rr O w E L c aj C C w � v, �, _ a -a a �, v, c O � L v en � a, v +, M +� c ca v v v a, ra +� L — — o — E v o n tin L U a... t.1 L O O Q 0a U p� L •L u -0 U w nA p0 a) C s2 O O a) c = c a) o f a) - O C C M '- M M r0 E - c v o E ns o v ,_ -0 Ln -0 L w � M � c U v a) +� U LL a a — +1 — em u — Of 590 a Q v O = O Q -1 a � = Q a z M `LL s Agenda Item #13. \ q \ / / % i / \ / \ \ \ e 2 % % c < z # @ \ C4 m r" w e e % $ � « q ± $ 2 « \ « / % � = o ® _ # m « Q z # @ k 2 -1 _ � 2 m 2 � % z # # � Ln @ /\ / y\ \ 4 / /ee 7 %a) � » r34 o = m o 0 o m o o r'4r e » e 2 / @ /m k » f q \ / / / \ » (N o = m o 0 0 Ln 0 0 @ � m e e � 7 / \ / L = (D (U ® g _ \ 2 \ � � o ƒ / E E k \ c k � \ CL � 2 § < \ M — -aai / / ¥ R 4-1 / / V3-11: 0 2 3 U k / / x j } / f / ) 4 / / k _ / 5 C V c - / \ % ) � / E 5 q \ e n / _ M 0 e § 2 / 2 \ § 3 / \ § g a \ 9 t / \ I 2 c R f / \ / / % \ = 5 / ® [ o 2 M w o % 2 2 2 2 = / 0 ƒ $ � 2 § / \ / / / 7 \ F ƒ / � ._ _ -0 y \ o = r — / G M e ° '» 2 ° % 2 . @ E t t / / � ƒ y \ > ( \ 2 2 / $ .2 \ / / 0 § 0 E / 2 g ) \ / % § ) a ) @ \ / L E % \ G > z t = ® u CL % 2 � = g 3 G G \ / % f a w 3 E � § E E E [ � ( % LU LU / — ) \ y n \ \ % 2 'g o 0 0 0 L.Lx x # x x } / # k } f / n /I's CO U \ / \ Page 244 0 590 x z 4 u e 2 Ul m w w 3 3 Agenda Item #13. Z L L�ii n- d pO e Z to 4 Lo M LL OJ c 00* M N O a oc: Z O fu > \ 0 p O N N O O 0o Ln LAL L v U O > a.., 4A i L Q L r O L a) C OL to Ln N N [6 Z Q U Cru d L � a1 C bn Ln Ln Uj W ° � a) E c a (n N N O N a) 2 a C LL 0 4-1 N Q O +.; a LL > aa+ co p E -r ca Z a •N zi -p 6 L ,C N .LL U p_ 4 L U U Ln C Y O O o -1 00 r- 'T rl U? O M t/I f6 Q } w N -1 � M n Lb lT LO N O Ln 3 4-1 J L � � Ln i1 � Ln rrf c-I Ln N M a--I N ro � U +� O O C n a c6 a) -0 L a E Q m E o •- N L N M N O U o N 7 am) ELa aJ N N c a a u m v v N °; t o p U a > a Q 4- W ; ri Q M } M a N O to C Q O � M V N LL W Q 'A �O U '� •� 0 a) 7 (u `w a) ~r N aN-I N O fV r�-1 l0 M ^ C4 lD \ 0 0 -p o aL on N = N N Ln 0 U o — co c Ln -o Ln Ln m O co L +' O a) a! 4- a > N a co O �--+ C: � a Q E N Q O C O co .'Q c U co - -0 m Q 3 0- s s - LL; ) co a o v U o +� +� U p M o c U v " v 0 0 ai ro Z > 0 a v as =ro a) � o 0 Ln O O U fo •+�-,� .V [6 00 2 �--I a--I a--I N 01 M � lb N lD M 0� Ln 4' CO N U Ln 3 O O L a N M LI N C O O .c a1 Q co C a 4- an E C) CJ L aJ a 3+, co c �L O ro a) E J v O c)O (U ro � -o -6 a s co 'n n ro c C:T j a O dA Z Q f6 Ln - Q N a) aj CU O C 4- O W ~ W n 'U vi O O ULLI J +-C 0 U w Y n (1) a U = a° O W Ln fV v o a > U v a a) O -p W a) (3) U O Q (A on C) co i O 4)Y5 mQ d a'' � °Q � UZ U cC yjE1E O41ul o O O u d O O a)) Va � n -0 4- + NGGl7 ro co L +, a � 0 o L -� OC pOp °�' v ro v o M +-' � a s Lo O W C � c 0) p H > a MO w C: a a � W p) a O U " � C 0 M L .� ,� •M U i OC 2 3 d dA cn � O L N � Ln CL = a) a � 41 � -p > o ) (o V) LM } L >o C M M L ? E oo :� Eo I 0 M n a C LL L.L a C) p O C: 2 CL � U O Ln QW a C: , _ -I Y N a GfC1:� a Ln >, O 1J Q +-, Lri -p E bb LL LL u a a +� N (A M M a o U o n c + — = v C U � Q ns j E c Ln M C p •` O — Y a a? c Ln U a ++ u o E N ° ai f6 V, ca a a aMi v c o oac ° �' m � a m Q o N OC co n } x c 2 L Lri do = m +, z Ln = � M E a c U to W +-� O c W +, c m C U cu N O La � O M E 3 c Q H Q p U L 0 n o c ° o ca a +, a — a a) a) v Q Eai a) a u u a Z- •� a Ln a x a o c 06 u`ni S +� W uo nA u c L L ra a O w Ln a s Ln G L M M la U_ L U L L L p (n L a O Q _ _ � _ CD L U U a) > m Q W c c >j .E O U - > a O_ a; +� O_ > aa, M " ° v ° W a U. n3 a) � v >M v ° a cca ca >° o La ca U a e of 590 V O- d � � o E 2 c Q L 0 a > Ln J LL1 G G > V LL1 > G J (n J Agenda Item #13. Q \ / / = I I / k.0 �.O 2 / « G � LO rn % \ \ "D 0 \ 2 / ( » C / k \ / e � 70 \ r4 \ \ \ / / 2 2 \ > ) / \ j \ % / \ / \ / / g f � 7 }� — % u k \ m m k \ / k rn / \ / � / \ M \ \ \ \ � \ \ 2 � � t G ra u \ \ k ^ / \ t _ M / > c > s 2 > [ R E R 7 G \ ) S \ to § / y \ru L. _ 3 \ \ \ ru S e o = m o w ( Of \ / Ln � J f W 7 = '( ) \ � \ j \ \ e e C 2 in s \ a) \ _ 0 t 4 S = y \ a) t 5 \ c \ § \ \ \ k } \ u § / \ z x » / } \ / > / 7 \ / Page 246 0 590 Agenda Item #13. Page 247 of 590 Agenda Item #13. Page 248 of 590 Agenda Item #13. Page 249 of 590 Agenda Item #13. Page 250 of 590 Agenda Item #13. Page 251 of 590 Agenda Item #13. Page 252 of 590 Agenda Item #13. Page 253 of 590 Agenda Item #13. Page 254 of 590 Agenda Item #13. Page 255 of 590 Agenda Item #13. rRN �i C7 C7 ro M Ln d N N Page 256 of 590 Agenda Item#13. E 66666 " ', E H ' -- g \\ \ \ t ; { ) \ M A dil S S 2 E E 2 2 Page 257 of 90 Agenda Item#13. Page 258 of 590