Budgeting HELP
bjw
Registered Posts: 3 New contributor ?
On the Budgeting practice paper question 2.1c the question states:
This year's budget for raw materials was set at £302,400. This assumed a 4% reduction in production and a 5% increase in raw material prices compared with the previous year.
However production volume is 6% lower than the previous year and there has been no price increase.
Calculate the material cost forecast: ????
The answer is meant to be £282,000
Please can someone explain how to work this out??
Thanks
This year's budget for raw materials was set at £302,400. This assumed a 4% reduction in production and a 5% increase in raw material prices compared with the previous year.
However production volume is 6% lower than the previous year and there has been no price increase.
Calculate the material cost forecast: ????
The answer is meant to be £282,000
Please can someone explain how to work this out??
Thanks
0
Comments

Ok first we have to add back the reduction in production so 302400/96x100 = 31500, as 4% has been taken off to account for the reduction in production this leaves us with only 96% of the figure we need to adjust.
Next we have to deduct the 5% that was accounted for, for an increase in raw materials price so 31500/105x100 = 30000 This leaves us with the figure before adjustments that we need, and we can now make the correct adjustment.
30000/100x94 = 282000 the figure of 94 is 100% less the 6% that needs to be adjusted.
I hope this helps. These questions are really fun when you get the hang of them.
Neil.0 
Thanks soo much.. been thinking about this question for ages and going round it circles. It seems really simple now you've told me.
Thanks you :001_smile:0 
I'm glad it helped, i was a little worried that i didn't get it across too well. The first thing to remember (and do) is adjust the initial figure back to what it was before any alterations, this means deducting and adding back in this case. Then you are left with a starting figure and can make the correct adjustments.
Good luck,
Neil.0 
I would go further than the previous poster in answering this question.
First of all you need to do the first part of the question in adding or deducting back,however you only need to bother about the second part of this if there is a reference to it in the last part of the question.
In other words if in the last part they make no mention of the second possible calculation you then ignore it.
I hope this helps.0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 251 NEW! Qualifications 2022
 139 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 35 AAT Level 3 Diploma in Accounting
 59 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 137 Bookkeeping
 7.3K General accounting discussion
 193 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 589 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership