Skip to main content
Sign in Create a free account
Varsity Tutors
Sign in
Back to lessons

Cost Accounting • Budgeting and Planning

Preparing Flexible Budgets — Prepare a flexible budget for variable and fixed costs

Learn to build budgets that adapt to actual activity levels, enabling meaningful cost control and variance analysis.

Explore the lesson 17 min read
A calculator with a cost receipt and comparison chart for cost accounting
Inside this lesson 10 sections 5 questions 10 figures

SECTION 1

Historical Context & Motivation

For much of the industrial era, companies relied on static budgets — single-point financial plans that projected costs and revenues at one anticipated level of activity. While conceptually straightforward, these plans quickly proved inadequate when actual production volumes deviated from forecasts. A factory budgeted for 10,000 units could not meaningfully evaluate its cost performance when it actually produced 12,000 units; raw comparisons between budgeted and actual figures conflated volume differences with genuine inefficiencies. The flexible budget emerged as a direct response to this analytical limitation, providing managers with a tool that adjusts expected costs to match the actual level of output, thereby isolating true cost variances from volume-driven differences.

1920s • Rise of Standard Costing

Scientific management pioneers like Frederick Taylor and engineers at companies such as DuPont begin developing standard cost systems, creating the conceptual groundwork for predefined cost targets against which actual performance could be measured.

1930s • Static Budgets in Mass Production

Large-scale manufacturers adopt formal static budgets for annual planning. However, the Great Depression exposes a major flaw: when demand collapses, static budgets become meaningless benchmarks because they cannot adjust to drastically lower production volumes.

1950s • Flexible Budgeting Takes Shape

Post-war management accounting textbooks formalize the distinction between fixed and variable costs and introduce the flexible budget as a tool for performance evaluation. The concept allows managers to restate budgeted costs at any observed activity level.

1980s–1990s • Integration with ERP Systems

Enterprise Resource Planning (ERP) software automates flexible budgeting, enabling real-time variance reports. Companies can now generate flexible budgets at the push of a button, making the technique standard practice across industries.

2010s–Present • Beyond Flex: Rolling & Activity-Based Budgets

Modern organizations extend flexible budgeting concepts into rolling forecasts and activity-based budgeting frameworks. Despite these innovations, the core logic of adjusting costs to actual activity remains the foundational analytical discipline.

The central question that flexible budgeting answers is deceptively simple: Given the volume of output we actually achieved, how much should we have spent? By separating costs into their variable and fixed components and recalculating expected costs at the actual activity level, the flexible budget provides a fair benchmark — one that neither punishes managers for producing more than planned nor masks inefficiency behind lower-than-expected volumes.

SECTION 2

Core Principles & Definitions

Building a flexible budget requires a solid understanding of cost behavior — specifically, how different cost categories respond when the level of activity changes. The entire mechanism hinges on classifying every budgeted cost line as variable, fixed, or mixed and then applying the appropriate adjustment logic. Before constructing any numbers, you must internalize a few foundational principles that govern how flexible budgets differ from their static counterparts and why those differences matter for managerial decision-making.

1

Variable Costs Scale with Activity

Variable costs change in direct proportion to the activity driver (e.g., units produced, machine hours). In a flexible budget, the variable cost per unit remains constant, so total variable cost = rate × actual quantity.
2

Fixed Costs Remain Constant Within the Relevant Range

Fixed costs (rent, depreciation, salaried labor) do not change as activity fluctuates within the relevant range. A flexible budget carries fixed costs forward at the same total dollar amount regardless of actual output.
3

Mixed Costs Require Separation

Some costs (e.g., utilities, maintenance) contain both variable and fixed components. Use techniques such as the high-low method or regression analysis to split them before building the flexible budget.
4

The Flexible Budget Isolates Efficiency Variances

By restating the budget at actual volume, the difference between the flexible budget and actual results is the flexible budget variance, which measures spending efficiency — not volume deviations.
5

Activity Driver Selection Is Critical

The chosen activity driver (units produced, direct labor hours, machine hours) must be the factor that most directly causes variable costs to change. An inappropriate driver undermines the entire flexible budget's analytical value.
✦

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. A static budget is the original route plotted before you left the house. If you take a detour, the static route is useless for judging how efficiently you drove. The flexible budget recalculates the expected fuel consumption, time, and distance from your actual starting point, letting you evaluate your driving efficiency fairly. Similarly, a flexible budget recalculates expected costs at your actual production level, letting you judge cost efficiency without the noise of volume changes.

SECTION 3

Visual Explanation — Static vs. Flexible Budget

The diagram below illustrates the relationship between a static budget, a flexible budget, and actual results. Notice how the flexible budget sits between the static budget and the actual results. The gap between the static budget and the flexible budget is the sales-volume variance (driven by the difference in activity level), while the gap between the flexible budget and actual results is the flexible budget variance (driven by price and efficiency differences).

Variance Analysis FrameworkSTATIC BUDGETBudgeted Qty:10,000 unitsTotal Cost: $250,000FLEXIBLE BUDGETActual Qty:12,000 unitsTotal Cost: $280,000ACTUAL RESULTSActual Qty:12,000 unitsTotal Cost: $295,000SALES-VOLUME VARIANCE$280,000 − $250,000 = $30,000 UFLEXIBLE BUDGET VARIANCE$295,000 − $280,000 = $15,000 UTOTAL STATIC BUDGET VARIANCE$295,000 − $250,000 = $45,000 UnfavorableThe flexible budget decomposes the total static budget variance into volume-driven and efficiency-driven components.
The variance analysis framework shows how the flexible budget (center, purple) bridges the gap between the static budget (left, blue) and actual results (right, pink). The sales-volume variance captures the cost impact of producing more or fewer units than planned, while the flexible budget variance isolates spending efficiency at the actual volume.

This framework is essential because without the flexible budget in the middle, a manager looking at the $45,000 total unfavorable variance might conclude that cost controls failed catastrophically. In reality, $30,000 of that variance arose simply because the company produced 2,000 more units than planned — a desirable outcome if driven by higher demand. Only the $15,000 flexible budget variance signals potential spending inefficiency that warrants investigation. This decomposition is the primary analytical contribution of the flexible budget.

SECTION 4

Mathematical Framework

The mathematical structure of a flexible budget is elegantly simple. At its core, it applies a cost function that separates total budgeted costs into their variable and fixed components. This function can be expressed at any level of activity, which is precisely what gives the flexible budget its adaptability. The following equations define the framework.

TOTAL FLEXIBLE BUDGET COST

TotalBudgetedCost=(VariableCostperUnit×ActualQuantity)+TotalFixedCostsTotal Budgeted Cost = (Variable Cost per Unit × Actual Quantity) + Total Fixed Costs

Where Variable Cost per Unit is the standard (budgeted) variable rate per unit of the activity driver, Actual Quantity is the actual number of units produced (or the actual level of the chosen activity driver), and Total Fixed Costs is the lump-sum amount that remains unchanged across activity levels within the relevant range.

FLEXIBLE BUDGET VARIANCE

FlexibleBudgetVariance=ActualResults−FlexibleBudgetAmountFlexible Budget Variance = Actual Results − Flexible Budget Amount

A positive result for costs means actual costs exceeded the flexible budget, which is unfavorable (U). A negative result means costs were below the budget, which is favorable (F). For revenue lines, the interpretation reverses.

SALES-VOLUME VARIANCE

Sales−VolumeVariance=FlexibleBudgetAmount−StaticBudgetAmountSales-Volume Variance = Flexible Budget Amount − Static Budget Amount

This variance arises purely from the difference between budgeted and actual activity levels. For cost items, a positive result (actual volume exceeded plan) is unfavorable because more units require more spending. For revenue, a positive result is favorable.

TOTAL STATIC BUDGET VARIANCE DECOMPOSITION

StaticBudgetVariance=FlexibleBudgetVariance+Sales−VolumeVarianceStatic Budget Variance = Flexible Budget Variance + Sales-Volume Variance

This identity confirms that the total difference between actual results and the static budget can always be decomposed into two mutually exclusive components: one driven by volume and one driven by spending efficiency.

⚠

Convention Note

When labeling variances, always attach "F" (Favorable) or "U" (Unfavorable) to the dollar amount. An unfavorable cost variance means you spent more than the flex budget allowed. A favorable revenue variance means you earned more than expected at that activity level. Never present a variance without its direction — the dollar figure alone is ambiguous.

SECTION 5

Detailed Breakdown — Variable, Fixed, and Mixed Costs in the Flexible Budget

The accuracy of any flexible budget depends entirely on how well you classify and model cost behavior. Each cost line item in the budget must be assigned to one of three categories — variable, fixed, or mixed — before the flexible budget can be prepared. The diagram below visualizes how each cost type behaves across different production levels and how the flexible budget incorporates them.

Cost Behavior Patterns in Flexible BudgetsVariable Costs0UnitsMax$$15/unitFixed Costs0UnitsMax$$100,000Mixed Costs0UnitsMax$Fixed portion: $20,000+$5/unitTotal Flexible Budget Cost0UnitsMax$Fixed baseTotal cost line
The four panels show: (1) variable costs rising linearly from the origin; (2) fixed costs as a horizontal line; (3) mixed costs starting at a fixed base and rising; and (4) the total flexible budget cost as an upward-sloping line anchored at the fixed cost base.
Cost CategoryBehavior in Flexible BudgetExamples
VariableAdjusts proportionally: total = rate × actual unitsDirect materials, direct labor (piece-rate), sales commissions, shipping costs
FixedRemains at the same total dollar amount regardless of activity levelRent, insurance, straight-line depreciation, salaried management
Mixed (Semi-variable)Fixed base + variable component: total = fixed portion + (variable rate × actual units)Utilities (base charge + per-kWh), maintenance (base crew + overtime), telephone (base + per-minute)

Cost categories and their treatment in a flexible budget

SECTION 6

Worked Example — Preparing a Flexible Budget

Apex Manufacturing prepared a static budget for the year based on expected production of 8,000 units. Actual production turned out to be 10,000 units. We will build a flexible budget at the actual activity level and compute the relevant variances. The following per-unit and total cost data are available from the original budget:

Cost ItemCost BehaviorStatic Budget (8,000 units)Actual Results (10,000 units)
Direct MaterialsVariable — $12/unit$96,000$128,000
Direct LaborVariable — $8/unit$64,000$85,000
Variable OverheadVariable — $5/unit$40,000$54,000
Fixed OverheadFixed — total$100,000$103,000
Total Costs$300,000$370,000

Apex Manufacturing — Given Data

Preparing the Flexible Budget and Analyzing Variances

  1. 1

    Step 1 — Identify Variable Cost Rates

    From the static budget data, extract the per-unit variable cost rates. Direct Materials = $12/unit, Direct Labor = $8/unit, Variable Overhead = $5/unit. The total variable cost rate is $12 + $8 + $5 = $25 per unit.
    Total variable cost rate = $25/unit
  2. 2

    Step 2 — Identify Fixed Costs

    Fixed Overhead is budgeted at $100,000 total. This amount does not change with production volume in the flexible budget. Regardless of whether actual production is 8,000 or 10,000 units, the budgeted fixed overhead remains $100,000.
    Total fixed costs = $100,000
  3. 3

    Step 3 — Compute the Flexible Budget at 10,000 Units

    Apply the variable rates to the actual volume: Direct Materials = $12 × 10,000 = $120,000. Direct Labor = $8 × 10,000 = $80,000. Variable Overhead = $5 × 10,000 = $50,000. Fixed Overhead = $100,000. Therefore, the total flexible budget = $120,000 + $80,000 + $50,000 + $100,000 = $350,000.
    Flexible Budget Total = $350,000 at 10,000 units
  4. 4

    Step 4 — Compute the Flexible Budget Variance

    Compare actual costs to the flexible budget line by line. Direct Materials: $128,000 − $120,000 = $8,000 U. Direct Labor: $85,000 − $80,000 = $5,000 U. Variable Overhead: $54,000 − $50,000 = $4,000 U. Fixed Overhead: $103,000 − $100,000 = $3,000 U. Total flexible budget variance = $370,000 − $350,000 = $20,000 Unfavorable. This means Apex spent $20,000 more than expected for producing 10,000 units.
    Flexible Budget Variance = $20,000 U (efficiency / spending issue)
  5. 5

    Step 5 — Compute the Sales-Volume Variance

    Compare the flexible budget to the static budget. Sales-Volume Variance = $350,000 − $300,000 = $50,000 Unfavorable for costs (since producing more units inherently costs more). Note: for revenue, producing more units would be favorable. The total static budget variance = $370,000 − $300,000 = $70,000 U, which equals the flex budget variance ($20,000 U) plus the volume variance ($50,000 U).
    Sales-Volume Variance = $50,000 U | Total Static Budget Variance = $70,000 U = $20,000 + $50,000 ✓
💡

Interpretation

Without the flexible budget, a manager would see the $70,000 total unfavorable variance and might panic. The flexible budget reveals that $50,000 of the overrun was purely due to higher volume — which could be good news if revenue increased accordingly. Only $20,000 reflects actual inefficiency, and line-item analysis shows the inefficiency is spread across all cost categories, suggesting a systemic issue rather than a single department's failure.

SECTION 7

Strengths and Limitations of Flexible Budgets

Like any managerial accounting tool, the flexible budget has both significant advantages and noteworthy limitations. Understanding these helps managers deploy the tool appropriately and avoid drawing false conclusions from the analysis.

StrengthsLimitations
Provides a fair apples-to-apples comparison by adjusting for volume differences, so managers evaluate efficiency rather than volume effects.Assumes a perfectly linear relationship between cost and volume (constant variable rate), which may not hold at extreme production levels.
Facilitates meaningful variance analysis by decomposing the total variance into volume and efficiency components.Accuracy depends heavily on correct cost classification (variable vs. fixed). Misclassification produces misleading flexible budget amounts.
Can be prepared at multiple activity levels in advance, giving managers pre-built benchmarks for different demand scenarios.Does not explain why variances occurred — it identifies that a variance exists but requires further investigation into root causes.
Improves managerial accountability by removing the excuse that volume differences caused cost overruns.Fixed cost treatment can be overly rigid; in practice, some 'fixed' costs change in steps (e.g., hiring an additional supervisor at a volume threshold).
Supports better forecasting by helping identify cost behavior patterns through repeated variance analysis.Requires reliable historical data or engineering estimates to establish accurate variable cost rates — garbage in, garbage out.

Comparative analysis of flexible budget strengths and limitations

✦

KEY TAKEAWAY

A flexible budget is like an adjustable wrench — it can fit different sizes (activity levels) and provides a much better grip (cost control) than a fixed-size wrench (static budget). However, if you set the wrench to the wrong size (misclassify costs), you will strip the bolt (draw incorrect conclusions). The tool is only as good as the accuracy of the cost behavior assumptions that underpin it.

SECTION 8

Connection to Advanced Theory — Activity-Based Flexible Budgets

The traditional flexible budget uses a single activity driver — typically units produced — to adjust all variable costs. While effective for simple manufacturing environments, this approach can be overly simplistic for organizations with diverse cost pools driven by multiple activities. Activity-Based Flexible Budgeting (ABFB) extends the flexible budget concept by applying different cost drivers to different cost pools, borrowing from Activity-Based Costing (ABC) methodology. This produces more refined variance analysis, particularly for overhead costs whose behavior is not directly proportional to production volume.

FeatureTraditional Flexible BudgetActivity-Based Flexible Budget
Cost DriversSingle driver (units produced, direct labor hours)Multiple drivers (setups, inspections, machine hours, customer orders)
Overhead TreatmentAll variable overhead scales with one driverEach overhead pool adjusts by its own driver
AccuracyAdequate for homogeneous productionSuperior for complex, multi-product environments
ComplexityLow — easy to prepare and interpretHigher — requires detailed activity and cost pool data
Best Suited ForSingle-product firms, simple cost structuresMulti-product firms, service industries, complex overhead

Traditional vs. Activity-Based Flexible Budgets

As you advance through your cost accounting coursework, you will encounter topics such as standard costing (which drills deeper into price and efficiency variances), multi-level contribution margin analysis, and capacity analysis (distinguishing between budgeted, practical, and theoretical capacity for fixed overhead allocation). Each of these builds directly on the flexible budget framework, making the concepts you have learned in this lesson essential building blocks for more advanced managerial accounting topics.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

A manager examines the static budget variance and finds that total manufacturing costs exceeded the budget by $40,000. She argues that cost control failed. What critical piece of information is missing from this analysis, and how would a flexible budget change the interpretation?
Show answer
The missing information is the actual activity level relative to the budgeted activity level. If actual production exceeded the static budget volume, part of the $40,000 variance is simply the additional cost of producing more units (the sales-volume variance), not a reflection of inefficiency. A flexible budget would restate the expected costs at the actual volume, isolating the flexible budget variance — the portion attributable to spending efficiency. For instance, if the flexible budget at actual volume shows expected costs only $10,000 below actual costs, then only $10,000 represents true inefficiency, and $30,000 is the natural cost increase from higher production.

Question 2: BASIC CALCULATION

A company's static budget was prepared for 5,000 units with the following costs: Direct Materials ($6/unit), Direct Labor ($10/unit), Variable Overhead ($4/unit), and Fixed Overhead ($50,000 total). Actual production was 6,500 units. Prepare the flexible budget at 6,500 units and calculate the total flexible budget cost.
Show answer
At 6,500 units, the flexible budget costs are: Direct Materials = $6 × 6,500 = $39,000; Direct Labor = $10 × 6,500 = $65,000; Variable Overhead = $4 × 6,500 = $26,000; Fixed Overhead = $50,000 (unchanged). Total flexible budget cost = $39,000 + $65,000 + $26,000 + $50,000 = $180,000. By comparison, the static budget total was ($6 + $10 + $4) × 5,000 + $50,000 = $100,000 + $50,000 = $150,000. The $30,000 difference ($180,000 − $150,000) is the sales-volume variance, reflecting the cost of producing 1,500 additional units at the $20/unit variable rate.

Question 3: INTERMEDIATE

Using the data from Problem 2, suppose the actual costs at 6,500 units were: Direct Materials $42,250; Direct Labor $63,700; Variable Overhead $28,600; Fixed Overhead $51,500. Compute each line-item flexible budget variance and the total flexible budget variance, indicating whether each is favorable or unfavorable.
Show answer
Comparing actual to the flexible budget at 6,500 units: Direct Materials variance = $42,250 − $39,000 = $3,250 Unfavorable (spent more per unit than budgeted). Direct Labor variance = $63,700 − $65,000 = −$1,300, which is $1,300 Favorable (spent less than expected). Variable Overhead variance = $28,600 − $26,000 = $2,600 Unfavorable. Fixed Overhead variance = $51,500 − $50,000 = $1,500 Unfavorable (perhaps due to an unplanned insurance premium increase). Total flexible budget variance = ($42,250 + $63,700 + $28,600 + $51,500) − $180,000 = $186,050 − $180,000 = $6,050 Unfavorable. The net unfavorable variance indicates that overall, costs ran $6,050 above what was expected for 6,500 units, warranting investigation particularly into materials and variable overhead.

Question 4: APPLIED

GreenTech Services runs a call center and uses 'calls handled' as its activity driver. The static budget assumed 20,000 calls with variable costs of $3.50 per call (labor, supplies) and fixed costs of $85,000 (rent, software licenses, management salaries). In March, the center handled 24,000 calls, incurring total variable costs of $88,800 and fixed costs of $86,200. Prepare the flexible budget, compute all variances, and advise management on which variances deserve attention.
Show answer
Flexible budget at 24,000 calls: Variable costs = $3.50 × 24,000 = $84,000; Fixed costs = $85,000; Total = $169,000. Static budget total = ($3.50 × 20,000) + $85,000 = $155,000. Actual total = $88,800 + $86,200 = $175,000. Sales-volume variance (cost) = $169,000 − $155,000 = $14,000 U (higher volume increases costs). Flexible budget variance: Variable = $88,800 − $84,000 = $4,800 U (actual cost per call was $3.70 vs. budgeted $3.50); Fixed = $86,200 − $85,000 = $1,200 U. Total flexible budget variance = $6,000 U. Management should focus on the $4,800 unfavorable variable cost variance. At $0.20 per call above standard across 24,000 calls, this suggests either labor overtime, higher supply costs, or inefficiency in call handling. The $1,200 fixed cost overrun is relatively minor and may reflect a one-time expense. The $14,000 volume variance is informational — higher call volume may correlate with higher revenue, making it a net positive.

Question 5: CRITICAL THINKING

A manufacturing firm produces two products — Alpha and Beta — on the same production line. Alpha uses 2 machine hours per unit and Beta uses 5 machine hours per unit. The static budget assumed 3,000 Alpha and 1,000 Beta (total 11,000 machine hours). Actual production was 2,500 Alpha and 1,500 Beta (total 12,500 machine hours). Variable overhead is driven by machine hours at $6/hour. If you prepare a flexible budget using units produced (4,000 actual vs. 4,000 budgeted), the volume variance appears to be zero. Explain why this is misleading and propose a better approach.
Show answer
Using total units as the activity driver masks a significant change in product mix. Although total units remained constant at 4,000, the shift from Alpha-heavy to Beta-heavy production increased machine hours from 11,000 to 12,500 — a 13.6% increase. Because variable overhead is driven by machine hours, the flexible budget should be prepared using machine hours as the driver, not units. With machine hours: Flexible budget variable overhead = $6 × 12,500 = $75,000, compared to the static budget of $6 × 11,000 = $66,000. The sales-volume variance (for overhead) is $9,000 U, correctly capturing the increased resource consumption from the product mix shift. A unit-based flexible budget would incorrectly show zero volume variance and would attribute the entire increase to spending inefficiency. This illustrates a fundamental principle: the activity driver must reflect the factor that actually causes the cost to change. In multi-product settings, this often means using resource-consumption measures (machine hours, labor hours) rather than simple output units.

SUMMARY

Lesson Summary

Summary

A flexible budget adjusts the static budget to reflect the actual level of activity, enabling fair cost performance evaluation. Its construction relies on separating costs into variable costs (which scale proportionally with the activity driver) and fixed costs (which remain constant within the relevant range). The total flexible budget formula is straightforward: Total Budgeted Cost = (Variable Cost per Unit × Actual Quantity) + Total Fixed Costs.

The flexible budget decomposes the total static budget variance into two actionable components: the sales-volume variance (driven by the difference between planned and actual volume) and the flexible budget variance (driven by spending efficiency and price changes). This decomposition removes volume noise from performance evaluation, giving managers a clear signal about true cost control effectiveness. Selecting the right cost driver and accurately classifying cost behavior are critical to the flexible budget's validity. In multi-product environments, resource-consumption measures (such as machine hours) often serve as more appropriate drivers than simple output units.

Varsity Tutors • Cost Accounting • Preparing Flexible Budgets — Prepare a flexible budget for variable and fixed costs