Title: Libby, Libby and Short
1Activity-Based Costing
Prepared by Douglas Cloud Pepperdine University
2Functional-Based ProductCosting Model
Direct Materials
Direct Labor
Overhead
PRODUCTS
3Goodmark CompanyAn Example
- Goodmark Company produces two products scented
and regular birthday cards.
4Goodmark CompanyAn Example
Product Costing Data
5Goodmark CompanyAn Example
Product Costing Data
Departmental Data
Cutting Dept. Printing Dept. Total
Direct labor hours Scented cards 10,000 10,000
20,000 Regular cards 150,000 10,000 160,000 T
otal 160,000 20,000 180,000 Machine hours Scen
ted cards 2,000 8,000 10,000 Regular cads 8,
000 72,000 80,000 Total 10,000 80,000 90,00
0
Continued
6Departmental Data
Cutting Dept. Printing Dept. Total
Overhead costs Setting up equipment 120,000
120,000 240,000 Moving materials 60,000 60,000
120,000 Machining 20,000 180,000 200,000 Inspe
cting products 16,000 144,000 160,000
Total 216,000 504,000 720,000
7Goodmark CompanyAn Example
Plantwide Overhead Rate
8Goodmark CompanyAn Example
Departmental Rates
9Goodmark CompanyAn Example
Departmental Rates
10Goodmark CompanyAn Example
Unit Cost Computation Plantwide Rates
Scented Cards Regular Cards
Prime costs 160,000 1,500,000
Overhead costs 4.00 x 20,000 80,000 4.00 x
160,000 640,000 Total manufacturing costs 24
0,000 2,140,000 Units of production 20,000
200,000 Unit cost 12.00 10.70
11Goodmark CompanyAn Example
Unit Cost Computation Departmental Rates
Scented Cards Regular Cards
Prime costs 160,000 1,500,000
Overhead costs (1.35 x 10,000) (6.30 x 8,0
00) 63,900 (2.35 x 150,000) (6.30
x 72,000) 656,100 Total manufacturing costs 22
3,900 2,156,100 Units of production 20,000
200,000 Unit cost 11.20 10.78
Rounded to nearest cent
12The Inadequacy of Plantwide and Departmental Rates
There are at least two major factors that can
impair the ability of the unit-based plantwide
and departmental rates to assign overhead costs
accurately (1) the proportion of nonunit-relat
ed overhead costs to total overhead costs is
large, and (2) the degree of product diversity i
s great.
13Goodmark CompanyAn Example
Product Diversity Consumption Ratios
Overhead Activity Scented Cards Regular Cards
Activity Drivers
Setups 0.60 0.40 Production runs
Moving materials 0.60 0.40 Number of moves
Machining 0.11 0.89 Machine hours
Inspection 0.11 0.89 Inspection hours
a a
b b c
c
d d
a b c d
60/100 (scented) and 40/100 (regular)
180/300 (scented) and 120/300 (regular)
10,000/90,000 (scented) and 80,000/90,000
(regular) 2,000/18,000 (scented) and 16,000/18,00
0 (regular)
rounded
14Goodmark CompanyAn Example
Unit Cost Computation Activity Rates
Scented Cards Regular Cards
Prime costs 160,000 1,500,000
Overhead costs Setting up 2,400 x 60 144,0
00 2,400 x 40 96,000 Machining 2.20 x
10,000 22,200 2.20 x 80,000 177,600
Continued
15 Scented Cards Regular Cards
Overhead costs(contd) Inspecting 8.89 x 2
,000 17,780 8.89 x 16,000 142,240 Moving ma
terials 400 x 180 72,000 400 x 120 48,00
0 Total manufacturing costs 415,980 1,963,840
Units of production 20,000 200,000
Unit cost 20.80 9.82
16Activity-Based Costing Model
Cost of Resources
17Design Steps for an Activity-Based Costing System
- 1. Identify, define, and classify activities and
key attributes.
- 2. Assign the cost of resources to activities.
- 3. Assign the cost of secondary activities to
primary activities.
- 4. Identify cost objects and specify the amount
of each activity consumed by specific cost
objects.
- 5. Calculate primary activity rates.
- 6. Assign activity costs to cost objects.
18Activity-Based Costing
- A primary activity is an activity that is
consumed by a final cost object such as a product
or customer.
- A secondary activity is one that is consumed by
intermediate cost objects such as primary
activities, materials, or other secondary
activities.
19Activity Dictionary Cardiology Ward
Activity Description
Activity Name
Activity Type
Cost Object(s)
Activity Driver
Supervising Scheduling, Secondary Activities Perce
ntage nurse coordinating, within time nurses a
nd performance department spend on
evaluation each activity Treating Admin
istering Primary Patient types Number of
patients medicine and treatments
changing dressings
Continued
20Activity Description
Activity Name
Activity Type
Cost Object(s)
Activity Driver
Providing Bathing, Primary Patient types Labor
hours hygienic care changing bedding and clot
hes, walking patients Responding to Answering
Primary Patient types Number of
patient calls, counseling, requests
requests providing snacks, etc. Monitoring Mo
nitoring Primary Patient types Monitoring
patients vital signs hours and posting patie
nt information
21Cardiology Ward Example (Contd)
Percentage of Time for Each Activity
- Activity Supervisor
Nurses
- Supervising nurses 100 0
- Treating patients 0 25
- Providing hygienic care 0 20
- Responding to requests 0 40
- Monitoring patients 0 15
22Cardiology Ward Example (Contd)
Unbundling of General Ledger Costs Chart of
Accounts View
Supervising 50,000 Supplies 40,600 Uniforms 8
,200 Salaries 300,000 Computer 1,200 Monitor
80,000
Total 480,000
23Unbundling of General Ledger Costs ABC View
Cardiology Ward Example (Contd)
- Supervising nurses 52,280
- Treating patients 90,000
- Providing hygienic care 76,600
- Responding to requests 133,200
- Monitoring patients 127,920
- Total 480,000
24 Cardiology Ward Example (Contd)
Assignment of Secondary Activity Costs to Primary
Activities
90,000 (0.25 x 52,280)
- Treating patients 103,070
- Providing hygienic care 87,056
- Responding to requests 154,112
- Monitoring patients 135,762
76,600 (0.20 x 52,280)
133,200 (0.40 x 52,280)
127,920 (0.15 x 52,280)
25 Cardiology Ward Example (Contd)
Rate Calculations
- Treating patients 103,070/30,000 3.44 per
treatment
- Providing hygienic care 87,056/16,000
5.44 per hour of
- care
- Responding to requests 154,112/80,000
1.93 per request
- Monitoring patients 135,762/200,000
0.68 per monitoring hour
26 Cardiology Ward Example (Contd)
Bill of Activities
Activity
Intensive
Activity
Driver Normal Intermediate
Care Total Production (output) Patient d
ays 10,000 5,000 3,000 Treating patients Treatmen
ts 5,000 10,000 15,000 30,000 Providing hygienic
care Hygienic hours 5,000 2,500 8,500 16,000
Responding to requests Requests 30,000 40,000 10,0
00 80,000 Monitoring patients Monitoring hours 20
,000 60,000 120,000 200,000
27 Cardiology Ward Example (Contd)
Assigning Cost Final Cost Objects
Normal
Treating patients 3.44 x 5,000 17,200
Providing hygientic care 5.44 x 5,000 27,200
Responding to requests 1.93 x 30,000 57,900
Monitoring patients 0.68 x 20,000 13,600
Total cost 115,900 Units 10,000 Nursing cost
per patient day 11.59
28 Cardiology Ward Example (Contd)
Assigning Cost Final Cost Objects
Intermediate
Treating patients 3.44 x 10,000 34,400
Providing hygientic care 5.44 x 2,500 13,600
Responding to requests 1.93 x 40,000 77,200
Monitoring patients 0.68 x 60,000 40,800
Total cost 166,000 Units 5,000 Nursing cos
t per patient day 33.20
29 Cardiology Ward Example (Contd)
Assigning Cost Final Cost Objects
Intensive Care
Treating patients 3.44 x 15,000 51,600
Providing hygientic care 5.44 x 8,500 46,240
Responding to requests 1.93 x 10,000 19,300
Monitoring patients 0.68 x 120,000 81,600
Total cost 198,740 Units 3,000 Nursing cost
per patient day 66.25
30Activity-Level Classification
- Unit-level activities are those that are
performed each time a unit is produced.
- Examples Power and machine hours are used each
time a unit is produced. Direct materials and
direct labor activities are also unit-level
activities, even though they are not overhead
costs.
31Activity-Level Classification
- Batch-level activities are those that are
performed each time a batch of products is
produced.
- Examples Setups, inspections, purchasing, and
material handling.
32Activity-Level Classification
Product-level (sustaining) activities are those
activities performed that enable the various
products of a company to be produced. These
activities and their costs tend to increase as
the number of different products increases.
Examples Engineering changes, developing
product-testing procedures, introducing new
products, and expediting goods.
33Activity-Level Classification
Facility-level activities are those that sustain
a factory's general manufacturing processes.
Examples Plant management, landscaping,
maintenance, security, property taxes, and
plant depreciation.
34Activities Classification and Homogeneous Sets
Processed classified activities
35From processed-classification activities
Activity Level Filter
Level-Classification activities
Homogenous sets
36ABC Database
- An ABC database is the collected data sets that
are organized and interrelated for use by an
organizations activity-based costing information
system. - A data set is a grouping of logically related
data.
37End of
Chapter
38(No Transcript)