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...