HomeMy WebLinkAboutApprove the Infrastructure Fund Annual Report for Fiscal YeaDept. ID PW 17-033 Page 1 of 2
Meeting Date: 6/19/2017
14qH4 V�� :7 __6
CITY OF HUNTINGTON BEACH
REQUEST FOR. CITY COUNCIL ACTION
MEETING DATE: 6/19/2017
SUBMITTED TO: Honorable Mayor and City Council Members
SUBMITTED BY: Fred A. Wilson, City Manager
PREPARED BY: Travis K. Hopkins, PE, Director of Public Works
SUBJECT: Approve the Infrastructure Fund Annual Report for Fiscal Year 2015-2016
Statement of Issue:
The City Charter requires an annual review and performance audit of the Infrastructure Fund and a
report of the findings to the City Council prior to adoption of the following fiscal year budget. This
review covers the fiscal year (FY) 2015-16.
Financial Impact:
Not applicable.
Recommended Action:
Approve the Infrastructure Fund Annual Report for FY 2015-2016.
Alternative Action(s):
Instruct staff to make revisions and resubmit at a later date.
Analysis:
The Infrastructure Fund was established in 2002 by City Charter Section 617(c), which states, "the
City Council shall by ordinance establish a Citizens Infrastructure Advisory Board (CIAB) to conduct
an annual review and performance audit of the Infrastructure Fund and report its findings to the City
Council prior to adoption of the following fiscal year budget."
The single substantial revenue source to the fund is General Fund excess fund balance per the
Financial Policy adopted in FY 2006-2007 and revised in FY 2009-2010 to allow for an Economic
Uncertainties Reserve commitment. There was no General Fund transfer for FY 2015-16.
Revenue included interest and a maintenance agreement reimbursement for a total of $70,149.
Expenditures for the year totaled $2,558,700. The fund balance at year's end was $7,063,285.
Per the City Charter, the Infrastructure Fund is designated for the sole purpose of infrastructure
expenditures. "Infrastructure" is defined in the Charter as "long-lived capital assets that normally
are stationary in nature and normally can be preserved for significantly greater number of years.
They include storm drains, storm water pump stations, alleys, streets, highways, curbs and gutters,
sidewalks, bridges, street trees, landscaped medians, parks, beach facilities, playgrounds, traffic
signals, streetlights, block walls along arterial highways, and all public buildings and public ways."
HB -45- Item 7. - I
Dept. ID PW 17-033 Page 2 of 2
Meeting Date: 6/19/2017
Citizens Infrastructure Advisory Board Action:
The annual Infrastructure Fund Report was approved at the May 25, 2016, meeting of the Citizens
Infrastructure Advisory Board by a vote of 7-0.
Environmental Status:
Not applicable.
Strategic Plan Goal:
Enhance and maintain infrastructure
Attachment(s):
Infrastructure Fund Report for Fiscal Year 2015-16
Item 7. - 2 HB -46-
Infrastructure Fund Annual Report
Fiscal Year 2015-Zo16
HB -47-
Item7.-3
SUBMITTED TO:
SUBMITTED BY:
DATE:
SUBJECT:
CITY OF HUNTINGTON BEACH
CITIZEN'S INFRASTRUCTURE ADVISORY BOARD
Citizen's Infrastructure Advisory Board
Travis K. Hopkins, PE, Director of Public Works
May 25, 2017
Approve Infrastructure Fund Annual Report
Statement of Issue: The City Charter requires an annual review and
performance audit of the Infrastructure Fund, and a report of the findings to the
City Council. This provides information pre -audit information on Fiscal Year
2015/16 and budget information on the current fiscal year.
Funding Source: Infrastructure Fund No. 314
Recommended Action: Motion to recommend to City Council approval of the
Infrastructure Fund Annual Report.
Alternative Action(s): Direct staff to modify the Annual Report.
Analysis: The Infrastructure Fund was established in 2002, by City Charter Section
617. Per Section 617 (a), the originally intended revenue source for the
Infrastructure Fund was a planned utility use tax on natural gas purchased to
generate electricity. However, this ballot measure failed. So, while the Charter
amendment created the fund, it was left with no source of revenue.
Other Charter requirements related to the fund are:
• Revenue placed in the Infrastructure Fund shall not supplant existing
infrastructure funding.
• General Fund expenditures for infrastructure improvements and
maintenance, subsequent to 2001, shall not be reduced below 15% of
general fund revenues based on a five-year rolling average.
• The City Council shall by ordinance establish a Citizens Infrastructure
Advisory Board to conduct an annual review and performance audit of
the Infrastructure Fund and report its findings to the City Council prior to
adoption of the following fiscal -year budget.
The single substantial revenue source to the fund is General Fund excess fund
balance per the Financial Policy adopted in Fiscal Year 2006/07. The Policy was
Item 7. - 4 xB __
revised beginning in Fiscal Year 2009/10 to allow for an Economic Uncertainties
Reserve commitment. Excerpts addressing the Infrastructure Fund for the
previous and current policies are shown in Attachment 1.
Revenue - FY 2015/16
1. There was no General Fund transfer for FY 2015/16.
2. Per a maintenance agreement for the traffic signal at Beachmonf Plaza the
fund was reimbursed $10,200.
3. Interest and market adjustments are paid in proportion to the cifywide
investments and fund balance. For 2015/16 this totaled $59,949.
Total Revenue for FY 2015/16 was $70,149.
Revenue Item Actual
Beachmont Plaza Reimbursement $10,200
Interest and Market Adjustments $59 949
Total Revenue
$70,149
Expenditures - 15-16
Budgeted expenditures and expenditure adjustments for FY 2015/16
consisted of carry forward projects from 2014/15, carry over encumbrances
from 2014/15 and new funds. Where applicable, project sheets from the FY
15/16 Capital Improvement Program (CIP) are included as Attachment 2.
1. Worthy Park Phase I project (business unit 31445002) - The budget
included $500,000 in CIP carry over. Only a small amount of these funds
($1,304) were expended for reproduction of plans and specs for the
purpose of the bid process for the project.
2. Main Promenade Parking Structure (business unit 31445003) - The 15-16
budget included $1,291,298 CIP in carry over and $111,943 in
encumbrance carry forwards - Total - $1,403,241. Of this amount
$1,121,085 was spent on the project.
3. Infrastructure Engineering/Design (business unit 31485201) - Encumbrance
carry forward funds totaled $43,910. The FY 15-16 budget originally
included $143,000 in new funds for Walnut and lst Street Lighting. This
project was put on hold and some of the funds were reprogrammed to
other areas. CIP carry over funds totaled $1,152,117 ($1,060,117 for the
ongoing Atlanta Widening project and $92,000 for Heil Pump Station
design). In addition, City Council approved an appropriation of $250,000
for dredging of Huntington Harbour. This project was done in conjunction
with the County. The total expenditures in the business unit were $993,983
broken down as follows:
Central Park Improvements - $47,090
2
HB -49- Item 7. - 5
Beach Parking Lot (final payment minus accrual to 14-15) - $2,760
Atlanta Avenue Widening - $693,233
Heil Pump Station Property Appraisal - $900
Huntington Harbour Dredging - $250,000
4. LED Lighting Retrofits (business unit 31485304) - $68,591 in encumbrance
carry forward funds were spent on LED retrofits in FY 15-16.
5. Senior Center (business unit 31487003) - The FY 15-16 budget began the
year with $2,545,340 in CIP carry over funds. Because the project was
nearing completion with only landscaping improvements the budget was
reduced by $225,000 and $1,000,000 was transferred to the Atlanta
Avenue Widening project at the end of the year. Expenditures for the
year totaled $147,047.
6. Heil Pump Station (business unit 31488001) - The 15-16 budget consisted of
$2,323,548 in CIP carry over funds. Staff continued work to obtain the
necessary property to move the project forward. Expenditures towards
this endeavor totaled $30,116.
7. Bella Terra Pedestrian Crossing (business unit 31490001) - The Infrastructure
Fund is being used as a holding account for developer fees and
expenditures related to the proposed Bella Terra Pedestrian Crossing
Project. The FY 2015/16 budget includes $63,639 in encumbrance carry
over funds related to preliminary design and $200,000 in carry forward
funds designated for construction. However, to date the project has
failed to move forward due to the fact the Public Utilities Commission,
which oversees railroad crossings, is reluctant to allow an at -grade
pedestrian crossing.
8. Arterial Rehabilitation (business unit 31490003) - There were some minor
salary charges ($285) to this business unit in FY 15-16 in preparation for the
16-17 CIP.
9. Atlanta Avenue Widening (business unit 31490004) - A business unit
dedicated to the ongoing project was created mid -year in order to better
track and separate costs. $1,000,000 was transferred from the Senior
Center Project as noted above. Of this amount $196,290 was expended
as part of the land acquisition process. The remaining funds were carried
over into the current fiscal year.
A summary of budget and expenditure activity and an expenditure transaction
detail are included as Attachment 3 to this report.
Budgeted Revenue - FY 16-17
A General Fund transfer to the Infrastructure Fund for the current fiscal year is not
currently programmed. Interest accrued to the fund as of March 1 is $24,338.
With six months remaining in the fiscal year it is reasonable to project that this
amount will double to approximately $50,000.
3
Item 7. - 6 HB -50-
Budgeted Expenditures - 16-17
The FY 16-17 Infrastructure Fund expenditure budget includes one new project
(Arterial Rehabilitation), CIP carry over and encumbrance carry forward funds.
1. Worthy Park Phase i project (business unit 31445002) - $451,096 in CIP carry
over and $47,600 in encumbrance carry forward. Total - $498,696.
2. Main Promenade Parking Structure (business unit 31445003) - $117,175 in
CIP carry over and $174,340 encumbrance carry forward. Total - $291,515.
3. Infrastructure Engineering/Design (business unit 31485201) - $509,180 in CIP
carry over and $3,600 in encumbrance carry forward. Total - $512,780.
4. Senior Center (business unit 31487003)-$1,166,389, in CIP carry over and
$6,909 in encumbrance carry forward for the Senior Center. Total
$1,173,228. The project is complete. These funds will be reprogrammed to
other areas. To date $150,000 has been transferred to the Atlanta Avenue
Widening Project to cover pending litigation costs related to the
necessary property acquisition. Adjusted Total $1,023,298.
5. Heil Pump Station (business unit 31488001) - $2,277,572 in CIP carry over
and $16,830 in encumbrance carry forward. Total - $2,294,402. As noted
above, the City also received a Hazard Mitigation Grant of $2,250,000 for
construction of the station. These funds are budgeted in a separate grant
fund.
6. Bella Terra Pedestrian Crossing (business unit 31490001) - $263,639 in CIP
carry over. As noted above, this business unit is utilized as a holding
account for developer funds designated for construction of a pedestrian
railroad crossing at Bella Terra.
7. Arterial Rehabilitation (business unit 31490003) - $1,200,000 in new CIP
funds for the FY 16-17 Arterial Rehabilitation Project.
8. Atlanta Avenue Widening (business unit 31490004) - $513,710 in CIP carry
over and $140,000 in encumbrance carry forward. Total - $653,710. As
noted above, $150,000 was transferred in from the Senior Center funds to
cover pending litigation. Adjusted Total - $803,710.
A summary of the FY 16-17 Infrastructure Fund expenditure budget is included as
Attachment 4.
Fund Balance
Fund Balance 10/1/15
$9,551,836
Revenue FY 15-16
$70,149
Expenditures FY 15-16
2 558 700
Fund Balance 10/1/16
$7,063,285
Projected Revenue FY 16-17
$50,000
Budgeted Expenditure FY 16-17
($6,888,04M
Projected Fund Balance 10/1/17
$225,245
1113 -5 1 - Item 7. - 7
Attachments:
1. Excerpts from Financial Policies adopted FY 2006/07 and 2009/10
2. Project Sheets
3. Infrastructure Fund (314) Summary of Budget and Expenditure Activity - FY
15-16 and Transaction Detail
4. Infrastructure Fund (314) Expenditure Budget Summary - FY 16-17
Item 7. - 8 xB -52-
Attachment 1
Excerpts from Financial Policies adopted FY 2006/07 and
2009/10
HB -53- Item 7. - 9
City of Huntington Beach
Financial Policies
Adopted FY 2006/07
FINANCIAL. REPORTING AND ACCOUNTING STANDARDS
The City's accounting system will be maintained in accordance with generally accepted accounting
practices and the standards of the Government Accounting Standards Board and the Government Finance
Officers Association.
The annual financial report will be prepared within six months of the close of the previous fiscal year. The
City will use generally accepted accounting principles in preparing the annual financial statements and will
attempt to qualify for the Government Finance Officers Association's Excellence in Financial Reporting
Program.
The City will strive for an unqualified audit opinion. An unqualified opinion is rendered without reservation
by the independent auditor that financial statements.are fairly presented.
The City will contract for an annual audit by, a qualified independent certified public accounting firm. The
independent audit firm will be selected through a competitive process at least once every five years. The
contract period will be for an initial period of three years, with two one-year options.
BUDGETING
The budget will be prepared consistent with the standards developed by the Government Finance Officers
Association and California Society of Municipal Finance Officers. In addition, a summary version will be
provided to the public in a user-friendly format.
The City will maintain a balanced operating budget for all funds with estimated revenues being equal to, or
greater than, estimated expenditures, and with periodic City Council reviews and necessary adjustments to
maintain balance.
On -going revenues will support on -going expenditures. Revenues from one-time or limited duration
sources will not be used to balance the annual operating budget.
Support function appropriations will be placed in the department in which they are managed.
GENERAL FUND BALANCE
The General Fund reserve (designation) will be a minimum of seven percent of the General Fund budget,
In addition, a second tier reserve will consist of the net accumulation of amounts that were in excess of the
seven percent reserve (designation) and remained in the General Fund after application of the financial
policy that immediately follows. This second tier reserve will be used to balance budget fluctuations.
Allocation of the audited General Fund balance in excess of the above reserves (designations) may be as
follows:
25 percent for capital projects (transferred to the Capital Improvement Reserve)
25 percent for Infrastructure transferred to the Infrastructure Fund)
50 percent to increase the 2 tier reserve
All supplemental appropriations from the General Fund minimum reserve that cannot otherwise be funded
during the current fiscal year operating budget must meet one of the three following criteria:
It is an unanticipated emergency.
It is required to implement a Memoranda of Understanding (MOU) or a mandate.
It is a new expense that is offset by related revenues.
Item 7. - 10 . -- FIB -54-
fHuntingtonw
Ali fFinano#al Follc.le.st�
FINANCIAL REPORTING AND ACCOUNTING STANDARDS
❑ The Citys accounting system will be maintained in accordance with generally accepted
accounting practices and the standards of the Government Accounting Standards Board
(GASB) and the Government Finance Officers Association (GFOA).
❑ The annual financial report will be prepared within six months of the dose of the previous
fiscal year. The City will use generally accepted accounting pdnclpies. In preparing the
annual financial statements and will attempt to qualify for the Government Finance Officers
Association's Excellence in Financial Reporting Program.
0 The City will strive for an unqualified audit opinion. An unqualified opinion is rendered
without reservation by the independent auditor that f nancial statements are fairly presented.
o The City will contract for an annual audit by a qualified independent certified public
accounting firm. The independent; audit firm will be selected through a competitive process
at least once every five years. The contract period will be for an initial period of three years,
with two one-year options.
BUDGETING
n The budget will be prepared consistent with the standards developed by the Government
Finance Officers Association and California Society of Mun€cipa] Finance Off cers (CSMFO).
In addition, a summary version will be provided to the public In a user-friendly format,
a The City will maintain a balanced operating budget for all funds with estimated revenues
being equal to, or greater than, estimated expenditures, and with periodic City Council
reviews and necessary adjustments to maintain balance.
❑ On-goirxd revenues will support on -going expenditures. Revenuesfrom one-time or limited
duration sources will not be used to balance the annual operating budget.
❑ Support function appropriations will be placed in the department in which they are managed.
GENERAL FUND BALANCE
❑ There will be an established Economic Uncertainties Reserve commitment in the General
Fund. The goal Is to have an Economic Uncertainties Reserve commitment equal to the
value of two months of the General Fund expenditure adopted budget amount.
n Once established, appropriations from the Economic Uncertainties Reserve commitment
can only be made by formal City Council action. Generally, appropriations and access to
these funds will be reserved for emergency situations. Examples of such emergencies
include, but are not limited to,
■ An unplanned, major event such as a catastrophic disaster requiring expenditures over
5% of the General Fund adopted budget
• Budgeted revenue taken by another govemment entity
Drop in projected/actual revenue of more than 5% of the General Fund adopted
revenue budget
a Should the Economic Uncertainties Reserve commitment be used, and its level falls below
the minimum amount of two months of General Fund expenditures adopted budget, the
goals is to replenish the fund within three fiscal years.
350
H B -55- Item 7. - 11
City of Huntington Beach
Financial Policies g_
,adopted Budget FY 2009/1-0
❑ Allocation of the audited General Fund unassigned fund balance will be done as follows if,
and until, the Economic Uncertainties Reserve commitment is fully funded (i.e., two months
of General Fund expenditurds):
• 50%to Economic Uncertainties Reserve commitment
• 25% for Infrastructure Fund
46. 256W to Capital Improvement Reserve (C) R) commitment
U Once tf-�e Economic Uncertainties Reserve commitment attains full funding, unassigned fund
balance will be divided as follows:
• 25% for Infrastructure Fund
f 25% to Capital Improvement Reserve (CIR) commitment
50% to Equipment Replacement commitment
11 Any unanticipated and unrestricted revenues recelved during the fiscal year will be added to
the fund balance of the General Fund,
FUND BALANCE CLASSIFICATION
❑ The Cites fund balance Is made up of the following components:
• Nonspendable fund balance typically includes inventories, prepaid items, and other
items that, by definiflon cannot be appropriated.
f The restricted fund balance category includes amounts that can be spent only for the
spedfic purposes stipulated by constitution, external resource providers, or through
enabling legislation.
• The committed fund balance classification includes amounts that can be used only for
the specific purposes determined by a formal action of the City Council. The City
Council has authority to establish, modify, or rescind a fund balance commitment.
• Amounts in the assigned fund balance classification are intended to be used by the
City for specific purposes but do not meet the criteria to be classified as restricted or
committed. The City Administrator or designee has the authority to establish, modify,
or rescind a fund balance assignment.
• Unassigned fund balance is the residual classification for the City's funds and includes
all spendable amounts not contained in the other classifications.
o The City considers restricted or unrestricted amounts to have been spent when an
expenditure is incurred for purposes for which both restricted and unrestricted fund balance
is available.
Q The City's committed, assigned, or unassigned amounts are considered to have been spent
when an expenditure is incurred for purposes for which amounts in any of those unrestricted
fund balance classifications could be used -
APPROPRIATION AUTHORITY
❑ The City Council is the appropriation authority for the City Budget, As required by state law,
appropriations expire at the end of each fiscal year.
351
Item 7. - 12 -. ... IAB -56- . -- .
Attachment 2
Project Sheets
HB -57- Item 7. - 13
il
FUNDING DEPARTMENT:
Community Services
DEPT. PROJECT MGR:
Dave Dominguez
SCHEDULE:
Design Complete: FY 2014/15
ConstrucUon Complete; FY 2015/16
PROJECT LOCATION
Y.
Parks & Bear-hes.x1sx
zi
'EACH M C1TYY,;0f UNTINGTONS.
......... .....
UPROVEMEN! R04, iZ 70F -770N`,�]�-�";':;��;'� FORMA
..... . ....
PROJECT COSTS
Prior
FY 14115
FY 15116
FY 16117
DesIgnIEnvironmental
157,500
$ 156.000
Construction
$ 1,150,000
Project Management
$ 100,000
Supplementals
$ 50,000
Continuing
50
Other
1$
TOTAL
167,500
156,000
$ 1,301,500
FUNDING SOURCES
Prior
FY 14116
FY 16116
FY 16117
Park Fees
Quimby Fees
$ 157,500
$ 156,000
$ 1,300,000
TOTAL
$ 157,500
1,300.000
MAINTENANCE COST IMPACT:
Additional annual cost
COMMENTS ON GRANTS I OTHER FUNDS:
11TOTAL PROJECT COST, $ 1,457,500
PROJECT TYPE; New Construction
CATEGORY: Parks & Beaches
Worthy Park
PRO ECT;TI.TE::;; a�[i :rmenadeParktRg
:`5ti`ucfire;#.erioVaiari
FUNDING DEPARTMENT:
Community Services
DEPT. PROJECT MGR:
David Dominguez
SCHEDULE:
Design Complete: FY 2015116
Construction Complete: FY 2015tl
r
, ��.Z�1��'�411dIj�J �E,l JliJ '�� '• n..�i���l�'I
i;sl;`rar-,�µ�h rk#iU�l�� �1'�• �� ..
kl;^,��; lip: .` �7�•�si�'W �c x''(k I 1 `f.•y ..,
��:F� {tyg �1 I C. Y`A� � �4 j ,[ 1 ) E IS3�RyI •t�(•�' lal�,
.t ulr.#�i.��`� ilr;Eii''kltz! 3�i��ii�•, x '�:;[iTt'C°ii',TM`F,�a�
facilities.xlsx
UIZ'CE•`C•aCCIMENT:
2ATF.GI6Pi AN r.0AI
PROJECT COSTS
Prior
FY 15116
FY 16117
FY 17M
FY 18119
DeslgWEnvlronmental
Construc fon
$ 1,500,000
Project Management
Supplementals
Right of Way
Other
TOTAL
$ 1,600,000-
FUNDIO SOURCES
Prior
FY 15/16
FY 16/17
FY 1711 S
FY 18119
Infrastructure un
$ 1,500,000
TOTAL
$ 1,500,000
MAINTENANCE COSTIMPACT:
Additional annual Cost. TED
COMMENTS ON GRANTS 1 OTHER FUNDS:
Infrastructure funds were appropriated as part of
FY 13-14 year-end budget adjustments.
TOTAI* PROJECT COST: $ 1,500,000
PROJECT TYPE: Rehabilitation
CATEGORY: Facilities
Main Parking Structure Renov.
...f,.....:....... ..,..... ...... r....„..,....,..,,.,..t..,.«.:r,.................
(D
J
7w�
F?ROJI=CTTLTLN;._ :New,e,nior;Gente
FUNDING DEPARTMENT:
Community Services
DEPT. PROJECT MGR:
Dave Dominguez
SCHEDULE:
Design Complete: FY 2014l15
Construction Complete: FY 2015116
Parks & Beaches.xlsx
PROJECT COSTS
Prior
FY 14115
FY 15116
FY 161V
Design/Environmental
$ 420,065
$ 286,950
Construction
$ 1,614,000
$ 18,875,000
Project Management
$ 650,000
Supplementals
$ 475,000
Continuing
$ 1,745,115
Other
TOTAL
2,034 065
$ 288,950
$ 21,745,115
FUNDING SOURCES
Prior
FY 14115
FY 15116
FY 16117
General Fund
$ 2,000,000
1nfrFund
$ 1,500,000
$ 1,000,000
Park Fees
i $ 300,000
$ 197,385
HUD FDl 1t90 and # 130 Grants
$ 234,065
$ 91,565
Donations
$ 2,000,000
Potential Bond Financing
$ 15,000,000
TOTAL
$ 2,034,065
$ 20,000,000
MAINTENANCE COST IMPACT:
Additional annual cost: Nonei
COMMENTS ON GRANTS 1 OTHER FUNDS:
Current financing plan has not yet been approved.
Staff is researching potential bond financing.
TOTAL PROJECT COST: 22,034 065
F'UN�bs�� :.? „�.. 'f00 :20H •�94 3,74
•: is
PROJECT TYPE: New Construction
CATEGORY: Parks & Beaches
Senior Center
...... .... :..I."............I
-1
P
618iiiab-bh
FUNDING DEPARTMENT: "^
Public Works
DEPT. PROJECT MGR:
Jim Wagner
SCHEDULE:
Design Complete: FY 2014/15
Construction Complete: FY 2016/17
ECT
f
L
drainage.xlsx
PROJECT COSTS
Prior
FY 15116
FY 16117
FY 17118
FY 18fig
Design/,Environmental
$ 344,300
Construction
$ 1,334,000
$ 2,550,000
Project Management
Supplementals
t of Way
Other
TOTAL
2,678,300
$ 2,550,000
FUNDING SOURCES
Prior
FY 15116
FY 16117
FY 17N 8
FY 18119
fnfr Fund (314)
Haz Mit (1222)
$ 2,678,300
$ 2,550,000
TOTAL
$ 2,678,300
2,660,000
MAINTENANCE COST IMPACT:
Additional annual cost: None
!COMMENTS ON GRANTS I OTHER FUNDS:
11TOTAL PROJECT COST: $ 5,228,300l
PROJECT TYPE: New Construction
CATEGORY: Drainage
Heil PS
............ . . I
PROJECT TITLE: Arterial Rehabilitation
FUNDING DEPARTMENT:
Public Works
DEPT, PROJECT MGR:
Jim Wagner
SCHEDULE:
Design Complete: FY 2016117
Construction Complete: FY 2016/17
PROJECT LOCATION
streets & transportation.xlsx
Arterials identified For FY 16/17 include Heil Ave. (Edwards to Springdale),
Atlanta Ave. (Delaware to Beach), and Indianapolis Ave. (Beach to Magnolia)
ROJECT NEED: Required to meet the goals of the Pavement Management Plan
URCE DOCUMENT: 2016 Pavement Management Plan
Enhance and maintain
PROJECT COSTS
FY 16117
FY 17118
FY 18/19
FY 19/20
FY 20/21
Design/Environmental
$
50,000
$
50,000
$
50,000
$ 50,000
$
50,000
Construction
$
3,000,000
$
2,000,000
$
2,000,000
$ 2,000,000
$
2,000,000
Project Management
$
100,000
$
100,000
$
100,000
$ 100,000
$
100,000
Supplementals
S
50,000
$
50,000
$
50,000
$ 50,000
$
50,000
RIW
Other
$
1,200,000
$
1,200,000
$
1,200,000
$ 1,200,000
$
1,200,000
TOTAL
4,400,000
$
3,400,000
$
3,400,000
$ 3 400,000
$
3,400,000
FUNDINGSOURCES
FY 16117
FY 17/18
FY 18110
FY 19120
FY 20121
General Fund (00)
$
1,00 ,000
$
1,000,000
$
1,000,000
$ 1,000,000
$
1,000,000
Measure M (293)
$
2,000,000
$
1,200,000
$
1,200,000
$ 1,200,000
$
1,200,000
Prop 42 (219)
$
200,000
intr Fund (394)
$
1,200,000
$
1.200,000
$
1,200,000
$ 1,200,000
$
1,200,000
TOTAL j
$
4,400,000
IS
3,400,000
$
3,400,000
3,400,000
$
3,400,000
MAINTENANCE COST IMPACT:
Additional annual cost:
IAny unanticipated maintenance cost will be
included In Public Works Operating Budget.
COMMENTS ON GRANTS I OTHER FUNDS:
Additional $1,200,000 needed to bring PCI to 80
within 7 years.
TOTAL PROJECT COST: $ 18,000,000
TEGORY:
obi
PWE Arterial Rehabilitation
........... r .., r .. .......... .
;-a
`..
CAD L
FUNDING DEPARTMENT:
Public Works
DEPT. PROJECT MGR:
Jo Claudio
SCHEDULE:
Design Complete: FY 2014/16
Construction Complete: FY 2015/16
ECT L
El
J
streets & transportation.xlsx
PRO ^: ,T COSTS
Prior
FY 16116
rY 16117
FY 17118
FY 18119
Design/En7tronmenta1
$ 396,000
Construction
$ 1,600,000
$ 1,200,000
Project Management
Supplementals
Right of Way
$ 4,759,364
Other
ConUnuing
TOTAL
6 55 664
1,200,000
FUNDING SOURCES
Prior
FY16116
FY16117
FY1711B
FY18119
Measure M (213)
$ 600,000
Prop 42 (219)
$ 1,450,000
Infr Fund (314)
$ 1,600,000
Traffic Impact Fee (206)
$ 896,000
OCTA (873)
$ 2,209,364
$ 1,200,000
TOTAL
6,755,364
1,200,000
MAINTENANCE COST IMPACT:
Additional annual cost: None
COMMENTS ON GRANTS / OTHER FUNDS:
TOTAL PROJECT COST: $ 7,956,364
TEGORY:
Atlanta Widening
M
f:
.......... __...,._..<<.,..�.......... _.... ...... ........�r.v „_,.., _.,,.i.., 1-T.
Attachment 3
Infrastructure Fund (314) Summary of Budget and Expenditure
Activity -- FY 15-16 and Transaction Detail
Ite1n 7. - 20 _ _ �
Infrastructure Fund 314j Summary of Budget and Expenditure Activit - FY 15-16
Revised 16-16
Encumbrance
Transfers and
CIP Carry
Budget
Actual
Carry Over to
Adjustments
Forward to 16-
Project
Business Unit
16-17
17
Worthy Park Phase 1
31445002
$500,000
$1,304
$47,600
$451,096
Main Prom P.S. Improvements
31445003
$1,403,241
$1,121,085
$174,340
$117,175
Infrastructure Design/Const
31485201
$1,506,763
$993,983
$3,600
$509,180
LED Lighting Retrofit
31485304
$68,591
$68,591
$0
$0
Senior Center
31487003
$2,545,340
$147,047
$6,909-$1,225,000
$1,166,389
Neil Pump Station ROW/Const
31488001
$2,323,548
$30,116
$16,830
$2,277,572
to
Bella Terra Pedestrian Crossing
3149001
$263 gag
$0
$Q
$263,639
v
' Arterial Rehabilitation
31490003
$0
$285
$0
$0
Atlanta Avenue Widening
31490004
$0
$196,290
$140,000 $1,000,000
$513,710
Totals
$8,611,122
$2,658,701
$389,279-$225,000
$6,298,761
note - amounts have been rounded to the nearest dollar
we
iv
GL Date
Account
General Ledger
Description
Journal
Entry Remark
Batch
Number
Amount
Data
Explanation
Business Unit 31445002- Worthy Park Phase I
9/12/2016
31445002.82900
118.59 Park Improvements
HB DIGITAL ARTS & BLUEPRINT IN CC 1513 Worthy Park
9/12/2016
9/12/2016
31446002.82900
1,185.84 Park improvements
HB DIGITAL ARTS & BLUEPRINT IN CC 1513 Worthy Park
9/12/2016
subtotal
1,304.43
Business Unit 31445003 - Main Promenade Parking Structure
1/29/2D16
31445003.51110
157.89 Base Salaries
Payro€i Labor Distribution
2/4/2016
3/11/2010
31445003.51110
684.19 Base Salaries
Payroll Labor Distribution
3117/2016
3/2512016
31445003.51110
789,45 Base Salaries
Payroll Labor D€stribution
3/31/2016
4/&2016
31445003,51110
473,67 Base Salaries
Payroll Labor Distribution
4/1412015
4/22J2016
31445003.51110
526.30 Base Salaries
Payroll Labor Distribution
4128/2016
5/6/2016
31445003.51110
994.71 Base Salaries
Payroll Labor Distribution
511212016
5/2012016
31445003.51110
789.45 Base Salaries
Payroll Labor Distribution
512612015
6/3/2016
31445003.51110
842.08 Base Salaries
Payroll Labor Distribution
6/9/2016
6/17/2016
31445003.51110
842.08 Base Salaries
Payroll Labor Distribution
6/2&2016
7/1/2016
31445003.51110
421.04 Base Salaries
Payroll Labor Distribution
W712016
1/29/2016
31445003.55110
39.31 CaiPERS Employer Cost
Actual Burden Journal Entries
214=16
3/11/2016
31445003.55110
170.29 CaIPERS Employer Cost
Actual Burden Journal Entries
3/1712016
3/2512016
31445003,55110
196.47 CaIPERS Employer Cost
Actual Burden Journal Entries
3131 12016
4/8/2016
31445003.55110
117.88 CaIPERS Employer Cost
Actual Burden Journal Entries
4/14/2016
4/22/2016
31445003.55110
130,98 CsIPERS Employer Cost
Actual Burden Journal Entries
4/28/2016
516/2016
31445003.55110
222.66 Ca€PERS Employer Cost
Actual Burden Journal Entries
5/12J2016
5/20/2016
31445003,55110
196.47 CafPERS Employer Cost
Actual Burden Journal Entries
5/26/2016
6/3/2016
31445003.55110
209.57 CHIPERS Employer Cost
Actual Burden Joumaf Entries
6/9/2016
6/17/2016
3144500155110
209.32 CaIPERS Employer Cost
Actual Burden Journal Entries
E42312016
711/2016
31445003.56110
111.74 C81PERS Employer Cost
Actual Burden Journal Entries
7/7/2016
9/29/2016
31445003,55110
53.16 CafPERS Employer Cast
Adj PERS Payroll Contr Biwk€y
11/15/2016
1129/2016
31445003.55175
6.73 Workers Compensation
Actual Burden Journal Entries
2/4/2016
3/11/2016
31445003.55175
29.15 Workers Compensation
Actual Burden Journal Entries
311712016
M512016
31445003.55175
33.63 Workers Compensation
Actual Burden Journal Entries
3/31/2016
4/812016
31445003.55175
20.18 Workers Compensation
Actual Burden Journal Entries
4/1412016
4/22/2016
31445003.55175
22.42 Workers Compensation
Actual Burden Journal Entries
4/28/2016
5/6/2016
31445003.55175
38.11 Workers Compensation
Actual Burden Journal Entries
511212016
5/20/2016
31445003.55175
33.63 Workers Compensation
Actual Burden Journal Entries
5/2612016
6/3/2016
8/17/2010
7/l/2016
9/29/2016
1/29/2016
3/11/2016
312512016
41M016
4/22/2016
5/6/2016
512012016
613/2016
611712016
7/1/2016
1/2912016
311 V2016
3/25/2016
4/8/2016
4IM2016
5/6/2016
5/20/2016
6/30116
6/17/2016
711/2016
9/29/2016
1/2912016
3/11/2016
3/25/2016
4/8/2016
5/6/2016
5/20/2016
6/3/2016
6/17/2016
7/1/2016
9/29/2016
1/2912010
31445003.55175
31445003.55175
31445003,56175
31445003.55175
31445003.55280
31445003.55280
31445003.55280
31445003.55280
31445003,55280
31445003,55280
31445003.55280
31445003.55280
31445003.552B0
31445003.55280
31445003.55350
31445003.55350
31445003.55350
31445003.55350
31445003.55350
31445003.55350
31445003.66350
31445003.55350
31445003.55350
31445003.55350
31445003.55350
31445003.55375
31445003.55375
31445003.55375
31445003.55375
31445003.55375
31445003.55375
31445003.55375
31445003.55375
31445003.55375
31445003,55375
31445003,55400
35.87 Workers Compensation
35,87 Workers Compensation
17.94 Workers Compensation
10,55 Workers Compensation
6.45 Waived Medical Insurance
27.99 Waived Medical Insurance
32.29 Waived Medical Insurance
19.37 Waived Medical insurance
21.53 Waived Medical Insurance
36.59 Waived Medical Insurance
32-N Waived Medical Insurance
43.08 Waived Medical Insurance
14.36 Waived Medical insurance
21.53 Waived Medical Insurance
0.30 Vision Gore
1.34 Vision Care
1.54 Vision Care
0.93 Vision Care
1.03 Vision Care
1.75 Vision Care
1.54 Vision Care
1.65 Vision Care
0.55 Vlslon Care
0.82 vision Care
-1.60 Vision Care
0.90 Disability
3.91 Disability
4.49 Disability
2.70 Dlsabllity
5,09 Dfsabllity
4,49 Dfsabllity
4.79 Disability
1.60 Disability
2.41 Disability
-4.66 Disability
2.02 Dental Insurance
Actual Burden -Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
True Up WC Rev & Exp
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Joumal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Adj Vision Payable
Actual Burden Journal Entries
Actual Burdett Journal Entries
Actual Burden Jaumal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Joumal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Adj LTD Liab
Actual Burden Jaumal Envies
61912016
6/23/2016
717/2016
11 /312016
2/4/2016
3/17/2016
3/31/2016
4/14/2016
4/28/2016
5/12/2016
5/26/2016
6/9/2016
6/23/2016
7/7/2016
2/4/2016
3/17/2016
313112016
4/14/2016
4/28/2016
5/12/2016
5/26/2016
6/9/2016
6/23/2016
7n/2016
11115/2016
2/4/2016
3/17/2016
3/3112016
4/14/2016
5/12/2016
5/2612016
6/9/2016
6/23/2016
m/2016
11/15/2016
2/4/2016
N
W.......... ._..... t ... w, r ..
3/11/2018
31445003.55400
8.72
Dental Insurance
Actual Burden Journal Entries
311712016
3/25/2016
31445003.55400
10.07
Dental Insurance
Actual Burden Journal Entries
3/31/2010
41812D16
31445003.55400
6.04
Dental Insurance
Actual Burden Journal Entries
4/1412016
4/22/2016
31445003.55400
6.71
Dental Insurance
Actual Burden Journal Entries
4/2812016
5/6/2016
31445003,55400
11.41
Dental Insurance
Actual Burden Journal Entries
511212016
5/20/2016
3144500155400
10.07
Dental Insurance
Actual Burden Journal Entries
5/26/2016
6/3/2016
31445003.55400
10.74
Dental Insurance
Actual Burden Journal Entries
6/9/2016
6/17/2016
31445003.55400
3.58
Dental Insurance
Actual Burden Journal Entries
6/23/2016
7/1/2016
31445003.55400
5.36
Dental Insurance
Actual Burden Journal Entrles
7/7/2016
1/29/2016
31445003.55450
0.10
Life Insurance
Actual Burden Joumal Entries
2/4/2016
3/11/2016
31445003.55450
0.43
Life Insurance
Actual Burden Joumal Entries
3/17/2016
3/25/2016
31445003.55450
0.51
Life Insurance
Actual Burden Journal Entries
3/31/2016
4/8/2016
31445003.55450
0.31
life Insurance
Actual Burden Journal Entries
4/14/2018
5/6/2016
31445003.55450
0.59
Life Insurance
Actual Burden Journal Entries
5/1212016
5/20/2016
31445003.55450
0.51
Ltfe Insurance
Actual Burden Journal Entries
5/26/2016
6/3/2016
31445003.55450
0.55
Life Insurance
Actual Burden Journal Entries
6/9/2016
6/17/2016
31445003.55450
0.18
Life Insurance
Actual Burden Journal Entries
6/23/2016
7/1/2016
31445003.55450
0.26
Life Insurance
Actual Burden Journal Entries
7/712016
9/2912D16
31445003.55450
0.88
Life insurance
Adj Life Insurance Liab
11/1512016
Gr
1/29/2016
31445003,58020
2,38
FICA Medicare
Actual Burden Journal Entries
2/412016
3/1112016
31445003.56020
10.29
FICA Medicare
Actual Burden Journal Entries
3/1712016
3/25/2016
31445003.56020
11.a7
FICA Medicare
Actual Burden Journal Entries
3/31/2016
4/8/2016
31445003.56020
7,12
FICA Medicare
Actual Burden Journal Entries
4/14/2016
4122/2016
31445D03.56020
7,92
FICA Medicare
Actual Burden Journal Entries
4128/2016
5/6/2016
31445003.56020
13.46
FICA Medicare
Actual Burden Journal Entries
5/12/2016
5/20/2016
31445003.66020
11.87
FICA Medicare
Actual Burden Journal Entries
5/26/2016
613/2016
31445003.56020
12.79
FICA Medicare
Actual Burden Journal Entries
6/9/2016
6/1712016
31445003.56020
12.40
FICA Medicare
Actual Burden Journal Entries
6/23/2016
7/1/2016
31445003.56020
6.39
FICA Medicare
Actual Burden Journal Entries
7/7/2016
10/1/2015
31445003,82800
-59,598.64
Other Improvement
AP ACCRUAL NO VOID RO
PV561386
11/20/2015
10/2612015
31445003.82800
59,59B.84
Other Improvement
WALKER PARKING CONSULTANTS
ccl534 Downtwn Pking Structure
1012612015
12/i412016
31445003.82800
46,162.14
Other Improvement
WALKER PARKING CONSULTANTS
cc1534 Downtwn Pking Structure
12/1412015
1/25/2016
31445003,132800
5,263.33
Other Improvement
WALKER PARKING CONSULTANTS
cc1534 Downtwn Pking Structure
1/2512016
212/2016
31445003.82800
218.16
Other Improvement
HB DIGITAL ARTS & BLUEPRINT IN
CC 1534 Main Promenade
202016
2/9/2016
31445003.82800
7.800.00
Other Improvement
MAIN PROMENADE INC
Main Prom Elevator Room
2/9/2016
2/9/2016
31445003.82800
27,600.00
Other Improvement
MAIN PROMENADE INC
Main Prom Stairwell
2/9/2016
.n ...... , ....: ..... ..... .... ..._,.. ... .. ..... ...... .. - ., " ... 1.1. .. ........ _.r._ 5 ... ...., I., ....... .i l ..... i l ,. ....., .... ...
2/22/2016
31445003.82800
5,627.50 Other Improvement
WALKER PARKING CONSULTANTS
cc1534 Dmmtwn Pking Structure
2/22/2016
3/1612016
31445003,82800
4,037.58 Other Improvement
WALKER PARKING CONSULTANTS
cc1534 Downtwn Pking Structure
3/15/2016
4/12/2016
31445003.82800
22,084.41 Other Improvement
ANGELUS WATERPROOFING & RESTOR
CC 1534 Main Promenade
4/12/2016
4/13/2016
31445003.82800
1,336.D0 Other Improvement
HARRIS & ASSOCIATES
CC 1534 Main Promenade
4/13/2416
4126/2016
31445003.82800
4,050.D0 Other Improvement
WALKER PARKING CONSULTANTS
cc-1534 Downtwn Pking Structure
4/2612016
512312016
31445003.82800
3,234.72 Other Improvement
WALKER PARKING CONSULTANTS
cc1534 Downtwn Pking Structure
512312D16
5/26/2016
31445003.828D0
7.014.Do Other Improvement
HARRIS & ASSOCIATES
CC 1534 Main Promenade
5/26/2016
61V2016
31445003,82800
185,749.85 Other Improvement
ANGELUS WATERPROOFING & RESTOR
CC 1534 Main Promenade
6/1/2016
6/13/2016
31445003.82800
167,943.12 Other Improvement
ANGELUS WATERPROOFING & RESTOR
CC 1534 Mein Promenade
6/1312016
6114/2016
31445003.82800
D.00 Other Improvement
SCHINDLER ELEVATOR CORP
CC1534 Main Promenade
6/1412016
612012016
31445003,92800
14,435.00 Other Improvement
AESCO INC
CC 1534 Main Promenade parking
6/2012016
612i12016
31445003.82800
8,425.69 Other Improvement
WALKER PARKING CONSULTANTS
cc1534 Downtwn Pking Structure
6/2112016
6128/2016
31445003.82800
0.00 Other Improvement
SCHINDLER ELEVATOR CORP
CC1534 Main Promenade
6/2812016
6/28/2016
31445003.82800
1,084.00 Other Improvement
SCHINDLER ELEVATOR CORP
C01534 Main Promenade
612812016
7f11/2016
31445003.82800
226,636.63 Other Improvement
ANGELUS WATERPROOFING & RESTOR
CC 1534 Main Promenade
7/1112016
7/19/2016
31445003.82800
6,750.00 Other Improvement
WALKER PARKING CONSULTANTS
cc1534 Downtwn Pking Structure
711912016
7121/2016
31445003.82800
9,295.00 Other Improvement
AESCO INC
CC 1534 Main Promenade parking
712112016
8/16/2016
31445003.82800
6,150.00 Other Improvement
WALKER PARKING CONSULTANTS
cc1534 Downtwn Pking Structure
8/1612016
8/23/2016
31445003.82800
6,847.00 Other Improvement
HARRIS & ASSOCIATES
CC 1534 Main Promenade
8/23/2016
8/23/2016
31445003.82800
7,269.00 Other Improvement
HARRIS & ASSOCIATES
CC 1534 Main Promenade
8/2312018
8/23/2016
31445003.82800
75,031.42 Other Improvement
ANGELUS WATERPROOFING & RESTOR
CC 1534 Main Promenade
8/2312016
8/2912016
31445003.82800
9,598.00 Other Improvement
HARRIS & ASSOCIATES
CC 1534 Main Promenade
8/2912016
8/29/2016
31445003.82800
5,600.00 Other Improvement
HARRIS & ASSOCIATES
Change Order
8/2912016
9/12/2016
31445003.82800
68,245.23 Other improvement
ANGELUS WATERPROOFING & RESTOR
CC 1534 Main Promenade
9/12/2016
9119/2016
31445003.82800
8,551.90 Other Improvement
HARRIS &ASSOCIATES
Change Order
9119l2D16
9/30/2016
31445003.82800
14,400.00 Other Improvement
AP ACCRUAL NO VOID RO
PV 591124
11/18/2016
9130/2016
31445003.82800
8,851.00 Other improvement
AP ACCRUAL NO VOID RO
PV 591577
11/18/2016
9/30/2016
31445003.82800
93,496.68 Other Improvement
AP ACCRUAL NO VOID RO
PV 591578
11/19/2016
9/30/2016
31445003.82800
4d,167.76 Other Improvement
Accrue Retentions
21538 01
12129/2016
9130/2016
31445003.82800
9,300.00 Other Improvement
Year End Accrual
PV 595238
1/6/2017
subtotal
1,121,094.69
Business Unit 31485201 - Infrastructure Engineering/Design
Beach Parking Lot
101112D15
31485201.82300
-22,736.14 Streets Improvement
Accrue Retention 14/15
12/31/2015
12114/2015
31485201.82300
25,496.14 Streets Improvement
ALL AMERICAN ASPHALT
CC 1484 City Beach Parking Lot
12/14/2015
2,760.00
J
Central Park Improvements
11/25/2015
31485201.82300
36,750.00 Streets Improvement
MERCHANTS LANDSCAPE SERVICES I
Central Park Clearing
11/25/2015
3/1412016
31485201,82300
800.00 Streets Improvement
HAMILTON BIOLOGICAL INC
Nesting Bird inspections
3114/2016
1112/2015
31485201.82800
9,540.00 Other Improvement
MARK BARD CONSTRUCTION CO
Central Park Dr. concrete
11/2/2015
11/21201a
31485201.82800
29,929.93 Other Improvement
NOBEST INC
Curbs Central Park Dr median
111212015
10/1/2015
31485201.82800
-29,929.93 Other Improvement
AP ACCRUAL NO VOID NO RO
PV 551846
1112D/2015
47,000,00
Atlanta Avenue Widening
9/3012016
31485201,82300
393,361.29 Streets Improvement
CA STATE TREASURER'S CONDEMNAT
Change Order
9/30/2016
9/30/2016
31485201.82300
277,135.43 Streets Improvement
CA STATE TREASURER'S CONDEMNAT
Condemnation-Attante Widening
9/30/2016
9/3012016
31485201.92300
22,736,00 Streets Improvement
Accrue Retentions
20536 OJ
12/29/2016
3/2912016
31485201.82700
78,608.00 Traffic Improvement
Trans Exp. OCTA to Atlanta AWP
312&2016
4/2512016
31485201.82700
19,277.00 Traffic Improvement
SURF CITY BEACH COTTAGES
rent/UYBities
4/25/2016
5/20/2016
31485201.82700
19,277.00 Traffic Improvement
SURF CITY BEACH COTTAGES
rentlUtiifties
5/2012016
6/13/2016
31485201.82700
1,200.00 Traffic Improvement
SPECTRUM CARE LANDSCAPE & IRRI
Atlanta Widening
6/13/2016
6/1312016
31485201.827D0
19,277.00 Traffic Improvement
SURF CITY BEACH COTTAGES
rent/Utilides
6/13/2016
7/2212016
31485201.82700
19,277.a0 Traffic Improvement
SURF CITY BEACH COTTAGES
Change Order
7/22/2016
8/1512016
31485201.82700
17,108.00 Traffic Improvement
SURF CITY BEACH COTTAGES
Change Order
8/15/2016
8/15/2016
31485201.62700
2,169.00 Traffic Improvement
SURF CITY BEACH COTTAGES
rendUtiGUas
8/15/2016
9119/2016
31485201.82700
820.00 Traffic Improvement
SPECTRUM CARE LANDSCAPE & IRRI
Atlanta Widening
W1912016
9/2012016
31485201.82700
19,277.00 Traffic Improvement
SURF CITY BEACH COTTAGES
Change Order
9/20/2016
9/28/2016
31485201 A2700
-196,290.00 Traffic Improvement
Reclass Expenditures
9/28/2016
693,232.72
Hall
Storm Water Pump Station
10126/2015
31485201.92800
900.00 Other Improvement
VALENTINE APPRAISAL & ASSOC
CC 1293 Hell Storm Water
1012612015
900.00
Huntington
Harbour Dredging
12/7l2015
31485201.82800
250,000.00 Other Improvement
COUNTY OF ORANGE OC PARKS
Dredge P862, CC 1446 & 1472
12/7/2015
250,000.00
subtotal
993,982.72
Business Unit
31485304 -LED Retrofits
10/1/2015
31485304,82850
-200.00 Street Lights Improvement
AP ACCRUAL NO VOID RO
PV 59642
11/20/2015
10/1/2015
31485304,82850
-205,00 Street Lights Improvement
AP ACCRUAL NO VOID RO
PV 548843
11/2012015
10/12/2015
31485304.82850
200,00 Street Lights Improvement
MERCURY DISPOSAL SYSTEM INC
RECYCLE LIGHT FIXTURES/LAMPS
10/12/2015
10112/2015
31485304,82850
205.00 Street Lights Improvement
MERCURY DISPOSAL SYSTEM INC
RECYCLE LIGHT FIXTURESf AMPS
10/1212015
1/26/2016
314853a4.82850
88,590.80 Street Lights Improvement
GRAYBAR
PHILLIPS POST TOP LED LIGHT
1/26/2016
subtotal
Business Unit 31497003 - Senior Canter
10/23/2015 31487003,51110
11/6/2015 31487OW-51110
10/23/2015 31487003,55110
11/6/2015 31487003.55110
9/29/2016 31487003.55110
10/23/2015 31487003.55175
1116/2015 31487003.55175
9/29/2010 31487003.55175
10/23/2015 31487003.55266.10
11/6/2015 314-87003.5526610
9/29/2016 31487003.55206.10
10/23/2015 31487003.55350
11/5/2015 31487003,55350
9/29/2016 31487003.55350
11/6/2015 31487003.55375
9/2912016 31487003-55375
10/2312015 31487003,55400
11/6/2016 31487003.55400
11/6/2016 31487003.55450
9/29/2016 3107003,55450
10/23/2015 31487003.56010
11/6/2015 31487003,56010
9/29/2016 314870W.56010
10/23/2015 31487003-56020
11/6/2015 31487003.56020
6/13/2016 31487003.82200
6/21/2016 31487003.82200
6121/2010 31487003.82200
6/21/2016 31487003.82200
7/512016 31487003.82200
7/6/2016 31487003.82200
711112016 314-37003.82200
91301.2015 31487003,82200
5/17/2010 31487003.82700
68,590.80
45.53 Base Salaries
273,18 Base Salaries
11.34 CAL PERS Employer Cost
88,07 CAL PERS Employer Cost
2.03 CAL PER$ Employer Cost
4.61 Workers Compensation
27.67 Workers Compensation
1.24 Workers Compensation
6.91 Teamster -UHC HMO
41.43 Teamster -UHC HMO
1.10 Teamster- UHC HMO
0.13 Vision Care
0.76 Vision Care
-0.12 Vision Care
1.80 Disability
-0.28 Disability
D,78 Dental Insurance
4.68 Dental Insurance
0.21 Llfe Insurance
0,05 Life Insurance
0,07 Deferred Compensation
0.41 Deferred Compensation
0.03 Deferred Compensation
0.62 FICA Medicare
3.73 FICA Medicare
3,250.00 Buildings Improvement
1,615.95 Buildings Improvement
1,709.80 Buildings Improvement
53.98 Buildings Improvement
5,504.00 Buildings Improvement
224.80 Buildings improvement
2,275.00 Buildings Improvement
1,024.44 Buildings improvement
31,290.85 Traffic Improvement
Payroll Labor Distribution
Payroll Labor Distribution
Actual Burden Journal Entries
Actual Burden Journal Entries
Adj PERS Payroll Contr Biwkly
Actual Burden Journal Entries
Actual Burden Journe I Entries
True Up WC Rev & Exp
Actual Burden Journal Entries
Actual Burden Journal Entries
Adj Teamster Medical Liab
Actual Burden Journal Entries
Actual Burden Journal Entries
Adj Vision Payable
Actual Burden Journal Entries
Adj LTD Llab
Actual Burden Journal Entdes
Actual Burden Journal Entries
Actual Burden Journal Entries
Adj Life Insurance Liab
Actual Burden Journal Entries
Actual Burden Journal Entries
Adj Deferred Comp Liab
Actual Burden Journal Entries
Actual Burden Journal Entries
MERCHANTS LANDSCAPE SERVICES I
JHM & CARSON SUPPLY
JHM & CARSON SUPPLY
JHM & CARSON SUPPLY
BILL'S HYDROS EED
irrigation sup. for San center
MARK BARD CONSTRUCTION CO
AP ACCRUAL NO VOID RO
MSL ELECTRIC INC
CC: 1473 Senior Center
IRRIGATION MATERIALS
IRRIGATION MATERIALS
IRRIGATION MATERIALS
hydroseed at Senior Center
CC 1473 Senior Center
PV 591073
CC 1473 Senior Cntr/Material
1012912015
11112/2015
10/29/2015
11/12/2015
11115/2016
10/29/2015
11/12/2015
11/3/2016
10/29/2015
1111212015
11115/2016
10129/2015
11112/2015
11/15/2018
11/12/2015
11/15/2016
10129121 015
11f1212015
1111212015
11/15/2016
10/29/2015
11112/2015
11/15/2016
10129/2015
11/12/2015
8/13/2016
6/21/2016
6/21/2016
6/21/2016
7/5/2016
7/6/2016
7/11/2016
11/18/2016
5/17/2016
.. ................ ..... i......,.,..-_..........:.......... .... ... _.,..,Ir._.._...<..,.i..L.,_...1.,..,.,.:....,......
r.�
,
J
N
5/1712016
31487003.82700
5/17/2016
31487003,82700
5/17/2018
31497003,82700
5/17/2016
31497003.82700
5/17=16
31487003,82700
5/18/2016
31487003.82700
7f12/2016
31487003.8270D
7/12/2016
31487003.827DO
9/1912016
31487003.827DD
subtotal
Business Unit 31488001 - Hell Pump Station
7/1/2016
31488001.51110
7/15/E016
31488001.51110
729/2016
31488001.51110
8/1212016
31489001.51110
82612016
314880a 1.51110
9/9/2016
31489001.51110
923/2016
31488001,51110
9/30/2016
31488001.51110
7/1/2016
31498001,55110
7/15/2016
31498001.5511D
7/29/2016
31488001,55110
8/122016
31488001.55110
8/262016
31488001.55110
9/92016
31488001.55110
923/2016
31488001.55110
9/29/2016
31488001.55110
9/30/2016
31488001.55110
7/1/2016
31488001.55175
7/15/2016
31488001.55175
71292016
31489001.55175
8/12/2016
31488001.55175
8/2612010
31488001.55175
9/9/2016
31488001.55175
9f232016
31488001.55175
9/29/2016
31488001.55175
20,125.00 Traffic Improvement
MSL ELECTRIC INC
labor
5/1712016
5.955.00 Traffic Improvement
MSL ELECTRIC INC
Tools & Equipment
5/1712016
14,211.12 Traffic Improvement
MSL ELECTRIC INC
CC 1473 Senior Cntr/Matedal
511712016
16,100.00 Traffic Improvement
MSL ELECTRIC INC
labor
5/1712016
4.764.00 Traffic Improvement
MSL ELECTRIC INC
Tools & Equipment
5/1712016
20,832.49 Traffic Improvement
Senior Center Traffic Signal
5/182016
4,025.00 Traffic Improvement
MSL ELECTRIC INC
labor
7/12/2016
1,191.00 Traffic Improvement
MSL ELECTRIC INC
Tools & Equipment
7/1=016
12,397.54 Traffic Improvement
MSL ELECTRIC INC
CC 1473 Senior Cntr/Materiel
9/1912016
147,046.55
257.76 Base Salaries
Payroll Labor Distribution
7/7/2016
114.56 Base Salaries
Payroll Labor Distribution
721=16
343.68 Base Salaries
Payroll Labor Distribution
81412016
1,489.28 Base Salaries
Payroll Labor Distribution
811812016
1,231.52 Base Salaries
Payroll Labor Distribution
9/1/2016
458.24 Base Salaries
Payroll Labor nistrlbution
9/i5/2016
544.16 Base Salaries
Payroll Labor Distribution
9/29/2016
686.56 Base Salaries
Payroll Accrual 15-16
10/21/2016
68.39 CeIPERS Employer Cost
Actual Burden Journal Entries-
7/7/2016
30.40 CeIPERS Employer Cost
Actual Burden Journal Entries
7/21/2016
91.21 CeIPERS Employer Cost
Actual Burden Joumai Entries
8/4/2016
395.21 C31PERS Employer Cost
Actual Burden Journal Entries
8/182016
326.80 CalPERS Employer Cost
Actual Burden Journal Entries
9/l2016
121.60 CaIPERS Employer Cost
Actual Burden Journal Entries
91152a16
144.40 CalPERS Employer Cost
Actual Burden Journal Entries
9/292016
45.06 CeIPERS Employer Cost
Adj PERS Payroll Contr Biwkly
11/15/2016
182.19 CeIPERS Employer Cost
Payroll Accrual 15-16
10212016
10.98 Workers Compensation
Actual Burden Journal Entries
7/7/2016
4.88 Workers Compensation
Actual Burden Journal Entries
712112016
14.64 Workers Compensation
Actual Burden Journal Entries
8/4/2016
63.44 Workers Compensation
Actual Burden Journal Entries
811 Kai 6
52.46 Workers Compensation
Actual Burden Joumal Entries
911=16
19.52 Workers Compensation
Actual Buren Journal Entries
9/15/2016
23.18 Workers Compensation
Actual Burden Journal Entries
9/2912016
8.42 Workers Compensation
True Up WC Rev & Exp
11/3/2016
.{ ........ . . .. . ......1. 1. ............. ..I .......... ,........__. I . 1 .... .,.., ........,... , ..� t .- j � ...........
we
m
9/30/2016
7/1/2016
7/1512D16
7/29=16
8/1V2016
8126/2016
919/20i6
912312016
9/29/2016
9/3012D16
7/1/2016
711512016
712912016
811212016
9/2612016
9/9/2016
9/29/2018
9130/2016
7/112016
7/15/2016
7/29/2016
8/12/2016
8/26/2016
9/912016
9/2312016
9/3012D16
71112016
7/1512016
7/29/2016
8/12/2016
8/26/2016
9/9/2016
9/29/2016
9/30/2016
7/1/2016
7/15/2016
31489001.55175
31488001.55350
31488001.55350
31488001.65350
31488001.55350
31488001.55350
31488001,55350
31488001.55350
31488001.55350
31488DD1.55350
31488001.55375
31488001.55375
31488091.55375
31488001.55375
31488DOl_55375
31488D01.55375
31488001.55375
31488001,55375
31488001,55400
31488001,55400
31488001,55400
31488001.55400
31488001.55400
31488001.55400
31488001,55400
31488001.55400
31488001.55450
31488001.55450
31488001.55450
31488001.55450
31488001.55450
31488001.55450
31488001,55450
31488001.55450
31488001.56020
31488001.56020
29.25 Workers Compensation
D.46 Vision Care
0.21 Vision Care
0.62 Vision Care
2.68 Vision Care
221 Vision Care
0.82 Vision Care
0.98 Vision Care
-1.28 Vision Care
1.21 Vision Care
1.36 Disability
0.60 Disability
1.83 Disability
7.83 Disability
6,46 Disability
Z40 Disability
-3.68 Disability
3.49 Disability
3.03 Dental Insurance
1.34 Dental insurance
4.01 Dental Insurance
17.45 Dental Insurance
14.43 Dental Insurance
5.37 Dental Insurance
6.38 Dental Insurance
7.89 Dental Insurance
0.17 Life Insurance
0.05 Life Insurance
0.15 Life Insurance
0,88 Life Insurance
D,73 Life insurance
0.28 Life Insurance
0,68 Life Insurance
0.40 Life Insurance
3,50 FICA Medicare
1.55 FICA Medicare
Payroll Accrual 15-16
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Adj Vlslon Payable
Payroll Accrual 15-16
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Adj LTD Liab
Payroll Accrual 15-16
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Payroll Accrual 15-16
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Actual Burden Journal Entries
Adj Life Insurance Llab
Payroll Accrual 15-16
Actual Burden Journal Entries
Actual Burden Journal Entries
10/21/2016
7nm16
7/21/2016
814/2016
8/18/2016
9/1/2016
9/1512016
9/29/2016
11/1512015
1012112016
7/7/2016
7/21/2016
8/4/2016
811912016
9/1/2016
9/1512016
1111512016
10/21/2016
7m2016
7/21/2016
8/4/2016
811812016
9/1/2016
9/150116
9/29/2016
10/21/2016
7/7/2016
7/21/2016
8/4/2016
811 MO16
911/2016
9/1512016
11115/2016
10121/2016
7/7/2016
7/21/2016
I
W
O
■
I
7/29/2016
31488001,56020
4.78 FICA Medicare
Actual Burden Journal Entries
8/4/2016
8/12/2016
31488001.56020
21.11 FICA Medicare
Actual Burden Journal Entries
811812016
8/26/2015
31488001,56020
17.45 FICA Medicare
Actual Burden Journal Entries
9/1/2016
9/912016
31488001.56020
5-51 FICA Medicare
Actual Burden Journal Entries
9/15/2016
923/2016
31488001.56020
7.38 FICA Medicare
Actual Burden Journal Entries
9/29/2016
950/2016
31488001,56020
9.33 FICA Medicare
Payroll Accrual 15-16
10121/2016
2/18/2016
31488001.82500
22,811.00 Drainage Improvement
COMMONWEALTH LAND TITLE CO
CC 1293 Heil Stormwater PS 2/18/2016
3/8=16
31488001.82500
900.00 Drainage Improvement
VALENTINE APPRAISAL & ASSOC
CC 1293 Heif Storm Water Rehab 3/8/2016
319/2016
31488001.82500
-745.99 Drainage Improvement
PayPointJE
3/9/2016
3/14/2016
31488001.82500
230.69 Drainage Improvement
HB DIGITAL ARTS & BLUEPRINT IN
CC 1293 Heil Storm Water PS 3/14/2016
subtotal
30,115.54
Business Unit 31490003 - Arterial Rehabilitation
8/26/2016
31490003.51110
203.61 Base Salaries
Payroll Labor Distribution
9/112016
8/26/2016
31490003.55110
54.05 CaIPERS Employer Cost
Actual Burden Journal Entries
9/1/2016
9/29/2016
31490003.55110
1-79 CaIPERS Employer Cost
Adj PERS Payroll Contr Biwkly
1111512016
W2612016
31490003.55175
8.67 Workers Compensaton
Actual Burden Journal Entries
9/1/2016
9/29/2016
31490003.55175
0.33 Workers Compensation
True Up WC Rev & Exp
1113M16
8/26/2016
31490003.55260.50
11.62 Blue Shield -Consolidated
Actual Burden Journal Entries
9110116
8/2612016
31490003.55350
0.30 Vision Care
Actual Burden Journal Entries
9/1/2016
9/29/2016
31490003.55350
-0.04 Vision Care
Adj Vision Payable
11115/2016
8/26/2016
31490003.55375
0,86 Disability
Actual Burden Journal Entries
9/1/2016
9/29/2016
31490003.55375
-0,13 Disability
Adj LTD Llab
11/152016
8/26/2016
31490003.55400
0.71 Dental Insurance
Actual Burden Journal Entries
9/1/2016
9/26/2016
31490003.55460
0.10 Life Insurance
Actual Burden Journal Entries
9/1/2016
9/2912016
31490003.55450
0.03 Life Insurance
Adj Life Insurance Lfab
11/15/2016
8/26/2016
31490003.56020
2,90 FICA Medicare
Actual Burden Journal Entries
911/2016
subtotal
284.80
Business Unit
31490004 -Atlanta Avenue Widening
928/2016
31490004,82700
196,290.00 Traffic Improvement
Reclass Expenditures
9/2812016
subtotal
196,290.00
MAIN TOTAL 2,558,699M
...................... _.............Y i
Attachment 4
Infrastructure Fund (314) Expenditure Budget Summary -- FY
1.6-17
HB -75- Item 7. - 31
Infrastructure Fund
115-17 Budget
31445002 - Worthy Paris Phase 1
82900 - Park Improvements
498,695.57
Capital
499,695.57
Business Unit Total
498,695,57
31445003 - Main Pmrn P.S. Improvements
82800 - Other Improvement
291,514.80
Capital
291,514.80
Business Unit Total
291,514.8o
31485201 - Infrastructure En ineer Uesipn
82000 - Improvements
509,180.28
82300 - Streets Improvement
3,600.00
Capital
512,780.28
Business Unit Total
512,780.28
31487003 - Senior Center
Salaries
82200 - Buildings Improvement
1,023,298.10
Capital
1,023,298,10
Business Unit Total
1,023,298.10
31488001 - Heil Pufnp Station
82500 - Drainage Improvement
2,294,401.98
Capital
2,294,401.98
Business Unit Total
2,294,401.98
31490001 - Bella Terra Pedestrian Crossin
82000 - Improvements
200,000.00
82800 - Other Improvement
63,638.54
Capital
263,638.54
Business Unit Total
263,638.54
31490003 - Arterial Rehabilitation 16-17
Salaries
82000 - improvements
1,200,000.00
capital
1,200,000.00
Business Unit Total
1,200,000.00
31490004 - Atlanta Avenue Widening
69380 - Prof Svcs - Litigation Cost
150,000.00
operating
150,000,00
82700 - Traffic Improvement
653,710-00
Capital
653,710,00
Business Unit Total
803,710.00
6,888,039.27
Item 7. - 32 HB -76-