Costs questions!
Sammmy88
Registered Posts: 283 Dedicated contributor 🦉
Just a few questions I have I can't seem to work out.
On the aat practice paper, task 2.1 on the on the batches sold and produced. I can work out everything except for the fixed element. I am insure at how to work this out.
Also on task 2.4 the budget and actual performance, I am unsure as to how to work out the operating profit, as every answer I get is different from practice answers!
Just soooo worried about this exam!
On the aat practice paper, task 2.1 on the on the batches sold and produced. I can work out everything except for the fixed element. I am insure at how to work this out.
Also on task 2.4 the budget and actual performance, I am unsure as to how to work out the operating profit, as every answer I get is different from practice answers!
Just soooo worried about this exam!
Level 2  Passed 2011
Level 3  Passed 2012
Level 4  Passed 2014
Awaiting to start CIMA
Level 3  Passed 2012
Level 4  Passed 2014
Awaiting to start CIMA
0
Comments

Hi Sammy, which aat practice paper is it? If you tell me the year and if June/Dec or send me the question I can try and explain it better that way.
Thanks,
Amy0 
Hi there
Hope you don't mind me butting in....
I am looking at Broadsword from the Word practice assessment on the AAT pages:
Task 2.1
You are told that the semivariable costs for 3,000 units is £7,380 You're also give the semivariable cost for £1,200 units as being £3,780:
£7,380  £3,780 = £3,600
3,000 units  1,200 units = 1,800 units
Now you divide the cost by the number of units: £3,600/1,800 units = £2.00/unit (the variable element.
If the variable element for 1,200 units is 1,200 units x £2.00 = £2,400, the fixed element must be £1,380 (£3,780£2,400 = £1,380)
Now we can work out the fixed and varaible element for each level of production
1,500 units x £2.00 = £3,000 + fixed £1,380 = £4,380
2,000 units x £2.00 = £4,000 + fixed £1,380 = £5,380
As for Task 2.4 I assume that you're adjusting the direct materials and labour for the new level of production whilst keeping the overheads fixed at £980,000>
In the orignial budget materials were £350,000 for 100,000 units so:
£350,000/100,000 = £3.50 per unit
Now we use this to flex the budget to the actual production of 144,000 units:
£3.50 x 144,000 = £504,000
Do the same for the Direct labour and revenue
Remember with these the term 'direct' relates directly to the costs (materials or labour) that we can directly associate with the production.
The operating profit is the Revenue (also reworked to reflect the flexed budget)  direct costs  overheads
Hope this helps0 
Hi Amy, it's the practice CBA on the aat website!
Thanks welsh wizard that's been a huge help! Makes sense to me now!
One more thing though on task 2.5, I know how to work out the pay period in the table and whether or not it is negative or positive. I am just stuck on how you actually work out the payback period in years/months?Level 2  Passed 2011
Level 3  Passed 2012
Level 4  Passed 2014
Awaiting to start CIMA0 
From your quote:I know how to work out the pay period in the table
At the point where you find that say £20,000 is needed to payback a project at the start of year 4, and there is a net cash flow of £24,000 in year 4.
Then you know that at some point in year 4 the project reaches the payback before going on to end the year as +£4,000
If you assume that cash flows during year 4 accrue evenly throughout the year,
then the exact point in year 4 is £20,000 x 12 months = 10 months
.........................................£24,000
This gives a payback period of 3 years and 10 months
The formula is
........... the amount required to payback in final year x 12 months = months in final year, add the number of full years
...........................the final year cash flowSandy
sandy@sandyhood.com
www.sandyhood.com0 
Oh I see that makes total sense now! I was just getting really confused.
Also another confusing point and its the last one (promise :p). Is in Task 1.1, I am comfortable with AVCO, but if the same question where to say LIFO or FIFO, the bit that confuses me, is the receipts and what to value the stock at...Level 2  Passed 2011
Level 3  Passed 2012
Level 4  Passed 2014
Awaiting to start CIMA0 
Hi Sammy, looks like your queries have all been answered :) You will be fine on this exam, sounds like you know most of it just a few little things confusing you, I did this exam a couple of weeks ago and was really worried about it and passed so I am sure you will be fine.
Amy0 
Have a look at this blog
There are 3 parts to the stock valuation section (so my apologies for giving you so much to read  I hope it provides a useful refresher)
stock 1
stock 2
stock 3
I hope it helps, if not please put a question together here and I'll try to helpSandy
sandy@sandyhood.com
www.sandyhood.com0 
Unfortunately I still don't understand how to work out the cost per kg in the issues part :(Level 2  Passed 2011
Level 3  Passed 2012
Level 4  Passed 2014
Awaiting to start CIMA0 
Sammy
Imagine that every kg you buy has a price label on it
You collect them in date order
Then when you issue stock you allocate the price labels in date order (for FIFO) and in reverse date order for (LIFO)
Say you had 20,000 kgs in stock last night made up of
5,000 that arrived 3 weeks ago at £10 per kg
9,000 that arrived 2 weeks ago at £11 per kg
6,000 that arrived last week at £12 per kg
And this morning a single requisition arrived for 16,000 kgs
This would have to be charged as
5,000 £10 £50,000
9,000 £11 £99,000
2,000 £12 £24,000
A total of 16,000 kgs and a total cost of £173,000
That should be the end of the story, but I am guessing that you want an average cost for that issue. If so:
£173,000 = £10.8125 per kg
16,000 kgsSandy
sandy@sandyhood.com
www.sandyhood.com0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 317 NEW! Qualifications 2022
 160 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 87 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 92 Software
 273 Tax
 135 Bookkeeping
 7.2K General accounting discussion
 200 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 582 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