ABC Worksheet

xlsx

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

Report
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 $ -