Agenda 12/12/2017 Item #16F312/12/2017
EXECUTIVE SUMMARY
Recommendation to accept a report covering Hurricane Irma clean up and recovery expenses
OBJECTIVE: Accept a report covering Hurricane Irma expenses.
CONSIDERATIONS: Cleanup and restoration of the community in the aftermath of Hurricane Irma
continues, and there are no additional budget amendments required as part of this reporting period.
Sufficient FY 2018 budget exists as County work continues.
Attached is a complete summary of all FY 2017 and current to date FY 2018 Hurricane Irma budget
amendments. Cumulatively, all FY 2017 and FY 2018 budget amendments to date total $114,768,000.
The amount spent to date, including payroll, during FY 2017 and FY 2018 totals $28,266,200. The first
FEMA reimbursement package from the County is still in progress and County staff is working with our
consultant to expedite submittal. The amount of time between reimbursement submittal and deposit to
the County will be closely monitored. Establishing sufficient budget for clean up and restoration from this
event is not indicative of actual expenditures, 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 state and federal 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: Accept this report.
Prepared by: Mark Isackson, Director of Corporate Financial and Management Services, Office of
Management and Budget
ATTACHMENT(S)
1. Hurricane Irma BA recap of SAP (PDF)
12/12/2017
COLLIER COUNTY
Board of County Commissioners
Item Number: 16.F.3
Doc ID: 4340
Item Summary: Recommendation to accept a report covering Hurricane Irma clean up and
recovery expenses.
Meeting Date: 12/12/2017
Prepared by:
Title: Operations Coordinator – Office of Management and Budget
Name: Valerie Fleming
12/04/2017 3:30 PM
Submitted by:
Title: Operations Coordinator – Office of Management and Budget
Name: Valerie Fleming
12/04/2017 3:30 PM
Approved By:
Review:
Office of Management and Budget Valerie Fleming Level 3 OMB Gatekeeper Review Completed 12/04/2017 3:30 PM
Budget and Management Office Mark Isackson Additional Reviewer Completed 12/04/2017 3:41 PM
County Attorney's Office Jeffrey A. Klatzkow Level 3 County Attorney's Office Review Completed 12/04/2017 4:20 PM
County Manager's Office Leo E. Ochs Level 4 County Manager Review Completed 12/05/2017 9:41 AM
Board of County Commissioners MaryJo Brock Meeting Pending 12/12/2017 9:00 AM
Hurricane Irma Recap of SAP
H:\Hurricane Irma (Sept 10 2017)\Irma, cost of storm and recap of BAs.xlsx Irma Recap 11/27/2017
Approved &
Pending_
FY17 -Spent plus
Posted BA's
BA's
FY18 appropriations
Total Budget
Rolled frm
Spent &
as of of 11/27/2017
Det
Division
Fund LL
Proigt O..
FY 2017
Scent - FY2O17
FY17 to FY18
FY2O18
FY2�018_
A rAp opr_ia_ted
Spent F1f18
CO
Sheriff (transfer f
040 959010
ISA
7,000,000
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
87,953.91
GM
Landscaping
112 144257
50154
2,000,000
2,000,000.00
2,000,1300.00
274,836.37
AS
Haldeman Creek M.
164114-4258
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.
10,750.00
GM
Coastal Zone - Reac
195 110406
50154
350,000
89.44
349,910.56
350,000.00
79,558.46
AS
PIO
301'100150
50154
500,000
500,000.00
633,800
1,133,8DO.D0
1,365.4D
PUD
OMB - E -City Sewer,
301 101522
50154
50,000
50,000.00
50,000.00
3,382.013
PUD
Facilities Mgt
301 110434
50154
2,750,000
93,906.44
2,656,093.56
1,200,000
31950,000.00 1
1,697,262.88
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
341.36
PS
University Ext
301 157112
50154
40
100.4
100,000.00
100,400.00
2,958.27
GM
Transp E -city
301 163635
50154
-
-
250,000
250,00.00
-
PS
Parks
306 116360
50154
2450,000
3,308.40
2,446,691.60
2,450,000.00
590,520.99
GM
CDES
309 138939
50154
100,000
53,669.42
46,330.58
100,000.00
6,475.64
GM
!Transportation
310 163670
50154
1,050,000 .
75,266.74 _
974,733.26
900,000
1,950,000.00
384,022.42
PS
Museums
314 157494
50154
100,000
148.43F4',.1611,647.83
99,851.57
100,000.00
757.44
CM
Pelican Bay
322 183825
50154
1,000
95.89904.11
140,000
141,000.00
21,844.21
GM
Stormwater
325 172940
50154
150,000
150,000.00
150,000.00
-
PUD
Water
412 273512
50154
1,550,000
145,733.69404,266.31
1,000,000
2,550,000.00
184,160.26
PUD
Wastewater
414 263614
50154
5,050,000
438,352.17
1
7_,000,000
12,050,00_0.00
6,0_01,608.18
AS
CAT Enhancement
426 138336
50154
200,000 _
200,000.00
_200,000.00
16,1315.75
AS
Transp Disadvantag.
427 138337
50154
100,0OQ
100,000.00
100,000.00
24,173.27
PUD
Solid Waste
474 173415
50154
7,750,000
5,212.99
7,744,787.01
70,000,000
77,750,000.00
6,603,048.06
AS
EMS
491 144611
50154'
-
10,004
10,000.00.
2,464.52
GM
Airport
496.192341j
50154 _
200.000
12,743.01
187,256.99
200,000.00
1,574.80
AS
Fleet
523 192341j
50154
750,000
750,004.00
750,000.00
-
Subtotals
32,959,000
7,885,771.37
24,598,464.33
81,650,000
633,800
114,768,035.701
15,995,873.79
BA's Processed after
the Declaration
_
Total Spent and Appropriated
for H.
Irma
$xxx.xx FEMA Revenue
114,768,035.70 1
Total Operating Expenses (cash out the
door) in FY17 & FY18
$xxx.xx Transfer from another fund
23,881,645.16
Payroll (Sept2 - Oct 13, 2017)
$xxx.xx no revenue, moved $from another exp category
4,384,585.90
Total Expenses (cash out the door) in FY17 & FY18
$xxx.xx more than 1 BA, used 2 or more from the above
28,266,232.06
H:\Hurricane Irma (Sept 10 2017)\Irma, cost of storm and recap of BAs.xlsx Irma Recap 11/27/2017
Recap Hurricane Irma Budget Amendments
BUDGET
REVENUE
EXPENDITURE
AMENDMENT
INCREASE
INCREASE EXPLANATION FOR
Reso or Public
Source
Cat FUND
NUMBER
(DECREASE)
(DECREASE) APPROPRIATION
BCC meeting
Hearing Reso
303 -Emergency
Realloacted dollars from other cost centers within
Fund 003
Exp Disaster
17-744
38,000 Fund 003
CM BA's
301 -County Wide
Realloacted dollars from other project within Fund
Fund 301
Exp Capital
17-746
50,000 301
CM BA's
Realloacted dollars from other project within Fund
Fund 306
Exp 306 -Parks Capital
17-747
50,000 306
CM BA's
310 -Transportation
Realloacted dollars from other project within Fund
Fund 310
Exp Capital
17-748
50,000 310
CM BA's
325-Stormwater
Realloacted dollars from other project within Fund
Fund 325
Exp Capital
17-749
50,000 325
CM BA's
412 -Water User Fee
Realloacted dollars from other project within Fund
Fund 412
Exp Capital
17-750
50,000 412
CM BA's
414 -Sewer User Fee
Realloacted dollars from other project within Fund
Fund 414
Exp Capital
17-751
50,000 414
CM BA's
474 -Solid Waste
Realloacted dollars from other project within Fund
Fund 474
Exp Capital
17-752
50,000 474
CM BA's
496 -Airport Authority
Realloacted dollars from other project within Fund
Fund 496
Exp Capital
17-753
50,000 496
CM BA's
195 -Beach
Realloacted dollars from other project within Fund
Fund 195
Exp Reounrishment
17-755
50,000 195
CM BA's
303 -Emergency
FEMA Reimb
FEMA rev Disaster
17-756
500,000
500,000 To recognize FEMA funds for Huricane Irma
9/6/2017
9/6/2017
301 -County Wide
FEMA Reimb
FEMA rev 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
310 -Transportation
FEMA Reimb
FEMA rev Capital
17-759
1,000,000
1,000,000 To recognize FEMA funds for Huricane Irma
9/6/2017
9/6/2017
325-Stormwater
FEMA Reimb
FEMA rev Capital
17-760
100,000
100,000 To recognize FEMA funds for Huricane Irma
9/6/2017
9/6/2017
412 -Water User Fee
FEMA Reimb
FEMA rev Capital
17-761
500,000
500,000 To recognize FEMA funds for Huricane Irma
9/6/2017
9/6/2017
414 -Sewer User Fee
FEMA Reimb
FEMA rev Capital
17-762
500,000
500,000 To recognize FEMA funds for Huricane Irma
9/6/2017
9/6/2017
474 -Solid Waste
FEMA Reimb
FEMA rev Capital
17-763
2,000,000
2,000,000 To recognize FEMA funds for Huricane Irma
9/6/2017
9/6/2017
496 -Airport Authority
FEMA Reimb
FEMA rev Capital
17-764
100,000
100,000 To recognize FEMA funds for Huricane Irma
9/6/2017
9/6/2017
195 -Beach
FEMA Reimb
FEMA rev Reounrishment
17-765
100,000
100,000 To recognize FEMA funds for Huricane Irma
9/6/2017
9/6/2017
040 -Sheriff General
To transfer funds from fund 001 to the Sheriff for
Fund 001 Gen Fd Transfer Fund
17-766
4,000,000
4,000,000 Hurricane Irma related payroll expenditures
9/6/2017
10/10/2017
Fund 113 Com
309 -Comm Dev
To transfer (loan) funds from fund 113 to fund 309
Dev
Loan Capital
17-771
100,000
100,000 for Hurricane Irma related expenditures
9/28/2017
10/10/2017
195 -Beach
FEMA Reimb
FEMA rev Reounrishment
17-775
100,000
100,000 To recognize FEMA funds for Huricane Irma
9/28/2017
9/28/2017
301 -County Wide
FEMA Reimb
FEMA rev Capital
17-776
100,000
100,000 To recognize FEMA funds for Huricane Irma - Library
9/28/2017
9/28/2017
301 -County Wide
To recognize FEMA funds for Huricane Irma -
FEMA Reimb
FEMA rev Capital
17-777
100,000
100,000 University Extension
9/28/2017
9/28/2017
301 -County Wide
FEMA Reimb
FEMA rev Capital
17-778
100,000
100,000 To recognize FEMA funds for Huricane Irma - DAS
9/28/2017
9/28/2017
H:\Hurricane Irma (Sept 102017)\List of Hurricane Irma BA's 321-17.xlsx
1 of 3
11/27/2017
Recap Hurricane Irma Budget Amendments
BUDGET
REVENUE
EXPENDITURE
AMENDMENT
INCREASE
INCREASE EXPLANATION FOR
Reso or Public
Source
Cat FUND
NUMBER
(DECREASE)
(DECREASE) APPROPRIATION
BCC meeting
Hearing Reso
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
301 -County Wide
To transfer funds from fund 001 to fund 301 for
Fund 001 Gen Fd
Transfer Capital
17-780
2,200,000
2,200,000 Hurricane Irma related expenditures
9/28/2017
10/10/2017
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
412 -Water User Fee
FEMA Reimb
FEMA rev Capital
17-783
1,000,000
1,000,000 To recognize FEMA funds for Huricane Irma
9/28/2017
9/28/2017
414 -Sewer User Fee
FEMA Reimb
FEMA rev 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
474 -Solid Waste
To transfer (loan) funds from fund 414 to fund 374
Cap
Loan Capital
17-785
5,700,000
5,700,000 for Hurricane Irma related expenditures
9/28/2017
10/10/2017
496 -Airport Authority
FEMA Reimb
FEMA rev 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
040 -Sheriff General
To transfer funds from fund 001 to the Sheriff for
Fund 001 Gen Fd
Transfer Fund
17-794
3,000,000
3,000,000 Hurricane Irma related payroll expenditures
9/28/2017
10/10/2017
301 -County Wide
To recognize FEMA funds for Huricane Irma -
FEMA Reimb
FEMA rev Capital
17-796
50,000
50,000 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
195 -Beach
FEMA Reimb
FEMA rev Reounrishment
17-807
100,000
100,000 To recognize FEMA funds for Huricane Irma
9/28/2017
9/28/2017
301 -County Wide
To recognize FEMA funds for Huricane Irma -
FEMA Reimb
FEMA rev Capital
17-808
500,000
500,000 Consultants
9/28/2017
9/28/2017
426 -CAT
FEMA Reimb
FEMA rev Enhancement
17-809
200,000
200,000 To recognize FEMA funds for Huricane Irma
9/28/2017
9/28/2017
427 -Transportation
FEMA Reimb
FEMA rev Disadvantaged
17-810
100,000
100,000 To recognize FEMA funds for Huricane Irma
9/28/2017
9/28/2017
Realloacted dollars from other projects within Fund
Fund 322
Exp 322 -Pelican Bay Cap
17-924
1,000 322
CM BA's
301 -County Wide
17-796 18.
To recognize FEMA funds for Huricane Irma -
FEMA Reinb
FEMA rev Capital
007
20,000
20,000 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 FY38.
63,236
Net FY 17 budget spent or roll -forward into FY38
32,484,236
303 -Emergency
To transfer funds from fund 001 to fund 003 for
Fund 001 Gen Fd Transfer Disaster
18-013
50,000
50,000 Hurricane Irma related expenditures
CM BA's
164 -Haldeman Creek
FEMA Reimb
FEMA rev 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
003 -Emergency
Reserves
Exp Disaster
18-034
400,000 Reallocate Reserves
10/10/2017
NFA
301 -County Wide
To transfer funds from fund 001 to fund 301 for
Fund 001 Gen Fd Transfer Capital
18-028
250,000
250,000 Hurricane Irma related expenditures - Everglade City
9/26/2017
10/10/2017
Fund 414 WW
To transfer funds from fund 414 to fund 473 for
Cap
Loan 474 -Solid Waste
18-030
30,000,000
30,000,000 Hurricane Irma related expenditures
10/10/2017
10/10/2017
H:\Hurricane Irma (Sept 102017)\List of Hurricane Irma BA's 421-17.1.
2 of 3
11/27/2017
Recap Hurricane Irma Budget Amendments
H:\Hurricane Irma (Sept 102017)\List of Hurricane Irma aA's 322-17.zlsx 3 of 3 11/27/2017
BUDGET
REVENUE
EXPENDITURE
AMENDMENT
INCREASE
INCREASE EXPLANATION FOR
Reso or Public
Source
Cat FUND
NUMBER
(DECREASE)
(DECREASE) APPROPRIATION
BCC meeting
Hearing Reso
Realloacted dollars from other projects within Fund
Fund 322
Exp 322 -Pelican Bay Cap
18-035
50,000 322
CM BA's
Realloacted dollars from other projects within Fund
Fund 491
Exp 491 -EMS
18-038
10,000 491
CM BA's
310 -Transportation
Fund 310
FEMA rev Capital
18-043
900,000
900,000 To recognize FEMA funds for Huricane Irma
10/24/2017
10/24/2017
412 -Water User Fee
Realloacted dollars from other projects within Fund
Fund 412
Exp Capital
18-044
1,000,000 412
10/24/2017
414 -Sewer User Fee
Realloacted dollars from other projects within Fund
Fund 414
Exp Capital
18-045
7,000,000 414
10/24/2017
301 -County Wide
To recognize FEMA funds for Huricane Irma - Fac
FEMA Reimb
FEMA rev Capital
18-048
1,200,000
1,200,000 Mgt
10/24/2017
10/24/2017
Realloacted dollars from other projects within Fund
Fund 322
Exp 322 -Pelican Bay Cap
18-057
40,000 322
CM BA's
Realloacted dollars from other projects within Fund
Fund 322
Exp 322 -Pelican Bay Cap
18-093
50,000 322
CM BA's
To recognize FEMA funds for Huricane Irma - Fac
FEMA Reimb
FEMA rev 474 -Solid Waste
18-121
40,000,000
40,000,000 Mgt
11/14/2017
11/14/2017
301 -County Wide
To recognize FEMA funds for Huricane Irma -
FEMA Reimb
FEMA rev Capital
18-123
633,800
633,800 Consultants
11/14/2017
12/12/2017
Total Spent/ Budgeted for Hurricane Irma in FY17 & FY18
114,768,036
H:\Hurricane Irma (Sept 102017)\List of Hurricane Irma aA's 322-17.zlsx 3 of 3 11/27/2017