Home For AAT student members AQ 2013 AAT Level 4 (Level 8 in Scotland)
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Unit 8/9 help

TerdooTerdoo Well-KnownRegistered Posts: 144
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

Comments

  • SandyHoodSandyHood Font Of All Knowledge Registered, Moderator Posts: 2,034
    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
    [email protected]
    www.sandyhood.com
  • TerdooTerdoo Well-Known Registered Posts: 144
    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
  • SandyHoodSandyHood Font Of All Knowledge Registered, Moderator Posts: 2,034
    59/2 = 29.5

    2 years worth of data, so add the two values together and divide by 2
    Sandy
    [email protected]
    www.sandyhood.com
Sign In or Register to comment.