Question

In: Accounting

4. Nationals Inc. uses activity-based costing to determine the costs of its three products: A, B,...

4. Nationals Inc. 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 below. (Check: Activity 1 activity rate should be a number between $7 and $10). (3 points)

Budgeted Activity

Activity Cost Pool

Budgeted Cost

Product A

Product B

Product C

Activity 1

$140,000

7,500

4,000

6,000

Activity 2

$54,000

2,500

2,000

1,500

Activity 3

$38,000

15,000

25,000

30,000


Compute the company's activity rates under activity-based costing for each of the three activities.

5. Yasiel, Designs, Inc. designs custom storage solutions to businesses. The following data is from the company’s most reporting period:

Design department

        Client consultation

500 contact hours

$100,000

        Drawing

1,000 design hours

$70,000

        Models

20,000 square feet

$25,000

Project Management

        Supervision

250 days

$43,750

        Billings

150 jobs

$55,000




a. Use ABC to compute overhead rates for each activity. Hint: You should have five different ABC overhead rates based on budgeted costs and overhead drivers above. (1 point)

b. Allocate costs to a 3,000 square foot job that requires 70 contact hours, 20 design hours, and 14 days to complete. Hint: Use the ABC overhead rates that you calculated in part a to allocate the overhead for each activity to this job based on the requirements of this one job. Check: Total overhead for this one job is a number between $20,000 and $23,000.

Solutions

Expert Solution

4. The company's activity rates under activity-based costing :

Activity A = $ 8.00

Activity B = $ 9.00

Activity C= $ 0.54

Note :

Budgeted Activity
Activity Cost Pool Budgeted Cost Product A Product B Product C Total Budgeted Activity ( Product A+ B+ C) Activity Rate ( Budgeted Cost /Total Budgeted Activity )
Activity 1 140000 7,500 4,000 6,000 17500 8.00
Activity 2 54000 2,500 2,000 1,500 6000 9.00
Activity 3 38000 15,000 25,000 30,000 70000 0.54

5.

The correct answer is :

Activity Activity Rate
        Client consultation 200.00
        Drawing 70.00
        Models 1.25
        Supervision 175.00
        Billings 366.67

Note :

Design department Activity Rate  ( Budgeted Cost / Budgeted Activity )
Activity Budgeted Activity Budgeted Cost
        Client consultation 500 contact hours $100,000 200.00
        Drawing 1,000 design hours $70,000 70.00
        Models 20,000 square feet $25,000 1.25
Project Management
Activity Budgeted Activity Budgeted Cost
        Supervision 250 days $43,750 175.00
        Billings 150 jobs $55,000 366.67

b.

The correct answer is $ 21,966.67

Note :

Activity Activity Rate Activity Costs Allocated ( Activity Rate * Activity)
        Client consultation 200.00 70 contact hours 14,000.00
        Drawing 70.00 20 design hours 1,400.00
        Models 1.25 3,000 square feet 3,750.00
        Supervision 175.00 14 days 2,450.00
        Billings 366.67 1 job 366.67
21,966.67

Related Solutions

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...
1.) A company uses activity-based costing to determine the costs of its three products: A, B,...
1.) 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 $ 81,000 7,100 10,100 21,100 Activity 2 $ 56,000 8,100 16,100 9,100 Activity 3 $ 104,000 3,600 2,100 2,725 How much overhead will be assigned to Product...
2. A Plus Company uses activity-based costing to determine the costs of its three products: A,...
2. A Plus 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 $ 70,000 6,000 9,000 20,000 Activity 2 $ 45,000 7,000 15,000 8,000 Activity 3 $ 82,000 2,500 1,000 1,625 Which of the following statements is true...
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...
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?
Production Inc. uses activity based costing. The following estimated activity costs are identified in the table...
Production Inc. uses activity based costing. The following estimated activity costs are identified in the table below. In addition, they have two product lines, A100 and B100. Activity Cost Cost Driver A100 B100 Cost allocation base Setup $85,600 # of setups 1,600 1,750 16,000 Handling $136,500 # of parts 1,480 360 65,000 Assembly $126,000 Direct Labor Hours 800 365 5,000 Total $348,100 Summary of prime costs: A100 B100 Direct materials $16,000 $9,500 Direct labor $13,400 $12,700 Calculate the unit cost...
Lysiak Corporation uses an activity based costing system to assign overhead costs to products. In the...
Lysiak Corporation uses an activity based costing system to assign overhead costs to products. In the first stage, two overhead costs--equipment depreciation and supervisory expense-are allocated 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 $ 47,000 Supervisory expense $ 6,000 Distribution of Resource Consumption Across Activity Cost Pools: Activity Cost Pools Machining Order Filling Other Equipment depreciation 0.60 0.10 0.30 Supervisory expense 0.60 0.20 0.20...
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:
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT