Profitability Analysis Techniques
Profitability Analysis Techniques
ProfitabilityAnalysis-Product
Wise/Segment Wise/ Customer Wise
LEARNING OBJECTIVES
After studying this chapter you will be able to understand:
• The various components of operating income and its impact on the profitability,
• Effect of growth component, price recovery component and productivity components in
the change of operating income,
• Reasons for the difference in the operatingprofit of two periods and its reconciliation,
• Product wise profitability analysis- Direct Product Profitability (DPP)
• Segment wise profitability analysis and Customer profitability analysis.
• Four perspectives of the Balanced scorecard.
spread our analysis into three main areas or components which are (a) Growth component (b)
Price recovery component and (c) Productivity [Link] will cover both revenue
and cost effect,wherever applicable,on these components separately.
(a) Growth component measures the change in the quantity of output sold. The growth
component of the change in the operating income measures the increase/ decrease in
revenue and in costs due to selling more/ less quantity units from the previous period.
Revenue effect of growth component:
Revenue effect of growth can be measured with the help of the following formula:
The revenue effect of growth measures the increase/ decrease in revenue solely due to
change in number of units sold.
Cost effect of growth component:
Cost effect of growth measures the effect of variable cost and fixed cost separately.
For variable cost components:
⎛ Actualunits of capacity in ⎞
⎜ ⎟
last year if adequate to Actualunits of Capacity ⎟
Cost effect of growth = ⎜ − × Rate inlast year
⎜ produce current year ' s inlast year ⎟
⎜ ⎟
⎝ productioninlast year ⎠
(b) Price recovery component of change in operating income measures the changes in
the revenue and costs solely due to changes in prices.
Revenue effect of price recovery component:
Revenue effect of price recovery can be measured with the help of the following formula:
The revenue effect of price recovery measures the increase/ decrease in revenue solely due
to change in selling prices.
(c) Productivity componentmeasures the change in the operating income due to changes in
the product mix and/ or yieldof inputs as compared with the last year. This component uses
current year’sprices of input to measure the changes in costs only.
For variable cost components:
Illustration 1
Y Limited is a manufacturer of Cardboard boxes. An analysis of its operating income between
2012and 2013 shows the following:
Income Revenue & Revenue & Cost Cost effect of Income
Statement Cost effect effect of Price productivity Statement
(amount in of Growth recovery component in (amount in
2012) component component in 2013 2013)
in 2013 2013
Revenue (`) 40,00,000 2,00,000(F) 4,20,000(F) - 46,20,000
Cost (`) 29,20,000 60,000 (A) 2,56,000(A) 58,000(F) 31,78,000
Operating Income 10,80,000 1,40,000(F) 1,64,000(F) 58,000(F) 14,42,000
(`)
Y limited sold 4,00,000 boxes and 4,20,000 boxes in 2012 and 2013 respectively. During 2013 the
market for cardboard boxes grew 3% in terms of number of units and all other changes are due to
company's differentiation strategy and productivity. Compute how much of the change in operating
income from 2012 to 2013 is due to the industry market size factor, productivity and product
differentiation and also reconcile the profit of both years due to these factors.
Solution:
Reconciliation of Operating Income
Particulars Amount (`)
Operating Income in 2012 10,80,000
Add: Change Due to Industry Market Size Factor (W.N.-1) 84,000
Changes Due to Productivity (W.N.-2) 58,000
Changes Due to Product Differentiation (W.N.-3) 2,20,000
Operating Income in 2013 14,42,000
Workings:
Total Increase in Sale of Cardboard Boxes 20,000 Boxes (4,20,000 Boxes – 4,00,000 Boxes). Out
of this increase in Sales of 20,000 Boxes,12,000 Boxes (3% of 4,00,000) is due to growth in
market size, and the remaining 8,000 Boxes (20,000 Boxes – 12,000 Boxes) are due to an
increase in market share .
In recent years DPP has developed considerably in parallel with activity-based costing. DPP
hasbecome much more sophisticated and is now very similar to activity-based costing. Infact it
may be regarded as the application or extension of activity based costing.
Benefits of DPP
• Better cost analysis
• Better pricing decisions
• Better management of stores and warehouse space
• The rationalisation of product ranges.
Direct product profitability statement: Retail organisations traditionally deducted the
boughtincost of goods from the selling price to give a gross margin. The gross margin is
uselessmeasure for controlling the costs of the organisation itself or making decisions about
the profitabilityof the different products. This is because none of the costs generated by the
retailorganisation itself are included in its calculation. For example, it does not include the
storagecosts of the different goods and these costs vary considerably from one goods to
another. Amethod was needed which relates the indirect costs to the goods according to the
way the goodsuses or creates these costs.
Indirect costs, for DPP may be analysed into basic cost categories as follows:
(i) Overhead cost: This is incurred through an activity that is not directly linked to a
particularproduct.
(ii) Volume related cost: The cost is incurred in relation to the space occupied by
[Link] includes storage and transport costs.
(iii) Product batch cost: This cost is often a time based cost. If product items (that is a
numberof identical products which are handled together as a batch) are stocked on
shelves alabour time cost is incurred.
(iv) Inventory financing costs: This is the cost of tying up money in stock and is the cost
ofthe product multiplied by interest rate per day or per week.
Direct product profit can be derived as shown below:
Direct Product Profit
Sales xx
Less:Cost of Goods Sold xx
Gross Margin xx
േ Adjustments xx
Adjusted Gross Margin xx
Less:Direct Product Costs xx
(Warehouse, Transportation, Store etc.)
Direct Product Profit xx
Table 1, given below shows the DPP for product A. Directly attributable costs have been
groupedinto three categories and are deducted from the gross margin to determine the good’s
DPP.
Table- 1
Direct product profit for product A
(`) (`)
Selling price p.u. 150.00
Less : Bought-in price 80.00
Gross margin 70.00
Less : Direct product costs :
Warehouse costs 16.00
Transport costs 18.00
Store costs 22.00 56.00
Direct product profit p.u. 14.00
Warehouse and store costs will include items such as labour, space and insurance costs,
while,transport costs will include labour, fuel and vehicle maintenance costs. The usual way to
spreadthese costs across the different goods sold is in relation to volume or area occupied, as
mostcosts increase in direct proportion to the volume of the good or the space it occupies.
However,there are some exceptions to this; for example, insurance costs may be better
spread on value oron a risk index. Risk is greater with refrigerated or perishable goods.
Refrigeration costs mustonly be related to those products that need to be stored in the
refrigerator.
The result of this type of DPP cost analysis may give information such as that given in
thefollowing table:
Table-2
Profit Gross margin (%) DPP (%)
Ice-cream 20.40 4.60
Baby food 11.00 5.50
Tooth paste 31.20 18.80
Wine 45.30 17.20
Paper tissues 15.70 0.00
Above table-2 shows that for ice-cream there is a considerable gap between the gross
marginand the DPP because its refrigerated storage is expensive. It also shows that paper
tissues,which had quite a healthy gross margin, are just breaking even with DPP; this is
because theyare very bulky relative to their price.
While the supermarket or other retailer does not have theluxury of stopping selling paper
tissues, because obviously it would lose considerable trade if itdid not stock a complete range
of goods, it does have other choices. The choices are merchandisingones, such as where to
display the stock and in what position on the shelves. Stocks at eyelevelsells more quickly
than the above or below eye level. The brand with the greatest marginshould be placed at eye
level. Goods at the front of the store tend to sell faster than goods at theback. This explains
why tissues are rarely found close to the entrance or the cash till.
With manufactured products cost per unit for the different products is often calculated and
theproducts ranked. For a retail organisation DPP per unit may not be the best measure to
use.
DPPper unit of time adds another dimension to the measurement and DPP per unit of time
permeasure of space adds a third. This is automatically built in when overheads are spread if
a costeach product uses this rate multiplied by the volume and the number of days or weeks in
thesystem. In the example in Table 1, the store costs would be based on a rate per cubic
centimeter or metre per day and the product cost can be calculated according to its size and
the time it takes to flowthrough the system. For example, if the store cost per cubic cm is `
0.0073 per day and goodA is 10 cubic cms and the average stay in the store is three days, the
store cost per item is `0.0073 × 10 cms. × 3 days = ` 0.22.
According to Doherty et al (1993) the single most valuable aspect of DPP lies in its
diagnosticcapabilities, allowing managers to ask questions, such as why did a product group
over or underperform. Table-3 shows that product group A-2 accounts for 3.07 per cent of
sales but for 3.31per cent of DPP. Upon investigation it emerged that stock-turn was managed
particularly well inthis group. Product B-2 has 3.05 per cent of sales but accounts for only 2.85
per cent of DPP. Aninvestigation of the warehouse costs might explain this or the opportunity
of offering multipacksmight reduce costs.
Table–3
DPP values by Product Group. From Doherty et al 1993.
Product Group Sales as a % of total sales DPP as a % of total DPP
A-1 3.20 3.40
A-2 3.07 3.31
B-1 2.84 2.89
B-2 3.05 2.85
C-1 2.75 2.66
A-3 2.26 2.48
Illustration 2
Jigyasa India Ltd. (JIL) has 30 retail stores of uniform sizes ‘Fruity &Sweety Retails’ across
the country. Mainly three products namely ‘Butter Jelly’, ‘Fruits & Nuts’ and ‘Icy Cool’ are sold
through these retail stores. JIL maintains stocks for all retail stores in a centralised
warehouse. Goods are released from the warehouse to the retail stores as per requisition
raised by the stores. Goods are transported to the stores through two types of vans i.e. normal
and refrigerated. These vans are to be hired by the JIL.
Required:
Calculate the Profit per unit using Direct Product Profitability (DPP) method.
Solution:
Direct Product Profitability (DPP) Statement
(Amount in `)
Butter Jelly Fruits & Nuts Icy Cool
Selling Price per unit 84.00 42.00 26.00
Less: Purchase Price per unit 76.00 34.00 22.00
Gross Profit …(A) 8.00 8.00 4.00
Direct Product Costs:
Warehouse Costs per m3 [W.N.-1] 7.46 2.07 3.73
Retail Stores Costs per m3 [W.N.-2] 6.36 4.00 6.36
Transportation Costs [W.N.-3] 76.56 50.00 76.56
Total DPP costs per m3 90.38 56.07 86.65
Items per m3[W.N.-4] 12,600 4,032 2,880
Cost per item …(B) 0.007 0.014 0.030
Direct Product Profit …(A) - (B) 7.993 7.986 3.97
Working Notes
(1) Warehouse Related Costs
General Costs (`) Cost Related with
Refrigerated Goods (`)
Labour& Staff Costs 27,000 ---
Refrigeration Costs --- 1,52,000
Material Handling Costs 28,000 ---
Total 55,000 1,52,000
Volume of Goods Sold 40,000 m3 25,000 m3
Cost per m3 per month 1.38 6.08
Products Time in Retail Stores Cost per m3 per month Total Cost
Butter Jelly 1 Month `6.36 `6.36
(`2.00 + `4.36)
Fruits & Nuts 2 Months `2.00 `4.00
Icy-Cool 1 Month `6.36 `6.36
(`2.00 + `4.36)
(3) Transportation Costs
Normal Van Refrigerated Van
Costs Costs
Cost per trip `3,200 `4,900
Volume of Van 64 m3 64 m3
Cost per m3 per trip `50.00 `76.56
(4) No. of Items per m3
Products No. of No. of Items per No. of Items per m3
Cartons (m3) Cartons (units)
Butter Jelly 42 300 12,600
(42 × 300)
Fruits & Nuts 28 144 4,032
(28 × 144)
Icy- Cool 40 72 2,880
(40 × 72)
Costs, in segment analysis can be classified into direct costs and indirect costs. All expenses
which are directly related with the existence of a segment are called direct costs. Direct costs
can be variable or fixed in nature. On the other hand indirect costs are common costs which
cannot be attributed totally to a particular segment. Generally, there are two approaches
followed to calculate segmental profit which are (i) Full cost approach and (ii) Contribution
approach.
(i) Full cost approach:Under this approach profit for a segment is calculated taking all
direct andindirect costs into account. The indirect costs are allocated to the segment based on
appropriate allocation base. Under this approach, since full costs are taken into account while
calculating segmental profit so sum total of profits of each segment equals to total
organisational profit. Mathematically it can be written as:
Segmental profit = Segmental revenue – Direct costs – Allocated indirect costs.
And
Organisational profit = ∑Segmental profits
(ii) Contribution approach:Under this approach instead of calculating segment wise net
income contribution is calculated. To calculate segmental contribution only direct costs are
deducted from the segmental revenue. All indirect expenses are deducted from the overall
organisational contribution. While following this approach one may find that the segment which
was seemed to be unprofitable is contributing towards the indirect expenses. Segmental
contribution can be simply calculated as:
Segmental contribution = Segmental revenue – Direct costs
And
Organisational profit = ∑Segmental contribution – Total indirect costs
Different customers or categories of customers will each use different amounts of these
activitiesand so customer profitability profiles can be built up, and customers can be charged
accordingto the cost to serve them. A hotel may have activities that are provided for specific
types ofcustomers, such as well laid-out gardens, a swimming pool and a bar. Older guests
may appreciateand use the garden, families use the swimming pool and business guests use
the bar. If theactivities are charged to the relevant guests a correct cost per bed occupied can
be calculated forthis type of category. This will show the relative profitability and lead to
strategies for encouragingthe more profitable guests.
Even a manufacturing organisation can benefit from costing its customers. Not all customerscost
the same to serve even if they require the same products. Some customers may be locateda
long way from the factory and transport may cost more. Other customers may be disruptiveand
place rush orders that interrupt production scheduling and require immediatespecial
[Link] customers need after sales service and help with technical matters, etc.
Illustration3
A manufacturing organisation has four different customers A, B, C and D. A single product
issold to them at different prices because of trade discount offered. Data is given for cost per
unit of business activity. You are required to prepare customer profitability statement.
Information on four customers
Customers A B C D
No. of units sold 60,000 80,000 1,00,000 70,000
Selling price net of discount 25p 23p 21p 22p
No. of sales visits 2 4 6 3
No. of purchase orders 30 20 40 20
No. of deliveries 10 15 25 14
Kilometres per journey 20 30 10 50
No. of rush deliveries — — 1 2
Cost of each activity
Sales visit ` 210 per visit
Order placing ` 60 per order
Product handling ` 0.10 per item
Normal delivery cost ` 2 per kilometer
Rushed delivery cost ` 200 per delivery
Solution:
Customer profitability Statement
Customers A B C D
(`) (`) (`) (`)
Revenue net of discount 15,000 18,400 21,000 15,400
(60,000 × ` 0.25) (80,000 × `0.23) (1,00,000 × `0.21) (70,000× `0.22)
Costs :
Sales visits 420 840 1,260 630
Ordering processing 1,800 1,200 2,400 1,200
Product handling 6,000 8,000 10,000 7,000
Normal Delivery 400 900 500 1,400
Rush deliveries — — 200 400
8,620 10,940 14,360 10,630
Operating profit 6,380 7,460 6,640 4,770
Percentage profitability 43% 41% 32% 31%
It is apparent from above solution that all four customers are profitable, but customers C and
Dnot particularly so when compared with customers A and B. There are several reasons for
thisrange in profitability one reason is the negotiation of favourable terms such as higher
tradediscount as compared to other customers.
Benefits of Customer Profitability Analysis:
1. It helps the supplier to identify which customers are eroding overall profitability andwhich
customers are contributing to it.
2. It can help to provide a basis for constructive dialogue between buyer and seller to
improve margins.
• Introduce products and services as per the desire of targeted customer and market
segments.
• Produce customised high-quality products and services economically with short
gestation periods.
• Mobilise employee skills and motivation for better and consistent deliberation in process
capabilities, quality, and response times.
• Deploy information technology, data bases and effective management information
systems.
The balanced scorecard is a method which displays organisation’s performance into four
dimensions namely financial, customer, internal and innovation. The four dimensions
acknowledge the interest of shareholders, customers and employees taking into account of
both long-term and short-term goals.
Kaplan and Norton classified performance measures into four business ‘perspectives’:
(i) The financial perspective
(ii) The customer perspective
(iii) The internal business perspective
(iv) The learning and growth perspective
(i) Financial Perspective: “How Do We Look To Shareholders?” In this step manager of a
division or a unit, links its business objectives to the corporate strategy of the company as a
[Link] performance measures indicate whether the company’s strategy
implementation and execution are contributing to its revenue and earnings. To identify key
performance measures in this perspective, managers, during strategic planning ask “How do
we look to shareholders?”
Corporate strategy and strategic initiatives are examined from the financial perspective to see
feasibility of these initiatives of being met. The financial objectives chosen at the onset of the
balanced scorecard implementation should serve two purposes:
1. To provide definite performance that was expected at the time of strategies selection.
2. To provide a focus for objectives and appropriate measures in each of the other three
perspectives.
(ii) Customer Perspective: “How Do Customer View Us?” In this stage, companies identify
customers and market segments in which they compete and also the means by which they
provide value to these customers and markets. Managers identify the lead indicators which
make a particular business unit or product different from that of others. Lead indicator may
vary from customer to customer or market segment. If for example, a customer values on-time
delivery then on-time delivery becomes a lead indicator. Examples of lead indicators may
include any number of customer considerations, including:
• On-time delivery
• On-site service
manager’s responsibility todecide as to what information needs to be disclosed and how any
problems of confidentialitycan best be overcome.
The following are some reasons why Balanced Scorecards sometimes fail to provide for
thedesired results;
• Managers mistakenly think that since they already use non – financial measures,
theyalready have a Balanced Scorecard.
• Senior executives misguidedly delegate the responsibility of the Scorecard
implementationto middle level managers.
• Company’s try to copy measures and strategies used by the best companies rather
thandeveloping their own measures suited for the environment under which they function.
• There are times when Balanced Scorecards are thought to be meant for reporting
purposesonly. This notion does not allow a Business to use the Scorecard to manage
Business ina new and more effective way.
It may be noted that the above-mentioned difficulties refer to the internal use of the
Scorecard,unless it is used internally successfully, it should not be used as a basis for
external reporting.