Activity Based Question
jlambo21
Registered, AAT Student Posts: 5 New contributor 🐸
Hello
If anyone can help me with the workings for this please ill be grateful.
Thank you
0
Comments

https://forums.aat.org.uk/Forum/discussion/447843/abccosting#latest
With a little search, please see above0 
CornishPixie Registered, MAAT, AATQB, AAT Licensed Accountant Posts: 117 Dedicated contributor 🌟 🐵 🌟Ok here's how I would answer this question = please let me know if I am right or wrong.
Do the basics first (note that they have reversed these in the table, putting materials first).
Cost driver per production set up is £2,000,000 / 250 (50 + 200) = £8,000
Cost driver per material requisition is £3,500,000 / 875 (175 + 700) = £4,000
Therefore, the total materials handling will be:
Alpha  £4,000 x 175 requisitions = £700,000
Delta  £4,000 x 700 requisitions = £2,800,000
Production set up will be:
Alpha  £8,000 x 50 set ups = £400,000
Delta  £8,000 x 200 set ups = £1,600,000
For b) you are told that it takes Alpha 2 labour hours to complete each unit and Delta uses 1 hour.
For Alpha it will be 2 x 87,500 = 175,000 hours
For Thyme it will be 1 x 100,000 = 100,000 hours
Total is 275,000 hours
Then, work out the hourly rate. So that would be £2,000,000 + £3,500,000 / 275,000 = £20 per hour
Therefore, for Alpha, the calculation will be 200,000 x £20 = £4,000,000
And for Delta, the calculation will be 1,600,000 x £20 = £32,000,000
Total = £36,000,000
0 
CornishPixie Registered, MAAT, AATQB, AAT Licensed Accountant Posts: 117 Dedicated contributor 🌟 🐵 🌟Spotted an error in my workings at the bottom of above, the 200,000 should be 400,000. Corrected below
Therefore, for Alpha, the calculation will be 400,000 x £20 = £8,000,000
And for Delta, the calculation will be 1,600,000 x £20 = £32,000,000
Total = £40,000,0000 
Thank you !!0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 234 NEW! Qualifications 2022
 133 General Qualifications 2022 discussion
 7 AAT Level 2 Certificate in Accounting
 31 AAT Level 3 Diploma in Accounting
 55 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 91 Software
 272 Tax
 135 Bookkeeping
 7.3K General accounting discussion
 201 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 586 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 47 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership