Strategic Management Accounting and Decision Support
Cost Behavior Analysis
Deconstructing Mixed Costs
In the real world, costs rarely fit neatly into the fixed or variable categories we've discussed. Many costs have a dual nature. Think about your company's utility bill. There's often a fixed monthly service charge just for being connected to the grid, plus a variable charge that goes up with every kilowatt-hour of electricity you use. This is a classic mixed cost.
For managers, simply labeling this entire expense as "utilities" isn't enough. To budget accurately, make pricing decisions, or decide whether to invest in new equipment, you need to break these mixed costs down into their fixed and variable components. Understanding this behavior allows you to predict how costs will change as your business activity fluctuates.
Mixed Cost
noun
A cost that contains both fixed and variable components. It has a baseline fixed portion and a variable portion that changes with the level of activity.
The fundamental goal is to express any mixed cost using a simple linear equation. This equation, known as a cost function, forms the bedrock of cost-volume-profit analysis and predictive modeling.
By determining the values for (fixed cost) and (variable rate), you can plug in any activity level to predict the total cost . Let's explore two common methods for finding these values.
Methods for Separation
Two primary techniques are used to split mixed costs: the high-low method, which is quick and simple, and least-squares regression, which is more precise.
The High-Low Method: A Quick Estimate
The high-low method is a straightforward approach that uses only two data points—the highest and lowest activity levels—to estimate the cost function. While it's easy to apply, be aware that it ignores all other data points and can be skewed by unusual highs or lows (outliers).
Here’s how it works. First, you identify the periods with the highest and lowest levels of activity from your data set. Note the total costs associated with each of those periods. Then, calculate the variable cost per unit () using the change in cost and the change in activity between these two points.
Once you have the variable cost per unit (), you can solve for the total fixed cost () by plugging the high or low data point back into the cost function equation and isolating .
Let's look at an example. A factory has the following maintenance cost data for the last six months:
| Month | Machine Hours (X) | Total Cost (Y) |
|---|---|---|
| Jan | 6,000 | $9,500 |
| Feb | 7,500 | $10,500 |
| Mar | 9,000 | $12,000 |
| Apr | 5,000 | $8,000 |
| May | 8,500 | $11,250 |
| Jun | 10,000 | $13,000 |
The highest activity is 10,000 hours in June (costing $13,000), and the lowest is 5,000 hours in April (costing $8,000). The variable rate is:
per machine hour.
Now, solve for the fixed cost using the high point:
.
The factory's maintenance cost function is .
Least-Squares Regression: A More Precise Approach
While the high-low method is fast, least-squares regression analysis is a more statistically sound technique. It uses all the available data points to find a line of best fit that minimizes the sum of the squared distances from each data point to the line. This approach provides a more reliable cost function because it's not distorted by a single high or low outlier.
Today, you don't need to do the complex calculations by hand. Software like Microsoft Excel or statistical packages can run a regression analysis in seconds. The key is knowing how to interpret the output.
When you run a regression, you'll get several outputs, but the most important for our purpose are the 'Intercept' (which is your fixed cost, ) and the coefficient for your activity variable (which is your variable cost per unit, ). You'll also get a value called 'R-squared', which tells you how well the line fits the data. An R-squared value close to 1.0 indicates a very strong fit, meaning your cost function is a reliable predictor.
Beyond the Straight Line
While a linear model () is powerful, not all costs behave so predictably. Two other common patterns are step costs and curvilinear costs.
Step-Variable and Step-Fixed Costs
Some costs are fixed over a small range of activity but jump to a new fixed level once that range is exceeded. These are called step costs.
-
Step-Variable Costs: These costs increase in small steps. For example, if one quality inspector can handle 1,000 units per day, you need to hire a second inspector as soon as production hits 1,001 units. The cost of inspection is fixed for 1-1,000 units, then jumps to a new fixed level for 1,001-2,000 units.
-
Step-Fixed Costs: These costs are fixed over a much wider range of activity. For instance, a factory might operate with one production supervisor, but if the company opens a second shift, it must hire another supervisor, doubling the supervision cost. The cost is fixed over the entire range of a single shift's capacity.
The key distinction is the width of the steps. If the steps are narrow, step-variable costs can often be approximated as a purely variable cost for modeling purposes. If the steps are wide, they should be treated as fixed costs within their relevant range.
Curvilinear Costs
A curvilinear cost shows a curved relationship with activity, not a straight line. Often, this is due to economies of scale. For example, the total cost of materials might increase as you produce more, but the cost per unit might decrease because you get bulk discounts. This creates a cost curve that flattens out at higher activity levels.
For practical purposes, within a company's normal operating range (the relevant range), a curved cost line is often so close to a straight line that a linear approximation is accurate enough for decision-making. Managers focus on the segment of the curve where the company typically operates, rather than the entire theoretical curve.
Cost Structure and Risk
The mix of fixed and variable costs in a company is called its cost structure. This structure has a major impact on a company's risk and profitability.
A company with high fixed costs and low variable costs (e.g., a highly automated factory or a software company) has high operating leverage. This means a small change in sales can produce a dramatic change in profits. When sales are high, profits soar because most costs are already covered. But when sales dip, the company is still stuck with its large fixed costs, and profits can vanish quickly.
Conversely, a company with low fixed costs and high variable costs (e.g., a merchandising business that buys and resells goods) has low operating leverage. Its profits are more stable but won't grow as explosively during a boom. This cost structure is generally less risky.
Cost behavior refers to the way in which a specific cost reacts to the changes in the levels of activity.
Understanding your company's cost behavior is not just an accounting exercise. It's a fundamental part of strategic management that informs everything from pricing and production levels to long-term investment decisions.
What is the primary goal of separating a mixed cost into its fixed and variable components?
A primary weakness of the high-low method is that it:
With these analytical tools, managers can move beyond simply recording costs to actively predicting and controlling them.