Loading...
HomeMy WebLinkAbout04.03.2019 @630 Regular Measure W COCWednesday, April 3, 2019 6:30 PM City of South San Francisco P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA City Hall, City Manager's Conference Room 400 Grand Avenue, South San Francisco, CA Measure W Citizens' Oversight Committee Regular Meeting Agenda 1 April 3, 2019Measure 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 Franciscco will hold a Regular Meeting on Wednesday, April 3, 2019 at 6:30 p.m., in the City Manager's Conference Room, City Hall, 400 Grand Avenue, South San Francisco, California. Call To Order. Roll Call. Public Comments. MATTERS FOR CONSIDERATION Motion to approve the Minutes from the meeting of February 6, 2019.1. Report regarding upcoming bond process for the Community Civic Campus. (Justin Lovell, Financial Services Manager) 2. Report transmitting Measure W Fiscal Year 2018-19 financial reports as of February 28, 2019. (Justin Lovell, Financial Services Manager) 3. Adjournment. Page 2 City of South San Francisco Printed on 1/5/2024 2 City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:19-292 Agenda Date:4/3/2019 Version:1 Item #:1. Motion to approve the Minutes from the meeting of February 6, 2019. City of South San Francisco Printed on 1/5/2024Page 1 of 1 powered by Legistar™3 Call to Order. Time: 6:31 p.m. Roll Call. PRESENT: Chair William Zemke, Vice Chair Christine Wong, Committee Members Mike Brosnan and Luis Alberto Fernandez De Paz. ABSENT: Committee Member Herman Alcalde PUBLIC COMMENTS None. MATTERS FOR CONSIDERATION 1.Motion to approve the Minutes from the meeting of December 5, 2018. Vice Chair Wong questioned minute note consistency. In response to Vice Chair Wong, Assistant City Manager Marian Lee stated that the committee meetings are shifting to a shorter version of the minutes accompanied by a recording. MOTION Committee Member Mike Brosnan moved and Vice Chair Wong seconded a motion to approve the minutes. The motion carried unanimously. 2.Report regarding the Community Civic Campus quarterly update for Quarter 2 Fiscal Year 2018-19. (Marian Lee, Assistant City Manager) Assistant City Manager Marian Lee and Kitchell Program Manager Dolores Montenegro presented on program management and schematic design and answered questions from the Committee Members. 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: CITY HALL CITY MANAGER'S CONFERENCE ROOM 400 GRAND AVENUE SOUTH SAN FRANCISCO, CA WEDNESDAY, FEBRUARY 6, 2019 6:30 p.m. 4 REGULAR MEASURE W COC MEETING MINUTES February 6, 2019 PAGE 2 Assistant City Manager Lee summarized prior meeting and progress made, including agreements and resolutions to previously address issues. Referencing Attachment 3, a little more than $700,000.00 has been spent this quarter, most on schematic design. On the last page of the same attachment is the list of active contracts. Chair Zemke questioned how the City will manage neighborhood parking. In response to Chair Zemke, Assistant City Manager Lee discussed the plan to come up with a parking management strategy when schematic design is completed. Assistant City Manager Lee discussed the change in building design due to PG&E, BART, and SFPUC Water Easement and grants to fund the 80ft x 120ft turf sized for casual play and playground. Council member Brosnan raised concerns regarding traffic. Assistant City Manager Lee acknowledged concerns and need for community meetings and discussed vehicle circulation and foot traffic. Assistant City Manager Lee discussed area plan, time line and key dates. Report transmitting Measure W Fiscal Year 2018-19 financial reports as of December 31, 2018. (Justin Lovell, Acting Financial Services Manager) 3. Acting Financial Services Manager Justin Lovell will be taking the place for Richard Lee. Acting Financial Services Manager Lovell presented the report, including; Revenue Detail, Amended Budget for the Expenditures, Project Expenses Allocated, Additional Project Detail, Balance Sheet, and a Summary/Life to Date as requested. Chair Zemke questioned bonding. In response to Chair Zemke, Acting Financial Services Manager explained the project schedule. Vice Chair Wong questioned numbers on Attachment 6. Acting Financial Services Manager Lovell indicated that he would double check. Assistant City Manager Lee explained that Attachment 6 does not include paving and suggested working on formatting. Acting Financial Services Manager Lovell will provide a more detailed, life to date report. Committee discussed bonding and fund raising. 5 REGULAR MEASURE W COC MEETING MINUTES February 6, 2019 PAGE 3 ADJOURNMENT At 7:46 p.m., Chair Zemke adjourned the meeting. Submitted by: Approved by: William Zemke, Chairman Amanda Parker, Administrative Assistant II City of South San Francisco City of South San Francisco 6 City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:19-276 Agenda Date:4/3/2019 Version:1 Item #:2. Report regarding upcoming bond process for the Community Civic Campus.(Justin Lovell,Financial Services Manager) RECOMMENDATION No formal action is needed. The report is for information only. BACKGROUND/DISCUSSION Bonding Process The purpose of this memo is to introduce bond issuance in relation to Measure W and the Community Civic Campus.It will also provide an outline for the next steps in the process of the bond issuance.As an overview, Measure W was approved by voters as a half-cent sales tax in November of 2015.The tax became effective April 1,2016 and has a 30 year term.The Measure W sales tax revenue is used to maintain and enhance locally controlled City services, including the Paving Program and funding the Community Civic Campus. The Community Civic Campus includes design and construction of a new Library,Park and Recreation facility and a new Police station.Construction of the first phase is slated to begin in January 2020 with the Police station.A majority of the construction costs of the Civic Campus will be funded through the issuance of lease revenue bonds or certificate of participation.These bonds will be secured by a pledge of lease payments in respect to an essential asset that is owned by the City.In this case,the leased asset is expected to be the Civic Campus itself and the City’s General Fund will be pledged to make lease payments.More specifically Measure W sales tax revenue will be used as the budgetary source of payments. Staff has been working with the City’s financial advisor,PFM Financial Advisors LLC (PFM),to provide analysis and bonding capacity based on revenue from the Measure W tax.With the project nearing construction the City will begin the first steps in the bond issuance process.The process typically takes four to five months to complete.The key steps in the financing process include the selection of the financing team, drafting of legal and disclosure documents, City Council approval and obtaining credit ratings. Below outlines the projected timeline: Late April Select financing team participants Late April Begin draft of legal and disclosure documents May-June Legal and disclosure document review Mid July Credit rating agency meetings Late July City council approval Early August Distribute offering document to investors Mid-August Bond pricing Early Sept Bond closing In keeping with the above timeline the requests for proposals for underwriters and disclosure/bond counsel have been posted to the City website and distributed for direct solicitation to eleven firms for underwriting and City of South San Francisco Printed on 1/5/2024Page 1 of 2 powered by Legistar™7 File #:19-276 Agenda Date:4/3/2019 Version:1 Item #:2. seven firms for bond and disclosure counsel. Preliminary Funding Plan All estimates are preliminary numbers.Staff continues to evaluate Measure W projections and the funding plan will require ongoing updates leading up to bond issuance.The total project cost is $210.0 million.The preliminary funding plan for the project is as follows: ·Measure W Cash $71.4 million ·2019 Bond Proceeds $115.0 million ·Other Local Sources $23.6 million Measure W Cash is the revenue from inception of tax through anticipated project completion.2019 Bond Proceeds is estimated bond funds available for project costs,net of capitalized interest and transaction costs. Other local sources includes estimated funding sources such as public safety impact fee,donations, infrastructure reserves and other funds. This amount includes a funding gap. The Bond issuance total is estimated at $149.7 million at this time.$115.0 million is for the project.The remaining $34.7 million is for the following: ·Capitalized Interest $28.3 million is set aside to pay interest on the bonds while the project is in construction. ·Insurance &Surety Premium $5.0 million is the third party cost to insure the timely payment of debt service and purchase a surety policy in-lieu of the City maintaining a cash debt service reserve fund. ·Underwriter’s Discount $1.1 million is the cost paid to the underwriters for selling the bonds to investors on behalf of the City. ·Costs of Issuance $0.3 million is the cost paid to financial advisors,bond counsel,disclosure counsel, rating agencies, and other ancillary costs associated with the sale of the bonds. After construction is complete,the City will begin making debt service payments.The estimated total principal amount is $149.7 million and the total interest amount is $132 million. Staff and consultant will present to the committee members at the meeting.Attached is preliminary detailed information about the project funding and bonding assumptions.Please know that this information will continuously be updated until bond issuance. FISCAL IMPACT None at this time. This is an information item. CONCLUSION This is an information item to update the committee members regarding the bonding process and preliminary assumptions related to the Community Civic Campus. Attachment: Preliminary Project Funding and Bonding Assumptions City of South San Francisco Printed on 1/5/2024Page 2 of 2 powered by Legistar™8 Funding Sources for Community Civic Campus 1 ❑The Community Civic Campus is being funded by a combination of Measure W cash collections and bond proceeds Total Project Costs:$210,000,000 Funding Sources: Measure W Cash(1)$ 71,380,951 2019 Bond Proceeds(2)115,000,000 [Other Local Sources]23,619,049 Total Funding Sources:$210,000,000 (1) Measure W revenue from inception of tax through project completion. (2) Estimated bond funds available for project costs, net of capitalized interest and transaction costs. 9 Bond Financing Sources and Uses 2 ❑The City anticipates issuing approximately $149.7 million of bonds for the Community Civic Campus, to be used as follows: Sources: Par Amount of Bonds:$149,715,000 Uses: Project Fund $115,000,000 Capitalized Interest 28,270,086 Bond Insurance & Surety Premium 5,021,543 Underwriter’s Discount 1,122,863 Costs of Issuance 300,508 Total Uses:$149,715,000 Note: Assumes current market rates plus a cushion for potential interest rate movement prior to issuance. 10 Financing Process & Schedule 3 ❑The lease revenue bond/COP financing process typically takes four to five months to complete ❑Key steps include the selection of the financing team, drafting of legal and disclosure documents, City Council approval, and obtaining credit ratings Date Event Late April •Select financing team participants •Begin drafting of legal and disclosure documents May through June •Legal and disclosure document drafting and review Mid-July •Rating agency meetings Late July •City Council approval •Receive ratings Early August •Distribute offering document to investors Mid-August •Bond Pricing Early September •Bond Closing 11 Questions? 12 City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:19-274 Agenda Date:4/3/2019 Version:1 Item #:3. Report transmitting Measure W Fiscal Year 2018-19 financial reports as of February 28,2019.(Justin Lovell, Financial Services Manager) RECOMMENDATION No formal action is needed. The report is for information only. BACKGROUND/DISCUSSION Attached for the Measure W Citizens’Oversight Committee’s information are Measure W financial reports through February 28, 2019 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,296,406 in revenue in January 2019 and February 2019,which accounts for the November 2018 advance and the second quarter clean-up from the California Department of Tax and Fee Administration. As indicated in Attachment 2,the amended budget for FY 2018-19 includes $16,768,598 in total appropriations,primarily for support of the City’s capital improvement plan.Through February 28,2019,the City expended $1,294,226 in Measure W. As such, the total remaining budget for FY 2018-19 is $13,008,971. For the months of January and February 2019,the Community Civic Campus project allocated $1,258,968 in costs to Measure W,and the Street Rehabilitation Program allocated $32,576 in cost that were incurred prior to February 2019.Project expense detail reports and supporting documentation are provided for the capital projects noted above via Attachments 3, 4 and 5. The balance sheet report,included as Attachment 6,lists all assets,liabilities,and equities for Measure W,and reports a cash balance of $16,500,961 as of February 28, 2019. As requested by the Measure W Citizen’s Oversight Committee,Attachment 7 summarizes the Measure W life- to-date revenues and expenditures through February 28, 2019. 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 February 2019 YTD 2.FY 2018-19 Measure W Expenditure Detail February 2019 YTD 3.FY 2018-19 Project pf1707 Transaction Detail February 2019 YTD 4.FY 2018-19 Project st1903 Transaction Detail February 2019 YTD City of South San Francisco Printed on 1/5/2024Page 1 of 2 powered by Legistar™13 File #:19-274 Agenda Date:4/3/2019 Version:1 Item #:3. 5.FY 2018-19 Project st1702 Transaction Detail February 2019 YTD 6.FY 2018-19 Measure W Balance Sheet Report February 2019 YTD 7.Measure W Life-to-date Revenues and Expenditures. City of South San Francisco Printed on 1/5/2024Page 2 of 2 powered by Legistar™14 03/22/2019 CITY OF SOUTH SAN FRANCISCO 1 1:27PM Page:revdetl.rpt Revenue Detail Report 01/01/2019 through 02/28/2019 Periods: 7 through 8 FY 2018-19 Measure W Revenue Detail Feb 2019 YTD 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,731,450.00 0.00 4,380,466.37 5,350,983.63 45.01 971,690.09 1011/24/2019 gl_crj CR 70607 Line Description: Measure W Sales Tax 1,324,726.06 1012/25/2019 gl_crj CR 70801 Line Description: Measure W Sales Tax 101-00000-30207 MEASURE W AND USE TAX (0.5%) 2,296,416.15 6,676,882.52 68.619,731,450.00 3,054,567.48 Total MEASURE W 68.612,296,416.15 6,676,882.529,731,450.00 3,054,567.48 Grand Total 2,296,416.15 6,676,882.52 68.619,731,450.00 3,054,567.48 1Page: 15 03/25/2019 CITY OF SOUTH SAN FRANCISCO 1 9:32AM Page:expdetl.rpt Expenditure Detail Report 01/01/2019 through 02/28/2019 Periods: 7 through 8 MEASURE W101 Account Number Adjusted Appropriation Expenditures Year-to-date Expenditures Year-to-date Encumbrances Balance Prct Used 101-5000 SUPPLIES & SERVICES 101-01101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-02101-5021 OPERATING SUPPLIES 0.00 0.00 0.000.000.00 0.00 101-02101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-03101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-04101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 40,975.000.00101-05101-5005 PROFESSIONAL & SPECIALIZED SVCS 12,675.0053,650.00 0.00 100.00 101-05101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-06101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-07101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-09101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-10101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-11101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-12101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-13101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-15101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-16101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 101-17101-5999 PROJ ACCT SUPPLIES & SCVS 0.00 0.00 0.000.000.00 0.00 100.000.00 40,975.00 12,675.00 0.0053,650.00Total SUPPLIES & SERVICES 101-6000 CAPITAL OUTAY 101-00000-6001 LAND 0.00 0.00 0.000.000.00 0.00 0.000.00 0.00 0.00 0.000.00Total CAPITAL OUTAY 101-9000 TRANSFERS 101-00000-9100 TRANSFER OUT TO GENERAL FUND 0.00 0.00 0.000.000.00 0.00 1,539,891.110.00101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV 0.0016,714,909.08 15,175,017.97 9.21 1,258,968.60 2/28/2019 rev alloc GJ pf1707 2,681.91 2/28/2019 rev alloc GJ st1702 32,576.44 2/28/2019 rev alloc GJ st1705 1,294,226.95 2,834,118.06 16.96101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV 0.00 13,880,791.0216,714,909.08 16.961,294,226.95 2,834,118.06 0.00 13,880,791.0216,714,909.08Total TRANSFERS 17.221,294,226.95 2,875,093.06 12,675.00 13,880,791.0216,768,559.08Total MEASURE W 1Page: 16 03/25/2019 CITY OF SOUTH SAN FRANCISCO 2 9:32AM Page:expdetl.rpt Expenditure Detail Report 01/01/2019 through 02/28/2019 Periods: 7 through 8 Grand Total 1,294,226.95 2,875,093.06 17.2212,675.00 13,880,791.0216,768,559.08 2Page: 17 paTran Project Expense Transaction Detail Report Page: 1 3/22/2019 2:42PM CITY OF SOUTH SAN FRANCISCO 1/1/2019 through 2/28/2019 Project Number pf1707 COMMUNITY CIVIC CAMPUS Benefits Encumbrances Materials Other TotalAccount #DescriptionReferenceDate Labor + Phase # 100 PRELIMINARY STUDIES Task # 600 CONTRACT/CONSULTANT SERVICES FIRST AMENDEMENT TO COND E 510-99995-5999 17,717.611/30/2019 0102110 Task Total: 600 0.00 17,717.61 0.00 0.00 0.00CONTRACT/CONSULTANT SERVICES Phase Total: 100 PRELIMINARY STUDIES 0.00 17,717.61 0.00 0.00 0.00 Phase # 110 DESIGN Task # 600 CONTRACT/CONSULTANT SERVICES FY 2017-18 allotment~ E 510-99995-5999 600,724.00 600,724.001/16/2019 0134217 107999 SMITHGROUPJJR INC Check: 273324 1/18/2019 FY 2017-18 allotment~ E 510-99995-5999 -600,724.001/16/2019 0134217 FY 2017-18 allotment~ E 510-99995-5999 343,274.94 343,274.941/16/2019 0135278 107999 SMITHGROUPJJR INC Check: 273324 1/18/2019 FY 2017-18 allotment~ E 510-99995-5999 -343,274.941/16/2019 0135278 FY 2017-18 allotment~ E 510-99995-5999 238,534.40 238,534.401/31/2019 0132350 107999 SMITHGROUPJJR INC Check: 273617 2/1/2019 FY 2017-18 allotment~ E 510-99995-5999 -238,534.401/31/2019 0132350 pf1707: Community Civic Campus E 510-99995-5999 7,450.00 7,450.002/12/2019 PRG #SSF1807 108252 PARTNERSHIP RESOURCES GROUP Check: 273909 2/13/2019 pf1707: Community Civic Campus E 510-99995-5999 766.26 766.262/12/2019 PRG #SSF1901E 108252 PARTNERSHIP RESOURCES GROUP Check: 273909 2/13/2019 pf1707: Community Civic Campus E 510-99995-5999 7,450.00 7,450.002/12/2019 PRG #SSF1901R 108252 PARTNERSHIP RESOURCES GROUP Check: 273909 2/13/2019 Task Total: 600 0.00 -1,182,533.34 0.00 1,198,199.60 1,198,199.60CONTRACT/CONSULTANT SERVICES Phase Total: 110 DESIGN 0.00 -1,182,533.34 0.00 1,198,199.60 1,198,199.60 Phase # 160 PROJECT MANAGEMENT Task # 600 CONTRACT/CONSULTANT SERVICES FY2016-17 APPROVED CONSUL E 510-99995-5999 60,769.00 60,769.002/7/2019 82279 106730 KITCHELL CEM Check: 273758 2/8/2019 FY2016-17 APPROVED CONSUL E 510-99995-5999 -60,769.002/7/2019 82279 Task Total: 600 0.00 -60,769.00 0.00 60,769.00 60,769.00CONTRACT/CONSULTANT SERVICES Phase Total: 160 PROJECT MANAGEMENT 0.00 -60,769.00 0.00 60,769.00 60,769.00 1Page:18 paTran Project Expense Transaction Detail Report Page: 2 3/22/2019 2:42PM CITY OF SOUTH SAN FRANCISCO 1/1/2019 through 2/28/2019 Project Number Total:pf1707 COMMUNITY CIVIC CAMPUS 0.00 -1,225,584.73 0.00 1,258,968.60 1,258,968.60 GRAND TOTAL: 0.00 -1,225,584.73 0.00 1,258,968.60 1,258,968.60 2Page:19 Invoice Approval - Commitments (IA) - 9 Project:Community Civic Campus Project Number:pf1707 Process Document: IA - 9 Overall Due Date: Current Workflow Step: Finance Approval Step Due Date: Subject:SMITHGROUPJJR INC - 0132350 Status:Approved Invoice Information Compile all backup documentation into one PDF file. Attach PDF document to Invoice Documentation data field. Vendor Invoice Number: 0132350 Vendor Invoice Date: 07.24.2018 Period From:05.26.2018 Period To:06.29.2018 Invoice Documentation:INV 2018-0724 10609.000 Inv 0132350 Progress Inv 005.pdf Tracking Info CM Signature:Dolores Montenegro CM Approval Date:01.04.2019 PM Signature:Marian Lee PM Approval Date:01.28.2019 Division Manager Signature: Matthew Ruble Division Manager Approval Date: 01.28.2019 Director Signature:Eunejune Kim Director Approval Date: 01.29.2019 Finance Info 20 Check Number: Check Date: Check Amount:0 Commitment Invoice Details Status:Approved Approved:01.29.2019 (Eunejune Kim) Commitment:0101921 - MASTER ARCH: CCC: PROGRAM/OUTREACH Company/Contact:SMITHGROUPJJR INC Date Received:12.21.2018 Date Due: Commitment Invoice Custom Fields Migrated:No 21 Invoice Items Commitment Item # Description Budget Line Item Funding Rule Invoiced To Date Retained To Date Invoice Amount Retainage Percent Retained This Invoice 1 Professional Services (Design) 110-040 MeasureW -100 4,159,399.39 0.00 238,534.40 0.00%0.00 Totals 4,159,399.39 0.00 238,534.40 0.00 22 Attached Documents File Name Attached By Date Attached Step INV 2018-0724 10609.000 Inv 0132350 Progress Inv 005.pdf Enders, Heather (City of South San Francisco) 12.21.2018 Start 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 21 8 219 220 221 222 223 224 225 226 paTran Project Expense Transaction Detail Report Page: 1 3/22/2019 2:38PM CITY OF SOUTH SAN FRANCISCO 1/1/2019 through 2/28/2019 Project Number st1903 STREET REHABILITATION PROGRAM FY18-19 Benefits Encumbrances Materials Other TotalAccount #DescriptionReferenceDate Labor + Phase # 003 PROJECT BUDGET Task # 001 PRELIMINARY STUDIES Street Rehabilitation Program~ E 510-99999-5999 8,340.00 8,340.001/29/2019 AR019262 022409 METROPOLITAN TRANS COMMISSION Check: 273528 1/30/2019 Task Total: 001 0.00 0.00 0.00 8,340.00 8,340.00PRELIMINARY STUDIES Task # 002 PROJECT MANAGEMENT 2018 SLURRY SEAL - TASK ORD E 510-99999-5999 74,778.001/30/2019 0102109 Wages E 510-99999-4001 210.00 210.002/7/2019 LD02/07/2 Benefits/Contributions E 510-99999-4308 13.84 13.842/7/2019 LD02/07/2 Benefits/Contributions E 510-99999-4311 19.82 19.822/7/2019 LD02/07/2 Benefits/Contributions E 510-99999-4326 3.61 3.612/7/2019 LD02/07/2 Benefits/Contributions E 510-99999-4329 3.15 3.152/7/2019 LD02/07/2 Benefits/Contributions E 510-99999-4338 2.78 2.782/7/2019 LD02/07/2 Benefits/Contributions E 510-99999-4340 15.75 15.752/7/2019 LD02/07/2 2018 SLURRY SEAL - TASK ORD E 510-99999-5999 16,877.00 16,877.002/26/2019 18100043-04 104472 SWINERTON MGMT & CONSULTING Check: 274355 3/1/2019 2018 SLURRY SEAL - TASK ORD E 510-99999-5999 -16,877.002/26/2019 18100043-04 Task Total: 002 268.95 57,901.00 0.00 16,877.00 17,145.95PROJECT MANAGEMENT Task # 003 DESIGN SERVICES 2019-C2 - FY 2018-19 Surface S E 510-99999-5999 800.00 800.001/10/2019 872055504 106415 NCE Check: 273216 1/16/2019 2019-C2 - FY 2018-19 Surface S E 510-99999-5999 -800.001/10/2019 872055504 2019-C1R - FY 2018-19 Street R E 510-99999-5999 1,560.00 1,560.001/16/2019 872065504 106415 NCE Check: 273372 1/23/2019 2019-C1R - FY 2018-19 Street R E 510-99999-5999 -1,560.001/16/2019 872065504 Task Total: 003 0.00 -2,360.00 0.00 2,360.00 2,360.00DESIGN SERVICES Phase Total: 003 PROJECT BUDGET 268.95 55,541.00 0.00 27,577.00 27,845.95 Project Number Total: st1903 STREET REHABILITATION PROGRAM FY18-19 268.95 55,541.00 0.00 27,577.00 27,845.95 GRAND TOTAL: 268.95 55,541.00 0.00 27,577.00 27,845.95 1Page: 22 7 228 229 230 231 232 233 234 235 236 237 23 8 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 paTran Project Expense Transaction Detail Report Page: 1 3/25/2019 9:39AM CITY OF SOUTH SAN FRANCISCO 1/1/2019 through 2/28/2019 Project Number st1702 UUD RULE 20A ANTOINETTE LN Benefits Encumbrances Materials Other TotalAccount #DescriptionReferenceDate Labor + Phase # 110 DESIGN Task # 600 CONTRACT/CONSULTANT SERVICES 2018-E4: Mission Street Underg E 510-99999-5999 9,520.00 9,520.002/8/2019 18100047-03 104472 SWINERTON MGMT & CONSULTING Check: 273934 2/13/2019 2018-E4: Mission Street Underg E 510-99999-5999 -9,520.002/8/2019 18100047-03 2018-E4: Mission Street Underg E 510-99999-5999 11,270.00 11,270.002/26/2019 17100055-6 104472 SWINERTON MGMT & CONSULTING Check: 274355 3/1/2019 2018-E4: Mission Street Underg E 510-99999-5999 -11,270.002/26/2019 17100055-6 Task Total: 600 0.00 -20,790.00 0.00 20,790.00 20,790.00CONTRACT/CONSULTANT SERVICES Phase Total: 110 DESIGN 0.00 -20,790.00 0.00 20,790.00 20,790.00 Project Number Total: st1702 UUD RULE 20A ANTOINETTE LN 0.00 -20,790.00 0.00 20,790.00 20,790.00 GRAND TOTAL: 0.00 -20,790.00 0.00 20,790.00 20,790.00 1Page: 25 4 255 256 257 258 259 260 General Ledger Balances Page 1 of 1 Criteria: As Of = 2/28/2019; Period = 0,1..12; 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 9,685,368.90 2,630,183.23 16,500,161.33 11208 ACCOUNTS RECEIVABLE - OTHER 1,959,169.26 0.00 1,959,169.26 0.00 Total CURRENT ASSETS 11,404,144.92 9,685,368.90 4,589,352.49 16,500,161.33 Object Group 21000 -- CURRENT LIABILITIES 21101 ACCOUNTS PAYABLE 0.00 40,975.00 40,975.00 0.00 Total CURRENT LIABILITIES 0.00 40,975.00 40,975.00 0.00 Object Group 27000 -- FUND BALANCES 27001 FUND BALANCE 0.00 0.00 7,369,335.08 (7,369,335.08) 27202 RESERVE FOR ENCUMBRANCE (53,650.00)40,975.00 0.00 (12,675.00) 27304 DES FOR CURRENT CAPITAL PROJ.(7,315,685.08)7,315,685.08 0.00 0.00 27472 DESIGNATED FOR CIVIC CAMPUS (4,034,809.84)0.00 0.00 (4,034,809.84) Total FUND BALANCES (11,404,144.92)7,356,660.08 7,369,335.08 (11,416,819.92) Object Group 28000 -- CONTROL ACCOUNTS 28001 ENCUMBRANCES 0.00 53,650.00 40,975.00 12,675.00 28003 APPROPRIATION CONTROL 0.00 0.00 7,369,335.08 (7,369,335.08) 28004 BUDGETED FUND BALANCE 0.00 7,369,335.08 0.00 7,369,335.08 28005 REVENUE CONTROL 0.00 1,959,169.26 8,636,051.78 (6,676,882.52) 28006 EXPENDITURE CONTROL 0.00 2,630,183.23 1,049,317.12 1,580,866.11 Total CONTROL ACCOUNTS 0.00 12,012,337.57 17,095,678.98 (5,083,341.41) Total MEASURE W 0.00 29,095,341.55 29,095,341.55 0.00 Total 0.00 29,095,341.55 29,095,341.55 0.00 261 Measure W Life‐to‐date Revenues and Expenditures Object Title FY 2015-16 FY2016-17 FY 2017-18 FY 2018-19 thru 2/28/19 Total Fund 101 -- MEASURE W Revenues 30207 MEASURE W AND USE TAX (0.5%) 1,493,425 8,886,653 11,162,238 6,676,883 Total Revenues 1,493,425 8,886,653 11,162,238 6,676,883 28,219,199 Expenditures 9100 TRANSFER OUT TO GENERAL FUND - - 2,440,861 - Community Civic Campus 211,992 382,775 2,658,267 1,162,667 4,203,709 Street Paving 464,011 3,826,455 356,933 4,647,399 UUD Antoinette 31,150 122,658 202,920 356,728 Subtotal 877,936 6,607,380 1,722,520 9,207,836 Total Expenditures 211,992 877,938 9,048,241 1,580,866 11,719,037 Net 1,281,433 8,008,716 2,113,996 5,096,016 16,500,162 26 2