| |
Step Fixed Cost and Break-even Analysis
 |
The separation of costs into fixed and variable components helps provide relevant information about costs for making decisions. VARIABLE, DIRECT OR MARGINAL COSTING assigns only variable manufacturing costs to products. |
Short-term VARIABLE COSTS vary in direct proportion to the level of activity. |
FIXED COSTS remain constant over wide ranges of activity for a specified time period. |
Under certain assumptions, given the fixed costs, variable costs, and the selling price the BREAK-EVEN POINT (Level of activity which results in a no profit no loss situation) can be calculated using the formula : |
BREAK-EVEN POINT (BEP) = TOTAL FIXED COST / CONTRIBUTION PER UNIT. |
The assumptions are -
- The behaviour of costs and revenues have been reliably determined and is linear over the relevant range
- All costs may be divided into fixed and variable elements.
- Fixed cost remain constant over the relevant volume range of the break-even analysis.
- Variable costs are proportional to volume.
- Selling prices to be unchanged.
- Prices of cost factors are to be unchanged.
- Efficiency and productivity remain unchanged.
- The analysis either covers a single product or it assumes that a given sales-mix will be maintained as total volume changes.
- Revenue and costs are being compared on a common activity base.
- Perhaps the most basic assumption of all is that the volume is the only relevant factor affecting cost. Of course other factors also affect costs and sales ; Ordinary CVP analysis is a crude over simplification when these factors are unjustifiably ignored.
- Changes in beginning and ending inventory levels are insignificant in amount.
|
STEP-FIXED COSTS have a distinguishing feature in that within a given time period, they are fixed within specified activity levels, but they eventually increase or decrease by a certain amount that at various critical activity levels. |
There are four distinct possibilities : |
| INCREASE IN RANGE (VOLUME) |
STEP FIXED COST |
Constant |
Constant |
Not Constant |
Constant |
Constant |
Not Constant |
Not Constant |
Not Constant |
A typical example would be the cost of supervisors for conducting an examination were in each supervisor would be in charge of a range of candidates. Once the given range is exceeded an additional supervisor would be required. The cost is fixed within the range of candidates but changes once the range is exceeded. Illustration 1 clarifies the situation. |
ILLUSTRATION 1 :
(Simplified situation of a real-life example) |
| Rs. |
Examination Fee per student |
50 |
Variable cost in conducting an examination (Answer papers, question setting etc.) |
30 |
Fixed costs associated with the examination (Hall rent honorarium etc.) |
20,000 |
In addition to the above cost supervisor have to be hired to supervise the students. One supervisor is required for every 100 candidates. The charge per supervisor is Rs. 200. |
In the above situation the supervision cost are constant over a range of 100 students. Once the range is exceeded i.e. the 101st student writes the exam an additional supervisor would be required. Such costs are described as Step-Fixed costs. |
Costs are analysed within a RELEVANT RANG in marginal costing. Once the given range of activity changes fixed costs tend to vary as depicted in the graph. |
The formula used in the calculation of the BEP has to be modified for a situation containing step-fixed costs. |
The approach is as below (Solution to Illustration 1) : |
Tentative BEP (Students) |
No. of supervisors |
Additional costs (Rs.) |
Additional Students |
20000/20 = 1000 |
10 |
10 * 200 = 2000 |
2000/20 = 100 |
100/1100 |
11 |
1 * 200 = 200 |
200/20 = 10 |
10/1110 |
12 |
1 * 200 = 200 |
200 / 20 = 10 |
10/1120 |
12 |
NIL |
NIL |
Therefore the BEP is 1120 students. |
Variable cost per unit is assumed to be a constant. But in some situations they vary in the same manner as step-fixed cost. For instance where discounts are offered as in Illustration 2, variable costs become STEP-VARIABLE COSTS. |
| Quantity Purchased {Kg.) |
Price per KG (Rs.) |
Discount (Rs.) |
Cost (Rs.) |
Range (Kgs) |
| |
|
[The discount is for each range of 100 Kg] |
100 |
100 |
- |
100 |
0-100 |
200 |
100 |
10 |
90 |
101-200 |
300 |
100 |
20 |
80 |
201-300 |
In the above situation, if the discount offered is in the nature of a trade discount, then the discounts will be for the full quantity of purchases, thereby making the price a direct variable cost. If the discounts are for specific ranges, the cost becomes the step variable cost ; Where the variable cost is a constant for a range ; Once the range is crossed, is varies but is constant for another range. The situation also requires an analysis of the range in the manner illustrated in Illustration 1 to arrive at the BEP. |
MULTIPLE BREAK EVEN POINTS |
Step fixed costs give rise to a unique situation where in more than 1 BEP exists for a given situation, i.e., more than one level of activity giving rise to a no profit no loss situation. I can be illustrated that as many step increases in fixed cost, there will be a maximum of so many BEPs possible. [Refer Graph 2]. |
| RANGE OF STUDENTS (DATA FROM ILLUSTRATION 1) |
| 1000-1100 |
1100-1200 |
1200-1300 |
| Full-loss Zone |
BEP |
Full-profit zone |
All the multiple BEP's will fall within the full loss and full profit zones. A full-loss zone is a range where any activity level within the range will result in a loss. In the like manner, a full-profit zone is the one where any activity level within the range will result in a profit. |
A second BEP can be recognised by calculating a tentative BEP at the immediately next range. If it falls outside the range there is no other BEP. If it does fall within the range then we have the second BEP and the possibility of a third cannot be ruled out. |
FORMULATIONS FOR EVALUATING THE FIRST AND SUBSEQUENT BREAK EVEN POINTS |
Case 1 : When the first break even point lands on the extreme point of the range over which the fixed cost is constant there will be a second BEP in the immediately succeeding range. The step fixed cost becomes a variable cost at the extreme point. |
Such a situation can be recognised even without computing the first BEP for the first category of step fixed cost which we have previously mentioned i.e with the following assumptions :
- The range over which the step-fixed cost varies is a constant.
- The change in step fixed cost is a constant.
|
NOTATIONS
Base fixed cost - FC [20000 in illustration 1]
Step fixed cost - SFC [200 in illustration 1]
Contribution per unit - C [20 in illustration 1]
Range/Step - R [100 in illustration 1]
No. of steps - N
|
The derivations is as follows :
On the extreme point the fixed cost becomes a variable cost at that point. Hence the total base fixed cost (General Fixed cost) is a function of the net recovery at that step i.e.
Total fixed cost = Base Fixed cost + Total step fixed cost = FC + (N * SFC)
Total recovery (Contribution) = No. of units * Contribution per unit = (N * R) * C
At the extreme point (BEP)
Total Fixed cost = Total Recovery.
FC + (N * SFC) = (N * R) * C
N = FC / ( (R*C) - SFC)
i.e., the total base fixed cost (the numerator) is a function of the net recovery at a step (the denominator).
If the resultant 'N', i.e the number of step is an integer then we have a situation of the first BEP landing on the extreme point and the step fixed cost approximating to a variable cost.
In such a situation the long drawn solution to locate the BEP can be simplified in a single step :
BEP = N * R
i.e., BEP = (FC * R) / ( (R * C) - SFC )
Note :
The BEP can be located using this formula only if N is an integer. However a slight modification would give the BEP in other cases also as shown in CASE 2.
|
| Illustration 3. |
Using the data from illustration 1, change the base fixed cost to Rs. 18000.
N = 18000/( (1000 * 20) - 200 )
The first BEP = 10 * 100 = 1000
There will be a second BEP since 'N' is a Integer. The second BEP is calculated as follows :
Step fixed cost = 200
No. of students to cover the cost = 200/20 = 10
Therefore the second BEP = 1000 + 10 = 1010
( The results can be verified by working back from the BEPs)
The conclusion is that when 'N' is an integer there will be atleast 2 BEPs.
Another intresting derivations is that when fixed cost is a multiple of Rs. 1800 (Denominator in the formula), more than one BEP is possible.
Note :
It is to be noted that when the net recovery at a step (Denominator in the formula) is nil, there will be no BEP i.e. if R * C = SFC, then 'N' tends to infinity. Hence, there is no BEP. Similarly when R * C < SFC the denominator is negative leading to a negative step. Since this also is an impossibility there will no BEP when R * C <= SFC.
|
Case 2 : |
Supposing 'N' from case 1 is not an integer then still there is a possiblity of a second BEP if the step fixed cost associated with a range is grater than the recovery from the excess capacity at the level in which the first BEP falls. In other words total cost at the next higher step (Step next to the one in which BEP falls) is greater than the total recovery at the extreme point of the previous level.
The assumptions laid down in case 1 hold. 'N' calculated using the formula will not be an integer. Replace 'N' with the immediately higher whole number to signify the step in which the BEP falls.
Total recovery at the extreme point of the current step = (N * R) * C
Total Step fixed cost at the next step = (N + 1) * SFC
if FC + (N + 1) * SFC > N * R * C --------I
there will be another BEP
or
i.e., FC > [N * (R * C - SFC) - SFC] --------II
or
The excess capacity at the current level = N * R - BEP
The recovery from the excess capacity = [ (N * R) - BEP] * C
Therefore if [ (N * R) - BEP ] * C < SFC --------III
there will be another BEP.
Equations I, II and III can be used to indicate the existence of another BEP. |
Illustration 4 |
Rs. |
Revenue per unit
|
50
|
Variable Cost per unit
|
25
|
Fixed cost
|
500
|
Step (Range)
|
50
|
Step fixed cost
|
800
|
[For every 50 units, the step fixed cost is Rs. 800]
|
N = 500 / ( (50 * 25) - 800) = 1.111
BEP = Total fixed cost / contribution = [Base fixed cost + step fixed cost] / Contribution
Therefore the first BEP = (FC + (N * SFC) ) / C
Here 'N' is the next higher whole number.
Therefore BEP = (500 + (2 * 800)) / 25 = 84
Since 'N' is not a whole number we have to check for the second BEP. Equation III can be used effectively.
( (2 * 50) - 84 ) < 800
i.e. 400 < 800.
Hence there will be another BEP. The second BEP will fall in the immediately next range.
The second BEP = 84 + (800/25) = 116.
|
Note :
Case 1 is only a specific instance of Case 2 where the excess capacity at the level of the BEP is nil, hence, no further recovery is possible from that level. Therefore the step-fixed cost of the next level is always greater than the recovery from the excess capacity in the level of BEP resulting in the second BEP. |
BREAK-EVEN POINT IN A SITUATION CONTAINING A PRODUCT MIX |
The procedure for computing the BEP is the same as in the other cases except that the contribution of the mix as a whole has to be taken to determine the BEP. It is also to be assumed that the production of the minimum component in the mix would automatically produce certain quantities of the other products.
A comprehensive Illustration is required to clarify this situation. Let us take up the case of a barber shop which offers only haircuts and shavings.
|
| Revenues per unit : |
Hair Cut |
Rs. 27.50 |
| |
Shaving |
Rs. 17.50 |
| Variable cost per unit : |
Haircut |
Rs. 7.50 |
| |
Shaving |
Rs. 7.50 |
| Fixed cost per month : |
|
Rs. 65,000 |
The scissors used for the haircuts lasts for 250 haircuts and costs Rs. 250. Similarly the shaving cream lasts for 150 shaves and costs Rs. 200. Instead to paying a fixed rent for the shop the barber has entered into an agreement with the owner whereby he has to pay a rental based on the number of customers. The details of the agreement are as follows :
With respect to the haircuts a minimum rental of Rs. 4000 per month is to be paid. If the number of haircuts exceeds 250 an additional sum of Rs. 4000 is to be paid so long as the number does not exceed 500. But a similar sum is to be paid once the number falls between 501 and 750. (i.e. for 0-250 haircuts, total rental = Rs. 4000 ; for 251 - 500 haircuts, total rental = 8000 and so on).
Similarly for shavings the minimum rental is Rs. 750 per month and the range of customers over which it changes is 150.
|
An analysis of the number of customers in the month of Dec. 1996, reveals the following:
Haircuts alone 2000
Shavings alone 1000
Both together 500
|
You are required to find out the break-even number of customers in terms of haircuts alone, shaves alone, and both together assuming :
- The proportion of customers remains the same as in Dec. 1996 and
- To the revenue and variable cost of doing a haircut and shave together is the sum revenue and variable cost of the individual activities.
|
Solution :
Assumptions
- The production mix for the month of Dec. 1996 was 4:2:1. In order to eliminate fractions we assume that there shall be a minimum of 5 haircuts and 3 shave. i.e. 4 Customers opting for haircuts alone, 2 for shaves alone and 1 for both.
- The proportion of the ranges over which the step-cost for the products vary will be the same as the product mix i.e. 250:150 is the same as 5:3. (4+1 : 2+1) This is a derivation from the problem and the solution given will hold good only if this relation is satisfied.
- The contribution derived from the combination is the same as the sum of the contributions of the individual products.
|
Step Fixed Cost : Hence, there are two step fixed cost associated with both haircuts and shaves. For haircuts the step fixed cost are the cost of scissors and the rental payment. For shaves the step fixed cost are the cost of the shaving cream and the rental. The calculations are as detailed below :
For 250 units of haircuts - Rs. 4250 (250+4000)
For 150 units of shaves - Rs. 950 (200+750)
Since, the proportion for the step-fixed cost as well as the product mix is the same (4:2:1), the two step fixed cost can be added up to compute the step fixed cost for the range.
Since, N is whole number N1 is also a whole number.
Thus, the annual BEP = N1 * R = 12 * N * R
= 12 * Monthly BEP. |
Thus, the annual BEP is 12times the monthly BEP when the monthly BEP falls on an extreme point. However this relation holds good only for the first monthly BEP and the first annual BEP. Second and subsequent BEP which do not fall on the extreme point will not satisfy the relation. It can be noticed that this is just a specific case of the general conditions that we have put forth. Here 'N' is always an integer and hence need not be rounded to compute the BEP. Similarly, N1 is also rounded. Hence, our original formulation stating N ( Rounded ) must be equal to N1 ( Rounded ) is always satisfied.
(Illustration 1 with a monthly fixed cost of Rs. 21600 will result in such a situation. ) |
Conclusion |
Step fixed cost is very interesting area in Marginal costing and possesses certain unique characteristics and leads to interesting revelations. Very little has been written on the subject and a deeper analysis would reveal interesting derivations. In this article a couple of things have been stated but not proved ; The phrase 'As many step increases in fixed cost there will be a maximum of so many BEPs possible'. Interested readers can take up such statements for further analysis once the basic concepts about step fixed costs are understood. |
|
| |
 |
|
|
 |