Fin Perf Question Help
jessbill3
Registered Posts: 17
Keta operates a standard costing system and uses raw material C2X which is a global community. 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
 12,500 litres of material C2X were purchased in June
Complete the statements below. In order to calculate your answers, you should split the raw material price variance into two components by calculating the part of the variance explained by the change in the price index and the part of the variance not explained by the changes in the price index.
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 £
c) the percentage increase in the index is %
Answers:
a) £281,250
b) £93,750
c) 5%
Please help i have no idea where to start
 the price index increased to 126.525 in June X3
 the raw material price variance for June was £375,000 adverse
 12,500 litres of material C2X were purchased in June
Complete the statements below. In order to calculate your answers, you should split the raw material price variance into two components by calculating the part of the variance explained by the change in the price index and the part of the variance not explained by the changes in the price index.
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 £
c) the percentage increase in the index is %
Answers:
a) £281,250
b) £93,750
c) 5%
Please help i have no idea where to start
0
Comments

Where to start?
We know the material price variance is the difference between the standard cost of the litres of material purchased and the actual amount paid. Here we are told that we bought 12,500 litres and that the standard price per litre was set at £450. This allows us to calculate the standard cost of 12,500 litres
12,500 litres x £450 = £5,625,000  We are also told that there was a material price variance which was adverse. This means that when we bought the 12,500 litres we paid more than the standard cost.
Actual cost: £5,625,000 + £375,000 = £6,000,000  The index has increased since the standard price was set. We need to revise the standard price to take this into account. Divide by the index value at the time the standard was set and multiply by the index value for the month of the variance.
£450 divided by 120.50 multiplied by 126.525 = £472.50  Find the standard cost of the litres purchased using the revised standard price
12,500 litres x £472.50 = £5,906,250  We can now separate the £375,000 price variance into the part due to the increase in the price index, and the part due to other factors such as the effectiveness of the purchasing team
 Original Standard cost £5,625,000
less Revised stdd cost £5,906,250
Increased index variance £281,250 adverse  Revised standard cost £5,906,250
Less actual price paid £6,000,000
Price variance (other factors) £93,750 adverse  The question of the % increase in the index could be found in point 3. Here just find the difference in the index value (126.525  120.50 = 6.025) and divide it by the index value when the standard was set 6.025 divided by 120.50 = 0.05
Multiply by 100 to find the percentage 0.05 x 100 = 5%
http://www.amazon.co.uk/ManagementCostAccountingForDummies/dp/1118650492
I encourage you to contribute to cancer research UK through the Maureen's Miracles page if you would like to show your appreciation for the answer given:
http://relay.cancerresearchuk.org/site/TR/RelayForLife/General?team_id=6827&pg=team&fr_id=1481
sandy@sandyhood.com
www.sandyhood.comSandy
sandy@sandyhood.com
www.sandyhood.com0  Here we are told that we bought 12,500 litres and that the standard price per litre was set at £450. This allows us to calculate the standard cost of 12,500 litres
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 318 NEW! Qualifications 2022
 161 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