Procurement & Supply Chain

Building a spend cube for a machine builder: categories, tail spend and should-cost

A spend cube answers three questions: what we buy, from whom, and for which machines. How to build one from ERP data, a category tree that fits machine building, and where the savings usually sit.

Not ready to talk yet? Take the 3-minute Procurement Data Check

SUPPLIER →BearingsSealsMotorsFastenersCablesMisc.ABCDEFTail spendSpend by category × supplier (darker = more)

TL;DR

  • A spend cube breaks spend down by category × supplier × business unit. Machine builders should add a fourth axis: machine type, via the BOM.
  • Most of the work is cleansing: supplier names, categories, units and currencies.
  • Tail spend rarely saves much per dollar but costs a lot of process effort. Consolidate it.
  • Should-cost on the top drawing parts gives buyers facts instead of last year’s price.
For:CPOCategory managersProcurement controllingCost engineering

What data goes in?

SourceContentSAP example
Purchase ordersItem, supplier, quantity, price, dateEKKO / EKPO
InvoicesWhat was actually paidRBKP / RSEG
Supplier masterNames, groups, countriesLFA1 (Business Partner in S/4HANA)
Material masterMaterial group, descriptionMARA / MAKT
BOMsWhich machine uses which partMAST / STKO / STPO

Which category tree fits machine building?

Level 1Level 2 examples
Machined & fabricated partsTurned, milled, sheet metal, welded assemblies
Castings & forgingsGrey iron, aluminium, steel forgings
Drives & motionMotors, gearboxes, linear guides, ball screws
Electrical & automationControls, drives, sensors, cabinets, cables
Fluid powerHydraulics, pneumatics, valves, cylinders
Standard & C-partsFasteners, bearings, seals
Purchased systemsRobots, chillers, conveyors
IndirectServices, logistics, IT, facilities

Don’t use the material group as your category

ERP material groups were set up for posting and MRP, often decades ago. Map them to a procurement category tree, and categorise by description and supplier where a material group is too broad.

What does the cube show?

SPEND BY CATEGORY ($M)Machined & fabricated$38MElectrical & automation$27MDrives & motion$19MPurchased systems$14MFluid power$9MCastings & forgings$8MStandard & C-parts$6MIllustrative example for a machine builder with $121M direct spend.
Sort suppliers by spend, descending
Top suppliers   = suppliers covering the first 80% of spend
Tail suppliers  = everyone else

Typical picture:  a few suppliers carry 80% of spend,
                  many share the remaining 20%
Tail cost driver: number of POs, invoices and supplier records, not price

Where are the savings levers?

LeverWhere it appliesData needed
Supplier consolidationFragmented categories, tailSpend per supplier and category
Should-costDrawing parts, castingsDrawing, material, process times
Volume bundlingSame part from several suppliersDeduplicated part master
SpecificationOver-specified partsEngineering review, standards
Terms & cataloguesTail, C-partsPO and invoice data

Should-cost in four steps

  1. Pick the top 50 drawing parts by spend.
  2. Model material + machining time + set-up + overhead + margin.
  3. Compare with the price paid.
  4. Take gaps above roughly 15% into negotiation, with the cost breakdown on the table.

Checklist

  • 24–36 months of POs and invoices
  • Supplier names normalised and grouped
  • Procurement category tree mapped to material groups
  • Spend linked to machine types via the BOM
  • Should-cost model for the top drawing parts

FAQ

What is a spend cube?

A data model that breaks purchasing spend down by category, supplier and business unit, usually over time. It shows where money goes and where the savings levers are.

Which data is needed to build a spend cube?

Purchase orders, invoices, the supplier master and the material master. For machine builders, BOMs add the link between spend and machine types.

What is tail spend?

The many small suppliers that together account for a small share of spend. They cost little in price terms but a lot in process effort.

What is should-cost analysis?

Calculating what a part should cost from material, process times, overheads and margin, and comparing it with the price paid. It gives buyers facts for negotiation.

How often should the spend cube be refreshed?

Monthly or quarterly from ERP exports. A one-off cube goes stale within a year.

What does your spend look like by machine type?

Send us 24 months of purchasing data under NDA. We’ll return a cleaned spend cube with your top savings levers.

Similar Posts