Loading...
HomeMy WebLinkAboutDocumentation_Regular_Tab 08_10/16/2024 Agenda Item #8. Regular Council STAFF MEMO Meeting: Regular Council - Oct 10 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.5 million, which represents 100% of the budgeted amount. It is almost $2.2 million (23%) higher than for the same period of the prior fiscal year due to Seaglass, home sales, and increase in valuation (Homesteaded properties limited to 3% increase). Historically, 91% of ad valorem tax distribution receipted by the end of February. 3. Sales/use taxes (105%), 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 in full. Insurance premium tax police and fire collected 11% ($34 thousand) above budgeted. Water utility tax is 21% above budgeted for eleven months collections due to higher water sales and infrastructure surtax collected 13% above budgeted for the ten months period. 4. Intergovernmental revenues (103%) which include municipal revenue sharing, half-cent sales tax, and local gas tax are one month behind the collection/reported period. It is above budget target for eleven months collections due to the half-cent sales tax revenue increase by 16%. 5. Local discretionary infrastructure surtax(96%) - collected at $513 thousand, which represent 96% of the budgeted amount for only ten month's collection/reported period and is above target for ten month's collections by 13%. 6. Revenues (Budgetary comparison) recorded in the General fund represents 104% of budgeted due to the distribution nature of Ad valorem taxes collected at 102%, representing 64% of overall General fund revenues at 9/30/2024. Note: The Village will continue recognizing/recording revenues for FY 2024 collected within 60 days of the current fiscal year end. Page 107 of 512 Agenda Item #8. 7. Overall Expenditures (Budgetary comparison) in the General Fund represents 89% of budgeted. Not all the expenditures were recorded for the services provided for the month of September 2024 and personnel expenditures were recorded as paid not when accrued. Note: The Village will be recognizing/recording expenditures for FY 2024 within 45 days of the current fiscal year-end. 8. Revenues and Expenditures (Prior year comparison) all funds — data is not comparable due to FY 2023 balances adjusted/audited and FY 2024 will be recording revenues for 60 days and expenditures for 45 days of the fiscal year end. This document and any attachments may be reproduced upon request in an alternative format by completing our Accessibility Feedback Form, sending an e-mail to the Village Clerk or calling 561- 768-0443. BUDGET INFORMATION: BUDGET AMOUNT 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 Sep 2024 October Managers Report September 2024 Grant Budget Worksheet Page 108 of 512 s 000Ito�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/8 4acanati Period Ending 09/30/2024 DB: Teauesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 366,175.61 Investments 8,740,407.50 Accounts Receivable 912,179.56 Due from Other Funds 0.00 Accrued Income Receivable 1,978.14 Inventories 44,600.05 Prepaids 115,210.99 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 10,180,551.85 *** Liabilities *** Accounts Payable (599,557.27) Accrued liabilities 14,537.00 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 1,592.22 Deferred Revenue 785,835.43 Other Current Liabilities 413.55 Customer Deposits 0.00 Noncurrent liabilities 0.00 Total Liabilities 202,820.93 *** Fund Balance *** F/B - Reserved for Inventories 0.00 F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 634,320.07 Fund Balance - Restricted 294,000.00 Fund Balance - Committed 500,000.00 Fund Balance - Assigned 831,382.00 Fund Balance - Unassigned 5,769,033.51 Total Fund Balance 8,028,735.58 Beginning Fund Balance 8,028,735.58 Net of Revenues VS Expenditures 1,948,995.34 Ending Fund Balance 9,977,730.92 Total Liabilities And Fund Balance 10,180,551.85 Page 109 of 512 s 000Ito�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/8 4acanati Period Ending 09/30/2024 DB: Teauesta Fund 101 BUILDING FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 79,090.99 Investments 667,092.76 Accounts Receivable 38.83 Inventories (492.51) Prepaids 3,866.58 Total Assets 749,596.65 *** Liabilities *** Accounts Payable (12,799.75) Accrued liabilities 0.00 Due to Other Governments 5,605.68 Total Liabilities (7,194.07) *** Fund Balance *** F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 10,656.92 Fund Balance - Restricted 1,052,159.01 Fund Balance - Assigned 828.00 Fund Balance - Unassigned 0.00 Total Fund Balance 1F063r643.93 Beginning Fund Balance 1F063r643.93 Net of Revenues VS Expenditures (306,853.21) Ending Fund Balance 756,790.72 Total Liabilities And Fund Balance 749,596.65 Page 110 of 512 s 000Ito�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/8 4acanati Period Ending 09/30/2024 DB: Teauesta Fund 301 CAPITAL IMPROVEMENT FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 133,437.73 Investments 741,411.56 Accounts Receivable 18,508.72 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 893,358.01 *** 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 (403,314.75) Ending Fund Balance 893,358.01 Total Liabilities And Fund Balance 893,358.01 Page 111 of 512 s 000Ito�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/8 4acanati Period Ending 09/30/2024 DB: Teauesta Fund 303 CAPITAL PROJECTS FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 223,434.19 Investments 25,321.25 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 248,755.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 (13,599.61) Ending Fund Balance 248,755.44 Total Liabilities And Fund Balance 248,755.44 Page 112 of 512 s 000Ito�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/8 4acanati Period Ending 09/30/2024 DB: Teauesta Fund 401 WATER FUND GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 616,605.39 Investments 10,760,372.25 Accounts Receivable 666,536.91 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Accrued Income Receivable 0.00 Inventories 254,578.91 Prepaids 33,084.22 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 29,069,267.07 *** Liabilities *** Accounts Payable (101,206.38) Accrued liabilities (300.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 46,045.00 Noncurrent liabilities 1,546,007.99 Other Long Term Liabilities 614,526.23 Def Inflows of Resources 538,011.00 Total Liabilities 3,074,943.45 *** 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 2,442,354.37 Ending Fund Balance 25,994,323.62 Total Liabilities And Fund Balance 29,069,267.07 Page 113 of 512 s 000Ito�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/8 4acanati Period Ending 09/30/2024 DB: Teauesta Fund 402 REFUSE & RECYCLING GL Number Description Balance *** Assets *** Cash and Cash Equivalents 11,446.52 Investments 71,704.60 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 83,151.12 *** 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 35,578.75 Ending Fund Balance 83,151.12 Total Liabilities And Fund Balance 83,151.12 Page 114 of 512 s 000Ito�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/8 4acanati Period Ending 09/30/2024 DB: Teauesta Fund 403 STORMWATER UTILITY GL Number Description Balance *** Assets *** Cash and Cash Equivalents 81,384.39 Investments 26,495.19 Accounts Receivable 1,612.87 Due from Other Funds 0.00 Inventories (81.06) 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,384,046.08 *** Liabilities *** Accounts Payable (602.36) 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,772.34 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 2,031,685.06 Fund Balance - Unassigned 480F853.59 Total Fund Balance 2,512,538.65 Beginning Fund Balance 2,512,538.65 Net of Revenues VS Expenditures (184,264.91) Ending Fund Balance 2,328,273.74 Total Liabilities And Fund Balance 2,384,046.08 Page 115 of 512 s 000Ito�am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 8/8 4acanati Period Ending 09/30/2024 DB: Teauesta Fund 605 SPECIAL LAW ENFORCEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 30,312.36 Investments 228,186.06 Accounts Receivable 217.65 Inventories 0.00 Prepaids 0.00 Total Assets 258,716.07 *** Liabilities *** Accounts Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** Fund Balance - Nonspendable 3,584.52 Fund Balance - Restricted 298,779.06 Fund Balance - Assigned 13,034.00 Fund Balance - Unassigned 0.00 Total Fund Balance 315,397.58 Beginning Fund Balance 315,397.58 Net of Revenues VS Expenditures (56,681.51) Ending Fund Balance 258,716.07 Total Liabilities And Fund Balance 258,716.07 Page 116 of 512 Agenda Item #8. VILLAGE OF TEQUESTA Cash & Investments Unadjusted Unaudited 9/30/2024 Cash and cash equivalents Investments Total General Fund#001 $ 3665176 $ 85740,705 $ 9510600 Building Fund#101 79M91 667M93 746,184 Capital Improvement Fund#3 01 13 3,43 8 741,412 874,849 Capital Projects Fund#303 223,434 25X I 248,755 Water Utility#401 61605 105760,372 11,376,978 Refuse &Recycling#402 115447 71,705 83 J 51 Stormwater#403 811384 26,495 10700 Special Law Enforcement#605 30,312 228J 86 258,498 Total Cash and Investments $ 195419887 $ 219261,288 $ 229803,175 *Interfund transfer pending Page 117 of 512 VILLAGE OF TEQUESTA Agenda Item #8. REVENUE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 9/30/2023 9/30/2024 VARIANCE %VARIANCE NOTES REVENUES Fund 001-GENERAL FUND General Property Taxes 9,530,215 11,703,838 2,173,623 22.81% Increase from Seaglass,sales,significant delinq collection Sales&Use Taxes 2,365,480 11471,630 (893,850) -37.79% Infr&Utility tax recorded in fund#301 in FY24 Franchise fees-gross receipt 6071485 536,990 (70,495) -11.60% One more month of revenue pending accrual FY24 Licenses&Permits 81710 8,390 (320) -3.67% Grants-Federal 88,966 221149 (66,817) -75.10% Differs from year to year Grants-State 1871176 341193 (152,982) -81.73% Differs from year to year Intergovernmental Revenue 1;110,601 1,017,016 (93,585) -8.43% One more month of revenue pending accrual FY24 Chgs for Services-Gen Gov 413,469 208,122 (205,346) -49.66% Land development fees based on the projects Indirect Costs 863,074 902,991 39,917 4.62% Rents&Royalties 220,951 210,714 (10,237) -4.63% Contributions&Donations 18,811 141762 (4,050) -21.53% Differs from year to year,timing in recording Miscellaneous Revenues 32,930 271436 (5,494) -16.68% Differs from year to year Chgs for Services-Public Safety 1,083,040 11284,041 201,000 18.56% Fire plan review fees Fines&Forfeitures 13,050 13,965 915 7.01% Impact Fees 2,615 121430 9,815 375.35% Impact fees based on the projects Grants and Contributions-Local 8,675 19,267 10,592 122.10% Differs from year to year Charges for Services-Recreation 123,738 162,643 38,905 31.44% Recreation programs fees increase Unrestricted Investment Earning 484,825 545,939 611113 12.61% Active investing,balance and study interest rates Other Financing Sources 53,480 57,601 41121 7.71% Disposition of assets Total General Fund 17/217/291 18,254,115 1,036,825 6.02% Fund 101-BUILDING FUND Licenses&Permits 1,053,625 679,811 (373,814) -35.48% Varies year to year based upon activity/projects Charges for Services 3,074 11783 (1,291) -41.98% One more qtr of revenue pending accrual FY24 Miscellaneous Revenues 0 2 2 100.00% Unrestricted Investment Earning 30,870 39,898 9,028 29.25% Active investing,balance and study interest rates Total Building Fund 1,087,569 7211494 (366,075) -33.66% Fund 301-Capital Improvement Fund Sales&Use Taxes 0 764,542 764,542 100.00% Infrastructure surtax and water utility tax Unrestricted Investment Earning 28,750 50,134 21,384 74.38% Active investing,balance and study interest rates Other Financing Sources 0 80,496 80,496 100.00% Financed purchase(tasers) Transfers in 873,583 0 (873,583) -100.00% FY24 pending recording,timing difference Total Capital Improvement Fund 902,333 895,173 (7,161) -0.79% Fund 303-Capital Projects Fund Unrestricted Investment Earning 1,082 10,321 9,239 853.90% Active investing,balance and study interest rates Transfers in 294,895 710,000 415,105 140.76% FY24 pending recording,timing difference Total Capital Projects Fund: 295,977 720,321 424,344 100.00% Fund 401-Water Fund Grants-State 0 21456 21,456 100.00% Differs from year to year Miscellaneous Revenues 37,881 38,052 171 0.45% Fines&Forfeitures 11,250 0 (1,250) -100.00% Local ordinance violations Unrestricted Investment Earning 3071757 460,861 153,104 49.75% Active investing,balance and study interest rates Other Financing Sources 160,371 2141158 53,787 33.54% Capital connect charge based on the projects Charges for Services 7,037,927 8,434,319 1,396,392 19.84% Cap Recovery charge impl in FY 24,water sales increase Total Water Fund: 7,545,186 9,149,846 1,604,661 21.27% Fund 402-Refuse&Recycling Unrestricted Investment Earning 3,221 11,648 8,427 261.64% Active investing,balance and study interest rates Charges for Services 572,373 590,139 171765 3.10% Total Refuse&Recycling: 575,594 6011787 26,193 4.55% Fund 403-Stormwater Utility Miscellaneous Revenues 0 9,798 9,797 100.00% Constraction damadge reimbursement Grants and Contributions-Local 14,385 0 (14,385) -100.00% Differ from year to year Unrestricted Investment Earning 1,586 121462 10,876 685.77% Active investing,balance and study interest rates Other Financing Sources 7,375 0 (7,375) -100.00% Disposition of assets Charges for Services 5221197 559,005 36,809 7.05% Transfers In 516,530 0 (516,530) -100.00% No transfers budgeter FY24 Total Stormwater Utility: 1,062,073 5811265 (480,808) -45.27% Fund 605-Special Law Enforcement Forfeitures 268,447 61,971 (206,475) -76.91% Differ from year to year Unrestricted Investment Earning 5,579 11,962 6,383 114.40% Active investing,balance and study interest rates Total Special Law Enforcement 274,026 73,933 (200,092) -73.02% TOTAL REVENUES-ALL FUNDS 28,960,048 30,997,934 2,037,886 7.04% Page 118 of 12 NOTES are for differences grater than 10%and amounts over$1,000. Agenda Item #8. VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 9/30/2023 9/30/2024 VARIANCE VARIANCE NOTES EXPENDITURES Fund 001-GENERAL FUND Council 63,632 671P231 3,599 5.66% Manager 323,118 380,656 57,538 17.81% Wages,bonus,sick leave buy back(retirement),ins Human Resources 4041176 412,348 8,172 2.02% Village Clerk 3821765 3921484 9,718 2.54% Finance 741,073 768,982 27,909 3.77% Wages,ClearGov software subscription$24K Legal 228,972 192,343 (36,629) -16.00% Differs from year to year based upon service needs Comprehensive Planning 285,687 3021253 16,567 5.80% Full time hire General Government 2241491 274.1154 49,663 22.12% Other contractual svcs and insurance increase IT 573,093 538,439 (34,654) -6.05% Comp system maint&supply Police Department 3,568,316 3,638,487 70,172 1.97% Code Compliance 68,151 54,308 (13,843) -20.31% Due to vacancies Fire Control 5,549,689 5,319,280 (230,409) -4.15% More expensive Ladder Truck purchase in FY 2023 Public Works 1,521,824 1,502,434 (19,390) -1.27% Leisure Services 11100,107 11193,507 93,399 8.49% P/T salaries,ins,program fees and misc park projects Debt Service 591,361 558,213 (33,149) -5.61% Pumper financed purchase paid in full Interfund Transfers 1,573,978 710.1000 (863,978) -54.89% FY24 pending recording,timing difference Total General Fund 17,200,434 16,305,120 (895,314) -5.21% Fund 101-BUILDING FUND Building Department 896,455 1,028,347 131,892 14.71% Wages,comp abs,ins,insp&other contr svcs,mgmt fees Total Building Fund 896,455 1,028,347 131,892 14.71% Fund 301-Capital Improvement Fund General 0 6,975 6,975 100.00% Projects varies year to year Public Works 130,830 7521129 621,300 474.89% Projects varies year to year Parks 0 169,762 169,762 100.00% Projects varies year to year Tequesta Bridge 0 5,400 5,400 100.00% Projects varies year to year Miscellaneous projects 276,412 364.1221 87,809 31.77% Projects varies year to year Interfund Transfers 111,030 0 (111,030) -100.00% FY24 pending recording,timing difference Total Capital Improvement Fund: 518,272 11298,487 780,215 100.00% Fund 303-Capital Projects Fund Public Works 170,000 3741P830 204,830 120.49% Projects varies year to year Parks 0 359,090 359,090 100.00% Projects varies year to year-Remembrance Park Total Capital Projects Fund: 170,000 733,920 563,920 100.00% Fund 401-Water Fund Water-Administration 1,300,182 1,566,606 266,424 20.49% Insurance,engineering svcs,comp system maint,mgmt fees Water- Production 2,006,155 2,003,132 (3,023) -0.15% Water-Distribution 789,883 7141869 (75,014) -9.50% Water-Customer Service 328,754 308,571 (20,183) -6.14% Renewal&Replacement 185,332 823,863 638,530 344.53% Differs from year to year based upon projects Capital Improvements 0 823,717 823,717 100.00% Differs from year to year based upon projects Debt Service 1021199 466,785 364,586 356.74% Other Nonoperating 676,786 (51) (676,837) -100.00% Total Water Fund: 5,389,291 6,707,492 1,318,201 24.46% Fund 402-Refuse&Recycling Refuse and Recycling 600,665 5661P208 (34,457) -5.74% Total Refuse&Recycling: 600,665 566,208 (34,457) -5.74% Fund 403-Stormwater Utility Storm Water Utilities 347,536 380,380 32,843 9.45% Engineering svcs Renewal&Replacement 0 385,151 385,151 100.00% Differs from year to year based upon projects Other Nonoperating 150,046 0 (150,046) -100.00% Total Stormwater Utility: 497,582 765,530 267,948 53.85% Fund 605-Special Law Enforcement Police 921151 130,615 38,464 41.74% Differs from year to year based upon needs Total Special Law Enforcement: 921151 130,615 38,464 41.74% TOTAL EXPENDITURES-ALL FUNDS 25,364,851 27,535,719 21170,869 8.56% NOTES are for differences grater than 10%and amounts over$1,000. Agenda Item #8. THE VILLAGE OF TEQUESTA REVENUE REPORT-CASH BASIS,UNAUDITED FY 2024 FY 2024 100.00% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 9/30/2024 VARIANCE VARIANCE USED NOTES Fund 001-GENERAL FUND General Property Taxes 11,524,090 111524,090 11,524,090 11,7031838 179.1748 1.56% 101.56 Historically,91%receipted by the end of Feb Sales&Use Taxes 1,350,252 1,350,252 1,350,252 1,471,630 121,378 8.99% 108.99 state revs one month behind,above budgeted Franchise fees-gross receipt 530,938 530,938 530,938 536,990 6,052 1.14% 101.14 one month behind,above budgeted Licenses&Permits 9,000 9,000 9,000 8,390 (610) -6.78% 93.22 special events,vacational rental permits Indirect Costs 902,991 902,991 902,991 902,991 0 0.00% 100.00 Grants Federal 25,737 25,737 25,737 221149 (3,588) -13.94% 86.06 Differ from year to year,timing of collection Grants-State 77,000 137/728 1371,728 341193 (103,535) -75.17% 24.83 Differ from year to year,timing of collection Intergovernmental Revenue 9841,222 9841222 9841,222 1,017,016 321P794 3.33% 103.33 Revs one month behind,1/2 c sales tax above budg Grants and Contributions-Local 14,084 14,084 14,084 19,267 5,183 36.80% 136.80 Differ from year to year,timing of collection Chgs for Services-Gen Gov 208,645 208,645 208,645 208,122 (523) -0.25% 99.75 Chgs for Services-Public Safety 11,227,355 1.1227,355 11,227,355 11284,041 56,686 4.62% 104.62 Charges for Services-Recr. 62,500 62,500 62,500 162,643 100,143 160.23% 260.23 Rec program fees increase Fines&Forfeitures 18,275 18,275 18,275 13,965 (4,310) -23.59% 76.41 Code enf fines&fees below budg Unrestricted Investment Earning 280,500 280,500 280,500 545,939 265,439 94.63% 194.63 Active investing,balance and study interest rates Rents&Royalties 188,839 188,839 188,839 210,714 21,875 11.58% 111.58 Recreational rentals above budgeted Impact Fees 8,169 8,169 8,169 121P430 41P261 52.16% 152.16 Differ from yrto yr depending on projects/permits Contributions&Donations 10,000 30,000 30,000 141P762 (15,238) -50.79% 49.21 Differ from year to year events depending Miscellaneous Revenues 13,205 13,205 13,205 27,436 14,231 107.77% 207.77 Differ from year to year Other Financing Sources 8,398 8,398 8,398 57,601 49,203 585.89% 685.89 Disposition of assets(fire truck) Total General Fund 171444,200 17,524,928 17,524,928 18,254,115 729,187 4.16% 104.16 Fund 101-BUILDING FUND Licenses&Permits 608,708 608,708 608,708 679,811 71,103 11.68% 111.68 Varies year to year based upon activity/projects Chgs for Sery-Gen Gov 0 0 0 11783 1,783 100.00% 100.00 Admin fees from other gov Unrestricted Investment Earning 15,000 15,000 15,000 39,898 24,898 165.99% 265.99 Active investing,balance and study interest rates Miscellaneous Revenues 0 0 0 2 2 100.00% 0.00 Appropriate Fund Balance 564,262 612,632 0 0 Total Building Fund 110187,970 11236,340 623,708 721,494 97,786 15.68% 58.36 Fund 301-Capital Improvement Fund Sales&Use Taxes 757,055 757,055 757,055 764,542 71487 0.99% 100.99 state revs two month behind,above budgeted Unrestricted Investment Earn 0 0 0 50,134 50,134 100.00% 100.00 Active investing,balance and study interest rates Other Financing Sources 0 0 0 80,496 80,496 100.00% 100.00 Financed purchase(tasers) Transfers In 15,000 15,000 15,000 0 (15,000) -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: 11253,964 11,253,964 772,055 895,173 123,118 15.95% 71.39 Fund 303-Capital Projects Fund Unrestricted Investment Earning 0 0 0 10,321 10,321 100.00% 100.00 Active investing,balance and study interest rates Grants-State 200,000 200,000 200,000 0 (200,000) -100.00% 0.00 Timing in revenue recording Transfers In 1,884,895 1,884,895 1,884,895 710,000 (1,174,895) -62.33% 37.67 FY 2024 not recorded,timing in recording Total Capital Projects Fund: 2,084,895 2,084,895 2,084,895 720,321 (1,364,574) -65.45% 0.00 Fund 401-Water Fund Grants State 0 0 0 21P456 21456 100.00% 0.00 Differ from year to year,timing of collection Charges for Services 8.12341,600 8,234,600 8,2341600 8,434,319 1991P719 2.43% 102.43 water sales revenue one month behind,higher sales Unrestricted Investment Earn 0 0 0 460,861 460,861 100.00% 100.00 Active investing,balance and study interest rates Miscellaneous Revenues 371,272 371272 371,272 38,052 780 2.09% 102.09 Differ from year to year Other Financing Sources(icl.loan) 8,620,000 8,620,000 8,620,000 214/158 (8,405,842) -97.52% 2.48 Loan is not received in FY 24 Appropriate Fund Balance 21,112.1271 2.11121271 0 0 Total Water Fund: 19,004,143 19,004,143 16,891,872 9,149,846 (7,742,026) -45.83% 48.15 Fund 402-Refuse&Recycling Charges for Services 592,403 592,403 592,403 590,139 (2,264) -0.38% 99.62 Historically,91%receipted by the end of Feb Unrestricted Investment Earn 500 500 500 11,648 11,148 2229.61% 2,329.61 Active investing,balance and study interest rates Appropriate Fund Balance 19,697 19,697 0 0 Total Refuse&Recycling: 612,600 612,600 592,903 601.1787 8,884 1.50% 98.23 Fund 403-Stormwater Utility Grants&Contributions 252,500 252,500 252,500 0 (252,500) -100.00% 0.00 Timing in revenue recording Charges for Services 545,550 545,550 545,550 559,005 13,455 2.47% 102.47 Historically,91%receipted by the end of Feb Unrestricted Investment Earn 500 500 500 12,462 11,962 2392.45% 21492.45 Active investing,balance and study interest rates Miscellaneous Revenues 0 0 0 9,798 9,798 100.00% 100.00 Differ from year to year Appropriate Fund Balance 28,768 28,768 0 Total Stormwater Utility: 827,318 827,318 798,550 5811265 (217,285) -27.21% 70.26 Fund 605-Special Law Enforcement Forfeitures 25,000 25,000 25,000 61,971 36,971 147.89% 247.89 Differ from year to year,timing of collection Unrestricted Investment Earn 1,500 1,500 1,500 11,962 10,462 697.46% 0.00 Active investing,balance and study interest rates Appropriate Fund Balance 138,161 138,161 0 0 0.00 Total Special Law Enforcement 164,661 164,661 26,500 73,933 47,433 178.99% 0.00 TOTAL REVENUES-ALL FUNDS 42,579,751 421,708,849 39,315,411 30,997,934 (8,317,477) -21.16% 72.58 NOTES are for differences grater than 10%and amounts over$1,000. Izi- A3and2 THE VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED FY 2024 FY 2024 100.00 ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 9/30/2024 VARIANCE VARIANCE USED Fund 001-General Fund Council 74,640 74,640 74,640 67,231 7,409 9.93% 90.07(1),(2) Manager 362,368 362,368 362,368 380,656 (18,288) -5.05% 105.05(1),(2) Human Resources 456,599 456,599 456,599 412,348 44,251 9.69% 90.31(1),(2) Village Clerk 4471453 447,453 447.1453 3921484 54,969 12.28% 87.72(1),(2) Finance 807,224 807,224 807,224 768,982 38,242 4.74% 95.26 Legal 195,000 195,000 195,000 192,343 2,657 1.36% 98.64 Comprehensive Planning 495,338 508,808 508,808 3021,253 206,555 40.60% 59.40 General Government 328,215 3291212 329,212 2741,154 55,058 16.72% 83.28 IT 535,503 549,931 549,931 538,439 111493 2.09% 97.91(3) Police Department 3,748,841 3,829,569 3,829,569 3,638,487 191,082 4.99% 95.01(1),(2) Code Compliance 109,261 109,261 109,261 54,308 54,953 50.30% 49.70 Fire Control 4/764/250 5,501,292 5,501,292 5,319,280 182,012 3.31% 96.69 Public Works 1,626,076 1,682,545 1,682,545 1,502,434 180,111 10.70% 89.30 Leisure Services 1,201,176 11210,152 1,210,152 1.1193,507 16,645 1.38% 98.62(3) Debt Service 542,250 542.1250 5421250 558,213 (15,963) -2.94% 102.94(3) Interfund Transfers 11700,008 11,700,008 11700,008 710,000 990,008 58.24% 41.76(3) Allocate to Fund Balance* 49,998 49,998 Total General Fund 17.1444.1200 18,356,310 18,356,310 16.1305,120 2,051,190 11.17% 88.83 Fund 101-BUILDING FUND Building&Zoning 110187,970 1,2371167 1/237/167 1,028,347 208,820 16.88% 83.12(1),(2) Total Building Fund 110187,970 112371P167 1/237/167 1,028,347 208,820 16.88% Fund 301-Capital Improvement Fund General 65,000 65,000 65,000 6,975 58,025 89.27% 10.73 (2),(3) Public Works 210,000 805,782 805,782 752,129 53,653 6.66% 93.34 (2),(3) Parks 175,077 175,077 175,077 169,762 5,315 3.04% 96.96 (2),(3) Tequesta Drive(Bridge) 44,000 44,000 44,000 5,400 38,600 87.73% 12.27 (2),(3) Tequesta Park 250,000 250,000 250,000 0 250,000 100.00% 0.00 (2),(3) Misc Projects 310,000 331,314 331,314 3641221 (32,907) -9.93% 109.93 (2),(3) Interfund Transfers 199,887 199.1887 0 Total Capital Improvement Fund: 1.1253,964 1,871,061 1,871,061 11298,487 572,573 30.60% 69.40 Fund 303-Capital Projects Fund Public Works 710,000 710,000 710,000 374,830 335,170 47.21% 52.79 (2),(3) Leisure Services 110250,000 11250,000 11250,000 359,090 890,910 71.27% 0.00 (2),(3) Allocate to Fund Balance* 124,895 124,895 0.00 Total Capital Projects Fund: 2,084,895 2,084,895 2,084,895 733,920 1,350,975 64.80% 35.20 Fund 401-Water Fund Water-Administration 11711,930 1,832,727 1,832,727 1,566,606 266,121 14.52% 85.48 Water- Production 21280,598 2,305,499 2,305,499 2,003,132 302,366 13.12% 86.88 Water-Distribution 889,331 890,761 890,761 714,869 175,892 19.75% 80.25 Water-Customer Service 320,184 320,184 320,184 308,571 11,613 3.63% 96.37 Renewal&Replacement 3,753,000 41382.1290 4,382,290 823,863 3,558,427 81.20% 18.80 (2) Capital Improvement 9,555,000 11,630,465 11,630,465 823,717 10,806,748 92.92% 0.00(2) Debt Service 4941100 4941100 4941100 466,785 27,315 5.53% 94.47 Other Nonoperating 0 0 0 (51) -100.00% 0.00 Total Water Fund: 19,004,143 21,856,025 21,856,025 6,707,492 15,148,534 69.31% 30.69 Fund 402-Refuse&Recycling Refuse and Recycling 612,600 612,600 612,600 566,208 46,392 7.57% 92.43 (1),(2) Total Refuse&Recycling: 612,600 612,600 612,600 566,208 46,392 7.57% 92.43 Fund 403-Stormwater Utility Storm Water Utilities 373,318 459,261 459,261 380,380 78,881 17.18% 82.82 (1),(2) Renewal&Replacement 454,000 701,196 701.1196 385,151 316,045 45.07% 54.93 (2),(3) Total Stormwater Utility: 827,318 11160.1457 1.1160,457 765,530 394,926 34.03% 65.97 Fund 605-Special Law Enforcement Police 164,661 177,695 177,695 130,615 47,080 26.49% 100.00 (2) Total Special Law Enforcement 164,661 177,695 177,695 130,615 47,080 26.49% 100.00 TOTAL EXPENDITURES-ALL FUNDS 42,579,751 47,356,210 47,356,210 27,535,719 19,820,491 41.85% 58.15 Notes: *Not included in Target Budget calculation (1)Personal expenditures/expenses recorded as when paid not when accrued.Personnel paid 9/26/24 for the period ended 9/21/24. Due to timing of payroll dates 9 days of personnel expenditures not reflected in September 2024. (2)Not all operating expenditures/expenses recorded for the services of September 2024.Expenditures recorded on a cash basis and adjusted to accrual at year end. Page 121 f 512 (3)Timing in expenditures/expenses recording and/or recorded as one time entry at year end. Agenda Item #8. 1 N I N I I I I I I I I I I I N O N O 00 fV N M O N M N tD lD rl N �00 00 qt 00 LO qt M k.D 00 M M � r-I N O lD N � \ +J \ � M N � Ln N M qt � rl rl N N \ M QO N (V Ln O �"� M lO lO rl rl M M �"� N rl N N N N I� (V Ln lO l0 QO R:* QO M � M O M l0 00 N r1 O (V 9t Ln � M � � rl I� I� �.n lO M I� M 00 l0 � O � O rl rl M N N I� M lO M M M M 00 Ln O q;l- N N M N M M rl rl N N M N O O O \ 4-0 \ \ N H N N (*#4 N N N N N 00 M M O 0 M CY) 00 r-I M O N _n �� B O O (V rl (V rl ++ \ I Ln O � LO r-I 00 rl Ol O Ol N N N \ l0 LlO rV O M 00 N r � M r-i N N N N N N s s s c c c cO c O O c 00 O O 01 M M CY) � M a) I N M N In NM N I� O N M M c � O N � O � C a) � O n N }' 4-1' 01 l r rl rl 01 N 4-1N N N rl M rl = i i i V V V i O OC E i M CL v) 4-0 n C bn E L E N o � +� � O � aA � aA LM coQ � s a- c 0 E V �ro 0 V c/f W U 4-1 _0 o CL CL > -a 4-j - - Z oC mQ of512 +6 E � � +� s a O Q > coO O O O > UOU U co w U U U ' Agenda Item #8. rl M N O 00 O N I� 00 lqt lqt M Ln rl ::I- �--� O 1 I� M I rl Ol N NLn O N lD l0 I� O _ N N Ln \ � N N OO N _n 00 N � � MMN MOO 41 \ N rl N N 0 N O N rl M I� 00 I� 00 O M O 00 rl O l� ri ko � rn N m 00 � �o M M N Q1 M M rl O 00 00 00N 00 00 0 rr) 0) rl \ ( O rl O N M 00 (.0N N �••� \ N M O N O ~ O N N rl O OLn � M k.0�n N 0L0 O O I� 00 rl rl 1 1 \ J1 V l M 00 I O � O 00 M O N 00 N 0) � 01 O I� rl Ln M N Ln � Ln � M M � 00 M 00 O � M N or0 C M O ~ O N N l0 M N O M O rl M t t N N M rl Ol _ I� l0 l0 O O 2 M O Q00 M M O M M O N rl 00 O rl i i i i V V Ol O N \ C: � •ca 07 O co > U � •N v\i v) _0 Eb U cn C-0 O � — =3 M Q O a) O U U > cn O +� Ln •� •— ca � O cn \ � > _ L _ L a C: c a) U 0 Ln cz M V _ x > ca cn p LU +� ' bn N O > iz U N pC O O W =3 .� 'gin a� M ai N +5 0 cu Q) u C: _O (D oc — U O ago a) (a W •— Ln E CL U U ci •U •� LLJ> U � w +� Q O a, a, a, •o ` O � °O — o a ; o c" L LO 1� of 512 acz m 010 0 Q (-4 U0 U oC p a- 0- V) LL U.D Agenda Item #8. Ln I'0 O � 00 00 Q0 M N Ln rl 00 M oo O -;t N l0 Ln o0 oo M q M rl rl m 00 O rl 0) N O qt M ::I- N N Ln 00 N N Ln I� l0 Ln rl N Ln M l0 rl rl N rl Ln ry Ln M rl M N I� N 00 O O � � N M I� 00 O q;t q;t r-1 r-1 ri M O Q0 r-I rl Ln q;:I- O Ln M qt 00 rl q::I- dl O1 I� CV M t N Ln rl Ln 01 M CV O Ln rl rl l0 N Ln Ol rl CV Ln rl rl rl Ln l0 \ o N Ln N rl M rl M 00 � O o — � � N O M o) Ln M (o rn L.0 O (10 (.0 M O O Ln rn O Ln ::1- (10 rn � 00 M rl Q0 M CV 110 l0 qzt N N rl Ln M rl rl I� l0 M rl M N I� M rl rl M l0 rl N rl M N l0 rl Ln M rl M rl l0 o N `� 0 0 N M N o O 0 Ln 01 0 M G M rl O N -;t rl o O O O r-I OR::I- MR::I- rl 00 N M 0) rl l0 N 4:1- r-I *, o t Ol ::1- 00 4A (10 o O � o m � ca � LM u a � U V dJ � i LL iz a--; O D v V OV tw O O C: O •Ln O co aA � o o co D V ECA O O Q O � V U = O u — u Q) c E C E E Ca - a--+ co V ca V a'' O fa > +-+ VLn +-' (A c 06 � V a- 0 LL =3 +j cn O +-' — +-+ V' DC V chi) N W �, U � a--' 06 � C� � � (� � cn >` Q Ln Q 0 i.i in U u •O O p O cn Ln O O O ca Ln p O ca ca p p — Q `� co +j V 4A hA V +_+ +_+ Q � _ bp W � � O O O V nO o a— 1z a z LL _ o , a� , Q ` u of 512 a O O Q O O a- w w w LL 0C 2lz�j Agenda Item #8. ,::I- cV r� N N N O p O O O m N O M N � CF) q;t Lr) O O O O 1.0 O O Ln O Ln O O O O +•+ � Lr) +•+ \ lD M � Lr) O O Ln � M Ln N Lr) O M I- r- M lD M O O T-4 r-I O r-1 r-1 r-1 I_f) I_f) � N � rl M 00 N N 00 ~ O F. O N N Ln I� O O r-1 r-1 I:t Ln 0 0 Q0 � O O O Ln Ln O O O O O I� O O I� O Ol t 0) r-1 00 Ln O M � M N Ln 01;* M M d1 I� r-1 I� 00 00 01 I� N rn r-1 cm (.D O M N N O N Ln M N N to4-1 Zj- N `� ro O N N F- N N N I_f) O O O O O cM O N I� I� O O I� O O O O O O O Ln Ln M M � M 01 lD � O rn 00 O O O � O r-I M I� I r-1 � r-1 N N 00 0) r-1 r� M lD M N r-1 N N N r-1 O r-I r-1 N N N L N M � M N N N N r-I O 00 O O O O O O O Ln I� N O O O O O O O O O O s s I'D O M O r-1 O N M Ln O O �••� �+ r-I N r-I N N � r-1 r-I r-I N r-1 O O 2 Ln 2 r-1 i i V V � V O c� i V a •o o }' a V � � V � co M � a cc Co c� E a �' N •� o _0 — x a� 0 U a� Q > O = L O DC w U -- Q `~ _ C: U = - v� aJ cn > p ca O — = O O }' cn +� LL > D cc Cc co � aj o � Q Q x ~ — — _ — cc � V O � � U � U � .� _ cn cn ca ca p > > of 512 cco Q ate = a ca O � .2 M a� >� ca O w O O co L O O co oC v) 0 > O 0 � v � m U.oc oc Agenda Item #8. 1 1 1 O O O O O O 00 O O O O O O O O O O I� O O OLr) O O O Q1 0 0 0 0 0 0 O O 0 0 0 O O O O 0 0 0 0 ♦,,, Ln Ln N N r-1 00 r-1 r-1 N M 00 � N CY)M 0 lD I� O Ln r-1 � M M lD 0 Ln cM Ln O Ln Ln O O O O O O O O O O O O O O O O O r-1 O O O O O O N M I� r-1 N �D r-1 Ln ORzt 0 0 00 M M 0 0 0 O O 0 01�t 0 0 Ln O Ln O r-I 00 r-1 r-1 Ln � N 00 O N I� N 00 r-1 I� l0 � al Ln M r-I N 4-1 O F- O Ln O O O Ln O O O O O O O O O O O O O O O O O Ln O O O O O O O O Ln 00 r-1 Ln I� O O O Ln Ln M O O O 0 0 01�t O O Ln 0 r-I I� Ln M r-1 Ln N 00 Ln N I� Ln I� lD Ln l0 TH TH r-1 r-I r-I O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 0 Ln r-I tw cz 4--+ Q i O O 2 O V N ate-+ \ c6 0 O ca � _ ca a-0 O 0 E +jcn O Q — O v � i N cu N 2 O j ca cn O N �, — N li ca C, Q � cn 2 V 4-J 00 — � � 0%- W �C cn � CIDQ CD � � O U ru (D ruO _ — Q ago V) -0 u � � o >LLJ � `� oc � � cn � � � � oc � > u Ln OLE • a� � O — s W O Q O a) Q) (-a Q) : ca V oC - oC 0 w > cn F-- LL Q N L.L F-- F-- 2 cn —i CO E oC Li 00 Li LU Agenda Item #8. o\° o O N N N N O N 00 00 O M M I� N Ln N to Ln ri l� o M o \ Ln M lO �n rl O E M N M �n Q 4+ \ m 0 0 L m m m rn � o � 00 O N N rl N rl N M Ol I_n o Q O N rl O N N0 C:) N O M N N O N N m M N M � rn (O O M N M N M 0 M Ln N M N 0 o) 0 � \ Ln lO rl l0 O M 00 4-1 \ N N rl 00 O a) Q0 m Ln N 1O M N � I'O � N ri M N m N n rn 00 �n N N 0 M o N @ rj N O N rl N 1:t 3 Sri N Q In M \NN OO 000 0 I I Or � MNLnrl lONO 00 00 M M 00 Q \ of 0 � Ol NN O 00 LnN rl � dl Ln00 N 00 � 00 dl rl Lr) N @ roO G r' O 04-0 t tw lO = O Ln O r °1 M O Ln O 0) m *, +r � 0') N N M I� M M N O O M _ 00 +r M rl rl rl O 00 :1- N 00 lO lO M i V i V Q V O E � L E Je i 0 O au L � w V dJ cr M c .V L Cl) a E U 0 V) (1) ca Ln p '� _0N cn O N - E cn O N ca cr ago a, a, N ca :�, aA +�-+ U L _0fu Q E E = Q cn — — 'L ca ._4-0 CU U- N L Cu cr c- 0 +� V .5 (n (n (% N W M O (.n C6 a) cn ._ i ca DC cn cn cn - cn DC (a _ •� 4-+ U O - 4' � v O 0O N N N O Q C1A Q O = O bA Ln `� ca L 400 o a) L L L _ > i L t27 of 512 O V ii , oC Q V V > O oC 0� O O O O O +J O M > 0L L L L O L (� �..� O � all Ca �..� V a Q O O LL M J cn cn oc a > m cn Agenda Item #8. N � N rN M Ict Ln Ln N O N r-I I� In I� N N N N O II) In 00 M M M rl Ln OM N �n a..� O Q0 QO 00 M � r-I M N Ln rn r, N N �, O N rn M N V- �n M �n 'n 1O Ln Ln N N r-I N r-I O O N � O M Lr) of O O 00 Lr)ca N �n a� M 0000 � N rn M � O � N N `� Ol � � � �D rl �n rl �n Ol N � rl l0 I� 4-J M Ln o0 O I� o0 lD Ol Ln N 00 Ol N M lD r-I O M 00 N N r-I N M M N Ln Ol M Ln �n l0 Ln N � N r-I Ol ~ O 00 N Ln M O O m — O `n m � � 0000 � 00 00 M 0000 Ln M 00 � O o M N � qt � � � (10 O N M �o rn Q0 4-J 110 M rn 00 00 �D �nCN 00 �o �o I� � O N M M �o cy \ O � � M M �o � p Ol � rl rl N N i _0 U Ln N o0 0 00 o m Ln W N N M 00 Ln Ln � Ln M O o M M M r-I N rl Q r-I r-I N r A N M r-I M l0 00 bA a� a� ^ � a V) (3) c _0 O M 0- � a +� O N ) N = V O a--' Q E O 4-j N N bn =3 � a--+ a--+ w0 4-j .U E _ — ate-j O v O p O U (D - bo V U ca .P C c0 � = O � �� E •� U M O O v, — boo > U N +-► p cn , cn cn }, L V N co Ca N N cu cn Ln N Q cn E E U .U `n =3 U U J G� co oC � 0 Ln i a) _0 a) Ln cn cn c +-+ � U ( " Q (A � � 4-JU N `n Ln a) O ' O U O O +-+ — ca cn O O U O — +� +-+ a1 U O i O ca � O — cn +,i Lc6 O U ca bA CO p O O � O N +� Los 0 U UU O O —p a)\= n p\\ � O w m — p 12ca of 512 bA cn p - UN p N c D cn L b10 _aLL U aw c Q O O Q i cn w V Q Q Z U a UL Agenda Item #8. r-1 I I I I;t Ln � Ln Ln N � lD O N I� I� M 00 00 O� M M 00 Q M 00 lD Q N Q M 01 O O1 I� N �O M 00 Lr) � M `� N � Ln Ol Ln z N M z I� z N rl N lD rl N N rl l0 I�N M Ln r-I M °n m O °M m N ono M oMo 00 � QT-j m w Q � Q Ln O M r o0 0 Ln o0 rn ko M M M N M Ln 0) r, z - N z MM z N N �O N s CY) � 00 aA 00 00 N W O N 00 Ln w W Ln s M m � O 00 00 � m �o ,� a m Q Q � � N 0 0�0 O l0 ri rl M to O w 0) � z o � O z Ln z � M M M � cM rl O cV rl M Ln cV Ol � \ cV rl rl � rl 00 N N r-I Ol M 00 Ln Ln r N rl O O � O N ° Q O rl Q Q Q Q Q Q O O O M O M 01 M � � 0 0 O ri O i � � M o - z M M z z z z z z Ln � N N Q r4 r-I L ° — O U Q ca 4 ° U o N ° O cu 4--+ O � + o CU C � L N O O ?� aJ O O _0 Ln (In ate-+ (U a) a) c O U cn J c6 '> N � ,N cr N U LPL N Q o a) MO > v > a0-+ � Q E E '-P C: M s M Un M U - N LL N f0 a.., O }+ ate-+ 0 ate-+ a.:, N L i .� ca cn Q O ca .— a--+ 4 0 O M = UD aJ _M �_ O LL � u 0 — cn C o •— O Q cn C C: >- cn (./) Wbn bn M L .° -W can � -W 0 \ cn U 0 W Ln C: Z7; E E C 0 u cc_ M LU a..+ cnLU M M W 0) a) C: C i L N cn N CUO U X z �c° W° ° Ln 9 Of 512o O o LL o w w — Q � �E c u a X X U X X x LuU O Q U U U CL LLaj O U - - - LU LU LU Agenda Item #8. f6 0O � N 0 N O 4-j u V .. N 00 � to W — U � N M 00 CY) N � O (.0M N M N r-I r-I M N O +.J LL V c6 •U N \ +-+ N te O o . N a..+ — O O .— O N u U O — (B .� un Ln . 0 z V _� — U 4-jQ Q U Q 0 0 Q. } N -0 G .V i L c6 LL ate., i 0 > 41 I� 00 M M I� `� I� I� 00 N cn N Ul O ,0 U N M N Ln N M r� I� 00 I� N OU ul Q QLn Z L O N M \-I a-i DC _ N N O V� V -0ca ci O .� o N oV) CO N U i N M ° E U z M N u M W L N O pC Q 41 co N cn O lD � zt O O l0 0) N 00 Q V N 0 MJ (o 00 N � E z N � i � M r-1 I� r-1 N OO N rN-1 N ca — N Q � N buO un N _ o c� z � � 01 0 O � N °C m 0 H LnO 0 ca C7 cz m O O _ z Oca Q cc c .O O 0 t�A cn C G 00 Ol O � N � c M +-+ I..L — — a� O r-I r-1 M 00 lD O 00 Ln 4-0 +-+ cn W > —W 0 �' _0 = r-I r-I N l0 r-I Vi r-I M ' W M +-� 0 � Q c6 � � Q N V) O ) � � O cc Ln ca a� CO }, V +, ca t�0 �' O U aA E -a c6 C � 1 O s .O c6 a=+ �, cn U cn 0 a- ELLIa� E Q a� •• �' }' a v Q Z +s-+ t�A � ca ca � � _� E c—a _0 ro ro v v � _ - �j L N N 06 0 — O c~lf `� Q `n -0 +J O O S � O O O C6 to •i •L - L H Q . te ON a) OO wU O � Ln L4n ( O � +' V •O : � v o L (n _ 0 U U ca + V U ai a) L— W te o+ O u `) LLJ ru O 7a C: N z O ♦'' 4-0 UE v N cn (0 > C: U U U a� a� Ln Ln o _0 N N a)> M Q aJ 0 Q N c•� N 4-10 Li � 4J cn u — Q) E ^, — L Q 4-J •— w w N N N 4-1 �-+ Ln U b-O O +-) — a� W - -- -- W v cn 0 U ca N N +� — _0 N — = ca •V i bn U v � cn cn V N .U O c0 ca c6 � dJ O � fu V Q cn — cn i O O DC z m N N •— O a--+ t/) — ca 4J cn N L cn �' O = m m U v cn `) O 4� �, t O: � O C — V V = ca — oc v w �, o - M '� 'V � � E CL o }, o O 1 0of512 O cn ca v v O v JO ci o V Q Ln ca cv Q Ou 2 Ou Q cn J w U w > 21 Agenda Item #8. 0 ul N U � m Ln � m nn W 0 N 00 ca V 0 M r N r-I N w rn m N o c a U 0 O k.O cV Ln N Ln Il%%% q::I- O >- r4 00 r-, O Lrn m r� w a U t 4-+ O 2 r%-, 0000 0000 No 4-p � IZ N o6 i i V c6 N ca bu0 _ — c6 ca ca v � — —_ Ca .0 •U Ura i ca N -0 N o N N V o E O a) ° ro E > ca >- O O }; 'x O +-j a Q E o � �, L- o � >. O ca : M +j CT ca (D +� � c6 E ^ j 'E Q 4-, aj E O L (D ^ ca L 0 U o oc2 a) aicn _0 co `a: E +_ oaj E o - N +J p *. E c: v r E -- 0 0 Q) o _0 o 0 v >- Q N Q) M � c 0 Ln r-I � . o E 0 oc o cvi . � .� Page 131 of 512 M 0 ca 0 '=3 0 CL 0 CD 4) 2D .2 (D WX CL a.