In: Accounting
Bramble Visuals produces Tablets and Books. Total overhead costs
traditionally have been allocated on the basis of direct labor
hours. After implementing activity-based costing, managers
determined the following cost pools and cost drivers. They also
decided that general costs should no longer be allocated to
products.
|
Activity Pool |
Department Costs |
Cost Driver |
||||
|---|---|---|---|---|---|---|
|
Binding |
$297,000 | Number of units | ||||
|
Printing |
955,500 | Machine hours | ||||
|
Product design |
234,000 | Change orders | ||||
|
General |
727,500 | None | ||||
|
Total overhead costs |
$2,214,000 | |||||
Other information is as follows:
|
Tablets |
Books |
||||
|---|---|---|---|---|---|
|
Units |
62,500 | 30,000 | |||
|
Direct materials cost per unit |
$3.00 | $10 | |||
|
Direct labor cost per unit |
$7.00 | $14.00 | |||
|
Direct labor hours |
30,000 | 19,200 | |||
|
Machine hours |
150,000 | 144,000 | |||
|
Change orders |
1,500 | 2,400 |
Bramble’s managers have gathered the following information about
selling and administrative costs.
|
Activity Pool |
Total Cost |
Cost Driver |
||
|---|---|---|---|---|
|
Shipping |
$300,000 | Pounds shipped | ||
|
Advertising |
187,500 | Number of mailings | ||
|
Commissions |
168,125 | Sales price | ||
|
Total selling and administrative costs |
$655,625 |
|
Tablets |
Books |
||||
|---|---|---|---|---|---|
|
Weight |
20,000 pounds | 40,000 pounds | |||
|
Advertising mailings |
25,000 | 100,000 | |||
|
Sales commission |
5% of sales price | 8.00% of sales price | |||
|
Selling price per unit |
$35 | $75 |
Calculate ABC rates. (Round answers to 2 decimal
places, e.g. 15.25.)
|
S&A Cost ABC rates |
|||
|---|---|---|---|
|
Shipping |
$enter a dollar amount per pound rounded to 2 decimal places /lb. | ||
|
Advertising |
$enter a dollar amount per mailing rounded to 2 decimal places /mailing |
|
Product Cost ABC rates |
|||
|---|---|---|---|
|
Tablets |
$enter a dollar amount per unit rounded to 2 decimal places per unit | ||
|
Books |
$enter a dollar amount per unit rounded to 2 decimal places per unit |
1. ABC rates
Departmental cost
| Activity | Cost Pool | / | Cost Driver | = | Activity rate |
| Binding | $297,000 | / | 92,500 units | = | $3.21 per unit |
| Printing | $955,500 | / | 294,000 machine hours | = | $3.25 per machine hour |
| Product design | $234,000 | / | 3,900 changes orders | = | $60.00 per change order |
S&A Cost ABC rate
| Activity | Cost Pool | / | Cost Driver | = | Activity rate |
| Shipping | $300,000 | / | 60,000 pounds | = | $5.00 per pound |
| Advertising | $187,500 | / | 125,000 mailings | = | $1.50 per mailing |
2. Product cost
| Particulars | Tablets | Books |
| Direct materials cost per unit | $3.00 | $10.00 |
| Direct Labor cost per unit | $7.00 | $14.00 |
| Overhead cost per unit | $12.45 | $23.61 |
| Total Unit product cost | $22.45 | $47.61 |
| x Units sales | 62,500 | 30,000 |
| Total Product cost | $1,403,125 | $1,428,300 |
Working Notes:
Allocation of overhead cost
Tablets
| Activity | Cost Driver | x | Activity rate | = | Overhead cost |
| Binding | 62,500 units | x | $3.21 per unit | = | $200,625 |
| Printing | 150,000 machine hours | x | $3.25 per machine hour | = | $487,500 |
| Product design | 1,500 change orders | x | $60.00 per change order | = | $90,000 |
| Total Overhead costs | = | $778,125 |
Overhead cost per unit = $778,125 / 62,500 units = $12.45 per unit
Books
| Activity | Cost Driver | x | Activity rate | = | Overhead cost |
| Binding | 30,000 units | x | $3.21 per unit | = | $96,300 |
| Printing | 1,000 machine hours | x | $3.25 per machine hour | = | $468,000 |
| Product design | 2,400 change orders | x | $60.00 per change order | = | $144,000 |
| Total Overhead costs | = | $708,300 |
Overhead cost per unit = $708,300 / 30,000 units = $23.61 per unit
All the best...