Question

In: Accounting

1. Activity Based Costing Duncan Company recently introduced a markers to complement their other product, pencils....

1. Activity Based Costing

Duncan Company recently introduced a markers to complement their other product, pencils. Accountants accumulate all overhead in a single cost pool and allocate it based on machine-hours. With the recent addition of an expanded computer system, Duncan decided to begin implementing ABC. A study reveals much overhead cost related to machine setups and batch changes. They select the number of setups and the number of batch changes as the activity driers for the two new cost pools. They will continue to use machine-hours as the base for allocating all remaining overhead. Accountants provide the following information about Duncan Company’s most recent year of operations:

                                                                Pencils                      Markers                              Total

Units produced                                           5,000 1,000                            6,000

Direct material cost per unit               $            5 $      3                  

Direct labor cost                                    200,000 $300,000                     $500,000

Machine hours                                           4,000 6,000                          10,000

Machine setups                                               30 50                                 80

Batch changes                                               300 700                            1,000

Overhead:

            Machine setup-related                                                                                     $   200,000

            Batch-related                                                                                                        500,000

            Other                                                                                                               1,500,000

                                                                                                                                    $2,200,000

                                                                                                                                    ========   

Required:

Using the current costing system (Absorption costing), determine the total and unit cost for each product line.

Using the ABC costing system, determine the total and unit cost for each product line.

If you were the manager of the pencil department, which method would you prefer and why?

Product Costs using the Current Costing System

(Absorption Costing)

OHR =

                                 Pencils Markers Total

Direct Material       $                                              $ $

Direct Labor

Overhead                                         

(OHR x AV)

Total Cost            $ $ $

                                                                                      =======

÷Units produced                                          

Cost per unit

                             =======             =======            

Product Costs using the ABC Costing System

         OHR #1 = ____________ =                               

        

OHR #2 = ____________ =                               

        

OHR #3 = ____________ =                               

                                 Pencils              Markers               Total

Direct Material       $                                              $                                              $

Direct Labor

Overhead                                         

(OHR x AV)

                                                                                                  

Total Cost            $                           $                           $

                                                                                      

÷Units produced =======

Cost per unit

       =======             =======

Solutions

Expert Solution

Product Costs using the Current Costing System​ (Absorption Costing

OHR =​Total overhead/Mechine hours

​ =    $2,200,000/10,000HOURS

   =    220$ PER HOUR

   Pencils $ Markers $ Total $

Direct Material

5000*5=25,000 1000*3=3,000 28,000
Direct Labor 2,00,000 3,00,000 5,00,000

Overhead    (OHR x MECHINE HOURS)

8,80,000 13,20,000 22,00,000
Total Cost   11,05,000 16,23,000 27,28,000
÷Units produced    5000 units 1000 units 6000units
Cost per unit $ 221 1623 455

Product Costs using the ABC Costing System​

   OHR #1 = Machine setup-related /no.of set up= $ 200,000/80setups

=$2,500 per set up

   OHR #2 = Batch-related/no.of batchs = $500,000/1000 batchs

   =$500 per batch   

OHR #3 =OTHRS/ Machine hours = 1,500,000/10,000hours

=150$ per mechine hour

   Pencils $ Markers $ Total $
Direct Material 5000units*5$=25,000    1000units*3$=3,000 28,000
Direct Labor    2,00,000    3,00,000 5,00,000
Overhead  ​cost
setup related cost 30setups*$2500=75,000 30setups*$2500=1,25000 2,00,000
Batch changes realated 300batchs*$500=1,50,000 700Batchs*$500=3,50,000 5,00,000
other over head cost 4000hours*150$=6,00000 6000hours*150$=9,00,000 15,00,000
Total Cost   10,50,000 16,78,000 27,28,000
÷Units produced    5000 1000 6000
Cost per unit $ 210    1678    455

DECESSION

  • ​If i am the manager of pencil department should prefer activity based costing system
  • ​because it results Reduction in cost of overhead by 55,000$ (8,80,000-,8,25,000)
  • ​so product cost reduced by 11$ per unit (55,000$/5000units)

Related Solutions

Rusties Company recently implemented an activity-based costing system.
  Rusties Company recently implemented an activity-based costing system. At the beginning of the year, management made the following estimates of cost and activity in the company’s five activity cost pools: Activity Cost Pool Activity Measure ExpectedOverhead Cost ExpectedActivity Labor-related Direct labor-hours $ 24,912 2,076 DLHs Purchase orders Number of orders $ 1,070 535 orders Product testing Number of tests $ 4,550 325 tests Template etching Number of templates $ 770 35 templates General factory Machine-hours $ 52,500 10,500 MHs...
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing....
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $462,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information...
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing....
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $462,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information...
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing....
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $462,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information...
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing....
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $462,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information...
In your readings this module, you were introduced to Activity-Based Costing or ABC. It is a...
In your readings this module, you were introduced to Activity-Based Costing or ABC. It is a method used to determine a reliable predetermined benchmark for the allocation of overhead costs to the products produced based on their activity levels. In this discussion, we will work a case study on ABC together. For your initial response, attempt to answer the questions yourself and post all the required items into the Discussion Area. You may want to post some elements during different...
Doede Corporation uses activity-based costing to compute product margins. In the first stage, the activity-based costing...
Doede Corporation uses activity-based costing to compute product margins. In the first stage, the activity-based costing system allocates two overhead accounts--equipment depreciation and supervisory expense--to three activity cost pools--Machining, Order Filling, and Other--based on resource consumption. Data to perform these allocations appear below: Overhead costs: Equipment depreciation $ 82,000 Supervisory expense $ 12,100 Distribution of Resource Consumption Across Activity Cost Pools: Activity Cost Pools Machining Order Filling Other Equipment depreciation 0.60 0.30 0.10 Supervisory expense 0.60 0.20 0.20 In the...
Doede Corporation uses activity-based costing to compute product margins. In the first stage, the activity-based costing...
Doede Corporation uses activity-based costing to compute product margins. In the first stage, the activity-based costing system allocates two overhead accounts--equipment depreciation and supervisory expense--to three activity cost pools--Machining, Order Filling, and Other--based on resource consumption. Data to perform these allocations appear below: Overhead costs: Equipment depreciation $ 30,000 Supervisory expense $ 14,800 Distribution of Resource Consumption Across Activity Cost Pools: Activity Cost Pools Machining Order Filling Other Equipment depreciation 0.50 0.40 0.10 Supervisory expense 0.50 0.30 0.20 In the...
Dodo Inc., uses activity-based costing to determine product margins. In the first stage, the activity-based costing...
Dodo Inc., uses activity-based costing to determine product margins. In the first stage, the activity-based costing system allocates two overhead accounts--equipment depreciation and supervisory expense--to three activity cost pools--Machining, Order Filling, and Other--based on resource consumption. Data pertinnent to perform these allocations appears below: Overhead costs: Equipment depreciation $ 107,000 Supervisory expense $ 9,900 Distribution of Resource Consumption Across Activity Cost Pools: Activity Cost Pools Machining Order Filling Other Equipment depreciation 0.60 0.30 0.10 Supervisory expense 0.60 0.20 0.20 In...
Doede Corporation uses activity-based costing to compute product margins. In the first stage, the activity-based costing...
Doede Corporation uses activity-based costing to compute product margins. In the first stage, the activity-based costing system allocates two overhead accounts--equipment depreciation and supervisory expense--to three activity cost pools--Machining, Order Filling, and Other--based on resource consumption. Data to perform these allocations appear below: Overhead costs: Equipment depreciation $ 103,000 Supervisory expense $ 13,100 Distribution of Resource Consumption Across Activity Cost Pools: Activity Cost Pools Machining Order Filling Other Equipment depreciation 0.60 0.20 0.20 Supervisory expense 0.60 0.10 0.30 In the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT