Item D01 D.1
G BOARD OF COUNTY COMMISSIONERS
County of Monroe Mayor Heather Carruthers,District 3
IleOI1da Keys Mayor Pro Tern Michelle Coldiron,District 2
�p.° Craig Cates,District I
David Rice,District 4
Sylvia J.Murphy,District 5
County Commission Meeting
January 22, 2020
Agenda Item Number: D.1
Agenda Item Summary #6490
BULK ITEM: Yes DEPARTMENT: Budget and Finance
TIME APPROXIMATE: STAFF CONTACT: Julie Cuneo (305) 292-4460
No
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: N/A
DOCUMENTATION:
Hurricane Irma Financial Update as of 12 31 19
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:
Packet Pg. 721
D.1
Revenue Producing: If yes, amount:
Grant:
County Match:
Insurance Required:
Additional Details:
N/A
REVIEWED BY:
Tina Boan Completed 01/07/2020 4:33 PM
Kathy Peters Completed 01/07/2020 4:35 PM
Board of County Commissioners Pending 01/22/2020 9:00 AM
Packet Pg. 722
urricane rma
� nanc � a a e
Board of County Commission Meeting January 22, 2020
Projects Submitted to FEMA as of 12/31/19
FEMA CdC DLA R-
I_ A-1. 11.1.17 FEMA PdP. A-..
"Id- C11 11,DEM IIII
PdID Pld. D..-....P.P. FEMAR-- ...DEM
-1- supplig-
I EMA...-Id $1-1. $104465 wn $104465 $104465 $oreset ana fully Pam
Fennn9 I-C..
2 -do. -50. 8235os -50. $o
�nesyslems"'.
C
-I EM6 M 1. 111111017 11. $1"15.5 -902 -902 reset ana -
111.201. C I P.
fully
P.d
..dd.
I EMA 116.M 214 $61,- $61,263 200 :o d
E=I,,I-R...-
P-
.d......I. 03 d11
I EMA.5.M 1113 -201. p- d.. .13 .1,639 -
�41547 729 $o $3 Ad..m.D..Co.
snae
Cpemllons ceder and Co.snae
I EMA 341.M 15. 3112011 $111126 $-394 $1-95 Ad..m.D..
--nd d III C
FEMA 41-M2521 4-01. Co.�II -63. -63. CI4638 $- -.5. $o $ Ad;.g.. C
D.-
F.d and Co.
snae
.19 PI e K,AAdP 11 Col III
I EMA.0.-1. 911712011 .1952 $1 020 wn $I4020 - $o -Ad;.g..and Co.
..m.D.. snae
poIC
FEMA 37--10. 3.11201. �000'=,L..O''..Id .1999 do wn $41999 .1999 $o
12 FEMA.72- 1111.2017 d--Co. 614 V614 v166C- I
FEMA 6--14 411.2019 E EV $6014 $6,014 14 :o M.I..and--add
oz
,o III vl- I M.I..and F.ddd
M.I..'pado,P
I.nd.ng
�11.2019 $
FEMA.57M41 121112017 1.mare $12 $1,1 $Il 112 M053 $I,Ill
aaned Due
I�Ic-pm%cl-1�ICV-hl�I I h $111 111 $-111 pad"'P--
I EMA 11613 M 1. 11112011 E I NIA $-111 $111 $151,132 $,1,111 $2 111 lIA I.nd.ng
FEMA160.-24. 21112011 'Ot%
$201 1 $111111 NIA $111111 $111121 $211. lIA-,,ated-,C1,d
M.g..Padod�P.d and Co.
.AdPI.m.P--n
2� $ =1eAedd1=-2019 1 Z�22 1 WD, d Veh $,o I lIA $10 111 $2 Il I I D,e
$%127 82,173
Ihe te,n,-I-,-n 100%
2,FEMA 161.M1512 3112011 _ $1.111 lIA $1.111 $1$1934 fl,$5 lIA M.I..,Padodv P.d
M.ff
padol P
2,FEMA.5.-2- 211.201. M.S CO �41 -965 1965 $.13.6 I.nd.ng
Co=-.-1-9. Pa-
2,FEMA 36--4- 101311201.CO . .12.2 .1665 I.nd.ng
K padol P
21 -2019 -P 4,57.665 $1157. $11699
I ,,ndl d�t,Ct,te
21 10-2011 lIA -ol $-oi V�d�t, Zn
21 1111C201C C5=m-n,,-I IPC
l e I I d�t,Ct,te
1-2011 1 V�
1-2011 C.Ih- $1 21� 211 1 $1 211 1 Ct,te
12 1-2011 -1-ps I0%C.I-e -C lIA V�d�t,
I I d�t,Ct,te
I I d�t,Ct,te
lIA d�t,
�11 2 011 Un'l�M nC I
212 2 011 IPC C.Ih- $III 111 -1 2�1o�: lIA -1111 -1111 V�d1I
1-2011 P-1Cp p 'IoDEetC=e mare
pee- 2�1 lIA
,ndlZ n d Ct,to
-lend,n,lt�te
10-2011 IPC C.Ih,,e - $1 I I I ,,ndl d�t,Ct,te
I EPA-2 Ill 2-2011 -n.,t-nsIPCC-h,,e $III--$1 $111 1 oI $111 1 oI V�d�t,
PC
$1 11C oil $1 111 V� Zn
IIII lem-1 Clesdent,'l to
12 Ill-1I -,s-In,'-C.mare' �o'oZ' lIA $111111 $111111
I I ,,ndl d�t,Ct,te
5121 lIA d�t,112C201I =,K V� Zn
-2019 .1353 136 Idd, $131.01 $131.01 da.-on III,P
17,-
le-
FE.A
I EPA II1�O 1-251 5-2011 .-d-A,-IPC C.I-e $2 121 115 $1 210 111 $1 210 111
FE.A 1-51-0 5-2011 A,,p�l I0%C.I-e $1 Il 111 $1 $1 lIA Ct.e
lem-1 Clesdent,al
I EPA 111.1-5. Ill-11 -,s-In,)IPC C.Ih-' $511551 $511551 NIA lend,n,lee,I-ev,
em"" I Cle S d D-sl=,)'�01% Rsopient Final Review
$110 111 $151150 $151150 NIA
I EPA I110 I-OC Ill-11
I EPA.1.M 1201 121C201I Plne)10%cnosl snares .41,6.9 .41,6.9 NIA lend,n,CIC Imect Develftment
EPA III I-C 211-11 Ih"e $125- z=nF EPA Ins-n cel-1.1
EPA.1.1-511 1-2011 1,,s l e�c h Chmeent I dC $112 1: 1,nd 91"P
PC I�Veh
V51234 ndn -Pm'e 2'1'1h,'1'1eS 11,110%C.Ih,,e I $1112. lend,n,IDII I,—lev�-
e�
FE.A.1-MI1 �1�1201I I-e $1"1"1 $1"1"1 I.nd.ng EIP
FE.A-15 P-1 �-201I -A Co.C�hst,e $210112 $2 0112 Pend:ng-P.=nal R-M
51112011 1"` $-11 $-11
.CP11ICF,cI1--d-,s P.nd.ng..d-F-I R-m
I EPA 11201 P-1 Il 511-11 IPC C.Ih- W I- W I
FE.A I-C P-151 5-2011 1-1-10%C.Ih- VOI,2.5 VOI,2.5 P.nd.ng PDM.Pm,..R-m
IPI2-,s lem-1 Clesdent,al
FE.A 11115 P-521 Ill-1I s-1 n,)92% snare' $61 672 $61,672 P.nd.ng PDM.Pm,..Renee&FAE& s
12 1 EPA�1 001 61712011 I-e $1-.6 $1-.6 Pend n,CIC miceP,,, ,pment
-Oca C1 Road 90%as
=.P.nd.nd FEMA In .6
FE.A 11102 71212011 Shal
FE.A 1117. 101112011 Al,CuI-s C-Is III&111 $117565 $111565 P.nd.ng ENV R-m
RRRRR"RR"11
iii
F-16-M M ff" '11lI It,11,lo,se III,-Ih- $15 071 ,n Ap1 P,ocess
211 C201 I se 1— % 1- M Ap1 P,ocess'_ -I.- CC-'- $1-1. $0 -,- Idd- .5179. $2R281,007 -d89 1.82� :�61,540
L.MondI-.: $61,697 860 $3%957 $199" $o -19 .515- $4RI27 .2 271
d-n..: -1,361 $668 -779 VIZ.03 m $114so1 -011
A -1 L191SI-I-IS :nd I ddI P.d -.9- d P-d�P.d III III P.d.nd_
App-
P.
EEI Es-al El.m.s R-W..,p.-F-I P.nd.nd In FEMA-Pd-s
EMMIE FEMA D.a- In App..Pd.-
IN
-E
. at
JE
E E
E MIS
JE
az
UE
12.
a ®
- - - - ---- -- - - - - - - - - - -
S'E
UE
rc"E E E
2 2
E E
LL
R R R R W R =R W R R R W R R R F R LL R W R R R R R R
Lu . . .
- - - - - - - - - -
- - -- -- -- - - - - - -
S'E --- -- -- - - - - - -
- - -- -- -- - - - - - - -
- -- -- - - - - - - - -
2 2
( \\ �\.� �� \. \) \ } � } } } \ } { \\ \ \} \� \ �
\\ \\ \\\} \\ \} \} \ } \ } \ } ; ! ! \} } \\\\ \ \
\\\ ) \ } \}\\\\\- - -- -- -- - - - - - - - - - -
- - -- -- -- - - - -
- - -- -- -- - - - -
Paid Expenses by Fund as of 12/31 /19
Hurricane Irma Activity by Fund
FY17 FY18 FY19 FY20 Actual
Actual Actual Actual Actual Total
Grant Fund -Fund 125
125 0459110 Personnel $2,509,179 $686,520 $295,547 $45,488 $3,536,734
125 0459110 Operating $3,470,917 $8,363,910 $3,156,928 $203,543 $15,195,297
125 0459110 Capital $46,642 $24,551 $1,863,921 $36,918 $1,972,032
Total $6,026,738 $9,074,980 $5,316,396 $285,949 $20,704,062
Card Sound Road -Fund 401
401 22559 Personnel $0 $0 $0 $0 $0
401 22559 Operating $0 $13,175 $0 $0 $13,175
401 22559 Capital $0 $0 $0 $0 $0
Total $0 $13,175 $0 $0 $13,175
Marathon Airport-Fund 403
403 635102 Personnel $30,116 $8,607 $0 $985 $39,709
403 635102 Operating $3,505 $272,555 $403,768 $57,216 $737,044
403 635102 Capital $0 $0 $40,525 $0 $40,525
Total $33,621 $281,163 $444,292 $58,201 $817,277
Key West Airport-Fund 404
404 630191 Personnel $77,258 $1,094 $0 $0 $78,352
404 630191 Operating $28,516 $86,457 $16,198 $0 $131,171
404 630191 Capital $0 ($0.36) $0 $0 ($0)
Total $105,773 $87,551 $16,198 $0 $209,522
MSD Solid Waste-Fund 414
414 40003 Personnel $49,396 $1,883 $0 $0 $51,279
414 40003 Operating $1,326,521 $24,211,555 $817,080 $0 $26,355,155
414 40003 Capital $0 $0 $0 $0 $0
Total $1,375,916 $24,213,438 $817,080 $0 $26,406,434
TOTAL $7,542,048 $33,670,307 $6,593,966 $344,150 $48,150,471
Previous Month $7,542,048 $33,670,307 $6,593,966 $156,309 $47,962,631
Difference $0 $0 $0 $187,841 $187,840
69 N O 00 6F} 6F} 69 Co
C)O ti O Oti ti
O O
E
a Z
N M O tow M N 00 N
+�+ co CDO M Cfl a;
C) CD
M le to le
6Cq� C CD
M a C
N
ml*- o (D
LO (D co M � 00 - C
O M N LO � C0 0� w
N M E
f` CO C0 e N
(/, Q � 00 Cfl � M
N 00 C�
\ H Q 69 6F} 61%
L
N
E cn
C:
C: (u U
E N CuN 0=
cu
U },
C: CU 03 � LL
� — cu N
to 70 — T a)0 Q E U U cu
— � c�a
E > 0
J c 0LL U 03 N
L cuI,- (a W i 0= Ncn >
�� cn
cn Z O cn O N J cn
— N 0) .� (a
O4-0
m U � > � > u) LL 0�
_ � 3
a
1
0 0 0 0 0 0 0
'E E ` E m t
E E ao no 2E
_ o o = E E
o'E^ - - af°i
E EE ? .E \.E = v
E-E E
E Ea ,ta E E
.E - n E c E.E.E _ E'E.E — — O a 3 0 E v o O m - = o Q e QeLl
.Q E .Q
`m E y `m E y `m
E 2 E 2 E '2 E a =s -
oEa- -
a��
m m m
N _ ul _ `o - E o _u ul
s E E.. E - a a E E
coIt I
2o 2o 2ml
0
ti ti
W
LL
§� -
\ }\ }\ \\\
\ jk\jk\ \\\\
Im
\ \ \ }
Im
21
\ ) f
3
a
o
0
0 0 0 0 0 0 0
m c 3
o
o °. Ea E n o f -
m�m
E 8.. E m o E o.`�i i E - - - - - -
E
E E m EE
E_ _ E
E E E E
m m m LL LL LL LL u �
co
m E c
N r E LE E
Eo LL w L r W 60 0
z o z o z o z o z o z o z o z o z o z o z o z o z o z o z o z o z o z o
U
d d
0
W
E E
E E E
E E
E E
o o E E
E
\ �\\
V
\\\\\\
\\
VE
( } ! \ \ ( } \\\\ \\\ \\ \\
E
E9 E9 E9 E9 E9
2 � E
A
o o �
o - -
as as - _ _
E.5 E
IE
E L r a a E E 3 a, E yo E o- - - v E
E E r Em oa - -=ono \- \- \ E -
°� - - -O °o V �a �a �� E Ei E� o.ota ?a tF tF 3 E ..
wA 3 c
E E E - o E - o.� - o.� 3 m3 oa.a To22
� g
Fl
Im
Im
Im
E _ ° E _ a 6'6 E
E E E E 22
co
ul
r m m m m
\ w
N s E E E E n _ a =E E v F c m o .LL s m - O
25 23
U
L 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
70
75
W
LL
(
\ \ \ \
\
!{y} !j
\r
} } \ 3 \ } \
\ ImIF
\ \ \ \ \
2E
2 22
/ /
- 0 2
E E { LE
- }k }k _
E{\ : \ |) : \ |) � :// / \ ƒ !{\§/ )},\}; : ; :
; z f
E / \
oo
/ \
& \ \ \ 6 } \ E / \
ml
, , ; ; ; ; ; ; - /) ; - -
; � ; - ; -
O
coml
u.
: \
!\3 \ `) � ) \� / ® ` ) t` ® ] ° * { `
co
- \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \\ \ \ \ \ \\ \ \ \ \\ \ \\
�
-
¢
:
O
�
W
LL
} \ 3 \ } }
\\ \\