7.11: Flexible Budgets

Last updated
Save as PDF

Page ID: 26089

$ \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $ $ \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} $$\newcommand{\id}{\mathrm{id}}$ $ \newcommand{\Span}{\mathrm{span}}$ $ \newcommand{\kernel}{\mathrm{null}\,}$ $ \newcommand{\range}{\mathrm{range}\,}$ $ \newcommand{\RealPart}{\mathrm{Re}}$ $ \newcommand{\ImaginaryPart}{\mathrm{Im}}$ $ \newcommand{\Argument}{\mathrm{Arg}}$ $ \newcommand{\norm}[1]{\| #1 \|}$ $ \newcommand{\inner}[2]{\langle #1, #2 \rangle}$ $ \newcommand{\Span}{\mathrm{span}}$ $\newcommand{\id}{\mathrm{id}}$ $ \newcommand{\Span}{\mathrm{span}}$ $ \newcommand{\kernel}{\mathrm{null}\,}$ $ \newcommand{\range}{\mathrm{range}\,}$ $ \newcommand{\RealPart}{\mathrm{Re}}$ $ \newcommand{\ImaginaryPart}{\mathrm{Im}}$ $ \newcommand{\Argument}{\mathrm{Arg}}$ $ \newcommand{\norm}[1]{\| #1 \|}$ $ \newcommand{\inner}[2]{\langle #1, #2 \rangle}$ $ \newcommand{\Span}{\mathrm{span}}$$\newcommand{\AA}{\unicode[.8,0]{x212B}}$

Early in the chapter, you learned that a budget should be adjusted for changes in assumptions or variations in the level of operations. Managers use a technique known as flexible budgeting to deal with budgetary adjustments. A flexible operating budget is a special kind of budget that provides detailed information about budgeted expenses (and revenues) at various levels of output.

A YouTube element has been excluded from this version of the text. You can view it online here: pb.libretexts.org/llmanagerialaccounting/?p=168

Leed Company’s manufacturing overhead cost budget at 70% capacity is shown below. Leed can produce 25,000 units in a 3 month period or a quarter, which represents 100% of capacity.

Leed Company
Manufacturing Overhead Cost
3-month Budget

Supplies	$1,400
Power	7,000
Insurance	4,200
Maintenance	4,900
Depreciation	18,000
Supervision	57,000
Total Overhead Costs	$92,500

Units Produced (70% capacity)	17,500

To keep the example simple, we assume that the first four costs are strictly variable and we will calculate a budget per unit for these costs. On the other hand, the last two costs, depreciation and supervision, are fixed costs and are assumed to be constant over the entire relevant range of activity meaning they do not change based on volume. The table below shows the calculations for units produced at 70% capacity and calculates the variable cost per unit for all variable costs.

		Variable	Fixed	Calculation
Units produced	17,500 units			(25,00 units x 70% capacity)

Supplies	$1,400	$0.08		($1,400 / 17,500 units)
Power	7,000	$0.40		($7,000 / 17,500 units)
Insurance	4,200	$0.24		($4,200 / 17,500 units)
Maintenance	4,900	$0.28		($4,900 / 17,500 units)
Depreciation	18,000		$18,000	No calculation – fixed cost
Supervision	57,000		$57,000	No calculation – fixed cost

Now that we know the variable costs per unit. we can calculate the flexible budget for any level of activity using these figures. Leed Company prepares a flexible budget for 70%, 80%, 90% and 100% capacity. Notice how the variable costs change with volume but the fixed costs remain the same.

Leed Company
Flexible Budget for Mfg Overhead
			70% capacity	80% capacity	90% capacity	100% capacity
Volume (in units)	(25,000 units x capacity %)		17,500	20,000	22,250	25,000

	Variable	Fixed
Supplies	$0.08		$1,400	$1,600	$1,780	$2,000
			(17,500 units x $0.08)	(20,000 units x $0.08)	(22,250 units x $0.08)	(25,000 units x $0.08)
Power	$0.40		7,000	8,000	8,900	10,000
			(17,500 units x $0.40)	(20,000 units x $0.40)	(22,250 units x $0.40)	(25,000 units x $0.40)
Insurance	$0.24		4,200	4,800	5,340	6,000
			(17,500 units x $0.24)	(20,000 units x $0.24)	(22,250 units x $0.24)	(25,000 units x $0.24)
Maintenance	$0.28		4,900	5,600	6,230	7,000
			(17,500 units x $0.24)	(20,000 units x $0.24)	(22,250 units x $0.24)	(25,000 units x $0.24)
Depreciation		$18,000	18,000	18,000	18,000	18,000
Supervision		$57,000	57,000	57,000	57,000	57,000
Total Mfg Overhead			$92,500	$95,000	$97,250	$100,000

A flexible budget can be prepared for any level of activity. The advantage to a flexible budget is we can create a budget based on the ACTUAL level of production to give us a clearer picture of our results by comparing the flexible budget to actual results. This analysis would compare the actual level of activity so volume variances are not a factor and management can focus on the cost variances only. We will discuss this analysis next in the performance report.