Profit Margin Variance Analysis Calculator
Decompose the gap between budgeted and actual gross profit into sales volume, selling price, and variable cost variances. Educational. Runs in your browser.
This decomposes the change in gross profit between plan and actual into three drivers. Volume variance isolates selling more or fewer units (valued at the budgeted margin); price variance isolates charging more or less per unit; cost variance isolates spending more or less per unit. By construction the three sum exactly to the total variance (actual − budget gross profit). Favorable means the driver increased profit. Educational; everything runs in your browser.
About this tool
Variance analysis answers the question every manager asks after the numbers come in: we planned one gross profit and delivered another — so what actually drove the gap? Simply knowing that profit came in above or below budget is not enough; the value is in attributing the difference to specific, controllable causes. This calculator performs the classic three-way decomposition of the gross-profit variance using budgeted versus actual price, variable cost, and unit volume. The sales volume variance isolates the effect of selling more or fewer units than planned, valued at the budgeted contribution margin per unit, so it captures the volume effect cleanly without contaminating it with price or cost changes. The selling price variance isolates the effect of charging more or less per unit than budgeted, applied to the actual units sold. The variable cost variance isolates the effect of each unit costing more or less to make than planned, again on actual volume. A key property — and a good check on the method — is that these three pieces sum exactly to the total variance (actual gross profit minus budgeted gross profit), so nothing is left unexplained. Each piece is labeled favorable (it raised profit) or unfavorable (it lowered profit). Managers use this to separate, say, a good quarter that was really just higher volume from one driven by genuine pricing power or cost discipline — and to know where to act. This is educational. Everything runs in your browser; nothing is uploaded.
How to use it
- Enter the budgeted (planned) price per unit, variable cost per unit, and units.
- Enter the actual price, variable cost, and units for the period.
- Read budget and actual gross profit and the total variance.
- Review the volume, price, and cost variances — they sum to the total — and the favorable/unfavorable tags.
Frequently asked questions
- What is profit (gross margin) variance analysis?
- It breaks the difference between budgeted and actual gross profit into the specific causes — how much came from selling more or fewer units (volume), from price changes, and from cost changes — so managers can see what really drove the result.
- How are the three variances calculated?
- Volume variance = (actual − budget units) × budget margin per unit. Price variance = (actual − budget price) × actual units. Cost variance = (budget − actual cost) × actual units. They sum exactly to actual minus budgeted gross profit.
- What does favorable vs unfavorable mean?
- Favorable means the driver increased profit relative to plan (e.g. higher price, lower cost, more units); unfavorable means it reduced profit. The sign of each variance in this tool reflects its effect on profit.
- Why value the volume variance at the budgeted margin?
- To isolate the pure volume effect. Using the budgeted contribution margin per unit keeps price and cost changes out of the volume figure, so each variance measures one cause without overlap — which is why the three add up to the total.
- Do the variances always sum to the total variance?
- Yes. This three-way decomposition is algebraically exact: the sales volume, selling price, and variable cost variances always add up to the difference between actual and budgeted gross profit, leaving nothing unexplained.
- Is anything uploaded?
- No. All calculations run entirely in your browser.