Unit 8/9 help

Terdoo · February 2010

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

SandyHood · February 2010

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

Terdoo · February 2010

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 advance

SandyHood · February 2010

59/2 = 29.5

2 years worth of data, so add the two values together and divide by 2

Unit 8/9 help

Comments

Categories