FPFM Financial Performance - AAT Sample Assessment 1 - Task 5 - Index Numbers
eddzter1978
Registered Posts: 6
Hello All,
Could someone help me please. I thought I had index numbers ok in my head, but task 5 of the FPFM sample assessment 1 on the AAT website has completely thrown me.
It says Keta operates a standard costing system and uses raw material C2X which is a global commodity. The standard price was set based upon a market price of £450 per litre when the material price index for C2X was 120.50. The following information has been gathered:
- the price index increased to 126.525 in June X3
- the raw material price variance for June was £375,000 adverse
- 12500 litres of material C2X were purchased in June.
It then asks you to complete the following statements:
a - The part of the variance explained by the increase in the price index is - £
b - The part of the variance not explained by the increase in the price index is - £
The answers are a) £281,250 and b) £93,750 but I cannot work out how to get to these figures.
Any help would be most appreciated.
Thanks
Ed
Could someone help me please. I thought I had index numbers ok in my head, but task 5 of the FPFM sample assessment 1 on the AAT website has completely thrown me.
It says Keta operates a standard costing system and uses raw material C2X which is a global commodity. The standard price was set based upon a market price of £450 per litre when the material price index for C2X was 120.50. The following information has been gathered:
- the price index increased to 126.525 in June X3
- the raw material price variance for June was £375,000 adverse
- 12500 litres of material C2X were purchased in June.
It then asks you to complete the following statements:
a - The part of the variance explained by the increase in the price index is - £
b - The part of the variance not explained by the increase in the price index is - £
The answers are a) £281,250 and b) £93,750 but I cannot work out how to get to these figures.
Any help would be most appreciated.
Thanks
Ed
1
Comments
-
Hello,
The standard was 12,500 litres @ £450 = £ 5,625,000
We know there an adverse variance of £ 375,000
Therefore the actual cost must of been £ 5,625,000 + £ 375,00 = £ 6,000,000
The actual cost per litre £ 6,000,000 / 12,500 litres = £ 472.50
If we re-index the cost per litre to current figures £ 450/120.50*126.525 = £ 472.50
So,
Variance not explained by indexing = £ 480 - £ 472.50 * 12,500 litres = £ 93,750
Variance expained by indexing = £ 22.50 (£ 472.50 - £ 450) * 12,500 litres = £ 281,250
Feeling helpful Hope this correct
0 -
Oops, actual cost per litre is £ 480 - the rest looks ok :P0
-
Thank you so much! Amazing.0
-
what about how to calculate the percentage task 1.5 (q) C
0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 323 NEW! Qualifications 2022
- 165 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 88 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 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 off-topic 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