Loading...
CC SR 20171219 2 - FY16-17 Year End ReportRANCHO PALOS VERDES CITY COUNCIL MEETING DATE: 12/19/2017 AGENDA REPORT AGENDA HEADING: Regular Business AGENDA DESCRIPTION: Consideration and possible action regarding the FY16-17 Year-end Financial Report, Purchase Order Carry -Forward Schedule, and Continuing Appropriations. RECOMMENDED COUNCIL ACTION: (1) Receive and file the FY16-17 Year-end Financial Report; (2) Receive and file the Purchase Order Carry -Forward Schedule from FY16-17 to FY17-18; (3) Approve decreasing FY16-17 Adopted Budget in the amount of $320,657 (Capital Improvement Projects Fund), $300,000 (Donor Restricted Fund), and $415,000 (General Fund); and, (4) Approve Continuing Appropriations from FY16-17 to FY17-18, amending the FY17-18 Adopted Budget in the amount of $320,657 (Capital Improvement Projects Fund), $300,000 (Donor Restricted Fund), and $415,000 (General Fund). FISCAL IMPACT: Amounts specified in Recommended Council Actions #3 and #4 above. Amount Budgeted: N/A Additional Appropriation: N/A Account Number(s): N/A ORIGINATED BY: Vina Ramos, Accounting Supervisor �1— REVIEWED BY: Trang Nguyen, Deputy Director of Finance Deborah Cullen, Director of Finance APPROVED BY: Doug Willmore, City Manager fP ATTACHED SUPPORTING DOCUMENTS: A. FY16-17 Purchase Order Carry -Forward Schedule (page A-1) B. FY16-17 Continuing Appropriations Schedule (page B-1) Fiscal Year 2016-17 General Fund Year-end Results In the City's Budget Workshop on June 20, 2017, Staff projected FY16-17 General Fund Revenues to end the year at $29.6 million and Expenditures to end at $29.8 million, resulting in a negative variance of $0.2 million (revenues to expenditures). In comparison to the actual year-end results, the unaudited General Fund operations ended the year at $29.4 million of Revenues and $27.7 million of 1 Expenditures, resulting a positive variance of $1.7 million (revenues to expenditures). The following table is a summary of FY16-17 General Fund Operation results. Table 1 — Summary of FY16-17 General Fund Operations General Fund Balance Reconciliation After applying the 50% Reserve Fund policy, Purchase Orders Carry -forward, and Continuing Appropriations, the unaudited General Fund Balance ended the year with an increase of $1.9 million. This is an increase of $0.5 million from the year-end estimates presented at the Budget Workshop on June 20, 2017. The increase is a combination of less anticipated Revenues by $0.2 million, savings of $2.3 million in Expenditures, adding $1 million of Purchase Order Carry -Forward items, and $0.4 million of Continuing Appropriations. The major changes on the year-end results over estimates are savings from approved projects in FY16-17 but not completed by year-end. About $1 million is under Public Safety, related to the Automated License Plate Recognition (ALPR) projects and the Public Safety Incentive Program for residents to purchase security camera devices. The General Fund also realized savings from transfers of $1.3 million from the Proposition A Exchange Program with the cities of Montebello, Diamond Bar, and Rolling Hills. The remaining savings are from the professional and technical services from various Departments. The following table is a reconciliation of the changes to estimates. 2 FY 2016-17 FY 2016-17 Change in General Fund YE Estimates Actuals Estimates Revenues $ 29.6 $ 29.4 $ (0.2) Expenditures $ (29.8) $ (27.7) $ 2.1 Variance $ (0.2) $ 1.7 $ 1.9 General Fund Balance Reconciliation After applying the 50% Reserve Fund policy, Purchase Orders Carry -forward, and Continuing Appropriations, the unaudited General Fund Balance ended the year with an increase of $1.9 million. This is an increase of $0.5 million from the year-end estimates presented at the Budget Workshop on June 20, 2017. The increase is a combination of less anticipated Revenues by $0.2 million, savings of $2.3 million in Expenditures, adding $1 million of Purchase Order Carry -Forward items, and $0.4 million of Continuing Appropriations. The major changes on the year-end results over estimates are savings from approved projects in FY16-17 but not completed by year-end. About $1 million is under Public Safety, related to the Automated License Plate Recognition (ALPR) projects and the Public Safety Incentive Program for residents to purchase security camera devices. The General Fund also realized savings from transfers of $1.3 million from the Proposition A Exchange Program with the cities of Montebello, Diamond Bar, and Rolling Hills. The remaining savings are from the professional and technical services from various Departments. The following table is a reconciliation of the changes to estimates. 2 Table 2 - Summary of FY16-17 General Fund Revenues and Expenditure General Fund (in millions) FY 2016-17 Estimates FY 2016-17 Actuals Change in Estimates Beginning Fund Balance $ 15.1 $ 15.1 $ - Add: Revenues $ 29.4 $ 29.2 $ (0.2) Add: Transfers In $ 0.2 $ 0.2 $ - Subtotal $ 44.7 $ 44.5 $ (0.2) Less: Year-end Operating Expenditures $ 25.6 $ 23.3 $ (2.3) Less: Transfers Out $ 4.2 $ 4.4 $ 0.2 Subtotal $ 29.8 $ 27.7 $ (2.1) Unaudited General Fund Balance $ 14.9 $ 16.8 $ 1.9 Less: 50% Policy Reserve $ (12.8) $ (12.8) $ - Purchase Orders Carry -Forward $ (1.0) $ (1.0) Continuing Appropriations $ (0.4) $ (0.4) Unaudited General Fund Unrestricted Surplus(Deficit) $ 2.1 $ 2.6 $ 0.5 General Fund Revenues As illustrated in Table 1, the change to estimates in Revenues is a decrease of $0.2 million. The following are highlights of the major changes: ➢ Transfer Occupancy Tax (TOT) includes two categories, one is from Terranea's TOT and the other category is from Miscellaneous TOT that includes occupying rooms in a hotel or similar for 30 days or less. Staff projected $5.3 million of TOT collected from Terranea and $0.6 million of Miscellaneous TOT. Compared to the year-end results, Terranea's TOT improved by about $100,000 but offset by the decreased results in Miscellaneous TOT of $400,000, resulting in a net decrease of about $300,000 to estimates. ➢ Property Tax came in slightly higher than estimated by $42,000. This increase is tied to larger property transfer tax revenue from the sale of real property. ➢ Sales Tax came in higher than estimated by $200,000 primarily from growth in food product sales. ➢ Other Licenses & Permits decreased by over $100,000 mainly attributed to the projected amount of permits in the Building and Safety program. ➢ Other Revenues increased by $100,000 from a combination of increased sales at the Point Vicente Interpretive Center, interest earnings, RDA loan payments, donations, Business License Tax, and Charges for Services. The categories that came in under from estimates include Franchise Tax due to decreased of consumption levels and Golf Tax due to decreased of sales receipts. 3 The following table is a summary of revenue estimates and actuals. Table 3 — FY16-17 General Fund Revenues — Estimates vs. Actuals $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $(2,000) Other Other Property Tax Sales Tax TOT UUT Licenses & evenue Revenue ■ FY 2016-17 $12,304 $2,228 $5,896 $1,819 $2,294 $4,879 Estimates ■ FY 2016-17 $12,346 $2,384 $5,601 $1,775 $2,141 $5,013 Unaudited Actuals ■ Variance $42 $156 $(295) $(44) $(153) $134 General Fund Expenditures As illustrated in Table 1, Expenditures ended the year better than estimated by $2.1 million. The following are highlights of the changes to estimates: r Salaries and Benefits ended $0.5 million higher than year-end estimates. This is mostly due to Workers' Compensation, Group Term Life Insurance Premium, Replacement Insurance Premium and payroll accrual for the first week of July 2016 that was not included in the estimates for a total of $471,000. The remaining $29,000 is from overtime and part-time staff during the last quarter of the year. v Non -Personnel category is the City's general operations including contract services, legal services, training, memberships, and supplies. Compared to the year-end estimates, this category came in lower by $1.4, mainly from the maintenance, professional and technical contracts for $1.1 million that were not completed by year-end. The rest of the unspent amounts are from operating supplies, training, memberships, and utilities. ➢ Public Safety also ended the year lower than year-end estimates by $1 million primarily from the ALPR projects and the Incentive Program. These projects are included in the Purchase Order Carry -Forward and scheduled for completion in FY17-18. ➢ Transfers Out ended the year slightly lower than expected by $0.1 million due to the final results from TOT revenues. al The following tables summarize the expenditure estimates and actuals. Table 4A - FY16-17 General Fund Expenditures -Estimates vs. Actuals $12,000 $10,000 $8,000 V) � $6,000 M In o $4,000 t � $2,000 $(2,000) Salaries & Wages Benefits Non -Personnel Public Safety Transfers ■ FY 2016-17 Estimates $6,412 $1,911 $9,621 $7,355 $4,500 ■ FY 2016-17 $6,578 $2,250 $8,204 $6,273 $4,387 Unaudited Actuals ■ Variance $166 $339 $(1,418) $(1,083) $(113) Table 4113 - FY16-17 General Fund Exoenditures - By Deoartments Overall, the General Fund Operations ended the year with a slight decrease in revenues and expenditures ending the year below estimates. This results in a General 5 $8,000 $7,000 $6,000 $5,000 $4,000 o $3,000 $2,000 $1,000 $_� ' $(1,000) $(2,000) Admin City Commun Finance Legal Public Public Recreati on & Transfer Council ity Dev Services Safety Works Parks s ■ FY 2016-17 $3,028 $140 $2,763 $3,666 $1,173 $6,273 $4,086 $2,175 $4,387 Unaudited Actuals ■ FY 2016-17 $3,275 $120 $2,973 $3,905 $950 $7,355 $4,766 $2,276 $4,190 Estimates ■ Variance $(246) $20 $(209) $(239) $223 $(1,083) $(680) $(101) $198 Overall, the General Fund Operations ended the year with a slight decrease in revenues and expenditures ending the year below estimates. This results in a General 5 Fund surplus of $2.6 million, after funding the 50% Reserve Policy and accounting for purchase orders carry -forward and continuing appropriations into FY17-18. Capital Improvement Proiects Fund The CIP Fund ended the year with a fund balance of $22 million. Of this amount, total Transfers -In ended the year at $4.4 million and Expenditures at $7.1 million. Transfers -In came in lower than estimated by $100,000, mainly from the year-end TOT revenue results. The change to estimates in fund balance is a decrease of $3 million primarily from the number of projects completed in FY16-17. When compared to the previous year-end results, expenditures in FY16-17 increased by over $5 million. In addition to the completed projects, $5 million of projects have been awarded before year- end and will be carried forward in FY17-18. Equipment Replacement Fund Equipment Replacement Fund ended the year on target at $2.7 million. The year-end expenditure results came in lower than estimated by about $265,000. The change to estimates are from unspent budget from the City's software implementation programs. About $215,000 is the remaining balance from the City's new permitting system, and $45,000 from the City's financial software. Both projects will continue until completed, and therefore unspent budgets will be carried forward to FY17-18. Water Quality/Flood Protection Fund Water Quality ended the year on target with no fund balance and no new revenues received. All approved Storm Drain projects—totaling $4.2 million—have been encumbered and scheduled to be completed in FY17-18. Other Governmental Funds Other Governmental Funds include Special Revenue Funds and Permanent Funds. The balance for all funds ended at $13.2 million. Over 90% of the fund balance is restricted by law or external agencies. Over $10 million is restricted by law, $1 million is restricted by reimbursement settlement with the Improvement Authority – Abalone Cove, and another $750,000 is restricted by endowment within Subregion One. Al • Table 5 - Other Funds Year-end Summary Restricted Fund Balance In Beginning Fund Balance $ Add: Revenues $ Add: Transfers In $ Subtotal $ Less: Expenditures $ Less: Transfers Out $ Subtotal $ Restricted Ending Fund Balance $ Purchase Orders Carry -Forward $ Continuing Appropriations $ Unaudited Fund Balance Surplus(Deficit) $ Purchase Order Carrvover Schedule Capital Equipment rovement Replacement Water Quality 29.7 $ 3.8 $ 5.6 $ 0.3 $ 0.1 $ 0.05 $ 4.1 $ - $ - $ 34.1 $ 3.9 $ 5.6 $ (7.1) $ (0.9) $ (1.4) $ (7.1) $ (0.9) $ (1.4) $ 27.0 $ 3.0 $ 4.2 $ (4.7) $ (0.3) $ (4.2) $ (0.3) $ - $ - $ 22.0 $ 2.7 $ 0.0 $ Special Revenues & Permanent Funds 14.0 7.0 0.2 21.2 (5.7) (0.2) (5.9) 15.3 (1.8) (0.3) 13.2 As part of the year-end process, Staff reviewed open purchase orders and compiled a ist of projects and purchases that were encumbered in FY16-17 but not completed or delivered by June 30, 2017. To meet budgetary requirements, the purchase orders must be carried forward in FY17-18. The carry -forward items of $12.4 million have no net fiscal impact as it decreases the FY16-17 Adopted Budget and increases the FY17- 18 Adopted Budget for the same amount. About 80% of the carry -forward items are projects from the CIP Fund and from the Water Quality Fund. The following is a summary of the carry -forward amount for by Fund. 7 Fund Fund Name Total 101 General Fund $ 963,643 202 Gas Tax $ 249,346 213 Waste Reduction $ 2,500 216 Prop A $ 306,310 225 Abalone Cove $ 2,125 228 Donor Restricted $ 7,893 285 IA Portuguese $ 40,820 310 CDBG $ 165,760 330 CIP $ 4,660,059 334 Quimby $ 969,295 501 Water Quality $ 4,735,809 681 Equipment Replacement $ 264,065 795 IA $ 17,500 Grand Total $ 12,385,126 Additional details are included in the attached Exhibit A, FY16-17 Purchase Order Carry - Forward Schedule. Continuing Appropriations In addition to the Purchase Order Carry -Forward Schedule, the Finance Department, in partnership with other Departments and the City Manager, prepares a summary of proposed continuing appropriations to be carried over to the next fiscal year. The General Fund continuing appropriations will primarily be used to fund the ongoing projects such as; the Portuguese Bend Landflow and Wireless Telecommunications Facility Permit programs. Table 6 below identifies the projects that were included in the FY16-17 Adopted Budget, but were not completed or spent by June 30, 2017. As a result, Staff is requesting to carryover the appropriation to FY17-18 Adopted Budget. Additional details are included in the attached Exhibit B. Table 6: FY16-17 Continuing Appropriation Requests Fund Fund Name Total 330 CIP Fund $ 320,657 228 Donor Restricted Fund $ 300,000 101 lGeneral Fund $ 415,000 Total $ 1,035,657 The City is currently going through an external audit with Vavrinek, Trine, Day & Co. (VTD). Once the audit is completed, Finance will prepare and submit the Comprehensive Annual Financial Report (CAFR) to the City Council, which will have the audited final revenues, expenditures, and fund balances. EXHIBIT A: FY 2016-17 PO Carry -Forward Requests - By Fund F.d Fund Fund Name Total 101 General Fund $ 963,643 202 Gas Tax $ 249,346 213 Waste Reduction $ 2,500 216 Prop A $ 306,310 225 Abalone Cove $ 2,125 228 Donor Restricted $ 7,893 285 IA Portuguese $ 40,820 310 CDBG $ 165,760 330 CIP $ 4,660,059 334 Quimby $ 969,295 501 Water Quality $ 4,735,809 681 Equipment Replacement $ 264,065 795 11A $ 17,500 Grand Total I $ 12,385,126 F.d Exhibit A: FY 2016-17 PO Carry -Forward Requests - Details F.dM Fund Vendor PO Fund Name PO Date Department Department Program Reason/Justification Number Name Amount I NTERW EST CONSULTING GROUP, General Fund 101 05/24/2017 CDD 20170101 1 CDD - BUILDING & SAFETY $ 22,111 Temp service extended Project not completed in General Fund 101 02/16/2017 CDD 9370 E.S.A. CDD - PLANNING $ 41,194 FY16-17 Ongoing project for General Fund 101 02/13/2017 CM 9361 GENESIS WORKS, INC. CITY MANAGER $ 11,063 Employee Development PORTFOLIO RECOVERY General Fund 101 02/01/2017 FIN 9140 ASSOCIATES FINANCE $ 2,388 Pending invoice in FY16-17 VAVRINEK, TRINE, DAY General Fund 101 03/06/2017 FIN 20170001 & CO., L FINANCE $ 6,363 Ongoing project COST RECOVERY General Fund 101 06/22/2017 FIN 20170148 SYSTEMS, INC. NON -DEPARTMENTAL $ 9,000 Pending invoice in FY16-17 VIGILANT SOLUTIONS, PUBLIC SAFETY - SPECIAL General Fund 101 02/01/2017 CM 9169 LLC. PROGRAMS $ 215,957 Ongoing project VIGILANT SOLUTIONS, PUBLIC SAFETY - SPECIAL General Fund 101 07/06/2017 CM 20170164 LLC. PROGRAMS $ 391,500 Ongoing project VIGILANT SOLUTIONS, PUBLIC SAFETY - SPECIAL General Fund 101 07/06/2017 CM 20170164 LLC. PROGRAMS $ 120,000 Ongoing project BOT HOME PUBLIC SAFETY - SPECIAL General Fund 101 07/10/2017 CM 20170166 AUTOMATION, INC PROGRAMS $ 100,000 Ongoing project Citywide traffic sign inventory, assessment of signs, and obtain cost estimate for replacement of CBM CONSULTING, aging, damaged, and non - General Fund 101 02/02/2017 PW - GF 9231 INC. PUBLIC WORK S- ADMIN $ 3,745 compliant signs. Survey for vacation of right- PENCO ENGINEERING, of -way (ROW) on a portion of General Fund 101 04/04/2017 PW - GF 20170018 INC. PUBLIC WORK S- ADMIN $ 9,580 Crest Rd. F.dM A-3 Fund Vendor PO Fund Name PO Date Department Department Program Reason/Justification Number Name Amount Design of acoustical BLACK, O'DOWD & PUBLIC WORKS - BUILDING improvements project at General Fund 101 02/01/2017 PW - GF 9168 ASSOCIATES, I MAINT $ 1,500 PVIC Citywide traffic sign inventory, assessment of signs, and obtain cost estimate for replacement of CBM CONSULTING, PUBLIC WORKS - TRAFFIC aging, damaged, and non - General Fund 101 02/02/2017 PW - GF 9231 INC. SAFETY $ 10,826 compliant signs. COUNTY SANITATION REC & PARK - OTHER Invoice pending. Payment General Fund 101 01/27/2017 R&P 8932 DISTRICT #5 FACILITIES $ 2,400 will be processed in FY17-18 PORTFOLIO RECOVERY Porfolio Recovery - Stats General Fund 101 06/30/2017 Finance 20170195 ASSOCIATES Finance $ 1,550 report for FY16-17 General Fund 101 06/30/2017 Finance 9063 CITY OF RHE CM - Public Safety $ 14,467 Traffic services for FY16-17 HARDY & HARPER, Maintenance of PB landslide Gas Tax 202 01/31/2017 PW -OTHER 9054 INC. PW - LANDSLIDE $ 15,460 area drainage pipe. Construction management and inspection services for PW - MEASURE R - Annual Sidewalk Repair Gas Tax 202 08/14/2017 PW - OTHER 20170190 SUNBEAM SOLAR SIDEWALK REPAIR $ 31,988 Program. EBS GENERAL PW - MEASURE R - Construction of Annual Gas Tax 202 08/14/2017 PW - OTHER 20170189 ENGINERING, INC. SIDEWALK REPAIR $ 201,898 Sidewalk Repair Program. Advertisement of "Earth Month" activities, using Used Oil Opportunity Grant Waste NATIONAL MEDIA, Program funds (for 5 -week Reduction 213 02/03/2017 PW - OTHER 9346 INC. WASTE REDUCTION $ 2,500 period). Construction of Hawthorne CALIFORNIA PW - PROP A - Blvd. Pedestrian Linkage Proposition A 216 06/29/2017 PW -OTHER 20170159 LANDSCAPE & DESIGN HAWTHORNE $ 163,265 Sidewalk/Bus Stop Project. A-3 Fund Vendor PO Fund Name PO Date Department Department Program Reason/Justification Number Name Amount Construction of park PUB CONSTRUCTION, PW - PROP A - LOWER improvements at Lower Proposition A 216 07/27/2017 PW -OTHER 20170177 INC. HESSE PARK $ 120,055 Hesse Park. Proposition A 216 06/30/2017 PW - Other 20170159 CA LANDSCAPE PW - Other $ 22,991 Hawthorne Linkage Project Engineer's report for annual Abalone Cove Sewer PW - ABALONE COVE Maintenance District fee Abalone Cove 225 05/15/2017 PW - OTHER 20170089 HARRIS & ASSOCIATES SEWER DISTRICT $ 2,125 assessments. CALIFORNIA NATIVE Donor Restricted 228 02/02/2017 R&P 9219 PLANT SOCIE DONOR RESTRICTED FUND $ 7,893 Invoice pending in FY16-17 MCGEE SURVEYING GPS survey at existing points IA Portuguese 285 01/26/2017 PW -OTHER 8857 CONSULTING PW - IA PORT BEND $ 40,820 within the landslide area. Design services for the Bus CBM CONSULTING, Stop at City Hall ADA Access CDBG 310 02/16/2017 PW -OTHER 9378 INC. PW - CDBG $ 2,570 Improvements Project. Construction of Bus Stop as part of City Hall ADA Access CDBG 310 07/31/2017 PW - OTHER 20170181 PALP INC PW - CDBG $ 163,190 Improvements Project. Hawthorne Blvd. road repairs associated with the PW -CIP - Hawthorne Blvd. Traffic HARDY & HARPER, INFRASTRUCTURE Signal Synchronization CIP 330 06/19/2017 PW - CIP 20170136 INC. IMPROVEMENTS $ 7,837 Project. Construction management PW - CIP - and inspection services for ATKINS NORTH INFRASTRUCTURE the Miraleste Dr. Arterial CIP 330 06/19/2017 PW - CIP 20170138 AMERICA, INC. IMPROVEMENTS $ 88,477 Rehabilitation Project. F."M Fund Vendor PO Fund Name PO Date Department Department Program Reason/Justification Number Name Amount Environmental studies PW-CIP- related to the straightening INFRASTRUCTURE of the east end of PVDS in CIP 330 07/10/2017 PW - CIP 20170169 CWE IMPROVEMENTS $ 44,745 the PB landslide area. Contingency funds PW-CIP- associated wth the Coastal HARRIS STEEL FENCE INFRASTRUCTURE Bluff Fence Project, which is CIP 330 06/20/2017 PW - CIP 20170142 CO., INC IMPROVEMENTS $ 10,456 currently under construction. Funds for completion of the PW - CIP - Coastal Bluff Fence Project, HARRIS STEEL FENCE INFRASTRUCTURE which is currently under CIP 330 06/20/2017 PW - CIP 20170142 CO., INC IMPROVEMENTS $ 104,562 construction. Civil engineering & project management services for PB INTERWEST PW-CIP- landslide design services & CONSULTING GROUP, INFRASTRUCTURE street light acquisition CIP 330 04/28/2017 PW - CIP 201700651 IMPROVEMENTS $ 17,910 project. Environmental review (initial study) related to the PW-CIP- straightening of the east end INFRASTRUCTURE of PVDS in the PB landslide CIP 330 02/01/2017 PW - CIP 9111 CWE IMPROVEMENTS $ 40,745 area. PW - CIP - Retention funds need to be CONCEPT INFRASTRUCTURE released for Sunnyside Ridge CIP 330 02/01/2017 PW - CIP 9114 CONSULTANT, INC. IMPROVEMENTS $ 7,010 Trail Segment Project. PW-CIP- Retention funds need to be CONCEPT INFRASTRUCTURE released for Sunnyside Ridge CIP 1 330 1 02/01/2017 PW - CIP 9114 CONSULTANT, INC. IMPROVEMENTS $ 16,364 Trail Segment Project. F."M we Fund Vendor PO Fund Name PO Date Department Department Program Reason/Justification Number Name Amount PW-CIP- Retention funds need to be CONCEPT INFRASTRUCTURE released for Sunnyside Ridge CIP 330 02/01/2017 PW - CIP 9114 CONSULTANT, INC. IMPROVEMENTS $ 23,194 Trail Segment Project. PW -CIP - Retention funds need to be CONCEPT INFRASTRUCTURE released for Sunnyside Ridge CIP 330 02/01/2017 PW - CIP 9114 CONSULTANT, INC. IMPROVEMENTS $ 36,586 Trail Segment Project. PW - CIP - ABNY GENERAL INFRASTRUCTURE Construction of ADA Access CIP 330 08/02/2017 PW - CIP 20170184 ENGINEERING INC. IMPROVEMENTS $ 446,113 Improvements at Hesse Park. Construction management & inspection services for the INTERWEST PW-CIP- Pedestrian Safe Bus CONSULTING GROUP, INFRASTRUCTURE Stop/Sidewalk Linkage CIP 330 06/29/2017 PW - CIP 20170158 I IMPROVEMENTS $ 101,870 Project on Hawthorne Blvd. Construction of the PW-CIP- Pedestrian Safe Bus CALIFORNIA INFRASTRUCTURE Stop/Sidewalk Linkage CIP 330 06/29/2017 PW - CIP 20170159 LANDSCAPE & DESIGN IMPROVEMENTS $ 1,163,193 Project on Hawthorne Blvd. PW - CIP - Design services for Miraleste INFRASTRUCTURE Drive Arterial Street CIP 330 02/02/2017 PW - CIP 9191 SUNBEAM SOLAR IMPROVEMENTS $ 20,612 Rehabilitation Project. PW-CIP- Construction of Miraleste INFRASTRUCTURE Drive Arterial Street CIP 330 07/06/2017 PW - CIP 20170165 PALP INC IMPROVEMENTS $ 1,624,412 Rehabilitation Project. Design services for PW-CIP- Hawthorne Blvd. Traffic INFRASTRUCTURE Signal Synchronization CIP 330 01/30/2017 PW - CIP 8993 SUNBEAM SOLAR IMPROVEMENTS $ 4,203 Project. we F."M Fund Vendor PO Fund Name PO Date Department Department Program Reason/Justification Number Name Amount Construction of the PW-CIP- Hawthorne Blvd. Traffic PRO TECH INFRASTRUCTURE Signal Synchronization CIP 330 01/31/2017 PW - CIP 9094 ENGINEERING CORP IMPROVEMENTS $ 13,874 Project. Construction management & PW -CIP - inspection services for the INFRASTRUCTURE PVDE Guardrail Replacement CIP 330 04/24/2017 PW - CIP 20170050 SUNBEAM SOLAR IMPROVEMENTS $ 13,760 Project. Design services for the PW-CIP- Residential Street INFRASTRUCTURE Rehabilitation Project (Area CIP 330 02/02/2017 PW - CIP 9197 SUNBEAM SOLAR IMPROVEMENTS $ 174,057 7). Certified arborist services for PW - CIP - the Residential Street GAUDENTI & SONS INFRASTRUCTURE Rehabilitation Project (Area CIP 330 02/03/2017 PW - CIP 9321 CORP IMPROVEMENTS $ 5,000 7). Construction management and inspection services for PW-CIP- the Residential Street CBM CONSULTING, INFRASTRUCTURE Rehabilitation Project (Area CIP 330 07/19/2017 PW - CIP 20170172 INC. IMPROVEMENTS $ 44,800 7). Design services for the Residential Street Rehabilitation Project (Area PW-CIP- 7), due to the addition of INFRASTRUCTURE Crest Road East to the CIP 330 08/14/2017 PW - CIP 20170191 SUNBEAM SOLAR IMPROVEMENTS $ 55,000 project. Design services for the PW-CIP- Residential Street INFRASTRUCTURE Rehabilitation Project (Area CIP 330 03/04/2017 PW - CIP 9396 SUNBEAM SOLAR IMPROVEMENTS $ 380,103 8). Civil engineering services for PW-CIP- the Residential Street INFRASTRUCTURE Rehabilitation Project (Area CIP 330 08/14/2017 PW - CIP 20170193 SUNBEAM SOLAR IMPROVEMENTS $ 11,600 8). F."M Fund Vendor PO Fund Name PO Date Department Department Program Reason/Justification Number Name Amount Design services for the FY 15- 16 Residential Street PW -CIP - Rehabilitation Project (Areas INFRASTRUCTURE 2 & 6). Billing for survey and CIP 330 02/01/2017 PW - CIP 9162 SUNBEAM SOLAR IMPROVEMENTS $ 3,024 as -built plans is still pending. HORIZONS Construction of dog park and CONSTRUCTION CO. QUIMBY - EASTVIEW DOG park improvements at Quimby 334 08/02/2017 PW - OTHER 20170183 INT PARK $ 315,920 Eastview Park. Construction inspection services for ADA Access HR GREEN QUIMBY - LOWER HESSE Improvements Project at Quimby 334 07/31/2017 PW -OTHER 20170179 CALIFORNIA, INC. PARK $ 25,800 Hesse Park. Construction of park PUB CONSTRUCTION, QUIMBY - LOWER HESSE improvements at Lower Quimby 334 07/27/2017 PW -OTHER 20170177 INC. PARK $ 627,575 Hesse Park. PW - CIP - INFRASTRUCTURE Ongoing project - SDDIP CC CIP 501 06/30/2017 PW - CIP 518 COUCH & SONS, LP IMPROVEMENTS $ 1,970,451 Approved 6/6/17 PW-CIP- INFRASTRUCTURE Ongoing project PVDE Water Quality 501 06/30/2017 PW - CIP 20170056 A TO Z CONSTRUCTION IMPROVEMENTS $ 67,695 Guardrail Design services for the Storm INTERWEST Drain Deficiency CONSULTING GROUP, Improvement Program Water Quality 501 06/19/2017 PW - OTHER 20170131 1 WQF $ 6,770 (SDDIP). Preparation of a Project Study Report (PSR) for a potential storm drain project at Altamira Canyon to WQF - ALTAMIRA manage drainage at this Water Quality 1 501 01/31/2017 PW - OTHER 1 90501 HARRIS & ASSOCIATES I DRAINAGE $ 78,321 location. me Fund Vendor PO Fund Name PO Date Department Department Program Reason/Justification Number Name Amount Construction management & inspection services for the Storm Drain Deficiency WQF -STORM DRAIN DEF Improvement Program Water Quality 501 07/31/2017 PW -OTHER 20170178 PSOMAS IMPROVEMENT $ 78,620 (SDDIP). Design services for the Storm Drain Deficiency DUDEK & ASSOCIATES, WQF -STORM DRAIN DEF Improvement Program Water Quality 501 02/03/2017 PW - OTHER 9266 INC. IMPROVEMENT $ 3,823 (SDDIP) - Year 1. Design services for the Storm Drain Deficiency DUDEK & ASSOCIATES, WQF -STORM DRAIN DEF Improvement Program Water Quality 501 08/14/2017 PW - OTHER 20170192 INC. IMPROVEMENT $ 15,012 (SDDIP) - Year 1. Release of retention related SOUTHWEST PIPELINE WQF -STORM DRAIN to the construction of the Water Quality 501 02/20/2017 PW - OTHER 8704 & TRENCHLE LINING $ 387,726 Storm Drain Lining Project. Release of retention related SOUTHWEST PIPELINE WQF -STORM DRAIN to the construction of the Water Quality 501 01/31/2017 PW -OTHER 9097 & TRENCHLE LINING $ 217,517 Storm Drain Lining Project. WQF -STORM DRAIN Construction of the Storm Water Quality 501 02/02/2017 PW - OTHER 9196 CWE POINT REPAIR $ 54,520 Drain Point Repair Project. Construction management & INTERWEST inspection services for the CONSULTING GROUP, WQF -STORM DRAIN Storm Drain Point Repair Water Quality 501 06/19/2017 PW - OTHER 20170139 1 POINT REPAIR $ 35,000 Project. WQF - STORM DRAIN Construction of the Storm Water Quality 501 06/19/2017 PW - OTHER 20170140 G. B. COOKE, INC. POINT REPAIR $ 182,100 Drain Point Repair Project. WQF - STORM DRAIN Construction of the Storm Water Quality 501 06/19/2017 PW -OTHER 20170140 G. B. COOKE, INC. POINT REPAIR $ 189,870 Drain Point Repair Project. WQF - STORM DRAIN Construction of the Storm Water Quality 501 06/19/2017 PW - OTHER 20170140 G. B. COOKE, INC. POINT REPAIR $ 1,716,630 Drain Point Repair Project. me F" Fund Vendor PO Fund Name PO Date Department Department Program Reason/Justification Number Name Amount Equipment RAMUNDSEN Replacement 681 02/16/2017 CM 9358 SUPERIOR HOLDINGS, EQUIP REPLACEMENT $ 4,179 Ongoing project -Trakit Equipment RAMUNDSEN Replacement 681 02/16/2017 CM 9358 SUPERIOR HOLDINGS, EQUIP REPLACEMENT $ 203,087 Ongoing project -Trakit Equipment TYLER TECHNOLOGIES, Replacement 681 01/31/2017 FIN 9090 INC. EQUIP REPLACEMENT $ 45,557 Ongoing project Light bar for 2017 Toyota Equipment Prius replacement vehicle for Replacement 681 06/14/2017 PW - EQUIP 20170125 72 HOUR LLC EQUIP REPLACEMENT $ 8,171 CDD. Light bar for 2017 Toyota Equipment Prius replacement vehicle for Replacement 681 06/19/2017 PW - EQUIP 20170137 72 HOUR LLC EQUIP REPLACEMENT $ 3,071 CDD. Provide a GPS survey at MCGEE SURVEYING existing points within the PB IA Abalone 795 1 01/26/2017 PW -OTHER 8857 CONSULTING PW - IA ABALONE COVE 1 $ 17,500 landslide area. TOTAL 1 $ 12,385,126 F" I0 -M Exhibit B: FY 2016-17 Continuing Appropriation Requests Fund Number Fund Name Account Number Requested Amount Description 330 CIP 330-400-8806-8802 $ 76,475 Ongoing project for PVDS Bike Lane 330 CIP 330-400-8404-8404 $ 84,982 Ongoing project for Coastal Bluff Fence Replacement, Phase 1 330 CIP 330-400-8031-8802 $ 50,000 Ongoing project for Hawthorne Blvd. Traffic Signal Synchronization for operations 330 CIP 330-400-8043-5101 $ 74,200 Ongoing project for the landslide feasibility study, Portuguese 330 CIP 330-400-8502-8402 $ 35,000 Ongoing project for the ADA access at the RPTV building 228 Donor Restricted 228-400-8501-8004 $ 300,000 Ongoing project for PVIC Exhibit Renovation 101 General Fund 101-400-2999-5101 $ 100,000 Ongoing projects for Portuguese Bend & Wireless Telecommunication Facilities 101 General Fund 101-400-2999-6101 $ 40,000 Ongoing project for Training 101 General Fund 101-400-4160-5101 $ 75,000 Ongoing project for NCCP under CDD 101 IGeneral Fund 101-400-6120-4901 1 $ 200,000 Ongoing project for the HOA Grant Matching Program under 1 Public Safety 101 1 1 1 $ 1,035,657 ITotal Continuing Appropriations I0 -M