Implementing Activity-Based Costing

Learning Objective 5 Cost products or services using activity-based costing

Now that you understand the basic concepts of ABC, let’s see how Plastim’s managers develop an ABC system by refining the simple costing system. We will also compare the two systems, and identify the factors to consider when deciding whether to develop an ABC system.

Implementing ABC at Plastim

To implement ABC, Plastim’s managers follow the seven-step approach to costing and the three guidelines for refining costing systems (trace more costs as direct costs, increase the number of homogenous indirect-cost pools, and identify cost drivers of the costs in the cost pools). Exhibit 5-3 shows an overview of Plastim’s ABC system. Use this exhibit as a guide as you study the following steps, each of which is marked in Exhibit 5-3.

Exhibit 5-3

Overview of Plastim’s Activity-Based Costing System

A flowchart shows the step-by-step, overview of Plastim’s activity-based costing system.
The details of the flowchart are as follows: Step 1: Cost object: S3 and C5 lenses Step 2: Direct costs: Direct materials; Direct manufacturing labor; Mold cleaning and maintenance Step 3: Cost-allocation base: 100 parts-square feet; 2,000 setup-hours; 12,750 molding machine-hours; 1,500 shipment setup-hours; 67,500 cubic feet delivered; 39,750 direct manufacturing labor-hours Step 4: Indirect–cost pool: Design activity: dollar 450,000; Molding machine setup activity: dollar 300,000; Molding machine operations activity: dollar 637,500; Shipment setup activity: dollar 81,000; Distribution activity: dollar 391,500; Administration activity: dollar 255,000 Step 5: dollar 4,500 per part square foot; dollar 150 per setup-hour; dollar 50 per molding machine-hour; dollar 54 per shipment setup-hour; dollar 5.80 per cubic foot delivered; dollar 6.4151 per direct manufacturing labor-hour; Step 6: Includes indirect costs Step 7: Includes both direct as well as indirect costs
  1. Step 1: IDENTIFY THE PRODUCTS THAT ARE THE CHOSEN COST OBJECTS. The cost objects are the 60,000 S3 and the 15,000 C5 lenses that Plastim will produce in 2020. Plastim’s managers want to determine the total costs and then the per-unit cost of designing, manufacturing, and distributing these lenses.
  2. Step 2: IDENTIFY THE DIRECT COSTS OF THE PRODUCTS. The managers identify the following direct costs of the lenses because these costs can be easily and unambiguously traced to a specific mold and lens: direct material costs, direct manufacturing labor costs, and mold cleaning and maintenance costs.
  3. Exhibit 5-5 shows the direct and indirect costs for the S3 and C5 lenses using the ABC system. The direct costs calculations appear on lines 6, 7, 8, and 9 in Exhibit 5-5. Plastim’s managers classify all other costs as indirect costs, as we will see in Exhibit 5-4.

Exhibit 5-4

Activity-Cost Rates for Indirect-Cost Pools

A screenshot of a spreadsheet shows the activity-cost rates for indirect-cost pools.

The details of the spreadsheet are as follows:

  1. Activity: Design

    1. Cost hierarchy category: Product sustaining

    2. Total budgeted indirect costs (Step 4): dollar 450,000

    3. Budgeted quantity of cost-allocation base (Step 3): 100 parts-square feet

    4. Budgeted indirect cost rate (Step 5): dollar 4,500 per part-square foot (budgeted cost divided by budget quantities)

    5. Cause-and-effect relationship between allocation base and activity cost; Design Department indirect costs increase with more complex molds (more parts, larger surface area).

  2. Activity: Molding machine setup

    1. Cost hierarchy category: Batch-level

    2. Total budgeted indirect costs (Step 4): dollar 300,000

    3. Budgeted quantity of cost-allocation base (Step 3): 2,000 setup-hours

    4. Budgeted indirect cost rate (Step 5): dollar 150 per setup-hour (budgeted cost divided by budget quantities)

    5. Cause-and-effect relationship between allocation base and activity cost; Indirect setup costs increase with setup-hours.

  3. Activity: Machine operations

    1. Cost hierarchy category: Output unit level

    2. Total budgeted indirect costs (Step 4): dollar 637,500

    3. Budgeted quantity of cost-allocation base (Step 3): 12,750 molding machine hours

    4. Budgeted indirect cost rate (Step 5): dollar 50 per molding machine-hour (budgeted cost divided by budget quantities)

    5. Cause-and-effect relationship between allocation base and activity cost; Indirect costs of operating molding machines increases with molding machine-hours.

  4. Activity: Shipment setup

    1. Cost hierarchy category: Batch-level

    2. Total budgeted indirect costs (Step 4): dollar 81,000

    3. Budgeted quantity of cost-allocation base (Step 3): 1,500 shipment setup-hours

    4. Budgeted indirect cost rate (Step 5): dollar 54 per shipment setup-hour (budgeted cost divided by budget quantities)

    5. Cause-and-effect relationship between allocation base and activity cost; Shipping costs incurred to prepare batches for shipment increase with the number of shipment setup-hours.

  5. Activity: Distribution

    1. Cost hierarchy category: Output-unit level

    2. Total budgeted indirect costs (Step 4): dollar 391,500

    3. Budgeted quantity of cost-allocation base (Step 3): 67,500 cubic feet delivered

    4. Budgeted indirect cost rate (Step 5): dollar 5.80 per cubic foot delivered (budgeted cost divided by budget quantities)

    5. Cause-and-effect relationship between allocation base and activity cost; Distribution costs increase with the cubic feet of packages delivered.

  6. Activity: Administration

    1. Cost hierarchy category: Facility sustaining

    2. Total budgeted indirect costs (Step 4): dollar 255,000

    3. Budgeted quantity of cost-allocation base (Step 3): 39,750 direct manuf. labor-hours

    4. Budgeted indirect cost rate (Step 5): dollar 6.4151 per direct manuf. labor-hour (budgeted cost divided by budget quantities)

    5. Cause-and-effect relationship between allocation base and activity cost; The demand for administrative resources increases with direct manufacturing labor-hours.

Exhibit 5-5

Plastim’s Product Costs Using an Activity-Based Costing System

A screenshot of a spreadsheet shows the Plastim’s product costs using activity-based costing system.

Table shows the total and per unit costs of 60,000 simple S3 lenses, and 15,000 complex C5 lenses.

  1. Direct costs

    1. Direct material

    2. Total direct material S3 lenses: dollar 1,125,000

    3. Per unit direct material S3 lenses: dollar 18.75

    4. Total direct material C5 lenses: dollar 675,000

    5. Per unit direct material C5 lenses: dollar 45.00

    6. Total direct material (sum of S3 and C5): dollar 1,800,000

    7. Direct manufacturing labor

    8. Total direct manufacturing labor S3 lenses: dollar 600,000

    9. Per unit direct manufacturing labor S3 lenses: dollar 10.00

    10. Total direct manufacturing labor C5 lenses: dollar 195,000

    11. Per unit direct manufacturing labor C5 lenses: dollar 13.00

    12. Total direct manufacturing labor (sum of S3 and C5): dollar 795,000

    13. Direct mold cleaning and maintenance costs

    14. Total direct mold cleaning and maintenance costs S3 lenses: dollar 120,000

    15. Per unit direct mold cleaning and maintenance costs S3 lenses: dollar 2.00

    16. Total direct mold cleaning and maintenance costs C5 lenses: dollar 150,000

    17. Per unit direct mold cleaning and maintenance costs C5 lenses: dollar 10.00

    18. Total direct mold cleaning and maintenance costs-labor (sum of S3 and C5): dollar 270,000

    19. Total direct costs (Step 2)

    20. Total direct costs S3 lenses: dollar 1,845,000

    21. Per unit total direct costs S3 lenses: dollar 30.75

    22. Total direct costs C5 lenses: dollar 1,020,000

    23. Per unit total direct costs C5 lenses: dollar 68.00

    24. Total direct costs (sum of S3 and C5): dollar 2,865,000

  2. Indirect Costs

    1. Design

    2. Total S3 design cost (30 parts-sq. ft. times dollar 4,500): dollar 135,000

    3. Per unit S3 design cost: dollar 2.25

    4. Total C5 design cost (70 parts-sq. ft. times dollar 4,500): dollar 315,000

    5. Per unit C5 design cost: dollar 21.00

    6. Total design cost: dollar 450,000

  3. (b) Setup of molding machines

    1. Total S3 setup cost (500 setup-hours times dollar 150): dollar 75,000

    2. Per unit S3 setup cost: dollar 1.25

    3. Total C5 setup cost (1,500 setup-hours times dollar 150): dollar 225,000

    4. Per unit C5 setup cost: dollar 15.00

    5. Total setup cost: dollar 300,000

  4. (c) Machine operations

    1. Total S3 machine operations cost (9,000 molding machine-hours times dollar 50): dollar 450,000

    2. Per unit S3 machine operations cost: dollar 7.50

    3. Total C5 machine operations cost (3,750 molding machine-hours times dollar 50): dollar 187,500

    4. Per unit C5 machine operations cost: dollar 12.50

    5. Total machine operations cost: dollar 637,500

    6. Shipment setup

    7. Total S3 shipment setup cost (750 shipment setup hours times dollar 54): dollar 40,500

    8. Per unit S3 shipment setup cost: dollar 0.67

    9. Total C5 shipment setup cost (750 shipment setup hours times dollar 54): dollar 40,500

    10. Per unit C5 shipment setup cost: dollar 2.70

    11. Total shipment setup cost: dollar 81,000

    12. Distribution

    13. Total S3 distribution cost (45,000 cubic feet delivered times dollar 5.80): dollar 261,000

    14. Per unit S3 distribution cost: dollar 4.35

    15. Total C5 distribution cost (22,500 cubic feet delivered times dollar 5.80): dollar 130,500

    16. Per unit C5 distribution cost: dollar 8.70

    17. Total distribution cost: dollar 391,500

    18. Administration

    19. Total S3 administration cost (30,000 dir. manuf. labor-hours times dollar 6.4151): dollar 192,453

    20. Per unit S3 administration cost: dollar 3.21

    21. Total C5 administration cost (9,750 dir. manuf. labor-hours times dollar 6.4151): dollar 62,547

    22. Per unit C5 administration cost: dollar 4.17

    23. Total administration cost: dollar 255,000

  5. Total indirect costs allocated (Step 6)

    1. Total indirect costs S3 lenses: dollar 1,153,953

    2. Per unit total indirect costs S3 lenses: dollar 19.23

    3. Total indirect costs C5 lenses: dollar 961,047

    4. Per unit total indirect costs C5 lenses: dollar 64.07

    5. Total indirect costs (sum of S3 and C5): dollar 2,115,000

  6. Total costs (Step 7)

    1. Total costs S3 lenses: dollar 2,998,953

    2. Per unit total costs S3 lenses: dollar 49.98

    3. Total costs C5 lenses: dollar 1,981,047

    4. Per unit total costs C5 lenses: dollar 132.07

    5. Total costs (sum of S3 and C5): dollar 4,980,000

  1. Step 3: SELECT THE ACTIVITIES AND COST-ALLOCATION BASES TO USE FOR ALLOCATING INDIRECT COSTS TO THE PRODUCTS. Following guideline 2 (increase the number of homogenous indirect-cost pools) and guideline 3 (identify cost drivers of the costs in the cost pools) for refining a costing system (pages 156–157), Plastim’s managers identify six activities in order to allocate indirect costs to products: (1) design, (2) molding machine setup, (3) machine operations, (4) shipment setup, (5) distribution, and (6) administration. Exhibit 5-4, column 2, shows the cost hierarchy category, and column 4 shows the cost-allocation base and the budgeted total quantity of the cost-allocation base for each activity described in column 1.
  2. Identifying the cost-allocation bases effectively defines the activity pools into which costs must be grouped in an ABC system. For example, rather than define the design activities of product design, process design, and prototyping as separate activities, Plastim’s managers group them as a combined “design” activity and form a homogenous design-cost pool. Why? Because the same cost driver—the complexity of the mold—drives the cost of each design activity. In contrast, the manufacturing department identifies two activity-cost pools—a molding machine setup-cost pool and a machine operations-cost pool—instead of a single manufacturing overhead cost pool, because each activity has a different cost driver: setup-hours for the molding machine setup-cost pool and machine-hours for the machine operations-cost pool.
  3. Step 4: IDENTIFY THE INDIRECT COSTS ASSOCIATED WITH EACH COST-ALLOCATION BASE. In this step, Plastim’s managers try to assign budgeted indirect costs for 2020 to the activities identified in Step 3 (see Exhibit 5-4, column 3) on the basis of a cause-and-effect relationship between the identified cost-allocation base for an activity and the individual indirect costs. For example, all costs that have a cause-and-effect relationship to cubic feet of packages moved are assigned to the distribution-cost pool. Of course, the strength of the cause-and-effect relationship between the cost-allocation base and the cost of an activity varies across cost pools. For example, the cause-and-effect relationship between direct manufacturing labor-hours and administration activity costs, which, as we discussed earlier, is somewhat arbitrary, is not as strong as the relationship between setup-hours and setup activity costs, where setup-hours is the cost driver of setup costs.
  4. Some indirect costs can be directly identified with a particular activity. For example, salaries paid to design engineers and depreciation of equipment used in the design department are directly identified with the design activity. Other indirect costs need to be allocated across activities. For example, on the basis of interviews or time records, manufacturing engineers and supervisors estimate the time they will spend on design, molding machine setup, and molding machine operations. If a manufacturing engineer spends 15% of her time on design, 45% of her time managing molding machine setups, and 40% of her time on molding operations, the company will allocate the manufacturing engineer’s salary to each of these activities in proportion to the time spent. Another example is rent costs that are allocated to activity-cost pools on the basis of square-feet area used by the different activities.
  5. As you will see, most costs do not fit neatly into activity categories. Often, costs first need to be allocated to activities (Stage 1 of the two-stage cost-allocation model) before the costs of the activities can then be allocated to cost objects such as products (Stage 2).
  6. The following table shows the assignment of indirect costs to the seven activities identified in Step 3. Recall that Plastim’s management accountants reclassify mold-cleaning costs as a direct cost because these costs can be easily traced to a specific mold and lens.
<p>A table shows the assignment of indirect costs to the seven activities identified in Step 3</p>

The table depicts salaries, wages of support staff, depreciation, maintenance, power and fuel, rent, and total for seven activities (design, molding machine setup, molding operations, mold cleaning, shipment setup, distribution, and administration) and total. The details of the table are as follows:

  1. Salaries (supervisors, design engineers, process engineers)
    • Design: 320,000 dollars
    • Molding machine setup: 105,000 dollars
    • Molding operations: 137,500 dollars
    • Mold cleaning: 0 dollars
    • Shipment setup: 21,000 dollars
    • Distribution: 61,500 dollars
    • Administration: 165,000 dollars
    • Total: 810,000 dollars
  1. Wages of support staff
    • Design: 65,000 dollars
    • Molding machine setup: 115,000 dollars
    • Molding operations: 70,000 dollars
    • Mold cleaning: 234,000 dollars
    • Shipment setup: 34,000 dollars
    • Distribution: 125,000 dollars
    • Administration: 40,000 dollars
    • Total: 683,000 dollars
  1. Depreciation
    • Design: 24,000 dollars
    • Molding machine setup: 30,000 dollars
    • Molding operations: 290,000 dollars
    • Mold cleaning: 18,000 dollars
    • Shipment setup: 11,000 dollars
    • Distribution: 140,000 dollars
    • Administration: 15,000 dollars
    • Total: 528,000 dollars
  1. Maintenance
    • Design: 13,000 dollars
    • Molding machine setup: 16,000 dollars
    • Molding operations: 45,000 dollars
    • Mold cleaning: 12,000 dollars
    • Shipment setup: 6,000 dollars
    • Distribution: 25,000 dollars
    • Administration: 5,000 dollars
    • Total: 122,000 dollars
  1. Power and fuel
    • Design: 18,000 dollars
    • Molding machine setup: 20,000 dollars
    • Molding operations: 35,000 dollars
    • Mold cleaning: 6,000 dollars
    • Shipment setup: 5,000 dollars
    • Distribution: 30,000 dollars
    • Administration: 10,000 dollars
    • Total: 124,000 dollars
  1. Rent
    • Design: 10,000 dollars
    • Molding machine setup: 14,000 dollars
    • Molding operations: 60,000 dollars
    • Mold cleaning: 0 dollars
    • Shipment setup: 4,000 dollars
    • Distribution: 10,000 dollars
    • Administration: 20,000 dollars
    • Total: 118,000 dollars
  1. Total
    • Design: 450,000 dollars
    • Molding machine setup: 300,000 dollars
    • Molding operations: 637,500 dollars
    • Mold cleaning: 270,000 dollars
    • Shipment setup: 81,000 dollars
    • Distribution: 391,500 dollars
    • Administration: 255,000 dollars
    • Total: 2,385,000 dollars
  1. Step 5: COMPUTE THE RATE PER UNIT OF EACH COST-ALLOCATION BASE. Exhibit 5-4, column 5, summarizes the calculation of the budgeted indirect-cost rates using the budgeted total quantity of each cost-allocation base from Step 3 and the total budgeted indirect costs of each activity from Step 4.
  2. Step 6: COMPUTE THE INDIRECT COSTS ALLOCATED TO THE INDIVIDUAL PRODUCTS. Exhibit 5-5 shows total budgeted indirect costs of $1,153,953 allocated to the simple lens and $961,047 allocated to the complex lens. Follow the budgeted indirect-cost calculations for each lens in Exhibit 5-5. For each activity, Plastim’s operations personnel budget the total quantity of the cost-­allocation base that will be used by each type of lens (recall that Plastim operates at capacity). For example, lines 15 and 16 in Exhibit 5-5 show that of the 2,000 total setup-hours, the S3 lens is budgeted to use 500 hours and the C5 lens 1,500 hours. The budgeted indirect-cost rate is $150 per setup-hour (Exhibit 5-4, column 5, line 5). Therefore, the total budgeted cost of the setup activity allocated to the S3 lens is $75,000 (500 setup‐hours×150 pre setup‐hour) and to the C5 lens is $225,000 (1,500 setup‐hours×150 per setup‐hour). The budgeted setup cost per unit equals $1.25 ($75,000÷60,000 units) for the S3 lens and $15($225,000÷15,000 units)  for the C5 lens.
  3. Next consider shipment setup costs. Plastim supplies its S3 and C5 lenses to two different Giovanni plants. One of these is an international plant in Mexico. Preparing for these shipments is more time consuming than preparing shipments to the local plant in Indiana because of additional documents related to customs, taxes, and insurance. The following table shows the budgeted number of shipments of S3 and C5 lenses to each plant.
<p>A table shows the budgeted number of shipments of S3 and C5 lenses to each plant</p>

The table depicts simple S3 lens shipments and complex C5 lens shipments to the Mexico plant and Indiana plant in addition to total shipments. The details of the table are as follows:

  1. Simple S3 lens shipments
    • Mexico plant shipments: 10
    • Indiana plant shipments: 100
    • Total shipments: 110
  1. Complex C5 lens shipments
    • Mexico plant shipments: 30
    • Indiana plant shipments: 60
    • Total shipments: 90
  1. Total shipments: 200
  1. Each shipment to the Mexico plant requires 12.5 hours of the shipment department personnel’s time, while each shipment to the Indiana plant requires half that time, 6.25 hours. The following table indicates the budgeted shipping setup-hours for the S3 and C5 lenses.
<p>A table gives budgeted shipping setup-hours for the S3 and C5 lenses</p>

The table depicts simple S3 lens shipment setup-hours and complex C5 lens shipment setup-hours for the Mexico plant and Indiana plant as well as total shipment setup-hours. The details of the table are as follows:

  1. Simple S3 lens shipment setup-hours
    • Mexico plant (12.5 hours times 10): 125
    • Indiana plant (6.25 hours times 100): 625
    • Total: 750
  1. Complex C5 lens shipment setup-hours
    • Mexico plant (12.5 hours times 30): 375
    • Indiana plant (6.25 hours times 60): 375
    • Total: 750
  1. Total shipment setup-hours: 1,500
  1. The budgeted indirect-cost rate is $54 per shipment setup-hour (Exhibit 5-4, column 5, line 7). Therefore, lines 21 and 22 in Exhibit 5-5 show that the total budgeted cost of the shipment setup activity allocated to the S3 lens is $40,500 (750 shipment setup‐hours×$54 per shipment setup‐hour) and to the C5 lens is $40,500 (750 shipment setup‐hours×$54 per shipment setup‐hour). Budgeted setup cost per unit equals $0.67 ($40,500÷60,000 units) for the S3 lens and $2.70 ($40,500÷15,000 units) for the C5 lens.
  2. Costing for shipment setups using shipment setup-hours as the cost driver is another example of time-driven activity-based costing (TDABC) because available time is used to allocate the costs in the activity pool. TDABC allows Plastim’s managers to account for the varying complexity in the shipments of S3 and C5 lenses. Notice that if Plastim had ignored the complexity of different shipments and allocated costs to lenses based only on the number of shipments, it would have calculated a budgeted indirect-cost rate of $405 per shipment in Exhibit 5-4 ($81,000÷200 shipment) Using this rate the total budgeted cost of the shipment setup activity allocated to the S3 lens is $44,550 (110 shipments×$405 per shipment) and to the C5 lens is $36,450 (90 shipments×$54 per shipment). The budgeted setup cost per unit equals $0.74 ($44,550÷60,000 units) for the S3 lens and $2.43 ($36,450÷15,000 units) for the C5 lens. Using the number of shipments, rather than shipment setup-hours, as the cost driver would overcost the simple S3 lens and undercost the complex C5 lens.
  3. Step 7: COMPUTE THE TOTAL COST OF THE PRODUCTS BY ADDING ALL DIRECT AND INDIRECT COSTS ASSIGNED TO THE PRODUCTS. Exhibit 5-5 presents the product costs for the simple and complex lenses. The direct costs are calculated in Step 2, and the indirect costs are calculated in Step 6. The ABC system overview in Exhibit 5-3 shows three direct-cost categories and six indirect-cost categories. The budgeted cost of each lens type in Exhibit 5-5 has nine line items, three for direct costs and six for indirect costs. The differences between the ABC product costs of S3 and C5 calculated in Exhibit 5-5 highlight how each of these products uses different amounts of direct and indirect costs related to each of the activities.

Watch Try It Video

We emphasize two features of ABC systems. First, these systems identify all costs used by products, whether the costs are variable or fixed in the short run. Thus, ABC systems lend themselves to making long-run strategic decisions where managers want revenues to exceed total costs. Otherwise, a company will make losses and will be unable to continue in business. Second, recognizing the hierarchy of costs is critical when allocating costs to products. Management accountants use the cost hierarchy to first calculate the total costs of each product. They then derive per-unit costs by dividing total costs by the number of units produced.