How parts managers forecast demand when inventory lives in three systems
Parts demand forecasting in a multi-location heavy equipment dealership starts with a reconciliation problem, not a planning one.
It’s Monday morning, and a parts manager at a four-branch heavy equipment dealer is trying to answer a simple question: what should we be stocking next month, and where?
The answer exists. It’s just spread across three places. The dealer management system says what’s on the shelf at each branch. The OEM’s parts portal says what’s on order and what’s been superseded. The service schedule, often a spreadsheet one of the branches keeps, says which machines are due in and what they’re likely to need. None of the three agree on timing, naming or part numbers, so before the parts manager can forecast anything, they have to reconcile everything.
That reconciliation is the job most weeks. The forecast is what’s left over at the end of it.
Why parts demand forecasting breaks across locations
For: parts managers and branch managersEach branch in a multi-location dealer group sees its own demand clearly. The branch near the quarry knows its customers run older excavators hard and burn through undercarriage parts. The branch on the edge of town knows its compact equipment rental fleet spikes every spring. What nobody sees clearly is the whole network at once.
That’s not a people problem. It’s a structural one. In most multi-location dealer groups, parts inventory is managed branch by branch rather than as a network. Each location has its own stock levels, its own ordering patterns, and its own view of what demand looks like. The network view exists only when someone assembles it by hand.
Three things make the separate views hard to stitch together.
Demand doesn’t follow the same pattern at every branch.
Fleet mix, machine age, season and local project work all vary by location. An average across the network hides the branches that need more and the ones carrying too much.
Part numbers change.
When an OEM supersedes a part, the demand history splits across the old number and the new one. If the two aren’t linked in the data, the forecast sees two slow-moving parts instead of one steady one, and orders accordingly.
Service demand arrives late.
A machine booked in for a 2,000-hour service next week will need a predictable set of parts. If the service schedule lives somewhere the parts system can’t read, that demand only becomes visible when the technician walks up to the counter.
When TR-4410 becomes TR-4410A
Twelve months of sales. The OEM superseded the part in month eight.
What the gaps cost on the counter and in the yard
For: parts managers and dealer principalsThe cost of a fragmented forecast runs in two directions at the same time.
On one side, parts sit. A slow mover at one branch ties up working capital, takes shelf space, and eventually becomes obsolete. KEA Advisors, which benchmarks commercial parts operations, sets the target for obsolete inventory at less than 2 percent, where obsolete means any part on hand with no sales in the last 12 months.
On the other side, parts are missing. Fill rate measures how often the counter can supply what the customer or the technician asked for. KEA Advisors sets the benchmark for first-time fill rate at 90 percent or better.
Most dealer groups operating across disconnected systems fall short of that. The shortfall is not usually a stocking problem. It is a visibility problem: the right part exists somewhere in the network, but the branch that needs it doesn’t know that until after the customer has already waited.
In a heavy equipment business, a missing part doesn’t just mean a lost counter sale. It means a machine stays down while the part ships from another branch or from the OEM. That’s a rental unit not earning, a customer’s project slipping, and a customer who learns to call someone else first.
The frustrating part is that both problems often exist in the same dealer group at the same time.
One part, four branches
Track roller TR-4410 is needed for a machine booked in at Quarry Road. Switch views to see what changes.
The part sitting unsold at one branch is the part another branch is waiting on. Without a network view, nobody knows to move it.
How the forecast gets built today
In most dealer groups, the monthly forecast is a manual assembly job.
The parts manager exports stock levels from the dealer management system, pulls open orders and supersession notices from the OEM portal, and asks each branch for their service bookings. All of it goes into a spreadsheet. Part numbers get matched by hand. Superseded numbers get merged where someone remembers to merge them. Then the parts manager adjusts the numbers using what they know about local conditions: the contractor starting a big job in the north, the fleet that’s aging into a rebuild cycle, the branch that always over-orders filters.
That local knowledge is the valuable part. It’s also the part that gets squeezed, because the assembly takes most of the time available. By the time the spreadsheet is finished, the stock levels it started from are already a week old.
What changes when the data lives in one place
Automation doesn’t replace the parts manager’s judgment about local conditions. It replaces the export, the matching and the reconciling that come before it.
When parts, service and rental run on one platform, such as A365, the parts manager starts from a single, current view of the network rather than building one. On-hand stock, open orders and in-transit transfers are visible across every branch. Superseded part numbers carry their demand history forward, so the forecast sees the real rate of use. Scheduled services and open work orders show up as expected demand before the machine arrives, not after.
From there, the system does the arithmetic. It flags where stock is high relative to demand, where a shortage is forming, and where a transfer between branches would cover a gap faster and cheaper than a new order. The parts manager reviews those signals, applies what they know about the customers and the season, and makes the call.
The forecast stops being a monthly event and becomes something the parts manager can check on a Tuesday afternoon.
What to look for in your own parts operation
Three checks tell you whether your forecast is built on data or on reconciliation.
01 Measure fill rate by branch, not just across the group.
02 Count how many systems someone has to open to answer “do we have this part anywhere in the network?”
03 Check how superseded part numbers are handled in your demand history.
For the full operational framework across service, rental, parts and compliance, the Annata Heavy Equipment AI Practical Field Guide walks through each area with the benchmarks and use cases behind it.
Get the full operational framework
The Heavy Equipment AI Practical Field Guide covers service, rental, parts, and compliance, with the benchmarks and use cases behind each area.
Get the Field Guide