09/29/2017 - PacketPort Orchard
Council Finance Committee
September 29, 2017
7:3o am Council Conference Room
City Hall
1) Finance Report Treasurer Martin
a. Sales Tax Revenue Report
b. Treasurers Report — Funds, accounts
2) Tremont Widening Project
a. Construction Finance Plan
3) Mid -biennial Review
Other Items to come before the Committee
Schedule Next Meeting Date
Role of the Finance Committee
Finance Director, Noah Crocker
Finance Director, Noah Crocker
The finance committee provides oversight of city budgeting, financial planning, and financial reporting. The committee recommends long-range
financial goals along with funding strategies for the operating and capital budgets. Human resource issues requiring policy direction are brought
before the committee. The committee serves as the advisory forum for transportation and street maintenance funding, and funding relating to the
transportation benefit district.
C
u
a
Y
d
F
OD
M N n0% •+ w M-
ryocoo+�D�Dn a
M �D N Ali n 06 V) 6. M 7
0 0 0 0 0 0 0 0
O � n N O� N '+ V)
M N O It - O O N
7 N M w O m 7-
w O M O O IDM N
�n���vo0ivni�
,, M M n w M M
vrNirNiraOic`�+�aaa
-+ O
O O` CO OO0 N
N O-+
OO
O
lD O
O
Cl)
V) o0 N00N 'O
'D
O
0aaNn
a
O
7 0
(V
•+
'+
n o
O N O n 07
N
N O
0
N
N
� O
M n �O �0 D O�
•+
O OD
7
a
Co aq°hNONotl�°irn°a
ON 0 t- 00 00 m D� of m w w
O n M N n 'D n v '+ 00 N O
N 7 O� M c0 N .+ c �D O N cc
0
It N M a` 00 10 O 10 N 7 1
D; M �O 00 7 I: O �O D? N n ,y
dam' O 'C' oc� n .+ ' S O N
7 M M M M M 7 M M 7 M
m 0 7 7 0 n n M •+
M 7 7 N N 7 N N 0 O Ncl
o � rn vNi v�i rn N voi rn a�
7 N M M m M M M M M M
N co m 00 10 n 7 0 O V)
n n n O N 10 M n M O O x
00 M lO M n O` 0, 7 O a- "D in
� 0 O 00 N- 0 7 m N 0 .+
N M N N M M M M m M m M
n
n
y b O n
Ob,
Oo 00 Q
00 ti Q
h
•-+ Q` -+ N N M M M M M M
N
N 00
0
a
n
vmi
o6 NI
O
V)
M
6
n
O N
M
�D
n
n
n N
V)
V)
Cl)
Co
1O
N tr
N
N1
O
V)
�D
to -
�o
N
10
10
Cl)
m%D�Dt�101n
It Vi
Ni
O+
00
M
rn o
m�o
rn
a
rn a
N
n
to
v>
co n
ci
Ni
Vi
n
Cl)
O-+
'+
N
N
Cl) V)
V)
m
V)
Cl)
� NU)
O
.�i
D`
co n
n
%0
N
n-
•+a�o
nn
I : '+
O
00
N
n
O�
m 00
O
O
V)
n
N11
It
00
N
pV)
lO
N
-n+
O,
-
7
7
N
p
O N
N ,Oy
V) M
n a
M
�
N
CO
.+
V)
O
00
7
n
00
m
W
N7
ID
n
N'
%D
Nrl
O�
%O
10
•+
O
b
m
�R
0
00
V)
00
co
co
N
0
O
N
fR
O
O
to
n
to
A w A p o m Y
V y N N A G C m G '�
P� ro 7 aai c�'i o v E" s PO
w ¢ �ti¢m0zCa Ua
O
of
�D
M
m
c
7-
m
w'
O
0
7
N
M
M
N
qD
N
O
M
M
O
q o
ai
a
--
•+
o
v
ni
w
D`
n
O
D`
M
m
O
N
N
00
w
n
W
m
co
tD
D:
N
00
00
V)
m
w
W
N
Y
6
N
N
N
(3
0
CN
n
LO
N%
[Urr
W O
O
M
�o
w
N
m
'+
O)
w
N
W Ooo
mtDtl�
-.a
aoIqID
cl
N
0
M%
M
0
F
M%
to
M
M
d
Y
�
w
e�
¢�
¢
UP
z
o
General Ledger
Cash and Investment
Totals
User: hdraper
Printed: 09/25/17 08:56:12
Period 08 - 08
Fiscal Year 2017
City of Port Orchard
216 Prospect Street
Port Orchard, WA 98366
(360)876-5139
www.cityofportorchard.us
Account Number Description Bea Bal Period Amt End Bal
001
Current Expense
2,154,110.38
-17,249.63
2,136,860.75
002
City Street Fund
928,088.24
-51,635.23
876,453.01
003
Stabilization Fund
842,103.99
866.03
842,970.02
General Funds
3,924,302.61
-68,018.83
3,856,283.78
103
Criminal Justice
408,144.42
11,555.44
419,699.86
104
Special Investigative Unit
67,978.78
272.91
68,251.69
107
Community Events
128,685.07
10,633.68
139,318.75
108
Paths & Trails
6,390.96
115.78
6,506.74
109
Real Estate Excise Tax
1,665,375.75
71,141.78
1,736,517.53
III
Impact Mitigation Fee
1,311,472.44
139,835.42
1,451,307.86
Special Revenue Funds
3,588,047.42
233,555.01
3,821,602.43
206
Bond Redemption Fund
0.00
0.00
0.00
Debt Service Funds
0.00
0.00
0.00
302
Capital Construction
169,507.99
-5,561.80
163,946.19
303
Cum Res Equip Replacement
442,377.37
439.55
442,816.92
304
Street Capital Projects
1,442,072.36 -
5,741,121.33
7,183,193.69
Capital Projects Funds
2,053,957.72
5,735,999.08
7,789,956.80
401
Water -Sewer Utilities
3,038,960.79
221,656.50
3,260,617.29
402
Water -Sewer Equip Replace
317,165.13
300.28
317,465.41
403
Water -Sewer Cumulative Reserve
4,963,478.03
27,169.85
4,990,647.88
Water Sewer Funds
8,319,603.95
249,126.63
8,568,730.58
421
Storm Drainage Utility
1,366,656.67
60,849.90
1,427,506.57
422
Storm Drainage Equipment Repla
152,145.12
160.47
152,305.59
423
Storm Drainage Capital Facil
698,583.73
736.83
699,320.56
Storm Drainage Funds
2,217,385.52
61,747.20
2,279,132.72
621
1984 Refunding
4,800.43
0.00
4,800.43
631
Trust and Agency
7,143.02
4,146.78
11,289.80
632
Wastewater Treatment Facil Fee
2,313,922.69
9,532.03
2,323,454.72
Trust & Agency Funds
2,325,866.14
13,678.81
2,339,544.95
Grand Total
22,429,163.36
6,226,087.90
28,655,251.26
GL - Cash and Investment Totals (09/25/2017 - 8:56 AM) Page 1
General Ledger
Fund Balance Reserves
User: Kpearson
Printed: 09/27/ 17 11:35:58
Period 08 - 08
Fiscal Year 2017
Account Number
Description
End Bal
109.0-508.30-01
Restricted End Fund Bal-BEET 1
$
482,971.93
109-0-508-30-02
Restricted End Fund Bal-BEET 2
$
1,253,545.60
109
Real Estate Excise Tax
$
1,736,517.53
111-0-508-30-00
End Restr Fund Bal-MW Trans
$
489,777.48
111.0-508.31-00
End Restr Fund Bal - Parks
$
301,188.61
111-0-508-32.00
End Restr Fund But - McWdParks
$
39,334.04
111-0-508-33-00
End Restr Fund Bat - Bayside
$
250,157.81
1 I1-0-508-34-00
End Restr Fund Bal-Transportat
$
370,849.92
III
Impact Mitigation Fee
$
1,451,307.86
TREMONT WIDENING CONSTRUCTION PROJECT
FINANCE PLAN
MONTH: 6/1/2017
7/1/2017
8/1/2017
9/1/2017
10/1/2017
11/1/2017
12/1/2017
1/1/2018
2/1/2018
3/1/2018
4/1/2018
Estimated Expenditures:
Budget:
Schedule A -Roadway Improvements
8,797,050
253,355
336,047
504,071
504,071
462,725
462,725
462,725
462,725
546,297
546,297
Schedule A - Storm drainage
1,692,464
48,743
64,652
96,978
96,978
89,024
89,024
89,024
89,024
105,102
105,102
ScheduleB-Water795,489
0
120,278
0
40,093
36,115
200,463
0
0
12,012
80,185
Schedule C-Sanitary Sewer
498,245
0
49,326
0
7,025
0
0
0
0
28,201
84,552
Schedule D-Underground Utilities
990,373
0
116,468
45,260
6,437
0
0
45,260
77,645
161,728
161,728
ScheduleE-SanitarySewer
5,559
0
2,527
2,527
505
0
0
0
0
0
0
Change Orders
Additional Costs
5/1/2018
6/1/2018
7/1/2018
8/1/2018
9/1/2018
10/1/2018
11/1/2018
12/1/2018
1/l/2019
2/1/2019 3/1/2019
4/1/2019
5/1/2019
525,184
504,071
504,071
504,071
462,725
420,499
420,499
378,273
293,821
242,799 0
0
0
101,040
96,978
96,978
96,978
89,024
80,900
80,900
72,776
56,528
46,712 0
0
0
80,185
160,371
65,787
0
0
0
0
0
0
0 0
0
0
84,552
84,552
47,234
0
0
56,401
56,401
0
0
0 0
0
0
116,468
155,290
64,671
39,417
0
0
0
0
0
0 0
0
0
0
0
0
0
0
0
0
0
0
0 0
0
0
Total
Project Cost
8,797,050
1,692,464
795,489
498,245
990,373
5,559
0
Construction Administration, Inspection and Support
2,698,691
99,100
107,600
157,000
146,400
132,900
138,300
130,000
133,800
127,600
132,100
136,300
138,600
144,700
143,100
153,900
137,300
147,400
130,300
90,900
49,500
121,891
2,698,691
PSE Schedule 74 - City Share
890,449
30,000
60,000
60,000
60,000
8o,000
i00,000
120,000
120,000
100,000
80,000
80,449
890,449
Credit for PSE Share of Schedule 74 Conduit and Structure Installation Cost
(103,489)
(103,489)
(103,489)
Credit for PSE Share of Schedule 74 Design Cost (60% of $80, 131.00 PSE Design Cost
(48,079)
(48,079)
(48,079)
PSE Transmission Line Recolcation - City Share
236,259
50,000
150,000
36,259
236,259
Intolight - City Share
227,126
10,000
20,000
20,000
20,000
20,000
20,000
37,000
40,000
20,000
10,000
10,126
227,126
Customer Service Reconnections
250,000
40,000
40,000
40,000
40,000
250,000
Expenditures:
16,930,137
491,198
1,026,898
922,095
831,510
820,764
1,010,512
884,008
963,194
1,140,939
1,239,964
1,174,304
1,139,862
923,441
783,566
705,643
695,100
705,200
581,349
441,250
187,443
121,891 0 0
16,930,137
Cumulative Expense
491,198
1,518,096
2,440,191
3,321,701
4,142,465
%152,976
6,036,995
7,000,178
8,141,118
%381,082
10,555,386
11,695,249
12,618,690
13,402�256
14,107,904
14,803,004
15,508,204
16,089,553
16,530,803
16,718,246
16,840,137 16,840,137 16,840,137
Prjmt Completion
3%
9%
14%
20%
2431.
30%
36%
41%
49%
55%
62%
69%
75%
79%
83%
8:7%
92%
95%
98%
99%
99% 99% 99%
Contingency 1.069.963 0 0 0 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Actual Expenditures:
Schedule A -Roadway Improvements
Schedule A -Storm drainage
Schedule B-Water
Schedule C-Sanitary Sewer
Schedule D-Underground Utilities
Schedule E-Sanitary Sewer
Change Orders
MONTH: 6/l/2017 7/1/2017 8/l/2017 9/1/2017 10/1/2017 111/2017
Budget:
8,797,050 243,972
1,692,464
795,489
Additional Costs:
Construction Administration, Inspection and Support
PSE Schedule 74 - City Share
Credit for PSE Share of Schedule 74 Conduit and Structure Installation Cost
Credit for PSE Share of Schedule 74 Design Cost (60% of $80, 131.00 PSE Design Cost
PSE Transmission Line Recolcation - City Share
Intolight - City Share
Customer Service Reconnections
Misc
Expenditures:
Cumulative Expense
Pr jmt Completion
17 1/1/2018 2!1/2018 3/1/2018 4/l/2018 5/1/2018 6/l/2018 7/1/2018 8/l/2018 9/1/2018 10/1/2018 11/l/2018 12/1/2018 1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019 Project Balance
8,553,078
I 1,692,464
795:489
Contingency 1,069,863 1,069,863
Beginning balance 1 2 3 4 5 6 7 8 9 10 11
12 13
14 15 16 17 18 19 20
21 22 23 24
Bond Proceeds Spenddown
5,802,845 5,776,474 5,729,941 5,664,839 5,374,467 5,374,467 5,374,467 5,374,467 5,374,467 5,374,467 5,374,467 5,374,467
5,374,467 5,374,467
5,374,467 5,374,467 5,374,467 5,374,467 5,374,467 5,374,467 5,374,467
5,374,467 5,374,467 5,374,467 5,374,467
For IRS Tax Exempt Status
Percentage ofremaining Proceeds
100% 100% 99% 98% 93% 93% 93%
93%
93%
93%
IRS Bond Proceeds Balance Target
5,222,561
3,191,565
1,450,711
0
IRS Bond Proceeds Expenditure Requirement
580,285
2,611,290
4,352,134
5,802,845
24 Month Spending Exception for Construction %
101/6
45 %
75%
100%
Funding Sources:
Budget:
Bond -Street
4,110,381
26,371
46,533
65,102
290,372
3,682,003
Bond - Storm
1,692,464
1,692,464
TIB (Limited to Road cost, 20% of CACM, 5% of landscaping)
8,000,000
11,700
56,750
7,931,550
WSDOT (FEDERAL $, Construction only, no A&E; Schedul A only less Storm)
1,701,447
1,701,447
State
2,000,000
2,000,000
Water/Sewer Utility
495,708
10,418
485,290
18,000,000
26,371
46,533
76,802
357,540
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17,492,754
Cumulative Expense
26,371
72,904
149,706
507,246
507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246 507,246
Project Completion
0%
0%
0%
1%
3%
3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3%
Fund 304 Cashflow Analysis (includes all transportation capital projects)
MONTH:
7/1/2017
8/1/2017
9/1/2017
10/1/2017
11/1/2017 12/1/2017 1/l/2018 2/1/2018 3/1/2018 4/1/2018 5/1/2018 6/1/2018 7/1/2018 8/1/2018 9/1/2018 10/1/2018 11/l/2018 12/1/2018 1/l/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019 6/1/2019 Project Cost
Ending Cash Balance
9/28/2017 U:\Tremont widening\Tremont Widening -Big 01 Spreadsheet.xlsx
MONTHLY CONSTRUCTION EXPENSE
1,400,000
1,200,000
1,000,000
800,000
600,000
400,000
200,000
0
6/1/2017 7/1/2017 8/1/2017 9/1/2017 30/1/2017 11/1/2017 12/1/2017 1/1/2018 2/1/2018 3/1/2018 4/1/2018 5/1/2018 6/1/2018 7/1/2018 8/1/2018 9/1/2018 30/1/2018 11/1/2018 12/1/2018 1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019
MONTHLY EXPENDITURES VS. BOND PROCEEDS SPENDDOWN
$1,000,000 —
$0
1
2 3 4 5 6 7 8 9
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
SIRS Bond Proceeds Balance Target —Expenditures:
9/28/2017 UATremont widening\Tremont Widening -Big 01 Spreadsheet.xlsx
MONTHLY CONSTRUCTION EXPENSE
1,400,000
1,200,000
1,000,000
800,000
600,000
400,000
200,000
0
6/1/2017 7/1/2017 8/1/2017 9/1/2017 30/1/2017 11/1/2017 12/1/2017 1/1/2018 2/1/2018 3/1/2018 4/1/2018 5/1/2018 6/1/2018 7/1/2018 8/1/2018 9/1/2018 30/1/2018 11/1/2018 12/1/2018 1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019
MONTHLY EXPENDITURES VS. BOND PROCEEDS SPENDDOWN
$1,000,000 —
$0
1
2 3 4 5 6 7 8 9
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
SIRS Bond Proceeds Balance Target —Expenditures:
9/28/2017 UATremont widening\Tremont Widening -Big 01 Spreadsheet.xlsx
2017-2018
Biennial Budget Review
City of Part Orchard
September 29, 2017
Biennial Review 2017-2018
Departments Budget Capital Bdgt Director Mayor Final
2017-2018 2017-2D18 Requests Adusbnent
Dept 7- Administrative
511.30
Legislative -Official Publications
180,100
511.60
LegislativeServioes
392,371
513.10
Executive
176,763
514.30
Adri inistrative Records Sys
260,601
514.40(511.7)
Election Costs
22,000
514.89
Census*
0
514.90(511.8)
Voter Registration Costs
40,000
515.20
Legal
818,700
518.90 (519.9)
Other Gedl Svs.
17,800
531.70
Pollution Control
18,220
539.30
Animal Control
85,000
562.00
Public Health
25,624
566.00
SubstanoePbuse-Alcoholismfee
7,000
573.90
Spectakhr&ConmunityChirres&Lights and Foot Ferry
98,847
Total Dept 7-Administrative
2,143,026
Deptt-Finance
514.22
Fiduciary Services
09,379
514.23
Financial BudgetlAccounting
057,609
517.90
Wellness Corrmttee
4,900
518.10(516.2)
HurnanResources Management
222,018
6,100
6,100
518.88
InkxnetionTechnology0per
512,011
67,500
9,500
9,500
Total Department I. Finance
1,525,977
67,500
15,600
15,600
Dept 2 - Judicial
512.50
Judic0l
1, 9
-
Total nepartrrent2-Judicial
1, ,
Dept $ - Law Enforcement
521.00
Law Enforcement
8,080,675
523.208523.6
Detention & Correction
1,703,345
70,000
70,000
Total Department 3 - Law Enforcement
9,764,020
70,000
70,000
Department 4 - Community development
517.91(558.8)
Development-Comrrute Trip Reduction
2,000
524.20
Protective Inspection
815,318
13,250
(10,750)
2,500
558.60
Planting
1,698,262
9,000
(41500)
(32,500)
559.20
Housing &CorrrnunityDev
103,280
Total Department 4 - Community Development
2,618,860
22,250
(52250)
(30,000)
Department 5 - Public Works
518.20(532.1)
Engineering
215,151
518.30
Cereal Facilities(OthrGen GA Svs)
551,292
10,000
(10000)
-
518.30
AMInsuranceCurrent expense portion
289,100
559.30.41
Natural & Fcononic FmAronrrent
300,000
200,000
500,000
572.50
Library Facility
55,185
576.80
Parks
746,595
31,000
111,200
(105,000)
6,200
002/304
Street (includes pamng &sidevalk repair)
3,736,942
140,750
(5,000)
135,750
Total Department 5- PublicVUorks
5,5K265
31,000
561,950
80,000
641,950
Reserves and Other Payments (Used Expenditures $ for these)
001
Pol ice Equipment TR 001.6.597
-
-
001
To Stabilization Fund TR 001.6.597
240,000
002
To Equip Reserve pay back buck lR 002.5.597.00
69,787
001
PaftReserve 9-508.52
71,615
001
City Hall Reserve 9508.53
-
001
Prop Tax Rev Share W County 9-508.54
001
Sales Tax Rev Share vJ Canty 9-508.55
-
001
Reaeation(PdnissionsTax) 9-508.40
241,800
001
KCCFlA Jability pn-t 9508.56
-
002
RESTRICTED Street Resen(e 101.0.287.00 002.9.508.30
002
Street Projects - Assigned Fund Balance 002.9.508.51
-
TOTAL RESERVErl RANSFER
623,202
TOTAL General Fund 23,519,158 98,500 669,800 27,750 697,550
Department 3-Law Enforcement (Other Funds)
103
Gininal Justice Fund
613,827
ind in proposed
104
Special Investigative Unit Fund
6,500
Total Department 3-LawEnforcement (Other Funds)
620,327
Department 5-Proprietary Funds
401/402,403
MerSaver UtilityFund
15,152,935
8,358,445
650,000
(27,000)
623,000
421
Storm Drainage Utility Fund
2,582,747
41,600
425,000
(25,000)
400,000
Total Department 5- Propnetarty Funds
17,735,682
8,400,045
1,075,000
(5$0t10)
1,023,000
TOTAL 41,875,167 8,498,545 1,744,800 (24,250) 1,720,550
2017 - 2018 Biennial Review Narrative
Return completed document by September 8, 2017
Date: 9/8/2017
Department: Finance
Click on cell. Use drop -down menu to insert Department
Reduction in Expense: Ar
Description: B.A.R.S. Coding Amount
Total
-
Increase in Expense:
Description: B.A.R.S. Coding Amount
HR:
Increase for Workers Comp Retro Program Svs Fees 001.1.518.10.41 1300
add back for 2017 First Aid training - not budgeted
001.1.518.10.41
2600
add back for Salary Survey expenses carryover from 2016
001.1.518.10.41
1200
add back to extra advertising in 2017
001.1.518.10.44
1000
IT:
Windows 10 licenses (could use capital funding?)
001.1.518.88.49
9500
Total
14,300.00
Modifications:
Description: B.A.R.S. Coding Amount
001.5.594
Mayor's Utility Undergrounding on Bay St
300,000.00
Total
300,000.00
l�q^.�* Yie
"ti iyK an ti>1Yxsn i� rpl�0�� ' yQ �� F � yet: 1 'i "� e � t
.e .•: t.,35_.��.r'... _w,.;, �. w`+z�a...��.-.« . ��:fir.'�'•�7'..4,...�.��,wt���,�.rl�r;�f.F,;C����:s�:>IZ.��i.�3�.F6r�`.�t �;...-�c..
Return completed document by September 8, 2017
Date: 8-Sep-17
Department: Court
Gkk an cep. Use drop -dawn menu to Insert Depar unent
MOW �. � � �.FAME
Description: B.A.R.S. Coding Amount
No changes
Total
-
iAMaase`i E [e ^s :tea -
Description: B.A.R.S. Coding Amount
No changes
Total
"
1�Po"�iai3 s.
Description: B.A.R.S. Coding Amount
No changes
Total
"
2017 - 2018 Biennial Review Narrative
Return completed document by September 8, 2017
Date: 9/6/2017
Department: Police
Click on cell. Use drop -down menu to insert Department
Reduction in Expense: Ar
Description: B.A.R.S. Coding Amount
Total
-
Increase in Expense:
Description: B.A.R.S. Coding Amount
Intergovernment Professional Service/ Kitsap County Jail/2018
001-3-523-60-51
$70,000.00
Tota I
-
Modifications:
Description: B.A.R.S. Coding Amount
Total
-
2017 - 2018 Biennial Review Narrative
Return completed document by September 8, 2017
Date: 9/8/2017
Department: Community Development
Click on cell. Use drop -down menu to insert Department
Reduction in Expense:
Description: B.A.R.S. Coding Amount
Total
-
Increase in Expense:
Description: B.A.R.S. Coding Amount
Building Inspection Services
001-4-524-20-41 $ 10,000.00
Parks Plan Update
001-5-576-80-41
$ 50,000.00
Salmonberry Bethel Intersection Design
002-5-543-30.40
$ 75,000.00
Communications Planning (Public Notice Signs+ Comp Plan Notice
001-4-558-60-42
$ 1,500.00
Communications Building (Public Notice Signs)
001-4-524-20-42
$ 750.00
DCD Copier Replacement 60 month lease - 25%
001-4-524-20-45
$ 2,500.00
DCD Copier Replacement 60 month lease- 75%
001-4-558-60-45
$ 7,500.00
Total
137,250.00
Modifications:
Description: B.A.R.S. Coding Amount
Total
137,250.00
2017 - 2018 Biennial Review Narrative
Return completed document by September 8, 2017
Date: 25-Aug-17
Department: Public Works
Note: Bold Items Required Click on cell. Use drop -down menu to insert Department
Reduction in Expense: Ar
Description: B.A.R.S. Coding Amount
Total
-
Increase in Expense:
Description: B.A.R.S. Coding Amount
City Hall Blinds
001.5.518.30.48
$ 10,000.00
Inceased Parks Maintenance-S
001.5.576.80.10
$ 10,000.00
Increased Parks Maintenance-B
001.5.576.80.20
$ 40,000.00
Increased Parks Maintenance
001.5.576.80.31
$ 5,000.00
Tree Removal - Roadway
002.5.542.30.40
$ 20,000.00
Snow & Ice
002.5.542.66.30
$ 15,000.00
Excavator Rental - Street
002.5.543.30.40
$ 5,000.00
PW Shop (KPUD) Internet - Water
401.5.534.20.40
$ 6,000.00
Excavator Rental - Water Utility
401.5.534.51.40
$ 5,000.00
Water Treatment - Chlorinator
401.5.534.52.40
$ 3,000.00
Wells - Supplies
401.5.534.53.30
$ 5,000.00
Retail Water Purchase - COB
401.5.534.80.33
$ 500,000.00
PW Shop (KPUD) Internet - Sewer
401.5.535.20.40
$ 6,000.00
Excavator Rental - Sewer Utility
401.5.535.51.40
$ 5,000.00
Storm - Supplies
421.5.531.00.30
$ 5,000.00
Street Sweeping - Parts
421.5.531.51.30
$ 5,000.00
Annapolis Creek PS&E and Permitting (Storm CIP)
421.5.597.00.00
$ 400,000.00
Anderson Hill/Clifton Roundabout - CO#1
304.5.595.14.63
$ 5,750.00
2018 Striping (plus $15K carryover from 2017)
002.5.542.64.40
$ 20,000.00
Water -Pumping (Melcher)
401.5.534.56.40
$ 90,000.00
Parks Dept. Rental of 1259 Lloyd Pwky from Fund #401
001.5.576.80.45
$ 6,200.00
Sensus Meter Reader Replacement
401.5.534.72.40
$30,000.00
Storm Water Testing
421.5.531.00.40
$ 10,000.00
Excavator Rental - Storm Utility
421.5.531.00.40
$ 5,000.00
Total
1,201,950.00
2017 - 2018 Biennial Review Narrative
Return completed document by September 8, 2017
Date: 8-Sep-17
Department: Admin
Click on cell. Use drop -down menu to insert Department
Reduction in Expense: Ar
Description: B.A.R.S. Coding Amount
Total
-
Increase in Expense:
Description: B.A.R.S. Coding Amount
Total
-
Modifications:
Description: B.A.R.S. Coding Amount
Chimes and Lights Garland and Wreaths Purchase from 2017 to
2018
001.7.573.90.49
7,000.00
Total
7,000.00