Loading...
Agenda 10/10/2017 Item #16F1310/10/2017 EXECUTIVE SUMMARY Recommendation to approve additional FY 2018 budget amendments covering post Hurricane Irma clean up and recovery for the County-wide debris removal mission, funding for Everglades City pursuant to the recently approved inter-local agreement and certain cash flow requirements in Emergency Disaster Fund (003) OBJECTIVE: Establish sufficient FY 2018 budget providing for uninterrupted clean up and recovery post Hurricane Irma. CONSIDERATIONS: Funding cleanup and restoration of the community in the aftermath of Hurricane Irma continues and to that end, this executive summary requests approval for three additional FY 2018 budget amendments as follows; 1. $30,000,000 to continue funding the debris removal mission 2. $250,000 establishing budget for Everglades City assistance pursuant to the inter-local agreement 3. $50,000 transfer from the General Fund to Emergency Disaster Fund (003) for cash flow purposes Attached to this report is a complete summary of all FY 2017 and FY 2018 budget amendments processed in connection with Hurricane Irma including the three budget amendments covered in this executive summary. Cumulatively, all budget amendments to date total $63,890,500. The amount spent and/or encumbered totals $7.8 million. Establishing sufficient budget for clean up and restoration from this event is not indicative of what will actually be spent simply a barometer of anticipated expenses. FISCAL IMPACT: This Hurricane event will require a significant amount of County resources up front in anticipation of reimbursement in the coming months. The most significant component will be removing approximately 4.5 million cubic yards of debris from the community. The County has sufficient resources to cash flow the required clean up and restoration work and we are well positioned to submit for reimbursement for work performed to the appropriate agencies in a timely fashion. However, OMB will be monitoring the reimbursement stream closely and if necessary take appropriate mid -year budget management steps to always insure that sufficient year ending FY 2018 cash is maintained. LEGAL CONSIDERATIONS: This item has been reviewed by the County Attorney, is approved as to form and legality, and requires majority vote for approval. -JAK RECOMMENDATION: Approve three FY 2018 budget amendments covering post Hurricane Irma clean up and recovery for the County-wide debris removal mission, funding for Everglades City pursuant to the recently approved inter-local agreement and certain cash flow requirements in Emergency Disaster Fund (003). Prepared by: Mark Isackson, Director of Corporate Finance and Management Services, Office of Management and Budget ATTACHMENT(S) 1. Hurricane Irma BA recap-summary (PDF) 10/10/2017 COLLIER COUNTY Board of County Commissioners Item Number: 16.F.13 Doc ID: 3873 Item Summary: Recommendation to approve additional FY 2018 budget amendments covering post Hurricane Irma clean up and recovery for the County-wide debris removal mission, funding for Everglades City pursuant to the recently approved inter-local agreement and certain cash flow requirements in Emergency Disaster Fund (003). Meeting Date: 10/10/2017 Prepared by: Title: Operations Coordinator – Office of Management and Budget Name: Valerie Fleming 10/04/2017 8:19 AM Submitted by: Title: Operations Coordinator – Office of Management and Budget Name: Valerie Fleming 10/04/2017 8:19 AM Approved By: Review: Office of Management and Budget Valerie Fleming Level 3 OMB Gatekeeper Review Completed 10/04/2017 8:19 AM County Attorney's Office Jeffrey A. Klatzkow Level 3 County Attorney's Office Review Completed 10/04/2017 8:55 AM Budget and Management Office Mark Isackson Additional Reviewer Completed 10/04/2017 9:44 AM County Manager's Office Nick Casalanguida Level 4 County Manager Review Completed 10/04/2017 12:03 PM Board of County Commissioners MaryJo Brock Meeting Pending 10/10/2017 9:00 AM H:\FORMS\Budget amendments\Irma, cost of storm and recap of BAs.xlsx Sheet2 10/4/201-7 FY17 -10/2/2017 Rolled frm 10/01/17 10/03/17 Spent & Dept Division Fund CC Project # Total Budget-FY2017 Spent - FY2017 FY17 to FY18 FY2018 Appropriated CO Sheriff (transfer frm 040 959010 NA 7,000,000 7,000,000.00 - 7,000,000.00 AS Emergency Mgt 003 144256 NA 538,000 6,907.58 12,557.00 50,000 400,000 469,464.58 GM Landscaping 112 144257 50154 2,000,000 2,000,000.00 2,000,000.00 AS Haldeman Creek M 164 144258 NA - - 100,000 100,000.00 CM Immokalee CRA 186 144259 NA - - 100,000 100,000.00 Bayshore CRA 187 144260 NA - - 500,000 500,000.00 GM Coastal Zone - Bead 195 110406 50154 350,000 89.44 349,910.56 350,000.00 FCM AS PIO 301 100150 50154 500,000 500,000.00 500,000.00 AS 800 MHz 301 140482 50154 20,000 6,546.71 13,453.29 20,000.00 PS Animal Services 301 155411 50154 100,000 19.34 99,980.66 100,000.00 PS Library 301 156114 50154 100,000 100,000.00 100,000.00 PS University Ext 301 157112 50154 100,000 100,000.00 100,000.00 GM Transportation 301 163635 50154 250,000 250,000.00 PUD Facilities Mgt 301 110434 50154 2,750,000 93,906.44 2,656,093.56 2,750,000.00 PUD OMB - E -City 301 101522 50154 50,000 50,000.00 50,000.00 PS Parks 306 116360 50154 2,450,000 3,308.40 2,446,691.60 2,450,000.00 GM CDES 309 138939 50154 100,000 53,669.42 46,330.58 100,000.00 GM Transportation 310 163670 50154 1,050,000 75,266.74 974,733.26 1,050,000.00 PS Museums 314 157494 50154 100,000 148.43 991851.57 100,000.00 CM Pelican Bay 322 183825 50154 1,000 95.89 904.11 50,000 51,000.00 GM Stormwater 325 172940 50154 150,000 150,000.00 150,000.00 PUD Water 412 273512 50154 1,550,000 145,733.69 1,404,266.31 1,550,000.00 PUD Wastewater 414 263614 50154 5,050,000 438,352.17 4,611,647.83 5,050,000.00 AS CAT Enhancement 426 138336 50154 200,000 200,000.00 200,000.00 AS Transp Disadvantag 427 138337 50154 100,000 100,000.00 100,000.00 PUD Solid Waste 474 173415 50154 7,750,000 5,212.99 7,744,787.01 30,000,000 37,750,000.00 GM Airport 496 192341 50154 200,000 12,743.01 187,256.99 200,000.00 AS Fleet 523 192341 50154 750,000 750,000.00 750,000.00 Total as of 9/20/2017 BA's Processed after the Declaration 32,959,000 7,842,000.25 24,598,464.33 750,000 30,700,000.00 63,890,464.58 Total Cost of Irma as of 10/2/2017L63,890,464.58 H:\FORMS\Budget amendments\Irma, cost of storm and recap of BAs.xlsx Sheet2 10/4/201-7 Recap Hurricane Irma Budget Amendments ' BUDGET REVENUE EXPENDITURE AMENDMENT INCREASE INCREASE EXPLANATION FOR Source Cat FUND NUMBER (DECREASE) (DECREASE) APPROPRIATION Realloacted dollars from other cost centers within Fund 003 Exp 303 17-744 38,000 Fund 003 Emergency Disaster Realloacted dollars from other project within Fund Fund 301 Exp 301 17-746 50,000 301 County-wide Capital Realloacted dollars from other project within Fund Fund 306 Exp 306 17-747 50,000 306 Parks Capital Realloacted dollars from other project within Fund Fund 310 Exp 310 17-748 50,000 310 Transportation Capital Realloacted dollars from other project within Fund Fund 325 Exp 325 17-749 50,000 325 Stormwater Capital Realloacted dollars from other project within Fund Fund 412 Exp 412 17-750 50,000 412 Water Capital Realloacted dollars from other project within Fund Fund 414 Exp 414 17-751 50,000 414 Sewer Capital Realloacted dollars from other project within Fund Fund 474 Exp 474 17-752 50,000 474 Solid Waste Capital Realloacted dollars from other project within Fund Fund 496 Exp 496 17-753 50,000 496 Airport Capital Realloacted dollars from other project within Fund Fund 195 Exp 195 17-755 50,000 195 Beach Reounrishment FEMA Reimb Exp 303 17-756 500,000 500,000 To recognize FEMA funds for Huricane Irma Emergency Disaster Fd FEMA Reimb Exp 301 17-757 500,000 500,000 To recognize FEMAfunds for Huricane Irma County-wide Capital FEMA Reimb Exp 306 17-758 500,000 500,000 To recognize FEMA funds for Huricane Irma Parks Capital FEMA Reimb Exp 310 17-759 1,000,000 1,000,000 To recognize FEMA funds for Huricane Irma Transportation Capital FEMA Reimb Exp 325 17-760 100,000 100,000 To recognize FEMA funds for Huricane Irma Stormwater Capital FEMA Reimb Exp ,- 412 17-761 500,000 500,000 To recognize FEMA funds for Huricane Irma Water Capital FEMA Reimb Exp 414 17-762 500,000 500,000 To recognize FEMA funds for Huricane Irma Sewer Capital FEMA Reimb Exp 474 17-763 2,000,000 2,000,000 To recognize FEMA funds for Huricane Irma Solid Waste Capital H:\FORMS\Budget amendments\Humcane Irma BA's 9-21-17.xlsx Fund 001 Gen Fd Exp 040 17-766 4,000,000 Sheriff General Fd Fund 113 Com Dev Recap Hurricane Irma Budget Amendments 309 17-771 BUDGET REVENUE EXPENDITURE Community Development Capital AMENDMENT INCREASE INCREASE EXPLANATION FOR Source Cat FUND NUMBER (DECREASE) (DECREASE) APPROPRIATION FEMA Reimb Exp 496 17-764 100,000 100,000 To recognize FEMA funds for Huricane Irma 301 17-776 Airport Capital FEMA Reimb Exp 195 17-765 100,000 100,000 To recognize FEMA funds for Huricane Irma 301 17-777 Beach Reounrishment Fund 001 Gen Fd Exp 040 17-766 4,000,000 Sheriff General Fd Fund 113 Com Dev Exp 309 17-771 100,000 Loan Community Development Capital FEMA Reimb Exp 195 17-775 100,000 Beach Reounrishment FEMA Reimb Exp 301 17-776 100,000 County -wide Capital FEMA Reimb Exp 301 17-777 100,000 County -wide Capital FEMA Reimb Exp 301 17-778 100,000 County -wide Capital FEMA Reimb Exp 314 17-779 100,000 Museum Capital Fund 001 Gen Fd Exp 301 17-780 2,200,000 County -wide Capital FEMA Reimb Exp 306 17-782 1,900,000 Parks Capital FEMA Reimb Exp 412 17-783 1,000,000 Water Capital FEMA Reimb Exp 414 17-784 4,500,000 Wastewater Capital Fund 414 WW Cap Exp 474 17-785 5,700,000 Loan Solid Waste FEMA Reimb Exp 496 17-787 50,000 Aiprort Capital FEMA Reimb Exp 523 17-788 750,000 Fleet Fund 001 Gen Fd Exp 040 17-794 Sheriff's Agency FEMA Reimb Exp 301 17-796 County -wide Capital H:\FORMS\Budget amendments\HuMcane Irma BA's 9-21-17.xlsx To transfer funds from fund 001 to the Sheriff for 4,000,000 Hurricane Irma related payroll expenditures To transfer funds from fund 113 to fund 309 for 100,000 Hurricane Irma related expenditures 100,000 To recognize FEMA funds for Huricane Irma 100,000 To recognize FEMA funds for Huricane Irma -Library To recognize FEMA funds for Huricane Irma - 100,000 University Extension 100,000 To recognize FEMAfunds for Huricane Irma - DAS 100,000 To recognize FEMA funds for Huricane Irma To transfer funds from fund 001 to fund 301 for 2,200,000 Hurricane Irma related expenditures 1,900,000 To recognize FEMAfunds for Huricane Irma 1,000,000 To recognize FEMA funds for Huricane Irma 4,500,000 To recognize FEMAfunds for Huricane Irma To transfer funds from fund 414 to fund 374 for 5,700,000 Hurricane Irma related expenditures 50,000 To recognize FEMAfunds for Huricane Irma 750,000 To recognize FEMAfunds for Huricane Irma To transfer funds from fund 001 to the Sheriff for 3,000,000 3,000,000 Hurricane Irma related payroll expenditures To recognize FEMA funds for Huricane Irma - 50,000 50,000 Everglades City Utility Study Source FEMA Reimb FEMA Reimb FEMA Reimb FEMA Reimb FEMA Reimb Fund 322 Recap Hurricane Irma Budget Amendments Cat BUDGET AMENDMENT FUND NUMBER REVENUE INCREASE (DECREASE) EXPENDITURE INCREASE EXPLANATION FOR (DECREASE) APPROPRIATION Exp 112 17-802 2,000,000 2,000,000 To recognize FEMA funds for Huricane Irma 322 17-924 Landscaping Pelican Bay 100,000 100,000 To recognize FEMA funds for Huricane Irma Exp 195 17-807 100,000 100,000 To recognize FEMA funds for Huricane Irma 250,000 Beach Renourishment To transfer funds from fund 001 to fund 301 for Hurricane Irma related expenditures - Everglade City 30,000,000 30,000,000 To transfer funds from fund 414 to fund 374 for To recognize FEMA funds for Huricane Irma - Exp 301 17-808 500,000 500,000 Consultants County -wide Capital Exp 426 17-809 CAT Enhancement Exp 427 17-810 50,000 Transportation Disadvantaged Exp 322 17-924 100,000 Pelican Bay FEMA Reinb Exp 301 17-796 County -wide Capital Total Budget Amendments Processed in FY 2017 Fund 003, only spent $6,907.58 and open PO's of $12,557.00, balance of budget will not roll forward into FYi8. Net FY 17 budget spent or roll -forward into FY18 Fund 001 Gen Fd Exp 003 18-013 Emergency Disaster FEMA Reimb Exp 164 18-012 Haldeman Creek MSTU FEMA Reimb Exp 186 18-014 Immokalee CRA FEMA Reimb Exp 187 18-015 Bayshore CRA Reserves Exp 003 Emergency Disaster Fund 001 Gen Fd 301 County -wide Capital Fund 414 WW Cap 474 Loan Solid Waste Fund 322 322 Pelican Bay Total Spent/ Budgeted for Hurricane Irma in FY17 & FY18 H:\FORMS\Budget amehdments\Huricane Irma BA's 9-21-17.xlu 200,000 200,000 To recognize FEMA funds for Huricane Irma 100,000 100,000 To recognize FEMA funds for Huricane Irma Realloacted dollars from other projects within Fund 1,000 1,000 322 To recognize FEMA funds for Huricane Irma - 20,000 20,000 800MHz5ystem 63,890,465 32,959,000 (518,535) 32,440,465 50,000 50,000 To transfer funds from fund 001 to fund 003 for Hurricane Irma related expenditures 100,000 100,000 To recognize FEMA funds for Huricane Irma 100,000 100,000 To recognize FEMA funds for Huricane Irma 500,000 500,000 To recognize FEMA funds for Huricane Irma 400,000 Reallocate Reserves 250,000 250,000 To transfer funds from fund 001 to fund 301 for Hurricane Irma related expenditures - Everglade City 30,000,000 30,000,000 To transfer funds from fund 414 to fund 374 for Hurricane Irma related expenditures Realloacted dollars from other projects within Fund 50,000 322 63,890,465