Planning, budgeting and forecasting
Build the operating plan from its drivers: sales, production, materials, labor and overhead. Then translate activity into collections, payments and financing. A profitable budget can still require cash borrowing.
Three links that keep the budget consistent
- Production units
- Sales units + desired ending finished goods - beginning finished goods.
- Material purchases
- Production needs + desired ending materials - beginning materials.
- Cash before financing
- Opening cash + collections - cash payments.
Keep quantities separate from dollars. Credit sales become cash when collected.
See the decision
Sales are not the production budget
Next month sales are forecast at 8,000 units. Beginning finished goods are 900 units and desired ending finished goods are 1,200. Each unit needs 2 kg of material; ignore raw-material inventory changes.
- 01
Sales
8,000 units to customers
- 02
Inventory policy
Build finished goods by 300 units
- 03
Production
8,300 units; 16,600 kg used
Budget for 8,300 units of production and 16,600 kg of material usage, then schedule cash payments separately.
How to apply these ideas
1. Sales assumptions
State volume, price and collection timing separately.
Start with a supported demand assumption and test constraints such as capacity or inventory availability. Sales dollars feed the income plan; the credit policy and collection lag determine when those dollars enter the cash budget.
Watch for: Copying sales directly into cash collections.
2. Production
Units to produce = sales + desired ending inventory - beginning inventory.
The inventory policy connects consecutive periods. Convert required units into materials, labor and capacity using consistent standards. A sales increase can require even more production if management also raises the inventory buffer.
Watch for: Reversing beginning and ending inventory.
3. Cash and financing
Roll forward opening cash using actual collection and payment timing.
Exclude noncash depreciation from cash payments. Add capital purchases, taxes and financing flows at their expected dates. Compare ending cash before financing with the required minimum to calculate borrowing or surplus.
Watch for: Using budgeted net income as the change in cash.
4. Forecast updates
Update the driver when evidence changes; preserve the original benchmark.
A rolling forecast supports the latest decision, while the approved budget remains a performance reference. Identify whether a revision reflects demand, pricing, productivity or timing so the team can explain the difference.
Watch for: Overwriting the original budget and losing the comparison.
Study the topic
Planning, budgeting and forecasting: explanations and applications
Connect strategy, forecast assumptions, operating schedules and cash financing. This is the main budgeting guide; the linked applications work through specific forecasting and schedule problems.
By MiloPrep editorial team. Original teaching explanations and illustrative cases; official curriculum references are listed below.
Translate strategy into measurable operating assumptions
A strategy states where and how the organization intends to compete. A budget translates that choice into near-term actions and resource commitments. A differentiation strategy may require product-development and service spending even when a cost-only comparison favors cuts. Identify the strategic objective before calling an expense inefficient.
Use external and internal analysis for specific decisions. A competitor-price threat might change the sales forecast; a capacity constraint might change the production plan; a shortage of technical staff might delay a project. Name the driver, its owner, its measurement and the period affected. A SWOT list without changes to assumptions does not yet constitute a financial plan.
Choose the budget method for the decision
Budget methods can coexist. A master budget coordinates the organization, a project budget controls one undertaking and a flexible budget recalculates an allowance at another activity level. A rolling budget extends the horizon as time passes. It does not mean that every original performance target should be overwritten.
Participation can improve operating information and acceptance, but it also creates opportunities for budgetary slack. Ask whether a deliberately low sales estimate or inflated resource request is a prudent uncertainty allowance or an incentive-driven distortion. Make assumptions visible and retain the original benchmark alongside approved revisions.
| Approach | Best use | Main limitation |
|---|---|---|
| Master budget | Coordinate operating and financial schedules | Can become stale when drivers change |
| Zero-based | Justify activities and resource packages | Requires evidence and review effort |
| Activity-based | Translate demand into required activities/resources | Depends on credible activity drivers |
| Rolling | Maintain a forward planning horizon | Needs version control and clear ownership |
| Flexible | Compare costs at a common activity level | Requires a valid cost-behavior model |
| Project | Control a defined scope and completion horizon | Must reconcile with shared resource constraints |
Use a forecast model whose assumptions fit the data
A regression forecast relates an outcome to one or more drivers. In y = a + bx, a is the estimated intercept and b is the estimated change in y for a one-unit change in x. A statistical association can help prediction without proving causation. Avoid extrapolating far outside the observed range, and test forecasts on periods not used to fit the model.
A cumulative average-time learning curve describes average labor time per unit as cumulative output doubles. With an 80% curve, the average at two units is 80% of the one-unit time; the average at four units is 80% of the two-unit average. Multiply average time by cumulative units before subtracting prior cumulative hours to find incremental production time.
Expected value weights possible outcomes by probabilities that sum to one. It describes a probability-weighted mean, not a guaranteed result or necessarily an outcome that can occur. Report the scenarios and the downside as well as the average when liquidity or capacity could fail in an adverse case.
Build schedules in an order that preserves the physical flows
Start with sales units and prices. Add desired ending finished goods and subtract beginning finished goods to obtain production. Convert production into materials usage and labor hours. Materials purchases also depend on raw-material inventories. Labor cost depends on hours, rates and any specified capacity or overtime rules. Overhead should distinguish variable drivers from fixed commitments.
The schedules must use consistent units and periods. Kilograms consumed are not kilograms purchased, and purchases are not necessarily cash payments. Include opening receivables and payables when translating earlier credit transactions into the current cash budget. Depreciation may be in the income budget while excluded from cash payments.
Reconcile cash, financing and projected statements
Add collections to opening cash, deduct cash payments and compare the result with the required minimum. Borrowing fills a shortfall only under the stated financing terms. Interest timing, minimum loan increments and restrictions on repayment can change the answer. Capital expenditure uses cash when paid; the income statement recognizes depreciation rather than the full payment immediately.
Carry the ending balances into the projected balance sheet and reconcile equity through forecast income and distributions. A balance-sheet plug can make a spreadsheet balance while hiding an omitted collection or inventory assumption. Check the operational explanation of each movement, then test how demand, payment timing and capacity changes affect the funding requirement.
Work it through
Worked example: Sales are not the production budget
Next month sales are forecast at 8,000 units. Beginning finished goods are 900 units and desired ending finished goods are 1,200. Each unit needs 2 kg of material; ignore raw-material inventory changes.
| Driver | Units |
|---|---|
| Expected sales | 8,000 |
| Desired ending goods | +1,200 |
| Beginning goods | -900 |
| Production required | 8,300 |
- 1
Production = 8,000 + 1,200 - 900 = 8,300 units.
- 2
Materials used in production = 8,300 × 2 = 16,600 kg. Purchase quantity would also reflect raw-material inventories if they changed.
Budget for 8,300 units of production and 16,600 kg of material usage, then schedule cash payments separately.
Work through the alternatives
More worked cases: planning, budgeting and forecasting
Original teaching scenarios. Each case states its assumptions, shows the working and explains the limits of the conclusion.
A profitable sales plan still needs borrowing
June sales are $120,000. Collect 70% in June and $24,000 from May receivables. Opening cash is $8,000. Pay $76,000 operating costs and $35,000 for equipment. The minimum ending cash is $10,000; ignore financing costs.
| Cash schedule | Amount |
|---|---|
| Current collections: 70% × $120,000 | $84,000 |
| Prior collections | $24,000 |
| Cash available including opening balance | $116,000 |
| Operating and equipment payments | $111,000 |
| Ending cash before financing | $5,000 |
| Borrowing required | $5,000 |
- Available cash = 8,000 + 84,000 + 24,000 = $116,000.
- After $111,000 payments, only $5,000 remains. Borrow another $5,000 to reach the $10,000 minimum. Current sales still uncollected are $36,000.
What the result means: The financing need comes from timing and the equipment payment. Sales revenue is not a substitute for the collections schedule.
An 80% cumulative average-time learning curve
The first unit takes 100 labor hours. An 80% cumulative average-time learning curve applies through four units with no disruption.
| Cumulative output | Average hours per unit | Total hours |
|---|---|---|
| 1 unit | 100 | 100 |
| 2 units | 80 | 160 |
| 4 units | 64 | 256 |
- At two units, cumulative average time = 100 × 80% = 80 hours; total = 160 hours.
- At four units, average = 80 × 80% = 64 hours; total = 256. Units three and four together therefore require 256 - 160 = 96 hours.
What the result means: The 64-hour figure is the average for all four units, not the time for the fourth unit. The model must match the wording of the problem.
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. Production needs 6,000 kg. Beginning material is 700 kg and desired ending material is 900 kg. How much should be purchased?
Show answer and explanation
6,200 kg.
Purchases = usage + desired ending inventory - beginning inventory. Supplier payment terms then determine when those purchases use cash.
2. A forecast uses cost = $12,000 + $7 × units. What is the forecast at 3,000 units?
Show answer and explanation
$33,000.
Add fixed/intercept cost to 3,000 × $7. The forecast is defensible only within a range where the estimated relationship remains appropriate.
3. Sales outcomes are $80,000 with probability 25%, $100,000 with 50%, and $140,000 with 25%. What is expected sales?
Show answer and explanation
$105,000.
0.25 × 80,000 + 0.50 × 100,000 + 0.25 × 140,000 = 105,000. None of the listed outcomes is $105,000; the mean is not a promise.
Questions about planning, budgeting and forecasting
- Is a forecast the same as a target?
- A forecast estimates the likely outcome under stated assumptions. A target expresses the desired outcome. A useful plan shows the actions and resources needed to close the gap.
- Should fixed costs flex with volume?
- Normally not within the relevant range. Capacity additions or step costs can change that assumption, so name the range before extending a model.
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, Section B, beginning on printed page 3. The calculations, analysis and professional judgments candidates are expected to perform.
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.