Wednesday, December 1, 2010
Activity Based Planning (ABP)
Monday, November 1, 2010
Visualization of costs and profitability in Life Insurance Company with ABC
• All this information is used to identify the non-value added activities as well as the opportunities to outsource the activities. The organizations can outsource the activities like managing the medical network, dispatch, customer service etc.
Various reports can be generated for the management decision purpose. These reports can be classified under 1) Cost reports 2) Profitability reports. Some of the examples are:
• Cost reports
o Customer Lifecycle costs - Total overheads of the organization for a period can be seen grouped as i) Cost to Acquire ii) Cost to Serve iii) Cost to retain iv) Cost to close v) Cost to sustain channel vi) Cost to sustain business vii) Cost available to use.
o Transaction costs – ABM model gives you information about cost of each transaction grouped under various lifecycle events. This is cost is provided as a’ Clean process’ and ‘Rework’. This information can be used to understand and improve the cost of the transactions. It can also be used to have internal benchmarking across products or across various regions.
o Department Costs – The cost of the departments are not the cost center accounting costs but costs added from the shared services like HR, Admin, IT etc. This report also shows the ‘cost per minute’ for the department. A department is seen as costly when the costs are higher for that department, but sometimes this is department is not costly on per minute cost, because of the available resource capacity is higher. This cost of department is shown as per their top 5 activity costs. This gives the information on the focus of the department. This report also tells about the utilization of the department.
• Profitability reports – The format of this can be like (Insurance premium + Investment income + other income – Reserves – Cost of customer services – cost of claims – Cost of capital)
o Profitability of Line of Business (LOB) by Customer Segment
o Profitability of Customer segment by region
o Profitability of Channels by Product group
Friday, October 1, 2010
Can you create a model with 520,729 activities in ABC?
Wednesday, September 1, 2010
An ABC Initiative is only as effective as the software that supports it
Sunday, August 1, 2010
Profitability solution for Bank
Thursday, July 1, 2010
“Push and Pull” in ABC
This type of modeling has helped in calculation of product and customer profitability in the services industries very well. It has also helped in taking the costs of the internal services departments like HR, IT etc. It has been used by various consultants for a long time now and the current wave named as ‘time driven activity based costing (TDABC)’ is actually a more sophisticated version of the bottom-up or pull type of ABC modeling. This is a modeling technique and most of the commercial software solutions are capable of building such type of models. Now we will take some example and try to understand the difference.
Push ABC example
With the addition of the product 4, brings its own revenue as well as expenses. Because of this the total revenue and the expenses are changed. The new amount of expenses is distributed based on the number of accounts various products. And now, the profitability of the products changes. The product 2, which was unprofitable till last period looks profitable now.
This is when the business managers start disbelieving the numbers. Quite reasonable too. Because there was no business change that happened in that period and still the product started looking profitable. The question comes, what is the correct information? The current information that the product is profitable or the earlier information that the product was unprofitable. Nobody can give the correct answer with this data.
We will take the similar example of the products and try to understand the Pull ABC model.
What is the difference here? The expenses are not distributed based on the # of accounts, but the unit costs are calculated for each product and it is multiplied by the # of accounts. In this case the total expenses do not match with the sum of expenses of the products. This is because the balance is the capacity available for expansion.
Now we add a product here also and see the calculation.
When you add the product and the income and expenses of the same the profitability of the products 1,2 and 3 is unchanged. And which should be, isn’t it? The expenses are taken from the capacity available and the available capacity is reduced.
Wednesday, June 2, 2010
For the “Haves” and “Have-Nots” of Cost and Profitability Solution
Benefits of Activity Based Management (ABM) for “Have-Nots”
b) Information to continuously improve processes and reduce costs – ABM provides the important information about the cost of various processes. Process is nothing but a set of activities performed in a sequence by one or more functions. With ABM we can understand the cost of those processes, benchmark them against internal or external targets and improve upon them.
c) A relationship between organizational cost and organizational value – ABM provides objective information about the cost of the various activities or processes. We can add other subjective or qualitative attributes like ‘value add’ to these processes. This added value can be seen for customer, organization etc. By comparing the cost of the process or product or customer against the value that is added by it, we can focus and create appropriate action plan.
1) Productivity – Cost per assembly, # of assemblies per person
2) Cycle time – time to assemble a product
3) Quality - # of product assemble correctly in first attempt
With this kind of measure we can monitor the performance of various activities. Now the activities are performed by one or more persons. With this we can manage the performance of the activities and people together with the accountability of the same.
b) Best practice organization create a organization wide view of the customer – With the help of initial understanding of the customer profitability, organizations use the same information for overall customer intelligence. This leads the organizations to create the ‘one view’ of the customer across the organizations. For example for Retail Banking the profitability of the customer is calculated across the products held like savings account, cash-credit account, fixed deposit account, housing loan account, car loan account, Demat account etc. With this single view the overall profitability can be seen and cross-subsidization in various service fees can be seen.
e) Best-practice organizations take a holistic view of customer profitability and include lifetime value and customer valuation metrics in the calculation – As we discussed earlier the customer profitability information is used for segmentation, marketing campaigns, retention etc. With the available information of past profitability together with the analytical values of propensity to buy and churn, the organization can calculate the ‘customer lifetime value (CLTV)’ and use this information to retain the customers with highest CLTV. Also analyze the behavior of those customers to align other customers.
f) Best-practice organizations include the majority, but not all, of their costs in the customer profitability calculation. Best-practice organizations use appropriate methods for cost assignment – With the help of ‘time driven activity based costing’, we take the cost that are relevant to the various processes. The installed capacity cost if not utilized completely is not taken to the product or customer. This is shown in the ABM model as ‘Cost Available to Use’. Also the cost of various departments that are not related to the customer or product are separated and shown as ‘Cost to sustain business’. This helps the marketing department to use relevant information for taking business decisions.
g) Best-practice partners all work closely with IT. Enabling technologies for calculating customer profitability include data warehousing, CRM systems, data mining, external databases, and predictive analytics – The work with the IT starts with the building of the ABM model. Here most of the data available in the transactional systems is brought into the ABM model with the help of the ETL tools. The no-system-data is also brought with the help of the web-based solutions. Once the results are calculated in the ABM model, it integrated with the other solutions using the warehousing solutions. The historical data is used for predicting the future behavior and the related profitability of the customer.
h) Best-practice organizations emphasize intelligence (e.g., decision support), not routine reporting, in customer profitability information dissemination - The organizations do not create large number of reports for everybody. In fact the information is provided to those who are decision makers and also as and when required. In this the OLAP tools help the organizations to create the ad-hoc reports and the slice-and-dice required across various dimensions of the report. The dissemination also happens now with the dashboards and intranet facilities.
i) Best-practice organizations secure buy-in from the users and upper-level support for customer profitability initiatives – This is the most important factor in the initiative. The buy-in helps the authenticity of the input data as well as the results. This helps the decisions makes to use the output freely for the improvement initiatives and business decisions.
Thursday, April 1, 2010
Maturity of Cost Management in Organizations
While I was thinking on writing on this subject, I could see the possible reactions from the various stakeholders (is this a really big word with respect to costing?). Costing is generally looked upon as ‘we know it all’ in manufacturing to ‘we have never done it’ in service industry. Sometimes people say, in today’s world the price is decided by the market, so there is no need of costing. In India, there is a statutory need for some of the industries to provide cost data on a regular basis to the bodies. I have the experience that if I use the words Activity Based Management instead of Activity Based Costing, people are more ready to listen to. But there are few organizations in India which have undertaken the study of their maturity of cost management. This is what, it prompted to me to think on this topic.
Techniques used – There are various techniques that are available for cost management. Starting from the standard costing, absorption costing to calculate the product costs and variances to activity based costing, target costing, lifecycle costing, strategic cost management etc.
In manufacturing industry the bare minimum use of costing is there for inventory valuation. For this generally the absorption costing method is used, where the expenses booked in the period are charged to the products as manufacturing or admin or sales overheads. The method to charge the overheads to the products is bead on volume drivers. In service industry this is not required statutorily so you wouldn’t find there. Most of the times, the same information is used to understand the product profitability and take the business decisions. And we have seen time and again that this leads to incorrect decisions making.
Some organizations use activity based costing to calculate the product, customer profitability. Here the cost of the cost objects is calculated by calculating the cost of the activities first. The cause and effect relationship is used. The cost objects consume the activities and activities consume resources. Based on this relationship the cost flows to cost objects. This is a better way to arrive at product and customer profitability.
In target costing, the organization looks for introducing a product. Before doing this a market survey is conducted to understand the features that are desired by the target customer segment and the price that they are ready to pay for the same. A study of competitor’s product features and the corresponding price is also done. Based on this information the features of the new products are defined. A target price is decided with an expected profit. So the cost is the resultant factor. Target Price – Target Profit = Target Cost. Once this is done, a cross-functional team is formed to work on the design of the product, material, processing, marketing etc. Vendors are involved in this process. With the help of this team the organization tries to achieve the target cost.
In Lifecycle costing, the organization looks at the costs of the product throughout the life of the product. From the design, R&D, introduction, enhancements to the phasing out of the product. This helps the organization to plan the costs as well the price at various stages of the lifecycle of the product. You can plan the overall profitability of the product and manage the costs accordingly. The similar concept is now being introduced for customers also and called as Customer Lifecycle Value (CLV).
Strategic cost management relates the management of the costs based upon the strategic direction of the organization. I repeat, it is the management of the costs according to the strategy of the organization. Quite often I have seen people confusing strategic cost management as the cost of the strategy. In other words, that will be cost to the organization if they have to take certain strategic decision. This is like a cost benefit ratio. Typically if use the Porter’s concept of competitive strategy, there are two ways, a) Cost leadership b) Differentiation.
In the current scenario, the operationalization can also be looked from the angle of ‘use of technology’ for the cost management techniques. Spreadsheets are the minimum that people use and they know it is not the best of the ways always. There are various stand alone software solutions are available in the market and use of those does help the organization to make most of the techniques. Going further, the results of cost management techniques can be integrated with other cost techniques or overall performance management methodologies.
The organization ‘A’ is using may be only one technique and at a very low level i.e. measurement and it is still not operationalized. Organization ‘B’ is using many techniques but their overall maturity of use is low but they have achieved some progress in operationalization. Organization ‘C’ is using couple of techniques only but achieved best of the overall maturity and operationalization. Organization ‘D’ is using few techniques with middle level of maturity and operationalization. Organization ‘E’ is using most of the techniques at a very high maturity level but not operationalized it.
Once such a study is conducted it will definite help to understand the cost maturity of the organization, industry, geography and help the organizations to see which type of technique at what level of maturity and oeprationalization would help them.
Finally, wish you a happy fools’ day.