Question: a . Evaluate a seasonally adjusted trend forecasting model. Note: Round all of your answers to ( mathbf { 3 } )

a. Evaluate a seasonally adjusted trend forecasting model.
Note: Round all of your answers to \(\mathbf{3}\) decimal places except "Absolute Percent Error" which should be rounded to 2 decimals.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|}
\hline Period & Month-Year & Month & \begin{tabular}{l}
Sales \\
(\$ Million)
\end{tabular} & Trend & Index & Forecast & Absolute Error & Absolute Percent Error & \\
\hline 1 & Jan-2020 & 1 & 58,722 & 0.000 & 0.000 & & & & \%\\
\hline 2 & Feb-2020 & 2 & 55,870 & & & & & & \%\\
\hline 3 & Mar-2020 & 3 & 73,901 & & & & & & \%\\
\hline 4 & Apr-2020 & 4 & 64,383 & & & & & & \%\\
\hline 5 & May-2020 & 5 & 68,436 & & & & & & \%\\
\hline 6 & Jun-2020 & 6 & 63,973 & & & & & & \%\\
\hline 7 & Jul-2020 & 7 & 66,892 & & & & & & \%\\
\hline 8 & Aug-2020 & 8 & 64,500 & & & & & & \%\\
\hline 9 & Sep-2020 & 9 & 62,100 & & & & & & \%\\
\hline 10 & Oct-2020 & 10 & 64,017 & & & & & & \%\\
\hline 11 & Nov-2020 & 11 & 63,920 & & & & & & \%\\
\hline 12 & Dec-2020 & 12 & 67,027 & & & & & & \%\\
\hline 13 & Jan-2021 & 1 & 64,785 & & & & & & \%\\
\hline 14 & Feb-2021 & 2 & 59,018 & & & & & & \%\\
\hline 15 & Mar-2021 & 3 & 64,734 & & & & & & \%\\
\hline 16 & Apr-2021 & 4 & 63,749 & & & & & & \%\\
\hline 17 & May-2021 & 5 & 68,015 & & & & & & \%\\
\hline 18 & Jun-2021 & 6 & 66,531 & & & & & & \%\\
\hline 19 & Jul-2021 & 7 & 68,923 & & & & & & \%\\
\hline 20 & Aug-2021 & 8 & 68,259 & & & & & & \%\\
\hline 21 & Sep-2021 & 9 & 66,939 & & & & & & \%\\
\hline 22 & Oct-2021 & 10 & 69,523 & & & & & & \%\\
\hline 23 & Nov-2021 & 11 & 68,948 & & & & & & \%\\
\hline 24 & Dec-2021 & 12 & 73,617 & & & & & & \%\\
\hline
\end{tabular}. What are the MAD and MAPE?
Note: Round your answers to 2 decimal places.
What are the monthly indexes?
Note: Round your answers to 4 decimal places. d. Forecast sales for January, February, March, and April of 2022. Note: Round your answers to 3 decimal places.
a . Evaluate a seasonally adjusted trend

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!