Loading...
HomeMy WebLinkAboutDocumentation_Regular_Tab 08_8/8/2024 Agenda Item #8. Regular Council STAFF MEMO Y Meeting: Regular Council - Aug 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 $11.5 million, which represents 100% of the budgeted amount. It is about $2 million (21%) 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 (73%), 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 116%. Insurance premium tax ($307 thousand) to be collected at the year-end as one distribution. Sales/use taxes are slightly above for nine months collections due to utility tax — water and infrastructure surtax collected above budgeted. 4. Intergovernmental revenues (85%) 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 nine months collections due to the half-cent sales tax revenue increase by 16%. 5. Local discretionary infrastructure surtax(77%) - collected at $409 thousand, which represent 77% of the budgeted amount for only eight month's collection/reported period and is above target for eight month's collections by 10%. 6. Revenues (Budgetary comparison) recorded in the General fund represents 95% of budgeted due to the distribution nature of Ad valorem taxes collected at 100%, representing 70% of overall General fund revenues at 7/31/2024. 7. Overall Expenditures (Budgetary comparison) in the General Fund represents 70% of budgeted. Not all the expenditures recorded for the services provided for the month of July 2024 and personnel expenditures recorded as paid not when accrued. Page 32 of 265 Agenda Item #8. 8. Revenues (Prior year comparison) all funds increased by $3.7 million (16%) mainly due to Ad valorem taxes collected $2 million (21%) higher than same period of prior year, increased investment earnings and implementation of a new capital recovery charge in water fund. 9. Expenditures (Prior year comparison) all funds increased by $2.6 million (13%) due to capital improvement, storm water and water projects. 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 Finance Report through July July 2024 Grant Budget Worksheet July 2024 Managers Report.ADA Page 33 of 265 Q ltoti�f am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/8 sracan Period Ending 07/31/2024 DB: Teauesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 612,507.47 Investments 10,780,880.95 Accounts Receivable 1,049,121.22 Due from Other Funds 0.00 Accrued Income Receivable 1,978.14 Inventories 44,778.66 Prepaids 112,445.66 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 12,601,712.10 *** Liabilities *** Accounts Payable (1,632.81) Accrued liabilities 10,349.88 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 1,420.77 Deferred Revenue 812,767.43 Other Current Liabilities 413.55 Customer Deposits 0.00 Noncurrent liabilities 0.00 Total Liabilities 823,318.82 *** 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 3,749,657.70 Ending Fund Balance 11,778,393.28 Total Liabilities And Fund Balance 12,601,712.10 Page 34 of 265 Q ltoti�f am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/8 sracan Period Ending 07/31/2024 DB: Teauesta Fund 101 BUILDING FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 117,974.12 Investments 685,430.36 Accounts Receivable 37.31 Inventories (263.66) Prepaids 3,866.58 Total Assets 807,044.71 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Due to Other Governments 2,626.71 Total Liabilities 2,626.71 *** 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 (259,225.93) Ending Fund Balance 804,418.00 Total Liabilities And Fund Balance 807rO44.71 Page 35 of 265 Q ltoti�f am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/8 sracan Period Ending 07/31/2024 DB: Teauesta Fund 301 CAPITAL IMPROVEMENT FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 81,518.26 Investments 734,680.85 Accounts Receivable 18,409.40 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 834,608.51 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - 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 (4 62,0 64.25) Ending Fund Balance 834,608.51 Total Liabilities And Fund Balance 834,608.51 Page 36 of 265 Q ltoti�f am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/8 sracan Period Ending 07/31/2024 DB: Teauesta Fund 303 CAPITAL PROJECTS FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 24,368.42 Investments 92,919.18 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 117,287.60 *** 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 (145,067.45) Ending Fund Balance 117,287.60 Total Liabilities And Fund Balance 117,287.60 Page 37 of 265 Q ltoti�f am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/8 sracan Period Ending 07/31/2024 DB: Teauesta Fund 401 WATER FUND GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 404,245.41 Investments 10,713,045.62 Accounts Receivable 652,895.96 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Accrued Income Receivable 0.00 Inventories 255,327.33 Prepaids 31,321.50 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 209r631.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 28,794,925.21 *** Liabilities *** Accounts Payable (0.01) Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 303.98 Deferred Revenue 0.00 Current Portion of Debt 431,555.63 Other Current Liabilities 0.00 Customer Deposits 48,875.00 Noncurrent liabilities 1,546,007.99 Other Long Term Liabilities 614,526.23 Def Inflows of Resources 538,011.00 Total Liabilities 3,179,279.82 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 13,995,148.87 Net Assets, Restricted 0.00 Fund Balance - Restricted 406,555.63 Fund Balance - Committed 500,000.00 Fund Balance - Unassigned 8,650,264.75 Total Fund Balance 23,551,969.25 Beginning Fund Balance 23,551,969.25 Net of Revenues VS Expenditures 2,063,676.14 Ending Fund Balance 25,615,645.39 Total Liabilities And Fund Balance 28,794,925.21 Page 38 of 265 Q ltoti�f am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/8 sracan Period Ending 07/31/2024 DB: Teauesta Fund 402 REFUSE & RECYCLING GL Number Description Balance *** Assets *** Cash and Cash Equivalents 11,464.72 Investments 171,815.98 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 183,280.70 *** 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 135,708.33 Ending Fund Balance 183,280.70 Total Liabilities And Fund Balance 183,280.70 Page 39 of 265 Q ltoti�f am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/8 sracan Period Ending 07/31/2024 DB: Teauesta Fund 403 STORMWATER UTILITY GL Number Description Balance *** Assets *** Cash and Cash Equivalents 115,713.61 Investments 36,384.30 Accounts Receivable 1,685.60 Due from Other Funds 0.00 Inventories 52.00 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,428,470.20 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 0.00 Current Portion of Debt 0.00 Other Long Term Liabilities 42,744.70 Def Inflows of Resources 13,630.00 Total Liabilities 56,374.70 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 2,031,685.06 Fund Balance - Unassigned 480F853.59 Total Fund Balance 2,512,538.65 Beginning Fund Balance 2,512,538.65 Net of Revenues VS Expenditures (140,443.15) Ending Fund Balance 2,372,095.50 Total Liabilities And Fund Balance 2,428,470.20 Page 40 of 265 Q ltoti�f am BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 8/8 sracan Period Ending 07/31/2024 DB: Teauesta Fund 605 SPECIAL LAW ENFORCEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 62,656.50 Investments 220r536.19 Accounts Receivable 217.65 Inventories 0.00 Prepaids 0.00 Total Assets 283,410.34 *** 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 (31,987.24) Ending Fund Balance 283,410.34 Total Liabilities And Fund Balance 283,410.34 Page 41 of 265 Agenda Item #8. VILLAGE OF TEQUESTA Cash & Investments Unadjusted Unaudited 7/31/2024 Cash and cash equivalents Investments Total General Fund#001 $ 6125507 $ 10578001. $ 115393,388 Building Fund#101 117X4 685,430 803,404 Capital Improvement Fund#301 81,518 73401 816,199 Capital Projects Fund#303 24,368 92,919 117,288 Water Utility#401 404,245 105713 M46 11)117,291 Refuse &Recycling#402 115465 171,816 183,281 Stormwater#403 1151714 36,384 152M98 Special Law Enforcement#605 62,657 220,536 283 J 93 Total Cash and Investments $ 194309449 $ 239435,693 $ 249866,142 *Interfund transfer pending Page 42 of 265 VILLAGE OF TEQUESTA Agenda Item #8. REVENUE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 7/31/2023 7/31/2024 VARIANCE %VARIANCE NOTES REVENUES Fund 001-GENERAL FUND General Property Taxes 9,533,479 11,556,999 2,023,520 21.23% Increase from Seaglass,sales,&3%Homestead properties Sales&Use Taxes 11453,304 874,945 (578,358) -39.80% Infrastructure&Utility tax recorded in fund#301 in FY24 Franchise fees-gross receipt 427,666 427,069 (597) -0.14% Licenses&Permits 61110 41430 (1,680) -27.50% Rental permits Grants-Federal 49,047 211460 (27,587) -56.25% Differs from year to year Grants-State 121,489 241144 11,655 93.33% Differs from year to year Intergovernmental Revenue 836,949 839,294 2,346 0.28% Chgs for Services-Gen Gov 173,053 1741298 11244 0.72% Land development fees based on the projects Indirect Costs 719,228 7521492 33,264 4.62% Rents&Royalties 235,988 197,598 (38,390) -16.27% Sprint lease terminated Contributions&Donations 14,984 9,055 (5,929) -39.57% Differs from year to year,timing in recording Miscellaneous Revenues 271245 26,560 (685) -2.51% Differs from year to year Chgs for Services-Public Safety 8831317 966,010 82,693 9.36% Fines&Forfeitures 9,629 121293 2,663 27.66% Code enforcement fees Impact Fees 11764 12,005 10,240 580.43% 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 93,581 141,802 48,221 51.53% Recreation programs fees increase Unrestricted Investment Earning 335,514 452,863 117,349 34.98% Active investing,balance and study interest rates Other Financing Sources 42,963 57,601 14,638 34.07% Disposition of assets(fire truck) Total General Fund 14,864,984 16,570,185 1,705,200 11.47% Fund 101-BUILDING FUND Licenses&Permits 6521462 573,011 (79,451) -12.18% Varies year to year based upon activity/projects Charges for Services 1,909 11783 (126) -6.60% Miscellaneous Revenues 0 2 2 100.00% Unrestricted Investment Earning 241117 32,500 8,384 34.76% Active investing,balance and study interest rates Total Building Fund 678,488 6071296 (71,192) -10.49% Fund 301-Capital Improvement Fund Sales&Use Taxes 0 6141218 6141,218 100.00% Infrastructure surtax and water utility tax Unrestricted Investment Earning 221705 421737 20,032 88.23% Active investing,balance and study interest rates Total Capital Improvement Fund 221705 656,955 6341250 100.00% Fund 303-Capital Projects Fund Unrestricted Investment Earning 646 8,759 8,113 1255.83% Active investing,balance and study interest rates Total Capital Projects Fund: 646 8,759 8,113 100.00% Fund 401-Water Fund Miscellaneous Revenues 36,052 38,039 1,987 5.51% Grants-State 0 21456 21456 100.00% Fines&Forfeitures 11250 0 (1,250) -100.00% Local ordinance violations Unrestricted Investment Earning 202,364 370,919 168,555 83.29% Active investing,balance and study interest rates Other Financing Sources 143,017 156,455 13,438 9.40% Capital connect charge based on the projects Charges for Services 5,593,158 6,904,744 1,311,586 23.45% New Capital Recovery charge implemented in FY 2024 Total Water Fund: 5,975,841 71472,614 1,496,772 25.05% Fund 402-Refuse&Recycling Unrestricted Investment Earning 21166 9,538 7,371 340.27% Active investing,balance and study interest rates Charges for Services 569,389 590,139 20,750 3.64% Total Refuse&Recycling: 571,555 599,676 28,121 4.92% Fund 403-Stormwater Utility Miscellaneous Revenues 0 9,798 9,797 100.00% Constraction damadge reimb Grants and Contributions-Local 14,385 0 (14,385) -100.00% Differ from year to year Unrestricted Investment Earning 1,367 10,680 9,313 681.22% Active investing,balance and study interest rates Other Financing Sources 7,375 0 (7,375) -100.00% Disposition of assets Charges for Services 512,517 546,003 33,486 6.53% Total Stormwater Utility: 535,644 566,481 30,836 5.76% Fund 605-Special Law Enforcement Forfeitures 194,548 43,432 (151,117) -77.68% Differ from year to year Unrestricted Investment Earning 3,950 9,238 5,289 133.90% Active investing,balance and study interest rates Total Special Law Enforcement 198,498 52,670 (145,828) -73.47% TOTAL REVENUES-ALL FUNDS 22,848,362 26,534,635 3,686,273 16.13% NOTES are for differences grater than 10%and amounts over$1,000. Page 43 of 265 Agenda Item #8. VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED YTD BALANCE YTD BALANCE DESCRIPTION 7/31/2023 7/31/2024 VARIANCE VARIANCE NOTES EXPENDITURES Fund 001-GENERAL FUND Council 44,359 59,464 15,105 34.05% Computer system maint&supplies Manager 253,274 311,715 58,440 23.07% Wages,sick leave buy back-retirement,insurance Human Resources 313,256 341,605 28,349 9.05% Wages,sick leave buy back,employee recogn,recruit Village Clerk 312,032 3261668 14,636 4.69% Finance 600,836 636,316 35,480 5.91% Wages,ClearGov software subscription$24K Legal 1371441 161,168 23,727 17.26% Differs from year to year based upon service needs Comprehensive Planning 2111186 238,141 26,955 12.76% Full time hire General Government 190,621 247.1719 57,099 29.95% Other contractual svcs and insurance increase IT 395,907 461,163 65,257 16.48% Wages,computer system maint&supply,contr svcs Police Department 2,849,394 2,905,399 56,005 1.97% Code Compliance 641783 37,037 (27,747) -42.83% Vacancies Fire Control 41486,965 41296,861 (190,104) -4.24% More expensive Ladder Truck purchase in FY 2023 Public Works 11210,639 112341171 23,532 1.94% Leisure Services 9121267 1,029,932 117,665 12.90% P/T salaries,ins,program fees and misc park projects Debt Service 582,306 533,168 (49,138) -8.44% Pumper financed purchase paid in full Total General Fund 12,565,266 12,820,527 255,261 2.03% Fund 101-BUILDING FUND Building Department 717,634 866.1522 148,888 20.75% Wages,comp abs,ins,insp&other contr svcs,mgmt fees Total Building Fund 717,634 866,522 148,888 20.75% Fund 301-Capital Improvement Fund General 0 6,975 6,975 100.00% Projects varies year to year Public Works 421745 676.1641 633,896 1482.98% 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 208,456 260,241 511785 24.84% Projects varies year to year Total Capital Improvement Fund: 251,201 11119,019 867,818 100.00% Fund 303-Capital Projects Fund Public Works 56,211 2,296 (53,915) -95.91% Projects varies year to year Parks 8,000 151,531 143,531 100.00% Projects varies year to year-Remembrance Park Total Capital Projects Fund: 641211 153,827 89,616 100.00% Fund 401-Water Fund Water-Administration 11126,707 1,351,770 225,063 19.98% Insurance,engineering svcs,comp system maint,mgmt fees Water- Production 11704,226 1,641,863 (62,364) -3.66% Water-Distribution 641,093 5861218 (54,875) -8.56% Water-Customer Service 246,902 251,660 4,758 1.93% Renewal&Replacement 520,214 642.8132 121,918 23.44% Differs from year to year based upon projects Capital Improvements 17,073 547,685 530,612 100.00% Differs from year to year based upon projects Debt Service 386,314 387,661 1,347 0.35% Other Nonoperating 0 (51) (51) -100.00% Total Water Fund: 4,642,530 5,408,937 766,408 16.51% Fund 402-Refuse&Recycling Refuse and Recycling 451,351 4631F968 12,617 2.80% Total Refuse&Recycling: 451,351 463,968 12,617 2.80% Fund 403-Stormwater Utility Storm Water Utilities 266,364 3211773 55,410 20.80% Engineering svcs Renewal&Replacement 27,302 385,151 357,849 1310.70% Differs from year to year based upon projects Total Stormwater Utility: 293,666 706,924 413,258 140.72% Fund 605-Special Law Enforcement Police 78,739 84,657 5,918 7.52% Differs from year to year based upon needs Total Special Law Enforcement: 78,739 84,657 5,918 7.52% TOTAL EXPENDITURES-ALL FUNDS 19,064,597 21,624,381 2,559,784 13.43% NOTES are for differences grater than 10%and amounts over$1,000. Page 44 of 265 Agenda Item #8. THE VILLAGE OF TEQUESTA REVENUE REPORT-CASH BASIS,UNAUDITED FY 2024 FY 2024 83.33% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 7/31/2024 VARIANCE VARIANCE USED NOTES Fund 001-GENERAL FUND General Property Taxes 11,524,090 111524,090 91,603,408 115561999 11953,591 20.34% 100.29 Historically,91%receipted by the end of Feb State revs one month behind,record-cash basis,ins prem Sales&Use Taxes 1,350,252 1,350,252 110125,210 874,945 (250,265) -22.24% 64.80 tax received as one distrib at FYE($307K) Franchise fees-gross receipt 530,938 530,938 4421448 427,069 (15,380) -3.48% 80.44 one month behind Licenses&Permits 9,000 9,000 7,500 41P430 (3,070) -40.93% 49.22 Special events,vacational rental permits Indirect Costs 902,991 902,991 7521493 7521492 0 0.00% 83.33 Grants Federal 25,737 25,737 21,448 211460 12 0.06% 83.38 Differ from year to year,timing of collection Grants-State 77,000 137/728 1141,773 24,144 (90,629) -78.96% 17.53 Differ from year to year,timing of collection Intergovernmental Revenue 9841,222 9841222 820,185 839,294 19,109 2.33% 85.27 Revs one month behind,1/2 c sales tax above budg Grants and Contributions-Local 14,084 14,084 11,737 19,267 7,530 64.16% 136.80 Differ from year to year,timing of collection Chgs for Services-Gen Gov 208,645 208,645 173,871 1741298 427 0.25% 83.54 Chgs for Services-Public Safety 11,227,355 1.1227,355 1,022,796 966,010 (56,786) 78.71 Charges for Services-Recr. 62,500 62,500 52,083 141,802 89,719 172.26% 226.88 Rec program fees increase Fines&Forfeitures 18,275 18,275 15,229 121293 (2,937) -19.28% 67.26 Code enf fines&fees below budg Unrestricted Investment Earning 280,500 280,500 233,750 452,863 219,113 93.74% 161.45 Active investing,balance and study interest rates Rents&Royalties 188,839 188,839 157,366 197,598 40,232 25.57% 104.64 Timing in revenue recording Impact Fees 8,169 8,169 6,808 12,005 5,197 76.34% 146.95 Differ from yrto yr depending on projects/permits Contributions&Donations 10,000 30,000 25,000 9,055 (15,945) -63.78% 30.18 Differ from year to year events depending Miscellaneous Revenues 131,205 13,205 11,004 26,560 15,555 141.36% 201.13 Differ from year to year Other Financing Sources 8,398 8,398 6,998 57,601 50,602 723.06% 685.89 Disposition of assets(fire truck) Total General Fund 171444,200 17,524,928 14,604,107 16,570,185 1,966,078 13.46% 94.55 Fund 101-BUILDING FUND Licenses&Permits 608,708 608,708 507.1257 573,011 65,754 12.96% 94.14 Varies year to year based upon activity/projects Chgs for Sery-Gen Gov 0 0 0 11783 1,783 100.00% 100.00 Unrestricted Investment Earning 15,000 15,000 12,500 32,500 20,000 160.00% 216.67 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 519,757 607,296 87,539 16.84% 49.12 Fund 301-Capital Improvement Fund Sales&Use Taxes 757,055 757,055 630,879 614.1218 (16,661) -2.64% 81.13 State revs two month behind,above budgeted Unrestricted Investment Earn 0 0 0 421737 421P737 100.00% 100.00 Active investing,balance and study interest rates Transfers In 15,000 15,000 12,500 0 (12,500) -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 643,379 656,955 13,576 2.11% 52.39 Fund 303-Capital Projects Fund Unrestricted Investment Earning 0 0 0 8,759 8,759 100.00% 100.00 Active investing,balance and study interest rates Grants-State 200,000 200,000 166,667 0 (166,667) -100.00% 0.00 Timing in revenue recording Transfers In 1,884,895 1,884,895 1,570,746 0 (1,570,746) -100.00% 0.00 FY 2024 not recorded,tfrs recorded at year end Total Capital Projects Fund: 2,084,895 2,084,895 110737,413 8,759 (1,728,653) -99.50% 0.00 Fund 401-Water Fund Grants State 0 0 0 21P456 21P456 100.00% 0.00 Differ from year to year,timing of collection Charges for Services 8.12341,600 8,234,600 6.18621167 6,904,744 421P577 0.62% 83.85 water sales revenue one month behind,higher sales Unrestricted Investment Earn 0 0 0 370,919 370,919 100.00% 100.00 Active investing,balance and study interest rates Miscellaneous Revenues 371,272 37,272 31,060 38,039 6,979 22.47% 102.06 Differ from year to year Other Financing Sources(icl.loan) 8,620,000 8,620,000 71183,333 156,455 (7,026,878) -97.82% 1.82 Loan proceeds,recorded when received Appropriate Fund Balance 21112,271 21,1121271 0 0 Total Water Fund: 19,004,143 19,004,143 14,076,560 71472,614 (6,603,946) -46.91% 39.32 Fund 402-Refuse&Recycling Charges for Services 592,403 592,403 493,669 590,139 96,469 19.54% 99.62 Historically,91%receipted by the end of Feb Unrestricted Investment Earn 500 500 417 9,538 9,121 2189.02% 1,907.52 Active investing,balance and study interest rates Appropriate Fund Balance 19,697 19,697 0 0 Total Refuse&Recycling: 612,600 612,600 494,086 599,676 105,590 21.37% 97.89 Fund 403-Stormwater Utility Grants&Contributions 252,500 252,500 2101417 0 (210,417) -100.00% 0.00 Timing in revenue recording Charges for Services 545,550 545,550 454,625 546,003 91,378 20.10% 100.08 Historically,91%receipted by the end of Feb Unrestricted Investment Earn 500 500 417 10,680 10,263 2463.17% 21135.97 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 665,458 566,481 (98,978) 68.47 Fund 605-Special Law Enforcement Forfeitures 25,000 25,000 20,833 43,432 22,598 108.47% 173.73 Differ from year to year,timing of collection Unrestricted Investment Earn 1,500 1,500 1,250 9,238 7,988 639.07% 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 22,083 52,670 30,587 138.51% 0.00 TOTAL REVENUES-ALL FUNDS 42,579,751 421-708,849 32,762,843 26,534,635 (6,228,207) -19.01% 62.13 NOTES are for differences grater than 10%and amounts over$1,000. A3and2 THE VILLAGE OF TEQUESTA EXPENDITURE REPORT-CASH BASIS,UNAUDITED FY 2024 FY 2024 83.33% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 7/31/2024 VARIANCE VARIANCE USED Fund 001-General Fund Council 74,640 74,640 62,200 59,464 2,736 4.40% 79.67(1),(2) Manager 362,368 362,368 301,973 311,715 (9,741) -3.23% 86.02(1),(2) Human Resources 456,599 456,599 380,499 341,605 38,894 10.22% 74.82 Village Clerk 4471453 447,453 372,878 326,668 46,209 12.39% 73.01 Finance 807,224 807,224 672,687 636,316 36,371 5.41% 78.83 Legal 195,000 195,000 162,500 1611168 1,333 0.82% 82.65 Comprehensive Planning 495,338 508,808 424,007 238,141 185,865 43.84% 46.80 General Government 328,215 3291212 274,343 2471,719 26,624 9.70% 75.25 IT 535,503 549,931 458,276 461.1163 (2,887) -0.63% 83.86(3) Police Department 3,748,841 3,829,569 3,191,308 2,905,399 285,908 8.96% 75.87(1),(2) Code Compliance 109,261 109,261 91,051 37,037 54,014 59.32% 33.90 Fire Control 4/764/250 5,501,292 4,584,410 41,296,861 287,549 6.27% 78.11 Public Works 1,626,076 1,682,545 1/402/121 1.1234,171 167,950 11.98% 73.35 Leisure Services 1,201,176 11210,152 1,008,460 1,029,932 (21,472) -2.13% 85.11(3) Debt Service 542,250 542.1250 451,875 533,168 (81,293) -17.99% 98.33(3) Interfund Transfers 11700,008 11,700,008 11416,673 0 11416,673 100.00% 0.00(3) Allocate to Fund Balance* 49,998 49,998 Total General Fund 17.1444.1200 18,356,310 15,296,925 12,820,527 21476,398 16.19% 69.84 Fund 101-BUILDING FUND Building&Zoning 110187,970 1,237,167 1,030,973 866,522 1641451 15.95% 70.04(1),(2) Total Building Fund 110187,970 112371P167 1,030,973 866,522 164,451 15.95% Fund 301-Capital Improvement Fund General 65,000 65,000 541167 6,975 471192 87.12% 10.73 (2),(3) Public Works 210,000 805,782 6711485 676,641 (5,156) -0.77% 83.97 (2),(3) Parks 175,077 175,077 145,898 169,762 (23,864) -16.36% 96.96 (2),(3) Tequesta Drive(Bridge) 44,000 44,000 36,667 5,400 31,267 85.27% 12.27 (2),(3) Tequesta Park 250,000 250,000 208,333 0 208,333 100.00% 0.00 (2),(3) Misc Projects 310,000 331,314 276,095 260,241 15,854 5.74% 78.55 (2),(3) Interfund Transfers 199,887 199,887 0 Total Capital Improvement Fund: 1.1253,964 1,871,061 1,559,217 11119,019 440,198 28.23% 59.81 Fund 303-Capital Projects Fund Public Works 710,000 710,000 591,667 21,296 589,370 99.61% 0.32 (2),(3) Leisure Services 110250,000 11250,000 1,041,667 151,531 890,136 85.45% 0.00 (2),(3) Allocate to Fund Balance* 124,895 124,895 0.00 Total Capital Projects Fund: 2,084,895 2,084,895 1/737/413 153,827 1,583,586 91.15% 7.38 Fund 401-Water Fund Water-Administration 11711,930 1,832,727 1,527,273 1,351,770 175,503 11.49% 73.76 Water- Production 21280,598 2,305,499 1,921,249 1,641,863 279,386 14.54% 71.22 Water-Distribution 889,331 890,761 742,301 586,218 156,083 21.03% 65.81 Water-Customer Service 320,184 320,184 266,820 251,660 15,160 5.68% 78.60 Renewal&Replacement 3,753,000 41382,290 3,651,908 6421132 3,009,776 82.42% 14.65 (2) Capital Improvement 9,555,000 11,630,465 9,692,054 547,685 9,144,369 94.35% 0.00(2) Debt Service 4941100 4941100 4111750 387,661 24,089 5.85% 78.46 Other Nonoperating 0 0 0 (51) -100.00% 0.00 Total Water Fund: 19,004,143 21,856,025 18,213,355 5,408,938 12,8041417 70.30% 24.75 Fund 402-Refuse&Recycling Refuse and Recycling 612,600 612,600 510,500 463,968 46,532 9.12% 75.74 (1),(2) Total Refuse&Recycling: 612,600 612,600 510,500 463,968 46,532 9.12% 75.74 Fund 403-Stormwater Utility Storm Water Utilities 373,318 459,261 382,718 3211773 60,944 15.92% 70.06 (1),(2) Renewal&Replacement 454,000 701,196 584.1330 385,151 199,179 34.09% 54.93 (2),(3) Total Stormwater Utility: 827,318 11160,457 967,047 706,924 260,123 26.90% 60.92 Fund 605-Special Law Enforcement Police 164,661 177,695 148,079 84,657 63,422 42.83% 100.00 (2) Total Special Law Enforcement 164,661 177,695 148,079 84,657 63,422 42.83% 100.00 TOTAL EXPENDITURES-ALL FUNDS 42,579,751 47,356,210 39,463,508 21,624,382 17,839,127 45.20% 45.66 Notes: *Not included in Target Budget calculation (1)Personal expenditures/expenses recorded as when paid not when accrued.Personnel paid 7/18/24 for the period ended 7/13/24. Due to timing of payroll dates 18 days of personnel expenditures not reflected in July 2024. (2)Not all operating expenditures/expenses recorded for the services of Jul 2024.Expenditures recorded on a cash basis and adjusted to accrual at year end. Page 46 f 265 (3)Timing in expenditures/expenses recording and/or recorded as one time entry at year end. CL .2 4) CD 0 .2 IL a. Agenda Item #8. N N N O N O 00 N (V M O N N Q0 l0 rl (V 00 00 � 00 L �0) (1O 00 M M � r-1 N O l0 N I� \ �+ \ O I� � � � M � (V I� Ln N M � � rl rl N N \ 01 lD N V Lr) Lr)O �"� M l0 l0 rl rl M Ol �"� N r-1 N (N N N N I� N Ln W W W W M M O M W 00 N rl O N � Lr) I;t M � r-1 r-1 r-1 I� I� Lr) w Lr) I� Lr) 00 l0 I;t O � O rl rl M N CV I� M w M O M M M 00 un O qt N N M N M M rl rl r-1 N N r-1 M N N N N N N N N � N N O H N N N N N N w O � O 00 O w w 00 N N rl w N O \ \ QD Lr) 01 00 � LO O O � � O N � W 00 N 00 M NNM O Lr)M M 01 00 r-1 w N r-1 00 rl N M r-1 rl M O O O O H I� 00 O w N W CV W r-1 O O r-1 M I� r-1 -�t 00 r-1 rl O (V rl O t t N N O O N O rl M t }+ }+ rl rl M rl rl }+ c c c c c c O O O G �n M rl O O i i i V V V N i O CL c a) Ln E E Ln EM A-i_ Ln �, Ln a� i o ++-j ago EL }O =3 N — �_ O N ca cu J _ a�> a) a) fu= — tvo O a v o +-J u o a, -0 O C: cn O O 0 O a) Q D aJ NLL U �' O O O i > v cn cn Ln �� �� Q a) 0 DC U �' a� O O Q L Q p ca � a� a� c6 in +� L DC +� cn Q }' a1 — pC U U O cn O O > cn cn 01 W c cn O U � .p .2 -a ]�-+ " Q I W cn DC U [a cn ' W L o L Q CO �, Li e of 265 cu+ 'cn E oC 'cn E cu �C U L p U E U L aA p 2 Q Q 4-► o a, o — (V O O � L ca a) > O w a, aU LL U a- O O o 0 � Z oC U � = U m V O w U oC 0- = LLm U Z oC — U U Agenda Item #8. � 00 � N O N r-I W N r-I M N O 0 O N I� n l000 N 00 � � Ol �n rl 00 O �--� 000 0 O � M N N NO l0 1,0 I� 00 N N I;t \ ' ' a-+ \ rl N N I N O N M w Q0 rl w O N M 00 M lD N Q0 M O 00 � 10 k D 1�t O M O M Ln N r- d1 N M 00 I� l0 I� N M rl rl N M N dl M M rl O rl rl M O LA O \ 4-J \ N N O ~ O N N rl � I;t O rn � O m 00 M N � Ln fV 00 (3) ri O O Ln M l0 m (.0 cv I'o �D rl (.0 Ln M o) O 00 N M I;t O N O M Ln M � M 4-J M N 0 N N N S 1�t Ln (N O fV � O rl rl Ln O q;t 000 M N Ln l0 M M M Ln l0 N l0 M rl N N N 4-+ 4-+ 00 I� I� rl _ c O O ,::1- O O N i i V V \ can cu =3 =3 O U cr U � \ L C ca U +.+ UO CO N = 0 = ca O Ln N .v i Z) M 0 l0 O N E U . Ln cn ate-+ > v U Q ._ N �� N cn � cn fc� LL .— cu a-+ L N LU N tea- E � m E+ > Ul UCD � ( O QLL CA � 0 Cl) 0cn +, O O , v \ \ c Q — — N m c ( to L 0 Ln 0 > 0 E 0 :E 4-J 4-) � — x O M a� E 2 — a� O _ ;� Q cc w 4 of 265 U U 2 2 -1 m 0 0 0 Q N M O U Q 0- 0- V i..L OU i..� Agenda Item #8. O � o0 00 Q0 M N Ln 00 m w O -;t N i0 m w 00 M -;t m � r--j m -;t N rl M N O ::1- M 1;T N N Ln 00 N N In I\ l0 Ln rl N Ln M l0 rl rl N rl Ln N Ln M rl M N I\1 11� N 00N O � 0-0 O N 00 O R::I- 1;T ri rl M -;t \ rl O (.O rl rl Ln O In M 00 rl Ql 01 M R::I- M R::I- N M rl Ln O) M N O Ln rl rl 1,0 N Ln a) rl N Ln rl rl Ln l0 o M Ln N rl M rl M v N 00 a O o _ O o N V o ~ O (*#4 00 rl M rl M O I\ q::I- 1.0 O 9,0 I\ M N 00 M N rl M M lO M I_f) M rl I� q* In rl 00 rl q::I- O r-I r-1 r\ Ln N rl O r-I 01 N rl rl M N rl rl N rl In rl o Ln N N rl Ln rn N 0 p m N � M N o O �' N rl m I\ O l0 O I� I� M O O QO O CV O rl N N O M M rl I;t O M 00 rl O rl M CV *, O t r-1 rl M rl � 4 dl NO o r O 0 m 4-0 ca � 4-0 4-0 V � Q V U N O cu E +j •Ln � � 40A ca � a� O ca z E Ln O C: \ ,C O 00 Ln Ln Ln O O O +_' Ln cu a Ln U fun (n cn � N w � � N v � V) H L.L toco E U •— N a) =$ 0� O O +� p w Ln N =3 cn � `n U �A aA U O O Q _ � � E o°0 4-0 ° ° o a ° o8 � o 4 QzQzocw _ v � � � 'Q � �° -0 ° moo .� Q i o _u o -F Of265 3 > 4- cu w w w O M O W a O 0 Q — 0 0 M w w w � w w 0- oC I 2 Z cn Q Agenda Item #8. N N O N O � O O O M N O M N � O) � �n O O O O � O O Ln O �n O O O O O � \ L a-+ r) 4-+ \ 1.0 M I� L n O O Ln � m L n N L n O M I� I� M QO M O L n L n O r-I O �"� � r-I Ln Ln � N - rl M 00 N N 00 ~ O ~ O N N I� O O rI rl R:t Ln 0 C to q* O O O Ln Ln O O O O O Ln M I� O O I� O Ol qzt dl rl 00 Ln O M � M N Ln O q;T Ln � M M Ol � r-I � r-I 00 00 O) � N a) rl M lD O M N N O N In M N N Q0 N � O N N F- Cy N O N N 01 O O O O O M O Rzi- O I;t O O M O O O O O O O O Ln O Ln M M 00 M � O Ln O N 00 Ln O O � O Ln (�D rl (3) N N lD M Ol NM N N N � N M M M N � N N N O O O O O O O O rl O +�.+ rl O O O O O O O O O O O O t t M Ln O M O 00 O Ln Ln N rl 1�t N rl rl N rl M rl cO ccO � G Ln G N i i V � � O ca v OTC M O � V u .O ca M a� M oc to cu � X O _0 — � }, U w Q ca a �° o o a U — aA ro O = — ca — O O te-+ Q p = Q — U U O -0 O O O a O U _ c./) c./) > v LL > Z +-+ cn Q a-J cD �C LU c� can tip i � ro iz U cn O ca 0 — � ca cr3 ca ca co — 0 Ln Q a-5 +, U c� t o — a-J cn \ � a-J -C -C U •r 'ca ca � c./) > CO a� U of 265 �v z• a O ca O xaj 0- > L O w O O M o o M - U 2 a oC 0 U GC � > cn O > � 1 V O 0 U V V m U t0C oC 0- oC Agenda Item #8. to N O Ln 0 0 0 0 O O O O O O O 0 0 O O O O 0 0 N O N �n O Ln O m O O O O O O O O O O O O a-+ \ �n N N r-I 00 r-I r-I N � M 00 � MCY) 0 0 Lnlfl I� � O N M m m �o N r- N N Ln 0 Ln Ln O O O O O O O O O O O O O O O r-I O O O O O O N r i N lD r-I Ln 0 � O O 00 Ln M O O O O O O � O O Ln 0 Ln 0 r-I r-1 00 rl r- q* Ln � 00 O N � N 00 I rl I� ID � `� a) m m r-1 r-1 r- N N O O O Ln O O O O O O O O O O O O O O O Ln O O O O O O O O r-I In I� O O O In M O O O O O ;1- O 0 Ln 0 m Ln Ln 00 Ln N � Ln � � Ln Mr-I r-I r-I r-I N r-I N M N � N N Ln Ln O N N O O O O O O O O O O O 0 00 O O O O O O O O O O O O O O 0 Ln Ln Qo as-+ r-I � O E O o0 00 M i i 3 V tU0 ca �' +� E Q 0 M E U ca e •`n t�0 V O U +�-' O O cn — — a 4-0 Ln p cn Ur > }, 'Vf +� �, cn > — '—cn O N +� �' � v� 2 � � ca DC — � � 0- w cn � � Q � � •L Q •> O O = w > 0 ca L7 O — c/) M C: -Fa -,-- E M: +-p M cn cn cn > > Q0 co cn — cn cn >- DC Ln O cn p U cn C37O Q > Q N 0- O O O D- � �_ 0 _ V O O a) O Q O (u a� O ca w •� ca ca O �'7 oC oC w Li- cn N 2 Ln co E = UL m UL wI V Agenda Item #8. 00 N � N N NO � 00 00 O M M � (V u Ln (� N l0 Ln r-I l� Ln r14 O M O N l0 � r-I O M N M I_f) Q 0 0 m ON to r, � Ln M M M M 00 O� r Ol � Q0 N N M o) Ln 0 0 0 N ~ O M N O 00 In l0 N rl ro l0 � O � M 00 � \ fV N rl 000 O M M M (V Col Ol O In M � O rl Ln CN M N l0 0 N rl M (N M N I� Ol 00 I_f) N� 00 Ol ~ O N g o 0 f6 N N O N 3 l0 00 O rl I� O u N O O Ln rl M N I� M rl O M N ° O � O N 00 M rl rl M 00 4-J \ M rl O rl M � w rl 01 - a) \ o 0 M M rl 00 � I� � l0 N I� � M � � � � � l0 N �n � N `� M 0 �' O 0 rn N � O 4-0 dA �,O = Ln O O 00 l0 N �N-1 a) Ln 0 0 00 m 0 00 N N M N � M _ 0 Q M � � O O 00 N M I 00 w q* w M O r, rn M LM 4-J i Q � 4-0 O E C O U E Qcr •� U •> bn O o � _ +J — a� +, p N ca N — c� c0 _0 _0 a� a� � ° c� � � •� _� � Q i Q N cn ate-+ O � N N > Q O •— •— �, pC c w 4A O O — •� O U L L � 0 cn _ O V) •5 (A cn c! 0 w i O 5 DC � cn cn cnru cn DC 'c6 '� 0 Ln 0 (1) .- a) --.e :Paoi43 of 265 -W Q v v O O O O O O C ca +� r�o -0p ° 0. Q O O 0- 0- 0- UL 0- J Zn cn tY b > M cn Ln cn Agenda Item #8. N O N � N ca N Ln w nMn M M r l Ln O Ln N M I� Ln � N N O � � Ln r-I r-1 l0 M r-1 N `� 'n 4 ' Ln Ln M r-1 M r-1 O l0 l0 00 M l0 r-1 01 M LnLn N Ln l0 M r-1 ' M N N r-I r-I N N r�-I N r-i '� Ln O N 0 O M Ln N O l� N Ln a) M 00 � N cy) I� � O � N N � rn � �, � � � � � Ln M Ln 00 0 � oo �o rn �' � � rn N � , m m fV M l0 � T* � N N r-1 M Ln l0 r-I r-I 0 M r-I N M M N M M Ln Ln (Y) M N N r- Ol M O 00 N Ln M O rn — O Ln o LNn 00 �o M M O a) Ln rl*l� � M +q.+ N � `� � 00 `� � � LnN N � l0 M M r-i � lzt N M � 00 M Ln N N Ln tn- Ln Ln r-1 `� r1 N M N MLn O F- C N r-1 rl N Ln N � r1 U N L N Ln M OLn Ln N 00 O N rl O O Ln M M +-+ 0000 0 � N Ol Ln Ln 9t 1O O r-1 N ' rl r-I r-I � � M � O � N N � � >• N r-1 a--+ O z tab +� O ) N = U O Q � t/f U a..+ a--+ Ca C) = N ate-+ Un N cn o C 4-; 'c� _0 s O +J cn � O cn p v p O O ca a� 2 au _0 p c: U (a C: ca O _ z -0V' a--+ • r •� LL a) •U a--j 0 Z) N }, �_ 4A cn cn Lncn 'n � tn Ln 4-j Ln cn Ln M k O O J N 0 � � U ._ U U U G� ca DC � O Ln Ln w c in U ateJ ateJ -0 U O O O b- � O 2- N OE E:Ll nO p� 4A U MQ 4-j U 40- 0 Ln Lu O u -0 � 'u +-, C: -a — E Ln Q t, .0 -0 •E c.� _a u W taro cz a) `" rl ago '- ago �,W >r-1 bn Ln cu O w co a� a� ago ago O M u 00 Lu LU 0 Q U.o oc o a J J a a z U M LL Agenda Item #8. 1;t 1;t � � q;t Ln � Ln Ln N I� lD O N I� I� I� rl M M Q M Q Q O I- cV 00 rl 00 � Ln Ln I_f) `� M 00 z � 00 M z N z M O1 N al Q0 � � Ol oo u1 M N N rl lD I� Ol m N M � N rl N Ol � Qo N rn rQ m m 00 °-j rn t'o 0000 Q �D 00 Q o Q O rn o �n m N oro Sri 00 0� rn z M 00(-4 z M Z N N oo oo rn M M N r-i 00 00 I� O N � � � m M lD Q N Q � Q N I� �D r m M �n � 0o M 00 z k.D w z O Z w M O M M N ri cv �, o 0 0000 N N M `� � `� 00 01 0 M N O W rl � 00� M O O Q00 O 00 Q Q 00O � NMN O � Z W Z Z Ln OM M OO rl O O� M ca O - > ^ ca O 0- o cn _0_ > o ° O 4—p c� � L O V O _0 Ln i O 0 LA .> � aJ p � O v � LnQ cn > � 0 Lnp cn a) � O z V o Q V � — cn O ca U- L 3: = _0 E Ocon -61 p a) � cu O Ln pC = cn O •— O Q cn tx o V O O oC O 0 O cn O �' w wpE E .p O O `�' O N �' .� O ca +- �Ln -� +� C Z � tW ago Ln ca z U oC C cn N w `- O �' ca ca N cn 41 N N �0 a� bD 4 ° co O o CO a0 oc Q) .o .o 0 o P f 2 o o Ln � — p w w — o �n o � � � � o � � � � � � M M � � � � age 55 0 5 or_ V — U U oL x x oc u X X X ,� _ oC w u cu � Q O u V V V z M u o 0) W w w w Agenda Item #8. V O � .N O N p N -0 as--+ a O Q N ro M N O t l0 io M N U N = L H O t/) — N M N � 00 r-I r-I p O .. N a� Q W c V a� s M N N V +, LLIO OC cn U Q c N p W o O H O c cn V LL G i Q z 4-J •> cr) V a-J O ca � NIn N V cn }' J V ca O cn U- aA ... O cn m 0 r1 00 I� I� N +-+ V 41 d j H M rl w LQ cn cn V a N N _O •> ch N Ln N M � 00 I� N \ O c—c >- � cn G O N � � fa to 0 � M N O O s J }' O •ca >� N N — — _ '� O CD " v o ° .. M .I— �ca .� O Q) O � M N LA � � — 0- S !E � ICI O � E (,7 ago O - E a c c > � Ln CO o Ln N r1 r1 � M M G M O M M w O O Ln M r1 Ln r1 � L N r1 Z O — p L O M N U z >. ( a — � U o o � N N o CO V •> O cn p 4- Ln LL Q v U L O a) 1� s t W �7 s `n > O cn c `n O }+ }+ 0 +� a� > s_ CA QO -+ O �-0 4-J L~ S M W COO O O �D Ln O ry) N rr) GS�+ 00� Mra cn _ —_ _ N O > O V Q O ca `� V V U Z m � l�A 0 Ln E i p O O ca — cn a--+ +.+ 4- O +, _ .0 L Ln .J s o w o v u _0 W O }, N Q L cn O J L .. `- up E DC -0 t0A cn N N Ln E E W }' — O G� n UO cn v 0- Ln � >- V Ln (Ai CO _ Ca L E � •L � +� � ca � N a) E O Q a--+ N cn L (� � U->- � v E N = o °' o s O °' M Ln Ln too 4-J CO o� v p o i o a-+ N 0 cn J Ct3 QJ N � VLn N N O ---% ate+ CL u V >� O s N >` — in U V L cn E 4J U- V ) N o v \ i Q V ' > O E (� V Q 0 s -1-1 c _ v Q t�A O > \ � a--' ca O N _ agocn N V v +O c ._+ ca ca OI CO N ca _ - CO CL Ln �C O 0 W +� O +� V p — +�+ co m a� cn ca M Ln 0 - O E +J 06 o;a O - N L-L _ (li _ P 5 of 265 V Q Q - + 3 O E w Q Q ca J w U w Agenda Item #8. 0 Ln N 110 I%l U N r--. r---. .� M `n 1;T M Ni w O N 00 a � U 0 M � � N r-I (V l0 } r--.. r... M N O Ol r� a U � Ol O w N O >- d1 Oq M 0i Ol M N N c a� ca U t C6 }+ _0 _ C: t.0 0 U) O b-0 +- W O O c6 i V O U b-0 p � � (D Ln rN-I v v O Q cu r 4- O V v Mcr c Q ca s c6 O +-' (,O — — � C ca 4-J 0 r O O .�' -0 v � a � i O N N O E (D C6 2 E ^ v pa) fu }' N � Qq }' O +.+ O Or- 2 p E .2!% cn _ � v N N v M — i .2 v E � O a--+ C � o o 4-1 4- ru v 4 E O � i 4-J o CLCL _ +r u v E v a� 0 — O p .� E vi u .N M a U _ .� Page 57 of 265 x I> � O ca c6 O .�. !E � +� � O ° Q 2 a_