Hudson Marine provides boats sales, service, and maintenance. Boat trailers are one of its top sales items. Suppose the quarterly sales values for the seven years of historical data are as follows. Do not round intermediate calculations. Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Yearly Sales 1 7 17 9 2 35 2 9 19 17 8 53 3 13 28 23 12 76 4 18 27 23 17 85 5 23 32 30 20 105 6 23 38 31 19 111 7 26 41 33 28 128 a. Compute the centered moving average values (first find Four-Quarter Moving Average) for this time series (to 3 decimals). Centered Moving Sales Average 1 6 t N 16 3 11 4 3 5 10 6 6 16 7 17 8 6 9 12 10 28 11 21 12 12 13 20 14 28 15 23 16 16 17 20 18 35 19 30 20 19 21 25 22 37 23 30 24 20 25 30 26 41 27 34 28 27
b. Compute the seasonal indexes for the four quarters (to 3 decimals). Quarter Adjusted Seasonal Index 1 2 3 4
c. When does Hudson Marine experience the largest seasonal effect? Hudson Marine experiences the largest seasonal increase in quarter The largest seasonal effect is the seasonal decrease in quarter