Flexible vs. Static Budget
Adjusting for activity levels.
Why This Matters
Every budget is prepared at a specific expected level of activity โ planned unit sales, planned production volume, planned hours. But actual results almost never match the plan exactly. If sales come in higher than expected, costs should be higher too. If sales fall short, some costs should be lower.
A static budget keeps the original planned numbers fixed regardless of what actually happens. Comparing actual results to a static budget when volume differs is like comparing a runner's time on a hilly course to a pace target set for a flat course.
A flexible budget adjusts the budget to reflect what costs should have been at the actual volume achieved. This separates the volume effect from the efficiency effect.
Static budgets answer: "How did we perform compared to the plan?" Flexible budgets answer: "At the volume we actually achieved, did we manage costs well?" The second question drives management action.
Static Budget: A Single Fixed Benchmark
A static (fixed) budget is the original master budget prepared at the planned activity level. It does not change when actual volume differs.
ABC COFFEE โ 2027 STATIC BUDGET (92,750 planned cups)
Revenue: 92,750 ร $2.00 = $185,500
Variable costs: 92,750 ร $1.22 = ($113,155)
Contribution Margin: $72,345
Fixed costs: ($34,300)
Operating Income: $38,045
At year end, actual cups sold = 85,000 (10% below plan). Static budget comparison:
| Static (92,750) | Actual (85,000) | Variance | |
|---|---|---|---|
| Revenue | $185,500 | $170,000 | ($15,500) U |
| Variable costs | ($113,155) | ($103,700) | $9,455 F |
| Operating Income | $38,045 | $31,800 | ($6,245) U |
Is the $9,455 favorable variable cost variance meaningful?
Variable costs were $9,455 less โ but we sold 7,750 fewer cups. Of course costs were lower. This static comparison cannot tell you whether variable cost per unit was controlled well.
Flexible Budget: Adjusting for Actual Volume
FLEXIBLE BUDGET FORMULA
Flexible Budget = (Budgeted VC/Unit ร Actual Units) + Budgeted Fixed Costs
ABC at actual 85,000 cups:
Revenue: 85,000 ร $2.00 = $170,000
Variable costs: 85,000 ร $1.22 = ($103,700)
Contribution Margin: $66,300
Fixed costs: ($34,300)
Operating Income: $32,000
Flexible Budget Variance Tool
Pre-filled with ABC Coffee 2027 data. Enter planned volume, actual volume, price, variable cost per unit, and fixed costs to see static vs. flexible vs. actual โ with sales volume and flexible budget variances separated.
CM/Unit
$0.78
| Line Item | Static (92,750) | Flexible (85,000) | Actual (85,000) |
|---|---|---|---|
| Revenue | $185,500 | $170,000 | $170,000 |
| Variable Costs | ($113,155) | ($103,700) | ($103,700) |
| Contribution Margin | $72,345 | $66,300 | $66,300 |
| Fixed Costs | ($34,300) | ($34,300) | ($34,500) |
| Operating Income | $38,045 | $32,000 | $31,800 |
Sales Volume Variance
($6,045) U
Flexible OI โ Static OI
Volume issue โ not cost control
Flexible Budget Variance
($200) U
Actual OI โ Flexible OI
True cost control signal
Total Variance (Static โ Actual)
($6,245) U
Actual OI โ Static OI
Variance Decomposition
Volume miss: 7,750 units ร $0.78 CM โ ($6,045) U
At actual volume, cost performance: ($200) U
The Full Variance Analysis: Three Columns
Three-Column Variance Bridge
Static Budget
92,750 cups
$38,045
Sales Volume Var
($6,045) U
Flexible Budget
85,000 cups
$32,000
Flex Budget Var
($200) U
Actual
85,000 cups
$31,800
| Static (92,750) | Flexible (85,000) | Actual (85,000) | |
|---|---|---|---|
| Revenue | $185,500 | $170,000 | $170,000 |
| Variable costs | ($113,155) | ($103,700) | ($103,700) |
| Contribution | $72,345 | $66,300 | $66,300 |
| Fixed costs | ($34,300) | ($34,300) | ($34,500) |
| Operating Income | $38,045 | $32,000 | $31,800 |
Breaking Down the Variances
Sales Volume Variance
= Flexible Budget OI โ Static Budget OI
= $32,000 โ $38,045
= ($6,045) Unfavorable
Cause: 7,750 fewer cups than planned. Each cup contributes ~$0.78. This is NOT a cost control issue โ it is a volume issue for the sales team to investigate.
Flexible Budget Variance
= Actual OI โ Flexible Budget OI
= $31,800 โ $32,000
= ($200) Unfavorable
Cause: Fixed costs $200 over budget. Variable costs exactly on target. This IS a cost control signal โ but immaterial here. Management ran efficiently; the shortfall was entirely volume.
Flexible Budget Variance: Deeper Cuts
The flexible budget variance on variable costs can be further split into price and efficiency components:
FLEXIBLE BUDGET VARIANCE COMPONENTS
Price Variance: (Actual price โ Standard price) ร Actual quantity purchased
Efficiency Variance: (Actual qty used โ Standard qty) ร Standard price
ABC DM example: Standard $0.79/cup. Actual $0.83/cup ร 85,000 = $70,550. Flexible budget DM: $67,150. Variance: $3,400 U โ price vs. efficiency each needs a different managerial response.
Flexible Budgets for Service Businesses
Law Firm Example
Activity base: billable hours (instead of units)
Budget at 2,000 hrs: Rev $400K โ Var $120K โ FC $180K = OI $100K
Actual: 1,700 billable hours
Flexible at 1,700 hrs: Rev $340K โ Var $102K โ FC $180K = OI $58K
Sales volume variance: ($42,000) U โ 300 hours fewer billed
Flexible budget variance compares actual OI to $58K for cost control
Budgeting Section Complete
You've now covered all five Budgeting modules. Together they build a complete understanding of business planning: from why budgets exist, to how they're connected, to how you use them to evaluate what actually happened.
| Module | Core Concept | # |
|---|---|---|
| Budgeting Basics | Four purposes; process; top-down vs. bottom-up; slack | #88 |
| Master Budget | Integrated system: operating + financial budgets | #89 |
| Sales Budget | Revenue forecast; seasonality; collection timing | #90 |
| Cash Budget | Cash collections; disbursements; financing needs | #91 |
| Flexible vs. Static Budget โ You are here | Volume variance vs. efficiency variance separation | #92 |
Common Mistakes
Mistake 1: Using Static Variances for Cost Control Evaluation
โ Wrong
"Variable cost variance is $9,455 favorable โ operations did a great job."
โ Right
Always use the flexible budget for cost control. Volume effects belong in Sales Volume Variance.
Mistake 2: Not Separating Fixed and Variable Costs
โ Wrong
"Total costs were 70% of revenue โ budget 70% at any volume."
โ Right
Separate fixed and variable. Flex only the variable portion; keep fixed costs constant across volumes.
Key Takeaway
A static budget is fixed at the planned activity level โ useful for goal-setting but misleading for cost control evaluation when actual volume differs from plan. A flexible budget recalculates what costs should have been at the actual volume achieved, enabling a clean separation between the Sales Volume Variance (how much volume missed the plan) and the Flexible Budget Variance (whether costs were managed well at the actual volume). The flexible budget variance is the true measure of cost control performance; the sales volume variance is a measure of sales effectiveness. Every meaningful variance analysis requires both.
Test Your Understanding
Flexible budget mechanics, variance decomposition, ABC static trap, and fixed vs. variable separation โ check your answers below.
Question 1: Budget = 10,000 units. Actual = 8,000 units. VC = $5/unit. FC = $20,000. Price = $10/unit. Actual VC = $5/unit. What is flexible budget operating income?
Question 2: Static Budget OI = $50,000. Flexible Budget OI = $44,000. Actual OI = $46,000. What is the flexible budget variance?
Question 3: ABC Coffee: static budget 92,750 cups, actual 85,000 cups. Variable cost variance on static comparison is $9,455 Favorable. Is this meaningful for cost control?
Question 4: True or False: A flexible budget adjusts fixed costs proportionally when volume changes.
Ready to Practice?
Build three-column variance reports, separate volume from efficiency effects, and diagnose cost control performance in the Practice Lab.
Try the Practice LabWhat's Next?
Next: Standard Costing and Variance Analysis โ set precise cost benchmarks per unit, then decompose differences into price and efficiency components managers can act on.
Standard Costing
Predetermined cost benchmarks for DM, DL, and OH
Cash Budget
Planning cash flows period by period