Refer to Accounting Test Question No.1
(a) Computation of the activity based costs and profits for each contract.
Step 1: Compute cost per unit of cost driver
= Cost pool / cost driver volume
|
Activity |
Cost pool (a) |
Cost driver volume/yr (b) |
Cost/unit of cost driver (a)/(b) |
|
Moulding |
$150,000 |
2,000 |
$75/moulding hour |
|
Inspection |
$75,000 |
150 |
$500/batch |
|
Production Management |
$125,000 |
20 |
$6,250/contract |
Step 2: Compute the cost drivers consumed by each contract
|
Cost driver |
Customer AAA |
Customer BBB |
|
Batches |
1,000 unit/100 =10 |
2,000unts/50=40 |
|
Moulding hours |
10batches x 5=50 |
40batchesx7.5=300 |
|
Contracts |
1 |
1 |
Step 3: Finally, compute the Costs And Profit For Each Contract
Under Activity Based Costing Methodology
Costs And Profits For Each Contract
|
|
|
Contract AAA |
|
Contract BBB |
|
Selling price |
|
$27,000 |
|
$100,000 |
|
Materials |
1,000 x $15 |
$15,000 |
2,000 x $20 |
$40,000 |
|
Moulding |
50 hours x $75 |
$3,750 |
300 hour x$75 |
$22,500 |
|
Inspection |
10 batches x $500 |
$5,000 |
40 batches x $500 |
$20,000 |
|
Management |
|
$6,250 |
|
$6,250 |
|
Total cost |
|
$30,000 |
|
$88,750 |
|
Profit/(Loss) |
|
($3,000) |
|
$11,250 |
(b) Computation of profit based on absorption costing using moulding hour
First compute the overhead absorption rate
=Total annual overheads/annual moulding hour
=($150,000+$125,000)/2,000
=$175 per moulding hour.
Under Absorption Costing Methodology
Costs And Profits For Each Contract
|
|
|
Contract AAA |
|
Contract BBB |
|
Selling price |
|
$27,000 |
|
$100,000 |
|
Materials |
1,000 x $15 |
$15,000 |
2,000 x $20 |
$40,000 |
|
Overheads |
50 hours x $175 |
$8,750 |
300 hour x$175 |
$52,500 |
|
Total cost |
|
$23,750 |
|
$92,500 |
|
Profit/(Loss) |
|
$3,250 |
|
$7,500 |
Notes:
- Based on activity based costing, Customer AAA’s contract would be unprofitable while Customer BBB’s contract is worth accepting. (Refer earlier article on ABC able to give a true cost)
- If we use the traditional costing accounting/method which is the absorption costing basis, the management will think that both contracts were profitable.
- Using activity based costing, the management should only accept only 1 contract which is Customer AAA’s contract.

FCCA,CA(MIA)with more than 26 years of post-qualifying working experiences. Previous working stints with one of the big accounting four, Regional GFC & Group Treasurer in a group of Malaysian and Group CFO in Singapore public listed concern.
Also author to another very popular free educational accounting cum finance blog: http://basiccollegeaccounting.com under the branding of College Accounting Coach.
[...] [Refer Answer] [...]
[...] [Refer Answer] [...]