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:

  1. Identify the activities performed in the organization
  2. Determine activity cost pools
  3. Calculate activity rates for each cost pool
  4. Allocate activity rates to products (or services)
  5. 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:

Production
  • 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.

Activities and Common Cost Drivers
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:

Activities and Estimated Overhead Costs
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:

Expected Cost Driver Activities
         
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

Driver Predetermined Overhead Rate
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

Allocate Cost to Product
         
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.

Musicality’s Accounting Information
       
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

Musicality’s Accounting Information
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.

5.3a ExampleVideo Play Button

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

  1. 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.
  2. 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.
  3. 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
  1. How much does each mattress cost to manufacture?
  2. 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:

Horizontal Model
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:

Horizontal Model
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

 

5.3b ExampleVideo Play Button

Princess Consuela’s Dresses shows the following actual manufacturing overhead.

Horizontal Model
Balance Sheet
Cash + Raw Materials + Manuf. Overhead + Work in Process + Finished Goods = Liability + Common Stock + Retained Earnings
41,000 = 41,000

Instructions

  1. If a total of $45,000 of overhead is applied to all jobs, is overhead over- or under-applied?
  2. 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?
  3. If a total of $39,000 of overhead is applied to all jobs, is overhead over- or under-applied?
  4. 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.

Horizontal Model
Balance Sheet
Cash + Raw Materials + Manuf. Overhead + Work in Process + Finished Goods = Liability + Common Stock + Retained Earnings
30,000 = 30,000

Instructions

  1. If a total of $28,000 of overhead is applied to all jobs, is overhead over- or under-applied?
  2. 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?
  3. How does this amount effect the cost of jobs already delivered to customers?
  4. If a total of $33,000 of overhead is applied to all jobs, is overhead over- or under-applied?
  5. 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?
  6. 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

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Accounting, The Language of Business Copyright © 2024 by JoAnn Wood is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book