HomeMy WebLinkAboutDocumentation_Regular_Tab 02_12/14/2023 Agenda Item #2.
Regular Council
STAFF MEMO
Meeting: Regular Council - Dec 14 2023
Staff Contact: Jeffery Snyder, Finance Director Department: Finance
Presentation of the Village's Financial Results for Fiscal Year Ended September 30, 2023
This financial overview is presented pursuant to Article III, Section 3.03(10) of the Village Charter,
which requires submission to the Village Council, within ninety (90) days after the close of each fiscal
year, a complete report of the operation and business of the Village for the preceding fiscal year.
The amounts herein are unaudited (subject to change) and represent the results of operations for
various Village funds as year ending September 30, 2023. The audited financial statements will be
presented to Council after the Village's independent CPA Firm, Mauldin & Jenkins, have completed
their audit, which is expected to be finished during March 2024.
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.
BUDGET AMOUNT N/A AMOUNT AVAILABLE N/A EXPENDITURE AMOUNT: N/A
FUNDING SOURCES: N/A IS THIS A PIGGYBACK:
❑ Yes ❑x N/A
DID YOU OBTAIN 3 QUOTES?
❑ Yes ❑x N/A
COMMENTS/EXPLANATION ON SELECTION Informational Only
POTENTIAL MOTION - • REQUESTED: I
Preliminary information on the results of the Village Financial Operations for Fiscal Year 2022-23.
Fiscal Review - FY 2022-23 Final
Page 10 of 593
Agenda
CD
014
Page 11
N
N
4�
e
1
/I •
nL
W
O
U
. •
Agenda Item #2.
N O M
L N
•— O > � O
O M
saw = �
0 ^ 0 N N
MENOMONEE oar s �
M 'gin }
0 = Q
N30
U � a0
�
u 0 0 � o
i V (D
V C
_0 O O 0 O
D }
0. 0
= H E
W 0 � a
NEv �
rto
3 U O
N •— N O
' � _ >
O N V 4)
V N } O
V
i •—
O L Q
U v 0 H O
Page 12 of 593
Agenda Item #2.
Q
� > N
4-
0 � N
U 0oa�
o
a QC
• } � � C � 7C)
� L4o �
• p g > >
� O
• • • w
• C: to
D N
• • —
o -0 U
4- � U
LL. 7C) (1) �
00 0
• Ln
> V Li Q D
CL
CL � E9—
— — — �
� •� � � � � s` � 0Ln
U' m ULL. U v, Lu 'o � �
• • • • • () °
Page 13 of 593
Agenda Item #2.
--------------------------------
X � �
•= L
O C
N O O V t
O V O O
N N a O p
t O Q 4) � }
. O
= N O N •�
= vs N od
VN
X V V
0) 0 .V Q
} } N `
CL
' _ } V N
a E — _ ' U
O a
12.
N C E L •U 0
N O i O i 4�
_a E > _ NEE
O O V L
� O a V L N
N = U •Q O >
r- O
(D 0)
Page 14 of 593
Agenda Item #2.
0 0 0 0 0 0 09 0 0 0
to I� M m I� m 0 0m o m
vro MIt00qt0m11001n
z rl In In 00 N rl O 01 01 14
' rI N 1 N � m
UC 0 y ' N
°
o
Q) Ln rl Ln N 0 N 11 rr) It 00
U qA l H N U) I;t 0 1 N 0 N
C N Ill N N 0 N 00 ' N H N H
z 00 N N H 0 N I N H It
L N H N 0) O N N 1 N Rt
rl m H N 1 m
� 0
� a �
1 —
• m In 0) Ln N H 00 11 00 O N Rt
1 N H N w In O � N H N � m
— N 't 't 00 0 N O 0 0 O O
N
N D O In N O O O m M " 00 O
O U In m 0N rl 0 w N rl qt rl
N Q 0) N rl rl N
} H
LL t4 -LA
y
• M O 00 O O In 0 1 N m w 0
.. N 0 rI O 0 00 N 0 1 00 0
• N N 0 N N N 00 m O N 0 N 00
N t'O H 00 't a) m N m 't 0 0 Ln
.• N -0 O 't 00 00 O M l0 �0 In m 'I
O O M In 00 N In H I
1 N co 0) N H lD
LL
1
0
Ul
+1 U N
L
U C > u1 '
v v v
aU E a� O
� L
(0 � C L fII 0
N ++ X � , OU -0v
v v L U 4 to a a� _
> C L L L � U L
N 0 -C (Q +J f0 C ) � ++
� a- 0LL cv co�c � � 0
Page 15 of 593
Agenda Item #2.
c o 0 0 0 o 0 0 o 0 0 0 0 0 0
M I� 00 M 00 O N O 00 g O N O rl rl 00 Ln
N M M H I Ln O O H H N 0 M O N N
v bA H O N r< ri 0 0 0 0 0 � 'i Ln 6 O rl Ln
1 Z N N H H
y y
u U)
U 0
a
o r
-------------------------
I�1
N Ol O M M 00 N 0 O 00 00 rl O N M N 0
— 0 0 N � q N N H 00 H M H M M M M 0
N N N O 00 O 0 rl q ri 0 M H M 00 M
C: v H rl M N Ol I�
fuz
m v,
> 0
O 000 0 M N w M H g H M 0 M H w H
M rl I� 0 N N w It M H 0 qt N O 0 N M
m lD rl rl N O M 0 ql O M H N 00 rl M M
N P() M 'I N rl 00 Ln M M 00 00 H c-I N rl M (n
N 0 N O 00 '1 N 00 N N 0 0 I, N 0) 0) N H
N M It M N N N N Ln L() � L() O L() L(1 H
O U M Ln c-I rl H N
} Q y � H H � rl
LL
N Lr) 00 Ln N O LO Lr) H N 0) O 0 0 O H N
1 M N H N O H 0 N M W 0 M O O W H
M 00 M 00 M O M In M N N M N 1 O 1
• N 0 q Ln 0) O N M e(1 M 0) 0 N L(1 H 00 N
N v 00 N H H I M 00 N N N 00 H H 0 0) O L()
• N hp M N N N N Lr) Lr) 0 H Ln H
O :3 r6 006
m
.. LL
c c C
v
• a-
u > L v
1 a 0 � L `° 0 .uv �
v V, a�i 0 Q a o � C
L s v O N 'L
U 0 N c
1 CMMUC cl a) U 3 D +, i —
D c E 2 m EC - -c w -Q O -Q v
(6 ,
— L +.+
U 2 > iL U l7 a- U LL a- —j 0
Page 16 of 593
Agenda Item #2.
•
• rn � � m N
m Ln w Q0
00 0 q:11 Ln R:ll
ri 0 M �D 00
0 0
00 r1l., rl-1 00
-U� -cn-
m
N
• 0
• N 0
••
• o Ol U � V oOl
N
LO
L- Z) u
Q) O M }
(� O N
r/0� Q� V u � o Nv
U L �, m f� m N�o � � � o
_ � � co C6
0 (� -a �o q
• — 00
a-J � m 3 °? c c
co 0 Q) _0y � � � � p a
N a
N i N C
E
• w� �--�m� � —
v
�� ` tan u zo Q
1
co � w U w
1
Page 17 of 593
Agenda Item #2.
0
0
Q
O
Q
m Q
Q
>
Q
N N
N 10
CD � co
00
Li
N O
_ M
N � O
NO LOCO
---- m_
NCO C)
t4
't O
_ � co
CV "q Cv
O %O 10
N LO O
>- Cl) N
LL-
Ol
• O O M
O �
N co Ol
. � co co
ri
�} t4
• 0 U
O O` O
N I�
U- (y
b �4
O`
a0 N
_ N
O O N
N U-) CO
>- M
r Cl)
LO 10
� �
O 00 LO
CV I� IT
>- � co
U 4
E/} y}
r� N
10 M
C"
• O � CD
>- O c0-
U- N V
1
0 0 0 0 0 0 0 0 0
O O O O O O O O O p
Ol 00 r� 10 U) M N Q
bg b4 b4 tf} Q
Q —
p m
LL
Q L
Q O
Page 18 of 593
Agenda Item #2.
1
O O I�
LO
Q41.S
- D CAI
w
QQ OLL �
• O �
1
•
O
LL. (Y)
• O (� �
V)
0 o j M
o }
� N c N
w
L
•
1
1
Page 19 of 593
Agenda Item #2.
L LO LO
aLO
� C. Ln
N 0 O
CO
O
O � �
t/1
Zvi 2 H N
V D r M
O > = H
0 L � 0) >
4) N 00 LO C C N
N
N LO
v} c c °O c
N M
C >- >- >- ca m H
U- U- U- a
V
ca m
_u L
N O O
u O
O O O
p N •0
� O H
L
N
}
•• u
y � S
—
.�
C _ =
O O
._
C^
W •_ ii N
O C
0
O
�L >
O
L ._
U C a 0
Qa u1L
Page 20 of 593
Agenda Item #2.
44
N
f O------------------------------------
Ow
OM
—
Q i s
r t/� O_ ; LL.
W LL.
vs
ka N
_ O O� Z
C L W
O �
1 Q rno
•
1 }
Yx
-� S v
Q d)
u3
y
O O-0
} Vf C
�Vv U
:/ LL H 4)
Page 21 of 593
Agenda Item #2.
r-I M N r-I N
r-I M 0) q:1- u1
(.0 M f� Ln r-I
N N N 0) N
r-i O N r� M
M M Ln M N
----------------
Q)
U
Ca
• m
• C:
LL N
• LL N
-0 O ro
ateJ N
U r-I O
O
O
• cn ch
DC N Ln \
O U N U O
o ? o
Ul m
• U L a-
CD
a--+ cn
0O 0 v Li co
C: Q) a_+ — m
-0 Q)
c: t
Q) 0
4A > Q
m LCir- W U W
Page 22 of 593
Agenda Item #2.
w r- O rl-� Ln
r- r- O r*.. Ln
m M O rn m
Q0 Ln 00 n 1c:T
m M r r-� Ln
r-I N r-I r-I N
------------
i/)-
N
U
f�
m
1 �
• • L N
� N
_0 O m
4- � N
U r-I O
.C: O N
Ln O O
— v
v N u O
N L Z) E 4-
ra 0O W MO
ai c/) � m LA
• V L a-J ru
C6 V
a--' V 1
0�0 0 Lira
tw cn Z3 c cu
v
Qj
c�
rw > Q
m w U w
Page 23 of 593
Agenda Item #2.
N (Z N q* C0
N N Ln I- Ql
Ln O r-i oo m
........._.. rl N r-I M
t1)-
N
• U
• cu fu
Cu
CD
LL N
N
m
N
U O
.L O N
can O
O
r-1 m
o �' O1
• I U O
N L
O L
N
w N s
U L
/ CO S — V
4- to
• CD 0 LL M
c Q) � m
-0 v
o: C . to
a c
M > a M
m � w U w
Page 24 of 593
Agenda Item #2.
C �
D N
U
C 0
0 E E
•— a� a�H
o
z a
W � U
LO 3
3 N �
O0n.............................. O Q G
y
C7 N
N a
U ail=
00
64"' u.. N (D 0.2
POOZ CG C x u
*6/ �i 0 2 o
06 L
0
� N N
AA� N
O L L
/ ^•
W
US
C
�O
L� C
N w 4
aap
E
N
N
IN
U O 0)
>_ O- C
L U QN�
^, O (D
VI �
0-030
� U� vOi
OM O
Q�O
3
Page 25 of 593
Agenda Item #2.
Q)
0O N
"t O
V Lq
• 0 tf}
IN16MC14
N No-
10
O .p
� � 7
U- -0 L")
•
O O
� O �
O 00 CON
� cc!
U- '0 LO
•
� N
O COO CD
O I� 't
>- � 0,
LL
00
� N
C4 M �
>- 00 O
L6
•
•
N
I n
O O O O O O O O
O O O O O O O O De w
tf} tf} } 64 tF+ to+ tf} tf}
Page 26 of 593
Agenda Item #2.
w ^ t � O M � � .0-01 j N
bd0 oo —i r-i O Ln M o0 o0
ZN 00 N C O rV N O
' N ri l0 r-I '
V 0O
ONO
--------------------------------
r O r- M O Ln r1 Ln
(U b.0 '1 00 M N zt 00 l0 f,
CIO O M l0 N M M r-I I�
M ? 00 l N �D 0) O M Ln
M Ln M M lD r-i r-I
V N
O
�rt
O lD W M O M O cV
00 I:zj- M N O M O M
Nate+ O r- n o0 rV r-i O I�
O C Sri Lr1 N O Lr
M I- r- [V M 0 0 0
f V O I- M N r-i I- M
Ly � r-I N Lll
V}
r-i l0 r-i l0 O I;t M I�
N = O m o � 0 M omo M
N M r\ Lr r M lD lD O r1
N � m m rn oo �n
U M M l0 N M r-i l0 M
Lj- Q r-i r-i U
w � ■
Z U Z
O "'
Zo Z LU W z
O oC U H
Lnu w Q
a w
LU
z 00 O w Op
E oL H N co U Z
-W0 N O w > O
M Q O U Q w Z
CL DC DC DC cn DC
O
Q Q Q Q W m
0 O
c-I N M ::1- O O
,Z* Ict IZT lz:l- r-i O M
N N N N 1�t r` M
Q Q Q Q Q Q Q 4,
W N W N N N N p
D D D 0 D 0 O H
Page 27 of 593
Agenda Item #2.
Ln Ln N M w
r-I O M r-I N
Ln M r r-I lD
1 \ \ \ 1
Ln M M
M CV O r-I Ln
N r-- Ln N qz:l-
1 - Q0 Ln r--1 W
O
J-
Cl.
C
^T'
W
z
_0 N
N
O
U N fV
O N
O o N
L aD
• v � t� O
Ln =3 ? p Q
N ry cn N
(3) O Lr) —
� U N
m O �i a O
air
a c bn
'aA > � �
m w U w
N
� U
Page 28 of 593
Agenda Item #2.
0,
LO
S Li o
\1 � �
O
N
LL
--------------------------------------
--------------------------------
LO �
N 10 O
N V
O r, 0,
� �
10 O
0 00 O
N r
• LL �
CD LO
00 U
O
>-04 00 0,
LL "t 't
' r" 00
O` O -O
FD 0C N
• ' >- 00 00
LL- 't �
64 t4
•
N �
• O O O O O O O O O O j
O O O O O O O O O O
O O O O O O O O O O > Q
L-() O V) (D V) O L-r) O L-r) O N x
10 10 LO LO 'T � c7 Cl) N N De w
tf} t4 tf} tf} t— t} t} tt+ t,} tp}
Page 29 of 593
Agenda Item #2.
M qc:l- q:31 O M
RZI- M l0 r-_ r-_
I'D Ln Q0 O Ln
N Ln O Ln r-,
I� r-_ O N
O
a=+
O
4—+
z
N
_0 N
U O
cV
O
CD
O
`� cn cn \
U Ln u O
cn i
=O i cc O
V) m Ln
U i +.,
N
1 ca � o
m 0 cc
tvp cn � � ca
.E -0
c bo
au a) C
m W w C— w
V
Page 30 of 593
Agenda Item #2.
a�
10
0
oM
Lo
N
0
--------------------------
M �
N �o Lo
M
U- 10 1
• N 10 co
ON 10 N
' Lx) 10
O Lo �
• � LO
LO
/ O- o10
O L
>- COU- It CO
N
O O O O O O c
• O O O O O O
O O O O O O N X
N O co 10 V N De w
Page 31 of 593
0 0 0 0 0 0 0 0
Agenda Item #2. 0 0 0 0 0 0 0 0
CD O o CD CD CD CD CD
LO co N
cn
LO
4.4 O
M
LO
N b4
O
lV
---
co------------------------------
U')
- N O O
-- N r� O
O N U')
•
Q � O
>- LO M
U- N 10
•
Q r,
>- O LQ
LL V
b4 t,4
N
� N �
('I `0 LO
>- Cl) 00
L 7
t4 64
N
• O O O O O O O O O O O O O O
O O O O O O O O O O O O O O N
O O O O O O O O O O O O O O DL
Q
CD O CD CD CD CD CD CD O CD CD O w
O Lx) O LO O LO O LO O LO O LO O L
I,- 0 0 LO LQ V Iq (0 CO N N t
lb4 4r4
N �
IIJ Q
w
c )
0 O
Page 32 of 513
Agenda Item #2.
Ln M l0 r-_ N
dl I*-_ Ln
dl O r-I � dl
,zt N M fV I�
I� l0 Ln O r-,
O M rl rl
r-I
O
a=+
O
N
z
_0 (V
N
Oro
U (V
• Z O
N O N
O O
S` \
cn cn
O v `n v O
cn L
=3 L ru O
• QJ V') - CD cn
V a--+ m ca
c O
CID C- \ U
ma-J to
O\ Q)
to cn ca
c N }' •— m
.E
C .
m W u W
U
Page 33 of 593
Agenda Item #2.
Ln
�U LLI
lD
F i
• LL � c
Q C
� . 'n (U
v
> co v un
.......
p o w _ Q
--
a+11 L L N Q O Q
41
i � N v C U L L
> Q N LQ> a E = u a
Q ° v c L v > U v
v c p N o v L c U
. V) L. L v
L U CL
O t c Z) Q —
U U V) —
' - v V U c N o O c E U
O 0 C O \ M p 'O v v
• V) J = —i Q J N U Q a DC
■
1:11 OIZT O 00 rl O N n Or� M N
• 00 l0 00 0 I:t l0 m c-I M r� qt N 00
I*- N m M H m w N M qt m l0 M
v
rl M cri of 06 06 m 1 ry� L6 rri M
' 00
O
oC
c
0
F
Q
�a
H
> > >
-a 0 0 0
o 0 0 ru
� c c c v —
� uUU cccv
v v v L U U
C
c c c
L L L C •� L .L
O O O L. L.
+- .4� .4� O O O ca ca U cn ci
U U U
p p a
L L L '- N
O O O -0 -0 -a v N c E 0 0
CC Cz; :3 :3 L L v O -
- — a a a LL LL 0 U J J
Page 34 of 593
Agenda Item #2.
0
v
0
(7
06
v
Q
+-j
L
O
..................... ............... > N
•� Y L
Q N
\ ) >`
f0 v
--- -- U LJ N > L U �n
v v ° u
d Q > i D > v
' O v v O v;
L � U
> O c:
u o E 0 5-
v -0 M M v L v
v
> — a E
4- > m F O a
' v C O O N 4-
a a a Cl.0 v c�
L
• V) U W LL, W W OC U ~
0
Il� N Ln O O O O 00 I*l n N
• N N N 0 w � I� N 00 r- N H M ('�M M
00 00 N 00
OJ
' O
C
0
E
Q
-V� in if� V�
H � H
LL
7
r_ c
LL E +�
> Qi c
>
v
O O cn in E E
Q. Q L L L L L L L
co co E E O O O O O ro
f0 M U U U U U
-6 ++ -t — — — — —
Q. Q -0 -0 -0 -0 -0 L1 v
D M M � =; � = =
m U U a a a a LL E LZ
Page 35 of 593
Agenda Item ■2.
� m
E $
. 2 �
y �
p ƒ
® ®
E u
° o �
/ I
E § q / / \ E
) \ $ 2 e E j
ƒ E 2 E E § a
@ E o § ® 'S
� $ / 2
7 § / t 0 E > / o
« k / u > '� / § E -W
---- 7 ® L Q E E ] E $ k e Qj
/ cc .- I m Q � M g
\ / 7 M
z c o / 2 0
f $ ' ) C 0 t a 7 c M
E 2 0 u / c R u
u § g E v R m '} R U / o m $ c
CO a Q / � § ƒ m § \ Z 0
Q
� � E E _ o c R 0 £ ' U
m 2 E � I b ® ®
§ U N g E g Q c
R [ u Q
'§ / U U 2 q / \ > 2 % / aLL
_ — v u = U /
'k v % c £ '� q_ v 0 = � 'm D %
w R R R / k R O / / k / R k
e m $ qt m@ 0 0 n 0@ m » @ 0 m
n 3 e 3 2 ¥ 7 m 2 0 3 # S@ 0 M
E % m O@ � m g m m m r- ¥ S 3 rq
d 6 6 L & & o 1 � or-� rl� ry� 6 1C4,
2 m ¥ ¥ » % m ¥ & m ¥ Zt % a
� o
�
�
c
0
[
«
�
0
.. �
�
LL
L.
> > > > > > > » ¥ > » >
R + ' 4 +J ' '
@ $ 4 o $ I u u@ Q v @ $ I
+J 4� +J +J 4� 4� +J +j +j �
Page 36 G 593
Agenda Item #2.
L
D
u
LL
D v
u a
c v C 0 CCMUl) U-) C
U U E E v G
_-- Q O IV a! M y oZS c0 v
u a " Q Q f6 n3 ++ O
o o v
m ' u V) a v E
u +j > v v > O v
U u v v (D
v u `° `� N v
oc 06 v v + oc
u i Ln O 00
00 a
u) O O v L V) V)
Q a z O L \ H O O Z
LL
• � vui � vi a
Ln O qt 0 H O O O O M H M M N
• t0 O H O N Ln O O O M 00 M 00
M M 0 1�t M M O N O O w H 00
GJ
O � M 0 � M tD � � l�D� 01 N ri
O c-I 00
' 0 N N N
C
• 0
O
E
o o
a,
O N N
`.
_ O
C > > > >, > > > > > > > H
LL — — — — — — — — — — — aJ
L L L L L L L L L L L d
M v v v v v v W W W v w
Page 37 of 593
Agenda Item #2.
w
c E
� L
ro Ln
d
W
_ UA
a) +r
--- - u 0 L.O C C
......-
G a1 0 Q O U
a v L N Q)
' +.J v an
Ln f0 L
in Ln
< E L C
o 0 0
+ +J V +�
ul
LL6 4� ro
L L L QJ
d 0 > U
/ Mu Q Q
•
0 H Ln M M It RT
O0 M N � rrl O O
• LO ' H M H rM-I
N M
O
+•+
C
3
E
Q
th -V� to V'r
HLL H
� � v
3
LL E
L V 4-0
L C:
�+ p aa)
E
3 W i
Ew w w w Q
-W 3 3 J 0
LA
E E E E �0
a�
a,
0 0 0 o -
a o
ci Ln Ln Ln cn a
Page 38 of 593
Agenda Item #2.
--------------------------------
1
Page 39 of 593