Item D1 D.1
G BOARD OF COUNTY COMMISSIONERS
County of Monroe Mayor Sylvia Murphy,District 5
The Florida Keys l'U � � Mayor Pro Tem Danny Kolhage,District 1
�pw° Michelle Coldiron,District 2
Heather Carruthers,District 3
David Rice,District 4
County Commission Meeting
October 16, 2019
Agenda Item Number: D.1
Agenda Item Summary #6175
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 Financial Update 9 30 19 REVISED 10 8 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. 885
D.1
Revenue Producing: If yes, amount:
Grant:
County Match:
Insurance Required:
Additional Details:
N/A
REVIEWED BY:
Tina Boan Completed 10/01/2019 3:28 PM
Kathy Peters Completed 10/01/2019 3:32 PM
Board of County Commissioners Pending 10/16/2019 9:00 AM
Packet Pg. 886
D.1.a
I�l1
a�
Tina Boan, Sr. Director ( Monroe County Budget and Finance
a
eo
a�
a
Packet Pg. 887
D.1.a
Projects Submitted to FEMA as of 9/30/19 REVISED 10/8/19
ff iP
1 millio
cltg 862 ood $6o 950 $60 950 $60 950 $o SM1are
s Obligaled and Cost$110,d]e $106,465 $106kR5 $106kR5 $0 SM1are
y n 0 0%co $25,00e $23,50e $23,50e $23,50e $0 ig-R!and Cost SM1are
me t00%cost Obligaled and Cost$1025e5 $50,902 $50,9o2 $50,9o2 $0 SM1are
Sand cie $65 tee $61 263 $61 263 $5e 200 $u ig-and Cost SM1are
Oblig-and Cost
t BID- 811,7e0 $11,214 $11,214 $11,214 So SM1are
re flab r
mA26503 PW111 5rz01 ricaag,aphaD and ock) $66,303 $46,547 $46,547 $40,729 $0 $1,191 Aaias enl n oaQoel SM1are
areons
lm�aten'alenle Oblig--!ana c SM1are
Evacuation 90 $117,126 $114,394 $114,394 $100,095 80 $e,5ee All stment Rue Cost SM1are
820 63e $20 63e $20 63e $1e o5e $0 $v 5de Aalus�mentn0u¢ost
k&P 0%cost $3,427 $3,427 $3,427 $2 999 $0 I'll A Oblig-d and Cost SM1are
RP 90%Cost n Cost SM1are
$
ee 952 $10 020 $10 020 $e 76e $0 $]52 Ad lustment0.
Odlig-and Cost
ns $d9,999 $5o,000 $49,999 $49,999 $o SM1are
Odlig-and Cost
mA5072 PW 22 r14rzo 30 $2,701,506 $2,667,614 $2,667,614 $2,667,274 $u SM1are
Oblig-,Pa,tially Paid and
5611,e 1] $524,115 $524,115 $153,437 $370,678 $153,43]
a e ioate5Calster
Obi ig Paid and E
mA16038 PW242 16rz01 talslemoval92% $205,446 $te],110 $te],110 $163,721 $23,3e9
R $5,092,359 $4,682,553 $4,6e2,553 $550,467 4d,dH],59f, 4"I,f.SdCOstSh a.Ad
ly
II mA3e528 PW433 13rz01 is Removal9o% $13,941,716 $11,342,465 1:1,342,465 $9,919,5]1 $5,e13 4nd9,"1,Cost Sha,e AaisitmentaDue
E
is Removal 92% Oblig-,Pat ially Paid and
8],6e1,3e5 $7,6]],635 8],6]],635 86,]e9,062 $6,37e f5]'i,91;9 Co
$2 076 323 $1 969 33] $1 969 337 $1 6e3 462 $2e5 e]5 44d2 n2n Costsha.Ad zitmema0ue
Distodc ounhouse90%Cost Oblig-,Pa,tially Paid and
FEMA68381 6e01 837,811 $34 890 RA $34 890 1 $30,529
Temn yR p @q pmenU Cost Du.
M Ste 1 Ift WWII pblla fd dP a 08Y'.ee
,I'rem,2586 PW 2719 2/8+3A 16 Meala-186%vCoet Bb le W44>IY21 $344 966 I.N/A W344 @b51 W34q,9R5 Mal da inn for Pa me0t °lk-
shI g and E anuald`196% bblt♦t d d P a 0 E1'te'
11 F@MA ISM,PW 1512 3WIM18 Cart BI $962,126' Wi46 B73' .WA $646 1B. MAR 76 4'dld[ f P
Mon C ty 8h @ pblf t tl dP dng StPt'e
11'fi8MIA3B6B1PW 9629„1623013 I.I 11RI98/94k&Nzre Ws 1621324 1, $BDO b54- .N/A FSOWb%4- 389965a U'a'dP 14 Pe gq
Cben IM ke e and Buoya 99% "N'd d P a 0 Bt.Y
2uF@MA68313 PW6633 11/16016,Coe't abare ,lmg,4 W196 BD4- WA M6,504 "B'514 MalO[4n fue Pamem
8g�i Cmm>(ty Pa rh'9q% pbll fd dP a 08Y'ee
ss'fiC4vIA683B>PW65>3 3/19/SA 19'Cp4t 9haea $s,2]g,9g1 ! $1.376@91 $97]g 9q1, 61 Zt8 991 Yal da inn for Pa meu $�
P5Y1i1 nt Roatls,&Brdgea 98%
26 R@MA 41931 PW6992 Coet Mare $0 232'6] Wl 232 6] M 232 6T 11,216467 4'dl d[an fue Pa meat
$5 3 P1E1 13 gd men1999tevCna469are b Ie4nd N/A%fiA 999MID
mblgta dP dmg st'4re 00
n'fi8MIA4b994PW68A3! 12P22,616 U1 W4„4{699 - I. $64➢9 15- A 9➢0 %'a'd'ePonfor Pe meet
mb'tf4t d St Y d P tl g
2eR@MA36219f W066P 3281PA19 6ual Ram s9A%Coat Sfials $BiA�609- $239 AB I.WA W239'9a6.- W389946 'uald[nfue Q Pa ment !
pbll$�f tl d P tl g$l Ck �
za'fi8MIA683B6-PW6996 3/f,84'A1g Vatelan'a IIA'91T%Bo e49Naea, W446;986 W426 BIB .N/A WE)BIB, W O BO Mald f P 0t
bbl�td dP tlIBtW
31 F@MA68393 f WRI80 I,12tA19 Wad P I,MIA st Mare $63714B, $634 62 .NIA $634 02', $634 62 4'dldt f P t
Bltie M p rk&l4 en 4nfae pbllg f d d P tl g SY't'e w
at'fiC4vIA6839q,PW652 -d/l2'11J'i7Y M11'Ctiat a- � $H66262 -;$24526159 �N/A- W248062' W248282 Mal da f P nt I CObl�td dP tlg$t:te' lei
32 P@MA362P2PW 46YA' fOFB/2618 GataB ltl 90l C st SM1are Wl OD V99 v zl,- .NIA V2841 V234' 4'dld[ f P
MC6 1d g tlSq p a pbld6 t tl dP dmg St�ee y�5
sa'F6MA3B948�PW78@9 1/2$/Cp 19' U' K 98/vC 4k.&N,re $826i793 W132.31g IN/A $132A1g;, W93231$ %'a'd'P fa Pe nt LU
IM C W O f of on Cerrcev ttbt L 46 d q.,l.nta
3u R@MA3B682f WA43A iG/99l2618 9tl%Cost Bhare $T9'S33- 6dAA 49Pr- BFftn 9PJ- b1d4 9F 5fe4U t fn,k,ruvnv'.
fkhl gpM1 d tlP d n:.w.ase
as'F6MA68302`WDM 2rg3ojgq Transfer tdCld a 96la,Ca9 s§1YaYe" $886A➢4 ro1k"T'I'tA $18$t,194, WilVrc,304$, 44Rtywy44m M1rx r (�
ttbt b 46 d},G,Av
16F@MA68388 PWU14 4A21WI9 @a st Maltello3tl°la Cost Share $61014 649RR %6 HkM 5BA, 5fe4U tnfn,k,mront.
aT'fi8MIA99Y34 frW7T36 g/14HA 19'fi ry693%Pemnual9altlllY- $Br611 s,t„03d ryn„I{Ti gkSla Urd1A Inn Yrotaw d 4S(nse
emeaiaeon 90 1 Final aoaiow
90/ $131,011 $1420736 $1420736 1Final Review
$161 240 $16B,B16 $16B,B16
G 0/Coll $205049 $175654 $1 65654 ,t{inal Rcvic
G 0%Cosl $495,124 $495,124 $495,124 ,t{inal Rcvic
er Fne Staloff 90 ,t final Rcvic
$150192 $B 970 $B 970
,t f anal Rcvic
$2,090,425 $1 210996 $1 210996
,t f anal Rcvic
$1 It 263 $144024 $144024
OPS4al(Re ,t f anal Rcvic
B 1BM1are'a $117131 $117131 $117135 NIA
Cl
[Reei bras Hauling)90 ,t{inal Rcvic
$153350 $153350 $153350 11¢
eT FEMA 68394 PW 6203 MC SM1erAts Hou e(Big 0 6�
4212,a W 4212,0 W 4212,a W
canon Towers 90%Co
$49 212 $41 115
C Bui 0%Cost $391,654 $40B4O90 Alnsuran-06
Gift $149 991 $17 57B
$291 054 $291 054
12 n1 $256465 92214B3
$132,119 $913,294
sl Marlello 90%Cosl $285 52 $285 52
$451 614 $4652B0
uil 0%Cos $9 114 $90,914 ,�C4A R Be
OVlew
MA 36203 PW718 14/201 Mitltlle Y $4 0 041 $349 794 ntlinp LIII Rcvn.w
Lo,ve,Keys uil 0%Cost
$45,353 $132,137 4F1 Rovlow
$192854 $148322
al(Rase tle ayJ nlial $52 67190 $52,62
Resi
$15509' $15509'
FAL E&Meals 90%Cost $1140,B96 $1 140,B96
a CM1ia Road 90%Cost
$B0,9BB $B0,9BB
c9F'6hi'66dspWa#14'„vv6rz41"sLl hw aas 9634//4ast9 k,,,„$Bgffa,,,,,,,r''.
cs ACMA16A36,,,,,1.,,2A61S6?d'�ss Gam 1¢6/�4t'�kafa,,, S6'69',di45W,,,,,,,,i ,,,,,,,,,.$, -,,,,,I,,,,,,,,,,i ,,,,,, ,,,,,,,,,, ,,,,,,,,,,,z,,,,,,, f4'q''eal P13aa4e,,,!,,,,I
To S6o 63]669 Sd e]d 952 $40 3]et02 $4,558,308 $0 $35,819,7931 $6,878,652 $0 526,643,7791 $4112,5451 $1,584,319
Total Expense Paid:
A office or L.gisllure Affairs my Pa
ldidid add and Pendirc9 3tatPl
P Env ronmenta Hstora Preservaton WURDltin rd,Paymeni,i
W«�
Packet Pg. 888
(alepdnlei:)ueui:j ewil aue:)ijjnH) 6 L 9 o a3SIA3N 6L OC 6 alepdn iel:)ueul:j aue:)IjjnH :juqwq:)ejjV a)
co
co
a.
HE
gt
a.
L-j
4M--
i tea, iM,
E E wa
t..
t E
02
JE
Na N
q
cl R
Lu
co
of
MN S E -4
I I IE
EAAAE E
Lu
HI
D.1.a
Paid Expenses by Fund as of 9/30/19
Hurricane Irma Activity by Fund
FY17 FY18 FY19 Actual
Actual Actual Actual Total
Grant Fund -Fund 125
125 0459110 Personnel $2,509,179 $686,520 $290,075 $3,485,773
125 0459110 Operating $3,470,917 $8,363,910 $2,827,293 $14,662,120
125 0459110 Capital $46,642 $24,551 $1,625,498 $1,696,691
Total $6,026,738 $9,074,980 $4,742,866 $19,844,584
Card Sound Road -Fund 401 LL
401 22559 Personnel $0 $0 $0 $0
401 22559 Operating $0 $13,175 $0 $13,175
401 22559 Capital $0 $0 $0 $0
Total $0 $13,175 $0 $13,175
Marathon Airport -Fund 403
403 635102 Personnel $30,116 $8,607 $0 $38,724 eo
403 635102 Operating $3,505 $272,555 $262,855 $538,915
403 635102 Capital $0 $0 $0 $0
Total $33,621 $281,163 $262,855 $577,639 co
Key West Airport -Fund 404
404 630191 Personnel $77,258 $1,094 $0 $78,352
404 630191 Operating $28,516 $86,457 $16,198 $131,171
404 630191 Capital $0 ($0.36) $0 ($0)
Total $105,773 $87,551 $16,198 $209,522
MSD Solid Waste - Fund 414
414 40003 Personnel $49,396 $1,883 $0 $51,279
414 40003 Operating $1,326,521 $24,211,555 $817,080 $26,355,155
414 40003 Capital $0 $0 $0 $0LL
Total $1,375,916 $24,213,438 $817,080 $26,406,434
TOTAL $7,542,048 $33,670,307 $5,838,999 $47,051,354
Previous Month $7,542,048 $33,670,307 $5,402,760 $46,615,115
Difference Via¢';➢ Via¢';➢ $436,2 ' $ 6,23'
Packet Pg. 890
( l pdn l ':)u u' it u :)'aa ? 6L so a3SIA3N 6L OC 6 alepdn l ':)u u' u :)'aa aju :) jj
r
1C Os
r 00
� a1
a
d
O 00 O O� a
69 (V ofC\j 00 69 R m
_ = O C) O CD CD
O
00
E
a z
O
CM a
mP- o (D
LO (D co co LO (D LO C
O CIO N LOCO O� w
N M r O � �
♦^ ♦, _ CO CO N
v, a - o0 CO � � M
Co -q- N 00 a)
O (E) 60-
6�
\ H Q 69 6F}
L
N
� U �
U 0= N 0=
N
U � N
� N to
�
r n � U) ca I..L : U �
V/ � p N O
_ U N
O Q � (jUcu
E cu
�
U � o �, °' a, — off a)
a)a) 5 � iL aa a)E > a� � a, ,
C�
D O J LL 0 (c O a Q
L ca ca W " � > C v
cn cn Z O cn O N - J
n .6 N U � U 72 N . N Q
- N 0) >, i 0) (a - (a
m U � � > 0- > u) U- 0 � u) 0