HomeMy WebLinkAboutDocumentation_Regular_Tab 07_1/9/2020Agenda Item #7.
Regular Council
STAFF MEMO
Meeting: Regular Council - Jan 09 2020 - AMENDED AGENDA
Staff Contact: Jeremy Allen, Village Manager Department: Manager
Manager's Report
Below are list of the Finance Department reports presented and statistical data for the month of
November 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 $746 thousand, which represents 10% of the budgeted amount. It is
$500 thousand lower than the prior fiscal year-, however, we are expecting the distribution to catch up
in the month of December 2019. Historically, 91% of ad valorem tax distribution receipted by the end
of February.
3)Sales Taxes collected $36 thousand, which represent 7% of the budgeted amount and on target for
one -month collection due to the distribution to be one month behind the collection/reported period.
4)Sales/use taxes (10%) and intergovernmental revenues (9%) fall below 16.67% budget target due
to the distribution to be one month behind the collection/reported period. Local Discretionary
infrastructure surtax falls two moth behind. However, it is on target for one -month collection.
Page 104 of 686
Agenda Item #7.
5)Revenues (Budgetary comparison) recorded in the General fund represents 11 % of budgeted due
to the distribution nature of State revenues and Ad valorem taxes (representing 66% of overall
General fund revenues).
6)Overall Expenditures (Budgetary comparison) in the General Fund represents 15% of budgeted,
which is slightly below targeted 16.67%.
7)Revenues (Prior year comparison) all funds decreased by $1 million (35%) due to ad valorem
revenues collected $500 less than prior year and Water Utility billing $527 thousand not being
processed/posted in November 2019. Utility Billing was processed and posted December 1 for the
October 2019 revenues.
8)Expenditures (Prior year comparison) all funds has decreased by $99 thousand (3.43%) mainly
due to the timing difference in recording some of the expenditure payments (insurance, FEC lease, d
landscape and irrigation maintenance).
Combined
Page 105 of 686
kdifIt§)# BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/7
aca 11 Period Ending 11/30/2019
DB: Tequesta
Fund 001 GENERAL FUND
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents
2,892.76
Investments
2,797,214.26
Accounts Receivable
202,628.00
Due from Other Funds
0.00
Inventories
38,180.21
Prepaids
139,822.68
Other Assets - Current
0.00
Other Fixed Assets
0.00
Total Assets
3,180,737.91
*** Liabilities ***
Accounts Payable
;65,316.07)
Accrued liabilities
8,162.96
Retainage Payable
0.00
Due to Other Funds
0.00
Due to Other Governments
4,609.98
Deferred Revenue
0.00
Other Current Liabilities
0.00
Customer Deposits
0.00
Noncurrent liabilities
0.00
Def Inflows of Resources
132,748.97
Total Liabilities
80,205.84
*** 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
391,214.00
Fund Balance - Assigned
0.00
Fund Balance - Unassigned
1,759,014.03
Total Fund Balance
3,882,110.58
Beginning Fund Balance - 18-19
3,882,110.58
Net of Revenues VS Expenditures - 18-19
(198,154.01)
*18-19 End FB/19-20 Beg FB
3,683,956.57
Net of Revenues VS Expenditures - Current Year
(583,424.50)
Ending Fund Balance
3,100,532.07
Total Liabilities And Fund Balance
3,180,737.91
* Year Not Closed
Page 106 of 686
kd19 'N'! It§t#P. BALANCE SHEET FOR VILLAGE OF TEQUESTA
aQ� Period Ending 11/30/2019
DB: Tequesta
Fund 301 Capital Improvement Fund
GL Number Description
*** Assets ***
Cash and Cash Equivalents
Investments
Accounts Receivable
Due from Other Funds
Prepaids
Total Assets
*** Liabilities ***
Accounts Payable
Accrued liabilities
Retainage Payable
Due to Other Funds
Total Liabilities
*** Fund Balance ***
F/B - Res for Encumbrance
F/B - All Other Reserves
F/B - Unreserved - Designated
F/B - Unreserved/Undesignated
Fund Balance - Nonspendable
Fund Balance - Restricted
Fund Balance - Assigned
Fund Balance - Unassigned
Total Fund Balance
Beginning Fund Balance - 18-19
Net of Revenues VS Expenditures - 18-19
*18-19 End FB/19-20 Beg FB
Net of Revenues VS Expenditures - Current Year
Ending Fund Balance
Total Liabilities And Fund Balance
* Year Not Closed
Balance
6, 824 . 69
556,149.14
8,883.50
0.00
0.00
571,857.33
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
422,754.00
0.00
;392,229.23)
30,524.77
30,524.77
413,083.42
443,608.19
128,249.14
571,857.33
571,857.33
Page: 2/7
Page 107 of 686
kd19 'N'! It§t#P. BALANCE SHEET FOR VILLAGE OF TEQUESTA
aQ� Period Ending 11/30/2019
DB: Tequesta
Fund 303 Capital Projects Fund
GL Number Description
*** Assets ***
Cash and Cash Equivalents
Investments
Accounts Receivable
Due from Other Funds
Prepaids
Improvements Other Than Bldgs.
Total Assets
*** Liabilities ***
Accounts Payable
Accrued liabilities
Retainage Payable
Due to Other Funds
Total Liabilities
*** Fund Balance ***
F/B - Res for Encumbrance
F/B - Unreserved/Undesignated
Fund Balance - Nonspendable
Fund Balance - Assigned
Fund Balance - Unassigned
Total Fund Balance
Beginning Fund Balance - 18-19
Net of Revenues VS Expenditures - 18-19
*18-19 End FB/19-20 Beg FB
Net of Revenues VS Expenditures - Current Year
Ending Fund Balance
Total Liabilities And Fund Balance
* Year Not Closed
Balance
154,312.79
0.00
0.00
0.00
0.00
0.00
154,312.79
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
204,312.79
204,312.79
204,312.79
(50,000.00)
154,312.79
0.00
154,312.79
154,312.79
Page: 3/7
Page 108 of 686
kdafIt§try P.
BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/7
aca a 11 Period Ending 11/30/2019
DB: Tequesta
Fund 401 Water Fund
GL Number Description Balance
*** Assets ***
Current Assets
0.00
Cash and Cash Equivalents
352,714.86
Investments
5,313,578.98
Accounts Receivable
92,950.87
Special Assess -Current
0.00
Special Assess - noncurrent
0.00
Due from Other Funds
0.00
Inventories
212,167.63
Prepaids
44,291.49
Other Assets - Current
0.00
Land
83,335.00
Other Assets - Non Current
83,335.00
INFRASTRUCTURE
14,120,256.79
Buildings
256,740.48
Improvements Other Than Bldgs.
29,360.00
Machinery & Equipment
184,457.27
Construction in Progress
2,517.38
Intangible Assets
54,814.52
Other Fixed Assets
0.00
Deferred Outflows
529,564.62
FIXED ASSETS
0.00
Total Assets
21,276,749.89
*** Liabilities ***
Accounts Payable
;11,511.19)
Accrued liabilities
17.15
Retainage Payable
0.00
Due to Other Funds
0.00
Due to Other Governments
455.60
Deferred Revenue
0.00
Current Portion of Debt
403,465.51
Other Current Liabilities
0.00
Customer Deposits
42,955.54
Noncurrent liabilities
3,119,114.03
Other Long Term Liabilities
397,857.38
Def Inflows of Resources
231,539.00
Total Liabilities
4,183,893.02
*** 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 - 18-19
17,549,160.98
Net of Revenues VS Expenditures - 18-19
81,832.85
*18-19 End FB/19-20 Beg FB
17,630,993.83
Net of Revenues VS Expenditures - Current Year
(538,136.96)
Ending Fund Balance
17,092,856.87
Total Liabilities And Fund Balance
21,276,749.89
* Year Not Closed
Page 109 of 686
4&i
kdf t BALANCE SHEET FOR VILLAGE OF TEQUESTA
aca IC Period Ending 11/30/2019
DB: Tequesta
Fund 402 Refuse & Recycling
GL Number Description
*** Assets ***
Cash and Cash Equivalents
Investments
Accounts Receivable
Other Assets - Current
Total Assets
*** Liabilities ***
Accounts Payable
Due to Other Funds
Total Liabilities
*** Fund Balance ***
F/B - Unreserved/Undesignated
Fund Balance - Unassigned
Total Fund Balance
Beginning Fund Balance - 18-19
Net of Revenues VS Expenditures - 18-19
*18-19 End FB/19-20 Beg FB
Net of Revenues VS Expenditures - Current Year
Ending Fund Balance
Total Liabilities And Fund Balance
* Year Not Closed
Balance
68,188.20
70f324.28
0.00
0.00
138,512.48
0.00
0.00
0.00
118,098.59
118,098.59
118,098.59
8,539.78
126,638.37
11,874.11
138,512.48
138,512.48
Page: 5/7
Page 110 of 686
4& kdif BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/7
aca Gal IC"1 Period Ending 11/30/2019
DB: Tequesta
Fund 403 Stormwater Utility
GL Number Description Balance
*** Assets ***
Cash and Cash Equivalents
4,714.18
Investments
1,014,100.55
Accounts Receivable
1,600.00
Due from Other Funds
0.00
Inventories
709.84
Prepaids
0.00
Other Assets - Current
0.00
Other Assets - Non Current
0.00
INFRASTRUCTURE
1,017,457.10
Buildings
0.00
Improvements Other Than Bldgs.
0.00
Machinery & Equipment
10,476.33
Construction in Progress
0.00
Deferred Outflows
21,686.00
Total Assets
2,070,744.00
*** Liabilities ***
Accounts Payable
(631.90)
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
13,646.51
Def Inflows of Resources
11,223.00
Total Liabilities
24,237.61
*** 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 - 18-19
2,079,600.92
Net of Revenues VS Expenditures - 18-19
(31,467.03)
*18-19 End FB/19-20 Beg FB
2,048,133.89
Net of Revenues VS Expenditures - Current Year
(1,627.50)
Ending Fund Balance
2,046,506.39
Total Liabilities And Fund Balance
2,070,744.00
* Year Not Closed
Page 111 of 686
4&i
kdf t BALANCE SHEET FOR VILLAGE OF TEQUESTA
aca IC Period Ending 11/30/2019
DB: Tequesta
Fund 605 Special Law Enforcement
GL Number Description
*** Assets ***
Cash and Cash Equivalents
Investments
Accounts Receivable
Inventories
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 - 18-19
Net of Revenues VS Expenditures - 18-19
*18-19 End FB/19-20 Beg FB
Net of Revenues VS Expenditures - Current Year
Ending Fund Balance
Total Liabilities And Fund Balance
* Year Not Closed
Balance
80,479.20
0.00
0.00
0.00
80,479.20
0.00
0.00
0.00
0.00
108,391.34
108,391.34
108,391.34
(26,400.14)
81,991.20
(1,512.00)
80,479.20
80,479.20
Page: 7/7
Page 112 of 686
Agenda Item V.
v
7
D_
t
U
aJ
aJ
Ln
u U
aJ
C
w
O
3
z
�,
m
�
o
v
O
aJ_
O
U
U
T
T
N
C
C
O
O
o
E
Q
m
y
E
v
O
E
U
E
aJ
C
n
O
O
O
N
E
3
C
a,
S
D
o
v
_
_
LL
U
O
U
O
w
o
0
0
0
0
0
0
0
0
0
0 0
U
O
lO
W
O
ri
00
[V
00
L.D
O
-zl' ri
z
O
M
I-D
ri
O
rn
Ln
rn
Ln
O
oo m
Q
O
O
cV
ri
cV
-1
Zzr
Il
M
O
ri r-i
ri
N
Ol
PV
O
n
ri
Q
>
0
Q
H
LcJ,
::)
LU
Cl
LU
F-
Li
O
w
Q
J
J
Q,
p
N
O
M
ri
�
LU
U
Z
Q
<
w
O
w
>
w
Z
w rn
U
Q
p
ri
z O
Q
J
0
w
_
Q O
11
o
CO m
o r-1
CC
O
E
} ri
a
w
Lu
a
w
U 00
Z
Cf
w
LU
F
Q O
J
0
z
Q O
CO M
w
M
CL
X
♦- ri
�
0
M
O
� Z
C)
N
LL ri
U
aJ
a, o
� T C
3 O O
O _0
O T O
E fl_
O 0aC C
O •-
U-
� N v
c c
Q)
f� H
0 0 0 0 0
Ln N O O N
1p Iq O O ri
r-1 O O O 00
M I O O LA
r-1 r-I
N m lD ri m (T In O 00 m m m LD O W N O
I- cV I, W n W M C4 lD M O M ri O O tD O
N M O W M I, lD M lD lD Ln (V O M (V M r-1
m `J N ri ri M v N ri ri Dl rl v Ln rl
00 RZI, N v v v v v N
Ln ri
w w lD lD N lD m m m m p Ln lD O N O O
m I- o N Ln o ri Lo Lo m I- -zi, m o o m o
ri I- N O Ln m N ri lD cV M O M ri
L.6 00 LD ri 00 O Ol N CV O Ol ri Ln M I�
zj, oo Ln oo Rzj, N M 00 M m N
I- r-1 r-1 r-1
O ri O m p I- Ln w n O ri N N O O N O
r- O M:Zr r- ri N 00 m oo Ln r- O ri m
tzr ri ri ri LT ri Ln ro 00 F, lD O m Ln Ln
Ol Ol N O Ln Ol r- M N r-I 00 O I- cv1 Ln
fV 00 Ln 00 M m 00 M ri m
m ri
r-1
0 0
Ln m
I I
r-I II r-I
O
O
O
PA
O
O
M
In
cc
� W
C LL
In
Z ++ u N w OC
U C C U C
>ON
> u of
>� Ln
CL X Ln a) O a) C I LO U Ln
f0 L/1 UI .V Vf C E N J
U ~ O N (0 (O Ln > aJ +N+ -0 U_ 0 N L/7 U H Ln
LLJJ 110 X C UI C �_ j E CL > �Y > 0A • j W W
0 a) Vf f0 a) +' V, - L W C C
aJ > Lnn u Z Z
In N p w L CL a) 8 O w M >>
W 0" In C L, L/7 ++ U C N W W
D _ N > >_ > co i2 LL Vf L N .� I..L >_ N M M
Z E o6 00.0 00.0 U vN N L N J J
wW C C a) a) 0A C V) Q a) 0A (0 C t C f6
aJ t a� C E
w U w cn - U- oC Li- - --i U U U 0 H U H H
0 0 o 0 0 0 0 0
w O O ri M N 0 0
W O O N Ln -i O O
�t O O N M-zil 0 0
r-1 r-1
W O O M M w N O
LLn O r- � lm0 Ln O
Ol ri lD ri ri ri I-
LT CV r-1 N
ri
[V O
O
Ln
�
00
N
O
00
O
r-m
ri
O
�
O
m
Ln
O
O
�
N
ri
ri
I�
rn
r-
r-I
0 0 0 [V ri ri O O
00 O M O
O O lD lD n
N Ln M
O I-
PIL
o �� o
O
ri
r-I r-I 00
ri ri �
00 N Ln
N M 00
M N M
N N v
L
Ln
O
Cl
Cl
00
N
L'
Ln
O
00
N
O
Ln
M
ce
Ln
W
w
D
In Z
Z
p W W
C a+ LL d
Li a) Ln Z W
� Q co
O Ln
Ln a) `� u `� ESan
-O O U U w ++ Z J W
QC 'o - a� 3 o a a L>1,,
w C " C W J i W W .yL�
z (O - - w ap t)
Z _ o o a0.� N E --
W a-+ 7 >_ U C
wa) f0 f0 O W
C7 U U CC Ln L n H Z
• • •
Agenda Item #7. VILLAGE OF TEQUESTA
REVENUE REPORT FOR THE VILLAGE OF TEQUESTA - UNADJUSTED, UNAUDITED
PERIOD ENDING 11/30/2019
YTD BALANCE I YTD BALANCE
DESCRIPTION 11/30/2018 11/30/2019 VARIANCE I % VARIANCE NOTES
REVENUES
Fund 001 - GENERAL FUND
General Property Taxes
1,329,470
746,198
(583,272)
Sales & Use Taxes
152,130
156,206
4,076
Franchise fees - gross receipt
89,101
88,778
(323)
Intergovernmental Revenue
80,145
81,026
881
Chgs for Sery - Gen Gov
5,979
48,552
42,573
Intragovernmental Revenue
99,117
120,906
21,789
Rents & Royalties
37,525
39,219
1,695
Miscellaneous Revenues
3,383
64
(3,320)
Chgs for Sery - Public Safety
98,652
99,945
1,293
Fines & Forfeitures
2,837
2,169
(668)
Impact Fees
0
2,693
2,693
Contributions & Donations
7,900
5,400
(2,500)
Licenses & Permits
81,781
80,279
(1,503)
Charges for Services - Recr.
10,072
1,056
(9,016)
Other Financing Sources
0
30
30
Unrestricted Investment Earning
14,650
11,536
(3,114)
-43.87% First distribution in 2019 lower, will catch up in futu
2.68%
-0.36%
1.10%
712.01% Land development fee schedule increase
21.98% Implemented Admin fees from Build Department
4.52% Cell towers leases increases
-98.12% Differs from year to year
1.31%
-23.56% Code enforcement fees differs
100.00% Differs from year to year
-31.65% Tequesta Fest donations, timing difference
-1.84%
-89.51% Tequesta Fest collections recorded in Dec 2019
100.00%
-21.26% Investment account balance decrease
Total General Fund
2,012,743
1,484,057
(528,685)
-26.27%
Fund 301 - Capital Improvement Fund
Unrestricted Investment Earning
0
1,149
1,149
100.00% Differ from year to year and budgeted at low
Transfers In
0
127,100
127,100
100.00% Transfers differ from year to year
Total Capital Improvement Fund
0
128,249
128,249
100.00%
Fund 303 - Capital Projects Fund
Transfers In
0
0
0
0.00%
Total Capital Projects Fund:
0
0
0
0.00%
Fund 401 - Water Fund
Miscellaneous Revenues
5
5
(0)
-1.38%
Other Financing Sources
5,592
0
(5,592)
0.00%
Unrestricted Investment Earning
14,865
17,396
2,531
17.03% Interest rate and account balance increase
Charges for Services
790,096
218,868
(571,228)
-72.30% Water utility billing posted on Dec 1, s/b Nov 30
Total Water Fund:
810,558
236,269
(574,289)
-70.85%
Fund 402 - Refuse & Recycling
Intergovernmental Revenue
0
0
0
0.00%
Unrestricted Investment Earning
349
230
(119)
-34.12% Investment account balance decrease
Tax collector distrib in 2019 lower, will catch up in
Charges for Services
110,133
53,718
(56,415)
-51.22% future months
Total Refuse & Recycling:
110,482
53,948
(56,534)
-51.17%
Fund 403 - Stormwater Utility
Unrestricted Investment Earning
3,646
2,991
(654)
-17.94% Investment account balance decrease
Tax collector distrib in 2019 lower, will catch up in
Charges for Services
69,976
36,719
(33,257)
-47.53% future months
Total Stormwater Utility:
73,622
39,711
(33,911)
-46.06%
TOTAL REVENUES - ALL FUNDS
3,007,404
1,942,234
(1,065,170)
-35.42%
TOTAL REVENUE LESS TRANSFERS
3,007,404
1,815,134
(1,192,270)
-39.64%
Page 114 of 686
Agenda Item #7. VILLAGE OF TEQUESTA
EXPENDITURE REPORT FOR THE VILLAGE OF TEQUESTA - UNADJUSTED, UNAUDITED
PERIOD ENDING 11/30/2019
YTD BALANCE
YTD BALANCE
DESCRIPTION
11/30/2018
11/30/2019
VARIANCE
VARIANCE
NOTES
EXPENDITURES
Fund 001 - GENERAL FUND
Council
9,814
10,428
614
6.26%
Manager
60,501
40,494
(20,007)
-33.07% Regular Salaries & Wages decrease
Human Resources
59,277
63,262
3,984
6.72% Computer system main increase
Village Clerk
58,418
62,249
3,831
6.56% Computer system main increase
Finance
72,528
63,231
(9,297)
-12.82% Overall expenditure decrease
Legal
9,082
13,587
4,505
49.61%
Comprehensive Planning
5,261
15,329
10,068
191.39% Misc Planning Service increase
General Government
72,785
50,283
(22,502)
-30.92% Property/casualty ins have not payed/recorded
IT
31,158
31,411
253
0.81% *
Police Department
521,148
506,991
(14,157)
-2.72% *
Building & Zoning
85,841
116,491
30,649
35.70% Admin Mgmt Fees implementation
Code Compliance
13,321
13,221
(100)
-0.75% *
Fire Control
576,475
551,064
(25,412)
-4.41% *
Public Works
197,866
147,485
(50,382)
-25.46% Landscape maint, FEC lease not payed/recorded yet
Leisure Services
155,345
143,635
(11,709)
-7.54% Decrease in operating expenditures
Debt Service
110,878
110,878
0
0.00%
Interfund Transfers
0
127,100
127,100
0.00% Transfers differ from year to year
Other Nonoperating
384
346
(38)
-9.95%
Total General Fund
2,040,080
2,067,482
27,402
1.34%
Fund 301 - Capital Improvement Fund
Public Works
0
0
0
0.00%
Total Capital Improvement Fund:
0
0
0
0.00%
Fund 303 - Capital Projects Fund
Recreation Center
21,000
0
(21,000)
0.00%
Total Capital Projects Fund:
21,000
0
(21,000)
0.00%
Fund 401 - Water Fund
Water -Administration
225,945
191,633
(34,312)
-15.19% Insurance, engineering exp lower
Water - Production
287,009
242,463
(44,546)
-15.52% Utility services, water chemicals exp lower
Water -Distribution
171,014
135,983
(35,031)
-20.48% Comp absences decrease
Renewal & Replacement
3,900
134,273
130,373
3342.58% WTP upgrade project
Debt Service
67,419
68,052
633
0.94%
Other Nonoperating
2,346
2,002
(344)
-14.66%
Total Water Fund:
757,632
774,405
16,773
2.21%
Fund 402 - Refuse & Recycling
Refuse and Recycling
40,641
42,074
1,433
3.53%
Total Refuse & Recycling:
40,641
42,074
1,433
3.53%
Fund 403 - Stormwater Utility
Storm Water Utilities
36,866
32,838
(4,027)
-10.92%
Renewal & Replacement
2,835
8,500
5,665
199.82%
Other Nonoperating
0
0
0
0.00%
Total Stormwater Utility:
39,701
41,338
1,638
4.12%
Fund 605 - Special Law Enforcement
Police
0
1,512
1,512
100.00%
Total Special Law Enforcement:
0
1,512
1,512
100.00%
TOTAL EXPENDITURES - ALL FUNDS
2,899,054
2,926,811
27,757
0.96%
TOTAL EXP LESS TRANSFERS 2,899,054 2,799,711 (99,343) -3.43%
Page 115 of 686
Agenda Item #7.
Page 116 of 686
Agenda Item #7.
Department Reports (November 2019)
Parks and Recreation
19-Oct 19-Nov YTD
Agendas Compiled and Distributed
3
48
39
Summer Camp Registration
45
0
Council/Comm Meeting Hours
4.5
67.5
62.75
Orders Processed
5
30
48
Ages 5-7
13
0
Resolutions Processed
9
48
35
Ages 7-12
32
0
Ordinances Processed
3
17
11
Ages New Families
6
0
Agreements Processed
10
52
65
Revenue
$46,687.50
Legal Advertisements
Recreation Programs
Legal Notices
3
42
38
Tai Chi Classes
14
14
Bids/RFPs/Quotes
3
4
3
Yoga Classes
20
30
Public Records Processed
21
205
226
Tennis Classes
13
13
Lien Request Processed
41
439
539
Fencing Classes
8
8
Imaged/scanned pages
1256
11686
10917
Gymnastics Classes
0
56
Open Gym Classes
0
3
Public Information Officer
Ninja Scouts Classes
0
4
Facebook Posts
12
321
426
Homeschool Classes
0
3
Facebook Message Resposes
5
156
unk
Mah Jongg Program
0
0
Facebook Followers
43
*3240
unk
Revenue
Page Views
1271
Unk
unk
Facility Rentals
Page Reach
10218
unk
unk
Constitution Park
3
11
Press Releases
01
7
3
Recreation Center
1
1
CodeRed Messages Launched
01
34
N/A
Tequesta Park
Smoke Signals
01
41
4
Groups
3
5
Clerk/PIO Events & Meetings: Tequesta Business Assoc/Hobe Sound Chbr
Steering mtg, election training, and ADA training
Reservations
19
Revenue
Website: Clerk's Offce serves as the webmaster and updates/amends most
pages/handles user administration/alerts, etc.
Special Events
Election: Met with 3 candidates and processed paperwork and election material
Food Truck
900
* number varies due to page likes/unlikes
Tequesta Fest
3,500
Run 4 The Pies
1
1 3,000
Water Distribution
19-Oct 19-Nov YTD Fire
YTD
as of
19-Oct 19-Nov 10/2019
Line Maintenance
0
1
Station Maintenance
469
409
878
Equipment Maintenance
4
26
Daily Training
646
514
1160
Work Orders (Non Meter)
6
100
Company Training
215.8
74.9
290.7
Employee Call Back
9
15
Officer Development Training
74.75
38.5
113.25
Valves Exercised
0
0
Driver & Operator Training
13
6
19
Service Repairs
1
0
jHazmat Training
2.5
4
6.5
Meter Set/Changed Out
29
8
10therTraining
5
16
21
Meter Reader Related Work Orders
87
66
FF Admin Duties
563
530
1093
Locates Performed
294
244
Unit Repose Data
Staff Vacancies (Days)
13
40.375
Fire
12
18
30
EMS
89
87
176
Customer Service 19-Oct 19-Nov YTD
SPOP's
1
0
1
New Accounts
40
32
Other
5
2
7
Closed Accounts
42
28
Mutal Aid Given - PBCFR/MCFR
6
11
17
Work Orders Completed
128
146
PBCFR/MCFR
6
131
19
Total Accounts Billed
5061
5087
Inspection Data
Aging Report
New Construction
14
22
36
30 Days
$17,743.16
$15,398.82
Annual Fire
15
114
129
60 Days
$12,749.97
$7,050.34
New uss ew
Riir1
4
5
90 Days
$12,843.58
$16,424.12
Re -Inspections
1 321
18
50
Page 117 of 686
Agenda Item #7.
180 Days
$23,614.56
$24,187.67
Food Truck/Tents
12
6
18
Past Due Shutoff List (Slow Pay)
73
91
Public Relations Events Data
Amount
$14,774.52
$19,117.43
Community Functions Hrs
89
125
214
Bill Adjustment Report
15 Accounts
12 Accounts
Station Tours
0
10
10
Leak:
8 Accounts
8 Accounts
Walk -Ins
3
2
5
Misread:
5 Accounts
3 Accounts
NON -SUFFICIENT FUNDS (NSF) FEE:
2 Accounts
1 Accounts
Overtime As of 12/27/19
Budget
Actual
Goal/Actual
Amount Billed
$477,282.09
$527,538.99
Overtime Budget
$92,100
1
$16,157
24%/17.5%*
Water Usage
60,626
73,126
Overtime Training Budget
$15,500
$3,113
1 24%/20%
*Includes Cash Comp Time
IT
19-Nov
Prior Month YTD
Helpdesk Tickets
137
126
137
Police Department
19-Oct
19-Nov
YTD
Projects
Communication Division
Council Chambers
Officer Initiated Calls
745
716
7590
Telestaff
Calls for Service
335
600
4531
Exchange 2016
Fire Rescue
42
79
632
Alienvault
Patrol Division
Water Distribution 19-Oct 19-Nov YTD
Reports Filed
32
19
302
Water Production Total
85.581
83.46
933.855
Arrest
8
11
73
Maximum Day
3.21
3.38
3.551
Crashes Investigated
10
8
321
Minimum Day
2.191
2.006
1.54
Traffic Stops
279
141
2774
Average Daily
2.761
2.782
2.795
Citations
63
72
541
Backwash Water
1.599
1.676
19.445
Warnings
79
48
654
Monthly Total Gallons Flushed
2.242
2.56
25.91
Administration
Monthly Rainfall
3.99
0.09
51.63
Open Positions
1
1
4
Projects
Resignations
0
0
3
New Filter Plant Power Cables load tested
Public Records Request
44
391
519
Filter Plant Backwash Programming installed to PLC
MCC Breakers and Drives installed and programmed
Overtime
Budget
Actual
Goal/Actual
Human Resources & Risk Managrem
19-Oct
19-Nov
YTD
Operations
$92,100
$40,789
24%/47%
Open Positions
2
2
4
Communications
$15,500
$4,673
24%/20%
Applications Rec'd
36
106
142
Community Development 19-Oct 19-Nov YTD
Onboardings (hires)
1
2
3
Off board ings (Terms)
2
0
2
Payroll Authorizations & Evaluations
186
48
234
EE Benefit Chgs & Verifications
5
21
26
Land Development Applications
7
3
EE Recognition - Individual
29
29
58
Board Meetings
2
2
EE Recognition - Group
1
0
1
Ongoing Projects
4
3
Training (Headcount)
1
2
3
10 Year Water Supply Plan
1
1
FMLA Requests
2
1
3
Non Ad Valorem (NAV)
N/A
N/A
Work Comp Claims
1
0
1
Annexation Research
1
1
(EE)
2
0
2
ADA Compliance Documents
4
N/A
Policy/Handbook updates
0
0
0
Major Meetings/Conference Calls
4
4
Records Requests
1
2
3
Lighthouse Art Center
4
HRIS Adjustments
4433
2315
6,748
(2GHO) - Reserve/Key Estates/Teq.
Country Club/ Pelican Sq.
4
3
Newsletter
1
1
2
Wayne Hermann - 209 Tequesta Dr
1
1
Safety Mtgs & Assessments
1
0
1
209 Tequesta Drive
1
-
Auto, Property, Liability Claims
0
0
0
DRC Meeting
0
0
Public Works 19-Oct 19-Nov YTD
Permits (New Single Family and Comrr
2
6
roper ies & Areas Plowed 4X per
month
33
33
66
Phone Calls/Emails/Walk-Ins
851
94
Properties Trimmed Hedges 1 20 1 10 1 30
Page 118 of 686
Agenda Item #7.
Properties Trimmed Palms, Trees
10
30
40
Flowers Planted
329
80
409
Properties Fertilized
1
1
2
Landscape equipment maintenance
frequency per month
3
1
4
Sidewalk Repairs/Grinding
2
0
2
Street Signs Replaced
1
1
1
Road Repairs
4
0
4
Pet Pots Maintained 2x per week
8
8
16
Vegatation Debris in yards
60
60
120
Banners Hung
20
24
44
Outdoor lights Repaired
7
12
19
Street Light Outages
6
0
7
Work Orders
138
150
288
Standby Generator Maintenance
4
2
6
Fleet Maintenance/Vehicles Serviced
6
14
20
Surplus -Junked or Sold lems
0
0
0
Utility Locates 811 Dig
1
0
1
Engineering Services
2
1
3
Customer Calls
18
1 28
46
Event Set-up
5
1 8
13
Projects
7
1 15
22
Building Department 19-Sep 19-Oct 19-Nov
In -Office Meetings With Residents
18
26
22
Permits Issued
115
130
102
New Residential Permits
0
1
1
Residential Remodel Permits
47
76
51
Commercial Remodel Permits
9
7
5
Trade Permits
59
76
46
Residential Plan Reviews
63
47
46
Commercial Plan Reviews
9
7
5
Total Inspections
266
279
205
Certificates of Compliance
75
75
62
Over the Counter
24
45
38
Electronic
91
85
64
Land Develoment fees
$18,793
$28,280.47
$15,624.92
Building permit fees
21,741.85
49,114.48
$31,164.09
Building Permits average turnaround
48 hrs
48 hrs
48 hrs
Complaints
3
0
1
Record Requests
18
23
19
Permit/Code Information Requests
23
31
26
FFMA-ASFPM Meetings/Training
2
2
1
BCAIB-BOAF-BOATC/ DBPR Meetings
2
2
1
Code Enforcement Inspections
16
30
7
Notices of Violation Issued
12
15
6
Rubbish and accumulation
0
1
2
Illegal RV/camper/trailer parking
5
18
2
Illegal water drainage
1
1
0
Other
9
23
7
Code Cases Opened
8
42
10
Code Cases Closed
5
27
4
Code Cases Cleared Within 30 Days
5
30
4
Code Cases Scheduled for Hearing
2
3
2
Magistrate Meeting
1
21
2
Meeting With Residents Re Violations
10
181
5
Page 119 of 686