Cost Behavior Analysis in Financial Projections

Costs can be classified by many characteristics such as nature or function, but one of the most important from the point of view of developing financial projections is the cost behavior classification.

The term cost behavior refers to the manner in which a cost will change in relation to the volume of production or selling activity of the business.

Variable Cost Behavior Example

Variable costs are costs which will change in direct proportion to any production or selling activity.

Examples which fall within the variable cost behavior definition are direct materials, direct labor and sales commissions.
The total variable cost is calculated using the variable cost formula which multiplies the unit variable cost by the number of units of activity.
Variable cost = Unit variable cost x Number of units

So for example, if the costs of a motor vehicle include variable costs of 0.60 per mile traveled for fuel and other costs, then the total variable cost for two different levels of annual mileage of 5,000 and 12,000 miles would be calculated as follows:

Variable cost = Unit variable cost x Number of units
Variable cost = 0.60 x 5,000 = 3,000
Variable cost = 0.60 x 12,000 = 7,200
The total variable cost changes as the level of activity changes.
Assuming that the unit variable cost remains constant over the level of activity considered, then the variable cost behavior graph below shows how the total variable cost changes with the number of units.

cost behavior variable cost graph

It should be noted that the unit variable cost does not need to remain constant and in most situations will change as the activity level changes.

Financial Template Variable Cost Behavior

The variable costs definition for use in the financial projections template is costs which vary with the level of output of the business.

Variable costs are usually included as part of the cost of sales figure in the income and expenditure statement as this allows a realistic gross margin and break even sales point to be calculated.

Fixed Cost Behavior Example

Fixed costs are costs which are incurred whether or not a business has any production or sales activity. Fixed costs are a function of the passage of time and are sometimes referred to as periodic costs for this reason.

Examples of costs which fall within the fixed costs definition are rent, insurance and general and administration salaries.

The fixed cost behavior graph below shows a business with total fixed costs of 4,000. The total fixed cost remains constant over the level of activity considered.

cost behavior fixed cost graph

It should be noted that fixed costs are only fixed over a range of activity and tend to take steps up or down between activity level ranges. For example, if a business rents a new manufacturing unit then the level of output will increase and the range of activity and the fixed cost will change to a new level and follow a step cost behavior.

Fixed Cost Per Unit

The fixed cost per unit can be calculated using the fixed cost formula which divides the total fixed cost by the number of units.

Fixed cost per unit = Total fixed costs / Number of units

The fixed cost per unit will change as the level of activity changes. So for example, if the costs of a motor vehicle include fixed costs of 4,000 for items such as insurance, then the fixed cost per unit for the two annual mileages of 5,000 and 12,000 miles would be calculated as follows:

Fixed cost per unit = Total fixed costs / Number of units
Fixed cost per unit = 4,000 / 5,000 = 0.80 
Fixed cost per unit = 4,000 / 12,000 = 0.33

Financial Template Fixed Cost Behavior

The fixed costs definition for use in the financial projections template is costs that do not vary with the level of output from the business.

Fixed costs are normally included as part of operating expenses in the income and expenditure statement.

Mixed Cost Behavior Example

In reality most costs have a variable and a fixed element. For example, employees cannot be hired and fired to suit production levels, and so labor costs have a fixed component independent of production or sales levels.

Costs which have a variable and fixed component are referred to as mixed costs or semi-variable costs.

Mixed cost = Variable cost + Fixed cost

Mixed Costs Analysis

When preparing financial projections mixed costs need to be separated into their variable and fixed cost components in order that they can be correctly forecast as the activity level of the business changes.

Assuming the unit variable cost and the total fixed cost remain constant over the range of activity being considered then the mixed cost formula or semi variable cost formula can be used to calculate the total mixed cost.

Mixed cost = Unit variable cost x Number of units + Fixed cost

So for example, if the costs of a motor vehicle include fixed costs of 4,000 for items such as insurance, and variable costs of 0.60 per mile for fuel and other costs, then the total mixed cost for two different annual mileages of 5,000 and 12,000 miles would be calculated as follows:

Unit variable cost = 0.60 per mile
Total fixed costs = 4,000
Mixed cost = Unit variable cost x Number of units + Fixed cost
Mixed cost = 0.60 x 5,000 + 4,000 = 7,000
Mixed cost = 0.60 x 12,000 + 4,000 = 11,200

The cost behavior graphs below shows how the total mixed cost changes with the number of units.

cost behavior mixed cost graph

Use of the High-Low Method to Determine Mixed Cost Components

When preparing financial projections, if historical information is available on costs, then a technique called the high-low method can be used to calculate the unit variable cost and the total fixed cost components of a mixed cost.

Suppose for example historical information shows that when used for 5,000 miles the cost of operating the vehicle is 7,000, and at 12,000 miles the cost increases to 11,200.

If these are the highest and lowest mileages recorded then using the high-low method we can calculate the change in the cost (variable component) for a given change in mileage as follows:

High Low Method
Activity LevelUnitsCost
High12,00011,200
Low5,0007,000
Change7,0004,200

The table above shows that for a 7,000 change in the mileage (units) the total cost changes by 4,200. Based on this information the unit variable cost component can be calculated using the high low method cost formula as follows.

Unit variable cost = Variable cost / Units
Unit variable cost = 4,200 / 7,000 = 0.60 per mile

The unit variable cost is now used for either the high or low values in the mixed cost formula to calculate the fixed cost component.

Mixed cost = Unit variable cost x Number of units + Fixed cost
11,200 = 0.60 x 12,000 + Fixed cost
Fixed cost = 4,000

Our full mixed cost formula can now be stated as

Mixed cost = Unit variable cost x Number of units + Fixed cost
Mixed costs = 0.60 x miles + 4,000

This mixed cost formula can now be used in the financial projections to establish the total cost at any level of activity within the range being considered.

The cost behavior including the variable and fixed cost components determine the cost structure of a business and can have a significant impact on whether a startup business is successful or not.

Last modified July 16th, 2019 by Michael Brown

About the Author

Chartered accountant Michael Brown is the founder and CEO of Plan Projections. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.

You May Also Like