Explain the profit change, not only the percentage change
A revenue variance does not explain an EBITDA variance. For a contribution-based MIS, value sales-volume changes at budgeted contribution, then separately calculate price, variable-cost and fixed-cost effects. Where the products share a meaningful common unit, split volume into total quantity and mix. The components must sum exactly to actual profit less budget profit.
This is a management accounting method, not a statutory Schedule III format or a legal pricing rule. ICAI Board of Studies standard-costing practice material illustrates sales and cost variances and profit reconciliations under marginal and absorption costing. The method below uses original figures and one explicit convention: favourable effects on profit are positive; adverse effects are negative.
Keep the baseline and units fixed
For each product retain budget units BQ, actual units AQ, budget net selling price BP, actual net selling price AP, budget variable cost per unit BV and actual variable cost per unit AV. Budget contribution per unit BC equals BP − BV. Prices exclude GST and reflect the same discount/return policy; actual variable cost must relate to the units sold. Budget and actual fixed operating costs are separately identified.
The model assumes no inventory absorption difference, lease-accounting difference, non-operating item or unallocated operating expense outside the stated cost totals. In a real manufacturing MIS, reconcile production to sales, opening/closing inventory and fixed-production-overhead absorption before comparing the management contribution result with financial statements. Direct cost is not automatically variable cost; classify behaviour using the relevant activity range.
Use a bridge that closes mathematically
| Component | Formula: signed profit effect | Interpretation |
|---|---|---|
| Sales volume at standard contribution | Σ(AQ − BQ) × BC | Quantity and mix together; not a revenue variance. |
| Sales price | ΣAQ × (AP − BP) | Price effect on actual units sold. |
| Variable cost | ΣAQ × (BV − AV) | Higher unit cost produces an adverse effect. |
| Fixed operating spending | Budget fixed cost − actual fixed cost | Does not automatically flex with sales volume. |
| Total profit movement | Sum of the four components | Actual contribution less actual fixed cost, minus budget profit. |
For a meaningful common unit, revised standard-mix quantity RSQ for product i = total actual units × budget quantity share for that product. Quantity effect = Σ(RSQ − BQ) × BC; mix effect = Σ(AQ − RSQ) × BC. Together they equal the sales-volume contribution variance. Keep full precision until reporting; two-decimal presentation must still reconcile.
Do not add unlike quantities such as tonnes, software seats and consultant-hours to manufacture a product-mix variance. Analyse suitable families or use separately defined operational drivers. For new or discontinued products, present a scope change with a documented baseline rather than inventing a prior-period unit margin.
Separate findings from reasons
The bridge quantifies where profit changed. It does not prove why: price pressure may arise from discounts, customer mix or contractual changes; variable-cost differences may arise from rates, usage, yield or cost classification. Attach transaction and operational evidence before assigning responsibility. A material price variance measured on purchases must be reconciled for inventory before combining it with consumption-based profit effects.
Worked illustrations
These illustrations use fictional facts and expressly stated assumptions. Amounts are Indian rupees unless a different currency or unit is specified. They are independent examples, not findings about any actual client.
Illustrative example 1: Budget and actual totals on a common basis
Product A: budget 1,000 units at price ₹1,000 and variable cost ₹600; actual 800 units at price ₹950 and variable cost ₹620. Product B: budget 500 units at price ₹1,600 and variable cost ₹1,000; actual 900 units at price ₹1,500 and variable cost ₹1,060. Budget sales are ₹18,00,000, variable costs ₹11,00,000 and contribution ₹7,00,000. Actual sales are ₹21,10,000, variable costs ₹14,50,000 and contribution ₹6,60,000. With budget fixed cost ₹4,00,000 and actual ₹4,30,000, operating profit falls from ₹3,00,000 to ₹2,30,000 despite higher revenue.
Illustrative example 2: Split total volume into quantity and mix
For the same products, budget contribution is ₹400 per A and ₹600 per B. Total volume effect = (800 − 1,000) × 400 + (900 − 500) × 600 = ₹1,60,000 favourable. Budget mix is two-thirds A and one-third B. At 1,700 actual units, RSQ is 1,133⅓ A and 566⅔ B. Quantity effect is ₹93,333.33 favourable; mix effect is ₹66,666.67 favourable. Their sum is ₹1,60,000. Fractional RSQ is an analytical comparator, not a physical production instruction.
Illustrative example 3: Price discounts consume the volume benefit
A price effect = 800 × (950 − 1,000) = −₹40,000. B price effect = 900 × (1,500 − 1,600) = −₹90,000. Total price effect is −₹1,30,000. Revenue at actual quantities and budget prices is ₹22,40,000; actual revenue ₹21,10,000 is ₹1,30,000 lower. This price effect can enter the contribution bridge directly because the cost effect is separately reconciled.
Illustrative example 4: Flex variable cost to the actual product quantities
Standard variable cost for actual sales = 800 × 600 + 900 × 1,000 = ₹13,80,000. Actual variable cost is ₹14,50,000. Variable-cost effect is −₹70,000: A contributes −₹16,000 and B −₹54,000. Comparing actual cost only with the static ₹11,00,000 budget would show a ₹3,50,000 increase, but ₹2,80,000 of that is the standard-cost effect of changed quantities/mix, not this unit-cost variance.
Illustrative example 5: Keep fixed spending separate
Budget fixed operating costs of ₹4,00,000 versus actual ₹4,30,000 give −₹30,000 spending variance. Raising the fixed-cost budget in the same ratio as sales would hide this difference unless those costs are demonstrably activity-driven. Step-fixed additions need an approved revised forecast alongside, not a silent rewrite of the original budget.
Illustrative example 6: Close the complete operating-profit bridge
Budget profit ₹3,00,000 + quantity ₹93,333.33 + mix ₹66,666.67 − price ₹1,30,000 − variable cost ₹70,000 − fixed spending ₹30,000 = actual profit ₹2,30,000. Net movement is −₹70,000. Revenue growth is ₹3,10,000 ÷ ₹18,00,000 = 17.22%, while profit falls ₹70,000 ÷ ₹3,00,000 = 23.33%. The opposite directions are fully reconciled, not contradictory.
Illustrative example 7: Decompose a material-cost difference without duplicating it
Independent case: 500 units produced and sold, with no stock movement. Standard material input is 2 kg per unit at ₹50/kg: standard cost ₹50,000. Actual consumption is 1,050 kg at ₹52/kg: cost ₹54,600. Price effect on consumption = (50 − 52) × 1,050 = −₹2,100; usage effect = (1,000 − 1,050) × 50 = −₹2,500. Total −₹4,600 matches the cost difference. These are components of the material-cost variance, not extra adjustments to add after already deducting that variance.
Ten-step verification table
| Step | Verification | Evidence to retain |
|---|---|---|
| 1 | Freeze the approved budget version and reporting scope. | Dated budget and revision register. |
| 2 | Agree net revenue and actual operating cost totals. | Closed P&L and ledger reconciliation. |
| 3 | Validate product/customer units and credit-note treatment. | Sales quantities and invoice/return mapping. |
| 4 | Separate variable, mixed and fixed cost behaviour. | Approved cost-driver assumptions. |
| 5 | Reconcile production, sales and inventory valuation. | Quantity roll-forward and absorption bridge. |
| 6 | Calculate volume at budget contribution per unit. | Product-level standard-margin worksheet. |
| 7 | Split quantity/mix only within a meaningful unit family. | Budget shares, RSQ and unrounded calculations. |
| 8 | Calculate price, variable-cost and fixed-spending effects. | Actual-volume flex and cost schedules. |
| 9 | Tie all effects exactly to the profit movement. | Zero-difference reconciliation and rounding check. |
| 10 | Validate causes and assign corrective action. | Evidence, accountable owner and commercial decision log. |
Sixteen practitioner FAQs
1. Why use contribution instead of sales value for the volume effect?
The bridge explains profit. Extra units contribute their standard price less standard variable cost; using selling price alone would omit the volume-related cost.
2. Can a separate revenue bridge also be prepared?
Yes. Use budget selling price for revenue-volume effects and reconcile to actual sales. Label it separately from the contribution/profit bridge.
3. Is mix always favourable when higher-priced products sell more?
No. The relevant metric here is budget contribution per unit on a comparable unit basis; a higher selling price can accompany a lower contribution.
4. What if products have different measurement units?
Do not sum incompatible units. Create comparable families or separately analyse each driver and reconcile the monetary effects.
5. Why use actual quantities in the price variance?
That convention compares actual revenue with revenue at budget prices for the units actually sold and allows the other components to close consistently.
6. Are direct salaries automatically variable?
No. Direct attribution and cost behaviour are different questions. Classify salary commitments using actual terms and the relevant operating range.
7. Should fixed rent increase in the flexible budget?
Only if a supported change in cost behaviour or capacity requires it. A fixed monthly commitment does not change simply because sales change.
8. How are sales returns handled?
Use a consistent net-sales and quantity policy. Separate timing corrections and prior-period returns where they distort current-period price and volume.
9. Can actual production replace actual sales units?
Not without an inventory reconciliation. A sales-contribution bridge uses sold units; production-cost variances require a bridge through stock.
10. What happens to purchase-price variances in closing inventory?
Their profit effect depends on what was consumed and sold and on the accounting treatment. Do not expense an entire purchase variance merely because it was calculated.
11. How should a newly launched product be presented?
Identify a scope effect and a documented comparison baseline. A percentage change from zero or an invented historical margin is not meaningful.
12. Can a revised forecast replace the original budget?
Present both with clear version labels. Keeping the original plan preserves accountability; the revised forecast supports forward decisions.
13. Does a favourable usage variance prove good quality?
No. Lower input may reflect yield improvements or under-specification. Check quality, rejects, returns and rework evidence.
14. How should rounding be controlled?
Calculate at full precision and round for display. Reconcile displayed totals and identify any immaterial presentation adjustment explicitly.
15. Should material price and usage variances be added to the total variable-cost variance?
They should explain or replace the relevant component, not be added again. Maintain a hierarchy in which sub-variances sum to their parent.
16. What makes the commentary useful to management?
State the quantified effect, evidenced cause, affected customer/product, decision owner and next action. Avoid attributing causes from aggregate numbers alone.
Conclusion
Keep revenue and contribution bridges distinct, preserve the original budget, and reconcile every component to actual operating profit. Use the bridge to direct investigation before assigning a cause or changing prices.