Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Item D1
D.1 G 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 August 21, 2019 Agenda Item Number: D.1 Agenda Item Summary #5924 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 8 21 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. 1050 D.1 Revenue Producing: If yes, amount: Grant: County Match: Insurance Required: Additional Details: N/A REVIEWED BY: Tina Boan Completed 08/06/2019 2:55 PM Kathy Peters Completed 08/06/2019 3:08 PM Board of County Commissioners Pending 08/21/2019 9:00 AM Packet Pg. 1051 D.1.a I � m Tina Boan, Sr. Director ( Monroe County Budget and Finance a a� a Packet Pg. 1052 D.1.a Projects Submitted to FEMA as of 7/31/19 F-CRC °IP,,ae at$l mHill.ana F scription of Projen ovep nlmg $62,OO4 $60,950 $60,950 $60,950 $0 Obli-ana F.111 Paid supplig $11O,47O $1O6,465 Sto6,d65 Sto6,d65 $0 obii-ana F.111 Paid n m cost $25,000 $23,508 $23,508 $23,508 $0 obii-ana F.111 Paid 8102,505 $50,902 $50,902 $50,902 $0 obii-ana F.111 Paid ana cle $65,100 $61,263 $61,263 $58,200 $O Obli-ana F.111 Paid a $11,700 $11,214 NAI $11,214 $11,214 $O Obli-d ana F.111 Paid reallab barnmag' %6,303 $46,547 $46,547 $4O,729 $O Obli-ana F.111 Paid areOOp. i.cOmraca5 8117,126 $114,394 $114,394 $100,095 $O Obli-ana F.111 Paid tvacll-n ism l 820,630 $20,638 $20,638 $18,058 8O Obligate)and Fully Paid Shas p 5m t.oat $3,427 $3,427 $3,427 $2,999 8O Obligate)and Fully Paid bO ill Pme ey xP]w`PP $00,952 $10,020 $10,020 $0,]60 $OOblig-antl Fully Paid $49,999 $50,000 N $49,999 $49,999 8O Obligate)and Fully Paid t rst3 $2,701,506 $2A67,614 $2A67,614 $2A6],2]4 $O obligated and tally Paid 86tt,en 85zd,tt5 85zd,tt5 $t5343] $370,678 St53,437 Obligmmana P-Ily Paia a(� dalaj' e�ka $205,446 $187,110 81In,110 8163,]n $23,389 ObO gnea ana Paaaly Paia xemwal rem $5A92359 $4A82,553 Sdbe2,553 855op6] Sd,t32,oe6 8363,1e5 Obligmea ana Paaialy Paia xemwal ism $13141,716 8113d2,d65 8113d2,d65 $9119,571 $5,O13 Obbgnca an Paaaly Paid ILL xemwal]]m -111,3e5 $]A77,635 8]An,635 86)e9,o62 $6,378 obligated and Paaialy Paid 82A]6,323 $1169,337 $1169,337 $1 AO3,d62 $2O5,O75 obligate)and Paaially Paid E FE 62d0 Plyddl5 � MaI Mxl Ang Mleage&meals pbl daodPna ng EMfe 2nF MA32966pW2]19 12116PAm Dow,o'.6pe $447]21 �2-04965 hl $84A,9OO $34p,4O0 VIi�on fprPayMeM eh $54SA>3 Bh41(ari g d C ,,,1pO"h $552125 hl 8540,8]8 $54 pblg daod P atl ng EMfe u P�MA1e15a Pw151z� 3nza91e Cn° dare vaudaton earvayMem M r'C yHh RH dq eHars - pblg d3OCP ang EMfe 22 FEMA3O0 P!iG4629 1AQ3f1A3 &11€2,324 $9OOb64 8500,054 $900954 Vlid fprP eM LMabnA M k saga Buoys]d% pblg daod P atl ng EMfe v FF4v1A0B313 FVV53B3 11n6016 $19A 9O4 $196,9O4 MA 8195,904 $199pO4 Vlid frP eM =� B1g PwB Lnmmanikperw75%Cd»I pblg d oaP ang EMfe 2a F&MA633Bt P995i3 3Y29/,'A19 Bhara. $1'S]5,901'. da;2F9,9A1 ",$IA]%9O1 $12Y35M V lid on fprP yNreM zs F&Av1A41A8LP?54R2 31PA2919 Loaf Bhara kaads&Brdges9H% $1',-32�46p 4a;d93A6/ 4',$1,293,46/ $12`�3Pff/ =frd,'P-M EMfe F der Oe ggvbl tl pblg daod Aeaa ng Elafe u FEMA4A99d PD2542 3Yd9/JA18,Cg9rpmjan$96nf Lust'Kara $424pgq ,MOM N! $54pOO $34PW Velidatonfur;Pay: a IMA35215 PA566O 3/23,2919 BdA Re 4 F6/o6t 81 $5v 565 6239p4b N4/f¢ Q x"b wx N{3YYy4Rx Ybf S t a tf % Hb La9aNvusa T9".i Gael' k1h6v1 to tt 2a F`MK4A63331 P!168O1 13Y23]✓1'i19 BNha'a i. $2]p1T .$24p9A N4/f¢ u' g72 tWt4 $h;.iy951 p.r Iuvul � k1h6v1 to"tt uA tt51,Re za FFJv1A0BMPN99O5 30019 VSYeren'sPark Z6%Lost 9Hsrq,s; $445065 $423,998 N4/f¢ u'g,IXP5.997 Q?F xIx Y@n rtn�e�'.p.r rrgrat � sd FPWDA8393 P$JQ 41121XIQ 'Ndtapp Pelk]5%QMJKIaIl sw'N2 '101100 Mil-00 y16n e;nott:$p.r¢qa tml Blae Hg M&Tee O-, k1h6v1 to tt uA tt51,Re00 at P M+'.A83W PM1552] 2rV 2JY19 N Lasf 9hatb' ygNn x" w ✓{,p' Y@e rt n e$'.p.r�;.lewt emeaaeon]5i $1316,011 $1429,236 $1,429,236 Einal Revi 0) nsa(Big Pins)]si $441,689 $440,689 $440,9 Mc Co ]5i Einal Rssi $161 240 $168,816 $168A16 eon $492a2 $49s2a $153o,]99 $]a3d nl-wnle, $70533 $ 9n t�,e sal�en]5i ces $150192 $es70 MC BOIId ng ntle uipment(U P, _)75° s M1a,e $326793 $132 31 5 A 1, 1 0gy� tfu /o[,osl $991114 $3O5y66 e.• s9 FtMHbwm Wwr4b 1n5/1ll1r SM1are It el'No ment pppp nserbaeons is/o l,o $366504 $3007 yq eantl Gift $49 A96 �1 $495,124 $4495124 $291,054 $291 A54 es&Equipmenl]5% �Imion $211411 $225483 so $832 832 619 $ 519 sl Maaeo75/Cosl �]A $285,152 $285,152 o� $205049 1]iV" $55,881 $,+,+1M $451,614 $4652H0 ui /Cos) $9325 $90354 ;® M,ddl $410,041 $349794 u /Coss $45353 P $2p9O4Lr 9 p®ppp $111213$ k1$144A24 V9 $192854 1111 l Resi 525]190 eOPED � br ng)]5%CosRleSM1areden'a $155p95 1.:A I' al(Hes01 tl i-1 Delulingl]5 $117135 Y':i6]A35 r (Res d=,s Oeb�saH au ng)]]5 l W $1,140,896 $1,140096 u Ilcmovnl.Viun/- 3p11 e: _t1n t ""0 v i vlvl Yi 0 Yi, i1iI I I rPI L �5%a3AS3,,,, ,,,,,,,,, ,,, ,,,,,, ,,,,,,,,, ,,,,,,,,,,i,,,,,,,,,,,1 ,,,,, t'r��1MoptdkT $6-6,422 $],ed9A9d $3]130596 $20O241 So 8353d56t5 86 d3936d So ;26,25P,Y4 Onice of g arentraia aly Pa ewirenmena n atones P�enaaon Vella£Udnf4r Payment Packet Pg. 1053 D.1.a .unry Gram 5 mtd a .0 n ..n7 A- $1898 t mm$o Pro e$]2 00 pz$o xea$u 21000 .St$Do"o ace$60 50 M$60 50 gs$o Ball$28 a�$11 50 a D$10,0 3 m Cl$]t 0 2 e difti P$11950 m $0 C mc$o P Ntl u$11 e50 g m th.e...f 81238 $0 $106 65 $0 $106 65 $106 65 $106 65 $106 65 $0 $+38 $7135 -$e]2 $98 93 $0 $0 $7135 $7,nD135 C-fit received on arch..deer sub.scion $908 volt b.r.all.-d to th.p.jst ODD volt be.emetl at 22boo 89oe $0 $23508 $0 $23508 $23508 $23508 $23508 $0 -$me $0 89oe $22boo $0 $0 $o $o-for all LA, AdDID- my mm 11,759 Lair ma�km valuer neon $o $o $+0+,759 $o $+0+,759 $50102 NIAI $50102 $50102 $o $o $o $o $50102 $o $o s5,®e s5,®Brae � 6+263 $0 $0 $61263 $0 $61263 $55,12 $3,063 $582oo 3,063 $61263 $o $0 $o $0 $61263 So $0 $o $0 $28 volt be r.all.-d t.the p.j.e ODD Wit be.emetl al LL $0 $11,242 $0 $11242 $0 $++242 $112+4 $112+4 $112+4 $0 -S2e $0 828 $11,186 $0 $0 $0 $0 close..for all DAI. +4243 $32,305 $0 $d6,5d] $0 $d6,5d] $34y10 $51818 $40,729 $51818 $d6,5d] $o $0 $o $0 $d6,5d] $0 $0 $0 $0 g Ithee...f 16,536 $0 $0 $116,536 $0 $116,536 $85)96 $14,299 $+ooA95 $14,299 $ttd,39d $o $0 $2,142 $2,142 $116,536 $2,142 $268 $0 $24+0 op ait�'nal pro �p 10,738 $0 $0 $20,738 $0 $20,738 $1547e $2,580 $3A58 $2,580 $2ob38 $0 $0 888 See $20,725 See $0 $o $88 The t tall Sent:H 6bsh al$m of F.a.,al and Stm..ent Mmch W po 83427 80 80 83427 80 83427 82,5]0 Sd28 82A99 S428 83427 $0 80 80 80 83427 80 80 80 80 . l:oumy'..chsls d..to 1. 5+,55d $40,459 $0 $92A13 -$5d,d23 $37589 $7,515no $1,253 $8)68 $1,253 $11-0 $o $64,621 $o Sono $+0,+98 -$+o,+98 -$+]e -$+o,+98 $0 $23A0+ $34,-D.I=sne tv..rnotO vke par�keot the ro amen 3A99 $0 $0 $49A99 $0 $d9A99 $49A99 NIA $49199 NIA $49199 $o NIAI $0 $o NIA $0 $49A99 $o $o $o $o unry mm a or ours ee 80 82 2 80 8262 id 80 8262 id 8262]d NIA 8262]d NIA 8262]d $ NIA 80 $ono N. 80 8262]d 80 80 -83P -839 ineli ible for reimbursement.. "•m✓ 19352 80 $0 $209 52 $0 $209 52 $+40332A] $23 88 $+6372+A5 $+63]2+ 80 80 823 89 $23389 $+2++0 $23389 $0 $22 d2 $++d]cna-d .ants were ak.matle f.rtmg $0 $522055 $0 $522 55 $0 $522 55 $370]e NIA $370]e NIA $370]e $153437 NIA $0 $+53 3] N. $153437 $524115 by$d,900.Th.amount in 00 t0A00 80 80 S4,910A00 80 Sd,910A00 83,959A15 81]2,1]0 S4,132Ae6 81]2,1]0 S4,304256 8363,165 80 S4A00 -$dA00 $d,299,356 W03.7i.n W tilliaiist.a. 85A2.]9 is still i$v 62211n.Addt D.id t.D..d.p.irsg 10613 $o $o $+280d 68 $o$+280d 6e $8502 89 $t+] $9919]t $t+] 2 $+t336 52 $t 62 $0 $146e+5 $t 6e+5$+280d 6] t.f+z.2.D++not paid.the time..bli0mi.n t.$68A27.19 $0 $0 57 85d]35 $0 57 85d]35 $5 906 68 $882195 $6]89 62 $eez 195 57 6]+5] $6 365 $0 $+83]9 $183 d]9 $]85d]36 g'sea 3de°ae a e $143,550.98 is still in valiaai.n.$6,665 will b.-Ho-a 80 80 82,2d,1]3 80 82,2d,1]3 S1,dd2A68 82do,d95 81,683A62 82d0,d95 $+,923A2 Std3,551 86,665 8152,366 Std5,]Ot 82,069A58 6 $32]]]t] So 831,]d9A93 -85d,d23$31695469 823 d9dA69 $i]62,]]t $25,257.>A9. 82]39382 $2892+22 82 t28]29 $64,621 $10,736 $t982A30 $ to t98 $+y6t e2$3o959A1e $2],3]t $26. $58,704 $31 A66 to p q l+u/ W W ° W Packet Pg. 1054 D.1.a Paid Expenses by Fund as of 7/31 /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 $260,891 $3,456,590 125 0459110 Operating $3,470,917 $8,363,910 $2,566,746 $14,401,572 125 0459110 Capital $46,642 $24,551 $1,165,359 $1,236,551 Total $6,026,738 $9,074,980 $3,992,996 $19,094,713 Card Sound Road - Fund 401 401 22559 Personnel $0 $0 $0 $0 E 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 403 635102 Operating $3,505 $272,555 $63,591 $339,652 00 403 635102 Capital $0 $0 $0 $0 Total $33,621 $281,163 $63,591 $378,375 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 $834,420 $26,372,495 414 40003 Capital $0 $0 $0 $0 - Total $1,375,916 $24,213,438 $834,420 $26,423,774 E TOTAL $7,542,048 $33,670,307 $4,907,205 $46,119,560 ° Packet Pg. 1055 D.1.a Estimated Damages Submitted to Insurance as of 7/31/19 Total After Payments Amount in Buildings Deductible Received Negotiation Citizen's Property Insurance $4,472,350 .fy(i;t(i;t!5,E3 2 E3 $3,490,385 Wright National Flood Insurance $1,411,262 $74r4r,234r $667,028 Lloyd's of London $12,803,536 $5,00,00 $0.00 $18,687,148 .f6,7«4�0,062 $4,157,413 as Vehicles and Fire Apparatus and CL Portable Equipment for Fire Rescue Volunteer Firemen's Insurance Service, Inc. VFIS $560,639 .fy:�Or:„Ori;�rk8( ) $197,011 Florida League of Cities $41,194 $41,1I94r $0.00 Progressive Insurance $1,860 $0.00 U- $603,693 ,fy406„683 $197,011 � E Total: $19,290,841 `7,146,7+°P5 $4,354,424 a cv 00 cm CL a� M E a Packet Pg. 1056