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 reindex 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 (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