Budget and forecast
- Budget: set once, used to judge performance against the plan
- Forecast: revised regularly, used to decide what to do next
A worked variance table
A company budgeted sales of Rs 50,00,000 and material cost of Rs 30,00,000 for the month. The actuals were Rs 46,00,000 and Rs 29,00,000.
| Line | Budget (Rs) | Actual (Rs) | Variance (Rs) | Type |
|---|---|---|---|---|
| Sales | 50,00,000 | 46,00,000 | (4,00,000) | Adverse |
| Material cost | 30,00,000 | 29,00,000 | 1,00,000 | Favourable |
Lower sales are adverse. Lower material cost looks favourable, but part of it is simply the result of selling less. A useful note separates the effect of volume from the effect of price.
What a good variance note contains
- The numberState the variance and whether it is favourable or adverse.
- The causeVolume, price, mix or timing.
- The impactWhat it means for the year, not only the month.
- The actionWho will do what.
Common mistakes
- Reporting the variance without explaining it
- Treating every favourable variance as good news
- Comparing different definitions of a line item
- Ignoring timing differences that will reverse next month
The person who runs the activity usually knows the real reason faster than the ledger does.
FAQs
What is a rolling forecast?
A forecast that always looks a fixed number of months ahead and is extended as each month closes.
Is a favourable variance always good?
No. A lower cost can mean lower activity or a quality compromise.
Which tool is used?
Most teams use spreadsheets, and larger firms use planning software connected to the accounting system.