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.