Which KPIs Matter for Tracking Parts Obsolescence? A Parts Manager's Guide

Parts obsolescence tracking hinges on four core KPIs: inventory turns (how fast stock moves), excess inventory ratio (the percentage of parts sitting beyond 12 months), parts scrap rate (the dollar value of parts written off annually), and cost of carrying inventory (the annual expense tied to holding slow-moving stock). Together, these metrics reveal whether your parts department is holding dead weight or managing aging inventory strategically.

Why Most Parts Managers Track the Wrong Metrics

A common pattern we see across dealerships is this: parts managers focus almost exclusively on parts sales dollars and gross margin percentage. Those numbers matter, but they miss the story entirely. A parts department can post record sales and still be drowning in obsolete inventory that costs thousands per month to carry.

The dealers who get this right track inventory health separately from revenue health. They understand that a $50,000 parts investment sitting on shelves for two years is a $50,000 problem, even if the month's sales looked good. The expense of storing, managing, and ultimately scrapping those parts compounds quietly until someone actually looks at the numbers.

Here's the disconnect: gross margin on parts sales is backward-looking. You're measuring money you already made. Obsolescence KPIs are forward-looking. They tell you whether you're about to make expensive mistakes. One parts manager might report 42% margin on a $180,000 monthly parts sale. Another might report 38% margin on $220,000 in sales—and yet be in far better financial health because their inventory turns are three times faster and their excess ratio sits at 8% instead of 22%.

The pressure to show short-term profitability often obscures the long-term drain of dead inventory. That's a common mistake the industry makes, and it's expensive.

Inventory Turns: Your First Signal of Trouble

Inventory turns measure how many times your parts stock completely sells and gets replaced in a given period, usually annually. The formula is straightforward:

Inventory Turns = Cost of Parts Sold / Average Inventory Value

If your annual parts cost of goods sold is $900,000 and your average inventory sits at $300,000, your turns are 3.0x per year. That means your inventory completely cycles every four months on average.

What's healthy? OEM dealerships typically see turns between 2.5x and 4.5x annually, depending on brand, market, and dealership size. Independent shops often run 4x to 6x because they can't afford to carry depth. A dealership with 1.8x turns is almost certainly holding too much slow-moving stock. One with 6.0x or higher might be under-stocked and losing RO revenue by not having parts in stock.

The reason this matters: every dollar sitting in slow-moving inventory is money that could be working elsewhere. Storage space costs money. Inventory management software licenses cost money. Shelf time and handling cost money. If a part takes eight months to sell instead of two, you've burned through six months of carrying costs on a single SKU—and if it never sells, you've burned the whole cost.

Consider a scenario where a typical Honda dealership carries $450,000 in parts inventory and turns 3.2x annually. If they could improve turns to 4.0x by eliminating the slowest 15% of SKUs, they'd reduce average inventory to $360,000. At a blended carrying cost of 25% annually (which includes storage, insurance, handling, obsolescence reserve, and opportunity cost), that's a $22,500 annual savings,or roughly the cost of one additional service advisor.

Track turns monthly. Plot them on a trend line. If turns are declining, you're accumulating inventory faster than it's moving. That's your early warning system.

Excess Inventory Ratio: The Health Snapshot

Excess inventory ratio is the percentage of your parts stock that hasn't moved in a defined period,typically 12 months, sometimes 18. It's a direct measure of dead weight.

Excess Inventory Ratio = Value of Parts Not Sold in 12 Months / Total Inventory Value × 100

If your total inventory is worth $500,000 and $85,000 worth of parts haven't sold in 12 months, your excess ratio is 17%. Healthy dealerships run 8% to 12% excess. Above 15% and you're holding too much; below 5% and you're either managing inventory exceptionally well or you're under-stocked.

This metric is brutally honest. A part that hasn't sold in 12 months almost certainly won't sell. It's not waiting for the right customer,it's taking up space and tying up capital. Parts managers sometimes argue they need depth for those "rare jobs" or "one-off applications." Sometimes that's true. Most of the time, it's nostalgia disguised as inventory strategy.

The parts department at a mid-sized Ford dealership might carry forty-two different fuel door assemblies across model years to cover every possible customer request. In reality, three applications represent 89% of the demand. The other thirty-nine are costing $3,200 per year to carry and will likely never sell. A dealer1 Solutions user tracking excess inventory by part family and age can identify those SKUs quickly and make a data-driven decision to return them or donate them.

Break excess inventory into age buckets: 12-18 months, 18-24 months, and 24+ months. The 24+ month bucket is particularly telling. If you have $8,000 worth of parts that haven't sold in two years, those are candidates for immediate action,return, scrap, or donation. Waiting another six months won't change the outcome.

Now, there's a legitimate counterargument: some parts truly are long-tail items that might not sell for years but are essential when they do. A replacement transmission for a 2003 model year truck might sit for 36 months and then suddenly get ordered. But that scenario is rare, and it's worth quantifying. If you're holding $50,000 in parts "just in case," you should know exactly which SKUs fall into that category and why. Most dealers can't answer that question,which suggests they're holding inventory by inertia, not strategy.

Parts Scrap Rate: The Cost of Misjudgment

Parts scrap rate measures the dollar value of parts you write off annually because they've become obsolete, damaged, or unsellable. It's the moment of truth for inventory decisions.

Annual Parts Scrap = Total Dollar Value of Parts Written Off / Annual Parts Revenue × 100

If you scrap $18,000 worth of parts in a year and your annual parts revenue is $1,200,000, your scrap rate is 1.5%. Industry benchmarks sit around 0.8% to 1.2% for well-managed dealerships. Above 2% and you're destroying value through poor inventory planning or obsolescence management.

The tricky part: scrap rate is where past mistakes become visible. By the time a part is scrapped, it's already cost you months of carrying expense. But scrap rate tells you whether you're making the same mistakes repeatedly. If scrap rate is climbing year-over-year, your inventory decisions are getting worse. If it's flat or declining, you're learning.

Many dealers don't track this at all. Parts that age out get quietly donated or sent back to the distributor, and the write-off happens without formal reporting. That's a mistake. You need to know the annual dollar amount explicitly. It changes behavior when you see "$34,000 in parts scrapped last year" instead of a vague sense that "some inventory doesn't work out."

Track scrap by category: old model-year parts, superseded parts (newer revisions replaced the old one), damaged parts, and obsolete parts. That breakdown tells you where to focus. If superseded parts are your biggest scrap driver, you need a better process for retiring old part numbers when new ones are released. If old model-year parts are the problem, you're carrying too much depth on aging vehicles.

Cost of Carrying Inventory: The Annual Burden

This KPI often gets overlooked because it's not a single transaction,it's a silent, persistent expense. Cost of carrying inventory includes storage space, insurance, handling labor, obsolescence reserve, and opportunity cost (the interest you'd earn if that money were invested elsewhere).

Annual Carrying Cost = Average Inventory Value × Carrying Cost Rate

Carrying cost rate typically ranges from 20% to 30% annually for dealership parts. That includes:

Storage and facilities: the square footage your parts occupy, the climate control, the racking, the utilities.
Insurance: coverage on parts inventory.
Obsolescence reserve: the money you set aside annually knowing some parts will never sell.
Handling and labor: picking, shelving, inventory counts, cycle counts.
Opportunity cost: the return you'd earn if that capital were deployed elsewhere in the business.

If your average inventory is $400,000 and your carrying cost is 25%, your annual carrying cost is $100,000. That's $100,000 you're spending every year just to hold parts on the shelf, before you account for the parts that actually sell.

Here's why this matters operationally: if you reduce average inventory by $50,000 through better turns and lower excess ratio, you've just freed up $12,500 in annual carrying cost. That's real money. Use it to invest in reconditioning, customer retention, or team development.

Parts managers sometimes resist inventory optimization because they fear lost sales if a part isn't in stock. That's a legitimate concern worth testing. But the math is usually in favor of leaner inventory. A part that sits for twelve months costs money; a part that turns every sixty days and occasionally requires a one-day order is almost always the better deal financially.

How to Organize Obsolescence KPIs Into a Tracking System

Data without action is just reporting. The dealers who get this right build a monthly KPI review into their business rhythm.

Monthly KPI Dashboard: Track these four metrics on a single sheet or dashboard that updates automatically from your parts management system:

Inventory turns (current month, rolling 12-month trend)
Excess inventory ratio (overall and by category)
Parts scrap rate (dollar amount and percentage)
Average carrying cost (total and per unit of inventory)

Compare each month to the same month last year and to your internal targets. If turns are declining or excess inventory is creeping up, you know within 30 days, not six months later when the damage is compounded.

Quarterly Deep Dive: Once per quarter, pull a list of your slowest-moving 200 SKUs (the ones with the longest days-to-sale). Classify each one:

Keep: Parts that support current model inventory or high-frequency repairs. These have legitimate demand.
Reduce: Parts where you're over-stocked relative to demand. Return or reduce quantity.
Eliminate: Parts that haven't sold in 18+ months or are superseded. Scrap or donate immediately.

This is the kind of workflow that Dealer1 Solutions was built to handle,pulling aging inventory reports, making decisions, and executing returns or write-offs without manual back-and-forth.

Annual Obsolescence Forecast: Every January, estimate your expected scrap and obsolescence for the coming year based on the prior three years' average. Set a target (e.g., "reduce scrap rate from 1.3% to 1.0%"). Align your inventory purchasing strategy to support that target. If your forecast says you'll scrap $22,000 this year, that's $22,000 less you should be spending on new inventory in slow-moving categories.

Balancing Obsolescence KPIs With Customer Service

The obvious tension: if you optimize inventory to the point where you never have parts in stock, customer satisfaction and RO completion rates suffer. That's real. The goal isn't to eliminate inventory,it's to eliminate the wrong inventory.

The best parts managers segment their inventory into three tiers:

Tier 1 (Core Stock): High-velocity parts that move every 30-60 days. These should always be in stock. This is typically 20% of your SKUs and drives 70% of your demand.
Tier 2 (Supporting Stock): Medium-velocity parts that move every 60-120 days. Stock strategically based on seasonal demand and vehicle population. These are your 30% of SKUs driving 25% of demand.
Tier 3 (Specialty/Order-to-Supply): Slow-moving parts and one-off applications. Don't stock these. Order from your distributor or wholesaler when needed. This 50% of SKUs drives only 5% of demand.

Once you've segmented, your obsolescence KPIs become much more meaningful. You should have extremely low excess inventory in Tier 1 (5-8%) because those parts move. Tier 2 can tolerate higher excess (10-15%). Tier 3 should be nearly zero because you're not stocking it at all.

If your excess inventory is concentrated in Tier 3, you're over-stocking parts you shouldn't be carrying in the first place. That's a decision-making problem, not an inventory problem. If excess is high in Tier 1, you've misjudged demand,that's worth investigating because it suggests your sales forecasting or vehicle population analysis is off.

Common Mistakes in Obsolescence Tracking

Parts managers often make one of three errors when they start tracking obsolescence KPIs:

Mistake 1: Ignoring the parts sitting in the back corner. Dealerships have parts that have been physically present for so long that no one remembers why. They're not in your DMS as active stock. They're just... there. Run a physical inventory count at least annually and reconcile it against your system. That's where the biggest obsolescence problems hide.

Mistake 2: Conflating inventory turns with parts sales velocity. A part that sells once per month has a different risk profile than a part that sells once per year, even if the annual revenue is the same. Track both velocity (days-to-sale) and volume. A slow-moving high-dollar item (like a transmission) might have a long days-to-sale but legitimate demand. A slow-moving low-dollar item (like a trim clip) is almost certainly excess.

Mistake 3: Setting targets that are too aggressive too quickly. If your excess ratio is currently 18% and you set a target of 8% for next quarter, you'll either fail and get discouraged, or you'll scrap too much and lose parts you actually need. Move the needle gradually. A 1-2 percentage point improvement per quarter is aggressive but achievable.

Frequently asked questions

What's the difference between excess inventory and slow-moving inventory?

Excess inventory is parts that haven't sold in a defined period (usually 12 months). Slow-moving inventory is parts that sell infrequently (every 60-120 days) but are still selling. Slow-moving inventory can be healthy if it supports legitimate demand. Excess inventory is almost always a problem because it's tying up capital without generating revenue.

How often should I review obsolescence KPIs?

At minimum, monthly. Pull your four core KPIs (turns, excess ratio, scrap rate, carrying cost) at the same time each month so you can spot trends. Quarterly, do a deeper analysis by parts category and age. Annually, conduct a full inventory audit and adjust your stocking strategy for the coming year.

Should I return slow-moving parts to my distributor or scrap them?

Return them first if your distributor accepts returns (most do, with a restocking fee). Only scrap parts that are damaged, obsolete, or can't be returned. Scrapping destroys 100% of the value immediately. A return at 80% of cost preserves more value and removes the carrying burden. Track both as separate line items in your scrap rate calculation.

How does inventory segmentation (Tier 1, 2, 3) affect my KPI targets?

It makes your targets more meaningful. Your Tier 1 stock should have excellent inventory turns (4-6x annually) and very low excess (5-8%). Tier 2 can tolerate slower turns (2-3x) and higher excess (10-15%) because those are supporting parts. Tier 3 shouldn't be carried at all, so turns and excess don't apply,you order to supply. Without segmentation, comparing your turns to industry benchmarks is apples-to-oranges.

What should I do if my excess inventory ratio is above 15%?

First, segment your inventory and identify which tiers have the problem. If it's in Tier 1 or 2, you've over-stocked relative to demand and need to adjust purchasing. If it's in Tier 3, you shouldn't be carrying that inventory at all,move to order-to-supply immediately. Then, decide on the parts already in excess: return what you can, donate what you can't, and scrap the rest. Create a 90-day action plan to bring excess ratio below 12%.

How do I explain carrying cost to my dealership manager when justifying inventory reduction?

Use a specific number. If your average inventory is $400,000 at a 25% carrying cost, you're burning $100,000 annually just to hold parts. If you can reduce average inventory to $350,000 by improving turns and eliminating excess, you save $12,500 per year. That's a real business impact, not a theoretical argument. Show the math, and the decision becomes obvious.

---