CC C C: Y$Y # Yyy Yy Yy
CC C C: Y$Y # Yyy Yy Yy
CC C C: Y$Y # Yyy Yy Yy
factory should have spent to make 10,000 units, not to what the factory should have spent to make 9,000 units or 11,000 units or any other production level. The flexible budget variance is the difference between any line-item in the flexible budget and the corresponding line-item from the statement of actual results. The following steps are used to prepare a flexible budget: 1. Determine the budgeted variable cost per unit of output. Also determine the budgeted sales price per unit of output, if the entity to which the budget applies generates revenue (e.g., the retailer or the hospital). Determine the budgeted level of fixed costs. Determine the actual volume of output achieved (e.g., units produced for a factory, units sold for a retailer, patient days for a hospital). Build the flexible budget based on the budgeted cost information from steps 1 and 2, and the actual volume of output from step 3.
2. 3.
4.
Flexible budgets are prepared at the end of the period, when actual output is known. However, the same steps described above for creating the flexible budget can be used prior to the start of the period to anticipate costs and revenues for any projected level of output, where the projected level of output is incorporated at step 3. If these steps are applied to various anticipated levels of output, the analysis is called pro forma analysis. Pro forma analysis is useful for planning purposes. For example, if next years sales are double this years sales, what will be the companys cash, materials, and labor requirements in order to meet production needs?
Pro Forma Analysis at Guess Who Jeans: Following are pro forma monthly income statements for Guess Who Jeans, a small, start-up fashion jeans manufacturer. The pro forma analysis was prepared at the beginning of the month and considered three alternative sales levels. The company has no variable marketing costs.
GUESS WHO JEANS PRO FORMA ANALYSIS FOR THE UPCOMING MONTH
Income Statement line-item Revenue Variable costs: Materials Labor Overhead Total Contribution margin Fixed costs: Manufacturing Overhead Marketing costs Total fixed costs Operating income Budgeted amount per unit $40 Pro Forma Analysis for Alternative Output Levels 10,000 units $400,000 20,000 units $800,000 30,000 units $1,200,000
15 10 5 30 $10
Since by definition, fixed costs are not expected to change as volume of output changes within the relevant range, fixed costs remain the same at all three projected levels of output. Revenue and variable costs vary with output in a linear fashion. Hence, when output increases 100% from 10,000 units to 20,000 units, revenue, each line-item for variable costs, and contribution margin all increase 100%.
Static Budget Variance at Guess Who Jeans: Guess Who management decides that 10,000 units is the most likely output volume, and sets the static budget based on this sales and production level. After the end of the month, company personnel prepare the following table, showing the static budget, actual results, and the static budget variance.
GUESS WHO JEANS STATIC BUDGET VARIANCE FOR THE MONTH JUST ENDED
Income Statement line-item Revenue Variable costs: Materials Labor Overhead Total Contribution margin Fixed costs: Manufacturing Overhead Marketing costs Total fixed costs Operating income Budgeted amount per unit $40 Static Budget (A) 10,000 units $400,000 Actual Results (B) 16,000 units $670,000 Static Budget Variance (A) (B) $270,000
15 10 5 30 $10
In the variance column, positive numbers are favorable variances (good news), and negative numbers are unfavorable (bad news). The static budget variance shows a large favorable variance for revenue, and large unfavorable variances for variable costs. These large variances are due primarily to the fact that the static budget was built on an output level of 10,000 units, while the company actually made and sold 16,000 units. The revenue variance might also be due to an average unit sales price that differed from budget. The variable cost variances might also be due to input prices that differed from budget (e.g., the price of fabric), or input quantities that differed from the per-unit budgeted amounts (e.g., yards of fabric per pair of pants). There are also small variances for fixed costs. These costs should not vary with the level of output (at least within the relevant range). However, many factors can cause actual fixed costs to differ from budgeted fixed costs that are unrelated to output volume. For example, property tax rates and the fixed salaries of front office personnel can change, and depreciation expense can change if unexpected capital acquisitions or dispositions occur.
The Flexible Budget Variance at Guess Who Jeans: In order to better understand the causes of the large revenue and variable cost variances in the static budget variance column, Guess Who personnel prepare the following flexible budget.
GUESS WHO JEANS FLEXIBLE BUDGET VARIANCE FOR THE MONTH JUST ENDED
Income Statement line-item Revenue Budgeted amount per unit Flexible Budget (A) 16,000 units Actual Results (B) 16,000 units Flexible Budget Variance (A) (B)