Flexible Budget: Formula, Variance Analysis and Worked Example

A flexible budget recalculates planned revenue and variable expenses for a different activity level while retaining the original budgeted rates and appropriate fixed commitments. For performance review, use actual completed activity. Comparing actual results with that same-activity budget separates the effect of doing more or less work from the effect of prices and spending.

This guide uses one fictional USD service-business month, shows the full profit reconciliation and provides the calculator above. Figures are invented planning inputs, not benchmarks. The tool is a simple equivalent-unit operating model, not a cash forecast, manufacturing inventory model or explanation of who caused a variance.

Flexible budget formula and assumptions

Flexible revenue = budgeted price × actual activity. Flexible variable expense = budgeted variable cost per unit × actual activity. Flexible total expense = flexible variable expense + budgeted fixed expense. Subtract total expense from flexible revenue to calculate flexible operating income.

Keep the original selling price and variable-cost rate when flexing the budget. Substituting actual rates would hide the differences you need to investigate. Do not scale every expense by the volume change: rent can stay fixed within a relevant range, while a per-visit supply cost changes with completed visits. A further supervisor, minimum staffing requirement or additional vehicle can create a new fixed-cost step.

Use the fixed, variable and mixed-cost guide to define cost behavior. If a pool mixes fixed and variable amounts, split it using defensible records. The high-low method gives only a preliminary two-observation estimate and still needs checks against other records.

A complete flexible budget example

The original monthly plan is 200 completed equivalent cleaning visits at $180 each, with $80 variable expense per visit and $14,000 fixed operating commitments. Actual activity is 180 visits. Actual net sales are $31,500, actual variable expenses $15,120 and actual fixed operating expenses $14,300.

At 180 actual visits, the original $180 price produces flexible revenue of $32,400, and the original $80 variable rate produces flexible variable expense of $14,400. The fixed budget remains $14,000. Actual revenue implies $175 per visit and actual variable spending $84 per visit in this simplified case. Those implied averages diagnose differences; they do not establish why prices or costs changed.

The static comparison says actual variable spending of $15,120 is $880 below the original $16,000 budget. That is a lower bill, but not evidence of efficient delivery: the business completed 20 fewer visits. At 180 visits, the appropriate variable-cost comparison is $15,120 actual versus $14,400 flexible, a $720 unfavorable difference.

Flexible budget variance formula: label the sign

This guide defines flexible-budget variance = actual result − flexible budget. A positive revenue difference is favorable; a positive expense difference is unfavorable. For operating income, positive is favorable. A label must accompany the sign so a higher expense is not mistaken for good performance.

The $900 revenue shortfall, $720 variable-spending excess and $300 fixed-spending excess together reduce operating income by $1,920. Do not add the contribution-margin variance again: contribution already combines revenue and variable expenses. A variance directs investigation; it is not automatically an employee fault, waste finding or price recommendation.

Reconcile the full original-to-actual profit change

Activity effect = flexible operating income − original operating income. Here it is $4,000 − $6,000 = −$2,000. At the unchanged $100 planned contribution per visit, completing 20 fewer visits loses $2,000 contribution toward fixed commitments.

Performance effect = actual operating income − flexible operating income. Here it is $2,080 − $4,000 = −$1,920. The full change is −$2,000 + −$1,920 = −$3,920, exactly matching $2,080 actual minus $6,000 original. That reconciliation prevents an unexplained residual from disappearing into a general budget label.

For a multiple-product business, the equivalent-unit assumption can fail when mix changes. A more complex analysis must separate volume, mix, price and cost effects using a consistent base. Start with the sales-mix and weighted-margin guide rather than treating every completed order as identical.

How to prepare a useful flexible budget

1. Retain the original approved plan, rates and reporting period. A revised forecast is useful, but should not overwrite the comparison baseline.
2. Reconcile actual activity and recognized net sales. Returns, discounts and incomplete jobs need a stated convention.
3. Flex each variable line with its real driver. Job count can suit consumables, while miles or machine-hours may better explain another pool.
4. Keep fixed commitments at their budgeted amount only within the valid range. Separately identify actual changes, cost steps and scope changes.
5. Compare actual and flexible lines, then reconcile the activity and performance effects to the total operating-income difference.
6. Investigate the largest controllable drivers with invoices, work records and schedules. Record an owner, action and next review date.

A favorable cost variance can arise from deferred maintenance or reduced service quality. An unfavorable labor variance can arise from training, changed customer requirements or incorrect standards. The budget identifies a question to investigate, not a complete operational diagnosis.

Flexible budget in Excel or Google Sheets

For a compact worksheet, place planned units in B2, actual units B3, budgeted price B4, variable rate B5 and fixed budget B6. Original operating income is =B2*(B4-B5)-B6; flexible operating income is =B3*(B4-B5)-B6. Enter actual revenue B7, actual total variable expense B8 and actual fixed expense B9. Actual operating income is =B7-B8-B9.

Require complete numeric inputs and a consistent period before calculating. The activity effect is flexible minus original; the performance effect is actual minus flexible. All three operating-income calculations should use the same included cost boundary. Use the contribution statement template to reconcile the revenue, variable-expense, contribution and fixed-expense lines.

Where the simple model stops

The calculator does not validate productive capacity, forecast demand, model tax or loan payments, or reproduce an external financial statement. Inventory changes and production-versus-sales differences require additional schedules. At zero actual units, unit-price averages are undefined; any positive actual revenue needs a timing or unit reconciliation before interpretation.

Use a separate cash budget and receipt/payment schedule for liquidity. A favorable operating variance cannot pay a bill before customer cash arrives. Keep operating results, future demand and payment timing distinct.

Turn the variance table into a performance report

A useful flexible budget performance report answers three separate questions: how much work happened, what that work should have earned and cost at the approved rates, and what actually happened. Give each line an activity driver, evidence reference and explanation. Keep the signed difference separate from its favorable or unfavorable label. The label describes the operating-income effect, not whether someone made a good decision.

In the existing cleaning example, revenue is $900 below the same-activity budget. The implied actual price is $31,500 ÷ 180 = $175, versus the original $180. The arithmetic explanation is 180 × ($175 − $180) = −$900. That does not establish a price-cutting problem: inspect discounts, refunds, job scope and the mix of visits before calling this a pure selling-price variance. A different service mix can change the average even if no individual price changes.

The $720 unfavorable variable-expense difference equals 180 × ($84 − $80). Calling this an efficiency variance would go beyond the data. The $84 average can reflect higher input prices, more input quantities, different work or incorrect classifications. A visit-level total cannot identify labor hours and wage-rate effects without a supporting hours schedule.

Separate labor rate from hours with a supporting schedule

Consider a separate fictional labor schedule, not a breakdown of the $720 above. For 180 comparable visits, the standard allows 1.5 delivery hours per visit at $24 per hour. Standard hours allowed are 270 and the flexible labor budget is $6,480. Actual approved hours are 288 at $25, costing $7,200. The actual-minus-standard cost difference is $720 unfavorable.

Use actual hours for the rate component and standard hours allowed for actual output for the hours comparison. Using the original 200-visit labor allowance would mix volume with performance again. Confirm whether the labor pool includes overtime, employer burden and paid non-delivery time; the standard and actual columns need the same scope. An hours variance can reflect training or authorized service changes, so investigate records before assigning responsibility. The embedded calculator reports aggregate revenue and expense differences; it does not calculate these labor subvariances.

When one activity driver is not enough

Suppose a separate monthly support pool includes $1,200 fixed dispatch, $2 per completed visit and $0.40 per delivery mile. At 180 visits and 2,100 miles, its flexible amount is $1,200 + $360 + $840 = $2,400. Multiplying the entire original pool by a visits percentage would incorrectly scale the fixed commitment and assume miles always move with visits. Keep the three components in a supporting schedule and reconcile the total back to the operating report.

Where a contract creates a capacity step, such as a second vehicle above a documented mileage threshold, use the applicable budgeted step rather than pretending the original fixed amount covers unlimited activity. Preserve the approved baseline and show scope changes separately. The simple calculator uses one equivalent activity unit and one fixed pool; use it only when that simplification fits, or prepare a driver-level schedule outside the widget.

Example of a variance action record

For the original $900 revenue shortfall, assign the sales owner to reconcile the 180 completed visits to net invoice lines, approved discounts and credits. Record a due date and the resulting explanation. For the $720 variable-spending difference, the operations owner should reconcile purchase usage and approved delivery time. For the $300 fixed-expense excess, inspect the actual invoice and whether it belongs to this period. These are evidence requests, not conclusions that the business should raise prices or reduce staffing.

Review absolute dollars and the operational context together. A small percentage of a large pool may deserve attention, while a large percentage on a tiny line may not. Do not invent a universal investigation threshold. Agree a review policy before the period closes and track repeated small differences that accumulate. Close the review by recording the evidence, action, owner and next check; retain the original standards so a revised forecast does not erase accountability.

Download and verify the flexible budget worksheet

Download the formula-based flexible budget review CSV. It follows this guide’s 200 planned and 180 actual visits, producing $6,000 original operating income, $4,000 flexible income and $2,080 actual income. The final reconciliation should be zero: activity effect plus performance effect minus total change. Import into Excel or Google Sheets with formula interpretation enabled, retain row positions and verify those defaults before replacing inputs. Blank or invalid inputs suppress calculations. CSV does not preserve formatting, validation menus or multiple sheets.

Use the restaurant operating-budget guide for a restaurant-specific plan and the restaurant sales forecast for demand assumptions. This page owns the same-activity performance comparison; it does not replace those industry plans. For the labor decomposition method, see OpenStax’s labor variance lesson. All additional schedules here are original fictional illustrations.

Method sources

OpenStax explains preparing flexible budgets and using budgets to evaluate results. This guide's service-business data, classifications and reconciliation are original illustrative examples.

Keep the master plan behind the flexible comparison

The master budget guide and cash bridge connect sales, delivery costs and collections before the period starts. Preserve that approved plan. This page flexes operating results at actual activity; it does not rebuild the full cash budget or projected balance sheet.

Download a static budget variance report

Use the budget vs actual Excel template when you need a monthly or YTD comparison against the original approved totals. Its blank report and filled example keep actual revenue, expenses and the operating-result bridge together. The template owns the download task; this guide owns the same-activity flexible-budget analysis.

For a small static illustration, budget revenue of $30,000 less $20,000 included expenses gives $10,000 operating result. Actual revenue of $28,000 less $21,000 expenses gives $7,000. Using actual minus budget, the revenue difference is −$2,000, expense difference is +$1,000 and result difference is −$3,000. The result bridge is revenue variance minus expense variance. It is not a new example of the calculator's activity-adjusted results.

Before calling the $1,000 expense increase inefficient, inspect completed activity and the expense boundary. More jobs, a rate increase, overtime or a timing adjustment can produce different explanations. Apply the original rates to actual activity in this page's calculator, then compare actual results with that flexible benchmark.

For monthly reporting, enter explicit zeros for genuinely closed zero-activity accounts and leave unknown actuals blank. Match the YTD cutoff on both sides; do not compare three actual months with a full-year budget. Keep expense reductions caused by fewer jobs separate from improvements at the same workload. The workbook leaves incomplete periods unreported and shows no percentage when the budget denominator is zero.

Preserve the approved budget when expectations change. Update future drivers in the rolling forecast and its dated worksheet, keeping its current expectations separate from the original target. Neither the operating comparison nor the forecast proves that customers will pay on time; use a dated cash schedule for that question.