Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
PBSD BC Agenda 04/08/2022
PELICAN BAY SERVICES DIVISION Municipal Services Taxing and Benefit Unit NOTICE OF PUBLIC MEETING FRIDAY, APR. 812022 THE BUDGET COMMITTEE OF THE PELICAN BAY SERVICES DIVISION WILL MEET ON FRIDAY, APRIL 8 AT 9:00 AM AT THE PELICAN BAY SERVICES DIVISION, 1ST FLOOR OF THE TRUIST BANK BUILDING, SUITE 102, LOCATED AT 801 LAUREL OAK DRIVE, NAPLES, FLORIDA. AGENDA 1. Pledge of Allegiance 2. Roll call 3. Agenda approval 4. Approval of 10/11/2021 meeting minutes 5. Audience Comments 6. Financial Review a. Fund 109 b. Fund 778 c. Fund 320 d. Fund 322 e. March Financials 7. Other Business 8. Adjourn ANY PERSON WISHING TO SPEAK ON AN AGENDA ITEM WILL RECEIVE UP TO THREE (3) MINUTES PER ITEM TO ADDRESS THE BOARD. THE BOARD WILL SOLICIT PUBLIC COMMENTS ON SUBJECTS NOT ON THIS AGENDA AND ANY PERSON WISHING TO SPEAK WILL RECEIVE UP TO THREE (3) MINUTES. THE BOARD ENCOURAGES YOU TO SUBMIT YOUR COMMENTS IN WRITING IN ADVANCE OF THE MEETING. ANY PERSON WHO DECIDES TO APPEAL A DECISION OF THIS BOARD WILL NEED A RECORD OF THE PROCEEDING PERTAINING THERETO, AND THEREFORE MAY NEED TO ENSURE THAT A VERBATIM RECORD IS MADE, WHICH INCLUDES THE TESTIMONY AND EVIDENCE UPON WHICH THE APPEAL IS TO BE BASED. IF YOU ARE A PERSON WITH A DISABILITY WHO NEEDS AN ACCOMMODATION IN ORDER TO PARTICIPATE IN THIS MEETING YOU ARE ENTITLED TO THE PROVISION OF CERTAIN ASSISTANCE. PLEASE CONTACT THE PELICAN BAY SERVICES DIVISION AT (239) 252-1355. BUDGET COMMITTEE PELICAN BAY SERVICES DIVISION OCTOBER 11, 2021 The Budget Committee of the Pelican Bay Services Division met on Monday, October 11 at 1*00 p.m. at the SunTrust Bank Building, 801 Laurel Oak Drive, Suite 102, Naples, Florida. In attendance were: Budget Committee Michael Fogg, Chairman Nick Fabregas (absent) Dave Mangan Denise McLaughlin (absent) Susan O'Brien Pelican Bay Services Division Staff Karin Herrmann, Operations Analyst Neil Dorrill, Administrator Lisa Jacob, Project Manager Chad Coleman, Operations Manager Barbara Shea, Administrative Assistant Darren Duprey, Assoc. Project Mgr. (absent) Also Present Jack Cullen, PBSD Board Michael Rodburg, PBSD Board Rick Swider, PBSD Board APPROVED AGENDA (AS PRESENTED) 1. Pledge of Allegiance 2. Roll can 3. Agenda approval 4. Approval of 05/04/2021 meeting minutes 5. Audience Comments 6. FY 2021 Financial Review a. Fund 109 b. Fund 778 c. Fund 320 d. Fund 322 7. Capital Projects/Financing 8. Review FY 2022 Budget Development Process 9. Other Committee Comments 10. Adjourn ROLL CALL Mr. Fabregas and Ms. McLaughlin were absent and a quorum was established. AGENDA APPROVAL 1 Pelican Bay Services Division Budget Committee Meeting October 11, 2021 Ms. O'Brien motioned, Mr. Mangan seconded to approve the agenda as resented. The motion carried unanimously. APPROVAL OF 5/04/2021 MEETING MINUTES Ms. O'Brien motioned, Mr. Mangan seconded to approve the 5/04/2021 meeting minutes as presented. The motion carried unanimously. AUDIENCE COMMENTS None FY 2021 FINANCIAL REVIEW Mr. Fogg commented that our FY2022 PBSD budget was approved by the Board of County Commissioners (BCC) and is now locked in. Mr. Coleman reviewed funds spent, variances, and resulting carryovers to FY2022 and FY2023 for each of our four funds for FY2021. Mr. Coleman also noted that we spent 91% (or $138,000) of the $150,000 allocated to us by the County in Fund 111, for Clam Bay, in FY2021. Ms. O'Brien commented on the amount spent on lake bank remediation engineering in FY2021. Mr. Dorrill commented that this was a result of examining many options for developing a plan for the lake bank remediation of Oakmont Lake, FY2022 BUDGET REVIEW Mr. Fogg provided an overview of our FY2022 budget including carryforwards, reserves, expenses, and revenues for each fund. CAPITAL PROJECTS/FINANCING Mr. Fogg provided an overview of our capital fund balances, revenues, and expected project expenditures in FY2022. Mr. Dorrill commented that our Environmental Consultant, Dr. Dabees, will be providing an update on the County's Fall Beach Renourishment Project at this Wednesday's monthly PBSD Board meeting. He noted that the PBSD has the option to purchase additional sand for placement south of Marker 32. Mr. Dorrill noted that a potential Clam Pass dredging project (expected towards the end of 2021), would provide additional sand placement on the north side of the pass. He also expressed concern over the County's beach renourishment schedule which plans for the Pelican Bay beach to be renourished from just before the Christmas holiday through sometime in January. This is not ideal for Pelican Bay residents and their visitors. Ms. O'Brien commented that the PBSD Board already voted on the PBSD's participation in the County's Fall beach renourishment project at its July meeting. Mr. Fogg commented that the estimated cost of our FY2022 beach renourishment project is approximately $900,000. He noted that the PBSD will have to add back funds to our beach renourishment reserve in future budget years, in order to fund future beach renourishment projects. Mr. Fogg commented that the estimated cost of our FY2022 Oakmont Lake Remediation Project is approximately $2.5 million. 2 Pelican Bay Services Division Budget Committee Meeting October 11, 2021 Mr. Fogg commented that the estimated cost of our FY2022 Operations Building Replacement Project is approximately $3.5 million. Ms. Jacob commented that this project is out to bid and that bids received will be opened on Oct. 21. Mr. Fogg commented that Mr. Coleman has suggested that it would be more cost effective to bid out one project to replace all of our remaining traffic signs, than to complete the project in segments over several years. Mr. Coleman will work on options to modify the sign specifications to reduce the cost of the signs for this project. Additional funds will be added to this project next year, and the project will be completed when the project has been fully funded. Mr. Fogg commented that if the Landscape Median Project is approved at Wednesday's board meeting, a budget amendment will be required. The total project cost of $154,223.30 will be funded by transferring $98,194.56 from the Field Operations Center Improvements Project in Fund 322 and $56,028.74 from the Sign Project in Fund 322 to the Landscape Median Project. Ms. O'Brien suggested that the replacement of our traffic signs is more important to our residents than the landscape median project. She suggested that our staff is utilized for the replacement of plants on our medians. Mr. Doi -rill commented that in light of all the pluses and minuses related to the Phase 1 Sidewalk Project, the project is looking to come in on budget. He commented that permits are in hand for our Phase 2 project, which is currently "in -process" in the County's Procurement Dept, Mr. Coleman commented that ABB's best estimate for our Phase 2 project is $6.8 million. He noted that this is the only PBSD project which will require financing in FY2022. Mr. Fogg commented that Fund 322 will potentially have an additional $1 million available that had not been previously expected. Mr. Coleman commented that we will need to draw on our credit line, after bids are received, to open the purchase order for our Phase 2 project. REVIEW FY 2022 BUDGET DEVELOPMENT PROCESS Mr. Fogg provided suggestions on now to improve Lite FY2022 budget development process. He suggested that in order to meet the County's early May budget submission deadline, the PBSD Budget Committee needs to start work in January to set the framework for the next budget cycle, determine any financing requirements, and determine a target ERU assessment. Mr. Fogg suggested that the committee works with the County's GovMax summary forms during the FY2022 budget process. Ms. O'Brien suggested that it would be helpful if these forms included data from the past 5 or 10 years for review and analysis by the committee. Mr. Dorrill noted that the BCC typically approves County budget policy for the following year at its first board meeting in March. OTHER COMMITTEE COMMENTS Ms. O'Brien suggested that the Water Management Committee needs to provide a game plan and guidelines for all future lake remediation projects. This would assist in the PBSD budgeting process. The meeting was adjourned at 2:05 3 Pelican Bay Services Division Budget Committee Meeting October 11, 2021 Michael Fogg, Chairman Minutes approved �] as presented OR �] as amended ON ( ]date 4 Agenda item #6 Page 1 of 4 22/23 Preliminary Budget" Commentary Operations expenses increase U w/o ($320,000) over 21/22 budget driven by significant increase in compensation for County employees effective 01/01/2022 and a similar increase in the general inflation rate. 2. Last year a large operations c/fwd surplus allowed us to significantly increase the capital budget to fund major projects and reduce borrowing. The c/fwd operations surplus this year is $515,000 less. 3. To achieve an overall assessment increase of around 6.9%this year the capital budget has to be reduced by $360,000. The budget still covers identified project plan needs for next year but does not allow for capital capacity build. 4. Last year budgeted operating expenses increased by approximately 3%. Adding 2-3% for capital capacity build got us to an overall budget (assessment) increase of 4.9%. This year with underlying inflation at 6.5% adding 2-3% for capital capacity build would require an overall assessment increase of 8.5-9.5 % vs the 6.9% in the preliminary 22/23 budget. 5. Making things more complicated is a further unannounced but expected 22/23 year increase in County compensation similar to that implemented earlier this year. 6. Approximately $750,000 equates to $100 pet ERU. Agenda item #6 Page 2 of 4 2022/23 Assessment Summary 3/31/22 IV t' '' •• 'gross 0000s Net 000's 22/23 ERU $ 21/22 ERU $ Increase I � Operations1QQ;; 1 4,838 4,597 I 631 .:.-::....,. L Clamk'assJ, 2A.. 15n..II 21 � �........... ....................................156V......1..L.......0._ ..... .. _._........I.-........ . 1,508 1,490 205 1 -.. : — -- : . ........I ............... .-2t.......A.._.. I.... ..... .............. ........ . ,.r.::..::: ,....: s 857 799 7.3% �8237i .......................j ....6,504.................. ......j .........I. I. _ ..I............. flpaxaxl0ns.77Q;! ; 300 41 .. tr8p ta1.... 1 ,, 77 351 46 • i . _81. ... 1 ... 864 851... 9.1. 864.1 315% 1. 7,248 6,688 946 885 8,9°i6 .ttI _.._ ....,..... .. . IV .::........ ;. — --"1 ............................ ... ... ........ .... _ .... ti- F-re-T:: ;-•�-.-r:4,__ ......................I I t I . ........ ......... ..... ..._............ till III ... . ..................I It._....-.__..._..._ I I I .. I. I.. I.. I.. I.......... IV IV GI : t% Agenda item #6 Page 3 of 4 p�LICAN BAIT ANNUAL ASSESSMEN' NON AD YEAR 109 WM 109 BA 32o CB 322 CAP VALOREM PROPOSED 2022 123.91 .394.57 31,14 249.99 799.61 2021 122,16 429.44 24.55 183.99 760A4 2020 186.11 446.59 25.92 102,89 761.51 2019 144.06 404.33 29.56 438.77 $1,016.72 2018 132.73 401.52 21.08 97.67 $653.00 2017 138.72 379.23 16.66 56.21 $590.82 2016 125.19 314.67 17.53 5262 $510.01 2015 105.8 261,21 15.58 44.18 $426.77 2014 97A9 255.65 17.49 27.51 $398.14 2013 91.23 246.62 17,64 42.64 $398,13 ***2012 $398A3 ***Increase In assessment to begin accruing funds for CIP; 2015 to Include beach renot 2011 $ 370.63 2010 $ 370.64 2009 $ 370.46 2008 $ 382.30 2007 $ 42298 **Zero Millage Rate for 2007 and 2008 due to using excess security funding. 2006* $ 151.40 *2006 assessment rate was low due to using most of the reserves because of possible z 2005 $ 475.43 2004 $ 325.28 2003 $ 29113 2002 $ 293.54 2001 $ 284.15 2000 $ 280,23 Millage Rate Includes Security for years 2000 through 2006. riE�iP I r7Ti�1��T�]:�L�➢�9 MILEAGE ERU'S RATE 7658.9 0.0857 7658.9 0,0857 7658.9 0.0857 7615,29 0.0857 7615.29 0.0857 7615629 0.0857 7615.29 0.0857 7614,29 0.0857 7615429 0.0857 7617.29 0*0857 7618.29 0.0857 arishment 7618.29 0.0531 7617,29 0.0531 7616.29 0,0532 7618.29 0** 7619.29 0** annexation, 7629.29 0.1486* 7644.28 0.1399 7763.19 0.1544 7764.11 0.2013 7811.00 0.2183 7770.35 0.2050 7734.82 0.2303 Agenda item #6 Page 4 of 4 pumuiq RPnrILS, i,:4Nl nIIVr(I•: i)I¢ll l'MInel i,e RPM, 611WIP aanry ulivl;; o-,:n,n.I ,l,a' ., All u,yny; ,,,:,I :I:,nIV .s 011.411,1111 0111111 411 Anvllsla�n.l ruon+,l 1"112..1 WIN"ll INlupin\p w mnr, nu,I:n:I ant. ,ogm,,l ay:w annn:a nlul nR+l=n,,.Y l Iu:Ynmo,,.l pt�.I;;O+lYnin+d llni,:>.I rots') IYnl:poapI A rhlot nulr,:plv,ad n,:<:Y „ II:ocY N;I Wd o9:V'lZ/419 peVr ooyeA ygAy - leu•aa op66of-uosuyot- (peeiun 688) u Agenda item #6a Page 1 of 8 109 2022/23 Budget Summary 2021 21Me Budget l 21/22 Fcst. 22/23 Budget - ........ ! I ..5. `.... _.. i... ... .t.. ._ !.... Operating It FI Note 1 4,395 4 4,767 843 5,106 Miscellaneous Rev ..:.. 168 93 93 ................. .. 91 4,227 4,694 .. ...... _.... 4,750 I 5,015 i_ ..,: ., .. ...... . ._.i_... .1. ... .;, C/Fwd 2 757 I 2,326 2,756 1,811 ..;. Less Reserves 1,556 10401 11401 11401 i Avail C/Fwd 1,201 925 11355 418 ...... Net 3,026 3,769 �.16 j 3.395 41597 Revenue, OFF,41075 3,769 L 3,813 4,597 .. Surplus 1049 0 I 418 0 ,;, Or i Note1 .t: _ IF 122B/21A 392 8.99/0 r 123B/22B .........IF 319 6.7% _. 236/21A 711 d 161% ,. �I Office of the County Manager Pelican Bay Services Division Pelican Bay Community Beautification (109) Forecast FY 2022: Agenda item #6a Page 2 of 8 Personal Services are forecasted to be higher due to the Evergreen compensation study recommendations and subsequent compensation increase In January, Operation Expenses have increased due to Inflation and higher costs of goads end services. Current FY 2023; Personal Services are higher due to the Evergreen compensation study recommendations and subsequent compensation Increases, Operating Expenses are higher due to Inflation increases In the costs of goods and services Capital outlay for FY23 Includes the replacement of, two utility vehicles, three 52" riding mowers, and two stand -on mowers. This Division is not part of the motor pool capital program and equipment is budgeted on a cash and carry basis based upon Fleet Management Division's recommendations of replacement, Revenues: Special assessment revenue funding for community beauilflcation Increased from $394.57 to $447.42 per equivalent residential unit (ERU), which will raise $3,323,900, Miscellaneous revenues include office space sublease revenue from the Pelican Bay Foundation, Fiscal Year 2023 8 Ofnce of the County Manager Agenda item #6a Page 3 of 8 Office of the County Manager Pelican Bay Services Division Pelican Bay Water Management (109) Forecast FY 2022: Personal Services has Increased after the Evergreen compensation study. Operating expenses have Increased due to higher costs of goods and services. Current FY 2023: The FY23 operating budget Is higher than FY22 primarily due to personal Increases, fleet charges and flood control. Other operating costs have Increased In FY23 as a result of inflation. A lower carry forward and Increased costs In personal services has created the need for an Increase In assessment. Revenues; Special assessment revenue funding water management activities Increased from $123.91 to $165.17 per equivalent residential unit (ERU) in FY 2023 which will raise $1,361,100, Miscellaneous revenues include sublease revenue from the Pelican Bay Foundation, Fiscal Year 2023 4 O(fice of the County Manager Agenda item #6a Page 4 of 8 Fund Detail Proforma Summary Grouped By Account Minor Collier County Government Fiscal Year 2023 FY 2021 FY 2022 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 Adopted Actual Adopted Amended Forecast Current Expanded Budget %Change 109 Pelican Bay Beautification MSTBU Expenditures 500 Personal Services 119781941 24049,000 21049,000 21093,400 2,241,600 0 24241,600 9.40 BOO Operating Expense 21029,435 2,163,900 21179,361 2,197,000 21377,600 0 21377,500 9,87 610 Indirect Cost Relmhurs 121,400 136,100 136,100 136,100 1500000 0 150,000 10,21 700 Capital Outlay 155,858 177,500 1773500 1720000 98,600 0 982500 -44.61 856f Trans to Property Appraiser 5,067 850000 851000 85,000 802000 0 800000 -5.88 855h Trans to Tax Collector 81,504 130,700 130,700 130,700 1001000 0 100,000 -23.49 912a Trans to 301 Cc Wide Cap Fd 0 8,700 8,700 8,700 10,000 0 10,000 14.94 916h Trans to 408 Water/Sewer Fd 23,100 21$000 21,000 21,000 21,o0D 0 21,000 0,00 920f Trans to 506 IT Capital 0 0 0 0 27,600 0 27,800 N/A 991 Reserve for Contingencies 0 16%000 169,000 0 160,000 0 160,000 0,63 993 Reserve for Capital 0 111,200 111,200 0 110,000 0 110,000 -1A8 995a Reserve for Disaster Relief 0 700,000 7009000 0 700,000 0 7002000 0,00 998 Reserve for Cash Flow 0 475,000 475,000 0 475,000 0 476,000 0.00 999 Reserve for Attrition 0 43,900 43,900 0 -430900 0 43,900 0,00 Revenues 325a Special Assessments 41075,210 31971,000 3,971,000 3/8131100 41847,400 0 4,B471400 22,07 360 Miscellaneous Revenues 1029500 35,800 36,800 35,800 36,800 0 36,800 2.79 3611nterest/Mlsc 17,786 23,100 23,100 16,000 20,000 0 200000 -13,42 392d Trans fan Property Appraiser 73,018 0 0 0 0 0 0 N/A 392h Trans frm Tax Collector 32,667 0 0 0 0 0 0 N/A 413u Trans fm 320 Clam Bay Cap Fd 34,100 340100 34,100 34,100 34,100 0 34,100 0.00 499u Carry Forward 21816,900 2,3111000 213269461 2,766,900 1,8111000 0 118113000 -21,64 499z Less 6% Required By Law 0 -2011800 -201,800 0 -242,000 0 -242,000 19.92 Fund Total Expenditure: 4$95,305 61173,200 61188,661 4,843,900 6,507,300 0 61507,300 SAII Fund Total Revenue: 7/1624179 6117%200 61188,661 6,654,900 60507,300 0 6,5071300 5.41 Fund Balance: 21756,874 0 0 118112000 0 0 0 N/A GovMex 1 4/4/2022 Agenda item #6a Page 5 of 8 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2023 FY 2021 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 FY 2023 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 109 Pelican Bay Beautification MSTBU 500 Personal Services Exoendltures 182601-109 612100 Regular Salaries 731 0 0 0 0 0 0 N/A 182601-109 521100 Social Security 62 0 0 0 0 0 0 N/A `182601-109 622100 Retirement Regular 73 0 0 0 0 0 0 N/A 182602-109 M2100 Regular Salaries 229,696 235,811 235,811 216,600 264,351 0 264,351 12,10 182602.109 512600 Auto Use Benefit 152 0 0 0 0 0 0 N/A 182602409 612600 ER 457 Deferred 1,297 11530 11630 2,900 1,530 0 1,630 0.00 182602A 09 514l 00 Overtime 20,248 204200 20,200 17,600 21,000 0 21,000 3,96 182602-109 615000 Vacation Sell Back 0 11552 1,552 11600 635 0 635 -69,09 182602-109 519100 Reserve For Salary 0 51217 60217 0 91 0 91 -98.26 182602409 521100 Social Security 17,835 18,669 18,669 16,000 20,389 0 20,389 9,21 182602-109 522100 Retirement Regular 25,691 27,088 27,08B 22,400 32,221 0 320221 18.95 182602A09 623150 Health Insurance 50,566 50,566 60,666 50,600 50,666 0 601666 0,00 %2602-109 523152 Dental Insurance 1,930 12930 11930 12900 2,026 0 2,026 4,97 182602-109 523163 Short Term 386 386 386 400 482 0 482 24,87 182602-109 523154 Long Term 772 772 772 600 868 0 868 12,44 182602-109 623160 Life Insurance 643 679 679 700 741 0 741 9,13 182602-109 524100 Workers 61100 5,500 52500 51600 61600 0 6,600 20,00 182602.109 628200 Allowance Vehicle -162 0 0 0 0 0 0 N/A 182900-109 512100 Regular Selades 662 0 0 0 0 0 0 N/A 182900A09 621100 Social Security 46 0 0 0 0 0 0 N/A 182900-109 522100 Retirement Regular 66 0 0 0 0 0 0 N/A 1182901-109 512100 Regular Salaries 873,097 894,887 894,887 943,400 1,0360106 0 11036,106 15,78 182901-109 512500 Auto Use Benefit 478 0 0 0 0 0 0 N/A 182901-109 612000 ER 467 Deferred 7,313 71840 79840 11,600 70440 0 71440 -5.10 182901-109 514100 Overtime 19%206 207,600 2079500 215,000 215,000 0 215,000 3,61 182001-109 615000 Vacation Sell Back 0 21652 2,552 2,500 21491 0 2,491 -2,39 182901-109 518100 Termination Pay 143 0 0 0 0 0 0 N/A 182901-109 619100 Reserve For Salary 0 26,958 26,958 0 35 0 36 -99,87 182901-109 521100 Social Security 76,668 71,310 71,310 86,000 80,018 0 80,018 12,21 182901-109 522100 Retirement Regular 113,972 105,762 105,752 137,800 133,028 0 133,028 25,79 182901-109 523150 Health Insurance 289,248 289,248 289,248 28%200 289,248 0 289,248 M00 182901-109 523162 Dental Insurance 11,040 11,040 11,040 11,Oo0 11,693 0 11,693 6.01 18290M09 623153 Short Term 21208 21208 2,208 21200 21761 0 2,761 25,05 182901.109 523154 Long Term 4,416 41416 4,416 41400 4,969 0 41969 12,52 182901-109 623160 Life Insurance 2,536 21589 2,589 21600 2,911 0 2,911 12,44 182901-109 524100 Workers 48,300 52,800 529800 520800 54,500 0 64,600 3,22 182901-109 528200 Allowance Vehicle 478 0 0 0 0 0 0 N/A Expenditures 11978,941 21049,000 2,049,000 2,093,400 2,241,600 0 2,241,600 9.4o 600 Operating Expense Expenditures 182602-109 631400 Engineering Fees 27,939 30,000 30,000 17,000 20,000 0 20,000 -33.33 182602409 634207 IT Capital Allocation 22,000 41800 41800 41800 0 0 0 -100.00 182602-109 634210 Info Tech 6,300 8,700 8,700 %700 8,900 0 80900 2.30 182602-109 634211 IT Billing Hours 400 600 600 600 800 0 800 60,00 182602-109 634261 Flood Control 215,254 200,000 200,000 260,000 245,000 0 246,000 22,60 182602-109 634805 Emergency Malnl 496 0 0 600 Boo 0 600 N/A 182602-109 634980 Inlerdept Payment 12,125 0 0 0 0 0 0 N/A 182602-109 634999 Other Contractual 52,644 64,000 6%476 44,000 77,000 0 77,000 20,31 182602-109 639967 Temporary Labor 71,104 87,000 87,OOD 77,000 90,000 0 90,000 3.46 182602A09 641160 Telephone Beepers 360 400 400 360 400 0 400 0.00 182602-109 641400 Telephone Direct 999 1,200 11200 350 0 0 0 -100,00 182602-109 641700 Cellular Telephone 31900 4,200 4,200 31000 3,000 0 31000 -28,67 182602.109 641950 Postage Freight 31214 300 300 100 200 0 200 -33,33 182602-109 643300 Trash and Garbage 10,997 14,000 141000 14,000 140000 0 14,000 0.00 182802A09 644100 Rent Buildings 13,693 181000 18,000 44,000 45,000 0 45,000 150.00 182602-109 644600 Rent Equipment 1,122 11500 1,500 2,000 11800 0 1,800 20,00 182602-109 64MOOInsurance General 50000 6,100 5,100 51100 4,600 0 4,500 -11,76 182602-109 645260 Auto Insurance 10400 11400 1,400 1,400 1,400 0 1,400 0,00 182602-109 646180 Building R And M 255 0 0 0 0 0 0 NIA 182602-109 646311 Sprinkler System 0 0 0 90 0 0 0 N/A 1B2602-109 646319 Tree Trimming 46,000 61,000 55,400 64,300 66,000 0 65,000 27,45 182602-109 646320 Landscape 51902 51000 51000 5,000 51000 0 61000 0.00 182602-109 646430 Fleet Malnt ISF 31,128 81600 81600 81600 15,600 0 15,600 81.40 182602-109 646440 Fleet Malnt ISF 61425 2,600 2,500 2,600 61700 0 6,700 168,00 182602-109 646445 Fleet Non Malnt 783 11200 1,200 1,9go 2,600 0 2,600 108,33 GovMax 1 4/4/2022 Agenda item #6a Page 6 of 8 Account Minor Fund Line Item Detail Proforma Collier Couniv Government Fiscal Year 2023 FY 2021 Actual FY 2022 Adopted FY 2022 Amended FY 2023 Forecast FY 2023 Current FY 2023 Expanded FY 2023 Budget Adopted % Change 109 Pelican Bay Beautification MSTBU 600 Operating Expense Expenditures 182602-109 646970 Other Equip Repair 10,542 21600 21500 30000 39000 0 3,000 20.00 182602-109 647110 Printing Binding 21416 300 300 0 300 0 300 0.00 182602-109 849000 Sales Tax Expense 1 0 0 100 0 0 0 N/A 182602-109 649030 Clerks Recording 0 100 100 0 100 0 100 0.00 182602-109 649100 Legal Advertising 11588 21000 2,000 2,000 21000 0 2,000 0.00 182602-109 651110 Oice Supplies 61695 1,600 11500 11500 12600 0 1,600 0400 182602A09 651930 Minor Office 299 1,000 1,000 0 0 0 0 -100,00 182602409 651950 Minor Data 180 0 0 0 0 0 0 N/A 182602409 652130 Clothing And 609 21000 20000 11000 2,000 0 21000 0,00 182602409 652140 Personal Safely 21131 11200 11200 3,000 31600 0 %500 191,67 182602A09 652310 Fertilizer Herbicides 43,650 - 1000000 100,000 650000 70,000 0 70,000 -30,00 182602A09 652490 Fuel and Lubricants 20044 21400 21400 11400 31500 0 31500 46,83 182602-109 652990 Other Operating 110339 81000 81000 12,000 13,700 0 13,700 71,25 182602A09 654360 Other Training Ed 3,814 20000 2,000 20000 4,000 0 4,000 100.00 182901-109 631400 Engineering Fees 16,162 10,000 100000 0 100000 0 10,000 0,00 182901409 634207IT Capital Allocation 41400 17,300 17,300 17,300 0 0 0 -100.00 182901.109 634210 Info Tech 36,700 44,600 44,600 44,600 45,300 0 45,300 1,57 182901.109 634263 Flood Control 127,810 88,000 88,000 100,100 100,o00 0 100,000 13.64 182901-109 634330 Towed Vehicles 285 0 0 0 0 0 0 N/A 182901-109 634805 Emergency Malnt 2,525 21600 2,500 0 21500 0 2,600 0.00 182901-109 6349801nterdept Payment 869 0 0 0 0 0 0 N/A 182901-109 634990 Landscape 11210 20600 2,600 2,600 31000 0 30000 15,38 182901-109 634999 Other Contractual 216,021 126,900 132,485 201,000 160,000 0 160,000 26,08 182901-109 639964 Storage Contractor 824 500 500 200 300 0 300 40,00 182901-109 639966 Pest Control 260 600 500 0 600 0 500 0.00 182901-109 639967 Temporary Labor 286,221 347,000 347,000 325*000 360,000 0 350,000 0,86 182901-109 640300 Out Of County 0 600 600 600 500 0 500 M00 182901-109 640410 Motor Pool Rental 11050 0 0 0 0 0 0 N/A 182901-109 641160 Telephone Beepers 360 400 400 400 400 0 400 0,00 182901-109 641400 Telephone Direct 998 1,200 11200 700 400 0 400 -66,67 182901-109 641700 Cellular Telephone 91101 9,600 91600 8,200 91600 0 91500 -1,04 182901-109 641950 Postage Freight 85 500 600 100 600 0 600 0.00 182901-109 643100 Electricity 2,337 2,500 2,500 21500 2,600 0 2$00 0.00 182901.109 643300 Trash and Garbage 31138 4,000 41000 4,000 4,000 0 49000 0.00 182901-109 644100 Rent Buildings 13,794 42,000 429000 440000 46,000 0 45,000 7.14 182901-109 644600 Rent Equipment 51171 21000 21000 31000 4,300 0 40300 115400 18290iA09 645100 Insurance General 13,200 13,500 13,600 132600 12,900 0 12,900 444 182901-109 645260 Auto Insurance 12,500 10,700 100700 10,700 10,700 0 10,700 0.00 182901-109 646180 Building R And M 0 21600 2,500 0 2,500 0 21500 0,00 182901A09 646311 Sprinkler System 61,291 62,000 52,000 55,000 58,000 0 68,000 11,64 182901A09 646314 Maintenance 85,461 90,000 90,000 1166000 126,400 0 126,400 40,44 182901-109 646319 Tree Trimming 1860631 152,900 152,900 176,000 2000000 0 200,000 30.80 182901-109 646320 Landscape 57,417 160,000 160,000 1000000 1300000 0 130,000 A8.76 182901-109 646381 Road And Blkepath 8,788 25,000 25,000 25,000 25,000 0 250000 0.00 182901.109 646430 Fleet Melnl ISF 51,492 41,300 41,300 41,300 61,600 0 61,600 49,16 182901.109 646440 Fleet Melnt ISF 21,977 16,500 16,500 16,600 2%400 0 29,400 78,18 182901-109 646445 Fleet Non Malnt 6,885 1,700 1,700 11700 61300 0 6,300 270,69 182901-109 646970 Other Equip Repair 5,636 60600 6,600 6,600 8,000 0 8,000 21,21 182901-109 647110 Printing Binding 51284 11000 12000 200 500 0 Soo -50,00 102901A09 649010 Licenses And 3,437 21500 2,500 2,500 2,600 0 2,600 0.00 182901-109 649030 Clerks Recording 11191 81400 8,400 8,400 8,400 0 8,400 0,00 182901-109 649100 Legal Advertising 11027 31000 3,000 31000 3,000 0 %000 0.00 182901-109 661110 Office Supplies 51056 21000 29000 21000 2,000 0 20000 0.00 182901-109 651930 Minor Office 466 16,000 150000 50000 0 0 0 400.00 182901-109 651950 Minor Data 26 500 500 0 600 0 600 0.00 182901-109 662110 Clothing And 0 600 600 500 600 0 600 20,00 182901-109 652130 Clothing And 18,180 20,000 200000 20,000 20,000 0 20,000 0400 182901-109 652140 Personal Safely 5,349 40000 40000 7,000 71000 0 7,000 75,00 182901A09 652310 Fertilizer Herbicides 77,831 120,000 1200000 1o5,000 110,000 0 11o,000 -8.33 182901A09 652490 Fuel and Lubricants 32,894 40,000 40,000 30,000 55,700 0 55,700 39,25 182901A09 662910 Minor Operating 7,899 151000 151000 15,000 15,000 0 15,000 0400 182901-109 652920 Computer Software 0 800 800 600 800 0 800 0.00 182901409 662990 Other Operating 18,972 15,000 15,000 18,000 200000 0 20,000 33,33 182901-109 652999 Painting Supplies ' 0 600 600 0 Soo 0 500 0,00 182901A09 653710 Traffic Signs 697 61000 61000 61000 80000 0 80000 33,33 OovMex 2 4/4/2022 Agenda item #Be Page 7 of 8 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2023 FY 2021 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 FY 2023 Adopted Actual Adopted Amended Forecast Current Expanded Budget %Change 109 Pelican Bay Beautification MSTBU 600 Operating Expense Expenditures 182901-109 654360 Other Training Ed 11389 21000 2,000 21000 21500 0 2,500 26,00 Expenditures 21029,435 2,1633900 2,1791361 2,197,000 21377,500 0 23377,600 9,87 610 Indirect Cost Reimburs Expenditures 182602-109 634970 Indirect Cost 121,400 136,100 136,100 136,100 1501000 0 160,000 10,21 Expenditures 121,400 136,100 136,100 136,100 150,000 0 150,000 10,21 700 Capital Outlay Exnenditures 182602-109 764900 Data Processing 0 600 500 0 600 0 500 0.00 182602-109 764990 Other Machinery 0 0 0 0 10,000 0 10,000 N/A 182901-109 764110 Autos And Trucks 94,875 860000 85,000 81,000 0 0 0 -100,00 182901.109 764900 Data Processing 21,505 11000 10000 0 10000 0 11000 0.00 182901-109 764990 Other Machinery 39,476 91,000 91,000 91,000 87,000 0 87,000 -4.40 Expenditures 1553858 177,600 177,500 172,000 98,500 0 981500 -44,61 855f Trans to Property ppraiser Expenditures 959010-109 930600 Budget Transfers 5,067 85,000 85,000 85,000 80,000 0 800000 -5.88 Expenditures 5,067 85,000 85,000 850000 80300o 0 80,ow -5.88 855h Trans to Tax Collector Expenditures 959010-109 930700 Budget Transfers 813504 130,700 130,700 130,700 100,000 0 100,000 -23.49 Expenditures 81,504 130,700 130,700 130,700 100,000 0 1000000 -23.49 912a Trans to 301 Co Wide Cap Fd Expenditures 929010-109 913010 Transfer to 301 0 8,700 IIJ00 81700 10,000 0 101000 14.94 Expenditures 0 %700 81700 8,700 10,000 0 10,090 14,94 916h Trans to 408 Water/Sewer Fd Expenditures 929010-109 914080 Transfer to 408 23,100 21,000 21,000 21,000 21,000 0 217000 0,00 Expenditures 23,100 21,000 21,000 21,000 21,000 0 21,000 0.00 920f Trans to 506 IT Capital Expenditures 929010-109 915060 Transfer to 506 0 0 0 0 27,600 0 27,600 N/A Expenditures 0 0 0 0 27,600 0 27,600 NIA 991 Reserve for Contingencies Expenditures 919010A09 991000 Reserve For 0 1591000 169,000 0 160,000 0 160,000 0.63 Expenditures 0 1591000 1590000 0 160,000 0 160,000 0.63 993 Reserve for Capital Expenditures 919010-109 993000 Reserve For 0 111,200 111,200 0 110,000 0 1102000 -1.08 Expenditures 0 111,200 111,200 0 110,000 0 1100000 -1.08 995e Reserve for Disaster Relief Expenditures 919010-109 991700 Reserve For 0 700,000 700,000 0 700,000 0 700,000 0.00 Expenditures 0 7003000 700,000 0 700,000 0 700,000 0.00 998 Reserve for Cash Flow Expenditures 919010-109 998000 Reserve For Cash 0 475,000 475,000 0 475,000 0 4754000 0,00 Expenditures 0 475,000 475,000 0 475,000 0 475,000 0,00 999 Reserve for Attrition Expenditures 919010-109 992100 Reserve Far 0 A3,900 -43,900 0 -43,900 0 -43,900 0.00 Expenditures 0 -43,900 143,900 0 -43,900 0 43,900 0.00 325a Special Assessments Revenues 182601-109 325100Speclal 905,104 0 0 0 0 0 0 NIA 182602-109 325100Special 0 949,000 949,000 9123000 11414,100 0 1,4140100 49,01 182900-109 325100 Special 3,170,106 0 0 0 0 0 0 N/A 182901-109 325100 Speclal 0 310223000 31022,000 21901,100 31433,300 0 33433,300 13,61 Revenues 410750210 31971,000 3,9711000 30813,100 4,847,400 0 4,8471400 22.07 360 Miscellaneous Revenues Revenues 182602-109 362192 Lease Facilities 0 17,900 17,900 17,900 18,400 0 183400 2,79 182602-109 364410 Surplus Furniture 34,000 0 0 0 0 0 0 N/A 182901-109 362192 Lease Facilities 0 170900 17,900 17,900 18,400 0 18,400 2,79 GovMax 3 414/2022 Agenda item #6a Page 8 of 8 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2023 FY 2021 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 FY 2023 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 109 Pelican Bay Beautification MSTBu 360 Miscellaneous Revenues Revenues 182901-109 364410 Surplus Furniture 63,650 0 0 0 0 0 0 NIA 182901-109 365100 Scrap Sales 43150 0 0 0 0 0 0 N/A 182901.109 369130 Ins Cc Refunds 701 0 0 0 0 0 0 N/A Revenues 102,500 35,800 354800 35,800 36,800 0 36,800 2.79 3611nterest/Misc Revenues 182601-109 361320 Interest Tax 96 0 0 0 0 0 0 N/A 182900.109 351320 Interest Tax 336 0 0 0 0 0 0 N/A 989010-109 361170 Interest SBA 33588 0 0 0 0 0 0 N/A 989010A09 361180 Investment Interest 13,764 23,100 23,100 16,000 20,000 0 20,000 •13.42 Revenues 17,785 23,100 23,100 151000 20,000 0 20,000 •13,42 392d Trans firm Properly Appraiser Revenues 959010-109 486600 Transfer From 73,018 0 0 0 0 0 0 NIA Revenues 73,018 0 0 0 0 0 0 NIA 392h Trans frm Tax Collector Revenues 969010-109 486700 Transfer From Tax 32,667 0 0 0 0 0 0 N/A Revenues 32,667 0 0 0 0 0 0� 413u Trans fm 320 Clam Bay Cap Fd Revenues 929010-109 481320 Transfer From 320 34,100 34,10D 34,100 34,100 349100 0 34,100 0.00 Revenues 34,100 34,100 34,100 341100 34,100 0 34,100 0.00 499u Carry Forward Revenues 919010-109 489200 Carryfomard 218160900 21311,000 2,3119000 2,7560900 11811,000 0 10811,000 -21.64 919010-109 489201 Carry Fonvard Of 0 0 15,461 0 0 0 0 NIA Revenues 2,816.900 2,311,000 2,328,461 2,766,900 7,811,000 0 1,811,000 -21.64 499z Less 5% Required By Law Revenues 919010-109 489900 Less 5% Required 0 -201,800 -201,800 0 -2421000 0 -242,000 19,92 Revenues 0 -201,800 -201,800 0 -2421000 0 -242,000 19,92 Fund Total Expenditure: 4,395,305 61173,200 81188,681 4,843,900 6,507,300 0 81507,300 5.41 Fund Total Revenue: 7,152,179 6,173,200 6,188,881 6,654,900 8,607,300 0 6,507,300 5,41 Fund Balance: 217563874 0 0 1,8111000 0 0 0 N/A GovMax 4 4/4I2022 Agenda item #6b Page 1 of 5 778 2022123 Budget Summary 21 Actual 2122 Budget 22/23 Budget ... _. $ 000 ............. $ 000 ......._........ .. $ 000 i ! 263 330 376 I..... LL 0 156 0:. ................. !. L... 376 I. 2,061 440 2,314 926 i ..351 i 127 L.. 14 22..._ 22 �...... 21300 .. 904 i.......... 705 1 �_.__ ;.... ........... .... .. .. 2,096 i 365 143. 140 j 88 88 11956 277 55 i.. 344 627 i 650 627 650 _....630 ........ ...... ..._ i 286. L.... ° ! ........ - - ...... _... I I I ! 1 Agenda item #61b Page 2 of 5 Office of Lite County Manager Pelican Bay Services Division Pelican Bay Street Lighting (778) Forecast FY 2022: Personal Services are forecasted to be higher due to the Evergreen compensation study recommendations and subsequent compensation Increase in January. Operating Expenses are forecasted to be In line with the FY2022 Budget due to lower than anticlpated needs of electrical contractors, light bulbs and ballast expenditures. Current FY 2023; Personal Services Increase In accordance with the Evergreen compensation study. Operating Expenses are budgeted higher than FY22 due to Increased costs of goods and services, Excess funds are transferred to capital project fund 322 for the new Pelican Bay Operations Building, The street lights have LED bulbs which require less frequent maintenance and replacement. This fund had a millage rate of .0857 In FY 2022 and the rate remains unchanged for FY 2023 in accordance with the advisory committee recommendation. Estimated taxable value for this district totals $7,712,078,048 which represents a 0.71%Increase over last year. Property taxes total $684,000. The District's actual cash and cash equivalents (carry -forward) year over year decreased from $340,200 to $142,940 as of 9/30/2021. Miscellaneous revenues Include office space sublease revenue from the Pelican Bay Foundation. Fiscal Year 2023 0 Once of the County Manager Agenda item #6b Page 3 of 5 Fund Detail Protorma Summary Grouped By Account Minor Collier County Government Fiscal Year 2023 FY 2021 FY 2022 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 Adopted Actual Adopted Amended Forecast Current Expanded Budget %Change 778 Pelican Bay Light Expenditures 500 Personal Services 87,287 1050500 105,600 107,300 113,600 0 113,600 7.68 600 Operating Expense 143,359 184,800 190,730 178,460 209,040 0 209,040 13,12 610 Indirect Cost Relmburs 100000 9,800 93800 91800 91400 0 9,400 -4,08 700 Capital Oullay 0 156,590 156,500 152,000 500 0 500 -99.68 855f Trans to Property Appraiser 0 12,000 12,000 12,000 10,000 0 10,000 -16.67 855h Trans to Tax Collector 12,688 17,000 17,000 17,000 151000 0 15,000 -11,76 912w Trans to 322 Pet Bay Irr and Land 2,061,800 440,000 440,000 440,000 370,000 0 370,000 -15,91 991 Reserve for Contingencies 0 11,400 11,400 0 11,400 0 11,400 0.00 993 Reserve for Capital 0 36,400 36,400 0 36,400 0 36,400 0.00 998 Reserve for Cash Flow 0 39,700 39,700 0 40,000 0 40,000 0,76 Revenues 306 Ad Valorem Taxes 6294977 660,900 660,900 634,500 684,000 0 684,000 3,50 307 Delinquent Ad Valorem Taxes 21270 0 - 0 0 0 0 0 N/A 360 Miscellaneous Revenues 0 18,400 18,400 0 180900 0 18,900 2,72 3611nterest/Mlsc 7,011 31600 31600 21400 3,600 0 31600 0,00 392h Trans frm Tax Collector 4,446 0 0 0 0 0 0 N/A 499u Carry Forward 2,096,500 364,300 370t230 425,000 142,940 0 142,940 -60,76 499z Less 5% Required By Law 0 -34,100 -34,100 0 •34,100 0 -34,100 0.00 Fund Total Expenditure: 2,3153134 11013,100 1,019,030 9160560 815,340 0 815,340 -19.52 Fund Total Revenue: 21740,204 11013,100 1,0191030 11061,900 816,340 0 815,340 -19.62 Fund Balance: 425,070 0 0 145,340 0 0 0 N/A GovMex 1 4/412022 Agenda Item #6b Page 4 of 5 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2023 FY 2021 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 FY 2023 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change �Q];�t�111�Sri�mza 500 Personal Services Expenditures 182701-778 512100 Regular Salaries 63,466 660447 660447 69,200 740298 0 749298 11,82 182701.778 612500 Auto Use Benefit 152 0 0 0 0 0 0 N/A 182701.778 512600 ER 457 Deferred 348 530 630 19000 530 0 630 0.00 182701-778 614100 Overtime 51812 62900 61900 6,400 7,100 0 71100 2,90 182701-778 616000 Vacation Sell Back 0 504 504 200 179 0 179 -64,48 182701-778 519100 Reserve For Salary 0 11486 19486 0 79 0 79 -94,68 182701-778 521100 Social Security 41241 51271 5,271 61600 61738 0 51738 8.86 182701478 522100 Retirement Regular 61109 70637 70637 8,200 91056 0 9,058 18.58 182701-778 623160 Health Insurance 13,886 13,886 130900 13,886 0 13,886 0A0 182701-778 523152 Dental Insurance 530 530 .130886 630 600 556 0 556 4.91 182701-778 523163 Short Term 106 106 106 100 132 0 132 24,53 182701478 623154 Long Term 212 212 212 200 238 0 238 12,26 182701-778 623160 Life Insurance 188 191 191 200 208 0 208 8.90 182701-778 524100 Workers 21400 1,800 1,800 1,800 1,600 0 1,600 41.11 182701-778 528200 Allowance Vehicle -152 0 0 0 0 0 0 N/A Expenditures 87,287 1051500 105,500 107,300 113,600 0 113,600 7,68 600 Operating Expense Expenditures 0 5,000 51000 0 4,700 0 41700 -6.00 182701-778 631400 Engineering Fees 182701-778 634210 Info Tech 600 500 60D 600 0 0 0 -100.00 182701478 634805 Emergency Malnl 0 21600 21500 0 2,500 0 21500 0.00 182701-778 634999 Other Contractual 35,277 37,800 43,730 43,800 45,000 0 45,000 19,05 182701478 639964 Storage Contractor 824 500 500 200 240 0 240 -52.00 182701478 639967 Temporary Labor 35,694 43,600 43,600 41,000 44,500 0 44,500 2,06 182701-778 641150 Telephone Beepers 360 400 400 360 400 0 400 0.00 182701478 641400 Telephone Direct 701 800 800 250 0 0 0 A00.00 182701-778 641950 Postage Freight 85 200 200 360 400 0 400 100,00 182701-778 643100 Electricity 25,420 26,000 26,000 28,000 26,000 0 26,000 0.00 182701-778 644100 Rent Buildings 13,693 16,o00 151000 44,000 27,000 0 279000 80,00 182701-778 644600 Rent Equipment 21105 2,000 21000 20200 2,500 0 21600 25,00 182701.778 645100 Insurance General 11600 11400 1,400 19400 11100 0 12100 -21.43 182701-776 645260 Auto Insurance 900 900 900 900 900 0 900 0.00 182701-778 646430 Fleet Malnt ISF 41392 1,400 1,400 11900 4,500 0 4,500 221,43 182701.778 646440 Fleet Malnt ISF 11602 900 900 600 12100 0 11100 22,22 182701.778 646445 Fleet Non Malnt 41835 200 200 200 41900 0 41900 23350,00 182701-778 646970 Other Equip Repair 0 Soo 600 0 500 0 500 0.00 182701-778 651110 Office Supplies 61636 800 800 0 800 0 800 0.00 182701-778 652140 Personal Safety 1,104 1,100 13100 2,600 2,600 0 21500 127,27 182701478 652490 Fuel and Lubricants 243 300 300 30o 500 0 50o 66,67 182701-778 652990 Other Operating 21387 2,000 29000 4,000 49000 0 4,000 100,00 182701-778 652992 Electrical 0 26,000 26,000 0 209000 0 20,000 -23.08 182701478 652993 Light Bulbs Ballast 61101 15,000 15,000 81000 15,000 0 150000 0.00 Expenditures 143,359 184,800 190,730 178,460 209,040 0 209,040 13.12 610 Indirect Cost Relmburs Expenditures 182701-778 634970 Indirect Cost 100000 91800 91800 90800 9,400 0 91400 -4,08 Expenditures 101000 92800 91800 91800 9,400 0 9,400 -4,08 700 Capital Outlay Expenditures 182701-778 764110 Autos And Trucks 0 156,000 156,0oo 152,000 0 0 0 -100,00 182701-778 764900 Data Processing 0 500 600 0 600 0 500 0.00 Expenditures 0 156,500 15%500 162,000 600 0 600 -99.68 855f Trans to Proper Appraiser Expenditures 959010-778 930600 Budget Transfers 0 12,000 12,000 12,000 100000 0 100000 -16,67 Expenditures 0 12,000 12,000 12,000 102000 0 10,000 -16.67 855h Trans to Tax Collector Expenditures 959010-778 930700 Budget Transfers 12,688 17,000 17,000 17,000 159000 0 15,000 -11,76 Expenditures 120688 17,000 179000 17,000 15,000 0 15,000 -11.76 912w Trans to 322 Pal Bay Irr and Land Expenditures 929010.778 913220 Transfer to 322 Pei 2,061,800 440,000 440,000 440,000 370,000 0 370,000 -16.91 Expenditures 210619800, 440,000 440,000 440,000 370,000 0 370,000 -16.91 GovMex 1 4/4I2022 Agenda item #6b Page 5 of 5 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2023 FY 2021 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 FY 2023 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 778 Pelican Bay Light 991 Reserve for Contingencies Expendltures 919010-778 991000 Reserve For 0 11,400 11,400 0 11,400 0 11,400 0100 Expenditures 0 11,400 11,400 0 11,400 0 11,400 0100 993 Reserve for Capital Expenditures 919010-778 993000 Reserve For 0 36,400 36,400 0 36,400 0 36,400 0100 Expenditures 0 36,400 36,400 0 36,400 0 36,400 0100 998 Reserve for Cash Flow Expenditures 919010-778 998000 Reserve For Cash 0 39,700 39,700 0 402000 0 40,000 0,76 Expenditures - 0 39,700 39,700 0 40,000 0 40,000 0,76 306 Ad Valorem Taxes Revenues 182700-776 311100 Current Ad Valorem 6290977 0 0 0 0 0 0 N/A 182701-778 311100 Current Ad Valorem 0 660,900 660,900 634,500 684,000 0 684,000 3150 Revenues 629,977 660,900 660,900 634,500 684,000 0 684,000 3,50 307 Delinquent Ad Valorem Taxes Revenues 182700.778 311200Dellnquenl Ad 21270 0 0 0 0 0 0 N/A Revenues 2,270 0 0 0 0 0 0 N/A 360 Miscellaneous Revenues Revenues 182701-778 362192 Lease Facilities 0 18,400 18,400 0 181900 0 18,900 2,72 Revenues 0 18,400 18,400 0 181900 0 18,900 2.72 361 Interest/Misc Revenues 182700.778 361320 Interest Tax 68 0 0 0 0 0 0 N/A 989010-778 361170lnterest SBA 1,388 0 0 0 0 0 0 N/A 989010-778 361180 Investment Interest 51555 3,600 30600 2,400 31600 0 3,600 0.00 Revenues 71011 31600 31600 21400 31600 0 31600 0.00 392h Trans frm Tax Collector Revenues 959010-778 486700 Transfer From Tax 4,446 0 0 0 0 0 0 N/A Revenues 4,446 0 0 0 0 0 0 N/A 499u Carry Forward Revenues 919010.778 489200 Carryferward 21096,500 364,300 364,300 425,000 142,940 0 142,940 -60,76 919010.778 489201 Carry Forward Of 0 0 51930 0 0 0 0 N/A Revenues 2,096,600 364,300 370m230 425,000 142,940 0 1423940 -60.76 499z Less 5% Required By Law Revenues 919010-778 489900 Less 6%Required 0 -34,100 -34,100 0 •34,100 0 -34,100 0.00 Revenues 0 -34,100 734,100 0 -34,100 0 -34,100 0.00 Fund Total Expenditure: 2,315,134 1,013,100 1,019,030 916,560 815,340 0 815$40 -19,52 Fund Total Revenue: 21740,204 1,013,100 11019,030 13061,900 815,340 0 8150340 -19,52 Fund Balance: 425,070 0 0 145,340 0 0 0 N/A GovMax 2 4I4I2022 Agenda item #6c Page 1 of Fund Detail Proforma Summary Grouped By Account Minor Collier County Government Fiscal Year 2023 FY 2021 FY 2022 FY 2022 FY 2022 FY 2023 FY2023 FY 2023 Adopted Actual Adopted Amended Forecast Current Expanded Budget %Change 320 Clam Bay Restoration Expenditures 600 Operating Expense 179,029 178,600 331,111 331,200 120,000 0 120,000 -32.81 865f Trans to Property Appraiser 0 81900 81900 81900 61800 0 6,800 -23,60 855h Trans to Tax Collector 31591 133100 132100 13,100 91600 0 91600 -26,72 9041 Trans to 109 PB MSTUBU Fd 34,100 34,100 34,100 34,100 34,100 0 34,100 0.00 Revenues 325a Special Assessments 179,564 238,500 238,500 22%000 166,200 0 166$200 -30,31 3611nterest/Misc 1,060 100 100 800 100 0 100 0.00 392d Trans frm Property Appraiser 2,980 0 0 0 0 0 0 N/A 392h Trans frm Tax Collector 11337 0 0 0 0 0 0 N/A 499u Carry Forward 201,900 81100 1600610 170,100 12,600 0 12,600 65,66 499z Less 6% Required By Law 0 -12,000 -12,000 0 -81400 0 -81400 -30.00 Fund Total Expenditure: 216,720 234,700 387,211 387,300 170,500 0 170,500 -27.35 Fund Total Revenue: 386,841 234,700 381,210 399,900 170,500 0 170,500 -27,35 Fund Balance: 170,121 0 -1 12,600 0 0 0 N/A OovMex 7 4I6/2022 Agenda item #6c Page 2 of 2 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2023 FY 2021 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 FY 2023 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 320 Clam BY Restoration 800 O ep rating E>Spense Expenditures 183800-320 631400 Engineering Fees 81,243 106,100 164,377 164,4 l) 85,000 0 85,000 -19,89 163800.320 634999 Other Contractual 21,186 353000 121,281 121,300 35,000 0 350000 0.00 183800-320 646319 Tree Trimming 76,600 37,500 40,900 40,900 0 0 0 -100.00 183800-320 652990 Other Operating 0 0 41553 41600 0 0 0 N/A Expenditures 179,029 178,600 331,111 331,200 120,000 0 V%000 -32.81 855f Trans to Property Appraiser Expenditures 959010-320 930600 Budget Transfers 0 89900 81900 8,900 63800 0 60600 -23.60 Expenditures 0 80900 8,900 81900 6,8o0 0 %800 -23.60 855h Trans to Tax Collector Expenditures 959010-320 930700 Budget Transfers 31591 13,100 13,100 13,100 91600 0 91600 -26,72 Expenditures 31591 13,100 13,100 130100 91600 0 91600 -26,72 9041 Trans to 109 PB MSTUBU Fd Expenditures 929010-320 911090 Transfer to 109 Pet 34,100 34,100 34,100 34,100 34,100 0 34,100 0,00 Expenditures 34,100 343100 34,100 34,100 34,100 0 34,100 0.00 325a Special Assessments Revenues 183800-320 325100 Speclal 776 238,500 238,500 229,000 166,200 0 166,200 -30.31 183805-320 325100 Speclal 178,788 0 0 0 0 0 0 NIA Revenues 179,564 238,500 238,500 229,000 166,200 0 166,200 -30.31 3611nteresUMiac Revenues 183805-320 361320 Interest Tax 19 0 0 0 0 0 0 NIA 989010-320 361170 Interest SBA 215 0 0 100 0 0 0 N/A 989010-320 361180 Investment Interest 826 100 100 700 100 0 100 0.00 Revenues 1,060 100 100 800 100 0 100 0.00 392d Trans frm Property Appraiser Revenues 959010-320 486600 Transfer From 21980 0 0 0 0 0 0 N/A Revenues 2,980 0 0 0 0 0 0 NIA 392h Trans frm Tax Collector Revenues 183800-320 486700 Transfer From Tax 901 0 0 0 0 0 0 NIA 183805-320 486700 Transfer From Tax -901 0 0 0 0 0 0 NIA 959010-320 486700 Transfer From Tax 13337 0 0 0 0 0 0 NIA Revenues 1,337 0 0 0 0 0 0 NIA 499u Carry Forward Revenues 919010-320 489200 Carryforward 201,900 83100 81100 170,100 12,600 0 123600 55,56 919010-320 489201 Carry Forward Of 0 0 152,510 0 0 0 0 N/A Revenues 201,900 8,100 160.610 170,100 12,600 0 12,600 55.56 499z Less 5% Required By Law Revenues 919010-320 489900 Less 5% Required 0 -12,000 -121000 0 -80400 0 -91400 -30.00 Revenues 0 -12,000 •121000 0 -8,400 0 -6,400 -30.00 Fund Total Expenditure: 2161720 234,700 3870211 387,300 170,500 0 170,500 •27.35 Fund Total Revenue: 386,841 234,700 387,210 399,900 170,500 0 170,500 -27.35 Fund Balance: 170,121 0 -1 12,600 0 0 0 NIA GovMax 1 4/612022 322 2022/20 Budget Summary Agenda item #6d Page 1 of 4 ;.Reserve C/Fwd 22/23 Budget $ 000 _. $ 000 _Reserves... $ 000 _., .... _ Revenue..: :. t.. 1490..... ,. ::. .._ .......... Tfr. From 77B 351. ., . i ....,. , Interest . _. '...._... g :. .. _ _. _....... ... County Contrtbutron 520 :Loan ': 6,500 I __..83870 �.. Projects _ LandscapeI 100.-_,_ pd Si inage::_ 94_ 150 I 244 Beach Reno 266 566 _ _ .._. _ _ _ ....300 .. Lake Banks 1 000._._.. 10000 i ... _ F..... Sidewalks Phase 2 866 61500.__ 7,366 ,..-.. _ _.. _ ., . Proects 132_._..... 132 _Other _ _ _._..... _..... Transfer to County;. 88 Debt Service...800.: I ... -i..... I i i 11226 80870, 11942 „ . I J t it � r , 21122 Assessment w net. Interest 'ttansters.ln No 778 Transfer cc S/W Cowin - Miscellaneous Rev, 0 .._.... 11798,400 1,798 406 i 0 9 500 20 000 10,600 -.._ .__ _ . .__ I ..._ . ...p 4ao,600, 4a0000 520,000I- I11 620000 a 0 $9,900,274i $9,910,774 . I ...._._._...................._.._.._.........._... _. .._.... .. � .. .. _........ ..._.. PROJECTS ' Landscape Imp 157)081 . 157,881 ... ....._....._ ..__..._..._. --------... _.. . ..._...._..... SI9na9e . 93,971 93,971 ... ..... _. ... ..._...__ ..._ . __.... ...i, ___..__.___..........--- ` Beach Reno : 2,2371867 ! 1,021,962 i Reserve 276 000 Roadway Safety 100,946 ! 1001945 . Side Walk Engineering 67,831 i 67,831 ........ __ _.. Ops Building__ . .... .. . . ......... .. ..._...... 3707,706 _.._...._.._. _. __. 3J979706 ._......:._. ..... __._...-- ....._.... .... _. ...... .. ..... .__. F Sidewalks -Phase 1 653,843 1 653,843 _.._._....... _..... ... ..... _.._.._.. .L.... .. .. .... _... .. _......... .. ... .. I Sidewalks. Phase 2, 0 7,382,697 ,. ._.....IFF............. ...... _.. .A........: .. I .I..... ... .. ... . . Lake Banks 12815,630! 2,401,946 lies Capital Outlay 451,800 0 . _._........ ... .. ..... .. .... Debt Service CIF ____-.___ ._._._ .. ........._., .._.__..... 75,000 IF FL Debt Service 200,000 200,000 ..... _. .. .._.. .. ...__ .. _.. _...__ ..... ... Irma Insurance reclaim 160,0001 160 000 .... ......... . ...... ._. ..._..., __. _.._ . . Collier County Fees i 88,100i 88,100 Financing needed $9,900,274 F. $16,381 782 ; IFk Table 1-1 Agenda item #6d Page 2 of 4 Cfwd per Jan F/S $ 7,280,8131 Higher balances °� _.-..._.. ......... 01 01 PBF sidewalks bid separately 0! 1006001 ._...._ .. .__......0....FF. _. _..._. ...................... 1 . ....._.. ___..___' _____.._. ._._.._...,. .... _.._..._.l .. ..... _ ......._-. _.__..__.__ . t__..._.. _.__...._.....I 6 j PBB Median Project 01 Reserve build ....--- --...._..._—.. . _...._ _ ' .._i.....P .__. .. 1,216,905 I Ex ense lower than expected ... _._ .._.. _.... _. ._. . .....: 275000Reserve build 0 Crosswalk .......... _............ .._.....__... _ ... ... ....._ I 0 0 1$3.8m-CC share $0.3M+ W ___ .I.- ... ... .._... ._.. ......-._.._. .... .F-.__..i Oi ......._. ... ____. .I _. ....__..... .. ._ ............ -7,382,697, ;$8.8M+ CEI+Engineering -588,4i8! $2,3m+ Engineering .._. ..._. . _.. ..--- ....... F. 451.600 76,000 .. .. .. .......... ... .... .........._ .. i........_.. ._.._.._.._._i 0I Interest and loan Initiation fees O1 0: g -$6 A81,608 I ...._ ...__I ...... _—_... _ ..... 1 BadgetAmendment 2022 Agenda item #6d Page 3 of 4 Agenda Item #7e Page t of 6 T�"Rz�50126 Beach Reno $940,000 Su As aftar$275K reserve All 1 flu [! (WMi 50126 51026 Lake Bank $600,000 New Account Sidewalk2 $34%000 T[M{@ttQ{x' 993000 Res Cap. Outlay $451,600 Ts� sa�.Ty �°.yy; New Account Sidewalk $451,600 �.-\�v�t 992090 Sldawulk 2 754000 r(X,;,;yka' ININ ORMIN 1 .... }.... r OWN. 1l;WkW Mill A: 1 Agenda item #6d Page 4 of 4 pBSD Proposed Loan Schedule 3/3/22 I ; .... 1 Dpfp ;' ..` Interest N3% Principle Loan Balance County Capital Fund Notes Repayment I Contribution to side :: . '' ;walks-$126K /qtr i ., . ._.:.,_ 7/i/2022, .::. . .. ..... I .. ! ....... _.... $8,500 ODO .. ._.... ... .... ... ..I.. ... .. _...... . ... ... .... Loan Origination i/1/2023:? .,.a $97,600 .0 0 $6,6000D0 $260,000,00 -$162,500.00 Interest only to conversion to IF IF F+414 IF I fixed loan 111/23 7/1/2023 $97 500 ! 216,OOD i $%284 000 $260,000.00 $63,60D.00 'Fixed Loan 16yr O 3% I �. ..__..: . ... .... ....... _... . ...... .... ... .. .. ........... .. . I I I I I .... I IF. I ., ..... .. i/1l2024 $94,280 i 2162000 $63068000 $260,000.00 $80,260.o0 Semi Annual Interest and I IF 1 j Principle payments ;. _ 7/1/2024 ............ .. $91,020 ...... I .... ._.. 216,000 ...__.._ $6,862 000 i..... .._.._...... $260p00.00 ....... _... $57,020.00 ; 21/23 Capital Assessment ....:: . ._ _........ ......._ .............__ .I....._........ .. ._....._... i$1.83M II 1/i/,2Q26 $87,780 2160000 $5,636000 j $260,000.00 $53,78000 i.. ,_ 7/1/2028 $84540 I_ 216,000 . _.. $5,420,000 $2601000,00 1 .... _ $50,640.00 ...... .._.._ .... I ' 1/1/2.028 $81300 218,000 $5,204000 I $25000D.00 $47,300.00 IF I l ;.:. ....... L.. ... .. . .. .711/2020. !. $78,060 i 210,000 I $4,988,000 $260,000.00 $44,08000 I _ ._— __...,...... FF. :.`.7/1/202T';�;:. $74,820 ..._......... 218,000 _....._..... $4,772,000 ___._._....... $260,006IF $40,820.00 j i- 7(1/2027, I 218,000 $4,666000 I.00 $250,000AO $37,68000 1. 1/1/2028I. IF ,. ,_,_,$71680 $68340 216,000 $4,340,000 $250,000.00 ! $340340.00 ., ........j 7/1/2028 $65100 216,000 $4,124,000 $260000.00 $310100,00 .:;% i/1/2020. $61,860 1.... .. _.._.. 216,000 $3,908000 ._... ! $260000.00 .. _._... $27,66000 . . .. _._ .. .... ... I ._.... L._. ....,.. I._.. .:,. ...._.... .. 7/1/2020, `: 458620 216,000 I $3,602000 I $260,000.00 $24,82000 �..... ... _, '. ..._ ._ L...... , ._..... 1t .. ...... _1 1 1 ..i 7/1/203.0. $55,380 216,00D $3476000 $271,38000 County contribution ends, .i�.i IF:7/1/2030 :; $529140 216 000 I $3 2601000 $268,140,00 1/A.31. >, $48900 216,000_.. $264,90000 i ... _ ! 7/1/2031,IF $46660 L... 216,000 I.._ i .$3,044,000 $20828060 .. . j .._.... $261,86000 ` ... 1/1/2O $42420 $2,612000 $268,42000 7/1/2032 $39180 ., .. -, .216,000 216,000 !. $2,396,000 $255018000 :. 1/1/2033 $36,040 216,000 $21180,000 $261,94000 Interest rate resale after 10 years+ mutual put option 7/1l2Q33. $32,70D 216,000 $1,984,000 $248,700.00 '32/33 Capital Assessment IF II at $6.Om+/yr IF : ......._... .�_ . _ ...... ........_ t ............... .....I .... . _..,..__.. IF ......_....__... .. .._.I -5years , 7 ! 1,964,000 ; 5yf est. P&I $500K/yr ._. _. _ ' 7!1(2033. .......... _ ....... 8600,000 .. _ . ......... $0 .. ...._. $3500000400 _.$1,964,000+Int' . ........... -.-mm, . 1Loan repaid I i.. ;, .;; :: ... .. ......... .....IFFIF I . .. IF ... ...... _. .... .. I 1 PELICAN BAY BALANCE SHEET March 31, 2022 (UNAUDITED) Pelican Bay Landscape, Street Safety, Lake &Beach Clam Bay Capital Operating Fund Lighting Projects Projects 109 778 322 320 TOTAL ASSETS Cash and investments 4,705,048.31 689,841.79 7,863,198.02 266,493.20 13,524,581,32 Interest receivable - - - - - Trade receivable, net - - - - Due from other governments 8,00 184,961.21 184,969.21 Totalassets 4,705,056.31 689,841.79 8,048,159.23 266,493.20 13,70%550.53 LIABILITIES AND FUND BALANCE Liabilities: Accounts payable 150,250.03 2*408,54 66,831.43 23,984.51 243,474,51 Wages payable - - - - - Retainage payable - - - - - Due toother Government 124,47 62.24 186.71 Total liabilities 150,374.50 2,470.78 66,831.43 23,984.51 243,661.22 Fund balances: Fund balance 4,554,681.81 687,371.01 7,981,327.80 242,508.69 13,465,889.31 Total llabilities and fund balances 4,705,056.31 689,841.79 8,048,159.23 266,493.20 13,709,550.53 Fund Balanceattheend ofthe period 4,554,681.81 687,371,01 7,981,327.80 242t508,69 13,465,889.31 Unspent balance of projects: Small projects under5200K 50126-Beach Renourishment 50211-PBSD OPS BLD 50212-PBSD PH3-SW 51026-PBSD Lake Bank Restoration 51100-Clam Bay Restoration Total unspent balance of major projects Budgeted reserves: 993000-Reserve far contingencies 991700-Reserve for disaster relief 992090-Reserve for sinking fund 993000-Reserve for capital outlay 994500-Reserve for future construction and Improvemen 998000-Reserve for cash Total budgeted reserves - - 254,196.83 - 254,196.83 - - 1,321,510.83 - 1,321,510.63 - %781J26.87 - 3,781,126.87 - - 353,926.54 - 353,926.54 - 2,198,348.42 - 2,198,348.42 220,917.86 220,917.86 7,909,109.49 220,917.86 8,130,02735 159,000.00 11,400.00 - - 170,400.00 700,000.00 - 160,000.00 - 860,000.00 - - 75,000.00 - 75,000.00 111r200.00 36,400,00 451,600.00 - 599,200.00 475,000.00 39,700.00 514,700.00 1,445,200.00 8J,500.00 686,600.00 2,219,300.00 Budgeted commitments at the end of the period 1,445,200.00 87,500.00 8595,709.49 220,917.86 10,349,327.35 3,109,481.81 599,871.01 (614,381.69) 21,590.83 3,116,561.96 !§§ ( \\ aa ; #„ 0 rr. ;, a rmm ; l;E.., _ (\!} - .§JE7; . ,} ( }}} ! .....)\ \ ! ! ; / § i! )! ` \ ;« ! „n1 ) -! !4f r«r ;r " " § r ) M a .II §.8....; ;,; ,�� „ ..... :]! •,. Z§ }§ fM / \ ! ......., ! § \a ; ! , E En .:� ;;;; >;§ ;i§ i ;] , §!;\_§ , \ EEE EBr \))(f4 , ,. , |;}E!! {§)( § r§ § ! f | )!) | - ! ((� . ;;; ) , ;;) §!f ! r!; d § �; |! , aa0 |))! g} ; §\E{2 aK !w G ; s �!,!R ;!! d B m�5;& : ;/ !!§! §!°` 9°°;!� !;§!)/ : !]!} ! []! !| !!! ! . I }((( �(\m §\ 00 0 a \/ .......: .......;. "i}`] ! ) ! § } am a% ..\.}}MW }}\ .,!! } ,.l...I „ !; ..,,,Br ,. \ ! § !\!| 2} .. }\ ! !! ..IIkI •! \\ (( - ) /( �\ ) /5r }:!:^[ f!