Activity-Based Costing (ABC)

4.2. Using an activity-based costing (ABC) in an example

Friends Company, a manufacturer of valves, produces and sells two types of valves: Gas Safety Valves (GSV) and MSC Valves (MSC). Friends Company has the following data for the two products:

 

GSV

MSC

Production Volume

10,000

5,000

Selling Price

$78.00

$130.00

Unit prime cost

$21.00

$35.00

In addition, Friends Company has identified the following activities, costs, and activity consumption cost drivers:

Activity

Budgeted Cost

Cost Driver

Machine set-ups

$100,000

Number of set-ups

Machine running

$400,000

Machine-hours

Inspection

$70,000

Inspection-hours

Packing

$30,000

Number of packing-orders

Total

$600,000

 

Friends Company also collected the activity data for each product:

Cost Driver

GSV

MSC

Total

Number of set-ups

80

260

340

Machine-hours

18,000

36,000

54,000

Inspection-hours

3,000

4,000

7,000

Number of packing-orders

2,100

3,500

5,600

Using the total cost for each activity and the total amount of activity cost driver we can determine the activity cost rate:

Cost Driver

Cost ($)

Activity Amount

Activity Rate ($)

 

A

B

C=A/B

Number of set-ups

100,000

340

294.12

Machine-hours

400,000

54,000

7.41

Inspection-hours

70,000

7,000

10.00

Number of packing-orders

30,000

5,600

5.36

As we can see from the table above, one set-up costs $294.12, one machine-hour costs $7.41, one inspection-hour costs $10.00, and one packing order costs $5.36. Now, let’s calculate the per-unit cost of each product manufactured by Friends Company:

GSV (10,000 units)

Activity Cost Driver

Activity Rate

Activity Amount

Total Overhead

Overhead per Unit

 

A

B

C=A x B

D=C/10,000

Number of set-ups

$  294.12

80

$  23,529.60

$  2.35

Machine-hours

7.41

18,000

133,380.00

13.34

Inspection-hours

10.00

3,000

30,000.00

3.00

Number of packing-orders

5.36

2,100

11,256.00

1.13

Total

     

19.82


MSC (5,000 units)

Activity Cost Driver

Activity Rate

Activity Amount

Total Overhead

Overhead per Unit

 

A

B

C=A x B

D=C/5,000

Number of set-ups

$  294.12

260

$  76,471.20

$ 15.29

Machine-hours

7.41

36,000

266,760.00

53.35

Inspection-hours

10.00

4,000

40,000.00

8.00

Number of packing-orders

5.36

3,500

18,760.00

3.75

Total

     

80.39

The allocation of factory overhead using activity-based costing is summarized in the illustration below.

Illustration 4: Friends Company’s allocation of factory overhead costs using ABC

Friends Company’s allocation of factory overhead costs using ABC

Using the obtained data we can perform the product profitability analysis; that is, we will determine the unit margin profit of each product:

   

GSV

MSC

Unit selling price

A

$78.00

$130.00

Less: Unit prime cost

B

($21.00)

($35.00)

Less: Unit overhead cost

C

($19.82)

($80.39)

Unit margin

D=A-B-C

$37.18

$14.61

Unit margin percentage

E=D/A x 100%

47.67%

11.24%

According to the data presented in the table above, the MSC product is actually $22.57 ($37.18 – $14.61) less profitable than the GSV product. The unit margin percentage for the MSC product is lower than the one for the GSV product when using the activity-based costing. Therefore, the management of Friends Company might consider changing the production process of the MSC product (e.g. increase batch-size to decrease the cost of machine set-ups per item produced) and increasing the selling price (i.e. as long as the increase in selling price would not substantially decrease product sales).

Using this example we can see that activity-based costing provides a lot of information about production activities and how they affect the cost of products, which the volume-based costing system does not explain.

Let’s compare the product profitability analyses under volume-based and activity-based costing:

 

Volume-based Costing

Activity-based Costing

 

GSV

MSC

GSV

MSC

Unit selling price

$78.00

$130.00

$78.00

$130.00

Less: Unit prime cost

($21.00)

($35.00)

($21.00)

($35.00)

Less: Unit overhead cost

($36.00)

($48.00)

($19.82)

($80.39)

Unit margin

$21.00

$47.00

$37.18

$14.61

Unit margin percentage

26.92%

36.15%

47.67%

11.24%

As we can see from the table above, the product per-unit cost and per-unit margin profit differ under the volume-based and activity-based costing. The reason is that activity-based costing traces overhead consumption by each product and thus provides a more accurate per-unit overhead cost.

On the other hand, volume-based costing assigns factory overhead costs using direct labor-hours or machine-hours as a cost driver. As the result, volume-based costing undercosts low-volume product (i.e. products requiring fewer direct labor hours in total) and overcosts high-volume products (i.e. products requiring more direct labor-hours in total). In our example, the production of GSV product and MSC product required 30,000 and 20,000 direct labor-hours, respectively. Therefore, the overhead per unit cost for products GSV and MSC were overstated and understated, accordingly.

Using the data obtained under the activity-based costing, for example, we can see that the overhead per-unit cost of product GSV is overstated by $16.18 (i.e. $16.18 = $36.00 – $19.82) under the volume-based costing because the production of GSV requires more direct labor-hours (in total). Thus, a product – MSC in this case – is subsidized at the expense of others. In cost accounting this is called cross-subsidization.

<<    1    2    3    4    5    6    7    8    >>   

Benefits of registration
  • Utilize a diagnostic test
  • Access 250+ questions and solutions
  • Bookmark and re-visit important topics
  • Obtain certificate of completion
  • Read various accounting articles
  • Hide ads on all pages