Cost Behavior Analysis
Comparing costs and activities
Comparing costs and activities
Cost behavior analysis refers to management’s attempt to understand how operating costs change in relation to a change in an organization’s level of activity. These costs may include direct materials, direct labor, and overhead costs that are incurred from developing a product. Management typically performs cost behavior analysis through mathematical cost functions.
Cost functions are descriptions of how a cost (i.e. material, labor, or overhead) changes with changes in the level of activity relating to that cost. For example, total variable costs will change in relation to increased activity, while fixed costs will remain the same. Cost functions may come in various forms.
To learn more, launch our financial analysis courses!
Cost functions are usually given in the form of y = mx + b and can be plotted on a graph.
In order to determine these cost functions, managers typically make the following assumptions for simplicity purposes:
The relevant range here refers to the range of activity in which the relationship between the total cost and the level of activity is maintained. However, in real life situations, not all cost functions are linear and also are not explained by a single cost driver.
To learn from video-example, take our financial analysis courses!
It is common for management to use quantitative analysis methods to illustrate cost functions. The simplest approach is the high-low method. This method uses only the highest and lowest values of the cost driver and its respective costs to determine the cost function.
Although there are many limitations to this approach, it is a simple first attempt at examining the relationship between the cost driver and the overall costs.
Regression analysis is another method that uses statistical methods to measure the average amount of change in the dependent variable associated with changes in the independent variable. The regression approach is a much better indication of the relationship between the variables. Software such as Microsoft Excel is a useful tool for performing regression analysis.
XYZ Company would like to examine how overhead costs behave with changes in labor hours:
Month | Total Overhead Costs | Labor Hours |
March | $50,000 | 2,000 |
April | 70,000 | 3,000 |
May | 55,000 | 1,500 |
June | 65,000 | 3,500 |
July | 55,000 | 1,000 |
August | 65,000 | 2,000 |
September | 45,000 | 1,500 |
October | 80,000 | 4,000 |
November | 55,000 | 2,500 |
December | 60,000 | 2,500 |
Here is the cost data tha was observed:
Hours | Cost | |
Highest Observation | 4,000 | $80,000 |
Lowest Observation | (1,000) | (55,000) |
Difference | 3,000 | 25,000 |
Slope or Variable Cost: 25,000/3,000 = $8.33
Y Intercept or Fixed Cost: $46,667
Therefore, the full cost function is: Y = 8.33x + 46,667. This means that for every additional labor hour, total overhead costs will increase by $8.33.
See more examples in our financial analysis fundamentals course.
Under regression cost behavior analysis, the approach is fairly similar, but instead, uses all data points instead of just the highest and lowest values.
Using the regression function in MS Excel, we can obtain an ANOVA output that gives a cost function of Y = 8.72x + 39,502.
This means that for every additional labor hour, the total overhead costs will increase by $8.72 and if there are no labor hours, the total overhead costs would just be equal to the fixed cost of $39,502.
Under the regression approach, we can analyze the cost function using several criteria:
Economic Plausibility | Degree of Fit | Confidence | |
Main Concept | Is it plausible that the total overhead costs are affected/determined by labor hours? | Determined by the R squared value of the regression output. The higher the number, the greater the change in the dependent variable can be explained by the independent variable. | Relationship between the standard error and the intercept (fixed cost) and the x variable (variable cost) |
Analysis of Example | It does appear logical that total overhead costs and labor hours are related. | R squared is 0.64. So, 64% of the change in overhead costs can be explained by the change in labor hours. | With a T-stat greater than 2, the relationship is acceptable. |
Learn about regression analysis in our financial math course!
Enter your name and email in the form below and download the free template now!
In the content above, we examined two methods of analyzing linear relationships. However, many companies often examine the relationship between multiple independent variables on a single dependent variable.
Frequently, companies may also conduct analyses on each variable and then do the combined analysis to further examine the effects of each independent variable on the dependent variable. The general takeaway is that there are many different ways of analyzing cost behavior data within a company and it is up to management to decide how in depth they intend to take the analysis.
In a world that is shifting to a more data and technology-based economy, analyzing data in various ways will prove to be beneficial to companies if they are able to implement the proper and necessary measures.
Learn financial analysis online now!
This has been an introductory guide to cost behavior analysis. To keep learning and advancing your career, please see the additional resources below:
Learn accounting fundamentals and how to read financial statements with CFI's free online accounting classes. These courses will give the confidence you need to perform world-class financial analyst work. Start now!
Building confidence in your accounting skills is easy with CFI courses! Enroll now for FREE to start advancing your career!