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
Keep exploring
Free tools
- Purchase Price Variance CalculatorCalculate purchase price variance from standard and actual price, see percent variance, annual impact and how PPV moves as price changes.
- Purchase Price Variance (PPV) WorksheetCalculate purchase price variance line by line from quantity, standard price and actual price, with totals and percent of spend.
- Purchase Price Variance Analysis WorksheetList received parts with standard and purchase price to see PPV in currency and percent, and which items drive it.
ERP fixes and how-tos
- How to Set Up Budgets and Budget vs Actual in NetSuiteCreate budgets in NetSuite by account, department, class or location, import them by CSV, and run Budget vs Actual reports to track spend against plan.
- SAP Purchase Price Variance (PPV) Report: T-Codes, Accounts and AnalysisHow purchase price variance arises in SAP, the PRD price difference account, and the tcodes and tables to report and analyze PPV by material and vendor.
- How to Enter an AP Voucher in SyteLineEnter a SyteLine AP voucher against received POs or as a non-PO expense, understand three-way matching and distributions, and fix common voucher problems.
Guides
- Setting Up Cost Variance Analysis in SyteLineConfigure cost variance analysis in Infor SyteLine for material, labor, and overhead variances. Set up variance reporting for standard cost manufacturing environments.
- Gross Margin Analysis by Product and CustomerGross margin analysis by product and customer: build a contribution model in ERP, allocate freight and rebates, and find the 20 percent of SKUs losing money.
- Investigating Costing Variances in SyteLineInvestigate SyteLine costing variances: identify the variance type, trace purchase price and job variances, and reconcile the results to the general ledger.