Loading...
HomeMy WebLinkAbout10.04.2017 @6:30 Regular Measure W COCWednesday, October 4, 2017 6:30 PM City of South San Francisco P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA Municipal Services Building, Council Chambers 33 Arroyo Drive, South San Francisco, CA Measure W Citizens' Oversight Committee Regular Meeting Agenda October 4, 2017Measure W Citizens' Oversight Committee Regular Meeting Agenda NOTICE IS HEREBY GIVEN, pursuant to Section 54956 of the Government Code of the State of California, the Measure W Citizens' Oversight Committee of the City of South San Francisco will hold a Regular Meeting on Wednesday, October 4, 2017, at 6:30 p.m., in the City Council Chambers, Municipal Services Building, 33 Arroyo Drive, South San Francisco, California. Call To Order. Roll Call. Public Comments. MATTERS FOR CONSIDERATION Motion to approve the Minutes from the meeting of August 2, 2017.1. Presentation of audit overview by independent auditor. (Katherine Yuen, CPA, Vice President, Maze and Associates) 2. Report transmitting Measure W Fiscal Year 2016-17 financial reports. (Richard Lee, Director of Finance) 3. Report regarding transmitting Fiscal Year 2017-18 Measure W financial reports through August 31, 2017. (Richard Lee, Director of Finance) 4. Adjournment. Page 2 City of South San Francisco Printed on 9/29/2017 CITY OF SOUTH SAN FRANCISCO Measure W Citizen Oversight Committee Audit Overview October 4, 2017 1 Our Responsibility under U.S. Generally Accepted Auditing Standards Our responsibility, as described by professional standards, is to express an opinion about whether the financial statements prepared by management with your oversight are fairly presented, in all material respects, in conformity with U.S. generally accepted accounting principles. Our audit of the financial statements does not relieve you or management of your responsibilities. Our responsibility is to plan and perform the audit to obtain reasonable, but not absolute, assurance that the financial statements are free of material misstatement. As part of the audit we will consider the City’s internal control. Such considerations are solely for the purpose of determining our audit procedures and not to provide any assurance concerning such internal control. We are responsible for communicating significant matters related to the audit that are, in our professional judgment, relevant to your responsibilities in overseeing the financial reporting process. However, we are not required to design procedures specifically to identify such matters. Materiality Financial Accounting Standards Board Statement of Financial Accounting Concepts No. 2 (CON-2), Qualitative Characteristics of Accounting Information, defines materiality as the "magnitude of an omission or misstatement of accounting information that, in the light of surrounding circumstances, makes it probable that the judgment of a reasonable person relying on the information would have been changed or influenced by the omission or misstatement." In planning and performing the audit, we use professional judgment to determine a level of materiality. Factors considered in this evaluation include the components of the financial statements believed to be the most critical to users and the extent of adjustments detected in prior audits. Audit Scope Council approved our contract in 2016 which incorporates our proposal detailing our audit approach and timing. Audit scope generally includes the following subject to adaptation from our risk assessment process: •Perform risk assessment brainstorming and planning •Create audit plan tailored to the City and sector •Transactions cycles subject to control testing and sampling: •Transactions cycles testing: •Transactions and balances tested in total: •Evaluate overall duty assignment including: •Information system controls tests: •Perform compliance tests ATTACHMENT A CITY OF SOUTH SAN FRANCISCO Measure W Citizen Oversight Committee Audit Overview October 4, 2017 2 Audit Timing We have met with staff and agreed the following schedule:  Interim fieldwork: May 2017  Final fieldwork: October 2017  Reports finalization: December 2017 Financial Status Balances Page 1 of 1 Criteria: As Of = 6/30/2017; Summarize by = Report,Fund,ObjectGroup,Object; Period = 0,1..12,13,14,15,16; Fund = 101 Object Title Month-To-Date Actual Year-To-Date Actual Year-To-Date Ado Budget Year-To-Date Adjustments Year-To-Date Adj Budget Year-To-Date Encumbrances Bdgt. to Act. Variance Pct. Spent Fund 101 -- MEASURE W Revenues Object Group 30000 -- TAXES 30207 MEASURE W AND USE TAX (0.5%)1,196,802.25 8,886,653.13 7,000,000.00 0.00 7,000,000.00 0.00 (1,886,653.13) 127.0% Total TAXES 1,196,802.25 8,886,653.13 7,000,000.00 0.00 7,000,000.00 0.00 (1,886,653.13)127.0% Total Revenues 1,196,802.25 8,886,653.13 7,000,000.00 0.00 7,000,000.00 0.00 (1,886,653.13)127.0% Expenditures Object Group 5000 -- SUPPLIES & SERVICES 5021 OPERATING SUPPLIES 0.00 210.00 0.00 0.00 0.00 0.00 (210.00) 0.0% 5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 176,177.26 176,177.26 0.00 176,177.26 0.0% Total SUPPLIES & SERVICES 0.00 210.00 0.00 176,177.26 176,177.26 0.00 175,967.26 0.1% Object Group 9000 -- TRANSFERS 9510 TRANSFER OUT TO CAPITAL IMPROV 238,636.32 877,727.51 5,500,000.00 0.00 5,500,000.00 0.00 4,622,272.49 16.0% Total TRANSFERS 238,636.32 877,727.51 5,500,000.00 0.00 5,500,000.00 0.00 4,622,272.49 16.0% Total Expenditures 238,636.32 877,937.51 5,500,000.00 176,177.26 5,676,177.26 0.00 4,798,239.75 15.5% Total MEASURE W 958,165.93 8,008,715.62 1,500,000.00 (176,177.26)1,323,822.74 0.00 (6,684,892.88)605.0% Total 958,165.93 8,008,715.62 1,500,000.00 (176,177.26)1,323,822.74 0.00 (6,684,892.88)605.0% ATTACHMENT 1 Compare & Contrast Transactions & Use Tax (aka District Tax)Bradley Burns 1% Local Sales/Use Tax Sales shipped to on seller's vehicle Applicable district taxes collected and allocated to buyer's location when shipped on sellers' vehicle regardless of where the sale was negotiated (point of sale). If sale negoatiated in *Municipality but shipped out of the Municipality, Municipality gets the Bradley Burns but no district tax. Car Sales Receives district tax revenue on all car purchases of every Municipality resident regardless of where they purchase the vehicle from. Only receives revenue from purchases from dealerhsips physically located in the Municipality. Consumer Decisions Purchasing patterns by consumers who choose where they spend on taxable goods is not a signficant impact. We have noticed no difference to existing sales tax before and after a district tax is approved. ex. A half-cent sales tax on a $1,000 washer and dryer is $5. Consumer more likely to shop for best price over tax rate. Municipalities are limited to only what is transacted within their borders. For example, a visitor to Municipality is likely to also spend in surrounding areas; whereas, Municipality only receives their local tax on transactions occuring within its borders. The 1% local tax is uniform throughout CA; therefore, consumers can not escape the tax by purchasing in another Municipality. Construction Municipality has several construction retailers and wholesalers that generate local Bradley Burns sales tax. Likely to have much of those sales shipped out of Municipality. No district tax. On the other hand, district tax will be captured from construction materials shipped into Municipality. Municipality receives when point of sale is in the Municipality regardless of where product is shipped to. Countywide Pools 3rd party vehicle sales, use taxes, construction, vending machine sales, some internet sales, etc are allocated into countywide pools. There are no pool allocations for District Taxes and Municipality with a district tax receives 100% of tax on these types of transactions. Said transactions are allocated by the SBE to the Countywide pools, and the Municipality only receives the percentage of their quarterly sales tax amount divided by the countywide total sales tax amount. Leases Existing leases at time of district tax becoming effective are not subject to the new district tax. Some leases go through the countywide pools. Some leases are allocated back to the Municipality where the lease was negotiated. Retail, Restaurants, Service Stations Point of destination is the cash register. May have minor differences for retailers shipping product to buyer living outside of Municipality but purchased in Municipality, or possibly a restaurant doing catering outside of Municipality would not get District tax on those sales. Point of sale is the cash register. **Internet Retail Sales Transactions and Use tax is a destination sourced allocation; thereby, the transactions and use tax on all purchases made within a municiplality are allocated to that municipality with the applicable district tax. Amazon, Nordstrom, Macys.com 100% to municipality. 1. ***Amazon, Nordstrom, Macy's and others dot com transactions are allocated to the county pool of the buyer. 2. Some dot com retailers with physical presence in CA, point-of-sale at distribution facility. * [Please Note: Municipality is defined by the jurisdictional boundary. City of South San Francisco, City of San Mateo, Unincorporated San Mateo County, etc, etc] ** Internet Retail Sales. Explaination only applies to sales taxes that are actually collected. Any business without physical presence in CA are not required to collect. *** Amazon currently does not own the stock of goods based in CA warehouse facilities. The SBE ruled that those transactions are use tax and allocate to pools. For internet-based retailers without physical presence in CA, do not have to collect CA sales tax on their sales into CA. Estimated $23M to $26B of uncollected sales taxes nationwide. tax revenue allocated to jurisdiction where purchase was made tax revenue allocated to jurisdiction where purchase was shipped tax revenue allocated to buyer's jurisdiction of residence, regardless of where purchase was made tax revenue allocated to countywide pool ATTACHMENT 2 09/25/2017 CITY OF SOUTH SAN FRANCISCO 2 8:44AM Page:revdetl.rpt Revenue Detail Report 07/01/2016 through 06/30/2017 Periods: 0 through 16 FY 2016-17 Measure W Revenues MEASURE W101 Account Number Adjusted Estimate Revenues Year-to-date Revenues Balance Prct Rcvd 101-00000-30207 MEASURE W AND USE TAX (0.5%)(Continued) Line Description: FY16-17 Measure W Tax-CA Document Description : FY 2016-2017 YEAR END ACCRUAL 101-00000-30207 MEASURE W AND USE TAX (0.5%) 8,886,653.13 8,886,653.13 126.95 7,000,000.00 -1,886,653.13 Total MEASURE W 126.95 8,886,653.13 8,886,653.13 7,000,000.00 -1,886,653.13 Grand Total 8,886,653.13 8,886,653.13 126.95 7,000,000.00 -1,886,653.13 2Page: A B 09/25/2017 CITY OF SOUTH SAN FRANCISCO 1 8:46AM Page:expdetl.rpt Expenditure Detail Report 07/01/2016 through 06/30/2017 Periods: 0 through 16 FY 2016-17 Measure W Expenditures MEASURE W101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used 101-01000 CITY COUNCIL 101-01000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total CITY COUNCIL 101-02000 CITY CLERK 101-02000-5000 SUPPLIES & SERVICES 101-02101-5021 OPERATING SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 invoice IN CC339940 210.001/18/2017 Line Description: TRAINING BOOKS FOR MEASURE W C Document Description : GR BROWN ACT TRAINING BOOKS FOR MEASURE101 000432Vendor:LEAGUE OF CA CITIES-PENINSULA Check # 256167 210.00 210.00 0.00101-02101-5021 OPERATING SUPPLIES 0.00 -210.00 0.00 0.00 210.00 210.00 0.00 -210.00 0.00Total CITY CLERK 101-03000 CITY TREASURER 101-03000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total CITY TREASURER 101-04000 CITY ATTORNEY 101-04000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total CITY ATTORNEY 101-05000 CITY MANAGER 101-05000-5000 SUPPLIES & SERVICES 101-05101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 invoice IN 9573 23,273.757/26/2016 Line Description: GROUP 4 MEASURE W - SSF PUC SI Document Description : MEASURE W - SSF PUC SITE ANALYSIS - JUNE101 000355Vendor:GROUP 4 ARCHITECTURE Check # 251946 invoice IN 207994 207.288/2/2016 Line Description: MAYOR AND CM SPEECH TRANSLATIO Document Description : MEASURE W TOWN HALL - SPEECH TRANSLATION101 104394Vendor:PARTNERS IN COMMUNICATION LLC Check # 252111 genjrnl GJ 54495 -23,273.758/31/2016 Line Description: GROUP 4 MEASURE W - SSF PUC SI Document Description : Rcls proj exp 101 genjrnl GJ 54495 -207.288/31/2016 Line Description: MAYOR AND CM SPEECH TRANSLATIO Document Description : Rcls proj exp 101 1Page: ATTACHMENT 4 09/25/2017 CITY OF SOUTH SAN FRANCISCO 2 8:46AM Page:expdetl.rpt Expenditure Detail Report 07/01/2016 through 06/30/2017 Periods: 0 through 16 FY 2016-17 Measure W Expenditures MEASURE W101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used 101-05101-5999 PROJ ACCT SUPPLIES & SCVS (Continued) genjrnl GJ 55023 -23,273.75 8/31/2016 Line Description: GROUP 4 MEASURE W - SSF PUC SI Document Description : RCLS PROJECT/MEAS W EXPENSES 101 genjrnl GJ 55023 -207.28 8/31/2016 Line Description: MAYOR AND CM SPEECH TRANSLATIO Document Description : RCLS PROJECT/MEAS W EXPENSES 101 genjrnl GJ 55703 207.28 8/31/2016 Line Description: Reverse JE 55023 Document Description : REVERSE DUPLICATE JE #55023 101 genjrnl GJ 55703 23,273.75 8/31/2016 Line Description: Reverse JE 55023 Document Description : REVERSE DUPLICATE JE #55023 101 0.00 0.00 0.00 0.00 0.00 0.00Total CITY MANAGER 101-06000 FINANCE DEPARTMENT 101-06000-5000 SUPPLIES & SERVICES 101-06101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total FINANCE DEPARTMENT 101-07000 NON-DEPARTMENTAL 101-07000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total NON-DEPARTMENTAL 101-09000 HUMAN RESOURCES 101-09000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total HUMAN RESOURCES 101-10000 ECONOMIC & COMMUNITY DEVELOPMENT DEPT 101-10000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total ECONOMIC & COMMUNITY DEVELOPMENT DEPT 101-11000 FIRE DEPARTMENT 101-11000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total FIRE DEPARTMENT 101-12000 POLICE DEPARTMENT 101-12000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total POLICE DEPARTMENT 101-13000 PUBLIC WORKS 2Page: 09/25/2017 CITY OF SOUTH SAN FRANCISCO 3 8:46AM Page:expdetl.rpt Expenditure Detail Report 07/01/2016 through 06/30/2017 Periods: 0 through 16 FY 2016-17 Measure W Expenditures MEASURE W101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used 101-13000-5000 SUPPLIES & SERVICES 101-13101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 budadj BA 2017-PO-OPEN 8,750.00 7/1/2016 Line Description: Auto PO Open (0101148)Document Description : AUTO BUDGET ADJUSTMENT (OPENING PO'S)101 budadj BA 2017-PO-OPEN 3,130.15 7/1/2016 Line Description: Auto PO Open (0101324)Document Description : AUTO BUDGET ADJUSTMENT (OPENING PO'S)101 budadj BA 2017-PO-OPEN 1,902.11 7/1/2016 Line Description: Auto PO Open (0101179)Document Description : AUTO BUDGET ADJUSTMENT (OPENING PO'S)101 budadj BA 2017-PO-OPEN 2,295.00 7/1/2016 Line Description: Auto PO Open (0101319)Document Description : AUTO BUDGET ADJUSTMENT (OPENING PO'S)101 budadj BA 2017-PO-OPEN 2,600.00 7/1/2016 Line Description: Auto PO Open (0101321)Document Description : AUTO BUDGET ADJUSTMENT (OPENING PO'S)101 budadj BA 2017-PO-OPEN 157,500.00 7/1/2016 Line Description: Auto PO Open (0101321)Document Description : AUTO BUDGET ADJUSTMENT (OPENING PO'S)101 invoice IN 06/23/16 2,860.00 7/20/2016 Line Description: Ground Penetrating Radar on BA Document Description : GROUND PENETRATING RADAR ON BART TUBE PR101 099369Vendor:EXARO TECHNOLOGIES CORPORATION Check # 251716 invoice IN 1606114 3,520.00 8/16/2016 Line Description: TASK ORDER NO. 2016-2- ALTA SU Document Description : ON CALL SERVICES FOR SURVEYING, MAPPING,101 101112Vendor:SANDIS CIVIL ENG SURVEYORS Check # 252483 genjrnl GJ 54495 -2,860.00 8/31/2016 Line Description: Ground Penetrating Radar on BA Document Description : Rcls proj exp 101 genjrnl GJ 54495 -3,520.00 8/31/2016 Line Description: TASK ORDER NO. 2016-2- ALTA SU Document Description : Rcls proj exp 101 genjrnl GJ 55023 -2,860.00 8/31/2016 Line Description: Ground Penetrating Radar on BA Document Description : RCLS PROJECT/MEAS W EXPENSES 101 genjrnl GJ 55023 -3,520.00 8/31/2016 Line Description: TASK ORDER NO. 2016-2- ALTA SU Document Description : RCLS PROJECT/MEAS W EXPENSES 101 genjrnl GJ 55703 2,860.00 8/31/2016 Line Description: Reverse JE 55023 Document Description : REVERSE DUPLICATE JE #55023 101 genjrnl GJ 55703 3,520.00 8/31/2016 Line Description: Reverse JE 55023 Document Description : REVERSE DUPLICATE JE #55023 101 0.00 0.00 0.00101-13101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 176,177.26 176,177.26 0.00 0.00 0.00 0.00 176,177.26 176,177.26Total PUBLIC WORKS 101-15000 LIBRARY DEPARTMENT 3Page: 09/25/2017 CITY OF SOUTH SAN FRANCISCO 4 8:46AM Page:expdetl.rpt Expenditure Detail Report 07/01/2016 through 06/30/2017 Periods: 0 through 16 FY 2016-17 Measure W Expenditures MEASURE W101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used 101-15000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total LIBRARY DEPARTMENT 101-16000 INFORMATION TECHNOLOGY DEPARTMENT 101-16000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total INFORMATION TECHNOLOGY DEPARTMENT 101-17000 PARKS & RECREATION DEPARTMENT 101-17000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total PARKS & RECREATION DEPARTMENT 101-99000 CIP 101-99000-9000 TRANSFERS 101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV 0.00 0.00 5,500,000.00 0.00 5,500,000.00 0.00 rev alloc GJ pf1707 43,324.429/30/2016 Line Description: Project: pf1707 Allocation Document Description : Project: pf1707 Allocation 101 rev alloc GJ pf1707 60,507.4912/31/2016 Line Description: Project: pf1707 Allocation Document Description : Project: pf1707 Allocation 101 rev alloc GJ pf1707 4,202.0012/31/2016 Line Description: Project: pf1707 Allocation Document Description : Project: pf1707 Allocation 101 rev alloc GJ pf1707 67,188.004/30/2017 Line Description: Project: pf1707 Allocation Document Description : Project: pf1707 Allocation 101 rev alloc GJ st1705 348,125.254/30/2017 Line Description: Project: st1705 Allocation Document Description : Project: st1705 Allocation 101 rev alloc GJ pf1707 113,804.165/31/2017 Line Description: Project: pf1707 Allocation Document Description : Project: pf1707 Allocation 101 rev alloc GJ st1705 1,939.875/31/2017 Line Description: Project: st1705 Allocation Document Description : Project: st1705 Allocation 101 rev alloc GJ pf1707 93,539.546/23/2017 Line Description: Project: pf1707 Allocation Document Description : Project: pf1707 Allocation 101 rev alloc GJ st1702 31,150.006/30/2017 Line Description: Project: st1702 Allocation Document Description : Project: st1702 Allocation 101 rev alloc GJ st1705 113,946.786/30/2017 Line Description: Project: st1705 Allocation Document Description : Project: st1705 Allocation 101 877,727.51 877,727.51 15.96101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV 0.00 4,622,272.49 5,500,000.00 15.96 877,727.51 877,727.51 0.00 4,622,272.49 5,500,000.00Total CIP 4Page: Refer to Project pf1707 Transaction Detail Refer to Project st1702 Transaction Detail Refer to Project st1702 Transaction Detail 09/25/2017 CITY OF SOUTH SAN FRANCISCO 5 8:46AM Page:expdetl.rpt Expenditure Detail Report 07/01/2016 through 06/30/2017 Periods: 0 through 16 FY 2016-17 Measure W Expenditures 15.47 877,937.51 877,937.51 0.00 4,798,239.75 5,676,177.26Total MEASURE W Grand Total 877,937.51 877,937.51 15.47 0.00 4,798,239.75 5,676,177.26 5Page: paTran Project Expense Transaction Detail Report Page:1 9/25/2017 8:56AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #pf1707 COMMUNITY CIVIC CAMPUS Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate Phase #100 PRELIMINARY STUDIES Ground Penetrating Radar on BA E 510-99995-5999 2,860.00 2,860.008/31/2016 54495 GROUP 4 MEASURE W - SSF PUC SI E 510-99995-5999 23,273.75 23,273.758/31/2016 54495 TASK ORDER NO. 2016-2- ALTA SU E 510-99995-5999 3,520.00 3,520.008/31/2016 54495 Ground Penetrating Radar on BA E 510-99995-5999 2,860.00 2,860.008/31/2016 55023 GROUP 4 MEASURE W - SSF PUC SI E 510-99995-5999 23,273.75 23,273.758/31/2016 55023 TASK ORDER NO. 2016-2- ALTA SU E 510-99995-5999 3,520.00 3,520.008/31/2016 55023 Reverse JE 55023 E 510-99995-5999 -23,273.75 -23,273.758/31/2016 55703 Reverse JE 55023 E 510-99995-5999 -2,860.00 -2,860.008/31/2016 55703 Reverse JE 55023 E 510-99995-5999 -3,520.00 -3,520.008/31/2016 55703 Task Order No. 2016-2- Support E 510-99995-5999 13,670.67 13,670.679/27/2016 9624 000355 GROUP 4 ARCHITECTURE Check: 253486 9/28/2016 El Camino Real/Chestnut Specif E 510-99995-5999 2,010.00 2,010.0010/6/2016 8326160 106572 KIMLEY-HORN ASSOCIATES INC Check: 253746 10/7/2016 PROJECT 0622-100 SSF NEW PARCE E 510-99995-5999 4,202.00 4,202.0011/3/2016 20942 000737 WILSEY HAM, INC Check: 256778 2/15/2017 El Camino Real/Chestnut Specif E 510-99995-5999 14,602.50 14,602.5011/21/2016 8394444 106572 KIMLEY-HORN ASSOCIATES INC Check: 255021 12/2/2016 El Camino Real/Chestnut Specif E 510-99995-5999 18,355.00 18,355.0011/21/2016 8482598 106572 KIMLEY-HORN ASSOCIATES INC Check: 254967 11/30/2016 Task Order No. 2016-2- Support E 510-99995-5999 12,831.65 12,831.6511/21/2016 9651 000355 GROUP 4 ARCHITECTURE Check: 255018 12/2/2016 Task Order No. 2016-2- Support E 510-99995-5999 11,979.16 11,979.1612/8/2016 9676 000355 GROUP 4 ARCHITECTURE Check: 256283 1/27/2017 El Camino Real/Chestnut Specif E 510-99995-5999 14,373.47 14,373.473/20/2017 9063750 106572 KIMLEY-HORN ASSOCIATES INC Check: 260158 7/5/2017 ECR/CHESTNUT AVE AREA PLAN E 510-99995-5999 22,670.00 22,670.005/25/2017 970728 105716 MICHAEL BAKER INTL, INC Check: 259222 5/26/2017 ECR/CHESTNUT AVE AREA PLAN E 510-99995-5999 38,944.48 38,944.485/25/2017 973965 105716 MICHAEL BAKER INTL, INC Check: 259222 5/26/2017 ECR/CHESTNUT AVE AREA PLAN E 510-99995-5999 14,125.68 14,125.685/25/2017 977048 105716 MICHAEL BAKER INTL, INC Check: 259222 5/26/2017 Wages E 510-99995-4001 2.00 65.92 65.926/1/2017 LD06/01/2 10901 KARI JUNG 2.00 65.92 Benefits/Contributions E 510-99995-4334 23.33 23.336/1/2017 LD06/01/2 10901 KARI JUNG 23.33 Benefits/Contributions E 510-99995-4331 15.56 15.566/1/2017 PBA6/1/2017 1Page: ATTACHMENT 5 paTran Project Expense Transaction Detail Report Page:2 9/25/2017 8:56AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #pf1707 COMMUNITY CIVIC CAMPUS Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 10901 KARI JUNG 15.56 Benefits/Contributions E 510-99995-4332 6.35 6.356/1/2017 PBA6/1/2017 10901 KARI JUNG 6.35 Benefits/Contributions E 510-99995-4336 0.28 0.286/1/2017 PBA6/1/2017 10901 KARI JUNG 0.28 Benefits/Contributions E 510-99995-4339 1.08 1.086/1/2017 PBA6/1/2017 10901 KARI JUNG 1.08 Task Order No. 2016-2- Support E 510-99995-5999 7,471.30 7,471.306/7/2017 9760 000355 GROUP 4 ARCHITECTURE Check: 259535 6/9/2017 ECR/CHESTNUT AVE AREA PLAN E 510-99995-5999 13,121.25 13,121.256/14/2017 979981 105716 MICHAEL BAKER INTL, INC Check: 259702 6/16/2017 ECR/CHESTNUT AVE AREA PLAN E 510-99995-5999 9,718.75 9,718.756/30/2017 983346 105716 MICHAEL BAKER INTL, INC Check: 260391 7/14/2017 Phase Total:100 PRELIMINARY STUDIES 2.00 65.92 46.60 227,729.66 227,842.18 Phase #110 DESIGN OCA TASK ORDER 2017-1 - CHESTN E 510-99995-5999 6,905.25 6,905.256/30/2017 9524353 106572 KIMLEY-HORN ASSOCIATES INC Check: 260158 7/5/2017 Phase Total:110 DESIGN 0.00 0.00 0.00 6,905.25 6,905.25 Phase #160 PROJECT MANAGEMENT Tax Acrual 9.5%E 100-01110-5045 44.18 44.1810/25/2016 CC335573 100108 AMAZON.COM CREDIT CARD PURCHASE -~E 100-01110-5045 465.0010/25/2016 CC335573 100108 AMAZON.COM Check: 254258 10/28/2016 TELECOMMUNICATIONS ASST / MAIN E 510-99995-5999 220.00 220.0012/8/2016 I2016177 025633 KELSO COMMUNICATIONS Check: 256045 1/18/2017 MEASURE W - PRE-CONSTRUCTION P E 510-99995-5999 39,792.00 39,792.002/17/2017 70763 106730 KITCHELL CEM Check: 256864 2/22/2017 MEASURE W -- PROFESSIONAL SERV E 510-99995-5999 27,396.00 27,396.004/10/2017 71383 106730 KITCHELL CEM Check: 258221 4/19/2017 FY2016-17 APPROVED CONSULTANT E 510-99995-5999 23,153.00 23,153.005/15/2017 71829 106730 KITCHELL CEM Check: 258997 5/19/2017 FY2016-17 APPROVED CONSULTANT E 510-99995-5999 14,911.00 14,911.005/15/2017 72303 106730 KITCHELL CEM Check: 258997 5/19/2017 COMMUNITY CIVIC CAMPUS -- MEAS E 510-99995-5999 700.00 700.005/23/2017 16-WCP-096-2 106245 WATTS, COHN AND PARTNERS, INC Check: 259568 6/9/2017 2Page: paTran Project Expense Transaction Detail Report Page: 3 9/25/2017 8:56AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #pf1707 COMMUNITY CIVIC CAMPUS Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate COMMUNITY CIVIC CAMPUS, KITCHE E 510-99995-5999 19,155.00 19,155.006/14/2017 72759 106730 KITCHELL CEM Check: 259783 6/21/2017 COMMUNITY CIVIC CAMPUS, KITCHE E 510-99995-5999 21,982.00 21,982.006/30/2017 73364 106730 KITCHELL CEM Check: 260833 8/2/2017 Phase Total:160 PROJECT MANAGEMENT 0.00 0.00 0.00 147,353.18 147,818.18 Project Number Total:pf1707 COMMUNITY CIVIC CAMPUS 2.00 65.92 46.60 381,988.09 382,565.61 GRAND TOTAL: 2.00 65.92 46.60 381,988.09 382,565.61 3Page: C C paTran Project Expense Transaction Detail Report Page: 1 9/25/2017 11:22AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1702 UUD RULE 20A ANTOINETTE LN Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate Phase #100 PRELIMINARY STUDIES (13) co#13 OPEN line for Antoi E 510-99999-5999 6,300.00 6,300.006/10/2017 14100038-33 104472 SWINERTON MGMT & CONSULTING Check: 260325 7/12/2017 (13) co#13 OPEN line for Antoi E 510-99999-5999 1,680.00 1,680.006/30/2017 14100038-28 104472 SWINERTON MGMT & CONSULTING Check: 260189 7/5/2017 (13) co#13 OPEN line for Antoi E 510-99999-5999 3,570.00 3,570.006/30/2017 14100038-29 104472 SWINERTON MGMT & CONSULTING Check: 260189 7/5/2017 (13) co#13 OPEN line for Antoi E 510-99999-5999 2,100.00 2,100.006/30/2017 14100038-30 104472 SWINERTON MGMT & CONSULTING Check: 260189 7/5/2017 (13) co#13 OPEN line for Antoi E 510-99999-5999 3,500.00 3,500.006/30/2017 14100038-31 104472 SWINERTON MGMT & CONSULTING Check: 260189 7/5/2017 (13) co#13 OPEN line for Antoi E 510-99999-5999 7,000.00 7,000.006/30/2017 14100038-32 104472 SWINERTON MGMT & CONSULTING Check: 260189 7/5/2017 (13) co#13 OPEN line for Antoi E 510-99999-5999 7,000.00 7,000.006/30/2017 14100038-34 104472 SWINERTON MGMT & CONSULTING Check: 260325 7/12/2017 Phase Total:100 PRELIMINARY STUDIES 0.00 0.00 0.00 31,150.00 31,150.00 Project Number Total:st1702 UUD RULE 20A ANTOINETTE LN 0.00 0.00 0.00 31,150.00 31,150.00 GRAND TOTAL: 0.00 0.00 0.00 31,150.00 31,150.00 1Page: ATTACHMENT 6 D E F G H I J D E F G H I J paTran Project Expense Transaction Detail Report Page:1 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate Phase #110 DESIGN Plans and Specs Printing Servi E 510-99999-5999 105.12 105.128/5/2016 25380 001013 KSM PRINTING Check: 252187 8/5/2016 Wages E 510-99999-4001 48.00 2,469.67 2,469.678/11/2016 LD08/11/2 01700 ROBERT HAHN 22.00 1,499.74 00725 KELVIN MUNAR 26.00 969.93 Benefits/Contributions E 510-99999-4334 881.56 881.568/11/2016 LD08/11/2 01700 ROBERT HAHN 534.51 00725 KELVIN MUNAR 347.05 Benefits/Contributions E 510-99999-4331 373.38 373.388/11/2016 PBA8/11/2016 01700 ROBERT HAHN 171.13 00725 KELVIN MUNAR 202.25 Benefits/Contributions E 510-99999-4332 152.42 152.428/11/2016 PBA8/11/2016 01700 ROBERT HAHN 69.86 00725 KELVIN MUNAR 82.56 Benefits/Contributions E 510-99999-4336 9.19 9.198/11/2016 PBA8/11/2016 01700 ROBERT HAHN 4.21 00725 KELVIN MUNAR 4.98 Benefits/Contributions E 510-99999-4339 26.01 26.018/11/2016 PBA8/11/2016 01700 ROBERT HAHN 11.92 00725 KELVIN MUNAR 14.09 Wages E 510-99999-4001 24.00 1,574.35 1,574.358/25/2016 LD08/25/2 01700 ROBERT HAHN 22.00 1,499.74 00725 KELVIN MUNAR 2.00 74.61 Benefits/Contributions E 510-99999-4334 561.22 561.228/25/2016 LD08/25/2 01700 ROBERT HAHN 534.51 00725 KELVIN MUNAR 26.71 Benefits/Contributions E 510-99999-4331 186.69 186.698/25/2016 PBA8/25/2016 01700 ROBERT HAHN 171.13 00725 KELVIN MUNAR 15.56 Benefits/Contributions E 510-99999-4332 76.21 76.218/25/2016 PBA8/25/2016 1Page: ATTACHMENT 7 paTran Project Expense Transaction Detail Report Page:2 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 69.86 00725 KELVIN MUNAR 6.35 Benefits/Contributions E 510-99999-4336 4.59 4.598/25/2016 PBA8/25/2016 01700 ROBERT HAHN 4.21 00725 KELVIN MUNAR 0.38 Benefits/Contributions E 510-99999-4339 13.00 13.008/25/2016 PBA8/25/2016 01700 ROBERT HAHN 11.92 00725 KELVIN MUNAR 1.08 Wages E 510-99999-4001 29.00 1,598.46 1,598.4610/20/2016 LD10/20/2 01700 ROBERT HAHN 19.00 1,314.66 11073 MICHELLE TRAYER 10.00 283.80 Benefits/Contributions E 510-99999-4331 32.62 32.6210/20/2016 LD10/20/2 11073 MICHELLE TRAYER 32.62 Benefits/Contributions E 510-99999-4334 571.45 571.4510/20/2016 LD10/20/2 01700 ROBERT HAHN 468.58 11073 MICHELLE TRAYER 102.87 Benefits/Contributions E 510-99999-4331 225.59 225.5910/20/2016 PBA10/20/201 01700 ROBERT HAHN 147.80 11073 MICHELLE TRAYER 77.79 Benefits/Contributions E 510-99999-4332 92.08 92.0810/20/2016 PBA10/20/201 01700 ROBERT HAHN 60.33 11073 MICHELLE TRAYER 31.75 Benefits/Contributions E 510-99999-4336 5.05 5.0510/20/2016 PBA10/20/201 01700 ROBERT HAHN 3.64 11073 MICHELLE TRAYER 1.41 Benefits/Contributions E 510-99999-4339 15.71 15.7110/20/2016 PBA10/20/201 01700 ROBERT HAHN 10.29 11073 MICHELLE TRAYER 5.42 Wages E 510-99999-4001 25.00 1,199.26 1,199.2611/3/2016 LD11/03/2 01700 ROBERT HAHN 12.00 830.32 11073 MICHELLE TRAYER 13.00 368.94 Benefits/Contributions E 510-99999-4331 42.40 42.4011/3/2016 LD11/03/2 11073 MICHELLE TRAYER 42.40 2Page: paTran Project Expense Transaction Detail Report Page:3 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate Benefits/Contributions E 510-99999-4334 396.70 396.7011/3/2016 LD11/03/2 01700 ROBERT HAHN 262.97 11073 MICHELLE TRAYER 133.73 Benefits/Contributions E 510-99999-4331 194.48 194.4811/3/2016 PBA11/3/2016 01700 ROBERT HAHN 93.35 11073 MICHELLE TRAYER 101.13 Benefits/Contributions E 510-99999-4332 79.39 79.3911/3/2016 PBA11/3/2016 01700 ROBERT HAHN 38.11 11073 MICHELLE TRAYER 41.28 Benefits/Contributions E 510-99999-4336 4.14 4.1411/3/2016 PBA11/3/2016 01700 ROBERT HAHN 2.30 11073 MICHELLE TRAYER 1.84 Benefits/Contributions E 510-99999-4339 13.54 13.5411/3/2016 PBA11/3/2016 01700 ROBERT HAHN 6.50 11073 MICHELLE TRAYER 7.04 Wages E 510-99999-4001 10.00 691.93 691.9311/17/2016 LD11/17/2 01700 ROBERT HAHN 10.00 691.93 Benefits/Contributions E 510-99999-4334 204.55 204.5511/17/2016 LD11/17/2 01700 ROBERT HAHN 204.55 Benefits/Contributions E 510-99999-4331 77.79 77.7911/17/2016 PBA11/17/201 01700 ROBERT HAHN 77.79 Benefits/Contributions E 510-99999-4332 31.75 31.7511/17/2016 PBA11/17/201 01700 ROBERT HAHN 31.75 Benefits/Contributions E 510-99999-4336 1.91 1.9111/17/2016 PBA11/17/201 01700 ROBERT HAHN 1.91 Benefits/Contributions E 510-99999-4339 5.42 5.4211/17/2016 PBA11/17/201 01700 ROBERT HAHN 5.42 Wages E 510-99999-4001 16.00 1,028.30 1,028.3012/1/2016 LD12/01/2 01700 ROBERT HAHN 14.00 968.70 11073 MICHELLE TRAYER 2.00 59.60 Benefits/Contributions E 510-99999-4331 6.51 6.5112/1/2016 LD12/01/2 11073 MICHELLE TRAYER 6.51 Benefits/Contributions E 510-99999-4334 307.94 307.9412/1/2016 LD12/01/2 3Page: paTran Project Expense Transaction Detail Report Page:4 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 286.36 11073 MICHELLE TRAYER 21.58 Benefits/Contributions E 510-99999-4331 124.46 124.4612/1/2016 PBA12/1/2016 01700 ROBERT HAHN 108.90 11073 MICHELLE TRAYER 15.56 Benefits/Contributions E 510-99999-4332 50.81 50.8112/1/2016 PBA12/1/2016 01700 ROBERT HAHN 44.46 11073 MICHELLE TRAYER 6.35 Benefits/Contributions E 510-99999-4336 2.96 2.9612/1/2016 PBA12/1/2016 01700 ROBERT HAHN 2.68 11073 MICHELLE TRAYER 0.28 Benefits/Contributions E 510-99999-4339 8.67 8.6712/1/2016 PBA12/1/2016 01700 ROBERT HAHN 7.59 11073 MICHELLE TRAYER 1.08 Wages E 510-99999-4001 20.00 1,383.85 1,383.8512/15/2016 LD12/15/2 01700 ROBERT HAHN 20.00 1,383.85 Benefits/Contributions E 510-99999-4334 409.08 409.0812/15/2016 LD12/15/2 01700 ROBERT HAHN 409.08 Benefits/Contributions E 510-99999-4331 155.58 155.5812/15/2016 PBA12/15/201 01700 ROBERT HAHN 155.58 Benefits/Contributions E 510-99999-4332 63.51 63.5112/15/2016 PBA12/15/201 01700 ROBERT HAHN 63.51 Benefits/Contributions E 510-99999-4336 3.83 3.8312/15/2016 PBA12/15/201 01700 ROBERT HAHN 3.83 Benefits/Contributions E 510-99999-4339 10.84 10.8412/15/2016 PBA12/15/201 01700 ROBERT HAHN 10.84 Wages E 510-99999-4001 22.00 1,522.24 1,522.2412/29/2016 LD12/29/2 01700 ROBERT HAHN 22.00 1,522.24 Benefits/Contributions E 510-99999-4334 542.57 542.5712/29/2016 LD12/29/2 01700 ROBERT HAHN 542.57 Benefits/Contributions E 510-99999-4331 171.13 171.1312/29/2016 PBA12/29/201 01700 ROBERT HAHN 171.13 Benefits/Contributions E 510-99999-4332 69.86 69.8612/29/2016 PBA12/29/201 4Page: paTran Project Expense Transaction Detail Report Page:5 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 69.86 Benefits/Contributions E 510-99999-4336 4.21 4.2112/29/2016 PBA12/29/201 01700 ROBERT HAHN 4.21 Benefits/Contributions E 510-99999-4339 11.92 11.9212/29/2016 PBA12/29/201 01700 ROBERT HAHN 11.92 Wages E 510-99999-4001 10.00 691.93 691.931/12/2017 LD01/12/2 01700 ROBERT HAHN 10.00 691.93 Benefits/Contributions E 510-99999-4334 246.62 246.621/12/2017 LD01/12/2 01700 ROBERT HAHN 246.62 Benefits/Contributions E 510-99999-4331 77.79 77.791/12/2017 PBA1/12/2017 01700 ROBERT HAHN 77.79 Benefits/Contributions E 510-99999-4332 31.75 31.751/12/2017 PBA1/12/2017 01700 ROBERT HAHN 31.75 Benefits/Contributions E 510-99999-4336 1.91 1.911/12/2017 PBA1/12/2017 01700 ROBERT HAHN 1.91 Benefits/Contributions E 510-99999-4339 5.42 5.421/12/2017 PBA1/12/2017 01700 ROBERT HAHN 5.42 Wages E 510-99999-4001 23.00 1,394.47 1,394.471/26/2017 LD01/26/2 01700 ROBERT HAHN 18.00 1,245.47 11073 MICHELLE TRAYER 5.00 149.00 Benefits/Contributions E 510-99999-4331 16.29 16.291/26/2017 LD01/26/2 11073 MICHELLE TRAYER 16.29 Benefits/Contributions E 510-99999-4334 497.87 497.871/26/2017 LD01/26/2 01700 ROBERT HAHN 443.92 11073 MICHELLE TRAYER 53.95 Benefits/Contributions E 510-99999-4331 178.91 178.911/26/2017 PBA1/26/2017 01700 ROBERT HAHN 140.02 11073 MICHELLE TRAYER 38.89 Benefits/Contributions E 510-99999-4332 73.04 73.041/26/2017 PBA1/26/2017 01700 ROBERT HAHN 57.16 11073 MICHELLE TRAYER 15.88 Benefits/Contributions E 510-99999-4336 4.15 4.151/26/2017 PBA1/26/2017 5Page: paTran Project Expense Transaction Detail Report Page:6 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 3.44 11073 MICHELLE TRAYER 0.71 Benefits/Contributions E 510-99999-4339 12.46 12.461/26/2017 PBA1/26/2017 01700 ROBERT HAHN 9.75 11073 MICHELLE TRAYER 2.71 Wages E 510-99999-4001 30.00 1,681.85 1,681.852/9/2017 LD02/09/2 01700 ROBERT HAHN 20.00 1,383.85 11073 MICHELLE TRAYER 10.00 298.00 Benefits/Contributions E 510-99999-4331 32.57 32.572/9/2017 LD02/09/2 11073 MICHELLE TRAYER 32.57 Benefits/Contributions E 510-99999-4334 601.13 601.132/9/2017 LD02/09/2 01700 ROBERT HAHN 493.22 11073 MICHELLE TRAYER 107.91 Benefits/Contributions E 510-99999-4331 233.37 233.372/9/2017 PBA2/9/2017 01700 ROBERT HAHN 155.58 11073 MICHELLE TRAYER 77.79 Benefits/Contributions E 510-99999-4332 95.26 95.262/9/2017 PBA2/9/2017 01700 ROBERT HAHN 63.51 11073 MICHELLE TRAYER 31.75 Benefits/Contributions E 510-99999-4336 5.24 5.242/9/2017 PBA2/9/2017 01700 ROBERT HAHN 3.83 11073 MICHELLE TRAYER 1.41 Benefits/Contributions E 510-99999-4339 16.26 16.262/9/2017 PBA2/9/2017 01700 ROBERT HAHN 10.84 11073 MICHELLE TRAYER 5.42 PAVEMENT MGT. TECHNICAL ASSIST E 510-99999-5999 8,400.00 8,400.002/14/2017 AR013086 022409 METROPOLITAN TRANS COMMISSION Check: 256718 2/15/2017 Wages E 510-99999-4001 32.50 1,764.25 1,764.252/23/2017 LD02/23/2 01700 ROBERT HAHN 20.00 1,383.85 10901 KARI JUNG 2.50 82.40 11073 MICHELLE TRAYER 10.00 298.00 Benefits/Contributions E 510-99999-4331 32.57 32.572/23/2017 LD02/23/2 11073 MICHELLE TRAYER 32.57 6Page: paTran Project Expense Transaction Detail Report Page:7 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate Benefits/Contributions E 510-99999-4334 630.30 630.302/23/2017 LD02/23/2 01700 ROBERT HAHN 493.23 10901 KARI JUNG 29.16 11073 MICHELLE TRAYER 107.91 Benefits/Contributions E 510-99999-4331 252.82 252.822/23/2017 PBA2/23/2017 01700 ROBERT HAHN 155.58 10901 KARI JUNG 19.45 11073 MICHELLE TRAYER 77.79 Benefits/Contributions E 510-99999-4332 103.20 103.202/23/2017 PBA2/23/2017 01700 ROBERT HAHN 63.51 10901 KARI JUNG 7.94 11073 MICHELLE TRAYER 31.75 Benefits/Contributions E 510-99999-4336 5.59 5.592/23/2017 PBA2/23/2017 01700 ROBERT HAHN 3.83 10901 KARI JUNG 0.35 11073 MICHELLE TRAYER 1.41 Benefits/Contributions E 510-99999-4339 17.61 17.612/23/2017 PBA2/23/2017 01700 ROBERT HAHN 10.84 10901 KARI JUNG 1.35 11073 MICHELLE TRAYER 5.42 Wages E 510-99999-4001 43.00 2,393.88 2,393.883/9/2017 LD03/09/2 01700 ROBERT HAHN 28.00 1,937.40 10901 KARI JUNG 3.00 98.88 11073 MICHELLE TRAYER 12.00 357.60 Benefits/Contributions E 510-99999-4331 39.09 39.093/9/2017 LD03/09/2 11073 MICHELLE TRAYER 39.09 Benefits/Contributions E 510-99999-4334 855.02 855.023/9/2017 LD03/09/2 01700 ROBERT HAHN 690.54 10901 KARI JUNG 34.99 11073 MICHELLE TRAYER 129.49 Benefits/Contributions E 510-99999-4331 334.50 334.503/9/2017 PBA3/9/2017 7Page: paTran Project Expense Transaction Detail Report Page:8 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 217.81 10901 KARI JUNG 23.34 11073 MICHELLE TRAYER 93.35 Benefits/Contributions E 510-99999-4332 136.55 136.553/9/2017 PBA3/9/2017 01700 ROBERT HAHN 88.91 10901 KARI JUNG 9.53 11073 MICHELLE TRAYER 38.11 Benefits/Contributions E 510-99999-4336 7.48 7.483/9/2017 PBA3/9/2017 01700 ROBERT HAHN 5.36 10901 KARI JUNG 0.42 11073 MICHELLE TRAYER 1.70 Benefits/Contributions E 510-99999-4339 23.30 23.303/9/2017 PBA3/9/2017 01700 ROBERT HAHN 15.17 10901 KARI JUNG 1.63 11073 MICHELLE TRAYER 6.50 Professional Services for Stre E 510-99999-5999 492.50 492.503/17/2017 872015504 106415 NCE Check: 257528 3/22/2017 2017 Local Streets and Roads A E 510-99999-5999 400.00 400.003/22/2017 103920 000432 LEAGUE OF CA CITIES-PENINSULA Check: 257704 3/29/2017 Wages E 510-99999-4001 27.00 1,795.74 1,795.743/23/2017 LD03/23/2 01700 ROBERT HAHN 25.00 1,729.82 10901 KARI JUNG 2.00 65.92 Benefits/Contributions E 510-99999-4334 642.91 642.913/23/2017 LD03/23/2 01700 ROBERT HAHN 619.08 10901 KARI JUNG 23.83 Benefits/Contributions E 510-99999-4331 210.03 210.033/23/2017 PBA3/23/2017 01700 ROBERT HAHN 194.47 10901 KARI JUNG 15.56 Benefits/Contributions E 510-99999-4332 85.74 85.743/23/2017 PBA3/23/2017 01700 ROBERT HAHN 79.39 10901 KARI JUNG 6.35 Benefits/Contributions E 510-99999-4336 5.06 5.063/23/2017 PBA3/23/2017 8Page: paTran Project Expense Transaction Detail Report Page:9 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 4.78 10901 KARI JUNG 0.28 Benefits/Contributions E 510-99999-4339 14.63 14.633/23/2017 PBA3/23/2017 01700 ROBERT HAHN 13.55 10901 KARI JUNG 1.08 Wages E 510-99999-4001 32.00 1,672.15 1,672.154/6/2017 LD04/06/2 01700 ROBERT HAHN 18.00 1,245.47 10901 KARI JUNG 3.00 98.88 11073 MICHELLE TRAYER 11.00 327.80 Benefits/Contributions E 510-99999-4331 35.83 35.834/6/2017 LD04/06/2 11073 MICHELLE TRAYER 35.83 Benefits/Contributions E 510-99999-4334 597.60 597.604/6/2017 LD04/06/2 01700 ROBERT HAHN 443.92 10901 KARI JUNG 34.99 11073 MICHELLE TRAYER 118.69 Benefits/Contributions E 510-99999-4331 248.93 248.934/6/2017 PBA4/6/2017 01700 ROBERT HAHN 140.02 10901 KARI JUNG 23.34 11073 MICHELLE TRAYER 85.57 Benefits/Contributions E 510-99999-4332 101.62 101.624/6/2017 PBA4/6/2017 01700 ROBERT HAHN 57.16 10901 KARI JUNG 9.53 11073 MICHELLE TRAYER 34.93 Benefits/Contributions E 510-99999-4336 5.41 5.414/6/2017 PBA4/6/2017 01700 ROBERT HAHN 3.44 10901 KARI JUNG 0.42 11073 MICHELLE TRAYER 1.55 Benefits/Contributions E 510-99999-4339 17.34 17.344/6/2017 PBA4/6/2017 01700 ROBERT HAHN 9.75 10901 KARI JUNG 1.63 11073 MICHELLE TRAYER 5.96 Wages E 510-99999-4001 15.00 1,037.89 1,037.894/20/2017 LD04/20/2 9Page: paTran Project Expense Transaction Detail Report Page:10 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 15.00 1,037.89 Benefits/Contributions E 510-99999-4334 370.05 370.054/20/2017 LD04/20/2 01700 ROBERT HAHN 370.05 Benefits/Contributions E 510-99999-4331 116.68 116.684/20/2017 PBA4/20/2017 01700 ROBERT HAHN 116.68 Benefits/Contributions E 510-99999-4332 47.63 47.634/20/2017 PBA4/20/2017 01700 ROBERT HAHN 47.63 Benefits/Contributions E 510-99999-4336 2.87 2.874/20/2017 PBA4/20/2017 01700 ROBERT HAHN 2.87 Benefits/Contributions E 510-99999-4339 8.13 8.134/20/2017 PBA4/20/2017 01700 ROBERT HAHN 8.13 Wages E 510-99999-4001 14.00 968.70 968.705/4/2017 LD05/04/2 01700 ROBERT HAHN 14.00 968.70 Benefits/Contributions E 510-99999-4334 345.26 345.265/4/2017 LD05/04/2 01700 ROBERT HAHN 345.26 Benefits/Contributions E 510-99999-4331 108.90 108.905/4/2017 PBA5/4/2017 01700 ROBERT HAHN 108.90 Benefits/Contributions E 510-99999-4332 44.46 44.465/4/2017 PBA5/4/2017 01700 ROBERT HAHN 44.46 Benefits/Contributions E 510-99999-4336 2.68 2.685/4/2017 PBA5/4/2017 01700 ROBERT HAHN 2.68 Benefits/Contributions E 510-99999-4339 7.59 7.595/4/2017 PBA5/4/2017 01700 ROBERT HAHN 7.59 Wages E 510-99999-4001 14.00 968.70 968.705/18/2017 LD05/18/2 01700 ROBERT HAHN 14.00 968.70 Benefits/Contributions E 510-99999-4334 345.26 345.265/18/2017 LD05/18/2 01700 ROBERT HAHN 345.26 Benefits/Contributions E 510-99999-4331 108.90 108.905/18/2017 PBA5/18/2017 01700 ROBERT HAHN 108.90 Benefits/Contributions E 510-99999-4332 44.46 44.465/18/2017 PBA5/18/2017 01700 ROBERT HAHN 44.46 Benefits/Contributions E 510-99999-4336 2.68 2.685/18/2017 PBA5/18/2017 01700 ROBERT HAHN 2.68 Benefits/Contributions E 510-99999-4339 7.59 7.595/18/2017 PBA5/18/2017 10Page: paTran Project Expense Transaction Detail Report Page: 11 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 7.59 Task Order 2017-1 for 2016 Str E 510-99999-5999 1,939.87 1,939.875/19/2017 21366 000737 WILSEY HAM, INC Check: 259041 5/19/2017 Wages E 510-99999-4001 10.00 691.93 691.936/1/2017 LD06/01/2 01700 ROBERT HAHN 10.00 691.93 Benefits/Contributions E 510-99999-4334 246.62 246.626/1/2017 LD06/01/2 01700 ROBERT HAHN 246.62 Benefits/Contributions E 510-99999-4331 77.79 77.796/1/2017 PBA6/1/2017 01700 ROBERT HAHN 77.79 Benefits/Contributions E 510-99999-4332 31.75 31.756/1/2017 PBA6/1/2017 01700 ROBERT HAHN 31.75 Benefits/Contributions E 510-99999-4336 1.91 1.916/1/2017 PBA6/1/2017 01700 ROBERT HAHN 1.91 Benefits/Contributions E 510-99999-4339 5.42 5.426/1/2017 PBA6/1/2017 01700 ROBERT HAHN 5.42 Task Order 2017-1 for 2016 Str E 510-99999-5999 902.96 902.966/8/2017 21415a 000737 WILSEY HAM, INC Check: 259670 6/14/2017 Professional Services Rendered E 510-99999-5999 420.00 420.006/15/2017 872015505 106415 NCE Check: 259705 6/16/2017 Wages E 510-99999-4001 12.00 830.31 830.316/15/2017 LD06/15/2 01700 ROBERT HAHN 12.00 830.31 Benefits/Contributions E 510-99999-4334 295.93 295.936/15/2017 LD06/15/2 01700 ROBERT HAHN 295.93 Benefits/Contributions E 510-99999-4331 93.35 93.356/15/2017 PBA6/15/2017 01700 ROBERT HAHN 93.35 Benefits/Contributions E 510-99999-4332 38.11 38.116/15/2017 PBA6/15/2017 01700 ROBERT HAHN 38.11 Benefits/Contributions E 510-99999-4336 2.30 2.306/15/2017 PBA6/15/2017 01700 ROBERT HAHN 2.30 Benefits/Contributions E 510-99999-4339 6.50 6.506/15/2017 PBA6/15/2017 01700 ROBERT HAHN 6.50 Task Order 2017-4, Roadway and E 510-99999-5999 35,975.00 35,975.006/28/2017 0063983 000273 DKS ASSOCIATES Check: 260631 7/26/2017 Wages E 510-99999-4001 16.00 1,107.08 1,107.086/29/2017 LD06/29/2 11Page: K paTran Project Expense Transaction Detail Report Page: 12 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 16.00 1,107.08 Benefits/Contributions E 510-99999-4334 394.50 394.506/29/2017 LD06/29/2 01700 ROBERT HAHN 394.50 Benefits/Contributions E 510-99999-4331 124.46 124.466/29/2017 PBA6/29/2017 01700 ROBERT HAHN 124.46 Benefits/Contributions E 510-99999-4332 50.81 50.816/29/2017 PBA6/29/2017 01700 ROBERT HAHN 50.81 Benefits/Contributions E 510-99999-4336 3.06 3.066/29/2017 PBA6/29/2017 01700 ROBERT HAHN 3.06 Benefits/Contributions E 510-99999-4339 8.67 8.676/29/2017 PBA6/29/2017 01700 ROBERT HAHN 8.67 Printing Services- Plans, Spec E 510-99999-5999 328.62 328.626/30/2017 144084 000606 ROZZI REPRODUCTION & SUPPLY IN Check: 260111 6/30/2017 Task Order 2017-1 for 2016 Str E 510-99999-5999 33,750.20 33,750.206/30/2017 21506 000737 WILSEY HAM, INC Check: 260740 7/26/2017 Wages E 510-99999-4001 1.90 135.42 135.426/30/2017 LD06/30/2 01700 ROBERT HAHN 1.90 135.42 Benefits/Contributions E 510-99999-4334 23.06 23.066/30/2017 LD06/30/2 01700 ROBERT HAHN 23.06 Benefits/Contributions E 510-99999-4331 14.78 14.786/30/2017 PBA6/30/2017 01700 ROBERT HAHN 14.78 Benefits/Contributions E 510-99999-4332 6.03 6.036/30/2017 PBA6/30/2017 01700 ROBERT HAHN 6.03 Benefits/Contributions E 510-99999-4336 0.36 0.366/30/2017 PBA6/30/2017 01700 ROBERT HAHN 0.36 Benefits/Contributions E 510-99999-4339 1.03 1.036/30/2017 PBA6/30/2017 01700 ROBERT HAHN 1.03 Phase Total:110 DESIGN 474.40 28,602.36 15,745.47 82,714.27 127,062.10 Phase #120 CONSTRUCTION Classified Advertising; San Ma E 510-99999-5999 568.98 568.989/7/2016 0000996118 027869 CALIFORNIA NEWSPAPER PARTNERS Check: 253014 9/9/2016 Wages E 510-99999-4001 32.00 2,068.76 2,068.769/8/2016 LD09/08/2 12Page: L paTran Project Expense Transaction Detail Report Page:13 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 28.00 1,937.39 00725 KELVIN MUNAR 2.00 74.61 11073 MICHELLE TRAYER 2.00 56.76 Benefits/Contributions E 510-99999-4331 6.52 6.529/8/2016 LD09/08/2 11073 MICHELLE TRAYER 6.52 Benefits/Contributions E 510-99999-4334 736.91 736.919/8/2016 LD09/08/2 01700 ROBERT HAHN 689.64 00725 KELVIN MUNAR 26.70 11073 MICHELLE TRAYER 20.57 Benefits/Contributions E 510-99999-4331 248.93 248.939/8/2016 PBA9/8/2016 01700 ROBERT HAHN 217.81 00725 KELVIN MUNAR 15.56 11073 MICHELLE TRAYER 15.56 Benefits/Contributions E 510-99999-4332 101.61 101.619/8/2016 PBA9/8/2016 01700 ROBERT HAHN 88.91 00725 KELVIN MUNAR 6.35 11073 MICHELLE TRAYER 6.35 Benefits/Contributions E 510-99999-4336 6.02 6.029/8/2016 PBA9/8/2016 01700 ROBERT HAHN 5.36 00725 KELVIN MUNAR 0.38 11073 MICHELLE TRAYER 0.28 Benefits/Contributions E 510-99999-4339 17.33 17.339/8/2016 PBA9/8/2016 01700 ROBERT HAHN 15.17 00725 KELVIN MUNAR 1.08 11073 MICHELLE TRAYER 1.08 Wages E 510-99999-4001 36.00 2,288.86 2,288.869/22/2016 LD09/22/2 01700 ROBERT HAHN 30.00 2,075.77 00725 KELVIN MUNAR 2.00 74.61 01047 HEATHER RUIZ 4.00 138.48 Benefits/Contributions E 510-99999-4334 820.10 820.109/22/2016 LD09/22/2 13Page: paTran Project Expense Transaction Detail Report Page:14 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 742.89 00725 KELVIN MUNAR 26.94 01047 HEATHER RUIZ 50.27 Benefits/Contributions E 510-99999-4331 280.05 280.059/22/2016 PBA9/22/2016 01700 ROBERT HAHN 233.37 00725 KELVIN MUNAR 15.56 01047 HEATHER RUIZ 31.12 Benefits/Contributions E 510-99999-4332 114.31 114.319/22/2016 PBA9/22/2016 01700 ROBERT HAHN 95.26 00725 KELVIN MUNAR 6.35 01047 HEATHER RUIZ 12.70 Benefits/Contributions E 510-99999-4336 6.69 6.699/22/2016 PBA9/22/2016 01700 ROBERT HAHN 5.74 00725 KELVIN MUNAR 0.38 01047 HEATHER RUIZ 0.57 Benefits/Contributions E 510-99999-4339 19.50 19.509/22/2016 PBA9/22/2016 01700 ROBERT HAHN 16.25 00725 KELVIN MUNAR 1.08 01047 HEATHER RUIZ 2.17 Wages E 510-99999-4001 22.00 1,251.03 1,251.0310/6/2016 LD10/06/2 01700 ROBERT HAHN 14.00 968.70 00725 KELVIN MUNAR 2.00 74.61 01047 HEATHER RUIZ 6.00 207.72 Benefits/Contributions E 510-99999-4334 447.89 447.8910/6/2016 LD10/06/2 01700 ROBERT HAHN 345.26 00725 KELVIN MUNAR 26.74 01047 HEATHER RUIZ 75.89 Benefits/Contributions E 510-99999-4331 171.13 171.1310/6/2016 PBA10/6/2016 01700 ROBERT HAHN 108.90 00725 KELVIN MUNAR 15.56 01047 HEATHER RUIZ 46.67 Benefits/Contributions E 510-99999-4332 69.86 69.8610/6/2016 PBA10/6/2016 14Page: paTran Project Expense Transaction Detail Report Page:15 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 44.46 00725 KELVIN MUNAR 6.35 01047 HEATHER RUIZ 19.05 Benefits/Contributions E 510-99999-4336 3.91 3.9110/6/2016 PBA10/6/2016 01700 ROBERT HAHN 2.68 00725 KELVIN MUNAR 0.38 01047 HEATHER RUIZ 0.85 Benefits/Contributions E 510-99999-4339 11.92 11.9210/6/2016 PBA10/6/2016 01700 ROBERT HAHN 7.59 00725 KELVIN MUNAR 1.08 01047 HEATHER RUIZ 3.25 Wages E 510-99999-4001 5.00 141.90 141.9011/17/2016 LD11/17/2 11073 MICHELLE TRAYER 5.00 141.90 Benefits/Contributions E 510-99999-4331 16.31 16.3111/17/2016 LD11/17/2 11073 MICHELLE TRAYER 16.31 Benefits/Contributions E 510-99999-4334 51.44 51.4411/17/2016 LD11/17/2 11073 MICHELLE TRAYER 51.44 Benefits/Contributions E 510-99999-4331 38.89 38.8911/17/2016 PBA11/17/201 11073 MICHELLE TRAYER 38.89 Benefits/Contributions E 510-99999-4332 15.88 15.8811/17/2016 PBA11/17/201 11073 MICHELLE TRAYER 15.88 Benefits/Contributions E 510-99999-4336 0.71 0.7111/17/2016 PBA11/17/201 11073 MICHELLE TRAYER 0.71 Benefits/Contributions E 510-99999-4339 2.71 2.7111/17/2016 PBA11/17/201 11073 MICHELLE TRAYER 2.71 Wages E 510-99999-4001 8.00 253.41 253.4112/15/2016 LD12/15/2 00725 KELVIN MUNAR 2.00 74.61 11073 MICHELLE TRAYER 6.00 178.80 Benefits/Contributions E 510-99999-4331 19.54 19.5412/15/2016 LD12/15/2 11073 MICHELLE TRAYER 19.54 Benefits/Contributions E 510-99999-4334 91.44 91.4412/15/2016 LD12/15/2 00725 KELVIN MUNAR 26.70 11073 MICHELLE TRAYER 64.74 15Page: paTran Project Expense Transaction Detail Report Page:16 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate Benefits/Contributions E 510-99999-4331 62.23 62.2312/15/2016 PBA12/15/201 00725 KELVIN MUNAR 15.56 11073 MICHELLE TRAYER 46.67 Benefits/Contributions E 510-99999-4332 25.40 25.4012/15/2016 PBA12/15/201 00725 KELVIN MUNAR 6.35 11073 MICHELLE TRAYER 19.05 Benefits/Contributions E 510-99999-4336 1.23 1.2312/15/2016 PBA12/15/201 00725 KELVIN MUNAR 0.38 11073 MICHELLE TRAYER 0.85 Benefits/Contributions E 510-99999-4339 4.33 4.3312/15/2016 PBA12/15/201 00725 KELVIN MUNAR 1.08 11073 MICHELLE TRAYER 3.25 Wages E 510-99999-4001 16.00 476.80 476.8012/29/2016 LD12/29/2 11073 MICHELLE TRAYER 16.00 476.80 Benefits/Contributions E 510-99999-4331 52.12 52.1212/29/2016 LD12/29/2 11073 MICHELLE TRAYER 52.12 Benefits/Contributions E 510-99999-4334 172.64 172.6412/29/2016 LD12/29/2 11073 MICHELLE TRAYER 172.64 Benefits/Contributions E 510-99999-4331 124.46 124.4612/29/2016 PBA12/29/201 11073 MICHELLE TRAYER 124.46 Benefits/Contributions E 510-99999-4332 50.81 50.8112/29/2016 PBA12/29/201 11073 MICHELLE TRAYER 50.81 Benefits/Contributions E 510-99999-4336 2.26 2.2612/29/2016 PBA12/29/201 11073 MICHELLE TRAYER 2.26 Benefits/Contributions E 510-99999-4339 8.67 8.6712/29/2016 PBA12/29/201 11073 MICHELLE TRAYER 8.67 Wages E 510-99999-4001 11.00 327.80 327.801/12/2017 LD01/12/2 11073 MICHELLE TRAYER 11.00 327.80 Benefits/Contributions E 510-99999-4331 35.83 35.831/12/2017 LD01/12/2 11073 MICHELLE TRAYER 35.83 Benefits/Contributions E 510-99999-4334 118.69 118.691/12/2017 LD01/12/2 11073 MICHELLE TRAYER 118.69 Benefits/Contributions E 510-99999-4331 85.57 85.571/12/2017 PBA1/12/2017 16Page: paTran Project Expense Transaction Detail Report Page:17 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 11073 MICHELLE TRAYER 85.57 Benefits/Contributions E 510-99999-4332 34.93 34.931/12/2017 PBA1/12/2017 11073 MICHELLE TRAYER 34.93 Benefits/Contributions E 510-99999-4336 1.55 1.551/12/2017 PBA1/12/2017 11073 MICHELLE TRAYER 1.55 Benefits/Contributions E 510-99999-4339 5.96 5.961/12/2017 PBA1/12/2017 11073 MICHELLE TRAYER 5.96 Task Order 2016-4 Geotechnical E 510-99999-5999 11,500.00 11,500.002/13/2017 203039 104960 NINYO AND MOORE GEOTECHNICAL Check: 256725 2/15/2017 Minor Construction Agreement f E 510-99999-5999 25,950.00 25,950.003/15/2017 5066 000391 INTERSTATE GRADING & PAVING IN Check: 257395 3/16/2017 Wages E 510-99999-4001 15.00 447.00 447.003/23/2017 LD03/23/2 11073 MICHELLE TRAYER 15.00 447.00 Benefits/Contributions E 510-99999-4331 48.86 48.863/23/2017 LD03/23/2 11073 MICHELLE TRAYER 48.86 Benefits/Contributions E 510-99999-4334 161.85 161.853/23/2017 LD03/23/2 11073 MICHELLE TRAYER 161.85 Benefits/Contributions E 510-99999-4331 116.68 116.683/23/2017 PBA3/23/2017 11073 MICHELLE TRAYER 116.68 Benefits/Contributions E 510-99999-4332 47.63 47.633/23/2017 PBA3/23/2017 11073 MICHELLE TRAYER 47.63 Benefits/Contributions E 510-99999-4336 2.12 2.123/23/2017 PBA3/23/2017 11073 MICHELLE TRAYER 2.12 Benefits/Contributions E 510-99999-4339 8.13 8.133/23/2017 PBA3/23/2017 11073 MICHELLE TRAYER 8.13 CONSTRUCTION OF 2016 ADA RAMPS E 510-99999-5999 301,382.75 301,382.753/31/2017 9036 106802 GOLDEN BAY CONSTRUCTION, INC Check: 257787 3/31/2017 Wages E 510-99999-4001 11.00 761.12 761.124/6/2017 LD04/06/2 01700 ROBERT HAHN 11.00 761.12 Benefits/Contributions E 510-99999-4334 271.28 271.284/6/2017 LD04/06/2 01700 ROBERT HAHN 271.28 Benefits/Contributions E 510-99999-4331 85.57 85.574/6/2017 PBA4/6/2017 01700 ROBERT HAHN 85.57 Benefits/Contributions E 510-99999-4332 34.93 34.934/6/2017 PBA4/6/2017 17Page: paTran Project Expense Transaction Detail Report Page:18 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 34.93 Benefits/Contributions E 510-99999-4336 2.10 2.104/6/2017 PBA4/6/2017 01700 ROBERT HAHN 2.10 Benefits/Contributions E 510-99999-4339 5.96 5.964/6/2017 PBA4/6/2017 01700 ROBERT HAHN 5.96 Wages E 510-99999-4001 18.00 1,173.00 1,173.004/20/2017 LD04/20/2 01700 ROBERT HAHN 16.00 1,107.08 10901 KARI JUNG 2.00 65.92 Benefits/Contributions E 510-99999-4334 418.05 418.054/20/2017 LD04/20/2 01700 ROBERT HAHN 394.72 10901 KARI JUNG 23.33 Benefits/Contributions E 510-99999-4331 140.02 140.024/20/2017 PBA4/20/2017 01700 ROBERT HAHN 124.46 10901 KARI JUNG 15.56 Benefits/Contributions E 510-99999-4332 57.16 57.164/20/2017 PBA4/20/2017 01700 ROBERT HAHN 50.81 10901 KARI JUNG 6.35 Benefits/Contributions E 510-99999-4336 3.34 3.344/20/2017 PBA4/20/2017 01700 ROBERT HAHN 3.06 10901 KARI JUNG 0.28 Benefits/Contributions E 510-99999-4339 9.75 9.754/20/2017 PBA4/20/2017 01700 ROBERT HAHN 8.67 10901 KARI JUNG 1.08 Wages E 510-99999-4001 20.50 1,255.40 1,255.405/4/2017 LD05/04/2 01700 ROBERT HAHN 16.00 1,107.08 10901 KARI JUNG 4.50 148.32 Benefits/Contributions E 510-99999-4334 447.05 447.055/4/2017 LD05/04/2 01700 ROBERT HAHN 394.57 10901 KARI JUNG 52.48 Benefits/Contributions E 510-99999-4331 159.46 159.465/4/2017 PBA5/4/2017 01700 ROBERT HAHN 124.46 10901 KARI JUNG 35.00 Benefits/Contributions E 510-99999-4332 65.10 65.105/4/2017 PBA5/4/2017 18Page: paTran Project Expense Transaction Detail Report Page:19 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 50.81 10901 KARI JUNG 14.29 Benefits/Contributions E 510-99999-4336 3.70 3.705/4/2017 PBA5/4/2017 01700 ROBERT HAHN 3.06 10901 KARI JUNG 0.64 Benefits/Contributions E 510-99999-4339 11.11 11.115/4/2017 PBA5/4/2017 01700 ROBERT HAHN 8.67 10901 KARI JUNG 2.44 Wages E 510-99999-4001 12.00 757.85 757.855/18/2017 LD05/18/2 01700 ROBERT HAHN 10.00 691.93 10901 KARI JUNG 2.00 65.92 Benefits/Contributions E 510-99999-4334 269.95 269.955/18/2017 LD05/18/2 01700 ROBERT HAHN 246.62 10901 KARI JUNG 23.33 Benefits/Contributions E 510-99999-4331 93.35 93.355/18/2017 PBA5/18/2017 01700 ROBERT HAHN 77.79 10901 KARI JUNG 15.56 Benefits/Contributions E 510-99999-4332 38.10 38.105/18/2017 PBA5/18/2017 01700 ROBERT HAHN 31.75 10901 KARI JUNG 6.35 Benefits/Contributions E 510-99999-4336 2.19 2.195/18/2017 PBA5/18/2017 01700 ROBERT HAHN 1.91 10901 KARI JUNG 0.28 Benefits/Contributions E 510-99999-4339 6.50 6.505/18/2017 PBA5/18/2017 01700 ROBERT HAHN 5.42 10901 KARI JUNG 1.08 FEDERAL EXPRESS SHIPPING CHARG E 510-99999-5999 69.20 69.205/31/2017 CC349557 000310 FEDEX Check: 259388 6/2/2017 Wages E 510-99999-4001 4.00 276.77 276.776/1/2017 LD06/01/2 01700 ROBERT HAHN 4.00 276.77 Benefits/Contributions E 510-99999-4334 98.65 98.656/1/2017 LD06/01/2 01700 ROBERT HAHN 98.65 Benefits/Contributions E 510-99999-4331 31.12 31.126/1/2017 PBA6/1/2017 19Page: paTran Project Expense Transaction Detail Report Page:20 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 31.12 Benefits/Contributions E 510-99999-4332 12.70 12.706/1/2017 PBA6/1/2017 01700 ROBERT HAHN 12.70 Benefits/Contributions E 510-99999-4336 0.77 0.776/1/2017 PBA6/1/2017 01700 ROBERT HAHN 0.77 Benefits/Contributions E 510-99999-4339 2.17 2.176/1/2017 PBA6/1/2017 01700 ROBERT HAHN 2.17 TASK ORDER 2017-1 STREET SURFA E 510-99999-5999 22,145.00 22,145.006/2/2017 872035501 106415 NCE Check: 259545 6/9/2017 Wages E 510-99999-4001 29.50 1,060.37 1,060.376/15/2017 LD06/15/2 01700 ROBERT HAHN 4.00 276.77 10901 KARI JUNG 7.50 247.20 11073 MICHELLE TRAYER 18.00 536.40 Benefits/Contributions E 510-99999-4331 58.63 58.636/15/2017 LD06/15/2 11073 MICHELLE TRAYER 58.63 Benefits/Contributions E 510-99999-4334 380.38 380.386/15/2017 LD06/15/2 01700 ROBERT HAHN 98.68 10901 KARI JUNG 87.47 11073 MICHELLE TRAYER 194.23 Benefits/Contributions E 510-99999-4331 229.48 229.486/15/2017 PBA6/15/2017 01700 ROBERT HAHN 31.12 10901 KARI JUNG 58.34 11073 MICHELLE TRAYER 140.02 Benefits/Contributions E 510-99999-4332 93.68 93.686/15/2017 PBA6/15/2017 01700 ROBERT HAHN 12.70 10901 KARI JUNG 23.82 11073 MICHELLE TRAYER 57.16 Benefits/Contributions E 510-99999-4336 4.37 4.376/15/2017 PBA6/15/2017 01700 ROBERT HAHN 0.77 10901 KARI JUNG 1.06 11073 MICHELLE TRAYER 2.54 Benefits/Contributions E 510-99999-4339 15.98 15.986/15/2017 PBA6/15/2017 20Page: paTran Project Expense Transaction Detail Report Page:21 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 2.17 10901 KARI JUNG 4.06 11073 MICHELLE TRAYER 9.75 BART PERMIT FOR CHESTNUT AVE D E 510-99999-5999 1,260.00 1,260.006/27/2017 PR-000446 021558 BAY AREA RAPID TRANSIT DISTRIC Check: 260068 6/30/2017 Wages E 510-99999-4001 10.00 313.80 313.806/29/2017 LD06/29/2 10901 KARI JUNG 5.00 164.80 11073 MICHELLE TRAYER 5.00 149.00 Benefits/Contributions E 510-99999-4331 16.29 16.296/29/2017 LD06/29/2 11073 MICHELLE TRAYER 16.29 Benefits/Contributions E 510-99999-4334 112.23 112.236/29/2017 LD06/29/2 10901 KARI JUNG 58.28 11073 MICHELLE TRAYER 53.95 Benefits/Contributions E 510-99999-4331 77.78 77.786/29/2017 PBA6/29/2017 10901 KARI JUNG 38.89 11073 MICHELLE TRAYER 38.89 Benefits/Contributions E 510-99999-4332 31.76 31.766/29/2017 PBA6/29/2017 10901 KARI JUNG 15.88 11073 MICHELLE TRAYER 15.88 Benefits/Contributions E 510-99999-4336 1.42 1.426/29/2017 PBA6/29/2017 10901 KARI JUNG 0.71 11073 MICHELLE TRAYER 0.71 Benefits/Contributions E 510-99999-4339 5.42 5.426/29/2017 PBA6/29/2017 10901 KARI JUNG 2.71 11073 MICHELLE TRAYER 2.71 TASK ORDER 2017-1 STREET SURFA E 510-99999-5999 19,165.00 19,165.006/30/2017 872035502 106415 NCE Check: 260166 7/5/2017 Wages E 510-99999-4001 0.40 12.28 12.286/30/2017 LD06/30/2 11073 MICHELLE TRAYER 0.40 12.28 Benefits/Contributions E 510-99999-4331 1.30 1.306/30/2017 LD06/30/2 11073 MICHELLE TRAYER 1.30 Benefits/Contributions E 510-99999-4334 2.13 2.136/30/2017 LD06/30/2 11073 MICHELLE TRAYER 2.13 21Page: paTran Project Expense Transaction Detail Report Page:22 9/25/2017 8:58AM CITY OF SOUTH SAN FRANCISCO 7/1/2016 through 6/30/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate Benefits/Contributions E 510-99999-4331 3.11 3.116/30/2017 PBA6/30/2017 11073 MICHELLE TRAYER 3.11 Benefits/Contributions E 510-99999-4332 1.27 1.276/30/2017 PBA6/30/2017 11073 MICHELLE TRAYER 1.27 Benefits/Contributions E 510-99999-4336 0.06 0.066/30/2017 PBA6/30/2017 11073 MICHELLE TRAYER 0.06 Benefits/Contributions E 510-99999-4339 0.22 0.226/30/2017 PBA6/30/2017 11073 MICHELLE TRAYER 0.22 Phase Total:120 CONSTRUCTION 250.40 12,866.15 7,777.14 382,040.93 402,684.22 Project Number Total:st1705 STREET REHABILITATION PROGRAM FY16-17 724.80 41,468.51 23,522.61 464,755.20 529,746.32 GRAND TOTAL: 724.80 41,468.51 23,522.61 464,755.20 529,746.32 22Page: K L General Ledger Balances Page 1 of 1 Criteria: As Of = 6/30/2017; Period = 0,1..12,13,14,15,16; Summarize By = Report,Fund,ObjectGroup,Object; Fund = 101 Object Title Beginning Balance Year-To-Date Debits Year-To-Date Credits Ending Balance Fund 101 -- MEASURE W Object Group 11000 -- CURRENT ASSETS 11101 CASH AND INVESTMENT 277,488.10 8,825,475.19 978,514.78 8,124,448.51 11208 ACCOUNTS RECEIVABLE - OTHER 1,044,800.00 1,165,700.00 1,044,800.00 1,165,700.00 Total CURRENT ASSETS 1,322,288.10 9,991,175.19 2,023,314.78 9,290,148.51 Object Group 21000 -- CURRENT LIABILITIES 21101 ACCOUNTS PAYABLE (40,855.21)70,926.24 30,071.03 0.00 Total CURRENT LIABILITIES (40,855.21)70,926.24 30,071.03 0.00 Object Group 27000 -- FUND BALANCES 27001 FUND BALANCE (1,105,255.63)0.00 176,177.26 (1,281,432.89) 27202 RESERVE FOR ENCUMBRANCE (176,177.26)340,067.26 163,890.00 0.00 Total FUND BALANCES (1,281,432.89)340,067.26 340,067.26 (1,281,432.89) Object Group 28000 -- CONTROL ACCOUNTS 28001 ENCUMBRANCES 0.00 340,067.26 340,067.26 0.00 28003 APPROPRIATION CONTROL 0.00 0.00 176,177.26 (176,177.26) 28004 BUDGETED FUND BALANCE 0.00 176,177.26 0.00 176,177.26 28005 REVENUE CONTROL 0.00 1,044,800.00 9,931,453.13 (8,886,653.13) 28006 EXPENDITURE CONTROL 0.00 937,659.57 59,722.06 877,937.51 Total CONTROL ACCOUNTS 0.00 2,498,704.09 10,507,419.71 (8,008,715.62) Total MEASURE W 0.00 12,900,872.78 12,900,872.78 0.00 Total 0.00 12,900,872.78 12,900,872.78 0.00 ATTACHMENT 8 Financial Status Balances Page 1 of 1 Criteria: As Of = 8/31/2017; Summarize by = Report,Fund,ObjectGroup,Object; Period = 0,1..12,13,14,15,16; Fund = 101 Object Title Month-To-Date Actual Year-To-Date Actual Year-To-Date Ado Budget Year-To-Date Adjustments Year-To-Date Adj Budget Year-To-Date Encumbrances Bdgt. to Act. Variance Pct. Spent Fund 101 -- MEASURE W Revenues Object Group 30000 -- TAXES 30207 MEASURE W AND USE TAX (0.5%)0.00 0.00 9,168,433.00 0.00 9,168,433.00 0.00 9,168,433.00 0.0% Total TAXES 0.00 0.00 9,168,433.00 0.00 9,168,433.00 0.00 9,168,433.00 0.0% Total Revenues 0.00 0.00 9,168,433.00 0.00 9,168,433.00 0.00 9,168,433.00 0.0% Expenditures Object Group 6000 -- CAPITAL OUTAY 6001 LAND 0.00 0.00 2,440,861.00 0.00 2,440,861.00 0.00 2,440,861.00 0.0% Total CAPITAL OUTAY 0.00 0.00 2,440,861.00 0.00 2,440,861.00 0.00 2,440,861.00 0.0% Object Group 9000 -- TRANSFERS 9510 TRANSFER OUT TO CAPITAL IMPROV 0.00 0.00 9,168,433.00 0.00 9,168,433.00 0.00 9,168,433.00 0.0% Total TRANSFERS 0.00 0.00 9,168,433.00 0.00 9,168,433.00 0.00 9,168,433.00 0.0% Total Expenditures 0.00 0.00 11,609,294.00 0.00 11,609,294.00 0.00 11,609,294.00 0.0% Total MEASURE W 0.00 0.00 (2,440,861.00)0.00 (2,440,861.00)0.00 (2,440,861.00)0.0% Total 0.00 0.00 (2,440,861.00)0.00 (2,440,861.00)0.00 (2,440,861.00)0.0% ATTACHMENT 1 09/21/2017 CITY OF SOUTH SAN FRANCISCO 1 8:59AM Page:revdetl.rpt Revenue Detail Report 07/01/2017 through 08/31/2017 Periods: 0 through 2 MEASURE W101 Account Number Adjusted Estimate Revenues Year-to-date Revenues Balance Prct Rcvd 101-00000 NON EXPENSE ACCT 101-00000-30000 TAXES 101-00000-30207 MEASURE W AND USE TAX (0.5%) 9,168,433.00 0.00 0.00 9,168,433.00 0.00 7/19/2017 gl_cr CR 61502 499,600.00 101 7/19/2017 acrul_r_je GJ 61503-R -499,600.00 101 8/16/2017 gl_cr CR 62138 666,100.00 101 8/16/2017 acrul_r_je GJ 62166-R -666,100.00 101 101-00000-30207 MEASURE W AND USE TAX (0.5%) 0.00 0.00 0.00 9,168,433.00 9,168,433.00 101-00000-36101 SALE OF REAL/PERSONAL PROPERTY 0.00 0.00 0.00 0.00 0.00 Total MEASURE W 0.00 0.00 0.00 9,168,433.00 9,168,433.00 Grand Total 0.00 0.00 0.00 9,168,433.00 9,168,433.00 1Page: A B ATTACHMENT 2 ATTACHMENT A ATTACHMENT A ATTACHMENT A ATTACHMENT A ATTACHMENT A ATTACHMENT A ATTACHMENT B ATTACHMENT B ATTACHMENT B ATTACHMENT B ATTACHMENT B ATTACHMENT B 09/21/2017 CITY OF SOUTH SAN FRANCISCO 1 9:18AM Page:expdetl.rpt Expenditure Detail Report 07/01/2017 through 08/31/2017 Periods: 0 through 2 MEASURE W101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used 101-00000 NON EXPENSE ACCT 101-00000-6000 CAPITAL OUTAY 101-00000-6001 LAND 0.00 0.00 2,440,861.00 0.00 2,440,861.00 0.00 0.00 0.00 0.00 0.00 2,440,861.00 2,440,861.00Total NON EXPENSE ACCT 101-01000 CITY COUNCIL 101-01000-5000 SUPPLIES & SERVICES 101-01101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total CITY COUNCIL 101-02000 CITY CLERK 101-02000-5000 SUPPLIES & SERVICES 101-02101-5021 OPERATING SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 101-02101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total CITY CLERK 101-03000 CITY TREASURER 101-03000-5000 SUPPLIES & SERVICES 101-03101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total CITY TREASURER 101-04000 CITY ATTORNEY 101-04000-5000 SUPPLIES & SERVICES 101-04101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total CITY ATTORNEY 101-05000 CITY MANAGER 101-05000-5000 SUPPLIES & SERVICES 101-05101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total CITY MANAGER 101-06000 FINANCE DEPARTMENT 101-06000-5000 SUPPLIES & SERVICES 101-06101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total FINANCE DEPARTMENT 1Page: 09/21/2017 CITY OF SOUTH SAN FRANCISCO 2 9:18AM Page:expdetl.rpt Expenditure Detail Report 07/01/2017 through 08/31/2017 Periods: 0 through 2 MEASURE W101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used 101-07000 NON-DEPARTMENTAL 101-07000-5000 SUPPLIES & SERVICES 101-07101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total NON-DEPARTMENTAL 101-09000 HUMAN RESOURCES 101-09000-5000 SUPPLIES & SERVICES 101-09101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total HUMAN RESOURCES 101-10000 ECONOMIC & COMMUNITY DEVELOPMENT DEPT 101-10000-5000 SUPPLIES & SERVICES 101-10101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total ECONOMIC & COMMUNITY DEVELOPMENT DEPT 101-11000 FIRE DEPARTMENT 101-11000-5000 SUPPLIES & SERVICES 101-11101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total FIRE DEPARTMENT 101-12000 POLICE DEPARTMENT 101-12000-5000 SUPPLIES & SERVICES 101-12101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total POLICE DEPARTMENT 101-13000 PUBLIC WORKS 101-13000-5000 SUPPLIES & SERVICES 101-13101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total PUBLIC WORKS 101-15000 LIBRARY DEPARTMENT 101-15000-5000 SUPPLIES & SERVICES 101-15101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total LIBRARY DEPARTMENT 101-16000 INFORMATION TECHNOLOGY DEPARTMENT 101-16000-5000 SUPPLIES & SERVICES 2Page: 09/21/2017 CITY OF SOUTH SAN FRANCISCO 3 9:18AM Page:expdetl.rpt Expenditure Detail Report 07/01/2017 through 08/31/2017 Periods: 0 through 2 MEASURE W101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used 101-16101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total INFORMATION TECHNOLOGY DEPARTMENT 101-17000 PARKS & RECREATION DEPARTMENT 101-17000-5000 SUPPLIES & SERVICES 101-17101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Total PARKS & RECREATION DEPARTMENT 101-99000 CIP 101-99000-9000 TRANSFERS 101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV 0.00 0.00 9,168,433.00 0.00 9,168,433.00 0.00 0.00 0.00 0.00 0.00 9,168,433.00 9,168,433.00Total CIP 0.00 0.00 0.00 0.00 11,609,294.00 11,609,294.00Total MEASURE W Grand Total 0.00 0.00 0.00 0.00 11,609,294.00 11,609,294.00 3Page: paTran Project Expense Transaction Detail Report Page:1 9/21/2017 9:43AM CITY OF SOUTH SAN FRANCISCO 7/1/2017 through 8/31/2017 Project Number #pf1707 COMMUNITY CIVIC CAMPUS Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate Phase #100 PRELIMINARY STUDIES El Camino Real/Chestnut Specif E 510-99995-5999 3,200.00 3,200.008/10/2017 9193576-1 106572 KIMLEY-HORN ASSOCIATES INC Check: 261034 8/11/2017 ECR/CHESTNUT AVE AREA PLAN E 510-99995-5999 4,522.82 4,522.828/23/2017 986107 105716 MICHAEL BAKER INTL, INC Check: 261409 8/25/2017 Phase Total:100 PRELIMINARY STUDIES 0.00 0.00 0.00 7,722.82 7,722.82 Project Number Total:pf1707 COMMUNITY CIVIC CAMPUS 0.00 0.00 0.00 7,722.82 7,722.82 GRAND TOTAL: 0.00 0.00 0.00 7,722.82 7,722.82 1Page: C D ATTACHMENT 4 C ATTACHMENT A ATTACHMENT A ATTACHMENT A D ATTACHMENT B paTran Project Expense Transaction Detail Report Page: 1 9/21/2017 9:46AM CITY OF SOUTH SAN FRANCISCO 7/1/2017 through 8/31/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate Phase #110 Printed sets of Street Slurry E 510-99999-5999 59.43 59.437/7/2017 144146 000606 ROZZI REPRODUCTION & SUPPLY IN Check: 260320 7/12/2017 Wages E 510-99999-4001 17.10 1,218.78 1,218.787/13/2017 LD07/13/2 01700 ROBERT HAHN 17.10 1,218.78 Benefits/Contributions E 510-99999-4334 207.54 207.547/13/2017 LD07/13/2 01700 ROBERT HAHN 207.54 Benefits/Contributions E 510-99999-4331 133.02 133.027/13/2017 PBA7/13/2017 01700 ROBERT HAHN 133.02 Benefits/Contributions E 510-99999-4332 54.30 54.307/13/2017 PBA7/13/2017 01700 ROBERT HAHN 54.30 Benefits/Contributions E 510-99999-4336 3.27 3.277/13/2017 PBA7/13/2017 01700 ROBERT HAHN 3.27 Benefits/Contributions E 510-99999-4339 9.27 9.277/13/2017 PBA7/13/2017 01700 ROBERT HAHN 9.27 Wages E 510-99999-4001 17.00 1,211.64 1,211.647/27/2017 LD07/27/2 01700 ROBERT HAHN 17.00 1,211.64 Benefits/Contributions E 510-99999-4334 206.34 206.347/27/2017 LD07/27/2 01700 ROBERT HAHN 206.34 Benefits/Contributions E 510-99999-4331 132.24 132.247/27/2017 PBA7/27/2017 01700 ROBERT HAHN 132.24 Benefits/Contributions E 510-99999-4332 53.98 53.987/27/2017 PBA7/27/2017 01700 ROBERT HAHN 53.98 Benefits/Contributions E 510-99999-4336 3.25 3.257/27/2017 PBA7/27/2017 01700 ROBERT HAHN 3.25 Benefits/Contributions E 510-99999-4339 9.21 9.217/27/2017 PBA7/27/2017 01700 ROBERT HAHN 9.21 Classified Advertising in San E 510-99999-5999 865.46 865.468/7/2017 0001069230 027869 CALIFORNIA NEWSPAPER PARTNERS Check: 260938 8/9/2017 Wages E 510-99999-4001 26.00 1,853.10 1,853.108/10/2017 LD08/10/2 01700 ROBERT HAHN 26.00 1,853.10 Benefits/Contributions E 510-99999-4334 315.56 315.568/10/2017 LD08/10/2 01700 ROBERT HAHN 315.56 1Page: DESIGN E F ATTACHMENT 5 paTran Project Expense Transaction Detail Report Page: 2 9/21/2017 9:46AM CITY OF SOUTH SAN FRANCISCO 7/1/2017 through 8/31/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate Benefits/Contributions E 510-99999-4331 202.25 202.258/10/2017 PBA8/10/2017 01700 ROBERT HAHN 202.25 Benefits/Contributions E 510-99999-4332 82.56 82.568/10/2017 PBA8/10/2017 01700 ROBERT HAHN 82.56 Benefits/Contributions E 510-99999-4336 4.98 4.988/10/2017 PBA8/10/2017 01700 ROBERT HAHN 4.98 Benefits/Contributions E 510-99999-4339 14.09 14.098/10/2017 PBA8/10/2017 01700 ROBERT HAHN 14.09 Task Order 2017-4, Roadway and E 510-99999-5999 13,525.49 13,525.498/18/2017 17011-004 000273 DKS ASSOCIATES Check: 261682 9/8/2017 Task Order 2017-1 for 2016 Str E 510-99999-5999 2,041.97 2,041.978/18/2017 21576 000737 WILSEY HAM, INC Check: 261376 8/23/2017 Wages E 510-99999-4001 30.00 1,514.94 1,514.948/24/2017 LD08/24/2 01700 ROBERT HAHN 14.00 997.82 10901 KARI JUNG 8.00 271.60 11073 MICHELLE TRAYER 8.00 245.52 Benefits/Contributions E 510-99999-4331 26.04 26.048/24/2017 LD08/24/2 11073 MICHELLE TRAYER 26.04 Benefits/Contributions E 510-99999-4334 260.91 260.918/24/2017 LD08/24/2 01700 ROBERT HAHN 171.42 10901 KARI JUNG 46.97 11073 MICHELLE TRAYER 42.52 Benefits/Contributions E 510-99999-4331 233.36 233.368/24/2017 PBA8/24/2017 01700 ROBERT HAHN 108.90 10901 KARI JUNG 62.23 11073 MICHELLE TRAYER 62.23 Benefits/Contributions E 510-99999-4332 95.26 95.268/24/2017 PBA8/24/2017 01700 ROBERT HAHN 44.46 10901 KARI JUNG 25.40 11073 MICHELLE TRAYER 25.40 Benefits/Contributions E 510-99999-4336 4.94 4.948/24/2017 PBA8/24/2017 2Page: G H paTran Project Expense Transaction Detail Report Page:3 9/21/2017 9:46AM CITY OF SOUTH SAN FRANCISCO 7/1/2017 through 8/31/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 2.68 10901 KARI JUNG 1.13 11073 MICHELLE TRAYER 1.13 Benefits/Contributions E 510-99999-4339 16.25 16.258/24/2017 PBA8/24/2017 01700 ROBERT HAHN 7.59 10901 KARI JUNG 4.33 11073 MICHELLE TRAYER 4.33 Phase Total:110 DESIGN 90.10 5,798.46 2,068.62 16,492.35 24,359.43 Phase #120 CONSTRUCTION Wages E 510-99999-4001 3.60 110.48 110.487/13/2017 LD07/13/2 11073 MICHELLE TRAYER 3.60 110.48 Benefits/Contributions E 510-99999-4331 11.72 11.727/13/2017 LD07/13/2 11073 MICHELLE TRAYER 11.72 Benefits/Contributions E 510-99999-4334 19.13 19.137/13/2017 LD07/13/2 11073 MICHELLE TRAYER 19.13 Benefits/Contributions E 510-99999-4331 28.00 28.007/13/2017 PBA7/13/2017 11073 MICHELLE TRAYER 28.00 Benefits/Contributions E 510-99999-4332 11.43 11.437/13/2017 PBA7/13/2017 11073 MICHELLE TRAYER 11.43 Benefits/Contributions E 510-99999-4336 0.51 0.517/13/2017 PBA7/13/2017 11073 MICHELLE TRAYER 0.51 Benefits/Contributions E 510-99999-4339 1.95 1.957/13/2017 PBA7/13/2017 11073 MICHELLE TRAYER 1.95 Wages E 510-99999-4001 2.00 142.55 142.557/27/2017 LD07/27/2 01700 ROBERT HAHN 2.00 142.55 Benefits/Contributions E 510-99999-4334 24.27 24.277/27/2017 LD07/27/2 01700 ROBERT HAHN 24.27 Benefits/Contributions E 510-99999-4331 15.56 15.567/27/2017 PBA7/27/2017 01700 ROBERT HAHN 15.56 Benefits/Contributions E 510-99999-4332 6.35 6.357/27/2017 PBA7/27/2017 01700 ROBERT HAHN 6.35 Benefits/Contributions E 510-99999-4336 0.38 0.387/27/2017 PBA7/27/2017 3Page: paTran Project Expense Transaction Detail Report Page: 4 9/21/2017 9:46AM CITY OF SOUTH SAN FRANCISCO 7/1/2017 through 8/31/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 0.38 Benefits/Contributions E 510-99999-4339 1.08 1.087/27/2017 PBA7/27/2017 01700 ROBERT HAHN 1.08 TASK ORDER 2017-1 STREET SURFA E 510-99999-5999 10,580.00 10,580.008/10/2017 872035503 106415 NCE Check: 261046 8/11/2017 Wages E 510-99999-4001 4.00 210.45 210.458/10/2017 LD08/10/2 01700 ROBERT HAHN 2.00 142.55 10901 KARI JUNG 2.00 67.90 Benefits/Contributions E 510-99999-4334 35.51 35.518/10/2017 LD08/10/2 01700 ROBERT HAHN 24.27 10901 KARI JUNG 11.24 Benefits/Contributions E 510-99999-4331 31.12 31.128/10/2017 PBA8/10/2017 01700 ROBERT HAHN 15.56 10901 KARI JUNG 15.56 Benefits/Contributions E 510-99999-4332 12.70 12.708/10/2017 PBA8/10/2017 01700 ROBERT HAHN 6.35 10901 KARI JUNG 6.35 Benefits/Contributions E 510-99999-4336 0.66 0.668/10/2017 PBA8/10/2017 01700 ROBERT HAHN 0.38 10901 KARI JUNG 0.28 Benefits/Contributions E 510-99999-4339 2.16 2.168/10/2017 PBA8/10/2017 01700 ROBERT HAHN 1.08 10901 KARI JUNG 1.08 CONSTRUCTION OF 2016 ADA RAMPS E 510-99999-5999 15,862.25 15,862.258/10/2017 RETENTION-3919-16 Check: 261023 8/11/2017 Wages E 510-99999-4001 5.00 356.37 356.378/24/2017 LD08/24/2 01700 ROBERT HAHN 5.00 356.37 Benefits/Contributions E 510-99999-4334 61.23 61.238/24/2017 LD08/24/2 01700 ROBERT HAHN 61.23 Benefits/Contributions E 510-99999-4331 38.89 38.898/24/2017 PBA8/24/2017 01700 ROBERT HAHN 38.89 Benefits/Contributions E 510-99999-4332 15.88 15.888/24/2017 PBA8/24/2017 01700 ROBERT HAHN 15.88 Benefits/Contributions E 510-99999-4336 0.96 0.968/24/2017 PBA8/24/2017 4Page: I 106802 GOLDEN BAY CONSTRUCTION, INC J paTran Project Expense Transaction Detail Report Page: 5 9/21/2017 9:46AM CITY OF SOUTH SAN FRANCISCO 7/1/2017 through 8/31/2017 Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17 Hours Labor Benefits Other TotalAccount #DescriptionReferenceDate 01700 ROBERT HAHN 0.96 Benefits/Contributions E 510-99999-4339 2.71 2.718/24/2017 PBA8/24/2017 01700 ROBERT HAHN 2.71 TASK ORDER 2017-1 STREET SURFA E 510-99999-5999 2,160.00 2,160.008/29/2017 872035504 Check: 261490 8/30/2017 Phase Total:120 CONSTRUCTION 14.60 819.85 322.20 28,602.25 29,744.30 Project Number Total:st1705 STREET REHABILITATION PROGRAM FY16-17 104.70 6,618.31 2,390.82 45,094.60 54,103.73 GRAND TOTAL: 104.70 6,618.31 2,390.82 45,094.60 54,103.73 5Page: 106415 NCE K ATTACHMENT A & ATTACHMENT B ' ATTACHMENT C ( ATTACHMENT C ATTACHMENT C ATTACHMENT C ATTACHMENT D ) ATTACHMENT D I J K