The URL can be used to link to this page

PBSD MSTBU Agenda 04/06/2023 (Budget)PELICAN BAY SERVICES DIVISION Municipal Services Taxing and Benefit Unit NOTICE OF PUBLIC MEETING THURSDAY, APRIL 6, 2023 THE BUDGET COMMITTEE OF THE PELICAN BAY SERVICES DIVISION WILL MEET ON THURSDAY, APRIL 6 AT 2:00 PM 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 11/09/2022 meeting minutes 5. Audience Comments 6. Review of the draft FY24 PBSD budget 7. Target FY24 PBSD assessment 8. Adjournment 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 NOVEMBER 9, 2022 The Budget Committee of the Pelican Bay Services Division met on Wednesday, Nov. 9 at 1:30 p.m. at the Truist Building, 801 Laurel Oak Drive, Suite 102, Naples, Florida. In attendance were: Budget Committee Michael Fogg, Chairman Joe Chicurel Denise McLaughlin Michael Rodburg (absent) Pelican Bay Services Division Staff Dave Greenfield, Interim Supr. —Field II (absent) Neil Dorrill, Administrator Karin Herrmann, Ops. Support Specialist II Chad Coleman, Operations Manager Lisa Jacob, Project Manager II Darren Duprey, Project Manager I (absent) Barbara Shea, Admin. Support Specialist II Also Present Michael Weir, PBSD Board APPROVED AGENDA (ASAMENDED) I . Pledge of Allegiance 2. Roll call 3. Agenda approval 4. Approval of 5/04/2022 meeting minutes 5. Audience Comments 6. Review of October Financial Statements a. New format b. Year-end adjustments 7. Financial impact of Hurricane Ian a. Update on Hurricane Ian Clean-up (add -on) 8. Budget impact of Oakmont Lake Project close-out 9. Review of plans for draw down of financing a. Timing of cash flow requirements by major project for FY2023 b. Options for budget amendments to defer future loan draw down 10. Ten-year financial projection I1. Adjourn ROLL CALL Mr•. Rodburg was absent and a quorum was established. 1 Pelican Bay Services Division Budget Committee Meeting November 9, 2022 AGENDA APPROVAL Ms. McLaughlin motioned, Mr. Fogg seconded to approve the agenda as amended. The motion carried unanimously. IMs. McLaughlin motioned, Dr. Chicurel seconded to approve the 5/04/2022I meeting minutes as presented. The motion carried unanimously. UPDATE ON HURRICANE IAN LOSSES AND RELATED FINANCIAL IMPACTS Mr. Coleman provided the following updates related to Hurricane Ian. • Replacement irrigation equipment has been ordered at a cost of approximately $116,000. Our in-house crew will complete the installation. This purchase order is being funded through our operations budget. • Aerators need to be replaced in 17 lakes at a cost of approximately $215,000. Staff will complete the aerator installation. • Our tide gauges in Clam Bay need to be replaced at an approximate cost of $22,000. • Our Operations Building has been completely gutted. Only the bathrooms continue to be used by staff. No offices are in use. Two microwaves and two refrigerators were purchased for the maintenance staff, which are FEMA reimbursable. Workstations have been set up in the Truist Building PBSD Office for maintenance staff needs. Staff is working on leasing a temporary trailer; the estimated annual lease cost is approximately $50,000. • The Replacement Operations Building Project will be put out to bid in December/January. It is hoped that we receive a project bid under $4 million. Ms. McLaughlin questioned whether we could add solar capability to the specs and suggested that federal subsidies may be available for this additional expense. Mr. Dorrill will follow up with our engineer, Davidson Engineering on this issue. • Our replacement costs for the aerators, tide gauges, and temporary maintenance trailer will likely be FEMA reimbursable. Replacement costs for lost equipment for "life, safety, and health" are generally FEMA reimbursable. • PBSD staff removed approximately 800 cubic yards of horticulture debris in Pelican Bay. • A purchase order for Hart's Electric has been opened for approximately $35,000 for street lighting repairs, in order to get the lights back on. Streetlights and irrigation are our #1 priorities. • The Pelican Bay Beach has been cleaned by outside contractor, Earth Tech, hired by the County's Coastal Zone Mgt. Dept. A new beach survey has been completed. The elevation of the beach has been reduced. It is expected that the County will make a decision on beach renourishment sometime in early 2023, and the PBSD will piggy -back onto their project. The dune along our shore is gone and will need to be restored. Although the County will seek FEMA reimbursement for the needed dune restoration and sand replacement, Mr. 2 Pelican Bay Services Division Budget Committee Meeting November 9, 2022 Dorrill commented that he feels it is unlikely that FEMA will provide reimbursement for these items. • County beaches are currently closed. The County is hoping to open Vanderbilt Beach for the Thanksgiving holiday. Signs will be posted, warning of possible objects in the sand. • Post -Ian aerials of Clam Pass have been taken. Our Coastal Engineer, Dr. Dabees will have a new survey of Clam Pass performed. The Pass does appear to be flowing. • Om• Oakmont Lake Project is nearing completion. The lake bank work is completed. The contractor has some remaining work to complete in the park area. The project is expected to come in within budget. • Mobilization of the Sidewalk Phase 2 Project is expected to begin on Monday, Nov. 14. The contractor is planning to start the project by removing the sidewalk on Ridgewood Drive, starting at the south end, and working northward. All planned tree removal has been completed. Some stump grinding work remains to be completed. AUDIENCE COMMENTS None REVIEW OF OCTOBER FINANCIAL STATEMENTS Mr. Fogg provided a newly formatted 10/31/2022 PBSD balance sheet, which was added to the record. This new format provides two columns to separate out "assessment funded activities" and "Pelican Bay financed capital projects, Fund 323." Mr. Fogg commented that he worked with the Clerk's Office to produce this format which shows our outstanding debt as well as the amount (currently $4 million) which we have available to draw down. Ms. McLaughlin emphasized that we cannot go out for bids on our projects unless we have the funds available in our budget, to pay for them. Mr. Fogg commented that we must draw down funds in advance of our receiving contractor invoices. Currently we have more cash than we need on our balance sheet, as a result of the delays of our Sidewalk Phase 2 Project and our Operations Building Project. Mr. Fogg reviewed unspent balances of projects and reserves for future planned projects. Mr. Coleman suggested that no new lake bank projects are planned this year, and therefore funds in reserve for such future projects may be used for this year's beach renourishment needs. REVIEW OF PLANS FOR DRAW DOWN OF FINANCING Mr. Coleman reported that we will need approximately $30Q000 each month going forwarA to pay for invoices related to our Sidewalk Phase 2 project. He noted that we may not need any additional draw downs this fiscal year, as a result of the delay in both the start of this project and our Operations Building project. Mr. Fogg questioned whether we could pay back some of the funds already drawn down, without a prepayment penalty fee. Mr. Dorrill commented that he will research whether a payback is possible, without a penalty fee. He also noted that if we choose to use funds currently earmarked for other projects this fiscal year, that we will need to process a budget amendment (requiring BCC approval) no later than July 1, 2023. Mr. Dorrill noted that the interest rate on our borrowed funds is 2.6% and that we are earning a lesser interest rate on our cash on hand. Pelican Bay Services Division Budget Committee Meeting November 9, 2022 TEN-YEAR FINANCIAL PROJECTION Mr. Fogg reviewed his "10-year assessment and capital project projections" document which was included in the agenda packet. He noted that his 10-year estimates do not include inflation. All estimates as well as debt service will need to be adjusted for inflation in the future, where applicable. Mr. Fogg suggested that we will need to build reserves for street lighting at sometime in the future. He noted that his assessment estimates for the next two years require a 3% increase in the assessment for capital needs (which would be in addition to any inflation required increases). FUTURE TREE REPLACEMENT Mr. Dorrill commented that Mr. Griffith has been tasked to prepare a proposal to enhance/add canopy trees on Pelican Bay Blvd. as well as other residential streets. He noted that we will need professionally prepared exhibits of his proposal, which include "road right-of-way" and private property lines. Ms. McLaughlin suggested that we review the tree species on our list of approved trees, and eliminate those which are not storm -resistant. Mr. Coleman also suggested that any new trees should be maintenance friendly. Mr. Dorrill commented that the Landscape & Safety Committee will need to develop a tree replacement policy, which would include a discussion of who would be responsible for the maintenance of newly planted trees on private property (inside the right-of-way). This issue may require a legal opinion. The meeting was adjourned at 2:29 Michael Fogg, Chairman Minutes approved �] as presented OR L� as amended ON ( ]date 4 Fund Detail Proforma Summary Grouped By Account Minor Collier County Government Fiscal Year 2024 FY 2022 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 109 Pelican Bay Beautification MSTBU Expenditures 500 Personal Services 2,161,126 2,2411600 2,241,600 21281,700 2,585,800 0 21585,800 15,36 600 Operating Expense 2,048,634 2,286,500 2,341,869 2,273,900 2,342,100 0 21342,100 2.43 610 Indirect Cost Relmburs 136,100 150,000 150,000 150,000 1410000 0 141,000 -6.00 700 Capital Outlay 50,362 98,500 214,325 212,900 1840600 0 184,500 87.31 855f Trans to Property Appraiser 72,036 80,000 80,000 80,000 80,000 0 80,000 0.00 855h Trans to Tax Collector 77,899 120,000 120,000 120,000 110,000 0 110,000 -8,33 912a Trans to 301 Cc Wide Cap Fd 8,700 81700 8,700 81700 81700 0 81700 0.00 916h Trans to 408 Water/Sewer Fd 21,000 17,600 17,600 173600 17,600 0 17,600 0.00 920f Trans to 506 IT Capital 0 37,100 37,100 37,100 37,100 0 37,100 0.00 991 Reserve for Contingencies 0 1083500 108,500 0 170,000 0 170,000 56,68 991d Reserve for Salary Adj. 0 162$00 162,500 0 0 0 0 -100.00 993 Reserve for Capital 0 1103500 110,500 0 120,000 0 120,000 8,60 995e Reserve for Disaster Relief 0 700,000 700,000 0 700,000 0 700,000 0.00 998 Reserve for Cash Flow 0 4753000 475,000 0 475,000 0 475,000 0.00 999 Reserve for Attrition 0 -39,300 -39,300 0 -39,300 0 -39$00 0.00 Revenues 325a Special Assessments 31894,956 4,903,400 41903,400 4,707,200 51215,600 0 5,215,600 6.37 360 Miscellaneous Revenues 106,977 36,800 36,800 1%400 40,800 0 40,800 10.87 3611nterest/Misc 25,666 20,000 20,000 26,000 26,000 0 26,000 30,00 392d Trans frm Property Appraiser 447 0 0 0 0 0 0 N/A 392h Trans frm Tax Collector 30,134 0 0 0 0 0 0 N/A 413u Trans fm 320 Clam Bay Cap Fd 34,100 340100 34,100 34,100 34,700 0 34,700 1.76 499u Carry Forward 23756,900 1,811,000 13982,193 21273,300 1,877,100 0 1,877,100 3.65 499z Less 5% Required By Law 0 -248,100 -248,100 0 -2611700 0 -261,700 5.48 Fund Total Expenditure: 4,575,856 61557,200 67728,393 53181,900 63932,500 0 6,932,500 5.72 Fund Total Revenue: 6,849,180 6,557,200 61728,393 7305%000 63932,500 0 6,932,500 5.72 Fund Balance: 21273,324 0 0 1,877,100 0 0 0 N/A GovMax 1 4/3/2023 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2024 FY 2022 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 109 Pelican Bay Beautification MSTBU 500 Personal Services Expenditures 182602-109 512100 Regular Salaries 269,591 264,351 264,351 282,600 298,000 0 298,000 12.73 182602-109 512500 Auto Use Benefit 258 0 0 0 0 0 0 N/A 182602-109 512600 ER 457 Deferred 1,499 11530 13530 4,200 2,896 0 2,896 89.28 182602-109 514100 Overtime 22,776 21,000 21,000 28,300 25,000 0 25,000 19,05 182602-109 515000 Vacation Sell Back 0 635 635 0 755 0 755 18.90 182602-109 519100 Reserve For Salary 0 91 91 0 16,440 0 16,440 17,965.93 182602-109 519200 Merit 0 0 0 0 4,716 0 41716 N/A 182602-109 521100 Social Security 21,021 20,389 20,389 25,900 24,691 0 24,691 21.10 182602-109 522100 Retirement Regular 32,698 32,221 32,221 373700 47,830 0 47,830 48.44 182602-109 523150 Health Insurance 50,566 50,566 500566 50,600 533114 0 53,114 5.04 182602-109 523152 Dental Insurance 1,930 21026 2,026 20000 21026 0 21026 0.00 182602-109 523153 Short Term 386 482 482 500 482 0 482 0.00 182602-109 523154 Long Term 772 868 868 900 868 0 868 0,00 182602-109 523160 Life Insurance 679 741 741 700 882 0 882 19.03 182602-109 524100 Workers 51500 6,600 60600 63600 71000 0 73000 6.06 182602-109 528200 Allowance Vehicle -258 0 0 0 0 0 0 N/A 182901-109 512100 Regular Salaries 9403814 11036,106 1t036,106 995,700 1,138,367 0 11138,367 9,87 182901-109 512500 Auto Use Benefit 266 0 0 0 0 0 0 N/A 182901-109 512600 ER 457 Deferred 61529 7,440 7,440 12,300 91410 0 93410 26.48 182901-109 514100 Overtime 220,662 215,000 215,000 228,000 2250000 0 225,000 4.65 182901-109 515000 Vacation Sell Back 0 2,491 2,491 0 21883 0 2,883 15.74 182901-109 518100 Termination Pay 0 0 0 100400 0 0 0 N/A 182901-109 519100 Reserve For Salary 0 35 35 0 62,621 0 62,621 178,817.14 182901-109 519200 Merit 0 0 0 0 18,015 0 18,015 N/A 182901-109 521100 Social Security 83,830 803018 80,018 87,000 94,196 0 94,196 17.72 182901A09 522100 Retirement Regular 139,572 133,028 133,028 142,300 166,291 0 166,291 25.00 182901-109 523150 Health Insurance 289,248 2893248 2893248 289,200 303,820 0 303,820 5.04 182901-109 523152 Dental Insurance 11,040 11,593 11,593 11,600 11,593 0 11,593 0.00 18290iA09 523153 Short Term 2,208 2,761 21761 2,800 2,761 0 2,761 0.00 182901-109 523154 Long Term 4,416 4,969 41969 5,000 41969 0 4,969 0.00 182901-109 523160 Life Insurance 20589 2,911 23911 2,900 31374 0 3,374 15.91 182901-109 524100 Workers 52,800 54,500 54,500 54,500 57,800 0 57,800 6.06 182901-109 528200 Allowance Vehicle -266 0 0 0 0 0 0 N/A Expenditures 21161,126 2,241,600 21241,600 21281 p700 2,585,800 0 2,585,800 15.36 600 Operating Expense Expenditures 182602-109 631400 Engineering Fees 16,623 17,000 17,000 14,500 17,000 0 17,000 0.00 182602-109 634207 IT Capital Allocation 4,800 0 0 0 0 0 0 N/A 182602-109 634210 Info Tech 8,700 9,300 91300 91300 63700 0 6,700 -27.96 182602-109 634211 IT Billing Hours 500 800 800 800 1,400 0 1,400 75.00 182602-109 634251 Flood Control 160,159 240,000 286,641 271,700 220,000 0 220,000 -8.33 182602-109 634805 Emergency Maint 582 600 600 0 600 0 600 0.00 182602-109 6349801nterdept Payment 11,525 0 0 0 0 0 0 N/A 182602-109 634999 Other Contractual 51,526 723000 72,000 72,000 720000 0 72,000 0.00 182602-109 639967 Temporary Labor 73,984 873000 87,000 83,000 85,000 0 850000 -2,30 182602-109 640410 Motor Pool Rental 41 0 0 0 0 0 0 N/A 182602-109 641150 Telephone Beepers 360 400 400 400 400 0 400 0.00 182602-109 641400 Telephone Direct 250 0 0 0 0 0 0 N/A 182602-109 641700 Cellular Telephone 3,521 3,000 31000 41600 3,800 0 3,800 26,67 182602-109 641950 Postage Freight 3,651 200 200 too 200 0 200 0.00 182602-109 643300 Trash and Garbage 13,457 14,000 14,000 14,000 14,000 0 14,000 0.00 182602-109 644100 Rent Buildings 43,558 453000 45,000 48,700 500900 0 50,900 13,11 182602-109 644600 Rent Equipment 1,579 1,800 11800 1,600 11600 0 1,600 -11.11 182602-109 645100 Insurance General 5,100 4,500 43500 41500 41700 0 41700 4.44 182602-109 645260 Auto Insurance 1,400 1,400 11400 1,400 1,400 0 10400 0.00 182602-109 646311 Sprinkler System 218 0 0 0 0 0 0 N/A 182602-109 646319 Tree Trimming 66,895 61,000 61,000 30,000 45,000 0 45,000 -26.23 182602-109 646320 Landscape 0 5,000 5,000 600 53000 0 5,000 0.00 182602-109 646430 Fleet Maint ISF 32,825 153600 153600 15,600 81600 0 80600 -44.87 182602-109 646440 Fleet Maint ISF 4,325 6,700 6,700 63700 41300 0 4,300 -35.82 182602-109 646445 Fleet Non Maint 4,486 2,500 2,500 21500 31200 0 31200 28.00 182602-109 646970 Other Equip Repair 6,837 3,000 113728 81600 3,000 0 3,000 0.00 182602-109 647110 Printing Binding 0 300 300 0 0 0 0 -100.00 182602-109 649000 Sales Tax Expense -13 0 0 0 0 0 0 N/A 182602-109 649030 Clerks Recording 0 100 100 0 100 0 100 0.00 GovMax 1 4/3/2023 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2024 FY 2022 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 109 Pelican Bay Beautification MSTBU 600 Operating Expense Expenditures 182602-109 649100 Legal Advertising 1,715 2,000 2,000 1,500 1,500 0 1,500 -25.00 182602-109 651110 Office Supplies 1,435 12500 12500 1,000 11500 0 10500 0.00 182602-109 651930 Minor Office 566 0 0 0 0 0 0 N/A 182602-109 652130 Clothing And 563 23000 23000 1,000 2,000 0 21000 0.00 182602-109 652140 Personal Safety 20123 3,500 31500 2,000 3,500 0 31500 0,00 182602-109 652310 Fertilizer Herbicides 26,016 70,000 7%000 50,000 60,000 0 60,000 -14.29 182602-109 652490 Fuel and Lubricants 4,111 3,500 31500 11200 30400 0 33400 -2.86 182602-109 652990 Other Operating %668 13,700 13,700 16,000 15,000 0 15,000 9.49 182602-109 654360 Other Training Ed 21500 40000 4,000 1,500 2,500 0 21500 -37.50 182901-109 631400 Engineering Fees 0 10,000 10,000 0 10,000 0 10,000 0.00 182901-109 634207 IT Capital Allocation 173300 0 0 0 0 0 0 N/A 182901-109 634210 Info Tech 44,600 45,300 45,300 45,300 59,000 0 59,000 30.24 182901-109 634253 Flood Control 159,628 1003000 100,000 100,000 115,000 0 115,000 15.00 182901-109 634805 Emergency Maint 0 2,500 20500 0 2,500 0 23500 0.00 182901-109 634980 Interdept Payment 21639 0 0 0 0 0 0 N/A 182901-109 634990 Landscape 796 3,000 3,000 11500 31000 0 3,000 0.00 182901-109 634999 Other Contractual 239,632 1531000 1533000 150,000 150,000 0 160,000 -1,96 182901-109 639964 Storage Contractor 222 300 300 300 300 0 300 0,00 182901-109 639966 Pest Control 0 500 500 800 11000 0 11000 100.00 182901-109 639967 Temporary Labor 306,286 347,000 3473000 345,000 345,000 0 345,000 -0.58 182901-109 640300 Out Of County 1,172 500 500 23100 21500 0 21500 400.00 182901-109 640410 Motor Pool Rental 142 0 0 900 0 0 0 N/A 182901-109 641150 Telephone Beepers 360 400 400 400 400 0 400 0.00 182901-109 641400 Telephone Direct 425 400 400 0 0 0 0 -100,00 182901-109 641700 Cellular Telephone 9,715 92500 90500 90500 10,500 0 10,500 10.53 182901-109 641950 Postage Freight 30 500 500 900 1,000 0 1,000 100.00 182901-109 643100 Electricity 20969 21500 23500 21500 21500 0 2,500 0,00 18290iA09 643300 Trash and Garbage 3,635 41000 4,000 4,000 43000 0 4,000 0.00 182901-109 644100 Rent Buildings 43,558 45,000 45,000 48,700 500900 0 50,900 13.11 182901-109 644600 Rent Equipment 1,667 41300 4,300 90900 10,000 0 10,000 132.56 182901-109 645100 Insurance General 13,500 12,900 12,900 12,900 13,600 0 13,600 5,43 182901-109 645260 Auto Insurance 10,700 10,700 10,700 10,700 10,700 0 10,700 0,00 182901-109 646180 Building R And M 0 21500 21500 0 0 0 0 -100.00 182901-109 646311 Sprinkler System 503737 58,000 58,000 112,000 580000 0 58,000 0.00 182901-109 646314 Maintenance 64,917 105*000 105,000 105,000 120,000 0 1200000 14,29 182901-109 646319 Tree Trimming 144,565 175,000 175,000 155,000 155,000 0 155,000 -11.43 182901-109 646320 Landscape 593857 120,000 120,000 120,000 1500000 0 150,000 25.00 182901-109 646381 Road And Bikepalh 29,554 25,000 25,000 25,000 25,000 0 25,000 0,00 182901-109 646430 Fleet Maint ISF 49,795 61,600 610600 61,600 71,800 0 71,800 16.56 182901-109 646440 Fleet Maint ISF 27,462 29,400 29,400 29,400 35,700 0 35,700 21.43 182901-109 646445 Fleet Non Maint 13,161 6,300 6,300 6,300 13,200 0 13,200 109,52 182901-109 646970 Other Equip Repair 4,272 8,000 80000 2,500 81000 0 8,000 0.00 182901-109 647110 Printing Binding 21896 500 500 0 500 0 500 0.00 182901-109 649000 Sales Tax Expense 12 0 0 0 0 0 0 N/A 182901-109 649010 Licenses And 11497 20500 2,500 0 2,500 0 2,500 0,00 182901-109 649030 Clerks Recording 91595 81400 8,400 10,100 10,200 0 10,200 21.43 182901-109 649100 Legal Advertising 109 3,000 3,000 200 11500 0 1,500 -50.00 182901-109 651110 Office Supplies 13483 2,000 2,000 1,600 1,600 0 1,600 -20,00 182901-109 651930 Minor Office 62868 0 0 0 0 0 0 N/A 182901-109 651950 Minor Data 0 500 500 0 500 0 500 0,00 182901-109 652110 Clothing And 346 600 600 3,700 4,000 0 41000 566.67 182901-109 652130 Clothing And 16,788 203000 20,000 20,000 200000 0 20,000 0.00 182901-109 652140 Personal Safely 61118 71000 7,000 7,000 71000 0 71000 0,00 182901-109 652310 Fertilizer Herbicides 63,216 105,000 105,000 105,000 120,000 0 120,000 14.29 182901-109 652490 Fuel and Lubricants 41,590 55,700 55,700 45,000 55,600 0 55,600 -0,18 182901-109 652910 Minor Operating 61032 15,000 150000 15,000 15,000 0 15,000 0.00 182901-109 652920 Computer Software 0 800 800 1,400 800 0 800 0.00 182901-109 652990 Other Operating 17,250 20,000 20,000 37,100 25,000 0 25,000 25.00 182901-109 652999 Painting Supplies 0 500 500 100 500 0 500 0,00 182901-109 653710 Traffic Signs 21431 8,000 81000 0 83000 0 8,000 0.00 182901-109 654360 Other Training Ed 31519 2,500 23500 700 23500 0 2,500 0.00 Expenditures 2,048,634 2,286,500 2,341,869 202730900 21342,100 0 21342,100 2.43 GovMax 2 4l3/2023 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2024 FY 2022 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 109 Pelican Bay Beautification MSTBU 610 Indirect Cost Reimburs ExRenditores 182602-109 634970 Indirect Cost 136,100 150,000 150,000 1503000 141,000 0 141,000 -6,00 Expenditures 136,100 150,000 150,000 150,000 141,000 0 141,000 .6.00 700 Capital Outlay Expenditures 182602-109 764110 Autos And Trucks 0 0 0 0 450000 0 45,000 N/A 182602-109 764900 Data Processing 0 500 500 0 500 0 500 0.00 182602-109 764990 Other Machinery 0 10,000 10,000 103000 0 0 0 -100.00 182901-109 764110 Autos And Trucks 0 0 80,654 80,700 40,000 0 40,000 N/A 182901-109 764900 Data Processing 0 11000 13000 0 11000 0 1,000 0.00 182901-109 764990 Other Machinery 50,362 87,000 122,171 122,200 98,000 0 98,000 12.64 Expenditures 50,362 98,500 214,325 212,900 184,500 0 184,500 87.31 855f Trans to Property Appraiser Expenditures 959010-109 930600 Budget Transfers 72,036 80,000 80,000 80,000 800000 0 80,000 0.00 Expenditures 72,036 80,000 80,000 80,000 80,000 0 800000 0.00 855h Trans to Tax Collector Expenditures 959010-109 930700 Budget Transfers 77,899 120,000 1207000 1203000 110,000 0 110,000 -8.33 Expenditures 77,899 120,000 120,000 120,000 110,000 0 110,000 -8.33 912a Trans to 301 Co Wide Cap T Fd Expenditures 929010-109 913001 Transferto 8,700 83700 8,700 8,700 81700 0 81700 0.00 Expenditures 8,700 81700 8,700 81700 8,700 0 81700 0.00 916h Trans to 408 Water/Sewer Fd Expenditures 929010-109 914008 Transfer to 21,000 17,600 17,600 170600 17,600 0 17,600 0.00 Expenditures 21,000 17,600 17,600 173600 17,600 0 17,600 0.00 920f Trans to 506 IT Capital Expenditures 929010-109 915006 Transfer to 0 37,100 37,100 37,100 37,100 0 37,100 0.00 Expenditures 0 37,100 37,100 37,100 37,100 0 37,100 0.00 991 Reserve for Contingencies Expenditures 919010-109 991000 Reserve For 0 108,500 108,500 0 170,000 0 170,000 56.68 Expenditures 0 108,500 108$00 0 170,000 0 170,000 56.68 991d Reserve for Salary Adl, Expenditures 919010-109 992150 Reserve for Salary 0 162,500 162,500 0 0 0 0 -100.00 Expenditures 0 162,500 162,500 0 0 0 0 -100.00 993 Reserve for Capital Expenditures 919010-109 993000 Reserve For 0 1101500 110,500 0 120,000 0 120,000 8.60 Expenditures 0 1%500 110,500 0 120,000 0 120,000 8.60 995e Reserve for Disaster Relief Expenditures 919010-109 991700 Reserve For 0 700,000 700,000 0 700,000 0 7003000 0,00 Expenditures 0 700,000 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 475,000 0.00 Expenditures 0 475,000 475,000 0 4760000 0 475,000 0.00 999 Reserve for Attrition Expenditures 919010-109 992100 Reserve For 0 -39,300 -3%300 0 -39,300 0 -393300 0,00 Expenditures 0 -39,300 -39,300 0 -393300 0 -39,300 0.00 325a Special Assessments Revenues 182602-109 325100Special 9190670 1,431,200 11431,200 11412,200 11423,100 0 1,423,100 -0.57 182901-109 325100 Special 219759286 31472,200 31472,200 392959000 31792,500 0 3,792,500 9,22 Revenues 31894,956 49903,400 4,903,400 41707,200 5,2151600 0 51215,600 6,37 360 Miscellaneous Revenues Revenues 182602-109 362190 Lease Facilities 71138 0 0 0 0 0 0 N/A 182602-109 362192 Lease Facilities 11,490 18,400 18,400 18,400 203400 0 20,400 10.87 182901-109 362190 Lease Facilities 7,138 0 0 0 0 0 0 N/A GovMax 3 4I3I2023 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2024 FY 2022 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 109 Pelican Bay Beautification MSTBU 360 Miscellaneous Revenues Revenues 182901-109 362192 Lease Facilities 117490 18,400 18,400 0 20,400 0 20,400 10.87 182901-109 364410 Surplus Furniture 12,950 0 0 0 0 0 0 N/A 182901-109 366900 Contributions 56,772 0 0 0 0 0 0 N/A Revenues 106,977 363800 360800 18,400 40,800 0 40,800 10.87 361 Interest/Misc Revenues 182602-109 361320 Interest Tax 70 0 0 0 0 0 0 N/A 182901-109 3613201nterest Tax 247 0 0 0 0 0 0 N/A 989010-109 361170 Interest SBA 7,019 0 0 0 0 0 0 N/A 989010-109 361180 Investment Interest 18,329 209000 20,000 26,000 26,000 0 26,000 30.00 Revenues 25,666 20,000 20,000 26,000 26,000 0 26,000 30.00 392d Trans firm Property Appraiser Revenues 959010-109 486600 Transfer From 447 0 0 0 0 0 0 N/A Revenues 447 0 0 0 0 0 0 N/A 392h Trans frm Tax Collector Revenues 959010-109 486700 Transfer From Tax 30,134 0 0 0 0 0 0 N/A Revenues 30,134 0 0 0 0 0 0 N/A 413u Trans fm 320 Clam Bay Cap Fd Revenues 929010-109 413040 Transfer From 34,100 34,100 34,100 34,100 34,700 0 34,700 1,76 Revenues 34,100 34,100 34,100 34,100 34,700 0 34,700 1,76 499u Carry Forward Revenues 919010-109 489200 Carryfonvard 21756,900 1,811,000 19811,000 2,2733300 13877,100 0 1,877,100 3.65 919010-109 489201 Carry Forward Of 0 0 171,193 0 0 0 0 N/A Revenues 2,756,900 1,811,000 1,982,193 2,273,300 1,877,100 0 1,877,100 3.65 499z Less 5 % Required By Law Revenues 919010-109 489900 Less 5% Required 0 -248,100 -2480100 0 -261,700 0 -261 p700 5.48 Revenues 0 -248,100 -248,100 0 -261 p700 0 -261,700 5.48 Fund Total Expenditure: 4,575,856 6,557,200 6,728,393 5,181,900 6,9320500 0 61932,500 5.72 Fund Total Revenue: 61849,180 6,557,200 61728,393 7,0593000 61932,500 0 6,932,500 5.72 Fund Balance: 27273,324 0 0 1,877,100 0 0 0 N/A GovMeX 4 4/3I2023 Fund Detail Proforma Summary Grouped By Account Minor Collier County Government Fiscal Year 2024 FY 2022 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change Expenditures 500 Personal Services 600 Operating Expense 610 Indirect Cost Reimburs 700 Capital Outlay 855f Trans to Property Appraiser 855h Trans to Tax Collector 912w Trans to 322 Pet Bay Irr and Land 991 Reserve for Contingencies 991d Reserve for Salary Adj. 993 Reserve for Capital 998 Reserve for Cash Flow Revenues 306 Ad Valorem Taxes 307 Delinquent Ad Valorem Taxes 360 Miscellaneous Revenues 361 Interest/Misc 392h Trans frm Tax Collector 499u Carry Forward 499z Less 5% Required By Law 778 Pelican Bay Light 106,466 113,600 113,600 117,500 132,700 0 132,700 16.81 182,599 214,300 214,300 191,300 220,900 0 2203900 3.08 9,800 91400 9,400 9,400 10,500 0 10,500 11.70 0 500 151,767 151,300 500 0 500 0.00 0 81000 81000 8,000 82000 0 8,000 0.00 12,755 175900 17,900 175900 17,900 0 17,900 0.00 440,000 397,700 397,700 397,700 442,100 0 442,100 11.16 0 11,400 11,400 0 11,400 0 117400 0.00 0 11,400 112400 0 0 0 0 -100.00 0 50,000 502000 0 36,400 0 36,400 -27.20 0 40,000 40,000 0 40,000 0 402000 0.00 633,124 743,400 743,400 706,300 786,100 0 786,100 5.74 21484 0 0 0 0 0 0 N/A 18,627 18,900 18,900 0 20,400 0 20,400 7.94 3,714 15500 1,500 0 3,600 0 3,600 140.00 5,023 0 0 0 0 0 0 N/A 425,000 148,700 299,967 336,400 149,600 0 149,600 0.61 0 -38,300 -38,300 0 -39,300 0 -39,300 2.61 Fund Total Expenditure: 751,640 874,200 1,025,467 893,100 920,400 0 920,400 5.28 Fund Total Revenue: 1,087,972 874,200 1,0252467 170423700 920J400 0 9202400 5.28 Fund Balance: 3362333 0 0 149,600 0 0 0 N/A GovMax 1 4/3/2023 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2024 FY 2022 FY 2023 FY 2023 FY 2023 Actual Adopted Amended Forecast FY 2024 FY 2024 Current Expanded FY 2024 Budget Adopted % Change 778 Pelican Bay Light 500 Personal Services Expenditures 182701-778 512100 Regular Salaries 69,540 74,298 74,298 783400 82,623 0 82,623 11.20 182701-778 512500 Auto Use Benefit 258 0 0 0 0 0 0 N/A 182701-778 512600 ER 457 Deferred 499 530 530 1,600 796 0 796 50.19 182701-778 514100 Overtime 51848 7,100 7,100 6,300 71000 0 71000 -1.41 182701-778 515000 Vacation Sell Back 0 179 179 0 209 0 209 16.76 182701-778 519100 Reserve For Salary 0 79 79 0 40559 0 4,559 51670,89 182701-778 519200 Merit 0 0 0 0 11308 0 1,308 N/A 182701-778 521100 Social Security 53440 51738 53738 53700 61845 0 63845 19.29 182701-778 522100 Retirement Regular 8,432 9,056 9,056 83900 11,904 0 113904 31,45 182701-778 523150 Health Insurance 132886 13,886 130886 13,900 14,586 0 14,586 5,04 182701-778 523152 Dental Insurance 530 556 556 600 556 0 556 0,00 182701-778 523153 Short Term 106 132 132 100 132 0 132 0.00 182701-778 523154 Long Term 212 238 238 200 238 0 238 0.00 182701-778 523160 Life Insurance 191 208 208 200 244 0 244 17.31 182701-778 524100 Workers 1,800 11600 1,600 11600 11700 0 1,700 6,25 182701-778 528200 Allowance Vehicle -258 0 0 0 0 0 0 N/A Expenditures 106,486 113,600 1133600 117,500 132,700 0 132,700 16.81 600 Operating Expense Expenditures 182701-778 631400 Engineering Fees 0 41500 4,500 0 41500 0 41500 0.00 182701-778 634210 Info Tech 500 0 0 0 0 0 0 N/A 182701-778 634805 Emergency Maint 30900 2,500 21500 0 21500 0 2,500 0,00 182701-778 634999 Other Contractual 45,065 453000 45,000 45,000 45,000 0 45,000 0.00 182701-778 639964 Storage Contractor 222 200 200 300 300 0 300 50.00 182701-778 639967 Temporary Labor 373607 44,000 44,000 44,000 44,000 0 44,000 0,00 182701-778 641150 Telephone Beepers 360 400 400 400 400 0 400 0,00 182701-778 641400 Telephone Direct 176 0 0 0 0 0 0 N/A 182701-778 641950 Postage Freight 80 400 400 300 400 0 400 0,00 182701-778 643100 Electricity 29,571 26,000 26,000 260500 27,000 0 27,000 3,85 182701-778 644100 Rent Buildings 433558 453000 45,000 48,700 50,900 0 50,900 13.11 182701-778 644600 Rent Equipment 21056 2,500 2,500 11800 21000 0 23000 -20.00 182701-778 645100 Insurance General 10400 1,1o0 1,100 1,100 11100 0 11100 0,00 182701-778 645260 Auto Insurance 900 900 900 900 900 0 900 0,00 182701-778 646430 Fleet Maint ISF 41392 4,500 4,500 43500 6,200 0 61200 37.78 182701-778 646440 Fleet Maint ISF 2,798 1,100 10100 12100 3,700 0 3,700 236.36 182701-778 646445 Fleet Non Malnt 390 4,900 4,900 4,900 800 0 800 -83,67 182701-778 646970 Other Equip Repair 0 500 500 0 500 0 500 0.00 182701-778 651110 Office Supplies -1,250 800 800 0 800 0 800 0.00 182701-778 652140 Personal Safety 1,410 21500 20500 21300 2,500 0 21500 0,00 182701-778 652490 Fuel and Lubricants 323 500 500 0 400 0 400 -20.00 182701-778 652990 Other Operating 31184 4,000 4,000 31500 4,000 0 41000 0,00 182701-778 652992 Electrical 30592 103000 10,000 0 10,000 0 10,000 0.00 182701-778 652993 Light Bulbs Ballast 2,365 133000 13,000 63000 13,000 0 13,000 0,00 Expenditures 182,599 2143300 214,300 191,300 220,900 0 2203900 3.08 610 Indirect Cost Reimburs Expenditures 182701-778 634970 Indirect Cost 90800 9,400 91400 93400 10,500 0 10,500 11,70 Expenditures 91800 9,400 93400 %400 100500 0 103500 11,70 700 Capital Outlay Expenditures 182701-778 764110 Autos And Trucks 0 0 151,267 151,300 0 0 0 N/A 182701-778 764900 Data Processing 0 500 500 0 500 0 500 0.00 Expenditures 0 500 151,767 1513300 500 0 500 0.05 855f Trans to Property Appraiser Expenditures 959010-778 930600 Budget Transfers 0 81000 83000 8,000 81000 0 81000 0.00 Expenditures 0 81000 8,000 82000 81000 0 8,000 0.00 855h Trans to Tax Collector Expenditures 959010-778 930700 Budget Transfers 12,755 17,900 17,900 17,900 17,900 0 17,900 0.00 Expenditures 12,755 17,900 17,900 173900 173900 0 17,900 0.00 912w Trans to 322 Pei Bay Irr and Land Expenditures 929010-778 913041 Transfer to 440,000 397,700 397,700 397,700 442,100 0 442,100 11.16 Expenditures 4403000 397,700 3973700 397,700 442,100 0 442,100 11.16 GovMax 1 4/3/2023 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2024 FY 2022 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 778 Pelican Bay Light 991 Reserve for Contingencies Expenditures 919010-778 991000 Reserve For 0 11,400 113400 0 11,400 0 113400 0,00 Expenditures 0 11,400 11,400 0 11,400 0 11,400 0.00 991 d Reserve for Salary Adj. Expenditures 919010-778 992150 Reserve for Salary 0 11,400 11,400 0 0 0 0 -100.00 Expenditures 0 11,400 11,400 0 0 0 0 -100.00 993 Reserve for Capital Expenditures 919010-778 993000 Reserve For 0 50,000 500000 0 36,400 0 36,400 -27.20 Expenditures 0 503000 503000 0 36,400 0 36,400 -27.20 998 Reserve for Cash Flow Expenditures 919010-778 998000 Reserve For Cash 0 403000 40,000 0 40,000 0 40,000 0.00 Expenditures 0 40,000 40,000 0 40,000 0 40,000 0.00 306 Ad Valorem Taxes Revenues 182700-778 311100 Current Ad Valorem 633,124 0 0 0 0 0 0 N/A 182701-778 311100 Current Ad Valorem 0 743,400 743,400 706,300 786,100 0 786,100 5,74 Revenues 633,124 743,400 743,400 706,300 786,100 0 7863100 5,74 307 Delinquent Ad Valorem Taxes Revenues 182700-778 311200 Delinquent Ad 21484 0 0 0 0 0 0 N/A Revenues 21484 0 0 0 0 0 0 N/A 360 Miscellaneous Revenues Revenues 182701-778 362190 Lease Facilities 7,138 0 0 0 0 0 0 N/A 182701-778 362192 Lease Facilities 11,490 180900 18,900 0 20,400 0 20,400 7.94 Revenues 18,627 180900 18,900 0 20,400 0 20,400 7.94 361 Interest/Misc Revenues 182700-778 361320 Interest Tax 47 0 0 0 0 0 0 N/A 989010-778 3611701nterest SBA 929 0 0 0 0 0 0 N/A 989010-778 361180 Investment Interest 2,737 1,500 12500 0 30600 0 30600 140,00 Revenues 3,714 10500 10500 0 32600 0 3,600 140,00 392h Trans frm Tax Collector Revenues 959010-778 486700 Transfer From Tax 51023 0 0 0 0 0 0 N/A Revenues 5,023 0 0 0 0 0 0 N/A 499u Carry Forward Revenues 919010-778 489200 Carryfonvard 425,000 148,700 1483700 336,400 149,600 0 149,600 0.61 919010-778 489201 Carry Forward Of 0 0 151,267 0 0 0 0 N/A Revenues 425,000 148,700 299,967 336,400 149,600 0 149,600 0.61 499z Less 5 % Required By Law Revenues 919010-778 489900 Less 5% Required 0 -38,300 -38,300 0 -39,300 0 -39,300 2.61 Revenues 0 -38,300 -38,300 0 -393300 0 -39,300 2.61 Fund Total Expenditure: 7510640 874,200 1,025,467 893,100 920,400 0 920,400 5.28 Fund Total Revenue: 1,087,972 874,200 1,025,467 1,042,700 920,400 0 920,400 5.28 Fund Balance: 336,333 0 0 149,600 0 0 0 N/A GovMax 2 4/3/2023 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2024 FY 2022 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 32w Clam Bay Restoration 600 Operating Expense Expenditures 183800-320 631400 Engineering Fees 89,023 35,000 1103353 110,400 353000 0 35,000 0,00 183800-320 634999 Other Contractual 69,670 120,000 171,611 171,600 120,000 0 120,000 0.00 183800-320 646319 Tree Trimming 0 0 40,900 40,900 0 0 0 N/A 183800-320 652990 Other Operating 0 0 41553 41600 0 0 0 N/A Expenditures 1583694 155,000 327,417 327.500 155,000 0 155,000 0.00 855f Trans to Property Appraiser Expenditures 959010-320 930600 Budget Transfers 2,966 6,800 61800 51900 51900 0 51900 -13,24 Expenditures 2,966 6,800 6,800 5,900 5,900 0 5,900 -13,24 855h Trans to Tax Collector Expenditures 959010-320 930700 Budget Transfers 41471 9,600 92600 8,700 8,700 0 8,700 -9.38 Expenditures 41471 9,600 91600 81700 83700 0 81700 -9.38 904i Trans to 109 PB MSTUBU Fd Expenditures 929010-320 911007 Transfer to 34,100 34,100 34,100 34,100 34,100 0 34,100 0,00 Expenditures 34,100 34,100 34,100 347100 34,100 0 343100 0.00 325a Special Assessments Revenues 183800-320 325100 Special 0 203,100 203,100 0 0 0 0 -100.00 183805-320 325100 Special 223,552 0 0 1920900 195,300 0 195,300 N/A Revenues 223,552 203,100 2033100 192,900 195,300 0 195,300 -3.84 361 Interest/Misc Revenues 183805-320 361320 Interest Tax 14 0 0 0 0 0 0 N/A 989010-320 361170 Interest SBA 463 0 0 0 0 0 0 N/A 989010-320 361180 Investment Interest 1,051 100 100 4,500 200 0 200 100.00 Revenues 11528 100 100 41500 200 0 200 100.00 392h Trans firm Tax Collector Revenues 959010-320 486700 Transfer From Tax 1,810 0 0 0 0 0 0 N/A Revenues 11810 0 0 0 0 0 0 N/A 499u Carry Forward Revenues 919010-320 489200 Carryforward 170,100 12,600 12,600 1963800 18,000 0 18,000 42.86 919010-320 489201 Carry Forward Of 0 0 172,417 0 0 0 0 N/A Revenues 170,100 12,600 185,017 196,800 18,000 0 18,000 42.89 499z Less 5% Required By Law Revenues 919010-320 489900 Less 5% Required 0 -100300 -103300 0 -90800 0 -91800 -4.85 Revenues 0 -10,300 -10,300 0 -93800 0 -91800 -4.85 Fund Total Expenditure: 200,231 205,500 377,917 376,200 203,700 0 203,700 -0.88 Fund Total Revenue: 396,989 205,500 377,917 394,200 203,700 0 203,700 -0.88 Fund Balance: 196,758 0 0 183000 0 0 0 N/A GovMax 1 4l3/2023 i 0 o i 0 .@ o C o m o 0 E _ N Y m CPO 'O ca N 6 @ N J a) elf flJ O Q (T a) Ol Y _ U v C @ w c m "° IW Nlcu rn "Co i@ _, CO oo o-o-000000 O o C 0 0 0 0 0 N N FL C oLOo o (00 0 0 EA Ui V Cfi (O 60 6a M (O N a N a ° o -- U o 0 0 0 Cl 0 0 0 o 0 N O 66 ( 0 C O O Cl O O 40 C •) 0 0 o Co O } oa too o� lL C M a LL EA C a) E -_ — N C U C C E @ O N C 6 O LU `O ` CL E o o 0 w a> E �@ E m C Y W NI Ni @NN@Cj>U)N`O > Mi N N 3.@mfn N m O_ w Dcc@ C cn =@E U m °gym O �cna cj�YOapi o p p� 0 3 p 0 co a`I cn n mcn ocncom0) a)m.6 mm 0-m N� mmm0. n.dNCL M N G7 (OM COMCO.-NNM M (0 0 N Cn r O N N N O N �y 0 0 0 0 0 0 0 0 m (O M M (O (O (O (O M (O (n lL 0