Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Documentation_Workshop_Tab 06_3/14/2019
Agenda Item #6. Workshop STAFF MEMO Meeting: Workshop - Dec 02 2019 Staff Contact: Jeremy Allen, Village Manager Department: Manager Discuss 5-year Capital Expenditures, Financing Plan, and Recreation Center At the workshop in November staff was tasked with the following items: • Operating cost for the proposed Recreation Center • Parking agreement for Recreation Center • Fund Balance (with Recreation Center) • Wort case scenarios using property value decreases • Current Millage Rate compared to other Palm Beach County Municipalities Operating Budget for the proposed Recreation Center (Summary) Category 10/1/19- 10/1/20- 10/1/21- 10/1/22- 9/30/2020 9/30/2021 9/30/2022 9/30/2023 Expenses Revenues Difference $657,350 $90;000 -$567,350 $5677965 $457000 -$522,965 $5757834 $457000 -$530,834 $861,930 $2271500 -$634,430 Recovery 14% 8% 8% 26% Shared Parking Agreement • Staff has met with Pastor Mike about a proposed arrangement. The Village Attorney has draft an agreement to provide to the church to consider. The agreement is under consideration. Fund Balance • Based on the projected operating cost for the Recreation Center the impact to the budget will be an additional $105,000. This takes into consideration a 26% recovery vs. a 14% recovery. Worst Case Scenario (Downturn in Economy). FY 2021 FY 2022 FY 2023 FY 2024 Estimated Estimated Budget Budget ($2307373) ($4867932) ($264,638) Millage Rate Compared to Other Municipalities Estimated Budget ($416,851) Estimated Budget Page 38 of 53 Agenda Item #6. 2019 Final Millage Rates 1 Manalapan 16.7373 2 Town of 16.7774 Palm Beach 3 Hypoluxo 17.4963 4 Highland 17.509 Beach 5 Gulf Stream 17.5699 6 Cloud Lake 17.7544 7 Glenridge 17.7544 8 Boca Raton 18.3027 9 Jupiter 18.9669 10 Jupiter Inlet 19.2461 Colony 11 Ocean 19.6463 Ridge 12 Royal Palm 19.6744 Beach 13 Palm Beach 19.8463 Gardens 14 Palm Beach 19.8463 Gardens 15 Juno Beach 19.8621 16 Palm Beach 19.9461 Gardens 17 Wellington 20.2244 18 Village of 20.2545 Golf 19 Delray 20.5738 Beach 20 Lantana 20.6674 21 Greenacres 20.6963 22 Loxahatchee 20.7544 Groves 23 Palm 21.0055 Springs 24 Tequesta 21.0251 25 Palm Beach 21.0753 Shores 26 North Palm 21.2093 Beach 27 South Palm 21.3479 Beach Delray 28 Beach - 21.5738 DDA 29 Boynton 21.6093 Page 39 of 53 Agenda Item #6. Beach 30 Atlantis 21.9763 31 Riviera 22.1613 Beach 32 West Palm 22.176 Beach West Palm 33 22.176 Beach 34 Haverhill 22.2544 35 Lake Park 22.5148 36 Westlake 22.8794 West Palm 37 Beach - 23.176 DDA 38 Lake Worth 23.7719 Beach Lake Clarke 39 Shores 24.0342 40 South Bay 24.0633 Mangonia 41 Park 24.0963 42 Belle Glade 24.2963 43 Briny 24.2963 Breezes 44 Pahokee 24.2963 Operating Budget 2 11-8-19 3 year and 5 year downturn (SIP pat-I-ot PBC Millage Rates 2019 Page 40 of 53 Agenda Item #6. N 0 0 O O \ � N M 00 �- N N N O _ O O V N N 00ft. O Ln � \ Ln O \ L � t O M =5 N Ln O Q1 O N � M Ln �- \ O i O N O r-I N OLn O M O O Ln O1 M lD �- M C1 O O Ul Ul Ul Q > cc U X w oC 00 O M Ln qj)- I Q0 O1 N Ln -(h w 0 N 0 00 O N U U N 5 i aA ra cn O O O U T-j M 0 00 0 i 0 NO 0 C: cn +-+ i :3 U a-+ •— O C: CO N b.0 •— C: cn rl \ r-1 \ fV O N rl Page 41 of 53 Agenda Item #6. O O O O O O O O O O O O O M O O D Ln O O O O O O Oft. O O N O O O 1� O Ln 0 0 0 0 0 0 0 O \ .4j). 1 1 N O Ln Ln M ri O Ln O Ln Ln ri \ I� cV V)- V)- tn• if)- N tn- M l0 rl t/)- O N rl 1h i n tn• tn- M tn• tn- \ O N N r-I O r-1 rl 1:t � �D r-1 00 r-i Ln 1:T M Q0 � O N oo q* � Ln N qt N M 1� cm o0 ri -c:t N M M N rl rl N rl M 9t O N M O N O rl m y J` M ri m oo R:t (10 M ri \ cV Ln in- i)- tn- tn- rl tn• N M rl tn• O N tn• qj)- -c/)- qj)- q)- M qj)- \ 01 N O � r-1 X 00 � M M Olzt O� (.D N N lD O LU �lzt M rl Ln Q0 N QO Q0 00 � 00 M N N lD M N rl O N O M M M r-I O O hA O O cri �" M ri M o0� M Ln ri rl Ln qj)- if)- - -(J)- V)- 4J)- N M tn- a--� cV tn• qj)- V)- -Ln- -(J)- � M �- L � � O N O\ O r-1 O O O O O O O O O O O O O O O Ln Ln Ln O O O O O O O O O N M rl rl O N O N M rl rl 00 O 1 1 N N rn M i M rl m oo � M � N rl \ rl � tn- tn- tn- tn- rl tn- N Ln rl tn- O N tn- qj)- qj)- V)- tn- M 4j)- 01 01 r-I r-I \ O r-I U c V) ca �j O cn N U v) �' Q C V) O c- \_ C) m +j O a1 Q +� Q ca , U m-0 ca 00 u -a}, C: O >. ,L 0 N L U 4 v c6 C) �_ .�cz — , .— _ Q � U O �Ln O ca � m + O 0 U E Q U U O i O 0 U V) U Q L- w O Ln 0 0 0 0 0 0 0 0 0 0 Ln 0 0 0 O O O Ln Ln Ln Ln O Ln 0 l0 m O O O O O m O m Ln O O O M N N rl O I� c-I cal 0 0 M O Q0 00 1� O N M M rl M 1� Ln I N O I� rl rl rl N rl cV I� rl M M M I N I� N M � N rl M tn• in- tn• tn• tn• N rl M tn• tn. tn• M tn• M tn• tn• qj,)- Ln tn• tn• in tn• tn• rl tn tn• tn- ,Zt O O O O O O O O O O O O O O O O O O O O M O tn- O O O O qj)- tn. O O O O qj)- O O O O O O O M rl O O N1. O O O O 1� O O O Ln O1. O Ln rl rl Ln � r-I rl rl Ln O r-I Ln Ln rl Ln (V rl N O N Ln t/)- in- IA- i)- in- N tn• 1n rl in rl -(/)- qj)- qj)- lzt tn• tn- tn- tn- tn• tn- Ln O O O O O O O O O O O O O O O O O O O O k.0 O -tn- O O O O -tn- -tn- O O O O -tn- O O O O O O O rl O O N O O Ln O O Ln M rl Ln rl rl rl Ln O r-I Ln Ln rl Ln N rl N M cV Ln tn- -LJ in- tn- tn- N tn- tn- rl tn- rl tn- tn• tn- -Ln -ch -tn- {M � O O O O O O O O O O O O O 00 O O O O O O Ln O -tn- O O O O tn• tn• O O O O tn- O O O O O O O I� rl O O N O O O O I� O O O O O I� Ln Ln I 1 rl \ Ln \ 1 rl \ rl 1 O \ N \ (.0 \ rl \ Ln 1 1� \ N 1 L0 \ N \ M 1 00 N Ln tn- t4 tn- N rl M tn- tn- Ln tn- M tn- tn- tn- t/)- -Ln -tn- tn- tn- {M n - ca `n U � ca L � t/') S✓ O � N U Q � U O � � � O � +� ca •� 'C ca C: cn +-' — Q m +_+ cn � — �_ � cn 4te1 U cn � Ln • O � N cn C�0 +� _ ca a • Q _ = .CL M cn w O \ \ •� O ca U — (J N N cn CUO w +� s O to �' to cz — CAA ,� L O U U ate-+ a_' _� N E �' O cn Q �' ca ca L O . — 4-1O — +-' � J to O d- D U m O a m O 2> V O Page 42 of 53 Agenda Item #6. W E O U L O �n E Ul :3 V) U C: V O N U oC O 00 O N 00 M rl*, O O M lL0 n rl M -cry- rl*l 4j)- M O 00 O O OQ -cn- O Lr). . N Lli Ol qj)- M L r) 4j)- 144- r-4 Ln Ol if)- M Ln -V� I -V} m 00 cV Ln N I� \ Ln O tom- M aA O L Ln N l0 O Ol 1 Ln O I U L a--+ O U O O O -OLn O Ln q:t% O% 110 M V /- r-i . V fQ0 .Ln 00 V 1 N N 00 Ln -V! 4-J c .— O Q Q O =3 }' V) LU ca (Un O 0 O L • N — O a1 Q O O Q Q ate-+ O U G cL o I LL Ln .E M L.L i i� Page 43 of 53 11/25/2019 BUDGET REPORT FOR VILLAGE OF TEQUESTA Agenda Item #6. 2018-19 2019-20 ACTIVITY ORIGINAL G L NUMBER __________________ DESCRIPTION __________ TH RU 09/30/19 BUDGET ---------------------------------------------------------------------------------------------- ESTIMATED REVENUES Dept 231 - Leisure Services Revenue 001-231-334.205 State DEP Grant - (FRDAP) 001-231-347.100 Tequesta Fest 001-231-347.190 Special Events - Other 001-231-347.201 Winter/Summer Camp Fees 001-231-347.205 Recreation Programs Fees 001-231-362.100 Rental - Facilities 001-231-363.271 Parks and Rec Impact Fees 001-231-365.110 Concession Sales 001-231-366.100 Contrib & Donations & Sponsor 001-231-369.000 Other Miscellaneous Revenue TOTAL REVENUE Totals for dept 231 - Leisure Services TOTAL ESTIMATED REVENUES APPROPRIATIONS Dept 231 - Leisure Services Expenditure 001-231-512.100 Regular Salaries & Wages 001-231-514.350 Overtime - Disaster 001-231-515.103 Bonus Pay Plan 001-231-515.106 Clothing & Boot Allowance 001-231-515.107 Part-time Salaries 001-231-515.108 Auto Allowance 001-231-515.109 Seasonal Salaries & Wages 001-231-515.120 Cell phone allowance 001-231-516.100 Compensated Absences 001-231-521.101 FICA Taxes 001-231-521.102 Medicare Taxes 001-231-522.102 VOT Pension Contributions 001-231-523.101 Life/Health Insurance 001-231-524.100 Workers' Comp Insurance 001-231-526.105 Employee Physical/Psycologica 001-231-531.324 Grants Acquistion & Admin 001-231-534.303 Special Events 001-231-540.300 Travel & Per Diem 001-231-541.300 Communication Services 001-231-541.301 Postage 001-231-543.300 Utility Services 001-231-545.300 Insurance 001-231-546.200 R&M - Station 11 001-231-546.302 VEHICLE REPAIR & MAINTENANCE 001-231-546.303 Building Repair & Maint 001-231-546.306 General Maintenance 001-231-546.310 Equipment Repair & Maint 001-231-546.315 Facilities - Repair & Maint 001-231-546.320 Computer system maint & suppl 001-231-549.201 Advertising & Promotion 001-231-549.300 Other Misc Chgs & Obligations 001-231-549.304 Licenses, Fees & Permits 001-231-549.332 Recreation Program Expense 001-231-549.333 Spring/Summer Camp 001-231-551.300 Office Supplies & Equipment 001-231-551.315 Concession Supplies 001-231-552.301 Gas & Oil 001-231-552.302 Small Tools and Equipment 001-231-552.305 Uniforms 2019-20 2019-20 2019-20 AMENDED ACTIVITY REMAINING BUDGET _______________________ BUDGET _ 9,585 125000 12,000 449 11, 551.00 3,871 51300 5,300 607 4,693.00 471463 40, 750 40, 750 40, 750.00 17, 384 18, 000 18, 000 18, 000.00 57491 71500 7,500 17356 6,144.00 276 276 (276.00) 452 800 800 800.00 77900 5,000 51000 57400 (400.00) 40 927462 895350 89,350 87088 815262.00 ------------------------------------------------------------------------------------------------------------------- 92,462 891350 89,350 8,088 81,262.00 ------------------------------------------------------------------------------------------------------------------- 92,462 891350 89,350 8,088 81,262.00 198,412 2121400 2121400 22, 641 189, 759. 00 37150 35150 3,150 37150 125 150 150 125 25.00 57,027 49, 350 49,350 5,816 43, 534.00 3,016 31000 37000 445 2,555.00 29,194 30, 000 30, 000 30, 000.00 17206 11200 1,200 178 15022.00 27899 31000 3,000 3,000.00 17,703 185200 18,200 17744 16,456.00 47140 41300 41300 408 3,892.00 22,278 23,100 23,100 27461 20,639.00 533427 54,100 54,100 87909 45,191.00 135538 12, 800 12, 800 12, 800.00 441 15000 1,000 15000.00 3,000 47000 4,000 4,500 (500.00) 543744 55, 000 55,000 52,000 37000.00 11000 1,000 1,000.00 10,342 12,000 12,000 1,058 10,942.00 6 18, 040 20, 000 20, 000 17479 18, 521.00 14, 664 21,100 21,100 21,100.00 17881 21000 21000 90 1,910.00 273680 30, 000 30, 000 3, 610 26, 390.00 373203 36,000 36,000 103726 25,274.00 528 17700 1, 700 1)700.00 77263 51400 5,400 17562 37838.00 77193 71200 7,200 17275 5,925.00 472 41500 3,623 3,623.00 37119 31100 37977 17350 2,627.00 36591 43, 000 43, 000 7, 688 35, 312.00 15, 621 17, 000 17, 000 17, 000.00 17170 21000 21000 2,000.00 17018 1,000 11000 1,000.00 17297 25500 21500 2500.00 17474 15500 1500 Page 44 �00 110 001-231-554.300 Books, Publ, Subs & Membershi 001-231-554.301 Personnel Training 17200 1,200 1,200.00 00 "Rem Naprovements other than Bldgs 001-231-664.600 Mach/Equipment 17099 001-231-664.601 Computer Equipment 31700 37700 37700.00 001-231-664.607 Equipment - Tech TOTAL EXPENDITURE 651,071 690,650 690,650 131,215 559,435.00 Totals for dept 231 - Leisure Services ------------------------------------------------------------------------------------------------------------------- 651 J071 690,650 690,650 131,215 559435.00 TOTAL APPROPRIATIONS ------------------------------------------------------------------------------------------------------------------- 6513071 6907650 690,650 1313215 559,435.00 NET OF REVENUES/APPROPRIATIONS - FUND 001 ------------------------------------------------------------------------------------------------------------------- (558,609) (601,300) (601,300) (123,127) 478,173.00 BEGINNING FUND BALANCE 378827111 ENDING FUND BALANCE 373237502 (601,300) (601,300) (123,127) Page 45 of 53 The Village of Teguesta General Fund #001 Summary Budgets - Oper2 Fiscal Years 2020 - 20. . FY 2020 FY 2020 FY 2021 FY 2022 Approved Projected Estimated Estimated Budget Budget Budget Budget Dept. 000 General $10,921,350 $10,921,350 $11,220,646 $11,531,914 Dept. 150 Comprehensive Planning $145,000 $145,000 $45,000 $45,000 Dept. 175 Police Department $60,400 $60,400 $23,100 $23,100 Dept. 181 Code Enforcement $10,000 $10,000 $10,000 $10,000 Dept. 192 Fire Control $1,155,150 $1,1SS,150 $1,179,240 $1,204,226 Dept. 231 Leisure Services $89,350 $89,350 $89,350 $89,350 Dept. 910-950 Other Non -Operating Subtotal:Operating $130,000 Revenues $12,511,250 $130,000 $130,000 $130,000 Dept. 100 Council $62,050 $62,050 $63,167 $64,304 Dept. 110 Manager $286,100 $286,400 $294,851 $303,553 Dept. 111 Human Resources $386,750 $378,900 $389,341 $400,079 Dept. 120 Village Clerk $370,150 $370,500 $380,681 $391,151 Dept. 130 Finance $425,400 $425,350 $437,402 $449,803 Dept. 140 Legal $180,000 $180,000 $183,240 $186,538 Dept. 150 Comprehensive Planning $163,800 $163,800 $166,748 $169,750 Dept. 160 General Government $275,700 $275,700 $280,663 $285,71S Dept. 161 I.T. $219,400 $219,750 $226,115 $232,666 Dept. 175 Police Department $3,267,880 $3,271,680 $3,485,749 $3,692,986 Dept. 181 Code Enforcement $93,750 $93,750 $96,304 $98,930 Dept. 192 Fire Control $3,935,800 $3,922,850 $4,060,172 $4,175,389 Dept. 210 Public Works $1,405,400 $1,405,600 $1,438,052 $1,471,303 Dept. 231 Leisure Services $686,950 $687,050 $704,39S $722,202 Dept. 700 Debt Service $4S6,120 $4S6,120 $428,020 $428,020 Dept. 950 Bank Charges & Credit Card Fees $6,000 $6,000 $6,108 $6,218 Dept. 950 Allocate to Fund Balance $100,000 $100,000 $0 $0 Increases Ad Valorem 4.00% Personnel 3.00% FY 2023 Operating 1.80% Estimated Budget Notes $11,855,632 $45,000 *No large projects anticipated after FY2020 $23,100 *FY2020-Includes forfeired 401a contribution(one time revenue) $10,000 $1,230,141 *Annual increases in contracts: 4%JIC & 3% PBC $89,350 $130,000 *Interest & disposition of assets $65,461 $312,513 $411,122 $401,918 $462,562 $189,896 $172,805 $290,857 $239,410 $3,797,325 *PBA: FY20214%; Police DB: FY21:50% FY22-23100% $101,630 $4,293,945 *IAFF: FY2021 5% $1,505,373 $740,483 $55,520 *SCVA Fire Equip paid off in FY2020; PS Bldng paid off in FY2022 $6,330 $0 *Projected increase in land development fees OVER/(UNDER): $190,000 $205,750 $56,328 ($45,016) $336,072 Capital $190,000 $190,000 = $0 *Does not include ambulance or Buidling Dept.'s capital (see summaries below) OVER/(UNDER): $0 $15,750 $56,328 ($45,016) $336,072 Projected Minimum Balance of Unassigned Fund Balance @ FYE: $ (759,808) $ (744,058) $ (687,730) $ (732,746) $ (396,674) Page 46 of 53 General -I; The Fund #001 Summary Fiscal Village of TeQuesta BudgetsOperatingIncreases Years 2020 - 2023 Ad Valorem 0.00% ge n e m Personnel 1.50% FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Operating 1.80% Approved Projected Estimated Estimated Estimated Estimated Assumption: 5% Decrease in state -shared revenue in initial yr w/1% decr thereafter Budget Budget Budget Budget Budget Budget Notes Dept. 000 General $10,921,350 $10,921,350 $10,749,403 $10,716,733 $10,684,390 $10,652,370 Ad Valorem Revenues $7,482,400 $7,482,400 $7,482,400 $7,482,400 $7,482,400 $7,482,400 Other General Revenues $3,438,950 $3,438,950 $3,267,003 $3,234,333 $3,201,990 $3,169,970 Dept. 150 Comprehensive Planning $145,000 $145,000 $45,000 $45,000 $45,000 $45,000 *No large projects anticipated after FY2020 Dept. 175 Police Department $60,400 $60,400 $23,100 $23,100 $23,100 $23,100 *FY2020-Includes forfeired 401a contribution(one time revenue) Dept. 181 Code Enforcement $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 Dept. 192 Fire Control $1,155,150 $1,155,150 $1,179,240 $1,204,226 $1,230,141 $1,256,056 *Annual increases in contracts: 4%JIC& 3%PBC Dept. 231 Leisure Services $89,350 $89,350 $89,350 $89,350 $89,350 $89,350 Dept. 910-950 Other Non -Operating $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 *Interest & disposition of assets Dept. 100 Council Operating Revenues $12,511,25i $62,050 $12,511,250 $62,050 $12,226,0931'$12,205,876 $63,167 $64,304 $65,461 $66,640 Dept. 110 Manager $286,100 $286,400 $290,731 $295,128 $299,592 $304,123 Personnel $274,350 $274,650 $278,770 $282,951 $287,196 $291,503 Operating $11,750 $11,750 $11,962 $12,177 $12,396 $12,619 Dept. 111 Human Resources $386,750 $378,900 $384,815 $390,823 $396,925 $403,123 Personnel $309,600 $301,750 $306,276 $310,870 $315,533 $320,266 Operating $77,150 $77,150 $78,539 $79,952 $81,392 $82,857 Dept. 120 Village Clerk $370,150 $370,500 $376,291 $382,173 $388,147 $394,216 Personnel $292,350 $292,700 $297,091 $301,547 $306,070 $310,661 Operating $77,800 $77,800 $79,200 $80,626 $82,077 $83,555 Dept. 130 Finance $425,400 $425,350 $431,907 $438,566 $445,328 $452,195 Personnel $366,350 $366,300 $371,795 $377,371 $383,032 $388,777 Operating $59,050 $59,050 $60,113 $61,195 $62,296 $63,418 Dept. 140 Legal $180,000 $180,000 $183,240 $186,538 $189,896 $193,314 Dept. ISO Comprehensive Planning $163,800 $163,800 $166,748 $169,750 $172,805 $175,916 Dept. 160 General Government $27S,700 $27S,700 $280,663 $285,715 $290,857 $296,093 Dept. 161 I.T. $219,400 $219,750 $223,103 $226,508 $229,965 $233,474 Personnel $200,400 $200,750 $203,761 $206,818 $209,920 $213,069 Operating $19,000 $19, 000 $19,342 $19,690 $20,045 $20,405 Dept. 175 Police Department $3,267,880 $3,271,680 $3,420,169 $3,582,055 $3,637,399 $3,693,601 *PBA: FY2021 4%; Police DB: FY21:50% FY22-23 100% Personnel $2,749,200 $2,753,000 $2,892,153 $3,044,535 $3,090,203 $3,136,556 Operating $518,680 $518,680 $528,016 $537,521 $547,196 $557,045 Dept. 181 Code Enforcement $93,750 $93,750 $95,221 $96,715 $98,233 $99,774 Personnel $72,200 $72,200 $73,283 $74,382 $75,498 $76,630 Operating $21,550 $21,550 $21,938 $22,333 $22,735 $23,144 Dept. 192 Fire Control $3,935,800 $3,922,850 $3,978,998 $3,990,330 $4,001,861 $4,013,596 *IAFF: FY2021 5% Personnel $3,396,550 $3,383,600 $3,430,041 $3,431,492 $3,432,964 $3,434,459 Operating $539,250 $539,250 $548,957 $558,838 $568,897 $579,137 Dept. 210 Public Works $1,405,400 $1,405,600 $1,429,113 $1,4S3,022 $1,477,335 $1,S02,OS7 Personnel $595,750 $59S,950 $604,889 $613,963 $623,172 $632,520 Operating $809,650 $809,650 $824,224 $839,060 $854,163 $869,538 Dept. 231 Leisure Services $686,950 $687,050 $698,172 $709,476 $720,965 $732,641 Personnel $414,750 $414,850 $421,073 $427,389 $433,800 $440,307 Operating $272,200 $272,200 $277,100 $282,087 $287,165 $292,334 Dept. 700 Debt Service $456,120 $456,120 $428,020 $428,020 $55,520 $55,520 *SCVA Fire Equip paid off in FY2020; PS Bldng paid off in FY2022 Dept. 950 Bank Charges & Credit Card Fees $6,000 $6,000 $6,108 $6,218 $6,330 $6,444 Dept. 950 Allocate to Fund Balance $100,000 $100,000 $0 $0 $0 $0 *Projected increase in land development fees OVER/(UNDER): $190,000 $205,750 ($230,373) ($486,932) ($264,638) ($416,851) Utility tax $0 $0 Capital ($190,000) ($190,000) $0 $0 $0 $0 *Does not include ambulance or Buidling Dept.'s capital (see summaries below) OVER/(UNDER): $0 $15,750 ($230,373) ($486,932) ($264,638) ($416,851) Projected Minimum Balance of Unassigned Fund Balance @ FYE: (759,808) $ (744,058) $ (974,431) $ (1,461,364) $ (1,726,002) $ (2,142,853) Page 47 of 53 The Villaae of Teauesta Agenda Item #6. 5 Year Capital Outlay Plan and Funding Sources Fiscal Years 2020-2024 Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Account # 2020 2021 2022 2023 2024 Totals 6 Million Over 15 Years Projected Capital Expenditures 653.600 Facility Improvments $ - $ - $ 135,000 $ 50,000 $ - $ 185,000 Tennis Court Surfacing $ - $ - $ 35,000 $ - $ - $ 35,000 Tennis Court Pickelball Courts $ - $ - $ 100,000 $ - $ - $ 100,000 Pickelball Shade Structure $ - $ - $ - $ 30,000 $ - $ 30,000 Park Landscaping/Trees $ - $ - $ - $ 20,000 $ - $ 20,000 662.600 Buildings $ - $ - $ - $ - $ - $ - Recreation Center 663.632 Architect & Engineering $ - $ - $ - $ - $ - $ - Recreation Center Year 1 Recreation Center Year 2 663.546 Roads and Bridges $ - $ 321,000 $ 255,000 $ 255,000 $ 255,000 $ 1,086,000 20 Yr. Road Replacement Plan $ - $ 255,000 $ 255,000 $ 255,000 $ 255,000 $ 1,020,000 Tequesta Bridge $ - $ 66,000 $ - $ - $ - $ 66,000 663.652 Pathways/Sidewalks $ 200,000 $ 153,000 $ 49,500 $ 50,000 $ 58,500 $ 511,000 Country Club Dr. Sidewalks/Aprons (Total Cost $433,676) $ 200,000 $ 118,000 $ - $ - $ - $ 318,000 Shay Place $ - $ 35,000 $ - $ - $ - $ 35,000 Dover & Venus $ - $ - $ 49,500 $ - $ - $ 49,500 Camelia Circle $ - $ - $ - $ 50,000 $ - $ 50,000 Saturn Ave & Azalaela Circle $ - $ - $ - $ - $ 58,500 $ 58,500 664.600 Machinery & Equipment $ 13,000 $ 66,000 $ - $ 40,000 $ 40,000 $ 159,000 Treadmill (Police & Fire) $ 3,500 $ - $ - $ - $ - $ 3,500 Police Misc. Items $ $ $ - $ $ $ Fire Air Pack $ 4,500 $ - $ - $ - $ - $ 4,500 Fire Spare Air Bottles (5) $ 5,000 $ - $ - $ - $ - $ 5,000 Cardiac Monitor $ - $ - $ - $ 40,000 $ 40,000 $ 80,000 PoliceSpec Events Veh/Traitor/Golf Cart $ - $ 20,000 $ - $ - $ - $ 20,000 Air Compressor $ - $ 46,000 $ - $ - $ - $ 46,000 664.601 Computer Equipment $ 87,200 $ 34,140 $ 32,400 $ 41,100 $ 32,400 $ 227,240 Switch Replacement (Total Cost $100,000) $ 87,200 $ - $ - $ - $ - $ 87,200 SAN Replacement (Total Cost $400,000) $ - $ - $ - $ - $ - $ - Server Room Fire Suppression System (Total Cost $22,000) $ - $ 19,140 $ - $ - $ - $ 19,140 Network Monitoring (Total Cost $20,000) $ - $ - $ 17,400 $ - $ - $ 17,400 Server Room Uninterrupted Power Solution (Total Cost $30,000) $ - $ - $ - $ 26,100 $ - $ 26,100 Hybrid Cloud Infrustructure (Total Cost $20,000) $ - $ - $ - $ - $ 17'�a $ e 48 Of '��oo Misc Hardware $ - $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 60,000 Agenda Item #6. 664.602 Vehicles $ 324,000 $ 115,500 $ 56,000 $ 109,000 $ 162,000 $ 766,500 Police $ 24,000 $ 40,000 $ 56,000 $ 79,000 $ 92,000 $ 291,000 Fire $ 300,000 $ - $ - $ - $ - $ 300,000 Fire Aerial $ $ $ $ $ $ Fire Tahoe $ - $ 42,500 $ - $ - $ - $ 42,500 Engine $ - $ - $ - $ - $ 70,000 $ 70,000 Public Works $ - $ - $ - $ 30,000 $ - $ 30,000 Sims Training Trailer $ - $ 33,000 $ - $ - $ - $ 33,000 664.603 Furn/Fixtures/Equip $ 150,000 $ 35,000 $ 85,000 $ 30,000 $ - $ 300,000 Public Safety Generator $ - $ 35,000 $ - $ - $ - $ 35,000 Public Safety Air Units $ - $ - $ 35,000 $ - $ - $ 35,000 Total Station $ - $ - $ 25,000 $ - $ - $ 25,000 Night Vision $ - $ - $ 25,000 $ - $ - $ 25,000 Tasers $ - $ - $ - $ 30,000 $ - $ 30,000 Compatiable Radios/Software $ 150,000 $ - $ - $ - $ - $ 150,000 Debt Service $ - $ 100,000 $ 350,000 $ 509,000 $ 509,000 $ 1,468,000 Recreation Center $ - $ 100,000 $ 350,000 $ 509,000 $ 509,000 $ 1,468,000 i 312.610 Local Disc. Infrastructure Surtax $ 427,100 $ 427,100 $ 427,100 $ 427,100 $ 427,100 $ 2,135,500 314.300 Utility Tax Water $ - $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ 1,000,000 Local Disc. Infrastructure Surtax Reserves (Fund 301) $ 578,970 $ - $ - $ - $ - $ 578,970 Fund Balance as of 10/01/19 (Fund 303) $ 154,313 $ - $ - $ - $ - $ 154,313 Captital Lease - Fire Equipment (Expires 09/30/20) $ - $ 28,000 $ 28,000 $ 28,000 $ 28,000 $ 112,000 Public Safety Facility Loan Payment (Expires 09/30/22) $ - $ - $ - $ 372,500 $ 372,500 $ 745,000 Captital Lease - Fire Pumper (Expires 09/30/23) $ - $ - $ - $ - $ 48,100 $ 48,100 Loan proceeds $ - $ - $ - $ - $ - $ - Over/Under By Year: $ 386,183 $ (119,540) $ (257,800) $ (6,500) $ 68,800 $ 71,143 Reserves Balances at Fiscal Year End Each Year: $ 386,183 $ 266,643 $ 8,843 $ 2,343 $ 71,143 N/A Page 49 of 53 The Villaae of Teauesta Agenda Item #6. 5 Year Capital Outlay Plan and Funding Sources Fiscal Years 2020-2024 Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Account # 2020 2021 2022 2023 2024 Totals 8 Million Over 20 Years Projected Capital Expenditures 653.600 Facility Improvments $ - $ - $ 135,000 $ 55,000 $ - $ 190,000 Tennis Court Surfacing $ - $ - $ 35,000 $ - $ - $ 35,000 Tennis Court Pickelball Courts $ - $ - $ 100,000 $ - $ - $ 100,000 Pickelball Shade Structure $ - $ - $ - $ 30,000 $ - $ 30,000 Park Landscaping/Trees $ - $ - $ - $ 25,000 $ - $ 25,000 662.600 Buildings $ - $ - $ - $ - $ - $ - Recreation Center 663.632 Architect & Engineering $ - $ - $ - $ - $ - $ - Recreation Center Year 1 Recreation Center Year 2 663.546 Roads and Bridges $ - $ 321,000 $ 255,000 $ 255,000 $ 255,000 $ 1,086,000 20 Yr. Road Replacement Plan $ - $ 255,000 $ 255,000 $ 255,000 $ 255,000 $ 1,020,000 Tequesta Bridge $ - $ 66,000 $ - $ - $ - $ 66,000 663.652 Pathways/Sidewalks $ 200,000 $ 153,000 $ 49,500 $ 50,000 $ 58,500 $ 511,000 Country Club Dr. Sidewalks/Aprons (Total Cost $433,676) $ 200,000 $ 118,000 $ - $ - $ - $ 318,000 Shay Place $ - $ 35,000 $ - $ - $ - $ 35,000 Dover & Venus $ - $ - $ 49,500 $ - $ - $ 49,500 Camelia Circle $ - $ - $ - $ 50,000 $ - $ 50,000 Saturn Ave & Azalaela Circle $ - $ - $ - $ - $ 58,500 $ 58,500 664.600 Machinery & Equipment $ 13,000 $ 66,000 $ - $ 40,000 $ 40,000 $ 159,000 Treadmill (Police & Fire) $ 3,500 $ - $ - $ - $ - $ 3,500 Police Misc. Items $ $ $ - $ $ $ Fire Air Pack $ 4,500 $ - $ - $ - $ - $ 4,500 Fire Spare Air Bottles (5) $ 5,000 $ - $ - $ - $ - $ 5,000 Cardiac Monitor $ - $ - $ - $ 40,000 $ 40,000 $ 80,000 PoliceSpec Events Veh/Traitor/Golf Cart $ - $ 20,000 $ - $ - $ - $ 20,000 Air Compressor $ - $ 46,000 $ - $ - $ - $ 46,000 664.601 Computer Equipment $ 87,200 $ 34,140 $ 32,400 $ 41,100 $ 32,400 $ 227,240 Switch Replacement (Total Cost $100,000) $ 87,200 $ - $ - $ - $ - $ 87,200 SAN Replacement (Total Cost $400,000) $ - $ - $ - $ - $ - $ - Server Room Fire Suppression System (Total Cost $22,000) $ - $ 19,140 $ - $ - $ - $ 19,140 Network Monitoring (Total Cost $20,000) $ - $ - $ 17,400 $ - $ - $ 17,400 Server Room Uninterrupted Power Solution (Total Cost $30,000) $ - $ - $ - $ 26,100 $ - $ 26,100 Hybrid Cloud Infrustructure (Total Cost $20,000) $ - $ - $ - $ - $ 17'�a $ e 50 Of '��oo Misc Hardware $ - $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 60,000 Agenda Item #6. 664.602 Vehicles $ 324,000 $ 115,500 $ 56,000 $ 109,000 $ 162,000 $ 766,500 Police $ 24,000 $ 40,000 $ 56,000 $ 79,000 $ 92,000 $ 291,000 Fire $ 300,000 $ - $ - $ - $ - $ 300,000 Fire Aerial $ $ $ $ $ $ Fire Tahoe $ - $ 42,500 $ - $ - $ - $ 42,500 Engine $ - $ - $ - $ - $ 70,000 $ 70,000 Public Works $ - $ - $ - $ 30,000 $ - $ 30,000 Sims Training Trailer $ - $ 33,000 $ - $ - $ - $ 33,000 664.603 Furn/Fixtures/Equip $ 150,000 $ 35,000 $ 85,000 $ 30,000 $ - $ 300,000 Public Safety Generator $ - $ 35,000 $ - $ - $ - $ 35,000 Public Safety Air Units $ - $ - $ 35,000 $ - $ - $ 35,000 Total Station $ - $ - $ 25,000 $ - $ - $ 25,000 Night Vision $ - $ - $ 25,000 $ - $ - $ 25,000 Tasers $ - $ - $ - $ 30,000 $ - $ 30,000 Compatiable Radios/Software $ 150,000 $ - $ - $ - $ - $ 150,000 Debt Service $ - $ 100,000 $ 376,050 $ 545,000 $ 545,000 $ 1,566,050 Recreation Center $ - $ 100,000 $ 376,050 $ 545,000 $ 545,000 $ 1,566,050 i 312.610 Local Disc. Infrastructure Surtax $ 427,100 $ 427,100 $ 427,100 $ 427,100 $ 427,100 $ 2,135,500 314.300 Utility Tax Water $ - $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ 1,000,000 Local Disc. Infrastructure Surtax Reserves (Fund 301) $ 578,970 $ - $ - $ - $ - $ 578,970 Fund Balance as of 10/01/19 (Fund 303) $ 154,313 $ - $ - $ - $ - $ 154,313 Captital Lease - Fire Equipment (Expires 09/30/20) $ - $ 28,000 $ 28,000 $ 28,000 $ 28,000 $ 112,000 Public Safety Facility Loan Payment (Expires 09/30/22) $ - $ - $ - $ 372,500 $ 372,500 $ 745,000 Captital Lease - Fire Pumper (Expires 09/30/23) $ - $ - $ - $ - $ 48,100 $ 48,100 Loan proceeds $ - $ - $ - $ - $ - $ - Over/Under By Year: $ 386,183 $ (119,540) $ (283,850) $ (47,500) $ 32,800 $ (31,907) Reserves Balances at Fiscal Year End Each Year: $ 386,183 $ 266,643 $ (17,207) $ (64,707) $ (31,907) N/A Page 51 of 53 Agenda Item #6. 2019 Final Millage Rates 1 Manalapan 16.7373 2 Town of Palm Beach 16.7774 3 Hypoluxo 17.4963 4 Highland Beach 17.509 5 Gulf Stream 17.5699 6 Cloud Lake 17.7544 7 Glenridge 17.7544 8 Boca Raton 18.3027 9 Jupiter 18.9669 10 Jupiter Inlet Colony 19.2461 11 Ocean Ridge 19.6463 12 Roya I Pa I m Beach 19.6744 13 Palm Beach Gardens 19.8463 14 Palm Beach Gardens 19.8463 15 Juno Beach 19.8621 16 Palm Beach Gardens 19.9461 17 Wellington 20.2244 18 Village of Golf 20.2545 19 Delray Beach 20.5738 20 Lantana 20.6674 21 Greenacres 20.6963 22 Loxahatchee Groves 20.7544 23 Palm Springs 21.0055 24 Tequesta 21.0251 25 Palm Beach Shores 21.0753 26 North Palm Beach 21.2093 27 South Palm Beach 21.3479 28 Delray Beach - DDA 21.5738 29 Boynton Beach 21.6093 30 Atlantis 21.9763 31 Riviera Beach 22.1613 32 West Palm Beach 22.176 33 West Palm Beach 22.176 34 Haverhill 22.2544 35 Lake Park 22.5148 36 Westlake 22.8794 37 West Palm Beach - DDA 23.176 38 Lake Worth Beach 23.7719 39 Lake Clarke Shores 24.0342 40 South Bay 24.0633 41 Mangonia Park 24.0963 42 Belle Glade 24.2963 43 Briny Breezes 24.2963 44 Pahokee 24.2963 Page 52 of 53