7.9 Flexible Budgets

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.

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.