Home Accounting

# Flexible Budgets

The previous chapter provided a comprehensive budget illustration using a static budget. The static budget is one which is developed for a single level of activity. It is very useful for planning and control purposes. However, you were also cautioned about the potential shortcomings of using static budgets for performance evaluation. Specifically, when the actual output varies from the anticipated level, variances are likely to arise. These variances can be quite misleading. The genesis of the problem is that variable costs will tend to track volume. If the company produces and sells more products than anticipated, one would expect to see more variable costs (and vice versa). Presumably, it is a good thing to produce and sell more than planned, but the variances resulting from the higher costs can appear as a bad thing! The opposite occurs when volume is less than anticipated.

To illustrate, assume that Mooster's Dairy produces a premium brand of ice cream. Mooster's Dairy uses a static budget based on anticipated production of 100,000 gallons per month. Cost behavior analysis revealed that direct materials are variable and anticipated to be \$1 per gallon (\$100,000 in total), direct labor is variable and anticipated to be \$.50 per gallon (\$50,000 in total), and variable factory overhead is expected to be \$1.50 per gallon (\$150,000 in total). Fixed factory overhead is planned at \$205,000 per month. The monthly budget for total manufacturing costs is \$505,000, as shown in the budget column below.

MOOSTER'S DAIRY - Static Budget/Expense Analysis For the Month Ending July 31, 20X9

 Actual Budget (105,000 units) (100,000 units) Variance Variable Expenses Direct materials \$ 105,000 \$ 100,000 \$ (5,000) Direct labor 53,000 50,000 (3,000) Variable factory overhead 155,000 150,000 (5,000) Total Variable Expenses \$ 313,000 \$ 300,000 \$ (13,000) Fixed Factory Overhead \$ 200,000 \$ 205,000 \$ 5,000 Total Manufacturing Costs \$ 513,000 \$ 505,000 \$ (8,000)

July of 20x9 was hotter than usual, and Mooster found them selves actually producing 105,000 gallons. Total factory costs were \$513,000.

Mooster's July's budget versus actual expense analysis reveals unfavorable variances for materials, labor, and variable factory overhead. Does this mean the production manager has done a poor job in controlling costs? Remember that actual production volume exceeded plan. At a glance, it is challenging to reach any conclusion. What is needed is a performance report where the budget is "flexed" based on the actual volume.

The flexible budget reveals a much different picture. Rather than incurring \$8,000 of cost overruns as portrayed by the variances associated with the static budget, you can see below that total production costs were \$7,000 below what would be expected at 105,000 units of output. On balance, it appears that the production manager has done a good job.

 MOOSTER'S DAIRY - Flexible Budget/Expense Analysis For the Month Ending July 31, 20X9 Actual Budget (105,000 units) (105,000 units) Variance Variable Expenses Direct materials Direct labor Variable factory overhead \$ 105,000 53,000 155,000 \$ 105,000 52,500 157,500 \$ - (500) 2,500 Total Variable Expenses \$ 313,000 \$ 315,000 \$ 2,000 Fixed Factory Overhead \$ 200,000 \$ 205,000 \$ 5,000 Total Manufacturing Costs \$ 513,000 \$ 520,000 \$ 7,000

Specifically, direct materials cost exactly \$1.00 per gallon of output. Direct labor totaled \$500 in excess of the plan amount of \$52,500 (105,000 units x \$0.50 = \$52,500), resulting in an unfavorable labor variance. This could be due to using more labor hours or paying a higher labor rate per hour - or some combination thereof. Later in this chapter, you will learn how to perform analysis to better identify the root contributing cause of such variances. The variable factory overhead was expected at \$157,500 (105,000 units x \$1.50 per unit = \$157,500), but actually only cost \$155,000. Fixed factory overhead was \$5,000 less than anticipated.

## Flexible Budget for Performance Evaluations

The flexible budget responds to changes in activity, and may provide a better tool for performance evaluation. It is driven by the expected cost behavior. Fixed factory overhead is the same no matter the activity level, and variable costs are a direct function of observed activity. When performance evaluation is based on a static budget, there is little incentive to drive sales and production above anticipated levels because increases in volume tend to produce more costs and unfavorable variances. The flexible budget-based performance evaluation provides a remedy for this phenomenon.

## Flexible Budgets for Planning

The flexible budget illustration for Mooster's Dairy was prepared after actual production was known. While this tool is useful for performance evaluation, it does little to aid advance planning. But, flexible budgets can also be useful planning tools if prepared in advance. For instance, Mooster's Dairy might anticipate alternative volumes based on temperature-related fluctuations in customer demand for ice cream. These fluctuations will be very important to production management as they plan daily staffing and purchases of milk and cream that will be needed to support the manufacturing operation. As a result, Mooster's Dairy might prepare an advance flexible budget based on many different scenarios:

 MOOSTER'S DAIRY - Static Budget/Expense Analysis For the Month Ending July 31, 20X9 Budget Budget Budget Budget Budget (80,000 units) (90,000 units) (100,000 units) (110,000 units) (120,000 units) Notes Variable Expenses Direct materials \$ 80,000 \$ 90,000 \$ 100,000 \$ 110,000 \$ 120,000 \$1.00 per unit Direct labor 40,000 45,000 50,000 55,000 60,000 \$0.50 per unit Variable factory overhead 120,000 135,000 150,000 165,000 180,000 \$1.50 per unit Total Variable Expenses Fixed Factory Overhead Total Manufacturing Costs \$ 240,000 \$ 270,000 \$ 300,000 \$ 330,000 \$ 360,000 \$ 205,000 \$ 205,000 \$ 205,000 \$ 205,000 \$ 205,000 \$ 445 000 \$ 475 000 \$ 505 000 \$ 535 000 \$ 565 000

The above flexible budget reveals only the aggregate expense levels expected to be generated. In reality, supporting flexible budget documents would resemble the comprehensive budget documents portrayed in the prior chapter. Such comprehensive documents would provide the information necessary to manage the smallest of operating details that must be adjusted as production volumes fluctuate.

## Flexible Budgets and Efficiency of Operation

It perhaps goes without saying that computers are most helpful in preparing budget information that is easily flexed for changes in volume. Indeed, even the preparation of the very simple illustrative information for Mooster's Dairy was aided by an electronic spreadsheet. Businesses save millions upon millions of dollars in accounting time by relying on computers to aid budget preparation.

But, this savings is inconsequential when compared to the real savings that results from using computerized flexible budgeting tools. As production volumes ramp up and down to meet customer demand, computerized flexible budgets are adjusted on a real-time basis to send signals throughout the modern organization (including electronic data interchange with suppliers). The net result is that the supply chain is immediately adjusted to match raw material orders to real production levels, thereby eliminating billions and billions of dollars of raw material waste and scrap.

 Related topics