Loading...
HomeMy WebLinkAbout12.05.2018 @630 Regular Measure W COCWednesday, December 5, 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 December 5, 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, December 5, 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 meeting of October 3, 2018.1. Report regarding the Community Civic Campus quarterly update for Quarter 1 Fiscal Year 2018/19. (Marian Lee, Assistant City Manager and Dolores Montenegro, Kitchell Program Manager) 2. Report regarding a presentation of the draft Comprehensive Annual Finance Report for the fiscal year ended June 30, 2018 (Amber Coatney, Audit Supervisor, Maze and Associates) 3. Report transmitting Measure W Fiscal Year 2018-19 reports through October 31, 2018 (Richard Lee, Director of Finance) 4. Adjournment. Page 2CityofSouthSanFrancisco Printed on 1/17/2019 City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:18-1066 Agenda Date:12/5/2018 Version:1 Item #:1. Motion to approve the Minutes for the meeting of October 3, 2018. City of South San Francisco Printed on 11/30/2018Page1of1 powered by Legistar™ Call to Order. Time: 6:30 p.m. Roll Call. PRESENT: Chair William Zemke, Vice Chair Christine Wong, Committee Members Herman Alcalde, Mike Brosnan, and Luis Alberto Fernandez De Paz ABSENT: William Romero (alternate) PUBLIC COMMENTS Mina Richardson. MATTERS FOR CONSIDERATION 1. Motion to approve the Minutes from the meeting of April 4, 2018 and August 1, 2018. MOTION Chair Zemke moved and Committee Member Alcalde seconded a motion to approve the minutes. The question was called and the motion carried unanimously. 2. Presentation of audit overview by independent auditor. (Katherine Yuen, CPA, Vice President, Maze and Associates) Katherine Yuen presented an overview of the audit process and Measure W funds. Vice Chair Wong asked about the audit sampling and if Measure W was separated from the General Fund. Ms. Yuen explained the focus on income statements, confirmation of revenue fund, and selection of transactions for expenditures. She discussed the judgmental approach. MINUTES REGULAR MEETING MEASURE W CITIZENS’ OVERSIGHT COMMITTEE OF THE CITY OF SOUTH SAN FRANCISCO P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, California 94083 Meeting to be held at: MUNICIPAL SERVICES BUILDING COUNCIL CHAMBERS 33 ARROYO DRIVE SOUTH SAN FRANCISCO, CA WEDNESDAY, OCTOBER 3, 2018 6:30 p.m. REGULAR MEASURE W COC MEETING OCTOBER 3, 2018 MINUTES PAGE 2 Vice Chair Wong asked about internal controls and travel policies. Ms. Yuen explained that if a travel reimbursement was selected they would review the policy. In response to Chair Zemke, Ms. Yuen explained review of risk assessment and provided examples. 3. Report transmitting Measure W Fiscal Year 2017-18 year-end results. (Richard Lee, Director of Finance) Finance Director Richard Lee provided highlights on the Measure W Fiscal Year 2017-18 year-end results including Periods 13-16, California Department of Tax and Fee Administration, revenue and expenditures. In response to Committee Member Herman, City Manager Futrell discussed the Civic Campus design, estimated at $210 million. He stated the Fire Station would be completed when the existing building was sold. He stated the cost of designing the Fire Station was included. Chair Zemke asked about the four-month window for schematic design. City Manager Futrell indicated the design would be presented to the Council and the public on November 14, 2018. He stated the project was being designed to fall under the $210 million estimate. In response to Committee Member Herman, Finance Director Lee explained that the roll-over was $7.3 million and the cash balance was $9.4 million. Chair Zemke requested a bimonthly report of the on-hand amount. Finance Director Lee stated, as actuals came in, the cash projections were revised in the event bonding process could be delayed. Vice Chair Wong suggested correcting the date on the revenue report. Finance Director Lee explained the finance system nuance. Mina Richardson asked about the stage. City Manager Futrell explained that the Library, Parks and Recreation, and Community Theater was being designed so that, if the bids were over estimates, the theater construction could be postponed. He stated the Fire Department construction costs would be negotiated as part of the sale of City Hall. In response to Chair Zemke, City Manager Futrell discussed options for Council meetings if the theater was not built. ADJOURNMENT At 6:54 p.m., Chair Zemke adjourned the meeting. Submitted by: Approved by: Krista Martinelli, City Clerk William Zemke, Chairman City of South San Francisco City of South San Francisco City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:18-126 Agenda Date:12/5/2018 Version:1 Item #:2. Report regarding the Community Civic Campus quarterly update for Quarter 1 Fiscal Year 2018/19.(Marian Lee, Assistant City Manager and Dolores Montenegro, Kitchell Program Manager) RECOMMENDATION It is recommended that the Measure W Citizens’Oversight Committee receive this Quarter 1 Fiscal Year 2018/2019 report regarding the Community Civic Campus project. BACKGROUND/DISCUSSION This quarterly report was presented to City Council November 14, 2018. The staff report is attached. FISCAL IMPACT This item is informational and has no impact on the City budget. CONCLUSION The next quarterly update to the Citizens’ Oversight Committee will be presented in February 2019. City of South San Francisco Printed on 11/30/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-1062 Agenda Date:12/5/2018 Version:1 Item #:3. Report regarding a presentation of the draft Comprehensive Annual Finance Report for the fiscal year ended June 30, 2018 (Amber Coatney, Audit Supervisor, Maze and Associates) RECOMMENDATION This is an information item only. BACKGROUND/DISCUSSION Maze and Associates,the City of South San Francisco’s independent auditor,conducted a comprehensive audit of the City’s financial statements for the fiscal year ended June 30,2018 in accordance with U.S.generally accepted auditing standards. The auditor’s responsibilities include: Express an opinion about whether the financial statements are fairly presented; and Plan and perform the audit to obtain reasonable,but not absolute,assurance that the financial statements are free of material misstatement; The audit scope includes the following actions: 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 The auditors have completed their fieldwork,which included an interim audit in May 2018,followed by the final audit in October 2018.Attachment 1 provides excerpts from the draft Comprehensive Annual Financial Report (CAFR)for the fiscal year (FY)ended June 30,2018,that are within the Measure W Citizens’Oversight Committee’s purview. FISCAL IMPACT None CONCLUSION The information contained in the draft FY 2017-18 CAFR is consistent with the information presented to the Measure W Citizens’Oversight Committee throughout FY 2017-18.The independent audit was conducted in accordance with U.S.generally accepted auditing standards,and the CAFR was prepared in accordance with U.S. generally accepted accounting principles. City of South San Francisco Printed on 11/30/2018Page1of2 powered by Legistar™ File #:18-1062 Agenda Date:12/5/2018 Version:1 Item #:3. Attachments 1.Excerpts from FY 2017-18 CAFR 2.PowerPoint Presentation City of South San Francisco Printed on 11/30/2018Page2of2 powered by Legistar™ REVIEW DRAFT 11/30/2018 2:50 PM SUPPLEMENTARY INFORMATION ATTACHMENT 1 REVIEW DRAFT 11/30/2018 2:50 PM GENERAL FUND The General Fund is the City’s primary operating fund. It accounts for all financial resources of the general government, except those required to be accounted for in another fund. The General Fund is comprised of the following: GENERAL PURPOSE FUND This fund accounts for resources traditionally associated with government, such as administration, public safety, library, parks maintenance, and recreation, outside of those accounted for in other funds. MEASURE W FUND This fund accounts for revenue as the result of the voter-approved one-half percent sales and use tax. Revenues are committed for maintenance and enhancement of local services. General Purpose Measure W Total ASSETS Cash and investments $25,762,213 $11,885,837 $37,648,050 Receivables: Accounts 5,774,877 1,959,169 7,734,046 Accrued interest 213,239 213,239 Due from other funds 70,000 70,000 Inventory 106 106 Restricted cash and investments 200,000 200,000 Properties held for redevelopment 20,582,335 20,582,335 Total Assets $52,602,770 $13,845,006 $66,447,776 LIABILITIES Accounts payable $1,307,966 $1,307,966 Accrued salaries and benefits 3,027,256 3,027,256 Other payable 290,552 290,552 Deposits 411,025 411,025 Unearned revenue 124,085 124,085 Total Liabilities 5,160,884 5,160,884 FUND BALANCES Nonspendable 106 106 Restricted 20,582,335 20,582,335 Committed 2,934,541 $13,791,356 16,725,897 Assigned 4,280,672 53,650 4,334,322 Unassigned 19,644,232 19,644,232 Total Fund Balances 47,441,886 13,845,006 61,286,892 Total Liabilities and Fund Balances $52,602,770 $13,845,006 $66,447,776 CITY OF SOUTH SAN FRANCISCO GENERAL FUND COMBINING BALANCE SHEETS JUNE 30, 2018 Intra-Fund Transactions General Purpose Measure W Elimination Total REVENUES Property taxes $34,143,627 $34,143,627 Sales taxes 17,567,674 $11,162,238 28,729,912 Transient occupancy taxes 13,978,533 13,978,533 Franchise Fees 4,403,493 4,403,493 Other taxes 5,869,611 5,869,611 Intergovernmental 2,610,233 2,610,233 Interest and rentals 2,846,967 2,846,967 Licenses and permits 14,674,809 14,674,809 Charges for services 10,924,668 10,924,668 Fines and forfeitures 423,604 423,604 Other 266,872 266,872 Total Revenues 107,710,091 11,162,238 118,872,329 EXPENDITURES Current: City Council 239,264 239,264 City Clerk 660,306 660,306 City Treasurer 135,218 135,218 City Attorney 996,380 996,380 City Manager 2,668,715 22,351 2,691,066 Finance 3,080,769 3,080,769 Non-departmental 1,049,187 1,049,187 Human Resources 1,541,524 1,541,524 Fire 26,059,072 26,059,072 Police 26,639,009 26,639,009 Public Works 5,014,343 5,014,343 Parks and Recreation 15,468,370 15,468,370 Library 5,379,836 5,379,836 Economic and Community Development 7,722,689 7,722,689 Total Expenditures 96,654,682 22,351 96,677,033 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 11,055,409 11,139,887 22,195,296 OTHER FINANCING SOURCES (USES) Proceeds from sale of capital assets 3,990,605 3,990,605 Transfers in 6,269,262 (2,440,861) 3,828,401 Transfers out (13,732,838) (6,585,030) 2,440,861 (17,877,007) Total Other Financing Sources (Uses) (3,472,971) (6,585,030) (10,058,001) Net Change in Fund Balances before special items 7,582,438 4,554,857 12,137,295 Special Item (7,154,626) (7,154,626) Net Change in Fund Balances 427,812 4,982,669 Fund balances (deficits) - July 1 47,014,074 9,290,149 56,304,223 Fund balances (deficits) - June 30 $47,441,886 $13,845,006 $61,286,892 CITY OF SOUTH SAN FRANCISCO GENERAL FUND COMBINING SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES FOR THE YEAR ENDED JUNE 30, 2018 CITY OF SOUTH SAN FRANCISCO GENERAL FUND COMBINING SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (NON GAAP LEGAL BASIS) FOR THE YEAR ENDED JUNE 30, 2018 Variance with Final Budget Actual Positive Original Final Amount (Negative) Resources (inflows): Property taxes $26,877,714 $33,760,827 $34,143,627 $382,800 Sales taxes 16,279,876 16,279,876 17,567,674 1,287,798 Transient occupancy taxes 14,800,000 14,800,000 13,978,533 (821,467) Franchise fees 4,000,000 4,000,000 4,403,493 403,493 Other taxes 6,043,065 5,343,065 5,869,611 526,546 Intergovernmental 7,024,542 2,020,600 2,610,233 589,633 Interest and rentals 6,480,863 7,000,863 2,846,967 (4,153,896) Licenses and permits 9,232,477 10,232,477 14,674,809 4,442,332 Charges for services 8,934,001 9,329,002 10,924,668 1,595,666 Fines and forfeitures 818,500 163,500 423,604 260,104 Other 174,991 174,991 266,872 91,881 Amounts available for appropriation 100,666,029 103,105,201 107,710,091 4,604,890 Charges to appropriations (outflows) City Council 246,918 246,917 239,264 7,653 City Clerk 642,681 666,810 660,306 6,504 City Treasurer 130,861 130,861 135,218 (4,357) City Attorney 913,092 1,038,092 996,380 41,712 City Manager 1,960,599 3,091,257 2,861,732 229,525 Finance 2,595,665 3,365,768 3,423,017 (57,249) Non-departmental 1,080,967 1,108,503 1,107,187 1,316 Human Resources 1,625,221 1,675,257 1,698,958 (23,701) Fire 26,373,610 26,906,873 26,763,505 143,368 Police 27,864,737 27,654,237 26,639,009 1,015,228 Public Works 4,315,409 4,976,637 5,339,181 (362,544) Parks and Recreation 15,553,369 15,929,220 15,649,568 279,652 Library 5,361,133 5,575,195 5,394,725 180,470 Economic and Community Development 7,216,002 10,772,828 10,027,304 745,524 Total charges to appropriations 95,880,264 103,138,455 100,935,354 2,203,101 OTHER FINANCING SOURCES (USES) Proceeds from sale of capital assets 3,990,600 3,990,605 5 Transfers in 1,772,505 1,800,705 6,269,262 4,468,557 Transfers out (2,920,600) (6,592,401) (13,732,838) (7,140,437) Total Other Financing Sources (Uses) (1,148,095) (801,096) (3,472,971) (2,671,875) NET CHANGE IN FUND BALANCES BEFORE SPECIAL ITEMS 3,637,670 (834,350) 3,301,766 4,136,116 Special Item (7,154,626) (7,154,626) Net Change in Fund Balances $3,637,670 ($834,350) (3,852,860) ($3,018,510) Fund Balance - July 1 47,014,074 Adjustment to budgetary basis: Encumbrance adjustments 4,280,672 Fund Balance - June 30 $47,441,886 Budgeted Amounts General Purpose Variance with Variance with Final Budget Final Budget Actual Positive Actual Positive Original Final Amount (Negative) Original Final Amount (Negative) 26,877,714 $33,760,827 $34,143,627 $382,800 9,168,433 $9,168,433 $11,162,238 $1,993,805 25,448,309 25,448,309 28,729,912 3,281,603 14,800,000 14,800,000 13,978,533 (821,467) 4,000,000 4,000,000 4,403,493 403,493 6,043,065 5,343,065 5,869,611 526,546 7,024,542 2,020,600 2,610,233 589,633 6,480,863 7,000,863 2,846,967 (4,153,896) 9,232,477 10,232,477 14,674,809 4,442,332 8,934,001 9,329,002 10,924,668 1,595,666 818,500 163,500 423,604 260,104 174,991 174,991 266,872 91,881 9,168,433 9,168,433 11,162,238 1,993,805 109,834,462 112,273,634 118,872,329 6,598,695 246,918 246,917 239,264 7,653 642,681 666,810 660,306 6,504 130,861 130,861 135,218 (4,357) 913,092 1,038,092 996,380 41,712 76,000 76,001 (1) 1,960,599 3,167,257 2,937,733 229,524 2,595,665 3,365,768 3,423,017 (57,249) 1,080,967 1,108,503 1,107,187 1,316 1,625,221 1,675,257 1,698,958 (23,701) 2,440,861 2,440,861 2,440,861 28,814,471 29,347,734 26,763,505 2,584,229 27,864,737 27,654,237 26,639,009 1,015,228 4,315,409 4,976,637 5,339,181 (362,544) 15,553,369 15,929,220 15,649,568 279,652 5,361,133 5,575,195 5,394,725 180,470 7,216,002 10,772,828 10,027,304 745,524 2,440,861 2,516,861 76,001 2,440,860 98,321,125 105,655,316 101,011,355 4,643,961 3,990,600 3,990,605 5 1,772,505 1,800,705 6,269,262 4,468,557 9,168,433) (13,900,705) (6,585,030) 7,315,675 (12,089,033) (20,493,106) (20,317,868) 175,238 9,168,433) (13,900,705) (6,585,030) 7,315,675 (10,316,528) (14,701,801) (10,058,001) 4,643,800 2,440,861) (7,249,133) 4,501,207 11,750,340 1,196,809 (8,083,483) 7,802,973 15,886,456 7,154,626) (7,154,626) 2,440,861) ($7,249,133) 4,501,207 $11,750,340 $1,196,809 ($8,083,483) 648,347 $8,731,830 9,290,149 56,304,223 53,650 4,334,322 13,845,006 $61,286,892 Budgeted Amounts Budgeted Amounts Measure W Total Independent Auditor Presentation For fiscal year ended June 30, 2018 City of South San Francisco Amber Coatney Audit Supervisor 1 ATTACHMENT 2 Annual Audit Maze and Associates – independent of the City. Audit timing: Interim – May 2018 Final – October 2018 Audit to be completed – December 2018 2 Annual Audit (Continued) Audit was conducted according to: 1.Auditing standards generally accepted in the USA 2.Government Auditing Standards issued by the Comptroller General of the United States of America. 3 Result of Audit Unmodified (clean) opinion Fairly stated, in all material respects Conformity with accounting principles generally accepted (GAAP) in the USA 4 Measure W Financial Statements Balance Sheets Combining Schedule of Revenues, Expenditures, and Changes in Fund Balance Combing Schedule of Revenue, Expenditures, and Changes in Fund Balance – Budget and Actual 5 QUESTIONS? 6 We are in the business to help our clients succeed” City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:18-1063 Agenda Date:12/5/2018 Version:1 Item #:4. Report transmitting Measure W Fiscal Year 2018-19 reports through October 31,2018 (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 October 31, 2018 for Fiscal Year (FY) 2018-19. Attachment 1,the Fiscal Year (FY)2018-19 Measure W Revenue Detail Report,indicates that the City received 2,346,514 in revenue through October 31,2018,which accounts for the advances for July and August 2018 from the California Department of Tax and Fee Administration.As reflected in the revenue detail report and supporting documents,the advance for May 2018 in the amount of $806,092 and true up for the second quarter of 2018 in the amount of $1,153,078 were accrued for FY 2017-18. As indicated in Attachment 2,the adopted budget for FY 2018-19 includes $9,452,874 in total appropriations, primarily for support of the City’s capital improvement plan.Through October 31,2018,the City expended 1,207,923 in Measure W.As such,the total remaining budget for FY 2018-19 is $8,244,951.The Community Civic Campus project allocated $1,162,668 in cost to Measure W,and the Underground Utility District (UUD) for Antoinette Lane allocated $11,730 in cost.Project expense detail reports and supporting documentation are provided for the capital projects noted above via Attachment 3 and Attachment 4. The balance sheet report,included as Attachment 5,lists all assets,liabilities,and equities for Measure W,and reports a cash balance of $13,717,134 as of October 31, 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 2018-19 authorized appropriation limit. Attachments: 1.FY 2018-19 Measure W Revenue Detail October 2018 YTD 2.FY 2018-19 Measure W Expenditure Detail October 2018 YTD 3.FY 2018-19 Project pf1707 Transaction Detail October 2018 YTD 4.FY 2018-19 Project st1702 Transaction Detail October 2018 YTD City of South San Francisco Printed on 11/30/2018Page1of2 powered by Legistar™ File #:18-1063 Agenda Date:12/5/2018 Version:1 Item #:4. 5.FY 2018-19 Measure W Balance Sheet Report October 2018 YTD City of South San Francisco Printed on 11/30/2018Page2of2 powered by Legistar™ 11/28/2018 CITY OF SOUTH SAN FRANCISCO 1 4:46PM Page:revdetl.rpt Revenue Detail Report 07/01/2018 through 10/31/2018 Periods: 0 through 4 FY 2018-19 Measure W Revenue Detail Oct 2018 YTD 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,731,450.00 0.00 0.00 9,731,450.00 0.00 806,091.751017/24/2018 gl_crj CR 68290 Line Description: Measure W Sales Tax 806,091.751017/24/2018 acrul_r_je GJ 68210-R Line Description: FY17-18 Sales Tax-CA 1,153,077.511018/24/2018 gl_crj CR 68939 Line Description: Measure W Sales Tax 1,153,077.511018/24/2018 acrul_r_je GJ 68942-R Line Description: FY17-18 Sales Tax-CA 914,703.571019/24/2018 gl_crj CR 69320 Line Description: Measure W Sales Tax 1,431,810.1210110/24/2018 gl_crj CR 69910 Line Description: Measure W Sales Tax 101-00000-30207 MEASURE W AND USE TAX (0.5%) 2,346,513.69 2,346,513.69 24.119,731,450.00 7,384,936.31 Total MEASURE W 24.112,346,513.69 2,346,513.699,731,450.00 7,384,936.31 Grand Total 2,346,513.69 2,346,513.69 24.119,731,450.00 7,384,936.31 1Page: ATTACHMENT 1 1A 1B 1C 1D 1A 1B 1C 1D 11/28/2018 CITY OF SOUTH SAN FRANCISCO 1 6:29PM Page:expdetl.rpt Expenditure Detail Report 07/01/2018 through 10/31/2018 Periods: 0 through 4 FY 2018-19 Measure W Expenditures Oct 2018 YTD MEASUREW101 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 Total CAPITAL OUTAY 0.000.00 0.00 0.000.000.00 101-00000-9000 TRANSFERS Total TRANSFERS 0.000.00 0.00 0.000.000.00 0.000.00 0.00 0.00 0.000.00TotalNONEXPENSEACCT 101-01000 CITY COUNCIL 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 101-02000 CITY CLERK 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 101-03000 CITY TREASURER 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 101-04000 CITY ATTORNEY 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 101-05000 CITY MANAGER 101-05000-5000 SUPPLIES & SERVICES 101-05101-5005 PROFESSIONAL & SPECIALIZED SVCS 0.00 0.00 0.000.000.00 0.00 53,650.007/1/2018 budadj BA 2019-PO-OPEN 101LineDescription: Auto PO Open (0101942) Document Description : AUTO BUDGET ADJUSTMENT (OPENING PO'S) 1Page: ATTACHMENT 2 11/28/2018 CITY OF SOUTH SAN FRANCISCO 2 6:29PM Page:expdetl.rpt Expenditure Detail Report 07/01/2018 through 10/31/2018 Periods: 0 through 4 FY 2018-19 Measure W Expenditures Oct 2018 YTD MEASUREW101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used 101-05101-5005 PROFESSIONAL & SPECIALIZED SVCS (Continued) 11,175.009/6/2018 invoice IN PRG #SSF1803 101LineDescription: COMM CIV CAMPUS FUNDRAISING PR Document Description : COMM CIV CAMPUS FUNDRAISING PROG JULY 20 Vendor: 108252 PARTNERSHIP RESOURCES GROUP Check # 270440 11,175.009/6/2018 invoice IN PRG #SSF1804 101LineDescription: COMM CIV CAMPUS FUNDRAISING PR Document Description : COMM CIV CAMPUS, PRG FUNDRAISING CONSULT Vendor: 108252 PARTNERSHIP RESOURCES GROUP Check # 271118 11,175.0010/2/2018 invoice IN PRG #SSF1805 101LineDescription: COMMUNITY CIVIC CAMPUS FUNDRAI Document Description : COMM CIV CAMPUS, PRG FUNDRAISING CONSULT Vendor: 108252 PARTNERSHIP RESOURCES GROUP Check # 271118 33,525.00 33,525.00 62.49101-05101-5005 PROFESSIONAL & SPECIALIZED SVCS 0.00 20,125.0053,650.00 Total SUPPLIES & SERVICES 62.4933,525.00 0.00 20,125.0033,525.0053,650.00 62.4933,525.00 33,525.00 0.00 20,125.0053,650.00TotalCITYMANAGER 101-06000 FINANCE DEPARTMENT 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 101-07000 NON-DEPARTMENTAL 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 101-09000 HUMAN RESOURCES 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 101-10000 ECONOMIC & COMMUNITY DEVELOPMENT DEPT 101-10000-5000 SUPPLIES & SERVICES 2Page: 2A 2B 2C 11/28/2018 CITY OF SOUTH SAN FRANCISCO 3 6:29PM Page:expdetl.rpt Expenditure Detail Report 07/01/2018 through 10/31/2018 Periods: 0 through 4 FY 2018-19 Measure W Expenditures Oct 2018 YTD MEASUREW101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used Total SUPPLIES & SERVICES 0.00 0.00 0.000.00 0.00 0.00 0.000.00TotalECONOMIC & COMMUNITY DEVELOPMENT DEPT 101-11000 FIRE DEPARTMENT 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 101-12000 POLICE DEPARTMENT 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 101-13000 PUBLIC WORKS 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 101-15000 LIBRARY DEPARTMENT 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 101-16000 INFORMATION TECHNOLOGY DEPARTMENT 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 101-17000 PARKS & RECREATION DEPARTMENT 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 101-99000 CIP 101-99000-9000 TRANSFERS 101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV 0.00 0.00 9,399,224.000.009,399,224.00 0.00 3Page: 11/28/2018 CITY OF SOUTH SAN FRANCISCO 4 6:29PM Page:expdetl.rpt Expenditure Detail Report 07/01/2018 through 10/31/2018 Periods: 0 through 4 FY 2018-19 Measure W Expenditures Oct 2018 YTD MEASUREW101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used 101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV (Continued) 1,162,667.6510/31/2018 rev alloc GJ pf1707 101LineDescription: Project: pf1707 Allocation Document Description : Project: pf1707 Allocation 11,730.4910/31/2018 rev alloc GJ st1702 101LineDescription: Project: st1702 Allocation Document Description : Project: st1702 Allocation 1,174,398.14 1,174,398.14 12.49101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV 0.00 8,224,825.869,399,224.00 Total TRANSFERS 12.491,174,398.14 0.00 8,224,825.861,174,398.149,399,224.00 12.491,174,398.14 1,174,398.14 0.00 8,224,825.869,399,224.00TotalCIP 12.781,207,923.14 1,207,923.14 0.00 8,244,950.869,452,874.00TotalMEASUREW Grand Total 1,207,923.14 1,207,923.14 12.780.00 8,244,950.869,452,874.00 4Page: Refer to Attachment 3 Refer to Attachment 4 2A 2B 2C paTran Project Expense Transaction Detail Report Page: 1 11/28/2018 4:53PM CITY OF SOUTH SAN FRANCISCO 7/1/2018 through 10/31/2018 Project Number #pf1707 COMMUNITY CIVIC CAMPUS Hours Benefits Materials OtherTotalAccount #DescriptionReferenceDate Labor + Phase #100 PRELIMINARY STUDIES Ninyo and Moore Geotechical E 510-99995-5999 -71,000.00 -71,000.007/31/2018 69051-R COMM CIVIC CAMPUS, GEOTECHNICA E 510-99995-5999 71,000.00 71,000.008/15/2018 219345 104960 NINYO AND MOORE GEOTECHNICAL Check: 270010 8/22/2018 Phase Total:100 PRELIMINARY STUDIES 0.00 0.00 0.00 0.00 0.00 Phase #110 DESIGN COMM CIVIC CAMPUS NEWSLTR CITY E 510-99995-5999 983.25 983.259/24/2018 133903 099812 ESSENCE PRINTING, INC Check: 270807 9/26/2018 FY 2017-18 allotment~E 510-99995-5999 334,433.13 334,433.1310/26/2018 0133026 107999 SMITHGROUPJJR INC Check: 271596 10/31/2018 FY 2017-18 allotment~E 510-99995-5999 665,002.11 665,002.1110/26/2018 0133624 107999 SMITHGROUPJJR INC Check: 271596 10/31/2018 Phase Total:110 DESIGN 0.00 0.00 983.25 999,435.24 1,000,418.49 Phase #160 PROJECT MANAGEMENT PERMIT FEES FOR BART TUNNEL SU E 510-99995-5999 15,000.00 15,000.007/18/2018 W-19.5-002-SSF 021558 SAN FRANICSCO BAY AREA RAPID Check: 269282 7/25/2018 COMM CIV CAMPUS KITCHELL PROJ E 510-99995-5999 49,987.00 49,987.008/16/2018 80019 106730 KITCHELL CEM Check: 269932 8/17/2018 MIKE FUTRELL -- CREDIT CARD PU E 510-99995-5999 25.15 25.159/5/2018 cc378413 000310 FEDEX Check: 270349 9/7/2018 FY2016-17 APPROVED CONSULTANT E 510-99995-5999 49,165.00 49,165.009/24/2018 80536 106730 KITCHELL CEM Check: 270877 9/28/2018 LESLIE ARROYO -- CREDIT CARD P E 510-99995-5999 450.00 450.0010/22/2018 cc381115 105406 DGI Check: 271605 10/31/2018 LESLIE ARROYO -- CREDIT CARD P E 510-99995-5999 97.01 97.0110/22/2018 cc381116 108067 AMERICAN LANGUAGE SERVICE Check: 271605 10/31/2018 LESLIE ARROYO -- CREDIT CARD P E 510-99995-5999 160.00 160.0010/22/2018 cc381117 105406 DGI Check: 271605 10/31/2018 FY2016-17 APPROVED CONSULTANT E 510-99995-5999 47,365.00 47,365.0010/26/2018 81137 106730 KITCHELL CEM Check: 271574 10/31/2018 Phase Total:160 PROJECT MANAGEMENT 0.00 0.00 15,732.16 146,517.00 162,249.16 Project Number Total:pf1707 COMMUNITY CIVIC CAMPUS 0.00 0.00 16,715.41 1,145,952.24 1,162,667.65 1Page: ATTACHMENT 3 3A 3B 3C 3D 3E 3F 3G 3H 3I 3J 3K 3L Page 1 of 54 paTran Project Expense Transaction Detail Report Page: 2 11/28/2018 4:53PM CITY OF SOUTH SAN FRANCISCO 7/1/2018 through 10/31/2018 GRAND TOTAL: 0.00 0.00 16,715.41 1,145,952.24 1,162,667.65 2Page:Page 2 of 54 3A Page 3 of 54 Page 4 of 54 Page 5 of 54 3B Page 6 of 54 Page 7 of 54 3C Page 8 of 54 Page 9 of 54 Page 10 of 54 Page 11 of 54 Page 12 of 54 Page 13 of 54 3D Page 14 of 54 Page 15 of 54 Page 16 of 54 Page 17 of 54 Page 18 of 54 Page 19 of 54 3E Page 20 of 54 3F Page 21 of 54 Page 22 of 54 Page 23 of 54 Page 24 of 54 Page 25 of 54 Page 26 of 54 Page 27 of 54 Page 28 of 54 3G Page 29 of 54 Page 30 of 54 Page 31 of 54 Page 32 of 54 Page 33 of 54 Page 34 of 54 Page 35 of 54 Page 36 of 54 Invoice Approval (IA) - 1 Project: Community Civic Campus Project Number: pf1707 Process Document: IA - 1 Overall Due Date: Current Workflow Step: Finance Approval Step Due Date: Subject: Kitchell CEM - 80536 Status: Approved Invoice Information Compile all backup documentation into one PDF file. Attach PDF document to Invoice Documentation data field. Vendor Invoice Number: 80536 Vendor Invoice Date: 09.07.2018 Period From: 07.30.2018 Period To: 08.26.2018 Invoice Documentation: KITCHELL Inv 80536 dtd 9.7.18.pdf Tracking Info CM Signature: Dolores Montenegro CM Approval Date: 09.11.2018 PM Signature: Marian Lee PM Approval Date: 09.12.2018 Division Manager Signature: Richard Cho Division Manager Approval Date: 09.12.2018 Director Signature: Eunejune Kim Director Approval Date: 09.21.2018 Finance Info Check Number: Check Date: Check Amount: 0 3H Page 37 of 54 Commitment Invoice Details Status: Approved Approved: 09.21.2018 (Eunejune Kim) Commitment: 0101597 - FY16-17 CONSULTANT SVCS-CIVIC CTR- MEASURE W Company/Contact: Kitchell CEM Date Received: 09.07.2018 Date Due: 10.07.2018 Commitment Invoice Custom Fields Migrated: No Invoice Items Commitment Item # Description Budget Line Item Funding Rule Invoiced To Date Retained To Date Invoice Amount Retainage Percent Retained This Invoice 1 Contract Amount 100- 040 MeasureW- 100 639,008.00 0.00 49,165.00 0.00% 0.00 Totals 639,008.00 0.00 49,165.00 0.00 Attached Documents File Name Attached By Date Attached Step KITCHELL Inv 80536 dtd 9.7.18.pdf Sanders, Renee City of South San Francisco) 09.10.2018 Start Page 38 of 54 Page 39 of 54 Page 40 of 54 Page 41 of 54 Page 42 of 54 Page 43 of 54 Page 44 of 54 Page 45 of 54 3I Page 46 of 54 3J Page 47 of 54 3K Page 48 of 54 3L Page 49 of 54 Page 50 of 54 Page 51 of 54 Page 52 of 54 Page 53 of 54 Page 54 of 54 paTran Project Expense Transaction Detail Report Page: 1 11/28/2018 4:55PM CITY OF SOUTH SAN FRANCISCO 7/1/2018 through 10/31/2018 Project Number #st1702 UUD RULE 20A ANTOINETTE LN Hours Benefits Materials OtherTotalAccount #DescriptionReferenceDate Labor + Phase #100 PRELIMINARY STUDIES 13) co#13 OPEN line for Antoi E 510-99999-5999 45,600.00 45,600.009/7/2018 14100038-48 104472 SWINERTON MGMT & CONSULTING Check: 270568 9/14/2018 Phase Total:100 PRELIMINARY STUDIES 0.00 0.00 0.00 45,600.00 45,600.00 Phase #110 DESIGN Antoinette Lane Underground Ut E 510-99999-5999 31,304.00 31,304.008/23/2018 17095-C 107372 BELLECCI & ASSOCIATES, INC.Check: 270053 8/27/2018 2018-E4: Mission Street Underg E 510-99999-5999 14,030.00 14,030.0010/18/2018 17100055-3 104472 SWINERTON MGMT & CONSULTING Check: 271333 10/19/2018 Phase Total:110 DESIGN 0.00 0.00 0.00 45,334.00 45,334.00 Project Number Total:st1702 UUD RULE 20A ANTOINETTE LN 0.00 0.00 0.00 90,934.00 90,934.00 GRAND TOTAL: 0.00 0.00 0.00 90,934.00 90,934.00 1Page: ATTACHMENT 4 4A 4B 4C Page 1 of 11 4A Page 2 of 11 Page 3 of 11 Invoice Approval (IA) - 1 Project: Underground Utility District- Rule 20A (Antoinette) Project Number: st1702 Process Document: IA - 1 Overall Due Date: Current Workflow Step: Finance Approval Step Due Date: Subject: BELLECCI & ASSOCIATES, INC. - 17095-C Status: Approved Invoice Information Compile all backup documentation into one PDF file. Attach PDF document to Invoice Documentation data field. Vendor Invoice Number: 17095-C Vendor Invoice Date: 08.14.2018 Period From: 10.16.2017 Period To: 07.01.2018 Invoice Documentation: Bellecci Invoice 17095-C.pdf Tracking Info CM Signature: Peter Vorametsanti CM Approval Date: 08.21.2018 PM Signature: Richard Cho PM Approval Date: 08.21.2018 Division Manager Signature: Richard Cho Division Manager Approval Date: 08.23.2018 Director Signature: Justin Lovell Director Approval Date: 08.23.2018 4B Page 4 of 11 Finance Info Check Number: Check Date: Check Amount: 0 Commitment Invoice Details Status: Approved Approved: 08.23.2018 (Justin Lovell) Commitment: 0101695 - ANTOINETTE LANE UNDERGROUND UTILITY DISTRICT Company/Contact: BELLECCI & ASSOCIATES, INC. Date Received: 08.20.2018 Date Due: Commitment Invoice Custom Fields Migrated: No Invoice Items Commitment Item # Description Budget Line Item Funding Rule Invoiced To Date Retained To Date Invoice Amount Retainage Percent Retained This Invoice 1 Contract Amount 110- 040 Rule 20A- Local Match Split 64,243.00 0.00 31,304.00 0.00% 0.00 Totals 64,243.00 0.00 31,304.00 0.00 Attached Documents File Name Attached By Date Attached Step Bellecci Invoice 17095-C.pdf Jung, Kari City of South San Francisco) 08.20.2018 Start Page 5 of 11 Page 6 of 11 Page 7 of 11 Page 8 of 11 Invoice Approval (IA) - 2 Project: Underground Utility District- Rule 20A (Antoinette) Project Number: st1702 Process Document: IA - 2 Overall Due Date: Current Workflow Step: Finance Approval Step Due Date: Subject: SWINERTON MGMT & CONSULTING - 17100055-3 Status: Approved Invoice Information Compile all backup documentation into one PDF file. Attach PDF document to Invoice Documentation data field. Vendor Invoice Number: 17100055-3 Vendor Invoice Date: 10.04.2018 Period From: 09.01.2018 Period To: 09.30.2018 Invoice Documentation: Swinerton Invoice 17100055-3.pdf Tracking Info CM Signature: Peter Vorametsanti CM Approval Date: 10.05.2018 PM Signature: Matthew Ruble PM Approval Date: 10.09.2018 Division Manager Signature: Richard Cho Division Manager Approval Date: 10.09.2018 Director Signature: Eunejune Kim Director Approval Date: 10.18.2018 Page 9 of 11 Finance Info Check Number: Check Date: Check Amount: 0 Commitment Invoice Details Status: Approved Approved: 10.18.2018 (Eunejune Kim) Commitment: 0101838 - ON CALL RESO 141- 2017 MULTI-DISCIPLINARY ENGINEERING SERVICES FY 17- 18 Company/Contact: SWINERTON MGMT & CONSULTING Date Received: 10.04.2018 Date Due: Commitment Invoice Custom Fields Migrated: No Invoice Items Commitment Item # Description Budget Line Item Funding Rule Invoiced To Date Retained To Date Invoice Amount Retainage Percent Retained This Invoice 1 Project Management Prelim Studies) 100- 030 Rule 20A- Measure W 43,430.00 0.00 14,030.00 0.00% 0.00 Totals 43,430.00 0.00 14,030.00 0.00 Attached Documents File Name Attached By Date Attached Step Swinerton Invoice 17100055-3.pdf Jung, Kari-Admin City of South San Francisco) 10.04.2018 Start Page 10 of 11 4C Page 11 of 11 General Ledger Balances Criteria: As Of = 10/31/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 9,444,975.66 4,305,682.95 33,525.00 13,717,133.61 11208 ACCOUNTS RECEIVABLE - OTHER 1,959,169.26 -1,959,169.26 - Total CURRENT ASSETS 11,404,144.92 4,305,682.95 1,992,694.26 13,717,133.61 Object Group 21000 -- CURRENT LIABILITIES 21101 ACCOUNTS PAYABLE -33,525.00 33,525.00 - Total CURRENT LIABILITIES -33,525.00 33,525.00 - Object Group 27000 -- FUND BALANCES 27001 FUND BALANCE --7,369,335.08 (7,369,335.08) 27202 RESERVE FOR ENCUMBRANCE (53,650.00) 33,525.00 -(20,125.00) 27304 DES FOR CURRENT CAPITAL PROJ.(7,315,685.08) 7,315,685.08 -- 27472 DESIGNATED FOR CIVIC CAMPUS (4,034,809.84) --(4,034,809.84) Total FUND BALANCES (7,369,335.08)7,349,210.08 7,369,335.08 (7,389,460.08) Object Group 28000 -- CONTROL ACCOUNTS 28001 ENCUMBRANCES -53,650.00 33,525.00 20,125.00 28003 APPROPRIATION CONTROL --53,650.00 (53,650.00) 28004 BUDGETED FUND BALANCE -53,650.00 -53,650.00 28005 REVENUE CONTROL -1,959,169.26 4,305,682.95 (2,346,513.69) 28006 EXPENDITURE CONTROL -33,525.00 -33,525.00 Total CONTROL ACCOUNTS -2,099,994.26 4,392,857.95 (2,292,863.69) Total MEASURE W -13,788,412.29 13,788,412.29 (0.00) Total -13,788,412.29 13,788,412.29 (0.00) ATTACHMENT 5