QUESTION $4(20$ Marks$)$

Study the information provided below and answer the following questions.

INFORMATION

Radasys Digicommerce Inc. $($RDI$)$ is an e$-$commerce enterprise specialising in consumer electronics. Presently, the

sales department at RDI utilises the Three$-$Quarter$-$Moving$-$Average Method $(3$QMAM$)$ to forecast demand for one of its

flagship products, an AI$-$driven gadget. The newly appointed Chief Demand Planner at RDI, tasked with driving innovation

and enhancing forecasting accuracy, suspects that regression modelling may offer a superior alternative. Consequently,

he plans to conduct a comparative analysis to assess the relative forecasting accuracy between the $3$QMAM and

regression analysis methodologies.

As an operations analyst at RDI, you have been assigned this task. The following sales data for the gadget is available:

Year Quarter Sales $($units$)$

$2020$ Q$11800$

Q$22100$

Q$31400$

Q$42500$

$2021$ Q$11300$

Q$21500$

Q$31200$

Q$42000$

$2022$ Q$11600$

Q$21800$

Q$31100$

Q$42200$

$2023$ Q$12000$

Q$22300$

Q$31600$

Q$43000$

REQUIRED:

$4\mathrm{.}1.$ Using the $3$QMAM, calculate the gadget$$s quarterly sales forecasts for the period $2020$Q$4$ to $2024$Q$1.(4$ marks$)$

$4\mathrm{.}2.$ Conduct a simple regression analysis to determine the trend equation of the sales and use it to

estimate the number of units of the gadget expected to be sold throughout the fiscal year $2024.$ Assume

that Q$1$ of $2020$ is $1,$ Q$2$ of $2020$ is $2,$ etc. Present all details of the calculations.

$(8$ marks$)$

$4\mathrm{.}3.$ Evaluate the relative forecasting accuracies of the $3$QMAM and the regression analysis for the period

from $2020$Q$4$ to $2023$Q$4$ using the Mean Absolute Percentage Error $($MAPE$)$ method.

$(4$ marks$)$

$4\mathrm{.}4.$ Summarise the findings derived from the assessment conducted in $4\mathrm{.}3.(4$ marks$)$