HomeMy WebLinkAboutDocumentation_Regular_Tab 12_10/10/2019 Agenda Item #12.
v'O{4f YY��df
Regular Council
STAFF MEMO
Meeting: Regular Council - Oct 10 2019
Staff Contact: Jeremy Allen, Village Manager Department: Manager
TITLE
Village Manager's Monthly Report
ATTACHMENTS:
August Manager Report
Page 270 of 414
Agenda Item #12.
(I)
.....1...11.1.111•1 CD+.
Sbm
0
C
0 CS
C(12
Page 271 of 414
Agenda Item #12.
or ?Ea
61,
7
Ir 7
-4147e01.110{ Memorandum
To: Jeremy Allen, Village Manager
Hugh Dunkley, Finance Director
From: Tatiana Racanati, Assistant Finance Director
Date: 9/17/19
Subject: August 2019 Finance Department Monthly Reports
Below are list of the Finance Department reports presented and statistical data for the month of August
2019.
Financial Reports— Unadjusted, Unaudited
• Balance Sheets, Summary (attached)
• Revenue & Expenditure Report, Detailed (attached)
• Revenue & Expenditure Report (prior year comparison), Summary, Detailed (attached)
• Revenue & Expenditure Report (target budget), Summary (attached)
• Cash and Investment Report (attached)
Statistical data—department benchmarks
• Finance
Additional Information
1) 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 are $6.8 million, which represents 100% of the budgeted amount.
Historically, 91% of ad valorem tax distribution receipted by the end of February.
3) Sales Taxes collected $396 thousand, which represent 85% of the budgeted amount and on target
for ten-month collection due to the distribution to be month behind the collection/reported period.
Page 272 of 414
Agenda Item #12.
4) Sales/use taxes (76%) and intergovernmental revenues (87%) fall below 92% budget target due
to the distribution to be month behind the collection/reported period. Local Discretionary infrastructure
surtax falls two moth behind.
5) Revenues (Budgetary comparison) recorded in the General fund are $12.1 million, which
represents 93% of budgeted mainly due to the property taxes collected at 100%. Overall revenues
within targeted ranges with the exception of few that are exceeded Village's expectations or were not
budgeted at all due to the unpredicted nature:
• General Government charges for services above budgeted $13,747 due to the fee
schedule adjustment;
• Code Enforcement fines $35,670 above budgeted;
• Insurance reimbursement$13,211 (not budgeted);
• Contributions and donations—recreation $6,400 above budgeted:
• Summer Camp$13,713 above budgeted;
• Investment earnings $43,237 above budgeted.
6) Overall Expenditures (Budgetary comparison) in the General Fund are $10.9 million, which
represents 85% of budgeted, which is below targeted amount, by $963 thousand. Senior staff has
been advised to be cautious of spending's and stay within the budgeted amounts as we are
approaching the fiscal year end.
7) Although all Expenditures/Expenses related to FY 2019 have not been recorded at this time, we
have noted that the following departments in the General Fund reporting actual expenses in excess
of budget(a full report is attached):
• Dep 110: Manager—Compensated Absences ($5,643 over)
• Dep 150: Planning —Other contractual services ($9,465 over)
• Dep 175: Police—Clothing and boot allowance at 112% budget used ($1,630 over)
• Dep 175: Police—VOT Pension Contributions ($15,968 over)
• Dep 175: Police—P/T salaries at 114% budget used
• Dep 175: Police—PIT salaries—communications at 110% budget used
• Dep 180: Building— Legal Services at 121% budget used
• Dep 180: Building —Travel and per diem at 116% budget used
• Dep 180: Building —Computer equipment at 146% budget used
• Dep 181: Code Compliance—Legal services at 112% budget used
• Dep 192: Fire—Marine unit operations at 130% budget used
• Dep 192: Fire—Overtime is at 94% budget used
• Dep 192: Fire—Vehicle repair and maintenance at 99% budget used
Note, personal expenditures/expenses recorded as when paid not when occurred. Personal paid on
8/22/19 is for the period ended 8/17/19. Fourteen days (one pay period) of personal
expenditures/expenses related to the month of August 2019 are not recorded at 8/31/19.
8) Revenues (Prior year comparison) all funds recorded this year are $713 thousand (3.99%) more
than prior year due to the increase in ad valorem taxes, higher investment earnings that is offset by
less fees collected due to not as many big construction projects this year.
Page 273 of 414
Agenda Item #12.
9) Expenditures (Prior year comparison) all funds has decreased by$417 thousand (2.45%)due to
budget cuts at the beginning of the fiscal year in the General fund, not any road/sidewalks projects
budgeted in FY 2019.
Statistical data-Finance
Payroll Direct Deposits: 233
Payroll Remittance Checks: 10
Payroll Remittance ETFs: 13
Purchase Requisitions/Orders Issued: 0
AP checks issued ACH: 57
AP checks issued Paper: 300
Void checks: 1
Manual Journal Entries: 55
Page 274 of 414
Agenda Item #12.
7
U,
CC Y
- a) ,--1O v)
a1 CU
a) E o a1 +-'
'al +o.+ N O C)
i a) p_ 01 LL C) O
O cu .1 C p_
O O. to N C E co C Ql
N = _C } ('EJ O O .Ts � 0
L}L a) LL 00 N Cm }, U N
V) C L U C 0 C
U) N 7 = L -° a) 0 a) C +, L LL
0I- 0 E L U L•O0 co CD -0 a) co V) O >4 CO C) C
Z > +' O m co
y v a a ,) 1- v a) U O v }, ° v
Ua) 2 -0 v C O OU O v -0 0 .c .i] coLLO '-
.0
y OCiD
O v a~ E ccoo a) 7 •C v CL CU s- CU c ro O >. a+ LO., fo 0. 7
>. o
u x c E E c ° 7 E co ami ° CU U 1-
.+7)
•_ ;° a) -0 L 0 a) 0 9 v s- 4- `- oa V U C)) a)
QJ E E Q E U m o c v c a) 3
7 7 d 'O E ` CU °° a1 ` a) 'p ° 3 to
ca O a1 .E v ` _0 a) = a) L c c C, U v
> v > c a) O a) y °� C a ° C) u CU
d a) U =° C -4 -° L 'U 0 U to _. a) U
QJ u CL1 a)
E C v) aJ ° f0 yam, L co 4- N
Q C "O a—
) L c a) ++ Y ut c t C to a Q
a co '17 aJ L a1 COL00 °- C - '° a) O O
IU.1 d Li. J C 0 U 0 0 IL W 2 co I- m (n Z Z Z
Cf Cf W o*' o* o * * o * * * * o 0 0 * * \ o ice° * \ \ o * * o 0 0 * * X
U 01 ID 01 d' d' N N m o 0l Vl m I� lD m V1 I. N o m Vl 01 m N O m I. O N N N
I- Z 00 e1 a1 N 'Cr VD N LO 0 N I. N 111 01 0 CO d' 01 0 a1 a1 01 N V1 0 d' 0 a1 M of d'
LL. < V) a1 m V1 O O M O ,-1 l0 00 00 a1 Oi d' 6 N O 00 O Mr.: 6 O M O O a1 l0 N
0Q a1 NCV N 0 ' LID N01 ,-1I� l0 t0 O 01 0 a1 01
W >
O
J_
5 V1Ol N 00 01 CO N O dN M 00 CO • O V1 CO0O a 00 O d' N CO 01 t0 O d• d' R l0 O O O0
Q = O1 U a-I 0 01 0 a1 M 'Cr V1 Co IO UI M O^ d' 00 'Cr 01 'Cr L00M03 COC� N N CO CO 01 m in et U1 0Om d' N l0 N M Cr) a-I
W 0 < N d• N N O 'N-1 1 Lri I N 000 S M 0 00 d' N N Vf Ct d• N N V1 M a•I m
O N oc M a1 a•-I a1 Iv d' N 00 . V) .N.. a.. a. .... a-1
1f LL a1 Q v .... I i-I
00I- >
p
O 0
LLI O LU M 00 01 N V1 0 01 V) 0 M Cr) UI 0 01 N 1.1) Cr 0 0 01 a-1 .-I Cr 0 0 M 01 a1 U1 N N 01
W O= Z U O1CrV
CoC0 Co00 CO LO 1 a1N N 00 01 N 0 0 01 a1 V1 01 I)1 m 01 Na•-1 0 01 a1 LID d'0 0
UW O Z a1 d• CO M 0 00 V1111 N. CO N d' a1 CO a1 N Cr N 01 0 0 10 IN In N V1 1.0 l0 0 0 0
er
CL Z < O co' ,–i" I: 0 V
0f Vi 0 N 1 DD ,-ih.' m n P lD O N 01 DDO d" 1-Z -I ID
0 Co a1 Co a1 d' N ^ l0 a1 M 01 l0 p CO LO ^ IN M Vf W 01 Co CI' M l0 1.0 01
O O Q \ l0 ‘–i' a–I l0 Co 0Oa-I O d' 4.
Z I Cp
W W
CL 0-
X
LU
0 U W dN 00 N• N 0 Cr N Io V1 MN d' a1 014- 0 .01 N 01 0 d' 01 M M LSD 01 V1 Co N M m 0
Co00 N 01 Co (.0 M CO a1 01 0 l0 0 01 M a1 0 l0 0 0 V1 N IN 'C d' IN N N M
ZZ Z p 1 d
M 0 ' 0 0 a1 0 c-1 00 V1 IN M d• NN dN 0 ' a1 m N N V1 LID 00 N N CO m M 01
N N l01)')
N lD lD V1 01 V1 M VM1 I: a-1 l0 O to' V• O 0
1 1 .0 600 I: c V1 pOD 00l
LuQ N N ,1 N 01 N 01 U1 l0 0 Co IN V) M d' N ti N 00 1.0 N 0 l0 l0 t0 N V
D co m d' M d' N V1 ,-1 pN- ,-I a1 I� Co to Co I� V1 N Cr V 1 N) e0 00
W p CO l0 a1 a1 m ,1a-1^ a-1� a^-1 N
> O
111
CC
N
V1 W
C WD
H H
Z
>4L.
Io aZ
Z .c7) C C aJ C U WCe 7 ++ W d
aJ a) 14 0 C +' h H LL
0 �) cu oOl CO oC H '� ac) In Z w
O_ 0C C7 0C C .0 C v1 E 7 to LU C E ILIcu Q OZS
() V a� v �, Q CLI v 0 +I+ U VI Vl _U H H a1 °c° U H
V1 a) MO i C 0 c 41 OC O_ L '> j 170 W W E - _ LO W
W X v ar +J (o 0 E L c c Z > > H a) U, }, 4- G H
O0 a a1 = C CO p 'p O I 1/1 n d +�'' •i7 C VI W W cc U O W W .WJ W
val "
W O_ 0 a) a) N a) cc C 11 I/) LL a)cu a) 0 06 N 0 U c N 0 W W I- LL E O a, X X W
0 to 0 > O > C2S co . O LL 42 CD , ,n . iLL a1 u, OC OC p N - LL LL 0 -J W W LL
Z L L aF VI O� U of a) ++ aF a) J J Z L a, co L N 10 J J
W a) ,n C La N N +U, U C to U, co aL+ C C `0 N y of Q Q W a) +, +, a) N E 'U QQ< Q 0 494
> a) (o +�., 00 �L+ c ccof cp 00 C Q c a) (o c0 L L fo a C d d �"]tFLL l�
cc U 0 LL 0 C d' L 0 0 LL U _I 0 U D 0 I- U 0 0 x (' U U > (/}7
Agenda Item #12.
a)
.2
a)
uv a Eac
vtao a
3 3o > * Ca) O O
o atN HO ,9`-la) riO raV' Ql ba 0 C , N a a)N O
O C NON O o G) p a) ?, 0a
—, T 0. C > m
D -a 7
u- v p E aCi mm a) C
w a) m L c 'O''''' v 2 E o c) v a" 0 C 0
I- a) v E m ° v er a) -0 )a a) w - T T a s v
_ o v a err >
u u t O O io
Z O `1 U 'C T C9 C N H T C O 0 f' 0'O 0
u O ). O t O v to O n1 N `ci,m 0r. '0
0 C N w E fa a) 7 E U ry C y to >, >. to 0 a) m
al w a) y Tba
a0+ . C . T .-, O T w a) r0+ O O a0+ a L in
C
c v E E E o v E E .� u 01 g
• E w Q O a) u m m O
S
E E m v 0) ° a a) a) m u u v
E C N L' U a u O a1 .‘,2
T _ `_ T 01 C C O
> a E c o v c v d ,n E 13 a E C v u
T 0. in O" 0) U "O C ) -0 0 "O C N 2 E UO . V
t N 7 > E C ,n a) C N N w a) a) r- i al
CL C m -O N j C al O Y C r 0 a) C C d 41 �' �., T
O v Q C a ,n 20 'O al G) fa CC v RI c`0 Q) a to u
a LE = u 0 U D a u0. 0 m ..,, o r H 0 E U 3 cc
l)w O1 tD 01 V1 V N N N O 01 u) M N. aD m u1 Ni O N 0 0 CO 0 0 •I 0 .--I d' CO u1
Z 00 N N LC) V LD N O 0 N N N an CO O CO O CO M O O N 0 0 u1 et CO V .-I p
Q LA .-i .-i f!1 ul O O .4 p N i0 W Cp .--I Ol 4 N lD N O O m O O V Ni CO 00 N M
02 .-1 N N u1 O lD N .-1 I� u1 M O O 01 O O W N N
Q .ii m d' r-: .-I .-i .-11 rl
>
Q
I-Ln
_
N .D 01 00 N LID CO CO V0 u1 CO e"1 u1 N u1 OD O V O O 00 N .- O1 N
1 0,
D U rn 0�1 u1 M N an M e-I M Ot N M 0 u1 0 M u1 M .--I ILO 0 M 0 0 N N 0 0 0
d Z ei 0 O N N m d' CO CO lD M N V CO. d' LD LD d' •"1 .-i 01 0 0 u1 O .-i u1 O N
LU Q W CO N [F 01 01 v T .cPN lD 00 cM N M •"'I O 00 O O
ei ci Ol' 01 n
F- I, a? N N O v n 00 lD d' e-I N a M N O In 01 .-i I�
w Q M v "" ei N 111 1)') N N — M
Q >
Q W
W
D -J NN W M Co O CO In 0 al M O M M u1 0 01 N ul CO N 01lD 0 lDO O Wu1 M MN M
V O1 Co CO Co r` 4 In r1 N 00 01 N 0 0 01 N In 01 co l0 lO CO et M M ei cc
> •-I Z e-I [t Co M M W u1 u1 M Co N V e-1 0o s-I N tO u1 N .-i .-I Li') Ol LD r\ 01
♦- _ g O 0 00 N co' N W u1 N O1 N W N I� N N N N
ei ei lD N a N 00
LL 0-5. N 0 I- N N I� M Cr) N 0 CO N r'1 (� N N M .-I N O1 lD
Q H O Q .\-I 00 ei V' n ID ei 0 lD ei 0 ei CO M
LU (9 m M aD' ei ei N u1 ul
0 Q Z rn W `-I
Fo T p
J aL Z
5 0 w
LU 0w Co N N Cr N N lO an ry V ,-10 a 0 d' Lr) V O 0 0 0 0 00 M etan 00
U 00 d' 00 M s-I N cn Co Lr1 M 00 M ci O lD 0 01 0 lD Ol 0 O 0 0 0 N u1 N 0 In
Lu M Z •1 M Ot V lD 0 ri 0 ei CO u1 N co N O N 0 Ot N ei eI 0 0 O cr N. N al d'
n wg NO N' 0' elV u1 Ol u1 00 Iii. ni N e-r tD N (-4.O01 r O O O O u1 .4u1 Cri ui •"I
ZN N e-1 N 01 N Ol e-I tD O CO r` CO p V V 0 0 CO LO N N 01
L),1 Q ei V M et N Ln .-1 0 N CO u1 u1 N N ei 01 s-I
> Q l0 L4ei epi ti' Lr
CC CO
O
'CIC
C
7
u-
0.0
CD =+a 5C CSi 00
c
O. a) a) >. i E LL u. C a)
Z 0 0 0
U C C ,� w C U Y ut > N C Y C in )- H V C
Q Z N i > > O a) ra a) C N 0 Q) u 3 a) C O V N
v N a>i o a>i �+ z v a = E - Ii -o = a) w >
a u. x v z 0 cc aci u C N E = E C > 2 u. C c E = ,,, C
V Q ~ 0 OL To v ro of > 0 = _u al Ln 'O > p °. 'i u- > '. 0 u 0� m
'n OC y °° c C7 c a z a > no C aTO W CO > oa c
O z N N , a) a) Y u. CO , *_' v C C U- 2W ao 0 u. E ate+ N C ,...b0
v C o a)
W o. 1— a) E E m 3 a) ` W .) a) err ti a a o_ m u 7
l7 ° N w v E o aoi y v t v a a ° cco u y C u c To v a) c .LL. cc e
w1 O v v N v C L1 v1 o v i.. otS ,n o ti c d . C ` = L = ' C U C ° •01., ' v
W e{ — N > > 10 , w 7 N , Ut •,- LL C N f0 a. m O. c-I (a LL U. 0 N >
0 O co 0 t 0 O O H O of a+ -0 N N a) a+ N O w la O w io O - a+ a) O O
Z o v oa m v m c� M w c v eel an 0 Cr v m 3 a m
W 'fl C a) C cu 00 1i C vai C CO O O. C N 10 1a N .c Ti 'C a C C 'D H v a) fa N
� LL � � LL = � � � £ v° (-) c� � � 0 O C � ~ � LL ~ o LL 2 n 27 f414
W
Agenda Item #12.
z
Iv nm
to
f0 0
O
a) u ,
N C
2 a, O
U u -0
Ul C C
a co a)
u0 °=
C t
m c >.
ry J
O Ua
+
c U •
3 N U
O "0 N
u m O
ry N u
c t0 OJ
OJ
E VI
N N 0
W N *.
> c ei
O
0
01 4 N in al
0▪1 O• N 01 1� .-i .-I Cr)
U3 O O N V 1: O M
ey O .--1 e1
e-1
1.0 CO N 110 .-i 00 in [h In
T N V t0 O l0 N 00 N
ci O in In N N' N
'-- e-I if1 l0 N .-i N
•1 CO m 01 00 r. .-1 ei
N 01 N LII LII
N 0011 4 O N M O O
ei N V1 •1 00 Ol 1: f\
oo OD 4 4 N 0 V in In
00 Co.
ei ei
L11 L!1 N 0 l0 lD
d" ul V1 LO 00 V 0 0
eti N 00 CO N l0 M N
N crj 1p O cr1 crl
V V m co '.o 000
00 1:
ei eI
0o m
C_ C ccW
Cate. C 0 N
w — W Z Z
7. ,_, 7
C 00 C 2
., C L y 4. —1 1—
E vi u> « E .1 a. Q y�1
VI N Ce 4-, U ' W
V V_
�al E CC E > Z « W w
- cu ... N
N .c. 0 N Z
v O N N a) p UJ W
U 4- 3 . U � E > W
w !r1 0'• C
C h O
v1 `0 Ce cr co H J J
Zf N f0 13 11 c0 f0 Q Q
7 u F LL D o ~ o o Page 277 of 414
Agenda Item #12.
ii
s oN r ei
o c m a) m
CL t Y N O a u
Y O -0 c a) a 7
0
a) , m v > a
V1 a U in H C 0 t0
E c N U to U -a ai+ Ed)
H v O 0 ° '� v CT CT v v v a 'a c
o > `m W 72
Z C d m a, N N O 0 > L 30 O u C
} Y ` w �-I
41 N ` C la 8 2 'j LL LL N U O t0 C W C C O
.a U3 N `1 L w L C C a' y O N y
N a) ` to 'O > a) a al a) }
3 3 a O U O N W 01 E w C C A a) 'I'' LL C
etc 0. c '', c a m y m m O Y v 3 E o c
° O C (0 L L 4- C U w > aJ t+ al
v N c>'•
-0 a' N a a) Li L a) L a) o Y N O c C
> a > N N a > > _ o .. = a E E ,�
to a) C O L O N D Y a a .O C a v °' t0 �+ E
a(O+ o to Y a) - _
L H ..�- `1 Cr C H U C C to -0
`m m ,„ Io a) m y m 'a a ,v a' 3 v c 0 3 `) °+' m
y v ° v y u u c c v 3 0 'N W a o 5
°° v1 -m0 al Ea 'D •D O O L -0 N C C IN '1`
a II = O ti U K U in Z Z F- u in Z a a cc O j 8
w * * * * * * * * * * * o * * * * * i * * * o o ice' * i * i * * a a o
o ei rn N al 01 00 0 ei in m m O 01 a-i N. 01 O ,-i m N N 0 0 0 N 0 CO N m cn N N en
Z .-i m O to tO 1/1 N V O 1� en 0 '-I Ol M N o co N in u1 O 0 UD 01 0 V d. VI .7 O O c I
a Q 1D to Oi 00 1'n W .--1 O a M .-i p O L11 a O O cn ri Lc; tri O O in O
2 e1 N N ci 0 ,-I .-I N O 1-- 01 0 O O dm' n.1 N em-I O O Csl
O
r -1 N ci c-I e I
H
N
W
0 LU 7 01 u1 O Dt rn 01 O e-I CO t0 e-I m .7 N ei O ei 01t0 LID0 0 N CO to t !1 V 0 t0 t .7 V e-/
O U CO 01 ci LO 11'1 Na N ID N 0 ‘13ei Cn 01 u1 N 0 0 i!1 0 0 O O e-I In u-) a'uLO N t0 r\ N N
w Z N ON M N °
1 01 cF 00 1 .--I .7 0 0 N N to e-1 en coa al m in in 00 tO c0 rn 01 7 N N en
F Q N e•1 tD O N' c 01 1: tD Cp N Ol tD a O 00 O 'xi ei t0' tD 00 W O u1' .-i' M e-I d' d� tD
w 2 ei N u1 r-I 7 en N 0 CO O O rt s' —1n - 7 7' .7 t0 v t0 CO N Na en
O Q e-I N ` N 00 to V u1
w >
Q (.0..?
3 cn
LU) J `i0 W t0 t0 N Cn 0 N tD V N CO 01 .-1 co N N 00 0 to t- 0 0 0 o O co W N ci rn en al m O1
O > N U Ol 01 ci t0 V V N c0 N eV 0 t0 ci Ol In 01 CO M O1 N N 0 0 N e I N e I fn CO 01 .-1 e-I V
• \ Z ' N cn ei co co t0 O o N N O O co N ei M 1V t0 1� N to to N 01 O r` rn O N u1 to 0
• F `i O N N u1 ei O O N O1 m M Q1 Ol 1- ,--i O ci (.4 e01 01 cO W t0 0,i N O1 N0 N'cO O r`
M J N V )--1V coNV en N N tO N O .7 CO N CO 0 en 'l c-I V .7 N cel 0 tN 0 in O O ei
W CC c\O Q ci N M cn M ei .--1 N e-I O If) r1 0 1O Ct 01 .-i In c0 cO V 00 d• V N
O O0 0O In r -i'n rn . d e• a [t
Lu W (7 0 W ci
C7 H Z O
o zJ a
W
a 0 W 0 UD e I N N V t11 a t0 N N 0 rn O Ol m O t0 en LID LID 0 0 01 t0 (11 t0 N O) 01 Ln t11 co
W U co co N to co O 01 i V UD r 0 O N tn n N u1 0 en IN 0 N. N t0 al 0 N .4 N
W O z .1 In en N M O c0 4 00 N t0 t0 Ol 00 01 0 ei U1 V1 LID LAD m In CO t0 .-i 00 N N t0
a' O u In W ei W N V• .-i .-i u1 .-i n u1 O M O 0 W t0 t0 u7 01 O to rn n N O6 O
0 w N V N 0, N d• In 00 ID N en 7 CO CO 0 n .7 CO 10 t0 CO CO r` NI CO N N 0 0 CO
Qa Q[O i.-1N N N M .--I ei N ei CO Inc-I N Na 7 r\ r` u1 in O In N e 'ch N d• 7 e I
Z \ N n ‘-i. , .-i .-i 'd•
a O
X
W
9
c
3
LL
.. -0
E .i LL c i,
Z D m > C m C c > a`+
O Z D
•E +J o d y 7 c 0) d an c
a LL 10 al 0 , a O) `O to C c,,.,lo c C E °C° aC - Y W .
2J v a E c bO O) v > a a` 'u ° O u m os .) > 3
U Q ` Q) Cu y tL 'O O LL 'Y t6
N IX m c v c i . m c a D u n a p a u w
W W 7 0 N E C U c a) 7 , a �,, al 0 a) •c _a el N c H a) OC E
0 to Z O Y I^ > O to al 2 0 U- to E U i' - OG al a 0 L
W W v' Co f0 N a O U_ F O co c a E O2 U O U. 10 "O a� .O,. Y
6' 17 1r v L (7 a) t121 E +-, •' to Z "o o L U ° m v O m .. -00- ' °� '� 0 .. 0c C 0 in 10
D v U a) v — O oa o c > v c z W '= +' `—' Q . 9 m ar Z a..' f0 7
H ei •V m C a) U ci co O U v to i C .-I U a m N a ei 3 to A N al ..- (n
0 OC 'O 10 m C — D_ a) u ••77
– a) o . ' ,, a`l 01 0 . 10 0 L m 0 v a`) v a) ... a`l o '^ 1v o E
Z o 7 C E r0 m a E C •- — 'o w ,,n a) t (D m To O en 0 U a m 1`a 1aa c -0 r 3 of .2 = rt o
W -0 O 7 C al O a) 0 7 o 7 v N a+ y, 'O .O y -a N a) ''' .II y 8 -a ..-.
n. c U x > LL J U C7 � D_ m U ii D_ J n E O v, C0- .. C rc .'0 c 3 3 i c 3 0 0 Plage 0 of "f14
W U. I- U. 1- LL - LL I-. LL I-' LL
Agenda Item #12.
.--1 1
0
N
›-
L)-
.E LLC
a)
a) W
_ 00
Tx -ID
O N
U
al G
v 3
3 a
E CO
a) s
E'
O =
O. O.
01
J -.1
mol mm V) 'a
00 O .-i .-1 10 N
1.0d' Ol Ol
00N l00 l00 O 0 O
O l0 N N M N M
Cr; l0' l!1 1!1 1: n N
N N N N .-1 CT .-i
N .-i l/1 1/1 N N
l!1 LD l0 W 0 O
.-i CO' .-i .-i
N m .-1 r1 .--1 ,{
c-1 M l0 l0
l0 l0
.--1 .--1
0N St N N N N
LII N CO 00 M N
d' LA" Ol Ol 00 00
00 UD ID lD l0 N
In 111 1 .-1 N O
I N
..
c
ro
E Z
. a)LL
d
c
▪ •° E -' r''
CU �, W ` Q LL
E = 3 ° In z
W
c0• D J C D'
W
v• a+ m 3 —
it; •al J 0
in
06 3 d Z W
V) 07 W J
in y a) X X
`• o
u W W
c N) lD •- N J J
CU°� F 7 o 0 Page 279 of 414
t1'e�r` 7a9 lt2� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/7
� Period Ending 08/31/2019
DB: Tequesta
Fund 001 GENERAL FUND
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 57,737.83
Investments 4,731,854.96
Accounts Receivable 218,529.30
Due from Other Funds 0.00
Inventories 35,256.99
Prepaids 46,127.30
Other Assets - Current 0.00
Other Fixed Assets 0.00
Total Assets 5,089,506.38
*** Liabilities ***
Accounts Payable (120,754.46)
Accrued liabilities (2,101.47)
Retainage Payable 0.00
Due to Other Funds 0.00
Due to Other Governments 4,216.29
Deferred Revenue 0.00
Other Current Liabilities 0.00
Customer Deposits 0.00
Noncurrent liabilities 0.00
Def Inflows of Resources 180,520.19
Total Liabilities 61,880.55
*** 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 - Nonspendable 224,994.55
Fund Balance - Restricted 1,506,888.00
Fund Balance - Committed 500,000.00
Fund Balance - Assigned 0.00
Fund Balance - Unassigned 1,650,228.03
Total Fund Balance 3,882,110.58
Beginning Fund Balance 3,882,110.58
Net of Revenues VS Expenditures 1,145,515.25
Ending Fund Balance 5,027,625.83
Total Liabilities And Fund Balance 5,089,506.38
Page 280 of 414
ifdi #1 2. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/7
ate` 1 II' fF' Period Ending 08/31/2019
DB: Tequesta
Fund 301 Capital Improvement Fund
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 11,970.39
Investments 0.00
Accounts Receivable 0.00
Due from Other Funds 0.00
Prepaids 0.00
Total Assets 11,970.39
*** 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 - Assigned 0.00
Fund Balance - Unassigned 30,524.77
Total Fund Balance 30,524.77
Beginning Fund Balance 30,524.77
Net of Revenues VS Expenditures (18,554.38)
Ending Fund Balance 11,970.39
Total Liabilities And Fund Balance 11,970.39
Page 281 of 414
Q�/ l�l�l� 2� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/7
s��` LracanatiPeriod Ending 08/31/2019
DB: Tequesta
Fund 303 Capital Projects Fund
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 169,312.79
Investments 0.00
Accounts Receivable 0.00
Due from Other Funds 0.00
Prepaids 0.00
Improvements Other Than Bldgs. 0.00
Total Assets 169,312.79
*** Liabilities ***
Accounts Payable 13,500.00
Accrued liabilities 0.00
Retainage Payable 0.00
Due to Other Funds 0.00
Total Liabilities 13,500.00
*** Fund Balance ***
F/B - Res for Encumbrance 0.00
F/B - Unreserved/Undesignated 0.00
Fund Balance - Nonspendable 0.00
Fund Balance - Assigned 0.00
Fund Balance - Unassigned 204,312.79
Total Fund Balance 204,312.79
Beginning Fund Balance 204,312.79
Net of Revenues VS Expenditures (48,500.00)
Ending Fund Balance 155,812.79
Total Liabilities And Fund Balance 169,312.79
Page 282 of 414
Q@{ 7a9Ifl�11.i#12. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/7
S _: Lracanati 1 II' fh1 Period Ending 08/31/2019
DB: Tequesta
Fund 401 Water Fund
GL Number Description Balance
*** Assets ***
Current Assets 0.00
Cash and Cash Equivalents 827,736.25
Investments 5,286,164.06
Accounts Receivable 633,130.04
Special Assess -Current 0.00
Special Assess - noncurrent 0.00
Due from Other Funds 0.00
Inventories 211,922.12
Prepaids 19,454.25
Other Assets - Current 0.00
Land 83,335.00
Other Assets - Non Current 83,335.00
INFRASTRUCTURE 14,612,902.33
Buildings 272,115.17
Improvements Other Than Bldgs. 31,708.80
Machinery & Equipment 230,717.18
Construction in Progress 2,517.38
Intangible Assets 80,635.19
Other Fixed Assets 0.00
Deferred Outflows 553,023.53
FIXED ASSETS 0.00
Total Assets 22,845,361.30
*** Liabilities ***
Accounts Payable 16,796.19
Accrued liabilities 17.15
Retainage Payable 0.00
Due to Other Funds 0.00
Due to Other Governments 335.52
Deferred Revenue 0.00
Current Portion of Debt 387,702.79
Other Current Liabilities 0.00
Customer Deposits 34,850.33
Noncurrent liabilities 3,507,580.03
Other Long Term Liabilities 400,755.63
Def Inflows of Resources 231,539.00
Total Liabilities 4,579,576.64
*** 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 5,464,397.11
Total Fund Balance 17,549,160.98
Beginning Fund Balance 17,549,160.98
Net of Revenues VS Expenditures 716,623.68
Fund Balance Adjustments 0.00
Ending Fund Balance 18,265,784.66
Total Liabilities And Fund Balance 22,845,361.30
Page 283 of 414
Q$ 1�9' 8�3�Al2BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/7
S uraca CI11 fF1L Period Ending 08/31/2019
DB: Tequesta
Fund 402 Refuse & Recycling
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 132,560.17
Investments 69,961.54
Accounts Receivable 490.74
Other Assets - Current 0.00
Total Assets 203,012.45
*** 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,098.59
Total Fund Balance 118,098.59
Beginning Fund Balance 118,098.59
Net of Revenues VS Expenditures 84,913.86
Ending Fund Balance 203,012.45
Total Liabilities And Fund Balance 203,012.45
Page 284 of 414
{ KAli' � `1 2. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/7
�`�Lr Period Ending 08/31/2019
DB: Tequesta
Fund 403 Stormwater Utility
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 148,472.12
Investments 909,384.31
Accounts Receivable 513.20
Due from Other Funds 0.00
Inventories 632.35
Prepaids 0.00
Other Assets - Current 0.00
Other Assets - Non Current 0.00
INFRASTRUCTURE 1,115,691.07
Buildings 0.00
Improvements Other Than Bldgs. 0.00
Machinery & Equipment 15,508.84
Construction in Progress 0.00
Deferred Outflows 21,769.00
Total Assets 2,211,970.89
*** Liabilities ***
Accounts Payable (1,602.98)
Accrued liabilities 0.00
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 12,034.41
Def Inflows of Resources 11,223.00
Total Liabilities 21,654.43
*** 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 843,213.86
Total Fund Balance 2,079,600.92
Beginning Fund Balance 2,079,600.92
Net of Revenues VS Expenditures 110,715.54
Fund Balance Adjustments 0.00
Ending Fund Balance 2,190,316.46
Total Liabilities And Fund Balance 2,211,970.89
Page 285 of 414
4 ti 2. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/7
�M Period Ending 08/31/2019
DB: Tequesta
Fund 605 Special Law Enforcement
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents 93,978.28
Investments 0.00
Accounts Receivable 0.00
Inventories 0.00
Total Assets 93,978.28
*** Liabilities ***
Accounts Payable 252.00
Due to Other Funds 0.00
Total Liabilities 252.00
*** Fund Balance ***
Fund Balance - Nonspendable 0.00
Fund Balance - Assigned 0.00
Fund Balance - Unassigned 108,391.34
Total Fund Balance 108,391.34
Beginning Fund Balance 108,391.34
Net of Revenues VS Expenditures (14,665.06)
Ending Fund Balance 93,726.28
Total Liabilities And Fund Balance 93,978.28
Page 286 of 414
Agenda Item #12.
VILLAGE OF TEQUESTA
ALL FUNDS
8/31/2019
Current Cash&Investments Unadjusted
SBA Prime
Cash Investments Total
General Fund#001 57,738 4,731,855 $ 4,789,593
Capital Improvement Fund#301 11,970 0 11,970
Capital Projects Fund#303 169,313 0 169,313
Water Utility#401 827,736 5,286,164 6,113,900
Refuse&Recycling#402 132,560 69,962 202,522
Stormwater#403 148,472 909,384 1,057,856
Special Law Enforcement#605 93,978 0 93,978
Total Cash and Investments $ 1,441,768 $ 10,997,365 $ 12,439,133
Page 287 of 414
Agenda Item #12.
Department Reports (August 2019)
Village Clerk's Office 19-Aug YTD 2018
Agendas Compiled and Distributed 3 34 39 Summer Camp Registration 45 45
Council/Comm Meeting Hours 7.5 46 62.75
Orders Processed 3 20 48 Ages 5-7 13 13
Resolutions Processed 4 29 35 Ages 7-12 32 32
Ordinances Processed 1 11 11 Ages New Familie 6 6
Agreements Processed 3 31 65 Revenue $46,687.50
Legal Advertisements Recreation Programs
Legal Notices 4 31 38 Tai Chi Classes 14 14
Bids/RFPs 0 1 3 Yoga Classes 20 20
Public Records Processed 16 152 226 Tennis Classes 13 13
Lien Request Processed 35 338 539 Fencing Classes 8 8
Imaged/scanned pages 750 8134 10917 Gymnastics Classes 0 56
Open Gym Classes 0 3
Public Information Officer Ninja Scouts Classes 0 4
Facebook Posts 31 264 426 Homeschool Classes 0 3
Facebook Message Resposes 2 143 410 Mah Jongg Program 0 0
Facebook Followers 62 3370 unk Revenue
Page Views 1193 Unk unk Facility Rentals
Post Engagement 4683 19010 unk Constitution Park 3 0
Page Reach 26184 unk unk Recreation Centel 1 2
Press Releases 1 5 3 Tequesta Park
CodeRed Messages Launched 6 21 N/A Groups 3 3
Smoke Signals 1 3 4 Reservations 1
Clerk/PIO Events&Meetings: Tequesta Business Assoc/Hobe Sound
Chbr meeting and kick off event planning, Hurricane Dorian Prep and
public information.and Shred-It event Revenue
Website: Clerk's Offce serves as the webmaster and updates/amends
most pages/handles user administration/alerts,etc. Special Events
Tequesta Fest:Saturday, Nov.30th, 12:00pm-5:00pm
Food Trucks: Begins Oct.4th,5:00pm-9:00pm
Line Maintenance 9 0 Station Maintenance 273 1,059 502
Equipment Maintenance 2 10 Daily Training 664 735 520.5
Work Orders(Non Meter) 7 125 Company Training 122 107.03 67.78
Employee Call Back 11 15 Multi Company Training 0 0 0
Valves Exercised 10 0 Officer Development Training 114 105.5 107.8
Service Repairs 1 0 Driver&Operator Training 51 108.75 35
Meter Set/Changed Out 13 10 Hazmat Training 7.5 51 30.5
Meter Reader Related Work Orders 161 131 Other Training 12 6 10
Locates Performed 231 220 FF Admin Duties 811 919 535
Staff Vacancies(Days) 6.5 25.5 Unit Repose Data
Fire 10 10 14
Customer Service 19-Jul 19-Aug YTD EMS 77 68 56
New Accounts 46 32 SPOP's 2 1 5
Closed Accounts 51 29 Other 1 4 5
Work Orders Completed 230 261 Mutal Aid Given-PBCFR/r 4 6 9
Total Accounts Billed 5102 5083 Mutual Aid Received-PBC 5 15 6
Aging Report Inspection Data
30 Days $23,012.65 $21,147.63 New Construction 14 15 7
60 Days $11,514.90 $12,961.59 Aunnual Fire 21 34 48
Page 288 of 414
Agenda Item #12.
90 Days $12,974.55 $13,715.95 New Buisness/New Occupa 1 2 2
180 Days $22,275.32 $23,780.88 Re-Inspections 9 9 13
Past Due Shutoff List(Slow Pay) 84 79 Food Truck/Tents 0 0 22
Amount $17,522.63 $17,828.82 Public Relations Events Data
Bill Adjustment Report 11 Accounts 18 Accounts Community Functions 2 2 68
Amount Billed $527,122.54 $546,958.87 Station Tours 0 0 8
Water Usage 69,789 72,804 Walk-Ins 0 0 1
IT 19-Aug'rior Month YTD
Helpdesk Tickets 144 205 1208
Projects
Council Chambers
Telestaff
Exchange 2016
FDLE Technical Audit
Water Distribution 19-Jul 19-Aug YTD POWNstartinkent 19-Jul 19-Aug YTD
Water Production Total 85.618 71.66 646.926 Communication Division
Maximum Day 3.134 2.595 3.087 Officer Initiated Calls 745 656 5566
Minimum Day 2.335 2.037 2.214 Calls for Service 335 377 3280
Average Daily 2.762 2.312 2.661 Fire Rescue 42 25 488
Backwash Water 1.827 1.808 14.047 Patrol Division
Monthly Total Gallons Flushed 2.253 2.742 18.941 Reports Filed 32 20 229
Monthly Rainfall 4.29 0.43 44.69 Arrest 8 6 55
Projects Crashes Investivated 10 6 117
High Service Pumps 6&7 Priming Systems Repaired,Lightning Strike damaged F. Traffic Stops 279 131 2180
Instrumentation shutting down Plant for several hours until repairs were complel Citations 63 23 426
PBCHD Survey completed,DEP Industrial Inspection completed, Hydrogen Perox Warnings 79 19 549
Human Resources 19-Jul 19-Aug YTD Administration
Open Positions 7 3 30 Open Positions 1 0 3
Applications Rec'd 105 12 941 Resignations 0 0 2
Onboardings(hires) 3 1 27 Public Records Request 44 29 358
Offboardings(Terms) 0 8 25
Payroll Authorizations 31 65 - Community Development 19-Jul 19-Aug YTD
EE Benefit Chgs& Verifications 34 139 - Land Development Applications 7 7
EE Recognition-Individual 16 13 172 Board Meetings 1 1
EE Recognition-Group 0 1 4 Ongoing Projects 3 4
Training(Headcount) 10 107 196 10 Year Water Supply Plan 1 1
FMLA Requests 1 2 10 Non Ad Valorem(NAV) N/A N/A
Work Comp Claims 1 4 9 Annexation Research N/A N/A
Grievances,Investigations&Lawsuits 1 0 5 ADA Compliance Documents 4 0
Policy/Handbook updates o 2 Major Meetings/Conference Calls 6 4
Records Requests 3 1 19 Lighthouse Art Center 2 2
HRIS Adjustments 1600 2499 14,159 (2GHO)-Reserve and Seaglass 3 1
Newsletter 1 1 6 Phil Perko-Seaglass 1 0
Safety Mtgs&Assessments 1 2 5 SFWMD 1 1
Auto,Property,Liability Claims 0 1 6 DRC Meeting 1 1
Permits(New Single Family and Co 4 3
Properties&Areas Mowed 4x per
month 33 33 33 Phone Calls/Emails/Walk-Ins 72 86
Properties Trimmed Hedges 5 19 5
Properties Trimmed Palms,Trees 5 10 15
Flowers Planted 66 0 0
Properties Fertilized 6 2 0
Page 289 of 414
Agenda Item #12.
Landscape equipment maintenance
frequency per month 1 1 2
Sidewalk Repairs/Grinding 5 0 0
Street Signs Replaced 6 2 0
Road Repairs 4 1 1
Pet Pots Maintained 2x per week 8 8 8
Vegatation Debris in yards 30 30 60
Banners Hung 25 16 19
Outdoor lights Repaired 5 11 10
Street Light Outages 0 0 2
Work Orders 0 49 110
Standby Generator Maintenance 2 2 3
Fleet Maintenance/Vehicles Serviced 15 19 23
Surplus-Junked or Sold lems 37 8 140
Utility Locates 811 Dig 6 1 2
Engineering Services 1 2 2
Customer Calls 9 17 16
Event Set-up 5 5 7
Projects 9 10 9
Building Dept. 19-Jul 19-Aug
In-Office Meetings With Residents 16 34
Permits Issued 143 115
New Residential Permits 0 0
Residential Remodel Permits 56 47
Commercial Remodel Permits 15 9
Trade Permits 72 59
Residential Plan Reviews 56 106
Commercial Plan Reviews 15 9
Total Inspections 263 266
Certificates of Compliance 98 75
Over the Counter 29 24
Electronic 114 91
Land Develoment fees $10,998.49
Building permit fees 53,788.71 21,741.85
Building Permits average turnaround 48 hrs 48 hrs
Complaints 2 3
Record Requests 11 18
Permit/Code Information Requests 24 23
Regular Council Meetings 1 1
Council Workshop Meetings 1 1
FFMA-ASFPM Meetings/Training 1 2
BCAIB-BOAF-BOATC/DBPR Meetings 2 2
Code Enforcement Inspections 23 16
Notices of Violation Issued 12 7
High grass and weeds 2 0
Rubbish and accumulation 0 1
Illegal RV/camper/trailer parking 5 5
Dangerous structure 1 0
Illegal water drainage 1 1
Obstructed view 1 0
Other 6 9
Code Cases Opened 16 8
Code Cases Closed 13 5
Code Cases Cleared Within 30 Days 14 5
Code Cases Scheduled for Hearing 2 1
Magistrate Meeting 1 2
Meeting With Residents Re Violations 17 10
Page 290 of 414
Agenda Item #12.
Building Dept. June Year to Date(I Prior Year Total(FY)
Permits and Reviews
In-Office Meetings With Residents 16
Permits Issued 143
New Residential Permits 0
Residential Remodel Permits 56
New Construction Permits 0
Commercial Remodel Permits 15
Trade Permits 72
Residential Plan Reviews 56
Commercial Plan Reviews 15
Total Inspections 263
Certificates of Compliance 98
Permit Application
Over The Counter 29
Electronic 114
Building Permit Valuations and Turnaround
Building Permit Fees 53,788.71
Expenditures $43,145.25
Building Fees Minus Expenditures $10,643.46
Building Permits Average Turnaround 48 hrs
Complaints 2
Request for Information
Record Request 11
Permit/Code Information Request 24
Code Enforcement Activity
Code Enforcement Inspections 23
Notices of Violation Issued 12
High grass and weeds 2
Rubbish and accumulation 0
Junked vehicles 0
easement violation 0
Illegal RV/camper/trailer parking 5
Dangerous structure 1
Stagnant water 0
Illegal water drainage 1
Obstructed view 1
Other 6
Code Cases Opened 16
Code Cases Closed 13
Code Cases Cleared Within 30 Days 14
Code Cases Scheduled for Hearing 2
Magistrate Meeting 1
Meeting With Residents Re Violations 17
Page 291 of 414