HomeMy WebLinkAboutDocumentation_Regular_Tab 11_10/13/2022Agenda Item #11 0
Regular
ti
STAFF MEMO
Meeting:
Staff Contact:
Manager's Report
Regular Council - Oct 13 2022
Jeremy Allen, Village Manager Department: Manager
1. The Financial Reports presented above are recorded on a cash basis 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 $412 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 (94%), 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 fire ($172
thousand) is expected to be received and recorded as a revenue of FY 2022. Local Business
Taxes collected in full. Overall, sales/use taxes are above budgeted for eleven month's
collections.
4. Intergovernmental revenues (110%) 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 eleven month's collections due to following increases: municipal revenue
sharing by 18%, half -cent sales tax by 20%.
5. Local discretionary infrastructure surtax(101 %) - collected at $470 thousand, which
represent 101 % of the budgeted amount for only ten month's collection/reported period and is
above target by 18% due to the increased State revenue collection/distributions.
6. Revenues (Budgetary comparison) recorded in the General fund represents 93% of budgeted.
It is below target budget due to State insurance premium tax fire ($172 thousand) is expected to
be received and recorded as a revenue of FY 2022 and fire truck financing budgeted but not
received. Note: The Village will be recording revenues for FY 2022 if collected within 60 days of
the current fiscal period.
7. Overall Expenditures (Budgetary comparison) in the General Fund represents 77% of
budgeted. Not all the expenditures recorded for the services provided up to 9/30/22 and
Page 133 of 478
Agenda Item #11 0
personnel expenditures recorded as paid not when accrued. Note: The Village will be recording
expenditures for FY 2022 within 45 days of the current fiscal period.
8. Revenues and Expenditures (Prior year comparison) all funds —data is not comparable due
to FY 2021 balances adjusted/audited and FY 2022 will be recording revenues for 60 days and
expenditures for 45 days of the fiscal year end.
This document and any attachments may be reproduced upon request in an alternative format by
completing our Accessibility Feedback Form, sending an e-mail to the Village Clerk or calling 561-768-
0443.
PROJECT NAME: NA BUDGET: NA ENCUMBERED: NA
Proposed:
NA
PROJECTED TOTAL: NA
Projected Remaining:
NA
Sep 2022 v2 reports
2September 2022 Managers Report.ADA (21
September 2022 Grant Budget Worksheet Amended
Page 134 of 478
I�r1 BALANCE SHEET FOR VILLAGE OF TEQUESTA
A 0acaniat� 0
Period Ending 09/30/2022
DB : Tec{uesta
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, 800, 196. 77
6, 494, 020 . 50
373r662.84
0.00
0.00
86,484.53
413,327.11
0.00
0.00
9,167,691.75
(192, 949.43)
397, 476. 50
0.00
0.00
1,393.83
89,730.66
0.00
0.00
0.00
295,651.56
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,665,660.61
8,872,040.19
9,167,691.75
Page: 1/8
Page 135 of 478
I�r1 BALANCE SHEET FOR VILLAGE OF TEQUESTA
A 0acaniat� 0
Period Ending 09/30/2022
DB: Tequesta
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
228,719.69
603,422.49
2.56
255.23
4,328.60
836,728.57
(4, 783.19)
(56, 837 .23)
4,412.38
(57,208.04)
0.00
11,454.70
864, 932. 12
0.00
876,386.82
876,386.82
17,549.79
893,936.61
836,728.57
Page: 2/8
Page 136 of 478
I�r1 BALANCE SHEET FOR VILLAGE OF TEQUESTA
A 0acaniat� 0
Period Ending 09/30/2022
DB : Tec{uesta
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
106r367.19
0.00
0.00
0.00
0.00
106,367.19
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, 924.07)
106,367.19
106,367.19
Page: 3/8
Page 137 of 478
I�r1 BALANCE SHEET FOR VILLAGE OF TEQUESTA
A 0acaniat� 0
Period Ending 09/30/2022
DB : Tec{uesta
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
136,361.42
0.00
0.00
0.00
0.00
136,361.42
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,413,732.69)
136,361.42
136,361.42
Page: 4/8
Page 138 of 478
I�r1 BALANCE SHEET FOR VILLAGE OF TEQUESTA
A 0acaniat� 0
Period Ending 09/30/2022
DB : Tec{uesta
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, 990, 818 . 36
3, 930r260.21
580,180.97
0.00
0.00
0.00
0.00
223,131.07
40,410.66
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,426,263.59
(32, 995. 13)
(314, 972.38)
0.00
0.00
2,202.12
0.00
391,728.09
0.00
42,430.00
2, 344, 386. 67
415, 756. 86
478,636.00
3,327,172.23
0.00
0.00
0.00
0.00
11,584,763.87
0.00
376,728.00
500,000.00
7, 760, 148 . 90
20,221,640.77
20f22lr640.77
877,450.59
21,099,091.36
24,426,263.59
Page 139 of 478
Q ��1111 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/8
A racanat� Period Ending 09/30/2022
DB: Tequesta
Fund 402 REFUSE & RECYCLING
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents
113,075.74
Investments
0.00
Accounts Receivable
0.00
Other Assets - Current
0.00
Total Assets
113,075.74
*** 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
18,791.98
Ending Fund Balance
113,075.74
Total Liabilities And Fund Balance
113,075.74
Page 140 of 478
Q ��1111 0
BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/8
A racanat� Period Ending 09/30/2022
DB: Tequesta
Fund 403 STORMWATER UTILITY
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents
30F593.62
Investments
0.00
Accounts Receivable
6,677.92
Due from Other Funds
0.00
Inventories
180.14
Prepaids
517.71
Other Assets - Current
0.00
Other Assets - Non Current
0.00
INFRASTRUCTURE
2,003,395.44
Buildings
0.00
Improvements Other Than Bldgs.
0.00
Machinery & Equipment
17,118.63
Construction in Progress
0.00
Deferred Outflows
25,859.00
Total Assets
2,084,342.46
*** Liabilities ***
Accounts Payable
1,687.55
Accrued liabilities
(24,309.89)
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
14,769.37
Def Inflows of Resources
10,773.00
Total Liabilities
2,920.03
*** Fund Balance ***
F/B - Res for Encumbrance
0.00
F/B - Unreserved - Designated
0.00
F/B - Unreserved/Undesignated
0.00
N.A., Inv in Cap, net of debt
1,236,387.06
Fund Balance - Unassigned
740F011.78
Total Fund Balance
1,976,398.84
Beginning Fund Balance
1,976,398.84
Net of Revenues VS Expenditures
105F023.59
Ending Fund Balance
2,081,422.43
Total Liabilities And Fund Balance
2,084,342.46
Page 141 of 478
I�r1 BALANCE SHEET FOR VILLAGE OF TEQUESTA
A 0acaniat� 0
Period Ending 09/30/2022
DB : Tec{uesta
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
50r979.67
80r561.70
0.00
0.00
8,540.61
140,081.98
1, 661. 80
0.00
1,661.80
13,352.35
143,688.75
0.00
0.00
157,041.10
157,041.10
(18,620.92)
138,420.18
140,081.98
Page: 8/8
Page 142 of 478
Agenda Item #11 0
VILLAGE OF TEQUESTA
Cash & Investments Unadjusted Unaudited
9/30/2022
Cash Investments
Total
General Fund #001
$ 118001197 $
614945021 $
89294,217
Building Fund #101
2285720
603,422
832,142
Capital Improvement Fund #301
106,367
-
106,367
Capital Projects Fund #3 03
136,361
-
136,361
Water Utility #401
2,9901818
319301260
61921 M79
Refuse & Recycling #402
1131076
-
113 M76
Stormwater #403
301594
-
30,594
Special Law Enforcement #605
501980
K562
131,541
Total Cash and Investments
$ 514579112 $
119108,265 $
169565,377
Page 143 of 478
VILLAGE OF TEQUESTA
nda Item #11 . REVENUE REPORT -CASH BASIS, UNAUDITED
YTD BALANCE YTD BALANCE*
DESCRIPTION 9/30/2021 9/30/2022 VARIANCE % VARIANCE NOTES
REVENUES
Fund 001- GENERAL FUND
General Property Taxes
7,848,744
8,260,937
4121193
5.25%
Sales & Use Taxes
1,966,890
1,803,166
(163,724)
-8.32% Ins.premium tax fire has not received ($172K)
Franchise fees - gross receipt
509,963
4711413
(38,550)
-7.56%
Licenses & Permits
11050
8,350
7,300
695.24% Special permits collected
Grants - Federal
11714,667
1,586,685
(127,982)
-7.46%
Grants - State
15,615
12,615
(3,000)
-19.21% Differs from year to year
Intergovernmental Revenue
909,044
9931665
84,621
9.31% State revenues distributions increase
Chgs for Services - Gen Gov
646,167
4711454
(174,713)
-27.04% Decrease in large projects - land development fees
Intragovernmental Revenue
1,031,297
856,342
(174,955)
-16.96% Decrease in admin fees from Water fund
Rents & Royalties
227,006
253,180
26,175
11.53% Recreation facilities rental increase
Contributions & Donations
100
41,665
41,565
41565.47% Public Safety fitness room donation
Miscellaneous Revenues
29,016
6,160
(22,856)
-78.77% Differs from year to year
Chgs for Services - Public Safety
1,430,216
11196,440
(233,776)
-16.35% Fire plan review fees decrease due to projects
Fines & Forfeitures
22,805
14,697
(8,108)
-35.55% Code enf. Fines decrease
Impact Fees
25,933
9,602
(16,332)
-62.98% Differs from year to year, depending on projects
Charges for Services - Recr.
5,575
15,538
9,963
178.72% 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
7,551
3,606
(3,945)
-52.25% Investments unrealized gains/(losses)
Other Financing Sources
345,148
972
(344,176)
-99.72% Capital lease, sale of assets differ from year to year
Total General Fund
16,768,781
16,006,487
(762,294)
-4.55%
Fund 101- BUILDING FUND
Licenses & Permits
871,235
751,857
(119,378)
-13.70% Decrease in large projects
Grants - Federal
1,813
0
(1,813)
-100.00% Differs from year to year
Charges for Services
31,554
6,940
(24,613)
-78.00% Admin fees from other gov depending on projects
Miscellaneous Revenues
0
56
56
100.00%
Unrestricted Investment Earning
11135
3,642
2,507
220.95% Investment balance and rate increase
Total Building Fund
905,737
762,495
(143,242)
-15.81%
Fund 301- Capital Improvement Fund
Unrestricted Investment Earning
347
89
(258)
-74.35%
Transfers In
460,110
0
(460,110)
-100.00% FY 2022 not recorded yet
Total Capital Improvement Fund
460,457
89
(460,368)
-99.98%
Fund 303 - Capital Projects Fund
Unrestricted Investment Earning
41133
1,070
(3,063)
-74.11% 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.
Transfers In
404,050
0
(404,050)
-100.00% FY 2022 not recorded yet
Total Capital Projects Fund:
71298,183
1,070
(7,297,113)
-99.99%
Fund 401- Water Fund
Grants Federal
3,542
0
(3,542)
-100.00% Differs from year to year
Miscellaneous Revenues
64,074
35,746
(28,328)
-44.21% Differs from year to year (credit recorded in FY 2021)
Fines & Forfeitures
0
563
563
100.00%
Other Financing Sources
613,478
108,862
(504,616)
-82.26% Capital connect charges due to big projects
Unrestricted Investment Earning
6,671
(15,461)
(22,132)
-331.78% Investments unrealized gains/(losses)
Charges for Services
6,058,053
6,281,920
223,866
3.70%
Total Water Fund:
6,745,818
6,411,628
(334,189)
-4.95%
Fund 402 - Refuse & Recycling
Intergovernmental Revenue
11208
41273
3,065
100.00% SWA shared revenues distributions increase
Unrestricted Investment Earning
363
145
(218)
-60.11%
Charges for Services
485,435
500,129
14,694
3.03%
Total Refuse & Recycling:
487,006
504,547
17,541
3.60%
Fund 403 - Stormwater Utility
Transfers In
0
188,565
188,565
100.00% Differs from year to year
Unrestricted Investment Earning
883
62
(821)
-93.01%
Charges for Services
450,271
487,427
37,156
8.25%
Grants
15,615
0
(15,615)
100.00% Differs from year to year
Total Stormwater Utility:
466,770
676,054
209,284
44.84%
Fund 605 - Special Law Enforcement
Forfeitures
91,516
94,055
2,539
100.00% Differs from year to year
Unrestricted Investment Earning
131
598
467
356.15%
Total Special Law Enforcement
91,647
94,653
3,006
3.28%
TOTAL REVENUES - ALL FUNDS
33,224,399
24,457,024
(8,767,375)
-26.39%
* The Village will be recording revenues for FY 2022 if collected within 60 days of the current fiscal period. r % A A A
NOTES are for differences grater than 10% and amounts over $1,000.
0
enda Item #11.
VILLAGE OF TEQUESTA
EXPENDITURE REPORT - CASH BASIS, UNAUDITED
YTD BALANCE
YTD BALANCE*
*
%*
DESCRIPTION
9/30/2021
9/30/2022
VARIANCE
VARIANCE
NOTES
EXPENDITURES
Fund 001 - GENERAL FUND
Council
53,872
63,680
9,808
18.21% Computer system maintenance & supply
Manager
292,053
303,370
11,317
3.88%
Human Resources
341.1472
367,516
26,045
7.63%
Village Clerk
322.1453
3221444
(9)
0.00%
Finance
685,344
683,002
(2,341)
-0.34%
Legal
195,445
153,431
(42,014)
-21.50% Differs from year to year based upon service needs
Comprehensive Planning
157,625
187,201
29,575
18.76% Rate increase and other contractual services increase
General Government
2521,414
227,159
(25,255)
-10.01% Paradise park lease termination
IT
4971,186
423,813
(73,373)
-14.76% Decrease in equipment purchases/IT projects
Police Department
3,366,437
3,470,390
103,953
3.09% Overtime, insurance, capital purchases
Code Compliance
84,947
106,236
21,289
25.06% Additional part time salaries and legal svcs.
Fire Control
4,504,390
3,841,969
(662,421)
-14.71% Vehicle purchase in 2021($299K), pension contrib
Public Works
11403,950
1,343,599
(60,351)
-4.30%
Leisure Services
641,363
780,393
139,030
21.68% Salaries, ins, maint, events/programs/outreach exp incr
Debt Service
489,760
878,058
388,298
79.28% New debt service (rec.center, vehicles & SAN project )
Interfund Transfers
668,160
188,565
(479,595)
-71.78% FY 2022 not recorded yet
Total General Fund
13,956,870
13,340,826
(616,043)
-4.41%
Fund 101 - BUILDING FUND
Building Department
675,181
744,945
69,765
10.33% Salaries, insp svcs, build repair & maint
Interfund Transfers
10,103
0
(10,103)
-100.00% Differs from year to year
Total Building Fund
685,284
744,945
59,662
8.71%
Fund 301- Capital Improvement Fund
Public Works
142,826
247,013
104.1187
72.95% 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
Interfund Transfers
196,000
0
(196,000)
-100.00% FY 2022 not recorded yet
Total Capital Improvement Fund:
425,821
247,013
(178,808)
-41.99%
Fund 303 - Capital Projects Fund
Public Works
236,329
255,000
18,671
7.90% Roads repair and maintenance
Recreation Center
4,568,026
21159,803
(2,408,223)
-52.72% Recreation Center project
Total Capital Projects Fund:
4,804,355
21414,803
(2,389,552)
-49.74%
Fund 401- Water Fund
Water -Administration
1,359,554
1,333,615
(25,939)
-1.91%
Water - Production
2,005,061
1,7171448
(287,614)
-14.34% Water system maint expense, timing in pension exp.rec.
Water -Distribution
801.1185
619,332
(181,854)
-22.70% Vacant position, system maint, timing in pension exp.rec.
Water -Customer Service
239,745
261,545
21,800
9.09% Bad debt exp and regular salaries increases
Renewal & Replacement
5521,236
1.0139,560
587,324
106.35% Water projects
Debt Service
131,391
462,678
3311,286
252.14% Debt service paid off in FY 2021
Interfund Transfers
21,891
0
(21,891)
-100.00% Differs from year to year
Other Nonoperating
721,340
0
(721,340)
-100.00% Depreciation expense and loss on disposal of CA
Total Water Fund:
5,832,405
5,534,178
(298,227)
-5.11%
Fund 402 - Refuse & Recycling
Refuse and Recycling
511.0299
485,755
(25,544)
-5.00%
Total Refuse & Recycling:
511.0299
485,755
(25,544)
-5.00%
Fund 403 - Stormwater Utility
Storm Water Utilities
310,451
350,323
39,872
12.84% Engineering svcs increase
Renewal & Replacement
711,460
220,708
149,248
208.86% Drainage improvements
Other Nonoperating
142,822
0
(142,822)
-100.00% Depreciation expense
Total Stormwater Utility:
5241,733
571,030
46,297
8.82%
Fund 605 - Special Law Enforcement
Police
19,582
113,274
93,692
478.45% Differs from year to year
Total Special Law Enforcement:
19,582
113,274
93,692
478.45%
TOTAL EXPENDITURES - ALL FUNDS
26,760,349
23,451,825
(3,308,524)
-12.36%
* The Village will be recording expenditures for
FY 2022 within 45 days
of the current fiscal period.
NOTES are for differences grater than 10% and amounts over $1,000.
Page 145 of 478
Benda Item #11.
THE VILLAGE OF TEQUESTA
REVENUE REPORT CASH BASIS, UNAUDITED
FY 2022
FY 2022
100.00%
ORIGINAL
AMENDED
TARGET
YTD BALANCE
DOLLAR
PERCENT
% BDGT
DESCRIPTION
BUDGET
BUDGET
BUDGET
9/30/2022
VARIANCE
VARIANCE
USED
NOTES
Fund 001- GENERAL FUND
General Property Taxes
81,158,070
81158.1070
81,158,070
81260.1937
102,867
1.26%
101.26
Sales & Use Taxes
1.1910,660
1,910,660
11,910,660
1,803,166
(107,494)
-5.63%
94.37
Ins.premium tax fire to be recorded ($172K)
Franchise fees - gross receipt
462,000
462,000
462,000
471,413
9,413
2.04%
102.04
Licenses & Permits
1,000
1,000
1,000
8,350
7,350
735.00%
835.00
Intragovernmental Revenue
856,310
856,310
856,310
856,342
32
0.00%
100.00
Grants Federal
201400
11165.1630
1101651630
11586.1685
4211055
36.12%
136.12
ARPA funds received
Grants - State
12,000
20,675
20,675
12,615
(8,060)
-38.98%
61.02
Differ from year to year
Intergovernmental Revenue
907,320
907,320
907,320
993,665
86,345
9.52%
109.52
Chgs for Services - Gen Gov
1951P500
204,000
204,000
4711454
2671P454
131.10%
231.10
Land development fees depends on the projects
Chgs for Services - Public Safety
11265,570
11267,660
11267,660
11196,440
(71,220)
-5.62%
94.38
Charges for Services - Recr.
46,190
46,190
46,190
15,538
(30,652)
-66.36%
33.64
No Teq.fest, special events & camp fees
Fines & Forfeitures
18,500
18,500
18,500
14,697
(3,803)
-20.55%
79.45
Local ordinance and code fines decrease
Unrestricted Investment Earning
8,300
8,300
8,300
3,606
(4,694)
-56.56%
43.44
Investments unrealized gains/(losses)
Rents & Royalties
255,190
255,190
255,190
253,180
(2,010)
-0.79%
99.21
Impact Fees
1,500
1,500
1,500
9,602
8,102
540.12%
640.12
Differ from year to year depending on projects
Contributions & Donations
2,000
37,467
37,467
41,665
410198
11.21%
111.21
Public Safety fitness room donation
Miscellaneous Revenues
121230
12,230
12,230
6,160
(6,070)
-49.63%
50.37
Differ from year to year
Other Financing Sources (lease)
0
1,865,588
1,865,588
972
(1,864,616)
-99.95%
0.05
Fire trucks will not be financed/received FY 2022
Appropriate Fund Balance
1.1145,230
941275
0
Total General Fund
15,277,970
17,292,565
171292,565
16,006,487
(1,286,078)
-7.44%
92.56
Fund 101- BUILDING FUND
Licenses & Permits
503,000
703,000
703,000
751,857
48,857
6.95%
106.95
Chgs for Sery - Gen Gov
0
0
0
6,940
6,940
100.00%
0.00
Differ from year to year depending on projects
Unrestricted Investment Earning
1,400
11400
1,400
3,642
2,242
160.16%
260.16
Investment balance and rate increase
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
876,260
762,495
(113,765)
-12.98%
87.02
Fund 301- Capital Improvement Fund
Unrestricted Investment Earn
1,000
1,000
1,000
89
(911)
-91.10%
8.90
Transfers In
677.1260
6771,260
677.1260
0
(677,260)
-100.00%
0.00
FY 2022 not recorded yet
Appropriate Fund Balance
87,000
117,585
0
Total Capital Improvement Fund:
765,260
795,845
795,845
89
(795,756)
-99.99%
0.01
Fund 303 - Capital Projects Fund
Unrestricted Investment Earning
500
500
500
1,070
570
114.00%
100.00
Transfers In
87,000
117,585
117,585
0
(117,585)
-100.00%
0.00
FY 2022 not recorded yet
Appropriate Fund Balance
254,500
2,613,138
0
Total Capital Projects Fund:
342,000
2,7311223
21,731,223
1,070
(2,730,153)
-99.96%
0.00
Fund 401- Water Fund
Charges for Services
6,346,500
6,346,500
6,346,500
6,281,920
(64,580)
-1.02%
98.98
Fines & Forfeitures
0
0
0
563
563
100.00%
100.00
Unrestricted Investment Earn
81400
8,400
81400
(15,461)
(23,861)
-284.06%
(184.06)
Unrealized loss on investments
Miscellaneous Revenues
48,500
48,500
48,500
35,746
(12,754)
-26.30%
73.70
Differ from year to year
Other Financing Sources (icl.loan)
41457,000
41457,000
41457,000
108,862
(4,348,138)
-97.56%
2.44
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
13,504,146
6,411,629
(7,092,517)
-52.52%
47.48
Fund 402 - Refuse & Recycling
Intragovernmental Revenue
0
0
0
41273
4,273
100.00%
100.00
SWA revenue sharing new
Charges for Services
500,940
500,940
500,940
500,129
(811)
-0.16%
99.84
Unrestricted Investment Earn
500
500
500
145
(355)
-71.00%
29.00
Appropriate Fund Balance
28,570
28,570
0
Total Refuse & Recycling:
530,010
530,010
530,010
504,548
(25,463)
-4.80%
95.20
Fund 403 - Stormwater Utility
Grants & Contributions
30,000
125,000
125,000
0
(125,000)
-100.00%
0.00
Grant not received
Charges for Services
497,810
497,810
497,810
4871427
(10,383)
-2.09%
97.91
Unrestricted Investment Earn
11,400
11400
11,400
62
(1,338)
-95.59%
4.41
Transfers In
150,000
188,565
188,565
188,565
0
0.00%
100.00
Appropriate Fund Balance
0
471352
471,352
Total Stormwater Utility:
679,210
860,127
860,127
676,054
(184,073)
-21.40%
78.60
Fund 605 - Special Law Enforcement
Forfeitures
0
441202
44,202
94,055
49,853
112.78%
0.00
Differ from year to year
Unrestricted Investment Earn
0
0
0
598
598
100.00%
1.00
Appropriate Fund Balance
74,920
149,670
149,670
0.00
Total Special Law Enforcement
74,920
193,872
193,872
94,653
(99,219)
-51.18%
0.00
TOTAL REVENUES - ALL FUNDS
31,282,980
36,784,048
36,784,048
24,457,024
(12,327,024)
-33.51%
66.49
r% _ _. _ A A r+ _r A -7n
NOTES are for differences grater than 10% and amounts over $1,000.
o% w% A A 14- o% &% 1 4 ol ol
U11
THE VILLAGE OF TEQUESTA
EXPENDITURE REPORT - CASH BASIS, UNAUDITED
FY 2022
FY 2022
100.00%
ORIGINAL
AMENDED
TARGET
YTD BALANCE
DOLLAR
PERCENT
% BDGT
DESCRIPTION
BUDGET
BUDGET
BUDGET
9/30/2022
VARIANCE
VARIANCE
USED
Fund 001- General Fund
Council
771350
77,350
77,350
63,680
(13,670)
-17.67%
82.33
(1), (2)
Manager
306,720
306,720
306,720
303,370
(3,350)
-1.09%
98.91
(1),(2)
Human Resources
385,040
385,040
385,040
367,516
(17,524)
-4.55%
95.45
Village Clerk
373,940
373,940
373,940
322,444
(51,496)
-13.77%
86.23
Finance
715,220
715,220
715,220
683,002
(32,218)
-4.50%
95.50
Legal
190,000
190,000
190,000
153,431
(36,569)
-19.25%
80.75
Comprehensive Planning
281,540
290,040
290,040
1871F201
(102,839)
-35.46%
64.54
General Government
314,310
2801310
280,310
2271F159
(53,151)
-18.96%
81.04
IT
476,650
476,650
476,650
423,813
(52,837)
-11.09%
88.91
(3)
Police Department
3,558,370
3,639,436
3,639,436
3,470,390
(169,046)
-4.64%
95.36
(1),(2)
Code Compliance
1241480
124.1480
1241480
106,236
(18,244)
-14.66%
85.34
Fire Control
4101721295
6,058,759
6,058,759
3,841,969
(2,216,790)
-36.59%
63.41
Public Works
1,546,915
1,546,915
1,546,915
1,343,599
(203,316)
-13.14%
86.86
Leisure Services
942,080
976,080
976,080
780,393
(195,687)
-20.05%
79.95
(3)
Debt Service
886,280
886,280
886,280
878,058
(8,222)
-0.93%
99.07
New debt service
Interfund Transfers
827,260
865,825
865,825
188,565
(677,260)
-78.22%
21.78
(3)
Allocate to Fund Balance
99,520
99,520
Total General Fund
15,277,970
17/292,565
17.1292,565
13,340,826
(3,951,739)
-22.85%
77.15
Fund 101- BUILDING FUND
Building & Zoning
676,260
786,260
786,260
744,945
(41,315)
-5.25%
94.75
(1), (2)
Allocate to Fund Balance
0
90,000
90,000
0
(90,000)
-100.00%
0.00
Total Building Fund
676,260
876,260
8761260
744,945
(131,315)
-14.99%
Fund 301- Capital Improvement Fund
Public Works
419,590
419,590
419,590
247,013
(172,577)
-41.13%
58.87
(2)
Interfund Transfers
87,000
117,585
117,585
0
(117,585)
-100.00%
0.00
(3)
Allocate to Fund Balance
258,670
258,670
Total Capital Improvement Fund:
765,260
795,845
795,845
247,013
(548,832)
-68.96%
31.04
Fund 303 - Capital Projects Fund
Public Works
255,000
255,000
255,000
255,000
0
0.00%
100.00
Recreation Center
87,000
21476,223
2.1476,223
21159,803
(316,420)
-12.78%
87.22
Total Capital Projects Fund:
342,000
2/731/223
2107311223
21414,803
(316,420)
-11.59%
88.41
Fund 401- Water Fund
Water -Administration
1103771790
11494,036
11494,036
1,333,615
(160,421)
-10.74%
89.26
Water - Production
1,945,290
1,960,290
1,960,290
1.1717.1448
(242,842)
-12.39%
87.61
Water -Distribution
742,350
756,350
756,350
619,332
(137,018)
-18.12%
81.88
Water -Customer Service
279,450
279,450
279,450
261,545
(17,905)
-6.41%
93.59
Renewal & Replacement
3,657,000
4,078,550
4,078,550
11,139,560
(2,938,990)
-72.06%
27.94
(2)
Capital Improvement
41442,000
41442,000
4,442,000
0
(4,442,000)
-100.00%
0.00
(2)
Debt Service
493,470
493.1470
493,470
462.1678
(30,792)
-6.24%
93.76
Other Nonoperating
0
0
0
0
0.00%
0.00
Total Capital Projects Fund:
12,937,350
13,504,146
13,504,146
5,534,178
(7,969,968)
-59.02%
40.98
Fund 402 - Refuse & Recycling
Refuse and Recycling
530,010
530,010
530,010
485,755
(44,255)
-8.35%
91.65
(1), (2)
Other Nonoperating
0
0
0
0
0
0.00%
0.00
Total Refuse & Recycling:
530,010
530,010
530,010
485,755
(44,255)
-8.35%
91.65
Fund 403 - Stormwater Utility
Storm Water Utilities
351,690
471,615
471,615
350,323
(121,292)
-25.72%
74.28
(1), (2)
Renewal & Replacement
282,000
342,992
342,992
220,708
(122,285)
-35.65%
64.35
(2), (3)
Allocate to Fund Balance
45,520
45,520
45,520
Total Stormwater Utility:
679,210
860.1127
860,127
571.1030
(289,097)
-33.61%
66.39
Fund 605 - Special Law Enforcement
Police
74,920
193,872
193,872
113,274
(80,598)
-41.57%
100.00
(2)
Total Special Law Enforcement
74,920
193,872
193,872
113,274
(80,598)
-41.57%
100.00
TOTAL EXPENDITURES - ALL FUNDS
31.1282,980
36,784,048
36,784,048
23,451,825
(13,332,223)
-36.24%
63.76
Notes:
(1) Personal expenditures/expenses recorded as when paid not when accrued. Personnel paid 9/29/22 for the period ended
9/24/22.
6 days of personnel expenditures not reflected in September 2022.
(2) Not all operating expenditures/expenses
recorded for the services of September 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 147 of 478
Page 148 of 478
�
00
�
00
r-I
cv
o
cv
�
r-i
00
Ln
N
�
N
O
00
m
m
N
�
(.0
O
(.0
In
�
M
r*4
corm
cv
In
r-I
�
Q
r-I
Ln
Q1
dl
00
rl
N
0000
N
N
N
00
rl
Ol
N
N
N
N
N
00
Ln
m
I�
Ln
00
cV
r-I
O
r-I
M
N
O
00
O
N
I�
Ln
l0
O
I�
I:t1
M
r-I
rn
l0
N
N
N
00
00
�
�
Ol
Ln
r-I
�
00
O
r-I
o
r
o
O
�
M
r�
a)
�
N
�
�
H
H
cn
V
N
N
(.0
cv
M
r-I
rn
00
O
Ln
�t
rn
N
Ln
1.0
Ln
Ln
Ln
ri
N
n
M
rn
�
rn
r-I
r-I
M
r-I
M
r-I
r-I
01
Ln
�
O
r-I
l0
�
rl
Ln
Ol
O
M
O
4
l0
Ln
N
N%
rl
Ol
r-I
r-I
m
m
l0
(.0
I�
r-I
�
M
O
O
N
�
i
�
i
W
a)
S
cal
r-I
M
O
O
�
O
M
O
r-I
O
O
M
S
N
cV
M
I�
(V
q;t
r-I
00
O
'::1-
lzt
00
M
M
O
r1
rn
Q0
�D
Q0
O
O
2
2
r-I
i
i
V
V
V
V
V
�
�
N
LL
LL
-0 V
t�:
O
O
U Q
U
U
=
L
Oru
E
U
m
O
)`
—
O
m
.�
O
c6
>
w
a-
a) s m
U
4A
Ln
•i
O
�
u
�+
•�
U
N
Ln
m
E
�
.O
V
J f O
a--+
m
L
W
O
x
L
>, N L
co
cn
a_
O
'rc
41
>,
=
>
cu
'
O
°�Q
_
m
>
V+
o
a�
a�
O
�
�
Q)
—
L
a
_
�
�V
+
�
w
4
Qo
O
a
s
M
N
NE
o
V
O
a 0)
O O
�
�'
Z
co
Q
co
N
co
ca
M
Mo
U
CA
a)c.�
uO
a
O
�>
`�
LL
w
cn
O
U
z
ca
>
C
7
a
E
L-
—i
m
O
a
Q
—
I N cn CO
U
oC
O-
V)
.O
LL
U
_
Page 149 of 478
M
m
q;t
m
rn
�
�D
�
r--1
m
�D
M
m
Q0
00
�D
rl
m
4:1-
m
�
�
M
Ln
M
M
M
M
N
[V
rl
r-I
00
lzt
rl
rl
R:I-
N
I�
00
rl
N
N
00
rl
c
V--1
00
M
rl
N
O
V--1
(A
O
(-JO
(A
O
00
o
O
O
O
0O
N
N
00
00
Q0
m
N
Ln
r-I
k-o
Ln
O
::1-
m
(.D
u)
O
M
�
m
::I-
Q0
In
O
00
m
�
�
Ol
N
O
IZI-
M
:t
N
rl
O
:1-
r-i
N
lD
I:t
�
rl
rl
rl
N
r-I
rl
rl
r1
Ln
c
O
Ln
r-I
N
N
a)
O
Ln
N
r4
O
N
N
O
O
o\i
O
a\i
Ln
H
�
N
N
m
c�
Q
00
::1-
lzt
m
N
�
00
Ol
00
O
�
N
l0
Ln
00
00
m
::I-M
r-I
r-I
M
N
M
N
M
r-I
r-I
o
N
Lii
00
N
N
In
I�
l0
Lnrl
CV
I.n
M
lD
rl
rl
I n
ca
N
4-0
Ln
M
rl
M
N
I�
4-0
N
N
�7
Oy
�
�
M
r-I
O
O
OR
LM
LM
O
O
W
�
r-I
m
N
m
O
N
O
O
O�
N
N
r-i
�0
W
O
O
r�
r�
S
O
N
l0
r-i
r-I
O
M
I-
p
4-0
rl
rl
O
N
N
4-0
dA
o
=
`�
`�
rn
=
-0
p
O
O
mOLn
LM
LM
V
L-
i
4-+
U
O
N
cu
Ln
0
0
0o
p
Q
aLnE
Ln
O
+_+
cn
a
i
O
Ln
U
O
G�
ca
.O
Q
Ln
Q
Ln
E
Ln
—
U
O
0
_
V)
�
p
=
>
`'''
�
V
-
C6
_0
Q
Ln
�
a)
C6
v
o
c�
E
Ln
L
m"-
-
�>
Q
>
>
_
>_
v
N
O
�
"
O
cn
\
Ln
cn
W
LL
Ln
a-+
' N
a"'06
O
N
>.
ca
lzi
C
c
W
O
O
O
t
O
O
O
ca
p
ca
L
m
_
c
•Ln
p
N
•—
_
oC
O
O
E
Z
—
O
dCJ
p
N
N
�
iO
�C
CD
I.
U
V
1
�'Q
Qcn
Ui
O
p•p
a
>
O
O
Q
*''
O
O
a-
ww4A
w
w
w4
w
I�
(
w
O
0C
2
Z
V)
Q
=
Page 150 of 478
V--1
N
O
—
M
N
�
a)
�
O
(.0OLO
O
00
O
0
O
� O
O
O
O
�
�
�
N
N
00
N
�
r-I
OO
N
M
~
O
N
O
N
N
�
O
00
O
O
00
O
of
N
O
N
I�t
L)
NO
r-I
0
0
000
r-I
�
I_f)
cu
0
O
lD
M
;;1-
O1
0
O
0
�
Ln
00
O
O
Ln
un
O
O
`�
mN
O
0
O
Ln
0
O
O
0
Ln
O
O
O
O
O
O
O
O
O
O
Ln
O
O
M
l0
r-I
�
N
N
Ln
r-I
I n
I*
In
Il
O
m
O1
O
M
00
Rt
(.0D
Ln
s
0
11
°�,°
o
O
TH���
Ln
O
N
o
Ln�
o
O
0
O
0�
o
O
0
O
0
0
0
0
0
0
0
0
a
L
V
�
a-+
V
O
ca
i
V
a
0
a
+r
o
'-
•-
m
o
i
V
GC
�
m
a
�
+-j
L-
m
C:
—
O
t�0
a0
'0
C
v
_
O
U
•.��__
�c�a
>
c
O
O
O
Ln
`E
U
�
—
�
�—
��
v
�
O
_
�
p
`i7
�
O
V
cn
p
O
O
M
mi
cz
w
m
4-1
m
O
N
—
N
cn
U
cn
O
W
IZ
O
+�
0-
0
cXa
. _
V'c0
—
o
>
E
O
Q
. —
>
c�
.O
O
U
+,
cn
—
cry
DC
cn
+-+
O
LLJ
�
C
�
U
E
q
c
C
=
�'
cn
�
0
+-+
Q
W
4 -+
W
W
a-J
Ln��
Q
Q
cn
•>
—
O
a-J
to
•—
V
'p
j,
l�A
v
�
E
N
E
N
.v
O
v
X
N
v
0-
cc
>
v
N
�
O
a
m
m
GEC
cn
O
C�
O
L7
ii
U
C�
m
U
c�
~
~
w
U
c�
Page 151 of 478
N
0
N
O
O
O
00
O
Vf
N
O
N
00
00
Ln
O
M
M
I�
O
O
v
O
O
O
Lr)+r
\
I_f)
lO
Ln
rl
I�
(M
l0
cV
rl
N
rl
NO
M
01
~
N
rl
_
O
N
�
O
�
N
N
Orl
Orl
OOOO
M
M
M
NI
M
Ol
l0
O
Ln
bi)�
Q000�
\00
Ol
Ln
Ln
N
M
l0
ca
-I
u1
rt)
N
>
N
O
O
O
0)��
fV
cV
CN
0�
O
Ln
Ln
�
�
00
Zt
0
Ln
M
�O
i
�
f V
r-I
N
rl
M
00
t
O
rl
O
O
O
O
rl
I�t
O
N
O
00
�O
N�
�
cn
10
Ln
N
M
rl
M
p
N
r-I
rl
N
Ol
i
i
V
a-+
0
CL
•c�
D
O
a
a
.W
CL
>,
>,
-a
—
U
�0
•>
L
f6
LL
ru
I..L
•—
—
—
O
—
+�
_
>
�
cn
0
aJ
O
0_
—
N
U
�
-C
LL
m
s
—
m
C
V
C
—
a--+
N
cn
N
p[
Q
p
ca
>
>�
i
G�
N
�
—
+�
+�
1
N
V
•—
—
O
V)
N
•—
cn
+�
cn
Ln
C
4A
E_
N
O
O
N
O
O
v
0
p
cnLn
• >
ca
+-+
_�
4-,
V
rl
l0
rl
rl
rl
rl
l0
rl
rl
rl
—
�
O
ca
U
—
LL
O
DC
Q
U
+�
U
O
U
c
—
EMOI
cn
o-
oc
LL
m
LL
w
GC
Z
Z
Z
Z
Z
Z
Z
Z
Z
Z=
V
10.
Page 152 of 478
O
O
�
O
N
M
N+rn
fi
V
w
N
\
�
rnO
_n
-I
O
I
Lr)
Ln
W_)
mmma)00
O
�
M
O
O
r-IN
00
r�
r�-I
�rn�
O
N
I
�
r-I
_)
N
-
I
�
�N�COp
O
NN
M
N
fl
I�
r-I
r-I
N
�
O~
O
~
O
O
N
O
,::I-
M
O
00
m
4-+
p
N
�
l0
01
O
O
H
M
O
N
I�
N
I
(.O
M
m
l0
O
00
N
` �
�n
00
�
l0
O
O
M
O
Ln
N
O
l0
O
M
�
N
�
0
�
M
N
r-I�
r-I
r-I
N
rl
M
rl
O1
I�
N
00
rl
I1�
M
r-I
lD
r-I
N
M
rl
0
O
N
N
oLn
rl
fa
fa
r-I
cV
N
3
V
Ln
0
O
�
Ol
�
LO
fV
O
00
cV
O
N
00
00
00
Ol
(.O
O
�
(10
cV
O
00
�
Rt
N
�
r-I
LO
LO
rl
N
�
O
LO
rl
O)
Ln
M
ri
r-I
LO
m
M
�
rl
�
00
M
rl
`�
�
ri
r-i
l0
to
N
LO
r-I
—
0
o
L
O
o
�
o
�
O
O
OM
m
0
O
O
O
O
W
O
N
O
LO
0r1
LO
�n
00
0000
m
r�,
0
r1
�
N
(10
r1
�
N
N
a
�
V
cn
O
E
�
V
O
L
'�
Q
c
—
U
O
•�
V
GJ
a
.�
aO
N
U
41
aA
m
N
2
O
N
O
.�
N
N
N
ca
c�
tx
•�
tao
V
Ln
O
rl
U
Q
_
i
Q
•c6
•
ate-+
�
0�0
•i
O
+_�
O
'
0
aA
O
a1
N
cn
M0
i
�
DCLA
ca
cn
F-
cn
F
cn
�
L.L
cn
N
�
DC
cn
�
co
�
�
_
�
4-1
s
�
�
�
�
a-J
v
C
—
U
Q
N
U
O
N
N
N
N
Q
hA
Q
O
4A
•�
,
O•
�
+-0
._
Q
—-
+r
+�
c6
i
dJ
i
N
i
N
i
dJ
L
N
V
cn
(�
a..+
per[
+-'
O
cu
�--'
L-
�
O
J
O
J
i`
41
-0
a-J
J
U
O
�
DC
�
G�
i
O
Q
Q
Q
Q-0
c6
4A
w
a--+
41
_�
a_+
C
taA
cn
C
N
• p
O
O
O
O
0
+-+
w
p
—
Q
O
O
L
0-
J
cn
Ul
0-
>
m
Ul
to
I..L
cnD
W
W
Page 153 of 478
r-I
r-I
Ln
O
N
w
O
Q
Ln
O
M
�D
Q
Q
O
Qo
00
�
Q
Q
Q
Q
Q
Ln
Ln
N
M
Ln
r1
110
M
Ln
00
�
�
M
Ln
�D
�
Mz
N
QD
z
z
r-I
�
z
z
z
z
z
rl
00
(V
(V
r-I
r-I
O
00
M
M
O
0)
rn�
Lr)
M
00
Q
O
00
��
Ln
Q
Q
Q
Q
Q
Q
Q
Q Q Q
I'O
QO
M
`n
r-I
I�
I�
r-I
M
rn
00
r-I
�
00
O
00
m`
N�
�
z
r
z
z
z
z
z
z
z
z z z
N
M
M
Ln
0)
00
m
00
�
OL
O�
�
cV
*
Ln
cV
cV
k.0
�
�
u�
Q0
M
r-I
N
v -I
M
lD
N
-�.
01
N
N
M
�
M
CY)�
r-I
qt
0)
00
N
I_f)
I�
00
�
O
M
I�
M
t.O
O
CF)00
rl
N
0)
�
��-I
Ln
0)
N
N
M
rl
rl
r-,
00
O
0
m
I�
I�
N
00
Ol
�
O
00
N
�
N
OM
M
�
Ln
�n
rl
�
p
10
M
(.0
�(
N
Ln
O
M
B
N
ONO
110
�n
N
r-I
N
rl
Ln
rl
N
rj
M
00
Ln
N
p
O
4J
.
Un
i
(a
b.0
c
N
=3
p
[0
l/
T
E
W
U
�
O
Q
O
O
ca
cn
—
cn
!.
. —
a--+
�j
N
N
w
(�
'�
N
"
4-j
0
a
o
0
'>
N_
+-+
�>
Q
v)
O
aO-+
c
O
O
cn
Q
c
p
V
+�
canLn
p
V
C
Ln
ca
O
N
a--+
M
cu
.V
Ln
—
WLnN
cam/)
i
Ln
>
Q
Q
4A
O
(U
N
U
N
O
a--'
ca
4J
E
�
ca
a)N
C
Q
N
U
a--+
cn
U
O
O
>
J
i
>�
ca
N
N
O
a-j
c
��
O
U
.�
U
U
OC
O
�
O
-0
C:
Q
Ln
_0
`n
N
aA
—
—
O
a-
`�M
O
on
E
N
0
n
v
Q
OCU
o
a)
`�
m0
O
N
+�
N
+J
OV
O
'U
O
O
O
++
�
M
p
cNa—v
Ezt�
NE
�-'
c—n
N—
'
N
N
U
p
.
cn
Q
Q
cn
O
O
O
co
Cf
cn
N
+-j
+'
ca
v)
ca
ca
O
O
>
a
p
.
O
C
0
qA
mm
qA
�Jp
L�pNL
U
UO
O
t
N
NO
�
O
�
`
2
2
U
OO
—
C
pU
<
)
p
w
+J
+OO
N
-
U
QM
bn
CC
O
w
0
A
N
Q-0
bca6c
O
N
p
O
O4A
—•
m
N
M
mm
O
O
E
O
O
+Jy
a�—
con
�
CO
�
.0
LL
a_
a_
UN
Q
v
"
�
Q
J
�
Q
Q
a�
O1
I
O
J
z
Page 154 of 478
00
Q0
cM
•�
V
Ln O
�O O
i s V •� �-
4- •O b.0
M '
O
a ` Q) r c i
s CL U U
CD C 4-
a) C O
O0 L V >CD i
Q Q Q
Q
Q
Q
Q
Q
Q
Q
�, 0 .� O a1
+-j
�n
N
�n
+� CO � �, U
Z Z Z
Z
Z
Z
Z
Z
Z
Z
� _ O +, U
Q ca - v>- V U m
Q) -0
V Q C6 m
UL
O a) � UO ca Q O cn
L- U J O Q
M
W ago (A C- O o
rn
01
r-..
Ln
m-I
a
Q
0O
zO
ryl)N
I-
z
00
m
z
I�
�
�
�
�
rn
O)
m
�r-j
m
l0
N
m
m
O
QQ O Q) aV-+
p
Ln
a� u +� +� a,
N i1 0 N N
V
O }'
.� Ul
O w w� F
OLO O U EQ ca p Q
r-IU
0 U
Q
z
l0
M
N
�n
Q
z
I_f)
00
Q
z�
I�
N
m
rl
rn
�
�o
I.n
�
o
0
o
m
c.�
o
a) a) Q �
� —
— V— ce �
00
i
`- ca w (2)
> o 0-- 0 a)
� 0- M U bb E
O
tu0 Q
cn p +� O
cn
Q
O
a) 4- C: O
C:
� + O cn
N
O
tu0
—
V
CAA Q) cn Q c6 V
(U
ca
O
o
O N m> a� •- a�
a)
-�e
+-+
N +-+ V � 4E
c6
N
O
a)
Q U U � O `n
0
z
vi
�
O cn � , nA � can
:
�L-
Q
>�
O
Q
`n - (U+ +�-►
cn w E V
_�
0 ca
�
0
+-
-a
�
O
i
ca
+j
m m -0V;
o
O V O
Ln
N
a)
Q)
O
O
_0
�
-a
•
`
� O O
Q(,
}N'
cr
-j
a)
a�
�
w
�O
o
CO ca a) CO
V
an
L-
N
ca
c6
U
i
u t +-j vi —
� cn . v' O (u
-0
•E
L)
V
•
7
�
�
O
ca
> � . — m O � m �
Q) co
^
• V
a)
N
W
Z
N
p
V
O
_
M
O
Q
w• cn � v'
i Q) 2
L
a""'
4-j
�-+
u
4-,
N
_
•�
>�
Q)
cn
• —
VO
p[
�
CAA
cn
_0 4-j O O —
V i Q N
V)
N • —
(�
•�
—
O
Q
O
+-j
—
>
aj
+)
V)
L
_
>
`~
a-J •�
O Q �
F E
cn
vi
-0
U
c
i
�.
�'
V)
s
i) 0
can
O c6
j
� ca
O
4-0
�
M
cn
�
• c_a
s
V
cn
�
�
}'
ca
�
� O
r1 E i �
L
V
a)
O
s
O
—0 0 ' V
a)
Ln
w
:
�
J
ca a)
E � teE O CD
a
+-+
°•°
(n
A
o
+s
� �cn Q —
O
�
O
O
Oul
u
Ln
o E
W
FO
J
>m
Lntn
cw
N
-a
�
CU
sccNna
O
O
O
O
�
O
�
}'
M
cn - E
—
�
w
(n
Ln
m
>
m
C:CNknN
ao
Q• m
a6 � wi
�
U
V
J
O
V
a)
a)
+�
�
N
�_
�_
� E E
mO
ca
`�
O
_�
ca
b.0
`�
°C
oc
�
w
w
'cn
'cn
o
O
O
O
co ca �' 'Fj O a) �'
�-'
�C
*k
X
I
oC
w
*k
0
Ln_0
a)
0-
0-
o
��
m
m
V
V
V
V
Zj
o a� +�
p
a)
O
cu
a)
E
w
w
w
V m O N D >
(A
z
CL
U
incn
00
W
w
w
w
U Q c6 > V O
Page 155 of 478
rl
�
—
4\
N
O
M
I
m�
Ln
oM
w
Lr)
r-I
1.0
Sri
N
O
N
N
M
N
m
rn
'�
n
M
N
cn
r-I
M
r-I
Lr)
M
N
M
N
0
H
00
Lr)
M
lqt
M
�
N
N
00
m
1,0
a)
re)
M
i
N
t
i
O
N
Ln
r,n
rn
Mm
o
�
o
rn
N
M
i
i
3
V
O
._
cn
_
�
O
a�
aA
cc
CL
(U
--
a-J
o
O
U
N
O
N
�
U
N
N
U
ate-+
O
m
W
(a)
DC
.�
>
�
=
U
�'
.i
—
s
N
O
.�
4-1
—
•cam
�
L
N
X
N
+J
(2)
N
U
�
c
�
O
O
N
�
U
�
�
�
>
Q
�
>
ateJ
ateJ
�,
4-
�3E
J
W
W
(/)
G
G
J
(,/)
Page 156 of 478
Q
O
U
A)
.y
N
LL
LL
C
C:
co
U
0
Q
d
a
Of
N
N
U'
o
Q
U
Q
w
2
2
J
N
>
o
0
00
r
0
0
O
O
0
o
O
O
0
Lq
M
f--
ao
O
La
La
co
N
It
CO
La
O
—
—
co
NN
N
Cfl
U x
W
Q
Q
N
0
O
(TO
0
Oo
0
Oo
0
O
0
CD
0
CD
0 r
O
O
(
M
N
L d
cm
0)
N
W
W
°p
Zt
64
LO
o
N
v
>
>
N
i
o
�
cq
ai
(D Loa
0
o
o
o CD
LO
llq
I-
°ram'
O
O
f-
N
d
M
is
W
000
N
M
�
O
O
06?
O
O
6a
O
o
O
6-)
64
64
69
N
7
OO
0
LO
0
0
O
O
O
i
Q�
M
N
O
O
O
O
O
o
-
U)
�
4
6
604
0�
6'T
604
O
O
CD
O
O
O
CD
CD
O
O
N
O
CD
Loa
6)
O
CD
Loa
u
O
O
69
O
O
64
o0
N
VD,
O
O
69
O
O
64
61)
coG
a+
L O
V' G
O
�
0
Co
O
CDO
O
CD
O
O
O
OLO CO
�}
O
O
r-
Cfl
O
O
O
O
C
O
r-
Lfj
6GS
Lo`}
�
m
Cd
co
i i
co
Q
U' •�
N
N
LO
N
N
0
N
N
O
0
O
C\4
m
LLLL
LL,
LLL
(.0
m
++ i
N
O
i V
0
W
NO
N
r
m
N
N
LL
N
O
LL
N
N
LL
N
N
LL
N
0
LL
L �
m
O
LO
O
O
U)
N
U)
U
O
O
N
��-
N
CL
O
U
Q)
U
a)N_
'p
O
N
O
L
O
L
(D
C
L
O
E
a
a
U
E
C
OC
CL
�.
L
�
c
0
o
CB
�.
(B
�
�
0
o
O
N
N
L
L
C7
E
O
cy,c
C
W
�O
O
c
O
(D
E
W
�
W
O
a�i
c6
W
W
U)0
�
a)
>
cl
(a
E
o
o
2
2
v
E
o
J
m
U
U�
ca
a
O
m
m
m
m
�
mLM)
N
m
0
U
O
m
m
m
Q
m
m
cO
Coa
cu
m
o
LL
0
LL
o
LL
w
LL
w
LL
W
o
LL
o
J
D
N
N
O
C
O
co
L
U
L
m
V)
co
m
U)
m
LL
D
D
CO
Q
LL
D�
N
N_
d
d
E
ca
L
E
m
L
0
J
a
C
O
Q
N
N
�
^O
LL
+
^^O
LL
N
>1
7
LO
Efi
U
cn
Q
E
E
@
N
O
N
N
00
(D
E
>
E
E
m
00
a
v,
U
U
Z
E
06
06
C
(1)
U'
o
v
0
O
a
U
U
M
Q)
Q)
D
t0
C
C
•p
a
•Nn
.�
L
`
3
`c�
vC
c
CD
C�
0
U)
H
L
J
LL
C
E
o
�
C
m
N
�
•�"—,
�
+r
'
in
E
c
0
m
m
U
a
Z
a-
O
~