Refer to Accounting Test Question No.ABC2
(a) Computation of the activity based overheads
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) |
Purchasing | $75,000 | 1,500 | $50/purchase order |
Setting | $112,000 | 2,800 | $40/batch |
Materials handling | 96,000 | 8,000 | $12/movement |
Inspection | $70,000 | 2,800 | $25/batch |
Machining | $150,000 | 50,000 | $3/machine hour |
Step 2:Compute the volume of cost drivers consumed by Product XX
Purchase orders (given) =25 |
Batches=15,000/100=150 |
Materials movement=150 batches x6=900 |
Machine hours=15,000 units x 0.1=1,500 |
Step 3:Compute the Activity Based Overheads cost for Product XX
Activity | ||
Purchasing | 25 orders x $50 | $1,250 |
Setting | 150 batches x $40 | $6,000 |
Material handling | 900 movements x $12 | $10,800 |
Inspection | 150 batches x $25 | $3,750 |
Machining | 1,500 hours x $3 | $4,500 |
Total | $26,300 |
(b) Computation of budgeted overheads costs for Product XX using absorption costing
Budgeted overheads
=($75,000+$96,000+$112,000+$70,000+$150,000)
=$503,000
Budgeted absorption cost/machine hour
=$503,000/50,000
=$10.06
Budgeted machining hours for Product XX=1,500
Budgeted absorbed overhead
=1,500 x $10.06
=$15,090
© Ways in which the company can reduce the ABC for product XX:
- Reduce the number of batches by increasing the batch size which will then reduce the setting overhead,materials handling and inspection costs.
- Reduce the number of purchase orders
- Innovate ways of speeding up production so that the machining hours are reduced.
- Management Accounting Question ABC No2 On Activity Based Costing
- Answer To Accounting Test Question No. 1 On Activity Based Costing
- Activity Based System Question No 4 (with answer)
- Accounting Question No ABC1 On Activity-Based Costing
- Activity Based Costing Question No.5 (with answer)
- What is Activity-Based Costing System?
- Steps In Implementing Activity-Based Costing System(ABC):

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.
what is the economic business cycle