13.2 Variance, Forecasting, and Budgeting

Budgeting and Forecasting in BAR

BAR treats budgeting and forecasting as decision tools, not arithmetic drills. The AICPA 2026 Blueprint expects candidates to transform data, prepare budgets using supportable assumptions, model financial results, and analyze forecasts with ratios and explanations. In a simulation, that may mean using a sales pipeline, prior-year costs, commodity price data, headcount plans, or management assumptions to build a forecast and then defend the result.

Budget Versus Forecast Versus Projection

A budget is management's approved operating and financial plan for a period. A forecast updates expected results based on current information and the entity's best estimate of conditions it expects to exist. A projection models results under one or more hypothetical assumptions, such as a new product launch, a debt refinancing, or expansion into another market. On BAR, read the wording carefully because the purpose dictates which assumptions are appropriate.

Data Transformation Comes First

Forecasting tasks often include imperfect data. Before modeling, decide whether data must be cleaned, grouped, or transformed. Sales data may need to be summarized by product line, customer type, region, or contract term. Expense data may need to be split into fixed and variable components using the high-low method or regression. Unstructured data such as customer comments or service tickets may need to be categorized before it can support assumptions about churn or warranty cost.

Variance Analysis That Explains Causes

A variance is the difference between actual results and a benchmark such as budget, standard, forecast, or prior period. BAR expects you to pick the right variance method for the scenario and then explain the cause.

• Price variance: Did the entity sell or buy at a price different from expected? (actual price − standard price) × actual quantity.
• Volume variance: Did activity differ from the planned level?
• Mix variance: Did the entity sell a different proportion of high-margin and low-margin products?
• Efficiency (quantity) variance: Did labor or materials usage differ from the standard input level? (actual quantity − standard quantity) × standard price.
• Spending variance: Did cost per input or fixed spending differ from budget?

Worked example: a manufacturer reports an unfavorable materials spending variance because steel prices rose 6%, while reporting a favorable efficiency variance because scrap fell. The net variance matters, but the separate causes drive the management action: renegotiate supply contracts versus invest further in scrap reduction.

Planning Techniques

BAR can test cost-benefit analysis, sensitivity analysis, what-if scenarios, breakeven analysis, and predictive analytics. Sensitivity analysis changes one assumption at a time to find which assumption drives results. What-if modeling combines several assumption changes simultaneously. Breakeven analysis identifies the activity level where contribution margin covers fixed costs; breakeven units = fixed costs ÷ contribution margin per unit. Predictive analytics uses historical data to estimate future patterns.

Interpreting Forecast Results

A forecast is not finished when the spreadsheet balances. Interpret it with profitability, liquidity, solvency, and activity ratios. If projected revenue growth requires a large jump in inventory and receivables, cash flow can weaken even when projected income improves. If a projection assumes a lower defect rate, tie that assumption to evidence such as recent process improvements, not optimism.

A strong BAR conclusion names the assumption, quantifies the effect, and states the implication: "The forecast meets the EBITDA target only if unit sales grow at least 8% and material-cost inflation stays below 3%; otherwise the loan-covenant cushion falls below management's threshold."

Building a Cash Budget

Many BAR simulations ask you to assemble a cash budget, which is distinct from the budgeted income statement because it tracks the timing of cash receipts and disbursements rather than accrual revenue and expense. The structure is predictable: beginning cash, plus expected cash collections, less cash disbursements for purchases, payroll, overhead, capital expenditures, debt service, and taxes, equals the ending cash balance before financing.

A common requirement is a collections schedule that lags sales: for example, if 60% of sales are collected in the month of sale, 30% the following month, and 10% the month after, you must spread each month's sales across three collection periods. The same lag logic applies to paying suppliers on net-30 or net-60 terms. Candidates lose points by forgetting that a sale recorded in the income statement may not become cash for one to three months.

After computing ending cash before financing, compare it to a required minimum balance. If projected cash falls below the minimum, the budget must show borrowing on a line of credit; if it rises well above the minimum, the budget should show repayment or short-term investment. This is where forecasting connects to the financing themes in Section 13.4: a forecast that looks profitable on the income statement can still require a credit line draw in peak working-capital months, and the cash budget is what reveals that need before it becomes a crisis.