Beyond dashboards: seeing what is working, what needs attention, and what to do next.
Most retailers and dealers are not short on information. There are sales reports, inventory reports, work-order reports, financial statements, aging reports, dashboards, spreadsheets, and any number of other ways to look at what already happened.
The challenge is rarely getting another report. The harder questions are: what deserves attention? Why does it matter? And what should we do about it?
Those questions are not academic. In one margin review, roughly 590 under-priced parts were leaving about $54,000 a year on the table — at the same sales volume, with no new customers required. Every one of those items already appeared on reports the owner had been looking at for years. Nothing on any of them said this is where the money is going. That review is worth reading in full if you want to see what the alternative would have cost.
Information is only the starting point
A report can tell you that an item has not sold in 300 days. It can tell you that a work order has been open for three weeks. It can tell you that gross margin is lower than it was last month. It can tell you that several quotes are still outstanding.
All of that is useful. But none of it automatically tells you whether there is actually a problem.
A 300-day-old part may be exactly what you expect to have on the shelf. A three-week-old repair may be waiting on a backordered part with a known arrival date. A lower margin percentage may be the result of a perfectly reasonable product mix.
The number gets your attention. Understanding the circumstances tells you what the number means.
Reporting tells you what happened. Good management asks what it means.
Business systems are very good at recording activity. Every invoice, purchase order, work order, receipt, price change, inventory adjustment, customer interaction, and accounting entry becomes part of the record.
That gives you an enormous amount of information. The value comes from learning how to interpret it.
Consider inventory. An aging report might show one item that has not sold in 420 days with $28 invested; another that has not sold in 240 days with eight units on hand and $1,900 invested; a seasonal item that has not moved since last year; and a replacement part that sells infrequently but is important to the service department.
Technically, all four may qualify as slow-moving inventory. Operationally, they are not the same problem.
The question is not simply, “Which item is oldest?” It is, “Which situation deserves our attention first?”
That is a much more useful management question, and Freeing Cash Trapped in Dead Stock works through how to answer it.
The same principle applies across the business
Every area has its own version of the same gap — between what the report shows and what somebody actually needs in order to decide.
Service is worth singling out. It is often the least understood profit center in the building — treated as something the manufacturer requires in order to carry the product, rather than a business the owner chose to be in. Priced, costed, staffed and stocked properly, it is usually the most profitable department of the lot. Most of the reporting around it never gets far enough to show that. We take that apart in Turning Work Orders Into a Production System.
This is what operational intelligence is meant to do. It turns a large amount of information into a smaller number of meaningful questions.
That is where operational intelligence begins.
It should not replace judgment
There is a temptation, especially with newer technology, to assume that better intelligence means the system should simply make the decision. That is not the goal.
Any store is full of exceptions that make sense to the people who know the business. A slow-moving part may be important to a major commercial customer. A low-margin sale may be part of a larger relationship. A long-open work order may have a completely reasonable explanation.
No calculation understands every circumstance on its own.
Good operational intelligence should help the person making the decision see the situation more clearly. It can identify the condition, provide context, show how the situation compares with what is normal, and point out something worth reviewing.
But the person running the business still brings experience, customer knowledge, local market knowledge, and judgment the numbers do not contain. That is a strength, not a weakness.
Better information should lead to better habits
Operational intelligence is not only about finding problems. Over time, it should help people get better at recognizing them.
A parts manager who regularly reviews slow-moving inventory begins to see patterns in purchasing. A service manager who pays attention to where jobs stall begins to notice recurring bottlenecks. A controller who tracks the same month-end exceptions begins to see which processes need to change upstream. A salesperson with a clear follow-up process becomes less dependent on memory.
This is where information becomes knowledge.
The tool that gets you there varies. Sometimes it is a better report. Sometimes it is a conversation with a manager, or training, or a new operating procedure. Sometimes an outside pair of eyes sees what has become too familiar internally. And sometimes it is software watching the data continuously and bringing unusual conditions to someone’s attention. Different tools, same purpose.
The goal is not a business that depends on more reports. It is a business that gets better at using the information it already has.
A useful test
When you look at any report, dashboard, or business review, ask three questions.
If the information does not help answer one of those three, it may still be interesting. But it may not be helping you run the business.
You already generate an enormous amount of information. The opportunity is not to generate more. It is to get more value from what you already know.
Area: Foundations — the idea the rest of the work rests on.
Applies across: Revenue, Operations, Administration and Executive.
Read next: Start With the Decision, Not the Report — what this looks like when you sit down in front of your own system.
ProfitEdge Systems helps independent retailers and dealers improve profitability and operating performance through consulting, training, and intelligence tools. See how we help →