Flexible Budgets — Prepare a flexible budget based on activity level - Managerial Accounting

SECTION 1

Historical Context & Motivation

For most of the industrial age, companies relied on static budgets—single-point estimates of revenues and costs prepared before the period began. A static budget assumes one fixed level of output and does not adjust when actual activity deviates from the plan. While this approach was adequate for stable manufacturing environments with predictable demand, it quickly broke down as markets became more volatile and product lines more complex. Managers discovered that comparing actual results to a budget built on 10,000 units was misleading when the factory actually produced 12,000 units. The resulting variances blended volume effects with spending efficiency, making it nearly impossible to isolate true performance problems.

1920s • Rise of Standard Costing

Frederick Taylor's scientific management movement drives adoption of standard costs in manufacturing. Budgets are built around one expected production volume, laying the groundwork for variance analysis.

1950s • Flexible Budgeting Concepts Emerge

Cost accounting textbooks begin distinguishing between fixed and variable costs within budgets, enabling managers to restate budgets at different activity levels for more accurate performance evaluation.

1980s • Activity-Based Costing Synergies

Activity-based costing (ABC) refines cost driver analysis, making flexible budgets more precise by linking overhead pools to specific activities rather than a single volume measure.

2000s–Present • ERP Integration & Rolling Forecasts

Enterprise resource planning systems automate flexible budget calculations in real time, and many firms adopt rolling forecasts that continuously flex budgets as conditions change.

The central question a flexible budget answers is deceptively simple: What should costs and revenues have been, given the volume we actually achieved? By stripping out the volume effect, managers can focus on whether resources were used efficiently—a distinction that static budgets alone cannot provide.

SECTION 2

Core Principles & Definitions

A flexible budget is a budget that adjusts or "flexes" revenue and cost estimates to reflect the actual level of activity (such as units produced, machine hours, or sales volume) achieved during a period. Unlike a static budget, which is locked at one planned volume, the flexible budget recalculates expected amounts using the budgeted per-unit rates and the actual quantity of the cost driver. Understanding flexible budgets requires a firm grasp of several foundational ideas.

Cost Behavior Classification

Every cost must be classified as variable, fixed, or mixed. Variable costs change proportionally with activity; fixed costs remain constant over the relevant range; mixed costs contain both elements.

Activity Level (Cost Driver)

The measure of output or volume used to flex the budget—commonly units produced, units sold, direct labor hours, or machine hours. Choosing the right driver is critical for meaningful analysis.

Relevant Range

The span of activity over which fixed-cost and variable-rate assumptions remain valid. Outside this range, step-fixed costs may shift or variable rates may change due to economies or diseconomies of scale.

Flexible Budget Variance

The difference between actual results and the flexible budget amount at the same activity level. This variance isolates spending efficiency by removing volume effects present in the static budget variance.

Sales-Volume Variance

The difference between the flexible budget and the static (master) budget, caused solely by the difference between actual and planned activity levels. It captures the effect of selling or producing more or fewer units than expected.

✦

KEY TAKEAWAY

Think of a flexible budget like a GPS that recalculates your route based on where you actually are, rather than where you planned to be. If your company planned to produce 8,000 units but actually produced 10,000, a static budget still shows costs for 8,000 units—like a GPS insisting you're on the highway when you've already taken the exit. The flexible budget recalculates costs for 10,000 units so you can assess whether the journey from that point was efficient.

SECTION 3

Visual Explanation — Static vs. Flexible Budget

The diagram above shows how fixed costs remain constant (dashed amber line) while the total flexible budget (solid cyan line) increases linearly with activity. The static budget is anchored at 8,000 units (violet dot), while the flex budget recalculates to 10,000 actual units (green dot). The difference between the flex budget and actual cost at 10,000 units is the flexible budget variance.

This visual makes the core insight of flexible budgeting clear. When a company produces 10,000 units instead of the budgeted 8,000, comparing the actual cost of $63,000 to the static budget of $54,000 yields a $9,000 unfavorable static budget variance. However, that $9,000 figure conflates two separate effects. The sales-volume variance ($6,000) captures the natural cost increase from producing 2,000 extra units, while the flexible budget variance ($3,000 unfavorable) isolates genuine spending inefficiency. Without a flexible budget, managers might over-react to the $9,000 gap and pursue cost-cutting measures when in reality most of the increase was simply the natural consequence of higher production.

SECTION 4

Mathematical Framework

Building a flexible budget requires a formula-driven approach that separates variable costs from fixed costs. All flexible budget amounts for costs follow a single linear cost model, while revenue is simply the budgeted selling price multiplied by the actual quantity sold.

FLEXIBLE BUDGET — TOTAL COST

Flexible Budget Total Cost = (Variable Cost per Unit × Actual Activity Level) + Total Fixed Costs

Variable cost per unit is derived from the master budget. Actual activity level is the realized volume (units produced, hours worked, etc.). Fixed costs remain at the originally budgeted amount within the relevant range.

FLEXIBLE BUDGET — REVENUE

Flexible Budget Revenue = Budgeted Selling Price per Unit × Actual Units Sold

The budgeted selling price (not the actual price) is used so that price variances can be isolated separately from volume effects.

FLEXIBLE BUDGET VARIANCE

Flexible Budget Variance = Actual Results − Flexible Budget Amount

For costs: a positive variance means actual costs exceeded the flex budget (unfavorable). For revenue: a positive variance means actual revenue exceeded the flex budget (favorable). The sign convention may be reversed depending on the textbook—always label U (unfavorable) or F (favorable).

SALES-VOLUME VARIANCE

Sales-Volume Variance = Flexible Budget Amount − Static Budget Amount

This variance captures only the effect of the volume difference. For revenue, a positive result is favorable (sold more than planned). For costs, a positive result means higher costs due to higher volume (unfavorable for costs, but expected). This decomposition is: Static Budget Variance = Flexible Budget Variance + Sales-Volume Variance.

SECTION 5

Variance Decomposition — Static to Flexible

The power of a flexible budget lies in its ability to decompose the total static budget variance into two actionable components. The first component is the sales-volume variance, which measures how much of the total variance is attributable to producing or selling a different number of units than planned. The second component is the flexible budget variance, which isolates spending efficiency by comparing actual results to what the budget would have been at the actual volume. This decomposition is the analytical backbone of performance reporting in managerial accounting.

This framework shows how the total static budget variance breaks into two parts. The flexible budget variance compares actual results to the flex budget (both at actual volume), isolating spending efficiency. The sales-volume variance compares the flex budget to the static budget, capturing only the volume difference.

Component	Formula	What It Reveals
Static Budget Variance	Actual − Static Budget	Total deviation from the master plan (volume + spending combined)
Flexible Budget Variance	Actual − Flexible Budget	Spending efficiency: Did we pay more or use more inputs per unit than planned?
Sales-Volume Variance	Flexible Budget − Static Budget	Volume effect: How much variance is explained purely by output differing from the plan?

Summary of the three variance measures in flexible budget analysis

SECTION 6

Worked Example — Preparing a Flexible Budget

Consider SkyBrew Coffee Co., which planned to produce and sell 8,000 bags of premium coffee in March. The master (static) budget includes the following per-unit and fixed cost assumptions: budgeted selling price = $20 per bag; budgeted variable cost = $3.00 per bag for direct materials, $2.00 per bag for direct labor, $1.50 per bag for variable overhead; total budgeted fixed costs = $30,000 for the month. Actual production and sales for March turned out to be 10,000 bags. We will prepare a flexible budget at 10,000 units and compute the variances.

SkyBrew Coffee Co. — Flexible Budget for March

1
Step 1 — Identify Budgeted Rates and Fixed Costs

From the master budget: Selling price = $20/bag. Variable costs per bag: Direct materials $3.00, Direct labor $2.00, Variable overhead $1.50. Total variable cost per bag = $3.00 + $2.00 + $1.50 = $6.50. Total fixed costs = $30,000. These rates are the building blocks of our flexible budget.

Variable cost per unit = $6.50; Fixed costs = $30,000
2
Step 2 — Determine the Actual Activity Level

The actual number of bags produced and sold in March was 10,000. This is the activity level to which we will flex the budget. Note that the static budget was prepared for 8,000 bags.

Actual activity = 10,000 bags
3
Step 3 — Compute Flexible Budget Revenue

Flexible budget revenue = Budgeted selling price × Actual units sold = $20 × 10,000 = $200,000. Note we use the budgeted price, not the actual price, so we can later isolate a selling-price variance.

Flex budget revenue = $200,000
4
Step 4 — Compute Flexible Budget Variable Costs

Direct materials: $3.00 × 10,000 = $30,000. Direct labor: $2.00 × 10,000 = $20,000. Variable overhead: $1.50 × 10,000 = $15,000. Total variable costs = $30,000 + $20,000 + $15,000 = $65,000.

Flex budget variable costs = $65,000
5
Step 5 — Compute Flexible Budget Total Costs and Operating Income

Total flexible budget costs = Variable costs + Fixed costs = $65,000 + $30,000 = $95,000. Flexible budget operating income = Revenue − Total costs = $200,000 − $95,000 = $105,000. For comparison, the static budget operating income was ($20 × 8,000) − ($6.50 × 8,000 + $30,000) = $160,000 − $82,000 = $78,000.

Flex budget operating income = $105,000 | Static budget operating income = $78,000
6
Step 6 — Compute Variances (Assume Actual Data)

Assume actual results for March: Revenue = $195,000, Total variable costs = $68,000, Fixed costs = $31,500, Operating income = $95,500. Flexible budget variance for operating income = $95,500 − $105,000 = −$9,500 (unfavorable). Sales-volume variance for operating income = $105,000 − $78,000 = $27,000 (favorable). Total static budget variance = $95,500 − $78,000 = $17,500 (favorable). Verification: −$9,500 + $27,000 = $17,500 ✓.

Flex variance = $9,500 U | Volume variance = $27,000 F | Static variance = $17,500 F

Line Item	Actual Results	Flex Budget Variance	Flexible Budget (10,000 units)	Volume Variance	Static Budget (8,000 units)
Revenue	$195,000	$5,000 U	$200,000	$40,000 F	$160,000
Variable Costs	$68,000	$3,000 U	$65,000	$13,000 U	$52,000
Fixed Costs	$31,500	$1,500 U	$30,000	$0	$30,000
Operating Income	$95,500	$9,500 U	$105,000	$27,000 F	$78,000

Comprehensive flexible budget performance report for SkyBrew Coffee Co., March

SECTION 7

Strengths, Limitations & Comparisons

Flexible budgets are a significant improvement over static budgets for performance evaluation, but they are not without their own limitations. Understanding both the strengths and the boundaries of the flexible budgeting approach allows managers to deploy it effectively and recognize when additional analysis—such as activity-based budgeting or rolling forecasts—may be warranted.

Criterion	Strengths	Limitations
Performance Evaluation	Isolates spending efficiency from volume effects, providing a fairer evaluation of managerial performance.	Assumes cost behavior (variable vs. fixed) is perfectly classified; misclassification distorts variances.
Cost Behavior	Works well when costs are truly linear within the relevant range and the cost driver is well-chosen.	Relies on a single cost driver; multi-driver environments may need activity-based flexible budgets.
Decision-Making	Helps managers understand 'what should have been' and directs attention to controllable cost overruns.	Does not explain why variances occurred; further investigation (price/efficiency splits) is still needed.
Flexibility	Can be prepared at any activity level, enabling what-if analysis and scenario planning.	Only valid within the relevant range. Step-fixed costs and non-linear variable costs reduce accuracy outside this range.
Preparation Effort	Simple formula-based calculation once cost behavior is established; easily automated in spreadsheets or ERP.	Requires upfront investment in cost estimation (high-low method, regression) to determine variable rates accurately.

Strengths and limitations of flexible budgets

✦

KEY TAKEAWAY

A flexible budget is like adjusting a recipe when you decide to serve 12 guests instead of 8. You scale the ingredient quantities (variable costs) but keep the fixed elements—oven temperature, baking time (fixed costs)—the same. If the meal still costs more than expected after this adjustment, the overspend reflects genuine inefficiency (you wasted ingredients or paid too much), not simply the fact that you fed more people. However, the recipe analogy also reveals the tool's limitation: it assumes ingredient costs scale linearly, which may not hold if bulk discounts or spoilage kick in at different volumes.

SECTION 8

Connection to Advanced Variance Analysis

The flexible budget is a gateway to more granular variance analysis. Once you have isolated the flexible budget variance, you can further decompose it into price (rate) variances and efficiency (quantity) variances for direct materials, direct labor, and variable overhead. This layered approach—often called the variance analysis hierarchy—moves from the broadest measure (static budget variance) down to individual input-level causes. For example, an unfavorable flexible budget variance for direct materials might result from paying a higher price per kilogram (price variance) or using more kilograms per unit than standard (efficiency variance), or both. Understanding how the flexible budget fits into this hierarchy is essential for managerial decision-making and performance reporting.

Aspect	Flexible Budget Analysis	Advanced Variance Analysis
Level of Detail	Compares total costs and revenues at actual vs. budgeted amounts for the actual activity level.	Decomposes each flexible budget variance into price and efficiency components for each input.
Actionability	Identifies which cost categories are over or under budget but does not pinpoint the root cause.	Directs managers to specific causes: Was the input price higher? Was more input used per unit?
Data Required	Actual and budgeted totals for each line item, plus the actual activity level.	Actual and standard prices and quantities for each individual input (material, labor, overhead).
Typical Course Sequence	Covered first as the foundation of budget-to-actual analysis.	Covered next, building directly on the flexible budget framework to drill deeper.

Flexible budget analysis versus advanced (price/efficiency) variance analysis

In more advanced settings, firms also adopt activity-based flexible budgets that use multiple cost drivers rather than a single volume measure. For instance, quality inspection costs might flex with the number of batches rather than the number of units, while shipping costs flex with the number of orders. These multi-driver flexible budgets align with activity-based costing (ABC) and provide even more accurate performance benchmarks in complex manufacturing and service environments. As you continue in managerial accounting, the flexible budget you learn here becomes the conceptual foundation on which all of these more sophisticated tools are built.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

Explain why comparing actual costs to a static budget can be misleading when actual production volume differs significantly from the planned volume. How does a flexible budget address this problem?

Show answer

A static budget is prepared for one fixed activity level. When actual volume differs, the resulting variance blends two distinct effects: the natural cost change from producing more or fewer units (the sales-volume variance) and any genuine spending inefficiency (the flexible budget variance). For instance, if a company produces 25% more units than planned, variable costs will naturally be higher, but the static budget comparison treats this entirely as an unfavorable variance. A flexible budget solves this by recalculating expected costs at the actual volume, using the same per-unit variable rates and fixed cost totals from the master budget. The resulting flexible budget variance then purely measures whether the company spent more or less per unit than it should have, enabling managers to evaluate performance fairly.

Question 2: BASIC CALCULATION

A company budgeted to produce 5,000 units with variable costs of $12 per unit and total fixed costs of $40,000. Actual production was 6,500 units. Prepare the flexible budget showing total variable costs, total fixed costs, and total costs at 6,500 units.

Show answer

Using the flexible budget formula: Total variable costs = $12 × 6,500 = $78,000. Fixed costs remain at $40,000 regardless of volume changes within the relevant range. Total flexible budget costs = $78,000 + $40,000 = $118,000. By comparison, the static budget total costs were ($12 × 5,000) + $40,000 = $100,000. The $18,000 difference between the flexible and static budgets ($118,000 − $100,000) is the sales-volume variance for costs, which is entirely attributable to producing 1,500 more units than planned.

Question 3: INTERMEDIATE

Rivera Manufacturing has the following master budget for April: budgeted sales = 15,000 units at $25 each; variable manufacturing cost = $10/unit; variable selling expense = $2/unit; fixed manufacturing overhead = $60,000; fixed selling and admin = $20,000. Actual results for April: 18,000 units sold for $440,000 total revenue; actual variable manufacturing costs = $185,000; actual variable selling expense = $38,000; actual fixed manufacturing overhead = $62,000; actual fixed selling and admin = $21,000. Prepare a full flexible budget performance report and compute the flexible budget variance and sales-volume variance for operating income.

Show answer

Flexible budget at 18,000 units: Revenue = $25 × 18,000 = $450,000. Variable manufacturing = $10 × 18,000 = $180,000. Variable selling = $2 × 18,000 = $36,000. Fixed manufacturing OH = $60,000. Fixed S&A = $20,000. Flexible budget operating income = $450,000 − $180,000 − $36,000 − $60,000 − $20,000 = $154,000. Static budget operating income at 15,000 units = ($25 × 15,000) − ($10 × 15,000) − ($2 × 15,000) − $60,000 − $20,000 = $375,000 − $150,000 − $30,000 − $60,000 − $20,000 = $115,000. Actual operating income = $440,000 − $185,000 − $38,000 − $62,000 − $21,000 = $134,000. Flexible budget variance = $134,000 − $154,000 = −$20,000 (unfavorable). Sales-volume variance = $154,000 − $115,000 = $39,000 (favorable). Check: −$20,000 + $39,000 = $19,000 = $134,000 − $115,000 = static budget variance (favorable).

Question 4: APPLIED

GreenTech Services operates a call center that budgeted handling 50,000 calls in June. Budgeted data: variable cost per call = $4.80 (labor $3.00, technology $1.20, supplies $0.60); total fixed costs = $125,000. Actual calls handled = 58,000. Actual total variable costs = $292,000; actual fixed costs = $128,000. The manager claims the $35,000 total cost overrun (versus the static budget) is mainly due to higher-than-expected call volume. Is the manager's claim justified? Support your answer with a flexible budget analysis.

Show answer

Static budget total costs = ($4.80 × 50,000) + $125,000 = $240,000 + $125,000 = $365,000. Actual total costs = $292,000 + $128,000 = $420,000. Static budget variance = $420,000 − $365,000 = $55,000 unfavorable (not $35,000 as the manager stated—the manager may have been approximating). Flexible budget at 58,000 calls: Variable = $4.80 × 58,000 = $278,400; Fixed = $125,000; Total = $403,400. Sales-volume variance = $403,400 − $365,000 = $38,400 unfavorable (explained by volume). Flexible budget variance = $420,000 − $403,400 = $16,600 unfavorable (spending inefficiency). The manager is partially correct: $38,400 of the $55,000 overrun (about 70%) is due to higher volume and was expected. However, $16,600 reflects genuine cost overruns—$13,600 in variable costs and $3,000 in fixed costs—that cannot be explained by volume alone and should be investigated.

Question 5: CRITICAL THINKING

A retail company uses units sold as its sole cost driver for flexible budgeting. However, the company sells products through both an online channel (low handling cost per order) and brick-and-mortar stores (high overhead per unit). In a given month, total units sold matched the master budget exactly, yet variable costs exceeded the flexible budget by a substantial margin. The flexible budget variance appears entirely unfavorable, but no individual input price or efficiency change occurred. Explain what is likely happening and recommend a modification to the flexible budget approach.

Show answer

This situation illustrates a key limitation of single-driver flexible budgets: a sales-mix shift. Even though total units sold matched the budget, the proportion sold through each channel likely changed. If more units were sold through the high-cost brick-and-mortar channel and fewer online, the weighted-average variable cost per unit would increase, causing total variable costs to exceed the flexible budget based on a single blended rate. Since no actual price or efficiency changes occurred, the entire unfavorable variance is a phantom caused by aggregation. The recommended modification is to adopt either a multi-segment flexible budget that prepares separate flex budgets for each sales channel (each with its own variable cost per unit) or an activity-based flexible budget that uses different cost drivers for different cost pools—for instance, flexing online fulfillment costs by online orders and store costs by store traffic. This approach aligns with ABC principles and produces variances that accurately reflect genuine efficiency differences rather than mix effects.

SUMMARY

Lesson Summary

Summary

A flexible budget adjusts budgeted revenues and costs to the actual activity level achieved during a period, using budgeted per-unit variable rates and the originally planned total fixed costs. The formula is straightforward—Flex Budget Total Cost = (Variable Cost per Unit × Actual Units) + Fixed Costs—but the analytical power is substantial. By comparing actual results to the flexible budget rather than the static (master) budget, managers can decompose total variances into a flexible budget variance (spending efficiency) and a sales-volume variance (volume effect).

This decomposition is essential for fair performance evaluation: it prevents managers from being blamed (or credited) for cost changes that are simply the mechanical result of producing more or fewer units. Preparing a flexible budget requires classifying each cost as variable, fixed, or mixed, identifying the appropriate cost driver, and ensuring the analysis stays within the relevant range. The flexible budget also serves as the foundation for advanced variance analysis, where the flexible budget variance is further broken into price and efficiency components for each input.