How to calculate budget variance and find the gap
The short answer
Subtract budgeted sales from actual sales for the quarter to date to calculate budget variance, then divide by budget for the percentage. A negative figure means you are behind. To find where the gap comes from, split it into customer count, purchase frequency and average order value, by channel and category.
Sales budget variance analysis, step by step
Why it matters
A single variance number tells you sales are off plan without saying why, and each cause needs a different fix. Splitting the gap by customers, frequency and order value points the response at the right team while the quarter can still be recovered.
The question to ask
Copy this into Lexi as written.
How to work it out
1. Compare like periods. Line up budget vs actual sales for the same weeks to date, by channel and category.
2. Calculate the variance. Subtract budget from actual, and divide by budget for the percentage.
3. Split the drivers. Break the gap into active customers, orders per customer and average order value, against the assumptions behind the budget.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a pet retailer eight weeks into the quarter. It splits the budget variance into active customers, order frequency and average order value.
- Budget to date: $18.0 million. Actual: $17.1 million, 5% behind.
- Active customers: 389,000, against 410,000 budgeted
- Orders per customer: 1.8, on plan
- Average order: $24.42, against $24.40
What the data shows
Frequency and order value are on plan, so the whole gap comes from 21,000 fewer active customers.
What it means
New customer acquisition is down 30% against budget, while existing customers are buying as planned.
What to do
Focus the rest of the quarter on acquisition, and leave existing-customer promotions as planned.
Would you like the acquisition shortfall split by channel?
Frequently asked questions
What does budget vs actual sales variance tell you?
It shows how far sales are from plan, in dollars and as a percentage of budget. A positive variance means ahead and a negative one means behind. On its own it does not explain the cause, so pair it with the drivers behind the budget, such as customer count, order frequency and average order value.
Why is total variance not enough to act on?
The same shortfall can come from fewer customers, fewer orders per customer or smaller orders, and each needs a different response. A marketing push will not fix a pricing problem, and a promotion will not replace missing customers. Splitting variance by driver tells you which lever to pull.
When should retail budget variance trigger a reforecast?
When the gap holds for several weeks and traces to a driver that will not recover on its own, such as a lasting drop in new customers. A one-week miss caused by weather or a shifted promotion usually corrects itself. Set a threshold, such as 3% for three straight weeks, and reforecast when it is crossed.