Ch. 5 Cost Components and Cost-Volume-Profit
5.3 More about Manufacturing Overhead
Learning Objectives
After finishing this section, students will be able to:
- Understand the difference between applied and actual overhead.
- Know how to assign overhead using the activity based costing method.
Overhead is the hardest part of determining how much a project costs. In the previous section, we learned about predetermined overhead. In this section, we will learn how activity-based costing might be a better solution for overhead.
Activity-Based Costing
Activity-based costing (ABC) is an accounting method that recognizes the relationship between product costs and a production activity, such as the number of hours of engineering or design activity, the costs of the set up or preparation for the production of different products, or the costs of packaging different products after the production process is completed. Overhead costs are then allocated to production according to the use of that activity, such as the number of machine setups needed. In contrast, the traditional allocation method commonly uses cost drivers, such as direct labor or machine hours, as the single activity.
ABC is a five-stage process that allocates overhead more precisely than traditional allocation does by applying it to the products that use those activities. ABC works best in complex processes where the expenses are not driven by a single cost driver. Instead, several cost drivers are used as the overhead costs are analyzed and grouped into activities, and each activity is allocated based on each group’s cost driver. The five stages of the ABC process are:
- Identify the activities performed in the organization
- Determine activity cost pools
- Calculate activity rates for each cost pool
- Allocate activity rates to products (or services)
- Calculate unit product costs
Step 1
The first step is to identify activities needed for production. An activity is an action or process involved in the production of inventory. There can be many activities that consume resources, and management will need to narrow down the activities to those that have the biggest impact on overhead costs. Examples of these activities include:
- Taking orders
- Setting up machines
- Purchasing material
- Assembling products
- Inspecting products
- Providing customer service
Step 2
The second step is assigning overhead costs to the identified activities. In this step, overhead costs are assigned to each of the activities to become a cost pool. A cost pool is a list of costs incurred when related activities are performed. For example, the production cost pool consists of costs such as indirect labor for those accepting the order, verifying the customer has credit to pay for the order, maintenance and depreciation on the machines used to produce the orders, and utilities and rent for operating the machines. A list of cost pools and potential activities are as follows:
- Indirect labor setting up machines
- Indirect labor cost of accepting and verifying orders
- Machine maintenance costs
- Costs to operate the machine: utilities, insurance, etc.
Purchasing material
- Preparing purchase requisitions for the material
- Cost to move material from receiving department into production
- Depreciation of equipment used to move material
Inspect Products
- Inspection supervisor costs
- Cost to move product to and from the inspection area
Assemble Product
- Cost of assembly machine
- Cost of label machine
- Cost of labels
Technological production
- Website maintenance
- Depreciation of computers
Step 3
Once the costs are grouped into similar cost pools, the activities in each pool are analyzed to determine which activity “drives” the costs in that pool, leading to the third step of ABC: identify the cost driver for each cost pool and estimate an annual level of activity for each cost driver. As you’ve learned, the cost driver is the specific activity that drives the costs in the cost pools.
Activity Cost Pool | Cost Driver |
---|---|
Customer order | Number of orders |
Production | Machine setups |
Purchasing materials | Purchase requestions |
Assembling products | Direct labor hours |
Inspecting products | Inspection hours |
Customer Service | Number of contacts with customers |
Step 4
The fourth step is to compute the predetermined overhead rate for each of the cost drivers. This portion of the process is similar to finding the traditional predetermined overhead rate, where the overhead rate is divided by direct labor dollars, direct labor hours, or machine hours. Each cost driver will have its own overhead rate, which is why ABC is a more accurate method of allocating overhead.
Step 5
Finally, step five is to allocate the overhead costs to each product. The predetermined overhead rate found in step four is applied to the actual level of the cost driver used by each product. As with the traditional overhead allocation method, the actual overhead costs are accumulated in an account called manufacturing overhead and then applied to each of the products in this step.
Notice that steps one through three represent the process of allocating overhead costs to activities, and steps four and five represent the process of allocating the overhead costs that have been assigned to activities to the products to which they pertain. Thus, the five steps of ABC involve two major processes: first, allocating overhead costs to the various activities to get a cost per activity, and then allocating the cost per activity to each product based on that product’s usage of the activities.
Let’s look at Musicality, a company that produces music books. Musicality is making a positive gross profit each year but is considering switching to an activity-based costing approach for determining overhead and has collected data to help them decide which overhead allocation method they should use.
Step 1: Identify cost pools necessary to complete the product. Musicality determined its cost pools are:
-
- Setting up machines
- Purchasing material
- Inspecting products
- Assembling products
- Technological production
Step 2: Assign overhead cost to the cost pools. Based on historical information, Musicality has estimated the overhead for each cost pool to be:
Activity Measurement | Estimated Overhead Costs |
---|---|
Setting Up Machines | $200,000 |
Purchasing Material | 500,000 |
Inspecting Products | 300,000 |
Assembling Products | 600,000 |
Technological Production | 900,000 |
Total | $2,500,000 |
Step 3: Identify the cost driver for each activity, and estimate an annual activity for each driver. Musicality determined the driver and estimated activity for each product to be the following:
Cost Driver | Solo | Band | Orchestra | Total Activity |
---|---|---|---|---|
Machine Setups | 2,000 | 1,500 | 1,500 | 5,000 |
# of Purchase Requisitions | 5,000 | 4,000 | 1,000 | 10,000 |
Inspection Hours | 10,000 | 9,000 | 1,000 | 20,000 |
# of Parts Requiring Labor | 15,000 | 3,000 | 12,000 | 30,000 |
Machine Hours | 80,000 | 60,000 | 10,000 | 150,000 |
Step 4: Compute the predetermined overhead for each cost driver. Musicality determined this predetermined overhead rate for each driver by using the formula:
Estimated Overhead Costs / Total Activity = ABC Rate per Activity
Activity | Cost Driver | Estimated Overhead Costs | Total Activity | ABC Rate per Activity |
---|---|---|---|---|
Setting Up Machines | Machine Setups | $200,000 | 5,000 | $40 |
Purchasing Material | # of Purchase Requisitions | 500,000 | 10,000 | 50 |
Inspecting Products | Inspection Hours | 300,000 | 20,000 | 15 |
Assembling Products | # of Parts Requiring Labor | 600,000 | 30,000 | 20 |
Technological Production | Machine Hours | 900,000 | 150,000 | 6 |
Step 5: Allocate overhead costs to products. Assuming Musicality’s activities were as estimated, the amount allocated to each product is calculated by using the formula:
Cost Driver * ABC Rate per Activity = Allocated Overhead
Activity | Solo | Band | Orchestra | Total |
---|---|---|---|---|
Machine Setups | $80,000 | $60,000 | $60,000 | $200,000 |
Number of Purchase Requisitions | 250,000 | 200,000 | 50,000 | 500,000 |
Inspection Hours | 150,000 | 135,000 | 15,000 | 300,000 |
Number of Parts Requiring Labor | 300,000 | 60,000 | 240,000 | 600,000 |
Machine Hours | 480,000 | 360,000 | 60,000 | 900,000 |
Total Allocated Overhead | $1,260,000 | $815,000 | $425,000 | $2,500,000 |
Notice that the total overhead for machine setups of $200,000 has now been allocated fairly across the solo, band, and orchestra division. Now that Musicality has applied overhead to each product, they can calculate the cost per unit. Management can review its sales price and make necessary decisions regarding its products. During the year, the following information was gathered from musicality’s records.
Information | Solo | Band | Orchestra |
---|---|---|---|
Sales Price | $20.00 | $25.00 | $30.00 |
Direct Material per unit | $3.50 | $6.00 | $11.70 |
Direct Labor per unit | $10.00 | $2.75 | $4.30 |
Est. # of Units to be Produced | 140,000 | 100,000 | 250,000 |
Actual # of Units Produced | 150,000 | 110,000 | 200,000 |
With this information we can now determine how much overhead should be assigned to each product, determine our gross profit for each product, and verify if our products are being sold for the correct amount.
Total Allocated Product Overhead / Est. # of Units to be Produced = Overhead Cost per Unit
Solo: $1,260,000 / 140,000 = $9.00
Band: $815,000 / 100,000 = $8.15
Orchestra: $ 425,000 / 250,000 = $1.70
Information | Solo | Band | Orchestra |
---|---|---|---|
Per Unit | |||
Sales Price | $20.00 | $25.00 | $30.00 |
Direct Material | -3.50 | -6.00 | 11.70 |
Direct Labor | -10.00 | -2.75 | 4.30 |
Overhead | -9.00 | -8.15 | -1.70 |
Gross Profit per Unit | ($2.50) | $8.10 | $12.30 |
Based on Sales Actual Sold | |||
Actual # of Units Produced | 150,000 | 110,000 | 200,000 |
Gross Profit per Unit | x ($2.50) | x $8.10 | x $12.30 |
Gross Profit by Product | ($375,000) | $891,000 | $2,460,000 |
The calculations Musicality did in order to switch to ABC revealed that the Solo product was generating a loss for every unit sold. Knowing this information will allow Musicality to consider whether they should make changes to generate a profit from the Solo product, such as increase the selling price or carefully analyze the costs to identify potential cost reductions. Musicality could also decide to continue selling Solo at a loss, because the other products are generating enough profit for the company to absorb the Solo product loss and still be profitable.
Why would a company continue to sell a product that is generating a loss? Sometimes these products are ones for which the company is well known or that draw customers into the store. For example, companies will sometimes offer extreme sales, such as on Black Friday, to attract customers in the hope that the customers will purchase other products. This information shows how valuable ABC can be in many situations for providing a more accurate picture than traditional allocation.
Activity Cost Pool | Cost Driver | Expected Overhead Cost | Cost Driver Activity A | Cost Driver Activity B |
---|---|---|---|---|
Labor | Direct Labor hour | $156,000 | 6,000 | 11,000 |
Purchase Orders | # of Orders | $11,000 | 60 | 30 |
Parts management | # of Part Types | $80,000 | 30 | 15 |
General factory | Machine hours | $180,000 | 3,000 | 8,000 |
Instructions
- Complete the activity rate for each of the activity pools: a) Direct Labor Hour, b) # of Orders, c) # of Part Types, and d) Machine hours.
- Using the ABC data, determine the total amount of overhead cost assigned to PRODUCT A: a) Direct Labor Hour, b) # of Orders, c) # of Part Types, and d) Machine hours.
- The company produced 5,000 units of Product A. If Product A had $10.00 per unit in direct material and $15.00 per unit in direct labor costs, what is the TOTAL PRODUCT PER UNIT?
5.3a Practice
Activity |
Expected Overhead Cost |
Cost Driver |
Cost Driver Activity |
Machine Setup |
$20,000 |
Setup hours | 500 setup hours |
Inspection |
$15,000 |
Inspection hours | 300 inspection hours |
Order Processing |
$10,000 |
Orders processed | 200 orders |
For a particular product, if it requires 10 setup hours, 5 inspection hours, and 2 orders processed, what would be the cost allocation?
Check Figures
- Cost allocation for setup hours, $400
- Solution (Excel file will download)
5.3a Homework
Box Springs, Inc., makes two sizes of box springs: twin and double. For the twin mattress, direct material is $25 per unit and direct labor is $40 per unit. For the double mattress, direct material is $40 per unit and direct labor is $50 per unit. Box Springs estimates it will make 5,000 twins and 9,000 doubles in the next year. It estimates the overhead for each cost pool and cost driver activities as follows:
Activity Cost Pool | Cost Driver | Expected Overhead Cost | Cost Driver Activity Twin | Cost Driver Activity Double |
---|---|---|---|---|
Framing | Square feet of pine | $210,000 | 5,000 | 2,000 |
Padding | Square feet of quilting | $220,000 | 120,000 | 100,000 |
Filling | Square feet of filling | $320,000 | 500,000 | 300,000 |
Labeling | # of boxes | $240,000 | 800,000 | 400,000 |
Inspection | # of inspections | $170,000 | 12,000 | 5,000 |
- How much does each mattress cost to manufacture?
- If 4,875 twin mattress are sold for $220 and 9,075 double mattresses are sold for $500, how much profit is made?
Actual versus Applied Overhead
No matter how you allocate overhead, the actual overhead incurred during the year is rarely equal to the amount that was applied to the individual jobs. Thus, at year-end, the manufacturing overhead account often has a balance, indicating overhead was either overapplied or underapplied.
If, at the end of the term, there is a positive balance in manufacturing overhead, the overhead is considered underapplied overhead. A positive balance in manufacturing overhead shows either that not enough overhead was applied to the individual jobs or overhead was underapplied. If, at the end of the term, there is a negative balance in manufacturing overhead, more overhead was applied to jobs than was actually incurred. This shows the actual amount was overapplied overhead.
Since the overhead is first recorded in the manufacturing overhead account, then applied to the individual jobs, traced through finished goods inventory, and eventually transferred to cost of goods sold, the year-end balance is eliminated through an adjusting entry, offsetting the cost of goods sold. If manufacturing overhead has a positive balance, the overhead is underapplied, and the resulting amount in cost of goods sold is understated. The adjusting entry is:
Balance Sheet | Income Statement | |||||||||||||||||||
Cash | + | Raw Materials | + | Manuf. Overhead | + | Work in Process | + | Finished Goods | = | Liability | + | Common Stock | + | Retained Earnings | Revenue | – | Cost of Goods Sold | = | Net Income | Description |
-$$$ | = | -$$$ | – | $$$ | = | $$$ | COGS |
If manufacturing overhead has a negative balance, the overhead is overapplied, and the resulting amount in cost of goods sold is overstated. The adjusting entry is:
Balance Sheet | Income Statement | |||||||||||||||||||
Cash | + | Raw Materials | + | Manuf. Overhead | + | Work in Process | + | Finished Goods | = | Liability | + | Common Stock | + | Retained Earnings | Revenue | – | Cost of Goods Sold | = | Net Income | Description |
$$$ | = | $$$ | – | -$$$ | = | $$$ | COGS |
Princess Consuela’s Dresses shows the following actual manufacturing overhead.
Balance Sheet | ||||||||||||||
Cash | + | Raw Materials | + | Manuf. Overhead | + | Work in Process | + | Finished Goods | = | Liability | + | Common Stock | + | Retained Earnings |
41,000 | = | 41,000 |
Instructions
- If a total of $45,000 of overhead is applied to all jobs, is overhead over- or under-applied?
- If a total of $45,000 of overhead is applied to all jobs, what amount will be applied to cost of goods sold at the end of the period?
- If a total of $39,000 of overhead is applied to all jobs, is overhead over- or under-applied?
- If a total of $39,000 of overhead is applied to all jobs, what amount will be applied to cost of goods sold at the end of the period?
5.3b Practice
Pivot Solutions estimated $240,000 in total overhead costs for the year and applied this at a predetermined overhead rate of $4 per machine hour (based on 60,000 estimated machine hours). During the year, the company actually incurred $250,000 in overhead costs and used 58,000 machine hours.
What is the amount of over or under-applied overhead?
Check Figures
- Under-applied of -$18,000
- Solution (Excel file will download)
5.3b Homework
Rachel’s Custom Clothing shows the following actual manufacturing overhead.
Balance Sheet | ||||||||||||||
Cash | + | Raw Materials | + | Manuf. Overhead | + | Work in Process | + | Finished Goods | = | Liability | + | Common Stock | + | Retained Earnings |
30,000 | = | 30,000 |
Instructions
- If a total of $28,000 of overhead is applied to all jobs, is overhead over- or under-applied?
- If a total of $28,000 of overhead is applied to all jobs, what amount will be applied to cost of goods sold at the end of the period?
- How does this amount effect the cost of jobs already delivered to customers?
- If a total of $33,000 of overhead is applied to all jobs, is overhead over- or under-applied?
- If a total of $33,000 of overhead is applied to all jobs, what amount will be applied to cost of goods sold at the end of the period?
- How does this amount effect the cost of jobs already delivered to customers?
Licensing and Attribution:
Content on this page is adapted from the following openly licensed resource(s):
Principles of Accounting, Volume 2: Managerial Accounting by Mitchell Franklin, Patty Graybeal, and Dixon Cooper licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License