$($Note$,$ you have already done the step $1)$ by answering sub$-$question $c)$ and please put

those values into the table. You can copy the form to your answer sheet then fill blank

cells$).$A company has collected quarterly sales for the past two years which are shown in the

following table. The company wants to forecast the next year's seasonal sales.

a$)$ Let $A_1$ and $A_2$ be the actual total sales $($i$.$e$.,$ the sum of all four seasonal sales$)$ in $2022$

and $2023,$ respectively. Assume current time is $t,$ the $n-$moving average $($MV$)$ technique

makes forecast for the time $t+1$ by taking the average of previous $n$ actual values where

$nt.($The formula can be written as $F_{t+1}=\frac{{\displaystyle \underset{i=t-n+1}{\overset{t}{}}}{A}_i}{n}$ where $A_i$ is the $i-$th actual data$).$

Predict the total sales for $2024$ using MV with $2$ actual values $A_1$ and $A_2.$

b$)$ In general, we would expect the total sales gets increased in both $2023$ and $2024$ as

the economy situation has been keeping going well since $2021.$ Use this and your

answer to sub$-$question a$)$ to explain the limitation of moving average $($MV$)$ method in

forecasting.

c$)$ Calculate the average seasonal sales for both $2022$ and $2023.$

d$)$ Here are the steps of forecasting with seasonality. Please follow the steps to fill out

the blank cells in the following form.

Calculate the average seasonal sales for each year;

Calculate each seasonal index $($by dividing the actual seasonal sales by the

average seasonal sales$)$;

Compute the average indexes;

Predict the average seasonal sales for year $2024$ using any forecasting method of $4.$your choice.

Multiple next year$$s average seasonal sales by each average seasonal index.