The URL can be used to link to this page

Home My WebLink AboutDocumentation_Regular_Tab 12_8/11/2022Agenda Item #12. Regular Council STAFF MEMO Meeting: Regular Council - Aug 11 2022 Staff Contact: Jeremy Allen, Village Manager Department: Manager Village Manager Standing Report CRY: 1. The Financial Reports presented above are unadjusted and unaudited. The Village considers revenues available if collected within 60 days of the current fiscal period. This means that there are additional revenues and expenditures that have not been recorded to date and that will be recorded once year-end adjustments are completed. Additionally, during the year, revenues and expenses are recorded on a modified accrual basis (similar to a cash basis). This will result in significant differences between our beginning balances in the enterprise funds (water, refuse and recycling and stormwater) and the adjusted ending balances as these funds report on a full accrual basis. 2. Property Taxes — collected at $8.3 million, which represents 101 % of the budgeted amount. It is $416 thousands (5%) higher than for the same period of the prior fiscal year. Historically, 91 % of ad valorem tax distribution receipted by the end of February. 3. Sales/use taxes (70%), which include local infrastructure surtax, insurance premium, utility, communication service and local business tax, fell below budget target due to the distribution to be one month behind the collection/reported period and Insurance premium tax ($263 thousand) to be collected at the year-end as one distribution, with the exception of the Local Business Tax collected in full. Overall, sales/use taxes are above budgeted for nine month's collections. 4. Intergovernmental revenues (86%) which include municipal revenue sharing, half -cent sales tax, and local gas tax distribution to be one month behind the collection/reported period. It is above budget target for nine month's collections due to the half -cent sales tax revenue increase col lection/distribution (by 18%). 5. Local discretionary infrastructure surtax(80%) - collected at $375 thousand, which represent 80% of the budgeted amount for only eight month's collection/reported period and is above target by 14% due to the increased State revenue collection/distributions. 6. Revenues (Budgetary comparison) recorded in the General fund represents 76% of budgeted. It is below target budget due to the distribution nature of grant revenues (ARPA funds $1.1 million) and State insurance premium tax ($263 thousand) to be received as one distribution at year-end. 7. Overall Expenditures (Budgetary comparison) in the General Fund represents 64% of budgeted. Not all the expenditures recorded for the services provided up to 7/31/22 and personnel expenditures recorded as paid not when accrued. Page 152 of 499 Agenda Item #12. 8. Revenues (Prior year comparison) all funds decreased due to loan proceeds recorded in FY 2021 ($6.9 millions). 9. Expenditures (Prior year comparison) all funds aligned with prior fiscal year. 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. PROJECT NAME: BUDGET: N/A ENCUMBERED: N/A Proposed: N/A Jul 2022 reports Quarterly Investment Report - June 2022 Copy of August 2022 Managers Report.ADA Copy of July 2022 Grant Budget Worksheet Projected Remaining: N/A Page 153 of 499 Q lfoti�i # 120 BALANCE SHEET FOR VILLAGE OF TEQUESTA sracanPeriod Ending 07/31/2022 DB : Tecruesta Fund 001 GENERAL FUND GL Number Description *** Assets *** Cash and Cash Equivalents Investments Accounts Receivable Due from Other Funds Accrued Income Receivable Inventories Prepaids Other Assets - Current Other Fixed Assets Total Assets *** Liabilities *** Accounts Payable Accrued liabilities Retainage Payable Due to Other Funds Due to Other Governments Deferred Revenue Other Current Liabilities Customer Deposits Noncurrent liabilities Total Liabilities *** Fund Balance *** F/B - Reserved for Inventories F/B - Res for Encumbrance F/B - All Other Reserves F/B - Unreserved - Designated F/B - Unreserved/Undesignated Fund Balance - Nonspendable Fund Balance - Restricted Fund Balance - Committed Fund Balance - Assigned Fund Balance - Unassigned Total Fund Balance Beginning Fund Balance Net of Revenues VS Expenditures Ending Fund Balance Total Liabilities And Fund Balance Balance 1, 720, 816. 00 6,454,734.98 344,515.83 0.00 0.00 83,849.40 412,330.60 0.00 0.00 9,016,246.81 280,031.88 315,042.79 0.00 0.00 1,271.47 32,382.97 0.00 0.00 0.00 628,729.11 0.00 0.00 0.00 0.00 0.00 732,799.97 364,007.00 500,000.00 55,709.00 4, 553, 863. 61 6,206,379.58 6,206,379.58 2,181,138.12 8,387,517.70 9,016,246.81 Page: 1/8 Page 154 of 499 Q lfoti�i # 120 BALANCE SHEET FOR VILLAGE OF TEQUESTA sracanPeriod Ending 07/31/2022 DB: Teauesta Fund 101 BUILDING FUND GL Number Description *** Assets *** Cash and Cash Equivalents Investments Accounts Receivable Inventories Prepaids Total Assets *** Liabilities *** Accounts Payable Accrued liabilities Due to Other Governments Total Liabilities *** Fund Balance *** F/B - Unreserved/Undesignated Fund Balance - Nonspendable Fund Balance - Restricted Fund Balance - Unassigned Total Fund Balance Beginning Fund Balance Net of Revenues VS Expenditures Ending Fund Balance Total Liabilities And Fund Balance Balance 145,460.02 701,606.55 12.25 212.25 4,328.60 851,619.67 (1, 765. 10) (46r430.63) 732.51 (47,463.22) 0.00 11,454.70 864,932.12 0.00 876,386.82 876,386.82 22,696.07 899,082.89 851,619.67 Page: 2/8 Page 155 of 499 Q lfoti�i # 120 BALANCE SHEET FOR VILLAGE OF TEQUESTA sracanPeriod Ending 07/31/2022 DB: Teauesta Fund 301 CAPITAL IMPROVEMENT FUND GL Number Description *** Assets *** Cash and Cash Equivalents Investments Accounts Receivable Due from Other Funds Prepaids Total Assets *** Liabilities *** Accounts Payable Accrued liabilities Retainage Payable Due to Other Funds Total Liabilities *** Fund Balance *** F/B - Res for Encumbrance F/B - All Other Reserves F/B - Unreserved - Designated F/B - Unreserved/Undesignated Fund Balance - Nonspendable Fund Balance - Restricted Fund Balance - Committed Fund Balance - Assigned Fund Balance - Unassigned Total Fund Balance Beginning Fund Balance Net of Revenues VS Expenditures Ending Fund Balance Total Liabilities And Fund Balance Balance 106,365.41 0.00 0.00 0.00 0.00 106,365.41 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 59,172.00 262, 429. 00 31, 690 . 26 0.00 353,291.26 353,291.26 (246, 925.85) 106,365.41 106,365.41 Page: 3/8 Page 156 of 499 Q lfoti�i # 120 BALANCE SHEET FOR VILLAGE OF TEQUESTA sracanPeriod Ending 07/31/2022 DB: Teauesta Fund 303 CAPITAL PROJECTS FUND GL Number Description *** Assets *** Cash and Cash Equivalents Investments Accounts Receivable Due from Other Funds Prepaids Total Assets *** Liabilities *** Accounts Payable Accrued liabilities Retainage Payable Due to Other Funds Total Liabilities *** Fund Balance *** F/B - Res for Encumbrance F/B - Unreserved/Undesignated Fund Balance - Nonspendable Fund Balance - Assigned Fund Balance - Unassigned Total Fund Balance Beginning Fund Balance Net of Revenues VS Expenditures Ending Fund Balance Total Liabilities And Fund Balance Balance 146,104.30 0.00 0.00 0.00 0.00 146,104.30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,550,094.11 0.00 2,550,094.11 2,550,094.11 (2,403,989.81) 146,104.30 146,104.30 Page: 4/8 Page 157 of 499 Q lfoti�i # 120 BALANCE SHEET FOR VILLAGE OF TEQUESTA sracanPeriod Ending 07/31/2022 DB : Tecruesta Page: 5/8 Fund 401 WATER FUND GL Number Description *** Assets *** Current Assets Cash and Cash Equivalents Investments Accounts Receivable Special Assess -Current Special Assess - noncurrent Due from Other Funds Accrued Income Receivable Inventories Prepaids Other Assets - Current Land Other Assets - Non Current INFRASTRUCTURE Buildings Improvements Other Than Bldgs. Machinery & Equipment Construction in Progress Intangible Assets Other Fixed Assets Deferred Outflows FIXED ASSETS Total Assets *** Liabilities *** Accounts Payable Accrued liabilities Retainage Payable Due to Other Funds Due to Other Governments Deferred Revenue Current Portion of Debt Other Current Liabilities Customer Deposits Noncurrent liabilities Other Long Term Liabilities Def Inflows of Resources Total Liabilities *** Fund Balance *** F/B - Res for Encumbrance F/B - All Other Reserves F/B - Unreserved - Designated F/B - Unreserved/Undesignated N.A., Inv in Cap, net of debt Net Assets, Restricted Fund Balance - Restricted Fund Balance - Committed Fund Balance - Unassigned Total Fund Balance Beginning Fund Balance Net of Revenues VS Expenditures Ending Fund Balance Total Liabilities And Fund Balance Balance 0.00 2, 970, 942 . 84 3, 600, 500 . 71 732,573.83 0.00 0.00 0.00 0.00 223,902.22 40r448.64 0.00 83,335.00 83,335.00 15, 249, 991. 62 224,255.54 24,662.40 306,345.95 216,729.93 8r 038.08 0.00 548,103.80 0.00 24,229,830.56 (1, 335. 70) (274r118.39) 0.00 0.00 251.53 0.00 391,728.09 0.00 41,430.00 2,344,386.67 415,756.86 478,636.00 3,396,735.06 0.00 0.00 0.00 0.00 11,584,763.87 0.00 376,728.00 500,000.00 7, 760, 148 . 90 20F22lr640.77 20,221,640.77 611,454.73 20r833,095.50 24,229,830.56 Page 158 of 499 Q lfoti�i #120 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/8 sracanPeriod Ending 07/31/2022 DB: Teauesta Fund 402 REFUSE & RECYCLING GL Number Description Balance *** Assets *** Cash and Cash Equivalents 198,944.81 Investments 0.00 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 198,944.81 *** 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 94,283.76 Total Fund Balance 94,283.76 Beginning Fund Balance 94,283.76 Net of Revenues VS Expenditures 104,661.05 Ending Fund Balance 198,944.81 Total Liabilities And Fund Balance 198,944.81 Page 159 of 499 Q lfoti�i # 120 BALANCE SHEET FOR VILLAGE OF TEQUESTA sracanPeriod Ending 07/31/2022 DB : Tecruesta Page: 7/8 Fund 403 STORMWATER UTILITY GL Number Description *** Assets *** Cash and Cash Equivalents Investments Accounts Receivable Due from Other Funds Inventories Prepaids Other Assets - Current Other Assets - Non Current INFRASTRUCTURE Buildings Improvements Other Than Bldgs. Machinery & Equipment Construction in Progress Deferred Outflows Total Assets *** Liabilities *** Accounts Payable Accrued liabilities Retainage Payable Due to Other Funds Due to Other Governments Current Portion of Debt Other Long Term Liabilities Def Inflows of Resources Total Liabilities *** Fund Balance *** F/B - Res for Encumbrance F/B - Unreserved - Designated F/B - Unreserved/Undesignated N.A., Inv in Cap, net of debt Fund Balance - Unassigned Total Fund Balance Beginning Fund Balance Net of Revenues VS Expenditures Ending Fund Balance Total Liabilities And Fund Balance Balance (62,834.04) 0.00 289.46 0.00 617.53 517.71 0.00 0.00 2,003,395.44 0.00 0.00 17,118.63 0.00 25,859.00 1,984,963.73 517.71 (20, 369. 40) 0.00 0.00 0.00 0.00 14,769.37 10,773.00 5,690.68 0.00 0.00 0.00 1,236,387.06 740,011.78 1,976,398.84 1,976,398.84 2,874.21 1,979,273.05 1,984,963.73 Page 160 of 499 Q lfoti�i # 120 BALANCE SHEET FOR VILLAGE OF TEQUESTA sracanPeriod Ending 07/31/2022 DB: Teauesta Fund 605 SPECIAL LAW ENFORCEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents Investments Accounts Receivable Inventories Prepaids Total Assets *** Liabilities *** Accounts Payable Due to Other Funds Total Liabilities *** Fund Balance *** Fund Balance - Nonspendable Fund Balance - Restricted Fund Balance - Assigned Fund Balance - Unassigned Total Fund Balance Beginning Fund Balance Net of Revenues VS Expenditures Ending Fund Balance Total Liabilities And Fund Balance 51,747.37 80r420.25 0.00 0.00 8,540.61 140,708.23 0.00 0.00 0.00 13,352.35 143,688.75 0.00 0.00 157,041.10 157,041.10 (16,332.87) 140,708.23 140,708.23 Page: 8/8 Page 161 of 499 Agenda Item #12. VILLAGE OF TEQUESTA Cash & Investments Unadjusted Unaudited 7/31/2022 Cash Investments Total General Fund #001 $ 117205816 $ 69454,735 $ 85175,551 Building Fund #101 145,460 70107 84707 Capital Improvement Fund #301 106,365 - 106,365 Capital Projects Fund #303 146,104 - 146,104 Water Utility #401 219701943 300,501 61571,444 Refuse & Recycling #402 1985945 - 198,945 Stormwater #403 (62,834) * - (62,834) Special Law Enforcement #605 51,747 80,420 132,168 Total Cash and Investments $ 592779547 $ 109837,262 $ 1691149809 * Transfer In from General fund is pending upon receipt of ARPA funds. Page 162 of 499 nda Item #12. VILLAGE OF TEQUESTA REVENUE REPORT- UNADJUSTED, UNAUDITED 7/31/2022 YTD TD DESCRIPTION 1 7/3 �2021EI Y7/3%2022E VARIANCE I %VARIANCE NOTES REVENUES Fund 001 - GENERAL FUND General Property Taxes 7,845,063 8,260,937 415,874 5.30% Historically, 91% receipted by the end of Feb Sales & Use Taxes 11220,552 1,345,724 125,171 10.26% State revenues distributions increase Franchise fees - gross receipt 375,076 363,715 (11,361) -3.03% Licenses & Permits 780 1,010 230 29.49% Grants - Federal 173,745 49,565 (124,180) -71.47% Differs from year to year Grants - State 13,605 12,615 (990) -7.28% Differs from year to year Intergovernmental Revenue 679,819 777,654 97,835 14.39% State revenues distributions increase Chgs for Services - Gen Gov 593,237 3971218 (196,019) -33.04% Decrease in large projects - land development fees Intragovernmental Revenue 859,414 713,618 (145,796) -16.96% Decrease in admin fees from Water fund Rents & Royalties 191,576 2141226 22,650 11.82% Recreation facilities rental increase Contributions & Donations 100 3,350 3,250 100.00% Differs from year to year Miscellaneous Revenues 18,124 3,186 (14,938) -82.42% Insurance premium refund not received in FY 2022 Chgs for Services - Public Safety 1,099,983 972,289 (127,694) -11.61% Fire plan review fees decrease due to projects Fines & Forfeitures 171181 13,985 (3,196) -18.60% Code enf. Fines decrease Impact Fees 25,933 9,602 (16,332) -62.98% Differs from year to year, decrease in new projects Charges for Services - Recr. 5,575 9,190 3,615 64.84% Recreation program's fees increase due to open facility Transfers In 31,994 0 (31,994) -100.00% Differs from year to year Unrestricted Investment Earning 6,462 141242 71780 120.40% Investment balance and rate increase Other Financing Sources 1921219 972 (191,247) -99.49% Capital lease, sale of assets differ from year to year Total General Fund 13,350,438 13,163,096 (187,342) -1.40% Fund 101 - BUILDING FUND Licenses & Permits 808,843 603,237 (205,606) -25.42% Decrease in large projects Grants - Federal 1,813 0 (1,813) -100.00% Differs from year to year Charges for Services 311237 6,940 (24,297) -77.78% Admin fees from other gov depending on projects Miscellaneous Revenues 0 56 56 100.00% Unrestricted Investment Earning 975 1,824 849 87.13% Total Building Fund 842,868 612,057 (230,811) -27.38% Fund 301 - Capital Improvement Fund Unrestricted Investment Earning 313 87 (226) -72.16% Total Capital Improvement Fund 313 87 (226) -72.16% Fund 303 - Capital Projects Fund Unrestricted Investment Earning 3,317 1,068 (2,249) -67.81% Investment balance decrease Other Financing Sources 6,890,000 0 (6,890,000) -100.00% Loan proceeds for cap. projects recv'd in previous yr. Total Capital Projects Fund: 6,893,317 1,068 (6,892,249) -99.98% Fund 401 - Water Fund Grants Federal 3,542 0 (3,542) -100.00% Differs from year to year Miscellaneous Revenues 62,826 35,203 (27,623) -43.97% Differs from year to year (credit recorded in FY 2021) Fines & Forfeitures 0 563 563 100.00% Other Financing Sources 474,970 101,920 (373,051) -78.54% Capital connect charges due to big projects Unrestricted Investment Earning 5,621 41747 (875) -15.56% Investment balance decrease Charges for Services 4,876,414 5,038,587 1621173 3.33% Total Water Fund: 5,423,373 5,181,019 (242,354) -4.47% Fund 402 - Refuse & Recycling Intergovernmental Revenue 0 1,992 1,992 100.00% SWA shared revenues distributions increase Unrestricted Investment Earning 328 142 (186) -56.75% Charges for Services 4821800 500,129 17,329 3.59% Total Refuse & Recycling: 483,128 502,263 19,134 3.96% Fund 403 - Stormwater Utility Unrestricted Investment Earning 870 62 (808) -92.90% Charges for Services 4471845 4871427 39,583 8.84% Total Stormwater Utility: 448,715 4871489 38,774 8.64% Fund 605 - Special Law Enforcement Forfeitures 91,516 89,470 (2,046) 100.00% Differs from year to year Unrestricted Investment Earning 103 456 353 342.28% Total Special Law Enforcement 91,619 89,926 (1,693) -1.85% TOTAL REVENUES - ALL FUNDS 27,533,771 20,037,005 (7,496,766)-27.23% NOTES are for differences grater than 10% and amounts over $1,000. Page 163 of 499 rW enda Item #12. VILLAGE OF TEQUESTA EXPENDITURE REPORT - UNADJUSTED, UNAUDITED 7/31/2022 YTD BALANCE YTD BALANCE DESCRIPTION 7/31/2021 7/31/2022 VARIANCE VARIANCE NOTES EXPENDITURES Fund 001 - GENERAL FUND Council 40,489 53,742 13,254 32.73% Computer system maintenance, volunteer appreciation Manager 229,509 250,987 21,478 9.36% Human Resources 276,665 300,854 241F189 8.74% Village Clerk 268,381 2711151 21,769 1.03% Finance 563,096 572,262 9,166 1.63% Legal 1441,749 120,804 (23,945) -16.54% Differs from year to year based upon service needs Comprehensive Planning 116,090 171,155 55,065 47.43% Rate increase and other contractual services increase General Government 229,810 206,064 (23,747) -10.33% Paradise park lease termination IT 433,796 376,378 (57,419) -13.24% Decrease in equipment purchases/IT projects Police Department 2,583,404 21751,908 168,504 6.52% Code Compliance 66,588 91,086 24,498 36.79% Additional Part time salaries and legal svcs. Fire Control 3,488,307 3,253,116 (235,191) -6.74% Vehicle purchase in 2021 ($299K) Public Works 11107.1762 1,095,648 (12,115) -1.09% Leisure Services 525,095 659,776 134,680 25.65% Salaries, builders risk ins, events & programs exp increase Debt Service 409,016 807,028 398,012 97.31% New debt service (rec.center, vehicles & SAN project ) Total General Fund 10,482,758 10,981,958 499,200 4.76% Fund 101 - BUILDING FUND Building Department 542,590 589,361 46,771 8.62% Interfund Transfers 10,103 0 (10,103) -100.00% Differs from year to year Total Building Fund 552,693 589,361 36,668 6.63% Fund 301- Capital Improvement Fund Public Works 25,764 247,013 221,249 858.74% Roads and sidewalks repair and maintenance Parks 3,600 0 (3,600) -100.00% Projects differ from year to year Tequesta Drive Bridge 83,395 0 (83,395) -100.00% Projects differ from year to year Total Capital Improvement Fund: 1121,759 247,013 1341,254 119.06% Fund 303 - Capital Projects Fund Public Works 236,329 255,000 18,671 100.00% Roads repair and maintenance Recreation Center 21222,835 2.1150,057 (72,778) -3.27% Recreation Center project Total Capital Projects Fund: 21459,164 21405,057 (54,107) 100.00% Fund 401- Water Fund Water -Administration 11192,028 1,1711466 (20,563) -1.73% Water - Production 1,560,622 1/401/234 (159,388) -10.21% Timing in pension expense recording Water -Distribution 716,928 525,495 (191,433) -26.70% Vacant position, timing in pension exp. Recording Water -Customer Service 1921776 2141777 22,001 11.41% Bad debt exp.and regular salaries increases Renewal & Replacement 821,013 880,371 59,358 7.23% Water projects Debt Service 419,499 376,222 (43,277) -10.32% Debt service paid off in FY 2021 Interfund Transfers 21,891 0 (21,891) -100.00% Differs from year to year Other Nonoperating 39,761 0 (39,761) -100.00% Differs from year to year - loss on disposal of CA Total Water Fund: 4,964,519 4,569,564 (394,954) -7.96% Fund 402 - Refuse & Recycling Refuse and Recycling 384.8232 397,602 13,369 3.48% Total Refuse & Recycling: 3841F232 397,602 13,369 3.48% Fund 403 - Stormwater Utility Storm Water Utilities 264,301 263,907 (394) -0.15% Renewal & Replacement 655,095 220,708 (434,387) -66.31% Drainage improvements Other Nonoperating 10,449 0 (10,449) -100.00% Differs from year to year - loss on disposal of CA Total Stormwater Utility: 929,844 484,615 (445,230) -47.88% Fund 605 - Special Law Enforcement Police 16,082 106,259 90,177 560.72% Vary from yr. to yr., not spent evenly throughout the yr. Total Special Law Enforcement: 16,082 106,259 90,177 100.00% TOTAL EXPENDITURES - ALL FUNDS 19,902,052 19,781,429 (120,622) -0.61% * Varies by department, different expenditures have not been recorded in FY 2022 vs FY 2021. VOTES are for differences grater than 10% and amounts over $1,000. Page 164 of 499 4.genda Item #12. THE VILLAGE OF TEQUESTA REVENUE REPORT - UNADJUSTED, UNAUDITED 7/31/2022 FY 2022 FY 2022 83.33 % ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT % BDGT DESCRIPTION BUDGET BUDGET BUDGET 7/31/2022 VARIANCE VARIANCE USED NOTES Fund 001- GENERAL FUND General Property Taxes 810158,070 8.1158.1070 610798,392 8,2601937 1104621P546 21.51% 101.26 Historically, 91% receipted by the end of Feb Sales & Use Taxes 1,910,660 1,910,660 1,592,217 1,345,724 (246,493) -15.48% 70.43 Ins.premium tax comes as one distribution Franchise fees - gross receipt 462,000 462,000 385,000 363,715 (21,285) -5.53% 78.73 Licenses & Permits 1,000 1,000 833 1,010 177 21.20% 101.00 Intragovernmental Revenue 856,310 856,310 713,592 713,618 27 0.00% 83.34 Grants Federal 201,400 1/165/630 9711,358 491565 (921,794) -94.90% 4.25 ARPA funds are not yet received Grants - State 12,000 20,675 171P229 12,615 (4,614) -26.78% 61.02 Differ from year to year Intergovernmental Revenue 907,320 907,320 756,100 777,654 21,554 2.85% 85.71 State rev is one month behind, 1/2 c tax above budg. Chgs for Services - Gen Gov 195.1500 204,000 170,000 3971218 2271P218 133.66% 194.71 Land development fees depends on the projects Chgs for Services - Public Safety 11,265,570 11267,660 1,056,383 9721289 (84,094) -7.96% 76.70 Charges for Services - Recr. 46,190 46,190 38,492 9,190 (29,302) -76.13% 19.90 No Teq.fest & camp fees Fines & Forfeitures 18,500 18,500 15,417 13,985 (1,432) -9.29% 75.59 Unrestricted Investment Earning 8,300 8,300 6,917 141P242 7,325 105.90% 171.59 Investment balance and rate increase Rents & Royalties 255,190 255,190 212,658 214,226 1,567 0.74% 83.95 Impact Fees 1,500 1,500 11250 9,602 8,352 668.15% 640.12 Differ from year to year Contributions & Donations 2,000 2,000 1,667 3,350 1,683 101.00% 167.50 Donations received Miscellaneous Revenues 121230 121P230 10,192 3,186 (7,006) -68.74% 26.05 Differ from year to year Other Financing Sources (lease) 0 1,865,588 1,554,657 972 (1,553,685) -99.94% 0.05 Fire trucks will not be received this FY Appropriate Fund Balance 1.1145,230 94,275 0 Total General Fund 15,277,970 17,257,098 14,380,915 13,163,096 (1,217,819) -8.47% 76.28 Fund 101- BUILDING FUND Licenses & Permits 503,000 703,000 585,833 603,237 171P404 2.97% 85.81 Permit fees collected for projects Chgs for Sery - Gen Gov 0 0 0 6,940 6,940 100.00% 0.00 Differ from year to year Unrestricted Investment Earning 110400 11400 110167 1,824 658 56.37% 130.31 Miscellaneous Revenues 0 0 0 56 56 100.00% 0.00 Appropriate Fund Balance 171,860 171,860 0 0 Total Building Fund 676,260 876,260 730,217 612,057 (118,159) -16.18% 69.85 Fund 301- Capital Improvement Fund Unrestricted Investment Earn 1,000 1,000 833 87 (746) -89.56% 8.70 Transfers In 6771,260 6771260 564,383 0 (564,383) -100.00% 0.00 Timing in revenue recording Appropriate Fund Balance 87,000 117,585 0 Total Capital Improvement Fund: 765,260 795,845 663,204 87 (663,117) -99.99% 0.01 Fund 303 - Capital Projects Fund Unrestricted Investment Earning 500 500 417 1,068 651 156.32% 100.00 Transfers In 87,000 117,585 97,988 0 (97,988) -100.00% 0.00 Timing in revenue recording Appropriate Fund Balance 254,500 2,613,138 0 Total Capital Projects Fund: 342,000 21731,223 210276,019 1,068 (2,274,951) -99.95% 0.00 Fund 401- Water Fund Charges for Services 6,346,500 6,346,500 5,288,750 5,038,587 (250,163) -4.73% 79.39 Revenue is one month behind Fines & Forfeitures 0 0 0 563 563 100.00% 100.00 Unrestricted Investment Earn 8,400 8,400 7,000 41747 (2,253) -32.19% 56.51 Unrealized loss on investments Miscellaneous Revenues 48,500 48,500 40,417 35,203 (5,214) -12.90% 72.58 Other Financing Sources (icl.loan) 41457,000 41457,000 3,714,167 101,920 (3,612,247) -97.26% 2.29 Loan proceeds recorded when received Appropriate Fund Balance 2,076,950 2,643,746 0 0 Total Capital Projects Fund: 12,937,350 13,504,146 11,253,455 5,181,019 (6,072,436) -53.96% 38.37 Fund 402 - Refuse & Recycling Intragovernmental Revenue 0 0 0 1,992 1,992 100.00% 100.00 SWA revenue sharing new Charges for Services 500,940 500,940 417,450 500,129 82,679 19.81% 99.84 Historically, 91% receipted by the end of Feb Unrestricted Investment Earn 500 500 417 142 (275) -65.98% 28.35 Appropriate Fund Balance 28,570 28,570 0 Total Refuse & Recycling: 530,010 530,010 441,675 502,263 60,588 13.72% 94.76 Fund 403 - Stormwater Utility Grants & Contributions 30,000 30,000 25,000 0 (25,000) -100.00% 0.00 Differ from year to year Charges for Services 497,810 497,810 414,842 487/427 72,586 17.50% 97.91 Historically, 91% receipted by the end of Feb Unrestricted Investment Earn 1,400 11400 1,167 62 (1,105) -94.71% 4.41 Investment balance decrease Transfers In 150,000 188,565 157.1138 0 (157,138) -100.00% 100.00 Timing in revenue recording Appropriate Fund Balance 0 47,352 39,460 Total Stormwater Utility: 679,210 765,127 637,606 487,489 (150,117) -23.54% 63.71 Fund 605 - Special Law Enforcement Forfeitures 0 44,202 36,835 89,470 52,635 142.89% 0.00 Differ from year to year Unrestricted Investment Earn 0 0 0 456 456 100.00% 1.00 Appropriate Fund Balance 74,920 149,670 1241725 0.00 Total Special Law Enforcement 74,920 193,872 161,560 89,926 (71,634) -44.34% 0.00 TOTAL REVENUES - ALL FUNDS 311282,980 36,653,581 30,544,651 20,037,005 (10,507,646) -34.40% 54.67 r-% _ _. _ A r. r _r A nn NOTES are for differences grater than 10% and amounts over $1,000. 0%W'%A•1 14.0%w% 4017 0 THE VILLAGE OF TEQUESTA EXPENDITURE REPORT - UNADJUSTED, UNAUDITED 7/31/2022 FY 2022 FY 2022 83.33 % ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT % BDGT DESCRIPTION BUDGET BUDGET BUDGET 7/31/2022 VARIANCE VARIANCE USED Fund 001- General Fund Council 77,350 77,350 64,458 53,742 (10,716) -16.63% 69.48 (1), (2) Manager 306,720 306,720 255,600 250,987 (4,613) -1.80% 81.83 (1),(2) Human Resources 385,040 385,040 320,867 300,854 (20,013) -6.24% 78.14 Village Clerk 373,940 373.1940 311,617 271.1151 (40,466) -12.99% 72.51 Finance 715,220 715,220 596,017 5721,262 (23,755) -3.99% 80.01 Legal 190,000 190,000 158,333 120,804 (37,529) -23.70% 63.58 Comprehensive Planning 281,540 290,040 2411700 171,155 (70,545) -29.19% 59.01 General Government 314,310 280.1310 233,592 206,064 (27,528) -11.78% 73.51 IT 476,650 476,650 3971208 376,378 (20,831) -5.24% 78.96 (3) Police Department 3,558,370 3,603,969 3,003,308 21,751,908 (251,399) -8.37% 76.36 (1),(2) Code Compliance 1241480 1241,480 103,733 91,086 (12,648) -12.19% 73.17 Fire Control 41172,295 6,058,759 5,048,966 3,253,116 (1,795,849) -35.57% 53.69 Public Works 1,546,915 1,546,915 1,289,096 1,095,648 (193,448) -15.01% 70.83 Leisure Services 942,080 976,080 813,400 659,776 (153,624) -18.89% 67.59 (3) Debt Service 886,280 886,280 738,567 807,028 68,462 9.27% 91.06 New debt service Interfund Transfers 827,260 865,825 721,521 0 (721,521) -100.00% 0.00 (3) Allocate to Fund Balance 99,520 99,520 Total General Fund 15,277,970 171257,098 14,380,915 10,981,958 (3,398,957) -23.64% 63.64 Fund 101- BUILDING FUND Building & Zoning 676,260 786,260 655,217 589,361 (65,855) -10.05% 74.96 (1), (2) Allocate to Fund Balance 0 90,000 75,000 0 (75,000) -100.00% 0.00 Total Building Fund 676,260 876,260 7301217 589,361 (140,855) -19.29% Fund 301- Capital Improvement Fund Public Works 419,590 419,590 349,658 247,013 (102,645) -29.36% 58.87 (2) Interfund Transfers 87,000 117,585 97,988 0 (97,988) -100.00% 0.00 (3) Allocate to Fund Balance 258,670 258,670 Total Capital Improvement Fund: 765,260 795,845 663,204 247,013 (416,191) -62.75% 31.04 Fund 303 - Capital Projects Fund Public Works 255,000 255,000 212,500 255,000 42,500 20.00% 100.00 Recreation Center 87,000 2.1476,223 2,063,519 2.1150,057 86,538 4.19% 86.83 Total Capital Projects Fund: 342,000 21731.1223 21276,019 2.1405,057 129,038 5.67% 88.06 Fund 401- Water Fund Water -Administration 1/377/790 1.1494,036 11245,030 11,171.1466 (73,564) -5.91% 78.41 Water - Production 1,945,290 1,960,290 1,633,575 1.1401,234 (232,341) -14.22% 71.48 Water -Distribution 742,350 756,350 630,292 525,495 (104,797) -16.63% 69.48 Water -Customer Service 279,450 279,450 232,875 214,777 (18,098) -7.77% 76.86 Renewal & Replacement 3,657,000 4,078,550 3,398,792 880,371 (2,518,421) -74.10% 21.59 (2) Capital Improvement 4,442,000 41,442,000 3,701,667 0 (3,701,667) -100.00% 0.00 (2) Debt Service 493,470 493.1470 411/225 376.1222 (35,003) -8.51% 76.24 Other Nonoperating 0 0 0 0 0.00% 0.00 Total Capital Projects Fund: 12,937,350 13,504,146 11,253,455 4,569,564 (6,683,891) -59.39% 33.84 Fund 402 - Refuse & Recycling Refuse and Recycling 530,010 530,010 441,675 397,602 (44,073) -9.98% 75.02 (1), (2) Other Nonoperating 0 0 0 0 0 0.00% 0.00 Total Refuse & Recycling: 530,010 530,010 441,675 397,602 (44,073) -9.98% 75.02 Fund 403 - Stormwater Utility Storm Water Utilities 351,690 376,615 313,846 263,907 (49,939) -15.91% 70.07 (1), (2) Renewal & Replacement 282,000 342,992 285,827 220,708 (65,119) -22.78% 64.35 (2), (3) Allocate to Fund Balance 45,520 45,520 37,933 Total Stormwater Utility: 679,210 765.1127 637/606 484.1615 (152,991) -23.99% 63.34 Fund 605 - Special Law Enforcement Police 74,920 193,872 161,560 106,259 (55,301) -34.23% 100.00 (2) Total Special Law Enforcement 74,920 193,872 161,560 106,259 (55,301) -34.23% 100.00 TOTAL EXPENDITURES - ALL FUNDS 31,282,980 36,653,581 30,544,651 19,781,429 (10,763,222) -35.24% 53.97 Notes: (1) Personal expenditures/expenses recorded as when paid not when accrued. Personnel paid 7/21/22 for the period ended 7/16/22. 15 days of personnel expenditures not reflected in July 2022. (2) Not all operating expenditures/expenses recorded for the services of July 2022. Expenditures recorded on a cash basis and adjusted at year end. (3) Timing in expenditures/expenses recording or/and recorded as one time entry. Page 166 of 499 Agenda Item #12. Ll r FTC +A 7 dt 4c, t TO: Honorable Mayor, Village Council Members and Jeremy Allen, Village Manager FROM: Jeff Snyder, CPA, Finance Director DATE: July 27, 2022 SUBJECT: Quarterly Investment Report The investment policy requires that we provide Village Council with a quarterly investment report. Attached is the investment report for the quarter ending June 30, 2022. This report is divided into four sections. The first section is this narrative, followed by a listing of the investments, the weighted average interest rate compared to the bench marks established by the policy or closely related bench marks, and a graphical presentation of the make-up of the Village's investment portfolio. Currently the Village's investment portfolio is heavily invested in the short-term liquid investments (21%) at TD Bank, the Village's current bank and in two local government investment pools, also liquid (50%) - Florida SAFE and Florida CLASS. This brings our total percentage of short term liquid investments to (71%). The Village's portfolio also consists of longer term United States Government Agency Securities (17% - Federal Home Loan Bank i.e. FHLB). The Village's portfolio holds two certificates of deposits (CD's -12%) from TD Bank. The portfolio's purchase price to market value for the Federal Home Loan Bank bonds demonstrates the effect of rising interest rates amid the Federal Open Market Committee (FOMC) efforts to control inflation. This resulted in an unrealized loss to our Government Agency Securities investments' market value. The market swings are the reason behind the Village's policy to hold investment until maturity. The change in market value is expected and anticipated. This is why the Finance Department does not invest funds necessary for current operations in longer -term investments. To hedge against rising rates we purchased a "step up" callable bond for which interest rates will climb each year the bonds are not called (3.15% increasing to 5.5%). The stated interest rate will be the yield recognized by the Village by following the hold until maturity strategy. The Village's portfolio performed well against the bench marks for the quarter in a rising rate environment. The short-term liquid investment bench mark was the Florida State 1 Page 167 of 499 Agenda Item #12. Quarterly Investment Report Page 2 of 2 7/27/2022 Board of Administration Investment Pool (SBA) rate which was 1.58% as of June 30, 2022. The weighted average return for our short-term investments was 1.23% or 35 basis points below the SBA (which included our bank deposit balance which normally has lower rates). The Village's longer -term weighted average return is 2.58% which is 27 basis points below the benchmark of a 3 year treasury bond, 2.85% (June 30, 2022 rate). Inflation continues to trouble the FOMC and they raised the benchmark interest rate by three-quarters of a percent in an effort to combat inflation. Investment returns will increase as a result, over time. Our weighted average maturity is 2.75 years and compares reasonably well to the June 30, 2022 3-year T-Bill bench mark. The weighted average maturity is 2.75 years which is well below the maximum set by policy for core funds of 5.5 years. The final graphical picture of our investment portfolio is provided to give you a quick over view to ensure that we are following the portfolio composition in our very comprehensive investment policy. I am happy to report that our portfolio composition is within the guidelines set. Please do not hesitate to contact me with questions, concerns and/or recommendations. 2 Page 168 of 499 Agenda Item #12. Village of Tecluesta Quarterly Investment Report For the Quarter Ending 6/30/2022 Net Realized Net Realized & Unrealized Purchase Market Interest Interest Revenue Interest Revenue Maturity Investments: Price Value Rate 30-Jun-2022 30-Jun-2022 Date Agencies: Federal Home Loan Bank Agency 170007000 9967560 1.75% 17701 (17739) 25-May-23 Federal Home Loan Bank Agency $ 27000,000 $ 1,993,420 3.15% 57950 (630) 26-May-27 Certificates of Deposit: TD Bank 11000,000 170001000 2.19% 3,285 37285 8-May-23 TD Bank 17000,000 1,000,000 2.64% 31960 39960 6-May-24 Cash & Cash Equivalents:## FL Class -Investment Pool* 375047056 375041056 1.40% 87056 87056 Liquid FLSAFE - Investment Pool* 570037467 570031467 1.40% 77888 77888 Liquid TD Bank** 37654,618 37654,618 0.85% 1,299 17299 Liquid $ 171162 7141 $ 171152 3121 $ 32,140 $ 227120 ## - Cash balance as of June 30, 2022 statements. * - Interest rate as of quarter -end. ** - Compensating balance which reduces banking fees - commonly called Earnings Credit Rate (ECR). 3 Page 169 of 499 Agenda Item #12. City of Venice, Florida Quarterly Investment Report For the Quarter Ending 6/30/2022 Weighted Weighted Purchase Purchase Interest Average Average Maturity Investments: Date Price Rate Interest Rate Maturity Date Agencies: Federal Home Loan Bank Agency 25-May-22 1,0003000 1.75% 0.35% 72 25-May-23 Federal Home Loan Bank Agency 26-May-22 21000,000 3.15% 1.26% 720 26-May-27 Certificates of Deposit: TD Bank 5/6/2022 1,0003000 2.19% 0.44% 72 8-May-23 TD Bank 5/6/2022 1,000,000 2.64% 0.53% 140 6-May-24 Total Investments $ 55000,000 1,005 Days/Maturity Weighted Average Interest Rate 2.58% Weighted Average Maturity 2.75 Years Bench Mark = 3 yr Treasury Bond Rate Cash & Cash Equivalents:## FL Class -Investment Pool* FLSAFE - Investment Pool* TD Bank** Total Cash & Cash Equivalents Weighted Average Interest Rate 315047056 5, 007, 888 r%r% r% r w -7 w 2.85% 1.40% 0.403% 1.40% 0.576% 0.85% 0.256% 1.23% Bench Mark = SBA* 1.58% Total Cash & Investments $17,177,116 ## - Cash balance as of June 30, 2022 statements. * - Interest rate as of quarter -end. ** - Compensating balance which reduces banking fees - commonly called Earnings Credit Rate (ECR). 4 Page 170 of 499 Agenaa item *i z. N N O N N Ol ti J O O n 4-0 E 4-0 � N N > 0 O N }' U � Q }, N � N E I L > O (D � �cn Q 0 L U � C7 U � � o`o 0 11 11 11 O LO Page 171 of 499 Agenda Item #12. Page 172 of 499 Agenda Item #12. r- 00 qct 00 ri N o can N l- cV r-1 M M Ln N N r- N O 00 M M N I� 1,D O �D M Ln r--i 00 Lli r1 I" qzi O r-i Ln 01 01 00 cM rl N N N N � f V � 00 Q0 r-101 � O \ � O \ N N N N N o0 Ln 01 r- Ln o0 f V ri O r-1 M f V O 00 O N I� M l0 O I� 00 qtr-1 M r-1 M l0 N N N 00 q;t Ln r-i � 00 O CY) O ri O O � M� fr-i V � N N N l0 l0 I� M O N M O N O O N N ri ri (10 ri M rn O M1:t �D N M M lD O M M rn qt r-1 m Ln Ln r-1 Ln m ri ri N ri N ri ri 3 Ln m I� N t-i Ln 00 m m O O Q f Q 00 Ln r- Ln � lD o r1 r-1 w r-1 � 00 O O L M L a S N r-1 N O r-1 M O r-I O N O N Ln 00 00 � r- O 00 'qT 9t N N 1;t M r-1 �r 4-1 Ln 0) ;* 00 N I� r-I r-I l0 O O 2 2 00 m � 4-J L L V V c6 N 0 N N M +-+ v D a� cr Q) N U C/(31 M ++ v LL i.i E o � O _� > U cn o V =3 U Ln O LL i U ) O a", 4-J E C37 m L O U M O aJ p E aj to O V V CO L N N N +J w N N m t X NC37 N 4 oc N >, — CID , _0 V v \ ai ai E > a_ ai Q � v U > >• O - L _0o a) N O N \ v +� N v °i Q� .N 4-J � N C fa a) DC L N . N fa _ �-0 fa (6 i C� Q! a--' V N -5 Q .� 4-}' C i V c/) U aA LU \ +j Q O Q - Q - ca � i.i >ai Q �U N N Q a N D c N A U aN! Q 4-1 � � �� p •� U" v O� E - O_ i- 0 oC LL w cn O 2 2 U a� .L 4-1 .� CL w O m 0 aj 0 = 0- C Q V c-1 D O 1 U= N QL C)a. aJ S cn i i O U Page 173 of 499 Agenda Item #12. M M Mr*_ �D r- r-i M ,o m M Lp 00 ko r1 rn,:i- m r-r- zt M Ln 00 M Ln (V (V r-i o r-I r-i 00 00 lc:l- r-i r-� M N r-1 I- N 00 r-i N R:t N 00 O r-1 r-I O p � p 0 0 p 0 p p ~ O N ~ O N 00 l0 M cV Ln r1 (.0 u) O lqT M 1.0 u) O M I- M Ict 10 Ln O 00 M f- I- N 01�t M Rt N r-1 O qt r-1 f V l0 qt � r-i r-i r-i f V r-1 r-1 r-i r-I In o 0 I� r-1 N N 0 d1 o LA N N N M M p O o\i O o\i H 0 N N ca 3 V Q fV r-1 M M N I� r1 I- M M Ln l0 r� O qzi- q* Lo rn N 00 O r-i m f-1 N M Ql r-1 \ o N 00 00 CV r-i N r-i r-i M r-1 CV N R�t r-1 r1 cM ca C7 l0 ++ 0 N M N 00 O O 0) H H 0 O O L � L Q) O r-I M O In M r-1 r-I l0 00 O r-i O::T M O O N M M r-i r-i r-1 r-1 O O M Q) N p l0 r1 r1 00 O O O mO O � L L a� N t tw N O c_ M = N \ � cc� M G V N I� .N OC Ln C: cn O 06 O 4-1 H — cn 'N i O =3 m bD v Ul _ O GG O M E N N E +-j N �--+ O O a••+ cn -W Ln _ �--+ Ln _ U Q) N ' V M= i "� 4-V - ro N O N U cc c6 U� Q a� U _ > E Q Z > � V N p i O� N O N (n N O\ N W — U N i i 4 0� C C7 O CD O N V) M f0 J N }, N U- �. Ln qA cn N , 2 � N qA � C aN-+ N N N cn N N V V O 0 ~u m 0U O O� O O N � O ra � O i O 0 O = E O C �� o ° � o o cv No v CA Q) Z (U U V O>i0- C V U _ O . O Q O O Q O O a- LU W I W c LL C6 J OC = Z M V) Q NL = a Page 174 of 499 Agenda Item #12. v � N � O \ O O r- M � N N00O � r- M�O N O O N r-I O N a) M 0 0 cjj txO O O 00 M O N = j O N 0 � O � O O O O O O O N N � c-I 0 0 000 c-I Ln O r-I r-I v CO 00 N � c6 0 O O O O O O N N l0 O O Lr) O Lr) 1 O r-I N Ln Ln O O O O Lr) O O O O O O Lfi Lr) O O O O Lr) O Lr) N l0 r-I � M r-I 00 r-I M 00 N l0 O M 00 14* lD Ln r-I lD t C CO cLr) 00 O O O rM-I O O O O O O Lr) O rq � r--1 N O O O O O O O O O N L V _N C L C V C O M V C � O 7w L M M a V & (A L O N \ N L N •- M a an M .� .O 4 � c N Cr OJ — N .E c� � L o 0 4- -_ �> O -0 U U _0 CA CA � L U L U N N 4-1 N ai � 0v U cn CD M �+ O L CO c O v) U(N U dJ Z }' Zn N N M a w Q) cn UO O cn � O � U_ Ln 41 M J a-J C i N ai N Q U M U� i v M \ V) O 0i U � ca 2Q, LL ca Ln. Ln QpO o , \ V U aJ .� � C6 }' u }' Q L Q '� N .O •� C O C L O G! C6 4A O = Q (6 d >- M O" Q O D f� M Q) O Q O O O O f6 u 2 OC cry O C7 O V� U U V) C)= U (A � 2� cn E�� m Page 175 of 499 Agenda Item #12. O O O 00 01 O Ln Ln r- O 00 O `� O IA rq N O � N 00 00 tZ � O i N M M � fV V 0 � O c-I M N t M M � N N r-I r-I N N rq N 01 M M +.A O \ O L n (V N � r-I CV r r-I � M M Ol N M Ln Ili N O N r-I M O O � N w 00 N 000 000 O � 00 0 000 N � \ � � w w T-i � w O M 00 Ln r-I r-I r-I MO r-I rN-I r-I CA 00 w Ol M L n Ln N M N 1;T w N � o N r1 00 O 00 CV CO O 00 M O O �q:T r-I r-I 01 Ol N r-I N � M 3 V M O r-I 00 M ri � F L r-I N N� 00 rN4 \ � M (7 cu o M Ln 0 o N o o 3 M � N N r-i O r� 00N ra 3 4a V a � i t 0 O u •O m E 4-0 \ i L a� Q N L a fa E cn v 4-1 O }' 4-1 v 00 •E of V) • U O O +J p 0 N E v � a) O� o �, _0 N V N 2 U v v c6 +-+ p _ •N _ a--, O � _ v N N O CON (D L U w N Y Q E E N O LU >a) > O N O V f6 '— � � fa •Vf L.L — N N U N cn cn U U Ca — c6 � +- O U N c� — L U cn In cn a--+ c /) cn C W i O 4 a) 0` O O U C` O LA Ina) 0 w • 0 - E U a. O= a-, iLL� G1 w a —co ) w U� U at at V= cn O Page 176 of 499 Agenda Item #12. c ri Ln r-I Ln Ln NM O N Ln r-I O M tA r-1 N O ryi � (� }1 N \ l0 01 M u1 O N r-I O l0 I� Ln I, * r� qt Ln � M Ln M cV M r- O1 O � 00 M O r� O r-I r� 00 r-I N O 01 N N r-I r-I l0 I, r-I Ln N ^ N r- N r� M N N O ~ N O ~ O O r-I O N O f6 N l0 O� N M Ol l0 O N u1 00 CD O O O Lr) l0 N 0 4-0\ Ol O M r-I r-I N M r-I Ql `� 00 r-I Lr) M l0 r-I O M O O � Q0 r-i M Lr) M fV r-I r-I I- N M r-I N r-I O N N � ate+ ate+ M N cc O OM � O 00 O N l0 � 00 � 0r,4 N r1 �0 � Lr) 0 ;;I- � r- 00 � O0 O Ol 0) f N O o � m 0)N 00 Cy)M oo M oo un un Ln � c14 ry r-I N N 00 O O O N J M M 0 r-I 0 r-I 0 0 00 � mow O l0 00 N. CS4 N r-I l0 O f� O N r-I I� LnLn r-I Ln Ln No � r1 � M CAA L V a) a) N � 0A � +-+ C: O O 0N E Vf N N u L 0 aJ w - ru . u U d O v bA 4-j-+ }' E a) E L > E v) ai E v U •� +� L a) v _-a U ' a) N E • cu Ln E NE -Qi QJ J Z'UO v UE aj d N >O _0 N aJ aj U Ul iJ QCcaan6�� N Q (0 4A ai V—r-I 00 O • •7te ay. N O con N L aa�� ai LL a� ai �_ dA � O +tv,0 LOfuu � M c6 U �, a U+, U UUOOcn OO cNa-n-J' a--+ a--+ Ln +-+ m V) ° 0 } N+-' aU L CL v Q cn }' a) O} , c v c O O 4- a1 a- Q >- -0 }, (U � U 0 iai a) 0Q Q L LLL L 0 l _0 L-0R3 a-J -I-)-+ � a� to n a) > p � 0O OL aL_- a a a J V) v > V) V) D w = w a- Q U OO Page 177 of 499 Agenda Item #12. 00 o Q Q \ Ln o m M Ln to 00 a \ s \ o m �D Ln w lD r- a \ s \ a \ a \ s \ r--i Z N R:I- lD r-I ri Z Z I� r-I N ::I- r-1 1:t r- 00 Z Z Z Z Z 00 M M O 01 M N N �� M 00 M r-I 00 Q \ O 00 00 O lD 00 � Q \ Q \ Q \ Q \ Q \ Q \ Q \ Q Q Q Q Q Q \ \ \ \ \ \ Q \ Q \ Q \ r- r-I M m m N r- N n Z � r-i I:t M N Z z z z z z z z z z z z z z z z M N r-I ^ Ln M r4 M Ln M r-I p�1 N Rt� l0 0w0 w N cM � l0 LO Q l0 r-i Q� r� �n 0) N � �/} r- Ln 0O 00 M M M O Ln r n N cV N N f V 00 N l0 M 0 M C1l 00 r1 z �n N N z 0 Ln N ri M .� r1 CV M .� 00 00 � r-I 00 Ln 00 r-I M N M , M Ln N N M N Lin M 00 Q0 l0 Q M M 00 Q M r-I r-I lD O r-ir-I N Mr -I O N M� M c-I M Ln 00 M z r i M M z w L Ln 4-0 a1 V) U 0 ate-+ a) E C: E C: E � OU a) E E 0 E O U 4-1 0 a) LAQ +j � Ln a) v O _0 a) Ln Ln O V) ca O Q a) >Z v a -C Ln +� tn v _0° }' N a M \ +� � M �- . v — +j O C:}' V) > v Ln r O �, N co O Q N Vi > >' u '— +-+ a1 v O v - � O c O .v 0= V) � s � cu4-j -le O 0L> O _O N O Q) O O 0= N (M 1 X a) u C:t]A u ca O n 4-J M a) a) Z v LnO � E E �� . V)Q) N% C:E O a-+ L O O a }, +-+ U U f6 On 0 v }' — a) > C6 fD CaA C:i O N U c6 = Q) O a--+ a-'' M w E� Lj 3 = U cn N O _0 Y 3 0 C� � O C: O c a O � O — ON� C - O +� N E +, U V a) N O a a0 O NOn Ln +N U + z a U 0 V) a) n V). a nV rc,0 N O O E E E `n iO 3 N w N Ln *— U O N = Cr V a) O CC vZ' 4-j n )6cn U - - O a-- b V)O -M cCn-k+ � uN Ln O aJ }.aa0U- Zn Q _N= OC U a) \ LA 4- � O O O wE bn N n C n C w +- � lzi � O a) NNc c� Q(� — U O ) ra � N � OO- b0 a) v 4- O a) 0)0 O txo O U CD C: cc- vU o Q J Q to Q z 0-LL z Page 178 of 499 Agenda Item #12. 00 r- cn Q) L C: v +-+ N O •� >' 0 c6 l"4 O L dJ Ca 4-0 �O O CD -0 L Nr ca -0 O ~ N u ma y-I fa .- ate-+ _ O N cu cn U c:U Q)L N N 0Q)a--+ O " C"D E 0 cn O a _v O Q Q cn U N �_ ca � � O N � Vj > -0 C •7 v N N O Q Q Q Ln N L (u MO C N C C i +-a '� v �\ M Rt (r-l.0 O Z Z Z -a•� p O C U 0 ~ 0A r-1 M L to O c6 L 0 ca C: a.., mro _ _ .p 4-02 Qz 01.0 DO 0) lD I� 0 M O O N C: cc L C O C: O O ca O O Q a+ a--+ O N lD N r- N N �a-+ Q U M Ln N r- X •� _0� z oc p v C: s O Q cli U 0 cu O ro u o n > v w s 4-1cn N " *k L w r_ � ate-+ +� L N O Q Z 00 N 1-0O N N O O O O O O a) v C: p cn > L L N — +-+ O • }' O Ol C)N -::I- rl LA Q O v v +, L- '> L p s °C +-, O Q L V) c6 Z, Q) p 'u U >. C: qA p CON a"' L N U Q)M N fa U C M� 4-1U U N y U Ca Q Li- ca C (n L N � � L O v }, O }, L Qj O0 ' ca M -0 p -0 C- +- " cn O N L � N L 23, 40A fa }, N dJ N ,> O -0-U � 4-1 a v Q E Ln o C)v (n � 0- C:L Ln N cu � O -0 0 � N u O CAD p L fB U) - (a w ca : — Q v N � CA cn O Q)ro Q) M c/Y E L +-+ L E N M t�A . v N- N U O _0 O N 1 a+ fa QN 0 N=3 c(aa /� O D — O }, N L +-+ } OE cn +iN U v(31 QE 4-1 N z p 41 cn N +1 _U ca C: }, + •O _0i n Z 0 i— v vi C N ccV) C cu Q _0 0 E "0 ' +- -C N 0 4-j cnLn ++ L L.L ' - �C O Q a--+ ,� QJ L co O ate-+ �, 0 o0 Ca � Mv ca iF3 u I L p L Q p U 0 a-J a-0 v> is O N N Q N (a +-+ U*)+-+ U _ — .� N N M 'v E p O Q L J dJ vI E w > u N a_+ fa -0 pC U a�"'., ' fa O0 O � p Ln ca cn L U N N ro +, N 0 t�A p ro i .--� N O � cr O cn p N p N >� -0 � N v N w c6 J c6 N L N +-+ v .c M O � O a N (n L '— Q S� aN., v `n N N fa N O 'n N �q—p cn 0�jp U cn O N C C c cn O 4 U v O— +, — O 0 N u N +-+ � v LOL N CL •> Ln0 (U ` a--+ O cliN ate-+ O N L L N .c6 U O m O O� E C:ca N 4J z +ra v fa �0 CA => N N U O � 'ra v N M U � c v � N v O U C > }, N N c0 U 4A v -0 fa H N 0) N .. .. .. L — S ca - . aL-+ C ra � O ro a� t1M0 � `� O N v N ra N C 'gin 'v� O ++ O +� O +� O +� CO U N � � � v � v p M •— c � 'C N .— � E � � CL� O O — �G w Cn v � O 'in m m u GJ U a1 U a1 U v L� cn +� aJ L 11A N fa L fa fa M p fa - N � C � — L O Q M p U 0 cn m w w w w U n > O O E E ca � � w w Page 179 of 499 Agenda Item #12. M o00 00 Li I- Ln M 00 N M ::J- m M N r-I N r-I lD N M Ql Ln U) N r-I Ln M N M 0 m M r-I al Ln N ro r-I rLn-I 00 lzt N N (`M Qq N 1:t M W r-I N i i O i O -0 M - 73 41 N N .i �X J= U .0 N � cn M cn V L i aj > +-+ .L N U C � V) 12121 � V) Page 180 of 499 Agenda Item #12. O 0) 0) cD U C C C C � N4-0 Q C C Q- C7 .� = U U- U- r � U E U Y Y w w a a � (� - Q Q Q U A 2 2 I - U U L L O � O O V) 1 1 1 1 1 1 1 1 1 O � 00 = N L CM CD O Z) Z) (r M M Q c~4 � O J J QO co N (� x > > cf3 N 4t L O O O O O O O O O O O O O J J M T- (.0 O� N O V) > > b4 N i LO O M O O LO M LO O LO O O T- OO Q 00 O K LV N It CD ce) O O N Op O O � � O O ti O > N O O L(j O O O O O O T— 6'} O pp 69 69- V} V9- dg O O O O O O O V O O O O � OO O Lf) U') O OO CD O O �_ V O O 6 M � � � rl— o 0 0 0 0 0 o � o 0 6 M O f` O O O O O O O pp O p O O T O O O M C0 co �� d N C L E Z E Page 181 of 499 0 co Agenda Item #12. Page 182 of 499 Agenda Item #12. Page 183 of 499