HomeMy WebLinkAbout10.03.2018 @630 Regular Measure W COCWednesday, October 3, 2018
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 3, 2018MeasureWCitizens' 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 3, 2018, 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 for the meetings of April 4, 2018 and August 1, 2018.1.
Presentation of audit overview by independent auditor. (Katherine Yuen, CPA, Vice
President, Maze and Associates)
2.
Report transmitting Measure W Fiscal Year 2017-18 year-end results. (Richard Lee,
Director of Finance)
3.
Adjournment.
Page 2CityofSouthSanFrancisco Printed on 10/24/2018
City of South San Francisco
Legislation Text
P.O. Box 711 (City Hall, 400
Grand Avenue)
South San Francisco, CA
File #:18-936 Agenda Date:10/3/2018
Version:1 Item #:1.
Motion to approve the Minutes for the meetings of April 4, 2018 and August 1, 2018.
City of South San Francisco Printed on 9/27/2018Page1of1
powered by Legistar™
City of South San Francisco
Legislation Text
P.O. Box 711 (City Hall, 400
Grand Avenue)
South San Francisco, CA
File #:18-911 Agenda Date:10/3/2018
Version:1 Item #:2.
Presentation of audit overview by independent auditor.(Katherine Yuen,CPA,Vice President,Maze and
Associates)
RECOMMENDATION
No formal action is required. The item is for information purposes only.
BACKGROUND/DISCUSSION
Each Fiscal Year,the City’s independent auditor presents the audit overview to the Measure W Citizens’
Oversight Committee,pursuant to the committee bylaws.The audit overview,included as Attachment 1,
describes the independent auditor’s responsibility under United States Generally Accepted Auditing Standards,
defines materiality, the scope of the audit, and the general timeline for major audit milestones.
CONCLUSION
The independent auditor’s audit plan is sound,fair,and in compliance with Generally Accepted Auditing
Standards.
Attachment - Audit Overview
City of South San Francisco Printed on 9/27/2018Page1of1
powered by Legistar™
CITY OF SOUTH SAN FRANCISCO
Measure W Citizen Oversight Committee
Audit Overview
October 3, 2018
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 1
CITY OF SOUTH SAN FRANCISCO
Measure W Citizen Oversight Committee
Audit Overview
October 3, 2018
2
Audit Timing
We have met with staff and agreed the following schedule:
Interim fieldwork: May 2018
Final fieldwork: October 2018
Reports finalization: December 2018
City of South San Francisco
Legislation Text
P.O. Box 711 (City Hall, 400
Grand Avenue)
South San Francisco, CA
File #:18-922 Agenda Date:10/3/2018
Version:1 Item #:3.
Report transmitting Measure W Fiscal Year 2017-18 year-end results.(Richard Lee, Director of Finance)
RECOMMENDATION
This is an information only item.
BACKGROUND/DISCUSSION
Attached for the Measure W Citizens’Oversight Committee’s information are Measure W financial reports
through accounting period 16 of Fiscal Year (FY) 2017-18.
Attachment 1,the Fiscal Year (FY)2017-18 Measure W Revenue Detail Report,indicates that the City received
1,959,169 in revenue between accounting periods 13 through 16,which accounts for revenues that were
accrued for FY 2017-18,and includes the true-up for the second quarter of calendar year 2018,and the May
2018 advance from the California Department of Tax and Fee Administration.The City has received a total of
11,162,238 in Measure W revenues for all of FY 2017-18.
As indicated in Attachment 2,the City expended $7,189,055 in Measure W funds in June 2018.As authorized
by the City Council via the FY 2017-18 adopted budget,Measure W reimbursed the General Fund for its share
of $2,440,861 of the land acquisition costs for the Community Civic Campus project.In addition,the other
highlighted transactions largely represent capital project expenditure allocation costs that had not yet taken
place in the last reporting period due to vendor invoices that were received after June 30th,and were for services
rendered within FY 2017-18.The allocated costs principally reflect capital project expense allocations as
follows,with accompanying project expense detail reports and supporting documentation provided in
Attachment 3 and Attachment 4:
Community Civic Campus (pf1707): $631,631; and
Year 2 of the 5-Year Paving Program (st1705): $1,805,294.
The City expended a total of $9,048,241 of Measure W funds in FY 2017-18.Compared to the FY 2017-18
Amended Budget of $16,417,566 reflected in Attachment 5,the budget remainder is $7,369,325.These funds,
which represent unexpended budget appropriations for capital improvement projects,will be committed as a
reserve for current capital projects and serve as a budget amendment in FY 2018-19.
The balance sheet report,included as Attachment 6,lists all assets,liabilities,and equities for Measure W,and
indicates a cash balance of $9.4 million as of June 30, 2018.
CONCLUSION
Measure W revenues were received and accounted for accurately.Measure W funds were spent in a manner
consistent with the Measure W ballot measure language,and within the FY 2017-18 authorized appropriation
City of South San Francisco Printed on 9/27/2018Page1of2
powered by Legistar™
File #:18-922 Agenda Date:10/3/2018
Version:1 Item #:3.
consistent with the Measure W ballot measure language,and within the FY 2017-18 authorized appropriation
limit.
Attachments:
1.FY 2017-18 Measure W Revenue Detail Periods 13 - 16
2.FY 2017-18 Measure W Expenditure Detail Periods 12 - 16
3.Project pf1707 Transaction Detail June 2018
4.Project st1705 Transaction Detail June 2018
5.FY 2017-18 Measure W Budget to Actual Period 16 YTD
6.Measure W (Fund 101) Balance Sheet Report Period 16 YTD
City of South San Francisco Printed on 9/27/2018Page2of2
powered by Legistar™
09/18/2018
CITY OF SOUTH SAN FRANCISCO
1
3:27PM
Page:revdetl.rpt Revenue Detail Report
06/30/2018 through 06/30/2018
Periods: 13 through 16
FY 2017-18 Measure W Revenue Detail
MEASUREW101
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 9,203,068.56 -34,635.56 100.38
1,153,077.511016/30/2018 acrul_r_je GJ 68942
Line Description: FY17-18 Sales Tax-CA Document Description : FY 2017-2018 YEAR END ACCRUAL
806,091.751016/30/2018 acrul_r_je GJ 68210
Line Description: FY17-18 Sales Tax-CA Document Description : FY 2017-2018 YEAR END ACCRUAL
101-00000-30207 MEASURE W AND USE TAX (0.5%) 1,959,169.26 11,162,237.82 121.759,168,433.00 -1,993,804.82
Total MEASURE W 121.751,959,169.26 11,162,237.829,168,433.00 -1,993,804.82
Grand Total 1,959,169.26 11,162,237.82 121.759,168,433.00 -1,993,804.82
1Page:
ATTACHMENT 1
1A
1B
1A
1B
09/20/2018
CITY OF SOUTH SAN FRANCISCO
1
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
NON EXPENSEACCT00000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-00000-6000 CAPITAL OUTAY
101-00000-6001 LAND 0.00 0.00 2,440,861.000.002,440,861.00 0.00
Total CAPITAL OUTAY 0.000.00 0.00 2,440,861.000.002,440,861.00
101-00000-9000 TRANSFERS
101-00000-9100 TRANSFER OUT TO GENERAL FUND 0.00 0.00 0.000.000.00 0.00
2,440,861.006/29/2018 genjrnl GJ 69163
101LineDescription: Trfr - PUC and Taxing Entities Document Description : TRANSFER FUNDS PUC PARCELS/TAXING ENTITI
2,440,861.00 2,440,861.00 0.00101-00000-9100 TRANSFER OUT TO GENERAL FUND 0.00 -2,440,861.000.00
Total TRANSFERS 0.002,440,861.00 0.00 -2,440,861.002,440,861.000.00
100.002,440,861.00 2,440,861.00 0.00 0.002,440,861.00TotalNONEXPENSEACCT
1Page:
ATTACHMENT 2
09/20/2018
CITY OF SOUTH SAN FRANCISCO
2
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
CITYCOUNCIL01000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-01000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalCITYCOUNCIL
2Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
3
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
CITYCLERK02000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-02000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalCITYCLERK
3Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
4
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
CITYTREASURER03000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-03000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalCITYTREASURER
4Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
5
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
CITYATTORNEY04000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-04000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalCITYATTORNEY
5Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
6
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
CITYMANAGER05000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-05000-5000 SUPPLIES & SERVICES
0.000.00101-05101-5005 PROFESSIONAL & SPECIALIZED SVCS 0.0076,000.00 76,000.00 0.00
11,175.006/5/2018 invoice IN PRG #SSF1801
101LineDescription: COMMUNITY CIVIC CAMPUS FUND RA Document Description : COMM CIV CAMPUS FUND RAISING CONSULTANT
Vendor: 108252 PARTNERSHIP RESOURCES GROUP Check # 268102
11,175.006/5/2018 invoice IN PRG #SSF1802
101LineDescription: COMM CIV CAMPUS FUNDRAISING PR Document Description : COMM CIV CAMPUS FUNDRAISING PRG, 6/1/18
Vendor: 108252 PARTNERSHIP RESOURCES GROUP Check # 268399
22,350.00 22,350.00 29.41101-05101-5005 PROFESSIONAL & SPECIALIZED SVCS 0.00 53,650.0076,000.00
0.000.00101-05101-5999 PROJ ACCT SUPPLIES & SCVS 0.000.00 0.00 0.00
Total SUPPLIES & SERVICES 29.4122,350.00 0.00 53,650.0022,350.0076,000.00
29.4122,350.00 22,350.00 0.00 53,650.0076,000.00TotalCITYMANAGER
6Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
7
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
FINANCEDEPARTMENT06000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-06000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalFINANCEDEPARTMENT
7Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
8
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
NON-DEPARTMENTAL07000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-07000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalNON-DEPARTMENTAL
8Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
9
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
HUMANRESOURCES09000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-09000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalHUMANRESOURCES
9Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
10
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
ECONOMIC & COMMUNITY DEVELOPMENTDEPT10000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-10000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalECONOMIC & COMMUNITY DEVELOPMENT DEPT
10Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
11
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
FIREDEPARTMENT11000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-11000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalFIREDEPARTMENT
11Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
12
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
POLICEDEPARTMENT12000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-12000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalPOLICEDEPARTMENT
12Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
13
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
PUBLICWORKS13000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-13000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalPUBLICWORKS
13Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
14
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
LIBRARYDEPARTMENT15000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-15000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalLIBRARYDEPARTMENT
14Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
15
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
INFORMATION TECHNOLOGYDEPARTMENT16000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-16000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalINFORMATIONTECHNOLOGYDEPARTMENT
15Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
16
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
PARKS & RECREATIONDEPARTMENT17000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-17000-5000 SUPPLIES & SERVICES
Total SUPPLIES & SERVICES 0.000.00 0.00 0.000.000.00
0.000.00 0.00 0.00 0.000.00TotalPARKS & RECREATION DEPARTMENT
16Page:
09/20/2018
CITY OF SOUTH SAN FRANCISCO
17
2:41PM
Page:expdetl.rpt Expenditure Detail Report
06/01/2018 through 06/30/2018
Periods: 12 through 16
MEASUREW101
CIP99000
Prct
UsedBalance
Year-to-date
Encumbrances
Year-to-date
ExpendituresExpenditures
Adjusted
AppropriationAccountNumber
101-99000-9000 TRANSFERS
1,859,186.580.00101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV 0.0013,900,705.49 12,041,518.91 13.37
822,323.676/30/2018 rev alloc GJ st1705
101LineDescription: Project: st1705 Allocation Document Description : Project: st1705 Allocation
560,630.916/30/2018 rev alloc GJ pf1707
101LineDescription: Project: pf1707 Allocation Document Description : Project: pf1707 Allocation
681,010.406/30/2018 rev alloc GJ st1705
101LineDescription: Project: st1705 Allocation Document Description : Project: st1705 Allocation
982,969.996/30/2018 rev alloc GJ st1705
101LineDescription: Project: st1705 Allocation Document Description : Project: st1705 Allocation
71,000.006/30/2018 rev alloc GJ pf1707
101LineDescription: Project: pf1707 Allocation Document Description : Project: pf1707 Allocation
1,581,588.866/30/2018 rev alloc GJ pf1707
101LineDescription: Project: pf1707 Allocation Document Description : Project: pf1707 Allocation
26,320.006/30/2018 rev alloc GJ st1702
101LineDescription: Project: st1702 Allocation Document Description : Project: st1702 Allocation
4,725,843.83 6,585,030.41 47.37101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV 0.00 7,315,675.0813,900,705.49
Total TRANSFERS 47.374,725,843.83 0.00 7,315,675.086,585,030.4113,900,705.49
47.374,725,843.83 6,585,030.41 0.00 7,315,675.0813,900,705.49TotalCIP
55.117,189,054.83 9,048,241.41 0.00 7,369,325.0816,417,566.49TotalMEASUREW
Grand Total 7,189,054.83 9,048,241.41 55.110.00 7,369,325.0816,417,566.49
17Page:
paTran Project Expense Transaction Detail Report Page: 1
9/19/2018 3:25PM CITY OF SOUTH SAN FRANCISCO
6/1/2018 through 6/30/2018
Project Number #pf1707 COMMUNITY CIVIC CAMPUS
Phase #100 PRELIMINARY STUDIES
Date Reference Description Account #Hours Benefits Materials Other Total
Labor +
Task #600 CONTRACT/CONSULTANT SERVICES
COMM CIV CAMPUS LAND ECONOMICSE 510-99995-5999 12,765.00 12,765.006/11/2018 1801-01
107895 LAND ECONOMICS CONSULTANTS LLC Check: 268376 6/20/2018
COMMUNITY CIVIC CAMPUS LAND EC E 510-99995-5999 7,955.00 7,955.006/11/2018 1801-02
107895 LAND ECONOMICS CONSULTANTS LLC Check: 268263 6/15/2018
COMMUNITY CIVIC CAMPUS LAND EC E 510-99995-5999 1,480.00 1,480.006/11/2018 1801-03
107895 LAND ECONOMICS CONSULTANTS LLC Check: 268263 6/15/2018
Task Total: 600 0.00 0.00 0.00 22,200.00 22,200.00CONTRACT/CONSULTANT SERVICES
Phase Total:100 PRELIMINARY STUDIES 0.00 0.00 0.00 22,200.00 22,200.00
1Page:
ATTACHMENT 3
paTran Project Expense Transaction Detail Report Page:2
9/19/2018 3:25PM CITY OF SOUTH SAN FRANCISCO
6/1/2018 through 6/30/2018
Project Number #pf1707 COMMUNITY CIVIC CAMPUS
Phase #110 DESIGN
Date Reference Description Account #Hours Benefits Materials Other Total
Labor +
Task #600 CONTRACT/CONSULTANT SERVICES
COMM CIVIC CAMPUS, SMITH GROUP E 510-99995-5999 487,478.34 487,478.346/20/2018 0131637
107999 SMITHGROUPJJR INC Check: 268952 7/11/2018
Task Total:600 0.00 0.00 0.00 487,478.34 487,478.34CONTRACT/CONSULTANT SERVICES
Phase Total:110 DESIGN 0.00 0.00 0.00 487,478.34 487,478.34
2Page:
paTran Project Expense Transaction Detail Report Page: 3
9/19/2018 3:25PM CITY OF SOUTH SAN FRANCISCO
6/1/2018 through 6/30/2018
Project Number #pf1707 COMMUNITY CIVIC CAMPUS
Phase #160 PROJECT MANAGEMENT
Date Reference Description Account #Hours Benefits Materials Other Total
Labor +
Task #600 CONTRACT/CONSULTANT SERVICES
FY2016-17 APPROVED CONSULTANT E 510-99995-5999 35,759.00 35,759.006/11/2018 78928
106730 KITCHELL CEM Check: 269408 7/27/2018
COMM CIV CAMPUS, KITCHELL PROG E 510-99995-5999 37,245.00 37,245.006/24/2018 79463
106730 KITCHELL CEM Check: 268926 7/11/2018
COMMUNITY CIVIC CAMPUS, THE CO E 510-99995-5999 3,107.39 3,107.396/25/2018 1055
108377 THE COLLECTIVE POTENTIAL LLC Check: 268882 7/6/2018
HEATHER ENDERS -- CREDIT CARD E 510-99995-5999 148.57 148.576/30/2018 cc375407
104664 PRONTO LASAGNERIA N PIZZERIA Check: 269257 7/20/2018
Task Total: 600 0.00 0.00 3,255.96 73,004.00 76,259.96CONTRACT/CONSULTANT SERVICES
Phase Total:160 PROJECT MANAGEMENT 0.00 0.00 3,255.96 73,004.00 76,259.96
Project Number Total:pf1707 COMMUNITY CIVIC CAMPUS 0.00 0.00 3,255.96 582,682.34 585,938.30
GRAND TOTAL: 0.00 0.00 3,255.96 582,682.34 585,938.30
3Page:
3A
3B
2A
2B
paTran Project Expense Transaction Detail Report Page: 1
9/19/2018 3:23PM CITY OF SOUTH SAN FRANCISCO
6/1/2018 through 6/30/2018
Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17
Phase #110 DESIGN
Date Reference Description Account #Hours Benefits Materials Other Total
Labor +
Task #600 CONTRACT/CONSULTANT SERVICES
Task Order 2017-4, Roadway and E 510-99999-5999 490.00 490.006/21/2018 0066716
000273 DKS ASSOCIATES Check: 268478 6/22/2018
Task Total: 600 0.00 0.00 0.00 490.00 490.00CONTRACT/CONSULTANT SERVICES
Phase Total:110 DESIGN 0.00 0.00 0.00 490.00 490.00
1Page:
ATTACHMENT 4
paTran Project Expense Transaction Detail Report Page:2
9/19/2018 3:23PM CITY OF SOUTH SAN FRANCISCO
6/1/2018 through 6/30/2018
Project Number #st1705 STREET REHABILITATION PROGRAM FY16-17
Phase #120 CONSTRUCTION
Date Reference Description Account #Hours Benefits Materials Other Total
Labor +
Task #600 CONTRACT/CONSULTANT SERVICES
Materials Testing and Special E 510-99999-5999 6,122.50 6,122.506/6/2018 218529
104960 NINYO AND MOORE GEOTECHNICAL Check: 268002 6/6/2018
2018-2: Construction Services E 510-99999-5999 7,327.30 7,327.306/21/2018 22159
000737 WILSEY HAM, INC Check: 268526 6/22/2018
2016 Street Rehabilitation Pro E 510-99999-5999 574,281.22 574,281.226/21/2018 4
000391 INTERSTATE GRADING & PAVING IN Check: 268578 6/27/2018
Task Order 2018-1: 2016 STREET E 510-99999-5999 46,267.00 46,267.006/25/2018 3366
105927 ANCHOR ENGINEERING, INC.Check: 268537 6/27/2018
2018-G4: Soil Classification -E 510-99999-5999 5,376.00 5,376.006/29/2018 219153
104960 NINYO AND MOORE GEOTECHNICAL Check: 268855 7/6/2018
2016 Street Rehabilitation Pro E 510-99999-5999 982,969.99 982,969.996/29/2018 5
000391 INTERSTATE GRADING & PAVING IN Check: 268842 7/6/2018
Task Total:600 0.00 0.00 0.00 1,622,344.01 1,622,344.01CONTRACT/CONSULTANT SERVICES
Phase Total:120 CONSTRUCTION 0.00 0.00 0.00 1,622,344.01 1,622,344.01
Project Number Total:st1705 STREET REHABILITATION PROGRAM FY16-17 0.00 0.00 0.00 1,622,834.01 1,622,834.01
GRAND TOTAL: 0.00 0.00 0.00 1,622,834.01 1,622,834.01
2Page:
Financial Status Balances Page 1 of 1
Criteria: As Of = 6/30/2018; 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%)712,000.83 11,162,237.82 9,168,433.00 0.00 9,168,433.00 0.00 (1,993,804.82) 121.7%
Total TAXES 712,000.83 11,162,237.82 9,168,433.00 0.00 9,168,433.00 0.00 (1,993,804.82)121.7%
Total Revenues 712,000.83 11,162,237.82 9,168,433.00 0.00 9,168,433.00 0.00 (1,993,804.82)121.7%
Expenditures
Object Group 5000 -- SUPPLIES & SERVICES
5005 PROFESSIONAL & SPECIALIZED SVCS 22,350.00 22,350.00 0.00 76,000.00 76,000.00 0.00 53,650.00 29.4%
Total SUPPLIES & SERVICES 22,350.00 22,350.00 0.00 76,000.00 76,000.00 0.00 53,650.00 29.4%
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
9100 TRANSFER OUT TO GENERAL FUND 2,440,861.00 2,440,861.00 0.00 0.00 0.00 0.00 (2,440,861.00) 0.0%
9510 TRANSFER OUT TO CAPITAL IMPROV 4,725,843.83 6,585,030.41 9,168,433.00 4,732,272.49 13,900,705.49 0.00 7,315,675.08 47.4%
Total TRANSFERS 7,166,704.83 9,025,891.41 9,168,433.00 4,732,272.49 13,900,705.49 0.00 4,874,814.08 64.9%
Total Expenditures 7,189,054.83 9,048,241.41 11,609,294.00 4,808,272.49 16,417,566.49 0.00 7,369,325.08 55.1%
Total MEASURE W (6,477,054.00)2,113,996.41 (2,440,861.00)(4,808,272.49)(7,249,133.49)0.00 (9,363,129.90)(29.2%)
Total (6,477,054.00)2,113,996.41 (2,440,861.00)(4,808,272.49)(7,249,133.49)0.00 (9,363,129.90)(29.2%)
ATTACHMENT 5
General Ledger Balances Page 1 of 1
Criteria: As Of = 6/30/2018; 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 8,124,448.51 11,838,204.21 10,517,677.06 9,444,975.66
11208 ACCOUNTS RECEIVABLE - OTHER 1,165,700.00 1,959,169.26 1,165,700.00 1,959,169.26
Total CURRENT ASSETS 9,290,148.51 13,797,373.47 11,683,377.06 11,404,144.92
Object Group 21000 -- CURRENT LIABILITIES
21101 ACCOUNTS PAYABLE 0.00 22,350.00 22,350.00 0.00
Total CURRENT LIABILITIES 0.00 22,350.00 22,350.00 0.00
Object Group 27000 -- FUND BALANCES
27001 FUND BALANCE 0.00 53,650.00 4,732,272.49 (4,678,622.49)
27202 RESERVE FOR ENCUMBRANCE 0.00 22,350.00 76,000.00 (53,650.00)
27304 DES FOR CURRENT CAPITAL PROJ.(4,732,272.49)4,732,272.49 0.00 0.00
27472 DESIGNATED FOR CIVIC CAMPUS (4,557,876.02)0.00 0.00 (4,557,876.02)
Total FUND BALANCES (9,290,148.51)4,808,272.49 4,808,272.49 (9,290,148.51)
Object Group 28000 -- CONTROL ACCOUNTS
28001 ENCUMBRANCES 0.00 76,000.00 76,000.00 0.00
28003 APPROPRIATION CONTROL 0.00 76,000.00 4,884,272.49 (4,808,272.49)
28004 BUDGETED FUND BALANCE 0.00 4,884,272.49 76,000.00 4,808,272.49
28005 REVENUE CONTROL 0.00 1,165,700.00 12,327,937.82 (11,162,237.82)
28006 EXPENDITURE CONTROL 0.00 10,517,677.06 1,469,435.65 9,048,241.41
Total CONTROL ACCOUNTS 0.00 16,719,649.55 18,833,645.96 (2,113,996.41)
Total MEASURE W 0.00 35,347,645.51 35,347,645.51 0.00
Total 0.00 35,347,645.51 35,347,645.51 0.00
ATTACHMENT 6