Check the weights behind the headline percentage
A company's total margin can decline even when each segment's margin improves. The result depends on both the margin earned within each segment and the share of revenue that segment represents. If sales move strongly toward a lower-margin segment, better execution inside both segments may be outweighed by the changing mix.
The first check is arithmetic. Calculate total margin as total profit divided by total revenue, using the same profit definition for every row. Do not average the segment percentages unless each segment has the same revenue. Then retain the revenue weights beside the percentages so the report shows why a large segment has more influence on the total.
This is a management analysis of a defined margin measure. Gross margin, contribution after fulfillment and operating margin include different costs. Choose one, reconcile it to the underlying records, and keep its definition stable across the periods. ACCA's CVP analysis makes product-mix assumptions explicit; activity-based analysis offers a separate framework for understanding the costs behind individual customers or segments.
References: ACCA: Cost-volume-profit analysis; ACCA: Activity-based management
An illustrative business with two segments
In the first period, Segment A produces $800,000 of revenue at a 20% margin and Segment B produces $200,000 at a 10% margin. Profit is $160,000 plus $20,000, or $180,000 on $1 million of revenue. The company's combined margin is 18%.
In the second period, A improves to 22% but produces only $200,000 of revenue. B improves to 12% and produces $800,000. Profit is now $44,000 plus $96,000, or $140,000. The company earns a 14% total margin even though both segment percentages rose by two percentage points.
Neither segment manager's percentage report is necessarily wrong. The consolidated report answers a different question because the sales weights changed from 80% A and 20% B to 20% A and 80% B. Reviewing only the total would miss the within-segment improvement; reviewing only the segment percentages would miss the $40,000 reduction in profit.
| Measure | First period | Second period |
|---|---|---|
| A revenue / margin | $800,000 / 20% | $200,000 / 22% |
| B revenue / margin | $200,000 / 10% | $800,000 / 12% |
| Combined revenue | $1,000,000 | $1,000,000 |
| Combined profit | $180,000 | $140,000 |
| Combined margin | 18% | 14% |
Hold the old mix constant to explain the change
Apply the new segment margins to the old revenue weights. Eighty percent multiplied by 22%, plus 20% multiplied by 12%, gives a 20% margin. Under that convention, improvements within the segments add two percentage points to the original 18% margin.
Next change the weights to the new 20% and 80% mix while retaining the new margins. The result falls from 20% to 14%, so the mix effect is negative six percentage points. The bridge reconciles: 18%, plus two points of within-segment improvement, less six points from mix, equals 14%.
The attribution depends on the sequence. Holding the old margins while changing mix first gives a different division between interaction effects. State the convention and use it consistently. The purpose is to make the total understandable, not to present one mathematical allocation as the only possible explanation.
Investigate the commercial reason for the mix shift
A lower-margin segment may still generate useful profit dollars, support a customer relationship or use capacity that would otherwise sit idle. A mix analysis does not by itself justify cutting that segment. Review demand, delivery capacity, acquisition spending and the costs that would change if the sales mix changed again.
In this example, A's $600,000 revenue decline deserves investigation. It could reflect lost customers, delayed shipments, a deliberate move away from low-quality business within A, or a product classification change. B's growth could be attractive in its own terms while failing to replace A's lost contribution. The appropriate action depends on which explanation the transaction records and commercial teams support.
Keep a separate view of absolute profit. A percentage target can encourage a team to turn away profitable incremental work when the cost base cannot be reduced. Conversely, growth in profit dollars can conceal a deteriorating return on capacity or cash. Review the constraints relevant to the decision.
Use comparable cohorts when customers enter and leave
Segment membership can change. If low-margin customers leave, the average margin of the surviving customers may improve without any change in their individual economics. Preserve customer identifiers and compare continuing customers separately from new and departed customers before describing the result as better service efficiency.
One useful layout shows the previous period's full population, the continuing-customer population in both periods, new customers and departed customers. Reconcile their revenue and profit back to the total. State whether a customer that moves between segments retains its prior classification for comparison or moves to the current classification in both periods.
Avoid treating an incomplete cohort as a finished outcome. A recently acquired customer may not yet have incurred onboarding, returns or support costs. Compare customers at similar stages when those expenses materially affect profitability, and retain a separate current-period view for the accounting reconciliation.
Give the report a decision that matches the evidence
Do not replace the actual consolidated margin with the fixed-weight result in the headline accounts. The fixed-weight percentage is a diagnostic comparison: it shows what the rate would have been under a specified sales composition. Presenting it beside the actual result preserves that distinction and prevents a useful analytical adjustment from being mistaken for earned profit.
For a pricing review, show realized prices and variable delivery costs within the relevant segment. For a capacity decision, show contribution per constrained resource as well as total contribution. For a customer-service review, examine the activities that make certain accounts more expensive to support. A sales-mix bridge locates the change; it does not replace those more specific analyses.
Before publishing, test that revenue weights sum to 100%, segment profit adds to consolidated profit and the bridge explains the entire percentage-point movement. Keep percentage points distinct from percentage changes: a fall from 18% to 14% is four percentage points, or approximately a 22.2% decline in the margin rate.
The commentary can then be precise: segment margins improved, but a shift toward Segment B reduced the combined rate and profit dollars. Attach the actual sales movements and the proposed commercial response. Readers should be able to identify which change management can influence without mistaking a composition effect for an operating failure.
Sources
Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.
Related reading
Need help with this work?
General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.