Commerce Costing
Commerce Costing
System Design:
    Activity Based Costing
    PowerPoint Authors:
          Jon A. Booker, Ph.D., CPA, CIA
          Charles W. Caldwell, D.B.A., CMA
          Susan Coomer Galbreath, Ph.D., CPA
Learning Objective 1
                The
                The departmental
                     departmental approach
                                    approach relies
                                              relies
      exclusively
      exclusively on
                  on volume-related
                      volume-related allocation
                                      allocation bases
                                                  bases while
                                                         while
        some
         some overhead
               overhead costs
                          costs may
                                 may be
                                     be caused
                                        caused byby factors
                                                     factors
        that
        that are
             are not
                 not related
                     related to
                             to the
                                the volume
                                    volume of
                                            of production.
                                               production.
      Activity-base
      Activity-base costing
                    costing is
                             is required
                                required to
                                          to account
                                             account for
                                                     for these
                                                         these
                          other
                          other factors.
                                  factors.
3-8
                           Activities
                           Activities
                  Consumption
                  Consumption of
                              of Resources
                                 Resources
                             Cost
                             Cost
3-10
Examples of Activities
                       Admitting
       Setting up                       Billing      Opening a
                        hospital
       machines                       customers     bank account
                        patients
3-11
                          A predetermined overhead
         Activity
                             rate for each activity
          Rate                     cost pool.
3-12
       AA predetermined
          predetermined overhead
                           overhead rate
                                       rate is
                                             is computed
                                                computed for  for
           each
           each activity
                 activity and
                          and then
                               then applied
                                     applied toto jobs
                                                   jobs and
                                                         and
           products
            products based
                      based onon the
                                  the amount
                                      amount of  of activity
                                                     activity
               consumed
                consumed by by the
                                the job
                                     job or
                                         or product.
                                            product.
3-13
       Designing an Activity-Based
       Costing System
         The
         The challenge
              challenge isis to
                              to select
                                 select aa reasonably
                                           reasonably
        small
        small number
              number of of activities
                           activities that
                                       that explain
                                             explain the
                                                      the
         bulk
         bulk of
              of the
                  the variation
                      variation inin overhead
                                     overhead costs.
                                                costs.
       Activities
       Activities are
                  are usually
                       usually chosen
                               chosen by
                                       by interviewing
                                            interviewing aa
         broad
         broad range
                 range of
                        of managers
                            managers to
                                      to find
                                          find out
                                               out what
                                                   what
         activities
         activities they
                     they think
                           think consume
                                 consume most
                                            most of
                                                  of the
                                                      the
                   organization’s
                   organization’s resources.
                                   resources.
3-14
       Designing an Activity-Based
       Costing System
            Related activities are
       frequently combined to reduce
          the amount of detail and
            record-keeping costs.
                                  For example, several activities may
                                  be involved in handling and moving
                                   raw materials, but these may be
                                    combined into a single activity
                                       entitled material handling.
       An
       An activity
            activity dictionary
                     dictionary defines
                                 defines each
                                           each of of the
                                                       the activities
                                                           activities
        that
         that will
              will be
                   be included
                       included in
                                 in the
                                     the activity-based
                                         activity-based costing
                                                            costing
        system
         system andand how
                         how the
                              the activities
                                  activities will
                                              will be
                                                   be measured.
                                                        measured.
3-15
       Hierarchy of Activities
  Level
  Level           Activities
                  Activities                         Activity
                                                     Activity Measure
                                                              Measure
 Unit-level
 Unit-level       Processing
                  Processing units
                             unitson
                                   on machines
                                      machines       Machine-hours
                                                     Machine-hours
                  Processing
                  Processing units
                             unitsby
                                   byhand
                                      hand           Direct
                                                     Directlabor-hours
                                                            labor-hours
                  Consuming
                  Consuming factory
                              factorysupplies
                                     supplies        Units
                                                     Unitsproduced
                                                            produced
 Batch-level
 Batch-level      Processing
                  Processing purchase
                              purchaseorders
                                       orders        Purchase
                                                     Purchaseorders
                                                               ordersprocessed
                                                                      processed
                  Processing
                  Processing production
                              production orders
                                         orders      Production
                                                     Production orders
                                                                 ordersprocessed
                                                                        processed
                  Setting
                  Setting up
                          up equipment
                             equipment               Number
                                                     Numberofofsetups
                                                                setups
                  Handling
                  Handling materials
                            materials                Pounds
                                                     Poundsofofmaterial
                                                                materialhandled
                                                                        handled
 Product-level
 Product-level    Testing
                  Testing new
                          new products
                               products              Hours
                                                     Hoursof
                                                           oftesting
                                                              testing time
                                                                       time
                  Administering
                  Administering parts
                                 partsinventories
                                       inventories   Number
                                                     Numberofofpart
                                                                parttypes
                                                                     types
                  Designing
                  Designing products
                             products                Hours
                                                     Hoursof
                                                           ofdesign
                                                              design time
                                                                       time
 Facility-level
 Facility-level   General
                  Generalfactory
                          factoryadministration
                                   administration    Direct
                                                     Directlabor-hours
                                                            labor-hours
                  Plant
                  Plantbuilding
                        building and
                                 and grounds
                                     grounds         Direct
                                                     Directlabor-hours
                                                            labor-hours
3-16
       Graphic Example of
       Activity-Based Costing
                Various Manufacturing Overhead Costs
       Graphic Example of
       Activity-Based Costing
                   Various Manufacturing Overhead Costs
Second-Stage Allocations
                                      Products
               Unit-Level             Batch-Level       Product-Level Facility-Level
                Activity                Activity           Activity     Activity
3-18
                                      DVD
                                      DVD        CD
                                                 CD
                                     Units
                                      Units    Units
                                                Units
                Direct
                Direct materials
                       materials     $$ 90
                                        90     $$ 50
                                                   50
                Direct
                Direct Labor
                       Labor         $$ 20
                                        20     $$ 20
                                                   20
3-21
  Predetermined         $10,000,000
                =                     = $20 per DLH
  overhead rate        500,000 DLHs
3-22
Learning Objective 2
Learning Objective 3
Learning Objective 4
           The
           The ABC
                 ABC system
                      system assigns
                              assigns $14.45
                                       $14.45
           less
            less overhead
                 overhead than
                           than the
                                the traditional
                                    traditional
               system
               system to
                       to each
                          each CD
                               CD player.
                                    player.
3-32
          The
          The ABC
               ABC system
                    system assigns
                            assigns $57.80
                                      $57.80
          more
          more overhead
                overhead than
                          than the
                               the traditional
                                   traditional
            system
            system toto each
                        each DVD
                             DVD player.
                                   player.
3-33
        Low-volume product
When
When aa company
        company implements
                   implements activity-based
                                 activity-based costing,
                                                costing,
overhead
overhead cost
          cost often
                often shifts
                       shifts from
                              from high-volume
                                   high-volume toto low-
                                                    low-
  volume
  volume products
          products with
                     with aa higher
                             higher unit
                                    unit product
                                         product cost
                                                  cost
       resulting
       resulting for
                 for the
                     the low-volume
                         low-volume products.
                                       products.
3-34
High-volume product
 The
 The traditional
      traditional system
                  system assigns
                           assigns the
                                    the same
                                        same amount
                                              amount of
                                                     of
   all
   all overhead
        overhead costs
                   costs to
                         to each
                            each CD
                                  CD oror DVD
                                          DVD player
                                              player
                     ($40
                      ($40 per
                            per unit).
                                unit).
3-35
                1.
                1. Compute
                    Compute the
                             the number
                                  number of of units
                                               units processed
                                                     processed
                   per
                   per production
                       production order
                                   order for
                                          for each
                                              each product.
                                                     product.
                                                         DVD
                                                         DVD Units
                                                              Units   CD
                                                                      CD Units
                                                                          Units
       Number
       Number of
              of units
                 unitsproduced
                       produced per
                                per year
                                     year                   50,000
                                                            50,000     200,000
                                                                        200,000
       Number
       Number of
              of production
                 production orders
                            ordersissued
                                   issued per
                                          per year
                                               year            800
                                                                800        400
                                                                            400
       Number
       Number of
              of units
                 unitsprocessed
                       processed per
                                 per production
                                      production order
                                                 order        62.5
                                                               62.5        500
                                                                            500
3-36
                                                      DVD
                                                       DVDUnits
                                                          Units CDCDUnits
                                                                    Units
        Cost
        Costtoto issue
                  issue aa production
                           production order
                                       order          $$ 2,625
                                                          2,625 $$ 2,625
                                                                     2,625
        Average
        Average number
                    number of ofunits
                                unitsprocessed
                                      processed per
                                                per
           production
             production order
                            order                           62.5
                                                            62.5       500
                                                                       500
        Production
        Production order
                      order cost
                              costper
                                  per unit
                                       unit           $$   42.00
                                                           42.00 $$   5.25
                                                                      5.25
  Notice,
  Notice, the
           the costs
               costs are
                     are being
                            being shifted
                                   shifted from
                                            from the
                                                  the high
                                                      high
 volume
 volume CDCD players
              players to
                       to the
                           the low
                                low volume
                                    volume DVDDVD players.
                                                    players.
3-37
       Targeting Process
       Improvements
           An ABC system can help identify
        areas where the company can benefit
        from improving its current processes.
             Activity-Based
              Activity-Based Management
                             Management
       Focuses
       Focuses on
               on managing
                   managing activities
                             activities to
                                        to eliminate
                                           eliminate
         waste
         waste and
               and reduce
                     reduce delays
                            delays and
                                    and defects.
                                         defects.
3-38
       Targeting Process
       Improvements
               The
               The first
                   first step
                         step in
                              in any
                                 any improvement
                                     improvement
             program
             program isis deciding
                          deciding what
                                   what to
                                        to improve.
                                           improve.
     The
     The Theory
         Theory of
                of Constraints
                    Constraints              Activity
                                             Activity rates
                                                       rates can
                                                             can be
                                                                  be
       approach
       approach targets
                 targets the
                         the                 used
                                             used toto target
                                                       target areas
                                                               areas
          highest
          highest impact
                   impact                     where
                                              where costs
                                                       costs seem
                                                              seem
   improvement
    improvement opportunities.
                  opportunities.              excessively
                                               excessively high.
                                                              high.
          Benchmarking
           Benchmarking can
                          can be
                              be used
                                  used to
                                        to compare
                                           compare activity
                                                     activity cost
                                                              cost
        information
         information with
                     with world-class
                          world-class standards
                                       standards of
                                                  of performance
                                                     performance
                   achieved
                    achieved by
                              by other
                                 other organizations.
                                        organizations.
3-39
       Benefits of Activity-Based
       Costing
   ABC
   ABC improves
        improves the
                  the accuracy
                      accuracy of
                               of product
                                  product costing
                                          costing by:
                                                  by:
   •• Increasing
       Increasing the
                   the number
                        number ofof cost
                                    cost pools
                                          pools used
                                                 used toto accumulate
                                                           accumulate
      overhead
       overhead costs.
                  costs.
   •• Using
       Using activity
              activity cost
                       cost pools
                            pools that
                                   that are
                                         are more
                                              more homogeneous
                                                     homogeneous thanthan
      departmental
       departmental cost
                       cost pools.
                            pools.
   •• Assigning
       Assigning overhead
                  overhead costs
                               costs using
                                      using activity
                                             activity measures
                                                      measures that
                                                                 that
      cause
       cause those
              those costs,
                      costs, rather
                             rather than
                                     than relying
                                           relying solely
                                                    solely on
                                                           on direct
                                                              direct
      labor
       labor hours.
             hours.
       Activity-based
       Activity-based costing
                       costing also
                                also highlights
                                     highlights activities
                                                 activities
             that
             that could
                  could benefit
                        benefit most
                                 most from
                                       from process
                                             process
          improvement
           improvement efforts,
                         efforts, such
                                  such asas Six
                                            Six Sigma.
                                                Sigma.
3-40
   Limitations of Activity-Based
   Costing
          Costs of implementing an ABC system may outweigh
          the benefits. However, the benefits are more likely to be
          worth the costs when:
       1. Products differ substantially in volume, batch size, and in
          activities required.
       2. Conditions have changed substantially since the existing
          cost system was established.
       3. Overhead costs are high and increasing and no one seems
          to understand why.
       4. Management does not trust the existing cost system and it
          ignores data from it when making decisions.
3-41
       Activity-Based Costing
       Critical Assumption
     The
     The cost
          cost in
               in each
                   each activity
                         activity pool
                                  pool is
                                       is strictly
                                          strictly
  proportional
  proportional to
                to its
                   its activity
                       activity measure
                                measure.. When
                                           When this
                                                   this
   assumption
   assumption isis violated,
                    violated, the
                              the accuracy
                                  accuracy ofof ABC
                                                ABC
        data
        data can
             can be be called
                       called into
                               into question.
                                    question.
  For
  For example,
      example, managers
                managers should
                             should be
                                     be particularly
                                        particularly
   alert
   alert to
         to product
            product costs
                    costs that
                            that contain
                                 contain allocated
                                         allocated
                facility-level
                facility-level costs
                               costs..
3-42
Learning Objective 5
                                                  Estimated
                                                  Estimated
                                                  Overhead
                                                  Overhead
       Activity
       Activity Cost
                Cost Pool
                       Pool Activity
                            Activity Measure
                                      Measure       Cost
                                                    Cost       Expected
                                                               Expected Activity
                                                                        Activity
       Machine
       Machine related
                  related Machine
                            Machine hours
                                       hours     $$ 175,000
                                                     175,000      5,000
                                                                  5,000 MHs
                                                                         MHs
       Purchase
       Purchase orders
                   orders Number
                            Number of of orders
                                         orders       63,000
                                                      63,000        700
                                                                    700 orders
                                                                         orders
       Machine
       Machine setups
                  setups Number
                            Number of of setups
                                         setups       92,000
                                                      92,000        460
                                                                    460 setups
                                                                         setups
       Product
       Product testing
                 testing    Number
                            Number of of tests
                                         tests      160,000
                                                     160,000        200
                                                                    200 tests
                                                                         tests
       General
       General factory
                factory     Direct
                            Direct labor
                                    labor hours
                                           hours    300,000
                                                     300,000     25,000
                                                                 25,000 DLHs
                                                                         DLHs
                                                 $$ 790,000
                                                     790,000
3-45
                           Estimated
                           Estimated              Total
                                                  Total
                           Overhead
                            Overhead           Expected
                                                Expected
       Activity
       ActivityCost
                CostPool
                      Pool    Cost
                               Cost             Activity
                                                 Activity          Activity
                                                                    ActivityRate
                                                                            Rate
       Machine
       Machinerelated
                 related   $$ 175,000
                              175,000    ÷÷   5,000
                                              5,000MHs
                                                     MHs    ==   $$ 35
                                                                     35 perperMH
                                                                               MH
       Purchase
       Purchaseorders
                  orders       63,000
                                63,000   ÷÷   700
                                              700orders
                                                   orders   ==   $$ 90
                                                                     90 perperorder
                                                                               order
       Machine
       Machinesetups
                 setups        92,000
                                92,000   ÷÷   460
                                              460setups
                                                   setups   ==   $$ 200
                                                                    200 perpersetup
                                                                               setup
       Product
       Producttesting
                testing       160,000
                              160,000    ÷÷   200
                                              200tests
                                                   tests    ==   $$ 800
                                                                    800 perpertest
                                                                               test
       General
       Generalfactory
                factory       300,000
                              300,000    ÷÷   25,000
                                              25,000DLH
                                                      DLH   ==   $$ 12
                                                                     12 perperDLH
                                                                               DLH
                           $$ 790,000
                              790,000
3-46
          Description
          Description                  Debit
                                       Debit      Credit
                                                  Credit
       a.
       a. Raw
          Raw Materials
               Materials               915,000
                                       915,000
            Accounts
            Accounts Payable
                       Payable                    915,000
                                                  915,000
       b.
       b. Work
          Work in
                in Process
                   Process             810,000
                                       810,000
          Manufacturing
          Manufacturing Overhead
                         Overhead       90,000
                                        90,000
            Raw
            Raw Materials
                  Materials                       900,000
                                                  900,000
3-49
           Description
           Description                     Debit
                                           Debit     Credit
                                                     Credit
        c.
        c. Work
           Work in
                 in Process
                    Process                 95,000
                                            95,000
           Manufacturing
           Manufacturing Overhead
                          Overhead         275,000
                                           275,000
             Salaries
             Salaries and
                       and Wages
                           Wages Payable
                                 Payable             370,000
                                                     370,000
        d.
        d. Manufacturing
            Manufacturing Overhead
                           Overhead        180,000
                                           180,000
              Accumulated
              Accumulated Depreciation
                            Depreciation             180,000
                                                     180,000
3-50
           Description
           Description                  Debit
                                        Debit     Credit
                                                  Credit
        e.
        e. Manufacturing
           Manufacturing Overhead
                         Overhead       230,000
                                        230,000
             Cash/Accounts
             Cash/Accounts Payable
                            Payable               230,000
                                                  230,000
3-51
             Description
             Description                 Debit
                                         Debit     Credit
                                                   Credit
        f.f. Work
             Work in
                   in Process
                      Process            761,000
                                         761,000
               Manufacturing
               Manufacturing Overhead
                              Overhead              761,000
                                                    761,000
3-52
           Description
           Description                  Debit
                                        Debit      Credit
                                                   Credit
        g.
        g. Finished
           Finished Goods
                     Goods            1,650,000
                                      1,650,000
              Work
              Work in
                    in Process
                       Process                    1,650,000
                                                  1,650,000
3-53
Bal. 14,000
                      Underapplied
                     Overhead Costs
3-54
End of Chapter 3