← All insightsProfitability

Why your best product may be losing you money

Almost every manufacturing business has a product everyone is proud of. It has the highest margin in the costing, sales likes to push it and planning gives it priority. But what if the number behind that pride is not true?

The product that looked like the best

A food manufacturer with €17 million revenue had a clear winner. According to the costing, product A carried a markup of almost 40% and made up 29% of sales. Products B and C looked average by comparison, with a markup of around 5%.

We then recalculated product costs from measured process times and actual production routes. The picture reversed.

ProductPriceUnit cost beforeUnit cost afterMarkup beforeMarkup after
A€8.70€6.22€8.8339.9%−1.5%
B€9.56€9.12€7.474.8%28.0%
C€10.12€9.56€8.065.9%25.6%

The “best” product was losing money on every unit sold. The two products the company considered average were in fact the most profitable.

“We knew we had a problem, but we couldn’t put our finger on it.”

Managing director, before the project

Why the costing does not tell the truth

A costing is a model, and a model is only as good as the data in it. In manufacturing businesses it most often breaks in five places.

  1. Overheads are allocated with the wrong key. If you allocate them by labour hours or material value, products that use a lot of machine time, changeovers or quality control carry too little cost. Other products pay for them.
  2. Standard times are out of date. They were set when the product was launched; since then machines, recipes, people and batch sizes have changed. The ERP still holds the old numbers.
  3. Routings in the ERP do not match the product’s real path. The product goes through an extra operation, waits on another line or is reworked by hand, and none of it is in the system.
  4. Different production routes have different costs. The same product can run on a fast or a slow route. The costing knows only one.
  5. Averages hide small batches. Changeovers, start-ups and scrap are spread evenly across all products, even though only a few of them cause it.

At the food manufacturer, three of these errors showed up at once: re-measured times, corrected routings and reallocated overheads each revealed mistakes in the costing on their own.

Why it costs more than it seems

A wrong costing is not just an accounting inaccuracy. Decisions are built on it:

The business works more, sells more and earns less. And because the numbers in the report look logical, nobody knows exactly where the problem is.

What the company did

The project took two months. The client team was two people, two hours a week each.

First, fix the cost picture. We measured the actual times of production operations, used value stream mapping to show how different production routes affect product costs, corrected the routings and reallocated overheads. The new costings now run every month in the client’s ERP (Microsoft Dynamics NAV).

Then, fix the plan. With the right costs, monthly production plans gave priority to products B and C. The company raised the price of product A by 20%. Volume fell by 40%, and the product moved from a loss to a markup of around 18%.

€219,600annual EBITDA improvement, measured on actual monthly results
12.1% → 13.4%EBITDA margin
+8%revenue, as freed-up capacity moved to B and C

What mattered most was not a corrected report but a changed decision: the company sold less of its “best” product and earned more.

Five questions for your business

  1. When were standard times in your production last measured, rather than copied over?
  2. What key do you use to allocate overheads, and does it reflect what products actually use: machine hours, changeovers, quality control?
  3. Do the routings in your ERP match the path the product really takes through production?
  4. Does the product with the highest costed margin also have the most changeovers, the smallest batches or the most scrap?
  5. Does your production plan choose products by actual profitability, or by habit and sales pressure?

If you have no reliable answer to two or more of these, there is a good chance the profitability ranking of your products is not what the costing shows.

Where to start

You do not need to build a perfect costing system straight away. Start narrow:

  1. pick the three to five products with the largest share of sales,
  2. measure their actual times and routes through production,
  3. allocate overheads according to what the products really use,
  4. compare the new costing with the old one.

If the profitability ranking of your products changes, you have found money. The next step is to carry that change into prices and the production plan, not just into the report.

Products in the case are anonymised. Markup is calculated on unit cost. The EBITDA improvement was measured on actual monthly results.

Full case study: Production controlling (PDF) ↗

Share this articleLinkedInEmail
Read next
Working capital

Less inventory, more cash, but not more profit

Reducing inventory releases cash, but EBITDA usually falls in the year of the reduction. Three traps, a case from practice, a board table and six steps to keep the warehouse from filling up again.

· 9 min read