Monthly Budget vs. Actual Variance Analysis: An FP&A Case Study
The Cheesecake Factory (CAKE) | Q3 FY2025 | FP&A Skill Series
Why Variance Analysis Is Core to FP&A
Every FP&A analyst spends a significant portion of each month explaining why actual results differed from the plan. Variance analysis is the structured process of quantifying those differences, identifying their drivers, and communicating actionable findings to management. This article walks through a full Q3 budget vs. actual analysis for CAKE as if presenting to a CFO.
The Structure of Variance Analysis
Variance analysis follows a consistent structure regardless of the company. For every metric, you must answer four questions: What was the plan? What actually happened? How large is the gap in dollars and percent? What caused it?
For restaurant operators, variances typically cascade: if traffic misses, revenue misses. If revenue misses but food costs are fixed in procurement, food cost percentage increases. That cascading effect is why understanding the primary driver — was it volume, pricing, or mix? — is essential before you build the explanation.
Volume vs. Price vs. Mix — The Three Variance Drivers
Volume: More or fewer covers (guests) than planned. Price: Average menu price realization. Mix: Which menu items guests actually ordered vs. what was assumed. Understanding which lever drove the variance determines the management response.
Q3 FY2025 Budget vs. Actual — Full P&L Variance Table
The table below presents the full quarter analysis. Red cells indicate unfavorable variances (actual worse than budget). Green cells indicate favorable variances.
| Metric | Budget | Actual | Variance | Var % | Primary Driver |
|---|---|---|---|---|---|
| REVENUE | |||||
| Total Revenue ($M) | $916.5 | $902.3 | ($14.2) | (1.5%) | Traffic softness in casual dining; -1.8% comp traffic |
| Same-Store Sales Growth | 3.2% | 1.4% | (180 bps) | — | Menu price offset insufficient to cover traffic decline |
| Average Check ($) | $28.45 | $28.90 | +$0.45 | +1.6% | Favorable premium menu mix shift; guests ordering higher-margin items |
| FOOD & BEVERAGE COST | |||||
| Food & Bev Cost ($M) | $244.9 | $251.1 | ($6.2) | (2.5%) | Commodity inflation: poultry +4.2%, dairy +2.8% vs. plan |
| Food & Bev Cost % | 26.7% | 27.8% | (110 bps) | — | Inflation above hedging coverage; procurement exposure in spot market |
| LABOR COST | |||||
| Labor Cost ($M) | $321.1 | $326.8 | ($5.7) | (1.8%) | CA minimum wage increase effective July 2025; OT premium |
| Labor Cost % | 35.0% | 36.2% | (120 bps) | — | Higher-than-budgeted OT due to understaffing + wage floor increase |
| OPERATING PERFORMANCE | |||||
| Other Restaurant Costs ($M) | $109.8 | $112.4 | ($2.6) | (2.4%) | Utility costs +6.1% YoY; supply chain freight costs elevated |
| SG&A ($M) | $52.2 | $53.7 | ($1.5) | (2.9%) | Legal accruals and Q4 marketing spend pulled forward into Q3 |
| EBITDA ($M) | $188.5 | $158.3 | ($30.2) | (16.0%) | Cumulative: revenue miss + commodity + labor inflation |
| EBITDA Margin % | 20.6% | 17.5% | (310 bps) | — | Largest single-quarter margin miss in four years |
| Net Income ($M) | $112.3 | $88.7 | ($23.6) | (21.0%) | Operating cost overruns; no tax benefit to offset |
Variance Deep Dive — Understanding Each Driver
Revenue Variance — ($14.2M) / (1.5%)
Budget: $916.5M | Actual: $902.3M | Gap: ($14.2M)
The revenue miss is entirely volume-driven. Average check actually beat budget by $0.45, meaning CAKE's pricing strategy is working — guests who came spent more. The problem is that fewer guests came. Comparable restaurant traffic declined 1.8% vs. the budgeted +0.5% improvement, creating a volume headwind that price could not fully offset.
The root cause: casual dining consumer traffic pressure persisted longer into Q3 than management anticipated when setting the annual plan. This is an industry-wide dynamic — Darden Restaurants, Brinker International, and BJ's Restaurants all reported similar traffic patterns. CAKE's market share position held steady.
Food & Beverage Cost Variance — ($6.2M) / 110 bps
Budget: 26.7% | Actual: 27.8% | Gap: 110 bps unfavorable
Commodity markets moved against CAKE's procurement hedges. Poultry spot prices increased 4.2% above the plan assumption, and dairy costs increased 2.8%. CAKE had hedged approximately 60% of poultry requirements through Q3, but the unhedged 40% absorbed the full spot price increase. Management's response: extend forward contracts on poultry through Q2 FY2026.
Labor Cost Variance — ($5.7M) / 120 bps
Budget: 35.0% | Actual: 36.2% | Gap: 120 bps unfavorable
Two concurrent events drove the labor miss. First, California's minimum wage floor increased effective July 1, 2025. CAKE budgeted for this increase at the corporate level, but the implementation of new scheduling protocols in California restaurants was delayed, resulting in elevated overtime as managers over-scheduled to ensure coverage. Second, a broader staffing shortage in the FOH resulted in premium hourly rates to maintain service standards during peak weekend periods.
EBITDA Variance — ($30.2M) / (16.0%)
Priority escalation — requires CFO and operating leadership review
Budget: $188.5M | Actual: $158.3M | Gap: ($30.2M) — Largest quarterly miss in four years
The EBITDA variance is not the result of a single large item — it is the accumulation of three simultaneous headwinds: revenue shortfall, commodity inflation, and labor cost increases. When three cost lines all move unfavorably in the same quarter, the operating leverage that makes restaurant businesses attractive reverses: fixed costs are spread over a smaller revenue base, amplifying the margin impact.
Executive Summary — CFO Presentation Notes
1. Revenue missed budget by $14.2M. Traffic softness in casual dining persists; pricing support is working but cannot fully compensate for volume decline.
2. Food & Beverage cost exceeded budget by 110 bps. Unhedged commodity exposure in poultry and dairy is the primary driver. Forward contracts must be extended.
3. Labor cost variance of 120 bps reflects CA wage floor increases and overtime premiums from scheduling execution gaps. Technology rollout must accelerate.
4. EBITDA of $158.3M missed the $188.5M plan by $30.2M — the largest quarterly shortfall in four years. This is a management priority requiring a formal Q4 recovery plan.
5. Q4 recovery levers: expand commodity hedging, accelerate scheduling optimization, evaluate targeted menu price adjustments on high-traffic items, and freeze discretionary SG&A.
What Good Variance Analysis Sounds Like in Practice
When presenting to a CFO, the goal is short, direct, and action-oriented. "Revenue missed $14M due to traffic. Food cost missed 110 bps due to spot commodity exposure. Labor missed 120 bps due to wage increases and overtime. EBITDA missed $30M. Q4 recovery plan is attached." That's the communication. The detail lives in the supporting schedules.
Disclaimer: This case study is hypothetical and constructed for educational purposes only. Numbers are illustrative, not actual CAKE reported results. Source data: CAKE 10-K FY2024. Not investment advice.