FY19 OUA Budget5/3/2010
Okeechobee Utility Authority
FY19 Budget
Table of Contents
FY19
Budget Doc.
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
B-1
Notes to Revenue Summary
0-2
Revenue Summary
B-3 to 13-4
Revenue Detail
C
C-1
Notes to Expenditures 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 -1e 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 & 1 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
H-1
Analysis of Fire Hydrant Fund
K
K-1
Debt Service Summary BB&T and SRF Combined
I<-2
BB&T Debt Service Summary Series 2017 A & 2017 B
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 & AGRC
O
0-1
Projected Fund Balances and Expenditures for Capital Projects
P
P-1
10/20 Plan Developer CC Revenue
R
R-1
Budget Recap for Newspaper
5/3/2018 2:50 PM
-0.94% 1
Okeechobee Utility Authority
FY19 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:
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 lower than the previous years
budgeted levels by:
O & M expense classifications which have been subject to market volatility have been
adjusted to reflect projected increases as follows:
Electric Services
12,000
Chemical Expenses
54,500
Fuels, Gas & Diesel Expenses
$ (4,010)
O&M Expenses (excluding labor)
$ 233,988
Labor related expenses reflect the following:
Total for Cost of Living Adjustment:
$25,546
Total cost for Employee Merit Increase:
$51,733
Total cost for Employee Bonus:
$45,429
Total cost for Employee Health Care Increase:
$0
Total cost of Urgent Care Services Increase:
$2,547
Pension Contribution Annual Budget & Rate
$397,485
In summary, total operating expense (including labor) as presented is higher than the
previous years budgeted levels by:
5/3/2018 2:50 PM
5/3/2016
FY19
0.278%
0.0%
0.0%
2.5%
9.8%
7.3%
1.0%
1.5%
1.5%
0.0%
3.0%
16.0%
4.3%
A-1
Okeechobee Utility Authority
FY19 Budget
Notes to the Budget Summary of Sources & Uses Funds Statement (Pages 44-A6)
Page
Line
5/3/2018
A-4
7
General Utility Operating Revenue not including incremental
$ 9,151,064
revenue from the FY10 & FY11 rate increases shown below:
A-4
40
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:
$ 851,862
Total operating expense (including labor) as presented is 4.3%
higher than the previous years budgeted amount by:
Total operating revenue, including fire hydrant fees, is lower
-0.94%
than the previous years budgeted amount by:
$ (95,269)
A-4
10
Total Operating Expenses is composed of five departmental
$ 1,735,880
A-4
8
totals as is shown in Expenditures Summary C-2 lines 6
through 24.
$ 7,290,001
Total operating expense (including labor) as presented is 4.3%
higher than the previous years budgeted amount by:
$ 299,902
A-4
10
Senior Debt Service consists of both BB&T series 2017A&B
Bank Loans.
$ 1,735,880
A-4
See Tab K for the detail for each debt issue.
A-4
A-4 22
Junior Debt Service consists of 2 SRF loans.
As presented the Budget projects utilization of Rate
Approximately 30% of the restricted revenue category is
A-4
12
A-4
31
derived from the scheduled special assessments from
developers' in the 10/20 plan for wastewater capital
connection charges of:
$ 60,373
A-4
30
And for water capital connection charges of:
0
A-4
28 &
29
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.
CO
$ 18,258
A-4 22
Junior Debt Service consists of 2 SRF loans.
As presented the Budget projects utilization of Rate
A-4
12
Stabilization Funds for SRF Junior debt service payments in
the amount of:
$ 212,296
A-4 22
Junior Debt Service consists of 2 SRF loans.
$ 1,001,506
See Tab K pages K-3 for the detail on each indebtedness.
(1) Assumes Capital Connection Charges, AGRC and
installation fees will stay at 75% discount levels. The
FY18 budget at 100% generated $95k more revenue.
A-2
5/3/2018 2:51 PM
Okeechobee Utility Authority
FY19 Budget
Notes to the Budget Summary of Sources & Uses Funds Statement (Pages A4 -A6)
Page
Line
A-4
35
Total interest income revenue on restricted account balances
has been projected based on the extremely low current yields
$ 186,053
A-4
34
on qualified public funds accounts and with the expectation
that these low yield levels will likely continue through the
proposed budget cycle.
$ 34,360
A-4
35
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:
$ 186,053
A-5
A-5
88
104
Total Fund Balances at September 30, 2018 (Projected)
$ 10,037,176
As presented, the Budget Summary anticipates that the
$ 6,947,375
A-4
41
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:
$ 851,862
A-4
44
The remaining revenue will be transferred to the Rate
Stabilization Fund at year end:
$ -
As presented the Budget projects utilization of Operating
A-4
57
Funds to increase the Emergency Reserve Fund to its $ 24,649
minimum requirement by adding funds in the amount of:
A-5
A-5
88
104
Total Fund Balances at September 30, 2018 (Projected)
$ 10,037,176
See worksheet in section 0 for a detailed analysis of the
projected balances
$ 6,947,375
Projected Net Additions to Fund Balances From Transfers in FY19
$ 72,328
This amount represents the expected transfers to the
individual funds as further detailed in the worksheet in tab O.
$ 6,947,375
A-6
149
Proposed Capital Improvement Project and departmental capital
request expenditures for FY19 total:
$ 6,947,375
Proposed capital expenditures are found listed in Tab D,
sheet D-2.
The proposed expenditures are not listed in any order of
priority.
A-6
168
Total Projected Fund Balances at September 30, 2019
$ 4,375,996
See worksheet in section 0 for a detailed analysis of the
projected balances
A-3
5/3/2018 2:51 PM
AIBICI 0 f E I F
G
H
1
2
3
4
5
Okeechobee Utility Authority
water
FY19 Budget
sewer
Budget Summary
Sources & Uses of Funds Statement 5/3/201
6
FUNDS FROM GENERAL UTILITY OPERATING REVENUE SOURCES:
FY19 Budget
7
General
Utility Operating Revenue (Not including revenue from FY10 & 11 rata Increases)
$9,151,064
B
Total Operating Expenses
(7,290,001)
9
Net General Utility Operating Revenue (Available for 5135T 0/5)
1,861,064
10
Total BB&T Debt Service Payments and Budgeted 050 Ratio
(1,735,880)
11
Remaining General Utility Oper Rev (Aver 695T DP Available for SRF Drs)
125,184
12
Extra Funds needed from Rate Stabilization Fund
212,296
13
FUNDS PROVIDED FROM RESTRICTED REVENUE SOURCES:
14
Transfers In From Restricted Funds to Meet SRF Debt Service:
15
Transfer in From 10/20 WW CCC Fund
0
16
Transfer In from RR&I Fund Surplus (See Tab E. colt 514)
0
17
Transfer in from Emergency Reserve Fund Surplus pee Tab F, cell 614)
0
18
Transfer in from Operating Reserve Fund Surplus (See Tab 8, cell 514)
0
19
FY10 & FY11 Rate Increase Revenue used for current SRF Debt Service
851,862
20
Total Restricted Funds used for SRF Debt Service
851,862
21
Sub -Total
1,189,342
_
22
Total SRF Debt Service Payments and Budgeted DSC Ratio
(1,001,506)
a
23
24
Remaining General Revenue & Transferred Funds
187,836
25
26
OTHER SOURCES OF FUNDS;
27
Restricted Revenue:
28
Water Capital Connection Charge Revenue From InOil
9,450
29
Wastewater Captial Connection Charge Revenue From Infill
8,808
30
Water Capital Connection Charge Revenue From 10/20 Developers
0
31
Wastewater Capital Connection Charge Revenue 10/20 Developers
60,373
32
WW Capital Connection Revenue (Indirectly Through Tax Certificate Process)
0
_
33
Fire Hydrant Fund Fees
73,062
34
Restricted Interest Income
34,360
35
Sub-Tolal Restricted Revenue
106,053
36
37
Incremental
Rate Revenue from FY10 & FY11 Rate Increases:
38
Continuing Revenue From FY10, fi,) Rale Increase
526,382
39
Continuing Revenue From FY11. 35% Rale Increase
325,480
40
Total Incremental Revenue from FY10 & FY11 Rate Increases
851,862
41
Amount earmarked towards current SRF Debt Service Payments
(851,862)
42
Subtotal
0
43
Funds Transferred to Future CIP, earmarked
0
44
Remaining Rate Increase Revenue
0
45
46
Total Funds Available for Required & Discretionary Capital Transfers
$ 373,889
47
48
Required
Capital Transfers:
49
Transfer Into Fire Hydrant Fund
(73,062)
50
Transfer of Interest Income Shown Above Into Respective Restricted Funds
(34,360)
51
Transfer to Operating Reserve Fund (skive to maintain 90 days of newssheet G cell B14
(73,921)
52
Transfer Into Water CCC Fund (from Water in -fill Revenue)
(9,450)
53
Transfer Into Water CCC Fund (from Water 10/20 Plan)
0
54
Transfer Into WW CCC Fund (from WW in -fill Revenue)
(8,808)
55
Transfer Into WW CCC Fund (from 10/20 Plan After SRF Debt Service Payments)
(60,373)
56
Transfer Into RR&I Fund (lo be maintained at 5% al Prior Year System Revenue)
0
57
Transfer Into Emergency Reserve Fund Is be maintained at 30 days Oper Exp)
(24,649)
58
Total funds used for Required Capital Transfers
(284,624)
59
60
Discretionary Capital Transfers:
61
Transfer to Operating Reserve Fund (srove to maintain 90 days of 059)
0
62
Inter -fund Transfer to Future CIP or other fund
(90,745)
63
Future CIP Funds Earmarked fora new project
0
64
Transfer to Rate Stabilization Fund
0
65
Total funds used for Discretionary Capital Transfers
(89,265)
66
67
Total funds used for Required & Discretionary Capital Transfers
(373,889)
68
69
70
REMAINING REVENUE FUNDS AVAILABLE FOR OTHER LAWFUL PURPOSES
50.
A-4
ABIGI - 0
E I F ....,....9___I I-1
71
FUNDING SOURCES:
FY19 Budget
72
Fund Balance Reserves at October 1, 2018 (Projected):
73
Restricted by Bond Covenants/Loan Documents:
74
RR&I Fund (Must be maintained at 5% of Prior Year System Revenue)
503,777
75
Capital Connection Fund -Water
903,581
76
Capital Connection Fund -Sewer
325,222
77
Capital Connection Fund -Sewer 10/20 Plan (Restricted for WWTP os)
558,630
78
Fire Hydrant Fund
99,135
79
Sub -Total
2,390,344
80
Restricted
by Board Policy:
81
General Operating & Payroll & Account Funds
1,757,072
82
PTO Account Fund
234,500
83
Emergency Reserve Fund (Must be maintained at 30 day Oper Exp.)
574,529
84
Operating Reserve Fund (strive for so Days al Oper Exp)
1,723,613
85
Future CIP Funding (Stave to maintain al 5% of Prior Year System Revenue)_
1,042,605
86
Rate Stabilization & Debt Service Reserve Funds -
2,314,513
87
Sub -Total
7,646,832
B8
Total Fund Balance Reserves at October 1, 2018 (Projected)
10,037,176
89
90
Changes
to Fund Balance Reserves (From Transfers during FY19):
91
Transfer Into RR&I Fund (Mimi be maintained at 5% of Pdor Year System Revenue)
0
92
Transfer into CCC Fund -Water (from in -fill)
9,450
93
Transfer into CCC Fund -Water (from 10/20 Plan)
0
94
Transfer into CCC Fund -Sewer (from in -fill)
8,808
95
Transfer into CCC Fund -Sewer 10/20 Plan diet of SRF Debt Service Payments)
60,373
96
Transfer into Fire Hydrant Fund
73,062
97
Transfer Into PTO Account Fund (Net of withdrawals)
0
98
Transfer into Emergency Reserve Fund (Aust be maintained at so days Oper Exp)
24,649
99
Transfer into Operating Reserve Fund is m maintain al 90 days oro & M)
73,921
100
Transfer into Future CIP Funding Sieve to maintain at 5=s of Prior Year cross Rev)
0
101
Transfer into Discretionary Rale Stabilization Funds
(212,296)
102
Transfer Into Future CIP Fund Earmarked for
0
103
Transfers into Restricted Accounts from Interest Income
34,380
104
Total Additions into Fund Balance Reserves (From Transfers In FY19)
72,328
105
106
Total Fund Balance Reserves (Projected)
10,109,504
107
108
Funding Sources for proposed Construction Project Expenditures:
109
Funding From State Appropriation for Wastewater Project
0
110
Funding From Stale Appropriation for Septic to Sewer Project
523,867
111
Funding From CDBG grant for Whispering Pines Water Project
690,000
112
Total Funding Sources from Grants & Loans
1,213,867
113
114
TOTAL FUNDS AVAILABLE FOR CAPITAL EXPENDITURES & FUND BALANCE RESERVES
11,323,371
115
A-5
A B CI D
E F G L®_H
116
PROPOSED CAPITAL EXPENDITURES DURING FY19:
FY19 Budget
117
Proposed Capital Improvement Project Expenditures:
Funding Sources
118
CIP Expenditures Carried-Over from previous Budgets:
-
119
Water Treatment Plant Storage Tank 3M gallons
4,665,610
OP/CIP/RSF/Water CC
120
SE 8th Ave Water Main Installation
325,000
CIP
121
122
OP / CIP
123
124
125
Sub-total
4,990,610
126
127
CIP Expenditures Proposed for FY19:
128
Scada System
50,000
Sewer CCC
129
Gravity Sewer Repair & Rehabilitation
100,000
Sewer CCC
130
Generator-Lin Stations
15,000
131
Lin Stations Rehabilitation
0
132
Water Main Installation (System Wide)
300,000
Water CCC
133
Water Main Repair & Replacement (System Wide)
150,000
Water CCC
134
Manhole Rehabilitations (30 x $2,400 each)
72,000
Sewer CCC
135
Septic to Sewer Project
523,867
136
Fire Hydrant Replacements (nominal)
25,000
HYD FD
137
Sub-total
1,235,867
138
139
Total Proposed Capital Improvement Project Expenditures
6,226,477
140
141
Proposed Departmental Capital Expenditures: (Detail on 0-1)
142
Administration (water and wastewater master plans)
350,000
WATER CCC & WWTI
143
Maintenance
224,810
OP
144
Water
18,500
Water CCC
145
Wastewater
127,588
_
Sewer CCC
146
Meter
0
147
Total Proposed Departmental Capital Expenditures
720,898
148
149
Grand Total of Proposed Capital Funds Expenditures
6,947,375
150
151
PROJECTED RESERVES END OF FISCAL YEAR
152
Fund Balance Reserves at September 30, 2018 (Projected):
153
Restricted by Bond Covenants/Loan Documents:
154
RR&I Fund (Must be maintained at 5% of Prior Year System Revenue)
510,045
155
Capita/ Connection Charge Fund-Water
19,531
156
Capital Connection Charge Fund-Sewer
27,030
157
Capital Connection Charge Fund-Sewer 10/20 Plan (Restricted for WWTP os)
444,003
158
Fire Hydrant Fund
147,197
159
Sub-Total
1,147,805
160
Restricted by Board Policy:
161
General Operating & Payroll Account Funds
349,064
162
PTO Account Fund
234,500
163
Emergency Reserve Fund (Musa be maintained at 30 day Oper E,p.l
606,326
164
Operating Reserve Fund lsbtve for 90 Days of Cper Exp)
1,813,91B-
165
Future CIP Funding (Strive to maintain at 5% of Prior Year System Revenue)
117,605
166
Rate Stabilization Fund
106,777
167
Sub-Total
3,228,190
168
Fund Balance Reserves at September 30, 2019 (Projected)
4,375,996
169
170
TOTAL PROPOSED CAPITAL EXPENDITURES AND FUND BALANCES
11,323,371
171
172
REMAINING FUNDS
Si
176
A-6
AIBICI 0 1 E 1 F G L H
177
178
179
180
161
.1
Okeechobee Utility Authority
FY19 Budget
Budget Summary 5/3/201
Debt Service Coveraoe Tests
182
Senior Lien Debt Service Coverage Analysis_(110% Required)
183
184
General Utility Operating Revenue pine 7 above)
$ 9,151,064
185
LessTotal Oper Exp pme 6 above)
(7,290,001),
186
Net General Utility Operating Revenue
$ 1,861,064
187
188
Additional
Operating Revenue includible for Senior Lien Coverage test:
189
Fire Hydrant Fund Fee Revenue (One 33 above)
_
73,062
190
Incremental Rate Revenue from FY10 & FY11 rate increases pine 40 above)
851,862
191
192
Total Current Year Operating Revenue for Senior Lien Coverage Test
5 2,785,988
193
194
Senior Lien Debt Service
(1,735,880)
160% a
195
196
Remaining
General Utility Oper Rev After BB&T Debt Service
5 1,050,108
197
198
Senior Lien Coverage
199
L
200
Junior
Lien Debt Coverage Analysts (115% for SRF)J120%for RSF)
FORSRF
COVERAGE
FORSRF
COVERAGE
201
202
Remaining
General Utility Oper Revenue After BB&T Debt Service
$ 1,050,108
$ 1,050,108
203
Less Senior Lien Coverage Factor at 10%
(173,588)
(173,588'
204
Less Incremental Rate Revenue from FY10 a FY11 rate increases added above
(851,862)
(851,862'
205
Add other sources of revenue provided in current year.
206
Total Restricted Interest Income
34,360
34,360
207
Water Capital Connection Charge Revenue From Infill
9,450
9,450
208
Wastewater Gaptizl Connection Charge Revenue From Infill
8,808
8,808
209
Water Capital Connection Charge Revenue From 10/20 Developer
-
-
210
Current year 10/20 Plan WW CCC revenue
60,373
$ 60,373
211
212
Revenue available to meet Junior Lien coverage test before recognizing portion of
FY10 & FY11 Rate Increases as current year revenue.
$ 137,640
$ 137,649
213
Extra Funds needed from Rale Stabilization Fund
$ 212,296
212,296
214
Portion of FY10 & FY11 rate increase revenue required to be recognized in current
year to meet Jr Lien Coverage tests
851,862
851,862
215
216
Total revenue required to meet Jr Lien Debt Service Coverage
$ 1,201,807
1,201 807
217
218
219
Junior Lien Debt Service Coverage (DSC) Requirement is 1.15
120%
220
221
DSC Requirement to satisfy before funds are added to Rate Stabilization Fund
120%
222
223
Junior Lien Revenue Requirement Per SRF Coverage at 115%:
224
Junior Lien Debt Service $ 1,001,506
225
Add Junior Lien Coverage for SRF 150,226
226
Total Operating Funds required to meet SRF debt coverage ratio 1,151,732
227
A-7
Okeechobee Utility Authority
FY19 Budget
Notes to Revenue Summary
Page
Line
5/3/2018
8-2
8 to 12
Grand Total Operating Revenue is composed of five classifications of
operating income shown in Revenue Summary tab B lines 8 through 12.
10,002,927
B-3
18
Total Water Utility Revenue
6,028,494
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:
320,982
8-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:
198,474
FY19 water utility revenue has been projected utilizing OUA's 4 year weighted
average model.
B-3
29
Total Sewer Utility Revenue
3,789,082
8-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:
205,400
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:
127,006
FY15 sewer utility revenue has been projected utilizing OUA's 4 year
weighted average model.
B-3
31
Penalties & Late Charges
B-4
62
106,178
Total Capital Connection Charges
78,631
As previously noted, other than the scheduled 10/20 developer special
assessments, the growth rate in new capital connections from in -fill is
projected at approximately:
0.278%
5/3/2018 2:52 PM
B -i
A
1 Okeechobee Utility Authority
2 FY19 Budget
3 Revenue Summary
4
5
6
7 Operating Revenue:
FY18
Budget
8
Total Water Utility Revenue (see B-3 Line 18)
6,084,065
9
Total Sewer Utility Revenue (see B-3 Line 29)
3,792,685
10
Penalties & Late Charges (see B-3 Line 31)
121,721
11
Miscellaneous Revenue (see 13-3 Line 33)
77,230
12
Total Other Operating Revenue (see 8-3 Line 38)
22,307
13
Grand Total Operating Revenue (see B-3 Line 40)
10,098,008
14
15
Non -Operating Revenue:
16
Gain/Loss Sale of Fixed Assets (see 13-4 Line 43)
0
17
Fire Hydrant Fund Fees (see 13-4 Line 45)
73,250
18
Total Restricted Interest (see e-4 Line 56)
22,000
19
Total CCC Revenue (Direct) (see B-4 Line 62)
221,468
22
Grand Total Non -Operating Revenue (see B-4 Line 72)
316,718
23
24
Grants, Loans & CIP Funding:
25
Internal Funding for CIP Expenditures
6,593,850
26
Internal Funding (Rate Stabilization Fund) for SRF Debt Service +
funding for Operating Reserve and for Emergency Reserve Funds
0
27
External Funding for Construction Projects
1,040, 000
28
Total Grants, Loans & CIP Funding (see 13-4 Line 80)
7,633,850
29
30
GRAND TOTAL REVENUE (see B-4 Line 82)
18,048,576
31
32
33
DM %
0.00%
5/3/2018
FY19
Budget
6,028,494
3,789,082
106,178
39,438
39,734
10,002,927
0
73,062
34,360
78,631
186,053
6,947,375
123,031
1,213,867
8,284,273
18,473,253
B-2
5/3/2018 2:52 PM
A
H
N
O
p
1
Okeechobee Utility Authority
2
FY19 Budget
3
Revenue Detail
5/3/2010
4
PRELIMINARY
FY18
FY19
5
(1) revenue budget assumes capital connection charges and
related installation fees will remain at 75% discount levels.
Budget
Budget
6
Amount
Amount
7
OPERATING REVENUE
8
Water Utility Revenue
5,366,255
5,349,708
9
Water AGRC Revenue (from in-fill connections)
13,911
3,783
(1)
10
Water GRC Revenue
27,692
16,956
11
Install Fees Water
21,125
5,300
(1)
12
Private Fire Protection
66,344
66,612
13
Turn On/Off Fees
49,530
49,920
14
Other Revenue Water
18,448
16,758
15
Incremental Water Rev From 6.0% Rate Increase in FY-10
321,788
320,982
16
Incremental Water Rev From 3.5% Rate Increase in FY-11
198,972
198,474
18
Total Water Utility Revenue
6,084,065
6,028,494
19
20
Wastewater Utility Revenue
3,399,142
3,423,333
21
Wastewater AGRC Revenue (from in-fiu connections)
9,350
2,622
(1)
22
Wastewater GRC Revenue
18,106
11,186
23
Install Fees Wastewater
23,352
5,844
(1)
24
Kings Bay Wastewater Maintenance Fee
8,526
12,462
25
Other Revenue Wastewater
4,152
1,230
26
Incremental Wastewater Rev From 6.0% Rate Increase in FY-10
203,949
205,400
27
Incremental Wastewater Rev From 3.5% Rate Increase in FY-11
126,108
127,006
29
Total Wastewater Utility Revenue
3,792,685
3,789,082
30
31
Penalties & Late Charges
121,721
106,178
32
33
Miscellaneous Revenue
77,230
39,438
34
35 Interest
Operating Account
15,642
39,566
36 Interest
on 10/20 Extended Payment Plan
6,627
0
37 Interest
Payroll Account
38
168
38
Total Unrestricted Interest Revenue
22,307
39,734
39
40
GRAND TOTAL FROM OPERATING REVENUE
10,098,008
10,002,927
41
In inn a n n inn nn
A
H
N
0
P
1
Okeechobee Utility Authority
2
FY19 Budget
3
Revenue Detail
5/3/2018
4
PRELIMINARY
FY18
FY19
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
73,250
73,062
46
47
Interest -Water CCC Fund
2,573
0
48
Interest -Wastewater CCC Fund
780
0
49
Interest -10/20 WWTP Expansion Fund
1,273
0
50
Interest-RR&I Funding Required accrued
1,464
6,268
51
Interest -Fire Hydrant Fund
213
0
52
Interest -Future CIP Funding
1,586
0
53
Interest -Rate Stabilization Fund & Debt Service Fund
7,434
4,560
54
Interest -Operating Reserve Fund (90 day O&M) accrued
5,027
16,384
55
Interest -Emergency Reserve Fund (30 day O&M) accrued
1,650
7,148
56
Total Restricted Interest
22,000
34,360
57
58
Water CCC from in -fill
32,750
9,450
(1)
59
Wastewater CCC from in -fill
30,420
8,808
(1)
60
Water CCC from 10/20 Plan (Net assessment received from developer)
35,525
0
61
WWTP CCC 10/20 Plan (Net assessment received from developer)
122,773
60,373
62
Total W&WW CCC Revenue (Direct)
221,468
78,631
63
71
72
GRAND TOTAL NON-OPERATING REVENUE
316,718
186,053
73
74
GRANTS, LOANS & CIP FUNDING
75 Internal
Funding for CIP Expenditures
5,823,800
$ 6,226,477
76 Internal
Funding for SRF Debt Service (from Restricted Funds)
0
123,031
77 Internal
Funding for Departmental Capital Expenditures
770,050
$ 720,898
78
External Funding -State Appropriations
350,000
523,867
79
External Funding CDBG
690,000
$ 690,000
80
GRAND TOTAL GRANTS, LOANS & FUNDING FOR CIP
7,633,850
8,284,273
81
82
GRAND TOTAL SOURCES OF FUNDS
18,048,5761
18,473,253
In inn a n n inn nn
Okeechobee Utility Authority
FY19 Budget
Notes to Expenditures Summary:
Page Line
5/3/2018
C-2
26
Total Departmental Operating Expense:
$7,290,001
Total Operating expense (including labor) as presented is higher
than the previous years budgeted amount by:
4.3%
$299,902
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 has been historically subject to market fluctuations
have been assigned a specific projected inflation factor. For
example:
Electrical expenses are assigned a specific budgetary value or an
adjusted amount based on a projected inflation factor of:
2.5%
Chemicals are assigned a specific budgetary value or an adjusted
amount based on a projected inflation factor of:
9.8%
Fuel, gas, diesel & general petroleum based commodities have
been assigned a specific budgetary value or an adjusted amount
based on a projected inflation factor of:
Many other expense classifications have been assigned a general
inflation factor of:
7.3%
C-1
5/3/2018 2:54 PM
A
B
2
3
4
5
Okeechobee Utility Authority
FY19 Budget
Expenditures Summary
Operating Expenses
6
Admin/Exec. Labor, (includes $27,851 for Urgent Care Services)
7
Admin/Exec. 0 & M
8
Total Administration / Executive Expenses
9
10
Maintenance Labor
11
Maintenance 0 & M
12
Total Maintenance Expenses
13
14
15
16
Water Labor
WaterO & M
Total Water Expenses
17
18
Wastewater Labor
19
Wastewater 0 & M
20
Total Wastewater Expenses
21
22
Meter Labor
23
Meter 0 & M
24
2b
Total Meter Reader Expenses
26
Grand Total Operating Expenses
27
28
Non -Operating Expenses
29
30
31
Debt Service Interest Expense
Amortization Expense
Depreciation Expense
32
Grand Total Non -Operating Expenses
33
34
Transfers
35
Debt Service Principal Payments
36
Required Transfers to Funds from Restricted Revenue
37
Required Transfers Into Funds from Pledged Revenue net of Junior Debt Service
38
Discretionary Transfers From Restricted Funds
39
40
41
42
Other Transfers
Grand Total Transfers
GRAND TOTAL EXPENDITURES
43
44
GRAND TOTAL EXPENDITURES WITHOUT
NON-CASH AMORTIZATION & DEPRECIATION EXPENSE
C ID
FY18
Budget
1,054,411
946,041
2,000,452
1,416,982
748,418
2,165,400
518,212
1,035, 829
1,554,041
591,372
434,300
1,025,672
218,866
25,668
244,534
6,990,099
687,251
22,200
2,600,000
3,309,451
2,045,840
200,774
122,773
367,989
7,633,850
10,371,226
I— 20,670,776
G
5/3/2018
FY19
Budget
1,123,61:
905,35:
2,028,966
1,389,309
939,150
2,328,459
521,65f
1,072, 24.
1,593,901
606,814
476,580
1,083,394
224,362
30,918
255,280
7,290,001
640,486
22, 200
2,660,000
3,322,686
2,096,900
224,250
60,373
8,161,242
10,542,765
21,155,452
18,048,576
18,473,252
C-2
5/3/2018 2:55 PM
_
W
0
O
CO
Q
Okeechobee Utility Authority
FY19 Budget PRELIMINARY 5/3/2018
Operating Expense Summary by Department
FY19
FY 19 Budget
Amount
C
r
CD
M
1 r
•r
P.
0
CO
O1
CO CO
521.658
i 5fi
) r
) CO
• CO
1 CO
CD
CV
CO
CO
V'
CV
N
N-
CO
h
in.
COA C;
M
CO
In
CO
O
ID
r
co
CO
V
CI
N
0
a-
476.5801
) CO
) r
) CO
O
3.424.2441
•
I
•
2.028.9661
2.328.4591
1.593.9011
1.083.3941
255.2801
7.290.0011
FY18
FY18 Budget
Department Amount
Summary Labor: Administration 1,054,411
Maintenance 1,416,982
N
T...
N
C
V-
N
L..
d
CO
Wastewater 591,372
Meter 218,866
Total Labor 3,799,843
Summary 0 & M: Administration _ 946,041
Maintenance 748,418
Water 1,035,829
Wastewater 434,300
Meter 25,668
Total O & M 3,190,256
Summary Dept Total: Administration 2,000,452
Maintenance 2,165,400
Water 1,554,041
Wastewater 1,025,672
Meter _ 244,534
Total Department Expenses 6,990,099
Prelim FY19 Operating Expense Budget higher than Final FY18 299,902
Percent increase 4.3%
t -I NI CJ
[fI in IO N-
W
O]
O
r
"
C]
-4-
I!]
t0
r
N
Q1
2
71
N
N
N
N
N
CJ
9
N
0)
0)
0)
C)
0)
0)
2
5/3/2018 2:56 PM
_
W
0
m
Q
'OI
Okeechobee Utility Authority
FY19 Budget 5/3/2018
Operating Expense Detail by Department and Account
FY19
FY 19 Budget
Amnnnt
N
O
O
' CO
{ O)
N
N
N
St
N
CO
O)
O
N
1.11
Ce)
O
0
14.2701
I N
I r
n
O
O
N
N
r.
O
CO
M
CO
t:
a—
N
r
O
Co
co
a—
r
r
ID
1�
r
M
O
O
1"-
N
'C
O
O
Cal
O
27.851
M
r
t0
M
N
r
FY18
Administration Labor: FY18 Budget
Account Number Account Description Amount
401-3-513-1100-100 Executive Salaries 288,744
401-3-513-1101-100 Supervisor Salaries 121,239
401-3-513-1200-100 Regular Salaries 318,372
1401-3-513-1201-100 On Call non -pension admin 0
401-3-513-1202-100 Merit Pay Admin 0
401-3-513-1300-100 Accrued Payout Admin (PTO) 17,236
401-3-513-1400-100 Overtime 6,875
401-3-513-1600-100 Accured Wages and FICA 0
401-3-513-1610-100 Accrued Benefits and FICA 0
401-3-513-2100-100 FICA 57,565
401-3-513-2200-100 Retirement 107,639
401-3-513-2300-100 Health Insurance _ 104,160
401-3-513-2301-100 Disability Insurance 2,953
401-3-513-2302-100 Life Insurance 2,352
401-3-513-2400-100 Workmens Compensation 1,972
401-3-513-2500-100 Unemployment Compensation 0
401-3-513-3400-213 Urgent Care Services 25,304
Admin Labor Subtotal 1,054,411
N
Q
CO
V
V N
V O
U'
Q
N- CO
Q.4-
0
Q
0.-
10 I!]
N
II]
CO
0
V`
0
10
CO
II]
I-
10
CO
N
0
4]
0
(O
(0
N
t0
to
0
0
0
0
n
N-
N
n
Y
U
5/3/2018 2:56 PM
N
0
5/3/2018 2:56 PM
FY19
FY 19 Budget
Amount
0
0
to
rep
0
0
0010
0
0
In
t`7
0
0
eV
0
0
to
CV
0
0
0
000
Lo
N
0
0
tfjc
0
C
Cr.
10,000
25 nnn
1401-3-513-3400-200 Other contract serv(surveys, 1095C, Misc.) 10,000 700001
) 0
) 0
)in
i N1P1
1
0
0
000to
r
0
0
cr
CO
0
0
O
we
0 0 0
0 0 0
loo
P<M eP("1'tl'00:
N
0
0
o00'tl
0
0
0
0
r
0
0
3,000
250
7 Snn
) 0 0
) 0 0119
)oto
rr
0
0
➢d
0
v
n
40,000
R snn
C
N
m
m
C
iti
(13
_
0
O
O
{
O
V
is
0
m
_
4
18
Administration O&M: 8
Account NumberFY18 Budget
Account Description Amount
AMA G99 Minn dna .-s_-
`FV 1-0-013-IOLU-IUU /Accrued OPEB - 4,900
401-3-513-3100-200 Legal Service -General Counsel 35.000
401-3-013-3100-202 Legal Sery-Dev Matters -Other 5,000
401-3-513-3100-203 Legal Serv-Easement Matters 5,000
401-3-513-3100-204 Legal Sery-Land Trust v OUA 0
401-0-010-3101-200 Engineering Fees 15.000
401-3-013-3101-201 ngEFees-Water General 10,000
401-3-513-3101-202 Eng Fees -Water Quality Improv. 40.000
401-3-513-3101-203 Eng Fees -WW General 10000
401-3-513-3ZUU-2UU Accounting & Auditing 25000
401-3-513-3400-202 Financial Advisor 2,500
401-3-513-3400-203 PRMG-Consultant Services - 28.490
1401-3-513-3400-204 GAS & Assoc -Legislative Sery 36,000
401-3-513-3400-205 Alcalde & Fay -Legislative Sery 40,000
401 3 513
3400-206 One -Call Serv(6,120 x4Yrs to5/31/16) 5,000
401-3-513-3400-207 ADP -Payroll Services 23.500
401-3-513-3400-212 ADP -Easy Labor Management Fees 4,000
401-3-513-3400-208 Random Drug Program Costs 3,000
401-3-513-3400-210Safety Matters -Consulting Serv. & Supplies 4.000
401-3-513-3400-211 Pension Related Matters 20.000
N
h
CO
Co
CJ;
Diem 5,000
401-3-513-4100-100 Communication Service 250
401-3-513-4100-101 Com Serv-Comcast Embarq 6.000
N-
a3
U
N
a)
v�[n
EE
0
Jvl
N
D
—
D
`)COC
0101
r]07c
_
D
7
4u I -3-513-41 UU-1 U4 Com Serv-Reimbursements 1,500
401-3-513-4100-105 Com Serv-Ads Services 0
401-3-513-4100-106 SLERS Radio Maint Fee (7x$9x12) 750
401-3-513-4100-107 SLERS Antenna Maint Fee (7x$9x12) 750
401-3-513-4100-108 SLERS R&M Admin _ 0
401-3-513-5215-100 Satety Supplies 550
401-3-513-4200-100 Postage and Transportation 50.000
00
0d
_I
LL
mai
0
O
0
ct '71-
'7M
DLO
Jt+)
D
7
0,Cc
ra)
co:
G
@.
XI
0<
— t
Ni
D(
7(
O)C
n
AJC
_
D C
t
4V I-3-0I3-4000-IUU I ravel and Per
cal v l ml in r---
n n n r
m
n n
01 m In
n CO CO
N
CO
m
CO
m
m
o
m
r'
m
(V V 2n
mm m
co
m
a m
mm
mc
m o
0
"
0
m
0
7
0
m
0
m
0
n
0
m
0
m 0
0 .-
.-
r
a
m
.-
v
v.
r
e
n
N
0
5/3/2018 2:56 PM
5/3/2018 2:56 PM
FY19
FY 19 Budget
Amnnnt
0
'O
T
r
{
)
0
0
0
<D
0
0
O
O
0
M
CC
V
0)
N
T
0)
1�
LO
r
0
0
In
r
0
0
O
O
r
0
0
N
r
0
0
Ill
r
0
0
0
In
C)
0
0
0
O
r
0
0
0
O
0
N
In
N
0
0
0
QO
T
0
0
0
00
0
0
0
eF
0
0
0
N
0
0
N
r
0
0
1f)
N
r
0
0
LO
aJ
0
0
r
N
0
0
til
N
0
1q
N
0
0
O
N
0
0
0
O
T
0
C
0
0
C
(®
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 946,041 905,353
152 Admin Dept Totals 2,000,452 2,028,966
LL
D
ac
FY18
Administration O&M: FY18 Budget
Account Number Account Description Amount
401 -o -o13-4400-101 Pitney Bowes Post Mach Lease 1,100
401-3-b13-4400-102 Copier Leases & Usage Costs 5,250
401-3-513-4500-200 Insurance -Prop, Cas & Gen Liab 321,757
401-3-513-4500-201 Insurance -Pollution Policy 12,944
401-3-513-4500-202 Insurance -Storage Tank Policy 1,500
401-3-513-4600-100 R&M Vehicles 1,500
1--5
40313-4609-100 R&M Building Admin 12,500
401-3-513-4611-100 R&M Equipment 2,000
401-3-513-4612-100 R&M Comp Equipment 2,500
401-3-513-4613-100 R&M Comp Software (Springbrk) 36,000
401-3-513-4613-101 Comp Sys, HW / SW Upgrades & IT Sery 10,000
401-3-513-4613-102 IT Outsourced Services 9.000
401-3-513-4615-100 Lawn Service Admin 2,520
401-3-513-4700-200 Printing and Binding 18,000
401-3-513-4901-100 Education-Springbrook & General 5,000
401-3-513-4902-200 Advertising 4,000
401-3-513-4902-201 Website/Webhosting Exp E -billing 2,000
401-3-513-4905-200 Bad Debt Expense 1,500
401-3-513-4909-100 Miscellaneous 12,000
401-3-513-5100-100 Office Supplies 8.500
401-3-513-5201-100 Fuel Gas & Diesel - Vehicles 2,160
401-3-513-5203-100 Uniforms 2,500
401-3-513-5207-100 Tools 250
401-3-513-5208-100 Supplies 2,500
401-3-513-5400-100 Books, Dues and Publications 8,000
401-3-513-6400-100 Department Expenditure (See D-1) 0
401-3-513-9000-200 Contingencies 60,000
cal -1 K I
N I
N
2
(1M
N
N
NN
N
2
co
PI
^
2
2 r
2
2
Q{
Q
Q
Q
.4
'{
Q
5/3/2018 2:56 PM
5/3/2018 2:56 PM
FY19
FY 19 Budget
Amnnnt
In
e-
M
i n
1
CO
In
N
e-
CO
to
CO
N
e-
CD
M
CO
r
V®®
1.
CO
In
M
M
V
1--
h
O)
CO
r
O
CO
CO
er^
r"
CO
In
M
O
CO
M
47.5471
•:®
O
O
O
CO
1.389.3091
I
W
0
FY18
Maintenance Labor: FY18 Budget
Account Number Account Description Amount
401-4-536-1101-100 Supervisor Salaries Maint 71,500
401-4-536-1200-100 Regular Salaries Maint 837,725
401-4-536-1201-100 On Call non -pension 12,360
401-4-536-1300-100 Accrued Payout 21,517
401-4-536-1400-100 Overtime Maint 54,544
401-4-536-1600-100 Accured Wages and FICA Maint 0
401-4-536-1610-100 Accured Benefits and FICA Main 0
401-4-536-2100-100 FICA Maint 76,320
401-4-536-2200-100 Retirement Maint 134,497
401-4-536-2300-100 Health Insurance Maint 156,240
401-4-536-2301-100 Disability Insurance Maint _ 3,615
401-4-536-2302-100 Life Insurance Maint 3,528
401-4-536-2400-100 Workmens Compensation Maint 45,136
401-4-536-2500-100 Unemployment Comp Maint 0
COLA Increase-Maint 0
401-4-536-1202-100 Merit Increase-Maint 0
Employee Bonus-Maint 0
Health Insurance Increase-Maint 0
Maintenance Labor Subtotal 1,416,982
o r l N
'0 to II1
01
10
O
0
r
0
N
t0
!O
m
V
In
0
0
l0
CO
r
0
m
0
01
0
O
r
r
r
N
n
fl
n
V
r
ID
r
l0
n
N-
r
of
r
0)
r
O
CO
r
CO
N
CO
CO
CO
V
CO
Ip
0
0
m
N-
CO
m
CO
0)
CO
0
0)
5/3/2018 2:56 PM
G9
U
5/3/2018 2:56 PM
FY19
FY 19 Budget
Amnnwf
0000000000
'
3
E
00000
I"-
0000
I+rl
r
(000000
NID
rMM
In
0
do
00
100
IO
O
'CP
000C
000C
000
tDMMr
•tP
C
uvv sc
) 0
) 0
) 00C
ION[
I10
0
0
N
C
C
C
r
vUU Ub
)00000c
) 0
)0000[
I OI�CON(O
IN
0
(0
0
0
0
Mc
C
If.
25,000
750
1 0
1 0
. (n
0
0
00[00000
rrr1O(nrM
0
CO
0
N
0
0
0
0
0
0
0
0
LL
0
m
—
cC
FY18
Maintenance O&M: FY18 Budget
Account Number Account Description Amount
401-4-536-4100-108 SLERS R&M Maintenance 0
n., . ,.,, ----
00
0
P
la
U
2[91
D
D
70(
V
D
OCD[
nIn[
0
Vii•
]
r'Zr
N
1�
C0
U
CO
d
O)[
O(
N ,•
O(
V (
M`
MC
O C
4U r-4-000-4000-IUU i ravel and Per Diem Maint 1.000
1401-4-536-4100-101 Com Sery-Embarq/Comcast Maint 4,500
401-4-536-4100-102 Com Sery-Nextel Cellular Maint 2,000
4u I-4-536-4100-103 Com Serv-Sprint Maint 0
401-4-536-4100-300 Communications AirVac 1,250
401-4-513-4IUU-1ULD SLERS Radio Maint Fee-Maint (31x$9x12) 3,500
401-4-513-4100-107 SLENS Tower Maint Fee-Maint (31x$9x12) 3,348
40 I -4-536-42U0-100 Postage Transportation Maint 750
=PL Maintenance 6,500
401-4-536-4300-200 Utilities -FPL Pump Stations 32,000
401-4-536-4300-300 Utilities AirVac 43.000
4D1-4-536 4301-100 Utilities Waste Management Maint 4,300
401-4-536-4301-101 Utilities Waste Mngmt-tipping fees 3,100
401-4-536-4400-100 Equipment Rental Maint 1,000
4u1-4-536-4600-100 K&M Vehicles Maint 20,000
401-4-536-4bub-200 R&M Pump Stations 50,000
401-4-536-4605-201 R&M Pump Stations Electrical 15,000
401-4-536-4605-300 K&M Air Vac 45,000
401-4-536-4bUb-400 R&M Water Distribution Maint 90,000
401-4-536-4605-500 K&M Sewer Collection Maint 20,000
4U I-4-536-4605-600 R&M Kings Bay 7,500
401-4-536-4605-700 R&M SCADA 3,400
4
01-4-536-4609-100 R&M Building Maintenance 2,500
401-4-536-4611-100 R&M Equipment Maintenance 35,000
401-4-536-4611-200 R&M Equipment Pump Stations 9:750
401-4-536-4611-300 K&IVI Generators 5.000
401-4-536-4b12-100 R&M Computer Equipment Maint 750
401-4-536-4613-100 R&M Computer Software Maint 500
00
O
r
C
N
rG
N
co
Q
U
Yom.
0
D
gt'ICJ
D(D(
7V'
:6 CD
n1.n
0
4-v'
7
-
4U I -4-036-4b lb-2uu Lawn Sery Pump Stations 1,980
401-4-536-4615-300 Lawn Sery Air Vac 1,620
401-4-536-4616-100 Testing and Lab Service 5,500
401-4-536-4901-1UU Education maint 5,500
401-4-536-4909-100 Miscellaneous Maint 0
C
E2
ar
D
E
In
0
0
r
0
A
1401-4-536-4300-100 Util
CD
Q co
I 0)I m
r coC9
0)
0)
m o
a) 0
N
0
N
N
0
N
V In
O 0
01 0l
0
N
0
0
N
r
0
01
CO
0
[)I
mN
O
01
0
01
1-
,-
CV
N
[+ )
01
Q
N
In
,-
N
ID
01
r
01
N
01
m
>-
N
0
N N
N N 01
N COn
N N
01
CrV
01
N
0 r
N 01 01
N N N
0
N
01
m 0
01 CO
N N
e-
C)
01
01 Celct
CO 0) (0
N 01 N
r
CO
N
G9
U
5/3/2018 2:56 PM
U
5/3/2018 2:56 PM
FY 19 Budget
Am nun+
O
0
O
' N
O
0
O
to
M
O
0
to
n
O
0
CO
N
O
0
0
N
1�
r
O
0
C)
tri
r
O
0
to
r
O
0
IC
r
O
0
to
t.
O
0
LO
N
O
V)
N
O
O
t[)
N
r
O
O
O
r
O
O
O
r
O
O
O
CO
O
O
O
CO
O
O
IN
C
C
C
LC
CC
vuu ut.
)0000
) O
) In
)
0
O
N
N
Maintenance 0 & M Subtotal 748,418 934 inn'
) Q)
I IC
) CO
I N
1 M
N
LL
w
twamtenance O&M: FY18 Budget
Account Number Account Description Amount
401-4-536-5100-100 Office Supplies Maint 1,000
4u1-4-536-5201-100 Fuel: Gas, Diesel - Vehicles 35.000
401-4-536-5202-100 Fuel Other Maint 7,500
401-4-536-5203-100 Uniforms Maint 5,500
401-4-536-5206-100 Meters and Meter Boxes 175,000
401-4-536-5207-100 Tools Maint 15.000
401-4-536-5207-200 Tools Pump Stations 2.500
401-4-536-5207-300 Tools Air Vac 500
401-4-536-5207-400 Tools Water Dist Maint 1.500
1401-4-536-5207-500 Tools Sewer Collection Maint 2,500
401-4-536-5207-600 Tools Kings Bay Maint 250
401-4-536-5208-100 Supplies Maint 12.500
401-4-536-5208-200 Supplies Pump Stations 1.250
401-4-536-5208-300 Supplies Air Vac 1,250
401-4-536-5208-400 Supplies Water Dist Maint 6,000
401-4-536-5208-500 Supplies Sewer Collection Main 3:000
401-4-536-5208-600 Supplies Kings Bay Maint 500
401-4-536-5209-200 Chemicals Pump Stations - 26.000
401-4-536-5215-100 Safety Supplies 10 000
401-4-536-5400-100 Books, Dues and Publ Maint 500
401-4-536-6400-100 Departmental Expenditure (See D-1) 0
40.-4-536-9000-100 Contingency-Maint 2.500
401-4-536-9999-100 Return To Stock 0
Maintenance Dept Totals 2.165.400
co
co
')
CA
t7
N
O
N
•-
O
01
N
Q
01
CO
Q
N
d'
01
V]
d'
N
(0
V
N
C-
V
01
CO
V
N
0)
Q
N
0
Vl
N
In
N
N
In
N
r)
In
04
C
N
01
In
N
N
10
in
01
r
N
01
W
In
04
0t
In
01
o
l0
01
tO
01
N
0
N
lam)
N
01
Z
CO
N
to
0
N
r
0
01
00
1➢
0
0)
10
N
1-
01
1, -
N
U
5/3/2018 2:56 PM
5/3/2018 2:56 PM
FY19
FY 19 Budget
hamem nt
CD
ID
tl'
' to
3 <t
3
10
CO
V'
0)
r
t0
0
M
tD
M
N
CO
1`
0)
N
C)
(O
N.
r
80
0
0
0
0
0
r
r
r0)
N
r
1-
O
r
CO
0
0
0
CO
et
In
�'
N
0)
(0
In
N
N-
N
ID
h.
et
N-
CO
r
N
0
N
10
0)
10
0
s'
d'
N
0
1+
N
r
CO
St
r
0
et
St
r
0
CO
r
N
0
I,-
r
CO
V
0
a-
521,658
LL
FY18
Water Labor: FY18 Budget
Account Number Account Description Amount
401-5-533-1101-100 Supervisor Salaries SWTP _ 44.302
401-5-533-1101-200 Supervisor Salaries GWTP 1g 987
401-5-533-1200-100 Regular Salaries SWTP 236.432
401-5-533-1200-200 Regular Salaries GWTP 34,517
401-5-533-1300-100 Accrued Payout SWTP 7 910
401-5-533-1300-200 Accrued Payout GWTP 0
401-5-533-1201-200 On Call/NonPension GWTP 0
401-5-533-1202-100 Merit Pay SWTP 0
401-5-533-1202-200 Merit Pay GWTP 0
401-5-533-1400-100 Overtime SWTP 11,642
401-5-533-1400-200 Overtime GWTP 1,833
401-5-533-1610-100 Accured Benefits and FICA SWTP 0
401-5-533-1600-200 Accured Wages and FICA GWTP 0
4U1-o-533-LDUU-IUU unemployment Comp SWTP 0
401-5-533-2500-200 Unemployment Comp GWTP 0
24,502
2,703
401-5-533-2200-100 Retirement SWTP 44.317
401-5-533-2200-200 Retirement GWTP 5,100
401-5-533-2300-100 Health Insurance SWTP 59,520
401-5-533-2300-200 Health Insurance GWTP 7.440
401-5-533-2301-100 Disability Insurance SWTP 1,254
401-5-533-2301-200 Disability Insurance GWTP 151
401-5-533-2302-100 Life Insurance SWTP 1,344
401-5-533-2302-200 Life Insurance GWTP 168
401-5-533-2400-100 Workmens Comp SWTP 14,491
401-5-533-2400-200 Workmens Comp GWTP _ 1,599
I3o9i Water Labor Subtotal 518,212
O
O
0
1-
0
CO
C
O
N
C
/U
0
C
O
z
(0
U
C
0
O
O
O
Q
N
t+
LO
6
2 -
n n
PI u�I n m
N "LaN
n
n
N
m
n
N
m
n
N
o
CO
N
CO
N
N
CO
N
CO
N
e
CO
N
LO
CO
N
ID
CO
N
n
CO
N
m
CO
N
m
O
N
o
m
N
m
N
N
M
N
COCD
m m
N N
v
01
N
to
01
N
n
m
N
CO0
m
N
m
M
N
o
CO
r
0
CO
N
0
CO
PI
0
CO
v
0
CO
5/3/2018 2:56 PM
U
5/3/2018 2:56 PM
L
FY19
FY 19 Budget
CD
CO
0
eco-
3'r
C
0
0
r
N
0000011,000000000
u)tnen
i'1' O
r
M
to
r
0
O
cD
r---
rO
LO
0
N
N
'Kt
InN
a-
V'
In
v-0
NO
r
C
C
V
If
r
UUU S7!
)000000000000000000
)
)
)
t
0
0
Iv
In
h
11,00000
CN
00000
1n
u)N
N
r
u)O
Nth
0000%1'00
In
do
In
In
cc.t
OIC
r
N
Cr)
000000
000000
0470
co
00
OO
a--
CD
01
r
to
IS
o
Ea
-
1
'Water 0 & M: FY18
FY18 Budget
Account Number
Account Description Amount
40
1 1-5-533-3400-201 utility Sry / Elev Strg Tank RM 18,072
� 401-5-533-1620-100 Accured OPEB SWTP 2.100
401-b-533-1620-200 Accured OPEB GWTP 450
01-o-533-34uu-zu9 GPS T
Tracking 1,650
001-5-533-4000-100 Travel and Per Diem SWTP 350
01-5-533-4000-200 Travel and Per Diem GWTP 150
401-5-533-4100-101 Com Serv-Embarq/Centurylinl( SWTP 5.000
401-u-533-4100-103 Com serv-sprint SWTP 175
and c cnn AAnn ..,.
10
co
E
'YI
a)
:nl
�4U 1-0-033-4IUU-ZUU Com Serv-Embarq GWTP 2.200
and c coo Annn Ann
Radio Maint Fee SWTP (5x$9x12) 540
Radio Maint Fee GWTP (2x$9x12) 216
YU 1-o-U33-41Uu-'1U! SLtKS lower Maint Fee SWTP (5x$9x12) 540
401-u-533-41uu-zu( SLERS Tower Maint Fee GWTP (2x$9x12) 216
401-u-533-4200-1uu Postage Transportation SWTP 1.000
401-5-533-4200-200 Postage Transportation GWTP 100
401-5-533-4300-100 Utilities -FPL SWTP 155.000
,401-5-533-4300-LUU Utmties-FPL GWTP 45.000
es -FPL PRP ' 0
es Waste Mgmt SWTP 3.000
4V 1 -o -003-43U i-Arin
zuu utilities Waste Mgmt GWTP 0
01-u-503-4400-iuu Equipment Rental SWTP 750
Y01-5-533-4400-200 Equipment Rental GWTP 250
401-5-533-4600-100 P.&M Vehicles SWTP 3.500
SWTP 15 000
GWTP 15,000
giu i -o -o33 -4o I i- Iuu K&IVI Equipment SWTP 125.000
401-5-533-461 I-200 R&M Equipment GWTP 30.000
.
Equipment PRP 1 000
Computer Equip SWTP '500
4V i-o-033-40.2-ZUU K&M Computer Equip GWTP 500
401-5-533-4613-100 R&M Computer Software SWTP 500
401-o-533-4613-200 K&M Computer Software GWTP 500
401-5-533-4615-100 Lawn Service SWTP 10.440
401-5-533-4615-200 Lawn Service GWTP 7.200
401-5-533-4615-700 Lawn Service PRP 1,620
ig and Lab Service SWTP 36.000
ig and Lab Service GWTP 500
+u i-a-033-401`J-iuu Czi Annual Maintenance 7.000
Ozone WaterSystertm Inc. SWTP 30,000
•
ation SWTP - _ 1.500
10
H
Ur
OC
-
nl
Li
O<
-c
7c
] C
r,
7r
0 r
3Lj
00
3C
t 4
a
E
tc
�C
7C
0 C
o-<
00 r
0 ci
n0
nu
JC
t
0<
0<
�.
77
0 C
C
0 r
0 r
01
n1
DC
3.
D<
0<
rC
Vr
0<
7`
+)C
h r
n1
1.50
?
0<
0<
.
-C
-
9C
hr
011
(.1-) LI
t CC
.-Y0C
01
n L
C
C
0
D
0
0
n
T
0
0
7
D
t
3-
MI")
N) 17
N
M
N
0)
N N
0) C] C]
N
N
0)
N
m (h
N N
0) 10
N 17 (7
1) (0
0)
0)
Ezt
M ",
2 C)
LE,
2
0) (0
g [7
<0
M(2
(1 (0 C')
A
V
C) (1
V
V A'A
(0 m 0) 0)
V
0
1!]
(0 0) (7
N N
(0
N WI 141 12()
2 ('1
!]
0)
0)
CO 11)) N (0
(0 (0
m (0
10<
<0 0)
2
U
5/3/2018 2:56 PM
5/3/2018 2:56 PM
FY 19 Budget
Amount
0
In
I N
' r
{
0
0
In
0
0
to
r
0
0
to
In
0
0
In
r
0
Io
M
0
0
O
°I
0
0
In
0
0
In
r
0
0
to
00
o
N
r
O
tzt
15.0001
) 0
o
In
0
o
49
0
In
N
0
0
LO
N
0
0
to
0
0
0
O
If)
0
0
O
O
N
0
0
to
r
0
0
r
0
0
O
r
0
in
r
0
0
o
O
U)
N
1.072:2431
1,593,901
w
0
CO
Water 0 & M: Description FY18 Budget- -
Account Number Amount
401-5-533-4909-100 Miscellaneous SWTP 1.250
401-5-533-4909-200 Miscellaneous GWTP 500
1401-5-533-4950-100 Permits SWTP 1,500
401-5-533-4950-200 Permits GWTP 500
401-5-533-5100-100 Office Supplies SWTP 1,250
401-5-533-5100-200 Office Supplies GWTP 350
401-5-533-5201-100 Fuel: Gas, Diesel - Vehicles SWTP 4,000
401-5-533-5201-200 Fuel: Gas, Diesel - Vehicles GWTP 810
1401-5-533-5202-100 Fuel Other Equipment SWTP 4,500
401-5-533-5202-200 Fuel Other Equipment GWTP 1,200
401-5-533-5203-100 Uniforms SWTP 1,500
401-5-533-5203-200 Uniforms GWTP 400
401-5-533-5204-100 Lab Supplies SWTP 5,400
401-5-533-5204-200 Lab Supplies GWTP 500
401-5-533-5207-100 Tools SWTP 500
401-5-533-5207-200 Tools GWTP 250
401-5-533-5208-100 Supplies SWTP 4,000
401-5-533-5208-200 Supplies GWTP 500
401-5-533-5209-100 Chemicals SWTP 450,000
401-5-533-5209-200 Chemicals GWTP 25,000
401-5-533-5215-100 Safety suppliesSWTP _ 1,500
401-5-533-5215-200 Safety supplies GWTP 100
401-5-533-5400-100 Books, Dues and Pub SWTP 1,500
401-5-533-5400-200 Books, Dues and Pub GWTP 150
401-5-533-6400-100 Departmental Expenditure (See D-1) 0
401-5-533-9000-100 Contingency -Water 5,000
Water 0 & M Subtotal 1,035,829
Water Dept Totals 1,554,041
r m
m l (0
0) 0)
m
m
m
o
r
0)
I-
c]
('I
r
m
c-)
n
N)
a{
r
m
u
CI
m
ID
n
0)
I;
r
01
P.D.OI
n
CO 0)
0
m
In
m
0)
Po'
m
m
m
m
01
y
m
C)
V)
m
m
Ip
m
0)
1P
m
0)
m
m
CO
o
m
I7
r
m
I+l
n
m
I.)
0)
rn
0)
n
m
m
m
m
m
m
m
0)
5/3/2018 2:56 PM
I
A I B 1 D IEIJ L
i Wastewater Labor: FY18 FY19
FY18 Budget FY 19 Budget
Account Number Account Description Amount
401-6-535-1101-100 Supervisor Salaries WW Amount
65,025 66,704
401-6-535-1200-100 Regular Salaries WW 298,666 305,029
401-6-535-1200-101 Part-time Salaries WW 37.712 38 7
401-6-535-1201-100 Non pension WW wages 11
a 0
401-6-535-1202-100 Merit Pay WW 0 0
401-6-535-1300-100 Accrued Payout WW 8.99R 7 188
401-6-535-1400-100 Overtime WVV 14.942 15 544
401-6-535-1600-100 Accured Wages and FICA WW
0
401-b-535-1610-100 Accured Benefits and FICA WW 0 „
CO
RI r
M
M
If)
r
et
T
CO
1401-b-535-2300-100 Health Insurance WW 59.520 59 520
401-6-535-2301-100 Disability Insurance WW 1.616 1 554
401-6-535-2302-100 Life Insurance WW 1.512 1 440
401-b-535-2400-100 Workmens Compensation WW 14.577 ga's-,n
427 ‘11.11-b-b:ib-zbuU-100 Unemployment Comp WW 0 0
428
429 Wastewater Labor Subtotal
591,372 606,814
430
431
432
433
434
435
436
437
401-b-535-2100-100 FICA WW 32,539
401-6-535-2200-100 Retirement WW 56.265
I.
1
1
1
I
0 0
V
0
0
a
0 0CO
v
v
0
v
0
7
v
CV
'S
r
3
.`r-
Q
'n CO
3 Q
r
R
CO
Q
m
V
a
Q
a
m
Q
5/3/2018 2:56 PM
5/3/2018 2:56 PM
FY19
FY 19 Budget
O
St
N
eN
0
0
0
0
r
0
0
in
I,-
)n
O
N
CD
O O
CO 01noln
Or
®
O
N
o 0 0
to
OI`�LO
ONr-NNNI!)r
co
1--
r
0
0
O
0
0
O
0
Cn00
0
0
0
0
0
o
00
V'A'N
0 0
o o
Cnl�tn
N
0
(no
0
rr
0
o
In
0
C
c
C
C
1UUS cc
3000000000000
, o
)LO
I
1
o
LO
o
LO
o
N
o
16)6{6
r
o
o
0)
r.-
o
CO
o
ca
rr
CO
N
-
11
CO
_
<
Wastewater 0 & M: FY18
FY18 Budget
Account Number Account Description Amount
Ani c om n.nn nnn ...,-. — . .
0
CPI
N
Yo
U
__n
i
3
A
D(
D i
7—r
3 1
n 1
n
(
2 - 1
t
I4U-i-b-bib-4950-100 Permits WW Cemetery Rd 0
-w -u-535-4000- iuu Travel and Per Diem WW 1.500
401-o-000-4100-108 SLERS R&M WWTP 0
And r cfr A nn An.n
0
O
0
1P
Y
D
C
U
01
6O
aE
E
LIY
E
o0.
DO(
7(7(
7
7
0LOl
n CO
n10L
n (D
7
t•I'<
0
N
C
>
N
u]
c
C
c
E
701
m
(n j
10
a
51312018 2:56 PM
FY19
FY 19 Budget
000000C
0
00SIZ
000'9t'
000'V
5201401-6-535-5400-100 Books, Dues and Publications 500 500
521 401-6-535-6400-100 Departmental Expenditure (See D-1) 0 0
522401-6-535-1620-100 Accured OPEB WW 2,300 2,300
523 401-6-535-9000-100 Contingency -WW 0 25,000
524 Wastewater 0 & M Subtotal 434,300 476,580
525 Wastewater Dept Totals 1,025,672 1,083,394
0
O
In
tf)
O
O
0
001.0000C
O
IO
O
O
O
N
Ia
h
O
t(2
0
to
O
N
If)
to
If)
O
N
O
Iii
'®
g M
O
M
M
O
r
r
LC)
r
r
r
) M
N
N
N
LL
FY18
Wastewater 0 & M: FY18 Budget
Account Number Account Description Amount
ervice WWTP 30000
ervices ETP 500
Services KBTP 750
vU I-b-b35-4blb- (UU Testing and Lab Services PRP 250
lent WWTP 25.000
2 500
2,500
ection Well due 6-17 0
0
4,200
0
el - Vehicles 5,000
1,250
1,500
4,500
1,500
3,000
TP 45,000
3,000
P 2,250
1,250
FP 2,250
D TP (Ava PRsn mn) enn
0
to
WW
ill
III
N
0)
0
N
01
0
In
Q) O
0
LL F-
O 0
O O
O O
N N
ill( i I CJ i I i t[)
((((1111(C01(10,1111111
LLII1111110111X)11111111
O 1 O
d '
S
o
'S
m
m
Yrm
m m 'Sr'
m
r m m o N c 8 18 to to
m m m o 0 0 0 0 0 0 0 0
p cV M
.-
Q v) (a
1- m
Q
y'
Q cY Q
C'
Q d' Q In 4] In I(l IP N V] I(J N
N N N �!] Ifl
N In
1n 141
10
a
51312018 2:56 PM
5/3/2018 2:56 PM
FY -19
FY 19 Budget
nrnni1 nt
CO
O)1-
WN
r-
7 to
)
CO
U5
co
O
CO
11)
Cn
N
Det
N
h
N
h0
O
0
r
O1f)1�000MN
Cf)OOrNIA
C.R.W
rrO)
r
N
I—CO
N
I'-
1%.
CO
c
TI
N
N
u
0
m
Meter Labor: FY18
FY18 Budget
Account Number Account Description Amount
401-7-513-1101-100 Supervisor Salaries 50,855
401-7-513-1200-iuu Regular Salaries 85,049
401-7-513-1202-100 Merit Pay 0
401-7-513-1300-100 Accrued Payout 3,216
O
CD
p)
OCI
CO
m
C
Cl_
C
O
ZZ
0o
•1
N
V
0 C')
n
Do
t.
4UI-/-0IJ-1ZU1-1 UU Non -pension wages 8,575
401-7-513-1400-100 Overtime 1,833
_ .....
a
Z
L
D
C
N
V)0
m
>
O
m
J
Z
7
D
)
)
r
401-7-513-1610-100 Accured Benefits and FICA 0
401-7-513-2100-100 FICA 11.440
401-7-513-Z UU-1UU Retirement 20,104
1 4 7
01-7-513-2300-100 Health Insurance 29,760
401--513-2301-100 Disability Insurance 597
401-7-5'13-2302-100 Lite Insurance 672
1401-7-513-2400-1UU Workmens Compensation 6.765
Meter Labor Subtotal 218,866
in
I In
CO 1n
V]
y'
m
0 In
u)
m
m
V1
I-
m
IO
m
0)
N
m
CO
In
0 CV
c v
to m l()
v
m
v
(0
y
'S
V)
0
v
1!)
m
c
N 141
1-
0
m m
v.1-
0 123
(0
1)
V)
t--
V)
0
co
(0
m If)
0
V)
0
0
N
.-
(0
0
0!
In
(0
m
10
l0
y
0
(0
In
0
If)
(0
(0
IJ)
n
(0
N
m
IO
V)
m
(0
0
0
r
10
1
10
N(0
r
V)
r
1()
v
r
1()
(n
r
m
5/3/2018 2:56 PM
5/3/2018 2:56 PM
n :�
Nf
O
V
N
N
O
O
T
r•
O
O
LO
O
O
T
et
CO
W
d'
ID
CO
O
O
O
LO
N
O
O
IO
O
O
Cr,
M
O
O
In
C
C
IC
1000'L
O
IO
I+
O
0
N
O
0
ICJ
MC
O
0
LO
O
O
0
O
O
O
O
IO
C
r
255,280
u
0
CO
cC
]Meter 0 & M: FVIR R::rinc+
1.11111111111111111
4u1-/-513-3400-209 GPS Tracking 2,240
401-7-513-1610-101 Accrued OPEB MR 1,100
401-7-513-4000-100 Travel and Per Diem 500
401-7-513-4200-100 Postage, Freight & Shipping MR 100
401-7-513-4100-106 SLERS Radio Maint Fee MR (8x$9x12) 864
401-7-513-4100-107 SLERS Tower Maint Fee MR (8x$9x12) 864
401-7-513-4400-100 Equipment Rental MR 0
1401-7-513-4600-100 R&M Vehicles 2,500
401-7-513-4611-100 R&M Meter Reading Equipment 500
401-7-513-4613-100 R&M Computer Software Sensus 3,250
401-7-513-4618-100 R&M Meter Testing BackFlow 500
401-7-513-4901-100 Education 500
401-7-513-5201-100 Fuel: Gas, Diesel - Vehicles 7,000
401-7-513-5203-100 Uniforms 750
401-7-513-5207-100 T001s 500
401-7-513-5208-100 Supplies 3,500
401-7-513-5400-100 Books, Dues and Publications 500
401-7-513-6400-100 Departmental Expenditure (See D-1) 0
Insect Services
4011-7-513-2500-100 Unemployment Comp MR 0
401-7-536-5215-100 Safety 500
Meter 0 & M Subtotal 25,668
Meter Dept Totals 244,534
r
of
N
r
rl
1n
o
In
In
m =
r W m
1n 10 ID
N tm
m m
10 In
v0 o r
to 0 m m
N h In N
0
0
In
rn
m
0)
o r
m m
N In
N m
01 0
N 11J
7 in
0 0
in In
o
0
0)
r
C1
In
m
m
to
m
m
to
o
0
to
5/3/2018 2:56 PM
5/3/2018 2:57 PM C-18
B C D E
F
G1 H
1
Okeechobee Utility Authority
5/3/2018
2
FY19 Budget
3
NON-OPERATING EXPENDITURES AND TRANSFERS
4
FY18
Budget
Amount
5
FY19
Budget
Amount
6
7
NON-OPERATING EXPENSES:
8
Debt Service Interest Expense:
11
SRF 1 Interest Expense
128,388
72,278
222,900
263,685
687,251
118,027
12
SRF 2 Interest Expense
66,579
14
BB&T 2017A Interest Expense
196,440
15
BB&T 2017B Interest Expense
259,440
16
Total
640,486
17
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,600,000
2,660,000
36
37
TOTAL NON-OPERATING EXPENSES 3,309,451
3,322,686
38
39 (1)
(Effective after FY14, these items will be expenses in year incurred)
5/3/2018 2:57 PM C-18
5/3/2018 2:57 PM
C-19
BIC D E
F
G
H
40
NON-OPERATING TRANSFERS: FY18
FY19
41
Required Transfers:
42
Debt Service Principal Payment & Loan Fee Transfers:
45
SRF 1 Principal
554,475
564,836
46
SRF 2 Principal
246,365
252,064
52
BB&T 2017A Principal
1,095,000
1,125,000
53
BB&T 20176 Principal
150,000
155,000
54
Total
2,045,840
2,096,900
55
Unrestricted/Restricted Revenue Transfers to Restricted Accts:
56
Operating Reserve Fund
73,921
57
Restricted Interest to Restricted Accts. 22,000
34,360
58
Cap Conn Fund Water (infill) 32,750
9,450
59
Cap Conn Fund WW (infill) 30,420
8,808
60
Cap Conn Fund Water 10/20 35,525
0
61
Fire Hydrant Fund 73,250
73,062
62
Emergency Reserve Fund 6,829
24,649
63
Total 200,774
224,250
64
65
Pledged Restricted Revenue Transferred to Restricted Fund Acct:
66
Cap Conn Fund WWTP 10/20 (Direct) 122,773
60,373
67
Cap Conn Fund WWTP 10/20 (Indirect) 0
0
68
Sub -Total 122,773
60,373
69
Less Amount Used Towards Junior Debt Service 0
0
70
Total 122,773
60,373
71
72
Discretionary Transfers -From Restricted Funds:
73
Net Transfer to Rate Stabilization Fund 231,420
$ 187,836
74
Funds Earmarked for 0
0
75
Future CIP Funding 136,569
$ -
76
Total 367,989
187,836
77
Other Transfers:
78
Internal Transfer for CIP Expenditures 6,593,850
6,947,375
79
Internal Transfer for Departmental Capital Expenditures 0
0
80
External Funding from State Grant 1,040,000
1,213,867
81
Total 7,633,850
8,161,242
82
83
TOTAL NON-OPERATING EXPENDITURES AND TRANSFERS 13,680,677 ##
14,053,287
5/3/2018 2:57 PM
C-19
D-1
5/3/2018 2:58 PM
A B C D E F G
1
Okeechobee
Utility Authority
Budget
Additional Departmental Capital Expenditures
5/3/2018
2
FY19
3
Proposed
4
Operating
Capital
5
DEPARTMENT TOTALS
6
ADMINISTRATION
0
350,000
7
MAINTENANCE
0
224,810
8
WATER
0
18,500
9
WASTEWATER
0
127,588
10
METER
0
0
11
TOTALS
0
7.20 898
12
Administration
_----
13
Water master plan: (carryover from FY18 Budget)
175,000
14
WasteWater master plan: (carryover from FY18 Budget)
175,000
16
21
22
Sub Total Administration
0
350,000
23
Maintenance
24
Replace &move tonic at Seminole Village Air Vac
12,275
25
New generator Vac #2 2016 Tradewinds TP125
50,000
26
Jet truck repairs_
75,000
27
Replace 532 with used Chevrolet 2500HD Utility Truck
18,750
28
29
Infra Map System
40,000
30
31
GPRover
28,785
32
Sub Total Maintenance
224,810
33
Water
34
35
36
37
38
Valve Pac III Controllers 6 filters
8,500
39
40
Krebs Fittings (4 sets) Actiflo
10,000
41
42
Sub Total Water
0
18,500
43
Wastewater
44
Tele Handler used w/attachments
70,000
45
Replace 434 w Chevrolet 2500 ext cab 6ft utility body 31,000
46
Replace 430 w Nissan Frontier 4x4 Ext cab v6 26,588
47
48
Sub Total Wastewater 01 127,588.
49
Meter
50
0
51
0
55
Sub Total Meter 0,,
0
D-1
5/3/2018 2:58 PM
d
0
N
0
w
N
a
o.
c
N
O 0
v
c a
>
to
)) rn U
d r
.c oa
[0
0) y
d r
s j. >
0
1--
FY24 FY20-FY24
o o 0 0 0
o o 0 0 0
0 0 0 0
0 0 0 0
o o I
o 0 0
o o 0
0 0 0
0 o (0
LO LO r r
0 0 0 0 0 0
0 0 0 0 0 0
O o 0 0 0 0
0 0 0 0 U)
Ln If) US r N
N N V
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
o O O O o 0 0 0 0 0 0
O N O O O 0 0 0 O N
6 N N In N r LO US N
0 0 0
O 0 0
0 0 O
ri o 0
0 Ln
0 0
O 0
0 O
O m
u
N-
0
0 0 0
0 O O
0 O O
L11 LO
O O O
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 o 10 6 6 6- 6 6
Lo (Li N r tO LLD N
O 0 0
0 O 0
O O O
OO Ln
N US N
0 0 0
0 0 0
0 0 O
O O DI
1n In N
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
O OO O Ln
LI] L!) N
0 00 0 0
0 0 0 0 0
0 0 0 0 0
O O O In n
L() If) N
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 O 0 0 0 0 0 0 0 0 0
Y] O O O Yi O 0 0 0 6 if]
r LL) N Ln N O — Ln O N
r L1]
C)
580,000 612,000
1,030,000 580,000 609,000
0 0 0 0 0 1` O O O O O O N- o 0 0 CO 0 If)
0 0 0 O (O 0 0 0 0 1'- 0 r 0 CO C--
0 0 0 0 CO 0 0 0 0 CO a 0 CO Ln in m
o 0 N L,1 O o N O N O O V 00 CD DI CO DIr 1� r
r
r Ln O N. N O In Nr LO CO r N (O N (n N r r V
CD
(5 (0
a)
to
E.
a) y O a)
N 0 (f) E
>. a) En- E
C ° CO E , >
O O a) c c o
) LE E E m .� ' E
— aal
c n O a) m a] O
CD N ) O > () o y N
CD V 9
Ocu, co 1-5
O X m O CC g R aJ c c
2 'co Q m oo .( � 06 . m LL
cn
fn N D1 O @ .Q N N ❑.
,r s `m (� a) c (o a) `a)
ix N- `m K .1°c 3 . K 0 E a
m a)
C ca o`co o rn -m "lo m m> a):>c
1— Q C> C Lu 0 U m a) m O m
0) U 0 N t (a 6' w mru
Ccn0U' 2 0C i.Ecnw 30
DEPARTMENTAL CAPITAL REQUE
-J
a
1-
0
❑ O r ❑
0 ❑CD Q]
)mFEL':
a)- - 1) c mm`mN(aU) c 3 K
E 0 d
.E c co N `m
N co to 0
D-2
5/3/2018 2:59 PM
1 ITINImV in CON CO
A
B
Okeechobee Utility Authority
FY19 Budget
5/3/2018
Analysis of RR&i Fund
Funding is required to be maintained at 5% of Previous Year System
Operating Revenue.
$10,002,927
FY18 System Operating Revenue (Projected)
FY18 Funding Required at 5% (Fund Balance Required)
500,146
10
11
12
Fund Balance at September 30, 2018 (Projected)
503,777
13
14
Fund Surplus (Deficit)
3,631
15
16
Funds to be Transferred Back to Future CIP Fund
0
17
18
Remaining Fund Surplus
$3,631
19
20
FY19 Funding Budgeted
r
$p
21
22
23
24
25
26
27
28
29
30
5/3/2018 2:59 PM E-1
5/3/2018 2:59 PM F-1
A
B
1
Okeechobee Utility Authority
2
FY19 Budget
5/3/2018
3
Analysis of Emergency Reserve Fund
4
5
(Maintained at 30 days of current year System 0 & M)
6
7
8
FY18 System Operating Expenses (Budgeted)
$7,290,001
9
10
FY18 30 Days 0 & M Expenses (Fund Balance Required)
599,178
11
12
Fund Balance at September 30, 2018 (Projected)
574,529
13
14
Fund Surplus (Deficit)
(24,649)
15
16
Funds to be Transferred into Emergency Reserve Fund in FY19
24,649
17
18
Remaining Fund Surplus (deficit)
($0)
19
21
22
23
24
25
26
27
28
29
30
5/3/2018 2:59 PM F-1
5/3/2018 3:00 PM OS -1
A
B
1
Okeechobee Utility Authority
2
FY19 Budget
5/3/2018
3
Analysis of Operating Reserve Fund
4
5
(Maintain at 90 days expenses of current year System 0 & M)
6
7
8
FY18 System Operating Expenses (Budgeted)
$7,290,001
9
-
10
FY18 90 Days O & M Expenses
1,797,534
11
12
Fund Balance at September 30, 2018 (Projected)
1,723,613
13
14
Fund Surplus (Shortage)
(73,921)
15
16
Funds to be transferred into Operating Reserve Fund in FY19
73,921
17
18
Remaining Fund Surplus
(0)
19
21
5/3/2018 3:00 PM OS -1
A
c
D
E
1
2
3
4
Okeechobee Utility Authority
FY19 Budget
Analysis of Fire Hydrant Fund
5
The fire Hydrant Fund receives revenue of $ 0.50 per water bill per month
to the fund.
6
7
8
9
10
11
12
5/3/2018
Fund Balance at September 30, 2018 (Projected) $99,135
Budgeted Additional Revenue in FY19 $73,062
Interest Earnings Added to Fund Balance (Projected) $0
Budgeted Hydrant Replacement Expenditures in FY19 ($25,000)
Budgeted Repair and Maintenance Expenses in FY19 $0
Projects (TBD)
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
$0
Projected Fire Hydrant Fund Balance at September 30, 2019 $147,197
5/3/2018 3:00 PM H- i
Okeechobee Utility Authority
Debt Service Summary
FYE
Ending
9/30/12
9/30/13
9/30/14
BB&T D/S Sub Total
Int.
Prin.
811,949
782,014
751,170
1,005,000
1,035, 000
1,065, 000
SRF D/S Sub Total
Int.
Prin.
446,067
424,304
332,906
Prepayments included with March 15, 2014 payments
9/30/15
9/30/16
719,455 1,095,000
686,831 1,130, 000
246,958
231,836
Totals 3,751,419 5,330,000 1,682,071
Paid $530,000 and refunded $19,425,000 on 3/29/2017
9/30/17
9/30/18
256,179 510,000
486,585
1,245,000
216,407
200,666
1,058,847
1,080,610
920,304
6,422,932
754,548
769,670
4,583,978
785,099
800,840
Last Updated
08/14/17
Total Annual
Debt Service
3,321,863
3,321,928
3,069,380
2,815,961
2,818,337
15,347,468
1,767,685
2,733,091
9/30/19
455,880
1,280,000
184,606
816,900
2,737,386
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
424,303
1,310,000
168,220
151,502
134,446
117,043
99,288
81,172
62,689
43,830
24,589
4,957
0
1,489,416
833,286
850,004
867,060
884,463
902,218
920,334
938,817
957,675
976,917
495,796
0
11,029,409
2,735,809
2,733,501
2,735,402
2,736,513
2,736,669
2,736,035
2,738,072
2,734,773
2,735,342
2,233,814
1,731,083
391,995
1,340,000
358,896
1,375,000
325,007
1,410,000
290,164
1,445,000
254,530
1,480,000
216,566
1,520,000
173,267
1,560,000
128,836
1,605,000
83,061
1,650,000
36,083
1,695,000
3,881,350
19,425,000
35,825,174
Total debt at beginning of fiscal year
Total principal paid during fiscal year
Total debt at end of fiscal year
$ 29,159,310
$ 2,045,840
$ 27,113,470
4/25/2018 5:13 PM
K-1
Okeechobee Utility Authority
Debt Service Summary - BB&T Bank Debt
FYE
Ending
BB&T 2017A
Int. 2.40% I Prin.
Last Updated
08/14/17
BB&T 2017B
Int. 2.83%
Paid $530,000 and refunded $19,425,000 on 3/29/2017
9/30/2017
4/1/2018
9/30/2018
4/1/2019
9/30/2019
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
Prin.
BB&T Total
Debt Service
121,333.33
114,720.00
108,180.00
101,580.00
440,000.001 1
545,000
550,000
560,000
94,860.00 565,000
88,080.00 570,000
81,240.00 580,000
74,280.00 585,000
67,260.00 595,000
60,120.00 600,000
52,920.00 610,000
45,600.00 615,000
38,220.00 620,000
30,780.00 630,000
23,220.00 635,000
15,600.00 645,000
7,860.00 655,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
134,845.57
132,373.25
131,312.00
70,000.00
75,000.00
75,000.00
766,178.90
867,093.25
864,492.00
130,250.75
75,000.00
866,830.75
129,189.50
80,000.00
869,049.50
128,057.50
80,000.00
866,137.50
126,925.50
80,000.00
868,165.50
125,793.50
80,000.00
865,073.50
124,661.50
80,000.00
866,921.50
123,529.50
85,000.00
868,649.50
122,326.75
80,000.00
865,246.75
121,194.75
85,000.00
866,794.75
119,992.00
90,000.00
868,212.00
118,718.50
90,000.00
869,498.50
117,445.00
90,000.00
865,665.00
116,171.50
90,000.00
866,771.50
114,898.00
90,000.00
867,758.00
113,624.50
755,000.00
868,624.50
102,941.25
765,000.00
867,941.25
92,116.50
775,000.00
867,116.50
81,150.25
785,000.00
866,150.25
70,042.50
795,000.00
865,042.50
58,793.25
810,000.00
868,793.25
47,331.75
820,000.00
867,331.75
35,728.75
830,000.00
865,728.75
23,984.25
840,000.00
863,984.25
12,098.25
855,000.00
867,098.25
1,125,853.33 10,000,000.00 2,755,496.32 9,425,000.00 23,306,349.65
A VI=11/1.10 L.4/, flRA
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
9/30/14
SRF # 1
SRF # 2
Int. 1.86%
Prin.
94,955 1,190
189,876 2,414
191,207 246,369
186,683 496,179
177,412 505,451
167,966 514,896
Int. 2.3%
Prin.
95,151
222,466
214,572
207,717
197,781
141,358
224,518
414,686
422,839
429,526
439,461
336,586
Prepayments included with March 15, 2014 payments 4,022,441
9/30/15
9/30/16
158,345 524,518
148,543 534,319
88,614 230,030
83,292 235,351
9/30/17 138,559 544,304 77,848 240,795
9/30/18
128,388
554,475
72,278
246,365
SRF # 3
Int. 1.91%
Prin.
0
0
46,564 145,126
53,499 134,536
51,666 133,142
49,111 135,698
23,582 68,822
2,400,491
0 0
0 0
0
0
0
0
Last Updated
08/14/17
SRF Total
Debt Service
415,814
1,021,132
1,263, 023
1,504,914
1,504,914
1,253,210
6,422,932
1,001,506
1,001, 506
1,001,506
1,001,506
9/30/19
118,027
564,836
66,579
252,064
0
0
1,001,506
9/30/20
107,472
575,391
60,748
257,895
0
0
1,001,506
9/30/21
96,720
586,143
54,783
263,861
0
0
1,001,506
9/30/22
85,767
597,096
48,679
269,965
0
0
1,001,506
9/30/23
74,609
608,253
42,434
276,210
0
0
1,001,506
9/30/24
63,243
619,619
36,045
282,599
0
0
1,001,506
9/30/25
51,665
631,198
29,508
289,136
0
0
1,001,506
9/30/26
39,870
642,993
22,819
295,824
0
0
1,001,506
9/30/27
27,854
655,008
15,976
302,667
0
0
1,001,506
9/30/28
15,615
667,248
8,975
309,669
0
0
1,001,506
9/30/29
3,146
338,285
1,811
157,511
0
0
500,753
9/30/30
0
0
0
0
0
0
0
Totals
2,265,920
10,410,183
1,789,434
10,200,000
224,422
3,017,815
27,907,774
K-3
d/7r,/ fllfE 5. 17 DNA
Okeechobee Utility Authority
FY19 Budget
Notes to Labor Costs
Page Line
5/3/2010
L-2
X 143
Total Budgeted Labor costs as presented:
$3,865,757
The above amount includes labor costs for all positions expected to be utilized
in fiscal year.
A 1.0% Cost of Living Allowance has been included in the accompanying
Budget totaling:
$25,546
A 1.5% Merit increase has been included in the accompanying Budget totaling:
$51,733
A 1.5% Bonus has been included in the accompanying Budget totaling:
$45,429
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:
$2,547
A 1.0% increase in the Pension Contribution rate totaling:
$35,417
L -a
5/3/2018 3:00 PM
5/3/2010 3:02 PM
_
fir
=
<
_
_
n
-
mi
rvr=
=gc
t.R-
_
__
LT,
ry
n
0--
-ui
_
-
R
_
n
_
'
cI
_
a
�i
-
-
N
-- — ' 1 u 1 ti I 5
_ r'I
of
11111
_
'
'�
a ;'t!;!
- n
404,0091
m-
rv�
c
-,
'egg
n
_
r
'
{
PI
NII
.t.-
-
-
_ a
1 1
1,200 64,2241 3,237 100 24 190 10,004 7,440
4,976 266,316 13,422 1,440 192 1,012 41,014 59,520
0 0 0 0 0 0 0 II
0 01 0 o 0 o o 0
0
-
c
=
q
ry
[-
=
e n
o
-
n
:Ii
r
n
-
cl
n
-r
,t
-
^
o.
c
L.
n
vl
^
N
a
=l
R
n
N.
u
r
O,74
�
a
v,
c
e =I
e„ n
-
',I1
r
-
_ -
-7
id
_
,.i
h.
o
U
a
_
'
n
ry
x
-
ry
_
n
T
_
2I
-
-
I
-
-
ry
iv! afirurvisor
miler Support
On Coll
--_Overllve._
Meter Reader
� '
LL
-
-
c
-
u
E "
_--
e N-
a
Z
h
L
t
L
p
c
Urgent Care Services)
- u
' O�
-
_ 1
5 ulnntal Wastewater Supervisor]_
_?`
L
EOe
.7 E
U O
�
t
;—'T.
v''
=
y
j
y
_-
-7.-g-
U
Lt.
0
U=
F -
m V
E E
fo
L.
p
'
- U
O.,
in
-
y
t1
O
_
__
-
a
Subtotal Meter R
.SIIIrtnbd Mal
Subtotalh
_
I
1 I
_
-_
v
i-
e
6
O
o
0
0
.-
.- mI
fl ml m
o
.-
_
.-
.-
--.-
.-
.-
.-
.-
r
,
5/3/2010 3:02 PM
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
A
8
C
D
E
F
Okeechobee Utility Authority FY19 Budget
Projected General In -Fill Revenue
Approved Rates from Resolution 17-07, Effective October 1, 2017
WATER
G
H
5/3/2018
WASTEWATER
Capital Connection Charge Revenue
Projected
Projected
Connections
Connections
Added in Revenue Total CC Added in Revenue Total CC
FY19 Per CC Revenue FY19 Per CC Revenue
25 $378.00 $9,450.00 12 $734.00 $8,808.00
Install Fee Revenue
Revenue Per Total Install Revenue Per Total Install
Residential Mtr Fee Revenue Connection Fee Revenue
25 $212.00 $5,300.00 12 $487.00 $5,844.00
Accrued Garanteed Revenue Charges (AGRC)
AGRC Per 1 ERC Total AGRC AGRC Per 1 ERC Total AGRC
Connection (1) Revenue Connection (2) Revenue
Oct -18 2 582.01 1,164.02 1 830.55 830.55
Nov -18 2 586.08 1,172.16 1 838.46 838.46
Dec -18 2 590.15 1,180.30 1 846.37 846.37
Jan -19 2 594.22 1,188.44 1 854.28 854.28
Feb -19 2 598.29 1,196.58 1 862.19 862.19
Mar -19 2 602.36 1,204.72 1 870.10 870.10
Apr -19 2 606.43 1,212.86 1 878.01 878.01
May -19 2 610.50 1,221.00 1 885.92 885.92
Jun -19 2 614.57 1,229.14 1 893.83 893.83
Jul -19 2 618.64 1,237.28 1 901.74 901.74
Aug -19 2 622.71 1,245.42 1 909.65 909.65
Sep -19 3 626.78 1,880.34 1 917.56 917.56
Totals 25 $3,783.07 12 $2,622.17
Statictical Data:
Water Wastewater
Projected Number of active connections
Beginning of Fiscal Year 9230 4216
In -fill Growth rate 0.271% 0.285%
Average cost per new connection $741 $1,440
(1) AGRC for Water increases by $4.07 per month.
(2) AGRC for Wastewater increases by $7.91 per month.
5/3/2018 3:02 PM
N-1
0
La
0
0
0
5/3/20113 3:06 PM
UP
0
00
or
o
o
ni
in
co
nr
in
III
o
3Enrt
.,
I
10
IIS
Ell
II
0
co
to
340,054 234,500 000,320 1,013,010 510.045
all
,"4::
0
in
iii.
2.970.930 I
En
a
o
o
�o
o
N
N
111
Scads System
Gener LTt 51
boem)
Gravity Sever Repair Rehabilitation
LRt
—J.._R M1
a a pbllllatmns
Manhole Rehabilitations
r
Not General Ullllly Operating Revenue
BOST Debt Service Payments
Wastewater CCC from 10420 Developers'
Fire Hydrant Fund Fees
Wafer CCC from Infill
WssteWater CCC from Infill
Waley CCC from 10/20 Developers
Restricted Interest Income
Rale Revenue from FY10 & FY11 Rate Increases
SRF Debt Service Payments (required)
tntentund transfers from Operating Budget
Infer -fund transfer from FY16 Budget Surplus to be made FI
Net 5ourco of Funds from Oporallons
Fund Balances Before Capital Expenditures
Use of Funds for Water Capital Pmfeer,
SE 8th Ave Wafer Main Inslalalion
SE 13th Drive Water Maln Installalion (55001)
Maintenance _.
Water
TOTAL
'talented Fund Bal Reserves at Sept 30, 2019
5/3/20113 3:06 PM
A
8
C
D
E
F
G
H
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
18
19
20
21
22
23
24
25
26
27
28
29
30
Okeechobee Utility Authority
FY19 Budget
10/20 Plan Developer CC Revenue
Developer Short Name
Northshore Village, Inc.
Stephen E, Myers, SR
Stephen E, Myers, SR
Stephen E, Myers, SR
Total
(Projected Transaction Details)
Developer
Commitment for
Tax Yr 2018
(OUA FY19
Revenue)
25.800.00
28,702.79
1,088.86
4,408.35
34,200.00
Early Payment
Discounts Taken
& Tax Collector's
Fee Paid (1)
(1,527.36)
(1,699.21)
(64.46)
(260.97)
5/3/2018
Net Assessment
Payment by
Developer (1)
$ 60,000.00 (3,552.00) $
24,272.64
27,003.58
1,024.40
4,147.38
56,448.00
(1) Based on previous year payment history.
(2) Does not include interest to be charged on assessment balance or recovery of
prior year Tax Collector's Fees as per terms of First Amendment to Standard
Developer's Agreement.
The revenue to be received in FY19 from these items are estimated to total:
$ 6,627.42
P-1
5/3/2018 3:07 PM
Fiscal Year October 1, 2018 to September 30, 2015
7 N CO tO
mm 0 CO N.-. CD
et O CO (D c] CO
CO CO n N
O I�'Cr C N
co- M c0 r
K3
M
LO
M
et
05
d) et LO 0 CO O CO N- N
0 (O O) CO CO co o O) (O (O
O) el- CO O) N 7 O O) CO N
M N 2) CO- (O O (D C) (7
01 N CO N (n V 0) (O r 1-
(O COO O O N CO O N N e'
N
r r N N r Co
= 63
U�
z W
z
❑ z
D
w0
N N
_
0
F
LU
?�® ¢ ww❑❑
❑❑w
"5_ i_
cW �i>--W (n
U� ° dz�W-¢¢FF' m
W WHF m DZ¢5iF ouJ D
> > W W N W W 2>- H
Z Z n e W F'F-Z K}? -
w w00 0H Cn�h¢dzo
>W>CCCC
W W D W d W ®¢¢¢❑ W �" J O z
DI 3 ¢ F W
z} W Zzz EcnU ch um)(n w0-U_X
w�W O W W 3fn(n WWWEn UWW
_ �� wzra
K F- -I U w W e W W W W W~ g3 U
> ¢ w 0 0 n_ a a w d z CL,w pc❑
= W W Z z° W W W W W W 0 05 0
U U ❑
LIJ zCO ¢ W W Z Z Z Z Z O (rf Z
m� Wim¢¢¢ !n HH t -1 -HW WU_w
w W HwH I- I- Z¢¢¢¢¢(n(nm1—
> CO 2 d d d w LB W W W W cn h Z Z
owwwwwmm¢¢
W Q¢ ¢¢¢ wawn.w W wCC�
DC 0OOO w00000❑❑1HC7
TOTAL EXPENSES
BUDGETED SURPLUS OR (DEFICIT) $
5/3/2018 3:07 PM