Loading...
HomeMy WebLinkAboutDocumentation_Regular_Tab 07_6/10/2021Agenda Item #7. Regular Council STAFF MEMO Meeting: Regular Council - Jun 10 2021 Staff Contact: Jeremy Allen, Village Manager Department: Manager Manager's Monthly Report The Financial Reports presented above are unadjusted and unaudited. The Village considers revenues available if collected within 45 days of the current fiscal period. This means that there are additional revenues and expenditures that have not been recorded to date and that will be recorded once year-end adjustments are completed. Additionally, during the year, revenues and expenses are recorded on a modified accrual basis (similar to a cash basis). This will result in significant differences between our beginning balances in the enterprise funds (water, refuse and recycling and stormwater) and the adjusted ending balances as these funds report on a full accrual basis. 2. Property Taxes — collected at $7.8 million, which represents 101% of the budgeted amount. It is $387 thousand (5%) higher than the prior fiscal year. Historically, 91 % of ad valorem tax distribution receipted by the end of February. 3. Sales/use taxes (51%), which include local infrastructure surtax, insurance premium, utility, communication service and local business tax, fall below budget target due to the distribution to be one/two month behind the collection/reported period and Insurance premium tax ($246 thousand) to be collected at the year-end as one distribution, with the exception of the Local Business Tax collected at 87%. It is on target for seven months collections. 4. Intergovernmental revenues (68%) which include municipal revenue sharing, half -cent sales tax, local gas tax, show above budget target for seven months collections period due to the half - cent sales tax revenue distributions higher than budgeted (72%). 5. Local discretionary infrastructure surtax - collected at $232 thousand, which represent 63% of the budgeted amount for only six months collection/reported period and it is above budget target. 6. Revenues (Budgetary comparison) recorded in the General fund represents 84% of budgeted due to the distribution nature of Ad valorem taxes collected at 101 %, representing 64% of overall General fund revenues at 5/31/2021, Federal grants received in the amount of $160 thousand and fees collected due to the large projects (Sea Glass and Reserve). 7. Overall Expenditures (Budgetary comparison) in the General Fund represents 62% of budgeted, which is slightly below target budgeted due to the fact that not all the expenditures recorded for the services provided up to 5/31/21 and personnel expenditures recorded as paid not when accrued. Page 79 of 485 Agenda Item #7. 8. Revenues (Prior year comparison) all funds increased significantly due to distribution nature of Ad valorem taxes ($387 thousand), Sea Glass project permit and fees ($450 thousand), Reserve project fees ($122 thousand) and receipt of the loan proceeds for the Recreation Facility project ($6,890 thousand). The Village has also received grants and DEA forfeiture funds: - Corona virus aid relief grant - $133 thousand; - Police reimbursement grant for the ATV and UTV vehicles - $33 thousand; - DEA forfeiture - $92 thousand. 9. Expenditures (Prior year comparison) all funds slightly increased due to Recreation facility and drainage projects offset by decrease in Water utility projects. This document and any attachments may be reproduced upon request in an alternative format by completing our Accessibility Feedback Form, sending an e-mail to the Village Clerk or calling 561-768-0443. Copy of 20-21 Grants Master 6-7-21 Copy of May 2021 Managers Report.ADA 2021.05.Utilities Monthly Dashboard Financial May 2021 reports Page 80 of 485 4) m 4) N s 4Cr N � O F 4— 4) O 4 m m a•+ c o O C� m m m o m 0 CN CN CIO CD C) c o 0 C) 0 0 C) O N N N N N N 00 r N m C N C\ M C\ M w i M N N Ln C) O O O N N N LL LL I LL O O O O O ) O O O > N N N N .) > > > N N N O �C V M N \- M 0 Of N N N T N N L as N ti� (fl M M N N N N N N 0 O O O � j O O CILO >-N>->->->->-� Z LL LL Lid LL LL LL LL LL LL LL U) U } O O 0 cn � CD0 E U > E U U -a}, 4- � CDO Q a) m M E U () a) a) O OL (� E E E C C C C Q LU } O O O O O O 06 L O a) M O E > > > O O L CO E E U C � J � W W W ° E •� •� •� >_ W W � 0 (a 0 0 0 O O Co C _ 0 C:) M cv M CO a) � a) a) a) W W 2 2 2 E o° E E E a) o o� V- U C O m ° C o o L C E co M M M co �. a� -0 -0 - o Q 0 M M M 0 c w N 0 0 (� m m m= a Cc o m m m m m m m cLa m m Q C� C� C� LL p� E o����� m� U cn O= 0 0 0 0 0 LL m LL LL LL LL LL LL m a- LWL U U U lO m (n c as L L L L L L O O CL A� a) a) a) U U U U U U 0- 0- 0- 0- Z) Z) I Z) 0� I LL I LL LL I LL 1 0- 0- 0- 0- 0- 0- +r a) > � C6 C O 0 Y L _CU p co _ n (D O L L C U C (6 LL C) C� CD O a) a p U L O o � O LL (6 p L O _j� C� U 2 _ U) 0 co ° U) LL U m ° L yam— W W a N U J L >, a) a) VJ D) .— LL O a) ' ' C c> - a o p O p O O ai o W Q m vi m 0- CL� Z> >� LL U LL U IL Q>� O W cn ri 00 M r-I f V r-I M 00 N r-I N lD 00 M O '9t N N r-I M r-I M Ln N Ln r-I r-I 00 M r -I 00 N (V N r-I 1-I l0 r-I r-I Ln M r-I M I� N r-I M N c-I r-I O r-I r-I r-I N c I ci O N M \ 0 Ln M :1- 00 c-I 0) Lf1 It 0) LO ri N M Lfi O I� r� ri r-I N ri 00 W ri Ln -tt w -tt N O ri M O 61 Lfl Ol 00 M O N l0 r-I ri ri ri ri ri O O M � � M r-I � N N N 00 O 00 Ql 00 M r*lr14O,OO 0 Ln ri N N rn O lD l0 N N - N MI -I i -I N lf cI CV N CV r-I 0 \ M N N N ON N O � M M r-I L O Q � E v _o Lm E > M O Q� an > to E N 3 a nn •� aco o v 'c �00 'a '^ 6 2 C O to O += E •F, o Of a, 0 a•L m o ° a ' a- °m E aj a > a) a) H E< uE a- 0 E = O O CL O u OvO +° U a a ov a) o 0° O D U01 v a)c —ro Ecn —3co v o U Q > +aca0,,, �v_ •v Q 01 pLn 0 \ a W a1 a)O w d O n3 2uJ0Uv _ � LL a vE y_, v w U U U UE aj w u o E �-a0�� tiE a, a,a3o[2�a, oo >vo v` awowUoonwoO I oMa' d Z U H LL of U H° ucl) O w U oc a� U w co U Z oc - 0 0 0 U 2 Page 82 of 485 N �t O O ;t .--1 -A O N O m r-4 c-I M-A N O O Ln .1 N .--1 r-I O M c-I N lD O O O O O N 00 00 O n Ln c-1 N lD 00 r� I O Lr) LO Ln N c-I M l.n N O N O O Ln O ran 0 0 0 Ln .1 -1 Ln 00 0 0 0 0 0 UD O r\ O w O r\ N r" N N -1 00 -1 O ill 0n lD N O M N N O O tD O -til O O O M n -1 Ln 't O O O O OItt N �n lD 01 00 N rV O (.D N ci 0) .-I O w Ln w N c-I rn \ m rn 0 N a1 7 n C m U N =3 - L) � d N U aJ � � N L U T .� T L g C 0 p V U O c O U L t6 +J co � G1 c LL V N L aJ Y 7 v) (A V O � j +' O U cLi N U a) w m m M cn bq 0 v a E Q o > N � M to `�° m c a Q ~ Z kD O O > ++ aJ E N a1 M i N a) i a1 i O to - m �+ a1 ++ i bA E 0 aj UA O_ O pa \ �, C v C .N E C v Q a, c-0 a) a) +r a — ra U ao 3 LU +' nn M O p c c Q v, O ca O , 0 > p •>_ Q1 0 T CD C a) of E C a) O .s .E L L Q Q Q > E 0 C a) Z f6 •f6 H M Ln N 0 0 ccN C 4D Q ccN C ,�, d m +' c In �..% L �--i L ai a1 C L 7 a+ 0 an x " aJ E a1 2 += a1 ~ Q a1 - oC LL W Q cn O M > p Z •� 0 2 � E � U E O ++ E U > N t C. C C C O a) .*' C O (D 2 (D cu O aJ aJ t ra 0 ra +� V) co 0 0 Q N H U= 0 a a Ln D 0 0 0 2 0 i Page 83 of 485 -1 # -1 # m m # # 7 -i m 2 % % $ \ \ / I $ \ N 00 ® 0 < § o 0 ƒ < m o@ o L e o o m m m�» m m o# e N m o o N -Ao -Am m e N g _ e N Q Ln < o m o Ln N o < r- m rl o� z_ z o e o o z N m�_ o_ Ln § / § -C _ a � •E � m% m z o \ m o ± § 5 y / § U � ■ E ao { Q 2 2 § A Ln k R _ 0 w_ § co § ( § f \ z k § # $ \ t e » ° s { t ) / § @ ( / m § _ m § > % — G \ y E « e ¥ § - g < \ § f � 7 ( \ \ 2 # E O ƒ ƒ » / ± \ \ 2 / ( \ co G [ 2 = � Q 2 § j } 0 \ K \ G ± « / @ 2 \ /� # % : p » \ \ 2 § / ( \ \ § ® 3 9 y e G & / @ m \ � / 2 / \ \ » -0 0 W \ } \ \ [ \ ( \ \ ) \ \ \ \ / / ƒ 2 / / = n \ / \ _ z< J Of_°/ a 2 G 2\ 3 2 2 2\ G > 7 » � u> 2 5 CL c-0 a = of Of. 8 \ / 2 / o < f f / cL ± ± / 7 \ \ \ J ƒ } k 7 Page 84 0 485 N O O Q Q Q N O O O LO Z Z Z 00 N N 00 O � LO O n O O O O 00 m N N O N O O O .�-I Ln iN-I mm O lO0 m LD Ln U) m 14 N O N O O CD O Ln 0 0 O Z Z Z r-I �n O 00 i11 O I,,('1 O O O O LI r- 0 0 Ln l0 M Ln e-1 N O N O Q Q Q M N N O O O O O V'1 O O O O O N Kt Ln O � O n O O O O O m m O O O Z Z Z U Y L (a � L d 0 O � p o = v L cif V O � O v C Y � � a Y E L + O V1 Vf u a 3 Q � a1 aJ H i a t`Aif QJ N L la cn a l0 C s U `A fC � 0 � — n3 O •+, L N H O '++ i U `� N O Ln � > Y in •ro on C '� co M C OL N bA O a1 OJ N p � u — `n +� L.L. M n3 C Y a, i L L m m m m u) `" U IA W O bD d "6 p �A N � J C �' a1 aJ iA >- p U N U O_ O i C .� O a O Y L I- O a tO O w p m >_ L +O—, i cn cn c F m O a) uZ 0 a m % p L L U w c N O O aJ O w (U +' +� a1 +� aJ O O V w C CL .O v v ^ Q y T a v H � w N a' ca > O 2 d U Y LL U 1n m— o rn w w w U Page 85 of 485 O O O O O O 0 00 O O M N m O m ri r-i r-i M m M 00 0 N � LD 00 } l0 Ln O O O O Lf1 N 00 N O 00 N N N N m -A � -1 .-1 -1 N Ln N 00 fS3 M Lf1 Ol l0 00 N M Ln 11 c-I M N 00 M r-1 00 N N m N O 00 r-1 N O On O OO -1 n O 00 w co N N N N Ln c-I c-I M c-I N Ln N N lD Ln c-I ri Ln Ol O1 M N fV Ol Ol ri r-1 O l0 r I O 00 O O O 00 N lfl O O O r-I M -1 N ri Occ ri n rN-I —1 O O0 M rI M Y m aJ 41 LYi� c ri E ri s O c0 m E Q 41 tA O N a °J a, v v a1 Ln E c of6 p V) 41 _0 3 � ri u E n ^ 3 � aD o c o .° a) ai ^ N f0 u p aci O •+� c O -O LYn 2� O L2 W as ro c 0 , E v o O m + c w v cc O aJ u N O -O \ C U V 2 0_ cc U f6 c ate+ O a' C C 1n a1 v Y m 'O 'a C m -O u v M +' 7 — v 7E c E=" c w v w Ow c c m W k9 - ° 6 U h w a1 0_ a) Q E E '+' .c f0 (a 4 - +, N 0a -0 a1 � _ Y U T C c c a� Ln ._ L- m >� + U v v E Own O •E ns O m cci c =�c O w c E I U 0 o �U 0A a 0 �cc O a L v ++cu Ov va >O v iiiaJ aJ-a, E 0aOOOOOu u s> iZ E E O U LL s Q U O O O O ca N Q s O O ^ ; 0 W Li- W Li- W a a a m C7 oc L in > Ln w U a 0 u a Page 86 of 485 N M W N 00 r-I 1-1 W cr)U7 O rl w m O r-1 m N N N m M LO r-I fV O O m om o N N m a I oo o w w o m m a M c N � fV ' m O �D Ln Ln Q rq 00 ri I- N N M 00 m Ln m � N m w a Do 0 � D0 0 m kD 0 � � Ln r-I Ln M 't r-I M o \ N :I- LD O r-1 M c I CO c-I r-I a, O n cn Ln m m o m N a m m o0 0 M m ri m �o rq o -I m 7 N � m m N lD N ry.1 1-I r-I o N Q \ N 01 O IZI- l�D cM ^ \ONc-I MAO O O O MW kON M M lN c-o O r-I N V CV -i rq m � ri t V c Y O O E v t Q U c O >. u E v 3 v � a s a v Y Qj v v E v aj u 3 u bD > o c Q c Ln v '0 N 3 N n3 S ai N C D1 N bA '6 E (D '�.+ fl_ N Y U N ccO � 2 � C L -0 N -O -O -O -6 C t N 0 N Qj v v v WE N MU n3 U V bD OD o `o r u u .L i [6 00 W i in O- C O O :++ O -O E E O1 n3 v Y C N bD O O " O! M C v W N N '� f� C O '� C D! Y C O_ N C DJ y0,, C 3 V) C L d n3 LL' N N N N N CC C f0 O = L C '� U U U O F+ C u O N .L N .L DJ .L DJ 'L O_ Y OD SZ — O M O L _ •O C CD Y V1 (6 — N y N i J > N J O! u C N ++ *' O *' O -O 3 N UJ H U O cc a 30 p d ro c O a1 O O DJ Q =� '00 N O Q O O O v ra O N OA D C 6 v i a o o a 0- a LL a Ln � > m V U V w w o Page 87 of 485 M Lll rl 1n N O N 00 O m, Om LO 00 Q 00 � N 3 3 Q 1n Q m M M i--I um'� M c `1 c 1� Z o0 M Z D D Q Q Z Z L n LO r-I O 00 1n N 00 N Ol Ol Lr) N N r- -i m N M Ol U) M n O (0)(.0 00 O N m 0 ZY LO N M -1 N ^ N N LD Ln 00 LO rq O ^ -1 l0 M N N c N Ln Ln Q Q Q m Z Z Z +Q+ O f0 Ln 1n N ^ m � 00 00 m m Q I- l0 0) Ln 00 O N N LD Ln n m 0 O Ln O1 a) 't 00 t0 N i N N N N �""1 .-I � m r j `� Ln 000 00 c-I r-I m N \ } N c-I N L o N m N n N M Ol w Ul M -I Ln M O LnN 00 1--11 00 1--1 M -1 ra M O O LD lD n M �--I N N M O�j N 0 Ln r-I N OO in C � +i U a) c O E a N U a) L Q N 0 O Q E W a) H � v a v � N C) N Y i i= V) *' O O O O o U u ro _7 o — u ++ n O O D N E ) a) 7 OU +.+ N aJ N (6 to f0 0 OA> CL OL0 G U u _0 a) -0 V) U U U OO > m O E a) 3 .1 (O a! dO a-+ -6 C Q ) N N v 4A — _ w w c a) U O _ J to n3 U a) _ LA 0 VNi c a) U a) U Q O O 0 C m to � '^ Ln O LL V) O d b8.O N O v a+) o v V) u au) ++ Oc - 0 o_ o o LA a `0 o E E `^ ns 0 — Q Q E'n p o° U a °' °' a 2 3> a n L m ar 0 3 a3 c c E E E a o a n u +� L v nz C Y a C E E v v a) tin 0 0 o O N `" N + i a) o 0 0 O o 0 ra as ra ns a) v z E Ln CA v a c O u v> -0 z L� Of a \ �° �° o° LL a0 ao Q — \ OC '� _ — -Own3 O H c c C: � a) bO a) -O u .- w a) 00 c c u u m u m 00 ca ++ O +� �n �n O O L O a1 a) E C a) c 7 O 0 a) L m w J m -0 c M a) a) m �--� Ll Ll d O 0 = — O _ i* i* d U 0 N CIA a u o o - o a_3 a 1 a a z a m Page 88 of 485 g 3 0 / 6 0 % f = o \ §to R ) 2 » 7 E ( E = \ ) / \ k \cu < ® E -ac \ _ \ E u \ $ j § ( $ ° ` } \ \ \ \ J \ / 0 / o/\ 0 f§ 3$-0 g / k E o \ u k\ 9 f = m G § ; o -0C/ § m = = b $ ° 0 2 f 0 / ° cL \ _ - 2 @ \ E } U ` o § /) m / = o < » » _ \ / ® 0 $ s ) 2 / z f § : 2 E e : a -0 2 § \ 4 -0 ? \ % = 2 - o m g m- \_§= a k z y \ \ ) § % m E \ / c -le § = g Co O : z � � 3 � - 6 a « § $ \ ) k \ © ° 0 _ \ E » a ± 3 $ { _ 6 7 c ; i _ $ •- m \ ) / \ g 5 / _ ) / m § \ \ f § \ u _0 $ \ \ \ \ \ k \ \ \ \ \ G \ \ \ \ \ � \ e 2 2 & ! / k p \ E 2 § \ & § \ \ - £ \ 2 o 0 > { % = � ! @ G \ 2 / \ � 7 7 J { ) § ai s 3 _ { g 7 q / v) » ' / � 0 ( i 2) / j f . / \ \ \ E { } \ k c / O o 3 n / ƒ 4 » E * & \ / < f / \ ) Page 89 of 485 c� (A O N • q ��� 09 ® T� m P� ' 9<11d . P 0 0 0 0 0 0 0 t"- JQ l� q y ��P� 0 0 0 0 0 0 0 O o O O o C C 0 0 0 0 0 0 0 0 4P o C C C oN 0 0 C C 0 0 oN Il tD m � m N r-i V? t4 V? t4 V} t4 t4 O I, O lD O O O O O Vl �t m N -1 t/? !-I c-I Vi Vn to V) t/i to r� f ]� r� ° P,, + I � o O O���Ph d 3 00 Oc,�P� o � JO Iv �dqq q> o�a d dOLO4J a) CC ✓dO q<,, i Od =E O"d7, ,d a JI O"0 C O qp;, o e ■ gOrJ o O - ul 3 �d q4'a t �d q4'a .i U o� ." o<-, �aa v E GJ > o2 b o� b u ■ c� Q 76 Oe P� 1 �� P� ■ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 V} C C 0 0 0 0 0 0 C 0 O O 0 O O O O O O O 0 O 0 O V} O O O O O O O O O O O O O m 0 m O Ln O ul O uo tzll Itil m m N N ci ci V)� O N Ii O 0 ci 0 O O O 00 �D V N to V} V)� V)- 0 ul 0 0 0 0 O ul O Ln 0 0 0 0 O Ln O U) V} -L } V} V} V} t4 V} V} V> t4 f -zt m m N N r-I ci �7d1�L�t BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/8 acan fF/ Period Ending 05/31/2021 DB: Tecruesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 6,821,940.22 Investments 24,585.32 Accounts Receivable 265,400.32 Due from Other Funds 0.00 Inventories 67,001.63 Prepaids 58,745.87 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 7,237,673.36 *** Liabilities *** Accounts Payable 13,227.66 Accrued liabilities 118,842.35 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 1,206.63 Deferred Revenue 0.00 Other Current Liabilities 0.00 Customer Deposits 0.00 Noncurrent liabilities 0.00 Def Inflows of Resources 63,349.26 Total Liabilities 196,625.90 *** Fund Balance *** F/B - Reserved for Inventories 0.00 F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Ncnspendable 290,921.10 Fund Balance - Restricted 420,582.76 Fund Balance - Committed 500,000.00 Fund Balance - Assigned 298,661.00 Fund Balance - Unassigned 1,884,303.78 Total Fund Balance 3,394,468.64 Beginning Fund Balance 3,394,468.64 Net of Revenues VS Expenditures 3,646,578.82 Ending Fund Balance 7,041,047.46 Total Liabilities And Fund Balance 7,237,673.36 Page 91 of 485 �2d1�L�t BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/8 acan fF/ Period Ending 05/31/2021 DB: Tecruesta Fund 101 BUILDING FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 1,595,672.72 Investments 0.00 Accounts Receivable 0.00 Inventories 83.95 Prepaids 1,257.75 Total Assets 1,597,014.42 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities (17,008.52) Due to Other Governments 700,959.42 Total Liabilities 683,950.90 *** Fund Balance *** F/B - Unreserved/Undesignated 0.00 Fund Balance - Restricted 1,151,130.04 Fund Balance - Unassigned (495,196.87) Total Fund Balance 655,933.17 Beginning Fund Balance 655,933.17 Net of Revenues VS Expenditures 257,130.35 Ending Fund Balance 913,063.52 Total Liabilities And Fund Balance 1,597,014.42 Page 92 of 485 �7d1�L�t BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/8 acan fF/ Period Ending 05/31/2021 DB: Tecruesta Fund 301 Capital Improvement Fund GL Number Description Balance *** Assets *** Cash and Cash Equivalents 224,376.81 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 224,376.81 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 0.00 Fund Balance - Restricted 240,480.00 Fund Balance - Committed 46,485.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 31,690.53 Total Fund Balance 318,655.53 Beginning Fund Balance 318,655.53 Net of Revenues VS Expenditures (94,278.72) Ending Fund Balance 224,376.81 Total Liabilities And Fund Balance 224,376.81 Page 93 of 485 �7d1�L�t BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/8 acan fF/ Period Ending 05/31/2021 DB: Tecruesta Fund 303 Capital Projects Fund GL Number Description Balance *** Assets *** Cash and Cash Equivalents 5,861,934.61 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 5,861,934.61 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 46,563.00 Fund Balance - Unassigned 9,702.79 Total Fund Balance 56,265.79 Beginning Fund Balance 56,265.79 Net of Revenues VS Expenditures 5,805,668.82 Ending Fund Balance 5,861,934.61 Total Liabilities And Fund Balance 5,861,934.61 Page 94 of 485 �7d1���tr BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/8 acan fF/ Period Ending 05/31/2021 DB: Teauesta Fund 401 Water Fund GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 5,625,834.56 Investments 40,639.03 Accounts Receivable 161,326.31 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Inventories 250,194.82 Prepaids 13,766.88 Other Assets - Current 0.00 Land 83,335.00 Other Assets - Non Current 83,335.00 INFRASTRUCTURE 15,370,162.19 Buildings 241,365.80 Improvements Other Than Bldgs. 27,011.20 Machinery & Equipment 325,011.94 Construction in Progress 0.00 Intangible Assets 28,993.85 Other Fixed Assets 0.00 Deferred Outflows 538,799.71 FIXED ASSETS 0.00 Total Assets 22,706,441.29 *** Liabilities *** Accounts Payable (5,926.36) Accrued liabilities (101,087.22) Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 251.53 Deferred Revenue 0.00 Current Portion of Debt 412,997.17 Other Current Liabilities 0.00 Customer Deposits 53,356.78 Noncurrent liabilities 2,721,115.19 Other Long Term Liabilities 483,856.31 Def Inflows of Resources 156,780.00 Total Liabilities 3,721,343.40 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 11,584,763.87 Net Assets, Restricted 0.00 Fund Balance - Committed 500,000.00 Fund Balance - Unassigned 7,223,463.86 Total Fund Balance 19,308,227.73 Beginning Fund Balance 19,308,227.73 Net of Revenues VS Expenditures (323,129.84) Ending Fund Balance 18,985,097.89 Total Liabilities And Fund Balance 22,706,441.29 Page 95 of 485 �7d1���tr BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/8 acan fF/ Period Ending 05/31/2021 DB: Tecruesta Fund 402 Refuse & Recycling GL Number Description Balance *** Assets *** Cash and Cash Equivalents 295,194.21 Investments 0.00 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 295,194.21 *** Liabilities *** Accounts Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** F/B - Unreserved/Undesignated 0.00 Fund Balance - Unassigned 118,576.84 Total Fund Balance 118,576.84 Beginning Fund Balance 118,576.84 Net of Revenues VS Expenditures 176,617.37 Ending Fund Balance 295,194.21 Total Liabilities And Fund Balance 295,194.21 Page 96 of 485 �7d1���tr BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/8 acan fF/ Period Ending 05/31/2021 DB: Tecruesta Fund 403 Stormwater Utility GL Number Description Balance *** Assets *** Cash and Cash Equivalents 733,234.11 Investments 0.00 Accounts Receivable 200.00 Due from Other Funds 0.00 Inventories 291.79 Prepaids 0.00 Other Assets - Current 0.00 Other Assets - Non Current 0.00 INFRASTRUCTURE 1,334,459.48 Buildings 0.00 Improvements Other Than Bldgs. 0.00 Machinery & Equipment 12,758.92 Construction in Progress 0.00 Deferred Outflows 23,887.00 Total Assets 2,104,831.30 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities (7,940.25) Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 0.00 Current Portion of Debt 0.00 Other Long Term Liabilities 8,945.55 Def Inflows of Resources 10,547.00 Total Liabilities 11,552.30 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 1,236,387.06 Fund Balance - Unassigned 797,975.14 Total Fund Balance 2,034,362.20 Beginning Fund Balance 2,034,362.20 Net of Revenues VS Expenditures 58,916.80 Ending Fund Balance 2,093,279.00 Total Liabilities And Fund Balance 2,104,831.30 Page 97 of 485 �7d1���tr BALANCE SHEET FOR VILLAGE OF TEQUESTA acan fF/ Period Ending 05/31/2021 DB: Teauesta Fund 605 Special Law Enforcement GL Number Description Balance *** Assets *** Cash and Cash Equivalents Investments Accounts Receivable Inventories Prepaids Total Assets *** Liabilities *** Accounts Payable Due to Other Funds Total Liabilities *** Fund Balance *** Fund Balance - Nonspendable Fund Balance - Assigned Fund Balance - Unassigned Total Fund Balance Beginning Fund Balance Net of Revenues VS Expenditures Ending Fund Balance Total Liabilities And Fund Balance 165,379.01 0.00 0.00 0.00 0.00 165,379.01 0.00 0.00 0.00 0.00 0.00 84,976.34 84,976.34 84,976.34 80,402.67 165,379.01 165,379.01 Page: 8/8 Page 98 of 485 Agenda Item #7. VILLAGE OF TEQUESTA Cash & Investments Unadjusted Unaudited 5/31/2021 General Fund #001 Building Fund #101 Capital Improvement Fund #301 Capital Projects Fund #303 Water Utility #401 Refuse & Recycling #402 Stormwater #403 Special Law Enforcement #605 Total Cash and Investments SBA Prime Cash Investments Total $ 6,821,940 $ 24,585 $ 6,846,526 1,595,673 0 1,595,673 224,377 0 224,377 5,861,935 0 5,861,935 5,625,835 40,639 5,666,474 295,194 0 295,194 733,234 0 733,234 165,379 0 165,379 $ 21,323,566 $ 65,224.35 $ 21.388.790.60 Page 99 of 485 Agenaa item fFf. Y_ E U aJ Q O U a C CY aJ L u i 0 Z, -0 aJ bD C O LL O O aJ t6 >_ Q 0- v ° O U aJ U L 0 v Y C > GC O- U vYi O v> N LN _0 o2J N n U 0 a) N N aJ O N N > Z aJ aJ v�i aJ O 0 aJ C a) aJ L n3 O C H M O O *' aiaai C-6 C7 v 6 U v y> O Q a a v vNi Y *' O E aJ N P Y N a) N U aJ L ,� Y YO L Y .� Y Y aJ Q (7 L CA u� .� N L n3 ` CO L L m O aJ ns O - aJ L M, U aJ U aJ ra @ dJ O_ Y >' Y � O OL w (Uw aJ aJ - aJ `� " >` C >` a1 E aJ >. U O >A >` U _ N a) Y aJ O N C aJ O C O K Y 0 C N U O O_ Q O O L p Y Y L C Y M < Y L (� C W >j Y L (6 Y f6 O L QJ u i L l" 1 O Y L QJ Y >, Y y Y L (O Y L (G Ol C C E / aj QJ L O aJ L aJ >, aJ L of , -0 Y C L ,_� aJ C -0 aJ >? C aJ Y aJ >, aJ ? O O Y E > Y O N Y -0 w aJ O E C ,� E D_ oq O L N O •�, CJ w LL O O O O @ > > N w L1 i w OL N GA }- N to pp w a) Q a1 OCL N C v> n >n O w u Q w Ll 'O r- aJ C •7 O @ -0 `� O - W [a O p > i E •7 `� cL.J aJ aJ i Q 2 co U J Q 0 a LL 0 0 0 Z J Q co O 0 0 0 O W o 0 0 0 0 0 o a o 0 0 0'O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0ONO o ~ W Ln 00 0) O -;t r�r-I lO I;t Ln (.0� r-O n 00 0) l0 M N N N M O -i 1� 0) tD r -I Ln —i rn m Q z N N 1" n Lf1 O O -! O) O) O Kz� 'j: 00 -! -! t0 W 00 n ri ri K;� O r� N 01 01 1" -! 00 R:t ri D Q Ln N O al LO -i -;t N M O O 00 LD 01 Ki 00 r-I Ln 4 Ln O ri N O 1.0 -1 -1 N O O Kt 0 tD Q -i l0 O O � Ln 3 � -1 00 M O 00 1l -i M M O (V N N 00 1l z R ri Ln N O 1.0 N _1 I Cl) lfl c-I c-I O N Q o W l0 O O Cl) Ln 0) N 1l M M L1) M r- O l0 l0 n ri P, ;t <D 13 -1 M I 01 l0 w N Ln N 0) -1 M ri LD Lf) 1l O O Ol O 00 N l4 Lf) O -1 M O 00 N N N r- M W N O M 1- O N M 1* GN U O N M O -i Ln m 0) 00 O -i N O m -i K* w Ln r-I to -zT m wI;t r- O w M O O t0 N 00 Q 1, O N -i Ln Ln Ln M Ln M Ln 1� 01 r-I 00 Lr `-' r-I Ol Ln KZF N n 06 N -;I� O M 00 r-I al Ln C T:F N r\i Q 00 O K* Ln r� O N w 0) N -i �"' l0 00 01 K* O G) 0) Ln M — Ul N 1� 01 M M wZ M M -1 ri N N c-I I, O O r'I O O P% 00 N W Q Q ri .... 00 00 r-I v N C L > W > LU H 0 LL 0 d W Ln M N 00 -q 0) Ln -iI M 0) Ln -i1 M 00 Ln O 00 N W q O -q1 tD � -1 0) tD N r-I � N 00 -11 LU 0) M M O w rl -zt M O r-1 O M r-1 O r-1 O r-I Zt C) Zt 00 G) O 1- Ln L!) N zt r-i 0) 0) Ln LA M W U r-I N N O M -tt CDN Ln M lzt w lzt rn Ln -tt r-I O 1- 0) M a) G) -i (.o Ln 1- 0) CD r-I 0) N N 1� C7 W Z N lD tD 0) O Ln M rI r- M 00 M 00 Lf) M N r-1 M 00 to -i N -;t tD 00 (3) Ln r-4 r-i ri 01 1� Q Q O Ln -1 6) O tD N r-I o0 Ln tD -i tD O N M r-I M (3) to M 1- Ln (3) 00 N (j) 00 r-i M t0 N O JQ ~ J Q N 1- (3) (N n ri Ln -:t tD ri 00 r-1 N 41 a) G) M t O W N M M M t0 Q °0 r-� rl� re) rn M 00 r- ni of Z m N N r-1 ri W Ln a r X W Q 0) rn c V ma) O n') �� 1- O o0 tD q 6) O t V O O Ln rn M 1- O 00 O tD M r-IN O r� r� W Z U O M N O W M N 1- N M N Olzt Wlzt O O O W O M a--1 a--1 1� O 1- Ln zf O r-i O N N 00 Q Z N O 1� 00 N Ln N tD lz M Lr ri N Lf) Ln L() N N r-I O M -* tD O 0) 0) t O Ln O tD Ln 00 W Q O M tD tD (3) O 1- Ln M 1, Ln 00 1, 0) M r-i Ln O ZZ n 00 to 6 N 0) V r-I O rf r-I r� .--I l R Q J N lD r-1 0) Ln r-1 r-1 M 00 -:t 0) N 1- O N M W M n N M Ln 0) r-i N N (3) -* z Q (rl 00 N N Ln ri -t -4 1l ri r-I r- IM 00 r-I r-I lD N N -q w-* M W m M Z:F Lf Lr 00 N rr III Ln cc to H W LL H H Q a aJ > Q _0 CA CC Z C U C W C ++ C 7 W W CL O N U > > > O Ln CU N LL LL N O_ >n (U p aJ (� i l6 U L N H LL �..+ aJ E n3 H W z W >n = 0= O .y >n C z5 E v1 W C L C>: Q 06 U ~ > -0 U U u C = H v1 +�+ t6 c6 a) p to H H W_ W i X U C •+-+ K O_ > C2S to >` H a) U '� O Q 0 O_ (6 to a) L v - aJ E i aJ N O aJ i +' a) a) N `n U aJ Z Z W - > O +' U >. U C W +-> Z N J z W O a) aJ C > L C > p M > L i to L C� C L W W C C _0 aj L W > 'ALLJ L aJ >n � -0 L � i O � , aJ O aJ O O � O > > Q � � Q O C C[ a) � O d d W 0_ = tL aj � N N LL +p+ W - � L � t_pif 0 LLB > > f6 LL of LL 'L L en 00 d L L 06 J W W z 5 OZS L N , O W O O - O o +-' a) +� ,� aJ J J C tb� a W a) 0 C C 0 M ate+ V C 0 N CU6 aL+ a) aJ Q Q W a) +' +J ,P�g4 `n f° QJ W aJ U@ aJ t c p +' s 0 0 X aJ O m M aJ - Q� o o W CC 0 Ln LL l7 - U - = 0 U ii - U U 0� H U H H W C7 M U U � K N Ln H t- t- Z VILLAGE OF TEQUESTA enda Item #7. REVENUE REPORT - UNADJUSTED, UNAUDITED DESCRIPTION YTD BALANCE 5/31/2020 YTD BALANCE 5/31/2021 VARIANCE I % VARIANCE NOTES REVENUES Fund 001- GENERAL FUND General Property Taxes 7,369,199 7,756,295 387,096 5.25% Historically, 91%receipted by the end of Feb Sales & Use Taxes 816,023 916,233 100,210 12,28% Utility tax -water implemented Franchise fees - gross receipt 296,702 299,032 2,330 0.79% Licenses & Permits 259,889 700 (259,189) -99.73% Building Fund 101 created in Aug 2020 Grants Federal 10,299 160,109 149,810 100.00% Corona virus aid relief grant Intergovernmental Revenue 517,520 523,079 5,559 1.07% Chgs for Sery - Gen Gov 135,273 404,214 268,941 198.81% Land development fees - Sea Glass & Reserve project Intragovernmental Revenue 483,624 687,531 203,907 42.16% Admin mgmt. Water fee increase Rents & Royalties 147,494 153,303 5,809 3.94% Miscellaneous Revenues 6,968 13,709 6,741 96.75% Differs from year to year Grants - State 4,235 13,605 9,370 221.25% Police reimbursement grant Chgs for Sery - Public Safety 797,148 864,431 67,283 8.44% Fire plan review fees increase Fines & Forfeitures 8,826 16,797 7,971 90.31% Code enforcement fees differs Impact Fees 3,544 25,508 21,964 619.80% Differs from year to year, due to new projects Charges for Services - Recr. 21,569 3,415 (18,154) -84.17% Canceled recreation programs due to COVID Contributions & Donations 5,500 100 (5,400) -98.18% No donations due to Tequesta Fest cancelation Transfers In 0 31,994 31,994 100.00% Other Financing Sources 2,955 174,219 171,264 5795.72% Capital lease - SAN project & sale of assets differ Unrestricted Investment Earning 44,778 5,400 (39,378) -87.94% Investment interest rate decrease Total General Fund 10,931,546 12,049,674 1,118,127 10,23% Fund 101- BUILDING FUND Licenses & Permits 0 700,208 700,208 100.00% Build fund created Aug 20, Sea Glass & Reserve pr. Grants Federal 0 1,813 1,813 100.00% Corona virus aid relief grant Chgs for Sery - Gen Gov 0 7,031 7,031 100.00% Unrestricted Investment Earning 0 754 754 100.00% Total Building Fund 0 709,807 709,807 100.00% Fund 301- Capital Improvement Fund Unrestricted Investment Earning 3,484 275 (3,209) -92.11% Investment interest rate decrease Transfers In 127,100 0 (127,100) -100.00% Transfers differ from year to year Total Capital Improvement Fund 130,584 275 (130,309) -99.79% Fund 303 - Capital Projects Fund Other Financing Sources 0 6,890,000 6,890,000 100.00% Loan proceeds for Recreation Center received Unrestricted Investment Earning 0 2,420 2,420 100.00% Transfers In 0 0 0 0.00% Total Capital Projects Fund: 0 6,892,420 6,892,420 100.00% Fund 401- Water Fund Grants Federal Miscellaneous Revenues Fines & Forfeitures Other Financing Sources Unrestricted Investment Earning Charges for Services Total Water Fund: Fund 402 - Refuse & Recycling Unrestricted Investment Earning Charges for Services Total Refuse & Recycling: Fund 403 - Stormwater Utility Unrestricted Investment Earning Charges for Services Total Stormwater Utility: Fund 605 - Special Law Enforcement Forfeitures Grants - State Unrestricted Investment Earning Total Special Law Enforcement TOTAL REVENUES - ALL FUNDS ITOTAL REVENUE LESS TRANSFERS 0 3,542 3,542 100.00% Corona virus aid relief grant 38,359 54,710 16,352 42.63% Credit memo for a prior year expenses 459 0 (459) -100.00% 67,247 167,799 100,552 149.53% Increase in capital connect charges - Sea Glass 47,153 4,759 (42,394) -89.91% Investment interest rate decrease 3,842,144 3,074,813 (767,331) -19,97% Timing difference in Utility revenue recording 3,995,363 3,305,624 (689,739) -17.26% 684 281 (403)-58.92% Investment interest rate decrease 475,004 475,382 378 0.08% 475,688 475,663 (25) -0.01% 8,180 776 (7,404)-90.51% Investment interest rate decrease 420,886 443,152 22,266 5.29% 429,067 443,928 14,862 3.46% 0 91,516 91,516 100.00% DEA forfeiture 4,265 0 (4,265)-100.00% Corona virus aid relief grant 0 78 78 100.00% 4,265 91,594 87,329 2047.57% 15,966,513 23,968,985 8,002,472 50.12% 15,839,413 23,936,991 8,097,578 51.12% 01 of 485 enda Item #7. VILLAGE OF TEQUESTA EXPENDITURE REPORT - UNADJUSTED, UNAUDITED DESCRIPTION YTD BALANCE 5/31/2020 YTD BALANCE 5/31/2021 VARIANCE % VARIANCE NOTES EXPENDITURES Fund 001- GENERAL FUND Council 36,621 32,835 (3,786) -10.34% Lower council expenditures Manager 181,313 183,775 2,462 1.36% Human Resources 238,646 224,643 (14,003) -5.87% Village Clerk 225,317 224,448 (870) -0.39% ClearGov impl., BS&A cost reallocation, health ins & salary Finance 283,124 461,354 178,230 62.95% redistribution Legal 88,062 116,442 28,380 32.23% Differs from year to year Comprehensive Planning 82,971 91,663 8,692 10.48% Legal and other contractual services increase General Government 176,639 173,839 (2,800) -1.59% Insurance redistribution IT 134,647 432,877 298,230 221.49% Computer system maint & new IT project Police Department 2,123,241 2,021,148 (102,093) -4.81% Building & Zoning 468,124 0 (468,124) -100.00% Building department moved to Fund 101 Code Compliance 51,883 53,052 1,170 2.25% Legal exp differ based on the number of cases Fire Control 2,456,951 2,832,396 375,445 15.28% Salaries, ambulance purchase $299K, O/T disaster Public Works 870,876 808,260 (62,616) -7.19% Utility svcs, pathway maint, janitorial suppl. decrease Leisure Services 428,411 405,899 (22,511) -5.25% Gen maint, program exp, ins decrease Debt Service 324,626 340,464 15,839 4.88% Lease matured in FY 2020 Interfund Transfers 127,100 0 (127,100) -100.00% Differs from year to year, due to new projects Other Nonoperating 1,126 0 (1,126) -100.00% Total General Fund 8,299,677 8,403,095 103,418 1.25% Fund 101- BUILDING FUND Building & Zoning 0 442,573 442,573 100.00% Building Fund 101 created in Aug 2020 Interfund Transfers 0 10,103 10,103 100.00% Total Building Fund 0 452,676 452,676 100.00% Fund 301- Capital Improvement Fund Police radios 129,008 0 (129,008) -100.00% Projects differ from year to year Public Works 0 12,859 12,859 100.00% Projects differ from year to year Bridge Improvements 0 78,095 78,095 100.00% Projects differ from year to year Parks 0 3,600 3,600 0.00% Total Capital Improvement Fund: 129,008 94,554 (34,455) -26.71% Fund 303 - Capital Projects Fund Recreation Center 35,970 1,086,751 1,050,781 2921.27% Recreation Center project Total Capital Projects Fund: 35,970 1,086,751 1,050,781 100.00% Fund 401- Water Fund Water -Administration Water - Production Water -Distribution Water -Customer Service Renewal & Replacement Debt Service Interfund Transfers Other Nonoperating Total Water Fund: Fund 402 - Refuse & Recycling Refuse and Recycling Total Refuse & Recycling: Fund 403 - Stormwater Utility Storm Water Utilities Renewal & Replacement Total Stormwater Utility: Fund 605 - Special Law Enforcement Police Total Special Law Enforcement: 983,815 915,943 (67,873) -6.90% 1,235,255 1,079,302 (155,952) -12.63% Water system maint 627,519 509,230 (118,289) -18.85% New department moved out 0 152,933 152,933 100.00% New department created 1,377,577 609,291 (768,287) -55.77% Decrease in Utility projects 345,150 340,339 (4,810) -1.39% 0 21,891 21,891 100.00% 82,640 0 (82,640) -100.00% Legal settlement 4,651,956 3,628,929 (1,023,027) -21.99% 290,443 299,046 8,603 2.96% 290,443 299,046 8,603 2.96% 173,596 187,439 13,843 7.97% 39,465 197,572 158,107 400.63% Drainage maintenance and improvement projects 213,061 385,012 171,951 1,512 11,191 9,679 80.71% 640.15% Differs from year to year 1,512 11,191 9,679 640.15% TOTAL EXPENDITURES - ALL FUNDS 13,621,627 14,361,252 739,626 5.43% TOTAL EXP LESS TRANSFERS 13,494,527 14,329,258 834,732 6.19% 5 Aigenda Item #7. THE VILLAGE OFTEQUESTA REVENUE REPORT- UNADJUSTED, UNAUDITED 5/31/2021 FY 2021 FY 2021 66.67% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT % BDGT DESCRIPTION BUDGET BUDGET BUDGET 5/31/2021 VARIANCE VARIANCE USED NOTES Fund 001-GENERAL FUND General Property Taxes 7,690,000 7,690,ODD 5,126,667 7,756,295 2,629,628 51.29% 100.86 Historically, 91%receipted bythe end of Feb Sales &Use Taxes 1,784,150 1,784,150 1,189,433 916,233 (273,200) -22.97% 51.35 Ins premium tax $246Kdistribbythe year end Franchise fees - gross receipt 462,000 462,000 308,000 299,032 (8,968) -2.91% 64.73 Licenses & Permits 500 500 333 700 367 110.00% 140.00 Intragovernmental Revenue 1,031,250 1,031,250 687,500 687,531 31 0.00% 66.67 Grants Federal 0 20,916 13,944 160,109 146,165 1048.23% 765.49 corona virus aid reliefgrant Grants - State 100,000 100,000 0 13,605 13,605 100.00% 13.61 Police reimbursement grant Intergovernmental Revenue 768,350 768,350 512,233 523,079 10,846 2.12% 68.08 state rev is one/two month behind, higher than projec Chgs for Sery - Gen Gov 195,000 195,000 130,000 404,214 274,214 210.93% 207.29 Land development fees - sea Glass & Reserve project Chgs for Sery - Public Safety 1,216,850 1,218,650 812,433 864,431 51,997 6.40% 70.93 Fire plan review fees increase Charges for Services - Recr. 15,300 15,300 10,200 3,415 (6,785) -66.52% 22.32 canceled recreation programs due to coVID Fines & Forfeitures 18,500 18,500 12,333 16,797 4,464 36.19% 90.79 code enforcement fees differs Unrestricted Investment Earning 62,000 62,000 41,333 5,400 (35,933) -86.94% 8.71 Investment interest rate decrease Rents & Royalties 228,800 228,800 152,533 153,303 769 0.50% 67.00 Impact Fees 1,500 1,500 1,000 25,508 24,508 2450.81% 1,700.54 Differfrom yeartoyear, new projects Contributions & Donations 1,600 1,600 1,067 100 (967) -90.63% 6.25 No donations due to Tequesta Fest cancelation Miscellaneous Revenues 19,200 19,200 12,800 13,709 909 7.10% 71.40 Differfromyeartoyear Other Financing Sources 440,400 440,400 293,600 174,219 (119,381) -40.66% 39.56 capital lease recorded when debt incurred Transfers In 0 0 0 31,994 31,994 100.00% 0.00 Appropriate Fund Balance 298,661 0 0 Total General Fund 14,035,400 14,356,777 9,571,185 12,049,674 2,478,489 25.90% 83.93 Fund 101- BUILDING FUND Licenses & Permits 505,000 805,000 536,667 700,208 163,542 30.47% 86.98 Build department - sea Glass & Reserve project permits Grants Federal 0 0 0 1,813 1,813 100.00% 0.00 Corona virusaidreliefgrant Chgs for Sery - Gen Gov 0 0 0 7,031 7,031 100.00% 0.00 Unrestricted Investment Earning 0 0 0 754 754 100.00% 0.00 Other Financing Sources 19,800 19,800 13,200 0 (13,200) -100.00% 0.00 capital lease recorded when debt incurred Appropriate Fund Balance 146,950 0 0 0 Total Building Fund 671,750 824,800 549,867 709,807 159,940 29.09% 86.06 Fund 301- Capital Improvement Fund Unrestricted Investment Earn 5,200 5,200 3,467 275 (3,192) -92.07% 5.29 Investment interest rate decrease Transfers In 434,250 405,044 270,029 0 (270,029) -100.00% 0.00 Differfromyeartoyear Appropriate Fund Balance 97,650 97,650 0 0 Total Capital Improvement Fund: 537,100 507,894 338,596 275 (338,321) -99.92% 0.05 Fund 303 - Capital Projects Fund Unrestricted Investment Earning 0 0 0 2,420 2,420 100.00% 0.00 Other Financing Sources 0 6,936,563 4,624,375 6,890,000 2,265,625 48.99% 99.33 Loan proceeds for Recreation center received Transfers In 208,050 208,050 138,700 0 (138,700) -100.00% 0.00 Differfromyeartoyear Appropriate Fund Balance 0 0 0 0 Total Capital Projects Fund: 208,050 7,144,613 4,763,075 6,892,420 2,129,345 44.71% 0.00 Fund 401- Water Fund Grants Federal 0 0 0 3,542 3,542 100.00% 0.00 corona virus aid reliefgrant Charges for Services 6,326,250 6,326,250 4,217,500 3,074,813 (1,142,687) -27.09% 48.60 Timing difference in Utility revenue recording Unrestricted Investment Earn 64,800 64,800 43,200 4,759 (38,441) -88.98% 7.34 Investment interest rate decrease Miscellaneous Revenues 48,650 48,650 32,433 54,710 22,277 68.69% 112.46 Differfromyeartoyear Other Financing Sources 57,900 57,900 38,600 167,799 129,199 334.71% 289.81 capital connect charges new projects Appropriate Fund Balance 648,250 1,299,212 0 0 Total Capital Projects Fund: 7,145,850 7,796,812 5,197,875 3,305,624 (1,892,251) -36.40% 42.40 Fund 402 - Refuse & Recycling Charges for Services 484,000 484,000 322,667 475,382 152,716 47.33% 98.22 Historically, 91%receipted bythe end of Feb Unrestricted Investment Earn 1,100 1,100 733 281 (452) -61.69% 25.54 Investment interest rate decrease Appropriate Fund Balance 29,650 29,650 0 0 Total Refuse & Recycling: 514,750 514,750 343,167 475,663 132,497 -14.36% 92.41 Fund 403 - Stormwater Utility Charges for Services 457,700 457,700 305,133 443,152 138,019 45.23% 96.82 Historically, 91% receipted bythe end of Feb Unrestricted Investment Earn 12,150 12,150 8,100 776 (7,324) -90.42% 6.39 Investment interest rate decrease Appropriate Fund Balance 299,050 804,662 0 0 Total Stormwater Utility: 768,900 1,274,512 849,675 443,928 (405,746) -90.42% 34.83 Fund 605 - Special Law Enforcement Unrestricted Investment Earn 0 0 0 78 78 100.00% 0.00 Forfeitures 0 0 0 91,516 91,516 100.00% 0.00 DEA forfeiture Appropriate Fund Balance 0 30,441 0 0 0.00 Total Special Law Enforcement 0 30,441 20,294 91,594 71,300 0.00% 0.00 TOTAL REVENUES - ALL FUNDS 23,881,800 32,450,599 21,633,733 23,968,984 2,335,252 10.79% 73.86 Page 103 of 485 g TOTAL REV - LESS APPROPRIATION 22,372,950 29,783,940 19,855,960 23,968,984 4,113,024 20.71% 80.48 Aga THE VILLAGE OF TEQUESTA EXPENDITURE REPORT- UNADJUSTED, UNAUDITED DESCRIPTION FY 2021 ORIGINAL BUDGET FY 2021 AMENDED BUDGET 66.67% TARGET BUDGET YTD BALANCE 5/31/2021 DOLLAR VARIANCE PERCENT VARIANCE % BDGT USED Fund 001- General Fund Council 65,600 65,600 43,733 32,835 (10,898) -24.92% 50.05 Manager 293,650 293,650 195,767 183,775 (11,992) -6.13% 62.58 Human Resources 366,900 366,900 244,600 224,643 (19,957) -8.16% 61.23 Village Clerk 355,350 355,350 236,900 224,448 (12,452) -5.26% 63.16 Finance 691,7DD 691,700 461,133 461,354 220 0.05% 66.70 Legal 180,000 180,000 120,000 116,442 (3,558) -2.97% 64.69 Comprehensive Planning 164,000 164,000 109,333 91,663 (17,670) -16.16% 55.89 General Government 271,900 277,900 185,267 173,839 (11,428) -6.17% 62.55 IT 709,950 709,950 473,300 432,877 (40,423) -8.54% 60.97 Police Department 3,417,050 3,439,766 2,293,177 2,021,148 (272,029) -11.86% 58.76 Code Compliance 91,250 91,250 60,833 53,052 (7,781) -12.79% 58.14 Fire Control 4,043,550 4,342,211 2,894,807 2,832,396 (62,412) -2.16% 65.23 Public Works 1,489,000 1,489,000 992,667 808,260 (184,406) -18.58% 54.28 Leisure Services 705,100 705,100 470,067 405,899 (64,167) -13.65% 57.57 Debt Service 542,100 571,306 380,871 340,464 (40,406) -10.61% 59.59 Interfund Transfers 642,300 613,094 408,729 0 (408,729) -100.00% 0.00 Other Nonoperating 6,000 0 0 0 0 0.00% 0.00 Total General Fund 14,035,400 14,356,777 9,571,185 8,403,095 (1,168,090) -12.20% 58.53 Fund 101- BUILDING FUND Building & Zoning 671,750 716,750 477,833 442,573 (35,260) -7.38% 61.75 Interfund Transfers 0 0 0 10,103 10,103 100.00% 0.00 Other Nonoperating 0 108,050 72,033 0 (72,033) -100.00% 0.00 Total Building Fund 671,750 824,800 549,867 452,676 (97,191) -17.68% Fund 301- Capital Improvement Fund Public Works 413,000 158,000 105,333 12,859 (92,475) -87.79% 8.14 Parks 50,000 50,000 33,333 3,600 (29,733) -89.20% 7.20 Tequesta Drive Bridge 74,100 74,100 49,400 78,095 28,695 58.09% 105.39 Other Nonoperating 0 225,794 150,529 0 (150,529) -100.00% 0.00 Total Capital Improvement Fund: 537,100 507,894 338,596 94,554 (244,043) -72.07% 18.62 Fund 303 - Capital Projects Fund Public Works 0 255,000 Recreation Center 208,050 6,634,613 4,423,075 1,086,751 (3,336,325) -75.43% 16.38 Other Nonoperating 0 255,000 170,000 0 (170,000) -100.00% 0.00 Total Capital Projects Fund: 208,050 7,144,613 4,763,075 1,086,751 (3,676,325) -77.18% 15.21 Fund 401- Water Fund Water -Administration 1,426,250 1,584,766 1,056,511 915,943 (140,568) -13.30% 57.80 Water- Production 1,956,850 1,956,850 1,304,567 1,079,302 (225,264) -17.27% 55.16 Water -Distribution 773,500 773,500 515,667 509,230 (6,437) -1.25% 65.83 Water -Customer Service 221,150 246,150 164,100 152,933 (11,167) -6.81% 62.13 Renewal & Replacement 2,202,100 2,702,496 1,801,664 609,291 (1,192,373) -66.18% 22.55 Debt Service 541,000 533,050 355,367 340,339 (15,027) -4.23% 63.85 Interfund Transfers 0 0 0 21,891 21,891 0.00% 0.00 Other Nonoperating 25,000 0 0 0 0 0.00% 0.00 Total Capital Projects Fund: 7,145,850 7,796,812 5,197,875 3,628,929 (1,568,946) -30.18% 46.54 Fund 402 - Refuse & Recycling Refuse and Recycling 514,750 514,750 343,167 299,046 (44,121) -12.86% 58.10 Other Nonoperating 0 0 0 0 0 0.00% 0.00 Total Refuse & Recycling: 514,750 514,750 343,167 299,046 (44,121) -12.86% 58.10 Fund 403 - Stormwater Utility Storm Water Utilities 358,300 366,520 244,347 187,439 (56,907) -23.29% 51.14 Renewal & Replacement 410,600 907,992 605,328 197,572 (407,756) -67.36% 21.76 Other Nonoperating 0 0 0 0 0 0.00% 0.00 Total Stormwater Utility: 768,900 1,274,512 849,675 385,012 (464,663) -54.69% 30.21 Fund 605 - Special Law Enforcement Police 0 30,441 20,294 11,191 (9,103) -44.86% 100.00 Total Special Law Enforcement 0 30,441 20,294 11,191 (9,103) -44.86% 100.00 TOTAL EXPENDITURES - ALL FUNDS 23,881,800 32,450,599 21,633,733 14,361,252 (7,272,480) -33.62% 44.26 Notes: 1) Personal expenditures/expenses recorded as when paid not when accrued. Personnel paid 5/27/21 for the period ended 5/22/21. 9 days of personnel expenditures not reflected in May 2021. 2) Not all operating expenditures/expenses recorded for the services up to 5/31/2021. n, r 4) Capital lease at inception recorded when debt incurred $459K. 104 of 485