SLIDE 1
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 - - 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
SLIDE 2
SLIDE 3
City and County of San Francisco
Office of the Controller
3
SLIDE 4
City and County of San Francisco
Office of the Controller
Citywide Nonprofit Monitoring and Capacity Building Program 2016 Annual Report Highlights 4
SLIDE 5
City and County of San Francisco
Office of the Controller
CSA Performance: Public Library Staffing
- San Francisco Public Library (SFPL) Staffing Analysis methods:
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
SLIDE 6
City and County of San Francisco
Office of the Controller
CSA Performance: Charter Report on Street and Sidewalk Maintenance
Findings of CSA’s Charter-required report on street and sidewalk 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
SLIDE 7
City and County of San Francisco
Office of the Controller
CSA Performance: Charter Report on Park Maintenance Standards
Findings of CSA’s Charter-required report on park maintenance 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
SLIDE 8
City and County of San Francisco
Office of the Controller
CSA Performance: Charter Report on Park Maintenance Standards
- Lowest scoring parks are shown below. District 10 has three of
the lowest scoring parks and eight of ten are in the southern part
- f the City.
- Bay View Playground, Alice Chalmers and Rolph Nicol were low
scoring in FY15 as well.
8
SLIDE 9
City and County of San Francisco
Office of the Controller
CSA Performance: Other important work in the October to December period
- Support to the Citywide Jail Alternative working group
- Homeless and Supportive Housing – helping the new
department get up and running with contracting process mapping, Homeless Outreach Team (SFHOT) analysis and
- ther 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
SLIDE 10
City and County of San Francisco
Office of the Controller
CSA Audits: Construction Audits & Assessments
10
Audit Description Status
2012 Clean and Safe Neighborhood Parks Bond Program Audit
- Joe DiMaggio
Audit of construction management, project controls and oversight procedures Contractor: SFDelaney Consulting
- Joe DiMaggio
Report issued on 1/17/17 GO Bond Expenditures Audits:
- 2010 ESER
- 2011 RRSS
- 2008 SFGH Rebuild
Review bond expenses to determine if expenditures are in accordance with ballot measure Contractor: Cumming Construction Management
- 2010 ESER and
2011 RRSS reports issued in July 2016
- Reporting phase for
2008 SFGH Rebuild Pre-construction Phase Audits:
- SSIP
- 2014 ESER
Reviews of planning for project scheduling, contract method determination, scope creep controls, contingency calculation, and adherence to bond provisions Contractor: RW Block and Sjoberg Evashenk
- Planning and
Scoping Phase Construction Insurance Assessment Assessment of the City’s procurement practices for construction insurance coverage Contractor: RW Block
- Planning and
Scoping Phase
SLIDE 11
City and County of San Francisco
Office of the Controller
CSA Audits: I ssued Audits (Jul – Dec 2016)
I ssued Date Report
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
SLIDE 12
City and County of San Francisco
Office of the Controller
CSA Audits: I ssued Audits (Jul – Dec 2016)
I ssued Date Report
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
SLIDE 13
City and County of San Francisco
Office of the Controller
CSA Audits: SFMTA Absence Management Audit
Why We Conducted the Audit This audit was performed at the request of SFMTA management. What We Found
The Majority of SFMTA Focus Groups Expressed That Three Elements of Organizational Culture Need Improvement to Enhance Employee Engagement and Improve Attendance
*Percentage of SFMTA employee focus groups expressing the need for professional respect and compassionate leadership, better communication, and increased accountability.
13
SLIDE 14
City and County of San Francisco
Office of the Controller
CSA Audits: SFMTA Absence Management Audit
Why It Matters: An Effective Absence Management Program Encompasses Aspects of Human Capital and Technical Elements 14
SLIDE 15
City and County of San Francisco
Office of the Controller
CSA Audits: Transportation Network Company
(TNC) Audits of Uber, Lyft, and Wingz
SFO’s TNC Operating Permit
- SFO was the first airport in California to develop a TNC agreement
permitting drop-offs and pick-ups at the Airport.
- The first pilot permit was signed in October 2014.
- The Controller’s Office was involved in drafting permit language,
specifically the permit’s audit provision. 15
Pay a per trip fee for every pick-up and drop-off within geofence Comply with CPUC safety & regulatory requirements Develop system to track trips based
- n geofence
established by Airport Submit self- reported trips to Airport monthly
Key Permit Requirements
SLIDE 16
City and County of San Francisco
Office of the Controller
CSA Audits: Transportation Network Company
(TNC) Audits of Uber, Lyft, and Wingz
Why We Conducted the Audits:
- Determine whether revenues and related permit fees reported and paid to
the Airport are supported by underlying accounting and trip records.
- Determine whether TNC complied with certain permit terms and conditions,
including driver and vehicle requirements for operations. What We Found:
- Uber and Lyft fully complied and Wingz mostly complied with selected
transportation requirements
- Uber reported trips accurately and correctly paid the Airport $8.5 million for
2.2 million trips provided
- Lyft did not report 7,803 trips, resulting in underpayment of $30,042
- Wingz mostly complied with selected transportation requirements and
correctly paid the Airport $32,964 for 8,562 trips provided
16
SLIDE 17
City and County of San Francisco
Office of the Controller
CSA Audits: Ongoing Major Projects
- Citywide Fleet Management Audit
- Citywide Facilities Maintenance Audit
- Information Technology Cybersecurity Programs
- Public Health Environment Division Audit
- SFMTA Information Technology Governance Audit
- Sheriff Information Technology Governance Audit
17
SLIDE 18
City and County of San Francisco
Office of the Controller
CSA Audits: Report on Audit Recommendations Follow-Up
- CSA follows up on all recommendations every six months after
issuance, consistent with SF Charter requirement, Section F1.105.
- CSA reports on the results of its follow-up activity to the Board of
Supervisors’ Government Audit and Oversight Committee.
- Based on its review of the department’s response, CSA assigns an
audit determination status: Open, Contested, Closed.
- Based on CSA’s review of responses for the first quarter of fiscal year
2016-17 (issued Oct. 26, 2016): CSA followed up on 107 open recommendations from 24 reports Departments implemented 55 (51 percent) of open recommendations CSA was able to close 9 of the 24 reports or memorandums 18
SLIDE 19
City and County of San Francisco
Office of the Controller
CSA Audits: Report on Audit Recommendations Follow-Up
- Majority of CSA’s recommendations are implemented within one year of their
issuance.
- However, some remain outstanding for longer. The average age of the open
recommendations is 23 months.
19
10 20 30 40 50 Aging and Adult Services Controller Library Environment Port SFPUC SFMTA
Average Age of Open Recommendations (in months) Number of Open Recommendations
Number and Average Age of Open Recommendations Followed up on, by Department
SLIDE 20