Sign in

Blog · Wallet share and penetration · Industrial manufacturers

Catalogue fit per customer: how a manufacturer measures the product lines its customers could buy

A method for industrial and component manufacturers to measure, per customer, the product lines bought against the lines customers of that type buy, value the gap, keep direct and distributor channels from double counting, and reconcile to shipped revenue.

The short answerCatalogue fit is the product lines a customer buys against the lines customers of the same type and size buy from you, per customer, valued at your margin on each missing line. Compute it from the ERP's order history by customer, product line, channel and plant, keep direct and distributor sales as a dimension so the same shipment is never counted twice, and assert that customer revenue sums to plant and channel totals and to shipped revenue.

A component manufacturer knows what each customer bought last year. It rarely knows which product lines that customer is qualified for and has never bought from it. The order history has everything needed to work it out. This guide sets out the method, with the channel handling that makes or breaks it for anyone who sells both direct and through distributors.

The measure

Per customer:

Fit = product lines bought ÷ product lines in the norm for the customer's type and size Gap value = Σ (missing lines × your margin on the line for that band)

Per plant, channel and rep, the sum of gap values, and the concentration of revenue in the top customers.

The rows you need

  • Order history: one row per order line or per customer, product line, channel, plant and period, with revenue. From SAP, Oracle, Epicor or an export from any of them.
  • Customer master: type, size band, and for distributors whether they report point of sale.
  • Product line list: the lines as the sales team sells them.

Customer identifiers only.

Channels without double counting

Direct sales and distributor sales are both in shipped revenue, and a customer served both ways appears in both. The rule:

  1. Channel is a dimension of every row: direct, distributor, OEM.
  2. Reconcile each channel to its own shipments.
  3. Reconcile the sum of channels to total shipped revenue.
  4. Measure fit per customer per channel, and then per customer across channels only where the end customer is known.

shipped revenue = Σ channels = Σ plants = Σ customers = Σ product lines

If channels sum to more than shipped revenue, a shipment appears under both a distributor and the end customer. The assertion finds it before the fit does.

Building the norm

Band customers by type and size. For each band, the share of customers buying each line in the trailing year. The fit set is every line bought by more than half the band. Product management can add a new line to a band's set as a labelled assumption.

A worked example

Mid-size OEM band, fit set of bearings, seals, couplings and service. One customer, direct channel.

Line Bought Revenue In fit set Gap value
Bearings Yes $1.2m Yes
Seals Yes $410k Yes
Couplings Yes $120k Yes
Service Yes $40k Yes
Gearboxes No No

Full fit, no gap. The next customer in the band buys bearings only, and the same table for them shows three missing lines worth $560k at the band's margin. The plant's list opens there.

Where it goes wrong

Fit at part-number level. Thousands of parts, every customer under-penetrated, no ranking worth reading. Measure at the line the team sells.

Distributors as end customers. A distributor buying every line looks like a perfectly penetrated customer while its end customers are invisible. Keep the channel dimension and measure distributors against distributors.

Plant transfers. A customer served from a second plant after a capacity move appears under both plants. The plant assertion fails; the fix is a dated transfer.

Service booked elsewhere. Service revenue billed from a separate system never joins the order history and every customer looks like they buy no service. Bring the service export in as another file with the same customer identifiers.

Every month, per plant and channel

Mapped once, the order history produces the fit list per customer, rolled up per plant, channel and rep, reconciled to shipped revenue, every month. Covirage builds this from the export as it is. The industrial manufacturers page describes the setup, and you can upload a sample order export and see the roll-up on your own rows.

Questions people ask

We sell through distributors. How do we know the end customer?

Where the distributor reports point-of-sale, use it; where not, treat the distributor as the customer for that channel and measure its fit against other distributors. Keep the two channels apart in the roll-up and reconcile each to its own shipments. Mixing them is how the same order gets counted at the distributor and again at the end customer.

What is a product line for this purpose?

The level at which your sales team sells: bearings, seals, couplings, gearboxes, service. Not the part number. A fit measured at part-number level shows every customer missing thousands of parts and means nothing.

Where does the fit norm come from?

From your own customers. Band by type and size, and a line is in the band's fit set if more than half the band buys it. No external data needed.