Back to results for “Variance Analysis”
Budgeting & Forecasting › Flexible Budgets

How do you prepare a flexible budget statement showing several activity levels?

Advanced

Answer

Build a table with columns for several activity levels (e.g., 80%, 90%, 100%, 110% of capacity). For each, recompute variable costs at that level and keep fixed costs constant, showing total cost and profit at each level. This 'flexible budget' set lets management see cost and profit across a range before the actual level is known.
Real-world example A flexible budget table shows costs and profit at 8,000, 10,000, and 12,000 units for planning.

Common follow-ups: What varies across the columns? | Why show several levels?