3.3: Using Activity-Based Costing to Allocate Overhead Costs (Part 2)

Comparison of ABC to Plantwide Costing at SailRite

After going through the process of allocating overhead using activity-based costing, John Lester (the company accountant) called a meeting with the same management group introduced at the beginning of the chapter: Cindy Hall (CEO), Mary McCann (vice president of marketing), and Bob Schuler (vice president of production). As you read the following dialogue, refer to Figure 3.7, which summarizes John’s findings.

Cindy: What do you have for us, John? I think you’ll find the results of our most recent costing analysis very interesting. We used an approach called activity-based costing to allocate overhead to products. I recall being interviewed last week about the activities involved in the production process. Yes, here’s what we found. The old allocation approach indicates that the Basic boat costs $2,880 to build and the Deluxe boat costs$3,650 to build. Our average sales price for the Basic is $3,200 and$4,500 for the Deluxe. You can see why we pushed sales of the Deluxe boat—it has a profit of $850 per boat. John, from your analysis, it looks as if we were wrong about the Deluxe boat being the most profitable. We do have some startling results. Using activity-based costing, an approach I think is much more accurate, the Deluxe boat is not profitable at all. In fact, we lose$530 for each Deluxe boat sold, and the profits from the Basic boat are much higher than we thought at $596 per unit. I see direct materials and direct labor are the same no matter which costing system we use. Why is there such a large variation in overhead costs? Good question! When we used our old approach of one plantwide rate based on direct labor hours, the Deluxe process consumed 20 percent of all direct labor hours worked—that is, 50,000 Deluxe hours divided by 250,000 total hours. Therefore the Deluxe model was allocated 20 percent of all overhead costs. Using activity-based costing, we identified five key activities and assigned overhead costs based on the use of these activities. The Deluxe process consumed more than 20 percent of the resources provided for every activity. For example, running machines is one of the most costly activities, and the Deluxe model used about 44 percent of the resources provided by this activity. This is significantly higher than the 20 percent allocated using direct labor hours under the old approach. This certainly makes sense! Each Deluxe boat takes a whole lot more machine hours to produce than the Basic boat. Thanks for this analysis, John. Now we know why company profits have been declining even though sales have increased. Either the Deluxe sales price must go up or costs must go down—or a combination of both! Figure 3.7 - Activity-Based Costing Versus Plantwide Costing at SailRite Company *From Figure 3.2 **From Figure 3.5. Question: SailRite has more accurate product cost information using activity-based costing to allocate overhead. Why is the overhead cost per unit so different using activity-based costing? Answer: Figure 3.8 provides a more thorough look at how the Deluxe product consumes a significant share of overhead resources—much higher than the 20 percent that was being allocated based on direct labor hours. Let’s look at Figure 3.8 in detail: • The ABC column represents overhead costs allocated using the activity-based costing shown back in Figure 3.5. • The DLH (direct labor hours) column represents overhead costs allocated using direct labor hours as the allocation base where 80 percent was allocated to the Basic boat (= 200,000 hours ÷ 250,000 total hours) and 20 percent allocated to the Deluxe boat (= 50,000 hours ÷ 250,000 total hours). • The Diff. (difference) column shows the difference between one allocation method and the other. Notice the shift in the allocation of overhead costs using activity-based costing. A total of$1,380,000 in overhead costs shifts to the Deluxe sailboat, which amounts to $1,380 per boat (=$1,380,000 ÷ 1,000 boats).

Figure 3.8 - Detailed Analysis of Overhead Allocations at SailRite Company

*Amounts in this column come from Figure 3.5.

**Amounts in this column are calculated by multiplying 80 percent for the Basic boat (20 percent for the Deluxe) by the total overhead cost for the activity. For example, the total overhead cost for purchasing materials is $1,200,000 (see Figure 3.4 ) and$1,200,000 × 80 percent = $960,000. Using the plantwide approach (one plantwide rate based on direct labor hours),$960,000 is the amount allocated to the Basic sailboat for this activity, and $240,000 is the amount allocated to the Deluxe boat. The primary reason that using activity-based costing shifted overhead costs to the Deluxe sailboat is that producing each Deluxe boat requires more resources than the Basic boat. For example, the Basic boat requires 50,000 machine hours to produce 5,000 boats, and the Deluxe boat requires 40,000 machine hours to produce 1,000 boats. The number of machine hours required per boat produced is as follows: You can see from this analysis that the Deluxe boat consumes four times the machine hours of the Basic boat. At a rate of$30 per machine hour, the Deluxe boat is assigned $1,200 per boat for this activity ($30 rate × 40 machine hours) while the Basic boat is assigned $300 per boat ($30 rate × 10 machine hours).

Question: Activity-based costing undoubtedly provides better cost information than most traditional costing methods, such as plantwide and department allocation methods. However, ABC has its limitations. What are the advantages and disadvantages of using activity-based costing?

More accurate cost information leads to better decisions. The cost information provided by ABC is generally regarded as more accurate than the information provided by most traditional costing methods. This allows management to make better decisions in areas such as product pricing, product line changes (adding products or eliminating products), and product mix decisions (how much of each product to produce and sell).

Increased knowledge of production activities leads to process improvements and reduced costs. ABC requires identifying the activities involved in the production process (step 1) and assigning costs to these activities (step 2). This provides management with a better view of the detailed activities involved (purchasing materials, machine setups, inspections, and so forth) and the cost of each activity. Managers are more likely to focus on improving efficiency in the most costly activities, thereby reducing costs.

ABC systems can be costly to implement. ABC systems require teamwork across the organization and therefore require employees to take time out from their dayto-day activities to assist in the ABC process (e.g., to identify costly activities). Assigning costs to activities takes time, as does identifying and tracking cost drivers. And assigning costs to products requires a significant amount of time in the accounting department. Imagine having 15 cost pools (activities), each with a predetermined overhead rate used to assign overhead costs to the company’s 80 products—not an unrealistic example for a large company. The accounting costs incurred to maintain such a system can be prohibitively high.

Unitizing fixed costs can be misleading. Product costing involves allocating costs from activity centers to products and calculating a product cost per unit. The problem with this approach is that fixed costs are often a large part of the overhead costs being allocated (e.g., building and machinery depreciation and supervisor salaries). Recall that fixed costs are costs that do not change in total with changes in activity.

Looking back to the SailRite example using activity-based costing, the Deluxe sailboat cost $5,030 per unit to produce based on production of 1,000 units (as shown in Figure 3.5). If SailRite produces 2,000 units of the Deluxe boat, will the unit cost remain at$5,030? Probably not. A significant portion of overhead costs are fixed and will be spread out over more units, thereby reducing the cost per unit. We address this issue at length in later chapters. The point here is that managers must beware of using per unit cost information blindly for decision making, particularly if a significant change in the level of production is anticipated.

The benefits may not outweigh the costs. Companies with one or two products that require very little variation in production may not benefit from an ABC system. Suppose a company produces one product. The overhead costs can be divided into as many cost pools as you like, but all overhead costs will still be assigned to the one product. (We should mention, however, that management would benefit from understanding the activities involved in the process and the costs associated with each activity. It’s the allocation to the one product—steps 4 and 5 of ABC—that would provide little useful information in this scenario.)

Companies that produce several different products may believe that the benefits of implementing ABC will outweigh the costs. However, management must be willing to use the ABC information to benefit the company. Companies like Chrysler Group LLC have been known to try ABC, only to meet resistance from their managers.

Until managers are willing to use the ABC information to make improvements in the organization, there is no point in implementing such a system.

Characteristics of Companies That Use Activity-Based Costing

A survey of 130 U.S. manufacturing companies yielded some interesting results. The companies that used activity-based costing (ABC) had higher overhead costs as a percent of total product costs than companies that used traditional costing. Those using ABC also had a higher level of automation. The complexity of production processes and products tended to be higher for those using ABC, and ABC companies operated at capacity more frequently.

It is important to note that the differences between companies using ABC and companies using traditional costing systems in all these areas—overhead costs, automation, complexity of production, and frequency of capacity—were relatively small. However, users of ABC indicated their systems were more adequate than traditional systems in providing useful information for performance evaluation and cost reduction.

Source: Susan B. Hughes and Kathy A. Paulson Gjerde, “Do Different Cost Systems Make a Difference?” Management Accounting Quarterly, Fall 2003.

ABC Cost Flows

Question: How are overhead costs recorded when using activity-based costing?

For example, assume production of SailRite’s Basic sailboats has the following cost driver activity for one week of operations:

*From Figure 3.4.

The entry to record overhead applied to the Basic sailboats for the week is as follows:

Recall from Chapter 2 that the manufacturing overhead account is closed to cost of goods sold at the end of the period. If actual overhead costs are higher than applied overhead, the resulting underapplied overhead is closed with a debit to cost of goods sold and a credit to manufacturing overhead. If actual overhead costs are lower than applied overhead, the resulting overapplied overhead is closed with a debit to manufacturing overhead and a credit to cost of goods sold.

Recap of Three Allocation Methods

We have discussed three different methods of allocating overhead to products—plantwide allocation, department allocation, and activity-based costing. Remember, total overhead costs will not change in the short run, but the way total overhead costs are allocated to products will change depending on the method used

Figure 3.9 presents the three allocation methods, using SailRite as an example. Notice that the three pie charts in the illustration are of equal size, representing the $8,000,000 total overhead costs incurred by SailRite. Figure 3.9 - The Three Methods of Overhead Allocation Overhead Rates: 1 Allocated based on direct labor hours (DLH):$8,000,000 ÷ 250,000 DLH = $32 per DLH. 2 Allocated based on direct labor hours (DLH):$5,000,000 ÷ 217,000 DLH = $23 per DLH. 3 Allocated based on machine hours (MH):$3,000,000 ÷ 60,000 MH = $50 per MH. 4 Allocated based on direct labor hours (DLH):$1,500,000 ÷ 250,000 DLH = $6 per DLH. 5 Allocated based on inspection hours (IH):$1,000,000 ÷ 20,000 IH = $50 per IH. 6 Allocated based on purchase requisitions (PR):$1,200,000 ÷ 10,000 PR = $120 per PR. 7 Allocated based on machine setups (MS):$1,600,000 ÷ 2,000 MS = $800 per MS. 8 Allocated based on machine hours (MH):$2,700,000 ÷ 90,000 MH = $30 per MH. KEY TAKEAWAY Activity-based costing focuses on identifying the activities required to make products, on forming cost pools for each activity, and on allocating overhead costs to the products based on their use of each activity. ABC systems and traditional systems often result in vastly different product costs. But even if the resulting product costs are not much different, ABC provides managers with a better understanding of the production activities required for each activity and the associated costs, which often leads to improved efficiency and reduced costs. BUSINESS IN ACTION 3.2 Using Activity-Based Costing to Argue Predatory Pricing BuyGasCo Corporation, a privately owned chain of gas stations based in Florida, was taken to court for selling regular grade gasoline below cost, and an injunction was issued. Florida law prohibits selling gasoline below refinery cost if doing so injures competition. Using a plantwide approach of allocating costs to products, the plaintiff’s costing expert was able to support the allegation of predatory pricing. The defendant’s expert witness, an accounting professor, used activity-based costing to dispute the allegation. Both costing experts had to allocate costs to each of the three grades of gasoline (regular, plus, and premium) to determine a total cost per grade of fuel and a cost per gallon for each grade. Sales of regular grade fuel were significantly higher (63 percent of total sales) than the other two grades. Using the plantwide approach, the plaintiff‘s expert allocated all costs based on gallons of gas sold. Using the activity-based costing approach, the defendant‘s expert formed three activity cost pools—labor, kiosk, and gas dispensing. The first two cost pools allocated costs using gallons of gas sold and therefore were allocated as they would be with the plantwide approach (63 percent for regular grade, 20 percent for plus, and 17 percent for premium). The third cost pool (gas dispensing) allocated costs equally to each grade of fuel (i.e., one-third of costs to each grade of fuel). The gas dispensing pool included costs for storage tanks, all of which were the same size, as well as gas pumps and signs. Compared with the plantwide approach, activity-based costing showed a lower cost per gallon for regular gas and a higher cost per gallon for the other two grades of fuel. Once the ABC information was presented, the case was settled, and the initial injunction was lifted. Sources: Thomas L. Barton and John B. MacArthur, “Activity-Based Costing and Predatory Pricing: The Case of the Petroleum Retail Industry,” Management Accounting, Spring 2003; All Business, “Home Page,” http://www.allbusiness.com. REVIEW PROBLEM 3.3 Parker Company produces an inkjet printer that sells for$150 and a laser printer that sells for $350. Last year, total overhead costs of$1,050,000 were allocated based on direct labor hours. A total of 15,000 direct labor hours were required last year to build 12,000 inkjet printers (1.25 hours per unit), and 10,000 direct labor hours were required to build 4,000 laser printers (2.50 hours per unit). Total direct labor and direct materials costs for the year were as follows:

Inkjet Printer Laser Printer
Direct materials $540,000$320,000
Direct labor $600,000$400,000

The management of Parker Company would like to use activity-based costing to allocate overhead rather than use one plantwide rate based on direct labor hours. The following estimates are for the activities and related cost drivers identified as having the greatest impact on overhead costs.

Required:

1. Calculate the direct materials cost per unit and direct labor cost per unit for each product.
2.
1. Using the plantwide allocation method, calculate the predetermined overhead rate and determine the overhead cost per unit for the inkjet and laser products.
2. What is the cost per unit for the inkjet and laser products?
3.
1. Using the activity-based costing allocation method, calculate the predetermined overhead rate for each activity. (Hint: Step 1 through step 3 in the activity-based costing process have already been done for you; this is step 4.)
2. Using the activity-based costing allocation method, allocate overhead to each product. (Hint: This is step 5 in the activity-based costing process.) Determine the overhead cost per unit. Round amounts to the nearest dollar.
3. What is the product cost per unit for the inkjet and laser products?
4. Calculate the per unit profit for each product using the plantwide approach and the activity-based costing approach. Comment on the differences between the results of the two approaches.
1. The cost per unit for direct materials is as follows:

The cost per unit for direct labor is as follows:
2.
1. The plantwide allocation used by Parker Company is based on direct labor hours. The predetermined overhead rate is calculated as follows: $$\begin{split} \frac{\text{Estimated overhead cost}}{\text{Estimated activity in allocation base}} &= \frac{1,050,000}{25,000\; hours} \\ &= \text{\ 42 per direct labor hours} \end{split}$$Because the inkjet printer requires 1.25 direct labor hours to build and the laser printer takes 2.50 direct labor hours to build (both figures are provided in the problem data), $52.50 in overhead is allocated to 1 unit of the inkjet product (=$42 rate × 1.25 hours) and $105 in overhead is allocated to 1 unit of the laser product ($42 rate × 2.50 direct labor hours).
2. Per unit product costs are as follows:

Direct materials and direct labor determined from Question 1.
*$52.50 = 1.25 direct labor hours per unit ×$42 rate.
**$105 = 2.50 direct labor hours per unit ×$42 rate.
3.
1. Predetermined overhead rates are calculated for each activity as follows:
2. Overhead costs are allocated as follows:

*Overhead allocated equals the predetermined overhead rate times the cost driver activity.
**Overhead cost per unit for the inkjet printer equals $695,000 (overhead allocated) ÷ 12,000 units produced, and for the laser printer,$355,000 ÷ 4,000 units produced. Amounts are rounded to the nearest dollar.
3. Per unit product costs are as follows:

Direct materials and direct labor determined from Question 1. Overhead determined from Question 3b.

4. Although unit product costs do not change significantly for the inkjet printer when activity-based costing is used (from $147.50 to$153), the cost increases enough to result in a $3 loss for each unit. Conversely, the laser printer costs decrease significantly from$285 to $269 per unit when using activity-based costing, resulting in a profit of$81 per unit.

The shift in overhead costs to the inkjet printer is primarily a result of the inkjet printer using 80 percent of the production run resources and thus being assigned 80 percent of the overhead costs associated with production runs. The plantwide rate approach only assigned 60 percent of all overhead costs to the inkjet printer, including those related to production runs (60 percent = 15,000 inkjet direct labor hours ÷ 25,000 total direct labor hours).