City Services Auditor (CSA) City and County of San Francisco Office - PowerPoint PPT Presentation

City Services Auditor (CSA) City and County of San Francisco Office of the Controller Highlights of FY 2016-17 Audits & Projects Presentation to CGOBOC January 26, 2017

City and County of San Francisco CSA Performance: I ssued Projects Office of the Controller I ssued Date Report 11/15/16 Citywide Nonprofit Monitoring and Capacity Building Program: FY15-16 Annual Report and Highlights 11/10/16 San Francisco Public Library Public Services Division Staffing Analysis, Summary and Appendices 11/10/16 FY16 Nonprofit Monitoring Results Dataset 10/31/16 (ECE) Market Rates Review 2016 10/26/16 Street and Sidewalk Maintenance Standards Annual Report FY2015-16 10/25/16 Park Maintenance Standards Annual Report FY2015-16 10/5/16 Emergency Medical Response: Destinations and Ambulance Diversion 2

City and County of San Francisco Office of the Controller 3

Citywide Nonprofit Monitoring and Capacity Building Program 2016 Annual Report Highlights City and County of San Francisco Office of the Controller 4

City and County of San Francisco CSA Performance: Public Library Staffing • San Francisco Public Library (SFPL) Staffing Analysis methods: Office of the Controller interviews, job shadows, time-use surveys, focus groups, benchmark comparisons and other quantitative work. • Deliverables for SFPL included: a task matrix to better match jobs to public needs and strategic goals and a relative staffing index to show vacancies, backfill rates and coverage. • Benchmark data shows SF near the top in funding: 5

CSA Performance: Charter Report on City and County of San Francisco Street and Sidewalk Maintenance Findings of CSA’s Charter-required report on street and sidewalk Office of the Controller maintenance include: • Service requests to SF311 increased significantly, the City’s response rate held steady at 90% within 48 hours and overall litter decreased. However both SF311 data and our evaluations show the same or worsening incidences of feces, needles, condoms and broken glass on streets; • Illegal dumping incidents decreased in commercial routes and increased in residential routes. Golden Gate Park and Land’s End illegal dumping drove increases in District 1; • Graffitti counts increased significantly on both private property and on public property that is not maintained by DPW • On average the City was quicker to respond to service requests for tree and landscaping issues. 6

CSA Performance: Charter Report on City and County of San Francisco Park Maintenance Standards Findings of CSA’s Charter-required report on park maintenance Office of the Controller standards include: • Most parks scored between 80 and 90% on our standards, with 85% a level that indicates good conditions and maintenance. • Highest scoring parks are shown below. Four of the ten highest scoring parks were recently renovated as part of the 2008 or 2012 Neighborhood Park bond programs. 7

CSA Performance: Charter Report on City and County of San Francisco Park Maintenance Standards • Lowest scoring parks are shown below. District 10 has three of Office of the Controller the lowest scoring parks and eight of ten are in the southern part of the City. • Bay View Playground, Alice Chalmers and Rolph Nicol were low scoring in FY15 as well. 8

CSA Performance: Other important work City and County of San Francisco in the October to December period • Support to the Citywide Jail Alternative working group Office of the Controller • Homeless and Supportive Housing – helping the new department get up and running with contracting process mapping, Homeless Outreach Team (SFHOT) analysis and other support • Electronic Health Records new system acquisition—working with DPH on the City’s next very large IT procurement—lessons and templates from F$P • Under the Vision Zero effort—geocoding and analysis of traffic collision deaths and injuries to provide SFPD with data and mapping tools to measure enforcement efforts. 9

CSA Audits: Construction Audits & City and County of San Francisco Assessments Audit Description Status Office of the Controller • Joe DiMaggio 2012 Clean and Safe Audit of construction management, project Neighborhood Parks controls and oversight procedures Report issued on Bond Program Audit Contractor: SFDelaney Consulting 1/17/17 • Joe DiMaggio • 2010 ESER and GO Bond Review bond expenses to determine if Expenditures Audits: expenditures are in accordance with ballot 2011 RRSS reports • 2010 ESER measure issued in July 2016 • 2011 RRSS • Reporting phase for Contractor: Cumming Construction • 2008 SFGH Rebuild Management 2008 SFGH Rebuild Pre-construction Reviews of planning for project scheduling, • Planning and Phase Audits: contract method determination, scope creep Scoping Phase • SSIP controls, contingency calculation, and • 2014 ESER adherence to bond provisions Contractor: RW Block and Sjoberg Evashenk Construction Insurance Assessment of the City’s procurement • Planning and Assessment practices for construction insurance coverage Scoping Phase Contractor: RW Block 10

City and County of San Francisco CSA Audits: I ssued Audits (Jul – Dec 2016) I ssued Date Report Office of the Controller 7/7/2016 Airport Commission: Swiss International Air Lines Ltd. Correctly Paid Its Landing Fees for 2013 and 2014 7/11/2016 Office of the Treasurer and Tax Collector: Quarterly Review of the Schedule of Cash, Investments, and Accrued Interest Receivable as of March 31, 2016 7/12/2016 Department of Public Works: Expenditures at the Department for the 2010 Earthquake Safety and Emergency Response Bond Program Were in Accordance With the Ballot Measure 7/13/2016 San Francisco Municipal Transportation Agency: The Overhead Rate of One Central Subway Project Consultant Must Be Reduced 7/25/2016 Department of Public Works: Expenditures at the Department for the 2011 Road Repaving and Street Safety Bond Program Were in Accordance With the Ballot Measure 7/28/2016 City Services Auditor Follow-up on Recommendation Implementation Status Annual Summary – Fiscal Year 2015-16 7/28/2016 City Services Auditor Recommendations Not Implemented After More Than Two Years on June 30, 2016 8/4/2016 Human Services Agency: The Department Effectively Ensures That County Adult Assistance Programs Provide Maximum Benefits to Eligible Clients 8/24/2016 Human Services Agency: Oversight of Arriba Juntos Grants Needs Improvement to Better Ensure Delivery of Services 9/6/2016 Airport Commission: Andale Mexican Restaurant and Bar Correctly Reported Its Revenue and Paid Its Rent for 2013 and 2014 9/7/2016 Central Shops: Payments to Channel Lumber Complied With City Procurement Policies and Procedures but Some Controls Should Be Improved to Pay Vendors on Time & Take Advantage of Early Payment Discounts 9/22/2016 Port Commission: D&G Company dba Lou’s Pier 47 Underpaid $16,145 in Rent to the Port for January 2011 Through December 2013 9/29/2016 SFMTA: City of San Francisco Japan Center Garage Corporation Needs to Improve Some Operations at the Japan Center Garages 9/29/2016 SFMTA: LAZ Parking Correctly Reported Revenues of the Garage at Zuckerberg San Francisco General Hospital for July 2013 Through June 2015, but a Few Improvements Can Strengthen Its Operations 11

City and County of San Francisco CSA Audits: I ssued Audits (Jul – Dec 2016) I ssued Date Report Office of the Controller 10/4/2016 Airport Commission: Pelican Communications, Inc., Correctly Reported Its Revenues and Paid Rent for 2013 and 2014 but Did Not Provide the Required Certified Financial Statements 10/12/2016 Public Health's Employee Separation Process Needs Improvement to Minimize the Risk of Unauthorized Access to Buildings, Property, and Data 10/20/2016 SFMTA: San Francisco Municipal Transportation Agency’s Indirect Cost Allocation Plan for the Fiscal Year Ending June 30, 2015, Generally Complied With Federal Requirements 10/26/2016 City Services Auditor Follow-up on Recommendation Implementation Status – Fiscal Year 2016-17, First Quarter 10/27/2016 Fine Arts Museums of San Francisco: The Corporation of the Fine Arts Museums Inappropriately Paid $450,773 to a City Employee. FAMSF and COFAM Should Improve Their Payroll and Disbursements Processes. 11/3/2016 Airport Commission: Transportation Network Company Operating Permit Audit – Rasier-CA, LLC, Correctly Paid the Airport $8.5 Million for 2.2 Million Vehicle Trips In October 2014 Through September 2015 11/3/2016 Airport Commission: Transportation Network Company Operating Permit Audit – Lyft, Inc., Complied With All Tested Transportation Requirements but Underpaid the Airport $30,042 in Trip Fees 11/3/2016 Airport: Transportation Network Company Operating Permit Audit – Wingz Correctly Paid the Airport $32,964 for 8,562 Vehicle Trips in Apr.- Sep. 2015 and Complied With Most Transportation Requirements 11/16/2016 Board of Supervisors: Pacific Gas and Electric Company Properly Paid Its Franchise Fees and Surcharges for 2013 and 2014 11/23/2016 Board of Supervisors: NRG Energy Center San Francisco LLC Properly Paid Its Franchise Fees for 2013 and 2014 12/15/2016 Recreation and Park Commission: Murata’s Café Hana Overpaid $470 in Rent for Its Japanese Tea Garden Concession for 2013 and 2014 12/22/2016 San Francisco Municipal Transportation Agency: Absence Management Efforts Can Be Enhanced Through Improved Organizational Culture and More Effective Program Management Tools 12