CPA Business Analysis & Reporting (BAR) • Budgeting, Planning, And Control

Prepare Operating And Financial Budgets

Master the systematic construction of operating and financial budgets that drive organizational planning and control.

A certification badge with calculator and balance symbols for CPA preparation
Inside this lesson 9 sections 5 questions 10 figures

SECTION 1

Historical Context & Motivation

The practice of budgeting is as old as organized commerce itself, yet the formalized systems of operating and financial budgets that dominate modern corporate planning are products of the twentieth century. As industrial firms grew in scale and complexity during the early 1900s, ad hoc spending plans proved wholly inadequate for coordinating production, procurement, and capital deployment. Managers needed a disciplined quantitative framework that could translate strategic objectives into departmental action plans and cash-flow projections. The master budget—the comprehensive package of operating and financial budgets—emerged as the answer, becoming perhaps the most widely used managerial accounting tool in both the private and public sectors.

1919 • DuPont's ROI Framework

DuPont Corporation pioneered the use of return-on-investment analysis, which required forward-looking budgets to project divisional profitability and capital requirements—an early precursor to integrated budget systems.

1922 • McKinsey's 'Budgetary Control'

James O. McKinsey published Budgetary Control, one of the first treatises to argue that firms should prepare interlinked operating and financial budgets as a coordinated planning and control mechanism.

1950s • Flexible Budgeting Emerges

Post-war manufacturing volatility led academics and practitioners to develop flexible budgets that adjusted planned costs for actual activity levels, improving the performance-evaluation utility of budgets.

1970s • Zero-Based Budgeting

Peter Pyhrr's zero-based budgeting methodology gained prominence, requiring managers to justify every expenditure from a base of zero rather than merely adjusting prior-period amounts—sharpening the link between budgets and strategic priorities.

2000s–Present • Integrated Planning & ERP

Enterprise resource planning (ERP) systems and cloud-based tools enabled real-time, rolling budgets and scenario modeling, though the fundamental architecture of operating and financial budgets remains the CPA exam standard.

Despite decades of methodological innovation, the core question that operating and financial budgets address has never changed: How does a firm translate its strategic plan into a quantified, actionable set of schedules that coordinate revenue generation, resource consumption, and cash management across all functional areas? Answering this question is precisely what the CPA BAR section tests, and it is the focus of this lesson.

SECTION 2

Core Principles & Definitions

A master budget is the comprehensive financial plan for a given period—typically one fiscal year divided into quarters or months. It consists of two interlocking halves: the operating budget, which projects revenues and expenses culminating in a budgeted income statement, and the financial budget, which projects cash inflows and outflows, capital expenditures, and the budgeted balance sheet. These two halves are sequentially dependent: most financial budget schedules require inputs that flow from the operating budget. Understanding the architectural principles that govern their construction is essential before attempting the mechanics.

1

Goal Congruence

Every sub-budget must align with the organization's strategic objectives. The sales budget starts the process because revenue targets derive directly from the firm's competitive strategy and market analysis.
2

Sequential Dependency

Budgets are prepared in a strict sequence. The production budget depends on the sales budget; the direct materials budget depends on the production budget; and the cash budget depends on all operating budgets.
3

Behavioral Considerations

Budgets serve as performance benchmarks. Participative ('bottom-up') budgeting increases buy-in, while imposed ('top-down') budgets can create budgetary slack or dysfunctional gaming.
4

Control Through Variance Analysis

Once actual results are available, managers compare them to budgeted figures. Favorable and unfavorable variances pinpoint areas requiring corrective action, closing the planning-control loop.
5

Static vs. Flexible Budgets

A static budget is prepared for a single expected activity level. A flexible budget adjusts revenues and variable costs for actual activity, enabling more meaningful performance evaluation.

SECTION 3

Visual Explanation — The Master Budget Flowchart

MASTER BUDGET ARCHITECTUREOPERATING BUDGETSFINANCIAL BUDGETSSales BudgetProduction BudgetDirect MaterialsDirect LaborMfg. OverheadSelling & AdminCOGS BudgetBudgeted IncomeStatementCapital ExpendituresCash CollectionsCash DisbursementsCash BudgetBudgeted BalanceSheetCOMPLETE MASTER BUDGET
The master budget flowchart shows how the sales budget (top left) cascades into production and expense budgets, culminating in the budgeted income statement. That output, combined with capital expenditure plans and cash schedules, feeds the financial budgets on the right, ending with the budgeted balance sheet.

The diagram above captures the essential architecture of the master budget. Notice that every arrow flows downward and—crucially—to the right, reflecting the fact that operating budget outputs become financial budget inputs. The sales budget is the genesis schedule: once expected unit sales and selling prices are established, the production budget can determine how many units to manufacture, which in turn drives the direct materials purchases budget, the direct labor budget, and the manufacturing overhead budget. These individual cost budgets aggregate into the cost of goods sold (COGS) budget, and when combined with the selling and administrative expense budget and the sales budget, they produce the budgeted income statement. On the financial side, the cash budget synthesizes the timing of receipts and payments—information that originates in the operating budgets—to project the firm's liquidity position period by period.

SECTION 4

Mathematical Framework — Key Budget Equations

Each schedule in the master budget relies on straightforward but interconnected equations. Mastery of these formulas is essential for the CPA BAR exam, where candidates must construct or complete budget schedules under time pressure. Below are the core equations, presented in the sequence you would use them when building a master budget from scratch.

SALES BUDGET

BudgetedRevenue=ExpectedUnitSales×SellingPriceperUnitBudgeted Revenue = Expected Unit Sales × Selling Price per Unit

This schedule is prepared first. Unit sales forecasts may come from market research, historical trends, or management judgment. The total becomes the starting point for the entire master budget.

PRODUCTION BUDGET

UnitstoProduce=BudgetedSales(units)+DesiredEndingFGInventory−BeginningFGInventoryUnits to Produce = Budgeted Sales (units) + Desired Ending FG Inventory − Beginning FG Inventory

FG = Finished Goods. This equation ensures the firm produces enough to meet sales demand while maintaining target inventory levels. The desired ending inventory is typically stated as a percentage of next period's budgeted sales.

DIRECT MATERIALS PURCHASES BUDGET

Purchases(units)=ProductionNeeds+DesiredEndingRMInventory−BeginningRMInventoryPurchases (units) = Production Needs + Desired Ending RM Inventory − Beginning RM Inventory

RM = Raw Materials. Production needs = Units to Produce × Material per Unit. The total cost of purchases equals Purchases (units) × Cost per Unit of material.

CASH BUDGET (RECEIPTS SIDE)

CashReceipts=CashSales+CollectionsfromCreditSalesofCurrentPeriod+CollectionsfromPrior−PeriodReceivablesCash Receipts = Cash Sales + Collections from Credit Sales of Current Period + Collections from Prior-Period Receivables

Credit collection patterns (e.g., 60% in the month of sale, 35% the following month, 5% uncollectible) are typically provided in the problem. Accuracy here is critical because the cash budget determines whether borrowing is needed.

CASH BUDGET (NET)

EndingCash=BeginningCash+TotalCashReceipts−TotalCashDisbursements±FinancingEnding Cash = Beginning Cash + Total Cash Receipts − Total Cash Disbursements ± Financing

If the ending cash balance before financing falls below the minimum required balance, the firm borrows. If it exceeds the minimum by enough to repay borrowings, repayments (plus interest) are made.

SECTION 5

Detailed Breakdown — Operating vs. Financial Budget Components

While the flowchart in Section 3 provided the high-level architecture, a deeper understanding requires examining each budget component's purpose, key inputs, and outputs. The following table organizes every schedule in the master budget, identifies whether it belongs to the operating or financial half, and highlights the data dependencies that CPA exam questions frequently test.

Budget ScheduleCategoryKey InputsKey Output
Sales BudgetOperatingMarket forecast, pricing strategyBudgeted revenue; unit sales by period
Production BudgetOperatingUnit sales, inventory policyUnits to produce by period
Direct Materials PurchasesOperatingProduction units, material per unit, RM inventory policyPounds/units and $ of materials to purchase
Direct Labor BudgetOperatingProduction units, labor hours per unit, wage rateTotal labor hours and cost
Manufacturing OverheadOperatingActivity base (e.g., DLH), OH rate (variable + fixed)Total overhead cost; cash vs. non-cash (depreciation)
Selling & Admin ExpenseOperatingUnit sales, variable S&A per unit, fixed S&ATotal S&A expense; cash vs. non-cash
Budgeted Income StatementOperatingSales, COGS, S&A expense budgetsNet income (or loss) for the budget period
Capital Expenditure BudgetFinancialStrategic plan, capacity analysisPlanned CapEx outlays by period
Cash BudgetFinancialAll operating budgets, collection/payment patterns, CapExEnding cash balance; borrowing/repayment needs
Budgeted Balance SheetFinancialAll prior budgets, beginning balance sheetProjected financial position at period end

Master Budget Components and Their Sequential Dependencies

OPERATING vs. FINANCIAL BUDGET — DATA FLOWOPERATING BUDGETSales Budget → RevenueProduction Budget → UnitsDM + DL + OH → Mfg. CostS&A Expense BudgetBudgeted Income StatementOutputs: Revenue, COGS,Gross Profit, OpEx, Net IncomeFINANCIAL BUDGETCapital Expenditure BudgetCash Receipts ScheduleCash Disbursements ScheduleCash BudgetBudgeted Balance SheetOutputs: Ending Cash, A/R,Inventory, PPE, Liabilities, Equityfeeds
This side-by-side view emphasizes the dividing line between operating and financial budgets. Dashed arrows show how the budgeted income statement's outputs—revenue timing, cost timing, and net income—feed the financial budget's cash schedules and balance sheet projections.
ℹ
CPA EXAM TIP

SECTION 6

Worked Example — Building a Master Budget

Apex Manufacturing produces a single product—the Widget-X. The company is preparing its master budget for Q1 of the upcoming year (January through March). The following data have been gathered. Work through this comprehensive example to see how every budget schedule connects.

ℹ
GIVEN DATA

Worked example

  1. 1

    Step 1 — Sales Budget

    Multiply expected unit sales by the selling price for each month. January: 10,000 × $25 = $250,000. February: 12,000 × $25 = $300,000. March: 15,000 × $25 = $375,000.
    Total Q1 Budgeted Revenue = $925,000
  2. 2

    Step 2 — Production Budget

    For each month, apply: Units to Produce = Budgeted Sales + Desired Ending FG − Beginning FG. January: 10,000 + (20% × 12,000) − 2,000 = 10,000 + 2,400 − 2,000 = 10,400 units. February: 12,000 + (20% × 15,000) − 2,400 = 12,000 + 3,000 − 2,400 = 12,600 units. March: 15,000 + (20% × 14,000) − 3,000 = 15,000 + 2,800 − 3,000 = 14,800 units.
    Q1 Production: Jan 10,400 | Feb 12,600 | Mar 14,800 = 37,800 units
  3. 3

    Step 3 — Direct Materials Purchases Budget

    Production needs in lbs = Units to Produce × 3 lbs. January: Needs = 10,400 × 3 = 31,200 lbs. Desired ending RM = 10% × (12,600 × 3) = 3,780 lbs. Purchases = 31,200 + 3,780 − 3,120 = 31,860 lbs × $2 = $63,720. February: Needs = 37,800 lbs. Ending RM = 10% × (14,800 × 3) = 4,440. Purchases = 37,800 + 4,440 − 3,780 = 38,460 lbs × $2 = $76,920. March: Needs = 44,400 lbs. Assume desired ending RM for April requires an April production estimate; if April production is approximately 14,000 units (we'll use a simplifying assumption that desired ending RM = 4,200 lbs). Purchases = 44,400 + 4,200 − 4,440 = 44,160 lbs × $2 = $88,320.
    Q1 Material Purchases: $63,720 + $76,920 + $88,320 = $228,960
  4. 4

    Step 4 — Direct Labor Budget

    DL Cost = Units to Produce × 0.5 hrs × $16/hr. Jan: 10,400 × 0.5 × $16 = $83,200. Feb: 12,600 × 0.5 × $16 = $100,800. Mar: 14,800 × 0.5 × $16 = $118,400.
    Q1 Direct Labor Cost = $302,400
  5. 5

    Step 5 — Manufacturing Overhead Budget

    Variable OH = Units Produced × $3. Fixed OH = $20,000/month. Jan: (10,400 × $3) + $20,000 = $51,200. Feb: (12,600 × $3) + $20,000 = $57,800. Mar: (14,800 × $3) + $20,000 = $64,400. Cash OH = Total OH − Depreciation ($5,000/month).
    Q1 Total OH = $173,400; Cash OH = $173,400 − $15,000 = $158,400
  6. 6

    Step 6 — Budgeted Income Statement

    Revenue: $925,000. COGS requires computing per-unit manufacturing cost. Per-unit cost = DM ($6) + DL ($8) + Variable OH ($3) = $17 variable manufacturing cost. Add allocated fixed OH per unit: $60,000 ÷ 37,800 ≈ $1.59/unit. Total mfg cost/unit ≈ $18.59. COGS = 37,000 units sold × $18.59 ≈ $687,830 (approximation; in practice, use actual schedule totals). Alternatively, COGS = Beginning FG cost + Manufacturing costs incurred − Ending FG cost. For simplicity: Total Mfg Cost = DM used ($226,800) + DL ($302,400) + OH ($173,400) = $702,600. Beginning FG at cost (2,000 × estimated $18.59) ≈ $37,180. Ending FG (2,800 × $18.59) ≈ $52,052. COGS ≈ $37,180 + $702,600 − $52,052 = $687,728. Gross Profit ≈ $925,000 − $687,728 = $237,272. S&A: Variable (37,000 × $1 = $37,000) + Fixed ($30,000) = $67,000. Operating Income ≈ $237,272 − $67,000 = $170,272.
    Q1 Budgeted Operating Income ≈ $170,272

This worked example demonstrates how each schedule's output becomes the next schedule's input. Notice that if January's sales forecast were revised upward by 1,000 units, the change would ripple through every subsequent budget—production, materials, labor, overhead, and ultimately the income statement and cash budget. This cascading effect is precisely why the sequential dependency principle is so fundamental to budget preparation.

SECTION 7

Strengths, Limitations, and Comparisons

No planning tool is without trade-offs, and the master budget is no exception. Understanding both its strengths and limitations is essential not only for the CPA exam but for real-world managerial effectiveness. The table below contrasts the advantages and disadvantages of traditional static budgets, then highlights how alternative approaches attempt to mitigate the weaknesses.

StrengthsLimitations
Provides a comprehensive, coordinated plan that aligns all departments toward common targets.Assumes a single level of activity—actual volumes may differ significantly, making variance analysis misleading.
Facilitates resource allocation by quantifying expected needs for materials, labor, and cash.Can be time-consuming and expensive to prepare, especially for large, diversified organizations.
Establishes benchmarks for performance evaluation through variance analysis.May encourage budgetary slack—managers padding estimates to make targets easier to achieve.
Forces management to think ahead, identifying potential bottlenecks and financing needs before they arise.Becomes stale quickly in volatile environments if not supplemented with rolling forecasts.
The cash budget specifically helps prevent liquidity crises by forecasting borrowing needs.Over-emphasis on meeting budget targets can lead to short-term thinking and dysfunctional behavior (e.g., deferring maintenance).

Strengths and Limitations of the Traditional Master Budget

★

Key takeaway

PRACTICAL PERSPECTIVE

SECTION 8

Connection to Advanced Theory — Beyond the Static Budget

The static master budget taught in this lesson is the foundational framework, but contemporary management accounting extends these concepts in several important directions. On the CPA BAR exam, you may encounter questions that bridge basic budget preparation with more sophisticated techniques. The table below maps each traditional budget concept to its advanced counterpart, helping you see where this lesson fits within the broader discipline of planning and control.

Traditional ConceptAdvanced ExtensionKey Difference
Static (Master) BudgetFlexible BudgetAdjusts budgeted amounts for actual activity level, enabling isolation of spending (efficiency) variances from volume variances.
Annual Budget CycleRolling (Continuous) BudgetPerpetually extends the planning horizon—when January actuals are recorded, January of the next year is added.
Incremental BudgetingZero-Based Budgeting (ZBB)Requires managers to justify every expense from zero each period rather than adjusting prior-year figures.
Volume-Based OH AllocationActivity-Based Budgeting (ABB)Budgets overhead using cost drivers identified through ABC, improving cost accuracy for diverse product portfolios.
Deterministic BudgetProbabilistic / Scenario BudgetingIncorporates probability distributions and Monte Carlo simulation to generate ranges of outcomes rather than point estimates.

Traditional vs. Advanced Budget Concepts

For the CPA BAR section, your primary task is to demonstrate competence in preparing and interpreting the traditional master budget. However, be prepared for conceptual questions about flexible budgets and variance analysis, as these topics frequently appear in tandem with budget preparation. A solid grasp of the static budget structure makes the transition to flexible budgets straightforward: you simply replace the single budgeted activity level with the actual activity level and recompute all variable cost line items, leaving fixed costs unchanged.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

The following is a partially completed master budget sequence chart. For each budget listed in Column A, use the drop-down in Column B to select whether it is prepared BEFORE or AFTER the sales budget is finalized. Then, in Column C, select the correct direct input that budget relies upon.Column B choices (each row): Before | AfterColumn C choices (each row): Sales Budget | Production Budget | Direct Materials & Labor & Overhead Budgets | All Operating Budgets Combined
Show answer
Correct completed table:Step-by-step verification:Step 1 — Sales Budget (prepared FIRST): Establishes budgeted unit sales and budgeted revenue. Every downstream budget requires this figure as its ultimate starting point. Without finalized unit sales, no production quantity can be correctly determined.Step 2 — Production Budget (After | Input: Sales Budget): Formula: Units to Produce = Budgeted Unit Sales + Desired Ending Finished Goods Inventory − Beginning Finished Goods Inventory. Directly requires the sales budget unit figure. Cannot be completed before sales budget is finalized.Step 3 — Direct Materials Budget (After | Input: Production Budget): Formula: Materials to Purchase = (Units to Produce × Materials per Unit) + Desired Ending Materials Inventory − Beginning Materials Inventory. Requires units to produce from the production budget, which itself requires the sales budget.Step 4 — Direct Labor Budget (After | Input: Production Budget): Formula: Budgeted Labor Cost = Units to Produce × Direct Labor Hours per Unit × Hourly Rate. Requires units to produce from the production budget.Step 5 — Manufacturing Overhead Budget (After | Input: Production Budget): Variable and fixed overhead are applied based on units to produce and/or labor hours derived from the production budget.Step 6 — Cash Budget (After | Input: All Operating Budgets Combined): Aggregates cash inflows from the sales budget and cash outflows from materials purchases, labor costs, overhead costs, and selling & administrative expenses. It is the last operating budget prepared before the budgeted financial statements and requires all prior budgets to be complete.Key Conclusion: Every budget in the master budget is prepared AFTER the sales budget. The sales budget is the keystone input — an error in it cascades forward, invalidating production quantities, materials purchases, labor schedules, overhead allocations, and ultimately the entire cash budget and pro forma financial statements.

Question 2: BASIC CALCULATION

Bravo Corp. expects to sell 8,000 units in May and 10,000 units in June. The desired ending finished goods inventory each month is 15% of the following month's sales. Beginning FG inventory on May 1 is 1,200 units. July sales are estimated at 9,000 units. How many units must Bravo produce in May and June?
Show answer
Apply the production budget equation for each month. May: Units to Produce = 8,000 + (15% × 10,000) − 1,200 = 8,000 + 1,500 − 1,200 = 8,300 units. June: Units to Produce = 10,000 + (15% × 9,000) − 1,500 = 10,000 + 1,350 − 1,500 = 9,850 units. Note that the beginning FG for June is the ending FG from May (1,500 units), and the ending FG for June is based on July's forecast. This problem illustrates the rolling nature of inventory policy assumptions across periods.

Question 3: INTERMEDIATE

Charlie Inc. produces widgets requiring 4 lbs of raw material per unit at $3/lb. For March, budgeted production is 6,000 units. Desired ending raw material inventory is 10% of the next month's production needs. April budgeted production is 7,500 units. Beginning raw material inventory on March 1 is 2,600 lbs. Calculate (a) the total raw material purchases in pounds for March, and (b) the total dollar cost of those purchases.
Show answer
First, compute March production material needs: 6,000 × 4 = 24,000 lbs. Next, compute desired ending RM inventory: 10% × (7,500 × 4) = 10% × 30,000 = 3,000 lbs. Apply the purchases equation: Purchases = 24,000 + 3,000 − 2,600 = 24,400 lbs. The dollar cost = 24,400 × $3 = $73,200. This problem tests the ability to chain the production budget into the materials purchases budget. A common error is forgetting to convert April's production into pounds before computing the desired ending inventory—always multiply units by the material requirement per unit first.

Question 4: APPLIED

Delta Manufacturing budgets the following for Q2: Total Sales $500,000 (all on credit); collection pattern: 70% in the month of sale, 25% in the following month, 5% uncollectible. April A/R balance from March sales: $45,000 (all expected to be collected in April). Cash disbursements for April: $160,000. Beginning cash balance April 1: $30,000. Minimum required cash balance: $25,000. Prepare the cash budget for April only, determining whether Delta needs to borrow. April sales are $150,000.
Show answer
Cash receipts for April: Collections from April sales = 70% × $150,000 = $105,000. Collections from March A/R = $45,000. Total receipts = $150,000. Cash available = Beginning cash $30,000 + Receipts $150,000 = $180,000. Less disbursements: $160,000. Ending cash before financing = $180,000 − $160,000 = $20,000. Since the minimum required balance is $25,000, Delta must borrow at least $5,000. After borrowing $5,000, ending cash = $25,000. This problem integrates the operating budget output (sales revenue and its timing) with the financial budget (cash collections and minimum balance constraint). In practice, Delta might borrow a round number like $10,000 to provide a cushion.

Question 5: CRITICAL THINKING

Echo Corp.'s budget committee is debating two approaches for the upcoming fiscal year: (1) a traditional static master budget or (2) a flexible budget with quarterly rolling updates. The CFO argues that the static budget is sufficient because the company operates in a stable industry with predictable demand. The VP of Operations counters that even in stable industries, input prices fluctuate enough to make static budgets misleading for performance evaluation. Evaluate both positions. Under what specific conditions would you recommend each approach, and how does the choice affect variance analysis?
Show answer
The CFO's position has merit: in stable industries where volume variance is minimal, a static budget provides an adequate planning benchmark and is less costly to maintain. If actual sales closely match budgeted sales, the static budget's performance benchmarks remain valid, and volume-related distortions are small. However, the VP of Operations raises a legitimate concern: even when volume is stable, changes in material prices, wage rates, or overhead spending can generate variances that the static budget cannot properly decompose. A flexible budget isolates the spending variance (actual cost minus flexible budget cost at actual volume) from the volume variance (flexible budget minus static budget), enabling more precise accountability. The recommended approach depends on (a) the materiality of expected volume deviations—if demand can swing ±15%, a flexible budget is essential; (b) the cost of updating—rolling budgets require robust information systems; and (c) the behavioral culture—if managers are evaluated strictly on static budget targets, they may game the system. An optimal compromise is to prepare a static master budget for planning and cash management but evaluate operating managers using flexible budget variances. This dual approach leverages the strengths of both methodologies while mitigating their individual weaknesses.

Varsity Tutors • CPA (BAR) • Prepare Operating And Financial Budgets