Actual vs plan variance
(Actual − plan) ÷ plan for the same slice and period
- Formula
(Actual − plan) ÷ plan for the same slice and period- Unit
- %
- Aggregation rule
- Ratio of sums
- Source system
- ERP and accounting system; Plan and budget model
- Owning role
- Chief financial officer
- Frequency
- Monthly
Passport
- Grain
- Line or category × period
- Numerator
- Actual − plan
- Denominator
- Plan
- At zero or no data
- Plan is 0: “—”, not infinity.
- Limits
- One slice and one period for plan and actual. A plus on costs is bad, on revenue good: read the sign by the meaning of the line.
- Check example
- Actual, RUB: 5400000; Plan, RUB: 5000000.
(a-b)/b*100. Result: 8.0% - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: Plan versus actual, variance
- Calculation: Plan versus actual by store: pace, period forecast, required daily pace
Definition
Plan versus actual, variance: the difference between actual and plan for a line. For income minus is worse, for costs plus is worse, so the sign must be read by effect on profit; the variance is analyzed by cause: volume, price, one-offs.
Suppose planned revenue is RUB 10 million and actual RUB 9.2 million: variance −RUB 0.8 million (−8%); costs plan 4m and actual 4.3m: effect on profit −0.3m. Analyze first the line with the biggest harm to profit.