Item G01 G.1
t, BOARD OF COUNTY COMMISSIONERS
County of Monroe Mayor Sylvia Murphy,District 5
The Florida Keys l'U � � Mayor Pro Tern Danny Kolhage,District 1
�pw° Michelle Coldiron,District 2
Heather Carruthers,District 3
David Rice,District 4
County Commission Meeting
November 20, 2019
Agenda Item Number: G.1
Agenda Item Summary #6260
BULK ITEM: Yes DEPARTMENT: Budget and Finance
TIME APPROXIMATE: STAFF CONTACT: Lynn Gonzalez (305) 292-4467
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 BOCC Meeting 11.20.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. 963
G.1
Revenue Producing: If yes, amount:
Grant:
County Match:
Insurance Required:
Additional Details:
N/A
REVIEWED BY:
Tina Boan Completed 11/05/2019 3:23 PM
Kathy Peters Completed 11/05/2019 3:24 PM
Board of County Commissioners Pending 11/20/2019 9:00 AM
Packet Pg. 964
G.1.a
Tina Boan, Sr. Director ( Monroe County Budget and Finance
a
a�
a
Packet Pg. 965
G.1.a
Projects Submitted to FEMA as of 10/31/19
°(P,o e
t$1 mieio
sc,ipti0n.P,Oien ove,�an
nimg $62,004 $60,950 $60,950 $60,950 $o NA Odid- F.11,Paid
Suppiig $110,d]e $106,465 S106,465 S106,465 So N/A Obfid- F.11,Paid
n %cos, $25,008 $23,50e fis $23,508 $23,508 $o WA Obfid- F.11,Paid
8102,585 $50,902 $50,902 $50,902 $oWA Obfid- F.11,Paid
ana cie $65,188 $61,263 fis $61,263 $58,200 $o WA Obfid- F.11,Paid
a $11,]80 $11,214 $11,214 $11,214 $o NIA Obfid- F.11,Paid
realab
ba,nmag' phait
%6,303 S46,547 S46,547 S40,729 So $3,491 Obfig-it 0uC-SM1ae
are�mateas,comrecaool.$117126 $114,394 $114,394 $100,095 $0 $8,580 Aa'is�nnem0ueost SM1ae
6vacuaion rum UM1Ogatea ana cost S>,ae
m p um t.ost 620,638 $20,638 $20,638 $18,058 $0 $1,54e Adjistment Uue 'M1ae
Sha83,427 83,427 83,427 82,999 80 825]Aal��ment uueost
CL
ey xv ru%Lost UMigal nDd.1ost]M1ae
rs PP $88,952 $10,020 $10,020 $e,]68 80 $752 A,yisimem Uue 'M1ae
idog-and 1-
$49,999 $m,00o N $49,999 $49,999 $o
I.-
rs13 $2,701,506 $2fi67,614 82fi6],6td 82fi6],nd So SM1ae
S6,Otd S6,Otd S6,Otd %5]1d at, u
8611,817 $524,115 fis $524,115 $153p37 $370,678 $153,437 loal.Adjos-no
are Immer`s,e a t.
alalILL
emwai rem $205,446 $187,110 $187,110 $163,721 $23,389 at.
8 $5,92,359 $4fie2,553 $4fie2,553 $44e7,596 $7,654
aemwai 9z% $13141,]16 $11,342,465 $11,342,465 $9119,571 $5,813 $849,958 Sia,'e Ad�stm,d Uue and
ac �
8]fi81,385 $]fi]],635 $]fi]],635 $6,789,062 istme$6,3]8 $575,od9Sha,Aa' m Uo¢aa
Obfi
oC-She9o%cwt $2fi]6,323 $1169,337 $1169,337 $1A83,462 $285,8]5 $142,028 SM1ae Adi-nn.m Uueaa ac toncC Para Pad an wt
zo FE 68381 P146801 are $3],811 $34890 WA $34890 $30529 $2 isimem ue
' I pot Ykp Cg p t ang elate M f%o I tl gM g b!A a1s Ublg atl d
u FNA4lk284b uuudll'J,i,:I-' 190%6 9 ,,,,,,,,/,,,,, $4az724 $84A,905 MA 044,909 $244969 Ve as on ar aY0%eM
n Fd4l lol.vvu1612 3F ,o C4et 81ig � a .®
,,,,,,,1,�,,, %962126 %946,8]% h/ �"%946,8]8 $546ry'i6 Ve tie on ar a;.Me g �
v f'hl4llhlb66LPW 462Y !1U .!U18 30la Coeet BM 0 g$a 6f9 $116232R %500,654 h/ %500,654 $500$54 V g of aeneM a
2a FCviMb641a PJJJIad 11 b101b C erBM %196,904 ff990,904 h/ $196,504 $196$04 V g of aen eM a T
zs FMi viMb6dtl+YWobF4 3FL9k'U10 6h renQ u%man Y bt $1216,90f 1$(A]5,901 ",$IA]5,901 $1 2t5901 Ve as on ar a$'Mem a i".+✓
,S PMivIM4r0aLNN+oa52 i 3rsu/2U1r c9rmed „�,,,,,°„ Bn zs3,a66 ,g�;aa.45r ',�.zsa.4u� at 2zap6� �e as on ar a�Mem a
a1-4°994-- .itLLk'ulo Fpup sn1�0%Lnat ellane '� $424pg0 �$s4.°Go MA &s4.°m $5000 ljf,."il,'aenem a �
2a IMA 36215 PM660 31P8,2019 6da<Ramps99"%CaEt 6hare $910565 &289,946 h/ i"%289,946 $289946 V g ar aeneM a
za IMAE36363P 506 3dP8,2019 Vsferen'PAkA%Cost 9Har�e $446,966 U2053 MA $426,993 $428493 V g ar aeneM a
so EEMAWIM P 79D 4wI o19 Wa,- k9)%C Eh sw8,742 $634p02 h/ i"%634,062 $634p02 V g ar aeneM a
st FMi viMb6aW F'VJobL LN1a 90°la Cost BMare $666262 $215,261,5a MA %245,262 sooVi 2 Ve as on ar aY0%eM a
a EEMA36222 PW40]6 PVno18 6atp 6b 14 g90h4 tBM td dn,486799 „ry'f,294 MA $],234 $7,34 V g r aeneM a
ss FMi viMlbll4b vV4/u9b, I." Ks tw SLust 80are ea 'ppeY vm79fl ff132,315 h/ 8132,315 $1ita19 Ve tia on ar aj'•MeM a
a PM41(h3b6ffE W444a6 1Una/2A11d 90lt et8 a1U M1udM1 Venter %]0A5d3 1144AB 81Q0.p96 %144,106 Veiaa nn ara a3NdreM htafe
ss IM&66362 PW6YJ1 2222019 It WlIS1 90fCao-8- $266;(14 $981,103 8181;106 $191106 Ve1g tea d eM htafe
y Ugtl rr mov;lMtIUFlP- � 2b1 g C d "d g 5t f
rF P�MA99134 FWi738 6/14/2➢19 9{1xita�9"11r e $2911. �$3911 $3911 89R71 v dt f P 1
Ybl K ude81 @:tna ny n�ary
ao P�M+'.68892 Pw6752 0/2079 MCPetk 3 ^„99hG 4t$Pr4re $2➢5A49 $155fi54 Mt DfT 6+r1 $P'k.°k
MAd7e g&R mea atfon9(%- YbIW d @ a y as
se P�M+'.41616a/p92 662718 2 sk 6}r $1376411 &k MnO DPdI,'k 14 Rz,4A46t°n V 4 4 6 p'. M p q
4P63pb R {R dental YbIW d !@'a y as ld
mP MA9fibe FWi569 6n4/2➢19 Db+eH p 9&Sg 90 e" $145 q95 $165A95 D1,. 'f x1^,ie'%Nf VAteta nnk p:.sncny 0
9 $161 240 $168,816 $168616
$4911z4 $495124 $4s5,124 N.
Sh, r Ens Sralion 90F $,0 192
$ey]o $eg]o N. S.
Einar Reviewal
p $2D90,429 $1210,996 $1,210li96 S.
rinai ueviewal
p $181 263 $44024 $44624 NAI S.
Final ussisw at
saI(Rss-In I
5:. 5 5f39,t50N.
(Re ns Haulin�90/ Final Heviewal stlemial°eb ventlmg HewpierA e®
slfia,]62 slfia,]62 slfia762
M1e Here
e(B$
Pm090 ceseM1a,e $212,803 $212,803 $21200
-,�90%C 8 5
ens %-
149996 $1757e
L�
291,014 $291114
.0 Figss m90 12 $211411 $225483 1n u
$832,619 $983294
1"90%C. $285 152 $285 152 �� ��n .1aaP- �
%Ce $91325 $90liI4 .1
dd C. $410,041 $349,794
45353 $132,137
192,854 $148372
Re
n9��o92.1C s6a,r��a $fi,cn , , p +`+
Fl mMea29oices n4o�386 $104966
Ih Il Read IU%Ee
80988 $86988
t
�5�as 45Pwdy24"" r1� n 6�+a��lcus97lc44sN� a�66s. ,,. lalsauslwu34:� �
Eat 60 des zn3 s2,940195 $o 8s z 3fiora5 $0
: �$26fi,d8,,489 $
dez 5d5 815e4
i,3,1 9
0'156 Sd,e]d52SMond,ima8b3] 9 558308 $0 $3fi9793 $68]efi2 $0 $2fid3,19 $de25d5 $ised,319
$4],]46416
OLA orciceof L.gisi-Atai6 ally Paid
twirenmenta nst.ncnl
iy�pp4bl✓�6,64b4,��,,,
Packet Pg. 966
(e d l iou ul wi a�a olaar� ) VO `LL upee 00 e d l iou ul wi a�a olaar� : �M43 r-
� m
,Tn
a.
HE
Ws _ d mp a.Hon B m tl 5=
Ms5e 5�
e d
� a e
Ha
- � S
A v�
'c $
a@=
a= '
"a
� a
a n a a
- a �
am
s
� a
"s
m
d= a n
A� � m _ m _ _ stt�� ana tt
d
a � -0ss s
sews e >
e=;a_-
a
w
(e; d l iou ul wi a�a olaar� ) VO `L L ui;ee 00 e; d l iou ul wi a�a olaar� :;�aM43e ; co
� m
,Tn CD
V
a
e �
a
eQ
gal
= e_ aA_
_ n
a � n
� eAA
e
A�
n
m�E ^
e e
H
��L e
a=
`a
am p
@^ m
d� ^
�e »
m ^^ -^
»e » m � e
ad
m e m
m o m � ®
o m
� e
E - - - - -
r - - - m m
em
v a
€A v
m
(e d l iou ul_q ewil au olaan ) 6 VO `LLBupeeW 00 e d l iou ul_A ewil aueoijinH WM43eUV CD
,Tn
V
a
m
a
E
r
-
0 0 0 0 0 0
-tea,rE E
E E -
a -
E _ = o E d E 5 2a S E ° a°
o o
� E ry ca E c
n
m g
E o A E o A o E o A E o A c E w c E
� a� mad ¢� mad mad LLo LLS LLo LLo LLo m ., 3LL
u u A -
O E o E m E
i
` a a
L
W
LL
(e; d l iou ul wi a�a olaar� ) VO `L L ui;ee 00 e; d l iou ul wi a�a olaar� :;�aM43e ; CD� ti
,Tn
V
a
m
a
r
o � v
a
w
° w
E n a E n 3
0
A
Y
A
w
a`
m
A w a
m Q n Q n
Or
N N
m.
M n
li.
a m w m w w w w "
E v
w E
LL p m w m m m
M =
e n 3 v E E
27 o a o
0
c o k >w
E n N c
� °E
w w w
(e d l iou ul wi a�a olaar� ) VO `LL upee 00 e d l iou ul wi a�a olaar� : �aOIW43 T
� ti
,Tn
V
a
a
O O O O O
- - - - - _ -
cc t
- E w 7F � m
3 E - - .v. - 3 ws - _ a
3 Q E E u ,o Q - o o s
a - - - - a o 3 - T E o E r E
cc cc U0
E E o o « \ - \ - \ - 3 3 3 v 7E - -
ml
E- °1 E 3 E _ �E �E CIE « 3 \ o a s
E _ cm
7 - E G F G F G F E t E s _ E 3 0« _ u
0 cm
_ - o a = _3 E Im
v LL 3 N 3 3 3 E a 3 - 3 E a
E m v E Q o E E E E � E O m_ oa _ v O a _ - E o E, > —
„n 6 E '^ LL 3 0 a 6 `v o
U^
Im
Ic
rym.'
Y"m
E
V! E E m E m w E m E m m E v= m E
r a > a> a � E a> a> vLLo "LLSLLo vLLo vLLo mw 3 ``
m m m m w
ie
O v m " "E of"o ao > ow F E E
E cm
7 a
U '
70E o 70E o 70E o 70E o 70E o 70E o 70E o 70E o 70E o 70E o 70E o 70E o 70E o
a a
0
LU
0
LL
(e; d l iou ul_q ewil au olaan ) 6 VO `LLBui;eeW 00 e; d l iou ul_A ewil aueoijinH 4u8w43 ;; ti
,Tn CD
V
a
a
r
�Q
o
0 0 ow v
E _ 3
a \
a E m
t
> v m v
v v m « o
E c-
t o v E
'c �-'E o `v o v v
m m ' m f0 - >
. m.� 3 v v
m v o
3'60 1. o T N
o E E s>
G F G F
w cc
o
3 ¢m
3 a -
m o
0 `o " v o o o
�m a
G m > = 3- \ E E E Q
?
0
O m a0,
wc L cmIm
a m Q 6 Q Q«
U^
A
Y"� 4
rrii
n n n a m m
vm m
n
ry E v°�'
v v v> v ovo v a`
« m E E E
a v v v v o p E
a
v � E o v E o v
IICC t° S �
TES a
a =
.. o m o 10
o a a o «
3 m �w LL � ° 7E
- -
o
0 o u m u
�;. m vm vm vm vm vm
0 o 10 o 0o 0 o 0 o 0 o 0 o 0 o
E v
m m0 `oa o `m '3 E
3
o m t o v
m
E m o ° v o
°
v v o E v'«
E
p > p o_
(e; d l iou ul wi a�a olaar� ) VO `L L ui;ee 00 e; d l iou ul wi a�a olaar� :;�aM43e ; co
� 1-
7 CD
0 Ch
a
m
a
a
0
x x ° E x x x x x
IE
o o o 0 0 0 0
- - - - - - -
r` r`
- _ -
E E 3 E E - 'E « .3 .3 - � E °,� 3 «O Q s -t l� v
3 6 3o
o
E E n 3 r 3 - - .w us 3 m G-
EE o w - - - - - v�-o E T E o - oc - = o
° � cw °-3 t o « r E
— a a o o - c - _ - _ - _ a- _ oo
E 3 a E m - r- j O0 E
`ml v is ° ° v `-¢ E v a
m cm
o
o
>"c ate. s� 7E ; a y ° a o � o
� - 3 -= �.
3 E o °' LL - - 3 3E a 3 3 E n
E m m v - Ev. `o_ 3 o E.� E E.� E a -
E LL E E
l^
r'
Y"m
0') i E E E E E °'' < <
E m E m o f E « m E « m v a O0 E E
\ a a a 7E a 7ELL o LL o LL o v LL o v LL o m w 3
com m m
N - - - -
O - E - E- m E > E -
E � E„ _ 7EE- E� 5o
o E - j m �m Qcc=
U
I, 0000000000 7o 7o 7o
aD �`
r r r r r r r r r r a S r
L
0
ui
LL
(e; d l iou ul_q ewil au olaan ) 6 VO `L LBui;eeW 00 e; d l iou ul_A ewil aueoijinH WM43e ;
,Tn
V
a
m
a
b
r
owE 3 «
3 a m o «
t o t o v E m m
m � °
t Q
- - w
> o
o °
�
° E E v m E m
a "' v
,E \.E 3 vmc
3 o N «
> 3 E «
E 7 ° �t ¢m a
3 a a m o «
o o o
-° m > o 0 ig
° v
G z
o o > >
o mIn In 6
� r w
w�.
+rt
y v*
A
Q
ry E W c W W
O0 E °0 E °0 E
U' LL m w m a m a u m Q E m m
8 _
3 7 LL 7 ° i�
7 7 7 7 7 7 7
m ^ 3 7E0
o E
m o o ry m n m ry >
v o
m m m 'o'« v t
a
m m a a n m m o
o o m E
- 3 3-
Ic
E
o a E S 3
(e; d l iou ul_q ewil au olaan ) 6 VO `L LBui;eeW 00 e; d l iou ul_A ewil aueoijinH WM43e ; Ln
1-
CD
V
a
m
a
a
0
LL a -
.3LL
x x ° E x x x x
IMP -
" o o o o 0 0
- - - o - - -
m E 3 E -E .E 3 m 3 m Lo
cc E T cc 3 «.E G w -t l� m a
3 E 3 E o o 3 E .E .E '3 m o m G- - - 3«
t o - - - - a o t « « E
E- a s o o - - _ _ E _ E - " o E 6- o o
m 3 m m
E 3 a E ,o j o m E.
_ - o a = = E E 6_\ -
3 E o °' LL - - 3 3E a 3 3 E n
cw
E m v - E `o_ 3 o E.� E E.� E 3 3 o a_ _ E o c E Q\ —
ELLm w 15
l^
Im
r'
/'tom i E E E E E °'' < <
w.E m E « m o f E « m E m v a O0 E v E
\ a a a a LL o LL o LL o v LL o v LL o m w 3
m m m
0 - - o
-
r - E - E- �m E >" E
U
cc
cm c
o
Is Is Is Is Is Is Is Is Is I Is Is Is
I, 0000000000000
(D
r r r r r r r r r r a a r
L
O
ui
Q
LL
(e; d l iou ul wi a�a olaar� ) VO `L L ui;ee 00 e; d l iou ul wi a�a olaar� :;�aM43e ; m
� ti
,Tn
V
a
m
a
4�
T
W W
°w v E E
E 3 «
o — a 7 \
«
m
m t t
m m v7F E
t o t o v o m
v G
v =
m m v m
0
0 0
E ° v � �
a \ a 3 m E
o a= o a c m a u = E E m =v t
m m m m = m E v t E m
v v
o E o
o = ° —
n m m v = v v
m
_ o "' o m "' 3 ° v v
m a _
O E.Q o f.Q 3 v O > _ > «
o w v m v 3 3
cw
o > mEc 0 o
«> \ E E
O >u O >u u _
uwo
3 a a m o tw «
3 °- 3 _ o 3O o E n E E G E E
v >
m o a z m o v w „o =
= v iv o «
«
O m ° m Q `° `° z o «
a— n ry o_Q« Q« O o
w�.
+rt
y v*
A
Q
o
ry w
y p v r v v v v ry v
O0 E °0 E Y m E
w a Ew m r
v v vi v -O v `° mw vi
m
a v v O
a � a ry ry
_
E " v E „ ry 0�Ct E d o.� °-w « w «
I., t O O v d. v t
4 d o.
a d u m Q m m w U' LL°« m a7E a7E
- a
y m = O >
> _ _ 0 v IS
v p =
a x � a «. O v � � � ° _O m a p v LL v LL
m u u« O m o v t o o
.. p m p O a N p p
w .N v
u - =LL a a D o w o
OEO O « O� u � v« v«
3 ° 7 o 0
'-. O ^�O� O O O O O O � �
., �o �o �o �o �o �o �o �o �O o �O o �O o
v v v « O
v a « v
v a
o E
!' mx 1. mm Im mx 1. Ix mm o -
m m o 3 .3 E
v o o x
m m — v o cm
E
« o E
0 6 E o 3 Y oc
G.1.a
Paid Expenses by Fund as of 10/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 $4,159 $3,495,405
125 0459110 Operating $3,470,917 $8,363,910 $3,082,530 $0 $14,917,357
125 0459110 Capital $46,642 $24,551 $1,863,921 $47,237 $1,982,350 CL
Total $6,026,738 $9,074,980 $5,241,999 $51,395 $20,395,112
Card Sound Road -Fund 401
401 22559 Personnel $0 $0 $0 $0 $0
401 22559 Operating $0 $13,175 $0 $0 $13,175 M
401 22559 Capital $0 $0 $0 $0 $0 E-
Total $0 $13,175 $0 $0 $13,175
Marathon Airport-Fund 403
403 635102 Personnel $30,116 $8,607 $0 $347 $39,070
403 635102 Operating $3,505 $272,555 $358,939 $882 $635,880
403 635102 Capital $0 $0 $47,222 $0 $47,222
Total $33,621 $281,163 $406,160 $1,228 $722,172 cy
Ir-
Key West Airport-Fund 404
Ir-
404 630191 Personnel $77,258 $1,094 $0 $0 $78,352 CD
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 P3
MSD Solid Waste-Fund 414
co
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 CL
Total E$1
,375,916 $24,213,438 $817,080 $0 $26,406,434
2
TOTALI $7,542,048 1 $33,670,307 $6,481,437 $52,624 $47,746,416
Previous Month $7,542,048 $33,670,307 $5,838,999 $0 $47,051,354
Difference $0 $0 $642,438 $52,624 $695,tl 1.,'j2
M
E
°
Packet Pg. 977
(e; d l iou ul_q ewil au olaan ) 6 VO `LLBui;eeW 00 e; d l iou ul_A ewil aueoijinH 4u8w43 ;; CIO
111 1-
7 CD
0 Ch
a
m
O 00 O O� � a
EF} N 00 H} a V- m
O E� � O O
O
ti ti ti �
cfl 0') 0)
O O 6c>
E CD
a z
I k k fr. I Ilin
III //h y��,/�W��y� �1�V� �G N gip,
��ill rcir/ �'U�
jj�j It
lljj431111 i (C) a 11d �d
M� �!,'w�11N'
/ ,
O
0) 1,-- o (D
O� (D CN M �00 CIO LID IZT LIDCDO � CIO N � Cfl d7 00 00
N 1 M P- O (D C
_ Cfl Cfl N
604- 604-
M lzt v- N 00 a)
O E�} Ec} � � r
F- o
EN
Ecn
0=
U N N
0=
N Co cn
U },
C:
CID � IL
i i U) U)
tW 4-
o ca
Q 4-0 cn
toC: a) a)
U a
a) Fu -aiL E > a� cn
0- 0= 0= - a) r-
•�
O p J U- V m p
cn cn Z O � p N J
♦�//�� cn
0= C: to N � U (B N
• �--�
m U � -j > � > U) LL0-