Hudson Marine provides boats sales, service, and maintenance. Boat trailers are one of its top sales items. Suppose the
Posted: Wed May 04, 2022 12:57 pm
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. Total Yearly Quarter 1 Quarter 2 Quarter 3 Quarter 4 Sales Year 1 4 16 8 5 33 2 9 18 8 52 3 16 26 13 76 4 19 27 20 92 5 21 32 19 100 6 23 37 20 112 7 27 42 27 130 17 21 26 28 32 34
a. Compute the centered moving average values (first find Four-Quarter Moving Average) for this time series (to 3 decimals). Centered Moving t Sales Average 4 16 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 8 5 9 18 17 8 16 26 21 13 19 27 26 20 21 32 28 19 23 37 32 20 27 42 34 27
c. Compute the seasonal indexes for the four quarters (to 3 decimals). Adjusted Seasonal Index Quarter 1 2 3 4 d. When does Hudson Marine experience the largest seasonal effect? Hudson Marine experiences the largest seasonal increase in quarter Does this result seem reasonable? This is also reasonable because of decreased boating in the fall and winter The largest seasonal effect is the seasonal decrease in quarter +
a. Compute the centered moving average values (first find Four-Quarter Moving Average) for this time series (to 3 decimals). Centered Moving t Sales Average 4 16 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 8 5 9 18 17 8 16 26 21 13 19 27 26 20 21 32 28 19 23 37 32 20 27 42 34 27
c. Compute the seasonal indexes for the four quarters (to 3 decimals). Adjusted Seasonal Index Quarter 1 2 3 4 d. When does Hudson Marine experience the largest seasonal effect? Hudson Marine experiences the largest seasonal increase in quarter Does this result seem reasonable? This is also reasonable because of decreased boating in the fall and winter The largest seasonal effect is the seasonal decrease in quarter +