Plan vs Actual Variance Formula
How apparel planners and analysts calculate variance against plan — the diagnostic signal for every merchandise financial plan.
What Plan vs Actual Variance measures
Variance is the percentage by which actual results differ from plan. It applies to every metric — sales, receipts, markdowns, margin, inventory — and is the core diagnostic signal for the merchandise financial plan.
Variance % = (Actual − Plan) ÷ Plan × 100A variance number alone is not an insight. Paired with a root-cause trail — which styles, which sizes, which markdown, which cost — variance becomes the prompt for a specific action.
Worked apparel example
Planned sales for May: $850K. Actuals: $780K.
Variance % = ($780K − $850K) ÷ $850K = −8.2%
Material miss. Re-forecast required. The variance itself is one number; the actionable insight lives in decomposing it: which department, class, and style drove the miss? Was it a mix problem or a velocity problem? Is it a one-month blip or a trend?
Variance of -8.2% is severe. Flag to leadership and re-plan the buy.
Failure modes we see
Variance reported, not decomposed. Monthly scorecards show −8% against plan. Nobody traces it. By Q3, the business has missed plan every month and leadership concludes "the plan was wrong" rather than "execution drifted in specific ways."
How RetailNorthstar handles variance
Variance runs at every grain — department, class, style, color, size, door, week. A miss at the headline rolls up from the specific cells that caused it — and each cell links to the decision trail behind it.
Related formulas
- Comparable Store Sales — variance against same-period prior
- Category Mix % — variance against planned mix
- Open-to-Buy — OTB adjustments are variance-driven
See variance decomposed live from headline to style — so misses drive specific re-plans.
Book a Demo →