Budgeting, Forecasting and Managerial Planning

Introduction

Budgeting is the formal process through which an organisation translates strategy into quantified plans for a defined period. Forecasting estimates what is likely to occur, while budgeting specifies what management intends to achieve and the resources it will commit. Planning therefore involves both predictive judgement and purposeful action. In contemporary organisations, budgets support coordination, resource allocation, performance evaluation, liquidity management and strategic control.

A budget is not merely a financial statement prepared in advance. It is a coordinated operating model linking demand, capacity, procurement, labour, investment, financing and cash. A well-designed budget makes assumptions visible and creates a basis for dialogue. A poorly designed budget can encourage dysfunctional behaviour, excessive cost cutting, budgetary slack and short-termism.

Learning objectives

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

1. Explain the purpose, architecture and behavioural implications of budgets.
2. Prepare functional, master, cash, flexible and capital budgets.
3. Distinguish budgets from forecasts and integrate both into managerial planning.
4. Evaluate incremental, zero-based, rolling, activity-based and beyond-budgeting approaches.
5. Apply scenario planning and sensitivity analysis to uncertain decisions.
6. Assess governance, technology and ethical issues in the budgeting process.

1. The architecture of an organisational budget

The budgeting process normally begins with strategic objectives and the principal budget factor, often sales demand, production capacity, cash availability or a regulatory constraint. The principal budget factor limits the scale of other plans. Functional budgets are then prepared and consolidated into the master budget.

A typical sequence is:

1. Establish strategic assumptions and the planning horizon.
2. Forecast sales volume, prices, market conditions and customer mix.
3. Prepare the sales budget.
4. Convert sales requirements into a production or service-delivery budget.
5. Prepare materials, labour, overhead, selling and administrative budgets.
6. Prepare the capital expenditure budget.
7. Integrate operating plans into a budgeted income statement and statement of financial position.
8. Prepare the cash budget and financing plan.
9. Approve, communicate, monitor and revise the plan.

The sales budget generally drives a manufacturing master budget. In a service organisation, the equivalent driver may be patient visits, consulting hours, hotel room nights or transactions. In a not-for-profit organisation, funding restrictions and service commitments may be more important than profit.

Functional budgets

The sales budget states expected units and selling prices. The production budget identifies units to be manufactured. The materials purchases budget determines quantities and expenditure on inputs. Labour and overhead budgets quantify conversion resources. Selling and administration budgets capture distribution and support activities. A capital budget identifies long-term asset acquisitions and disposals.

For a manufacturing business, the production requirement is:

All terms are measured in units. The formula assumes that finished-goods inventory is planned deliberately and that production is the relevant supply response. If inventory is not held, desired and opening inventories are zero.

Materials purchases are calculated as:

If material quantity per unit is m, production volume is Q_p, and purchase price per material unit is P_m, then:

The result is expressed in currency. This calculation assumes a constant material standard and purchase price; price changes should be modelled by period where relevant.

Worked example: functional budgets

Illustrative Manufacturing Ltd expects sales of 10,000 units in Quarter 1 and 12,000 units in Quarter 2. Desired ending finished-goods inventory equals 20% of the following quarter’s sales. Opening finished-goods inventory is 1,800 units. Each product requires 3 kg of material at £4 per kg. Desired ending materials inventory is 10% of the following quarter’s production material requirement, and opening materials inventory is 3,600 kg.

Quarter 1 production is:

10,000 + (20% × 12,000) − 1,800 = 10,600 units.

Material required for Quarter 1 production is 10,600 × 3 = 31,800 kg. If Quarter 2 production is 12,400 units, Quarter 2 material requirement is 37,200 kg. Desired ending Quarter 1 materials inventory is 10% × 37,200 = 3,720 kg. Therefore, Quarter 1 purchases are:

31,800 + 3,720 − 3,600 = 31,920 kg.

The purchase cost is 31,920 × £4 = £127,680. The schedule demonstrates why sales, inventory and purchasing budgets must be coordinated rather than prepared independently.

2. The master budget and cash budget

The master budget consolidates functional budgets. Its operating components commonly include a budgeted income statement, while its financial components include a cash budget and budgeted statement of financial position. The budgeted income statement reports expected revenues, costs and profit; it does not by itself demonstrate solvency.

The cash budget focuses on timing. A basic structure is:

Every term is measured in currency for the same period. Non-cash expenses, such as depreciation, are excluded from cash payments, although capital purchases and loan repayments are included. The cash budget is particularly sensitive to credit terms, tax dates, payroll timing, capital expenditure and seasonal demand.

A business may forecast accounting profit but still face a cash deficit because customers pay later, inventory is purchased in advance or capital investment is concentrated in one period. The cash budget therefore supports borrowing decisions, minimum cash policies and short-term investment decisions.

Cash collection example

Suppose January credit sales are £80,000 and February credit sales are £100,000. Customers pay 60% in the month of sale and 40% in the following month. February cash receipts from these sales are:

40% of January sales + 60% of February sales = £32,000 + £60,000 = £92,000.

This is a cash-flow calculation, not February revenue. The distinction is essential when preparing a cash budget.

3. Flexible budgets and performance evaluation

A fixed budget is prepared for one planned activity level. It is useful for planning but can be unfair for performance evaluation when actual activity differs materially from budget. A flexible budget recalculates variable costs for the actual activity level while retaining appropriate fixed-cost assumptions.

If F is total flexible-budget cost, a is fixed cost, b is variable cost per unit and Q is activity volume, then:

The formula assumes linear cost behaviour within the relevant range and a constant variable cost per unit. Step costs, mixed costs and nonlinear capacity effects require a more detailed model.

Worked example: flexible budget variance

A department budgeted for 5,000 service hours, with fixed costs of £30,000 and variable cost of £12 per hour. Actual activity was 5,500 hours and actual cost was £99,000.

The flexible budget is:

£30,000 + (£12 × 5,500) = £96,000.

The spending variance is £99,000 − £96,000 = £3,000 adverse. Comparing actual cost with the original fixed budget of £90,000 would show £9,000 adverse, but that difference combines the effect of higher activity with spending performance. Flexible budgeting provides the more meaningful control comparison.

Flexible budgets can also separate activity, spending and efficiency effects. However, managers should not be judged mechanically: a favourable cost variance may reflect poor quality, delayed maintenance or under-resourcing, while an adverse variance may represent an approved investment in service reliability.

4. Capital budgeting

Capital budgeting concerns long-term investments whose benefits and cash flows extend across several periods. Relevant cash flows are incremental, after-tax and associated with the decision. Sunk costs are excluded, while opportunity costs, working-capital effects, tax consequences and terminal proceeds are included where applicable.

The net present value (NPV) of an investment is:

Here, I₀ is the initial investment, CF_t is incremental cash flow in period t, r is the relevant discount rate, n is the project life and TV is terminal value. All cash flows must be measured in consistent currency units and the discount rate must match the risk, timing and tax basis of the cash flows. A positive NPV indicates value creation relative to the chosen discount rate, subject to model assumptions.

The internal rate of return is the discount rate that makes NPV equal to zero. Payback measures the time required to recover the initial investment but ignores cash flows after payback and, in its basic form, the time value of money. NPV is generally preferred for shareholder-value decisions, although strategic, environmental and resilience benefits may need additional evaluation.

5. Forecasting and uncertainty

A budget expresses an approved plan; a forecast is management’s current best estimate of the outcome. The budget normally remains a benchmark, while the forecast should change when evidence changes. Treating a forecast as a target can discourage honest reporting of emerging risks.

Forecasts may be qualitative, such as expert judgement or customer interviews, or quantitative, such as time-series, regression and driver-based models. A simple moving average for the next-period forecast is:

where A_t is actual demand in period t, k is the number of observations and F_(t+1) is the next forecast. The method assumes that recent observations provide useful information and that no strong trend or structural break invalidates the average.

Exponential smoothing gives greater weight to recent observations:

where 0 ≤ α ≤ 1. A high α responds quickly to new information but may be volatile; a low value is smoother but slower to recognise change. Forecast accuracy should be assessed out of sample where possible. Common measures include mean absolute deviation:

and mean absolute percentage error, provided actual values are not zero:

Forecast metrics do not replace judgement. A model can be statistically accurate in stable conditions yet fail after a regulatory change, supply disruption or change in customer behaviour.

6. Budgeting approaches

Incremental budgeting

Incremental budgeting starts with the prior budget or actual expenditure and adjusts it for expected changes. It is efficient where activities are stable and managers possess reliable historical information. Its weaknesses are the preservation of inefficiencies, automatic continuation of low-value activities and weak challenge of established assumptions.

Zero-based budgeting

Zero-based budgeting requires activities to be justified from a zero base rather than assuming continuation. Managers develop decision packages describing purpose, benefits, resources and consequences of alternative funding levels. It can reveal obsolete activities and improve prioritisation, but a full annual application may be costly, bureaucratic and disruptive. It is often most useful for selected cost categories or periodic strategic reviews.

Rolling budgets and forecasts

A rolling budget continuously extends the planning horizon. When one month or quarter ends, another is added. This maintains forward visibility and is valuable in volatile environments. It requires disciplined updating and should not become an administrative ritual. A rolling forecast is usually more appropriate for prediction, while a rolling budget may retain resource-authorisation functions.

Activity-based budgeting

Activity-based budgeting begins with expected outputs and the activities required to deliver them. Resource demand is derived from cost-driver volumes rather than broad percentage increases. For example, purchase orders, inspections, machine setups and customer contacts may drive overhead resources. It is particularly useful where overhead is significant and products consume support activities differently. Its limitations include data requirements, driver-measurement errors and the danger of treating estimated relationships as causal facts.

Beyond budgeting

Beyond-budgeting thinking challenges rigid annual targets, centralised control and fixed resource allocations. It emphasises relative performance, decentralised decision-making, continuous planning, transparent information and adaptive resource allocation. It does not mean abandoning numerical discipline. Organisations still require forecasts, investment cases, capacity plans and cash controls. The debate is therefore not “budgets or no budgets” but which planning and control mechanisms fit the organisation’s uncertainty, technology and governance needs.

7. Scenarios and sensitivity analysis

Scenario planning explores internally consistent combinations of assumptions, such as base, downside and upside cases. It is not the assignment of probabilities unless probabilities are explicitly estimated. Scenarios help management consider interactions: a recession may reduce volume, increase bad debts and lower supplier reliability simultaneously.

Sensitivity analysis changes one assumption at a time, holding others constant, to identify influential variables. If profit is:

then the sensitivity of profit to selling price, holding quantity and costs constant, is quantity. Sensitivity is not the same as uncertainty: a variable may be highly influential but relatively predictable, or less influential but highly uncertain.

Break-even quantity is:

This assumes constant unit price and variable cost, fixed costs within the relevant range and a constant sales mix for multi-product operations. For a portfolio, the contribution margin must be based on an assumed sales mix.

Management should combine sensitivity tables, scenario narratives, stress tests and reverse stress tests. A reverse stress test asks which combination of adverse conditions would make liquidity, covenant compliance or strategic viability unacceptable.

8. Integrated case: Northstar Components Ltd

Background

Northstar Components Ltd manufactures industrial sensors. Demand is growing, but customers pay after 60 days. The company is considering a £600,000 automated testing system and must prepare a six-month plan. The finance director is concerned that the annual budget hides a cash shortage during installation.

Problem

The sales team forecasts monthly sales of £300,000 in months 1–3 and £360,000 in months 4–6. Sixty per cent of sales are collected in the month of sale and 40% in the following month. Variable manufacturing cost is 50% of sales and is paid one month after production. Monthly fixed cash operating costs are £70,000. The system is purchased for £600,000 in month 3. Opening cash is £250,000 and the minimum desired balance is £100,000.

Analysis and approach

Cash receipts are £180,000 in month 1, because there are no assumed prior-period collections in this simplified illustration. Month 2 receipts are £180,000 + £120,000 = £300,000. Month 4 receipts are £216,000 + £120,000 = £336,000. Production is assumed to match sales and inventory is ignored for this cash illustration. Variable cash payments in month 2 equal 50% of month 1 sales, or £150,000; in month 4 they equal 50% of month 3 sales, or £150,000.

For month 3, cash before financing is opening cash £250,000 plus receipts £300,000, less variable payment £150,000, fixed costs £70,000 and capital expenditure £600,000. The resulting balance is £−£270,000. To maintain the £100,000 minimum, Northstar requires financing of £370,000 in month 3, before interest and financing fees.

The finance team should then prepare a full master budget, including tax, depreciation, working capital, debt service and the system’s incremental benefits. The capital investment should be evaluated using NPV rather than accounting profit alone. Scenarios should test lower demand, delayed collections, cost inflation and implementation delays. A rolling forecast should be updated monthly, while the approved capital budget should remain subject to stage-gate approval.

Outcome and learning points

The cash budget exposes a liquidity requirement that the income statement may obscure. The investment decision and financing decision are connected but analytically distinct. Northstar should establish explicit assumptions, assign ownership for each driver, monitor forecast error and use trigger points for corrective action. For example, a delay in collections beyond 60 days could trigger tighter credit control or a revised borrowing drawdown.

This illustrative case also demonstrates that budget preparation is a cross-functional process. Sales assumptions affect production, production affects procurement, procurement affects cash timing, and capital expenditure affects both financing and operating capacity.

9. Governance, behaviour and technology

Budgets influence behaviour because rewards, promotions and resource access may depend on budget performance. Common dysfunctional practices include padding estimates, postponing necessary expenditure, accelerating sales, reducing maintenance and negotiating easily achievable targets. Participative budgeting can improve information quality and commitment, but participation may also create slack. Effective governance separates forecasting from target-setting where possible, documents assumptions and reviews performance using controllable as well as uncontrollable factors.

A sound budget process should include an assumptions register, approval authority, version control, audit trails, segregation of duties and a clear variance-investigation policy. Ethical issues include deliberately biased forecasts, selective disclosure of downside risks, manipulation of cut-off dates and investment cases that omit adverse externalities. Professional accountants should communicate uncertainty rather than present estimates as facts.

Enterprise resource planning systems, driver-based planning platforms and business intelligence tools can connect operational data with financial plans. Artificial intelligence may assist demand forecasting, anomaly detection and scenario generation. However, AI outputs require governance: data quality, model drift, explainability, access control, privacy and human review are essential. Historical data may encode discrimination or outdated relationships, and automated forecasts can create false confidence. Technology improves speed and consistency; it does not remove managerial accountability.

10. Best-practice framework

A mature budgeting and forecasting system should:

• begin with strategy and identify the principal constraint;
• distinguish targets, budgets, forecasts and scenarios;
• use operational drivers rather than arbitrary percentage changes;
• integrate profit, cash, capacity, risk and capital investment;
• use flexible budgets for performance assessment;
• update forecasts when evidence changes;
• combine financial and non-financial measures such as quality, lead time, safety and customer retention;
• document assumptions and ownership;
• test downside scenarios and liquidity resilience;
• review behavioural consequences and ethical risks;
• use technology with controls, transparency and professional judgement.

Chapter Summary

Budgeting translates strategy into coordinated resource and financial plans. Functional budgets include sales, production, materials, labour, overhead, selling, administration and capital expenditure schedules. These are consolidated into a master budget containing a budgeted income statement, cash budget and budgeted financial position.

Cash planning is distinct from profit planning because the timing of receipts and payments determines liquidity. Flexible budgets improve performance evaluation by adjusting variable costs to actual activity. Capital budgeting should focus on incremental, after-tax cash flows and commonly uses NPV, supported by risk and strategic analysis.

Forecasts are updated estimates, whereas budgets are approved plans or benchmarks. Moving averages and exponential smoothing can support forecasting, but structural change and managerial judgement remain important. Incremental, zero-based, rolling, activity-based and beyond-budgeting approaches have different strengths and limitations. Scenario planning examines coherent alternative futures, while sensitivity analysis identifies the effect of changing individual assumptions. Effective systems integrate strategy, operations, cash, risk, technology, governance and ethical accountability.

Key Terms

Budget: A quantified plan for a defined future period.

Forecast: Management’s current estimate of a future outcome.

Master budget: Consolidated operating and financial budget.

Functional budget: Budget prepared for a specific organisational function.

Principal budget factor: Constraint that limits the organisation’s plans.

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

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

Capital budget: Plan for long-term investments and asset disposals.

Incremental budgeting: Budgeting based on prior amounts plus adjustments.

Zero-based budgeting: Justification of activities and resources from a zero base.

Rolling budget: Budget continuously extended by adding a new future period.

Activity-based budgeting: Budgeting resources from expected activities and cost drivers.

Beyond budgeting: Adaptive management approach challenging rigid annual budgets.

Scenario analysis: Evaluation of internally consistent alternative futures.

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

Net present value: Present value of incremental cash inflows less investment and outflows.

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

Driver-based planning: Planning based on operational factors that cause financial outcomes.

Review Questions

Short Answer Questions

1. Distinguish a budget from a forecast.
2. What is the principal budget factor?
3. Why is a flexible budget useful in performance evaluation?
4. State two differences between scenario and sensitivity analysis.
5. Why can a profitable organisation experience a cash deficit?

Long Answer Questions

1. Explain how functional budgets are integrated into a master budget.
2. Critically evaluate incremental, zero-based and rolling budgeting.
3. Discuss the assumptions and limitations of NPV in capital budgeting.
4. Explain how budgeting can create dysfunctional managerial behaviour and how governance can reduce it.
5. Evaluate the potential contribution and risks of AI-enabled forecasting.

Analytical / Application Questions

1. A company plans sales of 8,000 units, wants ending inventory of 1,200 units and has opening inventory of 900 units. Calculate required production and explain how the result changes if demand is uncertain.
2. Fixed costs are £45,000 and contribution per unit is £15. Calculate break-even volume and discuss two limitations of the calculation.
3. Design a three-scenario cash-planning framework for a business facing delayed customer collections, rising input prices and a proposed capital investment.

Multiple Choice Questions with Answers

Question 1

Which budget normally provides the starting point for a manufacturing master budget?

A. Sales budget

B. Cash budget

C. Capital budget

D. Administration budget

Correct Answer: A. Sales budget

Question 2

A company has budgeted fixed costs of £30,000 and variable costs of £12 per service hour. At 5,500 hours, what is the flexible budget cost?

A. £90,000

B. £96,000

C. £99,000

D. £102,000

Correct Answer: B. £96,000

Question 3

Which item is generally excluded from a cash budget because it is non-cash?

A. Loan repayment

B. Capital expenditure

C. Depreciation

D. Payroll payment

Correct Answer: C. Depreciation

Question 4

If sales are 10,000 units, desired ending inventory is 2,000 units and opening inventory is 1,500 units, required production is:

A. 8,500 units

B. 10,000 units

C. 10,500 units

D. 13,500 units

Correct Answer: C. 10,500 units

Question 5

What is the principal advantage of NPV over basic payback?

A. It ignores cash flows after recovery

B. It incorporates the time value of money and later cash flows

C. It requires no discount rate

D. It measures accounting profit directly

Correct Answer: B. It incorporates the time value of money and later cash flows

Question 6

Which approach requires activities to be justified from a zero base?

A. Incremental budgeting

B. Rolling budgeting

C. Zero-based budgeting

D. Flexible budgeting

Correct Answer: C. Zero-based budgeting

Question 7

A rolling forecast is best described as one that:

A. Remains unchanged after approval

B. Continuously extends the forecast horizon

C. Includes only cash transactions

D. Excludes uncertain assumptions

Correct Answer: B. Continuously extends the forecast horizon

Question 8

Sensitivity analysis usually changes:

A. All assumptions simultaneously

B. One assumption while holding others constant

C. Only historical data

D. The accounting period only

Correct Answer: B. One assumption while holding others constant

Question 9

If selling price is £50, variable cost is £30 and fixed cost is £40,000, break-even volume is:

A. 800 units

B. 1,333 units

C. 2,000 units

D. 4,000 units

Correct Answer: C. 2,000 units

Question 10

Which is a key governance risk in AI-enabled forecasting?

A. The elimination of all uncertainty

B. Model drift and poor-quality training data

C. Guaranteed unbiased predictions

D. Removal of the need for human review

Correct Answer: B. Model drift and poor-quality training data