HomeMy WebLinkAboutRes2017-061CITY OF SEWARD, ALASKA Sponsored by: Hunt
RESOLUTION 2017-061
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
SEWARD, ALASKA, ADOPTING THE WATER ENTERPRISE FUND
BIENNIAL BUDGET FOR CALENDAR YEARS 2018 AND 2019
WHEREAS, the City Manager has submitted to the City Council a proposed biennial
budget for the City of Seward for Calendar Years 2018 and 2019; and
WHEREAS, the preliminary biennial budget was reviewed by the City Council in
budget work sessions on September 27, October 2, and October 3, 2017, which were televised to
the public; and
WHEREAS, a public hearing is scheduled on the proposed budget for October 23,
2017, and a second public hearing and final adoption is scheduled for November 27, 2017; and
WHEREAS, the water enterprise fund has begun repaying debt on a major Third
Avenue water main loan, necessitating rate increases to coverthe cost of debt service and other
operational needs, with rates slated to rise 2.1 % in 2018 (five-year average CPI) and 1.6% (five-
year average CPI) in 2019.
NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE
CITY OF SEWARD, ALASKA, that:
Section 1. The Water Enterprise Fund budget for Calendar Years 2018 and 2019 which
is attached hereto and made a part hereof by reference and which contains estimated revenues
and expenses for the period January 1, 2018 - December 31, 2019, is HEREBY ADOPTED, and
the necessary funds are hereby appropriated.
Section 2. This resolution shall take effect immediately upon adoption.
PASSED AND APPROVED by the City Council of the City of Seward, Alaska, this
27'' day of November, 2017.
THE CITY OF SEWARD, ALASKA
David Squires, Mayo
CITY OF SEWARD, ALASKA
RESOLUTION 2017-061
AYES:
Casagranda, Keil, McClure, Slater, Towsley, Horn, Squires
NOES:
None
ABSENT:
None
ABSTAIN:
None
ATTEST:
I&JA-f �, '
Ble@a J. Ballou, K4MC
City Clerk
(City Seal) OF ssbk
j.
go
_ • SEAL = •
q• .......,••
OF
1
WATER ENTERPRISE FUND
Budgeted Statement of Revenues and Expenses
and Change in Net Position.
For 20I8 and 20I9
2016
2017
2018
2019
Actual *
Budget
Budget
Budget
Operating revenue:
Residential
48I,202
453,600
477,7I9
476,492
Small General Service
131223
I27,656
130,337
I32,422
Large General Service
229,373
2I5,604
220,132
223,654
SMIC Sales
47,066
59,208
60,451
6I,4I9
Special Contract Sales
245,585
278,700
284,553
289,I06
Miscellaneous
64,564
90,996
I40,412
144,393
Charges for Services - Ship Water
93,877
82,500
84,233
105,580
Total operating revenue:
$1,292,890
$1,308,264I,39
,8$1,433,066
Operating expense before depreciation:
Salaries & Benefits
4I9,349
435,832
367,I66
370,259
Purchased services
247,002
396,012
384,300
385,500
Supplies & Maintenance
44,726
97,200
90,500
89,500
General & Administrative
254,288
279,972
284,549
288,691
Total operating expense:
$965,36S
$1,209,016I
,I33,950
Operating mcoeoe before depreciation 327,525 99,248 271,322 299,116
Depreciation 200,323 I86,996 392,I99 392,199
Operating income (loss) $127,202 8 -$120,877 493,083
Non -operating revenues (expenses)
Interest income 6,643 7,008 7,I55 7,270
Other revenue 8,972 0 0 0
Interest expense-24,098-23,700-21,697-I9,669
Total noa-°P-U-6 - (-P--) - 8,4 - I - I4, ,
Eamiags before transfers and cmmbw,=,
Transfers Out
Transfers In
Capital contributions and special items
Change in net position
Beginning net position
Ending net position
$I18,719
-$104,440
-$135,419
-$I05,482
-600,748
-II3,40I
-II6,633
-II4,S42
98,0I0
0
0
0
0
0
0
0
-$384,0I9
-$2I7,941
4252,052
4220,024
$10,492,561
$IO,I08,S42
M390,70I
$9,638,649
$IO,I08,542 a
$9,890,701
$9,638,649
$9,4I8,625
* Ties to annual Comprehensive Annual Financial Report
Of total depreciation expense, the following amounts were attributable to capital assets funded with capital contributions:
(a) $24,402 or II%; (b) $22,224 or I I%; (c) $I86,036 or 47%; (d) $209,090 or 53%
CITY OF SEWARD
WATER ENTERPRISE FUND
Budgeted Statement of Cash Flow
For 2018 and 2019
Beginning cash balance at 111115: *
Cash is provided by (used for):
Change in net position
Add expense items not affecting cash:
Depreciation
Net cash provided by (used for) operations
Other sources (uses) of cash
Debt principal payments
Capital outlay
Net increase (decrease) in cash
Estimated ending cash balance
2017 2018 2019
Budget Budget Budget
$1,170,000
(2I7,84I) (252,052) (220,024)
I86,996 392,I99 392,199
(30,845) I40,I47 I72,I75
(I33,I52) (135,I47) (I67,I75)
(5,000) (5,000)
(I63,997)
$I,006,003 $I,006,003
(*) Ties to CAFR and includes only Water Enterprise Fund; excludes related capital projects.
$ I,006,003
Notes;
Water Fund has not transferred funds to NMRF in 20I6, 20I7, 20I8 or 20I9 due to new 3rd Ave. Water Line debt payments.
City of Seward
Water Enterprise Fund
2018/2019 Biennial Operating Budget
Revenue Detail by Line Item
2016 2016 2017 2018 2017-18 2019 2018-19
Actual Actual Budget Budget % Chg Budget % Chs,
Revenues
17000 5300 Residential
17000 5310 SG Service
17000 5320 LG Service
17000 5330 SMIC Sales
17000 6340 Spec. Contracts
17000 5801 Turn on Fees
17000 5804 Work Order Revenue
17000 5806 Ship Water
17000 5807 Hydrant Rentals
17000 5899 Miscellaneous Revenue
17000 5901 EF Investment Interest
17000 5905 EF Penalties and Interest
17000 5919 Contra PERS On -behalf paid by SOA
17000 5920 PERS On -behalf paid by SOA
17000 5940 Amort. of CIA - General
455,795
481,202
453,600
477,719
5.32
476,492
(0,26)
132,772
131,223
127,656
130,337
2.10
132,422
1.60
210,460
229,373
215,604
220,132
2.10
223,664
1.60
49,367
47,066
59,208
60,451
2.10
61,419
1.60
266,801
245,595
278,700
284,653
2.10
289,106
1.60
8,497
11,182
9,996
10,206
2.10
10,369
1.60
1,500
0
0
0
0.00
0
0.00
107,264
93,877
82,500
84,233
2.10
106,580
25.34
55,799
55,572
121,470
120,000
(1.21)
123.655
3.05
6,741
(2,190)
9,996
10,206
2.10
10,369
1.60
18,384
2,393
5,004
5,109
2.10
5,191
1.61
10,532
4,250
2,004
2,046
2.10
2,079
1.61
(34,315)
(593)
0
0
0.00
0
0.00
46,777
9,565
0
0
0.00
0
0.00
24,472
24,402
22,224
186,036
737.10
209,090
12.39
Total Revenues $ 1,349,836 $ 1,332,907 $ 1,387,962 $ 1,591,028 $ 14.63 $ 1,649,426 $ 3.67
City of Seward
Water Enterprise Fund
2018I2019 Biennial Operating Budget
Expenditure Line Item by Fund
2015
2016
2017
2018
2017-18
2019
2018-19
Actual
A
B t
et
Budget
a Ch
Personnel Costs:
6000 Salaries
176,034
160,656
223,616
183,556
(17.91)
181,616
(1,46)
6001Overtime
23,137
8,440
4,608
4,192
(9.03)
4,226
0.81
6002 Standby Time
11,394
8,515
11,076
9,754
(11.94)
9,862
1.11
6100 Medicare
2,922
2,937
3,648
3,428
(6,03)
3,387
(1.20)
6102 Workers' Compensation
7,639
7,781
9,240
12,191
31.94
12,141
(0.41)
6200 Leave Time
33,877
11,496
23,496
18,745
(20.22)
20,420
8.94
6201 Retirement Benefits
113,855
137,889
61,152
43,874
(28.25)
44,470
1.36
6202 Health Insurance
69,796
81,174
98,504
91,426
(7,19)
94,137
2.97
6203 In Lieu of FICA
443
461
492
0
1100.00)
0
0W0
Total Personnel Costs;
$ 439,097 $
419,349 $
435,832 $
367,166
$ (15.76) $
370,259
$ 0.84
Non -Personnel Costs:
7000 Audit
132
0
0
0
0.00
0
0.00
7001 Communications
10,829
9,208
12,000
11,000
(8.33)
12,000
9.09
7002 Postage and Freight
2,580
2,443
6,504
6,500
(0.06)
6,500
0.00
7003 Bank and Credit Card Fees
6,251
6,782
6,000
6,000
0.00
6,000
0.00
7004Insurance
11,346
12,150
9,996
10,800
8,04
11,000
1.85
7006 Legal
0
0
6,000
5,000
(16.67)
5,000
0.00
7009 Contracted Services
47,130
22,824
80,004
75,000
(6,25)
75,000
0.00
7011 Testing
8,085
4,796
11,508
11,000
(4,41)
11,000
0.00
7015 Utilities
177,953
1135,732
264,000
269,000
(1.89)
259,000
0,00
7016 Heating Fuel
1,199
3,067
0
0
0.00
0
0.00
7210 Vehicle Supplies
0
1,361
0
0
0.00
0
0.00
7211 Gas & Lube
14,678
4,844
10,500
10,500
0.00
10,500
0.00
7213 Safety Equipment
2,075
2,052
3,000
3,000
0.00
3,000
0.00
7215 Operating Supplies
113,212
23,869
48,504
44,500
(8,25)
44,500
0.00
7216 Maintenance & Repair
8,043
6,367
28,500
26,000
(8.77)
25,000
(3.85)
7217 Small Tools & Equipment
7,429
6,234
6,696
6,500
(2.93)
6,500
0.00
7300 Advertising
79
0
1,500
1,000
(33.33)
1,000
0.00
7301 Subscriptions & Dues
1,937
880
1,762
1,700
(2.97)
1,700
0.00
7302 Travel & Subsistence
752
3,611
5,604
5,600
(0.07)
5,600
0.00
7303 Education & Training
105
2,507
5,604
5,600
(0.07)
5,600
0.00
7304 Equipment Rent
12,150
1,350
9,996
8,000
(19.97)
8,000
0.00
7307 GF Administrative Fee
239,611
245,122
261,004
258,849
3.13
262,991
1.60
7330 P.I.L.T.
106,155
103,606
108,660
110,660
1.84
108,669
(1.89)
7331 Reclass PILT to Transfer -Out
(106,166)
(103,606)
(108,660)
(110,660)
1.84
(108,569)
(1,89)
7808 Bad Debt Expense
1,768
715
2,004
2,000
(0.20)
2,000
0.00
7810 Miscellaneous Expense
247
103
2,508
1,800
(28.23)
1,800
0.00
7900 Depreciation Expense
199,645
200,323
186,996
392,199
109.74
392,199
0.00
8012 Debt Service Interest Expense
25,826
24,098
23,700
21,697
(8.45)
19,669
(9.35)
8103 Capital Equipment
0
0
0
0
0.00
0
0.00
8104 Motor Pool Rent
4,500
0
0
5,000
0.00
5,000
0.00
8300 Debt Service Principal
129,658
131,182
133,152
135,147 _
1.50
137,175
1.50
Total Non -Personnel Costs;
$ 932,120
$ 901,620
$ 1,117,032
$ 1,313,392
$ 17.58
$ 1,317,734
$ 0.33
Total Expenditures
$ 1,371,217
$ 1,320,969
$ 1,552,864
$ 1,680,558
$ 8.22
$ 1,687,993
$ D.44
O
N
1v
0
ro
0
O_
rD
X
rD
a
M
1z
1r
W
w
00
cn
70
m
rD
n
rD
o'
3
0
1s
v
aj
3
ai
ro
Fs
V
rt
3
rD
r-r
S
w
3
Y
F-�
00
S
rD
Du
rr
S
C1
SL
(DD
0
1T
M
d
LZ
Q
(D
0-
NJ
0
F-
PO
m
S
m
S
N
O a)
p-
C
O
En
N
a
C
cu
iA LA
3
i11
LA
CD
o
nn
2
ro
a
Lnro
m
n
O
rr
r
j
n
O
rt
ro
-a
O
p}
rD
w
3
rD
O
n
0
n
0
a)m
0
3
3
M
0
r
m
00
ro
0
0
In
CDo
r+
ro
ro
r
W
rn
w
a,
w
co
w
4
o
r
w
N
w
kO
V
Lrl
00
N)
V
4�,
Ln
ih
n
i/F
h
w
w
w
w
�.
V
F
—
U7
V7
1—
F-
U1
Ln
3 N
V
v
3 1y
r*o
fD
N
N
rt
N 00
to
Lo
M LDD
:"'
�''
�
Cl
Ql
r+ OD
Ln
C
01
Q1
rr W
C
La
�
CL
NrF
V
C
fD r%*
In
rt
N
N
N
b1
N
01
7
O
O
�
r r
V
�I
r+
00
?
N
I
Ln
Ol
y_
00
W
61
Ln
)
SSUy
hi
LU
00
cri
00
00
ro
G
�hco
U1
W
Fi
W
01
w
W
W�
00
I -a
Ft n
(M
Lrito
Ln
1
~
W
NJN
�
V
v
F�
00
1p
LU
O
O
N
CD
O
No
O
W
w
N
3
w
w
o
oNJ
V
V
N
O
N
00
m
an
c m n_
LD m
o Z Q
9 � to
N 0 m
CD M
�. rri
CD c v
LA Z
m
Q
c
M
CITY OF SEWARD
WATER ENTERPRISE FUND
Budgeted Interfund Transfers
2018 and 2019
2018 2019
Transfers- Transfers- Transfers- Transfers -
In Out In Out
General Fund:
Federal and state lobbying $5,973 $5,973
Payments -in -Lieu -of -Tax 110,660 108,569
$0 $116,633 $0 $114,542