Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Carl Warren, William B. Tayler

15th edition

1337912026, 978-1337912020

More Books

Students also viewed these Accounting questions

Question

What are the three categories of time? (p. 291)

Answered: 1 week ago

Question

Purpose: What do we seek to achieve with our behaviour?

Answered: 1 week ago

Question

An action plan is prepared.

Answered: 1 week ago