Study guides / BAR: Business Analysis & Reporting / Budgeting & forecasting
Budgeting & forecasting
BAR: Business Analysis & Reporting · quick review
The master budget runs from sales to production, purchases, cash and the budgeted statements. Flexible budgets and variance analysis compare actual results with what activity should have cost.
The rules
- Sales budget drives everything. Production = sales + desired ending finished goods − beginning finished goods.
- Materials purchases = production needs + desired ending materials − beginning materials.
- Cash collections apply collection patterns to each month's sales. Uncollectible amounts never become cash.
- Flexible budget = fixed costs + variable rate × actual activity. Flexible budget variance = actual − flexible budget. Sales-volume variance = flexible budget − static budget.
- Forecasting tools: regression (the coefficient of determination R² measures fit), trend analysis, and scenario and sensitivity analysis.
Formulas
- Units to produce: Budgeted sales + Desired ending inventory − Beginning inventory
- Flexible budget cost: Budgeted fixed costs + (Variable cost per unit × Actual units)
Common traps
- Comparing actual costs with a static budget mixes volume effects with spending effects.
- Depreciation is in the operating budget but not the cash budget.
- In a regression, a high R² shows association, not causation.
How it's tested
Prepare budget schedules, compute flexible budget and volume variances, and interpret forecasts. Expect numeric-entry simulations.
Practise it
The full lesson, worked examples and practice questions are in Tickmark, where every answer choice is explained.
Open the full lesson