Help with trend % calculation please
katiekitkat123
Registered Posts: 23 New contributor 🐸
Hi all I'm having trouble working out the % trend on this question, help please
The table below contains information about the last three months cost per kilogram for product Exe.
Complete the blank cells to show details of the trend.
Show all figures in whole numbers.
Month August September October
Actual Cost .........£165 £159 £145
Seasonal Variation+£15 +£6 -£11
Trend
Monthly increase in trend
Percentage increase in trend
between August and October%
The table below contains information about the last three months cost per kilogram for product Exe.
Complete the blank cells to show details of the trend.
Show all figures in whole numbers.
Month August September October
Actual Cost .........£165 £159 £145
Seasonal Variation+£15 +£6 -£11
Trend
Monthly increase in trend
Percentage increase in trend
between August and October%
0
Comments
-
Hello
if you have the Seasonal variation, then do the opposite from the info so:
August £165-£15=£150
September £159-6=£153
October £145+£11=156
Trend increase is £3 per month
if you have the trend and need the seasonal variation, do the same as shown (if+ then +)
the % increase is 156/153=1.0196 or 101.96%/1.96%0 -
Yes Diddy is right with trend = 150 for august 153 for september and 156 for october
The trend increase is yep £3 per month.
However to work out the %increase we have to do difference in trend/ original then * 100
so the difference = 6/divided by original trend which is 150 for august then * 100 which = 4%AAT
Level 2 - 2010
Level 3 - 2011
Level 4 - 2013
ACCA
F4 - 2015
F5 - 20150
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