• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Ask AI
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for March and June 2025 exams.
Get your discount code >>

Time series

Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA MA – FIA FMA › Time series

  • This topic has 5 replies, 2 voices, and was last updated 5 years ago by John Moffat.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • September 7, 2019 at 7:36 am #545397
    iza1
    Participant
    • Topics: 115
    • Replies: 112
    • ☆☆☆

    The trend of a product has been calculated as a decrease in sales of 2 units/quarter
    and seasonal variation of Q4 = -15
    Sales for Q4 2017 is 320 units
    using additive model what is predicted sales for Q4 2018 ?

    320 + (- 2* 4 quarter) + (-15) = 297 units
    but answer says 312

    September 7, 2019 at 9:20 am #545413
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54655
    • ☆☆☆☆☆

    If you have typed it all out correctly then it seems that the answer is 297 units.

    Does the answer in your book not show the workings also?

    September 7, 2019 at 9:59 am #545421
    iza1
    Participant
    • Topics: 115
    • Replies: 112
    • ☆☆☆

    320- 15 + (- 2* 4 quarter) + (-15) = 312 units

    this is the working

    September 7, 2019 at 3:29 pm #545470
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54655
    • ☆☆☆☆☆

    My mistake – the answer is correct.

    If the actual sales in Q4 2017 were 320, then because there is a seasonal variation of -15, the trend would be 320 + 15 = 335.

    Therefore for Q4 2018, the forecast is 335 – (4×2) – 15 = 312

    September 8, 2019 at 6:40 am #545528
    iza1
    Participant
    • Topics: 115
    • Replies: 112
    • ☆☆☆

    but that seasonal variation is what we are adjusting at the end isnt it ? why adjust it twice ?

    September 8, 2019 at 9:13 am #545539
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54655
    • ☆☆☆☆☆

    The seasonal variation will occur in every Q4. So the actual sales in 2017 will include the effect of the seasonal variation.

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.
Log In

Primary Sidebar

Donate
If you have benefited from our materials, please donate

ACCA News:

ACCA My Exam Performance for non-variant

Applied Skills exams is available NOW

ACCA Options:  “Read the Mind of the Marker” articles

Subscribe to ACCA’s Student Accountant Direct

ACCA CBE 2025 Exams

How was your exam, and what was the exam result?

BT CBE exam was.. | MA CBE exam was..
FA CBE exam was.. | LW CBE exam was..

Donate

If you have benefited from OpenTuition please donate.

PQ Magazine

Latest Comments

  • singhjyoti on Conceptual Framework – ACCA SBR lecture
  • John Moffat on Time Series Analysis – ACCA Management Accounting (MA)
  • azubair on Time Series Analysis – ACCA Management Accounting (MA)
  • Gowri7 on Relevant cash flows for DCF Working capital (examples 2 and 3) – ACCA Financial Management (FM)
  • Govere on The use of ratios and comparisons in auditing

Copyright © 2025 · Support · Contact · Advertising · OpenLicense · About · Sitemap · Comments · Log in