Loading...
Item D17C oun t y of Monr ELj » °o � i� G�, � BOARD OF COUNTY COMMISSIONERS � Mayor David Rice, District 4 The Florida Ke s lv ', y f i I w; \ Mayor Pro Tern Sylvia J. Murphy, District 5 ; ,= _ :' j Danny L. Kolhage, District 1 George Neugent, District 2 Heather Carruthers, District 3 County Commission Meeting December 13, 2017 Agenda Item Number: D.17 Agenda Item Summary #3693 BULK ITEM: Yes DEPARTMENT: Budget and Finance TIME APPROXIMATE: STAFF CONTACT: Christina Brickell (305) 292 -4466 N/A AGENDA ITEM WORDING: Approval to advance up to $5.1 million dollars from Planning, Building and Zoning Fund (Fund 148) to the MSD Solid Waste Fund (Fund 414) as needed for cash flow purposes for that Fund and up to $19.1 million dollars from General Fund (Fund 001) to MSD Solid Waste Fund (Fund 414), Grant Fund (Fund 125), Marathon Airport (Fund 403) and Key West Airport (Fund 404) as needed for cash flow purposes for those Funds. This short term advance will provide cash flow until reimbursement can be received from FEMA. ITEM BACKGROUND: Cash flow is needed in the solid waste, grant and airport funds to cover costs until such time as those funds expensed are reimbursed to us from FEMA/Grantor. This transaction entry is only recorded on the balance sheet; therefore, there is no budget impact and the intent is for the funds to return any advance borrowed in the short term which would be by 9/30/18. This short term advance is in compliance with the boards' financial policy with respect to reserve fund balances and minimum levels of adequate operating capital. PREVIOUS RELEVANT BOCC ACTION: N/A CONTRACT /AGREEMENT CHANGES: N/A STAFF RECOMMENDATION: Approval. DOCUMENTATION: Short Term Loan Summary FYI Fund 148 Detail FYI 8 Fund 414 Detail 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: Revenue Producing: Grant: County Match: Insurance Required: Additional Details: If yes, amount: REVIEWED BY: Tina Boan Christine Limbert Kathy Peters Board of County Commissioners Completed Completed Completed Pending 12/05/2017 11:03 AM 12/05/2017 12:18 PM 12/05/2017 12:27 PM 12/13/2017 9:00 AM L C C L m U L i se sR se sR sA sA sR sA se sR sR sR sR et CD 00 W ar ° ° s o s V5 W) fie fie �c W a fie sA sA Ge fie H ON 00 N t` N go 01 eV eh �,, O1 M G e +i o ei t- = �o en a-, h 00 Ge 00 N r M 4 fq kn bus 'bR d b N M bR bR bR 'C 1 �D v kn ON N eq G 0 M kn l- tn kn kn W, Q o C O 00 W en t w e , se r. ` sR 00 .� en W� sR se fie M O Ge �, , ,� eq fie go ag kn "o eV o ff, M o in b�R, b�R', M �o p e4 e` Ge fie o fie r y ,•; sR sR fie M H le t` C 01'. .�-� '. 00 solo go eq r-il f eV e M 00 l- t` V kn N f/9', bl4 Gl4 y4 Gl4 bA le sR 66 bR t- r � 00 l- Rn in w en eq N r sR' .� vi' fie s9 c " en �' sR t- �Cm �� oo O kn �+ ti �^ N 1A 95 N WW k 00 Ge Ge N 95 l Q t- M V5 V l�� V5 M f/4.I fie o l bR w a C3 U U U P C3 U ooc a,o m 0 c� 3 0 LLM f� V 0 00'000 0 0 0 0 o'0'000 0 0 0 0 0 0 0 0 0 0 3 0 ��000 0 & 00000 0 0 0 0 a 4-j 0 0 Q' U C N (0 (0 0 - 0 M :3 U— :3 U— — 0 C L— (0 C Q' U O IV cu 0 0 N ' � U- o�°°� cn tm V E . 9 U L (D t/) CD '' 0- 0 U) W U z a m z D LL W LL rl O G1 z B z W W H a IA W D z W W of n LLI LL H H W LO U r-I � O � N ca CO � � m n � M' Ln � Li ... Ln ca r- M 0 � w W U z a m z D LL W LL rl O G1 z B z W W H a IA W D z W W of n LLI LL H H W LO L m n � M' Ln ... Ln r- M 0 0 Ln pq - cn oo � � wl � N W 'a Z m •> > up a oc � CO LLI c Q v LL z E of V ~ Q N - L U n O C e0 z rl a f6 v LL . LL j W m L `� \ C G1 O -W O H CC O U LL U \ G O W � H � a t Z (n 2 U o 0 ~ O W Q. v c W z C E LU H v Q f6 E GJ � 4 N H O W W U f6 f6 m LL 0 N co N r-I O N L 4-j Q f0 +--j t/1 W W U Z Q m 0 Z LL UD rl LL rl O Q11 Z Z W W H Q n O ��-I � R* N p M M Q11 O Il r-I In O N St h rl M M I- M N LD O 06 '' N 1A 1� N M .�-I Ln n M' LM qrl N r-I lD 1� Q1 R L dxo 7 m 7 .m GJ W m Q cc Z C g � eo Q. O LL ONWC CO V z ° a m o DT-4 V J 4J U p cm W 0. 1� % I cm W W Fp U. 4 ^ LL rl% m O H E C 0 O cn (0 Q C7 a ,} C O U m Z O CL i i 7 41 H' U E m O C W 4J y G1 4� -r- 4. Z O O v > V W Vf (A LL (1) (U N E -W H (n (n Q iz O W W W V Z Q C0 Z LL to LL tC a-I O D1 Z_ Z W H Q H W D W W of n rl LL C LLI C H G H W � U O � N � u ca � CO � -0 Ll C: N m LL. Q m co � + Q + O N � co w w W V Z Q C0 Z LL to LL tC a-I O D1 Z_ Z W H Q H W D W W of n rl LL C LLI C H G H W a, c o n rl LL V E h W a u N GJ U ) 7 Ll L 4J GJ 0 > N N 4J L C co co _r_ Li 4' U O H W OC H Z W CL W n a-I LL C W Q H W u -a e N Z P% Cl Ll r4 N m 00 m DO + Q + co w O 0 C'Ln E R LL O G1 Q a, c o n rl LL V E h W a u N GJ U ) 7 Ll L 4J GJ 0 > N N 4J L C co co _r_ Li 4' U O H W OC H Z W CL W n a-I LL C W Q H W u -a e Z �> m m DO + Q + Z w O Q. E LL O G1 Q C LL LPL O N J co h M T „ H 7 M O LL \ w DO M O s Z H U D m W Z Q. E Q H m h IA W W O W ° N d d . N W wai WWp N u d e W � $ e � U N d 9 m w N N m W d � N a [aP N W %IN !!I O vl C Q U C C � T W te r, � � w n (V�V of 9V� punj - ueo wisi lion ) I! p(] 9V4 pund �Aj :4uowt4oe V 0 0 $ m O O N O O O O v O N a n a a g P O O h h F �00 C VI e fA a �' V � • ai U el m d W OI U p 8 U .� m m F �b°ia8n°�.'e � � � bggbW bggb�P4 U ed b gg b U u mup T'�ty m A l ' e � e W e �p � � F Q a F a W F a w a w r w a w a w O W m F a u F u of h O VY E V Vj a O y U � l9 a a O N N N O M R 1 o m. R V. O 8 v v oe'.. W h o o ° P O v m a m N a kr h O O b � O O p O p �. b y, ge N � •--i O� b t P � Q. V T i3 q t Q P W a oo �mne e `n ° w m p N a V1 p p p p N b M a m O i3 d .. Qk N N d l�Q� r: NGG of f� GO b r r ce O: o 0. N O �' ~ t a I q r m o6 o6 of N O NN �`.. of h M G ° : �O sT � of N P y O O V1 O ' ff H ° V e m �+ b t h m rl .� Nl W a I O ay b O a M.. �. U N ¢ o v N N W m .--i b o 4e O t��t n S. P t-: r P r w O vi m r r N �. o l N Iw N gyp: O Or a �NOat+ rot p � a o a N O N b v of O m �. m e P . m O b 8 M r v a O .+ Oaar pp r W M m 0 0 of r h.. M� h O n O N m!Q u N v rT. O a a P a N W N •--^ N ° � V R b 0 0 $ m O O N O O O O v O N a n a a g P O O h h F �00 C VI e fA a �' V � • ai U el m d W OI U p 8 U .� m m F �b°ia8n°�.'e � � � bggbW bggb�P4 U ed b gg b U u mup T'�ty m A l ' e � e W e �p � � F Q a F a W F a w a w r w a w a w O W m F a u F u of h O VY E V Vj a O y U � l9 a a O N N N O M R 1 o m. R V. O 8 v v oe'.. r E rn te e. h o o ° P O v m a P b O v a t m N P r t R ool O O P O r l�Q� r: NGG of f� GO b r r ce a �' ~ t a m w; oa a N O r. m r m P r IR O NN �`.. of h M G ° : �O sT � of N P n H ° V R O M o mm 8m a 4.. O O Y a s t p �erA k a O m m .--i b o 4e O t��t n S. P t-: r P r w O vi m r r N �. N gyp: O Or b m O b 8 M a O .+ Oaar pp M m m 0 0 of r h.. M� h O n P O O P p R N N m!Q Q N N b of O N O v o v rT. O a a P a N N N •--^ N ° � V R b 1p.. b t°n t O a +o vw � �N t+ri°iI .--� P: � �on It r� N i O. O pb r � N oc Q°^• �� h� : N� N a � r m H N N N v O N h P O h b N O m 10 N N O n b e b b a� r W o w m r b b a N e Q .. R n O R n o6 8y O r o n O b " S h r tin .+ c O. N N N r t O h di„'. V v t . O tt ' N m IL m ooc M r m� Q m r m. r 0 0 $ m O O N O O O O v O N a n a a g P O O h h F �00 C VI e fA a �' V � • ai U el m d W OI U p 8 U .� m m F �b°ia8n°�.'e � � � bggbW bggb�P4 U ed b gg b U u mup T'�ty m A l ' e � e W e �p � � F Q a F a W F a w a w r w a w a w O W m F a u F u of h O VY E V Vj a O y U � l9 a a O N N N F Q � o R F � � a (V�V of 9V� punj - ueo wisi lioLI ) Ii p(] 9V4 pund �Aj :4uowt4oe V C C C�7 h 2 C7 C7 h h h h h h y C7 C7 C7 C7 C7 m N M M M 'm "m M A A A A AA mm m N w w 'a o o a o o M.- Ill _ ° M ffi �� N g N �� +� O O a� m 0 � M � O N •+ O �• N V m V1 •-. • m h O O O m $� M Q M Q� {� � » V M V N o N d V „. N eTi wS wf 1. y mil. N -4 m It "'. q4. a 4 4. �p S 8 4'. it g 88 8 g q ,. a 6. g is a v ° a ` s y h ' q q p g mVYB�.> g . q Q N N. Yi � a � N b v a M S N M I S ° vl W a N g e ° M a T I I a� m � T � V � N » Z N h n• � YI YI. mm 8 C W W mz C C C�7 h 2 C7 C7 h h h h h h y C7 C7 C7 C7 C7 m N M M M 'm "m M A A A A AA mm m N w w 'a o o a o o (V�V of 9V� punj - ueo wisi lion S) I! p(] V�V pund g�Aj :4uowt4oepV V v a e o o (�) .. ao N () E V 'e ww; oci o0. m OCI I I cq N m an O '2 Co oo R O r V 4 6 .6 p P oc� m cq o o ll 'k QQ cq El ci E P 'I W z oci cz� -Ci oi Im 6 o6 m 1.9 A IS 8 A 5 N 1. I Mo cz� 06 A m 'e ww; oci o0. m OCI I I cq N m an O '2 Co oo R O r V p P oc� m cq o o ll 'k cq At ci E P 'I W z oci 'e ww; oci o0. m OCI I I cq N m an O '2 Co oo R O r V r g y � y � a m w 4� a m m (V�V of 9V� punj - ueo wisi lioLI ) Ii p(] V�V pund �Aj :4uowt4oe V m m v Z? U' C� 8 m m kF�aaaaaaaaa� s����� 6443 99999 k 1 - 1 1, .a °'t*A91q! .. .. "�m M e o rd' a � N HS. ^ � g - 3 N 6� ocL N w d O m oci r � a �0 ® V$ a f�+ N rn aC N r F. o`�o' IcL e m c o N .-, N N a pr e - m ad' d �.. v e g m c n a 06 a a m ' oa.. oknNo � ° i e v Za `?i t3 _ A M IK IK g a mono o � a �m IK ° �o �s8 eed lz 14 r it o- �, sQ sQ a S m o v O .n v'o .tenkAA N _. m _r M m m v Z? U' C� 8 m m kF�aaaaaaaaa� s����� 6443 99999 k 1 - 1 1, .a °'t*A91q!