Skip to content

Do you track regular time, absences and overtime? Are you getting this insight from your data?

July 8, 2016

Let’s start with some background. We were working with a client to help them understand how effectively they were using labor hours in their Distribution Center. This organization’s employees are paid hourly and considered full time.

Similar to most clients, they were tracking Regular, OT and Absence hours by employee. Looking at the data summarized by department across time in the chart below showed nothing unusual. In fact it looks like they have increasing amounts of overtime when they use more overall hours. This is a good method for flexing labor to meet demand. (For a great article on the effective use of OT, check out this The Overtime Lie by John Frehse at Core Practice Partners)

hours by week of year

It appears that they are scheduling effectively too. The chart below shows that in general they are working the hours that are scheduled by department.

scheduled and worked hours

At the summary level many of the details are hidden, It’s only when we get down to the individual employee level that it becomes apparent that there is room for improvement. This is the hardest part of deriving insights from data…organizing the data to start at a summary level and then progressively drilling down towards the right amount of detail to discover something of value.

employee hours

Let me explain the chart above…the x axis shows the number of hours worked in one week.  The y axis shows how many of those hours are overtime hours. Each dot represents the hours worked by an individual employee. The color of the dot represents the range of hours that employee was absent during the week. For example a green dot means all the hours were worked and there was no absence. A yellow dot means that while a person was scheduled for say 30 hours. They were absent between five and ten hours and worked the rest. The legend on the right of the chart shows the complete gradient.

We saw two distinct situations in this data. The first is that for this particular week charted there is a higher rate of absenteeism compared to others. It wasn’t a holiday week or something else that would drive absenteeism. By looking at this chart week by week it became clear that on busy weeks there was higher absenteeism than in slower weeks.

Secondly, we immediately noticed that while everyone is considered full time, many people were not working 40 hours and yet there were many people working significant overtime. So while at a summary level, the OT percentage looked reasonable, the reality was that there was plenty of regular hours capacity to satisfy the demand without the use of overtime. This of course drives costs up, but additionally as we hear in the news frequently, many people are not getting as many hours as they would like and to them, this situation is likely frustrating.

Creative visualization can turn data that companies must collect into valuable insights for improved productivity and increased employee satisfaction. In this case eliminating half the overtime and replacing it with regular hours would have resulted in a ~$35k a week savings. Don’t let your data rest!

Visualizing Schedule “Tradesies”

January 20, 2016

We recently met with an operations executive that was confronting one of the more vexing issues a manager faces. An employee told her there is a rumor going around that employees are swapping shifts with each other to increase their pay. In this organization, anyone who is not scheduled to work but then works is entitled to premium pay.

One of the well known ways to exploit this type of policy (I explained this as “tradesies” in my book Lean Labor) is to find a couple of buddies and regularly swap shifts with each other. It may not be every shift, but you have to trust your partner enough to know that you can be up or down a shift and when the time comes, they will agree to swap out a shift with you.

This of course drives up costs without increasing output. Not a good outcome for any organization. The executive was pondering what to do. The challenge is that there are many legitimate reasons to swap shifts and the policy is intended to provide flexibility for the workforce but ensure coverage for the workload. A premium may be paid to encourage employees to work hours that they might not otherwise want, thereby providing liquidity to the system.

Addressing this would be tough because it’s difficult to discriminate between legitimate shift swaps and ones that were done purely to increase pay. But the rumor was expanding and if this practice spread it could ultimately lead to lower profits, poor morale and even layoffs of uninvolved people.

Before she acted, she asked my team to take a look at her organization’s scheduling data and see what we could find. This is a fairly challenging exercise because first you have to figure out who actually swapped shifts with who. There is no “marker” other than a premium paycode for one person. After that was resolved, we had a long list of shift swaps. Next we had to figure out a way to visualize that list to help interpret the data.

After a couple of different approaches, the team was excited as they realized this would call for a different type of visual approach. The reason they were excited is that the vast majority of visualizations required are bar, line and scatter charts. These charts do a great job, but we all like some variety!

In this case the team realized they were looking at a networking relationship between the people swapping shifts.

Using a networking diagram, they plotted the employees and who they swapped a shift with. What we wanted to know though was not only who, but how many times shifts were swapped since gaming typically occurs between a small group of people. For that we colored the arrow differently based on the number of swaps made over the time period analyzed.

schedule swap diagram

Below is the result of the effort. As you can see, the majority of the swaps are occasional and with a variety of people. Good news! Most people are swapping shifts as the organization intended. But after applying a filter to remove the occasional swaps there are two clusters of three people that are swapping significantly more times and with the same people. This doesn’t necessarily mean they are gaming the system. It’s possible that they have very specific skills and there is a limited pool of people they can swap with.

This information was illuminating for the executive. Out of thousands of people, she could now focus on six and get to the bottom of it quickly. She could also respond to the rumor with hard facts. Finally, it was peace of mind for her to know that the vast majority of her employees were using the policy as it was intended.

The data scientists behind the scenes and how they put a spotlight on dark data

December 9, 2015

Over the past 18 months I have learned a lot about analytics and big data, especially applied to the workforce. I spend a fair amount of my time speaking to customers, analysts and the media and besides the most common question of “do you have any examples you can share” I get asked about the people involved and process of developing these applications. In the spirit of “people are the most important resource a company has” I want to showcase that side of big data.

For timekeeping and scheduling, dark data…( to save you a quick trip to your favorite search engine, I mean data that is collected but not typically used, yet is still required) ….in this case the audit trails of any change made to a timecard or schedule.

In Kronos there are sixteen different types of edits you can make to a timecard or schedule. Each of these edits represents tiny trades of time and money between an employee and the company. Individually most are inconsequential, but in aggregate they represent tens or hundreds of millions of dollars. By and large most of these changes are transactions that everyone agrees to and are necessary… The employee forgot to clock in so the supervisor adds in an “in punch”. Or an employee calls in sick and the supervisor changes a paycode from regular to sick in the schedule.

Occasionally however there are situations where the changes are indicative of an issue. For example, a supervisor changes a couple of minutes around during the week on an employee’s time card and eliminates premium pay. Or a supervisor changes a schedule after the fact to represent that an employee only worked the hours they were scheduled.

These small changes are usually lost in the millions of annual transactions that occur throughout the year. And because they are so small they are usually missed by most reports and audit teams. Only when the employee affected has the courage to speak up does a company become aware of it. By this time the consequences for all involved are significant; from degraded morale on the part of the employee to unnecessary cost in terms of productivity, turnover and financial impact for the company.

As the economy improves and companies feel the pain of turnover and lost performance when employee engagement sags, we have been engaged by companies to understand how they can identify these situations. The companies know the answer is in the data because when someone files a grievance and points out the specific situation and dates, the HR department can immediately see what happened in the transactions.

The challenge is seeing these changes sooner; especially before someone is so frustrated they file a grievance or the behavior becomes obvious to all. This is where one of our data scientists who has a PhD in computer science realized that this is a very similar challenge to what retailers face when they are trying to understand what the millions of customer clicks represent on a website. The customers aren’t telling them why they are clicking the way they do and only a fraction of the clicks result in an order.

So the data scientist applied the same machine learning techniques on timekeeping data that retailers use when they analyze their web server logs. The result of his work however was very difficult to interpret unless you understood machine learning and clustering techniques. To simplify this we had one of our visualization experts re-imagine the output in a way that a lay person could understand. Her interpretation was amazing in its simplicity!

Secondly, the data scientist had created a very flexible tool. The first prototype had a number of tuning parameters requiring the user to take output from past results and enter it in to help weight certain parameters for future analysis. We recognized that aside from a data scientist, we couldn’t expect a typical business user to be able to perform this tuning. So we focused what the tool could do and eliminated the tuning parameters.

clustering dashboard

An example of the machine learning dashboard in Workforce Auditor

We were very nervous and excited about analyzing our first data set (we went in without knowing anything about the customer or their practices to ensure we didn’t bias the analysis). When we researched the results, there it was…we had found an issue that was previously unknown to that company. We tried it a second, third and fourth time. Each time we found something important to the customer that they suspected but couldn’t prove or they were completely unaware of. These small changes were indicative of million dollar +  issues that were looming for these companies but had now been avoided….very exciting stuff.

We found supervisors gaming schedules to improve their own bonuses (the company since tweaked the rules of the bonus). We found a store manager working extremely hard to rebuild her schedule each week because the forecast and automated schedule she received was off (the company immediately re-tuned the forecast for her store). There were many more examples and we realized that we had developed quite a versatile tool. Its power is that it can evaluate the actions of thousands of employees and narrow it down to just a handful of situations that require further investigation in a matter of minutes.

With so many positive results we fast tracked the technology. It’s now available as Workforce Auditor and is included with our Workforce Analytics platform.

Take a ways from this experience?

1) Skills and experience really count in developing big data applications, no one is going from “excel guru” to building a machine learning application overnight and it takes multiple people to get it right

2) involving (internal or external) customers and their data is essential; no one could ever build this without deep domain knowledge and many different data sets to trial

3) By focusing on the business problem rather than the technology we created something that was streamlined and easy to use rather than a feature laden product showcasing the power of machine learning.

When I have a little more time to write, I want to share how the newest member of our team used scheduling data and a network map to uncover undisclosed relationships in a company and what it was costing them….stay tuned!

American Payroll Association Launches its Lean Labor Course

May 27, 2015

If you are reading this, you are probably aware that I authored a book a couple of years ago by the name of Lean Labor. Its purpose was to apply the philosophy and techniques of Lean specifically to paying and managing the workforce.

I’m pleased to announce that the American Payroll Association (APA) has taken the content from this book and added its own knowledge to create the first Lean Labor educational course. It’s targeted at Payroll Professionals who are looking to run their own operations in a Lean fashion as well as support other areas in their business by providing improved processes and information.

In addition, the APA recruited Dr. Martin Armstrong, Vice President Payroll Shared Services at Time Warner Cable to teach the course with me. Martin, who is also a friend, has implemented many of the techniques found in Lean Labor within his own organization and was recognized for this achievement by the APA with a Prism award. Martin recently wrote an article for training (a leadership development resource) titled The Perfect Paycheck.

We’ve taken the fundamentals of the book and added our experiences over the last three years to provide a practical course in using Lean to improve the performance of an organization driven from a Payroll perspective.

We’ll be teaching the inaugural course July 13-14 in Las Vegas. For more details on the course see the description at the APA site.

Forget 1 + 1 = 3, I’ll show you how 0 + 0 = 1 million

April 16, 2015

Everyone knows that labor costs show up on the income statement, but the same workforce can’t be found on the balance sheet. It’s considered an intangible asset and does not earn a line on the balance sheet. Did you know that there is another intangible asset that has similar qualities?

It’s the data your company collects every day. Each time an employee fills out or edits a form on a mobile device, laptop, desktop or kiosk, it’s adding to the quantity of data your company owns. This collection of data is relatively expensive and is represented as either a Cost of Goods Sold or an Operating Expense on the income statement chewing away at your profits. Similar to employees it too has no quantified asset value.

CFO’s understand both are extraordinarily valuable but also have a difficult time articulating it as anything more specific than goodwill.

What I have seen in the last year however is that an increasing number of companies are putting these two intangible assets together and finding million dollar insights about their businesses. I am specifically differentiating from companies who have business analysts hard at work tearing apart their data and those companies that are empowering a broader population of employees with increasing amounts of information.

The reason that this is important is that business analysts are relatively few and far between. When the broader workforce can begin making data-driven decisions on a daily basis and view situations with perspective and context based on facts rather than relying on their instincts and week old reports, the value creation is exponential.

Why are some doing better than others in capitalizing on this opportunity? Analytics and Big Data are a frequent topic of discussion with every company I visit. Everyone recognizes the potential. But as with most emerging opportunities, most are talking about it and formulating plans. The successful ones are diving in, learning and profiting. Companies that have accelerated their labor analytics journey are finding they can…

  • Identify who is not regularly following the corporate policies put in place from clocking, to editing time sheets to aligning a schedule to demand
  • Identify employees that have figured out manipulate the data they enter into so they can game controls and metrics in a way that current reports can’t identify. This results in either fraudulent behavior or boosting performance metrics at someone else’s expense.
  • Identify employees who are not following policy and outperforming others resulting in new best practices.
  • Identify employees who are overwhelmed with manual production and employee scheduling edits due to smaller batches and increases in product mix. This change in production speeds and patterns with no accompanying improvements in scheduling techniques is resulting in more unplanned Saturday shifts and overtime to accommodate less than optimal schedules
  • Locate where cost accountants have made mis-allocations of labor costs due to a lack of visibility to where and when the costs actually occurred.
  • Rank employees who are receiving volatile schedules from week to week that can result in increased fatigue and turnover.

I didn’t recognize how big this was becoming until I noticed a trend in the conversations I have been having with companies that provide strategic consulting. Some of these consultants are telling me their jobs are getting harder and in some cases their revenue is falling. Why? One of their bread and butter techniques of identifying opportunities is by interviewing multiple employees from different departments and then aggregating data from different systems. What they are experiencing is that the “low hanging fruit” they could always depend on is gone. Customers have already figured it out. The Aha! moments consultants are famous for are getting harder to find with their traditional techniques. They must evolve too.

Where is your company in maximizing its ROIA (Return On Intangible Assets)? The following list highlights some of what the companies that I visit with were experiencing before they changed tactics. To see how you relate, take a survey of your spreadsheets and business analysts to see if you can identify these situations:

  • Is there so much data available that the reports are now being heavily summarized, and detailed and history is not being carried along?
  • Is there significant manual massaging, data wrangling to use a fancy term, to reconcile data from different systems…is this causing latency in delivering the information?
  • Are different functional areas frustrated with the lack of support in getting at data and beginning to start reporting processes of their own, especially as you move to middle management ranks?
  • Have intrepid employees begun adding thousands of lines of macros to spreadsheets to make them automated and interactive to the point that the spreadsheets themselves are unstable?
  • Do spreadsheets going to front line managers have hundreds of rows or more and multiple tabs to make sure they have all the information they need?
  • Do your spreadsheets analyze mainly the data that users enter on forms or through hardware but ignore the data that the hardware and software generates itself in logs and audit trails?
  • Are people frustrated by the fact that they know the data they need is resting on servers within your organization but even your best report writers are not able to put it together to answer the questions and hypotheses posed?

If you see signs of this in your organization, then a review of your reporting processes, skills and tools is in order. You have an opportunity to change the way you think about math.

Lean Workforce in Hospitals

February 17, 2015

I’ve been a big fan of Mark Graban’s for years, but only just had the opportunity to work with him. About 2 weeks ago we delivered a webinar focused on Lean in hospitals. If you haven’t heard of Mark, he’s a highly respected Lean expert and author of Lean Hospitals among other books on the subject.

Mark provided several examples of how Lean techniques can be used to improve operations and steps ensure that a hospital’s staff is respected and supported.

If you haven’t had a chance to hear Mark speak about Lean, this is a great opportunity. He shares specific examples and outlines a process that everyone can use to improve outcomes.

Becker’s Hospital Review hosted it and you can see it here

Additionally Mark will be holding full seminars soon. If you are looking to learn more about Lean in a healthcare environment I would suggest looking into one of these:

Building Successful Lean Teams

Boston, March 31, 2015

Kaizen: On-Site Experience, Franciscan St. Francis

Indianapolis, April 22,23

The case for (and against) predictive analytics

November 14, 2014

It’s been a busy couple of months, and I’ve been learning quite a bit about business intelligence, big data and the opportunities and challenges in this space.

One area that has been a frequent topic is predictive analytics. As a lean guy, anything that promises improved business results by predicting the future immediately makes me suspect. I’ve been indoctrinated by the Lean philosophy to depend less on forecasts and more on the ability to observe and react to current demand and disruptions in a process.

That being said, I really depend on weather forecasts to get my kids dressed in the morning, so maybe I need to keep an open mind.

Predictive analytics is the next evolution in a long history of forecasting solutions that technology providers offer. For example, Kronos provides a labor forecast for retailers to help them in creating a labor schedule for the next week. This can be really helpful in supporting store managers in that it is really difficult to aggregate all the different patterns and unique events that are significant in scheduling a store. For example, day of the week is a fairly repeatable pattern and can be predicted fairly easily. Black Friday is also consistent. So rather than force the store manager to figure it out on her own, why not automate that in a forecast.

But ask a store manage if they completely rely on that forecast (or any other vendors forecast for that matter) and they will tell you that they use it for guidance. The reason for this is that there are many factors that affect a local store that aren’t used as drivers in creating the forecast. For example, if there is construction in the area that makes it more difficult for customers to get to the store or if a product is out of stock that week, the local manager will know that sales will not meet the forecast. This is why it’s so important to have someone knowledgeable about the local practice with the ability to react quickly to changing conditions.

Predicting levels of absence at a store or plant level is significantly easier that predicting individual absence. Make sure you understand the probability of success in a prediction. If you are providing guidance at the individual level, and the probability of a correct prediction is 60% then that means you are wrong 40% of the time. What actions are you asking managers to take based on this prediction and what’s the impact financially and in terms of system trust if it’s wrong?

A slight improvement over the status quo is good enough if a manager is already making the same decision frequently at an individual level. Hiring guidance for a similar job that has high turnover is a great example of an area where this works. Infrequent decisions are or if you are asking someone to take an action based on a predictive result is a different story. If it’s only a couple of percent better than the current method, internal customers are going to not understand the nuance of improvement and the project will be difficult to sustain.

When someone is having difficulty at home, it is likely their work will suffer. How is this behavior measured? While there are some outcomes that are measured like increases in absenteeism, these can also be attributed to difficulty with a supervisor or co-worker or a health issue.

Behavior is an area where correlation and causation can easily be confused. While we sense through data that something is wrong, it’s still going to take personal discussion to find out what the cause is. If you try and let software predict what the cause is and the manager takes a wrong action, it won’t be too long before the software isn’t trusted.

It’s very tempting to look for patterns in the data we already have. And no doubt there is lots of value hidden away in there that we have yet to mine. But we need to be careful to not try and solve every problem we have with existing data. In many cases, new data will be required to capture the true drivers of an event or behavior. This is a much more difficult endeavor.

So is there a future for predictive analytics? Absolutely. We just need to treat it like any other tool in our bag and not go around thinking that every employee problem we face is now a nail for predictive analytics to hammer.

Where are areas where predictive analytics excels?

Are there significant consequences for missing something?

Safety is something that comes to mind. If we can improve our ability to predict an increase in safety risk by even a few percent, the savings can be significant both in life, limb and dollars. This is a great area for exploring. Part of the solution needs to include understanding the drivers required to reduce the risk once an increase is predicted.

Will improvements in processing power or improved algorithms provide better insight than before?

This is the case for weather prediction. The data and algorithms were overwhelming the processing capabilities. As capacity to process improved, outcomes improved. This is also the case for customer behavior analysis. With lots of new data and increased granularity lower costs for processing have changed the game. Do you see similar opportunities with respect to labor analytics in your company? This could be a rich area to explore.

Predictive analytics is an interesting area, but let’s balance these efforts with the basics of making information more available and easier to use. Only then will we truly empower our employees’ decision making capabilities.

%d bloggers like this: