Flexible Budgets: How They Work and When to Use Them
By Newtown Analytics · · 8 min read
For finance, fp&a & accounting managers
A flexible budget restates the budget at the level of activity that actually occurred, so that actual costs can be compared with what they should have been for that volume. A static budget is built for one volume, say 4,000 units; if the business sells 3,800, comparing actual costs with the static budget gives a misleading answer, because lower volume would have reduced many costs anyway. The flexible budget separates the effect of volume from the effect of how well costs were controlled. This guide shows how to build one, walks through a complete example and explains where it is used and where it falls short. It supports budget variance analysis and the formulas in variance analysis formulas, and is part of budgeting and forecasting.
Static vs. flexible budgets
| Static budget | Flexible budget | |
|---|---|---|
| Based on | One planned activity level | The actual activity level |
| Changes with volume | No | Yes, using cost behavior |
| Best for | Targets and planning | Evaluating cost control and performance |
| Variance it supports | Total variance | Activity (volume) variance and spending variance separately |
| Complexity | Low | Moderate: needs cost behavior data |
Cost behavior: the basis of flexing
A flexible budget needs to know how each cost behaves.
| Cost type | Behavior | Flexible budget formula |
|---|---|---|
| Variable | Changes in proportion to activity | Rate × actual activity |
| Fixed | Stays the same within the relevant range | Fixed amount |
| Semi-variable (mixed) | Fixed part plus variable part | Fixed + rate × actual activity |
| Step-fixed | Jumps at capacity thresholds | Number of steps needed × cost per step |
Activity can be units produced, units sold, labor hours, machine hours, orders or any driver that explains the cost. See driver-based budgeting.
The relevant range matters. A fixed cost is fixed only within a range of activity. If volume doubles, you may need another supervisor, a new machine or another shift.
A full worked example
A hypothetical company budgets 4,000 units for the month. Price is $50 per unit. Variable costs are $30 per unit. Fixed costs are $12,000. Actual results: 3,800 units sold at an average price of $49.50, with total costs of $129,500.
Step 1: Static budget
| Line | Static budget (4,000 units) |
|---|---|
| Revenue | 4,000 × $50 = $200,000 |
| Variable costs | 4,000 × $30 = $120,000 |
| Fixed costs | $12,000 |
| Total costs | $132,000 |
| Profit | $68,000 |
Step 2: Flexible budget at actual volume (3,800 units)
| Line | Flexible budget (3,800 units) |
|---|---|
| Revenue | 3,800 × $50 = $190,000 |
| Variable costs | 3,800 × $30 = $114,000 |
| Fixed costs | $12,000 |
| Total costs | $126,000 |
| Profit | $64,000 |
Step 3: Actual
| Line | Actual |
|---|---|
| Revenue | 3,800 × $49.50 = $188,100 |
| Total costs | $129,500 |
| Profit | $58,600 |
Step 4: Variances
| Line | Static budget | Flexible budget | Actual | Activity variance (Static - Flex) | Flexible budget variance (Flex - Actual) |
|---|---|---|---|---|---|
| Revenue | $200,000 | $190,000 | $188,100 | -$10,000 (U) | -$1,900 (U) |
| Total costs | $132,000 | $126,000 | $129,500 | +$6,000 (F) | -$3,500 (U) |
| Profit | $68,000 | $64,000 | $58,600 | -$4,000 (U) | -$5,400 (U) |
Total profit variance: $58,600 - $68,000 = -$9,400. Split: activity effect -$4,000 and performance effect -$5,400. Check: -4,000 - 5,400 = -9,400.
What the static comparison would have said
Comparing actual costs of $129,500 with the static cost budget of $132,000 shows a $2,500 favorable cost variance. A manager could claim a saving. The flexible budget shows that costs, for 3,800 units, should have been $126,000. They were $3,500 higher. The "saving" was just lower volume, and in fact cost control was weak.
Reading the performance variances
- Revenue -$1,900: price, ($49.50 - $50.00) × 3,800.
- Costs -$3,500: spending and efficiency. Break it down using price and usage variances for materials, labor and overhead. See variance analysis formulas.
The activity variance of -$4,000 is the profit effect of selling 200 fewer units: 200 × ($50 - $30) = $4,000. It is not a performance issue for the production team; it belongs to whoever owns demand.
When to use a flexible budget
| Situation | Why |
|---|---|
| Production or service volume varies from plan | To judge cost control fairly |
| Department costs depend on activity | Support functions like customer service or warehousing |
| Performance evaluation | To separate managers' influence on cost from volume swings |
| Pricing and profit analysis | To understand the margin effect of volume changes |
| Mid-year reforecasts | To update expectations at the new volume |
It is less useful where costs are almost all fixed or discretionary, such as research or executive salaries.
Building a flexible budget in a spreadsheet
- List costs and classify each as variable, fixed, semi-variable or step-fixed.
- Estimate the rates from history or contracts. Use regression on past data for semi-variable costs. See regression analysis for financial forecasting in Excel.
- Set the cost drivers and take actual driver values from the operational system.
- Calculate the flexible budget for the actual drivers.
- Compare with actual costs and calculate variances.
- Test the model by changing activity to confirm costs respond sensibly.
A step-fixed example
A warehouse needs one supervisor for every 15,000 order lines a month, at $5,200 a month each. At 40,000 order lines it needs 3 supervisors (40,000 / 15,000 = 2.67, rounded up): $15,600. At 46,000 lines it needs 4 (3.07 rounded up): $20,800. A flexible budget that treats supervision as a smooth variable cost of $0.346 per line would understate the jump at 45,001 lines. Step costs need their own rule.
A second example: a service department with step costs
A customer support team budgets 4,000 tickets a month. Each agent can handle 1,000 tickets and costs $5,200 a month. Tools and telephony cost $3.50 per ticket. Management and software for the team cost $6,000 a month regardless of volume.
| Line | Static budget (4,000 tickets) | Flexible budget (4,600 tickets) |
|---|---|---|
| Agents | 4 × $5,200 = $20,800 | 5 × $5,200 = $26,000 (4.6 rounded up) |
| Tools and telephony | 4,000 × $3.50 = $14,000 | 4,600 × $3.50 = $16,100 |
| Management and software | $6,000 | $6,000 |
| Total | $40,800 | $48,100 |
Actual tickets were 4,600 and actual spending was $49,300.
- Against the static budget the team looks $8,500 over ($49,300 - $40,800), or 20.8 percent.
- Against the flexible budget the overspend is only $1,200 (2.5 percent).
- The activity variance is $48,100 - $40,800 = $7,300, caused by 600 extra tickets and the fifth agent needed to handle them.
The manager of the support team had little control over the extra tickets. The $1,200 is the part to discuss with the manager. The $7,300 belongs to the question of why tickets rose, which may point to a product issue or a marketing campaign. The flexible budget turns a blame discussion into a diagnosis. Notice also the step cost: the 4,001st ticket triggers a whole extra agent in the budget, though in practice the team might cover the first 600 extra tickets with overtime.
Flexible budgets and planning
Flexible budgets also help in planning. Instead of a single budget, finance can publish a table of costs at several activity levels.
| Units | Variable costs | Fixed costs | Total | Cost per unit |
|---|---|---|---|---|
| 3,000 | $90,000 | $12,000 | $102,000 | $34.00 |
| 3,500 | $105,000 | $12,000 | $117,000 | $33.43 |
| 4,000 | $120,000 | $12,000 | $132,000 | $33.00 |
| 4,500 | $135,000 | $12,000 | $147,000 | $32.67 |
Managers can see how unit costs fall with volume as fixed costs are spread. This is the same logic as break-even analysis: fixed costs of $12,000 divided by a contribution of $20 per unit gives a break-even volume of 600 units.
Limits
| Limit | Response |
|---|---|
| Needs accurate cost behavior | Review rates regularly; use regression |
| Relevant range | Note the range and update outside it |
| Driver data required | Collect activity data in the operational system |
| Can hide strategic issues | Combine with static budget and forecast to see the full picture |
| Complexity for many lines | Flex the major cost lines only |
| Mix effects | Use PVM for multi-product mixes. See price-volume-mix analysis |
Flexible budgets and unit economics
The rates in a flexible budget are the variable costs per unit, which are also the building blocks of unit economics. Knowing contribution per unit lets you predict profit at any volume. See unit economics.
Common mistakes
- Treating all costs as variable.
- Using the wrong driver.
- Ignoring step costs.
- Using flexible budgets outside the relevant range.
- Forgetting that the activity variance is not a cost-control issue.
- Not documenting rates and drivers.
Related guides
For a table-based report that includes flexed comparisons, see budget vs. actual report: template and commentary tips. For forecasting with activity drivers, see driver-based forecasting.
FAQs
What is a flexible budget?
A budget that adjusts to the actual level of activity, using known cost behavior, so actual costs can be compared with what they should have been.
What is the difference between a flexible budget and a static budget?
A static budget is set for one activity level. A flexible budget changes with activity.
How do you calculate a flexible budget?
Multiply the budgeted variable cost per unit by actual activity, add fixed costs, and treat semi-variable and step costs with their own formulas.
What is an activity variance?
The difference between the static budget and the flexible budget; it shows the effect of volume differing from plan.
Why are flexible budgets useful?
They separate the effect of volume from the control of costs, giving a fairer measure of performance.
Keep reading
This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.