Automotive KPI Dashboard Example

Automotive Parts Supplier Performance Dashboard

The call comes from the OEM's material planner just before seven in the morning. The truck that should be at the dock isn't, and the assembly line will run out of your cross-members before lunch. For a tier 1 supplier, that's the worst call of the year, and it often starts with a part you don't make yourself.

Parts makers employ more people than the vehicle plants they supply. The Bureau of Labor Statistics counted 524,700 people in motor vehicle parts manufacturing on average in 2025, against 285,800 in the plants that build the vehicles. Many of those parts plants answer to an OEM scorecard, and most depend on a few suppliers further up the chain that they rarely have to think about.

Until one stops. On September 16, 2025, a fire broke out at Novelis's aluminum plant in Oswego, New York, with most of the damage in the hot mill, and Novelis said in November 2025 it expected to restart the mill that December. Ford, which buys aluminum from the plant, had already put the hit to its 2025 adjusted EBIT at $1.5 billion to $2 billion in October. The hot mill came back online on June 10, 2026, about six months after the December restart Novelis had expected.

The supplier in this example is invented, and so is its shock: smaller than Oswego and closer to what most tier 1 plants actually live through, a tier-2 supplier of a cheap part going under. Every monthly figure below is modeled for this example. Only one target below, the recordable incident rate, has a published benchmark behind it. The rest are starting points.

What is an Automotive KPI Dashboard?

Overview

For a parts supplier, an automotive KPI dashboard shows whether the plant is shipping good parts to the OEM's release without paying to rush them, and what is happening upstream that will decide next month's answer.

It starts at the receiving dock. Supplier PPM shows how many of the parts your own suppliers sent were bad. Plant inventory days on hand shows how long the plant could keep building if the trucks stopped, and how much cash is sitting in steel coil and finished racks while they don't.

Then the line. OEE puts availability, speed and good parts into one figure. Line cycle time is the speed part, measured in seconds per assembly and read against takt time, the pace the OEM's releases demand. Process scrap rate counts the parts that came off the press or the weld cell wrong. The recordable incident rate belongs here too, because it rises when a plant runs overtime to recover.

Then the shipping dock, where the customer starts counting. Parts shipped gives the volume behind everything else. On-time delivery to the OEM shows whether you met the release. Premium freight shows what it cost to meet it, and customer PPM shows how many of the parts that arrived were rejected. Those last three are the numbers the OEM's buyer sees. If you want availability and changeovers split out line by line, the production dashboard example goes deeper on the plant floor.

Who benefits from this dashboard?

1. Plant Manager: Watches on-time delivery and premium freight together, because a perfect delivery month paid for with expedited trucks is a warning, not a win.
2. Customer Quality Engineer: Customer PPM is their scorecard with the OEM. Seeing it next to process scrap shows whether a reject came from a defect the plant already knew about or one it never caught.
3. Supplier Quality Engineer: Supplier PPM by source tells them which tier-2 to visit this week, and which single-sourced part would hurt most if its maker had a bad month.
4. Materials and Logistics Manager: Owns inventory days on hand and the inbound half of premium freight. Too little stock and every hiccup becomes a charter; too much and finance asks why the yard is full of coil.
5. EHS Manager: The rolling recordable rate shows whether a recovery is being bought with tired people on Saturday shifts.

Keep engineered scrap off this board. In a stamping plant, much of the steel in the scrap bin was meant to end up there: offal from blanking and slugs from piercing, designed into the die and sold back to the scrap dealer. Count it and the scrap rate is large and never moves. Track process scrap, parts rejected for defects, and leave engineered scrap to the material yield report.

Dashboard Example Overview

The invented supplier stamps and welds chassis assemblies, mostly front cross-members and brackets, in one Ohio plant with about 640 people. It ships around 430,000 parts a month on daily releases to three OEM assembly plants building pickups and SUVs, for roughly $250 million a year in sales. Its main weld line has a takt time of 58 seconds. It reports ten KPIs monthly:

• Supplier PPM: Incoming parts rejected at receiving or at the line, divided by parts received, times one million. For this plant, weld nuts and bolts make up most of the count.
• Inventory Days on Hand: Raw material, work in process and finished goods at cost, divided by average daily cost of goods sold. It tells you how many days the plant could ship if every inbound truck stopped.
• OEE: Availability times performance times quality on the main weld line. Performance is measured against a fixed ideal cycle time of 52 seconds, so a slower line shows up here as well as in cycle time.
• Cycle Time: Average measured seconds per finished cross-member on the main weld line. It needs to stay comfortably under the 58-second takt to leave room for downtime.
• Process Scrap Rate: Parts scrapped for defects divided by parts produced. Splits, wrinkles, bad welds and misplaced nuts count. Blanking offal doesn't.
• Total Recordable Incident Rate: OSHA recordable cases times 200,000, divided by hours worked, over a rolling 12 months. One plant's monthly rate jumps around too much to read, so the rolling version is the one on the board.
• Parts Shipped to OEM: Saleable parts shipped. It has no target and no direction. It's here because customer PPM is calculated on it, and because it falls every July and December when the OEMs shut their plants.
• On-Time Delivery to OEM: Shipments that met the release's date and delivery window, divided by shipments due. Some customers count early as a miss, so use the customer's rule.
• Premium Freight % of Sales: Inbound and outbound freight above the contracted mode (expedited trucks, air and charter) divided by net sales.
• Customer PPM: Parts the OEM rejected, divided by parts shipped, times one million. Counted the OEM's way, including parts its sort team pulled at the dock.

From October 2024 to October 2025 the plant has a good, quiet year. Robot path changes take line cycle time from 54.9 seconds to 53.8, and plant OEE climbs from 77.6% to 81.3%. Process scrap falls from 1.9% to 1.5%. Customer PPM drops from 32 to 18, on-time delivery rises from 98.4% to 99.2%, and premium freight runs at about 0.2% of sales, 0.17% in October 2025.

In early November 2025 the plant's only supplier of projection weld nuts, a small family-owned tier 2, stops shipping after its lender pulls its credit line. Every cross-member carries four nuts. The plant has six days of them.

Purchasing buys every compatible nut three distributors can find and pays to fly some of them in. November premium freight jumps to 1.47% of sales and on-time delivery slips to 96.1%. Inventory days on hand rises to 11.6, as steel coil keeps arriving for a weld line that keeps stopping.

December is the low point. The distributor nuts come from mixed lots, and some have damaged threads. Operators check every nut by hand, and line cycle time stretches to 57.9 seconds, close enough to takt that any stoppage means a missed truck. Supplier PPM hits 3,050. A batch of cross-members with bad nuts gets through to one OEM, which rejects it and puts the plant on controlled shipping, an outside sort team at the plant's expense. Customer PPM for December is 561. On-time delivery falls to 89.4%, premium freight reaches 3.67% of sales, OEE drops to 61.8% and process scrap climbs to 3.6%. Inventory peaks at 14.6 days.

The fixes take three months. In January 2026, two nut makers already supplying other automotive customers get through PPAP and split the volume. The plant sets a 15-day safety bank of nuts, which barely moves inventory days on hand because a weld nut is cheap to hold. In March, a vision camera goes into the weld cell to check each nut's position and thread before welding, replacing the hand check.

The customer numbers recover first. By February, customer PPM is back to 32 and premium freight is down to 0.46%. By June 2026, on-time delivery is 99.3%, premium freight 0.21%, customer PPM 21 and inventory 10.3 days. In September, customer PPM is 16, level with July as the lowest in two years.

Line cycle time doesn't come back, and that's a choice. It's 55.9 seconds in September 2026, against 53.8 before the shock and a 55-second target. The camera adds about two seconds a part, and the corrective action the plant sent the OEM commits to keeping it. Because performance is still measured against the 52-second ideal, OEE settles at 79.0%, below both its 80% target and the 81.3% of October 2025. With 2.1 seconds of headroom to takt instead of 4.2, a higher OEM schedule now means Saturday shifts, not a faster line.

Two smaller numbers didn't fully recover either. Supplier PPM is 165 in September 2026, against 141 before the shock, because the two new nut sources are good but not yet as good as the old one. And the rolling recordable rate rose from 2.23 to 2.81 in January 2026, after three recordable injuries in each of December and January on overtime-heavy weeks. It's 2.63 in September and won't drop back until those two months leave the 12-month window, in December 2026 and January 2027.

List of Automotive KPIs

Only the recordable incident rate has a published US benchmark, from the BLS injury survey. Every other target is this example's starting point; replace it with your customer's scorecard targets or your own trailing year.

For a shorter read on which measures matter most when you're competing for the next program, see seven automotive KPIs for competitiveness. If your business sits further down the chain as a distributor or warehouse, the supply chain dashboard example covers fill rate and cash-to-cash cycle time instead.

Why Automotive Dashboards Matter

An OEM sees three numbers about its supplier: PPM, delivery and premium freight. The plant can make any one of them look good by spending on another, which is why they belong on the same screen as the plant numbers behind them.

On-time delivery can be propped up through most crises if nobody asks what the trucks cost. In December this plant still shipped nearly nine in ten releases on time, and paid 3.67% of sales in premium freight to do it. Lean inventory pulls the other way: ten days on hand is efficient right up to the day a tier-2 stops, and then every missing day turns into a charter.

Speed and quality trade too. Two seconds of camera time per cross-member cost this plant two points of OEE and half its headroom to takt, and bought it the lowest customer PPM it has posted in two years. A board that shows only OEE would call that a loss. A board that shows only customer PPM would never know what it cost.

The weld nut in this example costs a few cents and stalled a plant that sells $250 million a year. Before the next shortage, list your single-sourced parts, put the days on hand of each next to its supplier's PPM, and start with the cheapest ones.