The URL can be used to link to this page

Home My WebLink AboutDocumentation_Regular_Tab 07_11/15/2021Agenda Item V. Regular Council STAFF MEMO Meeting: Regular Council - Nov 15 2021 Staff Contact: Jeremy Allen, Village Manager Department: Manager r November Manager's Report through October 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 — first FY 2022 distribution is scheduled for the midst of November 2021. Historically, 91 % of ad valorem tax distribution receipted by the end of February. 3. Sales/use taxes (1.63%), which include local infrastructure surtax, insurance premium, utility, communication service and local business tax, are one/two month behind the collection/reported period, with the exception of the Local Business Tax. Revenues for FY 2022 has not been received at 10/31/2021. 4. Intergovernmental revenues (1.77%) which include municipal revenue sharing, half -cent sales tax, local gas tax are one/two month behind the collection/reported period. Revenues for FY 2022 has not been received at 10/31 /2021. 5. Revenues (Budgetary comparison) recorded in the General fund represents 1.82% of budgeted due to the distribution nature of Ad valorem taxes (first FY 2022 distribution — November 2021) and State Revenues collection one/two month behind collected period. 6. Overall Expenditures (Budgetary comparison) in the General Fund represents 5.45% of budgeted, which is below target budgeted due to the fact that not all the expenditures recorded for the services provided up to 10/31 /21 and personnel expenditures recorded as paid not when accrued. 7. Revenues (Prior year comparison) all funds aligned with the prior year revenues. 8. Expenditures (Prior year comparison) all funds increased slightly due to entering into a debt service contracts for the recreation center and computer hardware. 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. Page 131 of 433 Agenda Item V. 1 Oct 2021 reports October 2021 Managers Report.ADA (1) 3Copy of October 31 2021 Grant Budget Worksheet Page 132 of 433 Q 'BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/8 s00 racatnotqli Period Ending 10/31/2021 DB: Tequesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 5,633,581.56 Investments 24,597.52 Accounts Receivable 338,821.62 Due from Other Funds 0.00 Inventories 65,636.68 Prepaids 256,316.87 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 6,318,954.25 *** Liabilities *** Accounts Payable 232,363.30 Accrued liabilities 267,056.95 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 1,204.97 Deferred Revenue 1,615,045.10 Other Current Liabilities 0.00 Customer Deposits 0.00 Noncurrent liabilities 0.00 Total Liabilities 2,115,670.32 *** Fund Balance *** F/B - Reserved for Inventories 0.00 F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 290F921.10 Fund Balance - Restricted 420r582.76 Fund Balance - Committed 500,000.00 Fund Balance - Assigned 298,661.00 Fund Balance - Unassigned 1,884,303.78 Total Fund Balance 3,394,468.64 Beginning Fund Balance - 20-21 3,394,468.64 Net of Revenues VS Expenditures - 20-21 1,787,180.76 *20-21 End FB/21-22 Beg FB 5,181,649.40 Net of Revenues VS Expenditures - Current Year (978,365.47) Ending Fund Balance 4,203,283.93 Total Liabilities And Fund Balance 6,318,954.25 * Year Not Closed Page 133 of 433 Q 'BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/8 s00 racatnotqli Period Ending 10/31/2021 DB: Tequesta Fund 101 BUILDING FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 848,335.26 Investments 0.00 Accounts Receivable 9.62 Inventories 88.53 Prepaids 6,783.35 Total Assets 855,216.76 *** Liabilities *** Accounts Payable 7,056.82 Accrued liabilities (38,674.58) Due to Other Governments 3,536.41 Total Liabilities (28,081.35) *** Fund Balance *** F/B - Unreserved/Undesignated 0.00 Fund Balance - Restricted 1,151,130.04 Fund Balance - Unassigned (495,196.87) Total Fund Balance 655,933.17 Beginning Fund Balance - 20-21 655,933.17 Net of Revenues VS Expenditures - 20-21 218,765.05 *20-21 End FB/21-22 Beg FB 874,698.22 Net of Revenues VS Expenditures - Current Year 8,599.89 Ending Fund Balance 883,298.11 Total Liabilities And Fund Balance 855,216.76 * Year Not Closed Page 134 of 433 Q 'BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/8 s00 racatnotqli Period Ending 10/31/2021 DB: Tequesta Fund 301 CAPITAL IMPROVEMENT FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 89,495.01 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 89,495.01 *** Liabilities *** Accounts Payable 313.50 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 313.50 *** 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 240F480.00 Fund Balance - Committed 46,485.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 31,690.53 Total Fund Balance 318,655.53 Beginning Fund Balance - 20-21 318,655.53 Net of Revenues VS Expenditures - 20-21 (229,474.02) *20-21 End FB/21-22 Beg FB 89,181.51 Net of Revenues VS Expenditures - Current Year 0.00 Ending Fund Balance 89,181.51 Total Liabilities And Fund Balance 89,495.01 * Year Not Closed Page 135 of 433 Q 'BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/8 s00 racatnotqli Period Ending 10/31/2021 DB: Tequesta Fund 303 CAPITAL PROJECTS FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 2,317,372.34 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 2,317,372.34 *** Liabilities *** Accounts Payable 11,591.80 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 11,591.80 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 46,563.00 Fund Balance - Unassigned 9,702.79 Total Fund Balance 56,265.79 Beginning Fund Balance - 20-21 56,265.79 Net of Revenues VS Expenditures - 20-21 21,275,022.28 *20-21 End FB/21-22 Beg FB 2,331,288.07 Net of Revenues VS Expenditures - Current Year (25,507.53) Ending Fund Balance 2,305,780.54 Total Liabilities And Fund Balance 2,317,372.34 * Year Not Closed Page 136 of 433 Q 'BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/8 s00 racatnotqli Period Ending 10/31/2021 DB: Tequesta Fund 401 WATER FUND GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 6,061,683.48 Investments 40r659.24 Accounts Receivable 606,557.61 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 35,000.00 Inventories 254,545.24 Prepaids 73,866.73 Other Assets - Current 0.00 Land 83,335.00 Other Assets - Non Current 83,335.00 INFRASTRUCTURE 15,367,117.19 Buildings 239,466.91 Improvements Other Than Bldgs. 27,011.20 Machinery & Equipment 290,194.86 Construction in Progress 0.00 Intangible Assets 28,993.85 Other Fixed Assets 0.00 Deferred Outflows 516,332.80 FIXED ASSETS 0.00 Total Assets 23,624,764.11 *** Liabilities *** Accounts Payable 68,610.15 Accrued liabilities (229,381.83) Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 251.53 Deferred Revenue 0.00 Current Portion of Debt 391,728.09 Other Current Liabilities 0.00 Customer Deposits 49,246.02 Noncurrent liabilities 2,344,386.67 Other Long Term Liabilities 483,856.31 Def Inflows of Resources 156,780.00 Total Liabilities 3,265,476.94 *** 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 11,584,763.87 Net Assets, Restricted 0.00 Fund Balance - Committed 500,000.00 Fund Balance - Unassigned 7,223,463.86 Total Fund Balance 19,308,227.73 Beginning Fund Balance - 20-21 19,308,227.73 Net of Revenues VS Expenditures - 20-21 896,724.12 *20-21 End FB/21-22 Beg FB 20,204,951.85 Net of Revenues VS Expenditures - Current Year 154,335.32 Ending Fund Balance 20,359,287.17 Total Liabilities And Fund Balance 23,624,764.11 * Year Not Closed Page 137 of 433 Q 'BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/8 s00 racatnotqli Period Ending 10/31/2021 DB: Tequesta Fund 402 REFUSE & RECYCLING GL Number Description Balance *** Assets *** Cash and Cash Equivalents 89,811.62 Investments 0.00 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 89,811.62 *** 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 118,576.84 Total Fund Balance 118,576.84 Beginning Fund Balance - 20-21 118,576.84 Net of Revenues VS Expenditures - 20-21 (28,039.64) *20-21 End FB/21-22 Beg FB 90F537.20 Net of Revenues VS Expenditures - Current Year (725.58) Ending Fund Balance 89,811.62 Total Liabilities And Fund Balance 89,811.62 * Year Not Closed Page 138 of 433 Q 'BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/8 s00 racatnotqli Period Ending 10/31/2021 DB: Tequesta Fund 403 STORMWATER UTILITY GL Number Description Balance *** Assets *** Cash and Cash Equivalents (80,017.98) Investments 0.00 Accounts Receivable 274.57 Due from Other Funds 0.00 Inventories 340.23 Prepaids 678.90 Other Assets - Current 0.00 Other Assets - Non Current 0.00 INFRASTRUCTURE 1,313,465.01 Buildings 0.00 Improvements Other Than Bldgs. 0.00 Machinery & Equipment 23,304.85 Construction in Progress 0.00 Deferred Outflows 23,887.00 Total Assets 1,281,932.58 *** Liabilities *** Accounts Payable 4,614.94 Accrued liabilities (17,900.69) Retainage Payable 0.00 Due to Other Funds 35,000.00 Due to Other Governments 0.00 Current Portion of Debt 0.00 Other Long Term Liabilities 8,945.55 Def Inflows of Resources 10,547.00 Total Liabilities 41,206.80 *** 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 797,975.14 Total Fund Balance 2,034,362.20 Beginning Fund Balance - 20-21 2,034,362.20 Net of Revenues VS Expenditures - 20-21 (755,271.06) *20-21 End FB/21-22 Beg FB 1,279,091.14 Net of Revenues VS Expenditures - Current Year (38,365.36) Ending Fund Balance lf240F725.78 Total Liabilities And Fund Balance 1,281,932.58 * Year Not Closed Page 139 of 433 Q 'BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 8/8 s00 racatnotqli Period Ending 10/31/2021 DB: Tequesta Fund 605 SPECIAL LAW ENFORCEMENT GL Number Description Balance *** Assets *** Cash and Cash Equivalents 147,067.50 Investments 0.00 Accounts Receivable 0.00 Inventories 0.00 Prepaids 8,540.61 Total Assets 155,608.11 *** Liabilities *** Accounts Payable 1,750.00 Due to Other Funds 0.00 Total Liabilities 1,750.00 *** Fund Balance *** Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 84,976.34 Total Fund Balance 84,976.34 Beginning Fund Balance - 20-21 84,976.34 Net of Revenues VS Expenditures - 20-21 72,064.76 *20-21 End FB/21-22 Beg FB 157,041.10 Net of Revenues VS Expenditures - Current Year (3,182.99) Ending Fund Balance 153,858.11 Total Liabilities And Fund Balance 155,608.11 * Year Not Closed Page 140 of 433 Agenda Item #7. VILLAGE OF TEQUESTA Cash & Investments Unadjusted Unaudited 10/31/2021 SBA Prime Cash Investments Total General Fund #001 $ 516331582 $ 249598 $ 516581179 Building Fund #101 8483335 0 8481335 Capital Improvement Fund #301 891495 0 891495 Capital Projects Fund #303 2,317,372 0 2,317,372 Water Utility #401 610611683 401659 611021343 Refuse & Recycling #402 895812 0 899812 Stormwater #403 (80,018) 0 (80,018) Special Law Enforcement #605 1471068 0 147,068 Total Cash and Investments $ 1591079329 $ 659256.76 $ 15,1729585.55 Page 141 of 433 Agenaa item *r. E N � U U u Na) ate+ . O' •O N Q Q N E O ° Qj > z °C co O a) E N Ln U U L � `~ L L U � O O O + � C � � L- Q) +, O E E E � O O O •� Qj N O Q) i W L •� • :'� :•~ U N U Q) Q m J 0 0 DC 0 0 0 F- O � O O O O O O � � O O O O � \ O O O O O O O O — LU U O-ON M N N 00 Ol tO I� O 00 O O O O 00 O Ln 00 00 N I� O I� � Ln O w w Q M m Ln rl I� Ol M O B 0) O O O N O I� N N L!) I� O 0) 00 Ln 0 q* 4* Q Q rM 4 o0 (,D r� (,D I� O rM N 0 0 0 I� O O O O O M O o0 rI M 0q* 4* Q Ll) 0) rl rl O O O O O 0) O O ' ' rl ' O rl O Z M 00 rl rl rl ' rl rl rl " rl p o W V) N M I� Ln 00 Q0 l0 lO M Q0 N rl O O rl M rl M M N Ln 00 rl M M M N N w Q O W O 1,0 � fV O I� lD (.0 � Ln l0 � T-1 � 00 00 (10 l0 O rl rl I� 00 W W Ln (10 rl C) 0) O Ln I� rl (.0 00 rl ;t r-I N N Ln 00 Ln CV Ln rl N N O a 1 L) 1 N 1 Ll) \ \ \ M 1 CV 1 00 1 Ll) N N 1 0) \ rl \ L n 1 00 1 1 M N N Ln M a M � O rl rl -- -- � v v rl -- (V r� N N N Z N N LLI Q O a c H > W cc F- O a _ 0 W N 00 lD O Ol N l0 S O N rl O O lD O 00 Tr R* M (10 00 Ll) lD L) M W W N LU r-I (.D r-I O (V M M L!) M CV M l0 M rl M M N I� u) 00 l0 rl M CV �--1 �--1 m 00 Ol Lf) O Ln rI rl N I� Co M 00 rl N M N M T-1 N LLI NO 1 rl 1 (.0lD 1 1 M \ 00 1 rl \ I* 1 1 00 � N GN N 1 M \ I� \ LO 1 1 00 1 M �%Z Ln Ln M JQ J N M� L1) rl CV I� rl (ID 00 N N L!) � NM (`M O O 00 00 00 N M N N 00 J 4 > Q m M Z 0 0 a W U Q rl N rl rl M � Il N r � 0 0 0 0 I� 00 lO M M rl rl O I� M wO M M W Z O � R::I- 00 N N M o0 (.O 00 I� rl O O O I� Q0 N rl 00 Ln Ln Ln a Z N � O N O M 0) Q0 N l0 M�� N� M�� Ln Ln r1 W Q O 1 1,0 1 1 N 1 Ln \ Rt 1 Ln \ rl 1 fV \ 00 1 M� � % � 1 lO \ 0) 1 N 1 M � N � N � 00 Q J� w N rl rl 00 N w M � M M M Z m m N 00 00 r-I 00 ... W ri rl �--I W 0 O W � N H ate+ N z N Z SZ •� N N C6 N i LU .7 W Z W O v �7 � u = o — N v +- H L cn a x Ln N N W W Lu Z W � O (> Ln � E cn J N a 06 U cn bjOcn +_N-+ c6 ' c6 > ' N p • U N U �� A V) �_ > a_+ i Q cn W W X E N � - �C � � i > j j N N .0 .P 0 Q 0 O O E •> E D •� w Ln •U V Z Z - v U W Z J W cn °V' O � L a� � >. o O () L O N v ° L O c _0 O W > W > > C: 'o QJ oc L a� W a a > W W Q = v v� cn a) > V) L a) > DC ca V) L LL 0) LL +-+ — ii }, • � W � W � H Q LL _ LL L Q_ � O� a"' � ro J iG W iC W W� a6 � v O O O co — o C)6 4 -' cn aJ � +� v W W M 0A LL L c6 W W M� u v UD a a W v�" �U a s _� v a� ago L � �o � � � c� s L c� H H a C = Q c0 � o a) H H H u-1 ro M .0 �� w _V) .� o +� O O X v M a� + O O W OC c/) J— U— 02 U LL — U U O U U DC v) Ln H H Z ge 142 of 433 kgenda Item #7. VILLAGE OF TEQUESTA REVENUE REPORT - UNADJUSTED, UNAUDITED 10/31/2021 YTD BALANCE YTD BALANCE DESCRIPTION 10/31/2020 10/31/2021 VARIANCE % VARIANCE NOTES REVENUES Fund 001 - GENERAL FUND Sales & Use Taxes 66,771 31,162 (35,609) -53.33% - Franchise fees - gross receipt 44,042 46,208 2,167 4.92% Licenses & Permits 280 140 (140) -50.00% Special event permits Intergovernmental Revenue 15,021 15,950 928 6.18% Chgs for Services - Gen Gov 14,323 28,329 14,006 97.79% Land development fees Intragovernmental Revenue 85,937 71,362 (14,576) -16.96% Rents & Royalties 21,682 17,916 (3,766) -17.37% Miscellaneous Revenues 1 1 0 0.00% Differs from year to year Chgs for Services - Public Safety 62,264 64,430 2,166 3.48% Fines & Forfeitures 80 722 642 802.90% Code enforcement fees differs Impact Fees 0 851 851 100.00% Differs from year to year, due to new projects Charges for Services - Recr. 0 160 160 100.00% Other Financing Sources 0 236 236 100.00% Unrestricted Investment Earning 6 0 (6) -100.00% Total General Fund 310,407 2771467 (32,939) -10.61% Fund 101 - BUILDING FUND Licenses & Permits 262,001 56,196 (205,805) -78.55% Sea Glass & Reserve project permits Total Building Fund 262,001 56,196 (205,805) 100.00% Fund 301 - Capital Improvement Fund Total Capital Improvement Fund 0 0 0 #DIV/0! Fund 303 - Capital Projects Fund Total Capital Projects Fund: 0 0 0 100.00% Fund 401 - Water Fund Miscellaneous Revenues 0 3 3 100.00% Other Financing Sources 8,677 0 (8,677) -100.00% Capital connect charges, new projects - Sea Glass Unrestricted Investment Earning 12 0 (12) -100.00% Charges for Services 243,306 488,448 245,141 100.75% Total Water Fund: 251,995 488,451 236,455 93.83% Fund 402 - Refuse & Recycling Total Refuse & Recycling: 0 0 0 0.00% Fund 403 - Stormwater Utility Total Stormwater Utility: 0 0 0 0.00% Fund 605 - Special Law Enforcement Total Special Law Enforcement 0 0 0 0.00% TOTAL REVENUES - ALL FUNDS 824,403 8221114 (2,289) -0.28% TOTAL REVENUE LESS TRANSFERS 8241403 8221114 (2,289) -0.28% Page 143 of 433 genda Item #7. VILLAGE OF TEQUESTA EXPENDITURE REPORT - UNADJUSTED, UNAUDITED 10/31/2021 YTD BALANCE YTD BALANCE DESCRIPTION 10/31/2020 10/31/2021 VARIANCE VARIANCE NOTES EXPENDITURES Fund 001 - GENERAL FUND Council 6,384 3,627 (2,757) -43.18% * Manager 23,325 22,115 (1,210) -5.19% * Human Resources 39,751 35,280 (4,471) -11.25% * Village Clerk 33,069 30,399 (2,670) -8.07% * Finance 47,653 56357 8,704 18.27% Salary redistrib., ins., comp. system maint. Comprehensive Planning 97 1,164 1,067 1094.63% * General Government 44,027 18,006 (26,021) -59.10% * IT 71,471 43,312 (28;160) -39.40% Police Department 309,690 276,666 (33,024) -10.66% * Code Compliance 6,256 5,503 (753) -12.04% * Fire Control 324,895 263,238 (61,657) -18.98% * Public Works 90,299 63,053 (27,246) -30.17% * Leisure Services 59,517 80,693 21,177 35.58% * Debt Service 79,836 356,419 276,583 346.44% New debt service (rec.center, vehicles & SAN project ) Total General Fund 1;136,271 1,255,833 119,562 10.52% Fund 101 - BUILDING FUND Building Department 49,461 47,596 (1,865) -3.77% Total Building Fund 49,461 47,596 (1,865) -3.77% Fund 301 - Capital Improvement Fund Total Capital Improvement Fund: 0 0 0 0.00% Fund 303 - Capital Projects Fund Recreation Center 0 25,508 25,508 100.00% Recreation Center project Total Capital Projects Fund: 0 25,508 25,508 100.00% Fund 401 - Water Fund Water -Administration 153,299 1141209 (39,091) -25.50% * Water - Production 116,032 114,667 (1,366) -1.18% * Water -Distribution 68,705 43,827 (24,879) -36.21% Water -Customer Service 15,742 18,419 2,677 17.01% Renewal & Replacement 25,920 12,242 (13,678) -52.77% Decrease in Utility projects Debt Service 29,582 30,752 1,170 3.95% Other Nonoperating 3,045 0 (3,045) -100.00% Total Water Fund: 412,327 3341115 (78,211) -18.97% Fund 402 - Refuse & Recycling Refuse and Recycling 713 726 13 1.84% * Total Refuse & Recycling: 713 726 13 1.84% Fund 403 - Stormwater Utility Storm Water Utilities 24,968 21,100 (3,867) -15.49% * Renewal & Replacement 0 17,265 17,265 100.00% Drainage maintenance and improvement projects Other Nonoperating 8,820 0 (8,820) -100.00% Total Stormwater Utility: 33,788 38,365 4,578 13.55% Fund 605 - Special Law Enforcement Police 0 3,183 3,183 100.00% Differs from year to year Total Special Law Enforcement: 0 3,183 3,183 10.00% TOTAL EXPENDITURES - ALL FUNDS 1,632,559 1,705,326 72,767 4.46% TOTAL EXP LESS TRANSFERS 1,632,559 1,705,326 72,767 4.46% * Varies by department, different expenditures have not been recorded in FY 2022 vs FY 2021. Page 144 of 433 Benda Item #7. THE VILLAGE OF TEQUESTA REVENUE REPORT - UNADJUSTED, UNAUDITED 10/31/2021 FY 2022 FY 2022 8.33 % ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT % BDGT DESCRIPTION BUDGET BUDGET BUDGET 10/31/2021 VARIANCE VARIANCE USED NOTES Fund 001- GENERAL FUND General Property Taxes 8,158,070 8,158,070 679,839 0 (679,839) -100.00% 0.00 Historically, 91% receipted by the end of Feb Sales & Use Taxes 1,910,660 1,910,660 159,222 31,162 (128,059) -80.43% 1.63 State revenues one/two month behind Franchise fees - gross receipt 462,000 462,000 38,500 46,208 7,708 20.02% 10.00 Licenses & Permits 1,000 1,000 83 140 57 68.00% 14.00 Special event permits Intragovernmental Revenue 856,310 856,310 71,359 71,362 3 0.00% 8.33 Grants Federal 20,400 20,400 1,700 0 (1,700) -100.00% 0.00 Differ from year to year Grants - State 12,000 12,000 0 0 0 100.00% 0.00 Differ from year to year Intergovernmental Revenue 907,320 907,320 75,610 15,950 (59,660) -78.91% 1.76 State rev is one/two month behind Chgs for Services - Gen Gov 195,500 195,500 16,292 28,329 12,037 73.88% 14.49 Land development fees Chgs for Services - Public Safety 1,265,570 1,265,570 105,464 64,430 (41,034) -38.91% 5.09 Charges for Services - Recr. 46,190 46,190 3,849 160 (3,689) -95.84% 0.35 Fines & Forfeitures 18,500 18,500 1,542 722 (819) -53.15% 3.90 Code enforcement fees differs Unrestricted Investment Earning 8,300 8,300 692 0 (692) -100.00% 0.00 Rents & Royalties 255,190 255,190 21,266 17,916 (3,350) -15.75% 7.02 Impact Fees 1,500 1,500 125 851 726 580.51% 56.71 Differ from year to year Contributions & Donations 2,000 2,000 167 0 (167) -100.00% 0.00 Miscellaneous Revenues 12,230 12,230 1,019 1 (1,018) -99.90% 0.01 Differ from year to year Other Financing Sources 0 0 0 236 236 100.00% #DIV/0! Transfers In 0 0 0 0 0 100.00% 0.00 Appropriate Fund Balance 11145,230 1,145,230 0 0 Total General Fund 15,277,970 15,277,970 1,273,164 277,467 (995,697) -78.21% 1.82 Fund 101- BUILDING FUND Licenses & Permits 503,000 503,000 41,917 56,196 14,279 34.07% 11.17 Chgs for Sery - Gen Gov 1,400 1,400 0 0 0 100.00% 0.00 Appropriate Fund Balance 171,860 171,860 0 0 Total Building Fund 676,260 676,260 56,355 56,196 (159) -0.28% 8.31 Fund 301- Capital Improvement Fund Unrestricted Investment Earn 1,000 1,000 83 0 (83) -100.00% 0.00 0 Transfers In 677,260 677,260 56,438 0 (56,438) -100.00% 0.00 Differ from year to year Appropriate Fund Balance 87,000 87,000 0 0 Total Capital Improvement Fund: 765,260 765,260 63,772 0 (63,772) -100.00% 0.00 Fund 303 - Capital Projects Fund Unrestricted Investment Earning 500 500 0 0 0 100.00% 100.00 Transfers In 87,000 87,000 7,250 0 (7,250) -100.00% 0.00 Differ from year to year Appropriate Fund Balance 254,500 254,500 0 0 Total Capital Projects Fund: 342,000 342,000 28,500 0 (28,500) -100.00% 0.00 Fund 401- Water Fund Grants Federal 0 0 0 0 100.00% 0.00 Differ from year to year Charges for Services 6,346,500 6,346,500 528,875 488,448 (40,427) -7.64% 7.70 Unrestricted Investment Earn 8,400 8,400 700 0 (700) -100.00% 0.00 Miscellaneous Revenues 48,500 48,500 4,042 3 (4,039) -99.93% 0.01 Differ from year to year Other Financing Sources 4,457,000 4,457,000 371,417 (371,417) -100.00% 0.00 Loan proceeds Appropriate Fund Balance 2,076,950 2,076,950 0 0 Total Capital Projects Fund: 12,937,350 12,937,350 1,078,113 488,451 (589,662) -54.69% 3.78 Fund 402 - Refuse & Recycling Charges for Services 500,940 500,940 41,745 0 (41,745) -100.00% 0.00 Historically, 91% receipted by the end of Feb Unrestricted Investment Earn 500 500 42 0 (42) -100.00% 0.00 Appropriate Fund Balance 28,570 28,570 0 0 Total Refuse & Recycling: 530,010 530,010 44,168 0 (44,168) -200.00% 0.00 Fund 403 - Stormwater Utility Grants & Contributions 30,000 30,000 - - 0 0.00% - Charges for Services 497,810 497,810 41,484 0 (41,484) -100.00% 0.00 Historically, 91% receipted by the end of Feb Unrestricted Investment Earn 1,400 1,400 117 0 (117) -100.00% 0.00 Transfers In 150,000 150,000 0 Appropriate Fund Balance 0 0 0 0 Total Stormwater Utility: 679,210 679,210 56,601 0 (56,601) -100.00% 0.00 Fund 605 - Special Law Enforcement Unrestricted Investment Earn 0 0 0 0 0 100.00% 0.00 Forfeitures 0 0 0 0 0 100.00% 0.00 Appropriate Fund Balance 74,920 74,920 0 0 0.00 Total Special Law Enforcement 74,920 74,920 6,243 0 (6,243) 0.00% 0.00 TOTAL REVENUES - ALL FUNDS 31,282,980 31,282,980 2,606,915 822,114 (1,784,801) -68.46% 2.63 TOTAL REV - LESS APPROPRIATION 26,529,690 26,529,690 2,210,808 822,114 (1,388,694) -62.81% 3.10 Page 145 of 433 Age THE VILLAGE OF TEQUESTA EXPENDITURE REPORT - UNADJUSTED, UNAUDITED 10/31/2021 FY 2022 FY 2022 8.33 ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT % BDGT DESCRIPTION BUDGET BUDGET BUDGET 10/31/2021 VARIANCE VARIANCE USED Fund 001- General Fund Council 77,350 77,350 6,446 3,627 (2,819) -43.73% 4.69 Manager 306,720 306,720 25,560 22,115 (3,445) -13.48% 7.21 Human Resources 385,040 385,040 32,087 35,280 3,194 9.95% 9.16 Village Clerk 373,940 373,940 31,162 30,399 (762) -2.45% 8.13 Finance 715,220 715,220 59,602 56,357 (3,245) -5.44% 7.88 Legal 190,000 190,000 15,833 0 (15,833) -100.00% 0.00 Comprehensive Planning 281,540 281,540 23,462 1,164 (22,298) -95.04% 0.41 General Government 314,310 314,310 26,193 18,006 (8,187) -31.26% 5.73 IT 476,650 476,650 39,721 43,312 3,591 9.04% 9.09 Police Department 3,558,370 3,558,370 296,531 276,666 (19,865) -6.70% 7.78 Code Compliance 124,480 124,480 10,373 5,503 (4,870) -46.95% 4.42 Fire Control 4,172,295 4,172,295 347,691 263,238 (84,453) -24.29% 6.31 Public Works 1,546,915 1,546,915 128,910 63,053 (65,857) -51.09% 4.08 Leisure Services 942,080 942,080 78,507 80,693 2,186 2.79% 8.57 Debt Service 886,280 886,280 73,857 356,419 282,562 382.58% 40.22 Interfund Transfers 827,260 827,260 68,938 0 (68,938) -100.00% 0.00 Other Nonoperating 99,520 99,520 8,293 0 (8,293) 0.00% 0.00 Total General Fund 15,277,970 15,277,970 1,273,164 1,255,833 (17,332) -1.36% 8.22 Fund 101- BUILDING FUND Building & Zoning 676,260 676,260 56,355 47,596 (8,759) -15.54% 7.04 Interfund Transfers 0 0 0 0 0 100.00% 0.00 Other Nonoperating 0 0 0 0 0 #DIV/0! 0.00 Total Building Fund 676,260 676,260 56,355 47,596 (8,759) -15.54% Fund 301- Capital Improvement Fund Public Works 419,590 419,590 34,966 0 (34,966) -100.00% 0.00 Interfund Transfers 87,000 87,000 7,250 0 (7,250) -100.00% 0.00 Other Nonoperating 258,670 258,670 21,556 0 (21,556) -100.00% 0.00 Total Capital Improvement Fund: 765,260 765,260 63,772 0 (63,772) -100.00% 0.00 Fund 303 - Capital Projects Fund Public Works 255,000 255,000 21,250 0 (21,250) -100.00% 0.00 Recreation Center 87,000 87,000 7,250 25,508 18,258 251.83% 29.32 Total Capital Projects Fund: 342,000 342,000 28,500 25,508 (2,992) -10.50% 7.46 Fund 401- Water Fund Water -Administration 1,377,790 1,377,790 114,816 114,209 (607) -0.53% 8.29 Water - Production 1,945,290 1,945,290 162,108 114,667 (47,441) -29.26% 5.89 Water -Distribution 742,350 742,350 61,863 43,827 (18,036) -29.15% 5.90 Water -Customer Service 279,450 279,450 23,288 18,419 (4,868) -20.90% 6.59 Renewal & Replacement 3,657,000 3,657,000 3041750 12,242 (292,508) -95.98% 0.33 Capital Improvement 4,442,000 41442,000 370,167 0 (370,167) -100.00% 0.00 Debt Service 493,470 4931470 41,123 30,752 (10,371) -25.22% 6.23 Other Nonoperating 0 0 0 0 0.00% 0.00 Total Capital Projects Fund: 12,937,350 12,937,350 1,078,113 334,115 (743,997) -69.01% 2.58 Fund 402 - Refuse & Recycling Refuse and Recycling 530,010 530,010 44,168 726 (43,442) -98.36% 0.14 Other Nonoperating 0 0 0 0 0 0.00% 0.00 Total Refuse & Recycling: 530,010 530,010 44,168 726 (43,442) -98.36% 0.14 Fund 403 - Stormwater Utility Storm Water Utilities 351,690 351,690 29,308 21,100 (8,207) -28.00% 6.00 Renewal & Replacement 282,000 282,000 23,500 17,265 (6,235) -26.53% 6.12 Other Nonoperating 45,520 45,520 3,793 0 (3,793) 0.00% 0.00 Total Stormwater Utility: 679,210 679,210 56,601 38,365 (18,235) -32.22% 5.65 Fund 605 - Special Law Enforcement Police 74,920 74,920 6,243 3,183 (3,060) -49.02% 100.00 Total Special Law Enforcement 74,920 74,920 6,243 3,183 (3,060) -49.02% 100.00 TOTAL EXPENDITURES - ALL FUNDS 31,282,980 31,282,980 2,606,915 1,705,326 (901,589) -34.58% 5.45 Notes: 1) Personal expenditures/expenses recorded as when paid not when accrued. Personnel paid 10/28/21 for the period ended 10/23/21. 8 days of personnel expenditures not reflected in October 2021. 2) Not all operating expenditures/expenses recorded for the services up to 10/31/2021. 3) Village will be recording expenditures related to FY 2021 up until November 15th. Page 146 of 433 M N ri M Ln Rzl- O W Ln lzT Ln Ln n N � 00 rI rI M N T-4 �O M N Ln rI qzt m M N N O 00 N I� N c-i c-I c-i r-i c-I M M 01 d1 M 00 O M M Q0 l0 Ln M M I� M Ln N rl l0 rl rl rl V--1 qzl- Ln m � m � m m rl m M rl l0 rl I� N rl M 00 N CV rl rl CV rl I N rl O r-I N N O \ N V--1 \ M V--1 \ M 00 0\0 O O M M N N O O � (V I* N M m Ln N N rl l0 O Ol N rl rl N rl \ M Ol �n 00 �n O 00 rl m Ol Ln Ol M M rl 00 N 00 O M rl m N N rl M M O O r-1 r-1 cn L- O DC E E L M C6 Q Q w w o 0 to rl .r. 4-0 N N O •�W N : £ Ln >- m v aA u wL v v i N _0 Ln•� O O •a) aA _ _ LU 0 V a- O N 00 O N }�—' O }' E v _ �> ca �Q ca v cn 4A V Q N `� ca .� j v '� aj a v 2 N � E � O p O p v Q +, N v +, ca v ca cn U +� N _ O z: m v QLn v Ln ca oc +, � O cu � v � G U- v -0 m O D U a, C G N C6 • Ca E — • Ca u N U N CT _0 O p � Q i U cn cn cn cn — +_' V v 4-J V Q� u aJ oC U U � O 0 O ra c�i� c�i� can v U N +� v pC w N M U v O_0 — � — Q 00 w can ca U ca U ca U E a J E LF— _� CL _ n ra cn E f E �O -0-0-0L Z U � U � V O w U a- w U LLmm U Z U U U V) O ca O > ca � L � O N v � V C Ln ca � b.A U }, cn — °� •wo v U 'age 147 of 433 Ln Ln O w m O O m O O N rl Ln M m W O M N W Ln I� Ol cV r-IN 0000 (V O Ol LI n r l0 O Ln Ln O � � O O Ln �D O Ln O m O r�4 O O � ri 00 � 00 rn � M I:t M O �t rn r-i N rl `� O ko l0 N O O N M 00 0000 Ol I� O Ln O l0 O m rl N O rl � rI Ln Ln M rI rI N I� 00 O � N m N � l0 rl lD 00 rl `� O Ln l0 N N O � (M � rl � M 0000 I� O I� O I� O N O Ln O rn r-I I� O N N I� M rI l0 00 00 rn N Ln fV N I:t I:t rI l0 rl O cV Ln l0 N r*4 O � M � rl O m 1 0 v cr V) cc U a) : 0_ DC aJ � LL iz C O � m U u 4J U aJ > V i ate-+ N p O — a, Ca Ca I L +_+ E v Co m U a) E 0 ca 0O O u O E �N N U v v O N a= v u Lu M a=+ s U Co V o X v >. u p m a cc '�' v aA � � (n _ _� > E +-+ O > a- J ro N U i cn lD N \ V cn ca }, O a) m N v, ' 4-0 ca a� u N E aN+ V O N ateJ W aJ ' � c6 E ca C: — aJ n 4A N ' � bA cn N a--+ > N U N wo � a) a--+ < Qr. (A ate+ ate-+ U-)N O O O V .- N 0 m N cn � 0 m Q Q p c U> -J v z ca ' CIO c ca cc O m D fo a- a-J o U S LZA �J a- a-J a-J •— ++ ✓ • _v O 0 XO 0) v � }, a� LL O Z �U Q Z0a) U ca cLL � ramv 4-0 N O a Q NU U- p Page 148 of 433 01 O O rl O ry QO c6 O V O 00 Q Q z O O o ru a� O rl M I� O N CV 00 I_f) O O lO M rl rl 00 O M I� O N M rl O rI rl l0 N I� Ol M Ol I� N N LL rl O Ol (N Lr) N 00 B O O LO M rl rl 00 O M I� O N M rl O rl r� r rn M rn � N � a- J O � N \ O Q p z M � O 0 O 'L rl lO N O O rl rl Ol Ol a-j al C: 00 O -U - 2Q O z U tw �..� is U � N O m N O M �C +_+ \ (A ca O •— }, O 0 06 v � _ a (Aw z N w V C: E i O L 0 v >LA N O N +�+ m M w a a) a N 'fB cn E06 U � Q N U +.+ O _0 _0N ' 7 - M O V a +_+ - _ �, > > _ > > V n O O O N fa V) U +' _ V p O a J \ UL i -N N Ln0 + i U U O }' O 0 O N cn O s O O ca U O r O � +� v i N E O O Q bn�- W I E O _0 O + O a. N � oc m p � N 0 Ca m fa_ U U C:U Q �O _ w U U) m O U v O _NQ •++ > Qa-+ m w w w CO ru =3 dJ N a O O Q O O 6L w w w w J 2 z V) Q 2 d z Page 149 of 433 00 00 Q Q N O O O O N O O O \\ \ N O O O � O O O r-I O N (.0 N O O z z r1 r-I Ln r-Ir-I - N r' N O N m 00 Lrn N o 0 0 Ln � o O � 0 0�Lr) 0 0 o N `� 0 0 00 0 00 r-I r-I r-I � l0 r-I r-I N N N M r-I 0 0 Q Q N O O O o 0 On 00 0 OM M O O O O � O O t0D 001 O NO 00 � Z Z O M N l0 Q Q N O O O O O 00 O � \ � 0 0 O O O O O O N B C 0 p Ln z z r1 m m 00 O a o c0 4-0 D LM V •— 4-0 � � — O \ L i _0 a � � a N .o � N a v V N N Ln a� v �, N H -00 N a) ra N0 _ b-0 cu p[ +N.+ v ca a_ N U ca U N — ca \ N V) C: ca cn N vU cu EN ico ca t�A 4-J p ca � p (A cago c ca O pv v+ QN \raa ra .— GJ •— O nUwa- �7 a� LL c O w � U� � � -se OO ur) v O O O O O ru � U v U O 4- > (1) O— v E — u u u v u � 4J Ll G1 u v L Iz O ~ ru oG GG IZ U � cn � (7 � N 0 = WJul LL LL LL LL LL — Page 150 of 433 O O r-I r-I ��-I u1 O r-I O r-I � N ��-I O M 01 O rl M N r-I N M O O m R::I- G) r-I m rl r-I lD O M N r-I 0 rl 00 N N Ln N Ln N I_f) r-I rl rl rl N Ln Ln Ln N o 00 fa u Q U to L.L Q r-I M 0) O rl M CV r-I fV M O O M fV R::I- (3) M r-I l0 O M O CV rl N rl N rl 00 N N N N Il1 r-I rl f� rl N I_f) N _0 O m � rl Rt N 00 O O O N M 00 N r-I 00 -:* Ln O lD rl M rl fV rl O 00 N l0 O O Or-J � r-I N rl NO r-I NO 0 � Q i a � O LM o .p CL m E a °' v a V E a cn E O +i a a a E UO - 0 0- v Ln 0° � a) O c 'D a n Ln E v v 0 w w V O a Ma a O+ Oa n� ~ Ca p \- a m r ca � N ,>aO 0 w 0- a � CO aC w U ca � Y 0 e L � - a + cn N v O }' V) ca OC -0 p a u 'i N O N v m 'i 'i O— a — a +, C U C a- +p+ +� a w O — > v� O +.1 �O O 0 U U — 'ca a +� O bA c� u '(A — OL }' N k ; O +� a) cn cn cA ' � Ln .5L. o ia O O nca O_ }O, .4-4N+ CaA —u1A v a o a, ocru - �' a..r m O O O O Ul O cn G O U ii oC Q U U O or-m fu a .bn O L7 or_in 2= > V) w U l- I a- 0 V I 1 a 1 1 1 1 1 1 Q O Page 151 of 433 r-I N O N O N O O Ln nri m Ln M N � o N M Lr) I.n O I.n O O r� M 00 O O O M 00 01 00 N M O I� 01 N rn a) N N r o r-I M r-I N r-I r-I r-I 0) r-I M N r-I Q �0 fV m o� M N Ln Q0 \ O cn o J Q ate-+ o (0 In cV r �MO o0 r4.4 O N r-IrLn� rLn Q O O (.0 0 0 Ol O O Ln m O � I� O) l0 r-I CV p rV 't 1 cv M N l0 r 00 r-i r� r-1 r-I U r-i O N O ri M M I'0 qt O O O O N O w O O O O w m M O1 Ln 00 r N Ln Ln O r-I r-I o M N O rn Ln Ln Z5 O v M: E bn c — uLn v v }' O o 0 0 ca U V 4-j Q L c� u V -o ° E ai 0 U ra a Q =3 cr iJ ra +' � C1A i a i u o 7w ra •� aJ a U aJ Ln '� a--+ a) aJ aO-+ �_ •� N v 'm m 0 N v to to p U aJ OE v N Ur 0 Q �, U a Q N 2 n O V N _0 aJ N N a a aJ U aJ aJ o U v v -0 v Q _ i • aA O O • NU O+j N i •� •� aJ Ca 4-J L O (a aJ CO aJ E CL ) aJ •� 0 0 aJ to 4A "' Q O p o U O N � cn cn cn — cn aJ � � • � � � � _ +-+ � +-+ s � aJ 4- � � [a U � ra U � U U U � p O aJ aJ aJ aJ Q t�A O 0 Cep •� O •� +, +j N cn N = _ U oCflu 0 U -0 a) Z• LaJ Ln -aO N Q O O O � m p i tti0 w cn aJ w OO 1 O> 0 �� D Q U o w Page 152 of 433 M Ln 00 O a O 00 a s 00 (Z M O O a Q a ,� a I--, \ z �n M N � r-I \ z \ z N M �n r-I Ln M �C �C \ z z z 00 m z l0 I� Ln r-I 00 I;t N 00 Q I� M Ln M r- I� a Om al 00 lD Q Q Q O � m N r-I "I-, z I� N N �n 00 N lD z z z z `� M QO N Ln Ln Ol M O m rq 00 �o r-Im Ln o� Ln M a a a a r-I M Ln rn M 00 Ol 00 Ql N a O N Ol 00 N 00 \ \ \ \ r-I rnr-I �n cM 00 N M N MCF) z z z z z N Ln M M O p O O) � O N `- n I� r-i r-i N cm r� 00 N I.n O 00 0 -;t 0 00 m r-1 0 O O N r-I r1 m r� I� 00 rll_ I:t 00 00 r-I N m rn m m rn N O N � N _ Q r bA _ ra N V ca bA c Ln O ai N Q E � m ai V) OE }' ai _0 D ai co V, aN-+ •�, +j ca v � s � _0z U V) V)> ,� +, Q >, v O o > O z N _ ' L v o v cn � `� - � O o o U . � Li C C N N N � � aj U — � � +� — •— U O aj (� +-+ — O — ai a) Q ajbn Ln N ca O ca m Ln LnV) V) O p cn • U �0 +�—, > Q Q Q N U +j LA aj _� v '> v o _0 v N ai L _ •� v Of o o Ln �, v v a, aj u ai U Ln ai Ln ON — aj O — bA > v v acNnJ N _ cn N Ln bDte4-J O V)U Ln aJ ccannJ +� +� Q O O O N ca Q) bA V)O O V) � (Li Up a) E p O 0 0_ m O V) CL p � O E E aj w OO — O bA cnUp n} O ai co Cf cn vv ++ +- , � cn Ln ai -0 Q aJ aJ +� > chi) +N-+ i E Ln O - p � }' p E 4A bA v) Ln w ca N ca 2 O N Ln LL O cn N •— •— U i O p — O p 0 ca ca }, 4- z +-+ N U DC U v> < a v o O ,� a'° `� a� H V) v (A v E Q M N a) _0 ca ca v o v ai m a ai Ln aJ a1 ' ' O O O v— bA a� � — — DC v bA C ca U = U M b.0 M +� O bA to O O N N v c6 _ N cn +_+ +_+ +_+ v m J m-0 c M v v +J LL� O +� _ v� Q O 'v1 m m U U U bA , dJ E bA bA p c6 i O ai aJ 3 aJ a) a o a J J_ a a z a _ OL U o V) CO w w w Page 153 of 433 N L aN-+ dJ ca N Q N M M O r-I rl M M 00 rl lD O s -av n N N N = o O `-L'� O N U. -0 Ul 'ca Ln N a)m _0\ Ca Ca U v v � N v v v ru le C: L N 'm (n L — _ N l� _v U Ln -0 O Q C O c N r ,N \ V ca M " `n _O O �--I cn O ca N m U N cn c6 N O '� U Ln +.+ Ln .E W a� _ c6 N E O > L- O cy) � m �--I N t.6 Q U l" � N O cn U • O E Ln bA _00 < _0O V a a; � +j Ln N 0 0 ca a--+ ate-+ Q cvi� v v a� =3 :3 _Lns _0 }, Q 'v v � O Ln O • 1 • Ln LA E/ \ V /v W bn 0 E ca L • a s T O �O ru � =3 a-J v m N }, 0 u _0 Ln}OZ3 c� ' �0 O oc Q 4- r. o � _0 .S o � 9 � U C: a 2 }+ O 4-1 v �' v _0 _0 o v c a a O •— LM O -0 ca U O ' 0 0 O N � +- o Ln v vLlr) o o O 01 +' cu +�•+ a) U-) OU LU (_0 4 v o E Ln ca �, LL 4- CL E v J s O O E > E L O s O O +4-1Ln L0 ov v Q o � � _� �' v0 : Oo _ � o a, _ v+� N N �D E QN Q E v — .� O � m i N U Q i O O u 0 c6 z = cn Ul fa i 0O Ln N ^� m L.L _N N 4-1 cn m — u dJ — cn _0 > a o � 0 X v +, 6 U UD co N 4J — �>V a � a) + � o E O v � O w dJ U N 0) c6 > O • }� N -0 i 9F Q > • > +-+ +-+ (� 0 0 F = U E > Z � w w cn Page 154 of 433 Agenda Item V. Z6'699 88E 1 99'08l LOI 00'000 96 1 E-V'996 966 Z le}ol peaH }uaw}ie as :Aq pa}}lwgnS [OZ :aagwnN }uaw}aedea - - (s;saA 9) saeaA oanl JOI 1e101 - - papun3 - - ssoiboid ul - - papaeanv - - sua o poijad juejB se Aldde o} pua}ul pue pai;l}uapl aney }}e}S sauop Apnr EO'896`Z9 EO'896'Z9 - $ - $ - $ EO'896`Z9$ 6ZOZ/Z6/Z sawoo}nO }ueaO yW33 aai3 }ueaO spa}y i}a�U o} aoue}slssv ** *+�+��*�#;#;# 66 @ 68-6$$ fi9Z6� tZO �91vi !ice � ICI F)u,punA Ad6� 66�68 tZ6zk �d u.aoH AalwlA i3nivA# i3n-lVA# a81 ZZOZAJ SWl 38d- `dW33 s�jo/A oilgnd nwwoO-V aan}on}sea;ul }uallisad buippe uaoH AGlwl>i iAnivn# ijn-lVA# a81 ZZOZAA SWl O8d- `dW33 s�ao/A oilgnd nwwoO',g aan}on}sea;ul }uallisad buippq pleuoaoW ipu O 00'000`V1 00'000`-n - $ - $ - $ 00'000`V[$ ZZOZAA ZZOZ 1.3 sawoo}nO }uejE) yW33 ajld / 11 }ueaO saa}y i;aald o} eoue}slssy u!IglJ'}-j 00'00t `Zt 00'006`Z� - $ - $ - $ 00'OOt-`Zl $ �ZOZ.l3 �ZOZ Aj !AJaS leoipaW oua aaw3 }unoO yoea8 wled aai3 }uea0 SW3 O8d sauop Apnr 8t,•tEE`L 8tl'8ZE`LEl 00't,66`6Z� - $ 8V8ZE`Lct $ OZOZ/[c/O[ OZOZ4/E Alunoo yoea8 wled aa!3 alAO3 }ob' S32JVO sauop Apnr £E'6E6`00 L9'V90`61l 00'V66`6Z� - - $ L9'V90`64 t $ OZOZ/lc/9 OZOZ/�/E ol}ej}sluiwpy }uawa eueW Aouabjew3 leaapad aaid }ueJO a1AO3-b'W3d uipun,j Adwd 00'000`09 00'000`09 00'0$ 00'0$ 00'0$ 000`09$ ZZOZ AA OZOZ A3 uoi}oa}ad le}uawuoainu8 }o Idea epuo13 uol}eaaoaqj Naed uoi}n}l}suoO uipun,j >IdWd 00'000`09 00'000`09 00'0$ 00'0$ 00'0$ 000`09$ ZZOZ AA OZOZ A3 uoi}oa}ad le}uawuoainu8 }o Idea epuold uol}eaaoa�j sped aoueagwewa�j uaoH LalwiN iAnIVn# i3f}Tdn# 000`93 W9'V6 LZOZ/K/6 I ZOZ/ 11/91 }uejo ain}ona}sea;ul leaauaO uol}e l}iW J8aO slaoM ollgnd speo�j Apnwwoo gn10 Aijunoo pleuoQoW ipu O 00'000`096 00'000`09 t - - - $ 00'000`09l $ uol}oa}oad le}uawuoalnu3 }o }uawlie ea epiaol j sal}ill}n wea oad IME) epuo13 }uallisa�:l pleuoQoW ipu 3 09'tt,6` 6E$ 00'980,$ 09'990`86$ 00'st 9`9l$ 00'000`03 00'000`OE$ EZOZ/OE/9 6ZOZ/6Z/9 1011081OJd 1e}uawualnu3 }o }uoupe ea epiao13 sal}ili}f1 }ueaO 61 £ }ueaO aoanoS }uio uoN nnaaaoW;aly3 Issv 00'9ZL`08 00'9ZL`08 00'91�L`8Z$ 00'9vL`8Z$ 00'0$ 00'OLt,`60l•$ EZOZ/Z/9 OZOZ/E/9 }uawa eueW pueg jo neain8 ad }uea0 Wg8 - ad acid sawep ll - - 00'099`9l $ 00'099`M 00'0$ 00'099`%$ t ZOZM/E OZOZ/9l /l l le}uawuoalnu3 Alunoo yoea8 wled ad }ueaO as}eueW ad MaaSoW;aly3 Issv tL'9L 96'LL6`-V 9Z't'Z8`8b$ 90'ZZO`9tl$ 00'0$ 00'000`09$ ZZOZ/b 4 OZOZWL }uawaojo}u3 meg }o;uawpedaa epuold ad }ueaa GIA03 - ad ualowS 4EN '}1 60'LZ8`V 9L'986`V 9VMZ` 6$ 09'8E[`�$ 00'0$ 9Z'VZ[`9$ ZZOZ/8Z/7 OZOZ/6Z/V aol}snp;o }uaw}iedea Sf} ad }ueJO noway APOO ea sluiva py ;ueaE) saan;ipuedx3 aanof( JLIO senuana2{ aano�(aaeC) saan;ipuedx3 d-17A senuanab d-1-A o;e �C;i 4 W a ;unoua uea d; WO uoi euluaaa ; 1 ;uea WOuoi ani oa ;uea ao uea J uaw eda 4 auae uea N J }aaysij.ioM ja6pn8 }ueaE) e4senbal jo afiell!n Page 155 of 433