Agenda 01/23/2018 Item #16F501/23/2018
EXECUTIVE SUMMARY
Recommendation to authorize additional FY 2018 budget amendments covering post Hurricane
Irma clean up and recovery for repairs to the 800 MHz public safety communication system and
the storm-water network.
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 two (2) additional FY 2018 budget amendments as follows;
1. $193,800 to cover repairs to the public safety communication system
2. $12,500,000 to cover removal of debris and clearing numerous canals throughout the storm-
water network
Attached to this report is a complete summary of all FY 2017 and current to date FY 2018 budget
amendments processed because of Hurricane Irma including the two (2) budget amendments covered in
this executive summary. Cumulatively, all non - payroll FY 2017 and FY 2018 budget amendments to
date total $169,089,600. Including payroll expenses associated with the event (9/2/17 to 10/13/17) of
$4,384,600, total event expenses and outstanding appropriations total $173,474,200. The amount spent to
date during FY 2017 and FY 2018 totals $73,490,000. Reimbursement revenue from insurance proceeds
booked to the wastewater system totals $85,500. Establishing sufficient budget for clean up and
restoration from this event is not indicative of what will be spent simply a barometer of anticipated
expenses.
FISCAL IMPACT: Establishing budget in the amount of $173.5 million has required a combination of
financial management steps not the least of which is the deferral/postponement of capital projects
particularly in the public utility and storm-water area and a reduction of FY 2017 and FY 2018 General
Fund reserves totaling $22.0 million. These reserve reductions were primarily necessary to minimize the
deferral of capital projects. Where necessary and appropriate in funds with sufficient cash, FEMA
revenue has been budgeted anticipating some level of reimbursement later in FY 2018 and in FY 2019.
Eventually, FEMA revenue and other reimbursement revenue will be received into the accounting system.
This reimbursement revenue will be booked initially to the fund where the expense was incurred and
subsequent budget adjustments will be processed to make whole various donating funds with a priority to
re-establish depleted reserves and re-appropriate capital budgets which were reduced.
The County has sufficient resources to cash flow the required clean up and restoration work given the
necessary financial management steps outlined above 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 in all affected
funds.
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: Authorize two (2) FY 2018 budget amendments covering post Hurricane Irma
16.F.5
Packet Pg. 490
01/23/2018
clean up and recovery for repairs to the 800 MHz public safety communication system and clearing
numerous canals within the storm-water network.
Prepared by: Mark Isackson, Director of Corporate Finance and Management Services, Office of
Management and Budget
ATTACHMENT(S)
1. Irma, recap of BAs (PDF)
2. List of Hurricane Irma BA's (PDF)
16.F.5
Packet Pg. 491
01/23/2018
COLLIER COUNTY
Board of County Commissioners
Item Number: 16.F.5
Doc ID: 4523
Item Summary: Recommendation to authorize additional FY 2018 budget amendments covering
post Hurricane Irma clean up and recovery for repairs to the 800 MHz public safety communication
system and the storm-water network.
Meeting Date: 01/23/2018
Prepared by:
Title: Operations Coordinator – Office of Management and Budget
Name: Valerie Fleming
01/16/2018 2:01 PM
Submitted by:
Title: Operations Coordinator – Office of Management and Budget
Name: Valerie Fleming
01/16/2018 2:01 PM
Approved By:
Review:
Office of Management and Budget Valerie Fleming Level 3 OMB Gatekeeper Review Completed 01/16/2018 2:01 PM
Budget and Management Office Mark Isackson Additional Reviewer Completed 01/16/2018 2:15 PM
County Attorney's Office Jeffrey A. Klatzkow Level 3 County Attorney's Office Review Completed 01/16/2018 2:15 PM
County Manager's Office Leo E. Ochs Level 4 County Manager Review Completed 01/16/2018 3:01 PM
Board of County Commissioners MaryJo Brock Meeting Pending 01/23/2018 9:00 AM
16.F.5
Packet Pg. 492
Hurricane Irma Recap (Per SAP)
Approved &Pending FY17 - Spent plus
Posted BA's BA's FY18 appropriations as of 1/14/2018 as of 1/14/2018 as of 1/14/2018
Total Budget Rolled frm (need BA)Spent & as of 1/14/2018 Ins Proceeds FEMA Rev Unreimbursed
Dept Division Fund CC Project #FY 2017 Spent - FY2017 FY17 to FY18 FY2018 FY2018 Appropriated Spent _ FY18 ComItem 369130 ComItem 331220 Exp(FY17+18)-Rev
CO Sheriff (transfer frm 001)040 959010 NA 7,000,000 7,000,000.00 - 7,000,000.00 - 7,000,000.00
AS Emergency Mgt 003 144256 NA 538,000 50,678.70 12,557.00 450,000 513,235.70 139,934.09 190,612.79
GM Landscaping 112 144257 50154 2,000,000 2,000,000.00 2,000,000.00 560,971.07 560,971.07
AS Haldeman Creek MSTU 164 144258 NA - - 100,000 100,000.00 - -
CM Immokalee CRA 186 144260 NA - - 100,000 100,000.00 - -
CM Bayshore CRA 187 144259 NA - - 500,000 500,000.00 39,950.00 39,950.00
GM Coastal Zone - Beaches 195 110406 50154 350,000 89.44 349,910.56 1,320,000 1,670,000.00 274,884.13 274,973.57
AS PIO 301 100150 50154 500,000 500,000.00 633,800 1,133,800.00 2,605.00 2,605.00
PUD OMB - E-City Sewer 301 101522 50154 50,000 50,000.00 50,000.00 7,264.50 7,264.50
PUD Facilities Mgt 301 110434 50154 2,750,000 93,906.44 2,656,093.56 1,700,000 4,450,000.00 2,840,408.14 2,934,314.58
AS 800 MHz 301 140482 50154 20,000 6,546.71 13,453.29 193,800 213,800.00 4,067.01 10,613.72
PS Animal Services 301 155411 50154 100,000 19.34 99,980.66 100,000.00 - 19.34
PS Library 301 156114 50154 100,000 100,000.00 100,000.00 341.36 341.36
PS University Ext 301 157112 50154 100,000 100,000.00 100,000.00 15,255.39 15,255.39
GM Transp E-city 301 163635 50154 - - 250,000 250,000.00 9,012.50 9,012.50
PS Parks 306 116360 50154 2,450,000 3,308.40 2,446,691.60 4,700,000 7,150,000.00 963,241.16 966,549.56
GM CDES 309 138939 50154 100,000 53,669.42 46,330.58 100,000.00 6,698.87 60,368.29
GM Transportation 310 163670 50154 1,050,000 75,266.74 974,733.26 900,000 1,950,000.00 700,048.69 775,315.43
PS Museums 314 157494 50154 100,000 148.43 99,851.57 100,000.00 757.44 905.87
CM Pelican Bay 322 183825 50154 1,000 95.89 904.11 240,000 241,000.00 99,309.15 99,405.04
GM Stormwater 325 172940 50154 150,000 150,000.00 5,000,000 12,500,000 17,650,000.00 - -
PUD Water 412 273512 50154 1,550,000 145,733.69 1,404,266.31 1,000,000 2,550,000.00 204,152.95 349,886.64
PUD Wastewater 414 263614 50154 5,050,000 438,352.17 4,611,647.83 9,000,058 14,050,057.57 9,109,440.22 85,500.00 9,462,292.39
AS CAT Enhancement 426 138336 50154 200,000 200,000.00 200,000.00 16,961.45 16,961.45
AS Transp Disadvantage 427 138337 50154 100,000 100,000.00 100,000.00 30,111.75 30,111.75
PUD Solid Waste 474 173415 50154 7,750,000 5,212.99 7,744,787.01 98,007,700 105,757,700.00 46,167,090.21 46,172,303.20
AS EMS 491 144611 50154 - 10,000 10,000.00 2,464.52 2,464.52
GM Airport 496 192341 50154 200,000 12,743.01 187,256.99 200,000.00 24,682.45 37,425.46
AS Fleet 523 192341 50154 750,000 750,000.00 750,000.00 - - -
Subtotals 32,959,000 7,885,771.37 24,598,464.33 123,911,558 12,693,800 169,089,593.27 61,219,652.05 85,500.00 - 69,019,923.42
BA's Processed after the Declaration
Payroll (Sept2 - Oct 13, 2017)4,384,586.90 4,384,586.90 4,384,586.90
FY 17 non-PR expenses 7,885,771.37
Total Spent and Appropriated for H. Irma 173,474,180.17
Total Expenses (cash out the door) in FY17 & FY18 73,490,010.32 85,500.00 - 73,404,510.32
$xxx.xx FEMA Revenue -
$xxx.xx Transfer from another fund
$xxx.xx no revenue, moved $ from another exp category
$xxx.xx 2 or more BA's used from the above list (FEMA, Transf, exp to exp)
H:\Hurricane Irma (Sept 10 2017)\Irma, cost of storm and recap of BAs.xlsx Irma Recap 1/16/2018
16.F.5.a
Packet Pg. 493 Attachment: Irma, recap of BAs (4523 : Recommendation to authorize additional FY 2018 budget
Recap Hurricane Irma Budget Amendments
Source Cat FUND
BUDGET
AMENDMENT
NUMBER
REVENUE
INCREASE
(DECREASE)
EXPENDITURE
INCREASE
(DECREASE)
EXPLANATION FOR
APPROPRIATION BCC meeting
Reso or Public
Hearing Reso
Fund 003 Exp
303-Emergency
Disaster 17-744 38,000
Realloacted dollars from other cost centers within
Fund 003 CM BA's
Fund 301 Exp
301-County Wide
Capital 17-746 50,000
Realloacted dollars from other project within Fund
301 CM BA's
Fund 306 Exp 306-Parks Capital 17-747 50,000
Realloacted dollars from other project within Fund
306 CM BA's
Fund 310 Exp
310-Transportation
Capital 17-748 50,000
Realloacted dollars from other project within Fund
310 CM BA's
Fund 325 Exp
325-Stormwater
Capital 17-749 50,000
Realloacted dollars from other project within Fund
325 CM BA's
Fund 412 Exp
412-Water User Fee
Capital 17-750 50,000
Realloacted dollars from other project within Fund
412 CM BA's
Fund 414 Exp
414-Sewer User Fee
Capital 17-751 50,000
Realloacted dollars from other project within Fund
414 CM BA's
Fund 474 Exp
474-Solid Waste
Capital 17-752 50,000
Realloacted dollars from other project within Fund
474 CM BA's
Fund 496 Exp
496-Airport Authority
Capital 17-753 50,000
Realloacted dollars from other project within Fund
496 CM BA's
Fund 195 Exp
195-Beach
Reounrishment 17-755 50,000
Realloacted dollars from other project within Fund
195 CM BA's
FEMA Reimb FEMA rev
303-Emergency
Disaster 17-756 500,000 500,000 To recognize FEMA funds for Huricane Irma 9/6/2017 9/6/2017
FEMA Reimb FEMA rev
301-County Wide
Capital 17-757 500,000 500,000 To recognize FEMA funds for Huricane Irma 9/6/2017 9/6/2017
FEMA Reimb FEMA rev 306-Parks Capital 17-758 500,000 500,000 To recognize FEMA funds for Huricane Irma 9/6/2017 9/6/2017
FEMA Reimb FEMA rev
310-Transportation
Capital 17-759 1,000,000 1,000,000 To recognize FEMA funds for Huricane Irma 9/6/2017 9/6/2017
FEMA Reimb FEMA rev
325-Stormwater
Capital 17-760 100,000 100,000 To recognize FEMA funds for Huricane Irma 9/6/2017 9/6/2017
FEMA Reimb FEMA rev
412-Water User Fee
Capital 17-761 500,000 500,000 To recognize FEMA funds for Huricane Irma 9/6/2017 9/6/2017
FEMA Reimb FEMA rev
414-Sewer User Fee
Capital 17-762 500,000 500,000 To recognize FEMA funds for Huricane Irma 9/6/2017 9/6/2017
FEMA Reimb FEMA rev
474-Solid Waste
Capital 17-763 2,000,000 2,000,000 To recognize FEMA funds for Huricane Irma 9/6/2017 9/6/2017
FEMA Reimb FEMA rev
496-Airport Authority
Capital 17-764 100,000 100,000 To recognize FEMA funds for Huricane Irma 9/6/2017 9/6/2017
FEMA Reimb FEMA rev
195-Beach
Reounrishment 17-765 100,000 100,000 To recognize FEMA funds for Huricane Irma 9/6/2017 9/6/2017
Fund 001 Gen Fd Transfer
040-Sheriff General
Fund 17-766 4,000,000 4,000,000
To transfer funds from fund 001 to the Sheriff for
Hurricane Irma related payroll expenditures 9/6/2017 10/10/2017
Fund 113 Com
Dev Loan
309-Comm Dev
Capital 17-771 100,000 100,000
To transfer (loan) funds from fund 113 to fund 309
for Hurricane Irma related expenditures 9/28/2017 10/10/2017
FEMA Reimb FEMA rev
195-Beach
Reounrishment 17-775 100,000 100,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
FEMA Reimb FEMA rev
301-County Wide
Capital 17-776 100,000 100,000 To recognize FEMA funds for Huricane Irma - Library 9/28/2017 9/28/2017
FEMA Reimb FEMA rev
301-County Wide
Capital 17-777 100,000 100,000
To recognize FEMA funds for Huricane Irma -
University Extension 9/28/2017 9/28/2017
FEMA Reimb FEMA rev
301-County Wide
Capital 17-778 100,000 100,000 To recognize FEMA funds for Huricane Irma - DAS 9/28/2017 9/28/2017
FEMA Reimb FEMA rev 314-Museum Capital 17-779 100,000 100,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
Fund 001 Gen Fd Transfer
301-County Wide
Capital 17-780 2,200,000 2,200,000
To transfer funds from fund 001 to fund 301 for
Hurricane Irma related expenditures 9/28/2017 10/10/2017
H:\Hurricane Irma (Sept 10 2017)\List of Hurricane Irma BA's 9-21-17.xlsx 1 of 3 1/16/2018
16.F.5.b
Packet Pg. 494 Attachment: List of Hurricane Irma BA's (4523 : Recommendation to authorize additional FY 2018 budget amendments covering post Hurricane
Recap Hurricane Irma Budget Amendments
Source Cat FUND
BUDGET
AMENDMENT
NUMBER
REVENUE
INCREASE
(DECREASE)
EXPENDITURE
INCREASE
(DECREASE)
EXPLANATION FOR
APPROPRIATION BCC meeting
Reso or Public
Hearing Reso
FEMA Reimb FEMA rev 306-Parks Capital 17-782 1,900,000 1,900,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
FEMA Reimb FEMA rev
412-Water User Fee
Capital 17-783 1,000,000 1,000,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
FEMA Reimb FEMA rev
414-Sewer User Fee
Capital 17-784 4,500,000 4,500,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
Fund 414 WW
Cap Loan
474-Solid Waste
Capital 17-785 5,700,000 5,700,000
To transfer (loan) funds from fund 414 to fund 374
for Hurricane Irma related expenditures 9/28/2017 10/10/2017
FEMA Reimb FEMA rev
496-Airport Authority
Capital 17-787 50,000 50,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
FEMA Reimb FEMA rev 523-Fleet 17-788 750,000 750,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
Fund 001 Gen Fd Transfer
040-Sheriff General
Fund 17-794 3,000,000 3,000,000
To transfer funds from fund 001 to the Sheriff for
Hurricane Irma related payroll expenditures 9/28/2017 10/10/2017
FEMA Reimb FEMA rev
301-County Wide
Capital 17-796 50,000 50,000
To recognize FEMA funds for Huricane Irma -
Everglades City Utility Study 9/28/2017 9/28/2017
FEMA Reimb FEMA rev 112-Landscape Cap 17-802 2,000,000 2,000,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
FEMA Reimb FEMA rev
195-Beach
Reounrishment 17-807 100,000 100,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
FEMA Reimb FEMA rev
301-County Wide
Capital 17-808 500,000 500,000
To recognize FEMA funds for Huricane Irma -
Consultants 9/28/2017 9/28/2017
FEMA Reimb FEMA rev
426-CAT
Enhancement 17-809 200,000 200,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
FEMA Reimb FEMA rev
427-Transportation
Disadvantaged 17-810 100,000 100,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
Fund 322 Exp 322-Pelican Bay Cap 17-924 1,000
Realloacted dollars from other projects within Fund
322 CM BA's
FEMA Reimb FEMA rev
301-County Wide
Capital
17-796
18-007 20,000 20,000
To recognize FEMA funds for Huricane Irma -
800MHz System CM BA's 10/10/2017
Total Budget Amendments Processed in FY 2017 32,959,000
Fund 003 Irma budget is $538,000, only spent $50,678.70 and open PO's of $12,557.00, (538,000) (Cost Center budgets are not carried-forward into the new FY)
balance of budget will not roll forward into FY18.63,236
Net FY 17 budget spent or roll-forward into FY18 32,484,236
Fund 001 Gen Fd Transfer
303-Emergency
Disaster 18-013 50,000 50,000
To transfer funds from fund 001 to fund 003 for
Hurricane Irma related expenditures CM BA's
FEMA Reimb FEMA rev
164-Haldeman Creek
MSTU 18-012 100,000 100,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
FEMA Reimb FEMA rev 186-Immokalee CRA 18-014 100,000 100,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
FEMA Reimb FEMA rev 187-Bayshore CRA 18-015 500,000 500,000 To recognize FEMA funds for Huricane Irma 9/28/2017 9/28/2017
Reserves Exp
003-Emergency
Disaster 18-034 400,000 Reallocate Reserves 10/10/2017 NFA
Fund 001 Gen Fd Transfer
301-County Wide
Capital 18-028 250,000 250,000
To transfer funds from fund 001 to fund 301 for
Hurricane Irma related expenditures - Everglade City 9/26/2017 10/10/2017
Fund 414 WW
Cap Loan 474-Solid Waste 18-030 30,000,000 30,000,000
To transfer funds from fund 414 to fund 473 for
Hurricane Irma related expenditures 10/10/2017 10/10/2017
Fund 322 Exp 322-Pelican Bay Cap 18-035 50,000
Realloacted dollars from other projects within Fund
322 CM BA's
Fund 491 Exp 491-EMS 18-038 10,000
Realloacted dollars from other projects within Fund
491 CM BA's
Fund 310 FEMA rev
310-Transportation
Capital 18-043 900,000 900,000 To recognize FEMA funds for Huricane Irma 10/24/2017 10/24/2017
Fund 412 Exp
412-Water User Fee
Capital 18-044 1,000,000
Realloacted dollars from other projects within Fund
412 10/24/2017
H:\Hurricane Irma (Sept 10 2017)\List of Hurricane Irma BA's 9-21-17.xlsx 2 of 3 1/16/2018
16.F.5.b
Packet Pg. 495 Attachment: List of Hurricane Irma BA's (4523 : Recommendation to authorize additional FY 2018 budget amendments covering post Hurricane
Recap Hurricane Irma Budget Amendments
Source Cat FUND
BUDGET
AMENDMENT
NUMBER
REVENUE
INCREASE
(DECREASE)
EXPENDITURE
INCREASE
(DECREASE)
EXPLANATION FOR
APPROPRIATION BCC meeting
Reso or Public
Hearing Reso
Fund 414 Exp
414-Sewer User Fee
Capital 18-045 7,000,000
Realloacted dollars from other projects within Fund
414 10/24/2017
FEMA Reimb FEMA rev
301-County Wide
Capital 18-048 1,200,000 1,200,000
To recognize FEMA funds for Huricane Irma - Fac
Mgt 10/24/2017 10/24/2017
Fund 322 Exp 322-Pelican Bay Cap 18-057 40,000
Realloacted dollars from other projects within Fund
322 CM BA's
Fund 322 Exp 322-Pelican Bay Cap 18-093 50,000
Realloacted dollars from other projects within Fund
322 CM BA's
FEMA Reimb FEMA rev 474-Solid Waste 18-121 40,000,000 40,000,000
To recognize FEMA funds for Huricane Irma - Fac
Mgt 11/14/2017 11/14/2017
FEMA Reimb FEMA rev
301-County Wide
Capital 18-123 633,800 633,800
To recognize FEMA funds for Huricane Irma -
Consultants 11/14/2017 12/12/2017
Fund 322 Exp 322-Pelican Bay Cap 18-158 50,000
Realloacted dollars from other projects within Fund
322 CM BA's
Fund 414 Exp
414-Sewer User Fee
Capital 18-160 1,000,000
Realloacted dollars from other projects within Fund
414 1/9/2018
Fund 195 Exp
195-Beach
Reounrishment 18-161 1,320,000 Reallocate Reserves 12/12/2017
Fund 310 Transp
& Exp
Loan &
Exp
325-Stormwater
Capital 18-166 1,950,000 5,000,000
To transfer $1,950,000 from fund 310 AND
reallocate $3,050,000 from other proj within fd 325
for Hurricane Irma related expenditures 1/9/2018 1/9/2018
Loans & Exp
Loan &
Exp 474-Solid Waste 18-168 21,007,700 28,007,700
To transfer $2.5m from fd 470; $3.5m from fd 473;
$1,007,700 from fd 414; $4m from fd 412; $10m
from fd 001 AND reallocate $7m from other proj
within fd 474 for debris related expenes 1/9/2018 1/9/2018
Fund 414 Exp
414-Sewer User Fee
Capital 18-173 1,000,058
Realloacted dollars from other projects within Fund
414 1/9/2018
FEMA Reimb FEMA rev
301-County Wide
Capital 18-178 500,000 500,000
To recognize FEMA funds for Huricane Irma -
Facilities Mgt 1/9/2018 1/9/2018
Fund 001 & 111
General Fund
Transfer &
FEMA Rev 306-Parks Capital 18-181 4,700,000 4,700,000
To transfer $2.5m from fd 001; $22,500 from fd 111
AND recognize $2,177,500 FEMA funds for Huricane
Irma 1/9/2018 1/9/2018
Fund 322 Exp 322-Pelican Bay Cap 18-200 50,000
Realloacted dollars from other projects within Fund
322 CM BA's
FEMA Reimb FEMA rev
301-County Wide
Capital 18-201 193,800 193,800
To recognize FEMA funds for Huricane Irma -
800MHz System 1/23/2018 1/23/2018
Fund 313 Transp
Cap Loan
325-Stormwater
Capital 18-209 12,500,000 12,500,000
To transfer $12.5m from fund 313 for Hurricane
Irma related expenditures 1/9/2018 1/9/2018
Total Spent/ Budgeted for Hurricane Irma in FY17 & FY18 169,089,593.27
H:\Hurricane Irma (Sept 10 2017)\List of Hurricane Irma BA's 9-21-17.xlsx 3 of 3 1/16/2018
16.F.5.b
Packet Pg. 496 Attachment: List of Hurricane Irma BA's (4523 : Recommendation to authorize additional FY 2018 budget amendments covering post Hurricane