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
- 12.5K For AAT students
- 328 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 57 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 275 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 203 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 584 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