San Francisco Salaries Analysis A closer look at
- Slides: 8
San Francisco Salaries Analysis A closer look at the Sheriff Dept. salaries
A closer look at public data on the SF Sheriff Dept. Salaries • Average Salaries by Job Type • Analysis of the Top 10 earners by year (2011 -2014) • Salary Makeup Analysis • Conclusions and Suggestions
ER SH F' D N U ER IF ER F T N G EA SH SE R ER T AI N AN N TE AP T F ET AD C KE EP EU C TY LI S F' IF ER S S F' IF 1 F IF ER SH F F IF ER SH SH TY PE R O PR SH S F' IF IF ER SH IF ER ER EP U SH D SH R IO N SE TY TY U EP D EP U D IE F H C T AN ST SI AS Average Salaries by Job Type 300000 250000 200000 150000 100000 Total 50000 0
Top 10 Earners by Year 2011 Top 10 Employees' Salary Makeup 2012 Top 10 Employees' Salary Makeup 250000 300000 250000 200000 150000 Benefits Other Pay Overtime Pay Other Pay 150000 Overtime Pay Base Pay 100000 50000 0 0 1 2 3 4 5 6 7 8 9 10
Top 10 Earners by Year 2013 Top 10 Employees' Salary Makeup 2014 Top 10 Employees' Salary Makeup 400000 350000 300000 250000 Benefits Pay 200000 Benefits Pay Other Pay 200000 Overtime Pay Base Pay 150000 Other Pay Overtime Pay 150000 Base Pay 100000 50000 0 0 1 2 3 4 5 6 7 8 9 10
Salary Makeup Analysis 2014 Percentage of Pay Makeup Using 2014 as a model basis, since it has the greatest difference from spot 1 to spot 10 and also because it has the most 16% Base Pay uniform makeup of pay types over the 4 43% years, we can get an understanding of what the average pay makeup from the highest earners looks like. Other Pay Overtime Pay Benefits Pay 35% 6%
Conclusions • It may be more cost effective and for the better of the mental health and fatigue of the sheriffs to hire more sheriffs of each variety. • Decreasing over time worked and increasing workers may have an adverse effect financially for those in the department who are utilizing the current offerings of unrestricted overtime. • It would however have a positive effect on diversity in the force by increasing those employed, increasing off hours time to help with fatigue and mental recuperation of the regular stresses associated with law enforcement, and without having to increase budget for the department. • This may not need to be a removal of all Overtime hours but, as some other law enforcement departments have done, limit the Overtime hours allowed. • Unfortunately due to the “Other Pay” and “Benefits” fields not be defined in the data set given, I’m unable to draw any further conclusions but some limits may also be put in place in those areas to inhibit exorbitant spending on the department’s part.
Data Cleaned Using Iron Python Script written by Michael Williams. Data provided by the city of San Francisco and is publicly available for all state employees. Insights completed by Michael Williams on 3/21/16.