Screen Shot 2014-08-19 at 1.14.35 PM

Our recent story about Metro Louisville’s 5 worst-performing departments led to questions about whether we were going to do the same for the city’s best performers. This was always the plan.

As stated in the earlier story we have based choices, as much as possible, on information provided by the city’s LouieStat system, which was created to help keep tabs on how the various departments of Metro Government have measured up to goals set by the city. It is a commendable effort to increase government transparency.

LouieStat is overseen by the Office of Performance Improvement (OPI).

As noted in the prior article, LouieStat analyzes stats specific to each of the city’s 19 departments, while also applying consistent criterion across all departments. The city calls these criterion Key Performance Indicators, or KPI. There are four “enterprise” KPIs that OPI evaluates for every department in LouieStat: 1) unscheduled overtime, 2) sick time usage, 3) work related illness and injury, and 4) responsiveness to citizen concerns.

LouieStat seeks to make its system easily understood via icons. A green circle with a check means the department has met or exceeded the stated goal, a yellow triangle means it’s almost at its goal, and a red octagon means the goal has not been met. If there’s not enough information, there is a “To Be Determined” icon.

LouieStat’s info is based on the various department’s year-over-year findings, though it also provides month-by-month figures when you dig a little deeper.

There has to be some element of interpretation in these rankings. Some of the best-performing departments are obvious, and have the most green circles. But down the ladder some departments may have more green circles than others, but their recent trends are moving in the wrong direction. Or they have a yellow triangle, but are essentially on goal. This is IL’s best effort to present the best performing departments in the city, given that some information is incomplete, and some information has to be interpreted versus simply observed. For more information and to analyze further, you can access LouieStat here.

Now, onto the best-performing departments…

5. Public Health and Wellness: At first blush Public Health has quite a few red octagons, but the good news is these categories are generally moving in the right direction when you delve into the information. One such red octagon is in overtime, which seems to be a problem for many departments, based on LouieStat’s data. Another is for hours not worked, where the department is a bit above goal, and the third is for hours lost due to work-related illness and injury. This last category had a goal of zero hours lost, so any numbers in this column would move it off goal.

Screen Shot 2014-08-21 at 11.19.36 AM

Its department-specific KPIs are both on target, with extremely positive recent data. Also it’s fitting that a department tasked with promoting public health has a low percentage of employees with high sick leave consumption.

4. PARC: Our parking department is generally meeting its departmental goals, or is close to them. They have four green circles, and four yellow triangles out of 11 categories. One triangle, for off-street revenue at PARC facilities, is extremely close to its goal, as is reported on-street parking meter repairs.

Screen Shot 2014-08-21 at 11.18.10 AM

Hours not worked are at 930 versus the goal of 1,137, earning a green circle. Also on-street parking citation revenue is at $1.92 million versus the year-over-year goal of $1.87 million.

So, maybe no one likes the meter attendee when they ticket your car, but at least they’re doing what they’re supposed to do.

3. Louisville Metro Police Department: The Louisville police are generally in the spirit of the LouieStat law, with only one red icon, versus four green circles and three yellow triangles. Their hours lost due to work related illness and injury clocked in at 13,344, way below the goal of 30,910. The cops also had 75 sworn employees with high sick leave consumption, while the goal was 81. Violent crimes hit 3,744, exceeding the goal of 3,781. Total crimes were at 32,281, just above the goal of 31,566, earning a yellow triangle.

Screen Shot 2014-08-21 at 11.16.46 AM

One head scratcher: The department earned a green circle for overtime hours paid, at 49,930, but the goal level was registered at TBD.

The lone red octagon came due the the department’s non-police employees. There were 51 civilian employees with high sick leave consumption versus the goal of 41.

2. Human Resources: The people who hire other Metro Government employees did well on LouieStat, earning five green circles and one yellow triangle out of eight total categories. The yellow triangle was for dollars spent on overtime, which was just barely over the line at $6,066 for the year versus the goal of $6,026.

Screen Shot 2014-08-21 at 11.15.37 AM

Otherwise HR did quite well, exceeding or meeting goals in hours not worked, hours lost due to work related illness and injury, lost time injury rate, employees with high sick leave consumption, and hiring cycle occurrences exceeding timeframe.

Hiring cycle occurrences exceeding timeframe is worth a minor celebration, coming in at 63 occurrences for the most recently measured year, versus the goal of 127. We say celebrate, because most of us have been on the receiving end of a drawn-out hiring process at some point in our lives, and it’s the pits.

The red icons were for overtime hours paid, 130 versus the goal of 104, and metrowide lost time injury rate, with a current frequency level of 7.63, while the goal is 4.93. (What this last bit means: Over a 12 month period it measures the number of what it terms “OSHA recordables” with days away from work times 200,000 divided by the total number of hours worked. Make sense now?)

1. Metro Technology Services: It makes some sense the IT guys rocked LouieStat the best. They earned six green circles, one yellow triangle, and two red lights. They should be celebrated for their dollars spent on overtime alone, coming in at a miserly $11,296 versus a goal level of $41,533. This correlated to 312 overtime hours paid, versus the goal of 1,536.

Screen Shot 2014-08-21 at 11.14.14 AM

Metro Technology also aced all their department-specific KPIs, earning great grades for service availability, service desk first time fix, service desk call abandonment, and help desk satisfaction. All of which is stellar, because everyone intuitively cowers before the surly IT guy.

On the downside they got dinged for clocking 4,878 hours not worked, versus a goal of 2,749, and for 17 employees with high sick leave consumption, while the goal was 10.

Overall, though, good going, Metro Technology. Where would LouieStat be without you?