Budgeting, Forecasting and Resource Planning

Introduction and context

Budgeting is the systematic process through which an organisation translates strategy into quantified plans for a defined period. Forecasting estimates what is likely to happen, whereas budgeting authorises and coordinates what management intends to achieve. Resource planning connects both activities to the deployment of scarce cash, people, assets, technology and organisational capacity.

For a Chartered Finance Manager, budgeting is not merely the preparation of spreadsheets. It is a management-control activity involving assumptions, behavioural incentives, risk evaluation, governance and strategic choice. A budget can clarify priorities and expose financing requirements, but it can also encourage gaming, short-termism and inefficient resource consumption when poorly designed.

A high-quality planning system therefore combines a sound operating budget with cash and capital budgets, explicit assumptions, sensitivity analysis, appropriate performance measures and disciplined review. It should be sufficiently rigorous for accountability but sufficiently adaptive for uncertain environments.

Learning objectives

By the end of this chapter, the reader should be able to:

1. Explain the relationship between strategy, forecasting, budgeting and resource allocation.
2. Prepare operating, cash and capital budgets and reconcile their interdependencies.
3. Apply flexible, rolling, zero-based and beyond-budgeting approaches.
4. Use scenario analysis, sensitivity analysis and forecast-error measures in planning.
5. Evaluate investment and resource-allocation decisions using relevant financial and strategic information.
6. Identify behavioural, ethical, technological and governance risks in budgeting systems.

1. The planning architecture

The planning cycle normally proceeds through the following linked stages:

• Strategic analysis: clarification of purpose, competitive position, objectives and constraints.
• Forecasting: estimation of demand, prices, costs, working capital, financing needs and external conditions.
• Target setting: selection of desired outcomes, such as revenue, margin, service quality, cash generation or market share.
• Budget formulation: translation of targets into detailed operating, cash and capital schedules.
• Resource allocation: approval of people, inventory, capacity, technology and investment resources.
• Execution and control: monitoring actual results against expectations and taking corrective action.
• Learning and revision: updating assumptions as evidence changes.

The distinction between a forecast and a budget is important. A forecast should be an unbiased or best-estimate view of likely outcomes. A budget may represent a negotiated target, including a level of performance that management expects to achieve. Confusing the two can cause managers to distort forecasts to obtain easier targets or more resources.

A useful planning hierarchy is:

2. Operating budgets

An operating budget describes expected revenues, operating activity and operating costs for a period. It usually culminates in a budgeted income statement, but it begins with operational drivers rather than accounting totals.

2.1 Sales budget

The sales budget is commonly the starting point because demand influences production, purchasing, staffing and cash collection. A basic revenue relationship is:

The equation assumes that units and prices are sufficiently defined and that revenue recognition follows the relevant accounting framework. If products have different prices, the calculation should be performed by product or customer segment and then aggregated. Discounts, returns, rebates, foreign exchange and contract terms must be considered.

A robust sales budget combines historical patterns with causal drivers such as market growth, customer retention, sales pipeline quality, capacity, competitor action and price elasticity. Pure extrapolation can be unreliable when the organisation is entering a new market or facing structural change.

2.2 Production and materials budgets

For a manufacturing organisation, planned production is derived from sales and inventory policy:

The units on all three terms must be identical. The relationship assumes that inventory is measured in physical units and that finished-goods inventory policy is intentional rather than accidental.

Material purchases can be estimated as:

If each unit requires a different quantity of material, the calculation should be performed by material category. Purchase cost is then obtained by multiplying quantities by expected purchase prices, allowing for supplier discounts, freight, taxes and wastage.

2.3 Labour and overhead budgets

Direct labour budgets use expected production hours and wage rates:

This formula assumes a stable standard of labour efficiency and a known wage rate. Overtime premiums, employer contributions, temporary labour, learning effects and capacity constraints may require separate modelling.

Overhead budgets should distinguish fixed, variable and mixed costs. A cost that appears fixed within a normal capacity range may become step-fixed when a new shift, supervisor or facility is required. Driver-based budgeting links costs to activities such as machine hours, purchase orders, deliveries, customer accounts or service tickets.

2.4 Budgeted income statement

A budgeted income statement consolidates operating assumptions:

The equation is a planning model, not a substitute for financial reporting. Depreciation, accruals, provisions, tax, financing costs and accounting policy must be treated consistently. Cash expenditure is not identical to expense, which is why the income statement must be connected to a cash budget rather than used as a cash proxy.

3. Cash budgeting and working capital

A cash budget estimates cash receipts, cash payments, financing movements and closing liquidity. It is essential even when the organisation is profitable because timing differences can create a liquidity crisis.

Cash receipts may include customer collections, asset disposals, grants and borrowings. Cash payments may include suppliers, wages, taxes, interest, capital expenditure and dividends. Non-cash expenses such as depreciation are excluded from cash payments, while capital expenditure is included when paid.

A useful collection schedule separates sales made in the current period from collections of earlier credit sales. For example, if 60% of monthly credit sales are collected in the month of sale and 40% in the following month, collections for month t are:

The percentages must reflect observed contractual and behavioural patterns. Bad debts, delayed payments and seasonality should be modelled explicitly.

Working-capital planning concerns inventory, receivables and payables. The cash conversion cycle is commonly expressed as:

Here, inventory days, receivables days and payables days are average time periods, usually measured in days. A shorter cycle generally releases cash, but aggressive reductions can damage service quality, supplier relationships or production continuity.

Liquidity planning should include minimum cash balances, committed facilities, covenant headroom and stress scenarios. A cash budget that shows an annual surplus may still conceal a severe temporary deficit.

4. Capital budgeting and resource planning

Capital budgeting evaluates long-term investments such as machinery, information systems, facilities, product development and acquisitions. These decisions are difficult to reverse and often determine future operating capacity.

4.1 Relevant cash flows

A capital-budgeting analysis should include incremental cash flows caused by the project. Typical components are:

• initial purchase, installation and training costs;
• additional working capital;
• incremental operating receipts and payments;
• tax effects;
• disposal proceeds and recovery of working capital;
• opportunity costs of resources already owned.

Sunk costs are excluded because they cannot be changed by the decision. Allocated overhead is included only when it represents an incremental cash consequence. Financing flows are normally excluded from project cash flows when the discount rate already reflects financing risk and cost of capital.

4.2 Net present value

Net present value (NPV) measures the present value of expected future incremental cash flows less the initial investment:

Where I₀ is the initial investment at time zero, CF_t is the incremental cash flow in period t, r is the appropriate discount rate per period, and n is the project life. Cash flows and the discount rate must use consistent periods and currency units. Under conventional assumptions, a positive NPV indicates that the project is expected to create value above the required return.

The discount rate should reflect project risk, not simply the organisation’s average borrowing rate. A project with materially different operating or country risk may require a different rate or probability-weighted cash-flow analysis.

4.3 Worked capital-budgeting example

An illustrative project requires an initial investment of £120,000 and produces expected incremental cash flows of £50,000 in each of the next three years. The discount rate is 10%, and there is no terminal value.

The present values are approximately £45,455, £41,322 and £37,566. Therefore:

On the stated assumptions, the project has a positive NPV. The result is not a guarantee: if demand, costs or the discount rate change, the conclusion may change. Management should therefore complement NPV with scenario analysis, strategic fit, implementation risk and non-financial consequences.

4.4 Resource allocation under constraint

When capital, labour or production capacity is limited, projects should not automatically be ranked by total profit. Relevant measures include NPV per unit of scarce resource, strategic necessity, risk-adjusted value and interdependence with other projects. A mathematically optimal allocation may be operationally infeasible if projects require indivisible teams or minimum investment thresholds.

Linear programming can formalise allocation problems. In general form, an organisation maximises an objective such as contribution or NPV subject to resource constraints:

Here, x_j is the level of activity or project j, c_j is its contribution to the objective, a_{ij} is the amount of resource i consumed by activity j, and b_i is the available quantity of resource i. The model is applicable when relationships are sufficiently linear and activities are divisible or can be represented appropriately. Real decisions may require integer programming, qualitative judgement or staged approvals.

5. Flexible and rolling budgets

A static budget is prepared for one assumed activity level. It is useful for authorisation but weak for performance evaluation when actual volume differs materially from plan.

A flexible budget adjusts variable costs to the actual activity level while retaining appropriate fixed-cost assumptions:

This is valid only when the cost behaviour assumption is reasonable within the relevant range. Step costs, inflation, efficiency changes and mixed costs require more detailed schedules.

For example, suppose a service centre budgets fixed costs of £30,000 and variable cost of £8 per service ticket. At 4,000 actual tickets, the flexible budget cost is:

Comparing actual cost with £62,000 is more informative than comparing it with a static budget based on 3,500 tickets. The resulting variance can be decomposed into volume, price, efficiency and spending effects where the underlying data support such analysis.

A rolling budget or rolling forecast continuously extends the planning horizon. At the end of each month or quarter, the completed period is removed and a new future period is added. Rolling systems are valuable in volatile conditions, but they require disciplined assumptions and can impose excessive administrative effort if every line is continually reworked.

A rolling forecast should not necessarily replace a formal annual budget. The annual budget may remain important for authorisation, incentives and external commitments, while the rolling forecast provides a current view of likely outcomes.

6. Zero-based budgeting and beyond budgeting

Zero-based budgeting

Zero-based budgeting (ZBB) requires activities or spending packages to be justified from a defined base rather than automatically carrying forward the previous period. Effective ZBB asks:

• What service or outcome does this activity produce?
• What level of service is required?
• What alternative delivery methods exist?
• What are the consequences of reducing or eliminating it?
• What evidence supports the proposed cost?

ZBB can identify legacy expenditure and challenge organisational inertia. However, a literal annual reconstruction of every cost can be expensive and may undervalue capabilities whose benefits are long term or difficult to measure. Selective or periodic ZBB is often more practical than comprehensive annual application.

Beyond budgeting

Beyond-budgeting approaches question rigid annual targets, centralised resource allocation and performance evaluation against fixed budgets. Common principles include relative performance evaluation, decentralised decision-making, continuous planning, transparency, customer focus and resource access when justified by business need.

The approach does not mean abandoning financial discipline. It replaces some fixed controls with dynamic controls, strong information systems, clear accountability and explicit guardrails. It may be more appropriate where demand and technology change rapidly, but it can be difficult where regulatory approvals, fixed funding limits or coordination requirements demand formal budgets.

7. Forecasting and uncertainty

Forecasting is a structured judgement about future conditions. It may use qualitative methods, statistical models or combinations of both.

7.1 Forecasting methods

• Driver-based forecasting: links outcomes to operational drivers such as customers, transactions, headcount, utilisation or price.
• Time-series forecasting: uses historical patterns, including trend and seasonality, when the past remains informative.
• Regression analysis: estimates relationships between a dependent variable and explanatory variables. It is useful only when the relationship is economically plausible and data quality is adequate.
• Scenario analysis: constructs internally consistent alternative futures, such as base, upside and downside cases.
• Judgemental forecasting: incorporates expert knowledge, especially where structural breaks or limited history make statistical extrapolation unreliable.

Forecast precision should not be confused with decision quality. A forecast with a narrow range may simply conceal uncertainty. Management should record assumptions, confidence ranges and indicators that would trigger revision.

7.2 Forecast-error measures

If actual value is A_t and forecast value is F_t, forecast error may be defined as:

Mean absolute error (MAE) is:

Mean absolute percentage error (MAPE) is:

MAE is expressed in the original units. MAPE is percentage-based but becomes problematic when actual values are zero or close to zero and can overemphasise small denominators. Forecast evaluation should also consider bias, materiality and the decision consequences of errors.

7.3 Scenario and sensitivity analysis

Sensitivity analysis changes one assumption while holding others constant, such as selling price, volume or labour cost. Scenario analysis changes several linked assumptions to represent a coherent environment. For example, a recession scenario may combine lower volume, delayed collections, price pressure and higher bad debts.

A useful scenario process is:

1. Identify value drivers and uncertainties.
2. Establish a transparent base case.
3. Define internally consistent alternative cases.
4. Quantify effects on profit, cash, covenant ratios and strategic milestones.
5. Identify early-warning indicators and management actions.
6. Assign responsibilities and decision thresholds.

Probabilistic analysis may calculate expected value:

where p_s is the probability assigned to scenario s and the probabilities sum to 1. Expected value is informative only when probabilities are defensible; it should not disguise deep uncertainty or non-linear downside risk.

8. Performance management and behavioural design

Budgets influence behaviour because they allocate resources, establish expectations and affect rewards. Common dysfunctional behaviours include budgetary slack, deliberate underestimation of revenue, spending to avoid future cuts, manipulation of timing and excessive focus on controllable accounting measures.

Better design principles include:

• separate best-estimate forecasts from negotiated performance targets;
• involve operational managers who understand drivers, while retaining challenge and governance;
• use controllable measures for accountability;
• combine financial metrics with quality, safety, customer and employee indicators;
• review assumptions rather than blaming managers for uncontrollable events;
• reward sustainable performance rather than single-period target attainment;
• use relative and trend-based evaluation where appropriate.

A budget variance is a signal for investigation, not automatically evidence of poor management. Favourable cost variance may reflect under-maintenance, poor quality or delayed investment. Unfavourable expenditure may reflect a justified response to an unexpected opportunity.

9. Technology, data and AI

Modern planning platforms integrate enterprise-resource-planning data, operational drivers, workflow approvals and dashboards. Driver-based models can connect transactions, capacity and financial outcomes more quickly than manually maintained spreadsheets.

AI and machine-learning tools may support demand sensing, anomaly detection, scenario generation and narrative variance analysis. They do not remove the need for professional judgement. Risks include biased training data, unstable relationships, model drift, opaque recommendations, cyberattack and false confidence in precise outputs.

Governance should include data ownership, access controls, version control, audit trails, model validation, human approval and documented override rationale. A forecast generated by an algorithm remains a management estimate and should be challenged against commercial knowledge and external evidence.

10. Illustrative case: Northbridge Components Ltd

Background

Northbridge Components Ltd, a fictional manufacturer, supplies specialised parts to industrial customers. Demand has grown, but cash shortages have increased because customers pay slowly and management is considering a £1.2 million automated production line.

Problem

The annual budget assumes 24,000 units sold at £150 each. Variable manufacturing cost is £92 per unit and fixed operating costs are £900,000. Credit sales are collected 70% in the month of sale and 30% in the following month. The proposed line would increase capacity but requires £1.2 million immediately and is expected to generate incremental after-tax cash flows of £470,000, £500,000 and £520,000 over three years. The required return is 12%.

Analysis

Budgeted revenue is:

Budgeted variable cost is:

Budgeted operating profit before financing and tax is therefore:

The contribution per unit is £58. If volume falls by 2,000 units while fixed costs remain unchanged, operating profit falls by:

The capital project’s NPV is approximately:

The present values are approximately £419,643, £398,597 and £370,726. Thus:

On the base case, the project slightly fails the value-creation test. However, the decision should not be made from NPV alone. The project may protect strategic customers, reduce quality risk or create options for future growth. Conversely, the cash budget may show that financing the investment would breach the minimum liquidity policy during a seasonal trough.

Approach and solution

The finance team adopts three linked measures. First, it prepares a monthly rolling cash forecast and negotiates improved collection terms with major customers. Second, it uses a flexible operating budget that separates volume effects from price and efficiency effects. Third, it defers final capital approval until a pilot confirms the expected labour savings and until committed finance is available.

The team also prepares downside and upside scenarios. In the downside case, units decline by 10%, collections slow by one month and project cash flows fall by 15%. In the upside case, a customer contract raises volume and project cash flows increase by 12%. Approval requires the project to remain within covenant limits and to meet a defined operational milestone.

Outcome

The pilot confirms only part of the expected efficiency gain. Management renegotiates the equipment price and stages the investment. The revised project produces a positive NPV, while the rolling cash process prevents the organisation from mistaking accounting profit for available liquidity.

Learning points

The case demonstrates that operating, cash and capital budgets must be integrated. It also illustrates that NPV is assumption-sensitive, that cash timing can dominate profitability, and that staged investment can preserve strategic flexibility. A disciplined process does not eliminate uncertainty; it makes uncertainty visible and actionable.

11. Governance, ethics and limitations

Budgeting systems should comply with applicable company law, accounting standards, tax rules, funding covenants and public-sector or sector-specific requirements. Managers must not manipulate forecasts, conceal liabilities, shift costs between periods or overstate certainty to secure funding.

Boards and audit committees should review major assumptions, downside resilience, capital-allocation criteria, liquidity headroom and incentive effects. Segregation of duties should exist between budget preparation, approval, payment authority and performance certification.

Important limitations include model risk, unreliable historical data, structural breaks, uncertain probabilities and interdependencies between decisions. A budget is not a prediction of destiny or a substitute for managerial judgement. It is a formal representation of assumptions that must be challenged and updated.

Best-practice checklist

An effective budgeting and resource-planning system should:

1. Begin with strategy and measurable value drivers.
2. Distinguish forecasts, targets and authorised spending limits.
3. Integrate operating, cash and capital schedules.
4. Use flexible analysis when activity levels vary.
5. Maintain a rolling view of liquidity and major assumptions.
6. Apply scenario and sensitivity analysis to material risks.
7. Evaluate investments using incremental cash flows and appropriate risk.
8. Combine financial and non-financial performance indicators.
9. Document assumptions, ownership, approvals and revisions.
10. Use technology with strong data, model and cyber governance.
11. Investigate variances constructively and avoid automatic blame.
12. Reassess whether the planning method remains suitable as conditions change.

Chapter Summary

Budgeting translates strategy into quantified operating, cash and capital plans; forecasting estimates likely outcomes; and resource planning determines how scarce organisational capacity is deployed. Sales, production, materials, labour and overhead budgets should be linked through operational drivers and consolidated into a budgeted income statement. Because profit does not equal cash, a separate cash budget must model collection and payment timing, working capital, financing and liquidity headroom.

Capital budgeting focuses on incremental cash flows and risk-adjusted value. NPV provides a rigorous decision framework, but strategic fit, uncertainty, capacity and implementation risk also matter. Flexible budgets improve performance evaluation when actual activity differs from plan, while rolling forecasts support adaptation. Zero-based budgeting challenges inherited expenditure; beyond-budgeting approaches seek agility through decentralisation, continuous planning and dynamic controls.

Effective forecasting combines data, drivers, judgement and explicit uncertainty. Scenario and sensitivity analysis reveal vulnerabilities and management actions. Finally, budgeting is a behavioural and governance system: ethical conduct, reliable data, appropriate incentives, human oversight and clear accountability are as important as mathematical accuracy.

Key Terms

Budget: A quantified and authorised plan for a defined period.

Forecast: A best estimate of likely future conditions or results.

Operating budget: A plan for revenues, activity and operating costs.

Cash budget: A schedule of expected cash receipts, payments and financing.

Capital budget: A plan and evaluation of long-term investment expenditure.

Flexible budget: A budget adjusted for the actual level of activity.

Rolling forecast: A forecast whose planning horizon is continuously extended.

Zero-based budgeting: A method requiring expenditure to be justified rather than automatically carried forward.

Beyond budgeting: A management philosophy emphasising adaptive planning and decentralised control.

Working capital: Current operating assets and liabilities, including inventory, receivables and payables.

Cash conversion cycle: Inventory days plus receivables days less payables days.

Incremental cash flow: Cash flow caused by accepting a decision compared with rejecting it.

Sunk cost: A past cost that cannot be changed by a current decision.

Net present value: Present value of future incremental cash flows less initial investment.

Scenario analysis: Evaluation of coherent alternative future conditions.

Sensitivity analysis: Assessment of the effect of changing one assumption.

Budgetary slack: Deliberate understatement of expected performance or overstatement of required resources.

Driver-based planning: Forecasting and budgeting through operational causes of financial outcomes.

Resource constraint: A limit on available cash, labour, capacity, materials or other inputs.

Variance: The difference between an actual result and a budget, forecast or standard.

Review Questions

Short Answer Questions

1. Distinguish between a forecast and a budget.
2. Why can a profitable organisation experience a cash shortage?
3. State the basic relationship used to calculate required production.
4. What is the purpose of a flexible budget?
5. Why are sunk costs excluded from capital-budgeting decisions?

Long Answer Questions

1. Explain how an operating budget, cash budget and capital budget should be integrated.
2. Compare static, flexible, rolling, zero-based and beyond-budgeting approaches.
3. Explain the use of NPV, including its assumptions and limitations.
4. Discuss how budgeting systems can create dysfunctional behaviour and how governance can reduce it.
5. Evaluate the role of technology and AI in contemporary forecasting and resource planning.

Analytical / Application Questions

1. A business expects to sell 18,000 units at £80 each. Variable cost is £46 per unit and fixed operating cost is £420,000. Calculate budgeted revenue, contribution and operating profit. Explain how a flexible budget would assist if actual volume is 20,000 units.
2. A project costs £250,000 and generates cash flows of £100,000, £110,000 and £120,000 over three years. Using a 10% discount rate, calculate its NPV and advise management, noting relevant non-financial considerations.
3. Design a downside scenario for a business facing lower demand, slower customer collections and higher input prices. Identify the effect on the operating budget, cash budget and capital-allocation decision, and specify at least three early-warning indicators.

Multiple Choice Questions with Answers

Question 1

Which statement best distinguishes a forecast from a budget?

A. A forecast is always externally audited, while a budget is not.

B. A forecast estimates likely outcomes, while a budget may express an authorised target or plan.

C. A forecast contains only cash information, while a budget contains only profit information.

D. A forecast is prepared after the period ends, while a budget is prepared during the period.

Correct Answer: B. A forecast estimates likely outcomes, while a budget may express an authorised target or plan.

Question 2

A company expects sales of 10,000 units, desires ending inventory of 1,500 units and begins with 1,200 units. What production is required?

A. 8,800 units

B. 9,700 units

C. 10,300 units

D. 11,500 units

Correct Answer: C. 10,300 units

Question 3

Which item is normally included in a cash budget but not as an expense in the income statement at the time of payment?

A. Capital expenditure

B. Depreciation

C. Accrued wages expense

D. Credit sales revenue

Correct Answer: A. Capital expenditure

Question 4

A flexible budget is primarily useful because it:

A. Eliminates all fixed costs from performance reports.

B. Adjusts variable-cost expectations for the actual activity level.

C. Guarantees that actual results will equal the original budget.

D. Replaces the need for a cash-flow forecast.

Correct Answer: B. Adjusts variable-cost expectations for the actual activity level.

Question 5

An investment requires £100,000 and has a present value of expected future cash flows of £108,000. What is its NPV?

A. £8,000 positive

B. £8,000 negative

C. £108,000 positive

D. £100,000 negative

Correct Answer: A. £8,000 positive

Question 6

Which cost should generally be excluded from an incremental capital-budgeting analysis?

A. Additional working capital required by the project

B. An opportunity cost of using an existing facility

C. A past feasibility-study cost that cannot be recovered

D. Additional maintenance cash payments caused by the project

Correct Answer: C. A past feasibility-study cost that cannot be recovered

Question 7

What is a principal characteristic of zero-based budgeting?

A. All costs are increased by the inflation rate.

B. Expenditure is justified rather than automatically carried forward.

C. Only capital expenditure is reviewed.

D. Budgets are never revised after approval.

Correct Answer: B. Expenditure is justified rather than automatically carried forward.

Question 8

If inventory days are 50, receivables days are 35 and payables days are 30, what is the cash conversion cycle?

A. 15 days

B. 55 days

C. 85 days

D. 115 days

Correct Answer: B. 55 days

Question 9

Which statement about MAPE is correct?

A. It is unaffected when actual values are zero.

B. It is expressed in the original monetary units.

C. It can be distorted when actual values are zero or close to zero.

D. It measures only favourable forecast errors.

Correct Answer: C. It can be distorted when actual values are zero or close to zero.

Question 10

Which practice most directly reduces the risk of confusing accounting profit with liquidity?

A. Preparing only an annual income-statement budget

B. Using a cash budget with collection and payment timing assumptions

C. Excluding working capital from all forecasts

D. Evaluating every project using revenue growth alone

Correct Answer: B. Using a cash budget with collection and payment timing assumptions