Item D10M
C ounty of f Monroe
ELj » °o
�
BOARD OF COUNTY COMMISSIONERS
/�
�
Mayor David Rice, District 4
Th e Florida Keys
Mayor Pro Tem Sylvia J. Murphy, District 5
Danny L. Kolhage, District 1
George Neugent, District 2
Heather Carruthers, District 3
County Commission Meeting
February 21, 2018
Agenda Item Number: D.10
Agenda Item Summary #3930
BULK ITEM: Yes DEPARTMENT: Budget and Finance
TIME APPROXIMATE: STAFF CONTACT: Julie Cuneo (305) 292 -4460
N/A
AGENDA ITEM WORDING: Report of Hurricane Irma finance activity by the Office of
Management and Budget.
ITEM BACKGROUND:
PREVIOUS RELEVANT BOCC ACTION:
CONTRACT /AGREEMENT CHANGES:
N/A
STAFF RECOMMENDATION:
DOCUMENTATION:
OMB Report to BOCC 2 21 18 Meeting on Hurricane Irma finance activity REVISED
FINANCIAL IMPACT:
Effective Date:
Expiration Date:
Total Dollar Value of Contract:
Total Cost to County:
Current Year Portion:
Budgeted:
Source of Funds:
CPI:
Indirect Costs:
Estimated Ongoing Costs Not Included in above dollar amounts:
Revenue Producing:
Grant:
County Match:
Insurance Required:
Additional Details:
If yes, amount:
N/A
REVIEWED BY:
Kathy Peters Completed 02/06/2018 7:00 PM
Board of County Commissioners Pending 02/21/2018 9:00 AM
FULL REPORT Hurricane Irma Finance Report - Daily Estimates
Today's Date Total Estimated Expenses (Cummulativ )
February 6, 2018 $43,373,942
Monroe County Expenses (Estimate) Estimated Costs By Category -�' {l� Hurricane Irma
n Payments
$17,837,674
F Labor Camps Missions
$2,668,308 $_ $1,990,791
Debris
Removal
100
90
80
70
60
50
40
30
20
10
0
Resource Requests Processed
Supply Activity Transaction Total 1473
r °i Gq; n r4 Gal 'S7 C7
Resource Request Missions 434
Missions filled with an EOC PO 37
O Hurricane Request to Purchase 78
)
x
rq C4 C-4 rq
Resource Request Informational Missions 13
Missions with no action taken 94
Direct Purchases /Audit Slips 817
Office of Management and Budget
U—
M
E
�s
total Submitted as of 1129118: $8,818,634.27
Total Category A: $5,162,544.00
Total Category 13: $3,656,090.27
Office of Management and Budget
Date Uploaded to
Project Cost
Project Obligated>
Project ID
FEMA Portal
Description of Project
Submitted
by FEMA
MC -B -003
FEMA5072
11/14/2017
Force Account Labor 100% Cost Share
$2,667,613.65
MC -B -021
FEMA9386
12/1/2017
Satellite Systems 100% Cost Share
$102,586.00
MC -B -019
FEMA8880
12/1/2017
Fire /Rescue Medical Supplies 100% Cost Share
$110,477.79
MC -B -018
FEMA9657
12/1/2017
Temporary Sanitary Facilities 100% Cost Share
$62,005.00
MC -B -010
Force Account Vehicle & Equipment 100% Cost
FEMA11613
1/13/2018
Share
$611,817.33
MC -A -023
FEMA11667
1/13/2018
Higgs Beach Sand Cleanup 100% Cost Share
$65,188.00
MC -B -015
Emergency Repairs of Roads and Bridges 100%
FEMA16549
1/13/2018
Cost Share
$11,780.00
MC -B -020
FEMA9376
1/13/2018
Temporary Fencing 100% Cost Share
$23,507.50
MC -A -002
1/25/2018
Debris 90% Cost Share
$5,097,356.00
Temporary Road Repair 75% Cost Share (labor,
road signs, orange cones, barricades, asphalt
MC -B -015
1/25/2018
and rock)
$66,303.00
total Submitted as of 1129118: $8,818,634.27
Total Category A: $5,162,544.00
Total Category 13: $3,656,090.27
Office of Management and Budget
Category A -- Debris
Description of Project Project Cost Estimate
Debris Removal 75% Cost Share
Total: $0
Category B -- Emergency and Protective Measures
Description of Project
Project Cost Estimate
Sheltering 100% Cost Share
$640,000
Materials, Supplies, Fuel and Travel Expenses 100% Cost
$200,000
Base Camps 100% Cost Share
$6,800,000
Debris 1 Push 100% Cost Share
$350,000
EOC Expenses 100% Cost Share
$900,000
Force Account Labor & Equipment & Materials Post 75% Cost
$1,000,000
Mold Testing & Remediation 100% and 75% Cost Share
$800,000
Other Post 30 days 75% Cost Share
$1,000,000
Total:
$11,690,000
Category C- -Roads and Bridges
Description of Project
Roads 75% Cost Share
Bridges 75% Cost Share
Total:
Project Cost Estimate
$500,000
$450,000
$950,000
Total of Projects Under Development for Submission:
$12,640,000
Office of Management and Budget
R �.
Office of Management and Budget
IC
(D
LL
M
E
LU
U)
LU
as
CU
E
CU
M
x
CD
as
co
04
04
L)
L)
0
ED
0
0
CL
0
4;
r-
4)
E
FY17
Actual
FY18
Actual
Total
FY17
Estm.
Obligated
FY18
Estm.
Obligated
Total
FEMA
Requested
Reimbursed
Grant Fund - Fund 126
125 0459110 Personnel $2,509,179
$328,036
$2,837,214
$2,511,538
$328,036
$2,839,573
$2,510,844
$0
125 0459110 Operating $785,306
$706,527
$1,491,832
$7,818,167
$4,506,113
$12,324,280
$1,030,157
$0
125 0459110 Capital $46,642
$2,545
$49,187
$46,642
$2,545
$49,187
$0
$0
Marathon Airport - Fund 403
403 635102 Personnel $30,116
$7,576
$37,692
$30,116
$7,576
$37,692
$30,116
$0
403 635102 Operating $3,505
$128,539
$132,044
$3,505
$128,539
$132,044
$23,508
$0
403 635102 Capital $0
$0
$0
$0
$0
$0
$0
$0
Key West Airport - Fund 404
404 630191 Personnel $77,258
$1,094
$78,352
$77,258
$1,094
$78,352
$77,258
$0
404 630191 Operating $28,516
$69,349
$97,865
$28,516
$115,798
$144,314
$0
$0
404 630191 Capital $0
$5,026
$5,026
$0
$5,026
$5,026
$0
$0
MSD Solid Waste - Fund 414
414 40003 Personnel $49,396
$1,883
$51,279
$49,396
$1,883
$51,279
$49,396
$0
414 40003 Operating $0
$6,876,546
$6,876,546
$1,074,017
$26,012,901
$27,086,917
$5,097,356
$0
414 40003 Capital $0
$0
$0
$0
$0
$0
$0
$0
TOTAL,
$3,629,917
$8,127,120
$11,667,037
1$11,639,164
1 $31,109,611
$42,748,666
$8,818,636
$0
Office of Management and Budget
IC
(D
LL
M
E
LU
U)
LU
as
CU
E
CU
M
x
CD
as
co
04
04
L)
L)
0
ED
0
0
CL
0
4;
r-
4)
E