In: Accounting
Combat Fire, Inc. manufactures steel cylinders and nozzles for
two models of fire extinguishers: (1) a home fire extinguisher and
(2) a commercial fire extinguisher. The home model is a
high-volume (54,000 units), half-gallon cylinder that holds 2 1/2
pounds of multi-purpose dry chemical at 480 PSI. The commercial
model is a low-volume (10,200 units), two-gallon cylinder that
holds 10 pounds of multi-purpose dry chemical at 390 PSI. Both
products require 1.5 hours of direct labor for completion.
Therefore, total annual direct labor hours are 96,300 or [1.5 hours
× (54,000 + 10,200)]. Estimated annual manufacturing overhead is
$1,573,108. Thus, the predetermined overhead rate is $16.34 or
($1,573,108 ÷ 96,300) per direct labor hour. The direct materials
cost per unit is $18.50 for the home model and $26.50 for the
commercial model. The direct labor cost is $19 per unit for both
the home and the commercial models.
The company’s managers identified six activity cost pools and
related cost drivers and accumulated overhead by cost pool as
follows.
|
Estimated Use of |
||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Activity Cost Pools |
Cost Drivers |
Estimated Overhead |
Estimated Use of |
Home |
Commercial |
|||||
| Receiving | Pounds |
$87,100 |
335,000 |
215,000 |
120,000 |
|||||
| Forming | Machine hours |
150,150 |
35,000 |
27,000 |
8,000 |
|||||
| Assembling | Number of parts |
399,280 |
217,000 |
165,000 |
52,000 |
|||||
| Testing | Number of tests |
47,940 |
25,500 |
15,500 |
10,000 |
|||||
| Painting | Gallons |
57,838 |
5,258 |
3,680 |
1,578 |
|||||
| Packing and shipping | Pounds |
830,800 |
335,000 |
215,000 |
120,000 |
|||||
|
$1,573,108 |
||||||||||
Under traditional product costing, compute the total unit cost
of each product. (Round answers to 2 decimal places,
e.g. 12.50.)
|
Home Model |
Commercial Model |
|||
|---|---|---|---|---|
| Total unit cost |
Under ABC, prepare a schedule showing the computations of the
activity-based overhead rates (per cost driver). (Round
overhead rate to 2 decimal places, e.g.
12.25.)
|
Activity Cost Pool |
Estimated |
Estimated |
Activity-Based |
||||||
|---|---|---|---|---|---|---|---|---|---|
| Receiving | $enter a dollar amount | enter an amount of pounds | Pounds | $enter a dollar amount per pound rounded to 2 decimal places | per pound | ||||
| Forming | enter a dollar amount | enter a number of machine hours | Machine hours | $enter a dollar amount per machine hour rounded to 2 decimal places | per machine hour | ||||
| Assembling | enter a dollar amount | enter a number of parts | Parts | $enter a dollar amount per part rounded to 2 decimal places | per part | ||||
| Testing | enter a dollar amount | enter a number of tests | Tests | $enter a dollar amount per test rounded to 2 decimal places | per test | ||||
| Painting | enter a dollar amount | enter an amount of gallons | Gallons | $enter a dollar amount per gallon rounded to 2 decimal places | per gallon | ||||
| Packing and shipping | enter a dollar amount | enter an amount of pounds | Pounds | $enter a dollar amount per pound rounded to 2 decimal places | per pound | ||||
| $enter a total amount | |||||||||
Prepare a schedule assigning each activity’s overhead cost pool to each product based on the use of cost drivers. (Round overhead cost per unit to 2 decimal places, e.g. 12.25 and cost assigned to 0 decimal places, e.g. 2,500.)
Compute the total cost per unit for each product under ABC.
| OH cost per unit (Traditional costing) | |||||||
| Home | Commercial | ||||||
| DLH per unit | 1.5 | 1.5 | |||||
| Multiply: Oh rate per DLH | 16.34 | 16.34 | |||||
| Oh cost per unit | 24.51 | 24.51 | |||||
| Unit cost per Traditional costing | |||||||
| Home | Commercial | ||||||
| Material cost | 18.5 | 26.5 | |||||
| Labour cost | (1.50*19) | 28.5 | 28.5 | ||||
| Overheads cost | 24.51 | 24.51 | |||||
| Unit cost per Traditional costing | 71.51 | 79.51 | |||||
| Activity Based: | |||||||
| Activity rate: | |||||||
| Activity | Est. Overheads | Cost drivers | Activity rate | ||||
| Receiving | 87100 | 335000 | 0.26 | per pound | |||
| Forming | 150150 | 35000 | 4.29 | per Mh | |||
| Assembling | 399280 | 217000 | 1.84 | Per part | |||
| Testing | 47940 | 25500 | 1.88 | per test | |||
| painting | 57838 | 5258 | 11 | per gallon | |||
| Packing and shipping | 830800 | 335000 | 2.48 | per pound | |||
| Assigning Overheads | |||||||
| Home | Commercial | ||||||
| Activity | Rate | Driver | Oh cost | Driver | Oh cost | ||
| Receiving | 0.26 | 215000 | 55900 | 120000 | 31200 | ||
| Forming | 4.29 | 27000 | 115830 | 8,000 | 34320 | ||
| Assembling | 1.84 | 165000 | 303600 | 52000 | 95680 | ||
| Testing | 1.88 | 15500 | 29140 | 10000 | 18800 | ||
| painting | 11 | 3680 | 40480 | 1578 | 17358 | ||
| Packing and shipping | 2.48 | 215000 | 533200 | 120000 | 297600 | ||
| Total overheads | 1078150 | 494958 | |||||
| Divide: Units | 54000 | 10200 | |||||
| Oh cost per unit | 19.97 | 48.53 | |||||
| Unit cost per ABC | |||||||
| Home | Commercial | ||||||
| Material cost | 18.5 | 26.5 | |||||
| Labour cost | (1.50*19) | 28.5 | 28.5 | ||||
| Overheads cost | 19.97 | 48.53 | |||||
| Unit cost per ABC | 66.97 | 103.53 | |||||