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

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.


