Loading...
Agenda 09/13/2022 Item #16F 3 (Budget Amendments)09/13/2022 EXECUTIVE SUMMARY Recommendation to authorize budget amendments appropriating approximately $1,438,252,900 of unspent FY 2022 capital project and grant budgets into fiscal year 2023. OBJECTIVE: Board of County Commissioners' approval of budget amendments which will increase the FY 2023 budget by approximately $1,438,252,900 in the various Capital projects, Grant and Grant donor matching funds. CONSIDERATIONS: During fiscal year 2022, grants and capital projects were contemplated and planned for in the adopted budget and/or budget amendments were processed. Grants and Capital Projects do not necessarily “expire” at the end of the Board’s fiscal year, on September 30. The unspent portion of these budgets need to roll forward into the next fiscal year t o avoid disruption in the payment of venders and employees. This action is considered customary and routine in accordance with budgetary practices and the accounting associated with Capital and Grant Funds. Grant awards are approved by the Board at various times during the year; many grants have fiscal year cycles different than the County’s fiscal year of Oct 1 - Sept 30. At year-end, the accounting system SAP automatically calculates the unspent budget (amended budget less expenditures) and posts this amount into fiscal year 2023 budget as a budget amendment. Some grants require local matching funds. In the donor funds, match money is budgeted as a transfer to the Grant Fund. As expenditures are incurred, Finance transfers the correct amount of cash from the donor fund to the Grant Fund. If at year end, the grant is not completed, committed match dollars sitting in the donor fund must be re-budgeted in fiscal year 2023 to ensure that the grant is in compliance with the grant contract and match requirements. Capital Projects are usually multi-year projects. Budgets are created during the budget process and/or in the form of budget amendments. As professionals and contractors are hired, purchase orders are opened and work is in progress, the closing down and starting up a fiscal year should not disrupt the progress of a capital project. The accounting system SAP automatically calculates the unspent budget (amended budget less expenditures) and posts this amount into fiscal year 2023 budget as a budget amendment. Section 129.06, Florida Statute, mandates that any increase in a Fund by the recognition of Carryforward and increasing the appropriations must be approved by resolution of the Board of County Commissioners after an advertised public hearing. (The resolution will be in the next BCC meeting on September 27th). The $1,438,252,900 is the amount of unspent budget (amended budget of $1,746,918,700 less expenditures of $309,561,600) as of July 27, 2022 plus the amount of transfers to be made by t he donor funds of $895,800. On October 1, SAP will automatically calculate and post the unspent budgets in each grant and capital project’s fund. The actual amount of the budget amendment may be more or less than $1,438,252,900 depending on the activity within the remaining 65 days before September 30. Additional moneys will be spent when invoices are processed and/or the Board may authorize budget amendments on September 13th and September 27th which was not contemplated in this executive summary. Waiting until after the close of the fiscal year for Board approval on the budget amendments to carryforward the unspent budgets, will mean that all the capital projects and grants will sit idle with no budgets for 11 days. The consequence is over $446 million in open purchase orders cannot roll into FY 16.F.3 Packet Pg. 2973 09/13/2022 2023; venders and grant employees will not receive any form of payment until after the October 11th Board meeting. Below is a recap of Exhibit A listing the primary categories of the estimated roll over amounts in the Capital Projects and Grants totaling $1,438,252,900. The categories are listed from most restricted to least restricted in terms of various legislature, statutory, legal, policy, program or regulatory constraints. Unspent budgets as of 7/27/2022 Grant Funds $218,449,100 Donor Funds Providing Grant Match Money 895,800 Gas & Infrastructure Sales Tax Capital Projects Funds 327,861,700 Impact Fees Capital Projects Funds 176,589,100 User Fees and Bond Proceeds Capital Projects Funds 598,651,700 Ad Valorem Supported Capital Projects Funds 115,805,500 Total $1,438,252,900 FISCAL IMPACT: Budget amendments in the approximate amount of $1,438,252,900 are needed in FY 2023 to re-appropriate unspent (FY 2022) budget within each capital project, grant, and match funds and to recognize a like amount in Carryforward/Grant revenue. Attached is Exhibit “A” listing each Fund and estimated dollar amount calculated as of July 27, 2022. On October 1, the accounting system SAP will calculate and post the precise amount of unspent budget and this amount may be more or less than $1,438,252,900, depending on the activity over the remaining 65 days in the fiscal year. The budget amendment is $216,769,200 higher than the previous year primarily due to infrastructure sales tax projects and bond proceeds projects. This roll of unspent funds does not affect the adopted FY 2023 budget which the Board will consider on September 22, 2022. GROWTH MANAGEMENT IMPACT: While there is no new growth management impact, this carryforward funding request will ensure that there are no payments or contracting delays for budgeted growth management projects. LEGAL CONSIDERATIONS: This item was reviewed by the County Attorney, is approved as to form and legality, and requires majority support for approval. -JAK RECOMMENDATION: Recommendation to authorize budget amendments totaling approximately $1,438,252,900 to re-appropriate unspent (FY 2022) budget and carry forward into fiscal year 2023 for capital projects, grants, and match money. PREPARED BY: Laura Zautcke, Senior Budget Analyst, Office of Management & Budget ATTACHMENT(S) 1. FY22 Proj roll to FY23 Exhibit A (PDF) 16.F.3 Packet Pg. 2974 09/13/2022 COLLIER COUNTY Board of County Commissioners Item Number: 16.F.3 Doc ID: 23110 Item Summary: Recommendation to authorize budget amendments appropriating approximately $1,438,252,900 of unspent FY 2022 capital project and grant budgets into fiscal year 2023. Meeting Date: 09/13/2022 Prepared by: Title: – Office of Management and Budget Name: Debra Windsor 08/18/2022 11:25 AM Submitted by: Title: Director - Facilities Maangement – County Manager's Office Name: Ed Finn 08/18/2022 11:25 AM Approved By: Review: Office of Management and Budget Laura Zautcke Level 3 OMB Gatekeeper Review Completed 08/18/2022 11:27 AM Office of Management and Budget Laura Zautcke Additional Reviewer Completed 08/18/2022 5:25 PM County Attorney's Office Jeffrey A. Klatzkow Level 3 County Attorney's Office Review Completed 08/19/2022 11:21 AM County Manager's Office Ed Finn Additional Reviewer Completed 08/21/2022 8:32 PM County Manager's Office Dan Rodriguez Level 4 County Manager Review Completed 09/06/2022 12:43 PM Board of County Commissioners Geoffrey Willig Meeting Pending 09/13/2022 9:00 AM 16.F.3 Packet Pg. 2975 Estimate of the Unspent 2022 Project Budgets to be Added to FY 2023 Budget Exhibit A As of 7/27/2022 Grants Economic Development Fund (007)2,910,700 Miscellaneous Grants Fund (116)735,000 Natural Resources Grant (117)6,800 Sea Turtle/Parks Grant (119)417,800 Community Development Block Grants Fund (121)2,000 Services for Seniors - County Aging Program Fund (123)2,826,400 MPO Grants Fund (128)64,500 Library Grants Fund (129)1,143,900 Public Utilities Grant Fund (416)3,426,200 Public Utilities Grant Match Fund (417)1,117,300 Collier Area Transit (CAT) Grant Fund (424)21,306,400 Collier Area Transit (CAT) Grant Match Fund (425)1,008,200 Collier Area Transit (CAT) Enhancements Fund (426)3,040,900 Transportation Disadvantaged Fund (427)4,021,500 Transportation Disadvantaged Grant Fund (428)889,400 Transportation Disadvantaged Grant Match Fund (429)100,800 Solid Waste Disposal Grant Fund (472)1,685,500 Solid Waste Grant Fund (475)196,900 Solid Waste Grants Match Fund (476)65,700 EMS Grants Fund (493)213,900 EMS Grants Match Fund (494)324,300 Airport Authority Grant Fund (498)968,700 Airport Authority Grant Match Fund (499)121,800 Specialized Grants Fund (701)1,430,500 Specialized Grants Match Fund (702)501,200 Administrative Services Grant Fund (703)106,300 Administrative Services Grant Match Fund (704)300 Housing Grant Fund (705)95,667,300 Housing Grant Match Fund (706)22,900 Human Services Grant Fund (707)4,625,400 Human Services Grant Match Fund (708)25,300 Public Services Grant Fund (709)12,078,200 Public Services Grant Match Fund (710)697,200 Transportation Grant Fund (711)28,025,700 Transportation Grant Match Fund (712)18,561,700 FEMA Grants Fund (727)1,000,000 Deepwater Horizon Oil Spill Settlement (757)2,130,500 State Housing Incentive Partnership Grant Fund (791)6,982,000 218,449,100 Donor Funds Providing Match Money to Grants General Fund (001)841,300 Unincorporated Areas General Fund (111)2,200 Conservation Collier Fund (174)10,000 Emergency Medical Services Fund (490)32,300 University Extension Fund (604)10,000 895,800 Fuel and Surplus Sales Tax Projects Road Construction - Gas Tax Capital Fund (313)21,898,600 Infrastructure Sales Tax Capital Fund (318)305,963,100 327,861,700 16.F.3.a Packet Pg. 2976 Attachment: FY22 Proj roll to FY23 Exhibit A (23110 : Unspent FY 2022 Capital project and grant budgets into FY 2023) Exhibit A As of 7/27/2022 Impact Fee Capital Projects Road Impact Fee - District 1 Fund (331)19,553,400 Road impact Fee - District 2 Fund (333)23,468,100 Road Impact Fee - District 3 Fund (334)1,633,400 Road Impact Fee - District 4 Fund (336)17,493,600 Road Impact Fee - District 6 Fund (338)28,840,900 Road Impact Fee - District 5 Fund (339)12,238,600 Regional Park Impact Fee Fund (345)1,273,500 Parks Impact Fee - Unincorporated Area Fund (346)45,835,300 Emergency Management Services Impact Fee Fund (350)504,400 Library Impact Fee Fund (355)131,900 Ochopee Fire Control District Impact Fee Fund (372)76,300 Correctional Facilities Impact Fee Fund (381)1,682,600 Law Enforcement Impact Fee Fund (385)2,254,700 Government Facilities Impact Fee Fund (390)2,998,200 Water Impact Fees Capital Projects Fund (411)6,676,900 Sewer System Development Capital Fund (413)11,927,300 176,589,100 User Fee & Bond Proceeds Capital Projects Naples Production Park MSTD (138)162,700 Special Assessment Bayshore/Avalon Beautification MSTU (160)2,591,800 MSTU tax Conservation Collier Capital Fund (179)191,200 Conservation Collier tax Court Maintenance Fund (181)8,617,500 Court Fines and Fees TDC Beach Park Facilities Fund (183)4,096,600 Tourist Development (TDC) tax TDC - Beach Renourishment and Pass Maintenance Fund (195)17,520,300 Tourist Development (TDC) tax Florida Boating Improvement Fund (303)2,535,800 Vessel Registration Fees ATV Settlement (305)3,197,300 Settlement from SFWMD Parks Bond Proceeds Fund (308)14,132,800 Bond Proceeds Community Development - Capital Projects Fund (309)11,148,900 User Fees (TDC) Museum Capital Projects Fund (314)1,065,700 TDC Tax Clam Bay Restoration Capital Fund (320)200,100 Special Assessment Pelican Bay Capital Fund (322)6,807,600 Special Assessment Pelican Bay Commercial Paper Capital Fund (323)10,000,000 Commercial Paper Stormwater Bond Proceeds Fund (327)52,419,600 Bond Proceeds Transportaton Debt Financed Capital Fund (330)27,195,900 Commercial Paper Road Assessments (341)518,200 Special Assessment Sports Complex Capital Fund (370)26,425,300 Bond Proceeds Water - Sewer Motor Pool Capital Recovery Fund (409)8,034,300 Water-Sewer User Fees Water User Fees Capital Projects Fund (412)70,696,900 Water User Fees Sewer User Fee Capital Projects Fund (414)102,220,600 Sewer User Fees Water Sewer Bond Proceeds Fund (415)21,851,300 Bond Proceeds Public Utilities Special Assessment (418)18,000 Special Assessment Water-Sewer Bond #2 Proceeds Fund (419)145,970,100 Bond Proceeds Solid Waste Capital Projects Fund (474)15,575,400 Solid Waste Fees EMS Capital Fund (491)7,122,000 EMS Fees Airport Authority Capital Fund (496)4,146,200 User Fees Information Technology Capital Fund (506)5,414,400 Internal Service Charges Motor Pool Capital Recovery Fund (523)18,549,200 User Fees Tourist Development Capital Projects (758)836,400 Tourist Development (TDC) tax Immokalee CRA Capital Fund (786)1,555,300 CRA Bayshore CRA Capital Fund (787)7,834,300 CRA 598,651,700 Ad Valorem Capital Projects MSTD Landscaping Projects Fund (112)8,272,500 County-wide Capital Projects Fund (301)41,613,500 Parks and Recreation Capital Projects Fund (306)12,542,600 Transportation Road & Bridge Capital Fund (310)32,599,900 Stormwater Capital Projects Fund (325)20,777,000 115,805,500 Total 1,438,252,900 16.F.3.a Packet Pg. 2977 Attachment: FY22 Proj roll to FY23 Exhibit A (23110 : Unspent FY 2022 Capital project and grant budgets into FY 2023)