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/Management-Cost-Accounting-For-Dummies/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 (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