Unit 8/9 help
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.5K For AAT students
- 325 NEW! Qualifications 2022
- 160 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 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
- 274 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 202 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