7.4 Prepare Flexible Budgets

Flexible Budgets

flexible budget is one based on different volumes of sales. A flexible budget flexes the static budget for each anticipated level of production. This flexibility allows management to estimate what the budgeted numbers would look like at various levels of sales. Flexible budgets are prepared at each analysis period (usually monthly), rather than in advance, since the idea is to compare the operating income to the expenses deemed appropriate at the actual production level.

Big Bad Bikes is planning to use a flexible budget when they begin making trainers. The company knows its variable costs per unit and knows it is introducing its new product to the marketplace. Its estimations of sales and sales price will likely change as the product takes hold and customers purchase it. Big Bad Bikes developed a flexible budget that shows the change in income and expenses as the number of units changes. It also looked at the effect a change in price would have if the number of units remained the same. The expenses that do not change are the fixed expenses, as shown in Figure 7.23.


BIG BAD BIKES
Flexible Budget
For Year Ended December 31, 2019
Units Sold
1,000 1,500 1,500
Sales Price
$70 $70 $75
Sales
$70,000 $105,000 $112,500

Per-unit cost
Cost of Goods Sold



Direct Material $4 $4,000 $6,000 $6,000
Direct Labor 15 15,000 22,500 22,500
Variable Manufacturing Overhead 3 3,000 4,500 4,500
Fixed Manufacturing Overhead
29,000 29,000 29,000
Total Cost of Goods Sold
51,000 62,000 62,000
Gross Profit
19,000 43,000 50,500
Variable Sales and Admin 2.50 2,500 3,750 3,750
Fixed Sales and Admin
18,000 18,000 18,000
Income Taxes
1,000 1,000 1,000
Total Other Expenses
21,500 22,750 22,750
Net Income (Loss)
$(2,500) $20,250 $27,750
Figure 7.23 Flexible Budget for Big Bad Bikes.