In: Accounting
Activity-Based Supplier Costing
Clearsound uses Alpha Electronics and La Paz Company to buy two electronic components used in the manufacture of its cell phones: Component 125X and Component 30Y. Consider two activities: testing components and reordering components. After the two components are inserted, testing is done to ensure that the two components in the phones are working properly. Reordering occurs because one or both of the components have failed the test and it is necessary to replenish component inventories. Activity cost information and other data needed for supplier costing are as follows:
I. Activity Costs Caused by Suppliers (testing failures and reordering as a result)
Activity | Costs |
Testing components | $1,200,000 |
Reordering components | 300,000 |
II. Supplier Data
Alpha Electronics | La Paz Company | ||||||||||||
125X | 30Y | 125X | 30Y | ||||||||||
Unit purchase price | $10 | $26 | $12 | $28 | |||||||||
Units purchased | 120,000 | 78,400 | 15,000 | 15,000 | |||||||||
Failed tests | 1,700 | 780 | 10 | 10 | |||||||||
Number of reorders | 60 | 40 | 0 | 0 |
Required:
Determine the cost of each supplier by using ABC. Round Test and Reorder rates to the nearest dollar, and final answers to the nearest cent.
Alpha Electronics | La Paz Company | ||||
125X | 30Y | 125X | 30Y | ||
Unit cost: | $fill in the blank 1 | $fill in the blank 2 | $fill in the blank 3 | $fill in the blank 4 |
Alpha Electronics |
La Paz Company |
Total |
|||
125X |
30Y |
125X |
30Y |
||
Failed tests (a) |
1,700 |
780 |
10 |
10 |
2,500 |
Number of reorders (b) |
60 |
40 |
0 |
0 |
100 |
Activity Cost |
Units |
Cost per Unit |
||
Testing Components |
$1,200,000.00 |
2,500 |
$480.00 |
|
Reordering Components |
$300,000.00 |
100 |
$3,000.00 |
|
Alpha Electronics |
La Paz Company |
|||
125X |
30Y |
125X |
30Y |
|
Failed tests (a*480.00) |
$816,000.00 |
$374,400.00 |
$4,800.00 |
$4,800.00 |
Reordering Components(b*3,000) |
$180,000.00 |
$120,000.00 |
$0.00 |
$0.00 |
Total Costs © |
$996,000.00 |
$494,400.00 |
$4,800.00 |
$4,800.00 |
Units Purchased (d) |
120000 |
78,400 |
15000 |
15000 |
Cost per Unit (e=c/d) |
8.30 |
$6.31 |
$0.32 |
$0.32 |
Purchase Price (f) |
$10.00 |
$26.00 |
$12.00 |
$28.00 |
Total Costs (e +f) |
$18.30 |
$32.31 |
$12.32 |
$28.32 |
I hope it is useful to u if u have any doubt pls comment give me up thumb