Item D1 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 �pw° Danny L.Kolhage,District I
aµ David Rice,District 4
Sylvia J.Murphy,District 5
County Commission Meeting
December 11, 2019
Agenda Item Number: D.1
Agenda Item Summary #6333
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 12.11.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. 736
D.1
Revenue Producing: If yes, amount:
Grant:
County Match:
Insurance Required:
Additional Details:
N/A
REVIEWED BY:
Tina Boan Completed 11/25/2019 9:47 AM
Kathy Peters Completed 11/25/2019 11:43 AM
Board of County Commissioners Pending 12/11/2019 9:00 AM
Packet Pg. 737
D.1.a
Tina Boan, Sr. Director ( Monroe County Budget and Finance
a
a�
a
Packet Pg. 738
D.1.a
Projects Submitted to FEMA as of 11/30/19
°(P,o e
et$1 millio
sc,ipti0e m P,Oien over an
supPlirs $110,478 $106,465 S106,465 S106,465 $o NA Oblidl.dl F.11,Paid
".Ci.g l00%
soar $25,008 $23,50e U $23,508 $23,508 $o N/A Oblid- F.11,Paid
8102,585 $50,902 $50,902 $50,902 $oWA Oblid- F.11,Paid
ana cis $65,188 $61,263 U $61,263 $58,200 $o NIA Oblilll Paid
a $11,780 $11,214 $11,214 $11,214 $o N/A Oblidl.dl F.11,Paid
rea(lab
barnaars' %6,303 $46,547 $46,547 $40,729 $0 $3,491 Aai�mem 0u¢oet shore
re Op. i s,coma snore
8117,126 $114,39d $114,394 $100,095 $0 $8,580 Adli, m0T_
Fvacumion rum $20,6311 $20,63e $20,638 $18,058 $0 81,548 Adli--0ue Shaoet snore
s p um cost °nligatea ana cost snore
ey xP rum cat 83,427 83,427 83,427 82,999 80 825]Axjustment uue snore
8881952 $10,020 $10,020 $8,768 $0 $752 Aai��ment uidndueoet
CL
�irst 1p $49,999 $50,000 $49,999 $49,999 80 snore
82,701,506 -67,614 -67,614 $2b6],2]4 So
86,014 $6,014 $6,014 $5,714 NA Oblig- y Paid
t1Muem%oxemovaol rnunre- $3,011 $3,011 $3,011 92,Ii6ll W1, e�
Nrs
$62,004 $60,950 f]1,111)[ $60,950 $10,053
111.9-
S6tt,et] $524,115 $524,115 $15-7 $370,678 $153,437 $ ac
are Immer`s,e a c
ale) $205,446 $187,110 $187,110 $163,721 $23,389 NI,
xemwal11% a c
$5A92,359 $4A82,553 $4fi82,553 $44e7,596 $7,654 $
aemwal9o%
813941,716 $11342,465 $11342,465 $16T69,H2A $5,e13
aemwal92%
$]fi81,385 $]fi77,635 $]fi77,635 $],AMI, ] $6,376 ac V✓
Obli
82A76,323 $1169,337 $1169,337 $1 A83,462 $265,6]5 $142A26 share Adli. em uu¢aa
ounhouee90%cat $5119fif 4511,911 $511,9fif $30,529 $2,61]Shablire Adli.-m pas atle
$12d,090 $54,000 $54,000 $AY,12]v FE 42 m N/A �a i e
f pot Yk P Cq p t
M f,al 1tl gM g blA als Ublg letl a
9e
n f'M411M2abb uuudl19,i,� .'fIb/201tl 190%6 8 $4A],]21 $84A,908 h( $84A,900 $3d4960 V r aemeM
zs FtNA 161b'd Pyu1612 lF LN1 C e81i0 ,t 8962126" %946,8]% h( 1'894mn $6d6A]6 V 0 ar aen eM a
u FMI vlAlbtlbLYV4 dh2Y !1U/Gi�1?!Al%V"Oestbflal eY �P� 1 $7Jff^1„'6� 5&,CP,Yf() NY �""pIX;kt,Yfll $NF],ldll Ve tla on m aj�MeM a ""a'a
a FtNAb6dltl PWJIad I:11 b101b C erBM � $196,904 ff990,904 h( 1"8196,904 $196$64 V 9 ar aen eM
ca PWA66tltl1YW- lFL9k'61A 6n rea$umman Y ar ga,2F9,9Af 1$(A]5,901 �",$IA]6,901 $1 2t3901 Vo ao on ar a$'MeM a �
>9 PPMA4rAA ft AA2 irs I'll o- at 2 3o Ae as on ar a Mem a
so IMA 36219 PM660 3asaawb 6oa<Remp Pn%o6t 81- $5v,665 &299,946 MA 8299,946 $29994� Ve as on ar a MeM a
si IMAMM PN6966 30019 VSYeren'Pa,kx%Cost sN,r; $446,966 WOW MA $428,996 $428496 V 9 ar aeneM a
a F9lv1A08893 PM79D 4FI2h019 W4teod lark�%4ns 6harel $683,F42 $M4p62 MA 684p62 $624A02 Vo as on ar a$'MeM a
ss FWA-PWo62] A-11 90°la Cost Bhre e $666262 $245,261b4 MA $24 W2 $29 X2 V 9 ar aeneM a
a F9MA8RM PV446]6 ! 'Maw 6atp wwld 9A%coat BVand $106,,"9 1$f,234 MA $],234 $7,34 Vo ao on ar a$'MeM a
ss $PPMAlhl.'N4/U9b. 1fh P, K6ys}a95 8 Lust 0a,e ea 'ppeY mmE ff132,Z19 h1 �"8132,Z16 $1 ta19 Vo do on ar aMeM a
M ntoa ri(yU nYoa Venfet Ublg letl a tlng hlafe
ss FtNAlb6ffE PW 44a6 1Una/t111d 90°la Cost Bhre $(0gae $940.p96 81Q0.p96 $144496 V M
°bl0 C d 5tma
:2 P6MA6888DIPn(61F1 ?i�.22➢19 Yrapsf¢r%4t 00099%Gp6t Pr9'a,e $d60 56¢ $181198 M81198 $1#11p8 o.v d4 f P'. 1
°Gugatgdana Aprvdng5fate
se P6MA6889D Pw6762 4,9/2, WdTd A ^„g df.$ rr4rp $2➢5A49 $15Hfi64 Mt M7Hfi64 $I$6q$4 v d 4 f Pa afanl
MIlto g&R mad atfon9(%- °Glg d aAervdng5fate
es P6MA41A16 rn/Cb92 662718 cook 6h $1,876411 &}429,736 $A 429,736 $1 a2➢]36 v d 4 f P 1 p q
' 4P63p b R {Reodental 4hgg d a Z4 gSfate ld
ao P6MA9fibe PWi969 6n412➢19 Dab,eH 4pn 92%cp6t Prhx,e" $165 q96 $195A98 Mt M55A9S BA55A95 valg4 f P n1 }�
)buy ti t4$uA rrsl,re 4.d
ai P65W68891 Pv1.5464 ?36&I419 MCPdtkA 199hC s$rr4rp $499.124 3499.124 Mt.' avA"r,M12Po SMe't.✓Po t f'. �1S
GomfW Ica wn a ,9A ngaR aass PF.M'v1A3b662d9td9 PwV4o9a61768 l9F11
P7h2N91A8 ore aad 9rntu b]on ap MAM bHA6� "$AlG4
Wgtt $99 Pf nGGUUlnN r tt nGG e�ttf{1¶fwuu:gA n�ttttS
P5.l,-
Re
$ t]ff MAM O(5l6
r nre emtionru] $61 240 $168,816 $168616 renal xeviewat p�q
51A5,649 51I 51I
p $121o,s96 $1,210996
p $e 263 $44024 $44p24 Final Heviewal
val(Rsslaenlial �
553Y,556 55
(Rssasallal°sbns Hauling)90% Final Heviewal
51en,]o2 5153,350 5153am
os
sra He (e$
P'a)9o%c share $212,e03 $212603
6u C. �,.t 1 LL
v1-19 °9a 1 n FEMA683ffiPN5946 Share $825431 $825t131 �
es m �i
MC Pg
$132119 $903294
"ll'90%Coss In 6HM AM
v,.I,o-b11 4ar.4o-bo V9
1$210332 $210332 Pend9CIC Pqed ent
u /Co 16 A63
u /Cos $410,041 'Pet,
$45353 1136p01
$192854 1
02 De"Remova
Resi
auling)92%Cos ehare�a $61 62 gCRC Pqedp e9al
E&-Is 90%Coss $1140896 $1140096 PendgCIC Pqedp p�p
a[,mce xoaa IU%[,o
$80988 $80988
sa FEMA 11-4 019 ArCua 2H]&290 $397111 $39]}Fah Pend,CRC P,oqjed Devellopmem
�6�4a �aPWdy24"" rt� n ffi11gf�j{dus9A/64KsN� a�66s. ,,, lalsauslwuA4:� �
es F'k`N4vN¢034,,,,,,,,I 2C($+2rP(5?6 ,Misimpf4a%46akv'h 6, to $5tfi t5�.,. 86 855A6o 83e9 5 m St e899�90 ,,,,,$0�$3 Sd9II] $28A2>;946 Sd92 598 8159,Z]110HMomh ima $60fi3]669 Sd,e]d952 Sdo,3]e toe Sd 55e,3o8 $0 $0 b26fid3,119 $482,5451 $1584,319
oral rs P a:$47,746416
OLAorcmeof L.gisil..AAairs ally Paid
twirenmenta nemna P�e�vahoa Ue aaAon{ycpxymeM
iy�pp4bl✓�6,d4h4,��,,,
Packet Pg. 739
(a&ePdn leloueul_q ewil aueoiaanH) 6L' VU 6upaapy 0009 a&ePdn leloueul_A ewil aueolaanH:}uawyOe}aV c
R v
r
d�A sad s
A
a R
d
ni
�e
e 4 & & a i Z
� A
a a a a a a p
e®
a a a a5 5
E E �
d A¢e
a ® F a a a
Afi e
2
R
d
m CI &
5 F�
H�
LL=a=
a55 5 5 a a
A R
a a a a a
& a �
ia6
IE
assss
a
W
(a&ePdn leloueul_q ewil aueolaanH) 6L'WU 6upaopy 0009 a&ePdn leloueul_A ewil aueolaanH:}uawy3e}aV
R v
r
o a
a
d
Y
V
t6
a
_a
d=
n s e
E�� e
a � x
� dAe
az
a
d
m pd=
e®
=d=
m
eds� a
a
E add m
d e m
� dad
_ w
s
d
b � a
_ e
ep
dF ate; m 2'
m
AEw m m s
r »- m
m e » »
a i»
E o e o
0
m
h e
ia6 S
H a a o s A
0 ` w
m
= A o A m
N m a
v�
a =a
m m m m
V r r r
da m m
C C C C C a o
r e e m e 6 r m e e e e e m e G m e d
a a a a a a a a a n n n n n n n n n n n n n ba"
a (ayePdn pp—ul j..,I auevuanH)6t't t'U fuUaaW 0009 ayePdn lelvueul j—1 au-,,jnH:yuawUoeyyb
n
0
a
a
Q
r
M
1111 3 LL
a a E E a a a a
N"
0 0 a E o o 0 0
o - - -
Kl
IN
3 E E 3 aE'mE' 3
3 F E EE 3E 3lw
E3 E3 \s a°; 3
'3
\ E v
o =10
I.U0 m.ml m -
>c - 3 o� o o �s o a o o `-� 1 u
G
E mlml U0 2
IN
T Y m't m > m m - -
y a y a +- d - v
r a a ¢ m a a to w LL o c� v LL 0 0 0 LL 0
\ m m m
ol
e
(� ao ao ao ao ao ao ao ao ao ao
UM
00000 20 20 20 20 20
0
ti N 1 1. 1. 1
ui
0
LL
_ate w,_..-_anm 6-!4_0009_dn —1 _w_m
\ 10
10
\
\\\�\ \ \\ \ \\\ \\\ \\\17
10
\\ \ \ \ /\
_\ ^ \\
r /& % ( &* - : { [»
\cF10
m � \\ \\ \\ \ Pm
� \ \\ \~
>
\\ \\ \\ U U U U u u u u
_ate w,_..-_anm 6-!4_0009_dn —1 _
\ ! !
\ \\\\ \ \ \ a2\
ET
\ \
\ �\ U U
\ \ § § \\\\ \�\ \\ \\
_»m_,..,I wmmm _0009_aj m _w_m
: k
� \E
( § § § ) § § § §
\ _ \} § , 7 7 \ � \\/
} | ) \ ~ ) { - m
\ \\ \\ \\\ \ \ \\ \\ \\ \ om� \UO
\ \ \\@ } \ \\\ \ \\ \} \} \\/ \\\\
\ \ \ \} \\\ \ \\\} \ }0 0 OE
E\ \ \ \ \ Al
{
NN
11
WN
Im
IN MN
t & > > , >
\ : ! . \ ! .09 . ! \ ! . \ z ` % 22 ;
ow
> } oo >o o o //o- }m } \ \ /\ {E
} {J {J {J {J {J {J {J {J {J {J
( 0mm w \ \ \\ \ \ \\ \\ \ \ \ \ \\ \ \
( f f f f f f f f f f
r} a a a a a a a a a a
IN
(
> § | § § § § § §\ §
_»m_,..,I wmmm _000._aj m _w_m
2 (
} k
{ #` ! : : : ) »
\ K \\\ \ \ / � / 10
� \ \ \ \ \ \ \
/ / } \ -
){ }_ _ - - : !2
§ ; % \ \ \ }
2 ; \! _ -\ _
) ) ) f! /%3 L0.u ! § }] f} ) / [
o
o
\ 2 ! \ 2 ! / : / ! :2 » % )) f
\ )) \ _ / ~ / \ ;or \ �
{J {J {J {J {J {J {J {J {J {J {J
a (ayePdn lel°ueuij ewal aue°laan H)6t't t'Zt fw,yaaW 0009 appdn leloueulj—1 aue°uanH:yuawU°eyya{
n
0
a
a
0 0
n ¢ o 0
m ° q
°
3 > > 3 m m o
o° E
E 2 -
S 3 3
m v -6
E E u
o t o r w a m >' o m
a
o w o o w o
m 2 m
a r E a r E
z m m
m m m m
o m o
E n
� N
�i
Q-
yf
_ m m
LL E E LL° m m
m o w o w
0 w 0 w 0 w
3 o U\ o o
ry ry a m
" �
3 o m r a
o w m
o o m m v
` n r o °
3 3
w
n °
E
o - o ° E
0. 2E E Y 0 3 ,m
o Y m 3 o w 10 o > o n
a (ayePdn lelnueul j..,I auenuanH)6t't t'U fuUaaW 0009 ayePdn lelnueul j—1 au-,,jnH:yuawU�eyyb
n
0
a
a
M
1111 G
a a a F a a a
1 -
0 0 0 o 0 0
t o
So
10
o 0
j
E o 0 3 E3 E3 \ a n 3 3
o a —
Fo
> .£
OW t
mlw E o c 3 0
ti ti le 6
le M
E E E E
w w w w an d
a a a a to v LL 0 cn ate, LL 0 cn ate, LL o c� v LL oLO
cn a LL o
\ m m m m
- U UO E
E ~s v LL > ab m m o
E
ao ao ao ao ao ao ao
UM
IM
ui
L
0
0
LL
_ate w,_..-_anm 6-!4_0009_dn —1 _w_m
In
12
\� \\ \ \\\ \\\ \\\ \ \ \ \\ \\
10
$ [ &* : - { [»
0 ® \ \^
IN
10
® })( ®i ± / 22 0
\ \ \ \\ \ \ u \\ \ \ \\ \ \ \~
§ , a > m :
\\ u u u u u u u u u u
a (ayepdn pp—uij..,I aueouanH)6C'tCU 6ugaaW 0009.4.pdn leloueulj—1 au-,,jnH:yuawUoeBy n
a
a
a
E
E
V
0 0
v E E
3
m
w v
o a m o f >
3
y y m v w v
r o o E
V o o � o
m m76
0-6
ml
ET-
E s
—
U E v E E
o w o
w L
Y
08 08m
nu w
p w w
a' N
.. ry m o n
A rn � ri 6 v
MM
IM
lw
aaa of Ev � vv � vv �
ow a o > v o a >a
v v s v o v
E w v E w v
E
3 Q \ G o Q w
a� o m 3
E
—
o
(e; d l iou ul_q ewil au olaan ) 6V VZ Bui;eeW 00 e; d l iou ul_A ewil aueoijinH WM43e ; T
LO
T ti
a
a
0 0 0 0 0 0
14
o 2tp
E E E c ._ n o a lm
o Y
- af°i E
> >o v a Y 3
- _
E E
'E.E - - O a 3 0 E v o
o
� g
FE' E.. E.. a _s a _s a _s a _s a _s - - - _ - a _s
�
V/ a a a a '`�°
04
N `o - E o _ T E - - > E -
s E E E E E E
U
0000000000000000
(D - - - -
n n ,
0
ti ti
W
LL
(e; d l iou ul_q ewil au olaan ) 6V VZ Bui;eeW 00 e; d l iou ul_A ewil aueoijinH WM43eUV cN
LO
T ti
a
m
a
E
E
c c
E E
- o '
E o 3 y o 0
E n t E
m o
v a v � .. o 0 0
en o
v a o n 3 E
a Ev E
E E
a o
3E 25 a ¢m
�a
E-' E a� 3a E ar-ao a E E
E.
G
y m y m m y m m m m m
m t s m
o
o f E o E o E o af°i E-
S d E
p E a E a E a
v
3 E E
-E m
'
�,
n o E
22
3 3 -
E
o Y E 3 0 o o > o n
D.1.a
Paid Expenses by Fund as of 11/30/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 $9,183 $3,500,428
125 0459110 Operating $3,470,917 $8,363,910 $3,156,928 $60,075 $15,051,829
125 0459110 Capital $46,642 $24,551 $1,863,921 $84,154 $2,019,268 CL
Total $6,026,738 $9,074,980 $5,316,396 $153,412 $20,571,526
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 $985 $39,709
403 635102 Operating $3,505 $272,555 $403,768 $1,912 $681,740
403 635102 Capital $0 $0 $40,525 $0 $40,525
Total $33,621 $281,163 $444,292 $2,897 $761,973
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,593,966 $156,309 $47,962,631
Previous Month $7,542,048 $33,670,307 $6,481,437 $52,624 $47,746,416
Difference $0 $0 C"II12,529 $"103,685 Ca2,16,2,1
M
E
°
Packet Pg. 753
(e; d l iou ul_q ewil au olaan ) 6V VZ Bui;eeW 00 e; d l iou ul_A ewil aueoijinH WM43eUV v
LID
T ti
a
m
O 00 O O� � a
EF} N 00 H} a V- M
r O E� C) O O
O
ti � ti ti it
� �
O O 6c>
E CD
a z
I k k fr. I ltlI
II II�� III� //h y�0 U y�� �, W11� �1�u� �G�p N
kv11� �Z U P� �iI a� �i� rc �U CG) j),
i (C)jj�j It
lljja 11d �d
�� m It
M of It
/ ,
a) ti o (D
OLO (D CN M �00 M 0) IZT� CD
0 � M N � Cfl d7 00 00
N 1 M P- O (D C
_ (fl Cfl N
(♦, a ( � 00 (fl M
CIOM � N 00 a)
O 6G} Ec} � � r
F- o
EN
ECIO
0=
U N N
0=
N Co C
U },
C:
CU IL
i M i U) U)
t=3 4-
o ca
Q to U a
a) Fu -aiL EC: a) a)
> a� cn
0- 0= 0= - a) r-
•�
O p J U- V M p
CIO cn Z O (n p a) CIO
VJ N .� >, = �CD 0 -0
• �--�
m U � -j > � > U) LL0-