Budgeting - percentage calculations
dalmatian
Registered Posts: 37 New contributor 🐸
This year's budget for raw materials was set at £319,770. This assumed a 2% price increase from the previous year together with a reduction in production volume of 5%. However, production volume remains static and the price increase is 3%.
Calculate the raw material cost forecast..... ??
Calculate the raw material cost forecast..... ??
0
Comments
-
Not sure where I am going wrong... 319770 x 100/102 = 313,500
313,500 x3%= 9405 3+3500 = 322,905. Yet answer is 339,900?0 -
Ok so you do 319770/102*100=313500, 313500/95*100=330000,330000*3/100=9900,330000+9900=339900 #bingo0
-
Hi
I think it's the way it is worded.
I agree with the first part of your caclualtion 319770 x 100 / 102 = 313500.
As this figure incorporates a reduction in production of 5% I would do this: 313500 / 95 x 100 = 330000
Now add the 3% price increase: 330000 + 9900 = 339900
Hope this helps0 -
Thanks for your explanation. that 5% pulled me off track0
-
Wabisabi look at the timing difference between my post and yours1
-
A photofinish! Great minds think alike0
-
My man0
-
need help fort the different ways to calculate the percentage for example
we have 450 and 10% you will see 450x100/90 another time you will see direct multiplication of 450x10% another time you will see 450x10/90 and so on and so forth and other many ways please I need explanations of when to use each one.
0 -
Hi Maereg
One way to explain it would be to compare it to a VAT calculation. If you have a price of £24 that includes VAT and you want to calculate the price net of VAT you would divide £24 by 120 (because that price represents 100% + the 20% VAT) then multiply by 100.
If you are given a budget in which is has been assumed there will be an increase of 3%, then you know that the figure has to be divided by 103 and multiplied by 100 to get back to the pre increase cost. Or if the budgeted amount assumed a decrease of 5% you would divide by what you've got (ie 95% of the original amount) and multiply by what you want to get (100%)
On the other hand if you are given a number and just need to calculate a percentage just divide by 100 and multiply by the percent you want to calculate.
(It's the same principal as using index numbers - divide by what you've got and multiply by the amount you want to get.)
This is how I understand it - hope it helps.
1 -
Thanks
0
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