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.
- Answer To Management Accounting Question No:ABC2 on Activity Based Costing
- Accounting Question No ABC1 On Activity-Based Costing
- Activity Based Costing Question No.5 (with answer)
- Activity Based System Question No 4 (with answer)
- Management Accounting Question ABC No2 On Activity Based Costing
- What is Activity-Based Costing System?
- Activity-Based Costing System:The Necessity To Know The “True” Cost Of A Product

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