Question
The manager of a company is preparing revenue plans for the last quarter of 2018/2019 and for the first three quarters of 2019/2020.The data below
The manager of a company is preparing revenue plans for the last quarter of 2018/2019 and for the first three quarters of 2019/2020.The data below refer to one of the main products:
Revenue April-June July-Sept Oct-Dec Jan-March
Quarter 1 Quarter 2 Quarter 3 Quarter 4
'000 '000 '000 '000 '000
2015/2016 49 37 58 67
2016/2017 50 38 59 68
2017/2018 51 40 60 70
2018/2019 50 42 61 -
Required:
a)Calculate the four-quarterly moving average trend for this set of data.
b)Calculate the seasonal factors using either the additive model or the multiplicative model, but not both.
c) Explain, but do not calculate how you would use the results in parts (a) and(b) of this question to forecast the revenue for the last quarter of 2018/2019and for the first three quarters of 2019/2020.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started