HomeMy WebLinkAboutDocumentation_Regular_Tab 04_7/11/2024 Agenda Item #4.
Regular Council
STAFF MEMO
Meeting: Regular Council - Jul 11 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.4 million, which represents 99% 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 (65%), 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
110%. Insurance premium tax ($307 thousand) to be collected at the year-end as one
distribution. Sales/use taxes are on target for eight months collections.
4. Intergovernmental revenues (77%) 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 eight months collections due to the half-cent sales tax revenue increase by 15%.
5. Local discretionary infrastructure surtax(68%) - collected at $365 thousand, which
represent 68% of the budgeted amount for only seven month's collection/reported period and
is above target for seven month's collections by 10%.
6. Revenues (Budgetary comparison) recorded in the General fund represents 90% of
budgeted due to the distribution nature of Ad valorem taxes collected at 99%, representing
72% of overall General fund revenues at 6/30/2024.
7. Overall Expenditures (Budgetary comparison) in the General Fund represents 64% of
budgeted. Not all the expenditures recorded for the services provided for the month of June
2024 and personnel expenditures recorded as paid not when accrued.
Page 12 of 118
Agenda Item #4.
8. Revenues (Prior year comparison) all funds increased by $3.1 million (14%) 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 $1.8 million (10%) 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 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
Jun 2024 v2
June 2024 Managers Report.ADA
1June 2024 Grant Budget Worksheet (2)
Page 13 of 118
4&02� Iilti## f� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/8
C acan LLCM' fF'F Period Ending 06/30/2024
DB: Teauesta
Fund 001 GENERAL FUND
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 468,788.89
Investments 11,322,868.84
Accounts Receivable 982,150.56
Due from Other Funds 0.00
Accrued Income Receivable 1, 978.14
Inventories 45, 648.60
Prepaids 113,768.29
Other Assets - Current 0.00
Other Fixed Assets 0.00
Total Assets 12,935,203.32
*** Liabilities ***
Accounts Payable (2,854.14)
Accrued liabilities 8,207.58
Retainage Payable 0.00
Due to Other Funds 0.00
Due to Other Governments 1,420.97
Deferred Revenue 810,074.23
Other Current Liabilities 413.55
Customer Deposits 0.00
Noncurrent liabilities 0.00
Total Liabilities 817,262.19
*** Fund Balance ***
F/B - Reserved for Inventories 0.00
F/B - Res for Encumbrance 0.00
F/B - All Other Reserves 0.00
F/B - Unreserved - Designated 0.00
F/B - Unreserved/Undesignated 0.00
Fund Balance - Ncnspendable 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 4,089,205.55
Ending Fund Balance 12,117,941.13
Total Liabilities And Fund Balance 12,935,203.32
Page 14 of 118
4&02� Iilti## f� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/8
C acan LLCM' fF'F Period Ending 06/30/2024
DB: Teauesta
Fund 101 BUILDING FUND
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 176,264.59
Investments 682,566.11
Accounts Receivable 38.71
Inventories (194.27)
Prepaids 3,866.58
Total Assets 862,541.72
*** Liabilities ***
Accounts Payable (219.70)
Accrued liabilities 0.00
Due to Other Governments 7,213.60
Total Liabilities 6,993.90
*** 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 1,063,643.93
Beginning Fund Balance 1,063,643.93
Net of Revenues VS Expenditures (208,096.11)
Ending Fund Balance 855,547.82
Total Liabilities And Fund Balance 862,541.72
Page 15 of 118
4&02� Iilti## f� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/8
C acan LLCM' fF'F Period Ending 06/30/2024
DB: Teauesta
Fund 301 CAPITAL IMPROVEMENT FUND
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 223,308.03
Investments 730,831.18
Accounts Receivable 24,467.49
Due from Other Funds 0.00
Prepaids 0.00
Total Assets 978,606.70
*** 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 (318,066.06)
Ending Fund Balance 978,606.70
Total Liabilities And Fund Balance 978,606.70
Page 16 of 118
4&02� Iilti## f� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/8
C acan LLCM' fF'F Period Ending 06/30/2024
DB: Teauesta
Fund 303 CAPITAL PROJECTS FUND
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 26,593.79
Investments 92,417.30
Accounts Receivable 0.00
Due from Other Funds 0.00
Prepaids 0.00
Total Assets 119,011.09
*** 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 (143,343.96)
Ending Fund Balance 119,011.09
Total Liabilities And Fund Balance 119,011.09
Page 17 of 118
4&02� Iilti## f� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/8
C acan LLCM' fF'F Period Ending 06/30/2024
DB: Teauesta
Fund 401 WATER FUND
GL Number Description Balance
*** Assets ***
Current Assets 0.00
Cash and Cash Equivalents 698,722.29
Investments 9,837,564.86
Accounts Receivable 817,197.94
Special Assess -Current 0.00
Special Assess - noncurrent 0.00
Due from Other Funds 0.00
Accrued Income Receivable 0.00
Inventories 254, 961.85
Prepaids 31,341.34
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 28,377,877.67
*** Liabilities ***
Accounts Payable (476.04)
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 47,725.00
Noncurrent liabilities 1,546,007.99
Other Long Term Liabilities 614,526.23
Def Inflows of Resources 538,011.00
Total Liabilities 3,177,653.79
*** 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 1,648,254.63
Ending Fund Balance 25,200,223.88
Total Liabilities And Fund Balance 28,377,877.67
Page 18 of 118
4&02� Iilti## f� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/8
C acan LLCM' fF'F Period Ending 06/30/2024
DB: Teauesta
Fund 402 REFUSE & RECYCLING
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 67,748.99
Investments 211,149.91
Accounts Receivable 0.00
Other Assets - Current 0.00
Total Assets 278,898.90
*** 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 231,326.53
Ending Fund Balance 278,898.90
Total Liabilities And Fund Balance 278,898.90
Page 19 of 118
4&02� Iilti## f� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/8
C acan LLCM' fF'F Period Ending 06/30/2024
DB: Teauesta
Fund 403 STORMWATER UTILITY
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 23,773.80
Investments 185,758.67
Accounts Receivable 4, 976.58
Due from Other Funds 0.00
Inventories (12.71)
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,489,131.03
*** 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 480,853.59
Total Fund Balance 2,512,538.65
Beginning Fund Balance 2,512,538.65
Net of Revenues VS Expenditures (79,782.32)
Ending Fund Balance 2,432,756.33
Total Liabilities And Fund Balance 2,489,131.03
Page 20 of 118
4&02� Iilti## f� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 8/8
C acan LLCM' fF'F Period Ending 06/30/2024
DB: Teauesta
Fund 605 SPECIAL LAW ENFORCEMENT
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 16,030.06
Investments 269, 685.37
Accounts Receivable 217.65
Inventories 0.00
Prepaids 0.00
Total Assets 285,933.08
*** Liabilities ***
Accounts Payable 0.00
Due to Other Funds 0.00
Total Liabilities 0.00
*** Fund Balance ***
Fund Balance - Ncnspendable 3,584.52
Fund Balance - Restricted 298,780.00
Fund Balance - Assigned 13,034.00
Fund Balance - Unassigned (0.94)
Total Fund Balance 315,397.58
Beginning Fund Balance 315,397.58
Net of Revenues VS Expenditures (29,464.50)
Ending Fund Balance 285,933.08
Total Liabilities And Fund Balance 285,933.08
Page 21 of 118
Agenda Item #4.
VILLAGE OF TEQUESTA
Cash&Investments Unadjusted Unaudited
6/30/2024
Cash and cash
equivalents Investments Total
General Fund#001 $ 468,769 $ 11,322,869 $ 11,791,638
Building Fund#101 176,265 682,566 858,831
Capital Improvement Fund#301 223,308 730,831 954,139
Capital Projects Fund#303 26,594 92,417 119,011
Water Utility#401 698,722 9,837,565 10,536,287
Refuse &Recycling#402 67,749 211,150 278,899
Stormwater#403 23,774 185,759 209,532
Special Law Enforcement#605 16,030 269,685 285,715
Total Cash and Investments $ 1,701,210 $ 23,332,842 $ 25,034,053
*Interfund transfer pending
Page 22 of 118
VILLAGE OF TEQUESTA
Agenda Item #4. REVENUE REPORT-CASH BASIS,UNAUDITED
YTD BALANCE YTD BALANCE
DESCRIPTION 6/30/2023 6/30/2024 VARIANCE %VARIANCE NOTES
REVENUES
Fund 001-GENERAL FUND
General Property Taxes 9,430,268 11,397,878 1,967,610 20.86% Increase from Seaglass,sales,&3%Homestead properties
Sales&Use Taxes 1,287,989 783,693 (504,296) -39.15% Infrastructure&Utility tax recorded in fund#301 in FY24
Franchise fees-gross receipt 377,402 380,410 3,007 0.80%
Licenses&Permits 6,110 3,590 (2,520) -41.24% Rental permits
Grants-Federal 49,047 20,770 (28,277) -57.65% Differs from year to year
Grants-State 12,489 24,144 11,655 93.33% Differs from year to year
Intergovernmental Revenue 748,339 753,783 5,444 0.73%
Chgs for Services-Gen Gov 162,889 166,466 3,578 2.20% Land development fees based on the projects
Indirect Costs 647,306 677,243 29,938 4.62%
Rents&Royalties 228,537 193,904 (34,633) -15.15% Sprint lease terminated
Contributions&Donations 14,984 1,450 (13,534) -90.32% Differs from year to year,timing in recording
Miscellaneous Revenues 25,831 23,182 (2,649) -10.25% Differs from year to year
Chgs for Services-Public Safety 811,850 864,693 52,843 6.51%
Fines&Forfeitures 8,598 10,960 2,362 27.46% Code enforcement fees
Impact Fees 1,764 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 84,325 132,758 48,434 57.44% Recreation programs fees increase
Unrestricted Investment Earning 290,451 331,681 41,231 14.20%Active investing,balance and rate increases
Other Financing Sources 42,930 57,601 14,671 34.17% Disposition of assets(fire truck)
Total General Fund 14,239,781 15,855,478 1,615,697 11.35%
Fund 101-BUILDING FUND
Licenses&Permits 552,072 520,594 (31,478) -5.70%Varies year to year based upon activity/projects
Charges for Services 1,909 1,214 (695) -36.40%
Miscellaneous Revenues 0 2 2 100.00%
Unrestricted Investment Earning 18,936 29,395 10,460 55.24%Active investing,balance and rate increases
Total Building Fund 572,917 551,205 (21,712) -3.79%
Fund 301-Capital Improvement Fund
Sales&Use Taxes 0 547,809 547,809 100.00% Infrastructure surtax and water utility tax
Unrestricted Investment Earning 19,542 38,564 19,022 97.34% Active investing,balance and rate increases
Total Capital Improvement Fund 19,542 586,374 566,831 100.00%
Fund 303-Capital Projects Fund
Unrestricted Investment Earning 156 8,187 8,031 5151.15% Active investing,balance and rate increases
Total Capital Projects Fund: 156 8,187 8,031 100.00%
Fund 401-Water Fund
Miscellaneous Revenues 30,805 32,176 1,371 4.45%
Grants-State 0 2,456 2,456 100.00%
Fines&Forfeitures 1,250 0 (1,250) -100.00%
Unrestricted Investment Earning 170,157 282,365 112,208 65.94% Active investing,balance and rate increases
Other Financing Sources 116,985 49,701 (67,284) -57.52% Capital connect charge based on the projects
Charges for Services 5,040,824 6,041,772 1,000,948 19.86% New Capital Recovery charge implemented in FY 2024
Total Water Fund: 5,360,021 6,408,470 1,048,449 19.56%
Fund 402-Refuse&Recycling
Unrestricted Investment Earning 1,201 8,661 7,459 621.03%Active investing,balance and rate increases
Charges for Services 563,359 580,694 17,335 3.08%
Total Refuse&Recycling: 564,560 589,355 24,795 4.39%
Fund 403-Stormwater Utility
Miscellaneous Revenues 0 9,798 9,797 100.00%
Grants and Contributions-Local 14,385 0 (14,385) -100.00% Differ from year to year
Unrestricted Investment Earning 1,016 9,966 8,950 880.93% Active investing,balance and rate increases
Other Financing Sources 7,375 0 (7,375) -100.00% Disposition of assets
Charges for Services 508,710 539,157 30,447 5.99%
Total Stormwater Utility: 531,487 558,921 27,434 5.16%
Fund 605-Special Law Enforcement
Forfeitures 194,548 7,543 (187,005) -96.12% Differ from year to year
Unrestricted Investment Earning 2,537 8,388 5,850 230.58% Active investing,balance and rate increases
Total Special Law Enforcement 197,085 15,930 (181,155) -91.92%
TOTAL REVENUES-ALL FUNDS 21,485,550 24,573,919 3,088,369 14.37%
NOTES are for differences grater than 109/6 and amounts over$1,000.
Page 23 of 118
Agenda Item #4. VILLAGE OF TEQUESTA
EXPENDITURE REPORT-CASH BASIS,UNAUDITED
YTD BALANCE YTD BALANCE %
DESCRIPTION 6/30/2023 6/30/2024 VARIANCE VARIANCE NOTES
EXPENDITURES
Fund 001-GENERAL FUND
Council 39,599 54,464 14,865 37.54% Computer system maint&supplies
Manager 226,059 272,067 46,008 20.35% Wages,sick leave buy back-retirement,insurance
Human Resources 289,321 311,192 21,871 7.56% Wages,sick leave buy back,employee recogn,recruit
Village Clerk 292,332 299,536 7,205 2.46%
Finance 559,335 582,925 23,590 4.22% Wages,ClearGov software purchase$24K
Legal 129,421 150,887 21,466 16.59% Differs from year to year based upon service needs
Comprehensive Planning 191,380 212,738 21,358 11.16% Full time hire
General Government 185,326 236,858 51,533 27.81% Other contractual svcs and insurance increase
IT 375,302 434,658 59,356 15.82% Wages,computer system maint&supply,contr svcs
Police Department 2,594,766 2,643,250 48,484 1.87%
Code Compliance 63,321 35,402 (27,919) -44.09% Vacancies
Fire Control 4,233,843 3,941,953 (291,890) -6.89% More expensive Ladder Truck purchase in FY 2023
Public Works 1,118,229 1,096,925 (21,304) -1.91%
Leisure Services 856,522 969,196 112,674 13.15% P/T salaries,ins,program fees and misc park projects
Debt Service 577,833 524,222 (53,611) -9.28% Pumper financed purchase paid in full
Total General Fund 11,732,587 11,766,273 33,686 0.29%
Fund 101-BUILDING FUND
Building Department 656,271 759,301 103,030 15.70% Regular salaries,comp abs,ins,insp&other contr svcs
Total Building Fund 656,271 759,301 103,030 15.70%
Fund 301-Capital Improvement Fund
General 0 6,975 6,975 100.00% Projects varies year to year
Public Works 18,708 478,161 459,453 2455.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 174,229 244,142 69,913 40.13% Projects varies year to year
Total Capital Improvement Fund: 192,936 904,440 711,503 100.00%
Fund 303-Capital Projects Fund
Parks 0 151,531 151,531 100.00% Projects varies year to year-Remembrance Park
Total Capital Projects Fund: 0 151,531 151,531 100.00%
Fund 401-Water Fund
Water-Administration 1,040,826 1,253,557 212,731 20.44% Insurance,engineering svcs,ins,comp system maint
Water- Production 1,558,974 1,498,218 (60,757) -3.90% Pension exp-timing in recording,comp absences
Water-Distribution 599,070 534,692 (64,378) -10.75% Pension exp-timing in recording,ins,water system maint
Water-Customer Service 224,256 226,433 2,176 0.97%
Renewal&Replacement 484,494 604,012 119,518 24.67% Differs from year to year based upon projects
Capital Improvements 1,812 295,251 293,439 100.00% Differs from year to year based upon projects
Debt Service 346,744 348,104 1,360 0.39%
Other Nonoperating 0 (51) (51) -100.00%
Total Water Fund: 4,256,177 4,760,215 504,039 11.84%
Fund 402-Refuse&Recycling
Refuse and Recycling 401,311 358,028 (43,283) -10.79% Timing in expense recording
Total Refuse&Recycling: 401,311 358,028 (43,283) -10.79%
Fund 403-Stormwater Utility
Storm Water Utilities 221,847 253,553 31,706 14.29% Engineering svcs
Renewal&Replacement 26,022 385,151 359,129 1380.10% Differs from year to year based upon projects
Total Stormwater Utility: 247,869 638,703 390,834 157.68%
Fund 605-Special Law Enforcement
Police 73,153 45,395 (27,758) -37.95% Differs from year to year based upon needs
Total Special Law Enforcement: 73,153 45,395 (27,758) -37.95%
TOTAL EXPENDITURES-ALL FUNDS 17,560,304 19,383,885 1,823,581 10.38%
NOTES are for differences grater than 10%and amounts over$1,000.
Page 24 of 118
Benda Item #4. THE VILLAGE OFTEQUESTA
REVENUE REPORT-CASH BASIS,UNAUDITED
FY 2024 FY 2024 75.00%
ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT
DESCRIPTION BUDGET BUDGET BUDGET 6/30/2024 VARIANCE VARIANCE USED NOTES
Fund 001-GENERAL FUND
General Property Taxes 11,524,090 11,524,090 8,643,068 11,397,878 2,754,811 31.87% 98.90 Historically,91%receipted bythe end of Feb
State revs two month behind,record-cash basis,ins prem
Sales&Use Taxes 1,350,252 1,350,252 1,012,689 783,693 (228,996) -22.61% 58.04 tax received as one distrib at EYE($3010
Franchise fees-gross receipt 530,938 530,938 398,204 380,410 (17,794) -4,47% 71.65 one month behind
Licenses&Permits 9,000 9,000 6,750 3,590 (3,160) -46.81% 39.89 special events,vacational rental permits
Indirect Costs 902,991 902,991 677,243 677,243 0 0.00% 75.00
Grants Federal 25,737 25,737 19,303 20,770 1,467 7.60% 80.70 Differfrom year to year,timing of collection
Grants-State 77,000 137,728 103,296 24,144 (79,152) -76.63% 17.53 Differfromyearto year,timing ofcollection
Intergovernmental Revenue 984,222 984,222 738,167 753,783 15,616 2.12% 76.59 Revs one month behind,l/2c sales tax above budg
Grants and Contributions-Local 14,084 14,084 10,563 19,267 8,704 82.40% 136.80 Differ from year to year,timing of collection
Chgs for Services-Gen Gov 208,645 208,645 156,484 166,466 9,982 6.38% 79.78
Chgs for Services-Public Safety 1,227,355 1,227,355 920,516 864,693 (55,823) -6.06% 70.45 Fire plan review fees,EMS Svcs below budg
Charges for Services-Recr. 62,500 62,500 46,875 132,758 85,883 183.22% 212.41 Rec program fees increase
Fines&Forfeitures 18,275 18,275 13,706 10,960 (2,746) -20.04% 59.97 Code enffines&fees below budg
Unrestricted Investment Earning 280,500 280,500 210,375 331,681 121,306 57.66% 118.25 Active investing,balance and rate increases
Rents&Royalties 188,839 188,839 141,629 193,904 52,274 36.91% 102.68 Timing in revenue recording
Impact Fees 8,169 8,169 6,127 12,005 5,878 95.94% 146.95 Differ from yr to yr depending on projects/permits
Contributions&Donations 10,000 30,000 22,500 1,450 (21,050) -93,56% 4.83 Differ from year to year events depending
Miscellaneous Revenues 13,205 13,205 9,904 23,182 13,279 134.08% 175.56 Differfromyeartoyear
Other Financing Sources 8,398 8,398 6,299 57,601 51,302 814,52% 685.89 Disposition of assets(fire truck)
Total General Fund 17,444,200 17,524,928 13,143,696 15,855,478 2,711,782 20,63% 90.47
Fund 101-BUILDING FUND
Licenses&Permits 608,708 608,708 456,531 520,594 64,063 14,03% 85.52 varies yearto year based upon activity/projects
Chgs for Sery-Gen Gov 0 0 0 1,214 1,214 100.00% 100.00
Unrestricted Investment Earning 15,000 15,000 11,250 29,395 18,145 161,29% 195.97 Active investing,balance and rate increases
Miscellaneous Revenues 0 0 0 2 2 100.00% 0.00
Appropriate Fund Balance 564,262 612,632 0 0
Total Building Fund 1,187,970 1,236,340 467,781 551,205 83,424 17,83% 44.58
Fund 301-Capital Improvement Fund
Sales&Use Taxes 757,055 757,055 567,791 547,809 (19,982) -3.52% 72.36 state revstwo month behind,above budgeted
Unrestricted Investment Earn 0 0 0 38,564 38,564 100.00% 100.00 Active investing,balance and rate increases
Transfers In 15,000 15,000 11,250 0 (11,250) -100.00% 0.00 FY2024 not recorded,tfrs recorded atyearend
Appropriate Fund Balance 481,909 481,909 0
Total Capital Improvement Fund: 1,253,964 1,253,964 579,041 586,374 7,332 1.27% 46.76
Fund 303-Capital Projects Fund
Unrestricted Investment Earning 0 0 0 8,187 8,187 100.00% 100.00 Active investing,balance and rate increases
Grants-State 200,000 200,000 150,000 0 (150,000) -100.00% 0.00 Timing in revenue recording
Transfers In 1,884,895 1,884,895 1,413,671 0 (1,413,671) -100.00% 0.00 FY2024 not recorded,tfrs recorded atyearend
Total Capital Projects Fund: 2,084,895 2,084,895 1,563,671 8,187 (1,555,485) -99.48% 0.00
Fund 401-Water Fund
Grants State 0 0 0 2,456 2,456 100.00% 0.00 Differfrom yearto year,timing ofcollection
Charges for Services 8,234,600 8,234,600 6,175,950 6,041,772 (134,178) -2,17% 73.37 watersales revenue recording one month behind
Unrestricted Investment Earn 0 0 0 282,365 282,365 100.00% 100.00 Active investing,balance and rate increases
Miscellaneous Revenues 37,272 37,272 27,954 32,176 4,222 15,10% 86.33 Differfromyeartoyear
Other Financing Sources(icl.loan) 8,620,000 8,620,000 6,465,000 49,701 (6,415,299) -99.23% 0.58 Loan proceeds,recorded when received
Appropriate Fund Balance 2,112,271 2,112,271 0 0
Total Water Fund: 19,004,143 19,004,143 12,668,904 6,408,470 (6,260,434) -49,42% 33.72
Fund 402-Refuse&Recycling
Charges for Services 592,403 592,403 444,302 580,694 136,392 30,70% 98.02 Historically,91%receipted bythe end of Feb
Unrestricted Investment Earn 500 500 375 8,661 8,286 2209.48% 1,732.11 Active investing,balance and rate increases
Appropriate Fund Balance 19,697 19,697 0 0
Total Refuse&Recycling: 612,600 612,600 444,677 589,355 144,677 32.54% 96.21
Fund 403-Stormwater Utility
Grants&Contributions 252,500 252,500 189,375 0 (189,375) -100.00% 0.00 Timing in revenue recording
Charges for Services 545,550 545,550 409,163 539,157 129,994 31.77% 98.83 Historically,91%receipted bythe end of Feb
Unrestricted Investment Earn 500 500 375 9,966 9,591 2557.71% 1,993.29 Active investing,balance and rate increases
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 598,913 558,921 (39,992) -6.68% 67.56
Fund 605-Special Law Enforcement
Forfeitures 25,000 25,000 18,750 7,543 (11,207) -59.77% 30.17 Differ from year to year,timing of collection
Unrestricted Investment Earn 1,500 1,500 1,125 8,388 7,263 645.56% 0.00 Active investing,balance and rate increases
Appropriate Fund Balance 138,161 138,161 0 0 0.00
Total Special Law Enforcement 164,661 164,661 19,875 15,930 (3,945) -19.85% 0.00
TOTAL REVENUES-ALL FUNDS 42,579,751 42,708,849 29,486,558 24,573,919 (4,912,639) -16,66% 57.54 Page 25 of 118
NOTES are for differences grater than 10%and amounts over$1,000.
A
THE VILLAGE OF TEQUESTA
EXPENDITURE REPORT-CASH BASIS,UNAUDITED
FY 2024 FY 2024 75.00%
ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT
DESCRIPTION BUDGET BUDGET BUDGET 6/30/2024 VARIANCE VARIANCE USED
Fund 001-General Fund
Council 74,640 74,640 55,980 54,464 1,516 2.71% 72.97(1),(2)
Manager 362,368 362,368 271,776 272,067 (291) -0.11% 75.08(1),(2)
Human Resources 456,599 456,599 342,449 311,192 31,257 9.13% 68.15(1),(2)
Village Clerk 447,453 447,453 335,590 299,536 36,053 10.74% 66.94(1),(2)
Finance 807,224 807,224 605,418 582,925 22,493 3.72% 72.21
Legal 195,000 195,000 146,250 150,887 (4,637) -3.17% 77.38(1),(2)
Comprehensive Planning 495,338 508,808 381,606 212,738 168,868 44.25% 41.81(1),(2)
General Government 328,215 329,212 246,909 236,858 10,051 4.07% 71.95(1),(2)
IT 535,503 549,931 412,448 434,658 (22,210) -5.38% 79.04(3)
Police Department 3,748,841 3,829,569 2,872,177 2,643,250 228,927 7.97% 69.02(1),(2)
Code Compliance 109,261 109,261 81,946 35,402 46,543 56.80% 32.40(1),(2)
Fire Control 4,764,250 5,501,292 4,125,969 3,941,953 184,016 4.46% 71.66(1),(2)
Public Works 1,626,076 1,682,545 1,261,909 1,096,925 164,984 13.07% 65.19(1),(2)
Leisure Services 1,201,176 1,210,152 907,614 969,196 (61,582) -6.78% 80.09(3)
Debt Service 542,250 542,250 406,688 524,222 (117,535) -28.90% 96.68(3)
Interfund Transfers 1,700,008 1,700,008 1,275,006 0 1,275,006 100.00% 0.00(3)
Allocate to Fund Balance* 49,998 49,998
Total General Fund 17,444,200 18,356,310 13,767,233 11,766,273 2,000,960 14.53% 64.10
Fund 101-BUILDING FUND
Building&Zoning 1,187,970 1,237,167 927,875 759,301 168,574 18.17% 61.37(1),(2)
Total Building Fund 1,187,970 1,237,167 927,875 759,301 168,574 18.17%
Fund 301-Capital Improvement Fund
General 65,000 65,000 48,750 6,975 41,775 85.69% 10.73 (2),(3)
Public Works 210,000 805,782 604,337 478,161 126,176 20.88% 59.34 (2),(3)
Parks 175,077 175,077 131,308 169,762 (38,454) -29.29% 96.96 (2),(3)
Tequesta Drive(Bridge) 44,000 44,000 33,000 5,400 27,600 83.64% 12.27 (2),(3)
Tequesta Park 250,000 250,000 187,500 0 187,500 100.00% 0.00 (2),(3)
Misc Projects 310,000 331,314 248,486 244,142 4,344 1.75% 73.69 (2),(3)
Interfund Transfers 199,887 199,887 0
Total Capital Improvement Fund: 1,253,964 1,871,061 1,403,295 904,440 498,856 35.55% 48.34
Fund 303-Capital Projects Fund
Public Works 710,000 710,000 532,500 0 532,500 100.00% 0.00 (2),(3)
Leisure Services 1,250,000 1,250,000 937,500 151,531 785,970 83.84% 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,563,671 151,531 1,412,141 90.31% 7.27
Fund 401-Water Fund
Water-Administration 1,711,930 1,832,727 1,374,545 1,253,557 120,989 8.80% 68.40
Water- Production 2,280,598 2,305,499 1,729,124 1,498,218 230,906 13.35% 64.98 (1),(2)
Water-Distribution 889,331 890,761 668,071 534,692 133,379 19.96% 60.03
Water-Customer Service 320,184 320,184 240,138 226,433 13,705 5.71% 70.72
Renewal&Replacement 3,753,000 4,382,290 3,286,717 604,012 2,682,705 81.62% 13.78 (2)
Capital Improvement 9,555,000 11,630,465 8,722,849 295,251 8,427,597 96.62% 0.00(2)
Debt Service 494,100 494,100 370,575 348,104 22,471 6.06% 70.45
Other Nonoperating 0 0 0 (51) (51) -100.00% 0.00
Total Water Fund: 19,004,143 21,856,025 16,392,019 4,760,216 11,631,803 70.96% 21.78
Fund 402-Refuse&Recycling
Refuse and Recycling 612,600 612,600 459,450 358,028 101,422 22.07% 58.44 (1),(2)
Total Refuse&Recycling: 612,600 612,600 459,450 358,028 101,422 22.07% 58.44
Fund 403-Stormwater Utility
Storm Water Utilities 373,318 459,261 344,446 253,553 90,893 26.39% 55.21 (1),(2)
Renewal&Replacement 454,000 701,196 525,897 385,151 140,746 26.76% 54.93 (2),(3)
Total Stormwater Utility: 827,318 1,160,457 870,342 638,703 231,639 26.61% 55.04
Fund 605-Special Law Enforcement
Police 164,661 177,695 133,271 45,395 87,877 65.94% 100.00 (2)
Total Special Law Enforcement 164,661 177,695 133,271 45,395 87,877 65.94% 100.00
TOTAL EXPENDITURES-ALLFUNDS 42,579,751 47,356,210 35,517,158 19,383,886 16,133,272 45.42% 40.93
Notes:
*Not included in Target Budget calculation
(1)Personal expenditures/expenses recorded as when paid not when accrued.Personnel paid 6/20/24 for the period ended 6/15/24.
Due to timing of payroll dates 15 days of personnel expenditures not reflected in June 2024.
(2)Not all operating expenditures/expenses recorded for the services of Jun 2024.Expenditures recorded on a cash basis and
adjusted to accrual at year end. Page 26 f 118
(3)Timing in expenditures/expenses recording and/or recorded as one time entry at year end.
Agenda Item #4.
N N N
\N +H+ Nl0 c I l0 00 N N M l0 00 00 00 L � 0) 0 00 M M � c N O
N � r-
1., O Lf1 M CT) rj N L! Ln
M riri � � M � N N -1 N Nl0 r-1 r-1 M Cr) N r-I fV fV
N N N
O O O
N N N
1" N Ln -zt l0 w W W M I- M O M W 00 N c-1 O N -zt Ln -�t M r" ri ri
-1 Il r, Ln w Ln f- Ln 00 w ::J- O 1�t O 1--1 -1 M N N I- M w M O
M M M 00 Ln O Zt N N M N M M ri ri ri
N N rn N
N N N
N N N
O ch O O
N ate+ N I I I I I I I I I N
O
H
N N N
N N W 01 w O 01 �t 00 fV (10 Ol ri M NC) N r-I w �
\ \ ri 00 00 Lr) M 00 � r- rl ri O M M 1l lV 1l 00 fV \ ri �t
M M Lr) 00 M I� 00 r" l0 ri ci r� N ri r 4 M ri M 61 Ln
N N N N
N N N N
nz
O
H
l0 1- ri 00 O N w ri 00 N rr) O 00 O 1l M Ln 00 ri O ri ri O
t t M N ri W 1, M O N lV t
C C C
ar ar ar rn I:t O ri I:t O
O C C
L L L
L L L
3 3 3
u U U
i
O
Q
w
W .1.1
E
w N
a, a c
i a � a �, w
Mo E E 4-1E
C as w a '0 1 v v u
C CL +� 7cr
_ O n3 c ^ (U cu C .� co
N 3 u -0 vi O U C C 0 H a- Lu u N o
ai 00
O m e 3 v v c E ° c p 'a a =
Qj U, a — — p
+� aj > v v, n o api ao
O o m oc E a) � +- p E
C E U Of o �, o L o o � .s v Q M v C v
i C CC - CL _ +- O U C O O M a1 c LL U -0 M O C.J
W aJ - fB fB U a) aJ of O Er � c Cr > U to to
oD M Ln 4+ L � ++ L LA Q � p M p E � oC U U O (n O � O � > VI VI
a1 aJ W a1 C O c� L O 4, L L Q 00 w U n3
4 _ E a � E _ a, +� L o_ L � 0 Co ai g Of 118
v 3 '� E '� E m i= 0 u v u E oo do p Q Q -0 4- eo
F- v a� o a� o o H a� > o a� v a� LL U oL o o v o o
z of U L� oc U M F- > U 0 w U Of a W LL m -j U z of = U U
Agenda Item $4.
< _ m � 0 � » _ co e m � 0 = 0 � � M
_ 2 m � mr1i E # It 2@ e � _
_ m o m e @
00 / 0 cn
rq 1 14
e * # e m m z _ m 0r m < e zr z » ¥ e 0 e 0 = e m
¥ e / m zT 0 m 0 m m c % m \ ƒ q \ q \ LO \
B t o 0 0 0
m � m
B o
� m
� � r-4 o r, 0 0 r4 » 00r14 m z Ln 0 m m m e » 0 #
m m N m m e q t » � _ Ln e # ¥
� 00 zt 0
m m m
3
Ln M E k
�
N # m o e z 0 0 e # 0 m 0 w 2 e e 0@ 0 m »
L 0 % / e »
0 0
0 0 0 m
E
L.L.
n
/ q 0
u = u
\ M
0 R 2 I
3 9 c 2
0 _ m
§ § V) \ g »
_ _ — % y
> L.0
\ / E u
\ m � o § / 0 u
m g = > \ ¥ s u
- 2 % 3 \ _ Tj /
\ ƒ % k 2 \ E 3 _a M / k E
s } E \ LU / 2 o E ® - e 5
e > e 2 ¥
_ \ —
/ / \ \ / \ } / L aj
f � / § (
° e - \ _ _ m ) « 2 >
\ j 7 g { � ƒ / § ƒ % 3 2 / \ § $ \ 5
a
/ / \ E f -cr -0 \ \ { n u \ e \ U / k 0 <
g 2 e ° \ / o \ _ » � bb / e M 0 5ro
G G / m / / m \ ƒ k � / § t $ / _cr k IA 2
_ e =
\ \ \ / 7 \ $ 2 2 / O § ) E / $ ) 2 \ ' e E 7 28 O 118
.-
_0 -0M m > � = I u E = U o \ > ±
0 0 ° % o = e = » = Q ® o a 2 � \ O c
Q u » > -j I 0 2 > < 0 u = 2 a- a- t I e 3 U 2
Agenda Item #4.
LO O 1- 00 00 L.0 M N L.() ri I:t W M 00 O lzl- N LA Ln 00 W M lzt M r-I -1 M t
O r-1 M N O �t M zt N N Ln 00 N N Ln 1� l0 Ln ri N Lf) M l0 r-1
c-I N 't ri Ln o N Ln M ri M N 1-
00
o H O cNI
O
o N
o O
N
1- 00 O -�t -�t ri c I --1 M - ri O LO ri ri LO O Ln M �t W 1--1 -;t 0) O) t Ln
N M -�t N Ln ri Ln M M N O Ln -1 1-1 L.O N Ln M c-I N Ln 1--1
c-I Ln lD M Ln N ri M ri M
. N 00
o N O
+�+ \
Q o O N
o ~ O
M N
O
C7
O co Ln �t M Ln O) M O r-1 LO -tl- LO Ln M ri l0 1, N lO N N M M O In O
N r-i r-1 Ln ri 00 O ri r-1 Ln Ln N ri Q) ri w ri ri ri N (14 Q) ri
ri N r-1 -zj- ri Lf) ri N ri Lf)
Ln 00
°r\i N
v,
� G N
� � M
N
o O
� N
M r-1 M w r-1 M O M Q) O o N Ln 00 O ri -zi- ri lO O r, ri M M O M 1, r-1 ri
c-I fV ri o t M N r-I
a) a a+ n
ho o O
O
3 0
co ar
LC C
3 N
Q U
U
v
a, aJ O
E +�
a1
N to O
3 N M d0
m a1
N ns z
E M )
O H 0
w 4' Ln
O O c° 4-
0
Ln a o �, Q (0 Ln v - v c
Q L L L ¢ 4-1
QJ
,�, 3 E 3 c0 .0 a1 � a1 j E
4-1
U M 2 i Ln LL1 CO C a1 M _00 Ina, W U M Lo U ¢ °n
ai Ln c •° O c v LL. > E ¢
U- aJ Y a1
Ln
Ln
U _Ln L^ a1 LU 3 U a1 4' C7 C7 O Ln > M
ca i Ln o \ �^ LL Ln v 3 c01 L a1 N °2S 0 LnLn
+, +� ',� c > an = v 2 •� c c `� a1 as
CC 0 cu vL U 3 O C
0 O 11 U Q L fC 7 ~ L m 0 O Ln U 1]0 C- U .O .O a1 3 0- O = ( L a1
o U � 0° c - v E o a1 o � ago ago a�i E °C °+�' i
u ai c ai a °� +' a M a1 Q aj 0 0 oc U Ln
a a�
Na z ¢ z LL c� v}�i v .Q a>�i �° ° m o°Jc o°'c .� Q Y `o u o _ i Of 118
Ln E a O O Q E O O a w w w H � � a w 2 Z Ln
Agenda Item #4.
N
c-1
N N
IA C14
(a N++ \ N rn c I r-1 06 � � O O O O O O O O
L 1 0 OO O d LD M O Ln 4+ LD O O O
O -I -, O M Ln Ln Lf N 111 LO
N 't M ^ 00 N N 00
~ O ~ O
N N
ci c-1 -zt Ln O O l0 - O O O Ln Ln O O O O O M
c-I 1-- O O r- Zt O M ltT M c-1 w M O M 1, M N M O ZT Ln
M M M I, ci 1, 1-1 00 00 Cl 1- N Ol rl M LO O M N
N N N Ln M N N LO N `1
f0 N ^ N
N
~ N N
k.p rn o 0 0 0 o m o m o m o o m o 0 0 0 0 0 0 0
rl Ln Ln m M Ln M (n O Ln O N 00 Lf) O O ;t O Ln
lD -i LD 1- lD r- N lD 1, M 1, N Kt M
c-I N .--1
N N
Q0
M N M
N � N
N N
S L N Ln O M O 00 O O Ln Ln N
c-I N c-I c-I r, N c-I M c-I
C C O
O O N
N � �
C C
L L
3 7 U
U u O
O
ca
Gl
U
N
Y
i
f6
a
0
G U
M \ ro
i
U M L
w a °'
bz
°'
f0 L �
N L
0 or
V + f0 U d i C a 0 w U Q
in a 1A > O O O a ro O fu
E a c0 f6 - O O °C -0 4M
t t In = O +'
N i 4-1 U C Y C (6 �
J + Q O - Q _ d d N to j O a) QjLOl O N
uz '� d v N n a 6 w -j E w = LLn
a c L� a O a co ,, c c 3 ru c 3 ro m t `°
n H a 'Q E O LA U Y N +1 o Y D_ U a O a Q o c X_ (7 •- " u c 0
o O LA V) t o u '+Z ii +, a s _ = r3 a s
L ut Vl O Q- C ++ CJ [6 L f6 C tiO D_' +"' VI \ C +•� L L U C L l6 f6 a N
a a a Co a o > > L 3 of118
+� a t Z a a c +� +� a n
o Q o Q- � u v ago a c E w s E c s o o _ Q a
a L a L p GJ f6 O 7 Q c6 M CL a > O a O O M L O O co C >
Q 2 a C7 LL. OG H Ln 0 > � C7 0 H C7 LL U (D C7 m _, V Dc a
Agenda Item #4.
1- 0 1n 0 0 0 0 0 0 0 0 0 0 0 00 00 0 0 o 0 o o M No 0
n N N 00 O u1 O Ql O M O O O O O OzT O O O O O O 0 � \ O�
r-I r-I r-I N 00 M M lD I� 1p p O N
N
M 111 O 1I1 111 O O O O O O O O O O O O O O 0 r-1 O O O O O O N
1, ri N l0 r-1 Ln 0 -:t O 0 00 Ln M O O O O O 0 -ZT O 0 Ln 0 1n 0 -1
ri w r-I r-1 -ZT V1 00 O N 1- N w r-I 1, Lo -tT
ai Lri cvi -1 r 1 r I N
O o\i 00
to
O
N
1n O O O 1n O O O O O O O O O O O O O O O Ln O O O O O O O O
lD —i Ln 1" O O O M M O O O O O .;t O O O
.-I 't M Ln Ln 00 1n N 1, Ln n Ln
f•�'f � a-I c-I r-I c-I
r-1 M
N N
O
N �
N 1n
N N
O
N
O O O O O O O O O O O O O 00 O O O O O O O O O O O O O O O
1n s
r� c
0
E o
4+ N
al 00
L
L
3
U
an �
L
D E
L M
Q OCL
E U w
fu v,
tw U
c i M U
c N
O a' o � a c
+� Ln
Ln v co >, M p v,
i a1 +� c O j U
2ai
Ln
L co V) O +, ~ u N w co L E a
Q O v m o- = c a > V, a M
U U Q1 = U � m +, M W W Y w 4_ 4- N 4� O_ i in
j ai
to c O O O c > > pp ^ O L cca U N p +J
U H d 0O �n E Ln N Y N LU d Y aJ Y LL ~ � cn N H a ro U chi
co ro co _ E - Q v, v c co u W Z3 co co c = t O C ai
+ + +� ro ro +� +� +� to 2 '+�
O Q c ra V ra L (A U) > W F O in p 3 u
a a, aj a, > N > a m a, a, L > �, P 1 of 118
U M = M -0 Q Q Q � +, Q U v a, 'c� +° a nn v c w
U s s Q - > u Q a s 0 0) O s s '- c 4 o Y c = L O
U aJ O N O O ro L w O Q O aJ w O [6 aJ [6 ca O
H H H H (D 0' � o' w i i N H 1L cn w � H 2 to w co a o' w o0 w w U
Agenda Item #4.
N 00 00 O M M I- N u Lf1 (a N l0 Lnr, O m O `� N
M tO LO r-I O n M N M Ln Q O O m O O ^ m m m rn m
N r 1 N c-1 N M M Ln o
N
0
M
� N
O
M M N M M w O M N f31 N M O M Ln N M N O M O n M L O
Ln LO c-I l0 O M GO ++ \ N N c-I 00 O Ql c-I
M Ln N M N l0 O N E r-I M N 61 M N I� 00 Ln N� 00
� N
O
N
� N N N
M LD 00 p O r� r-1 n M N I, O Ln .--1 r-1 O I� Ql M O O M NO 00 r,
O N 00 M -1 M 00 ++ \ Ol O ri r-I
N 00 00 r-I Q I- � � 't M ri LO M 1, r l lD
Ln lO -i Ol N a) � � O N N ri r-I Lf) ri M r-1
o -! ~ O
(g rn N
O 41
b,O w r_
-a Ln O
3 �
a) '� N M 00 O Ln 0 0 ^ co 00 } M O O O N
00 N N Ln 1- M CQC M r� O O 00 N � N GO l0 c-I M r-1
O L
u L
u O
Q U
s
c
O
� v
c >•
O u
v
N 73
cr
i N
3 °' ai v
+� c UZ
a
>
Q u (n
Q)
3 C N L
a a fa .� a a
+, 3 " " a v u
a °
O N rB N
v 0- = o_ a 4- Ln >
U bA Ln41 N w \ N u N •" 00 O ru
` N = N ajLn> Q O O C L -o E E N i M W O O L cO
In Iu CA ..L O " �+ •" .� O4 a) C L C N p - " C N
Lai
C w i ° fD W " " " " " N OC C f6 C 4) N C
L° 41 i +' a1 U O •� ++ O C v O O O N O d N O Y dA Q O_ 2 O 00 C7
f6 O aC L f6 f6 4-1 f6 .� Q � � i � � N � a1 � " ?) � O +-' N ° +�
_ fL u 0C M i
u LL L � a c� � c� � o � o- �, �, 0-1 � � v � O_ frs v 2of118
o v L °
a Q O O a no ao Ii a J in N w O_ > M cn � U) Ii
Agenda Item #4.
N O
M IZI- Ln Ln
n
N r Ln ^ n NM N N No r- � Ln n Ln 00 M M M -, -i V1 r-1 � OM N
u1 - i O lD (.0 M M tD .-I M NU) 1l
lD rl N N 1-1N Ln L/1 Ql i--I M -Ic-I -1 N N U) N U) Lr) -i lD � LM r-1-1
N
O Ln
N �
O
M Lq
O V1 'T w N 00 ^ Or
c-1 N N Ol ^ f6 N l0 l0 ^ l0 .--� LI1LI) Dl M W � N a) ,� � Ol N � C)
lD I� ++ M Lr) 00 O 1� 00 tD a) Ln M
Cn N M l0 N N N c I N M M rq Lr)rq N a) M Lr) lf1 M
O 00 m
N Sri
M
� O
'^ G 1r) 0 0 M M Oo Ln
c-I Ql O M r-I N }M+ fV M M M M M N fV 01 i--I Ql M O O 00 M N I\
l0 M m 1r1 O N N m o0 c I N N N Lj N
N M N cn 'n �p N Ln
N �
r-I
U
a) LJ n O n m n N
O N M lf1 O M M � O N N I� N O O +J W M M M Lr) M 00
rl ri 3 rl 't a) M N lD c-1 N N Ln M
>- M N c-1 �p N
O
Z
O
CL
C V }
N = u V)
E bD
p N a)
U +—, + _0Ca
a, a) CLO + Z;Q 4 J > ra
(3) 3
v a) >, o 4-1
a 'u p
a, CL v � o o
v V) c) ccO 0 O �O M
4- Q U lD C G (UbD U coC
0 U M +J C — C
Y v 4-1 Z L n O v a) �
al C to 0 N ~ _ `) > O +
U aO.+ CO C bA O in �n N N V) N >,
C in N
O U N a) ra M v O a) a)
Ln bOQ n (�6 a) > a) Q CL bA Y O U f0
L a) C _ U 3 U
1 U _ CC C E E > n in co
L > a) v
C U .S C U u u J `1 a) m Qf 7 30
C L O ZN f6 a1 vQ- OC a)p a — Oa ft C) N
O N a M bA v4�
n n n Ut l biOa) 4 � 4J f6 C
a) a) n 0 C a- aU Ln 4-
0 ; O
a p a) U OO O V) Eu +�
a) a) Q Q N L L CObA to a) +1 + n M +� G t C
c U Mfuzi U O O O C a) c a) a) LL OU a) E U M O - O p a) � C 0
�, ai LnN N U a O U a) > Q a) DC a s N aci o U- 12 v
Q ° �_ v c = ai
v o = v �_ a Y " �° °°eL 3 of 118
L ci to u� a) O a) C 7 -0 u� L J m C U a) a) +1 L U 11 — I.
O c-I C a) > L bD O L a) L bA N -C 7 a) a) bp bp O a1 3 n5
(n CO LU 0_ LU d a u 0 w 0 a � a a Q Z U a LL
Agenda Item #4.
M 1l- Zt LO rl LO Ln N f� l0 O
1� ci M M Q M Q Q O
M 00 00 -I M 00 00 lD N M Ql 1O � -1 � Ql 00 �
� M c-I N r- Ln Ln Ln Ql LO Z N M z 1- Z (V -i N
N N c-I l0 r, M
N
ro l0 N 61 M M w � M Q0 00 Q Q O Q O M Ln
c I O Lnc 1
N c-I O M 00 lD L n c-1 00 CO M (.0M Ln N 00 00 O M ^ M Z Z Z N l0 c-I
M M M M .-I Ln W � Ql rj c-I N M� N N c-I
N �
L
Ln
Ln 00 Ol 00 Ln - Q � Q � Q N r, 00 ci Ln
rN-I Ol `� M M M Ln l-D � O Z Ln \ � l0 Z O Z �O M M N N
r, N M O 00
M
l0 00 LO � W � Q Q Q Q Q Q Q Q Q Q Q Q Q 00
LO O p M c-1 w \ \ \ \ \ \ \ \ \ \ \ \ O M M O O N O O
'= N -1 r-I Z Z Z Z Z Z Z Z Z Z Z ZZ
L L
O v�i O
r0 O
aj Y O a)
= 7 _ >
a] E a1 M N c QJ a)
41
41 v V
Q H V) O
O v ro �O Q > n a1 Q p
to
L cu
Q > O 0- N Oai _ O r0
(f6 u 3 LO L vi Y
N O X N x 3 j ++1 0 O
O n +- r0 a1 > L m O aJ Cf a) aJ U 3
3 Q p N � O Vi ai
u > p Q
L
" 0 E VI + L 4 0 a z u O -0 Q
L ° 3 � c M u = a) v L v
N ai a) 3 N °' O ai E �, v' cLo v w - N +'
O c a) 0 v E — c o v a, u c v 4'Ln bz
r0 N O a N �t ra oC `. 0 O j ° N Q N a) Gc0 (�j
ra
V)
tao
NN co V) rLa ai O v, c E aci aci � Q >°. m ') ti ^ -- Q aj a)
o aJ c on un t — L 0 +J E E V, c +� Y H ai N � E > uo
a E o ns w o a � ° v a� ° 0 .o O c O a a' v +� ra ro a L
c V) n n w z a a) c t � a`) n c v ai z ai o U a
ao a, a� _ ato w ° a, on ai aj -0 o E i n c c c c
+° a c n ° E c c o o Q n�o a^ a� 0 0 0 O
aj
fu c ° o E O O �, W _ a, o W w o f ° c ° _C O W c M Y 4� +1 Page 34 Of 118
n _ oc U _ x U a x x � u x x x 11 _ 02 LU v � 0- o u u u u
x i L o a) a, E a� v a)
a U cn W W W W
Agenda Item #4.
a O a 0 N a
a
LI • ~ L L a
—0 > a N M O CN
O Q M M N
N O
QU -0 ro ro O OO -Oao ro O U U U. c O
a Q d JO = Z G � N N V N vIs
U E M U N
N a Ln U L 4 � .L 'O (B
O to a " W J in ° L 3 >
(n N (6 a 'c m f6 a C a N
Q L {/I C C -O Y N
Q — � Q +L+ d 'p C = vi `LL•' N LL C
O � C aLn u a m � L v 0 �--� 00 � � � 00 7
z ° m L to h p `� '� ate-+ C ° ! ^ i--I N L!1 N M .-I n 00 n C3 tD N O
U a (L6 (6 M \ U
U Ln W .L +�., U pi
�j W Q (n C H O C L a N N O
iJ U O u � In p O C c N C
LL W a V N a a-.+ M U Q 'p N
oC L a � a Q
a a U
V Vf N — L C `�
Qj
ZA
ai
O? tea,, 'OU wd - Q)QC Z 4'
rn
L •NO
Itt`1 M o o 3 EZ Q o u o ooQ o - Ln r LD M M NNN o
LJ , 0
� ro N CO N � N Lf)m O
O L U N d 00 :Ll O
0 Ln Q E C: Q +� > v ° ° a Q f6 oCO
N
ai
(� U _ o a a
3 LL N � 'n a vi N C: J as+
a a Y L �, u u ._ -0 M c0 Ln Cc
i..� 0 0 N E M (0 f0 .0 '� - Q m G N 00 � G
to C i� V +�., +' ar O O r, `� 00 N l0 � M O Ln
a (6 O c L V1 ro > L() r I Ln
r N N
N [6 C C ro M +' N +' U C6 U a a
U U w JE L w U -p N �0 C 3 3
ai
b0 a
O_ a) � a p cu a a
to n C a V, > f6 } E LJ
ZO ru CL Q OLA � aj (4-/1 E v ` M M w
O 4-1 �j
> a a) !n (0 L Ln U bbD t0 r0
a' O — C O O M M 2-1
a- - ^J by O
W ` ° E .0Q Co , M C , E v c O
o
a�
c IA M tea) o O W QJ w > o u b�D " u 3 E E
+, a v � v L o o aJ
of o v-)a a) a) E aL O a' - ) O
� Z NO vC n In N M M
Z E Q) Q
IA Y Oo6 N U cHV QOo in 41
ro L \ l0 c6 a a vi LL -O -O C }, M +.+ *' 3
W N m a O- C L O U 4 'j 'j M ..
N E a M O —� f6 +J 1 L L
L �a•+ Z E a L � L a rr Q) a a ++
n a H co E M c V O a) E c `n ^ v aci
Q E LWu d a O U LO vI O f6 _tn +' -O aJ N N ++ CC�i
O N L CC a E Q 0 U (6 a Y p E LL L}L L
N C a VI C L
C o p_ 4J E L L S O a) >, a) i L 06 o2S N O fC
C L a L -0 ++ a O +, O V O L a Q.
-W V a a (0 C C L O- - ' N N d O ^ +a)
N +-+ a 'O Q bA G1
Q o c O Q � E ro ° L O LL LL u a) +' C a)
L p a co a; L a E � ai a a N v, ,� * M a a) O GJ Cy
c a O bA �' Q ahe
! O �= 0 E
cY0 u N O a) cU0 (bn
2)
(A CL Ln
U � p c 'ro a O `�a) Ln rLa m a i c U 'L U ° 0
ro o u a o - a) m L w � E L °� o u a) o P Of 118
a+�) 'o vi v vi ` o a aj v o a�a, M 9
U a O E � cn 3 w V w > - n
Agenda Item $4.
(
c 2
� F, r, /
\ / � 7 \
2 r-4 \
§
� / « \
C
(
\ / m e o
>- m Oq \ M,
/ w « \
] m
�
§
\ $ $ / 2
\ \ \ « tio
/ u
e /
/ \ / b
\ — e /
ƒ
e &
:E M \ z , Q E
0
0 § \ \ \ \
[ / \ _ k
/
u L G E 3 t
\ § u m ƒ 4-1
k 3 §
\ §— e \ §
a �
a k ( J 7 � \ t
Ln G 2 / /
[ /
\ � \ \ / \ \ \
3 o G
/ \ � � �
\ 0 \ � » /
� — g = 2 = } } \ { v
u 2�, / c ^ » %
- E \ c —0 §
E \ 7 / / A Page 36 0 118
} ' 2 { , uk E •�
2
\ / $ :E / 2 k
11 INS Ii I III I