Master budget linkages
Connect sales to production and resource needs, then connect credit terms to cash. The operating schedules build budgeted profit; collection, payment, investment and financing schedules build the cash budget and projected balance sheet.
From sales to the cash budget
- Operating schedules
- Sales → production → materials, labor and overhead.
- Cash collections
- Current cash sales + collections of current and earlier credit sales.
- Borrowing need
- Minimum cash balance - cash before financing, when the difference is positive.
The simplified borrowing rule excludes financing costs and repayment restrictions; add them when the case specifies them.
See the decision
A collection lag creates a financing need
Opening cash is $15,000. Current sales are $100,000: 60% collected now and 40% next month. All $28,000 opening receivables are collected now. Cash payments are $98,000 and minimum ending cash is $12,000. Ignore financing costs.
- 01
Sales
$100,000 earned
- 02
Collections
$88,000 including old receivables
- 03
Financing
$7,000 borrowing required
Required borrowing is $7,000. Ending receivables from current sales are $40,000, not missing cash revenue.
How to apply these ideas
1. Start with sales
Volume × selling price gives revenue, not collections.
Keep units and dollars in separate lines. Apply expected collection timing to current and prior sales. The opening receivables balance carries cash receipts from earlier periods into the current plan.
Watch for: Leaving prior-period receivables out of the cash budget.
2. Roll inventories
Add the desired ending balance and subtract the opening balance.
Use this roll-forward for finished goods to obtain production. Apply material requirements and the raw-material inventory policy to obtain purchases. The same algebra works only when the quantities refer to the same inventory stage.
Watch for: Using the finished-goods inventory balance in the materials schedule.
3. Schedule payments
Apply payment terms to purchases and other obligations.
Materials used, materials purchased and cash paid can be three different amounts. Add opening payables settlements and exclude noncash expenses. Schedule capital expenditure when payment occurs rather than spreading it as depreciation.
Watch for: Using cost of goods sold as cash paid to suppliers.
4. Close the loop
Reconcile ending cash, debt and working capital to the projected balance sheet.
A funding gap changes borrowing and may change interest expense. Iterate the linked schedules until financing assumptions and ending balances agree. A spreadsheet balancing mechanically does not validate unrealistic demand or capacity assumptions.
Watch for: Plugging the balance sheet without explaining financing.
Study the topic
Master budget linkages: explanations and applications
Follow sales through production, materials purchases, payments and projected balances. The budgeting parent covers strategy, methods and forecast selection.
By MiloPrep editorial team. Original teaching explanations and illustrative cases; official curriculum references are listed below.
Keep the physical schedule separate from the dollar schedule
Start with units of customer demand. The finished-goods roll-forward determines production; the production specification determines materials usage; the raw-material roll-forward determines purchases. Only then multiply purchase quantity by its price and apply supplier payment terms. Skipping a stage can confuse consumption, purchasing and payment.
Use the same cut-off at each link. Beginning inventory is the preceding period’s ending balance. Desired ending inventory is a policy assumption, not an additional sale. If next month’s demand determines the current closing inventory target, obtain that forecast before calculating this month’s production requirement.
| Schedule | Relationship | Carry-forward balance |
|---|---|---|
| Finished goods | Beginning + production - sales = ending | Next period’s beginning finished goods |
| Raw materials | Beginning + purchases - usage = ending | Next period’s beginning raw materials |
| Receivables | Beginning + credit sales - collections = ending | Future collections |
| Payables | Beginning + credit purchases - payments = ending | Future payments |
| Cash | Beginning + receipts - payments + net financing = ending | Next period’s opening cash |
Include opening receivables and payables
A collection pattern applies to the sales that created each receivable cohort. If 60% of sales is collected in the current month and 40% next month, current collections include both cohorts. An opening receivable balance may include older amounts or bad debts, so use the facts rather than automatically multiplying all prior sales by the same percentage.
Supplier terms apply to purchases, not materials usage or cost of goods sold. Opening payables settle prior obligations; unpaid current purchases create the closing balance. Reconcile the cash payment schedule to the payable roll-forward. When a problem specifies discounts, taxes or partial payments, model them explicitly instead of hiding them in a plug.
Close the model without hiding a funding gap
After operating payments, add capital spending, taxes, dividends and the specified financing flows. Depreciation affects profit and potentially tax, but is not itself a cash payment. Compare cash before financing with the required minimum and apply the borrowing rules. Interest can depend on when borrowing occurs, so timing may require another pass through the schedule.
A projected balance sheet checks that cash, inventory, receivables, payables, fixed assets, debt and equity tell a consistent story. Retained earnings rolls forward by profit less distributions. If the statements fail to reconcile, locate the omitted transaction or assumption. Do not use unexplained “other assets” or borrowing as a balancing device.
Work it through
Worked example: A collection lag creates a financing need
Opening cash is $15,000. Current sales are $100,000: 60% collected now and 40% next month. All $28,000 opening receivables are collected now. Cash payments are $98,000 and minimum ending cash is $12,000. Ignore financing costs.
| Cash schedule | Amount |
|---|---|
| Opening cash | $15,000 |
| Current sales collected | +$60,000 |
| Opening receivables collected | +$28,000 |
| Cash payments | -$98,000 |
| Cash before borrowing | $5,000 |
- 1
Collections = 100,000 × 60% + 28,000 = $88,000.
- 2
Cash before borrowing = 15,000 + 88,000 - 98,000 = $5,000. Borrow 12,000 - 5,000 = $7,000 to reach the minimum.
Required borrowing is $7,000. Ending receivables from current sales are $40,000, not missing cash revenue.
Work through the alternatives
More worked cases: master budget linkages
Original teaching scenarios. Each case states its assumptions, shows the working and explains the limits of the conclusion.
Materials usage, purchases and payments are three amounts
Sales are 5,000 units; beginning finished goods 400 and desired ending 600. Each unit uses 3 kg. Beginning material is 1,000 kg and desired ending 1,400 kg. Material costs $4/kg. Pay 75% of current purchases plus $12,000 opening payables; no discounts or other movements.
| Schedule | Calculation | Result |
|---|---|---|
| Production | 5,000 + 600 - 400 | 5,200 units |
| Material usage | 5,200 × 3 | 15,600 kg |
| Purchases | 15,600 + 1,400 - 1,000 | 16,000 kg |
| Purchase value | 16,000 × $4 | $64,000 |
| Cash payments | 75% × $64,000 + $12,000 | $60,000 |
| Closing payables | 25% × $64,000 | $16,000 |
- Calculate the two inventory roll-forwards before applying the $4 price.
- Opening payables + current purchases - cash payments = 12,000 + 64,000 - 60,000 = $16,000, matching the unpaid current purchases.
What the result means: Materials usage is $62,400, purchases $64,000 and cash payments $60,000. Their differences are explained by inventory and credit timing.
Practice this topic
Check your understanding
Try each short application before opening its explanation. These are original learning checks, not official exam questions or a score prediction.
1. Beginning receivables are $18,000, credit sales $80,000 and collections $74,000. No write-offs occur. What is ending receivables?
Show answer and explanation
$24,000.
18,000 + 80,000 - 74,000 = 24,000. This is an asset balance, not extra revenue.
2. Cash before financing is $7,500 and the minimum is $12,000. Borrowing must be in $1,000 increments. Ignore interest. How much is borrowed?
Show answer and explanation
$5,000.
The shortfall is $4,500, rounded up to the permitted borrowing increment. Ending cash is $12,500, not exactly the minimum.
Questions about master budget linkages
- Why can a profitable business need borrowing?
- Profit includes credit sales and accrual expenses. Inventory growth, slow collections and capital expenditure can use cash before the related income appears.
- Where does depreciation enter?
- It enters the income and asset schedules. It is excluded from cash payments, although its tax effects matter when tax cash flows are modeled.
Sources and scope
Curriculum mapping: Part 1, Section B, Planning, Budgeting, and Forecasting. The official outline assigns 20% to the entire domain, not to this individual technique. These are selected study notes, not complete curriculum coverage.
Official curriculum references establish scope and expected skills. The explanations, diagrams and numerical cases are independent teaching material from MiloPrep, not official questions or source-validated solutions. Curriculum references checked 2026-10-10.
- IMA Content Specification Outlines (effective September 2024) ↗
Supports: Part 1, Section B, beginning on printed page 6. Domain names, weights and curriculum boundaries.
- IMA Learning Outcome Statements (effective September 2024) ↗
Supports: Part 1 B.5: linked budget schedules, continuing on page 6; printed page 5. Curriculum scope, not verification of this original worked example.
Independent US CMA study material. Not affiliated with or endorsed by IMA. This covers management accounting, not medical-assistant certification or the separate ICMAI qualification.