Gross Margin by Product Calculator: Find Which SKUs Actually Pay
This free gross margin by product calculator shows what a single SKU or product family actually earns, and is built for controllers, product managers, and sales leaders in discrete manufacturing. Enter net selling price, material, labor, applied overhead, variable selling costs, and annual volume, and the tool returns gross profit per unit, gross margin percentage, and the annual gross profit the product contributes. Most manufacturers discover that 20% to 30% of their SKUs earn less than half the company average, and a handful actively destroy margin once freight and commission are included honestly.
Your numbers
Net of discounts, rebates, and volume programs actually realized on invoices.
Fully rolled-up material including purchased components and packaging.
Burdened labor from the routing, including setup amortized over typical lot size.
Plant overhead absorbed by the part: supervision, depreciation, utilities, quality.
Costs that scale with revenue and are usually missing from a standard cost comparison.
Trailing twelve months of shipped quantity for this product or family.
Your results
Estimates only. This model treats applied overhead as a product cost, so eliminating a low-margin SKU will not release overhead dollars one for one. Confirm cost behavior before making product rationalization decisions.
Get your full product margin report
We will email you a personalized expert breakdown of your margin structure with industry benchmark comparisons, and a Netray manufacturing finance specialist will follow up with concrete next steps.
No spam. Your results stay private. Unsubscribe anytime.
Why freight and commission change the answer
Standard cost reports in SyteLine and Infor LN usually stop at manufactured cost, which makes every product look healthier than it is. At a $320 price with $226 of manufactured cost, the standard report shows a 29.4% margin. Add 6% for freight and commission, which is $19.20, and real gross profit drops to $74.80, or 23.4%. On 12,000 units that is $897,600 of annual gross profit rather than the $1.13 million the standard report implies. The gap matters most on heavy, bulky, or long-haul products where freight can consume 10% or more of revenue and is almost never allocated back to the part number.
Margin benchmarks for discrete manufacturers
Use these ranges as reference points when you rank a product portfolio. They reflect gross margin after manufactured cost and variable selling cost, which is the number that survives contact with reality rather than the standard-cost margin your ERP reports by default. Compare each product family against the band that matches its competitive position, not against your company average, because a portfolio blending build-to-print work with proprietary assemblies will always show a misleading mean. The spread within a single manufacturer is usually wider than the spread between manufacturers, and that internal spread is where the pricing opportunity lives.
- Contract manufacturing and build-to-print work typically lands between 12% and 20% gross margin.
- General discrete manufacturing with some product IP sits in the 25% to 35% range.
- Aerospace and defense components with qualification barriers routinely sustain 35% to 45%.
- Aftermarket parts and service kits often exceed 50% and are chronically under-promoted.
What to do with a low-margin product
Resist the reflex to discontinue. Applied overhead does not disappear when a SKU leaves, so cutting a 12% margin product often just reallocates that overhead onto the survivors and shrinks total profit. Work the sequence instead: reprice first, since a 5% price increase on a 23% margin product lifts gross profit by more than 20%. Next, attack material cost through resourcing or design change, because material is usually the largest bucket. Then look at routing standards, which are often wrong rather than genuinely expensive. Only after those three levers are exhausted should rationalization be on the table, and then only with a fixed-cost absorption plan.
How Netray turns margin analysis into a running system
One-off spreadsheet studies age out within a quarter, and the next one starts from scratch. Netray builds product margin reporting directly on your ERP data in SyteLine, LN, Baan, or M3, allocating freight, commission, and rebates back to the item level so leadership sees real margin rather than standard margin. We rebuild the underlying cost inputs at the same time, because margin reporting on stale standards just produces confident wrong answers faster. We then deploy on-prem AI agents that watch for margin erosion by customer, product family, and individual quote, and alert the commercial team while a repricing window is still open. Because the models run inside your network, defense and ITAR-controlled data never leaves your environment.
Frequently Asked Questions
Should I use gross margin or contribution margin for product decisions?
Use both, for different questions. Gross margin includes applied overhead and is the right lens for pricing and portfolio strategy, because it reflects the full cost of serving a market long term. Contribution margin excludes fixed overhead and answers short-term questions: whether to accept a fill-in order, or which product to run when capacity is tight. Making discontinuation decisions on gross margin alone frequently destroys profit, because the overhead simply moves elsewhere.
How do I allocate freight when customers pay shipping?
If the customer pays freight directly to the carrier, exclude it. If you prepay and add it to the invoice, record both the revenue and the cost so the net effect shows up honestly, which is often slightly negative. If you ship freight-free above a threshold, allocate actual outbound freight to the product family using weight or cube. That last case is where most manufacturers lose visibility, because the cost sits in a single distribution expense account.
Why is my margin different from what the ERP reports?
The usual culprits are stale standard costs, unabsorbed variances sitting in a plant account rather than on the part, and net price differences from rebates or annual volume credits that never reach the item level. Run the calculator with your actual realized price and your latest rolled cost, then compare. A gap above five points almost always points to variances the standard cost is quietly excluding.
Get a personalized product margin analysis and a ranked list of repricing opportunities from Netray's manufacturing finance specialists.
Related Tools
Product Cost Rollup Calculator
Roll material, direct labor, applied overhead, machine time, and scrap loss into a single defensible unit cost the way your ERP cost rollup should.
ERP OperationsQuote Margin Analyzer
Pressure-test a quote by amortizing setup across the order quantity, adding commission, and showing the price required to hit a 30% target margin.
ERP OperationsLabor Burden Rate Calculator
Convert base wages into a fully burdened hourly rate using payroll taxes, workers comp, retirement match, benefits, and paid time off.
Go Deeper
Manufacturing Costing Methods Compared: Standard, Actual, Average
Standard, actual, and average costing compared for manufacturers: variance analysis, ERP setup in SyteLine and LN, DFARS considerations, and AI cost intelligence.
ERP RFP Template for Discrete Manufacturers
A complete ERP RFP template for discrete manufacturing: requirements matrix, CMMC and ITAR questions, weighted scoring model, and vendor demo scripts.