Management Accounting · Forecasting, Budgeting and Budgetary Control
Forecasting Techniques and Methods for CMA Intermediate
Updated 10 October 2026 · Fact-checked
Forecasting is the estimate of what is likely to happen in future, such as sales or costs, using judgement or past data. A budget is a plan of what you intend to achieve. To solve problems, identify the data, pick the method (moving average, trend line or regression), compute, and state the forecast.
Understand Forecasting Techniques and Methods
A forecast is a prediction of future events based on past data, current conditions and judgement. It answers the question: what is likely to happen? Sales next year, demand for a product and raw material prices are common examples.
A budget is a detailed plan, expressed in numbers, of what management intends to do and achieve. It answers: what do we want to happen, and how will we make it happen? Forecasting comes first. The sales forecast is the base on which the sales budget, and then all other budgets, are built.
- Forecast: a prediction; covers uncertain factors; may include several possible outcomes; not binding on anyone.
- Budget: a target and plan; linked to responsibility; fixed for a period; used for control by comparing actuals.
Forecasting methods fall into two groups. Qualitative methods rely on opinion and judgement. Use them when past data is missing or unreliable, for example a new product. Examples are the Delphi method (a panel of experts gives views in rounds, anonymously, until opinions converge), sales force opinion, executive opinion and market surveys.
Quantitative methods use numbers. Time series analysis studies past values over time and splits them into trend, seasonal variation, cyclical variation and random (irregular) variation. Moving averages smooth out short-term swings to show the trend. Regression analysis finds a relationship between a dependent variable (such as sales) and an independent variable (such as advertising spend), then uses it to predict.
No method is exact. Quantitative methods assume the past pattern continues. Always treat the output as an estimate, and revise it when conditions change.
Key rules to remember
- Simple moving average (n periods)
- Moving average = (sum of n consecutive period values) ÷ n
- Place each average against the middle period if n is odd. For an even n, centre it by averaging two successive averages.
- Linear trend line
- Y = a + bX
- Y is the forecast value, X is the time period (or the independent variable), a is the intercept and b is the slope.
- Regression slope (least squares)
- b = (nΣXY − ΣX·ΣY) ÷ (nΣX² − (ΣX)²)
- n is the number of pairs of observations.
- Regression intercept
- a = (ΣY − b·ΣX) ÷ n
- Equivalent to a = Ȳ − b·X̄.
- Trend by deviation from mean time (X taken from the middle)
- When ΣX = 0: a = ΣY ÷ n and b = ΣXY ÷ ΣX²
- Useful shortcut for time series with coded time values.
- Time series components
- Y = T + S + C + R (additive model)
- T is trend, S seasonal, C cyclical, R random. A multiplicative model uses Y = T × S × C × R.
How to solve Forecasting Techniques and Methods questions
Use this order for any forecasting question. It keeps working clear so you earn step marks even if one figure is wrong.
- 1Read what is asked: a forecast value, the trend, a moving average series or a theory difference.
- 2Identify the data type: time-based data points to moving average or trend; two related variables point to regression.
- 3Set up a working table with columns for X, Y, XY and X² (regression), or for period totals and averages (moving average).
- 4For regression, code X to make ΣX = 0 where the periods are equally spaced; this shortens the work.
- 5Compute the totals, then b, then a, and write the equation Y = a + bX.
- 6Substitute the required X value to get the forecast, and state the unit and period clearly.
- 7Add a one-line comment: the assumption that the past pattern continues, and that the figure is an estimate.
Quickest way: Coded-time trend line
When to use it: Use when the question gives an odd number of equally spaced years and asks for a trend line or a future forecast.
- Take the middle year as X = 0, and number the others as −2, −1, 0, 1, 2 (for five years).
- Because ΣX = 0, compute a = ΣY ÷ n.
- Compute b = ΣXY ÷ ΣX².
- Write Y = a + bX.
- For a forecast, find the coded X for the target year by counting years from the middle year, and substitute.
Common mistakes in Forecasting Techniques and Methods
Treating a forecast and a budget as the same thing.
Both deal with future figures, so they look alike.
Fix: Say that the forecast is a prediction and the budget is a plan with targets and responsibility. Write at least two differences in the theory answer.
Placing moving averages against the wrong period.
Students write the average against the first period of the group.
Fix: For a 3-period average, place it against the middle period. For an even period, centre it by averaging two consecutive averages.
Using the wrong X when forecasting from coded time.
The coded year numbers are miscounted after shifting the origin.
Fix: Write the coded values next to the years. Count the gap from the X = 0 year to the target year.
Applying the shortcut b = ΣXY ÷ ΣX² when ΣX is not zero.
The shortcut is memorised without its condition.
Fix: Use the shortcut only when ΣX = 0. Otherwise use the full normal-equation formula.
Using qualitative methods for data-rich problems, or quantitative methods for a new product with no history.
Students do not link the method to the data available.
Fix: State that qualitative methods suit situations without past data, and quantitative methods need reliable historical data.
Giving a forecast as a certain figure.
The answer ends at the number.
Fix: Write that the figure is an estimate that assumes the past trend continues.
Worked examples
Example 1
Sales (₹ lakh) of a firm for six years are: Year 1: 20, Year 2: 24, Year 3: 22, Year 4: 28, Year 5: 26, Year 6: 30. Calculate the three-year moving averages and state the trend.
Show the solution
- Years 1-3 total: 20 + 24 + 22 = 66. Average = 66 ÷ 3 = 22. Place against Year 2.
- Years 2-4 total: 24 + 22 + 28 = 74. Average = 74 ÷ 3 = 24.67. Place against Year 3.
- Years 3-5 total: 22 + 28 + 26 = 76. Average = 76 ÷ 3 = 25.33. Place against Year 4.
- Years 4-6 total: 28 + 26 + 30 = 84. Average = 84 ÷ 3 = 28. Place against Year 5.
- The averages rise from 22 to 28, so the short-term ups and downs are smoothed out and an upward trend shows.
Answer: Three-year moving averages (₹ lakh): Year 2: 22, Year 3: 24.67, Year 4: 25.33, Year 5: 28. The trend is upward.
Example 2
A company's sales (₹ lakh) for five years are: 2022: 40, 2023: 44, 2024: 50, 2025: 54, 2026: 62. Fit a straight-line trend and forecast sales for 2028.
Show the solution
- Take 2024 as the origin. Coded X: 2022 = −2, 2023 = −1, 2024 = 0, 2025 = 1, 2026 = 2. So ΣX = 0.
- ΣY = 40 + 44 + 50 + 54 + 62 = 250. n = 5.
- ΣXY = (−2×40) + (−1×44) + (0×50) + (1×54) + (2×62) = −80 − 44 + 0 + 54 + 124 = 54.
- ΣX² = 4 + 1 + 0 + 1 + 4 = 10.
- a = 250 ÷ 5 = 50. b = 54 ÷ 10 = 5.4.
- Trend line: Y = 50 + 5.4X.
- For 2028, X = 4. Y = 50 + 5.4 × 4 = 50 + 21.6 = 71.6.
Answer: Trend line: Y = 50 + 5.4X (X = 0 in 2024). Forecast sales for 2028 = ₹71.6 lakh, assuming the past trend continues.
Exam tips
- In theory questions, give the forecast vs budget difference as a short point-wise list. Four points are enough.
- In numerical questions, always show the working table. Examiners award marks for ΣXY, ΣX² and the equation even if the final answer is off.
- Use coded time whenever the periods are equally spaced. It saves time and reduces errors.
- For MCQs, remember what each method suits: Delphi is qualitative, moving average smooths data, regression links two variables.
- End every forecast with a note on its assumption. It costs one line and shows understanding.
Practice questions from Forecasting, Budgeting and Budgetary Control
- A Nashik firm fits a least squares line Y = a + bX to quarterly sales, where X is the quarter number. It finds a = 400 units and b = 25 unit…
- Sharma Plastics budgets for 10,000 units: variable cost Rs 30 per unit, fixed cost Rs 2,00,000. If the budget is flexed to 12,000 units, the…
- Which budget is normally prepared first when sales demand is the limiting (principal budget) factor of Gupta Traders Ltd.?
- Mehta Components Ltd budgets production of 8,000 units. Each unit needs 3 kg of raw material. Opening raw material stock is 2,500 kg and the…
- Ananya Appliances budgets sales of 6,000 units at Rs 500 each. Variable cost is Rs 300 per unit and fixed production overhead is Rs 4,00,000…
Forecasting Techniques and Methods in other exams
The same ground in other exams, if you are preparing for more than one or want another angle on it.
Forecasting Techniques and Methods: frequently asked questions
What is the difference between a forecast and a budget?
A forecast predicts what is likely to happen. A budget is a plan of what management wants to achieve and is tied to responsibility and control. The forecast is usually prepared first and feeds into the budget.
Which forecasting methods are important for CMA Intermediate?
Know qualitative methods such as the Delphi method, executive opinion and market surveys. For numbers, focus on moving averages, trend lines by least squares and simple regression.
How do I calculate a three-period moving average?
Add three consecutive values and divide by 3. Place the result against the middle period. Then move one period forward and repeat.
When should I use regression instead of time series?
Use time series when the forecast depends only on past values over time. Use regression when the variable you forecast depends on another variable, such as sales on advertising spend.
Is forecasting always accurate?
No. Forecasts rest on assumptions, and conditions change. Treat the result as an estimate and revise it when new information arrives.