Chapter 6: Calculating Forecasts
Using historical patterns and sensitivity analysis to support forecasts and recommendations
About this Chapter
The forecasting techniques assessed within LO 4.4 are covered here. The chapter examines time series, trend and seasonal variation, moving averages, simple regression, index numbers and probability-weighted expected values. It also considers how past data can be projected and why forecasts remain dependent on assumptions about future conditions. Sensitivity analysis is used to compare how changes in key assumptions affect an outcome, with interpretation and recommendation treated as part of the forecasting task rather than an optional extra.
Study Guide Highlights
Trend and seasonal patterns
Time-series analysis separates recurring patterns from the underlying direction of the data. Trend and seasonal variation receive particular attention, along with the role of moving averages in smoothing short-term fluctuations so that the trend is easier to see. Additive seasonal effects, expressed as amounts, are distinguished from multiplicative effects, expressed proportionately, because the form of the data determines the appropriate interpretation.
Regression and linear relationships
Simple regression is used to describe a broadly linear relationship between variables and to support estimation where that relationship is sufficiently stable. A line inferred from a wider data set is distinguished from a line derived from only two points. Forecast use therefore depends not only on obtaining a line, but also on considering whether the data pattern and surrounding conditions make that line credible.
Index numbers and expected values
Index numbers provide a common base for comparing changes over time and can be used to adjust or interpret monetary data. The concept of an expected value as a probability-weighted outcome is also introduced. Both techniques require careful interpretation: an index depends on its base and comparison point, while an expected value summarises uncertainty rather than describing an outcome that must actually occur.
Sensitivity and forecast reliability
Forecasts can be useful without being certain. The chapter considers the dependence of forecasting methods on historical patterns, data quality and stable relationships, then uses sensitivity analysis to show how changes in important assumptions affect the result. The emphasis is on identifying material exposure and linking a recommendation to the evidence, rather than treating a single base-case forecast as a guaranteed future outcome.
Before using moving averages, identify the number of periods in the repeating cycle. An even-length cycle needs centring, while an odd-length cycle aligns differently with the underlying observations.
When asked about forecast limitations, link the answer to the assumptions behind the technique, especially the continuation of past patterns. Identify what could change and why that would weaken the forecast.
Chapter Resources
Slides for this chapter.
PPT coming soon
PowerPoint SlidesCourse Navigation
- 01 Activity Based Costing
- 02 Target Costing and Life Cycle Costing
- 03 Limiting Factor Analysis
- 04 Linear Programming
- 05 Short-Term Decision Making
- 06 Calculating Forecasts Current
- 07 Introduction to Budgeting
- 08 Budgeting Processes
- 09 Further Aspects of Budgeting
- 10 Standard Costing and Variances
- 11 Performance Measurement and Control
- 12 Divisional Performance
- 13 Long-Term Decision Making
- 14 Impact of Technology