Allocating overhead costs based on “activities” that actually contribute to overhead costs
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
Activity-based costing is a more specific way of allocating overhead costs based on “activities” that actually contribute to overhead costs. In job-order costing and variance analysis, overhead costs are applied based on a specific cost driver such as labor hours or machine hours.
An activity is an event, task, or unit of work with a specific purpose, whether it be designing products, setting up machines, operating machines, or distributing products. Therefore, activity-based costing considers all the potential activities instead of relying on just one variable (for example, labor hours or machine hours).
Generally, activity-based costing is used in the manufacturing industry, as it produces more accurate cost data, generating values that are close to the true cost and can be identified during the production phase.
Activity-based costing serves and complements many other analyses and measures, including target costing, product costing, product line profitability analysis, service pricing, and more. Thus, it is used to better understand the company’s true costs, and thereby formulate an appropriate pricing strategy to mitigate unnecessary expenses.
Let take a look at the following example to compare the differences:
XYZ Company manufactures and sells two types of tables: Standard and Luxury. Annual sales, direct labor hours, and total direct labor hours per year are provided below:
Total | |
---|---|
Standard: 2,000 units * 5 labor hours per unit | 10,000 |
Luxury: 10,000 units * 4 labor hours per unit | 40,000 |
Total Labor Hours | 50,000 |
Costs for materials and labor for each table are provided below:
Standard | Luxury | |
---|---|---|
Direct Materials | $25 | $17 |
Direct Labor ($12 per hour) | $60 | $48 |
Manufacturing overhead costs total $800,000 every year. The breakdown of these costs among the company’s six activity cost pools is given below. The following six activities contribute to overall overhead costs.
Estimated MOH | Standard | Luxury | Total | |
---|---|---|---|---|
Labor related | $80,000 | 10,000 | 40,000 | 50,000 |
Machine setups | $150,000 | 3000 | 2,000 | 5,000 |
Parts administration | $160,000 | 50 | 30 | 80 |
Production orders | $70,000 | 100 | 300 | 400 |
Material receipts | $90,000 | 150 | 600 | 750 |
General factory machine hours | $250,000 | 12,000 | 28,000 | 40,000 |
Using the predetermined overhead rate approach with labor hours, the predetermined overhead rate is equal to $16 per labor hour ($800,000 / 50,000 labor hours). Using this information, we can design a cost card for each product.
Standard Luxury
Direct materials $25 $17
Direct labor $60 $48
Manufacturing overhead applied:
Standard: 5 labor hours * $16 per labor hour $80
Luxury: 4 labor hours * $16 per labor hour $64
Unit product cost $165 $129
Using the activity-based costing approach, we can determine overhead rates for each activity that is relevant to production. The activities listed below are given in this example but companies usually break down the relevant activities.
Activity | Estimated MOH | Total per Activity | Overhead Rate |
---|---|---|---|
Labor related | $80,000 | 50,000 hours | $1.60 per labor hour |
Machine setups | $150,000 | 5,000 setups | $30.00 per setup |
Parts administration | $160,000 | 80 parts | $2,000 per part |
Production orders | $70,000 | 400 orders | $175 per order |
Material receipts | $90,000 | 750 receipts | $120 per receipt |
General factory machine hours | $250,000 | 40,000 machine hours | $6.25 per machine hour |
Next, for each product, we can use the calculated overhead rates to determine the overhead numbers:
Standard | Luxury | |||
---|---|---|---|---|
Activity | Expected Activity | Overhead applied | Expected Activity | Overhead applied |
Labor-related | 10,000 | $16,000 | 40,000 | $64,000 |
Machine setups | 3,000 | $90,000 | 2,000 | $60,000 |
Part administration | 50 | $100,000 | 30 | $60,000 |
Production orders | 100 | $17,500 | 300 | $52,500 |
Material receipts | 150 | $18,000 | 600 | $72,000 |
General factory machine hours | 12,000 | $75,000 | 28,000 | $175,000 |
Total | $316,500 | $483,500 | ||
Units produced | 2,000 | Units produced | 10,000 | |
Overhead cost per unit | $158.25 | Overhead cost per unit | $48.35 |
Under the activity-based approach, the unit cost card gives different unit product costs for each product.
Standard | Luxury | |
---|---|---|
Direct materials | $25 | $17 |
Direct labor | $60 | $48 |
Manufacturing overhead applied: | ||
Standard: 5 labor hours * $16 per labor hour | $158.25 | |
Luxury: 4 labor hours * $16 per labor hour | $48.35 | |
Unit product cost | $243.25 | $113.35 |
Download CFI’s Excel template to advance your finance knowledge and perform better financial analysis.
Activity-based costing (ABC) can affect the cost distribution process in three ways:
By comparing the first unit cost card (i.e., when manufacturing overhead is applied based on just one variable: direct labor hours) and the second unit cost card (i.e., when manufacturing overhead is applied based on several important activities), we can see that the unit product cost for each product is generally similar. However, the activity-based approach is the more specific and precise way that companies will allocate their manufacturing overhead costs.
For the standard product, we can see that the manufacturing overhead cost per unit is much lower for the regular labor-based approach. In producing the product, more overhead costs were actually put into the process than estimated by the labor approach.
In contrast, for the luxury product, manufacturing overhead costs based on labor hours were higher when compared to the activity-based approach. When considering all relevant activities, overhead costs in manufacturing each product are actually less than that estimated by labor hours only.
Therefore, even though labor hours or machine hours may be a good starting point for companies to get a general idea of potential overhead costs, they can use activity-based costing as an alternative if they are looking to get a more exact assessment of overhead.
Access and download collection of free Templates to help power your productivity and performance.
Already have an account? Log in
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.
Already have a Full-Immersion membership? Log in