Unit 8/9 help
Options
Terdoo
Registered Posts: 144 Dedicated contributor 🦉
A computer program has used a linear regression to analysis, using quarter number 30 is the first quarter of yr 2000) the sales trend has being detemine as
Sales Trend (in£) = (Quarter Number * £1200) + £83000
and here they have quarter 1, 2, 3, & 4, using the data calculate the forcast of sales in £s for each quarter 2003.
How do they know that quarter 2003 is 42 and the next quarter is 43? how do you calculate the quarter to come to this?
Could someone help with an explained answer please?
Thanks in advance
Sales Trend (in£) = (Quarter Number * £1200) + £83000
and here they have quarter 1, 2, 3, & 4, using the data calculate the forcast of sales in £s for each quarter 2003.
How do they know that quarter 2003 is 42 and the next quarter is 43? how do you calculate the quarter to come to this?
Could someone help with an explained answer please?
Thanks in advance
0
Comments

Year/Quarter......2000/1...2000/2..2000/3.2000/4..2001/1......2002/1.....2003/1...2003/2..2003/3.2003/4
Quarter No.............30.......31........32.......33........34..............38........42..........43.........44........45
Sales
Trend..............(30 x £1,200)
......................+ £83,000
....................£119,000
Sandy
sandy@sandyhood.com
www.sandyhood.com0 
Re unit 8/9
Thanks for the quick reply. Sandyhood, could you pls help with this,
Average seasonal variation in turnover were:
Q1 Q2 Q3 Q4
2005 28 3 21 +53
2006 31 0 22 +52
Total 59 3 43 +10
Average 29.5
How do you calculate the average?
thanks in advance0 
59/2 = 29.5
2 years worth of data, so add the two values together and divide by 2Sandy
sandy@sandyhood.com
www.sandyhood.com0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.4K For AAT students
 278 NEW! Qualifications 2022
 148 General Qualifications 2022 discussion
 9 AAT Level 2 Certificate in Accounting
 50 AAT Level 3 Diploma in Accounting
 70 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 270 VAT
 91 Software
 271 Tax
 134 Bookkeeping
 7.1K General accounting discussion
 198 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 580 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