Activity-Based Costing (ABC)

4. Comparison illustration of volume-based and activity-based costing

To better understand the differences between the traditional and activity-based costing and how those differences affect product profitability analysis as well as management decisions, we will look at the following 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

Direct labor-hours

30,000

20,000

Direct labor-hours per unit

3

4

Budgeted factory overhead

$600,000

Budgeted direct labor-hours

50,000

4.1. Using a volume-based costing system in an example

Let’s calculate the unit product cost using volume-based costing. Under traditional costing, the factory overhead cost is assigned based on direct labor-hours (DLH). The factory overhead rate is determined as follows:

Factory Overhead Rate per DLH = 
Total Factory Overhead
Total DLH

In this case, the factory overhead rate per DLH = $600,000 / 50,000 = $12 per DLH (i.e. plant-wide rate). Using this information, we can determine the total amount of factory overhead assigned to each product and the factory overhead cost per unit for both products:

 

GSV

MSC

Factory overhead cost per DLH

$12.00 per DLH

Direct labor hours

30,000

20,000

Factory overhead assigned

$360,000

$240,000

Production volume (in units)

10,000

5,000

Factory overhead cost per unit

$36.00

$48.00

Note: $360,000 = $12.00 x 30,000 and $240,000 = $12.00 x 20,000.

Now we can calculate the unit margin profit for each product and determine how profitable the products are:

   

GSV

MSC

Unit selling price

A

$78.00

$130.00

Less: Unit prime cost

B

($21.00)

($35.00)

Less: Unit overhead cost

C

($36.00)

($48.00)

Unit margin

D=A-B-C

$21.00

$47.00

Unit margin percentage

E=D/A x 100%

26.92%

36.15%

Note C: $36.00 = $12.00 x 3 hrs and $48.00 = $12.00 x 4 hrs.

Therefore, using the volume-based costing we can see that the product MSC is much more profitable than the product GSV. However, let’s use the activity-based costing and see if we can get the same or similar results.

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