Start with one period and one sales total

Take sales by customer for the last 12 completed months from your invoicing records. Use figures excluding VAT and treat credit notes consistently on every row. Do not add outstanding quotations, a customer's forecast or an order that has not yet been delivered to invoiced sales.

Combine different account numbers belonging to the same customer before calculating. Pay particular attention to cases where the same buyer orders for several sites. If necessary, also review sales by corporate group, but do not count a group and its companies as separate customers in the same table: that would count the same sales twice.

The sum of customer sales must match total sales for the selected period. If there is a difference, resolve it first. An attractive percentage is no help if some invoicing is missing from the denominator.

Calculate the largest customer's share and the top three's share

Sort customers by sales. Calculate two figures:

  • Largest customer's share: largest customer's sales ÷ total sales × 100%.
  • Top three customers' share: combined sales of the three largest customers ÷ total sales × 100%.

The first shows the weight of a single customer relationship. The second shows how much of your sales rests on a few decision-makers. Neither figure alone tells you about customers' profitability, ability to pay or how easily missing work could be replaced.

Sales of five example customers over the same 12-month period
CustomerSalesShare
A400 000 €40%
B250 000 €25%
C150 000 €15%
D120 000 €12%
E80 000 €8%
Total1 000 000 €100%

The largest customer's share is 40%. The top three's share is (400 000 + 250 000 + 150 000) ÷ 1 000 000 = 80%. Five account numbers do not mean five equally strong supports in this example.

Do not treat, for example, 30 or 50 percent as a universal safety threshold. The same share may mean different risks for a series manufacturer and a project-based machine shop. Canadian business lender BDC identifies customer concentration as something to examine during acquisition due diligence. That supports investigating the issue, rather than setting one percentage threshold for everyone. Source: BDC, business due diligence.

Trace the change from revenue to an individual machine

Continue with the same illustration. If sales to customer A fell by a quarter, annual sales would fall by 100 000 €. That is 10% of the example machine shop's total sales, even if the customer relationship continued.

A fall in revenue is not the same as a fall in profit. Materials and bought-in operations may no longer be needed, but not all wage, premises and machine costs can be reduced at the same pace. Calculate the effect using the contribution margin on those jobs and the same cost boundaries you use when pricing quotations.

Then look at the operations. If A loads one lathe and a separate measurement station, the released time is not spread evenly across the workshop. Average utilisation may hide the fact that one particular machine loses its second shift's work.

The article on machine utilisation shows how available hours and contribution margin are linked. The next question here is who will buy those hours if the current customer reduces orders.

Different customer accounts may depend on the same order

Three different companies may supply the same end customer's project. They may also share an owner, an investment cycle or demand that rises and falls at the same time. Three billing addresses then spread demand less than the list suggests.

Alongside the largest customers, add the connection you actually know: a corporate group, an end customer's project or an industry. Leave unknown information blank. Do not infer the end customer solely from a part's shape or a customer's website.

Make the same check for contracts. The existence of a framework agreement alone does not tell you what quantities the buyer has committed to ordering. Read the quantity, forecast and termination terms separately. Record a binding order and the customer's preliminary estimate in different columns.

Compare past sales with the upcoming workload

The share over the last 12 months changes slowly. A large customer's orders may stop today, but its share of past sales will stay high for a long time. That is why monitoring the percentage alone comes too late for production planning.

Make a short worklist for the largest customers. Record the volume of confirmed orders, the last confirmed delivery week, the expected decision date for the next order and who will confirm it with the buyer. Keep information from the buyer separate from your own estimate.

If the buyer says a new drawing revision will arrive in a month, the next action is to confirm the timetable for the revision and RFQ. If the buyer's own project has been halted, renewing a quotation alone does not create work. The action must address the reason.

Reduce dependence while retaining a good customer relationship

A large customer may be the machine shop's most profitable and predictable customer. Reducing its share does not mean rejecting good work. The first goal may be to grow other sales for the same machines affected by the concentration.

Define the work you seek by capacity: manufacturing process, material, part size, batch size and delivery rhythm. A new customer that needs a completely different machine will not fill the hours released by the existing customer.

Then choose one step to track. It might be finding out about a smaller existing customer's next project or confirming the decision date for a quotation already sent. The quotation follow-up workflow helps turn an open quotation into an agreed next task.

Calculate it using your own data

The customer concentration Excel calculator calculates the largest customer's share and the top three customers' share. After requesting the download, you fill in the file on your own computer; customer-specific sales figures remain in the file.

Enter one customer per row and check that all sales for the period are included. The calculator has 30 customer rows. If you have more customers, calculate the total in a larger spreadsheet: do not group the remaining customers into one “other” customer that could incorrectly appear among the top three.

The workflow in this article is simple: update the shares, for example at month-end, and review the largest customers' upcoming orders at the same time. The percentage shows the size of the dependence. The next order confirmed with the buyer tells you whether action is needed now.

Once the dependence is known

If you need more buyers for the same machines, you can start with a free visit from Ironspan. We review the kind of work that fits the capacity and where it makes sense to expand the customer base.