Cash Budgets

Profitable months can still run out of cash

Northwind closed Q2 with positive net income but tripped a working capital covenant. Tomato paste prepayments hit in May while grocery AR (accounts receivable, customer balances owed to Northwind) collected on 45-day terms. The cash budget maps when cash enters and leaves, separate from accrual profit.

Maria manages liquidity; Priya builds the cash schedule from operating budgets plus capital and financing plans.

Northwind Foods is a mid-size packaged foods manufacturer selling through grocery and food-service channels and the anchor company for ACC 102. Annual revenue is approximately $420M across 3 plants and 180 SKUs. CFO Maria Chen, VP Operations James Okoro, and Plant Controller Priya Shah rely on standard costing, contribution margin, and budget variance analysis to run Omaha (dry goods and granola (Plant 1)), Fresno (sauces and condiments (Plant 2)), and Columbus (frozen Heat & Eat meals (Plant 3)).

ACC 101 (Financial Accounting) taught GAAP external reporting: income statement COGS, inventory on the balance sheet, and audited totals. ACC 102 uses overlapping facts for internal decisions: product-level costs, contribution margin, budgets, and variances managers act on before GAAP closes the quarter.

Cash budget structure

Typical format: beginning cash + cash receipts − cash disbursements = ending cash, by month or week. Sections: operating (collections, materials, payroll), investing (capex), financing (borrowings, repayments).

From profit to cash: major reconciling items

Add back depreciation (~$420K/month illustrative). Subtract AR buildup, inventory investment, and timing gaps on AP (accounts payable, amounts Northwind owes suppliers). EBITDA ~$4.0M/month is a starting point, not cash.

Collections and payment assumptions

Collections pattern from AR aging: 78% of credit sales next month, remainder following. Club may pay faster; food-service slower. Cash budget uses channel-specific curves.

Minimum cash and covenants

Maria sets $15M minimum operating cash plus revolver availability. Loan covenants may cap net debt/EBITDA; cash budget forecasts covenant headroom monthly.

Link to master budget

Sales budget → AR collections. Materials purchases → AP disbursements. S&A → payroll and marketing cash. Capital budget → investing section.

March credit sales $28.5M (grocery-heavy). Beginning cash $18.2M. Collections per schedule above.

Part A: April collections from March sales

78% × $28.5M = $22.23M in April; remaining $6.27M in May.

Part B: April cash from February sales tail

Assume February tail $5.1M collected in April (22% of February credit sales). Total operating receipts ≈ $27.33M before current-month cash sales.

Part C: Disbursements stub

Paste purchases $6.1M (82% paid April), payroll $4.8M, other S&A $3.2M → $14.1M operating outflows plus capex $2.4M freezer milestone. Check: timing not P&L month ✓

Part D: Managerial read

Ending cash near $29M before debt paydown; Maria holds paste prepayment discussion to May week 2.

Q4 granola inventory build $4.3M accrual COGS delay: cash paid for oats in October, revenue ships November. Cash budget showed $3.8M outflow before AR collections caught up. Priya shortened build by one week to preserve covenant cushion.

March credit sales $30M. Collections: 75% in April, 25% in May. April cash collections from March sales? April payroll cash $5.2M; materials cash $7.4M; all other $2.1M. Beginning cash $20M. Ending cash before capex?

Solution

March sales collections in April = 0.75 × $30M = $22.5M. Disbursements = $5.2M + $7.4M + $2.1M = $14.7M. Ending = $20M + $22.5M − $14.7M = $27.8M. Check: exclude May 25% tail ✓

Key takeaways

• Cash budgets time receipts and disbursements; profit is accrual-based.
• AR and AP timing drive Northwind grocery versus club cash curves.
• Depreciation adds back to profit but never touched cash.
• Inventory and capex can drain cash while income looks strong.
• Maria pairs cash budget with covenant and minimum cash policies.

1. List three reconciling items from EBITDA to cash for Northwind.
2. Sketch channel-specific collection assumptions for one month.
3. Continue to Lesson 4: Flexible Budgets.

Cash Budgets in Northwind's operating cadence

Profit does not equal cash. Northwind's cash budget adds depreciation back, subtracts capital for line upgrades, tracks AR (accounts receivable) collections (grocery 45-day terms), and schedules AP (accounts payable) for commodities. A profitable quarter can still breach a loan covenant if tomato paste prepayments spike.

CFO Maria Chen, VP Operations James Okoro, and Plant Controller Priya Shah review master budgets, cash planning, and flexible forecasts in monthly plant controller meetings before data hardens into GAAP quarter-close. Priya Shah's team posts standard cost updates, volume variances, and mix effects to shared folders James Okoro's operators can action within 48 hours. Maria Chen uses the same underlying transactions ACC 101 will later classify for external statements, but managerial reports may show segment margin, transfer prices, and flexible budget comparisons not required in the 10-K (annual SEC filing).

Walk the arithmetic habit every controller expects. When cash budgets produces a rate, ratio, or variance, show the numerator definition, denominator definition, period, and plant scope. If Omaha and Columbus use different allocation bases, state why (machine intensity vs labor intensity). A single blended rate is simpler but can misprice SKUs; ABC (activity-based costing) fixes that complexity with more measurement cost.

Extended scenario: cross-plant read for Cash Budgets

Picture a Tuesday S&OP (sales and operations planning) review. Grocery sales beat forecast on NorthWind Granola 12oz by 6% while food-service sauce lagged. Contribution margin dollars rose roughly $71K on granola alone at $2.81 unit CM, but Fresno faced overtime on sauce kettles and Columbus cold storage approached 96% utilization. Cash Budgets is how leadership decides whether to pull forward Omaha oven maintenance, expedite tomato paste, or reprice a low-CM promotional pack.

Reconcile before recommending. Fixed manufacturing overhead budget $3.2M per month must be covered by portfolio CM after variable costs. At current granola CM ratio 56.3%, price cuts require explicit volume lift calculations; see Unit 3 CVP. Budget variances (Unit 4) will later decompose whether misses were volume, price, or efficiency.

Stakeholder tension is normal. James Okoro protects line reliability and food safety audits. Maria Chen protects covenant headroom and EPS (earnings per share) guidance. Commercial leads protect slotting and brand share. Cash Budgets gives shared vocabulary so debate targets assumptions (standard oat price, changeover minutes, transfer price) instead of personalities.

Mechanics checklist: Cash Budgets

Use the same checklist Priya posts on every analysis deck: (1) Cost object defined (SKU, job, plant, customer). (2) Time horizon labeled short-run vs long-run; capacity decisions differ. (3) Relevant costs isolated; sunk and allocated corporate charges scrutinized. (4) Denominator for any rate shown (machine hours, cases, labor dollars). (5) Check line ties detail to control totals within $1,000 unless immateriality policy says otherwise.

Spreadsheet replication: separate data (volumes, prices, hours) from formulas (rates, variances, CM). Color inputs blue; never embed hard-coded totals in CM formulas. Tie units × unit CM = total CM and fixed + variable = total manufacturing cost on every tab. Northwind rejects decks where margin percent disagrees with dollar CM due to mixed rounding.

For master budgets, cash planning, and flexible forecasts, link forward and back. Earlier cost classification lessons explain why a cost is fixed or indirect; later variance and decision lessons consume the same standard cost database. Breaking the chain (e.g., changing oat standard without updating budget and transfer price) creates silent contradictions across plants.

ACC 101 bridge and external reporting

Financial accounting in ACC 101 answered: what happened, in GAAP language, for outsiders? Managerial accounting answers: what should we do next quarter, with product and plant detail? Northwind's inventory on the balance sheet equals capitalized product cost; COGS on the income statement releases those costs when customers take title. Period costs (HQ, ads) never inventory.

Differences are legitimate. Managerial standard costs may differ from actual GAAP costs until variances close at period end. Overhead allocation choices for pricing can include discretionary marketing sub-pools excluded from inventory capitalization under GAAP. Maria insists teams label GAAP view vs managerial view on every slide to prevent audit committee confusion.

When cash budgets touches inventory or COGS, articulate the flow: beginning FG (finished goods) + COGM (cost of goods manufactured) − COGS = ending FG. Weighted-average process costing at Fresno must match pounds of sauce in tanks to financial pounds shipped.

Practice extension: self-check without peeking

Open a blank workbook tab. Row 1: write the Northwind decision Cash Budgets informs this month. Row 2: list three variable and three fixed costs for the relevant plant. Row 3: compute unit CM for NorthWind Granola 12oz at price $4.99 and variable $2.18. Row 4: state one relevant and one irrelevant cost for a hypothetical SKU drop decision. Row 5: define the check line you would show Maria.

Compare your rows to this lesson's worked examples. Gaps mark what to re-read. If you work outside manufacturing, map plant → team, SKU → product line, and OH → shared services; the logic survives.

Executive questions on Cash Budgets

"How sure are we?" Show assumptions, sensitivity on volume ±5%, and whether data is actual, flexed budget, or forecast. "What is the dollar impact?" Translate units to CM dollars and fixed coverage. "What changes next month?" Name owners: purchasing for price variances, maintenance for downtime, sales for mix. "Does this match GAAP?" Flag timing differences between managerial standards and financial close.

Northwind's credible narrative is four bullets: recommendation, quantified CM or variance impact, key assumption, and metric that would falsify the view within 30 days. Cash Budgets is operational only when those bullets reference this lesson's mechanics, not generic strategy language.

Numerical reconciliation drill (Cash Budgets)

Month-end tie-out Priya runs: (A) sum of SKU margins reconciles to plant contribution within 0.3%. (B) OH applied at standard rate reconciles to actual OH pool ± under/over-applied balance. (C) Units produced × standard hours per unit reconciles to payroll hours ± overtime flag. (D) Pounds issued from warehouse reconciles to BOM (bill of materials) allowance ± scrap ticket.

Document materiality. Northwind sets $25,000 investigation threshold for single-plant variances unless food safety or retailer OTIF is implicated. Smaller variances roll into trend charts for master budgets, cash planning, and flexible forecasts. This discipline prevents chasing noise while catching structural drift in cash budgets drivers.

Study synthesis: connect Cash Budgets to Units 1–6

Unit 1 classification feeds Unit 2 costing systems, which feed Unit 3 CVP, Unit 4 budgets and standards, Unit 5 variances and responsibility, and Unit 6 decisions. Cash Budgets sits in that chain; skipping prerequisites produces pretty slides with wrong denominators.

Capstone habit: pick one Northwind SKU and trace it from BOM standard → job or process cost accumulation → unit CM → budgeted volume → flexible variance → pricing or make/buy choice. If any link breaks, the decision story breaks. Re-run the chain after this lesson before attempting unit assessments.

Spreadsheet modeling notes for Cash Budgets

Build Northwind models with three tabs: Inputs (blue cells for volumes, prices, hours, standards), Calc (black formulas only), and Output (green decision metrics). Lock formula cells before circulation. Priya requires a balance check row on every tab: for job costing, sum of job WIP plus FG equals GL control account; for CVP, fixed + total CM = operating income at break-even; for variances, price plus quantity plus volume equals total material variance.

When cash budgets spans plants, duplicate structure per plant then consolidate with elimination of intercompany transfers. Omaha machine-hour OH rate $38 must not be applied to Fresno labor-hour jobs without explicit conversion notes. Transfer pricing between Columbus bowls and internal food-service must use the policy Maria approved (variable cost plus 15% for short-run; market price for external comparisons).

Sensitivity tables belong beside base case, not in appendix footnotes. Show low, base, and high for volume, price, and key cost drivers. James Okoro reads sensitivity before approving overtime; Maria reads it before covenant certification.

Plant-level detail: Omaha, Fresno, Columbus

Omaha (Plant 1) focuses on dry granola and oats handling. Annual throughput near 5.0M cases with peak oven utilization in Q4 club promos. Fresno (Plant 2) runs sauce kettles with frequent flavor changeovers; Heritage Tomato Sauce is the volume leader at 680,000 units/month. Columbus (Plant 3) produces frozen Heat & Eat bowls with cold-chain constraints; storage at 96% capacity triggers mix decisions before cash budgets math even begins.

Each plant uses different OH drivers because cost causality differs. Blending rates for reporting simplicity is allowed for executive summaries but not for product-level pricing or make-or-buy calls. ABC (activity-based costing) activity rates from Unit 2 should feed master budgets, cash planning, and flexible forecasts when single-rate distortion exceeds $0.05 per unit on any SKU above $2M annual contribution.

Priya publishes a monthly plant contribution bridge: price, volume, mix, variable cost, fixed cost, and variance buckets. Cash Budgets should map to at least one bridge line with a named owner.

Worked pattern replication (Cash Budgets)

Students should replicate lesson examples with altered assumptions before the unit quiz. Change one driver at a time: increase oat price $0.05/lb, reduce bowl CM by $0.20, add 12,000 incremental promo units, or shift mix from sauce to granola 3 percentage points. Recompute the lesson's primary output (unit cost, break-even units, flexible budget allowance, variance, or CM per hour) and verify the check line still balances.

Northwind controllers grade replication on: correct formula, correct sign convention (favorable vs unfavorable), explicit assumption label, and one-sentence managerial read. Answers missing any element fail the internal review even if the final number is accidentally right.

Link replication to ACC 101: any inventory change from capitalized product cost affects the balance sheet until COGS recognition. Managerial cash budgets may suggest building inventory for absorption; Maria will ask whether that matches sales forecast and retailer OTIF commitments.

Common Northwind data definitions (reuse every lesson)

Case means retail ship unit unless labeled pallet or inner pack. Standard cost is frozen until October revision unless safety issue forces interim update. Actual cost comes from AP invoices and payroll with three-way match. Contribution margin excludes allocated corporate overhead unless the lesson explicitly studies full cost. Fixed manufacturing overhead includes plant supervision and depreciation on production equipment; fixed S&A is period cost.

Machine hour is run time on bottleneck equipment (oven, kettle, blast freezer), not calendar time. Direct labor hour ties to time tickets with job or department codes. Changeover minutes are logged separately for ABC setup pools. Scrap above standard yield posts to variance accounts with quality engineer sign-off.

Using consistent definitions prevents the "two correct answers" problem in cross-functional meetings. Cash Budgets outputs should footnote which definition version was used.

From lesson to Monday action (Cash Budgets)

Translate cash budgets into a Monday action list with three items: (1) metric to watch this week, (2) threshold that triggers escalation, (3) owner other than finance who must respond. Example patterns: purchasing lead for material price variance beyond $40,000; maintenance lead for downtime above 4% on Omaha ovens; commercial lead for promo CM below $0.50/case.

Finance owns the math; operations owns the fix. Cash Budgets fails in practice when controllers publish variances without operational counterparts in the same meeting. James Okoro's staff meetings start with physical units (cases produced, changeovers, scrap pounds) before dollars, so the team sees whether variances are real efficiency or measurement noise.

Document decisions in the cost council log: date, lesson concept applied, recommendation, dissent if any, and 30-day follow-up metric. This is how Northwind preserves institutional memory across controller turnover.

Judgment under conflicting signals (Cash Budgets)

Real weeks present conflicting signals. Material price variance favorable $28,000 while quality scrap unfavorable $41,000 and OTIF slips 2 points. Cash Budgets does not pick a single winner; it structures tradeoffs. Priya's memo format: quantify each effect in CM or variance dollars, state interaction (cheap paste caused viscosity issues), recommend corrective action with owner, and separate one-time from run-rate.

Do not annualize a one-week blip without labeling it. Do not ignore a four-week trend because month-end accruals are incomplete. Maria applies two-period confirmation for capital requests tied to master budgets, cash planning, and flexible forecasts: a variance or opportunity must appear in two consecutive monthly reviews or survive a flexible-budget retest at actual volume.

Board members without cost accounting training should still understand the recommendation sentence. If the sentence requires jargon undefined in the memo, rewrite.

Technical supplement: formulas referenced in Cash Budgets

Keep a formula sheet in your ACC 102 workbook. Core patterns Northwind reuses: Unit CM = Price − Variable cost per unit. CM ratio = Unit CM ÷ Price. Break-even units = Fixed costs ÷ Unit CM. DOL (degree of operating leverage) = Total CM ÷ Operating income at a given volume. Material price variance = (AP − SP) × AQ. Material quantity variance = (AQ − SQ) × SP. OH applied = Actual base × Predetermined rate. CM per constrained hour = Unit CM ÷ Hours per unit on the bottleneck.

Plug numbers before interpreting. A favorable price variance with unfavorable quantity may net unfavorable margin. High DOL amplifies small volume misses into large profit misses. Low CM per hour on a promoted SKU can destroy portfolio margin even when unit CM looks positive.

Profit does not equal cash. Northwind's cash budget adds depreciation back, subtracts capital for line upgrades, tracks AR (accounts receivable) collections (grocery 45-day terms), and schedules AP (accounts payable) for commodities. A profitable quarter can still breach a loan covenant if tomato paste prepayments spike.

Recompute one formula from this lesson using Northwind numbers different from the worked example (change volume ±10% or price ±$0.10) and confirm the check line. This drill catches formula direction errors before exams and before executive reviews.

Cash Budgets in Northwind's operating cadence

Profit does not equal cash. Northwind's cash budget adds depreciation back, subtracts capital for line upgrades, tracks AR (accounts receivable) collections (grocery 45-day terms), and schedules AP (accounts payable) for commodities. A profitable quarter can still breach a loan covenant if tomato paste prepayments spike.

CFO Maria Chen, VP Operations James Okoro, and Plant Controller Priya Shah review master budgets, cash planning, and flexible forecasts in monthly plant controller meetings before data hardens into GAAP quarter-close. Priya Shah's team posts standard cost updates, volume variances, and mix effects to shared folders James Okoro's operators can action within 48 hours. Maria Chen uses the same underlying transactions ACC 101 will later classify for external statements, but managerial reports may show segment margin, transfer prices, and flexible budget comparisons not required in the 10-K (annual SEC filing).

Walk the arithmetic habit every controller expects. When cash budgets produces a rate, ratio, or variance, show the numerator definition, denominator definition, period, and plant scope. If Omaha and Columbus use different allocation bases, state why (machine intensity vs labor intensity). A single blended rate is simpler but can misprice SKUs; ABC (activity-based costing) fixes that complexity with more measurement cost.

Extended scenario: cross-plant read for Cash Budgets

Picture a Tuesday S&OP (sales and operations planning) review. Grocery sales beat forecast on NorthWind Granola 12oz by 6% while food-service sauce lagged. Contribution margin dollars rose roughly $71K on granola alone at $2.81 unit CM, but Fresno faced overtime on sauce kettles and Columbus cold storage approached 96% utilization. Cash Budgets is how leadership decides whether to pull forward Omaha oven maintenance, expedite tomato paste, or reprice a low-CM promotional pack.

Reconcile before recommending. Fixed manufacturing overhead budget $3.2M per month must be covered by portfolio CM after variable costs. At current granola CM ratio 56.3%, price cuts require explicit volume lift calculations; see Unit 3 CVP. Budget variances (Unit 4) will later decompose whether misses were volume, price, or efficiency.

Stakeholder tension is normal. James Okoro protects line reliability and food safety audits. Maria Chen protects covenant headroom and EPS (earnings per share) guidance. Commercial leads protect slotting and brand share. Cash Budgets gives shared vocabulary so debate targets assumptions (standard oat price, changeover minutes, transfer price) instead of personalities.

Mechanics checklist: Cash Budgets

Use the same checklist Priya posts on every analysis deck: (1) Cost object defined (SKU, job, plant, customer). (2) Time horizon labeled short-run vs long-run; capacity decisions differ. (3) Relevant costs isolated; sunk and allocated corporate charges scrutinized. (4) Denominator for any rate shown (machine hours, cases, labor dollars). (5) Check line ties detail to control totals within $1,000 unless immateriality policy says otherwise.

Spreadsheet replication: separate data (volumes, prices, hours) from formulas (rates, variances, CM). Color inputs blue; never embed hard-coded totals in CM formulas. Tie units × unit CM = total CM and fixed + variable = total manufacturing cost on every tab. Northwind rejects decks where margin percent disagrees with dollar CM due to mixed rounding.

For master budgets, cash planning, and flexible forecasts, link forward and back. Earlier cost classification lessons explain why a cost is fixed or indirect; later variance and decision lessons consume the same standard cost database. Breaking the chain (e.g., changing oat standard without updating budget and transfer price) creates silent contradictions across plants.