Plan versus actual, variance
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.
Formula
Variance = actual − plan; for costs the effect on profit = plan − actual
How to read
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.
Where it is discussed
Topics
- Revenue, profit and costs
- Store and chain
- Forecast and budget
- Order data quality
- Store sales and receipts: traffic, conversion, ticket
- Scenarios and plan stress test
- Business valuation and raising capital
Calculations
- Revenue analysis: price, volume and mix
- Plan versus actual by store: pace, period forecast, required daily pace
- Sales plan by store
- Annual budget by month
- Income and expense budget: plan versus actual
- Cost of order mismatches and payback of the fix
- Runway: how many months the cash lasts
Documents
- Budget: P&L, cash, purchase, marketing, payroll and CAPEX budgets
- Plan versus actual and profit factor analysis (bridge)
- Sales plan
- S&OP: cycle and documents
- The financial audit of a brand: P&L, profit bridge, loss map and checklist