The flexible budget uses the same selling price and cost assumptions as the original budget. The variable amounts are recalculated using the actual level of activity, which in the case of the income statement is sales units. What is not known from looking at it is why the variances occurred. To use flexible budgets for variance analysis effectively, managers and employees should establish clear and realistic goals and standards for the flexible budget and communicate them to all relevant parties. It’s important to update and revise the flexible budget regularly and compare it with the actual results and the fixed or static budget. Variance analysis should include a detailed analysis of each variance, as well as identifying the factors and responsibilities for each.

Most revenues are considered variable so only costs are discussed in the following category descriptions. Taking a flexible approach to budgeting typically doesn’t mean you get a free pass when it comes to more traditional, static budgeting. In fact, the static budget is essential for establishing a baseline to measure performance and results and ultimately for calculating the variances that do occur throughout the year. Although the budget report shows variances, it does not explain the reasons for the variance. The budget report is used by management to identify the sales or expenses whose amounts are not what were expected so management can find out why the variances occurred. By understanding the variances, management can decide whether any action is needed.

Flexible Budgets Could Flex for Various Activities

For example, Figure 7.24 shows a static quarterly budget for 1,500 trainers sold by Big Bad Bikes. If the company performs well and reaches an above-target performance, it will have a favorable variance of $90,625. Though powerful anytime, you can imagine how useful this capability would be now, with so much disruption to normal course of business activity.

A static budget helps to monitor expenses, sales, and revenue, which helps organizations achieve optimal financial performance. By keeping each department or division within budget, companies can remain on track with their long-term financial goals. A static budget serves as a guide or map for the overall direction of the company. The March planning budget and flexible budget for Wanda’s furniture repair shop, ReStore, were prepared in the first two practice video problems. The cost formula for a variable cost is the cost per unit times the quantity driving the cost, usually sales or production. Shipping is a variable cost since it is always $4 per unit but the total depends on how many units are sold.

Budget with Varying Levels of Production

The March planning budget for Wanda’s furniture repair shop, ReStore, was prepared in the first practice video problem. On April 1st the actual results for the month of March were available. She originally planned to repair 120 pieces https://online-accounting.net/ of furniture during March but she actually repaired 145 pieces of furniture. Using the revenue and cost formulas for the shop, prepare a flexible budget for March. Wanda Wallace owns ReStore a furniture repair and restoration shop.

The company offers sales incentives to their sales force of 5% of sales. Taking a flexible approach to budgeting typically doesn’t mean you get a free pass when it comes to more traditional, static budgeting. Thereafter, prepare a flexible budget for single or multiple activity levels. For example, under a static budget, a company would set an anticipated expense, say $30,000 for a marketing campaign, for the duration of the period.

How do flexible budgets work for variance analysis?

Also, temporary staff or additional employees needed for overtime during busy times are best budgeted using a flexible budget versus a static one. For income items (revenue, contribution margin and operating income in this example), the flexible budget variance is favorable when actual numbers exceed flexible budget numbers and vice versa. For cost items, excess of flexible budget numbers over actual number means favorable variance and vice versa. The variance is the difference between the flexible budgeted performance and the actual performance. Identifying the variances do not necessarily tell us what is causing the issues, but highlights the issue so that management and the business can investigate the cause. A favourable variance is when revenue is higher than budgeted or expenses are lower than budgeted.

The reforecasted flexible budget adjusts revenue and expenditure targets to match the actual level of activity. Reforecasting enables the user to compare flexible budget targets to actual results and evaluate actual performance. A static budget is a budget that is fixed at the beginning of the period and does not change regardless of the actual level of activity or output. It is based on the estimated output and the budgeted costs per unit and in total. A static budget allows you to compare the actual results with the planned results, and to identify any sales or spending variances.

Static Budget Definition, Limitations, vs. a Flexible Budget

For example, a variance resulting in an increase in revenue would be considered favorable whereas a variance resulting from an increase in expenses would be considered unfavorable. For example, a flexible budget model is designed where the price per unit is expected to be $100. In the most recent month, 800 units are sold and the actual price per unit sold is $102. This means there is a favorable flexible budget variance related to revenue of $1,600 (calculated as 800 units x $2 per unit). In addition, the model contains an assumption that the cost of goods sold per unit will be $45. This means there is an unfavorable flexible budget variance related to the cost of goods sold of $4,000 (calculated as 800 units x $5 per unit).

• Flexible budget is budget typically in the form of an income statement that is adjustable to any level of activity such as units produced or units sold.
• Furthermore, it facilitates communication and coordination among different departments or functions by providing a common basis for performance measurement and feedback.
• We call this an unfavorable variance and will identify it with the letter U.

The new budget for sales commissions is $10,500 ($262,500 sales times 4%), and the new budget for delivery expense is $1,750 (17,500 units times 10%). These are added to the fixed costs of $12,500 to get the flexible budget amount of $24,750. In addition, variable costs increased by $57,600 overall because of some slight increases in actual variable manufacturing costs. Even though that is a positive number in our calculation, it is an unfavorable variance because it hurt the bottom line. It’s possible that during the year, since sales were robust, management chose to expand the selling, general, and administrative infrastructure (buying new equipment, doling out sales bonuses, etc.). The follow-up to this analysis would be to examine expense categories in more detail, using budget versus actual.

More articles on Cost Accounting

If a manager is only responsible for a department’s costs, to include all the manufacturing costs or net income for the company would not result in a fair evaluation of the manager’s performance. If, however, the manager is the Chief Executive what is equity method of accounting Officer, the entire income statement should be used in evaluating performance. Let’s say Green Company estimates their total production capacity to be 250,000 units. The direct material and labor costs per unit are $4.50 and $2.50 respectively.

• This helps you make more informed decisions if (or when) adjustments are needed.
• At the end of December, Vera wants to prepare a planning budgeted income statement for the upcoming month, January.
• Since opening approximately two years ago, the restaurant has received rave local reviews and was recently named the best Southern restaurant in the city.
• It spotlights for us where the issues may be – but we must evaluate whether the variance is significant (is it big enough to warrant investigation) and then conduct further analysis.

Static budgets are often used by non-profit, educational, and government organizations since they have been granted a specific amount of money to be allocated for a period. Yet other expenses have considerable chance of varying to one degree or another. For instance, staffing projections may be dependent on an expected long-term contract being finalized—or unexpected market conditions may result in a welcome spike in sales. If the company performs below targets and produces only 75% of the units they will produce an adverse variance of -$181,250. At first, you need to analyze the range under which the activity is expected to fluctuate. We saved more than $1 million on our spend in the first year and just recently identified an opportunity to save about $10,000 every month on recurring expenses with Planergy.