Independent, vendor-neutral help for retailers and dealers

Dealer Foundations INSIGHT

What Operational Intelligence Actually Means

A dashboard shows you numbers. This is about which of them need a decision this month, and who should be making it.

Operational intelligence is the difference between knowing an item hasn’t sold in 300 days and knowing whether that matters.

Most retailers and dealers aren’t 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 aren’t 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 hasn’t 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’s 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 hasn’t sold in 420 days with $28 invested; another that hasn’t sold in 240 days with eight units on hand and $1,900 invested; a seasonal item that hasn’t 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’re not the same problem.

One aging report, four different situations

420 days

$28 invested

Old on paper. There’s almost no money in it.

240 days

8 on hand · $1,900 invested

Newer than the first one, and far more money tied up.

Seasonal

No movement since last year

Expected. It sells when the season turns.

Slow part

Sells infrequently

Service needs it on the shelf. Stocked on purpose.

All four land on the same report. Only the second one is clearly a decision waiting to be made.

The question is not simply, “Which item is oldest?” It is, “Which situation deserves our attention first?”

That’s 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.

What the report shows, and what you actually need to know

Service

The report shows which work orders are still open.

Which jobs are moving normally, and which ones have stopped moving?

Sales

The report shows a list of open quotes.

Which customers are waiting on us, and which opportunities are slipping because nobody owns the next step?

Accounting

The report shows this month’s exceptions.

Could we have caught any of these earlier and corrected them before month-end?

Parts & Inventory

The report shows thousands of items.

Where are meaningful dollars tied up, and which decisions would make the biggest difference?

Service is worth singling out. It’s 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’s 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’s 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’s 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 don’t contain. That is a strength, not a weakness.

Better information should lead to better habits

Operational intelligence isn’t 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’s a better report. Sometimes it’s 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’s 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.

01

What’s working?

02

What needs attention?

03

What do we know that helps us decide what to do next?

If the information doesn’t 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.

How this connects

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 →

Katherine Mitchell

About the author
Katherine Mitchell — Retail and dealer operations strategist

Katherine started in this industry at thirteen, filing carbon-copy sales receipts in the upstairs office of her family’s hardware store in Doraville, Georgia. Since then she has set up multiple rental and outdoor power equipment operations, sold equipment, trained staff, and run departments and stores. She has also guided owners through opening new locations, getting more out of the operations they already had, and ownership transitions in both directions — taking a business over, or preparing to sell one. Later came years on the vendor side: professional services at a general retail platform, then at a DMS built for outdoor power equipment dealers. Thirty years in, she started ProfitEdge on one conclusion: the value a business needs is usually already inside it. It just is not visible yet.

Have a problem you keep re-solving every month? Start a conversation →

Free checklist

The Physical Inventory Planning Checklist

Two pages. Everything to do six weeks, two weeks and one week out, the count-day rules, and a review sheet that shows the gross variance, not just the net. One email address, nothing else.

Free follow-up kit

The Follow-Up Kit

Four printable pieces: a short huddle playbook for managers, the huddle form, a one-page field job aid, and a guide to turning the reports you already have into working lists. One email address, nothing else.

Free self-check

The Exit-Readiness Self-Check

Two pages. What still runs through you, the four questions a buyer or successor will ask, and a place to name your first three gaps. One email address, nothing else.

Free worksheet

The Shrink Investigation Worksheet

Two pages. A five-step check for every significant variance, an item log, where shortages hide in an equipment and hardware store, and how to spot a pattern before anyone is accused. One email address, nothing else.

Free self-check

The Small-Office Controls Self-Check

Two pages. Who does what on a payment, the five control activities, first fixes for a two-person office, and a login review. One email address, nothing else.

Free counter log

The Missed-Sale Log

Two pages. A counter log for every request you couldn’t fill, a weekly review that gives each signal an owner, and a place to track patterns across the month. One email address, nothing else.

Free account review

The Commercial Account Review

Two pages. A snapshot of your five most important commercial, fleet, municipal or farm accounts: what they run, the terms on file, and what each account really earns. One email address, nothing else.

Free planning sheet

The Before-the-PO Planning Sheet

Two pages. Why you’re buying it, four questions to answer before the cash goes out, the program on one page, and how to run a controlled test when the evidence is thin. One email address, nothing else.

Free template

The Customer Deposit Policy Template

Two pages. Write your deposit terms once, set how deposits are handled at the counter, and reconcile open deposits every month. One email address, nothing else.

Free worksheet

The Revenue Leak Worksheet

Two pages. Check warranty, co-op and programs, labor, vendor terms and floorplan, put a yearly dollar figure on each leak, and rank them against shrink with an owner for every fix. One email address, nothing else.

Free morning review

The Work Order Stage Review

Two pages. A morning sheet for every open job, with its stage, what it’s waiting on, the next step and who owns it, plus a stage-by-stage count of where work stalls. One email address, nothing else.

Free monthly review

Monthly Margin Questions

Two pages. The four questions an owner should be able to answer every month, set out as a sheet to fill in when the statement arrives, with a checklist of where margin drifts. One email address, nothing else.

Free planning sheet

The Decision-First Report Request

Two pages. Before asking for a new report or a new system, write down the decision, who makes it, how often, what counts as an exception and whether the data can be trusted. One email address, nothing else.

Free working sheet

The Month-End Exception Review

Two pages. The five questions worth settling before you build anything, and a daily / weekly / before-the-close sheet with the owner column left blank for your own names. One email address, nothing else.

Work through it with someone

Bring the problem you keep re-solving

Most of what ends up in these articles started as a question from a shop owner or a dealer principal. If something here sounds like your month, say so and we will look at it together.

Start a conversation →