This calculator gives estimates for education and planning. It is not investment, tax or legal advice; for decisions about your own situation, talk to a qualified financial professional.
A flexible budget variance analysis explains why actual profit differed from the budget. The flexible budget variance calculator takes the budgeted volume, price, variable cost and fixed costs and the actual units, revenue, variable costs and fixed costs, and gives the static profit, the flexible profit, the actual profit, the sales volume variance, the flexible budget variance and the total variance.
How the calculation works
- The static budget profit uses the planned volume: planned units × (budgeted price − budgeted variable cost) − budgeted fixed costs.
- The flexible budget profit keeps the same prices and costs but uses the actual volume: actual units × (budgeted price − budgeted variable cost) − budgeted fixed costs.
- The sales volume variance = flexible profit − static profit. It shows the effect of selling more or fewer units than planned.
- The flexible budget variance = actual profit − flexible profit. It shows the effect of prices and costs differing from the plan, at the real volume.
Example
The budget is 10,000 units at $25, a variable cost of $14 and fixed costs of $60,000, a static profit of $50,000. The company sells 11,200 units, with revenue of $290,000, variable costs of $160,000 and fixed costs of $62,500, an actual profit of $67,500. At 11,200 units the flexible budget profit is $63,200. The sales volume variance is $13,200 favorable, the flexible budget variance is $4,300 favorable and the total is $17,500 favorable.
Why it matters
Managers are judged on results against the budget, but a result is only fair to judge once the volume effect is removed. Splitting the variance shows how much of it came from selling more or less and how much from prices and costs, which they control differently.
Good to know
The calculation treats costs as purely fixed or purely variable and the budget as a single product or a stable mix. If you sell several products, a sales mix variance also arises. Fixed costs are assumed unchanged across the range of volumes, and this holds only within the relevant range of activity.
Related tools
The break-even calculator finds the volume that covers costs, the material variance calculator splits price and usage variances and the operating leverage calculator shows how profit reacts to sales.