HomeMy WebLinkAbout25- Finance 25.a
�,F,4tNARD�,� N
Consent Calendar o
City of San Bernardino
Request for Council Action
L
Date: October 18, 2017
w
To: Honorable Mayor and City Council Members
From: Andrea M. Miller, City Manager o
By: Brent A. Mason, Director of Finance
CL
Subject: Fiscal Year 2016-17 Continuing Appropriations and Encumbrance a
Carryovers and Amending the Fiscal Year 2017-18 Budget a
c
Recommendation
Resolution of the Mayor and City Council of the City of San Bernardino, California,
approving the Fiscal Year 2016-17 Continuing Appropriations and Encumbrance
Carryovers and amending the Fiscal Year 2017-18 Budget to include the approved
Fiscal Year 2016-17 Continuing Appropriations and Encumbrance Carryovers.
0
N
Background
Continuing Appropriations and Encumbrance Carryovers are budgetary clean-up items
that occur annually in municipalities as a part of the year-end closing process. The N
Finance Department receives requests for carryovers from City departments, The U.
Finance Department analyzes outstanding purchase orders, contracts, and remaining o
budget balances to determine which unspent appropriations should be recommended for
carryover into the new fiscal year. Sufficient budget appropriations from the FY 2016-17
Budget remain available to support the departmental requests. Council approval is o
required to amend the Adopted 2017-18 Budget to include these carryover funds for use
in FY 2017-18.
w
Discussion o
>
Finance has coordinated with the City departments to identify those projects/accounts
which meet the above requirements and has developed the attached lists of Continuing
Appropriations, attached as Exhibit A, and Encumbrance Carryovers, attached as Exhibit Ui
U
B. They reflect City commitments to projects, services or purchases approved in FY z
2016-17 that were unable to be completed by the close of the 2017 fiscal year. The
Continuing Appropriations list totals $4,391,453, of which $49,136 is for General Fund
projects. The balance is for restricted funding sources, primarily grants and capital U
projects. The Encumbrance Carryovers list totals $3,284,431, of which $958,996 is for w
General Fund projects. Again, the balance is primarily for grants and capital projects. >_
E
a
Packet Pg. 366
25.a
Fiscal Impact
The requested actions amend/increase the 2017-18 Adopted Budget to the accounts and o
in the amounts noted in the exhibits to the Resolution. The amounts represent the
unexpended portion of various projects, previously approved by the Council, not yet L)
complete at June 30, 2017. The budget appropriations are not included in the 2017-18
Adopted Budget. If approved, this action will re-establish the unspent portion of the L
budget from the prior year in the new fiscal period. Sufficient funds exist to address the
requested supplemental appropriation.
w
Conclusion C
It is recommended that the Mayor and City Council adopt the Resolution to approve the y
budget adjustments associated with carrying over the unspent budget from Fiscal Year c
2016-17 into the 2017-18 Fiscal Year
L
Q.
O
L
CL
a
Attachments Q
Attachment 1 — Resolution Approving Carryovers into Fiscal Year 2017-18; Exhibit A-
Continuing Appropriations; Exhibit B- Encumbrance Carryovers
C
p
Synopsis of Previous Council Actions: U
ti
T
Fiscal Year 2017/18 Budget Adopted on June 21, 2017 `O
0
N
f6
U
N
LL
O
O
N
4Cl
O
a
LU
o:
LU
O
Q:
Q:
Q
U
LU
U
Z
m
U
Z
LU
LL
C
d
Q
Packet Pg. 367
25.b
c
ca
N
L
1 RESOLUTION NO. o
2
RESOLUTION OF THE MAYOR AND CITY COUNCIL OF THE CITY OF SAN
3 BERNARDINO, CALIFORNIA, APPROVING THE FISCAL YEAR 2016-17
CONTINUING APPROPRIATIONS AND ENCUMBRANCE CARRYOVERS AND
4 AMENDING THE FISCAL YEAR 2017-18 BUDGET TO INCLUDE THE APPROVED
5 FISCAL YEAR 2016-17 CONTINUING APPROPRIATIONS AND ENCUMBRANCE
CARRYOVERS. c
LU
6
WHEREAS,the FY 2017-18 budget was adopted on June 21,2017; and
7 w
r-
8
8 WHEREAS,the Continuing Appropriations and Encumbrance Carryovers reflect City
•L
9 commitments to projects, services or purchases that were approved in FY 2016-17 but were L-
CL
CL
10 not completed or fully paid for in FY 2016-17. a
as
c
11 '�
12 NOW THEREFORE, BE IT RESOLVED BY THE MAYOR AND CITY c
COUNCIL OF THE CITY OF SAN BERNARDINO AS FOLLOWS:
13
SECTION 1. The Mayor and City Council approve the Continuing Appropriations
14 N
15 and Encumbrance Carryovers lists, attached hereto as Exhibit A and Exhibit B.
16 SECTION 2. The Director of Finance is hereby authorized to amend the FY 2017-18 N
U-
17 Budget to include the approved Continuing Appropriations and Encumbrance Carryovers. a;
0
18
19
/// a
20 W
IlI >
21 0
22 /// a
23 111
Z
24 9
25
26 w
27 U.
28 ///
r
1 f6
a
Packet Pg. 368
25.b
1 RESOLUTION OF THE MAYOR AND CITY COUNCIL OF THE CITY OF SAN
BERNARDINO, CALIFORNIA, APPROVING THE FISCAL YEAR 2016-17 Z,
2 CONTINUING APPROPRIATIONS AND ENCUMBRANCE CARRYOVERS AND v
3 AMENDING THE FISCAL YEAR 2017-18 BUDGET TO INCLUDE THE APPROVED m
FISCAL YEAR 2016-17 CONTINUING APPROPRIATIONS AND ENCUMBRANCE
4 CARRYOVERS.
5
I HEREBY CERTIFY that the foregoing Resolution was duly adopted by the Mayor w
6
and City Council of the City of San Bernardino at a 1°
7 _ --- U,
meeting thereof, held on the day of 2017, by the following vote,
8 •�
CL
9 to wit: a
CL
10a
Council Members: AYES NAYS ABSTAIN ABSENT =
11
MARQUEZ —_ c
12 U
13 BARRIOS —.---.-_
(o
14 VALDIVIA _
15 SHORETT }
16 NICKELU.
-
17
RICHARD N
18 --
19 MULVIHILL _— F
a
20 w
21 Georgeann Hanna,CMC,City Clerk o
22 The foregoing Resolution is hereby approved this day of '2017. v
23 0
z
24
25 R.Carey Davis,Mayor
City of San Bernardino v
26 Z
w
Approved as to form: LL
27 Gary D. Saenz,City Attorney
28
By:
2 a
Packet Pg.369
25.b
Continuing Appropriations Exhibit A
2016/17 to 2017/18
a
c
Fund Dept Prog Account Original Amount Amount to Carryover Project Title M
y
i
d
001 470 0001 5181 $ 3,527.00 $ 3,527.00 Internet Filter O
Feldheym Children's Movies Public Performance
001 470 0049 5181 $ 68,332.00 $ 2,392.00 Rights f°
U
a)
001 470 0064 5505 $ 47,220.00 3,520 Feldheym Children's Aquarium Maintenance r_
001 470 0001 5111 $ 81000.00 $ 450.00 Laser Printer for Staff
001 380 0075 5193 $ 132,797.00 $ 39,247.00 RSVP Grant E
General Fund Total $ 49,136.00 U
c
LU
117 130 2318 5502 $ 367,890.00 $ 166,903.00 ACQUISITION/REHABILITATION
117 130 2331 5502 $ 1,000,000.00 $ 375,000.00 HOME-Infilled Housing Developmnt
117 130 2330 5502 $ 518,231.18 $ 516,631.00 Single Family Rehab Program
Home Investment Total $ 1,058,534.00 .2
y
119 130 2191 5502 $ 350,000.00 $ 350,000.00 CDBG-Veterans Support Program C
119 130 2199 5502 $ 70,000.00 $ 70,000.00 Micro Enterprise Program o
119 130 2200 5502 $ 250,000.00 $ 250,000.00 CDBG CW Comm Bldg Rehab/Bus!Imp Q
119 130 2201 5502 $ 450,000.00 $ 450,000.00 CDBG CW Owner Occ Hsng Rehab qua
119 380 2202 5502 $ 40,000.00 $ 40,000.00 CDBG 5th St Sr Ctr HVAC replace G
119 380 2202 5504 $ 160,000.00 $ 160,000.00 CDBG 5th St Sr Ctr HVAC replace
c
119 380 2203 5502 $ 50,600.00 $ 50,600.00 CDBG J Lewis Pool Filtrat System
119 380 2203 5504 $ 202,400.00 $ 202,400.00 CDBG J Lewis Pool Filtrat System O
119 380 2205 5502 $ 60,000.00 $ 60,000.00 CDBG Newmark Park Light Install U
119 380 2205 5504 $ 240,000.00 $ 240,000.00 CDBG Newmark Park Light Install r
119 470 8055 5706 $ 21,040.00 $ 21,040.00 Library Roof Replacement c>,
CDBG Total, $ 1,894,040.00 N
120 130 2350 5502 $ 1,493,278.00 $ 636,778.00 Administration
NSP1 Total $ 636,778.00
R
v
122 130 2058 5502 $ 787,055.00 $ 154,533.00 Administration N
ii
NSP3 Total $ 154,533.00
ro
0
5515-001:Palm Ave(Co-op w/City of Highland-lead) ,N
126 160 7949 5504 $ 45,000.00 $ 45,000.00 Bike Lanes at Pacific St
TC17-006:Hospitality Ln Median&Signal
126 160 8601 5504 $ 45,000.00 $ 32,750.00 Improvments from E St to Waterman Ave H
Q
Gas Tax Fund Total $ 77,750.00 IX
w
5516-026:Co-op w/City of Highland Baseline St 0
129 160 8034 5504 $ 1,000.00 $ 1,000.00 Lighted Crosswalk(SRTS) IX
iY
SS16-023:Co-op w/City of Highland Baseline St& U
129 160 8031 5504 $ 5,900.00 $ 5,900.00 5th St Signal Coordination Upgrade(MSRC) U
Z
SS16-024:Co-op w/City of Highland for 5 Corridors
129 160 8032 5504 $ 25,600.00 $ 25,600.00 Project,Signal Coordination Upgrade(MSRC) m
Measure I Total $ 32,500.00
U
263 160 7338 5504 S 50,000.00 $ 32,290.00 TC-A:Citywide Traffic Signal Improvements Z
TC16-001:Redlands Blvd&Hunts Ln Traffic Signal w
263 160 8037 5504 $ 110,000.00 $ 96,909.49 Modification t}i.
c
263 160 8611(xxx 5504 $ 40,000.00 $ 40,000.00 TC17-003:Traffic Management Center Upgrade a�
Local Regional Circulation Total $ 169,199.49 t
U
R
Q
Packet Pg. 370
25.b
Continuing Appropriations Exhibit A
2016/17 to 2017/18
Fund Dept Prog Account Original Amount Amount to Carryover Project Title
d
O
679 250 0035 5502 $ 308,500.00 $ 16,000.00 Voip Project U
Telephone Support Fund $ 16,000.00 d
v
C
R
679 250 0058 5702 250,000 Microsoft Purchase
679 250 0062 5702 70,000 40,000 Additional Backup E
information Technology Fund $ 290,000.00
W
Total $ 4,378,470.49
G
lC
N
C
O
'r+
R
a
0
L-
CL
0.
Q
rn
c
c
c
0
U
ti
m
77
a�
R
v
y
LL
00
O
N
r
t-
H
Q
LLI
O
a:
Q
U
W
U
Z
m
U
Z
LU
LL
r
C
d
Q
Packet Pg. 371
25.b
Encumbrance Carryovers Exhibit B
2016/17 to 2017/18
Fund Dept Prog Account Original Amount Amount Amount to Carryover Venda Name
Remaining N
L
d
001 090 0053 5505 417,500.00 146,592.04 146,592.04 IDS Group O
001 090 0053 5505 228,605.00 194,977.90 194,977,90 Transtech Engineers Inc
Total General Governement 341,569.94 U
a�
L)
001 210 0086 5111 199,168.00 116,615.08 116,615.08 Adamson Police Products L
001 210 0001 5701 102,944.20 102,944.00 102,944.00 Innovative Emergency Equipment
E
001 210 0001 5704 175,000.00 175,000.00 175,000.00 CelPlan Technologies Inc 3
U
001 210 0001 5701 331,031.07 152,569.99 152,569.99 Fairview Ford
W
Total Police 547,129.07 a
C
to
001 380 0001 5502 25,300.00 6,818.10 6,818.00 Revive Restoration y
c
001 380 0001 570420,379.00 20,379.00 20,379.00 California Waters Development
001 380 0069 5704 20,000.00 20,000.00 20,000.00 California Waters Development
001 380 0070 5704 5,000.00 5,000.00 5,000.00 California Waters Development 0
L-
001
001 380 0072 5704 8,100.00 8,100.00 8,100.00 California Waters Development a
001 380 0077 5704 10,000.00 10,000.00 10,000.00 California Waters Development Q
Total Parks,Recreation,and Community Development 70,297.00
c
C
General Fund 958,996.01
O
U
117 130 2322 5502 734,000.00 73,400.00 73,400.00 4546-WG PARTNERS 1 MGP LLC ti
117 130 2331 5502 625,000.00 625,000.00 625,000.00 1590-HOUSING PARTNERS I INC
T
0
2132-NEIGHBORHOOD HOUSING N
117 130 2318 5502 150,149.67 146,821.00 146,821.00 SERVICES OF THE INLAND EMPIRE d
Total Economic and Housing Development 845,221.00 }
R
U
to
Home Improvement Fund 845,221.00 ii
00
118 210 0082 511116,037.00 13,703.88 13,704.00 Foremost Promotions c
N
Total Police 13,704.00
r
H
Gang and Street Asset Forfeiture Fund 13,704.00 ~
Q
119 210 2168 5704 225,000.00 225,000.00 225,000.00 CelPlan Technologies Inc j
Total Police 225,000.00 O
IX
CDBG Fund 225,000.00 U
W
123 210 0972 5701 129,609.08 96,720.81 96,720.81 Fairview Ford U
Z
123 210 0972 5701 122,000.00 98,275.46 98,275.46 Duratech USA Inc
123 210 0972 5701 137,265.80 137,266.00 137,266.00 Innovative Emergency Equipment m
123 210 8041 5102 7,000.00 7,000.00 5,305.53 CelPlan Technologies Inc
123 210 0972 5701 122,000.00 23,725.00 23,725.00 Duratech USA Inc U
123 210 8554 5704 30,000.00 30,000.00 29,999.46 Precision Survey Supply Inc W
123 210 8553 5702 22,998.55 20,896.05 20,896.05 Enforcement Technology LL
Total Police 412,188.31 w;
c
m
Federal Grant Programs Fund 412,188.31 E
v
tC
Q
Packet Pg. 372
25.b
Encumbrance Carryovers Exhibit B
2016/17 to 2017/18
Fund Dept Prog Account Original Amount ReAmount maininK Amount to Carryover Vendor Name
O
128 210 0087 5701 319,504.12 83,773.77 83,773.77 Fairview Ford cc
128 210 0087 5701 10,790.00 10,790.00 10,790.00 Innovative Emergency Equipment U
d
128 210 0087 5102 35,000.00 17,991.00 17,991.00 Duratech USA Inc
c
Total Police 112,554.77
E
Traffic Safety Fund 112,554.77
C
W
129 160 7924 5504 321,382.00 85,220.00 85,220.00 1824-DBX,Inc.
129 160 7931 5504 302,553.00 179,501.80 179,501.80 1824-DBX,Inc.
y
C
O
t.
5170-San Bernardino County M
129 160 7240 5504 65,000.00 27,165.32 27,165.32 Transportation Authority C
Total Capital Improvement 291,887.12 Q
Q
Q
Measure I Fund 291,887.12
261 210 0114 5505 169,795.44 169,795.00 169,795.44 G&S Carpet Mills Inc =
Total Police 169,795.44 0
O
U
f`
Law Enforcement Facilities DIF Fund 169,795.44
W
T
263 160 8038 5504 31,500.00 5,675.50 5,675.50 626074-KOA Corporation
Total Capital Improvement 5,675.50
Local Regional Circulation Fund 5,675.50
v
N
ii
264 160 7245 5504 189,064.04 158,491.82 158,491.82 603384-AECOM USA,Inc.
00
264 160 7121 5504 280,000.00 27,958.91 27,958.91 603384-AECOM USA,Inc. N
T
610143-Engineering Resources of
264 160 7160 5504 178,555.00 62,957.82 62,957.82 Southern California Q
Total Capital Improvement 249,408.55 W
W
O
Regional Circulation System Fund 249,408.55
Grand Total 3,284,430.70 Q
U
W
U
Z
9
g
U
Z
W
LL
r
C
d
r_
Q
Packet Pg. 373