ALAW Ltd has experienced a growth in its product markets over the last three years and is concerned about its capacity to deal with the increasing number of orders it is receiving. In order to better...

Plot the sales revenue figures and appropriate trend line on a graph and identify from this the choice of model for working out the seasonal component.

Using the appropriate seasonal model, complete the calculations that are required to produce the required forecasts for quarters 1, 2, 3 and 4 of 2021.

On the basis of your analysis explain the recommendation that you would make to ALAW Ltd regarding its future plans.

Extracted text: ALAW Ltd has experienced a growth in its product markets over the last three years and is concerned about its capacity to deal with the increasing number of orders it is receiving. In order to better understand future patterns of demand for their products and devise an appropriate strategy the owners have asked you to analyse past trends and prepare forecasts for the following year. Quarterly data on their sales revenue between 2018 and 2020 are presented below. Sales Revenue (£000's) Q1 Q2 Q3 Q4 2018 24 86 44 26 2019 108 272 122 66 2020 234 600 240 184