OUA Annual Budget FY 2020-218/31/2020
Okeechobee Utility Authority
FY21 Budget
Table of Contents
FY21
Budget Document
Tab
Pages
A
A-1
Significant Budgetary Assumptions
A-2 to A-3
Notes to the Budget Summary of Sources & Uses Funds Statement
A-4 to A-7
Budget Summary of Sources & Uses Funds Statement
B
13-1
Notes to Revenue Summary
B-2
Revenue Summary
8-3 to B-4
Revenue Detail
C
C-1
Notes to Operating Expense Summary
C-2
Expenditures Summary
C-3
Operating Expense Summary by Department
C-4 to C-17
Operating Expenses Detail by Department and Account
C-18 to C-19
Non Operating Expenditures and Transfers
D
0-1
Additional Departmental O&M and Capital Expenditures
D-2
Five Year Capital Improvement Plan Expenditure Detail (CIP)
E
E-1
Analysis of R R & I Fund Transfer (5% Prev FY Sys Oper Rev)
F
F-1
Analysis of Emergency Reserve Fund Transfer (Req 30 Days of O&M)
G
G-1
Analysis of Operating Reserve Fund Transfer (Strive for 90 Days of O&M)
H
1-1-1
Analysis of Fire Hydrant Fund
J
J-1
Analysis of CIP (Capital Improvement) Fund
K
K-1
Debt Service Summary Truist Bank (formerly BB&T) and SRF Combined
K-2
Truist Bank (formerly BB&T) Debt Service Summary Series 2020 A & 202013
K-3
SRF Debt Service Summary
L
L-1
Notes to Labor Costs
L-2
Projected Labor Costs by Department
N
N-1
Projected General In -fill revenue from: WCC, WWCC & Install Fees
O
0-1
Projected Fund Balances and Expenditures for Capital Projects
R
R-1
Budget Recap for Newspaper
FINAL BUDGET 8/31/2020 8:11 AM
Okeechobee Utility Authority
FY21 Budget
Significant Budgetary Assumptions
In developing the accompanying annual budget, the following significant
assumptions and estimates have been used in the projection of operating
revenues and expenses:
Water and wastewater utility revenue has been projected using a weighted average
model. The underlying data in this model utilizes actual revenue levels from the
previous four fiscal years to determine the weighted average.
Water and wastewater utility revenue includes the additional revenue from the
projected customer infill growth of:
Proposed Rate Increase for Water Utility Revenue:
Proposed Rate Increase for Wastewater Utility Revenue:
In summary, total operating revenue as presented is greater than the previous years
budgeted level by:
O & M expense which may be subject to market volatility have been adjusted to reflect
projected changes. Per cent change from FY20 budget is given below.
Electric Services
$ 3,100
Chemical Expenses
$ 4,500
Fuels, Gas & Diesel Expenses
O&M Expenses (excluding labor)
$ 355,002
Labor related expenses reflect the following:
Total for Cost of Living Adjustment:
$26,819
Total cost for Employee Merit Increase:
$0
Total cost for Employee Bonus:
$59,363
Total cost for Employee Health Care Increase:
$0
Current Monthly Health Care Cost Per Employee
$700
FY21 Budgeted Monthly Health Care Cost Per Employee
$700
Total cost of Urgent Care Services Increase:
$0
Annual Pension Contribution Budget & Rate from Actuaries $305,599
Total labor expense is higher (less) than the previous year budget by:
FINAL BUDGET
8/31/2020 8:12 AM
8/31/2020
FY21
0.27%
2.0%
2.0%
3.80%
0.64%
0.78%
0.0%
9.89%
1.00%
0.00%
2.00%
0.0%
0.0%
12.40%
-0.78%
A-1
Okeechobee Utility Authority
FY21 Budget
Notes to the Budget Summary of Sources & Uses Funds Statement (Pages A4 -A6)
Page
Line
8/31/2020
A 4
7
General Utility Operating Revenue not including incremental
$ 9,855,211
revenue from the FY10 & FY11 rate increases shown below:
10
totals as is shown in Expenditures Summary C-2 lines 5
through 24.
$ 7,911,516
A-4
46
The Incremental Rate Revenue from both the FY10 and FY11
rate increases is shown separately under Other Sources of
Funds and is projected to total:
$ 919,512
Total operating revenue is greater than the previous year's 3.80%
budgeted amount by:
$ 395,628
A 4
13
Total Operating Expenses is composed of five departmental
$ 1,739,448
A-4
10
totals as is shown in Expenditures Summary C-2 lines 5
through 24.
$ 7,911,516
Total operating expense (including labor) as presented is 4.27%
higher than the previous years' budgeted amount by:
$ 323,666
A 4
13
Senior Debt Service consists of both Truist series 2020A &
series 2020B Bank Loans.
$ 1,739,448
A-4
See Tab K for the detail for each debt issue.
Stabilization Funds in the amount of:
A-4
33 & 34
The remaining capital connection revenue in the amount of:
is derived from 25 new water and 12 wastewater capital
connection charges that are from projected in -fill.
(1)
$ 18,650
A-4 26
Annual Junior Debt Service consists of the SRF #1 loan:
As presented, the Budget projects utilization of Rate
A-4
11
Stabilization Funds in the amount of:
0
A-4 26
Annual Junior Debt Service consists of the SRF #1 loan:
$ 682,862
See Tab K pages K-3 for the detail on each indebtedness.
(1) Assumes Capital Connection Charges (CCC) and
Installation Fees stay at 75% discount levels. The
FY21 budget at 100% would have $93,025 greater
budgeted revenue from in -fill CCC and install fees..
FINAL BUDGET
A-2
8/31/2020 8:12 AM
Okeechobee Utility Authority
FY21 Budget
Notes to the Budget Summary of Sources & Uses Funds Statement (Pages A4 -A6)
Pa
Line
A 4
40
Total interest income revenue on restricted account balances
has been projected based on the extremely low current yields
$ 121,978
A-4
39
on qualified public funds accounts and with the expectation
that these low yield levels will likely continue through the
proposed budget cycle.
$ 18,194
A 4
40
Restricted revenues are credited to their respective fund
balances during the fiscal year. They are detailed in the Other
Sources of Funds section of the Budget Summary and for the
fiscal year total:
$ 121,978
A-5
93
Total Projected Fund Balances at September 30, 2020
$ 6,693,240
As presented, the Budget Summary anticipates that the
$ 17,890,852
A 4
45
portion of the projected additional revenue derived from both
the FY10 and FY11 rate increases that will be used for
current year SRF Debt Service totals:
$ 919,512
A-4
68
The remaining revenue will be transferred to the Rate
Stabilization Fund at year end:
$ 40,493
As presented the Budget projects utilization of Operating
A-4
62
Funds to increase the Emergency Reserve Fund to its
minimum requirement by adding funds in the amount of:
$ 6,547
A-5
93
Total Projected Fund Balances at September 30, 2020
$ 6,693,240
See worksheet in section 0 for a detailed analysis of the
projected balances
$ 17,890,852
A-5 109
Projected Net Additions to Fund Balances From Transfers in FY20
$ 562,875
$ 17,890,852
This amount represents the expected transfers to the
individual funds as further detailed in the worksheet in tab O.
Proposed capital expenditures are found listed in Tab D,
sheet D-2 and Tab 0
A-6
157
Proposed Capital Improvement Project and departmental capital
request expenditures for FY21 total:
$ 17,890,852
Proposed capital expenditures are found listed in Tab D,
sheet D-2 and Tab 0
The proposed expenditures are not listed in any order of
priority.
A-6
176
FINAL BUDGET
Total Projected Fund Balances at September 30, 2021
$ 4,663,191
See worksheet in Tab 0 for a detailed analysis of the
projected balances
A-3
8/31/2020 8:12 AM
AIBICI D I E I F
G
H
1
2
3
4
5
Okeechobee Utility Authority
Water
2.00%
FY21 Budget
Sower
2.00%
Budget Summary
Sources & Uses of Funds Statement 8/31/2020
6
FUNDS FROM GENERAL UTILITY OPERATING REVENUE SOURCES:
FY21 Budget
7
General Utility Operating Revenue (Not including revenue Item FY10 & 11 rale increases)
9,855,211
B
FY10 & FY11 Rate Increase Revenue used for current SRF Debt Service
9
Total General Utility Operating Revenues
9,855,211
10
Total Operating Expenses
(7,911,516)
11
Funds needed from Rate Stabilization Fund
0
12
Net General Utility Operating Revenue (Available for Troia Bank Dem Service)
1,943,695
13
Total Trulst Bank Debt Service Payments and Budgeted DSC Ratio
(1,739,448)
111.7%
14
Remaining General Utility Oper Revenue Available ter SRF Debt Service
204,247
15
FUNDS
PROVIDED FROM RESTRICTED REVENUE SOURCES:
16
Transfers
In From Restricted Funds to Meet SRF Debt Service:
17
Transfer
in From 10/20 WW CCC Fund
0
18
Transfer
in from RR&I Fund Surplus (See Tab 6, Jr els)
0
19
Transfer
In from Emergency Reserve Fund Surplus (see Tab F, cell els)
0
20
Transfer
In from Operating Reserve Fund Surplus (See Tab G. cell B16)
0
21
FY10
& FY11 Rate Increase Revenue used for current SRF Debt Service
919,512
22
1 Total Restricted Funds used for SRF Debt Service
919,512
23
Less
Senior Lien Coverage Factor at 10% (only utilized In DSC calculation)
(173,945)
24
Less
Junior Lien Coverage Factor at 20% (only utilized In DSC calculation)
25
Sub-Total
949,815
26
Total SRF Debt Payments and Budgeted DSC Ratio
(682,862)
139.1%
27
Sub-Total
266,952
28
29
Remaining General Operating Revenue and Funds from both Debt Coverage Ratios
440,097
30
31
OTHER
SOURCES OF FUNDS;
32
Restricted
Revenue:
33
Water
Capital Connection Charge Revenue From Infill
9,650
34
Wastewater
Captial Connection Charge Revenue From Infill
9,000
35
Water
Capital Connection Charge Revenue From 10/20 Developers
0
36
Wastewater
Capital Connection Charge Revenue-to/2e Developers
0
37
WW
Capital Connection Revenue(Indirectly Through Tax Certificate Process)
0
38
Fire
Hydrant Fund Fees
85,134
39
Restricted
Interest Income
18,194
40
Sub-Total Restricted Revenue
121,978
41
42
Incremental
Rate Revenue from FY10 8 FY11 Rate Increases:
43
Continuing
Revenue From FY10, 6% Rate Increase
568,185
44
Continuing
Revenue From FY11, 3.5% Rale Increase
351,328
45
Total Incremental Revenue from FY10 & FY11 Rate Increases
919,512
46
Amount earmarked towards current SRF Debt Service Payments
(919,512)
47
Subtotal
0
46
Funds Transferred 10 Future CIP, earmarked
0
49
Remaining Rate Increase Revenue
0
50
51
Total Funds Available far Required B. Discretionary Capital Transfers
562,875
52
53
Re
ufred
Capital Transfers:
54
�ransfer
Into Fire Hydrant Fund
(85,134)
55
Transfer
of Interest Income Shown Above Into Respective Restricted Funds
(18,194)
56
Transfer
to Operating Reserve Fund (strive to maintain 90 days or D&M) see tab G
(22,903)
57
Transfer
Into Water CCC Fund (from Water in-fill Revenue)
(9,650)
58
Transfer
Into Water CCC Fund (from Water 10/20 Plan)
0
59
Transfer
Into WW CCC Fund (from WW in-fill Revenue)
(9,000)
60
Transfer
Into WW CCC Fund ((ram 10/20 Plan Alter SRF Debt Service Payments)
0
61
Transfer
Into RR&I Fund Bo be maintained at 5% el Prior Year System Revenue) see tab E
0
62
Transfer
Into Emergency Reserve Fund (ID be maintained at 30 days Oper Fzp) sea rob F
(6,547)
63
Total Funds Used for Required Capital Transfers
(151,427)
64
65
Discretionary Capital Transfers:
66
Transfer to Operating Reserve Fund (solve to maintain so days or 0&M)
0
67
Infer-fund Transfer to Future CIP
(370,954)
68
Interfund Transfer to Rate Stabilization Fund
(40,493)
69
70
Total Funds Used for Discretionary Capital Transfers
(411,447)
71
72
Total Funds Used for Required 8 Discretionary Capital Transfers
(562,875)
73
74
75
REMAINING
REVENUE FUNDS AVAILABLE FOR OTHER LAWFUL PURPOSES
0
A-4
AIBICI D
E F G H
76
FUNDING SOURCES:
FY21 Budget
77
Fund Balance at October 1, 2020 (Projected):
_
78
Restricted by Bond Covenants/Loan Documents:
79
RR&1 Fund (Must be maintained at 5% of Prior Year System Revenue)
529,073
80
Capital Connection Fund -Water
472,754
81
Capital Connection Fund -Sewer
276,629
82
Capital Connection Fund -Sewer 10/20 Plan (Restricted for W WTP DS)
448,441
83
Fire Hydrant Fund
227,315
84
Sub -Total
1,954,212
85
Restricted by Board Policy:
86
General Operating & Payroll & Account Funds
471,943
87
PTO Account Fund
234,500
86
Emergency Reserve Fund (Must be maintained at 30 day Oper Exp.)
640,925
89
Operating Reserve Fund (Strive for90 Days of Oper Exp)
1,919,557
90
Future CIP Funding(Sbive b maintain at 6% of Prior Year System Revenue)
251,860
91
Rate Stabilization Fund
1,220,244
92
Sub -Total
4,739,029
93
Total Fund Balance at October 1, 2020 (Projected)
6,693,240
—
94
95
Changes
to Fund Balance (From Transfers Projected for FY21):
_
96
Transfer into RR&I Fund (Must be maintained at 5% of Prior Year System Revenue)
0
97
Transfer into CCC Fund -Water (from in -fill)
9,650
98
Transfer into CCC Fund -Water (from 10/20 Plan)
0
g9
Transfer into CCC Fund -Sewer (from in -fill)
9,000
100
Transfer into CCC Fund -Sewer 10/20 Plan
0
101
Transfer into Fire Hydrant Fund
85,134
102
Transfer into PTO Account Fund (Net of withdrawals)
0
103
Transfer into Emergency Reserve Fund (Must be maintained at so days Oper Exp)
6,547
104
Transfer into Operating Reserve Fund (Strive In maintain at ea days of 0 & M)
22,903
105
Transfer into Future CIP Funding(Smve to maintain at 6% of Prior Year Gross Rev)
370,954
106
Transfer into Discretionary Rate Stabilization Funds
40,493
107
Transfer Into Future CIP Fund Earmarked:
0
108
Transfers into Restricted Accounts from Interest Income
18,194
109
Total Additions Into Fund Balance (From Transfers In FY21)
562,875
110
111
Total Fund Balances (Projected)
7,256,115
112
Funding
Sources for Proposed Construction Project Expenditures:
113
Advanced Meterinfrastructure Project In Buckhead
100,000
114
State Grant for Lakeview Estates WWTF
0
115
State Grants for SW Section WW (Septic to Sewer Project)
6,771,795
116
Funding from Loans to be Obtained for SW Section WW (Septic to Sewer Project)
6,926,133
117
Pine Ridge Park Wastewater State Grant
1,500,000
118
Total Funding Sources from Grants & Loans
15,297,928
119
TOTAL FUNDS AVAILABLE FOR CAPITAL EXPENDITURES & FUND BALANCES
22,554,043
120
A-5
AIBICI D
E 1 F I G 1 H
121
PROPOSED CAPITAL EXPENDITURES DURING FY21:
FY21 Budget
122
Funds
from Rate Stabilization Fund used as Operating Revenue
Pine Ridge Park wastewater
0
123
1,689,000
124
SW Section WW Project (septic to sewer project)
13,601,030
125
AMI Meter Installation project in Backhand 8 SW
335,762
126
Capital Improvement Project Expenditures (primarily grantiloan funded)
15,625,792
127
128
Pine Ridge Park water (appropriated in FY20 budget amendment R1)
0
129
Generators Replacement -Vac Station #2 8 WWTP
210,000
130
SE 28th St Water Main Install
275,000
131
FLDOT: US441 SE @ SE 15th Terrace (TCI) traffic circle
0
132
Sub -total
485,000
133
CIP Expenditures and Maintenance & Rehab Proposed for FY21:
134
LIft Station Pump Replacements
32,000
135
Scade System
25,000
136
Gravity Sewer Repair & Rehabilitation
50,000
137
Generator -Lift Stations
50,000
138
Lift Station Rehabilitations NW18; 5W13; 8 NE2
50,000
139
Vacuum Pump Replacement
25,000
140
Water Main Installation (System Wide)
150,000
141
Water Main Repair & Replacement (System Wide)
150,000
_
142
Manhole Rehabilitations (30 x $2,400 each)
72,000
143
Lift Station Electrical Panels - 7 Stations
110,000
144
Fire Hydrant Replacements (nominal)
25,000
145
Water main relocation 441SE
95,000
146
Sub -total
834,000
147
Total Proposed Capital Improvement Project Expenditures
1,319,000
148
149
Proposed Departmental Capital Expenditures: (Detail on D-1)
150
Administration (water/wastewater master plans & admin office restoration)
700,000
151
Maintenance
93,195
152
Water
26,365
153
Wastewater
126,500
154
Meter
0
155
Total Proposed Departmental Capital Expenditures
946,060
156
157
Grand Total of Proposed Capital Funds Expenditures
17,890,952
158
159
PROJECTED RESERVES END OF FISCAL YEAR
160
Fund
Balance Reserves at September 30, 2021 (Projected):
161
Restricted by Band Covenants/Loan Documents:
162
RR&I Fund (Must be maintained at 5% of PrioryearSystem Revenue)
531,413
163
Capital Connection Charge Fund -Water
7,404
164
Capital Connection Charge Fund -Sewer
96,629
165
Capital Connection Charge Fund -Sewer 10/20 Plan (Resmued for wwrP Ds)
81,941
166
Fire Hydrant Fund
287,449
167
Sub Total
1,004,836
168
Restricted by Board Policy & General Operating Funds
169
General Operating & Payroll Account Funds
59,224
170
PTO Account Fund
234,500
171
Emergency Reserve Fund (Must be maintained at 30 day Oper Exp.)
643,715
172
Operating Reserve Fund (Strive for90 Days of Oper Exp)
1,927,882
173
Future CFP Funding(smve to maintain at 3% of Prior Year System Revenue)
17,052
174
Rate Stabilization Fund
775,982
175
Sub -Total
3,658,355
176
Fund Balance Reserves at September 30, 2021 (Projected)
4,663,191
177
178
TOTAL PROPOSED CAPITAL EXPENDITURES AND FUND BALANCES
22,554,043
179
180
REMAINING FUNDS
50
A-6
184
AIBICI D 1 E I F 1 G 1 H
185
Okeechobee Utility Authority
FY21 Budget
Budget Summary
Debt Service Coverage Tests
186
187
8/3112020
188
189
190
Senior Lien Debt Service Coverage Analysis (110%Required)
191
192
General Utility Operating Revenue Oine 9 above)
9,655,211
193
LessTatal Oper Exp (line 8 above)
(7,911,516)
194
Funds needed from Rate Stabilization Fund
0
195
Net General Utility Operating Revenue
1,943,695
196
197
Total Current Year Operating Revenue for Senior Lien Coverage Test
1,943,695
19B
199
Senior Lien Debt Service
(1,739,448)
111.7%
200
201
Remaining General Utility Oper Rev After Truist Bank Debt Service
204 247
202
203
Senior Lien Coverage
204
205
Junior Lien Debt Coverage Analysis (115% for SRF)_(120% Tar RSF)
FOR SRF
COVERAGE
206
207
Remaining General Utility Oper Revenue After Truist Bank Debt Service
204,247
208
Less Senior Lien Coverage Factor at 10%
(173,945)
209
Less Junior Lien Coverage Factor at 20%
210
Less Incremental Rate Revenue from FY106 FY11 rate Increases added above
919,512
211
Available Revenue for Junior Lien DSC Calculation (compared to line 216)
949,815
139.1%
212
213
Note: Junior Lien Revenue Requirement to satisfy SRF Coverage at 115%
SRF (Junior Lien) Debt Service
Dollars required to satisfy Junior Lien Coverage for SRF per Board Policy of 120%
Total Operating Funds required to meet SRF debt coverage ratio
102 429
214
215
682 862
216
136 572
217
819,435
218
102,429 A-7
219
Note: Junior Lien Revenue Requirement to satisfy SRF Coverage at 115% is:
Okeechobee Utility Authority
FY21 Budget
Notes to Revenue Summary
Pane
Line
8/31/2020
B-2
8 to 12
Grand Total Operating Revenue is composed of five classifications of
operating income shown in Revenue Summary tab B2 lines 8 through 12.
10,774,723
B-3
18
Total Water Utility Revenue
6,558,005
B-3
15
Total water utility revenue above includes the ongoing effect from the FY10 6.0%
rate increase with projected incremental water utility revenue totaling:
349,744
B-3
16
Also, total water utility revenue includes the ongoing effect from the FY11 3.5%
rate increase with projected incremental water utility revenue totaling:
216,259
FY21 water utility revenue has been projected utilizing OUA's budgeted
revenues for 4-1-20 to 9-30-20 and actual revenues for 10-1-19 to 3-31-20
B-3
29
Total Sewer Utility Revenue
4,033,986
13-3
26
Total sewer utility revenue above includes the ongoing effect from the FY10 6.0%
rate increase with projected incremental sewer utility revenue totaling:
218,440
B-3
27
Also, total sewer utility revenue includes the ongoing effect from the FY11 3.5%
rate increase with projected incremental sewer utility revenue totaling:
135,069
FY21 water utility revenue has been projected utilizing OUA's budgeted
revenues for4-1-20 to 9-30-20 and actual revenues for 10-1-19 to 3-31-20
B-3
31
Penalties & Late Charges
117,408
B-4
62
Total Capital Connection Charges
18,650
As previously noted, the growth rate in new capital connections from in -fill is
projected at approximately:
0.27%
FINAL BUDGET 8/31/2020 8:13 AM
B-1
A
G
H
J
K
1
2
3
5
6
7
Okeechobee Utility Authority
FY21 Budget
Revenue Summary
Operating Revenue:
FY20
Budget
8
Total Water Utility Revenue (see B-3 Line 18)
6,289,975
9
Total Sewer Utility Revenue (see 6-3 Line 29)
3,853,685
10
Penalties & Late Charges (see B-3 Line 31)
110,750
11
Miscellaneous Revenue (see B-3 Line 33)
48,624
12
Total Other Operating Revenue (see B-3 Line 38)
77,199
13
Grand Total Operating Revenue (see B-3 Line 40)
10,380,233
14
15
Non -Operating Revenue:
16
Gain/Loss Sale of Fixed Assets (see B-4 Line 43)
0
17
Fire Hydrant Fund Fees (see B-4 Line 45)
83,996
18
Total Restricted Interest (see 6-4 Line 56)
65,821
19
Total CCC Revenue (Direct) (see B-4 Line 62)
168,315
22
Rate Stabilization Fund Transfer (see B-4 Line 71)
75,000
23
Grand Total Non -Operating Revenue (see 8-4 Line 72)
393,132
24
25
Grants, Loans & CIP Funding:
26
Internal Funding for CIP & Departmental Capital Expenditures
3,638,831
27
Internal Funding (Rate Stabilization Fund) for SRF Debt Service +
funding for Operating Reserve and for Emergency Reserve Funds
0
28
External Funding for Construction Projects
15,067,836
29
Total Grants, Loans & CIP Funding (see B-4 Line 80)
18,706,667
30
31
GRAND TOTAL REVENUE (see B-4 Line 82)
29,480,032
32
33
2.00%
2.00%
8/31/2020
FY21
Budget
6,558,005
4,033,986
117,408
39,330
25,995
10,774,723
0
85,134
18,194
18,650
0
121,978
4,289,822
0
15,297,928
19,587,750
30,484,451
B-2
FINAL BUDGET
8/31/2020 8:13 AM
A
H
N
0
P
1
Okeechobee Utility Authority
8/31/2020
2
FY21 Budget
3
Revenue Detail
4
FINAL
FY20
FY21
5
(1) revenue budget assumes capital connection charges and
related installation fees will remain at 75% discount levels.
Budget
Budget
6
(2) interest income from restricted funds on page B-4 is
inconsequential and is included in operating interest icome
Amount
Amount
7
OPERATING REVENUE
8
Water Utility Revenue
5,579,713
5,829,071
9
Water AGRC Revenue (from in -fill connections)
6,250
6,250
(1)
10
WaterGRC Revenue
25,216
17,480
11
Install Fees Water
6,250
6,375
(1)
12
Private Fire Protection
68,166
70,685
13
Turn On/Off Fees
48,854
47,606
14
Other Revenue Water
13,736
14,535
15
Incremental Water Rev From 6.0% Rate Increase in FY -10
334,783
349,744
16
Incremental Water Rev From 3.5% Rate Increase in FY -11
207,007
216,259
17
0
0
18
Total Water Utility Revenue
6,289,975
6,558,005
19
20
Wastewater Utility Revenue
3,474,053
3,640,674
21
Wastewater AGRC Revenue (from in -fill connections)
6,000
6,000
(1)
22
Wastewater GRC Revenue
8,114
14,646
23
Install Fees Wastewater
6,000
6,120
(1)
24
Kings Bay Wastewater Maintenance Fee
11,612
11,022
25
Other Revenue Wastewater
10,576
2,014
26
Incremental Wastewater Rev From 6.0% Rate Increase in FY -10
208,443
218,440
27
Incremental Wastewater Rev From 3.5% Rate Increase in FY -11
128,887
135,069
29
Total Wastewater Utility Revenue
3,853,685
4,033,986
30
31
Penalties & Late Charges
110,750
117,408
32
33
Miscellaneous Revenue
48,624
39,330
34
35
Interest Operating Account
76,804
25,523
37
Interest Payroll Account
395
472
38
Total Unrestricted Interest Revenue
77,199
25,995
39
40
GRAND TOTAL FROM OPERATING REVENUE
10,380,233
10,774,723
41
A
H
N
0
P
1
Okeechobee Utility Authority
8/3112020
2
FY21 Budget
3
Revenue Detail
4
FINAL
FY20
FY21
5
(1) revenue budget assumes capital connection charges and
related installation fees will remain at 75% discount levels.
Budget
Budget
42
NON-OPERATING REVENUE
Amount
Amount
43
Gain/Loss Sale of Fixed Asset
0
0
44
45
Fire Hydrant Fund Fees
83,996
85,134
46
47
Interest-Water CCC Fund
0
(2)
0
48
Interest-Wastewater CCC Fund
0
(2)
0
49
Interest-CCC WWTP Expansion Fund
0
(2)
0
50
Interest-RR&I Funding Required
10,000
2,340
51
Interest-Fire Hydrant Fund
0
(2)
0
52
Interest-Future CIP Funding
0
(2)
0
53
Interest-Rate Stabilization Fund & Debt Service Fund
16,771
4,739
54
Interest-Operating Reserve Fund (90 day O&M) accrued
26,650
8,325
55
Interest-Emergency Reserve Fund (30 day O&M) accrued
12,400
2,790
56
Total Restricted Interest
65,821
18,194
57
58
Water CCC from in-fill
9,450
9,650
(1)
59
Wastewater CCC from in-fill
8,808
9,000
(1)
60
Water CCC from 10/20 Plan (Net assessment received from developer)
0
0
61
WWTP CCC 10/20 Plan (Net assessment received from developer)
150,057
0
62
Total Water & WW CCC Revenue (Direct)
168,315
18,650
70
71
Internal Funding from Rate Stabilization Fund
75,000
0
72
GRAND TOTAL NON-OPERATING REVENUE
393,132
121,978
73
74
GRANTS, LOANS & CIP FUNDING
75
Internal Funding for CIP Expenditures
2,800,081
3,343,762
76
Internal Funding for SRF Debt Service (from Restricted Funds)
0
0
77
Internal Funding for Departmental Capital Expenditures
838,750
946,060
78
External Funding-State Programs
1,523,867
8,371,795
79
External Funding from loans/grants to obtain
13,543,969
6,926,133
80
GRAND TOTAL GRANTS & INTERNAL FUNDING
18,706,667
19,587,750
81
82
GRAND TOTAL SOURCES OF FUNDS
29,480,032
30,484,451
Okeechobee Utility Authority
FY21 Budget
Notes to Operating Expense Summary:
Page Line
8/31/2020
C-2
26
Total Departmental Operating Expense:
$7,911,516
Total Operating expense (including labor) as presented is higher 4.27%
than the previous years budgeted amount by:
$323,666
C-4 to
C-17
In the detailed expense listing shown on pages C-4 through C-17,
most expense classifications have been assigned a budgetary
value based on either a specific contract amount or an analysis of
the current year to date operating expenses projected to year end.
However, several selected O&M expense classifications in each
department have been historically subject to market fluctuations.
Examples are electrical, chemical and fuel, gas, diesel and
petroleum.
Electrical expenses are assigned a specific budgetary value or an
adjusted amount based on a projected inflation factor of.
0.64%
Chemicals are assigned a specific budgetary value or an adjusted
amount based on a percent change FY20 budget
0/8%
Fuel, gas, diesel & general petroleum based commodities have
been assigned a specific budgetary value or an adjusted amount
based on a percent change from FY20 budget:
0.00%
Many other expense classifications have been assigned a specific
budgetary amount for an increase of:
9.89%
C-1
FINAL BUDGET 8/31/2020 8:13 AM
G
1
2
3
4
5
Okeechobee Utility Authority
FY21 Budget
Expenditures Summary
Operating Expenses
6
7
Admin/Exec. Labor, (includes $27,851 for Urgent Care Services)
Admin/Exec. 0 & M
8
Total Administration / Executive Expenses
9
10
11
12
Maintenance Labor
Maintenance 0 & M
Total Maintenance Expenses
13
14
15
Water Labor
Water 0 & M
16
Total Water Expenses
17
18
19
Wastewater Labor
Wastewater 0 & M
20
Total Wastewater Expenses
21
22
23
24
Meter Labor
Meter O & M
Total Meter Reader Expenses
25
26
Grand Total Operating Expenses
27
28
Non -Operating Expenses
29
Debt Service Interest Expense
30
Amortization Expense
31
Depreciation Expense
32
Grand Total Non -Operating Expenses
33
34
Transfers
35
36
37
38
39
Debt Service Principal Payments
Required Transfers to Restricted Revenue Funds
Required Transfers Into Funds from Pledged Revenue net of Junior Debt Service
Discretionary Transfers From Restricted Funds
Other Transfers
40
Grand Total Transfers
41
42
GRAND TOTAL EXPENDITURES
43
44
FY20
Budget
1,158, 562
962,354
2,120,916
1,392, 399
1,070, 850
2,463,249
598,068
1,030,037
1,628,105
615,578
491,430
1,107,008
233,768
34,804
268,572
7,587,850
531,775
22,200
2,660,000
3,213,975
1,885,391
168,467
150,058
403,441
18,706,667
21,314,023
32,115,848
GRAND TOTAL EXPENDITURES WITHOUT
NON-CASH AMORTIZATION & DEPRECIATION EXPENSE 29,433,648
8/31/2020
FY21
Budget
1,170, 981
1,075,598
2,246,579
1,370,234
1,072,350
2,442,584
602,750
1,041,085
1,643,835
594,347
725,830
1,320,177
228,727
29,614
258,341
7,911,516
394,167
22,200
2,660,000
3,076,367
2,028,143
121,978
0
440,897
19,587,750
22,178,768
33,166,651
30,484,451
C-2
FINAL BUDGET 8/31/2020 8:14 AM
A I 8 I D 1 E1 L
1
Okeechobee Utility Authority
8/31/2020
2
FY21 Budget
Operating Expense Summary by Department
3
4
FY20
Budget
Department Amount
5
FY21
Budget
Amount
6
7
a
Summary Labor: Administration 1,158,562
1,170,981
9
Maintenance 1,392,399
1,370,234
10
Water 598,068
602,750
11
Wastewater 615,578
594,347
12
Meter 233,768
228,727
13
Total Labor 3,998,375
3,967,039
14
15
16
Summary 0 & M: Administration 962,354
1,075,598
17
Maintenance 1,070,850
_ 1,072,350
18
Water 1,030,037
1,041,085
19
Wastewater 491,430
725,830
20
Meter 34,804
29,614
21
Total 0 & M 3,589,475
3,944,477
22
23
24
25
Summary Dept Total: Administration 2,120,916
2,246,579
26
Maintenance 2,463,249
2,442,584
27
Water 1,628,105
1,643,835
28
Wastewater 1,107,008
1,320,177
29
Meter 268,572
258,341
30
Total Department Expenses 7,587,850
7,911,516
31
32
33
34
35
FY21 Operating Expense Budget higher than Final FY20 323,666
36
Percent change 4.27%
37
38
39
A 1 B 1 D J E J L
40
Okeechobee Utility Authority
41
FY21 Budget 8/31/2020
42
Operating Expense Detail by Department and Account
43
44
FY20
FY21
45
Administration Labor: Budget
Budget
46
Account Number Account Description Amount
Amount
47
401-3-513-1100-100 Executive Salaries 307,953
313,718
46
401-3-513-1101-100 Supervisor & retired empl rehire salaries 134,102
136,677
49
401-3-513-1200-100 Regular Salaries 361,667
375,696
50
401-3-513-1201-100 On Call non -pension admin 0
0
51
401-3-513-1202-100 Bonus Pay Admin 0
0
52
401-3-513-1300-100 Accrued Payout PTO (cash payments) 14,849
15,320
53
401-3-513-1400-100 Overtime 7,485
7,412
54
401-3-513-1600-100 Accured Wages and FICA 0
0
55
401-3-513-1610-100 Accrued Benefits & FICA (vacation/sick) 0
0
56
401-3-513-2100-100 FICA 63,193
64,935
57
401-3-513-2200-100 Retirement 103,977
92,292
58
401-3-513-2300-100 Health Insurance 126,000
126,000
59
401-3-513-2301-100 Disability Insurance 2,840
2,605
60
401-3-513-2302-100 Life Insurance 3,060
3,060
61
401-3-513-2400-100 Workmens Compensation 2,085
1,914
62
401-3-513-2500-100 Unemployment Compensation 0
0
63
401-3-513-3400-213 Urgent Care Services 27,851
27,851
64
401-3-513-2400-101 COLA Increase 0
0
65
401-3-513-1620-100 Accrued OPEB 3,500
3,500
66
401-3-513-1201-102 Janitorial Services 0
0
67
Employee Bonus 0
0
66
Health ins increase 0
0
69
70
Admin Labor Subtotal 1,158,562
1,170,981
71
72
A
I B
D I E
L
73
Account Description
FY20
Budget
Amount
FY21
Budget
Amount
74
Administration O&M:
75
Account Number
401-3-513-5100-101
76
Office Equipment
3,350
_
3,350
77
401-3-513-4905-201
Collection Agency Expense
0
750
78
401-3-513-3100-200
Legal Service -General Counsel
35,000
35,000
79
401-3-513-3100-202
Legal Serv-Dev Matters -Other
1,500
1,500
so
401-3-513-3100-203
Legal Serv-Easement Matters
2,500
2,500
e1
401-3-513-3100-204
Legal Serv-EEOC
0
82
401-3-513-3100-205
Legal Serv-Dev Matters -Royal
0
83
401-3-513-3100-206
Legal Serv-Dev Matters-CIB Marine(LVA)
0
84
401-3-513-3100-207
Legal Serv-Dev Matters- (Freshwater)
0
as
401-3-513-3100-208
Board Meeting Compensation ($250 x 12)
0
0
86
401-3-513-3100-204
Legal Serv-Land Trust v OUA
25,000
0-
87
401-3-513-3101-200
Engineering Fees
25,000
25,000
ea
401-3-513-3101-201
Eng Fees -Water General
5,000
5,000
as
401-3-513-3101-202
Eng Fees -Water Quality Improv.
30,000
30,00C
so
401-3-513-3101-203
Eng Fees -WW General
10,000
10,000
91
401-3-513-3200-200
Accounting & Auditing
25,000
30,000
92
401-3-513-3400-200
Other contract serv(surveys, 1095C, Misc)
20,000
20,000
93
401-3-513-3400-201
Utility Sery Co (Moved to Water Dept)
0
94
401-3-513-3400-202
Financial Advisor
2,500
2,500
95
401-3-513-3400-203
PRMG-Consultant Services
15,000 -
25,000
se
401-3-513-3400-204
CAS & Assoc -Legislative Sery
36,000
36,000
97
401-3-513-3400-205
Thorn Run -Legislative Sery
0
98
401-3-513-3400-206
One -Call Sery
6,500
6,500
99
401-3-513-3400-207
ADP -Payroll Services
24,500
24,500
100
401-3-513-3400-212
ADP -Easy Labor Management Fees
4,000
4,000
101
401-3-513-3400-208
Random Drug Program Costs
2,000
5,000
102
401-3-513-3400-210
Safety Matters -Consulting Serv&Supplies
3,000
3,000
103
401-3-513-3400-211
Pension Related Matters
5,000
3,500
104
401-3-513-3400-216
Bank Service Fee CSB
9,400
9,400
los
401-3-513-4000-100
Travel and Per Diem
2,000
2,000
106
401-3-513-4100-100
Communication Service
250 0
107
401-3-513-4100-101
Com Serv-Comcast
7,500
7,500
toe
401-3-513-4100-102
Com Serv-Verizon Cellular
1,000
1,000
los
401-3-513-4100-104
Com Serv-Reimbursements
1,500
1,500
110
401-3-513-4100-105
Com Serv-Ans Services
0
111
401-3-513-4100-106
SLERS Radio Service Fee (7x$9x12)
750
750
112
401-3-513-5208-101
COVID-19 Exp
0
25,000
113
401-3-513-4100-108
SLERS R&M -Admin
0 500
114
401-3-513-5215-100
Safety Supplies
1,750
1,750
115
401-3-513-4200-100
Postage and Transportation
45,000
45,000
11s
401-3-513-4300-100
Utilities -FPL
7,500
7,500
117
401-3-513-4301-100
Utilities Waste Management
1,400
1,500
A
B
1 D 1 E
L
118
Administration O&M:
Account Number
Account Description
FY20
Budget
Amount
FY21
Budget
Amount
119
120
121
401-3-513-4400-101
Pitney Bowes Post Mach Lease
1,100
1,100
122
401-3-513-4400-102
Copier Leases & Usage Costs
6,000
6,000
123
401-3-513-4500-200
Insurance -Prop, Cas & Gen Liab
330,000
335,000
124
401-3-513-4500-201
Insurance -Pollution Policy
14,944
14,944
125
401-3-513-4500-202
Insurance -Storage Tank Policy
2,000
1,644
126
401-3-513-4600-100
R&M Vehicles
1,500
1,500
127
401-3-513-4609-100
R&M Building Admin
10,000
25,000
126
401-3-513-4611-100
R&M Equipment
1,250
1,250
129
401-3-513-4612-100
R&M Comp Equipment
1,500
1,500
130
401-3-513-4613-100
R&M Comp Software (Springbrk)
35,000
35,000
131
401-3-513-4613-101
Comp Sys, HW/SW Upgrades & IT Sery
12,500
12,500
132
401-3-513-4613-102
IT Outsourced Services
9,000
9,000
133
401-3-513-4615-100
Lawn Service Admin
750
750
134
401-3-513-5208-101
Shrinkage Expense
0
0
135
401-3-513-4700-200
Printing and Binding
20,000
20,000
136
401-3-513-4901-100
Education-Springbrook & General
9,000
5,000
137
401-3-513-4902-200
Advertising
4,000
4,000
138
401-3-513-4902-201
Website/Webhosting Exp E -billing
2,000
2,000
139
401-3-513-4905-200
Bad Debt Expense
42,500
60,000
140
401-3-513-4909-100
Miscellaneous
15,500
23,000
141
401-3-513-5100-100
Office Supplies
8,500
8,500
142
401-3-513-5201-100
Fuel Gas & Diesel - Vehicles
2,160
2,160
143
401-3-513-5203-100
Uniforms
1,500
1,500
144401-3-513-5207-100
Tools
250
250
145
401-3-513-5208-100
Supplies Administration
2,500
10,000
146
401-3-513-5400-100
Books, Dues and Publications
10,000
10,000
147
401-3-513-6400-100
Capital Outlay Admin
0
27,500
148
401-3-513-9000-200
Contingencies
60,000
80,000
149
401-3-513-4908-100
Hurricane Expenditures
0
0
150
401-3-513-4907-100
Loan Cost of Issuance
0
0
151
Admin 0 & M Subtotal
962,354 1,075,598
152
Admin Dept Totals
2,120,916 2,246,579
A
1 B
I D I E
L
156
Maintenance Labor:
Account Number
Account Description
FY20
Budget
Amount
FY21
Budget
Amount
157
158
159
401-4-536-1101-100
Supervisor Salaries Maint
74,888
76,184
160
401-4-536-1200-100
Regular & retired employ rehired Salaries
820,804
817,082
161401-4-536-1201-100
non -pension
0
162
401-4-536-1201-101
On Call
12,588
12,465
163
401-4-536-1400-100
Overtime Maint
42,444
42,032
164
401-4-536-1600-100
Accured Wages and FICA Maint
0
0
165
401-4-536-1610-100
Accrued Benefits & FICA (vacation/sick)
0
0
166
401-4-536-2100-100
FICA Maint
73,996
73,779
167
401-4-536-2200-100
Retirement Maint
116,457
100,670
168
401-4-536-2300-100
Health Insurance Maint
176,400
176,400
169
401-4-536-2301-100
Disability Insurance Maint
3,159
2,824
170
401-4-536-2302-100
Life Insurance Maint
4,284
4,284
171
401-4-536-2400-100
Workmens Compensation Maint
47,331
44,345
172
401-4-536-2500-100
Unemployment Comp Maint
0
0
173
401-4-536-1300-100
Accrued Payout PTO (cash payments)
16,548
16,668
174
401-4-536-1202-100
Merit Increase-Maint
0
0
175
401-4-536-1620-100
Accrued OPEB Maint
3,500
3,500
176
177
Maintenance Labor Subtotal
1,392,399
1,370,234
178
179
180
181
182
183
184
185
186
187
188
189
190
A
1 6
1 D 1 E
L
194
Account Description
FY20
Budget
Amount
FY21
Budget
Amount
195
Maintenance O&M:
196
Account Number
197
401-4-536-4100-108
SLERS R&M Maintenance
0
1,000
198
199
401-4-536-3400-209
GPS Tracking
7,000
7,000
zoo
401-4-536-4000-100
Travel and Per Diem Maint
1,000
1,000
201
401-4-536-4100-101
Com Sery-Embarq/Comcast Maint
5,000
5,000
202
401-4-536-4100-102
Com Serv-Nextel Cellular Maint
1,500
1,500
203
401-4-536-4100-104
Com Serv-Reimbursements Maint
0
750
204
401-4-536-4100-300
Communications AirVac
1,250
1,250
205
401-4-536-4100-106
SLERS Radio Maint I-ee-Maint (31x$9x12)
3,500
3,500
206
401-4-513-4100-107
SLERS Tower Maint Fee-Maint (31x$9x12)
0
0
207
401-4-536-4200-100
Postage Transportation Maint
500
500
208
401-4-536-4300-100
Utilities -FPL Maintenance
5,500
5,500
zo9
401-4-536-4300-200
Utilities -FPL Pump Stations
55,000
55,000
210
401-4-536-4300-300
Utilities AirVac
41,000
46,000
211
401-4-536-4301-100
Utilities Waste Management Maint
3,500
4,000
212
401-4-536-4301-101
Utilities Waste Mngmt-tipping fees
1,500
1,500
213
401-4-536-4400-100
Equipment Rental Maint
2,500
2,500
214
401-4-536-4600-100
R&M Vehicles Maint
32,500
40,000
215
401-4-536-4605-200
R&M Pump Stations
95,000
95,000
216
401-4-536-4605-201
R&M Pump Stations Electrical
20,000
20,000
217
401-4-536-4605-300
R&M Air Vac
85,000
100,000
218
401-4-536-4605-400
R&M Water Distribution Maint
125,000
110,000
219
401-4-536-4605-500
R&M Sewer Collection Maint
25,000
25,000
220
401-4-536-4605-600
R&M Kings Bay
7,500
7,500
221
401-4-536-4605-700
R&M SCADA
15,000
15,000
222
401-4-536-4609-100
R&M Building Maintenance
2,500
2,500
223
401-4-536-4611-100
R&M Equipment Maintenance
24,000
24,000
224
401-4-536-4611-200
R&M Equipment Pump Stations
10,000
5,000
225
401-4-536-4611-300
R&M Generators
27,500
20,000
750
226
401-4-536-4612-100
R&M Computer Equipment Maint
750
227
401-4-536-4613-100
R&M Computer Software Maint
500
500
228
401-4-536-4614-100
R&M Copier Usage Maint
1,000
1,000
229
401-4-536-4615-200
Lawn Sery Pump Stations
1,980
1,980
230
401-4-536-4615-300
Lawn Sery Air Vac
1,620
1,620
231
401-4-536-4616-100
Testing and Lab Service
5,000
5,000
232
401-4-536-4901-100
Education maint
6,250
6,250
233
401-4-536-4909-100
Miscellaneous Maint
1,000
1,000
234
401-4-536-4501-100
Small Equipment
2,500
2,500
235
401-4-536-5100-100
Office Supplies Maint
3,000
3,000
236
A
I B
1 D E
L
238
Account Description
Budget
Amount
Budget
Amount
239
Maintenance O&M:
zao
Account Number
241
401-4-536-5201-100
Fuel: Gas, Diesel - Vehicles
35,000
35,000
zaz
401-4-536-5202-100
Fuel Other Maint
7,500
7,500
243
401-4-536-5203-100
Uniforms Maint
6,500
7,000
244
401-4-536-5206-100
Meters and Meter Boxes
200,000
200,000
245
401-4-536-5207-100
Tools Maint
18,000
18,000
zas
401-4-536-5207-200
Tools Pump Stations
1,500
1,500
247
401-4-536-5207-300
Tools Air Vac
500
500
No
401-4-536-5207-400
Tools Water Dist Maint
500
1,000
249
401-4-536-5207-500
Tools Sewer Collection Maint
1,500
750
250
401-4-536-5207-600
Tools Kings Bay Maint
250
250
251
401-4-536-5208-100
Supplies Maint
12,500
12,500
z5z
401-4-536-5208-200
Supplies Pump Stations
2,500
1,000
253
401-4-536-5208-300
Supplies Air Vac
750
750
254
401-4-536-5208-400
Supplies Water Dist Maint
11,500
7,500
255
401-4-536-5208-500
Supplies Sewer Collection Main
3,000
2,500
256
401-4-536-5208-600
Supplies Kings Bay Maint
500
500
257
401-4-536-5209-200
Chemicals Pump Stations
105,000
105,000
258
401-4-536-5215-100
Safety Supplies
10,000
15,000
259
401-4-536-5400-100
Books, Dues and Publ Maint
500
500
2so
401-4-536-6400-100
Capital Outlay Maint
7,000
7,000
261
40'-4-536-9000-100
Contingency-Maint
25,000
25,000
zsz
401-4-536-9999-100
Return To Stock
0
0
263
264
Maintenance 0 & M Subtotal
1,070,850 1,072,350
265
Maintenance Dept Totals
2,463,249
2,442,584
267
268
269
270
271
272
273
A
1
B
D 1 E
L
274
Water Labor:
Account Number
Account Description
FY20
Budget
Amount
FY21
Budget
Amount
275
276
277
401-5-533-1101-100
Supervisor Salaries SWTP
46,663
47,792
278
401-5-533-1101-200
Supervisor Salaries GWTP
19,998
20,482
279
401-5-533-1200-100
Regular Salaries SWTP
279,992
287,743
280
401-5-533-1200-200
Regular Salaries GWTP
36,772
37,835
281
401-5-533-1300-100
Accrued PayoutSWTP
6,342
6,547
282
401-5-533-1300-200
Accrued Payout GWTP
0
0
28a
401-5-533-1201-103
Part Time Employee SWTP
0
0
284
401-5-533-1201-203
Part Time Employee GWTP
0
0
285
401-5-533-1202-100
Bonus Pay SWTP
0
0
286
401-5-533-1202-200
Bonus Pay GWTP
0
0
287
401-5-533-1400-100
Overtime SWTP
12,111
11,994
288
401-5-533-1400-200
Overtime GWTP
1,907
1,888
28s
401-5-533-1610-100
Accured Benefits and FICA SWTP
0
0
zso
401-5-533-1610-200
Accured Benefits and FICA GWTP
0
0
291
401-5-533-2500-100
Unemployment Comp SWTP
0
0
292
401-5-533-2500-200
Unemployment Comp GWTP
0
0
293
401-5-533-2100-100
FICA SWTP
26,509
27,148
294
401-5-533-2100-200
FICA GWTP
4,380
4,545
295
401-5-533-2200-100
Retirement SWTP
49,011
43,858
296
401-5-533-2200-200
Retirement GWTP
4,658
4,006
297
401-5-533-2300-100
Health Insurance SWTP
75,600
75,600
298
401-5-533-2300-200
Health Insurance GWTP
8,400
8,400
299
401-5-533-2301-100
Disability Insurance SWTP
1,252
1,162
300
401-5-533-2301-200
Disability Insurance GWTP
125
112
301
401-5-533-2302-100
Life Insurance SWTP
1,836
1,836
302
401-5-533-2302-200
Life Insurance GWTP
204
204
303
401-5-533-2400-100
Workmens Comp SWTP
18,099
17,505
304
401-5-533-2400-200
Workmens Comp GWTP
1,659
1,544
305
401-5-533-1600-100
Accured Wages and FICA SWTP
0
0
aos
401-5-533-1600-200
Accured Wages and FICA GWTP
0
0
307
401-5-533-1620-100
Accured OPEB SWTP
2,100
2,100
308
401-5-533-1620-200
Accured OPEB GWTP
450
450
309
Water Labor Subtotal
598,068
602,750
310
401-5-533-1201-101
On Call/NonPension SWTP
0
0
311
401-5-533-1201-201
On Call/NonPension GWTP
0
0
312
A
I B
1 D I E
L
316
Account Description
FY20
Budget
Amount
FY21
Budget
Amount
317
Water 0 & M:
Account Number
318
319
401-5-533-3400-201
American Tank / Elev Strg Tank RM
16,966
16,964
320
401-5-533-4100-108
SLERS R & M SWTP
0
0
321
401-5-533-4100-208
SLERS R & M GWTP
0
0
1,650
355
322
401-5-533-3400-209
GPS Tracking
1,650
350
323
401-5-533-4000-100
Travel and Per Diem SWTP
324
401-5-533-4000-200
Travel and Per Diem GWTP
150
150
325
401-5-533-4100-101
Com Serv-Embarq/Centurylink SWTP
4,500
4,500
326
401-5-533-4100-103
Com Serv-Sprint SWTP
175
175
327
401-5-533-4100-104
Com Serv-Reimburse. SWTP
650
650
328
401-5-533-4100-200
Communications GWTP
2,400
2,400
329
401-5-533-4100-106
SLERS Radio Maint Fee SWTP (5x$9x12)
540
540
330
401-5-533-4100-206
SLERS Radio Maint Fee GWTP((((((2x$9x12
216
216
331
401-5-533-4100-107
SLERS Tower Maint Fee SWTP (5x$9x12)
0
0
332
401-5-533-4100-207
SLERS Tower Maint Fee GWTP 2x$9x12)
0
0
333
401-5-533-4200-100
Postage Transportation SWTP
750
450
334
401-5-533-4200-200
Postage Transportation GWTP
0
0
335
401-5-533-4300-100
Utilities -FPL SWTP
165,000
165,000
336
401-5-533-4300-200
Utilities -FPL GWTP
40,000
40,000
338
401-5-533-4301-100
Utilities Waste Mgmt SWTP
3,000
3,600
339
401-5-533-4301-200
Utilities Waste Mgmt GWTP
650
650-
340
401-5-533-4400-100
Equipment Rental SWTP
1,000
2,250
341
401-5-533-4400-200
Equipment Rental GWTP
250
250
342
401-5-533-4600-100
R&M Vehicles SWTP
3,500
3,500-
,500343
343
401-5-533-4600-200
R&M Vehicles GWTP
0
0
344
401-5-533-4602-100
R&M SWTP
25,000
35,000
345
401-5-533-4602-200
R&M GWTP
7,500
7,500
346
401-5-533-4602-201
SWTP Backwash pond clean & diversion
0
0
348
401-5-533-4611-100
R&M Equ pment SWTP
100,000
100,000
349
401-5-533-4611-200
R&M Equipment GWTP
18,000
18,000
350
401-5-533-4611-201
R&M Generators GWTP
2,250
2,250
351
401-5-533-4612-100
R&M Computer Equip SWTP
1,500
1,500
352
401-5-533-4612-200
R&M Computer Equip GWTP
500
250
353
401-5-533-4613-100
R&M Computer Software SWTP
500
250
354
401-5-533-4613-200
R&M Computer Software GWTP
500
250
355
401-5-533-4615-100
Lawn Service SWTP
10,440
10,440
356
401-5-533-4615-200
Lawn Service GWTP
7,200
7,200
357
401-5-533-4615-700
Lawn Service PRP
900
900
358
401-5-533-4616-100
Testing and Lab Service SWTP
36,000
25,000
359
401-5-533-4616-200
Testing and Lab Service GWTP
500
500-
361
401-5-533-4619-100
C2i Annual Maintenance
7,500
8,500
362
401-5-533-4620-100
R&M Ozone Water System Inc. SWTP
40,000
42,250
363
401-5-533-4901-100
Education SWTP
2,500
1,500
364
401-5-533-4901-200
Education GWTP
500
250
365
401-5-533-4611-101
R&M Generator SWTP
15,000
15,000
A
I a
D
E
L
366
367
Water 0 & M:
Account Number
Description
Budget
Amount
Budget
Amount
368
369
401-5-533-4909-100
Miscellaneous SWTP
1,250
1,250
370
401-5-533-4909-200
Miscellaneous GWTP
500
500
371
401-5-533-4950-100
Permits SWTP
1,500
500
372
401-5-533-4950-200
Permits GWTP
1,500
500
373
401-5-533-5100-100
Office Supplies SWTP
1,500
1,500
374
401-5-533-5100-200
Office Supplies GWTP
350
350
375
401-5-533-5201-100
Fuel: Gas, Diesel - Vehicles SWTP
4,000
4,000
376
401-5-533-5201-200
Fuel: Gas, Diesel - Vehicles GWTP
500
500
377
401-5-533-5202-100
Fuel Other Equipment SWTP
8,500
8,500
378
401-5-533-5202-200
Fuel Other Equipment GWTP
3,250
3,250
379
401-5-533-5203-100
Uniforms SWTP
1,500
1,500
360
401-5-533-5203-200
Uniforms GWTP
400
250
381
401-5-533-5204-100
Lab Supplies SWTP
10,000
8,500
382
401-5-533-5204-200
Lab Supplies GWTP
1,250
1,250
383
401-5-533-5207-100
Tools SWTP
500
1,250
384
401-5-533-5207-200
Tools GWTP
250
250
385
401-5-533-5208-100
Supplies SWTP
2,500
2,500
386
401-5-533-5208-200
Supplies GWTP
500
500
387
401-5-533-5209-100
Chemicals SWTP
400,000
400,000
388
401-5-533-5209-200
Chemicals GWTP
20,000
20,000
389
401-5-533-5209-700
Chemicals PRP
0
0
390
401-5-533-5215-100
Safety suppliesSWTP
1,500
3,500
391401-5-533-5215-200
Safety suppliesGWTP
100
250
392
401-5-533-5400-100
Books, Dues and Pub SWTP
500
500
393
401-5-533-5400-200
Books, Dues and Pub GWTP
150
150
394
0
395
401-5-533-6400-100
Capital Outlay SWTP
0
10,000
396
401-5-533-6400-200
Capital Outlay GWTP
0
0
397
401-5-533-9000-100
Contingency -Water
50,000
50,000
398
Water O & M Subtotal
1,030,037
1,041,085
399
Water Dept Totals
1,628,105
1,643,835
A
I B
1 D I E
L
402
Account Description
FY20
Budget
Amount
FY21
Budget
Amount
403
Wastewater Labor:
a0a
Account Number
405
401-6-535-1101-100
Supervisor Salaries WW
68,415
69,710
aos
401-6-535-1200-100
Regular Salaries WW
346,489
336,583
407
401-6-535-1201-103
Part-time Salaries WW
0
0
408
401-6-535-1201-100
On Call WW wages
0
0
409
401-6-535-1202-100
Bonus Pay WW
0
0
410
401-6-535-1300-100
Accrued Payout WW
7,270
7,224
411
401-6-535-1400-100
Overtime WW
15,544
15,393
412
401-6-535-1600-100
Accured Wages and FICA WW
0
0
413
401-6-535-1610-100
Accured Benefits and FICA WW
0
0
414
401-6-535-2100-100
FICA WW
33,486
32,812
415
401-6-535-2200-100
Retirement WW
55,130
47,046
416
401-6-535-2300-100
Health Insurance WW
67,200
67,200
417
401-6-535-2301-100
Disability Insurance WW
1,368
1,200
418
401-6-535-2302-100
Life Insurance WW
1,632
1,632
419
401-6-535-2400-100
Workmens Compensation WW
16,744
13,246
420
401-6-535-1620-100
Accured OPEB WW
2,300 2,300
421
COLA Increase-WW
0
0
422
Merit Increase-WW
0
0
423
Employee Bonus-WW
0
0
424
Health Insurance Increase-WW
0
0
425
426
401-6-535-2500-100
Unemployment Comp WW
0
0
427
428
Wastewater Labor Subtotal
615,578
594,347
429
430
431
432
433
434
435
436
437
438
439
440
441
A
B
1 ID i E
L
444
Account Description
FY20
Budget
Amount
FY21
Budget
Amount
445
Wastewater 0 & M:
446
Account Number
447
401-6-535-3400-209
GPS Tracking
2,240
2,240
448
449
401-6-535-4000-100
Travel and Per Diem WW
750
750
450
401-6-535-4100-108
SLERS R&M WWTP
0
0
451
401-6-535-4100-101
Com Sery-Embarq/Centuyrylink WW
5,750
5,750
452
401-6-535-4100-104
Com Serv-Reimbursements WW
650
650
453
401-6-535-4100-106
SLERS Radio Maint Fee WW (10x$9x12)
1,080
1,080
454
401-6-535-4100-107
SLERS Tower Maint Fee WW 10x$9x12)
0
0
455401-6-535-4200-100
Postage Transportation WW
250
250
456
401-6-535-4300-100
Utilities WW
160,000
160,000
457
401-6-535-4300-200
Utilities LVTP
2,750
2,500
458
401-6-535-4300-300
Utilities OTTP
2,750
1,250
459
401-6-535-4300-400
Utilities ETP
2,250
2,250
46a
401-6-535-4300-500
Utilities KBTP
2,750
3,100
461
401-6-535-4300-700
Utilities PRPTP
500
0
462
401-6-535-4301-100
Utilities Waste Mgmt WW
6,250
6,250
463
401-6-535-4400-100
Equipment Rental WW
750
2,500
750
4,750
464
401-6-535-4600-100
R&M Vehicles WW
465
401-6-535-4602-100
R&M WWTP
24,000
36,000
466
401-6-535-4602-200
R&M Lakeview
2,500
2,500
467
401-6-535-4602-300
R&M OTTP
750
750
468
401-6-535-4602-400
R&M ETP
1,250
1,250
459
401-6-535-4602-500
R&M KB TP
1,250
1,250
470
401-6-535-4602-???
Sand Removal -Digesters & Clarifiers
0
218,559-
471
401-6-535-4609-100
R&M Building WWTP
3,500
3,500
472
401-6-535-4611-100
R&M Equipment WWTP
22,500
22,500
473
401-6-535-4611-200
R&M Equipment LVTP
500
1,500
474
401-6-535-4611-300
R&M Equipment OTTP
500
500
475
401-6-535-4611-400
R&M Equipment ETP
500
500
476
401-6-535-4611-500
R&M Equipment KBTP
1,500
1,500
477
401-6-535-4611-600
R&M Equipment PRTP
0
0
478
401-6-535-4612-100
R&M Computer & Office Equi. WW
1,750
1,750
479
401-6-535-4613-100
R&M Computer Software WW
3,500
3,500
480
401-6-535-4611-800
R&M Generators WWTP
0
0
481
401-6-535-4615-100
Lawn Service WWTP
13,500
13,500
482
401-6-535-4615-200
Lawn Service LVTP
900
900
483
401-6-535-4615-300
Lawn Service OTTP
1,800
1,800
484
401-6-535-4615-400
Lawn Service ETP
1,260
1,260-
,260485
485
401-6-535-4615-500
Lawn Service KBTP
0
0
486
401-6-535-4615-600
Lawn Service PRP TP
0
0
487
488
A
1 B
1 D 1 E
L
489
Wastewater 0 & M:
Account Number
Account Description
FY20
Budget
Amount
FY21
Budget
Amount
490
491
492
401-6-535-4616-100
Testing and Lab Service WWTP
28,000
28,000
493
401-6-535-4616-400
Testing and Lab Services ETP
1,250
1,250
494
401-6-535-4616-500
Testing and Lab Services KBTP
1,250 _
1,250
495
401-6-535-4616-700
Testing and Lab Services PRP
0
0
495
401-6-535-4617-100
Residual Management WWTP
35,000 _
45,000
497
401-6-535-4901-100
Education WW
2,000
2,000
498
401-6-535-4909-100
Misc WW
1,500
1,500
499
401-6-535-4950-100
Permits WW Cemetery Rd
12,000
7,500
500
401-6-535-4950-200
Permits LVTP
0
0
501
401-6-535-4950-300
Permits OTTP
0
0
502
401-6-535-4950-400
Permits ETP
0
0
503
401-6-535-4950-500
Permits KBTP
10,000
10,000
504
401-6-535-4950-600
Permits PRP
10,000
0
505
401-6-535-5100-100
Office Supplies WW
1,250
1,250
506
401-6-535-5201-100
Fuel: Gas, Diesel - Vehicles
6,000
6,000
507
401-6-535-5202-100
Fuel Other WW
7,500
7,500
508
401-6-535-5203-100
Uniforms WW
2,250
2,250
509
401-6-535-5204-100
Lab Supplies WW
3,500
3,500
510
401-6-535-5207-100
Tools WW
1,500
2,500
511
401-6-535-5208-100
Supplies WW
4,000
4,000
512
401-6-535-5209-100
Chemicals WWTP
45,000
51,500
513
401-6-535-5209-200
Chemicals LVTP
3,000
1,500
514
401-6-535-5209-300
Chemicals OTTP
2,250
1,750
515
401-6-535-5209-400
Chemicals ETP
2,000
2,000
516
401-6-535-5209-500
Chemicals KBTP
2,500
2,500
517
401-6-535-5209-600
Chemicals PRP TP
0
0
518
401-6-536-5215-100
Safety Supplies
1,500
3,000
519
401-6-535-5400-100
Books, Dues and Publications
500
500
520
401-6-535-6400-100
Capital Outlay WW
0
0
521
522
401-6-535-9000-100
Contingency-WW
35,000
35,000
523
Wastewater 0 & M Subtotal
491,430 725,830
524
Wastewater Dept Totals
1,107,008
1,320,177
529
530
A
I B
l D I E
L
531
Meter Labor:
Account Number
Account Description
FY20
Budget
Amount
FY21
Budget
Amount
532
533
534
401-7-513-1101-100
Supervisor Salaries MR
53,195
54,276
535
401-7-513-1200-100
Regular Salaries MR
89,848
91,597
536
401-7-513-1202-100
Bonus Pay
0
0
537
401-7-513-1300-100
Accrued Payout
2,642
2,722
538
401-7-513-1201-100
Non Pension wages MR
0
0
539
401-7-513-1201-102
Non -pension wages custodial services
9,970
5,087
540
401-7-513-1400-100
Overtime
2,247
2,225
541
401-7-513-1600-100
Accured Wages and FICA
0
0
542
401-7-513-1610-100
Accured Benefits and FICA
0
0
543
401-7-513-2100-100
FICA
12,080
11,927
544
401-7-513-2200-100
Retirement
20,015
17,727
545
401-7-513-2300-100
Health Insurance
33,600
33,600
546
401-7-513-2301-100
Disability Insurance
528
482
547
401-7-513-2302-100
Life Insurance
816
816
548
401-7-513-2400-100
Workmens Compensation
7,727
7,169
549
401-7-513-2500-100
Unemployment Comp MR
0
550
COLA Increase -Meter
0
0
551
Merit Increase -Meter
0
0
552
553
554
401-7-513-1620-100
Accrued OPEB MR
1,100
1,100
555
Meter Labor Subtotal
233,768
228,727
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
A
I B
I 0
L E
L
575
FY20
Budget
Amount
FY21
Budget
Amount
576
Meter 0 & M:
Account Number
Account Description
577
578
401-7-513-3400-209
GPS Tracking
2,240
1,750_
579
Backflow recalibration fees and repairs
0
800
569
401-7-513-4000-100
Travel and Per Diem
500
250
581
401-7-513-4200-100
Postage, Freight & Shipping MR
150
150
582
401-7-513-4200-100
SLERS Radio Maint Fee MR (8x$9x12)
0
0
sae
401-7-513-4100-106
SLERS Tower Maint Fee MR (8x$9x12)
864
864
584
401-7-513-4100-107
SLERS Tower Service Fee
0
0
585
401-7-513-4100-108
SLERS R&M
586
401-7-513-4600-100
R&M Vehicles
2,500
2,500
587
401-7-513-4611-100
R&M Meter Reading Equipment
4,500
3,500
588
401-7-513-4613-100
R&M Computer Software Sensus
3,500
3,500
sag
401-7-513-4618-100
R&M Meter and BackFlow Equip Testing
800
800
590401-7-513-4901-100
Education
500
500
591
401-7-513-5201-100
Fuel: Gas, Diesel - Vehicles
8,500
8,500
592
401-7-513-5203-100
Uniforms
750
750
593
401-7-513-5207-100
Tools
500
500
594401-7-513-5208-100
Supplies
2,500
1,750
595
401-7-513-5400-100
Books, Dues and Publications
500
500
596
401-7-513-6400-100
Capital Outlay
3,500
0
597
401-7-513-6399-100
Insect Services
2,500
2,500
598
401-7-513-5215-100
Safety
500
500
599
Meter 0 & M Subtotal
34,804
29,614
600
Meter Dept Totals
268,572
258,341
FINAL BUDGET
8/31/2020 10:49 AM C-18
B C D E F
G
H
1
Okeechobee Utility Authority
2
FY21 Budget
8/31/2020
3
NON-OPERATING EXPENDITURES AND TRANSFERS
4
5
FY20
FY21
6
Budget
Budget
7
NON-OPERATING EXPENSES:
Amount
Amount
8
Debt Service Interest Expense:
11
SRF 1 Interest Expense
107,472
96,720
12
SRF 2 Interest Expense
0
0
13
SRF Interest Expense
0
0
14
Truist Bank 2020A Interest Expense
169,320
114,229
15
Truist Bank 20203 Interest Expense
254,983
183,219
16
Total
531,775
394,167
11
18
Amortization Expense:
31
Amortize Organizational Costs
9,600
9,600
32
Amortize Long -Term Lease
12,600
12,600
33
Total
22,200
22,200
34
35
Depreciation Expense:
2,660,000
2,660,000
36
37
TOTAL NON-OPERATING EXPENSES
3,213,975
3,076,367
38
39
FINAL BUDGET
8/31/2020 10:49 AM C-18
FINAL BUDGET 8/31/2020 10:49 AM
C-19
B C D E
F
G
H
40
NON-OPERATING TRANSFERS:
FY20
FY21
41
Required Transfers:
42
Debt Service Principal Payment & Loan Fee Transfers:
45
SRF 1 Principal
575,391
586,143
46
SRF 2 Principal
0
0
52
Truist Bank 2020A Principal
1,150,000
1,292,000
53
Truist Bank 2020B Principal
160,000
150,000
54
Total
1,885,391
2,028,143
55
Unrestricted/Restricted Revenue Transfers to Restricted Accts:
56
Operating Reserve Fund
0
0
57
Restricted Interest to Restricted Accts.
65,821
18,194
58
Cap Conn Fund Water (infill)
9,650
9,650
59
Cap Conn Fund WW (infill)
9,000
9,000
61
Fire Hydrant Fund
83,996
85,134
62
Emergency Reserve Fund
0
0
63
Total
168,467
121,978
64
65
Pledged Restricted Revenue Transferred to Restricted Fund Acct:
66
Cap Conn Fund WWTP 10/20 (Direct)
150,058
0
68
Sub -Total
150,058
0
69
Less Amount Used Towards Junior Debt Service
0
0
70
Total
150,058
0
71
72
Discretionary Transfers -From Restricted Funds:
73
Net Transfer to Rate Stabilization Fund
403,441
$ 440,897
74
Funds Earmarked for
0
0
75
Future CIP Funding
0
0
76
Total
403,441
440,897
77
Other Transfers:
78
Internal Transfer for CIP Expenditures
2,800,081
1,319,000
79
Internal Transfer for Departmental Capital Expenditures
838,750
946,060
80
External Funding from State
15,067,836
15,297,928
81
Total
18,706,667
17,562,988
82
83
TOTAL NON-OPERATING EXPENDITURES AND TRANSFERS 24,527,998 0
23,230,373
FINAL BUDGET 8/31/2020 10:49 AM
C-19
D-1
FINAL BUDGET 8/31/2020 10:49 AM
A B C D
E F
G
1
Okeechobee Utility Authority
8/31/2020
2
FY21 Budget
3
Proposed Additional Departmental Capital Expenditures
4
1
'DEPARTMENT TOTALS
Operating
Capital
5
6
ADMINISTRATION
27,500
700,000
7
MAINTENANCE
0
93,195
8
WATER
10,000
26,365
9
WASTEWATER
0
126,500
10
METER
0
0
11
TOTALS
37,500
946,060
12
Administration
13
i
Water master plan
175,000
14
WasteWater master plan
175,000
15
Administration Office Restoration
350,000
16
17Springbrook
Online Payment Portal
15,500
18
I
I
Springbrook Training
12,000
19
1
20
1
Sub Total Administration
27,500
700,000
21
Maintenance
30
John Deere mini excavator
41,514
31
1
5 lift station mixers for Thioguard sites SE4, SW4, NE6, NE8, NW14
24,995
32
Replace blue pump with Thompson self -priming
trash pump
26,686
33
34
j
35
I
Sub Total Maintenance
0
93,195
36
Water
37
2020 Ford F-150 Super Cab 4x2 SWB
26,365
38
I
Shop roof and gutter
5,000
39
Sludge press air compressor
2,500
40
I
Sidewalk from parking lot
I
Sub Total Water
2,500
10,000
26,365
41
42
1
Wastewater
43
44
King's Bay Lift Station
20,000
45
Entrance road paving work
106,500
46
Sub Total Wastewater
0
126,500
47
Meter
48
49
50
1
51
I
52
I I
Sub Total Meter
0
0
D-1
FINAL BUDGET 8/31/2020 10:49 AM
AN C
J
K L ItN N I4 P CI R I 5 j T
1
Okeechobee Utility Authority
8/31/2020
2
FY21 Budget
3
Five Year Capital Improvement Plan Expenditure Detail
4
Total
5
FY20
FY21
FV22 FY23 FY24 FY25
FY20-FY25
6
Appropriated
7
WASTEWATER:
8
SCADA System
25,000
25,0001 25,000 25,000 25,000' 125,000
9
Generator- Lift Stations (General)
50,000
50,000 50,000 150,000
10
Generator Replacements totaling $21 Ok as follows:
210,000
210,000
11
Vac Station #2 150K Generator $125,000
12
1 WWTP Generator$60,000
13
Engineering to replace Vac Station 142 & W WTP $25,000
14
Gravity Sewer Repair & Rehabilitation
50,000
100,000 1 50,000 I 100,000
50,000 350,000
15
'Lift
Station Rehabilitations NW18; SW13; & NE2
50,000
100,000:, 50,000 100,000
50,000 350,000
16
Lift Station Electrical Panels - 7 Stations
110,000
110,000
17
Manhole Rehabs (30 x $2,400)
72,000
72,000
72,000
32,000
72,000
32,000
72,000
32,000
360,000
160,000
18
Lift Station Pump Replacements
32,000
32,000
19
Vacuum Pump Replacement
25,000
25,000
25,0001
25,000
25,000
125,000
20
WATER:
21
Water Main Installation (System Wide)
150,000
150,000
150,000
150,000
150,000
750,000
22
Water Main Repair & Replacement (System Wide)
150,000
150,000
150,000
25,0001
150,000
1 25,000
150,000
25,000
750,000
125,000
23
Fire Hydrant Installations & Replacements
25,000
25,000
24
Water main relocation 441SE
95,000
95,000
25
5E 28th St Water Main Installation
275,000
275,000
26
DEPARTMENTAL
CAPITAL REQUESTS:
27
Administration (See 0-1)
700,000
10,000
10,000
10,000
10,000
740,000
28
Maintenance (See 0-1)
93,195
50,000
50,000
50,000
50,000
293,195
29
Water (See 0-1)
26,365
50,000
50,000
50,000
50,000
226,365
30
Wastewater (See D-1)
126,500
25,000
25,0001
25,000
25,000
226,500
31
Meter Reader See D-1)
0
5,000
5,000,1
5,000
5,000
20,000
32
33
34
p
N
TOTAL
2,265,050
819,000
769,000
819,000
769,000
5,441,060
MAJOR PROJECTS
35
36
J Lakeview Estates: experimental WWTF Stale grant LP47012
1
1,000,000
-
1,000,000
37
Pine Ridge Park water OUA
426,950
426,950
482,600
38
[Pine Ridge Park wastewater OUA
293,600
189,000
39
Pine Ridge Park wastewater State Grant LP00017
-
1,500,000
1,500,000
40
I Total FY20 Appropriations
1,720,550
r-
2,409,550
41
42
43
Advanced Metering Infrastructure Loan to be Obtained
Advanced Metering Infrastructure a•reement with SFWMD
235,762
100,000
235,762
100,000
44
335,762
335,762
45
46
SW Wastewater Service Area 513,950,000
47
State Grant LPQ0008
102,072
5,897,928
1
6,000,000
48
Amendment to State Grant LP00008
500,000
500,000
49
State Grant (Septic to Sewer Project) L47021
150,000
373,867
I I
1
523,867
6,926,133
50
Loan to be obtained
51
I
13,950,000
52
53
FINAL BUDGET
8/31/2020 10:50 AM E-1
A
B
1
Okeechobee Utility Authority
2
FY21 Budget
8/31/2020
3
Analysis of RR&I Fund
4
Funding is required to be maintained at 5% of Previous Year System
5
Operating Revenue.
6
7
8
FY20 System Operating Revenue (Projected)
$10,380,233
9
10
FY21 Funding Required at 5% (Fund Balance Required)
519,012
11
12
Fund Balance at September 30, 2021 (Projected)
531,413
13
14
Fund Surplus (Deficit)
12,401
15
16
Funds to be Transferred Back for SRF Debt Payment
0
17
18
Remaining Fund Surplus
$12,401
19
20
FY21 Funding Budgeted
1
0
FINAL BUDGET
8/31/2020 10:50 AM E-1
FINAL BUDGET 8/31/2020 10:50 AM F-1
A
B
1
Okeechobee Utility Authority
2
FY21 Budget
8/31/2020
3
Analysis of Emergency Reserve Fund
4
5
(Maintained at 30 days of current year System 0 & M)
6
7
8
FY21 System Operating Expenses (Budgeted)
$7,911,516
9
10
FY21 30 Days 0 & M Expenses (Fund Balance Required)
650,262
11
12
Fund Balance at September 30, 2021 (Projected)
643,715
13
14
Fund Surplus (Deficit)
(6,547)
15
16
Funds to be Transferred Back for SRF Debt Payment
0
17
18
Remaining Fund Surplus (deficit)
($6,547)
19
20
FY21 Funding Budgeted projected to be $6,547
!
-
FINAL BUDGET 8/31/2020 10:50 AM F-1
FINAL BUDGET
8/31/2020 10:50 AM G-1
A
B
1
Okeechobee Utility Authority
2
FY21 Budget
0/31/2020
3
Analysis of Operating Reserve Fund
4
5
(Maintain at 90 days expenses of current year System 0 & M)
6
7
8
FY21 System Operating Expenses (Budgeted)
$7,911,516
9
10
FY21 90 Days 0 & M Expenses
1,950,785
11
12
Fund Balance at September 30, 2021 (Projected)
1,927,882
13
14
Fund Surplus (Shortage)
(22,903)
15
16
Funds to be Transferred Back for SRF Debt Payment
0
17
18
Remaining Fund Surplus (deficit)
(22,903)
19
20
FY21 Funding Budgeted projected to be $22,903
I
21
FINAL BUDGET
8/31/2020 10:50 AM G-1
Okeechobee Utility Authority
FY21 Budget
Analysis of Fire Hydrant Fund
The fire hydrant fund receives revenue of $ 0.50 per residential meter per
month.
Fund Balance at September 30, 2020 (Projected)
Budgeted Additional Revenue in FY21
Interest Earnings Added to Fund Balance (Projected)
Budgeted Hydrant Replacement Expenditures in FY21
Projects (TBD)
Projected Fire Hydrant Fund Balance at September 30, 2021
6/31/2020
$227,315
$85,134
$0
($25,000)
$0
$287,449
FINAL BUDGET 8/31/2020 10:58 AM H-1
Okeechobee Utility Authority
FY21 Budget
8/31/2020
Analysis of CIP Fund
Strive to Begin the Fiscal Year with a Fund balance of 6% of Projected
System Operating Revenue
FY21 System Operating Revenue (Projected)
$10,380,233
FY21 Funding Projected at 6%
$622,814
Fund Balance at September 30, 2020 (Projected)
251,860
Deficit to be Funded
$370,954
Remaining Fund Surplus
FY21 Funding Budgeted
$370,954
Okeechobee Utility Authority
Debt Service Summary
FYE
Ending
9/30/12
9/30/13
3/15/14
9/30/14
9/30/15
9/30/16
Totals
Truist D/S Sub Total
Int.
Prin.
811,949 1,005,000
782,014 1,035,000
SRF D/S Sub Total
Int.
Prin.
446,067 1,058,847
424,304 1,080,610
Principal prepayment
6,422,932
751,170
719,455
686,831
3,751,419
1,065,000
1,095,000
1,130,000
5,330,000
332,906 920,304
246,958 754,548
231,836 769,670
1,682,071 4,583,978
Last Updated
08/31/20
Total Annual
Debt Service
3/29/17
3/29/17
530,000
Refunded $19,425,000
9/30/17
9/30/18
9/30/19
4/1 //20
256,179
247,093
239,492
216,138
510,000
620,000
625,000
0
Truist Bank
4/1 //20
formerly BB&T
Refunded $16,390,000
9/30/20
9/30/21
9/30/22
9/30/23
9/30/24
9/30/25
9/30/26
9/30/27
9/30/28
9/30/29
9/30/30
Totals
158,456
297,448
271,087
244,143
216,616
188,506
159,029
127,254
94,556
60,885
26,445
712,000
1,442, 000
1,476,000
1,505,000
1,534,000
1,581,000
1,540,000
1,580, 000
1,635,000
1,670, 000
1,715,000
1,844,424 16,390,000
216,407
200,666
145,980
55,076
785,099
800,840
3,522,237
286,364
3,321,863
3,321,928
3,069,380
2,815,961
2,818,337
15,347,468
1,767,685
1,868,599
4,532,709
557,578
52,404 289,027 1,211,887
96,720 586,143 2,422,310
85,767 597,096 2,429,950
74,609 608,253 2,432,006
63,243 619,619 2,433,479
51,665 631,198 2,452,368
39,870 642,993 2,381,891
27,854 655,008 2,390,116
15,615 667,248 2,412,419
3,146 338,285 2,072,316
0 0 1,741,445
510,892
R/07nn')n G.Gc DIU
5,634,870 24,380,186
K-1
Okeechobee Utility Authority
ebt Service Summary - Truist Bank Debt
FYE
Truist 2020A
Ending Int. 1.79% Prin.
Refunded $16,390,000 on 4/1/2020
9/30/2020
4/1/2021
9/30/2021
4/1/2022
9/30/2022
4/1/2023
9/30/2023
4/1/2024
9/30/2024
4/1/2025
9/30/2025
4/1/2026
9/30/2026
4/1/2027
9/30/2027
4/1/2028
9/30/2028
4/1/2029
9/30/2029
4/1/2030
9/30/2030
65,693.00
59,991.85
54,237.00
48,428.45
42, 566.20
36,650.25
30,680.60
24,657.25
18,580.20
12,449.45
6,265.00
637,000.00
643,000.00
649,000.00
655,000.00
661,000.00
667,000.00
673,000.00
679, 000.00
685,000.00
691,000.00
700,000.00
400,199.25 7,340,000.00
Truist 2020B
Int. 2.05% I Prin.
Last Updated
08/31/20
Truist Total
Debt Service
92,762.50
75,000.00
870,455.50
91,993.75
75,000.00
869,985.60
91,225.00
75,000.00
869,462.00
90,456.25
80,000.00
873,884.70
89,636.25
80,000.00
873,202.45
88,816.25
80,000.00
872,466.50
87,996.25
85,000.00
876,676.85
87,125.00
85,000.00
875,782.25
86,253.75
85,000.00
874,833.95
85,382.50
95,000.00
883,831.95
84,408.75
95,000.00
885,673.75
83,435.00
765,000.00
848,435.00
75,593.75
775,000.00
850,593.75
67,650.00
785,000.00
852,650.00
59,603.75
795,000.00
854,603.75
51,455.00
815,000.00
866,455.00
43,101.25
820,000.00
863,101.25
34,696.25
830,000.00
864,696.25
26,188.75
840,000.00
866,188.75
17,578.75
850,000.00
867,578.75
8,866.25
865,000.00
873,866.25
1,444,225.00 9,050,000.00 18,234,424.25
K-2
Okeechobee Utility Authority
Debt Service Summary - SRF Debt
FYE
Ending
9/30/09
9/30/10
9/30/11
9/30/12
9/30/13
3/15/14
9/30/14
9/30/15
9/30/16
9/30/17
9/30/18
2/12/19
9/30/19
9/30/20
9/30/21
9/30/22
9/30/23
9/30/24
9/30/25
9/30/26
9/30/27
9/30/28
9/30/29
9/30/30
Totals
Last Updated
08/31/20
SRF # 1
SRF # 2
Int. 1.86%
Prin.
Int. 2.3%
Prin.
SRF # 3
Int. 1.91%
Prin.
SRF Total
Debt Service
94,955 1,190
189,876 2,414
191,207 246,369
186,683 496,179
177,412 505,451
167,966 514,896
158,345 524,518
148,543 534,319
138,559 544,304
128,388 554,475
118,027 564,836
107,472 575,391
96,720 586,143
85,767 597,096
74,609 608,253
63,243 619,619
51,665 631,198
39,870 642,993
27,854 655,008
15,615 667,248
3,146 338,285
0 0
95,151 224,518
222,466 414,686
214,572 422,839
207,717 429,526
197,781 439,461
4,022,441
141,358 336,586
88,614 230,030
83,292 235,351
77,848 240,795
72,278 246,365
27,954 2,957,401
0 0
0 0
0 0
46,564 145,126
53,499 134,536
51,666 133,142
49,111 135,698
2,400,491
23,582 68,822
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
O 0
0 0
O 0
0 0
0 0
O 0
415,814
1,021,132
1,263, 023
1,504,914
1,504, 914
6,422,932
1,253,210
1,001,506
1,001,506
1,001,506
1,001,506
682,862
682,862
682,862
682,862
682,862
682,862
682,862
682,862
682,862
682,862
341,431
0
2,265,920 10,410,183
1,429,031 10,200,000
224,422 3,017,815
24,562,017
Lf a
Okeechobee Utility Authority
FY21 Budget
Notes to Labor Costs
Page Line
8/31/2020
L-2
X 149
Total Budgeted Labor costs as presented:
$3,967,039
The above amount includes labor costs for all positions expected to be utilized
in fiscal year.
A 1% Cost of Living Allowance has been included in the accompanying Budget
totaling:
$26,819
A 0% Merit increase has been included in the accompanying Budget totaling:
$0
A 2.0% Bonus has been included in the accompanying Budget totaling:
$59,363
An increase in Health Care Cost to OUA has been included in the
accompanying Budget totaling:
$0
An increase in the urgent care services contract has been included in the
accompanying Budget totaling:
$0
Total change in Budgeted Labor cost vs. previous year's budget.
(31,336)
A 13.4% decrease in the Pension Contribution funding totaling:
(43,649)
L-1
PRELIMINARY BUDGET 8/31/2020 10:51 AM
L900119 1VNI
m. m
v
i
w
N
...
'o
m
o
x
J m
m>
w m _&
o m x% m m a w 2-
o
m
m y
m m a w
-
o
0
[SOb '1041l�
o
Ovel
Accrued 0
Accrued 0
Subtotal Wt
Subtotal Wate.
Lo
Subtotal Woutewate
Subtotal Wastowl
Subtotal Meter Rel
Ac
Subtotal Muir.
Subtotal M
Submtul C
Ae
Subtotal Mater Reade
Urgent (
Subtotal Admi
Subtotal At
Adm -Supp
Ar
Subtotal Exec,
-
n
e
2.
0
v
a
3
2.
0
n g 2 1 .d
- z e
>
O
�_
f
�,=
1
3
O
1,833'
395,654
L.
w
eio
e
-LII
u
m
_
w,,.,
93,816
2,160
148,641
73,923
729,893
62,941
12,100
40,800
919,657
67,642
326,602
0
14,942
,e
� -
n
4
H
a. ym_ee��
m
!2!!l!!I:i!I::oeleala d ,-o:;:L:
m- m
O e
w a
-- e-
e N x-
x
a
e -to
io
to
to
e
J O e �n
9E.a
o.
u
la.
L
-
:+ m
w
m
1L
n
x a
r
o
0 0 0
0 0
010
0 0
0
0
0'o
0 0
0 0
0
v �c
v'0
000010e
N
e c
o
e o} - a
v- o
e
-
x
a
a n2
2 0 0 v
a -
i '>
I ;°
e 'o x j j ! v
0-
z
u
a e
e
-60-
e alb,-
t+
o ole
m
- a
- v
j'm
o .-..
-
-
= w
v
1 I3
c
O
m
to
a 0
c
e c
Um
J i
0 0
_
m-
__
oloa�
v
m
leo -
n
�1
-0L-
0 e:
e
0
0
0
84.000
i
: ! iy eo
eIua
0
e
m
It
o
lo
e
-
J
:;:i
- ;
x
L
!!':
n
w
e
:;:;!
w
v
en
m
L
4.1 as _ 44 Os
L 14
m-4 0 ee e e. w -ma
�
P
J
0
fa
U
u
n.-
e
-Ps 01
ue
Usw
44
9
_o
LEIw N
1W ' ' `
e a
-:I
DI:
..:L 4._ v e n J
J a 0 0
Eo e
t a
14
n
e
0
L.
y
a
:-4
o
1-
w
a
a
:e
vi o 0 :�
0
I
0 ,e 0 0 00 COo0 0 o
e
e e
0 0
0
0
0
0
0 0
0
p
0 0 0 cc
C
0
c e o
I
o e e e e 0 e io
0 0
D o e
0
c
e
c e
0
I! F7 F
0 0 a
<
e
_ w
- -
0 w a-
0
time
.�
_
w e e,
o
a
w
o
�2
i.�
w
-
_
a i10
- e _ .
8 8 E 8 e 8 mJ 8 e J w
J
a
o v
]
e a w a
J
x
-
0
enweu
u
=
C o
-m
ooNlN
13$0119 lVN1d
Vi d CC 0008/FL/6
2:82Pin4.
8821"800JOIN>uu+
000J
mui
W 88
O
88,88V88+8.m,c)N2wm
0b
1JN
40112
c
O
u
J
_
m nate pionnuSuon rung ueeo an operating Revenue
f...l'._. TOTAL
rroteIciIeu runt! uaraaces
I
c2u2 2
a1c
r
t
n
Il
m
s
maaFf?
-
'4_nAn°
zoaa�a'T
xO3
t
3°
s
x
e n
n°o'a
-3n3=
" c 3-
_
x
n i
I INet General ullllly Operaling Revenue
BUT Debt Service Payments (required)
I I WasteWater egg from 10/20 Developers'
2
i�Fi
_x_='_
'
p
L.u.enccu r.rcwun
r ineastructure rroloen u551100a
epanmental Oopltal Requests: (Detail on le -1)
IUIF 01uIIo11 ereclncal ranela - / brall0n5
)U1 Mallon Pump Replacements
:ar�am�Fi
lam
?af
'_
I u c
F?x
a
=3ua?
m Ll
'o
c
=a
i
_--
mg^
17
o
?n
.2 0
_
3
ruse or runs For wastewater Liopnar Protects:
SW Section design construction 1-13-20
_F
mmmd
�.
_oma
95�GS
-=mc
33
N
3
..
Fm�
m
m_3
o
i
i
IbW se Won W WPrefect (loan to be obtained)
-�n=,`-exs°
-
°
d
0
d
G
3
-
I
Water Main Rel008IIOf 4415E
Pine Moe Park Wastewater
e
d
v
n
AOvanco0 Motor infrastructure project In Buckland
Pine Ridge Park Wastewater State Grant
Source of Funds from Operations net debt service, excluding 1
-
°
_
ff
-
a
el
o'o
oa
el 0,1
om00 _u
884
3
T
1?.o
N
o0
00
00o
a
0000
19
m
0
-
e
a
®
J
°,
n000a'a'ooth
_.
03
a
.-
—
— in
12
N u
—
1.500.000
6,771,795
6,926,133
V
n O
m
z
o
a
0
o
0
N
FUN al
1 M
N
m
0
J
gh'Ia
2
0
2,340
0
v
5X of Prev
Yr Op Rey
Ob
o£
9
_
w
o
o
N
in
O
o o
0
o!A
31
14
cI�
N
100.000
I/
00
O
O
__
c
u
0
12
a
0
a
s u.
a
u
y___N
Li_
a a
a a
a a
440697
100.000
1 500.000
0
MSC
6.926.133
O O a
0
000 6
7 t °°0
M
o e
a
Okeechobee Utility Authority FY21 Budget
Projected General In -Fill Revenue
Approved Rates from Resolution 20-02, Effective April 1, 2020
WATER
8/31/2020
WASTEWATER
Capital Connection Charge Revenue
Projected Projected
Connections Connections
Added in Revenue Total CC Added in Revenue Total CC
FY21 Per CC Revenue FY21 Per CC Revenue
25 $386.00 $9,650.00 12 $750.00 $9,000.00
Install Fee Revenue
Revenue Per Total Install Revenue Per Total Install
Residential Mtr Fee Revenue Connection Fee Revenue
25 $255.00 $6,375.00 12 $510.00 $6,120.00
Accrued Garanteed Revenue Charges (AGRC)
AGRC Per 1 ERC Total AGRC AGRC Per 1 ERC Total AGRC
Connection nl Revenue Connection (2) Revenue
Oct -19 2 250.00 500.00 1 500.00 500.00
Nov -19 2 250.00 500.00 1 500.00 500.00
Dec -19 2 250.00 500.00 1 500.00 500.00
Jan -20 2 250.00 500.00 1 500.00 500.00
Feb -20 2 250.00 500.00 1 500.00 500.00
Mar -20 2 250.00 500.00 1 500.00 500.00
Apr -20 2 250.00 500.00 1 500.00 500.00
May -20 2 250.00 500.00 1 500.00 500.00
Jun -20 2 250.00 500.00 1 500.00 500.00
Jul -20 2 250.00 500.00 1 500.00 500.00
Aug -20 2 250.00 500.00 1 500.00 500.00
Sep -20 3 250.00 750.00 1 500.00 500.00
Totals 25 $6,250.00 12 $6,000.00
Statictical Data:
Water Wastewater
Projected Number of active connections
Beginning of previous Fiscal Year 9464 4414
Beginning of Fiscal Year 9505 4424
In -fill Growth rate 0.263% 0.271%
Average cost per new connection $891 $1,760
(1) AGRC for water was capped at $250.00 effective 10-1-18 as part of the 75% discount
(2) AGRC for wastewater was capped at $500.00 effective 10-1-18 as part of the 75% discount
FINAL BUDGET
8/13/2020 10:14 AM
N-1