ABC Worksheet
xlsx
keyboard_arrow_up
School
York University *
*We aren’t endorsed by this school
Course
2700
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
14
Uploaded by CountPenguinMaster907
Refining a Cost System
ABC Method
Step 1 - Determine Allocation rate for each activity cost pool
Step 2 - For each cost object (e.g., product, department), determine the direct costs.
Step 3 - Using the allocation rates, allocate overhead costs for each activity cost pool to the cost object, base
1. Direct Cost Tracing - Try to trace as many direct costs as possible (e.g., minimize indirect cost pool).
2. Indirect cost pool homogenization - rather than using a single cost pool, try to categorize indirect costs in
3. Cost allocation - for each indirect cost pool, try to assign the most causal driver for a homogeneous cost p
ed on the cost driver.
nto homogenous pools.
pool.
Job Costing
DM
IDM
DML
IDML
DEP
Misc. MOH
Cost Drivers:
MH
LH
LW
Etc.
Costs
Direct Costs
Pool
Indirect Costs (MOH)
Pool
Traced directly to a Cost Object
Cost Object - Products
- Customer
- Department
- Product Line
- Etc.
Allocated to a Cost Object, usually based on a single
cost driver
Direct Costs
Pool
Traced directly Cost Object
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ABC Costing
Separate MOH based on activity
DM
DML
Costs
Indirect Costs (MOH)
Pool #1
to a t
Cost Object - Products
- Customer
- Department
- Product Line
- Etc.
Allocated to a Cost Object, based on multiple cost drivers.
Indirect Costs (MOH)
Pool #2
Indirect Costs (MOH)
Pool #3
Cost Driver #1
Cost Driver #2
Cost Driver #3
Huey Parker produces mathematical and financial calculators. Data related to the two products are presented be
Mathematical
Financial
Annual Production in Units
50,000 100,000 DM Costs
$ 180,000 $ 360,000 DML Costs
$ 60,000 $ 120,000 DML Hours
2,500 5,000 Machine Hours
35,000 40,000 Number of Production runs
50
50
Inspection Hours
1,000 500 Both products pass through Department 1 and Department 2. The departments combined MOH costs are:
Costs
(Assume actual costs)
Machining
$ 450,000 Setup
$ 144,000 Inspection
$ 126,000 Total
$ 720,000 1. Compute the MOH costs for each product, using job costing (in this case actual costing). Use machine hours as
2. Compute the manufacturing cost for each product, using job costing.
3. Compute the MOH costs for each product, using the ABC method.
4. Compute the manufacturing cost for each product, using the ABC method.
5. Calculate the difference in each method (overcosting vs undercosting)
1. JOB Costing MOH costs
MOH Costs $ 720,000 MH 75,000 Allocation rate $ 9.60 per MH
Mathematical Financial
Machine Hours
35,000 40,000 Allocation rate $ 9.60 $ 9.60 MOH $ 336,000 $ 384,000 Annual Production in Units
50,000 100,000 MOH per product
$ 6.72 $ 3.84 2. Job Costing - Total cost per product
Mathematical Financial
DM Costs
DML Costs
MOH Costs
Total Manufacturing Costs
Annual Production in Units
Manufacturing Cost Per Unit 3. ABC Costing MOH costs
Costs
Driver
MOH rate
Machining
Setup
Inspection
Mathematical Calculators
Rate
Driver
MOH
Units
Machine
Setup
Inspection
Total
MOH per unit
Financial Calculators
Rate
Driver
MOH
Units
Machine
Setup
Inspection
Total
MOH per unit
Math
Financial
DM
DML
MOH
Units
Cost per unit
Total Manufacturing Cost Per Unit
Total MOH
Mathematical
Financial
Mathematical
Job Costing
Job Costing
ABC
ABC
Difference
Difference
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
elow.
s the cost driver.
Financial
Job Costing
DM
IDM
DML
IDML
DEP
Misc. MOH
Cost Drivers:
MH
Costs
Direct Costs
Pool
Indirect Costs (MOH)
Pool ($720K)
Traced directly to a Cost Object
Cost Objects: 1.Mathematical Calculator
2. Financial Calculator
Allocated to a Cost Object, usually based on a single
cost driver
Direct Costs
Pool
Traced directly Cost Object
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ABC Costing
Separate MOH based on activity
DM
DML
Costs
Machining MOH
$450,000
to a t
Cost Object 1.Mathematical Calculator
2. Financial Calculator
Allocated to a Cost Object, based on multiple cost drivers.
Setup MOH
$144,000
Inspection MOH
$126,000
Cost Driver #1:
MH
Cost Driver #2:
# of Setup runs
Cost Driver #3:
Inspection HRS
Table 1
Sliders
Slurpers
Estimated volume
3,400 units 4,800 units
Direct labour hours per unit
1.40 hours
1.90 hours
Direct materials cost per unit
$7.40 $12.70 Direct labour cost per unit
$14.00 $19.00 1) Compute the predetermined overhead rate under the current method, and determine the un
Table 2
Activity Cost Pool
Estimated Overhead Costs
Expected Activity: Sliders
Machine setups
$12,190 80
Purchase orders
79,200
730
General factory
69,400
4,760
Total
$160,790 2) Determine the unit product cost of each product for the current period using the activity-base
Part 1 - Job Costing
Sliders
Total Volume
Direct labour hours per unit
Total Direct Labour Hours
- Total Budgeted Overhead
Total Direct Labour Hours
Overhead Rate
#DIV/0!
Cost per unit
Sliders
DM per Unit
DL per unit
Manufacturing Overhead
$ - East Production Co. manufactures two products: Sliders and Slurpers. The company estimated it w
manufacturing overhead costs during the current period. Overhead currently is applied to the pro
labour hours. Data concerning the current period's operations appear below:
The company is considering using an activity-based costing system to compute unit product costs traditional system based on direct labour hours. The activity-based costing system would use thre
for the current period are given below:
Part 2 - Activity Based Costing
Sliders
Volume
Machine setups
Purchase orders
General factory
Activity Rates (Calculate from yellow cells from Table 2 above)
Machine setups
Purchase orders
General factory
Allocated Overhead = Volume X Activity Rate
Machine setups
Purchase orders
General factory
$ - Number of Units
MOH per unit
#DIV/0!
Cost per unit
Sliders
Direct Materials
Direct Labour
MOH per unit
$ -
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
nit product cost of each product for the current year.
Expected Activity: Slurpers
Total
Activity Allocation Rate
150
230
920
1,650
9,120
13,880
ed costing approach.
Slurpers
- - per DLH
Slurpers
This is equal to DLH for each product x the overhead rate.
$ - would incur $160,790 in oducts on the basis of direct for external financial reports instead of its ee activity cost pools. Data relating to these activities
Slurpers
)
$ - #DIV/0!
Slurpers
$ -
Related Documents
Related Questions
There are four steps in the two-stage cost allocation process using ABC. Which of the following
not one of those steps?
Select a cost driver for each activity cost pool.
O Identify and classify activities.
Identify the volume-based cost driver.
O Form activity cost pools and assign indirect costs to each pool.
arrow_forward
In a two-stage activity-based costing model, stage one involves Select one: O O A. assigning activity costs to cost objects. B. assigning indirect resource costs to activity pools. C. measuring the various indirect resource costs and determining resource drivers. D. assigning direct costs to cost objects.
arrow_forward
ABC costing attempts to:
O A. classify as many costs as indirect costs as is feasible.
OB. identify the activities involved in a process.
create as many cost pools as possible.
O C.
O D. seek a lesser level of detail.
arrow_forward
In an activity-based costing system, the first step in assigning costs is to
• A. separate nonvalue-adding activities from value-adding activities.
B. identify the appropriate activities for each function.
• C. analyze all nonvalue-adding activities to determine if they are necessary support areas.
D. accumulate costs for each activity.
arrow_forward
2. The internal cost analysis process involves the following in what order? (A) Identify the links between the process and check for opportunities to lower costs, (B) Identify the value creating processes and the cost of each, (C) Identify the cost driver for each process and the cost per activity level.
a. A, B, Cb. C, A, Bc. B, A, Cd. B, C, A
arrow_forward
1.An activity that has a direct cause-effect relationship with the resources consumed is a(n)
Group of answer choices
cost driver
overhead rate
cost pool
product activity
arrow_forward
In developing an ABC system, what is the last step?
Identify the primary activities and estimate a total cost pool for each.
Select an allocation base for each activity.
Allocate the costs to the cost object using the activity cost allocation rates.
Calculate an activity cost allocation rate for each activity.
arrow_forward
The allocation of indirect costs in an activity-based costing system a. may require other costs to be allocated to activities before the costs of the activities can be allocated to the products. b. is simplified because more costs are identified as direct costs. c. requires the use of heterogeneous cost pools. d. is simplified because a limited number of activities are identified as cost objects.
arrow_forward
Distinguish between the single-rate and the dual-rate methods.
The single-rate (cost-allocation) method makes
costs in each cost pool to cost objects using
distinction between fixed costs and variable costs in the cost pool. It allocates
rate per unit of the single allocation base.
arrow_forward
(Management Accounting)
When assigning indirect costs to a cost object, an ideal cost-allocation base measures ________.
A) the proportion of indirect costs to direct costs
B) the extent a particular cost is caused by a cost object
C) multiple cost drivers
D) the proportion of direct costs to indirect costs
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Related Questions
- There are four steps in the two-stage cost allocation process using ABC. Which of the following not one of those steps? Select a cost driver for each activity cost pool. O Identify and classify activities. Identify the volume-based cost driver. O Form activity cost pools and assign indirect costs to each pool.arrow_forwardIn a two-stage activity-based costing model, stage one involves Select one: O O A. assigning activity costs to cost objects. B. assigning indirect resource costs to activity pools. C. measuring the various indirect resource costs and determining resource drivers. D. assigning direct costs to cost objects.arrow_forwardABC costing attempts to: O A. classify as many costs as indirect costs as is feasible. OB. identify the activities involved in a process. create as many cost pools as possible. O C. O D. seek a lesser level of detail.arrow_forward
- In an activity-based costing system, the first step in assigning costs is to • A. separate nonvalue-adding activities from value-adding activities. B. identify the appropriate activities for each function. • C. analyze all nonvalue-adding activities to determine if they are necessary support areas. D. accumulate costs for each activity.arrow_forward2. The internal cost analysis process involves the following in what order? (A) Identify the links between the process and check for opportunities to lower costs, (B) Identify the value creating processes and the cost of each, (C) Identify the cost driver for each process and the cost per activity level. a. A, B, Cb. C, A, Bc. B, A, Cd. B, C, Aarrow_forward1.An activity that has a direct cause-effect relationship with the resources consumed is a(n) Group of answer choices cost driver overhead rate cost pool product activityarrow_forward
- In developing an ABC system, what is the last step? Identify the primary activities and estimate a total cost pool for each. Select an allocation base for each activity. Allocate the costs to the cost object using the activity cost allocation rates. Calculate an activity cost allocation rate for each activity.arrow_forwardThe allocation of indirect costs in an activity-based costing system a. may require other costs to be allocated to activities before the costs of the activities can be allocated to the products. b. is simplified because more costs are identified as direct costs. c. requires the use of heterogeneous cost pools. d. is simplified because a limited number of activities are identified as cost objects.arrow_forwardDistinguish between the single-rate and the dual-rate methods. The single-rate (cost-allocation) method makes costs in each cost pool to cost objects using distinction between fixed costs and variable costs in the cost pool. It allocates rate per unit of the single allocation base.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning