Â
This lesson delves deeper into the quantitative forecasting techniques introduced in Lesson 4.4, focusing on their practical application in management accounting. It examines the mechanics and limitations of regression analysis and learning curves.
Â
-
Simple and Multiple Regression Analysis: Simple linear regression is a statistical tool for modelling the relationship between two variables (e.g., sales and advertising). The formula for a simple linear regression is Y = a + bX, where Y is the dependent variable (e.g., sales), X is the independent variable (e.g., advertising spend), ‘a’ is the intercept (the fixed element), and ‘b’ is the slope (the variable element) . Multiple regression extends this to include two or more independent variables (e.g., advertising and price). It is used to create more accurate forecasts by considering multiple drivers. The key limitation is that the analysis must be based on a valid underlying relationship, and it does not prove causation.
-
Learning Curve Analysis: The learning curve is based on the observation that the time required to produce a unit decreases by a constant percentage (e.g., 80% learning curve) as the cumulative number of units doubles. The cumulative average-time learning model and the incremental unit-time learning model are the two main approaches for calculating the effect of learning on total time . This is particularly useful in industries like aerospace, shipbuilding, and electronics.
-
Application of Forecasting Techniques: Regression is also used to separate mixed costs into their fixed and variable elements, which is a prerequisite for flexible budgeting. Time series analysis, using methods like moving averages, is a simpler alternative for forecasting when trends are stable. Expected value analysis is a valuable tool for quantifying risk and uncertainty in the budget, as it allows managers to see not just a single most likely outcome, but a range of possible outcomes weighted by their probability .