Home / Insights

Inventory series · Part 3 of 4

ABC Analysis for Manufacturers: Why Dollar Value Is Not Enough

A $40 gasket set can shut down a filling line. On an ABC report it sits at the very bottom of class C, next to the drive belts, and gets the least attention of anything in the plant.

That is the problem with applying standard ABC analysis in a factory. The method in Post 1 ranks items by annual dollar usage, and for a distributor that works well: when an item runs out, you lose that item's sales. In a plant, running out of one input can stop everything that depends on it. The cost of a stockout has little to do with the price of the part.

This post keeps the ABC method and adds one thing to it: a criticality rating. If you have not read Post 1, start there for the five steps. Here we cover only what changes for a manufacturer.

Three pools of inventory, three behaviours

A distributor holds one kind of inventory: finished goods for sale. A manufacturer holds several, and each follows different rules.

PoolWhat drives its demandWhat a stockout costsHow to classify it
Raw materials and packagingThe production schedule. Usage follows what you plan to make.A delayed or cancelled batch, idle labour, late customer ordersABC by annual value consumed, plus criticality
Spare parts and maintenance suppliesEquipment wear and failure. Usage is low and irregular.Downtime on the equipment, and everything downstream of itCriticality first; value is almost irrelevant
Work in progressYour own process and batch sizesRarely a stockout; the cost is cash and floor spaceLeave out of ABC. Control it through scheduling.
Finished goodsCustomer ordersA lost or late saleStandard ABC by sales, as in Post 1

Two practical points follow. First, use consumption, the quantity issued to production or maintenance, not purchases. Purchases reflect when you bought, not what you used. Second, keep the unit of measure consistent. If resin is bought by the drum and issued by the kilogram, convert before you multiply.

A worked example: a coatings manufacturer

Ridgeline Coatings is a fictional maker of industrial coatings. The list below covers 20 purchased items across raw materials, packaging and spare parts, with a combined annual usage of $2,420,750. It is ranked exactly as in Post 1, with cut-offs at 80% and 95% of cumulative value.

RankItemPoolAnnual usageUnit costAnnual valueCumulative %Class
1RM-01 Epoxy resinRaw material180,000 kg$4.20$756,00031.2%A
2RM-02 Titanium dioxide pigmentRaw material95,000 kg$3.80$361,00046.1%A
3RM-03 Xylene solventRaw material210,000 L$1.35$283,50057.9%A
4PK-01 20 L steel pail with lidPackaging48,000$5.60$268,80069.0%A
5RM-04 Polyamine hardenerRaw material42,000 kg$6.10$256,20079.5%A
6RM-05 Acrylic resinRaw material38,000 kg$3.50$133,00085.0%B
7PK-02 4 L can with lidPackaging60,000$1.90$114,00089.7%B
8RM-06 Calcium carbonate extenderRaw material160,000 kg$0.45$72,00092.7%B
9RM-07 Iron oxide red pigmentRaw material9,000 kg$5.20$46,80094.7%B
10PK-04 PalletsPackaging2,600$14.00$36,40096.2%C
11RM-08 Dispersant additiveRaw material2,400 kg$14.00$33,60097.5%C
12RM-09 Defoamer additiveRaw material1,100 kg$11.50$12,65098.1%C
13SP-03 Filter bags, box of 50Spare part90$120.00$10,80098.5%C
14PK-03 Product labels, per 1,000Packaging120$85.00$10,20098.9%C
15RM-10 ThickenerRaw material900 kg$9.00$8,10099.3%C
16SP-01 Disperser mechanical sealSpare part4$1,850.00$7,40099.6%C
17SP-04 Pump diaphragm kitSpare part12$310.00$3,72099.7%C
18SP-06 Dispersion bladeSpare part6$480.00$2,88099.8%C
19SP-02 Filling line gasket setSpare part60$40.00$2,40099.9%C
20SP-05 Drive beltSpare part20$65.00$1,300100.0%C

The split looks familiar: 5 A items carry 79.5% of the value, 4 B items carry 15.1%, and 11 C items carry 5.3%. By the usual logic, the plant would now manage five items closely and put the bottom eleven on autopilot.

What the value ranking misses

Now mark the items that would stop production if they ran out. The plant's production and maintenance leads identify six.

Three of the six line-stopping items sit in the C tailBars: annual value per item, ranked. Line: cumulative share of the $2,420,750 total.Blue: vital items, where a stockout stops production.$0$250k$500k$750k80%95%RM-01 Epoxy resin: $756,000 a year, class ARM-01RM-02 Titanium dioxide pigment: $361,000 a year, class ARM-02RM-03 Xylene solvent: $283,500 a year, class ARM-03PK-01 20 L steel pail with lid: $268,800 a year, class APK-01RM-04 Polyamine hardener: $256,200 a year, class ARM-04RM-05 Acrylic resin: $133,000 a year, class BRM-05PK-02 4 L can with lid: $114,000 a year, class BPK-02RM-06 Calcium carbonate extender: $72,000 a year, class BRM-06RM-07 Iron oxide red pigment: $46,800 a year, class BRM-07PK-04 Pallets: $36,400 a year, class CPK-04RM-08 Dispersant additive: $33,600 a year, class CRM-08RM-09 Defoamer additive: $12,650 a year, class CRM-09SP-03 Filter bags, box of 50: $10,800 a year, class CSP-03PK-03 Product labels, per 1,000: $10,200 a year, class CPK-03RM-10 Thickener: $8,100 a year, class CRM-10SP-01 Disperser mechanical seal: $7,400 a year, class CSP-01SP-04 Pump diaphragm kit: $3,720 a year, class CSP-04SP-06 Dispersion blade: $2,880 a year, class CSP-06SP-02 Filling line gasket set: $2,400 a year, class CSP-02SP-05 Drive belt: $1,300 a year, class CSP-05A: 5 items, 79.5%79.5%B: 4 items, 15.1%94.7%C: 11 items, 5.3%RM-01: cumulative 31.2%RM-02: cumulative 46.1%RM-03: cumulative 57.9%PK-01: cumulative 69.0%RM-04: cumulative 79.5%RM-05: cumulative 85.0%PK-02: cumulative 89.7%RM-06: cumulative 92.7%RM-07: cumulative 94.7%PK-04: cumulative 96.2%RM-08: cumulative 97.5%RM-09: cumulative 98.1%SP-03: cumulative 98.5%PK-03: cumulative 98.9%RM-10: cumulative 99.3%SP-01: cumulative 99.6%SP-04: cumulative 99.7%SP-06: cumulative 99.8%SP-02: cumulative 99.9%SP-05: cumulative 100.0%RM-08 dispersant$33,600 a yearSP-01 mechanical seal$7,400 a yearSP-02 gasket set$2,400 a year
Illustrative data for a fictional manufacturer: 20 purchased items, 12 months of consumption.

Three of the six are A items: epoxy resin, titanium dioxide and hardener. Value-based ABC already gives them attention. The other three are buried in class C:

  • RM-08 Dispersant additive, $33,600 a year. Every batch needs it, it comes from a single supplier, and the lead time is eight weeks.
  • SP-01 Disperser mechanical seal, $7,400 a year. The plant uses about four a year, and a replacement takes ten weeks to arrive.
  • SP-02 Filling line gasket set, $2,400 a year. The $40 part from the opening paragraph.

Together these three are worth $43,400 a year, under 2% of the total. Managed as ordinary C items, they would be counted once a year and reordered when someone noticed the bin was empty.

The ranking misleads in the other direction too. All six spare parts fall in class C, with a combined value of $28,500. A value-only view says spares do not matter. Any maintenance manager will tell you otherwise.

Add a criticality rating

The fix is a second label on every item. Ask three questions: if we ran out today, would a line stop? Is there a substitute or a second supplier? How long would it take to get more?

RatingMeaning
1. VitalProduction stops. There is no substitute, and resupply takes weeks.
2. EssentialProduction is disrupted, but a substitute, second supplier or workaround is available within days.
3. DesirableNo effect on output. Available locally the same day or week.

Production and maintenance staff should set these ratings, not purchasing alone. They know which parts have no workaround.

The two labels together decide the control policy. Value sets how tightly you manage the item; criticality sets how much protection it gets.

ClassVital (1)Essential (2)Desirable (3)
ATight control and protected supply: forecast-driven orders, a supply agreement or second source, high service levelTight control with lean stock: frequent orders, no excess bufferTight control with minimum stock: buy close to need
BStandard reorder point with a raised service levelStandard reorder pointStandard reorder point with a lower service level
CNever run out: hold a generous fixed minimum and check it on a scheduleSimple min/max or two-binBuy on demand, or hold a token quantity

What changes at Ridgeline

  • The three vital C items get protection. Two spare mechanical seals on the shelf cost $3,700 and ten gasket sets cost $400. A three-month minimum of dispersant, 600 kg, costs $8,400. That is $12,500 in total to cover three items that can each stop the plant.
  • The non-vital A items get leaner. Xylene and steel pails are high in value but available from several local suppliers. They need frequent orders and close tracking, not a large buffer.
  • The vital A items get both. Epoxy resin, titanium dioxide and hardener are expensive and irreplaceable. These justify supply agreements, a qualified second source and the careful safety stock calculation covered in the next post.

Pitfalls specific to manufacturers

One year is too short for spare parts. A seal that fails every three years shows zero usage in most years. Use three to five years of history for spares, and never delete a vital part because it did not move last year.

Shelf life caps the buffer. "Hold plenty of the cheap items" works for gaskets. It does not work for a catalyst or additive with a six-month shelf life. Set the maximum stock below what you will use before it expires.

History misleads when the product mix is changing. Raw material usage follows the production plan. If you are launching a product or dropping one, rank materials on planned usage for the next 12 months, not on the last 12.

Dead stock is invisible to ABC. The analysis ranks by usage, so an item with stock on the shelf and no usage never appears. Run a separate report of items with no movement in 12 months.

Report by pool. A single list is fine for ranking. For review meetings, show raw materials, packaging and spares separately, because different people own each one.

Re-rate after equipment changes. A new filling line or a decommissioned mixer changes which spares are vital. Review criticality whenever the equipment list changes, and at least once a year.

Your checklist

  • List purchased items by pool: raw materials, packaging, spare parts
  • Pull 12 months of consumption for materials, and three to five years for spares
  • Run the ABC ranking by annual value
  • Rate every item for criticality with production and maintenance
  • Flag every vital item in class C and set a fixed minimum for it
  • Check shelf life before raising any buffer
  • Run a no-movement report for dead stock
Free Excel templateThe workbook for this series includes the Ridgeline example, with a criticality column and the combined policy for each item.
Download template

Next in the series: Post 4 sets safety stock for a manufacturer, where raw material demand comes from the production schedule and spare parts need a different method altogether.

Chmltech Ltd. helps small and mid-sized businesses improve operations and adopt digital tools. If you would like help applying this to your own inventory, get in touch.

Chmltech Insights · Free template

Download the template

Inventory ABC and Safety Stock Template (Excel workbook)

We use your details to record this request and may follow up about it. See our privacy notice.

Keep reading

Related articles

All 155 articles
Operational EfficiencyProcess Improvement

Inventory series · Part 4 of 4

Safety Stock for Manufacturers: Raw Materials and Spare Parts

Safety stock for raw materials, where supplier lead time drives the buffer, and for spare parts, where the Poisson method replaces the usual formula.

Nov 11, 2026 · 7 min read

Ready to find your next improvement?

Book a strategy call. We will talk through your goals, pain points and where AI, systems or process work can make the biggest difference.