Loading...
CC SR 20191217 06 - Year-End ReportMEETING DATE: 12/17/2019 CITY COUNCIL AGENDA REPORT AGENDA HEADING: Regular Business AGENDA DESCRIPTION: Consideration and possible action regarding the Fiscal Year 2018-19 Year-end Unaudited Financial Report, Purchase Order Carry-Forward Schedule, and continuing appropriations RECOMMENDED COUNCIL ACTION: (1) Receive and file the FY 2018-19 Year-end Unaudited Financial Report; (2) Receive and file the Purchase Order Carry-Forward Schedule from FY 2018-19 to FY 2019-20; (3) Approve decreasing the FY 2018-19 Adopted Budget in the amount of $741,432 (General Fund), $535,797 (1911 Act Street Lighting Fund), $4,851 (Proposition A Fund), $9,081 (Proposition C Fund), $113,705 (Measure R Fund), $7,331 (Donor Restricted Contribution Fund, $131,261 (CDBG Fund), $4,054,018 (Infrastructure Improvement Program Fund), $563,665 (State Grant Fund), $862,341 (Quimby Fund) and $116,773 (Equipment Replacement Fund) for purchase order carry- forward, continuing appropriation and projects in process; and, (4) Approve amending the FY 2019-20 Adopted Budget in the amount of $741,432 (General Fund), $535,797 (1911 Act Street Lighting Fund), $4,851 (Proposition A Fund), $9,081 (Proposition C Fund), $113,705 (Measure R Fund), $7,331 (Donor Restricted Contribution Fund), $131,261 (CDBG Fund), $4,054,018 (Infrastructure Improvement Program Fund), $563,665 (State Grant Fund), $862,341 (Quimby Fund) and $116,773 (Equipment Replacement Fund) for purchase order carry-forward, continuing appropriations and capital projects in process. FISCAL IMPACT: Decrease citywide (all funds) FY 2018-19 Budget in the amount of $7,140,255. Increase citywide (all funds) FY 2019-20 Budget in the amount of $7,140,255. Amount Budgeted: N/A Additional Appropriation: N/A Account Number(s): N/A ORIGINATED BY: Christopher Browning, Senior Administrative Analyst REVIEWED BY: Angelina Garcia, Interim Director of Finance APPROVED BY: Ara Mihranian, AICP, Interim City Manager 1 ATTACHED SUPPORTING DOCUMENTS: A. FY 2018-19 Purchase Order Carry-Forward Schedule (page A-1) Fiscal Year 2018-19 General Fund Year-End Results At the City’s budget adoption hearing held on June 18, 2019, Staff projected FY 2018-19 General Fund revenues to end the year at $31 million and expenditures to end at $30.9 million, including transfers, resulting in a positive variance of about $100,000 (revenues to expenditures). The General Fund unaudited actual year-end results show operations ending the year with total revenues of almost $31.8 million and just over $29.2 million of expenditures, including transfers, resulting in a positive variance of $2.6 million (revenues to expenditures). The following table is a summary of FY 2018-19 General Fund operating results. Table 1 – Summary of FY 2019-20 General Fund Operations General Fund Operations When comparing year-end estimated revenues and expenditures to unaudited actuals, the General Fund operations show an increase of about $2.5 million to the fund balance. This $2.5 million increase was the result of the unaudited actual for revenues ending higher than year-end estimates by over $800,000 and a savings of $1.7 million in expenditures. Year-end estimates are prepared with input and approximations from the various City departments based on the current and expected activities. The increase in revenues is due primarily to higher-than-expected inflow from licenses and permits, franchise tax, and other miscellaneous revenue. Savings from expenditures is due to underruns in salaries and benefits, professional and technical services, repairs and maintenance, and supplies. The following is a more detailed discussion on these results. General Fund Revenues FY 2018-19 FY 2018-19 Changes Year-end Unaudited to Year-end in millions Estimates Actual Estimates Revenues $31.0 $31.8 $0.8 Expenditures ($30.9) ($29.2) ($1.7) $0.1 $2.6 2 Revenues increased by approximately $860,000 or 2.8% when compared to year- end estimates as illustrated in Table 2. This table is a summary of the major revenues and compares the revised budget and year-end estimated revenues to year-end actuals. Highlights of the major changes are outlined below. Table 2 – FY 2018-19 General Fund Revenues – Estimates vs. Actuals  Property Tax o Revenue came in slightly higher than estimated by $90,400 or 0.7%. This increase was the result of higher-than-expected secured property tax revenue, which was offset slightly by lower-than-expected Property Transfer Tax revenue.  Transient Occupancy Tax (TOT) o Transient occupancy tax is separated in to two categories; TOT revenue from Terranea Resort and miscellaneous TOT revenue received from America’s Best Value Inn and the Terranea Casitas rental properties. Staff projected $5.37 million in revenue from Terranea and $223,000 from all miscellaneous properties. Miscellaneous TOT revenue exceeded estimates by $27,600 or 12%. Terranea’s TOT revenue saw a minor increase of $29,600 or 0.6%, resulting in an overall net increase over estimates of 1%.  Licenses and Permits o Revenue exceeded expectations by $237,000 or 12% overall compared to year-end estimates. License and permit revenue can vary and is dependent on the frequency of residential and commercial projects in the City. For this reason, this revenue source can be difficult to project.  Franchise Tax Property Tax 13,439,000$ 13,476,700$ 13,567,136$ 90,436$ 0.67% TOT 5,823,100 5,588,200 5,645,497 57,297 1.03% Sales Tax 2,561,300 2,567,000 2,661,180 94,180 3.67% License & Permits 2,290,300 1,967,800 2,204,606 236,806 12.03% Franchise Tax 2,024,900 2,024,900 2,149,743 124,843 6.17% UUT 1,921,600 1,921,600 1,917,107 (4,493) -0.23% OTHER/ MISC 1,572,500 1,907,900 2,098,551 190,651 9.99% OTHER TAXES 1,290,400 1,305,500 1,374,841 69,341 5.31% Subtotal 30,923,100 30,759,600 31,618,662 859,062 2.79% TRANSFER IN 220,000 220,000 220,000 - Total Revenues 31,143,100$ 30,979,600$ 31,838,662$ 859,062$ 2.77% % FY 18-19 Revised Budget FY 18-19 YE Estimate FY 18-19 YE Actuals Variance from YE Estimate 3 o Revenue received was approximately $124,800 or 6.2% higher than estimates. Franchise tax is levied on the providers of utility, refuse and cable services in exchange for use of the City’s rights-of-way.  Other/Miscellaneous Revenue o All other non-tax revenue sources make up roughly 6% of General Fund revenue, and include revenues such as fines, Point Vicente Interpretive Center (PVIC) sales, rental fees, Redevelopment Agency loan repayment, federal and state reimbursements, and interest earnings. These other revenue sources combined came in at approximately $190,600 or 10% higher than estimated. There was higher-than-expected revenue from programs/events, rentals/leases, PVIC sales, false alarm fees, code enforcement, and business license penalties. Additionally, revenue from interest earnings continues to grow, exceeding third quarter estimates by $34,600 or 10.4%. General Fund Expenditures Table 3 summarizes the expenditures by category, revised budget, year-end estimates, variances and percent of change in the General Fund. Table 3 – FY 2018-19 General Fund Expenditures – Estimates vs. Actuals As illustrated in Table 3, Expenditures ended the year better than estimated by slightly over $1.7 million. The following are highlights of the changes to the year-end estimates:  Salaries and Benefits o Combined ended the year almost $246,000 or 14% under year- end estimates. This is due to several unanticipated employee FY 2018-19 FY 2018-19 FY 2018-19 Revised YE Estimates at Unaudited Budget 3rd Quarter Actual Variance % Salaries 7,909,850 7,326,579 7,229,052 (97,527) 5.61% Benefits 2,918,100 2,772,901 2,624,607 (148,294) 8.52% Legal Services 925,000 1,187,646 1,160,193 (27,453) 1.58% Sheriff Contract 6,318,500 6,318,500 6,335,382 16,882 -0.97% Preserve 584,200 584,200 584,236 36 0.00% Professional & Technical Services 3,524,837 3,244,491 2,537,012 (707,479) 40.66% Repairs & Maintenance 2,845,369 2,817,985 2,479,995 (337,990) 19.43% Supplies 681,084 743,800 421,187 (322,613) 18.54% Training/Conference 347,516 287,382 220,373 (67,009) 3.85% Misc. Expense 1,307,722 1,311,044 1,262,571 (48,473) 2.79% TOTAL OPERATING EXPENDITURES 27,362,178 26,594,528 24,854,607 (1,739,921) Transfers out 4,564,700 4,317,000 4,346,852 29,852 TOTAL EXPENDITURES 31,926,878 30,911,528 29,201,459 (1,710,069) 4 separations in the fourth quarter.  Professional and Technical Services o Finished the year about $707,000 or 41% under year-end estimates. About $396,000 of the underrun is due to delayed services and the remaining balance of $311,000 is due to planned services that were not utilized during the fiscal year.  Repairs and Maintenance o Came in under estimates by about $338,000 or 19%. The underrun in repairs is primarily due to repair services not needed during the fiscal year.  Supplies o Ended the year under the year-end estimate by slightly over $323,000 or 19%. Approximately $160,000 of the underrun is due to delay in receiving merchandise before the end of the fiscal year. The remaining balance of $163,000 is the automated license plate recognition (ALPR) camera moving to Capital Improvement Program. Table 4 – FY 2018-19 Fund Balance Reconciliation 5 The table above is a reconciliation of the changes to estimates and the reconciliation of the General Fund balance at the end of FY 2018-19. The fund balance reconciliation begins with the beginning fund balance, revenues received and transfers in, less operating expenditures and transfers out. The remaining calculation recognizes any designations impacting the fund balance at the end of the year, such as the 50% Policy Reserve, purchase orders that were in process at year-end, and continuing appropriations. The resulting amount is the excess fund balance remaining at the end of the year. Overall, the General Fund operations ended the year with an increase in revenues and expenditures coming in well below estimates. This resulted in a General Fund surplus of approximately $7.2 million, an increase of over $2.3 million over year-end estimates, after funding the 50% Reserve Policy and accounting for purchase orders carry-forward and continuing appropriations into FY 2019-20. Capital Improvement Program Fund FY 2018-19 FY 2018-19 Changes Year-end Unaudited to Year-end Estimates Actual Estimates Beginning Fund Balance - 7/1/18 18,078,960 18,078,960 - Add: Revenues 30,759,600 31,618,662 859,062 Add: Transfers In 220,000 220,000 - Subtotal 49,058,560 49,917,622 859,062 Less: Expenditures (26,594,528) (24,854,607) 1,739,921 Less: Transfers Out CIP (4,272,000) (4,301,852) (29,852) Less: Transfers Out Misc.(45,000) (45,000) - Subtotal (30,911,528) (29,201,459) 1,710,069 Unaudited Ending Fund Balance - 6/30/19 18,147,032 20,716,163 2,569,131 PO Carry-forward (341,432) (341,432) Continuing Appropriation (400,000) (400,000) Reserve Policy (50% of budgeted expenditures)(13,297,264) (12,798,020) 499,245 Excess Reserve 4,849,768 7,176,712 2,326,944 6 The Capital Improvement Program (CIP) Fund ended the year with a fund balance of approximately $27 million. Of this amount, total General Fund TOT transfers in were about $4.3 million and federal/state grants reimbursement of almost $1.1 million. The total capital outlay expenditures is almost $3.3 million. Equipment Replacement Fund The Equipment Replacement Fund ended the year with an unaudited fund balance of over $3 million. After accounting for the amount to be set aside for the restricted Council policy ($2.2 million) and for Purchase-Order Carry-forwards ($117,000), the fund ended the year with a surplus of over $700,000. Water Quality/Flood Protection Fund The Water Quality/Flood Protection (WQFP) Fund started the year with a negative fund balance due to a pending reimbursement from Caltrans for a completed project. The City received the reimbursement from Caltrans in the amount of $200,000 during FY 2018-19 and the last project was accepted by the City Council as complete on October 1, 2019. The WQFP funds have been expended and the fund has a zero available balance. All future/ongoing projects will no longer be funded by the WQFP Fund and will need to compete for funding with other capital projects. Other Governmental Funds Other Governmental Funds include Special Revenue Funds and Permanent Funds. The total restricted fund balance for these funds at June 30, 2019 is approximately $13.7 million. A total of about $1.8 million or 13% of the fund balance is restricted by City Council policy: $50,000 – Habitat Restoration, $750,000 – Sub-Region One, and $1,000,000 – Abalone Cove Improvement Authority. In addition to the Council policy, these funds also have purchase order being carried forward totaling slightly over $2.6 million and continuing appropriations of about $757,000; resulting in an unaudited fund balance surplus of more than $8.5 million. Capital Projects At the Capital Improvement Projects Workshop held on April 18, 2019, the City Council approved a list of projects that were expected to continue into FY 2019 -20. After closing FY 2018-19, the remaining balance for these projects is slightly over $6 million from various funds. Table 5 highlights each project, funding source, and the amount remaining in the project at June 30, 2019. 7 Table 5: FY 2018-19 Continuing Project Requests Fund Project Name Purchase Order Carry- Forward Continuing Appropriation Total 211 Citywide Street Light Acquisition and Smart Street Lighting System 535,797$ 127,551$ 663,348$ Total Fund 211 - 1911 Act 535,797$ 127,551$ 663,348$ 215 Traffic/Transportation Improvements 9,081$ 424,220$ 433,301$ Total Fund 215 - Proposition C 9,081$ 424,220$ 433,301$ 216 Transit Improvement - Bus Turnout/Stations - Design 4,851$ 1,041$ 5,892$ Total Fund 216 - Proposition A 4,851$ 1,041$ 5,892$ 220 Western Ave. Traffic Congestion Improvements 113,705$ 150,001$ 263,706$ Total Fund 220 - Measure R 113,705$ 150,001$ 263,706$ 310 ADA Improvements - Area 1 16,222$ 29,242$ 45,464$ 310 ADA Improvements - Area 9 115,039$ 6,360$ 121,399$ Total Fund 310 - CDBG 131,261$ 35,602$ 166,863$ 330 Abalone Cove Sanitary Sewer System Rehabilitation Program 41,291$ 11,995$ 53,286$ 330 Arterial Fences & Walls - Hawthorne Blvd. (Phase1)24,480$ -$ 24,480$ 330 Citywide ADA Transistion Plan and Implementation 66,450$ -$ 66,450$ 330 Civic Center Master Plan -$ 168,651$ 168,651$ 330 Connector Pipe Screens Project (SM Bay Prop. 84 Program)240,194$ 15,200$ 255,394$ 330 Hawthorne Blvd. Beautification - Design 47,250$ 32,080$ 79,330$ 330 Hesse Athletic Field Improvement Project 36,341$ 392,420$ 428,761$ 330 Pavement Management Program 35,313$ -$ 35,313$ 330 Peninsula-Wide Safe Routes 27,573$ -$ 27,573$ 330 Portuguese Bend Landslide Remediation 304,184$ 36,620$ 340,804$ 330 PVDS Realignment - East End 83,954$ 8,914$ 92,868$ 330 Residential Street Rehabilitation Program Area 3&4 - Construction 461,849$ -$ 461,849$ 330 Residential Street Rehabilitation Program Area 7 - Construction -$ -$ -$ 330 Residential Street Rehabilitation Program Area 8 - Construction 117,254$ 493,086$ 610,340$ 330 Signage Program 97,015$ -$ 97,015$ 330 Storm Drain Deficiency Improvement (PVDS at Peppertree Dr. and Hawthorne Blvd.) - Design 195,535$ -$ 195,535$ 330 Western Ave. ALPR Project - Phase 1 138,417$ 221,091$ 359,508$ Total Fund 330 - Infrastructure Improvement 1,917,100$ 1,380,057$ 3,297,157$ 332 Peninsula-Wide Safe Routes 200,428$ -$ 200,428$ 332 Connector Pipe Screens Project (SM Bay Prop. 84 Program)363,237$ -$ 363,237$ Total Fund 332 - State Grants 563,665$ -$ 363,237$ 334 Conestoga Trail Connection 406,282$ -$ 406,282$ 334 Ladera Linda Community Center 456,059$ 18,446$ 474,505$ Total Fund 334 - Quimby 862,341$ 18,446$ 880,787$ Total 4,137,801$ 2,136,918$ 6,074,291$ 8 Table 6 – Other Funds Year-end Summary As part of the year-end process, Staff reviewed open purchase orders and projects that were approved but have not yet started or been completed by June 30, 2019. A Purchase Order Carry-Forward Schedule is prepared for purchases that were encumbered in FY 2018-19, but not completed or delivered by June 30, 2019. A Continuing Appropriation list is prepared for projects that were approved but were delayed or have not started in FY 2018-19. Below are the details of the Purchase Order Carry-Forward and Continuing Appropriation requests. Purchase Order Carry-Forward Schedule To meet budgetary requirements, purchase orders must be carried forward in to FY 2019-20. The carry-forward items which total $4.6 million have no net fiscal impact as they decrease the FY 2018-19 budget and increase the FY 2019-20 budget by the same amount. More than $4 million or 90% of the carry-forward items are for capital- related projects. The following is a summary of all purchase orders to be carried forward aggregated by fund. Additional details are included in Attachment A-1, FY 2018-19 Purchase Order Carry- Forward Schedule. Capital Equipment Water Quality Other in millions Improvement Replacement Flood Protection Special Revenues Beginning Fund Balance - 7/1/18 24,405,475$ 3,172,478$ (200,000)$ 16,837,195$ Add: Revenues 513,970$ 351,159$ 200,000$ 7,058,347$ Add: Transfers in from General Fund 4,301,852$ -$ -$ 45,000$ Add: Transfers In from Special Revenue Funds 1,087,318$ -$ -$ 300,000$ Subtotal 30,308,615$ 3,523,637$ -$ 24,240,542$ Less: Expenditures (3,291,424)$ (452,376)$ -$ (8,920,705)$ Less: Transfers Out -$ -$ -$ (1,607,318)$ Subtotal (3,291,424)$ (452,376)$ -$ (10,528,023)$ Unaudited Ending Fund Balance - 6/30/19 27,017,191$ 3,071,261$ -$ 13,712,519$ Restricted by Council Policy (3,000,000)$ (2,217,000)$ -$ (1,800,000)$ PO Carry-forward (1,917,100)$ (116,773)$ -$ (2,569,464)$ Continuning Appropriation (1,380,058)$ -$ -$ (756,860)$ Unaudited Fund Balance Surplus/(Deficit) 20,720,033$ 737,488$ -$ 8,586,195$ 9 Table 7: FY 2018-19 Purchase Order Carry-forward Requests Continuing Appropriations Requests In addition to the purchase orders carried forward, the Finance Department, in partnership with the other departments and the City Manager, prepares a summary of proposed continuing appropriations to be carried over to the next fiscal year. Staff requests continuing appropriations of $400,000 in General Fund:  $250,000 for professional technical services  $75,000 for leave buyout  $25,000 for supplies  $50,000 for training and conferences In addition to the General Fund continuing appropriation s, Staff requests continuing appropriations for capital projects that were approved by the City Council on April 18, 2019 for a total of $2,136,918 from various funds. Table 8 summarizes all purchase orders carried forward and continuing appropriations by fund. The continuing appropriations have no net fiscal impact as they decrease the FY 2018-19 budget and increase the FY 2019-20 budget for the same amount. Fund Name Fund No. PO Carry-forward General Fund 101 341,432$ 1911 Act Street Lighting 211 535,797$ Proposition C 215 9,081$ Proposition A 216 4,851$ Measure R 220 113,705$ Donor Restricted 228 7,331$ CDBG 310 131,261$ CIP 330 1,917,100$ State Grant 332 563,665$ Quimby 334 862,341$ Equipment Replacement 681 116,773$ Grand Total 4,603,337$ 10 Table 8: FY 2018-19 Purchase Order Carry-forward and Continuing Appropriation Requests – by Fund The year-end unaudited actuals were presented to the Finance Advisory Committee (FAC) on November 14, 2019. The City’s external auditor, White Nelson Diehl Evans, LLP, completed the audit fieldwork for FY 2018-19 in late October. Once the audit is complete, the Finance Department 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. Fund Fund Name PO Carry- Forward Continuing Appropriation Total 101 General Fund 341,432$ 400,000$ 741,432$ 211 1911 Act Street Lighting 535,797$ 127,551$ 663,348$ 215 Proposition C 9,081$ 424,220$ 433,301$ 216 Proposition A 4,851$ 1,041$ 5,892$ 220 Measure A 113,705$ 150,001$ 263,706$ 228 Donor Restricted 7,331$ -$ 7,331$ 310 CDBG 131,261$ 35,602$ 166,863$ 330 CIP 1,917,100$ 1,380,057$ 3,297,157$ 332 State Grant 563,665$ -$ 563,665$ 334 Quimby 862,341$ 18,446$ 880,787$ 681 Equipment Replacement 116,773$ -$ 116,773$ Total 4,603,337$ 2,536,918$ 7,140,255$ 11 FY18-19 PO Carryover by Fund 6/30/2019 Fund Name Fund No.PO Carryover General Fund 101 341,431.95$ 1911 Act Street Lighting 211 535,797.24$ Proposition C 215 9,080.77$ Proposition A 216 4,851.60$ Measure R 220 113,705.30$ Donor Restricted 228 7,331.47$ CDBG 310 131,260.50$ CIP 330 1,917,099.59$ State Grant 332 563,665.30$ Quimby 334 862,341.00$ Equipment Replacement 681 116,773.25$ Grand Total 4,603,337.97$ A-1 ACCOUNT NUMBER DEPARTMENT DEPARTMENT - SECTION FUND CODE FUND DESC VENDOR NAME PO NUMBER YEAR OBJECT CODE OBJECT DESC PO Amount Carryover COMMENT/DESC Justification to CFWD 101-400-3110-5101 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND ANDERSONPENNA PARTNERS, INC.20190235 2019 5101 PROFESSIONAL/TECH SERVICES $ 770.00 FY18-19 STUDY EVAL PVDE TRAFFI This is an on-going project. Additional work has been requested by the TSC. Consultant is continuing to work on design options. 101-400-3150-5201 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND COUNTY OF LOS ANGELES 20190388 2019 5201 REPAIR & MAINT $ 15,536.70 FY18-19 FUEL MODIFICATION Invoices received after 6/30 but before 8/30. 101-400-5121-4310 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND OFFICE DEPOT 20190054 2019 4310 OPERATING MATERIALS & SUPPLIES $ 583.99 FY1819 OFFICE SUPPLIES Invoices received after 6/30 but before 8/30. 101-400-5170-4310 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND OFFICE DEPOT 20190054 2019 4310 OPERATING MATERIALS & SUPPLIES $ 1,042.30 FY1819 OFFICE SUPPLIES Invoices received after 6/30 but before 8/30. 101-400-2999-4310 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND OFFICE DEPOT 20190054 2019 4310 OPERATING MATERIALS & SUPPLIES $ 1,600.92 FY1819 OFFICE SUPPLIES Invoices received after 6/30 but before 8/30. 101-400-5110-4310 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND OFFICE DEPOT 20190054 2019 4310 OPERATING MATERIALS & SUPPLIES $ 742.19 FY1819 OFFICE SUPPLIES Invoices received after 6/30 but before 8/30. 101-400-5180-4310 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND OFFICE DEPOT 20190054 2019 4310 OPERATING MATERIALS & SUPPLIES $ 1,526.04 FY1819 OFFICE SUPPLIES Invoices received after 6/30 but before 8/30. 101-400-2999-4310 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND NEOPOST 20190185 2019 4310 OPERATING MATERIALS & SUPPLIES $ 294.21 FY1819 POSTAGE Invoices received after 6/30 but before 8/30. 101-400-3110-5101 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND ANDERSONPENNA PARTNERS, INC.20190269 2019 5101 PROFESSIONAL/TECH SERVICES $ 1,600.00 FY18-19 LAND SURVEY PARKHURST Work completed. Invoices received after 6/30 but before 8/30. 101-400-3151-4310 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND RECYCLE AWAY, LLC 20190384 2019 4310 OPERATING MATERIALS & SUPPLIES $ 15,424.15 FY18-19 SCHEM DESIGN PVDE WIDE This is an on-going project. Additional work has been requested by the TSC. Consultant is continuing to work on design options. 101-400-3110-5101 PUBLIC WORKS PUBLIC WORKS - ADMIN 101 GENERAL FUND ANDERSONPENNA PARTNERS, INC.20190254 2019 5101 PROFESSIONAL/TECH SERVICES $ 3,000.00 FY18-19 SCHEM DESIGN PVDE WIDE This is an on-going project. Additional work has been requested by the TSC. Consultant is continuing to work on design options. 101-400-4120-5101 COMMUNITY DEVELOPMENT COMMUNITY DEVELOPMENT - PLANNING 101 GENERAL FUND ABCX2, LLC 20190383 2019 5101 PROFESSIONAL/TECH SERVICES $ 18,937.50 FY18-19 AIR- NOISE FLIGHT TRACK Continued Project through Q1 2020 101-400-3120-5101 PUBLIC WORKS PUBLIC WORKS - TRAFFIC SAFETY 101 GENERAL FUND WILLDAN ENGINEERING 20190149 2019 5101 PROFESSIONAL/TECH SERVICES $ 15,120.53 FY 18-19 PROF. SERVICES FED./S Some certified payroll issues pending on a project from FY 18-19. Need funds to resolve pending issue. 101-400-2999-5101 FINANCE FINANCE - NON-DEPT 101 GENERAL FUND HARSHMAN, CAROLYN JEAN 20190405 2019 5101 PROFESSIONAL/TECH SERVICES $ 19,650.00 UPDATE CITY HAZMIT PLAN Ongoing project, estimated to be completed in FY19-20 101-400-5130-4310 RECREATION & PARKS RECREATION & PARKS - LADERA LINDA 101 GENERAL FUND MITY-LITE, INC.20190318 2019 4310 OPERATING MATERIALS & SUPPLIES $ 10,068.07 FY18-19 NEW TABLES AND CHAIRS Orderd in FY18-19 but lead time extended by vendor 101-400-5150-4310 RECREATION & PARKS RECREATION & PARKS - LADERA LINDA 101 GENERAL FUND MITY-LITE, INC.20190318 2019 4310 OPERATING MATERIALS & SUPPLIES $ 9,099.95 FY18-19 NEW TABLES AND CHAIRS Orderd in FY18-19 but lead time extended by vendor A-2 ACCOUNT NUMBER DEPARTMENT DEPARTMENT - SECTION FUND CODE FUND DESC VENDOR NAME PO NUMBER YEAR OBJECT CODE OBJECT DESC PO Amount Carryover COMMENT/DESC Justification to CFWD 101-400-2999-5101 FINANCE FINANCE - NON-DEPT 101 GENERAL FUND BLAIS & ASSOCIATES, INC.20190144 2019 5101 PROFESSIONAL/TECH SERVICES $ 19,949.60 FY18-19 ANNUAL CONTRACT FOR GR Ongoing project, estimated to be completed in FY19-20. 101-400-4110-5118 COMMUNITY DEVELOPMENT COMMUNITY DEVELOPMENT - ADMIN.101 GENERAL FUND BASHMAKIAN, ARTASHES 20180402 2018 5118 REIMBURSABLE SERVICES $ 20,315.60 CONTRACT PLANNING FOR WIRELESS Continued project- for Wireless Tecom projects reimbursed by Crown Castle. 101-400-3151-4310 PUBLIC WORKS PUBLIC WORKS - PARK MAINT.101 GENERAL FUND BSN SPORTS, LLC 20190399 2019 4310 OPERATING MATERIALS & SUPPLIES $ 20,620.40 FY 18-19 HESSE PK BLEACHERS Equipment ordered in FY1819 but not received by end of FY 18-19. 101-400-3151-4310 PUBLIC WORKS PUBLIC WORKS - PARK MAINT.101 GENERAL FUND PLAYCORE WISCONSIN, INC.20190380 2019 4310 OPERATING MATERIALS & SUPPLIES $ 28,929.83 FY 18-19 LOWER HESSE SHADE STR Equipment ordered in FY1819 but not received by end of FY 18-19. 101-400-4120-5101 COMMUNITY DEVELOPMENT COMMUNITY DEVELOPMENT - PLANNING 101 GENERAL FUND ALTA PLANNING + DESIGN, INC 20190332 2019 5101 PROFESSIONAL/TECH SERVICES $ 29,616.14 FY18-19 TRAILS NETWORK PLAN Continued Project through Q1 2020. 101-400-3150-4310 PUBLIC WORKS PUBLIC WORKS - TRAILS & OPEN SPACE 101 GENERAL FUND RECYCLE AWAY, LLC 20190384 2019 4310 OPERATING MATERIALS & SUPPLIES $ 70,000.00 FY 18-19 TRASH RECEPTACLES - P Equipment ordered in FY1819 but not received by end of FY 18-19. 101-400-4120-5101 COMMUNITY DEVELOPMENT COMMUNITY DEVELOPMENT - PLANNING 101 GENERAL FUND RINCON CONSULTANTS, INC.20190217 2019 5101 PROFESSIONAL/TECH SERVICES $ 34,753.83 FY18-19 ENVIRONMENTAL IMPACT R Continued Project through Q2 2020. 101-400-3110-5101 PUBLIC WORKS PUBLIC WORKS (CIP) - WESTERN AVE. ALPR 101 INFRASTRUCTURE IMPROVEMENTS NV5, INC.20190314 2019 5101 PROFESSIONAL/TECH SERVICES $ 2,250.00 FY18-19 NV5 ENGINEERING SERVIC Continued Project through Q1 2020. 211-400-8821-8099 PUBLIC WORKS PUBLIC WORKS (1911 ACT STREET LIGHTING) - STREET LIGHT ACQUISITION 211 1911 ACT STREET LIGHTING SIEMENS INDUSTRY, INC.20180442 2018 8099 MISC./OTHER EXPENSES $ 464,589.18 STREETLIGHT ACQUISITION, PROGRAM Streetlight acquisition is in process. Anticipate completion by end of December 2020. 211-400-8821-8099 PUBLIC WORKS PUBLIC WORKS (1911 ACT STREET LIGHTING) - STREET LIGHT ACQUISITION 211 1911 ACT STREET LIGHTING SOUTHERN CALIFORNIA EDISON 20190265 2019 8099 MISC./OTHER EXPENSES $ 71,208.06 FY18-19 STREETLIGHT ACQUISITION Streetlight acquisition is in process. Anticipate completion by end of December 2020. 215-400-8828-8005 PUBLIC WORKS PUBLIC WORKS (PROPOSITION C) - TRAFFIC 215 PROPOSITION C WILLDAN ENGINEERING 20190360 2019 8005 ENGINEERING DESIGN SERVICES $ 3,826.81 FY 18-19 TRAFFIC SIGNAL PVDS/P Design 65% complete. Design completion anticipated in spring 2020. 215-400-8828-8005 PUBLIC WORKS PUBLIC WORKS (PROPOSITION C) - TRAFFIC 215 PROPOSITION C WILLDAN ENGINEERING 20190151 2019 8005 ENGINEERING DESIGN SERVICES $ 5,253.96 FY 18-19 PVDS INTERSECT DESIGN Design 50% complete. Design completion anticipated in spring 2020. 216-400-8824-8005 PUBLIC WORKS PUBLIC WORKS (PROPOSITION A) - SILVER SPUR 216 PROPOSITION A PENCO, A CANNON COMPANY 20190334 2019 8005 ENGINEERING DESIGN SERVICES $ 4,851.60 FY18-19 SILVER SPUR TRANSIT IM Design 70% complete. Design completion anticipated in spring 2020. 220-400-8809-8005 PUBLIC WORKS PUBLIC WORKS (MEASURE R) - WESTERN AVE.220 MEASURE R WILLDAN ENGINEERING 20190282 2019 8005 ENGINEERING DESIGN SERVICES $ 113,705.30 FY18-19 WESTERN AVE CONGEST DE Ongoing project.Design 20% complete. A-3 ACCOUNT NUMBER DEPARTMENT DEPARTMENT - SECTION FUND CODE FUND DESC VENDOR NAME PO NUMBER YEAR OBJECT CODE OBJECT DESC PO Amount Carryover COMMENT/DESC Justification to CFWD 228-400-8501-8403 PUBLIC WORKS PUBLIC WORKS (DONOR RESTRICTED CONTRIBUTION) - PVIC REPLACEMENT 228 DONOR RESTRICTED CONTRIBUTION CHAMP SITE SERVICES INC.20190292 2019 8403 PARKS IMPROVEMENTS $ 4,331.47 FY18-19 PVIC WHALE & LIGHTHOUSE Ongoing project; waiting to close in FY1920. 228-400-0000-4310 PUBLIC WORKS PUBLIC WORKS (DONOR RESTRICTED CONTRIBUTION) 228 DONOR RESTRICTED CONTRIBUTION PLAYCORE WISCONSIN, INC.20190380 2019 4310 OPERATING MATERIALS & SUPPLIES $ 3,000.00 FY 18-19 LOWER HESSE SHADE STR Project to begin shortly. 310-400-8832-8801 PUBLIC WORKS PUBLIC WORKS (CDBG) - ADA CROSSWALK AREA 9 310 CDBG HARDY & HARPER, INC.20190410 2019 8801 INFRASTRUCTURES $ 93,466.00 FY 18-19 ADA ACCESS AREA 9- CON Project in construction. Construction 80% complete. Anticipate completion by end of October 2019. 310-400-8832-8006 PUBLIC WORKS PUBLIC WORKS (CDBG) - ADA CROSSWALK AREA 9 310 CDBG SUNBEAM SOLAR 20190409 2019 8006 INSPECTION SERVICES $ 8,000.00 FY 18-19 ADA ACCESS AREA 9 - IN Project in construction. Construction 80% complete. Anticipate completion by end of October 2019. 310-400-8832-8001 PUBLIC WORKS PUBLIC WORKS (CDBG) - ADA CROSSWALK AREA 9 310 CDBG MICHAEL BAKER INTERNATIONAL, INC.20190229 2019 8001 PROFESSIONAL/TECH SERVICES $ 11,331.25 FY18-19 CDBG ADMIN SERVICES Project in construction. Construction 80% complete. Anticipate completion by end of October 2019. 310-400-8829-8001 PUBLIC WORKS PUBLIC WORKS (CDBG) - ADA CROSSWALK AREA 1 310 CDBG MICHAEL BAKER INTERNATIONAL, INC.20190229 2019 8001 PROFESSIONAL/TECH SERVICES $ 18,463.25 FY18-19 CDBG ADMIN SERVICES The project construction is complete. The consultant is in the process of resolving the contractor's payroll issue and is working with CDC on the grant closeout process. The consultant may not spent all the funds. 330-400-8834-8005 PUBLIC WORKS PUBLIC WORKS (CIP) - STREET REHAB C3 AREA 3&4 330 INFRASTRUCTURE IMPROVEMENTS SUNBEAM SOLAR 20190227 2019 8005 ENGINEERING DESIGN SERVICES $ 461,849.40 FY18-19 RES. REHAB AREAS 3 AND Project recently awarded. 330-400-8811-8802 330 METROCELL 20190392 2019 8802 Arterial Wall Other Imp $ 24,480.00 ARTERIAL FENCE Ongoing project. 330-400-8830-8005 PUBLIC WORKS PUBLIC WORKS (CIP) - PENINSULA-WIDE SAFE ROUTES 330 INFRASTRUCTURE IMPROVEMENTS KOA CORPORATION 20190377 2019 8005 ENGINEERING DESIGN SERVICES $ 27,573.02 FY 18-19 SAFE ROUTE TO SCHOOL Consultant preparing master plan for Peninsula. Much work ahead. 330-400-8822-8802 PUBLIC WORKS PUBLIC WORKS (CIP) - WESTERN AVE. ALPR 330 INFRASTRUCTURE IMPROVEMENTS FARR, JASON 20190404 2019 8802 OTHER IMPROVEMENTS $ 136,042.00 FY 18-19 WESTERN AVE ALPR CONS Construction started. Completion anticipated by end of December 2019. A-4 ACCOUNT NUMBER DEPARTMENT DEPARTMENT - SECTION FUND CODE FUND DESC VENDOR NAME PO NUMBER YEAR OBJECT CODE OBJECT DESC PO Amount Carryover COMMENT/DESC Justification to CFWD 330-400-8822-8005 PUBLIC WORKS PUBLIC WORKS (CIP) - WESTERN AVE. ALPR 330 INFRASTRUCTURE IMPROVEMENTS NV5, INC.20190221 2019 8005 ENGINEERING DESIGN SERVICES $ 2,375.00 FY18-19 NV5 ENGINEERING SERVIC Design 95% complete. Consultant assisting with minor remaining questions. 330-400-8818-8004 PUBLIC WORKS PUBLIC WORKS (CIP) - RESIDENT ST. REHAB C2 AREA 8 330 INFRASTRUCTURE IMPROVEMENTS SUNBEAM SOLAR 9396 2017 8004 ARCHITECTURE DESIGN SERVICES $ 117,253.60 DESIGN FOR AREA 8 Project complete. However waiting for County to conduct record of survey. Estimated completion by end of December 2020. 330-400-8804-8008 PUBLIC WORKS PUBLIC WORKS (CIP) - HAWTHORNE BLVD. BEAUTIFICATION 330 INFRASTRUCTURE IMPROVEMENTS CICCHETTI, JON DAVID 20190281 2019 8008 MATERIAL TESTINGS $ 7,820.00 FY18-19 HAWTHORNE BLVD MEDIAN Design 90% complete. 330-400-8804-8004 PUBLIC WORKS PUBLIC WORKS (CIP) - HAWTHORNE BLVD. BEAUTIFICATION 330 INFRASTRUCTURE IMPROVEMENTS CICCHETTI, JON DAVID 20190281 2019 8004 ARCHITECTURE DESIGN SERVICES $ 39,430.00 FY18-19 HAWTHORNE BLVD MEDIAN Design 90% complete. 330-400-8715-8004 PUBLIC WORKS PUBLIC WORKS (CIP) - SDDIP 330 INFRASTRUCTURE IMPROVEMENTS DCA CIVIL ENGINEERING GROUP, INC.20190337 2019 8004 ARCHITECTURE DESIGN SERVICES $ 195,534.86 FY 18-19 STORM DRAIN DEFICIENCY Design 50% complete. Anticipate completion by end of December 2019. 330-400-8709-8807 PUBLIC WORKS PUBLIC WORKS (CIP) - CONNECTOR PIPE 330 INFRASTRUCTURE IMPROVEMENTS UNITED STORM WATER, INC.20190237 2019 8807 STORMWATER IMPROVEMENTS $ 132,846.76 FY18-19 CONSTRUCTION OF SANTA Construction 75% complete. County owned catch basins remaining. Waiting to receive permit from the County. Lengthy process since each catch basin will require its individual permit. Completion date depends on County responsiveness. 330-400-8709-8004 PUBLIC WORKS PUBLIC WORKS (CIP) - CONNECTOR PIPE 330 INFRASTRUCTURE IMPROVEMENTS PSOMAS 20190264 2019 8004 ARCHITECTURE DESIGN SERVICES $ 107,347.50 FY18-19 SANTA MONICA BAY CATCH Construction 75% complete. County owned catch basins remaining. Waiting to receive permit from the County. Lengthy process since each catch basin will require its individual permit. Completion date depends on County responsiveness. 330-400-8504-8004 PUBLIC WORKS PUBLIC WORKS (CIP) - CITYWIDE ADA TRANSITION 330 INFRASTRUCTURE IMPROVEMENTS CALIFORNIA JOINT POWERS INSURANCE AUTHORITY 20190328 2019 8004 ARCHITECTURE DESIGN SERVICES $ 66,450.00 FY 18-19 ADA TRANSITION PLAN Consultant 70% completed the transition plan. Anticipate completion by Spring 2020. A-5 ACCOUNT NUMBER DEPARTMENT DEPARTMENT - SECTION FUND CODE FUND DESC VENDOR NAME PO NUMBER YEAR OBJECT CODE OBJECT DESC PO Amount Carryover COMMENT/DESC Justification to CFWD 330-400-8420-8802 PUBLIC WORKS PUBLIC WORKS (CIP) - SIGNAGE PROGRAM 330 INFRASTRUCTURE IMPROVEMENTS PALOS VERDES PENINSULA LAND CONSERVANCY 20190296 2019 8802 OTHER IMPROVEMENTS $ 97,015.00 FY18-19 NATURE PRESERVE ENTRY Project not complete. Trail signage still needed. 330-400-8419-8006 PUBLIC WORKS PUBLIC WORKS (CIP) - Hesse ATHLETIC FIELD 330 INFRASTRUCTURE IMPROVEMENTS FOUNTAINHEAD CONSULTING CORPORATION 20190365 2019 8006 INSPECTION SERVICES $ 29,280.00 FY 18-19 Hesse PK- INSPECTION Project to be re-bid. Award expected in February 2020. 330-400-8419-8005 PUBLIC WORKS PUBLIC WORKS (CIP) - Hesse ATHLETIC FIELD 330 INFRASTRUCTURE IMPROVEMENTS CICCHETTI, JON DAVID 20190266 2019 8005 ENGINEERING DESIGN SERVICES $ 7,060.55 FY18-19 Hesse PARK TURF IMPROV Project to be re-bid. Award expected in February 2020. 330-400-8304-8001 PUBLIC WORKS PUBLIC WORKS (CIP) - PB LANDSLIDE AREA 330 INFRASTRUCTURE IMPROVEMENTS DANIEL B. STEPHENS & ASSOCIATES, INC.20190286 2019 8001 PROFESSIONAL/TECH SERVICES $ 304,184.20 FY18-19 PORTUGUESE LANDSLIDE M Design 60% complete. Anticipate completion by end of December 2019. 330-400-8301-8005 PUBLIC WORKS PUBLIC WORKS (CIP) - PVDS REALIGNMENT EAST END 330 INFRASTRUCTURE IMPROVEMENTS GEOLOGIC ASSOCIATES, INC.20190356 2019 8005 ENGINEERING DESIGN SERVICES $ 83,954.11 FY 18-19 PVDS REALIGNMENT/ST RA Design 60% complete. Anticipate completion by end of December 2019. 330-400-8202-8005 PUBLIC WORKS PUBLIC WORKS (CIP) - AB COVE 330 INFRASTRUCTURE IMPROVEMENTS NV5, INC.20190366 2019 8005 ENGINEERING DESIGN SERVICES $ 41,290.71 FY 18-19 ABALONE COVE SEWER RE Design 50% complete. Anticipate completion by end of December 2019. 330-400-8001-8001 PUBLIC WORKS PUBLIC WORKS (CIP) - PAVEMENT 330 INFRASTRUCTURE IMPROVEMENTS BUCKNAM, PETER JOSEPH 20190238 2019 8001 PROFESSIONAL/TECH SERVICES $ 35,312.88 FY18-19 PAVEMENT MANAGEMENT SY Draft report complete. Waiting for final report. 332-400-8830-8005 PUBLIC WORKS PUBLIC WORKS (STATE GRANTS) - PENINSULA-WIDE SAFE ROUTES 332 STATE GRANTS KOA CORPORATION 20190377 2019 8005 ENGINEERING DESIGN SERVICES $ 200,428.06 FY 18-19 SAFE ROUTE TO SCHOOL Consultant preparing master plan for Peninsula. Much work ahead. 332-400-8709-8807 PUBLIC WORKS PUBLIC WORKS (STATE GRANTS) - CONNECTOR PIPE SCREENS 332 STATE GRANTS UNITED STORM WATER, INC.20190237 2019 8807 STORMWATER IMPROVEMENTS $ 363,237.24 FY18-19 CONSTRUCTION OF SANTA Construction 75% complete. County owned catch basins remaining. Waiting to receive permit from the County. Anticipate completion by Spring 2020. 334-400-8410-8404 PUBLIC WORKS PUBLIC WORKS (QUIMBY - CONESTOGA TRAIL 334 QUIMBY PARK DEVELOPMENT PENCO, A CANNON COMPANY 20190336 2019 8404 TRAILS/OPEN SPACE IMPROVEMENTS $ 6,025.00 FY 18-19 CONESTOGA TRAIL- BID Consultant needed for occasional answering and reviewing RFI/Bid related items and providing clarification. 334-400-8410-8404 PUBLIC WORKS PUBLIC WORKS (QUIMBY - CONESTOGA TRAIL 334 QUIMBY PARK DEVELOPMENT KASA CONSTRUCTION, INC.20190403 2019 8404 TRAILS/OPEN SPACE IMPROVEMENTS $ 381,057.00 FY 18-19 CONESTOGA TRAIL CONST Construction 60% complete. Project completion anticipated by end of December 2019. A-6 ACCOUNT NUMBER DEPARTMENT DEPARTMENT - SECTION FUND CODE FUND DESC VENDOR NAME PO NUMBER YEAR OBJECT CODE OBJECT DESC PO Amount Carryover COMMENT/DESC Justification to CFWD 334-400-8410-8006 PUBLIC WORKS PUBLIC WORKS (QUIMBY - CONESTOGA TRAIL 334 QUIMBY PARK DEVELOPMENT SUNBEAM SOLAR 20190400 2019 8006 INSPECTION SERVICES $ 19,200.00 FY 18-19 CONESTOGA TRAIL INSPE Construction 60% complete. Project completion anticipated by end of December 2019. 334-400-8405-8004 PUBLIC WORKS PUBLIC WORKS (QUIMBY) - LADERA LINDA COMMUNITY CENTER 334 QUIMBY PARK DEVELOPMENT JOHNSON FAVARO, LLP 20190312 2019 8004 ARCHITECTURE DESIGN SERVICES $ 429,082.00 FY18-19 LADERA LINDA ARCHITECT Design 30% complete. Community input is needed. Design completion anticipated by June 2020. 334-400-8405-8001 PUBLIC WORKS PUBLIC WORKS (QUIMBY) - LADERA LINDA COMMUNITY CENTER 334 QUIMBY PARK DEVELOPMENT ANDERSONPENNA PARTNERS, INC.20190327 2019 8001 PROFESSIONAL/TECH SERVICES $ 26,977.00 FY18-19 LADERA LINDA SURVEY & Design 30% complete. Community input is needed. Design completion anticipated by June 2020. 681-400-0000-4401 CITY MANAGER CITY MANAGER - IT (EQUIPMENT REPLACEMENT) 681 EQUIPMENT REPLACEMENT RAMUNDSEN SUPERIOR HOLDINGS, LLC.9358 2017 4401 COMPUTERS $ 47,606.95 TRAKIT IMPLEMENTATIO N Ongoing project. 681-400-0000-5101 CITY MANAGER CITY MANAGER - IT (EQUIPMENT REPLACEMENT) 681 EQUIPMENT REPLACEMENT RAMUNDSEN SUPERIOR HOLDINGS, LLC.9358 2017 5101 PROFESSIONAL/TECH SERVICES $ 24,219.98 TRAKIT IMPLEMENTATIO N Ongoing project. 681-400-0000-5101 CITY MANAGER CITY MANAGER - IT (EQUIPMENT REPLACEMENT) 681 EQUIPMENT REPLACEMENT MATRIX IMAGING PRODUCTS, INC.20190116 2019 5101 PROFESSIONAL/TECH SERVICES $ 44,946.32 FY 18-19 SCANNING PROJECT Ongoing project. A-7