Consider the following monthly observations for 5 years. Click here for the Exce
ID: 3223630 • Letter: C
Question
Consider the following monthly observations for 5 years.
Click here for the Excel Data File
Calculate the 12-month centered moving average. (Do not round intermediate calculations. Round your answers to 2 decimal places.)
Calculate the ratio-to-moving average. (Do not round intermediate calculations. Round your answers to 2 decimal places.)
Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Calculate the seasonal indices for April and November. (Do not round intermediate calculations. Round your answers to 4 decimal places.)
Interpret the seasonal indices for April. (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Interpret the seasonal indices for November. (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Explanation / Answer
Sales index for April is 0.918291 which is 91.82% of the normal i.e. 8.18% below normal.
Sales index for November is 1.085067 which is 108.51% of the normal i.e. 8.51% above normal.
Year Month Sales MA CMA Ratio Avg_Ratio SI 1 1 16 1.249859 1 2 23 0.826226 1 3 13 0.883892 1 4 10 0.918291 1 5 23 0.948293 1 6 28 1.111197 1 7 37 0.848563 1 8 36 0.82638 1 9 24 1.173692 1 10 23 0.757341 1 11 27 24.25 24.54167 1.10017 1.085067 1 12 31 24.83333 24.45833 1.267462 1.371199 2 1 23 24.08333 24.16667 0.951724 1.226132 1.249859 2 2 14 24.25 25 0.56 0.810541 0.826226 2 3 15 25.75 25.45833 0.589198 0.867112 0.883892 2 4 28 25.16667 24.91667 1.123746 0.900858 0.918291 2 5 16 24.66667 23.58333 0.678445 0.930291 0.948293 2 6 22 22.5 21.91667 1.003802 1.090102 1.111197 2 7 11 21.33333 21.41667 0.513619 0.832454 0.848563 2 8 22 21.5 21.20833 1.037328 0.810692 0.82638 2 9 26 20.91667 20.33333 1.278689 1.151411 1.173692 2 10 16 19.75 20.04167 0.798337 0.742964 0.757341 2 11 13 20.33333 20.54167 0.63286 1.064469 1.085067 2 12 38 20.75 21.41667 1.774319 1.345168 1.371199 3 1 28 22.08333 22.375 1.251397 1.249859 3 2 30 22.66667 22.41667 1.33829 0.826226 3 3 22 22.16667 22.91667 0.96 0.883892 3 4 22 23.66667 23.91667 0.919861 0.918291 3 5 34 24.16667 24.16667 1.406897 0.948293 3 6 28 24.16667 23.79167 1.176883 1.111197 3 7 11 23.41667 22.95833 0.479129 0.848563 3 8 13 22.5 22.625 0.574586 0.82638 3 9 15 22.75 23.25 0.645161 1.173692 3 10 19 23.75 23.375 0.812834 0.757341 3 11 25 23 23.33333 1.071429 1.085067 3 12 29 23.66667 22.95833 1.263158 1.371199 4 1 36 22.25 21.91667 1.642586 1.249859 4 2 13 21.58333 21.08333 0.616601 0.826226 4 3 14 20.58333 20 0.7 0.883892 4 4 10 19.41667 19.75 0.506329 0.918291 4 5 20 20.08333 21.25 0.941176 0.948293 4 6 36 22.41667 23.16667 1.553957 1.111197 4 7 39 23.91667 24.875 1.567839 0.848563 4 8 31 25.83333 25.875 1.198068 0.82638 4 9 38 25.91667 26.5 1.433962 1.173692 4 10 20 27.08333 27.08333 0.738462 0.757341 4 11 39 27.08333 26.83333 1.453416 1.085067 4 12 29 26.58333 26.95833 1.075734 1.371199 5 1 30 27.33333 28.33333 1.058824 1.249859 5 2 22 29.33333 30.25 0.727273 0.826226 5 3 38 31.16667 31.16667 1.219251 0.883892 5 4 32 31.16667 30.375 1.053498 0.918291 5 5 20 29.58333 28.79167 0.694645 0.948293 5 6 17 28 27.16667 0.625767 1.111197 5 7 20 26.33333 26 0.769231 0.848563 5 8 11 25.66667 25.41667 0.432787 0.82638 5 9 30 25.16667 24.04167 1.247834 1.173692 5 10 14 22.91667 22.5 0.622222 0.757341 5 11 12 22.08333 1.085067 5 12 19 1.371199Sales index for April is 0.918291 which is 91.82% of the normal i.e. 8.18% below normal.
Sales index for November is 1.085067 which is 108.51% of the normal i.e. 8.51% above normal.