Item S1 S.1
� � �, BOARD OF COUNTY COMMISSIONERS
County of Monroe � ��r�i
�r � s�� Mayor Heather Carruthers,District 3
The Florida.Keys Mayor Pro Tem Michelle Coldiron,District 2
Craig Cates,District 1
David Rice,District 4
Sylvia J.Murphy,District 5
County Commission Meeting
April 15, 2020
Agenda Item Number: S.1
Agenda Item Summary #6781
BULK ITEM: Yes DEPARTMENT: County Attorney's Office
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:
Hurricane Irma Financial Update as of 3 3120
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. 2564
S.1
Revenue Producing: If yes, amount:
Grant:
County Match:
Insurance Required:
Additional Details:
N/A
REVIEWED BY:
Tina Boan Completed 04/07/2020 4:11 PM
Kathy Peters Completed 04/07/2020 4:16 PM
Board of County Commissioners Pending 04/15/2020 9:00 AM
Packet Pg. 2565
S.1.ai
Tina Boan, Sr. Director ( Monroe County Budget and Finance
E
N
E
w
Packet Pg. 2566
Projects Submitted to FEMA as of 3/31/20
gmmmnmpreredare old wd
supplies Stt4n. %=
$1.14. $1014. $1014.
retie s]sans,mN Cos
-9. -9. M. Fulypan
.,....I......
I-1-9-11 111-lo 811214 811214 811214
ns lane Stt0.391 $1-94� $Iol-� a I.Idw-
1-41.1-11 4--ld -6. -6.�
_da P9n 1.1 $1- $14N� $14N $1- P.I.M.d.. I.Idw
m nnQp woe cost .19. $1-1 Mo. $1519 1-4-11 P.I.M.d.. I.Idw pad
p-
.1. 1 -999 -
-1 11114-11 d-lOn--. -115. 1614 1614 12.
IM.6-0-14 4112.19 ...d.9n $1014 $1014 $1014 85]14 M.d.. I.Idw
$z..
$6zo. -9.
M1665 M1231
..p 9
$1799 $12. $12M $1- M.d.. I.Idw
ens 4ep
-966 d.,wp.d
M
F-1--26 2116.1. $.1446 $1.1110 $1.1110 $1.111ol FUINpaa
U-
22
21
E
16. 16M� $13. PAI. y.
13. $1,961- 1 $1,961-1 $1759 M13. PAI.M.d..,P..adW
- - - M.d-,
$56- $94.7d $ml.. $1519m $13% M.g..,
910.965 910.965 .13.1 $.1579 N.,.d.d...,
$,9,936 --
iaion
-.1. 9n $1,311011 $1736 $1736 $1,.1514 $.1- NIA M.d..-P...W-
11 F-9M7-69 6114.19 9. $15- $,5,o.l NIA $151o% -4. -5. NIA M....-P-N- CD
N
1�F-9-0- 6114.19 On $16- $16MJ NIA $16- M- .1-
F-6.13- 11116-6 gn "t. d Bnna
$19
1=-n,Plk9n
N19d $-19ol $-19ol $491od, $-.39 NIA M.... d P-N P.d
v, 4-
11, 0
0
H--r-
gem
F-
$245262 $245262 V, 1�r 1�
$326 $132315 - $132315 $132315
- $144416 $144416 CL
F 6-2 M611 21221201 1. $366504 $1�l 1 o� - $1�l 1 o� $1�l 1 o�
1�
F-6-1 M6464 312612- 11-.-p 1-1. -5 124 -5 124 - -5 1. -5 124 L)
�=HBl,ll,n,s 101-
F 6--- 512012011 $453531 - V H-n Zr 1�
-2-rs lem-l'lesHe-1
1�
1,ftns 1-1266 1.
1�F 40--61 41241201�1-re $210332 $223- $223- $223 LL
$-565 $-565 1�
d P-nd
-511 -511 -511
I Res"101 $2d
M.d- d P-nd
scequipmem1,1 - I
12. $.12. $.12. $.12.1
MI EMUW MI.
37492 8 95R- $1,9516. $1,9516.
5E F-73360 M6224 1112011 'gnrel s I Signals 101 $161 240 R-pen�F-1 Review
FHe 1. len
5,F-6-4 M6476 112412- $145-
51 F-6-5 M-0 51231201�He-e-r-1.-re -1 263 -1 263 -1 263 1 lgn,�nl Re,,p,enl F-1 Rev-
oPS4 611412011 lelnsDe S Rem—2se" Jbr 101112r %$ Appl.. I
51 1-1-1 M",1 -11-1 le- $17Z371 $17Z563 $17Z563
M I lull,�Iminnie xev Appl.. I
51 1-Hl-M,111 11111-1 1U, $`d4056 $4d4056 $4d4056
- - s Pend,n, Develen�
.1 Houe(B,,P,ne)101
F-6-4 M6203 11612011_ $441 6. $441 6.
F 6-6-46 211512--B ldn,s-lo-re $-550. $.,Ilu I.n..ng 1.1
I 11,1 M lol
I�pl Pro-s
$.,.,o.i -z"i �41,561241
-I --1 M1363
d-... 19. $13-1 $N-1
$51,671".
I-= dd,
.IA M.d- d I`Wp- Ml.g- d Ml.g..d.d ..WP.d
M.d- d P.dmg 6.
l.nd.nd..p..F.nal
P-
IPd-
Packet Pg. 2567
(AI!AI13V 03ULIUI=l ewil ouL,3ijjnH) OZ 6C C Jo se alepdn ILi3uLui=l ewil ouL,3ijjnH :IU8W43L'IIV 00
LO
C6y2
2- o CL
2
cu
H
a.
.c I
.2
q.2
2
2
oB
2
vFm
2 2
2
2
2
2
N PIP
1 2
(AI!AI13V 03ULIUI=l ewil ouL,3ijjnH) OZ �C C Jo se alepdn ILi3uLui=l ewil ouL,3ijjnH :IU8W43L'IIV
LO
C6
a.
u
m
N5
- - - - -- - - - - -
- - - - -- - - - - -
- - - - - - - ---
S.1.a
Paid Expenses by Fund as of 3/31/20
Hurricane Irma Activity by Fund
FY17 FY18 FY19 FY20 Actual
Hctuai Hctuai Hctuai Hctuai i otai
Grant Fund-Fund 125
125 0459110 Personnel $2,509,179 $686,520 $295,547 $99,065 $3,590,311
125 0459110 Operating $3,470,917 $8,363,910 $3,156,928 $1,194,687 $16,186,441
125 0459110 Capital $46,642 $24,551 $1,863,921 $383,118 $2,318,232
125 0459111 Personnel $0 $6,459 $0 $0 $6,459
125 0459111 Operating $0 $2,074,173 $0 $0 $2,074,173
Total $6,026,738 $1131553612 $533163396 $136763870 $2431753615
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 $133175 $0 $0 $133175
Marathon Airport-Fund 403
403 635102 Personnel $30,116 $8,607 $0 $985 $39,709 a
403 635102 Operating $3,505 $272,555 $403,768 $111,081 $790,908
403 635102 Capital $0 $0 $40,525 $0 $40,525 -
Total $333621 $281,163 $4443292 $1123066 $8713141 €
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 $1053773 $873551 $163198 $0 $2093522
MSD Solid Waste-Fund 414
a
414 40003 Personnel $49,396 $1,883 $0 $119 $51,399
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 $2432133438 $8173080 $119 $2634063554 E
TOTAL $735423048 $3537503938 $635933966 $137893055 $5136763008
Previous Month $735423048 $3336703307 $635933966 $133483664 $4831503471
E
Packet Pg.2570
(AI!AIIod aoueui=l ewil aueoiaanH) OZ 6£ £jo se alepdn leioueui=l ewil aueoiaanH :luauayoelld
LO
r N
co a1
a
a�
Y
V
C) 00 r CD Ca)
r d
ff} N C tq ��1 T- C)
C t771 O C) C) O
O
m C4 C4 N
O O 6q 6q 6q 6
E
a Z
N M co C-4 O CG (D m coo l N
0 O p CD ( O
� Cfl
m r` o (0
LO (D M CO 0) 00 � C M N � CO 00 CO
O
n N M r` (D C4 � N 00
n Q u "t "t co CO � 09- � M
C 0 i T— N 00 C�
O O r
\ H o
cu N
� U
U N
� N
EN CQ N C
U �
C: cc
(a N L- LL
t/) 7 a)
Q.
_O Q C C) C
C � ,� CQ
U � o a) 0 �
0- C: C � .- a, �- � �
cu O O J CCF LL U N
0- (If 4- m L LI L N >
N to Z O N O N J N
C C: +� to N -0 U CIf N
U C i
N 0) CQ
O
m C) > � > U) LL 0
( !� |mp¥a uL uewa a L|anH) OZ �CC Jo se mep dn |m3uem] ew4euL|anH :;eW43m; 04
q
� 6
a
\
a
\}\\\ o
\ : �\ � Z _ \
\\ E
o
\\\\ \\ \_
\ < o }}) {Z: »< _§ > -
: � _ \ _
\\\\) \\ \}\ \\ \\\ \\\ \\j\\\) \(\\\j\ \j \\\ \j
\2> ){ /{\;( }}) (
\\f/{j\ /}Z§, ® -
\\\ -
�\ \\~ \\ \\� \� \\\ o \\ �\\\�\�
\ { } } \ } \ } \ \ \ \ \ }
} { } } \ \ } } \ \ ( \ \ }
O = Z Z Z Z Zo >: : § > - - > - ; -51
C'4
C'4 ° {:; { _
- - - -o
`\ } \
co \}) °
` }® } \/ {: `} }Z /:° \ ): :` ) : }® °
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\\\ \\ \\
,_ ,_ ,_ ,_ ,_,_ ,_ ,_
2 = _
_
�
W
LL
( !� |mp¥a uL uewa a L|anH) OZ �CC Jo se mep dn |m3uem] ew4euL|anH :;eW43m;
q
� 6
a
_ \
o
/ a
/ o\} \� - -
\\ \\ \\\\\} \\\\ \\ \\\ \\
M
U
H
U
= H
U
a
\ u o \� \�\�\ }l
o
b -o }){ }) } }
( !� |mp¥a uL uewa a L|anH) OZ �CC Jo se mep dn |m3uem] ew4euL|anH :;eW43m; /
q
� 6
a
\
o
\\\ \ o�\ \ \\ \\\ \\� \\\o \\ }\: \ \\ \ \ \\ \\
-o
o
o
- : / « _ _
\\\\ \ \\\ \ \\\ \\\ \\\\\\\ \\\ \�\ \\ \\\\j\ \\\ \�
\\\\ \ \\\ \\ \\\ \\{ \\j\\\) \(\\\j\ \j \\\\j \j
/{\;( }}) (
- -o < _ \ ){}{ \\f/{j\ /}Z§, ® -
: - : 2 : :`» ` °t}° ` °:o
o -
\\\ }- _-j\ )} ;})}}\�\\\� _ - \ : :
} \ { } } \ } \ } \ \ \ \ \ }
} { } } \ \ } } \ \ ( \ \ }
: § > - - > - ; -
C'4
o
° {:; { _ o
- � `\ } \
\})` {co
: `} }Z /:° \ ): :` ) : }® °°
co \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\\\ \\ \\
2 = _
_
�
W
�
( !� |mp¥a uBU uma a L|anH) OZ �CC Jo se mep dn |m3uem] m4euL|anH :;eW43m; LO
q
� 6
a
u
/ a
o
o
o
o
o
o
o
o
o
o
o
o\\\\ \\ \\\\\\ \\\\ \\ \\\ \\
H
@
H
H
o
o
o
o
o
= G
,o
U
lei
o
\� \^ \� \�\�\ }\\
} }}o }){ }) } }
(A)!A!Ioy aoueui j ewal aueoiaanH) OZ 6££)o se alepdn moueui j ewal aueoijjnH:Iuawyoeuy m
A C-4
N
a
w
Y
U
t6
a
a
a
a
a �
a
0
mo mo o O E - - -
E °o
-
\
-'O - •�- a 3 _� a v� E w o 3 5 E 3 0
o
- ° o ° E n
Z rv - 2 a E
E
0 o E
0
NN
Im
IN
c -
M
zo zo zo zo zo zo zo zo zo zo zo zo zo zo
U
0
Q
W
LL
, A! m.l_aueo % E EEm e_#mm=m=i_au •m#8wLj38 m [
G /
0.
/
6
- $
\
M
. G
p
= G
9
U
- - - - - - - - - b
- - G
(AI!AI13V aoueui=l ewil aueouanH) OZ 6£ £Jo se a;epdn Ieioueui=l ewil aueouanH :;uauayoe;;d ti
� N
LO
a�
Y
u
a
a
a
� a �
0
0 3 o E
o
o
\ 3 3 o Z 3 o _ 3 m E o L w E o E
o
o
E m O E - \ - -a E `o_ _ _ o-o o
d o o a - E a 3 a o
- E _ 0 5 v
°3 - E a o 9 -o m .E - E.o o = o
t4 a - o 2 _ = i,t4 m E'-o _ o_ o _ 3 - v ID11
o
6 E 6
Eo
o
o
3 E o o
u-a
o
E E - 3 V \ -- o\Eo
° `m = E a. _ - - _ °'b 3 - oZ E \o
E \
E - E E E = v d 3 a - °E - m p
E 3 V o E3 - -_ - 3E a m _ 3
° _ - o - _ -Vo E a - - o s - o j = - O- -- _
S `g'
o
- - - - - - - -
� Eh � Eh � Eh � E � E �m� � Eh � E
n o -mE E -mE >-mE�mE�- - -
N o ma v a zW o 0
co EEELL �� - mo
$ �Es 3 Ew Ep
ao ao ao ao ao ao ao as ao ao ao ao ao ao ao ao ao ao
8E 8E 8E 8E 8E 8E 8E 8E 8E 8E 8E 8E 8E 8E 8E 8E 8E 8E
U
om o o o o o o o o o o o o o o o o oo oo
0
LU
0
U-
( !� |mp¥a uL uewa a L|anH) OZ �CC Jo se mep dn |m3uem] ew4euL|anH :;eW43m;
q
� 6
a
\
_ a
(
§ o
1 {
o
E\ \
o
\} - `\\\:\ {o
o
o _
\j \ \\ } } \\\o\\\ \ \\ \\
o
§ j )o j )j
\} j }}j }\ \} ( j\ }{\ }o
ow
\ o - \ \\ \�\
j ) (§ 7 (» { { \ \\
@
U
} g
m
ii
m
= g
\ U
M
: m
\ \ \ \ \ \ \ \
> a
§ 6
> @
H
\� (\\ \( }) }) §\\ }) \\) \o
\)
§_ }:: z{,
;: \\ _
`/° \ }: }} j\{: {{2 ol
wlw
)§ )§ )§ )§ )§ )§ )§ )§ )§
o
`§
o
\\\\ \\\ \} \\
! :> , !Z; !> ! 2
(AI!AI13V aoueui=l ewil aueouanH) OZ 6£ £Jo se a;epdn Ieioueui=l ewil aueouanH :;uauayoe;;d o
LO
� N
a
a�
Y
u
a
a
a
� a �
0
E - - _ .o v o
E o o.� o fi E m 3 - - o'o '° \ i O
o E o m _ \j o 0 3
o E a E O o o .E
o
o o E.-'E E a- E w E E-o 3 o - o'
e� V �� .�..3� 3� E
E ° a 3 E
o
E a 3 a ' -
.E E -3.. - -- E a. _ - - - -5 L r m - S,- _- _ >E
E 3 V 03 \ j N 3 a
o s - o
o
S g
� Eh � Eh � Eh -
_-mE >-mEa mE�- - - _
o 0
co
o
co
ao ao ao ao ao ao ao ao ao ao ao ao ao ao ao ao ao ao
80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80
U
000000000000000000
0
LU
LL
( !� |mp¥a uL uewa a L|anH) OZ �CC Jo se mep dn |m3uem] ew4euL|anH :;eW43m;
LO
� q
$ 6
a
\
_ a
(
§ o
1 {
o
E\ \
o
\} - `\\\:\ {o
o
o _
\j \ \\ } } \\\o\\\ \ \\ \\
o
§ j )o j )j
\} j }}j }\ \} ( j\ }{\ }o
ow
\ o - \ \\ \�\
j ) (§ 7 (» { { \ \\
@
U
} g
m
ii
m
= g
\ U
M
: m
\ \ \ \ \ \ \ \
> a
§ 6
> @
H
\� (\\ \( }) }) §\\ }) \\) \o
\)
§_ }:: z{,
;: \\ _
`/° \ }: }} j\{: {{2 ol
wlw
)§ )§ )§ )§ )§ )§ )§ )§ )§
o
`§
o
\\\\ \\\ \} \\
! :> , !Z; !> ! 2