Skip to content

MODULE 6 · LESSON 35 · Practical business analytics

Budget analysis

Compare planned and actual amounts while defining the sign and scope of a variance.

By Laurence Svekis · Self-paced · All worked data is synthetic unless you supply your own source.

Try the practice ↓

PredictInspectCalculateCheckExplainTransfer

Your starting point

Prerequisites: Use the ideas and vocabulary from lesson 34; revisit its worked examples if needed.

Definition: A budget variance is the difference between actual and planned amounts under a stated convention. Here actual minus planned is positive for spending above plan. A variance percentage divides that difference by the planned amount when the plan is nonzero.

Define the sign before interpreting it

Some reports use actual minus planned; others reverse the subtraction or change favorable signs for revenue and expenses. State the convention so a positive value is not mistaken for improvement. In this lesson all examples concern expenses: positive means above plan. A number’s desirability depends on the goal and context, not its sign alone.

Reconcile categories and periods

Use mutually exclusive categories and consistent currency units. Check whether the amounts are monthly flows or balances at a point in time. Summing account balances across months would not calculate spending. Ensure totals reconcile with component records and identify transfers that could be counted twice. A personal practice dataset should be synthetic or appropriately stripped of sensitive details.

Explain the difference without inventing a cause

Overspending can reflect price changes, timing, a necessary one-time purchase or an inaccurate plan. The table alone may not distinguish these explanations. Separate the observed variance from a proposed reason and state what record would verify it. This educational analysis helps practise definitions and arithmetic; it is not a personalized financial recommendation.

Two worked examples

Amount and percentage

Planned food spending is 200 and actual spending is 230. Under actual minus planned, variance is +30. Relative to the plan, the variance is 30 ÷ 200 × 100 = 15%. The result describes spending above plan, but does not establish whether the purchase was unnecessary.

A zero plan

A category has planned spending 0 and actual spending 25. The absolute variance is +25. A relative variance percentage is undefined because the baseline is zero. Report the amount and explain that the category was unplanned rather than displaying infinity or inventing a 100% change.

Where this becomes useful

A community event tracks expenses against a plan. A category-level variance chart can help organizers ask targeted questions about timing or scope changes without turning every overrun into a judgment about waste.

Make an attempt

Load Monthly budgets in the Formula Builder. Create actual minus planned, then a variance percentage. Filter one month and reconcile category differences with the overall difference between actual and planned totals.

Open the accompanying interactive lab →

Misconception check

Claim: Positive variance always means good performance.

Inspect the correction

The sign convention and metric matter. For expenses under actual-minus-plan, positive means above the planned amount.

Independent application

Build a fictional budget with at least four categories, including a zero-plan case. Calculate absolute and defined relative variances, reconcile totals, and write a neutral explanation separating the observed differences from possible causes.

Completion records practice and self-review. It is not certification of statistical competence.