Activity Flexible Budgeting
The ability to identify changes in activity costs as activity output changes allows manag ers to more carefully plan and monitor activity improvements. Activity flexible budgeting is the prediction of what activity costs will be as activity output changes. Variance analysis within an activity framework makes it possible to improve traditional budgetary performance reporting. It also enhances the ability to manage activities.
In a unit-based approach, budgeted costs for the actual level of activity are obtained by assuming that a single unit-based driver (units of product or direct labor hours) drives all costs. A cost formula is developed for each cost item as a function of units produced or direct labor hours. Exhibit 12.4 presents a unit-based flexible budget based on direct labor hours. If, however, costs vary with respect to more than one driver and the drivers are not highly correlated with direct labor hours, then the predicted costs can be misleading
The solution, of course, is to build flexible budget formulas for more than one driver. Cost estimation procedures (high-low method, the method of least squares, and so on) can be used to estimate and validate the cost formulas for each activity. This multiple cost-formula approach allows managers to predict more accurately what costs should be for different levels of activity measured by the activity output measure these costs can then be compared with the actual costs to help as budgetary performance. Exhibit provides an example of an activity flexible budget. that the budgeted amounts for direct materials and direct labor are the same as those reported in Exhibit 12.4; they use the same activity output measure. The budgeted amounts for the other items differ significantly from the traditional amounts because the activity output measures differ.
Assume that the first activity level for each driver in Exhibit 12.5 corresponds to the actual activity usage levels. Exhibit 12.6 compares the budgeted costs for the actual activity usage levels with the actual costs. One item is on target, and the other six items are mixed. The net outcome is a favorable variance of $21,500.
The performance report in Exhibit 12.6 compares total budgeted costs for the actual level of activity with the total actual costs for each activity. It is also possible to compare the actual fixed activity costs with the budgeted fixed activity costs, and the actual variable activity costs with the budgeted variable costs. Moreover, Exhibit 12.5 presents the budget formulas for each activity without any indication of how these formulas can be derived Cornerstone 12.4 demonstrates how an activity-based flexible budget formula can be derived and then used for performance reporting with a detailed breakdown of fixed and variable activity costs.