• 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
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

ACCA December 2022 Exam results:
* Pass rates * Comments * Instant Poll * Competition *

Specially for OpenTuition students: 20% off BPP Books for ACCA & CIMA exams – Get your BPP Discount Code >>

FORECAST SALES FOR THE BUDGET

Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA MA – FIA FMA › FORECAST SALES FOR THE BUDGET

  • This topic has 5 replies, 2 voices, and was last updated 7 years ago by John Moffat.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • November 14, 2015 at 11:43 am #282302
    ahmed02
    Member
    • Topics: 17
    • Replies: 15
    • ☆

    A business wishes to forecast next year’s sales for the budget.Next year is 2007.Sales are seasonal,summer and winter.
    seasonal sales for past 7 years have been as follows:

    20X4 SUMR:124 WIN:70
    20X5 SUMR:230 WIN:180
    20X6 SUMR: 310 WIN:270
    20X7 SUMR: 440 WIN:360
    20X8 SUMR: 520 WIN:470
    20X9 SUMR: 650 WIN:

    REQUIRED:
    A)Calculate trend line based on a two season moving average.
    B)Calculate the average increase in sales each season.
    C)Calculate seasonal variation in sales.
    D)Use this data to prepare a sales forecast for each season in 20Y0.

    |=Centre the moving average(Trend) from 20X4 -20X8 is: 123.5/177.5/225.0/267.5/322.5/377.5/420.0/467.5/527.5
    |=The average increase in sales each season in the trend line is:
    (527.5 -123.5) / 8= 50.5 each seasoon

    My curiosity are:
    1.There is only 6 years given not 7 years!
    2.Why there is no calculation of winter 20×8 and summer 20×9 trend?
    3. Why 123.5 substruct from 527.5? and can’t understand the calculation of 8 season!

    Thank You.

    November 14, 2015 at 2:08 pm #282325
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 51532
    • ☆☆☆☆☆

    I have no idea where you found this question, and therefore I cannot help you with your question 1 – assuming you have copied the question correctly, it would seem they have made a mistake!

    For the same reason, I cannot help with your second question.

    As far as your third question is concerned, from 123.5 to 177.5 is one increase; from 177.5 to 225.0 is a second increase, and so on. If you carry on counting then you will find that there are 7 increases.

    November 15, 2015 at 12:58 pm #282540
    ahmed02
    Member
    • Topics: 17
    • Replies: 15
    • ☆

    I FOUND THE QUESTION FROM KAPLAN 2014-15. If this is not correct then please tell me how will be the ques??
    and
    thank you to make me understand about the increase but i think there is 8 increase!

    Thank You.

    November 15, 2015 at 5:52 pm #282600
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 51532
    • ☆☆☆☆☆

    I do not have the Kaplan kit and so I cannot help you on that.

    With regard to you other question, you are correct – there are 8 increases (I am really sorry – I mistyped before by accident). Because there are 8 increases and the total difference between the first and the last is 527.5 – 123.5, they have divided by 8 in order to get the average increase per season.

    I apologise for confusing you with the mistyping 🙁

    November 16, 2015 at 11:51 am #282816
    ahmed02
    Member
    • Topics: 17
    • Replies: 15
    • ☆

    Its okay. And thank you ver much!

    November 16, 2015 at 7:57 pm #283111
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 51532
    • ☆☆☆☆☆

    You are welcome 🙂

  • 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

ACCA News:

 

ACCA My Exam Performance for non-variant Applied Skills exams is available NOW

NEW! Download the ACCA Pass Guide

FREE Verifiable CPD for ACCA Members

ACCA mock exams and debrief videos

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

Subscribe to ACCA’s Student Accountant Direct

Donate

If you have benefited from OpenTuition please donate.

ACCA CBE 2023 Exams

Instant Poll * How was your exam, and what was the result?

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

Specially for OpenTuition students

20% off BPP Books

Get BPP Discount Code

Latest comments

  • John Moffat on Capital asset pricing model (part b) – ACCA Financial Management (FM)
  • John Moffat on Capital asset pricing model (part b) – ACCA Financial Management (FM)
  • palbu on Basic group structures – Impairment – ACCA (SBR) lectures
  • AkilaShaikh on Capital asset pricing model (part b) – ACCA Financial Management (FM)
  • AkilaShaikh on Capital asset pricing model (part b) – ACCA Financial Management (FM)

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


We use cookies to show you relevant advertising, find out more: Privacy Policy · Cookie Policy