Overview
This Excel template is a useful tool to break-down overhead costs, through the activity based costing approach. Activity-based costing allocates overhead costs based on the different duties that are necessary for the production of the goods and services. It looks at all the potential activities required to produce a product, such as designing products, setting up machinery, and distributing end products, rather than just a single variable. One of the main advantages of using activity-based costing to calculate overhead is that you can easily identify what are the main contributors to your overhead expense. It is also the more precise and common approach companies use to allocate their overhead costs, compared to job-order costing and variance analysis where overhead costs are allocated based on specific cost driver such as machine hours or labor hours.

How to Use This Template

While being a simple Excel template that anyone can use, it is intended for intermediate users who have some basic understanding of accounting topics such as: This template consists of input cells in blue font and output cells in black font. To calculate the manufacturing overhead, simply input all your assumptions and data in the input cells and the outputs will be generated for you automatically! This is an easy-to-use Excel template to help users quickly determine overhead cost based on activities contributed. Users are also free to modify the activities to other relevant activities for calculating their own OH cost.

Learn More About Activity-Based Costing

Read CFI's guide to learn about the definition and use of this type of costing method. This guide covers a detailed example which compares between activity-based approach and labor hours approach to allocating overhead costs.  
Share
Reviews Add a review
Avatar
Dominik Newton

Thanks

More From Corporate Finance Institute®

Browse our top rated business templates. See All
restructuring financial model template preview 1 Restructuring Financial Model Template
209
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
320
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…
bank financial model template preview 1 Bank Financial Model Template
301
0
This bank financial model template is used to value financial institutions group (FIG) companies. This is a comprehensive model that…
Synthetic Call Chart Option Profit/Loss Graph Maker
901
239
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
722
0
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
424
106
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…