WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Accounting Tutorials » Budgeting Tutorials » Activity Based Costing

Activity Based Costing

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Activity Based Costing?

Activity based costing (also known as ABC costing) refers to the allocation of cost (charges and expenses) to different heads or activities or divisions according to their actual use or on account of some basis for allocation i.e. (cost driver rate which is calculated by total cost divided by total no. of activities) to arrive at a profit.

Examples include square footage that is used per product, and the same would be used to allocate the rent of the factory as well as the maintenance cost of the firm; similarly, the number of purchase orders (i.e., PO) used to allocate the purchasing expenses of the purchasing department.

Activity Based Costing Formula

Activity-Based Costing Formula = Cost Pool in Total / Cost Driver

Activity Based Costing Formula

The ABC formula can be explained with the following core concepts.

  • Cost Pool: This is an item for which measurement of the cost would require, e.g., a product
  • Cost Driver: It is a factor that will cause a change in the cost of that activity. There are two kinds of cost driver:
    • 1) Resource Cost Driver: It is a measure of the number of resources that shall be consumed by an activity. This will be used to assign the cost of a resource to an activity. E.g., Electricity,  Staff wages, Advertising, etc.
    • 2) Activity Cost Driver: This is the measure of the intensity of demand and the frequency that is placed on the activities by the cost pools. It will be used to assign the activity costs to a product or a customer. E.g., Material ordering costs, Machine set up costs, Inspection and testing charges, Material handling and storing costs, etc.

Examples of Activity Based Costing

Let’s see some simple to advanced examples to understand it better.

You can download this Activity Based Costing Excel Template here – Activity Based Costing Excel Template

Example # 1

BAC ltd is considering shifting from the traditional costing method to ABC based costing method, and it has got the following details. Using ABC costing formula, find out the new overhead rates for the company.

Activity Based Costing Formula Example1

We have here given two activities. The first one is a machine set-up activity, and the second one is inspecting the same. So the drivers areas the number of machine setup would increase the cost would also increase, and similarly as the number of inspecting hours increases, that would lead to an increase in inspection cost as well. Hence, we need to allocate those costs based upon their cost drivers.

Using the ABC formula: Cost Pool total / Cost driver

Calculation of Machine Setup CostActivity Based Costing Formula Example1.1

Machine setup cost / Number of Machine setups

=2,00,000 / 340

Machine Setup Cost = 588.24

Calculation of Inspection Cost

Activity Based Costing Formula Example1.2

Inspection cost /Inspection hours

=1,40,000 / 7500

Inspection Cost= 18.67

Example # 2

The following details pertain to different activities and their costs for Gamma Ltd. You are required to calculate the overhead rate for each activity.

Below is given data for calculation.

Activity Based Costing Formula Example2

We are here given five activities; hence, we need to allocate those costs based upon their cost drivers.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Using the ABC formula: Cost Pool total / Cost driver

Each activity pool’s total cost is divided by its cost driver to arrive at different rates.

Overhead Rate for the Purchasing Activity

Example2.1

Overhead Rate for the Purchasing Activity = 1,20,000 / 200

Activity-Based Costing for Purchasing will be –

Example2.2

Overhead Rate for the Purchasing Activity =600.00

Similarly, do the calculation of ABC Cost Formula for all the cost pool activities

Activity Based Costing Formula Example2-3

Total Estimated Overhead = 862500.00

Example # 3

Mamata Inc., a manufacturing company of drugs, is considering switching from their traditional method of cost to a newly implemented system by their production head. It is activity-based costing so that the two products Z serum and W serum can be sold at their proper cost and make them price competitive in the market.

Below are the production details that have been derived from the production sheet.

Example3

You are required to arrive at product-based total cost using ABC formula.

We are here given six activities; hence, we need to allocate those costs based upon their cost drivers.

Using the ABC formula: Cost Pool total / Cost driver

Each activity pool’s total cost is divided by its cost driver to arrive at different rates.

Overhead Rate for the Purchasing Activity

Example3-1

Overhead Rate for the Purchasing Activity = 60000/1000

For Purchasing, it will be –

Example3-2

Overhead Rate for the Purchasing Activity = 60.00

Similarly, do the calculation of ABC Cost Formula for all the cost pool activities

Example3-3

And the total estimated overhead is 506250.00

After arriving at different rates, we now have to arrive at product level total cost, which would be nothing but multiplying different overhead rates as arrived above with their actual cost drivers.

Example3-4

Relevance and Uses

It is a type of cost allocation process where it identifies all kinds of company’s costs and allocates them to the costs to the products based on actual consumption.

It will enhance the process of cost in 3 different ways. First, it will expand the number of cost pools, which can later be used to assign those overhead costs. So, it pools costs by activity instead of accumulating these costs in one organization-wide pool. Second, instead of on volume measures like direct labor costs or machine hours, it will create new bases to assign these overhead costs to items upon these activities, which shall generate costs. Lastly, it makes cost traceable to these activities.

Recommended Articles

This article has been a guide to what is Activity Based Costing (ABC) & its definition. Here we discuss the formula of activity-based costing along with its calculation & practical examples. You may learn more about excel from the following articles –

  • Standard Costing Methods
  • Semi Variable Cost
  • Formula of Variable Costing
  • Absorption Costing
  • Predetermined Overhead Rate Formula
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Activity Based Costing Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More