Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
PBSD BC Agenda 05/04/2022
PELICAN BAY SERVICES DIVISION Municipal Services Taxing and Benefit Unit NOTICE OF PUBLIC MEETING WEDNESDAY, MAY 45 2022 THE BUDGET COMMITTEE OF THE PELICAN BAY SERVICES DIVISION WILL MEET ON WEDNESDAY, MAY 4 AT 1: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 4/08/2022 meeting minutes 5. Audience Comments 6. Final Budget Review 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 APRIL 8, 2022 The Budget Committee of the Pelican Bay Services Division met on Friday, April 8 at 9:00 a.m. at the Truist Building, 801 Laurel Oak Drive, Suite 102, Naples, Florida. In attendance were: Budget Committee Michael Fogg, Chairman Pelican Bay Services Division Staff Neil Dorrill, Administrator Chad Coleman, Operations Manager Darren Duprey, Assoc. Project Mgr. Also Present Dave Mangan Denise McLaughlin Karin Herrmann, Operations Analyst Lisa Jacob, Project Manager Barbara Shea, Administrative Assistant Michael Rodburg, PBSD Board APPROVED AGENDA (AS PRESENTED) 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 ROLL CALL All members were present and a quorum was established. IMs. McLaughlin motioned, Mr. Mangan seconded to approve the agenda as I presented. The motion carried unanimously. Pelican Bay Services Division Budget Committee Meeting April 8, 2022 Ms. McLaughlin motioned, Mr. Fogg seconded to approve the 10/11/2021 meeting minutes as presented. The motion carried unanimously. AUDIENCE COMMENTS Ms. Susan O'Brien questioned whether our two new PBSD vehicles will be electric, and if not, what the reason is. She commented that it appears that there are no reductions in any operating expenses in Fund 109 in the proposed FY2023 budget. She suggested methods to reduce these costs including (1) reducing or eliminating the eight hours of guaranteed overtime provided to all County and temporary field workers each week, (2) returning to using temporary labor seasonally instead of annually, (3) privatizing specific landscape maintenance tasks, and (4) reducing or eliminating the two 45-minute breaks taken by field workers. She provided a summary of her cornments on the proposed FY2023 budget to the committee, which was added to the record. FINANCIAL REVIEW MARCH FINANCIALS Mr. Fogg provided a review of the 03/31/2022 PBSD financials. 94% of the FY2022 assessments have been collected. He noted that the employee salary increases, effective 01/01/2022, have had a nominal effect on our financials, as our head count has been a few short. Mr. Coleman commented that we currently have two open County field worker positions and two open temporary positions. Ms. McLaughlin questioned what the life of our light fixtures are. Mr. Fogg commented that the Landscape & Safety Committee will be looking at that as well as where additional streetlight poles may be needed. FUND 109 Mr. Fogg reviewed the line items contained within the proposed FY2023 Fund 109 budget. Highlights of committee discussion included the following. • Mr. Fogg commented on the challenge associated with the "catch up" increase in employee salaries on 01/01/2022 and the adverse effects of inflation, including an additional increase to employee salaries on 10/01/2022. • The proposed draft budget, as included in the agenda packet, provides fora 6.9%increase in the PBSD annual assessment. • Mr. Fogg commented that the anticipated FY2022 carryforward, estimated at $400,000, is significantly lower than last year's $900,000 earryforward. • Mr. Fogg commented that to fund the FY2023 operating budget, we need to reduce the capital budget by $350,000. • Mr. Coleman commented that the County HR Dept. has not yet provided budget guidance on the amount/percentage of the Oct. I employee wage increases. • Mr. Coleman commented that OMB budget guidance for ad valorem tax revenue is an increase of 3.5%. He noted that if the actual increase is higher, then the surplus will go to our capital fund. • Mr. Fogg commented that in light of the current high inflation rate, it may be difficult to budget for items such as fuel and fertilizer. 2 Pelican Bay Services Division Budget Committee Meeting April 8, 2022 • Mr. Fogg suggested that the L&S Committee looks at any areas in our landscaping work which could be bid out separately, in order to reduce our salary expense. Mr. Coleman commented that the cost of "contracted out" work has increased at least as much as our salary expenses. Mr. Mangan noted that he is currently paying $43/hour for day labor to perform golf course field work. • The committee discussed our two "flood control" line items. Mr. Coleman commented that a golf course (Club Pelican Bay) drainage pipe maintenance project is included in this line item. Mr. Fogg and Mr. Mangan suggested that staff re -looks at completing this project in FY2022, before prices rise next year. Mr. Coleman will contact Mr. Bob Bittner, Director of Golf Course Operations at the Club Pelican Bay, to discuss whether he would be agreeable to allowing us to complete this project prior to Oct. 1. Mr. Coleman noted that the second "flood control" line item is for our irrigation water expense. Mr. Dorrill suggested that staff reviews the County's chart of accounts to better classify these expenses which are currently captured under the title "flood control." • Mr. Coleman commented that the other contractual services line includes the monthly payments to DMG for administrative services, per the contract. He noted that the contract allows for an annual "COLA" increase to DMG, which has been tied to the COLA received by County employees in the past. Mr. Dorrill will review his contract to determine what his COLA would be if County employees receive a pay increase which is not specifically identified as a COLA increase. • Mr. Coleman commented on several expenses included in other contractual services, and noted that he will review the FY2022 forecast for each of these expenses. His forecast may need to be fine-tuned. • Mr. Fogg and Mr. Rodburg suggested that we should combine the two cost centers under Fund 109 into one cost center. This would simplify the budget process. Mr. Fogg noted that there appears to be no purpose in having two cost centers instead of one. Mr. Coleman responded that he will discuss this issue with the County's OMB Dept. and the Clerk of Courts. • Mr. Coleman commented that we are now using slow -release fertilizer, and therefore he has reduced the FY2023 fertilizer budget from the FY2022 budget. • Mr. Coleman commented that he has increased the budget for our irrigation system repairs as a result of our Phase 2 Sidewalk Replacement Project in FY2023. • The "maintenance" line item shows an increase in the FY2022 forecast and the FY2023 budget from the FY2022 budget. Mr. Coleman will review this line item to determine the causes of the increases. • The "landscape" line item shows a significant decrease in the FY2022 forecast and the FY2023 budget from the FY2022 budget. Mr. Coleman will take a second look at this. • FY2023 Fleet expense line items show a significant increase in FY2023. Mr. Coleman commented that these increases are a result of increases in the price of fuel and parts, and noted that the Fleet Dept. provides us with these budget arnounts. • Mr. Coleman commented that our budgets do not include any reserves for future fleet purchases. Mr. Dorrill directed Mr. Coleman to ask the Fleet Dept. if they could prepare a 3-year PBSD vehicle replacement schedule for us. Pelican Bay Services Division Budget Committee Meeting April 8, 2022 • Mr. Coleman commented that the Fleet Dept. has indicated that they have no plans for electric vehicles at this time. He also noted that currently there is not a cost/benefit advantage to purchasing electric -powered equipment such as mowers and blowers. • Mr. Fogg commented that our indirect costs (County departmental costs allocated to us) have increased by 10% in the FY2023 budget. • Mr. Coleman commented that we do have the ability to reduce some of our reserves. FUND 778 Mr. Fogg briefly reviewed Fund 778 line items and noted that budgeted operating expenses will increase by 13% in FY2023. Mr. Fogg noted that approximately $370,000 from this fund will be transferred to our Capital Fund 322. FUND 320 Mr. Coleman commented that we are budgeting $120,000 in operating expenses for Fund 320 in FY2023, which is a reduction from the FY2022 budget. We will have significant cairyforward funds in this fund in FY2023, and we also have $150,000 in Fund 111 for Clam Bay expenses. Mr. Coleman reported that the County has grant money to fund scaevola removal, which it will use for a project to remove these exotics in the areas of its most recent beach renourishment project. Scaevola will not be removed on private property. The PBSD will have the option to participate in their scaevola removal project. Mr. Coleman commented that the PBSD is not obligated to participate in the County's project. Mr. Fogg suggested that the Clam Bay Committee follows up on this issue. FUND 322 Mr. Fogg reviewed the proposed FY2023 budget for all of our capital projects, which are all fully funded except for our Phase 2 Sidewalk Replacement Project. We will obtain $6.5 million in commercial paper funding (obtained through the County) for our Sidewalk Project. Mr. Fogg noted that we are waiting on clarification of the method of drawing down funds (from our commercial paper line of credit) as needed. He noted that we hope to eventually convert our commercial paper financing into long-term financing. Mr. Dorrill commented that he confirmed with the Clerk of Courts, that the commercial paper loan functions as a line of credit, and that we can draw down funds as needed. Mr. Fogg commented that we may or may not have to make loan repayments in FY2023. COMMITTEE COMMENTS ON THE LEVEL OF THE FY2023 ASSESSMENT Mr. Fogg commented that the proposed FY2023 budget included in the agenda packet provides fora 6.90/^ increase in the assessment. He suggested that in order to cover for inflation, he would be more comfortable with an increase of up to 8.5%. Mr. Fogg noted that in our 10-year forecast, we will need to accrue funds for future projects. We will also need additional funds in future years, when the County annual contributions of $500,000 come to an end (in eight years). The committee agreed that the FY2023 assessment level needs to be increased by more than 6.9%. Mr. Fogg concluded that this issue needs further discussion by the full board. Ms. McLaughlin suggested that we prepare talking points to explain the reasons for the FY2023 assessment increase to the community. She also suggested a list of bullet points to Pelican Bay Services Division Budget Committee Meeting April 8, 2022 summarize the reasons for the PY2023 assessment increase for the budget discussion at the April PBSD board meeting. The meeting was adjourned at 11:00 a.m. Michael Pogg, Chairman Minutes approved L� as presented OR L� as amended ON � � date F�genda item #6 Page 1 of 14 Agenda item #6 Page 2 of 14 �_item « ge ,m, ral=.a §Bk( 000 § ) e PIIf \ \)§ IIIIIk ; )] / > c s t;e® j&6 \ & 2§§&eCK® !« � f ! " ! ; ! ) $ ` vi to 2 k0 ) ®! )k\§) \ \ ) )2 * r.)!2))j)` k!2 ¥ § mt ,||]! 2 .,a&aa a S ) ��(|! . )|.n;w !!� ) § ) 2 2\ fee;§;m2 , !! o , Agenda item #6 Page 4 of 14 Fund Detail Proforma Summary Grouped my 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 600 Personal Services 11978,941 21049,000 2104%000 2,093,400 2,241,600 0 21241,600 9.40 600 Operating Expense 20029,435 2,163,900 2,179,361 2,147,000 2,286,500 0 21286,500 5,67 610Indirect Cost Relmburs 121,400 1361100 136,100 136,100 160,000 0 1509000 10,21 700 Capital Outlay 1551868 177,500 177,500 172,000 98,600 0 98,600 44.61 865f Trans to Property Appraiser 60067 85,000 850000 86,000 80,o00 0 80,000 -5.88 866h Trans to Tax Collector 810604 130,700 1301700 130,700 120,000 0 120,000 -8,19 912a Trans to 301 Cc Wide Cap Fd 0 80700 8,700 80700 10,000 0 102000 14,94 916h Trans to 408 Water/Sewer Fd 23,100 21,000 21,000 21,000 17,600 0 17,600 -16,19 920f Trans to 6061T Capital 0 0 0 0 37,100 0 370100 N/A 991 Reserve for Contingencies 0 159,000 159,0o0 0 160,000 0 160,000 0,63 991d Reserve for Salary Adl, 0 0 0 0 162,600 0 162,500 N/A 993 Reserve for Capital 0 111,200 1110200 0 110,000 0 110,000 -1.08 996e Reserve for Disaster Relief 0 700,000 700,000 0 700,000 0 700,000 0.00 996 Reserve for Cash Flow 0 476,000 476,000 0 475,000 0 475,000 0.00 999 Reserve for Altdllon 0 430900 -43,900 0 -39,300 0 -39,300 -10.48 Revenues 325a Special Assessments 4,075,210 319719000 3,971,000 31813,100 4,9021800 0 4,902,800 23A7 360 Miscellaneous Revenues 102*600 35,800 35,800 350800 36,800 0 36,800 2,79 3611nterest/Mlso 17,785 23,100 23,100 161000 20,000 0 20,000 -13,42 392d Trans fan Property Appraiser 73,018 - 0 0 0 0 0 0 N/A 392h Trans fan Tax Collector 32,667 0 0 0 0 0 0 N/A 413u Trans fm 320 Clam Bay Cap Fd 34,100 34,100 34,100 34,100 34,100 0 34,100 0.00 499u Carry Forward 21816,900 21311,000 2,3261461 2,7661900 4,661,000 0 1,861,000 -19.47 499z Less 5% Required By Law 0 -2010800 -2011800 0 -246,200 0 -246o200 21.61 Fund Total Expenditure: 4,395,305 6,173,200 61188,661 4,793,900 61609,600 0 6,609,500 7.07 Fund Total Revenue: 7,152,179 61173,200 6,188,661 6,6541900 61609*500 0 6,609,500 7.07 Fund Balance: 2,756,874 0 0 1,8613000 0 0 0 N/A 320 Clam Bay Restoration Expenditures 600 Operating Expense 179,029 178,600 331,111 331,200 155,000 0 166,000 -13.21 855f Trans to Property Appraiser 0 8,900 80900 80900 60800 0 61800 -23.60 855h Trans to Tax Collector 30591 130100 13,100 13,100 92600 0 93600 -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,600 238,500 229,000 203,100 0 203,100 -14.84 3611nterest/Misc 11060 100 100 800 100 0 100 0.00 392d Trans frm Property Appraiser 21980 0 0 0 0 0 0 N/A 392h Trans frm Tax Collector 1,337 0 0 0 0 0 0 N/A 499u Carry Forward 201,900 ajoli 160,610 1700100 120600 0 12,600 55,56 499z Less 5% Required By Law 0 -12,000 -121000 0 -10,300 0 -10,300 44.17 Fund Total Expenditure: 216,720 2349700 387,211 387,300 205,600 0 205,600 -12A4 Fund Total Revenue: 386,841 234,700 387,210 399,900 205,500 0 205,500 -12A4 Fund Balance: 170,121 0 -1 12,600 0 0 0 N/A OovMax 1 4129/2022 Agenus Item #6 Page 5 of 14 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 322 Pelican Bay Irr & Lndscp Expenditures 600 Operating Expense 740,408 2,688,400 4,382,225 5,068,800 1,550,000 0 115500000 -40,12 700 Capital Outlay 413,165 11631,200 4,6430349 4/6430300 370,000 0 370,000 -75.84 8561' Trans to Property Appraiser 0 3%700 309700 30,700 57,400 0 57,400 86,97 855h Trans to Tax Collector 279103 57,400 67,400 57,400 340000 0 34,000 40.77 911y Trans to 299 Debt Sow Fd 0 2004000 200,000 63,500 209$00 0 209,300 4,66 992a Reserve for Future Debt Service 0 75,000 75,000 0 0 0 0 -100.00 993 Reserve for Capital 0 451,600 451,600 0 490,200 0 490,200 8.55 996e Reserve for Disaster Relief 0 160,000 160,000 0 0 0 0 -100.00 Revenues 325a Special Assessments 11355,165 11914,700 11914,700 1,8381100 1,682,600 0 11582,600 -17.34 360 Miscellaneous Revenues 689,212 40D,000 0 0 0 0 0 -100,00 3611nterest/Mlsc 22,896 9,50o 9,500 26,200 10,000 0 10,000 5,26 392d Trans frm Property Appraiser 113808 0 0 0 0 0 0 N/A 392h Trans frm Tax Collector 52311 0 0 0 0 0 0 N/A 405k Trans fm 111 Unlncorp Gen Fd 620,000 520,000 620*000 620,000 620,000 0 620,000 0.00 432c Trans fm 778 Pal Bay Lighting 2,061,800 4403000 440,000 440,000 370,000 0 370,000 -16,91 499u Carry Forward 3*716,700 1,926,400 7,1323374 7,2471400 308,000 0 308,000 -84,01 499z Less 5% Required By Law 0 A 160300 -116,300 0 -799700 0 -79,700 -31.47 Fund Total Expenditure: 11180,676 51094,300 91900,274 9,763,700 2,710,900 0 21710,900 -46.79 - Fund Total Revenue: 81382,891 5,0941300 91900,274 10,071,700 21710,900 0 2,710,900 46,79 Fund Balance: 7,2021215 0 0 308,000 0 0 0 N/A 778 Pelican Bay Light Expenditures 500 Personal Services 87,287 105,600 1051600 107,300 113,600 0 1130600 7.68 600 Operating Expense 143,359 184,800 190,730 193,600 214,300 0 214,300 15,96 610 Indirect Cost Relmburs 10,000 9,800 91800 91800 91400 0 9,400 4.08 700 Capital Outlay 0 156,500 156,600 1621000 500 0 500 -99,68 855f Trans to Property Appraiser 0 12,000 12,000 12,000 101000 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 Pal Bay Irr and Land 21061,800 440,000 440,000 440,000 370,000 0 37%000 -16,91 991 Reserve for Contingencies 0 11,400 11,400 0 11,400 0 110400 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 629,977 660,900 660,900 634,500 68%600 0 683,600 3,42 307 Delinquent Ad Valorem Taxes 2,270 0 0 0 0 0 0 N/A 360 Miscellaneous Revenues 0 18,400 18,400 18,400 18,900 0 18,900 2,72 3611nterest/Misc 7,011 %600 3,600 21400 32600 0 31600 0.00 392h Trans frm Tax Collector 4,446 0 0 0 0 0 0 N/A 499u Carry Forward 21096,500 364,300 370,230 4250000 1480700 0 148,700 -59.18 499z Less 5%Required By Law 0 -340100 -341100 0 -34,100 0 -341100 0,00 Fund Total Expenditure: 2,315,t34 110131100 1,01%030 931,600 820,600 0 820,600 -19.00 Fund Total Revenue: 2,74%204 11013,100 1,019,030 1,080,300 820,60o 0 820,600 A9.00 Fund Balance: 426,070 0 0 148,700 0 0 0 N/A GovMax 2 412912022 Agenda item #6 Page 6 of 14 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 Expenditures 182601-109 512100 Regular Salaries 731 0 0 0 0 0 0 N/A 182601-109 521100 Social Security 52 0 0 0 0 0 0 N/A 182601-109 622100 Retirement Regular 73 0 0 0 0 0 o N/A 182602.109 512100 Regular Salaries 229,698 235,811 235,811 2161500 264$51 0 264,351 12,10 182602-109 612500 Auto Use Benefit 152 0 0 0 0 0 0 N/A 182602-109 612600 ER 467 Deferred 11297 11630 10530 2,900 1,530 0 11630 0.00 182602-109 514100 Overtime 2%248 20,200 20,200 17,600 21,000 0 21,000 3,96 182602-109 615000 Vacation Sell Back 0 11562 11552 1,600 636 0 635 -59,09 182602.109 619100 Reserve For Salary 0 61217 6,217 0 91 0 91 -98,28 182602A09 521100 Social Security 17,835 18,669 18,669 15,000 20,389 0 20,389 9,21 182602-109 622100 Retirement Regular 26,691 27,088 27,088 22,400 32,221 0 32,221 18.95 182602-109 523150 Health Insurance 50,566 50,566 60,566 50,600 60,666 0 50,566 0.00 182602-109 523162 Dental Insurance 11930 13930 1,930 12900 21026 0 21026 4,97 182602-109 823153 Shod Term 386 386 386 400 482 0 482 24,87 182602-109 523154 Lang Term 772 772 772 800 868 0 868 12,44 182602A09 523160 Life Insurance 643 679 679 700 741 0 741 9.13 162602A09 624100 Workers 6,100 61500 60500 52600 69600 0 6,600 20.00 182602-109 528200 Allowance Vehicle -162 0 0 0 0 0 0 N/A 182900-109 512100 Regular Salaries 662 0 0 0 0 0 0 N/A 182900-109 521100 Social Security 46 0 0 0 0 0 0 N/A 182900.109 622100 Retirement Regular 66 0 0 0 0 0 0 N/A 1182901A09 612100 Regular Salaries 873,097 894,887 894,887 943,400 11036,106 0 11036,106 15,78 182901-109 512600 Auto Use Benefit 478 0 0 0 0 0 0 NIA 182901.109 512600 ER 467 Deferred 70313 7,840 71840 119600 70440 0 71440 -5.10 182901-109 514100 Overtime 193,206 207,600 207,500 2150000 215,000 0 215,000 3,61 182901-109 515000 Vacation Sell Back 0 2,552 21652 2,600 2,491 0 21491 -2.39 182901A09 518100 Termination Pay 143 0 0 0 0 0 0 N/A 182901A09 619100 Reserve For Salary 0 26,958 26,958 0 35 0 35 -99.87 182901A09 521100 Social Security 76,668 71,310 71,310 85,000 80,016 0 800018 12,21 182901.109 522100 Retirement Regular 113,972 105,752 1050752 137,800 133,028 0 133,028 25,79 182901-109 523150 Health Insurance 289,248 289,248 289,248 289,200 289,248 0 289,248 0.00 182901A09 623162 Dental Insurance 11,040 119040 11,040 119000 11,593 0 112593 5,01 182901409 523153 Short Term 21208 2,208 21208 21200 2,761 0 2$761 25,05 182901-109 623154 Long Term 41416 40416 4,416 41400 40969 0 4,969 12,52 182901-109 523160 Life Insurance 21536 21589 2,689 2,600 2,911 0 2,911 12,44 182901-109 624100 Workers 48,300 52,800 520800 52,800 64,600 0 540500 3.22 182901-109 528200 Allowance Vehicle -478 0 0 0 0 0 0 N/A Expenditures 1,978,941 2,049,000 2,0491000 2,093,400 2,241,600 0 2,24 ,800 9.40 600 Operating Expense se Expenditures 182602409 631400 Engineering Fees 27,939 300000 30,000 17,000 17,000 0 17,000 -43.33 182602A09 634207 IT Capital Allocation 22,000 43800 4,800 4,800 0 0 0 -100.00 182602-109 634210 Info Tech 61300 81700 8,700 81700 91300 0 90300 6.90 182602A09 634211 IT Billing Hours 400 600 500 Soo 800 0 800 60,00 182602-109 634251 Flood Control 2160264 200,000 200,000 160,000 240,000 0 240,000 20,00 182602-109 634605 Emergency Malnt 498 0 0 600 600 0 600 N/A 182602-109 6349801nterdept Payment 120125 0 0 0 0 0 0 N/A 182602-109 634999 Other Contractual 52,644 64,000 69,476 649000 72,000 0 721000 12,60 182602A09 639967 Temporary Labor 71,104 870000 87,000 77,000 87,000 0 87,000 0.00 182602A09 641150 Telephone Beepers 360 400 400 360 400 0 400 0.o0 182602-109 641400 Telephone Direct 999 1,200 11200 360 0 0 0 A00.00 182602.109 641700 Cellular Telephone 31900 4,200 4,200 31000 3,000 0 30000 -28.57 182602-109 641960 Postage Freight 31214 300 300 100 200 0 200 -33,33 182602-109 643300 Trash and Garbage 10,997 14,000 14,000 14,000 14,000 0 14,000 0.00 182602A09 644100 Rent Buildings 13,693 18,000 181000 44,000 46,000 0 45,000 150.00 182602-109 644600 Rent Equipment 1,122 1,600 11500 21000 11800 0 10800 20,00 182602-109 645100 Insurance General 6,000 61100 6,100 51100 4$00 0 4,600 A1,76 182602-109 646260 Auto Insurance 1,400 11400 1,400 19400 1,400 0 11400 0,00 182602A09 646180 Building R And M 255 0 0 0 0 0 0 N/A 182602-109 646311 Sprinkler System 0 0 0 90 0 0 0 N/A 182602-109 646319 Tree Trimming 4%000 61,000 65,400 640300 610000 0 61,000 19,61 182602-109 646320 Landscape 61902 51000 51000 6,o00 69000 0 50000 0.00 182602-109 646430 Fleet Malnt ISF 31,128 81600 80600 8,600 16,600 0 15,600 81.40 182602-109 646440 Fleet Malnt ISF 6,425 2,600 2,600 21500 6,700 0 6,700 168.00 182602A09 646445 Fleet Non Mart 783 10200 1,200 11900 2,600 0 2,600 108,33 GovMsx 1 4129/202 Agenda item #6 Page 7 of 14 Account Minor Fund Line Item Detaii 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 10a Pelican Bay Beautification MSTBU 6D0 Operating Expense Expenditures 182602-109 646970 Other Equip Repair 10,642 2,600 2,600 32000 31000 0 31000 20,00 182602-109 647110 Printing Binding 20416 300 300 0 300 0 300 0,00 182602-109 649000 Sales Tax Expense 1 0 0 100 0 0 0 N/A 182802-109 049030 Clerks Recording 0 100 100 0 100 0 100 0.00 182602-109 049100 Legal Advertising 11688 2,000 2,000 2,000 2,000 0 2,000 0,00 182602-109 661110 Office Supplies 61595 11600 11500 11500 12500 0 1,50o 0,00 182602-109 651930 Minor Office 299 10000 11000 0 0 0 0 -100,00 182602-109 651950 Minor Data 180 0 0 0 0 0 0 N/A 182602-109 652130 Clothing And 609 21000 2,000 10000 2,000 0 21000 0.00 182602-109 652140 Personal Safety 2,131 1,200 11200 30000 31600 0 31500 191,67 182602-109 662310 Fertilizer Herbicides 43,660 100,000 1006000 660000 70,000 0 70,000 -30,00 182602A09 652490 Fuel and Lubricants 21044 2,400 2,400 11400 31500 0 %600 45,83 182602-109 652990 Other Operating 11,339 80000 80000 12,000 13,700 0 13,700 71.26 182602-109 654360 Other Training Ed 31814 21000 20000 2,000 4,000 0 4,BDo 100.00 182901.109 631400 Engineering Fees 16,162 102000 100000 0 100000 0 10,000 0.00 182901-109 634207 IT Capital Allocation 41400 17,3OO 17,300 17,300 0 0 0 -100,00 182901-109 6342101nfo Tech 36,700 440600 44,600 44,600 46,300 0 45,300 1,57 182901A09 634263 Flood Control 127,810 880000 88,000 100,100 100,000 0 1000000 13.64 182901-109 634330 Towed Vehicles 285 0 0 0 0 0 0 N/A 182901A09 634805 Emergency Malnt 21626 2,500 2,600 0 20500 0 21500 0.00 182901-109 6349801nterdept Payment 869 0 0 0 0 0 0 N/A 182901409 634990 Landscape 11210 21600 2,600 2,600 32000 0 31000 1&38 182901=109 634999 Other Contractual 216,021 126,900 132,485 2010000 153,000 0 153,000 20,57 182901A09 639964 Storage Contractor 824 600 500 200 300 0 300 -40.00 182901A09 639966 Pest Control 250 600 600 0 Soo 0 Soo 0,00 182901A09 639967 Temporary Labor 286,221 347,000 347,000 325,000 347,000 0 347,000 0.00 182901-109 640300 Out Of County 0 600 Soo 600 500 0 500 0.00 182901-109 640410 Motor Pool Rental 11050 0 0 0 0 0 0 N/A 182901A09 641150 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 9,101 91600 9,600 8,200 92500 0 9,600 -1,04 182901-109 641950 Postage Freight 85 Soo 600 100 600 0 500 0.00 182901-109 643100 Electricity 2,337 21500 21500 2,500 21500 0 21600 0,00 182901-109 643300 Trash and Garbage 33138 41000 4,000 4,000 4,000 0 41000 0.00 182901-109 644100 Rent Buildings 13,794 42,000 42,000 44,000 450000 0 45,000 7,14 182901-109 644600 Rent Equipment 51171 21000 21000 31000 4,300 0 4,300 115,00 182901-109 645100 Insurance General 13,200 13,600 131500 13,500 12,900 0 12,900 -4,44 182901-109 646260 Auto Insurance 12,6OO 10,700 10,700 10,700 10,700 0 10,700 0,00 182901A09 646180 Building R And M 0 2,600 2,500 0 2,600 0 21500 0.00 182901-109 646311 Sprinkler System 61,291 52,000 62,000 55,000 58,000 0 58,000 11,54 182901-109 646314 Maintenance 86,461 902000 90,000 116,000 105,000 0 105,000 16,67 182901-109 646319 Tree Trimming 186,631 152,900 152,900 175,000 176,000 0 1762000 14,45 182901-109 646320 Landscape 57,417 160,000 1600000 13%000 120,000 0 120,000 -25,00 182901-109 646381 Road And Blkepath 61788 26,000 25,000 25,000 26,000 0 25,000 0000 182901-109 646430 Fleet Melnt ISF 61,492 41,300 41,300 41,300 61,600 0 61,600 49,16 182901-109 646440 Fleet Melnt ISF 21,977 16,600 16,600 160500 29,400 0 29,400 78,18 182901-109 646445 Fleet Non Mont 51685 11700 1,700 1,700 60300 0 61300 270,59 182901-109 646970 Other Equip Repair 51636 61600 6,600 61600 8,000 0 81000 21,21 182901-109 647110 Printing Binding 51284 11000 11000 200 600 0 500 -50,00 182901-109 649010 Licenses And 3,437 21500 21500 21600 20600 0 2,600 0,00 182901-109 649030 Clerks Recording 1,191 81400 %400 81400 8,400 0 8,400 0.00 182901-109 649100 Legal Advertising 11027 31000 31000 34000 3,000 0 31000 0.00 182901A09 651110 Office Supplies 51056 21000 2,000 2,000 2,000 0 2,000 0,00 182901A09 651930 Minor Office 465 16,000 152000 81000 0 0 0 400,00 182901-109 651950 Minor Data 26 600 600 0 500 0 60o 0.00 182901-109 652110 Clothing And 0 500 500 600 600 0 600 20,00 182901-109 652130 Clothing And 18,180 20,000 20,000 20,000 20,000 0 20,000 0,00 182901A09 652140 Personal Safety 61349 41000 41000 7,000 71000 0 7,000 76,00 182901-109 652310 Fertilizer Herbicides 77,831 1201000 120,000 1050000 105,000 0 1050000 -12,60 182901-109 652490 Fuel and Lubricants 32,894 40,000 40,000 30,000 55,700 0 55,700 3926 182901-109 652910 Minor Operating 71899 15,000 16,000 16,000 150000 0 16,000 0,00 182901A09 652920 Computer Software 0 800 800 600 800 0 800 0,00 182901-109 662990 Other Operating 18,972 16,000 15,000 180000 20,000 0 20,000 3333 182901-109 652999 Painting Supplies 0 500 500 0 500 0 500 OAD 182901-109 653710 Traffic Signs 597 61000 60000 6,000 82000 0 80000 33,33 OovMax 2 4/29I202 Agenda item #6 Page 8 of 14 Account Mlnor Fund Line Item Detall Proforma C_ower_C_ounty Government Flscat 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 Bav Beautification MSTBU 600 Operating Expense Expendltures 182901-109 654360 Other Training Ed 11389 21000 2,000 2,000 2,500 0 2$00 25,00 Expenditures 21029,435 23163,900 23179,361 2,147,000 21286,600 0 21266,600 5,67 610Indirect Cost Reimburs Expenditures 182602-109 634970 Indirect Cost 121,400 136*100 1360100 136,100 150,000 0 160,000 10,21 Expenditures 121,400 136,100 1,96,100 136,100 150,000 0 150,000 10.21 700 Capital Outlay Expenditures 182602-109 764900 Data Processing 0 600 Boo 0 600 0 600 0.00 182602.109 764990 Other Machinery 0 0 0 0 102000 0 10,000 NIA 182901-109 764110 Autos And Trucks 94,875 853000 65,000 81,000 0 0 0 -100,00 182901-109 764900 Data Processing 21,505 13000 17000 0 11000 0 11000 0.00 182901-109 764990 Other Machinery 39,478 91,000 910000 91,000 87,000 0 87,000 -4,40 Expenditures 155,868 177,500 177,500 172,000 981600 0 98,500 -44,51 855f Trans to Property Appraiser Expenditures 959010.109 930600 Budget Transfers 5,067 85,000 85,000 85,000 80,000 0 80,000 -5,88 Expenditures 51067 85,000 85,000 85,000 802000 0 80,000 -5,88 855h Trans to Tax Collector Expenditures 959010-109 930700 Budget Transfers 81,504 130,700 130,700 130,700 120,000 0 120,000 -8,19 Expenditures 81,604 130,700 130,700 130,700 120,000 0 120,000 -8,19 912a Trans to 301 Co Wide Can Fd Expenditures 929010-109 913010 Transfer to 301 0 81700 81700 8,700 10,000 0 10,000 14,94 Expenditures 0 8,700 8,700 81700 101000 0 10,000 14,94 916h Trans to 408 Water/Sewer Fd Expenditures 929010-109 914080 Transfer to 408 23,100 21,000 21,000 21,000 17,600 0 17,600 -16.19 Expenditures 23,100 21,000 21,000 21,000 17,600 0 17,600 -16.19 920f Trans to 506 IT Capital Expenditures 929010.109 915060 Transfer to 506 0 0 0 0 37,100 0 37,100 N/A Expenditures 0 0 0 0 37,100 0 37,100 N/A 991 Reserve for Contingencies Expendltures 919010-109 991000 Reserve For 0 169,000 169,000 0 160,000 0 160,000 0,63 Expenditures 0 1690000 159,000 0 160,000 0 160,000 0.63 991d Reserve for Salary Ate. Expenditures 919010-109 992160 Reserve for Salary 0 0 0 0 1620600 0 162,500 N/A Expenditures 0 0 0 0 162,500 0 162,500 N/A 993 Reserve for Capital Expenditures 919010-109 993000 Reserve For 0 111,200 1110200 0 110,000 0 110,000 -1.08 Expenditures 0 111,200 111,200 0 110,000 0 110,000 -1.08 995a 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 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 476,000 0 475,000 0 476,000 0.00 Expenditures 0 4751000 476,000 0 475,000 0 475,000 0.00 999 Reserve for Attrition Expenditures 919010-109 992100 Reserve For 0 •43,900 43,900 0 -39,300 0 -39,300 -10,48 Expenditures 0 143,900 -43,900 0 -391300 0 -390300 -10,48 325a Special Assessments Revenues 182601-109 325100 Special 905,104 0 0 0 0 0 0 N/A 182602.109 325100 Special 0 949,000 949,000 912,000 11431,000 0 1,431,000 60,79 182900-109 325100 Speclal 3,170,106 0 0 0 0 0 0 N/A 182901-109 326100 Speclal 0 3t022,000 3,022,000 20901,100 3,471,800 0 31471,800 14,88 Revenues 410750210 3,971,000 3,971,000 3,813,100 41902,800 0 4,902,800 23,47 GovMex 3 4128I202 Agenda item #6 Page 9 of 14 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal rear 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 182602-109 362192 Lease Facilities 0 17,900 17,900 17,900 18,400 0 18,400 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 182901-109 364410 Surplus Furniture 63,650 0 0 0 0 0 0 N/A 182901-109 365100 Scrap Sales 41150 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 35,800 35.800 360800 0 36,800 2.79 361 InterestlMisc Revenues 182601-109 361320 Interest Tax 96 0 0 0 0 0 0 N/A 182900-109 3613201nterest Tax 336 0 0 0 0 0 0 N/A 989010-109 361170 Interest SBA 31588 0 0 0 0 0 0 N/A 989010.109 361180 Investment Interest 13,764 23,100 23,100 15,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 film Proper Aooralser Revenues 959010A09 486600 Transfer From 73,018 0 0 0 0 0 0 N/A Revenues 73,018 0 0 0 0 0 0 NIA 392h Trans frm Tax Collector Revenues 959010-109 486700 Transfer From Tax 32,667 0 0 0 0 0 0 N/A Revenues 32,667 0 0 0 0 0 0 N/A 413u Trans fm 320 Clam Bay Can Ed Revenues 929010-109 481320 Transfer From 320 34,100 34,100 34,100 34,100 34,100 0 34,100 0100 Revenues 34,100 34,100 34,100 34,100 34,100 0 34,100 0,00 499u Carry Forward Revenues 919010-109 489200 Carryforward 2,816,900 2,3111000 21311,000 217564900 1,861,000 0 11861,000 -19.47 919010-109 489201 Carry Forward Of 0 0 15,461 0 0 0 0 N/A Revenues 21816,900 21311,000 21326,461 21766,900 1,861,000 0 1,861,000 -19.47 499z Less 5% Required By Law Revenues 919010-109 489900 Less 6 % Required 0 -201,800 -2013800 0 -245,200 0 -246,200 21,61 Revenues 0 -201,800 -201,800 0 -245,200 0 -2453200 21,51 Fund Total Expenditure: 41395,305 83173,200 8,188,661 4,793,900 61609,600 0 8,609,500 7.07 Fund Total Revenue: 7,152,179 8,173,200 8,188,881 6,864,900 8,609,500 0 8,609,500 7.07 Fund Balance: 21756,B74 0 0 19861,000 0 0 0 N/A 320 Clam Bay Restoration 600 Operating Expense Exnenditures 183800-320 fi31400 Englneadng Fees 81,243 108,100 164,377 164,400 35,000 0 35,000 •67.07 183800-320 634999 Other Contractual 21,186 35,000 121j281 1219300 1209000 0 120,000 242,86 183800-320 646319 Tree Trimming 76,600 37,500 40,900 40,900 0 0 0 -100,00 163800-320 652990 Other Operating 0 0 4,553 4,600 0 0 0 NIA Expenditures 179,029 178,600 3313111 331,200 165,000 0 165,000 •13.21 855f Trans to Pronedy Appralser Expenditures 959010-320 930600 Budget Transfers 0 80900 80900 83900 81800 0 61800 -23,60 Expenditures 0 82900 83900 81900 61800 0 61800 -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 3,691 13,100 13,100 13,100 94600 0 91600 -26,72 9041 Trans to 109 PS MSTUBU Fd Expenditures 929010-320 911090 Transfer to 109 Pei 34,100 34,100 34,100 34,100 34,100 0 34,100 0,00 Expenditures 34,100 34,100 34,100 34,100 34,100 0 34,100 0,00 aovMax 4 41281202 Agenda item #6 Page 10 of 14 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 Bay Restoration 325a Speclal Assessments Revenues 183600-320 325100 Special 776 238,600 23B,500 229,000 203,100 0 203,100 -14.84 183805-320 325100 Speclal 178,788 0 0 0 0 0 0 N/A Revenues 179,664 238,500 238,500 229,000 203,100 0 20%100 -14.84 361 InterestlMisc Revenues 183805.320 3613201nterest Tax 19 0 0 0 0 0 0 N/A 989010-320 361170 Interest SBA 215 0 0 100 0 0 0 N/A 989010-320 361180 Investment Interest B26 100 100 700 100 0 100 0.00 Revenues 1,060 100 100 800 100 0 100 0.00 :r _:. 1,1 1 .11 :1 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 N/A 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 N/A Revenues 11337 0 0 0 0 0 0 N/A 499u Carry Forward Revenues 919010-320 489200 Carryfonvard 201,900 89100 80100 170,100 12,600 0 12,600 55,56 919010-320 489201 Carry Forward Of 0 0 162,610 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 -121000 -120000 0 -10,300 0 -103300 -14.17 Revenues 0 -12,000 A2,000 0 -10,300 0 -10,300 -14.17 Fund Total Expenditure: 216,720 234,700 387,2l l 387,300 205,500 0 205t500 -12.44 Fund Total Revenue: 386,841 234,700 387,210 399,900 205,500 0 205,500 -12,44 Fund Balance: 170,121 0 -1 12,600 0 0 0 NIA 322 Pelican Bay Irr & LndscP 800 O eu rating�pense Expenditures 183825-322 631400 Engineadng Fees 94,150 0 205,746 732,400 0 0 0 NIA 183825-322 631401 Engineering Fees 167,377 0 65,133 65,100 0 0 0 N/A 183826-322 631990 Other Professional 0 4003000 0 0 0 0 0 -100.00 183625.322 634261 Flood Control 20,907 0 49837 4,800 0 0 0 N/A 183826-322 6349801nterdept Payment 21363 0 0 0 0 0 0 N/A 183825-322 634999 Other Contractual 358,0111 21038,400 31855,468 31856,400 11300,000 0 13300,000 -36,22 183826322 644600 Rent Equipment 0 0 50 100 0 0 0 N/A 183826322 646320 Landscape 0 0 157,020 167,000 1006000 0 100,000 N/A 183825322 649010 Licenses And 1,029 0 0 0 0 0 0 N/A 183825322 649980 Relmb Prior Year 0 0 0 160,000 0 0 0 N/A 183826-322 653710 Traffic Signs 953971 150,000 93,971 94,000 160,000 0 150,000 0,00 Expenditures 740,408 2,688,400 41382,226 6,068,800 1,550,000 0 126502000 -40,12 700 Capital Outlay Expenditures 183826322 763100 Improvements 413,165 1,631,200 41643,349 4,543,300 370,000 0 370,000 -75,84 Expenditures 413,165 11531,200 4,543,349 4,543,300 370,000 0 370,000 -75.84 855f Trans to Propefty Appraiser Expenditures 959010.322 930600 Budget Transfers 0 30,700 30,700 30,700 57,400 0 570400 86,97 Expenditures 0 30,700 30,700 30,700 67,400 0 57,400 86,97 855h Trans to Tax Collector Expenditures g59010322 930700 Budget Transfers 27,103 67,400 67,400 67,400 34,000 0 34,000 -40.77 Expenditures 27,103 57,400 57,400 57,400 34,000 0 34,000 -40.77 GovMax 6 4I29I202 Agenda item #6 Page 11 of 14 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 FY2023 Adopted Actual Adopted Amended Forecast Current Expanded Budget % Change 322 Pelican By Irr & LndscP 911y Trans to 299 Debt Sery Fd Exeenditures 929010.322 912990 Transfer to 299 0 200,000 200,000 63,600 209,300 0 209,300 4,65 Expenditures 0 200,000 2003000 63,500 209,300 0 209,300 4,65 992a Reserve for Future Debt Service Expenditures 919010.322 992090 Reserve For Future 0 75,000 75,000 0 0 0 0 -100,00 Expenditures 0 75,000 75,000 0 0 0 0 -100,00 993 Reserve for Capital Expenditures 919010-322 993000 Reserve For 0 451,600 451,600 0 490,200 0 490,200 8.55 Expenditures 0 451,600 4513600 0 490,200 0 490,200 8.55 995e Reserve for Disaster Relief Exeenditures 919010-322 991700 Reserve For 0 160,000 160,000 0 0 0 0 -100.00 Expenditures 0 1601000 1600000 0 0 0 0 -100.00 325a Special Assessments Revenues 183825-322 325100 Speclal 11355,165 19914,700 1,914,700 1,838,100 1,582,600 0 1,5821600 -17,34 Revenues 1,365,165 11914,700 1,914,700 1,838,100 1,682,600 0 1.682,600 -17.34 360 Miscellaneous 183825-322 Revenues Revenues 366900 Contributions 0 400,000 0 0 0 0 0 -100,00 183825-322 369130 Ins Cc Refunds 689,212 0 0 0 0 0 a N/A Revenues 589,212 400,000 0 0 0 0 0 A00.00 361 Interest/Misc Revenues 183825-322 361320 Interest Tax 144 0 0 0 0 0 0 N/A 909010-322 361170 Interest SBA 41975 0 0 0 0 0 0 NIA 989010-322 361180 Investment Interest 17,776 %500 %500 26,200 10,000 0 10,000 6,26 Revenues 22,895 91500 91500 26,200 10,000 0 10,000 5.26 392d Trans firm Propedy Appraiser Revenues 959010-322 486600 Transfer From 11,608 0 0 0 0 0 0 N/A Revenues 111808 0 0 0 0 0 0 NIA 392h Trans firm Tax Collector Revenues 969010-322 486700 Transfer From Tax 61311 0 0 0 0 0 0 N/A Revenues 5,3ll 0 0 0 0 0 0 N/A 405k Trans fm 111 Unincorp Gen Fd Revenues 929010-322 461111 Transfer From 111 620,000 520,000 520,000 520,000 520,000 0 520,000 0.00 Revenues 520,000 620,000 620,000 520,000 520,000 0 520,000 0,00 432c Trans fin 778 Pal Bay Lighting Revenues 929010-322 481778 Transfer From 778 2,061,800 440,000 440,000 440,000 370,000 0 370,000 -16,91 Revenues 21061,800 4400000 440,000 440,000 370,000 0 370,000 -16,91 499u Carry Forward Revenues 919010-322 489200 Canyforward 31716,700 10926,400 11926,400 7,247,400 3081000 0 308,000 -84,01 919010-322 489201 Carry Forward Of 0 0 61205,974 0 0 0 0 N/A Revenues 3,716,700 1,926,400 7,132,374 7,247,400 308,000 0 308,000 -84.01 499z Less 5% Required By Law Revenues 919010-322 469900 Less 5 % Required 0 -116,300 -116,300 0 -79,700 0 -79,700 -31,47 Revenues 0 -116,300 -116,300 0 49,700 0 -790700 -31.47 Fund Total Expenditure; 1,180,678 5,094,300 9,900,274 9,763,700 2,7101900 0 2,710,900 -46.79 Fund Total Revenue: 803820891 610943300 91900,274 10,077,700 2,710,900 0 21710,900 -46.79 Fund Balance: 71202,215 0 0 30%000 0 0 0 N/A OovMax 8 q/291202 Pyendo item #6 Page 12 of 14 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 500 Personal Services Expenditures 182701.778 612100 Regular Salarles 53,456 66,447 68,447 69,200 74,298 0 74,298 11.82 182701-778 612600 Auto Use Benefit 152 0 0 0 0 0 0 N/A 1102701-778 612600 ER 457 Deferred 348 630 630 1,000 530 0 530 0.00 182701-778 514100 Overtime 61812 6,900 61900 6,400 711oo 0 71100 2,90 182701-778 615000 Vacation Sell Back 0 504 504 200 179 0 179 -64A8 182701-778 519100 Reserve For Salary 0 11486 11486 0 79 0 79 -94,68 182701-778 521100 Social Security 41241 5,271 5,271 51500 5,738 0 5,738 8,86 182701-778 622100 Retirement Regular 6,109 71637 70637 8,200 91056 0 90056 18,68 182701-778 623150 Health Insurance 13,886 130886 13,886 13,900 13,886 0 13,8B6 0.00 182701.778 523152 Dental Insurance 530 530 630 600 556 0 556 4,91 182701-778 623163 Short Term 108 108 106 100 132 0 132 24,53 182701-778 623164 Long Term 212 212 212 200 238 0 238 12,26 182701-778 623160 Life Insurance 108 191 191 200 208 0 208 8.90 182701478 524100 Workers 2,400 1,600 11800 10800 10600 0 11600 -11.11 182701.778 526200 Allowance Vehicle -152 0 0 0 0 0 0 NIA Expenditures 87,287 106,600 105,600 107,300 1139600 0 11%600 7.68 600 Operating Expense Expenditures 182701478 631400 Engineering Fees 0 51000 5,o00 0 4,500 0 40600 -10.00 182701478 634210 Info Tech 600 600 500 500 0 0 0 -100.00 182701.778 634805 Emergency Malnl 0 2,600 2,500 51000 2,500 0 21600 0,00 182701-778 634999 Other Contractual 35,277 37,800 43,730 43,800 45,000 0 45,000 19,05 162701478 639964 Storage Contractor 824 500 500 200 200 0 200 -60.00 182701-778 639967 Temporary Labor 35,694 43,600 43,600 41,000 44,000 0 44,000 0.92 182701-778 641150 Telephone Beepers 360 400 400 400 400 0 400 0.00 182701-778 641400 Telephone Direct 701 600 800 250 0 0 0 -100,00 182701-778 641950 Postage Freight 86 200 200 350 400 0 400 100,00 182701.778 643100 Electricity 25,420 26,000 26,000 263000 28,000 0 26,000 0.00 182701-778 644100 Rent Buildings 131693 15,000 15,000 44,000 45,Og0 0 45,000 200,00 182701-778 644600 Rent Equipment 2,105 21000 2,000 21200 2,600 0 21600 26.00 182701-778 645100 Insurance General 11500 11400 1,400 11400 11100 0 11100 -21.43 182701-778 645260 Auto Insurance 900 900 900 900 900 0 900 0.00 182701.776 646430 Fleet Malnt ISF 4,392 1,400 1,400 11900 41600 0 4,500 221,43 182701-778 646440 Fleet Maint ISF 11502 900 900 600 11100 0 11100 22,22 182701-778 646445 Fleet Non Malnt 41835 200 200 200 4,900 0 4,900 21350,00 182701478 646970 Other Equip Repair 0 Soo 600 0 500 0 600 0.00 182701-778 651110 Office Supplies 6,636 800 800 0 800 0 800 0.00 182701478 652140 Personal Safely 1,104 1,100 1,100 21500 2,500 0 2,500 127,27 182701-778 652490 Fuel and Lubricants 243 300 300 300 500 0 500 66,67 182701-778 652990 Other Operating 2,387 20000 2,000 4,000 41000 0 4,OOo 100,00 182701-778 652992 Electrical 0 26,000 26,000 10,000 10,000 0 lo,000 -61,64 182701-778 652993 Light Bulbs Ballast 53101 16,000 16,000 82000 13,000 0 130000 -13.33 Expenditures 143,359 184,800190,730 193,600 214,300 0 214,300 15.96 610Indirect Cost Relmburs Expenditures 182701-778 634970 Indirect Cost 10,000 9,800 9,800 9,800 9,400 0 9,400 •4.08 Expenditures 10,000 90800 9,800 91800 %400 0 9,400 -4.08 700 Capital Outlay Expenditures 182701-778 764110 Autos And Trucks 0 166,000 156,000 162,000 0 0 0 -100,00 182701-778 764900 Data Processing 0 500 500 0 500 0 500 0.00 Expenditures 0 156,500 186,500 152,000 500 0 500 -99.68 855f Trans to Property Appraiser Expenditures 959010-778 930600 Budget Transfers 0 12,000 12,000 12,000 10,000 0 10,000 -16,67 Expenditures 0 12,000 12,000 12,000 10,000 0 101000 -16.67 855h Trans to Tax Collector Expenditures 959010-778 930700 Budget Transfers 12,686 17,000 17,000 17,000 16,000 0 ist000 -11,76 Expenditures 12,688 17,000 17,000 17,000 15,000 0 15,000 711.76 912w Trans to 322 Pel Bay Irr and Land Expenditures 929010-778 913220 Transfer to 322 Pei 2,061,800 440,000 440,000 440,000 370,000 0 3700000 -16,91 Expenditures 2,061,800 440,000 440,000 440,000 370,000 0 3701000 -15.91 GovMax 7 4/29/202 Agenda item #6 Page 13 of 14 Account Minor Fund Line Item Detail Proforma Collier County Government Fiscal Year 2023 FY 2021 FY2022 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 Expenditures 919010-778 991000 Reserve For 0 11,400 11,400 0 11,400 0 11,400 0,00 Expenditures 0 11,400 11,400 0 11,400 0 11,400 0,00 993 Reserve for Capital Expenditures 919010-778 993000 Reserve For 0 36,400 36,400 0 36,400 0 36,400 0,00 Expenditures 0 36,400 36,400 0 36,400 0 36,400 0,00 998 Reserve for Cash Flow Expenditures 919010478 998000 Reserve For Cash 0 39,700 39,700 0 40,000 0 40,000 0,76 Expenditures 0 3%700 390700 0 40,000 0 40,000 0,76 306 Ad Valorem Taxes Revenues 182700.778 31l 100 Current Ad Valorem 629,977 0 0 0 0 0 0 N/A 182701-778 311100 Current Ad Valorem 0 660,900 660,900 634,500 683,500 0 683,500 3A2 Revenues 629,977 660,900 660,900 634,500 683,500 0 683,600 3,42 307 Delinquent Ad Valorem Taxes Revenues 182700-778 3112000ellnquent Ad 24270 0 0 0 0 0 0 NIA Revenues 2,270 0 0 0 0 0 0 N/A 360 Miscellaneous Revenues Revenues 182701-776 362192 Lease Facilities 0 18,400 18,400 18,400 18,9oo 0 18,900 2,72 Revenues 0 18,400 180400 18,400 18,900 0 182900 2,72 361 Interest/Misc Revenues 182700-776 3613201nlerest Tex 68 0 0 0 0 0 0 N/A 989010-778 361170 Interest SBA 11388 0 0 0 0 0 0 N/A 989010-778 361180 Investment Interest 50655 3,600 3,600 2,400 3,600 0 3,600 0.00 Revenues 7,011 3,600 316o0 21400 31600 0 3,600 0.00 392h Trans firm Tax Collector Revenues 959010478 486700 Transfer From Tax 43446 0 0 0 0 0 0 NIA Revenues 4,446 0 0 0 0 0 0 NIA 499u Carry Forward Revenues 019010-778 489200 Carryforwanl 2,0964500 364,300 364,300 426,000 148,700 0 148,700 -59,18 919010.778 489201 Carry Forward Of 0 0 50930 0 0 0 0 N/A Revenues 2,096,600 364,300 370p230 426,000 1481700 0 148,700 -59.18 499Z Less 5 % Required By Law Revenues 919010-778 489900 Less 5%Required 0 -34,100 -34,100 0 -34,100 0 .94,100 0.00 Revenues 0 -34,100 -340100 0 -34,100 0 -34,100 0,00 Fund Total Expenditure: Fund Total Revenue: 2,3151734 2,740,204 1,013,100 1,013,100 1,019,030 1,019,030 931,600 1,080,300 820,600 820,800 0 0 820,800 820,600 -19.00 -1900. Fund Balance: 426,070 0 0 146,700 0 0 0 N/A GovMex 8 4/29/202 Agenda item #6 Page 14 of 14 IF 441) IF IF A/C322 1 ........:............ I.:.:............ Budgeted cpiryMrway i 2t/22 Assessmant. net, Interest - - r ..._.;......_................ &.-.. Ala 77#1n4riertr cc s/W Cept'n ... ..... _.... ' Miscellenenua no . ...... ...............I..._.. PROJECTS .......................I. a......1.,...._.... Landscape imp., A/c 322 O2125/P2 Update 21/228udget Current Ea.lmate ariance V Amended i ___.__..,_.-----------_. . .. ........-I I ---.. IF ._.._......_.. ...__........_.. i....._. $7,132,3791 $7,132,374 0 j Cfwd per Jan f/S I ..__ ................ WO. _.._.L_ . I l$7,260,8131 i I IF 1 -- --- -_I._....._.._._...._ : ............. ..................... _ I . . _. _I._........ .. ....... .. ...._; ........._. ._.. _ _...._ 1 4,796,400 1,798,400 0' OF" .-- _.!_-.._.I.._ _.I._r___....I....-..L...._.__.ences - -! -__________..--.,,,,,.-9,G00+,.,_„___ 20,000 ,00Higher bal10,G' 1 f`............._-.. L..... 01 .•...�._.-..,.. _�__.........__..._._... _...._ ....... __.._ _,....._.._. _...-._..--___.__�......-4.__.._--.i._....,.I ..11 _._......I _........ __.. __..._OJ....__ 1 440,000; 440000 0+ ._.__ _... .. .. .. . ....._ __..__....-.1........... . ...... .__..........._....-_ . i..-----._....... _ �_........ ...... 0201000 6200001 0 _ IFr o! 01 1 PBF sldewalke bid Iarately 6lgnage , . `Death Repo .: $9,A00,274( $9,910,774 .._...........167,881 . ;___._..._....157,881 93,971+ 9%971 ...:_....._.. 2,237,p87i 1,021,982 Resarye � 276,00p1 RoadWap$ptpty, ' 10019451 100,046� Side Walk9 01ppeitng 87,691' 67,031 ..::.:.:....r_._.:..........._........ Bps DulldlnS.. I. .... .........i.... .._.-_ . .. 3,797,706;- ----3,797,708 _ _ �81dewaiks-phoget 663,843` � - 658,8481 ..............._.__.....,...... . _..__,_..........._,..... .....,_. -..... ..._... Sidewalks - Phase 2. ' It 7382697 I lake Banks .. � i 1,818,630 i .. __ . .. 2,401,948 i ............... .........................I. .. _..... _ ... .....................-- I ' Ras, CApHot Pulley I 461,BOtl I p ' Debt Service QnU ': 78,000 : ...._...................... ......I........ I.,.._._.. _.... ,....`.`_...... _....__.._. -......_. 1 .. _ _...... _....... __. _ . . 'Befit BarulcAI 200,000i 200*000 Irmo lnsuranp mplalm ' 160,000 160,000 Co)ilar Pena I" I 88,100I BB,100IO I d Financing nee ..................... dad Table 1.1 $9,900 $16,361,782 ,27M1: sop,.I IF 0 � ! Rsserva build i 1,216,9051 Expense lower than II ekpooted _....................i_..._.._ ._.._......_.-..i......... ........._....., -275,0001 iRoserre build _..-.....__.__..._.._._____.__..._..__., 0I Crosswalk ' ....... a..-.--- ..... ........--_.....__._....__. ..... ... _........ 01 "I 0; I$3.Bm-00 share .. .... ... ..... i I $0.aM+FBF -. 1... ......_.._�1......_....... _...__..._. FW_.. _.............-- -7,362,6971 !$8,8M+ + i CEI+Engineering _._. .._.__.._.__.____L.......... ... __....-- W_.__._..._...... _.. ..... _I -688,416 r$2.9m+ Engineering —..-.......___._.--_..I_.......0 ...._..... ._.-... .... ..... ... + _ 451,6001 I 1 ..__...1..00.._.-...._... ..._.........._. _..... .L. ._ .......- ......... .....760000 1 I ................. _... __:..._.._...._ __......_.._. _; 0 I I Interest and loan Initiation fees ' p1 tl+ ..........__...__........+.........__...._..............._'E...._,-.. ......---.....J 8,481,600.1„ , ..,.. ...... ............. . 11 W,IF A i 1