Price, Volume and Cost Margin Variance Calculator
A margin bridge answers the question every controller gets at the review: why is gross margin different from budget? This calculator splits the gap into price, volume and unit cost effects for a single product or product family.
Your numbers
Your results
Single product, two factor bridge. For several products add a separate mix variance. Positive values increase margin versus budget.
Total margin variance vs actual units
Sweeps Actual units from 5000 to 15000, holding your other inputs fixed.
Margin bridge from live ERP data
Optional: see how a read-only layer over your ERP can produce price, volume and cost bridges every close.
Optional. The tool and every export work without this. No spam.
How to use it
Enter budget units, price and unit cost, then the actual figures for the same period. Use averages over the period for price and cost. The three effects add up exactly to the difference between actual and budget gross margin, and the check line proves it. Use one product or a family with a stable mix.
- Use net price after discounts and rebates
- Use the same cost basis in budget and actual
- Run one scenario per product line, then add them up
The method
Price variance is the price difference times actual units. Volume variance is the unit difference times the budget margin per unit. Cost variance is the budget cost per unit minus the actual cost per unit, times actual units. Because price and cost are both evaluated on actual units and volume at budget margin, the three pieces sum to actual margin minus budget margin with no remainder.
Worked example
With the default numbers, budget margin is 10,000 x 16 = 160,000. Actual margin is 9,200 x 15.5 = 142,600. Price adds 18,400, volume subtracts 12,800 and unit cost subtracts 23,000, for a total of minus 17,400. The story is that the team sold less and cost per unit rose by more than the price increase recovered.
Common mistakes
Using list price instead of net price hides discount leakage. Mixing a standard cost in the budget with an actual cost in the results makes the cost variance include a costing method change. For multi product businesses, summing product level bridges is more accurate than running one blended bridge, because mix then appears explicitly.
Frequently Asked Questions
Why is volume valued at budget margin?
Because volume variance asks what extra or missing units would have earned at the planned margin. Price and cost effects are then measured on the units actually sold, which avoids counting the same dollars twice.
Can I use this for revenue only?
Yes. Set budget cost and actual cost to zero and the bridge becomes a price and volume revenue analysis. The cost variance output will then be zero.
What about product mix?
This tool handles one product. For several products, run each separately and sum the price, volume and cost lines. The difference between the sum of product volume effects and a blended volume effect is the mix effect.
Does this replace my FP&A model?
No. It is a quick way to check or explain a margin gap. Your planning system may allocate cost and discounts in ways this simple bridge does not.
If building this bridge each month means pulling sales and cost data from several reports, Netray can automate it from your ERP data with the queries shown.
Related Tools
Manufacturing Cost Variance Types Reference
A searchable table of purchase, material, labor, overhead and revenue variances with formulas, owners and first checks.
Costing & FinanceManufacturing KPI Formula and Definitions Reference
A searchable lookup of the KPI formulas controllers and operations managers argue about, with units, typical ERP source and review cadence.
Costing & FinanceMonth End Reporting Readiness Checklist for Manufacturers
Work through the ERP checks that decide whether month end reports can be trusted: cut off, inventory, WIP, subledger tie out and sign off.
More Costing & Finance tools
See all- OEE Improvement Value Calculator
- Improve OEE vs Buy a New Machine Calculator
- Six Sigma Project Savings Tracker Worksheet
- Should Cost Model Worksheet for Machined Parts
- Quote Assumptions and Exclusions Template
- Tooling and NRE Amortization Quote Worksheet
- Subcontract and Outside Processing Cost Worksheet
- Overhead Cost Pool Allocation Worksheet
- Estimate Review and Approval Form Template