Cost Behavior and Analysis Methods
Cost Behavior and Analysis Methods
1
There is an inverse relationship between volumes of output and fixed costs
per unit; whereas, remain constant in total per period. The equation for fixed
costs is:
Total Costs = Fixed Costs + Variable costs Per Unit X Units (volume)
2
In the equation for total costs fixed costs and fixed element of fixed costs
are both included in the “Fixed Costs.” Likewise, variable costs and variable
elements of mixed costs are both included in “variable Costs.”
The equation for total costs corresponds to the general equation for a
“straight-line.”
Y = a + bx
The first five methods have been discussed with the help of the following
illustration.
Illustration:
3
Solution:
1. Comparison Method
Under this method, the quantum of output at two different levels of activity is
compared with corresponding amount of semi-variable costs. As fixed cost
remains constant, variable cost is determined by applying the following ratio:
This method is similar to the comparison method except that the data
relating to the highest and lowest levels of activity are considered.
In the given illustration, the highest level of activity is achieved in the month
of June and the lowest in the month of February, and hence, the data of
these two months is considered, as below.
= $1,750
350
= $5 per unit
For February, variable element of cost = 150 x $5 = $750
and, Fixed Element of cost = $1,750 - $750 = $1,000
For June, variable element of cost = 500 x $5 = $2,500
4
and, Fixed Element of cost = $3,500 - $2,500 = $1,000
y = bx + a
Where, y = Total semi-variable cost
x = Output (in units)
b = Variable cost per unit
a = Fixed cost element
$2,000 = 200 x 5 + a
Under this method of segregation of fixed and variable elements of cost, first
the average of the data relating two levels of activity is calculated and then the
equation method or range method is applied. Taking data of first two and last
two months, from the illustration, the cost is segregated as under.
= $1,375
275
= $5 per unit
This method is the most accurate method to segregate semi-variable costs into
fixed and variable elements. It is a statistical method based on the linear-
equation:
y = bx + a
N = number of observations
Taking the data given in the illustration, we compute the value of ∑x, ∑y, ∑x 2
and ∑xy as below.
Output Semi-variable
(x) Cost (y) x2 xy
January, 2022 200 2,000 40,000 400,000
February 150 1,750 22,500 262,500
March 250 2,250 62,500 562,500
April 300 2,500 90,000 750,000
May 400 3,000 160,000 1,200,000
June 500 3,500 250,000 1,750,000
6
∑x = 1,800 ∑y = 15,000 ∑x2 625,000 ∑xy4,925,000
Now, substituting value of b = 5 in any equation, say (iii), we can ascertain the
element of fixed cost:
15,000 = 1,800 x 5 +6a
or, 6a = 15,000 – 9,000
or, a = 1,000
or, f ixed cost element = $1,000
This method is based on ‘careful analysis of each item to determine how far the
cost varies with volume.” The analyst determines from the past experience as
to what portion of semi-variable cost comprises of variable cost element and
fixed cost element. Say, for instance, out of semi-variable cost of $5,000 the
variable element is 80%, then fixed cost would be $1,000, i.e., 5,000 minus
80% 0f 5,000. This method is simple but suffers from the subjectivity of the
accountant or the analyst. Two different persons may determine different
degrees of variability and ascertain different element of fixed cost from the one
given semi-variable cost.
7
The break-even analysis establishes a relationship between revenues and costs with respect to
volume. It shows the level of sates at which total revenues equal total costs. That is the point of
Zero profit. It is basically concerned with finding out the break-even point. It should be noted that
break-even point is just incidental in CVP analysis. The more important aspect of the CVP analysis
is to examine the effects of changes in costs, volume and prices on profits. Breakeven analysis, in
its wider concept, denotes a system of analysis, which determines the probable profit at any level of
apportioning.
6.4.1 Assumption of Breakeven Analysis
Breakeven analysis is based on a series of assumptions which are as follows:-
1. Costs can be separated into fixed and variable
2. Variable costs change in direct proportion to change in volume
3. Fixed costs remain constant at all volumes
4. Selling price will remain constant at all volumes of sales
5. Technological methods and operating efficiency of men and machine will remain unchanged
6. Production and sales will follow the uniform pattern
7. There will be only one product or in the case of multi products, product mix will remain
unchanged
8. Factory will work at predetermined efficiency level
A change in any one of the above factors will after the break-even point so that profits are
affected by changes in factors other than volume.
The Break-even point can also be computed graphically. Breakeven charts is defined as a chart
which shows that profitably or otherwise of an undertaking at various levels of activity and as a
result indicates the point at which neither profit nor loss is made charts which direct cost volume
profit data are visual aids which serve to dramatize the effect of changes in cost, volume and profit.
Breakeven points picturizes on a graph. Total cost, fixed and variable costs, sales revenues and
profit or loss at various volumes and also the breakeven point for the business. It is the graphical
representation showing the correction between costs, volume of sales and profits.
The Graphical Breakeven analysis eliminated the details and presents the information in a
simplified way.
8
The chart provides variable information at a glance regarding the characterization of the business
and therefore, is an important aid in profit planning exercises. The chart highlights the impact of
fixed costs of the operations of an undertaking. The relationship between fixed costs and profit at
different volumes may exert a powerful influence on selling price decisions and profit policies.
Breakeven charts are frequently used and needed where a business is newly started on where it is
experiencing trade difficulties. The advantage of BEP graph over the BEP formula is that we can
find out the costs and sales at any point, the profit or loss at any given point of sales. This
Breakeven chart is useful for managerial decisions.
Illustration:-
From the following data, prepare a breakeven chart:
Fixed cost Birr 20,000
Variable cost Birr 0.50 per unit
9
Sale price Birr 1 per unit
The unit produced and sold
0, 20,000, 40,000, 60,000, 80,000, 100,000
Solution:-
Unit Fixed Variable cost Total Total Sale Total
produced Cost Per unit variable Cost price sales
and sold No, (Birr) (Birr) C Cost (Birr) E=(B+D) Per unit G=(AxF)
A B D= (Ax C) (Birr) F (Birr)
(Birr)
0 20,000 ____ ___ 20,000 __ __
20,000 20,000 0.50 10,000 30,000 1 20,000
40,000 20,000 0.50 20,000 40,000 1 40,000
60,000 20,000 0.50 30,000 50,000 1 60,000
80,000 20,000 0.50 40,000 60,000 1 80,000
100,000 20,000 0.50 50,000 70,000 1 100,000
100 Profit
90
(in ’000)
Costs and Revenues
The Breakeven point is at 40,000 units, sales value Birr 40,000 and the margin of safety is 60,000
units, i.e., 100,000 units’ actual sales less BEP sales, 40,000 units.
10
6.4.4 Margin of safety
Margin of safety is the difference between the actual sales and breakeven point sales. One
assumption the preparation of BEP chart is that all put will convince sales. Therefore margin of
safety is also the excess output over the BEP output. Since all fixed costs are recovered at the BEP
only variable costs will be incurred for any output and sale after this point. Therefore
additionally sells value minus variable costs equals to contribution and contribution equals to profit.
Margin of safety is the measure of strength of a business any sales over and above the BEP sales
would provide the sense of safety – caution to the business. If the gap is large, it will indicate a
better safety and even if there is a full on demand, the business would still be earning profits. If the
distance or gap is short, it will indicate a caution as a little decrease in production / sales will cause
a violent fluctuation in profits. Thus, there should be a reasonable margin of safety. Otherwise a
reduced level of activity may prove detritus.
11
On a Breakeven chart, at the crossing of sales line and total cost line an angle is formed and this is
known as Angle of incidence. The angle to the right of BEP formed by the intersection of these two
lines is the Angle of incidence. This angle indicates the rate at which the profits are being made.
If the angle of incidence is large, it shows that the profits are being very satisfied at a higher rate. If
the angle of incidence is small, it shows that the profits are made, but under stress and less favorable
conditions. A large angle of incidence together with a high margin of safety is an indication of
highly favorable situation or even a state of monopoly.
Thus, cost value profit analysis and Breakeven charts are very much useful to the management in
price formulation, production planning, profit estimation and cost control.
Differential costs are the increase or decrease in total costs that result from
producing additional or fewer units or from adopting of alternative course of
action. The alternative course of action may arise due to change in sales
volume, alternative methods of production, change in production/ sales mix,
make or buy, add or drop a product line, etc. hence, differential cost is the
change of cost arising from an alternative course of action.
All post (historical or sunk) costs are themselves irrelevant to any decision
about the future.
Problem 1. To illustrate the analysis for fixing of selling price, a firm is selling
X product, whose variable cost per unit is $10, and fixed cost is $6,000. It has
14
sold 1,000 articles during one month at $20 per unit. Market research shows
that there is a great demand for the product if the price can be reduced.
If the price can be reduced to $12.50 per unit, it is expected that 5,000 articles
can be sold in the expanded market. The firm has to take a decision whether to
produce and sell 1,000 units at the rate of $20 or to produce and sell for the
growing demand of 5,000 units at the rate of $12.50.
Required: give your advice to the management in taking a decision.
Solution:
Comparative profit Statement
Exiting Situation Proposed Situation
Sales 1,000 units sales 5,000 units
@$20 per unit @$12.50 per unit
A. Sales $20,0000 $62,500
B. Variable Cost $10,0000 $50,000
C. Contribution (A-B) $10,0000 $12,500
D. Fixed Cost $ 6,0000 $ 6,000
E. Profit (C –D) $ 4,0000 $ 6,500
______________________________________________________________
The above analysis shows that the proposal to manufacture and sell
5,000 units will be more profitable. The profit will increase by more
than 50%. However, the management should also consider interest on
increased capital outlay and increase in fixed costs, if any, before
arriving at a final decision.
Problem 2. With a view to increase the volume of sales, Ambitious Enterprises
has in mind a proposal to reduce the price of its product by 20%. No change in
total fixed costs or variable costs per unit is estimated. The directors, however,
desire the present level of profit to be maintained.
The following information has been provided:
A. Sales 50,000 units $500,0000
B. Variable Costs $ 5 per unit
C. Fixed Costs $50,000
Required: Advise management on the basis of the various calculations made
from the data given.
Solution:
Marginal Cost Statement
_________________________________________________________
1. Sales $500,000
15
2. Variable Cost $250,000
3. Contribution (1 - 2) $250,000
4. Fixed Cost $ 50,000
5. Profit (3 -4) $200,000
__________________________________________________________
Sales required to maintain the present profit = Fixed costs + Desired Profit
P/V Ratio
= ($50,000 + $200,000) = $666,667 or 83,333 units
37.50
100
Thus, a reduction of selling price by 20% will require increase in sales
by 83,333 units in order to maintain the same level of profit. Thus, it
will be desirable to reduce the selling price by 20% only when the
management would be in a position to push up sales volume by 66%
(i.e., 83,333 -50000/50,000).
Problem 3. To illustrate the analysis for a special order decision, the following
budgeted income statement is for a manufacturer who has just received an
opportunity to sell 20,000 units of a product at $10 per unit to a discount Store
and sales of 60,000 units at the regular price are planned. The plant has a
capacity to produce 100,000 units.
Budgeted Income Statement
16
Per Unit Total
Sales (60,000) $15 $900,000
Manufacturing Costs:
Direct material $4 $240,000
Direct Labor $3 $180,000
Factory Overhead (1/3 variable) $6 $360,000
Total Manufacturing costs $780,000
Gross Profit $120,000
Selling and Administrative Expenses $ 80,000
Operating Income $ 40,000
______________________________________________________________
The president has some misgiving about accepting the order, even
though sufficient capacity is available. He sees that the average
manufacturing costs are $13 per unit $780,000/60000units) and that a
$10 per unit price be below this average cost.
Required: As the Controller of the firm, you are asked to evaluate the
offer.
Solution:
Only the incremental elements should be considered in making the
decision.
17
the decision to add or drop a product is whether it will increase or decrease the
future income of the company. To assess the changes in income, the
managerial accountant must determine the relevant costs. To help
management analyze this issue, the managerial accountant determines the
relevant costs associated with dropping a product-line. In making decisions of
this type, fixed costs are classified as avoidable and unavoidable.
Avoidable Costs are those costs that will not be incurred if one alternative is
chosen; in the case of the product line is eliminated.
Unavoidable Costs are those costs that are independent of the decision
and will continue to be incurred if the product line is eliminated.
The Income Statement for Moorhead Department Store shows total net income
of $35,000, which includes a loss of $10,000 from the sale of Groceries.
Required: Should Groceries be dropped? And, how much will total income be
affected if Groceries is dropped?
Solution:
(1) (2) (1 -2)
Keep Drop
18
Groceries Groceries Difference
Sales Revenue $1,900,000 $900,000 $1,000,000
Variable Costs $1,420,000 $620,000 $ 800,000
Contribution Margin $ 480,000 $ 280,000 $ 200,000
Fixed Costs:
Avoidable $ 265,000 $ 115,000 $ 150,000
Unavoidable $ 180,000 $ 180,000 $ 0
Total Fixed Costs $ 445,000 $ 295,000 $ 150,000
Operating Income $ 35,000 $ (15,000) $ 50,000
Thus, of the Groceries product line is dropped, net income will decrease by
$50,000 as shown above. The analysis shows that the Groceries product line
contributes $200,000 towards covering its avoidable fixed costs ($150,000)
associated with Groceries.
This analysis shows that Moorhead Department Store should not drop the
Groceries product line unless a more profitable use could be found for the
space that Groceries occupied in the store.
Required: (a) Should you make or buy? And, (b) what would be your decision if
the supplier offered the component at $ 4.85 each?
Solution:
19
(a) The variable cost of manufacturing a component is $5.00 calculated as
follows:
Materials $2.75
Labor $1.75
Other variable costs $0.50
Total $5.00
The market price is $5.75. This is more than the variable cost by $0.75. It is
therefore not profitable to procure from outside because in any case the
fixed costs will continue to be incurred. However, if the surplus capacity
released on account of procuring the component form outside could be put to
a more profitable use, it may be better to buy from outside rather than
manufacturing the component.
(b) In case the supplier is prepared to supply the component at $4.85,
there is a saving of $0.15 in the variable cost too. Hence, it is
profitable to procure from outside. The surplus capacity released
may be put to some other profitable use.
A B C
Unit contribution margin $10 $30 $25
Machine hours per unit ÷2 ÷ 2 ÷ 1
Contribution per hour $5 $15 $25
22
As shown in the following analysis, any other plan would result in the lower
profits.
A B C
Machine hours available 100 100 100
Machine hours per unit ÷2 ÷ 2 ÷ 1
Weekly production 50 50 100
Unit contribution margin x $10 x $30 x $25
Total Contribution $500 $1,500 $2500
When two or more limiting factors are in operation, it is necessary to take all of
them into consideration.
23