Question

In: Accounting

4) X Company makes two products, A and B, and uses an activity-based costing overhead allocation...

4) X Company makes two products, A and B, and uses an activity-based costing overhead allocation system, with three cost pools and three cost drivers. Budgeted costs and driver information for 2017 were as follows: Cost Pool 1 Cost Pool 2 Cost Pool 3 Budgeted costs $113,000 $53,000 $31,000 Cost Drivers Product A 84,000 62,000 75,000 Product B 63,000 54,000 47,000

What was the allocation to Product B in 2017?

Solutions

Expert Solution

CALCULATION OF THE TOTAL COST DRIVERS For Prdocut A For Prdocut B Total
Cost Drivers 1                                    84,000                             63,000              1,47,000
Cost Drivers 2                                    62,000                             54,000              1,16,000
Cost Drivers 3                                    75,000                             47,000              1,22,000
Step 1: Calculation of the Cost Driver Rate
Cost Driver Rate = Activity Cost / Cost Driver
Activity Cost / Cost Driver =
Activity Cost Driver   Activity Cost   "/"   Cost Driver " = " To Cost Driver Rate
Cost Pool 1 Cost Driver 1 $                     1,13,000 "/"   $               1,47,000 " = " To   $                      0.77
Cost Pool 2 Cost Driver 2 $                         53,000 "/"   $               1,16,000 " = " To   $                      0.46
Cost Pool 3 Cost Driver 3 $                         31,000 "/"   $               1,22,000 " = " To   $                      0.25
Step 2: Calculation of the Cost allocation for Product B
Activity Product Cost Driver Used "X " By Cost Driver Rate   " = " To Activity Cost as per Service Department
Cost Pool 1 Cost Driver 1
Product B                             63,000 "X " By $                        0.77 " = " To $                 48,429
Cost Pool 2 Cost Driver 2
Product B                             54,000 "X " By $                        0.46 " = " To $                 24,672
Cost Driver 3
Cost Pool 3 Product B
                            47,000 "X " By $                        0.25 " = " To $                 11,943
TOTAL COST ALLOCATION FOR PRODCUT B                85,043.61

Related Solutions

Jung Company uses activity-based costing. It makes two products, X and Y. The company's overhead costs...
Jung Company uses activity-based costing. It makes two products, X and Y. The company's overhead costs are traced to two activity cost pools. The following data are given: Activity cost pool Activity measure Estimated Overhead Cost Activity For X For Y Total Design Number of parts $32,000 200 parts 800 parts 1,000 parts Inspection Production units $18,000 2,000 units 1,000 units 3,000 units For the design activity, its activity rate (predetermined overhead rate) is:
Jennifer Company has two products: A and B. The company uses activity-based costing
Jennifer Company has two products: A and B. The company uses activity-based costing. The estimated total cost and expected activity for each of the company's three activity cost pools are as follows: The activity rate under the activity based costing system for Supporting customers is closest to:
5)X Company uses an activity-based costing overhead allocation system. It has identified three activities - Material...
5)X Company uses an activity-based costing overhead allocation system. It has identified three activities - Material handling, Product testing, Packaging - and their respective cost drivers - pounds of material, tests, packages. Budgeted activity costs in 2018 were as follows: Activity Budgeted Cost   Material handling $104,700       Product testing 58,700       Packaging 53,000       The following 2018 cost driver information is available for one of its products, Product A, and for all of its products (including Product A): Product A All Products pounds...
A company has two products: A and B. It uses activity-based costing and has prepared the...
A company has two products: A and B. It uses activity-based costing and has prepared the following analysis showing budgeted cost and activity for each of its three acivity cot pools. Cost Pool Budgeted Cost Product A Product B Activity 1 $87,000 3,000 2,800 Activity 2 $62,000 4,500 5,500 Activity 3 $93,000 2,500 5,250 Annual Production and sales level of Product A is, 34,300 units, and the annual production and sales level of Product B is 69,550 Units. What is...
Assume a company that uses activity-based costing (ABC) has only two products – A and B....
Assume a company that uses activity-based costing (ABC) has only two products – A and B. The company does not have any organization-sustaining activities or unused capacity costs. The company’s total manufacturing overhead cost of $56,000 has been allocated to the three activities shown below: Setups Machining Packing Orders Activity measure quantity: Product A 20 1,000 150 Activity measure quantity: Product B 20 ? 350 Overhead cost per activity cost pool ? ? $ 10,000 Activity rate    $ 150 per...
Abel Company uses activity-based costing. The company has two products: A and B. The annual production...
Abel Company uses activity-based costing. The company has two products: A and B. The annual production and sales of Product A is 200 units and of Product B is 400 units. There are three activity cost pools, with estimated costs and expected activity as follows: Expected ActivityActivity Cost PoolEstimated CostProduct AProduct BTotalActivity 1$16,660600100700Activity 218,4501,1007001,800Activity 39,7316016022022. The cost per unit of Product A is closest to which of the following? A. $27.91. B. $56.38. C. $141.04. D. $70.52.
Lindsey Company uses activity-based costing. The company has two products: A and B. The annual production...
Lindsey Company uses activity-based costing. The company has two products: A and B. The annual production and sales of Product A is 9,000 units and of Product B is 8,000 units. There are three activity cost pools, with total cost and total activity as follows: Total Activity Activity Cost Pool Total Cost Product A Product B Total Activity 1 $31,000 100 520 620 Activity 2 $46,287 860 250 1,110 Activity 3 $156,750 840 3,910 4,750 The activity-based costing cost per...
A company uses activity-based costing to determine the costs of its three products: A, B, and...
A company uses activity-based costing to determine the costs of its three products: A, B, and C. The budgeted cost and activity for each of the company's three activity cost pools are shown in the following table: Budgeted Activity Activity Cost Pool Budgeted Cost Product A Product B Product C Activity 1 $ 85,000 7,500 10,500 21,500 Activity 2 $ 60,000 8,500 16,500 9,500 Activity 3 $ 112,000 4,000 2,500 3,125 How much overhead will be assigned to Product B...
A company uses activity-based costing to determine the costs of its three products: A, B, and...
A company uses activity-based costing to determine the costs of its three products: A, B, and C. The budgeted cost and activity for each of the company's three activity cost pools are shown in the following table: A company uses activity-based costing to determine the costs of its three products: A, B, and C. The budgeted cost and activity for each of the company's three activity cost pools are shown in the following table: Budgeted Activity Activity Cost Pool Budgeted...
A company uses activity-based costing to determine the costs of its three products: A, B, and...
A company uses activity-based costing to determine the costs of its three products: A, B, and C. The budgeted cost and activity for each of the company's three activity cost pools are shown in the following table: Budgeted Activity Activity Cost Pool Budgeted Cost Product A Product B Product C Activity 1 $ 75,000 6,500 9,500 20,500 Activity 2 $ 50,000 7,500 15,500 8,500 Activity 3 $ 92,000 3,000 1,500 2,125 How much overhead will be assigned to Product B...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT