Every month, the sales manager of a mid-sized manufacturing company places the same table on the desk: products ranked by revenue, numbers looking solid. But when the monthly profit figure comes in, it does not match expectations. The highest-revenue product may be contributing the least to actual profit. This is not a coincidence — revenue figures viewed without cost allocation give managers an incomplete picture. Analytical reporting tools address exactly this gap, turning product-level profitability into a manageable, repeatable process.
Product-level profitability analysis goes beyond comparing sales revenue against direct material costs. Standard accounting software typically calculates gross margin by subtracting raw material costs from revenue, which is a useful starting point but not the full story. Indirect costs — warehouse space occupied, machine time consumed on the production line, the sales representative’s time, packaging expenses — are rarely assigned to individual products in basic setups. Contribution margin analysis distributes these indirect costs across products using defined allocation keys, revealing what each product truly earns for the company after absorbing its fair share of overhead.
This is where the analytical reporting modules of ERP systems prove their value. When data from accounting, inventory, and production modules flows into a unified structure, cost allocation rules can be defined and applied consistently. Warehouse costs can be distributed based on average inventory days per product; machine costs can be spread according to production time consumed. Once this allocation logic is configured, the system applies it automatically each reporting period, and the manager can read a product-level profitability table directly from the screen without manual calculation.
When this kind of analysis is run for the first time, the results are often surprising. In a typical scenario, two out of three high-revenue products may turn out to generate losses once overhead is properly allocated. These products may be underpriced, or their production processes may consume disproportionate resources. Meanwhile, a product with modest revenue figures can emerge as the most profitable item in the portfolio — because its low inventory turnover time, simple packaging, and short production cycle make it genuinely efficient. Without this information, portfolio decisions rely on intuition rather than evidence.
Contribution margin analysis has a direct impact on portfolio management decisions. Which products need pricing reviews, which should have production volumes increased, and which should be removed from the catalogue — all of these choices become grounded in data rather than sales volume instinct. The sales team also gets a different kind of direction: working toward profitability targets rather than pure revenue targets changes which products they prioritize and which customer segments they approach. Some companies, after running this analysis regularly, find that they can achieve higher net profit from the same total revenue, simply because the sales mix shifts toward genuinely profitable products.
In practice, the most common difficulty is setting up the cost allocation keys correctly. Deciding which expense category gets assigned to which product, and by what measure, requires both accounting knowledge and an understanding of production operations. Configuring this logic in the ERP system for the first time typically means bringing together finance, production, and operations teams to agree on the cost structure. Beyond the initial setup, the analysis depends on clean data: machine time records from the production module and inventory turnover figures from the stock module need to be maintained accurately and consistently. If the underlying data is unreliable, the profitability output will be too.
For a small or mid-sized business owner ready to implement product-level profitability analysis, a practical sequence looks like this: first, verify whether the existing ERP or accounting software supports cost centre definitions and cost allocation rules. Second, identify at least three indirect cost categories and define an allocation measure for each — warehouse area, machine hours, or labour time are common starting points. Third, run the report monthly and use the output to review pricing, production, and sales decisions. Looking at a revenue table may be a long-standing habit, but looking at a profitability table can become one too — and the difference is that the second table shows what is actually happening.
This article was originally written in Turkish by Gökhan MERCANOĞLU on April 23, 2007 and has been automatically translated into English and other languages using machine translation.