Actual spending or income against budget.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Variance
—
Variance
—
Budget used
—
Formula
Actual − budget; % = (actual − budget) ÷ budget × 100
=B2-C2Excel: B2 actual; C2 budget
For costs, a positive variance is over budget (adverse); for income it is ahead of budget.
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.