Level 4 - Management Accounting Decision & Control 2016
SigitaGib
Registered Posts: 6
I need some help to work out assessment task 2 online. The question:
Budgeted variable costs for the manufacture of 250 barrels.
Cost per unit £ Budgeted Cost£
Materials 36.00 9,000
Direct Labour 22.50 5,625
Variable overhead 10.50 2,625
Total cost 17,250
Actual production for the period was 300barrels and the total variances as follows:
Total variance£
Materials 1,200F
Direct Labour 390A
Variable Overhead 210F
During the period, the actual cost of material was £10 per kg and the standard quantity per unit was 3kg
420 actual hours were worked.
The standard labour time per unit was 1.5 hours.
Calculate Materials:
Actual Material Cost
Material Price Variance
Material Usage Variance
Standard Material Cost Of Production
Calculate Variable Overhead:
Actual Variable Overhead Cost
Variable Overhead Expenditure Variance
Variable Overhead Efficiency Variance
Standard Variable Overhead Cost Of Production
Budgeted variable costs for the manufacture of 250 barrels.
Cost per unit £ Budgeted Cost£
Materials 36.00 9,000
Direct Labour 22.50 5,625
Variable overhead 10.50 2,625
Total cost 17,250
Actual production for the period was 300barrels and the total variances as follows:
Total variance£
Materials 1,200F
Direct Labour 390A
Variable Overhead 210F
During the period, the actual cost of material was £10 per kg and the standard quantity per unit was 3kg
420 actual hours were worked.
The standard labour time per unit was 1.5 hours.
Calculate Materials:
Actual Material Cost
Material Price Variance
Material Usage Variance
Standard Material Cost Of Production
Calculate Variable Overhead:
Actual Variable Overhead Cost
Variable Overhead Expenditure Variance
Variable Overhead Efficiency Variance
Standard Variable Overhead Cost Of Production
0
Comments
-
Which bit are you having difficulty with? Any particular calculation or the whole question? Can you narrow it down as I'm not sure if I have to time to work everything out and give explanations?0
-
Would appreciate the whole question as I got totally confused. Any help would be perfect0
-
I am used to remembering and writing the calculations in a particular way that works for me but I'll try and write/explain it so you understand.
Actual Material Cost
Total Material Variance = Actual Cost v Actual Production @ std qty per unit @ std price per kg
we know the above formula, and we know the variance and can work out the other..
Total Material Variance = 1,200 F
Actual production of 300 units should have used 900kg @ £12 per kg = £10,800
Std qty is 3kg per unit. 300 unit x 3kg per unit = 900kg. Each kg costs £12per kg (we know budget production of 250 units is expected to use 750kg (3kg per unit) and 750kg have a budgeted cost of £9000, therefore std price is £9000/750kg = £12 per kg).
Simply Budgeted unit cost is £9000/250 units = £36 per unit, Actual production of 300 units is expected to cost 300 x £36 = £10,800
Putting these two figures into the formula:
1,200F = Actual Cost v £10,800
These means actual cost must be £1200 less than the budgeted cost, hence
actual material cost is £9600
Material Price Variance
Material Price Variance = Actual material cost v Actual qty @ std price
Actual cost we just worked out is £9600.
We are told that actual cost of material is £10 per kg, therefore £9600/£10 per kg = 960 kg. Actual qty of 960kg is expected to cost £11,520 (at std price of £12 per kg).
Material Price Variance = £9600 v £11,520 = £1,920 F
Material Usage Variance
Material Usage Variance = Actual qty @ std price v Actual production @ std qty @ std price
You have already worked out the figures in bold.
Material Usage Variance = £11,500 + £10,800=£720 A
Standard Material Cost of Production
I am guessing this is asking for the "standard material cost of actual production' The wording isn't clear but the answer you would have had to work out already £10,800, is this the answer?
0 -
The second part is similar so if you understand my workings you can try the second part yourself.
This unit really test your understanding of the variances so it's important you learn this thoroughly.
As I am used to my own short hand it was difficult to type out an explanation so I hope I haven't confused you further.
Good luck.
0 -
Thank you so much, it's much clearer now. I know the formulas, just struggle to use them. Will give a go to a second part and practice practice.0
-
Im struggling with this a lot my exam is in a week and I cant seem to remember the Variance formulas to use in the exam, is there any easy way to remember this. I never know what information you use when given a paragraph really confuses me0
-
Hi Sinead,
If you let me have your email address I am happy to share my notes on the variances. I know I can embed images onto the post but busy with work and studies to fiddle with it.
I don't know if my notes will help or confuse you further, it's just a way I lay out the calculations, in shorthand because you haven't got the time in the exams. If you are only having problems with remembering the calculations and can apply them to the questions then it may help.
You'll see a pattern, that for each you only have to memorise 3 calculations and not 6. and that basically the material, labour and variable overhead variances are very similar, so rather than remembering 18 calculations it's really only 3, the concepts are the same for each set.
My trick is I visually remember each one it its order, always price, usage and then total for material. Rate, efficiency and then total for labour etc. There is a distinct pattern and with the stressful exam conditions I don't need the panic of remembering which figure goes where.
The fixed overhead variances are a bit different though.
Good luck with your exam next week!
0 -
My exam in 2 weeks time and even knowing formulas it doesn't make sense where to use them. If you could share your notes with me also, I would really appreciate it N4T. My email sigita@mbs.gi0
-
Just emailed you.0
-
Hi Sigita,
I haven't said what is adv or fav because I think that its obvious and this would have been covered in L3. My advise to you is do more questions. Have you got exam or revision kits from Kaplan or BPP or Osborne? They will give you plenty of questions on one specific area. At the moment you are attempting exam type questions (which is good) but they throw a lot into one question which is confusing if you don't know the basics.
So i strongly recommend you get hold of a revision/exam if you haven't got one already and build on your knowledge from there first. You have two weeks so enough time.0 -
hello that would be much appreciated I feel I might have hope of passing if I can learn a way to remember the variances
my email is : sinead1@yahoo.com
Thank you0 -
Hi Sinead,
I just emailed the notes to you. Let me know if you dont receive it and I'll try again this evening.0 -
Hi everyone, I am new to this forum so apologies if I am not supposed to be writing here. I am taking my Management accounting:Decision and control exam level 4 on Tuesday. Struggling with two questions from the AAT sample paper 2- can anyone please help?
Task 8a-
Question= The maximum profit from the optimal production plan would be?
Answer=1785 not sure how this is worked out?
Task 9c-
Question=To the nearest whole units, the required sales volume is?
Answer=25217 units, not sure how this is worked out?
Any help would be much appreciated. Thanks so much.
0 -
Task 9c:
Reduced selling price per unit: £17.00
Target net profit per unit (£17 x 25%): £4.25
Target total cost per unit (£17 - £4.25): £12.75
Expected variable cost per unit (£140k/£20k): £7.00
Target fixed cost per unit (£12.75 - £7): £5.75
Required sales volume:
Total fixed costs / Target fixed cost per unit
£145,000 / £5.75 = 252170 -
Task 8a you need to account for the fixed costs per unit of product X - while we are producing less the fixed cost remains the same it's just under absorbed.
Product X Profit: £414
Product Y Profit: £660
Product Z Profit: £800
Total profit: £1874
However, X was budgeted at 407 units meaning we still incur fixed costs for the 207 units @ £0.43/unit:
207 x £0.43 = £89.01
£1874 - £89.01 = £1784.99 therefore £1785
...and in doing this realised I did it wrong in my MDCL exam! Oops0 -
Thank you so much Irrorate it makes sense now.
0 -
Hi All,
Has anyone re-sit the D&C exam yet?just got my results and got 64% really devastated. First fail in my life.
What sort of questions you had? Any tips or advice?
Many thanks0 -
Hi Yalda
sorry to hear. I failed my first exam as well with 69%. I also made an appeal but didn't work it got rejected it is really frustrated.
My exam didn't go that bad i had tasks 3, 8,9 exactly like assessment 2 rest of them was about standard costing lots of tricks also try to learn fixed costs variances. and learn thoroughly asset turnover.
I'm going to re-sits soon if you can share with me how was your exam it will be great help.
Thanks
0 -
Hi @gagan -
Many thanks for your message. I am sorry that you have failed too. I am sure you will pass next time. I am probably re-sitting mine end of October now because of other exam and life commitments but of course I will share my experience. Can you please also let me know if you re-sit it before me that would be awesome. I think some of my class mates might be re-sitting soon so I will ask them and let you know. Good luck with your exam (s).1 -
Yes sure I'll share my experience.
Thanks for wishing me good luck.
Good luck to you too.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 328 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 57 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 275 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 203 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 584 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership