In: Accounting
Traditional Product Costing versus Activity-Based
Costing
Assume that Panasonic Company has determined its estimated total
manufacturing overhead cost for one of its plants to be $636,400
consisting of the following activity cost pools for the current
month:
Activity Centers | Activity Costs | Cost Drivers | Activity Level |
---|---|---|---|
Assembly setups | $ 132,000 | Setup hours | 2,000 |
Materials handing | 64,800 | Number of moves | 600 |
Assembly | 360,000 | Assembly hours | 18,000 |
Maintenance | 79,600 | Maintenance hours | 1,990 |
Total | $636,400 |
Total direct labor hours used during the month were 14,800. Panasonic produces many different electronic products, including the following two products produced during the current month:
Model X301 | Model Z205 | |
---|---|---|
Units produced | 2,000 | 2,000 |
Direct materials costs | $27,000 | $27,000 |
Direct labor costs | $22,000 | $22,000 |
Direct labor hours | 700 | 700 |
Setup hours | 60 | 120 |
Materials moves | 30 | 60 |
Assembly hours | 900 | 900 |
Maintenance hours | 20 | 80 |
Required
a. Calculate the total per-unit cost of each model using direct
labor hours to assign manufacturing overhead to products.
Round answers for unit cost to two decimal places,
if applicable.
X301 | Z205 | |
---|---|---|
Direct materials | Answer | Answer |
Direct labor | Answer | Answer |
Overhead | Answer | Answer |
Total cost | Answer | Answer |
Units | Answer | Answer |
Unit cost | Answer | Answer |
b. Calculate the total per-unit cost of each model using
activity-based costing to assign manufacturing overhead to
products.
Round answers for unit cost to two decimal places,
if applicable.
X301 | Z205 | |
---|---|---|
Total direct materials costs | Answer | Answer |
Total direct labor costs | Answer | Answer |
Overhead costs: | ||
Assembly setup | Answer | Answer |
Materials handling | Answer | Answer |
Assembly | Answer | Answer |
Maintenance | Answer | Answer |
Total costs | Answer | Answer |
Units produced | Answer | Answer |
Unit cost | Answer | Answer |
Traditional Product Costing versus Activity-Based
Costing
Assume that Panasonic Company has determined its estimated total
manufacturing overhead cost for one of its plants to be $636,400
consisting of the following activity cost pools for the current
month:
Activity Centers | Activity Costs | Cost Drivers | Activity Level |
---|---|---|---|
Assembly setups | $ 132,000 | Setup hours | 2,000 |
Materials handing | 64,800 | Number of moves | 600 |
Assembly | 360,000 | Assembly hours | 18,000 |
Maintenance | 79,600 | Maintenance hours | 1,990 |
Total | $636,400 |
Total direct labor hours used during the month were 14,800. Panasonic produces many different electronic products, including the following two products produced during the current month:
Model X301 | Model Z205 | |
---|---|---|
Units produced | 2,000 | 2,000 |
Direct materials costs | $27,000 | $27,000 |
Direct labor costs | $22,000 | $22,000 |
Direct labor hours | 700 | 700 |
Setup hours | 60 | 120 |
Materials moves | 30 | 60 |
Assembly hours | 900 | 900 |
Maintenance hours | 20 | 80 |
Required
a. Calculate the total per-unit cost of each model using direct
labor hours to assign manufacturing overhead to products.
Round answers for unit cost to two decimal places,
if applicable.
X301 | Z205 | |
---|---|---|
Direct materials | Answer | Answer |
Direct labor | Answer | Answer |
Overhead | Answer | Answer |
Total cost | Answer | Answer |
Units | Answer | Answer |
Unit cost | Answer | Answer |
b. Calculate the total per-unit cost of each model using
activity-based costing to assign manufacturing overhead to
products.
Round answers for unit cost to two decimal places,
if applicable.
X301 | Z205 | |
---|---|---|
Total direct materials costs | Answer | Answer |
Total direct labor costs | Answer | Answer |
Overhead costs: | ||
Assembly setup | Answer | Answer |
Materials handling | Answer | Answer |
Assembly | Answer | Answer |
Maintenance | Answer | Answer |
Total costs | Answer | Answer |
Units produced | Answer | Answer |
Unit cost | Answer | Answer |
Answer:
Answer-1: | ||
Predetermined overhead rate = $636,400 / 14,800 = $43 | ||
Model X301 | Model Z205 | |
Raw material | $ 27,000 | $ 27,000 |
Direct labor | 22,000 | 22,000 |
Overhead | 30,100 | 30,100 |
Total cost | $ 79,100 | $ 79,100 |
Units | 2,000 | 2,000 |
Unit cost | $ 39.55 | $ 39.55 |
Answer-2: | |||||
Schedule of Activity-Based Overhead Rates per Cost Driver | |||||
Activity cost pool |
Overhead cost |
Use of cost drivers |
Activity-based overhead rate |
||
Assembly Set up costs | $ 132,000 | 2,000 | set ups hours | $ 66.00 | per set up hour |
Material handling costs | 64,800 | 600 | No. of moves | 108.00 | per move |
Assembly cost | 360,000 | 18,000 | Assembly hours | 20.00 | per assembly hour |
Maintenance cost | 79,600 | 1,990 | Maintenance hours | 40.00 | per maintenance hour |
636,400 |
Model X301 | Model Z205 | |
Raw material | $ 27,000 | $ 27,000 |
Direct labor | 22,000 | 22,000 |
Overhead: | ||
Assembly Set up costs | 3,960 | 7,920 |
Material handling costs | 3,240 | 6,480 |
Assembly cost | 18,000 | 18,000 |
Maintenance cost | 800 | 3,200 |
Total overhead cost | 26,000 | 35,600 |
Total cost | $ 75,000 | $ 84,600 |
Units produced | 2,000 | 2,000 |
Unit cost | $ 37.50 | $ 42.30 |