AAT Level 3 - Management Accounting Techniques (MATS) - Exam Walkthrough - Part 2

Within this video i'll be walking you through Task 4 through to 6 of Management Accounting Techniques (MATS). This is covering mock two from the AAT website.
Thank you for watching the video and supporting the channel! Links below:
Looking for live AAT revision sessions?:
www.willboardman.co.uk
/ willboardman_
www.linkedin.com/in/will-boardman
[e-mail]
📚 Looking for the best AAT study material?
accountext.co.uk/
Use code: "will20" for 20% off your order.
☕ Looking for the best coffee to help you focus?
londonnootropics.com/
Use code: "Willboardman" for 15% off.
Link to my full library of videos:
tinyurl.com/2ye4xunx

[@nickjones3600]

Excellent walk through Will, great explanations making it very easy to follow. Very grateful of your efforts. Many thanks

[@brettgreen325]

Thanks Will. A nice tempo and very clear explanations. I would recommend anyone to watch these videos as a final refresher the night before the assessments. I.e., close the books and just visualise!! Cheers mate

[@yoshistarluca]

This is super useful and the way you are explaining the answers will help me remember on my exams. Thanks a lot for all the videos!

[@rajapakserasika]

watched your videos for my AAT level -2 , they helped me a lot . Now i'm watching for AAT level 3. many thanks for doing this.

[@GirlyPop12V]

absolutely brilliant much love, Will

[@BeeLane-qr9fn]

Effortless listening to you going through the exam and learning from you too.

[@sharajaff9425]

Thanks so much it was useful to me

[@suelathaci4897]

Thank you very much Will,you saved my life 😅😂

[@cookupwithkupid3s503]

GOAT

[@jeffgreening3356]

thanks Will, can we use F function keys in the exam? (F4 for absolute reference)

[@Willboardman]

Hi Jeff, you’ll be able to use the F keys within the exam yes.

[@kellythomas2484]

hi will, in true or false questions is one always true and the other false in the aat exams? thanks

[@Zenic449]

Got my exam in 2 weeks, do you not need to upload your excel file like in previous 2016 ?

[@attiafatima9096]

hey, is it advisable to claim 3 exemptions from level 4?

[@natasha7761]

You can only claim 50% per level, so for level 4 you can only be exempted from 2 exams.

[@Willboardman]

Hi, I would double check but historically you could only claim up to 50% of the qualification as exemptions. Doesn’t fit perfectly given there are 5 exams at level 4 it may mean only being able to get exemptions from 2.

[@attiafatima9096]

@@Willboardman that's why i'm confused, they offered me 3

[@KeKsA]

Hi Will, just double checking shouldn't cell C3 be = (6,000-5,000)/5,000 which after hitting enter will give you 0 but then by changing to % should be 20% rather than 120%? Please let me know x

[@Willboardman]

Hi! It’s a fair question and it comes down to both wording and the maths behind it. So I have double checked and it is showing at 120%. So you’re correct in that you’re flexing the budget by an increase of 20%. But in order to do that you’d need to multiply your originally budgeted figures by 120% to get your increase of 20%. If we were to just multiply them by 20% it would only give us the 20% of the budgeted figure rather than the flexed amount. In theory you could use a formula to do 20% of the budgeted figure plus the budgeted figure which would also work :).

[@KeKsA]

@@Willboardman Thanks Will, that's exactly what I did and managed to get the same figures at the end as you did apart from % I queried. Thanks for fast response and clarity :)